DBA Data[Home] [Help]

APPS.IGS_AD_IMP_011 dependencies on FND_GLOBAL

Line 187: l_request_id := fnd_global.conc_request_id;

183: -- Call Log header
184: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
185:
186: IF (l_request_id IS NULL) THEN
187: l_request_id := fnd_global.conc_request_id;
188: END IF;
189:
190: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.begin';
191: l_debug_str := 'start of proc crt_apcnt_acad_hnr';

Line 226: l_request_id := fnd_global.conc_request_id;

222:
223: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
224:
225: IF (l_request_id IS NULL) THEN
226: l_request_id := fnd_global.conc_request_id;
227: END IF;
228:
229: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.exception'||l_error_code;
230:

Line 413: l_request_id := fnd_global.conc_request_id;

409:
410: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
411:
412: IF (l_request_id IS NULL) THEN
413: l_request_id := fnd_global.conc_request_id;
414: END IF;
415:
416: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception_update1'||'E014';
417:

Line 468: l_request_id := fnd_global.conc_request_id;

464:
465: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
466:
467: IF (l_request_id IS NULL) THEN
468: l_request_id := fnd_global.conc_request_id;
469: END IF;
470:
471: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception_update2'||'E014';
472:

Line 535: l_request_id := fnd_global.conc_request_id;

531: interface_acadhonor_id = acadhonor_rec.interface_acadhonor_id;
532: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
533:
534: IF (l_request_id IS NULL) THEN
535: l_request_id := fnd_global.conc_request_id;
536: END IF;
537:
538: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception'||'E518';
539:

Line 764: l_request_id := fnd_global.conc_request_id;

760: -- Call Log header
761: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
762:
763: IF (l_request_id IS NULL) THEN
764: l_request_id := fnd_global.conc_request_id;
765: END IF;
766:
767: l_label := 'igs.plsql.igs_ad_imp_011.crt_res_dtls.begin';
768: l_debug_str := 'Interface Res Id : ' || res_dtl_rec.interface_res_id;

Line 830: l_request_id := fnd_global.conc_request_id;

826:
827: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
828:
829: IF (l_request_id IS NULL) THEN
830: l_request_id := fnd_global.conc_request_id;
831: END IF;
832:
833: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.exception'||'E322';
834:

Line 904: l_request_id := fnd_global.conc_request_id;

900: p_error_code := 'E014';
901: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
902:
903: IF (l_request_id IS NULL) THEN
904: l_request_id := fnd_global.conc_request_id;
905: END IF;
906:
907: l_label := 'igs.plsql.igs_ad_imp_011.update_res.exception'||'E014';
908: l_debug_str := 'IGS_AD_IMP_011.PRC_PE_RES_DTLS.UPDATE_RES ' ||

Line 1121: l_request_id := fnd_global.conc_request_id;

1117: WHERE interface_res_id = res_dtl_rec.interface_res_id;
1118: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1119:
1120: IF (l_request_id IS NULL) THEN
1121: l_request_id := fnd_global.conc_request_id;
1122: END IF;
1123:
1124: l_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls.exception'||'E518';
1125:

Line 1655: l_request_id := fnd_global.conc_request_id;

1651:
1652: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1653:
1654: IF (l_request_id IS NULL) THEN
1655: l_request_id := fnd_global.conc_request_id;
1656: END IF;
1657:
1658: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.begin';
1659: l_debug_str := 'Interface Disability Id : ' || p_disability_rec.interface_disablty_id;

Line 1739: l_request_id := fnd_global.conc_request_id;

1735:
1736: IF p_error_code = 'E145' THEN
1737: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1738: IF (l_request_id IS NULL) THEN
1739: l_request_id := fnd_global.conc_request_id;
1740: END IF;
1741: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.exception'||'E145';
1742: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_Disability '||'Unhandled Exception'
1743: ||' for INTERFACE DISABLTY ID :'|| p_disability_rec.interface_disablty_id|| ' Status : 3'||

Line 1756: l_request_id := fnd_global.conc_request_id;

1752: END IF;
1753: ELSE
1754: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1755: IF (l_request_id IS NULL) THEN
1756: l_request_id := fnd_global.conc_request_id;
1757: END IF;
1758: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.exception'||p_error_code;
1759: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_Disability '||'Ovelapping records exist'
1760: ||' for INTERFACE DISABLTY ID :'|| p_disability_rec.interface_disablty_id|| ' Status : 3'

