[Home] [Help]
70: OPEN cur_old_ref_values;
71: FETCH cur_old_ref_values INTO old_references;
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;
149: IF new_references.s_relation_type <> 'FTCI' THEN
150: IF IGS_FI_VAL_FAR.finp_val_far_ins (
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;
165: new_references.attendance_mode,
166: new_references.govt_hecs_payment_option,
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;
176: IF IGS_FI_VAL_FAR.finp_val_far_rltn (
177: new_references.s_relation_type,
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;
187: -- Validate for closed location.
188: IF IGS_FI_VAL_FAR.crsp_val_loc_cd (
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.
198: --
199: IF IGS_EN_VAL_PEE.enrp_val_att_closed (
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.
206: -- Validate for closed attendance mode.
207: IF IGS_FI_VAL_FAR.enrp_val_am_closed (
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;
323: new_references.fee_cal_type,
324: new_references.fee_ci_sequence_number,
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,
354: new_references.unit_level ,
355: new_references.unit_type_id,
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,
371: new_references.govt_hecs_payment_option,
372: new_references.govt_hecs_cntrbtn_band,
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;
449: END IF;
450:
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
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
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;
616: new_references.fee_ci_sequence_number,
617: new_references.rate_number,
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 (
628: new_references.s_relation_type,
629: new_references.rate_number,
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;
727: ELSE
728: IF NOT IGS_EN_ATD_MODE_PKG.Get_PK_For_Validation (
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;
739: ELSE
740: IF NOT IGS_EN_ATD_TYPE_PKG.Get_PK_For_Validation (
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;
760: new_references.fee_cal_type,
761: new_references.fee_ci_sequence_number,
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;
778: new_references.fee_type,
779: new_references.fee_cal_type,
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;
790: ELSE
791: IF NOT IGS_FI_GOVT_HEC_CNTB_PKG.Get_PK_For_Validation (
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;
802: ELSE
803: IF NOT IGS_FI_GOV_HEC_PA_OP_PKG.Get_PK_For_Validation (
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;
815: IF NOT IGS_AD_LOCATION_PKG.Get_PK_For_Validation (
816: new_references.location_cd ,
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;
828: ELSE
829: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
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;
843: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (
844: new_references.course_cd,
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;
855: ELSE
856: OPEN cur1(new_references.org_party_id);
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;
869: ELSE
870: IF NOT IGS_PR_CLASS_STD_PKG.Get_UK_For_Validation (
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;
885: IF NOT igs_en_unit_set_pkg.get_pk_for_validation(
886: new_references.unit_set_cd,
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;
1036: OPEN cur_rowid;
1037: FETCH cur_rowid INTO lv_rowid;
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;
1066: BEGIN
1067: Open cur_rowid;
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;
1098: Open cur_rowid;
1099: Fetch cur_rowid INTO lv_rowid;
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;
1129: Open cur_rowid;
1130: Fetch cur_rowid INTO lv_rowid;
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;
1160: Open cur_rowid;
1161: Fetch cur_rowid INTO lv_rowid;
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;
1191: Open cur_rowid;
1192: Fetch cur_rowid INTO lv_rowid;
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;
1224: Open cur_rowid;
1225: Fetch cur_rowid INTO lv_rowid;
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;
1257: Open cur_rowid;
1258: Fetch cur_rowid INTO lv_rowid;
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;
1362: BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE ,p_updating => FALSE , p_deleting => FALSE );
1363: IF (Get_PK_For_Validation (
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;
1385: ELSIF (p_action = 'VALIDATE_INSERT') THEN
1386: IF (Get_PK_For_Validation (
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;
1513: ELSE
1514: x_program_update_date:=SYSDATE;
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:
1738: OPEN c1;
1739: FETCH c1 INTO tlinfo;
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;
1774: AND ((tlinfo.unit_mode = x_unit_mode) OR ((tlinfo.unit_mode IS NULL) AND (x_unit_mode IS NULL)))
1775: ) THEN
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:
1865: ELSE
1866: x_program_update_date := SYSDATE;
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:
2120: ----------------------------------------------------------------------------*/
2121: BEGIN
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;
2153: OPEN cur_rowid;
2154: FETCH cur_rowid INTO lv_rowid;
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;