DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_UTILS dependencies on PA_FP_WEBADI_UTILS

Line 1: PACKAGE BODY pa_fp_webadi_utils as

1: PACKAGE BODY pa_fp_webadi_utils as
2: /* $Header: PAFPWAUB.pls 120.14.12010000.2 2008/08/26 23:31:31 jngeorge ship $*/
3: /***************************************************************/
4: /*This procedure is called to return the layout code based on */
5: /* p_budget_version_id. */

Line 13: g_module_name VARCHAR2(30) := 'pa.plsql.PA_FP_WEBADI_UTILS';

9: G_TABLE_POPULATED VARCHAR2(1) := 'N' ;
10: G_TXN_CURRENCY_CODE_TBL PA_FP_WEBADI_PKG.l_txn_currency_code_tbl_typ ;
11:
12:
13: g_module_name VARCHAR2(30) := 'pa.plsql.PA_FP_WEBADI_UTILS';
14:
15: l_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
16:
17: PROCEDURE get_metadata_info(

Line 361: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_utils'

357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: x_msg_count := 1;
359: x_msg_data := SQLERRM;
360:
361: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_utils'
362: ,p_procedure_name => 'get_metadata_info');
363:
364: IF l_debug_mode = 'Y' THEN
365: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 816: pa_debug.g_err_stage := ':In PA_FP_WEBADI_UTILS.GET_RES_ASSIGNMENT_INFO' ;

812: ,p_debug_mode => l_debug_mode );
813: END IF;
814:
815: IF l_debug_mode = 'Y' THEN
816: pa_debug.g_err_stage := ':In PA_FP_WEBADI_UTILS.GET_RES_ASSIGNMENT_INFO' ;
817: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
818: END IF;
819:
820: IF ((p_resource_assignment_id IS NULL) OR (p_planning_level IS NULL)) THEN

Line 835: pa_debug.g_err_stage := 'PA_FP_WEBADI_UTILS.GET_RES_ASSIGNMENT_INFO';

831: END IF;
832:
833:
834: IF l_debug_mode = 'Y' THEN
835: pa_debug.g_err_stage := 'PA_FP_WEBADI_UTILS.GET_RES_ASSIGNMENT_INFO';
836: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
837: END IF ;
838:
839: IF (p_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) THEN

Line 927: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'

923: x_msg_count := 1;
924: x_msg_data := SQLERRM;
925:
926: FND_MSG_PUB.add_exc_msg
927: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'
928: ,p_procedure_name => 'GET_RES_ASSIGNMENT_INFO'
929: ,p_error_text => sqlerrm);
930:
931:

Line 970: pa_debug.set_err_stack('PA_FP_WEBADI_UTILS.VALIDATE_CHANGE_REASON_CODE');

966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
968:
969: IF l_debug_mode = 'Y' THEN
970: pa_debug.set_err_stack('PA_FP_WEBADI_UTILS.VALIDATE_CHANGE_REASON_CODE');
971: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
972: END IF;
973:
974: -- Check for business rules violations

Line 1043: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'

1039: x_msg_count := 1;
1040: x_msg_data := SQLERRM;
1041:
1042: FND_MSG_PUB.add_exc_msg
1043: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'
1044: ,p_procedure_name => 'VALIDATE_CHANGE_REASON_CODE'
1045: ,p_error_text => sqlerrm);
1046:
1047: pa_debug.G_Err_Stack := SQLERRM;

Line 1088: pa_debug.set_err_stack('PA_FP_WEBADI_UTILS.VALIDATE_TXN_CURRENCY_CODE');

1084: x_return_status := FND_API.G_RET_STS_SUCCESS;
1085: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1086:
1087: IF l_debug_mode = 'Y' THEN
1088: pa_debug.set_err_stack('PA_FP_WEBADI_UTILS.VALIDATE_TXN_CURRENCY_CODE');
1089: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1090: END IF;
1091:
1092: -- Check for business rules violations

Line 1205: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'

1201: END IF ;
1202:
1203:
1204: FND_MSG_PUB.add_exc_msg
1205: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'
1206: ,p_procedure_name => 'VALIDATE_TXN_CURRENCY_CODE'
1207: ,p_error_text => sqlerrm);
1208:
1209: pa_debug.G_Err_Stack := SQLERRM;

Line 2031: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'

2027: x_msg_count := 1;
2028: x_msg_data := SQLERRM;
2029:
2030: FND_MSG_PUB.add_exc_msg
2031: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'
2032: ,p_procedure_name => 'GET_ERROR_LOOKUP_CODE'
2033: ,p_error_text => x_msg_data);
2034:
2035: IF l_debug_mode = 'Y' THEN

Line 2237: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'

2233: x_msg_count := 1;
2234: x_msg_data := SQLERRM;
2235:
2236: FND_MSG_PUB.add_exc_msg
2237: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'
2238: ,p_procedure_name => 'CONV_MC_ATTR_MEANING_TO_CODE'
2239: ,p_error_text => x_msg_data);
2240:
2241: IF l_debug_mode = 'Y' THEN

Line 2309: p_function =>'pa_fp_webadi_utils.get_layout_details'

2305: l_debug_mode := NVL(l_debug_mode, 'Y');
2306:
2307: -- Set curr function
2308: pa_debug.set_curr_function(
2309: p_function =>'pa_fp_webadi_utils.get_layout_details'
2310: ,p_debug_mode => l_debug_mode );
2311:
2312: IF l_debug_mode = 'Y' THEN
2313: pa_debug.g_err_stage:='Validating input parameters';

Line 2394: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_utils'

2390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2391: x_msg_count := 1;
2392: x_msg_data := SQLERRM;
2393:
2394: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_utils'
2395: ,p_procedure_name => 'get_layout_details');
2396:
2397: IF l_debug_mode = 'Y' THEN
2398: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2681: pa_debug.write_file ('PA_FP_WEBADI_UTILS ' || pa_debug.g_err_stage);

2677: x_new_request_id := l_new_request_id;
2678: ELSIF l_new_request_id > 0 THEN
2679: pa_debug.g_err_stage := 'plan data processing Request Id is'||TO_CHAR (l_new_request_id);
2680: IF l_debug_mode = 'Y' THEN
2681: pa_debug.write_file ('PA_FP_WEBADI_UTILS ' || pa_debug.g_err_stage);
2682: END IF;
2683:
2684: IF l_debug_mode = 'Y' THEN
2685: pa_debug.g_err_stage:='Updating pa_budget_versions';

Line 3406: END PA_FP_WEBADI_UTILS;

3402: end;
3403:
3404:
3405:
3406: END PA_FP_WEBADI_UTILS;