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_LOG

Line 176: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

172:
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,

Line 179: fnd_log.string_with_context( fnd_log.level_procedure,

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,
182: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
183: END IF;

Line 391: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

387: IF l_return_status IN ('E','U') THEN
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');

Line 397: fnd_log.string_with_context( fnd_log.level_exception,

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)
401: );

Line 452: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

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

Line 458: fnd_log.string_with_context( fnd_log.level_exception,

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)
462: );

Line 491: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

487: STATUS = '3'
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,

Line 494: fnd_log.string_with_context( fnd_log.level_exception,

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,
497: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
498: );

Line 542: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

538: -----------------------------------
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');

Line 548: fnd_log.string_with_context( fnd_log.level_exception,

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)
552: );

Line 574: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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';
576: l_debug_str := 'igs_ad_imp_008.prc_pe_rel';
577: fnd_log.string_with_context( fnd_log.level_procedure,
578: l_label,

Line 577: fnd_log.string_with_context( fnd_log.level_procedure,

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)
581: );

Line 613: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

609: IF l_rel_count = 0 THEN
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,

Line 617: fnd_log.string_with_context( fnd_log.level_procedure,

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,
620: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
621: );

Line 665: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

661: p_src_type_id=> p_source_type_id); --tray , parameter added p_src_type_id=> p_source_type_id
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');

Line 671: fnd_log.string_with_context( fnd_log.level_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)
675: );

Line 851: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

847: l_flag_check_status := 'N';
848: IF l_enable_log = 'Y' THEN
849: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E014','IGS_AD_RELADDR_INT_ALL');
850: END IF;
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';

Line 861: fnd_log.string_with_context( fnd_log.level_exception,

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)
865: );

Line 877: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

873: l_addr_warning := 'Y';
874: IF l_enable_log = 'Y' THEN
875: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E073','IGS_AD_RELADDR_INT_ALL');
876: END IF;
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';

Line 887: fnd_log.string_with_context( fnd_log.level_exception,

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)
891: );

Line 925: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

921: );
922:
923: IF l_return_status IN ('E','U') THEN
924: l_flag_check_status := 'N';
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';

Line 934: fnd_log.string_with_context( fnd_log.level_exception,

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)
938: );

Line 978: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

974: );
975: IF l_return_status IN('E','U') THEN
976: l_flag_check_status := 'N';
977:
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';

Line 987: fnd_log.string_with_context( fnd_log.level_exception,

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)
991: );

Line 1019: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: l_msg_data := SQLERRM;
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';

Line 1028: fnd_log.string_with_context( fnd_log.level_exception,

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)
1032: );

Line 1196: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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
1197: IF (l_request_id IS NULL) THEN
1198: l_request_id := fnd_global.conc_request_id;
1199: END IF;
1200:

Line 1204: fnd_log.string_with_context( fnd_log.level_procedure,

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,
1207: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
1208: );

Line 1395: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1391:
1392:
1393: IF l_return_status IN ('E','U') THEN
1394: l_flag_check_status := 'N';
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';

Line 1404: fnd_log.string_with_context( fnd_log.level_exception,

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)
1408: );

Line 1420: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1416: Status = '3'
1417: WHERE INTERFACE_RELADDR_ID = reladdr_rec.INTERFACE_RELADDR_ID;
1418: ELSIF l_return_status = 'W' THEN
1419: l_addr_warning := 'Y';
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';

Line 1429: fnd_log.string_with_context( fnd_log.level_exception,

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)
1433: );

Line 1467: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1463: );
1464:
1465: IF l_return_status IN ('E','U') THEN
1466: l_flag_check_status := 'N';
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';

Line 1476: fnd_log.string_with_context( fnd_log.level_exception,

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)
1480: );

Line 1513: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1509:
1510: IF l_return_status IN ('E','U') THEN
1511: l_flag_check_status := 'N';
1512:
1513: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1514: IF (l_request_id IS NULL) THEN
1515: l_request_id := fnd_global.conc_request_id;
1516: END IF;
1517:

Line 1526: fnd_log.string_with_context( fnd_log.level_exception,

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,
1529: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
1530: );

Line 1554: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1550: l_addr_process := TRUE;
1551: END IF;
1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1555: IF (l_request_id IS NULL) THEN
1556: l_request_id := fnd_global.conc_request_id;
1557: END IF;
1558:

Line 1567: fnd_log.string_with_context( fnd_log.level_exception,

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,
1570: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
1571: );

Line 1702: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1698: l_dummy VARCHAR2(1);
1699:
1700: BEGIN
1701:
1702: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1703:
1704: IF (l_request_id IS NULL) THEN
1705: l_request_id := fnd_global.conc_request_id;
1706: END IF;

Line 1711: fnd_log.string_with_context( fnd_log.level_procedure,

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,
1714: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1715: END IF;

Line 1929: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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:
1931: IF (l_request_id IS NULL) THEN
1932: l_request_id := fnd_global.conc_request_id;
1933: END IF;

Line 1938: fnd_log.string_with_context( fnd_log.level_procedure,

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,
1941: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1942: END IF;

Line 2151: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2147: END LOOP;
2148: l_msg_data := tmp_var1;
2149: END IF;
2150:
2151: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2152:
2153: IF (l_request_id IS NULL) THEN
2154: l_request_id := fnd_global.conc_request_id;
2155: END IF;

Line 2165: fnd_log.string_with_context( fnd_log.level_exception,

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,
2168: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2169: END IF;

Line 2237: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2233: END LOOP;
2234: l_msg_data := tmp_var1;
2235: END IF;
2236:
2237: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2238:
2239: IF (l_request_id IS NULL) THEN
2240: l_request_id := fnd_global.conc_request_id;
2241: END IF;

Line 2251: fnd_log.string_with_context( fnd_log.level_exception,

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,
2254: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2255: END IF;

Line 2276: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2272:
2273: EXCEPTION
2274: WHEN OTHERS THEN
2275:
2276: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2277:
2278: IF (l_request_id IS NULL) THEN
2279: l_request_id := fnd_global.conc_request_id;
2280: END IF;

Line 2290: fnd_log.string_with_context( fnd_log.level_exception,

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,
2293: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2294: END IF;

Line 2656: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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:
2658: IF (l_request_id IS NULL) THEN
2659: l_request_id := fnd_global.conc_request_id;
2660: END IF;

Line 2665: fnd_log.string_with_context( fnd_log.level_procedure,

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,
2668: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2669: END IF;

Line 2836: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2832: );
2833:
2834: IF (l_return_status = 'E' OR l_return_status = 'U') THEN
2835:
2836: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2837:
2838: IF (l_request_id IS NULL) THEN
2839: l_request_id := fnd_global.conc_request_id;
2840: END IF;

Line 2849: fnd_log.string_with_context( fnd_log.level_exception,

2845: || 'Interface Relacad Id : '
2846: || (relacad_rec.interface_relacad_id)
2847: || 'Status : 3' || 'ErrorCode : E014 HzMesg: '||l_msg_data||' SQLERRM:' || SQLERRM;
2848:
2849: fnd_log.string_with_context( fnd_log.level_exception,
2850: l_label,
2851: l_debug_str, NULL,
2852: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2853: END IF;

Line 2939: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2935: );
2936:
2937: IF (l_return_status = 'E' OR l_return_status = 'U') THEN
2938:
2939: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2940:
2941: IF (l_request_id IS NULL) THEN
2942: l_request_id := fnd_global.conc_request_id;
2943: END IF;

Line 2952: fnd_log.string_with_context( fnd_log.level_exception,

2948: || 'Interface Relacad Id : '
2949: || (relacad_rec.interface_relacad_id)
2950: || 'Status : 3' || 'ErrorCode : E014 HzMesg: '||l_msg_data||' SQLERRM:' || SQLERRM;
2951:
2952: fnd_log.string_with_context( fnd_log.level_exception,
2953: l_label,
2954: l_debug_str, NULL,
2955: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2956: END IF;

Line 3053: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

3049: );
3050:
3051: IF (l_return_status = 'E' OR l_return_status = 'U') THEN
3052:
3053: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
3054:
3055: IF (l_request_id IS NULL) THEN
3056: l_request_id := fnd_global.conc_request_id;
3057: END IF;

Line 3066: fnd_log.string_with_context( fnd_log.level_exception,

3062: || 'Interface Relacad Id : '
3063: || (relacad_rec.interface_relacad_id)
3064: || 'Status : 3' || 'ErrorCode : E014 HzMesg: '||l_msg_data||' SQLERRM:' || SQLERRM;
3065:
3066: fnd_log.string_with_context( fnd_log.level_exception,
3067: l_label,
3068: l_debug_str, NULL,
3069: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3070: END IF;

Line 3172: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

3168:
3169: --ssomani added this check feb 26, 2001
3170: IF (l_return_status = 'E' OR l_return_status = 'U') THEN
3171:
3172: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
3173:
3174: IF (l_request_id IS NULL) THEN
3175: l_request_id := fnd_global.conc_request_id;
3176: END IF;

Line 3185: fnd_log.string_with_context( fnd_log.level_exception,

3181: || 'Interface Relacad Id : '
3182: || (relacad_rec.interface_relacad_id)
3183: || 'Status : 3' || 'ErrorCode : E322 HzMesg: '||l_msg_data||' SQLERRM:' || SQLERRM;
3184:
3185: fnd_log.string_with_context( fnd_log.level_exception,
3186: l_label,
3187: l_debug_str, NULL,
3188: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3189: END IF;

Line 3244: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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
3245: IF (l_request_id IS NULL) THEN
3246: l_request_id := fnd_global.conc_request_id;
3247: END IF;
3248:

Line 3252: fnd_log.string_with_context( fnd_log.level_procedure,

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,
3255: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3256: END IF;

Line 3303: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

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:
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';

Line 3312: fnd_log.string_with_context( fnd_log.level_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));
3316: END IF;

Line 3329: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

3325: END IF;
3326:
3327: EXCEPTION
3328: WHEN OTHERS THEN
3329: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
3330: IF (l_request_id IS NULL) THEN
3331: l_request_id := fnd_global.conc_request_id;
3332: END IF;
3333:

Line 3339: fnd_log.string_with_context( fnd_log.level_exception,

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));
3343: END IF;

Line 3398: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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:
3400: IF (l_request_id IS NULL) THEN
3401: l_request_id := fnd_global.conc_request_id;
3402: END IF;

Line 3407: fnd_log.string_with_context( fnd_log.level_procedure,

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,
3410: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3411: END IF;

Line 3559: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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
3560:
3561: IF (l_request_id IS NULL) THEN
3562: l_request_id := fnd_global.conc_request_id;
3563: END IF;

Line 3568: fnd_log.string_with_context( fnd_log.level_procedure,

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,
3571: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3572: END IF;

Line 3747: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

3743: IF l_enable_log = 'Y' THEN
3744: igs_ad_imp_001.logerrormessage(relns_emp_dtls_rec.interface_relemp_id,'E014','IGS_AD_RELEMP_INT_ALL');
3745: END IF;
3746:
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';

Line 3758: fnd_log.string_with_context( fnd_log.level_exception,

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)
3762: );

Line 3820: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

3816: x_reason_for_leaving => NVL(relns_emp_dtls_rec.reason_for_leaving,chk_dup_rec.reason_for_leaving),
3817: x_mode => 'R'
3818: );
3819: IF l_return_Status IN ('E','U') THEN
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';

Line 3829: fnd_log.string_with_context( fnd_log.level_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)
3833: );

Line 3965: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

3961: l_birth_date DATE;
3962:
3963: BEGIN
3964:
3965: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
3966:
3967: IF (l_request_id IS NULL) THEN
3968: l_request_id := fnd_global.conc_request_id;
3969: END IF;

Line 3974: fnd_log.string_with_context( fnd_log.level_procedure,

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,
3977: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3978: END IF;

Line 4044: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

4040: WHEN OTHERS THEN
4041: p_success := 'N';
4042: p_error_code := 'E277';
4043:
4044: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
4045:
4046: IF (l_request_id IS NULL) THEN
4047: l_request_id := fnd_global.conc_request_id;
4048: END IF;

Line 4058: fnd_log.string_with_context( fnd_log.level_exception,

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,
4061: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4062: END IF;

Line 4155: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

4151: -- UPDATE IGS_AD_INTERFACE
4152:
4153: -- Call Log detail
4154:
4155: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
4156:
4157: IF (l_request_id IS NULL) THEN
4158: l_request_id := fnd_global.conc_request_id;
4159: END IF;

Line 4169: fnd_log.string_with_context( fnd_log.level_exception,

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,
4172: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4173: END IF;

Line 4200: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

4196:
4197:
4198: BEGIN
4199:
4200: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
4201:
4202: IF (l_request_id IS NULL) THEN
4203: l_request_id := fnd_global.conc_request_id;
4204: END IF;

Line 4209: fnd_log.string_with_context( fnd_log.level_procedure,

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,
4212: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4213: END IF;

Line 4322: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

4318: IF l_return_status IN('E','U') THEN
4319: p_status :='3';
4320: p_error_code := 'E005';
4321:
4322: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
4323:
4324: IF (l_request_id IS NULL) THEN
4325: l_request_id := fnd_global.conc_request_id;
4326: END IF;

Line 4336: fnd_log.string_with_context( fnd_log.level_exception,

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,
4339: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4340: END IF;

Line 4372: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

4368: p_status :='3';
4369: p_error_code := 'E005';
4370:
4371:
4372: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
4373:
4374: IF (l_request_id IS NULL) THEN
4375: l_request_id := fnd_global.conc_request_id;
4376: END IF;

Line 4386: fnd_log.string_with_context( fnd_log.level_exception,

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,
4389: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4390: END IF;

Line 4407: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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
4408:
4409: IF (l_request_id IS NULL) THEN
4410: l_request_id := fnd_global.conc_request_id;
4411: END IF;

Line 4416: fnd_log.string_with_context( fnd_log.level_procedure,

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,
4419: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4420: END IF;

Line 4745: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

4741: SET status = '3',error_code = 'E014'
4742: WHERE interface_id = stat_rec.interface_id
4743: AND interface_stat_id = stat_rec.interface_stat_id;
4744:
4745: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
4746:
4747: IF (l_request_id IS NULL) THEN
4748: l_request_id := fnd_global.conc_request_id;
4749: END IF;

Line 4759: fnd_log.string_with_context( fnd_log.level_exception,

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,
4762: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4763: END IF;

Line 4790: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

4786: error_code = 'E518'
4787: WHERE interface_id = stat_rec.interface_id
4788: AND interface_stat_id = stat_rec.interface_stat_id;
4789:
4790: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
4791:
4792: IF (l_request_id IS NULL) THEN
4793: l_request_id := fnd_global.conc_request_id;
4794: END IF;

Line 4804: fnd_log.string_with_context( fnd_log.level_exception,

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,
4807: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4808: END IF;

Line 4928: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

4924: error_code = 'E014'
4925: WHERE interface_id = stat_rec.interface_id
4926: AND interface_stat_id = stat_rec.interface_stat_id;
4927:
4928: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
4929:
4930: IF (l_request_id IS NULL) THEN
4931: l_request_id := fnd_global.conc_request_id;
4932: END IF;

Line 4942: fnd_log.string_with_context( fnd_log.level_exception,

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,
4945: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4946: END IF;

Line 4974: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

4970: interface_id = stat_rec.interface_id
4971: AND interface_stat_id = stat_rec.interface_stat_id;
4972:
4973:
4974: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
4975:
4976: IF (l_request_id IS NULL) THEN
4977: l_request_id := fnd_global.conc_request_id;
4978: END IF;

Line 4988: fnd_log.string_with_context( fnd_log.level_exception,

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,
4991: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
4992: END IF;

Line 5011: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

5007: WHERE
5008: interface_id = stat_rec.interface_id
5009: AND interface_stat_id = stat_rec.interface_stat_id;
5010:
5011: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
5012:
5013: IF (l_request_id IS NULL) THEN
5014: l_request_id := fnd_global.conc_request_id;
5015: END IF;

Line 5025: fnd_log.string_with_context( fnd_log.level_exception,

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,
5028: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5029: END IF;

Line 5057: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

5053: WHERE interface_id = stat_rec.interface_id
5054: AND interface_stat_id = stat_rec.interface_stat_id;
5055:
5056:
5057: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
5058:
5059: IF (l_request_id IS NULL) THEN
5060: l_request_id := fnd_global.conc_request_id;
5061: END IF;

Line 5071: fnd_log.string_with_context( fnd_log.level_exception,

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,
5074: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5075: END IF;

Line 5170: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

5166: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date ,IGS_GE_DATE.igsdate('4712/12/31')) )
5167: );
5168: BEGIN
5169: -- Call Log header
5170: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
5171:
5172: IF (l_request_id IS NULL) THEN
5173: l_request_id := fnd_global.conc_request_id;
5174: END IF;

Line 5179: fnd_log.string_with_context( fnd_log.level_procedure,

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,
5182: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5183: END IF;

Line 5219: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

5215: p_status := '3';
5216: p_error_code := 'E161';
5217: -- Call Log detail
5218:
5219: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
5220:
5221: IF (l_request_id IS NULL) THEN
5222: l_request_id := fnd_global.conc_request_id;
5223: END IF;

Line 5233: fnd_log.string_with_context( fnd_log.level_exception,

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,
5236: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5237: END IF;

Line 5291: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

5287: l_error VARCHAR2(30);
5288: BEGIN
5289: -- Call Log header
5290:
5291: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
5292:
5293: IF (l_request_id IS NULL) THEN
5294: l_request_id := fnd_global.conc_request_id;
5295: END IF;

Line 5300: fnd_log.string_with_context( fnd_log.level_procedure,

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,
5303: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5304: END IF;

Line 5387: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

5383: SET status = '3',
5384: error_code = l_error
5385: WHERE interface_eit_id = p_biodemo_rec.interface_eit_id;
5386:
5387: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
5388:
5389: IF (l_request_id IS NULL) THEN
5390: l_request_id := fnd_global.conc_request_id;
5391: END IF;

Line 5401: fnd_log.string_with_context( fnd_log.level_exception,

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,
5404: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5405: END IF;

Line 5426: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

5422: -- Call Log header
5423: l_processed_records := 0;
5424: l_count := 0;
5425:
5426: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
5427:
5428: IF (l_request_id IS NULL) THEN
5429: l_request_id := fnd_global.conc_request_id;
5430: END IF;

Line 5435: fnd_log.string_with_context( fnd_log.level_procedure,

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,
5438: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5439: END IF;

Line 5626: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

5622: WHERE interface_eit_id = biodem_rec.interface_eit_id;
5623:
5624: -- Call Log detail
5625:
5626: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
5627:
5628: IF (l_request_id IS NULL) THEN
5629: l_request_id := fnd_global.conc_request_id;
5630: END IF;

Line 5640: fnd_log.string_with_context( fnd_log.level_exception,

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,
5643: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5644: END IF;

Line 5717: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

5713: WHERE interface_eit_id = biodem_rec.interface_eit_id;
5714:
5715: -- Call Log detail
5716:
5717: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
5718:
5719: IF (l_request_id IS NULL) THEN
5720: l_request_id := fnd_global.conc_request_id;
5721: END IF;

Line 5731: fnd_log.string_with_context( fnd_log.level_exception,

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,
5734: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5735: END IF;

Line 5822: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

5818: igs_ad_imp_025.prc_pe_race (p_source_type_id, p_batch_id);
5819:
5820: EXCEPTION
5821: WHEN OTHERS THEN
5822: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
5823:
5824: IF (l_request_id IS NULL) THEN
5825: l_request_id := fnd_global.conc_request_id;
5826: END IF;

Line 5831: fnd_log.string_with_context( fnd_log.level_exception,

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,
5833: l_debug_str, NULL,
5834: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
5835: END IF;