APPS.IGS_RE_THE_LGCY_PUB dependencies on IGS_RE_VAL_THE

Line 145: IF NOT igs_re_val_the.check_dup_thesis (

141: l_ret_status VARCHAR2(1) := 'S';
142: BEGIN
143:
144: --check for duplicate record in the Thesis table
145: IF NOT igs_re_val_the.check_dup_thesis (
146: p_person_id ,
147: p_the_dtls_rec.title,
148: p_ca_sequence_number) THEN
149: FND_MESSAGE.SET_NAME('IGS','IGS_RE_THE_DUPLIDATE');

Line 191: l_dummy_bool := igs_re_val_the.resp_val_the_expct (

187:
188: --IF Expected Submission Date < Minimum Submission Date OR Expected Submission Date > Maximum Submission Date
189: --then error will be logged.
190: l_message := NULL;
191: l_dummy_bool := igs_re_val_the.resp_val_the_expct (
192: p_person_id ,
193: p_ca_sequence_number,
194: p_the_dtls_rec.expected_submission_dt,
195: 'Y',

Line 217: l_dummy_bool := igs_re_val_the.resp_val_the_embrg(

213:
214: l_message := NULL;
215: -- Embargo details or Embargo Expiry date cannot have value unless the thesis has been SUBMITTED or EXAMINED
216: -- If Embargo Expiration Date is available without Embargo Details then log error message.
217: l_dummy_bool := igs_re_val_the.resp_val_the_embrg(
218: p_the_dtls_rec.embargo_details,
219: NULL,
220: p_the_dtls_rec.embargo_expiry_dt,
221: l_thesis_status,

Line 234: l_dummy_bool := igs_re_val_the.resp_val_the_fnl(

230:
231: l_message := NULL;
232: --If final title indicator has not been set and thesis status is either SUBMITTED or EXAMINED
233: --then log error message
234: l_dummy_bool := igs_re_val_the.resp_val_the_fnl(
235: p_person_id,
236: p_ca_sequence_number,
237: NULL,
238: p_the_dtls_rec.final_title_ind,

Line 249: l_dummy_bool := igs_re_val_the.resp_val_the_thr(

245: END IF;
246:
247: l_message := NULL;
248: -- If final result indicator is not set then log error message
249: l_dummy_bool := igs_re_val_the.resp_val_the_thr(
250: p_person_id,
251: p_ca_sequence_number ,
252: NULL,
253: p_the_dtls_rec.final_thesis_result_cd,

Line 274: l_dummy_bool := igs_re_val_the.resp_val_the_ctn(

270: ELSE
271:
272: l_message := NULL;
273: -- If citation Details are available then log error message, since thesis status is not SUBMITTED or EXAMINED
274: l_dummy_bool := igs_re_val_the.resp_val_the_ctn(
275: l_thesis_status,
276: p_the_dtls_rec.citation,
277: l_message);
278: IF l_message IS NOT NULL THEN

Line 288: l_dummy_bool := igs_re_val_the.resp_val_the_lbry(

284:
285: l_message := NULL;
286: -- If library catalog number or library lodgement date is available then log error message, since thesis status
287: -- is not SUBMITTED or EXAMINED
288: l_dummy_bool := igs_re_val_the.resp_val_the_lbry(
289: p_person_id,
290: p_ca_sequence_number,
291: NULL,
292: p_the_dtls_rec.library_catalogue_number,

Line 306: l_dummy_bool := igs_re_val_the.resp_val_the_thr(

302:
303: l_message := NULL;
304: --If thesis result code is available and thesis status is PENDING then log error message
305: --If final result indicator is not set then log error message
306: l_dummy_bool := igs_re_val_the.resp_val_the_thr(
307: p_person_id,
308: p_ca_sequence_number ,
309: NULL,
310: p_the_dtls_rec.final_thesis_result_cd,

Line 513: IF NOT igs_re_val_the.get_candidacy_dtls(

509: l_the_exam_status := 'INVALID';
510: END IF;
511:
512: -- Calling the function to get the value for ca_sequence_number
513: IF NOT igs_re_val_the.get_candidacy_dtls(
514: l_person_id,
515: p_the_dtls_rec.program_cd,
516: l_ca_sequence_number) THEN
517: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_CANT_LOCATE_CAND_DET');