DBA Data[Home] [Help]

APPS.IGF_SL_ALT_BORW_PKG dependencies on APP_EXCEPTION

Line 123: APP_EXCEPTION.RAISE_EXCEPTION;

119: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
120: CLOSE cur_old_ref_values;
121: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
122: IGS_GE_MSG_STACK.ADD;
123: APP_EXCEPTION.RAISE_EXCEPTION;
124: RETURN;
125: END IF;
126: CLOSE cur_old_ref_values;
127:

Line 243: APP_EXCEPTION.RAISE_EXCEPTION;

239: NULL;
240: ELSIF NOT igf_sl_loans_pkg.get_pk_for_validation ( new_references.loan_id ) THEN
241: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
242: IGS_GE_MSG_STACK.ADD;
243: APP_EXCEPTION.RAISE_EXCEPTION;
244: END IF;
245:
246: END check_parent_existance;
247:

Line 309: APP_EXCEPTION.RAISE_EXCEPTION;

305: IF (cur_rowid%FOUND) THEN
306: CLOSE cur_rowid;
307: FND_MESSAGE.SET_NAME ('IGF', 'IGF_SL_ALBW_LAR_FK');
308: IGS_GE_MSG_STACK.ADD;
309: APP_EXCEPTION.RAISE_EXCEPTION;
310: RETURN;
311: END IF;
312: CLOSE cur_rowid;
313:

Line 511: APP_EXCEPTION.RAISE_EXCEPTION;

507: -- Call all the procedures related to Before Insert.
508: IF ( get_pk_for_validation( new_references.albw_id ) ) THEN
509: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
510: IGS_GE_MSG_STACK.ADD;
511: APP_EXCEPTION.RAISE_EXCEPTION;
512: END IF;
513: check_parent_existance;
514: ELSIF (p_action = 'UPDATE') THEN
515: -- Call all the procedures related to Before Update.

Line 522: APP_EXCEPTION.RAISE_EXCEPTION;

518: -- Call all the procedures related to Before Insert.
519: IF ( get_pk_for_validation ( new_references.albw_id ) ) THEN
520: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
521: IGS_GE_MSG_STACK.ADD;
522: APP_EXCEPTION.RAISE_EXCEPTION;
523: END IF;
524: END IF;
525:
526: END before_dml;

Line 664: APP_EXCEPTION.RAISE_EXCEPTION;

660: END IF;
661: ELSE
662: FND_MESSAGE.SET_NAME ('FND', 'SYSTEM-INVALID ARGS');
663: IGS_GE_MSG_STACK.ADD;
664: APP_EXCEPTION.RAISE_EXCEPTION;
665: END IF;
666:
667: SELECT igf_sl_alt_borw_all_s.NEXTVAL
668: INTO x_albw_id

Line 1140: APP_EXCEPTION.RAISE_EXCEPTION;

1136: IF (c1%notfound) THEN
1137: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1138: IGS_GE_MSG_STACK.ADD;
1139: CLOSE c1;
1140: APP_EXCEPTION.RAISE_EXCEPTION;
1141: RETURN;
1142: END IF;
1143: CLOSE c1;
1144:

Line 1229: APP_EXCEPTION.RAISE_EXCEPTION;

1225: NULL;
1226: ELSE
1227: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1228: IGS_GE_MSG_STACK.ADD;
1229: APP_EXCEPTION.RAISE_EXCEPTION;
1230: END IF;
1231:
1232: RETURN;
1233:

Line 1355: APP_EXCEPTION.RAISE_EXCEPTION;

1351: END IF;
1352: ELSE
1353: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1354: IGS_GE_MSG_STACK.ADD;
1355: APP_EXCEPTION.RAISE_EXCEPTION;
1356: END IF;
1357:
1358: before_dml(
1359: p_action => 'UPDATE',