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.23.12010000.2 2008/07/29 12:55:46 ptkumar 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 122: ( '>> Entering Record Consumption','INV_THIRD_PARTY_STOCK_PVT'

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

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

200:
201: IF (l_debug = 1)
202: THEN
203: INV_LOG_UTIL.trace
204: ( '<< Exiting Record Consumption','INV_THIRD_PARTY_STOCK_PVT'
205: , 9
206: );
207: END IF;
208:

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

241:
242: IF (l_debug = 1)
243: THEN
244: INV_LOG_UTIL.trace
245: ( '>> Entering Populate Cost Details','INV_THIRD_PARTY_STOCK_PVT'
246: , 9
247: );
248: END IF;
249:

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

271:
272: IF (l_debug = 1)
273: THEN
274: INV_LOG_UTIL.trace
275: ( '<< Exiting Populate Cost Details','INV_THIRD_PARTY_STOCK_PVT'
276: , 9
277: );
278: END IF;
279:

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

318:
319: IF (l_debug = 1)
320: THEN
321: INV_LOG_UTIL.trace
322: ( '>> Entering Get Conversion Rate','INV_THIRD_PARTY_STOCK_PVT'
323: , 9
324: );
325: END IF;
326:

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

352:
353: IF (l_debug = 1)
354: THEN
355: INV_LOG_UTIL.trace
356: ( '<< Exiting Get Conversion Rate','INV_THIRD_PARTY_STOCK_PVT'
357: , 9
358: );
359: END IF;
360:

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

383:
384: IF (l_debug = 1)
385: THEN
386: INV_LOG_UTIL.trace
387: ( '>> Entering Reset OU ','INV_THIRD_PARTY_STOCK_PVT'
388: , 9
389: );
390: END IF;
391:

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

393:
394: IF (l_debug = 1)
395: THEN
396: INV_LOG_UTIL.trace
397: ( '<< Exiting Reset OU ','INV_THIRD_PARTY_STOCK_PVT'
398: , 9
399: );
400: END IF;
401:

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

860: -- End Rajesh
861: IF (l_debug = 1)
862: THEN
863: INV_LOG_UTIL.trace
864: ( 'Inserted into Tax Global temp tables','INV_THIRD_PARTY_STOCK_PVT'
865: , 9
866: );
867: INV_LOG_UTIL.trace
868: ( 'Calling INV_AP_TAX_ENGINE_MDTR.Calculate_Tax'

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

880:
881: IF (l_debug = 1)
882: THEN
883: INV_LOG_UTIL.trace
884: ( ' returned '||l_return_status,'INV_THIRD_PARTY_STOCK_PVT'
885: , 9
886: );
887: INV_LOG_UTIL.trace
888: ( 'l_msg_count => '|| l_msg_count

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

945: -- rajesh after loop
946: IF (l_debug = 1)
947: THEN
948: INV_LOG_UTIL.trace
949: ( 'x_nonrecoverable_tax is '||x_nonrecoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'
950: , 9
951: );
952: INV_LOG_UTIL.trace
953: ( 'x_recoverable_tax is '||x_recoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'

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

949: ( 'x_nonrecoverable_tax is '||x_nonrecoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'
950: , 9
951: );
952: INV_LOG_UTIL.trace
953: ( 'x_recoverable_tax is '||x_recoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'
954: , 9
955: );
956: INV_LOG_UTIL.trace
957: ( 'x_tax_rate is '||x_tax_rate,'INV_THIRD_PARTY_STOCK_PVT'

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

953: ( 'x_recoverable_tax is '||x_recoverable_tax,'INV_THIRD_PARTY_STOCK_PVT'
954: , 9
955: );
956: INV_LOG_UTIL.trace
957: ( 'x_tax_rate is '||x_tax_rate,'INV_THIRD_PARTY_STOCK_PVT'
958: , 9
959: );
960: INV_LOG_UTIL.trace
961: ( 'Return status is '||l_return_status,'INV_THIRD_PARTY_STOCK_PVT'

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

957: ( 'x_tax_rate is '||x_tax_rate,'INV_THIRD_PARTY_STOCK_PVT'
958: , 9
959: );
960: INV_LOG_UTIL.trace
961: ( 'Return status is '||l_return_status,'INV_THIRD_PARTY_STOCK_PVT'
962: , 9
963: );
964: END IF;
965:

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

1008: ELSE
1009: IF (l_debug = 1)
1010: THEN
1011: INV_LOG_UTIL.trace
1012: ( 'eBtax returned failure','INV_THIRD_PARTY_STOCK_PVT'
1013: , 9
1014: );
1015: END IF;
1016: RAISE FND_API.G_EXC_ERROR;

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

1047: RAISE FND_API.G_EXC_ERROR;
1048:
1049: WHEN OTHERS THEN
1050: INV_LOG_UTIL.trace
1051: ( 'SQLERRM '||SQLERRM|| ' SQLCODE '||SQLCODE ,'INV_THIRD_PARTY_STOCK_PVT'
1052: , 9
1053: );
1054:
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1128:
1129: IF (l_debug = 1)
1130: THEN
1131: INV_LOG_UTIL.trace
1132: ( '>> Entering Get Consumed Amt','INV_THIRD_PARTY_STOCK_PVT'
1133: , 9
1134: );
1135: END IF;
1136:

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

1186: );
1187:
1188:
1189: INV_LOG_UTIL.trace
1190: ( '>> UOM is different','INV_THIRD_PARTY_STOCK_PVT'
1191: , 9
1192: );
1193: END IF;
1194:

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

1218: NVL(l_total_cons_qty,0);
1219: IF (l_debug = 1)
1220: THEN
1221: INV_LOG_UTIL.trace
1222: ( '>>Total qty from MCT:'||l_total_cons_qty,'INV_THIRD_PARTY_STOCK_PVT'
1223: , 9
1224: );
1225: END IF;
1226: END LOOP;

Line 1239: ( '>>Total converted:'||l_total_cons_qty,'INV_THIRD_PARTY_STOCK_PVT'

1235:
1236: IF (l_debug = 1)
1237: THEN
1238: INV_LOG_UTIL.trace
1239: ( '>>Total converted:'||l_total_cons_qty,'INV_THIRD_PARTY_STOCK_PVT'
1240: , 9
1241: );
1242: END IF;
1243: END IF;

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

1244:
1245: IF (l_debug = 1)
1246: THEN
1247: INV_LOG_UTIL.trace
1248: ( '<< Exiting Get Consumed Amt','INV_THIRD_PARTY_STOCK_PVT'
1249: , 9
1250: );
1251: END IF;
1252:

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

1293:
1294: IF (l_debug = 1)
1295: THEN
1296: INV_LOG_UTIL.trace
1297: ( '>> Entering Get Total Blanket Amt','INV_THIRD_PARTY_STOCK_PVT'
1298: , 9
1299: );
1300: END IF;
1301:

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

1319:
1320: IF (l_debug = 1)
1321: THEN
1322: INV_LOG_UTIL.trace
1323: ( '>> Released Amt:'||x_released_amt,'INV_THIRD_PARTY_STOCK_PVT'
1324: , 9
1325: );
1326: END IF;
1327:

Line 1329: x_consumed_amt := INV_THIRD_PARTY_STOCK_PVT.get_consumed_amt

1325: );
1326: END IF;
1327:
1328: -- Get the consumed amounts for the blanket from MCT
1329: x_consumed_amt := INV_THIRD_PARTY_STOCK_PVT.get_consumed_amt
1330: ( p_header_id => p_po_header_id
1331: , p_rate => p_exchange_rate
1332: , p_currency_flag => p_ccode_flag
1333: );

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

1334:
1335: IF (l_debug = 1)
1336: THEN
1337: INV_LOG_UTIL.trace
1338: ( '>> COnsumed Amt:'||x_consumed_amt,'INV_THIRD_PARTY_STOCK_PVT'
1339: , 9
1340: );
1341: END IF;
1342:

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

1345: ELSE
1346: IF (l_debug = 1)
1347: THEN
1348: INV_LOG_UTIL.trace
1349: ( '>> Blanket does not have amount limit','INV_THIRD_PARTY_STOCK_PVT'
1350: , 9
1351: );
1352: END IF;
1353:

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

1359:
1360: IF (l_debug = 1)
1361: THEN
1362: INV_LOG_UTIL.trace
1363: ( '<< Exiting Get Total BLanket Amt','INV_THIRD_PARTY_STOCK_PVT'
1364: , 9
1365: );
1366: END IF;
1367:

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

1483:
1484: IF (l_debug = 1)
1485: THEN
1486: INV_LOG_UTIL.trace
1487: ( '>> Entering Get PO Info ','INV_THIRD_PARTY_STOCK_PVT'
1488: , 9
1489: );
1490: END IF;
1491: g_po_header_id := NULL;

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

1533: (p_transaction_action_id<>6)
1534: THEN
1535: IF (l_debug = 1)
1536: THEN
1537: INV_LOG_UTIL.trace('Implicit Txn ','INV_THIRD_PARTY_STOCK_PVT',9);
1538: END IF;
1539:
1540: INV_PO_THIRD_PARTY_STOCK_MDTR.Get_Blanket_Number
1541: ( p_inventory_item_id => p_inventory_item_id

Line 1555: , 'INV_THIRD_PARTY_STOCK_PVT'

1551: IF (l_debug = 1)
1552: THEN
1553: INV_LOG_UTIL.trace
1554: ( 'Blanket Header and line are:'||l_header_id||' '||l_document_line_id
1555: , 'INV_THIRD_PARTY_STOCK_PVT'
1556: , 9
1557: );
1558:
1559: INV_LOG_UTIL.trace

Line 1561: , 'INV_THIRD_PARTY_STOCK_PVT'

1557: );
1558:
1559: INV_LOG_UTIL.trace
1560: ( 'Global flag is l_global_flag: '||l_global_flag
1561: , 'INV_THIRD_PARTY_STOCK_PVT'
1562: , 9
1563: );
1564: END IF;
1565:

Line 1759: , 'INV_THIRD_PARTY_STOCK_PVT'

1755: IF (l_debug = 1)
1756: THEN
1757: INV_LOG_UTIL.trace
1758: ( 'Before Price break the Price is '||l_po_price
1759: , 'INV_THIRD_PARTY_STOCK_PVT'
1760: , 9
1761: );
1762: END IF;
1763:

Line 1799: , 'INV_THIRD_PARTY_STOCK_PVT'

1795: IF (l_debug = 1)
1796: THEN
1797: INV_LOG_UTIL.trace
1798: ( 'After Price break the Price is '||l_po_price
1799: , 'INV_THIRD_PARTY_STOCK_PVT'
1800: , 9
1801: );
1802: END IF;
1803:

Line 1828: INV_THIRD_PARTY_STOCK_PVT.Calculate_Tax

1824: ELSE
1825: l_calculate_tax_global := 'N' ;
1826: END IF;
1827:
1828: INV_THIRD_PARTY_STOCK_PVT.Calculate_Tax
1829: ( p_header_id => l_header_id
1830: , p_line_id => l_document_line_id
1831: , p_org_id => l_org_id
1832: , p_item_id => p_inventory_item_id

Line 1868: , 'INV_THIRD_PARTY_STOCK_PVT'

1864: IF (l_debug = 1)
1865: THEN
1866: INV_LOG_UTIL.trace
1867: ( 'Price after tax calc is '||l_po_price
1868: , 'INV_THIRD_PARTY_STOCK_PVT'
1869: , 9
1870: );
1871: END IF;
1872:

Line 1883: , 'INV_THIRD_PARTY_STOCK_PVT'

1879: IF (l_debug = 1)
1880: THEN
1881: INV_LOG_UTIL.trace
1882: ( 'conversion rate for UOM is '||l_uom_rate
1883: , 'INV_THIRD_PARTY_STOCK_PVT'
1884: , 9
1885: );
1886:
1887: INV_LOG_UTIL.trace

Line 1889: , 'INV_THIRD_PARTY_STOCK_PVT'

1885: );
1886:
1887: INV_LOG_UTIL.trace
1888: ( 'Price after conversion of UOM is '||l_po_price
1889: , 'INV_THIRD_PARTY_STOCK_PVT'
1890: , 9
1891: );
1892: END IF;
1893:

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

1935: -- the Purchasing options.
1936:
1937: IF (l_debug = 1)
1938: THEN
1939: INV_LOG_UTIL.trace('Curr. conv ','INV_THIRD_PARTY_STOCK_PVT',9);
1940: END IF;
1941:
1942: IF INV_PO_THIRD_PARTY_STOCK_MDTR.is_global(l_header_id)
1943: THEN

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

1946: l_rate_date := p_transaction_date;
1947:
1948: IF (l_debug = 1)
1949: THEN
1950: INV_LOG_UTIL.trace('Blanket is GA','INV_THIRD_PARTY_STOCK_PVT',9);
1951: END IF;
1952:
1953: SELECT
1954: default_rate_type

Line 1978: , 'INV_THIRD_PARTY_STOCK_PVT'

1974: THEN
1975: INV_LOG_UTIL.trace
1976: ( '>> Rate date and type are: '||l_conv_type||' '||l_rate_date||
1977: l_currency_code||' '||l_func_currency
1978: , 'INV_THIRD_PARTY_STOCK_PVT'
1979: , 9
1980: );
1981: END IF;
1982:

Line 1983: INV_THIRD_PARTY_STOCK_PVT.Get_Conversion_Rate

1979: , 9
1980: );
1981: END IF;
1982:
1983: INV_THIRD_PARTY_STOCK_PVT.Get_Conversion_Rate
1984: ( p_set_of_books_id => l_sob_id
1985: , p_from_currency => l_currency_code
1986: , p_to_currency => l_func_currency
1987: , p_conversion_date => NVL(l_rate_date,SYSDATE)

Line 2005: , 'INV_THIRD_PARTY_STOCK_PVT'

2001: IF (l_debug = 1)
2002: THEN
2003: INV_LOG_UTIL.trace
2004: ( '>> PO price as OUT :'||l_po_price
2005: , 'INV_THIRD_PARTY_STOCK_PVT'
2006: , 9
2007: );
2008: END IF;
2009:

Line 2014: INV_THIRD_PARTY_STOCK_PVT.Get_Total_Blanket_Amt

2010: END IF;
2011:
2012: -- Get the total blanket amount from the PO if entered
2013:
2014: INV_THIRD_PARTY_STOCK_PVT.Get_Total_Blanket_Amt
2015: ( p_po_header_id => l_header_id
2016: , p_object => NVL(l_object,'B')
2017: , p_exchange_rate => l_rate
2018: , p_ccode_flag => NVL(l_ccode_flag,'N')

Line 2031: , 'INV_THIRD_PARTY_STOCK_PVT'

2027: ( '>> Amount limit:'||l_bkt_amt_limit
2028: ||'>> Released Amount: '||l_released_amt
2029: ||'>> Consumed Amount: '||l_consumed_amt
2030: ||'>> PO Price: '||l_purch_uom_price
2031: , 'INV_THIRD_PARTY_STOCK_PVT'
2032: , 9
2033: );
2034: END IF;
2035:

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

2062:
2063: IF (l_debug = 1)
2064: THEN
2065: INV_LOG_UTIL.trace
2066: ( '<< Exiting Get PO Info','INV_THIRD_PARTY_STOCK_PVT'
2067: , 9
2068: );
2069: END IF;
2070:

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

2243:
2244: IF (l_debug = 1)
2245: THEN
2246: INV_LOG_UTIL.trace
2247: ( '>> Entering Get Account','INV_THIRD_PARTY_STOCK_PVT'
2248: , 9
2249: );
2250: END IF;
2251:

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

2278: -- Call PO Account Generator to generate accrual account
2279:
2280: IF (l_debug = 1)
2281: THEN
2282: INV_LOG_UTIL.trace('Got coaid ','INV_THIRD_PARTY_STOCK_PVT',9);
2283: END IF;
2284:
2285: INV_PO_THIRD_PARTY_STOCK_MDTR.Generate_Account
2286: ( p_charge_success => l_charge_success

Line 2410: , 'INV_THIRD_PARTY_STOCK_PVT'

2406: IF (l_debug = 1)
2407: THEN
2408: INV_LOG_UTIL.trace
2409: ( 'acct generated is'||x_accrual_account_id
2410: , 'INV_THIRD_PARTY_STOCK_PVT'
2411: , 9
2412: );
2413: END IF;
2414:

Line 2447: 'INV_THIRD_PARTY_STOCK_PVT'

2443: IF (l_debug = 1)
2444: THEN
2445: INV_LOG_UTIL.trace
2446: ( 'OTHERS error - Get_Account' ,
2447: 'INV_THIRD_PARTY_STOCK_PVT'
2448: , 9
2449: );
2450: END IF;
2451: RAISE;

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

2547:
2548: IF (l_debug = 1)
2549: THEN
2550: INV_LOG_UTIL.trace('Call from TM >>',
2551: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT',9);
2552: INV_LOG_UTIL.trace('g_calling_action => '||g_calling_action ,9 );
2553: INV_LOG_UTIL.trace('g_error_code => '|| g_error_code,9);
2554: END IF;
2555:

Line 2586: INV_THIRD_PARTY_STOCK_PVT.Get_Account

2582: -- INVCONV get accoutn for process organiztions from OPM setup.
2583: /*????IF INV_GMI_RSV_BRANCH.Is_Org_Process_Org(l_org_id) THEN
2584: NULL; --INVCONV ???? this will be replaced with the new call of OPM API.
2585: ELSE */
2586: INV_THIRD_PARTY_STOCK_PVT.Get_Account
2587: ( p_mtl_transaction_id => p_mtl_transaction_id
2588: , p_transaction_source_type_id => p_transaction_source_type_id
2589: , p_transaction_action_id => p_transaction_action_id
2590: , p_transaction_source_id => l_transaction_source_id

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

2600: ----END IF;
2601:
2602: IF (l_debug = 1)
2603: THEN
2604: INV_LOG_UTIL.trace('Account Generated>>','INV_THIRD_PARTY_STOCK_PVT',9);
2605: END IF;
2606:
2607: -- Call to get the PO price, po_header_id.
2608:

Line 2609: INV_THIRD_PARTY_STOCK_PVT.Get_PO_Info

2605: END IF;
2606:
2607: -- Call to get the PO price, po_header_id.
2608:
2609: INV_THIRD_PARTY_STOCK_PVT.Get_PO_Info
2610: ( p_mtl_transaction_id => p_mtl_transaction_id
2611: , p_transaction_source_type_id => p_transaction_source_type_id
2612: , p_transaction_action_id => p_transaction_action_id
2613: , p_inventory_item_id => p_inventory_item_id

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

2635: );
2636:
2637: IF (l_debug = 1)
2638: THEN
2639: INV_LOG_UTIL.trace('PO Info fetched >>','INV_THIRD_PARTY_STOCK_PVT',9);
2640: END IF;
2641:
2642: -- Call to insert to consumptions table.
2643: IF (l_debug = 1)

Line 2654: 'INV_THIRD_PARTY_STOCK_PVT ',9);

2650: THEN
2651: IF (l_debug = 1)
2652: THEN
2653: INV_LOG_UTIL.trace('Record_Consumption' ,
2654: 'INV_THIRD_PARTY_STOCK_PVT ',9);
2655: END IF;
2656:
2657: /* INVCONV START PBAMB - Passing a new parameter p_secondary_transaction_qty to
2658: Record Consumption procedure to support process attributes for inventory convergence project*/

Line 2659: INV_THIRD_PARTY_STOCK_PVT.Record_Consumption

2655: END IF;
2656:
2657: /* INVCONV START PBAMB - Passing a new parameter p_secondary_transaction_qty to
2658: Record Consumption procedure to support process attributes for inventory convergence project*/
2659: INV_THIRD_PARTY_STOCK_PVT.Record_Consumption
2660: ( p_mtl_transaction_id => p_mtl_transaction_id
2661: , p_transaction_source_type_id => p_transaction_source_type_id
2662: , p_transaction_action_id => p_transaction_action_id
2663: , p_transaction_source_id => l_transaction_source_id

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

2679: );
2680:
2681: IF (l_debug = 1)
2682: THEN
2683: INV_LOG_UTIL.trace('Inserted to MCT>>','INV_THIRD_PARTY_STOCK_PVT',9);
2684: END IF;
2685:
2686: -- Populate the costing table with the details of the txn.
2687: IF (l_debug = 1)

Line 2690: 'INV_THIRD_PARTY_STOCK_PVT ',9);

2686: -- Populate the costing table with the details of the txn.
2687: IF (l_debug = 1)
2688: THEN
2689: INV_LOG_UTIL.trace('Populate_Cost_Dtl',
2690: 'INV_THIRD_PARTY_STOCK_PVT ',9);
2691: END IF;
2692:
2693: -- INVCONV do not populate cost details for process organiztions.
2694: /* ????IF INV_GMI_RSV_BRANCH.Is_Org_Process_Org(l_org_id) THEN

Line 2697: INV_THIRD_PARTY_STOCK_PVT.Populate_Cost_Details

2693: -- INVCONV do not populate cost details for process organiztions.
2694: /* ????IF INV_GMI_RSV_BRANCH.Is_Org_Process_Org(l_org_id) THEN
2695: NULL;
2696: ELSE */
2697: INV_THIRD_PARTY_STOCK_PVT.Populate_Cost_Details
2698: ( p_mtl_transaction_id => p_mtl_transaction_id
2699: , p_rct_transaction_id => p_rct_transaction_id
2700: , p_transaction_source_type_id => p_transaction_source_type_id
2701: , p_transaction_action_id => p_transaction_action_id

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

2706: --END IF;
2707:
2708: IF (l_debug = 1)
2709: THEN
2710: INV_LOG_UTIL.trace('Populated CST tbl>>','INV_THIRD_PARTY_STOCK_PVT',9);
2711: END IF;
2712: END IF ; -- Diagnostics
2713:
2714: p_transaction_source_id := l_po_header_id;

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

2726:
2727: IF (l_debug = 1)
2728: THEN
2729: INV_LOG_UTIL.trace
2730: ( '<< Exiting Process Financial Info ','INV_THIRD_PARTY_STOCK_PVT'
2731: , 9
2732: );
2733: END IF;
2734:

Line 2749: 'INV_THIRD_PARTY_STOCK_PVT'

2745: IF (l_debug = 1)
2746: THEN
2747: INV_LOG_UTIL.trace
2748: ( '<< FND_API.G_EXC_ERROR - Process_fin Original API ',
2749: 'INV_THIRD_PARTY_STOCK_PVT'
2750: , 9
2751: );
2752: END IF;
2753:

Line 2767: 'INV_THIRD_PARTY_STOCK_PVT'

2763: IF (l_debug = 1)
2764: THEN
2765: INV_LOG_UTIL.trace
2766: ( '<< OTHERS error - Process_fin Original API ',
2767: 'INV_THIRD_PARTY_STOCK_PVT'
2768: , 9
2769: );
2770: INV_LOG_UTIL.trace
2771: ( '<< OTHERS error - Process_fin Original API ',

Line 2772: 'INV_THIRD_PARTY_STOCK_PVT'

2768: , 9
2769: );
2770: INV_LOG_UTIL.trace
2771: ( '<< OTHERS error - Process_fin Original API ',
2772: 'INV_THIRD_PARTY_STOCK_PVT'
2773: , 9
2774: );
2775: END IF;
2776:

Line 2852: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'

2848: IF (l_debug = 1)
2849: THEN
2850: INV_LOG_UTIL.trace
2851: ( '>> IN Process Financial Info - Diagnostics ',
2852: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'
2853: , 9
2854: );
2855: INV_LOG_UTIL.trace
2856: ( 'p_calling_action => ' || p_calling_action ,'INV_THIRD_PARTY_STOCK_PVT'

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

2852: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'
2853: , 9
2854: );
2855: INV_LOG_UTIL.trace
2856: ( 'p_calling_action => ' || p_calling_action ,'INV_THIRD_PARTY_STOCK_PVT'
2857: , 9
2858: );
2859: END IF;
2860:

Line 2884: INV_THIRD_PARTY_STOCK_PVT.Process_Financial_Info

2880: );
2881: END IF;
2882:
2883:
2884: INV_THIRD_PARTY_STOCK_PVT.Process_Financial_Info
2885: ( p_mtl_transaction_id => p_mtl_transaction_id
2886: , p_rct_transaction_id => p_rct_transaction_id
2887: , p_transaction_source_type_id => p_transaction_source_type_id
2888: , p_transaction_action_id => p_transaction_action_id

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

2918: 'from Overloaded API '
2919: , 9
2920: );
2921: INV_LOG_UTIL.trace
2922: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'
2923: , 9);
2924: INV_LOG_UTIL.trace
2925: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
2926: , 9);

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

2921: INV_LOG_UTIL.trace
2922: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'
2923: , 9);
2924: INV_LOG_UTIL.trace
2925: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
2926: , 9);
2927:
2928: INV_LOG_UTIL.trace
2929: ( 'x_purchasing_UOM=> ' || x_purchasing_UOM ,'INV_THIRD_PARTY_STOCK_PVT'

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

2925: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
2926: , 9);
2927:
2928: INV_LOG_UTIL.trace
2929: ( 'x_purchasing_UOM=> ' || x_purchasing_UOM ,'INV_THIRD_PARTY_STOCK_PVT'
2930: , 9);
2931: INV_LOG_UTIL.trace
2932: ( 'x_primary_UOM=> ' || x_primary_UOM ,'INV_THIRD_PARTY_STOCK_PVT'
2933: , 9);

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

2928: INV_LOG_UTIL.trace
2929: ( 'x_purchasing_UOM=> ' || x_purchasing_UOM ,'INV_THIRD_PARTY_STOCK_PVT'
2930: , 9);
2931: INV_LOG_UTIL.trace
2932: ( 'x_primary_UOM=> ' || x_primary_UOM ,'INV_THIRD_PARTY_STOCK_PVT'
2933: , 9);
2934: INV_LOG_UTIL.trace
2935: ( 'x_po_header_id=> ' || x_po_header_id ,'INV_THIRD_PARTY_STOCK_PVT'
2936: , 9);

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

2931: INV_LOG_UTIL.trace
2932: ( 'x_primary_UOM=> ' || x_primary_UOM ,'INV_THIRD_PARTY_STOCK_PVT'
2933: , 9);
2934: INV_LOG_UTIL.trace
2935: ( 'x_po_header_id=> ' || x_po_header_id ,'INV_THIRD_PARTY_STOCK_PVT'
2936: , 9);
2937: END IF;
2938:
2939: x_error_code := g_error_code ;

Line 2955: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'

2951: IF (l_debug = 1)
2952: THEN
2953: INV_LOG_UTIL.trace
2954: ( '<< OUT Process Financial Info - Diagnostics ',
2955: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'
2956: , 9
2957: );
2958: INV_LOG_UTIL.trace
2959: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'

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

2955: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT'
2956: , 9
2957: );
2958: INV_LOG_UTIL.trace
2959: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'
2960: , 9);
2961: INV_LOG_UTIL.trace
2962: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
2963: , 9);

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

2958: INV_LOG_UTIL.trace
2959: ( 'x_return_status => '|| x_return_status ,'INV_THIRD_PARTY_STOCK_PVT'
2960: , 9);
2961: INV_LOG_UTIL.trace
2962: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
2963: , 9);
2964: END IF;
2965: g_po_header_id := NULL ;
2966:

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

2978: IF (l_debug = 1)
2979: THEN
2980: INV_LOG_UTIL.trace
2981: ( 'SQLERRM=> ' || SQLERRM ,
2982: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT' , 9);
2983: END IF;
2984:
2985: WHEN fnd_api.g_exc_unexpected_error THEN
2986: -- Reset_OU_Context;

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

2994: IF (l_debug = 1)
2995: THEN
2996: INV_LOG_UTIL.trace
2997: ( 'SQLERRM=> ' || SQLERRM ,
2998: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT' , 9);
2999: END IF;
3000:
3001:
3002: WHEN OTHERS THEN

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

3010: IF (l_debug = 1)
3011: THEN
3012: INV_LOG_UTIL.trace
3013: ( 'SQLERRM=> ' || SQLERRM ,
3014: 'INVVTPSB: INV_THIRD_PARTY_STOCK_PVT' , 9);
3015: END IF;
3016:
3017:
3018: END Process_Financial_Info;

Line 3020: END INV_THIRD_PARTY_STOCK_PVT;

3016:
3017:
3018: END Process_Financial_Info;
3019:
3020: END INV_THIRD_PARTY_STOCK_PVT;