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;
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';
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';
160:
161: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
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';
226:
227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
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;
331:
332: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.exception_validate_record';
333:
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;
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';
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;
655:
656: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception_crt_pe_felony_dtls';
657:
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;
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';
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;
864:
865: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception';
866:
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;
928:
929: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception1';
930:
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;
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';
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;
1134:
1135: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception_crt_pe_hearing_dtls';
1136:
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;
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';
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:
1349: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception1';
1350:
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;
1414:
1415: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception2';
1416:
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;
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';
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;
1569:
1570: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_crt_pe_race';
1571:
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;
1624:
1625: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_validate_race_record';
1626:
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;
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';
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;
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';
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;
1864:
1865: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_priv_dtls.exception';
1866:
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;
1950:
1951: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception1';
1952:
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;
2087:
2088: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception_validate_record';
2089: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');