DBA Data[Home] [Help]

APPS.IGS_PS_GEN_006 dependencies on FND_LOG

Line 289: --sarakshi 17-Oct-2005 Bug#4657596, added fnd logging and corrected ERRBUF setting in the exception

285: AS
286: -------------------------------------------------------------------------------------------
287: --Change History:
288: --Who When What
289: --sarakshi 17-Oct-2005 Bug#4657596, added fnd logging and corrected ERRBUF setting in the exception
290: --sarakshi 14-Oct-2005 BUg#4657596, modified the exception such that get_string is called appropriately.
291: --sommukhe 01-SEP-2005 Bug# 4538540 , removed p_org_unit_cd and used Rollback in when others of the Exception Block.
292: --shtatiko 3-FEB-2003 Bug# 2550411, Added code to log information wherever needed to make
293: -- log file more informative.

Line 822: --Fnd log implementation

818: ROLLBACK;
819: -- SQLERRM has been added as per Bug Fux 2550411
820: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
821: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
822: --Fnd log implementation
823: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
824: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_006.crsp_ins_ci_uop_uoo.in_exception_section_OTHERS.err_msg',
825: SUBSTRB(SQLERRM,1,4000));
826: END IF;

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

819: -- SQLERRM has been added as per Bug Fux 2550411
820: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
821: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
822: --Fnd log implementation
823: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
824: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_006.crsp_ins_ci_uop_uoo.in_exception_section_OTHERS.err_msg',
825: SUBSTRB(SQLERRM,1,4000));
826: END IF;
827:

Line 824: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_006.crsp_ins_ci_uop_uoo.in_exception_section_OTHERS.err_msg',

820: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
821: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
822: --Fnd log implementation
823: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
824: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_006.crsp_ins_ci_uop_uoo.in_exception_section_OTHERS.err_msg',
825: SUBSTRB(SQLERRM,1,4000));
826: END IF;
827:
828: END crsp_ins_ci_uop_uoo;