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.13.12010000.2 2008/09/16 04:30:33 spothula 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.13.12010000.2 2008/09/16 04:30:33 spothula 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 1866: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'Y';

1862: p_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
1863:
1864: -- change made for bug 2350478
1865: IF p_ui_flag = 'Y' THEN
1866: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'Y';
1867: END IF;
1868:
1869: --OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'Y';
1870: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'N';

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

1866: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'Y';
1867: END IF;
1868:
1869: --OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'Y';
1870: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'N';
1871:
1872: IF p_ui_flag = 'Y' THEN
1873: OE_CONFIG_UTIL.G_CONFIG_UI_USED := 'Y';
1874: END IF;

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

1885: Print_Time('call to lines end time');
1886:
1887: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
1888: --OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'N';
1889: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y';
1890: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'N';
1891: OE_CONFIG_UTIL.G_CONFIG_UI_USED := 'N';
1892:
1893: fnd_profile.put('OE_CALCULATE_TAX_IN_OM', 'Y');

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

1886:
1887: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
1888: --OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'N';
1889: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y';
1890: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'N';
1891: OE_CONFIG_UTIL.G_CONFIG_UI_USED := 'N';
1892:
1893: fnd_profile.put('OE_CALCULATE_TAX_IN_OM', 'Y');
1894:

Line 2035: oe_config_pvt.Change_Columns

2031: IF l_debug_level > 0 THEN
2032: oe_debug_pub.add('CALLING CHANGE COLUMNS' , 2 ) ;
2033: END IF;
2034:
2035: oe_config_pvt.Change_Columns
2036: (p_top_model_line_id => p_top_model_line_id,
2037: p_config_hdr_id => p_config_hdr_id,
2038: p_config_rev_nbr => p_config_rev_nbr,
2039: p_ui_flag => p_ui_flag);

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

2423:
2424: END IF;
2425:
2426: IF l_debug_level > 0 THEN
2427: oe_debug_pub.add('LEAVING CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;
2428: END IF;
2429:
2430: EXCEPTION
2431: WHEN FND_API.G_EXC_ERROR THEN

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

2429:
2430: EXCEPTION
2431: WHEN FND_API.G_EXC_ERROR THEN
2432: IF l_debug_level > 0 THEN
2433: oe_debug_pub.add('EXC ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;
2434: END IF;
2435: RAISE FND_API.G_EXC_ERROR;
2436:
2437: WHEN OTHERS THEN

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

2435: RAISE FND_API.G_EXC_ERROR;
2436:
2437: WHEN OTHERS THEN
2438: IF l_debug_level > 0 THEN
2439: oe_debug_pub.add('ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT' , 1 ) ;
2440: END IF;
2441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2442: END Change_Columns;
2443:

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

2994: --
2995: BEGIN
2996:
2997: IF l_debug_level > 0 THEN
2998: oe_debug_pub.add('ENTERING DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
2999: END IF;
3000:
3001: IF p_config_hdr_id is not null AND
3002: p_config_rev_nbr is not null THEN

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

3017:
3018: IF l_return_value <> 1 THEN
3019: OE_Msg_Pub.Add_Text(l_error_message);
3020: IF l_debug_level > 0 THEN
3021: oe_debug_pub.add('ERROR IN DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3022: END IF;
3023: x_return_status := FND_API.G_RET_STS_ERROR;
3024: ELSE
3025: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3030: END IF;
3031: END IF;
3032:
3033: IF l_debug_level > 0 THEN
3034: oe_debug_pub.add('LEAVING DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3035: END IF;
3036:
3037: EXCEPTION
3038: when others then

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

3036:
3037: EXCEPTION
3038: when others then
3039: IF l_debug_level > 0 THEN
3040: oe_debug_pub.add('ERROR IN DELETE_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3041: END IF;
3042:
3043:
3044: END Delete_Config;

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

3272: END IF;
3273: x_return_status := FND_API.G_RET_STS_SUCCESS;
3274:
3275: IF l_debug_level > 0 THEN
3276: oe_debug_pub.add('LEAVING COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
3277: END IF;
3278:
3279: EXCEPTION
3280: WHEN OTHERS THEN

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

3278:
3279: EXCEPTION
3280: WHEN OTHERS THEN
3281: IF l_debug_level > 0 THEN
3282: oe_debug_pub.add('ERROR IN COPY_CONFIG,OE_CONFIG_PVT'|| sqlerrm ,1);
3283: END IF;
3284:
3285: RAISE;
3286: END Copy_Config;

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

3332: FROM oe_order_lines
3333: WHERE line_id = p_line_id;
3334:
3335: IF l_debug_level > 0 THEN
3336: oe_debug_pub.add('OE_CONFIG_PVT , BEFORE CHECK_HOLDS ON MODEL' , 1 ) ;
3337: END IF;
3338:
3339: OE_HOLDS_PUB.CHECK_HOLDS
3340: ( p_api_version => 1.0,

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

3372: x_msg_data => x_msg_data );
3373:
3374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3375: IF l_debug_level > 0 THEN
3376: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;
3377: END IF;
3378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3380: IF l_debug_level > 0 THEN

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

3377: END IF;
3378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3380: IF l_debug_level > 0 THEN
3381: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN PUT HOLD' , 1 ) ;
3382: END IF;
3383: RAISE FND_API.G_EXC_ERROR;
3384: END IF;
3385:

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

3403: l_release_reason_code := 'CZ_AUTOMATIC';
3404: l_release_comment := 'Configuration is now valid';
3405:
3406: IF l_debug_level > 0 THEN
3407: oe_debug_pub.add('OE_CONFIG_PVT,BEFORE RELEASE_HOLDS ON MODEL',1);
3408: END IF;
3409:
3410: OE_Holds_pub.release_holds
3411: ( p_order_tbl => l_holds_tbl,

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

3417: x_msg_data => x_msg_data );
3418:
3419: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3420: IF l_debug_level > 0 THEN
3421: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN RELEASING HOLD',1);
3422: END IF;
3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3424: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3425: IF l_debug_level > 0 THEN

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

3422: END IF;
3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3424: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3425: IF l_debug_level > 0 THEN
3426: oe_debug_pub.add('OE_CONFIG_PVT ,ERROR IN RELEASING HOLD' ,1);
3427: END IF;
3428: RAISE FND_API.G_EXC_ERROR;
3429: END IF;
3430:

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

3439:
3440: ELSE -- ret status error
3441: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3442: IF l_debug_level > 0 THEN
3443: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;
3444: END IF;
3445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3446:
3447: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

3445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3446:
3447: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3448: IF l_debug_level > 0 THEN
3449: oe_debug_pub.add('OE_CONFIG_PVT , ERROR IN CHECK HOLD' , 1 ) ;
3450: END IF;
3451: RAISE FND_API.G_EXC_ERROR;
3452: END IF;
3453: END IF; -- check holds ret status check.

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

3457: EXCEPTION
3458: when others then
3459: IF l_debug_level > 0 THEN
3460: oe_debug_pub.add
3461: ('ERROR IN PUT_HOLD_AND_RELEASE_HOLD IN OE_CONFIG_PVT' , 1 ) ;
3462: END IF;
3463:
3464: END put_hold_and_release_hold;
3465:

Line 3800: oe_config_pvt.Call_Process_Order

3796: END LOOP;
3797:
3798: l_control_rec.process := FALSE;
3799:
3800: oe_config_pvt.Call_Process_Order
3801: ( p_line_tbl => l_line_tbl
3802: ,p_control_rec => l_control_rec
3803: ,x_return_status => l_return_status);
3804:

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

3997: --
3998: BEGIN
3999:
4000: IF l_debug_level > 0 THEN
4001: oe_debug_pub.add('ENTERING COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
4002: END IF;
4003:
4004: IF p_config_hdr_id is not null AND
4005: p_config_rev_nbr is not null THEN

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

4041:
4042: END IF;
4043:
4044: IF l_debug_level > 0 THEN
4045: oe_debug_pub.add('LEAVING COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
4046: END IF;
4047:
4048: EXCEPTION
4049: when others then

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

4047:
4048: EXCEPTION
4049: when others then
4050: IF l_debug_level > 0 THEN
4051: oe_debug_pub.add('ERROR IN COPY_CONFIG IN OE_CONFIG_PVT' , 1 ) ;
4052: END IF;
4053:
4054: END Copy_Config1;
4055:

Line 4178: END Oe_Config_Pvt;

4174: END IF;
4175: END Print_Time;
4176:
4177:
4178: END Oe_Config_Pvt;