APPS.IGR_I_PKGITM_ASSIGN_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 132: app_exception.raise_exception;

128: )
129: ) THEN
130: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
131: igs_ge_msg_stack.add;
132: app_exception.raise_exception;
133: END IF;
134:
135: END check_uniqueness;
136:

Line 227: app_exception.raise_exception;

223: new_references.package_item_id
224: ) THEN
225: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
226: igs_ge_msg_stack.add;
227: app_exception.raise_exception;
228: END IF;
229:
230: IF (((old_references.product_category_id = new_references.product_category_id)) OR
231: ((new_references.product_category_id IS NULL))) THEN

Line 238: app_exception.raise_exception;

234: new_references.product_category_id
235: ) THEN
236: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
237: igs_ge_msg_stack.add;
238: app_exception.raise_exception;
239: END IF;
240:
241:
242: IF (((old_references.product_category_set_id = new_references.product_category_set_id)) OR

Line 250: app_exception.raise_exception;

246: new_references.product_category_set_id
247: ) THEN
248: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
249: igs_ge_msg_stack.add;
250: app_exception.raise_exception;
251: END IF;
252:
253: END check_parent_existance;
254:

Line 318: app_exception.raise_exception;

314: IF (cur_rowid%FOUND) THEN
315: CLOSE cur_rowid;
316: fnd_message.set_name ('IGS', ' IGR_PITM_PASITM_FK');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: RETURN;
320: END IF;
321: CLOSE cur_rowid;
322:

Line 375: app_exception.raise_exception;

371: )
372: ) THEN
373: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377: check_parent_existance;
378: check_uniqueness;
379: ELSIF (p_action = 'UPDATE') THEN

Line 391: app_exception.raise_exception;

387: )
388: ) THEN
389: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
390: igs_ge_msg_stack.add;
391: app_exception.raise_exception;
392: END IF;
393: check_uniqueness;
394: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
395: check_uniqueness;

Line 444: app_exception.raise_exception;

440: ELSE
441: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
442: fnd_message.set_token ('ROUTINE', 'IGR_I_PKGITM_ASSIGN_PKG.INSERT_ROW');
443: igs_ge_msg_stack.add;
444: app_exception.raise_exception;
445: END IF;
446:
447: x_pkg_item_assign_id := NULL;
448:

Line 528: app_exception.raise_exception;

524: IF (c1%notfound) THEN
525: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
526: igs_ge_msg_stack.add;
527: CLOSE c1;
528: app_exception.raise_exception;
529: RETURN;
530: END IF;
531: CLOSE c1;
532:

Line 543: app_exception.raise_exception;

539: NULL;
540: ELSE
541: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
542: igs_ge_msg_stack.add;
543: app_exception.raise_exception;
544: END IF;
545:
546: RETURN;
547:

Line 592: app_exception.raise_exception;

588: ELSE
589: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
590: fnd_message.set_token ('ROUTINE', 'IGR_I_PKGITM_ASSIGN_PKG.UPDATE_ROW');
591: igs_ge_msg_stack.add;
592: app_exception.raise_exception;
593: END IF;
594:
595: before_dml(
596: p_action => 'UPDATE',