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

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

2: /* $Header: CSTVAMRB.pls 120.20.12010000.3 2008/10/30 13:42:37 svelumur ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(2000) := 'CST_MiscAccrualReport_PVT';
5: G_LOG_HEADER CONSTANT VARCHAR2(100) := 'cst.plsql.CST_ACCRUAL_MISC_REPORT';
6: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7:
8: PROCEDURE Generate_MiscReportXml (
9: errcode OUT NOCOPY VARCHAR2,
10: errno OUT NOCOPY NUMBER,

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

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

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

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

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

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

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

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

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

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

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

102: ELSE
103: l_to_date := NULL;
104: END IF;
105:
106: -- Write the module name and user parameters to fnd log file
107:
108: IF (l_pLog) THEN
109: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
110: l_module || '.begin',

Line 109: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

105:
106: -- Write the module name and user parameters to fnd log file
107:
108: IF (l_pLog) THEN
109: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
110: l_module || '.begin',
111: '>>> ' || l_api_name || ':Parameters:
112: Org id:'|| l_current_org_id
113: || 'Title: ' || p_title

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

232:
233: DBMS_XMLGEN.closeContext(l_qryCtx);
234:
235:
236: -- Write the event log to fnd log file
237:
238: IF (l_eventLog) THEN
239: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,
240: l_module || '.' || l_stmt_num,

Line 239: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

235:
236: -- Write the event log to fnd log file
237:
238: IF (l_eventLog) THEN
239: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,
240: l_module || '.' || l_stmt_num,
241: 'Completed writing to output file');
242: END IF;
243:

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

245: DBMS_LOB.FREETEMPORARY (l_xml_doc);
246:
247: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
248:
249: -- Write the module name to fnd log file
250:
251: IF (l_pLog) THEN
252: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
253: l_module || '.end',

Line 252: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

248:
249: -- Write the module name to fnd log file
250:
251: IF (l_pLog) THEN
252: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
253: l_module || '.end',
254: '<<< ' || l_api_name);
255: END IF;
256:

Line 263: fnd_log.message(FND_LOG.LEVEL_ERROR,

259: WHEN FND_API.G_EXC_ERROR THEN
260: ROLLBACK;
261: l_return_status := FND_API.g_ret_sts_error;
262: If l_errorLog then
263: fnd_log.message(FND_LOG.LEVEL_ERROR,
264: G_LOG_HEADER || '.' || l_api_name || '(' ||to_char(l_stmt_num)||')',
265: FALSE
266: );
267: end If;

Line 272: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

268:
269: fnd_msg_pub.add;
270:
271: If l_slog then
272: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
273: G_LOG_HEADER || '.'||l_api_name||'('||to_char(l_stmt_num)||')',
274: l_error_message
275: );
276: End If;

Line 313: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

309: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
310:
311: WHEN OTHERS THEN
312: IF (l_uLog) THEN
313: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
314: l_module || '.' || l_stmt_num,
315: SUBSTRB (SQLERRM , 1 , 240));
316: END IF;
317:

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

373:
374: l_full_name CONSTANT VARCHAR2(3000) := G_PKG_NAME || '.' || l_api_name;
375: l_module CONSTANT VARCHAR2(3000) := 'cst.plsql.' || l_full_name;
376:
377: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
378: l_module);
379: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
380: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
381: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

375: l_module CONSTANT VARCHAR2(3000) := 'cst.plsql.' || l_full_name;
376:
377: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
378: l_module);
379: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
380: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
381: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
382:
383: BEGIN

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

376:
377: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
378: l_module);
379: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
380: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
381: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
382:
383: BEGIN
384:

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

377: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
378: l_module);
379: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
380: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
381: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
382:
383: BEGIN
384:
385: -- Write the module name to fnd log file

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

381: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
382:
383: BEGIN
384:
385: -- Write the module name to fnd log file
386:
387: IF (l_pLog) THEN
388: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
389: l_module || '.begin',

Line 388: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

384:
385: -- Write the module name to fnd log file
386:
387: IF (l_pLog) THEN
388: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
389: l_module || '.begin',
390: '>>> ' || l_api_name);
391: END IF;
392:

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

532: ( p_count => x_msg_count,
533: p_data => x_msg_data
534: );
535:
536: -- Write the module name to fnd log file
537:
538: IF (l_pLog) THEN
539: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
540: l_module || '.end',

Line 539: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

535:
536: -- Write the module name to fnd log file
537:
538: IF (l_pLog) THEN
539: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
540: l_module || '.end',
541: '<<< ' || l_api_name);
542: END IF;
543:

Line 562: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

558:
559: WHEN OTHERS THEN
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: IF (l_uLog) THEN
562: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
563: l_module || '.' || l_stmt_num,
564: SUBSTRB (SQLERRM , 1 , 240));
565: END IF;
566:

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

619:
620: l_full_name CONSTANT VARCHAR2(3000) := G_PKG_NAME || '.' || l_api_name;
621: l_module CONSTANT VARCHAR2(3000) := 'cst.plsql.' || l_full_name;
622:
623: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
624: l_module);
625: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
626: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
627: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

621: l_module CONSTANT VARCHAR2(3000) := 'cst.plsql.' || l_full_name;
622:
623: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
624: l_module);
625: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
626: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
627: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
628:
629: BEGIN

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

622:
623: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
624: l_module);
625: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
626: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
627: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
628:
629: BEGIN
630:

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

623: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED,
624: l_module);
625: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
626: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
627: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
628:
629: BEGIN
630:
631: -- Write the module name to fnd log file

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

627: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
628:
629: BEGIN
630:
631: -- Write the module name to fnd log file
632:
633: IF (l_pLog) THEN
634: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
635: l_module || '.begin',

Line 634: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

630:
631: -- Write the module name to fnd log file
632:
633: IF (l_pLog) THEN
634: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
635: l_module || '.begin',
636: '>>> ' || l_api_name);
637: END IF;
638:

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

981: ( p_count => x_msg_count,
982: p_data => x_msg_data
983: );
984:
985: -- Write the module name to fnd log file
986:
987: IF (l_pLog) THEN
988: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
989: l_module || '.end',

Line 988: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

984:
985: -- Write the module name to fnd log file
986:
987: IF (l_pLog) THEN
988: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
989: l_module || '.end',
990: '<<< ' || l_api_name);
991: END IF;
992:

Line 1010: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

1006:
1007: WHEN OTHERS THEN
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1009: IF (l_uLog) THEN
1010: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1011: l_module || '.' || l_stmt_num,
1012: SUBSTRB (SQLERRM , 1 , 240));
1013: END IF;
1014: