[Home] [Help]
94: Open cur_old_ref_values;
95: Fetch cur_old_ref_values INTO old_references;
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;
229:
230: IF upper(column_name) = 'CNDTNL_OFFER_MUST_BE_STSFD_IND' OR
231: column_name is null Then
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;
230: IF upper(column_name) = 'CNDTNL_OFFER_MUST_BE_STSFD_IND' OR
231: column_name is null Then
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;
240: IF upper(column_name) = 'ASS_RANK' OR
241: column_name is null Then
242: IF new_references.ass_rank < 1 OR
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;
241: column_name is null Then
242: IF new_references.ass_rank < 1 OR
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;
251: IF upper(column_name) = 'INTRNTNL_ACCEPTANCE_ADVICE_NUM' OR
252: column_name is null Then
253: IF new_references.intrntnl_acceptance_advice_num < 1 OR
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;
252: column_name is null Then
253: IF new_references.intrntnl_acceptance_advice_num < 1 OR
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;
262: IF upper(column_name) = 'SECONDARY_ASS_RANK' OR
263: column_name is null Then
264: IF new_references.secondary_ass_rank < 1 OR
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;
263: column_name is null Then
264: IF new_references.secondary_ass_rank < 1 OR
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;
273: IF upper(column_name) = 'PREFERENCE_NUMBER' OR
274: column_name is null Then
275: IF new_references.preference_number < 1 OR
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;
274: column_name is null Then
275: IF new_references.preference_number < 1 OR
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;
285: IF upper(column_name) = 'SEQUENCE_NUMBER' OR
286: column_name is null Then
287: IF new_references.sequence_number < 1 OR
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;
286: column_name is null Then
287: IF new_references.sequence_number < 1 OR
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;
296:
297: IF upper(column_name) = 'CORRESPONDENCE_CAT' OR
298: column_name is null Then
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;
297: IF upper(column_name) = 'CORRESPONDENCE_CAT' OR
298: column_name is null Then
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
308: column_name is null Then
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;
307: IF upper(column_name) = 'EXPECTED_COMPLETION_PERD' OR
308: column_name is null Then
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
318: column_name IS NULL THEN
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;
317: IF upper(column_name) = 'APPL_INST_STATUS' OR --arvsrini igsm
318: column_name IS NULL THEN
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;
347: ELSE
348: IF NOT IGS_EN_ATD_MODE_PKG.Get_PK_For_Validation (
349: new_references.attendance_mode
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;
348: IF NOT IGS_EN_ATD_MODE_PKG.Get_PK_For_Validation (
349: new_references.attendance_mode
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;
361: ELSE
362: IF NOT IGS_AD_OFRDFRMT_STAT_PKG.Get_PK_For_Validation (
363: new_references.adm_offer_dfrmnt_status
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;
362: IF NOT IGS_AD_OFRDFRMT_STAT_PKG.Get_PK_For_Validation (
363: new_references.adm_offer_dfrmnt_status
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;
375: ELSE
376: IF NOT IGS_AD_OFR_RESP_STAT_PKG.Get_PK_For_Validation (
377: new_references.adm_offer_resp_status
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;
376: IF NOT IGS_AD_OFR_RESP_STAT_PKG.Get_PK_For_Validation (
377: new_references.adm_offer_resp_status
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;
389: ELSE
390: IF NOT IGS_AD_OU_STAT_PKG.Get_PK_For_Validation (
391: new_references.adm_outcome_status
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;
390: IF NOT IGS_AD_OU_STAT_PKG.Get_PK_For_Validation (
391: new_references.adm_outcome_status
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;
403: ELSE
404: IF NOT IGS_EN_ATD_TYPE_PKG.Get_PK_For_Validation (
405: new_references.attendance_type
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;
404: IF NOT IGS_EN_ATD_TYPE_PKG.Get_PK_For_Validation (
405: new_references.attendance_type
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;
420: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
421: new_references.deferred_adm_cal_type,
422: new_references.deferred_adm_ci_sequence_num
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;
421: new_references.deferred_adm_cal_type,
422: new_references.deferred_adm_ci_sequence_num
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;
437: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
438: new_references.adm_cal_type,
439: new_references.adm_ci_sequence_number
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;
438: new_references.adm_cal_type,
439: new_references.adm_ci_sequence_number
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;
454: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (
455: new_references.course_cd,
456: new_references.crv_version_number
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;
455: new_references.course_cd,
456: new_references.crv_version_number
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;
468: ELSE
469: IF NOT IGS_EN_ENROLMENT_CAT_PKG.Get_PK_For_Validation (
470: new_references.enrolment_cat
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;
469: IF NOT IGS_EN_ENROLMENT_CAT_PKG.Get_PK_For_Validation (
470: new_references.enrolment_cat
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;
482: ELSE
483: IF NOT IGS_FI_FEE_CAT_PKG.Get_PK_For_Validation (
484: new_references.fee_cat
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;
483: IF NOT IGS_FI_FEE_CAT_PKG.Get_PK_For_Validation (
484: new_references.fee_cat
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;
496: ELSE
497: IF NOT IGS_FI_FUND_SRC_PKG.Get_PK_For_Validation (
498: new_references.funding_source
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;
497: IF NOT IGS_FI_FUND_SRC_PKG.Get_PK_For_Validation (
498: new_references.funding_source
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;
510: ELSE
511: IF NOT IGS_FI_HECS_PAY_OPTN_PKG.Get_PK_For_Validation (
512: new_references.hecs_payment_option
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;
511: IF NOT IGS_FI_HECS_PAY_OPTN_PKG.Get_PK_For_Validation (
512: new_references.hecs_payment_option
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;
524: ELSE
525: IF NOT IGS_AD_LOCATION_PKG.Get_PK_For_Validation (
526: new_references.location_cd
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;
525: IF NOT IGS_AD_LOCATION_PKG.Get_PK_For_Validation (
526: new_references.location_cd
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;
538: ELSE
539: IF NOT IGS_TR_ITEM_PKG.Get_PK_For_Validation (
540: new_references.ass_tracking_id
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;
539: IF NOT IGS_TR_ITEM_PKG.Get_PK_For_Validation (
540: new_references.ass_tracking_id
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;
552: ELSE
553: IF NOT IGS_TR_ITEM_PKG.Get_PK_For_Validation (
554: new_references.deferred_tracking_id
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;
553: IF NOT IGS_TR_ITEM_PKG.Get_PK_For_Validation (
554: new_references.deferred_tracking_id
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;
569: IF NOT IGS_EN_UNIT_SET_PKG.Get_PK_For_Validation (
570: new_references.unit_set_cd,
571: new_references.us_version_number
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;
570: new_references.unit_set_cd,
571: new_references.us_version_number
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;
589: new_references.person_id,
590: new_references.admission_appl_number,
591: new_references.nominated_course_cd
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;
590: new_references.admission_appl_number,
591: new_references.nominated_course_cd
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;
603: ELSE
604: IF NOT IGS_AD_CNDNL_OFRSTAT_PKG.Get_PK_For_Validation (
605: new_references.adm_cndtnl_offer_status
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;
604: IF NOT IGS_AD_CNDNL_OFRSTAT_PKG.Get_PK_For_Validation (
605: new_references.adm_cndtnl_offer_status
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;
617: ELSE
618: IF NOT IGS_AD_DOC_STAT_PKG.Get_PK_For_Validation (
619: new_references.adm_doc_status
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;
618: IF NOT IGS_AD_DOC_STAT_PKG.Get_PK_For_Validation (
619: new_references.adm_doc_status
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;
631: ELSE
632: IF NOT IGS_AD_ENT_QF_STAT_PKG.Get_PK_For_Validation (
633: new_references.adm_entry_qual_status
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;
632: IF NOT IGS_AD_ENT_QF_STAT_PKG.Get_PK_For_Validation (
633: new_references.adm_entry_qual_status
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;
645: ELSE
646: IF NOT IGS_AD_FEE_STAT_PKG.Get_PK_For_Validation (
647: new_references.late_adm_fee_status
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;
646: IF NOT IGS_AD_FEE_STAT_PKG.Get_PK_For_Validation (
647: new_references.late_adm_fee_status
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;
660: ELSE
661: IF NOT IGS_AD_APPL_STAT_PKG.Get_PK_For_Validation (
662: new_references.appl_inst_status ,'N'
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;
661: IF NOT IGS_AD_APPL_STAT_PKG.Get_PK_For_Validation (
662: new_references.appl_inst_status ,'N'
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;
675: NULL;
676: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
677: new_references.decision_make_id
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;
676: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
677: new_references.decision_make_id
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
687: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
688: new_references.decision_reason_id,
689: 'DECISION_REASON', 'N'
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;
688: new_references.decision_reason_id,
689: 'DECISION_REASON', 'N'
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
699: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
700: new_references.pending_reason_id,
701: 'PENDING_REASON','N'
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;
700: new_references.pending_reason_id,
701: 'PENDING_REASON','N'
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:
715: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
716: new_references.future_acad_cal_type,
717: new_references.future_acad_ci_sequence_num
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;
716: new_references.future_acad_cal_type,
717: new_references.future_acad_ci_sequence_num
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;
732: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
733: new_references.future_adm_cal_type,
734: new_references.future_adm_ci_sequence_num
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;
733: new_references.future_adm_cal_type,
734: new_references.future_adm_ci_sequence_num
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;
940: new_references.nominated_course_cd,
941: new_references.sequence_number,
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;
957: new_references.nominated_course_cd,
958: new_references.sequence_number,
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;
1070: if X_LAST_UPDATE_LOGIN is NULL then
1071: X_LAST_UPDATE_LOGIN := -1;
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:
1318: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
1319: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
1320: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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
1319: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
1320: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;
1466: open c1;
1467: fetch c1 into tlinfo;
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;
1668:
1669: ) then
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;
1762: if X_LAST_UPDATE_LOGIN is NULL then
1763: X_LAST_UPDATE_LOGIN := -1;
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:
1909: decline_ofr_reason = new_references.decline_ofr_reason -- end apadegal td001 igsm
1910: where ROWID = X_ROWID
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:
1926: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
1927: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
1928: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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
1927: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
1928: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;
2175: );
2176: delete from IGS_AD_PS_APLINSTHST_ALL
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(
2191: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
2192: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
2193: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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
2192: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
2193: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;