DBA Data[Home] [Help]

APPS.IGS_PR_SDT_PR_UNT_ST_PKG dependencies on FND_MESSAGE

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

33: -- Populate Old Values.
34: Open cur_old_ref_values;
35: Fetch cur_old_ref_values INTO old_references;
36: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: Close cur_old_ref_values;
40: App_Exception.Raise_Exception;
41:

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

76: new_references.person_id,
77: new_references.course_cd,
78: new_references.spo_sequence_number
79: )THEN
80: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83:
84: END IF;

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

94: IF NOT IGS_EN_UNIT_SET_PKG.Get_PK_For_Validation (
95: new_references.unit_set_cd,
96: new_references.version_number
97: )THEN
98: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101:
102: END IF;

Line 162: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPUS_SPO_FK');

158:
159: Open cur_rowid;
160: Fetch cur_rowid INTO lv_rowid;
161: IF (cur_rowid%FOUND) THEN
162: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPUS_SPO_FK');
163: IGS_GE_MSG_STACK.ADD;
164: Close cur_rowid;
165: App_Exception.Raise_Exception;
166:

Line 191: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPUS_US_FK');

187:
188: Open cur_rowid;
189: Fetch cur_rowid INTO lv_rowid;
190: IF (cur_rowid%FOUND) THEN
191: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPUS_US_FK');
192: IGS_GE_MSG_STACK.ADD;
193: Close cur_rowid;
194: App_Exception.Raise_Exception;
195:

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

238: new_references.course_cd,
239: new_references.spo_sequence_number,
240: new_references.unit_set_cd,
241: new_references.version_number) THEN
242: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245: END IF;
246: CHECK_CONSTRAINTS;

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

257: new_references.course_cd,
258: new_references.spo_sequence_number,
259: new_references.unit_set_cd,
260: new_references.version_number) THEN
261: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: CHECK_CONSTRAINTS;

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

303: if X_LAST_UPDATE_LOGIN is NULL then
304: X_LAST_UPDATE_LOGIN := -1;
305: end if;
306: else
307: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
308: IGS_GE_MSG_STACK.ADD;
309: app_exception.raise_exception;
310: end if;
311:

Line 369: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

365:
366: EXCEPTION
367: WHEN OTHERS THEN
368: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
369: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
370: fnd_message.set_token ('ERR_CD', SQLCODE);
371: igs_ge_msg_stack.add;
372: igs_sc_gen_001.unset_ctx('R');
373: app_exception.raise_exception;

Line 370: fnd_message.set_token ('ERR_CD', SQLCODE);

366: EXCEPTION
367: WHEN OTHERS THEN
368: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
369: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
370: fnd_message.set_token ('ERR_CD', SQLCODE);
371: igs_ge_msg_stack.add;
372: igs_sc_gen_001.unset_ctx('R');
373: app_exception.raise_exception;
374: ELSE

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

399: begin
400: open c1;
401: fetch c1 into tlinfo;
402: if (c1%notfound) then
403: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
404: IGS_GE_MSG_STACK.ADD;
405: close c1;
406: app_exception.raise_exception;
407:

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

418: )
419: then
420: null;
421: else
422: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
423: IGS_GE_MSG_STACK.ADD;
424: app_exception.raise_exception;
425: end if;
426: return;

Line 446: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

442: END IF;
443: delete from IGS_PR_SDT_PR_UNT_ST
444: where ROWID = X_ROWID;
445: if (sql%notfound) then
446: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
447: igs_ge_msg_stack.add;
448: igs_sc_gen_001.unset_ctx('R');
449: app_exception.raise_exception;
450: end if;

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

471: END IF ;
472:
473: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
474: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
475: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
476: IGS_GE_MSG_STACK.ADD;
477: App_Exception.Raise_Exception ;
478: END IF;
479:

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

480: END IF ;
481:
482: IF upper(Column_name) = 'UNIT_SET_CD' OR COLUMN_NAME IS NULL THEN
483: IF new_references.UNIT_SET_CD<> upper(new_references.UNIT_SET_CD) then
484: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception ;
487: END IF;
488: