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_LOG

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

114:
115: l_org_id NUMBER(15);
116: BEGIN
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;

Line 127: fnd_log.string_with_context( fnd_log.level_procedure,

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;
126:
127: fnd_log.string_with_context( fnd_log.level_procedure,
128: l_label,
129: l_debug_str, NULL,
130: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
131: END IF;

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

171: WHEN OTHERS THEN
172: p_error_Code:= 'E322';
173: p_status :='3';
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;

Line 187: fnd_log.string_with_context( fnd_log.level_exception,

183: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS.crt_pr_mil ' ||
184: 'Interface_military_Id: ' ||military_rec.Interface_military_Id
185: || 'Status : 3' || 'ErrorCode : E322' || SQLERRM;
186:
187: fnd_log.string_with_context( fnd_log.level_exception,
188: l_label,
189: l_debug_str, NULL,
190: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
191: END IF;

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

510: SET ERROR_CODE = cst_err_val_14,
511: status = cst_stat_val_3
512: WHERE interface_military_id= military_rec.interface_military_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;

Line 526: fnd_log.string_with_context( fnd_log.level_exception,

522: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS ' ||
523: 'Interface Military Id : ' || (MILITARY_REC.INTERFACE_MILITARY_ID)
524: || 'Status : 3' || 'ErrorCode : E014' || SQLERRM;
525:
526: fnd_log.string_with_context( fnd_log.level_exception,
527: l_label,
528: l_debug_str, NULL,
529: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
530: END IF;

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

581: SET ERROR_CODE = 'E014',
582: status = '3'
583: WHERE interface_military_id = military_rec.interface_military_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;

Line 597: fnd_log.string_with_context( fnd_log.level_exception,

593: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS ' ||
594: 'Military Type Cd : ' || MILITARY_REC.MILITARY_TYPE_CD
595: || ' Status : 3 ' || 'ErrorCode : E014' || SQLERRM;
596:
597: fnd_log.string_with_context( fnd_log.level_exception,
598: l_label,
599: l_debug_str, NULL,
600: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
601: END IF;

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

795: l_immu_id igs_pe_immu_dtls.immu_details_id%TYPE;
796:
797: BEGIN
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;

Line 808: fnd_log.string_with_context( fnd_log.level_procedure,

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;
807:
808: fnd_log.string_with_context( fnd_log.level_procedure,
809: l_label,
810: l_debug_str, NULL,
811: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
812: END IF;

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

894: ERROR_CODE = p_error_code
895: WHERE interface_immu_dtls_id = health_insur_rec.interface_immu_dtls_id;
896: -- Call Log detail
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;

Line 912: fnd_log.string_with_context( fnd_log.level_exception,

908: || ' Interface Id : '
909: || (health_insur_rec.interface_immu_dtls_id)
910: || ' Status : 3'|| ' ErrorCode : E159' ||SQLERRM;
911:
912: fnd_log.string_with_context( fnd_log.level_exception,
913: l_label,
914: l_debug_str, NULL,
915: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
916: END IF;

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

930:
931: -- Pick up all the records in the table for the P_INTERFACE_ID and
932: -- store them into a Record variable pe_health_rec.
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;

Line 943: fnd_log.string_with_context( fnd_log.level_procedure,

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';
942:
943: fnd_log.string_with_context( fnd_log.level_procedure,
944: l_label,
945: l_debug_str, NULL,
946: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
947: END IF;

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

1143: SET status = l_status,
1144: ERROR_CODE = l_error_code
1145: WHERE interface_immu_dtls_id = pe_health_rec.interface_immu_dtls_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;

Line 1160: fnd_log.string_with_context( fnd_log.level_exception,

1156: || 'INTERFACE_IMMU_DTLS_ID : ' ||
1157: pe_health_rec.interface_immu_dtls_id ||
1158: 'Status : ' || l_status || 'ErrorCode : ' || l_error_code || SQLERRM;
1159:
1160: fnd_log.string_with_context( fnd_log.level_exception,
1161: l_label,
1162: l_debug_str, NULL,
1163: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1164: END IF;

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

1257: SET status = l_status,
1258: ERROR_CODE = l_error_code
1259: WHERE interface_immu_dtls_id = pe_health_rec.interface_immu_dtls_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;

Line 1274: fnd_log.string_with_context( fnd_log.level_exception,

1270: || 'INTERFACE_IMMU_DTLS_ID : ' ||
1271: IGS_GE_NUMBER.TO_CANN(pe_health_rec.interface_immu_dtls_id) ||
1272: 'Status : ' || l_status || 'ErrorCode : ' || l_error_code || SQLERRM;
1273:
1274: fnd_log.string_with_context( fnd_log.level_exception,
1275: l_label,
1276: l_debug_str, NULL,
1277: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1278: END IF;

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

1354: l_hlth_id NUMBER;
1355: l_org_id NUMBER(15);
1356: BEGIN
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;

Line 1367: fnd_log.string_with_context( fnd_log.level_procedure,

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);
1366:
1367: fnd_log.string_with_context( fnd_log.level_procedure,
1368: l_label,
1369: l_debug_str, NULL,
1370: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1371: END IF;

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

1413:
1414: p_error_code := 'E322';
1415: p_status := '3';
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;

Line 1428: fnd_log.string_with_context( fnd_log.level_exception,

1424:
1425: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS.Crt_Pe_hlth_ins ' ||
1426: 'Status : 3' || 'ErrorCode : E322 insert failed ' || SQLERRM;
1427:
1428: fnd_log.string_with_context( fnd_log.level_exception,
1429: l_label,
1430: l_debug_str, NULL,
1431: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1432: END IF;

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

1523: l_enable_log := igs_ad_imp_001.g_enable_log;
1524: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls';
1525: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.';
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;

Line 1536: fnd_log.string_with_context( fnd_log.level_procedure,

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';
1535:
1536: fnd_log.string_with_context( fnd_log.level_procedure,
1537: l_label,
1538: l_debug_str, NULL,
1539: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1540: END IF;

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

1726: UPDATE igs_ad_hlth_ins_int
1727: SET error_code = 'E014',
1728: status = '3'
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;

Line 1742: fnd_log.string_with_context( fnd_log.level_exception,

1738: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS ' ||
1739: 'Interface Health Id : ' || hlth_ins_rec.INTERFACE_HLTH_ID ||
1740: ' Status : 3 ' || 'ErrorCode : E014 Update Failed ' || SQLERRM;
1741:
1742: fnd_log.string_with_context( fnd_log.level_exception,
1743: l_label,
1744: l_debug_str, NULL,
1745: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1746: END IF;

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

1795: UPDATE igs_ad_hlth_ins_int
1796: SET error_code = 'E014',
1797: status = '3'
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;

Line 1811: fnd_log.string_with_context( fnd_log.level_exception,

1807: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS ' ||
1808: 'Interface Health Id : ' || (hlth_ins_rec.INTERFACE_HLTH_ID) ||
1809: 'Status : 3' || 'ErrorCode : E014 update Failed ' || SQLERRM;
1810:
1811: fnd_log.string_with_context( fnd_log.level_exception,
1812: l_label,
1813: l_debug_str, NULL,
1814: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1815: END IF;

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

2050: SET status = '3',
2051: error_code = l_error_code
2052: WHERE interface_api_id = p_api_rec.interface_api_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;

Line 2069: fnd_log.string_with_context( fnd_log.level_exception,

2065: ||IGS_GE_NUMBER.TO_CANN(p_api_rec.Interface_api_Id)
2066: ||' Status:3 '
2067: ||'Error Code:'||l_error_code||' ' || SQLERRM;
2068:
2069: fnd_log.string_with_context( fnd_log.level_exception,
2070: l_label,
2071: l_debug_str, NULL,
2072: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2073: END IF;

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

2103: l_message_name VARCHAR2(30);
2104: l_app VARCHAR2(50);
2105: BEGIN
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;

Line 2116: fnd_log.string_with_context( fnd_log.level_procedure,

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 ;
2115:
2116: fnd_log.string_with_context( fnd_log.level_procedure,
2117: l_label,
2118: l_debug_str, NULL,
2119: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2120: END IF;

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

2175: p_error_code := 'E007';
2176: p_status := '3';
2177: END IF;
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;

Line 2191: fnd_log.string_with_context( fnd_log.level_exception,

2187: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES.crt_person_id_types, Interface Api Id : '
2188: || p_api_rec.interface_api_id ||' Status : '|| p_status || ' ErrorCode : '||
2189: p_error_code|| ' SQLERRM: '||SQLERRM;
2190:
2191: fnd_log.string_with_context( fnd_log.level_exception,
2192: l_label,
2193: l_debug_str, NULL,
2194: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2195: END IF;

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

2450: ELSE
2451: l_error_code := 'E014';
2452: END IF;
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;

Line 2466: fnd_log.string_with_context( fnd_log.level_exception,

2462: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES ' || 'Interface Api Id : '
2463: || api_rec.interface_api_id || 'SQLERRM '||SQLERRM ||' Status : 3 ' ||
2464: 'ErrorCode : '|| l_error_code;
2465:
2466: fnd_log.string_with_context( fnd_log.level_exception,
2467: l_label,
2468: l_debug_str, NULL,
2469: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2470: END IF;

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

2539: ELSE
2540: l_error_code := 'E014';
2541: END IF;
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;

Line 2555: fnd_log.string_with_context( fnd_log.level_exception,

2551: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES ' || 'Interface Api Id : '
2552: || api_rec.interface_api_id || ' SQLERRM '||SQLERRM ||' Status : 3 ' ||
2553: 'ErrorCode : '|| l_error_code;
2554:
2555: fnd_log.string_with_context( fnd_log.level_exception,
2556: l_label,
2557: l_debug_str, NULL,
2558: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2559: END IF;

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

2688: l_error VARCHAR2(30);
2689: l_object_version_number NUMBER;
2690: BEGIN
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;

Line 2701: fnd_log.string_with_context( fnd_log.level_procedure,

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) ;
2700:
2701: fnd_log.string_with_context( fnd_log.level_procedure,
2702: l_label,
2703: l_debug_str, NULL,
2704: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2705: END IF;

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

2798:
2799: IF l_return_status IN ('E','U') THEN -- error returned by HZ API
2800: error_code := 'E127'; -- failed in HZ insert
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;

Line 2815: fnd_log.string_with_context( fnd_log.level_exception,

2811: || 'Interface Citizen Id : '
2812: || (pcz_rec.interface_citizenship_id)
2813: || 'Status : 3' || 'ErrorCode : E127'|| l_msg_data;
2814:
2815: fnd_log.string_with_context( fnd_log.level_exception,
2816: l_label,
2817: l_debug_str, NULL,
2818: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2819: END IF;

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

2838: status:= '3';
2839: -- there can be a case when unhandled exception is raised in HZ package then the l_error will not be set
2840:
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;

Line 2855: fnd_log.string_with_context( fnd_log.level_exception,

2851: || 'Interface Citizen Id : '
2852: || (pcz_rec.interface_citizenship_id)
2853: || 'Status : 3' || ' SQLERRM:' || SQLERRM;
2854:
2855: fnd_log.string_with_context( fnd_log.level_exception,
2856: l_label,
2857: l_debug_str, NULL,
2858: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2859: END IF;

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

3046:
3047: IF l_return_status IN ('E','U') THEN
3048: error_code := 'E128'; -- updation failed in HZ
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;

Line 3063: fnd_log.string_with_context( fnd_log.level_exception,

3059: || 'Interface Citizen Id : '
3060: || (pcz_rec.interface_citizenship_id)
3061: || ' Status : 3 ' || 'ErrorCode : E128 msg_data: ' || l_msg_data;
3062:
3063: fnd_log.string_with_context( fnd_log.level_exception,
3064: l_label,
3065: l_debug_str, NULL,
3066: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3067: END IF;

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

3080: error_Code:= l_error; -- discrepency rule check failed
3081: status:= '3';
3082:
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;

Line 3097: fnd_log.string_with_context( fnd_log.level_exception,

3093: || 'Interface Citizen Id : '
3094: || (pcz_rec.interface_citizenship_id)
3095: || 'Status : 3' || ' SQLERRM:' || SQLERRM;
3096:
3097: fnd_log.string_with_context( fnd_log.level_exception,
3098: l_label,
3099: l_debug_str, NULL,
3100: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3101: END IF;

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

3350: WHEN OTHERS THEN
3351: status := '3';
3352: error_code := 'E133';
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;

Line 3368: fnd_log.string_with_context( fnd_log.level_exception,

3364: || 'Interface Fund Source Id : '
3365: || (pfs_rec.interface_fund_source_id)
3366: || 'Status : 3' || 'ErrorCode : E133 SQLERRM:' || SQLERRM;
3367:
3368: fnd_log.string_with_context( fnd_log.level_exception,
3369: l_label,
3370: l_debug_str, NULL,
3371: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3372: END IF;

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

3431: SET status = '3',
3432: error_code = l_error
3433: WHERE interface_fund_source_id = pfs_rec.interface_fund_source_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;

Line 3447: fnd_log.string_with_context( fnd_log.level_exception,

3443: l_debug_str := 'Igs_Ad_Imp_007.prc_pe_fund_source.Validate_Record '
3444: ||' Interface Fund Source Id : ' || (pfs_rec.interface_fund_source_id) ||'Status : 3'
3445: || 'ErrorCode :' || l_error || ' SQLERRM: ' || SQLERRM;
3446:
3447: fnd_log.string_with_context( fnd_log.level_exception,
3448: l_label,
3449: l_debug_str, NULL,
3450: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3451: END IF;

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

3550:
3551: EXCEPTION
3552: WHEN OTHERS THEN
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;

Line 3567: fnd_log.string_with_context( fnd_log.level_exception,

3563: || ' Source Id : '
3564: || (p_source_type_id)
3565: || 'Batch Id : ' || IGS_GE_NUMBER.TO_CANN(p_batch_id)|| ' SQLERRM: ' || SQLERRM;
3566:
3567: fnd_log.string_with_context( fnd_log.level_exception,
3568: l_label,
3569: l_debug_str, NULL,
3570: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3571: END IF;