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

Line 100: App_Exception.Raise_Exception;

96: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
97: Close cur_old_ref_values;
98: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: Return;
102: END IF;
103: Close cur_old_ref_values;
104:

Line 236: App_Exception.Raise_Exception;

232: IF new_references.cndtnl_offer_must_be_stsfd_ind NOT IN ('Y','N') Then
233: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
234: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CND_OFR_STSFD_IND'));
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: END IF;
239:
240: IF upper(column_name) = 'ASS_RANK' OR

Line 247: App_Exception.Raise_Exception;

243: new_references.ass_rank > 999 Then
244: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
245: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ASSESSMENT_RANK'));
246: IGS_GE_MSG_STACK.ADD;
247: App_Exception.Raise_Exception;
248: END IF;
249: END IF;
250:
251: IF upper(column_name) = 'INTRNTNL_ACCEPTANCE_ADVICE_NUM' OR

Line 258: App_Exception.Raise_Exception;

254: new_references.intrntnl_acceptance_advice_num > 999999999999999 Then
255: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
256: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTRL_ACCPT_ADV_NUM'));
257: IGS_GE_MSG_STACK.ADD;
258: App_Exception.Raise_Exception;
259: END IF;
260: END IF;
261:
262: IF upper(column_name) = 'SECONDARY_ASS_RANK' OR

Line 269: App_Exception.Raise_Exception;

265: new_references.secondary_ass_rank > 999 Then
266: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
267: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEC_ASS_RANK'));
268: IGS_GE_MSG_STACK.ADD;
269: App_Exception.Raise_Exception;
270: END IF;
271: END IF;
272:
273: IF upper(column_name) = 'PREFERENCE_NUMBER' OR

Line 280: App_Exception.Raise_Exception;

276: new_references.preference_number > 99 Then
277: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PREFERANCE_NUM'));
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: END IF;
283:
284:

Line 292: App_Exception.Raise_Exception;

288: new_references.sequence_number > 999999 Then
289: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
290: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQUENCE_NUM'));
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294: END IF;
295:
296:

Line 303: App_Exception.Raise_Exception;

299: IF new_references.correspondence_cat <> UPPER(new_references.correspondence_cat) Then
300: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
301: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRSPOND_CAT'));
302: IGS_GE_MSG_STACK.ADD;
303: App_Exception.Raise_Exception;
304: END IF;
305: END IF;
306:
307: IF upper(column_name) = 'EXPECTED_COMPLETION_PERD' OR

Line 313: App_Exception.Raise_Exception;

309: IF new_references.expected_completion_perd <> UPPER(new_references.expected_completion_perd) Then
310: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_PRD'));
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: END IF;
315: END IF;
316:
317: IF upper(column_name) = 'APPL_INST_STATUS' OR --arvsrini igsm

Line 323: App_Exception.Raise_Exception;

319: IF new_references.appl_inst_status <> UPPER(new_references.appl_inst_status) THEN
320: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
321: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));
322: IGS_GE_MSG_STACK.ADD;
323: App_Exception.Raise_Exception;
324: END IF;
325: END IF;
326:
327:

Line 354: APP_EXCEPTION.RAISE_EXCEPTION;

350: )THEN
351: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
352: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ATTENDANCE_MODE'));
353: IGS_GE_MSG_STACK.ADD;
354: APP_EXCEPTION.RAISE_EXCEPTION;
355: END IF;
356: END IF;
357:
358: IF (((old_references.adm_offer_dfrmnt_status = new_references.adm_offer_dfrmnt_status)) OR

Line 368: APP_EXCEPTION.RAISE_EXCEPTION;

364: )THEN
365: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
366: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_DFRMNT_STATUS'));
367: IGS_GE_MSG_STACK.ADD;
368: APP_EXCEPTION.RAISE_EXCEPTION;
369: END IF;
370: END IF;
371:
372: IF (((old_references.adm_offer_resp_status = new_references.adm_offer_resp_status)) OR

Line 382: APP_EXCEPTION.RAISE_EXCEPTION;

378: )THEN
379: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_RESP_STATUS'));
381: IGS_GE_MSG_STACK.ADD;
382: APP_EXCEPTION.RAISE_EXCEPTION;
383: END IF;
384: END IF;
385:
386: IF (((old_references.adm_outcome_status = new_references.adm_outcome_status)) OR

Line 396: APP_EXCEPTION.RAISE_EXCEPTION;

392: )THEN
393: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OUTCOME_STATUS'));
395: IGS_GE_MSG_STACK.ADD;
396: APP_EXCEPTION.RAISE_EXCEPTION;
397: END IF;
398: END IF;
399:
400: IF (((old_references.attendance_type = new_references.attendance_type)) OR

Line 410: APP_EXCEPTION.RAISE_EXCEPTION;

406: )THEN
407: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ATTENDANCE_TYPE'));
409: IGS_GE_MSG_STACK.ADD;
410: APP_EXCEPTION.RAISE_EXCEPTION;
411: END IF;
412: END IF;
413:
414: IF (((old_references.deferred_adm_cal_type = new_references.deferred_adm_cal_type) AND

Line 427: APP_EXCEPTION.RAISE_EXCEPTION;

423: )THEN
424: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
425: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEFERRED_ADM_CAL_TYPE'));
426: IGS_GE_MSG_STACK.ADD;
427: APP_EXCEPTION.RAISE_EXCEPTION;
428: END IF;
429: END IF;
430:
431: IF (((old_references.adm_cal_type = new_references.adm_cal_type) AND

Line 444: APP_EXCEPTION.RAISE_EXCEPTION;

440: )THEN
441: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
443: IGS_GE_MSG_STACK.ADD;
444: APP_EXCEPTION.RAISE_EXCEPTION;
445: END IF;
446: END IF;
447:
448: IF (((old_references.course_cd = new_references.course_cd) AND

Line 461: APP_EXCEPTION.RAISE_EXCEPTION;

457: )THEN
458: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM'));
460: IGS_GE_MSG_STACK.ADD;
461: APP_EXCEPTION.RAISE_EXCEPTION;
462: END IF;
463: END IF;
464:
465: IF (((old_references.enrolment_cat = new_references.enrolment_cat)) OR

Line 475: APP_EXCEPTION.RAISE_EXCEPTION;

471: )THEN
472: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENROLMENT_CAT'));
474: IGS_GE_MSG_STACK.ADD;
475: APP_EXCEPTION.RAISE_EXCEPTION;
476: END IF;
477: END IF;
478:
479: IF (((old_references.fee_cat = new_references.fee_cat)) OR

Line 489: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 503: APP_EXCEPTION.RAISE_EXCEPTION;

499: ) THEN
500: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUNDING_SOURCE'));
502: IGS_GE_MSG_STACK.ADD;
503: APP_EXCEPTION.RAISE_EXCEPTION;
504: END IF;
505: END IF;
506:
507: IF (((old_references.hecs_payment_option = new_references.hecs_payment_option)) OR

Line 517: APP_EXCEPTION.RAISE_EXCEPTION;

513: )THEN
514: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_HECS_PAY_OPT'));
516: IGS_GE_MSG_STACK.ADD;
517: APP_EXCEPTION.RAISE_EXCEPTION;
518: END IF;
519: END IF;
520:
521: IF (((old_references.location_cd = new_references.location_cd)) OR

Line 531: APP_EXCEPTION.RAISE_EXCEPTION;

527: )THEN
528: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_EN_LOCATION'));
530: IGS_GE_MSG_STACK.ADD;
531: APP_EXCEPTION.RAISE_EXCEPTION;
532: END IF;
533: END IF;
534:
535: IF (((old_references.ass_tracking_id = new_references.ass_tracking_id)) OR

Line 545: APP_EXCEPTION.RAISE_EXCEPTION;

541: )THEN
542: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ASS_TRACKING_ID'));
544: IGS_GE_MSG_STACK.ADD;
545: APP_EXCEPTION.RAISE_EXCEPTION;
546: END IF;
547: END IF;
548:
549: IF (((old_references.deferred_tracking_id = new_references.deferred_tracking_id)) OR

Line 559: APP_EXCEPTION.RAISE_EXCEPTION;

555: )THEN
556: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ASS_TRACKING_ID'));
558: IGS_GE_MSG_STACK.ADD;
559: APP_EXCEPTION.RAISE_EXCEPTION;
560: END IF;
561: END IF;
562:
563: IF (((old_references.unit_set_cd = new_references.unit_set_cd) AND

Line 576: APP_EXCEPTION.RAISE_EXCEPTION;

572: )THEN
573: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
574: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
575: IGS_GE_MSG_STACK.ADD;
576: APP_EXCEPTION.RAISE_EXCEPTION;
577: END IF;
578: END IF;
579:
580: IF (((old_references.person_id = new_references.person_id) AND

Line 596: APP_EXCEPTION.RAISE_EXCEPTION;

592: )THEN
593: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
594: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
595: IGS_GE_MSG_STACK.ADD;
596: APP_EXCEPTION.RAISE_EXCEPTION;
597: END IF;
598: END IF;
599:
600: IF (((old_references.adm_cndtnl_offer_status = new_references.adm_cndtnl_offer_status)) OR

Line 610: APP_EXCEPTION.RAISE_EXCEPTION;

606: )THEN
607: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_COND_OFR_STATUS'));
609: IGS_GE_MSG_STACK.ADD;
610: APP_EXCEPTION.RAISE_EXCEPTION;
611: END IF;
612: END IF;
613:
614: IF (((old_references.adm_doc_status = new_references.adm_doc_status)) OR

Line 624: APP_EXCEPTION.RAISE_EXCEPTION;

620: )THEN
621: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_DOC_STAT'));
623: IGS_GE_MSG_STACK.ADD;
624: APP_EXCEPTION.RAISE_EXCEPTION;
625: END IF;
626: END IF;
627:
628: IF (((old_references.adm_entry_qual_status = new_references.adm_entry_qual_status)) OR

Line 638: APP_EXCEPTION.RAISE_EXCEPTION;

634: )THEN
635: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_ENTRY_QUAL_STATUS'));
637: IGS_GE_MSG_STACK.ADD;
638: APP_EXCEPTION.RAISE_EXCEPTION;
639: END IF;
640: END IF;
641:
642: IF (((old_references.late_adm_fee_status = new_references.late_adm_fee_status)) OR

Line 652: APP_EXCEPTION.RAISE_EXCEPTION;

648: )THEN
649: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
650: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_LATE_ADM_FEE_STATUS'));
651: IGS_GE_MSG_STACK.ADD;
652: APP_EXCEPTION.RAISE_EXCEPTION;
653: END IF;
654: END IF;
655:
656:

Line 667: APP_EXCEPTION.RAISE_EXCEPTION;

663: )THEN
664: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));
666: IGS_GE_MSG_STACK.ADD;
667: APP_EXCEPTION.RAISE_EXCEPTION;
668: END IF;
669: END IF;
670:
671: ---************************************************* begin apadegal adtd001 IGS.M **********************************

Line 682: App_Exception.Raise_Exception;

678: ) THEN
679: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
680: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEC_MAKE'));
681: IGS_GE_MSG_STACK.ADD;
682: App_Exception.Raise_Exception;
683: END IF;
684: IF (((old_references.decision_reason_id = new_references.decision_reason_id)) OR
685: ((new_references.decision_reason_id IS NULL))) THEN
686: NULL;

Line 694: App_Exception.Raise_Exception;

690: ) THEN
691: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEC_REASON'));
693: IGS_GE_MSG_STACK.ADD;
694: App_Exception.Raise_Exception;
695: END IF;
696: IF (((old_references.pending_reason_id = new_references.pending_reason_id)) OR
697: ((new_references.pending_reason_id IS NULL))) THEN
698: NULL;

Line 706: App_Exception.Raise_Exception;

702: ) THEN
703: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PEND_REASON'));
705: IGS_GE_MSG_STACK.ADD;
706: App_Exception.Raise_Exception;
707: END IF;
708:
709: IF (((old_references.future_acad_cal_type = new_references.future_acad_cal_type) AND
710: (old_references.future_acad_ci_sequence_num = new_references.future_acad_ci_sequence_num)) OR

Line 722: APP_EXCEPTION.RAISE_EXCEPTION;

718: )THEN
719: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
720: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUT_ACAD_CAL'));
721: IGS_GE_MSG_STACK.ADD;
722: APP_EXCEPTION.RAISE_EXCEPTION;
723: END IF;
724: END IF;
725:
726: IF (((old_references.future_adm_cal_type = new_references.future_adm_cal_type) AND

Line 739: APP_EXCEPTION.RAISE_EXCEPTION;

735: )THEN
736: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
737: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUT_ADM_CAL'));
738: IGS_GE_MSG_STACK.ADD;
739: APP_EXCEPTION.RAISE_EXCEPTION;
740: END IF;
741: END IF;
742: ---************************************************* end apadegal adtd001 IGS.M **********************************
743:

Line 946: App_Exception.Raise_Exception;

942: new_references.hist_start_dt
943: ) THEN
944: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
945: IGS_GE_MSG_STACK.ADD;
946: App_Exception.Raise_Exception;
947: END IF;
948: Check_Constraints;
949: Check_Parent_Existance;
950: ELSIF (p_action = 'UPDATE') THEN

