APPS.IGS_PS_UNITREQREF_CD_PKG dependencies on IGS_GE_MSG_STACK

Line 49: igs_ge_msg_stack.add;

45: FETCH cur_old_ref_values INTO old_references;
46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;

Line 98: igs_ge_msg_stack.add;

94: new_references.reference_code
95: )
96: ) THEN
97: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:
102: END check_uniqueness;

Line 137: igs_ge_msg_stack.add;

133: new_references.reference_code
134: ) THEN
135: CLOSE cur_reference_cd_chk;
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140: END IF;
141: CLOSE cur_reference_cd_chk;

Line 150: igs_ge_msg_stack.add;

146: ELSIF NOT igs_ge_ref_cd_type_pkg.get_pk_for_validation (
147: new_references.reference_cd_type
148: ) THEN
149: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
150: igs_ge_msg_stack.add;
151: app_exception.raise_exception;
152: END IF;
153:
154: END check_parent_existance;

Line 261: igs_ge_msg_stack.add;

257: FETCH cur_rowid INTO lv_rowid;
258: IF (cur_rowid%FOUND) THEN
259: CLOSE cur_rowid;
260: fnd_message.set_name ('IGS', 'IGS_PS_RC_URRC_FK1');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: RETURN;
264: END IF;
265: CLOSE cur_rowid;

Line 296: igs_ge_msg_stack.add;

292: FETCH cur_rowid INTO lv_rowid;
293: IF (cur_rowid%FOUND) THEN
294: CLOSE cur_rowid;
295: fnd_message.set_name ('IGS', 'IGS_PS_RCT_URRC_FK2');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: RETURN;
299: END IF;
300: CLOSE cur_rowid;

Line 355: igs_ge_msg_stack.add;

351: new_references.unit_req_ref_cd_id
352: )
353: ) THEN
354: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
355: igs_ge_msg_stack.add;
356: app_exception.raise_exception;
357: END IF;
358: check_uniqueness;
359: check_parent_existance;

Line 371: igs_ge_msg_stack.add;

367: new_references.unit_req_ref_cd_id
368: )
369: ) THEN
370: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374: check_uniqueness;
375: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 427: igs_ge_msg_stack.add;

423: x_last_update_login := -1;
424: END IF;
425: ELSE
426: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:
431: SELECT igs_ps_unitreqref_cd_s.NEXTVAL

Line 525: igs_ge_msg_stack.add;

521: OPEN c1;
522: FETCH c1 INTO tlinfo;
523: IF (c1%notfound) THEN
524: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
525: igs_ge_msg_stack.add;
526: CLOSE c1;
527: app_exception.raise_exception;
528: RETURN;
529: END IF;

Line 546: igs_ge_msg_stack.add;

542: ) THEN
543: NULL;
544: ELSE
545: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
546: igs_ge_msg_stack.add;
547: app_exception.raise_exception;
548: END IF;
549:
550: RETURN;

Line 595: igs_ge_msg_stack.add;

591: x_last_update_login := -1;
592: END IF;
593: ELSE
594: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
595: igs_ge_msg_stack.add;
596: app_exception.raise_exception;
597: END IF;
598:
599: before_dml(