APPS.GMS_ENCUMBRANCE_GROUPS_PKG dependencies on APP_EXCEPTION

Line 92: app_exception.raise_exception;

88: -- we bypass the error checking that submit does, since
89: -- it should already have been done at the form level
90: execute_submit (x_encumbrance_group, x_err_code, x_return_status);
91: if (x_err_code = 1) then
92: app_exception.raise_exception;
93: end if;
94: end if;
95:
96: 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_encumbrance_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_encumbrance_group_status = 'RELEASED') and

Line 156: app_exception.raise_exception;

152: if ((x_encumbrance_group_status = 'RELEASED') and
153: (x_orig_group.encumbrance_group_status_code <> 'RELEASED')) then
154: release (x_encumbrance_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_encumbrance_group_status = 'WORKING') and

Line 164: app_exception.raise_exception;

160: if ((x_encumbrance_group_status = 'WORKING') and
161: (x_orig_group.encumbrance_group_status_code <> 'WORKING')) then
162: rework (x_encumbrance_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.encumbrance_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 encumbrances.
193: DECLARE

Line 214: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

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

Line 216: app_exception.raise_exception;

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

Line 292: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

288: set encumbrance_status_code = 'APPROVED'
289: where encumbrance_group = x_encumbrance_group;
290:
291: EXCEPTION
292: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
293: x_err_code := 1;
294: x_return_status := 'Could not lock encumbrances';
295: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
296: END release;

Line 343: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

339: set encumbrance_status_code = 'WORKING'
340: where encumbrance_group = x_encumbrance_group;
341:
342: EXCEPTION
343: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
344: x_err_code := 1;
345: x_return_status := 'Could not lock encumbrances';
346: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
347: END rework;

Line 395: -- app_exception.raise_exception;

391: if (x_orig_group.encumbrance_group_status_code <> 'WORKING') then
392: x_err_code := 1;
393: x_return_status := 'Can only submit working';
394: fnd_message.set_name ('PA', 'PA_TR_EPE_SUBMIT_ONLY_WORK');
395: -- app_exception.raise_exception;
396: return;
397: end if;
398:
399: -- Check that encumbrance items exist for the group

Line 414: -- app_exception.raise_exception;

410: if (x_count = 0) then
411: x_err_code := 1;
412: x_return_status := 'Exp items must exist';
413: fnd_message.set_name ('PA', 'PA_TR_EPE_SUBMIT_NO_ITEMS');
414: -- app_exception.raise_exception;
415: return;
416: end if;
417: END;
418:

Line 513: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

509: where encumbrance_group = x_encumbrance_group;
510:
511:
512: EXCEPTION
513: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
514: x_err_code := 1;
515: x_return_status := 'Could not lock encumbrances';
516: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
517: END execute_submit;