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_006

Line 1: PACKAGE BODY Igs_Ad_Imp_006 AS

1: PACKAGE BODY Igs_Ad_Imp_006 AS
2: /* $Header: IGSAD84B.pls 120.4 2006/06/06 09:37:34 skpandey ship $ */
3: /*
4: /* Change History
5: Who When What

Line 152: l_label := 'igs.plsql.igs_ad_imp_006.crt_pe_alias.begin';

148: IF (l_request_id IS NULL) THEN
149: l_request_id := fnd_global.conc_request_id;
150: END IF;
151:
152: l_label := 'igs.plsql.igs_ad_imp_006.crt_pe_alias.begin';
153: l_debug_str := 'Interface Alias Id : ' || person_alias_rec.INTERFACE_ALIAS_ID;
154:
155: fnd_log.string_with_context( fnd_log.level_procedure,
156: l_label,

Line 204: l_label := 'igs.plsql.igs_ad_imp_006.crt_pe_alias.exception';

200: IF (l_request_id IS NULL) THEN
201: l_request_id := fnd_global.conc_request_id;
202: END IF;
203:
204: l_label := 'igs.plsql.igs_ad_imp_006.crt_pe_alias.exception';
205:
206: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Alias.Crt_Pe_Alias ' ||
207: 'Interface Alias Id : ' || person_alias_rec.INTERFACE_ALIAS_ID ||
208: ' Status : 3 ' || 'ErrorCode : E322 ' || SQLERRM;

Line 206: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Alias.Crt_Pe_Alias ' ||

202: END IF;
203:
204: l_label := 'igs.plsql.igs_ad_imp_006.crt_pe_alias.exception';
205:
206: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Alias.Crt_Pe_Alias ' ||
207: 'Interface Alias Id : ' || person_alias_rec.INTERFACE_ALIAS_ID ||
208: ' Status : 3 ' || 'ErrorCode : E322 ' || SQLERRM;
209:
210: fnd_log.string_with_context( fnd_log.level_exception,

Line 228: l_prog_label := 'igs.plsql.igs_ad_imp_006.prc_pe_alias';

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)
232: LOOP

Line 229: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_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)
232: LOOP
233: l_processed_records := l_processed_records + 1 ;

Line 506: l_label := 'igs.plsql.igs_ad_imp_006.crt_emp_dtls.begin';

502: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
503: IF (l_request_id IS NULL) THEN
504: l_request_id := fnd_global.conc_request_id;
505: END IF;
506: l_label := 'igs.plsql.igs_ad_imp_006.crt_emp_dtls.begin';
507: l_debug_str := 'INTERFACE Emp Id : ' || Person_Emp_Rec.Interface_Emp_Id;
508: fnd_log.string_with_context( fnd_log.level_procedure,
509: l_label,
510: l_debug_str, NULL,

Line 559: l_label := 'igs.plsql.igs_ad_imp_006.crt_emp_dtls.exception';

555: IF (l_request_id IS NULL) THEN
556: l_request_id := fnd_global.conc_request_id;
557: END IF;
558:
559: l_label := 'igs.plsql.igs_ad_imp_006.crt_emp_dtls.exception';
560:
561: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls.crt_emp_dtls ' ||
562: 'INTERFACE Emp Id : ' || IGS_GE_NUMBER.TO_CANN(Person_Emp_Rec.Interface_Emp_Id) ||
563: ' Status : 3 ' || 'ErrorCode : E322 '|| l_msg_data;

Line 561: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls.crt_emp_dtls ' ||

557: END IF;
558:
559: l_label := 'igs.plsql.igs_ad_imp_006.crt_emp_dtls.exception';
560:
561: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls.crt_emp_dtls ' ||
562: 'INTERFACE Emp Id : ' || IGS_GE_NUMBER.TO_CANN(Person_Emp_Rec.Interface_Emp_Id) ||
563: ' Status : 3 ' || 'ErrorCode : E322 '|| l_msg_data;
564:
565: fnd_log.string_with_context( fnd_log.level_exception,

Line 585: l_prog_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_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');
589:

Line 586: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_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');
589:
590: -- 1.If rule is E or I, then if the match_ind is not null, the combination is invalid

Line 801: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.exception: ' || 'e014';

797: IF (l_request_id IS NULL) THEN
798: l_request_id := fnd_global.conc_request_id;
799: END IF;
800:
801: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.exception: ' || 'e014';
802:
803: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||
804: 'INTERFACE Emp Id : ' || IGS_GE_NUMBER.TO_CANN(Person_Emp_Rec.Interface_Emp_Id) ||
805: ' Status : 3 ' || 'ErrorCode : E014 '||l_msg_data;

Line 803: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||

799: END IF;
800:
801: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.exception: ' || 'e014';
802:
803: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||
804: 'INTERFACE Emp Id : ' || IGS_GE_NUMBER.TO_CANN(Person_Emp_Rec.Interface_Emp_Id) ||
805: ' Status : 3 ' || 'ErrorCode : E014 '||l_msg_data;
806:
807: fnd_log.string_with_context( fnd_log.level_exception,

Line 837: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.exception: ' || 'E014';

833: IF (l_request_id IS NULL) THEN
834: l_request_id := fnd_global.conc_request_id;
835: END IF;
836:
837: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.exception: ' || 'E014';
838:
839: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||
840: 'INTERFACE Emp Id : ' || Person_Emp_Rec.Interface_Emp_Id ||
841: ' Status : 3 ' || 'ErrorCode : E014 '||SQLERRM;

Line 839: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||

835: END IF;
836:
837: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.exception: ' || 'E014';
838:
839: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||
840: 'INTERFACE Emp Id : ' || Person_Emp_Rec.Interface_Emp_Id ||
841: ' Status : 3 ' || 'ErrorCode : E014 '||SQLERRM;
842:
843: fnd_log.string_with_context( fnd_log.level_exception,

Line 904: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.exception: '|| 'E014';

900: IF (l_request_id IS NULL) THEN
901: l_request_id := fnd_global.conc_request_id;
902: END IF;
903:
904: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.exception: '|| 'E014';
905:
906: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||
907: 'INTERFACE Emp Id : ' || Person_Emp_Rec.Interface_Emp_Id ||
908: ' Status : 3 ' || 'ErrorCode : E014 '|| l_msg_data;

Line 906: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||

902: END IF;
903:
904: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_empnt_dtls.exception: '|| 'E014';
905:
906: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||
907: 'INTERFACE Emp Id : ' || Person_Emp_Rec.Interface_Emp_Id ||
908: ' Status : 3 ' || 'ErrorCode : E014 '|| l_msg_data;
909:
910: fnd_log.string_with_context( fnd_log.level_exception,

Line 1166: l_label := 'igs.plsql.igs_ad_imp_006.crt_extra_cur.Begin';

1162: IF (l_request_id IS NULL) THEN
1163: l_request_id := fnd_global.conc_request_id;
1164: END IF;
1165:
1166: l_label := 'igs.plsql.igs_ad_imp_006.crt_extra_cur.Begin';
1167: l_debug_str := 'INTERFACE Excurr Id : ' || extracurr_rec.interface_excurr_id;
1168:
1169: fnd_log.string_with_context( fnd_log.level_procedure,
1170: l_label,

Line 1232: l_label := 'igs.plsql.igs_ad_imp_006.crt_extra_cur.exception';

1228: IF (l_request_id IS NULL) THEN
1229: l_request_id := fnd_global.conc_request_id;
1230: END IF;
1231:
1232: l_label := 'igs.plsql.igs_ad_imp_006.crt_extra_cur.exception';
1233:
1234: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Extclr_Dtls ' ||
1235: 'INTERFACE Excurr Id : ' || EXTRACURR_REC.INTERFACE_EXCURR_ID ||
1236: ' Status : 3 ' || 'ErrorCode : E322 '|| l_msg_data;

Line 1234: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Extclr_Dtls ' ||

1230: END IF;
1231:
1232: l_label := 'igs.plsql.igs_ad_imp_006.crt_extra_cur.exception';
1233:
1234: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Extclr_Dtls ' ||
1235: 'INTERFACE Excurr Id : ' || EXTRACURR_REC.INTERFACE_EXCURR_ID ||
1236: ' Status : 3 ' || 'ErrorCode : E322 '|| l_msg_data;
1237:
1238: fnd_log.string_with_context( fnd_log.level_exception,

Line 1271: l_label := 'igs.plsql.Igs_Ad_Imp_006.crt_extra_cur.exception';

1267: IF (l_request_id IS NULL) THEN
1268: l_request_id := fnd_global.conc_request_id;
1269: END IF;
1270:
1271: l_label := 'igs.plsql.Igs_Ad_Imp_006.crt_extra_cur.exception';
1272:
1273: l_debug_str := 'Igs_Ad_Imp_006.Prc_Pe_Extclr_Dtls ' ||
1274: 'INTERFACE Excurr Id : ' || IGS_GE_NUMBER.TO_CANN(EXTRACURR_REC.INTERFACE_EXCURR_ID) ||
1275: ' Status : 3 ' || 'ErrorCode : E322 ' || SQLERRM;

Line 1273: l_debug_str := 'Igs_Ad_Imp_006.Prc_Pe_Extclr_Dtls ' ||

1269: END IF;
1270:
1271: l_label := 'igs.plsql.Igs_Ad_Imp_006.crt_extra_cur.exception';
1272:
1273: l_debug_str := 'Igs_Ad_Imp_006.Prc_Pe_Extclr_Dtls ' ||
1274: 'INTERFACE Excurr Id : ' || IGS_GE_NUMBER.TO_CANN(EXTRACURR_REC.INTERFACE_EXCURR_ID) ||
1275: ' Status : 3 ' || 'ErrorCode : E322 ' || SQLERRM;
1276:
1277: fnd_log.string_with_context( fnd_log.level_exception,

Line 1293: l_prog_label := 'igs.plsql.igs_ad_imp_006.prc_pe_extclr_dtls';

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
1297: FOR extracurr_rec IN extracurr(l_interface_run_id) LOOP

Line 1294: l_label := 'igs.plsql.igs_ad_imp_006.prc_pe_extclr_dtls.';

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
1297: FOR extracurr_rec IN extracurr(l_interface_run_id) LOOP
1298: l_processed_records := l_processed_records + 1;

Line 1316: END Igs_Ad_Imp_006;

1312: END IF;
1313:
1314: END LOOP;
1315: END Prc_Pe_Extclr_Dtls;
1316: END Igs_Ad_Imp_006;