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

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

1: PACKAGE BODY CST_ReceiptAccrualPerEnd_PVT AS
2: /* $Header: CSTVRAPB.pls 120.18 2010/06/18 00:59:05 jkwac ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='CST_ReceiptAccrualPerEnd_PVT';
5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: G_GL_APPLICATION_ID CONSTANT NUMBER := 101;
8: G_PO_APPLICATION_ID CONSTANT NUMBER := 201;
9: G_CST_APPLICATION_ID CONSTANT NUMBER := 707;

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

43: /* 2- PROCEDURE */
44: /* 1- STATEMENT */
45:
46: /* In general, we should use the following:
47: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
48: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
49: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
50: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

44: /* 1- STATEMENT */
45:
46: /* In general, we should use the following:
47: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
48: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
49: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
50: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
52: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

45:
46: /* In general, we should use the following:
47: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
48: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
49: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
50: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_exceptionLog 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);

Line 50: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

46: /* In general, we should use the following:
47: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
48: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
49: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
50: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_exceptionLog 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_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

47: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
48: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
49: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
50: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_exceptionLog 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:

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

48: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
49: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
50: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_exceptionLog 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:
56: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

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

49: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
50: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
51: l_eventLog CONSTANT BOOLEAN := l_exceptionLog 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:
56: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
57: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

Line 56: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= 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:
56: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
57: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
58: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
59: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
60:

Line 57: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

53: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
54: */
55:
56: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
57: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
58: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
59: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
60:
61: l_conc_status BOOLEAN;

Line 58: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

54: */
55:
56: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
57: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
58: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
59: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
60:
61: l_conc_status BOOLEAN;
62: l_return BOOLEAN;

Line 59: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

55:
56: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
57: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
58: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
59: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
60:
61: l_conc_status BOOLEAN;
62: l_return BOOLEAN;
63: l_status VARCHAR2(1);

Line 78: FND_LOG.STRING(

74: g_counter := 0;
75: l_stmt_num := 0;
76: -- Procedure level log message for Entry point
77: IF (l_pLog) THEN
78: FND_LOG.STRING(
79: FND_LOG.LEVEL_PROCEDURE,
80: l_module || '.begin',
81: 'Start_Process <<' ||
82: 'p_min_accrual_amount = ' || p_min_accrual_amount ||','||

Line 79: FND_LOG.LEVEL_PROCEDURE,

75: l_stmt_num := 0;
76: -- Procedure level log message for Entry point
77: IF (l_pLog) THEN
78: FND_LOG.STRING(
79: FND_LOG.LEVEL_PROCEDURE,
80: l_module || '.begin',
81: 'Start_Process <<' ||
82: 'p_min_accrual_amount = ' || p_min_accrual_amount ||','||
83: 'p_vendor_id = ' || p_vendor_id ||','||

Line 215: FND_LOG.STRING(

211: END IF;
212:
213: -- Procedure level log message for exit point
214: IF (l_pLog) THEN
215: FND_LOG.STRING(
216: FND_LOG.LEVEL_PROCEDURE,
217: l_module || '.end',
218: 'Start_Process >>'
219: );

Line 216: FND_LOG.LEVEL_PROCEDURE,

212:
213: -- Procedure level log message for exit point
214: IF (l_pLog) THEN
215: FND_LOG.STRING(
216: FND_LOG.LEVEL_PROCEDURE,
217: l_module || '.end',
218: 'Start_Process >>'
219: );
220: END IF;

Line 229: FND_LOG.STRING(

225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO Start_Process_PVT;
227:
228: IF (l_exceptionLog) THEN
229: FND_LOG.STRING(
230: FND_LOG.LEVEL_EXCEPTION,
231: l_module || '.' || l_stmt_num,
232: l_msg_data
233: );

Line 230: FND_LOG.LEVEL_EXCEPTION,

226: ROLLBACK TO Start_Process_PVT;
227:
228: IF (l_exceptionLog) THEN
229: FND_LOG.STRING(
230: FND_LOG.LEVEL_EXCEPTION,
231: l_module || '.' || l_stmt_num,
232: l_msg_data
233: );
234: END IF;

Line 250: -- Unexpected level log message for FND log

246:
247: WHEN OTHERS THEN
248: ROLLBACK TO Start_Process_PVT;
249:
250: -- Unexpected level log message for FND log
251: IF (l_uLog) THEN
252: FND_LOG.STRING(
253: FND_LOG.LEVEL_UNEXPECTED,
254: l_module || '.' || l_stmt_num,

Line 252: FND_LOG.STRING(

248: ROLLBACK TO Start_Process_PVT;
249:
250: -- Unexpected level log message for FND log
251: IF (l_uLog) THEN
252: FND_LOG.STRING(
253: FND_LOG.LEVEL_UNEXPECTED,
254: l_module || '.' || l_stmt_num,
255: SQLERRM
256: );

Line 253: FND_LOG.LEVEL_UNEXPECTED,

249:
250: -- Unexpected level log message for FND log
251: IF (l_uLog) THEN
252: FND_LOG.STRING(
253: FND_LOG.LEVEL_UNEXPECTED,
254: l_module || '.' || l_stmt_num,
255: SQLERRM
256: );
257: END IF;

Line 313: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

309:
310: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
311: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.'||l_full_name;
312:
313: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
314: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
315: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
316: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
317:

Line 314: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

310: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
311: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.'||l_full_name;
312:
313: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
314: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
315: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
316: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
317:
318: l_stmt_num NUMBER;

Line 315: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

311: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.'||l_full_name;
312:
313: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
314: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
315: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
316: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
317:
318: l_stmt_num NUMBER;
319: l_msg_data VARCHAR2(240);

Line 316: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

312:
313: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
314: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
315: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
316: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
317:
318: l_stmt_num NUMBER;
319: l_msg_data VARCHAR2(240);
320: l_ctr NUMBER;

Line 355: FND_LOG.STRING(

351:
352: l_stmt_num := 0;
353: -- Procedure level log message for Entry point
354: IF (l_pLog) THEN
355: FND_LOG.STRING(
356: FND_LOG.LEVEL_PROCEDURE,
357: l_module || '.begin',
358: 'Insert_AccrualSubLedger <<');
359: END IF;

Line 356: FND_LOG.LEVEL_PROCEDURE,

352: l_stmt_num := 0;
353: -- Procedure level log message for Entry point
354: IF (l_pLog) THEN
355: FND_LOG.STRING(
356: FND_LOG.LEVEL_PROCEDURE,
357: l_module || '.begin',
358: 'Insert_AccrualSubLedger <<');
359: END IF;
360:

Line 658: FND_LOG.STRING(

654: g_rae_cur_conv_date_tbl.DELETE;
655:
656: -- Procedure level log message for exit point
657: IF (l_pLog) THEN
658: FND_LOG.STRING(
659: FND_LOG.LEVEL_PROCEDURE,
660: l_module || '.end',
661: 'Insert_AccrualSubLedger >>'
662: );

Line 659: FND_LOG.LEVEL_PROCEDURE,

655:
656: -- Procedure level log message for exit point
657: IF (l_pLog) THEN
658: FND_LOG.STRING(
659: FND_LOG.LEVEL_PROCEDURE,
660: l_module || '.end',
661: 'Insert_AccrualSubLedger >>'
662: );
663: END IF;

Line 683: FND_LOG.STRING(

679: ROLLBACK TO Seed_RcvAccountingEvents_PVT;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
681:
682: IF (l_exceptionLog) THEN
683: FND_LOG.STRING(
684: FND_LOG.LEVEL_EXCEPTION,
685: l_module || '.' || l_stmt_num,
686: l_msg_data
687: );

Line 684: FND_LOG.LEVEL_EXCEPTION,

680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
681:
682: IF (l_exceptionLog) THEN
683: FND_LOG.STRING(
684: FND_LOG.LEVEL_EXCEPTION,
685: l_module || '.' || l_stmt_num,
686: l_msg_data
687: );
688: END IF;

Line 701: FND_LOG.STRING(

697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698:
699: -- Unexpected level log message
700: IF (l_uLog) THEN
701: FND_LOG.STRING(
702: FND_LOG.LEVEL_UNEXPECTED,
703: l_module || '.' || l_stmt_num,
704: SQLERRM
705: );

Line 702: FND_LOG.LEVEL_UNEXPECTED,

698:
699: -- Unexpected level log message
700: IF (l_uLog) THEN
701: FND_LOG.STRING(
702: FND_LOG.LEVEL_UNEXPECTED,
703: l_module || '.' || l_stmt_num,
704: SQLERRM
705: );
706: END IF;

Line 752: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

748:
749: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
750: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.'||l_full_name;
751:
752: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
753: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
754: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
755: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
756:

Line 753: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

749: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
750: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.'||l_full_name;
751:
752: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
753: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
754: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
755: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
756:
757: l_stmt_num NUMBER;

Line 754: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

750: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.'||l_full_name;
751:
752: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
753: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
754: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
755: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
756:
757: l_stmt_num NUMBER;
758: l_msg_data VARCHAR2(240);

Line 755: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

751:
752: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
753: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
754: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
755: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
756:
757: l_stmt_num NUMBER;
758: l_msg_data VARCHAR2(240);
759:

Line 837: FND_LOG.STRING(

833:
834: l_stmt_num := 0;
835: -- Procedure level log message for Entry point
836: IF (l_pLog) THEN
837: FND_LOG.STRING(
838: FND_LOG.LEVEL_PROCEDURE,
839: l_module || '.begin',
840: 'Create_AccrualAccount <<');
841: END IF;

Line 838: FND_LOG.LEVEL_PROCEDURE,

834: l_stmt_num := 0;
835: -- Procedure level log message for Entry point
836: IF (l_pLog) THEN
837: FND_LOG.STRING(
838: FND_LOG.LEVEL_PROCEDURE,
839: l_module || '.begin',
840: 'Create_AccrualAccount <<');
841: END IF;
842:

Line 1207: FND_LOG.STRING(

1203: /*Bug6987381 End */
1204: <>
1205: -- Procedure level log message for exit point
1206: IF (l_pLog) THEN
1207: FND_LOG.STRING(
1208: FND_LOG.LEVEL_PROCEDURE,
1209: l_module || '.end',
1210: 'Create_AccrualAccount >>'
1211: );

Line 1208: FND_LOG.LEVEL_PROCEDURE,

1204: <>
1205: -- Procedure level log message for exit point
1206: IF (l_pLog) THEN
1207: FND_LOG.STRING(
1208: FND_LOG.LEVEL_PROCEDURE,
1209: l_module || '.end',
1210: 'Create_AccrualAccount >>'
1211: );
1212: END IF;

Line 1232: FND_LOG.STRING(

1228: ROLLBACK TO Create_AccrualAccount_PVT;
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1230:
1231: IF (l_exceptionLog) THEN
1232: FND_LOG.STRING(
1233: FND_LOG.LEVEL_EXCEPTION,
1234: l_module || '.' || l_stmt_num,
1235: l_msg_data
1236: );

Line 1233: FND_LOG.LEVEL_EXCEPTION,

1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1230:
1231: IF (l_exceptionLog) THEN
1232: FND_LOG.STRING(
1233: FND_LOG.LEVEL_EXCEPTION,
1234: l_module || '.' || l_stmt_num,
1235: l_msg_data
1236: );
1237: END IF;

Line 1250: FND_LOG.STRING(

1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247:
1248: -- Unexpected level log message
1249: IF (l_uLog) THEN
1250: FND_LOG.STRING(
1251: FND_LOG.LEVEL_UNEXPECTED,
1252: l_module || '.' || l_stmt_num,
1253: SQLERRM
1254: );

Line 1251: FND_LOG.LEVEL_UNEXPECTED,

1247:
1248: -- Unexpected level log message
1249: IF (l_uLog) THEN
1250: FND_LOG.STRING(
1251: FND_LOG.LEVEL_UNEXPECTED,
1252: l_module || '.' || l_stmt_num,
1253: SQLERRM
1254: );
1255: END IF;

Line 1302: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

1298:
1299: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1300: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1301:
1302: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1303: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1304: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1305: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1306:

Line 1303: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

1299: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1300: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1301:
1302: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1303: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1304: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1305: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1306:
1307: l_stmt_num NUMBER;

Line 1304: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1300: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1301:
1302: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1303: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1304: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1305: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1306:
1307: l_stmt_num NUMBER;
1308: l_msg_data VARCHAR2(240);

Line 1305: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1301:
1302: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1303: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1304: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1305: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1306:
1307: l_stmt_num NUMBER;
1308: l_msg_data VARCHAR2(240);
1309:

Line 1317: FND_LOG.STRING(

1313:
1314: l_stmt_num := 0;
1315: -- Procedure level log message for Entry point
1316: IF (l_pLog) THEN
1317: FND_LOG.STRING(
1318: FND_LOG.LEVEL_PROCEDURE,
1319: l_module || '.begin',
1320: 'Insert_Account <<');
1321: END IF;

Line 1318: FND_LOG.LEVEL_PROCEDURE,

1314: l_stmt_num := 0;
1315: -- Procedure level log message for Entry point
1316: IF (l_pLog) THEN
1317: FND_LOG.STRING(
1318: FND_LOG.LEVEL_PROCEDURE,
1319: l_module || '.begin',
1320: 'Insert_Account <<');
1321: END IF;
1322:

Line 1404: FND_LOG.STRING(

1400: END IF;
1401:
1402: -- Procedure level log message for exit point
1403: IF (l_pLog) THEN
1404: FND_LOG.STRING(
1405: FND_LOG.LEVEL_PROCEDURE,
1406: l_module || '.end',
1407: 'Insert_Account >>'
1408: );

Line 1405: FND_LOG.LEVEL_PROCEDURE,

1401:
1402: -- Procedure level log message for exit point
1403: IF (l_pLog) THEN
1404: FND_LOG.STRING(
1405: FND_LOG.LEVEL_PROCEDURE,
1406: l_module || '.end',
1407: 'Insert_Account >>'
1408: );
1409: END IF;

Line 1429: FND_LOG.STRING(

1425: ROLLBACK TO Insert_Account_PVT;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1427:
1428: IF (l_exceptionLog) THEN
1429: FND_LOG.STRING(
1430: FND_LOG.LEVEL_EXCEPTION,
1431: l_module || '.' || l_stmt_num,
1432: l_msg_data
1433: );

Line 1430: FND_LOG.LEVEL_EXCEPTION,

1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1427:
1428: IF (l_exceptionLog) THEN
1429: FND_LOG.STRING(
1430: FND_LOG.LEVEL_EXCEPTION,
1431: l_module || '.' || l_stmt_num,
1432: l_msg_data
1433: );
1434: END IF;

Line 1447: FND_LOG.STRING(

1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444:
1445: -- Unexpected level log message
1446: IF (l_uLog) THEN
1447: FND_LOG.STRING(
1448: FND_LOG.LEVEL_UNEXPECTED,
1449: l_module || '.' || l_stmt_num,
1450: SQLERRM
1451: );

Line 1448: FND_LOG.LEVEL_UNEXPECTED,

1444:
1445: -- Unexpected level log message
1446: IF (l_uLog) THEN
1447: FND_LOG.STRING(
1448: FND_LOG.LEVEL_UNEXPECTED,
1449: l_module || '.' || l_stmt_num,
1450: SQLERRM
1451: );
1452: END IF;

Line 1497: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

1493:
1494: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1495: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.'||l_full_name;
1496:
1497: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1498: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1499: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1500: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1501:

Line 1498: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

1494: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1495: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.'||l_full_name;
1496:
1497: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1498: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1499: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1500: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1501:
1502: l_stmt_num NUMBER;

Line 1499: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1495: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.'||l_full_name;
1496:
1497: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1498: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1499: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1500: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1501:
1502: l_stmt_num NUMBER;
1503: l_msg_data VARCHAR2(240);

Line 1500: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1496:
1497: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1498: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1499: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1500: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1501:
1502: l_stmt_num NUMBER;
1503: l_msg_data VARCHAR2(240);
1504: l_ctr NUMBER;

Line 1516: FND_LOG.STRING(

1512:
1513: l_stmt_num := 0;
1514: -- Procedure level log message for Entry point
1515: IF (l_pLog) THEN
1516: FND_LOG.STRING(
1517: FND_LOG.LEVEL_PROCEDURE,
1518: l_module || '.begin',
1519: 'Insert_AccrualSubLedger <<');
1520: END IF;

Line 1517: FND_LOG.LEVEL_PROCEDURE,

1513: l_stmt_num := 0;
1514: -- Procedure level log message for Entry point
1515: IF (l_pLog) THEN
1516: FND_LOG.STRING(
1517: FND_LOG.LEVEL_PROCEDURE,
1518: l_module || '.begin',
1519: 'Insert_AccrualSubLedger <<');
1520: END IF;
1521:

Line 1659: FND_LOG.STRING(

1655: g_pnt_rcv_acc_event_id_tbl.DELETE;
1656:
1657: -- Procedure level log message for exit point
1658: IF (l_pLog) THEN
1659: FND_LOG.STRING(
1660: FND_LOG.LEVEL_PROCEDURE,
1661: l_module || '.end',
1662: 'Insert_AccrualSubLedger >>'
1663: );

Line 1660: FND_LOG.LEVEL_PROCEDURE,

1656:
1657: -- Procedure level log message for exit point
1658: IF (l_pLog) THEN
1659: FND_LOG.STRING(
1660: FND_LOG.LEVEL_PROCEDURE,
1661: l_module || '.end',
1662: 'Insert_AccrualSubLedger >>'
1663: );
1664: END IF;

Line 1684: FND_LOG.STRING(

1680: ROLLBACK TO Insert_AccrualSubLedger_PVT;
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1682:
1683: IF (l_exceptionLog) THEN
1684: FND_LOG.STRING(
1685: FND_LOG.LEVEL_EXCEPTION,
1686: l_module || '.' || l_stmt_num,
1687: l_msg_data
1688: );

Line 1685: FND_LOG.LEVEL_EXCEPTION,

1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1682:
1683: IF (l_exceptionLog) THEN
1684: FND_LOG.STRING(
1685: FND_LOG.LEVEL_EXCEPTION,
1686: l_module || '.' || l_stmt_num,
1687: l_msg_data
1688: );
1689: END IF;

Line 1702: FND_LOG.STRING(

1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1699:
1700: -- Unexpected level log message
1701: IF (l_uLog) THEN
1702: FND_LOG.STRING(
1703: FND_LOG.LEVEL_UNEXPECTED,
1704: l_module || '.' || l_stmt_num,
1705: SQLERRM
1706: );

Line 1703: FND_LOG.LEVEL_UNEXPECTED,

1699:
1700: -- Unexpected level log message
1701: IF (l_uLog) THEN
1702: FND_LOG.STRING(
1703: FND_LOG.LEVEL_UNEXPECTED,
1704: l_module || '.' || l_stmt_num,
1705: SQLERRM
1706: );
1707: END IF;

Line 1753: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

1749:
1750: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1751: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1752:
1753: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1754: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1755: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1756: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1757: l_stmt_num NUMBER;

Line 1754: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

1750: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1751: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1752:
1753: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1754: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1755: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1756: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1757: l_stmt_num NUMBER;
1758: l_msg_data VARCHAR2(240);

Line 1755: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1751: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1752:
1753: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1754: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1755: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1756: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1757: l_stmt_num NUMBER;
1758: l_msg_data VARCHAR2(240);
1759:

Line 1756: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1752:
1753: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1754: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1755: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1756: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1757: l_stmt_num NUMBER;
1758: l_msg_data VARCHAR2(240);
1759:
1760: l_application_id NUMBER;

Line 1777: FND_LOG.STRING(

1773:
1774: l_stmt_num := 0;
1775: -- Procedure level log message for Entry point
1776: IF (l_pLog) THEN
1777: FND_LOG.STRING(
1778: FND_LOG.LEVEL_PROCEDURE,
1779: l_module || '.begin',
1780: 'Get_SystemSetup <<' ||
1781: 'p_period_name =' || p_period_name);

Line 1778: FND_LOG.LEVEL_PROCEDURE,

1774: l_stmt_num := 0;
1775: -- Procedure level log message for Entry point
1776: IF (l_pLog) THEN
1777: FND_LOG.STRING(
1778: FND_LOG.LEVEL_PROCEDURE,
1779: l_module || '.begin',
1780: 'Get_SystemSetup <<' ||
1781: 'p_period_name =' || p_period_name);
1782: END IF;

Line 1886: FND_LOG.STRING(

1882: WHERE je_source_name = 'Purchasing';
1883:
1884: -- Procedure level log message for exit point
1885: IF (l_pLog) THEN
1886: FND_LOG.STRING(
1887: FND_LOG.LEVEL_PROCEDURE,
1888: l_module || '.end',
1889: 'Get_SystemSetup >> ' ||
1890: 'set_of_books_id = ' || x_sys_setup_rec.set_of_books_id ||','||

Line 1887: FND_LOG.LEVEL_PROCEDURE,

1883:
1884: -- Procedure level log message for exit point
1885: IF (l_pLog) THEN
1886: FND_LOG.STRING(
1887: FND_LOG.LEVEL_PROCEDURE,
1888: l_module || '.end',
1889: 'Get_SystemSetup >> ' ||
1890: 'set_of_books_id = ' || x_sys_setup_rec.set_of_books_id ||','||
1891: 'chart_of_accounts_id = ' || x_sys_setup_rec.chart_of_accounts_id ||','||

Line 1913: FND_LOG.STRING(

1909: ROLLBACK TO Get_SystemSetup_PVT;
1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1911:
1912: IF (l_exceptionLog) THEN
1913: FND_LOG.STRING(
1914: FND_LOG.LEVEL_EXCEPTION,
1915: l_module || '.' || l_stmt_num,
1916: l_msg_data
1917: );

Line 1914: FND_LOG.LEVEL_EXCEPTION,

1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1911:
1912: IF (l_exceptionLog) THEN
1913: FND_LOG.STRING(
1914: FND_LOG.LEVEL_EXCEPTION,
1915: l_module || '.' || l_stmt_num,
1916: l_msg_data
1917: );
1918: END IF;

Line 1931: FND_LOG.STRING(

1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1928:
1929: -- Unexpected level log message
1930: IF (l_uLog) THEN
1931: FND_LOG.STRING(
1932: FND_LOG.LEVEL_UNEXPECTED,
1933: l_module || '.' || l_stmt_num,
1934: SQLERRM
1935: );

Line 1932: FND_LOG.LEVEL_UNEXPECTED,

1928:
1929: -- Unexpected level log message
1930: IF (l_uLog) THEN
1931: FND_LOG.STRING(
1932: FND_LOG.LEVEL_UNEXPECTED,
1933: l_module || '.' || l_stmt_num,
1934: SQLERRM
1935: );
1936: END IF;