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_APPL_PKG dependencies on APP_EXCEPTION

Line 59: App_Exception.Raise_Exception;

55: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
56: Close cur_old_ref_values;
57: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
58: IGS_GE_MSG_STACK.ADD;
59: App_Exception.Raise_Exception;
60: Return;
61: END IF;
62: Close cur_old_ref_values;
63:

Line 150: APP_EXCEPTION.RAISE_EXCEPTION;

146: IF ((l_birth_date IS NOT NULL) AND (l_birth_date > new_references.appl_dt)) THEN
147: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DOB_ERROR');
148: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS','IGS_AD_APPL_DT'));
149: IGS_GE_MSG_STACK.ADD;
150: APP_EXCEPTION.RAISE_EXCEPTION;
151: END IF;
152: --
153: -- Determine the admission process category steps.
154: --

Line 193: APP_EXCEPTION.RAISE_EXCEPTION;

189: IF NVL(v_return_type, '-1') = cst_error THEN
190: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
191: FND_MESSAGE.SET_NAME('IGS',v_message_name);
192: IGS_GE_MSG_STACK.ADD;
193: APP_EXCEPTION.RAISE_EXCEPTION;
194: END IF;
195: END IF;
196: --
197: -- Validate the Academic Calendar.

Line 209: APP_EXCEPTION.RAISE_EXCEPTION;

205: IF v_message_name = 'IGS_AD_ADM_CAL_INSTNOT_DEFINE' THEN
206: FND_MESSAGE.SET_TOKEN('CAL_TYPE',new_references.acad_cal_type);
207: END IF;
208: IGS_GE_MSG_STACK.ADD;
209: APP_EXCEPTION.RAISE_EXCEPTION;
210: END IF;
211: --
212: -- Validate the Admission Calendar.
213: --

Line 225: APP_EXCEPTION.RAISE_EXCEPTION;

221: v_message_name) = FALSE THEN
222: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
223: FND_MESSAGE.SET_NAME('IGS',v_message_name);
224: IGS_GE_MSG_STACK.ADD;
225: APP_EXCEPTION.RAISE_EXCEPTION;
226: END IF;
227: --
228: -- Validate the Admission Category.
229: --

Line 236: APP_EXCEPTION.RAISE_EXCEPTION;

232: v_message_name) = FALSE THEN
233: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
234: FND_MESSAGE.SET_NAME('IGS',v_message_name);
235: IGS_GE_MSG_STACK.ADD;
236: APP_EXCEPTION.RAISE_EXCEPTION;
237: END IF;
238: END IF; -- p_inserting.
239: IF p_updating THEN
240: -- Validate update of the admission application record.

Line 250: APP_EXCEPTION.RAISE_EXCEPTION;

246: v_message_name) = FALSE THEN
247: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
248: FND_MESSAGE.SET_NAME('IGS',v_message_name);
249: IGS_GE_MSG_STACK.ADD;
250: APP_EXCEPTION.RAISE_EXCEPTION;
251: END IF;
252: END IF;
253: -- Cannot update the Commencement Period.
254: IF ((old_references.acad_cal_type <> new_references.acad_cal_type) OR

Line 260: APP_EXCEPTION.RAISE_EXCEPTION;

256: (old_references.adm_ci_sequence_number <> new_references.adm_ci_sequence_number)) THEN
257: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(2537));
258: FND_MESSAGE.SET_NAME('IGS','IGS_AD_UPD_COMPERIOD_NOTALLOW');
259: IGS_GE_MSG_STACK.ADD;
260: APP_EXCEPTION.RAISE_EXCEPTION;
261: END IF;
262: --
263: -- Cannot update the Admission Process Category.
264: --

Line 271: APP_EXCEPTION.RAISE_EXCEPTION;

267: (old_references.application_type IS NOT NULL AND old_references.application_type <> new_references.application_type )) THEN
268: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(2538));
269: FND_MESSAGE.SET_NAME('IGS','IGS_AD_UPD_ADMPRC_CAT_NOTALLO');
270: IGS_GE_MSG_STACK.ADD;
271: APP_EXCEPTION.RAISE_EXCEPTION;
272: END IF;
273: --
274: -- Cannot update the Choice Number for UK Profile.
275: --

Line 279: APP_EXCEPTION.RAISE_EXCEPTION;

275: --
276: IF FND_PROFILE.VALUE('OSS_COUNTRY_CODE') = 'GB' AND (old_references.choice_number <> new_references.choice_number) THEN
277: FND_MESSAGE.SET_NAME('IGS','IGS_AD_UPD_CH_NUM');
278: IGS_GE_MSG_STACK.ADD;
279: APP_EXCEPTION.RAISE_EXCEPTION;
280: END IF;
281: --
282: -- Cannot update the Choice Number for Alternate Application ID for UK Profile.
283: --

Line 287: APP_EXCEPTION.RAISE_EXCEPTION;

283: --
284: IF FND_PROFILE.VALUE('OSS_COUNTRY_CODE') = 'GB' AND (old_references.alt_appl_id <> new_references.alt_appl_id) THEN
285: FND_MESSAGE.SET_NAME('IGS','IGS_AD_UPD_ALT_APPL_ID');
286: IGS_GE_MSG_STACK.ADD;
287: APP_EXCEPTION.RAISE_EXCEPTION;
288: END IF;
289:
290: END IF; -- p_updating.
291: IF p_deleting THEN

Line 301: APP_EXCEPTION.RAISE_EXCEPTION;

297: v_message_name) = FALSE THEN
298: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
299: FND_MESSAGE.SET_NAME('IGS',v_message_name);
300: IGS_GE_MSG_STACK.ADD;
301: APP_EXCEPTION.RAISE_EXCEPTION;
302: END IF;
303: END IF; -- p_deleting.
304: --
305: -- Validate the Application Date.

Line 316: APP_EXCEPTION.RAISE_EXCEPTION;

312: v_message_name) = FALSE THEN
313: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
314: FND_MESSAGE.SET_NAME('IGS',v_message_name);
315: IGS_GE_MSG_STACK.ADD;
316: APP_EXCEPTION.RAISE_EXCEPTION;
317: END IF;
318: END IF;
319: --
320: -- Validate the Admission Application Status.

Line 334: APP_EXCEPTION.RAISE_EXCEPTION;

330: v_message_name) = FALSE THEN
331: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
332: FND_MESSAGE.SET_NAME('IGS',v_message_name);
333: IGS_GE_MSG_STACK.ADD;
334: APP_EXCEPTION.RAISE_EXCEPTION;
335: END IF;
336: END IF;
337: --
338: -- Validate the Admission Fee Status.

Line 354: APP_EXCEPTION.RAISE_EXCEPTION;

350: v_message_name) = FALSE THEN
351: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
352: FND_MESSAGE.SET_NAME('IGS',v_message_name);
353: IGS_GE_MSG_STACK.ADD;
354: APP_EXCEPTION.RAISE_EXCEPTION;
355: END IF;
356: END IF;
357: --
358: -- Validate the TAC Application Indicator.

Line 375: APP_EXCEPTION.RAISE_EXCEPTION;

371: IF NVL(v_return_type, '-1') = cst_error THEN
372: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
373: FND_MESSAGE.SET_NAME('IGS',v_message_name);
374: IGS_GE_MSG_STACK.ADD;
375: APP_EXCEPTION.RAISE_EXCEPTION;
376: END IF;
377: END IF;
378: END IF;
379:

Line 391: APP_EXCEPTION.RAISE_EXCEPTION;

387: new_references.appl_fee_amt IS NULL THEN
388:
389: FND_MESSAGE.SET_NAME('IGS','IGS_AD_FEE_AMT_NON_NEGATIVE');
390: IGS_GE_MSG_STACK.ADD;
391: APP_EXCEPTION.RAISE_EXCEPTION;
392: END IF;
393: END IF;
394: --
395:

Line 449: APP_EXCEPTION.RAISE_EXCEPTION;

445: v_message_name) = FALSE THEN
446: --raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
447: FND_MESSAGE.SET_NAME('IGS',v_message_name);
448: IGS_GE_MSG_STACK.ADD;
449: APP_EXCEPTION.RAISE_EXCEPTION;
450: END IF;
451: END IF;
452:
453:

Line 477: APP_EXCEPTION.RAISE_EXCEPTION;

473: new_references.acad_ci_sequence_number
474: )THEN
475: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACACAL_ADMCAL_NOTEXIST');
476: IGS_GE_MSG_STACK.ADD;
477: APP_EXCEPTION.RAISE_EXCEPTION;
478: END IF;
479: END IF;
480:
481: IF (((old_references.person_id = new_references.person_id)) OR

Line 491: APP_EXCEPTION.RAISE_EXCEPTION;

487: )THEN
488: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
489: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
490: IGS_GE_MSG_STACK.ADD;
491: APP_EXCEPTION.RAISE_EXCEPTION;
492: END IF;
493: END IF;
494:
495: IF (((old_references.application_type = new_references.application_type)) OR

Line 504: APP_EXCEPTION.RAISE_EXCEPTION;

500: new_references.application_type,'N'
501: )THEN
502: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
503: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_APPL_TYPE'));
504: APP_EXCEPTION.RAISE_EXCEPTION;
505: END IF;
506: END IF;
507:
508:

Line 519: APP_EXCEPTION.RAISE_EXCEPTION;

515: )THEN
516: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
517: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_APPL_STATUS'));
518: IGS_GE_MSG_STACK.ADD;
519: APP_EXCEPTION.RAISE_EXCEPTION;
520: END IF;
521: END IF;
522:
523: IF (((old_references.adm_fee_status = new_references.adm_fee_status)) OR

Line 533: APP_EXCEPTION.RAISE_EXCEPTION;

529: )THEN
530: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
531: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_FEE_STATUS'));
532: IGS_GE_MSG_STACK.ADD;
533: APP_EXCEPTION.RAISE_EXCEPTION;
534: END IF;
535: END IF;
536:
537: IF (((old_references.adm_cal_type = new_references.adm_cal_type) AND

Line 557: APP_EXCEPTION.RAISE_EXCEPTION;

553: )THEN
554: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
555: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_PRCS_CAT_ADM_CAL'));
556: IGS_GE_MSG_STACK.ADD;
557: APP_EXCEPTION.RAISE_EXCEPTION;
558: END IF;
559: END IF;
560:
561: IF (((old_references.admission_cat = new_references.admission_cat) AND

Line 575: APP_EXCEPTION.RAISE_EXCEPTION;

571: )THEN
572: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_PRCS_CAT'));
574: IGS_GE_MSG_STACK.ADD;
575: APP_EXCEPTION.RAISE_EXCEPTION;
576: END IF;
577: END IF;
578:
579: IF new_references.spcl_grp_1 IS NOT NULL AND NOT igs_ad_code_classes_pkg.Get_PK_For_Validation(new_references.spcl_grp_1,'N') THEN

Line 583: APP_EXCEPTION.RAISE_EXCEPTION;

579: IF new_references.spcl_grp_1 IS NOT NULL AND NOT igs_ad_code_classes_pkg.Get_PK_For_Validation(new_references.spcl_grp_1,'N') THEN
580: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
581: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_GRP'));
582: IGS_GE_MSG_STACK.ADD;
583: APP_EXCEPTION.RAISE_EXCEPTION;
584: END IF;
585: IF new_references.spcl_grp_1 IS NOT NULL AND NOT igs_ad_code_classes_pkg.Get_PK_For_Validation(new_references.spcl_grp_1,'N') THEN
586: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
587: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_GRP'));

Line 589: APP_EXCEPTION.RAISE_EXCEPTION;

585: IF new_references.spcl_grp_1 IS NOT NULL AND NOT igs_ad_code_classes_pkg.Get_PK_For_Validation(new_references.spcl_grp_1,'N') THEN
586: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
587: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_GRP'));
588: IGS_GE_MSG_STACK.ADD;
589: APP_EXCEPTION.RAISE_EXCEPTION;
590: END IF;
591:
592: END Check_Parent_Existance;
593:

Line 693: App_Exception.Raise_Exception;

689: IF (cur_rowid%FOUND) THEN
690: Close cur_rowid;
691: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AA_SSAT_FK');
692: IGS_GE_MSG_STACK.ADD;
693: App_Exception.Raise_Exception;
694: Return;
695: END IF;
696: Close cur_rowid;
697: END GET_FK_IGS_AD_SS_APPL_TYP;

Line 724: App_Exception.Raise_Exception;

720: IF (cur_rowid%FOUND) THEN
721: Close cur_rowid;
722: Fnd_Message.Set_Name ('IGS', 'IGS_CA_AA_CIR_FK');
723: IGS_GE_MSG_STACK.ADD;
724: App_Exception.Raise_Exception;
725: Return;
726: END IF;
727: Close cur_rowid;
728:

Line 750: App_Exception.Raise_Exception;

746: IF (cur_rowid%FOUND) THEN
747: Close cur_rowid;
748: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AA_PE_FK');
749: IGS_GE_MSG_STACK.ADD;
750: App_Exception.Raise_Exception;
751: Return;
752: END IF;
753: Close cur_rowid;
754:

Line 776: App_Exception.Raise_Exception;

772: IF (cur_rowid%FOUND) THEN
773: Close cur_rowid;
774: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AA_AAS_FK');
775: IGS_GE_MSG_STACK.ADD;
776: App_Exception.Raise_Exception;
777: Return;
778: END IF;
779: Close cur_rowid;
780:

Line 802: App_Exception.Raise_Exception;

798: IF (cur_rowid%FOUND) THEN
799: Close cur_rowid;
800: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AA_AFS_FK');
801: IGS_GE_MSG_STACK.ADD;
802: App_Exception.Raise_Exception;
803: Return;
804: END IF;
805: Close cur_rowid;
806:

Line 834: App_Exception.Raise_Exception;

830: IF (cur_rowid%FOUND) THEN
831: Close cur_rowid;
832: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AA_APAPC_FK');
833: IGS_GE_MSG_STACK.ADD;
834: App_Exception.Raise_Exception;
835: Return;
836: END IF;
837: Close cur_rowid;
838:

Line 862: App_Exception.Raise_Exception;

858: IF (cur_rowid%FOUND) THEN
859: Close cur_rowid;
860: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AA_APC_FK');
861: IGS_GE_MSG_STACK.ADD;
862: App_Exception.Raise_Exception;
863: Return;
864: END IF;
865: Close cur_rowid;
866:

Line 894: App_Exception.Raise_Exception;

890: IF (cur_rowid1%FOUND) THEN
891: Close cur_rowid1;
892: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AA_ACDC_FK1');
893: IGS_GE_MSG_STACK.ADD;
894: App_Exception.Raise_Exception;
895: Return;
896: END IF;
897: Close cur_rowid1;
898: END Get_FK_Igs_Ad_Code_Classes;

Line 937: APP_EXCEPTION.RAISE_EXCEPTION;

933: IF new_references.admission_appl_number < 0 OR new_references.admission_appl_number > 99 THEN
934: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'));
936: IGS_GE_MSG_STACK.ADD;
937: APP_EXCEPTION.RAISE_EXCEPTION;
938: END IF;
939: END IF;
940: IF upper(column_name) = 'ACAD_CI_SEQUENCE_NUMBER' OR column_name IS NULL THEN
941: IF new_references.acad_ci_sequence_number < 1 OR new_references.acad_ci_sequence_number > 999999 THEN

Line 945: APP_EXCEPTION.RAISE_EXCEPTION;

941: IF new_references.acad_ci_sequence_number < 1 OR new_references.acad_ci_sequence_number > 999999 THEN
942: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
943: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ACAD_CAL'));
944: IGS_GE_MSG_STACK.ADD;
945: APP_EXCEPTION.RAISE_EXCEPTION;
946: END IF;
947: END IF;
948: IF upper(column_name) = 'ADM_CI_SEQUENCE_NUMBER' OR column_name IS NULL THEN
949: IF (new_references.adm_ci_sequence_number < 1 OR new_references.adm_ci_sequence_number > 999999) THEN

Line 953: APP_EXCEPTION.RAISE_EXCEPTION;

949: IF (new_references.adm_ci_sequence_number < 1 OR new_references.adm_ci_sequence_number > 999999) THEN
950: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
952: IGS_GE_MSG_STACK.ADD;
953: APP_EXCEPTION.RAISE_EXCEPTION;
954: END IF;
955: END IF;
956: IF upper(column_name) = 'TAC_APPL_IND' OR column_name IS NULL THEN
957: IF new_references.tac_appl_ind NOT IN ('Y','N') THEN

Line 961: APP_EXCEPTION.RAISE_EXCEPTION;

957: IF new_references.tac_appl_ind NOT IN ('Y','N') THEN
958: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
959: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TAC_APPL_IND'));
960: IGS_GE_MSG_STACK.ADD;
961: APP_EXCEPTION.RAISE_EXCEPTION;
962: END IF;
963: END IF;
964: IF upper(column_name) = 'APPLICATION_TYPE' OR column_name IS NULL THEN -- Added as part of Enh Bug 2599457
965: IF new_references.application_type IS NULL THEN

Line 968: APP_EXCEPTION.RAISE_EXCEPTION;

964: IF upper(column_name) = 'APPLICATION_TYPE' OR column_name IS NULL THEN -- Added as part of Enh Bug 2599457
965: IF new_references.application_type IS NULL THEN
966: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_TYPE_NULL');
967: IGS_GE_MSG_STACK.ADD;
968: APP_EXCEPTION.RAISE_EXCEPTION;
969: END IF;
970: END IF;
971: IF upper(column_name) = 'ACAD_CAL_TYPE' OR column_name IS NULL THEN
972: IF new_references.acad_cal_type IS NULL THEN

Line 976: APP_EXCEPTION.RAISE_EXCEPTION;

972: IF new_references.acad_cal_type IS NULL THEN
973: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
974: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ACAD_CAL'));
975: IGS_GE_MSG_STACK.ADD;
976: APP_EXCEPTION.RAISE_EXCEPTION;
977: END IF;
978: END IF;
979: IF upper(column_name) = 'ADMISSION_CAT' OR column_name IS NULL THEN
980: IF new_references.admission_cat IS NULL THEN

Line 984: APP_EXCEPTION.RAISE_EXCEPTION;

980: IF new_references.admission_cat IS NULL THEN
981: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
982: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_PRCS_CAT'));
983: IGS_GE_MSG_STACK.ADD;
984: APP_EXCEPTION.RAISE_EXCEPTION;
985: END IF;
986: END IF;
987: IF upper(column_name) = 'ADM_APPL_STATUS' OR column_name IS NULL THEN
988: IF new_references.adm_appl_status IS NULL THEN

Line 992: APP_EXCEPTION.RAISE_EXCEPTION;

988: IF new_references.adm_appl_status IS NULL THEN
989: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
990: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_APPL_STATUS'));
991: IGS_GE_MSG_STACK.ADD;
992: APP_EXCEPTION.RAISE_EXCEPTION;
993: END IF;
994: END IF;
995: IF upper(column_name) = 'ADM_CAL_TYPE' OR column_name IS NULL THEN
996: IF new_references.adm_cal_type IS NULL THEN

Line 1000: APP_EXCEPTION.RAISE_EXCEPTION;

996: IF new_references.adm_cal_type IS NULL THEN
997: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
998: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
999: IGS_GE_MSG_STACK.ADD;
1000: APP_EXCEPTION.RAISE_EXCEPTION;
1001: END IF;
1002: END IF;
1003: IF upper(column_name) = 'ADM_FEE_STATUS' OR column_name IS NULL THEN
1004: IF new_references.adm_fee_status IS NULL THEN

Line 1008: APP_EXCEPTION.RAISE_EXCEPTION;

1004: IF new_references.adm_fee_status IS NULL THEN
1005: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1006: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_FEE_STATUS'));
1007: IGS_GE_MSG_STACK.ADD;
1008: APP_EXCEPTION.RAISE_EXCEPTION;
1009: END IF;
1010: END IF;
1011: IF upper(column_name) = 'S_ADMISSION_PROCESS_TYPE' OR column_name IS NULL THEN
1012: IF new_references.s_admission_process_type IS NULL THEN

Line 1016: APP_EXCEPTION.RAISE_EXCEPTION;

1012: IF new_references.s_admission_process_type IS NULL THEN
1013: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1014: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_PRCS_CAT'));
1015: IGS_GE_MSG_STACK.ADD;
1016: APP_EXCEPTION.RAISE_EXCEPTION;
1017: END IF;
1018: END IF;
1019: IF new_references.Common_app IS NOT NULL AND new_references.common_app NOT IN ('Y','N') THEN
1020: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

Line 1023: APP_EXCEPTION.RAISE_EXCEPTION;

1019: IF new_references.Common_app IS NOT NULL AND new_references.common_app NOT IN ('Y','N') THEN
1020: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1021: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_COM_APP'));
1022: IGS_GE_MSG_STACK.ADD;
1023: APP_EXCEPTION.RAISE_EXCEPTION;
1024: END IF;
1025:
1026: END CHECK_CONSTRAINTS;
1027:

Line 1113: APP_EXCEPTION.RAISE_EXCEPTION;

1109: new_references.admission_appl_number
1110: )THEN
1111: FND_MESSAGE.SET_NAME('IGS','IGS_GE_MULTI_ORG_DUP_REC');
1112: IGS_GE_MSG_STACK.ADD;
1113: APP_EXCEPTION.RAISE_EXCEPTION;
1114: END IF;
1115: Check_Constraints;
1116: Check_Parent_Existance;
1117: ELSIF (p_action = 'UPDATE') THEN

Line 1140: APP_EXCEPTION.RAISE_EXCEPTION;

1136: new_references.admission_appl_number
1137: )THEN
1138: FND_MESSAGE.SET_NAME('IGS','IGS_GE_MULTI_ORG_DUP_REC');
1139: IGS_GE_MSG_STACK.ADD;
1140: APP_EXCEPTION.RAISE_EXCEPTION;
1141: END IF;
1142: Check_Constraints;
1143: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
1144: -- Call all the procedures related to Before Delete.

Line 1269: app_exception.raise_exception;

1265: end if;
1266: else
1267: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1268: IGS_GE_MSG_STACK.ADD;
1269: app_exception.raise_exception;
1270: end if;
1271:
1272: Before_DML (
1273: p_action => 'INSERT',

Line 1401: app_exception.raise_exception;

1397: -- that the ownerof policy function does not have privilege to access.
1398: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1399: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1400: IGS_GE_MSG_STACK.ADD;
1401: app_exception.raise_exception;
1402: ELSE
1403: RAISE;
1404: END IF;
1405: end INSERT_ROW;

Line 1461: app_exception.raise_exception;

1457: if (c1%notfound) then
1458: close c1;
1459: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1460: IGS_GE_MSG_STACK.ADD;
1461: app_exception.raise_exception;
1462: return;
1463: end if;
1464: close c1;
1465:

Line 1505: APP_EXCEPTION.RAISE_EXCEPTION;

1501: NULL;
1502: ELSE
1503: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1504: IGS_GE_MSG_STACK.ADD;
1505: APP_EXCEPTION.RAISE_EXCEPTION;
1506: end if;
1507: return;
1508: end LOCK_ROW;
1509:

Line 1558: app_exception.raise_exception;

1554: end if;
1555: else
1556: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1557: IGS_GE_MSG_STACK.ADD;
1558: app_exception.raise_exception;
1559: end if;
1560: Before_DML (
1561: p_action => 'UPDATE',
1562: x_rowid => X_ROWID,

Line 1637: app_exception.raise_exception;

1633: igs_ge_msg_stack.add;
1634: IF (x_mode = 'S') THEN
1635: igs_sc_gen_001.unset_ctx('R');
1636: END IF;
1637: app_exception.raise_exception;
1638: end if;
1639: IF (x_mode = 'S') THEN
1640: igs_sc_gen_001.unset_ctx('R');
1641: END IF;

Line 1661: app_exception.raise_exception;

1657: -- that the ownerof policy function does not have privilege to access.
1658: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1659: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1660: IGS_GE_MSG_STACK.ADD;
1661: app_exception.raise_exception;
1662: ELSE
1663: RAISE;
1664: END IF;
1665: end UPDATE_ROW;

Line 1776: app_exception.raise_exception;

1772: igs_ge_msg_stack.add;
1773: IF (x_mode = 'S') THEN
1774: igs_sc_gen_001.unset_ctx('R');
1775: END IF;
1776: app_exception.raise_exception;
1777: end if;
1778: IF (x_mode = 'S') THEN
1779: igs_sc_gen_001.unset_ctx('R');
1780: END IF;

Line 1800: app_exception.raise_exception;

1796: -- that the ownerof policy function does not have privilege to access.
1797: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1798: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1799: IGS_GE_MSG_STACK.ADD;
1800: app_exception.raise_exception;
1801: ELSE
1802: RAISE;
1803: END IF;
1804: end DELETE_ROW;