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 APP_EXCEPTION

Line 76: app_exception.raise_exception;

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;
80:

Line 181: APP_EXCEPTION.RAISE_EXCEPTION;

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:
185: PROCEDURE Insert_BC_Options(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 241: app_exception.raise_exception;

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
245: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 247: app_exception.raise_exception;

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);
251: fnd_message.set_token('ATTRIBUTE', 'FundsCheckLevelCode');

Line 252: 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
256: IF (X_Amount_Type IS NOT NULL) THEN

Line 264: app_exception.raise_exception;

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
268: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 270: app_exception.raise_exception;

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
274: IF (X_Boundary_Code IS NOT NULL) THEN

Line 282: app_exception.raise_exception;

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
286: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 288: app_exception.raise_exception;

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
292: IF (X_Funding_Budget_Version_Id IS NOT NULL) THEN

Line 300: app_exception.raise_exception;

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
304: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 306: app_exception.raise_exception;

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
310: IF (X_Dr_Cr_Code IS NOT NULL) THEN

Line 318: app_exception.raise_exception;

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
322: fnd_message.set_name('SQLGL', 'GL_API_NULL_VALUE_ERROR');

Line 324: app_exception.raise_exception;

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
328: INTO L_Budgetary_Control_Flag

Line 341: app_exception.raise_exception;

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

Line 350: app_exception.raise_exception;

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
354: fnd_message.set_name('SQLGL', 'GL_API_SUMMTEMPL_BOUNDARY_ERR');

Line 355: 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
359: fnd_message.set_name('SQLGL', 'GL_API_SUMMTEMPL_BOUNDARY_ERR');

Line 360: 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
364: NULL;

Line 383: WHEN app_exceptions.application_exception THEN

379: );
380:
381:
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',