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 FND_MESSAGE

Line 251: FND_MESSAGE.SET_NAME('IGS','IGS_AD_REL_FAIL_PER_NO');

247: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.INTERFACE_RELATIONS_ID;
248: -- Call Log detail
249: IF l_enable_log = 'Y' THEN
250: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E204','IGS_AD_RELATIONS_INT_ALL');
251: FND_MESSAGE.SET_NAME('IGS','IGS_AD_REL_FAIL_PER_NO');
252: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
253: END IF;
254: RETURN;
255: ELSE

Line 252: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

248: -- Call Log detail
249: IF l_enable_log = 'Y' THEN
250: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E204','IGS_AD_RELATIONS_INT_ALL');
251: FND_MESSAGE.SET_NAME('IGS','IGS_AD_REL_FAIL_PER_NO');
252: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
253: END IF;
254: RETURN;
255: ELSE
256: l_person_number := P_Relations_Rec.person_number;

Line 393: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

389: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E452','IGS_AD_RELATIONS_INT_ALL');
390: END IF;
391: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
392: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E452';
393: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
394: fnd_message.set_token('INTERFACE_ID',P_Relations_Rec.Interface_Relations_Id);
395: fnd_message.set_token('ERROR_CD','E452');
396: l_debug_str := fnd_message.get || ' ' || l_msg_data;
397: fnd_log.string_with_context( fnd_log.level_exception,

Line 394: fnd_message.set_token('INTERFACE_ID',P_Relations_Rec.Interface_Relations_Id);

390: END IF;
391: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
392: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E452';
393: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
394: fnd_message.set_token('INTERFACE_ID',P_Relations_Rec.Interface_Relations_Id);
395: fnd_message.set_token('ERROR_CD','E452');
396: l_debug_str := fnd_message.get || ' ' || l_msg_data;
397: fnd_log.string_with_context( fnd_log.level_exception,
398: l_label,

Line 395: fnd_message.set_token('ERROR_CD','E452');

391: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
392: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E452';
393: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
394: fnd_message.set_token('INTERFACE_ID',P_Relations_Rec.Interface_Relations_Id);
395: fnd_message.set_token('ERROR_CD','E452');
396: l_debug_str := fnd_message.get || ' ' || l_msg_data;
397: fnd_log.string_with_context( fnd_log.level_exception,
398: l_label,
399: l_debug_str, NULL,

Line 396: l_debug_str := fnd_message.get || ' ' || l_msg_data;

392: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E452';
393: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
394: fnd_message.set_token('INTERFACE_ID',P_Relations_Rec.Interface_Relations_Id);
395: fnd_message.set_token('ERROR_CD','E452');
396: l_debug_str := fnd_message.get || ' ' || l_msg_data;
397: fnd_log.string_with_context( fnd_log.level_exception,
398: l_label,
399: l_debug_str, NULL,
400: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 454: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

450: END IF;
451:
452: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
453: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E172';
454: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
455: fnd_message.set_token('INTERFACE_ID',P_Relations_Rec.Interface_Relations_Id);
456: fnd_message.set_token('ERROR_CD','E172');
457: l_debug_str := fnd_message.get || ' ' || l_msg_data;
458: fnd_log.string_with_context( fnd_log.level_exception,

Line 455: fnd_message.set_token('INTERFACE_ID',P_Relations_Rec.Interface_Relations_Id);

451:
452: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
453: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E172';
454: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
455: fnd_message.set_token('INTERFACE_ID',P_Relations_Rec.Interface_Relations_Id);
456: fnd_message.set_token('ERROR_CD','E172');
457: l_debug_str := fnd_message.get || ' ' || l_msg_data;
458: fnd_log.string_with_context( fnd_log.level_exception,
459: l_label,

Line 456: fnd_message.set_token('ERROR_CD','E172');

452: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
453: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E172';
454: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
455: fnd_message.set_token('INTERFACE_ID',P_Relations_Rec.Interface_Relations_Id);
456: fnd_message.set_token('ERROR_CD','E172');
457: l_debug_str := fnd_message.get || ' ' || l_msg_data;
458: fnd_log.string_with_context( fnd_log.level_exception,
459: l_label,
460: l_debug_str, NULL,

Line 457: l_debug_str := fnd_message.get || ' ' || l_msg_data;

453: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E172';
454: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
455: fnd_message.set_token('INTERFACE_ID',P_Relations_Rec.Interface_Relations_Id);
456: fnd_message.set_token('ERROR_CD','E172');
457: l_debug_str := fnd_message.get || ' ' || l_msg_data;
458: fnd_log.string_with_context( fnd_log.level_exception,
459: l_label,
460: l_debug_str, NULL,
461: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 480: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

476:
477: EXCEPTION
478: WHEN OTHERS THEN
479: ROLLBACK TO before_creatupdate;
480: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
481: IF l_message_name = ('IGS_PE_PERS_ID_PRD_OVRLP') THEN
482: IF l_enable_log = 'Y' THEN
483: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E290','IGS_AD_RELATIONS_INT_ALL');
484: END IF;

Line 544: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

540: WHEN OTHERS THEN
541: l_msg_data := SQLERRM;
542: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
543: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '|| 'E518';
544: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
545: fnd_message.set_token('INTERFACE_ID',p_relations_rec.interface_relations_id);
546: fnd_message.set_token('ERROR_CD','E518');
547: l_debug_str := fnd_message.get || ' ' || SQLERRM;
548: fnd_log.string_with_context( fnd_log.level_exception,

Line 545: fnd_message.set_token('INTERFACE_ID',p_relations_rec.interface_relations_id);

541: l_msg_data := SQLERRM;
542: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
543: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '|| 'E518';
544: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
545: fnd_message.set_token('INTERFACE_ID',p_relations_rec.interface_relations_id);
546: fnd_message.set_token('ERROR_CD','E518');
547: l_debug_str := fnd_message.get || ' ' || SQLERRM;
548: fnd_log.string_with_context( fnd_log.level_exception,
549: l_label,

Line 546: fnd_message.set_token('ERROR_CD','E518');

542: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
543: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '|| 'E518';
544: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
545: fnd_message.set_token('INTERFACE_ID',p_relations_rec.interface_relations_id);
546: fnd_message.set_token('ERROR_CD','E518');
547: l_debug_str := fnd_message.get || ' ' || SQLERRM;
548: fnd_log.string_with_context( fnd_log.level_exception,
549: l_label,
550: l_debug_str, NULL,

Line 547: l_debug_str := fnd_message.get || ' ' || SQLERRM;

543: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '|| 'E518';
544: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
545: fnd_message.set_token('INTERFACE_ID',p_relations_rec.interface_relations_id);
546: fnd_message.set_token('ERROR_CD','E518');
547: l_debug_str := fnd_message.get || ' ' || SQLERRM;
548: fnd_log.string_with_context( fnd_log.level_exception,
549: l_label,
550: l_debug_str, NULL,
551: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 667: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

663: -- this can happen from the crt_rel_adr also, hence its better to keep when others
664: -- and when no data found separate
665: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
666: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.exception';
667: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
668: fnd_message.set_token('INTERFACE_ID',relations_rec.interface_relations_id);
669: fnd_message.set_token('ERROR_CD','E518');
670: l_debug_str := fnd_message.get || ' ' || SQLERRM;
671: fnd_log.string_with_context( fnd_log.level_exception,

Line 668: fnd_message.set_token('INTERFACE_ID',relations_rec.interface_relations_id);

664: -- and when no data found separate
665: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
666: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.exception';
667: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
668: fnd_message.set_token('INTERFACE_ID',relations_rec.interface_relations_id);
669: fnd_message.set_token('ERROR_CD','E518');
670: l_debug_str := fnd_message.get || ' ' || SQLERRM;
671: fnd_log.string_with_context( fnd_log.level_exception,
672: l_label,

Line 669: fnd_message.set_token('ERROR_CD','E518');

665: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
666: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.exception';
667: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
668: fnd_message.set_token('INTERFACE_ID',relations_rec.interface_relations_id);
669: fnd_message.set_token('ERROR_CD','E518');
670: l_debug_str := fnd_message.get || ' ' || SQLERRM;
671: fnd_log.string_with_context( fnd_log.level_exception,
672: l_label,
673: l_debug_str, NULL,

Line 670: l_debug_str := fnd_message.get || ' ' || SQLERRM;

666: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.exception';
667: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
668: fnd_message.set_token('INTERFACE_ID',relations_rec.interface_relations_id);
669: fnd_message.set_token('ERROR_CD','E518');
670: l_debug_str := fnd_message.get || ' ' || SQLERRM;
671: fnd_log.string_with_context( fnd_log.level_exception,
672: l_label,
673: l_debug_str, NULL,
674: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 857: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

853: l_request_id := fnd_global.conc_request_id;
854: END IF;
855: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception '||'E014';
856:
857: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
858: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
859: fnd_message.set_token('ERROR_CD','E014');
860: l_debug_str := fnd_message.get || ' ' || l_msg_data;
861: fnd_log.string_with_context( fnd_log.level_exception,

Line 858: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);

854: END IF;
855: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception '||'E014';
856:
857: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
858: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
859: fnd_message.set_token('ERROR_CD','E014');
860: l_debug_str := fnd_message.get || ' ' || l_msg_data;
861: fnd_log.string_with_context( fnd_log.level_exception,
862: l_label,

Line 859: fnd_message.set_token('ERROR_CD','E014');

855: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception '||'E014';
856:
857: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
858: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
859: fnd_message.set_token('ERROR_CD','E014');
860: l_debug_str := fnd_message.get || ' ' || l_msg_data;
861: fnd_log.string_with_context( fnd_log.level_exception,
862: l_label,
863: l_debug_str, NULL,

Line 860: l_debug_str := fnd_message.get || ' ' || l_msg_data;

856:
857: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
858: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
859: fnd_message.set_token('ERROR_CD','E014');
860: l_debug_str := fnd_message.get || ' ' || l_msg_data;
861: fnd_log.string_with_context( fnd_log.level_exception,
862: l_label,
863: l_debug_str, NULL,
864: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 883: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

879: l_request_id := fnd_global.conc_request_id;
880: END IF;
881: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.warning '||'E073';
882:
883: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
884: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
885: fnd_message.set_token('ERROR_CD','E073');
886: l_debug_str := fnd_message.get || ' ' || l_msg_data;
887: fnd_log.string_with_context( fnd_log.level_exception,

Line 884: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);

880: END IF;
881: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.warning '||'E073';
882:
883: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
884: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
885: fnd_message.set_token('ERROR_CD','E073');
886: l_debug_str := fnd_message.get || ' ' || l_msg_data;
887: fnd_log.string_with_context( fnd_log.level_exception,
888: l_label,

Line 885: fnd_message.set_token('ERROR_CD','E073');

881: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.warning '||'E073';
882:
883: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
884: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
885: fnd_message.set_token('ERROR_CD','E073');
886: l_debug_str := fnd_message.get || ' ' || l_msg_data;
887: fnd_log.string_with_context( fnd_log.level_exception,
888: l_label,
889: l_debug_str, NULL,

Line 886: l_debug_str := fnd_message.get || ' ' || l_msg_data;

882:
883: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
884: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
885: fnd_message.set_token('ERROR_CD','E073');
886: l_debug_str := fnd_message.get || ' ' || l_msg_data;
887: fnd_log.string_with_context( fnd_log.level_exception,
888: l_label,
889: l_debug_str, NULL,
890: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 930: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

926: IF (l_request_id IS NULL) THEN
927: l_request_id := fnd_global.conc_request_id;
928: END IF;
929: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception1 '||'E244';
930: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
931: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
932: fnd_message.set_token('ERROR_CD','E244');
933: l_debug_str := fnd_message.get || ' ' || l_msg_data;
934: fnd_log.string_with_context( fnd_log.level_exception,

Line 931: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);

927: l_request_id := fnd_global.conc_request_id;
928: END IF;
929: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception1 '||'E244';
930: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
931: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
932: fnd_message.set_token('ERROR_CD','E244');
933: l_debug_str := fnd_message.get || ' ' || l_msg_data;
934: fnd_log.string_with_context( fnd_log.level_exception,
935: l_label,

Line 932: fnd_message.set_token('ERROR_CD','E244');

928: END IF;
929: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception1 '||'E244';
930: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
931: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
932: fnd_message.set_token('ERROR_CD','E244');
933: l_debug_str := fnd_message.get || ' ' || l_msg_data;
934: fnd_log.string_with_context( fnd_log.level_exception,
935: l_label,
936: l_debug_str, NULL,

Line 933: l_debug_str := fnd_message.get || ' ' || l_msg_data;

929: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception1 '||'E244';
930: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
931: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
932: fnd_message.set_token('ERROR_CD','E244');
933: l_debug_str := fnd_message.get || ' ' || l_msg_data;
934: fnd_log.string_with_context( fnd_log.level_exception,
935: l_label,
936: l_debug_str, NULL,
937: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 983: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

979: IF (l_request_id IS NULL) THEN
980: l_request_id := fnd_global.conc_request_id;
981: END IF;
982: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception2 '||'E244';
983: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
984: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
985: fnd_message.set_token('ERROR_CD','E244');
986: l_debug_str := fnd_message.get || ' ' || l_msg_data;
987: fnd_log.string_with_context( fnd_log.level_exception,

Line 984: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);

980: l_request_id := fnd_global.conc_request_id;
981: END IF;
982: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception2 '||'E244';
983: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
984: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
985: fnd_message.set_token('ERROR_CD','E244');
986: l_debug_str := fnd_message.get || ' ' || l_msg_data;
987: fnd_log.string_with_context( fnd_log.level_exception,
988: l_label,

Line 985: fnd_message.set_token('ERROR_CD','E244');

981: END IF;
982: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception2 '||'E244';
983: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
984: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
985: fnd_message.set_token('ERROR_CD','E244');
986: l_debug_str := fnd_message.get || ' ' || l_msg_data;
987: fnd_log.string_with_context( fnd_log.level_exception,
988: l_label,
989: l_debug_str, NULL,

Line 986: l_debug_str := fnd_message.get || ' ' || l_msg_data;

982: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception2 '||'E244';
983: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
984: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
985: fnd_message.set_token('ERROR_CD','E244');
986: l_debug_str := fnd_message.get || ' ' || l_msg_data;
987: fnd_log.string_with_context( fnd_log.level_exception,
988: l_label,
989: l_debug_str, NULL,
990: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 1024: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1020: IF (l_request_id IS NULL) THEN
1021: l_request_id := fnd_global.conc_request_id;
1022: END IF;
1023: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.update_addr_exception'||'E014';
1024: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1025: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1026: fnd_message.set_token('ERROR_CD','E014');
1027: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1028: fnd_log.string_with_context( fnd_log.level_exception,

Line 1025: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);

1021: l_request_id := fnd_global.conc_request_id;
1022: END IF;
1023: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.update_addr_exception'||'E014';
1024: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1025: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1026: fnd_message.set_token('ERROR_CD','E014');
1027: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1028: fnd_log.string_with_context( fnd_log.level_exception,
1029: l_label,

Line 1026: fnd_message.set_token('ERROR_CD','E014');

1022: END IF;
1023: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.update_addr_exception'||'E014';
1024: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1025: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1026: fnd_message.set_token('ERROR_CD','E014');
1027: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1028: fnd_log.string_with_context( fnd_log.level_exception,
1029: l_label,
1030: l_debug_str, NULL,

Line 1027: l_debug_str := fnd_message.get || ' ' || SQLERRM;

1023: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.update_addr_exception'||'E014';
1024: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1025: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1026: fnd_message.set_token('ERROR_CD','E014');
1027: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1028: fnd_log.string_with_context( fnd_log.level_exception,
1029: l_label,
1030: l_debug_str, NULL,
1031: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 1400: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1396: IF (l_request_id IS NULL) THEN
1397: l_request_id := fnd_global.conc_request_id;
1398: END IF;
1399: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception1 '||'E322';
1400: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1401: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1402: fnd_message.set_token('ERROR_CD','E322');
1403: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1404: fnd_log.string_with_context( fnd_log.level_exception,

Line 1401: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);

1397: l_request_id := fnd_global.conc_request_id;
1398: END IF;
1399: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception1 '||'E322';
1400: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1401: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1402: fnd_message.set_token('ERROR_CD','E322');
1403: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1404: fnd_log.string_with_context( fnd_log.level_exception,
1405: l_label,

Line 1402: fnd_message.set_token('ERROR_CD','E322');

1398: END IF;
1399: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception1 '||'E322';
1400: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1401: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1402: fnd_message.set_token('ERROR_CD','E322');
1403: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1404: fnd_log.string_with_context( fnd_log.level_exception,
1405: l_label,
1406: l_debug_str, NULL,

Line 1403: l_debug_str := fnd_message.get || ' ' || l_msg_data;

1399: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception1 '||'E322';
1400: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1401: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1402: fnd_message.set_token('ERROR_CD','E322');
1403: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1404: fnd_log.string_with_context( fnd_log.level_exception,
1405: l_label,
1406: l_debug_str, NULL,
1407: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 1425: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1421: IF (l_request_id IS NULL) THEN
1422: l_request_id := fnd_global.conc_request_id;
1423: END IF;
1424: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.warning '||'E073';
1425: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1426: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1427: fnd_message.set_token('ERROR_CD','E073');
1428: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1429: fnd_log.string_with_context( fnd_log.level_exception,

Line 1426: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);

1422: l_request_id := fnd_global.conc_request_id;
1423: END IF;
1424: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.warning '||'E073';
1425: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1426: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1427: fnd_message.set_token('ERROR_CD','E073');
1428: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1429: fnd_log.string_with_context( fnd_log.level_exception,
1430: l_label,

Line 1427: fnd_message.set_token('ERROR_CD','E073');

1423: END IF;
1424: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.warning '||'E073';
1425: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1426: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1427: fnd_message.set_token('ERROR_CD','E073');
1428: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1429: fnd_log.string_with_context( fnd_log.level_exception,
1430: l_label,
1431: l_debug_str, NULL,

Line 1428: l_debug_str := fnd_message.get || ' ' || l_msg_data;

1424: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.warning '||'E073';
1425: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1426: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1427: fnd_message.set_token('ERROR_CD','E073');
1428: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1429: fnd_log.string_with_context( fnd_log.level_exception,
1430: l_label,
1431: l_debug_str, NULL,
1432: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 1472: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1468: IF (l_request_id IS NULL) THEN
1469: l_request_id := fnd_global.conc_request_id;
1470: END IF;
1471: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception2 '||'E322';
1472: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1473: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1474: fnd_message.set_token('ERROR_CD','E322');
1475: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1476: fnd_log.string_with_context( fnd_log.level_exception,

Line 1473: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);

1469: l_request_id := fnd_global.conc_request_id;
1470: END IF;
1471: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception2 '||'E322';
1472: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1473: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1474: fnd_message.set_token('ERROR_CD','E322');
1475: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1476: fnd_log.string_with_context( fnd_log.level_exception,
1477: l_label,

Line 1474: fnd_message.set_token('ERROR_CD','E322');

1470: END IF;
1471: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception2 '||'E322';
1472: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1473: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1474: fnd_message.set_token('ERROR_CD','E322');
1475: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1476: fnd_log.string_with_context( fnd_log.level_exception,
1477: l_label,
1478: l_debug_str, NULL,

Line 1475: l_debug_str := fnd_message.get || ' ' || l_msg_data;

1471: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception2 '||'E322';
1472: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1473: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1474: fnd_message.set_token('ERROR_CD','E322');
1475: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1476: fnd_log.string_with_context( fnd_log.level_exception,
1477: l_label,
1478: l_debug_str, NULL,
1479: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 1520: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1516: END IF;
1517:
1518: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception '||'E244';
1519:
1520: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1521: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1522: fnd_message.set_token('ERROR_CD','E244');
1523:
1524: l_debug_str := fnd_message.get || ' ' || l_msg_data;

Line 1521: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);

1517:
1518: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception '||'E244';
1519:
1520: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1521: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1522: fnd_message.set_token('ERROR_CD','E244');
1523:
1524: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1525:

Line 1522: fnd_message.set_token('ERROR_CD','E244');

1518: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception '||'E244';
1519:
1520: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1521: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1522: fnd_message.set_token('ERROR_CD','E244');
1523:
1524: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1525:
1526: fnd_log.string_with_context( fnd_log.level_exception,

Line 1524: l_debug_str := fnd_message.get || ' ' || l_msg_data;

1520: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1521: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1522: fnd_message.set_token('ERROR_CD','E244');
1523:
1524: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1525:
1526: fnd_log.string_with_context( fnd_log.level_exception,
1527: l_label,
1528: l_debug_str, NULL,

Line 1561: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1557: END IF;
1558:
1559: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception '||'E518';
1560:
1561: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1562: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1563: fnd_message.set_token('ERROR_CD','E518');
1564:
1565: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1562: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);

1558:
1559: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception '||'E518';
1560:
1561: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1562: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1563: fnd_message.set_token('ERROR_CD','E518');
1564:
1565: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1566:

Line 1563: fnd_message.set_token('ERROR_CD','E518');

1559: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception '||'E518';
1560:
1561: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1562: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1563: fnd_message.set_token('ERROR_CD','E518');
1564:
1565: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1566:
1567: fnd_log.string_with_context( fnd_log.level_exception,

Line 1565: l_debug_str := fnd_message.get || ' ' || SQLERRM;

1561: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1562: fnd_message.set_token('INTERFACE_ID',reladdr_rec.interface_reladdr_id);
1563: fnd_message.set_token('ERROR_CD','E518');
1564:
1565: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1566:
1567: fnd_log.string_with_context( fnd_log.level_exception,
1568: l_label,
1569: l_debug_str, NULL,

Line 2159: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

2155: END IF;
2156:
2157: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception';
2158:
2159: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2160: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2161: fnd_message.set_token('ERROR_CD','E014');
2162:
2163: l_debug_str := fnd_message.get || ' ' || l_msg_data;

Line 2160: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);

2156:
2157: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception';
2158:
2159: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2160: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2161: fnd_message.set_token('ERROR_CD','E014');
2162:
2163: l_debug_str := fnd_message.get || ' ' || l_msg_data;
2164:

Line 2161: fnd_message.set_token('ERROR_CD','E014');

2157: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception';
2158:
2159: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2160: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2161: fnd_message.set_token('ERROR_CD','E014');
2162:
2163: l_debug_str := fnd_message.get || ' ' || l_msg_data;
2164:
2165: fnd_log.string_with_context( fnd_log.level_exception,

Line 2163: l_debug_str := fnd_message.get || ' ' || l_msg_data;

2159: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2160: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2161: fnd_message.set_token('ERROR_CD','E014');
2162:
2163: l_debug_str := fnd_message.get || ' ' || l_msg_data;
2164:
2165: fnd_log.string_with_context( fnd_log.level_exception,
2166: l_label,
2167: l_debug_str, NULL,

Line 2245: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

2241: END IF;
2242:
2243: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception '||'E014';
2244:
2245: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2246: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2247: fnd_message.set_token('ERROR_CD','E014');
2248:
2249: l_debug_str := fnd_message.get || ' ' || l_msg_data;

Line 2246: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);

2242:
2243: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception '||'E014';
2244:
2245: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2246: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2247: fnd_message.set_token('ERROR_CD','E014');
2248:
2249: l_debug_str := fnd_message.get || ' ' || l_msg_data;
2250:

Line 2247: fnd_message.set_token('ERROR_CD','E014');

2243: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception '||'E014';
2244:
2245: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2246: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2247: fnd_message.set_token('ERROR_CD','E014');
2248:
2249: l_debug_str := fnd_message.get || ' ' || l_msg_data;
2250:
2251: fnd_log.string_with_context( fnd_log.level_exception,

Line 2249: l_debug_str := fnd_message.get || ' ' || l_msg_data;

2245: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2246: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2247: fnd_message.set_token('ERROR_CD','E014');
2248:
2249: l_debug_str := fnd_message.get || ' ' || l_msg_data;
2250:
2251: fnd_log.string_with_context( fnd_log.level_exception,
2252: l_label,
2253: l_debug_str, NULL,

Line 2284: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

2280: END IF;
2281:
2282: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception '||'E518';
2283:
2284: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2285: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2286: fnd_message.set_token('ERROR_CD','E518');
2287:
2288: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 2285: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);

2281:
2282: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception '||'E518';
2283:
2284: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2285: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2286: fnd_message.set_token('ERROR_CD','E518');
2287:
2288: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2289:

Line 2286: fnd_message.set_token('ERROR_CD','E518');

2282: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception '||'E518';
2283:
2284: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2285: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2286: fnd_message.set_token('ERROR_CD','E518');
2287:
2288: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2289:
2290: fnd_log.string_with_context( fnd_log.level_exception,

Line 2288: l_debug_str := fnd_message.get || ' ' || SQLERRM;

2284: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2285: fnd_message.set_token('INTERFACE_ID',relcon_rec.interface_rel_con_id);
2286: fnd_message.set_token('ERROR_CD','E518');
2287:
2288: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2289:
2290: fnd_log.string_with_context( fnd_log.level_exception,
2291: l_label,
2292: l_debug_str, NULL,

Line 3297: fnd_message.set_name('igs', 'igs_ad_crt_emp_dtl_failed');

3293: X_MODE => 'R' );
3294:
3295: IF l_return_Status IN ('E','U') THEN
3296: IF l_enable_log = 'Y' THEN
3297: fnd_message.set_name('igs', 'igs_ad_crt_emp_dtl_failed');
3298: fnd_file.put_line(fnd_file.log, fnd_message.get);
3299: -- Log the message Employment Details failed
3300: igs_ad_imp_001.logerrormessage(p_relemp_rec.interface_relemp_id,'E322','IGS_AD_RELEMP_INT_ALL');
3301: END IF;

Line 3298: fnd_file.put_line(fnd_file.log, fnd_message.get);

3294:
3295: IF l_return_Status IN ('E','U') THEN
3296: IF l_enable_log = 'Y' THEN
3297: fnd_message.set_name('igs', 'igs_ad_crt_emp_dtl_failed');
3298: fnd_file.put_line(fnd_file.log, fnd_message.get);
3299: -- Log the message Employment Details failed
3300: igs_ad_imp_001.logerrormessage(p_relemp_rec.interface_relemp_id,'E322','IGS_AD_RELEMP_INT_ALL');
3301: END IF;
3302:

Line 3308: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

3304: IF (l_request_id IS NULL) THEN
3305: l_request_id := fnd_global.conc_request_id;
3306: END IF;
3307: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.exception';
3308: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3309: fnd_message.set_token('INTERFACE_ID',p_relemp_rec.interface_relemp_id);
3310: fnd_message.set_token('ERROR_CD','E322');
3311: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3312: fnd_log.string_with_context( fnd_log.level_exception,

Line 3309: fnd_message.set_token('INTERFACE_ID',p_relemp_rec.interface_relemp_id);

3305: l_request_id := fnd_global.conc_request_id;
3306: END IF;
3307: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.exception';
3308: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3309: fnd_message.set_token('INTERFACE_ID',p_relemp_rec.interface_relemp_id);
3310: fnd_message.set_token('ERROR_CD','E322');
3311: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3312: fnd_log.string_with_context( fnd_log.level_exception,
3313: l_label,

Line 3310: fnd_message.set_token('ERROR_CD','E322');

3306: END IF;
3307: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.exception';
3308: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3309: fnd_message.set_token('INTERFACE_ID',p_relemp_rec.interface_relemp_id);
3310: fnd_message.set_token('ERROR_CD','E322');
3311: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3312: fnd_log.string_with_context( fnd_log.level_exception,
3313: l_label,
3314: l_debug_str, NULL,

Line 3311: l_debug_str := fnd_message.get || ' ' || l_msg_data;

3307: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.exception';
3308: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3309: fnd_message.set_token('INTERFACE_ID',p_relemp_rec.interface_relemp_id);
3310: fnd_message.set_token('ERROR_CD','E322');
3311: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3312: fnd_log.string_with_context( fnd_log.level_exception,
3313: l_label,
3314: l_debug_str, NULL,
3315: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 3335: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

3331: l_request_id := fnd_global.conc_request_id;
3332: END IF;
3333:
3334: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.exception '||'E518';
3335: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3336: fnd_message.set_token('INTERFACE_ID',p_relemp_rec.interface_relemp_id);
3337: fnd_message.set_token('ERROR_CD','E518');
3338: l_debug_str := fnd_message.get || ' ' || SQLERRM;
3339: fnd_log.string_with_context( fnd_log.level_exception,

Line 3336: fnd_message.set_token('INTERFACE_ID',p_relemp_rec.interface_relemp_id);

3332: END IF;
3333:
3334: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.exception '||'E518';
3335: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3336: fnd_message.set_token('INTERFACE_ID',p_relemp_rec.interface_relemp_id);
3337: fnd_message.set_token('ERROR_CD','E518');
3338: l_debug_str := fnd_message.get || ' ' || SQLERRM;
3339: fnd_log.string_with_context( fnd_log.level_exception,
3340: l_label,

Line 3337: fnd_message.set_token('ERROR_CD','E518');

3333:
3334: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.exception '||'E518';
3335: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3336: fnd_message.set_token('INTERFACE_ID',p_relemp_rec.interface_relemp_id);
3337: fnd_message.set_token('ERROR_CD','E518');
3338: l_debug_str := fnd_message.get || ' ' || SQLERRM;
3339: fnd_log.string_with_context( fnd_log.level_exception,
3340: l_label,
3341: l_debug_str, NULL,

Line 3338: l_debug_str := fnd_message.get || ' ' || SQLERRM;

3334: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.exception '||'E518';
3335: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3336: fnd_message.set_token('INTERFACE_ID',p_relemp_rec.interface_relemp_id);
3337: fnd_message.set_token('ERROR_CD','E518');
3338: l_debug_str := fnd_message.get || ' ' || SQLERRM;
3339: fnd_log.string_with_context( fnd_log.level_exception,
3340: l_label,
3341: l_debug_str, NULL,
3342: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 3753: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

3749: l_request_id := fnd_global.conc_request_id;
3750: END IF;
3751: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.exception '||'E014';
3752:
3753: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3754: fnd_message.set_token('INTERFACE_ID',relns_emp_dtls_rec.interface_relemp_id);
3755: fnd_message.set_token('ERROR_CD','E014');
3756:
3757: l_debug_str := fnd_message.get || ' ' || l_msg_data;

Line 3754: fnd_message.set_token('INTERFACE_ID',relns_emp_dtls_rec.interface_relemp_id);

3750: END IF;
3751: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.exception '||'E014';
3752:
3753: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3754: fnd_message.set_token('INTERFACE_ID',relns_emp_dtls_rec.interface_relemp_id);
3755: fnd_message.set_token('ERROR_CD','E014');
3756:
3757: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3758: fnd_log.string_with_context( fnd_log.level_exception,

Line 3755: fnd_message.set_token('ERROR_CD','E014');

3751: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.exception '||'E014';
3752:
3753: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3754: fnd_message.set_token('INTERFACE_ID',relns_emp_dtls_rec.interface_relemp_id);
3755: fnd_message.set_token('ERROR_CD','E014');
3756:
3757: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3758: fnd_log.string_with_context( fnd_log.level_exception,
3759: l_label,

Line 3757: l_debug_str := fnd_message.get || ' ' || l_msg_data;

3753: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3754: fnd_message.set_token('INTERFACE_ID',relns_emp_dtls_rec.interface_relemp_id);
3755: fnd_message.set_token('ERROR_CD','E014');
3756:
3757: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3758: fnd_log.string_with_context( fnd_log.level_exception,
3759: l_label,
3760: l_debug_str, NULL,
3761: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 3825: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

3821: IF (l_request_id IS NULL) THEN
3822: l_request_id := fnd_global.conc_request_id;
3823: END IF;
3824: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.exception';
3825: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3826: fnd_message.set_token('INTERFACE_ID',relns_emp_dtls_rec.interface_relemp_id);
3827: fnd_message.set_token('ERROR_CD','E014');
3828: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3829: fnd_log.string_with_context( fnd_log.level_exception,

Line 3826: fnd_message.set_token('INTERFACE_ID',relns_emp_dtls_rec.interface_relemp_id);

3822: l_request_id := fnd_global.conc_request_id;
3823: END IF;
3824: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.exception';
3825: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3826: fnd_message.set_token('INTERFACE_ID',relns_emp_dtls_rec.interface_relemp_id);
3827: fnd_message.set_token('ERROR_CD','E014');
3828: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3829: fnd_log.string_with_context( fnd_log.level_exception,
3830: l_label,

Line 3827: fnd_message.set_token('ERROR_CD','E014');

3823: END IF;
3824: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.exception';
3825: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3826: fnd_message.set_token('INTERFACE_ID',relns_emp_dtls_rec.interface_relemp_id);
3827: fnd_message.set_token('ERROR_CD','E014');
3828: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3829: fnd_log.string_with_context( fnd_log.level_exception,
3830: l_label,
3831: l_debug_str, NULL,

Line 3828: l_debug_str := fnd_message.get || ' ' || l_msg_data;

3824: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.exception';
3825: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
3826: fnd_message.set_token('INTERFACE_ID',relns_emp_dtls_rec.interface_relemp_id);
3827: fnd_message.set_token('ERROR_CD','E014');
3828: l_debug_str := fnd_message.get || ' ' || l_msg_data;
3829: fnd_log.string_with_context( fnd_log.level_exception,
3830: l_label,
3831: l_debug_str, NULL,
3832: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 4052: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

4048: END IF;
4049:
4050: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E277';
4051:
4052: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4053: fnd_message.set_token('INTERFACE_ID',p_per_stat.interface_stat_id);
4054: fnd_message.set_token('ERROR_CD','E277');
4055:
4056: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 4053: fnd_message.set_token('INTERFACE_ID',p_per_stat.interface_stat_id);

4049:
4050: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E277';
4051:
4052: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4053: fnd_message.set_token('INTERFACE_ID',p_per_stat.interface_stat_id);
4054: fnd_message.set_token('ERROR_CD','E277');
4055:
4056: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4057:

Line 4054: fnd_message.set_token('ERROR_CD','E277');

4050: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E277';
4051:
4052: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4053: fnd_message.set_token('INTERFACE_ID',p_per_stat.interface_stat_id);
4054: fnd_message.set_token('ERROR_CD','E277');
4055:
4056: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4057:
4058: fnd_log.string_with_context( fnd_log.level_exception,

Line 4056: l_debug_str := fnd_message.get || ' ' || SQLERRM;

4052: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4053: fnd_message.set_token('INTERFACE_ID',p_per_stat.interface_stat_id);
4054: fnd_message.set_token('ERROR_CD','E277');
4055:
4056: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4057:
4058: fnd_log.string_with_context( fnd_log.level_exception,
4059: l_label,
4060: l_debug_str, NULL,

Line 4163: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

4159: END IF;
4160:
4161: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E170';
4162:
4163: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4164: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4165: fnd_message.set_token('ERROR_CD','E170');
4166:
4167: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 4164: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);

4160:
4161: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E170';
4162:
4163: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4164: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4165: fnd_message.set_token('ERROR_CD','E170');
4166:
4167: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4168:

Line 4165: fnd_message.set_token('ERROR_CD','E170');

4161: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E170';
4162:
4163: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4164: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4165: fnd_message.set_token('ERROR_CD','E170');
4166:
4167: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4168:
4169: fnd_log.string_with_context( fnd_log.level_exception,

Line 4167: l_debug_str := fnd_message.get || ' ' || SQLERRM;

4163: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4164: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4165: fnd_message.set_token('ERROR_CD','E170');
4166:
4167: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4168:
4169: fnd_log.string_with_context( fnd_log.level_exception,
4170: l_label,
4171: l_debug_str, NULL,

Line 4330: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

4326: END IF;
4327:
4328: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E005';
4329:
4330: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4331: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4332: fnd_message.set_token('ERROR_CD','E005');
4333:
4334: l_debug_str := fnd_message.get || ' ' || l_msg_data;

Line 4331: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);

4327:
4328: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E005';
4329:
4330: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4331: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4332: fnd_message.set_token('ERROR_CD','E005');
4333:
4334: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4335:

Line 4332: fnd_message.set_token('ERROR_CD','E005');

4328: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E005';
4329:
4330: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4331: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4332: fnd_message.set_token('ERROR_CD','E005');
4333:
4334: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4335:
4336: fnd_log.string_with_context( fnd_log.level_exception,

Line 4334: l_debug_str := fnd_message.get || ' ' || l_msg_data;

4330: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4331: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4332: fnd_message.set_token('ERROR_CD','E005');
4333:
4334: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4335:
4336: fnd_log.string_with_context( fnd_log.level_exception,
4337: l_label,
4338: l_debug_str, NULL,

Line 4380: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

4376: END IF;
4377:
4378: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception2';
4379:
4380: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4381: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4382: fnd_message.set_token('ERROR_CD','E005');
4383:
4384: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 4381: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);

4377:
4378: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception2';
4379:
4380: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4381: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4382: fnd_message.set_token('ERROR_CD','E005');
4383:
4384: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4385:

Line 4382: fnd_message.set_token('ERROR_CD','E005');

4378: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception2';
4379:
4380: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4381: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4382: fnd_message.set_token('ERROR_CD','E005');
4383:
4384: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4385:
4386: fnd_log.string_with_context( fnd_log.level_exception,

Line 4384: l_debug_str := fnd_message.get || ' ' || SQLERRM;

4380: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4381: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4382: fnd_message.set_token('ERROR_CD','E005');
4383:
4384: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4385:
4386: fnd_log.string_with_context( fnd_log.level_exception,
4387: l_label,
4388: l_debug_str, NULL,

Line 4753: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

4749: END IF;
4750:
4751: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E014';
4752:
4753: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4754: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4755: fnd_message.set_token('ERROR_CD','E014');
4756:
4757: l_debug_str := fnd_message.get || ' ' || l_msg_data;

Line 4754: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);

4750:
4751: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E014';
4752:
4753: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4754: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4755: fnd_message.set_token('ERROR_CD','E014');
4756:
4757: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4758:

Line 4755: fnd_message.set_token('ERROR_CD','E014');

4751: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E014';
4752:
4753: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4754: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4755: fnd_message.set_token('ERROR_CD','E014');
4756:
4757: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4758:
4759: fnd_log.string_with_context( fnd_log.level_exception,

Line 4757: l_debug_str := fnd_message.get || ' ' || l_msg_data;

4753: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4754: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4755: fnd_message.set_token('ERROR_CD','E014');
4756:
4757: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4758:
4759: fnd_log.string_with_context( fnd_log.level_exception,
4760: l_label,
4761: l_debug_str, NULL,

Line 4798: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

4794: END IF;
4795:
4796: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E518';
4797:
4798: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4799: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4800: fnd_message.set_token('ERROR_CD','E518');
4801:
4802: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 4799: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);

4795:
4796: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E518';
4797:
4798: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4799: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4800: fnd_message.set_token('ERROR_CD','E518');
4801:
4802: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4803:

Line 4800: fnd_message.set_token('ERROR_CD','E518');

4796: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E518';
4797:
4798: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4799: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4800: fnd_message.set_token('ERROR_CD','E518');
4801:
4802: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4803:
4804: fnd_log.string_with_context( fnd_log.level_exception,

Line 4802: l_debug_str := fnd_message.get || ' ' || SQLERRM;

4798: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4799: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4800: fnd_message.set_token('ERROR_CD','E518');
4801:
4802: l_debug_str := fnd_message.get || ' ' || SQLERRM;
4803:
4804: fnd_log.string_with_context( fnd_log.level_exception,
4805: l_label,
4806: l_debug_str, NULL,

Line 4936: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

4932: END IF;
4933:
4934: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception1';
4935:
4936: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4937: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4938: fnd_message.set_token('ERROR_CD','E014');
4939:
4940: l_debug_str := fnd_message.get || ' ' || l_msg_data;

Line 4937: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);

4933:
4934: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception1';
4935:
4936: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4937: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4938: fnd_message.set_token('ERROR_CD','E014');
4939:
4940: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4941:

Line 4938: fnd_message.set_token('ERROR_CD','E014');

4934: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception1';
4935:
4936: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4937: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4938: fnd_message.set_token('ERROR_CD','E014');
4939:
4940: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4941:
4942: fnd_log.string_with_context( fnd_log.level_exception,

Line 4940: l_debug_str := fnd_message.get || ' ' || l_msg_data;

4936: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4937: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4938: fnd_message.set_token('ERROR_CD','E014');
4939:
4940: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4941:
4942: fnd_log.string_with_context( fnd_log.level_exception,
4943: l_label,
4944: l_debug_str, NULL,

Line 4982: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

4978: END IF;
4979:
4980: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception2';
4981:
4982: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4983: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4984: fnd_message.set_token('ERROR_CD',p_error_code);
4985:
4986: l_debug_str := fnd_message.get || ' ' || l_msg_data;

Line 4983: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);

4979:
4980: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception2';
4981:
4982: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4983: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4984: fnd_message.set_token('ERROR_CD',p_error_code);
4985:
4986: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4987:

Line 4984: fnd_message.set_token('ERROR_CD',p_error_code);

4980: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception2';
4981:
4982: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4983: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4984: fnd_message.set_token('ERROR_CD',p_error_code);
4985:
4986: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4987:
4988: fnd_log.string_with_context( fnd_log.level_exception,

Line 4986: l_debug_str := fnd_message.get || ' ' || l_msg_data;

4982: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
4983: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
4984: fnd_message.set_token('ERROR_CD',p_error_code);
4985:
4986: l_debug_str := fnd_message.get || ' ' || l_msg_data;
4987:
4988: fnd_log.string_with_context( fnd_log.level_exception,
4989: l_label,
4990: l_debug_str, NULL,

Line 5019: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

5015: END IF;
5016:
5017: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception3';
5018:
5019: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5020: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
5021: fnd_message.set_token('ERROR_CD','E014');
5022:
5023: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 5020: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);

5016:
5017: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception3';
5018:
5019: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5020: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
5021: fnd_message.set_token('ERROR_CD','E014');
5022:
5023: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5024:

Line 5021: fnd_message.set_token('ERROR_CD','E014');

5017: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception3';
5018:
5019: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5020: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
5021: fnd_message.set_token('ERROR_CD','E014');
5022:
5023: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5024:
5025: fnd_log.string_with_context( fnd_log.level_exception,

Line 5023: l_debug_str := fnd_message.get || ' ' || SQLERRM;

5019: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5020: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
5021: fnd_message.set_token('ERROR_CD','E014');
5022:
5023: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5024:
5025: fnd_log.string_with_context( fnd_log.level_exception,
5026: l_label,
5027: l_debug_str, NULL,

Line 5065: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

5061: END IF;
5062:
5063: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E518';
5064:
5065: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5066: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
5067: fnd_message.set_token('ERROR_CD','E518');
5068:
5069: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 5066: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);

5062:
5063: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E518';
5064:
5065: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5066: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
5067: fnd_message.set_token('ERROR_CD','E518');
5068:
5069: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5070:

Line 5067: fnd_message.set_token('ERROR_CD','E518');

5063: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E518';
5064:
5065: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5066: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
5067: fnd_message.set_token('ERROR_CD','E518');
5068:
5069: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5070:
5071: fnd_log.string_with_context( fnd_log.level_exception,

Line 5069: l_debug_str := fnd_message.get || ' ' || SQLERRM;

5065: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5066: fnd_message.set_token('INTERFACE_ID',stat_rec.interface_stat_id);
5067: fnd_message.set_token('ERROR_CD','E518');
5068:
5069: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5070:
5071: fnd_log.string_with_context( fnd_log.level_exception,
5072: l_label,
5073: l_debug_str, NULL,

Line 5227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

5223: END IF;
5224:
5225: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E161';
5226:
5227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5228: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_id);
5229: fnd_message.set_token('ERROR_CD','E161');
5230:
5231: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 5228: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_id);

5224:
5225: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E161';
5226:
5227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5228: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_id);
5229: fnd_message.set_token('ERROR_CD','E161');
5230:
5231: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5232:

Line 5229: fnd_message.set_token('ERROR_CD','E161');

5225: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E161';
5226:
5227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5228: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_id);
5229: fnd_message.set_token('ERROR_CD','E161');
5230:
5231: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5232:
5233: fnd_log.string_with_context( fnd_log.level_exception,

Line 5231: l_debug_str := fnd_message.get || ' ' || SQLERRM;

5227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5228: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_id);
5229: fnd_message.set_token('ERROR_CD','E161');
5230:
5231: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5232:
5233: fnd_log.string_with_context( fnd_log.level_exception,
5234: l_label,
5235: l_debug_str, NULL,

Line 5395: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

5391: END IF;
5392:
5393: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.validate_record';
5394:
5395: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5396: fnd_message.set_token('INTERFACE_ID',p_biodemo_rec.interface_eit_id);
5397: fnd_message.set_token('ERROR_CD',l_error);
5398:
5399: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 5396: fnd_message.set_token('INTERFACE_ID',p_biodemo_rec.interface_eit_id);

5392:
5393: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.validate_record';
5394:
5395: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5396: fnd_message.set_token('INTERFACE_ID',p_biodemo_rec.interface_eit_id);
5397: fnd_message.set_token('ERROR_CD',l_error);
5398:
5399: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5400:

Line 5397: fnd_message.set_token('ERROR_CD',l_error);

5393: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.validate_record';
5394:
5395: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5396: fnd_message.set_token('INTERFACE_ID',p_biodemo_rec.interface_eit_id);
5397: fnd_message.set_token('ERROR_CD',l_error);
5398:
5399: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5400:
5401: fnd_log.string_with_context( fnd_log.level_exception,

Line 5399: l_debug_str := fnd_message.get || ' ' || SQLERRM;

5395: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5396: fnd_message.set_token('INTERFACE_ID',p_biodemo_rec.interface_eit_id);
5397: fnd_message.set_token('ERROR_CD',l_error);
5398:
5399: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5400:
5401: fnd_log.string_with_context( fnd_log.level_exception,
5402: l_label,
5403: l_debug_str, NULL,

Line 5634: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

5630: END IF;
5631:
5632: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E090';
5633:
5634: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5635: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_eit_id);
5636: fnd_message.set_token('ERROR_CD','E090');
5637:
5638: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 5635: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_eit_id);

5631:
5632: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E090';
5633:
5634: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5635: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_eit_id);
5636: fnd_message.set_token('ERROR_CD','E090');
5637:
5638: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5639:

Line 5636: fnd_message.set_token('ERROR_CD','E090');

5632: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E090';
5633:
5634: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5635: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_eit_id);
5636: fnd_message.set_token('ERROR_CD','E090');
5637:
5638: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5639:
5640: fnd_log.string_with_context( fnd_log.level_exception,

Line 5638: l_debug_str := fnd_message.get || ' ' || SQLERRM;

5634: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5635: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_eit_id);
5636: fnd_message.set_token('ERROR_CD','E090');
5637:
5638: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5639:
5640: fnd_log.string_with_context( fnd_log.level_exception,
5641: l_label,
5642: l_debug_str, NULL,

Line 5725: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

5721: END IF;
5722:
5723: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E089';
5724:
5725: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5726: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_eit_id);
5727: fnd_message.set_token('ERROR_CD','E089');
5728:
5729: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 5726: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_eit_id);

5722:
5723: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E089';
5724:
5725: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5726: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_eit_id);
5727: fnd_message.set_token('ERROR_CD','E089');
5728:
5729: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5730:

Line 5727: fnd_message.set_token('ERROR_CD','E089');

5723: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E089';
5724:
5725: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5726: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_eit_id);
5727: fnd_message.set_token('ERROR_CD','E089');
5728:
5729: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5730:
5731: fnd_log.string_with_context( fnd_log.level_exception,

Line 5729: l_debug_str := fnd_message.get || ' ' || SQLERRM;

5725: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
5726: fnd_message.set_token('INTERFACE_ID',biodem_rec.interface_eit_id);
5727: fnd_message.set_token('ERROR_CD','E089');
5728:
5729: l_debug_str := fnd_message.get || ' ' || SQLERRM;
5730:
5731: fnd_log.string_with_context( fnd_log.level_exception,
5732: l_label,
5733: l_debug_str, NULL,