[Home] [Help]
461: IF c_coo%NOTFOUND THEN
462: CLOSE c_coo;
463: -- Log error, unable to transfer student course attempt
464: -- option as the course option is not offered.
465: IGS_GE_INS_SLE.genp_set_log_entry(
466: cst_enr_blk_co,
467: cst_blk_coo,
468: v_key,
469: 'IGS_EN_POO_NOT_EXISTS', -- Failed to transfer as option does not exist.
479: CLOSE c_cv;
480: IF v_cv_rec.s_course_status <> cst_active THEN
481: -- Log error, unable to transfer student course attempt
482: -- option as the course version is not active.
483: IGS_GE_INS_SLE.genp_set_log_entry(
484: cst_enr_blk_co,
485: cst_blk_coo,
486: v_key,
487: 'IGS_EN_FAIL_TRNS_POO_INACTIVE', -- Failed to transfer as course version not active.
498: (p_crv_version_number <> p_to_crs_version_number OR p_acad_cal_type <> p_to_acad_cal_type) THEN
499: -- Log error, unable to transfer student course attempt option
500: -- as the course version expiry date set and student
501: -- transferring into another version and calendar type.
502: IGS_GE_INS_SLE.genp_set_log_entry(
503: cst_enr_blk_co,
504: cst_blk_coo,
505: v_key,
506: 'IGS_EN_FAIL_TRNS_POO_EXPDT', -- Failed to transfer as course version expiry date set.
521: p_to_acad_cal_type,
522: v_message_name);
523: IF v_message_name is not null THEN
524:
525: IGS_GE_INS_SLE.genp_set_log_entry(
526: cst_enr_blk_co,
527: cst_blk_coo,
528: v_key,
529: v_message_name,
540: p_to_acad_cal_type,
541: v_message_name) THEN
542: IF v_message_name <> 'IGS_EN_NO_SPA_ENR_EXISTS' THEN
543:
544: IGS_GE_INS_SLE.genp_set_log_entry(
545: cst_enr_blk_co,
546: cst_blk_coo,
547: v_key,
548: 'IGS_EN_STUD_NOT_PRE_ENROLLED', -- warn pre-enrolment may be necessary.
561: v_message_name) THEN
562:
563: -- Log error, unable to transfer student course attempt option as
564: -- the course version is not active.
565: IGS_GE_INS_SLE.genp_set_log_entry(
566: cst_enr_blk_co,
567: cst_blk_coo,
568: v_key,
569: v_message_name, -- Failed to transfer as invalid funding source.
584: FETCH c_coousv INTO v_coousv_exists;
585: IF c_coousv%NOTFOUND THEN
586: CLOSE c_coousv;
587:
588: IGS_GE_INS_SLE.genp_set_log_entry(
589: cst_enr_blk_co,
590: cst_blk_coo,
591: v_key,
592: 'IGS_EN_SU_SETATT_EXISTS',
620: p_term_cal_type,
621: p_term_sequence_number) THEN
622:
623: IF v_message_name1 is not null THEN
624: IGS_GE_INS_SLE.genp_set_log_entry(
625: cst_enr_blk_co,
626: cst_blk_coo,
627: v_key,
628: v_message_name1,
629: cst_warning || '|' || cst_cross);
630: p_sca_warn_count := p_sca_warn_count + 1;
631: END IF;
632: IF v_message_name2 is not null THEN
633: IGS_GE_INS_SLE.genp_set_log_entry(
634: cst_enr_blk_co,
635: cst_blk_coo,
636: v_key,
637: v_message_name2,
638: cst_warning || '|' || cst_cross);
639: p_sca_warn_count := p_sca_warn_count + 1;
640: END IF;
641: IF v_message_name3 is not null THEN
642: IGS_GE_INS_SLE.genp_set_log_entry(
643: cst_enr_blk_co,
644: cst_blk_coo,
645: v_key,
646: v_message_name3,
813: END LOOP ;
814: EXCEPTION
815: WHEN OTHERS THEN
816: -- Log error if failed to update SPA HESA details
817: IGS_GE_INS_SLE.genp_set_log_entry(
818: cst_enr_blk_co,
819: cst_blk_coo,
820: v_key,
821: 'IGS_HE_UPD_SPA_FAIL',
831: p_course_cd, v_message) THEN
832: -- if program offering option of a completed program attempt is changed
833: -- then log warning message.
834: IF v_message IS NOT NULL THEN
835: IGS_GE_INS_SLE.genp_set_log_entry(
836: cst_enr_blk_co,
837: cst_blk_coo,
838: v_key,
839: 'IGS_EN_CHG_OPT_COMPL',
842:
843: END IF;
844:
845: -- Log that the IGS_PS_UNIT has been updated.
846: IGS_GE_INS_SLE.genp_set_log_entry(
847: cst_enr_blk_co,
848: cst_blk_coo,
849: v_key,
850: 'IGS_EN_STUD_SUCCESS_TRNS_POO', -- Successfully transferred.
883: RAISE;
884: END;
885: END enrpl_upd_sca_coo;
886: BEGIN
887: IGS_GE_INS_SLE.genp_set_log_cntr;
888: -- Determine students to be processed.
889: FOR v_sca_rec IN c_sca LOOP
890: SAVEPOINT sp_sca_blk_trn;
891: v_rollback_occurred := FALSE;
941: -- Add counts to total
942: v_total_sca_count := v_total_sca_count + 1;
943: END LOOP;
944: -- Log the summary counts.
945: IGS_GE_INS_SLE.genp_set_log_entry(
946: cst_enr_blk_co,
947: cst_blk_coo,
948: cst_summary,
949: NULL,
948: cst_summary,
949: NULL,
950: 'Total program attempts processed|' ||
951: TO_CHAR(v_total_sca_count));
952: IGS_GE_INS_SLE.genp_set_log_entry(
953: cst_enr_blk_co,
954: cst_blk_coo,
955: cst_summary,
956: NULL,
955: cst_summary,
956: NULL,
957: 'Total errors when transferring program offering option|' ||
958: TO_CHAR(v_total_sca_error_count));
959: IGS_GE_INS_SLE.genp_set_log_entry(
960: cst_enr_blk_co,
961: cst_blk_coo,
962: cst_summary,
963: NULL,
962: cst_summary,
963: NULL,
964: 'Total warning when transferring program offering option|' ||
965: TO_CHAR(v_total_sca_warn_count));
966: IGS_GE_INS_SLE.genp_set_log_entry(
967: cst_enr_blk_co,
968: cst_blk_coo,
969: cst_summary,
970: NULL,
969: cst_summary,
970: NULL,
971: 'Total program offering options transferred|' ||
972: TO_CHAR(v_total_sca_trnsfr_count));
973: IGS_GE_INS_SLE.genp_set_log_entry(
974: cst_enr_blk_co,
975: cst_blk_coo,
976: cst_summary,
977: NULL,
977: NULL,
978: 'Total locked record errors|' ||
979: TO_CHAR(v_total_lock_count));
980: -- Insert the log entries.
981: IGS_GE_INS_SLE.genp_ins_sle(
982: v_creation_dt);
983: p_creation_dt := v_creation_dt;
984: COMMIT;
985: RETURN;
1547: l_mesg_txt :=l_mesg_name;
1548: l_mesg_name:='IGS_EN_RULE_TEXT';
1549: END IF;
1550:
1551: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type => cst_enr_blk_ua,
1552: p_sl_key => cst_blk_ua,
1553: p_sle_key => p_key,
1554: p_sle_message_name => l_mesg_name,
1555: p_text => l_err_type ||l_mesg_txt);
1587: app_exception.raise_exception;
1588: END IF;
1589: CLOSE cur_cal_rel;
1590: -- Clear pl/sql table for writing IGS_GE_S_LOG_ENTRY records
1591: IGS_GE_INS_SLE.genp_set_log_cntr;
1592: -- Determine the (first) academic period of the teaching period.
1593: l_message_name := NULL;
1594: l_alternate_code := igs_en_gen_002.enrp_get_acad_alt_cd(p_cal_type =>p_teach_cal_type,
1595: p_ci_sequence_number =>p_teach_ci_sequence_number,
1752: --initialising the plsql table to store messages
1753: --whenever any error occurs, flush the table
1754: --by calling genp_set_log_cntr (this remove any success messages)
1755: --and add the error message alone.
1756: IGS_GE_INS_SLE.genp_set_log_cntr;
1757:
1758: l_processed := TRUE;
1759: l_course_key :=TO_CHAR(rec_sca.person_id) || '|' ||rec_sca.course_cd;
1760: -- Following function will returns the person type of the log in
1790: p_status =>l_deny_warn,
1791: p_message =>l_message_name);
1792: IF l_deny_warn='E' THEN --deny all hold validation
1793: l_processed := FALSE;
1794: IGS_GE_INS_SLE.genp_set_log_cntr;
1795: log_error_message(
1796: p_messages =>l_message_name,
1797: p_del =>';',
1798: p_key =>l_course_key,
1817: p_deny_warn =>l_deny_warn,
1818: p_calling_obj =>'JOB',
1819: p_create_warning =>'N') THEN
1820: --function returns the error then log all the error message and abort the further processing for the context person.
1821: IGS_GE_INS_SLE.genp_set_log_cntr;
1822: log_error_message(p_messages =>l_message_name,
1823: p_del =>';',
1824: p_key =>l_course_key,
1825: p_type =>'DENY',
1916: fnd_message.set_token('LIST',l_message_token);
1917: END IF;
1918: l_temp_msg:=fnd_message.get;
1919: fnd_file.put_line(Fnd_File.LOG,l_temp_msg);
1920: IGS_GE_INS_SLE.genp_set_log_entry(p_s_log_type =>cst_enr_blk_ua,
1921: p_sl_key =>cst_blk_ua,
1922: p_sle_key =>l_course_key,
1923: p_sle_message_name =>l_message_name,
1924: p_text =>'ERROR|'||l_temp_msg);
1927: END IF;
1928: END IF;
1929: IF l_action_processed THEN
1930: IF rec_get_sua_d.unit_attempt_status NOT IN(cst_enrolled,cst_waitlist,cst_invalid) THEN
1931: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type => cst_enr_blk_ua,
1932: p_sl_key => cst_blk_ua,
1933: p_sle_key => l_unit_key,
1934: p_sle_message_name => 'IGS_EN_UNABLE_DISCONT_UNIT',
1935: p_text => 'ERROR|'||cst_discontin);
1943: IF (igs_en_gen_008.enrp_get_var_window(p_cal_type => p_teach_cal_type,
1944: p_ci_sequence_number => p_teach_ci_sequence_number,
1945: p_effective_dt => NVL(p_enrolled_dt,SYSDATE),
1946: p_uoo_id => rec_get_sua_d.uoo_id ) = FALSE) THEN
1947: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type => cst_enr_blk_ua,
1948: p_sl_key => cst_blk_ua,
1949: p_sle_key => l_unit_key,
1950: p_sle_message_name => 'IGS_EN_TRN_ERR_VAR_WIND',
1951: p_text => 'ERROR|'||cst_discontin);
1973: p_admin_unit_status=> p_administrative_unit_status,
1974: p_uoo_ids => l_uoo_ids_list ,
1975: p_error_message => l_message_name);
1976: IF l_message_name IS NOT NULL THEN
1977: IGS_GE_INS_SLE.genp_set_log_cntr;
1978: log_error_message(p_messages =>'IGS_EN_BLK_SUB_DROP_FAILED',
1979: p_del =>';',
1980: p_key =>l_course_key,
1981: p_type =>'DENY',
2011: p_return_status =>l_return_status,
2012: p_message =>l_message_name,
2013: p_sub_unit => 'N');
2014: IF NOT l_return_status THEN
2015: IGS_GE_INS_SLE.genp_set_log_cntr;
2016: log_error_message(p_messages =>l_message_name,
2017: p_del =>';',
2018: p_key =>l_course_key,
2019: p_type =>'DENY',
2030: END IF;
2031: l_disc_count := l_disc_count + 1;
2032:
2033: IF ((p_confirmed_ind <> 'Y') OR (l_cntr_enroll = 0)) THEN
2034: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type => cst_enr_blk_ua,
2035: p_sl_key => cst_blk_ua,
2036: p_sle_key => l_unit_key,
2037: p_sle_message_name => 'IGS_EN_SUA_DISCONTINUED',
2038: p_text => 'INFORMATION|'||cst_discontin);
2082: FETCH cur_get_uoo INTO l_uoo_id,l_relation_type;
2083: CLOSE cur_get_uoo;
2084: --if uoo_id is null means that there is no offering exist for this combination.
2085: IF l_uoo_id IS NULL THEN
2086: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type => cst_enr_blk_ua,
2087: p_sl_key => cst_blk_ua,
2088: p_sle_key => l_unit_key,
2089: p_sle_message_name => 'IGS_EN_UOO_NOT_EXISTS_PARAM',
2090: p_text => 'ERROR|'||cst_enrol);
2098: IF (l_action_processed AND igs_en_gen_008.enrp_get_var_window(p_cal_type => p_teach_cal_type,
2099: p_ci_sequence_number => p_teach_ci_sequence_number,
2100: p_effective_dt => NVL(p_enrolled_dt,SYSDATE),
2101: p_uoo_id => l_uoo_id ) = FALSE) THEN
2102: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type => cst_enr_blk_ua,
2103: p_sl_key => cst_blk_ua,
2104: p_sle_key => l_unit_key,
2105: p_sle_message_name => 'IGS_EN_TRN_ERR_VAR_WIND',
2106: p_text => 'ERROR|'||cst_enrol);
2118: p_effective_date => NVL(p_enrolled_dt,SYSDATE),
2119: p_uoo_id => l_uoo_id,
2120: p_message_name => l_message_name) = FALSE) THEN
2121:
2122: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type => cst_enr_blk_ua,
2123: p_sl_key => cst_blk_ua,
2124: p_sle_key => l_unit_key,
2125: p_sle_message_name => l_message_name,
2126: p_text => 'ERROR|'||cst_enrol);
2135: FETCH cur_sua_stat INTO l_unit_attempt_status;
2136: CLOSE cur_sua_stat;
2137: IF l_action_processed THEN
2138: IF l_unit_attempt_status = cst_enrolled THEN
2139: IGS_GE_INS_SLE.genp_set_log_entry(p_s_log_type =>cst_enr_blk_ua,
2140: p_sl_key =>cst_blk_ua,
2141: p_sle_key =>l_unit_key,
2142: p_sle_message_name =>'IGS_EN_UNITVER_ATTEMPTED_STUD',
2143: p_text =>'ERROR|' || cst_enrol);
2154: p_load_ci_sequence_number =>p_load_cal_seq,
2155: p_course_cd =>rec_sca.course_cd);
2156: IF l_waitlist_ind IS NULL THEN
2157: --There is no seates are available for this unit section.
2158: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type => cst_enr_blk_ua,
2159: p_sl_key => cst_blk_ua,
2160: p_sle_key => l_unit_key,
2161: p_sle_message_name => 'IGS_EN_SS_CANNOT_WAITLIST',
2162: p_text => 'ERROR|'||cst_enrol);
2257: END IF;-- if superior and if l_ret_stat <> 'D'
2258:
2259:
2260: IF l_waitlist_ind = 'Y' THEN
2261: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type =>cst_enr_blk_ua,
2262: p_sl_key =>cst_blk_ua,
2263: p_sle_key =>l_unit_key,
2264: p_sle_message_name =>'IGS_EN_STUD_SUCCESS_WAIT_UNIT',
2265: p_text =>'INFORMATION|' || cst_enrol);
2268: l_succ_msg:='IGS_EN_UA_SECCESS_ADDED_STUD';
2269: ELSE
2270: l_succ_msg:='IGS_EN_STUD_SUCCESS_ENR_UNIT';
2271: END IF;
2272: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type =>cst_enr_blk_ua,
2273: p_sl_key =>cst_blk_ua,
2274: p_sle_key =>l_unit_key,
2275: p_sle_message_name =>l_succ_msg,
2276: p_text =>'INFORMATION|' || cst_enrol);
2313: l_ret_stat := 'FALSE';
2314: END;
2315:
2316: IF l_ret_stat = 'FALSE' AND l_deny_warn ='DENY' THEN
2317: IGS_GE_INS_SLE.genp_set_log_cntr;
2318: log_error_message(p_messages =>l_message_name,
2319: p_del =>';',
2320: p_key =>l_course_key,
2321: p_type =>'DENY',
2374: fnd_message.set_token('LIST',l_message_token);
2375: END IF;
2376: l_temp_msg:=fnd_message.get;
2377: fnd_file.put_line(Fnd_File.LOG,l_temp_msg);
2378: IGS_GE_INS_SLE.genp_set_log_entry(p_s_log_type =>cst_enr_blk_ua,
2379: p_sl_key =>cst_blk_ua,
2380: p_sle_key =>l_course_key,
2381: p_sle_message_name =>l_message_name,
2382: p_text =>'ERROR|'||l_temp_msg);
2404: p_admin_unit_status=> p_administrative_unit_status,
2405: p_uoo_ids => l_uoo_ids_list ,
2406: p_error_message => l_message_name);
2407: IF l_message_name IS NOT NULL THEN
2408: IGS_GE_INS_SLE.genp_set_log_cntr;
2409: log_error_message(p_messages =>'IGS_EN_BLK_SUB_DROP_FAILED',
2410: p_del =>';',
2411: p_key =>l_course_key,
2412: p_type =>'DENY',
2442: p_return_status =>l_return_status,
2443: p_message =>l_message_name,
2444: p_sub_unit => 'N');
2445: IF NOT l_return_status THEN
2446: IGS_GE_INS_SLE.genp_set_log_cntr;
2447: log_error_message(p_messages =>l_message_name,
2448: p_del =>';',
2449: p_key =>l_course_key,
2450: p_type =>'DENY',
2457: p_key =>l_course_key,
2458: p_type =>'WARN',
2459: p_c_u =>'D');
2460: END IF;
2461: igs_ge_ins_sle.genp_set_log_entry(p_s_log_type =>cst_enr_blk_ua,
2462: p_sl_key =>cst_blk_ua,
2463: p_sle_key =>l_unit_key,
2464: p_sle_message_name =>'IGS_EN_SUA_DISCONTINUED', -- Discontinue
2465: p_text =>'INFORMATION|' || cst_discontin);
2476: END LOOP; --i IN 1 .. l_cntr_disc
2477: END IF; --p_confirmed_ind = 'Y' AND l_processed
2478: IF NOT l_processed THEN -- if program validation fails
2479: ROLLBACK TO sp_sua_blk_e_d;
2480: IGS_GE_INS_SLE.genp_set_log_entry(p_s_log_type =>cst_enr_blk_ua,
2481: p_sl_key =>cst_blk_ua,
2482: p_sle_key =>l_course_key,
2483: p_sle_message_name =>'IGS_EN_BLK_CHG_UNDO',
2484: p_text =>'ERROR|ENROL');
2492: -- Roll back transaction.
2493: ROLLBACK TO sp_sua_blk_e_d;
2494: fnd_file.put_line(Fnd_File.LOG,sqlerrm);
2495: -- Log that a locked record exists and rollback has occurred.
2496: IGS_GE_INS_SLE.genp_set_log_entry(p_s_log_type =>cst_enr_blk_ua,
2497: p_sl_key =>cst_blk_ua,
2498: p_sle_key =>l_course_key,
2499: p_sle_message_name =>'IGS_EN_ALLALT_APPL_STUD_PRG',
2500: p_text =>'ERROR|LOCK');
2509: IF l_msg_name IS NULL THEN
2510: l_msg_name := 'IGS_EN_PRG_ROLLBCK_UNEXP';
2511: END IF;
2512: -- Log that a unhandled exception raised and rollback has occurred.
2513: IGS_GE_INS_SLE.genp_set_log_entry(p_s_log_type =>cst_enr_blk_ua,
2514: p_sl_key =>cst_blk_ua,
2515: p_sle_key =>l_course_key,
2516: p_sle_message_name =>l_msg_name,
2517: p_text =>'ERROR|ENROL');
2516: p_sle_message_name =>l_msg_name,
2517: p_text =>'ERROR|ENROL');
2518: l_total_encumb_error_count := l_total_encumb_error_count + 1;
2519: END; -- exception handler.
2520: IGS_GE_INS_SLE.genp_ins_sle(l_creation_dt);
2521: END LOOP;
2522: IGS_GE_INS_SLE.genp_set_log_cntr;
2523: -- Log the summary counts
2524: IGS_GE_INS_SLE.genp_set_log_entry(
2518: l_total_encumb_error_count := l_total_encumb_error_count + 1;
2519: END; -- exception handler.
2520: IGS_GE_INS_SLE.genp_ins_sle(l_creation_dt);
2521: END LOOP;
2522: IGS_GE_INS_SLE.genp_set_log_cntr;
2523: -- Log the summary counts
2524: IGS_GE_INS_SLE.genp_set_log_entry(
2525: p_s_log_type =>cst_enr_blk_ua,
2526: p_sl_key =>cst_blk_ua,
2520: IGS_GE_INS_SLE.genp_ins_sle(l_creation_dt);
2521: END LOOP;
2522: IGS_GE_INS_SLE.genp_set_log_cntr;
2523: -- Log the summary counts
2524: IGS_GE_INS_SLE.genp_set_log_entry(
2525: p_s_log_type =>cst_enr_blk_ua,
2526: p_sl_key =>cst_blk_ua,
2527: p_sle_key =>cst_summary,
2528: p_sle_message_name =>NULL,
2527: p_sle_key =>cst_summary,
2528: p_sle_message_name =>NULL,
2529: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_E_D_TOT_ATTEMPTS')||'|'||TO_CHAR(l_total_exist_sua_count));
2530:
2531: IGS_GE_INS_SLE.genp_set_log_entry(
2532: p_s_log_type =>cst_enr_blk_ua,
2533: p_sl_key =>cst_blk_ua,
2534: p_sle_key =>cst_summary,
2535: p_sle_message_name =>NULL,
2533: p_sl_key =>cst_blk_ua,
2534: p_sle_key =>cst_summary,
2535: p_sle_message_name =>NULL,
2536: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_PRG_ERR_COUNT')||'|'||TO_CHAR(l_total_course_error_count));
2537: IGS_GE_INS_SLE.genp_set_log_entry(
2538: p_s_log_type =>cst_enr_blk_ua,
2539: p_sl_key =>cst_blk_ua,
2540: p_sle_key =>cst_summary,
2541: p_sle_message_name =>NULL,
2539: p_sl_key =>cst_blk_ua,
2540: p_sle_key =>cst_summary,
2541: p_sle_message_name =>NULL,
2542: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_PRG_WRN_COUNT')||'|'||TO_CHAR(l_total_course_warn_count));
2543: IGS_GE_INS_SLE.genp_set_log_entry(
2544: p_s_log_type =>cst_enr_blk_ua,
2545: p_sl_key =>cst_blk_ua,
2546: p_sle_key =>cst_summary,
2547: p_sle_message_name =>NULL,
2545: p_sl_key =>cst_blk_ua,
2546: p_sle_key =>cst_summary,
2547: p_sle_message_name =>NULL,
2548: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_E_D_TOT_DIS_ERR_VAR_WIN')||'|'||TO_CHAR(l_total_disc_not_enrol_count));
2549: IGS_GE_INS_SLE.genp_set_log_entry(
2550: p_s_log_type =>cst_enr_blk_ua,
2551: p_sl_key =>cst_blk_ua,
2552: p_sle_key =>cst_summary,
2553: p_sle_message_name =>NULL,
2551: p_sl_key =>cst_blk_ua,
2552: p_sle_key =>cst_summary,
2553: p_sle_message_name =>NULL,
2554: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_E_D_TOT_ATT_CRE')||'|'||TO_CHAR(l_total_enrol_count));
2555: IGS_GE_INS_SLE.genp_set_log_entry(
2556: p_s_log_type =>cst_enr_blk_ua,
2557: p_sl_key =>cst_blk_ua,
2558: p_sle_key =>cst_summary,
2559: p_sle_message_name =>NULL,
2557: p_sl_key =>cst_blk_ua,
2558: p_sle_key =>cst_summary,
2559: p_sle_message_name =>NULL,
2560: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_E_D_TOT_ENR_ERR')||'|'||TO_CHAR(l_total_enrol_error_count));
2561: IGS_GE_INS_SLE.genp_set_log_entry(
2562: p_s_log_type =>cst_enr_blk_ua,
2563: p_sl_key =>cst_blk_ua,
2564: p_sle_key =>cst_summary,
2565: p_sle_message_name =>NULL,
2563: p_sl_key =>cst_blk_ua,
2564: p_sle_key =>cst_summary,
2565: p_sle_message_name =>NULL,
2566: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_E_D_TOT_ERN_WRN')||'|'||TO_CHAR(l_total_enrol_warn_count));
2567: IGS_GE_INS_SLE.genp_set_log_entry(
2568: p_s_log_type =>cst_enr_blk_ua,
2569: p_sl_key =>cst_blk_ua,
2570: p_sle_key =>cst_summary,
2571: p_sle_message_name =>NULL,
2569: p_sl_key =>cst_blk_ua,
2570: p_sle_key =>cst_summary,
2571: p_sle_message_name =>NULL,
2572: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_E_D_TOT_DIS_UNIT')||'|'||TO_CHAR(l_total_disc_count));
2573: IGS_GE_INS_SLE.genp_set_log_entry(
2574: p_s_log_type =>cst_enr_blk_ua,
2575: p_sl_key =>cst_blk_ua,
2576: p_sle_key =>cst_summary,
2577: p_sle_message_name =>NULL,
2575: p_sl_key =>cst_blk_ua,
2576: p_sle_key =>cst_summary,
2577: p_sle_message_name =>NULL,
2578: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_E_D_TOT_DIS_ERROR')||'|'||TO_CHAR(l_total_disc_error_count));
2579: IGS_GE_INS_SLE.genp_set_log_entry(
2580: p_s_log_type =>cst_enr_blk_ua,
2581: p_sl_key =>cst_blk_ua,
2582: p_sle_key =>cst_summary,
2583: p_sle_message_name =>NULL,
2581: p_sl_key =>cst_blk_ua,
2582: p_sle_key =>cst_summary,
2583: p_sle_message_name =>NULL,
2584: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_E_D_TOT_DIS_WARN')||'|'||TO_CHAR(l_total_disc_warn_count));
2585: IGS_GE_INS_SLE.genp_set_log_entry(
2586: p_s_log_type =>cst_enr_blk_ua,
2587: p_sl_key =>cst_blk_ua,
2588: p_sle_key =>cst_summary,
2589: p_sle_message_name =>NULL,
2587: p_sl_key =>cst_blk_ua,
2588: p_sle_key =>cst_summary,
2589: p_sle_message_name =>NULL,
2590: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_ENCUM_COUNT')||'|'||TO_CHAR(l_total_encumb_error_count));
2591: IGS_GE_INS_SLE.genp_set_log_entry(
2592: p_s_log_type =>cst_enr_blk_ua,
2593: p_sl_key =>cst_blk_ua,
2594: p_sle_key =>cst_summary,
2595: p_sle_message_name =>NULL,
2594: p_sle_key =>cst_summary,
2595: p_sle_message_name =>NULL,
2596: p_text =>FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_PRG_LCK_COUNT')||'|'||TO_CHAR(l_total_lock_count));
2597: -- Insert the log entries
2598: IGS_GE_INS_SLE.genp_ins_sle(l_creation_dt);
2599: p_creation_dt := l_creation_dt;
2600: END Enrp_Prc_Sua_Blk_E_D;
2601:
2602: -- procedure is used to store all the reference codes values
3213: CLOSE c_uoo;
3214:
3215: -- Log error, unable to transfer student IGS_PS_UNIT attempt
3216: -- option as the IGS_PS_UNIT option is not offered.
3217: IGS_GE_INS_SLE.genp_set_log_entry(
3218: cst_enr_blk_uo,
3219: cst_blk_uoo,
3220: v_key,
3221: 'IGS_EN_UOO_NOT_EXISTS', -- Failed to transfer as option does not exist.
3231: FETCH c_dest_sua INTO r_dest_sua;
3232: IF c_dest_sua%FOUND THEN
3233: -- Log error, unable to transfer student IGS_PS_UNIT attempt
3234: -- as student is already enrolled in the destination unit.
3235: IGS_GE_INS_SLE.genp_set_log_entry(
3236: cst_enr_blk_uo,
3237: cst_blk_uoo,
3238: v_key,
3239: 'IGS_EN_TRN_FAIL_DUP_ATT',
3253: CLOSE c_uoo_rel_type;
3254: IF l_source_uoo_rel='SUBORDINATE' AND (l_dest_uoo_Rel<>'SUBORDINATE' OR l_source_sup_uoo<>l_dest_sup_uoo) THEN
3255: -- Log error, unable to transfer student unit oferring
3256: -- option as the relation types are incosistent .
3257: IGS_GE_INS_SLE.genp_set_log_entry(
3258: cst_enr_blk_uo,
3259: cst_blk_uoo,
3260: v_key,
3261: 'IGS_EN_SUA_BLK_TRN_SUB_TO_SUP',
3266: END IF;
3267: IF l_source_uoo_rel='SUPERIOR' AND l_dest_uoo_Rel='SUBORDINATE' THEN
3268: -- Log error, unable to transfer student unit oferring
3269: -- option as the relation types are incosistent.
3270: IGS_GE_INS_SLE.genp_set_log_entry(
3271: cst_enr_blk_uo,
3272: cst_blk_uoo,
3273: v_key,
3274: 'IGS_EN_SUA_BLK_TRN_SUP_TO_SUB',
3285: IF v_uv_rec.s_unit_status <> cst_active THEN
3286:
3287: -- Log error, unable to transfer student IGS_PS_UNIT attempt
3288: -- option as the IGS_PS_UNIT version is not active.
3289: IGS_GE_INS_SLE.genp_set_log_entry(
3290: cst_enr_blk_uo,
3291: cst_blk_uoo,
3292: v_key,
3293: 'IGS_EN_FAIL_UNITVER_NOT_ACTIV', -- Failed to transfer as IGS_PS_UNIT version not active.
3301: IF p_u_version_number <> p_to_uv_version_number THEN
3302:
3303: -- Log error, unable to transfer student IGS_PS_UNIT attempt
3304: -- option as the IGS_PS_UNIT version is not active.
3305: IGS_GE_INS_SLE.genp_set_log_entry(
3306: cst_enr_blk_uo,
3307: cst_blk_uoo,
3308: v_key,
3309: 'IGS_EN_FAIL_UNITVER_EXPDT_SET', -- Failed to transfer as IGS_PS_UNIT version expiry date set.
3347: p_person_id => p_person_id,
3348: p_message => v_message_name
3349: );
3350: IF v_message_name IS NOT NULL THEN
3351: IGS_GE_INS_SLE.genp_set_log_entry(
3352: cst_enr_blk_uo,
3353: cst_blk_uoo,
3354: v_key,
3355: v_message_name, -- person belongs to more than one person ID group.
3374: );
3375: END IF;
3376: END IF;
3377: ELSE
3378: IGS_GE_INS_SLE.genp_set_log_entry(
3379: cst_enr_blk_uo,
3380: cst_blk_uoo,
3381: v_key,
3382: 'IGS_EN_TRN_FAIL_NO_SEATS', -- Failed to transfer.
3411: (NVL(dst_exam_rec.building_code,-1) <> NVL(src_exam_rec.building_code,-1)) OR
3412: (NVL(dst_exam_rec.room_code,-1)<> NVL(src_exam_rec.room_code,-1))
3413: )
3414: THEN
3415: IGS_GE_INS_SLE.genp_set_log_entry(
3416: cst_enr_blk_uo,
3417: cst_blk_uoo,
3418: v_key,
3419: 'IGS_EN_TRN_WARN_EXAM_VAL',
3432: p_destination_uoo_id,
3433: rec_f_unit.grading_schema_code,
3434: rec_f_unit.gs_version_number) THEN
3435:
3436: IGS_GE_INS_SLE.genp_set_log_entry(
3437: cst_enr_blk_uo,
3438: cst_blk_uoo,
3439: v_key,
3440: 'IGS_EN_MISMATH_GRAD', -- Failed to transfer.
3556:
3557: -- Source and destincation Grading schema are not the same, log an error message
3558: IF NOT l_grade_found THEN
3559:
3560: IGS_GE_INS_SLE.genp_set_log_entry(
3561: cst_enr_blk_uo,
3562: cst_blk_uoo,
3563: v_key,
3564: 'IGS_EN_MISMATH_GRAD', -- Failed to transfer.
3594: -- only when the unit is not a audit unit attempt
3595: IF v_update_uoo AND rec_f_unit.override_enrolled_cp IS NOT NULL AND rec_f_unit.no_assessment_ind <> 'Y' THEN
3596: IF l_override_enrolled_cp IS NOT NULL THEN
3597: IF l_override_enrolled_cp <> rec_f_unit.override_enrolled_cp THEN
3598: IGS_GE_INS_SLE.genp_set_log_entry(
3599: cst_enr_blk_uo,
3600: cst_blk_uoo,
3601: v_key,
3602: 'IGS_EN_MISMATH_ENR_CP', -- Failed to transfer.
3621: OPEN c_unit_enroll_cp(p_from_uoo_id);
3622: FETCH c_unit_enroll_cp INTO r_unit_enroll_cp;
3623: CLOSE c_unit_enroll_cp;
3624: IF r_unit_enroll_cp.enrolled_credit_points <> rec_f_unit.override_enrolled_cp THEN
3625: IGS_GE_INS_SLE.genp_set_log_entry(
3626: cst_enr_blk_uo,
3627: cst_blk_uoo,
3628: v_key,
3629: 'IGS_EN_MISMATH_ENR_CP', -- Failed to transfer.
3649: p_person_id => p_person_id,
3650: p_message => v_message_name
3651: );
3652: IF v_message_name IS NOT NULL THEN
3653: IGS_GE_INS_SLE.genp_set_log_entry(
3654: cst_enr_blk_uo,
3655: cst_blk_uoo,
3656: v_key,
3657: v_message_name, -- person belongs to more than one person ID group.
3673: ,l_message
3674: ,l_notification_flag
3675: ,'JOB');
3676: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
3677: IGS_GE_INS_SLE.genp_set_log_entry(
3678: cst_enr_blk_uo,
3679: cst_blk_uoo,
3680: v_key,
3681: 'IGS_EN_TRN_FAIL_INCMPT_RULE', -- Failed to transfer.
3682: cst_error || '|UV_INCMPT');
3683: p_sua_error_count := p_sua_error_count + 1;
3684: v_update_uoo := FALSE;
3685: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
3686: IGS_GE_INS_SLE.genp_set_log_entry(
3687: cst_enr_blk_uo,
3688: cst_blk_uoo,
3689: v_key,
3690: 'IGS_EN_TRN_WARN_INCMPT_RULE',
3709: p_person_id => p_person_id,
3710: p_message => v_message_name
3711: );
3712: IF v_message_name IS NOT NULL THEN
3713: IGS_GE_INS_SLE.genp_set_log_entry(
3714: cst_enr_blk_uo,
3715: cst_blk_uoo,
3716: v_key,
3717: v_message_name, -- person belongs to more than one person ID group.
3733: ,p_version_number
3734: ,l_message
3735: ,l_notification_flag);
3736: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
3737: IGS_GE_INS_SLE.genp_set_log_entry(
3738: cst_enr_blk_uo,
3739: cst_blk_uoo,
3740: v_key,
3741: 'IGS_EN_TRN_FAIL_SPL_PERM', -- Failed to transfer.
3742: cst_error || '|SPL_PERM');
3743: p_sua_error_count := p_sua_error_count + 1;
3744: v_update_uoo := FALSE;
3745: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
3746: IGS_GE_INS_SLE.genp_set_log_entry(
3747: cst_enr_blk_uo,
3748: cst_blk_uoo,
3749: v_key,
3750: 'IGS_EN_TRN_WARN_SPL_PERM',
3768: p_person_id => p_person_id,
3769: p_message => v_message_name
3770: );
3771: IF v_message_name IS NOT NULL THEN
3772: IGS_GE_INS_SLE.genp_set_log_entry(
3773: cst_enr_blk_uo,
3774: cst_blk_uoo,
3775: v_key,
3776: v_message_name, -- person belongs to more than one person ID group.
3791: p_course_version => p_version_number,
3792: p_message => l_message,
3793: p_deny_warn => l_notification_flag);
3794: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
3795: IGS_GE_INS_SLE.genp_set_log_entry(
3796: cst_enr_blk_uo,
3797: cst_blk_uoo,
3798: v_key,
3799: 'IGS_EN_TRN_FAIL_AU_PERM', -- Failed to transfer.
3800: cst_error || '|AU_PERM');
3801: p_sua_error_count := p_sua_error_count + 1;
3802: v_update_uoo := FALSE;
3803: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
3804: IGS_GE_INS_SLE.genp_set_log_entry(
3805: cst_enr_blk_uo,
3806: cst_blk_uoo,
3807: v_key,
3808: 'IGS_EN_TRN_WARN_AU_PERM',
3829: p_message => v_message_name
3830: );
3831:
3832: IF v_message_name IS NOT NULL THEN
3833: IGS_GE_INS_SLE.genp_set_log_entry(
3834: cst_enr_blk_uo,
3835: cst_blk_uoo,
3836: v_key,
3837: v_message_name, -- person belongs to more than one person ID group.
3853: l_message,
3854: l_notification_flag,
3855: 'JOB');
3856: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
3857: IGS_GE_INS_SLE.genp_set_log_entry(
3858: cst_enr_blk_uo,
3859: cst_blk_uoo,
3860: v_key,
3861: 'IGS_EN_TRN_FAIL_TIME_CNFLT', -- Failed to transfer.
3862: cst_error || '|TIME_CNFLT');
3863: p_sua_error_count := p_sua_error_count + 1;
3864: v_update_uoo := FALSE;
3865: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
3866: IGS_GE_INS_SLE.genp_set_log_entry(
3867: cst_enr_blk_uo,
3868: cst_blk_uoo,
3869: v_key,
3870: 'IGS_EN_TRN_WARN_TIME_CNFLT',
3890: p_message => v_message_name
3891: );
3892:
3893: IF v_message_name IS NOT NULL THEN
3894: IGS_GE_INS_SLE.genp_set_log_entry(
3895: cst_enr_blk_uo,
3896: cst_blk_uoo,
3897: v_key,
3898: v_message_name, -- person belongs to more than one person ID group.
3917: p_unit_version => NULL,
3918: p_calling_obj => 'JOB');
3919:
3920: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
3921: IGS_GE_INS_SLE.genp_set_log_entry(
3922: cst_enr_blk_uo,
3923: cst_blk_uoo,
3924: v_key,
3925: 'IGS_EN_TRN_FAIL_REPEAT', -- Failed to transfer.
3926: cst_error || '|UNIT_RPT');
3927: p_sua_error_count := p_sua_error_count + 1;
3928: v_update_uoo := FALSE;
3929: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
3930: IGS_GE_INS_SLE.genp_set_log_entry(
3931: cst_enr_blk_uo,
3932: cst_blk_uoo,
3933: v_key,
3934: 'IGS_EN_TRN_WARN_REPEAT',
3952: p_person_id => p_person_id,
3953: p_message => v_message_name
3954: );
3955: IF v_message_name IS NOT NULL THEN
3956: IGS_GE_INS_SLE.genp_set_log_entry(
3957: cst_enr_blk_uo,
3958: cst_blk_uoo,
3959: v_key,
3960: v_message_name, -- person belongs to more than one person ID group.
3976: p_deny_warn => l_notification_flag,
3977: p_upd_cp => l_dest_enrolled_cp-l_source_enrolled_cp,
3978: p_calling_obj => 'JOB');
3979: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
3980: IGS_GE_INS_SLE.genp_set_log_entry(
3981: cst_enr_blk_uo,
3982: cst_blk_uoo,
3983: v_key,
3984: 'IGS_EN_TRN_FAIL_MAX_CP', -- Failed to transfer.
3985: cst_error || '|PRG_MAXCP');
3986: p_sua_error_count := p_sua_error_count + 1;
3987: v_update_uoo := FALSE;
3988: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
3989: IGS_GE_INS_SLE.genp_set_log_entry(
3990: cst_enr_blk_uo,
3991: cst_blk_uoo,
3992: v_key,
3993: 'IGS_EN_TRN_WARN_MAX_CP',
4028: v_text := cst_warning || '|' || v_fail_type;
4029: p_sua_warn_count := p_sua_warn_count + 1;
4030: END IF;
4031: -- Log the problem.
4032: IGS_GE_INS_SLE.genp_set_log_entry(
4033: cst_enr_blk_uo,
4034: cst_blk_uoo,
4035: v_key,
4036: v_message_name,
4040: 'ENCUMB',
4041: 'ADVSTAND',
4042: 'ENROLDT',
4043: 'TEACHING') THEN
4044: IGS_GE_INS_SLE.genp_set_log_entry(
4045: cst_enr_blk_uo,
4046: cst_blk_uoo,
4047: v_key,
4048: 'IGS_EN_STUD_NOTTRNS_UOO', -- Failed to transfer.
4053: ELSE -- IGS_EN_VAL_SUA.enrp_val_sua_cnfrm
4054: -- Check if warnings exist and log warnings.
4055: IF v_message_name is not null THEN
4056:
4057: IGS_GE_INS_SLE.genp_set_log_entry(
4058: cst_enr_blk_uo,
4059: cst_blk_uoo,
4060: v_key,
4061: v_message_name,
4086: p_error_message => l_msg_name);
4087: IF l_msg_name IS NOT NULL THEN
4088: --Log error and indicate that not all subordinates were dropped. Abort transfer
4089: ROLLBACK TO sp_sua_blk_trn;
4090: IGS_GE_INS_SLE.genp_set_log_entry(
4091: cst_enr_blk_uo,
4092: cst_blk_uoo,
4093: v_key,
4094: 'IGS_EN_BLK_SUB_DROP_FAILED',
4346: ROLLBACK TO sp_sua_blk_trn;
4347: -- Get the message raised and log the same
4348: l_encoded_msg := fnd_message.get_encoded;
4349: fnd_message.parse_encoded(l_encoded_msg,l_app_sht_name,l_msg_name);
4350: IGS_GE_INS_SLE.genp_set_log_entry(
4351: cst_enr_blk_uo,
4352: cst_blk_uoo,
4353: v_key,
4354: l_msg_name,
4400:
4401: EXCEPTION
4402: WHEN OTHERS THEN
4403: ROLLBACK TO s_enr_trn_pt;
4404: IGS_GE_INS_SLE.genp_set_log_entry(
4405: cst_enr_blk_uo,
4406: cst_blk_uoo,
4407: v_key,
4408: 'IGS_EN_TRN_FAIL_CHILDS', -- Failed to transfer child records.
4463: l_unit_attempt_status:=NULL;
4464: IF l_sub_success IS NOT NULL THEN
4465: fnd_message.set_name('IGS','IGS_EN_BLK_SUB_SUCCESS');
4466: fnd_message.set_token('UNIT_CD',igs_en_gen_018.enrp_get_unitcds(l_sub_success));
4467: IGS_GE_INS_SLE.genp_set_log_entry(
4468: cst_enr_blk_uo,
4469: cst_blk_uoo,
4470: v_key,
4471: 'IGS_EN_BLK_SUB_SUCCESS', -- Subordinates enrolled successfully.
4474: END IF;
4475: IF l_sub_waitlist IS NOT NULL THEN
4476: fnd_message.set_name('IGS','IGS_EN_BLK_SUB_WLST');
4477: fnd_message.set_token('UNIT_CD',igs_en_gen_018.enrp_get_unitcds(l_sub_waitlist));
4478: IGS_GE_INS_SLE.genp_set_log_entry(
4479: cst_enr_blk_uo,
4480: cst_blk_uoo,
4481: v_key,
4482: 'IGS_EN_BLK_SUB_WLST', -- Subordinates enrolled successfully.
4485:
4486: IF l_sub_failed IS NOT NULL THEN
4487: fnd_message.set_name('IGS','IGS_EN_BLK_SUB_FAILED');
4488: fnd_message.set_token('UNIT_CD',igs_en_gen_018.enrp_get_unitcds(l_sub_failed));
4489: IGS_GE_INS_SLE.genp_set_log_entry(
4490: cst_enr_blk_uo,
4491: cst_blk_uoo,
4492: v_key,
4493: 'IGS_EN_BLK_SUB_FAILED', -- Subordinates enroll failed.
4511: p_message => v_message_name
4512: );
4513:
4514: IF v_message_name IS NOT NULL THEN
4515: IGS_GE_INS_SLE.genp_set_log_entry(
4516: cst_enr_blk_uo,
4517: cst_blk_uoo,
4518: v_key,
4519: v_message_name, -- person belongs to more than one person ID group.
4535: p_deny_warn => l_notification_flag,
4536: p_upd_cp => NULL,
4537: p_calling_obj => 'JOB');
4538: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
4539: IGS_GE_INS_SLE.genp_set_log_entry(
4540: cst_enr_blk_uo,
4541: cst_blk_uoo,
4542: v_key,
4543: 'IGS_EN_TRN_FAIL_REENROLL', -- Failed to transfer.
4544: cst_error || '|UNIT_REENR');
4545: p_sua_error_count := p_sua_error_count + 1;
4546: v_update_uoo := FALSE;
4547: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
4548: IGS_GE_INS_SLE.genp_set_log_entry(
4549: cst_enr_blk_uo,
4550: cst_blk_uoo,
4551: v_key,
4552: 'IGS_EN_TRN_WARN_REENROLL',
4571: p_message => v_message_name
4572: );
4573:
4574: IF v_message_name IS NOT NULL THEN
4575: IGS_GE_INS_SLE.genp_set_log_entry(
4576: cst_enr_blk_uo,
4577: cst_blk_uoo,
4578: v_key,
4579: v_message_name, -- person belongs to more than one person ID group.
4606: l_notification_flag := 'DENY';
4607: END IF;
4608:
4609: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
4610: IGS_GE_INS_SLE.genp_set_log_entry(
4611: cst_enr_blk_uo,
4612: cst_blk_uoo,
4613: v_key,
4614: 'IGS_EN_TRN_FAIL_MIN_CP', -- Failed to transfer.
4616: p_sua_error_count := p_sua_error_count + 1;
4617: v_update_uoo := FALSE;
4618: ROLLBACK TO sp_sua_blk_trn;
4619: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
4620: IGS_GE_INS_SLE.genp_set_log_entry(
4621: cst_enr_blk_uo,
4622: cst_blk_uoo,
4623: v_key,
4624: 'IGS_EN_TRN_WARN_MIN_CP',
4640: p_person_id => p_person_id,
4641: p_message => v_message_name
4642: );
4643: IF v_message_name IS NOT NULL THEN
4644: IGS_GE_INS_SLE.genp_set_log_entry(
4645: cst_enr_blk_uo,
4646: cst_blk_uoo,
4647: v_key,
4648: v_message_name, -- person belongs to more than one person ID group.
4674: l_notification_flag := 'DENY';
4675: END IF;
4676:
4677: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
4678: IGS_GE_INS_SLE.genp_set_log_entry(
4679: cst_enr_blk_uo,
4680: cst_blk_uoo,
4681: v_key,
4682: 'IGS_EN_TRN_FAIL_ATT_TYP', -- Failed to transfer.
4684: p_sua_error_count := p_sua_error_count + 1;
4685: v_update_uoo := FALSE;
4686: ROLLBACK TO sp_sua_blk_trn;
4687: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
4688: IGS_GE_INS_SLE.genp_set_log_entry(
4689: cst_enr_blk_uo,
4690: cst_blk_uoo,
4691: v_key,
4692: 'IGS_EN_TRN_WARN_ATT_TYP',
4710: p_person_id => p_person_id,
4711: p_message => v_message_name
4712: );
4713: IF v_message_name IS NOT NULL THEN
4714: IGS_GE_INS_SLE.genp_set_log_entry(
4715: cst_enr_blk_uo,
4716: cst_blk_uoo,
4717: v_key,
4718: v_message_name,
4736: p_upd_cp => NULL ,
4737: p_eligibility_step_type => 'CROSS_LOC',
4738: p_calling_obj => 'JOB' );
4739: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
4740: IGS_GE_INS_SLE.genp_set_log_entry(
4741: cst_enr_blk_uo,
4742: cst_blk_uoo,
4743: v_key,
4744: 'IGS_EN_TRN_FAIL_CRS_LOC', -- Failed to transfer.
4746: p_sua_error_count := p_sua_error_count + 1;
4747: v_update_uoo := FALSE;
4748: ROLLBACK TO sp_sua_blk_trn;
4749: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
4750: IGS_GE_INS_SLE.genp_set_log_entry(
4751: cst_enr_blk_uo,
4752: cst_blk_uoo,
4753: v_key,
4754: 'IGS_EN_TRN_WARN_CRS_LOC',
4773: p_message => v_message_name
4774: );
4775:
4776: IF v_message_name IS NOT NULL THEN
4777: IGS_GE_INS_SLE.genp_set_log_entry(
4778: cst_enr_blk_uo,
4779: cst_blk_uoo,
4780: v_key,
4781: v_message_name,
4801: p_eligibility_step_type => 'CROSS_MOD',
4802: p_calling_obj => 'JOB' );
4803:
4804: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
4805: IGS_GE_INS_SLE.genp_set_log_entry(
4806: cst_enr_blk_uo,
4807: cst_blk_uoo,
4808: v_key,
4809: 'IGS_EN_TRN_FAIL_CRS_MOD', -- Failed to transfer.
4811: p_sua_error_count := p_sua_error_count + 1;
4812: v_update_uoo := FALSE;
4813: ROLLBACK TO sp_sua_blk_trn;
4814: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
4815: IGS_GE_INS_SLE.genp_set_log_entry(
4816: cst_enr_blk_uo,
4817: cst_blk_uoo,
4818: v_key,
4819: 'IGS_EN_TRN_WARN_CRS_MOD',
4838: p_message => v_message_name
4839: );
4840:
4841: IF v_message_name IS NOT NULL THEN
4842: IGS_GE_INS_SLE.genp_set_log_entry(
4843: cst_enr_blk_uo,
4844: cst_blk_uoo,
4845: v_key,
4846: v_message_name,
4866: p_eligibility_step_type => 'CROSS_FAC',
4867: p_calling_obj => 'JOB' );
4868:
4869: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
4870: IGS_GE_INS_SLE.genp_set_log_entry(
4871: cst_enr_blk_uo,
4872: cst_blk_uoo,
4873: v_key,
4874: 'IGS_EN_TRN_FAIL_CRS_FAC', -- Failed to transfer.
4876: p_sua_error_count := p_sua_error_count + 1;
4877: v_update_uoo := FALSE;
4878: ROLLBACK TO sp_sua_blk_trn;
4879: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
4880: IGS_GE_INS_SLE.genp_set_log_entry(
4881: cst_enr_blk_uo,
4882: cst_blk_uoo,
4883: v_key,
4884: 'IGS_EN_TRN_WARN_CRS_FAC',
4905: p_person_id => p_person_id,
4906: p_message => v_message_name
4907: );
4908: IF v_message_name IS NOT NULL THEN
4909: IGS_GE_INS_SLE.genp_set_log_entry(
4910: cst_enr_blk_uo,
4911: cst_blk_uoo,
4912: v_key,
4913: v_message_name, -- person belongs to more than one person ID group.
4930: ,l_message
4931: ,l_notification_flag
4932: ,'JOB');
4933: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
4934: IGS_GE_INS_SLE.genp_set_log_entry(
4935: cst_enr_blk_uo,
4936: cst_blk_uoo,
4937: v_key,
4938: 'IGS_EN_TRN_FAIL_COREQ_RULE', -- Failed to transfer.
4940: p_sua_error_count := p_sua_error_count + 1;
4941: v_update_uoo := FALSE;
4942: ROLLBACK TO sp_sua_blk_trn;
4943: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
4944: IGS_GE_INS_SLE.genp_set_log_entry(
4945: cst_enr_blk_uo,
4946: cst_blk_uoo,
4947: v_key,
4948: 'IGS_EN_TRN_WARN_COREQ_RULE',
4969: p_message => v_message_name
4970: );
4971:
4972: IF v_message_name IS NOT NULL THEN
4973: IGS_GE_INS_SLE.genp_set_log_entry(
4974: cst_enr_blk_uo,
4975: cst_blk_uoo,
4976: v_key,
4977: v_message_name, -- person belongs to more than one person ID group.
4994: ,l_message
4995: ,l_notification_flag
4996: ,'JOB');
4997: IF ((NOT l_dummy_bolean) AND (l_notification_flag = 'DENY')) THEN
4998: IGS_GE_INS_SLE.genp_set_log_entry(
4999: cst_enr_blk_uo,
5000: cst_blk_uoo,
5001: v_key,
5002: 'IGS_EN_TRN_FAIL_PREREQ_RULE', -- Failed to transfer.
5004: p_sua_error_count := p_sua_error_count + 1;
5005: v_update_uoo := FALSE;
5006: ROLLBACK TO sp_sua_blk_trn;
5007: ELSIF ((NOT l_dummy_bolean) AND (l_notification_flag = 'WARN')) THEN
5008: IGS_GE_INS_SLE.genp_set_log_entry(
5009: cst_enr_blk_uo,
5010: cst_blk_uoo,
5011: v_key,
5012: 'IGS_EN_TRN_WARN_PREREQ_RULE',
5016: END IF;
5017: END IF;
5018: IF v_update_uoo THEN
5019: -- Log that the IGS_PS_UNIT has been updated.
5020: IGS_GE_INS_SLE.genp_set_log_entry(
5021: cst_enr_blk_uo,
5022: cst_blk_uoo,
5023: v_key,
5024: 'IGS_EN_STUD_SUCCESS_TRSF_UOO', -- Successfully transferred.
5034: -- Roll back transaction.
5035: ROLLBACK TO sp_sua_blk_trn;
5036: -- Log that a locked record exists and
5037: -- rollback has occurred.
5038: IGS_GE_INS_SLE.genp_set_log_entry(
5039: cst_enr_blk_uo,
5040: cst_blk_uoo,
5041: v_course_key,
5042: 'IGS_EN_ALLALT_APPL_STUD_PRG',
5080: p_teach_cal_type,
5081: p_teach_ci_sequence_number,
5082: v_teach_start_dt,
5083: v_teach_end_dt);
5084: IGS_GE_INS_SLE.genp_set_log_cntr;
5085:
5086: --Get the load calendar for a given calendar teaching calendar
5087: OPEN cur_load1;
5088: FETCH cur_load1 INTO l_load_cal_type,l_load_seq_number;
5127: -- for enrollment processes dld bug#1832130
5128: v_sua_rec.uoo_id) THEN
5129:
5130: v_text := 'ERROR|'||FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_ERR_VAR_WIND');
5131: IGS_GE_INS_SLE.genp_set_log_entry(
5132: cst_enr_blk_uo,
5133: cst_blk_uoo,
5134: v_course_key,
5135: 'IGS_EN_SUA_NOTALT_CUTOFDT',
5242: ',') = cst_att_valid THEN
5243: v_text := cst_error || '|' || v_text;
5244: v_validation_error := TRUE;
5245: END IF;
5246: IGS_GE_INS_SLE.genp_set_log_entry(
5247: cst_enr_blk_uo,
5248: cst_blk_uoo,
5249: v_course_key,
5250: v_sle_rec.message_name,
5255: IF IGS_GE_GEN_002.genp_get_delimit_str(
5256: v_sle_rec.key,
5257: 3,
5258: ',') = cst_invalid THEN
5259: IGS_GE_INS_SLE.genp_set_log_entry(
5260: cst_enr_blk_uo,
5261: cst_blk_uoo,
5262: v_course_key,
5263: NULL,
5265: END IF;
5266: IF v_validation_error THEN
5267: -- Log a message indicating that the IGS_PS_UNIT was
5268: -- not set to enrolled because of a validation error.
5269: IGS_GE_INS_SLE.genp_set_log_entry(
5270: cst_enr_blk_uo,
5271: cst_blk_uoo,
5272: v_course_key,
5273: 'IGS_EN_US_FAILS_ST_ENROLLED',
5294: IF (v_message_name IS NOT NULL) THEN
5295: -- Log the warning returned form enrp_val_sua_cnfrm_p
5296: v_text := cst_warning || '|';
5297: v_text := v_text || v_fail_type;
5298: IGS_GE_INS_SLE.genp_set_log_entry(
5299: cst_enr_blk_uo,
5300: cst_blk_uoo,
5301: v_course_key,
5302: v_message_name,
5306: END IF; -- end of processing occured
5307: END IF; -- check if outside enrollment variation window for the unit section
5308: ELSE
5309: --Log error message saying, Cannot transfer the Unit Section between the same source and destination
5310: IGS_GE_INS_SLE.genp_set_log_entry(
5311: cst_enr_blk_uo,
5312: cst_blk_uoo,
5313: v_course_key,
5314: 'IGS_EN_NO_TRN_SAME_USEC', -- Failed to transfer as option does not exist.
5350: -- Roll back transaction.
5351: ROLLBACK TO sp_sua_blk_trn;
5352: -- Log that a locked record exists and
5353: -- rollback has occurred.
5354: IGS_GE_INS_SLE.genp_set_log_entry(
5355: cst_enr_blk_uo,
5356: cst_blk_uoo,
5357: v_course_key,
5358: 'IGS_EN_ALLALT_APPL_STUD_PRG',
5363: RAISE;
5364: END; -- exception handler.
5365: END LOOP; -- end of unit attempts loop
5366: -- Log the summary counts.
5367: IGS_GE_INS_SLE.genp_set_log_entry(
5368: cst_enr_blk_uo,
5369: cst_blk_uoo,
5370: cst_summary,
5371: NULL,
5369: cst_blk_uoo,
5370: cst_summary,
5371: NULL,
5372: FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_PROC_COUNT')||'|'||TO_CHAR(v_total_sua_count));
5373: IGS_GE_INS_SLE.genp_set_log_entry(
5374: cst_enr_blk_uo,
5375: cst_blk_uoo,
5376: cst_summary,
5377: NULL,
5375: cst_blk_uoo,
5376: cst_summary,
5377: NULL,
5378: FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_ERR_COUNT')||'|'||TO_CHAR(v_total_sua_error_count));
5379: IGS_GE_INS_SLE.genp_set_log_entry(
5380: cst_enr_blk_uo,
5381: cst_blk_uoo,
5382: cst_summary,
5383: NULL,
5381: cst_blk_uoo,
5382: cst_summary,
5383: NULL,
5384: FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_WARN_COUNT')||'|'||TO_CHAR(v_total_sua_warn_count));
5385: IGS_GE_INS_SLE.genp_set_log_entry(
5386: cst_enr_blk_uo,
5387: cst_blk_uoo,
5388: cst_summary,
5389: NULL,
5387: cst_blk_uoo,
5388: cst_summary,
5389: NULL,
5390: FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_TRAN_COUNT')||'|'||TO_CHAR(v_total_sua_trnsfr_count));
5391: IGS_GE_INS_SLE.genp_set_log_entry(
5392: cst_enr_blk_uo,
5393: cst_blk_uoo,
5394: cst_summary,
5395: NULL,
5393: cst_blk_uoo,
5394: cst_summary,
5395: NULL,
5396: FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_ENCUM_COUNT')||'|'||TO_CHAR(v_total_encumb_error_count));
5397: IGS_GE_INS_SLE.genp_set_log_entry(
5398: cst_enr_blk_uo,
5399: cst_blk_uoo,
5400: cst_summary,
5401: NULL,
5399: cst_blk_uoo,
5400: cst_summary,
5401: NULL,
5402: FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_PRG_ERR_COUNT')||'|'||TO_CHAR(v_total_course_error_count));
5403: IGS_GE_INS_SLE.genp_set_log_entry(
5404: cst_enr_blk_uo,
5405: cst_blk_uoo,
5406: cst_summary,
5407: NULL,
5405: cst_blk_uoo,
5406: cst_summary,
5407: NULL,
5408: FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_PRG_WRN_COUNT')||'|'||TO_CHAR(v_total_course_warn_count));
5409: IGS_GE_INS_SLE.genp_set_log_entry(
5410: cst_enr_blk_uo,
5411: cst_blk_uoo,
5412: cst_summary,
5413: NULL,
5412: cst_summary,
5413: NULL,
5414: FND_MESSAGE.GET_STRING('IGS','IGS_EN_TRN_TOT_PRG_LCK_COUNT')||'|'|| TO_CHAR(v_total_lock_count));
5415: -- Insert the log entries.
5416: IGS_GE_INS_SLE.genp_ins_sle(
5417: v_creation_dt);
5418: p_creation_dt := v_creation_dt;
5419: COMMIT;
5420: RETURN;