DBA Data[Home] [Help]

APPS.IGS_GR_AWD_CRMN_PKG dependencies on APP_EXCEPTION

Line 57: App_Exception.Raise_Exception;

53: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
54: Close cur_old_ref_values;
55: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
56: IGS_GE_MSG_STACK.ADD;
57: App_Exception.Raise_Exception;
58: Return;
59: END IF;
60: Close cur_old_ref_values;
61:

Line 121: App_Exception.Raise_Exception;

117: new_references.create_dt,
118: v_message_name) = FALSE THEN
119: Fnd_Message.Set_Name('IGS', v_message_name);
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception;
122: END IF;
123: END IF;
124:
125: IF p_inserting OR p_updating THEN

Line 134: App_Exception.Raise_Exception;

130: new_references.ceremony_number,
131: v_message_name) = FALSE THEN
132: Fnd_Message.Set_Name('IGS', v_message_name);
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: -- validate required details have been specified
137: IF IGS_GR_VAL_GAC.grdp_val_gac_rqrd(
138: new_references.award_course_cd,

Line 148: App_Exception.Raise_Exception;

144: new_references.academic_hat_size,
145: v_message_name) = FALSE THEN
146: Fnd_Message.Set_Name('IGS', v_message_name);
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: -- validate unit set group
151: IF (NVL(new_references.us_group_number, 0) <>
152: NVL(old_references.us_group_number, 0)) THEN

Line 169: App_Exception.Raise_Exception;

165: new_references.us_group_number,
166: v_message_name) = FALSE THEN
167: Fnd_Message.Set_Name('IGS', v_message_name);
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: END IF;
172: END IF;
173: -- validate measurement codes

Line 182: App_Exception.Raise_Exception;

178: new_references.academic_gown_size,
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: END IF;
186: IF (NVL(new_references.academic_hat_size, 'NULL') <>

Line 194: App_Exception.Raise_Exception;

190: new_references.academic_hat_size,
191: v_message_name) = FALSE THEN
192: Fnd_Message.Set_Name('IGS', v_message_name);
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
197: END IF;
198: END IF;

Line 210: App_Exception.Raise_Exception;

206: new_references.grd_ci_sequence_number,
207: v_message_name) = FALSE THEN
208: Fnd_Message.Set_Name('IGS', v_message_name);
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;
213:
214: IF p_inserting OR (p_updating AND

Line 232: App_Exception.Raise_Exception;

228: new_references.award_cd,
229: v_message_name) = FALSE THEN
230: Fnd_Message.Set_Name('IGS', v_message_name);
231: IGS_GE_MSG_STACK.ADD;
232: App_Exception.Raise_Exception;
233: END IF;
234: END IF;
235:
236: IF p_inserting OR (p_updating AND

Line 257: App_Exception.Raise_Exception;

253: new_references.us_group_number,
254: v_message_name) = FALSE THEN
255: Fnd_Message.Set_Name('IGS', v_message_name);
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END IF;
259: END IF;
260: END IF;
261:

Line 290: App_Exception.Raise_Exception;

286: old_references.award_cd,
287: v_message_name) = FALSE THEN
288: Fnd_Message.Set_Name('IGS', v_message_name);
289: IGS_GE_MSG_STACK.ADD;
290: App_Exception.Raise_Exception;
291: END IF;
292:
293:
294: END AfterRowDelete2;

Line 326: App_Exception.Raise_Exception;

322: NEW_REFERENCES.graduand_seat_number,
323: v_message_name) = FALSE THEN
324: Fnd_Message.Set_Name('IGS', v_message_name);
325: IGS_GE_MSG_STACK.ADD;
326: App_Exception.Raise_Exception;
327: END IF;
328: END IF;
329: -- validate order in presentation
330: IF (NEW_REFERENCES.order_in_presentation IS NOT NULL) THEN

Line 340: App_Exception.Raise_Exception;

336: NEW_REFERENCES.order_in_presentation,
337: v_message_name) = FALSE THEN
338: Fnd_Message.Set_Name('IGS', v_message_name);
339: IGS_GE_MSG_STACK.ADD;
340: App_Exception.Raise_Exception;
341: END IF;
342: END IF;
343: v_rowid_saved := TRUE;
344: END IF;

Line 366: App_Exception.Raise_Exception;

362: NEW_REFERENCES.graduand_seat_number,
363: v_message_name) = FALSE THEN
364: Fnd_Message.Set_Name('IGS', v_message_name);
365: IGS_GE_MSG_STACK.ADD;
366: App_Exception.Raise_Exception;
367: END IF;
368: END IF;
369:
370: v_rowid_saved := TRUE;

Line 451: App_Exception.Raise_Exception;

447: old_references.award_cd,
448: v_message_name) = FALSE THEN
449: Fnd_Message.Set_Name('IGS', v_message_name);
450: IGS_GE_MSG_STACK.ADD;
451: App_Exception.Raise_Exception;
452: END IF;
453: END IF;
454:
455:

Line 472: APP_EXCEPTION.RAISE_EXCEPTION;

468: new_references.grd_cal_type,
469: new_references.grd_ci_sequence_number
470: ) THEN
471: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
472: APP_EXCEPTION.RAISE_EXCEPTION;
473: END IF;
474: END IF;
475:
476: IF (((old_references.academic_gown_size = new_references.academic_gown_size)) OR

Line 485: APP_EXCEPTION.RAISE_EXCEPTION;

481: new_references.academic_gown_size
482: ) THEN
483: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
484: IGS_GE_MSG_STACK.ADD;
485: APP_EXCEPTION.RAISE_EXCEPTION;
486: END IF;
487: END IF;
488:
489: IF (((old_references.person_id = new_references.person_id) AND

Line 510: APP_EXCEPTION.RAISE_EXCEPTION;

506: new_references.award_cd
507: ) THEN
508: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
509: IGS_GE_MSG_STACK.ADD;
510: APP_EXCEPTION.RAISE_EXCEPTION;
511: END IF;
512: END IF;
513:
514: IF (((old_references.academic_hat_size = new_references.academic_hat_size)) OR

Line 522: APP_EXCEPTION.RAISE_EXCEPTION;

518: IF NOT IGS_GE_MEASUREMENT_PKG.Get_PK_For_Validation (
519: new_references.academic_hat_size
520: ) THEN
521: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
522: APP_EXCEPTION.RAISE_EXCEPTION;
523: END IF;
524: END IF;
525:
526: IF (((old_references.grd_cal_type = new_references.grd_cal_type) AND

Line 552: APP_EXCEPTION.RAISE_EXCEPTION;

548: new_references.award_cd,
549: new_references.us_group_number
550: ) THEN
551: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
552: APP_EXCEPTION.RAISE_EXCEPTION;
553: END IF;
554: END IF;
555:
556: IF (((old_references.grd_cal_type = new_references.grd_cal_type) AND

Line 579: APP_EXCEPTION.RAISE_EXCEPTION;

575: new_references.award_crs_version_number,
576: new_references.award_cd
577: ) THEN
578: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
579: APP_EXCEPTION.RAISE_EXCEPTION;
580: END IF;
581: END IF;
582:
583: END Check_Parent_Existance;

Line 597: APP_EXCEPTION.RAISE_EXCEPTION;

593: NEW_REFERENCES.award_course_cd,
594: NEW_REFERENCES.award_crs_version_number,
595: NEW_REFERENCES.award_cd) THEN
596: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
597: APP_EXCEPTION.RAISE_EXCEPTION;
598: END IF;
599: END;
600:
601: PROCEDURE Check_Constraints(

Line 643: APP_EXCEPTION.RAISE_EXCEPTION;

639:
640: IF upper(column_name) = 'GRD_CI_SEQUENCE_NUMBER' OR column_name is null then
641: IF NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER < 1 OR NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER > 999999 THEN
642: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_VALUE');
643: APP_EXCEPTION.RAISE_EXCEPTION;
644: END IF;
645: END IF;
646: IF upper(column_name) = 'US_GROUP_NUMBER' OR column_name is null then
647: IF NEW_REFERENCES.US_GROUP_NUMBER < 0 OR NEW_REFERENCES.US_GROUP_NUMBER > 999999 THEN

Line 649: APP_EXCEPTION.RAISE_EXCEPTION;

645: END IF;
646: IF upper(column_name) = 'US_GROUP_NUMBER' OR column_name is null then
647: IF NEW_REFERENCES.US_GROUP_NUMBER < 0 OR NEW_REFERENCES.US_GROUP_NUMBER > 999999 THEN
648: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_VALUE');
649: APP_EXCEPTION.RAISE_EXCEPTION;
650: END IF ;
651: END IF;
652: IF upper(column_name) = 'ORDER_IN_PRESENTATION' OR column_name is null then
653: IF NEW_REFERENCES.ORDER_IN_PRESENTATION < 1 OR NEW_REFERENCES.ORDER_IN_PRESENTATION > 9999 THEN

Line 655: APP_EXCEPTION.RAISE_EXCEPTION;

651: END IF;
652: IF upper(column_name) = 'ORDER_IN_PRESENTATION' OR column_name is null then
653: IF NEW_REFERENCES.ORDER_IN_PRESENTATION < 1 OR NEW_REFERENCES.ORDER_IN_PRESENTATION > 9999 THEN
654: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_VALUE');
655: APP_EXCEPTION.RAISE_EXCEPTION;
656: END IF;
657: END IF;
658: IF upper(column_name) = 'ACADEMIC_DRESS_RQRD_IND' OR column_name is null then
659: IF NEW_REFERENCES.ACADEMIC_DRESS_RQRD_IND NOT IN ( 'Y' , 'N' ) THEN

Line 661: APP_EXCEPTION.RAISE_EXCEPTION;

657: END IF;
658: IF upper(column_name) = 'ACADEMIC_DRESS_RQRD_IND' OR column_name is null then
659: IF NEW_REFERENCES.ACADEMIC_DRESS_RQRD_IND NOT IN ( 'Y' , 'N' ) THEN
660: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_VALUE');
661: APP_EXCEPTION.RAISE_EXCEPTION;
662: END IF;
663: END IF;
664: IF upper(column_name) = 'GUEST_TICKETS_REQUESTED' OR column_name is null then
665: IF NEW_REFERENCES.GUEST_TICKETS_REQUESTED < 0 OR NEW_REFERENCES.GUEST_TICKETS_REQUESTED > 999 THEN

Line 667: APP_EXCEPTION.RAISE_EXCEPTION;

663: END IF;
664: IF upper(column_name) = 'GUEST_TICKETS_REQUESTED' OR column_name is null then
665: IF NEW_REFERENCES.GUEST_TICKETS_REQUESTED < 0 OR NEW_REFERENCES.GUEST_TICKETS_REQUESTED > 999 THEN
666: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_VALUE');
667: APP_EXCEPTION.RAISE_EXCEPTION;
668: END IF;
669: END IF;
670: IF upper(column_name) = 'GUEST_TICKETS_ALLOCATED' OR column_name is null then
671: IF NEW_REFERENCES.GUEST_TICKETS_ALLOCATED < 0 OR NEW_REFERENCES.GUEST_TICKETS_ALLOCATED > 999 THEN

Line 673: APP_EXCEPTION.RAISE_EXCEPTION;

669: END IF;
670: IF upper(column_name) = 'GUEST_TICKETS_ALLOCATED' OR column_name is null then
671: IF NEW_REFERENCES.GUEST_TICKETS_ALLOCATED < 0 OR NEW_REFERENCES.GUEST_TICKETS_ALLOCATED > 999 THEN
672: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_VALUE');
673: APP_EXCEPTION.RAISE_EXCEPTION;
674: END IF;
675: END IF;
676: IF ((UPPER (column_name) = 'ACADEMIC_GOWN_SIZE') OR (column_name IS NULL)) THEN
677: IF (new_references.ACADEMIC_GOWN_SIZE <> UPPER (new_references.ACADEMIC_GOWN_SIZE)) THEN

Line 680: App_Exception.Raise_Exception;

676: IF ((UPPER (column_name) = 'ACADEMIC_GOWN_SIZE') OR (column_name IS NULL)) THEN
677: IF (new_references.ACADEMIC_GOWN_SIZE <> UPPER (new_references.ACADEMIC_GOWN_SIZE)) THEN
678: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
679: IGS_GE_MSG_STACK.ADD;
680: App_Exception.Raise_Exception;
681: END IF;
682: END IF;
683: IF ((UPPER (column_name) = 'ACADEMIC_HAT_SIZE') OR (column_name IS NULL)) THEN
684: IF (new_references.ACADEMIC_HAT_SIZE <> UPPER (new_references.ACADEMIC_HAT_SIZE)) THEN

Line 687: App_Exception.Raise_Exception;

683: IF ((UPPER (column_name) = 'ACADEMIC_HAT_SIZE') OR (column_name IS NULL)) THEN
684: IF (new_references.ACADEMIC_HAT_SIZE <> UPPER (new_references.ACADEMIC_HAT_SIZE)) THEN
685: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
686: IGS_GE_MSG_STACK.ADD;
687: App_Exception.Raise_Exception;
688: END IF;
689: END IF;
690: IF ((UPPER (column_name) = 'AWARD_CD') OR (column_name IS NULL)) THEN
691: IF (new_references.AWARD_CD <> UPPER (new_references.AWARD_CD)) THEN

Line 694: App_Exception.Raise_Exception;

690: IF ((UPPER (column_name) = 'AWARD_CD') OR (column_name IS NULL)) THEN
691: IF (new_references.AWARD_CD <> UPPER (new_references.AWARD_CD)) THEN
692: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
693: IGS_GE_MSG_STACK.ADD;
694: App_Exception.Raise_Exception;
695: END IF;
696: END IF;
697: IF ((UPPER (column_name) = 'AWARD_COURSE_CD') OR (column_name IS NULL)) THEN
698: IF (new_references.AWARD_COURSE_CD <> UPPER (new_references.AWARD_COURSE_CD)) THEN

Line 701: App_Exception.Raise_Exception;

697: IF ((UPPER (column_name) = 'AWARD_COURSE_CD') OR (column_name IS NULL)) THEN
698: IF (new_references.AWARD_COURSE_CD <> UPPER (new_references.AWARD_COURSE_CD)) THEN
699: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
700: IGS_GE_MSG_STACK.ADD;
701: App_Exception.Raise_Exception;
702: END IF;
703: END IF;
704: IF upper(column_name) = 'FEES_PAID_IND' OR column_name is null then
705: IF NEW_REFERENCES.FEES_PAID_IND NOT IN ('Y', 'N') THEN

Line 707: APP_EXCEPTION.RAISE_EXCEPTION;

703: END IF;
704: IF upper(column_name) = 'FEES_PAID_IND' OR column_name is null then
705: IF NEW_REFERENCES.FEES_PAID_IND NOT IN ('Y', 'N') THEN
706: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_VALUE');
707: APP_EXCEPTION.RAISE_EXCEPTION;
708: END IF;
709: END IF;
710: IF ((UPPER (column_name) = 'GRADUAND_SEAT_NUMBER') OR (column_name IS NULL)) THEN
711: IF (new_references.GRADUAND_SEAT_NUMBER <> UPPER (new_references.GRADUAND_SEAT_NUMBER)) THEN

Line 714: App_Exception.Raise_Exception;

710: IF ((UPPER (column_name) = 'GRADUAND_SEAT_NUMBER') OR (column_name IS NULL)) THEN
711: IF (new_references.GRADUAND_SEAT_NUMBER <> UPPER (new_references.GRADUAND_SEAT_NUMBER)) THEN
712: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
713: IGS_GE_MSG_STACK.ADD;
714: App_Exception.Raise_Exception;
715: END IF;
716: END IF;
717: IF ((UPPER (column_name) = 'GRD_CAL_TYPE') OR (column_name IS NULL)) THEN
718: IF (new_references.GRD_CAL_TYPE <> UPPER (new_references.GRD_CAL_TYPE)) THEN

Line 721: App_Exception.Raise_Exception;

717: IF ((UPPER (column_name) = 'GRD_CAL_TYPE') OR (column_name IS NULL)) THEN
718: IF (new_references.GRD_CAL_TYPE <> UPPER (new_references.GRD_CAL_TYPE)) THEN
719: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
720: IGS_GE_MSG_STACK.ADD;
721: App_Exception.Raise_Exception;
722: END IF;
723: END IF;
724: IF ((UPPER (column_name) = 'GUEST_SEATS') OR (column_name IS NULL)) THEN
725: IF (new_references.GUEST_SEATS <> UPPER (new_references.GUEST_SEATS)) THEN

Line 728: App_Exception.Raise_Exception;

724: IF ((UPPER (column_name) = 'GUEST_SEATS') OR (column_name IS NULL)) THEN
725: IF (new_references.GUEST_SEATS <> UPPER (new_references.GUEST_SEATS)) THEN
726: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
727: IGS_GE_MSG_STACK.ADD;
728: App_Exception.Raise_Exception;
729: END IF;
730: END IF;
731: IF ((UPPER (column_name) = 'NAME_ANNOUNCED') OR (column_name IS NULL)) THEN
732: IF (new_references.NAME_ANNOUNCED <> UPPER (new_references.NAME_ANNOUNCED)) THEN

Line 735: App_Exception.Raise_Exception;

731: IF ((UPPER (column_name) = 'NAME_ANNOUNCED') OR (column_name IS NULL)) THEN
732: IF (new_references.NAME_ANNOUNCED <> UPPER (new_references.NAME_ANNOUNCED)) THEN
733: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
734: IGS_GE_MSG_STACK.ADD;
735: App_Exception.Raise_Exception;
736: END IF;
737: END IF;
738: END Check_Constraints;
739:

Line 829: App_Exception.Raise_Exception;

825: IF (cur_rowid%FOUND) THEN
826: Close cur_rowid;
827: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GAC_CRD_FK');
828: IGS_GE_MSG_STACK.ADD;
829: App_Exception.Raise_Exception;
830: Return;
831: END IF;
832: Close cur_rowid;
833:

Line 856: App_Exception.Raise_Exception;

852: IF (cur_rowid%FOUND) THEN
853: Close cur_rowid;
854: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GAC_GOWN_MSR_FK');
855: IGS_GE_MSG_STACK.ADD;
856: App_Exception.Raise_Exception;
857: Return;
858: END IF;
859: Close cur_rowid;
860:

Line 890: App_Exception.Raise_Exception;

886: IF (cur_rowid%FOUND) THEN
887: Close cur_rowid;
888: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GAC_GR_FK');
889: IGS_GE_MSG_STACK.ADD;
890: App_Exception.Raise_Exception;
891: Return;
892: END IF;
893: Close cur_rowid;
894:

Line 928: App_Exception.Raise_Exception;

924: IF (cur_rowid%FOUND) THEN
925: Close cur_rowid;
926: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GAC_ACUSG_FK');
927: IGS_GE_MSG_STACK.ADD;
928: App_Exception.Raise_Exception;
929: Return;
930: END IF;
931: Close cur_rowid;
932:

Line 964: App_Exception.Raise_Exception;

960: IF (cur_rowid%FOUND) THEN
961: Close cur_rowid;
962: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GAC_AWC_FK');
963: IGS_GE_MSG_STACK.ADD;
964: App_Exception.Raise_Exception;
965: Return;
966: END IF;
967: Close cur_rowid;
968:

Line 1048: App_Exception.Raise_Exception;

1044: IF Get_PK_For_Validation (
1045: NEW_REFERENCES.gac_id) THEN
1046: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1047: IGS_GE_MSG_STACK.ADD;
1048: App_Exception.Raise_Exception;
1049: END IF;
1050: Check_Uniqueness;
1051: Check_Constraints;
1052: Check_Parent_Existance;

Line 1065: App_Exception.Raise_Exception;

1061: ELSIF (p_action = 'VALIDATE_INSERT') THEN
1062: IF GET_PK_FOR_VALIDATION(NEW_REFERENCES.GAC_ID) THEN
1063: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1064: IGS_GE_MSG_STACK.ADD;
1065: App_Exception.Raise_Exception;
1066: END IF;
1067: check_uniqueness;
1068: check_constraints;
1069: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 1171: app_exception.raise_exception;

1167: X_PROGRAM_UPDATE_DATE := SYSDATE;
1168: end if;
1169: else
1170: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1171: app_exception.raise_exception;
1172: end if;
1173:
1174: Before_DML (
1175: p_action => 'INSERT',

Line 1349: app_exception.raise_exception;

1345: fetch c1 into tlinfo;
1346: if (c1%notfound) then
1347: close c1;
1348: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1349: app_exception.raise_exception;
1350: return;
1351: end if;
1352: close c1;
1353:

Line 1408: app_exception.raise_exception;

1404: ) then
1405: null;
1406: else
1407: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1408: app_exception.raise_exception;
1409: end if;
1410: return;
1411: end LOCK_ROW;
1412:

Line 1463: app_exception.raise_exception;

1459: X_LAST_UPDATE_LOGIN := -1;
1460: end if;
1461: else
1462: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1463: app_exception.raise_exception;
1464: end if;
1465:
1466: Before_DML (
1467: p_action => 'UPDATE',