Line 963: App_Exception.Raise_Exception;

959: new_references.hist_start_dt
960: ) THEN
961: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
962: IGS_GE_MSG_STACK.ADD;
963: App_Exception.Raise_Exception;
964: END IF;
965: Check_Constraints;
966: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
967: Check_Constraints;

Line 1076: app_exception.raise_exception;

1072: end if;
1073: else
1074: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1075: IGS_GE_MSG_STACK.ADD;
1076: app_exception.raise_exception;
1077: end if;
1078:
1079:
1080: Before_DML(

Line 1325: app_exception.raise_exception;

1321: -- that the ownerof policy function does not have privilege to access.
1322: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1323: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1324: IGS_GE_MSG_STACK.ADD;
1325: app_exception.raise_exception;
1326: ELSE
1327: RAISE;
1328: END IF;
1329:

Line 1472: app_exception.raise_exception;

1468: if (c1%notfound) then
1469: close c1;
1470: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1471: IGS_GE_MSG_STACK.ADD;
1472: app_exception.raise_exception;
1473: return;
1474: end if;
1475: close c1;
1476:

Line 1674: app_exception.raise_exception;

1670: null;
1671: else
1672: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1673: IGS_GE_MSG_STACK.ADD;
1674: app_exception.raise_exception;
1675: end if;
1676: return;
1677: end LOCK_ROW;
1678:

Line 1768: app_exception.raise_exception;

1764: end if;
1765: else
1766: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1767: IGS_GE_MSG_STACK.ADD;
1768: app_exception.raise_exception;
1769: end if;
1770:
1771: Before_DML(
1772: p_action =>'UPDATE',

Line 1915: app_exception.raise_exception;

1911: ;
1912: if (sql%notfound) then
1913: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1914: IGS_GE_MSG_STACK.ADD;
1915: app_exception.raise_exception;
1916: end if;
1917:
1918: After_DML(
1919: p_action =>'UPDATE',

Line 1933: app_exception.raise_exception;

1929: -- that the ownerof policy function does not have privilege to access.
1930: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1931: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1932: IGS_GE_MSG_STACK.ADD;
1933: app_exception.raise_exception;
1934: ELSE
1935: RAISE;
1936: END IF;
1937:

Line 2181: app_exception.raise_exception;

2177: where ROWID = X_ROWID;
2178: if (sql%notfound) then
2179: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2180: IGS_GE_MSG_STACK.ADD;
2181: app_exception.raise_exception;
2182: end if;
2183: After_DML(
2184: p_action =>'DELETE',
2185: x_rowid => X_ROWID

Line 2198: app_exception.raise_exception;

2194: -- that the ownerof policy function does not have privilege to access.
2195: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
2196: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
2197: IGS_GE_MSG_STACK.ADD;
2198: app_exception.raise_exception;
2199: ELSE
2200: RAISE;
2201: END IF;
2202: