APPS.PA_EXPENDITURE_GROUPS_PKG dependencies on APP_EXCEPTION

Line 90: app_exception.raise_exception;

86: -- we bypass the error checking that submit does, since
87: -- it should already have been done at the form level
88: execute_submit (x_expenditure_group, x_err_code, x_return_status);
89: if (x_err_code = 1) then
90: app_exception.raise_exception;
91: end if;
92: end if;
93:
94: END insert_row;

Line 148: app_exception.raise_exception;

144: -- we bypass the error checking that submit does, since
145: -- it should already have been done at the form level
146: execute_submit (x_expenditure_group, x_err_code, x_return_status);
147: if (x_err_code = 1) then
148: app_exception.raise_exception;
149: end if;
150:
151: -- added the below update for the bug 12547691
152: update pa_expenditures

Line 164: app_exception.raise_exception;

160: if ((x_expenditure_group_status = 'RELEASED') and
161: (x_orig_group.expenditure_group_status_code <> 'RELEASED')) then
162: release (x_expenditure_group, x_err_code, x_return_status);
163: if (x_err_code = 1) then
164: app_exception.raise_exception;
165: end if;
166:
167: -- added the below update for the bug 12547691
168: update pa_expenditures

Line 180: app_exception.raise_exception;

176: if ((x_expenditure_group_status = 'WORKING') and
177: (x_orig_group.expenditure_group_status_code <> 'WORKING')) then
178: rework (x_expenditure_group, x_err_code, x_return_status);
179: if (x_err_code = 1) then
180: app_exception.raise_exception;
181: end if;
182:
183: -- added the below update for the bug 12547691
184: update pa_expenditures

Line 213: app_exception.raise_exception;

209: -- check notfound?
210:
211: if (groups_rec.expenditure_group_status_code <> 'WORKING') then
212: fnd_message.set_name ('PA', 'PA_TR_EPE_ONLY_DEL_WORK');
213: app_exception.raise_exception;
214: end if;
215:
216: -- cascade delete to expenditures.
217: DECLARE

Line 240: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

236: end if;
237: END LOOP;
238:
239: EXCEPTION
240: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
241: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
242: app_exception.raise_exception;
243: END;
244:

Line 242: app_exception.raise_exception;

238:
239: EXCEPTION
240: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
241: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
242: app_exception.raise_exception;
243: END;
244:
245: delete from pa_expenditure_groups
246: where rowid = x_rowid;

Line 329: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

325: p_exp_status_code => 'APPROVED' );
326:
327:
328: EXCEPTION
329: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
330: x_err_code := 1;
331: x_return_status := 'Could not lock expenditures';
332: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
333: END release;

Line 395: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

391:
392:
393:
394: EXCEPTION
395: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
396: x_err_code := 1;
397: x_return_status := 'Could not lock expenditures';
398: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
399: END rework;

Line 447: -- app_exception.raise_exception;

443: if (x_orig_group.expenditure_group_status_code <> 'WORKING') then
444: x_err_code := 1;
445: x_return_status := 'Can only submit working';
446: fnd_message.set_name ('PA', 'PA_TR_EPE_SUBMIT_ONLY_WORK');
447: -- app_exception.raise_exception;
448: return;
449: end if;
450:
451: -- Check that expenditure items exist for the group

Line 466: -- app_exception.raise_exception;

462: if (x_count = 0) then
463: x_err_code := 1;
464: x_return_status := 'Exp items must exist';
465: fnd_message.set_name ('PA', 'PA_TR_EPE_SUBMIT_NO_ITEMS');
466: -- app_exception.raise_exception;
467: return;
468: end if;
469: END;
470:

Line 577: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

573:
574:
575:
576: EXCEPTION
577: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
578: x_err_code := 1;
579: x_return_status := 'Could not lock expenditures';
580: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
581: END execute_submit;