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

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

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

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

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

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

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

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

2885: SELECT decode(msi.lot_control_code,2,'Y','N')
2886: FROM mtl_system_items msi
2887: WHERE msi.inventory_item_id = l_inventory_item_id
2888: AND msi.organization_id =
2889: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
2890:
2891: TYPE line_tbl_type IS TABLE OF NUMBER
2892: INDEX BY BINARY_INTEGER;
2893: l_line_tbl line_tbl_type;

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

3523: -- p_x_line_rec.ordered_quantity := l_ref_line_rec.ordered_quantity; -- bug# 6617423
3524: -- bug# 6617423 : Start ---------
3525: oe_debug_pub.add( ' p_x_line_rec.org_id = '||p_x_line_rec.org_id ,5);
3526: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
3527: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
3528: ELSE
3529: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
3530: END IF;
3531: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis ,5 ) ;

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

3525: oe_debug_pub.add( ' p_x_line_rec.org_id = '||p_x_line_rec.org_id ,5);
3526: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
3527: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
3528: ELSE
3529: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
3530: END IF;
3531: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis ,5 ) ;
3532: oe_debug_pub.add( ' l_ref_line_rec.invoiced_quantity = '|| l_ref_line_rec.invoiced_quantity ,5 ) ;
3533: oe_debug_pub.add( ' l_ref_line_rec.ordered_quantity = '|| l_ref_line_rec.ordered_quantity,5 ) ;

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

3854: select decode(revision_qty_control_code, 2, 'Y', 'N')
3855: into l_revision_controlled
3856: from mtl_system_items
3857: where inventory_item_id = p_x_line_rec.inventory_item_id
3858: and organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3859: Exception
3860: When NO_DATA_FOUND Then
3861: l_revision_controlled := 'N';
3862: End;

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

4051:
4052: -- bug# 6617423 : start
4053: oe_debug_pub.add( ' p_x_line_rec.org_id = '|| p_x_line_rec.org_id , 5 ) ;
4054: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
4055: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
4056: ELSE
4057: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
4058: END IF;
4059: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis ,5) ;

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

4053: oe_debug_pub.add( ' p_x_line_rec.org_id = '|| p_x_line_rec.org_id , 5 ) ;
4054: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
4055: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
4056: ELSE
4057: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
4058: END IF;
4059: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis ,5) ;
4060:
4061: IF l_overship_invoice_basis = 'SHIPPED' then