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_LOG_UTIL

Line 123: INV_LOG_UTIL.trace

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

Line 211: INV_LOG_UTIL.trace

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

Line 252: INV_LOG_UTIL.trace

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

Line 282: INV_LOG_UTIL.trace

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

Line 329: INV_LOG_UTIL.trace

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

Line 363: INV_LOG_UTIL.trace

359: WHERE fc.currency_code = p_from_currency;
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;

Line 394: INV_LOG_UTIL.trace

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

Line 404: INV_LOG_UTIL.trace

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

Line 527: INV_LOG_UTIL.trace

523: BEGIN
524:
525: IF (l_debug = 1)
526: THEN
527: INV_LOG_UTIL.trace
528: ( 'Entering Into calculate tax '
529: , 9
530: );
531: END IF;

Line 543: INV_LOG_UTIL.trace

539: WHERE application_short_name = 'PO';
540:
541: IF (l_debug = 1)
542: THEN
543: INV_LOG_UTIL.trace
544: ( 'l_application_id => ' || l_application_id
545: , 9
546: );
547: END IF;

Line 550: INV_LOG_UTIL.trace

546: );
547: END IF;
548: IF (l_debug = 1)
549: THEN
550: INV_LOG_UTIL.trace
551: ( 'l_ship_to_location_id => '|| l_ship_to_location_id
552: , 9
553: );
554: END IF;

Line 615: INV_LOG_UTIL.trace

611:
612:
613: IF (l_debug = 1)
614: THEN
615: INV_LOG_UTIL.trace
616: ( 'l_vendor_party_id => ' || l_vendor_party_id
617: , 9
618: );
619: INV_LOG_UTIL.trace

Line 619: INV_LOG_UTIL.trace

615: INV_LOG_UTIL.trace
616: ( 'l_vendor_party_id => ' || l_vendor_party_id
617: , 9
618: );
619: INV_LOG_UTIL.trace
620: ( 'l_vendor_site_party_id => '|| l_vendor_site_party_id
621: , 9
622: );
623: INV_LOG_UTIL.trace

Line 623: INV_LOG_UTIL.trace

619: INV_LOG_UTIL.trace
620: ( 'l_vendor_site_party_id => '|| l_vendor_site_party_id
621: , 9
622: );
623: INV_LOG_UTIL.trace
624: ( 'rajesh p_header_id => '|| p_header_id
625: , 9
626: );
627: INV_LOG_UTIL.trace

Line 627: INV_LOG_UTIL.trace

623: INV_LOG_UTIL.trace
624: ( 'rajesh p_header_id => '|| p_header_id
625: , 9
626: );
627: INV_LOG_UTIL.trace
628: ( 'icx_session_id = > '|| FND_GLOBAL.session_id
629: , 9
630: );
631: INV_LOG_UTIL.trace

Line 631: INV_LOG_UTIL.trace

627: INV_LOG_UTIL.trace
628: ( 'icx_session_id = > '|| FND_GLOBAL.session_id
629: , 9
630: );
631: INV_LOG_UTIL.trace
632: ( 'p_global_flag => '|| p_global_flag
633: , 9
634: );
635: INV_LOG_UTIL.trace

Line 635: INV_LOG_UTIL.trace

631: INV_LOG_UTIL.trace
632: ( 'p_global_flag => '|| p_global_flag
633: , 9
634: );
635: INV_LOG_UTIL.trace
636: ( '*** Start inserting into GT tables '
637: , 9
638: );
639:

Line 640: INV_LOG_UTIL.trace

636: ( '*** Start inserting into GT tables '
637: , 9
638: );
639:
640: INV_LOG_UTIL.trace
641: ( 'l_event_type_code => '|| l_event_type_code
642: , 9
643: );
644: INV_LOG_UTIL.trace

Line 644: INV_LOG_UTIL.trace

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

Line 648: INV_LOG_UTIL.trace

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

Line 652: INV_LOG_UTIL.trace

648: INV_LOG_UTIL.trace
649: ( 'l_event_class_code => ' || l_event_class_code
650: , 9
651: );
652: INV_LOG_UTIL.trace
653: ( 'l_vendor_org_id => '|| l_vendor_org_id
654: , 9
655: );
656: INV_LOG_UTIL.trace

Line 656: INV_LOG_UTIL.trace

652: INV_LOG_UTIL.trace
653: ( 'l_vendor_org_id => '|| l_vendor_org_id
654: , 9
655: );
656: INV_LOG_UTIL.trace
657: ( 'l_legal_entity_id => ' || l_legal_entity_id
658: , 9
659: );
660: INV_LOG_UTIL.trace

Line 660: INV_LOG_UTIL.trace

656: INV_LOG_UTIL.trace
657: ( 'l_legal_entity_id => ' || l_legal_entity_id
658: , 9
659: );
660: INV_LOG_UTIL.trace
661: ( 'l_set_of_books_id => '|| l_set_of_books_id
662: , 9
663: );
664: END IF;

Line 680: INV_LOG_UTIL.trace

676: WHERE NVL(org_id,-99) = NVL(p_org_id,-99);
677: END IF ;
678: /* bug 5081702 End*/
679:
680: INV_LOG_UTIL.trace
681: ( 'l_rate_type => '|| l_rate_type
682: , 9
683: );
684:

Line 687: INV_LOG_UTIL.trace

683: );
684:
685: --Rajesh start inserting GT
686:
687: INV_LOG_UTIL.trace
688: ( 'Etax: clearing existing records from GT '
689: , 9
690: );
691: /* 5084307 - Start */

Line 873: INV_LOG_UTIL.trace

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

Line 877: INV_LOG_UTIL.trace

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'
879: , 9
880: );
881:

Line 893: INV_LOG_UTIL.trace

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

Line 897: INV_LOG_UTIL.trace

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
899: , 9
900: );
901: INV_LOG_UTIL.trace

Line 901: INV_LOG_UTIL.trace

897: INV_LOG_UTIL.trace
898: ( 'l_msg_count => '|| l_msg_count
899: , 9
900: );
901: INV_LOG_UTIL.trace
902: ( 'l_msg_data => '|| l_msg_data
903: , 9
904: );
905:

Line 958: INV_LOG_UTIL.trace

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

Line 962: INV_LOG_UTIL.trace

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'
964: , 9
965: );
966: INV_LOG_UTIL.trace

Line 966: INV_LOG_UTIL.trace

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'
968: , 9
969: );
970: INV_LOG_UTIL.trace

Line 970: INV_LOG_UTIL.trace

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'
972: , 9
973: );
974: END IF;

Line 1021: INV_LOG_UTIL.trace

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

Line 1033: INV_LOG_UTIL.trace

1029: EXCEPTION
1030: WHEN NO_DATA_FOUND THEN
1031: IF (l_debug = 1)
1032: THEN
1033: INV_LOG_UTIL.trace
1034: ( 'NO_DATA_FOUND exception','INV Calculate_tax'
1035: , 9
1036: );
1037: END IF;

Line 1060: INV_LOG_UTIL.trace

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

Line 1139: INV_LOG_UTIL.trace

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

Line 1187: INV_LOG_UTIL.trace

1183: -- Convert the qty to purchasing UOM, the UOM's are different
1184:
1185: IF (l_debug = 1)
1186: THEN
1187: INV_LOG_UTIL.trace
1188: ( 'l_primary_uom => '|| l_primary_uom, NULL
1189: , 9
1190: );
1191: INV_LOG_UTIL.trace

Line 1191: INV_LOG_UTIL.trace

1187: INV_LOG_UTIL.trace
1188: ( 'l_primary_uom => '|| l_primary_uom, NULL
1189: , 9
1190: );
1191: INV_LOG_UTIL.trace
1192: ( 'l_purchasing_uom => '|| l_purchasing_uom, NULL
1193: , 9
1194: );
1195:

Line 1197: INV_LOG_UTIL.trace

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

Line 1229: INV_LOG_UTIL.trace

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

Line 1239: INV_LOG_UTIL.trace

1235: CLOSE cons_csr_type;
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;

Line 1288: INV_LOG_UTIL.trace

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

Line 1314: INV_LOG_UTIL.trace

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

Line 1327: INV_LOG_UTIL.trace

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

Line 1338: INV_LOG_UTIL.trace

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

Line 1352: INV_LOG_UTIL.trace

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

Line 1478: INV_LOG_UTIL.trace

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

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

1541: );
1542:
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: );

Line 1551: INV_LOG_UTIL.trace

1547: , 'INV_THIRD_PARTY_STOCK_PVT'
1548: , 9
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: );

Line 1644: INV_LOG_UTIL.trace

1640: IF l_primary_uom <> NVL(l_purchasing_uom,l_primary_uom)
1641: THEN
1642: IF (l_debug = 1)
1643: THEN
1644: INV_LOG_UTIL.trace
1645: ( 'l_primary_uom => '|| l_primary_uom, NULL
1646: , 9
1647: );
1648: INV_LOG_UTIL.trace

Line 1648: INV_LOG_UTIL.trace

1644: INV_LOG_UTIL.trace
1645: ( 'l_primary_uom => '|| l_primary_uom, NULL
1646: , 9
1647: );
1648: INV_LOG_UTIL.trace
1649: ( 'l_purchasing_uom => '|| l_purchasing_uom, NULL
1650: , 9
1651: );
1652: END IF;

Line 1752: INV_LOG_UTIL.trace

1748: );
1749: */
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: );

Line 1792: INV_LOG_UTIL.trace

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

Line 1851: INV_LOG_UTIL.trace

1847: -- x_non_recoverable_tax :=0;
1848:
1849: IF (l_debug = 1)
1850: THEN
1851: INV_LOG_UTIL.trace
1852: ( 'x_non_recoverable_tax is '||x_non_recoverable_tax
1853: , 9
1854: );
1855: END IF;

Line 1861: INV_LOG_UTIL.trace

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

Line 1876: INV_LOG_UTIL.trace

1872: l_po_price := l_po_price * l_uom_rate;
1873:
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: );

Line 1882: INV_LOG_UTIL.trace

1878: , 'INV_THIRD_PARTY_STOCK_PVT'
1879: , 9
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: );

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

1966: END IF;
1967:
1968: IF (l_debug = 1)
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

Line 1998: INV_LOG_UTIL.trace

1994: l_ccode_flag := 'Y';
1995:
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: );

Line 2031: INV_LOG_UTIL.trace

2027: );
2028:
2029: IF (l_debug = 1)
2030: THEN
2031: INV_LOG_UTIL.trace
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

Line 2070: INV_LOG_UTIL.trace

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

Line 2251: INV_LOG_UTIL.trace

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

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

2409: x_variance_account_id := l_variance_account_id;
2410:
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: );

Line 2450: INV_LOG_UTIL.trace

2446: g_error_code := 'INV_CONS_SUP_GEN_ACCT' ;
2447:
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: );

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

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

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

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

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

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

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

2651:
2652: -- Call to insert to consumptions table.
2653: IF (l_debug = 1)
2654: THEN
2655: INV_LOG_UTIL.trace('g_calling_action => '|| g_calling_action ,9);
2656: END IF;
2657:
2658: IF g_calling_action IS NULL OR
2659: g_calling_action <> 'D'

Line 2663: INV_LOG_UTIL.trace('Record_Consumption' ,

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

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

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

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

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

Line 2759: INV_LOG_UTIL.trace

2755: , p_data => x_msg_data
2756: );
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: );

Line 2777: INV_LOG_UTIL.trace

2773: , p_data => x_msg_data
2774: );
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: );

Line 2782: 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 ',
2784: 'INV_THIRD_PARTY_STOCK_PVT'
2785: , 9
2786: );

Line 2862: INV_LOG_UTIL.trace

2858:
2859: BEGIN
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: );

Line 2867: 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'
2869: , 9
2870: );
2871: END IF;

Line 2888: INV_LOG_UTIL.trace

2884: -- Call the original API that was released in 11.5.9
2885:
2886: IF (l_debug = 1)
2887: THEN
2888: INV_LOG_UTIL.trace
2889: ( 'Calling main Process_Financial_Info ' ,
2890: 'from Overloaded API '
2891: , 9
2892: );

Line 2928: INV_LOG_UTIL.trace

2924: x_primary_UOM := g_primary_uom ;
2925:
2926: IF (l_debug = 1)
2927: THEN
2928: INV_LOG_UTIL.trace
2929: ( '<< Out of main Process_Financial_Info '|| x_return_status ,
2930: 'from Overloaded API '
2931: , 9
2932: );

Line 2933: INV_LOG_UTIL.trace

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

Line 2936: INV_LOG_UTIL.trace

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);
2939:
2940: INV_LOG_UTIL.trace

Line 2940: INV_LOG_UTIL.trace

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'
2942: , 9);
2943: INV_LOG_UTIL.trace
2944: ( 'x_primary_UOM=> ' || x_primary_UOM ,'INV_THIRD_PARTY_STOCK_PVT'

Line 2943: INV_LOG_UTIL.trace

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

Line 2946: INV_LOG_UTIL.trace

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

Line 2965: INV_LOG_UTIL.trace

2961: END IF;
2962:
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: );

Line 2970: 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'
2972: , 9);
2973: INV_LOG_UTIL.trace
2974: ( 'x_error_code =>' || x_error_code ,'INV_THIRD_PARTY_STOCK_PVT'

Line 2973: INV_LOG_UTIL.trace

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

Line 2992: INV_LOG_UTIL.trace

2988: );
2989:
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:

Line 3008: INV_LOG_UTIL.trace

3004: );
3005:
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:

Line 3024: INV_LOG_UTIL.trace

3020: , p_data => x_msg_data
3021: );
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: