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 453: l_master_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);

449: END IF;
450: -- End 4172500
451:
452: --bug5336639
453: l_master_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
454:
455: BEGIN
456: SELECT INVOICEABLE_ITEM_FLAG, INVOICE_ENABLED_FLAG
457: INTO l_invoiceable_item_flag, l_invoice_enabled_flag

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

510: INTO l_serviceable_product_flag
511: FROM oe_order_lines_all ol, mtl_system_items msi
512: WHERE ol.line_id = l_service_reference_line_id
513: AND ol.inventory_item_id = msi.inventory_item_id
514: AND msi.organization_id = nvl(ol.ship_from_org_id, oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ol.org_id));
515: EXCEPTION
516: WHEN NO_DATA_FOUND THEN
517: IF l_debug_level > 0 THEN
518: oe_debug_pub.add( 'IN NO DATA FOUND WHEN TRYING TO GET SERVICEABLE PRODUCT FLAG' ,5);

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

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

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

1085: PROCEDURE Get_Item_Description
1086: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1087: , x_item_description OUT NOCOPY VARCHAR2
1088: ) IS
1089: l_organization_id NUMBER := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
1090: --
1091: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1092: --
1093: l_item_description VARCHAR2(240) := null ;

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

1184: l_ordered_item VARCHAR2(2000);
1185: l_org_id NUMBER;
1186: /*Bug3261460-end*/
1187:
1188: l_organization_id NUMBER := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
1189: --
1190: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1191: --
1192: BEGIN

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

1240: l_item_identifier_type := NULL;
1241: l_inventory_item_id := NULL;
1242: l_organization_id := NULL;
1243: END;
1244: l_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);
1245: oe_debug_pub.add('Executed the first sql',1);
1246: BEGIN -- added for bug 4237123
1247: IF nvl(l_item_identifier_type,'INT') = 'INT' THEN -- Bug #3684306
1248: oe_debug_pub.add('Item identifier type is INT',1);

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

1369: END IF;
1370: END IF;
1371: END IF;
1372: IF l_overship_invoice_basis IS NULL THEN
1373: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_line_rec.org_id); --moac
1374: IF l_debug_level > 0 THEN
1375: oe_debug_pub.add( 'OVERSHIP_INVOICE_BASIS ( 3 ) : '||L_OVERSHIP_INVOICE_BASIS , 5 ) ;
1376: END IF;
1377: END IF;

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

1419: oe_debug_pub.add( 'INVOICE_SOURCE IS ( 1 ) : '||L_INVOICE_SOURCE , 5 ) ;
1420: END IF;
1421: RETURN l_invoice_source;
1422: ELSE
1423: l_invoice_source := oe_sys_parameters.value('OE_NON_DELIVERY_INVOICE_SOURCE',p_line_rec.org_id); --moac
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'INVOICE_SOURCE IS ( 2 ) : '||L_INVOICE_SOURCE , 5 ) ;
1426: END IF;
1427: RETURN l_invoice_source;

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

1445: oe_debug_pub.add( 'INVOICE SOURCE IS ( 3 ) : '||L_INVOICE_SOURCE , 5 ) ;
1446: END IF;
1447: RETURN l_invoice_source;
1448: ELSE
1449: l_invoice_source := oe_sys_parameters.value('OE_INVOICE_SOURCE',p_line_rec.org_id); --moac
1450: IF l_debug_level > 0 THEN
1451: oe_debug_pub.add( 'INVOICE_SOURCE IS ( 4 ) : '||L_INVOICE_SOURCE , 5 ) ;
1452: END IF;
1453: RETURN l_invoice_source;

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

1543: IF l_debug_level > 0 THEN
1544: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM ORDER TYPE : '||L_CUST_TRX_TYPE_ID , 5 ) ;
1545: END IF;
1546: IF l_cust_trx_type_id = 0 THEN
1547: SELECT NVL(oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID',p_line_rec.org_id), 0) --moac
1548: INTO l_cust_trx_type_id
1549: FROM DUAL;
1550: IF l_debug_level > 0 THEN
1551: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM PROFILE : '||L_CUST_TRX_TYPE_ID , 5 ) ;

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

1562: END IF;
1563: -- Get from reference line (Ignore l_creation_sign value here)
1564: Return_Credit_Info(p_line_rec, l_cust_trx_type_id, l_creation_sign);
1565: IF l_cust_trx_type_id = 0 THEN -- no cust_trx_type_id at line/order type
1566: SELECT OE_SYS_PARAMETERS.Value('OE_CREDIT_TRANSACTION_TYPE_ID',p_line_rec.org_id) --moac
1567: INTO l_cust_trx_type_id
1568: FROM DUAL;
1569: IF l_debug_level > 0 THEN
1570: oe_debug_pub.add( ' CUSTOMER TRANSACTION TYPE ID FROM PROFILE ' , 5 ) ;

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

1623: oe_debug_pub.add( 'CREDIT MEMO TYPE FROM LINE TYPE/ORDER TYPE OF CURRENT LINE'||L_CUST_TRX_TYPE_ID , 5 ) ;
1624: END IF;
1625: END IF;
1626: IF l_inv_cust_trx_type_id = 0 OR l_cust_trx_type_id = 0 THEN
1627: SELECT NVL(oe_sys_parameters.value('OE_CREDIT_TRANSACTION_TYPE_ID',p_line_rec.org_id), 0) --moac
1628: INTO l_cust_trx_type_id
1629: FROM DUAL;
1630: IF l_debug_level > 0 THEN
1631: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM PROFILE' , 5 ) ;

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

4077: IF l_debug_level > 0 THEN
4078: oe_debug_pub.add( 'INTERFACING SALES CREDITS FOR FREIGHT' , 5 ) ;
4079: END IF;
4080: --moac
4081: l_cr_srep_for_freight := NVL(OE_SYS_PARAMETERS.value('WSH_CR_SREP_FOR_FREIGHT',p_line_rec.org_id), 'N');
4082: -- If the profile option 'OM: Credit Salesperson for Freight on Sales'
4083: -- is set to 'Yes' then interface header/line sales credits otherwise
4084: -- insert dummy sales credits.
4085: IF l_cr_srep_for_freight = 'Y' THEN

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

4328: IF l_debug_level > 0 THEN
4329: oe_debug_pub.add( 'ENTER INTERFACE_CONTINGENCIES ( ) PROCEDURE ' , 5 ) ;
4330: END IF;
4331:
4332: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'N' THEN
4333: IF l_debug_level > 0 THEN
4334: oe_debug_pub.add( 'Acceptance not enabled, Not interfacing Contingency details');
4335: END IF;
4336: -- Do not interface acceptance details

Line 4406: IF (oe_sys_parameters.value('OE_DISCOUNT_DETAILS_ON_INVOICE',p_line_rec.org_id) = 'Y' AND p_adjustments_tbl.COUNT > 0) THEN --moac

4402: oe_debug_pub.add( 'p_adjustments_tbl.COUNT:'||p_adjustments_tbl.COUNT);
4403: END IF;
4404:
4405: -- 3685479 Replaced call to show_detail_discounts by the foll IF
4406: IF (oe_sys_parameters.value('OE_DISCOUNT_DETAILS_ON_INVOICE',p_line_rec.org_id) = 'Y' AND p_adjustments_tbl.COUNT > 0) THEN --moac
4407: -- get line total when the profile is off
4408: Rounded_Amount(p_currency_code => p_interface_line_rec.currency_code
4409: ,p_unrounded_amount => (p_line_rec.unit_selling_price * p_interface_line_rec.quantity)
4410: ,x_rounded_amount => l_line_tot_amount);

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

4914: p_x_charges_rec.INTERFACE_LINE_ATTRIBUTE12 := lpad('0', 30); -- shipment number
4915: p_x_charges_rec.INTERFACE_LINE_ATTRIBUTE13 := lpad('0', 30); -- option number
4916: p_x_charges_rec.INTERFACE_LINE_ATTRIBUTE14 := lpad('0', 30); -- service number
4917: -- l_vat_flag := NVL(FND_PROFILE.VALUE('AR_ALLOW_TAX_CODE_OVERRIDE'), 'N');
4918: l_freight_as_line := NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',p_line_rec.org_id), 'N'); --moac
4919: IF l_debug_level > 0 THEN
4920: oe_debug_pub.add( 'INVOICE FREIGHT AS REVENUE '||L_FREIGHT_AS_LINE ) ;
4921: END IF;
4922: l_freight_item := oe_sys_parameters.value('OE_INVENTORY_ITEM_FOR_FREIGHT',p_line_rec.org_id); --moac

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

4918: l_freight_as_line := NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',p_line_rec.org_id), 'N'); --moac
4919: IF l_debug_level > 0 THEN
4920: oe_debug_pub.add( 'INVOICE FREIGHT AS REVENUE '||L_FREIGHT_AS_LINE ) ;
4921: END IF;
4922: l_freight_item := oe_sys_parameters.value('OE_INVENTORY_ITEM_FOR_FREIGHT',p_line_rec.org_id); --moac
4923: /* VAT on freight
4924: if vat_flag = 'Y'
4925: if freight_as_line = 'Y'
4926: if freight_item is NULL

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

4949: INTO p_x_charges_rec.Description
4950: ,p_x_charges_rec.Uom_Code
4951: FROM mtl_system_items
4952: WHERE inventory_item_id = l_freight_item
4953: AND organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
4954: ELSE
4955: SELECT meaning
4956: ,NULL
4957: INTO p_x_charges_rec.Description

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

6142: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE12 := lpad(to_char(nvl(p_line_rec.Shipment_Number,0)),30);
6143: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE13 := lpad(to_char(nvl(p_line_rec.Option_Number,0)),30);
6144: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE14 := lpad(to_char(nvl(p_line_rec.Service_Number,0)),30);
6145: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE15 := NULL;
6146: p_x_interface_line_rec.SET_OF_BOOKS_ID := oe_sys_parameters.value('SET_OF_BOOKS_ID', p_line_rec.org_id);
6147: p_x_interface_line_rec.LINE_TYPE := 'LINE';
6148: p_x_interface_line_rec.WAREHOUSE_ID := p_line_rec.ship_from_org_id;
6149:
6150: /* If the Line is of OTA type, then we need to call an OTA API to get the */

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

6766: INTO l_territory_code
6767: FROM ar_system_parameters asp
6768: WHERE nvl(asp.org_id, -3114) = nvl(p_line_rec.org_id, -3114);
6769: ELSE
6770: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(p_line_rec.org_id);
6771: l_territory_code := l_AR_Sys_Param_Rec.default_territory;
6772: END IF;
6773:
6774: -- Get territory information into p_x_interface_line_rec

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

8291: END IF;
8292:
8293: -- 3685479 Replacing show detail dis by the following IF
8294: -- Adjustments need not be queried here as it is anyway going to be queried in interface_detail_discounts
8295: IF (oe_sys_parameters.value('OE_DISCOUNT_DETAILS_ON_INVOICE',p_line_rec.org_id) = 'Y') THEN --moac
8296: IF l_debug_level > 0 THEN
8297: oe_debug_pub.add( 'INSERTING DISCOUNT DETAILS' , 5 ) ;
8298: END IF;
8299: Interface_Detail_Discounts(p_line_rec, p_x_interface_line_rec

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

8636: -- 7231974
8637:
8638:
8639: --Customer Acceptance
8640: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'Y' AND
8641: OE_ACCEPTANCE_UTIL.Pre_billing_acceptance_on(l_line_rec)
8642: AND OE_ACCEPTANCE_UTIL.Acceptance_Status(l_line_rec) = 'NOT_ACCEPTED' THEN
8643: IF l_debug_level > 0 THEN
8644: oe_debug_pub.add('top_model_line_id:'||l_line_rec.top_model_line_id);