DBA Data[Home] [Help]

APPS.PA_FP_PJI_INTG_PKG dependencies on PA_FP_PJI_INTG_PKG

Line 1: PACKAGE BODY PA_FP_PJI_INTG_PKG AS

1: PACKAGE BODY PA_FP_PJI_INTG_PKG AS
2: --$Header: PAFPUT4B.pls 120.4.12020000.2 2013/03/08 18:55:56 sachandr ship $
3:
4: /* Declare global variables*/
5: g_debug_flag Varchar2(10) ;

Line 37: (x_Module => 'PA_FP_PJI_INTG_PKG'

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;
41: END;

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 405: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'

401: WHEN PJI_EXCEPTION THEN
402: x_return_status := 'U';
403: x_msg_count := 1;
404: fnd_msg_pub.add_exc_msg
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;

Line 418: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'

414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: x_msg_data := SQLCODE||SQLERRM;
416: x_msg_count := 1;
417: fnd_msg_pub.add_exc_msg
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;

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 531: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'

527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: x_msg_data := SQLCODE||SQLERRM;
529: x_msg_count := 1;
530: fnd_msg_pub.add_exc_msg
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;

Line 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');

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');
709: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
710: ,x_write_file => 'LOG'

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 1236: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'

1232: WHEN PJI_EXCEPTION THEN
1233: x_return_status := 'U';
1234: x_msg_count := 1;
1235: fnd_msg_pub.add_exc_msg
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;

Line 1249: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'

1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: x_msg_data := SQLCODE||SQLERRM;
1247: x_msg_count := 1;
1248: fnd_msg_pub.add_exc_msg
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;

Line 1259: END PA_FP_PJI_INTG_PKG;

1255: RAISE;
1256:
1257: END blk_update_reporting_lines;
1258:
1259: END PA_FP_PJI_INTG_PKG;