DBA Data[Home] [Help]

APPS.IGS_PS_GEN_008 dependencies on FND_MESSAGE

Line 597: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

593: crspl_coo_adm_cat_unit_set;
594: END;
595: EXCEPTION
596: WHEN OTHERS THEN
597: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
598: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_008.crsp_ins_unit_set');
599: IGS_GE_MSG_STACK.ADD;
600: App_Exception.Raise_Exception;
601: END crsp_ins_unit_set;

Line 598: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_008.crsp_ins_unit_set');

594: END;
595: EXCEPTION
596: WHEN OTHERS THEN
597: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
598: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_008.crsp_ins_unit_set');
599: IGS_GE_MSG_STACK.ADD;
600: App_Exception.Raise_Exception;
601: END crsp_ins_unit_set;
602:

Line 2409: fnd_message.set_name('IGS', p_message_name);

2405:
2406: -- If the Procedure has returned an error , then display the error message and abort the process
2407: IF l_status = 2 THEN -- ie. The procedure call has resulted in error.
2408:
2409: fnd_message.set_name('IGS', p_message_name);
2410: IGS_GE_MSG_STACK.ADD;
2411: app_exception.raise_exception;
2412:
2413: END IF;

Line 2430: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

2426: App_Exception.Raise_Exception;
2427: END;
2428: EXCEPTION
2429: WHEN OTHERS THEN
2430: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2431: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_008.crsp_ins_unit_ver');
2432: IGS_GE_MSG_STACK.ADD;
2433: App_Exception.Raise_Exception;
2434: END crsp_ins_unit_ver;

Line 2431: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_008.crsp_ins_unit_ver');

2427: END;
2428: EXCEPTION
2429: WHEN OTHERS THEN
2430: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2431: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_008.crsp_ins_unit_ver');
2432: IGS_GE_MSG_STACK.ADD;
2433: App_Exception.Raise_Exception;
2434: END crsp_ins_unit_ver;
2435:

Line 2615: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', l_message_name)

2611:
2612: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;
2613:
2614: -- jbegum As part of bug#2563596 the call to IGS_GE_GEN_003.genp_ins_log_entry was modified .
2615: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', l_message_name)
2616: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which
2617: -- was in turn causing function IGS_PS_GEN_008.crsp_ins_uop_uoo to throw up an unhandled exception.
2618: -- Also the concatenated string being passed to parameter p_text has only l_message_name concatenated to it instead of
2619: -- FND_MESSAGE.GET_STRING('IGS', l_message_name)

Line 2619: -- FND_MESSAGE.GET_STRING('IGS', l_message_name)

2615: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', l_message_name)
2616: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which
2617: -- was in turn causing function IGS_PS_GEN_008.crsp_ins_uop_uoo to throw up an unhandled exception.
2618: -- Also the concatenated string being passed to parameter p_text has only l_message_name concatenated to it instead of
2619: -- FND_MESSAGE.GET_STRING('IGS', l_message_name)
2620:
2621:
2622:
2623: PROCEDURE handle_excp( p_old_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) AS

Line 2638: l_message_name:=fnd_message.get;

2634: l_message_name fnd_new_messages.message_text%TYPE;
2635: BEGIN
2636: --l_message_name should contain error messasges from tbh while insertion, if any other error is occured
2637: --that is fetched by using sqlerrm and stored in l_message_name
2638: l_message_name:=fnd_message.get;
2639: IF l_message_name IS NULL THEN
2640: l_message_name:=sqlerrm;
2641: END IF;
2642:

Line 3345: NVL(fnd_message.get,SQLERRM),1,4000));

3341: --Fnd log implementation
3342: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3343: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_008.crsp_ins_uop_uoo.in_exception_section_OTHERS.err_msg',
3344: SUBSTRB('Unit Section:'||v_uoo_rec.uoo_id||' '||
3345: NVL(fnd_message.get,SQLERRM),1,4000));
3346: END IF;
3347: --This exception handler has been added as a part of bug#2332807
3348: handle_excp(l_old_uoo_id);
3349: END;

Line 3547: NVL(fnd_message.get,SQLERRM),1,4000));

3543: --Fnd log implementation
3544: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3545: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_008.crsp_ins_uop_uoo.in_exception_section_OTHERS.err_msg',
3546: SUBSTRB('unit ass item id-Pattern:'||v_uai_rec.unit_ass_item_id||' '||
3547: NVL(fnd_message.get,SQLERRM),1,4000));
3548: END IF;
3549: END;
3550: END LOOP; -- c_uai_source_rec
3551: END IF;

Line 3561: NVL(fnd_message.get,SQLERRM),1,4000));

3557: --Fnd log implementation
3558: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3559: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_008.crsp_ins_uop_uoo.in_exception_section_OTHERS.err_msg',
3560: SUBSTRB('Unit Ass Item Group Id-Pattern:'||cur_unit_ass_group_rec.unit_ass_item_group_id||' '||
3561: NVL(fnd_message.get,SQLERRM),1,4000));
3562: END IF;
3563:
3564: IF cur_unitassgrp_new%ISOPEN THEN
3565: CLOSE cur_unitassgrp_new;

Line 3857: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', p_message_name)

3853: App_Exception.Raise_Exception;
3854: END;
3855:
3856: -- jbegum As part of bug#2563596 the call to IGS_GE_GEN_003.genp_ins_log_entry was modified .
3857: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', p_message_name)
3858: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which
3859: -- was in turn causing function IGS_PS_GEN_008.crsp_ins_uop_uoo to throw up an unhandled exception.
3860: -- Also the concatenated string being passed to parameter p_text has only p_message_name concatenated to it instead of
3861: -- FND_MESSAGE.GET_STRING('IGS', p_message_name)

Line 3861: -- FND_MESSAGE.GET_STRING('IGS', p_message_name)

3857: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', p_message_name)
3858: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which
3859: -- was in turn causing function IGS_PS_GEN_008.crsp_ins_uop_uoo to throw up an unhandled exception.
3860: -- Also the concatenated string being passed to parameter p_text has only p_message_name concatenated to it instead of
3861: -- FND_MESSAGE.GET_STRING('IGS', p_message_name)
3862:
3863: --Enhancement bug 1800179, pmarada
3864: -- insert record into log entry table
3865:

Line 3879: NVL(fnd_message.get,SQLERRM),1,4000));

3875: --Fnd log implementation
3876: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3877: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_008.crsp_ins_uop_uoo.in_exception_section_OTHERS.err_msg',
3878: SUBSTRB('From the Main Exception of crsp_ins_uop_uoo'||' '||
3879: NVL(fnd_message.get,SQLERRM),1,4000));
3880: END IF;
3881:
3882: OPEN cur_org_unit (l_old_uoo_id);
3883: FETCH cur_org_unit INTO lcur_org_unit;