DBA Data[Home] [Help]

APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on INV_LOG_UTIL

Line 121: INV_LOG_UTIL.trace

117: BEGIN
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;

Line 203: INV_LOG_UTIL.trace

199: );
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;

Line 244: INV_LOG_UTIL.trace

240: -- transactions, the TM will do the insert.
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;

Line 274: INV_LOG_UTIL.trace

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

Line 321: INV_LOG_UTIL.trace

317: -- Call to the GL API to get the rate
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;

Line 355: INV_LOG_UTIL.trace

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

Line 386: INV_LOG_UTIL.trace

382: BEGIN
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;

Line 396: INV_LOG_UTIL.trace

392: FND_GLOBAL.apps_initialize(g_user_id,g_resp_id,g_pgm_appl_id);
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;

Line 519: INV_LOG_UTIL.trace

515: BEGIN
516:
517: IF (l_debug = 1)
518: THEN
519: INV_LOG_UTIL.trace
520: ( 'Entering Into calculate tax '
521: , 9
522: );
523: END IF;

Line 535: INV_LOG_UTIL.trace

531: WHERE application_short_name = 'PO';
532:
533: IF (l_debug = 1)
534: THEN
535: INV_LOG_UTIL.trace
536: ( 'l_application_id => ' || l_application_id
537: , 9
538: );
539: END IF;

Line 542: INV_LOG_UTIL.trace

538: );
539: END IF;
540: IF (l_debug = 1)
541: THEN
542: INV_LOG_UTIL.trace
543: ( 'l_ship_to_location_id => '|| l_ship_to_location_id
544: , 9
545: );
546: END IF;

Line 607: INV_LOG_UTIL.trace

603:
604:
605: IF (l_debug = 1)
606: THEN
607: INV_LOG_UTIL.trace
608: ( 'l_vendor_party_id => ' || l_vendor_party_id
609: , 9
610: );
611: INV_LOG_UTIL.trace

Line 611: INV_LOG_UTIL.trace

607: INV_LOG_UTIL.trace
608: ( 'l_vendor_party_id => ' || l_vendor_party_id
609: , 9
610: );
611: INV_LOG_UTIL.trace
612: ( 'l_vendor_site_party_id => '|| l_vendor_site_party_id
613: , 9
614: );
615: INV_LOG_UTIL.trace

Line 615: INV_LOG_UTIL.trace

611: INV_LOG_UTIL.trace
612: ( 'l_vendor_site_party_id => '|| l_vendor_site_party_id
613: , 9
614: );
615: INV_LOG_UTIL.trace
616: ( 'rajesh p_header_id => '|| p_header_id
617: , 9
618: );
619: INV_LOG_UTIL.trace

Line 619: INV_LOG_UTIL.trace

615: INV_LOG_UTIL.trace
616: ( 'rajesh p_header_id => '|| p_header_id
617: , 9
618: );
619: INV_LOG_UTIL.trace
620: ( 'icx_session_id = > '|| FND_GLOBAL.session_id
621: , 9
622: );
623: INV_LOG_UTIL.trace

Line 623: INV_LOG_UTIL.trace

619: INV_LOG_UTIL.trace
620: ( 'icx_session_id = > '|| FND_GLOBAL.session_id
621: , 9
622: );
623: INV_LOG_UTIL.trace
624: ( 'p_global_flag => '|| p_global_flag
625: , 9
626: );
627: INV_LOG_UTIL.trace

Line 627: INV_LOG_UTIL.trace

623: INV_LOG_UTIL.trace
624: ( 'p_global_flag => '|| p_global_flag
625: , 9
626: );
627: INV_LOG_UTIL.trace
628: ( '*** Start inserting into GT tables '
629: , 9
630: );
631:

Line 632: INV_LOG_UTIL.trace

628: ( '*** Start inserting into GT tables '
629: , 9
630: );
631:
632: INV_LOG_UTIL.trace
633: ( 'l_event_type_code => '|| l_event_type_code
634: , 9
635: );
636: INV_LOG_UTIL.trace

Line 636: INV_LOG_UTIL.trace

