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.6.12010000.2 2008/11/28 12:55:05 vgovvala 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: PROCEDURE Get_Fin_Plan_Dtls(p_project_id IN Pa_Projects_All.Project_Id%TYPE,
7: p_ci_id IN NUMBER,

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

335: IF P_PA_DEBUG_MODE = 'Y' THEN
336: pa_debug.init_err_stack('PA_FP_CONTROL_ITEMS_UTILS.get_finplan_ci_type_name');
337: END IF;
338:
339: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
340: l_debug_mode := NVL(l_debug_mode, 'Y');
341:
342: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
343:

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

387: IF P_PA_DEBUG_MODE = 'Y' THEN
388: pa_debug.init_err_stack('get_fp_ci_agreement_dtls: ' || 'PA_FP_CONTROL_ITEMS_UTILS.get_fp_ci_agreement_dtls');
389: END IF;
390:
391: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
392: l_debug_mode := NVL(l_debug_mode, 'Y');
393: SELECT pg.agreement_num,
394: pg.amount,
395: pg.agreement_currency_code

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

468: BEGIN
469: IF P_PA_DEBUG_MODE = 'Y' THEN
470: pa_debug.init_err_stack('PAFPCIUB.FP_CI_GET_VERSION_DETAILS');
471: END IF;
472: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
473: l_debug_mode := NVL(l_debug_mode, 'Y');
474: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
475: x_return_status := FND_API.G_RET_STS_SUCCESS;
476: x_msg_count := 0;

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

668: BEGIN
669: IF P_PA_DEBUG_MODE = 'Y' THEN
670: pa_debug.init_err_stack('PAFPCIUB.FP_CI_CHECK_MERGE_POSSIBLE');
671: END IF;
672: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
673: l_debug_mode := NVL(l_debug_mode, 'Y');
674: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
675: x_return_status := FND_API.G_RET_STS_SUCCESS;
676: x_msg_count := 0;

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

1886:
1887: x_msg_count := 0;
1888: x_return_status := FND_API.G_RET_STS_SUCCESS;
1889: pa_debug.set_err_stack('PA_FP_CONTROL_ITEMS_UTILS.Is_Create_CI_Version_Allowed');
1890: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1891: l_debug_mode := NVL(l_debug_mode, 'Y');
1892: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1893:
1894: -- Check for business rules violations

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

2347: BEGIN
2348: IF P_PA_DEBUG_MODE = 'Y' THEN
2349: pa_debug.init_err_stack('PAFPCIUB.GET_BUDGET_VERSION_INFO');
2350: END IF;
2351: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2352: l_debug_mode := NVL(l_debug_mode, 'Y');
2353: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2354: x_return_status := FND_API.G_RET_STS_SUCCESS;
2355: x_msg_count := 0;

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

2665: BEGIN
2666: IF P_PA_DEBUG_MODE = 'Y' THEN
2667: pa_debug.init_err_stack('PAFPCIUB.CHECK_PLAN_VERSION_NAME_OR_ID');
2668: END IF;
2669: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2670: l_debug_mode := NVL(l_debug_mode, 'Y');
2671: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2672: x_return_status := FND_API.G_RET_STS_SUCCESS;
2673: x_msg_count := 0;

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

2767: BEGIN
2768: IF P_PA_DEBUG_MODE = 'Y' THEN
2769: pa_debug.init_err_stack('PAFPCIUB.FP_CI_CHECK_COPY_POSSIBLE');
2770: END IF;
2771: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2772: l_debug_mode := NVL(l_debug_mode, 'Y');
2773: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2774: x_return_status := FND_API.G_RET_STS_SUCCESS;
2775: x_msg_count := 0;

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

3114: BEGIN
3115: IF P_PA_DEBUG_MODE = 'Y' THEN
3116: pa_debug.init_err_stack('PAFPCIUB.CHECK_FP_PLAN_VERSION_EXISTS');
3117: END IF;
3118: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3119: l_debug_mode := NVL(l_debug_mode, 'Y');
3120: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3121: x_return_status := FND_API.G_RET_STS_SUCCESS;
3122: x_msg_count := 0;

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

3409: BEGIN
3410:
3411: x_msg_count := 0;
3412: x_return_status := FND_API.G_RET_STS_SUCCESS;
3413: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3414: IF l_debug_mode = 'Y' THEN
3415: pa_debug.set_err_stack('Pa_Fp_Control_Items_Utils.FP_CI_VALIDATE_UPDATE_IMPACT');
3416: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3417: END IF;

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

4249: l_module_name VARCHAR2(100) := 'NON_APP_STATUSES_EXIST' ;
4250:
4251: BEGIN
4252:
4253: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4254:
4255: IF l_debug_mode = 'Y' THEN
4256: pa_debug.set_curr_function( p_function => 'NON_APP_STATUSES_EXIST',
4257: p_debug_mode => l_debug_mode );

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

4894:
4895:
4896: BEGIN
4897:
4898: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4899: x_msg_count := 0;
4900: x_return_status := FND_API.G_RET_STS_SUCCESS;
4901: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
4902: p_debug_mode => l_debug_mode );

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

6012: l_partial_quantity PA_BUDGET_VERSIONS.LABOR_QUANTITY%TYPE;
6013: l_labor_quantity PA_BUDGET_VERSIONS.LABOR_QUANTITY%TYPE;
6014: l_appr_rev_cw_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
6015: BEGIN
6016: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
6017: IF l_debug_mode = 'Y' THEN
6018: pa_debug.g_err_stage:='In get_labor_qty_partial - pa_fp_control_items_utils ';
6019: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6020: END IF;

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

6322: l_partial_quantity PA_BUDGET_VERSIONS.EQUIPMENT_QUANTITY%TYPE;
6323: l_equip_quantity PA_BUDGET_VERSIONS.EQUIPMENT_QUANTITY%TYPE;
6324: l_appr_rev_cw_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
6325: BEGIN
6326: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
6327: IF l_debug_mode = 'Y' THEN
6328: pa_debug.g_err_stage:='In get_equip_qty_partial - pa_fp_control_items_utils ';
6329: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6330: END IF;

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

6630: l_budget_version_type pa_budget_versions.version_type%TYPE;
6631: l_version_type pa_budget_versions.version_type%TYPE;
6632: BEGIN
6633:
6634: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
6635:
6636: IF l_debug_mode = 'Y' THEN
6637: pa_debug.g_err_stage:='In get_pc_revenue_partial - pa_fp_control_items_utils ';
6638: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

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

6828: l_cost pa_budget_versions.total_project_raw_cost%TYPE;
6829:
6830: BEGIN
6831:
6832: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
6833:
6834: IF l_debug_mode = 'Y' THEN
6835: pa_debug.g_err_stage:='In get_pc_cost - pa_fp_control_items_utils ';
6836: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

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

7078: and merge2.project_id = c_project_id)));
7079:
7080: BEGIN
7081:
7082: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7083: x_msg_count := 0;
7084: x_return_status := FND_API.G_RET_STS_SUCCESS;
7085: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
7086: p_debug_mode => l_debug_mode );

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

7491:
7492: l_impact_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7493:
7494: BEGIN
7495: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7496:
7497: IF l_debug_mode = 'Y' THEN
7498: pa_debug.g_err_stage:='In is_impact_exists - pa_fp_control_items_utils ';
7499: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

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

7596: l_debug_mode VARCHAR2(30);
7597: l_module_name VARCHAR2(30) := 'is_fin_impact_enabled';
7598:
7599: BEGIN
7600: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7601:
7602: IF l_debug_mode = 'Y' THEN
7603: pa_debug.g_err_stage:='is_fin_impact_enabled - pa_fp_control_items_utils ';
7604: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

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

7901: l_submit_revenue_check VARCHAR2(1);
7902:
7903: BEGIN
7904:
7905: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7906: l_debug_mode := NVL(l_debug_mode, 'N');
7907:
7908:
7909: pa_debug.set_curr_function( p_function => 'GET_PLAN_TYPES_FOR_IMPL',

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

9179: AND plan_version_id=c_app_cw_ver_id
9180: AND ci_plan_version_id=c_ci_version_id
9181: AND version_type=c_version_type);
9182: BEGIN
9183: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
9184: l_debug_mode := NVL(l_debug_mode, 'Y');
9185: x_msg_count := 0;
9186: x_return_status := FND_API.G_RET_STS_SUCCESS;
9187: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,

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

9576:
9577: l_app_cw_ver_rec c_app_cw_ver_csr%ROWTYPE;
9578:
9579: BEGIN
9580: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
9581: l_debug_mode := NVL(l_debug_mode, 'Y');
9582: x_msg_count := 0;
9583: x_return_status := FND_API.G_RET_STS_SUCCESS;
9584: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,

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

9704:
9705:
9706:
9707: BEGIN
9708: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
9709:
9710: IF l_debug_mode = 'Y' THEN
9711: pa_debug.g_err_stage:='get_impl_agr_revenue - pa_fp_control_items_utils ';
9712: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

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

9990:
9991: is_delete_allowed VARCHAR2(1) := 'Y';
9992:
9993: BEGIN
9994: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
9995:
9996: IF l_debug_mode = 'Y' THEN
9997: pa_debug.g_err_stage:='validate_fp_ci_type_delete - pa_fp_control_items_utils ';
9998: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);