APPS.IGF_SL_LOR_LOC_PKG dependencies on APP_EXCEPTION

Line 240: app_exception.raise_exception;

236: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
237: CLOSE cur_old_ref_values;
238: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
239: igs_ge_msg_stack.add;
240: app_exception.raise_exception;
241: RETURN;
242: END IF;
243: CLOSE cur_old_ref_values;
244:

Line 473: app_exception.raise_exception;

469: )
470: ) THEN
471: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
472: igs_ge_msg_stack.add;
473: app_exception.raise_exception;
474: END IF;
475:
476: END check_uniqueness;
477:

Line 499: app_exception.raise_exception;

495: new_references.origination_id
496: ) THEN
497: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
498: igs_ge_msg_stack.add;
499: app_exception.raise_exception;
500: END IF;
501:
502: IF (((old_references.award_id = new_references.award_id)) OR
503: ((new_references.award_id IS NULL))) THEN

Line 510: app_exception.raise_exception;

506: new_references.award_id
507: ) THEN
508: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
509: igs_ge_msg_stack.add;
510: app_exception.raise_exception;
511: END IF;
512:
513: IF (((old_references.base_id = new_references.base_id)) OR
514: ((new_references.base_id IS NULL))) THEN

Line 521: app_exception.raise_exception;

517: new_references.base_id
518: ) THEN
519: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
520: igs_ge_msg_stack.add;
521: app_exception.raise_exception;
522: END IF;
523:
524: END check_parent_existance;
525:

Line 624: app_exception.raise_exception;

620: IF (cur_rowid%FOUND) THEN
621: CLOSE cur_rowid;
622: fnd_message.set_name ('IGF', 'IGF_SL_LORL_LOR_FK');
623: igs_ge_msg_stack.add;
624: app_exception.raise_exception;
625: RETURN;
626: END IF;
627: CLOSE cur_rowid;
628:

Line 650: app_exception.raise_exception;

646: IF (cur_rowid%FOUND) THEN
647: CLOSE cur_rowid;
648: fnd_message.set_name ('IGF', 'IGF_AW_AWD_LORLOC_FK');
649: igs_ge_msg_stack.add;
650: app_exception.raise_exception;
651: RETURN;
652: END IF;
653: CLOSE cur_rowid;
654:

Line 676: app_exception.raise_exception;

672: IF (cur_rowid%FOUND) THEN
673: CLOSE cur_rowid;
674: fnd_message.set_name ('IGF', 'IGF_AP_FABASE_LORLOC_FK');
675: igs_ge_msg_stack.add;
676: app_exception.raise_exception;
677: RETURN;
678: END IF;
679: CLOSE cur_rowid;
680:

Line 1116: app_exception.raise_exception;

1112: )
1113: ) THEN
1114: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1115: igs_ge_msg_stack.add;
1116: app_exception.raise_exception;
1117: END IF;
1118: check_uniqueness;
1119: check_parent_existance;
1120: ELSIF (p_action = 'UPDATE') THEN

Line 1132: app_exception.raise_exception;

1128: )
1129: ) THEN
1130: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1131: igs_ge_msg_stack.add;
1132: app_exception.raise_exception;
1133: END IF;
1134: check_uniqueness;
1135: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
1136: check_uniqueness;

Line 1395: app_exception.raise_exception;

1391: END IF;
1392: ELSE
1393: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1394: igs_ge_msg_stack.add;
1395: app_exception.raise_exception;
1396: END IF;
1397:
1398: before_dml(
1399: p_action => 'INSERT',

Line 2447: app_exception.raise_exception;

2443: IF (c1%notfound) THEN
2444: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2445: igs_ge_msg_stack.add;
2446: CLOSE c1;
2447: app_exception.raise_exception;
2448: RETURN;
2449: END IF;
2450: CLOSE c1;
2451:

Line 2636: app_exception.raise_exception;

2632: NULL;
2633: ELSE
2634: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2635: igs_ge_msg_stack.add;
2636: app_exception.raise_exception;
2637: END IF;
2638:
2639: RETURN;
2640:

Line 2879: app_exception.raise_exception;

2875: END IF;
2876: ELSE
2877: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
2878: igs_ge_msg_stack.add;
2879: app_exception.raise_exception;
2880: END IF;
2881:
2882: before_dml(
2883: p_action => 'UPDATE',