DBA Data[Home] [Help]

APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on FND_PROFILE

Line 3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE BODY Pa_Fp_Control_Items_Utils AS
2: /* $Header: PAFPCIUB.pls 120.15.12020000.2 2012/07/19 09:36:22 admarath ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_CONTROL_ITEM_UTILS';
5:
6: --Bug 5845142. These variables are only for internal usage of check_valid_combo(for cvc) function
7: --and should not be used in other procedures/functions

Line 363: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

359: IF P_PA_DEBUG_MODE = 'Y' THEN
360: pa_debug.init_err_stack('PA_FP_CONTROL_ITEMS_UTILS.get_finplan_ci_type_name');
361: END IF;
362:
363: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
364: l_debug_mode := NVL(l_debug_mode, 'Y');
365:
366: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
367:

Line 415: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

411: IF P_PA_DEBUG_MODE = 'Y' THEN
412: pa_debug.init_err_stack('get_fp_ci_agreement_dtls: ' || 'PA_FP_CONTROL_ITEMS_UTILS.get_fp_ci_agreement_dtls');
413: END IF;
414:
415: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
416: l_debug_mode := NVL(l_debug_mode, 'Y');
417: SELECT pg.agreement_num,
418: pg.amount,
419: pg.agreement_currency_code

Line 496: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

492: BEGIN
493: IF P_PA_DEBUG_MODE = 'Y' THEN
494: pa_debug.init_err_stack('PAFPCIUB.FP_CI_GET_VERSION_DETAILS');
495: END IF;
496: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
497: l_debug_mode := NVL(l_debug_mode, 'Y');
498: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
499: x_return_status := FND_API.G_RET_STS_SUCCESS;
500: x_msg_count := 0;

Line 701: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

697: BEGIN
698: IF P_PA_DEBUG_MODE = 'Y' THEN
699: pa_debug.init_err_stack('PAFPCIUB.FP_CI_CHECK_MERGE_POSSIBLE');
700: END IF;
701: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
702: l_debug_mode := NVL(l_debug_mode, 'Y');
703: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
705: x_msg_count := 0;

Line 1924: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1920:
1921: x_msg_count := 0;
1922: x_return_status := FND_API.G_RET_STS_SUCCESS;
1923: pa_debug.set_err_stack('PA_FP_CONTROL_ITEMS_UTILS.Is_Create_CI_Version_Allowed');
1924: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1925: l_debug_mode := NVL(l_debug_mode, 'Y');
1926: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1927:
1928: -- Check for business rules violations

Line 2385: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

2381: BEGIN
2382: IF P_PA_DEBUG_MODE = 'Y' THEN
2383: pa_debug.init_err_stack('PAFPCIUB.GET_BUDGET_VERSION_INFO');
2384: END IF;
2385: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2386: l_debug_mode := NVL(l_debug_mode, 'Y');
2387: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2388: x_return_status := FND_API.G_RET_STS_SUCCESS;
2389: x_msg_count := 0;

Line 2718: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

2714: BEGIN
2715: IF P_PA_DEBUG_MODE = 'Y' THEN
2716: pa_debug.init_err_stack('PAFPCIUB.CHECK_PLAN_VERSION_NAME_OR_ID');
2717: END IF;
2718: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2719: l_debug_mode := NVL(l_debug_mode, 'Y');
2720: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;
2722: x_msg_count := 0;

Line 2820: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

2816: BEGIN
2817: IF P_PA_DEBUG_MODE = 'Y' THEN
2818: pa_debug.init_err_stack('PAFPCIUB.FP_CI_CHECK_COPY_POSSIBLE');
2819: END IF;
2820: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2821: l_debug_mode := NVL(l_debug_mode, 'Y');
2822: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2823: x_return_status := FND_API.G_RET_STS_SUCCESS;
2824: x_msg_count := 0;

Line 3167: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3163: BEGIN
3164: IF P_PA_DEBUG_MODE = 'Y' THEN
3165: pa_debug.init_err_stack('PAFPCIUB.CHECK_FP_PLAN_VERSION_EXISTS');
3166: END IF;
3167: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3168: l_debug_mode := NVL(l_debug_mode, 'Y');
3169: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171: x_msg_count := 0;

Line 3462: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

3458: BEGIN
3459:
3460: x_msg_count := 0;
3461: x_return_status := FND_API.G_RET_STS_SUCCESS;
3462: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3463: IF l_debug_mode = 'Y' THEN
3464: pa_debug.set_err_stack('Pa_Fp_Control_Items_Utils.FP_CI_VALIDATE_UPDATE_IMPACT');
3465: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3466: END IF;

Line 4302: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

4298: l_module_name VARCHAR2(100) := 'NON_APP_STATUSES_EXIST' ;
4299:
4300: BEGIN
4301:
4302: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4303:
4304: IF l_debug_mode = 'Y' THEN
4305: pa_debug.set_curr_function( p_function => 'NON_APP_STATUSES_EXIST',
4306: p_debug_mode => l_debug_mode );

Line 4954: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

4950:
4951:
4952: BEGIN
4953:
4954: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4955: x_msg_count := 0;
4956: x_return_status := FND_API.G_RET_STS_SUCCESS;
4957: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
4958: p_debug_mode => l_debug_mode );

Line 6072: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

6068: l_partial_quantity PA_BUDGET_VERSIONS.LABOR_QUANTITY%TYPE;
6069: l_labor_quantity PA_BUDGET_VERSIONS.LABOR_QUANTITY%TYPE;
6070: l_appr_rev_cw_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
6071: BEGIN
6072: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
6073: IF l_debug_mode = 'Y' THEN
6074: pa_debug.g_err_stage:='In get_labor_qty_partial - pa_fp_control_items_utils ';
6075: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6076: END IF;

Line 6382: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

6378: l_partial_quantity PA_BUDGET_VERSIONS.EQUIPMENT_QUANTITY%TYPE;
6379: l_equip_quantity PA_BUDGET_VERSIONS.EQUIPMENT_QUANTITY%TYPE;
6380: l_appr_rev_cw_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
6381: BEGIN
6382: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
6383: IF l_debug_mode = 'Y' THEN
6384: pa_debug.g_err_stage:='In get_equip_qty_partial - pa_fp_control_items_utils ';
6385: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6386: END IF;

Line 6692: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

6688: -- Bug 5845142
6689: l_ci_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
6690: BEGIN
6691:
6692: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
6693:
6694: IF l_debug_mode = 'Y' THEN
6695: pa_debug.g_err_stage:='In get_pc_revenue_partial - pa_fp_control_items_utils ';
6696: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 6901: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

6897: l_cost pa_budget_versions.total_project_raw_cost%TYPE;
6898:
6899: BEGIN
6900:
6901: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
6902:
6903: IF l_debug_mode = 'Y' THEN
6904: pa_debug.g_err_stage:='In get_pc_cost - pa_fp_control_items_utils ';
6905: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 7154: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

7150: and merge2.project_id = c_project_id)));
7151:
7152: BEGIN
7153:
7154: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7155: x_msg_count := 0;
7156: x_return_status := FND_API.G_RET_STS_SUCCESS;
7157: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
7158: p_debug_mode => l_debug_mode );

Line 7567: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

7563:
7564: l_impact_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7565:
7566: BEGIN
7567: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7568:
7569: IF l_debug_mode = 'Y' THEN
7570: pa_debug.g_err_stage:='In is_impact_exists - pa_fp_control_items_utils ';
7571: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 7672: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

7668: l_debug_mode VARCHAR2(30);
7669: l_module_name VARCHAR2(30) := 'is_fin_impact_enabled';
7670:
7671: BEGIN
7672: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7673:
7674: IF l_debug_mode = 'Y' THEN
7675: pa_debug.g_err_stage:='is_fin_impact_enabled - pa_fp_control_items_utils ';
7676: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 8000: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

7996: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
7997:
7998: BEGIN
7999:
8000: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
8001: l_debug_mode := NVL(l_debug_mode, 'N');
8002:
8003:
8004: pa_debug.set_curr_function( p_function => 'GET_PLAN_TYPES_FOR_IMPL',

Line 9341: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

9337: AND plan_version_id=c_app_cw_ver_id
9338: AND ci_plan_version_id=c_ci_version_id
9339: AND version_type=c_version_type);
9340: BEGIN
9341: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
9342: l_debug_mode := NVL(l_debug_mode, 'Y');
9343: x_msg_count := 0;
9344: x_return_status := FND_API.G_RET_STS_SUCCESS;
9345: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,

Line 9738: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

9734:
9735: l_app_cw_ver_rec c_app_cw_ver_csr%ROWTYPE;
9736:
9737: BEGIN
9738: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
9739: l_debug_mode := NVL(l_debug_mode, 'Y');
9740: x_msg_count := 0;
9741: x_return_status := FND_API.G_RET_STS_SUCCESS;
9742: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,

Line 9866: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

9862:
9863:
9864:
9865: BEGIN
9866: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
9867:
9868: IF l_debug_mode = 'Y' THEN
9869: pa_debug.g_err_stage:='get_impl_agr_revenue - pa_fp_control_items_utils ';
9870: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 10178: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

10174:
10175: is_delete_allowed VARCHAR2(1) := 'Y';
10176:
10177: BEGIN
10178: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
10179:
10180: IF l_debug_mode = 'Y' THEN
10181: pa_debug.g_err_stage:='validate_fp_ci_type_delete - pa_fp_control_items_utils ';
10182: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);