APPS.IGS_RE_THS_PNL_MBR_PKG dependencies on IGS_RE_VAL_TPM

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

2: /* $Header: IGSRI21B.pls 120.1 2005/07/04 00:42:48 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_tpm.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_RE_THS_PNL_MBR%RowType;

Line 108: IF IGS_RE_VAL_TPM.resp_val_tpm_upd( new_references.ca_person_id,

104: ELSIF p_updating THEN
105: v_transaction_type := 'UPDATE';
106: END IF;
107: -- Validate whether insert or update is permitted.
108: IF IGS_RE_VAL_TPM.resp_val_tpm_upd( new_references.ca_person_id,
109: new_references.ca_sequence_number,
110: new_references.the_sequence_number,
111: new_references.creation_dt,
112: v_transaction_type,

Line 126: IF IGS_RE_VAL_TPM.resp_val_tpm_upd( old_references.ca_person_id,

122: App_Exception.Raise_Exception;
123: END IF;
124: ELSIF p_deleting THEN
125: -- Validate whether insert or update is permitted.
126: IF IGS_RE_VAL_TPM.resp_val_tpm_upd( old_references.ca_person_id,
127: old_references.ca_sequence_number,
128: old_references.the_sequence_number,
129: old_references.creation_dt,
130: 'DELETE',

Line 145: IF IGS_RE_VAL_TPM.resp_val_tpm_pe( new_references.ca_person_id,

141: END IF;
142: END IF;
143: IF p_inserting THEN
144: -- Validate examiner IGS_PE_PERSON ID - only on insert as pk field.
145: IF IGS_RE_VAL_TPM.resp_val_tpm_pe( new_references.ca_person_id,
146: new_references.ca_sequence_number,
147: new_references.person_id,
148: v_message_name) = FALSE THEN
149: Fnd_Message.Set_Name ('IGS', v_message_name);

Line 158: IF IGS_RE_VAL_TPM.resp_val_tpm_tpmt( new_references.panel_member_type,

154: IF p_inserting OR
155: ( p_updating AND
156: (old_references.panel_member_type <> new_references.panel_member_type)) THEN
157: -- Validate panel member type if p_inserting or changed.
158: IF IGS_RE_VAL_TPM.resp_val_tpm_tpmt( new_references.panel_member_type,
159: v_message_name) = FALSE THEN
160: Fnd_Message.Set_Name ('IGS', v_message_name);
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;

Line 169: IF IGS_RE_VAL_TPM.resp_val_tpm_thr( new_references.ca_person_id,

165: IF (p_inserting AND new_references.thesis_result_cd IS NOT NULL) OR
166: ( p_updating AND
167: (NVL(old_references.thesis_result_cd,' ') <> NVL(new_references.thesis_result_cd,' '))) THEN
168: -- Validate IGS_RE_THESIS result code on p_inserting or change.
169: IF IGS_RE_VAL_TPM.resp_val_tpm_thr( new_references.ca_person_id,
170: new_references.ca_sequence_number,
171: new_references.the_sequence_number,
172: new_references.creation_dt,
173: new_references.thesis_result_cd,

Line 189: IF IGS_RE_VAL_TPM.resp_val_tpm_dcln( new_references.declined_dt,

185: NVL(new_references.confirmed_dt,igs_ge_date.igsdate('1900/01/01')) OR
186: NVL(old_references.declined_dt,igs_ge_date.igsdate('1900/01/01')) <>
187: NVL(new_references.declined_dt,igs_ge_date.igsdate('1900/01/01')))) THEN
188: -- Validate declined date and confirmed dates.
189: IF IGS_RE_VAL_TPM.resp_val_tpm_dcln( new_references.declined_dt,
190: new_references.confirmed_dt,
191: v_message_name) = FALSE THEN
192: Fnd_Message.Set_Name ('IGS', v_message_name);
193: IGS_GE_MSG_STACK.ADD;

Line 196: IF IGS_RE_VAL_TPM.resp_val_tpm_cnfrm( new_references.confirmed_dt,

192: Fnd_Message.Set_Name ('IGS', v_message_name);
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: IF IGS_RE_VAL_TPM.resp_val_tpm_cnfrm( new_references.confirmed_dt,
197: new_references.thesis_result_cd,
198: new_references.paid_dt,
199: new_references.declined_dt,
200: v_message_name) = FALSE THEN

Line 211: IF IGS_RE_VAL_TPM.resp_val_tpm_paid( new_references.paid_dt,

207: ( p_updating AND
208: NVL(old_references.paid_dt,igs_ge_date.igsdate('1900/01/01')) <>
209: NVL(new_references.paid_dt,igs_ge_date.igsdate('1900/01/01'))) THEN
210: -- Validate the paid date.
211: IF IGS_RE_VAL_TPM.resp_val_tpm_paid( new_references.paid_dt,
212: new_references.confirmed_dt,
213: v_message_name ) = FALSE THEN
214: Fnd_Message.Set_Name ('IGS', v_message_name);
215: IGS_GE_MSG_STACK.ADD;