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.

[Home] [Help]

APPS.IGS_AD_IMP_OFF_RESP_DATA dependencies on IGS_AD_GEN_008

Line 428: IF NVL(igs_ad_gen_008.admp_get_saos(acaiv_rec.adm_outcome_status), 'NULL') NOT IN (cst_offer, cst_cond_offer) THEN

424: p_validation_success := 'Y';
425:
426: --Validations on the Application Instance Outcome Status. Check if the Applicant's Outcome Status is mapped to one of the System Outcome Status of
427: --'Make Offer of Admission' (OFFER) or 'Make Offer of Admission Subject to Condition' (COND-OFFER).
428: IF NVL(igs_ad_gen_008.admp_get_saos(acaiv_rec.adm_outcome_status), 'NULL') NOT IN (cst_offer, cst_cond_offer) THEN
429: insert_int_error(p_offresp_int_id, 'E618',NULL);
430: p_validation_success := 'N';
431: logdetail(p_offresp_int_id, 'E618', NULL, 'validate_off_resp_dtls: IF NVL(igs_ad_gen_008.admp_get_saos(acaiv_rec.adm_outcome_status)' ,NULL);
432: RETURN;

Line 431: logdetail(p_offresp_int_id, 'E618', NULL, 'validate_off_resp_dtls: IF NVL(igs_ad_gen_008.admp_get_saos(acaiv_rec.adm_outcome_status)' ,NULL);

427: --'Make Offer of Admission' (OFFER) or 'Make Offer of Admission Subject to Condition' (COND-OFFER).
428: IF NVL(igs_ad_gen_008.admp_get_saos(acaiv_rec.adm_outcome_status), 'NULL') NOT IN (cst_offer, cst_cond_offer) THEN
429: insert_int_error(p_offresp_int_id, 'E618',NULL);
430: p_validation_success := 'N';
431: logdetail(p_offresp_int_id, 'E618', NULL, 'validate_off_resp_dtls: IF NVL(igs_ad_gen_008.admp_get_saos(acaiv_rec.adm_outcome_status)' ,NULL);
432: RETURN;
433: END IF;
434:
435: --Check if the Interface Offer Response Status is a valid Offer Response Status mapped to one of the System Offer Response Statuses.

Line 436: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) IS NULL THEN

432: RETURN;
433: END IF;
434:
435: --Check if the Interface Offer Response Status is a valid Offer Response Status mapped to one of the System Offer Response Statuses.
436: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) IS NULL THEN
437: insert_int_error(p_offresp_int_id, 'E600',NULL);
438: p_validation_success := 'N';
439: logdetail(p_offresp_int_id, 'E600', NULL, 'validate_off_resp_dtls: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status)' ,NULL);
440: RETURN;

Line 439: logdetail(p_offresp_int_id, 'E600', NULL, 'validate_off_resp_dtls: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status)' ,NULL);

435: --Check if the Interface Offer Response Status is a valid Offer Response Status mapped to one of the System Offer Response Statuses.
436: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) IS NULL THEN
437: insert_int_error(p_offresp_int_id, 'E600',NULL);
438: p_validation_success := 'N';
439: logdetail(p_offresp_int_id, 'E600', NULL, 'validate_off_resp_dtls: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status)' ,NULL);
440: RETURN;
441: END IF;
442:
443:

Line 448: /IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = igs_ad_gen_008.admp_get_saors(acaiv_rec.adm_offer_resp_status) THEN /

444: /********** VALIDATIONS WHICH CHECK FOR THE PROPER COMBINATION OF INTERFACE Vs SYSTEM TABLE Offer Response Status. Stop processing in case of failure *******/
445:
446: -- Check if Interface Offer Response status = Production table (IGS_AD_PS_APPL_INST_ALL) Offer Response Status.
447: /* Hashed this code as part of bug fix for 2631947. The corresponding MNT fix is through 2624637 */
448: /*IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = igs_ad_gen_008.admp_get_saors(acaiv_rec.adm_offer_resp_status) THEN */
449:
450: IF p_adm_offer_resp_status = acaiv_rec.adm_offer_resp_status THEN
451: insert_int_error(p_offresp_int_id, 'E601',NULL);
452: p_validation_success := 'N';

Line 453: logdetail(p_offresp_int_id, 'E601', NULL, 'validate_off_resp_dtls: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status)' ,NULL);