632: INV_LOG_UTIL.trace
633: ( 'l_event_type_code => '|| l_event_type_code
634: , 9
635: );
636: INV_LOG_UTIL.trace
637: ( 'l_entity_code => '|| l_entity_code
638: , 9
639: );
640: INV_LOG_UTIL.trace

Line 640: INV_LOG_UTIL.trace

636: INV_LOG_UTIL.trace
637: ( 'l_entity_code => '|| l_entity_code
638: , 9
639: );
640: INV_LOG_UTIL.trace
641: ( 'l_event_class_code => ' || l_event_class_code
642: , 9
643: );
644: INV_LOG_UTIL.trace

Line 644: INV_LOG_UTIL.trace

640: INV_LOG_UTIL.trace
641: ( 'l_event_class_code => ' || l_event_class_code
642: , 9
643: );
644: INV_LOG_UTIL.trace
645: ( 'l_vendor_org_id => '|| l_vendor_org_id
646: , 9
647: );
648: INV_LOG_UTIL.trace

Line 648: INV_LOG_UTIL.trace

644: INV_LOG_UTIL.trace
645: ( 'l_vendor_org_id => '|| l_vendor_org_id
646: , 9
647: );
648: INV_LOG_UTIL.trace
649: ( 'l_legal_entity_id => ' || l_legal_entity_id
650: , 9
651: );
652: INV_LOG_UTIL.trace

Line 652: INV_LOG_UTIL.trace

648: INV_LOG_UTIL.trace
649: ( 'l_legal_entity_id => ' || l_legal_entity_id
650: , 9
651: );
652: INV_LOG_UTIL.trace
653: ( 'l_set_of_books_id => '|| l_set_of_books_id
654: , 9
655: );
656: END IF;

Line 672: INV_LOG_UTIL.trace

668: WHERE NVL(org_id,-99) = NVL(p_org_id,-99);
669: END IF ;
670: /* bug 5081702 End*/
671:
672: INV_LOG_UTIL.trace
673: ( 'l_rate_type => '|| l_rate_type
674: , 9
675: );
676:

Line 679: INV_LOG_UTIL.trace

675: );
676:
677: --Rajesh start inserting GT
678:
679: INV_LOG_UTIL.trace
680: ( 'Etax: clearing existing records from GT '
681: , 9
682: );
683: /* 5084307 - Start */

Line 863: INV_LOG_UTIL.trace

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

Line 867: INV_LOG_UTIL.trace

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'
869: , 9
870: );
871:

Line 883: INV_LOG_UTIL.trace

879: );
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

Line 887: INV_LOG_UTIL.trace

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
889: , 9
890: );
891: INV_LOG_UTIL.trace

Line 891: INV_LOG_UTIL.trace

887: INV_LOG_UTIL.trace
888: ( 'l_msg_count => '|| l_msg_count
889: , 9
890: );
891: INV_LOG_UTIL.trace
892: ( 'l_msg_data => '|| l_msg_data
893: , 9
894: );
895:

Line 948: INV_LOG_UTIL.trace

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

Line 952: INV_LOG_UTIL.trace

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'
954: , 9
955: );
956: INV_LOG_UTIL.trace

Line 956: INV_LOG_UTIL.trace

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'
958: , 9
959: );
960: INV_LOG_UTIL.trace

Line 960: INV_LOG_UTIL.trace

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'
962: , 9
963: );
964: END IF;

Line 1011: INV_LOG_UTIL.trace

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

Line 1023: INV_LOG_UTIL.trace

1019: EXCEPTION
1020: WHEN NO_DATA_FOUND THEN
1021: IF (l_debug = 1)
1022: THEN
1023: INV_LOG_UTIL.trace
1024: ( 'NO_DATA_FOUND exception','INV Calculate_tax'
1025: , 9
1026: );
1027: END IF;

Line 1050: INV_LOG_UTIL.trace

1046: g_error_code := 'INV_CONS_SUP_NO_TAX_SETUP' ;
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:

Line 1131: INV_LOG_UTIL.trace

1127: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
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;

Line 1179: INV_LOG_UTIL.trace

1175: -- Convert the qty to purchasing UOM, the UOM's are different
1176:
1177: IF (l_debug = 1)
1178: THEN
1179: INV_LOG_UTIL.trace
1180: ( 'l_primary_uom => '|| l_primary_uom, NULL
1181: , 9
1182: );
1183: INV_LOG_UTIL.trace

Line 1183: INV_LOG_UTIL.trace

1179: INV_LOG_UTIL.trace
1180: ( 'l_primary_uom => '|| l_primary_uom, NULL
1181: , 9
1182: );
1183: INV_LOG_UTIL.trace
1184: ( 'l_purchasing_uom => '|| l_purchasing_uom, NULL
1185: , 9
1186: );
1187:

Line 1189: INV_LOG_UTIL.trace

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

Line 1221: INV_LOG_UTIL.trace

1217: l_total_cons_qty := NVL(l_conv_qty,0)*NVL(l_unit_price,0)+
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;

Line 1238: INV_LOG_UTIL.trace

1234: l_total_cons_qty := (l_total_cons_qty/NVL(p_rate,1));
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;

Line 1247: INV_LOG_UTIL.trace

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

Line 1296: INV_LOG_UTIL.trace

1292: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
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;

Line 1322: INV_LOG_UTIL.trace

1318: );
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;

Line 1337: INV_LOG_UTIL.trace

1333: );
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;

Line 1348: INV_LOG_UTIL.trace

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

Line 1362: INV_LOG_UTIL.trace

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

Line 1486: INV_LOG_UTIL.trace

1482: BEGIN
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;

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

1549: );
1550:
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: );

Line 1559: INV_LOG_UTIL.trace

1555: , 'INV_THIRD_PARTY_STOCK_PVT'
1556: , 9
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: );

Line 1649: INV_LOG_UTIL.trace

1645: IF l_primary_uom <> NVL(l_purchasing_uom,l_primary_uom)
1646: THEN
1647: IF (l_debug = 1)
1648: THEN
1649: INV_LOG_UTIL.trace
1650: ( 'l_primary_uom => '|| l_primary_uom, NULL
1651: , 9
1652: );
1653: INV_LOG_UTIL.trace

Line 1653: INV_LOG_UTIL.trace

1649: INV_LOG_UTIL.trace
1650: ( 'l_primary_uom => '|| l_primary_uom, NULL
1651: , 9
1652: );
1653: INV_LOG_UTIL.trace
1654: ( 'l_purchasing_uom => '|| l_purchasing_uom, NULL
1655: , 9
1656: );
1657: END IF;

Line 1757: INV_LOG_UTIL.trace

1753: );
1754: */
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: );

Line 1797: INV_LOG_UTIL.trace

1793: /* get break price API change updtake - Bug 5076263 - End */
1794:
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: );

Line 1856: INV_LOG_UTIL.trace

1852: -- x_non_recoverable_tax :=0;
1853:
1854: IF (l_debug = 1)
1855: THEN
1856: INV_LOG_UTIL.trace
1857: ( 'x_non_recoverable_tax is '||x_non_recoverable_tax
1858: , 9
1859: );
1860: END IF;

Line 1866: INV_LOG_UTIL.trace

1862: l_po_price := l_po_price + NVL(x_non_recoverable_tax,0);
1863:
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: );

Line 1881: INV_LOG_UTIL.trace

1877: l_po_price := l_po_price * l_uom_rate;
1878:
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: );

Line 1887: INV_LOG_UTIL.trace

1883: , 'INV_THIRD_PARTY_STOCK_PVT'
1884: , 9
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: );

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

1971: END IF;
1972:
1973: IF (l_debug = 1)
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

Line 2003: INV_LOG_UTIL.trace

1999: l_ccode_flag := 'Y';
2000:
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: );

Line 2026: INV_LOG_UTIL.trace

2022: );
2023:
2024: IF (l_debug = 1)
2025: THEN
2026: INV_LOG_UTIL.trace
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

Line 2065: INV_LOG_UTIL.trace

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

Line 2246: INV_LOG_UTIL.trace

2242: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
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;

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

2404: x_variance_account_id := l_variance_account_id;
2405:
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: );

Line 2445: INV_LOG_UTIL.trace

2441: g_error_code := 'INV_CONS_SUP_GEN_ACCT' ;
2442:
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: );

Line 2550: INV_LOG_UTIL.trace('Call from TM >>',

2546: g_po_header_id := NULL ;
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;

Line 2552: INV_LOG_UTIL.trace('g_calling_action => '||g_calling_action ,9 );

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

Line 2553: INV_LOG_UTIL.trace('g_error_code => '|| g_error_code,9);

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:
2556:
2557: IF (p_transaction_source_type_id=13) AND (p_transaction_action_id = 6)

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 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 2645: INV_LOG_UTIL.trace('g_calling_action => '|| g_calling_action ,9);

2641:
2642: -- Call to insert to consumptions table.
2643: IF (l_debug = 1)
2644: THEN
2645: INV_LOG_UTIL.trace('g_calling_action => '|| g_calling_action ,9);
2646: END IF;
2647:
2648: IF g_calling_action IS NULL OR
2649: g_calling_action <> 'D'

Line 2653: INV_LOG_UTIL.trace('Record_Consumption' ,

2649: g_calling_action <> 'D'
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

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 2689: INV_LOG_UTIL.trace('Populate_Cost_Dtl',

2685:
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.

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

2725: -- Reset_OU_Context;
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;

Line 2747: INV_LOG_UTIL.trace

2743: , p_data => x_msg_data
2744: );
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: );

Line 2765: INV_LOG_UTIL.trace

2761: , p_data => x_msg_data
2762: );
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: );

Line 2770: 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 ',
2772: 'INV_THIRD_PARTY_STOCK_PVT'
2773: , 9
2774: );

Line 2850: INV_LOG_UTIL.trace

2846:
2847: BEGIN
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: );

Line 2855: 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'
2857: , 9
2858: );
2859: END IF;

Line 2876: INV_LOG_UTIL.trace

2872: -- Call the original API that was released in 11.5.9
2873:
2874: IF (l_debug = 1)
2875: THEN
2876: INV_LOG_UTIL.trace
2877: ( 'Calling main Process_Financial_Info ' ,
2878: 'from Overloaded API '
2879: , 9
2880: );

Line 2916: INV_LOG_UTIL.trace

2912: x_primary_UOM := g_primary_uom ;
2913:
2914: IF (l_debug = 1)
2915: THEN
2916: INV_LOG_UTIL.trace
2917: ( '<< Out of main Process_Financial_Info '|| x_return_status ,
2918: 'from Overloaded API '
2919: , 9
2920: );

Line 2921: INV_LOG_UTIL.trace

2917: ( '<< Out of main Process_Financial_Info '|| x_return_status ,
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'

Line 2924: INV_LOG_UTIL.trace

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);
2927:
2928: INV_LOG_UTIL.trace

Line 2928: INV_LOG_UTIL.trace

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'
2930: , 9);
2931: INV_LOG_UTIL.trace
2932: ( 'x_primary_UOM=> ' || x_primary_UOM ,'INV_THIRD_PARTY_STOCK_PVT'

Line 2931: INV_LOG_UTIL.trace

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);
2934: INV_LOG_UTIL.trace
2935: ( 'x_po_header_id=> ' || x_po_header_id ,'INV_THIRD_PARTY_STOCK_PVT'

Line 2934: INV_LOG_UTIL.trace

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);
2937: END IF;
2938:

Line 2953: INV_LOG_UTIL.trace

2949: END IF;
2950:
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: );

Line 2958: 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'
2960: , 9);
2961: INV_LOG_UTIL.trace
2962: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'

Line 2961: INV_LOG_UTIL.trace

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);
2964: END IF;
2965: g_po_header_id := NULL ;

Line 2980: INV_LOG_UTIL.trace

2976: );
2977:
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:

Line 2996: INV_LOG_UTIL.trace

2992: );
2993:
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:

Line 3012: INV_LOG_UTIL.trace

3008: , p_data => x_msg_data
3009: );
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: