ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
<transaction username="mobileuser" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>mobileuser</username><password>827ccb0eea8a706c4c34a16891f84e7b</password><seed></seed><s></s><transid>tpcdr</transid><recordid>0</recordid><recdata></recdata><data transid="tpcdr" recordid="0"><axp_recid1 rowno="001">0</axp_recid1><appeal_zoneid rowno="001">10004</appeal_zoneid><applicant_type rowno="001">Others</applicant_type><firm_type rowno="001">Individual</firm_type><f_c_name rowno="001">W O Bhagchand Bhambi</f_c_name><address rowno="001">C/O Maksud Javed Khan, resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,</address><city rowno="001">JAIPUR</city><pin rowno="001">303602</pin><mcaseno rowno="001">0</mcaseno><submission_date rowno="001">04/06/2025</submission_date><order_issued_offid rowno="001">304</order_issued_offid><order_issued_off rowno="001">ME,Bijoliyan</order_issued_off><appeal_against_orderno rowno="001">??. /????/????./?????-2/ ?-309</appeal_against_orderno><order_date rowno="001">28/02/2025</order_date><appeal_against_off rowno="001"></appeal_against_off><case_decision_date rowno="001"></case_decision_date><case_purpose_name rowno="001">Others</case_purpose_name><appeal_reason rowno="001"></appeal_reason><axp_recid2 rowno="001">0</axp_recid2><app_name rowno="001">SHANTI DEVI</app_name><app_fname rowno="001">W O Bhagchand Bhambi</app_fname><app_city rowno="001">JAIPUR</app_city><app_pincode rowno="001">303602</app_pincode><app_address rowno="001">C/O Maksud Javed Khan, resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,</app_address><app_powerofatt rowno="001">No</app_powerofatt><power_name rowno="001">Maksud Javed Khan</power_name><power_fname rowno="001">ABDUL WAJID KHAN</power_fname><power_city rowno="001">JAIPUR</power_city><power_pincode rowno="001">302021</power_pincode><power_add rowno="001">Resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,</power_add><axp_recid3 rowno="001">0</axp_recid3><zoneid rowno="001">Udaipur</zoneid><smeoffice rowno="001">Bhilwara </smeoffice><meoffice rowno="001">ME,Bijoliyan</meoffice><leasetype rowno="001"></leasetype><mineraltype rowno="001"></mineraltype><lease_no rowno="001">Select</lease_no><lease_holder_name rowno="001">NA</lease_holder_name><lease_fname rowno="001"></lease_fname><lease_add rowno="001">N/V JALERI, TEHSIL- BIJOLIYA, DIST-BHILWARA</lease_add><lease_city rowno="001">BIJOLIYA</lease_city><lease_pincode rowno="001">311602</lease_pincode><axp_recid5 rowno="001">0</axp_recid5><appeal_against_ofcid rowno="001">ME,Bijoliyan</appeal_against_ofcid><personname rowno="001"></personname></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"mobileuser","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"tpcdr","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"appeal_zoneid":"10004","applicant_type":"Others","firm_type":"Individual","f_c_name":"W O Bhagchand Bhambi","address":"C/O Maksud Javed Khan, resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,","city":"JAIPUR","pin":"303602","mcaseno":"0","submission_date":"04/06/2025","order_issued_offid":"304","order_issued_off":"ME,Bijoliyan","appeal_against_orderno":"??. /????/????./?????-2/ ?-309","order_date":"28/02/2025","appeal_against_off":"","case_decision_date":"","case_purpose_name":"Others","appeal_reason":""}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"app_name":"SHANTI DEVI","app_fname":"W O Bhagchand Bhambi","app_city":"JAIPUR","app_pincode":"303602","app_address":"C/O Maksud Javed Khan, resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,","app_powerofatt":"No","power_name":"Maksud Javed Khan","power_fname":"ABDUL WAJID KHAN","power_city":"JAIPUR","power_pincode":"302021","power_add":"Resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,"}}]},{"axp_recid3":[{"rowno":"001","text":"0","columns":{"zoneid":"Udaipur","smeoffice":"Bhilwara ","meoffice":"ME,Bijoliyan","leasetype":"","mineraltype":"","lease_no":"Select","lease_holder_name":"NA","lease_fname":"","lease_add":"N/V JALERI, TEHSIL- BIJOLIYA, DIST-BHILWARA","lease_city":"BIJOLIYA","lease_pincode":"311602"}}]},{"axp_recid4":[]},{"axp_recid5":[{"rowno":"001","text":"0","columns":{"appeal_against_ofcid":"ME,Bijoliyan","personname":""}}]}]}}
Verifying username and password
User Name : mobileuser
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=mobileuser
Time elapsed = 18
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 10
Result : 
Verifying completed...
Page Access Category : 
User Name : mobileuser
Select sysdate as sdt from dual
Time elapsed = 5
dt=04/06/2025 14:22:45
Select sysdate as sdt from dual
Time elapsed = 6
Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null))
U=mobileuser
dt=04/06/2025 14:22:45
dt=04/06/2025 14:22:45
Time elapsed = 12
User Groups: mobileuser
select userroles from axusergroups where groupname in ( 'mobileuser' )
Time elapsed = 6
User Roles : mobileuser
Loading App/User vars
reading the props xml
Step3
Sql : select props from axprops where lower(name)= :name  order by blobno

Paramval : app
ParamTYpe : c
Param List : name

select props from axprops where lower(name)= :name  order by blobno

Time elapsed = 4
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="06/12/2024 17:18:50" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="738"><app color="$00EBF5F4" font="Tahoma,8"/><head font="Tahoma,12,tfff" color="$00DDE8E7"/><gridhead color="$00FFE8E8" font=""/><gridrow oddrowcolor="$00FEFCFA" evenrowcolor="$00FEF3ED"></gridrow><imgsfolder>images\</imgsfolder><container color="$00E8F1F0"/><name fontname="" fontsize="" fontbold="" fontitalic="" fontunderline="" fontcolor="" fontstrikeout="">Generalized Court Management System</name><img></img><envvar><currency>INR</currency><millions>F</millions><siteno></siteno><oraerrfrom>500</oraerrfrom><oraerrto>250000</oraerrto><postauto>F</postauto><finyrst></finyrst><finyred></finyred><cursep></cursep></envvar><currencies><INR></INR></currencies><appvars><m_courtname value="" param="f" hidden="false"><l>firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtname := sqlget({m2},{court_name})</l></m_courtname><m_courttype value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})</l><l>m_courttype := sqlget({m3},{court_type})</l></m_courttype><m_courtid value="" param="f" hidden="false"><l>firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})</l><l>m_courtid := sqlget({m4},{court_name_mastid})</l></m_courtid><login_userid value="" param="f" hidden="false"><l>firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})</l><l>login_userid := sqlget({m4},{axusersid})</l></login_userid><u_name value="" param="f" hidden="false"><l>firesql({m4},{select :username as uname from dual})</l><l>u_name := sqlget({m4},{uname})</l></u_name><m_courtcode value="" param="f" hidden="false"><l>firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtcode := sqlget({m4},{COURT_CODE})</l></m_courtcode><m_statename value="" param="f" hidden="false"><l>firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})</l><l>m_statename := sqlget({m2},{STATE_NAME})</l></m_statename><m_distname value="" param="f" hidden="false"><l>firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_distName := sqlget({m7},{DISTNAMEENG})</l></m_distname><m_courtcatid value="" param="f" hidden="false"><l>firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_courtcatid := sqlget({m8},{COURT_CATEGOTY})</l></m_courtcatid><m_deptid value="" param="f" hidden="false"><l>firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})</l><l>m_deptid := sqlget({m4},{department_mastid})</l></m_deptid><m_courttypeid value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})</l><l>m_courttypeid := sqlget({m3},{court_type_mastid})</l></m_courttypeid><urole value="" param="f" hidden="false"><l>firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })</l><l>urole := sqlget({m4},{groupname})</l></urole><m_cutoffdt value="" param="f" hidden="false"><l>firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})</l><l>m_cutoffdt := sqlget({a1},{dd})</l></m_cutoffdt><m_offcount value="" param="f" hidden="false"><l>firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})</l><l>m_offcount := sqlget({P1},{ct})</l></m_offcount></appvars><readonlyprops readonly_fontcolor="clBlack" readonly_bgcolor="clWindow"/><gfont/><mail><host></host><port></port><userid></userid><password></password></mail><pwdsetting><maxlogintry>0</maxlogintry><pwdexpdays>0</pwdexpdays><pwdalertdays>0</pwdalertdays><pwdminchars>0</pwdminchars><pwdprevnos>0</pwdprevnos><ispwdalphanum>F</ispwdalphanum></pwdsetting></props></root>
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
   Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
   Calling function firesql
username=mobileuser
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=mobileuser
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{court_name})
   Calling function sqlget
   Result of sqlget = ??????????? ???????? ????????? ???? ????? (AB-MGRSBY),HO
   Result = ??????????? ???????? ????????? ???? ????? (AB-MGRSBY),HO
   Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
   Calling function firesql
username=mobileuser
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=mobileuser
Time elapsed = 8
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = AB-MGRSBY
   Result = AB-MGRSBY
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=mobileuser
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=mobileuser
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 1245660000858
   Result = 1245660000858
   Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
   Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=mobileuser
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 11748000000124
   Result = 11748000000124
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=mobileuser
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = mobileuser
   Result = mobileuser
   Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
   Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=mobileuser
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10001
   Result = 10001
   Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
   Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{STATE_NAME})
   Calling function sqlget
   Result of sqlget = ????????
   Result = ????????
   Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=mobileuser
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=mobileuser
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Na
   Result = Na
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=mobileuser
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=mobileuser
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m8},{COURT_CATEGOTY})
   Calling function sqlget
   Result of sqlget = 1319880000000
   Result = 1319880000000
   Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
   Calling function firesql
login_userid=11748000000124
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=11748000000124
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{department_mastid})
   Calling function sqlget
   Result of sqlget = 
   Result = 
   Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
   Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=mobileuser
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 1245550000689
   Result = 1245550000689
   Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
   Calling function firesql
username=mobileuser
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=mobileuser
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{groupname})
   Calling function sqlget
   Result of sqlget = 
   Result = 
   Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
   Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({a1},{dd})
   Calling function sqlget
   Result of sqlget = 30/01/2021
   Result = 30/01/2021
   Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
   Calling function firesql
username=mobileuser
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=mobileuser
Time elapsed = 10
   Result of firesql = 
   Result = 
   Evaluating  sqlget({P1},{ct})
   Calling function sqlget
   Result of sqlget = 0
   Result = 0
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('mobileuser') and lower(sname)='tpcdr' and stype = 't' )

Time elapsed = 4
select Props from axuseraccess where lower(rname)='mobileuser' and lower(sname)='tpcdr' and stype = 't'
Time elapsed = 7
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno

Paramval : mobileuser,tpcdr,t
ParamTYpe : ccc
Param List : rname
sname
stype

select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno

Time elapsed = 4
Reading data from stream

Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : tpcdr
ParamTYpe : c
Param List : name

select props from tstructs where lower(name)= :name  order by blobno

Time elapsed = 4
Step4
tstructs\stm size:5975
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
select lpad(' ', 250, ' ') LVAL from dual
Time elapsed = 9
select lpad(' ', 250, ' ') LVAL from dual
Time elapsed = 5
   Evaluating date()
   Result = 
   Evaluating {AND a1.court_code=:m_courtcode }
   Result = 
   Evaluating m_courtcode
   Result = 
   Evaluating date()
   Result = 
   Evaluating {Submitted}
   Result = 
   Evaluating case_no + { saved successfully action}
   Result = 
   Evaluating {No}
   Result = 
   Evaluating {No}
   Result = 
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tpcdr
adxinout=o
Time elapsed = 5
select * from trn_dmg_casereg where trn_dmg_caseregid=0
Time elapsed = 9
select * from Axusers where 1=2
Time elapsed = 7
select distinct(fldname) from AxTempUserFields
Time elapsed = 3
select * from AxAttachWorkflow where lower(transid) = 'tpcdr'
Time elapsed = 6
Loading genmaps
Creating Action object
Submitting data to dbcall
Submiting & Registering data 
Registering Global variables data 
Registering Global variables data over
Setting values over
DB Call Validate and save

>>Validating tpcdr

>>Frame No 1
currdate = 
Evaluating - date()
   Result of date = 04/06/2025
currdate after validation = 04/06/2025
viewfilter = 
Evaluating - {AND a1.court_code=:m_courtcode }
viewfilter after validation = AND a1.court_code=:m_courtcode 
court_name = 
court_nameid = 
appeal_zoneid = 10004
court_code = 
Evaluating - m_courtcode
   m_courtcode = 10001
court_code after validation = 10001
court_type_id = 
court_type = 
applicant_type = Others
firmtype = 
f_c_name = W O Bhagchand Bhambi
address = C/O Maksud Javed Khan, resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,
city = JAIPUR
pin = 303602
prefix = 
SELECT  TO_CHAR ( sysdate,  'YYYY')||'/' AS prefix FROM  DUAL

Time elapsed = 4
prefix after validation = 2025/
case_no = 
SELECT  SUM (NVL (cnt, 0)) || '/'  || EXTRACT (YEAR FROM SYSDATE)
        AS  docid
  FROM (SELECT MAX (TO_NUMBER (REGEXP_SUBSTR (s.case_no, '([^/]+)\/', 1,1, NULL,1))) cnt
          FROM trn_dmg_casereg s
         WHERE  REGEXP_SUBSTR (s.case_no, '[^/]+$') = EXTRACT (YEAR FROM SYSDATE)
                       UNION ALL
        SELECT 1 FROM DUAL)

Time elapsed = 57
S=173/2025
Select case_no from trn_dmg_casereg where lower(case_no) = :S
S=173/2025
Time elapsed = 7
case_no after validation = 173/2025
cno = 
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tpcdr'

Time elapsed = 3
Select * FROM Sequence WHERE lower(TRANSTYPE)='tpcdr' and lower(FIELDNAME)='cno'and lower(prefixfield)='case_no'
Time elapsed = 5
cno after validation = 173/2025
mcaseno = 0
hearingdate = 
submission_date = 04/06/2025
order_issued_offid = 304
order_issued_off = ME,Bijoliyan
appeal_against_orderno = ??. /????/????./?????-2/ ?-309
order_date = 28/02/2025
case_decision_date = 
decision_type = 
decisionflag = 
Evaluating - {Submitted}
decisionflag after validation = Submitted
case_purpose_name = Others
appeal_reason = 
axp_aftersavemsg = 
Evaluating - case_no + { saved successfully action}
   case_no = 173/2025
axp_aftersavemsg after validation = 173/2025 saved successfully action
applicantcheck = 
Evaluating - 
time zone difference  = 0

>>Writing to tables tpcdr
Saving to table TRN_DMG_CASEREG
select * from TRN_DMG_CASEREG where  TRN_DMG_CASEREGid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15617000011207
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10001
court_name = 
appeal_reason = 
case_decision_date = 
case_purpose_name = Others
viewfilter = AND a1.court_code=:m_courtcode 
decision_type = 
hearingdate = 
decisionflag = Submitted
firmtype = 
case_no = 173/2025
order_date = 28/02/2025
applicant_type = Others
appeal_zoneid = 10004
pin = 303602
address = C/O Maksud Javed Khan, resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,
city = JAIPUR
f_c_name = W O Bhagchand Bhambi
order_issued_offid = 304
order_issued_off = ME,Bijoliyan
appeal_against_orderno = ??. /????/????./?????-2/ ?-309
mcaseno = 0
submission_date = 04/06/2025
Posting record
Param Type = n
trn_dmg_caseregid=15617000011207
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=mobileuser
Param Type = c
createdon=04/06/2025 14:22:46
Param Type = c
username=mobileuser
Param Type = c
modifiedon=04/06/2025 14:22:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10001
Param Type = c
case_purpose_name=Others
Param Type = c
viewfilter=AND a1.court_code=:m_courtcode 
Param Type = c
decisionflag=Submitted
Param Type = c
case_no=173/2025
Param Type = c
order_date=28/02/2025 00:00:00
Param Type = c
applicant_type=Others
Param Type = c
appeal_zoneid=10004
Param Type = c
pin=303602
Param Type = c
address=C/O Maksud Javed Khan, resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,
Param Type = c
city=JAIPUR
Param Type = c
f_c_name=W O Bhagchand Bhambi
Param Type = c
order_issued_offid=304
Param Type = c
order_issued_off=ME,Bijoliyan
Param Type = c
appeal_against_orderno=??. /????/????./?????-2/ ?-309
Param Type = c
mcaseno=0
Param Type = c
submission_date=04/06/2025 00:00:00
insert into TRN_DMG_CASEREG (trn_dmg_caseregid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,court_name,appeal_reason,case_decision_date,case_purpose_name,viewfilter,decision_type,hearingdate,decisionflag,firmtype,case_no,order_date,applicant_type,appeal_zoneid,pin,address,city,f_c_name,order_issued_offid,order_issued_off,appeal_against_orderno,mcaseno,submission_date) values (:trn_dmg_caseregid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,null,null,null,:case_purpose_name,:viewfilter,null,null,:decisionflag,null,:case_no,to_date(:order_date,'dd/mm/yyyy hh24:mi:ss'),:applicant_type,:appeal_zoneid,:pin,:address,:city,:f_c_name,:order_issued_offid,:order_issued_off,:appeal_against_orderno,:mcaseno,to_date(:submission_date,'dd/mm/yyyy hh24:mi:ss'))

Saving to table TRN_DMG_APPEAL_AGAINSTOFC
select * from TRN_DMG_APPEAL_AGAINSTOFC where  TRN_DMG_APPEAL_AGAINSTOFCid=0
Time elapsed = 6
Adding new record to store data from Frame 6, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15617000011208
Select sysdate as sdt from dual
Time elapsed = 4
personname = 
TRN_DMG_APPEAL_AGAINSTOFCrow = 1
Posting record
Param Type = n
trn_dmg_appeal_againstofcid=15617000011208
Param Type = n
trn_dmg_caseregid=15617000011207
Param Type = n
trn_dmg_appeal_againstofcrow=1
insert into TRN_DMG_APPEAL_AGAINSTOFC (trn_dmg_appeal_againstofcid,trn_dmg_caseregid,personname,trn_dmg_appeal_againstofcrow) values (:trn_dmg_appeal_againstofcid,:trn_dmg_caseregid,null,:trn_dmg_appeal_againstofcrow)

Saving to table TRN_DMG_APPLICANT
select * from TRN_DMG_APPLICANT where  TRN_DMG_APPLICANTid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15617000011209
Select sysdate as sdt from dual
Time elapsed = 5
app_pincode = 303602
app_address = C/O Maksud Javed Khan, resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,
app_city = JAIPUR
app_name = SHANTI DEVI
app_fname = W O Bhagchand Bhambi
app_powerofatt = No
power_pincode = 302021
power_add = Resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,
power_city = JAIPUR
power_name = Maksud Javed Khan
power_fname = ABDUL WAJID KHAN
TRN_DMG_APPLICANTrow = 1
Posting record
Param Type = n
trn_dmg_applicantid=15617000011209
Param Type = n
trn_dmg_caseregid=15617000011207
Param Type = n
app_pincode=303602
Param Type = c
app_address=C/O Maksud Javed Khan, resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,
Param Type = c
app_city=JAIPUR
Param Type = c
app_name=SHANTI DEVI
Param Type = c
app_fname=W O Bhagchand Bhambi
Param Type = c
app_powerofatt=No
Param Type = n
power_pincode=302021
Param Type = c
power_add=Resident of house no. A-316, in front of Sanskrit University, Gopalpura Bypass, Jaipur,
Param Type = c
power_city=JAIPUR
Param Type = c
power_name=Maksud Javed Khan
Param Type = c
power_fname=ABDUL WAJID KHAN
Param Type = n
trn_dmg_applicantrow=1
insert into TRN_DMG_APPLICANT (trn_dmg_applicantid,trn_dmg_caseregid,app_pincode,app_address,app_city,app_name,app_fname,app_powerofatt,power_pincode,power_add,power_city,power_name,power_fname,trn_dmg_applicantrow) values (:trn_dmg_applicantid,:trn_dmg_caseregid,:app_pincode,:app_address,:app_city,:app_name,:app_fname,:app_powerofatt,:power_pincode,:power_add,:power_city,:power_name,:power_fname,:trn_dmg_applicantrow)

Saving to table TRN_DMG_LEASEDTL
select * from TRN_DMG_LEASEDTL where  TRN_DMG_LEASEDTLid=0
Time elapsed = 9
Adding new record to store data from Frame 3, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 15617000011210
Select sysdate as sdt from dual
Time elapsed = 4
leasetype = 
mineraltype = 
meoffice = ME,Bijoliyan
zoneid = Udaipur
smeoffice = Bhilwara 
lease_no = Select
lease_city = BIJOLIYA
lease_pincode = 311602
lease_add = N/V JALERI, TEHSIL- BIJOLIYA, DIST-BHILWARA
lease_holder_name = NA
lease_fname = 
TRN_DMG_LEASEDTLrow = 1
Posting record
Param Type = n
trn_dmg_leasedtlid=15617000011210
Param Type = n
trn_dmg_caseregid=15617000011207
Param Type = c
meoffice=ME,Bijoliyan
Param Type = c
zoneid=Udaipur
Param Type = c
smeoffice=Bhilwara 
Param Type = c
lease_no=Select
Param Type = c
lease_city=BIJOLIYA
Param Type = n
lease_pincode=311602
Param Type = c
lease_add=N/V JALERI, TEHSIL- BIJOLIYA, DIST-BHILWARA
Param Type = c
lease_holder_name=NA
Param Type = n
trn_dmg_leasedtlrow=1
insert into TRN_DMG_LEASEDTL (trn_dmg_leasedtlid,trn_dmg_caseregid,leasetype,mineraltype,meoffice,zoneid,smeoffice,lease_no,lease_city,lease_pincode,lease_add,lease_holder_name,lease_fname,trn_dmg_leasedtlrow) values (:trn_dmg_leasedtlid,:trn_dmg_caseregid,null,null,:meoffice,:zoneid,:smeoffice,:lease_no,:lease_city,:lease_pincode,:lease_add,:lease_holder_name,null,:trn_dmg_leasedtlrow)

Time elapsed for insert/update = 3958208566624

>>Executing genmaps
Time elapsed for Gen Map = 3958208566625
Time elapsed for MD Map = 3958208566626
Time elapsed for Save History = 3958208566627
Time elapsed for Save Attachment = 3958208566627
Time elapsed for After Save WF Exec = 3958208566628
Transaction commited
Result : {"message":[{"msg":"DMG Registration Saved","Appeal No.*":"173/2025","recordid":"15617000011207"}]}
Savedata webservice completed


Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=mobileuser
Param Type = c
calledon=04/06/2025 14:22:45
Param Type = c
callfinished=04/06/2025 14:22:46
Param Type = c
structname=tpcdr
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=1061
Param Type = n
dbtimetaken=548
insert into axmwslog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken) values (null,:username,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),:structname,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken)

Freeing AxProvider Resources
Freeing DbManager Resources