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

Line 74: App_Exception.Raise_Exception;

70: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
71: Close cur_old_ref_values;
72: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
73: IGS_GE_MSG_STACK.ADD;
74: App_Exception.Raise_Exception;
75: Return;
76: END IF;
77: Close cur_old_ref_values;
78:

Line 199: app_exception.raise_exception;

195: IF l_appl_status = 'WITHDRAWN' OR
196: ( l_appl_status = 'COMPLETED' AND NOT igs_ad_gen_002.valid_ofr_resp_status(new_references.person_id,new_references.admission_appl_number)) THEN
197: fnd_message.set_name('IGS','IGS_AD_CANNOT_CHG_APPL_DTL');
198: igs_ge_msg_stack.add;
199: app_exception.raise_exception;
200: -- ADDED following check for Bug# 3017800
201: ELS*/
202: IF ( l_appl_status = 'COMPLETED' AND igs_ad_gen_002.valid_ofr_resp_status(new_references.person_id,new_references.admission_appl_number) AND l_fee_type <> 'ENROLL_DEPOSIT' ) THEN
203: fnd_message.set_name('IGS','IGS_AD_ENRDPT_UPD_CMP_APPL'); -- IGS_AD_ENRDPT_UPD_CMP_APPL: For a completed application only Enrollment Deposit fee records can be manupulated.

Line 205: app_exception.raise_exception;

201: ELS*/
202: IF ( l_appl_status = 'COMPLETED' AND igs_ad_gen_002.valid_ofr_resp_status(new_references.person_id,new_references.admission_appl_number) AND l_fee_type <> 'ENROLL_DEPOSIT' ) THEN
203: fnd_message.set_name('IGS','IGS_AD_ENRDPT_UPD_CMP_APPL'); -- IGS_AD_ENRDPT_UPD_CMP_APPL: For a completed application only Enrollment Deposit fee records can be manupulated.
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:
208: -- for an complete application for which the offer response status is 'Accepted' or the offer response status is
209: -- 'Defferal' with deferment status as 'Confirmed' , only fee type of enroll_deposit can be entered. Also manual

Line 223: app_exception.raise_exception;

219: IF NVL(p_inserting,FALSE) AND l_fee_type = 'ENROLL_DEPOSIT' AND l_fee_status IN ('PAID','PARTIAL') THEN
220: -- Manual creation of Enrollment Deposit record with Application Fee Status mapped to system status of Partial or Paid is not allowed.
221: fnd_message.set_name('IGS','IGS_AD_ENR_DPT_STATUS');
222: igs_ge_msg_stack.add;
223: app_exception.raise_exception;
224: END IF;
225:
226: IF NVL(p_updating,FALSE) AND l_fee_type = 'ENROLL_DEPOSIT' AND l_fee_status IN ('PAID','PARTIAL') THEN
227: -- Update of an Enrollment Deposit record with Application Fee Status mapped to system status of Partial or Paid is not allowed.

Line 230: app_exception.raise_exception;

226: IF NVL(p_updating,FALSE) AND l_fee_type = 'ENROLL_DEPOSIT' AND l_fee_status IN ('PAID','PARTIAL') THEN
227: -- Update of an Enrollment Deposit record with Application Fee Status mapped to system status of Partial or Paid is not allowed.
228: fnd_message.set_name('IGS','IGS_AD_ENRDPT_UPD_NT_ALWD');
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: END IF;
232: -- If manage_accounts is NULL or OTHER
233: ELSIF (l_manage_acc IS NULL OR l_manage_acc = 'OTHER') THEN
234: -- Allow Manual creation of Enrollment Deposit record with Application Fee Status mapped to system status of Partial or Paid.

Line 241: app_exception.raise_exception;

237: ELSE
238: IF l_fee_type = 'ENROLL_DEPOSIT' THEN
239: fnd_message.set_name('IGS','IGS_AD_ENR_DPT_CNT_PAY');
240: igs_ge_msg_stack.add;
241: app_exception.raise_exception;
242: END IF;
243: END IF;
244:
245: OPEN c_appl_dt (new_references.person_id,new_references.admission_appl_number);

