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_APPOACCRUALREPORT_PVT dependencies on FND_LOG

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

1: PACKAGE BODY CST_ApPoAccrualReport_PVT AS
2: /* $Header: CSTVAPRB.pls 120.21.12010000.4 2010/04/23 13:46:13 mpuranik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_ApPoAccrualReport_PVT';
5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LOG_HEADER CONSTANT VARCHAR2(100) := 'cst.plsql.CST_ACCRUAL_MISC_REPORT';
7:
8: PROCEDURE Generate_APPOReportXml (
9: errcode OUT NOCOPY VARCHAR2,

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

44:
45: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
46: l_module CONSTANT VARCHAR2(2000) := 'cst.plsql.' || l_full_name;
47:
48: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
49: l_module);
50: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
52: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

46: l_module CONSTANT VARCHAR2(2000) := 'cst.plsql.' || l_full_name;
47:
48: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
49: l_module);
50: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
52: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
53: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
54:

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

47:
48: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
49: l_module);
50: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
52: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
53: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
54:
55: l_conc_request BOOLEAN;

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

48: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
49: l_module);
50: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
52: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
53: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
54:
55: l_conc_request BOOLEAN;
56: /*Bug 7000786*/

Line 53: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

49: l_module);
50: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
52: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
53: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
54:
55: l_conc_request BOOLEAN;
56: /*Bug 7000786*/
57: l_encoding VARCHAR2(20);

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

95: l_stmt_num := 10;
96:
97: l_current_org_id := MO_GLOBAL.get_current_org_id;
98:
99: -- Write the module name and user parameters to fnd log file
100:
101: IF (l_pLog) THEN
102: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
103: l_module || '.begin',

Line 102: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

98:
99: -- Write the module name and user parameters to fnd log file
100:
101: IF (l_pLog) THEN
102: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
103: l_module || '.begin',
104: '>>> ' || l_api_name || ':Parameters:
105: Org id:'|| l_current_org_id
106: || 'Title: ' || p_title

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

218: END LOOP;
219:
220: DBMS_XMLGEN.closeContext(l_qryCtx);
221:
222: -- Write the event log to fnd log file
223:
224: IF (l_eventLog) THEN
225: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,
226: l_module || '.' || l_stmt_num,

Line 225: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

221:
222: -- Write the event log to fnd log file
223:
224: IF (l_eventLog) THEN
225: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,
226: l_module || '.' || l_stmt_num,
227: 'Completed writing to output file');
228: END IF;
229:

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

232: DBMS_LOB.FREETEMPORARY (l_xml_doc);
233:
234: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
235:
236: -- Write the module name to fnd log file
237:
238: IF (l_pLog) THEN
239: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
240: l_module || '.end',

Line 239: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

235:
236: -- Write the module name to fnd log file
237:
238: IF (l_pLog) THEN
239: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
240: l_module || '.end',
241: '<<< ' || l_api_name);
242: END IF;
243:

Line 249: fnd_log.message(FND_LOG.LEVEL_ERROR,

245: WHEN FND_API.G_EXC_ERROR THEN
246: ROLLBACK;
247: l_return_status := FND_API.g_ret_sts_error;
248: If l_errorLog then
249: fnd_log.message(FND_LOG.LEVEL_ERROR,
250: G_LOG_HEADER || '.' || l_api_name || '(' ||to_char(l_stmt_num)||')',
251: FALSE
252: );
253: end If;

Line 258: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

254:
255: fnd_msg_pub.add;
256:
257: If l_slog then
258: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
259: G_LOG_HEADER || '.'||l_api_name||'('||to_char(l_stmt_num)||')',
260: l_error_message
261: );
262: End If;

Line 298: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

294: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
295:
296: WHEN OTHERS THEN
297: IF (l_uLog) THEN
298: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
299: l_module || '.' || l_stmt_num,
300: SUBSTRB (SQLERRM , 1 , 240));
301: END IF;
302:

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

359: l_org_name VARCHAR2(300);
360: l_stmt_num NUMBER;
361: l_current_org_id NUMBER;
362:
363: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
364: l_module);
365: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
366: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
367: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

361: l_current_org_id NUMBER;
362:
363: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
364: l_module);
365: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
366: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
367: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
368:
369: BEGIN

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

362:
363: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
364: l_module);
365: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
366: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
367: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
368:
369: BEGIN
370:

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

363: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
364: l_module);
365: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
366: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
367: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
368:
369: BEGIN
370:
371: -- Write the module name to fnd log file

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

367: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
368:
369: BEGIN
370:
371: -- Write the module name to fnd log file
372:
373: IF (l_pLog) THEN
374: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
375: l_module || '.begin',

Line 374: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

370:
371: -- Write the module name to fnd log file
372:
373: IF (l_pLog) THEN
374: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
375: l_module || '.begin',
376: '>>> ' || l_api_name);
377: END IF;
378:

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

516: FND_MSG_PUB.Count_And_Get
517: ( p_count => x_msg_count,
518: p_data => x_msg_data);
519:
520: -- Write the module name to fnd log file
521:
522: IF (l_pLog) THEN
523: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
524: l_module || '.end',

Line 523: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

519:
520: -- Write the module name to fnd log file
521:
522: IF (l_pLog) THEN
523: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
524: l_module || '.end',
525: '<<< ' || l_api_name);
526: END IF;
527:

Line 546: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

542:
543: WHEN OTHERS THEN
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: IF (l_uLog) THEN
546: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
547: l_module || '.' || l_stmt_num,
548: SUBSTRB (SQLERRM , 1 , 240));
549: END IF;
550:

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

608: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
609: l_module CONSTANT VARCHAR2(2000) := 'cst.plsql.' || l_full_name;
610:
611:
612: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
613: l_module);
614: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
615: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
616: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

610:
611:
612: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
613: l_module);
614: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
615: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
616: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
617:
618: BEGIN

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

611:
612: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
613: l_module);
614: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
615: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
616: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
617:
618: BEGIN
619:

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

612: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
613: l_module);
614: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
615: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
616: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
617:
618: BEGIN
619:
620: -- Write the module name to fnd log file

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

616: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
617:
618: BEGIN
619:
620: -- Write the module name to fnd log file
621:
622: IF (l_pLog) THEN
623: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
624: l_module || '.begin',

Line 623: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

619:
620: -- Write the module name to fnd log file
621:
622: IF (l_pLog) THEN
623: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
624: l_module || '.begin',
625: '>>> ' || l_api_name);
626: END IF;
627:

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

1007: ( p_count => x_msg_count,
1008: p_data => x_msg_data
1009: );
1010:
1011: -- Write the module name to fnd log file
1012:
1013: IF (l_pLog) THEN
1014: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1015: l_module || '.end',

Line 1014: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1010:
1011: -- Write the module name to fnd log file
1012:
1013: IF (l_pLog) THEN
1014: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1015: l_module || '.end',
1016: '<<< ' || l_api_name);
1017: END IF;
1018:

Line 1036: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

1032:
1033: WHEN OTHERS THEN
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035: IF (l_uLog) THEN
1036: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1037: l_module || '.' || l_stmt_num,
1038: SUBSTRB (SQLERRM , 1 , 240));
1039: END IF;
1040: