DBA Data[Home] [Help]

APPS.IGS_PS_GEN_001 dependencies on FND_MESSAGE

Line 1830: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

1826: App_Exception.Raise_Exception;
1827: END;
1828: EXCEPTION
1829: WHEN OTHERS THEN
1830: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1831: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_001.crspl_ins_dms_rec');
1832: IGS_GE_MSG_STACK.ADD;
1833: App_Exception.Raise_Exception;
1834: END crspl_ins_dms_rec;

Line 1831: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_001.crspl_ins_dms_rec');

1827: END;
1828: EXCEPTION
1829: WHEN OTHERS THEN
1830: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1831: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_001.crspl_ins_dms_rec');
1832: IGS_GE_MSG_STACK.ADD;
1833: App_Exception.Raise_Exception;
1834: END crspl_ins_dms_rec;
1835:

Line 2069: Fnd_Message.Set_Name('IGS', p_message_name);

2065: out p_message_name,
2066: out l_status;
2067:
2068: IF NVL(l_Status,0) = 2 THEN -- ie. The procedure call has resulted in error.
2069: Fnd_Message.Set_Name('IGS', p_message_name);
2070: IGS_GE_MSG_STACK.ADD;
2071: App_Exception.Raise_Exception;
2072: END IF;
2073: ELSE

Line 2082: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

2078: -- End of new code added as per the HESA DLD Build. ENCR019 Bug# 2201753.
2079: --
2080: EXCEPTION
2081: WHEN OTHERS THEN
2082: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2083: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_001.CRSP_INS_CRS_VER');
2084: IGS_GE_MSG_STACK.ADD;
2085: App_Exception.Raise_Exception;
2086: END crsp_ins_crs_ver; -- main procedure

Line 2083: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_001.CRSP_INS_CRS_VER');

2079: --
2080: EXCEPTION
2081: WHEN OTHERS THEN
2082: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2083: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_001.CRSP_INS_CRS_VER');
2084: IGS_GE_MSG_STACK.ADD;
2085: App_Exception.Raise_Exception;
2086: END crsp_ins_crs_ver; -- main procedure
2087:

Line 2820: 'Reference Code:'||usec_occurs_refcd_rec.reference_code||' '||NVL(fnd_message.get,SQLERRM),1,4000));

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;
2823: END LOOP;
2824: END IF;

Line 2867: NVL(fnd_message.get,SQLERRM),1,4000));

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;
2870: END LOOP;
2871: END IF;

Line 2893: NVL(fnd_message.get,SQLERRM),1,4000));

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;
2896: END LOOP;
2897: END IF;

Line 2910: NVL(fnd_message.get,SQLERRM),1,4000));

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;
2913:
2914: END LOOP;

Line 3059: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3062: END LOOP;
3063:

Line 3070: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3073: END LOOP;
3074: END IF;

Line 3081: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3084: END LOOP;
3085:

Line 3139: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3142: END LOOP;
3143:

Line 3212: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3215:
3216:

Line 3254: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3257: END LOOP;
3258:

Line 3316: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3319: END LOOP;
3320:

Line 3359: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3362: END LOOP;
3363:

Line 3443: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3446: END LOOP;
3447: END IF;

Line 3456: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3459:
3460: END LOOP;

Line 3524: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3527: END LOOP;
3528:

Line 3569: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3572: END LOOP;
3573:

Line 3637: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3640: END LOOP;
3641:

Line 3696: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3699: END LOOP;
3700:

Line 3771: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3774: END LOOP;
3775:

Line 3810: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3813: END LOOP;
3814:

Line 3862: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3865: END LOOP;
3866:

Line 3951: NVL(fnd_message.get,SQLERRM),1,4000));

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;
3954: END LOOP;
3955:

Line 4039: NVL(fnd_message.get,SQLERRM),1,4000));

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;
4042: END LOOP;
4043:

Line 4172: NVL(fnd_message.get,SQLERRM),1,4000));

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;
4175: END LOOP;
4176: END IF;

Line 4184: NVL(fnd_message.get,SQLERRM),1,4000));

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;
4187: END LOOP;
4188: END IF;