449:
450: IF p_adm_offer_resp_status = acaiv_rec.adm_offer_resp_status THEN
451: insert_int_error(p_offresp_int_id, 'E601',NULL);
452: p_validation_success := 'N';
453: logdetail(p_offresp_int_id, 'E601', NULL, 'validate_off_resp_dtls: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status)' ,NULL);
454: RETURN;
455: END IF;
456: -- Check if the Interface Offer Response Status is allowed to update the existing offer response in production table.
457:

Line 459: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) <> cst_pending AND igs_ad_gen_008.admp_get_saors(acaiv_rec.adm_offer_resp_status) = cst_deferral THEN

455: END IF;
456: -- Check if the Interface Offer Response Status is allowed to update the existing offer response in production table.
457:
458: -- If Offer Response is changed to PENDING from DEFERRAL, then the Deffered Calendars should be NULL otherswise insert error record into corresponding table
459: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) <> cst_pending AND igs_ad_gen_008.admp_get_saors(acaiv_rec.adm_offer_resp_status) = cst_deferral THEN
460: IF p_def_acad_cal_type IS NOT NULL OR p_def_acad_ci_sequence_number IS NOT NULL THEN
461: insert_int_error(p_offresp_int_id, 'E612',NULL);
462: p_validation_success := 'N';
463: logdetail(p_offresp_int_id, 'E612', NULL, 'validate_off_resp_dtls: Check if the Interface Offer Response Status is allowed to update' ,NULL);

Line 483: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) NOT IN (cst_pending, cst_lapsed, cst_not_applic) THEN

479: --Copy the interface Actual Response Date to the OUT NOCOPY Variable p_calc_actual_ofr_resp_dt and populate this variable accordingly after necessary validations
480: p_calc_actual_ofr_resp_dt := p_actual_offer_response_dt;
481:
482: -- Check if Interface Offer Response Status is Other than 'PENDING', 'LAPSED', 'NOT-APPLIC'.
483: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) NOT IN (cst_pending, cst_lapsed, cst_not_applic) THEN
484: IF p_calc_actual_ofr_resp_dt IS NULL THEN
485: p_calc_actual_ofr_resp_dt := SYSDATE;
486: ELSE
487: IF TRUNC(p_calc_actual_ofr_resp_dt) > TRUNC(SYSDATE) THEN

Line 497: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) IN ('REJECTED','NOT-COMING') AND p_decline_ofr_reason IS NULL THEN

493: END IF;
494: END IF;
495:
496: --arvsrini igsm
497: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) IN ('REJECTED','NOT-COMING') AND p_decline_ofr_reason IS NULL THEN
498: insert_int_error(p_offresp_int_id, 'E592',NULL);
499: p_validation_success := 'N';
500: logdetail(p_offresp_int_id, 'E592', NULL, 'validate_off_resp_dtls: Check if the Interface Offer Response Status is allowed to update' ,NULL);
501:

Line 562: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_deferral AND

558: -- Default the Offer Deferment Status, depending on the value of Offer Response Status, and validate the same.
559: -- IF Offer Response Status is 'DEFERRAL', then default the Offer Deferment Status to 'PENDING'.
560: -- ELSE Offer Response Status is not equal to 'DEFERRAL', then Default the Offer Deferment Status to 'NOT-APPLIC'.
561:
562: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_deferral AND
563: NVL(igs_ad_gen_008.admp_get_saods(acaiv_rec.adm_offer_dfrmnt_status), cst_not_applic) = cst_not_applic THEN
564: IF igs_ad_gen_009.admp_get_sys_aods(cst_pending) IS NULL THEN
565: insert_int_error(p_offresp_int_id, 'E625',NULL);
566: p_validation_success := 'N';

Line 563: NVL(igs_ad_gen_008.admp_get_saods(acaiv_rec.adm_offer_dfrmnt_status), cst_not_applic) = cst_not_applic THEN

559: -- IF Offer Response Status is 'DEFERRAL', then default the Offer Deferment Status to 'PENDING'.
560: -- ELSE Offer Response Status is not equal to 'DEFERRAL', then Default the Offer Deferment Status to 'NOT-APPLIC'.
561:
562: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_deferral AND
563: NVL(igs_ad_gen_008.admp_get_saods(acaiv_rec.adm_offer_dfrmnt_status), cst_not_applic) = cst_not_applic THEN
564: IF igs_ad_gen_009.admp_get_sys_aods(cst_pending) IS NULL THEN
565: insert_int_error(p_offresp_int_id, 'E625',NULL);
566: p_validation_success := 'N';
567: logdetail(p_offresp_int_id, 'E625', NULL, 'IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status)' ,NULL);

Line 567: logdetail(p_offresp_int_id, 'E625', NULL, 'IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status)' ,NULL);

563: NVL(igs_ad_gen_008.admp_get_saods(acaiv_rec.adm_offer_dfrmnt_status), cst_not_applic) = cst_not_applic THEN
564: IF igs_ad_gen_009.admp_get_sys_aods(cst_pending) IS NULL THEN
565: insert_int_error(p_offresp_int_id, 'E625',NULL);
566: p_validation_success := 'N';
567: logdetail(p_offresp_int_id, 'E625', NULL, 'IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status)' ,NULL);
568: RETURN;
569: ELSE
570: p_adm_offer_defr_status := igs_ad_gen_009.admp_get_sys_aods(cst_pending);
571: -- ADMISSION COURSE APPLICATION INSTANCE: Admission Offer Deferment Status.

Line 730: igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_accepted THEN

726:
727:
728: -- if the offer response date is elapsed then continue with other validations if p_yes_no is 'Y'. Otherwise insert error record into Interface tables.
729: IF p_calc_actual_ofr_resp_dt > acaiv_rec.offer_response_dt AND TRUNC(acaiv_rec.offer_response_dt) < TRUNC(SYSDATE) AND
730: igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_accepted THEN
731: IF p_yes_no = '2' THEN
732: insert_int_error(p_offresp_int_id, NULL,'IGS_AD_RESP_DT_PASSED');
733: p_validation_success := 'N';
734: logdetail(p_offresp_int_id, NULL, 'IGS_AD_RESP_DT_PASSED', 'validate_off_resp_dtls: IF p_calc_actual_ofr_resp_dt > acaiv_rec.offer_response_dt' ,NULL);

Line 741: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_accepted THEN

737: END IF;
738:
739:
740: --Single Response build Bug:3132406
741: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_accepted THEN
742:
743: -- Get the Application level details which are required for Single Response validation. Bug:3132406
744: igs_ad_gen_002.admp_get_aa_dtl(
745: p_person_id,

Line 1131: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(l_acaiv_rec.adm_offer_resp_status), 'NULL') = 'ACCEPTED'

1127:
1128: -- begin apadegal adtd001 igs.m
1129: BEGIN
1130:
1131: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(l_acaiv_rec.adm_offer_resp_status), 'NULL') = 'ACCEPTED'
1132: AND NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(t_adm_offer_resp_status(t_idx)), 'NULL') <> 'ACCEPTED'
1133: THEN
1134: -- UNCONFIRM the Student PROGRAM ATTEMPTS. (api would be provided by enrolments team)
1135: IF NOT IGS_EN_VAL_SCA.handle_rederive_prog_att (p_person_id => l_acaiv_rec.PERSON_ID ,

Line 1132: AND NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(t_adm_offer_resp_status(t_idx)), 'NULL') <> 'ACCEPTED'

1128: -- begin apadegal adtd001 igs.m
1129: BEGIN
1130:
1131: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(l_acaiv_rec.adm_offer_resp_status), 'NULL') = 'ACCEPTED'
1132: AND NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(t_adm_offer_resp_status(t_idx)), 'NULL') <> 'ACCEPTED'
1133: THEN
1134: -- UNCONFIRM the Student PROGRAM ATTEMPTS. (api would be provided by enrolments team)
1135: IF NOT IGS_EN_VAL_SCA.handle_rederive_prog_att (p_person_id => l_acaiv_rec.PERSON_ID ,
1136: p_admission_appl_number => l_acaiv_rec.ADMISSION_APPL_NUMBER ,

Line 1331: IF igs_ad_gen_008.admp_get_saors(t_adm_offer_resp_status(t_idx)) = 'ACCEPTED' THEN

1327: -- Else Insert proper Error message into the Error Interface table.
1328: -- Update the Current Interface Offer Response record with Status '3'.
1329:
1330: IF l_completed_flag = 'Y' THEN
1331: IF igs_ad_gen_008.admp_get_saors(t_adm_offer_resp_status(t_idx)) = 'ACCEPTED' THEN
1332: -- Now the Record is updated successfully then call the Pre Enrollment Job with Confirm_ind and Eligibility_Ind parameters as 'Y', 'Y' respectively.
1333: IF igs_ad_upd_initialise.perform_pre_enrol(
1334: l_acaiv_rec.person_id,
1335: l_acaiv_rec.admission_appl_number,