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_ADMAPPLICATION_PUB dependencies on IGS_AD_GEN_008

Line 606: l_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(l_adm_outcome_status);

602: RAISE FND_API.G_EXC_ERROR;
603: ELSE
604: l_adm_outcome_status := p_adm_outcome_status;
605: END IF;
606: l_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(l_adm_outcome_status);
607:
608: IF p_decision_maker_id = FND_API.G_MISS_NUM THEN
609: l_decision_make_id := null;
610: ELSE

Line 853: IF NVL(igs_ad_gen_008.admp_get_saos(l_adm_outcome_status), 'NONE') IN

849: END IF;
850:
851: l_actual_response_dt := l_c_aplinst_cur.actual_response_dt;
852:
853: IF NVL(igs_ad_gen_008.admp_get_saos(l_adm_outcome_status), 'NONE') IN
854: ('OFFER', 'COND-OFFER') THEN
855: IF l_prpsd_commencement_date IS NULL THEN
856: -- Default the proposed commencement date.
857: l_prpsd_commencement_date := igs_en_gen_002.enrp_get_acad_comm(l_c_appl_cur.acad_cal_type,

Line 960: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(l_adm_outcome_status),'NULL') <> NVL(IGS_AD_GEN_008.ADMP_GET_SAOS (l_c_aplinst_cur.Adm_outcome_status ),'NULL')

956: FETCH c_ps_appl_cur INTO l_c_ps_appl_cur;
957: CLOSE c_ps_appl_cur;
958:
959: IF NVL(l_c_ps_appl_cur.req_for_reconsideration_ind,'N') = 'Y' AND
960: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(l_adm_outcome_status),'NULL') <> NVL(IGS_AD_GEN_008.ADMP_GET_SAOS (l_c_aplinst_cur.Adm_outcome_status ),'NULL')
961: THEN
962:
963: igs_ad_ps_appl_pkg.update_row(x_rowid => l_c_ps_appl_cur.row_id,
964: x_person_id => l_c_ps_appl_cur.person_id,

Line 1177: IF NVL(igs_ad_gen_008.admp_get_saors(l_adm_offer_resp_status), 'NULL') =

1173: OPEN c_adm_ofr_resp_stat_cur;
1174: FETCH c_adm_ofr_resp_stat_cur
1175: INTO l_adm_offer_resp_status;
1176: CLOSE c_adm_ofr_resp_stat_cur;
1177: IF NVL(igs_ad_gen_008.admp_get_saors(l_adm_offer_resp_status), 'NULL') =
1178: 'ACCEPTED' THEN
1179: IF igs_ad_upd_initialise.perform_pre_enrol(p_person_id,
1180: p_admission_appl_number,
1181: p_nominated_program_cd,

Line 1195: NVL(igs_ad_gen_008.admp_get_saos(l_adm_outcome_status), 'NULL') IN

1191: -- if we need to run the pre enrollment process for this application,
1192: -- we need to check the apc step and run the pre enrollment process
1193: -- for a course that has been offered on this update.
1194: ELSIF l_pre_enroll = 'Y' AND
1195: NVL(igs_ad_gen_008.admp_get_saos(l_adm_outcome_status), 'NULL') IN
1196: ('OFFER', 'COND-OFFER') AND
1197: NVL(igs_ad_gen_008.admp_get_saos(l_adm_outcome_status), 'NULL') <>
1198: NVL(igs_ad_gen_008.admp_get_saos(l_c_aplinst_cur.adm_outcome_status),
1199: 'NULL') THEN

Line 1197: NVL(igs_ad_gen_008.admp_get_saos(l_adm_outcome_status), 'NULL') <>

1193: -- for a course that has been offered on this update.
1194: ELSIF l_pre_enroll = 'Y' AND
1195: NVL(igs_ad_gen_008.admp_get_saos(l_adm_outcome_status), 'NULL') IN
1196: ('OFFER', 'COND-OFFER') AND
1197: NVL(igs_ad_gen_008.admp_get_saos(l_adm_outcome_status), 'NULL') <>
1198: NVL(igs_ad_gen_008.admp_get_saos(l_c_aplinst_cur.adm_outcome_status),
1199: 'NULL') THEN
1200:
1201: IF igs_ad_upd_initialise.perform_pre_enrol(p_person_id,

Line 1198: NVL(igs_ad_gen_008.admp_get_saos(l_c_aplinst_cur.adm_outcome_status),

1194: ELSIF l_pre_enroll = 'Y' AND
1195: NVL(igs_ad_gen_008.admp_get_saos(l_adm_outcome_status), 'NULL') IN
1196: ('OFFER', 'COND-OFFER') AND
1197: NVL(igs_ad_gen_008.admp_get_saos(l_adm_outcome_status), 'NULL') <>
1198: NVL(igs_ad_gen_008.admp_get_saos(l_c_aplinst_cur.adm_outcome_status),
1199: 'NULL') THEN
1200:
1201: IF igs_ad_upd_initialise.perform_pre_enrol(p_person_id,
1202: p_admission_appl_number,

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

1419: */
1420: -- end apadegal adtd001 igs.m
1421:
1422: --Check if the New Offer Response Status is a valid Offer Response Status mapped to one of the System Offer Response Statuses.
1423: -- IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) IS NULL THEN
1424: IF NOT IGS_AD_OFR_RESP_STAT_PKG.Get_PK_For_Validation(p_adm_offer_resp_status,'N') THEN
1425: p_validation_success := 'N';
1426: fnd_message.set_name('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
1427: fnd_message.set_token('ATTRIBUTE', FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_RESP_STATUS'));

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

1429: RETURN;
1430: END IF;
1431: --Validations on the Application Instance Outcome Status. Check if the Applicant's Outcome Status is mapped to one of the System Outcome Status of
1432: --'Make Offer of Admission' (OFFER) or 'Make Offer of Admission Subject to Condition' (COND-OFFER).
1433: IF NVL(igs_ad_gen_008.admp_get_saos(l_acaiv_rec.adm_outcome_status), 'NULL') NOT IN (cst_offer, cst_cond_offer) THEN
1434: p_validation_success := 'N';
1435: fnd_message.set_name('IGS', 'IGS_AD_OFRST_NOTACCEPTED');
1436: IGS_GE_MSG_STACK.ADD;
1437: RETURN;

Line 1455: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_pending AND igs_ad_gen_008.admp_get_saors(l_acaiv_rec.adm_offer_resp_status) = cst_accepted THEN

1451:
1452: /* Following validations are not needed now as Offer response is
1453: -- Check if the Interface Offer Response Status is allowed to update the existing offer response in production table.
1454: -- IF Interface Offer Response Status is 'PENDING' and the corresponding status in production table is 'ACCEPTED' Then
1455: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_pending AND igs_ad_gen_008.admp_get_saors(l_acaiv_rec.adm_offer_resp_status) = cst_accepted THEN
1456: p_validation_success := 'N';
1457: fnd_message.set_name('IGS', 'IGS_AD_ADMOFR_ALREADY_RESPOND');
1458: IGS_GE_MSG_STACK.ADD;
1459: RETURN;

Line 1462: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_pending AND igs_ad_gen_008.admp_get_saors(l_acaiv_rec.adm_offer_resp_status) = cst_rejected THEN

1458: IGS_GE_MSG_STACK.ADD;
1459: RETURN;
1460: END IF;
1461: -- IF Interface Offer Response Status is PENDING and the corresponding status in production table is REJECTED Then
1462: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_pending AND igs_ad_gen_008.admp_get_saors(l_acaiv_rec.adm_offer_resp_status) = cst_rejected THEN
1463: p_validation_success := 'N';
1464: fnd_message.set_name('IGS', 'IGS_AD_ADMOFR_ALREADY_REJECT');
1465: IGS_GE_MSG_STACK.ADD;
1466: RETURN;

Line 1469: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_accepted AND igs_ad_gen_008.admp_get_saors(l_acaiv_rec.adm_offer_resp_status) = cst_rejected THEN

1465: IGS_GE_MSG_STACK.ADD;
1466: RETURN;
1467: END IF;
1468: -- IF Interface Offer Response Status is 'ACCEPTED' and the corresponding status in production table is 'REJECTED' Then
1469: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_accepted AND igs_ad_gen_008.admp_get_saors(l_acaiv_rec.adm_offer_resp_status) = cst_rejected THEN
1470: p_validation_success := 'N';
1471: fnd_message.set_name('IGS', 'IGS_AD_ADMOFR_ALREADY_REJECT');
1472: IGS_GE_MSG_STACK.ADD;
1473: RETURN;

Line 1476: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_deferral AND igs_ad_gen_008.admp_get_saors(l_acaiv_rec.adm_offer_resp_status) = cst_rejected THEN

1472: IGS_GE_MSG_STACK.ADD;
1473: RETURN;
1474: END IF;
1475: -- IF Interface Offer Response Status is 'DEFERRAL' and the corresponding status in production table is 'REJECTED' Then
1476: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_deferral AND igs_ad_gen_008.admp_get_saors(l_acaiv_rec.adm_offer_resp_status) = cst_rejected THEN
1477: p_validation_success := 'N';
1478: fnd_message.set_name('IGS', 'IGS_AD_ADMOFR_ALREADY_REJECT');
1479: IGS_GE_MSG_STACK.ADD;
1480: RETURN;

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

1495: -- end apadegal adtd001 igs.m
1496:
1497:
1498: -- If Offer Response is changed to PENDING from DEFERRAL, then the Deffered Calendars should be NULL otherswise insert error record into corresponding table
1499: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) <> cst_pending AND igs_ad_gen_008.admp_get_saors(l_acaiv_rec.adm_offer_resp_status) = cst_deferral THEN
1500: IF p_def_acad_cal_type IS NOT NULL OR p_def_acad_ci_sequence_number IS NOT NULL THEN
1501: p_validation_success := 'N';
1502: fnd_message.set_name('IGS', 'IDS_AD_DEFER_TO_PENDING');
1503: IGS_GE_MSG_STACK.ADD;

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

1517: -- and populate this variable accordingly after necessary validations
1518: p_calc_actual_ofr_resp_dt := p_actual_offer_response_dt;
1519:
1520: -- Check if parameter Offer Response Status is Other than 'PENDING', 'LAPSED', 'NOT-APPLIC'.
1521: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) NOT IN (cst_pending, cst_lapsed, cst_not_applic) THEN
1522: IF p_calc_actual_ofr_resp_dt IS NULL THEN
1523: p_calc_actual_ofr_resp_dt := SYSDATE;
1524: END IF;
1525: END IF;

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

1568: -- with either of the values 'PENDING' or 'NOT-APPLIC' depending on the value of Offer Response Status.
1569: -- Default the Offer Deferment Status, depending on the value of Offer Response Status, and validate the same.
1570: -- IF Offer Response Status is 'DEFERRAL', then default the Offer Deferment Status to 'PENDING'.
1571: -- ELSE Offer Response Status is not equal to 'DEFERRAL', then Default the Offer Deferment Status to 'NOT-APPLIC'.
1572: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_deferral AND
1573: NVL(igs_ad_gen_008.admp_get_saods(l_acaiv_rec.adm_offer_dfrmnt_status), cst_not_applic) = cst_not_applic THEN
1574: IF igs_ad_gen_009.admp_get_sys_aods(cst_pending) IS NULL AND p_adm_offer_defr_status IS NULL THEN
1575: p_validation_success := 'N';
1576: fnd_message.set_name('IGS', 'IGS_AD_DEFR_STATUS_PEND_NOMAP');

Line 1573: NVL(igs_ad_gen_008.admp_get_saods(l_acaiv_rec.adm_offer_dfrmnt_status), cst_not_applic) = cst_not_applic THEN

1569: -- Default the Offer Deferment Status, depending on the value of Offer Response Status, and validate the same.
1570: -- IF Offer Response Status is 'DEFERRAL', then default the Offer Deferment Status to 'PENDING'.
1571: -- ELSE Offer Response Status is not equal to 'DEFERRAL', then Default the Offer Deferment Status to 'NOT-APPLIC'.
1572: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_deferral AND
1573: NVL(igs_ad_gen_008.admp_get_saods(l_acaiv_rec.adm_offer_dfrmnt_status), cst_not_applic) = cst_not_applic THEN
1574: IF igs_ad_gen_009.admp_get_sys_aods(cst_pending) IS NULL AND p_adm_offer_defr_status IS NULL THEN
1575: p_validation_success := 'N';
1576: fnd_message.set_name('IGS', 'IGS_AD_DEFR_STATUS_PEND_NOMAP');
1577: IGS_GE_MSG_STACK.ADD;

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

1625:
1626: /* Commeting this code to enable the Offer Response after offer response Deadline
1627: -- if the offer response date is elapsed then continue with other validations Otherwise raise the error.
1628: IF p_calc_actual_ofr_resp_dt > l_acaiv_rec.offer_response_dt AND TRUNC(l_acaiv_rec.offer_response_dt) < TRUNC(SYSDATE) AND
1629: igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_accepted THEN
1630: p_validation_success := 'N';
1631: fnd_message.set_name('IGS', 'IGS_AD_RESP_DT_PASSED');
1632: IGS_GE_MSG_STACK.ADD;
1633: RETURN;

Line 1660: 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

1656:
1657: --------------------------------------------------------------------------------
1658: -- Start of Validations intoduced as part of ADSS Build For Respond To Offer Page
1659: --------------------------------------------------------------------------------
1660: 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
1661: p_validation_success := 'N';
1662: fnd_message.set_name('IGS','IGS_AD_ADMOFR_WITH_REAS');
1663: IGS_GE_MSG_STACK.ADD;
1664: RETURN;

Line 1873: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(cur_ad_ps_appl_inst_rec.adm_offer_resp_status), 'NULL') = 'ACCEPTED'

1869:
1870: IF l_validation_success = 'Y' THEN
1871:
1872:
1873: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(cur_ad_ps_appl_inst_rec.adm_offer_resp_status), 'NULL') = 'ACCEPTED'
1874: AND NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status), 'NULL') <> 'ACCEPTED'
1875: THEN
1876: -- UNCONFIRM the Student PROGRAM ATTEMPTS. (api would be provided by enrolments team)
1877: IF NOT IGS_EN_VAL_SCA.handle_rederive_prog_att (p_person_id => cur_ad_ps_appl_inst_rec.PERSON_ID ,

Line 1874: AND NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status), 'NULL') <> 'ACCEPTED'

1870: IF l_validation_success = 'Y' THEN
1871:
1872:
1873: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(cur_ad_ps_appl_inst_rec.adm_offer_resp_status), 'NULL') = 'ACCEPTED'
1874: AND NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status), 'NULL') <> 'ACCEPTED'
1875: THEN
1876: -- UNCONFIRM the Student PROGRAM ATTEMPTS. (api would be provided by enrolments team)
1877: IF NOT IGS_EN_VAL_SCA.handle_rederive_prog_att (p_person_id => cur_ad_ps_appl_inst_rec.PERSON_ID ,
1878: p_admission_appl_number => cur_ad_ps_appl_inst_rec.ADMISSION_APPL_NUMBER ,

Line 2028: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status), 'NULL') = 'ACCEPTED' THEN

2024: X_APPL_INST_STATUS => cur_ad_ps_appl_inst_rec.appl_inst_status,
2025: x_ais_reason => cur_ad_ps_appl_inst_rec.ais_reason
2026: );
2027:
2028: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status), 'NULL') = 'ACCEPTED' THEN
2029: IF igs_ad_upd_initialise.perform_pre_enrol(cur_ad_ps_appl_inst_rec.Person_Id,
2030: cur_ad_ps_appl_inst_rec.Admission_Appl_Number,
2031: cur_ad_ps_appl_inst_rec.Nominated_Course_Cd,
2032: cur_ad_ps_appl_inst_rec.Sequence_Number,