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_012 dependencies on FND_LOG

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

138: l_tmp_var1 VARCHAR2(500);
139: l_tmp_var VARCHAR2(500);
140: BEGIN
141:
142: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
143:
144: IF (l_request_id IS NULL) THEN
145: l_request_id := fnd_global.conc_request_id;
146: END IF;

Line 151: fnd_log.string_with_context( fnd_log.level_procedure,

147:
148: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin_crt_prsn_contacts';
149: l_debug_str := 'Igs_Ad_Imp_012.crt_prsn_contacts';
150:
151: fnd_log.string_with_context( fnd_log.level_procedure,
152: l_label,
153: l_debug_str, NULL,
154: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
155: END IF;

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

200: l_error_code := 'E322';
201: l_status := '3'; ---check with the existinf error codes
202:
203:
204: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
205:
206: IF (l_request_id IS NULL) THEN
207: l_request_id := fnd_global.conc_request_id;
208: END IF;

Line 218: fnd_log.string_with_context( fnd_log.level_exception,

214: fnd_message.set_token('ERROR_CD','E322');
215:
216: l_debug_str := fnd_message.get || ' ' || l_msg_data;
217:
218: fnd_log.string_with_context( fnd_log.level_exception,
219: l_label,
220: l_debug_str, NULL,
221: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
222: END IF;

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

242:
243: p_error_Code:= 'E322';
244: p_status:= '3';
245:
246: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
247:
248: IF (l_request_id IS NULL) THEN
249: l_request_id := fnd_global.conc_request_id;
250: END IF;

Line 260: fnd_log.string_with_context( fnd_log.level_exception,

256: fnd_message.set_token('ERROR_CD','E322');
257:
258: l_debug_str := fnd_message.get || ' ' || l_msg_data;
259:
260: fnd_log.string_with_context( fnd_log.level_exception,
261: l_label,
262: l_debug_str, NULL,
263: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
264: END IF;

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

285: l_dummy VARCHAR2(1);
286:
287: BEGIN
288:
289: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
290:
291: IF (l_request_id IS NULL) THEN
292: l_request_id := fnd_global.conc_request_id;
293: END IF;

Line 298: fnd_log.string_with_context( fnd_log.level_procedure,

294:
295: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin_validate_prsn_contacts';
296: l_debug_str := 'Igs_Ad_Imp_012.validate_prsn_contacts';
297:
298: fnd_log.string_with_context( fnd_log.level_procedure,
299: l_label,
300: l_debug_str, NULL,
301: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
302: END IF;

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

436: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls';
437: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.';
438: l_enable_log := igs_ad_imp_001.g_enable_log;
439:
440: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
441:
442: IF (l_request_id IS NULL) THEN
443: l_request_id := fnd_global.conc_request_id;
444: END IF;

Line 449: fnd_log.string_with_context( fnd_log.level_procedure,

445:
446: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin';
447: l_debug_str := 'Igs_Ad_Imp_012.prc_pe_cntct_dtls';
448:
449: fnd_log.string_with_context( fnd_log.level_procedure,
450: l_label,
451: l_debug_str, NULL,
452: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
453: END IF;

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

689: l_error_code := 'E014';
690: l_status := '3';
691: --error code to be defined for the updation failure
692:
693: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
694:
695: IF (l_request_id IS NULL) THEN
696: l_request_id := fnd_global.conc_request_id;
697: END IF;

Line 707: fnd_log.string_with_context( fnd_log.level_exception,

703: fnd_message.set_token('ERROR_CD','E014');
704:
705: l_debug_str := fnd_message.get || ' ' || l_msg_data;
706:
707: fnd_log.string_with_context( fnd_log.level_exception,
708: l_label,
709: l_debug_str, NULL,
710: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
711: END IF;

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

729:
730: EXCEPTION
731: WHEN OTHERS THEN
732:
733: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
734:
735: IF (l_request_id IS NULL) THEN
736: l_request_id := fnd_global.conc_request_id;
737: END IF;

Line 747: fnd_log.string_with_context( fnd_log.level_exception,

743: fnd_message.set_token('ERROR_CD','E014');
744:
745: l_debug_str := fnd_message.get || ' ' || SQLERRM;
746:
747: fnd_log.string_with_context( fnd_log.level_exception,
748: l_label,
749: l_debug_str, NULL,
750: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
751: END IF;

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

825: END IF;
826: l_error_code := 'E014';
827: --error code to be defined for the updation failure
828:
829: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
830:
831: IF (l_request_id IS NULL) THEN
832: l_request_id := fnd_global.conc_request_id;
833: END IF;

Line 843: fnd_log.string_with_context( fnd_log.level_exception,

839: fnd_message.set_token('ERROR_CD',l_error_code);
840:
841: l_debug_str := fnd_message.get || ' ' || l_msg_data;
842:
843: fnd_log.string_with_context( fnd_log.level_exception,
844: l_label,
845: l_debug_str, NULL,
846: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
847: END IF;

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

862: END IF;
863: EXCEPTION
864: WHEN OTHERS THEN
865:
866: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
867:
868: IF (l_request_id IS NULL) THEN
869: l_request_id := fnd_global.conc_request_id;
870: END IF;

Line 880: fnd_log.string_with_context( fnd_log.level_exception,

876: fnd_message.set_token('ERROR_CD','E014');
877:
878: l_debug_str := fnd_message.get || ' ' || SQLERRM;
879:
880: fnd_log.string_with_context( fnd_log.level_exception,
881: l_label,
882: l_debug_str, NULL,
883: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
884: END IF;

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

898: crt_prsn_contacts(rec_pc => rec_pc1, error_code => l_error_code, status => l_status ) ;
899: EXCEPTION
900: WHEN OTHERS THEN
901:
902: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
903:
904: IF (l_request_id IS NULL) THEN
905: l_request_id := fnd_global.conc_request_id;
906: END IF;

Line 916: fnd_log.string_with_context( fnd_log.level_exception,

912: fnd_message.set_token('ERROR_CD','E518');
913:
914: l_debug_str := fnd_message.get || ' ' || SQLERRM;
915:
916: fnd_log.string_with_context( fnd_log.level_exception,
917: l_label,
918: l_debug_str, NULL,
919: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
920: END IF;

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

1035: SET status = '3',
1036: error_code = l_error_code
1037: WHERE interface_language_id = p_person_language_rec.interface_language_id;
1038:
1039: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1040:
1041: IF (l_request_id IS NULL) THEN
1042: l_request_id := fnd_global.conc_request_id;
1043: END IF;

Line 1053: fnd_log.string_with_context( fnd_log.level_exception,

1049: fnd_message.set_token('ERROR_CD',l_error_code);
1050:
1051: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1052:
1053: fnd_log.string_with_context( fnd_log.level_exception,
1054: l_label,
1055: l_debug_str, NULL,
1056: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1057: END IF;

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

1078: l_object_version_number NUMBER;
1079: l_last_update_date DATE;
1080: BEGIN
1081:
1082: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1083:
1084: IF (l_request_id IS NULL) THEN
1085: l_request_id := fnd_global.conc_request_id;
1086: END IF;

Line 1091: fnd_log.string_with_context( fnd_log.level_procedure,

1087:
1088: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.begin_crt_prsn_language';
1089: l_debug_str := 'Igs_Ad_Imp_012.crt_prsn_language';
1090:
1091: fnd_log.string_with_context( fnd_log.level_procedure,
1092: l_label,
1093: l_debug_str, NULL,
1094: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1095: END IF;

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

1132: SET status = '3',
1133: error_code = 'E322'
1134: WHERE interface_language_id = p_person_language_rec.interface_language_id;
1135:
1136: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1137:
1138: IF (l_request_id IS NULL) THEN
1139: l_request_id := fnd_global.conc_request_id;
1140: END IF;

Line 1150: fnd_log.string_with_context( fnd_log.level_exception,

1146: fnd_message.set_token('ERROR_CD','E322');
1147:
1148: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1149:
1150: fnd_log.string_with_context( fnd_log.level_exception,
1151: l_label,
1152: l_debug_str, NULL,
1153: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1154: END IF;

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

1173: SET status = '3',
1174: error_code = 'E322'
1175: WHERE interface_language_id = p_person_language_rec.interface_language_id;
1176:
1177: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1178:
1179: IF (l_request_id IS NULL) THEN
1180: l_request_id := fnd_global.conc_request_id;
1181: END IF;

Line 1191: fnd_log.string_with_context( fnd_log.level_exception,

1187: fnd_message.set_token('ERROR_CD','E322');
1188:
1189: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1190:
1191: fnd_log.string_with_context( fnd_log.level_exception,
1192: l_label,
1193: l_debug_str, NULL,
1194: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1195: END IF;

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

1373: SET error_code = 'E014',
1374: status='3'
1375: WHERE interface_language_id = person_language_rec.interface_language_id;
1376:
1377: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1378:
1379: IF (l_request_id IS NULL) THEN
1380: l_request_id := fnd_global.conc_request_id;
1381: END IF;

Line 1391: fnd_log.string_with_context( fnd_log.level_exception,

1387: fnd_message.set_token('ERROR_CD','E014');
1388:
1389: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1390:
1391: fnd_log.string_with_context( fnd_log.level_exception,
1392: l_label,
1393: l_debug_str, NULL,
1394: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1395: END IF;

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

1409:
1410: EXCEPTION
1411: WHEN OTHERS THEN
1412:
1413: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1414:
1415: IF (l_request_id IS NULL) THEN
1416: l_request_id := fnd_global.conc_request_id;
1417: END IF;

Line 1427: fnd_log.string_with_context( fnd_log.level_exception,

1423: fnd_message.set_token('ERROR_CD','E014');
1424:
1425: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1426:
1427: fnd_log.string_with_context( fnd_log.level_exception,
1428: l_label,
1429: l_debug_str, NULL,
1430: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1431: END IF;

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

1495: SET error_code = 'E014',
1496: status='3'
1497: WHERE interface_language_id = person_language_rec.interface_language_id;
1498:
1499: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1500:
1501: IF (l_request_id IS NULL) THEN
1502: l_request_id := fnd_global.conc_request_id;
1503: END IF;

Line 1513: fnd_log.string_with_context( fnd_log.level_exception,

1509: fnd_message.set_token('ERROR_CD','E014');
1510:
1511: l_debug_str := fnd_message.get || ' ' || l_msg_data;
1512:
1513: fnd_log.string_with_context( fnd_log.level_exception,
1514: l_label,
1515: l_debug_str, NULL,
1516: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1517: END IF;

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

1529:
1530: EXCEPTION
1531: WHEN OTHERS THEN
1532:
1533: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1534:
1535: IF (l_request_id IS NULL) THEN
1536: l_request_id := fnd_global.conc_request_id;
1537: END IF;

Line 1547: fnd_log.string_with_context( fnd_log.level_exception,

1543: fnd_message.set_token('ERROR_CD','E014');
1544:
1545: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1546:
1547: fnd_log.string_with_context( fnd_log.level_exception,
1548: l_label,
1549: l_debug_str, NULL,
1550: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1551: END IF;

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

1649: l_athletic_details_id igs_pe_athletic_dtl.athletic_details_id%TYPE;
1650: l_error_code igs_pe_ath_dtl_int.error_code%TYPE;
1651: BEGIN
1652: -- Call Log header
1653: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1654:
1655: IF (l_request_id IS NULL) THEN
1656: l_request_id := fnd_global.conc_request_id;
1657: END IF;

Line 1662: fnd_log.string_with_context( fnd_log.level_procedure,

1658:
1659: l_label := 'igs.plsql.igs_ad_imp_003.crt_apcnt_ath_dtls.begin';
1660: l_debug_str := 'Interface ATHLETIC DTLS Id : ' || p_ath_dtl_rec.interface_athletic_dtls_id;
1661:
1662: fnd_log.string_with_context( fnd_log.level_procedure,
1663: l_label,
1664: l_debug_str, NULL,
1665: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1666: END IF;

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

1692: error_code = l_error_code
1693: WHERE interface_athletic_dtls_id = p_ath_dtl_rec.interface_athletic_dtls_id;
1694:
1695: -- Call Log detail
1696: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1697:
1698: IF (l_request_id IS NULL) THEN
1699: l_request_id := fnd_global.conc_request_id;
1700: END IF;

Line 1711: fnd_log.string_with_context( fnd_log.level_exception,

1707: (p_ath_dtl_rec.interface_athletic_dtls_id) ||
1708: ' Status : ' || '3' || ' ErrorCode : ' || l_error_code
1709: ||' SQLERRM:' || SQLERRM;
1710:
1711: fnd_log.string_with_context( fnd_log.level_exception,
1712: l_label,
1713: l_debug_str, NULL,
1714: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1715: END IF;

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

1804: error_code = l_error_code
1805: WHERE interface_athletic_dtls_id = p_ath_dtl_rec.interface_athletic_dtls_id;
1806:
1807: -- Call Log detail
1808: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1809:
1810: IF (l_request_id IS NULL) THEN
1811: l_request_id := fnd_global.conc_request_id;
1812: END IF;

Line 1823: fnd_log.string_with_context( fnd_log.level_exception,

1819: (p_ath_dtl_rec.interface_athletic_dtls_id) ||
1820: ' Status : ' || '3' || ' ErrorCode : ' ||
1821: l_error_code||' SQLERRM:' || SQLERRM;
1822:
1823: fnd_log.string_with_context( fnd_log.level_exception,
1824: l_label,
1825: l_debug_str, NULL,
1826: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1827: END IF;

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

1841: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_dtls.';
1842:
1843: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1844:
1845: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1846:
1847: IF (l_request_id IS NULL) THEN
1848: l_request_id := fnd_global.conc_request_id;
1849: END IF;

Line 1854: fnd_log.string_with_context( fnd_log.level_procedure,

1850:
1851: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_dtls.begin';
1852: l_debug_str := 'Batch Id : ' || p_batch_id ;
1853:
1854: fnd_log.string_with_context( fnd_log.level_procedure,
1855: l_label,
1856: l_debug_str, NULL,
1857: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1858: END IF;

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

2003: error_code = l_error_code
2004: WHERE interface_athletic_dtls_id = ath_dtl_rec.interface_athletic_dtls_id;
2005:
2006: -- Call Log detail
2007: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2008:
2009: IF (l_request_id IS NULL) THEN
2010: l_request_id := fnd_global.conc_request_id;
2011: END IF;

Line 2022: fnd_log.string_with_context( fnd_log.level_exception,

2018: (ath_dtl_rec.interface_athletic_dtls_id) ||
2019: ' Status : ' || '3' || ' ErrorCode : ' ||
2020: l_error_code ||' SQLERRM:' || SQLERRM;
2021:
2022: fnd_log.string_with_context( fnd_log.level_exception,
2023: l_label,
2024: l_debug_str, NULL,
2025: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2026: END IF;

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

2065: error_code = l_error_code
2066: WHERE interface_athletic_dtls_id = ath_dtl_rec.interface_athletic_dtls_id;
2067:
2068: -- Call Log detail
2069: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2070:
2071: IF (l_request_id IS NULL) THEN
2072: l_request_id := fnd_global.conc_request_id;
2073: END IF;

Line 2084: fnd_log.string_with_context( fnd_log.level_exception,

2080: (ath_dtl_rec.interface_athletic_dtls_id) ||
2081: ' Status : ' || '3' || ' ErrorCode : ' ||
2082: l_error_code ||' SQLERRM:' || SQLERRM;
2083:
2084: fnd_log.string_with_context( fnd_log.level_exception,
2085: l_label,
2086: l_debug_str, NULL,
2087: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2088: END IF;

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

2184: l_athletic_prg_id igs_pe_athletic_prg.athletic_prg_id%TYPE;
2185: l_error_code igs_pe_ath_prg_int.error_code%TYPE;
2186: BEGIN
2187: -- Call Log header
2188: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2189:
2190: IF (l_request_id IS NULL) THEN
2191: l_request_id := fnd_global.conc_request_id;
2192: END IF;

Line 2197: fnd_log.string_with_context( fnd_log.level_procedure,

2193:
2194: l_label := 'igs.plsql.igs_ad_imp_003.crt_apcnt_ath_prg.begin';
2195: l_debug_str := 'Interface athletic prg Id : ' || p_ath_prg_rec.interface_athletic_prg_id;
2196:
2197: fnd_log.string_with_context( fnd_log.level_procedure,
2198: l_label,
2199: l_debug_str, NULL,
2200: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2201: END IF;

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

2229: error_code = l_error_code
2230: WHERE interface_athletic_prg_id = p_ath_prg_rec.interface_athletic_prg_id;
2231:
2232: -- Call Log detail
2233: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2234:
2235: IF (l_request_id IS NULL) THEN
2236: l_request_id := fnd_global.conc_request_id;
2237: END IF;

Line 2248: fnd_log.string_with_context( fnd_log.level_exception,

2244: (p_ath_prg_rec.interface_athletic_prg_id) ||
2245: ' Status : ' || '3' || ' ErrorCode : ' || l_error_code
2246: ||' SQLERRM:' || SQLERRM;
2247:
2248: fnd_log.string_with_context( fnd_log.level_exception,
2249: l_label,
2250: l_debug_str, NULL,
2251: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2252: END IF;

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

2329: error_code = l_error_code
2330: WHERE interface_athletic_prg_id = p_ath_prg_rec.interface_athletic_prg_id;
2331:
2332: -- Call Log detail
2333: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2334:
2335: IF (l_request_id IS NULL) THEN
2336: l_request_id := fnd_global.conc_request_id;
2337: END IF;

Line 2348: fnd_log.string_with_context( fnd_log.level_exception,

2344: (p_ath_prg_rec.interface_athletic_prg_id) ||
2345: ' Status : ' || '3' || ' ErrorCode : ' ||
2346: l_error_code||' SQLERRM:' || SQLERRM;
2347:
2348: fnd_log.string_with_context( fnd_log.level_exception,
2349: l_label,
2350: l_debug_str, NULL,
2351: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2352: END IF;

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

2366: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_prg.';
2367:
2368: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
2369:
2370: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2371:
2372: IF (l_request_id IS NULL) THEN
2373: l_request_id := fnd_global.conc_request_id;
2374: END IF;

Line 2379: fnd_log.string_with_context( fnd_log.level_procedure,

2375:
2376: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_prg.begin';
2377: l_debug_str := 'Batch Id : ' || p_batch_id ;
2378:
2379: fnd_log.string_with_context( fnd_log.level_procedure,
2380: l_label,
2381: l_debug_str, NULL,
2382: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2383: END IF;

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

2538: error_code = l_error_code
2539: WHERE interface_athletic_prg_id = ath_prg_rec.interface_athletic_prg_id;
2540:
2541: -- Call Log detail
2542: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2543:
2544: IF (l_request_id IS NULL) THEN
2545: l_request_id := fnd_global.conc_request_id;
2546: END IF;

Line 2557: fnd_log.string_with_context( fnd_log.level_exception,

2553: (ath_prg_rec.interface_athletic_prg_id) ||
2554: ' Status : ' || '3' || ' ErrorCode : ' ||
2555: l_error_code||' SQLERRM:' || SQLERRM;
2556:
2557: fnd_log.string_with_context( fnd_log.level_exception,
2558: l_label,
2559: l_debug_str, NULL,
2560: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2561: END IF;

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

2601: error_code = l_error_code
2602: WHERE interface_athletic_prg_id = ath_prg_rec.interface_athletic_prg_id;
2603:
2604: -- Call Log detail
2605: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2606:
2607: IF (l_request_id IS NULL) THEN
2608: l_request_id := fnd_global.conc_request_id;
2609: END IF;

Line 2620: fnd_log.string_with_context( fnd_log.level_exception,

2616: (ath_prg_rec.interface_athletic_prg_id) ||
2617: ' Status : ' || '3' || ' ErrorCode : ' ||
2618: l_error_code||' SQLERRM:' || SQLERRM;
2619:
2620: fnd_log.string_with_context( fnd_log.level_exception,
2621: l_label,
2622: l_debug_str, NULL,
2623: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2624: END IF;