APPS.IGS_PS_US_REQ_REF_CD_PKG dependencies on IGS_GE_MSG_STACK

Line 48: igs_ge_msg_stack.add;

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

Line 95: igs_ge_msg_stack.add;

91: new_references.reference_code
92: )
93: ) THEN
94: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98:
99: 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 151: igs_ge_msg_stack.add;

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

Line 162: igs_ge_msg_stack.add;

158: ELSIF NOT igs_ps_usec_ref_pkg.get_pk_for_validation (
159: new_references.unit_section_reference_id
160: ) THEN
161: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
162: igs_ge_msg_stack.add;
163: app_exception.raise_exception;
164: END IF;
165:
166: END check_parent_existance;

Line 271: igs_ge_msg_stack.add;

267: FETCH cur_rowid INTO lv_rowid;
268: IF (cur_rowid%FOUND) THEN
269: CLOSE cur_rowid;
270: fnd_message.set_name ('IGS', 'IGS_PS_RC_USRRC_FK1');
271: igs_ge_msg_stack.add;
272: app_exception.raise_exception;
273: RETURN;
274: END IF;
275: CLOSE cur_rowid;

Line 306: igs_ge_msg_stack.add;

302: FETCH cur_rowid INTO lv_rowid;
303: IF (cur_rowid%FOUND) THEN
304: CLOSE cur_rowid;
305: fnd_message.set_name ('IGS', 'IGS_PS_RCT_USRRC_FK2');
306: igs_ge_msg_stack.add;
307: app_exception.raise_exception;
308: RETURN;
309: END IF;
310: CLOSE cur_rowid;

Line 341: igs_ge_msg_stack.add;

337: FETCH cur_rowid INTO lv_rowid;
338: IF (cur_rowid%FOUND) THEN
339: CLOSE cur_rowid;
340: fnd_message.set_name ('IGS', 'IGS_PS_USR_USRRC_FK3');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: RETURN;
344: END IF;
345: CLOSE cur_rowid;

Line 398: igs_ge_msg_stack.add;

394: new_references.unit_section_req_ref_cd_id
395: )
396: ) THEN
397: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
398: igs_ge_msg_stack.add;
399: app_exception.raise_exception;
400: END IF;
401: check_uniqueness;
402: check_parent_existance;

Line 414: igs_ge_msg_stack.add;

410: new_references.unit_section_req_ref_cd_id
411: )
412: ) THEN
413: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
414: igs_ge_msg_stack.add;
415: app_exception.raise_exception;
416: END IF;
417: check_uniqueness;
418: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 471: igs_ge_msg_stack.add;

467: x_last_update_login := -1;
468: END IF;
469: ELSE
470: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
471: igs_ge_msg_stack.add;
472: app_exception.raise_exception;
473: END IF;
474:
475: SELECT igs_ps_us_req_ref_cd_s.NEXTVAL

Line 564: igs_ge_msg_stack.add;

560: OPEN c1;
561: FETCH c1 INTO tlinfo;
562: IF (c1%notfound) THEN
563: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
564: igs_ge_msg_stack.add;
565: CLOSE c1;
566: app_exception.raise_exception;
567: RETURN;
568: END IF;

Line 584: igs_ge_msg_stack.add;

580: ) THEN
581: NULL;
582: ELSE
583: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
584: igs_ge_msg_stack.add;
585: app_exception.raise_exception;
586: END IF;
587:
588: RETURN;

Line 632: igs_ge_msg_stack.add;

628: x_last_update_login := -1;
629: END IF;
630: ELSE
631: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
632: igs_ge_msg_stack.add;
633: app_exception.raise_exception;
634: END IF;
635:
636: before_dml(