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_006 dependencies on IGS_AD_IMP_001

Line 90: igs_ad_imp_001.logerrormessage(person_alias_rec.interface_alias_id,l_error_code);

86: WHERE interface_alias_id = person_alias_rec.interface_alias_id;
87: -- Call Log detail
88:
89: IF l_enable_log = 'Y' THEN
90: igs_ad_imp_001.logerrormessage(person_alias_rec.interface_alias_id,l_error_code);
91: END IF;
92: RETURN;
93: ELSE
94: l_error_code := NULL; --Validation successful

Line 109: igs_ad_imp_001.logerrormessage(PERSON_ALIAS_REC.INTERFACE_ALIAS_ID,l_error_code);

105: ERROR_CODE = l_error_code
106: WHERE INTERFACE_ALIAS_ID = PERSON_ALIAS_REC.INTERFACE_ALIAS_ID;
107:
108: IF l_enable_log = 'Y' THEN
109: igs_ad_imp_001.logerrormessage(PERSON_ALIAS_REC.INTERFACE_ALIAS_ID,l_error_code);
110: END IF;
111: RETURN;
112: END IF;
113: END IF;

Line 124: igs_ad_imp_001.logerrormessage(PERSON_ALIAS_REC.INTERFACE_ALIAS_ID,l_error_code);

120: SET STATUS = '3',
121: ERROR_CODE = l_error_code
122: WHERE INTERFACE_ALIAS_ID = PERSON_ALIAS_REC.INTERFACE_ALIAS_ID;
123: IF l_enable_log = 'Y' THEN
124: igs_ad_imp_001.logerrormessage(PERSON_ALIAS_REC.INTERFACE_ALIAS_ID,l_error_code);
125: END IF;
126: RETURN;
127: END IF;
128: l_error_code := null;

Line 217: igs_ad_imp_001.logerrormessage(person_alias_rec.INTERFACE_ALIAS_ID,'E322');

213: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
214: END IF;
215:
216: IF l_enable_log = 'Y' THEN
217: igs_ad_imp_001.logerrormessage(person_alias_rec.INTERFACE_ALIAS_ID,'E322');
218: END IF;
219: END Crt_Pe_Alias;
220: -- END OF LOCAL PROCEDURE
221:

Line 227: l_enable_log := igs_ad_imp_001.g_enable_log;

223: -- For every record check whether a corresponding row already exists
224: -- in the table IGS_PE_PERSON_ALIAS
225: -- Update of person alias is removed because there is no primary key based on which the record
226: -- present can be obtained because duplicate records can be created in form.
227: l_enable_log := igs_ad_imp_001.g_enable_log;
228: l_prog_label := 'igs.plsql.igs_ad_imp_006.prc_pe_alias';
229: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_alias.';
230: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
231: FOR person_alias_rec IN alias_cur(l_interface_run_id)

Line 230: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

226: -- present can be obtained because duplicate records can be created in form.
227: l_enable_log := igs_ad_imp_001.g_enable_log;
228: l_prog_label := 'igs.plsql.igs_ad_imp_006.prc_pe_alias';
229: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_alias.';
230: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
231: FOR person_alias_rec IN alias_cur(l_interface_run_id)
232: LOOP
233: l_processed_records := l_processed_records + 1 ;
234: person_alias_rec.start_dt := TRUNC(person_alias_rec.start_dt);

Line 323: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E223');

319: Status = '3'
320: WHERE Interface_Emp_Id = Person_Emp_Rec.Interface_Emp_Id;
321:
322: IF l_enable_log = 'Y' THEN
323: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E223');
324: END IF;
325: CLOSE Validate_Occup_Title;
326: RETURN;
327: END IF;

Line 340: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E212');

336: SET Error_Code = p_error_code,
337: Status = '3'
338: WHERE Interface_Emp_Id = Person_Emp_Rec.Interface_Emp_Id;
339: IF l_enable_log = 'Y' THEN
340: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E212');
341: END IF;
342: RETURN;
343: END IF;
344:

Line 355: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E208');

351: SET Error_Code = p_error_code,
352: Status = '3'
353: WHERE Interface_Emp_Id = Person_Emp_Rec.Interface_Emp_Id;
354: IF l_enable_log = 'Y' THEN
355: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E208');
356: END IF;
357:
358: RETURN;
359: END IF;

Line 373: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);

369: SET Error_Code = p_error_code,
370: Status = '3'
371: WHERE Interface_Emp_Id = Person_Emp_Rec.Interface_Emp_Id;
372: IF l_enable_log = 'Y' THEN
373: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);
374: END IF;
375: RETURN;
376: END IF;
377: END IF;

Line 389: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);

385: SET Error_Code = p_error_code,
386: Status = '3'
387: WHERE Interface_Emp_Id = Person_Emp_Rec.Interface_Emp_Id;
388: IF l_enable_log = 'Y' THEN
389: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);
390: END IF;
391: RETURN;
392: END IF;
393: END IF;

Line 406: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);

402: SET Error_Code = p_error_code,
403: Status = '3'
404: WHERE Interface_Emp_Id = Person_Emp_Rec.Interface_Emp_Id;
405: IF l_enable_log = 'Y' THEN
406: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);
407: END IF;
408: RETURN;
409: END IF;
410: END IF ;

Line 424: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);

420: SET Error_Code = p_error_code,
421: Status = '3'
422: WHERE Interface_Emp_Id = Person_Emp_Rec.Interface_Emp_Id;
423: IF l_enable_log = 'Y' THEN
424: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);
425: END IF;
426: RETURN;
427: END IF;
428: END IF;

Line 442: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);

