APPS.IGS_PS_STDNT_APV_ALT_PKG dependencies on IGS_PR_VAL_SCA

Line 6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_pr_val_scaae.genp_val_sdtt_sess

2: /* $Header: IGSPI65B.pls 120.2 2005/07/05 02:37:43 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_pr_val_scaae.genp_val_sdtt_sess
7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references IGS_PS_STDNT_APV_ALT%RowType;

Line 91: IF IGS_PR_VAL_SCA.prgp_val_sca_status (

87: (p_updating AND
88: new_references.rqrmnts_complete_ind <> old_references.rqrmnts_complete_ind) THEN
89: IF new_references.rqrmnts_complete_ind = 'Y' THEN
90: -- Validate that SCA Status is not 'COMPLETED' or 'UNCONFIRM'.
91: IF IGS_PR_VAL_SCA.prgp_val_sca_status (
92: new_references.person_id,
93: new_references.course_cd,
94: v_message_name) = FALSE THEN
95: Fnd_Message.Set_Name('IGS', v_message_name);

Line 100: IF IGS_PR_VAL_SCA.prgp_val_susa_cmplt (

96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98: END IF;
99: -- Validate that no IGS_PS_UNIT sets are incomplete or un-ended.
100: IF IGS_PR_VAL_SCA.prgp_val_susa_cmplt (
101: new_references.person_id,
102: new_references.course_cd,
103: v_message_name) = FALSE THEN
104: Fnd_Message.Set_Name('IGS', v_message_name);

Line 109: IF IGS_PR_VAL_SCAAE.prgp_val_sca_cmplt (

105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: -- Validate that SCA status is not DISCONTIN, INTERMIT or LAPSED.
109: IF IGS_PR_VAL_SCAAE.prgp_val_sca_cmplt (
110: new_references.person_id,
111: new_references.course_cd,
112: v_message_name) = FALSE THEN
113: Fnd_Message.Set_Name('IGS', v_message_name);

Line 120: IF IGS_PR_VAL_SCA.prgp_val_undo_cmpltn (

116: END IF;
117: ELSE
118: -- Check that associated IGS_GR_GRADUAND record does not have a status
119: -- of 'GRADUATED' or 'SURRENDER'.
120: IF IGS_PR_VAL_SCA.prgp_val_undo_cmpltn (
121: new_references.person_id,
122: new_references.course_cd,
123: new_references.version_number,
124: new_references.exit_course_cd,

Line 142: IF IGS_PR_VAL_SCAAE.prgp_val_scaae_cmplt(

138: (new_references.rqrmnts_complete_dt IS NOT NULL AND
139: old_references.rqrmnts_complete_dt IS NULL) OR
140: (new_references.rqrmnts_complete_dt IS NOT NULL AND
141: old_references.rqrmnts_complete_dt <>new_references.rqrmnts_complete_dt))) THEN
142: IF IGS_PR_VAL_SCAAE.prgp_val_scaae_cmplt(
143: new_references.rqrmnts_complete_ind,
144: new_references.rqrmnts_complete_dt,
145: v_message_name) = FALSE THEN
146: Fnd_Message.Set_Name('IGS', v_message_name);