161: l_table_meaning igs_lookup_values.meaning%TYPE;
162: l_meaning igs_lookup_values.meaning%TYPE;
163: BEGIN
164:
165: FND_MESSAGE.SET_NAME('FND','FND_LOCK_RECORD_ERROR');
166: l_msg_text := FND_MESSAGE.GET;
167:
168: OPEN gc_lkups (p_int_table_code,g_cst_tbl_lkup_type);
169: FETCH gc_lkups INTO l_table_meaning;
162: l_meaning igs_lookup_values.meaning%TYPE;
163: BEGIN
164:
165: FND_MESSAGE.SET_NAME('FND','FND_LOCK_RECORD_ERROR');
166: l_msg_text := FND_MESSAGE.GET;
167:
168: OPEN gc_lkups (p_int_table_code,g_cst_tbl_lkup_type);
169: FETCH gc_lkups INTO l_table_meaning;
170: CLOSE gc_lkups;
181: PROCEDURE log_no_data_exists(p_log IN BOOLEAN) AS
182: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
183: BEGIN
184: IF p_log THEN
185: FND_MESSAGE.SET_NAME('FND','FND_DEF_ALTERNATE_TEXT');
186: l_msg_text := FND_MESSAGE.GET;
187: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || l_msg_text);
188: END IF;
189: END log_no_data_exists;
182: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
183: BEGIN
184: IF p_log THEN
185: FND_MESSAGE.SET_NAME('FND','FND_DEF_ALTERNATE_TEXT');
186: l_msg_text := FND_MESSAGE.GET;
187: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || l_msg_text);
188: END IF;
189: END log_no_data_exists;
190:
209: The "Row Type" Part comes from a message the table name
210: part of it comes from the Lookup meaning of the int_table_cd
211: */
212:
213: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTERFACE_ID');
214: l_msg_text1 := FND_MESSAGE.GET;
215:
216: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MESSAGE_NUM');
217: l_msg_text2 := FND_MESSAGE.GET;
210: part of it comes from the Lookup meaning of the int_table_cd
211: */
212:
213: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTERFACE_ID');
214: l_msg_text1 := FND_MESSAGE.GET;
215:
216: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MESSAGE_NUM');
217: l_msg_text2 := FND_MESSAGE.GET;
218:
212:
213: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTERFACE_ID');
214: l_msg_text1 := FND_MESSAGE.GET;
215:
216: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MESSAGE_NUM');
217: l_msg_text2 := FND_MESSAGE.GET;
218:
219: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ROW_STATUS');
220: l_msg_text3 := FND_MESSAGE.GET;
213: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTERFACE_ID');
214: l_msg_text1 := FND_MESSAGE.GET;
215:
216: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MESSAGE_NUM');
217: l_msg_text2 := FND_MESSAGE.GET;
218:
219: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ROW_STATUS');
220: l_msg_text3 := FND_MESSAGE.GET;
221:
215:
216: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MESSAGE_NUM');
217: l_msg_text2 := FND_MESSAGE.GET;
218:
219: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ROW_STATUS');
220: l_msg_text3 := FND_MESSAGE.GET;
221:
222: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MSG_TXT');
223: l_msg_text4 := FND_MESSAGE.GET;
216: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MESSAGE_NUM');
217: l_msg_text2 := FND_MESSAGE.GET;
218:
219: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ROW_STATUS');
220: l_msg_text3 := FND_MESSAGE.GET;
221:
222: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MSG_TXT');
223: l_msg_text4 := FND_MESSAGE.GET;
224:
218:
219: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ROW_STATUS');
220: l_msg_text3 := FND_MESSAGE.GET;
221:
222: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MSG_TXT');
223: l_msg_text4 := FND_MESSAGE.GET;
224:
225: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ROW_TYPE');
226: l_msg_text5 := FND_MESSAGE.GET;
219: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ROW_STATUS');
220: l_msg_text3 := FND_MESSAGE.GET;
221:
222: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MSG_TXT');
223: l_msg_text4 := FND_MESSAGE.GET;
224:
225: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ROW_TYPE');
226: l_msg_text5 := FND_MESSAGE.GET;
227:
221:
222: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MSG_TXT');
223: l_msg_text4 := FND_MESSAGE.GET;
224:
225: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ROW_TYPE');
226: l_msg_text5 := FND_MESSAGE.GET;
227:
228: OPEN gc_lkups (p_int_table_code,g_cst_tbl_lkup_type);
229: FETCH gc_lkups INTO l_table_meaning;
222: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MSG_TXT');
223: l_msg_text4 := FND_MESSAGE.GET;
224:
225: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ROW_TYPE');
226: l_msg_text5 := FND_MESSAGE.GET;
227:
228: OPEN gc_lkups (p_int_table_code,g_cst_tbl_lkup_type);
229: FETCH gc_lkups INTO l_table_meaning;
230: CLOSE gc_lkups;
246: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
247: l_meaning igs_lookup_values.meaning%TYPE;
248: BEGIN
249:
250: FND_MESSAGE.SET_NAME('IGS','IGS_EN_LGCY_SUCCESS');
251: l_msg_text := FND_MESSAGE.GET;
252:
253: OPEN gc_lkups ('I',g_cst_lgcy_status);
254: FETCH gc_lkups INTO l_meaning;
247: l_meaning igs_lookup_values.meaning%TYPE;
248: BEGIN
249:
250: FND_MESSAGE.SET_NAME('IGS','IGS_EN_LGCY_SUCCESS');
251: l_msg_text := FND_MESSAGE.GET;
252:
253: OPEN gc_lkups ('I',g_cst_lgcy_status);
254: FETCH gc_lkups INTO l_meaning;
255: CLOSE gc_lkups;
415: l_msg_data := p_msg_data;
416:
417: IF l_msg_count =1 THEN
418: SELECT igs_en_lgcy_err_int_s.NEXTVAL INTO l_err_msg_id FROM DUAL;
419: FND_MESSAGE.SET_ENCODED(l_msg_data);
420: l_msg_text := FND_MESSAGE.GET;
421:
422: l_msg_number := NULL;
423: FND_MESSAGE.PARSE_ENCODED(l_msg_data,l_app,l_msg_name);
416:
417: IF l_msg_count =1 THEN
418: SELECT igs_en_lgcy_err_int_s.NEXTVAL INTO l_err_msg_id FROM DUAL;
419: FND_MESSAGE.SET_ENCODED(l_msg_data);
420: l_msg_text := FND_MESSAGE.GET;
421:
422: l_msg_number := NULL;
423: FND_MESSAGE.PARSE_ENCODED(l_msg_data,l_app,l_msg_name);
424: OPEN c_msg_text_num (l_app, l_msg_name);
419: FND_MESSAGE.SET_ENCODED(l_msg_data);
420: l_msg_text := FND_MESSAGE.GET;
421:
422: l_msg_number := NULL;
423: FND_MESSAGE.PARSE_ENCODED(l_msg_data,l_app,l_msg_name);
424: OPEN c_msg_text_num (l_app, l_msg_name);
425: FETCH c_msg_text_num INTO l_msg_number;
426: CLOSE c_msg_text_num;
427:
440: FND_MSG_PUB.GET(FND_MSG_PUB.G_FIRST,
441: FND_API.G_TRUE,
442: l_enc_msg,
443: l_msg_index);
444: FND_MESSAGE.SET_ENCODED(l_enc_msg);
445: l_msg_text := FND_MESSAGE.GET;
446: FND_MSG_PUB.DELETE_MSG(l_msg_index);
447:
448: l_msg_number := NULL;
441: FND_API.G_TRUE,
442: l_enc_msg,
443: l_msg_index);
444: FND_MESSAGE.SET_ENCODED(l_enc_msg);
445: l_msg_text := FND_MESSAGE.GET;
446: FND_MSG_PUB.DELETE_MSG(l_msg_index);
447:
448: l_msg_number := NULL;
449: FND_MESSAGE.PARSE_ENCODED(l_enc_msg,l_app,l_msg_name);
445: l_msg_text := FND_MESSAGE.GET;
446: FND_MSG_PUB.DELETE_MSG(l_msg_index);
447:
448: l_msg_number := NULL;
449: FND_MESSAGE.PARSE_ENCODED(l_enc_msg,l_app,l_msg_name);
450: OPEN c_msg_text_num (l_app,l_msg_name);
451: FETCH c_msg_text_num INTO l_msg_number;
452: CLOSE c_msg_text_num;
453: insert_log_err_msgs(
599: EXCEPTION
600: WHEN g_resource_busy THEN
601: log_resource_busy(g_cst_en_sua);
602: WHEN OTHERS THEN
603: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
604: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_as_suarc');
605: IGS_GE_MSG_STACK.ADD;
606: APP_EXCEPTION.RAISE_EXCEPTION;
607:
600: WHEN g_resource_busy THEN
601: log_resource_busy(g_cst_en_sua);
602: WHEN OTHERS THEN
603: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
604: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_as_suarc');
605: IGS_GE_MSG_STACK.ADD;
606: APP_EXCEPTION.RAISE_EXCEPTION;
607:
608:
829: EXCEPTION
830: WHEN g_resource_busy THEN
831: log_resource_busy(g_cst_en_spa);
832: WHEN OTHERS THEN
833: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
834: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_spa');
835: IGS_GE_MSG_STACK.ADD;
836: APP_EXCEPTION.RAISE_EXCEPTION;
837: END process_en_spa;
830: WHEN g_resource_busy THEN
831: log_resource_busy(g_cst_en_spa);
832: WHEN OTHERS THEN
833: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
834: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_spa');
835: IGS_GE_MSG_STACK.ADD;
836: APP_EXCEPTION.RAISE_EXCEPTION;
837: END process_en_spa;
838:
995: EXCEPTION
996: WHEN g_resource_busy THEN
997: log_resource_busy(g_cst_en_spat);
998: WHEN OTHERS THEN
999: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_UNHANDLED_EXP');
1000: FND_MESSAGE.SET_TOKEN ('NAME', 'IGS_EN_LGCY_PRC.LEGACY_BATCH_PROCESS.PROCESS_EN_SPAT');
1001: IGS_GE_MSG_STACK.ADD;
1002: APP_EXCEPTION.RAISE_EXCEPTION;
1003: END process_en_spat;
996: WHEN g_resource_busy THEN
997: log_resource_busy(g_cst_en_spat);
998: WHEN OTHERS THEN
999: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_UNHANDLED_EXP');
1000: FND_MESSAGE.SET_TOKEN ('NAME', 'IGS_EN_LGCY_PRC.LEGACY_BATCH_PROCESS.PROCESS_EN_SPAT');
1001: IGS_GE_MSG_STACK.ADD;
1002: APP_EXCEPTION.RAISE_EXCEPTION;
1003: END process_en_spat;
1004:
1170: EXCEPTION
1171: WHEN g_resource_busy THEN
1172: log_resource_busy(g_cst_en_susa);
1173: WHEN OTHERS THEN
1174: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1175: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_susa');
1176: IGS_GE_MSG_STACK.ADD;
1177: APP_EXCEPTION.RAISE_EXCEPTION;
1178: END process_en_susa;
1171: WHEN g_resource_busy THEN
1172: log_resource_busy(g_cst_en_susa);
1173: WHEN OTHERS THEN
1174: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1175: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_susa');
1176: IGS_GE_MSG_STACK.ADD;
1177: APP_EXCEPTION.RAISE_EXCEPTION;
1178: END process_en_susa;
1179:
1343: EXCEPTION
1344: WHEN g_resource_busy THEN
1345: log_resource_busy(g_cst_en_spi);
1346: WHEN OTHERS THEN
1347: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1348: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_spi');
1349: IGS_GE_MSG_STACK.ADD;
1350: APP_EXCEPTION.RAISE_EXCEPTION;
1351: END process_en_spi;
1344: WHEN g_resource_busy THEN
1345: log_resource_busy(g_cst_en_spi);
1346: WHEN OTHERS THEN
1347: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1348: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_spi');
1349: IGS_GE_MSG_STACK.ADD;
1350: APP_EXCEPTION.RAISE_EXCEPTION;
1351: END process_en_spi;
1352:
1492: EXCEPTION
1493: WHEN g_resource_busy THEN
1494: log_resource_busy(g_cst_en_spaa);
1495: WHEN OTHERS THEN
1496: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1497: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_spaa');
1498: IGS_GE_MSG_STACK.ADD;
1499: APP_EXCEPTION.RAISE_EXCEPTION;
1500: END process_en_spaa;
1493: WHEN g_resource_busy THEN
1494: log_resource_busy(g_cst_en_spaa);
1495: WHEN OTHERS THEN
1496: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1497: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_spaa');
1498: IGS_GE_MSG_STACK.ADD;
1499: APP_EXCEPTION.RAISE_EXCEPTION;
1500: END process_en_spaa;
1501:
1641: EXCEPTION
1642: WHEN g_resource_busy THEN
1643: log_resource_busy(g_cst_re_sprvsr);
1644: WHEN OTHERS THEN
1645: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1646: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_re_sprvsr');
1647: IGS_GE_MSG_STACK.ADD;
1648: APP_EXCEPTION.RAISE_EXCEPTION;
1649: END process_re_sprvsr;
1642: WHEN g_resource_busy THEN
1643: log_resource_busy(g_cst_re_sprvsr);
1644: WHEN OTHERS THEN
1645: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1646: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_re_sprvsr');
1647: IGS_GE_MSG_STACK.ADD;
1648: APP_EXCEPTION.RAISE_EXCEPTION;
1649: END process_re_sprvsr;
1650:
1798: EXCEPTION
1799: WHEN g_resource_busy THEN
1800: log_resource_busy(g_cst_re_the);
1801: WHEN OTHERS THEN
1802: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1803: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_re_the');
1804: IGS_GE_MSG_STACK.ADD;
1805: APP_EXCEPTION.RAISE_EXCEPTION;
1806: END process_re_the;
1799: WHEN g_resource_busy THEN
1800: log_resource_busy(g_cst_re_the);
1801: WHEN OTHERS THEN
1802: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1803: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_re_the');
1804: IGS_GE_MSG_STACK.ADD;
1805: APP_EXCEPTION.RAISE_EXCEPTION;
1806: END process_re_the;
1807:
2022: EXCEPTION
2023: WHEN g_resource_busy THEN
2024: log_resource_busy(g_cst_en_sua);
2025: WHEN OTHERS THEN
2026: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2027: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_sua');
2028: IGS_GE_MSG_STACK.ADD;
2029: APP_EXCEPTION.RAISE_EXCEPTION;
2030: END process_en_sua;
2023: WHEN g_resource_busy THEN
2024: log_resource_busy(g_cst_en_sua);
2025: WHEN OTHERS THEN
2026: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2027: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_sua');
2028: IGS_GE_MSG_STACK.ADD;
2029: APP_EXCEPTION.RAISE_EXCEPTION;
2030: END process_en_sua;
2031:
2209: EXCEPTION
2210: WHEN g_resource_busy THEN
2211: log_resource_busy(g_cst_he_spa);
2212: WHEN OTHERS THEN
2213: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2214: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_he_spa');
2215: IGS_GE_MSG_STACK.ADD;
2216: APP_EXCEPTION.RAISE_EXCEPTION;
2217: END process_he_spa;
2210: WHEN g_resource_busy THEN
2211: log_resource_busy(g_cst_he_spa);
2212: WHEN OTHERS THEN
2213: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2214: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_he_spa');
2215: IGS_GE_MSG_STACK.ADD;
2216: APP_EXCEPTION.RAISE_EXCEPTION;
2217: END process_he_spa;
2218:
2398: EXCEPTION
2399: WHEN g_resource_busy THEN
2400: log_resource_busy(g_cst_he_susa);
2401: WHEN OTHERS THEN
2402: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2403: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_he_susa');
2404: IGS_GE_MSG_STACK.ADD;
2405: APP_EXCEPTION.RAISE_EXCEPTION;
2406: END process_he_susa;
2399: WHEN g_resource_busy THEN
2400: log_resource_busy(g_cst_he_susa);
2401: WHEN OTHERS THEN
2402: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2403: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_he_susa');
2404: IGS_GE_MSG_STACK.ADD;
2405: APP_EXCEPTION.RAISE_EXCEPTION;
2406: END process_he_susa;
2407:
2569: EXCEPTION
2570: WHEN g_resource_busy THEN
2571: log_resource_busy(g_cst_av_avstdl);
2572: WHEN OTHERS THEN
2573: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2574: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_av_avstdl');
2575: IGS_GE_MSG_STACK.ADD;
2576: APP_EXCEPTION.RAISE_EXCEPTION;
2577: END process_av_avstdl;
2570: WHEN g_resource_busy THEN
2571: log_resource_busy(g_cst_av_avstdl);
2572: WHEN OTHERS THEN
2573: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2574: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_av_avstdl');
2575: IGS_GE_MSG_STACK.ADD;
2576: APP_EXCEPTION.RAISE_EXCEPTION;
2577: END process_av_avstdl;
2578:
2745: EXCEPTION
2746: WHEN g_resource_busy THEN
2747: log_resource_busy(g_cst_av_untstd);
2748: WHEN OTHERS THEN
2749: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2750: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_av_untstd');
2751: IGS_GE_MSG_STACK.ADD;
2752: APP_EXCEPTION.RAISE_EXCEPTION;
2753: END process_av_untstd;
2746: WHEN g_resource_busy THEN
2747: log_resource_busy(g_cst_av_untstd);
2748: WHEN OTHERS THEN
2749: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2750: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_av_untstd');
2751: IGS_GE_MSG_STACK.ADD;
2752: APP_EXCEPTION.RAISE_EXCEPTION;
2753: END process_av_untstd;
2754:
2920: EXCEPTION
2921: WHEN g_resource_busy THEN
2922: log_resource_busy(g_cst_as_uotcm);
2923: WHEN OTHERS THEN
2924: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2925: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_as_uotcm');
2926: IGS_GE_MSG_STACK.ADD;
2927: APP_EXCEPTION.RAISE_EXCEPTION;
2928: END process_as_uotcm ;
2921: WHEN g_resource_busy THEN
2922: log_resource_busy(g_cst_as_uotcm);
2923: WHEN OTHERS THEN
2924: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2925: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_as_uotcm');
2926: IGS_GE_MSG_STACK.ADD;
2927: APP_EXCEPTION.RAISE_EXCEPTION;
2928: END process_as_uotcm ;
2929:
3086: EXCEPTION
3087: WHEN g_resource_busy THEN
3088: log_resource_busy(g_cst_pr_out);
3089: WHEN OTHERS THEN
3090: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3091: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_pr_out');
3092: IGS_GE_MSG_STACK.ADD;
3093: APP_EXCEPTION.RAISE_EXCEPTION;
3094: END process_pr_out;
3087: WHEN g_resource_busy THEN
3088: log_resource_busy(g_cst_pr_out);
3089: WHEN OTHERS THEN
3090: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3091: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_pr_out');
3092: IGS_GE_MSG_STACK.ADD;
3093: APP_EXCEPTION.RAISE_EXCEPTION;
3094: END process_pr_out;
3095:
3227: EXCEPTION
3228: WHEN g_resource_busy THEN
3229: log_resource_busy(g_cst_pr_cr);
3230: WHEN OTHERS THEN
3231: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3232: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_pr_cr');
3233: IGS_GE_MSG_STACK.ADD;
3234: APP_EXCEPTION.RAISE_EXCEPTION;
3235: END process_pr_cr;
3228: WHEN g_resource_busy THEN
3229: log_resource_busy(g_cst_pr_cr);
3230: WHEN OTHERS THEN
3231: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3232: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_pr_cr');
3233: IGS_GE_MSG_STACK.ADD;
3234: APP_EXCEPTION.RAISE_EXCEPTION;
3235: END process_pr_cr;
3236:
3401: EXCEPTION
3402: WHEN g_resource_busy THEN
3403: log_resource_busy(g_cst_gr_grd);
3404: WHEN OTHERS THEN
3405: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3406: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_gr_grd');
3407: IGS_GE_MSG_STACK.ADD;
3408: APP_EXCEPTION.RAISE_EXCEPTION;
3409: END process_gr_grd;
3402: WHEN g_resource_busy THEN
3403: log_resource_busy(g_cst_gr_grd);
3404: WHEN OTHERS THEN
3405: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3406: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_gr_grd');
3407: IGS_GE_MSG_STACK.ADD;
3408: APP_EXCEPTION.RAISE_EXCEPTION;
3409: END process_gr_grd;
3410:
3543: EXCEPTION
3544: WHEN g_resource_busy THEN
3545: log_resource_busy(g_cst_as_trncmt);
3546: WHEN OTHERS THEN
3547: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3548: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_as_trncmt');
3549: IGS_GE_MSG_STACK.ADD;
3550: APP_EXCEPTION.RAISE_EXCEPTION;
3551: END process_as_trncmt;
3544: WHEN g_resource_busy THEN
3545: log_resource_busy(g_cst_as_trncmt);
3546: WHEN OTHERS THEN
3547: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3548: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_as_trncmt');
3549: IGS_GE_MSG_STACK.ADD;
3550: APP_EXCEPTION.RAISE_EXCEPTION;
3551: END process_as_trncmt;
3552:
3685: EXCEPTION
3686: WHEN g_resource_busy THEN
3687: log_resource_busy(g_cst_en_spi_rcond);
3688: WHEN OTHERS THEN
3689: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3690: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_spi_rcond');
3691: IGS_GE_MSG_STACK.ADD;
3692: APP_EXCEPTION.RAISE_EXCEPTION;
3693: END process_en_spi_rcond;
3686: WHEN g_resource_busy THEN
3687: log_resource_busy(g_cst_en_spi_rcond);
3688: WHEN OTHERS THEN
3689: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3690: FND_MESSAGE.SET_TOKEN('NAME','igs_en_lgcy_prc.legacy_batch_process.process_en_spi_rcond');
3691: IGS_GE_MSG_STACK.ADD;
3692: APP_EXCEPTION.RAISE_EXCEPTION;
3693: END process_en_spi_rcond;
3694:
3745: OPEN c_batch_desc;
3746: FETCH c_batch_desc INTO l_description;
3747: CLOSE c_batch_desc;
3748:
3749: FND_MESSAGE.SET_NAME('IGS','IGS_EN_BATCH_ID');
3750: l_msg_text := FND_MESSAGE.GET;
3751:
3752: FND_MESSAGE.SET_NAME('IGS','IGS_EN_REG_LOG_DESC');
3753: l_msg_text0 := FND_MESSAGE.GET;
3746: FETCH c_batch_desc INTO l_description;
3747: CLOSE c_batch_desc;
3748:
3749: FND_MESSAGE.SET_NAME('IGS','IGS_EN_BATCH_ID');
3750: l_msg_text := FND_MESSAGE.GET;
3751:
3752: FND_MESSAGE.SET_NAME('IGS','IGS_EN_REG_LOG_DESC');
3753: l_msg_text0 := FND_MESSAGE.GET;
3754:
3748:
3749: FND_MESSAGE.SET_NAME('IGS','IGS_EN_BATCH_ID');
3750: l_msg_text := FND_MESSAGE.GET;
3751:
3752: FND_MESSAGE.SET_NAME('IGS','IGS_EN_REG_LOG_DESC');
3753: l_msg_text0 := FND_MESSAGE.GET;
3754:
3755: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3756: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3749: FND_MESSAGE.SET_NAME('IGS','IGS_EN_BATCH_ID');
3750: l_msg_text := FND_MESSAGE.GET;
3751:
3752: FND_MESSAGE.SET_NAME('IGS','IGS_EN_REG_LOG_DESC');
3753: l_msg_text0 := FND_MESSAGE.GET;
3754:
3755: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
3756: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3757: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_text || ': ' || p_batch_id || ' ' || l_msg_text0 || ': ' || l_description);
3915: EXCEPTION
3916: WHEN OTHERS THEN
3917: retcode:=2;
3918: Fnd_File.PUT_LINE(Fnd_File.LOG,SQLERRM);
3919: ERRBUF := Fnd_Message.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
3920: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3921: END legacy_batch_process;
3922:
3923: