DBA Data[Home] [Help]

APPS.IGS_UC_APP_CHOICES_PKG dependencies on APP_EXCEPTION

Line 102: app_exception.raise_exception;

98: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
99: CLOSE cur_old_ref_values;
100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: RETURN;
104: END IF;
105: CLOSE cur_old_ref_values;
106:

Line 221: app_exception.raise_exception;

217: )
218: ) THEN
219: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
220: igs_ge_msg_stack.add;
221: app_exception.raise_exception;
222: END IF;
223:
224: END check_uniqueness;
225:

Line 255: app_exception.raise_exception;

251: new_references.app_id
252: ) THEN
253: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END IF;
257:
258: IF (((old_references.condition_category = new_references.condition_category) AND
259: (old_references.condition_code = new_references.condition_code)) OR

Line 269: app_exception.raise_exception;

265: new_references.condition_code
266: ) THEN
267: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
268: igs_ge_msg_stack.add;
269: app_exception.raise_exception;
270: END IF;
271:
272: IF (
273: (

Line 304: app_exception.raise_exception;

300: new_references.system_code) THEN
301:
302: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305:
306: END IF;
307: END IF;
308:

Line 417: app_exception.raise_exception;

413: IF (cur_rowid%FOUND) THEN
414: CLOSE cur_rowid;
415: fnd_message.set_name ('IGS', 'IGS_UC_UCAPCH_UCAP_FK');
416: igs_ge_msg_stack.add;
417: app_exception.raise_exception;
418: RETURN;
419: END IF;
420: CLOSE cur_rowid;
421:

Line 456: app_exception.raise_exception;

452: IF (cur_rowid%FOUND) THEN
453: CLOSE cur_rowid;
454: fnd_message.set_name ('IGS', 'IGS_UC_UCAPCH_UCOC_FK');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: RETURN;
458: END IF;
459: CLOSE cur_rowid;
460:

Line 497: app_exception.raise_exception;

493: IF (cur_rowid%FOUND) THEN
494: CLOSE cur_rowid;
495: fnd_message.set_name ('IGS', 'IGS_UC_UCAPCH_UCCSDE_FK');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: RETURN;
499: END IF;
500: CLOSE cur_rowid;
501:

Line 660: app_exception.raise_exception;

656: )
657: ) THEN
658: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
659: igs_ge_msg_stack.add;
660: app_exception.raise_exception;
661: END IF;
662: check_uniqueness;
663: check_parent_existance;
664: ELSIF (p_action = 'UPDATE') THEN

Line 676: app_exception.raise_exception;

672: )
673: ) THEN
674: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
675: igs_ge_msg_stack.add;
676: app_exception.raise_exception;
677: END IF;
678: check_uniqueness;
679: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
680: check_uniqueness;

Line 791: app_exception.raise_exception;

787: END IF;
788: ELSE
789: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
790: igs_ge_msg_stack.add;
791: app_exception.raise_exception;
792: END IF;
793:
794: SELECT igs_uc_app_choices_s.NEXTVAL
795: INTO x_app_choice_id

Line 1017: app_exception.raise_exception;

1013: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1014: fnd_message.set_token ('ERR_CD', SQLCODE);
1015: igs_ge_msg_stack.add;
1016: igs_sc_gen_001.unset_ctx('R');
1017: app_exception.raise_exception;
1018: ELSE
1019: igs_sc_gen_001.unset_ctx('R');
1020: RAISE;
1021: END IF;

Line 1170: app_exception.raise_exception;

1166: IF (c1%notfound) THEN
1167: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1168: igs_ge_msg_stack.add;
1169: CLOSE c1;
1170: app_exception.raise_exception;
1171: RETURN;
1172: END IF;
1173: CLOSE c1;
1174:

Line 1237: app_exception.raise_exception;

1233: NULL;
1234: ELSE
1235: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1236: igs_ge_msg_stack.add;
1237: app_exception.raise_exception;
1238: END IF;
1239:
1240: RETURN;
1241:

Line 1340: app_exception.raise_exception;

1336: END IF;
1337: ELSE
1338: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1339: igs_ge_msg_stack.add;
1340: app_exception.raise_exception;
1341: END IF;
1342:
1343: before_dml(
1344: p_action => 'UPDATE',

Line 1481: app_exception.raise_exception;

1477: IF (SQL%NOTFOUND) THEN
1478: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1479: igs_ge_msg_stack.add;
1480: igs_sc_gen_001.unset_ctx('R');
1481: app_exception.raise_exception;
1482: END IF;
1483: IF (x_mode = 'S') THEN
1484: igs_sc_gen_001.unset_ctx('R');
1485: END IF;

Line 1494: app_exception.raise_exception;

1490: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1491: fnd_message.set_token ('ERR_CD', SQLCODE);
1492: igs_ge_msg_stack.add;
1493: igs_sc_gen_001.unset_ctx('R');
1494: app_exception.raise_exception;
1495: ELSE
1496: igs_sc_gen_001.unset_ctx('R');
1497: RAISE;
1498: END IF;

Line 1748: app_exception.raise_exception;

1744: IF (SQL%NOTFOUND) THEN
1745: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1746: igs_ge_msg_stack.add;
1747: igs_sc_gen_001.unset_ctx('R');
1748: app_exception.raise_exception;
1749: END IF;
1750: IF (x_mode = 'S') THEN
1751: igs_sc_gen_001.unset_ctx('R');
1752: END IF;