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
dmismobileuser1f86bd3b581d1c9b322bb9349df5e753d![]()
INRFF,00000Ffiresql({m2},{select a3.valuecode from axusers a1,axuserdistrictdtl a2,cm_lov_values a3 where a1.axusersid=a2.axusersid(+) and a1.USERNAME= :username and A1.USERTYPE=a3.cm_lov_valuesid group by a3.valuecode})usrrole := sqlget({m2},{valuecode})firesql({m3},{select LISTAGG(A3.PATWAR_ENG, ',') WITHIN GROUP (ORDER BY A3.PATWAR_ENG) AS patwar from axusers a1,axuserdistrictdtl a2,cm_rvnu_patwar a3 where A1.AXUSERSID = A2.AXUSERSID and A3.CM_RVNU_PATWARID = A2.PATWAR and A1.USERNAME = :username })usrpatwar := sqlget({m3},{patwar})firesql({x},{Select distnm from VW_USRDTL where usrnm = :username and rownum=1})usrdistnm := sqlget({x},{distnm})firesql({x},{Select tehnm from VW_USRDTL where usrnm = :username and rownum=1})usrtehnm := sqlget({x},{tehnm})firesql({x},{Select ilrnm from VW_USRDTL where usrnm = :username and rownum=1})usrilrnm := sqlget({x},{ilrnm})firesql({x},{Select patnm from VW_USRDTL where usrnm = :username and rownum=1})usrpatnm := sqlget({x},{patnm})firesql({d1},{Select distinct nvl(X2.DISTRICT,0) distid from axusers x1,axuserdistrictdtl x2 where X1.AXUSERSID = x2.AXUSERSID(+) and x1.username = :username and rownum=1})usrdistid := sqlget({d1},{distid})firesql({A1},{select nvl(A2.DEPTNAME,'0') DEPTNAME from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1})usrdept := sqlget({A1},{DEPTNAME})firesql({A1},{select nvl(A2.OFFICENAME,'0') OFFICENAME from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1})usrofc := sqlget({A1},{OFFICENAME})firesql({A1},{select case when a3.DEPTNAME is null then 'ALL' else a3.DEPTNAME end as DEPTNAME from axusers a1,axuserdept a2,cm_department a3 where A3.CM_DEPARTMENTID(+) = A2.DEPTNAME and A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username })usrdeptnm := sqlget({A1},{DEPTNAME})firesql({A1},{Select 'ALL' OFCNAME from dual where :usrofc = 0 UNION Select OFCNAME from cm_office where cm_officeid = :usrofc})usrofcnm := sqlget({A1},{OFCNAME})firesql({m2},{Select x2.usergroup from axusers x1,AXUSERLEVELGROUPS x2 where x1.axusersid = x2.axusersid and x1.username = :username})urole := sqlget({m2},{usergroup})firesql({x},{Select PATID from VW_USRDTL where usrnm = :username and rownum=1})usrpatid := sqlget({x},{PATID})
Step4-4
Step5
Step6
Step9
fetched the props xml
9060000-1000000
2
Evaluating firesql({m2},{select a3.valuecode from axusers a1,axuserdistrictdtl a2,cm_lov_values a3 where a1.axusersid=a2.axusersid(+) and a1.USERNAME= :username and A1.USERTYPE=a3.cm_lov_valuesid group by a3.valuecode})
Calling function firesql
username=mobileuser1
select a3.valuecode from axusers a1,axuserdistrictdtl a2,cm_lov_values a3 where a1.axusersid=a2.axusersid(+) and a1.USERNAME= :username and A1.USERTYPE=a3.cm_lov_valuesid group by a3.valuecode
username=mobileuser1
Time elapsed = 48
Result of firesql =
Result =
Evaluating sqlget({m2},{valuecode})
Calling function sqlget
Result of sqlget = mobileuser
Result = mobileuser
Evaluating firesql({m3},{select LISTAGG(A3.PATWAR_ENG, ',') WITHIN GROUP (ORDER BY A3.PATWAR_ENG) AS patwar from axusers a1,axuserdistrictdtl a2,cm_rvnu_patwar a3 where A1.AXUSERSID = A2.AXUSERSID and A3.CM_RVNU_PATWARID = A2.PATWAR and A1.USERNAME = :username })
Calling function firesql
username=mobileuser1
select LISTAGG(A3.PATWAR_ENG, ',') WITHIN GROUP (ORDER BY A3.PATWAR_ENG) AS patwar from axusers a1,axuserdistrictdtl a2,cm_rvnu_patwar a3 where A1.AXUSERSID = A2.AXUSERSID and A3.CM_RVNU_PATWARID = A2.PATWAR and A1.USERNAME = :username
username=mobileuser1
Time elapsed = 44
Result of firesql =
Result =
Evaluating sqlget({m3},{patwar})
Calling function sqlget
Result of sqlget =
Result =
Evaluating firesql({x},{Select distnm from VW_USRDTL where usrnm = :username and rownum=1})
Calling function firesql
username=mobileuser1
Select distnm from VW_USRDTL where usrnm = :username and rownum=1
username=mobileuser1
Time elapsed = 50
Result of firesql =
Result =
Evaluating sqlget({x},{distnm})
Calling function sqlget
Result of sqlget = ALL
Result = ALL
Evaluating firesql({x},{Select tehnm from VW_USRDTL where usrnm = :username and rownum=1})
Calling function firesql
Select tehnm from VW_USRDTL where usrnm = :username and rownum=1
username=mobileuser1
Time elapsed = 48
Result of firesql =
Result =
Evaluating sqlget({x},{tehnm})
Calling function sqlget
Result of sqlget = ALL
Result = ALL
Evaluating firesql({x},{Select ilrnm from VW_USRDTL where usrnm = :username and rownum=1})
Calling function firesql
Select ilrnm from VW_USRDTL where usrnm = :username and rownum=1
username=mobileuser1
Time elapsed = 43
Result of firesql =
Result =
Evaluating sqlget({x},{ilrnm})
Calling function sqlget
Result of sqlget = ALL
Result = ALL
Evaluating firesql({x},{Select patnm from VW_USRDTL where usrnm = :username and rownum=1})
Calling function firesql
Select patnm from VW_USRDTL where usrnm = :username and rownum=1
username=mobileuser1
Time elapsed = 84
Result of firesql =
Result =
Evaluating sqlget({x},{patnm})
Calling function sqlget
Result of sqlget = ALL
Result = ALL
Evaluating firesql({d1},{Select distinct nvl(X2.DISTRICT,0) distid from axusers x1,axuserdistrictdtl x2 where X1.AXUSERSID = x2.AXUSERSID(+) and x1.username = :username and rownum=1})
Calling function firesql
username=mobileuser1
Select distinct nvl(X2.DISTRICT,0) distid from axusers x1,axuserdistrictdtl x2 where X1.AXUSERSID = x2.AXUSERSID(+) and x1.username = :username and rownum=1
username=mobileuser1
Time elapsed = 38
Result of firesql =
Result =
Evaluating sqlget({d1},{distid})
Calling function sqlget
Result of sqlget = 0
Result = 0
Evaluating firesql({A1},{select nvl(A2.DEPTNAME,'0') DEPTNAME from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1})
Calling function firesql
username=mobileuser1
select nvl(A2.DEPTNAME,'0') DEPTNAME from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1
username=mobileuser1
Time elapsed = 16
Result of firesql =
Result =
Evaluating sqlget({A1},{DEPTNAME})
Calling function sqlget
Result of sqlget = 0
Result = 0
Evaluating firesql({A1},{select nvl(A2.OFFICENAME,'0') OFFICENAME from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1})
Calling function firesql
select nvl(A2.OFFICENAME,'0') OFFICENAME from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1
username=mobileuser1
Time elapsed = 14
Result of firesql =
Result =
Evaluating sqlget({A1},{OFFICENAME})
Calling function sqlget
Result of sqlget = 0
Result = 0
Evaluating firesql({A1},{select case when a3.DEPTNAME is null then 'ALL' else a3.DEPTNAME end as DEPTNAME from axusers a1,axuserdept a2,cm_department a3 where A3.CM_DEPARTMENTID(+) = A2.DEPTNAME and A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username })
Calling function firesql
select case when a3.DEPTNAME is null then 'ALL' else a3.DEPTNAME end as DEPTNAME from axusers a1,axuserdept a2,cm_department a3 where A3.CM_DEPARTMENTID(+) = A2.DEPTNAME and A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username
username=mobileuser1
Time elapsed = 27
Result of firesql =
Result =
Evaluating sqlget({A1},{DEPTNAME})
Calling function sqlget
Result of sqlget = ALL
Result = ALL
Evaluating firesql({A1},{Select 'ALL' OFCNAME from dual where :usrofc = 0 UNION Select OFCNAME from cm_office where cm_officeid = :usrofc})
Calling function firesql
usrofc=0
Select 'ALL' OFCNAME from dual where :usrofc = 0 UNION Select OFCNAME from cm_office where cm_officeid = :usrofc
usrofc=0
usrofc=0
Time elapsed = 56
Result of firesql =
Result =
Evaluating sqlget({A1},{OFCNAME})
Calling function sqlget
Result of sqlget = ALL
Result = ALL
Evaluating firesql({m2},{Select x2.usergroup from axusers x1,AXUSERLEVELGROUPS x2 where x1.axusersid = x2.axusersid and x1.username = :username})
Calling function firesql
Select x2.usergroup from axusers x1,AXUSERLEVELGROUPS x2 where x1.axusersid = x2.axusersid and x1.username = :username
username=mobileuser1
Time elapsed = 22
Result of firesql =
Result =
Evaluating sqlget({m2},{usergroup})
Calling function sqlget
Result of sqlget = mobileuser
Result = mobileuser
Evaluating firesql({x},{Select PATID from VW_USRDTL where usrnm = :username and rownum=1})
Calling function firesql
Select PATID from VW_USRDTL where usrnm = :username and rownum=1
username=mobileuser1
Time elapsed = 83
Result of firesql =
Result =
Evaluating sqlget({x},{PATID})
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)='tscaf' and stype = 't' )
Time elapsed = 8
select Props from axuseraccess where lower(rname)='mobileuser' and lower(sname)='tscaf' and stype = 't'
Time elapsed = 10
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : mobileuser,tscaf,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 = 17
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 : tscaf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 8
Step4
tstructs\stm size:11883
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
select lpad(' ', 250, ' ') LVAL from dual
Time elapsed = 10
select lpad(' ', 250, ' ') LVAL from dual
Time elapsed = 21
Evaluating recordid
Result =
Evaluating userroles
Result =
Evaluating username
Result =
Evaluating usrdistid
Result =
Evaluating date()
Result =
Evaluating iif(age > 17,{T},{ should be greater then or equal 18})
Result =
Evaluating iif(getlength(mobileno) < 10 , {Mobile Number should be of 10 Digit},{T})
Result =
Evaluating iif(ruralurban = {Urban},iif(isempty(city)={T},{ is mandatory},{T}), {T})
Result =
Evaluating iif(ruralurban = {Rural},iif( isempty(pansamiti) ={T}, { is mandatory},{T}),{T})
Result =
Evaluating iif(ruralurban = {Rural}, iif(isempty(grampanchayat) = {T},{ is mandatory},{T}),{T})
Result =
Evaluating iif(ruralurban={Rural},iif(isempty(Village) = {T}, {is mandatory},{T}),{T})
Result =
Evaluating iif(ruralurban = {Urban},iif(isempty(disastercity)={T},{ is mandatory},{T}), {T})
Result =
Evaluating iif(disasterrural = {Rural},iif( isempty(disasterpansamiti) ={T}, { is mandatory},{T}),{T})
Result =
Evaluating iif(disasterrural = {Rural}, iif(isempty(disastergrampanchayat) = {T},{ is mandatory},{T}),{T})
Result =
Evaluating date()
Result =
Evaluating iif(isempty(disasdate) = {T},{ empty not allowed},iif( disasdate >todaydt,{Future Date Not Allowed},{T} ))
Result =
Evaluating scheme+ssoid
Result =
Evaluating {0}
Result =
Evaluating iif(ismandtory = {Yes}, iif(isempty(description) = {T},{ and attachment is mandatory},{T}),{T})
Result =
Evaluating iif(recordid > 0 & isempty(samvat)={T},{ is Mandatory! },{T})
Result =
Evaluating {Create}
Result =
Evaluating iif(action = {Recommend and Forward} & isempty(markto)={T},{ is mandatory},{T})
Result =
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tscaf
adxinout=o
Time elapsed = 25
select * from cm_activityform where cm_activityformid=0
Time elapsed = 25
select * from Axusers where 1=2
Time elapsed = 24
select distinct(fldname) from AxTempUserFields
Time elapsed = 18
select * from AxAttachWorkflow where lower(transid) = 'tscaf'
Time elapsed = 42
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : tacwk
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 8
Step4
tstructs\stm size:1693
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tacwk
adxinout=o
Time elapsed = 19
select * from trn_actionhistory where trn_actionhistoryid=0
Time elapsed = 19
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 tscaf
>>Frame No 1
recid =
Evaluating - recordid
recordid = 0
recid after validation = 0
status =
recid=0
select flag from CM_ACTIVITYFORM where CM_ACTIVITYFORMID = :recid
recid=0
Time elapsed = 13
isedit =
recid=0
select (case when flag in (0,3) then 'T' else 'F' end) isedit from CM_ACTIVITYFORM where
CM_ACTIVITYFORMID = :recid
recid=0
Time elapsed = 22
usrole =
Evaluating - userroles
userroles = mobileuser
usrole after validation = mobileuser
usr =
Evaluating - username
username = mobileuser1
usr after validation = mobileuser1
usrdistid =
Evaluating - usrdistid
usrdistid = 0
usrdistid after validation = 0
dist = Ajmer
select a1.cm_districtid, a1.districtname from cm_district a1
order by a1.districtname
Time elapsed = 9
regprefix =
dist=Ajmer
select 'AR'||'/'||(SUBSTR(upper( :dist ), 1, 4))||'/'||extract(year from sysdate )||'/' as pref
from dual
dist=Ajmer
Time elapsed = 37
regprefix after validation = AR/AJME/2025/
regno = 0
regdate =
recid=0
select TRUNC(CREATEDON) from CM_ACTIVITYFORM where CM_ACTIVITYFORMID =
:recid
recid=0
Time elapsed = 20
regdate after validation = 30/12/1899
todaydt =
Evaluating - date()
Result of date = 04/10/2025
todaydt after validation = 04/10/2025
calamity = FLOOD
select CM_DISASTERTYPEID,upper(DISASTERNAME) DISASTERNAME,DISASTERNAMEHN from cm_disastertype
where isactive = 'T' and IS4OTHERRELIEF = 'T'
order by DISASTERNAME
Time elapsed = 10
calamityid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
calamityid after validation = 12558000000000
scheme = Gratuitous Relief
Select c2.cm_lov_valuesid,C2.VALUECODE from cm_lov_values c2,cm_lov c1
where C1.CM_LOVID = C2.CM_LOVID and C1.LISTCODE = 'schemename' and upper(C2.ACTIVE) = upper('Yes')
order by C2.VALUECODE
Time elapsed = 25
schemeid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
schemeid after validation = 12704000000014
categorys = Clothing and Utensils/ Household Goods for Families
schemeid=12704000000014
Select A2.CM_SCHEMECATEGORYID, A2.SCHCATEGORYENG from cm_schemecategory a2,mst_subcategory a1 where A1.CATEGORY = A2.CM_SCHEMECATEGORYID and A1.SCHEME = :schemeid
schemeid=12704000000014
Time elapsed = 20
categoryid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
categoryid after validation = 15846000000021
quantity = 6
subcategory = Loss of Utensils/ Household Goods
schemeid=12704000000014
categoryid=15846000000021
select A2.MST_SUBCATEGORYDTLID, A2.SUBCATEGORY,A2.ASSITAMT from mst_subcategorydtl a2,mst_subcategory a1
where A2.MST_SUBCATEGORYID = A1.MST_SUBCATEGORYID and A1.SCHEME = :schemeid and A1.CATEGORY = :categoryid
schemeid=12704000000014
categoryid=15846000000021
Time elapsed = 59
subcatid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
subcatid after validation = 15853000000018
assistamt = 15000
applicantname = Shabnam Ara
afhname = Imamuddin
dob = 01/06/1979
age = 46
dob=01-Jun-1979
select decode(to_char(to_date( :dob, 'dd/mm/yyyy'),'yyyy'),1900,0,floor
(months_between(sysdate, :dob)/12))age from dual
dob=01-Jun-1979
dob=01-Jun-1979
Time elapsed = 32
Evaluating - iif(age > 17,{T},{ should be greater then or equal 18})
age = 46
Result of iif = T
gender = Female
select C.VALUECODE from VW_LOV c where C.LISTCODE = 'gender'
and upper(C.ACTIVE) = upper('Yes')
Time elapsed = 10
category =
select C.VALUECODE from VW_LOV c where C.LISTCODE = 'CastCategory'
and upper(C.ACTIVE) = upper('Yes')
Time elapsed = 11
mobileno = 9352829679
Evaluating - iif(getlength(mobileno) < 10 , {Mobile Number should be of 10 Digit},{T})
mobileno = 9352829679
Result of getlength = 10
Result of iif = T
email =
tdist =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
tdist after validation = 21
tehsil = Ajmer
dist = ('Ajmer')
Query component recreating again
select a.cm_tehsilid,a.tehsilname from cm_tehsil a ,cm_district b
where A.DISTRICTCODE =B.CM_DISTRICTID and upper(B.DISTRICTNAME)= upper('Ajmer')
Time elapsed = 42
ttehsil =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
dist = ('Ajmer')
ttehsil after validation = 190
ruralurban = Rural
select C.VALUECODE from VW_LOV c where C.LISTCODE = 'ruralurban'
and upper(C.ACTIVE) = upper('Yes')
Time elapsed = 22
city =
dist=Ajmer
select C.CM_CITYID, C.CITYENG from cm_city c, cm_district d where C.DISTRICTID = D.CM_DISTRICTID and d.DISTRICTNAME = :dist
dist=Ajmer
Time elapsed = 17
Evaluating - iif(ruralurban = {Urban},iif(isempty(city)={T},{ is mandatory},{T}), {T})
city =
Result of isempty = T
Result of iif = is mandatory
ruralurban = Rural
Result of iif = T
ward =
city=
select W.CM_WARDID,W.WARDENG from cm_ward w, cm_city c where W.CITYID = C.CITYID and C.CITYENG = :city order by W.CM_WARDID
city=
Time elapsed = 24
pansamiti = Srinagar
dist=Ajmer
select B.CM_BLOCKID,B.BLOCKNAME from cm_block b,cm_district d where B.DISTRICTCODE = D.CM_DISTRICTID and D.DISTRICTNAME = :dist order by B.BLOCKNAME
dist=Ajmer
Time elapsed = 25
Evaluating - iif(ruralurban = {Rural},iif( isempty(pansamiti) ={T}, { is mandatory},{T}),{T})
pansamiti = Srinagar
Result of isempty = F
Result of iif = T
ruralurban = Rural
Result of iif = T
grampanchayat = Hathi Khera
pansamiti=Srinagar
select gp.cm_gpanchayatId,GP.GPANCHAYATNAME from cm_gpanchayat gp,cm_block b where GP.PANSAMITI = B.CM_BLOCKID and B.BLOCKNAME = :pansamiti order by GP.GPANCHAYATNAME
pansamiti=Srinagar
Time elapsed = 68
Evaluating - iif(ruralurban = {Rural}, iif(isempty(grampanchayat) = {T},{ is mandatory},{T}),{T})
grampanchayat = Hathi Khera
Result of isempty = F
Result of iif = T
ruralurban = Rural
Result of iif = T
village = Boraj Kajipura
grampanchayat=Hathi Khera
dist=Ajmer
pansamiti=Srinagar
select V.CM_VILLAGEID,V.VILLAGENAME from cm_village v, cm_gpanchayat gp, cm_district cd, cm_block cb
where V.GPANCHAYATID = GP.CM_GPANCHAYATID
and CD.CM_DISTRICTID = CB.DISTRICTCODE
and CB.CM_BLOCKID = GP.PANSAMITI
and GP.GPANCHAYATNAME = :grampanchayat and CD.DISTRICTNAME = :dist and CB.BLOCKNAME = :pansamiti
order by V.VILLAGENAME
grampanchayat=Hathi Khera
dist=Ajmer
pansamiti=Srinagar
Time elapsed = 93
Evaluating - iif(ruralurban={Rural},iif(isempty(Village) = {T}, {is mandatory},{T}),{T})
village = Boraj Kajipura
Result of isempty = F
Result of iif = T
ruralurban = Rural
Result of iif = T
tvill =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
tvill after validation = 27380
streetname = Swastik Nagar
houseno = swastik nagar
disasterdist = Ajmer
select a1.cm_districtid, a1.districtname from cm_district a1
order by a1.districtname
Time elapsed = 56
disastertehsil = Ajmer
disasterdist = ('Ajmer')
Query component recreating again
select a.cm_tehsilid,a.tehsilname from cm_tehsil a ,cm_district b
where A.DISTRICTCODE =B.CM_DISTRICTID and upper(B.DISTRICTNAME)= upper('Ajmer')
Time elapsed = 39
disasterrural = Rural
select C.VALUECODE from VW_LOV c where C.LISTCODE = 'ruralurban'
and upper(C.ACTIVE) = upper('Yes')
Time elapsed = 44
disastercity =
disasterdist=Ajmer
select C.CM_CITYID, C.CITYENG from cm_city c, cm_district d where C.DISTRICTID = D.CM_DISTRICTID and d.DISTRICTNAME = :disasterdist
disasterdist=Ajmer
Time elapsed = 61
Evaluating - iif(ruralurban = {Urban},iif(isempty(disastercity)={T},{ is mandatory},{T}), {T})
disastercity =
Result of isempty = T
Result of iif = is mandatory
ruralurban = Rural
Result of iif = T
disasterward =
disastercity=
select W.CM_WARDID,W.WARDENG from cm_ward w, cm_city c where W.CITYID = C.CITYID and C.CITYENG = :disastercity order by W.CM_WARDID
disastercity=
Time elapsed = 17
disasterpansamiti = Srinagar
disasterdist=Ajmer
select B.CM_BLOCKID,B.BLOCKNAME from cm_block b,cm_district d where B.DISTRICTCODE = D.CM_DISTRICTID and D.DISTRICTNAME = :disasterdist order by B.BLOCKNAME
disasterdist=Ajmer
Time elapsed = 17
Evaluating - iif(disasterrural = {Rural},iif( isempty(disasterpansamiti) ={T}, { is mandatory},{T}),{T})
disasterpansamiti = Srinagar
Result of isempty = F
Result of iif = T
disasterrural = Rural
Result of iif = T
disastergrampanchayat = Hathi Khera
disasterpansamiti=Srinagar
select gp.cm_gpanchayatId,GP.GPANCHAYATNAME from cm_gpanchayat gp,cm_block b where GP.PANSAMITI = B.CM_BLOCKID and B.BLOCKNAME = :disasterpansamiti order by GP.GPANCHAYATNAME
disasterpansamiti=Srinagar
Time elapsed = 55
Evaluating - iif(disasterrural = {Rural}, iif(isempty(disastergrampanchayat) = {T},{ is mandatory},{T}),{T})
disastergrampanchayat = Hathi Khera
Result of isempty = F
Result of iif = T
disasterrural = Rural
Result of iif = T
disastervillage = Boraj Kajipura
disastergrampanchayat=Hathi Khera
disasterdist=Ajmer
disasterpansamiti=Srinagar
select V.CM_VILLAGEID,V.VILLAGENAME from cm_village v, cm_gpanchayat gp, cm_district cd, cm_block cb
where V.GPANCHAYATID = GP.CM_GPANCHAYATID
and CD.CM_DISTRICTID = CB.DISTRICTCODE
and CB.CM_BLOCKID = GP.PANSAMITI
and GP.GPANCHAYATNAME = :disastergrampanchayat and CD.DISTRICTNAME = :disasterdist and CB.BLOCKNAME = :disasterpansamiti
order by V.VILLAGENAME
disastergrampanchayat=Hathi Khera
disasterdist=Ajmer
disasterpansamiti=Srinagar
Time elapsed = 92
patwar =
disasterdist=Ajmer
disastertehsil=Ajmer
disastervillage=Boraj Kajipura
recordid=0
SELECT V.PATWARNM
FROM vw_tehsilvill v
WHERE V.DISTNM = :disasterdist
AND V.TEHSILNM = :disastertehsil
AND V.VILLNM = :disastervillage
AND :recordid = 0
UNION
SELECT PATWAR
FROM CM_ACTIVITYFORM
WHERE CM_ACTIVITYFORMID = :recordid
disasterdist=Ajmer
disastertehsil=Ajmer
disastervillage=Boraj Kajipura
recordid=0
recordid=0
Time elapsed = 83
patwar after validation = Boraj Kazipura
disasterstreetname = Swastik Nagar
disasterflatno = swastik nagar
disasdate = 04/09/2025
Evaluating - iif(isempty(disasdate) = {T},{ empty not allowed},iif( disasdate >todaydt,{Future Date Not Allowed},{T} ))
disasdate = 04/09/2025
todaydt = 04/10/2025
Result of iif = T
disasdate = 04/09/2025
Result of isempty = F
Result of iif = T
disasterdetail = Heavy Rain Fall shabnam T11
disasterarea = Boraj Ajmr
aadhaarno =
janaadhaarno = 5144426564
ackno = 9999-LBJ4-00142
memberid = 67179616787
ssoid = SHABNAM.ARA786
ifsc = SBIN0032366
bhamashah =
bankname = STATE BANK OF INDIA
branchname = Foy Sagar , Ajmer
accountno = 34605245669
chkdupsso =
Evaluating - scheme+ssoid
scheme = Gratuitous Relief
ssoid = SHABNAM.ARA786
chkdupsso after validation = Gratuitous ReliefSHABNAM.ARA786
sanctionflag =
Evaluating - {0}
sanctionflag after validation = 0
sanctionno =
disasteraddress =
samvat =
select samvat from cm_otherrelief_config order by Samvat desc
Time elapsed = 44
Evaluating - iif(recordid > 0 & isempty(samvat)={T},{ is Mandatory! },{T})
samvat =
Result of isempty = T
recordid = 0
Result of iif = T
farcat =
action =
farcat=
scheme=Gratuitous Relief
usrole=mobileuser
SELECT DISTINCT
CASE WHEN :farcat = 'OSMF' AND :scheme = 'Animal husbandry assistance' THEN 'Reject' ELSE ACTION END AS Action,
CASE WHEN :farcat = 'OSMF' AND :scheme = 'Animal husbandry assistance' THEN 5 else VIEWCODE END AS VIEWCODE from cm_wfactionhdr x1, cm_wfactiondtl x2
where x1.cm_wfactionhdrid = x2.cm_wfactionhdrid
and upper(x1.TCAPTIONNAME) = UPPER('Relief Assistance Form')
and UPPER(ROLE) = UPPER( :usrole )
order by VIEWCODE
farcat=
scheme=Gratuitous Relief
farcat=
scheme=Gratuitous Relief
usrole=mobileuser
Time elapsed = 65
Evaluating - {Create}
action after validation = Create
markto = Patwari
usrole=mobileuser
action=Create
SELECT DISTINCT a.nextusergroup
FROM cm_wfactiondtl a, cm_wfactionhdr b
WHERE A.cm_wfactionhdrid = b.cm_wfactionhdrid
AND B.Role = :usrole
AND a.action = :action
AND B.TRNNAME IN
(SELECT a2.cm_moduledtlid
FROM cm_modulehdr a1, cm_moduledtl a2
WHERE a1.cm_modulehdrid = a2.cm_modulehdrid
AND a1.modname = 'Other Relief'
AND a2.tname = 'tscaf')
usrole=mobileuser
action=Create
Time elapsed = 23
Evaluating - iif(action = {Recommend and Forward} & isempty(markto)={T},{ is mandatory},{T})
markto = Patwari
Result of isempty = F
action = Create
Result of iif = T
marktouser =
tdist=21
markto=Patwari
ttehsil=190
tvill=27380
SELECT e.USERNAME
FROM AXUSERlevelgroups e, axuserdistrictdtl g, AXUSERGROUPS d
WHERE E.AXUSERSID = G.AXUSERSID
AND E.USERGROUP = d.groupname
AND G.DISTRICT = :tdist
AND d.USERROLES = :markto
AND ( ( :markto = 'Tehsildar' AND G.PSAMITI = :ttehsil )
OR ( :markto IN ('ReliefOIC', 'Collector'))
OR ( :markto = 'Patwari'
AND (SELECT V.PATWARID
FROM vw_tehsilvill v
WHERE V.DISTID = :tdist
AND V.TEHSILID = :ttehsil
AND V.VILLID = :tvill ) = G.PATWAR))
tdist=21
markto=Patwari
markto=Patwari
ttehsil=190
markto=Patwari
markto=Patwari
tdist=21
ttehsil=190
tvill=27380
Time elapsed = 103
marktouser after validation = 38653
viewcode = 0
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
rejreason =
remark =
flag =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
flag after validation = 0
appamt =
bhamashahstatus =
bhamashahremark =
a =
time zone difference = 0
>>Writing to tables tscaf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tscaf'
Time elapsed = 32
Saving to table CM_ACTIVITYFORM
select * from CM_ACTIVITYFORM where CM_ACTIVITYFORMid=0
Time elapsed = 13
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 = 27
RecordId = 13014000000168
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 28
Select sysdate as sdt from dual
Time elapsed = 39
ifsc = SBIN0032366
bhamashah =
memberid = 67179616787
ssoid = SHABNAM.ARA786
accountno = 34605245669
disasteraddress =
bankname = STATE BANK OF INDIA
branchname = Foy Sagar , Ajmer
disasdate = 04/09/2025
disasterdetail = Heavy Rain Fall shabnam T11
disasterstreetname = Swastik Nagar
disasterflatno = swastik nagar
janaadhaarno = 5144426564
ackno = 9999-LBJ4-00142
disasterarea = Boraj Ajmr
aadhaarno =
action = Create
rejreason =
samvat =
farcat =
bhamashahstatus = 0
bhamashahremark =
flag = 0
appamt = 0
marktouser = 38653
markto = Patwari
remark =
viewcode = 0
sanctionflag = 0
sanctionno =
patwar = Boraj Kazipura
chkdupsso = Gratuitous ReliefSHABNAM.ARA786
disastervillage = 27380
email =
categorys = 15846000000021
category =
mobileno = 9352829679
Select * FROM Sequence WHERE lower(TRANSTYPE)='tscaf' and lower(FIELDNAME)='regno'and lower(prefixfield)='regprefix'
Time elapsed = 40
update Sequence set lastno = 126272 where lower(TRANSTYPE)='tscaf' and lower(FIELDNAME)='regno'and lower(prefixfield)='regprefix'
Time elapsed = 8
regno = AR/AJME/2025/126271
dist = 21
scheme = 12704000000014
calamity = 12558000000000
applicantname = Shabnam Ara
afhname = Imamuddin
subcategory = 15853000000018
assistamt = 15000
quantity = 6
gender = Female
dob = 01/06/1979
age = 46
disastertehsil = 190
disasterrural = Rural
houseno = swastik nagar
disasterdist = 21
disasterpansamiti = 191
disastergrampanchayat = 6622
disastercity = 0
disasterward = 0
city = 0
ward = 0
tehsil = 190
ruralurban = Rural
village = 27380
streetname = Swastik Nagar
pansamiti = 191
grampanchayat = 6622
Posting record
t=13014000000168
select regno from CM_ACTIVITYFORM where regno = 'AR/AJME/2025/126271' and CM_ACTIVITYFORMid <> :t
t=13014000000168
Time elapsed = 392
Param Type = n
cm_activityformid=13014000000168
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=mobileuser1
Param Type = c
createdon=04/10/2025 12:31:02
Param Type = c
username=mobileuser1
Param Type = c
modifiedon=04/10/2025 12:31:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
ifsc=SBIN0032366
Param Type = c
memberid=67179616787
Param Type = c
ssoid=SHABNAM.ARA786
Param Type = c
accountno=34605245669
Param Type = c
bankname=STATE BANK OF INDIA
Param Type = c
branchname=Foy Sagar , Ajmer
Param Type = c
disasdate=04/09/2025 00:00:00
Param Type = c
disasterdetail=Heavy Rain Fall shabnam T11
Param Type = c
disasterstreetname=Swastik Nagar
Param Type = c
disasterflatno=swastik nagar
Param Type = c
janaadhaarno=5144426564
Param Type = c
ackno=9999-LBJ4-00142
Param Type = c
disasterarea=Boraj Ajmr
Param Type = c
action=Create
Param Type = n
bhamashahstatus=0
Param Type = n
flag=0
Param Type = n
appamt=0
Param Type = c
marktouser=38653
Param Type = c
markto=Patwari
Param Type = n
viewcode=0
Param Type = n
sanctionflag=0
Param Type = c
patwar=Boraj Kazipura
Param Type = c
chkdupsso=Gratuitous ReliefSHABNAM.ARA786
Param Type = n
disastervillage=27380
Param Type = n
categorys=15846000000021
Param Type = n
mobileno=9352829679
Param Type = c
regno=AR/AJME/2025/126271
Param Type = n
dist=21
Param Type = n
scheme=12704000000014
Param Type = n
calamity=12558000000000
Param Type = c
applicantname=Shabnam Ara
Param Type = c
afhname=Imamuddin
Param Type = n
subcategory=15853000000018
Param Type = n
assistamt=15000
Param Type = n
quantity=6
Param Type = c
gender=Female
Param Type = c
dob=01/06/1979 00:00:00
Param Type = n
age=46
Param Type = n
disastertehsil=190
Param Type = c
disasterrural=Rural
Param Type = c
houseno=swastik nagar
Param Type = n
disasterdist=21
Param Type = n
disasterpansamiti=191
Param Type = n
disastergrampanchayat=6622
Param Type = n
disastercity=0
Param Type = n
disasterward=0
Param Type = n
city=0
Param Type = n
ward=0
Param Type = n
tehsil=190
Param Type = c
ruralurban=Rural
Param Type = n
village=27380
Param Type = c
streetname=Swastik Nagar
Param Type = n
pansamiti=191
Param Type = n
grampanchayat=6622
insert into CM_ACTIVITYFORM (cm_activityformid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,ifsc,bhamashah,memberid,ssoid,accountno,disasteraddress,bankname,branchname,disasdate,disasterdetail,disasterstreetname,disasterflatno,janaadhaarno,ackno,disasterarea,aadhaarno,action,rejreason,samvat,farcat,bhamashahstatus,bhamashahremark,flag,appamt,marktouser,markto,remark,viewcode,sanctionflag,sanctionno,patwar,chkdupsso,disastervillage,email,categorys,category,mobileno,regno,dist,scheme,calamity,applicantname,afhname,subcategory,assistamt,quantity,gender,dob,age,disastertehsil,disasterrural,houseno,disasterdist,disasterpansamiti,disastergrampanchayat,disastercity,disasterward,city,ward,tehsil,ruralurban,village,streetname,pansamiti,grampanchayat) values (:cm_activityformid,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,:ifsc,null,:memberid,:ssoid,:accountno,null,:bankname,:branchname,to_date(:disasdate,'dd/mm/yyyy hh24:mi:ss'),:disasterdetail,:disasterstreetname,:disasterflatno,:janaadhaarno,:ackno,:disasterarea,null,:action,null,null,null,:bhamashahstatus,null,:flag,:appamt,:marktouser,:markto,null,:viewcode,:sanctionflag,null,:patwar,:chkdupsso,:disastervillage,null,:categorys,null,:mobileno,:regno,:dist,:scheme,:calamity,:applicantname,:afhname,:subcategory,:assistamt,:quantity,:gender,to_date(:dob,'dd/mm/yyyy hh24:mi:ss'),:age,:disastertehsil,:disasterrural,:houseno,:disasterdist,:disasterpansamiti,:disastergrampanchayat,:disastercity,:disasterward,:city,:ward,:tehsil,:ruralurban,:village,:streetname,:pansamiti,:grampanchayat)
Saving to table CM_ACTIVITYFORM_ATTACH
select * from CM_ACTIVITYFORM_ATTACH where CM_ACTIVITYFORM_ATTACHid=0
Time elapsed = 13
Adding new record to store data from Frame 4, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 14
RecordId = 13014000000169
Select sysdate as sdt from dual
Time elapsed = 41
axp_gridattach_4 = T11 shbnam ji.pdf
axp_gridattach_4 = T11 shbnam ji.pdf
axp_gridattach_4 = T11 shbnam ji.pdf
attachname = Aadhaar Card
attachname = Aadhaar Card
attachname = Aadhaar Card
description = patwari report
description = patwari report
description = patwari report
CM_ACTIVITYFORM_ATTACHrow = 1
Posting record
Param Type = n
cm_activityform_attachid=13014000000169
Param Type = n
cm_activityformid=13014000000168
Param Type = c
axp_gridattach_4=T11 shbnam ji.pdf
Param Type = c
attachname=Aadhaar Card
Param Type = c
description=patwari report
Param Type = n
cm_activityform_attachrow=1
insert into CM_ACTIVITYFORM_ATTACH (cm_activityform_attachid,cm_activityformid,axp_gridattach_4,attachname,description,cm_activityform_attachrow) values (:cm_activityform_attachid,:cm_activityformid,:axp_gridattach_4,:attachname,:description,:cm_activityform_attachrow)
select * from CM_ACTIVITYFORM_ATTACH where CM_ACTIVITYFORM_ATTACHid=0
Time elapsed = 20
Adding new record to store data from Frame 4, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 18
RecordId = 13014000000170
Select sysdate as sdt from dual
Time elapsed = 13
axp_gridattach_4 = T11 shbnam ji.pdf
description = Relational Attachment1
attachname = Relational Attachment
CM_ACTIVITYFORM_ATTACHrow = 4
Posting record
Param Type = n
cm_activityform_attachid=13014000000170
Param Type = n
cm_activityformid=13014000000168
Param Type = c
axp_gridattach_4=T11 shbnam ji.pdf
Param Type = c
description=Relational Attachment1
Param Type = c
attachname=Relational Attachment
Param Type = n
cm_activityform_attachrow=4
insert into CM_ACTIVITYFORM_ATTACH (cm_activityform_attachid,cm_activityformid,axp_gridattach_4,description,attachname,cm_activityform_attachrow) values (:cm_activityform_attachid,:cm_activityformid,:axp_gridattach_4,:description,:attachname,:cm_activityform_attachrow)
select * from CM_ACTIVITYFORM_ATTACH where CM_ACTIVITYFORM_ATTACHid=0
Time elapsed = 22
Adding new record to store data from Frame 4, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 9
RecordId = 13014000000171
Select sysdate as sdt from dual
Time elapsed = 41
attachname = Relational Attachment
description = Relational Attachment2
axp_gridattach_4 = T11 shbnam ji.pdf
CM_ACTIVITYFORM_ATTACHrow = 5
Posting record
Param Type = n
cm_activityform_attachid=13014000000171
Param Type = n
cm_activityformid=13014000000168
Param Type = c
attachname=Relational Attachment
Param Type = c
description=Relational Attachment2
Param Type = c
axp_gridattach_4=T11 shbnam ji.pdf
Param Type = n
cm_activityform_attachrow=5
insert into CM_ACTIVITYFORM_ATTACH (cm_activityform_attachid,cm_activityformid,attachname,description,axp_gridattach_4,cm_activityform_attachrow) values (:cm_activityform_attachid,:cm_activityformid,:attachname,:description,:axp_gridattach_4,:cm_activityform_attachrow)
select * from CM_ACTIVITYFORM_ATTACH where CM_ACTIVITYFORM_ATTACHid=0
Time elapsed = 10
Adding new record to store data from Frame 4, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 13
RecordId = 13014000000172
Select sysdate as sdt from dual
Time elapsed = 40
axp_gridattach_4 = T11 shbnam ji.pdf
description = Relational Attachment3
attachname = Relational Attachment
CM_ACTIVITYFORM_ATTACHrow = 6
Posting record
Param Type = n
cm_activityform_attachid=13014000000172
Param Type = n
cm_activityformid=13014000000168
Param Type = c
axp_gridattach_4=T11 shbnam ji.pdf
Param Type = c
description=Relational Attachment3
Param Type = c
attachname=Relational Attachment
Param Type = n
cm_activityform_attachrow=6
insert into CM_ACTIVITYFORM_ATTACH (cm_activityform_attachid,cm_activityformid,axp_gridattach_4,description,attachname,cm_activityform_attachrow) values (:cm_activityform_attachid,:cm_activityformid,:axp_gridattach_4,:description,:attachname,:cm_activityform_attachrow)
select * from CM_ACTIVITYFORM_ATTACH where CM_ACTIVITYFORM_ATTACHid=0
Time elapsed = 9
Adding new record to store data from Frame 4, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 9
RecordId = 13014000000173
Select sysdate as sdt from dual
Time elapsed = 36
axp_gridattach_4 = T11 shbnam ji.pdf
description = Relational Attachment4
attachname = Relational Attachment
CM_ACTIVITYFORM_ATTACHrow = 7
Posting record
Param Type = n
cm_activityform_attachid=13014000000173
Param Type = n
cm_activityformid=13014000000168
Param Type = c
axp_gridattach_4=T11 shbnam ji.pdf
Param Type = c
description=Relational Attachment4
Param Type = c
attachname=Relational Attachment
Param Type = n
cm_activityform_attachrow=7
insert into CM_ACTIVITYFORM_ATTACH (cm_activityform_attachid,cm_activityformid,axp_gridattach_4,description,attachname,cm_activityform_attachrow) values (:cm_activityform_attachid,:cm_activityformid,:axp_gridattach_4,:description,:attachname,:cm_activityform_attachrow)
select * from CM_ACTIVITYFORM_ATTACH where CM_ACTIVITYFORM_ATTACHid=0
Time elapsed = 28
Adding new record to store data from Frame 4, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 12
RecordId = 13014000000174
Select sysdate as sdt from dual
Time elapsed = 25
axp_gridattach_4 = T11 shbnam ji.pdf
description = Relational Attachment5
attachname = Relational Attachment
CM_ACTIVITYFORM_ATTACHrow = 8
Posting record
Param Type = n
cm_activityform_attachid=13014000000174
Param Type = n
cm_activityformid=13014000000168
Param Type = c
axp_gridattach_4=T11 shbnam ji.pdf
Param Type = c
description=Relational Attachment5
Param Type = c
attachname=Relational Attachment
Param Type = n
cm_activityform_attachrow=8
insert into CM_ACTIVITYFORM_ATTACH (cm_activityform_attachid,cm_activityformid,axp_gridattach_4,description,attachname,cm_activityform_attachrow) values (:cm_activityform_attachid,:cm_activityformid,:axp_gridattach_4,:description,:attachname,:cm_activityform_attachrow)
select * from CM_ACTIVITYFORM_ATTACH where CM_ACTIVITYFORM_ATTACHid=0
Time elapsed = 20
Adding new record to store data from Frame 4, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 17
RecordId = 13014000000175
Select sysdate as sdt from dual
Time elapsed = 42
attachname = Relational Attachment
description = Relational Attachment6
axp_gridattach_4 = T11 shbnam ji.pdf
CM_ACTIVITYFORM_ATTACHrow = 9
Posting record
Param Type = n
cm_activityform_attachid=13014000000175
Param Type = n
cm_activityformid=13014000000168
Param Type = c
attachname=Relational Attachment
Param Type = c
description=Relational Attachment6
Param Type = c
axp_gridattach_4=T11 shbnam ji.pdf
Param Type = n
cm_activityform_attachrow=9
insert into CM_ACTIVITYFORM_ATTACH (cm_activityform_attachid,cm_activityformid,attachname,description,axp_gridattach_4,cm_activityform_attachrow) values (:cm_activityform_attachid,:cm_activityformid,:attachname,:description,:axp_gridattach_4,:cm_activityform_attachrow)
Saving to table CM_ACTIVITYGRATUITOUSDTL
select * from CM_ACTIVITYGRATUITOUSDTL where CM_ACTIVITYGRATUITOUSDTLid=0
Time elapsed = 15
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 = 8
RecordId = 13014000000176
Select sysdate as sdt from dual
Time elapsed = 17
personage = 40
address = boraj ajmer
maritalstatus = Married
name = shabnam
relationapplicant = self
CM_ACTIVITYGRATUITOUSDTLrow = 1
Posting record
Param Type = n
cm_activitygratuitousdtlid=13014000000176
Param Type = n
cm_activityformid=13014000000168
Param Type = n
personage=40
Param Type = c
address=boraj ajmer
Param Type = c
maritalstatus=Married
Param Type = c
name=shabnam
Param Type = c
relationapplicant=self
Param Type = n
cm_activitygratuitousdtlrow=1
insert into CM_ACTIVITYGRATUITOUSDTL (cm_activitygratuitousdtlid,cm_activityformid,personage,address,maritalstatus,name,relationapplicant,cm_activitygratuitousdtlrow) values (:cm_activitygratuitousdtlid,:cm_activityformid,:personage,:address,:maritalstatus,:name,:relationapplicant,:cm_activitygratuitousdtlrow)
select * from CM_ACTIVITYGRATUITOUSDTL where CM_ACTIVITYGRATUITOUSDTLid=0
Time elapsed = 20
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 18
RecordId = 13014000000177
Select sysdate as sdt from dual
Time elapsed = 41
personage = 40
address = boraj ajmer
maritalstatus = Married
name = shabnam
relationapplicant = SELF
CM_ACTIVITYGRATUITOUSDTLrow = 2
Posting record
Param Type = n
cm_activitygratuitousdtlid=13014000000177
Param Type = n
cm_activityformid=13014000000168
Param Type = n
personage=40
Param Type = c
address=boraj ajmer
Param Type = c
maritalstatus=Married
Param Type = c
name=shabnam
Param Type = c
relationapplicant=SELF
Param Type = n
cm_activitygratuitousdtlrow=2
insert into CM_ACTIVITYGRATUITOUSDTL (cm_activitygratuitousdtlid,cm_activityformid,personage,address,maritalstatus,name,relationapplicant,cm_activitygratuitousdtlrow) values (:cm_activitygratuitousdtlid,:cm_activityformid,:personage,:address,:maritalstatus,:name,:relationapplicant,:cm_activitygratuitousdtlrow)
select * from CM_ACTIVITYGRATUITOUSDTL where CM_ACTIVITYGRATUITOUSDTLid=0
Time elapsed = 9
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 13014000000178
Select sysdate as sdt from dual
Time elapsed = 9
relationapplicant = SELF
name = shabnam
maritalstatus = Married
address = boraj ajmer
personage = 40
CM_ACTIVITYGRATUITOUSDTLrow = 3
Posting record
Param Type = n
cm_activitygratuitousdtlid=13014000000178
Param Type = n
cm_activityformid=13014000000168
Param Type = c
relationapplicant=SELF
Param Type = c
name=shabnam
Param Type = c
maritalstatus=Married
Param Type = c
address=boraj ajmer
Param Type = n
personage=40
Param Type = n
cm_activitygratuitousdtlrow=3
insert into CM_ACTIVITYGRATUITOUSDTL (cm_activitygratuitousdtlid,cm_activityformid,relationapplicant,name,maritalstatus,address,personage,cm_activitygratuitousdtlrow) values (:cm_activitygratuitousdtlid,:cm_activityformid,:relationapplicant,:name,:maritalstatus,:address,:personage,:cm_activitygratuitousdtlrow)
select * from CM_ACTIVITYGRATUITOUSDTL where CM_ACTIVITYGRATUITOUSDTLid=0
Time elapsed = 9
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 9
RecordId = 13014000000179
Select sysdate as sdt from dual
Time elapsed = 10
relationapplicant = self
name = shabnam
maritalstatus = Married
address = boraj ajmer
personage = 40
CM_ACTIVITYGRATUITOUSDTLrow = 4
Posting record
Param Type = n
cm_activitygratuitousdtlid=13014000000179
Param Type = n
cm_activityformid=13014000000168
Param Type = c
relationapplicant=self
Param Type = c
name=shabnam
Param Type = c
maritalstatus=Married
Param Type = c
address=boraj ajmer
Param Type = n
personage=40
Param Type = n
cm_activitygratuitousdtlrow=4
insert into CM_ACTIVITYGRATUITOUSDTL (cm_activitygratuitousdtlid,cm_activityformid,relationapplicant,name,maritalstatus,address,personage,cm_activitygratuitousdtlrow) values (:cm_activitygratuitousdtlid,:cm_activityformid,:relationapplicant,:name,:maritalstatus,:address,:personage,:cm_activitygratuitousdtlrow)
select * from CM_ACTIVITYGRATUITOUSDTL where CM_ACTIVITYGRATUITOUSDTLid=0
Time elapsed = 20
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 13014000000180
Select sysdate as sdt from dual
Time elapsed = 34
personage = 40
address = boraj ajmer
maritalstatus = Married
name = shabnam
relationapplicant = SELF
CM_ACTIVITYGRATUITOUSDTLrow = 5
Posting record
Param Type = n
cm_activitygratuitousdtlid=13014000000180
Param Type = n
cm_activityformid=13014000000168
Param Type = n
personage=40
Param Type = c
address=boraj ajmer
Param Type = c
maritalstatus=Married
Param Type = c
name=shabnam
Param Type = c
relationapplicant=SELF
Param Type = n
cm_activitygratuitousdtlrow=5
insert into CM_ACTIVITYGRATUITOUSDTL (cm_activitygratuitousdtlid,cm_activityformid,personage,address,maritalstatus,name,relationapplicant,cm_activitygratuitousdtlrow) values (:cm_activitygratuitousdtlid,:cm_activityformid,:personage,:address,:maritalstatus,:name,:relationapplicant,:cm_activitygratuitousdtlrow)
select * from CM_ACTIVITYGRATUITOUSDTL where CM_ACTIVITYGRATUITOUSDTLid=0
Time elapsed = 8
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 13014000000181
Select sysdate as sdt from dual
Time elapsed = 37
relationapplicant = SELF
name = shabnam
address = BORAJ
personage = 40
maritalstatus = Married
CM_ACTIVITYGRATUITOUSDTLrow = 6
Posting record
Param Type = n
cm_activitygratuitousdtlid=13014000000181
Param Type = n
cm_activityformid=13014000000168
Param Type = c
relationapplicant=SELF
Param Type = c
name=shabnam
Param Type = c
address=BORAJ
Param Type = n
personage=40
Param Type = c
maritalstatus=Married
Param Type = n
cm_activitygratuitousdtlrow=6
insert into CM_ACTIVITYGRATUITOUSDTL (cm_activitygratuitousdtlid,cm_activityformid,relationapplicant,name,address,personage,maritalstatus,cm_activitygratuitousdtlrow) values (:cm_activitygratuitousdtlid,:cm_activityformid,:relationapplicant,:name,:address,:personage,:maritalstatus,:cm_activitygratuitousdtlrow)
Saving to table TRN_DYNAMICFIELDS
select * from TRN_DYNAMICFIELDS where TRN_DYNAMICFIELDSid=0
Time elapsed = 18
Adding new record to store data from Frame 5, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 9
RecordId = 13014000000182
Select sysdate as sdt from dual
Time elapsed = 49
attvalue = 4
attribute = Affected Days of family from Disaster Date
TRN_DYNAMICFIELDSrow = 1
Posting record
Param Type = n
trn_dynamicfieldsid=13014000000182
Param Type = n
cm_activityformid=13014000000168
Param Type = c
attvalue=4
Param Type = c
attribute=Affected Days of family from Disaster Date
Param Type = n
trn_dynamicfieldsrow=1
insert into TRN_DYNAMICFIELDS (trn_dynamicfieldsid,cm_activityformid,attvalue,attribute,trn_dynamicfieldsrow) values (:trn_dynamicfieldsid,:cm_activityformid,:attvalue,:attribute,:trn_dynamicfieldsrow)
select * from TRN_DYNAMICFIELDS where TRN_DYNAMICFIELDSid=0
Time elapsed = 13
Adding new record to store data from Frame 5, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 18
RecordId = 13014000000183
Select sysdate as sdt from dual
Time elapsed = 40
attvalue = Heavy Rain Fall
attribute = Cause of Loss Utensils/ Household Goods
TRN_DYNAMICFIELDSrow = 2
Posting record
Param Type = n
trn_dynamicfieldsid=13014000000183
Param Type = n
cm_activityformid=13014000000168
Param Type = c
attvalue=Heavy Rain Fall
Param Type = c
attribute=Cause of Loss Utensils/ Household Goods
Param Type = n
trn_dynamicfieldsrow=2
insert into TRN_DYNAMICFIELDS (trn_dynamicfieldsid,cm_activityformid,attvalue,attribute,trn_dynamicfieldsrow) values (:trn_dynamicfieldsid,:cm_activityformid,:attvalue,:attribute,:trn_dynamicfieldsrow)
Time elapsed for insert/update = 3968742649777
>>Executing genmaps
>>Posting from tscaf to tacwk
>>Mapping
Mapped moduletype Row = 1 value = Gratuitous Relief idvalue 0
Mapped entrytype Row = 1 value = Relief Assistance Form idvalue 0
Mapped tablename Row = 1 value = cm_activityform idvalue 0
Mapped recid Row = 1 value = 13014000000168 idvalue 0
Mapped viewcode Row = 1 value = 0 idvalue 0
Mapped actionbyrole Row = 1 value = mobileuser idvalue 0
Mapped actionbyuser Row = 1 value = mobileuser1 idvalue 0
Mapped action Row = 1 value = Create idvalue 0
Mapped nextrole Row = 1 value = Patwari idvalue 0
Mapped nextuser Row = 1 value = 38653 idvalue 0
Mapped remark Row = 1 value = idvalue 0
Mapped systemremark Row = 1 value = idvalue 0
Mapped appamt Row = 1 value = 0 idvalue 0
>>Validating tacwk
>>Frame No 1
moduletype = Gratuitous Relief
entrytype = Relief Assistance Form
tablename = cm_activityform
recid = 13014000000168
viewcode = 0
actionbyrole = mobileuser
actionbyuser = mobileuser1
action = Create
nextrole = Patwari
nextuser = 38653
remark =
systemremark =
appamt = 0
appamt after validation = 0.00
>>Writing to tables tacwk
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tacwk'
Time elapsed = 7
Saving to table TRN_ACTIONHISTORY
select * from TRN_ACTIONHISTORY where TRN_ACTIONHISTORYid=0
Time elapsed = 23
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 = 9
RecordId = 13014000000184
MapName tscaf1
SourceId 13014000000168
Select sysdate as sdt from dual
Time elapsed = 43
Select sysdate as sdt from dual
Time elapsed = 24
nextuser = 38653
nextrole = Patwari
action = Create
appamt = 0.00
systemremark =
remark =
actionbyuser = mobileuser1
tablename = cm_activityform
entrytype = Relief Assistance Form
moduletype = Gratuitous Relief
actionbyrole = mobileuser
viewcode = 0
recid = 13014000000168
Posting record
Param Type = n
trn_actionhistoryid=13014000000184
Param Type = c
mapname=tscaf1
Param Type = n
sourceid=13014000000168
Param Type = c
cancel=F
Param Type = c
createdby=mobileuser1
Param Type = c
createdon=04/10/2025 12:31:08
Param Type = c
username=mobileuser1
Param Type = c
modifiedon=04/10/2025 12:31:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
nextuser=38653
Param Type = c
nextrole=Patwari
Param Type = c
action=Create
Param Type = n
appamt=0
Param Type = c
actionbyuser=mobileuser1
Param Type = c
tablename=cm_activityform
Param Type = c
entrytype=Relief Assistance Form
Param Type = c
moduletype=Gratuitous Relief
Param Type = c
actionbyrole=mobileuser
Param Type = c
viewcode=0
Param Type = c
recid=13014000000168
insert into TRN_ACTIONHISTORY (trn_actionhistoryid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,nextuser,nextrole,action,appamt,systemremark,remark,actionbyuser,tablename,entrytype,moduletype,actionbyrole,viewcode,recid) values (:trn_actionhistoryid,:mapname,: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,:nextuser,:nextrole,:action,:appamt,null,null,:actionbyuser,:tablename,:entrytype,:moduletype,:actionbyrole,:viewcode,:recid)
Time elapsed for Gen Map = 3968742650500
Time elapsed for MD Map = 3968742650506
Time elapsed for Save History = 3968742650512
Time elapsed for Save Attachment = 3968742650519
Time elapsed for After Save WF Exec = 3968742650528
Transaction commited
Result : {"message":[{"msg":"Relief Assistance Form Saved","Registration No.":"AR/AJME/2025/126271","recordid":"13014000000168"}]}
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=mobileuser1
Param Type = c
calledon=04/10/2025 12:30:37
Param Type = c
callfinished=04/10/2025 12:30:51
Param Type = c
structname=tscaf
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=13725
Param Type = n
dbtimetaken=7110
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