DBA Data[Home] [Help]

APPS.PA_FP_PJI_INTG_PKG dependencies on PA_DEBUG

Line 13: --IF P_PA_DEBUG_MODE = 'Y' Then

9:
10: pragma autonomous_transaction ;
11: BEGIN
12: --dbms_output.put_line(p_msg);
13: --IF P_PA_DEBUG_MODE = 'Y' Then
14: NULL;
15: INSERT INTO PA_FP_CALCULATE_LOG
16: (SESSIONID
17: ,SEQ_NUMBER

Line 35: pa_debug.g_err_stage := substr('LOG:'||p_msg,1,240);

31:
32: BEGIN
33: --calc_log(p_msg);
34: If (NVL(p_debug_flag,'N') = 'Y' OR g_debug_flag = 'Y') Then
35: pa_debug.g_err_stage := substr('LOG:'||p_msg,1,240);
36: PA_DEBUG.write
37: (x_Module => 'PA_FP_PJI_INTG_PKG'
38: ,x_Msg => pa_debug.g_err_stage
39: ,x_Log_Level => 3);

Line 36: PA_DEBUG.write

32: BEGIN
33: --calc_log(p_msg);
34: If (NVL(p_debug_flag,'N') = 'Y' OR g_debug_flag = 'Y') Then
35: pa_debug.g_err_stage := substr('LOG:'||p_msg,1,240);
36: PA_DEBUG.write
37: (x_Module => 'PA_FP_PJI_INTG_PKG'
38: ,x_Msg => pa_debug.g_err_stage
39: ,x_Log_Level => 3);
40: End If;

Line 38: ,x_Msg => pa_debug.g_err_stage

34: If (NVL(p_debug_flag,'N') = 'Y' OR g_debug_flag = 'Y') Then
35: pa_debug.g_err_stage := substr('LOG:'||p_msg,1,240);
36: PA_DEBUG.write
37: (x_Module => 'PA_FP_PJI_INTG_PKG'
38: ,x_Msg => pa_debug.g_err_stage
39: ,x_Log_Level => 3);
40: End If;
41: END;
42:

Line 155: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

151: x_msg_data := Null;
152:
153: l_stage := 10;
154: /* Initialize the error stack */
155: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
156: g_debug_flag := l_debug_flag;
157: If g_debug_flag = 'Y' Then
158: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.update_reporting_lines');
159: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

Line 158: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.update_reporting_lines');

154: /* Initialize the error stack */
155: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
156: g_debug_flag := l_debug_flag;
157: If g_debug_flag = 'Y' Then
158: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.update_reporting_lines');
159: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
160: ,x_write_file => 'LOG'
161: ,x_debug_mode => l_debug_flag
162: );

Line 159: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

155: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
156: g_debug_flag := l_debug_flag;
157: If g_debug_flag = 'Y' Then
158: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.update_reporting_lines');
159: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
160: ,x_write_file => 'LOG'
161: ,x_debug_mode => l_debug_flag
162: );
163: End If;

Line 389: pa_debug.reset_err_stack;

385: x_return_status := l_return_status;
386: print_msg('End of updateReportingLines api retSts['||x_return_status||']');
387: --reset the error stack;
388: If g_debug_flag = 'Y' Then
389: pa_debug.reset_err_stack;
390: End If;
391:
392: EXCEPTION
393: WHEN INVALID_PARAMS THEN

Line 406: pa_debug.reset_err_stack;

402: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'
403: ,p_procedure_name => 'update_reporting_lines:Error Occured in plan_update' );
404: print_msg(l_stage||'Error occured in update_reporting_lines:Error Occured in plan_update ['||x_msg_data||']','Y');
405: If g_debug_flag = 'Y' Then
406: pa_debug.reset_err_stack;
407: End If;
408: RAISE;
409:
410: WHEN OTHERS THEN

Line 419: pa_debug.reset_err_stack;

415: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'
416: ,p_procedure_name => 'update_reporting_lines' );
417: print_msg(l_stage||'Error occured in update_reporting_lines['|| substr(SQLERRM,1,240),'Y');
418: If g_debug_flag = 'Y' Then
419: pa_debug.reset_err_stack;
420: End If;
421: RAISE;
422:
423: END update_reporting_lines;

Line 460: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

456: x_msg_data := Null;
457:
458: /* Initialize the error stack */
459: l_stage := 10;
460: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
461: g_debug_flag := l_debug_flag;
462: If g_debug_flag = 'Y' Then
463: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.update_reporting_lines_frombl');
464: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

Line 463: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.update_reporting_lines_frombl');

459: l_stage := 10;
460: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
461: g_debug_flag := l_debug_flag;
462: If g_debug_flag = 'Y' Then
463: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.update_reporting_lines_frombl');
464: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
465: ,x_write_file => 'LOG'
466: ,x_debug_mode => l_debug_flag
467: );

Line 464: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

460: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
461: g_debug_flag := l_debug_flag;
462: If g_debug_flag = 'Y' Then
463: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.update_reporting_lines_frombl');
464: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
465: ,x_write_file => 'LOG'
466: ,x_debug_mode => l_debug_flag
467: );
468: End If;

Line 515: pa_debug.reset_err_stack;

511: x_return_status := l_return_status;
512: print_msg('End of updateReportingLines_frombl api retSts['||x_return_status||']');
513: --reset the error stack;
514: If g_debug_flag = 'Y' Then
515: pa_debug.reset_err_stack;
516: End If;
517: EXCEPTION
518: WHEN INVALID_PARAMS THEN
519: x_return_status := 'E';

Line 532: pa_debug.reset_err_stack;

528: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'
529: ,p_procedure_name => 'update_reporting_lines_from_bl' );
530: print_msg(l_stage||'Error occured in update_reporting_lines_frombl['|| substr(SQLERRM,1,240),'Y');
531: If g_debug_flag = 'Y' Then
532: pa_debug.reset_err_stack;
533: End If;
534: RAISE;
535: END update_reporting_lines_frombl;
536:

Line 699: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

695: x_msg_data := Null;
696:
697: l_stage := 10;
698: /* Initialize the error stack */
699: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
700: g_debug_flag := l_debug_flag;
701: print_msg('Entered PA_FP_PJI_INTG_PKG.blk_update_reporting_lines api: Num of Trxns['||p_rep_res_assignment_id_tab.count||']','Y');
702: If g_debug_flag = 'Y' Then
703: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.blk_update_reporting_lines');

Line 703: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.blk_update_reporting_lines');

699: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
700: g_debug_flag := l_debug_flag;
701: print_msg('Entered PA_FP_PJI_INTG_PKG.blk_update_reporting_lines api: Num of Trxns['||p_rep_res_assignment_id_tab.count||']','Y');
702: If g_debug_flag = 'Y' Then
703: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.blk_update_reporting_lines');
704: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
705: ,x_write_file => 'LOG'
706: ,x_debug_mode => l_debug_flag
707: );

Line 704: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

700: g_debug_flag := l_debug_flag;
701: print_msg('Entered PA_FP_PJI_INTG_PKG.blk_update_reporting_lines api: Num of Trxns['||p_rep_res_assignment_id_tab.count||']','Y');
702: If g_debug_flag = 'Y' Then
703: pa_debug.init_err_stack('PA_FP_PJI_INTG_PKG.blk_update_reporting_lines');
704: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
705: ,x_write_file => 'LOG'
706: ,x_debug_mode => l_debug_flag
707: );
708: End If;

Line 1211: pa_debug.reset_err_stack;

1207: print_msg('End of blk_update_reporting_lines api retSts['||x_return_status||']');
1208: End If;
1209: --reset the error stack;
1210: If g_debug_flag = 'Y' Then
1211: pa_debug.reset_err_stack;
1212: End If;
1213:
1214: EXCEPTION
1215: WHEN INVALID_PARAMS THEN

Line 1228: pa_debug.reset_err_stack;

1224: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'
1225: ,p_procedure_name => 'blk_update_reporting_lines:Error Occured in plan_update' );
1226: print_msg(l_stage||'Error occured in blk_update_reporting_lines:Error Occured in plan_update ['||x_msg_data||']','Y');
1227: If g_debug_flag = 'Y' Then
1228: pa_debug.reset_err_stack;
1229: End If;
1230: -- Bug 4621171: Removed RAISE statement.
1231:
1232: WHEN OTHERS THEN

Line 1241: pa_debug.reset_err_stack;

1237: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'
1238: ,p_procedure_name => 'update_reporting_lines' );
1239: print_msg(l_stage||'Error occured in blk_update_reporting_lines['|| substr(SQLERRM,1,240),'Y');
1240: If g_debug_flag = 'Y' Then
1241: pa_debug.reset_err_stack;
1242: End If;
1243: RAISE;
1244:
1245: END blk_update_reporting_lines;