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.10.12010000.2 2008/11/10 13:43:14 anjha 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:

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:
193:

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:
193:
194: CURSOR c_txn_history_csr (c_transaction_id NUMBER, c_valuation_date DATE) IS

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

400: AND RT.transaction_id = rec_txn.transaction_id;
401:
402: IF l_sLog THEN
403: l_api_message := 'l_destination_type_code : '|| l_destination_type_code;
404: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
405: ,l_api_message);
406: END IF;
407:
408: /*

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

458: END IF; /* IF (l_destination_type_code = ) */
459:
460: IF l_sLog THEN
461: l_api_message := 'l_txn_price : '||l_txn_price;
462: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
463: ,l_api_message);
464: END IF;
465:
466: ELSE

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

472: WHERE TRANSACTION_ID = rec_txn.transaction_id;
473:
474: IF l_sLog THEN
475: l_api_message := 'l_dist_flag : '||l_dist_flag;
476: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
477: ,l_api_message);
478: END IF;
479:
480:

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

500: AND POH.po_header_id = RT.po_header_id;
501:
502: IF l_sLog THEN
503: l_api_message := 'l_txn_price : '||l_txn_price;
504: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
505: ,l_api_message);
506: END IF;
507:
508: ELSE

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

521: and pod.line_location_id = pol.line_location_id;
522:
523: IF l_sLog THEN
524: l_api_message := 'l_tax : '||l_tax;
525: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
526: ,l_api_message);
527: END IF;
528:
529: l_stmt_num := 130;

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

545: AND POH.po_header_id = RT.po_header_id;
546:
547: IF l_sLog THEN
548: l_api_message := 'l_txn_price : '||l_txn_price;
549: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
550: ,l_api_message);
551: END IF;
552:
553: END IF; -- l_dist_flag = 1

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

574: AND RAE.event_type_id IN (1,2,3,4,5,6);
575:
576: IF l_sLog THEN
577: l_api_message := 'l_txn_price : '||l_txn_price;
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: END IF;

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

607:
608: IF l_sLog THEN
609: l_api_message := 'l_total_price : '||l_total_price ||
610: ' l_total_quantity : '||l_total_quantity;
611: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
612: ,l_api_message);
613: END IF;
614:
615: END IF; /* IF rec_txn.transaction_type... */

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

629: and rae.transaction_date <= p_valuation_date)
630: OR p_valuation_date is null);
631: IF l_sLog THEN
632: l_api_message := 'l_rae_price : '||l_rae_price ;
633: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
634: ,l_api_message);
635: END IF;
636:
637: FOR rec_txn in c_txn_history_csr(l_rcv_transaction_id, p_valuation_date) LOOP

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

639: l_api_message := 'Processing Transaction_ID : '||rec_txn.transaction_id||
640: ' Transaction_Type : '||rec_txn.transaction_type||
641: ' Source_Doc_Qty : '||rec_txn.source_doc_quantity||
642: ' Organization_ID : '||rec_txn.organization_id;
643: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
644: ,l_api_message);
645: END IF;
646:
647:

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

658: AND PARENT.transaction_id = RT.parent_transaction_id;
659:
660: IF l_sLog THEN
661: l_api_message := 'l_parent_txn_type : '||l_parent_txn_type;
662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
663: ,l_api_message);
664: END IF;
665:
666: END IF;

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

692:
693: IF l_sLog THEN
694: l_api_message := 'l_total_price : '||l_total_price ||
695: ' l_total_quantity : '||l_total_quantity;
696: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
697: ,l_api_message);
698: END IF;
699:
700: END IF;

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

712: IF l_sLog THEN
713: l_api_message := ' l_total_price : '||l_total_price ||
714: ' l_total_quantity : '||l_total_quantity ||
715: ' x_unit_price : '||x_unit_price;
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:

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

730: p_data => x_msg_data );
731:
732:
733: IF l_pLog THEN
734: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
735: ,'Get_ReceivingUnitPrice >>');
736: END IF;
737:
738:

Line 761: IF fnd_log.level_unexpected >= g_log_level THEN

757: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
758: x_return_status := fnd_api.g_ret_sts_unexp_error ;
759:
760: /*IF l_uLog THEN*/ -- replaced this to work around GSCC false positives File.Sql.45 (bug #4480504)
761: IF fnd_log.level_unexpected >= g_log_level THEN
762: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
763: ,'Get_ReceivingUnitPrice : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
764: END IF;
765:

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

758: x_return_status := fnd_api.g_ret_sts_unexp_error ;
759:
760: /*IF l_uLog THEN*/ -- replaced this to work around GSCC false positives File.Sql.45 (bug #4480504)
761: IF fnd_log.level_unexpected >= g_log_level THEN
762: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
763: ,'Get_ReceivingUnitPrice : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
764: END IF;
765:
766: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)