APPS.IGS_GR_AWD_CRM_US_GP_PKG dependencies on APP_EXCEPTION

Line 44: App_Exception.Raise_Exception;

40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
41: Close cur_old_ref_values;
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: Return;
46: END IF;
47: Close cur_old_ref_values;
48:

Line 95: App_Exception.Raise_Exception;

91: new_references.ceremony_number,
92: v_message_name) = FALSE THEN
93: Fnd_Message.Set_Name('IGS', v_message_name);
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: END IF;
97: END IF;
98: -- Validate the award ceremony is not closed
99: IF p_inserting OR p_updating THEN

Line 110: App_Exception.Raise_Exception;

106: new_references.award_cd,
107: v_message_name) = FALSE THEN
108: Fnd_Message.Set_Name('IGS', v_message_name);
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
113:
114:

Line 146: App_Exception.Raise_Exception;

142: new_references.us_group_number,
143: v_message_name) = FALSE THEN
144: Fnd_Message.Set_Name('IGS', v_message_name);
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: v_rowid_saved := TRUE;
149: END IF;
150:

Line 167: App_Exception.Raise_Exception;

163: NEW_REFERENCES.order_in_award
164: ) THEN
165: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: END Check_Uniqueness;
170:
171: PROCEDURE Check_Parent_Existance AS

Line 198: App_Exception.Raise_Exception;

194: new_references.award_cd
195: ) THEN
196: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200: END IF;
201:
202: END Check_Parent_Existance;

Line 296: App_Exception.Raise_Exception;

292: IF (cur_rowid%FOUND) THEN
293: Close cur_rowid;
294: Fnd_Message.Set_Name ('IGS', 'IGS_GR_ACUSG_AWC_FK');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: Return;
298: END IF;
299: Close cur_rowid;
300:

Line 358: App_Exception.Raise_Exception;

354: NEW_REFERENCES.us_group_number
355: ) THEN
356: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
357: IGS_GE_MSG_STACK.ADD;
358: App_Exception.Raise_Exception;
359:
360: END IF;
361:
362: Check_Constraints;

Line 387: App_Exception.Raise_Exception;

383: NEW_REFERENCES.us_group_number
384: ) THEN
385: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
386: IGS_GE_MSG_STACK.ADD;
387: App_Exception.Raise_Exception;
388:
389: END IF;
390: Check_Constraints;
391: Check_uniqueness;

Line 460: app_exception.raise_exception;

456: end if;
457: else
458: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
459: IGS_GE_MSG_STACK.ADD;
460: app_exception.raise_exception;
461: end if;
462:
463: Before_DML (
464: p_action => 'INSERT',

Line 554: app_exception.raise_exception;

550: fetch c1 into tlinfo;
551: if (c1%notfound) then
552: close c1;
553: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
554: app_exception.raise_exception;
555: return;
556: end if;
557: close c1;
558:

Line 568: app_exception.raise_exception;

564: ) then
565: null;
566: else
567: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
568: app_exception.raise_exception;
569: end if;
570: return;
571: end LOCK_ROW;
572:

Line 607: app_exception.raise_exception;

603: end if;
604: else
605: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
606: IGS_GE_MSG_STACK.ADD;
607: app_exception.raise_exception;
608: end if;
609:
610: Before_DML (
611: p_action => 'UPDATE',

Line 791: App_Exception.Raise_Exception;

787: IF new_references.us_group_number < 0 OR
788: new_references.us_group_number > 999999 THEN
789: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
790: IGS_GE_MSG_STACK.ADD;
791: App_Exception.Raise_Exception;
792: END IF;
793: END IF;
794: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
795: IF new_references.closed_ind NOT IN('Y','N') THEN

Line 798: App_Exception.Raise_Exception;

794: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
795: IF new_references.closed_ind NOT IN('Y','N') THEN
796: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
797: IGS_GE_MSG_STACK.ADD;
798: App_Exception.Raise_Exception;
799: END IF;
800: END IF;
801:
802: IF upper(Column_name) = 'ORDER_IN_AWARD' OR column_name IS NULL then

Line 807: App_Exception.Raise_Exception;

803: IF new_references.ORDER_IN_AWARD < 0 OR
804: new_references.ORDER_IN_AWARD > 999 THEN
805: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
806: IGS_GE_MSG_STACK.ADD;
807: App_Exception.Raise_Exception;
808: END IF;
809: END IF;
810:
811:

Line 816: App_Exception.Raise_Exception;

812: IF upper(Column_name) = 'AWARD_CD' OR COLUMN_NAME IS NULL THEN
813: IF new_references.award_cd <> UPPER(new_references.award_cd) THEN
814: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
815: IGS_GE_MSG_STACK.ADD;
816: App_Exception.Raise_Exception;
817: END IF;
818: END IF;
819:
820:

Line 826: App_Exception.Raise_Exception;

822: IF upper(Column_name) = 'AWARD_COURSE_CD' OR column_name IS NULL then
823: IF new_references.award_course_cd <> UPPER(new_references.award_course_cd) THEN
824: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
825: IGS_GE_MSG_STACK.ADD;
826: App_Exception.Raise_Exception;
827: END IF;
828: END IF;
829:
830: IF upper(Column_name) = 'GRD_CAL_TYPE' OR column_name IS NULL then

Line 833: App_Exception.Raise_Exception;

829:
830: IF upper(Column_name) = 'GRD_CAL_TYPE' OR column_name IS NULL then
831: IF new_references.grd_cal_type <> UPPER(new_references.grd_cal_type) THEN
832: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
833: App_Exception.Raise_Exception;
834: END IF;
835: END IF;
836:
837: END Check_Constraints;