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 2007/02/06 10:14:23 dthakker noship $
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 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 402: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'

398: WHEN PJI_EXCEPTION THEN
399: x_return_status := 'U';
400: x_msg_count := 1;
401: fnd_msg_pub.add_exc_msg
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;

Line 415: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'

411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: x_msg_data := SQLCODE||SQLERRM;
413: x_msg_count := 1;
414: fnd_msg_pub.add_exc_msg
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;

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

524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: x_msg_data := SQLCODE||SQLERRM;
526: x_msg_count := 1;
527: fnd_msg_pub.add_exc_msg
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;

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

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

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

1220: WHEN PJI_EXCEPTION THEN
1221: x_return_status := 'U';
1222: x_msg_count := 1;
1223: fnd_msg_pub.add_exc_msg
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;

Line 1237: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'

1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: x_msg_data := SQLCODE||SQLERRM;
1235: x_msg_count := 1;
1236: fnd_msg_pub.add_exc_msg
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;

Line 1247: END PA_FP_PJI_INTG_PKG;

1243: RAISE;
1244:
1245: END blk_update_reporting_lines;
1246:
1247: END PA_FP_PJI_INTG_PKG;