eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_008 dependencies on IGS_AD_STAT_INT_ALL

Line 3939: FROM igs_ad_stat_int_all mi, igs_ad_interface_all i

3935: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
3936:
3937: CURSOR per_stat(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
3938: SELECT mi.*, i.person_id pid
3939: FROM igs_ad_stat_int_all mi, igs_ad_interface_all i
3940: WHERE mi.interface_run_id = cp_interface_run_id
3941: AND mi.interface_id = i.interface_id
3942: AND i.interface_run_id = cp_interface_run_id
3943: AND mi.status = '2'

Line 3990: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E205','IGS_AD_STAT_INT_ALL');

3986: p_success := 'N';
3987: p_error_code := 'E205';
3988:
3989: IF l_enable_log = 'Y' THEN
3990: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E205','IGS_AD_STAT_INT_ALL');
3991: END IF;
3992:
3993: UPDATE igs_ad_stat_int_all
3994: SET error_code = 'E205',

Line 3993: UPDATE igs_ad_stat_int_all

3989: IF l_enable_log = 'Y' THEN
3990: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E205','IGS_AD_STAT_INT_ALL');
3991: END IF;
3992:
3993: UPDATE igs_ad_stat_int_all
3994: SET error_code = 'E205',
3995: status = '3'
3996: WHERE interface_stat_id = p_per_stat.interface_stat_id;
3997: RETURN;

Line 4010: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E206','IGS_AD_STAT_INT_ALL');

4006: p_success := 'N';
4007: p_error_code := 'E206';
4008:
4009: IF l_enable_log = 'Y' THEN
4010: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E206','IGS_AD_STAT_INT_ALL');
4011: END IF;
4012:
4013: UPDATE igs_ad_stat_int_all
4014: SET error_code = 'E206',

Line 4013: UPDATE igs_ad_stat_int_all

4009: IF l_enable_log = 'Y' THEN
4010: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E206','IGS_AD_STAT_INT_ALL');
4011: END IF;
4012:
4013: UPDATE igs_ad_stat_int_all
4014: SET error_code = 'E206',
4015: status = '3'
4016: WHERE interface_stat_id = p_per_stat.interface_stat_id;
4017: RETURN;

Line 4065: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E277','IGS_AD_STAT_INT_ALL');

4061: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4062: END IF;
4063:
4064: IF l_enable_log = 'Y' THEN
4065: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E277','IGS_AD_STAT_INT_ALL');
4066: END IF;
4067:
4068: UPDATE igs_ad_stat_int_all
4069: SET error_code = 'E277',

Line 4068: UPDATE igs_ad_stat_int_all

4064: IF l_enable_log = 'Y' THEN
4065: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E277','IGS_AD_STAT_INT_ALL');
4066: END IF;
4067:
4068: UPDATE igs_ad_stat_int_all
4069: SET error_code = 'E277',
4070: status = '3'
4071: WHERE interface_stat_id = p_per_stat.interface_stat_id;
4072: RETURN;

Line 4087: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E207','IGS_AD_STAT_INT_ALL');

4083: p_success := 'N';
4084: p_error_code := 'E207';
4085:
4086: IF l_enable_log = 'Y' THEN
4087: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E207','IGS_AD_STAT_INT_ALL');
4088: END IF;
4089:
4090: UPDATE igs_ad_stat_int_all
4091: SET error_code = 'E207',

Line 4090: UPDATE igs_ad_stat_int_all

4086: IF l_enable_log = 'Y' THEN
4087: igs_ad_imp_001.logerrormessage(p_per_stat.interface_stat_id,'E207','IGS_AD_STAT_INT_ALL');
4088: END IF;
4089:
4090: UPDATE igs_ad_stat_int_all
4091: SET error_code = 'E207',
4092: status = '3'
4093: WHERE interface_stat_id = p_per_stat.interface_stat_id;
4094:

Line 4145: UPDATE IGS_AD_STAT_INT_ALL

4141: END IF;
4142: EXCEPTION
4143: WHEN NO_DATA_FOUND THEN
4144: L_MSG_DATA := SQLERRM;
4145: UPDATE IGS_AD_STAT_INT_ALL
4146: SET status = '3',
4147: error_code = 'E170'
4148: WHERE interface_id = stat_rec.INTERFACE_ID;
4149:

Line 4176: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E170','IGS_AD_STAT_INT_ALL');

4172: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4173: END IF;
4174:
4175: IF l_enable_log = 'Y' THEN
4176: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E170','IGS_AD_STAT_INT_ALL');
4177: END IF;
4178:
4179:
4180:

Line 4343: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');

4339: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4340: END IF;
4341:
4342: IF l_enable_log = 'Y' THEN
4343: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');
4344: END IF;
4345: ELSE
4346: p_status :='1';
4347: p_error_code := NULL;

Line 4393: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');

4389: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4390: END IF;
4391:
4392: IF l_enable_log = 'Y' THEN
4393: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');
4394: END IF;
4395:
4396: END Crt_Pe_Stat; -- end of local procedure crt_pe_stat
4397:

Line 4427: UPDATE IGS_AD_STAT_INT_all

4423: --ssomani, corrected the looping 15 March 2001
4424:
4425: --1. If rule is E or I, then if the match_ind is not null, the combination is invalid
4426: IF l_rule IN ('E','I') THEN
4427: UPDATE IGS_AD_STAT_INT_all
4428: SET status = '3',
4429: ERROR_CODE = 'E695' -- Error code depicting incorrect combination
4430: WHERE match_ind IS NOT NULL
4431: AND status = '2'

Line 4437: UPDATE IGS_AD_STAT_INT_all mi

4433: END IF;
4434:
4435: --2 If rule is E and duplicate exists, update match_ind to 19 and status to 1
4436: IF l_rule = 'E' THEN
4437: UPDATE IGS_AD_STAT_INT_all mi
4438: SET status = '1',
4439: match_ind = '19'
4440: WHERE mi.interface_run_id = l_interface_run_id
4441: AND mi.status = '2'

Line 4452: UPDATE IGS_AD_STAT_INT_all

4448:
4449: --3 If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
4450: -- processed in prior runs and didn't get updated .. update to status 1
4451: IF l_rule = 'R' THEN
4452: UPDATE IGS_AD_STAT_INT_all
4453: SET status = '1'
4454: WHERE interface_run_id = l_interface_run_id
4455: AND match_ind IN ('18','19','22','23')
4456: AND status = '2';

Line 4461: UPDATE IGS_AD_STAT_INT_all

4457: END IF;
4458:
4459: --4 If rule is R and match_ind is neither 21 nor 25 then error
4460: IF l_rule = 'R' THEN
4461: UPDATE IGS_AD_STAT_INT_all
4462: SET status = '3',
4463: ERROR_CODE = 'E695'
4464: WHERE interface_run_id = l_interface_run_id
4465: AND status = '2'

Line 4471: UPDATE IGS_AD_STAT_INT_all mi

4467: END IF;
4468:
4469: --5 If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
4470: IF l_rule = 'R' THEN
4471: UPDATE IGS_AD_STAT_INT_all mi
4472: SET status = '1',
4473: match_ind = '23'
4474: WHERE mi.interface_run_id = l_interface_run_id
4475: AND mi.match_ind IS NULL

Line 4518: UPDATE IGS_AD_STAT_INT_all mi

4514: END IF;
4515:
4516: --6 If rule is R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
4517: IF l_rule = 'R' THEN
4518: UPDATE IGS_AD_STAT_INT_all mi
4519: SET status = '3',
4520: match_ind = '20'
4521: WHERE mi.interface_run_id = l_interface_run_id
4522: AND mi.match_ind IS NULL

Line 4740: UPDATE igs_ad_stat_int_all

4736: x_birth_cntry_resn_code => NULL --- prbhardw
4737: );
4738:
4739: IF l_return_status IN('E','U') THEN
4740: UPDATE igs_ad_stat_int_all
4741: SET status = '3',error_code = 'E014'
4742: WHERE interface_id = stat_rec.interface_id
4743: AND interface_stat_id = stat_rec.interface_stat_id;
4744:

Line 4766: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E014','IGS_AD_STAT_INT_ALL');

4762: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4763: END IF;
4764:
4765: IF l_enable_log = 'Y' THEN
4766: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E014','IGS_AD_STAT_INT_ALL');
4767: END IF;
4768: ELSE
4769: UPDATE
4770: igs_ad_stat_int_all

Line 4770: igs_ad_stat_int_all

4766: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E014','IGS_AD_STAT_INT_ALL');
4767: END IF;
4768: ELSE
4769: UPDATE
4770: igs_ad_stat_int_all
4771: SET
4772: error_code = NULL, --ssomani, added this 15 March 2001
4773: status = '1', match_ind = '18'
4774: WHERE

Line 4784: UPDATE igs_ad_stat_int_all

4780: END IF; --l_success =Y for Stat validation.
4781: EXCEPTION
4782: WHEN OTHERS THEN
4783: l_msg_data := SQLERRM;
4784: UPDATE igs_ad_stat_int_all
4785: SET status = '3',
4786: error_code = 'E518'
4787: WHERE interface_id = stat_rec.interface_id
4788: AND interface_stat_id = stat_rec.interface_stat_id;

Line 4811: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E518','IGS_AD_STAT_INT_ALL');

4807: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4808: END IF;
4809:
4810: IF l_enable_log = 'Y' THEN
4811: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E518','IGS_AD_STAT_INT_ALL');
4812: END IF;
4813: END;
4814:
4815: ELSIF l_rule = 'R' THEN

Line 4922: UPDATE igs_ad_stat_int_all

4918: );
4919:
4920:
4921: IF l_return_status IN('E','U') THEN
4922: UPDATE igs_ad_stat_int_all
4923: SET status = '3',
4924: error_code = 'E014'
4925: WHERE interface_id = stat_rec.interface_id
4926: AND interface_stat_id = stat_rec.interface_stat_id;

Line 4949: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E014','IGS_AD_STAT_INT_ALL');

4945: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4946: END IF;
4947:
4948: IF l_enable_log = 'Y' THEN
4949: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E014','IGS_AD_STAT_INT_ALL');
4950: END IF;
4951:
4952:
4953: ELSE

Line 4954: UPDATE igs_ad_stat_int_all

4950: END IF;
4951:
4952:
4953: ELSE
4954: UPDATE igs_ad_stat_int_all
4955: SET status = '1', ERROR_CODE = NULL, match_ind = '18'
4956: WHERE
4957: interface_id = stat_rec.interface_id
4958: AND interface_stat_id = stat_rec.interface_stat_id;

Line 4964: igs_ad_stat_int_all

4960: END IF; -- for dff
4961:
4962: ELSE -- else l_success = 'N'
4963: UPDATE
4964: igs_ad_stat_int_all
4965: SET
4966:
4967: status = '3',
4968: error_code = p_error_code

Line 4995: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,p_error_code,'IGS_AD_STAT_INT_ALL');

4991: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4992: END IF;
4993:
4994: IF l_enable_log = 'Y' THEN
4995: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,p_error_code,'IGS_AD_STAT_INT_ALL');
4996: END IF;
4997:
4998:
4999: END IF; -- null handling

Line 5002: UPDATE igs_ad_stat_int_all

4998:
4999: END IF; -- null handling
5000:
5001: EXCEPTION WHEN OTHERS THEN
5002: UPDATE igs_ad_stat_int_all
5003: SET
5004:
5005: status = '3',
5006: error_code = 'E014'

Line 5032: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E014','IGS_AD_STAT_INT_ALL');

5028: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5029: END IF;
5030:
5031: IF l_enable_log = 'Y' THEN
5032: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E014','IGS_AD_STAT_INT_ALL');
5033: END IF;
5034:
5035: END;
5036: END IF;--end if for match_ind = '21'

Line 5040: UPDATE igs_ad_stat_int_all

5036: END IF;--end if for match_ind = '21'
5037: END IF;-- end if for l_rule = 'e'
5038: ELSE
5039: Crt_Pe_Stat(stat_rec =>stat_rec, p_status =>l_status, p_error_code=>l_error_code );
5040: UPDATE igs_ad_stat_int_all
5041: SET status = l_status,error_code = l_error_code
5042: WHERE interface_id = stat_rec.interface_id
5043: AND interface_stat_id = stat_rec.interface_stat_id;
5044: END IF;

Line 5051: UPDATE igs_ad_stat_int_all

5047: WHEN OTHERS THEN
5048: IF chk_dup_cur%ISOPEN THEN
5049: CLOSE chk_dup_cur;
5050: END IF;
5051: UPDATE igs_ad_stat_int_all
5052: SET status = '3',error_code = 'E518'
5053: WHERE interface_id = stat_rec.interface_id
5054: AND interface_stat_id = stat_rec.interface_stat_id;
5055:

Line 5078: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E518','IGS_AD_STAT_INT_ALL');

5074: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5075: END IF;
5076:
5077: IF l_enable_log = 'Y' THEN
5078: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E518','IGS_AD_STAT_INT_ALL');
5079: END IF;
5080:
5081: END;
5082: