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.CST_ACCRUALSUMMARYREPORT_PVT dependencies on FND_LOG

Line 5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY CST_AccrualSummaryReport_PVT AS
2: /* $Header: CSTVASRB.pls 120.16.12020000.2 2012/07/11 13:19:19 vkatakam ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_AccrualSummaryReport_PVT';
5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: PROCEDURE Generate_SummaryReportXml (
8: errcode OUT NOCOPY VARCHAR2,
9: errno OUT NOCOPY NUMBER,

Line 38: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,

34:
35: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
36: l_module CONSTANT VARCHAR2(2000) := 'cst.plsql.' || l_full_name;
37:
38: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
39: l_module);
40: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
41: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
42: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 40: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

36: l_module CONSTANT VARCHAR2(2000) := 'cst.plsql.' || l_full_name;
37:
38: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
39: l_module);
40: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
41: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
42: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
43: /*Bug 7305146*/
44: l_encoding VARCHAR2(20);

Line 41: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

37:
38: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
39: l_module);
40: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
41: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
42: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
43: /*Bug 7305146*/
44: l_encoding VARCHAR2(20);
45: l_xml_header VARCHAR2(100);

Line 42: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

38: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
39: l_module);
40: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
41: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
42: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
43: /*Bug 7305146*/
44: l_encoding VARCHAR2(20);
45: l_xml_header VARCHAR2(100);
46:

Line 63: -- Write the module name and user parameters to fnd log file

59: l_stmt_num := 10;
60:
61: l_current_org_id := MO_GLOBAL.get_current_org_id;
62:
63: -- Write the module name and user parameters to fnd log file
64:
65: IF (l_pLog) THEN
66: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
67: l_module || '.begin',

Line 66: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

62:
63: -- Write the module name and user parameters to fnd log file
64:
65: IF (l_pLog) THEN
66: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
67: l_module || '.begin',
68: '>>> ' || l_api_name || ':Parameters:
69: Org id:'|| l_current_org_id
70: || 'Title: ' || p_title

Line 159: -- Write the event log to fnd log file

155: l_length := l_length - l_amount;
156: l_offset := l_offset + l_amount;
157: END LOOP;
158:
159: -- Write the event log to fnd log file
160:
161: IF (l_eventLog) THEN
162: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,
163: l_module || '.' || l_stmt_num,

Line 162: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

158:
159: -- Write the event log to fnd log file
160:
161: IF (l_eventLog) THEN
162: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,
163: l_module || '.' || l_stmt_num,
164: 'Completed writing to output file');
165: END IF;
166:

Line 174: -- Write the module name to fnd log file

170: DBMS_LOB.FREETEMPORARY (l_xml_doc);
171:
172: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
173:
174: -- Write the module name to fnd log file
175:
176: IF (l_pLog) THEN
177: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
178: l_module || '.end',

Line 177: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

173:
174: -- Write the module name to fnd log file
175:
176: IF (l_pLog) THEN
177: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
178: l_module || '.end',
179: '<<< ' || l_api_name);
180: END IF;
181:

Line 207: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

203: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
204:
205: WHEN OTHERS THEN
206: IF (l_uLog) THEN
207: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
208: l_module || '.' || l_stmt_num,
209: SUBSTRB (SQLERRM , 1 , 240));
210: END IF;
211:

Line 264: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,

260:
261: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
262: l_module CONSTANT VARCHAR2(2000) := 'cst.plsql.' || l_full_name;
263:
264: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
265: l_module);
266: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
267: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
268: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 266: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

262: l_module CONSTANT VARCHAR2(2000) := 'cst.plsql.' || l_full_name;
263:
264: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
265: l_module);
266: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
267: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
268: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
269:
270: BEGIN

Line 267: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

263:
264: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
265: l_module);
266: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
267: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
268: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
269:
270: BEGIN
271:

Line 268: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

264: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
265: l_module);
266: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
267: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
268: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
269:
270: BEGIN
271:
272: -- Write the module name to fnd log file

Line 272: -- Write the module name to fnd log file

268: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
269:
270: BEGIN
271:
272: -- Write the module name to fnd log file
273:
274: IF (l_pLog) THEN
275: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
276: l_module || '.begin',

Line 275: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

271:
272: -- Write the module name to fnd log file
273:
274: IF (l_pLog) THEN
275: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
276: l_module || '.begin',
277: '>>> ' || l_api_name);
278: END IF;
279:

Line 393: -- Write the module name to fnd log file

389: FND_MSG_PUB.Count_And_Get
390: ( p_count => x_msg_count,
391: p_data => x_msg_data);
392:
393: -- Write the module name to fnd log file
394:
395: IF (l_pLog) THEN
396: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
397: l_module || '.end',

Line 396: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

392:
393: -- Write the module name to fnd log file
394:
395: IF (l_pLog) THEN
396: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
397: l_module || '.end',
398: '<<< ' || l_api_name);
399: END IF;
400:

Line 419: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

415:
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: IF (l_uLog) THEN
419: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
420: l_module || '.' || l_stmt_num,
421: SUBSTRB (SQLERRM , 1 , 240));
422: END IF;
423:

Line 470: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,

466:
467: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
468: l_module CONSTANT VARCHAR2(2000) := 'cst.plsql.' || l_full_name;
469:
470: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
471: l_module);
472: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
473: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
474: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 472: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

468: l_module CONSTANT VARCHAR2(2000) := 'cst.plsql.' || l_full_name;
469:
470: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
471: l_module);
472: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
473: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
474: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
475:
476: BEGIN

Line 473: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

469:
470: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
471: l_module);
472: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
473: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
474: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
475:
476: BEGIN
477:

Line 474: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

470: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
471: l_module);
472: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
473: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
474: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
475:
476: BEGIN
477:
478: -- Write the module name to fnd log file

Line 478: -- Write the module name to fnd log file

474: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
475:
476: BEGIN
477:
478: -- Write the module name to fnd log file
479:
480: IF (l_pLog) THEN
481: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
482: l_module || '.begin',

Line 481: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

477:
478: -- Write the module name to fnd log file
479:
480: IF (l_pLog) THEN
481: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
482: l_module || '.begin',
483: '>>> ' || l_api_name);
484: END IF;
485:

Line 725: -- Write the module name to fnd log file

721: ( p_count => x_msg_count,
722: p_data => x_msg_data
723: );
724:
725: -- Write the module name to fnd log file
726:
727: IF (l_pLog) THEN
728: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
729: l_module || '.end',

Line 728: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

724:
725: -- Write the module name to fnd log file
726:
727: IF (l_pLog) THEN
728: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
729: l_module || '.end',
730: '<<< ' || l_api_name);
731: END IF;
732:

Line 750: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

746:
747: WHEN OTHERS THEN
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
749: IF (l_uLog) THEN
750: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
751: l_module || '.' || l_stmt_num,
752: SUBSTRB (SQLERRM , 1 , 240));
753: END IF;
754: