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 olap_denorm_create (
40: p_element_version_id number ,

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

2211: l_end_date DATE;
2212: l_rec_count NUMBER;
2213: BEGIN
2214:
2215: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Slice_Name');
2216: IF g_debug_mode = 'Y' THEN
2217: Pa_Debug.write_file('Derive_Slice_Name: beginning',5);
2218: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: beginning', TRUE , g_proc);
2219: END IF;

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

2213: BEGIN
2214:
2215: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Slice_Name');
2216: IF g_debug_mode = 'Y' THEN
2217: Pa_Debug.write_file('Derive_Slice_Name: beginning',5);
2218: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: beginning', TRUE , g_proc);
2219: END IF;
2220:
2221: IF x_return_status IS NULL THEN

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

2309: END IF;
2310:
2311: IF g_debug_mode = 'Y' THEN
2312: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: finishing', TRUE , g_proc);
2313: Pa_Debug.write_file('Derive_Slice_Name: returning',5);
2314: END IF;
2315: Pa_Debug.Reset_Err_Stack;
2316:
2317: EXCEPTION

Line 2315: Pa_Debug.Reset_Err_Stack;

2311: IF g_debug_mode = 'Y' THEN
2312: -- Pji_Utils.WRITE2LOG( 'derive_slice_name: finishing', TRUE , g_proc);
2313: Pa_Debug.write_file('Derive_Slice_Name: returning',5);
2314: END IF;
2315: Pa_Debug.Reset_Err_Stack;
2316:
2317: EXCEPTION
2318: WHEN NO_DATA_FOUND THEN
2319: x_msg_count := x_msg_count + 1;

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

2629: l_msg_count NUMBER;
2630: l_msg_data VARCHAR2(2000);
2631: BEGIN
2632:
2633: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Report_Date_Julian');
2634: IF g_debug_mode = 'Y' THEN
2635: Pa_Debug.write_file('Get_Report_Date_Julian: begining',5);
2636: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: begining', TRUE , g_proc);
2637: END IF;

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

2631: BEGIN
2632:
2633: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Report_Date_Julian');
2634: IF g_debug_mode = 'Y' THEN
2635: Pa_Debug.write_file('Get_Report_Date_Julian: begining',5);
2636: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: begining', TRUE , g_proc);
2637: END IF;
2638:
2639: -- IF (p_calendar_type <> g_input_calendar_type) OR (p_calendar_id <> g_input_calendar_id) THEN

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

2649: RETURN g_report_date_julian;
2650:
2651: IF g_debug_mode = 'Y' THEN
2652: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: finishing', TRUE , g_proc);
2653: Pa_Debug.write_file('Get_Report_Date_Julian: returning',5);
2654: END IF;
2655: Pa_Debug.Reset_Err_Stack;
2656:
2657: EXCEPTION

Line 2655: Pa_Debug.Reset_Err_Stack;

2651: IF g_debug_mode = 'Y' THEN
2652: -- Pji_Utils.WRITE2LOG( 'derive_report_date_julian: finishing', TRUE , g_proc);
2653: Pa_Debug.write_file('Get_Report_Date_Julian: returning',5);
2654: END IF;
2655: Pa_Debug.Reset_Err_Stack;
2656:
2657: EXCEPTION
2658: WHEN OTHERS THEN
2659: 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 2673: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Period_Name');

2669: l_msg_count NUMBER;
2670: l_msg_data VARCHAR2(2000);
2671: BEGIN
2672:
2673: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Period_Name');
2674: IF g_debug_mode = 'Y' THEN
2675: Pa_Debug.write_file('Get_Period_Name: begining',5);
2676: -- Pji_Utils.WRITE2LOG( 'get_period_name: begining', TRUE , g_proc);
2677: END IF;

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

2671: BEGIN
2672:
2673: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Period_Name');
2674: IF g_debug_mode = 'Y' THEN
2675: Pa_Debug.write_file('Get_Period_Name: begining',5);
2676: -- Pji_Utils.WRITE2LOG( 'get_period_name: begining', TRUE , g_proc);
2677: END IF;
2678:
2679: -- IF (p_calendar_type <> g_input_calendar_type) OR (p_calendar_id <> g_input_calendar_id) THEN

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

2688: -- END IF;
2689:
2690: IF g_debug_mode = 'Y' THEN
2691: -- Pji_Utils.WRITE2LOG( 'get_period_name: returning', TRUE , g_proc);
2692: Pa_Debug.write_file('Get_Period_Name: returning',5);
2693: END IF;
2694: Pa_Debug.Reset_Err_Stack;
2695:
2696: RETURN g_period_name;

Line 2694: Pa_Debug.Reset_Err_Stack;

2690: IF g_debug_mode = 'Y' THEN
2691: -- Pji_Utils.WRITE2LOG( 'get_period_name: returning', TRUE , g_proc);
2692: Pa_Debug.write_file('Get_Period_Name: returning',5);
2693: END IF;
2694: Pa_Debug.Reset_Err_Stack;
2695:
2696: RETURN g_period_name;
2697:
2698: EXCEPTION

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

2727: l_gl_calendar_id NUMBER;
2728: l_pa_calendar_id NUMBER;
2729: l_same_pa_gl_period varchar2(1); /* Added for bug 9859878 */
2730: BEGIN
2731: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Period_Julian');
2732: IF g_debug_mode = 'Y' THEN
2733: Pa_Debug.write_file('Derive_Period_Julian: begining',5);
2734: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: begining', TRUE , g_proc);
2735: END IF;

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

2729: l_same_pa_gl_period varchar2(1); /* Added for bug 9859878 */
2730: BEGIN
2731: Pa_Debug.init_err_stack('PJI_REP_UTIL.Derive_Period_Julian');
2732: IF g_debug_mode = 'Y' THEN
2733: Pa_Debug.write_file('Derive_Period_Julian: begining',5);
2734: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: begining', TRUE , g_proc);
2735: END IF;
2736:
2737: IF p_calendar_type = 'E' THEN

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

2986:
2987:
2988: IF g_debug_mode = 'Y' THEN
2989: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: finishing', TRUE , g_proc);
2990: Pa_Debug.write_file('Derive_Period_Julian: returning',5);
2991: END IF;
2992: Pa_Debug.Reset_Err_Stack;
2993:
2994:

Line 2992: Pa_Debug.Reset_Err_Stack;

2988: IF g_debug_mode = 'Y' THEN
2989: -- Pji_Utils.WRITE2LOG( 'derive_period_julian: finishing', TRUE , g_proc);
2990: Pa_Debug.write_file('Derive_Period_Julian: returning',5);
2991: END IF;
2992: Pa_Debug.Reset_Err_Stack;
2993:
2994:
2995: EXCEPTION
2996: WHEN NO_DATA_FOUND THEN

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

3597: l_msg_count NUMBER;
3598: l_msg_data VARCHAR2(2000);
3599: BEGIN
3600:
3601: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Slice_Name');
3602: IF g_debug_mode = 'Y' THEN
3603: Pa_Debug.write_file('Get_Slice_Name: begining',5);
3604: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: begining', TRUE , g_proc);
3605: END IF;

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

3599: BEGIN
3600:
3601: Pa_Debug.init_err_stack('PJI_REP_UTIL.Get_Slice_Name');
3602: IF g_debug_mode = 'Y' THEN
3603: Pa_Debug.write_file('Get_Slice_Name: begining',5);
3604: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: begining', TRUE , g_proc);
3605: END IF;
3606:
3607: Derive_Slice_Name(p_project_id,

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

3613:
3614:
3615: IF g_debug_mode = 'Y' THEN
3616: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: returning', TRUE , g_proc);
3617: Pa_Debug.write_file('Get_Slice_Name: returning',5);
3618: END IF;
3619: Pa_Debug.Reset_Err_Stack;
3620:
3621: RETURN l_slice_name;

Line 3619: Pa_Debug.Reset_Err_Stack;

3615: IF g_debug_mode = 'Y' THEN
3616: -- Pji_Utils.WRITE2LOG( 'Get_Slice_Name: returning', TRUE , g_proc);
3617: Pa_Debug.write_file('Get_Slice_Name: returning',5);
3618: END IF;
3619: Pa_Debug.Reset_Err_Stack;
3620:
3621: RETURN l_slice_name;
3622:
3623: EXCEPTION

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

3935:
3936: BEGIN
3937: x_msg_count := 0;
3938: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3939: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3940:
3941: IF l_debug_mode = 'Y' THEN
3942: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_PARAM_CONSISTENCY',
3943: p_debug_mode => l_debug_mode );

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

3938: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3939: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3940:
3941: IF l_debug_mode = 'Y' THEN
3942: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_PARAM_CONSISTENCY',
3943: p_debug_mode => l_debug_mode );
3944: END IF;
3945:
3946: --Call the currency check API

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

4016: RETURN;
4017: END IF;
4018:
4019: IF l_debug_mode = 'Y' THEN
4020: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
4021: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4022: Pa_Debug.reset_curr_function;
4023: END IF;
4024: EXCEPTION

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

4017: END IF;
4018:
4019: IF l_debug_mode = 'Y' THEN
4020: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
4021: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4022: Pa_Debug.reset_curr_function;
4023: END IF;
4024: EXCEPTION
4025: WHEN OTHERS THEN

Line 4022: Pa_Debug.reset_curr_function;

4018:
4019: IF l_debug_mode = 'Y' THEN
4020: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
4021: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4022: Pa_Debug.reset_curr_function;
4023: END IF;
4024: EXCEPTION
4025: WHEN OTHERS THEN
4026:

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

4033: ,p_procedure_name => 'CHECK_WP_PARAM_CONSISTENCY'
4034: ,p_error_text => x_msg_data);
4035:
4036: IF l_debug_mode = 'Y' THEN
4037: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4038: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4039: Pa_Debug.reset_curr_function;
4040: END IF;
4041: RAISE;

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

4034: ,p_error_text => x_msg_data);
4035:
4036: IF l_debug_mode = 'Y' THEN
4037: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4038: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4039: Pa_Debug.reset_curr_function;
4040: END IF;
4041: RAISE;
4042: END CHECK_WP_PARAM_CONSISTENCY;

Line 4039: Pa_Debug.reset_curr_function;

4035:
4036: IF l_debug_mode = 'Y' THEN
4037: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4038: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4039: Pa_Debug.reset_curr_function;
4040: END IF;
4041: RAISE;
4042: END CHECK_WP_PARAM_CONSISTENCY;
4043:

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

4112:
4113: BEGIN
4114: x_msg_count := 0;
4115: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4116: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4117:
4118: IF l_debug_mode = 'Y' THEN
4119: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_CURRENCY_CONSISTENCY',
4120: p_debug_mode => l_debug_mode );

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

4115: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4116: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4117:
4118: IF l_debug_mode = 'Y' THEN
4119: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_CURRENCY_CONSISTENCY',
4120: p_debug_mode => l_debug_mode );
4121: END IF;
4122:
4123: --These flags will denote the respective consistency. A value of Y for x_pc_flag

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

4145: END IF;
4146: CLOSE check_projfunc_currency;
4147:
4148: IF l_debug_mode = 'Y' THEN
4149: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_CURRENCY_CONSISTENCY';
4150: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4151: Pa_Debug.reset_curr_function;
4152: END IF;
4153: EXCEPTION

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

4146: CLOSE check_projfunc_currency;
4147:
4148: IF l_debug_mode = 'Y' THEN
4149: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_CURRENCY_CONSISTENCY';
4150: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4151: Pa_Debug.reset_curr_function;
4152: END IF;
4153: EXCEPTION
4154:

Line 4151: Pa_Debug.reset_curr_function;

4147:
4148: IF l_debug_mode = 'Y' THEN
4149: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_CURRENCY_CONSISTENCY';
4150: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4151: Pa_Debug.reset_curr_function;
4152: END IF;
4153: EXCEPTION
4154:
4155: WHEN OTHERS THEN

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

4163: ,p_procedure_name => 'CHECK_WP_CURRENCY_CONSISTENCY'
4164: ,p_error_text => x_msg_data);
4165:
4166: IF l_debug_mode = 'Y' THEN
4167: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4168: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4169: Pa_Debug.reset_curr_function;
4170: END IF;
4171: RAISE;

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

4164: ,p_error_text => x_msg_data);
4165:
4166: IF l_debug_mode = 'Y' THEN
4167: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4168: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4169: Pa_Debug.reset_curr_function;
4170: END IF;
4171: RAISE;
4172: END CHECK_WP_CURRENCY_CONSISTENCY;

Line 4169: Pa_Debug.reset_curr_function;

4165:
4166: IF l_debug_mode = 'Y' THEN
4167: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4168: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4169: Pa_Debug.reset_curr_function;
4170: END IF;
4171: RAISE;
4172: END CHECK_WP_CURRENCY_CONSISTENCY;
4173:

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

4220:
4221: BEGIN
4222: x_msg_count := 0;
4223: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4224: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4225:
4226: IF l_debug_mode = 'Y' THEN
4227: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_MARGIN_CONSISTENCY',
4228: p_debug_mode => l_debug_mode );

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

4223: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4224: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4225:
4226: IF l_debug_mode = 'Y' THEN
4227: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_MARGIN_CONSISTENCY',
4228: p_debug_mode => l_debug_mode );
4229: END IF;
4230:
4231: --These flags will denote the respective consistency. A value of Y for x_currency_flag

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

4240: END IF;
4241: CLOSE check_margin_mask;
4242:
4243: IF l_debug_mode = 'Y' THEN
4244: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_MARGIN_CONSISTENCY';
4245: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4246: Pa_Debug.reset_curr_function;
4247: END IF;
4248: EXCEPTION

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

4241: CLOSE check_margin_mask;
4242:
4243: IF l_debug_mode = 'Y' THEN
4244: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_MARGIN_CONSISTENCY';
4245: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4246: Pa_Debug.reset_curr_function;
4247: END IF;
4248: EXCEPTION
4249:

Line 4246: Pa_Debug.reset_curr_function;

4242:
4243: IF l_debug_mode = 'Y' THEN
4244: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_MARGIN_CONSISTENCY';
4245: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4246: Pa_Debug.reset_curr_function;
4247: END IF;
4248: EXCEPTION
4249:
4250: WHEN OTHERS THEN

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

4258: ,p_procedure_name => 'CHECK_WP_MARGIN_CONSISTENCY'
4259: ,p_error_text => x_msg_data);
4260:
4261: IF l_debug_mode = 'Y' THEN
4262: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4263: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4264: Pa_Debug.reset_curr_function;
4265: END IF;
4266: RAISE;

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

4259: ,p_error_text => x_msg_data);
4260:
4261: IF l_debug_mode = 'Y' THEN
4262: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4263: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4264: Pa_Debug.reset_curr_function;
4265: END IF;
4266: RAISE;
4267: END CHECK_WP_MARGIN_CONSISTENCY;

Line 4264: Pa_Debug.reset_curr_function;

4260:
4261: IF l_debug_mode = 'Y' THEN
4262: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4263: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4264: Pa_Debug.reset_curr_function;
4265: END IF;
4266: RAISE;
4267: END CHECK_WP_MARGIN_CONSISTENCY;
4268:

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

4313:
4314: BEGIN
4315: x_msg_count := 0;
4316: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4317: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4318:
4319: IF l_debug_mode = 'Y' THEN
4320: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_STATUS_CONSISTENCY',
4321: p_debug_mode => l_debug_mode );

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

4316: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4317: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4318:
4319: IF l_debug_mode = 'Y' THEN
4320: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_STATUS_CONSISTENCY',
4321: p_debug_mode => l_debug_mode );
4322: END IF;
4323:
4324: --These flags will denote the respective consistency. A value of Y for x_currency_flag

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

4334: END IF;
4335: CLOSE check_published_flag;
4336:
4337: IF l_debug_mode = 'Y' THEN
4338: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
4339: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4340: Pa_Debug.reset_curr_function;
4341: END IF;
4342: EXCEPTION

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

4335: CLOSE check_published_flag;
4336:
4337: IF l_debug_mode = 'Y' THEN
4338: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
4339: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4340: Pa_Debug.reset_curr_function;
4341: END IF;
4342: EXCEPTION
4343:

Line 4340: Pa_Debug.reset_curr_function;

4336:
4337: IF l_debug_mode = 'Y' THEN
4338: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_PARAM_CONSISTENCY';
4339: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4340: Pa_Debug.reset_curr_function;
4341: END IF;
4342: EXCEPTION
4343:
4344: WHEN OTHERS THEN

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

4352: ,p_procedure_name => 'CHECK_WP_STATUS_CONSISTENCY'
4353: ,p_error_text => x_msg_data);
4354:
4355: IF l_debug_mode = 'Y' THEN
4356: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4357: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4358: Pa_Debug.reset_curr_function;
4359: END IF;
4360: RAISE;

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

4353: ,p_error_text => x_msg_data);
4354:
4355: IF l_debug_mode = 'Y' THEN
4356: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4357: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4358: Pa_Debug.reset_curr_function;
4359: END IF;
4360: RAISE;
4361: END CHECK_WP_STATUS_CONSISTENCY;

Line 4358: Pa_Debug.reset_curr_function;

4354:
4355: IF l_debug_mode = 'Y' THEN
4356: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4357: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4358: Pa_Debug.reset_curr_function;
4359: END IF;
4360: RAISE;
4361: END CHECK_WP_STATUS_CONSISTENCY;
4362:

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

4409:
4410: BEGIN
4411: x_msg_count := 0;
4412: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4413: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4414:
4415: IF l_debug_mode = 'Y' THEN
4416: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_TIME_CONSISTENCY',
4417: p_debug_mode => l_debug_mode );

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

4412: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4413: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4414:
4415: IF l_debug_mode = 'Y' THEN
4416: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_TIME_CONSISTENCY',
4417: p_debug_mode => l_debug_mode );
4418: END IF;
4419:
4420: --These flags will denote the respective consistency. A value of Y for x_currency_flag

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

4442: END IF;
4443: END LOOP;
4444:
4445: IF l_debug_mode = 'Y' THEN
4446: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_TIME_CONSISTENCY';
4447: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4448: Pa_Debug.reset_curr_function;
4449: END IF;
4450: EXCEPTION

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

4443: END LOOP;
4444:
4445: IF l_debug_mode = 'Y' THEN
4446: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_TIME_CONSISTENCY';
4447: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4448: Pa_Debug.reset_curr_function;
4449: END IF;
4450: EXCEPTION
4451:

Line 4448: Pa_Debug.reset_curr_function;

4444:
4445: IF l_debug_mode = 'Y' THEN
4446: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_TIME_CONSISTENCY';
4447: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4448: Pa_Debug.reset_curr_function;
4449: END IF;
4450: EXCEPTION
4451:
4452: WHEN OTHERS THEN

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

4460: ,p_procedure_name => 'CHECK_WP_PARAM_CONSISTENCY'
4461: ,p_error_text => x_msg_data);
4462:
4463: IF l_debug_mode = 'Y' THEN
4464: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4465: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4466: Pa_Debug.reset_curr_function;
4467: END IF;
4468: RAISE;

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

4461: ,p_error_text => x_msg_data);
4462:
4463: IF l_debug_mode = 'Y' THEN
4464: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4465: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4466: Pa_Debug.reset_curr_function;
4467: END IF;
4468: RAISE;
4469: END CHECK_WP_TIME_CONSISTENCY;

Line 4466: Pa_Debug.reset_curr_function;

4462:
4463: IF l_debug_mode = 'Y' THEN
4464: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4465: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4466: Pa_Debug.reset_curr_function;
4467: END IF;
4468: RAISE;
4469: END CHECK_WP_TIME_CONSISTENCY;
4470:

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

4518:
4519: BEGIN
4520: x_msg_count := 0;
4521: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4522: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4523:
4524: IF l_debug_mode = 'Y' THEN
4525: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_RBS_CONSISTENCY',
4526: p_debug_mode => l_debug_mode );

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

4521: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4522: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4523:
4524: IF l_debug_mode = 'Y' THEN
4525: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_RBS_CONSISTENCY',
4526: p_debug_mode => l_debug_mode );
4527: END IF;
4528:
4529: --These flags will denote the respective consistency. A value of Y for x_currency_flag

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

4538: END IF;
4539: CLOSE check_rbs_flag;
4540:
4541: IF l_debug_mode = 'Y' THEN
4542: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_RBS_CONSISTENCY';
4543: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4544: Pa_Debug.reset_curr_function;
4545: END IF;
4546: EXCEPTION

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

4539: CLOSE check_rbs_flag;
4540:
4541: IF l_debug_mode = 'Y' THEN
4542: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_RBS_CONSISTENCY';
4543: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4544: Pa_Debug.reset_curr_function;
4545: END IF;
4546: EXCEPTION
4547:

Line 4544: Pa_Debug.reset_curr_function;

4540:
4541: IF l_debug_mode = 'Y' THEN
4542: Pa_Debug.g_err_stage:= 'Exiting CHECK_WP_RBS_CONSISTENCY';
4543: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
4544: Pa_Debug.reset_curr_function;
4545: END IF;
4546: EXCEPTION
4547:
4548: WHEN OTHERS THEN

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

4556: ,p_procedure_name => 'CHECK_WP_RBS_CONSISTENCY'
4557: ,p_error_text => x_msg_data);
4558:
4559: IF l_debug_mode = 'Y' THEN
4560: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4561: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4562: Pa_Debug.reset_curr_function;
4563: END IF;
4564: RAISE;

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

4557: ,p_error_text => x_msg_data);
4558:
4559: IF l_debug_mode = 'Y' THEN
4560: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4561: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4562: Pa_Debug.reset_curr_function;
4563: END IF;
4564: RAISE;
4565: END CHECK_WP_RBS_CONSISTENCY;

Line 4562: Pa_Debug.reset_curr_function;

4558:
4559: IF l_debug_mode = 'Y' THEN
4560: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
4561: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
4562: Pa_Debug.reset_curr_function;
4563: END IF;
4564: RAISE;
4565: END CHECK_WP_RBS_CONSISTENCY;
4566:

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

5168:
5169: BEGIN
5170: x_msg_count := 0;
5171: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5172: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
5173:
5174: IF l_debug_mode = 'Y' THEN
5175: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Cal_Consistency',
5176: p_debug_mode => l_debug_mode );

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

5171: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5172: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
5173:
5174: IF l_debug_mode = 'Y' THEN
5175: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Cal_Consistency',
5176: p_debug_mode => l_debug_mode );
5177: END IF;
5178:
5179: --These flags will denote the respective consistency. A value of T for x_gl_flag, and x_pa_flag

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

5214: x_pa_flag := 'T';
5215: END IF;
5216:
5217: IF l_debug_mode = 'Y' THEN
5218: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Cal_Consistency';
5219: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
5220: Pa_Debug.reset_curr_function;
5221: END IF;
5222: EXCEPTION

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

5215: END IF;
5216:
5217: IF l_debug_mode = 'Y' THEN
5218: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Cal_Consistency';
5219: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
5220: Pa_Debug.reset_curr_function;
5221: END IF;
5222: EXCEPTION
5223: WHEN OTHERS THEN

Line 5220: Pa_Debug.reset_curr_function;

5216:
5217: IF l_debug_mode = 'Y' THEN
5218: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Cal_Consistency';
5219: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
5220: Pa_Debug.reset_curr_function;
5221: END IF;
5222: EXCEPTION
5223: WHEN OTHERS THEN
5224: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

5230: ,p_procedure_name => 'Check_Perf_Cal_Consistency'
5231: ,p_error_text => x_msg_data);
5232:
5233: IF l_debug_mode = 'Y' THEN
5234: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
5235: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
5236: Pa_Debug.reset_curr_function;
5237: END IF;
5238: RAISE;

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

5231: ,p_error_text => x_msg_data);
5232:
5233: IF l_debug_mode = 'Y' THEN
5234: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
5235: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
5236: Pa_Debug.reset_curr_function;
5237: END IF;
5238: RAISE;
5239: END Check_Perf_Cal_Consistency;

Line 5236: Pa_Debug.reset_curr_function;

5232:
5233: IF l_debug_mode = 'Y' THEN
5234: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
5235: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
5236: Pa_Debug.reset_curr_function;
5237: END IF;
5238: RAISE;
5239: END Check_Perf_Cal_Consistency;
5240:

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

5262:
5263: BEGIN
5264: x_msg_count := 0;
5265: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5266: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
5267:
5268: IF l_debug_mode = 'Y' THEN
5269: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Curr_Consistency',
5270: p_debug_mode => l_debug_mode );

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

5265: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5266: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
5267:
5268: IF l_debug_mode = 'Y' THEN
5269: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Curr_Consistency',
5270: p_debug_mode => l_debug_mode );
5271: END IF;
5272:
5273: --These flags will denote the respective consistency. A value of T for x_pfc_flag

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

5297: x_pfc_flag := 'T';
5298: END IF;
5299:
5300: IF l_debug_mode = 'Y' THEN
5301: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Curr_Consistency';
5302: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
5303: Pa_Debug.reset_curr_function;
5304: END IF;
5305: EXCEPTION

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

5298: END IF;
5299:
5300: IF l_debug_mode = 'Y' THEN
5301: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Curr_Consistency';
5302: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
5303: Pa_Debug.reset_curr_function;
5304: END IF;
5305: EXCEPTION
5306: WHEN OTHERS THEN

Line 5303: Pa_Debug.reset_curr_function;

5299:
5300: IF l_debug_mode = 'Y' THEN
5301: Pa_Debug.g_err_stage:= 'Exiting Check_Perf_Curr_Consistency';
5302: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level3);
5303: Pa_Debug.reset_curr_function;
5304: END IF;
5305: EXCEPTION
5306: WHEN OTHERS THEN
5307: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

5313: ,p_procedure_name => 'Check_Perf_Curr_Consistency'
5314: ,p_error_text => x_msg_data);
5315:
5316: IF l_debug_mode = 'Y' THEN
5317: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
5318: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
5319: Pa_Debug.reset_curr_function;
5320: END IF;
5321: RAISE;

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

5314: ,p_error_text => x_msg_data);
5315:
5316: IF l_debug_mode = 'Y' THEN
5317: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
5318: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
5319: Pa_Debug.reset_curr_function;
5320: END IF;
5321: RAISE;
5322: END Check_Perf_Curr_Consistency;

Line 5319: Pa_Debug.reset_curr_function;

5315:
5316: IF l_debug_mode = 'Y' THEN
5317: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
5318: Pa_Debug.WRITE(l_module_name,Pa_Debug.g_err_stage,l_debug_level5);
5319: Pa_Debug.reset_curr_function;
5320: END IF;
5321: RAISE;
5322: END Check_Perf_Curr_Consistency;
5323: