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

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

108: l_error_code igs_pe_housing_int.error_code%TYPE;
109: l_org_id NUMBER(15);
110: BEGIN
111: -- Call Log header
112: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
113:
114: IF (l_request_id IS NULL) THEN
115: l_request_id := fnd_global.conc_request_id;
116: END IF;

Line 121: fnd_log.string_with_context( fnd_log.level_procedure,

117:
118: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.begin_crt_pe_house_status';
119: l_debug_str := 'igs_ad_imp_025.prc_pe_house_status.crt_pe_house_status';
120:
121: fnd_log.string_with_context( fnd_log.level_procedure,
122: l_label,
123: l_debug_str, NULL,
124: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
125: END IF;

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

151: error_code = l_error_code
152: WHERE interface_housing_id = p_housing_rec.interface_housing_id;
153:
154: -- Call Log detail
155: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
156: IF (l_request_id IS NULL) THEN
157: l_request_id := fnd_global.conc_request_id;
158: END IF;
159: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_house_status.exception';

Line 167: fnd_log.string_with_context( fnd_log.level_exception,

163: fnd_message.set_token('ERROR_CD',l_error_code);
164:
165: l_debug_str := fnd_message.get || ' ' || SQLERRM;
166:
167: fnd_log.string_with_context( fnd_log.level_exception,
168: l_label,
169: l_debug_str, NULL,
170: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
171: END IF;

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

217: error_code = 'E114'
218: WHERE interface_housing_id = p_housing_rec.interface_housing_id;
219:
220: -- Call Log detail
221: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
222: IF (l_request_id IS NULL) THEN
223: l_request_id := fnd_global.conc_request_id;
224: END IF;
225: l_label := 'igs.plsql.igs_ad_imp_025.upd_pe_house_status.exception';

Line 232: fnd_log.string_with_context( fnd_log.level_exception,

228: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
229: fnd_message.set_token('ERROR_CD','E114');
230:
231: l_debug_str := fnd_message.get || ' ' || SQLERRM;
232: fnd_log.string_with_context( fnd_log.level_exception,
233: l_label,
234: l_debug_str, NULL,
235: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
236: END IF;

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

322: WHERE interface_housing_id = p_housing_rec.interface_housing_id;
323:
324: -- Call Log detail
325:
326: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
327:
328: IF (l_request_id IS NULL) THEN
329: l_request_id := fnd_global.conc_request_id;
330: END IF;

Line 340: fnd_log.string_with_context( fnd_log.level_exception,

336: fnd_message.set_token('ERROR_CD',l_error_code);
337:
338: l_debug_str := fnd_message.get || ' ' || SQLERRM;
339:
340: fnd_log.string_with_context( fnd_log.level_exception,
341: l_label,
342: l_debug_str, NULL,
343: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
344: END IF;

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

600:
601: BEGIN
602: -- Call Log header
603:
604: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
605:
606: IF (l_request_id IS NULL) THEN
607: l_request_id := fnd_global.conc_request_id;
608: END IF;

Line 613: fnd_log.string_with_context( fnd_log.level_procedure,

609:
610: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.begin_crt_pe_felony_dtls';
611: l_debug_str := 'igs_ad_imp_025.crt_pe_felony_dtls';
612:
613: fnd_log.string_with_context( fnd_log.level_procedure,
614: l_label,
615: l_debug_str, NULL,
616: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
617: END IF;

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

646: ELSE
647: p_status :='3';
648: p_error_code := 'E120';
649:
650: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
651:
652: IF (l_request_id IS NULL) THEN
653: l_request_id := fnd_global.conc_request_id;
654: END IF;

Line 664: fnd_log.string_with_context( fnd_log.level_exception,

660: fnd_message.set_token('ERROR_CD',p_error_code);
661:
662: l_debug_str := fnd_message.get || ' ' || SQLERRM;
663:
664: fnd_log.string_with_context( fnd_log.level_exception,
665: l_label,
666: l_debug_str, NULL,
667: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
668: END IF;

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

681: l_enable_log := igs_ad_imp_001.g_enable_log;
682: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
683: -- Every child records needs to be updated with this value.
684:
685: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
686:
687: IF (l_request_id IS NULL) THEN
688: l_request_id := fnd_global.conc_request_id;
689: END IF;

Line 694: fnd_log.string_with_context( fnd_log.level_procedure,

690:
691: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.begin';
692: l_debug_str := 'igs_ad_imp_025.prc_pe_felony_dtls';
693:
694: fnd_log.string_with_context( fnd_log.level_procedure,
695: l_label,
696: l_debug_str, NULL,
697: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
698: END IF;

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

855:
856: ELSE
857: l_status :='3';
858: l_error_code := 'E121';
859: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
860:
861: IF (l_request_id IS NULL) THEN
862: l_request_id := fnd_global.conc_request_id;
863: END IF;

Line 873: fnd_log.string_with_context( fnd_log.level_exception,

869: fnd_message.set_token('ERROR_CD',l_error_code);
870:
871: l_debug_str := fnd_message.get || ' ' || SQLERRM;
872:
873: fnd_log.string_with_context( fnd_log.level_exception,
874: l_label,
875: l_debug_str, NULL,
876: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
877: END IF;

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

919: ELSE
920: l_status :='3';
921: l_error_code := 'E121';
922:
923: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
924:
925: IF (l_request_id IS NULL) THEN
926: l_request_id := fnd_global.conc_request_id;
927: END IF;

Line 937: fnd_log.string_with_context( fnd_log.level_exception,

933: fnd_message.set_token('ERROR_CD',l_error_code);
934:
935: l_debug_str := fnd_message.get || ' ' || SQLERRM;
936:
937: fnd_log.string_with_context( fnd_log.level_exception,
938: l_label,
939: l_debug_str, NULL,
940: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
941: END IF;

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

1081: l_rowid VARCHAR2(25);
1082: l_hearing_details_id IGS_PE_HEARING_DTLS.hearing_details_id%TYPE;
1083: BEGIN
1084:
1085: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1086:
1087: IF (l_request_id IS NULL) THEN
1088: l_request_id := fnd_global.conc_request_id;
1089: END IF;

Line 1094: fnd_log.string_with_context( fnd_log.level_procedure,

1090:
1091: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.begin_crt_pe_hearing_dtls';
1092: l_debug_str := 'Igs_Ad_Imp_025.Prc_Pe_Hearing_Dtls.Crt_Pe_hearing_dtls';
1093:
1094: fnd_log.string_with_context( fnd_log.level_procedure,
1095: l_label,
1096: l_debug_str, NULL,
1097: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1098: END IF;

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

1125: p_error_code := 'E582';
1126: ELSE
1127: p_status :='3';
1128: p_error_code := 'E122';
1129: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1130:
1131: IF (l_request_id IS NULL) THEN
1132: l_request_id := fnd_global.conc_request_id;
1133: END IF;

Line 1143: fnd_log.string_with_context( fnd_log.level_exception,

1139: fnd_message.set_token('ERROR_CD',p_error_code);
1140:
1141: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1142:
1143: fnd_log.string_with_context( fnd_log.level_exception,
1144: l_label,
1145: l_debug_str, NULL,
1146: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1147: END IF;

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

1161: l_enable_log := igs_ad_imp_001.g_enable_log;
1162: l_interface_run_id := igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
1163: -- Every child records needs to be updated with this value.
1164:
1165: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1166:
1167: IF (l_request_id IS NULL) THEN
1168: l_request_id := fnd_global.conc_request_id;
1169: END IF;

Line 1174: fnd_log.string_with_context( fnd_log.level_procedure,

1170:
1171: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.begin';
1172: l_debug_str := 'Igs_Ad_Imp_025.Prc_Pe_Hearing_Dtls';
1173:
1174: fnd_log.string_with_context( fnd_log.level_procedure,
1175: l_label,
1176: l_debug_str, NULL,
1177: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1178: END IF;

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

1340: ELSE
1341: l_status := '3' ;
1342: l_error_code := 'E123';
1343:
1344: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1345: IF (l_request_id IS NULL) THEN
1346: l_request_id := fnd_global.conc_request_id;
1347: END IF;
1348:

Line 1357: fnd_log.string_with_context( fnd_log.level_exception,

1353: fnd_message.set_token('ERROR_CD',l_error_code);
1354:
1355: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1356:
1357: fnd_log.string_with_context( fnd_log.level_exception,
1358: l_label,
1359: l_debug_str, NULL,
1360: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1361: END IF;

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

1405: ELSE
1406: l_status := '3' ;
1407: l_error_code := 'E123';
1408:
1409: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1410:
1411: IF (l_request_id IS NULL) THEN
1412: l_request_id := fnd_global.conc_request_id;
1413: END IF;

Line 1423: fnd_log.string_with_context( fnd_log.level_exception,

1419: fnd_message.set_token('ERROR_CD',l_error_code);
1420:
1421: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1422:
1423: fnd_log.string_with_context( fnd_log.level_exception,
1424: l_label,
1425: l_debug_str, NULL,
1426: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1427: END IF;

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

1526: PROCEDURE crt_pe_race(p_race_rec IN race_cur%ROWTYPE) AS
1527: l_rowid VARCHAR2(25);
1528: BEGIN
1529: -- Call Log header
1530: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1531:
1532: IF (l_request_id IS NULL) THEN
1533: l_request_id := fnd_global.conc_request_id;
1534: END IF;

Line 1539: fnd_log.string_with_context( fnd_log.level_procedure,

1535:
1536: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.begin_crt_pe_race';
1537: l_debug_str := 'igs_ad_imp_025.prc_pe_race.crt_pe_race';
1538:
1539: fnd_log.string_with_context( fnd_log.level_procedure,
1540: l_label,
1541: l_debug_str, NULL,
1542: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1543: END IF;

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

1560: SET status = '3',
1561: error_code = 'E322'
1562: WHERE interface_race_id = p_race_rec.interface_race_id;
1563: -- Call Log detail
1564: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1565:
1566: IF (l_request_id IS NULL) THEN
1567: l_request_id := fnd_global.conc_request_id;
1568: END IF;

Line 1578: fnd_log.string_with_context( fnd_log.level_exception,

1574: fnd_message.set_token('ERROR_CD','E322');
1575:
1576: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1577:
1578: fnd_log.string_with_context( fnd_log.level_exception,
1579: l_label,
1580: l_debug_str, NULL,
1581: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1582: END IF;

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

1615: WHERE interface_race_id = p_race_rec.interface_race_id;
1616:
1617: -- Call Log detail
1618:
1619: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1620:
1621: IF (l_request_id IS NULL) THEN
1622: l_request_id := fnd_global.conc_request_id;
1623: END IF;

Line 1633: fnd_log.string_with_context( fnd_log.level_exception,

1629: fnd_message.set_token('ERROR_CD',l_error_code);
1630:
1631: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1632:
1633: fnd_log.string_with_context( fnd_log.level_exception,
1634: l_label,
1635: l_debug_str, NULL,
1636: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1637: END IF;

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

1651: l_enable_log := igs_ad_imp_001.g_enable_log;
1652: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
1653: -- Every child records needs to be updated with this value.
1654:
1655: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1656:
1657: IF (l_request_id IS NULL) THEN
1658: l_request_id := fnd_global.conc_request_id;
1659: END IF;

Line 1664: fnd_log.string_with_context( fnd_log.level_procedure,

1660:
1661: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.begin';
1662: l_debug_str := 'igs_ad_imp_025.prc_pe_race';
1663:
1664: fnd_log.string_with_context( fnd_log.level_procedure,
1665: l_label,
1666: l_debug_str, NULL,
1667: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1668: END IF;

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

1799:
1800: BEGIN
1801: SAVEPOINT before_insert;
1802: -- Call log header
1803: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1804:
1805: IF (l_request_id IS NULL) THEN
1806: l_request_id := fnd_global.conc_request_id;
1807: END IF;

Line 1812: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

1808:
1809: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.begin_crt_pe_priv_dtls';
1810: l_debug_str := 'igs_ad_imp_025.prc_priv_dtls.crt_pe_priv_dtls';
1811:
1812: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1813: END IF;
1814:
1815: igs_pe_priv_level_pkg.insert_row(
1816: x_rowid => l_rowid,

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

1855: error_code = l_error_code
1856: WHERE interface_privacy_id = p_priv_rec.interface_privacy_id;
1857:
1858: -- Call Log detail
1859: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1860:
1861: IF (l_request_id IS NULL) THEN
1862: l_request_id := fnd_global.conc_request_id;
1863: END IF;

Line 1873: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

1869: fnd_message.set_token('ERROR_CD',l_error_code);
1870:
1871: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1872:
1873: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1874: END IF;
1875:
1876: IF l_enable_log = 'Y' THEN
1877: igs_ad_imp_001.logerrormessage(p_priv_rec.interface_privacy_id,l_error_code);

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

1941: error_code = l_error_code
1942: WHERE interface_id = p_int_rec.interface_privacy_id;
1943: -- Call Log detail
1944:
1945: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1946:
1947: IF (l_request_id IS NULL) THEN
1948: l_request_id := fnd_global.conc_request_id;
1949: END IF;

Line 1959: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

1955: fnd_message.set_token('ERROR_CD',l_error_code);
1956:
1957: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1958:
1959: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1960: END IF;
1961:
1962: IF l_enable_log = 'Y' THEN
1963: igs_ad_imp_001.logerrormessage(p_int_rec.interface_privacy_id,l_error_code);

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

2078: WHERE interface_privacy_id = p_priv_rec.interface_privacy_id;
2079:
2080: -- Call Log detail
2081:
2082: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2083:
2084: IF (l_request_id IS NULL) THEN
2085: l_request_id := fnd_global.conc_request_id;
2086: END IF;

Line 2093: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

2089: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2090: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
2091: fnd_message.set_token('ERROR_CD',l_error_code);
2092: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2093: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2094:
2095: END IF;
2096:
2097: IF l_enable_log = 'Y' THEN