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;
333:
334: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visa.val_exception' || l_error;
335:
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;
493:
494: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_visa.exception' || l_error;
495:
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;
641:
642: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_visa.exception' || 'E014';
643:
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;
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';
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;
1005:
1006: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.val_exception' || p_err_code;
1007:
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;
1165:
1166: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_pass.exception' || l_error;
1167:
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;
1260:
1261: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_pass.exception' || p_error_code;
1262:
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;
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';
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;
1466:
1467: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.exception' || 'E014';
1468:
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;
1513:
1514: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.exception1' || 'E014';
1515:
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;
1688:
1689: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.val_exception' || p_err_code;
1690:
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;
1880:
1881: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_visit_histry.exception' || l_error;
1882:
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;
1997:
1998: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_visit_histry.exception' || 'E014';
1999:
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;
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';
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;
2201:
2202: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.exception' || 'E014';
2203:
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;
2249:
2250: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.exception1' || 'E014';
2251:
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;
2449:
2450: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.val_exception' || l_error;
2451:
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;
2555:
2556: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.crt_exception' || l_error;
2557:
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;
2666:
2667: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.upd_exception' || 'E014';
2668:
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;
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';
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;
2851:
2852: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.exception1 ' || 'E014';
2853:
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;
2901:
2902: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.exception2 ' || 'E014';
2903:
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;
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';