DBA Data[Home] [Help]

APPS.IGS_EN_DROP_UNITS_API dependencies on IGS_EN_SU_ATTEMPT_PKG

Line 1599: igs_en_su_attempt_pkg.pkg_source_of_drop := 'DROP';

1595: p_message := NULL;
1596:
1597: -- smaddali 8-dec-2005 added this global variable to bypass update spa,
1598: -- matriculation and reserved seat counts for DROP : bug#4864437
1599: igs_en_su_attempt_pkg.pkg_source_of_drop := 'DROP';
1600:
1601:
1602: -- This loop drop the units passed and in that process collects
1603: -- all the uooids that are failing (prereq/coreq in deny mode) because of dropping

Line 1635: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1631: p_message,
1632: l_return_status);
1633:
1634: IF l_return_status = 'E' AND p_message IS NOT NULL THEN
1635: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1636: p_return_status := 'E';
1637: igs_en_add_units_api.g_ss_session_id := NULL;
1638: RETURN;
1639: END IF;

Line 1655: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1651: l_return_status := NULL;
1652: l_uooids_dropped := NULL;
1653:
1654: END LOOP;
1655: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1656: igs_en_add_units_api.g_ss_session_id := NULL;
1657:
1658: EXCEPTION
1659: WHEN NO_AUSL_RECORD_FOUND THEN

Line 1660: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1656: igs_en_add_units_api.g_ss_session_id := NULL;
1657:
1658: EXCEPTION
1659: WHEN NO_AUSL_RECORD_FOUND THEN
1660: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1661: igs_en_add_units_api.g_ss_session_id := NULL;
1662: p_message := 'IGS_SS_CANTDET_ADM_UNT_STATUS';
1663: p_return_status := 'E';
1664: RETURN;

Line 1667: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1663: p_return_status := 'E';
1664: RETURN;
1665:
1666: WHEN resource_busy THEN
1667: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1668: igs_en_add_units_api.g_ss_session_id := NULL;
1669: p_message := 'IGS_GE_RECORD_LOCKED';
1670: p_return_status := 'E';
1671: RETURN;

Line 1674: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1670: p_return_status := 'E';
1671: RETURN;
1672:
1673: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1674: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1675: igs_en_add_units_api.g_ss_session_id := NULL;
1676: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
1677: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
1678: l_token := FND_MESSAGE.GET_TOKEN('LIST',NULL);

Line 1687: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1683: p_message := l_message_name;
1684: RETURN;
1685:
1686: WHEN OTHERS THEN
1687: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1688: igs_en_add_units_api.g_ss_session_id := NULL;
1689: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1690: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_ss_unit_attempt');
1691: IGS_GE_MSG_STACK.ADD;

Line 1757: igs_En_su_Attempt_pkg.update_row( X_ROWID => upd_units_rec.row_id ,

1753: l_admin_unit_status := p_admin_unit_status;
1754: END IF;
1755:
1756: -- Call update_row of the student unit attempt table handler i.e
1757: igs_En_su_Attempt_pkg.update_row( X_ROWID => upd_units_rec.row_id ,
1758: X_PERSON_ID => upd_units_rec.person_id ,
1759: X_COURSE_CD => upd_units_rec.course_cd ,
1760: X_UNIT_CD => upd_units_rec.unit_cd ,
1761: X_CAL_TYPE => upd_units_rec.cal_type ,