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_001 dependencies on FND_LOG

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

2101: --Who When What
2102: --sommukhe 08-JAN-2006 Bug#3305881,modified cursor c_ou by replacing IGS_OR_UNIT with IGS_OR_INST_ORG_BASE_V
2103: --sarakshi 12-Jan-2006 BUg#4926548,modified cursor c_fee_type_exists and c_fee_type_cal_exists to address performance issues, created pl-sql table.
2104: --sommukhe 23-NOV-2005 Bug#4726560, added cursors cur_usec_tchr_lead,cur_usec_tchr1, c_tch_ins and cur_usec_gs_df.
2105: --sarakshi 17-Oct-2005 Bug#4657596, added fnd logging
2106: --sarakshi 12-Sep-2005 Bug#45772, placed flexfield attributes in the call to the occurrence insert row with the local variables.
2107: --sommukhe 01-SEP-2005 Bug# 4538540 , Added cursor cur_ass_item .
2108: --sarakshi 14-Sep-2004 Enh#3888835, added cursor c_rtn_us,c_rtn_us_dtl and c_fee_type_cal_exists and it's related logic (of retention rollover).
2109: --sarakshi 12-Jul-2004 Bug#3729462, Added the column DELETE_FLAG in the where clause of the cursor cur_waitlist_chk .

Line 2816: --Fnd log implementation

2812: x_mode => 'R',
2813: x_reference_code_desc => usec_occurs_refcd_rec.reference_code_desc);
2814: EXCEPTION
2815: WHEN OTHERS THEN
2816: --Fnd log implementation
2817: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2818: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2819: SUBSTRB('Unit Section Occurrence Id:'||usec_occurs_refcd_rec.unit_section_occurrence_id||' '||'Reference Code Type:'||usec_occurs_refcd_rec.reference_code_type||' '||
2820: 'Reference Code:'||usec_occurs_refcd_rec.reference_code||' '||NVL(fnd_message.get,SQLERRM),1,4000));

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

2813: x_reference_code_desc => usec_occurs_refcd_rec.reference_code_desc);
2814: EXCEPTION
2815: WHEN OTHERS THEN
2816: --Fnd log implementation
2817: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2818: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2819: SUBSTRB('Unit Section Occurrence Id:'||usec_occurs_refcd_rec.unit_section_occurrence_id||' '||'Reference Code Type:'||usec_occurs_refcd_rec.reference_code_type||' '||
2820: 'Reference Code:'||usec_occurs_refcd_rec.reference_code||' '||NVL(fnd_message.get,SQLERRM),1,4000));
2821: END IF;

Line 2818: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

2814: EXCEPTION
2815: WHEN OTHERS THEN
2816: --Fnd log implementation
2817: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2818: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2819: SUBSTRB('Unit Section Occurrence Id:'||usec_occurs_refcd_rec.unit_section_occurrence_id||' '||'Reference Code Type:'||usec_occurs_refcd_rec.reference_code_type||' '||
2820: 'Reference Code:'||usec_occurs_refcd_rec.reference_code||' '||NVL(fnd_message.get,SQLERRM),1,4000));
2821: END IF;
2822: END;

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

2841:
2842: OPEN cur_usec_tchr1(p_old_uoo_Id,usec_instr_rec.instructor_id);
2843: FETCH cur_usec_tchr1 INTO cur_usec_tchr1_rec;
2844: IF cur_usec_tchr1%FOUND AND l_dest_lead_inst_id IS NOT NULL THEN
2845: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2846: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_PS_GEN_001.crsp_ins_unit_section.instructor_not_rolled_over_one_lead_already_in_destination_unit_section',
2847: 'Not rolling over Lead Instructo:'||usec_instr_rec.instructor_id||' '||'from Source UOO:'||p_old_uoo_Id||' '||
2848: 'to Destination UOO:'||p_new_uoo_id||' '||'as there already exists a different Lead Instructor:'||cur_usec_tchr_lead_rec.instructor_id||' '||
2849: 'in the Destination');

Line 2846: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_PS_GEN_001.crsp_ins_unit_section.instructor_not_rolled_over_one_lead_already_in_destination_unit_section',

2842: OPEN cur_usec_tchr1(p_old_uoo_Id,usec_instr_rec.instructor_id);
2843: FETCH cur_usec_tchr1 INTO cur_usec_tchr1_rec;
2844: IF cur_usec_tchr1%FOUND AND l_dest_lead_inst_id IS NOT NULL THEN
2845: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2846: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_PS_GEN_001.crsp_ins_unit_section.instructor_not_rolled_over_one_lead_already_in_destination_unit_section',
2847: 'Not rolling over Lead Instructo:'||usec_instr_rec.instructor_id||' '||'from Source UOO:'||p_old_uoo_Id||' '||
2848: 'to Destination UOO:'||p_new_uoo_id||' '||'as there already exists a different Lead Instructor:'||cur_usec_tchr_lead_rec.instructor_id||' '||
2849: 'in the Destination');
2850: END IF;

Line 2863: --Fnd log implementation

2859: CLOSE cur_usec_tchr1;
2860: END IF;
2861: EXCEPTION
2862: WHEN OTHERS THEN
2863: --Fnd log implementation
2864: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2865: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2866: SUBSTRB('Unit Section Occurrence Id:'||usec_instr_rec.unit_section_occurrence_id||' '||'Instructor Id:'||usec_instr_rec.instructor_id||' '||
2867: NVL(fnd_message.get,SQLERRM),1,4000));

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

2860: END IF;
2861: EXCEPTION
2862: WHEN OTHERS THEN
2863: --Fnd log implementation
2864: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2865: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2866: SUBSTRB('Unit Section Occurrence Id:'||usec_instr_rec.unit_section_occurrence_id||' '||'Instructor Id:'||usec_instr_rec.instructor_id||' '||
2867: NVL(fnd_message.get,SQLERRM),1,4000));
2868: END IF;

Line 2865: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

2861: EXCEPTION
2862: WHEN OTHERS THEN
2863: --Fnd log implementation
2864: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2865: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2866: SUBSTRB('Unit Section Occurrence Id:'||usec_instr_rec.unit_section_occurrence_id||' '||'Instructor Id:'||usec_instr_rec.instructor_id||' '||
2867: NVL(fnd_message.get,SQLERRM),1,4000));
2868: END IF;
2869: END;

Line 2889: --Fnd log implementation

2885: x_facility_code => usec_fac_rec.facility_code,
2886: x_mode => 'R' );
2887: EXCEPTION
2888: WHEN OTHERS THEN
2889: --Fnd log implementation
2890: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2891: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2892: SUBSTRB('Unit Section Occurrence Id:'||usec_fac_rec.unit_section_occurrence_id||' '||'Facility Code:'||usec_fac_rec.facility_code||' '||
2893: NVL(fnd_message.get,SQLERRM),1,4000));

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

2886: x_mode => 'R' );
2887: EXCEPTION
2888: WHEN OTHERS THEN
2889: --Fnd log implementation
2890: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2891: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2892: SUBSTRB('Unit Section Occurrence Id:'||usec_fac_rec.unit_section_occurrence_id||' '||'Facility Code:'||usec_fac_rec.facility_code||' '||
2893: NVL(fnd_message.get,SQLERRM),1,4000));
2894: END IF;

Line 2891: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

2887: EXCEPTION
2888: WHEN OTHERS THEN
2889: --Fnd log implementation
2890: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2891: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2892: SUBSTRB('Unit Section Occurrence Id:'||usec_fac_rec.unit_section_occurrence_id||' '||'Facility Code:'||usec_fac_rec.facility_code||' '||
2893: NVL(fnd_message.get,SQLERRM),1,4000));
2894: END IF;
2895: END;

Line 2906: --Fnd log implementation

2902: END IF; --Roll allowed
2903:
2904: EXCEPTION
2905: WHEN OTHERS THEN
2906: --Fnd log implementation
2907: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2908: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2909: SUBSTRB('Unit Section Occurrence Id:'||usec_occurs_rec.unit_section_occurrence_id||' '||'Occurrence Identifier:'||usec_occurs_rec.occurrence_identifier||' '||
2910: NVL(fnd_message.get,SQLERRM),1,4000));

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

2903:
2904: EXCEPTION
2905: WHEN OTHERS THEN
2906: --Fnd log implementation
2907: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2908: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2909: SUBSTRB('Unit Section Occurrence Id:'||usec_occurs_rec.unit_section_occurrence_id||' '||'Occurrence Identifier:'||usec_occurs_rec.occurrence_identifier||' '||
2910: NVL(fnd_message.get,SQLERRM),1,4000));
2911: END IF;

Line 2908: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

2904: EXCEPTION
2905: WHEN OTHERS THEN
2906: --Fnd log implementation
2907: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2908: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
2909: SUBSTRB('Unit Section Occurrence Id:'||usec_occurs_rec.unit_section_occurrence_id||' '||'Occurrence Identifier:'||usec_occurs_rec.occurrence_identifier||' '||
2910: NVL(fnd_message.get,SQLERRM),1,4000));
2911: END IF;
2912: END;

Line 3055: --Fnd log implementation

3051: CLOSE cur_wlst_prf_new;
3052:
3053: EXCEPTION
3054: WHEN OTHERS THEN
3055: --Fnd log implementation
3056: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3057: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3058: SUBSTRB('Unit Sec Waitlist Pref Id:'||wlst_prf_rec.unit_sec_waitlist_pref_id||' '||
3059: NVL(fnd_message.get,SQLERRM),1,4000));

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

3052:
3053: EXCEPTION
3054: WHEN OTHERS THEN
3055: --Fnd log implementation
3056: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3057: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3058: SUBSTRB('Unit Sec Waitlist Pref Id:'||wlst_prf_rec.unit_sec_waitlist_pref_id||' '||
3059: NVL(fnd_message.get,SQLERRM),1,4000));
3060: END IF;

Line 3057: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3053: EXCEPTION
3054: WHEN OTHERS THEN
3055: --Fnd log implementation
3056: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3057: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3058: SUBSTRB('Unit Sec Waitlist Pref Id:'||wlst_prf_rec.unit_sec_waitlist_pref_id||' '||
3059: NVL(fnd_message.get,SQLERRM),1,4000));
3060: END IF;
3061: END;

Line 3066: --Fnd log implementation

3062: END LOOP;
3063:
3064: EXCEPTION
3065: WHEN OTHERS THEN
3066: --Fnd log implementation
3067: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3068: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3069: SUBSTRB('Unit Sec Wait Priority Id:'||wlst_pri_rec.unit_sec_waitlist_priority_id||' '||
3070: NVL(fnd_message.get,SQLERRM),1,4000));

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

3063:
3064: EXCEPTION
3065: WHEN OTHERS THEN
3066: --Fnd log implementation
3067: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3068: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3069: SUBSTRB('Unit Sec Wait Priority Id:'||wlst_pri_rec.unit_sec_waitlist_priority_id||' '||
3070: NVL(fnd_message.get,SQLERRM),1,4000));
3071: END IF;

Line 3068: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3064: EXCEPTION
3065: WHEN OTHERS THEN
3066: --Fnd log implementation
3067: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3068: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3069: SUBSTRB('Unit Sec Wait Priority Id:'||wlst_pri_rec.unit_sec_waitlist_priority_id||' '||
3070: NVL(fnd_message.get,SQLERRM),1,4000));
3071: END IF;
3072: END;

Line 3077: --Fnd log implementation

3073: END LOOP;
3074: END IF;
3075: EXCEPTION
3076: WHEN OTHERS THEN
3077: --Fnd log implementation
3078: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3079: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3080: SUBSTRB('unit section limit wlst id:'||wlst_limit_rec.unit_section_limit_waitlist_id||' '||
3081: NVL(fnd_message.get,SQLERRM),1,4000));

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

3074: END IF;
3075: EXCEPTION
3076: WHEN OTHERS THEN
3077: --Fnd log implementation
3078: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3079: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3080: SUBSTRB('unit section limit wlst id:'||wlst_limit_rec.unit_section_limit_waitlist_id||' '||
3081: NVL(fnd_message.get,SQLERRM),1,4000));
3082: END IF;

Line 3079: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3075: EXCEPTION
3076: WHEN OTHERS THEN
3077: --Fnd log implementation
3078: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3079: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3080: SUBSTRB('unit section limit wlst id:'||wlst_limit_rec.unit_section_limit_waitlist_id||' '||
3081: NVL(fnd_message.get,SQLERRM),1,4000));
3082: END IF;
3083: END;

Line 3135: --Fnd log implementation

3131: CLOSE cur_usec_cps_new;
3132:
3133: EXCEPTION
3134: WHEN OTHERS THEN
3135: --Fnd log implementation
3136: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3137: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3138: SUBSTRB('Unit Sec Credit Points Id:'||usec_cps_rec.unit_sec_credit_points_id||' '||
3139: NVL(fnd_message.get,SQLERRM),1,4000));

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

3132:
3133: EXCEPTION
3134: WHEN OTHERS THEN
3135: --Fnd log implementation
3136: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3137: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3138: SUBSTRB('Unit Sec Credit Points Id:'||usec_cps_rec.unit_sec_credit_points_id||' '||
3139: NVL(fnd_message.get,SQLERRM),1,4000));
3140: END IF;

Line 3137: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3133: EXCEPTION
3134: WHEN OTHERS THEN
3135: --Fnd log implementation
3136: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3137: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3138: SUBSTRB('Unit Sec Credit Points Id:'||usec_cps_rec.unit_sec_credit_points_id||' '||
3139: NVL(fnd_message.get,SQLERRM),1,4000));
3140: END IF;
3141: END;

Line 3208: --Fnd log implementation

3204:
3205: END LOOP;
3206: EXCEPTION
3207: WHEN OTHERS THEN
3208: --Fnd log implementation
3209: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3210: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3211: SUBSTRB('Unit Section-CrossListed:'||p_old_uoo_id||' '||
3212: NVL(fnd_message.get,SQLERRM),1,4000));

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

3205: END LOOP;
3206: EXCEPTION
3207: WHEN OTHERS THEN
3208: --Fnd log implementation
3209: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3210: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3211: SUBSTRB('Unit Section-CrossListed:'||p_old_uoo_id||' '||
3212: NVL(fnd_message.get,SQLERRM),1,4000));
3213: END IF;

Line 3210: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3206: EXCEPTION
3207: WHEN OTHERS THEN
3208: --Fnd log implementation
3209: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3210: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3211: SUBSTRB('Unit Section-CrossListed:'||p_old_uoo_id||' '||
3212: NVL(fnd_message.get,SQLERRM),1,4000));
3213: END IF;
3214: END;

Line 3250: --Fnd log implementation

3246: CLOSE cur_usec_spn_new;
3247:
3248: EXCEPTION
3249: WHEN OTHERS THEN
3250: --Fnd log implementation
3251: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3252: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3253: SUBSTRB('Unit Section Sponsorship Id:'||usec_spn_rec.unit_section_sponsorship_id||' '||
3254: NVL(fnd_message.get,SQLERRM),1,4000));

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

3247:
3248: EXCEPTION
3249: WHEN OTHERS THEN
3250: --Fnd log implementation
3251: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3252: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3253: SUBSTRB('Unit Section Sponsorship Id:'||usec_spn_rec.unit_section_sponsorship_id||' '||
3254: NVL(fnd_message.get,SQLERRM),1,4000));
3255: END IF;

Line 3252: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3248: EXCEPTION
3249: WHEN OTHERS THEN
3250: --Fnd log implementation
3251: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3252: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3253: SUBSTRB('Unit Section Sponsorship Id:'||usec_spn_rec.unit_section_sponsorship_id||' '||
3254: NVL(fnd_message.get,SQLERRM),1,4000));
3255: END IF;
3256: END;

Line 3312: --Fnd log implementation

3308: CLOSE cur_usec_tchr_new;
3309:
3310: EXCEPTION
3311: WHEN OTHERS THEN
3312: --Fnd log implementation
3313: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3314: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3315: SUBSTRB('unit section teach resp id:'||usec_tchr_rec.unit_section_teach_resp_id||' '||
3316: NVL(fnd_message.get,SQLERRM),1,4000));

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

3309:
3310: EXCEPTION
3311: WHEN OTHERS THEN
3312: --Fnd log implementation
3313: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3314: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3315: SUBSTRB('unit section teach resp id:'||usec_tchr_rec.unit_section_teach_resp_id||' '||
3316: NVL(fnd_message.get,SQLERRM),1,4000));
3317: END IF;

Line 3314: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3310: EXCEPTION
3311: WHEN OTHERS THEN
3312: --Fnd log implementation
3313: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3314: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3315: SUBSTRB('unit section teach resp id:'||usec_tchr_rec.unit_section_teach_resp_id||' '||
3316: NVL(fnd_message.get,SQLERRM),1,4000));
3317: END IF;
3318: END;

Line 3355: --Fnd log implementation

3351: CLOSE cur_usec_as_new;
3352:
3353: EXCEPTION
3354: WHEN OTHERS THEN
3355: --Fnd log implementation
3356: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3357: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3358: SUBSTRB('Unit Section Assessment Id-Exam:'||usec_as_rec.unit_section_assessment_id||' '||
3359: NVL(fnd_message.get,SQLERRM),1,4000));

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

3352:
3353: EXCEPTION
3354: WHEN OTHERS THEN
3355: --Fnd log implementation
3356: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3357: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3358: SUBSTRB('Unit Section Assessment Id-Exam:'||usec_as_rec.unit_section_assessment_id||' '||
3359: NVL(fnd_message.get,SQLERRM),1,4000));
3360: END IF;

Line 3357: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3353: EXCEPTION
3354: WHEN OTHERS THEN
3355: --Fnd log implementation
3356: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3357: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3358: SUBSTRB('Unit Section Assessment Id-Exam:'||usec_as_rec.unit_section_assessment_id||' '||
3359: NVL(fnd_message.get,SQLERRM),1,4000));
3360: END IF;
3361: END;

Line 3439: --Fnd log implementation

3435: x_final_weight_qty => usec_unitass_rec.final_weight_qty
3436: );
3437: EXCEPTION
3438: WHEN OTHERS THEN
3439: --Fnd log implementation
3440: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3441: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3442: SUBSTRB('Unit Section Ass Item Id:'||usec_unitass_rec.unit_section_ass_item_id||' '||
3443: NVL(fnd_message.get,SQLERRM),1,4000));

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

3436: );
3437: EXCEPTION
3438: WHEN OTHERS THEN
3439: --Fnd log implementation
3440: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3441: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3442: SUBSTRB('Unit Section Ass Item Id:'||usec_unitass_rec.unit_section_ass_item_id||' '||
3443: NVL(fnd_message.get,SQLERRM),1,4000));
3444: END IF;

Line 3441: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3437: EXCEPTION
3438: WHEN OTHERS THEN
3439: --Fnd log implementation
3440: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3441: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3442: SUBSTRB('Unit Section Ass Item Id:'||usec_unitass_rec.unit_section_ass_item_id||' '||
3443: NVL(fnd_message.get,SQLERRM),1,4000));
3444: END IF;
3445: END;

Line 3452: --Fnd log implementation

3448: CLOSE cur_ass_item;
3449:
3450: EXCEPTION
3451: WHEN OTHERS THEN
3452: --Fnd log implementation
3453: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3454: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3455: SUBSTRB('Unit Section Ass Item Group Id:'||usec_unitassgrp_rec.us_ass_item_group_id||' '||
3456: NVL(fnd_message.get,SQLERRM),1,4000));

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

3449:
3450: EXCEPTION
3451: WHEN OTHERS THEN
3452: --Fnd log implementation
3453: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3454: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3455: SUBSTRB('Unit Section Ass Item Group Id:'||usec_unitassgrp_rec.us_ass_item_group_id||' '||
3456: NVL(fnd_message.get,SQLERRM),1,4000));
3457: END IF;

Line 3454: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3450: EXCEPTION
3451: WHEN OTHERS THEN
3452: --Fnd log implementation
3453: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3454: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3455: SUBSTRB('Unit Section Ass Item Group Id:'||usec_unitassgrp_rec.us_ass_item_group_id||' '||
3456: NVL(fnd_message.get,SQLERRM),1,4000));
3457: END IF;
3458: END;

Line 3520: --Fnd log implementation

3516: CLOSE cur_usec_refcd_new;
3517:
3518: EXCEPTION
3519: WHEN OTHERS THEN
3520: --Fnd log implementation
3521: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3522: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3523: SUBSTRB('Unit Section Reference Id:'||usec_refcd_rec.unit_section_reference_id||' '||'Reference Code Type:'||usec_refcd_rec.reference_code_type||' '||'Reference Code:'||usec_refcd_rec.reference_code||' '||
3524: NVL(fnd_message.get,SQLERRM),1,4000));

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

3517:
3518: EXCEPTION
3519: WHEN OTHERS THEN
3520: --Fnd log implementation
3521: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3522: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3523: SUBSTRB('Unit Section Reference Id:'||usec_refcd_rec.unit_section_reference_id||' '||'Reference Code Type:'||usec_refcd_rec.reference_code_type||' '||'Reference Code:'||usec_refcd_rec.reference_code||' '||
3524: NVL(fnd_message.get,SQLERRM),1,4000));
3525: END IF;

Line 3522: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3518: EXCEPTION
3519: WHEN OTHERS THEN
3520: --Fnd log implementation
3521: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3522: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3523: SUBSTRB('Unit Section Reference Id:'||usec_refcd_rec.unit_section_reference_id||' '||'Reference Code Type:'||usec_refcd_rec.reference_code_type||' '||'Reference Code:'||usec_refcd_rec.reference_code||' '||
3524: NVL(fnd_message.get,SQLERRM),1,4000));
3525: END IF;
3526: END;

Line 3565: --Fnd log implementation

3561: CLOSE cur_us_req_refcd_new;
3562:
3563: EXCEPTION
3564: WHEN OTHERS THEN
3565: --Fnd log implementation
3566: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3567: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3568: SUBSTRB('Unit Section Reference Id:'||us_req_refcd_rec.unit_section_reference_id||' '||'Reference Cd Type:'||us_req_refcd_rec.reference_cd_type||' '||'Reference Cd:'||us_req_refcd_rec.reference_code||' '||
3569: NVL(fnd_message.get,SQLERRM),1,4000));

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

3562:
3563: EXCEPTION
3564: WHEN OTHERS THEN
3565: --Fnd log implementation
3566: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3567: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3568: SUBSTRB('Unit Section Reference Id:'||us_req_refcd_rec.unit_section_reference_id||' '||'Reference Cd Type:'||us_req_refcd_rec.reference_cd_type||' '||'Reference Cd:'||us_req_refcd_rec.reference_code||' '||
3569: NVL(fnd_message.get,SQLERRM),1,4000));
3570: END IF;

Line 3567: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3563: EXCEPTION
3564: WHEN OTHERS THEN
3565: --Fnd log implementation
3566: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3567: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3568: SUBSTRB('Unit Section Reference Id:'||us_req_refcd_rec.unit_section_reference_id||' '||'Reference Cd Type:'||us_req_refcd_rec.reference_cd_type||' '||'Reference Cd:'||us_req_refcd_rec.reference_code||' '||
3569: NVL(fnd_message.get,SQLERRM),1,4000));
3570: END IF;
3571: END;

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

3603: OPEN cur_usec_gs_df(p_new_uoo_id);
3604: FETCH cur_usec_gs_df INTO cur_usec_gs_df_rec;
3605: IF cur_usec_gs_df%FOUND AND usec_grdsch_rec.default_flag ='Y' THEN
3606: l_default_flag := FALSE;
3607: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3608: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_PS_GEN_001.crsp_ins_unit_section.usec_grading_schema_not_rolled_over_one_default_already_in_destination_unit_section',
3609: 'Not rolling over Default Grading Schema code'||usec_grdsch_rec.grading_schema_code||' '||
3610: 'version number:'||usec_grdsch_rec.grd_schm_version_number||' '||'from Source UOO'||p_old_uoo_Id||' '||
3611: 'to Destination UOO:'||p_new_uoo_id||' '||'as there already exists a different Default Grading Schema code'||cur_usec_gs_df_rec.grading_schema_code||' '||

Line 3608: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_PS_GEN_001.crsp_ins_unit_section.usec_grading_schema_not_rolled_over_one_default_already_in_destination_unit_section',

3604: FETCH cur_usec_gs_df INTO cur_usec_gs_df_rec;
3605: IF cur_usec_gs_df%FOUND AND usec_grdsch_rec.default_flag ='Y' THEN
3606: l_default_flag := FALSE;
3607: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3608: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_PS_GEN_001.crsp_ins_unit_section.usec_grading_schema_not_rolled_over_one_default_already_in_destination_unit_section',
3609: 'Not rolling over Default Grading Schema code'||usec_grdsch_rec.grading_schema_code||' '||
3610: 'version number:'||usec_grdsch_rec.grd_schm_version_number||' '||'from Source UOO'||p_old_uoo_Id||' '||
3611: 'to Destination UOO:'||p_new_uoo_id||' '||'as there already exists a different Default Grading Schema code'||cur_usec_gs_df_rec.grading_schema_code||' '||
3612: 'version number'||cur_usec_gs_df_rec.grd_schm_version_number||' '||'in the destination');

Line 3633: --Fnd log implementation

3629: CLOSE cur_usec_grdsch_new;
3630:
3631: EXCEPTION
3632: WHEN OTHERS THEN
3633: --Fnd log implementation
3634: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3635: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3636: SUBSTRB('Unit Section Grad Schema Id:'||usec_grdsch_rec.unit_section_grading_schema_id||' '||
3637: NVL(fnd_message.get,SQLERRM),1,4000));

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

3630:
3631: EXCEPTION
3632: WHEN OTHERS THEN
3633: --Fnd log implementation
3634: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3635: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3636: SUBSTRB('Unit Section Grad Schema Id:'||usec_grdsch_rec.unit_section_grading_schema_id||' '||
3637: NVL(fnd_message.get,SQLERRM),1,4000));
3638: END IF;

Line 3635: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3631: EXCEPTION
3632: WHEN OTHERS THEN
3633: --Fnd log implementation
3634: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3635: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3636: SUBSTRB('Unit Section Grad Schema Id:'||usec_grdsch_rec.unit_section_grading_schema_id||' '||
3637: NVL(fnd_message.get,SQLERRM),1,4000));
3638: END IF;
3639: END;

Line 3692: --Fnd log implementation

3688: CLOSE cur_c_unt_ofr_opt_n_new;
3689:
3690: EXCEPTION
3691: WHEN OTHERS THEN
3692: --Fnd log implementation
3693: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3694: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3695: SUBSTRB('Crs Note Type:'||c_unt_ofr_opt_n_rec.crs_note_type||' '||'Unit Section:'||p_old_uoo_id||' '||
3696: NVL(fnd_message.get,SQLERRM),1,4000));

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

3689:
3690: EXCEPTION
3691: WHEN OTHERS THEN
3692: --Fnd log implementation
3693: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3694: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3695: SUBSTRB('Crs Note Type:'||c_unt_ofr_opt_n_rec.crs_note_type||' '||'Unit Section:'||p_old_uoo_id||' '||
3696: NVL(fnd_message.get,SQLERRM),1,4000));
3697: END IF;

Line 3694: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3690: EXCEPTION
3691: WHEN OTHERS THEN
3692: --Fnd log implementation
3693: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3694: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3695: SUBSTRB('Crs Note Type:'||c_unt_ofr_opt_n_rec.crs_note_type||' '||'Unit Section:'||p_old_uoo_id||' '||
3696: NVL(fnd_message.get,SQLERRM),1,4000));
3697: END IF;
3698: END;

Line 3767: --Fnd log implementation

3763: CLOSE cur_usec_pre_co_req_rule_new;
3764:
3765: EXCEPTION
3766: WHEN OTHERS THEN
3767: --Fnd log implementation
3768: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3769: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3770: SUBSTRB('S Rule Call Cd:'||usec_pre_co_req_rule_rec.s_rule_call_cd||' '||'Unit Section:'||p_old_uoo_id||' '||
3771: NVL(fnd_message.get,SQLERRM),1,4000));

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

3764:
3765: EXCEPTION
3766: WHEN OTHERS THEN
3767: --Fnd log implementation
3768: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3769: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3770: SUBSTRB('S Rule Call Cd:'||usec_pre_co_req_rule_rec.s_rule_call_cd||' '||'Unit Section:'||p_old_uoo_id||' '||
3771: NVL(fnd_message.get,SQLERRM),1,4000));
3772: END IF;

Line 3769: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3765: EXCEPTION
3766: WHEN OTHERS THEN
3767: --Fnd log implementation
3768: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3769: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3770: SUBSTRB('S Rule Call Cd:'||usec_pre_co_req_rule_rec.s_rule_call_cd||' '||'Unit Section:'||p_old_uoo_id||' '||
3771: NVL(fnd_message.get,SQLERRM),1,4000));
3772: END IF;
3773: END;

Line 3806: --Fnd log implementation

3802: CLOSE cur_usec_cat_new;
3803:
3804: EXCEPTION
3805: WHEN OTHERS THEN
3806: --Fnd log implementation
3807: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3808: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3809: SUBSTRB('unit Cat:'||usec_cat_rec.unit_cat||' '||'Unit Section:'||p_old_uoo_id||' '||
3810: NVL(fnd_message.get,SQLERRM),1,4000));

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

3803:
3804: EXCEPTION
3805: WHEN OTHERS THEN
3806: --Fnd log implementation
3807: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3808: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3809: SUBSTRB('unit Cat:'||usec_cat_rec.unit_cat||' '||'Unit Section:'||p_old_uoo_id||' '||
3810: NVL(fnd_message.get,SQLERRM),1,4000));
3811: END IF;

Line 3808: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3804: EXCEPTION
3805: WHEN OTHERS THEN
3806: --Fnd log implementation
3807: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3808: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3809: SUBSTRB('unit Cat:'||usec_cat_rec.unit_cat||' '||'Unit Section:'||p_old_uoo_id||' '||
3810: NVL(fnd_message.get,SQLERRM),1,4000));
3811: END IF;
3812: END;

Line 3858: --Fnd log implementation

3854: CLOSE cur_usec_plushr_new;
3855:
3856: EXCEPTION
3857: WHEN OTHERS THEN
3858: --Fnd log implementation
3859: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3860: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3861: SUBSTRB('Us Unscheduled Cl Id:'||usec_plushr_rec.us_unscheduled_cl_id||' '||
3862: NVL(fnd_message.get,SQLERRM),1,4000));

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

3855:
3856: EXCEPTION
3857: WHEN OTHERS THEN
3858: --Fnd log implementation
3859: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3860: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3861: SUBSTRB('Us Unscheduled Cl Id:'||usec_plushr_rec.us_unscheduled_cl_id||' '||
3862: NVL(fnd_message.get,SQLERRM),1,4000));
3863: END IF;

Line 3860: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3856: EXCEPTION
3857: WHEN OTHERS THEN
3858: --Fnd log implementation
3859: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3860: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3861: SUBSTRB('Us Unscheduled Cl Id:'||usec_plushr_rec.us_unscheduled_cl_id||' '||
3862: NVL(fnd_message.get,SQLERRM),1,4000));
3863: END IF;
3864: END;

Line 3947: --Fnd log implementation

3943: CLOSE cur_usec_tro_new;
3944:
3945: EXCEPTION
3946: WHEN OTHERS THEN
3947: --Fnd log implementation
3948: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3949: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3950: SUBSTRB('Org Unit Cd:'||usec_tro_rec.org_unit_cd||' '||'Unit Section:'||p_old_uoo_id||' '||
3951: NVL(fnd_message.get,SQLERRM),1,4000));

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

3944:
3945: EXCEPTION
3946: WHEN OTHERS THEN
3947: --Fnd log implementation
3948: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3949: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3950: SUBSTRB('Org Unit Cd:'||usec_tro_rec.org_unit_cd||' '||'Unit Section:'||p_old_uoo_id||' '||
3951: NVL(fnd_message.get,SQLERRM),1,4000));
3952: END IF;

Line 3949: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

3945: EXCEPTION
3946: WHEN OTHERS THEN
3947: --Fnd log implementation
3948: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3949: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
3950: SUBSTRB('Org Unit Cd:'||usec_tro_rec.org_unit_cd||' '||'Unit Section:'||p_old_uoo_id||' '||
3951: NVL(fnd_message.get,SQLERRM),1,4000));
3952: END IF;
3953: END;

Line 4035: --Fnd log implementation

4031: CLOSE cur_usec_spl_fees_new;
4032:
4033: EXCEPTION
4034: WHEN OTHERS THEN
4035: --Fnd log implementation
4036: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4037: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
4038: SUBSTRB('Fee Type-Special Fees:'||usec_spl_fees_rec.fee_type||' '||'Unit Section:'||p_old_uoo_id||' '||
4039: NVL(fnd_message.get,SQLERRM),1,4000));

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

4032:
4033: EXCEPTION
4034: WHEN OTHERS THEN
4035: --Fnd log implementation
4036: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4037: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
4038: SUBSTRB('Fee Type-Special Fees:'||usec_spl_fees_rec.fee_type||' '||'Unit Section:'||p_old_uoo_id||' '||
4039: NVL(fnd_message.get,SQLERRM),1,4000));
4040: END IF;

Line 4037: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

4033: EXCEPTION
4034: WHEN OTHERS THEN
4035: --Fnd log implementation
4036: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4037: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
4038: SUBSTRB('Fee Type-Special Fees:'||usec_spl_fees_rec.fee_type||' '||'Unit Section:'||p_old_uoo_id||' '||
4039: NVL(fnd_message.get,SQLERRM),1,4000));
4040: END IF;
4041: END;

Line 4168: --Fnd log implementation

4164: CLOSE c_rtn_us_new;
4165:
4166: EXCEPTION
4167: WHEN OTHERS THEN
4168: --Fnd log implementation
4169: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4170: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
4171: SUBSTRB('Non Std Usec Rtn Dtl Id:'||c_rtn_us_dtl_rec.non_std_usec_rtn_dtl_id||' '||
4172: NVL(fnd_message.get,SQLERRM),1,4000));

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

4165:
4166: EXCEPTION
4167: WHEN OTHERS THEN
4168: --Fnd log implementation
4169: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4170: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
4171: SUBSTRB('Non Std Usec Rtn Dtl Id:'||c_rtn_us_dtl_rec.non_std_usec_rtn_dtl_id||' '||
4172: NVL(fnd_message.get,SQLERRM),1,4000));
4173: END IF;

Line 4170: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

4166: EXCEPTION
4167: WHEN OTHERS THEN
4168: --Fnd log implementation
4169: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4170: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
4171: SUBSTRB('Non Std Usec Rtn Dtl Id:'||c_rtn_us_dtl_rec.non_std_usec_rtn_dtl_id||' '||
4172: NVL(fnd_message.get,SQLERRM),1,4000));
4173: END IF;
4174: END;

Line 4180: --Fnd log implementation

4176: END IF;
4177:
4178: EXCEPTION
4179: WHEN OTHERS THEN
4180: --Fnd log implementation
4181: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4182: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
4183: SUBSTRB('Non Std Usec Rtn Id:'||c_rtn_us_rec.non_std_usec_rtn_id||' '||
4184: NVL(fnd_message.get,SQLERRM),1,4000));

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

4177:
4178: EXCEPTION
4179: WHEN OTHERS THEN
4180: --Fnd log implementation
4181: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4182: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
4183: SUBSTRB('Non Std Usec Rtn Id:'||c_rtn_us_rec.non_std_usec_rtn_id||' '||
4184: NVL(fnd_message.get,SQLERRM),1,4000));
4185: END IF;

Line 4182: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',

4178: EXCEPTION
4179: WHEN OTHERS THEN
4180: --Fnd log implementation
4181: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
4182: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_001.crsp_ins_unit_section.in_exception_section_OTHERS.err_msg',
4183: SUBSTRB('Non Std Usec Rtn Id:'||c_rtn_us_rec.non_std_usec_rtn_id||' '||
4184: NVL(fnd_message.get,SQLERRM),1,4000));
4185: END IF;
4186: END;