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: end if;
151:
152: if ((x_expenditure_group_status = 'RELEASED') and

Line 156: app_exception.raise_exception;

152: if ((x_expenditure_group_status = 'RELEASED') and
153: (x_orig_group.expenditure_group_status_code <> 'RELEASED')) then
154: release (x_expenditure_group, x_err_code, x_return_status);
155: if (x_err_code = 1) then
156: app_exception.raise_exception;
157: end if;
158: end if;
159:
160: if ((x_expenditure_group_status = 'WORKING') and

Line 164: app_exception.raise_exception;

160: if ((x_expenditure_group_status = 'WORKING') and
161: (x_orig_group.expenditure_group_status_code <> 'WORKING')) then
162: rework (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: end if;
167:
168:

Line 189: app_exception.raise_exception;

185: -- check notfound?
186:
187: if (groups_rec.expenditure_group_status_code <> 'WORKING') then
188: fnd_message.set_name ('PA', 'PA_TR_EPE_ONLY_DEL_WORK');
189: app_exception.raise_exception;
190: end if;
191:
192: -- cascade delete to expenditures.
193: DECLARE

Line 216: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

212: end if;
213: END LOOP;
214:
215: EXCEPTION
216: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
217: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
218: app_exception.raise_exception;
219: END;
220:

Line 218: app_exception.raise_exception;

214:
215: EXCEPTION
216: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
217: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
218: app_exception.raise_exception;
219: END;
220:
221: delete from pa_expenditure_groups
222: where rowid = x_rowid;

Line 305: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

301: p_exp_status_code => 'APPROVED' );
302:
303:
304: EXCEPTION
305: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
306: x_err_code := 1;
307: x_return_status := 'Could not lock expenditures';
308: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
309: END release;

Line 371: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

367:
368:
369:
370: EXCEPTION
371: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
372: x_err_code := 1;
373: x_return_status := 'Could not lock expenditures';
374: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
375: END rework;

Line 423: -- app_exception.raise_exception;

419: if (x_orig_group.expenditure_group_status_code <> 'WORKING') then
420: x_err_code := 1;
421: x_return_status := 'Can only submit working';
422: fnd_message.set_name ('PA', 'PA_TR_EPE_SUBMIT_ONLY_WORK');
423: -- app_exception.raise_exception;
424: return;
425: end if;
426:
427: -- Check that expenditure items exist for the group

Line 442: -- app_exception.raise_exception;

438: if (x_count = 0) then
439: x_err_code := 1;
440: x_return_status := 'Exp items must exist';
441: fnd_message.set_name ('PA', 'PA_TR_EPE_SUBMIT_NO_ITEMS');
442: -- app_exception.raise_exception;
443: return;
444: end if;
445: END;
446:

Line 553: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

549:
550:
551:
552: EXCEPTION
553: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
554: x_err_code := 1;
555: x_return_status := 'Could not lock expenditures';
556: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
557: END execute_submit;