DBA Data[Home] [Help]

APPS.IGF_SP_STD_UNIT_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 122: app_exception.raise_exception;

118: new_references.fee_cls_prg_id
119: ) THEN
120: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
121: igs_ge_msg_stack.add;
122: app_exception.raise_exception;
123: END IF;
124:
125: IF (((old_references.unit_cd = new_references.unit_cd) AND
126: (old_references.version_number = new_references.version_number)) OR

Line 136: app_exception.raise_exception;

132: new_references.version_number
133: ) THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
139: END check_parent_existance;
140:

Line 243: app_exception.raise_exception;

239: IF (cur_rowid%FOUND) THEN
240: CLOSE cur_rowid;
241: fnd_message.set_name ('IGF', 'IGF_SP_STDU_SDFCP_FK');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: RETURN;
245: END IF;
246: CLOSE cur_rowid;
247:

Line 279: app_exception.raise_exception;

275: IF (cur_rowid%FOUND) THEN
276: CLOSE cur_rowid;
277: fnd_message.set_name ('IGF', 'IGF_SP_STDU_UV_FK');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: RETURN;
281: END IF;
282: CLOSE cur_rowid;
283: END get_fk_igs_ps_unit_ver;

Line 336: app_exception.raise_exception;

332: )
333: ) THEN
334: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
335: igs_ge_msg_stack.add;
336: app_exception.raise_exception;
337: END IF;
338: check_uniqueness;
339: check_parent_existance;
340: ELSIF (p_action = 'UPDATE') THEN

Line 352: app_exception.raise_exception;

348: )
349: ) THEN
350: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354: check_uniqueness;
355: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
356: check_uniqueness;

Line 407: app_exception.raise_exception;

403: END IF;
404: ELSE
405: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
406: igs_ge_msg_stack.add;
407: app_exception.raise_exception;
408: END IF;
409:
410: SELECT igf_sp_std_unit_s.NEXTVAL
411: INTO x_fee_cls_unit_id

Line 505: app_exception.raise_exception;

501: IF (c1%notfound) THEN
502: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
503: igs_ge_msg_stack.add;
504: CLOSE c1;
505: app_exception.raise_exception;
506: RETURN;
507: END IF;
508: CLOSE c1;
509:

Line 520: app_exception.raise_exception;

516: NULL;
517: ELSE
518: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
519: igs_ge_msg_stack.add;
520: app_exception.raise_exception;
521: END IF;
522:
523: RETURN;
524:

Line 568: app_exception.raise_exception;

564: END IF;
565: ELSE
566: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
567: igs_ge_msg_stack.add;
568: app_exception.raise_exception;
569: END IF;
570:
571: before_dml(
572: p_action => 'UPDATE',