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_AD_VAL_AA dependencies on IGS_AD_APPL

Line 5: -- Validate delete of an IGS_AD_APPL record.

1: PACKAGE BODY IGS_AD_VAL_AA AS
2: /* $Header: IGSAD76B.pls 120.0 2005/06/01 22:17:58 appldev noship $ */
3:
4: --
5: -- Validate delete of an IGS_AD_APPL record.
6: FUNCTION admp_val_aa_delete(
7: p_adm_appl_status IN VARCHAR2 ,
8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN AS

Line 11: -- Validate delete of an IGS_AD_APPL record.

7: p_adm_appl_status IN VARCHAR2 ,
8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN AS
10: BEGIN -- admp_val_aa_delete
11: -- Validate delete of an IGS_AD_APPL record.
12: DECLARE
13: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
14: BEGIN
15: -- Set the default message number

Line 13: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

9: RETURN BOOLEAN AS
10: BEGIN -- admp_val_aa_delete
11: -- Validate delete of an IGS_AD_APPL record.
12: DECLARE
13: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
14: BEGIN
15: -- Set the default message number
16: p_message_name := null;
17: -- Get the system admission application status.

Line 34: -- Validate insert of an IGS_AD_APPL record.

30: IGS_GE_MSG_STACK.ADD;
31: App_Exception.Raise_Exception;
32: END admp_val_aa_delete;
33: --
34: -- Validate insert of an IGS_AD_APPL record.
35: FUNCTION admp_val_aa_insert(
36: p_person_id IN NUMBER ,
37: p_adm_cal_type IN VARCHAR2 ,
38: p_adm_ci_sequence_number IN NUMBER ,

Line 49: -- Validate insert of an IGS_AD_APPL record.

45: p_return_type OUT NOCOPY VARCHAR2 )
46: RETURN BOOLEAN AS
47: BEGIN
48: -- admp_val_aa_insert
49: -- Validate insert of an IGS_AD_APPL record.
50: -- * If the admission process type is short admission, the short admission
51: -- date alias for the admission period must be set.
52: -- * If the admission process type is short admission, the short admission
53: -- date must be greater than the current date.

Line 173: -- Validate update of an IGS_AD_APPL record.

169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END admp_val_aa_insert;
172: --
173: -- Validate update of an IGS_AD_APPL record.
174: FUNCTION admp_val_aa_update(
175: p_adm_appl_status IN VARCHAR2 ,
176: p_message_name OUT NOCOPY VARCHAR2 )
177: RETURN BOOLEAN AS

Line 179: -- Validate update of an IGS_AD_APPL record.

175: p_adm_appl_status IN VARCHAR2 ,
176: p_message_name OUT NOCOPY VARCHAR2 )
177: RETURN BOOLEAN AS
178: BEGIN -- admp_val_aa_update
179: -- Validate update of an IGS_AD_APPL record.
180: DECLARE
181: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
182: BEGIN
183: -- Set the default message number

Line 181: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

177: RETURN BOOLEAN AS
178: BEGIN -- admp_val_aa_update
179: -- Validate update of an IGS_AD_APPL record.
180: DECLARE
181: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
182: BEGIN
183: -- Set the default message number
184: p_message_name := null;
185: -- Get the system admission application status.

Line 202: -- Validate the IGS_AD_APPL.appl_dt.

198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END admp_val_aa_update;
201: --
202: -- Validate the IGS_AD_APPL.appl_dt.
203: FUNCTION admp_val_aa_appl_dt(
204: p_appl_dt IN DATE ,
205: p_message_name OUT NOCOPY VARCHAR2 )
206: RETURN BOOLEAN AS

Line 208: -- Validate the IGS_AD_APPL.appl_dt.

204: p_appl_dt IN DATE ,
205: p_message_name OUT NOCOPY VARCHAR2 )
206: RETURN BOOLEAN AS
207: BEGIN
208: -- Validate the IGS_AD_APPL.appl_dt.
209: -- Validations are -
210: -- IGS_AD_APPL.appl_dt must be less than or equal to
211: -- the current date.
212: IF (TRUNC(p_appl_dt) > TRUNC(SYSDATE)) THEN

Line 210: -- IGS_AD_APPL.appl_dt must be less than or equal to

206: RETURN BOOLEAN AS
207: BEGIN
208: -- Validate the IGS_AD_APPL.appl_dt.
209: -- Validations are -
210: -- IGS_AD_APPL.appl_dt must be less than or equal to
211: -- the current date.
212: IF (TRUNC(p_appl_dt) > TRUNC(SYSDATE)) THEN
213: p_message_name := 'IGS_AD_APPLDT_LE_CURRENT_DT';
214: RETURN FALSE;

Line 213: p_message_name := 'IGS_AD_APPLDT_LE_CURRENT_DT';

209: -- Validations are -
210: -- IGS_AD_APPL.appl_dt must be less than or equal to
211: -- the current date.
212: IF (TRUNC(p_appl_dt) > TRUNC(SYSDATE)) THEN
213: p_message_name := 'IGS_AD_APPLDT_LE_CURRENT_DT';
214: RETURN FALSE;
215: END IF;
216: p_message_name := null;
217: RETURN TRUE;

Line 234: -- (IGS_AD_APPL.acad_cal_type, IGS_AD_APPL.acad_ci_sequence_number).

230: p_message_name OUT NOCOPY VARCHAR2 )
231: RETURN BOOLEAN AS
232: BEGIN -- admp_val_aa_acad_cal
233: -- Validate the admission application commencement period
234: -- (IGS_AD_APPL.acad_cal_type, IGS_AD_APPL.acad_ci_sequence_number).
235: -- Validations are -
236: -- ? IGS_AD_APPL.acad_cal_type must be an Academic calendar.
237: -- ? IGS_AD_APPL.acad_cal_type and IGS_AD_APPL.acad_ci_sequence_number
238: -- must be an Active calendar instance.

Line 236: -- ? IGS_AD_APPL.acad_cal_type must be an Academic calendar.

232: BEGIN -- admp_val_aa_acad_cal
233: -- Validate the admission application commencement period
234: -- (IGS_AD_APPL.acad_cal_type, IGS_AD_APPL.acad_ci_sequence_number).
235: -- Validations are -
236: -- ? IGS_AD_APPL.acad_cal_type must be an Academic calendar.
237: -- ? IGS_AD_APPL.acad_cal_type and IGS_AD_APPL.acad_ci_sequence_number
238: -- must be an Active calendar instance.
239: DECLARE
240: CURSOR c_ct (

Line 237: -- ? IGS_AD_APPL.acad_cal_type and IGS_AD_APPL.acad_ci_sequence_number

233: -- Validate the admission application commencement period
234: -- (IGS_AD_APPL.acad_cal_type, IGS_AD_APPL.acad_ci_sequence_number).
235: -- Validations are -
236: -- ? IGS_AD_APPL.acad_cal_type must be an Academic calendar.
237: -- ? IGS_AD_APPL.acad_cal_type and IGS_AD_APPL.acad_ci_sequence_number
238: -- must be an Active calendar instance.
239: DECLARE
240: CURSOR c_ct (
241: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE) IS

Line 241: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE) IS

237: -- ? IGS_AD_APPL.acad_cal_type and IGS_AD_APPL.acad_ci_sequence_number
238: -- must be an Active calendar instance.
239: DECLARE
240: CURSOR c_ct (
241: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE) IS
242: SELECT s_cal_cat
243: FROM IGS_CA_TYPE
244: WHERE cal_type = cp_acad_cal_type;
245: CURSOR c_ci_cs (

Line 246: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,

242: SELECT s_cal_cat
243: FROM IGS_CA_TYPE
244: WHERE cal_type = cp_acad_cal_type;
245: CURSOR c_ci_cs (
246: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
247: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
248: SELECT cs.s_cal_status
249: FROM IGS_CA_STAT cs,
250: IGS_CA_INST ci

Line 247: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS

243: FROM IGS_CA_TYPE
244: WHERE cal_type = cp_acad_cal_type;
245: CURSOR c_ci_cs (
246: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
247: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
248: SELECT cs.s_cal_status
249: FROM IGS_CA_STAT cs,
250: IGS_CA_INST ci
251: WHERE ci.cal_type = cp_acad_cal_type AND

Line 360: -- (IGS_AD_APPL.adm_cal_type,

356: apapc.closed_ind = 'N'; --added the closed indicator for bug# 2380108 (rghosh)
357: v_s_cal_status c_cal_instance%ROWTYPE;
358: BEGIN
359: -- Validate the admission application admission calendar
360: -- (IGS_AD_APPL.adm_cal_type,
361: -- IGS_AD_APPL.adm_ci_sequence_number).
362: -- Validations are -
363: -- IGS_AD_APPL.acad_cal_type must be an Admission calendar.
364: -- IGS_AD_APPL.adm_cal_type and IGS_AD_APPL.adm_ci_sequence_number

Line 361: -- IGS_AD_APPL.adm_ci_sequence_number).

357: v_s_cal_status c_cal_instance%ROWTYPE;
358: BEGIN
359: -- Validate the admission application admission calendar
360: -- (IGS_AD_APPL.adm_cal_type,
361: -- IGS_AD_APPL.adm_ci_sequence_number).
362: -- Validations are -
363: -- IGS_AD_APPL.acad_cal_type must be an Admission calendar.
364: -- IGS_AD_APPL.adm_cal_type and IGS_AD_APPL.adm_ci_sequence_number
365: -- must be

Line 363: -- IGS_AD_APPL.acad_cal_type must be an Admission calendar.

359: -- Validate the admission application admission calendar
360: -- (IGS_AD_APPL.adm_cal_type,
361: -- IGS_AD_APPL.adm_ci_sequence_number).
362: -- Validations are -
363: -- IGS_AD_APPL.acad_cal_type must be an Admission calendar.
364: -- IGS_AD_APPL.adm_cal_type and IGS_AD_APPL.adm_ci_sequence_number
365: -- must be
366: -- an Active calendar instance.
367: -- The Admission Calendar must be a child of the Academic Calendar.

Line 364: -- IGS_AD_APPL.adm_cal_type and IGS_AD_APPL.adm_ci_sequence_number

360: -- (IGS_AD_APPL.adm_cal_type,
361: -- IGS_AD_APPL.adm_ci_sequence_number).
362: -- Validations are -
363: -- IGS_AD_APPL.acad_cal_type must be an Admission calendar.
364: -- IGS_AD_APPL.adm_cal_type and IGS_AD_APPL.adm_ci_sequence_number
365: -- must be
366: -- an Active calendar instance.
367: -- The Admission Calendar must be a child of the Academic Calendar.
368: -- This validation is enforced in the database via the foreign key AA_CIR_FK.

Line 436: -- Validate the IGS_AD_APPL.admission_cat.

432: IGS_GE_MSG_STACK.ADD;
433: App_Exception.Raise_Exception;
434: END admp_val_aa_adm_cal;
435: --
436: -- Validate the IGS_AD_APPL.admission_cat.
437: FUNCTION admp_val_aa_adm_cat(
438: p_admission_cat IN VARCHAR2 ,
439: p_message_name OUT NOCOPY VARCHAR2 )
440: RETURN BOOLEAN AS

Line 472: -- Validate the IGS_AD_APPL.admission_cat.

468: WHERE fcm.admission_cat = p_admission_cat AND
469: fcm.dflt_cat_ind = 'Y'
470: GROUP BY fcm.admission_cat;
471: BEGIN
472: -- Validate the IGS_AD_APPL.admission_cat.
473: -- Validations are:
474: -- IGS_AD_APPL.admission_cat must not be closed.
475: -- IGS_AD_APPL.admission_cat must have one and only
476: -- one default IGS_CO_CAT_MAP record.

Line 474: -- IGS_AD_APPL.admission_cat must not be closed.

470: GROUP BY fcm.admission_cat;
471: BEGIN
472: -- Validate the IGS_AD_APPL.admission_cat.
473: -- Validations are:
474: -- IGS_AD_APPL.admission_cat must not be closed.
475: -- IGS_AD_APPL.admission_cat must have one and only
476: -- one default IGS_CO_CAT_MAP record.
477: -- IGS_AD_APPL.admission_cat must have one and only
478: -- one default IGS_EN_CAT_MAPPING record.

Line 475: -- IGS_AD_APPL.admission_cat must have one and only

471: BEGIN
472: -- Validate the IGS_AD_APPL.admission_cat.
473: -- Validations are:
474: -- IGS_AD_APPL.admission_cat must not be closed.
475: -- IGS_AD_APPL.admission_cat must have one and only
476: -- one default IGS_CO_CAT_MAP record.
477: -- IGS_AD_APPL.admission_cat must have one and only
478: -- one default IGS_EN_CAT_MAPPING record.
479: -- IGS_AD_APPL.admission_cat must have one and only

Line 477: -- IGS_AD_APPL.admission_cat must have one and only

473: -- Validations are:
474: -- IGS_AD_APPL.admission_cat must not be closed.
475: -- IGS_AD_APPL.admission_cat must have one and only
476: -- one default IGS_CO_CAT_MAP record.
477: -- IGS_AD_APPL.admission_cat must have one and only
478: -- one default IGS_EN_CAT_MAPPING record.
479: -- IGS_AD_APPL.admission_cat must have one and only
480: -- one default IGS_FI_FEE_CAT_MAP record.
481: OPEN c_ac;

Line 479: -- IGS_AD_APPL.admission_cat must have one and only

475: -- IGS_AD_APPL.admission_cat must have one and only
476: -- one default IGS_CO_CAT_MAP record.
477: -- IGS_AD_APPL.admission_cat must have one and only
478: -- one default IGS_EN_CAT_MAPPING record.
479: -- IGS_AD_APPL.admission_cat must have one and only
480: -- one default IGS_FI_FEE_CAT_MAP record.
481: OPEN c_ac;
482: FETCH c_ac INTO v_closed_ind;
483: IF (c_ac%FOUND) THEN

Line 547: -- Validate the IGS_AD_APPL.adm_appl_status.

543: App_Exception.Raise_Exception;
544: END;
545: END admp_val_aa_adm_cat;
546: --
547: -- Validate the IGS_AD_APPL.adm_appl_status.
548: FUNCTION admp_val_aa_aas(
549: p_person_id IN NUMBER ,
550: p_admission_appl_number IN NUMBER ,
551: p_adm_appl_status IN VARCHAR2 ,

Line 555: -- Validate the IGS_AD_APPL.adm_appl_status. Validations are -

551: p_adm_appl_status IN VARCHAR2 ,
552: p_message_name OUT NOCOPY VARCHAR2 )
553: RETURN BOOLEAN AS
554: BEGIN -- admp_val_aa_aas
555: -- Validate the IGS_AD_APPL.adm_appl_status. Validations are -
556: -- * The admission application status must be open. (AAS01)
557: -- * If the admission application status has a system value of
558: -- received, then it must equal the derived value. (AAS02)
559: -- * If the admission application status has a system value of

Line 587: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

583: cst_rejected CONSTANT VARCHAR2(10) := 'REJECTED';
584: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
585: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
586: v_message_name VARCHAR2(30);
587: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
588: v_derived_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
589: v_exit_loop BOOLEAN DEFAULT FALSE;
590: BEGIN
591: -- Set the default message number

Line 588: v_derived_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

584: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
585: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
586: v_message_name VARCHAR2(30);
587: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
588: v_derived_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
589: v_exit_loop BOOLEAN DEFAULT FALSE;
590: BEGIN
591: -- Set the default message number
592: p_message_name := null;

Line 611: p_message_name := 'IGS_AD_APPLST_CANNOT_RECEIVED';

607: p_adm_appl_status);
608: -- Validate when the application is received.
609: IF v_s_adm_appl_status = cst_received AND
610: IGS_AD_GEN_007.ADMP_GET_SAAS(v_derived_s_adm_appl_status) <> cst_received THEN
611: p_message_name := 'IGS_AD_APPLST_CANNOT_RECEIVED';
612: RETURN FALSE;
613: END IF;
614: -- Validate when the application is completed.
615: IF v_s_adm_appl_status = cst_completed AND

Line 617: p_message_name := 'IGS_AD_APPLST_CANNOT_COMPLETE';

613: END IF;
614: -- Validate when the application is completed.
615: IF v_s_adm_appl_status = cst_completed AND
616: IGS_AD_GEN_007.ADMP_GET_SAAS(v_derived_s_adm_appl_status) <> cst_completed THEN
617: p_message_name := 'IGS_AD_APPLST_CANNOT_COMPLETE';
618: RETURN FALSE;
619: END IF;
620: -- Validate when the application is withdrawn.
621: IF v_s_adm_appl_status = cst_withdrawn THEN

Line 623: p_message_name := 'IGS_AD_APPLST_CANNOT_WITHDRAW';

619: END IF;
620: -- Validate when the application is withdrawn.
621: IF v_s_adm_appl_status = cst_withdrawn THEN
622: IF IGS_AD_GEN_007.ADMP_GET_SAAS(v_derived_s_adm_appl_status) <> cst_withdrawn THEN
623: p_message_name := 'IGS_AD_APPLST_CANNOT_WITHDRAW';
624: RETURN FALSE;
625: END IF;
626: -- Validate if the admission application can be withdrawn.
627: -- Loop through IGS_AD_PS_APPL_INST records:

Line 645: p_message_name := 'IGS_AD_APPLST_NOTBE_WITHDRAWN';

641: EXIT;
642: END IF;
643: END LOOP;
644: IF v_exit_loop THEN
645: p_message_name := 'IGS_AD_APPLST_NOTBE_WITHDRAWN';
646: RETURN FALSE;
647: END IF;
648: END IF;
649: -- Return the default value

Line 666: -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed.

662: IGS_GE_MSG_STACK.ADD;
663: App_Exception.Raise_Exception;
664: END admp_val_aa_aas;
665: --
666: -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed.
667: FUNCTION admp_val_aas_closed(
668: p_adm_appl_status IN VARCHAR2 ,
669: p_message_name OUT NOCOPY VARCHAR2 )
670: RETURN BOOLEAN AS

Line 672: -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed

668: p_adm_appl_status IN VARCHAR2 ,
669: p_message_name OUT NOCOPY VARCHAR2 )
670: RETURN BOOLEAN AS
671: BEGIN -- admp_val_aas_closed
672: -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed
673: DECLARE
674: CURSOR c_aas IS
675: SELECT closed_ind
676: FROM IGS_AD_APPL_STAT

Line 676: FROM IGS_AD_APPL_STAT

672: -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed
673: DECLARE
674: CURSOR c_aas IS
675: SELECT closed_ind
676: FROM IGS_AD_APPL_STAT
677: WHERE adm_appl_status = p_adm_appl_status;
678: v_closed_ind IGS_AD_APPL_STAT.closed_ind%TYPE;
679: BEGIN
680: -- Set the default message number

Line 678: v_closed_ind IGS_AD_APPL_STAT.closed_ind%TYPE;

674: CURSOR c_aas IS
675: SELECT closed_ind
676: FROM IGS_AD_APPL_STAT
677: WHERE adm_appl_status = p_adm_appl_status;
678: v_closed_ind IGS_AD_APPL_STAT.closed_ind%TYPE;
679: BEGIN
680: -- Set the default message number
681: p_message_name := null;
682: -- Cursor handling

Line 704: -- Validate the IGS_AD_APPL.adm_fee_status.

700: IGS_GE_MSG_STACK.ADD;
701: App_Exception.Raise_Exception;
702: END admp_val_aas_closed;
703: --
704: -- Validate the IGS_AD_APPL.adm_fee_status.
705: FUNCTION admp_val_aa_afs(
706: p_person_id IN NUMBER ,
707: p_admission_appl_number IN NUMBER ,
708: p_adm_fee_status IN VARCHAR2 ,

Line 714: -- Validate the IGS_AD_APPL.adm_fee_status. Validations are

710: p_cond_offer_fee_allowed IN VARCHAR2 DEFAULT 'N',
711: p_message_name OUT NOCOPY VARCHAR2 )
712: RETURN BOOLEAN AS
713: BEGIN -- admp_val_aa_afs
714: -- Validate the IGS_AD_APPL.adm_fee_status. Validations are
715: -- The adm_fee_status must be open.
716: -- If fee's are required the adm_fee_status must not have a system value of
717: -- not-applicable.
718: -- If fee's are not required the adm_fee_status must have a system value of

Line 788: p_message_name := 'IGS_AD_APPLFEE_REQUIRED';

784: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_adm_fee_status);
785: -- Validate when fee's are required.
786: IF (p_fees_required_ind = 'Y') THEN
787: IF (v_s_adm_fee_status = cst_not_applic) THEN
788: p_message_name := 'IGS_AD_APPLFEE_REQUIRED';
789: RETURN FALSE;
790: END IF;
791: -- Validate against admission IGS_PS_COURSE application outcome status
792: IF (v_s_adm_fee_status = cst_pending) THEN

Line 798: p_message_name := 'IGS_AD_APPLFEE_NOTSET_OFRMADE';

794: FETCH c_chk_offer_pend INTO v_dummy;
795: IF c_chk_offer_pend%FOUND THEN
796: CLOSE c_chk_offer_pend;
797: -- Cannot be determining fees when offer has been made
798: p_message_name := 'IGS_AD_APPLFEE_NOTSET_OFRMADE';
799: RETURN FALSE;
800: END IF;
801: CLOSE c_chk_offer_pend;
802: END IF;

Line 809: p_message_name := 'IGS_AD_APPLFEE_NOTSET_ASSESED';

805: FETCH c_chk_offer_ass INTO v_dummy;
806: IF c_chk_offer_ass%FOUND THEN
807: CLOSE c_chk_offer_ass;
808: -- Cannot be assessing fees when offer is being made
809: p_message_name := 'IGS_AD_APPLFEE_NOTSET_ASSESED';
810: RETURN FALSE;
811: END IF;
812: CLOSE c_chk_offer_ass;
813: IF p_cond_offer_fee_allowed = 'N' THEN

Line 830: p_message_name := 'IGS_AD_APPLFEE_NOTBE_ASSESSED';

826: FETCH c_check_cndtnl INTO v_dummy;
827: IF c_check_cndtnl%FOUND THEN
828: CLOSE c_check_cndtnl;
829: -- Cannot be assessing fees when a conditional offer has been satisfied.
830: p_message_name := 'IGS_AD_APPLFEE_NOTBE_ASSESSED';
831: RETURN FALSE;
832: END IF;
833: CLOSE c_check_cndtnl;
834: END IF;

Line 839: p_message_name := 'IGS_AD_APPLFEE_NOT_APPLICABLE';

835: END IF;
836: -- Validate when fee's are not required.
837: IF p_fees_required_ind = 'N' AND
838: v_s_adm_fee_status <> cst_not_applic THEN
839: p_message_name := 'IGS_AD_APPLFEE_NOT_APPLICABLE';
840: RETURN FALSE;
841: END IF;
842: RETURN TRUE;
843: EXCEPTION

Line 870: -- Validate the IGS_AD_APPL.tac_appl_ind.

866: --
867: -- Validate if IGS_AD_FEE_STAT.adm_fee_status is closed.
868:
869: --
870: -- Validate the IGS_AD_APPL.tac_appl_ind.
871: FUNCTION admp_val_aa_tac_appl(
872: p_person_id IN NUMBER ,
873: p_tac_appl_ind IN VARCHAR2 DEFAULT 'N',
874: p_appl_dt IN DATE ,

Line 880: DECLARE -- Validate the IGS_AD_APPL.tac_appl_ind.

876: p_message_name OUT NOCOPY VARCHAR2 ,
877: p_return_type OUT NOCOPY VARCHAR2 )
878: RETURN BOOLEAN AS
879: BEGIN -- admp_val_aa_tac_appl
880: DECLARE -- Validate the IGS_AD_APPL.tac_appl_ind.
881: -- Validations are -
882: -- If the IGS_AD_APPL.tac_appl_ind = 'Y' then an alternate_person_id
883: -- record must exist for the person with an s_person_id_type of 'TAC'.
884: -- If the IGS_PE_ALT_PERS_ID record is dated, then it must be effective

Line 882: -- If the IGS_AD_APPL.tac_appl_ind = 'Y' then an alternate_person_id

878: RETURN BOOLEAN AS
879: BEGIN -- admp_val_aa_tac_appl
880: DECLARE -- Validate the IGS_AD_APPL.tac_appl_ind.
881: -- Validations are -
882: -- If the IGS_AD_APPL.tac_appl_ind = 'Y' then an alternate_person_id
883: -- record must exist for the person with an s_person_id_type of 'TAC'.
884: -- If the IGS_PE_ALT_PERS_ID record is dated, then it must be effective
885: -- as of the IGS_AD_APPL.appl_dt.
886: cst_error CONSTANT VARCHAR2(1) := 'E';

Line 885: -- as of the IGS_AD_APPL.appl_dt.

881: -- Validations are -
882: -- If the IGS_AD_APPL.tac_appl_ind = 'Y' then an alternate_person_id
883: -- record must exist for the person with an s_person_id_type of 'TAC'.
884: -- If the IGS_PE_ALT_PERS_ID record is dated, then it must be effective
885: -- as of the IGS_AD_APPL.appl_dt.
886: cst_error CONSTANT VARCHAR2(1) := 'E';
887: cst_warn CONSTANT VARCHAR2(1) := 'W';
888: cst_course CONSTANT IGS_AD_APPL.s_admission_process_type%TYPE := 'COURSE';
889: v_pe_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE;

Line 888: cst_course CONSTANT IGS_AD_APPL.s_admission_process_type%TYPE := 'COURSE';

884: -- If the IGS_PE_ALT_PERS_ID record is dated, then it must be effective
885: -- as of the IGS_AD_APPL.appl_dt.
886: cst_error CONSTANT VARCHAR2(1) := 'E';
887: cst_warn CONSTANT VARCHAR2(1) := 'W';
888: cst_course CONSTANT IGS_AD_APPL.s_admission_process_type%TYPE := 'COURSE';
889: v_pe_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE;
890: -- gmaheswa: Added START_DT <> END_DT OR END_DT IS NULL condition as part of bug 3882788
891: CURSOR c_api_pit IS
892: SELECT api.pe_person_id