DBA Data[Home] [Help]

APPS.IGS_FI_CR_TYPES_PKG dependencies on APP_EXCEPTION

Line 89: app_exception.raise_exception;

85: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
86: CLOSE cur_old_ref_values;
87: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
88: igs_ge_msg_stack.add;
89: app_exception.raise_exception;
90: RETURN;
91: END IF;
92: CLOSE cur_old_ref_values;
93:

Line 197: APP_EXCEPTION.RAISE_EXCEPTION;

193: CLOSE cur_overlapping_u;
194: FND_MESSAGE.SET_NAME('IGS','IGS_FI_SUB_ACCT_CR_TYP_EXIST');
195: FND_MESSAGE.SET_TOKEN('CRCLASS',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_CREDIT_CLASS',new_references.credit_class));
196: IGS_GE_MSG_STACK.ADD;
197: APP_EXCEPTION.RAISE_EXCEPTION;
198: END IF;
199: CLOSE cur_overlapping_u;
200: END IF;
201:

Line 224: app_exception.raise_exception;

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

Line 254: App_Exception.Raise_Exception;

250: new_references.cr_account_cd
251: ) THEN
252: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: END IF;
257: IF ((old_references.dr_account_cd = new_references.dr_account_cd) OR
258: (new_references.dr_account_cd IS NULL)) THEN

Line 266: App_Exception.Raise_Exception;

262: new_references.dr_account_cd
263: ) THEN
264: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
265: IGS_GE_MSG_STACK.ADD;
266: App_Exception.Raise_Exception;
267: END IF;
268: END IF;
269:
270: -- Added by sapanigr for Enhancement 4228665.

Line 280: App_Exception.Raise_Exception;

276: new_references.appl_hierarchy_id
277: ) THEN
278: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: END IF;
283:
284: IF (((old_references.credit_class = new_references.credit_class)) OR

Line 293: App_Exception.Raise_Exception;

289: new_references.credit_class
290: )THEN
291: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: END IF;
295:
296: -- Following is added by shtatiko as part of Deposits Build, Bug# 2584741
297: -- Check if any account exists with code new_references.forfeiture_account_cd

Line 307: App_Exception.Raise_Exception;

303: x_account_cd => new_references.forfeiture_account_cd
304: ) THEN
305: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: END IF;
309: END IF;
310:
311: IF ((old_references.payment_credit_type_id = new_references.payment_credit_type_id) OR

Line 320: App_Exception.Raise_Exception;

316: x_credit_type_id => new_references.payment_credit_type_id
317: ) THEN
318: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception;
321: END IF;
322: END IF;
323:
324: END check_parent_existance;

Line 381: App_Exception.Raise_Exception;

377: Fetch cur_rowid INTO lv_rowid;
378: IF (cur_rowid%FOUND) THEN
379: Fnd_Message.Set_Name ('IGS', 'IGS_FI_CRTY_CRTY_FK');
380: IGS_GE_MSG_STACK.ADD;
381: App_Exception.Raise_Exception;
382: Close cur_rowid;
383: Return;
384: END IF;
385: Close cur_rowid;

Line 588: app_exception.raise_exception;

584: )
585: ) THEN
586: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
587: igs_ge_msg_stack.add;
588: app_exception.raise_exception;
589: END IF;
590: check_uniqueness;
591: check_parent_existance;
592: ELSIF (p_action = 'UPDATE') THEN

Line 614: app_exception.raise_exception;

610: )
611: ) THEN
612: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
613: igs_ge_msg_stack.add;
614: app_exception.raise_exception;
615: END IF;
616: check_uniqueness;
617: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
618: BeforeRowInsertUpdate1(p_inserting => FALSE,

Line 714: app_exception.raise_exception;

710: END IF;
711: ELSE
712: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
713: igs_ge_msg_stack.add;
714: app_exception.raise_exception;
715: END IF;
716:
717: SELECT igs_fi_cr_types_s.NEXTVAL
718: INTO x_credit_type_id

Line 984: app_exception.raise_exception;

980: IF (c1%notfound) THEN
981: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
982: igs_ge_msg_stack.add;
983: CLOSE c1;
984: app_exception.raise_exception;
985: RETURN;
986: END IF;
987: CLOSE c1;
988:

Line 1032: app_exception.raise_exception;

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

Line 1120: app_exception.raise_exception;

1116: END IF;
1117: ELSE
1118: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1119: igs_ge_msg_stack.add;
1120: app_exception.raise_exception;
1121: END IF;
1122:
1123: before_dml(
1124: p_action => 'UPDATE',

Line 1435: APP_EXCEPTION.RAISE_EXCEPTION;

1431: -- in the table, explicitly the logic has been coded to prevent the deletion of records.
1432: -- done as part of bug 2404523
1433: FND_MESSAGE.SET_NAME('IGS','IGS_FI_DEL_NOT_ALLWD');
1434: IGS_GE_MSG_STACK.ADD;
1435: APP_EXCEPTION.RAISE_EXCEPTION;
1436: END beforerowdelete;
1437:
1438: END igs_fi_cr_types_pkg;