DBA Data[Home] [Help]

APPS.IGS_GR_AWD_CRM_UT_ST_PKG dependencies on FND_MESSAGE

Line 43: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

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

Line 95: Fnd_Message.Set_Name('IGS', v_message_name);

91: new_references.award_crs_version_number,
92: new_references.unit_set_cd,
93: new_references.us_version_number,
94: v_message_name) = FALSE THEN
95: Fnd_Message.Set_Name('IGS', v_message_name);
96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98: END IF;
99: END IF;

Line 107: Fnd_Message.Set_Name('IGS', v_message_name);

103: new_references.grd_cal_type,
104: new_references.grd_ci_sequence_number,
105: new_references.ceremony_number,
106: v_message_name) = FALSE THEN
107: Fnd_Message.Set_Name('IGS', v_message_name);
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;

Line 122: Fnd_Message.Set_Name('IGS', v_message_name);

118: new_references.award_course_cd,
119: new_references.award_crs_version_number,
120: new_references.award_cd,
121: v_message_name) = FALSE THEN
122: Fnd_Message.Set_Name('IGS', v_message_name);
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;

Line 138: Fnd_Message.Set_Name('IGS', v_message_name);

134: new_references.award_crs_version_number,
135: new_references.award_cd,
136: new_references.us_group_number,
137: v_message_name) = FALSE THEN
138: Fnd_Message.Set_Name('IGS', v_message_name);
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception;
141: END IF;
142: END IF;

Line 155: Fnd_Message.Set_Name('IGS', v_message_name);

151: NEW_REFERENCES.award_crs_version_number,
152: NEW_REFERENCES.award_cd,
153: NEW_REFERENCES.us_group_number,
154: v_message_name) = FALSE THEN
155: Fnd_Message.Set_Name('IGS', v_message_name);
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;

Line 171: Fnd_Message.Set_Name('IGS', v_message_name);

167: NEW_REFERENCES.award_crs_version_number,
168: NEW_REFERENCES.award_cd,
169: NEW_REFERENCES.us_group_number,
170: v_message_name) = FALSE THEN
171: Fnd_Message.Set_Name('IGS', v_message_name);
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;

Line 189: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

185: NEW_REFERENCES.award_crs_version_number,
186: NEW_REFERENCES.award_cd,
187: NEW_REFERENCES.us_group_number,
188: NEW_REFERENCES.order_in_group) THEN
189: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
190: IGS_GE_MSG_STACK.ADD;
191: App_Exception.Raise_Exception;
192: END IF;
193:

Line 224: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');

220: new_references.award_crs_version_number,
221: new_references.award_cd,
222: new_references.us_group_number
223: ) THEN
224: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228:

Line 240: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');

236: IF NOT IGS_EN_UNIT_SET_PKG.Get_PK_For_Validation (
237: new_references.unit_set_cd,
238: new_references.us_version_number
239: ) THEN
240: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
241: IGS_GE_MSG_STACK.ADD;
242: App_Exception.Raise_Exception;
243: END IF;
244: END IF;

Line 317: Fnd_Message.Set_Name ('IGS', 'IGS_GR_ACUS_ACUSG_FK');

313: Open cur_rowid;
314: Fetch cur_rowid INTO lv_rowid;
315: IF (cur_rowid%FOUND) THEN
316: Close cur_rowid;
317: Fnd_Message.Set_Name ('IGS', 'IGS_GR_ACUS_ACUSG_FK');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: Return;
321: END IF;

Line 345: Fnd_Message.Set_Name ('IGS', 'IGS_GR_ACUS_US_FK');

341: Open cur_rowid;
342: Fetch cur_rowid INTO lv_rowid;
343: IF (cur_rowid%FOUND) THEN
344: Close cur_rowid;
345: Fnd_Message.Set_Name ('IGS', 'IGS_GR_ACUS_US_FK');
346: IGS_GE_MSG_STACK.ADD;
347: App_Exception.Raise_Exception;
348: Return;
349: END IF;

Line 409: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

405: NEW_REFERENCES.us_group_number,
406: NEW_REFERENCES.unit_set_cd,
407: NEW_REFERENCES.us_version_number
408: ) THEN
409: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception;
412: END IF;
413: check_constraints;

Line 439: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

435: NEW_REFERENCES.us_group_number,
436: NEW_REFERENCES.unit_set_cd,
437: NEW_REFERENCES.us_version_number
438: ) THEN
439: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
440: IGS_GE_MSG_STACK.ADD;
441: App_Exception.Raise_Exception;
442: END IF;
443: check_constraints;

Line 498: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

494: if X_LAST_UPDATE_LOGIN is NULL then
495: X_LAST_UPDATE_LOGIN := -1;
496: end if;
497: else
498: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
499: IGS_GE_MSG_STACK.ADD;
500: app_exception.raise_exception;
501: end if;
502:

Line 591: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

587: open c1;
588: fetch c1 into tlinfo;
589: if (c1%notfound) then
590: close c1;
591: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
592: app_exception.raise_exception;
593: return;
594: end if;
595: close c1;

Line 601: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

597: if ( (tlinfo.ORDER_IN_GROUP = X_ORDER_IN_GROUP)
598: ) then
599: null;
600: else
601: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
602: app_exception.raise_exception;
603: end if;
604: return;
605: end LOCK_ROW;

Line 639: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

635: if X_LAST_UPDATE_LOGIN is NULL then
636: X_LAST_UPDATE_LOGIN := -1;
637: end if;
638: else
639: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
640: IGS_GE_MSG_STACK.ADD;
641: app_exception.raise_exception;
642: end if;
643:

Line 825: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

821:
822: IF upper(Column_name) = 'GRD_CI_SEQUENCE' OR column_name IS NULL then
823: IF new_references.grd_ci_sequence_number < 1 AND
824: new_references.grd_ci_sequence_number > 999999 THEN
825: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
826: IGS_GE_MSG_STACK.ADD;
827: App_Exception.Raise_Exception;
828: END IF;
829: END IF;

Line 834: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

830:
831: IF upper(Column_name) = 'US_GROUP_NUMBER' OR column_name IS NULL then
832: IF new_references.us_group_number < 0 AND
833: new_references.us_group_number > 999999 THEN
834: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
835: IGS_GE_MSG_STACK.ADD;
836: App_Exception.Raise_Exception;
837: END IF;
838: END IF;

Line 843: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

839:
840: IF upper(Column_name) = 'US_VERSION_NUMBER' OR column_name IS NULL then
841: IF new_references.us_version_number < 0 AND
842: new_references.us_version_number > 999 THEN
843: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
844: IGS_GE_MSG_STACK.ADD;
845: App_Exception.Raise_Exception;
846: END IF;
847: END IF;

Line 852: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

848:
849: IF upper(Column_name) = 'ORDER_IN_GROUP' OR column_name IS NULL then
850: IF new_references.order_in_group < 0 AND
851: new_references.order_in_group > 999 THEN
852: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
853: IGS_GE_MSG_STACK.ADD;
854: App_Exception.Raise_Exception;
855: END IF;
856: END IF;

Line 860: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

856: END IF;
857:
858: IF upper(Column_name) = 'AWARD_CD' OR COLUMN_NAME IS NULL THEN
859: IF new_references.award_cd <> UPPER(new_references.award_cd) THEN
860: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
861: IGS_GE_MSG_STACK.ADD;
862: App_Exception.Raise_Exception;
863: END IF;
864: END IF;

Line 868: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

864: END IF;
865:
866: IF upper(Column_name) = 'AWARD_COURSE_CD' OR column_name IS NULL then
867: IF new_references.award_course_cd <> UPPER(new_references.award_course_cd) THEN
868: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
869: IGS_GE_MSG_STACK.ADD;
870: App_Exception.Raise_Exception;
871: END IF;
872: END IF;

Line 876: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

872: END IF;
873:
874: IF upper(Column_name) = 'GRD_CAL_TYPE' OR column_name IS NULL then
875: IF new_references.grd_cal_type <> UPPER(new_references.grd_cal_type) THEN
876: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
877: IGS_GE_MSG_STACK.ADD;
878: App_Exception.Raise_Exception;
879: END IF;
880: END IF;

Line 884: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

880: END IF;
881:
882: IF upper(Column_name) = 'UNIT_SET_CD' OR column_name IS NULL then
883: IF new_references.unit_set_cd <> UPPER(new_references.unit_set_cd) THEN
884: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
885: IGS_GE_MSG_STACK.ADD;
886: App_Exception.Raise_Exception;
887: END IF;
888: END IF;