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.PJI_REP_UTIL dependencies on PA_DEBUG

Line 36: g_debug_mode VARCHAR2(1) := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

32: g_global_calendar_id NUMBER :=-99;
33: g_input_calendar_type VARCHAR2(1) :=' ';
34: g_input_calendar_id NUMBER := -99;
35:
36: g_debug_mode VARCHAR2(1) := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
37: g_proc NUMBER :=5;
38:
39: PROCEDURE Add_Message (p_app_short_name VARCHAR2
40: , p_msg_name VARCHAR2

Line 1825: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Slice_Name');

1821: l_end_date DATE;
1822: l_rec_count NUMBER;
1823: BEGIN
1824:
1825: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Slice_Name');
1826: IF g_debug_mode = 'Y' THEN
1827: Pa_Debug.write_file('Derive_Slice_Name: beginning',5);
1828: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: beginning', TRUE , g_proc);
1829: END IF;

Line 1827: Pa_Debug.write_file('Derive_Slice_Name: beginning',5);

1823: BEGIN
1824:
1825: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Slice_Name');
1826: IF g_debug_mode = 'Y' THEN
1827: Pa_Debug.write_file('Derive_Slice_Name: beginning',5);
1828: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: beginning', TRUE , g_proc);
1829: END IF;
1830:
1831: IF x_return_status IS NULL THEN

Line 1923: Pa_Debug.write_file('Derive_Slice_Name: returning',5);

1919: END IF;
1920:
1921: IF g_debug_mode = 'Y' THEN
1922: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: finishing', TRUE , g_proc);
1923: Pa_Debug.write_file('Derive_Slice_Name: returning',5);
1924: END IF;
1925: Pa_Debug.Reset_Err_Stack;
1926:
1927: EXCEPTION

Line 1925: Pa_Debug.Reset_Err_Stack;

1921: IF g_debug_mode = 'Y' THEN
1922: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: finishing', TRUE , g_proc);
1923: Pa_Debug.write_file('Derive_Slice_Name: returning',5);
1924: END IF;
1925: Pa_Debug.Reset_Err_Stack;
1926:
1927: EXCEPTION
1928: WHEN NO_DATA_FOUND THEN
1929: x_msg_count := x_msg_count + 1;

Line 2243: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Report_Date_Julian');

2239: l_msg_count NUMBER;
2240: l_msg_data VARCHAR2(2000);
2241: BEGIN
2242:
2243: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Report_Date_Julian');
2244: IF g_debug_mode = 'Y' THEN
2245: Pa_Debug.write_file('Get_Report_Date_Julian: begining',5);
2246: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: begining', TRUE , g_proc);
2247: END IF;

Line 2245: Pa_Debug.write_file('Get_Report_Date_Julian: begining',5);

2241: BEGIN
2242:
2243: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Report_Date_Julian');
2244: IF g_debug_mode = 'Y' THEN
2245: Pa_Debug.write_file('Get_Report_Date_Julian: begining',5);
2246: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: begining', TRUE , g_proc);
2247: END IF;
2248:
2249: -- IF (p_calendar_type <> g_input_calendar_type) OR (p_calendar_id <> g_input_calendar_id) THEN

Line 2263: Pa_Debug.write_file('Get_Report_Date_Julian: returning',5);

2259: RETURN g_report_date_julian;
2260:
2261: IF g_debug_mode = 'Y' THEN
2262: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: finishing', TRUE , g_proc);
2263: Pa_Debug.write_file('Get_Report_Date_Julian: returning',5);
2264: END IF;
2265: Pa_Debug.Reset_Err_Stack;
2266:
2267: EXCEPTION

Line 2265: Pa_Debug.Reset_Err_Stack;

2261: IF g_debug_mode = 'Y' THEN
2262: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: finishing', TRUE , g_proc);
2263: Pa_Debug.write_file('Get_Report_Date_Julian: returning',5);
2264: END IF;
2265: Pa_Debug.Reset_Err_Stack;
2266:
2267: EXCEPTION
2268: WHEN OTHERS THEN
2269: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Get_Report_Date_Julian');

Line 2283: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Period_Name');

2279: l_msg_count NUMBER;
2280: l_msg_data VARCHAR2(2000);
2281: BEGIN
2282:
2283: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Period_Name');
2284: IF g_debug_mode = 'Y' THEN
2285: Pa_Debug.write_file('Get_Period_Name: begining',5);
2286: -- Pji_Utils.WRITE2LOG( 'get_period_name: begining', TRUE , g_proc);
2287: END IF;

Line 2285: Pa_Debug.write_file('Get_Period_Name: begining',5);

2281: BEGIN
2282:
2283: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Period_Name');
2284: IF g_debug_mode = 'Y' THEN
2285: Pa_Debug.write_file('Get_Period_Name: begining',5);
2286: -- Pji_Utils.WRITE2LOG( 'get_period_name: begining', TRUE , g_proc);
2287: END IF;
2288:
2289: -- IF (p_calendar_type <> g_input_calendar_type) OR (p_calendar_id <> g_input_calendar_id) THEN

Line 2302: Pa_Debug.write_file('Get_Period_Name: returning',5);

2298: -- END IF;
2299:
2300: IF g_debug_mode = 'Y' THEN
2301: -- Pji_Utils.WRITE2LOG( 'get_period_name: returning', TRUE , g_proc);
2302: Pa_Debug.write_file('Get_Period_Name: returning',5);
2303: END IF;
2304: Pa_Debug.Reset_Err_Stack;
2305:
2306: RETURN g_period_name;

Line 2304: Pa_Debug.Reset_Err_Stack;

2300: IF g_debug_mode = 'Y' THEN
2301: -- Pji_Utils.WRITE2LOG( 'get_period_name: returning', TRUE , g_proc);
2302: Pa_Debug.write_file('Get_Period_Name: returning',5);
2303: END IF;
2304: Pa_Debug.Reset_Err_Stack;
2305:
2306: RETURN g_period_name;
2307:
2308: EXCEPTION

Line 2340: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Period_Julian');

2336: l_period_name VARCHAR2(100);
2337: l_gl_calendar_id NUMBER;
2338: l_pa_calendar_id NUMBER;
2339: BEGIN
2340: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Period_Julian');
2341: IF g_debug_mode = 'Y' THEN
2342: Pa_Debug.write_file('Derive_Period_Julian: begining',5);
2343: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: begining', TRUE , g_proc);
2344: END IF;

Line 2342: Pa_Debug.write_file('Derive_Period_Julian: begining',5);

2338: l_pa_calendar_id NUMBER;
2339: BEGIN
2340: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Period_Julian');
2341: IF g_debug_mode = 'Y' THEN
2342: Pa_Debug.write_file('Derive_Period_Julian: begining',5);
2343: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: begining', TRUE , g_proc);
2344: END IF;
2345:
2346: IF p_calendar_type = 'E' THEN

Line 2546: Pa_Debug.write_file('Derive_Period_Julian: returning',5);

2542:
2543:
2544: IF g_debug_mode = 'Y' THEN
2545: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: finishing', TRUE , g_proc);
2546: Pa_Debug.write_file('Derive_Period_Julian: returning',5);
2547: END IF;
2548: Pa_Debug.Reset_Err_Stack;
2549:
2550:

Line 2548: Pa_Debug.Reset_Err_Stack;

2544: IF g_debug_mode = 'Y' THEN
2545: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: finishing', TRUE , g_proc);
2546: Pa_Debug.write_file('Derive_Period_Julian: returning',5);
2547: END IF;
2548: Pa_Debug.Reset_Err_Stack;
2549:
2550:
2551: EXCEPTION
2552: WHEN NO_DATA_FOUND THEN

Line 3157: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Slice_Name');

3153: l_msg_count NUMBER;
3154: l_msg_data VARCHAR2(2000);
3155: BEGIN
3156:
3157: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Slice_Name');
3158: IF g_debug_mode = 'Y' THEN
3159: Pa_Debug.write_file('Get_Slice_Name: begining',5);
3160: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: begining', TRUE , g_proc);
3161: END IF;

Line 3159: Pa_Debug.write_file('Get_Slice_Name: begining',5);

3155: BEGIN
3156:
3157: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Slice_Name');
3158: IF g_debug_mode = 'Y' THEN
3159: Pa_Debug.write_file('Get_Slice_Name: begining',5);
3160: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: begining', TRUE , g_proc);
3161: END IF;
3162:
3163: Derive_Slice_Name(p_project_id,

Line 3173: Pa_Debug.write_file('Get_Slice_Name: returning',5);

3169:
3170:
3171: IF g_debug_mode = 'Y' THEN
3172: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: returning', TRUE , g_proc);
3173: Pa_Debug.write_file('Get_Slice_Name: returning',5);
3174: END IF;
3175: Pa_Debug.Reset_Err_Stack;
3176:
3177: RETURN l_slice_name;

Line 3175: Pa_Debug.Reset_Err_Stack;

3171: IF g_debug_mode = 'Y' THEN
3172: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: returning', TRUE , g_proc);
3173: Pa_Debug.write_file('Get_Slice_Name: returning',5);
3174: END IF;
3175: Pa_Debug.Reset_Err_Stack;
3176:
3177: RETURN l_slice_name;
3178:
3179: EXCEPTION

Line 3495: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

3491:
3492: BEGIN
3493: x_msg_count := 0;
3494: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3495: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3496:
3497: IF l_debug_mode = 'Y' THEN
3498: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_PARAM_CONSISTENCY',
3499: p_debug_mode => l_debug_mode );

Line 3498: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_PARAM_CONSISTENCY',

3494: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3495: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3496:
3497: IF l_debug_mode = 'Y' THEN
3498: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_PARAM_CONSISTENCY',
3499: p_debug_mode => l_debug_mode );
3500: END IF;
3501:
3502: --Call the currency check API

Line 3576: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';

3572: RETURN;
3573: END IF;
3574:
3575: IF l_debug_mode = 'Y' THEN
3576: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
3577: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3578: Pa_Debug.reset_curr_function;
3579: END IF;
3580: EXCEPTION

Line 3577: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);

3573: END IF;
3574:
3575: IF l_debug_mode = 'Y' THEN
3576: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
3577: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3578: Pa_Debug.reset_curr_function;
3579: END IF;
3580: EXCEPTION
3581: WHEN OTHERS THEN

Line 3578: Pa_Debug.reset_curr_function;

3574:
3575: IF l_debug_mode = 'Y' THEN
3576: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
3577: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3578: Pa_Debug.reset_curr_function;
3579: END IF;
3580: EXCEPTION
3581: WHEN OTHERS THEN
3582:

Line 3593: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

3589: ,p_procedure_name => 'CHECK_WP_PARAM_CONSISTENCY'
3590: ,p_error_text => x_msg_data);
3591:
3592: IF l_debug_mode = 'Y' THEN
3593: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3594: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3595: Pa_Debug.reset_curr_function;
3596: END IF;
3597: RAISE;

Line 3594: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);

3590: ,p_error_text => x_msg_data);
3591:
3592: IF l_debug_mode = 'Y' THEN
3593: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3594: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3595: Pa_Debug.reset_curr_function;
3596: END IF;
3597: RAISE;
3598: END CHECK_WP_PARAM_CONSISTENCY;

Line 3595: Pa_Debug.reset_curr_function;

3591:
3592: IF l_debug_mode = 'Y' THEN
3593: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3594: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3595: Pa_Debug.reset_curr_function;
3596: END IF;
3597: RAISE;
3598: END CHECK_WP_PARAM_CONSISTENCY;
3599:

Line 3672: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

3668:
3669: BEGIN
3670: x_msg_count := 0;
3671: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3672: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3673:
3674: IF l_debug_mode = 'Y' THEN
3675: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_CURRENCY_CONSISTENCY',
3676: p_debug_mode => l_debug_mode );

Line 3675: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_CURRENCY_CONSISTENCY',

3671: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3672: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3673:
3674: IF l_debug_mode = 'Y' THEN
3675: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_CURRENCY_CONSISTENCY',
3676: p_debug_mode => l_debug_mode );
3677: END IF;
3678:
3679: --These flags will denote the respective consistency. A value of Y for x_pc_flag

Line 3705: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_CURRENCY_CONSISTENCY';

3701: END IF;
3702: CLOSE check_projfunc_currency;
3703:
3704: IF l_debug_mode = 'Y' THEN
3705: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_CURRENCY_CONSISTENCY';
3706: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3707: Pa_Debug.reset_curr_function;
3708: END IF;
3709: EXCEPTION

Line 3706: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);

3702: CLOSE check_projfunc_currency;
3703:
3704: IF l_debug_mode = 'Y' THEN
3705: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_CURRENCY_CONSISTENCY';
3706: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3707: Pa_Debug.reset_curr_function;
3708: END IF;
3709: EXCEPTION
3710:

Line 3707: Pa_Debug.reset_curr_function;

3703:
3704: IF l_debug_mode = 'Y' THEN
3705: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_CURRENCY_CONSISTENCY';
3706: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3707: Pa_Debug.reset_curr_function;
3708: END IF;
3709: EXCEPTION
3710:
3711: WHEN OTHERS THEN

Line 3723: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

3719: ,p_procedure_name => 'CHECK_WP_CURRENCY_CONSISTENCY'
3720: ,p_error_text => x_msg_data);
3721:
3722: IF l_debug_mode = 'Y' THEN
3723: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3724: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3725: Pa_Debug.reset_curr_function;
3726: END IF;
3727: RAISE;

Line 3724: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);

3720: ,p_error_text => x_msg_data);
3721:
3722: IF l_debug_mode = 'Y' THEN
3723: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3724: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3725: Pa_Debug.reset_curr_function;
3726: END IF;
3727: RAISE;
3728: END CHECK_WP_CURRENCY_CONSISTENCY;

Line 3725: Pa_Debug.reset_curr_function;

3721:
3722: IF l_debug_mode = 'Y' THEN
3723: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3724: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3725: Pa_Debug.reset_curr_function;
3726: END IF;
3727: RAISE;
3728: END CHECK_WP_CURRENCY_CONSISTENCY;
3729:

Line 3780: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

3776:
3777: BEGIN
3778: x_msg_count := 0;
3779: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3780: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3781:
3782: IF l_debug_mode = 'Y' THEN
3783: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_MARGIN_CONSISTENCY',
3784: p_debug_mode => l_debug_mode );

Line 3783: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_MARGIN_CONSISTENCY',

3779: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3780: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3781:
3782: IF l_debug_mode = 'Y' THEN
3783: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_MARGIN_CONSISTENCY',
3784: p_debug_mode => l_debug_mode );
3785: END IF;
3786:
3787: --These flags will denote the respective consistency. A value of Y for x_currency_flag

Line 3800: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_MARGIN_CONSISTENCY';

3796: END IF;
3797: CLOSE check_margin_mask;
3798:
3799: IF l_debug_mode = 'Y' THEN
3800: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_MARGIN_CONSISTENCY';
3801: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3802: Pa_Debug.reset_curr_function;
3803: END IF;
3804: EXCEPTION

Line 3801: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);

3797: CLOSE check_margin_mask;
3798:
3799: IF l_debug_mode = 'Y' THEN
3800: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_MARGIN_CONSISTENCY';
3801: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3802: Pa_Debug.reset_curr_function;
3803: END IF;
3804: EXCEPTION
3805:

Line 3802: Pa_Debug.reset_curr_function;

3798:
3799: IF l_debug_mode = 'Y' THEN
3800: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_MARGIN_CONSISTENCY';
3801: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3802: Pa_Debug.reset_curr_function;
3803: END IF;
3804: EXCEPTION
3805:
3806: WHEN OTHERS THEN

Line 3818: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

3814: ,p_procedure_name => 'CHECK_WP_MARGIN_CONSISTENCY'
3815: ,p_error_text => x_msg_data);
3816:
3817: IF l_debug_mode = 'Y' THEN
3818: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3819: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3820: Pa_Debug.reset_curr_function;
3821: END IF;
3822: RAISE;

Line 3819: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);

3815: ,p_error_text => x_msg_data);
3816:
3817: IF l_debug_mode = 'Y' THEN
3818: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3819: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3820: Pa_Debug.reset_curr_function;
3821: END IF;
3822: RAISE;
3823: END CHECK_WP_MARGIN_CONSISTENCY;

Line 3820: Pa_Debug.reset_curr_function;

3816:
3817: IF l_debug_mode = 'Y' THEN
3818: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3819: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3820: Pa_Debug.reset_curr_function;
3821: END IF;
3822: RAISE;
3823: END CHECK_WP_MARGIN_CONSISTENCY;
3824:

Line 3873: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

3869:
3870: BEGIN
3871: x_msg_count := 0;
3872: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3873: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3874:
3875: IF l_debug_mode = 'Y' THEN
3876: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_STATUS_CONSISTENCY',
3877: p_debug_mode => l_debug_mode );

Line 3876: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_STATUS_CONSISTENCY',

3872: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3873: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3874:
3875: IF l_debug_mode = 'Y' THEN
3876: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_STATUS_CONSISTENCY',
3877: p_debug_mode => l_debug_mode );
3878: END IF;
3879:
3880: --These flags will denote the respective consistency. A value of Y for x_currency_flag

Line 3894: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';

3890: END IF;
3891: CLOSE check_published_flag;
3892:
3893: IF l_debug_mode = 'Y' THEN
3894: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
3895: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3896: Pa_Debug.reset_curr_function;
3897: END IF;
3898: EXCEPTION

Line 3895: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);

3891: CLOSE check_published_flag;
3892:
3893: IF l_debug_mode = 'Y' THEN
3894: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
3895: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3896: Pa_Debug.reset_curr_function;
3897: END IF;
3898: EXCEPTION
3899:

Line 3896: Pa_Debug.reset_curr_function;

3892:
3893: IF l_debug_mode = 'Y' THEN
3894: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
3895: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
3896: Pa_Debug.reset_curr_function;
3897: END IF;
3898: EXCEPTION
3899:
3900: WHEN OTHERS THEN

Line 3912: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

3908: ,p_procedure_name => 'CHECK_WP_STATUS_CONSISTENCY'
3909: ,p_error_text => x_msg_data);
3910:
3911: IF l_debug_mode = 'Y' THEN
3912: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3913: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3914: Pa_Debug.reset_curr_function;
3915: END IF;
3916: RAISE;

Line 3913: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);

3909: ,p_error_text => x_msg_data);
3910:
3911: IF l_debug_mode = 'Y' THEN
3912: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3913: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3914: Pa_Debug.reset_curr_function;
3915: END IF;
3916: RAISE;
3917: END CHECK_WP_STATUS_CONSISTENCY;

Line 3914: Pa_Debug.reset_curr_function;

3910:
3911: IF l_debug_mode = 'Y' THEN
3912: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3913: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
3914: Pa_Debug.reset_curr_function;
3915: END IF;
3916: RAISE;
3917: END CHECK_WP_STATUS_CONSISTENCY;
3918:

Line 3969: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

3965:
3966: BEGIN
3967: x_msg_count := 0;
3968: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3969: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3970:
3971: IF l_debug_mode = 'Y' THEN
3972: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_TIME_CONSISTENCY',
3973: p_debug_mode => l_debug_mode );

Line 3972: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_TIME_CONSISTENCY',

3968: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3969: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3970:
3971: IF l_debug_mode = 'Y' THEN
3972: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_TIME_CONSISTENCY',
3973: p_debug_mode => l_debug_mode );
3974: END IF;
3975:
3976: --These flags will denote the respective consistency. A value of Y for x_currency_flag

Line 4002: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_TIME_CONSISTENCY';

3998: END IF;
3999: END LOOP;
4000:
4001: IF l_debug_mode = 'Y' THEN
4002: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_TIME_CONSISTENCY';
4003: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4004: Pa_Debug.reset_curr_function;
4005: END IF;
4006: EXCEPTION

Line 4003: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);

3999: END LOOP;
4000:
4001: IF l_debug_mode = 'Y' THEN
4002: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_TIME_CONSISTENCY';
4003: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4004: Pa_Debug.reset_curr_function;
4005: END IF;
4006: EXCEPTION
4007:

Line 4004: Pa_Debug.reset_curr_function;

4000:
4001: IF l_debug_mode = 'Y' THEN
4002: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_TIME_CONSISTENCY';
4003: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4004: Pa_Debug.reset_curr_function;
4005: END IF;
4006: EXCEPTION
4007:
4008: WHEN OTHERS THEN

Line 4020: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

4016: ,p_procedure_name => 'CHECK_WP_PARAM_CONSISTENCY'
4017: ,p_error_text => x_msg_data);
4018:
4019: IF l_debug_mode = 'Y' THEN
4020: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4021: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4022: Pa_Debug.reset_curr_function;
4023: END IF;
4024: RAISE;

Line 4021: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);

4017: ,p_error_text => x_msg_data);
4018:
4019: IF l_debug_mode = 'Y' THEN
4020: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4021: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4022: Pa_Debug.reset_curr_function;
4023: END IF;
4024: RAISE;
4025: END CHECK_WP_TIME_CONSISTENCY;

Line 4022: Pa_Debug.reset_curr_function;

4018:
4019: IF l_debug_mode = 'Y' THEN
4020: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4021: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4022: Pa_Debug.reset_curr_function;
4023: END IF;
4024: RAISE;
4025: END CHECK_WP_TIME_CONSISTENCY;
4026:

Line 4078: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

4074:
4075: BEGIN
4076: x_msg_count := 0;
4077: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4078: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4079:
4080: IF l_debug_mode = 'Y' THEN
4081: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_RBS_CONSISTENCY',
4082: p_debug_mode => l_debug_mode );

Line 4081: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_RBS_CONSISTENCY',

4077: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4078: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4079:
4080: IF l_debug_mode = 'Y' THEN
4081: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_RBS_CONSISTENCY',
4082: p_debug_mode => l_debug_mode );
4083: END IF;
4084:
4085: --These flags will denote the respective consistency. A value of Y for x_currency_flag

Line 4098: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_RBS_CONSISTENCY';

4094: END IF;
4095: CLOSE check_rbs_flag;
4096:
4097: IF l_debug_mode = 'Y' THEN
4098: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_RBS_CONSISTENCY';
4099: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4100: Pa_Debug.reset_curr_function;
4101: END IF;
4102: EXCEPTION

Line 4099: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);

4095: CLOSE check_rbs_flag;
4096:
4097: IF l_debug_mode = 'Y' THEN
4098: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_RBS_CONSISTENCY';
4099: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4100: Pa_Debug.reset_curr_function;
4101: END IF;
4102: EXCEPTION
4103:

Line 4100: Pa_Debug.reset_curr_function;

4096:
4097: IF l_debug_mode = 'Y' THEN
4098: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_RBS_CONSISTENCY';
4099: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4100: Pa_Debug.reset_curr_function;
4101: END IF;
4102: EXCEPTION
4103:
4104: WHEN OTHERS THEN

Line 4116: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

4112: ,p_procedure_name => 'CHECK_WP_RBS_CONSISTENCY'
4113: ,p_error_text => x_msg_data);
4114:
4115: IF l_debug_mode = 'Y' THEN
4116: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4117: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4118: Pa_Debug.reset_curr_function;
4119: END IF;
4120: RAISE;

Line 4117: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);

4113: ,p_error_text => x_msg_data);
4114:
4115: IF l_debug_mode = 'Y' THEN
4116: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4117: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4118: Pa_Debug.reset_curr_function;
4119: END IF;
4120: RAISE;
4121: END CHECK_WP_RBS_CONSISTENCY;

Line 4118: Pa_Debug.reset_curr_function;

4114:
4115: IF l_debug_mode = 'Y' THEN
4116: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4117: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4118: Pa_Debug.reset_curr_function;
4119: END IF;
4120: RAISE;
4121: END CHECK_WP_RBS_CONSISTENCY;
4122:

Line 4728: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

4724:
4725: BEGIN
4726: x_msg_count := 0;
4727: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4728: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4729:
4730: IF l_debug_mode = 'Y' THEN
4731: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Cal_Consistency',
4732: p_debug_mode => l_debug_mode );

Line 4731: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Cal_Consistency',

4727: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4728: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4729:
4730: IF l_debug_mode = 'Y' THEN
4731: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Cal_Consistency',
4732: p_debug_mode => l_debug_mode );
4733: END IF;
4734:
4735: --These flags will denote the respective consistency. A value of T for x_gl_flag, and x_pa_flag

Line 4774: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Cal_Consistency';

4770: x_pa_flag := 'T';
4771: END IF;
4772:
4773: IF l_debug_mode = 'Y' THEN
4774: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Cal_Consistency';
4775: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4776: Pa_Debug.reset_curr_function;
4777: END IF;
4778: EXCEPTION

Line 4775: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);

4771: END IF;
4772:
4773: IF l_debug_mode = 'Y' THEN
4774: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Cal_Consistency';
4775: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4776: Pa_Debug.reset_curr_function;
4777: END IF;
4778: EXCEPTION
4779: WHEN OTHERS THEN

Line 4776: Pa_Debug.reset_curr_function;

4772:
4773: IF l_debug_mode = 'Y' THEN
4774: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Cal_Consistency';
4775: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4776: Pa_Debug.reset_curr_function;
4777: END IF;
4778: EXCEPTION
4779: WHEN OTHERS THEN
4780: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 4790: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

4786: ,p_procedure_name => 'Check_Perf_Cal_Consistency'
4787: ,p_error_text => x_msg_data);
4788:
4789: IF l_debug_mode = 'Y' THEN
4790: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4791: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4792: Pa_Debug.reset_curr_function;
4793: END IF;
4794: RAISE;

Line 4791: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);

4787: ,p_error_text => x_msg_data);
4788:
4789: IF l_debug_mode = 'Y' THEN
4790: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4791: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4792: Pa_Debug.reset_curr_function;
4793: END IF;
4794: RAISE;
4795: END Check_Perf_Cal_Consistency;

Line 4792: Pa_Debug.reset_curr_function;

4788:
4789: IF l_debug_mode = 'Y' THEN
4790: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4791: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4792: Pa_Debug.reset_curr_function;
4793: END IF;
4794: RAISE;
4795: END Check_Perf_Cal_Consistency;
4796:

Line 4822: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

4818:
4819: BEGIN
4820: x_msg_count := 0;
4821: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4822: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4823:
4824: IF l_debug_mode = 'Y' THEN
4825: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Curr_Consistency',
4826: p_debug_mode => l_debug_mode );

Line 4825: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Curr_Consistency',

4821: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4822: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4823:
4824: IF l_debug_mode = 'Y' THEN
4825: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Curr_Consistency',
4826: p_debug_mode => l_debug_mode );
4827: END IF;
4828:
4829: --These flags will denote the respective consistency. A value of T for x_pfc_flag

Line 4857: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Curr_Consistency';

4853: x_pfc_flag := 'T';
4854: END IF;
4855:
4856: IF l_debug_mode = 'Y' THEN
4857: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Curr_Consistency';
4858: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4859: Pa_Debug.reset_curr_function;
4860: END IF;
4861: EXCEPTION

Line 4858: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);

4854: END IF;
4855:
4856: IF l_debug_mode = 'Y' THEN
4857: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Curr_Consistency';
4858: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4859: Pa_Debug.reset_curr_function;
4860: END IF;
4861: EXCEPTION
4862: WHEN OTHERS THEN

Line 4859: Pa_Debug.reset_curr_function;

4855:
4856: IF l_debug_mode = 'Y' THEN
4857: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Curr_Consistency';
4858: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4859: Pa_Debug.reset_curr_function;
4860: END IF;
4861: EXCEPTION
4862: WHEN OTHERS THEN
4863: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 4873: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

4869: ,p_procedure_name => 'Check_Perf_Curr_Consistency'
4870: ,p_error_text => x_msg_data);
4871:
4872: IF l_debug_mode = 'Y' THEN
4873: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4874: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4875: Pa_Debug.reset_curr_function;
4876: END IF;
4877: RAISE;

Line 4874: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);

4870: ,p_error_text => x_msg_data);
4871:
4872: IF l_debug_mode = 'Y' THEN
4873: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4874: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4875: Pa_Debug.reset_curr_function;
4876: END IF;
4877: RAISE;
4878: END Check_Perf_Curr_Consistency;

Line 4875: Pa_Debug.reset_curr_function;

4871:
4872: IF l_debug_mode = 'Y' THEN
4873: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4874: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4875: Pa_Debug.reset_curr_function;
4876: END IF;
4877: RAISE;
4878: END Check_Perf_Curr_Consistency;
4879: