DBA Data[Home] [Help]

APPS.OE_DEFAULT_LINE dependencies on OE_SYS_PARAMETERS

Line 379: ('ORG',OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));

375: FND_MESSAGE.Set_TOKEN('ITEM', nvl(g_line_rec.ordered_item,g_line_rec.inventory_item_id));
376: END IF;
377: -- FND_MESSAGE.Set_TOKEN('ITEM', g_line_rec.ordered_item); Replaced with the above IF for 1722670
378: FND_MESSAGE.Set_TOKEN
379: ('ORG',OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
380: -- oe_organization_id is drpped,
381: -- hence need to call OE_SYS_PARAMETERS.Value('MASTER_ORGANIZATION_ID');
382:
383: OE_Msg_Pub.Add;

Line 381: -- hence need to call OE_SYS_PARAMETERS.Value('MASTER_ORGANIZATION_ID');

377: -- FND_MESSAGE.Set_TOKEN('ITEM', g_line_rec.ordered_item); Replaced with the above IF for 1722670
378: FND_MESSAGE.Set_TOKEN
379: ('ORG',OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
380: -- oe_organization_id is drpped,
381: -- hence need to call OE_SYS_PARAMETERS.Value('MASTER_ORGANIZATION_ID');
382:
383: OE_Msg_Pub.Add;
384:
385: IF l_debug_level > 0 THEN

Line 641: OE_Sys_Parameters.Value('MASTER_ORGANIZATION_ID');

637: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
638: l_blanket_number NUMBER;
639: --
640: l_item_validation_org NUMBER :=
641: OE_Sys_Parameters.Value('MASTER_ORGANIZATION_ID');
642: BEGIN
643:
644: IF p_request_date IS NOT NULL AND
645: p_request_date <> FND_API.G_MISS_DATE THEN

Line 2062: If( OE_Sys_Parameters.VALUE('OM_DEF_SUBSCRIPTION_BEHAVIOUR',p_line_rec.org_id) = 'SUB')

2058: -- sol_ord_er #16014165
2059: If(OE_ORDER_CACHE.g_item_rec.contract_item_type_code = OE_GLOBALS.G_ITEM_SUBSCRIPTION)
2060: THEN
2061: /* If System Parameter is set to default behaviour of subscription Item as Service */
2062: If( OE_Sys_Parameters.VALUE('OM_DEF_SUBSCRIPTION_BEHAVIOUR',p_line_rec.org_id) = 'SUB')
2063: AND p_line_rec.subscription_enable_flag <> 'N' THEN
2064: g_line_rec.subscription_enable_flag := 'Y';
2065: IF l_debug_level > 0 THEN
2066: oe_debug_pub.add('SK OEXDLINB.pls SUBSCRIPTION1 Y');

Line 3008: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');

3004: SELECT decode(msi.lot_control_code,2,'Y','N')
3005: FROM mtl_system_items msi
3006: WHERE msi.inventory_item_id = l_inventory_item_id
3007: AND msi.organization_id =
3008: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3009:
3010: TYPE line_tbl_type IS TABLE OF NUMBER
3011: INDEX BY BINARY_INTEGER;
3012: l_line_tbl line_tbl_type;

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

3642: -- p_x_line_rec.ordered_quantity := l_ref_line_rec.ordered_quantity; -- bug# 6617423
3643: -- bug# 6617423 : Start ---------
3644: oe_debug_pub.add( ' p_x_line_rec.org_id = '||p_x_line_rec.org_id ,5);
3645: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
3646: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
3647: ELSE
3648: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
3649: END IF;
3650: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis ,5 ) ;

Line 3648: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);

3644: oe_debug_pub.add( ' p_x_line_rec.org_id = '||p_x_line_rec.org_id ,5);
3645: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
3646: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
3647: ELSE
3648: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
3649: END IF;
3650: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis ,5 ) ;
3651: oe_debug_pub.add( ' l_ref_line_rec.invoiced_quantity = '|| l_ref_line_rec.invoiced_quantity ,5 ) ;
3652: oe_debug_pub.add( ' l_ref_line_rec.ordered_quantity = '|| l_ref_line_rec.ordered_quantity,5 ) ;

Line 3985: and organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');

3981: select decode(revision_qty_control_code, 2, 'Y', 'N')
3982: into l_revision_controlled
3983: from mtl_system_items
3984: where inventory_item_id = p_x_line_rec.inventory_item_id
3985: and organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3986: Exception
3987: When NO_DATA_FOUND Then
3988: l_revision_controlled := 'N';
3989: End;

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

4183: /*
4184: -- bug# 6617423 : start
4185: oe_debug_pub.add( ' p_x_line_rec.org_id = '|| p_x_line_rec.org_id , 5 ) ;
4186: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
4187: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
4188: ELSE
4189: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
4190: END IF;
4191: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis ,5) ;

Line 4189: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);

4185: oe_debug_pub.add( ' p_x_line_rec.org_id = '|| p_x_line_rec.org_id , 5 ) ;
4186: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
4187: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
4188: ELSE
4189: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
4190: END IF;
4191: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis ,5) ;
4192:
4193: IF l_overship_invoice_basis = 'SHIPPED' then