31: -- End of Comments
32: REM | 03-OCT-2005 Riyengar MRC Elimination Changes:
33: **/
34:
35: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
36: g_module_name VARCHAR2(100):= 'pa.plsql.pa_fp_org_fcst_gen_pub';
37: g_plsql_max_array_size NUMBER := 200;
38:
39: FUNCTION budget_version_in_error
86: IF P_PA_DEBUG_MODE = 'Y' THEN
87: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.get_amttype_id');
88: END IF;
89:
90: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
91: l_debug_mode := NVL(l_debug_mode, 'Y');
92:
93: IF P_PA_DEBUG_MODE = 'Y' THEN
94: pa_debug.set_process('get_amttype_id: ' || 'PLSQL','LOG',l_debug_mode);
651: IF P_PA_DEBUG_MODE = 'Y' THEN
652: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.gen_org_fcst');
653: END IF;
654:
655: --fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
656: l_debug_mode := NVL(l_debug_mode, 'Y');
657:
658: IF P_PA_DEBUG_MODE = 'Y' THEN
659: pa_debug.set_process('gen_org_fcst: ' || 'PLSQL','LOG',l_debug_mode);
752: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
753: END IF;
754: -- hr_utility.trace(to_char(l_stage));
755:
756: l_resource_list_id := FND_PROFILE.VALUE('PA_FORECAST_RESOURCE_LIST');
757:
758: SELECT rlm.resource_list_member_id
759: INTO l_resource_list_member_id
760: FROM pa_resource_list_members rlm
4418:
4419: x_msg_count := 0;
4420: x_return_status := FND_API.G_RET_STS_SUCCESS;
4421: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Create_Res_Task_Maps');
4422: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4423: l_debug_mode := NVL(l_debug_mode, 'Y');
4424: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4425:
4426: -- Check for business rules violations
4970:
4971: x_msg_count := 0;
4972: x_return_status := FND_API.G_RET_STS_SUCCESS;
4973: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Copy_Resource_Assignments');
4974: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4975: l_debug_mode := NVL(l_debug_mode, 'Y');
4976: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4977:
4978: /*
5688:
5689: x_msg_count := 0;
5690: x_return_status := FND_API.G_RET_STS_SUCCESS;
5691: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Copy_Budget_Lines');
5692: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5693: l_debug_mode := NVL(l_debug_mode, 'Y');
5694: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
5695:
5696: -- Checking for all valid input parametrs