APPS.IGS_PR_GEN_004 dependencies on FND_LOG

Line 2973: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2969: END IF;
2970: --
2971: stmt_str := stmt_str || 'ORDER BY sca.course_cd, sca.version_number ';
2972: --
2973: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2974: fnd_log.string (
2975: fnd_log.level_statement,
2976: 'igs.plsql.igs_pr_gen_004.prgpl_upd_initial_appl.dynamic_query',
2977: 'Query Built => ' || stmt_str

Line 2974: fnd_log.string (

2970: --
2971: stmt_str := stmt_str || 'ORDER BY sca.course_cd, sca.version_number ';
2972: --
2973: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2974: fnd_log.string (
2975: fnd_log.level_statement,
2976: 'igs.plsql.igs_pr_gen_004.prgpl_upd_initial_appl.dynamic_query',
2977: 'Query Built => ' || stmt_str
2978: );

Line 2975: fnd_log.level_statement,

2971: stmt_str := stmt_str || 'ORDER BY sca.course_cd, sca.version_number ';
2972: --
2973: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2974: fnd_log.string (
2975: fnd_log.level_statement,
2976: 'igs.plsql.igs_pr_gen_004.prgpl_upd_initial_appl.dynamic_query',
2977: 'Query Built => ' || stmt_str
2978: );
2979: END IF;

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

3064: RAISE;
3065: END;
3066: EXCEPTION
3067: WHEN OTHERS THEN
3068: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3069: fnd_log.string (
3070: fnd_log.level_exception,
3071: 'igs.plsql.igs_pr_gen_004.prgpl_upd_initial_appl.exit_exception',
3072: 'Exception => ' || SQLERRM

Line 3069: fnd_log.string (

3065: END;
3066: EXCEPTION
3067: WHEN OTHERS THEN
3068: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3069: fnd_log.string (
3070: fnd_log.level_exception,
3071: 'igs.plsql.igs_pr_gen_004.prgpl_upd_initial_appl.exit_exception',
3072: 'Exception => ' || SQLERRM
3073: );

Line 3070: fnd_log.level_exception,

3066: EXCEPTION
3067: WHEN OTHERS THEN
3068: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3069: fnd_log.string (
3070: fnd_log.level_exception,
3071: 'igs.plsql.igs_pr_gen_004.prgpl_upd_initial_appl.exit_exception',
3072: 'Exception => ' || SQLERRM
3073: );
3074: END IF;