DBA Data[Home] [Help]

APPS.IGS_RE_CDT_HIST_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 99: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

95: new_references.ATTENDANCE_PERCENTAGE := IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
96: END IF;
97: IF upper(column_name) = 'ACAI_NOMINATED_COURSE_CD' OR COLUMN_NAME IS NULL THEN
98: IF new_references.ACAI_NOMINATED_COURSE_CD <> upper(NEW_REFERENCES.ACAI_NOMINATED_COURSE_CD) then
99: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception ;
102: END IF;
103: END IF;

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

102: END IF;
103: END IF;
104: IF upper(column_name) = 'GOVT_TYPE_OF_ACTIVITY_CD' OR COLUMN_NAME IS NULL THEN
105: IF new_references.GOVT_TYPE_OF_ACTIVITY_CD <> upper(NEW_REFERENCES.GOVT_TYPE_OF_ACTIVITY_CD) then
106: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception ;
109: END IF;
110: END IF;

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

109: END IF;
110: END IF;
111: IF upper(column_name) = 'SCA_COURSE_CD' OR COLUMN_NAME IS NULL THEN
112: IF new_references.SCA_COURSE_CD <> upper(NEW_REFERENCES.SCA_COURSE_CD) then
113: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception ;
116: END IF;
117: END IF;

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

116: END IF;
117: END IF;
118: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
119: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then
120: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception ;
123: END IF;
124: END IF;

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

123: END IF;
124: END IF;
125: IF upper(column_name) = 'ACAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
126: IF new_references.ACAI_SEQUENCE_NUMBER < 1 OR new_references.ACAI_SEQUENCE_NUMBER > 999999 then
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception ;
130: END IF;
131: END IF;

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

130: END IF;
131: END IF;
132: IF upper(column_name) = 'ATTENDANCE_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
133: IF new_references.ATTENDANCE_PERCENTAGE < 1 OR new_references.ATTENDANCE_PERCENTAGE > 100 then
134: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception ;
137: END IF;
138: END IF;

Line 224: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

220: new_references.person_id,
221: new_references.sequence_number,
222: new_references.hist_start_dt
223: ) THEN
224: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: Check_Constraints;

Line 238: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

234: new_references.person_id,
235: new_references.sequence_number,
236: new_references.hist_start_dt
237: ) THEN
238: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;
242: Check_Constraints;

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

285: if X_LAST_UPDATE_LOGIN is NULL then
286: X_LAST_UPDATE_LOGIN := -1;
287: end if;
288: else
289: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
290: IGS_GE_MSG_STACK.ADD;
291: app_exception.raise_exception;
292: end if;
293: Before_DML (

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

407: open c1;
408: fetch c1 into tlinfo;
409: if (c1%notfound) then
410: close c1;
411: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
412: app_exception.raise_exception;
413: return;
414: end if;
415: close c1;

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

447: AND (X_INDUSTRY_LINKS is null)))
448: ) then
449: null;
450: else
451: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
452: app_exception.raise_exception;
453: end if;
454: return;
455: end LOCK_ROW;

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

489: if X_LAST_UPDATE_LOGIN is NULL then
490: X_LAST_UPDATE_LOGIN := -1;
491: end if;
492: else
493: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
494: IGS_GE_MSG_STACK.ADD;
495: app_exception.raise_exception;
496: end if;
497: Before_DML (