DBA Data[Home] [Help]

APPS.JA_CN_CFS_REPORT_PKG dependencies on FND_LOG

Line 74: L_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

70: --===========================================================================
71:
72: FUNCTION Prepare_CFS_Detail_Report RETURN BOOLEAN IS
73:
74: L_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
75: L_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
76: L_PROC_NAME VARCHAR2(100) := 'Prepare_CFS_Detail_Report';
77:
78: L_START_YEAR GL_PERIODS.PERIOD_YEAR%TYPE;

Line 75: L_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

71:
72: FUNCTION Prepare_CFS_Detail_Report RETURN BOOLEAN IS
73:
74: L_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
75: L_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
76: L_PROC_NAME VARCHAR2(100) := 'Prepare_CFS_Detail_Report';
77:
78: L_START_YEAR GL_PERIODS.PERIOD_YEAR%TYPE;
79: L_END_YEAR GL_PERIODS.PERIOD_YEAR%TYPE;

Line 253: FND_LOG.STRING(L_PROC_LEVEL,

249: BEGIN
250: --log for debug
251: IF (L_PROC_LEVEL >= L_DBG_LEVEL)
252: THEN
253: FND_LOG.STRING(L_PROC_LEVEL,
254: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.begin',
255: 'Enter procedure');
256: FND_LOG.STRING(L_PROC_LEVEL,
257: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 256: FND_LOG.STRING(L_PROC_LEVEL,

252: THEN
253: FND_LOG.STRING(L_PROC_LEVEL,
254: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.begin',
255: 'Enter procedure');
256: FND_LOG.STRING(L_PROC_LEVEL,
257: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
258: 'P_LEGAL_ENTITY_ID ' || P_LEGAL_ENTITY_ID);
259: FND_LOG.STRING(L_PROC_LEVEL,
260: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 259: FND_LOG.STRING(L_PROC_LEVEL,

255: 'Enter procedure');
256: FND_LOG.STRING(L_PROC_LEVEL,
257: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
258: 'P_LEGAL_ENTITY_ID ' || P_LEGAL_ENTITY_ID);
259: FND_LOG.STRING(L_PROC_LEVEL,
260: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
261: 'P_LEGAL_ENTITY ' || P_LEGAL_ENTITY);
262: FND_LOG.STRING(L_PROC_LEVEL,
263: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 262: FND_LOG.STRING(L_PROC_LEVEL,

258: 'P_LEGAL_ENTITY_ID ' || P_LEGAL_ENTITY_ID);
259: FND_LOG.STRING(L_PROC_LEVEL,
260: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
261: 'P_LEGAL_ENTITY ' || P_LEGAL_ENTITY);
262: FND_LOG.STRING(L_PROC_LEVEL,
263: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
264: 'P_LEDGER_ID ' || P_LEDGER_ID);
265: FND_LOG.STRING(L_PROC_LEVEL,
266: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 265: FND_LOG.STRING(L_PROC_LEVEL,

261: 'P_LEGAL_ENTITY ' || P_LEGAL_ENTITY);
262: FND_LOG.STRING(L_PROC_LEVEL,
263: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
264: 'P_LEDGER_ID ' || P_LEDGER_ID);
265: FND_LOG.STRING(L_PROC_LEVEL,
266: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
267: 'P_LEDGER_NAME ' || P_LEDGER_NAME);
268: FND_LOG.STRING(L_PROC_LEVEL,
269: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 268: FND_LOG.STRING(L_PROC_LEVEL,

264: 'P_LEDGER_ID ' || P_LEDGER_ID);
265: FND_LOG.STRING(L_PROC_LEVEL,
266: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
267: 'P_LEDGER_NAME ' || P_LEDGER_NAME);
268: FND_LOG.STRING(L_PROC_LEVEL,
269: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
270: 'P_CHART_OF_ACCOUNTS_ID ' || P_CHART_OF_ACCOUNTS_ID);
271: FND_LOG.STRING(L_PROC_LEVEL,
272: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 271: FND_LOG.STRING(L_PROC_LEVEL,

267: 'P_LEDGER_NAME ' || P_LEDGER_NAME);
268: FND_LOG.STRING(L_PROC_LEVEL,
269: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
270: 'P_CHART_OF_ACCOUNTS_ID ' || P_CHART_OF_ACCOUNTS_ID);
271: FND_LOG.STRING(L_PROC_LEVEL,
272: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
273: 'P_ADHOC_PREFIX ' || P_ADHOC_PREFIX);
274: FND_LOG.STRING(L_PROC_LEVEL,
275: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 274: FND_LOG.STRING(L_PROC_LEVEL,

270: 'P_CHART_OF_ACCOUNTS_ID ' || P_CHART_OF_ACCOUNTS_ID);
271: FND_LOG.STRING(L_PROC_LEVEL,
272: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
273: 'P_ADHOC_PREFIX ' || P_ADHOC_PREFIX);
274: FND_LOG.STRING(L_PROC_LEVEL,
275: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
276: 'P_INDUSTRY ' || P_INDUSTRY);
277: FND_LOG.STRING(L_PROC_LEVEL,
278: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 277: FND_LOG.STRING(L_PROC_LEVEL,

273: 'P_ADHOC_PREFIX ' || P_ADHOC_PREFIX);
274: FND_LOG.STRING(L_PROC_LEVEL,
275: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
276: 'P_INDUSTRY ' || P_INDUSTRY);
277: FND_LOG.STRING(L_PROC_LEVEL,
278: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
279: 'P_ID_FLEX_CODE ' || P_ID_FLEX_CODE);
280: FND_LOG.STRING(L_PROC_LEVEL,
281: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 280: FND_LOG.STRING(L_PROC_LEVEL,

276: 'P_INDUSTRY ' || P_INDUSTRY);
277: FND_LOG.STRING(L_PROC_LEVEL,
278: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
279: 'P_ID_FLEX_CODE ' || P_ID_FLEX_CODE);
280: FND_LOG.STRING(L_PROC_LEVEL,
281: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
282: 'P_REPORT_ID ' || P_REPORT_ID);
283: FND_LOG.STRING(L_PROC_LEVEL,
284: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 283: FND_LOG.STRING(L_PROC_LEVEL,

279: 'P_ID_FLEX_CODE ' || P_ID_FLEX_CODE);
280: FND_LOG.STRING(L_PROC_LEVEL,
281: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
282: 'P_REPORT_ID ' || P_REPORT_ID);
283: FND_LOG.STRING(L_PROC_LEVEL,
284: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
285: 'P_REPORT_NAME ' || P_REPORT_NAME);
286: FND_LOG.STRING(L_PROC_LEVEL,
287: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 286: FND_LOG.STRING(L_PROC_LEVEL,

282: 'P_REPORT_ID ' || P_REPORT_ID);
283: FND_LOG.STRING(L_PROC_LEVEL,
284: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
285: 'P_REPORT_NAME ' || P_REPORT_NAME);
286: FND_LOG.STRING(L_PROC_LEVEL,
287: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
288: 'P_ROW_SET_ID ' || P_ROW_SET_ID);
289: FND_LOG.STRING(L_PROC_LEVEL,
290: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 289: FND_LOG.STRING(L_PROC_LEVEL,

285: 'P_REPORT_NAME ' || P_REPORT_NAME);
286: FND_LOG.STRING(L_PROC_LEVEL,
287: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
288: 'P_ROW_SET_ID ' || P_ROW_SET_ID);
289: FND_LOG.STRING(L_PROC_LEVEL,
290: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
291: 'P_ROW_ID ' || P_ROW_ID);
292: FND_LOG.STRING(L_PROC_LEVEL,
293: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 292: FND_LOG.STRING(L_PROC_LEVEL,

288: 'P_ROW_SET_ID ' || P_ROW_SET_ID);
289: FND_LOG.STRING(L_PROC_LEVEL,
290: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
291: 'P_ROW_ID ' || P_ROW_ID);
292: FND_LOG.STRING(L_PROC_LEVEL,
293: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
294: 'P_ROW_NAME ' || P_ROW_NAME);
295: FND_LOG.STRING(L_PROC_LEVEL,
296: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 295: FND_LOG.STRING(L_PROC_LEVEL,

291: 'P_ROW_ID ' || P_ROW_ID);
292: FND_LOG.STRING(L_PROC_LEVEL,
293: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
294: 'P_ROW_NAME ' || P_ROW_NAME);
295: FND_LOG.STRING(L_PROC_LEVEL,
296: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
297: 'P_START_PERIOD ' || P_START_PERIOD);
298: FND_LOG.STRING(L_PROC_LEVEL,
299: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 298: FND_LOG.STRING(L_PROC_LEVEL,

294: 'P_ROW_NAME ' || P_ROW_NAME);
295: FND_LOG.STRING(L_PROC_LEVEL,
296: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
297: 'P_START_PERIOD ' || P_START_PERIOD);
298: FND_LOG.STRING(L_PROC_LEVEL,
299: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
300: 'P_END_PERIOD' || P_END_PERIOD);
301: FND_LOG.STRING(L_PROC_LEVEL,
302: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 301: FND_LOG.STRING(L_PROC_LEVEL,

297: 'P_START_PERIOD ' || P_START_PERIOD);
298: FND_LOG.STRING(L_PROC_LEVEL,
299: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
300: 'P_END_PERIOD' || P_END_PERIOD);
301: FND_LOG.STRING(L_PROC_LEVEL,
302: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
303: 'P_SOURCE ' || P_SOURCE);
304: FND_LOG.STRING(L_PROC_LEVEL,
305: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',

Line 304: FND_LOG.STRING(L_PROC_LEVEL,

300: 'P_END_PERIOD' || P_END_PERIOD);
301: FND_LOG.STRING(L_PROC_LEVEL,
302: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
303: 'P_SOURCE ' || P_SOURCE);
304: FND_LOG.STRING(L_PROC_LEVEL,
305: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.parameters',
306: 'P_BSV ' || P_BSV);
307: END IF; --(l_proc_level >= l_dbg_level)
308:

Line 383: FND_LOG.STRING(L_PROC_LEVEL,

379:
380: --log for debug
381: IF (L_PROC_LEVEL >= L_DBG_LEVEL)
382: THEN
383: FND_LOG.STRING(L_PROC_LEVEL,
384: L_MODULE_PREFIX || '.' || L_PROC_NAME || '.end',
385: 'Exit procedure');
386: END IF; --( l_proc_level >= l_dbg_level )
387:

Line 397: FND_LOG.STRING(L_PROC_LEVEL,

393: NAME => 'JA_CN_INVALID_GLPERIOD');
394: L_MSG_INVALID_GLPERIOD := FND_MESSAGE.GET;
395: IF (L_PROC_LEVEL >= L_DBG_LEVEL)
396: THEN
397: FND_LOG.STRING(L_PROC_LEVEL,
398: L_MODULE_PREFIX || '.' || L_PROC_NAME ||
399: '.JA_CN_INVALID_GLPERIOD ',
400: L_MSG_INVALID_GLPERIOD);
401: END IF; --(l_proc_level >= l_dbg_level)

Line 406: FND_LOG.STRING(L_PROC_LEVEL,

402:
403: WHEN OTHERS THEN
404: IF (L_PROC_LEVEL >= L_DBG_LEVEL)
405: THEN
406: FND_LOG.STRING(L_PROC_LEVEL,
407: L_MODULE_PREFIX || '.' || L_PROC_NAME ||
408: '.Other_Exception ',
409: SQLCODE || ':' || SQLERRM);
410: END IF; --(l_proc_level >= l_dbg_level)