DBA Data[Home] [Help]

APPS.OE_CONFIG_PVT dependencies on OE_CONFIG_PVT

Line 1: PACKAGE BODY Oe_Config_Pvt AS

1: PACKAGE BODY Oe_Config_Pvt AS
2: /* $Header: OEXVCFGB.pls 120.16.12020000.2 2012/07/03 10:18:55 amallik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='oe_config_pvt';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='oe_config_pvt';

1: PACKAGE BODY Oe_Config_Pvt AS
2: /* $Header: OEXVCFGB.pls 120.16.12020000.2 2012/07/03 10:18:55 amallik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='oe_config_pvt';
5:
6:
7: /*--------------------------------------------------------------------
8: forward declarations

Line 308: oe_config_pvt.Call_Process_Order

304: ELSE
305: l_control_rec.process := FALSE;
306: END IF;
307:
308: oe_config_pvt.Call_Process_Order
309: ( p_line_tbl => l_line_tbl
310: ,p_class_line_tbl => l_class_line_tbl
311: ,p_control_rec => l_control_rec
312: ,p_ui_flag => p_ui_flag

Line 1901: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'Y';

1897: p_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
1898:
1899: -- change made for bug 2350478
1900: IF p_ui_flag = 'Y' THEN
1901: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'Y';
1902: END IF;
1903:
1904: --OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'Y';
1905: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'N';

Line 1905: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'N';

1901: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'Y';
1902: END IF;
1903:
1904: --OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'Y';
1905: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'N';
1906:
1907: IF p_ui_flag = 'Y' THEN
1908: OE_CONFIG_UTIL.G_CONFIG_UI_USED := 'Y';
1909: END IF;

Line 1924: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y';

1920: Print_Time('call to lines end time');
1921:
1922: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
1923: --OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'N';
1924: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y';
1925: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'N';
1926: OE_CONFIG_UTIL.G_CONFIG_UI_USED := 'N';
1927:
1928: fnd_profile.put('OE_CALCULATE_TAX_IN_OM', 'Y');

Line 1925: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'N';

1921:
1922: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
1923: --OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'N';
1924: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y';
1925: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'N';
1926: OE_CONFIG_UTIL.G_CONFIG_UI_USED := 'N';
1927:
1928: fnd_profile.put('OE_CALCULATE_TAX_IN_OM', 'Y');
1929:

Line 2070: oe_config_pvt.Change_Columns

2066: IF l_debug_level > 0 THEN
2067: oe_debug_pub.add('CALLING CHANGE COLUMNS' , 2 ) ;
2068: END IF;
2069:
2070: oe_config_pvt.Change_Columns
2071: (p_top_model_line_id => p_top_model_line_id,
2072: p_config_hdr_id => p_config_hdr_id,
2073: p_config_rev_nbr => p_config_rev_nbr,
2074: p_ui_flag => p_ui_flag);

Line 2530: oe_debug_pub.add('LEAVING CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;

2526:
2527: END IF;
2528:
2529: IF l_debug_level > 0 THEN
2530: oe_debug_pub.add('LEAVING CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;
2531: END IF;
2532:
2533: EXCEPTION
2534: WHEN FND_API.G_EXC_ERROR THEN

Line 2536: oe_debug_pub.add('EXC ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;

2532:
2533: EXCEPTION
2534: WHEN FND_API.G_EXC_ERROR THEN
2535: IF l_debug_level > 0 THEN
2536: oe_debug_pub.add('EXC ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;
2537: END IF;
2538: RAISE FND_API.G_EXC_ERROR;
2539:
2540: WHEN OTHERS THEN

Line 2542: oe_debug_pub.add('ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;

2538: RAISE FND_API.G_EXC_ERROR;
2539:
2540: WHEN OTHERS THEN
2541: IF l_debug_level > 0 THEN
2542: oe_debug_pub.add('ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;
2543: END IF;
2544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2545: END Change_Columns;
2546:

Line 3428: oe_debug_pub.add('ENTERING DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;

3424: --
3425: BEGIN
3426:
3427: IF l_debug_level > 0 THEN
3428: oe_debug_pub.add('ENTERING DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3429: END IF;
3430:
3431: IF p_config_hdr_id is not null AND
3432: p_config_rev_nbr is not null THEN

Line 3451: oe_debug_pub.add('ERROR IN DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;

3447:
3448: IF l_return_value <> 1 THEN
3449: OE_Msg_Pub.Add_Text(l_error_message);
3450: IF l_debug_level > 0 THEN
3451: oe_debug_pub.add('ERROR IN DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3452: END IF;
3453: x_return_status := FND_API.G_RET_STS_ERROR;
3454: ELSE
3455: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3464: oe_debug_pub.add('LEAVING DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;

3460: END IF;
3461: END IF;
3462:
3463: IF l_debug_level > 0 THEN
3464: oe_debug_pub.add('LEAVING DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3465: END IF;
3466:
3467: EXCEPTION
3468: when others then

Line 3470: oe_debug_pub.add('ERROR IN DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;

3466:
3467: EXCEPTION
3468: when others then
3469: IF l_debug_level > 0 THEN
3470: oe_debug_pub.add('ERROR IN DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3471: END IF;
3472:
3473:
3474: END Delete_Config;

Line 3708: oe_debug_pub.add('LEAVING COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;

3704: END IF;
3705: x_return_status := FND_API.G_RET_STS_SUCCESS;
3706:
3707: IF l_debug_level > 0 THEN
3708: oe_debug_pub.add('LEAVING COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3709: END IF;
3710:
3711: EXCEPTION
3712: WHEN OTHERS THEN

Line 3714: oe_debug_pub.add('ERROR IN COPY_CONFIG,OE_CONFIG_PVT'|| sqlerrm ,1);

3710:
3711: EXCEPTION
3712: WHEN OTHERS THEN
3713: IF l_debug_level > 0 THEN
3714: oe_debug_pub.add('ERROR IN COPY_CONFIG,OE_CONFIG_PVT'|| sqlerrm ,1);
3715: END IF;
3716:
3717: RAISE;
3718: END Copy_Config;

Line 3768: oe_debug_pub.add('OE_CONFIG_PVT , BEFORE CHECK_HOLDS ON MODEL' , 1 ) ;

3764: FROM oe_order_lines
3765: WHERE line_id = p_line_id;
3766:
3767: IF l_debug_level > 0 THEN
3768: oe_debug_pub.add('OE_CONFIG_PVT , BEFORE CHECK_HOLDS ON MODEL' , 1 ) ;
3769: END IF;
3770:
3771: OE_HOLDS_PUB.CHECK_HOLDS
3772: ( p_api_version => 1.0,

Line 3808: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;

3804: x_msg_data => x_msg_data );
3805:
3806: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3807: IF l_debug_level > 0 THEN
3808: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;
3809: END IF;
3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3811: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3812: IF l_debug_level > 0 THEN

Line 3813: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;

3809: END IF;
3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3811: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3812: IF l_debug_level > 0 THEN
3813: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;
3814: END IF;
3815: RAISE FND_API.G_EXC_ERROR;
3816: END IF;
3817:

Line 3839: oe_debug_pub.add('OE_CONFIG_PVT,BEFORE RELEASE_HOLDS ON MODEL',1);

3835: l_release_reason_code := 'CZ_AUTOMATIC';
3836: l_release_comment := 'Configuration is now valid';
3837:
3838: IF l_debug_level > 0 THEN
3839: oe_debug_pub.add('OE_CONFIG_PVT,BEFORE RELEASE_HOLDS ON MODEL',1);
3840: END IF;
3841:
3842: OE_Holds_pub.release_holds
3843: ( p_order_tbl => l_holds_tbl,

Line 3853: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN RELEASING HOLD',1);

3849: x_msg_data => x_msg_data );
3850:
3851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3852: IF l_debug_level > 0 THEN
3853: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN RELEASING HOLD',1);
3854: END IF;
3855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3856: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3857: IF l_debug_level > 0 THEN

Line 3858: oe_debug_pub.add('OE_CONFIG_PVT ,ERROR IN RELEASING HOLD' ,1);

3854: END IF;
3855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3856: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3857: IF l_debug_level > 0 THEN
3858: oe_debug_pub.add('OE_CONFIG_PVT ,ERROR IN RELEASING HOLD' ,1);
3859: END IF;
3860: RAISE FND_API.G_EXC_ERROR;
3861: END IF;
3862:

Line 3875: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;

3871:
3872: ELSE -- ret status error
3873: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3874: IF l_debug_level > 0 THEN
3875: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;
3876: END IF;
3877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3878:
3879: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3881: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;

3877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3878:
3879: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3880: IF l_debug_level > 0 THEN
3881: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;
3882: END IF;
3883: RAISE FND_API.G_EXC_ERROR;
3884: END IF;
3885: END IF; -- check holds ret status check.

Line 3893: ('ERROR IN PUT_HOLD_AND_RELEASE_HOLD IN OE_CONFIG_PVT' , 1 ) ;

3889: EXCEPTION
3890: when others then
3891: IF l_debug_level > 0 THEN
3892: oe_debug_pub.add
3893: ('ERROR IN PUT_HOLD_AND_RELEASE_HOLD IN OE_CONFIG_PVT' , 1 ) ;
3894: END IF;
3895:
3896: END put_hold_and_release_hold;
3897:

Line 4232: oe_config_pvt.Call_Process_Order

4228: END LOOP;
4229:
4230: l_control_rec.process := FALSE;
4231:
4232: oe_config_pvt.Call_Process_Order
4233: ( p_line_tbl => l_line_tbl
4234: ,p_control_rec => l_control_rec
4235: ,x_return_status => l_return_status);
4236:

Line 4433: oe_debug_pub.add('ENTERING COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;

4429: --
4430: BEGIN
4431:
4432: IF l_debug_level > 0 THEN
4433: oe_debug_pub.add('ENTERING COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
4434: END IF;
4435:
4436: IF p_config_hdr_id is not null AND
4437: p_config_rev_nbr is not null THEN

Line 4477: oe_debug_pub.add('LEAVING COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;

4473:
4474: END IF;
4475:
4476: IF l_debug_level > 0 THEN
4477: oe_debug_pub.add('LEAVING COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
4478: END IF;
4479:
4480: EXCEPTION
4481: when others then

Line 4483: oe_debug_pub.add('ERROR IN COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;

4479:
4480: EXCEPTION
4481: when others then
4482: IF l_debug_level > 0 THEN
4483: oe_debug_pub.add('ERROR IN COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
4484: END IF;
4485:
4486: END Copy_Config1;
4487:

Line 4610: END Oe_Config_Pvt;

4606: END IF;
4607: END Print_Time;
4608:
4609:
4610: END Oe_Config_Pvt;