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_SUMMARY_BC_OPTIONS_PKG dependencies on FND_MESSAGE

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

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

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

176: AND (X_Funding_Budget_Version_Id IS NULL)))
177: ) then
178: return;
179: else
180: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
181: APP_EXCEPTION.RAISE_EXCEPTION;
182: end if;
183: END Lock_Row;
184:

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

234: OPEN check_funds_check_level;
235: FETCH check_funds_check_level INTO dummy;
236: IF check_funds_check_level%NOTFOUND THEN
237: CLOSE check_funds_check_level;
238: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
239: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
240: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
241: app_exception.raise_exception;
242: END IF;

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

235: FETCH check_funds_check_level INTO dummy;
236: IF check_funds_check_level%NOTFOUND THEN
237: CLOSE check_funds_check_level;
238: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
239: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
240: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
241: app_exception.raise_exception;
242: END IF;
243: CLOSE check_funds_check_level;

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

236: IF check_funds_check_level%NOTFOUND THEN
237: CLOSE check_funds_check_level;
238: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
239: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
240: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
241: app_exception.raise_exception;
242: END IF;
243: CLOSE check_funds_check_level;
244: ELSIF (X_Funds_Check_Level_Code IS NULL) THEN

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

241: app_exception.raise_exception;
242: END IF;
243: CLOSE check_funds_check_level;
244: ELSIF (X_Funds_Check_Level_Code IS NULL) THEN
245: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
246: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
247: app_exception.raise_exception;
248: ELSE
249: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');

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

242: END IF;
243: CLOSE check_funds_check_level;
244: ELSIF (X_Funds_Check_Level_Code IS NULL) THEN
245: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
246: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
247: app_exception.raise_exception;
248: ELSE
249: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
250: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);

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

245: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
246: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
247: app_exception.raise_exception;
248: ELSE
249: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
250: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
251: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
252: app_exception.raise_exception;
253: END IF;

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

246: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
247: app_exception.raise_exception;
248: ELSE
249: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
250: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
251: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
252: app_exception.raise_exception;
253: END IF;
254:

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

247: app_exception.raise_exception;
248: ELSE
249: fnd_message.set_name('SQLGL', 'GL_API_INVALID_VALUE');
250: fnd_message.set_token('VALUE', X_Funds_Check_Level_Code);
251: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');
252: app_exception.raise_exception;
253: END IF;
254:
255: -- Validate Amount Type

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

257: OPEN check_amount_type;
258: FETCH check_amount_type INTO dummy;
259: IF check_amount_type%NOTFOUND THEN
260: CLOSE check_amount_type;
261: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
262: fnd_message.set_token('VALUE', X_Amount_Type);
263: fnd_message.set_token('ATTRIBUTE', 'AmountType');
264: app_exception.raise_exception;
265: END IF;

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

258: FETCH check_amount_type INTO dummy;
259: IF check_amount_type%NOTFOUND THEN
260: CLOSE check_amount_type;
261: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
262: fnd_message.set_token('VALUE', X_Amount_Type);
263: fnd_message.set_token('ATTRIBUTE', 'AmountType');
264: app_exception.raise_exception;
265: END IF;
266: CLOSE check_amount_type;

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

259: IF check_amount_type%NOTFOUND THEN
260: CLOSE check_amount_type;
261: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
262: fnd_message.set_token('VALUE', X_Amount_Type);
263: fnd_message.set_token('ATTRIBUTE', 'AmountType');
264: app_exception.raise_exception;
265: END IF;
266: CLOSE check_amount_type;
267: ELSE

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

264: app_exception.raise_exception;
265: END IF;
266: CLOSE check_amount_type;
267: ELSE
268: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
269: fnd_message.set_token('ATTRIBUTE', 'AmountType');
270: app_exception.raise_exception;
271: END IF;
272:

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

265: END IF;
266: CLOSE check_amount_type;
267: ELSE
268: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
269: fnd_message.set_token('ATTRIBUTE', 'AmountType');
270: app_exception.raise_exception;
271: END IF;
272:
273: -- Validate Boundary Code

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

275: OPEN check_boundary_code;
276: FETCH check_boundary_code INTO dummy;
277: IF check_boundary_code%NOTFOUND THEN
278: CLOSE check_boundary_code;
279: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
280: fnd_message.set_token('VALUE', X_Boundary_Code);
281: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
282: app_exception.raise_exception;
283: END IF;

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

276: FETCH check_boundary_code INTO dummy;
277: IF check_boundary_code%NOTFOUND THEN
278: CLOSE check_boundary_code;
279: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
280: fnd_message.set_token('VALUE', X_Boundary_Code);
281: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
282: app_exception.raise_exception;
283: END IF;
284: CLOSE check_boundary_code;

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

277: IF check_boundary_code%NOTFOUND THEN
278: CLOSE check_boundary_code;
279: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
280: fnd_message.set_token('VALUE', X_Boundary_Code);
281: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
282: app_exception.raise_exception;
283: END IF;
284: CLOSE check_boundary_code;
285: ELSE

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

282: app_exception.raise_exception;
283: END IF;
284: CLOSE check_boundary_code;
285: ELSE
286: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
287: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
288: app_exception.raise_exception;
289: END IF;
290:

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

283: END IF;
284: CLOSE check_boundary_code;
285: ELSE
286: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
287: fnd_message.set_token('ATTRIBUTE', 'BoundaryCode');
288: app_exception.raise_exception;
289: END IF;
290:
291: -- Validate Budget Version

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

293: OPEN check_budget_version;
294: FETCH check_budget_version INTO dummy;
295: IF check_budget_version%NOTFOUND THEN
296: CLOSE check_budget_version;
297: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
298: fnd_message.set_token('VALUE', X_Funding_Budget_Version_Id);
299: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
300: app_exception.raise_exception;
301: END IF;

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

294: FETCH check_budget_version INTO dummy;
295: IF check_budget_version%NOTFOUND THEN
296: CLOSE check_budget_version;
297: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
298: fnd_message.set_token('VALUE', X_Funding_Budget_Version_Id);
299: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
300: app_exception.raise_exception;
301: END IF;
302: CLOSE check_budget_version;

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

295: IF check_budget_version%NOTFOUND THEN
296: CLOSE check_budget_version;
297: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
298: fnd_message.set_token('VALUE', X_Funding_Budget_Version_Id);
299: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
300: app_exception.raise_exception;
301: END IF;
302: CLOSE check_budget_version;
303: ELSE

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

300: app_exception.raise_exception;
301: END IF;
302: CLOSE check_budget_version;
303: ELSE
304: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
305: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
306: app_exception.raise_exception;
307: END IF;
308:

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

301: END IF;
302: CLOSE check_budget_version;
303: ELSE
304: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
305: fnd_message.set_token('ATTRIBUTE', 'FundingBudgetVersionId');
306: app_exception.raise_exception;
307: END IF;
308:
309: -- Validate Debit/Credit Code

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

311: OPEN check_dr_cr_code;
312: FETCH check_dr_cr_code INTO dummy;
313: IF check_dr_cr_code%NOTFOUND THEN
314: CLOSE check_dr_cr_code;
315: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
316: fnd_message.set_token('VALUE', X_Dr_Cr_Code);
317: fnd_message.set_token('ATTRIBUTE', 'DrCrCode');
318: app_exception.raise_exception;
319: END IF;

Line 316: fnd_message.set_token('VALUE', X_Dr_Cr_Code);

312: FETCH check_dr_cr_code INTO dummy;
313: IF check_dr_cr_code%NOTFOUND THEN
314: CLOSE check_dr_cr_code;
315: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
316: fnd_message.set_token('VALUE', X_Dr_Cr_Code);
317: fnd_message.set_token('ATTRIBUTE', 'DrCrCode');
318: app_exception.raise_exception;
319: END IF;
320: CLOSE check_dr_cr_code;

Line 317: fnd_message.set_token('ATTRIBUTE', 'DrCrCode');

313: IF check_dr_cr_code%NOTFOUND THEN
314: CLOSE check_dr_cr_code;
315: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
316: fnd_message.set_token('VALUE', X_Dr_Cr_Code);
317: fnd_message.set_token('ATTRIBUTE', 'DrCrCode');
318: app_exception.raise_exception;
319: END IF;
320: CLOSE check_dr_cr_code;
321: ELSE

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

318: app_exception.raise_exception;
319: END IF;
320: CLOSE check_dr_cr_code;
321: ELSE
322: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
323: fnd_message.set_token('ATTRIBUTE', 'DrCrCode');
324: app_exception.raise_exception;
325: END IF;
326:

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

319: END IF;
320: CLOSE check_dr_cr_code;
321: ELSE
322: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');
323: fnd_message.set_token('ATTRIBUTE', 'DrCrCode');
324: app_exception.raise_exception;
325: END IF;
326:
327: SELECT gl1.enable_budgetary_control_flag

Line 340: fnd_message.set_name('SQLGL', 'GL_API_SUMMTEMPL_FUNDS_LEVEL');

336: IF (X_Funds_Check_Level_Code = 'D' OR X_Funds_Check_Level_Code = 'B') THEN
337: IF (L_Budgetary_Control_Flag = 'Y') THEN
338: NULL;
339: ELSE
340: fnd_message.set_name('SQLGL', 'GL_API_SUMMTEMPL_FUNDS_LEVEL');
341: app_exception.raise_exception;
342: END IF;
343: END IF;
344:

Line 349: fnd_message.set_name('SQLGL', 'GL_API_SUMMTEMPL_BOUNDARY_ERR');

345: -- Validate that boundary code is a logical selection depending on the
346: -- amount type
347: IF (X_Amount_Type = 'PTD') THEN
348: IF (X_Boundary_Code <> 'P') THEN
349: fnd_message.set_name('SQLGL', 'GL_API_SUMMTEMPL_BOUNDARY_ERR');
350: app_exception.raise_exception;
351: END IF;
352: ELSIF (X_Amount_Type = 'QTD') THEN
353: IF (X_Boundary_Code NOT IN ('P', 'Q')) THEN

Line 354: fnd_message.set_name('SQLGL', 'GL_API_SUMMTEMPL_BOUNDARY_ERR');

350: app_exception.raise_exception;
351: END IF;
352: ELSIF (X_Amount_Type = 'QTD') THEN
353: IF (X_Boundary_Code NOT IN ('P', 'Q')) THEN
354: fnd_message.set_name('SQLGL', 'GL_API_SUMMTEMPL_BOUNDARY_ERR');
355: app_exception.raise_exception;
356: END IF;
357: ELSIF (X_Amount_Type = 'YTD') THEN
358: IF (X_Boundary_Code NOT IN ('P', 'Q', 'Y')) THEN

Line 359: fnd_message.set_name('SQLGL', 'GL_API_SUMMTEMPL_BOUNDARY_ERR');

355: app_exception.raise_exception;
356: END IF;
357: ELSIF (X_Amount_Type = 'YTD') THEN
358: IF (X_Boundary_Code NOT IN ('P', 'Q', 'Y')) THEN
359: fnd_message.set_name('SQLGL', 'GL_API_SUMMTEMPL_BOUNDARY_ERR');
360: app_exception.raise_exception;
361: END IF;
362: ELSIF (X_Amount_Type = 'PJTD') THEN
363: -- Already checked boundary code is J, P, Q or Y

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

382: EXCEPTION
383: WHEN app_exceptions.application_exception THEN
384: RAISE;
385: WHEN OTHERS THEN
386: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
387: fnd_message.set_token('PROCEDURE',
388: 'GL_SUMMARY_BC_OPTIONS_PKG.Insert_BC_Options');
389: RAISE;
390:

Line 387: fnd_message.set_token('PROCEDURE',

383: WHEN app_exceptions.application_exception THEN
384: RAISE;
385: WHEN OTHERS THEN
386: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
387: fnd_message.set_token('PROCEDURE',
388: 'GL_SUMMARY_BC_OPTIONS_PKG.Insert_BC_Options');
389: RAISE;
390:
391: END Insert_BC_Options;