DBA Data[Home] [Help]

APPS.IGS_PE_STAT_DETAILS_PKG dependencies on APP_EXCEPTION

Line 112: app_exception.raise_exception;

108: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
109: CLOSE cur_old_ref_values;
110: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 1');
111: igs_ge_msg_stack.ADD;
112: app_exception.raise_exception;
113: RETURN;
114: END IF;
115: CLOSE cur_old_ref_values;
116:

Line 240: App_Exception.Raise_Exception;

236: IF (cur_rowid%FOUND) THEN
237: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PST_CI_FK');
238: Igs_Ge_Msg_Stack.Add;
239: Close cur_rowid;
240: App_Exception.Raise_Exception;
241: Return;
242: END IF;
243: Close cur_rowid;
244: END GET_FK_IGS_CA_INST;

Line 278: App_Exception.Raise_Exception;

274: FETCH cur_rowid INTO lv_rowid;
275: IF (cur_rowid%NOTFOUND) THEN
276: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED 2');
277: IGS_GE_MSG_STACK.ADD;
278: App_Exception.Raise_Exception;
279: END IF;
280: CLOSE cur_rowid;
281:
282: END IF;

Line 295: app_exception.raise_exception;

291: new_references.MATR_SEQUENCE_NUMBER
292: ) THEN
293: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 3');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297:
298: IF (((old_references.INIT_CAL_TYPE = new_references.INIT_CAL_TYPE) AND
299: (old_references.INIT_SEQUENCE_NUMBER = new_references.INIT_SEQUENCE_NUMBER)) OR

Line 309: app_exception.raise_exception;

305: new_references.INIT_SEQUENCE_NUMBER
306: ) THEN
307: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 4');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
311:
312: IF (((old_references.RECENT_CAL_TYPE = new_references.RECENT_CAL_TYPE) AND
313: (old_references.RECENT_SEQUENCE_NUMBER = new_references.RECENT_SEQUENCE_NUMBER)) OR

Line 323: app_exception.raise_exception;

319: new_references.RECENT_SEQUENCE_NUMBER
320: ) THEN
321: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 5');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325:
326: IF (((old_references.CATALOG_CAL_TYPE = new_references.CATALOG_CAL_TYPE) AND
327: (old_references.CATALOG_SEQUENCE_NUMBER = new_references.CATALOG_SEQUENCE_NUMBER)) OR

Line 337: app_exception.raise_exception;

333: new_references.CATALOG_SEQUENCE_NUMBER
334: ) THEN
335: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 6');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339:
340:
341: END Check_Parent_Existance;

Line 478: app_exception.raise_exception;

474: )
475: ) THEN
476: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
477: igs_ge_msg_stack.ADD;
478: app_exception.raise_exception;
479: END IF;
480: ELSIF (p_action = 'UPDATE') THEN
481: -- Call all the procedures related to Before Update.
482: Check_Parent_Existance;

Line 491: app_exception.raise_exception;

487: )
488: ) THEN
489: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
490: igs_ge_msg_stack.ADD;
491: app_exception.raise_exception;
492: END IF;
493: END IF;
494:
495: END before_dml;

Line 602: app_exception.raise_exception;

598: END IF;
599: ELSE
600: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
601: igs_ge_msg_stack.ADD;
602: app_exception.raise_exception;
603: END IF;
604:
605: before_dml(
606: p_action => 'INSERT',

Line 802: app_exception.raise_exception;

798: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
799: fnd_message.set_token ('ERR_CD', SQLCODE);
800: igs_ge_msg_stack.add;
801: igs_sc_gen_001.unset_ctx('R');
802: app_exception.raise_exception;
803: ELSE
804: igs_sc_gen_001.unset_ctx('R');
805: RAISE;
806: END IF;

Line 931: app_exception.raise_exception;

927: IF (c1%NOTFOUND) THEN
928: fnd_message.set_name('FND', 'FORM_RECORD_DELETED 7');
929: igs_ge_msg_stack.ADD;
930: CLOSE c1;
931: app_exception.raise_exception;
932: RETURN;
933: END IF;
934: CLOSE c1;
935:

Line 1030: app_exception.raise_exception;

1026: NULL;
1027: ELSE
1028: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1029: igs_ge_msg_stack.ADD;
1030: app_exception.raise_exception;
1031: END IF;
1032:
1033: RETURN;
1034:

Line 1125: app_exception.raise_exception;

1121: END IF;
1122: ELSE
1123: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1124: igs_ge_msg_stack.ADD;
1125: app_exception.raise_exception;
1126: END IF;
1127:
1128: before_dml(
1129: p_action => 'UPDATE',

Line 1262: app_exception.raise_exception;

1258: IF (SQL%NOTFOUND) THEN
1259: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1260: igs_ge_msg_stack.add;
1261: igs_sc_gen_001.unset_ctx('R');
1262: app_exception.raise_exception;
1263: END IF;
1264: IF (x_mode = 'S') THEN
1265: igs_sc_gen_001.unset_ctx('R');
1266: END IF;

Line 1277: app_exception.raise_exception;

1273: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1274: fnd_message.set_token ('ERR_CD', SQLCODE);
1275: igs_ge_msg_stack.add;
1276: igs_sc_gen_001.unset_ctx('R');
1277: app_exception.raise_exception;
1278: ELSE
1279: igs_sc_gen_001.unset_ctx('R');
1280: RAISE;
1281: END IF;

Line 1499: app_exception.raise_exception;

1495: IF (SQL%NOTFOUND) THEN
1496: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1497: igs_ge_msg_stack.add;
1498: igs_sc_gen_001.unset_ctx('R');
1499: app_exception.raise_exception;
1500: END IF;
1501: IF (x_mode = 'S') THEN
1502: igs_sc_gen_001.unset_ctx('R');
1503: END IF;