438: SET Error_Code = p_error_code,
439: Status = '3'
440: WHERE Interface_Emp_Id = Person_Emp_Rec.Interface_Emp_Id;
441: IF l_enable_log = 'Y' THEN
442: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);
443: END IF;
444: RETURN;
445: END IF;
446: END IF;

Line 456: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);

452: SET Error_Code = p_error_code,
453: Status = '3'
454: WHERE Interface_Emp_Id = Person_Emp_Rec.Interface_Emp_Id;
455: IF l_enable_log = 'Y' THEN
456: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);
457: END IF;
458: RETURN;
459: END IF;
460:

Line 472: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);

468: SET Error_Code = p_error_code,
469: Status = '3'
470: WHERE Interface_Emp_Id = Person_Emp_Rec.Interface_Emp_Id;
471: IF l_enable_log = 'Y' THEN
472: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,p_error_code);
473: END IF;
474: RETURN;
475: END IF;
476: CLOSE employer_party_number_cur;

Line 572: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E322');

568: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
569: END IF;
570:
571: IF l_enable_log = 'Y' THEN
572: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E322');
573: END IF;
574: ELSE
575: UPDATE IGS_AD_EMP_INT_all
576: SET status = '1'

Line 583: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

579: END IF;
580: END crt_emp_dtls;
581: ------ End of Local Procedure crt_emp_dtls----
582: BEGIN
583: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
584: l_enable_log := igs_ad_imp_001.g_enable_log;
585: l_prog_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls';
586: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.';
587:

Line 584: l_enable_log := igs_ad_imp_001.g_enable_log;

580: END crt_emp_dtls;
581: ------ End of Local Procedure crt_emp_dtls----
582: BEGIN
583: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
584: l_enable_log := igs_ad_imp_001.g_enable_log;
585: l_prog_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls';
586: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.';
587:
588: l_rule :=Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(P_SOURCE_TYPE_ID,'PERSON_EMPLOYMENT_DETAILS');

Line 588: l_rule :=Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(P_SOURCE_TYPE_ID,'PERSON_EMPLOYMENT_DETAILS');

584: l_enable_log := igs_ad_imp_001.g_enable_log;
585: l_prog_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls';
586: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.';
587:
588: l_rule :=Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(P_SOURCE_TYPE_ID,'PERSON_EMPLOYMENT_DETAILS');
589:
590: -- 1.If rule is E or I, then if the match_ind is not null, the combination is invalid
591: IF l_rule IN ('E','I') THEN
592: UPDATE igs_ad_emp_int_all

Line 814: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E014');

810: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
811: END IF;
812:
813: IF l_enable_log = 'Y' THEN
814: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E014');
815: END IF;
816:
817: ELSE
818: UPDATE igs_ad_emp_int_all

Line 851: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E014');

847: );
848: END IF;
849:
850: IF l_enable_log = 'Y' THEN
851: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E014');
852: END IF;
853: END;
854: ELSIF l_rule = 'R' THEN
855: IF PERSON_EMP_REC.match_ind = '21' THEN

Line 917: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E014');

913: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
914: END IF;
915:
916: IF l_enable_log = 'Y' THEN
917: igs_ad_imp_001.logerrormessage(Person_Emp_Rec.Interface_Emp_Id,'E014');
918: END IF;
919:
920: ELSE
921: UPDATE igs_ad_emp_int_all

Line 1141: igs_ad_imp_001.logerrormessage(EXTRACURR_REC.INTERFACE_EXCURR_ID,p_error_code);

1137: ERROR_CODE = p_error_code
1138: WHERE INTERFACE_EXCURR_ID = EXTRACURR_REC.INTERFACE_EXCURR_ID;
1139:
1140: IF l_enable_log = 'Y' THEN
1141: igs_ad_imp_001.logerrormessage(EXTRACURR_REC.INTERFACE_EXCURR_ID,p_error_code);
1142: END IF;
1143:
1144: END validate_pe_excurr;
1145: -------------End of local procedure validate_pe_excurr ------------

Line 1245: igs_ad_imp_001.logerrormessage(EXTRACURR_REC.INTERFACE_EXCURR_ID,'E322');

1241: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1242: END IF;
1243:
1244: IF l_enable_log = 'Y' THEN
1245: igs_ad_imp_001.logerrormessage(EXTRACURR_REC.INTERFACE_EXCURR_ID,'E322');
1246: END IF;
1247:
1248: ELSE
1249: UPDATE

Line 1284: igs_ad_imp_001.logerrormessage(EXTRACURR_REC.INTERFACE_EXCURR_ID,'E322');

1280: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1281: END IF;
1282:
1283: IF l_enable_log = 'Y' THEN
1284: igs_ad_imp_001.logerrormessage(EXTRACURR_REC.INTERFACE_EXCURR_ID,'E322');
1285: END IF;
1286:
1287: END crt_extra_cur;
1288: -- End Local crt_extra_cur

Line 1292: l_enable_log := igs_ad_imp_001.g_enable_log;

1288: -- End Local crt_extra_cur
1289:
1290: BEGIN
1291:
1292: l_enable_log := igs_ad_imp_001.g_enable_log;
1293: l_prog_label := 'igs.plsql.igs_ad_imp_006.prc_pe_extclr_dtls';
1294: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_extclr_dtls.';
1295: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1296: -- No duplicate check!! Hence, different logic

Line 1295: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

1291:
1292: l_enable_log := igs_ad_imp_001.g_enable_log;
1293: l_prog_label := 'igs.plsql.igs_ad_imp_006.prc_pe_extclr_dtls';
1294: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_extclr_dtls.';
1295: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1296: -- No duplicate check!! Hence, different logic
1297: FOR extracurr_rec IN extracurr(l_interface_run_id) LOOP
1298: l_processed_records := l_processed_records + 1;
1299: