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 FND_LOG

Line 2452: --sarakshi 17-Oct-2005 Bug#4657596, added fnd logging

2448:
2449: -------------------------------------------------------------------------------------------------------------------------------------
2450: --Change History:
2451: --Who When What
2452: --sarakshi 17-Oct-2005 Bug#4657596, added fnd logging
2453: --sarakshi 14-oct-2004 Bug#3945817, passsing unit section status as mentioned in the bug.
2454: --sarakshi 14-Sep-2004 Enh#3888835, added cursor c_teach_date and it's related logic.
2455: --sarakshi 31-AUG-2004 Bug#3864738,passed unit_section_status as OPEN in the insert row call of IGS_PS_UNIT_OFR_OPT
2456: --sarakshi 12-Jul-2004 Bug#3729462, Added the predicate DELETE_FLAG='N' to the cursor c_uop_dest_rec

Line 3341: --Fnd log implementation

3337:
3338: END IF; -- if location_cd, IGS_AS_UNIT_CLASS, grading schema validation is TRUE
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));

Line 3342: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

3338: END IF; -- if location_cd, IGS_AS_UNIT_CLASS, grading schema validation is TRUE
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;

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 3543: --Fnd log implementation

3539: END IF; -- v_uai_continue
3540:
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));

Line 3544: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

3540:
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;

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 3557: --Fnd log implementation

3553:
3554:
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));

Line 3558: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

3554:
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;

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 3875: --Fnd log implementation

3871: FROM igs_ps_unit_ofr_opt
3872: WHERE uoo_id = cp_uoo_id;
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));

Line 3876: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

3872: WHERE uoo_id = cp_uoo_id;
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;

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: