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_002 dependencies on FND_GLOBAL

Line 278: l_request_id := fnd_global.conc_request_id;

274: -- Call Log header
275: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
276:
277: IF (l_request_id IS NULL) THEN
278: l_request_id := fnd_global.conc_request_id;
279: END IF;
280:
281: l_label := 'igs.plsql.igs_ad_imp_002.create_person.begin';
282: l_debug_str := 'Interface Id : ' || P_person_rec.INTERFACE_ID;

Line 543: l_request_id := fnd_global.conc_request_id;

539:
540: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
541:
542: IF (l_request_id IS NULL) THEN
543: l_request_id := fnd_global.conc_request_id;
544: END IF;
545:
546: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||'E322';
547:

Line 591: l_request_id := fnd_global.conc_request_id;

587: -- Call Log detail
588: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
589:
590: IF (l_request_id IS NULL) THEN
591: l_request_id := fnd_global.conc_request_id;
592: END IF;
593:
594: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||l_error_code;
595:

Line 822: l_request_id := fnd_global.conc_request_id;

818: -- Call Log detail
819: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
820:
821: IF (l_request_id IS NULL) THEN
822: l_request_id := fnd_global.conc_request_id;
823: END IF;
824:
825: l_label := 'igs.plsql.IGS_AD_IMP_002.create_person.exception:E005';
826:

Line 882: l_request_id := fnd_global.conc_request_id;

878: -- Call Log detail
879: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
880:
881: IF (l_request_id IS NULL) THEN
882: l_request_id := fnd_global.conc_request_id;
883: END IF;
884: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||'E005';
885:
886: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG' || l_msg_data ||

Line 1212: l_request_id := fnd_global.conc_request_id;

1208: -- Call Log header
1209: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1210:
1211: IF (l_request_id IS NULL) THEN
1212: l_request_id := fnd_global.conc_request_id;
1213: END IF;
1214:
1215: l_label := 'igs.plsql.igs_ad_imp_002.update_person.begin';
1216: l_debug_str := 'Interface Id : ' || P_person_rec.INTERFACE_ID;

Line 1516: l_request_id := fnd_global.conc_request_id;

1512:
1513: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1514: l_msg_data := SQLERRM ; --ssomani, added this 3/15/01
1515: IF (l_request_id IS NULL) THEN
1516: l_request_id := fnd_global.conc_request_id;
1517: END IF;
1518:
1519: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||l_error_code;
1520:

Line 1548: l_request_id := fnd_global.conc_request_id;

1544:
1545: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1546:
1547: IF (l_request_id IS NULL) THEN
1548: l_request_id := fnd_global.conc_request_id;
1549: END IF;
1550:
1551: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||'E014';
1552:

Line 1618: l_request_id := fnd_global.conc_request_id;

1614: IF l_location_id IS NOT NULL THEN
1615: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1616:
1617: IF (l_request_id IS NULL) THEN
1618: l_request_id := fnd_global.conc_request_id;
1619: END IF;
1620:
1621: l_label := 'igs.plsql.igs_ad_imp_002.update_person.duplicate_address_exists';
1622: l_debug_str := 'Interface Id : ' || P_person_rec.INTERFACE_ID;

Line 1639: l_request_id := fnd_global.conc_request_id;

1635: -- Address not exists. Create it.
1636: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1637:
1638: IF (l_request_id IS NULL) THEN
1639: l_request_id := fnd_global.conc_request_id;
1640: END IF;
1641:
1642: l_label := 'igs.plsql.igs_ad_imp_002.update_person.duplicate_address_doesnot_exist';
1643: l_debug_str := 'Interface Id : ' || P_person_rec.INTERFACE_ID;

Line 1858: l_request_id := fnd_global.conc_request_id;

1854: p_status := '3';
1855: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1856:
1857: IF (l_request_id IS NULL) THEN
1858: l_request_id := fnd_global.conc_request_id;
1859: END IF;
1860: l_label := 'igs.plsql.igs_ad_imp_002.validate_api.exception'||p_error_code;
1861: l_debug_str := 'Igs_Ad_Imp_002.Create_Api.validate_api'
1862: ||'Validation Failed'

Line 1890: l_request_id := fnd_global.conc_request_id;

1886:
1887: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1888:
1889: IF (l_request_id IS NULL) THEN
1890: l_request_id := fnd_global.conc_request_id;
1891: END IF;
1892:
1893: l_label := 'igs.plsql.igs_ad_imp_002.create_api.begin';
1894: l_debug_str := 'start of create_api proc';

Line 2020: l_request_id := fnd_global.conc_request_id;

2016:
2017: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2018:
2019: IF (l_request_id IS NULL) THEN
2020: l_request_id := fnd_global.conc_request_id;
2021: END IF;
2022:
2023: l_label := 'igs.plsql.igs_ad_imp_002.create_api.exception'||p_error_code;
2024:

Line 2117: l_request_id := fnd_global.conc_request_id;

2113: p_error_code := 'E014';
2114: END IF;
2115: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2116: IF (l_request_id IS NULL) THEN
2117: l_request_id := fnd_global.conc_request_id;
2118: END IF;
2119:
2120: l_label := 'igs.plsql.igs_ad_imp_002.create_api.exception1'||p_error_code;
2121:

Line 2211: l_request_id := fnd_global.conc_request_id;

2207: l_failure_child := 0;
2208: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2209:
2210: IF (l_request_id IS NULL) THEN
2211: l_request_id := fnd_global.conc_request_id;
2212: END IF;
2213:
2214: l_label := 'igs.plsql.igs_ad_imp_002.create_address.process_addrusage_begin';
2215: l_debug_str := 'Interface Addr Id : ' || l_interface_addr_id;

Line 2273: l_request_id := fnd_global.conc_request_id;

2269: l_error_code := 'E244';
2270: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2271:
2272: IF (l_request_id IS NULL) THEN
2273: l_request_id := fnd_global.conc_request_id;
2274: END IF;
2275:
2276: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E224';
2277:

Line 2337: l_request_id := fnd_global.conc_request_id;

2333:
2334: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2335:
2336: IF (l_request_id IS NULL) THEN
2337: l_request_id := fnd_global.conc_request_id;
2338: END IF;
2339:
2340: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';
2341:

Line 2368: l_request_id := fnd_global.conc_request_id;

2364: -- Call Log header
2365: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2366:
2367: IF (l_request_id IS NULL) THEN
2368: l_request_id := fnd_global.conc_request_id;
2369: END IF;
2370:
2371: l_label := 'igs.plsql.igs_ad_imp_002.create_address.begin';
2372: l_debug_str := 'Start of create_address proc';

Line 2438: l_request_id := fnd_global.conc_request_id;

2434:
2435: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2436:
2437: IF (l_request_id IS NULL) THEN
2438: l_request_id := fnd_global.conc_request_id;
2439: END IF;
2440:
2441: l_label := 'igs.plsql.igs_ad_imp_002.create_address.exception'||'E006';
2442:

Line 2467: l_request_id := fnd_global.conc_request_id;

2463:
2464: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2465:
2466: IF (l_request_id IS NULL) THEN
2467: l_request_id := fnd_global.conc_request_id;
2468: END IF;
2469:
2470: l_label := 'igs.plsql.igs_ad_imp_002.create_address.warning'||'E073';
2471:

Line 2533: l_request_id := fnd_global.conc_request_id;

2529:
2530: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2531:
2532: IF (l_request_id IS NULL) THEN
2533: l_request_id := fnd_global.conc_request_id;
2534: END IF;
2535:
2536: l_label := 'igs.plsql.igs_ad_imp_002.create_address.exception'||'E006';
2537:

Line 2638: l_request_id := fnd_global.conc_request_id;

2634: l_failure_child := 0;
2635: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2636:
2637: IF (l_request_id IS NULL) THEN
2638: l_request_id := fnd_global.conc_request_id;
2639: END IF;
2640:
2641: l_label := 'igs.plsql.igs_ad_imp_006.update_address.process_addrusage_begin';
2642: l_debug_str := 'Interface addr Id : ' || l_interface_addr_id;

Line 2701: l_request_id := fnd_global.conc_request_id;

2697: l_error_code := 'E244';
2698: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2699:
2700: IF (l_request_id IS NULL) THEN
2701: l_request_id := fnd_global.conc_request_id;
2702: END IF;
2703:
2704: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';
2705:

Line 2765: l_request_id := fnd_global.conc_request_id;

2761:
2762: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2763:
2764: IF (l_request_id IS NULL) THEN
2765: l_request_id := fnd_global.conc_request_id;
2766: END IF;
2767:
2768: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';
2769:

Line 2799: l_request_id := fnd_global.conc_request_id;

2795: -- Call Log header
2796: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2797:
2798: IF (l_request_id IS NULL) THEN
2799: l_request_id := fnd_global.conc_request_id;
2800: END IF;
2801:
2802: l_label := 'igs.plsql.igs_ad_imp_002.Update_Address.begin';
2803: l_debug_str := 'start of update_address';

Line 2819: l_request_id := fnd_global.conc_request_id;

2815:
2816: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2817:
2818: IF (l_request_id IS NULL) THEN
2819: l_request_id := fnd_global.conc_request_id;
2820: END IF;
2821:
2822: l_label := 'igs.plsql.igs_ad_imp_002.validate_address.exception'||p_error_code;
2823:

Line 2901: l_request_id := fnd_global.conc_request_id;

2897: p_error_code := 'E014';
2898: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2899:
2900: IF (l_request_id IS NULL) THEN
2901: l_request_id := fnd_global.conc_request_id;
2902: END IF;
2903:
2904: l_label := 'igs.plsql.igs_ad_imp_002.update_address.exception'||p_error_code;
2905:

Line 2928: l_request_id := fnd_global.conc_request_id;

2924:
2925: p_error_code := 'E073';
2926: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2927: IF (l_request_id IS NULL) THEN
2928: l_request_id := fnd_global.conc_request_id;
2929: END IF;
2930:
2931: l_label := 'igs.plsql.igs_ad_imp_002.update_address.warning'||p_error_code;
2932:

Line 2973: l_request_id := fnd_global.conc_request_id;

2969:
2970: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2971:
2972: IF (l_request_id IS NULL) THEN
2973: l_request_id := fnd_global.conc_request_id;
2974: END IF;
2975:
2976: l_label := 'igs.plsql.igs_ad_imp_002.update_address.exception'||'E014';
2977: