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_PS_GEN_008 dependencies on IGS_PS_GEN_008

Line 1: PACKAGE BODY igs_ps_gen_008 AS

1: PACKAGE BODY igs_ps_gen_008 AS
2: /* $Header: IGSPS08B.pls 120.7 2006/01/31 02:33:55 sommukhe ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: -- Who When What

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 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 2617: -- was in turn causing function IGS_PS_GEN_008.crsp_ins_uop_uoo to throw up an unhandled exception.

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)
2620:
2621:

Line 3113: -- The package IGS_PS_GEN_006 has a call to IGS_PS_GEN_008.crsp_ins_uop_uoo.Before this call in the package IGS_PS_GEN_006

3109: END IF;
3110: CLOSE c_uop_dest_rec;
3111:
3112: -- Added by jbegum as part of bug #2563596
3113: -- The package IGS_PS_GEN_006 has a call to IGS_PS_GEN_008.crsp_ins_uop_uoo.Before this call in the package IGS_PS_GEN_006
3114: -- an insert is happening into igs_ge_s_log table thru a call to IGS_GE_GEN_003.genp_ins_log.The same creation date is being
3115: -- passed to the call of IGS_PS_GEN_008.crsp_ins_uop_uoo.Hence added code here to check for existence of the record in
3116: -- igs_ge_s_log table before inserting into it.Thus preventing the error 'Record already exists' being thrown up as unhandled
3117: -- exception by the procedure IGS_PS_GEN_006.crsp_ins_ci_uop_uoo

Line 3115: -- passed to the call of IGS_PS_GEN_008.crsp_ins_uop_uoo.Hence added code here to check for existence of the record in

3111:
3112: -- Added by jbegum as part of bug #2563596
3113: -- The package IGS_PS_GEN_006 has a call to IGS_PS_GEN_008.crsp_ins_uop_uoo.Before this call in the package IGS_PS_GEN_006
3114: -- an insert is happening into igs_ge_s_log table thru a call to IGS_GE_GEN_003.genp_ins_log.The same creation date is being
3115: -- passed to the call of IGS_PS_GEN_008.crsp_ins_uop_uoo.Hence added code here to check for existence of the record in
3116: -- igs_ge_s_log table before inserting into it.Thus preventing the error 'Record already exists' being thrown up as unhandled
3117: -- exception by the procedure IGS_PS_GEN_006.crsp_ins_ci_uop_uoo
3118:
3119:

Line 3343: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_008.crsp_ins_uop_uoo.in_exception_section_OTHERS.err_msg',

3339: EXCEPTION
3340: WHEN OTHERS THEN
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

Line 3545: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_008.crsp_ins_uop_uoo.in_exception_section_OTHERS.err_msg',

3541: EXCEPTION
3542: WHEN OTHERS THEN
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;

Line 3559: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_008.crsp_ins_uop_uoo.in_exception_section_OTHERS.err_msg',

3555: EXCEPTION
3556: WHEN OTHERS THEN
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:

Line 3859: -- was in turn causing function IGS_PS_GEN_008.crsp_ins_uop_uoo to throw up an unhandled exception.

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)
3862:
3863: --Enhancement bug 1800179, pmarada

Line 3877: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_008.crsp_ins_uop_uoo.in_exception_section_OTHERS.err_msg',

3873: lcur_org_unit cur_org_unit%rowtype;
3874: BEGIN
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:

Line 3898: END igs_ps_gen_008;

3894: CLOSE cur_org_unit;
3895: END;
3896: END crsp_ins_uop_uoo;
3897:
3898: END igs_ps_gen_008;