DBA Data[Home] [Help]

APPS.PA_BUDGET_FUND_PKG dependencies on PA_DEBUG

Line 644: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

640:
641: EXCEPTION
642: WHEN OTHERS THEN
643: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BUDGET_FUND_PKG'
644: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
645:
646: IF c_delbal%ISOPEN THEN
647: close c_delbal;
648: END IF;

Line 730: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

726: COMMIT;
727: EXCEPTION
728: WHEN OTHERS THEN
729: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BUDGET_FUND_PKG'
730: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
731:
732: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;
733: x_err_message_code := (SQLCODE||' '||SQLERRM);
734: log_message('Create_bgt_lines_in_bc_balance: x_err_message_code'||x_err_message_code);

Line 871: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

867:
868: EXCEPTION
869: WHEN OTHERS THEN
870: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BUDGET_FUND_PKG'
871: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
872:
873: IF c_bdgt_bal%ISOPEN THEN
874: close c_bdgt_bal;
875: END IF;

Line 998: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);

994: -----------------------------------------------+
995: g_procedure_name := 'check_or_reserve_funds';
996: g_project_id := p_project_id;
997:
998: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);
999:
1000: g_debug_mode := nvl(g_debug_mode,'N');
1001:
1002: --- Initialize the error statck

Line 1003: PA_DEBUG.init_err_stack ('PA_BUDGET_FUND_PKG.check_or_reserve_funds');

999:
1000: g_debug_mode := nvl(g_debug_mode,'N');
1001:
1002: --- Initialize the error statck
1003: PA_DEBUG.init_err_stack ('PA_BUDGET_FUND_PKG.check_or_reserve_funds');
1004:
1005: log_message('Entering check_or_reserve_funds API .........') ;
1006:
1007: -- ----------------------------------------------------------------------+

Line 2534: l_temp_ret_status := pa_debug.release_user_lock('BSLNFCHKLOCK:'||to_char(p_project_id));

2530: x_return_status := FND_API.G_RET_STS_SUCCESS;
2531:
2532: log_message('entering release_bc_lock ..... ');
2533:
2534: l_temp_ret_status := pa_debug.release_user_lock('BSLNFCHKLOCK:'||to_char(p_project_id));
2535:
2536: log_message('after release_user_lock ..... ');
2537:
2538: commit;

Line 2588: IF PA_Debug.Acquire_User_Lock(P_Lock_Name)=0 -- Acquired the lock successfully

2584: l_release_lock NUMBER;
2585: PRAGMA AUTONOMOUS_TRANSACTION;
2586:
2587: BEGIN
2588: IF PA_Debug.Acquire_User_Lock(P_Lock_Name)=0 -- Acquired the lock successfully
2589: THEN
2590: l_release_lock := PA_Debug.Release_User_Lock(P_Lock_Name); -- Release the lock
2591: RETURN True;
2592: ELSE

Line 2590: l_release_lock := PA_Debug.Release_User_Lock(P_Lock_Name); -- Release the lock

2586:
2587: BEGIN
2588: IF PA_Debug.Acquire_User_Lock(P_Lock_Name)=0 -- Acquired the lock successfully
2589: THEN
2590: l_release_lock := PA_Debug.Release_User_Lock(P_Lock_Name); -- Release the lock
2591: RETURN True;
2592: ELSE
2593: RETURN False;
2594: END IF;

Line 2799: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);

2795:
2796: If P_calling_module = 'Year_End_Rollover' then
2797:
2798: If nvl(g_debug_mode,'N') = 'N' then
2799: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);
2800: g_debug_mode := nvl(g_debug_mode,'N');
2801: End If;
2802:
2803: log_message(' Set global variables for Year-End processing');

Line 3204: -- Procedure used to call pa_debug.write for FND logging

3200: FND_MSG_PUB.ADD;
3201:
3202: END ADD_MESSAGE;
3203:
3204: -- Procedure used to call pa_debug.write for FND logging
3205: PROCEDURE LOG_MESSAGE(p_message in VARCHAR2)
3206: IS
3207: BEGIN
3208: IF g_debug_mode = 'Y' then

Line 3211: pa_debug.g_err_stage := 'Error Msg :'||substr(p_message,1,250);

3207: BEGIN
3208: IF g_debug_mode = 'Y' then
3209:
3210: IF p_message is NOT NULL then
3211: pa_debug.g_err_stage := 'Error Msg :'||substr(p_message,1,250);
3212: --pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
3213: PA_DEBUG.write
3214: (x_Module => 'pa.plsql.PA_BUDGET_FUND_PKG.'||g_procedure_name
3215: ,x_Msg => substr(p_message,1,240)

Line 3212: --pa_debug.write_file('LOG: '||pa_debug.g_err_stage);

3208: IF g_debug_mode = 'Y' then
3209:
3210: IF p_message is NOT NULL then
3211: pa_debug.g_err_stage := 'Error Msg :'||substr(p_message,1,250);
3212: --pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
3213: PA_DEBUG.write
3214: (x_Module => 'pa.plsql.PA_BUDGET_FUND_PKG.'||g_procedure_name
3215: ,x_Msg => substr(p_message,1,240)
3216: ,x_Log_Level => 3);

Line 3213: PA_DEBUG.write

3209:
3210: IF p_message is NOT NULL then
3211: pa_debug.g_err_stage := 'Error Msg :'||substr(p_message,1,250);
3212: --pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
3213: PA_DEBUG.write
3214: (x_Module => 'pa.plsql.PA_BUDGET_FUND_PKG.'||g_procedure_name
3215: ,x_Msg => substr(p_message,1,240)
3216: ,x_Log_Level => 3);
3217: END IF;