[Home] [Help]
50: -- to table handler procedure calls as part of CCR - ENCR022.
51: --Nalin Kumar 28-Jan-2002 Added Procedure 'enrp_ins_sca_ukstat_trnsfr' and modified function enrp_ins_susa_trnsfr
52: -- procedure as pert of the HESA Intregation DLD (ENCR019). Bug# 2201753.
53: --prraj 21-Feb-2002 Added column QUAL_DETS_ID to the tbh calls of pkg
54: -- IGS_AV_STND_UNIT_LVL_PKG (Bug# 2233334)
55: --Added refernces to column ORG_UNIT_CD in call to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
56: --pmarada 24-Feb-2002 Added the copy-hesa_details Procedure, for the hesa requirment.
57: --Nishikant 03-May-2002 The Local procedure enrpl_copy_adm_unit_sets got modified to make Unit Sets Confirmed if
58: -- Program attempt got confirmed - due to the Enhancement Bug#2347141
58: -- Program attempt got confirmed - due to the Enhancement Bug#2347141
59: --smadadli 14-may-2002 Modified procedures copy_hesa_details , enrp_ins_snew_prenrl , enrp_ins_sret_prenrl for bug#2350629
60: --pmarada 23 -May-2002 Modified the c_us_version_number cursor, to fetch the next year from the program offerring option.
61: --nalkumar 05-June-2002 Removed the referances of the igs_av_stnd_unit/unit_lvl_pkg.(PREV_UNIT_CD and TEST_DETAILS_ID) parameter.
62: -- Modified the call to the igs_av_stnd_unit_pkg and igs_av_stnd_unit_lvl_pkg as per the bug# 2401170.
63: --smaddali 12-jun-2002 bug 2391799 modified procedure enrpl_copy_adm_unit_sets
64: --Nishikant 07OCT2002 UK Enhancement Build - Enh Bug#2580731 - Added the parameter p_selection_date in the Function Enrp_Ins_Sret_Prenrl
65: --kkillams 16-06-2003 Three new parameters are added to the Enrp_Ins_Snew_Prenrl and Enrp_Ins_Sret_Prenrl functions
66: -- ENRP_INS_PRE_POS, ENRPL_CREATE_POS_SUA,ENRPL_COPY_ADM_SUA and ENRPL_COPY_PARAM_SUA procedures are modified as per TD
7707: NOT (rec_dest_unit_lvl_dtls_found))) THEN
7708: BEGIN
7709: l_rowid5 := NULL;
7710: l_av_stnd_unit_lvl_id := rec_unit_lvl_dtls.av_stnd_unit_lvl_id;
7711: igs_av_stnd_unit_lvl_pkg.insert_row (
7712: x_mode => 'R',
7713: x_rowid => l_rowid5,
7714: x_person_id => p_person_id,
7715: x_as_course_cd => p_course_cd_new,
7742: --
7743: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7744: fnd_log.string (
7745: fnd_log.level_exception,
7746: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',
7747: 'Error:' || SQLERRM
7748: );
7749: END IF;
7750: RAISE;
7772: --
7773: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7774: fnd_log.string (
7775: fnd_log.level_exception,
7776: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',
7777: 'Error:' || SQLERRM
7778: );
7779: END IF;
7780: RAISE;
7784: ELSIF ((v_transfer_type = 'REVERSE_TRANSFER') AND
7785: (rec_dest_unit_lvl_dtls_found) AND
7786: (rec_dest_unit_lvl_dtls.s_adv_stnd_granting_status = 'TRANSFERRED')) THEN
7787: BEGIN
7788: igs_av_stnd_unit_lvl_pkg.update_row (
7789: x_mode => 'R',
7790: x_rowid => rec_dest_unit_lvl_dtls.ROWID,
7791: x_person_id => rec_dest_unit_lvl_dtls.person_id,
7792: x_as_course_cd => rec_dest_unit_lvl_dtls.as_course_cd,
7817: --
7818: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7819: fnd_log.string (
7820: fnd_log.level_exception,
7821: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_dest_update_exception',
7822: 'Error:' || SQLERRM
7823: );
7824: END IF;
7825: RAISE;
7831: v_unt_lvl_transfer_flag := 'N';
7832: END IF;
7833: BEGIN
7834: IF (v_unt_lvl_transfer_flag = 'Y') THEN
7835: igs_av_stnd_unit_lvl_pkg.update_row (
7836: x_mode => 'R',
7837: x_rowid => rec_unit_lvl_dtls.ROWID,
7838: x_person_id => rec_unit_lvl_dtls.person_id,
7839: x_as_course_cd => rec_unit_lvl_dtls.as_course_cd,
7865: --
7866: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7867: fnd_log.string (
7868: fnd_log.level_exception,
7869: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_src_update_exception',
7870: 'Error:' || SQLERRM
7871: );
7872: END IF;
7873: RAISE;