Line 1861: l_request_id := fnd_global.conc_request_id;

1857: IF l_error_code = 'E146' THEN
1858: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1859:
1860: IF (l_request_id IS NULL) THEN
1861: l_request_id := fnd_global.conc_request_id;
1862: END IF;
1863:
1864: l_label := 'igs.plsql.igs_ad_imp_011.update_disability.exception'||l_error_code;
1865:

Line 1885: l_request_id := fnd_global.conc_request_id;

1881: ELSE
1882: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1883:
1884: IF (l_request_id IS NULL) THEN
1885: l_request_id := fnd_global.conc_request_id;
1886: END IF;
1887:
1888: l_label := 'igs.plsql.igs_ad_imp_011.update_disability.exception'||l_error_code;
1889:

Line 1938: l_request_id := fnd_global.conc_request_id;

1934:
1935: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1936:
1937: IF (l_request_id IS NULL) THEN
1938: l_request_id := fnd_global.conc_request_id;
1939: END IF;
1940:
1941: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_service.begin';
1942: l_debug_str := 'Interface sn service Id : ' || p_sn_service_rec.interface_sn_service_id;

Line 1989: l_request_id := fnd_global.conc_request_id;

1985:
1986: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1987:
1988: IF (l_request_id IS NULL) THEN
1989: l_request_id := fnd_global.conc_request_id;
1990: END IF;
1991:
1992: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_service.exception'||l_error_code;
1993:

Line 2043: l_request_id := fnd_global.conc_request_id;

2039:
2040: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2041:
2042: IF (l_request_id IS NULL) THEN
2043: l_request_id := fnd_global.conc_request_id;
2044: END IF;
2045:
2046: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_contact.begin';
2047: l_debug_str := 'Interface sn contact Id : ' || p_sn_contact_rec.interface_sn_contact_id;

Line 2094: l_request_id := fnd_global.conc_request_id;

2090:
2091: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2092:
2093: IF (l_request_id IS NULL) THEN
2094: l_request_id := fnd_global.conc_request_id;
2095: END IF;
2096:
2097: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_contact.exception'||l_error_code;
2098:

Line 2148: l_request_id := fnd_global.conc_request_id;

2144: -- Call Log header
2145: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2146:
2147: IF (l_request_id IS NULL) THEN
2148: l_request_id := fnd_global.conc_request_id;
2149: END IF;
2150:
2151: l_label := 'igs.plsql.igs_ad_imp_011.prcess_sn_service.begin';
2152: l_debug_str := 'Interface sn service Id : ' || sn_service_rec.interface_sn_service_id;

Line 2299: l_request_id := fnd_global.conc_request_id;

2295:
2296: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2297:
2298: IF (l_request_id IS NULL) THEN
2299: l_request_id := fnd_global.conc_request_id;
2300: END IF;
2301:
2302: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;
2303:

Line 2364: l_request_id := fnd_global.conc_request_id;

2360:
2361: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2362:
2363: IF (l_request_id IS NULL) THEN
2364: l_request_id := fnd_global.conc_request_id;
2365: END IF;
2366:
2367: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;
2368:

Line 2425: l_request_id := fnd_global.conc_request_id;

2421: -- Call Log header
2422: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2423:
2424: IF (l_request_id IS NULL) THEN
2425: l_request_id := fnd_global.conc_request_id;
2426: END IF;
2427:
2428: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.begin';
2429: l_debug_str := 'Interface Disability Id : ' || p_interface_disability_id;

Line 2570: l_request_id := fnd_global.conc_request_id;

2566:
2567: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2568:
2569: IF (l_request_id IS NULL) THEN
2570: l_request_id := fnd_global.conc_request_id;
2571: END IF;
2572:
2573: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;
2574:

Line 2636: l_request_id := fnd_global.conc_request_id;

2632:
2633: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2634:
2635: IF (l_request_id IS NULL) THEN
2636: l_request_id := fnd_global.conc_request_id;
2637: END IF;
2638:
2639: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;
2640:

Line 2705: l_request_id := fnd_global.conc_request_id;

2701: -- Call Log header
2702: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2703:
2704: IF (l_request_id IS NULL) THEN
2705: l_request_id := fnd_global.conc_request_id;
2706: END IF;
2707:
2708: l_label := 'igs.plsql.igs_ad_imp_011.process_disability.begin';
2709: l_debug_str := 'igs_ad_imp_011.process_disability begin';