eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_BUDORG_BC_OPTIONS_PKG dependencies on APP_EXCEPTION

Line 73: app_exception.raise_exception;

69: FETCH check_overlaps into dummy;
70: IF check_overlaps%FOUND THEN
71: CLOSE check_overlaps;
72: fnd_message.set_name('SQLGL', 'GL_BC_BUDGET_OVERLAP');
73: app_exception.raise_exception;
74: ELSE
75: CLOSE check_overlaps;
76: END IF;
77:

Line 153: APP_EXCEPTION.RAISE_EXCEPTION;

149: ) then
150: return;
151: else
152: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
153: APP_EXCEPTION.RAISE_EXCEPTION;
154: end if;
155: END Lock_Row;
156:
157: PROCEDURE Update_Row(X_Rowid VARCHAR2,

Line 265: app_exception.raise_exception;

261: CLOSE check_funds_check_level;
262: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
263: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
264: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
265: app_exception.raise_exception;
266: END IF;
267: CLOSE check_funds_check_level;
268: ELSIF (X_Funds_Check_Level_Code IS NULL) THEN
269: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 271: app_exception.raise_exception;

267: CLOSE check_funds_check_level;
268: ELSIF (X_Funds_Check_Level_Code IS NULL) THEN
269: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
270: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
271: app_exception.raise_exception;
272: ELSE
273: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
274: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
275: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');

Line 276: app_exception.raise_exception;

272: ELSE
273: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
274: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
275: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
276: app_exception.raise_exception;
277: END IF;
278:
279: -- Validate Amount Type
280: IF (X_Amount_Type IS NOT NULL) THEN

Line 288: app_exception.raise_exception;

284: CLOSE check_amount_type;
285: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
286: fnd_message.set_token('VALUE', X_Amount_Type);
287: fnd_message.set_token('ATTRIBUTE', 'AmountType');
288: app_exception.raise_exception;
289: END IF;
290: CLOSE check_amount_type;
291: ELSE
292: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 294: app_exception.raise_exception;

290: CLOSE check_amount_type;
291: ELSE
292: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
293: fnd_message.set_token('ATTRIBUTE', 'AmountType');
294: app_exception.raise_exception;
295: END IF;
296:
297: -- Validate Boundary Code
298: IF (X_Boundary_Code IS NOT NULL) THEN

Line 306: app_exception.raise_exception;

302: CLOSE check_boundary_code;
303: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
304: fnd_message.set_token('VALUE', X_Boundary_Code);
305: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
306: app_exception.raise_exception;
307: END IF;
308: CLOSE check_boundary_code;
309: ELSE
310: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 312: app_exception.raise_exception;

308: CLOSE check_boundary_code;
309: ELSE
310: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
311: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
312: app_exception.raise_exception;
313: END IF;
314:
315: -- Validate Budget Version
316: IF (X_Funding_Budget_Version_Id IS NOT NULL) THEN

Line 324: app_exception.raise_exception;

320: CLOSE check_budget_version;
321: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
322: fnd_message.set_token('VALUE', X_Funding_Budget_Version_Id);
323: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
324: app_exception.raise_exception;
325: END IF;
326: CLOSE check_budget_version;
327: ELSE
328: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 330: app_exception.raise_exception;

326: CLOSE check_budget_version;
327: ELSE
328: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
329: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
330: app_exception.raise_exception;
331: END IF;
332:
333: -- Validate currency_code exists and is enabled in FND_CURRENCIES
334: -- Also, if entry_code is E, only functional currency and STAT is allowed.

Line 359: app_exception.raise_exception;

355: (L_Currency_Code = L_Functional_Currency)) THEN
356: NULL;
357: ELSE
358: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BUD_CTRL_OPT_ERR');
359: app_exception.raise_exception;
360: END IF;
361: END IF;
362:
363: -- Validate that boundary code is a logical selection depending on the

Line 368: app_exception.raise_exception;

364: -- amount type
365: IF (X_Amount_Type = 'PTD') THEN
366: IF (X_Boundary_Code <> 'P') THEN
367: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');
368: app_exception.raise_exception;
369: END IF;
370: ELSIF (X_Amount_Type = 'QTD') THEN
371: IF (X_Boundary_Code NOT IN ('P', 'Q')) THEN
372: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');

Line 373: app_exception.raise_exception;

369: END IF;
370: ELSIF (X_Amount_Type = 'QTD') THEN
371: IF (X_Boundary_Code NOT IN ('P', 'Q')) THEN
372: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');
373: app_exception.raise_exception;
374: END IF;
375: ELSIF (X_Amount_Type = 'YTD') THEN
376: IF (X_Boundary_Code NOT IN ('P', 'Q', 'Y')) THEN
377: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');

Line 378: app_exception.raise_exception;

374: END IF;
375: ELSIF (X_Amount_Type = 'YTD') THEN
376: IF (X_Boundary_Code NOT IN ('P', 'Q', 'Y')) THEN
377: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');
378: app_exception.raise_exception;
379: END IF;
380: ELSIF (X_Amount_Type = 'PJTD') THEN
381: -- Already checked boundary code is J, P, Q or Y
382: NULL;

Line 400: WHEN app_exceptions.application_exception THEN

396: X_Range_Id);
397:
398:
399: EXCEPTION
400: WHEN app_exceptions.application_exception THEN
401: RAISE;
402: WHEN OTHERS THEN
403: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
404: fnd_message.set_token('PROCEDURE',

Line 460: app_exception.raise_exception;

456: CLOSE check_funds_check_level;
457: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
458: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
459: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
460: app_exception.raise_exception;
461: END IF;
462: CLOSE check_funds_check_level;
463: ELSIF (X_Funds_Check_Level_Code IS NULL) THEN
464: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 466: app_exception.raise_exception;

462: CLOSE check_funds_check_level;
463: ELSIF (X_Funds_Check_Level_Code IS NULL) THEN
464: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
465: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
466: app_exception.raise_exception;
467: ELSE
468: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
469: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
470: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');

Line 471: app_exception.raise_exception;

467: ELSE
468: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
469: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
470: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
471: app_exception.raise_exception;
472: END IF;
473:
474: -- Validate Amount Type
475: IF (X_Amount_Type IS NOT NULL) THEN

Line 483: app_exception.raise_exception;

479: CLOSE check_amount_type;
480: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
481: fnd_message.set_token('VALUE', X_Amount_Type);
482: fnd_message.set_token('ATTRIBUTE', 'AmountType');
483: app_exception.raise_exception;
484: END IF;
485: CLOSE check_amount_type;
486: ELSE
487: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 489: app_exception.raise_exception;

485: CLOSE check_amount_type;
486: ELSE
487: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
488: fnd_message.set_token('ATTRIBUTE', 'AmountType');
489: app_exception.raise_exception;
490: END IF;
491:
492: -- Validate Boundary Code
493: IF (X_Boundary_Code IS NOT NULL) THEN

Line 501: app_exception.raise_exception;

497: CLOSE check_boundary_code;
498: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
499: fnd_message.set_token('VALUE', X_Boundary_Code);
500: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
501: app_exception.raise_exception;
502: END IF;
503: CLOSE check_boundary_code;
504: ELSE
505: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 507: app_exception.raise_exception;

503: CLOSE check_boundary_code;
504: ELSE
505: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
506: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
507: app_exception.raise_exception;
508: END IF;
509:
510: -- Validate Budget Version
511: IF (X_Funding_Budget_Version_Id IS NOT NULL) THEN

Line 519: app_exception.raise_exception;

515: CLOSE check_budget_version;
516: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
517: fnd_message.set_token('VALUE', X_Funding_Budget_Version_Id);
518: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
519: app_exception.raise_exception;
520: END IF;
521: CLOSE check_budget_version;
522: ELSE
523: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 525: app_exception.raise_exception;

521: CLOSE check_budget_version;
522: ELSE
523: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
524: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
525: app_exception.raise_exception;
526: END IF;
527:
528: -- Validate currency_code exists and is enabled in FND_CURRENCIES
529: -- Also, if entry_code is E, only functional currency and STAT is allowed.

Line 554: app_exception.raise_exception;

550: (L_Currency_Code = L_Functional_Currency)) THEN
551: NULL;
552: ELSE
553: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BUD_CTRL_OPT_ERR');
554: app_exception.raise_exception;
555: END IF;
556: END IF;
557:
558: -- Validate that boundary code is a logical selection depending on the

Line 563: app_exception.raise_exception;

559: -- amount type
560: IF (X_Amount_Type = 'PTD') THEN
561: IF (X_Boundary_Code <> 'P') THEN
562: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');
563: app_exception.raise_exception;
564: END IF;
565: ELSIF (X_Amount_Type = 'QTD') THEN
566: IF (X_Boundary_Code NOT IN ('P', 'Q')) THEN
567: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');

Line 568: app_exception.raise_exception;

564: END IF;
565: ELSIF (X_Amount_Type = 'QTD') THEN
566: IF (X_Boundary_Code NOT IN ('P', 'Q')) THEN
567: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');
568: app_exception.raise_exception;
569: END IF;
570: ELSIF (X_Amount_Type = 'YTD') THEN
571: IF (X_Boundary_Code NOT IN ('P', 'Q', 'Y')) THEN
572: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');

Line 573: app_exception.raise_exception;

569: END IF;
570: ELSIF (X_Amount_Type = 'YTD') THEN
571: IF (X_Boundary_Code NOT IN ('P', 'Q', 'Y')) THEN
572: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');
573: app_exception.raise_exception;
574: END IF;
575: ELSIF (X_Amount_Type = 'PJTD') THEN
576: -- Already checked boundary code is J, P, Q or Y
577: NULL;

Line 598: WHEN app_exceptions.application_exception THEN

594: end if;
595:
596:
597: EXCEPTION
598: WHEN app_exceptions.application_exception THEN
599: RAISE;
600: WHEN OTHERS THEN
601: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
602: fnd_message.set_token('PROCEDURE',