APPS.IGS_PR_SDT_PR_UNT_ST_PKG dependencies on IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

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:
42: Return;

Line 81: IGS_GE_MSG_STACK.ADD;

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

Line 99: IGS_GE_MSG_STACK.ADD;

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

Line 163: IGS_GE_MSG_STACK.ADD;

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:
167: Return;

Line 192: IGS_GE_MSG_STACK.ADD;

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:
196: Return;

Line 243: IGS_GE_MSG_STACK.ADD;

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

Line 262: IGS_GE_MSG_STACK.ADD;

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

Line 308: IGS_GE_MSG_STACK.ADD;

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:
312: Before_DML (

Line 371: igs_ge_msg_stack.add;

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
375: igs_sc_gen_001.unset_ctx('R');

Line 404: IGS_GE_MSG_STACK.ADD;

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:
408: return;

Line 423: IGS_GE_MSG_STACK.ADD;

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;
427: return;

Line 447: igs_ge_msg_stack.add;

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;
451: IF (x_mode = 'S') THEN

Line 476: IGS_GE_MSG_STACK.ADD;

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:
480: END IF ;

Line 485: IGS_GE_MSG_STACK.ADD;

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:
489: END IF ;