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_LINE_UTIL dependencies on OE_SYS_PARAMETERS

Line 665: l_credithold_cust VARCHAR2(10) := NVL(OE_SYS_PARAMETERS.value('ONT_CREDITHOLD_TYPE'),'S') ;

661:
662: -- ER#3667551 start
663: l_new_tbl_entry varchar2(10) := '';
664: l_bill_to_cust_id NUMBER := 0;
665: l_credithold_cust VARCHAR2(10) := NVL(OE_SYS_PARAMETERS.value('ONT_CREDITHOLD_TYPE'),'S') ;
666: -- ER#3667551 end
667: -- 14078867 start
668: l_old_itemcat NUMBER:= 0;
669: l_new_itemcat NUMBER:= 0;

Line 2380: IF ('Y' =OE_SYS_PARAMETERS.VALUE('OE_CC_CANCEL_PARAM')) THEN

2376: oe_debug_pub.add('OEXULINB: Tolerance is enabled!') ;
2377: ELSE
2378: --ER 12363706 end
2379: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := FALSE;
2380: IF ('Y' =OE_SYS_PARAMETERS.VALUE('OE_CC_CANCEL_PARAM')) THEN
2381: l_verify_payment_flag := 'Y';
2382: ELSE
2383: l_verify_payment_flag := 'N';
2384: END IF;

Line 3235: p_organization_id => OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'),

3231:
3232: Inv_Decimals_PUB.Validate_Quantity
3233: (
3234: p_item_id => p_x_line_rec.inventory_item_id,
3235: p_organization_id => OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'),
3236: p_input_quantity => l_temp_shipped_quantity,
3237: p_uom_code => p_x_line_rec.order_quantity_uom,
3238: x_output_quantity => l_validated_quantity,
3239: x_primary_quantity => l_primary_quantity,

Line 4171: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') )

4167: AND item_type_code = 'INCLUDED'
4168: AND exists (select null from mtl_system_items mtl where
4169: mtl.inventory_item_id = l.inventory_item_id and
4170: mtl.serviceable_product_flag = 'Y' and
4171: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') )
4172: AND ROWNUM = 1;
4173:
4174: EXCEPTION
4175: WHEN OTHERS THEN

Line 4279: and mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')

4275: select distinct 'Y'
4276: into l_serviceable_item
4277: from mtl_system_items mtl
4278: where mtl.inventory_item_id = p_x_line_rec.inventory_item_id
4279: and mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
4280: and mtl.serviceable_product_flag='Y';
4281: -- lchen added check for organizations to fix bug 2039304
4282:
4283: EXCEPTION

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

4811:
4812: IF l_debug_level > 0 then
4813: oe_debug_pub.add('operation:'||p_x_line_rec.operation||' booked_flag:'||p_x_line_rec.booked_flag||' new contingency_id: '||p_x_line_rec.contingency_id ||' old contingency_id: '||p_old_line_rec.contingency_id);
4814: END IF;
4815: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'Y'
4816: AND (NVL( p_x_line_rec.booked_flag, 'N') = 'N' OR
4817: p_x_line_rec.operation=OE_GLOBALS.G_OPR_CREATE)
4818: AND l_def_contingency_attributes = FND_API.G_TRUE
4819: AND p_x_line_rec.inventory_item_id IS NOT NULL

Line 6022: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',p_x_line_rec.org_id), 'N') = 'Y') THEN

6018: p_requesting_entity_id => p_x_line_rec.line_id,
6019: p_request_type => OE_GLOBALS.g_tax_line,
6020: x_return_status => l_return_status);
6021: -- 14151216, Added IF for System Parameter check
6022: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',p_x_line_rec.org_id), 'N') = 'Y') THEN
6023: -- Bug 13777599 start
6024: if l_debug_level > 0 then
6025: oe_debug_pub.add(' OEXULINB 1 Tax Header Delayed Req');
6026: End IF;

Line 6048: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',p_x_line_rec.org_id), 'N') = 'Y') THEN

6044: p_request_type => OE_GLOBALS.g_tax_line,
6045: p_param1 => l_param1,
6046: x_return_status => l_return_status);
6047: -- 14151216, Added IF for System Parameter check
6048: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',p_x_line_rec.org_id), 'N') = 'Y') THEN
6049: -- Bug 13777599 start
6050: if l_debug_level > 0 then
6051: oe_debug_pub.add(' OEXULINB 2 Tax Header Delayed Req');
6052: End IF;

Line 14213: l_organization_id NUMBER := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');

14209: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
14210: IS
14211: l_customer_number VARCHAR2(30);
14212: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
14213: l_organization_id NUMBER := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
14214:
14215: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14216: BEGIN
14217:

Line 17026: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);

17022: */
17023:
17024: oe_debug_pub.add( ' p_line_rec.org_id = '|| p_line_rec.org_id, 5 ) ;
17025: IF p_line_rec.org_id = FND_API.G_MISS_NUM THEN ---no need to handle null, automatically handled
17026: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
17027: ELSE
17028: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_line_rec.org_id);
17029: END IF;
17030: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis , 5 ) ;

Line 17028: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_line_rec.org_id);

17024: oe_debug_pub.add( ' p_line_rec.org_id = '|| p_line_rec.org_id, 5 ) ;
17025: IF p_line_rec.org_id = FND_API.G_MISS_NUM THEN ---no need to handle null, automatically handled
17026: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
17027: ELSE
17028: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_line_rec.org_id);
17029: END IF;
17030: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis , 5 ) ;
17031: oe_debug_pub.add( ' p_line_rec.reference_line_id = '|| p_line_rec.reference_line_id , 5) ;
17032:

Line 17142: , Z_Organization_Id => nvl(p_x_line_rec.ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'))

17138: INV_CUSTOMER_ITEM_GRP.CI_Attribute_Value(
17139: Z_Customer_Item_Id => p_x_line_rec.ordered_item_id
17140: , Z_Customer_Id => p_x_line_rec.sold_to_org_id
17141: , Z_Address_Id => l_address_id
17142: , Z_Organization_Id => nvl(p_x_line_rec.ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'))
17143: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
17144: , Z_Inventory_Item_Id => p_x_line_rec.inventory_item_id
17145: , Attribute_Name => 'INVENTORY_ITEM_ID'
17146: , Error_Code => l_error_code

Line 17159: , Z_Organization_Id => nvl(p_x_line_rec.ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'))

17155: INV_CUSTOMER_ITEM_GRP.CI_Attribute_Value(
17156: Z_Customer_Item_Id => p_x_line_rec.ordered_item_id
17157: , Z_Customer_Id => p_x_line_rec.sold_to_org_id
17158: , Z_Address_Id => l_address_id
17159: , Z_Organization_Id => nvl(p_x_line_rec.ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'))
17160: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
17161: , Z_Inventory_Item_Id => p_x_line_rec.inventory_item_id
17162: , Attribute_Name => 'INVENTORY_ITEM_ID'
17163: , Error_Code => l_error_code

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

17627: END IF;
17628: /*sdatti*/
17629:
17630: --Customer Acceptance
17631: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'Y'
17632: AND p_x_line_rec.item_type_code= 'SERVICE' and p_x_line_rec.accepted_quantity is NULL THEN
17633: /*Default Parent acceptance details*/
17634: OE_ACCEPTANCE_UTIL.Default_Parent_Accept_Details(p_x_line_rec);
17635: END IF;

Line 18614: l_promise_date_flag := OE_SYS_PARAMETERS.value('PROMISE_DATE_FLAG');

18610: -- Promise Date setup with Request date
18611: -- 'FR' - With First Request date
18612: -- 'R' -- For all change in Request date
18613: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
18614: l_promise_date_flag := OE_SYS_PARAMETERS.value('PROMISE_DATE_FLAG');
18615:
18616: IF l_promise_date_flag = 'FR'
18617: AND (p_old_line_rec.request_date = FND_API.G_MISS_DATE
18618: OR p_old_line_rec.request_date IS NULL) THEN

Line 18655: l_audit_trail_enabled VARCHAR2(1) := OE_SYS_PARAMETERS.VALUE('AUDIT_TRAIL_ENABLE_FLAG');

18651: IS
18652:
18653: l_ind NUMBER;
18654: l_code_level varchar2(6) := OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL;
18655: l_audit_trail_enabled VARCHAR2(1) := OE_SYS_PARAMETERS.VALUE('AUDIT_TRAIL_ENABLE_FLAG');
18656:
18657: l_return_status VARCHAR2(30);
18658: l_reason_code VARCHAR2(30);
18659: l_reason_comments VARCHAR2(2000);