DBA Data[Home] [Help]

APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on INV_CONSUMPTION_ADVICE_PROC

Line 1: PACKAGE BODY INV_CONSUMPTION_ADVICE_PROC AS

1: PACKAGE BODY INV_CONSUMPTION_ADVICE_PROC AS
2: -- $Header: INVRCADB.pls 120.20.12010000.3 2008/10/16 01:37:20 pdong ship $
3: --+=======================================================================+
4: --| Copyright (c) 2002 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 67: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_CONSUMPTION_ADVICE_PROC';

63: --===================
64: -- GLOBALS
65: --===================
66:
67: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_CONSUMPTION_ADVICE_PROC';
68: g_user_id NUMBER := FND_PROFILE.value('USER_ID');
69: g_resp_id NUMBER := FND_PROFILE.value('RESP_ID');
70: g_appl_id NUMBER;
71: -- Bug 5092489, commented becasue not used

Line 134: ( '>> Update po_distrubution_id','INV_CONSUMPTION_ADVICE_PROC'

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;
138: OPEN txn_csr_type;

Line 285: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'

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;
289:

Line 297: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'

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;
301:

Line 313: ( '<< Update po_distrubution_id','INV_CONSUMPTION_ADVICE_PROC'

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;
317:

Line 370: ( '>> Update Consumption','INV_CONSUMPTION_ADVICE_PROC'

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;
374:

Line 405: ( ' consumption_po_header_id : '||p_consumption_po_header_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
409:

Line 413: ( ' consumption_release_id : '||p_consumption_release_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
417:

Line 421: ( ' consumption_processed_flag : '||p_consumption_processed_flag,'INV_CONSUMPTION_ADVICE_PROC'

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;
425:

Line 429: ( ' error_code : '||p_error_code,'INV_CONSUMPTION_ADVICE_PROC'

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;
433:

Line 437: ( ' charge_account_id : '||p_charge_account_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
441:

Line 445: ( ' variance_account_id : '||p_variance_account_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
449:

Line 453: ( ' transaction_source_id : '||p_transaction_source_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
457:

Line 462: ( ' distribution_account_id : '||p_accrual_account_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
466:

Line 470: ( ' transaction_date : '||p_transaction_date,'INV_CONSUMPTION_ADVICE_PROC'

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;
474:

Line 598: ( '<< Update Consumption','INV_CONSUMPTION_ADVICE_PROC'

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;
602:

Line 632: ( '>> Load Combination(p_batch_id):'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
636:

Line 764: ( 'temp table count: ' || l_count ,'INV_CONSUMPTION_ADVICE_PROC'

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:
768: INV_LOG_UTIL.trace

Line 769: ( '<< Load Combination','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;
773: EXCEPTION

Line 778: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'

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;
782:

Line 816: ( '>> Load Combination_prf(p_batch_id)'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
820:

Line 1168: ( 'temp table count: ' || l_count ,'INV_CONSUMPTION_ADVICE_PROC'

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:
1172: INV_LOG_UTIL.trace

Line 1173: ( '<< Load Combination_prf','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;
1177:

Line 1183: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'

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;
1187:

Line 1241: ( '>> Validate Blanket','INV_CONSUMPTION_ADVICE_PROC'

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;
1245:

Line 1302: 'INV_CONSUMPTION_ADVICE_PROC'

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
1304: );
1305:
1306: ELSE

Line 1345: 'INV_CONSUMPTION_ADVICE_PROC'

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
1347: );
1348:
1349: END IF;

Line 1358: ( '<< Validate Blanket','INV_CONSUMPTION_ADVICE_PROC'

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;
1362:

Line 1580: ( '>> Load Interface Tables','INV_CONSUMPTION_ADVICE_PROC'

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;
1584:

Line 1596: INV_CONSUMPTION_ADVICE_PROC.validate_blanket(p_batch_id);

1592: /* bug 5200436 - End */
1593:
1594: l_curr_asl_index := l_asl_cons_tab.COUNT;
1595:
1596: INV_CONSUMPTION_ADVICE_PROC.validate_blanket(p_batch_id);
1597:
1598: l_document_type_code := 'PO';
1599:
1600: -- Get the header info

Line 1627: ( '>> No valid BPO:'||l_blanket_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
1631:

Line 1632: INV_CONSUMPTION_ADVICE_PROC.update_consumption

1628: , 9
1629: );
1630: END IF;
1631:
1632: INV_CONSUMPTION_ADVICE_PROC.update_consumption
1633: (p_consumption_po_header_id => NULL
1634: ,p_consumption_release_id => NULL
1635: ,p_error_code => l_error_msg
1636: ,p_batch_id => p_batch_id

Line 1878: ( '>> Load Interface Tables'||l_asl_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
1882:

Line 1889: ( '>> Load Interface Tables:','INV_CONSUMPTION_ADVICE_PROC'

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;
1893:

Line 1914: ( '>> Load Interface Tables_prf(UOM):'||l_primary_uom,'INV_CONSUMPTION_ADVICE_PROC'

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;
1918:

Line 1927: ( '>> Load Interface Tables_prf:(UOM differ)','INV_CONSUMPTION_ADVICE_PROC'

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
1931: ( 'Primary,Purchasing UOM is '||l_primary_uom||' '||l_purchasing_uom,'INV_CONSUMPTION_ADVICE_PROC'

Line 1931: ( 'Primary,Purchasing UOM is '||l_primary_uom||' '||l_purchasing_uom,'INV_CONSUMPTION_ADVICE_PROC'

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;
1935:

Line 1960: ( '>> UOM conversion '||l_conv_qty,'INV_CONSUMPTION_ADVICE_PROC'

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;
1964:

Line 1983: ( '>> From UOM '||l_from_uom_code,'INV_CONSUMPTION_ADVICE_PROC'

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
1987: ( '>> To UOM '||l_to_uom_code,'INV_CONSUMPTION_ADVICE_PROC'

Line 1987: ( '>> To UOM '||l_to_uom_code,'INV_CONSUMPTION_ADVICE_PROC'

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;
1991:

Line 2002: ( '>>UOM Rate '||l_uom_rate,'INV_CONSUMPTION_ADVICE_PROC'

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
2006: ( '>> Qty '||l_conv_qty,'INV_CONSUMPTION_ADVICE_PROC'

Line 2006: ( '>> Qty '||l_conv_qty,'INV_CONSUMPTION_ADVICE_PROC'

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;
2010:

Line 2025: ( '>> Load Interface Tables_prf(Price):'||l_po_price,'INV_CONSUMPTION_ADVICE_PROC'

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;
2029: */

Line 2051: ( '>> Outside Loop(Qty):'||l_conv_qty,'INV_CONSUMPTION_ADVICE_PROC'

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
2055: ( '>> Outside Loop(Price):'||l_po_price,'INV_CONSUMPTION_ADVICE_PROC'

Line 2055: ( '>> Outside Loop(Price):'||l_po_price,'INV_CONSUMPTION_ADVICE_PROC'

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
2059: ( '>> Outside Loop(error):'||l_error_msg,'INV_CONSUMPTION_ADVICE_PROC'

Line 2059: ( '>> Outside Loop(error):'||l_error_msg,'INV_CONSUMPTION_ADVICE_PROC'

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;
2063:

Line 2085: ( '>> PO Price (no conv):'||l_po_price,'INV_CONSUMPTION_ADVICE_PROC'

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;
2089: ELSE

Line 2096: ( '>> PO Price (conv):'||l_po_price||' '||l_nonrecoverable_tax,'INV_CONSUMPTION_ADVICE_PROC'

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;
2100:

Line 2116: ( '>> PO Price (fnd_curr):'||l_po_price,'INV_CONSUMPTION_ADVICE_PROC'

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;
2120: END IF;

Line 2138: ( '>> Location :'||l_location_id,'INV_CONSUMPTION_ADVICE_PROC'

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
2142: ( '>> Blanket /Item :'||l_blanket_id||' '||l_item_id,'INV_CONSUMPTION_ADVICE_PROC'

Line 2142: ( '>> Blanket /Item :'||l_blanket_id||' '||l_item_id,'INV_CONSUMPTION_ADVICE_PROC'

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
2146: ( '>> Owning org is :'||l_owning_organization_id,'INV_CONSUMPTION_ADVICE_PROC'

Line 2146: ( '>> Owning org is :'||l_owning_organization_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
2150:

Line 2328: ( 'Populated Lines Interface','INV_CONSUMPTION_ADVICE_PROC'

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;
2332:

Line 2343: ( '>> interface_header_id :'|| l_dist_interface_header_id,'INV_CONSUMPTION_ADVICE_PROC'

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 ;
2347:

Line 2438: ( 'Populated Distributions Interface','INV_CONSUMPTION_ADVICE_PROC'

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;
2442: END LOOP; -- line

Line 2454: ( '>> Create Documents ','INV_CONSUMPTION_ADVICE_PROC'

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;
2458:

Line 2462: ( 'Batch Id : '||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
2466:

Line 2470: ( 'Document Id : '||l_document_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
2474:

Line 2478: ( 'Document Number : '||l_document_number,'INV_CONSUMPTION_ADVICE_PROC'

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;
2482:

Line 2486: ( 'Line : '||l_lines,'INV_CONSUMPTION_ADVICE_PROC'

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;
2490:

Line 2502: ( 'Error Code : '||l_error_code,'INV_CONSUMPTION_ADVICE_PROC'

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;
2506:

Line 2510: ( '<< Create Documents ','INV_CONSUMPTION_ADVICE_PROC'

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;
2514:

Line 2529: ( '>> Update ASL ' ,'INV_CONSUMPTION_ADVICE_PROC'

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;
2533:

Line 2537: ( ' ASL_ID : '||l_asl_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
2541:

Line 2550: ( '<< Update ASL ','INV_CONSUMPTION_ADVICE_PROC'

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;
2554:

Line 2586: ( '>> Archive PO ','INV_CONSUMPTION_ADVICE_PROC'

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;
2590:

Line 2594: ( ' api version : '||l_api_version,'INV_CONSUMPTION_ADVICE_PROC'

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;
2598:

Line 2602: ( ' document id : '||l_document_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
2606:

Line 2610: ( ' document_type : '||l_archive_type,'INV_CONSUMPTION_ADVICE_PROC'

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;
2614:

Line 2618: ( ' document subtype : '||l_archive_subtype,'INV_CONSUMPTION_ADVICE_PROC'

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;
2622:

Line 2635: ( ' return status : '||l_archive_status,'INV_CONSUMPTION_ADVICE_PROC'

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;
2639:

Line 2643: ( ' msg data : '||l_msg_data,'INV_CONSUMPTION_ADVICE_PROC'

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;
2647:

Line 2651: ( '<< Archive PO : ','INV_CONSUMPTION_ADVICE_PROC'

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;
2655:

Line 2672: INV_CONSUMPTION_ADVICE_PROC.Update_Consumption

2668: l_consumption_processed_flag := 'E';
2669: END IF;
2670: END IF;
2671:
2672: INV_CONSUMPTION_ADVICE_PROC.Update_Consumption
2673: (p_consumption_po_header_id => l_consumption_po_header_id
2674: ,p_consumption_release_id => l_consumption_release_id
2675: ,p_error_code => l_error_msg
2676: ,p_batch_id => p_batch_id

Line 2690: ('Release created :'||l_consumption_release_id,'INV_CONSUMPTION_ADVICE_PROC',9);

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
2694: ('Batch :'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC',9);

Line 2692: ('PO created :'||l_consumption_po_header_id,'INV_CONSUMPTION_ADVICE_PROC',9);

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
2696: ('Blanket is :'||l_blanket_id,'INV_CONSUMPTION_ADVICE_PROC',9);

Line 2694: ('Batch :'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC',9);

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
2698: ('Site is :'||l_vendor_site_id,'INV_CONSUMPTION_ADVICE_PROC',9);

Line 2696: ('Blanket is :'||l_blanket_id,'INV_CONSUMPTION_ADVICE_PROC',9);

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
2700: ('Txn Date is :'||l_transaction_date,'INV_CONSUMPTION_ADVICE_PROC',9);

Line 2698: ('Site is :'||l_vendor_site_id,'INV_CONSUMPTION_ADVICE_PROC',9);

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;
2702:

Line 2700: ('Txn Date is :'||l_transaction_date,'INV_CONSUMPTION_ADVICE_PROC',9);

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;
2704: l_consumption_processed_flag := NULL;

Line 2715: ( '<< Load Interface Tables','INV_CONSUMPTION_ADVICE_PROC'

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;
2719:

Line 2736: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'

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;
2740:

Line 2789: ( '>> Load Summarized Quantity','INV_CONSUMPTION_ADVICE_PROC'

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;
2793:

Line 2812: ( 'First is :'||l_txn_first,'INV_CONSUMPTION_ADVICE_PROC'

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
2816: ( 'Last is :'||l_txn_ct,'INV_CONSUMPTION_ADVICE_PROC'

Line 2816: ( 'Last is :'||l_txn_ct,'INV_CONSUMPTION_ADVICE_PROC'

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;
2820: */

Line 2825: ( 'Last is :'||p_txn_source_tab.COUNT,'INV_CONSUMPTION_ADVICE_PROC'

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;
2829:

Line 2892: ( '<< Load Summarized Quantity null index','INV_CONSUMPTION_ADVICE_PROC' , 9

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;
2896:

Line 2900: ( '<< Load Summarized Quantity','INV_CONSUMPTION_ADVICE_PROC'

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;
2904:

Line 2910: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'

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;
2914:

Line 2963: ( '>> Load Summarized Quantity Prf','INV_CONSUMPTION_ADVICE_PROC'

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;
2967:

Line 2986: ( 'First is :'||l_txn_first,'INV_CONSUMPTION_ADVICE_PROC'

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
2990: ( 'Last is :'||l_txn_last||' '||l_txn_ct,'INV_CONSUMPTION_ADVICE_PROC'

Line 2990: ( 'Last is :'||l_txn_last||' '||l_txn_ct,'INV_CONSUMPTION_ADVICE_PROC'

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;
2994: */

Line 2999: ( 'Last is :'||p_txn_source_tab.COUNT,'INV_CONSUMPTION_ADVICE_PROC'

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;
3003:

Line 3108: ( '<< Load Summarized Quantity null index','INV_CONSUMPTION_ADVICE_PROC' , 9

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;
3112:

Line 3116: ( '<< Load Summarized Quantity_prf','INV_CONSUMPTION_ADVICE_PROC'

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;
3120:

Line 3126: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'

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;
3130:

Line 3171: ( '>> Delete Record','INV_CONSUMPTION_ADVICE_PROC'

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;
3175:

Line 3218: ( '<< Delete Record','INV_CONSUMPTION_ADVICE_PROC'

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;
3222:

Line 3228: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'

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;
3232:

Line 3252: ( '>> Log Initialize','INV_CONSUMPTION_ADVICE_PROC'

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;
3256:

Line 3271: ( '<< Log Initialize','INV_CONSUMPTION_ADVICE_PROC'

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;
3275:

Line 3297: ( '>> Log','INV_CONSUMPTION_ADVICE_PROC'

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;
3301:

Line 3321: ( '<< Log','INV_CONSUMPTION_ADVICE_PROC'

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;
3325:

Line 3371: ( '>> Generate Log','INV_CONSUMPTION_ADVICE_PROC'

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;
3375:

Line 3376: INV_CONSUMPTION_ADVICE_PROC.LOG

3372: , 9
3373: );
3374: END IF;
3375:
3376: INV_CONSUMPTION_ADVICE_PROC.LOG
3377: ( INV_CONSUMPTION_ADVICE_PROC.G_LOG_PROCEDURE
3378: , '< Consumption Advice Error'
3379: );
3380:

Line 3377: ( INV_CONSUMPTION_ADVICE_PROC.G_LOG_PROCEDURE

3373: );
3374: END IF;
3375:
3376: INV_CONSUMPTION_ADVICE_PROC.LOG
3377: ( INV_CONSUMPTION_ADVICE_PROC.G_LOG_PROCEDURE
3378: , '< Consumption Advice Error'
3379: );
3380:
3381: OPEN con_ad_err_cur;

Line 3396: INV_CONSUMPTION_ADVICE_PROC.LOG

3392: END LOOP;
3393:
3394: CLOSE con_ad_err_cur;
3395:
3396: INV_CONSUMPTION_ADVICE_PROC.LOG
3397: ( INV_CONSUMPTION_ADVICE_PROC.G_LOG_PROCEDURE
3398: , '> Consumption Advice Error'
3399: );
3400:

Line 3397: ( INV_CONSUMPTION_ADVICE_PROC.G_LOG_PROCEDURE

3393:
3394: CLOSE con_ad_err_cur;
3395:
3396: INV_CONSUMPTION_ADVICE_PROC.LOG
3397: ( INV_CONSUMPTION_ADVICE_PROC.G_LOG_PROCEDURE
3398: , '> Consumption Advice Error'
3399: );
3400:
3401: IF (l_debug = 1)

Line 3404: ( '<< Generate Log','INV_CONSUMPTION_ADVICE_PROC'

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;
3408:

Line 3507: ( '>> Consumption Txn Worker(p_batch_id)'||p_batch_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
3511:

Line 3518: INV_CONSUMPTION_ADVICE_PROC.load_combination_prf

3514: -- with records that belong to the specified batch
3515:
3516: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'
3517: THEN
3518: INV_CONSUMPTION_ADVICE_PROC.load_combination_prf
3519: (p_batch_id => p_batch_id
3520: ,p_vendor_id => NULL
3521: ,p_vendor_site_id => NULL
3522: ,p_inventory_item_id => NULL

Line 3525: INV_CONSUMPTION_ADVICE_PROC.load_combination

3521: ,p_vendor_site_id => NULL
3522: ,p_inventory_item_id => NULL
3523: ,p_organization_id => NULL);
3524: ELSE
3525: INV_CONSUMPTION_ADVICE_PROC.load_combination
3526: (p_batch_id => p_batch_id
3527: ,p_vendor_id => NULL
3528: ,p_vendor_site_id => NULL
3529: ,p_inventory_item_id => NULL

Line 3597: INV_CONSUMPTION_ADVICE_PROC.load_summarized_quantity_prf

3593:
3594: /* BUg 5092489. Following IF block is commented becasue quantity is populated during insert
3595: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'
3596: THEN
3597: INV_CONSUMPTION_ADVICE_PROC.load_summarized_quantity_prf
3598: (p_txn_source_tab => l_txn_source_tab
3599: ,p_inventory_item_tab => l_item_tab
3600: ,p_organization_tab => l_org_tab
3601: ,p_own_org_tab => l_owning_org_tab

Line 3615: INV_CONSUMPTION_ADVICE_PROC.load_summarized_quantity

3611: ,p_date_tab => l_date_tab
3612: ,p_batch_id => l_batch_id
3613: ,p_tax_rec_rate_tab => l_tax_rec_rate_tab); -- Bug 4969421
3614: ELSE
3615: INV_CONSUMPTION_ADVICE_PROC.load_summarized_quantity
3616: (p_txn_source_tab => l_txn_source_tab
3617: ,p_inventory_item_tab => l_item_tab
3618: ,p_organization_tab => l_org_tab
3619: ,p_own_org_tab => l_owning_org_tab

Line 3646: ( 'Consumption Txn Worker(l_loop_count)'||l_loop_count,'INV_CONSUMPTION_ADVICE_PROC'

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;
3650:

Line 3665: ( 'Consumption Worker(l_current_txn_source_id)'||l_current_txn_source_id,'INV_CONSUMPTION_ADVICE_PROC'

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
3669: ( 'Cons Worker(l_organization_id)'||l_organization_id,'INV_CONSUMPTION_ADVICE_PROC'

Line 3669: ( 'Cons Worker(l_organization_id)'||l_organization_id,'INV_CONSUMPTION_ADVICE_PROC'

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
3673: ( 'Cons Worker(l_inventory_item_id)'||l_inventory_item_id,'INV_CONSUMPTION_ADVICE_PROC'

Line 3673: ( 'Cons Worker(l_inventory_item_id)'||l_inventory_item_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
3677:

Line 3689: ( 'Consumption Txn Worker(l_vendor_id)'||l_vendor_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
3693:

Line 3711: ( 'Consumption Txn Worker(l_asl_id)'||l_asl_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
3715:

Line 3747: ( 'Consumption Txn Worker(l_elapsed)'||l_bill_date_elapsed,'INV_CONSUMPTION_ADVICE_PROC'

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
3751: ( 'Consumption Txn Worker(l_org_tab)'||l_org_tab(i),'INV_CONSUMPTION_ADVICE_PROC'

Line 3751: ( 'Consumption Txn Worker(l_org_tab)'||l_org_tab(i),'INV_CONSUMPTION_ADVICE_PROC'

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;
3755:

Line 3769: ( 'Consumption Txn Worker:Inside delete record','INV_CONSUMPTION_ADVICE_PROC'

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;
3773:

Line 3774: INV_CONSUMPTION_ADVICE_PROC.delete_record

3770: , 9
3771: );
3772: END IF;
3773:
3774: INV_CONSUMPTION_ADVICE_PROC.delete_record
3775: (p_txn_source_id => l_txn_source_tab(i)
3776: ,p_inventory_item_id => l_item_tab(i)
3777: ,p_organization_id => l_org_tab(i)
3778: ,p_own_org_id => l_owning_org_tab(i)

Line 3798: ( 'Consumption Txn Worker(l_bulk_count)'||l_bulk_count,'INV_CONSUMPTION_ADVICE_PROC'

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;
3802: EXIT WHEN l_loop_count < 1000;

Line 3814: INV_CONSUMPTION_ADVICE_PROC.load_interface_tables

3810:
3811: /* Bug 4599072 - Start */
3812: /* The Load_Interface_Tables_prf procedure will no longer be used */
3813:
3814: INV_CONSUMPTION_ADVICE_PROC.load_interface_tables
3815: (p_batch_id => l_batch_id
3816: ,x_return_status => l_return_status);
3817: /* Bug 4599072 - Start */
3818: /* bug 5113064 - Start */

Line 3831: INV_CONSUMPTION_ADVICE_PROC.generate_log(l_batch_id);

3827: /* bug 5113064 - Start */
3828:
3829: IF l_return_status <> 'S' THEN
3830:
3831: INV_CONSUMPTION_ADVICE_PROC.generate_log(l_batch_id);
3832:
3833: END IF;
3834:
3835: IF (l_debug = 1)

Line 3838: ( '<< Consumption Txn Worker','INV_CONSUMPTION_ADVICE_PROC'

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;
3842:

Line 3862: ( '>> Generate Batch Id','INV_CONSUMPTION_ADVICE_PROC'

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;
3866:

Line 3878: ( '<< Generate Batch Id','INV_CONSUMPTION_ADVICE_PROC'

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;
3882:

Line 3905: ( '>> Has Worker Completed','INV_CONSUMPTION_ADVICE_PROC'

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;
3909:

Line 3927: ( '<< Has Worker Completed','INV_CONSUMPTION_ADVICE_PROC'

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;
3931:

Line 3955: ( '>> Wait For Worker','INV_CONSUMPTION_ADVICE_PROC'

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;
3959:

Line 3966: IF INV_CONSUMPTION_ADVICE_PROC.has_worker_completed(p_workers(l_Idx))

3962: WHILE (NOT l_done) LOOP
3963:
3964: FOR l_Idx IN 1..p_workers.COUNT LOOP
3965:
3966: IF INV_CONSUMPTION_ADVICE_PROC.has_worker_completed(p_workers(l_Idx))
3967: THEN
3968: l_done := TRUE;
3969: x_worker_idx := l_Idx;
3970: EXIT;

Line 3984: ( '<< Wait For Worker','INV_CONSUMPTION_ADVICE_PROC'

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;
3988:

Line 4009: ( '>> Wait For All Workers','INV_CONSUMPTION_ADVICE_PROC'

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;
4013:

Line 4023: INV_CONSUMPTION_ADVICE_PROC.has_worker_completed(p_workers(l_Idx))

4019:
4020: FOR l_Idx IN 1..p_workers.COUNT LOOP
4021:
4022: IF NOT
4023: INV_CONSUMPTION_ADVICE_PROC.has_worker_completed(p_workers(l_Idx))
4024: THEN
4025: l_done := FALSE;
4026: EXIT;
4027: END IF;

Line 4040: ( '<< Wait For All Workers','INV_CONSUMPTION_ADVICE_PROC'

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;
4044:

Line 4075: ( '>> Submit Worker','INV_CONSUMPTION_ADVICE_PROC'

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;
4079:

Line 4086: INV_CONSUMPTION_ADVICE_PROC.wait_for_worker

4082: -- number of workers allowed
4083: l_worker_idx := x_workers.COUNT + 1;
4084: ELSE
4085: -- need to wait for a submitted worker to finish
4086: INV_CONSUMPTION_ADVICE_PROC.wait_for_worker
4087: ( p_workers => x_workers
4088: , x_worker_idx => l_worker_idx
4089: );
4090: END IF;

Line 4117: ( '<< Submit Worker','INV_CONSUMPTION_ADVICE_PROC'

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;
4121:

Line 4206: ( '>> Batch Allocation','INV_CONSUMPTION_ADVICE_PROC'

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;
4210:

Line 4248: ( '>> Batch Allocation(p_batch_size)'||p_batch_size,'INV_CONSUMPTION_ADVICE_PROC'

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
4252: ( '>> Batch Allocation(l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'

Line 4252: ( '>> Batch Allocation(l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'

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
4256: ( '>> Batch Allocation(l_max_workers)'||l_max_workers,'INV_CONSUMPTION_ADVICE_PROC'

Line 4256: ( '>> Batch Allocation(l_max_workers)'||l_max_workers,'INV_CONSUMPTION_ADVICE_PROC'

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
4260: ( '>> Batch Allocation(p_max_workers)'||p_max_workers,'INV_CONSUMPTION_ADVICE_PROC'

Line 4260: ( '>> Batch Allocation(p_max_workers)'||p_max_workers,'INV_CONSUMPTION_ADVICE_PROC'

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;
4264:

Line 4317: ( '>> Batch Alloc (l_current_batch_id)'||l_current_batch_id,'INV_CONSUMPTION_ADVICE_PROC'

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
4321: ( '>> Batch Alloc (l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'

Line 4321: ( '>> Batch Alloc (l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'

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
4325: ( '>> Batch Alloc (l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'

Line 4325: ( '>> Batch Alloc (l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'

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;
4329:

Line 4349: ( '>> Batch Alloc(l_group_count)'||l_group_count,'INV_CONSUMPTION_ADVICE_PROC'

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
4353: ( '>> Batch Alloc(l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'

Line 4353: ( '>> Batch Alloc(l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'

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;
4357:

Line 4367: ( '>> Batch Alloc(l_next_cons_index)'||l_next_cons_index,'INV_CONSUMPTION_ADVICE_PROC'

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
4371: ( '>> Batch Alloc(l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'

Line 4371: ( '>> Batch Alloc(l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'

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;
4375:

Line 4398: ( '>> Batch Alloc....group_count>group_size' ,'INV_CONSUMPTION_ADVICE_PROC'

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
4402: ( '>> Batch Alloc (l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'

Line 4402: ( '>> Batch Alloc (l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'

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
4406: ( '>> Batch Alloc (l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'

Line 4406: ( '>> Batch Alloc (l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'

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
4410: ( '>> Batch Alloc (l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'

Line 4410: ( '>> Batch Alloc (l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'

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
4414: ( '>> Batch Alloc (l_batch_ct)'||l_batch_count,'INV_CONSUMPTION_ADVICE_PROC'

Line 4414: ( '>> Batch Alloc (l_batch_ct)'||l_batch_count,'INV_CONSUMPTION_ADVICE_PROC'

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
4418: ( '>> Batch Alloc....' ,'INV_CONSUMPTION_ADVICE_PROC'

Line 4418: ( '>> Batch Alloc....' ,'INV_CONSUMPTION_ADVICE_PROC'

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;
4422:

Line 4565: INV_CONSUMPTION_ADVICE_PROC.submit_worker( l_current_batch_id

4561: AND mct.consumption_processed_flag IN ('N', 'E');
4562:
4563: -- Call concurrent worker
4564:
4565: INV_CONSUMPTION_ADVICE_PROC.submit_worker( l_current_batch_id
4566: , l_max_workers
4567: , l_workers_tbl);
4568:
4569: -- the size of the group can only be a maximum of the batch size

Line 4574: ( 'After submit worker'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'

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
4578: ( 'Batch Alloc(l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'

Line 4578: ( 'Batch Alloc(l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'

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
4582: ( 'Batch Alloc(l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'

Line 4582: ( 'Batch Alloc(l_batch_size)'||l_batch_size,'INV_CONSUMPTION_ADVICE_PROC'

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;
4586:

Line 4594: ( 'Batch Alloc(l_group_size)'||l_group_size,'INV_CONSUMPTION_ADVICE_PROC'

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;
4598:

Line 4612: ( 'Batch Alloc(l_current_batch_id)'||l_current_batch_id,'INV_CONSUMPTION_ADVICE_PROC'

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
4616: ( 'Batch Alloc(l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'

Line 4616: ( 'Batch Alloc(l_remain_batch_count)'||l_remain_batch_count,'INV_CONSUMPTION_ADVICE_PROC'

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;
4620:

Line 4633: ( 'Batch Alloc(l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'

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
4637: ( 'Batch Alloc(l_batch_count)'||l_batch_count,'INV_CONSUMPTION_ADVICE_PROC'

Line 4637: ( 'Batch Alloc(l_batch_count)'||l_batch_count,'INV_CONSUMPTION_ADVICE_PROC'

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;
4641:

Line 4646: INV_CONSUMPTION_ADVICE_PROC.wait_for_all_workers

4642: END LOOP;
4643:
4644: -- Return control when all concurrent programs have completed
4645:
4646: INV_CONSUMPTION_ADVICE_PROC.wait_for_all_workers
4647: ( p_workers => l_workers_tbl
4648: );
4649:
4650: IF (l_debug = 1)

Line 4653: ( '<< Batch Allocation','INV_CONSUMPTION_ADVICE_PROC'

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;
4657:

Line 4664: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'

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;
4668:

Line 4732: ( '>> Consumption Txn Manager','INV_CONSUMPTION_ADVICE_PROC'

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
4736: ( '>> p_batch_size: '|| p_batch_size

Line 4822: ( '<< CA Mgr (l_count):'||l_count,'INV_CONSUMPTION_ADVICE_PROC'

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
4826: ( '<< CA Mgr(batch_id):'||l_batch_id,'INV_CONSUMPTION_ADVICE_PROC'

Line 4826: ( '<< CA Mgr(batch_id):'||l_batch_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
4830:

Line 5225: ( '<< CA Mgr(l_transaction_source_id)'||l_transaction_source_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
5229:

Line 5248: ( '<< CA Mgr(l_current_cons_index)'||l_current_cons_index,'INV_CONSUMPTION_ADVICE_PROC'

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;
5252:

Line 5262: ( 'Before load_comb(batch_id):'||l_batch_id,'INV_CONSUMPTION_ADVICE_PROC'

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
5266: ( 'Before load_comb(vendor_id):'||p_vendor_id,'INV_CONSUMPTION_ADVICE_PROC'

Line 5266: ( 'Before load_comb(vendor_id):'||p_vendor_id,'INV_CONSUMPTION_ADVICE_PROC'

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
5270: ( 'Before load_comb(vendor_site_id):'||p_vendor_site_id,'INV_CONSUMPTION_ADVICE_PROC'

Line 5270: ( 'Before load_comb(vendor_site_id):'||p_vendor_site_id,'INV_CONSUMPTION_ADVICE_PROC'

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
5274: ( 'Before load_comb(item_id):'||p_inventory_item_id,'INV_CONSUMPTION_ADVICE_PROC'

Line 5274: ( 'Before load_comb(item_id):'||p_inventory_item_id,'INV_CONSUMPTION_ADVICE_PROC'

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
5278: ( 'Before load_comb(orgn):'||p_organization_id,'INV_CONSUMPTION_ADVICE_PROC'

Line 5278: ( 'Before load_comb(orgn):'||p_organization_id,'INV_CONSUMPTION_ADVICE_PROC'

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;
5282: */

Line 5285: INV_CONSUMPTION_ADVICE_PROC.load_combination_prf

5281: END IF;
5282: */
5283: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'
5284: THEN
5285: INV_CONSUMPTION_ADVICE_PROC.load_combination_prf
5286: (p_batch_id => l_batch_id
5287: ,p_vendor_id => p_vendor_id
5288: ,p_vendor_site_id => p_vendor_site_id
5289: ,p_inventory_item_id => p_inventory_item_id

Line 5292: INV_CONSUMPTION_ADVICE_PROC.load_combination

5288: ,p_vendor_site_id => p_vendor_site_id
5289: ,p_inventory_item_id => p_inventory_item_id
5290: ,p_organization_id => p_organization_id);
5291: ELSE
5292: INV_CONSUMPTION_ADVICE_PROC.load_combination
5293: (p_batch_id => l_batch_id
5294: ,p_vendor_id => p_vendor_id
5295: ,p_vendor_site_id => p_vendor_site_id
5296: ,p_inventory_item_id => p_inventory_item_id

Line 5308: ( 'Calling Batch Allocation(size) '||p_batch_size,'INV_CONSUMPTION_ADVICE_PROC'

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
5312: ( 'Workers '||p_max_workers,'INV_CONSUMPTION_ADVICE_PROC'

Line 5312: ( 'Workers '||p_max_workers,'INV_CONSUMPTION_ADVICE_PROC'

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;
5316:

Line 5317: INV_CONSUMPTION_ADVICE_PROC.batch_allocation

5313: , 9
5314: );
5315: END IF;
5316:
5317: INV_CONSUMPTION_ADVICE_PROC.batch_allocation
5318: (p_batch_size => p_batch_size
5319: ,p_max_workers => p_max_workers);
5320:
5321: IF (l_debug = 1)

Line 5336: ( '<< Consumption Txn Manager','INV_CONSUMPTION_ADVICE_PROC'

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;
5340:

Line 5346: ( SQLCODE || ' : ' || SQLERRM ,'INV_CONSUMPTION_ADVICE_PROC'

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;
5350:

Line 5357: END INV_CONSUMPTION_ADVICE_PROC;

5353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5354:
5355: END consumption_txn_manager;
5356:
5357: END INV_CONSUMPTION_ADVICE_PROC;