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 IGS_PS_GEN_001

Line 1: PACKAGE BODY IGS_PS_GEN_001 AS

1: PACKAGE BODY IGS_PS_GEN_001 AS
2: /* $Header: IGSPS01B.pls 120.11 2006/05/15 03:16:40 sarakshi ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

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

Line 4632: IF igs_ps_gen_001.fac_exceed_exp_wl(

4628: EXIT WHEN c_get_cal%NOTFOUND;
4629:
4630: /* If any one of the worklaod is exceeded with in particular Load calendar, then exist, else continue */
4631:
4632: IF igs_ps_gen_001.fac_exceed_exp_wl(
4633: l_c_cal_type,
4634: l_n_cal_seq_num,
4635: p_n_person_id,
4636: p_n_curr_wl,

Line 4653: END IGS_PS_GEN_001;

4649: RETURN FALSE;
4650:
4651: END teach_fac_wl;
4652:
4653: END IGS_PS_GEN_001;