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

Line 76: app_exception.raise_exception;

72: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
73: CLOSE cur_old_ref_values;
74: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
75: igs_ge_msg_stack.add;
76: app_exception.raise_exception;
77: RETURN;
78: END IF;
79: CLOSE cur_old_ref_values;
80:

Line 155: App_Exception.Raise_Exception;

151: new_references.fee_type,
152: v_message_name) = FALSE THEN
153: Fnd_Message.Set_Name('IGS',v_message_name);
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END IF;
158: END IF;
159: -- Validate that appropriate fields are set depending on the fee type.

Line 171: App_Exception.Raise_Exception;

167: new_references.govt_hecs_cntrbtn_band,
168: v_message_name) = FALSE THEN
169: Fnd_Message.Set_Name('IGS',v_message_name);
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174: -- Validate fee category is only set when the relation type = 'FCFL'.
175: IF p_inserting OR p_updating THEN

Line 182: App_Exception.Raise_Exception;

178: new_references.fee_cat,
179: v_message_name) = FALSE THEN
180: Fnd_Message.Set_Name('IGS',v_message_name);
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF;
184: END IF;
185: -- Validate closed indicators.
186: IF p_inserting OR p_updating THEN

Line 193: App_Exception.Raise_Exception;

189: new_references.location_cd,
190: v_message_name) = FALSE THEN
191: Fnd_Message.Set_Name('IGS',v_message_name);
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195: -- Validate for closed attendance type.
196: -- change igs_fi_val_far.enrp_val_att_closed
197: -- to igs_en_val_pee.enrp_val_att_closed

Line 204: App_Exception.Raise_Exception;

200: new_references.attendance_type,
201: v_message_name) = FALSE THEN
202: Fnd_Message.Set_Name('IGS',v_message_name);
203: IGS_GE_MSG_STACK.ADD;
204: App_Exception.Raise_Exception;
205: END IF;
206: -- Validate for closed attendance mode.
207: IF IGS_FI_VAL_FAR.enrp_val_am_closed (
208: new_references.attendance_mode,

Line 212: App_Exception.Raise_Exception;

208: new_references.attendance_mode,
209: v_message_name) = FALSE THEN
210: Fnd_Message.Set_Name('IGS',v_message_name);
211: IGS_GE_MSG_STACK.ADD;
212: App_Exception.Raise_Exception;
213: END IF;
214: END IF;
215: END BeforeRowInsertUpdateDelete1;
216:

Line 329: App_Exception.Raise_Exception;

325: new_references.s_relation_type,
326: v_message_name) = FALSE THEN
327: Fnd_Message.Set_Name('IGS',v_message_name);
328: IGS_GE_MSG_STACK.ADD;
329: App_Exception.Raise_Exception;
330: END IF;
331: IF igs_fi_val_far.finp_val_far_unique(new_references.fee_type,
332: new_references.fee_cal_type,
333: new_references.fee_ci_sequence_number,

Line 360: App_Exception.Raise_Exception;

356: new_references.unit_mode
357: ) = FALSE THEN
358: Fnd_Message.Set_Name('IGS',v_message_name);
359: IGS_GE_MSG_STACK.ADD;
360: App_Exception.Raise_Exception;
361: END IF;
362: IF IGS_FI_VAL_FAR.finp_val_far_order(new_references.fee_type,
363: new_references.fee_cal_type,
364: new_references.fee_ci_sequence_number,

Line 377: App_Exception.Raise_Exception;

373: new_references.order_of_precedence,
374: v_message_name) = FALSE THEN
375: Fnd_Message.Set_Name('IGS',v_message_name);
376: IGS_GE_MSG_STACK.ADD;
377: App_Exception.Raise_Exception;
378: END IF;
379: END IF;
380: END AfterStmtInsertUpdate4;
381:

Line 455: App_Exception.Raise_Exception;

451: IF ((UPPER (column_name) = 'ATTENDANCE_MODE') OR (column_name IS NULL)) THEN
452: IF (new_references.attendance_mode <> UPPER (new_references.attendance_mode)) THEN
453: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
454: IGS_GE_MSG_STACK.ADD;
455: App_Exception.Raise_Exception;
456: END IF;
457: END IF;
458: IF ((UPPER (column_name) = 'ATTENDANCE_TYPE') OR (column_name IS NULL)) THEN
459: IF (new_references.attendance_type <> UPPER (new_references.attendance_type)) THEN

Line 462: App_Exception.Raise_Exception;

458: IF ((UPPER (column_name) = 'ATTENDANCE_TYPE') OR (column_name IS NULL)) THEN
459: IF (new_references.attendance_type <> UPPER (new_references.attendance_type)) THEN
460: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
461: IGS_GE_MSG_STACK.ADD;
462: App_Exception.Raise_Exception;
463: END IF;
464: END IF;
465: IF ((UPPER (column_name) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
466: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) THEN

Line 469: App_Exception.Raise_Exception;

465: IF ((UPPER (column_name) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
466: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) THEN
467: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
468: IGS_GE_MSG_STACK.ADD;
469: App_Exception.Raise_Exception;
470: END IF;
471: END IF;
472: IF ((UPPER (column_name) = 'GOVT_HECS_PAYMENT_OPTION') OR (column_name IS NULL)) THEN
473: IF (new_references.govt_hecs_payment_option <> UPPER (new_references.govt_hecs_payment_option)) THEN

Line 476: App_Exception.Raise_Exception;

472: IF ((UPPER (column_name) = 'GOVT_HECS_PAYMENT_OPTION') OR (column_name IS NULL)) THEN
473: IF (new_references.govt_hecs_payment_option <> UPPER (new_references.govt_hecs_payment_option)) THEN
474: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
475: IGS_GE_MSG_STACK.ADD;
476: App_Exception.Raise_Exception;
477: END IF;
478: END IF;
479: IF ((UPPER (column_name) = 'LOCATION_CD') OR (column_name IS NULL)) THEN
480: IF (new_references.location_cd <> UPPER (new_references.location_cd)) THEN

Line 483: App_Exception.Raise_Exception;

479: IF ((UPPER (column_name) = 'LOCATION_CD') OR (column_name IS NULL)) THEN
480: IF (new_references.location_cd <> UPPER (new_references.location_cd)) THEN
481: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
482: IGS_GE_MSG_STACK.ADD;
483: App_Exception.Raise_Exception;
484: END IF;
485: END IF;
486: IF ((UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
487: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN

Line 490: App_Exception.Raise_Exception;

486: IF ((UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
487: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN
488: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
489: IGS_GE_MSG_STACK.ADD;
490: App_Exception.Raise_Exception;
491: END IF;
492: END IF;
493: IF ((UPPER (column_name) = 'S_RELATION_TYPE') OR (column_name IS NULL)) THEN
494: IF (new_references.s_relation_type NOT IN ('FTCI', 'FCFL')) THEN

Line 497: App_Exception.Raise_Exception;

493: IF ((UPPER (column_name) = 'S_RELATION_TYPE') OR (column_name IS NULL)) THEN
494: IF (new_references.s_relation_type NOT IN ('FTCI', 'FCFL')) THEN
495: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
496: IGS_GE_MSG_STACK.ADD;
497: App_Exception.Raise_Exception;
498: END IF;
499: END IF;
500: IF ((UPPER (column_name) = 'RATE_NUMBER') OR (column_name IS NULL)) THEN
501: IF ((new_references.rate_number < 1) OR (new_references.rate_number > 999999999)) THEN

Line 504: App_Exception.Raise_Exception;

500: IF ((UPPER (column_name) = 'RATE_NUMBER') OR (column_name IS NULL)) THEN
501: IF ((new_references.rate_number < 1) OR (new_references.rate_number > 999999999)) THEN
502: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
503: IGS_GE_MSG_STACK.ADD;
504: App_Exception.Raise_Exception;
505: END IF;
506: END IF;
507: IF ((UPPER (column_name) = 'ORDER_OF_PRECEDENCE') OR (column_name IS NULL)) THEN
508: IF ((new_references.order_of_precedence < 0) OR (new_references.order_of_precedence > 999999999)) THEN

Line 511: App_Exception.Raise_Exception;

507: IF ((UPPER (column_name) = 'ORDER_OF_PRECEDENCE') OR (column_name IS NULL)) THEN
508: IF ((new_references.order_of_precedence < 0) OR (new_references.order_of_precedence > 999999999)) THEN
509: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
510: IGS_GE_MSG_STACK.ADD;
511: App_Exception.Raise_Exception;
512: END IF;
513: END IF;
514: IF ((UPPER (column_name) = 'CHG_RATE') OR (column_name IS NULL)) THEN
515: IF (new_references.chg_rate < 0) THEN

Line 518: App_Exception.Raise_Exception;

514: IF ((UPPER (column_name) = 'CHG_RATE') OR (column_name IS NULL)) THEN
515: IF (new_references.chg_rate < 0) THEN
516: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
517: IGS_GE_MSG_STACK.ADD;
518: App_Exception.Raise_Exception;
519: END IF;
520: END IF;
521: IF ((UPPER (column_name) = 'COURSE_CD') OR (column_name IS NULL)) THEN
522: IF (new_references.course_cd <> UPPER (new_references.course_cd)) THEN

Line 525: App_Exception.Raise_Exception;

521: IF ((UPPER (column_name) = 'COURSE_CD') OR (column_name IS NULL)) THEN
522: IF (new_references.course_cd <> UPPER (new_references.course_cd)) THEN
523: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
524: IGS_GE_MSG_STACK.ADD;
525: App_Exception.Raise_Exception;
526: END IF;
527: END IF;
528: IF ((UPPER (column_name) = 'VERSION_NUMBER') OR (column_name IS NULL)) THEN
529: IF ((new_references.version_number < 0) OR (new_references.version_number > 999)) THEN

Line 532: App_Exception.Raise_Exception;

528: IF ((UPPER (column_name) = 'VERSION_NUMBER') OR (column_name IS NULL)) THEN
529: IF ((new_references.version_number < 0) OR (new_references.version_number > 999)) THEN
530: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
531: IGS_GE_MSG_STACK.ADD;
532: App_Exception.Raise_Exception;
533: END IF;
534: END IF;
535: IF ((UPPER (column_name) = 'CLASS_STANDING') OR (column_name IS NULL)) THEN
536: IF (new_references.class_standing <> UPPER (new_references.class_standing)) THEN

Line 539: App_Exception.Raise_Exception;

535: IF ((UPPER (column_name) = 'CLASS_STANDING') OR (column_name IS NULL)) THEN
536: IF (new_references.class_standing <> UPPER (new_references.class_standing)) THEN
537: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
538: IGS_GE_MSG_STACK.ADD;
539: App_Exception.Raise_Exception;
540: END IF;
541: END IF;
542: IF ((UPPER(column_name) = 'UNIT_SET_CD') OR (column_name IS NULL)) THEN
543: IF (new_references.unit_set_cd <> UPPER(new_references.unit_set_cd)) THEN

Line 546: app_exception.raise_exception;

542: IF ((UPPER(column_name) = 'UNIT_SET_CD') OR (column_name IS NULL)) THEN
543: IF (new_references.unit_set_cd <> UPPER(new_references.unit_set_cd)) THEN
544: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
545: igs_ge_msg_stack.add;
546: app_exception.raise_exception;
547: END IF;
548: END IF;
549: IF ((UPPER(column_name) = 'US_VERSION_NUMBER') OR (column_name IS NULL)) THEN
550: IF ((new_references.us_version_number < 0) OR (new_references.us_version_number > 999)) THEN

Line 553: app_exception.raise_exception;

549: IF ((UPPER(column_name) = 'US_VERSION_NUMBER') OR (column_name IS NULL)) THEN
550: IF ((new_references.us_version_number < 0) OR (new_references.us_version_number > 999)) THEN
551: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
552: igs_ge_msg_stack.add;
553: app_exception.raise_exception;
554: END IF;
555: END IF;
556: IF ((UPPER(column_name) = 'UNIT_VERSION_NUMBER') OR (column_name IS NULL)) THEN
557: IF ((new_references.unit_version_number < 0) OR (new_references.unit_version_number > 999)) THEN

Line 560: app_exception.raise_exception;

556: IF ((UPPER(column_name) = 'UNIT_VERSION_NUMBER') OR (column_name IS NULL)) THEN
557: IF ((new_references.unit_version_number < 0) OR (new_references.unit_version_number > 999)) THEN
558: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
559: igs_ge_msg_stack.add;
560: app_exception.raise_exception;
561: END IF;
562: END IF;
563: IF ((UPPER(column_name) = 'UNIT_TYPE_ID') OR (column_name IS NULL)) THEN
564: IF (new_references.unit_type_id < 0) THEN

Line 567: app_exception.raise_exception;

563: IF ((UPPER(column_name) = 'UNIT_TYPE_ID') OR (column_name IS NULL)) THEN
564: IF (new_references.unit_type_id < 0) THEN
565: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
566: igs_ge_msg_stack.add;
567: app_exception.raise_exception;
568: END IF;
569: END IF;
570: IF ((UPPER (column_name) = 'UNIT_CD') OR (column_name IS NULL)) THEN
571: IF (new_references.unit_cd <> UPPER (new_references.unit_cd)) THEN

Line 574: App_Exception.Raise_Exception;

570: IF ((UPPER (column_name) = 'UNIT_CD') OR (column_name IS NULL)) THEN
571: IF (new_references.unit_cd <> UPPER (new_references.unit_cd)) THEN
572: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
573: IGS_GE_MSG_STACK.ADD;
574: App_Exception.Raise_Exception;
575: END IF;
576: END IF;
577: IF ((UPPER(column_name) = 'UNIT_LEVEL') OR (column_name IS NULL)) THEN
578: IF (new_references.unit_level <> UPPER(new_references.unit_level)) THEN

Line 581: app_exception.raise_exception;

577: IF ((UPPER(column_name) = 'UNIT_LEVEL') OR (column_name IS NULL)) THEN
578: IF (new_references.unit_level <> UPPER(new_references.unit_level)) THEN
579: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
580: igs_ge_msg_stack.add;
581: app_exception.raise_exception;
582: END IF;
583: END IF;
584: IF ((UPPER (column_name) = 'UNIT_CLASS') OR (column_name IS NULL)) THEN
585: IF (new_references.unit_class <> UPPER (new_references.unit_class)) THEN

Line 588: App_Exception.Raise_Exception;

584: IF ((UPPER (column_name) = 'UNIT_CLASS') OR (column_name IS NULL)) THEN
585: IF (new_references.unit_class <> UPPER (new_references.unit_class)) THEN
586: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
587: IGS_GE_MSG_STACK.ADD;
588: App_Exception.Raise_Exception;
589: END IF;
590: END IF;
591: IF ((UPPER(column_name) = 'UNIT_MODE') OR (column_name IS NULL)) THEN
592: IF (new_references.unit_mode <> UPPER(new_references.unit_mode)) THEN

Line 595: app_exception.raise_exception;

591: IF ((UPPER(column_name) = 'UNIT_MODE') OR (column_name IS NULL)) THEN
592: IF (new_references.unit_mode <> UPPER(new_references.unit_mode)) THEN
593: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
594: igs_ge_msg_stack.add;
595: app_exception.raise_exception;
596: END IF;
597: END IF;
598:
599: END Check_Constraints;

Line 622: App_Exception.Raise_Exception;

618: new_references.fee_cat
619: )) THEN
620: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
621: IGS_GE_MSG_STACK.ADD;
622: App_Exception.Raise_Exception;
623: END IF;
624: IF (Get_UK2_For_Validation (
625: new_references.fee_type,
626: new_references.fee_cal_type,

Line 634: App_Exception.Raise_Exception;

630: new_references.fee_cat
631: )) THEN
632: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
633: IGS_GE_MSG_STACK.ADD;
634: App_Exception.Raise_Exception;
635: END IF;
636: END Check_Uniqueness;
637:
638:

Line 733: App_Exception.Raise_Exception;

729: new_references.attendance_mode
730: ) THEN
731: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
732: IGS_GE_MSG_STACK.ADD;
733: App_Exception.Raise_Exception;
734: END IF;
735: END IF;
736: IF (((old_references.attendance_type = new_references.attendance_type)) OR
737: ((new_references.attendance_type IS NULL))) THEN

Line 745: App_Exception.Raise_Exception;

741: new_references.attendance_type
742: ) THEN
743: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
744: IGS_GE_MSG_STACK.ADD;
745: App_Exception.Raise_Exception;
746: END IF;
747: END IF;
748: IF (((old_references.fee_cat = new_references.fee_cat) AND
749: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 766: App_Exception.Raise_Exception;

762: new_references.fee_type
763: ) THEN
764: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
765: IGS_GE_MSG_STACK.ADD;
766: App_Exception.Raise_Exception;
767: END IF;
768: END IF;
769: IF (((old_references.fee_type = new_references.fee_type) AND
770: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 784: App_Exception.Raise_Exception;

780: new_references.fee_ci_sequence_number
781: ) THEN
782: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
783: IGS_GE_MSG_STACK.ADD;
784: App_Exception.Raise_Exception;
785: END IF;
786: END IF;
787: IF (((old_references.govt_hecs_cntrbtn_band = new_references.govt_hecs_cntrbtn_band)) OR
788: ((new_references.govt_hecs_cntrbtn_band IS NULL))) THEN

Line 796: App_Exception.Raise_Exception;

792: new_references.govt_hecs_cntrbtn_band
793: ) THEN
794: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
795: IGS_GE_MSG_STACK.ADD;
796: App_Exception.Raise_Exception;
797: END IF;
798: END IF;
799: IF (((old_references.govt_hecs_payment_option = new_references.govt_hecs_payment_option)) OR
800: ((new_references.govt_hecs_payment_option IS NULL))) THEN

Line 808: App_Exception.Raise_Exception;

804: new_references.govt_hecs_payment_option
805: ) THEN
806: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
807: IGS_GE_MSG_STACK.ADD;
808: App_Exception.Raise_Exception;
809: END IF;
810: END IF;
811: IF (((old_references.location_cd = new_references.location_cd)) OR
812: ((new_references.location_cd IS NULL))) THEN

Line 821: App_Exception.Raise_Exception;

817: 'N'
818: ) THEN
819: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
820: IGS_GE_MSG_STACK.ADD;
821: App_Exception.Raise_Exception;
822: END IF;
823: END IF;
824:
825: IF (((old_references.residency_status_cd = new_references.residency_status_cd)) OR

Line 834: App_Exception.Raise_Exception;

830: 'PE_RES_STATUS',new_references.residency_status_cd
831: ) THEN
832: Fnd_Message.Set_Name ('FND' , 'FORM_RECORD_DELETED');
833: IGS_GE_MSG_STACK.ADD;
834: App_Exception.Raise_Exception;
835: END IF;
836: END IF;
837: IF (((old_references.course_cd = new_references.course_cd) AND
838: (old_references.version_number = new_references.version_number)) OR

Line 849: App_Exception.Raise_Exception;

845: new_references.version_number
846: ) THEN
847: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
848: IGS_GE_MSG_STACK.ADD;
849: App_Exception.Raise_Exception;
850: END IF;
851: END IF;
852: IF (((old_references.org_party_id = new_references.org_party_id) OR
853: (new_references.org_party_id IS NULL))) THEN

Line 861: App_Exception.Raise_Exception;

857: IF (cur1%NOTFOUND) THEN
858: CLOSE cur1;
859: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
860: IGS_GE_MSG_STACK.ADD;
861: App_Exception.Raise_Exception;
862: END IF;
863: CLOSE cur1;
864: END IF;
865:

Line 875: App_Exception.Raise_Exception;

871: new_references.class_standing
872: ) THEN
873: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
874: IGS_GE_MSG_STACK.ADD;
875: App_Exception.Raise_Exception;
876: END IF;
877: END IF;
878:
879: IF (((old_references.unit_set_cd = new_references.unit_set_cd) AND

Line 891: app_exception.raise_exception;

887: new_references.us_version_number
888: ) THEN
889: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
890: igs_ge_msg_stack.add;
891: app_exception.raise_exception;
892: END IF;
893: END IF;
894:
895:

Line 1042: app_exception.raise_exception;

1038: IF (cur_rowid%FOUND) THEN
1039: CLOSE cur_rowid;
1040: fnd_message.set_name ('IGS', 'IGS_FI_FAR_UM_FK');
1041: igs_ge_msg_stack.add;
1042: app_exception.raise_exception;
1043: RETURN;
1044: END IF;
1045: CLOSE cur_rowid;
1046:

Line 1072: App_Exception.Raise_Exception;

1068: Fetch cur_rowid INTO lv_rowid;
1069: IF (cur_rowid%FOUND) THEN
1070: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAR_AM_FK');
1071: IGS_GE_MSG_STACK.ADD;
1072: App_Exception.Raise_Exception;
1073: Close cur_rowid;
1074: Return;
1075: END IF;
1076: Close cur_rowid;

Line 1104: App_Exception.Raise_Exception;

1100: IF (cur_rowid%FOUND) THEN
1101: Close cur_rowid;
1102: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAR_ATT_FK');
1103: IGS_GE_MSG_STACK.ADD;
1104: App_Exception.Raise_Exception;
1105: Return;
1106: END IF;
1107: Close cur_rowid;
1108: END GET_FK_IGS_EN_ATD_TYPE;

Line 1135: App_Exception.Raise_Exception;

1131: IF (cur_rowid%FOUND) THEN
1132: Close cur_rowid;
1133: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAR_GHC_FK');
1134: IGS_GE_MSG_STACK.ADD;
1135: App_Exception.Raise_Exception;
1136: Return;
1137: END IF;
1138: Close cur_rowid;
1139: END GET_FK_IGS_FI_GOVT_HEC_CNTB;

Line 1166: App_Exception.Raise_Exception;

1162: IF (cur_rowid%FOUND) THEN
1163: Close cur_rowid;
1164: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAR_GHPO_FK');
1165: IGS_GE_MSG_STACK.ADD;
1166: App_Exception.Raise_Exception;
1167: Return;
1168: END IF;
1169: Close cur_rowid;
1170: END GET_FK_IGS_FI_GOV_HEC_PA_OP;

Line 1197: App_Exception.Raise_Exception;

1193: IF (cur_rowid%FOUND) THEN
1194: Close cur_rowid;
1195: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAR_LOC_FK');
1196: IGS_GE_MSG_STACK.ADD;
1197: App_Exception.Raise_Exception;
1198: Return;
1199: END IF;
1200: Close cur_rowid;
1201: END GET_FK_IGS_AD_LOCATION;

Line 1230: App_Exception.Raise_Exception;

1226: IF(cur_rowid%FOUND) THEN
1227: Close cur_rowid;
1228: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAR_CRV_FK');
1229: IGS_GE_MSG_STACK.ADD;
1230: App_Exception.Raise_Exception;
1231: Return;
1232: END IF;
1233: Close cur_rowid;
1234: END GET_FK_IGS_PS_VER;

Line 1263: App_Exception.Raise_Exception;

1259: IF(cur_rowid%FOUND) THEN
1260: Close cur_rowid;
1261: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAR_PCS_FK');
1262: IGS_GE_MSG_STACK.ADD;
1263: App_Exception.Raise_Exception;
1264: Return;
1265: END IF;
1266: Close cur_rowid;
1267: END GET_UFK_IGS_PR_CLASS_STD;

Line 1368: App_Exception.Raise_Exception;

1364: new_references.far_id
1365: )) THEN
1366: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
1367: IGS_GE_MSG_STACK.ADD;
1368: App_Exception.Raise_Exception;
1369: END IF;
1370: Check_Uniqueness;
1371: Check_Constraints;
1372: Check_Parent_Existance;

Line 1391: App_Exception.Raise_Exception;

1387: new_references.far_id
1388: )) THEN
1389: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
1390: IGS_GE_MSG_STACK.ADD;
1391: App_Exception.Raise_Exception;
1392: END IF;
1393: Check_Uniqueness;
1394: Check_Constraints;
1395:

Line 1519: app_exception.raise_exception;

1515: END IF;
1516: ELSE
1517: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1518: igs_ge_msg_stack.add;
1519: app_exception.raise_exception;
1520: END IF;
1521:
1522: SELECT igs_fi_fee_as_rate_far_id_s.nextval
1523: INTO x_far_id

Line 1744: app_exception.raise_exception;

1740: IF (c1%NOTFOUND) THEN
1741: CLOSE c1;
1742: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1743: igs_ge_msg_stack.add;
1744: app_exception.raise_exception;
1745: RETURN;
1746: END IF;
1747: CLOSE c1;
1748: IF ( (tlinfo.fee_cal_type = x_fee_cal_type)

Line 1780: app_exception.raise_exception;

1776: NULL;
1777: ELSE
1778: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1779: igs_ge_msg_stack.add;
1780: app_exception.raise_exception;
1781: END IF;
1782:
1783: RETURN;
1784:

Line 1871: app_exception.raise_exception;

1867: END IF;
1868: ELSE
1869: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
1870: igs_ge_msg_stack.add;
1871: app_exception.raise_exception;
1872: END IF;
1873:
1874: Before_DML(
1875: p_action => 'UPDATE',

Line 2126: app_exception.raise_exception;

2122: -- Bug#2409567, Will not allow any updation of attributes when the logical delete date is set.
2123: IF old_references.logical_delete_dt IS NOT NULL THEN
2124: fnd_message.set_name('IGS','IGS_FI_LOG_DEL_UPD_NOT_ALLOWED');
2125: IGS_GE_MSG_STACK.ADD;
2126: app_exception.raise_exception;
2127: END IF;
2128: END beforerowupdate;
2129:
2130: PROCEDURE get_fk_igs_en_unit_set_all(

Line 2159: app_exception.raise_exception;

2155: IF(cur_rowid%FOUND) THEN
2156: CLOSE cur_rowid;
2157: fnd_message.set_name('IGS', 'IGS_FI_FAR_EUS_FK');
2158: igs_ge_msg_stack.add;
2159: app_exception.raise_exception;
2160: RETURN;
2161: END IF;
2162: CLOSE cur_rowid;
2163: END get_fk_igs_en_unit_set_all;