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 FND_MESSAGE

Line 72: fnd_message.set_name('SQLGL', 'GL_BC_BUDGET_OVERLAP');

68: OPEN check_overlaps;
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;

Line 152: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

148: AND (X_Boundary_Code IS NULL)))
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:

Line 205: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

201: EXCEPTION
202: WHEN no_data_found THEN
203: RETURN;
204: WHEN OTHERS THEN
205: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
206: fnd_message.set_token(
207: 'PROCEDURE',
208: 'gl_budorg_bc_options_pkg.delete_budorg_bc_options');
209: RAISE;

Line 206: fnd_message.set_token(

202: WHEN no_data_found THEN
203: RETURN;
204: WHEN OTHERS THEN
205: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
206: fnd_message.set_token(
207: 'PROCEDURE',
208: 'gl_budorg_bc_options_pkg.delete_budorg_bc_options');
209: RAISE;
210: END delete_budorg_bc_options;

Line 262: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');

258: OPEN check_funds_check_level;
259: FETCH check_funds_check_level INTO dummy;
260: IF check_funds_check_level%NOTFOUND THEN
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;

Line 263: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);

259: FETCH check_funds_check_level INTO dummy;
260: IF check_funds_check_level%NOTFOUND THEN
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;

Line 264: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');

260: IF check_funds_check_level%NOTFOUND THEN
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

Line 269: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

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');
270: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
271: app_exception.raise_exception;
272: ELSE
273: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');

Line 270: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');

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');
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);

Line 273: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');

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');
276: app_exception.raise_exception;
277: END IF;

Line 274: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);

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');
276: app_exception.raise_exception;
277: END IF;
278:

Line 275: 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');
276: app_exception.raise_exception;
277: END IF;
278:
279: -- Validate Amount Type

Line 285: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');

281: OPEN check_amount_type;
282: FETCH check_amount_type INTO dummy;
283: IF check_amount_type%NOTFOUND THEN
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;

Line 286: fnd_message.set_token('VALUE', X_Amount_Type);

282: FETCH check_amount_type INTO dummy;
283: IF check_amount_type%NOTFOUND THEN
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;

Line 287: fnd_message.set_token('ATTRIBUTE', 'AmountType');

283: IF check_amount_type%NOTFOUND THEN
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

Line 292: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

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');
293: fnd_message.set_token('ATTRIBUTE', 'AmountType');
294: app_exception.raise_exception;
295: END IF;
296:

Line 293: fnd_message.set_token('ATTRIBUTE', 'AmountType');

289: END IF;
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

Line 303: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');

299: OPEN check_boundary_code;
300: FETCH check_boundary_code INTO dummy;
301: IF check_boundary_code%NOTFOUND THEN
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;

Line 304: fnd_message.set_token('VALUE', X_Boundary_Code);

300: FETCH check_boundary_code INTO dummy;
301: IF check_boundary_code%NOTFOUND THEN
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;

Line 305: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');

301: IF check_boundary_code%NOTFOUND THEN
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

Line 310: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

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');
311: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
312: app_exception.raise_exception;
313: END IF;
314:

Line 311: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');

307: END IF;
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

Line 321: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');

317: OPEN check_budget_version;
318: FETCH check_budget_version INTO dummy;
319: IF check_budget_version%NOTFOUND THEN
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;

Line 322: fnd_message.set_token('VALUE', X_Funding_Budget_Version_Id);

318: FETCH check_budget_version INTO dummy;
319: IF check_budget_version%NOTFOUND THEN
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;

Line 323: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');

319: IF check_budget_version%NOTFOUND THEN
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

Line 328: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

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');
329: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
330: app_exception.raise_exception;
331: END IF;
332:

Line 329: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');

325: END IF;
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

Line 358: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BUD_CTRL_OPT_ERR');

354: (L_Entry_Code = 'E') AND
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:

Line 367: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');

363: -- Validate that boundary code is a logical selection depending on the
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

Line 372: 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');
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

Line 377: 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');
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

Line 403: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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',
405: 'GL_BUDORG_BC_OPTIONS_PKG.Insert_BC_Options');
406: RAISE;
407:

Line 404: fnd_message.set_token('PROCEDURE',

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',
405: 'GL_BUDORG_BC_OPTIONS_PKG.Insert_BC_Options');
406: RAISE;
407:
408: END Insert_BC_Options;

Line 457: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');

453: OPEN check_funds_check_level;
454: FETCH check_funds_check_level INTO dummy;
455: IF check_funds_check_level%NOTFOUND THEN
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;

Line 458: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);

454: FETCH check_funds_check_level INTO dummy;
455: IF check_funds_check_level%NOTFOUND THEN
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;

Line 459: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');

455: IF check_funds_check_level%NOTFOUND THEN
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

Line 464: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

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');
465: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
466: app_exception.raise_exception;
467: ELSE
468: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');

Line 465: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');

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');
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);

Line 468: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');

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');
471: app_exception.raise_exception;
472: END IF;

Line 469: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);

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');
471: app_exception.raise_exception;
472: END IF;
473:

Line 470: 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');
471: app_exception.raise_exception;
472: END IF;
473:
474: -- Validate Amount Type

Line 480: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');

476: OPEN check_amount_type;
477: FETCH check_amount_type INTO dummy;
478: IF check_amount_type%NOTFOUND THEN
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;

Line 481: fnd_message.set_token('VALUE', X_Amount_Type);

477: FETCH check_amount_type INTO dummy;
478: IF check_amount_type%NOTFOUND THEN
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;

Line 482: fnd_message.set_token('ATTRIBUTE', 'AmountType');

478: IF check_amount_type%NOTFOUND THEN
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

Line 487: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

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');
488: fnd_message.set_token('ATTRIBUTE', 'AmountType');
489: app_exception.raise_exception;
490: END IF;
491:

Line 488: fnd_message.set_token('ATTRIBUTE', 'AmountType');

484: END IF;
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

Line 498: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');

494: OPEN check_boundary_code;
495: FETCH check_boundary_code INTO dummy;
496: IF check_boundary_code%NOTFOUND THEN
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;

Line 499: fnd_message.set_token('VALUE', X_Boundary_Code);

495: FETCH check_boundary_code INTO dummy;
496: IF check_boundary_code%NOTFOUND THEN
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;

Line 500: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');

496: IF check_boundary_code%NOTFOUND THEN
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

Line 505: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

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');
506: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
507: app_exception.raise_exception;
508: END IF;
509:

Line 506: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');

502: END IF;
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

Line 516: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');

512: OPEN check_budget_version;
513: FETCH check_budget_version INTO dummy;
514: IF check_budget_version%NOTFOUND THEN
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;

Line 517: fnd_message.set_token('VALUE', X_Funding_Budget_Version_Id);

513: FETCH check_budget_version INTO dummy;
514: IF check_budget_version%NOTFOUND THEN
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;

Line 518: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');

514: IF check_budget_version%NOTFOUND THEN
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

Line 523: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

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');
524: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
525: app_exception.raise_exception;
526: END IF;
527:

Line 524: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');

520: END IF;
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

Line 553: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BUD_CTRL_OPT_ERR');

549: (L_Entry_Code = 'E') AND
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:

Line 562: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_BOUNDARY_ERR');

558: -- Validate that boundary code is a logical selection depending on the
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

Line 567: 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');
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

Line 572: 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');
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

Line 601: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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',
603: 'GL_BUDORG_BC_OPTIONS_PKG.Update_BC_Options');
604: RAISE;
605:

Line 602: fnd_message.set_token('PROCEDURE',

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',
603: 'GL_BUDORG_BC_OPTIONS_PKG.Update_BC_Options');
604: RAISE;
605:
606: END Update_BC_Options;