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_THIRD_PARTY_STOCK_PVT dependencies on INV_THIRD_PARTY_STOCK_PVT

Line 1: PACKAGE BODY INV_THIRD_PARTY_STOCK_PVT AS

1: PACKAGE BODY INV_THIRD_PARTY_STOCK_PVT AS
2: -- $Header: INVVTPSB.pls 120.32.12020000.5 2012/10/10 09:00:47 ksaripal ship $
3: --+=======================================================================+
4: --| Copyright (c) 2002 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 48: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_THIRD_PARTY_STOCK_PVT';

44: --===================
45: -- GLOBALS
46: --===================
47:
48: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_THIRD_PARTY_STOCK_PVT';
49: g_user_id NUMBER := FND_PROFILE.value('USER_ID');
50: g_resp_id NUMBER := FND_PROFILE.value('RESP_ID');
51: g_pgm_appl_id NUMBER := FND_PROFILE.value('RESP_APPL_ID');
52:

Line 124: ( '>> Entering Record Consumption','INV_THIRD_PARTY_STOCK_PVT'

120:
121: IF (l_debug = 1)
122: THEN
123: INV_LOG_UTIL.trace
124: ( '>> Entering Record Consumption','INV_THIRD_PARTY_STOCK_PVT'
125: , 9
126: );
127: END IF;
128:

Line 212: ( '<< Exiting Record Consumption','INV_THIRD_PARTY_STOCK_PVT'

208:
209: IF (l_debug = 1)
210: THEN
211: INV_LOG_UTIL.trace
212: ( '<< Exiting Record Consumption','INV_THIRD_PARTY_STOCK_PVT'
213: , 9
214: );
215: END IF;
216:

Line 253: ( '>> Entering Populate Cost Details','INV_THIRD_PARTY_STOCK_PVT'

249:
250: IF (l_debug = 1)
251: THEN
252: INV_LOG_UTIL.trace
253: ( '>> Entering Populate Cost Details','INV_THIRD_PARTY_STOCK_PVT'
254: , 9
255: );
256: END IF;
257:

Line 283: ( '<< Exiting Populate Cost Details','INV_THIRD_PARTY_STOCK_PVT'

279:
280: IF (l_debug = 1)
281: THEN
282: INV_LOG_UTIL.trace
283: ( '<< Exiting Populate Cost Details','INV_THIRD_PARTY_STOCK_PVT'
284: , 9
285: );
286: END IF;
287:

Line 330: ( '>> Entering Get Conversion Rate','INV_THIRD_PARTY_STOCK_PVT'

326:
327: IF (l_debug = 1)
328: THEN
329: INV_LOG_UTIL.trace
330: ( '>> Entering Get Conversion Rate','INV_THIRD_PARTY_STOCK_PVT'
331: , 9
332: );
333: END IF;
334:

Line 364: ( '<< Exiting Get Conversion Rate','INV_THIRD_PARTY_STOCK_PVT'

360:
361: IF (l_debug = 1)
362: THEN
363: INV_LOG_UTIL.trace
364: ( '<< Exiting Get Conversion Rate','INV_THIRD_PARTY_STOCK_PVT'
365: , 9
366: );
367: END IF;
368:

Line 395: ( '>> Entering Reset OU ','INV_THIRD_PARTY_STOCK_PVT'

391:
392: IF (l_debug = 1)
393: THEN
394: INV_LOG_UTIL.trace
395: ( '>> Entering Reset OU ','INV_THIRD_PARTY_STOCK_PVT'
396: , 9
397: );
398: END IF;
399:

Line 405: ( '<< Exiting Reset OU ','INV_THIRD_PARTY_STOCK_PVT'

401:
402: IF (l_debug = 1)
403: THEN
404: INV_LOG_UTIL.trace
405: ( '<< Exiting Reset OU ','INV_THIRD_PARTY_STOCK_PVT'
406: , 9
407: );
408: END IF;
409:

Line 874: ( 'Inserted into Tax Global temp tables','INV_THIRD_PARTY_STOCK_PVT'

870: -- End Rajesh
871: IF (l_debug = 1)
872: THEN
873: INV_LOG_UTIL.trace
874: ( 'Inserted into Tax Global temp tables','INV_THIRD_PARTY_STOCK_PVT'
875: , 9
876: );
877: INV_LOG_UTIL.trace
878: ( 'Calling INV_AP_TAX_ENGINE_MDTR.Calculate_Tax'

Line 894: ( ' returned '||l_return_status,'INV_THIRD_PARTY_STOCK_PVT'

890:
891: IF (l_debug = 1)
892: THEN
893: INV_LOG_UTIL.trace
894: ( ' returned '||l_return_status,'INV_THIRD_PARTY_STOCK_PVT'
895: , 9
896: );
897: INV_LOG_UTIL.trace
898: ( 'l_msg_count => '|| l_msg_count

Line 959: ( 'x_nonrecoverable_tax is '||x_nonrecoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'

955: -- rajesh after loop
956: IF (l_debug = 1)
957: THEN
958: INV_LOG_UTIL.trace
959: ( 'x_nonrecoverable_tax is '||x_nonrecoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'
960: , 9
961: );
962: INV_LOG_UTIL.trace
963: ( 'x_recoverable_tax is '||x_recoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'

Line 963: ( 'x_recoverable_tax is '||x_recoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'

959: ( 'x_nonrecoverable_tax is '||x_nonrecoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'
960: , 9
961: );
962: INV_LOG_UTIL.trace
963: ( 'x_recoverable_tax is '||x_recoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'
964: , 9
965: );
966: INV_LOG_UTIL.trace
967: ( 'x_tax_rate is '||x_tax_rate,'INV_THIRD_PARTY_STOCK_PVT'

Line 967: ( 'x_tax_rate is '||x_tax_rate,'INV_THIRD_PARTY_STOCK_PVT'

963: ( 'x_recoverable_tax is '||x_recoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'
964: , 9
965: );
966: INV_LOG_UTIL.trace
967: ( 'x_tax_rate is '||x_tax_rate,'INV_THIRD_PARTY_STOCK_PVT'
968: , 9
969: );
970: INV_LOG_UTIL.trace
971: ( 'Return status is '||l_return_status,'INV_THIRD_PARTY_STOCK_PVT'

Line 971: ( 'Return status is '||l_return_status,'INV_THIRD_PARTY_STOCK_PVT'

967: ( 'x_tax_rate is '||x_tax_rate,'INV_THIRD_PARTY_STOCK_PVT'
968: , 9
969: );
970: INV_LOG_UTIL.trace
971: ( 'Return status is '||l_return_status,'INV_THIRD_PARTY_STOCK_PVT'
972: , 9
973: );
974: END IF;
975:

Line 1022: ( 'eBtax returned failure','INV_THIRD_PARTY_STOCK_PVT'

1018: ELSE
1019: IF (l_debug = 1)
1020: THEN
1021: INV_LOG_UTIL.trace
1022: ( 'eBtax returned failure','INV_THIRD_PARTY_STOCK_PVT'
1023: , 9
1024: );
1025: END IF;
1026: RAISE FND_API.G_EXC_ERROR;

Line 1061: ( 'SQLERRM '||SQLERRM|| ' SQLCODE '||SQLCODE ,'INV_THIRD_PARTY_STOCK_PVT'

1057: RAISE FND_API.G_EXC_ERROR;
1058:
1059: WHEN OTHERS THEN
1060: INV_LOG_UTIL.trace
1061: ( 'SQLERRM '||SQLERRM|| ' SQLCODE '||SQLCODE ,'INV_THIRD_PARTY_STOCK_PVT'
1062: , 9
1063: );
1064:
1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1140: ( '>> Entering Get Consumed Amt','INV_THIRD_PARTY_STOCK_PVT'

1136:
1137: IF (l_debug = 1)
1138: THEN
1139: INV_LOG_UTIL.trace
1140: ( '>> Entering Get Consumed Amt','INV_THIRD_PARTY_STOCK_PVT'
1141: , 9
1142: );
1143: END IF;
1144:

Line 1198: ( '>> UOM is different','INV_THIRD_PARTY_STOCK_PVT'

1194: );
1195:
1196:
1197: INV_LOG_UTIL.trace
1198: ( '>> UOM is different','INV_THIRD_PARTY_STOCK_PVT'
1199: , 9
1200: );
1201: END IF;
1202:

Line 1230: ( '>>Total qty from MCT:'||l_total_cons_qty,'INV_THIRD_PARTY_STOCK_PVT'

1226: NVL(l_total_cons_qty,0);
1227: IF (l_debug = 1)
1228: THEN
1229: INV_LOG_UTIL.trace
1230: ( '>>Total qty from MCT:'||l_total_cons_qty,'INV_THIRD_PARTY_STOCK_PVT'
1231: , 9
1232: );
1233: END IF;
1234: END LOOP;

Line 1240: ( '<< Exiting Get Consumed Amt','INV_THIRD_PARTY_STOCK_PVT'

1236:
1237: IF (l_debug = 1)
1238: THEN
1239: INV_LOG_UTIL.trace
1240: ( '<< Exiting Get Consumed Amt','INV_THIRD_PARTY_STOCK_PVT'
1241: , 9
1242: );
1243: END IF;
1244:

Line 1289: ( '>> Entering Get Total Blanket Amt','INV_THIRD_PARTY_STOCK_PVT'

1285:
1286: IF (l_debug = 1)
1287: THEN
1288: INV_LOG_UTIL.trace
1289: ( '>> Entering Get Total Blanket Amt','INV_THIRD_PARTY_STOCK_PVT'
1290: , 9
1291: );
1292: END IF;
1293:

Line 1315: ( '>> Released Amt:'||x_released_amt,'INV_THIRD_PARTY_STOCK_PVT'

1311:
1312: IF (l_debug = 1)
1313: THEN
1314: INV_LOG_UTIL.trace
1315: ( '>> Released Amt:'||x_released_amt,'INV_THIRD_PARTY_STOCK_PVT'
1316: , 9
1317: );
1318: END IF;
1319:

Line 1321: x_consumed_amt := INV_THIRD_PARTY_STOCK_PVT.get_consumed_amt

1317: );
1318: END IF;
1319:
1320: -- Get the consumed amounts for the blanket from MCT
1321: x_consumed_amt := INV_THIRD_PARTY_STOCK_PVT.get_consumed_amt
1322: ( p_header_id => p_po_header_id
1323: );
1324:
1325: IF (l_debug = 1)

Line 1328: ( '>> COnsumed Amt:'||x_consumed_amt,'INV_THIRD_PARTY_STOCK_PVT'

1324:
1325: IF (l_debug = 1)
1326: THEN
1327: INV_LOG_UTIL.trace
1328: ( '>> COnsumed Amt:'||x_consumed_amt,'INV_THIRD_PARTY_STOCK_PVT'
1329: , 9
1330: );
1331: END IF;
1332:

Line 1339: ( '>> Blanket does not have amount limit','INV_THIRD_PARTY_STOCK_PVT'

1335: ELSE
1336: IF (l_debug = 1)
1337: THEN
1338: INV_LOG_UTIL.trace
1339: ( '>> Blanket does not have amount limit','INV_THIRD_PARTY_STOCK_PVT'
1340: , 9
1341: );
1342: END IF;
1343:

Line 1353: ( '<< Exiting Get Total BLanket Amt','INV_THIRD_PARTY_STOCK_PVT'

1349:
1350: IF (l_debug = 1)
1351: THEN
1352: INV_LOG_UTIL.trace
1353: ( '<< Exiting Get Total BLanket Amt','INV_THIRD_PARTY_STOCK_PVT'
1354: , 9
1355: );
1356: END IF;
1357:

Line 1479: ( '>> Entering Get PO Info ','INV_THIRD_PARTY_STOCK_PVT'

1475:
1476: IF (l_debug = 1)
1477: THEN
1478: INV_LOG_UTIL.trace
1479: ( '>> Entering Get PO Info ','INV_THIRD_PARTY_STOCK_PVT'
1480: , 9
1481: );
1482: END IF;
1483: g_po_header_id := NULL;

Line 1529: INV_LOG_UTIL.trace('Implicit Txn ','INV_THIRD_PARTY_STOCK_PVT',9);

1525: (p_transaction_action_id<>6)
1526: THEN
1527: IF (l_debug = 1)
1528: THEN
1529: INV_LOG_UTIL.trace('Implicit Txn ','INV_THIRD_PARTY_STOCK_PVT',9);
1530: END IF;
1531:
1532: INV_PO_THIRD_PARTY_STOCK_MDTR.Get_Blanket_Number
1533: ( p_inventory_item_id => p_inventory_item_id

Line 1547: , 'INV_THIRD_PARTY_STOCK_PVT'

1543: IF (l_debug = 1)
1544: THEN
1545: INV_LOG_UTIL.trace
1546: ( 'Blanket Header and line are:'||l_header_id||' '||l_document_line_id
1547: , 'INV_THIRD_PARTY_STOCK_PVT'
1548: , 9
1549: );
1550:
1551: INV_LOG_UTIL.trace

Line 1553: , 'INV_THIRD_PARTY_STOCK_PVT'

1549: );
1550:
1551: INV_LOG_UTIL.trace
1552: ( 'Global flag is l_global_flag: '||l_global_flag
1553: , 'INV_THIRD_PARTY_STOCK_PVT'
1554: , 9
1555: );
1556: END IF;
1557:

Line 1754: , 'INV_THIRD_PARTY_STOCK_PVT'

1750: IF (l_debug = 1)
1751: THEN
1752: INV_LOG_UTIL.trace
1753: ( 'Before Price break the Price is '||l_po_price
1754: , 'INV_THIRD_PARTY_STOCK_PVT'
1755: , 9
1756: );
1757: END IF;
1758:

Line 1794: , 'INV_THIRD_PARTY_STOCK_PVT'

1790: IF (l_debug = 1)
1791: THEN
1792: INV_LOG_UTIL.trace
1793: ( 'After Price break the Price is '||l_po_price
1794: , 'INV_THIRD_PARTY_STOCK_PVT'
1795: , 9
1796: );
1797: END IF;
1798:

Line 1823: INV_THIRD_PARTY_STOCK_PVT.Calculate_Tax

1819: ELSE
1820: l_calculate_tax_global := 'N' ;
1821: END IF;
1822:
1823: INV_THIRD_PARTY_STOCK_PVT.Calculate_Tax
1824: ( p_header_id => l_header_id
1825: , p_line_id => l_document_line_id
1826: , p_org_id => l_org_id
1827: , p_item_id => p_inventory_item_id

Line 1863: , 'INV_THIRD_PARTY_STOCK_PVT'

1859: IF (l_debug = 1)
1860: THEN
1861: INV_LOG_UTIL.trace
1862: ( 'Price after tax calc is '||l_po_price
1863: , 'INV_THIRD_PARTY_STOCK_PVT'
1864: , 9
1865: );
1866: END IF;
1867:

Line 1878: , 'INV_THIRD_PARTY_STOCK_PVT'

1874: IF (l_debug = 1)
1875: THEN
1876: INV_LOG_UTIL.trace
1877: ( 'conversion rate for UOM is '||l_uom_rate
1878: , 'INV_THIRD_PARTY_STOCK_PVT'
1879: , 9
1880: );
1881:
1882: INV_LOG_UTIL.trace

Line 1884: , 'INV_THIRD_PARTY_STOCK_PVT'

1880: );
1881:
1882: INV_LOG_UTIL.trace
1883: ( 'Price after conversion of UOM is '||l_po_price
1884: , 'INV_THIRD_PARTY_STOCK_PVT'
1885: , 9
1886: );
1887: END IF;
1888:

Line 1934: INV_LOG_UTIL.trace('Curr. conv ','INV_THIRD_PARTY_STOCK_PVT',9);

1930: -- the Purchasing options.
1931:
1932: IF (l_debug = 1)
1933: THEN
1934: INV_LOG_UTIL.trace('Curr. conv ','INV_THIRD_PARTY_STOCK_PVT',9);
1935: END IF;
1936:
1937: IF INV_PO_THIRD_PARTY_STOCK_MDTR.is_global(l_header_id)
1938: THEN

Line 1945: INV_LOG_UTIL.trace('Blanket is GA','INV_THIRD_PARTY_STOCK_PVT',9);

1941: l_rate_date := p_transaction_date;
1942:
1943: IF (l_debug = 1)
1944: THEN
1945: INV_LOG_UTIL.trace('Blanket is GA','INV_THIRD_PARTY_STOCK_PVT',9);
1946: END IF;
1947:
1948: SELECT
1949: default_rate_type

Line 1973: , 'INV_THIRD_PARTY_STOCK_PVT'

1969: THEN
1970: INV_LOG_UTIL.trace
1971: ( '>> Rate date and type are: '||l_conv_type||' '||l_rate_date||
1972: l_currency_code||' '||l_func_currency
1973: , 'INV_THIRD_PARTY_STOCK_PVT'
1974: , 9
1975: );
1976: END IF;
1977:

Line 1978: INV_THIRD_PARTY_STOCK_PVT.Get_Conversion_Rate

1974: , 9
1975: );
1976: END IF;
1977:
1978: INV_THIRD_PARTY_STOCK_PVT.Get_Conversion_Rate
1979: ( p_set_of_books_id => l_sob_id
1980: , p_from_currency => l_currency_code
1981: , p_to_currency => l_func_currency
1982: , p_conversion_date => NVL(l_rate_date,SYSDATE)

Line 2000: , 'INV_THIRD_PARTY_STOCK_PVT'

1996: IF (l_debug = 1)
1997: THEN
1998: INV_LOG_UTIL.trace
1999: ( '>> PO price as OUT :'||l_po_price
2000: , 'INV_THIRD_PARTY_STOCK_PVT'
2001: , 9
2002: );
2003: END IF;
2004: /* Bug 13594851. Added else condition to null out the conv rate type and rate if both

Line 2019: INV_THIRD_PARTY_STOCK_PVT.Get_Total_Blanket_Amt

2015: END IF;
2016: /* Bug 13783272 */
2017:
2018: -- Get the total blanket amount from the PO if entered
2019: INV_THIRD_PARTY_STOCK_PVT.Get_Total_Blanket_Amt
2020: ( p_po_header_id => l_header_id
2021: , p_object => NVL(l_object,'B')
2022: , p_exchange_rate => l_rate
2023: , p_ccode_flag => NVL(l_ccode_flag,'N')

Line 2036: , 'INV_THIRD_PARTY_STOCK_PVT'

2032: ( '>> Amount limit:'||l_bkt_amt_limit
2033: ||'>> Released Amount: '||l_released_amt
2034: ||'>> Consumed Amount: '||l_consumed_amt
2035: ||'>> PO Price: '||l_purch_uom_price
2036: , 'INV_THIRD_PARTY_STOCK_PVT'
2037: , 9
2038: );
2039: END IF;
2040:

Line 2071: ( '<< Exiting Get PO Info','INV_THIRD_PARTY_STOCK_PVT'

2067:
2068: IF (l_debug = 1)
2069: THEN
2070: INV_LOG_UTIL.trace
2071: ( '<< Exiting Get PO Info','INV_THIRD_PARTY_STOCK_PVT'
2072: , 9
2073: );
2074: END IF;
2075:

Line 2252: ( '>> Entering Get Account','INV_THIRD_PARTY_STOCK_PVT'

2248:
2249: IF (l_debug = 1)
2250: THEN
2251: INV_LOG_UTIL.trace
2252: ( '>> Entering Get Account','INV_THIRD_PARTY_STOCK_PVT'
2253: , 9
2254: );
2255: END IF;
2256:

Line 2287: INV_LOG_UTIL.trace('Got coaid ','INV_THIRD_PARTY_STOCK_PVT',9);

2283: -- Call PO Account Generator to generate accrual account
2284:
2285: IF (l_debug = 1)
2286: THEN
2287: INV_LOG_UTIL.trace('Got coaid ','INV_THIRD_PARTY_STOCK_PVT',9);
2288: END IF;
2289:
2290: INV_PO_THIRD_PARTY_STOCK_MDTR.Generate_Account
2291: ( p_charge_success => l_charge_success

Line 2415: , 'INV_THIRD_PARTY_STOCK_PVT'

2411: IF (l_debug = 1)
2412: THEN
2413: INV_LOG_UTIL.trace
2414: ( 'acct generated is'||x_accrual_account_id
2415: , 'INV_THIRD_PARTY_STOCK_PVT'
2416: , 9
2417: );
2418: END IF;
2419:

Line 2452: 'INV_THIRD_PARTY_STOCK_PVT'

2448: IF (l_debug = 1)
2449: THEN
2450: INV_LOG_UTIL.trace
2451: ( 'OTHERS error - Get_Account' ,
2452: 'INV_THIRD_PARTY_STOCK_PVT'
2453: , 9
2454: );
2455: END IF;
2456: RAISE;

Line 2559: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT',9);

2555:
2556: IF (l_debug = 1)
2557: THEN
2558: INV_LOG_UTIL.trace('Call from TM >>',
2559: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT',9);
2560: INV_LOG_UTIL.trace('g_calling_action => '||g_calling_action ,9 );
2561: INV_LOG_UTIL.trace('g_error_code => '|| g_error_code,9);
2562: END IF;
2563:

Line 2594: INV_THIRD_PARTY_STOCK_PVT.Get_Account

2590: -- INVCONV get accoutn for process organiztions from OPM setup.
2591: /*????IF INV_GMI_RSV_BRANCH.Is_Org_Process_Org(l_org_id) THEN
2592: NULL; --INVCONV ???? this will be replaced with the new call of OPM API.
2593: ELSE */
2594: INV_THIRD_PARTY_STOCK_PVT.Get_Account
2595: ( p_mtl_transaction_id => p_mtl_transaction_id
2596: , p_transaction_source_type_id => p_transaction_source_type_id
2597: , p_transaction_action_id => p_transaction_action_id
2598: , p_transaction_source_id => l_transaction_source_id

Line 2612: INV_LOG_UTIL.trace('Account Generated>>','INV_THIRD_PARTY_STOCK_PVT',9);

2608: ----END IF;
2609:
2610: IF (l_debug = 1)
2611: THEN
2612: INV_LOG_UTIL.trace('Account Generated>>','INV_THIRD_PARTY_STOCK_PVT',9);
2613: END IF;
2614:
2615: -- Call to get the PO price, po_header_id.
2616:

Line 2617: INV_THIRD_PARTY_STOCK_PVT.Get_PO_Info

2613: END IF;
2614:
2615: -- Call to get the PO price, po_header_id.
2616:
2617: INV_THIRD_PARTY_STOCK_PVT.Get_PO_Info
2618: ( p_mtl_transaction_id => p_mtl_transaction_id
2619: , p_transaction_source_type_id => p_transaction_source_type_id
2620: , p_transaction_action_id => p_transaction_action_id
2621: , p_inventory_item_id => p_inventory_item_id

Line 2649: INV_LOG_UTIL.trace('PO Info fetched >>','INV_THIRD_PARTY_STOCK_PVT',9);

2645: );
2646:
2647: IF (l_debug = 1)
2648: THEN
2649: INV_LOG_UTIL.trace('PO Info fetched >>','INV_THIRD_PARTY_STOCK_PVT',9);
2650: END IF;
2651:
2652: -- Call to insert to consumptions table.
2653: IF (l_debug = 1)

Line 2664: 'INV_THIRD_PARTY_STOCK_PVT ',9);

2660: THEN
2661: IF (l_debug = 1)
2662: THEN
2663: INV_LOG_UTIL.trace('Record_Consumption' ,
2664: 'INV_THIRD_PARTY_STOCK_PVT ',9);
2665: END IF;
2666:
2667: /* INVCONV START PBAMB - Passing a new parameter p_secondary_transaction_qty to
2668: Record Consumption procedure to support process attributes for inventory convergence project*/

Line 2669: INV_THIRD_PARTY_STOCK_PVT.Record_Consumption

2665: END IF;
2666:
2667: /* INVCONV START PBAMB - Passing a new parameter p_secondary_transaction_qty to
2668: Record Consumption procedure to support process attributes for inventory convergence project*/
2669: INV_THIRD_PARTY_STOCK_PVT.Record_Consumption
2670: ( p_mtl_transaction_id => p_mtl_transaction_id
2671: , p_transaction_source_type_id => p_transaction_source_type_id
2672: , p_transaction_action_id => p_transaction_action_id
2673: , p_transaction_source_id => l_transaction_source_id

Line 2695: INV_LOG_UTIL.trace('Inserted to MCT>>','INV_THIRD_PARTY_STOCK_PVT',9);

2691: );
2692:
2693: IF (l_debug = 1)
2694: THEN
2695: INV_LOG_UTIL.trace('Inserted to MCT>>','INV_THIRD_PARTY_STOCK_PVT',9);
2696: END IF;
2697:
2698: -- Populate the costing table with the details of the txn.
2699: IF (l_debug = 1)

Line 2702: 'INV_THIRD_PARTY_STOCK_PVT ',9);

2698: -- Populate the costing table with the details of the txn.
2699: IF (l_debug = 1)
2700: THEN
2701: INV_LOG_UTIL.trace('Populate_Cost_Dtl',
2702: 'INV_THIRD_PARTY_STOCK_PVT ',9);
2703: END IF;
2704:
2705: -- INVCONV do not populate cost details for process organiztions.
2706: /* ????IF INV_GMI_RSV_BRANCH.Is_Org_Process_Org(l_org_id) THEN

Line 2709: INV_THIRD_PARTY_STOCK_PVT.Populate_Cost_Details

2705: -- INVCONV do not populate cost details for process organiztions.
2706: /* ????IF INV_GMI_RSV_BRANCH.Is_Org_Process_Org(l_org_id) THEN
2707: NULL;
2708: ELSE */
2709: INV_THIRD_PARTY_STOCK_PVT.Populate_Cost_Details
2710: ( p_mtl_transaction_id => p_mtl_transaction_id
2711: , p_rct_transaction_id => p_rct_transaction_id
2712: , p_transaction_source_type_id => p_transaction_source_type_id
2713: , p_transaction_action_id => p_transaction_action_id

Line 2722: INV_LOG_UTIL.trace('Populated CST tbl>>','INV_THIRD_PARTY_STOCK_PVT',9);

2718: --END IF;
2719:
2720: IF (l_debug = 1)
2721: THEN
2722: INV_LOG_UTIL.trace('Populated CST tbl>>','INV_THIRD_PARTY_STOCK_PVT',9);
2723: END IF;
2724: END IF ; -- Diagnostics
2725:
2726: p_transaction_source_id := l_po_header_id;

Line 2742: ( '<< Exiting Process Financial Info ','INV_THIRD_PARTY_STOCK_PVT'

2738:
2739: IF (l_debug = 1)
2740: THEN
2741: INV_LOG_UTIL.trace
2742: ( '<< Exiting Process Financial Info ','INV_THIRD_PARTY_STOCK_PVT'
2743: , 9
2744: );
2745: END IF;
2746:

Line 2761: 'INV_THIRD_PARTY_STOCK_PVT'

2757: IF (l_debug = 1)
2758: THEN
2759: INV_LOG_UTIL.trace
2760: ( '<< FND_API.G_EXC_ERROR - Process_fin Original API ',
2761: 'INV_THIRD_PARTY_STOCK_PVT'
2762: , 9
2763: );
2764: END IF;
2765:

Line 2779: 'INV_THIRD_PARTY_STOCK_PVT'

2775: IF (l_debug = 1)
2776: THEN
2777: INV_LOG_UTIL.trace
2778: ( '<< OTHERS error - Process_fin Original API ',
2779: 'INV_THIRD_PARTY_STOCK_PVT'
2780: , 9
2781: );
2782: INV_LOG_UTIL.trace
2783: ( '<< OTHERS error - Process_fin Original API ',

Line 2784: 'INV_THIRD_PARTY_STOCK_PVT'

2780: , 9
2781: );
2782: INV_LOG_UTIL.trace
2783: ( '<< OTHERS error - Process_fin Original API ',
2784: 'INV_THIRD_PARTY_STOCK_PVT'
2785: , 9
2786: );
2787: END IF;
2788:

Line 2864: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'

2860: IF (l_debug = 1)
2861: THEN
2862: INV_LOG_UTIL.trace
2863: ( '>> IN Process Financial Info - Diagnostics ',
2864: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'
2865: , 9
2866: );
2867: INV_LOG_UTIL.trace
2868: ( 'p_calling_action => ' || p_calling_action ,'INV_THIRD_PARTY_STOCK_PVT'

Line 2868: ( 'p_calling_action => ' || p_calling_action ,'INV_THIRD_PARTY_STOCK_PVT'

2864: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'
2865: , 9
2866: );
2867: INV_LOG_UTIL.trace
2868: ( 'p_calling_action => ' || p_calling_action ,'INV_THIRD_PARTY_STOCK_PVT'
2869: , 9
2870: );
2871: END IF;
2872:

Line 2896: INV_THIRD_PARTY_STOCK_PVT.Process_Financial_Info

2892: );
2893: END IF;
2894:
2895:
2896: INV_THIRD_PARTY_STOCK_PVT.Process_Financial_Info
2897: ( p_mtl_transaction_id => p_mtl_transaction_id
2898: , p_rct_transaction_id => p_rct_transaction_id
2899: , p_transaction_source_type_id => p_transaction_source_type_id
2900: , p_transaction_action_id => p_transaction_action_id

Line 2934: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'

2930: 'from Overloaded API '
2931: , 9
2932: );
2933: INV_LOG_UTIL.trace
2934: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'
2935: , 9);
2936: INV_LOG_UTIL.trace
2937: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
2938: , 9);

Line 2937: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'

2933: INV_LOG_UTIL.trace
2934: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'
2935: , 9);
2936: INV_LOG_UTIL.trace
2937: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
2938: , 9);
2939:
2940: INV_LOG_UTIL.trace
2941: ( 'x_purchasing_UOM=> ' || x_purchasing_UOM ,'INV_THIRD_PARTY_STOCK_PVT'

Line 2941: ( 'x_purchasing_UOM=> ' || x_purchasing_UOM ,'INV_THIRD_PARTY_STOCK_PVT'

2937: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
2938: , 9);
2939:
2940: INV_LOG_UTIL.trace
2941: ( 'x_purchasing_UOM=> ' || x_purchasing_UOM ,'INV_THIRD_PARTY_STOCK_PVT'
2942: , 9);
2943: INV_LOG_UTIL.trace
2944: ( 'x_primary_UOM=> ' || x_primary_UOM ,'INV_THIRD_PARTY_STOCK_PVT'
2945: , 9);

Line 2944: ( 'x_primary_UOM=> ' || x_primary_UOM ,'INV_THIRD_PARTY_STOCK_PVT'

2940: INV_LOG_UTIL.trace
2941: ( 'x_purchasing_UOM=> ' || x_purchasing_UOM ,'INV_THIRD_PARTY_STOCK_PVT'
2942: , 9);
2943: INV_LOG_UTIL.trace
2944: ( 'x_primary_UOM=> ' || x_primary_UOM ,'INV_THIRD_PARTY_STOCK_PVT'
2945: , 9);
2946: INV_LOG_UTIL.trace
2947: ( 'x_po_header_id=> ' || x_po_header_id ,'INV_THIRD_PARTY_STOCK_PVT'
2948: , 9);

Line 2947: ( 'x_po_header_id=> ' || x_po_header_id ,'INV_THIRD_PARTY_STOCK_PVT'

2943: INV_LOG_UTIL.trace
2944: ( 'x_primary_UOM=> ' || x_primary_UOM ,'INV_THIRD_PARTY_STOCK_PVT'
2945: , 9);
2946: INV_LOG_UTIL.trace
2947: ( 'x_po_header_id=> ' || x_po_header_id ,'INV_THIRD_PARTY_STOCK_PVT'
2948: , 9);
2949: END IF;
2950:
2951: x_error_code := g_error_code ;

Line 2967: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'

2963: IF (l_debug = 1)
2964: THEN
2965: INV_LOG_UTIL.trace
2966: ( '<< OUT Process Financial Info - Diagnostics ',
2967: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'
2968: , 9
2969: );
2970: INV_LOG_UTIL.trace
2971: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'

Line 2971: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'

2967: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'
2968: , 9
2969: );
2970: INV_LOG_UTIL.trace
2971: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'
2972: , 9);
2973: INV_LOG_UTIL.trace
2974: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
2975: , 9);

Line 2974: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'

2970: INV_LOG_UTIL.trace
2971: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'
2972: , 9);
2973: INV_LOG_UTIL.trace
2974: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
2975: , 9);
2976: END IF;
2977: g_po_header_id := NULL ;
2978:

Line 2994: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT' , 9);

2990: IF (l_debug = 1)
2991: THEN
2992: INV_LOG_UTIL.trace
2993: ( 'SQLERRM=> ' || SQLERRM ,
2994: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT' , 9);
2995: END IF;
2996:
2997: WHEN fnd_api.g_exc_unexpected_error THEN
2998: -- Reset_OU_Context;

Line 3010: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT' , 9);

3006: IF (l_debug = 1)
3007: THEN
3008: INV_LOG_UTIL.trace
3009: ( 'SQLERRM=> ' || SQLERRM ,
3010: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT' , 9);
3011: END IF;
3012:
3013:
3014: WHEN OTHERS THEN

Line 3026: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT' , 9);

3022: IF (l_debug = 1)
3023: THEN
3024: INV_LOG_UTIL.trace
3025: ( 'SQLERRM=> ' || SQLERRM ,
3026: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT' , 9);
3027: END IF;
3028:
3029:
3030: END Process_Financial_Info;

Line 3032: END INV_THIRD_PARTY_STOCK_PVT;

3028:
3029:
3030: END Process_Financial_Info;
3031:
3032: END INV_THIRD_PARTY_STOCK_PVT;