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 156: l_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

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

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

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

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

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

Line 392: pa_debug.reset_err_stack;

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

Line 409: pa_debug.reset_err_stack;

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

Line 422: pa_debug.reset_err_stack;

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

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

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

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

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

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

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

Line 518: pa_debug.reset_err_stack;

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

Line 535: pa_debug.reset_err_stack;

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

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

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

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

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

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

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

Line 1223: pa_debug.reset_err_stack;

1219: print_msg('End of blk_update_reporting_lines api retSts['||x_return_status||']');
1220: End If;
1221: --reset the error stack;
1222: If g_debug_flag = 'Y' Then
1223: pa_debug.reset_err_stack;
1224: End If;
1225:
1226: EXCEPTION
1227: WHEN INVALID_PARAMS THEN

Line 1240: pa_debug.reset_err_stack;

1236: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'
1237: ,p_procedure_name => 'blk_update_reporting_lines:Error Occured in plan_update' );
1238: print_msg(l_stage||'Error occured in blk_update_reporting_lines:Error Occured in plan_update ['||x_msg_data||']','Y');
1239: If g_debug_flag = 'Y' Then
1240: pa_debug.reset_err_stack;
1241: End If;
1242: -- Bug 4621171: Removed RAISE statement.
1243:
1244: WHEN OTHERS THEN

Line 1253: pa_debug.reset_err_stack;

1249: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'
1250: ,p_procedure_name => 'update_reporting_lines' );
1251: print_msg(l_stage||'Error occured in blk_update_reporting_lines['|| substr(SQLERRM,1,240),'Y');
1252: If g_debug_flag = 'Y' Then
1253: pa_debug.reset_err_stack;
1254: End If;
1255: RAISE;
1256:
1257: END blk_update_reporting_lines;