APPS.IGS_PS_US_REQ_REF_CD_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 96: app_exception.raise_exception;

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

Line 138: app_exception.raise_exception;

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

Line 152: app_exception.raise_exception;

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
156: ((new_references.unit_section_reference_id IS NULL))) THEN

Line 163: app_exception.raise_exception;

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

Line 272: app_exception.raise_exception;

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

Line 307: app_exception.raise_exception;

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

Line 342: app_exception.raise_exception;

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

Line 399: app_exception.raise_exception;

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;
403: ELSIF (p_action = 'UPDATE') THEN

Line 415: app_exception.raise_exception;

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
419: check_uniqueness;

Line 472: app_exception.raise_exception;

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
476: INTO x_unit_section_req_ref_cd_id

Line 566: app_exception.raise_exception;

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;
569: CLOSE c1;
570:

Line 585: app_exception.raise_exception;

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

Line 633: app_exception.raise_exception;

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(
637: p_action => 'UPDATE',