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_IMP_008

Line 1: PACKAGE BODY IGS_AD_IMP_008 AS

1: PACKAGE BODY IGS_AD_IMP_008 AS
2: /* $Header: IGSAD86B.pls 120.8 2006/06/23 05:50:39 gmaheswa ship $ */
3: /* Change History
4: Who when What
5:

Line 177: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.begin_crt_rel';

173: BEGIN
174: l_rel_person_exists := 'N';
175: l_Status := '3';
176: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
177: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.begin_crt_rel';
178: l_debug_str := 'Interface Relations Id: '||p_relations_rec.interface_relations_id;
179: fnd_log.string_with_context( fnd_log.level_procedure,
180: l_label,
181: l_debug_str, NULL,

Line 392: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E452';

388: IF l_enable_log = 'Y' THEN
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;

Line 453: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E172';

449: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E172','IGS_AD_RELATIONS_INT_ALL');
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;

Line 492: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception.others';

488: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
489: RETURN;
490: ELSE
491: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
492: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception.others';
493: l_debug_str := 'Unhandled Exception for interface Relatuons ID:'||P_Relations_Rec.Interface_Relations_Id||' ' || l_msg_data;
494: fnd_log.string_with_context( fnd_log.level_exception,
495: l_label,
496: l_debug_str, NULL,

Line 543: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '|| 'E518';

539: EXCEPTION
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;

Line 570: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns';

566: -- Main Procedure starts here Prc_Pe_Rel
567: BEGIN
568: l_processed_records := 0;
569: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
570: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns';
571: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.';
572: l_enable_log := igs_ad_imp_001.g_enable_log;
573: l_request_id := fnd_global.conc_request_id;
574: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 571: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.';

567: BEGIN
568: l_processed_records := 0;
569: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
570: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns';
571: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.';
572: l_enable_log := igs_ad_imp_001.g_enable_log;
573: l_request_id := fnd_global.conc_request_id;
574: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
575: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.begin';

Line 575: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.begin';

571: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.';
572: l_enable_log := igs_ad_imp_001.g_enable_log;
573: l_request_id := fnd_global.conc_request_id;
574: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
575: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.begin';
576: l_debug_str := 'igs_ad_imp_008.prc_pe_rel';
577: fnd_log.string_with_context( fnd_log.level_procedure,
578: l_label,
579: l_debug_str, NULL,

Line 576: l_debug_str := 'igs_ad_imp_008.prc_pe_rel';

572: l_enable_log := igs_ad_imp_001.g_enable_log;
573: l_request_id := fnd_global.conc_request_id;
574: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
575: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.begin';
576: l_debug_str := 'igs_ad_imp_008.prc_pe_rel';
577: fnd_log.string_with_context( fnd_log.level_procedure,
578: l_label,
579: l_debug_str, NULL,
580: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)

Line 614: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.relation_exist';

610: RAISE NO_DATA_FOUND;
611: END IF;
612: -- If Relation exists update interface table and proceed to the next record
613: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
614: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.relation_exist';
615: l_debug_str := 'Igs_Ad_Imp_008.Prc_Pe_Relns ' ||'Interface_Relations_Id : ' ||
616: IGS_GE_NUMBER.TO_CANN(Relations_Rec.Interface_Relations_Id) ||'Status : 1' || 'Relationship Exists';
617: fnd_log.string_with_context( fnd_log.level_procedure,
618: l_label,

Line 615: l_debug_str := 'Igs_Ad_Imp_008.Prc_Pe_Relns ' ||'Interface_Relations_Id : ' ||

611: END IF;
612: -- If Relation exists update interface table and proceed to the next record
613: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
614: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.relation_exist';
615: l_debug_str := 'Igs_Ad_Imp_008.Prc_Pe_Relns ' ||'Interface_Relations_Id : ' ||
616: IGS_GE_NUMBER.TO_CANN(Relations_Rec.Interface_Relations_Id) ||'Status : 1' || 'Relationship Exists';
617: fnd_log.string_with_context( fnd_log.level_procedure,
618: l_label,
619: l_debug_str, NULL,

Line 666: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_relns.exception';

662: WHEN OTHERS THEN
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;

Line 855: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception '||'E014';

851: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
852: IF (l_request_id IS NULL) THEN
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');

Line 881: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.warning '||'E073';

877: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
878: IF (l_request_id IS NULL) THEN
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');

Line 929: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception1 '||'E244';

925: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
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;

Line 982: l_label := 'igs.plsql.igs_ad_imp_008.update_addr.exception2 '||'E244';

978: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
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;

Line 1023: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.update_addr_exception'||'E014';

1019: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
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;

Line 1191: l_prog_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr';

1187: p_api_version := 1.0;
1188: l_Status := '3';
1189: l_Check := 'FALSE';
1190: l_Error_Code := 'E008';
1191: l_prog_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr';
1192: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.';
1193: l_enable_log := igs_ad_imp_001.g_enable_log;
1194: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1195:

Line 1192: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.';

1188: l_Status := '3';
1189: l_Check := 'FALSE';
1190: l_Error_Code := 'E008';
1191: l_prog_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr';
1192: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.';
1193: l_enable_log := igs_ad_imp_001.g_enable_log;
1194: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1195:
1196: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 1201: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.begin';

1197: IF (l_request_id IS NULL) THEN
1198: l_request_id := fnd_global.conc_request_id;
1199: END IF;
1200:
1201: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.begin';
1202: l_debug_str := 'Igs_Ad_Imp_008.crt_rel_adr.begin';
1203:
1204: fnd_log.string_with_context( fnd_log.level_procedure,
1205: l_label,

Line 1202: l_debug_str := 'Igs_Ad_Imp_008.crt_rel_adr.begin';

1198: l_request_id := fnd_global.conc_request_id;
1199: END IF;
1200:
1201: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.begin';
1202: l_debug_str := 'Igs_Ad_Imp_008.crt_rel_adr.begin';
1203:
1204: fnd_log.string_with_context( fnd_log.level_procedure,
1205: l_label,
1206: l_debug_str, NULL,

Line 1399: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception1 '||'E322';

1395: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
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;

Line 1424: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.warning '||'E073';

1420: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
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;

Line 1471: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception2 '||'E322';

1467: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
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;

Line 1518: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception '||'E244';

1514: IF (l_request_id IS NULL) THEN
1515: l_request_id := fnd_global.conc_request_id;
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');

Line 1559: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_adr.exception '||'E518';

1555: IF (l_request_id IS NULL) THEN
1556: l_request_id := fnd_global.conc_request_id;
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');

Line 1708: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.begin_prc_rel_con';

1704: IF (l_request_id IS NULL) THEN
1705: l_request_id := fnd_global.conc_request_id;
1706: END IF;
1707:
1708: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.begin_prc_rel_con';
1709: l_debug_str := 'Igs_Ad_Imp_008.prc_rel_con_dtl.prc_rel_con';
1710:
1711: fnd_log.string_with_context( fnd_log.level_procedure,
1712: l_label,

Line 1709: l_debug_str := 'Igs_Ad_Imp_008.prc_rel_con_dtl.prc_rel_con';

1705: l_request_id := fnd_global.conc_request_id;
1706: END IF;
1707:
1708: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.begin_prc_rel_con';
1709: l_debug_str := 'Igs_Ad_Imp_008.prc_rel_con_dtl.prc_rel_con';
1710:
1711: fnd_log.string_with_context( fnd_log.level_procedure,
1712: l_label,
1713: l_debug_str, NULL,

Line 1925: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl';

1921: BEGIN
1922: l_check := 'FALSE';
1923: l_Status := '3';
1924: l_Error_Code := 'E008';
1925: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl';
1926: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.';
1927: l_enable_log := igs_ad_imp_001.g_enable_log;
1928: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1929: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 1926: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.';

1922: l_check := 'FALSE';
1923: l_Status := '3';
1924: l_Error_Code := 'E008';
1925: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl';
1926: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.';
1927: l_enable_log := igs_ad_imp_001.g_enable_log;
1928: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1929: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1930:

Line 1935: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.begin';

1931: IF (l_request_id IS NULL) THEN
1932: l_request_id := fnd_global.conc_request_id;
1933: END IF;
1934:
1935: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.begin';
1936: l_debug_str := 'Igs_Ad_Imp_008.prc_rel_con_dtl';
1937:
1938: fnd_log.string_with_context( fnd_log.level_procedure,
1939: l_label,

Line 1936: l_debug_str := 'Igs_Ad_Imp_008.prc_rel_con_dtl';

1932: l_request_id := fnd_global.conc_request_id;
1933: END IF;
1934:
1935: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.begin';
1936: l_debug_str := 'Igs_Ad_Imp_008.prc_rel_con_dtl';
1937:
1938: fnd_log.string_with_context( fnd_log.level_procedure,
1939: l_label,
1940: l_debug_str, NULL,

Line 2157: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception';

2153: IF (l_request_id IS NULL) THEN
2154: l_request_id := fnd_global.conc_request_id;
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');

Line 2243: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception '||'E014';

2239: IF (l_request_id IS NULL) THEN
2240: l_request_id := fnd_global.conc_request_id;
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');

Line 2282: l_label := 'igs.plsql.igs_ad_imp_008.prc_rel_con_dtl.exception '||'E518';

2278: IF (l_request_id IS NULL) THEN
2279: l_request_id := fnd_global.conc_request_id;
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');

Line 2652: l_prog_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his';

2648: BEGIN
2649: l_check := 'FALSE';
2650: l_Status := '3';
2651: l_Error_Code := 'E008';
2652: l_prog_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his';
2653: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.';
2654: l_enable_log := igs_ad_imp_001.g_enable_log;
2655: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
2656: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 2653: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.';

2649: l_check := 'FALSE';
2650: l_Status := '3';
2651: l_Error_Code := 'E008';
2652: l_prog_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his';
2653: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.';
2654: l_enable_log := igs_ad_imp_001.g_enable_log;
2655: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
2656: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2657:

Line 2662: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.begin';

2658: IF (l_request_id IS NULL) THEN
2659: l_request_id := fnd_global.conc_request_id;
2660: END IF;
2661:
2662: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.begin';
2663: l_debug_str := 'Igs_Ad_Imp_008.crt_rel_acad_his';
2664:
2665: fnd_log.string_with_context( fnd_log.level_procedure,
2666: l_label,

Line 2663: l_debug_str := 'Igs_Ad_Imp_008.crt_rel_acad_his';

2659: l_request_id := fnd_global.conc_request_id;
2660: END IF;
2661:
2662: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.begin';
2663: l_debug_str := 'Igs_Ad_Imp_008.crt_rel_acad_his';
2664:
2665: fnd_log.string_with_context( fnd_log.level_procedure,
2666: l_label,
2667: l_debug_str, NULL,

Line 2842: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception '||'E014';

2838: IF (l_request_id IS NULL) THEN
2839: l_request_id := fnd_global.conc_request_id;
2840: END IF;
2841:
2842: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception '||'E014';
2843:
2844: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Update Row failed'
2845: || 'Interface Relacad Id : '
2846: || (relacad_rec.interface_relacad_id)

Line 2844: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Update Row failed'

2840: END IF;
2841:
2842: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception '||'E014';
2843:
2844: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Update Row failed'
2845: || 'Interface Relacad Id : '
2846: || (relacad_rec.interface_relacad_id)
2847: || 'Status : 3' || 'ErrorCode : E014 HzMesg: '||l_msg_data||' SQLERRM:' || SQLERRM;
2848:

Line 2945: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception1 '||'E014';

2941: IF (l_request_id IS NULL) THEN
2942: l_request_id := fnd_global.conc_request_id;
2943: END IF;
2944:
2945: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception1 '||'E014';
2946:
2947: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Update Row failed'
2948: || 'Interface Relacad Id : '
2949: || (relacad_rec.interface_relacad_id)

Line 2947: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Update Row failed'

2943: END IF;
2944:
2945: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception1 '||'E014';
2946:
2947: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Update Row failed'
2948: || 'Interface Relacad Id : '
2949: || (relacad_rec.interface_relacad_id)
2950: || 'Status : 3' || 'ErrorCode : E014 HzMesg: '||l_msg_data||' SQLERRM:' || SQLERRM;
2951:

Line 3059: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception1 '||'E014';

3055: IF (l_request_id IS NULL) THEN
3056: l_request_id := fnd_global.conc_request_id;
3057: END IF;
3058:
3059: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception1 '||'E014';
3060:
3061: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Update Row failed'
3062: || 'Interface Relacad Id : '
3063: || (relacad_rec.interface_relacad_id)

Line 3061: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Update Row failed'

3057: END IF;
3058:
3059: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception1 '||'E014';
3060:
3061: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Update Row failed'
3062: || 'Interface Relacad Id : '
3063: || (relacad_rec.interface_relacad_id)
3064: || 'Status : 3' || 'ErrorCode : E014 HzMesg: '||l_msg_data||' SQLERRM:' || SQLERRM;
3065:

Line 3178: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception '||'E322';

3174: IF (l_request_id IS NULL) THEN
3175: l_request_id := fnd_global.conc_request_id;
3176: END IF;
3177:
3178: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception '||'E322';
3179:
3180: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Insert Row failed'
3181: || 'Interface Relacad Id : '
3182: || (relacad_rec.interface_relacad_id)

Line 3180: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Insert Row failed'

3176: END IF;
3177:
3178: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel_acad_his.exception '||'E322';
3179:
3180: l_debug_str := 'Rule - Import, IGS_AD_IMP_008.crt_rel_acad_his Insert Row failed'
3181: || 'Interface Relacad Id : '
3182: || (relacad_rec.interface_relacad_id)
3183: || 'Status : 3' || 'ErrorCode : E322 HzMesg: '||l_msg_data||' SQLERRM:' || SQLERRM;
3184:

Line 3239: l_prog_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls';

3235: l_employer_party_id NUMBER;
3236: l_enable_log VARCHAR2(1);
3237: BEGIN
3238:
3239: l_prog_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls';
3240: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.';
3241: l_enable_log := igs_ad_imp_001.g_enable_log;
3242: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3243: lv_var := 'N';

Line 3240: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.';

3236: l_enable_log VARCHAR2(1);
3237: BEGIN
3238:
3239: l_prog_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls';
3240: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.';
3241: l_enable_log := igs_ad_imp_001.g_enable_log;
3242: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3243: lv_var := 'N';
3244: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 3249: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.begin';

3245: IF (l_request_id IS NULL) THEN
3246: l_request_id := fnd_global.conc_request_id;
3247: END IF;
3248:
3249: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.begin';
3250: l_debug_str := 'Igs_Ad_Imp_008.Crt_Relns_Emp_Dtls';
3251:
3252: fnd_log.string_with_context( fnd_log.level_procedure,
3253: l_label,

Line 3250: l_debug_str := 'Igs_Ad_Imp_008.Crt_Relns_Emp_Dtls';

3246: l_request_id := fnd_global.conc_request_id;
3247: END IF;
3248:
3249: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.begin';
3250: l_debug_str := 'Igs_Ad_Imp_008.Crt_Relns_Emp_Dtls';
3251:
3252: fnd_log.string_with_context( fnd_log.level_procedure,
3253: l_label,
3254: l_debug_str, NULL,

Line 3307: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.exception';

3303: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
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;

Line 3334: l_label := 'igs.plsql.igs_ad_imp_008.crt_relns_emp_dtls.exception '||'E518';

3330: IF (l_request_id IS NULL) THEN
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;

Line 3394: l_prog_label := 'igs.plsql.igs_ad_imp_008.validate_relns_emp_dtls';

3390:
3391: P_ERROR_CODE := NULL;
3392: lv_var := 'N';
3393:
3394: l_prog_label := 'igs.plsql.igs_ad_imp_008.validate_relns_emp_dtls';
3395: l_label := 'igs.plsql.igs_ad_imp_008.validate_relns_emp_dtls.';
3396: l_enable_log := igs_ad_imp_001.g_enable_log;
3397: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3398: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 3395: l_label := 'igs.plsql.igs_ad_imp_008.validate_relns_emp_dtls.';

3391: P_ERROR_CODE := NULL;
3392: lv_var := 'N';
3393:
3394: l_prog_label := 'igs.plsql.igs_ad_imp_008.validate_relns_emp_dtls';
3395: l_label := 'igs.plsql.igs_ad_imp_008.validate_relns_emp_dtls.';
3396: l_enable_log := igs_ad_imp_001.g_enable_log;
3397: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3398: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
3399:

Line 3404: l_label := 'igs.plsql.igs_ad_imp_008.validate_relns_emp_dtls.begin';

3400: IF (l_request_id IS NULL) THEN
3401: l_request_id := fnd_global.conc_request_id;
3402: END IF;
3403:
3404: l_label := 'igs.plsql.igs_ad_imp_008.validate_relns_emp_dtls.begin';
3405: l_debug_str := 'Igs_Ad_Imp_008.validate_relns_emp_dtls';
3406:
3407: fnd_log.string_with_context( fnd_log.level_procedure,
3408: l_label,

Line 3405: l_debug_str := 'Igs_Ad_Imp_008.validate_relns_emp_dtls';

3401: l_request_id := fnd_global.conc_request_id;
3402: END IF;
3403:
3404: l_label := 'igs.plsql.igs_ad_imp_008.validate_relns_emp_dtls.begin';
3405: l_debug_str := 'Igs_Ad_Imp_008.validate_relns_emp_dtls';
3406:
3407: fnd_log.string_with_context( fnd_log.level_procedure,
3408: l_label,
3409: l_debug_str, NULL,

Line 3554: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls';

3550: l_error_code VARCHAR2(30);
3551:
3552: BEGIN
3553:
3554: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls';
3555: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.';
3556: l_enable_log := igs_ad_imp_001.g_enable_log;
3557: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3558:

Line 3555: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.';

3551:
3552: BEGIN
3553:
3554: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls';
3555: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.';
3556: l_enable_log := igs_ad_imp_001.g_enable_log;
3557: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3558:
3559: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 3565: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.begin';

3561: IF (l_request_id IS NULL) THEN
3562: l_request_id := fnd_global.conc_request_id;
3563: END IF;
3564:
3565: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.begin';
3566: l_debug_str := 'Igs_Ad_Imp_008.Prc_Relns_Emp_Dtls';
3567:
3568: fnd_log.string_with_context( fnd_log.level_procedure,
3569: l_label,

Line 3566: l_debug_str := 'Igs_Ad_Imp_008.Prc_Relns_Emp_Dtls';

3562: l_request_id := fnd_global.conc_request_id;
3563: END IF;
3564:
3565: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.begin';
3566: l_debug_str := 'Igs_Ad_Imp_008.Prc_Relns_Emp_Dtls';
3567:
3568: fnd_log.string_with_context( fnd_log.level_procedure,
3569: l_label,
3570: l_debug_str, NULL,

Line 3751: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.exception '||'E014';

3747: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
3748: IF (l_request_id IS NULL) THEN
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');

Line 3824: l_label := 'igs.plsql.igs_ad_imp_008.prc_relns_emp_dtls.exception';

3820: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
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;

Line 3971: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.begin_validate_person_statistics';

3967: IF (l_request_id IS NULL) THEN
3968: l_request_id := fnd_global.conc_request_id;
3969: END IF;
3970:
3971: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.begin_validate_person_statistics';
3972: l_debug_str := 'Igs_Ad_Imp_008.Validate_Person_Statistics';
3973:
3974: fnd_log.string_with_context( fnd_log.level_procedure,
3975: l_label,

Line 3972: l_debug_str := 'Igs_Ad_Imp_008.Validate_Person_Statistics';

3968: l_request_id := fnd_global.conc_request_id;
3969: END IF;
3970:
3971: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.begin_validate_person_statistics';
3972: l_debug_str := 'Igs_Ad_Imp_008.Validate_Person_Statistics';
3973:
3974: fnd_log.string_with_context( fnd_log.level_procedure,
3975: l_label,
3976: l_debug_str, NULL,

Line 4050: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E277';

4046: IF (l_request_id IS NULL) THEN
4047: l_request_id := fnd_global.conc_request_id;
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');

Line 4161: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E170';

4157: IF (l_request_id IS NULL) THEN
4158: l_request_id := fnd_global.conc_request_id;
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');

Line 4206: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.begin_crt_pe_stat';

4202: IF (l_request_id IS NULL) THEN
4203: l_request_id := fnd_global.conc_request_id;
4204: END IF;
4205:
4206: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.begin_crt_pe_stat';
4207: l_debug_str := 'Igs_Ad_Imp_008.Crt_Pe_Stat';
4208:
4209: fnd_log.string_with_context( fnd_log.level_procedure,
4210: l_label,

Line 4207: l_debug_str := 'Igs_Ad_Imp_008.Crt_Pe_Stat';

4203: l_request_id := fnd_global.conc_request_id;
4204: END IF;
4205:
4206: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.begin_crt_pe_stat';
4207: l_debug_str := 'Igs_Ad_Imp_008.Crt_Pe_Stat';
4208:
4209: fnd_log.string_with_context( fnd_log.level_procedure,
4210: l_label,
4211: l_debug_str, NULL,

Line 4328: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E005';

4324: IF (l_request_id IS NULL) THEN
4325: l_request_id := fnd_global.conc_request_id;
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');

Line 4378: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception2';

4374: IF (l_request_id IS NULL) THEN
4375: l_request_id := fnd_global.conc_request_id;
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');

Line 4402: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main';

4398: -- main procedure begins
4399: BEGIN
4400: -- Call Log header
4401: l_processed_records := 0;
4402: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main';
4403: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.';
4404: l_enable_log := igs_ad_imp_001.g_enable_log;
4405: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
4406:

Line 4403: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.';

4399: BEGIN
4400: -- Call Log header
4401: l_processed_records := 0;
4402: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main';
4403: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.';
4404: l_enable_log := igs_ad_imp_001.g_enable_log;
4405: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
4406:
4407: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 4413: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.begin';

4409: IF (l_request_id IS NULL) THEN
4410: l_request_id := fnd_global.conc_request_id;
4411: END IF;
4412:
4413: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.begin';
4414: l_debug_str := 'Igs_Ad_Imp_008.Prc_Pe_Stat_Main';
4415:
4416: fnd_log.string_with_context( fnd_log.level_procedure,
4417: l_label,

Line 4414: l_debug_str := 'Igs_Ad_Imp_008.Prc_Pe_Stat_Main';

4410: l_request_id := fnd_global.conc_request_id;
4411: END IF;
4412:
4413: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.begin';
4414: l_debug_str := 'Igs_Ad_Imp_008.Prc_Pe_Stat_Main';
4415:
4416: fnd_log.string_with_context( fnd_log.level_procedure,
4417: l_label,
4418: l_debug_str, NULL,

Line 4751: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E014';

4747: IF (l_request_id IS NULL) THEN
4748: l_request_id := fnd_global.conc_request_id;
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');

Line 4796: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E518';

4792: IF (l_request_id IS NULL) THEN
4793: l_request_id := fnd_global.conc_request_id;
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');

Line 4934: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception1';

4930: IF (l_request_id IS NULL) THEN
4931: l_request_id := fnd_global.conc_request_id;
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');

Line 4980: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception2';

4976: IF (l_request_id IS NULL) THEN
4977: l_request_id := fnd_global.conc_request_id;
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);

Line 5017: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception3';

5013: IF (l_request_id IS NULL) THEN
5014: l_request_id := fnd_global.conc_request_id;
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');

Line 5063: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_main.exception '||'E518';

5059: IF (l_request_id IS NULL) THEN
5060: l_request_id := fnd_global.conc_request_id;
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');

Line 5176: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.begin_crt_biodemo';

5172: IF (l_request_id IS NULL) THEN
5173: l_request_id := fnd_global.conc_request_id;
5174: END IF;
5175:
5176: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.begin_crt_biodemo';
5177: l_debug_str := 'Igs_Ad_Imp_008.prc_pe_stat_biodemo.crt_biodemo';
5178:
5179: fnd_log.string_with_context( fnd_log.level_procedure,
5180: l_label,

Line 5177: l_debug_str := 'Igs_Ad_Imp_008.prc_pe_stat_biodemo.crt_biodemo';

5173: l_request_id := fnd_global.conc_request_id;
5174: END IF;
5175:
5176: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.begin_crt_biodemo';
5177: l_debug_str := 'Igs_Ad_Imp_008.prc_pe_stat_biodemo.crt_biodemo';
5178:
5179: fnd_log.string_with_context( fnd_log.level_procedure,
5180: l_label,
5181: l_debug_str, NULL,

Line 5225: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E161';

5221: IF (l_request_id IS NULL) THEN
5222: l_request_id := fnd_global.conc_request_id;
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');

Line 5297: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.begin_validate_record';

5293: IF (l_request_id IS NULL) THEN
5294: l_request_id := fnd_global.conc_request_id;
5295: END IF;
5296:
5297: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.begin_validate_record';
5298: l_debug_str := 'Igs_Ad_Imp_008.prc_pe_stat_biodemo.Validate_Record';
5299:
5300: fnd_log.string_with_context( fnd_log.level_procedure,
5301: l_label,

Line 5298: l_debug_str := 'Igs_Ad_Imp_008.prc_pe_stat_biodemo.Validate_Record';

5294: l_request_id := fnd_global.conc_request_id;
5295: END IF;
5296:
5297: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.begin_validate_record';
5298: l_debug_str := 'Igs_Ad_Imp_008.prc_pe_stat_biodemo.Validate_Record';
5299:
5300: fnd_log.string_with_context( fnd_log.level_procedure,
5301: l_label,
5302: l_debug_str, NULL,

Line 5393: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.validate_record';

5389: IF (l_request_id IS NULL) THEN
5390: l_request_id := fnd_global.conc_request_id;
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);

Line 5418: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo';

5414:
5415:
5416: BEGIN -- Start the Prc_Pe_Stat_Biodemo Now.
5417:
5418: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo';
5419: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.';
5420: l_enable_log := igs_ad_imp_001.g_enable_log;
5421: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
5422: -- Call Log header

Line 5419: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.';

5415:
5416: BEGIN -- Start the Prc_Pe_Stat_Biodemo Now.
5417:
5418: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo';
5419: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.';
5420: l_enable_log := igs_ad_imp_001.g_enable_log;
5421: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
5422: -- Call Log header
5423: l_processed_records := 0;

Line 5432: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.begin';

5428: IF (l_request_id IS NULL) THEN
5429: l_request_id := fnd_global.conc_request_id;
5430: END IF;
5431:
5432: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.begin';
5433: l_debug_str := 'Igs_Ad_Imp_008.Prc_Pe_Stat_Biodemo';
5434:
5435: fnd_log.string_with_context( fnd_log.level_procedure,
5436: l_label,

Line 5433: l_debug_str := 'Igs_Ad_Imp_008.Prc_Pe_Stat_Biodemo';

5429: l_request_id := fnd_global.conc_request_id;
5430: END IF;
5431:
5432: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.begin';
5433: l_debug_str := 'Igs_Ad_Imp_008.Prc_Pe_Stat_Biodemo';
5434:
5435: fnd_log.string_with_context( fnd_log.level_procedure,
5436: l_label,
5437: l_debug_str, NULL,

Line 5632: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E090';

5628: IF (l_request_id IS NULL) THEN
5629: l_request_id := fnd_global.conc_request_id;
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');

Line 5723: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat_biodemo.exception '||'E089';

5719: IF (l_request_id IS NULL) THEN
5720: l_request_id := fnd_global.conc_request_id;
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');

Line 5812: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat';

5808: l_request_id NUMBER;
5809: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
5810: BEGIN
5811:
5812: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat';
5813: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat.';
5814: l_enable_log := igs_ad_imp_001.g_enable_log;
5815:
5816: Prc_Pe_Stat_Main (p_source_type_id, p_batch_id);

Line 5813: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat.';

5809: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
5810: BEGIN
5811:
5812: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat';
5813: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat.';
5814: l_enable_log := igs_ad_imp_001.g_enable_log;
5815:
5816: Prc_Pe_Stat_Main (p_source_type_id, p_batch_id);
5817: Prc_Pe_Stat_Biodemo (p_source_type_id, p_batch_id);

Line 5828: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat.exception1';

5824: IF (l_request_id IS NULL) THEN
5825: l_request_id := fnd_global.conc_request_id;
5826: END IF;
5827:
5828: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat.exception1';
5829: l_debug_str := SQLERRM || ' ';
5830:
5831: fnd_log.string_with_context( fnd_log.level_exception,
5832: l_label,

Line 5840: END Igs_Ad_Imp_008;

5836: END Prc_Pe_Stat;
5837:
5838:
5839:
5840: END Igs_Ad_Imp_008;