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.OE_INVOICE_PUB dependencies on OE_SYS_PARAMETERS

Line 659: l_master_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);

655: END IF;
656: -- End 4172500
657:
658: --bug5336639
659: l_master_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
660:
661: BEGIN
662: SELECT INVOICEABLE_ITEM_FLAG, INVOICE_ENABLED_FLAG
663: INTO l_invoiceable_item_flag, l_invoice_enabled_flag

Line 720: AND msi.organization_id = nvl(ol.ship_from_org_id, oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ol.org_id));

716: INTO l_serviceable_product_flag
717: FROM oe_order_lines_all ol, mtl_system_items msi
718: WHERE ol.line_id = l_service_reference_line_id
719: AND ol.inventory_item_id = msi.inventory_item_id
720: AND msi.organization_id = nvl(ol.ship_from_org_id, oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ol.org_id));
721: EXCEPTION
722: WHEN NO_DATA_FOUND THEN
723: IF l_debug_level > 0 THEN
724: oe_debug_pub.add( 'IN NO DATA FOUND WHEN TRYING TO GET SERVICEABLE PRODUCT FLAG' ,5);

Line 933: IF (oe_sys_parameters.value('OE_DISCOUNT_DETAILS_ON_INVOICE',p_line_rec.org_id) = 'Y') THEN --moac

929: -- Eventhough the discounts are not actually inserted into oe_price_adj table,
930: -- Selling price is adjusted to discounted price)
931: -- To avoid this look at adj table to see if there are any adjustments
932: -- IF p_line_rec.unit_list_price <> p_line_rec.unit_selling_price AND
933: IF (oe_sys_parameters.value('OE_DISCOUNT_DETAILS_ON_INVOICE',p_line_rec.org_id) = 'Y') THEN --moac
934: -- 3661895 The IF will be true only for return retrobilled RMA, all others will go through else
935: -- RT{
936: IF (p_line_rec.line_category_code = 'RETURN'
937: and p_line_rec.reference_line_id IS NOT NULL

Line 1304: -- bug#12645586, l_organization_id NUMBER := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);

1300: PROCEDURE Get_Item_Description
1301: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1302: , x_item_description OUT NOCOPY VARCHAR2
1303: ) IS
1304: -- bug#12645586, l_organization_id NUMBER := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
1305: l_organization_id NUMBER := nvl(p_line_rec.ship_from_org_id,
1306: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id)); -- Added for bug#12645586
1307: --
1308: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1306: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id)); -- Added for bug#12645586

1302: , x_item_description OUT NOCOPY VARCHAR2
1303: ) IS
1304: -- bug#12645586, l_organization_id NUMBER := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
1305: l_organization_id NUMBER := nvl(p_line_rec.ship_from_org_id,
1306: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id)); -- Added for bug#12645586
1307: --
1308: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1309: --
1310: l_item_description VARCHAR2(240) := null ;

Line 1405: l_organization_id NUMBER := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);

1401: l_ordered_item VARCHAR2(2000);
1402: l_org_id NUMBER;
1403: /*Bug3261460-end*/
1404:
1405: l_organization_id NUMBER := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
1406: --
1407: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1408: --
1409: BEGIN

Line 1461: l_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);

1457: l_item_identifier_type := NULL;
1458: l_inventory_item_id := NULL;
1459: l_organization_id := NULL;
1460: END;
1461: l_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);
1462: oe_debug_pub.add('Executed the first sql',1);
1463: BEGIN -- added for bug 4237123
1464: IF nvl(l_item_identifier_type,'INT') = 'INT' THEN -- Bug #3684306
1465: oe_debug_pub.add('Item identifier type is INT',1);

Line 1590: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_line_rec.org_id); --moac

1586: END IF;
1587: END IF;
1588: END IF;
1589: IF l_overship_invoice_basis IS NULL THEN
1590: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_line_rec.org_id); --moac
1591: IF l_debug_level > 0 THEN
1592: oe_debug_pub.add( 'OVERSHIP_INVOICE_BASIS ( 3 ) : '||L_OVERSHIP_INVOICE_BASIS , 5 ) ;
1593: END IF;
1594: END IF;

Line 1640: l_invoice_source := oe_sys_parameters.value('OE_NON_DELIVERY_INVOICE_SOURCE',p_line_rec.org_id); --moac

1636: oe_debug_pub.add( 'INVOICE_SOURCE IS ( 1 ) : '||L_INVOICE_SOURCE , 5 ) ;
1637: END IF;
1638: RETURN l_invoice_source;
1639: ELSE
1640: l_invoice_source := oe_sys_parameters.value('OE_NON_DELIVERY_INVOICE_SOURCE',p_line_rec.org_id); --moac
1641: IF l_debug_level > 0 THEN
1642: oe_debug_pub.add( 'INVOICE_SOURCE IS ( 2 ) : '||L_INVOICE_SOURCE , 5 ) ;
1643: END IF;
1644: RETURN l_invoice_source;

Line 1666: l_invoice_source := oe_sys_parameters.value('OE_INVOICE_SOURCE',p_line_rec.org_id); --moac

1662: oe_debug_pub.add( 'INVOICE SOURCE IS ( 3 ) : '||L_INVOICE_SOURCE , 5 ) ;
1663: END IF;
1664: RETURN l_invoice_source;
1665: ELSE
1666: l_invoice_source := oe_sys_parameters.value('OE_INVOICE_SOURCE',p_line_rec.org_id); --moac
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add( 'INVOICE_SOURCE IS ( 4 ) : '||L_INVOICE_SOURCE , 5 ) ;
1669: END IF;
1670: RETURN l_invoice_source;

Line 1764: SELECT NVL(oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID',p_line_rec.org_id), 0) --moac

1760: IF l_debug_level > 0 THEN
1761: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM ORDER TYPE : '||L_CUST_TRX_TYPE_ID , 5 ) ;
1762: END IF;
1763: IF l_cust_trx_type_id = 0 THEN
1764: SELECT NVL(oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID',p_line_rec.org_id), 0) --moac
1765: INTO l_cust_trx_type_id
1766: FROM DUAL;
1767: IF l_debug_level > 0 THEN
1768: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM PROFILE : '||L_CUST_TRX_TYPE_ID , 5 ) ;

Line 1783: SELECT OE_SYS_PARAMETERS.Value('OE_CREDIT_TRANSACTION_TYPE_ID',p_line_rec.org_id) --moac

1779: END IF;
1780: -- Get from reference line (Ignore l_creation_sign value here)
1781: Return_Credit_Info(p_line_rec, l_cust_trx_type_id, l_creation_sign);
1782: IF l_cust_trx_type_id = 0 THEN -- no cust_trx_type_id at line/order type
1783: SELECT OE_SYS_PARAMETERS.Value('OE_CREDIT_TRANSACTION_TYPE_ID',p_line_rec.org_id) --moac
1784: INTO l_cust_trx_type_id
1785: FROM DUAL;
1786: IF l_debug_level > 0 THEN
1787: oe_debug_pub.add( ' CUSTOMER TRANSACTION TYPE ID FROM PROFILE ' , 5 ) ;

Line 1844: SELECT NVL(oe_sys_parameters.value('OE_CREDIT_TRANSACTION_TYPE_ID',p_line_rec.org_id), 0) --moac

1840: oe_debug_pub.add( 'CREDIT MEMO TYPE FROM LINE TYPE/ORDER TYPE OF CURRENT LINE'||L_CUST_TRX_TYPE_ID , 5 ) ;
1841: END IF;
1842: END IF;
1843: IF l_inv_cust_trx_type_id = 0 OR l_cust_trx_type_id = 0 THEN
1844: SELECT NVL(oe_sys_parameters.value('OE_CREDIT_TRANSACTION_TYPE_ID',p_line_rec.org_id), 0) --moac
1845: INTO l_cust_trx_type_id
1846: FROM DUAL;
1847: IF l_debug_level > 0 THEN
1848: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM PROFILE' , 5 ) ;

Line 4310: l_cr_srep_for_freight := NVL(OE_SYS_PARAMETERS.value('WSH_CR_SREP_FOR_FREIGHT',p_line_rec.org_id), 'N');

4306: IF l_debug_level > 0 THEN
4307: oe_debug_pub.add( 'INTERFACING SALES CREDITS FOR FREIGHT' , 5 ) ;
4308: END IF;
4309: --moac
4310: l_cr_srep_for_freight := NVL(OE_SYS_PARAMETERS.value('WSH_CR_SREP_FOR_FREIGHT',p_line_rec.org_id), 'N');
4311: -- If the profile option 'OM: Credit Salesperson for Freight on Sales'
4312: -- is set to 'Yes' then interface header/line sales credits otherwise
4313: -- insert dummy sales credits.
4314: IF l_cr_srep_for_freight = 'Y' THEN

Line 4561: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'N' THEN

4557: IF l_debug_level > 0 THEN
4558: oe_debug_pub.add( 'ENTER INTERFACE_CONTINGENCIES ( ) PROCEDURE ' , 5 ) ;
4559: END IF;
4560:
4561: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'N' THEN
4562: IF l_debug_level > 0 THEN
4563: oe_debug_pub.add( 'Acceptance not enabled, Not interfacing Contingency details');
4564: END IF;
4565: -- Do not interface acceptance details

Line 4635: IF (oe_sys_parameters.value('OE_DISCOUNT_DETAILS_ON_INVOICE',p_line_rec.org_id) = 'Y'

4631: oe_debug_pub.add( 'p_adjustments_tbl.COUNT:'||p_adjustments_tbl.COUNT);
4632: END IF;
4633:
4634: -- 3685479 Replaced call to show_detail_discounts by the foll IF
4635: IF (oe_sys_parameters.value('OE_DISCOUNT_DETAILS_ON_INVOICE',p_line_rec.org_id) = 'Y'
4636: AND p_adjustments_tbl.COUNT > 0
4637: AND NVL(p_line_rec.service_bill_option_code,'FBOM') <> 'FPOM') THEN --moac -- sol_ord_er #16014165
4638: -- get line total when the profile is off
4639: Rounded_Amount(p_currency_code => p_interface_line_rec.currency_code

Line 5149: l_freight_as_line := NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',p_line_rec.org_id), 'N'); --moac

5145: p_x_charges_rec.INTERFACE_LINE_ATTRIBUTE12 := lpad('0', 30); -- shipment number
5146: p_x_charges_rec.INTERFACE_LINE_ATTRIBUTE13 := lpad('0', 30); -- option number
5147: p_x_charges_rec.INTERFACE_LINE_ATTRIBUTE14 := lpad('0', 30); -- service number
5148: -- l_vat_flag := NVL(FND_PROFILE.VALUE('AR_ALLOW_TAX_CODE_OVERRIDE'), 'N');
5149: l_freight_as_line := NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',p_line_rec.org_id), 'N'); --moac
5150: IF l_debug_level > 0 THEN
5151: oe_debug_pub.add( 'INVOICE FREIGHT AS REVENUE '||L_FREIGHT_AS_LINE ) ;
5152: END IF;
5153: l_freight_item := oe_sys_parameters.value('OE_INVENTORY_ITEM_FOR_FREIGHT',p_line_rec.org_id); --moac

Line 5153: l_freight_item := oe_sys_parameters.value('OE_INVENTORY_ITEM_FOR_FREIGHT',p_line_rec.org_id); --moac

5149: l_freight_as_line := NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',p_line_rec.org_id), 'N'); --moac
5150: IF l_debug_level > 0 THEN
5151: oe_debug_pub.add( 'INVOICE FREIGHT AS REVENUE '||L_FREIGHT_AS_LINE ) ;
5152: END IF;
5153: l_freight_item := oe_sys_parameters.value('OE_INVENTORY_ITEM_FOR_FREIGHT',p_line_rec.org_id); --moac
5154: /* VAT on freight
5155: if vat_flag = 'Y'
5156: if freight_as_line = 'Y'
5157: if freight_item is NULL

Line 5184: AND organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);

5180: INTO p_x_charges_rec.Description
5181: ,p_x_charges_rec.Uom_Code
5182: FROM mtl_system_items
5183: WHERE inventory_item_id = l_freight_item
5184: AND organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
5185: ELSE
5186: SELECT meaning
5187: ,NULL
5188: INTO p_x_charges_rec.Description

Line 6404: p_x_interface_line_rec.SET_OF_BOOKS_ID := oe_sys_parameters.value('SET_OF_BOOKS_ID', p_line_rec.org_id);

6400: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE12 := lpad(to_char(nvl(p_line_rec.Shipment_Number,0)),30);
6401: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE13 := lpad(to_char(nvl(p_line_rec.Option_Number,0)),30);
6402: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE14 := lpad(to_char(nvl(p_line_rec.Service_Number,0)),30);
6403: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE15 := NULL;
6404: p_x_interface_line_rec.SET_OF_BOOKS_ID := oe_sys_parameters.value('SET_OF_BOOKS_ID', p_line_rec.org_id);
6405: p_x_interface_line_rec.LINE_TYPE := 'LINE';
6406: p_x_interface_line_rec.WAREHOUSE_ID := p_line_rec.ship_from_org_id;
6407:
6408: /* If the Line is of OTA type, then we need to call an OTA API to get the */

Line 7055: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(p_line_rec.org_id);

7051: INTO l_territory_code
7052: FROM ar_system_parameters asp
7053: WHERE nvl(asp.org_id, -3114) = nvl(p_line_rec.org_id, -3114);
7054: ELSE
7055: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(p_line_rec.org_id);
7056: l_territory_code := l_AR_Sys_Param_Rec.default_territory;
7057: END IF;
7058:
7059: -- Get territory information into p_x_interface_line_rec

Line 8699: IF (oe_sys_parameters.value('OE_DISCOUNT_DETAILS_ON_INVOICE',p_line_rec.org_id) = 'Y'

8695: END IF;
8696:
8697: -- 3685479 Replacing show detail dis by the following IF
8698: -- Adjustments need not be queried here as it is anyway going to be queried in interface_detail_discounts
8699: IF (oe_sys_parameters.value('OE_DISCOUNT_DETAILS_ON_INVOICE',p_line_rec.org_id) = 'Y'
8700: AND NVL(p_line_rec.service_bill_option_code,'FBOM') = 'FBOM') THEN --moac --sol_ord_er #16014165
8701: IF l_debug_level > 0 THEN
8702: oe_debug_pub.add( 'INSERTING DISCOUNT DETAILS' , 5 ) ;
8703: END IF;

Line 9180: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'Y' AND

9176: --9040537 Update_Credit_Invoice(p_line_rec => l_line_rec,p_header_rec => l_header_rec); --8319535
9177:
9178:
9179: --Customer Acceptance
9180: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'Y' AND
9181: OE_ACCEPTANCE_UTIL.Pre_billing_acceptance_on(l_line_rec)
9182: AND OE_ACCEPTANCE_UTIL.Acceptance_Status(l_line_rec) = 'NOT_ACCEPTED' THEN
9183: IF l_debug_level > 0 THEN
9184: oe_debug_pub.add('top_model_line_id:'||l_line_rec.top_model_line_id);