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

Line 121: l_request_id := fnd_global.conc_request_id;

117:
118: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
119:
120: IF (l_request_id IS NULL) THEN
121: l_request_id := fnd_global.conc_request_id;
122: END IF;
123:
124: l_label := 'igs.plsql.igs_ad_imp_007.crt_pr_mil.begin';
125: l_debug_str := 'Interface military Id : ' || MILITARY_REC.Interface_military_Id;

Line 178: l_request_id := fnd_global.conc_request_id;

174:
175: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
176:
177: IF (l_request_id IS NULL) THEN
178: l_request_id := fnd_global.conc_request_id;
179: END IF;
180:
181: l_label := 'igs.plsql.igs_ad_imp_007.crt_pr_mil.exception';
182:

Line 517: l_request_id := fnd_global.conc_request_id;

513:
514: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
515:
516: IF (l_request_id IS NULL) THEN
517: l_request_id := fnd_global.conc_request_id;
518: END IF;
519:
520: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.exception: '|| 'E014';
521:

Line 588: l_request_id := fnd_global.conc_request_id;

584:
585: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
586:
587: IF (l_request_id IS NULL) THEN
588: l_request_id := fnd_global.conc_request_id;
589: END IF;
590:
591: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.exception: '|| 'E014';
592:

Line 802: l_request_id := fnd_global.conc_request_id;

798:
799: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
800:
801: IF (l_request_id IS NULL) THEN
802: l_request_id := fnd_global.conc_request_id;
803: END IF;
804:
805: l_label := 'igs.plsql.igs_ad_imp_007.crt_health_ins.begin';
806: l_debug_str := 'INTERFACE_IMMU_DTLS_ID:'||health_insur_rec.INTERFACE_IMMU_DTLS_ID;

Line 901: l_request_id := fnd_global.conc_request_id;

897:
898: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
899:
900: IF (l_request_id IS NULL) THEN
901: l_request_id := fnd_global.conc_request_id;
902: END IF;
903:
904: l_label := 'igs.plsql.igs_ad_imp_007.crt_health_ins.exception';
905:

Line 937: l_request_id := fnd_global.conc_request_id;

933: -- Perform validations for the columns
934: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
935:
936: IF (l_request_id IS NULL) THEN
937: l_request_id := fnd_global.conc_request_id;
938: END IF;
939:
940: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.begin';
941: l_debug_str := 'igs_ad_imp_007.prc_pe_immu_dtls.begin';

Line 1150: l_request_id := fnd_global.conc_request_id;

1146:
1147: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1148:
1149: IF (l_request_id IS NULL) THEN
1150: l_request_id := fnd_global.conc_request_id;
1151: END IF;
1152:
1153: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.exception';
1154:

Line 1264: l_request_id := fnd_global.conc_request_id;

1260:
1261: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1262:
1263: IF (l_request_id IS NULL) THEN
1264: l_request_id := fnd_global.conc_request_id;
1265: END IF;
1266:
1267: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.exception: '|| l_error_code;
1268:

Line 1361: l_request_id := fnd_global.conc_request_id;

1357:
1358: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1359:
1360: IF (l_request_id IS NULL) THEN
1361: l_request_id := fnd_global.conc_request_id;
1362: END IF;
1363:
1364: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_hlth_ins.begin';
1365: l_debug_str := 'Interface_hlth_Id: '||(hlth_ins_rec.Interface_hlth_Id);

Line 1420: l_request_id := fnd_global.conc_request_id;

1416:
1417: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1418:
1419: IF (l_request_id IS NULL) THEN
1420: l_request_id := fnd_global.conc_request_id;
1421: END IF;
1422:
1423: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_hlth_ins.exception';
1424:

Line 1530: l_request_id := fnd_global.conc_request_id;

1526:
1527: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1528:
1529: IF (l_request_id IS NULL) THEN
1530: l_request_id := fnd_global.conc_request_id;
1531: END IF;
1532:
1533: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.begin';
1534: l_debug_str := 'igs_ad_imp_007.prc_pe_hlth_ins_dtls.begin';

Line 1733: l_request_id := fnd_global.conc_request_id;

1729: WHERE interface_hlth_id = hlth_ins_rec.interface_hlth_id;
1730: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1731:
1732: IF (l_request_id IS NULL) THEN
1733: l_request_id := fnd_global.conc_request_id;
1734: END IF;
1735:
1736: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.exception1';
1737:

Line 1802: l_request_id := fnd_global.conc_request_id;

1798: WHERE interface_hlth_id = hlth_ins_rec.interface_hlth_id;
1799: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1800:
1801: IF (l_request_id IS NULL) THEN
1802: l_request_id := fnd_global.conc_request_id;
1803: END IF;
1804:
1805: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.exception2';
1806:

Line 2057: l_request_id := fnd_global.conc_request_id;

2053:
2054: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2055:
2056: IF (l_request_id IS NULL) THEN
2057: l_request_id := fnd_global.conc_request_id;
2058: END IF;
2059:
2060: l_label := 'igs.plsql.igs_ad_imp_007.validate_api.exception';
2061:

Line 2110: l_request_id := fnd_global.conc_request_id;

2106:
2107: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2108:
2109: IF (l_request_id IS NULL) THEN
2110: l_request_id := fnd_global.conc_request_id;
2111: END IF;
2112:
2113: l_label := 'igs.plsql.igs_ad_imp_007.crt_person_id_types.begin';
2114: l_debug_str := 'Interface Api Id : '|| p_api_rec.interface_api_id ;

Line 2182: l_request_id := fnd_global.conc_request_id;

2178:
2179: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2180:
2181: IF (l_request_id IS NULL) THEN
2182: l_request_id := fnd_global.conc_request_id;
2183: END IF;
2184:
2185: l_label := 'igs.plsql.igs_ad_imp_007.crt_person_id_types.exception ' || p_error_code;
2186:

Line 2457: l_request_id := fnd_global.conc_request_id;

2453:
2454: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2455:
2456: IF (l_request_id IS NULL) THEN
2457: l_request_id := fnd_global.conc_request_id;
2458: END IF;
2459:
2460: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.exception ' || l_error_code;
2461:

Line 2546: l_request_id := fnd_global.conc_request_id;

2542:
2543: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2544:
2545: IF (l_request_id IS NULL) THEN
2546: l_request_id := fnd_global.conc_request_id;
2547: END IF;
2548:
2549: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.exception ' || l_error_code;
2550:

Line 2695: l_request_id := fnd_global.conc_request_id;

2691:
2692: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2693:
2694: IF (l_request_id IS NULL) THEN
2695: l_request_id := fnd_global.conc_request_id;
2696: END IF;
2697:
2698: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_citizenship.begin';
2699: l_debug_str := 'Interface Citizen Id : ' ||(pcz_rec.interface_citizenship_id) ;

Line 2805: l_request_id := fnd_global.conc_request_id;

2801: status := '3';
2802: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2803:
2804: IF (l_request_id IS NULL) THEN
2805: l_request_id := fnd_global.conc_request_id;
2806: END IF;
2807:
2808: l_label := 'igs.plsql.IGS_AD_IMP_007.crt_pe_citizenship.exception: '||'E127';
2809:

Line 2845: l_request_id := fnd_global.conc_request_id;

2841: IF l_error IS NULL THEN
2842: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2843:
2844: IF (l_request_id IS NULL) THEN
2845: l_request_id := fnd_global.conc_request_id;
2846: END IF;
2847:
2848: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_citizenship.exception';
2849:

Line 3053: l_request_id := fnd_global.conc_request_id;

3049: status := '3';
3050: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
3051:
3052: IF (l_request_id IS NULL) THEN
3053: l_request_id := fnd_global.conc_request_id;
3054: END IF;
3055:
3056: l_label := 'igs.plsql.IGS_AD_IMP_007.upd_pe_citizenship.exception: '||'E128';
3057:

Line 3087: l_request_id := fnd_global.conc_request_id;

3083: IF l_error IS NULL THEN
3084: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
3085:
3086: IF (l_request_id IS NULL) THEN
3087: l_request_id := fnd_global.conc_request_id;
3088: END IF;
3089:
3090: l_label := 'igs.plsql.igs_ad_imp_007.upd_pe_citizenship.exception';
3091:

Line 3357: l_request_id := fnd_global.conc_request_id;

3353: -- Call Log detail
3354: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
3355:
3356: IF (l_request_id IS NULL) THEN
3357: l_request_id := fnd_global.conc_request_id;
3358: END IF;
3359:
3360: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_fund_source.exception '||'E133';
3361:

Line 3438: l_request_id := fnd_global.conc_request_id;

3434:
3435: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
3436:
3437: IF (l_request_id IS NULL) THEN
3438: l_request_id := fnd_global.conc_request_id;
3439: END IF;
3440:
3441: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_fund_source.exception '||l_error;
3442:

Line 3557: l_request_id := fnd_global.conc_request_id;

3553:
3554: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
3555:
3556: IF (l_request_id IS NULL) THEN
3557: l_request_id := fnd_global.conc_request_id;
3558: END IF;
3559:
3560: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_int_dtls.exception ';
3561: