eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ACCRUALUTILITIES_GRP dependencies on FND_LOG

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

2: /* $Header: RCVGUTLB.pls 120.12.12020000.5 2012/12/21 10:43:10 yuyun ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_AccrualUtilities_GRP';
5: --G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'po.plsql.'||G_PKG_NAME;
8: G_MSG_LEVEL_THRESHOLD CONSTANT VARCHAR2(1):= FND_PROFILE.Value('FND_API_MSG_LEVEL_THRESHOLD');
9:
10: -----------------------------------------------------------------------------

Line 186: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= g_log_level AND

182:
183: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
184: l_module constant varchar2(60) := 'po.plsql.'||l_full_name;
185:
186: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= g_log_level AND
187: fnd_log.TEST(fnd_log.level_unexpected, l_module);
188: l_errorLog constant boolean := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
189: l_pLog constant boolean := l_errorLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
190: l_sLog constant boolean := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 187: fnd_log.TEST(fnd_log.level_unexpected, l_module);

183: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
184: l_module constant varchar2(60) := 'po.plsql.'||l_full_name;
185:
186: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= g_log_level AND
187: fnd_log.TEST(fnd_log.level_unexpected, l_module);
188: l_errorLog constant boolean := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
189: l_pLog constant boolean := l_errorLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
190: l_sLog constant boolean := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
191: l_rae_price NUMBER;

Line 188: l_errorLog constant boolean := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

184: l_module constant varchar2(60) := 'po.plsql.'||l_full_name;
185:
186: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= g_log_level AND
187: fnd_log.TEST(fnd_log.level_unexpected, l_module);
188: l_errorLog constant boolean := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
189: l_pLog constant boolean := l_errorLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
190: l_sLog constant boolean := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
191: l_rae_price NUMBER;
192: l_mmt_count NUMBER;

Line 189: l_pLog constant boolean := l_errorLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

185:
186: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= g_log_level AND
187: fnd_log.TEST(fnd_log.level_unexpected, l_module);
188: l_errorLog constant boolean := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
189: l_pLog constant boolean := l_errorLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
190: l_sLog constant boolean := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
191: l_rae_price NUMBER;
192: l_mmt_count NUMBER;
193: l_WT_COUNT NUMBER;

Line 190: l_sLog constant boolean := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

186: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= g_log_level AND
187: fnd_log.TEST(fnd_log.level_unexpected, l_module);
188: l_errorLog constant boolean := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
189: l_pLog constant boolean := l_errorLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
190: l_sLog constant boolean := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
191: l_rae_price NUMBER;
192: l_mmt_count NUMBER;
193: l_WT_COUNT NUMBER;
194: l_wcti_COUNT NUMBER;

Line 219: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'

215:
216: l_stmt_num := 0;
217:
218: IF l_pLog THEN
219: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
220: ,'Get_ReceivingUnitPrice <<');
221: END IF;
222:
223: -- Standard call to check for call compatibility

Line 242: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.begin'

238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239:
240: IF l_sLog THEN
241: l_api_message := 'p_rcv_transaction_id : '||p_rcv_transaction_id;
242: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.begin'
243: ,l_api_message);
244: END IF;
245:
246: l_stmt_num := 10;

Line 261: FND_LOG.message(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||l_stmt_num,FALSE);

257: IF l_source_doc_code <> 'PO' THEN
258: FND_MESSAGE.set_name('PO','INVALID_SOURCE_DOCUMENT');
259: FND_MSG_pub.add;
260: IF l_errorLog THEN
261: FND_LOG.message(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||l_stmt_num,FALSE);
262: END IF;
263: RAISE FND_API.g_exc_error;
264: END IF;
265:

Line 279: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

275: AND POH.po_header_id = l_po_header_id;
276:
277: IF l_sLog THEN
278: l_api_message := 'l_po_org_id : '|| l_po_org_id || '; l_po_sob_id : ' || l_po_sob_id;
279: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
280: ,l_api_message);
281: END IF;
282:
283: /* Get Receiving Operating Unit and Set of Books */

Line 292: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

288: WHERE organization_id = l_rcv_organization_id;
289:
290: IF l_sLog THEN
291: l_api_message := 'l_rcv_org_id : '|| l_rcv_org_id || '; l_rcv_sob_id : ' || l_rcv_sob_id;
292: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
293: ,l_api_message);
294: END IF;
295:
296:

Line 320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.begin'

316: l_rcv_transaction_id := p_rcv_transaction_id;
317:
318: IF l_sLog THEN
319: l_api_message := 'l_rcv_transaction_id : '||l_rcv_transaction_id;
320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.begin'
321: ,l_api_message);
322: END IF;
323:
324: l_total_price := 0;

Line 341: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

337: l_api_message := 'Processing Transaction_ID : '||rec_txn.transaction_id||
338: ' Transaction_Type : '||rec_txn.transaction_type||
339: ' Source_Doc_Qty : '||rec_txn.source_doc_quantity||
340: ' Organization_ID : '||rec_txn.organization_id;
341: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
342: ,l_api_message);
343: END IF;
344:
345:

Line 359: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

355: AND PARENT.transaction_id = RT.parent_transaction_id;
356:
357: IF l_sLog THEN
358: l_api_message := 'l_parent_txn_type : '||l_parent_txn_type;
359: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
360: ,l_api_message);
361: END IF;
362:
363: END IF;

Line 412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

408: AND RT.transaction_id = rec_txn.transaction_id;
409:
410: IF l_sLog THEN
411: l_api_message := 'l_destination_type_code : '|| l_destination_type_code;
412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
413: ,l_api_message);
414: END IF;
415:
416: /*

Line 482: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

478: END IF; /* IF (l_destination_type_code = ) */
479:
480: IF l_sLog THEN
481: l_api_message := 'l_txn_price : '||l_txn_price;
482: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
483: ,l_api_message);
484: END IF;
485:
486: ELSE --l_po_org_id <> l_rcv_org_id

Line 578: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

574: WHERE TRANSACTION_ID = rec_txn.transaction_id;
575:
576: IF l_sLog THEN
577: l_api_message := 'l_dist_flag : '||l_dist_flag;
578: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
579: ,l_api_message);
580: END IF;
581:
582:

Line 606: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

602: AND POH.po_header_id = RT.po_header_id;
603:
604: IF l_sLog THEN
605: l_api_message := 'l_txn_price : '||l_txn_price;
606: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
607: ,l_api_message);
608: END IF;
609:
610: ELSE

Line 627: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

623: and pod.line_location_id = pol.line_location_id;
624:
625: IF l_sLog THEN
626: l_api_message := 'l_tax : '||l_tax;
627: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
628: ,l_api_message);
629: END IF;
630:
631: l_stmt_num := 130;

Line 651: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

647: AND POH.po_header_id = RT.po_header_id;
648:
649: IF l_sLog THEN
650: l_api_message := 'l_txn_price : '||l_txn_price;
651: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
652: ,l_api_message);
653: END IF;
654:
655: END IF; -- l_dist_flag = 1

Line 683: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

679: AND RAE.event_type_id IN (1,2,3,4,5,6);
680:
681: IF l_sLog THEN
682: l_api_message := 'l_txn_price : '||l_txn_price;
683: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
684: ,l_api_message);
685: END IF;
686:
687: END IF;

Line 716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

712:
713: IF l_sLog THEN
714: l_api_message := 'l_total_price : '||l_total_price ||
715: ' l_total_quantity : '||l_total_quantity;
716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
717: ,l_api_message);
718: END IF;
719:
720: END IF; /* IF rec_txn.transaction_type... */

Line 738: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

734: and rae.transaction_date <= p_valuation_date)
735: OR p_valuation_date is null);
736: IF l_sLog THEN
737: l_api_message := 'l_rae_price : '||l_rae_price ;
738: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
739: ,l_api_message);
740: END IF;
741:
742: FOR rec_txn in c_txn_history_csr(l_rcv_transaction_id, p_valuation_date) LOOP

Line 748: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

744: l_api_message := 'Processing Transaction_ID : '||rec_txn.transaction_id||
745: ' Transaction_Type : '||rec_txn.transaction_type||
746: ' Source_Doc_Qty : '||rec_txn.source_doc_quantity||
747: ' Organization_ID : '||rec_txn.organization_id;
748: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
749: ,l_api_message);
750: END IF;
751:
752:

Line 767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

763: AND PARENT.transaction_id = RT.parent_transaction_id;
764:
765: IF l_sLog THEN
766: l_api_message := 'l_parent_txn_type : '||l_parent_txn_type;
767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
768: ,l_api_message);
769: END IF;
770:
771: END IF;

Line 801: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

797:
798: IF l_sLog THEN
799: l_api_message := 'l_total_price : '||l_total_price ||
800: ' l_total_quantity : '||l_total_quantity;
801: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
802: ,l_api_message);
803: END IF;
804:
805: END IF;

Line 821: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

817: IF l_sLog THEN
818: l_api_message := ' l_total_price : '||l_total_price ||
819: ' l_total_quantity : '||l_total_quantity ||
820: ' x_unit_price : '||x_unit_price;
821: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
822: ,l_api_message);
823: END IF;
824:
825:

Line 839: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'

835: p_data => x_msg_data );
836:
837:
838: IF l_pLog THEN
839: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
840: ,'Get_ReceivingUnitPrice >>');
841: END IF;
842:
843:

Line 866: IF fnd_log.level_unexpected >= g_log_level THEN

862: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
863: x_return_status := fnd_api.g_ret_sts_unexp_error ;
864:
865: /*IF l_uLog THEN*/ -- replaced this to work around GSCC false positives File.Sql.45 (bug #4480504)
866: IF fnd_log.level_unexpected >= g_log_level THEN
867: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
868: ,'Get_ReceivingUnitPrice : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
869: END IF;
870:

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

863: x_return_status := fnd_api.g_ret_sts_unexp_error ;
864:
865: /*IF l_uLog THEN*/ -- replaced this to work around GSCC false positives File.Sql.45 (bug #4480504)
866: IF fnd_log.level_unexpected >= g_log_level THEN
867: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
868: ,'Get_ReceivingUnitPrice : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
869: END IF;
870:
871: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)