DBA Data[Home] [Help]

APPS.IGS_GR_AWD_CRM_US_GP_PKG dependencies on IGS_GE_MSG_STACK

Line 43: IGS_GE_MSG_STACK.ADD;

39: Fetch cur_old_ref_values INTO old_references;
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;

Line 94: IGS_GE_MSG_STACK.ADD;

90: new_references.grd_ci_sequence_number,
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

Line 109: IGS_GE_MSG_STACK.ADD;

105: new_references.award_crs_version_number,
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:

Line 145: IGS_GE_MSG_STACK.ADD;

141: new_references.award_cd,
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;

Line 166: IGS_GE_MSG_STACK.ADD;

162: NEW_REFERENCES.award_cd,
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:

Line 197: IGS_GE_MSG_STACK.ADD;

193: new_references.award_crs_version_number,
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:

Line 295: IGS_GE_MSG_STACK.ADD;

291: Fetch cur_rowid INTO lv_rowid;
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;

Line 357: IGS_GE_MSG_STACK.ADD;

353: NEW_REFERENCES.award_cd,
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:

Line 386: IGS_GE_MSG_STACK.ADD;

382: NEW_REFERENCES.award_cd,
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;

Line 459: IGS_GE_MSG_STACK.ADD;

455: X_LAST_UPDATE_LOGIN := -1;
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 (

Line 606: IGS_GE_MSG_STACK.ADD;

602: X_LAST_UPDATE_LOGIN := -1;
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 (

Line 790: IGS_GE_MSG_STACK.ADD;

786: IF upper(Column_name) = 'US_GROUP_NUMBER' OR column_name IS NULL then
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

Line 797: IGS_GE_MSG_STACK.ADD;

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
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:

Line 806: IGS_GE_MSG_STACK.ADD;

802: IF upper(Column_name) = 'ORDER_IN_AWARD' OR column_name IS NULL then
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:

Line 815: IGS_GE_MSG_STACK.ADD;

811:
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:

Line 825: IGS_GE_MSG_STACK.ADD;

821:
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: