APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_LOG

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

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_RevenueCogsMatch_PVT';
5: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'cst.plsql.'||G_PKG_NAME;
7: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_module_name VARCHAR2(255) := G_LOG_HEAD;
9:
10: --BUG#7463298
11: g_ledger_id NUMBER := -1;

Line 22: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);

18: PROCEDURE debug
19: ( line IN VARCHAR2,
20: msg_prefix IN VARCHAR2 DEFAULT 'CST',
21: msg_module IN VARCHAR2 DEFAULT g_module_name,
22: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
23:
24: -- Ensure the MMT transaction_date and the acct_period_id match
25: PROCEDURE ensure_mmt_per_and_date
26: (x_return_status OUT NOCOPY VARCHAR2,

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

94: l_msg_data VARCHAR2(8000) := '';
95: l_stmt_num NUMBER := 0;
96:
97: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
98: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
99: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
100: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
101: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
102: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 99: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

95: l_stmt_num NUMBER := 0;
96:
97: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
98: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
99: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
100: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
101: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
102: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
103:

Line 100: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

96:
97: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
98: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
99: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
100: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
101: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
102: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
103:
104: program_exception EXCEPTION;

Line 101: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

97: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
98: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
99: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
100: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
101: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
102: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
103:
104: program_exception EXCEPTION;
105: CONC_STATUS BOOLEAN; -- variable for concurrent request completion status

Line 102: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

98: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
99: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
100: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
101: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
102: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
103:
104: program_exception EXCEPTION;
105: CONC_STATUS BOOLEAN; -- variable for concurrent request completion status
106:

Line 136: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

132: debug(' p_ledger_id : '|| p_ledger_id);
133: debug(' p_neg_req_id: '|| p_neg_req_id);
134:
135: /* IF l_procLog THEN
136: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
137: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
138: 'p_api_version = '||p_api_version||','||
139: 'p_low_date = '||p_low_date||','||
140: 'p_high_date = '||p_high_date||','||

Line 195: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));

191: x_return_status => l_return_status);
192:
193: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
194: IF l_errorLog THEN
195: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));
196: END IF;
197: raise program_exception;
198: END IF;
199:

Line 211: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));

207: x_return_status => l_return_status);
208:
209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
210: IF l_errorLog THEN
211: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));
212: END IF;
213: raise program_exception;
214: END IF;
215:

Line 217: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'

213: raise program_exception;
214: END IF;
215:
216: IF l_eventLog THEN
217: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'
218: ,'Completed phase 1 successfully.');
219: END IF;
220:
221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

Line 258: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module||'.'||l_stmt_num,

254: -- by OM line and accounting period.
255: l_stmt_num := 30;
256:
257: IF l_stmtLog THEN
258: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module||'.'||l_stmt_num,
259: 'Calling AR_MATCH_REV_COGS_GRP.populate_cst_tables with '||
260: 'p_from_gl_date = '||l_low_date||','||
261: 'p_to_gl_date = '||l_high_date||',');
262: END IF;

Line 279: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));

275: );
276:
277: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
278: IF l_errorLog THEN
279: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));
280: END IF;
281: raise program_exception;
282: END IF;
283:

Line 285: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'

281: raise program_exception;
282: END IF;
283:
284: IF l_eventLog THEN
285: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'
286: ,'Completed phase 2 successfully.');
287: END IF;
288:
289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

Line 380: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));

376: ,p_neg_req_id => p_neg_req_id); -- BUG#7387575
377:
378: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
379: IF l_errorLog THEN
380: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));
381: END IF;
382: raise program_exception;
383: END IF;
384:

Line 423: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'

419:
420: END IF;
421:
422: IF l_eventLog THEN
423: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'
424: ,'Completed phase 3 successfully.');
425: END IF;
426:
427: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

Line 456: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));

452: ,p_neg_req_id => p_neg_req_id);--BUG7387575
453:
454: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
455: IF l_errorLog THEN
456: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));
457: END IF;
458: raise program_exception;
459: END IF;
460:

Line 462: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'

458: raise program_exception;
459: END IF;
460:
461: IF l_eventLog THEN
462: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'
463: ,'Completed phase 4 successfully.');
464: END IF;
465:
466: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

Line 483: fnd_log.string(fnd_log.level_procedure,l_module||'.end',

479:
480: -- End API Body
481: /*
482: IF l_proclog THEN
483: fnd_log.string(fnd_log.level_procedure,l_module||'.end',
484: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
485: 'x_return_status = '||x_return_status||
486: 'x_dummy_out = '||x_dummy_out
487: );

Line 507: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);

503: FND_MSG_PUB.ADD;
504: END IF;
505:
506: IF l_errorLog THEN
507: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);
508: END IF;
509:
510: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_module||' failed to complete.');
511:

Line 533: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

529:
530: x_return_status := fnd_api.g_ret_sts_unexp_error ;
531:
532: IF l_unexpLog THEN
533: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
534: ,substrb(SQLERRM,1,250));
535: END IF;
536:
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

587: l_stmt_num NUMBER := 0;
588: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
589:
590: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
591: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
592: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
593: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
594: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
595: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 592: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

588: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
589:
590: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
591: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
592: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
593: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
594: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
595: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
596:

Line 593: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

589:
590: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
591: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
592: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
593: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
594: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
595: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
596:
597: CURSOR c_sales_order_issues IS

Line 594: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

590: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
591: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
592: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
593: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
594: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
595: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
596:
597: CURSOR c_sales_order_issues IS
598: SELECT mmt.trx_source_line_id cogs_om_line_id,

Line 595: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

591: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
592: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
593: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
594: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
595: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
596:
597: CURSOR c_sales_order_issues IS
598: SELECT mmt.trx_source_line_id cogs_om_line_id,
599: mmt.distribution_account_id cogs_acct_id,

Line 643: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

639:
640: l_stmt_num := 0;
641:
642: IF l_procLog THEN
643: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
644: 'Entering '||G_PKG_NAME||'.'||l_api_name
645: );
646: END IF;
647:

Line 689: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.10',TRUE);

685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
686: FND_MSG_PUB.ADD;
687: END IF;
688: IF l_errorLog THEN
689: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.10',TRUE);
690: END IF;
691: ELSE
692: l_so_count := l_so_count + 1;
693: END IF;

Line 699: FND_LOG.string(FND_LOG.LEVEL_EVENT, G_LOG_HEAD ||'.'|| l_api_name || '.10', l_api_message);

695: END LOOP all_sales_orders_loop;
696:
697: IF l_eventLog THEN
698: l_api_message := 'Inserted '||to_char(l_so_count)||' sales order issues into CCE.';
699: FND_LOG.string(FND_LOG.LEVEL_EVENT, G_LOG_HEAD ||'.'|| l_api_name || '.10', l_api_message);
700: END IF;
701:
702: -- End API Body
703:

Line 705: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

701:
702: -- End API Body
703:
704: IF l_proclog THEN
705: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
706: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
707: 'x_return_status = '||x_return_status
708: );
709: END IF;

Line 718: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

714: ROLLBACK TO Insert_SoIssues_PVT;
715: x_return_status := fnd_api.g_ret_sts_unexp_error ;
716:
717: IF l_unexpLog THEN
718: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
719: ,'Insert_SoIssues ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
720: END IF;
721:
722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

764:
765: l_api_name CONSTANT VARCHAR2(30) := 'Insert_RmaReceipts';
766: l_api_message VARCHAR2(1000);
767: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
768: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
769: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
770: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
771: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
772: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 769: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

765: l_api_name CONSTANT VARCHAR2(30) := 'Insert_RmaReceipts';
766: l_api_message VARCHAR2(1000);
767: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
768: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
769: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
770: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
771: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
772: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
773:

Line 770: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

766: l_api_message VARCHAR2(1000);
767: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
768: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
769: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
770: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
771: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
772: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
773:
774: l_stmt_num NUMBER := 0;

Line 771: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

767: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
768: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
769: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
770: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
771: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
772: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
773:
774: l_stmt_num NUMBER := 0;
775:

Line 772: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

768: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
769: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
770: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
771: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
772: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
773:
774: l_stmt_num NUMBER := 0;
775:
776: CURSOR c_rma_receipts IS

Line 860: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

856:
857: l_stmt_num := 0;
858:
859: /* IF l_procLog THEN
860: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
861: 'Entering '||G_PKG_NAME||'.'||l_api_name
862: );
863: END IF;
864: */

Line 1273: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);

1269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1270: FND_MSG_PUB.ADD;
1271: END IF;
1272: IF l_errorLog THEN
1273: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);
1274: END IF;
1275: raise program_exception;
1276: END IF;
1277:

Line 1287: FND_LOG.string(FND_LOG.LEVEL_EVENT, G_LOG_HEAD ||'.'|| l_api_name || '.'||l_stmt_num, l_api_message);

1283: END LOOP all_rma_receipts_loop;
1284:
1285: IF l_eventLog THEN
1286: l_api_message := 'Inserted '||to_char(l_rma_count)||' RMA Receipts into CCE.';
1287: FND_LOG.string(FND_LOG.LEVEL_EVENT, G_LOG_HEAD ||'.'|| l_api_name || '.'||l_stmt_num, l_api_message);
1288: END IF;
1289:
1290: -- End API Body
1291:

Line 1293: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

1289:
1290: -- End API Body
1291:
1292: IF l_proclog THEN
1293: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
1294: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
1295: 'x_return_status = '||x_return_status
1296: );
1297: END IF;

Line 1310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1306: ROLLBACK TO Insert_RmaReceipts_PVT;
1307: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1308:
1309: IF l_unexpLog THEN
1310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1311: ,'Insert_RmaReceipts ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
1312: END IF;
1313:
1314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

1359: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1360: l_stmt_num NUMBER := 0;
1361:
1362: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1363: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1364: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1365: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1366: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1367: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 1364: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

1360: l_stmt_num NUMBER := 0;
1361:
1362: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1363: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1364: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1365: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1366: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1367: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1368:

Line 1365: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

1361:
1362: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1363: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1364: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1365: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1366: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1367: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1368:
1369: --{BUG#5726230

Line 1366: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1362: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1363: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1364: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1365: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1366: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1367: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1368:
1369: --{BUG#5726230
1370: -- Add cursor for ledger access

Line 1367: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1363: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1364: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1365: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1366: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1367: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1368:
1369: --{BUG#5726230
1370: -- Add cursor for ledger access
1371: CURSOR cu_ledger(p_ledger_id IN NUMBER)

Line 1527: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

1523:
1524: l_stmt_num := 0;
1525:
1526: IF l_procLog THEN
1527: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
1528: 'Entering '||G_PKG_NAME||'.'||l_api_name
1529: );
1530: END IF;
1531:

Line 1830: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module||'.10',

1826:
1827: EXIT acct_period_loop WHEN l_revenue_acct_period_num IS NULL;
1828:
1829: IF l_stmtLog THEN
1830: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module||'.10',
1831: -- 'Ledger ID.Min Acct Per Num = '||to_char(l_sob.set_of_books_id)||'.'||to_char(l_revenue_acct_period_num));
1832: 'Ledger ID.Min Acct Per Num = '||l_sob||'.'||l_revenue_acct_period_num);
1833: END IF;
1834:

Line 1895: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);

1891: FND_MESSAGE.set_token('LEDGER', l_sob); -- to_char(l_sob.set_of_books_id)
1892: FND_MESSAGE.set_token('PERIOD_NAME',l_period_name);
1893: FND_MSG_PUB.ADD;
1894: IF l_errorLog THEN
1895: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);
1896: END IF;
1897: END IF;
1898: raise no_data_found;
1899: END;

Line 2340: debug(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num));

2336: x_msg_count => l_msg_count,
2337: x_msg_data => l_error_message);
2338:
2339: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2340: debug(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num));
2341: raise program_exception;
2342: END IF;
2343: --}
2344:

Line 2363: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);

2359: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2360: FND_MSG_PUB.ADD;
2361: END IF;
2362: IF l_errorLog THEN
2363: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);
2364: END IF;
2365: raise program_exception;
2366: END IF;
2367:

Line 2389: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module||'.100',

2385:
2386: END LOOP mismatched_lines_loop; -- c_mismatched_lines bulk fetches
2387:
2388: IF l_stmtLog THEN
2389: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module||'.100',
2390: 'Ledger.PerNum.InsertedEvents = '||l_sob||'.'|| --to_char(l_sob.set_of_books_id)||'.'||
2391: l_cogs_acct_period_num||'.'||l_cce_count);
2392: END IF;
2393:

Line 2438: FND_LOG.string(FND_LOG.LEVEL_EVENT, G_LOG_HEAD ||'.'|| l_api_name || '.10', l_api_message);

2434: END LOOP sob_loop;
2435:
2436: IF l_eventLog THEN
2437: l_api_message := 'Inserted '||to_char(l_cce_count)||' new COGS Recognition Events into CCE.';
2438: FND_LOG.string(FND_LOG.LEVEL_EVENT, G_LOG_HEAD ||'.'|| l_api_name || '.10', l_api_message);
2439: END IF;
2440:
2441: -- End API Body
2442:

Line 2444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

2440:
2441: -- End API Body
2442:
2443: IF l_proclog THEN
2444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
2445: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
2446: 'x_return_status = '||x_return_status
2447: );
2448: END IF;

Line 2478: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

2474: FND_MSG_PUB.ADD;
2475: END IF;
2476:
2477: IF l_unexpLog THEN
2478: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2479: ,'Create_CogsRecognitionEvents ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
2480: END IF;
2481: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Create_CogsRecognitionEvents:'||substrb(SQLERRM,1,250) );
2482:

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

2545: l_msg_data VARCHAR2(8000) := '';
2546: l_stmt_num NUMBER := 0;
2547:
2548: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
2549: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2550: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2553: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 2550: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

2546: l_stmt_num NUMBER := 0;
2547:
2548: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
2549: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2550: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2553: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2554:

Line 2551: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

2547:
2548: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
2549: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2550: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2553: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2554:
2555: l_revenue_om_line_id NUMBER;

Line 2552: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2548: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
2549: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2550: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2553: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2554:
2555: l_revenue_om_line_id NUMBER;
2556: l_parent_cce_id NUMBER;

Line 2553: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2549: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2550: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2553: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2554:
2555: l_revenue_om_line_id NUMBER;
2556: l_parent_cce_id NUMBER;
2557: l_operating_unit_id NUMBER;

Line 2583: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

2579: l_stmt_num := 0;
2580: debug(l_stmt_num);
2581: /*
2582: IF l_proclog THEN
2583: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
2584: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
2585: 'p_api_version = '||p_api_version||','||
2586: 'p_cogs_om_line_id = '||p_cogs_om_line_id||','||
2587: 'p_cogs_acct_id = '||p_cogs_acct_id||','||

Line 2652: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,G_LOG_HEAD||'.'||l_api_name||'.20',TRUE);

2648:
2649: debug(' CST_NO_REVENUE_OM_LINE for p_cogs_om_line_id : '||p_cogs_om_line_id);
2650:
2651: IF l_errorLog THEN
2652: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,G_LOG_HEAD||'.'||l_api_name||'.20',TRUE);
2653: END IF;
2654: raise program_exception;
2655: END IF;
2656:

Line 2795: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

2791:
2792: -- End API Body
2793:
2794: IF l_proclog THEN
2795: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
2796: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
2797: 'x_return_status = '||x_return_status
2798: );
2799: END IF;

Line 2812: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

2808: ROLLBACK TO Insert_OneSoIssue_PVT;
2809: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2810:
2811: IF l_unexpLog THEN
2812: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2813: ,'Insert_OneSoIssue ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
2814: END IF;
2815:
2816: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

2882: l_api_version CONSTANT NUMBER := 1.0;
2883: l_stmt_num NUMBER := 0;
2884:
2885: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2886: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2887: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2888: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2889: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2890: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 2887: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

2883: l_stmt_num NUMBER := 0;
2884:
2885: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2886: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2887: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2888: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2889: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2890: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2891:

Line 2888: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

2884:
2885: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2886: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2887: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2888: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2889: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2890: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2891:
2892: l_parent_event_id NUMBER;

Line 2889: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2885: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2886: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2887: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2888: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2889: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2890: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2891:
2892: l_parent_event_id NUMBER;
2893: l_prior_event_id NUMBER;

Line 2890: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2886: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2887: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2888: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2889: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2890: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2891:
2892: l_parent_event_id NUMBER;
2893: l_prior_event_id NUMBER;
2894: l_cogs_percentage NUMBER;

Line 2923: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

2919: l_stmt_num := 0;
2920: debug(l_stmt_num);
2921: /*
2922: IF l_proclog THEN
2923: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
2924: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
2925: 'p_api_version = '||p_api_version||','||
2926: 'p_rma_om_line_id = '||p_rma_om_line_id||','||
2927: 'p_cogs_om_line_id = '||p_cogs_om_line_id||','||

Line 3332: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);

3328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3329: FND_MSG_PUB.ADD;
3330: END IF;
3331: IF l_errorLog THEN
3332: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);
3333: END IF;
3334: raise program_exception;
3335: END IF;
3336:

Line 3348: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

3344: , p_data => x_msg_data
3345: );
3346:
3347: IF l_proclog THEN
3348: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
3349: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
3350: 'x_return_status = '||x_return_status||','||
3351: 'x_event_id = '||x_event_id||','||
3352: 'x_cogs_percentage = '||x_cogs_percentage

Line 3367: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

3363: ROLLBACK TO Insert_OneRmaReceipt_PVT;
3364: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3365:
3366: IF l_unexpLog THEN
3367: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3368: ,'Insert_OneRmaReceipt '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
3369: END IF;
3370:
3371: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

3440:
3441: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3442:
3443: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3444: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3445: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3446: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3447: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3448: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 3445: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

3441: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3442:
3443: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3444: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3445: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3446: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3447: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3448: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3449:

Line 3446: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

3442:
3443: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3444: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3445: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3446: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3447: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3448: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3449:
3450: BEGIN

Line 3447: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

3443: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3444: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3445: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3446: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3447: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3448: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3449:
3450: BEGIN
3451:

Line 3448: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

3444: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3445: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3446: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3447: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3448: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3449:
3450: BEGIN
3451:
3452: -- Standard start of API savepoint

Line 3458: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

3454:
3455: l_stmt_num := 0;
3456:
3457: IF l_procLog THEN
3458: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
3459: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
3460: 'p_api_version = '||p_api_version||','||
3461: 'p_cogs_om_line_id = '||p_cogs_om_line_id||','||
3462: 'p_pac_cost_type_id = '||p_pac_cost_type_id||','||

Line 3546: fnd_log.string(fnd_log.level_procedure,l_module||'.end',

3542:
3543: x_return_status := l_return_status;
3544:
3545: IF l_proclog THEN
3546: fnd_log.string(fnd_log.level_procedure,l_module||'.end',
3547: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
3548: 'x_return_status = '||x_return_status
3549: );
3550: END IF;

Line 3558: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

3554: ROLLBACK TO Record_SoIssueCost_PVT;
3555: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3556:
3557: IF l_unexpLog THEN
3558: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3559: ,'Record_SoIssueCost '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
3560: END IF;
3561:
3562: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

3649: l_err_code VARCHAR2(240);
3650: l_err_msg VARCHAR2(240);
3651:
3652: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3653: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3654: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3655: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3656: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3657: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 3654: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

3650: l_err_msg VARCHAR2(240);
3651:
3652: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3653: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3654: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3655: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3656: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3657: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3658: program_exception EXCEPTION;

Line 3655: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

3651:
3652: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3653: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3654: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3655: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3656: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3657: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3658: program_exception EXCEPTION;
3659:

Line 3656: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

3652: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3653: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3654: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3655: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3656: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3657: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3658: program_exception EXCEPTION;
3659:
3660: BEGIN

Line 3657: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

3653: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3654: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3655: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3656: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3657: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3658: program_exception EXCEPTION;
3659:
3660: BEGIN
3661:

Line 3668: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

3664:
3665: l_stmt_num := 0;
3666:
3667: IF l_proclog THEN
3668: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
3669: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
3670: 'p_rma_om_line_id = '||p_rma_om_line_id||','||
3671: 'p_cogs_om_line_id = '||p_cogs_om_line_id||','||
3672: 'p_cost_type_id = '||p_cost_type_id||','||

Line 3735: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.10',TRUE);

3731: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3732: FND_MSG_PUB.ADD;
3733: END IF;
3734: IF l_errorLog THEN
3735: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.10',TRUE);
3736: END IF;
3737: raise program_exception;
3738: END IF;
3739:

Line 3765: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Material Cost = '||to_char(l_elemental_cost(1)));

3761: WHERE cogs_om_line_id = p_cogs_om_line_id
3762: AND pac_cost_type_id IS NULL;
3763:
3764: IF l_stmtLog THEN
3765: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Material Cost = '||to_char(l_elemental_cost(1)));
3766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit MOH Cost = '||to_char(l_elemental_cost(2)));
3767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Resource Cost = '||to_char(l_elemental_cost(3)));
3768: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OSP Cost = '||to_char(l_elemental_cost(4)));
3769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OVHD Cost = '||to_char(l_elemental_cost(5)));

Line 3766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit MOH Cost = '||to_char(l_elemental_cost(2)));

3762: AND pac_cost_type_id IS NULL;
3763:
3764: IF l_stmtLog THEN
3765: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Material Cost = '||to_char(l_elemental_cost(1)));
3766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit MOH Cost = '||to_char(l_elemental_cost(2)));
3767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Resource Cost = '||to_char(l_elemental_cost(3)));
3768: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OSP Cost = '||to_char(l_elemental_cost(4)));
3769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OVHD Cost = '||to_char(l_elemental_cost(5)));
3770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Cost = '||to_char(l_unit_cost));

Line 3767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Resource Cost = '||to_char(l_elemental_cost(3)));

3763:
3764: IF l_stmtLog THEN
3765: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Material Cost = '||to_char(l_elemental_cost(1)));
3766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit MOH Cost = '||to_char(l_elemental_cost(2)));
3767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Resource Cost = '||to_char(l_elemental_cost(3)));
3768: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OSP Cost = '||to_char(l_elemental_cost(4)));
3769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OVHD Cost = '||to_char(l_elemental_cost(5)));
3770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Cost = '||to_char(l_unit_cost));
3771: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','p_txn_quantity = '||to_char(p_txn_quantity));

Line 3768: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OSP Cost = '||to_char(l_elemental_cost(4)));

3764: IF l_stmtLog THEN
3765: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Material Cost = '||to_char(l_elemental_cost(1)));
3766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit MOH Cost = '||to_char(l_elemental_cost(2)));
3767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Resource Cost = '||to_char(l_elemental_cost(3)));
3768: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OSP Cost = '||to_char(l_elemental_cost(4)));
3769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OVHD Cost = '||to_char(l_elemental_cost(5)));
3770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Cost = '||to_char(l_unit_cost));
3771: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','p_txn_quantity = '||to_char(p_txn_quantity));
3772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','l_cogs_percentage = '||to_char(l_cogs_percentage));

Line 3769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OVHD Cost = '||to_char(l_elemental_cost(5)));

3765: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Material Cost = '||to_char(l_elemental_cost(1)));
3766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit MOH Cost = '||to_char(l_elemental_cost(2)));
3767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Resource Cost = '||to_char(l_elemental_cost(3)));
3768: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OSP Cost = '||to_char(l_elemental_cost(4)));
3769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OVHD Cost = '||to_char(l_elemental_cost(5)));
3770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Cost = '||to_char(l_unit_cost));
3771: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','p_txn_quantity = '||to_char(p_txn_quantity));
3772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','l_cogs_percentage = '||to_char(l_cogs_percentage));
3773: END IF;

Line 3770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Cost = '||to_char(l_unit_cost));

3766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit MOH Cost = '||to_char(l_elemental_cost(2)));
3767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Resource Cost = '||to_char(l_elemental_cost(3)));
3768: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OSP Cost = '||to_char(l_elemental_cost(4)));
3769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OVHD Cost = '||to_char(l_elemental_cost(5)));
3770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Cost = '||to_char(l_unit_cost));
3771: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','p_txn_quantity = '||to_char(p_txn_quantity));
3772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','l_cogs_percentage = '||to_char(l_cogs_percentage));
3773: END IF;
3774:

Line 3771: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','p_txn_quantity = '||to_char(p_txn_quantity));

3767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Resource Cost = '||to_char(l_elemental_cost(3)));
3768: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OSP Cost = '||to_char(l_elemental_cost(4)));
3769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OVHD Cost = '||to_char(l_elemental_cost(5)));
3770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Cost = '||to_char(l_unit_cost));
3771: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','p_txn_quantity = '||to_char(p_txn_quantity));
3772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','l_cogs_percentage = '||to_char(l_cogs_percentage));
3773: END IF;
3774:
3775: FOR i IN 1..5 LOOP

Line 3772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','l_cogs_percentage = '||to_char(l_cogs_percentage));

3768: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OSP Cost = '||to_char(l_elemental_cost(4)));
3769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit OVHD Cost = '||to_char(l_elemental_cost(5)));
3770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Unit Cost = '||to_char(l_unit_cost));
3771: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','p_txn_quantity = '||to_char(p_txn_quantity));
3772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','l_cogs_percentage = '||to_char(l_cogs_percentage));
3773: END IF;
3774:
3775: FOR i IN 1..5 LOOP
3776: l_stmt_num := 40;

Line 3781: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.40','Cost Element '||to_char(i)||' COGS Credit Amount = '||to_char(l_cogs_credit_amount));

3777: l_cogs_credit_amount := l_elemental_cost(i) * -1 * p_txn_quantity * l_cogs_percentage;
3778: l_dcogs_credit_amount := (l_elemental_cost(i) * -1 * p_txn_quantity) - l_cogs_credit_amount;
3779:
3780: IF l_stmtLog THEN
3781: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.40','Cost Element '||to_char(i)||' COGS Credit Amount = '||to_char(l_cogs_credit_amount));
3782: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.40','Cost Element '||to_char(i)||' Deferred COGS Credit Amount = '||to_char(l_dcogs_credit_amount));
3783: END IF;
3784:
3785: IF (l_cogs_credit_amount <> 0) THEN

Line 3782: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.40','Cost Element '||to_char(i)||' Deferred COGS Credit Amount = '||to_char(l_dcogs_credit_amount));

3778: l_dcogs_credit_amount := (l_elemental_cost(i) * -1 * p_txn_quantity) - l_cogs_credit_amount;
3779:
3780: IF l_stmtLog THEN
3781: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.40','Cost Element '||to_char(i)||' COGS Credit Amount = '||to_char(l_cogs_credit_amount));
3782: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.40','Cost Element '||to_char(i)||' Deferred COGS Credit Amount = '||to_char(l_dcogs_credit_amount));
3783: END IF;
3784:
3785: IF (l_cogs_credit_amount <> 0) THEN
3786: l_stmt_num := 50;

Line 3826: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

3822: , p_encoded => FND_API.g_false
3823: );
3824:
3825: IF l_proclog THEN
3826: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
3827: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
3828: 'x_return_status = '||x_return_status
3829: );
3830: END IF;

Line 3847: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);

3843: FND_MSG_PUB.ADD;
3844: END IF;
3845:
3846: IF l_errorLog THEN
3847: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);
3848: END IF;
3849:
3850: FND_MSG_PUB.count_and_get
3851: ( p_count => x_msg_count,

Line 3861: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||'.'||l_stmt_num

3857: ROLLBACK TO Process_RmaReceipt_PVT;
3858: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3859:
3860: IF l_unexpLog THEN
3861: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||'.'||l_stmt_num
3862: ,'Process_RmaReceipt '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
3863: END IF;
3864:
3865: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

3926: l_api_name CONSTANT VARCHAR2(30) := 'Process_CogsRecognitionTxn';
3927: l_api_message VARCHAR2(1000);
3928: l_stmt_num NUMBER := 0;
3929: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3930: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3931: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3932: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3933: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3934: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 3931: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

3927: l_api_message VARCHAR2(1000);
3928: l_stmt_num NUMBER := 0;
3929: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3930: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3931: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3932: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3933: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3934: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3935:

Line 3932: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

3928: l_stmt_num NUMBER := 0;
3929: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3930: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3931: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3932: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3933: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3934: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3935:
3936: l_new_percentage NUMBER;

Line 3933: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

3929: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3930: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3931: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3932: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3933: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3934: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3935:
3936: l_new_percentage NUMBER;
3937: l_prior_percentage NUMBER;

Line 3934: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

3930: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3931: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3932: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3933: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3934: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3935:
3936: l_new_percentage NUMBER;
3937: l_prior_percentage NUMBER;
3938:

Line 3957: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

3953:
3954: l_stmt_num := 0;
3955:
3956: IF l_proclog THEN
3957: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
3958: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
3959: 'p_cogs_om_line_id = '||p_cogs_om_line_id||','||
3960: 'p_transaction_id = '||p_transaction_id||','||
3961: 'p_txn_quantity = '||p_txn_quantity||','||

Line 4054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

4050: , p_encoded => FND_API.g_false
4051: );
4052:
4053: IF l_proclog THEN
4054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
4055: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
4056: 'x_return_status = '||x_return_status
4057: );
4058: END IF;

Line 4066: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

4062: ROLLBACK TO Process_CogsRecognitionTxn_PVT;
4063: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4064:
4065: IF l_unexpLog THEN
4066: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
4067: ,'Process_CogsRecognitionTxn ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
4068: END IF;
4069:
4070: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

4117:
4118: l_api_name CONSTANT VARCHAR2(30) := 'Cost_BulkCogsRecTxns';
4119: l_api_message VARCHAR2(1000);
4120: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
4121: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4122: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4123: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4124: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4125: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 4122: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

4118: l_api_name CONSTANT VARCHAR2(30) := 'Cost_BulkCogsRecTxns';
4119: l_api_message VARCHAR2(1000);
4120: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
4121: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4122: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4123: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4124: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4125: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4126:

Line 4123: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

4119: l_api_message VARCHAR2(1000);
4120: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
4121: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4122: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4123: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4124: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4125: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4126:
4127: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 4124: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

4120: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
4121: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4122: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4123: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4124: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4125: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4126:
4127: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4128: l_stmt_num NUMBER := 0;

Line 4125: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

4121: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4122: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4123: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4124: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4125: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4126:
4127: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4128: l_stmt_num NUMBER := 0;
4129:

Line 4235: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

4231:
4232: l_stmt_num := 0;
4233:
4234: IF l_procLog THEN
4235: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
4236: 'Entering '||G_PKG_NAME||'.'||l_api_name
4237: );
4238: END IF;
4239:

Line 4515: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

4511:
4512: -- End API Body
4513:
4514: IF l_proclog THEN
4515: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
4516: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
4517: 'x_return_status = '||x_return_status
4518: );
4519: END IF;

Line 4533: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

4529: ROLLBACK TO Cost_BulkCogsRecTxns_PVT;
4530: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4531:
4532: IF l_unexpLog THEN
4533: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
4534: ,'Cost_BulkCogsRecTxns '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
4535: END IF;
4536:
4537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

4590: l_api_version CONSTANT NUMBER := 1.0;
4591: l_stmt_num NUMBER := 0;
4592:
4593: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
4594: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4595: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4596: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4597: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4598: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 4595: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

4591: l_stmt_num NUMBER := 0;
4592:
4593: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
4594: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4595: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4596: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4597: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4598: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4599:

Line 4596: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

4592:
4593: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
4594: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4595: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4596: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4597: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4598: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4599:
4600: l_cogs_om_line_id NUMBER;

Line 4597: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

4593: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
4594: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4595: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4596: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4597: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4598: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4599:
4600: l_cogs_om_line_id NUMBER;
4601:

Line 4598: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

4594: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4595: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4596: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4597: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4598: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4599:
4600: l_cogs_om_line_id NUMBER;
4601:
4602: l_mat_cost NUMBER;

Line 4617: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

4613:
4614: l_stmt_num := 0;
4615:
4616: IF l_proclog THEN
4617: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
4618: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
4619: 'p_api_version = '||p_api_version||','||
4620: 'p_transaction_id = '||p_transaction_id||','||
4621: 'p_layer_id = '||p_layer_id||','||

Line 4670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.10','No COGS Events found for transaction '||to_char(p_transaction_id));

4666: -- assummed that PAC process will be run again for this transaction
4667: -- after the transaction is costed (and hence CCE is created) in
4668: -- the future before the PAC period is closed.
4669: IF l_stmtLog THEN
4670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.10','No COGS Events found for transaction '||to_char(p_transaction_id));
4671: END IF;
4672: END;
4673:
4674: l_stmt_num := 20;

Line 4693: FND_LOG.string(

4689:
4690: l_tot_cost := l_mat_cost + l_moh_cost + l_res_cost + l_osp_cost + l_ovh_cost;
4691:
4692: IF l_stmtLog THEN
4693: FND_LOG.string(
4694: FND_LOG.LEVEL_STATEMENT,
4695: l_module||'.20',
4696: 'MAT:'||l_mat_cost||' MOH:'||l_moh_cost||' RES:'||l_res_cost||
4697: ' OSP:'||l_osp_cost||' OVH:'||l_ovh_cost

Line 4694: FND_LOG.LEVEL_STATEMENT,

4690: l_tot_cost := l_mat_cost + l_moh_cost + l_res_cost + l_osp_cost + l_ovh_cost;
4691:
4692: IF l_stmtLog THEN
4693: FND_LOG.string(
4694: FND_LOG.LEVEL_STATEMENT,
4695: l_module||'.20',
4696: 'MAT:'||l_mat_cost||' MOH:'||l_moh_cost||' RES:'||l_res_cost||
4697: ' OSP:'||l_osp_cost||' OVH:'||l_ovh_cost
4698: );

Line 4760: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

4756:
4757: -- End API Body
4758:
4759: IF l_procLog THEN
4760: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
4761: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
4762: 'x_return_status = '||x_return_status
4763: );
4764: END IF;

Line 4781: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

4777: ROLLBACK TO Insert_PacSoIssue_PVT;
4778: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4779:
4780: IF l_unexpLog THEN
4781: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
4782: ,'Insert_PacSoIssue ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
4783: END IF;
4784:
4785: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

4834: l_stmt_num NUMBER := 0;
4835: process_error EXCEPTION;
4836:
4837: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
4838: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4839: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4840: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4841: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4842: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 4839: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

4835: process_error EXCEPTION;
4836:
4837: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
4838: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4839: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4840: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4841: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4842: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4843:

Line 4840: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

4836:
4837: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
4838: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4839: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4840: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4841: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4842: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4843:
4844: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

Line 4841: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

4837: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
4838: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4839: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4840: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4841: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4842: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4843:
4844: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
4845: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 4842: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

4838: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4839: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4840: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4841: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4842: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4843:
4844: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
4845: l_err_rec CSTPALTY.cst_ae_err_rec_type;
4846:

Line 4859: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

4855:
4856: l_stmt_num := 0;
4857:
4858: IF l_proclog THEN
4859: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
4860: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
4861: 'p_cogs_om_line_id = '||p_cogs_om_line_id
4862: );
4863: END IF;

Line 4894: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.40','Cost Element '||to_char(i)||' COGS Credit Amount = '||to_char(l_ae_line_rec.transaction_value));

4890: -- COGS distribution = elemental cost * quantity * cogs percentage
4891: l_ae_line_rec.transaction_value := abs(l_elemental_cost(i) * p_ae_txn_rec.primary_quantity * p_ae_txn_rec.cogs_percentage);
4892:
4893: IF l_stmtLog THEN
4894: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.40','Cost Element '||to_char(i)||' COGS Credit Amount = '||to_char(l_ae_line_rec.transaction_value));
4895: END IF;
4896:
4897: IF (l_ae_line_rec.transaction_value <> 0) THEN
4898: -- Create COGS distribution

Line 4922: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.40','Cost Element '||to_char(i)||' Deferred COGS Credit Amount = '||to_char(l_ae_line_rec.transaction_value));

4918: -- Deferred COGS distribution = (elemental cost * quantity) - COGS distribution
4919: l_ae_line_rec.transaction_value := abs(l_elemental_cost(i) * p_ae_txn_rec.primary_quantity) - l_ae_line_rec.transaction_value;
4920:
4921: IF l_stmtLog THEN
4922: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.40','Cost Element '||to_char(i)||' Deferred COGS Credit Amount = '||to_char(l_ae_line_rec.transaction_value));
4923: END IF;
4924:
4925: IF (l_ae_line_rec.transaction_value <> 0) THEN
4926: -- Create Deferred COGS distribution

Line 4951: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

4947:
4948: -- End API Body
4949:
4950: IF l_proclog THEN
4951: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
4952: 'Exiting '||G_PKG_NAME||'.'||l_api_name
4953: );
4954: END IF;
4955:

Line 4965: FND_LOG.string(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

4961: x_ae_err_rec.l_err_code := l_err_rec.l_err_code;
4962: x_ae_err_rec.l_err_msg := l_err_rec.l_err_msg;
4963:
4964: IF l_errorLog THEN
4965: FND_LOG.string(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
4966: ,'Process_PacRmaReceipt ('||to_char(l_stmt_num)||') : '||substr(l_err_rec.l_err_msg,1,200));
4967: END IF;
4968:
4969: when others then

Line 4977: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

4973: x_ae_err_rec.l_err_msg := 'CSTPAPBR.Process_PacRmaReceipt()' ||
4974: to_char(l_stmt_num) || substr(SQLERRM,1,180);
4975:
4976: IF l_unexpLog THEN
4977: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
4978: ,'Process_PacRmaReceipt ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,180));
4979: END IF;
4980:
4981: END Process_PacRmaReceipt;

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

5011: l_stmt_num NUMBER := 0;
5012: process_error EXCEPTION;
5013:
5014: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
5015: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
5016: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5017: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5018: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5019: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 5016: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

5012: process_error EXCEPTION;
5013:
5014: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
5015: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
5016: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5017: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5018: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5019: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5020:

Line 5017: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

5013:
5014: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
5015: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
5016: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5017: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5018: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5019: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5020:
5021: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

Line 5018: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

5014: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name||'.';
5015: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
5016: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5017: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5018: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5019: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5020:
5021: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
5022: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 5019: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

5015: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
5016: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5017: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5018: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5019: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5020:
5021: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
5022: l_err_rec CSTPALTY.cst_ae_err_rec_type;
5023: l_dr_flag BOOLEAN;

Line 5041: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

5037:
5038: l_stmt_num := 0;
5039:
5040: IF l_proclog THEN
5041: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
5042: 'Entering '||G_PKG_NAME||'.'||l_api_name
5043: );
5044: END IF;
5045:

Line 5083: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Cost Element '||to_char(i)||' COGS Adjustment Amount = '||to_char(l_ae_line_rec.transaction_value));

5079: FOR i IN 1..5 LOOP
5080: l_ae_line_rec.transaction_value := l_elemental_cost(i) * p_ae_txn_rec.primary_quantity * (l_new_percentage - l_prior_percentage);
5081:
5082: IF l_stmtLog THEN
5083: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.20','Cost Element '||to_char(i)||' COGS Adjustment Amount = '||to_char(l_ae_line_rec.transaction_value));
5084: END IF;
5085:
5086: IF (l_ae_line_rec.transaction_value <> 0) THEN
5087: -- Create COGS distribution (debit if percentage increase, credit otherwise)

Line 5133: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

5129:
5130: -- End API Body
5131:
5132: IF l_proclog THEN
5133: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',
5134: 'Exiting '||G_PKG_NAME||'.'||l_api_name
5135: );
5136: END IF;
5137:

Line 5148: FND_LOG.string(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

5144: x_ae_err_rec.l_err_code := l_err_rec.l_err_code;
5145: x_ae_err_rec.l_err_msg := l_err_rec.l_err_msg;
5146:
5147: IF l_errorLog THEN
5148: FND_LOG.string(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
5149: ,'Process_PacCogsRecTxn ('||to_char(l_stmt_num)||') : '||substr(l_err_rec.l_err_msg,1,200));
5150: END IF;
5151:
5152: when others then

Line 5160: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

5156: x_ae_err_rec.l_err_msg := 'CSTPAPBR.Process_PacCogsRecTxn(' ||
5157: to_char(l_stmt_num)||') -' || substr(SQLERRM,1,180);
5158:
5159: IF l_unexpLog THEN
5160: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
5161: ,'Process_PacCogsRecTxn ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,180));
5162: END IF;
5163:
5164: END Process_PacCogsRecTxn;

Line 5273: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND

5269: l_success boolean;
5270:
5271: l_full_name constant varchar2(2000) := G_PKG_NAME || '.' || l_api_name;
5272: l_module constant varchar2(2000) := 'cst.plsql.' || l_full_name;
5273: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND
5274: fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5275: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5276: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5277: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 5274: fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);

5270:
5271: l_full_name constant varchar2(2000) := G_PKG_NAME || '.' || l_api_name;
5272: l_module constant varchar2(2000) := 'cst.plsql.' || l_full_name;
5273: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND
5274: fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5275: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5276: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5277: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5278: /*Bug 7305146*/

Line 5275: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);

5271: l_full_name constant varchar2(2000) := G_PKG_NAME || '.' || l_api_name;
5272: l_module constant varchar2(2000) := 'cst.plsql.' || l_full_name;
5273: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND
5274: fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5275: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5276: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5277: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5278: /*Bug 7305146*/
5279: l_encoding VARCHAR2(20);

Line 5276: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);

5272: l_module constant varchar2(2000) := 'cst.plsql.' || l_full_name;
5273: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND
5274: fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5275: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5276: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5277: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5278: /*Bug 7305146*/
5279: l_encoding VARCHAR2(20);
5280: l_xml_header VARCHAR2(100);

Line 5277: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);

5273: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND
5274: fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5275: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5276: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5277: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5278: /*Bug 7305146*/
5279: l_encoding VARCHAR2(20);
5280: l_xml_header VARCHAR2(100);
5281:

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

5292: else
5293: l_operating_unit := -1; /* Operating Unit not used in PAC */
5294: end if; /* p_cost_method = 1 */
5295:
5296: -- Write the module name and user parameters to fnd log file
5297:
5298: IF l_pLog THEN
5299: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
5300: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||

Line 5299: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

5295:
5296: -- Write the module name and user parameters to fnd log file
5297:
5298: IF l_pLog THEN
5299: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
5300: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
5301: 'p_cost_method = '||p_cost_method||','||
5302: 'p_ledger_id = '||p_ledger_id||','||
5303: 'l_operating_unit ='||l_operating_unit||','||

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

5435: end loop;
5436:
5437: dbms_xmlgen.closeContext(l_qryCtx);
5438:
5439: -- Write the event log to fnd log file
5440:
5441: if(l_eventLog) then
5442: fnd_log.string(fnd_log.LEVEL_EVENT,
5443: l_module || '.' || l_stmt_num, 'Completed writing to output file');

Line 5442: fnd_log.string(fnd_log.LEVEL_EVENT,

5438:
5439: -- Write the event log to fnd log file
5440:
5441: if(l_eventLog) then
5442: fnd_log.string(fnd_log.LEVEL_EVENT,
5443: l_module || '.' || l_stmt_num, 'Completed writing to output file');
5444: end if;
5445:
5446: -- free temporary memory

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

5448: dbms_lob.freetemporary(l_xml_doc);
5449:
5450: l_success := fnd_concurrent.set_completion_status('NORMAL', 'Request Completed Successfully');
5451:
5452: -- Write the module name to fnd log file
5453:
5454: IF l_pLog THEN
5455: fnd_log.string(fnd_log.level_procedure,l_module||'.end',
5456: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||

Line 5455: fnd_log.string(fnd_log.level_procedure,l_module||'.end',

5451:
5452: -- Write the module name to fnd log file
5453:
5454: IF l_pLog THEN
5455: fnd_log.string(fnd_log.level_procedure,l_module||'.end',
5456: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
5457: 'errcode = '||errcode||','||
5458: 'err_code = '||err_code
5459: );

Line 5487: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then

5483: l_msg_data := substrb(SQLERRM,1,240);
5484: l_success := fnd_concurrent.set_completion_status('ERROR', l_msg_data);
5485:
5486: when others then
5487: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then
5488: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
5489: l_module || '.' || l_stmt_num,
5490: substrb(SQLERRM , 1 , 240));
5491: end if;

Line 5488: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

5484: l_success := fnd_concurrent.set_completion_status('ERROR', l_msg_data);
5485:
5486: when others then
5487: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then
5488: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
5489: l_module || '.' || l_stmt_num,
5490: substrb(SQLERRM , 1 , 240));
5491: end if;
5492:

Line 5589: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);

5585: l_period_name CST_PAC_PERIODS.PERIOD_NAME%TYPE;
5586: l_meaning FND_LOOKUPS.MEANING%TYPE;
5587: l_stmt_num number;
5588:
5589: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5590: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5591: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5592: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5593:

Line 5590: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);

5586: l_meaning FND_LOOKUPS.MEANING%TYPE;
5587: l_stmt_num number;
5588:
5589: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5590: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5591: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5592: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5593:
5594: begin

Line 5591: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);

5587: l_stmt_num number;
5588:
5589: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5590: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5591: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5592: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5593:
5594: begin
5595:

Line 5592: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);

5588:
5589: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5590: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5591: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5592: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5593:
5594: begin
5595:
5596: -- Write the module name to fnd log file

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

5592: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5593:
5594: begin
5595:
5596: -- Write the module name to fnd log file
5597:
5598: IF l_pLog THEN
5599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
5600: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||

Line 5599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

5595:
5596: -- Write the module name to fnd log file
5597:
5598: IF l_pLog THEN
5599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
5600: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
5601: 'p_api_version = '||p_api_version||','||
5602: 'i_cost_method = '||i_cost_method||','||
5603: 'i_operating_unit = '||i_operating_unit||','||

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

5746: ( p_count => x_msg_count,
5747: p_data => x_msg_data
5748: );
5749:
5750: -- Write the module name to fnd log file
5751: IF l_plog THEN
5752: fnd_log.string(fnd_log.level_procedure,l_module||'.end',
5753: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
5754: 'x_return_status = '||x_return_status

Line 5752: fnd_log.string(fnd_log.level_procedure,l_module||'.end',

5748: );
5749:
5750: -- Write the module name to fnd log file
5751: IF l_plog THEN
5752: fnd_log.string(fnd_log.level_procedure,l_module||'.end',
5753: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
5754: 'x_return_status = '||x_return_status
5755: );
5756: END IF;

Line 5775: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then

5771: );
5772:
5773: when others then
5774: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
5775: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then
5776: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
5777: l_module || '.' || l_stmt_num,
5778: substrb(SQLERRM , 1 , 240));
5779: end if;

Line 5776: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

5772:
5773: when others then
5774: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
5775: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then
5776: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
5777: l_module || '.' || l_stmt_num,
5778: substrb(SQLERRM , 1 , 240));
5779: end if;
5780:

Line 5864: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);

5860: l_date_offset number;
5861:
5862: l_full_name constant varchar2(2000) := G_PKG_NAME || '.' || l_api_name;
5863: l_module constant varchar2(2000) := 'cst.plsql.' || l_full_name;
5864: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5865: l_errorLog constant boolean := l_uLog AND (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5866: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5867: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5868:

Line 5865: l_errorLog constant boolean := l_uLog AND (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);

5861:
5862: l_full_name constant varchar2(2000) := G_PKG_NAME || '.' || l_api_name;
5863: l_module constant varchar2(2000) := 'cst.plsql.' || l_full_name;
5864: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5865: l_errorLog constant boolean := l_uLog AND (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5866: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5867: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5868:
5869: begin

Line 5866: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);

5862: l_full_name constant varchar2(2000) := G_PKG_NAME || '.' || l_api_name;
5863: l_module constant varchar2(2000) := 'cst.plsql.' || l_full_name;
5864: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5865: l_errorLog constant boolean := l_uLog AND (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5866: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5867: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5868:
5869: begin
5870:

Line 5867: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);

5863: l_module constant varchar2(2000) := 'cst.plsql.' || l_full_name;
5864: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5865: l_errorLog constant boolean := l_uLog AND (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);
5866: l_eventLog constant boolean := l_errorLog and (fnd_log.LEVEL_EVENT >= G_LOG_LEVEL);
5867: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5868:
5869: begin
5870:
5871: -- Write the module name to fnd log file

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

5867: l_pLog constant boolean := l_eventLog and (fnd_log.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5868:
5869: begin
5870:
5871: -- Write the module name to fnd log file
5872:
5873: IF l_pLog THEN
5874: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
5875: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||

Line 5874: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',

5870:
5871: -- Write the module name to fnd log file
5872:
5873: IF l_pLog THEN
5874: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.begin',
5875: 'Entering '||G_PKG_NAME||'.'||l_api_name||' with '||
5876: 'p_api_version = '||p_api_version||','||
5877: 'i_cost_method = '||i_cost_method||','||
5878: 'i_operating_unit = '||i_operating_unit||','||

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

6410: ( p_count => x_msg_count,
6411: p_data => x_msg_data
6412: );
6413:
6414: -- Write the module name to fnd log file
6415: IF l_pLog THEN
6416: fnd_log.string(fnd_log.level_procedure,l_module||'.end',
6417: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
6418: 'x_return_status = '||x_return_status

Line 6416: fnd_log.string(fnd_log.level_procedure,l_module||'.end',

6412: );
6413:
6414: -- Write the module name to fnd log file
6415: IF l_pLog THEN
6416: fnd_log.string(fnd_log.level_procedure,l_module||'.end',
6417: 'Exiting '||G_PKG_NAME||'.'||l_api_name||' with '||
6418: 'x_return_status = '||x_return_status
6419: );
6420: END IF;

Line 6439: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then

6435: );
6436:
6437: when others then
6438: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
6439: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then
6440: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
6441: l_module || '.' || l_stmt_num,
6442: substrb(SQLERRM , 1 , 240));
6443: end if;

Line 6440: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

6436:
6437: when others then
6438: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
6439: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then
6440: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
6441: l_module || '.' || l_stmt_num,
6442: substrb(SQLERRM , 1 , 240));
6443: end if;
6444:

Line 6461: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)

6457: PROCEDURE debug
6458: ( line IN VARCHAR2,
6459: msg_prefix IN VARCHAR2 DEFAULT 'CST',
6460: msg_module IN VARCHAR2 DEFAULT g_module_name,
6461: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)
6462: IS
6463: l_msg_prefix VARCHAR2(64);
6464: l_msg_level NUMBER;
6465: l_msg_module VARCHAR2(256);

Line 6475: l_msg_level := FND_LOG.LEVEL_EXCEPTION;

6471: l_msg_prefix := msg_prefix;
6472: l_msg_level := msg_level;
6473: l_msg_module := msg_module;
6474: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
6475: l_msg_level := FND_LOG.LEVEL_EXCEPTION;
6476: END IF;
6477: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND G_DEBUG = 'N' THEN
6478: RETURN;
6479: END IF;

Line 6477: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND G_DEBUG = 'N' THEN

6473: l_msg_module := msg_module;
6474: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
6475: l_msg_level := FND_LOG.LEVEL_EXCEPTION;
6476: END IF;
6477: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND G_DEBUG = 'N' THEN
6478: RETURN;
6479: END IF;
6480: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
6481: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));

Line 6480: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

6476: END IF;
6477: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND G_DEBUG = 'N' THEN
6478: RETURN;
6479: END IF;
6480: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
6481: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));
6482: END IF;
6483: EXCEPTION
6484: WHEN OTHERS THEN RAISE;

Line 6481: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));

6477: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND G_DEBUG = 'N' THEN
6478: RETURN;
6479: END IF;
6480: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
6481: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));
6482: END IF;
6483: EXCEPTION
6484: WHEN OTHERS THEN RAISE;
6485: END debug;