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.INV_CONSUMPTION_ADVICE_PROC dependencies on INV_LOG_UTIL

Line 133: INV_LOG_UTIL.trace

129: BEGIN
130:
131: IF (l_debug = 1)
132: THEN
133: INV_LOG_UTIL.trace
134: ( '>> Update po_distrubution_id','INV_CONSUMPTION_ADVICE_PROC'
135: , 9
136: );
137: END IF;

Line 159: INV_LOG_UTIL.trace

155: EXIT WHEN txn_csr_type%NOTFOUND;
156:
157: IF (l_debug = 1)
158: THEN
159: INV_LOG_UTIL.trace
160: ( 'Transaction_id: '||l_transaction_id
161: , 9
162: );
163: INV_LOG_UTIL.trace

Line 163: INV_LOG_UTIL.trace

159: INV_LOG_UTIL.trace
160: ( 'Transaction_id: '||l_transaction_id
161: , 9
162: );
163: INV_LOG_UTIL.trace
164: ( 'Consumption_Release_Id: '||l_consumption_release_id
165: , 9
166: );
167: INV_LOG_UTIL.trace

Line 167: INV_LOG_UTIL.trace

163: INV_LOG_UTIL.trace
164: ( 'Consumption_Release_Id: '||l_consumption_release_id
165: , 9
166: );
167: INV_LOG_UTIL.trace
168: ( 'Consumption_Po_Header_Id: '||l_consumption_po_header_id
169: , 9
170: );
171: END IF;

Line 264: INV_LOG_UTIL.trace

260: END IF; -- po header id
261:
262: IF (l_debug = 1)
263: THEN
264: INV_LOG_UTIL.trace
265: ( 'Updating MTL_CONSUMPTION_TRANSACTIONS with po_distrubution_id '
266: ||l_po_distribution_id
267: , 9
268: );

Line 284: INV_LOG_UTIL.trace

280: CLOSE txn_csr_type;
281: END IF;
282:
283: IF (l_debug = 1) THEN
284: INV_LOG_UTIL.trace
285: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'
286: , 9
287: );
288: END IF;

Line 296: INV_LOG_UTIL.trace

292: CLOSE txn_csr_type;
293: END IF;
294:
295: IF (l_debug = 1) THEN
296: INV_LOG_UTIL.trace
297: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'
298: , 9
299: );
300: END IF;

Line 312: INV_LOG_UTIL.trace

308: CLOSE txn_csr_type;
309:
310: IF (l_debug = 1)
311: THEN
312: INV_LOG_UTIL.trace
313: ( '<< Update po_distrubution_id','INV_CONSUMPTION_ADVICE_PROC'
314: , 9
315: );
316: END IF;

Line 369: INV_LOG_UTIL.trace

365: BEGIN
366:
367: IF (l_debug = 1)
368: THEN
369: INV_LOG_UTIL.trace
370: ( '>> Update Consumption','INV_CONSUMPTION_ADVICE_PROC'
371: , 9
372: );
373: END IF;

Line 404: INV_LOG_UTIL.trace

400: END IF;
401:
402: IF (l_debug = 1)
403: THEN
404: INV_LOG_UTIL.trace
405: ( ' consumption_po_header_id : '||p_consumption_po_header_id,'INV_CONSUMPTION_ADVICE_PROC'
406: , 9
407: );
408: END IF;

Line 412: INV_LOG_UTIL.trace

408: END IF;
409:
410: IF (l_debug = 1)
411: THEN
412: INV_LOG_UTIL.trace
413: ( ' consumption_release_id : '||p_consumption_release_id,'INV_CONSUMPTION_ADVICE_PROC'
414: , 9
415: );
416: END IF;

Line 420: INV_LOG_UTIL.trace

416: END IF;
417:
418: IF (l_debug = 1)
419: THEN
420: INV_LOG_UTIL.trace
421: ( ' consumption_processed_flag : '||p_consumption_processed_flag,'INV_CONSUMPTION_ADVICE_PROC'
422: , 9
423: );
424: END IF;

Line 428: INV_LOG_UTIL.trace

424: END IF;
425:
426: IF (l_debug = 1)
427: THEN
428: INV_LOG_UTIL.trace
429: ( ' error_code : '||p_error_code,'INV_CONSUMPTION_ADVICE_PROC'
430: , 9
431: );
432: END IF;

Line 436: INV_LOG_UTIL.trace

432: END IF;
433:
434: IF (l_debug = 1)
435: THEN
436: INV_LOG_UTIL.trace
437: ( ' charge_account_id : '||p_charge_account_id,'INV_CONSUMPTION_ADVICE_PROC'
438: , 9
439: );
440: END IF;

Line 444: INV_LOG_UTIL.trace

440: END IF;
441:
442: IF (l_debug = 1)
443: THEN
444: INV_LOG_UTIL.trace
445: ( ' variance_account_id : '||p_variance_account_id,'INV_CONSUMPTION_ADVICE_PROC'
446: , 9
447: );
448: END IF;

Line 452: INV_LOG_UTIL.trace

448: END IF;
449:
450: IF (l_debug = 1)
451: THEN
452: INV_LOG_UTIL.trace
453: ( ' transaction_source_id : '||p_transaction_source_id,'INV_CONSUMPTION_ADVICE_PROC'
454: , 9
455: );
456: END IF;

Line 461: INV_LOG_UTIL.trace

457:
458:
459: IF (l_debug = 1)
460: THEN
461: INV_LOG_UTIL.trace
462: ( ' distribution_account_id : '||p_accrual_account_id,'INV_CONSUMPTION_ADVICE_PROC'
463: , 9
464: );
465: END IF;

Line 469: INV_LOG_UTIL.trace

465: END IF;
466:
467: IF (l_debug = 1)
468: THEN
469: INV_LOG_UTIL.trace
470: ( ' transaction_date : '||p_transaction_date,'INV_CONSUMPTION_ADVICE_PROC'
471: , 9
472: );
473: END IF;

Line 597: INV_LOG_UTIL.trace

593: AND consumption_processed_flag IN ('N', 'E');
594:
595: IF (l_debug = 1)
596: THEN
597: INV_LOG_UTIL.trace
598: ( '<< Update Consumption','INV_CONSUMPTION_ADVICE_PROC'
599: , 9
600: );
601: END IF;

Line 631: INV_LOG_UTIL.trace

627: BEGIN
628:
629: IF (l_debug = 1)
630: THEN
631: INV_LOG_UTIL.trace
632: ( '>> Load Combination(p_batch_id):'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
633: , 9
634: );
635: END IF;

Line 763: INV_LOG_UTIL.trace

759: from MTL_CONSUMPTION_TXN_TEMP where batch_id = p_batch_id;
760:
761: IF (l_debug = 1)
762: THEN
763: INV_LOG_UTIL.trace
764: ( 'temp table count: ' || l_count ,'INV_CONSUMPTION_ADVICE_PROC'
765: , 9
766: );
767:

Line 768: INV_LOG_UTIL.trace

764: ( 'temp table count: ' || l_count ,'INV_CONSUMPTION_ADVICE_PROC'
765: , 9
766: );
767:
768: INV_LOG_UTIL.trace
769: ( '<< Load Combination','INV_CONSUMPTION_ADVICE_PROC'
770: , 9
771: );
772: END IF;

Line 777: INV_LOG_UTIL.trace

773: EXCEPTION
774:
775: WHEN OTHERS THEN
776: IF (l_debug = 1) THEN
777: INV_LOG_UTIL.trace
778: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'
779: , 9
780: );
781: END IF;

Line 815: INV_LOG_UTIL.trace

811: BEGIN
812:
813: IF (l_debug = 1)
814: THEN
815: INV_LOG_UTIL.trace
816: ( '>> Load Combination_prf(p_batch_id)'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
817: , 9
818: );
819: END IF;

Line 1167: INV_LOG_UTIL.trace

1163: from MTL_CONSUMPTION_TXN_TEMP where batch_id = p_batch_id;
1164:
1165: IF (l_debug = 1)
1166: THEN
1167: INV_LOG_UTIL.trace
1168: ( 'temp table count: ' || l_count ,'INV_CONSUMPTION_ADVICE_PROC'
1169: , 9
1170: );
1171:

Line 1172: INV_LOG_UTIL.trace

1168: ( 'temp table count: ' || l_count ,'INV_CONSUMPTION_ADVICE_PROC'
1169: , 9
1170: );
1171:
1172: INV_LOG_UTIL.trace
1173: ( '<< Load Combination_prf','INV_CONSUMPTION_ADVICE_PROC'
1174: , 9
1175: );
1176: END IF;

Line 1182: INV_LOG_UTIL.trace

1178: EXCEPTION
1179:
1180: WHEN OTHERS THEN
1181: IF (l_debug = 1) THEN
1182: INV_LOG_UTIL.trace
1183: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'
1184: , 9
1185: );
1186: END IF;

Line 1240: INV_LOG_UTIL.trace

1236: BEGIN
1237:
1238: IF (l_debug = 1)
1239: THEN
1240: INV_LOG_UTIL.trace
1241: ( '>> Validate Blanket','INV_CONSUMPTION_ADVICE_PROC'
1242: , 9
1243: );
1244: END IF;

Line 1299: INV_LOG_UTIL.trace

1295: ,org_id = l_org_id
1296: WHERE transaction_source_id = l_header_id
1297: AND inventory_item_id = l_item_id
1298: AND valid_flag IS NULL;
1299: INV_LOG_UTIL.trace
1300: ( 'VALID line : item - '
1301: ||l_item_id || ', source - '|| l_header_id || ', org - '|| l_org_id,
1302: 'INV_CONSUMPTION_ADVICE_PROC'
1303: , 9

Line 1342: INV_LOG_UTIL.trace

1338: AND org_id = l_org_id
1339: AND transaction_source_id = l_header_id
1340: AND inventory_item_id = l_item_id;
1341: /* bug 5113064 - End */
1342: INV_LOG_UTIL.trace
1343: ( '**** INVALID line : item - '
1344: ||l_item_id || ', source - '|| l_header_id || ', org - '|| l_org_id,
1345: 'INV_CONSUMPTION_ADVICE_PROC'
1346: , 9

Line 1357: INV_LOG_UTIL.trace

1353: CLOSE valid_csr_type;
1354:
1355: IF (l_debug = 1)
1356: THEN
1357: INV_LOG_UTIL.trace
1358: ( '<< Validate Blanket','INV_CONSUMPTION_ADVICE_PROC'
1359: , 9
1360: );
1361: END IF;

Line 1579: INV_LOG_UTIL.trace

1575: BEGIN
1576:
1577: IF (l_debug = 1)
1578: THEN
1579: INV_LOG_UTIL.trace
1580: ( '>> Load Interface Tables','INV_CONSUMPTION_ADVICE_PROC'
1581: , 9
1582: );
1583: END IF;

Line 1626: INV_LOG_UTIL.trace

1622: l_error_msg := 'INV_SUP_CONS_NO_BPO_EXISTS';
1623:
1624: IF (l_debug = 1)
1625: THEN
1626: INV_LOG_UTIL.trace
1627: ( '>> No valid BPO:'||l_blanket_id,'INV_CONSUMPTION_ADVICE_PROC'
1628: , 9
1629: );
1630: END IF;

Line 1877: INV_LOG_UTIL.trace

1873: EXIT WHEN line_csr_type%NOTFOUND;
1874:
1875: IF (l_debug = 1)
1876: THEN
1877: INV_LOG_UTIL.trace
1878: ( '>> Load Interface Tables'||l_asl_id,'INV_CONSUMPTION_ADVICE_PROC'
1879: , 9
1880: );
1881: END IF;

Line 1888: INV_LOG_UTIL.trace

1884: l_curr_asl_index := l_curr_asl_index+1;
1885:
1886: IF (l_debug = 1)
1887: THEN
1888: INV_LOG_UTIL.trace
1889: ( '>> Load Interface Tables:','INV_CONSUMPTION_ADVICE_PROC'
1890: , 9
1891: );
1892: END IF;

Line 1913: INV_LOG_UTIL.trace

1909: , p_organization_id => l_organization_id
1910: );
1911: IF (l_debug = 1)
1912: THEN
1913: INV_LOG_UTIL.trace
1914: ( '>> Load Interface Tables_prf(UOM):'||l_primary_uom,'INV_CONSUMPTION_ADVICE_PROC'
1915: , 9
1916: );
1917: END IF;

Line 1926: INV_LOG_UTIL.trace

1922: IF l_primary_uom <> NVL(l_purchasing_uom,l_primary_uom)
1923: THEN
1924: IF (l_debug = 1)
1925: THEN
1926: INV_LOG_UTIL.trace
1927: ( '>> Load Interface Tables_prf:(UOM differ)','INV_CONSUMPTION_ADVICE_PROC'
1928: , 9
1929: );
1930: INV_LOG_UTIL.trace

Line 1930: INV_LOG_UTIL.trace

1926: INV_LOG_UTIL.trace
1927: ( '>> Load Interface Tables_prf:(UOM differ)','INV_CONSUMPTION_ADVICE_PROC'
1928: , 9
1929: );
1930: INV_LOG_UTIL.trace
1931: ( 'Primary,Purchasing UOM is '||l_primary_uom||' '||l_purchasing_uom,'INV_CONSUMPTION_ADVICE_PROC'
1932: , 9
1933: );
1934: END IF;

Line 1959: INV_LOG_UTIL.trace

1955: , x_vendor_site_code => l_vendor_site
1956: );
1957: IF (l_debug = 1)
1958: THEN
1959: INV_LOG_UTIL.trace
1960: ( '>> UOM conversion '||l_conv_qty,'INV_CONSUMPTION_ADVICE_PROC'
1961: , 9
1962: );
1963: END IF;

Line 1982: INV_LOG_UTIL.trace

1978:
1979:
1980: IF (l_debug = 1)
1981: THEN
1982: INV_LOG_UTIL.trace
1983: ( '>> From UOM '||l_from_uom_code,'INV_CONSUMPTION_ADVICE_PROC'
1984: , 9
1985: );
1986: INV_LOG_UTIL.trace

Line 1986: INV_LOG_UTIL.trace

1982: INV_LOG_UTIL.trace
1983: ( '>> From UOM '||l_from_uom_code,'INV_CONSUMPTION_ADVICE_PROC'
1984: , 9
1985: );
1986: INV_LOG_UTIL.trace
1987: ( '>> To UOM '||l_to_uom_code,'INV_CONSUMPTION_ADVICE_PROC'
1988: , 9
1989: );
1990: END IF;

Line 2001: INV_LOG_UTIL.trace

1997: );
1998:
1999: IF (l_debug = 1)
2000: THEN
2001: INV_LOG_UTIL.trace
2002: ( '>>UOM Rate '||l_uom_rate,'INV_CONSUMPTION_ADVICE_PROC'
2003: , 9
2004: );
2005: INV_LOG_UTIL.trace

Line 2005: INV_LOG_UTIL.trace

2001: INV_LOG_UTIL.trace
2002: ( '>>UOM Rate '||l_uom_rate,'INV_CONSUMPTION_ADVICE_PROC'
2003: , 9
2004: );
2005: INV_LOG_UTIL.trace
2006: ( '>> Qty '||l_conv_qty,'INV_CONSUMPTION_ADVICE_PROC'
2007: , 9
2008: );
2009: END IF;

Line 2024: INV_LOG_UTIL.trace

2020: l_po_price := l_po_price / NVL(l_uom_rate,1);
2021:
2022: IF (l_debug = 1)
2023: THEN
2024: INV_LOG_UTIL.trace
2025: ( '>> Load Interface Tables_prf(Price):'||l_po_price,'INV_CONSUMPTION_ADVICE_PROC'
2026: , 9
2027: );
2028: END IF;

Line 2050: INV_LOG_UTIL.trace

2046: END IF ;
2047:
2048: IF (l_debug = 1)
2049: THEN
2050: INV_LOG_UTIL.trace
2051: ( '>> Outside Loop(Qty):'||l_conv_qty,'INV_CONSUMPTION_ADVICE_PROC'
2052: , 9
2053: );
2054: INV_LOG_UTIL.trace

Line 2054: INV_LOG_UTIL.trace

2050: INV_LOG_UTIL.trace
2051: ( '>> Outside Loop(Qty):'||l_conv_qty,'INV_CONSUMPTION_ADVICE_PROC'
2052: , 9
2053: );
2054: INV_LOG_UTIL.trace
2055: ( '>> Outside Loop(Price):'||l_po_price,'INV_CONSUMPTION_ADVICE_PROC'
2056: , 9
2057: );
2058: INV_LOG_UTIL.trace

Line 2058: INV_LOG_UTIL.trace

2054: INV_LOG_UTIL.trace
2055: ( '>> Outside Loop(Price):'||l_po_price,'INV_CONSUMPTION_ADVICE_PROC'
2056: , 9
2057: );
2058: INV_LOG_UTIL.trace
2059: ( '>> Outside Loop(error):'||l_error_msg,'INV_CONSUMPTION_ADVICE_PROC'
2060: , 9
2061: );
2062: END IF;

Line 2084: INV_LOG_UTIL.trace

2080: THEN
2081: l_po_price := l_po_price - NVL(l_nonrecoverable_tax,0);
2082: IF (l_debug = 1)
2083: THEN
2084: INV_LOG_UTIL.trace
2085: ( '>> PO Price (no conv):'||l_po_price,'INV_CONSUMPTION_ADVICE_PROC'
2086: , 9
2087: );
2088: END IF;

Line 2095: INV_LOG_UTIL.trace

2091: l_func_po_price := l_po_price - NVL(l_nonrecoverable_tax,0);
2092:
2093: IF (l_debug = 1)
2094: THEN
2095: INV_LOG_UTIL.trace
2096: ( '>> PO Price (conv):'||l_po_price||' '||l_nonrecoverable_tax,'INV_CONSUMPTION_ADVICE_PROC'
2097: , 9
2098: );
2099: END IF;

Line 2115: INV_LOG_UTIL.trace

2111: WHERE fc.currency_code = NVL(l_currency_code,l_fin_curr_code);
2112:
2113: IF (l_debug = 1)
2114: THEN
2115: INV_LOG_UTIL.trace
2116: ( '>> PO Price (fnd_curr):'||l_po_price,'INV_CONSUMPTION_ADVICE_PROC'
2117: , 9
2118: );
2119: END IF;

Line 2137: INV_LOG_UTIL.trace

2133: -- Getting the location of the Inventory Organization
2134: l_inv_org_location:= INV_THIRD_PARTY_STOCK_UTIL.get_location(l_organization_id);
2135: IF (l_debug = 1)
2136: THEN
2137: INV_LOG_UTIL.trace
2138: ( '>> Location :'||l_location_id,'INV_CONSUMPTION_ADVICE_PROC'
2139: , 9
2140: );
2141: INV_LOG_UTIL.trace

Line 2141: INV_LOG_UTIL.trace

2137: INV_LOG_UTIL.trace
2138: ( '>> Location :'||l_location_id,'INV_CONSUMPTION_ADVICE_PROC'
2139: , 9
2140: );
2141: INV_LOG_UTIL.trace
2142: ( '>> Blanket /Item :'||l_blanket_id||' '||l_item_id,'INV_CONSUMPTION_ADVICE_PROC'
2143: , 9
2144: );
2145: INV_LOG_UTIL.trace

Line 2145: INV_LOG_UTIL.trace

2141: INV_LOG_UTIL.trace
2142: ( '>> Blanket /Item :'||l_blanket_id||' '||l_item_id,'INV_CONSUMPTION_ADVICE_PROC'
2143: , 9
2144: );
2145: INV_LOG_UTIL.trace
2146: ( '>> Owning org is :'||l_owning_organization_id,'INV_CONSUMPTION_ADVICE_PROC'
2147: , 9
2148: );
2149: END IF;

Line 2327: INV_LOG_UTIL.trace

2323: WHERE vendor_site_id = l_owning_organization_id;
2324:
2325: IF (l_debug = 1)
2326: THEN
2327: INV_LOG_UTIL.trace
2328: ( 'Populated Lines Interface','INV_CONSUMPTION_ADVICE_PROC'
2329: , 9
2330: );
2331: END IF;

Line 2342: INV_LOG_UTIL.trace

2338: FROM DUAL;
2339:
2340: IF (l_debug = 1)
2341: THEN
2342: INV_LOG_UTIL.trace
2343: ( '>> interface_header_id :'|| l_dist_interface_header_id,'INV_CONSUMPTION_ADVICE_PROC'
2344: , 9
2345: );
2346: END IF ;

Line 2437: INV_LOG_UTIL.trace

2433:
2434:
2435: IF (l_debug = 1)
2436: THEN
2437: INV_LOG_UTIL.trace
2438: ( 'Populated Distributions Interface','INV_CONSUMPTION_ADVICE_PROC'
2439: , 9
2440: );
2441: END IF;

Line 2453: INV_LOG_UTIL.trace

2449: THEN
2450:
2451: IF (l_debug = 1)
2452: THEN
2453: INV_LOG_UTIL.trace
2454: ( '>> Create Documents ','INV_CONSUMPTION_ADVICE_PROC'
2455: , 9
2456: );
2457: END IF;

Line 2461: INV_LOG_UTIL.trace

2457: END IF;
2458:
2459: IF (l_debug = 1)
2460: THEN
2461: INV_LOG_UTIL.trace
2462: ( 'Batch Id : '||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
2463: , 9
2464: );
2465: END IF;

Line 2469: INV_LOG_UTIL.trace

2465: END IF;
2466:
2467: IF (l_debug = 1)
2468: THEN
2469: INV_LOG_UTIL.trace
2470: ( 'Document Id : '||l_document_id,'INV_CONSUMPTION_ADVICE_PROC'
2471: , 9
2472: );
2473: END IF;

Line 2477: INV_LOG_UTIL.trace

2473: END IF;
2474:
2475: IF (l_debug = 1)
2476: THEN
2477: INV_LOG_UTIL.trace
2478: ( 'Document Number : '||l_document_number,'INV_CONSUMPTION_ADVICE_PROC'
2479: , 9
2480: );
2481: END IF;

Line 2485: INV_LOG_UTIL.trace

2481: END IF;
2482:
2483: IF (l_debug = 1)
2484: THEN
2485: INV_LOG_UTIL.trace
2486: ( 'Line : '||l_lines,'INV_CONSUMPTION_ADVICE_PROC'
2487: , 9
2488: );
2489: END IF;

Line 2501: INV_LOG_UTIL.trace

2497: );
2498:
2499: IF (l_debug = 1)
2500: THEN
2501: INV_LOG_UTIL.trace
2502: ( 'Error Code : '||l_error_code,'INV_CONSUMPTION_ADVICE_PROC'
2503: , 9
2504: );
2505: END IF;

Line 2509: INV_LOG_UTIL.trace

2505: END IF;
2506:
2507: IF (l_debug = 1)
2508: THEN
2509: INV_LOG_UTIL.trace
2510: ( '<< Create Documents ','INV_CONSUMPTION_ADVICE_PROC'
2511: , 9
2512: );
2513: END IF;

Line 2528: INV_LOG_UTIL.trace

2524: l_asl_id := l_asl_cons_tab(v_counter);
2525:
2526: IF (l_debug = 1)
2527: THEN
2528: INV_LOG_UTIL.trace
2529: ( '>> Update ASL ' ,'INV_CONSUMPTION_ADVICE_PROC'
2530: , 9
2531: );
2532: END IF;

Line 2536: INV_LOG_UTIL.trace

2532: END IF;
2533:
2534: IF (l_debug = 1)
2535: THEN
2536: INV_LOG_UTIL.trace
2537: ( ' ASL_ID : '||l_asl_id,'INV_CONSUMPTION_ADVICE_PROC'
2538: , 9
2539: );
2540: END IF;

Line 2549: INV_LOG_UTIL.trace

2545: END LOOP;
2546:
2547: IF (l_debug = 1)
2548: THEN
2549: INV_LOG_UTIL.trace
2550: ( '<< Update ASL ','INV_CONSUMPTION_ADVICE_PROC'
2551: , 9
2552: );
2553: END IF;

Line 2585: INV_LOG_UTIL.trace

2581: l_api_version := 1.0;
2582:
2583: IF (l_debug = 1)
2584: THEN
2585: INV_LOG_UTIL.trace
2586: ( '>> Archive PO ','INV_CONSUMPTION_ADVICE_PROC'
2587: , 9
2588: );
2589: END IF;

Line 2593: INV_LOG_UTIL.trace

2589: END IF;
2590:
2591: IF (l_debug = 1)
2592: THEN
2593: INV_LOG_UTIL.trace
2594: ( ' api version : '||l_api_version,'INV_CONSUMPTION_ADVICE_PROC'
2595: , 9
2596: );
2597: END IF;

Line 2601: INV_LOG_UTIL.trace

2597: END IF;
2598:
2599: IF (l_debug = 1)
2600: THEN
2601: INV_LOG_UTIL.trace
2602: ( ' document id : '||l_document_id,'INV_CONSUMPTION_ADVICE_PROC'
2603: , 9
2604: );
2605: END IF;

Line 2609: INV_LOG_UTIL.trace

2605: END IF;
2606:
2607: IF (l_debug = 1)
2608: THEN
2609: INV_LOG_UTIL.trace
2610: ( ' document_type : '||l_archive_type,'INV_CONSUMPTION_ADVICE_PROC'
2611: , 9
2612: );
2613: END IF;

Line 2617: INV_LOG_UTIL.trace

2613: END IF;
2614:
2615: IF (l_debug = 1)
2616: THEN
2617: INV_LOG_UTIL.trace
2618: ( ' document subtype : '||l_archive_subtype,'INV_CONSUMPTION_ADVICE_PROC'
2619: , 9
2620: );
2621: END IF;

Line 2634: INV_LOG_UTIL.trace

2630: );
2631:
2632: IF (l_debug = 1)
2633: THEN
2634: INV_LOG_UTIL.trace
2635: ( ' return status : '||l_archive_status,'INV_CONSUMPTION_ADVICE_PROC'
2636: , 9
2637: );
2638: END IF;

Line 2642: INV_LOG_UTIL.trace

2638: END IF;
2639:
2640: IF (l_debug = 1)
2641: THEN
2642: INV_LOG_UTIL.trace
2643: ( ' msg data : '||l_msg_data,'INV_CONSUMPTION_ADVICE_PROC'
2644: , 9
2645: );
2646: END IF;

Line 2650: INV_LOG_UTIL.trace

2646: END IF;
2647:
2648: IF (l_debug = 1)
2649: THEN
2650: INV_LOG_UTIL.trace
2651: ( '<< Archive PO : ','INV_CONSUMPTION_ADVICE_PROC'
2652: , 9
2653: );
2654: END IF;

Line 2689: INV_LOG_UTIL.trace

