DBA Data[Home] [Help]

APPS.PA_BUDGET_UTILS dependencies on FND_MSG_PUB

Line 2492: FND_MSG_PUB.Add_Exc_Msg

2488: exception
2489: WHEN FND_API.G_EXC_ERROR
2490: THEN
2491: x_err_code := SQLCODE;
2492: FND_MSG_PUB.Add_Exc_Msg
2493: ( p_pkg_name => 'PA_BUDGET_UTILS'
2494: , p_procedure_name => 'CREATE_LINE'
2495: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2496: );

Line 2509: FND_MSG_PUB.Add_Exc_Msg

2505: IF P_PA_DEBUG_MODE = 'Y' THEN
2506: pa_debug.g_err_stage:= 'In exception of create_line -2 '||substr(SQLERRM,1,100);
2507: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2508: END IF;
2509: FND_MSG_PUB.Add_Exc_Msg
2510: ( p_pkg_name => 'PA_BUDGET_UTILS'
2511: , p_procedure_name => 'CREATE_LINE'
2512: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2513: );

Line 2794: FND_MSG_PUB.Add_Exc_Msg

2790:
2791:
2792: WHEN OTHERS THEN
2793: p_err_code := SQLCODE;
2794: FND_MSG_PUB.Add_Exc_Msg
2795: ( p_pkg_name => 'PA_BUDGET_UTILS'
2796: , p_procedure_name => 'VERIFY_BUDGET_RULES'
2797: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2798: );

Line 2800: p_err_msg_count := FND_MSG_PUB.Count_Msg;

2796: , p_procedure_name => 'VERIFY_BUDGET_RULES'
2797: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2798: );
2799: p_warnings_only_flag := 'N';
2800: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2801: RETURN;
2802: END;
2803:
2804: -- do extra check for revenue budget

Line 2840: FND_MSG_PUB.Add_Exc_Msg

2836: -- budget at project level
2837: l_entry_level_code := 'P';
2838: WHEN OTHERS THEN
2839: p_err_code := SQLCODE;
2840: FND_MSG_PUB.Add_Exc_Msg
2841: ( p_pkg_name => 'PA_BUDGET_UTILS'
2842: , p_procedure_name => 'VERIFY_BUDGET_RULES'
2843: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2844: );

Line 2846: p_err_msg_count := FND_MSG_PUB.Count_Msg;

2842: , p_procedure_name => 'VERIFY_BUDGET_RULES'
2843: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2844: );
2845: p_warnings_only_flag := 'N';
2846: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2847: RETURN;
2848: END;
2849:
2850: end if;

Line 2876: p_err_msg_count := FND_MSG_PUB.Count_Msg;

2872: THEN
2873: p_warnings_only_flag := 'N';
2874: END IF;
2875: IF (p_err_code < 0) THEN
2876: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2877: RETURN;
2878: END IF;
2879:
2880: elsif ( (l_approved_code IN ('AC','ALL') )

Line 2932: p_err_msg_count := FND_MSG_PUB.Count_Msg;

2928: p_warnings_only_flag := 'N';
2929: END IF;
2930: END IF;
2931:
2932: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2933: p_err_stack := l_old_stack;
2934:
2935: EXCEPTION
2936: WHEN FND_API.G_EXC_ERROR

Line 2939: FND_MSG_PUB.Add_Exc_Msg

2935: EXCEPTION
2936: WHEN FND_API.G_EXC_ERROR
2937: THEN
2938: p_err_code := SQLCODE;
2939: FND_MSG_PUB.Add_Exc_Msg
2940: ( p_pkg_name => 'PA_BUDGET_UTILS'
2941: , p_procedure_name => 'VERIFY_BUDGET_RULES'
2942: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2943: );

Line 2945: p_err_msg_count := FND_MSG_PUB.Count_Msg;

2941: , p_procedure_name => 'VERIFY_BUDGET_RULES'
2942: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2943: );
2944: p_warnings_only_flag := 'N';
2945: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2947: THEN
2948: p_err_code := SQLCODE;
2949: FND_MSG_PUB.Add_Exc_Msg

Line 2949: FND_MSG_PUB.Add_Exc_Msg

2945: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2947: THEN
2948: p_err_code := SQLCODE;
2949: FND_MSG_PUB.Add_Exc_Msg
2950: ( p_pkg_name => 'PA_BUDGET_UTILS'
2951: , p_procedure_name => 'VERIFY_BUDGET_RULES'
2952: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2953: );

Line 2955: p_err_msg_count := FND_MSG_PUB.Count_Msg;

2951: , p_procedure_name => 'VERIFY_BUDGET_RULES'
2952: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2953: );
2954: p_warnings_only_flag := 'N';
2955: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2956: WHEN OTHERS THEN
2957: p_err_code := SQLCODE;
2958: FND_MSG_PUB.Add_Exc_Msg
2959: ( p_pkg_name => 'PA_BUDGET_UTILS'

Line 2958: FND_MSG_PUB.Add_Exc_Msg

2954: p_warnings_only_flag := 'N';
2955: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2956: WHEN OTHERS THEN
2957: p_err_code := SQLCODE;
2958: FND_MSG_PUB.Add_Exc_Msg
2959: ( p_pkg_name => 'PA_BUDGET_UTILS'
2960: , p_procedure_name => 'VERIFY_BUDGET_RULES'
2961: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2962: );

Line 2964: p_err_msg_count := FND_MSG_PUB.Count_Msg;

2960: , p_procedure_name => 'VERIFY_BUDGET_RULES'
2961: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
2962: );
2963: p_warnings_only_flag := 'N';
2964: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2965: RETURN;
2966:
2967: END Verify_Budget_Rules;
2968:

Line 3165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3161:
3162: -- Process Baseline Error. Rollback ANY Error
3163: IF (l_err_code < 0)
3164: THEN
3165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3166: THEN
3167: FND_MSG_PUB.add_exc_msg
3168: ( p_pkg_name => 'PA_BUDGET_UTILS'
3169: , p_procedure_name => 'BASELINE_BUDGET'

Line 3167: FND_MSG_PUB.add_exc_msg

3163: IF (l_err_code < 0)
3164: THEN
3165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3166: THEN
3167: FND_MSG_PUB.add_exc_msg
3168: ( p_pkg_name => 'PA_BUDGET_UTILS'
3169: , p_procedure_name => 'BASELINE_BUDGET'
3170: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0')
3171: );

Line 3176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3172: END IF;
3173: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3174: ELSE
3175: -- l_err_code > 0
3176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3177: THEN
3178: FND_MESSAGE.SET_NAME('PA','PA_BASELINE_FAILED');
3179: FND_MSG_PUB.add;
3180: END IF;

Line 3179: FND_MSG_PUB.add;

3175: -- l_err_code > 0
3176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3177: THEN
3178: FND_MESSAGE.SET_NAME('PA','PA_BASELINE_FAILED');
3179: FND_MSG_PUB.add;
3180: END IF;
3181: l_return_status := FND_API.G_RET_STS_ERROR;
3182: END IF; -- (l_err_code < 0)
3183:

Line 3214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3210:
3211: -- Process Baseline Error. Rollback ANY Error
3212: IF (l_err_code < 0)
3213: THEN
3214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3215: THEN
3216: FND_MSG_PUB.add_exc_msg
3217: ( p_pkg_name => 'PA_BUDGET_UTILS'
3218: , p_procedure_name => 'BASELINE_BUDGET'

Line 3216: FND_MSG_PUB.add_exc_msg

3212: IF (l_err_code < 0)
3213: THEN
3214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3215: THEN
3216: FND_MSG_PUB.add_exc_msg
3217: ( p_pkg_name => 'PA_BUDGET_UTILS'
3218: , p_procedure_name => 'BASELINE_BUDGET'
3219: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0')
3220: );

Line 3225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3221: END IF;
3222: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3223: ELSE
3224: -- l_err_code > 0
3225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3226: THEN
3227: FND_MESSAGE.SET_NAME('PA','PA_BASELINE_FAILED');
3228: FND_MSG_PUB.add;
3229: END IF;

Line 3228: FND_MSG_PUB.add;

3224: -- l_err_code > 0
3225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3226: THEN
3227: FND_MESSAGE.SET_NAME('PA','PA_BASELINE_FAILED');
3228: FND_MSG_PUB.add;
3229: END IF;
3230: l_return_status := FND_API.G_RET_STS_ERROR;
3231: END IF; -- (l_err_code < 0)
3232:

Line 3288: FND_MSG_PUB.add;

3284: THEN
3285: -- R12 SLA Effort, Phase II
3286: -- Add Success message to message stack.
3287: FND_MESSAGE.SET_NAME('PA','PA_NFSUBJ_BU_INTG_SUCCESS');
3288: FND_MSG_PUB.add;
3289: END IF;
3290:
3291: /*Start - Changes for Federal Uptake - I */ -- Bug 5522880
3292:

Line 3352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3348: -- Process Baseline Error. Rollback ANY Error
3349:
3350: IF (l_err_code < 0)
3351: THEN
3352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3353: THEN
3354: FND_MSG_PUB.add_exc_msg
3355: ( p_pkg_name => 'PA_BUDGET_UTILS'
3356: , p_procedure_name => 'BASELINE_BUDGET'

Line 3354: FND_MSG_PUB.add_exc_msg

3350: IF (l_err_code < 0)
3351: THEN
3352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3353: THEN
3354: FND_MSG_PUB.add_exc_msg
3355: ( p_pkg_name => 'PA_BUDGET_UTILS'
3356: , p_procedure_name => 'BASELINE_BUDGET'
3357: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0')
3358: );

Line 3363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3359: END IF;
3360: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3361: ELSE
3362: -- l_err_code > 0
3363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3364: THEN
3365: FND_MESSAGE.SET_NAME('PA','PA_BASELINE_FAILED');
3366: FND_MSG_PUB.add;
3367: END IF;

Line 3366: FND_MSG_PUB.add;

3362: -- l_err_code > 0
3363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3364: THEN
3365: FND_MESSAGE.SET_NAME('PA','PA_BASELINE_FAILED');
3366: FND_MSG_PUB.add;
3367: END IF;
3368: l_return_status := FND_API.G_RET_STS_ERROR;
3369: END IF; -- (l_err_code < 0)
3370:

Line 3442: FND_MSG_PUB.Count_And_Get

3438: THEN
3439: ROLLBACK TO baseline_budget_wrappper;
3440: x_return_status := FND_API.G_RET_STS_ERROR;
3441: --fix done for Bug 6408021
3442: FND_MSG_PUB.Count_And_Get
3443: (p_count => x_msg_count ,
3444: p_data => x_msg_data );
3445:
3446:

Line 3452: FND_MSG_PUB.Count_And_Get

3448: THEN
3449: ROLLBACK TO baseline_budget_wrappper;
3450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3451: --fix done for Bug 6408021
3452: FND_MSG_PUB.Count_And_Get
3453: (p_count => x_msg_count ,
3454: p_data => x_msg_data );
3455:
3456: WHEN L_BEM_FAILED

Line 3478: FND_MSG_PUB.Add_Exc_Msg

3474: WHEN OTHERS
3475: THEN
3476: ROLLBACK TO baseline_budget_wrappper;
3477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3478: FND_MSG_PUB.Add_Exc_Msg
3479: ( p_pkg_name => 'PA_BUDGET_UTILS'
3480: , p_procedure_name => 'BASELINE_BUDGET'
3481: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
3482: );

Line 3483: FND_MSG_PUB.Count_And_Get

3479: ( p_pkg_name => 'PA_BUDGET_UTILS'
3480: , p_procedure_name => 'BASELINE_BUDGET'
3481: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
3482: );
3483: FND_MSG_PUB.Count_And_Get
3484: (p_count => x_msg_count
3485: , p_data => x_msg_data );
3486:
3487:

Line 3838: FND_MSG_PUB.Add_Exc_Msg

3834: EXCEPTION
3835: WHEN OTHERS
3836: THEN
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3838: FND_MSG_PUB.Add_Exc_Msg
3839: ( p_pkg_name => 'PA_BUDGET_UTILS'
3840: , p_procedure_name => 'GET_VERSION_APPROVED_CODE'
3841: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
3842: );

Line 3843: FND_MSG_PUB.Count_And_Get

3839: ( p_pkg_name => 'PA_BUDGET_UTILS'
3840: , p_procedure_name => 'GET_VERSION_APPROVED_CODE'
3841: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
3842: );
3843: FND_MSG_PUB.Count_And_Get
3844: (p_count => x_msg_count ,
3845: p_data => x_msg_data );
3846: RETURN;
3847:

Line 3930: FND_MSG_PUB.Add_Exc_Msg

3926: EXCEPTION
3927: WHEN OTHERS
3928: THEN
3929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3930: FND_MSG_PUB.Add_Exc_Msg
3931: ( p_pkg_name => 'PA_BUDGET_UTILS'
3932: , p_procedure_name => 'GET_PROJECT_CURRENCY_INFO'
3933: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
3934: );

Line 3935: FND_MSG_PUB.Count_And_Get

3931: ( p_pkg_name => 'PA_BUDGET_UTILS'
3932: , p_procedure_name => 'GET_PROJECT_CURRENCY_INFO'
3933: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
3934: );
3935: FND_MSG_PUB.Count_And_Get
3936: (p_count => x_msg_count ,
3937: p_data => x_msg_data );
3938: RETURN;
3939:

Line 4107: FND_MSG_PUB.Add_Exc_Msg

4103: EXCEPTION
4104: WHEN OTHERS
4105: THEN
4106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4107: FND_MSG_PUB.Add_Exc_Msg
4108: ( p_pkg_name => 'PA_BUDGET_UTILS'
4109: , p_procedure_name => 'GET_APPROVED_FP_INFO'
4110: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
4111: );

Line 4112: FND_MSG_PUB.Count_And_Get

4108: ( p_pkg_name => 'PA_BUDGET_UTILS'
4109: , p_procedure_name => 'GET_APPROVED_FP_INFO'
4110: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
4111: );
4112: FND_MSG_PUB.Count_And_Get
4113: (p_count => x_msg_count ,
4114: p_data => x_msg_data );
4115: RETURN;
4116:

Line 4250: FND_MSG_PUB.Add_Exc_Msg

4246: EXCEPTION
4247: WHEN OTHERS THEN
4248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4249: x_err_code := SQLCODE;
4250: FND_MSG_PUB.Add_Exc_Msg
4251: ( p_pkg_name => 'PA_BUDGET_UTILS'
4252: , p_procedure_name => 'SET_PRJ_POLICY_cONTEXT'
4253: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
4254: );

Line 4255: FND_MSG_PUB.Count_And_Get

4251: ( p_pkg_name => 'PA_BUDGET_UTILS'
4252: , p_procedure_name => 'SET_PRJ_POLICY_cONTEXT'
4253: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
4254: );
4255: FND_MSG_PUB.Count_And_Get
4256: (p_count => x_msg_count ,
4257: p_data => x_msg_data );
4258: RETURN;
4259: