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_026 dependencies on FND_LOG

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

324:
325: p_error_code := l_error;
326: -- CALL LOG DETAIL
327:
328: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
329:
330: IF (l_request_id IS NULL) THEN
331: l_request_id := fnd_global.conc_request_id;
332: END IF;

Line 342: fnd_log.string_with_context( fnd_log.level_exception,

338: fnd_message.set_token('ERROR_CD',l_error);
339:
340: l_debug_str := fnd_message.get || ' ' || SQLERRM;
341:
342: fnd_log.string_with_context( fnd_log.level_exception,
343: l_label,
344: l_debug_str, NULL,
345: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
346: END IF;

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

484: ELSIF l_message_name = 'IGS_PE_VIS_ASOC_PASS_EXP' THEN
485: l_error:='E287';
486: ELSE
487: l_error := 'E322';
488: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
489:
490: IF (l_request_id IS NULL) THEN
491: l_request_id := fnd_global.conc_request_id;
492: END IF;

Line 502: fnd_log.string_with_context( fnd_log.level_exception,

498: fnd_message.set_token('ERROR_CD',l_error);
499:
500: l_debug_str := fnd_message.get || ' ' || SQLERRM;
501:
502: fnd_log.string_with_context( fnd_log.level_exception,
503: l_label,
504: l_debug_str, NULL,
505: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
506: END IF;

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

632: WHERE interface_visa_id = visa_rec.interface_visa_id;
633:
634: -- CALL LOG DETAIL
635:
636: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
637:
638: IF (l_request_id IS NULL) THEN
639: l_request_id := fnd_global.conc_request_id;
640: END IF;

Line 650: fnd_log.string_with_context( fnd_log.level_exception,

646: fnd_message.set_token('ERROR_CD','E014');
647:
648: l_debug_str := fnd_message.get || ' ' || SQLERRM;
649:
650: fnd_log.string_with_context( fnd_log.level_exception,
651: l_label,
652: l_debug_str, NULL,
653: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
654: END IF;

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

669: l_prog_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visa';
670: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visa.';
671: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
672:
673: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
674:
675: IF (l_request_id IS NULL) THEN
676: l_request_id := fnd_global.conc_request_id;
677: END IF;

Line 682: fnd_log.string_with_context( fnd_log.level_procedure,

678:
679: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visa.begin';
680: l_debug_str := 'IGS_AD_IMP_026.prc_pe_visa';
681:
682: fnd_log.string_with_context( fnd_log.level_procedure,
683: l_label,
684: l_debug_str, NULL,
685: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
686: END IF;

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

996: END IF;
997:
998: -- CALL LOG DETAIL
999:
1000: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1001:
1002: IF (l_request_id IS NULL) THEN
1003: l_request_id := fnd_global.conc_request_id;
1004: END IF;

Line 1014: fnd_log.string_with_context( fnd_log.level_exception,

1010: fnd_message.set_token('ERROR_CD',p_err_code);
1011:
1012: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1013:
1014: fnd_log.string_with_context( fnd_log.level_exception,
1015: l_label,
1016: l_debug_str, NULL,
1017: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1018: END IF;

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

1156: WHERE interface_passport_id = pass_rec.interface_passport_id;
1157:
1158: -- CALL LOG DETAIL
1159:
1160: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1161:
1162: IF (l_request_id IS NULL) THEN
1163: l_request_id := fnd_global.conc_request_id;
1164: END IF;

Line 1174: fnd_log.string_with_context( fnd_log.level_exception,

1170: fnd_message.set_token('ERROR_CD',l_error);
1171:
1172: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1173:
1174: fnd_log.string_with_context( fnd_log.level_exception,
1175: l_label,
1176: l_debug_str, NULL,
1177: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1178: END IF;

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

1251: p_status := '3';
1252:
1253: -- CALL LOG DETAIL
1254:
1255: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1256:
1257: IF (l_request_id IS NULL) THEN
1258: l_request_id := fnd_global.conc_request_id;
1259: END IF;

Line 1269: fnd_log.string_with_context( fnd_log.level_exception,

1265: fnd_message.set_token('ERROR_CD',p_error_code);
1266:
1267: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1268:
1269: fnd_log.string_with_context( fnd_log.level_exception,
1270: l_label,
1271: l_debug_str, NULL,
1272: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1273: END IF;

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

1292: l_prog_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport';
1293: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.';
1294: l_enable_log := igs_ad_imp_001.g_enable_log;
1295: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1296: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1297:
1298: IF (l_request_id IS NULL) THEN
1299: l_request_id := fnd_global.conc_request_id;
1300: END IF;

Line 1305: fnd_log.string_with_context( fnd_log.level_procedure,

1301:
1302: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.begin';
1303: l_debug_str := 'IGS_AD_IMP_026.prc_pe_passport';
1304:
1305: fnd_log.string_with_context( fnd_log.level_procedure,
1306: l_label,
1307: l_debug_str, NULL,
1308: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1309: END IF;

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

1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460:
1461: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1462:
1463: IF (l_request_id IS NULL) THEN
1464: l_request_id := fnd_global.conc_request_id;
1465: END IF;

Line 1475: fnd_log.string_with_context( fnd_log.level_exception,

1471: fnd_message.set_token('ERROR_CD','E014');
1472:
1473: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1474:
1475: fnd_log.string_with_context( fnd_log.level_exception,
1476: l_label,
1477: l_debug_str, NULL,
1478: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1479: END IF;

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

1504:
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507:
1508: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1509:
1510: IF (l_request_id IS NULL) THEN
1511: l_request_id := fnd_global.conc_request_id;
1512: END IF;

Line 1522: fnd_log.string_with_context( fnd_log.level_exception,

1518: fnd_message.set_token('ERROR_CD','E014');
1519:
1520: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1521:
1522: fnd_log.string_with_context( fnd_log.level_exception,
1523: l_label,
1524: l_debug_str, NULL,
1525: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1526: END IF;

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

1679: END IF;
1680:
1681: -- CALL LOG DETAIL
1682:
1683: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1684:
1685: IF (l_request_id IS NULL) THEN
1686: l_request_id := fnd_global.conc_request_id;
1687: END IF;

Line 1697: fnd_log.string_with_context( fnd_log.level_exception,

1693: fnd_message.set_token('ERROR_CD',p_err_code);
1694:
1695: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1696:
1697: fnd_log.string_with_context( fnd_log.level_exception,
1698: l_label,
1699: l_debug_str, NULL,
1700: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1701: END IF;

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

1871: l_error := 'E322';
1872:
1873: -- CALL LOG DETAIL
1874:
1875: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1876:
1877: IF (l_request_id IS NULL) THEN
1878: l_request_id := fnd_global.conc_request_id;
1879: END IF;

Line 1889: fnd_log.string_with_context( fnd_log.level_exception,

1885: fnd_message.set_token('ERROR_CD',l_error);
1886:
1887: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1888:
1889: fnd_log.string_with_context( fnd_log.level_exception,
1890: l_label,
1891: l_debug_str, NULL,
1892: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1893: END IF;

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

1988: error_code = 'E014'
1989: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
1990:
1991: -- CALL LOG DETAIL
1992: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1993:
1994: IF (l_request_id IS NULL) THEN
1995: l_request_id := fnd_global.conc_request_id;
1996: END IF;

Line 2006: fnd_log.string_with_context( fnd_log.level_exception,

2002: fnd_message.set_token('ERROR_CD','E014');
2003:
2004: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2005:
2006: fnd_log.string_with_context( fnd_log.level_exception,
2007: l_label,
2008: l_debug_str, NULL,
2009: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2010: END IF;

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

2026: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
2027:
2028: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_INTERNATIONAL_DETAILS');
2029:
2030: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2031:
2032: IF (l_request_id IS NULL) THEN
2033: l_request_id := fnd_global.conc_request_id;
2034: END IF;

Line 2039: fnd_log.string_with_context( fnd_log.level_procedure,

2035:
2036: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.begin';
2037: l_debug_str := 'IGS_AD_IMP_026.prc_pe_visit_histry';
2038:
2039: fnd_log.string_with_context( fnd_log.level_procedure,
2040: l_label,
2041: l_debug_str, NULL,
2042: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2043: END IF;

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

2192:
2193: EXCEPTION
2194: WHEN OTHERS THEN
2195:
2196: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2197:
2198: IF (l_request_id IS NULL) THEN
2199: l_request_id := fnd_global.conc_request_id;
2200: END IF;

Line 2210: fnd_log.string_with_context( fnd_log.level_exception,

2206: fnd_message.set_token('ERROR_CD','E014');
2207:
2208: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2209:
2210: fnd_log.string_with_context( fnd_log.level_exception,
2211: l_label,
2212: l_debug_str, NULL,
2213: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2214: END IF;

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

2240:
2241: EXCEPTION
2242: WHEN OTHERS THEN
2243:
2244: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2245:
2246: IF (l_request_id IS NULL) THEN
2247: l_request_id := fnd_global.conc_request_id;
2248: END IF;

Line 2258: fnd_log.string_with_context( fnd_log.level_exception,

2254: fnd_message.set_token('ERROR_CD','E014');
2255:
2256: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2257:
2258: fnd_log.string_with_context( fnd_log.level_exception,
2259: l_label,
2260: l_debug_str, NULL,
2261: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2262: END IF;

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

2440: WHERE interface_eit_id = eit_rec.interface_eit_id;
2441:
2442: -- CALL LOG DETAIL
2443:
2444: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2445:
2446: IF (l_request_id IS NULL) THEN
2447: l_request_id := fnd_global.conc_request_id;
2448: END IF;

Line 2458: fnd_log.string_with_context( fnd_log.level_exception,

2454: fnd_message.set_token('ERROR_CD',l_error);
2455:
2456: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2457:
2458: fnd_log.string_with_context( fnd_log.level_exception,
2459: l_label,
2460: l_debug_str, NULL,
2461: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2462: END IF;

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

2546: WHERE interface_eit_id = eit_rec.interface_eit_id;
2547:
2548: -- CALL LOG DETAIL
2549:
2550: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2551:
2552: IF (l_request_id IS NULL) THEN
2553: l_request_id := fnd_global.conc_request_id;
2554: END IF;

Line 2564: fnd_log.string_with_context( fnd_log.level_exception,

2560: fnd_message.set_token('ERROR_CD',l_error);
2561:
2562: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2563:
2564: fnd_log.string_with_context( fnd_log.level_exception,
2565: l_label,
2566: l_debug_str, NULL,
2567: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2568: END IF;

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

2657: WHERE interface_eit_id = eit_rec.interface_eit_id;
2658:
2659: -- CALL LOG DETAIL
2660:
2661: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2662:
2663: IF (l_request_id IS NULL) THEN
2664: l_request_id := fnd_global.conc_request_id;
2665: END IF;

Line 2675: fnd_log.string_with_context( fnd_log.level_exception,

2671: fnd_message.set_token('ERROR_CD','E014');
2672:
2673: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2674:
2675: fnd_log.string_with_context( fnd_log.level_exception,
2676: l_label,
2677: l_debug_str, NULL,
2678: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2679: END IF;

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

2691: l_prog_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit';
2692: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.';
2693: l_enable_log := igs_ad_imp_001.g_enable_log;
2694: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
2695: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2696:
2697: IF (l_request_id IS NULL) THEN
2698: l_request_id := fnd_global.conc_request_id;
2699: END IF;

Line 2704: fnd_log.string_with_context( fnd_log.level_procedure,

2700:
2701: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.begin';
2702: l_debug_str := 'IGS_AD_IMP_026.prc_pe_eit';
2703:
2704: fnd_log.string_with_context( fnd_log.level_procedure,
2705: l_label,
2706: l_debug_str, NULL,
2707: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2708: END IF;

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

2842:
2843: EXCEPTION
2844: WHEN OTHERS THEN
2845:
2846: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2847:
2848: IF (l_request_id IS NULL) THEN
2849: l_request_id := fnd_global.conc_request_id;
2850: END IF;

Line 2860: fnd_log.string_with_context( fnd_log.level_exception,

2856: fnd_message.set_token('ERROR_CD','E014');
2857:
2858: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2859:
2860: fnd_log.string_with_context( fnd_log.level_exception,
2861: l_label,
2862: l_debug_str, NULL,
2863: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2864: END IF;

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

2892:
2893: EXCEPTION
2894: WHEN OTHERS THEN
2895:
2896: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2897:
2898: IF (l_request_id IS NULL) THEN
2899: l_request_id := fnd_global.conc_request_id;
2900: END IF;

Line 2910: fnd_log.string_with_context( fnd_log.level_exception,

2906: fnd_message.set_token('ERROR_CD','E014');
2907:
2908: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2909:
2910: fnd_log.string_with_context( fnd_log.level_exception,
2911: l_label,
2912: l_debug_str, NULL,
2913: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2914: END IF;

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

3017: l_prog_label := 'igs.plsql.igs_ad_imp_026.prc_pe_addr';
3018: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_addr.';
3019: l_enable_log := igs_ad_imp_001.g_enable_log;
3020: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3021: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
3022:
3023: IF (l_request_id IS NULL) THEN
3024: l_request_id := fnd_global.conc_request_id;
3025: END IF;

Line 3030: fnd_log.string_with_context( fnd_log.level_procedure,

3026:
3027: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_addr.begin';
3028: l_debug_str := 'Igs_Ad_Imp_005.PRC_PE_ADDR';
3029:
3030: fnd_log.string_with_context( fnd_log.level_procedure,
3031: l_label,
3032: l_debug_str, NULL,
3033: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3034: END IF;