DBA Data[Home] [Help]

APPS.PA_BUDGET_UTILS dependencies on FND_MSG_PUB

Line 2496: FND_MSG_PUB.Add_Exc_Msg

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

Line 2513: FND_MSG_PUB.Add_Exc_Msg

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

Line 2798: FND_MSG_PUB.Add_Exc_Msg

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

Line 2804: p_err_msg_count := FND_MSG_PUB.Count_Msg;

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

Line 2844: FND_MSG_PUB.Add_Exc_Msg

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

Line 2850: p_err_msg_count := FND_MSG_PUB.Count_Msg;

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

Line 2880: p_err_msg_count := FND_MSG_PUB.Count_Msg;

2876: THEN
2877: p_warnings_only_flag := 'N';
2878: END IF;
2879: IF (p_err_code < 0) THEN
2880: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2881: RETURN;
2882: END IF;
2883:
2884: elsif ( (l_approved_code IN ('AC','ALL') )

Line 2936: p_err_msg_count := FND_MSG_PUB.Count_Msg;

2932: p_warnings_only_flag := 'N';
2933: END IF;
2934: END IF;
2935:
2936: p_err_msg_count := FND_MSG_PUB.Count_Msg;
2937: p_err_stack := l_old_stack;
2938:
2939: EXCEPTION
2940: WHEN FND_API.G_EXC_ERROR

Line 2943: FND_MSG_PUB.Add_Exc_Msg

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

Line 2949: p_err_msg_count := FND_MSG_PUB.Count_Msg;

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

Line 2953: FND_MSG_PUB.Add_Exc_Msg

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

Line 2959: p_err_msg_count := FND_MSG_PUB.Count_Msg;

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

Line 2962: FND_MSG_PUB.Add_Exc_Msg

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

Line 2968: p_err_msg_count := FND_MSG_PUB.Count_Msg;

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

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

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

Line 3171: FND_MSG_PUB.add_exc_msg

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

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

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

Line 3183: FND_MSG_PUB.add;

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

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

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

Line 3220: FND_MSG_PUB.add_exc_msg

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

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

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

Line 3232: FND_MSG_PUB.add;

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

Line 3292: FND_MSG_PUB.add;

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

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

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

Line 3358: FND_MSG_PUB.add_exc_msg

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

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

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

Line 3370: FND_MSG_PUB.add;

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

Line 3446: FND_MSG_PUB.Count_And_Get

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

Line 3456: FND_MSG_PUB.Count_And_Get

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

Line 3482: FND_MSG_PUB.Add_Exc_Msg

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

Line 3487: FND_MSG_PUB.Count_And_Get

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

Line 3842: FND_MSG_PUB.Add_Exc_Msg

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

Line 3847: FND_MSG_PUB.Count_And_Get

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

Line 3934: FND_MSG_PUB.Add_Exc_Msg

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

Line 3939: FND_MSG_PUB.Count_And_Get

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

Line 4111: FND_MSG_PUB.Add_Exc_Msg

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

Line 4116: FND_MSG_PUB.Count_And_Get

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

Line 4254: FND_MSG_PUB.Add_Exc_Msg

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

Line 4259: FND_MSG_PUB.Count_And_Get

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