Line 255: app_exception.raise_exception;

251: IF new_references.fee_date < l_appl_dt THEN
252: fnd_message.set_name('IGS','IGS_AD_APPL_DATE_ERROR');
253: fnd_message.set_token ('NAME',fnd_message.get_string('IGS','IGS_AD_FEE_DATE'));
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END IF;
257: */
258: -- the fee date cannot be later than the system date
259: IF new_references.fee_date > SYSDATE THEN

Line 263: app_exception.raise_exception;

259: IF new_references.fee_date > SYSDATE THEN
260: fnd_message.set_name('IGS','IGS_AD_DATE_SYSDATE');
261: fnd_message.set_token ('NAME',fnd_message.get_string('IGS','IGS_AD_FEE_DATE'));
262: igs_ge_msg_stack.add;
263: app_exception.raise_exception;
264: END IF;
265: END IF; -- p_updating, p_inserting
266: END IF; -- igs_ad_gen_015.g_chk_ad_app_req
267: END beforerowinsertupdate1;

Line 301: App_Exception.Raise_Exception;

297: IF NOT (new_references.fee_amount >= 0
298: OR new_references.fee_amount IS NULL) THEN
299: Fnd_Message.Set_Name('IGS','IGS_AD_FEE_AMT_NON_NEGATIVE');
300: IGS_GE_MSG_STACK.ADD;
301: App_Exception.Raise_Exception;
302: END IF;
303: END IF;
304:
305: END Check_Constraints;

Line 336: App_Exception.Raise_Exception;

332: ) THEN
333: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
334: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_PAY_METHOD'));
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338:
339: IF (((old_references.person_id = new_references.person_id) AND
340: (old_references.admission_appl_number = new_references.admission_appl_number)) OR

Line 351: App_Exception.Raise_Exception;

347: ) THEN
348: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
350: IGS_GE_MSG_STACK.ADD;
351: App_Exception.Raise_Exception;
352: END IF;
353:
354: IF (((old_references.applicant_fee_status = new_references.applicant_fee_status)) OR
355: ((new_references.applicant_fee_status IS NULL))) THEN

Line 365: App_Exception.Raise_Exception;

361: ) THEN
362: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPLICANT_FEE_STAT'));
364: IGS_GE_MSG_STACK.ADD;
365: App_Exception.Raise_Exception;
366: END IF;
367:
368: IF (((old_references.applicant_fee_type = new_references.applicant_fee_type)) OR
369: ((new_references.applicant_fee_type IS NULL))) THEN

Line 379: App_Exception.Raise_Exception;

375: ) THEN
376: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPLICANT_FEE_TYPE'));
378: IGS_GE_MSG_STACK.ADD;
379: App_Exception.Raise_Exception;
380: END IF;
381:
382: IF ((old_references.rev_account_cd = new_references.rev_account_cd) OR
383: (new_references.rev_account_cd IS NULL)) THEN

Line 392: App_Exception.Raise_Exception;

388: ) THEN
389: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
390: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_ACCT'));
391: IGS_GE_MSG_STACK.ADD;
392: App_Exception.Raise_Exception;
393: END IF;
394: END IF;
395:
396: IF ((old_references.cash_account_cd = new_references.cash_account_cd) OR

Line 406: App_Exception.Raise_Exception;

402: ) THEN
403: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CASH_ACCT'));
405: IGS_GE_MSG_STACK.ADD;
406: App_Exception.Raise_Exception;
407: END IF;
408: END IF;
409:
410: END Check_Parent_Existance;

Line 481: App_Exception.Raise_Exception;

477: IF (cur_rowid%FOUND) THEN
478: Close cur_rowid;
479: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAR_AA_FK');
480: IGS_GE_MSG_STACK.ADD;
481: App_Exception.Raise_Exception;
482: Return;
483: END IF;
484: Close cur_rowid;
485:

Line 533: App_Exception.Raise_Exception;

529: IF (cur_rowid%FOUND) THEN
530: Close cur_rowid;
531: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAR_ACDC_FK3');
532: IGS_GE_MSG_STACK.ADD;
533: App_Exception.Raise_Exception;
534: Return;
535: END IF;
536: Close cur_rowid;
537:

Line 544: App_Exception.Raise_Exception;

540: IF (cur_rowid2%FOUND) THEN
541: Close cur_rowid2;
542: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAR_ACADC_FK1');
543: IGS_GE_MSG_STACK.ADD;
544: App_Exception.Raise_Exception;
545: Return;
546: END IF;
547: Close cur_rowid2;
548:

Line 555: App_Exception.Raise_Exception;

551: IF (cur_rowid3%FOUND) THEN
552: Close cur_rowid3;
553: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAR_ACDC_FK2');
554: IGS_GE_MSG_STACK.ADD;
555: App_Exception.Raise_Exception;
556: Return;
557: END IF;
558: Close cur_rowid3;
559:

Line 660: App_Exception.Raise_Exception;

656: IF Get_Pk_For_Validation(
657: new_references.app_req_id) THEN
658: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
659: IGS_GE_MSG_STACK.ADD;
660: App_Exception.Raise_Exception;
661: END IF;
662: beforerowinsertupdate1( p_inserting => TRUE , p_updating => FALSE, p_deleting=> FALSE);
663: Check_Constraints;
664: Check_Parent_Existance;

Line 679: App_Exception.Raise_Exception;

675: IF Get_PK_For_Validation (
676: new_references.app_req_id) THEN
677: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
678: IGS_GE_MSG_STACK.ADD;
679: App_Exception.Raise_Exception;
680: END IF;
681: beforerowinsertupdate1( p_inserting => TRUE , p_updating => FALSE, p_deleting=> FALSE);
682: Check_Constraints;
683: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 811: app_exception.raise_exception;

807: end if;
808: else
809: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
810: IGS_GE_MSG_STACK.ADD;
811: app_exception.raise_exception;
812: end if;
813:
814: X_APP_REQ_ID := -1;
815:

Line 947: app_exception.raise_exception;

943: -- that the ownerof policy function does not have privilege to access.
944: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
945: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
946: IGS_GE_MSG_STACK.ADD;
947: app_exception.raise_exception;
948: ELSE
949: RAISE;
950: END IF;
951: END insert_row;

Line 1029: app_exception.raise_exception;

1025: if (c1%notfound) then
1026: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1027: IGS_GE_MSG_STACK.ADD;
1028: close c1;
1029: app_exception.raise_exception;
1030: return;
1031: end if;
1032: close c1;
1033: IF ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 1062: app_exception.raise_exception;

1058: NULL;
1059: ELSE
1060: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1061: igs_ge_msg_stack.add;
1062: app_exception.raise_exception;
1063: END IF;
1064: RETURN;
1065: END lock_row;
1066:

Line 1130: app_exception.raise_exception;

1126: end if;
1127: else
1128: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1129: IGS_GE_MSG_STACK.ADD;
1130: app_exception.raise_exception;
1131: end if;
1132: Before_DML(
1133: p_action=>'UPDATE',
1134: x_rowid=>X_ROWID,

Line 1200: app_exception.raise_exception;

1196: igs_ge_msg_stack.add;
1197: IF (x_mode = 'S') THEN
1198: igs_sc_gen_001.unset_ctx('R');
1199: END IF;
1200: app_exception.raise_exception;
1201: END IF;
1202: IF (x_mode = 'S') THEN
1203: igs_sc_gen_001.unset_ctx('R');
1204: END IF;

Line 1225: app_exception.raise_exception;

1221: -- that the ownerof policy function does not have privilege to access.
1222: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1223: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1224: IGS_GE_MSG_STACK.ADD;
1225: app_exception.raise_exception;
1226: ELSE
1227: RAISE;
1228: END IF;
1229: END update_row;

Line 1374: app_exception.raise_exception;

1370: igs_ge_msg_stack.add;
1371: IF (x_mode = 'S') THEN
1372: igs_sc_gen_001.set_ctx('R');
1373: END IF;
1374: app_exception.raise_exception;
1375: END IF;
1376: IF (x_mode = 'S') THEN
1377: igs_sc_gen_001.unset_ctx('R');
1378: END IF;

Line 1398: app_exception.raise_exception;

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