2685: ,p_vendor_site_id => l_vendor_site_id);
2686:
2687: IF (l_debug = 1)
2688: THEN
2689: INV_LOG_UTIL.trace
2690: ('Release created :'||l_consumption_release_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2691: INV_LOG_UTIL.trace
2692: ('PO created :'||l_consumption_po_header_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2693: INV_LOG_UTIL.trace

Line 2691: INV_LOG_UTIL.trace

2687: IF (l_debug = 1)
2688: THEN
2689: INV_LOG_UTIL.trace
2690: ('Release created :'||l_consumption_release_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2691: INV_LOG_UTIL.trace
2692: ('PO created :'||l_consumption_po_header_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2693: INV_LOG_UTIL.trace
2694: ('Batch :'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2695: INV_LOG_UTIL.trace

Line 2693: INV_LOG_UTIL.trace

2689: INV_LOG_UTIL.trace
2690: ('Release created :'||l_consumption_release_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2691: INV_LOG_UTIL.trace
2692: ('PO created :'||l_consumption_po_header_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2693: INV_LOG_UTIL.trace
2694: ('Batch :'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2695: INV_LOG_UTIL.trace
2696: ('Blanket is :'||l_blanket_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2697: INV_LOG_UTIL.trace

Line 2695: INV_LOG_UTIL.trace

2691: INV_LOG_UTIL.trace
2692: ('PO created :'||l_consumption_po_header_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2693: INV_LOG_UTIL.trace
2694: ('Batch :'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2695: INV_LOG_UTIL.trace
2696: ('Blanket is :'||l_blanket_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2697: INV_LOG_UTIL.trace
2698: ('Site is :'||l_vendor_site_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2699: INV_LOG_UTIL.trace

Line 2697: INV_LOG_UTIL.trace

2693: INV_LOG_UTIL.trace
2694: ('Batch :'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2695: INV_LOG_UTIL.trace
2696: ('Blanket is :'||l_blanket_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2697: INV_LOG_UTIL.trace
2698: ('Site is :'||l_vendor_site_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2699: INV_LOG_UTIL.trace
2700: ('Txn Date is :'||l_transaction_date,'INV_CONSUMPTION_ADVICE_PROC',9);
2701: END IF;

Line 2699: INV_LOG_UTIL.trace

2695: INV_LOG_UTIL.trace
2696: ('Blanket is :'||l_blanket_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2697: INV_LOG_UTIL.trace
2698: ('Site is :'||l_vendor_site_id,'INV_CONSUMPTION_ADVICE_PROC',9);
2699: INV_LOG_UTIL.trace
2700: ('Txn Date is :'||l_transaction_date,'INV_CONSUMPTION_ADVICE_PROC',9);
2701: END IF;
2702:
2703: l_error_msg := NULL;

Line 2714: INV_LOG_UTIL.trace

2710: CLOSE header_csr_type;
2711:
2712: IF (l_debug = 1)
2713: THEN
2714: INV_LOG_UTIL.trace
2715: ( '<< Load Interface Tables','INV_CONSUMPTION_ADVICE_PROC'
2716: , 9
2717: );
2718: END IF;

Line 2735: INV_LOG_UTIL.trace

2731: CLOSE line_csr_type;
2732: END IF;
2733:
2734: IF (l_debug = 1) THEN
2735: INV_LOG_UTIL.trace
2736: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'
2737: , 9
2738: );
2739: END IF;

Line 2788: INV_LOG_UTIL.trace

2784: BEGIN
2785:
2786: IF (l_debug = 1)
2787: THEN
2788: INV_LOG_UTIL.trace
2789: ( '>> Load Summarized Quantity','INV_CONSUMPTION_ADVICE_PROC'
2790: , 9
2791: );
2792: END IF;

Line 2811: INV_LOG_UTIL.trace

2807: END IF;
2808:
2809: IF (l_debug = 1)
2810: THEN
2811: INV_LOG_UTIL.trace
2812: ( 'First is :'||l_txn_first,'INV_CONSUMPTION_ADVICE_PROC'
2813: , 9
2814: );
2815: INV_LOG_UTIL.trace

Line 2815: INV_LOG_UTIL.trace

2811: INV_LOG_UTIL.trace
2812: ( 'First is :'||l_txn_first,'INV_CONSUMPTION_ADVICE_PROC'
2813: , 9
2814: );
2815: INV_LOG_UTIL.trace
2816: ( 'Last is :'||l_txn_ct,'INV_CONSUMPTION_ADVICE_PROC'
2817: , 9
2818: );
2819: END IF;

Line 2824: INV_LOG_UTIL.trace

2820: */
2821:
2822: IF (l_debug = 1)
2823: THEN
2824: INV_LOG_UTIL.trace
2825: ( 'Last is :'||p_txn_source_tab.COUNT,'INV_CONSUMPTION_ADVICE_PROC'
2826: , 9
2827: );
2828: END IF;

Line 2891: INV_LOG_UTIL.trace

2887:
2888: ELSE
2889: IF (l_debug = 1)
2890: THEN
2891: INV_LOG_UTIL.trace
2892: ( '<< Load Summarized Quantity null index','INV_CONSUMPTION_ADVICE_PROC' , 9
2893: );
2894: END IF;
2895: END IF;

Line 2899: INV_LOG_UTIL.trace

2895: END IF;
2896:
2897: IF (l_debug = 1)
2898: THEN
2899: INV_LOG_UTIL.trace
2900: ( '<< Load Summarized Quantity','INV_CONSUMPTION_ADVICE_PROC'
2901: , 9
2902: );
2903: END IF;

Line 2909: INV_LOG_UTIL.trace

2905: EXCEPTION
2906:
2907: WHEN OTHERS THEN
2908: IF (l_debug = 1) THEN
2909: INV_LOG_UTIL.trace
2910: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'
2911: , 9
2912: );
2913: END IF;

Line 2962: INV_LOG_UTIL.trace

2958: BEGIN
2959:
2960: IF (l_debug = 1)
2961: THEN
2962: INV_LOG_UTIL.trace
2963: ( '>> Load Summarized Quantity Prf','INV_CONSUMPTION_ADVICE_PROC'
2964: , 9
2965: );
2966: END IF;

Line 2985: INV_LOG_UTIL.trace

2981: END IF;
2982:
2983: IF (l_debug = 1)
2984: THEN
2985: INV_LOG_UTIL.trace
2986: ( 'First is :'||l_txn_first,'INV_CONSUMPTION_ADVICE_PROC'
2987: , 9
2988: );
2989: INV_LOG_UTIL.trace

Line 2989: INV_LOG_UTIL.trace

2985: INV_LOG_UTIL.trace
2986: ( 'First is :'||l_txn_first,'INV_CONSUMPTION_ADVICE_PROC'
2987: , 9
2988: );
2989: INV_LOG_UTIL.trace
2990: ( 'Last is :'||l_txn_last||' '||l_txn_ct,'INV_CONSUMPTION_ADVICE_PROC'
2991: , 9
2992: );
2993: END IF;

Line 2998: INV_LOG_UTIL.trace

2994: */
2995:
2996: IF (l_debug = 1)
2997: THEN
2998: INV_LOG_UTIL.trace
2999: ( 'Last is :'||p_txn_source_tab.COUNT,'INV_CONSUMPTION_ADVICE_PROC'
3000: , 9
3001: );
3002: END IF;

Line 3107: INV_LOG_UTIL.trace

3103: AND mctt.global_agreement_flag = 'N';
3104: ELSE
3105: IF (l_debug = 1)
3106: THEN
3107: INV_LOG_UTIL.trace
3108: ( '<< Load Summarized Quantity null index','INV_CONSUMPTION_ADVICE_PROC' , 9
3109: );
3110: END IF;
3111: END IF;

Line 3115: INV_LOG_UTIL.trace

3111: END IF;
3112:
3113: IF (l_debug = 1)
3114: THEN
3115: INV_LOG_UTIL.trace
3116: ( '<< Load Summarized Quantity_prf','INV_CONSUMPTION_ADVICE_PROC'
3117: , 9
3118: );
3119: END IF;

Line 3125: INV_LOG_UTIL.trace

3121: EXCEPTION
3122:
3123: WHEN OTHERS THEN
3124: IF (l_debug = 1) THEN
3125: INV_LOG_UTIL.trace
3126: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'
3127: , 9
3128: );
3129: END IF;

Line 3170: INV_LOG_UTIL.trace

3166: BEGIN
3167:
3168: IF (l_debug = 1)
3169: THEN
3170: INV_LOG_UTIL.trace
3171: ( '>> Delete Record','INV_CONSUMPTION_ADVICE_PROC'
3172: , 9
3173: );
3174: END IF;

Line 3217: INV_LOG_UTIL.trace

3213: AND mct.consumption_processed_flag IN ('N', 'E');
3214:
3215: IF (l_debug = 1)
3216: THEN
3217: INV_LOG_UTIL.trace
3218: ( '<< Delete Record','INV_CONSUMPTION_ADVICE_PROC'
3219: , 9
3220: );
3221: END IF;

Line 3227: INV_LOG_UTIL.trace

3223: EXCEPTION
3224:
3225: WHEN OTHERS THEN
3226: IF (l_debug = 1) THEN
3227: INV_LOG_UTIL.trace
3228: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'
3229: , 9
3230: );
3231: END IF;

Line 3251: INV_LOG_UTIL.trace

3247: BEGIN
3248:
3249: IF (l_debug = 1)
3250: THEN
3251: INV_LOG_UTIL.trace
3252: ( '>> Log Initialize','INV_CONSUMPTION_ADVICE_PROC'
3253: , 9
3254: );
3255: END IF;

Line 3270: INV_LOG_UTIL.trace

3266: END IF;
3267:
3268: IF (l_debug = 1)
3269: THEN
3270: INV_LOG_UTIL.trace
3271: ( '<< Log Initialize','INV_CONSUMPTION_ADVICE_PROC'
3272: , 9
3273: );
3274: END IF;

Line 3296: INV_LOG_UTIL.trace

3292: BEGIN
3293:
3294: IF (l_debug = 1)
3295: THEN
3296: INV_LOG_UTIL.trace
3297: ( '>> Log','INV_CONSUMPTION_ADVICE_PROC'
3298: , 9
3299: );
3300: END IF;

Line 3320: INV_LOG_UTIL.trace

3316: END IF;
3317:
3318: IF (l_debug = 1)
3319: THEN
3320: INV_LOG_UTIL.trace
3321: ( '<< Log','INV_CONSUMPTION_ADVICE_PROC'
3322: , 9
3323: );
3324: END IF;

Line 3370: INV_LOG_UTIL.trace

3366: BEGIN
3367:
3368: IF (l_debug = 1)
3369: THEN
3370: INV_LOG_UTIL.trace
3371: ( '>> Generate Log','INV_CONSUMPTION_ADVICE_PROC'
3372: , 9
3373: );
3374: END IF;

Line 3403: INV_LOG_UTIL.trace

3399: );
3400:
3401: IF (l_debug = 1)
3402: THEN
3403: INV_LOG_UTIL.trace
3404: ( '<< Generate Log','INV_CONSUMPTION_ADVICE_PROC'
3405: , 9
3406: );
3407: END IF;

Line 3506: INV_LOG_UTIL.trace

3502: BEGIN
3503:
3504: IF (l_debug = 1)
3505: THEN
3506: INV_LOG_UTIL.trace
3507: ( '>> Consumption Txn Worker(p_batch_id)'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
3508: , 9
3509: );
3510: END IF;

Line 3645: INV_LOG_UTIL.trace

3641: l_loop_count := cons_temp_csr_type%ROWCOUNT - l_bulk_count;
3642:
3643: IF (l_debug = 1)
3644: THEN
3645: INV_LOG_UTIL.trace
3646: ( 'Consumption Txn Worker(l_loop_count)'||l_loop_count,'INV_CONSUMPTION_ADVICE_PROC'
3647: , 9
3648: );
3649: END IF;

Line 3664: INV_LOG_UTIL.trace

3660: l_inventory_item_id := l_item_tab(i);
3661:
3662: IF (l_debug = 1)
3663: THEN
3664: INV_LOG_UTIL.trace
3665: ( 'Consumption Worker(l_current_txn_source_id)'||l_current_txn_source_id,'INV_CONSUMPTION_ADVICE_PROC'
3666: , 9
3667: );
3668: INV_LOG_UTIL.trace

Line 3668: INV_LOG_UTIL.trace

3664: INV_LOG_UTIL.trace
3665: ( 'Consumption Worker(l_current_txn_source_id)'||l_current_txn_source_id,'INV_CONSUMPTION_ADVICE_PROC'
3666: , 9
3667: );
3668: INV_LOG_UTIL.trace
3669: ( 'Cons Worker(l_organization_id)'||l_organization_id,'INV_CONSUMPTION_ADVICE_PROC'
3670: , 9
3671: );
3672: INV_LOG_UTIL.trace

Line 3672: INV_LOG_UTIL.trace

3668: INV_LOG_UTIL.trace
3669: ( 'Cons Worker(l_organization_id)'||l_organization_id,'INV_CONSUMPTION_ADVICE_PROC'
3670: , 9
3671: );
3672: INV_LOG_UTIL.trace
3673: ( 'Cons Worker(l_inventory_item_id)'||l_inventory_item_id,'INV_CONSUMPTION_ADVICE_PROC'
3674: , 9
3675: );
3676: END IF;

Line 3688: INV_LOG_UTIL.trace

3684: AND ROWNUM = 1;
3685:
3686: IF (l_debug = 1)
3687: THEN
3688: INV_LOG_UTIL.trace
3689: ( 'Consumption Txn Worker(l_vendor_id)'||l_vendor_id,'INV_CONSUMPTION_ADVICE_PROC'
3690: , 9
3691: );
3692: END IF;

Line 3710: INV_LOG_UTIL.trace

3706: ,x_purchasing_uom => l_purchasing_uom);
3707:
3708: IF (l_debug = 1)
3709: THEN
3710: INV_LOG_UTIL.trace
3711: ( 'Consumption Txn Worker(l_asl_id)'||l_asl_id,'INV_CONSUMPTION_ADVICE_PROC'
3712: , 9
3713: );
3714: END IF;

Line 3746: INV_LOG_UTIL.trace

3742: ,x_bill_date_elapsed => l_bill_date_elapsed);
3743:
3744: IF (l_debug = 1)
3745: THEN
3746: INV_LOG_UTIL.trace
3747: ( 'Consumption Txn Worker(l_elapsed)'||l_bill_date_elapsed,'INV_CONSUMPTION_ADVICE_PROC'
3748: , 9
3749: );
3750: INV_LOG_UTIL.trace

Line 3750: INV_LOG_UTIL.trace

3746: INV_LOG_UTIL.trace
3747: ( 'Consumption Txn Worker(l_elapsed)'||l_bill_date_elapsed,'INV_CONSUMPTION_ADVICE_PROC'
3748: , 9
3749: );
3750: INV_LOG_UTIL.trace
3751: ( 'Consumption Txn Worker(l_org_tab)'||l_org_tab(i),'INV_CONSUMPTION_ADVICE_PROC'
3752: , 9
3753: );
3754: END IF;

Line 3768: INV_LOG_UTIL.trace

3764:
3765: -- delete the record from the temporary table
3766: IF (l_debug = 1)
3767: THEN
3768: INV_LOG_UTIL.trace
3769: ( 'Consumption Txn Worker:Inside delete record','INV_CONSUMPTION_ADVICE_PROC'
3770: , 9
3771: );
3772: END IF;

Line 3797: INV_LOG_UTIL.trace

3793: l_bulk_count := cons_temp_csr_type%ROWCOUNT;
3794:
3795: IF (l_debug = 1)
3796: THEN
3797: INV_LOG_UTIL.trace
3798: ( 'Consumption Txn Worker(l_bulk_count)'||l_bulk_count,'INV_CONSUMPTION_ADVICE_PROC'
3799: , 9
3800: );
3801: END IF;

Line 3837: INV_LOG_UTIL.trace

3833: END IF;
3834:
3835: IF (l_debug = 1)
3836: THEN
3837: INV_LOG_UTIL.trace
3838: ( '<< Consumption Txn Worker','INV_CONSUMPTION_ADVICE_PROC'
3839: , 9
3840: );
3841: END IF;

Line 3861: INV_LOG_UTIL.trace

3857: BEGIN
3858:
3859: IF (l_debug = 1)
3860: THEN
3861: INV_LOG_UTIL.trace
3862: ( '>> Generate Batch Id','INV_CONSUMPTION_ADVICE_PROC'
3863: , 9
3864: );
3865: END IF;

Line 3877: INV_LOG_UTIL.trace

3873: RETURN l_batch_id;
3874:
3875: IF (l_debug = 1)
3876: THEN
3877: INV_LOG_UTIL.trace
3878: ( '<< Generate Batch Id','INV_CONSUMPTION_ADVICE_PROC'
3879: , 9
3880: );
3881: END IF;

Line 3904: INV_LOG_UTIL.trace

3900: BEGIN
3901:
3902: IF (l_debug = 1)
3903: THEN
3904: INV_LOG_UTIL.trace
3905: ( '>> Has Worker Completed','INV_CONSUMPTION_ADVICE_PROC'
3906: , 9
3907: );
3908: END IF;

Line 3926: INV_LOG_UTIL.trace

3922: RETURN l_result;
3923:
3924: IF (l_debug = 1)
3925: THEN
3926: INV_LOG_UTIL.trace
3927: ( '<< Has Worker Completed','INV_CONSUMPTION_ADVICE_PROC'
3928: , 9
3929: );
3930: END IF;

Line 3954: INV_LOG_UTIL.trace

3950: BEGIN
3951:
3952: IF (l_debug = 1)
3953: THEN
3954: INV_LOG_UTIL.trace
3955: ( '>> Wait For Worker','INV_CONSUMPTION_ADVICE_PROC'
3956: , 9
3957: );
3958: END IF;

Line 3983: INV_LOG_UTIL.trace

3979: END LOOP;
3980:
3981: IF (l_debug = 1)
3982: THEN
3983: INV_LOG_UTIL.trace
3984: ( '<< Wait For Worker','INV_CONSUMPTION_ADVICE_PROC'
3985: , 9
3986: );
3987: END IF;

Line 4008: INV_LOG_UTIL.trace

4004: BEGIN
4005:
4006: IF (l_debug = 1)
4007: THEN
4008: INV_LOG_UTIL.trace
4009: ( '>> Wait For All Workers','INV_CONSUMPTION_ADVICE_PROC'
4010: , 9
4011: );
4012: END IF;

Line 4039: INV_LOG_UTIL.trace

4035: END LOOP;
4036:
4037: IF (l_debug = 1)
4038: THEN
4039: INV_LOG_UTIL.trace
4040: ( '<< Wait For All Workers','INV_CONSUMPTION_ADVICE_PROC'
4041: , 9
4042: );
4043: END IF;

Line 4074: INV_LOG_UTIL.trace

4070: BEGIN
4071:
4072: IF (l_debug = 1)
4073: THEN
4074: INV_LOG_UTIL.trace
4075: ( '>> Submit Worker','INV_CONSUMPTION_ADVICE_PROC'
4076: , 9
4077: );
4078: END IF;

Line 4116: INV_LOG_UTIL.trace

4112: COMMIT;
4113:
4114: IF (l_debug = 1)
4115: THEN
4116: INV_LOG_UTIL.trace
4117: ( '<< Submit Worker','INV_CONSUMPTION_ADVICE_PROC'
4118: , 9
4119: );
4120: END IF;

Line 4205: INV_LOG_UTIL.trace

4201: BEGIN
4202:
4203: IF (l_debug = 1)
4204: THEN
4205: INV_LOG_UTIL.trace
4206: ( '>> Batch Allocation','INV_CONSUMPTION_ADVICE_PROC'
4207: , 9
4208: );
4209: END IF;

Line 4247: INV_LOG_UTIL.trace

4243: END IF;
4244:
4245: IF (l_debug = 1)
4246: THEN
4247: INV_LOG_UTIL.trace
4248: ( '>> Batch Allocation(p_batch_size)'||p_batch_size,'INV_CONSUMPTION_ADVICE_PROC'
4249: , 9
4250: );
4251: INV_LOG_UTIL.trace

Line 4251: INV_LOG_UTIL.trace

4247: INV_LOG_UTIL.trace
4248: ( '>> Batch Allocation(p_batch_size)'||p_batch_size,'INV_CONSUMPTION_ADVICE_PROC'
4249: , 9
4250: );
4251: INV_LOG_UTIL.trace
4252: ( '>> Batch Allocation(l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'
4253: , 9
4254: );
4255: INV_LOG_UTIL.trace

Line 4255: INV_LOG_UTIL.trace

4251: INV_LOG_UTIL.trace
4252: ( '>> Batch Allocation(l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'
4253: , 9
4254: );
4255: INV_LOG_UTIL.trace
4256: ( '>> Batch Allocation(l_max_workers)'||l_max_workers,'INV_CONSUMPTION_ADVICE_PROC'
4257: , 9
4258: );
4259: INV_LOG_UTIL.trace

Line 4259: INV_LOG_UTIL.trace

4255: INV_LOG_UTIL.trace
4256: ( '>> Batch Allocation(l_max_workers)'||l_max_workers,'INV_CONSUMPTION_ADVICE_PROC'
4257: , 9
4258: );
4259: INV_LOG_UTIL.trace
4260: ( '>> Batch Allocation(p_max_workers)'||p_max_workers,'INV_CONSUMPTION_ADVICE_PROC'
4261: , 9
4262: );
4263: END IF;

Line 4316: INV_LOG_UTIL.trace

4312: l_current_cons_index := l_txn_source_tab.FIRST;
4313:
4314: IF (l_debug = 1)
4315: THEN
4316: INV_LOG_UTIL.trace
4317: ( '>> Batch Alloc (l_current_batch_id)'||l_current_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
4318: , 9
4319: );
4320: INV_LOG_UTIL.trace

Line 4320: INV_LOG_UTIL.trace

4316: INV_LOG_UTIL.trace
4317: ( '>> Batch Alloc (l_current_batch_id)'||l_current_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
4318: , 9
4319: );
4320: INV_LOG_UTIL.trace
4321: ( '>> Batch Alloc (l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'
4322: , 9
4323: );
4324: INV_LOG_UTIL.trace

Line 4324: INV_LOG_UTIL.trace

4320: INV_LOG_UTIL.trace
4321: ( '>> Batch Alloc (l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'
4322: , 9
4323: );
4324: INV_LOG_UTIL.trace
4325: ( '>> Batch Alloc (l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'
4326: , 9
4327: );
4328: END IF;

Line 4348: INV_LOG_UTIL.trace

4344: l_group_count := l_group_count + 1;
4345:
4346: IF (l_debug = 1)
4347: THEN
4348: INV_LOG_UTIL.trace
4349: ( '>> Batch Alloc(l_group_count)'||l_group_count,'INV_CONSUMPTION_ADVICE_PROC'
4350: , 9
4351: );
4352: INV_LOG_UTIL.trace

Line 4352: INV_LOG_UTIL.trace

4348: INV_LOG_UTIL.trace
4349: ( '>> Batch Alloc(l_group_count)'||l_group_count,'INV_CONSUMPTION_ADVICE_PROC'
4350: , 9
4351: );
4352: INV_LOG_UTIL.trace
4353: ( '>> Batch Alloc(l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'
4354: , 9
4355: );
4356: END IF;

Line 4366: INV_LOG_UTIL.trace

4362: l_next_cons_index := l_current_cons_index + 1;
4363:
4364: IF (l_debug = 1)
4365: THEN
4366: INV_LOG_UTIL.trace
4367: ( '>> Batch Alloc(l_next_cons_index)'||l_next_cons_index,'INV_CONSUMPTION_ADVICE_PROC'
4368: , 9
4369: );
4370: INV_LOG_UTIL.trace

Line 4370: INV_LOG_UTIL.trace

4366: INV_LOG_UTIL.trace
4367: ( '>> Batch Alloc(l_next_cons_index)'||l_next_cons_index,'INV_CONSUMPTION_ADVICE_PROC'
4368: , 9
4369: );
4370: INV_LOG_UTIL.trace
4371: ( '>> Batch Alloc(l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'
4372: , 9
4373: );
4374: END IF;

Line 4397: INV_LOG_UTIL.trace

4393: l_new_batch := 'N';
4394:
4395: IF (l_debug = 1)
4396: THEN
4397: INV_LOG_UTIL.trace
4398: ( '>> Batch Alloc....group_count>group_size' ,'INV_CONSUMPTION_ADVICE_PROC'
4399: , 9
4400: );
4401: INV_LOG_UTIL.trace

Line 4401: INV_LOG_UTIL.trace

4397: INV_LOG_UTIL.trace
4398: ( '>> Batch Alloc....group_count>group_size' ,'INV_CONSUMPTION_ADVICE_PROC'
4399: , 9
4400: );
4401: INV_LOG_UTIL.trace
4402: ( '>> Batch Alloc (l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'
4403: , 9
4404: );
4405: INV_LOG_UTIL.trace

Line 4405: INV_LOG_UTIL.trace

4401: INV_LOG_UTIL.trace
4402: ( '>> Batch Alloc (l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'
4403: , 9
4404: );
4405: INV_LOG_UTIL.trace
4406: ( '>> Batch Alloc (l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'
4407: , 9
4408: );
4409: INV_LOG_UTIL.trace

Line 4409: INV_LOG_UTIL.trace

4405: INV_LOG_UTIL.trace
4406: ( '>> Batch Alloc (l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'
4407: , 9
4408: );
4409: INV_LOG_UTIL.trace
4410: ( '>> Batch Alloc (l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'
4411: , 9
4412: );
4413: INV_LOG_UTIL.trace

Line 4413: INV_LOG_UTIL.trace

4409: INV_LOG_UTIL.trace
4410: ( '>> Batch Alloc (l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'
4411: , 9
4412: );
4413: INV_LOG_UTIL.trace
4414: ( '>> Batch Alloc (l_batch_ct)'||l_batch_count,'INV_CONSUMPTION_ADVICE_PROC'
4415: , 9
4416: );
4417: INV_LOG_UTIL.trace

Line 4417: INV_LOG_UTIL.trace

4413: INV_LOG_UTIL.trace
4414: ( '>> Batch Alloc (l_batch_ct)'||l_batch_count,'INV_CONSUMPTION_ADVICE_PROC'
4415: , 9
4416: );
4417: INV_LOG_UTIL.trace
4418: ( '>> Batch Alloc....' ,'INV_CONSUMPTION_ADVICE_PROC'
4419: , 9
4420: );
4421: END IF;

Line 4573: INV_LOG_UTIL.trace

4569: -- the size of the group can only be a maximum of the batch size
4570:
4571: IF (l_debug = 1)
4572: THEN
4573: INV_LOG_UTIL.trace
4574: ( 'After submit worker'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'
4575: , 9
4576: );
4577: INV_LOG_UTIL.trace

Line 4577: INV_LOG_UTIL.trace

4573: INV_LOG_UTIL.trace
4574: ( 'After submit worker'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'
4575: , 9
4576: );
4577: INV_LOG_UTIL.trace
4578: ( 'Batch Alloc(l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'
4579: , 9
4580: );
4581: INV_LOG_UTIL.trace

Line 4581: INV_LOG_UTIL.trace

4577: INV_LOG_UTIL.trace
4578: ( 'Batch Alloc(l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'
4579: , 9
4580: );
4581: INV_LOG_UTIL.trace
4582: ( 'Batch Alloc(l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'
4583: , 9
4584: );
4585: END IF;

Line 4593: INV_LOG_UTIL.trace

4589: END IF;
4590:
4591: IF (l_debug = 1)
4592: THEN
4593: INV_LOG_UTIL.trace
4594: ( 'Batch Alloc(l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'
4595: , 9
4596: );
4597: END IF;

Line 4611: INV_LOG_UTIL.trace

4607: l_group_count :=0;
4608:
4609: IF (l_debug = 1)
4610: THEN
4611: INV_LOG_UTIL.trace
4612: ( 'Batch Alloc(l_current_batch_id)'||l_current_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
4613: , 9
4614: );
4615: INV_LOG_UTIL.trace

Line 4615: INV_LOG_UTIL.trace

4611: INV_LOG_UTIL.trace
4612: ( 'Batch Alloc(l_current_batch_id)'||l_current_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
4613: , 9
4614: );
4615: INV_LOG_UTIL.trace
4616: ( 'Batch Alloc(l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'
4617: , 9
4618: );
4619: END IF;

Line 4632: INV_LOG_UTIL.trace

4628: l_batch_count := l_batch_count + 1;
4629:
4630: IF (l_debug = 1)
4631: THEN
4632: INV_LOG_UTIL.trace
4633: ( 'Batch Alloc(l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'
4634: , 9
4635: );
4636: INV_LOG_UTIL.trace

Line 4636: INV_LOG_UTIL.trace

4632: INV_LOG_UTIL.trace
4633: ( 'Batch Alloc(l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'
4634: , 9
4635: );
4636: INV_LOG_UTIL.trace
4637: ( 'Batch Alloc(l_batch_count)'||l_batch_count,'INV_CONSUMPTION_ADVICE_PROC'
4638: , 9
4639: );
4640: END IF;

Line 4652: INV_LOG_UTIL.trace

4648: );
4649:
4650: IF (l_debug = 1)
4651: THEN
4652: INV_LOG_UTIL.trace
4653: ( '<< Batch Allocation','INV_CONSUMPTION_ADVICE_PROC'
4654: , 9
4655: );
4656: END IF;

Line 4663: INV_LOG_UTIL.trace

4659: EXCEPTION
4660:
4661: WHEN OTHERS THEN
4662: IF (l_debug = 1) THEN
4663: INV_LOG_UTIL.trace
4664: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'
4665: , 9
4666: );
4667: END IF;

Line 4731: INV_LOG_UTIL.trace

4727: BEGIN
4728:
4729: IF (l_debug = 1)
4730: THEN
4731: INV_LOG_UTIL.trace
4732: ( '>> Consumption Txn Manager','INV_CONSUMPTION_ADVICE_PROC'
4733: , 9
4734: );
4735: INV_LOG_UTIL.trace

Line 4735: INV_LOG_UTIL.trace

4731: INV_LOG_UTIL.trace
4732: ( '>> Consumption Txn Manager','INV_CONSUMPTION_ADVICE_PROC'
4733: , 9
4734: );
4735: INV_LOG_UTIL.trace
4736: ( '>> p_batch_size: '|| p_batch_size
4737: , 9
4738: );
4739: INV_LOG_UTIL.trace

Line 4739: INV_LOG_UTIL.trace

4735: INV_LOG_UTIL.trace
4736: ( '>> p_batch_size: '|| p_batch_size
4737: , 9
4738: );
4739: INV_LOG_UTIL.trace
4740: ( '>> p_max_workers: '||p_max_workers
4741: , 9
4742: );
4743: INV_LOG_UTIL.trace

Line 4743: INV_LOG_UTIL.trace

4739: INV_LOG_UTIL.trace
4740: ( '>> p_max_workers: '||p_max_workers
4741: , 9
4742: );
4743: INV_LOG_UTIL.trace
4744: ( '>> p_vendor_id: '||p_vendor_id
4745: , 9
4746: );
4747: INV_LOG_UTIL.trace

Line 4747: INV_LOG_UTIL.trace

4743: INV_LOG_UTIL.trace
4744: ( '>> p_vendor_id: '||p_vendor_id
4745: , 9
4746: );
4747: INV_LOG_UTIL.trace
4748: ( '>> p_vendor_site_id: '||p_vendor_site_id
4749: , 9
4750: );
4751: INV_LOG_UTIL.trace

Line 4751: INV_LOG_UTIL.trace

4747: INV_LOG_UTIL.trace
4748: ( '>> p_vendor_site_id: '||p_vendor_site_id
4749: , 9
4750: );
4751: INV_LOG_UTIL.trace
4752: ( '>> p_inventory_item_id: '||p_inventory_item_id
4753: , 9
4754: );
4755: INV_LOG_UTIL.trace

Line 4755: INV_LOG_UTIL.trace

4751: INV_LOG_UTIL.trace
4752: ( '>> p_inventory_item_id: '||p_inventory_item_id
4753: , 9
4754: );
4755: INV_LOG_UTIL.trace
4756: ( '>> p_organization_id: '||p_organization_id
4757: , 9
4758: );
4759: END IF;

Line 4767: INV_LOG_UTIL.trace

4763: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID') ) ;
4764:
4765: IF (l_debug = 1)
4766: THEN
4767: INV_LOG_UTIL.trace
4768: ( '>> g_request_id => '|| g_request_id
4769: , 9
4770: );
4771: END IF;

Line 4821: INV_LOG_UTIL.trace

4817: AND mmt.transaction_source_type_id = 1;
4818:
4819: IF (l_debug = 1)
4820: THEN
4821: INV_LOG_UTIL.trace
4822: ( '<< CA Mgr (l_count):'||l_count,'INV_CONSUMPTION_ADVICE_PROC'
4823: , 9
4824: );
4825: INV_LOG_UTIL.trace

Line 4825: INV_LOG_UTIL.trace

4821: INV_LOG_UTIL.trace
4822: ( '<< CA Mgr (l_count):'||l_count,'INV_CONSUMPTION_ADVICE_PROC'
4823: , 9
4824: );
4825: INV_LOG_UTIL.trace
4826: ( '<< CA Mgr(batch_id):'||l_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
4827: , 9
4828: );
4829: END IF;

Line 5224: INV_LOG_UTIL.trace

5220: l_transaction_source_id := l_txn_source_tab(l_current_cons_index);
5221:
5222: IF (l_debug = 1)
5223: THEN
5224: INV_LOG_UTIL.trace
5225: ( '<< CA Mgr(l_transaction_source_id)'||l_transaction_source_id,'INV_CONSUMPTION_ADVICE_PROC'
5226: , 9
5227: );
5228: END IF;

Line 5247: INV_LOG_UTIL.trace

5243: l_current_cons_index := l_txn_source_tab.NEXT(l_current_cons_index);
5244:
5245: IF (l_debug = 1)
5246: THEN
5247: INV_LOG_UTIL.trace
5248: ( '<< CA Mgr(l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'
5249: , 9
5250: );
5251: END IF;

Line 5261: INV_LOG_UTIL.trace

5257: -- with unprocessed data from MTL_CONSUMPTION_TRANSACTIONS
5258:
5259: IF (l_debug = 1)
5260: THEN
5261: INV_LOG_UTIL.trace
5262: ( 'Before load_comb(batch_id):'||l_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
5263: , 9
5264: );
5265: INV_LOG_UTIL.trace

Line 5265: INV_LOG_UTIL.trace

5261: INV_LOG_UTIL.trace
5262: ( 'Before load_comb(batch_id):'||l_batch_id,'INV_CONSUMPTION_ADVICE_PROC'
5263: , 9
5264: );
5265: INV_LOG_UTIL.trace
5266: ( 'Before load_comb(vendor_id):'||p_vendor_id,'INV_CONSUMPTION_ADVICE_PROC'
5267: , 9
5268: );
5269: INV_LOG_UTIL.trace

Line 5269: INV_LOG_UTIL.trace

5265: INV_LOG_UTIL.trace
5266: ( 'Before load_comb(vendor_id):'||p_vendor_id,'INV_CONSUMPTION_ADVICE_PROC'
5267: , 9
5268: );
5269: INV_LOG_UTIL.trace
5270: ( 'Before load_comb(vendor_site_id):'||p_vendor_site_id,'INV_CONSUMPTION_ADVICE_PROC'
5271: , 9
5272: );
5273: INV_LOG_UTIL.trace

Line 5273: INV_LOG_UTIL.trace

5269: INV_LOG_UTIL.trace
5270: ( 'Before load_comb(vendor_site_id):'||p_vendor_site_id,'INV_CONSUMPTION_ADVICE_PROC'
5271: , 9
5272: );
5273: INV_LOG_UTIL.trace
5274: ( 'Before load_comb(item_id):'||p_inventory_item_id,'INV_CONSUMPTION_ADVICE_PROC'
5275: , 9
5276: );
5277: INV_LOG_UTIL.trace

Line 5277: INV_LOG_UTIL.trace

5273: INV_LOG_UTIL.trace
5274: ( 'Before load_comb(item_id):'||p_inventory_item_id,'INV_CONSUMPTION_ADVICE_PROC'
5275: , 9
5276: );
5277: INV_LOG_UTIL.trace
5278: ( 'Before load_comb(orgn):'||p_organization_id,'INV_CONSUMPTION_ADVICE_PROC'
5279: , 9
5280: );
5281: END IF;

Line 5307: INV_LOG_UTIL.trace

5303: -- process a batch
5304:
5305: IF (l_debug = 1)
5306: THEN
5307: INV_LOG_UTIL.trace
5308: ( 'Calling Batch Allocation(size) '||p_batch_size,'INV_CONSUMPTION_ADVICE_PROC'
5309: , 9
5310: );
5311: INV_LOG_UTIL.trace

Line 5311: INV_LOG_UTIL.trace

5307: INV_LOG_UTIL.trace
5308: ( 'Calling Batch Allocation(size) '||p_batch_size,'INV_CONSUMPTION_ADVICE_PROC'
5309: , 9
5310: );
5311: INV_LOG_UTIL.trace
5312: ( 'Workers '||p_max_workers,'INV_CONSUMPTION_ADVICE_PROC'
5313: , 9
5314: );
5315: END IF;

Line 5323: INV_LOG_UTIL.trace

5319: ,p_max_workers => p_max_workers);
5320:
5321: IF (l_debug = 1)
5322: THEN
5323: INV_LOG_UTIL.trace
5324: ( 'Calling update_po_distrubution_id '
5325: , 9
5326: );
5327: END IF;

Line 5335: INV_LOG_UTIL.trace

5331:
5332:
5333: IF (l_debug = 1)
5334: THEN
5335: INV_LOG_UTIL.trace
5336: ( '<< Consumption Txn Manager','INV_CONSUMPTION_ADVICE_PROC'
5337: , 9
5338: );
5339: END IF;

Line 5345: INV_LOG_UTIL.trace

5341: EXCEPTION
5342:
5343: WHEN OTHERS THEN
5344: IF (l_debug = 1) THEN
5345: INV_LOG_UTIL.trace
5346: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'
5347: , 9
5348: );
5349: END IF;