DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_RMAP_PKG dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 11: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

7: * plan version resource list. */
8: PROCEDURE FCST_SRC_TXNS_RMAP
9: ( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
10: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
11: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
12: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
13: X_MSG_COUNT OUT NOCOPY NUMBER,
14: X_MSG_DATA OUT NOCOPY VARCHAR2 )
15: IS

Line 127: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

123: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE;
124: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE;
125:
126: /* Local copy of target version details for getting source version ids. */
127: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
128: l_resource_list_id PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE;
129:
130: /* Date update variables */
131: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 160: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID

156: FROM pa_resource_lists_all_bg
157: WHERE resource_list_id = p_fp_cols_rec.X_RESOURCE_LIST_ID;
158:
159: IF l_uncategorized_flag = 'Y' THEN
160: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID
161: ( p_project_id => p_project_id,
162: p_resource_list_id => p_fp_cols_rec.X_RESOURCE_LIST_ID,
163: p_resource_class_code => 'FINANCIAL_ELEMENTS' );
164: UPDATE PA_FP_CALC_AMT_TMP1

Line 172: pa_fp_gen_amount_utils.fp_debug

168: -- Beginning of code change for Bug 4070976 --
169: /* We get a fresh local copy of the target version details because
170: * p_fp_cols_rec does not have the updated source version ids. */
171: IF p_pa_debug_mode = 'Y' THEN
172: pa_fp_gen_amount_utils.fp_debug
173: ( p_msg => 'Before calling
174: pa_fp_gen_amount_utils.get_plan_version_dtls',
175: p_module_name => l_module_name,
176: p_log_level => 5 );

Line 174: pa_fp_gen_amount_utils.get_plan_version_dtls',

170: * p_fp_cols_rec does not have the updated source version ids. */
171: IF p_pa_debug_mode = 'Y' THEN
172: pa_fp_gen_amount_utils.fp_debug
173: ( p_msg => 'Before calling
174: pa_fp_gen_amount_utils.get_plan_version_dtls',
175: p_module_name => l_module_name,
176: p_log_level => 5 );
177: END IF;
178: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 178: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

174: pa_fp_gen_amount_utils.get_plan_version_dtls',
175: p_module_name => l_module_name,
176: p_log_level => 5 );
177: END IF;
178: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
179: ( P_BUDGET_VERSION_ID => p_budget_version_id,
180: X_FP_COLS_REC => l_fp_cols_rec,
181: X_RETURN_STATUS => x_return_status,
182: X_MSG_COUNT => x_msg_count,

Line 188: pa_fp_gen_amount_utils.fp_debug

184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
186: END IF;
187: IF p_pa_debug_mode = 'Y' THEN
188: pa_fp_gen_amount_utils.fp_debug
189: ( p_msg => 'Status after calling
190: pa_fp_gen_amount_utils.get_plan_version_dtls: ' ||
191: x_return_status,
192: p_module_name => l_module_name,

Line 190: pa_fp_gen_amount_utils.get_plan_version_dtls: ' ||

186: END IF;
187: IF p_pa_debug_mode = 'Y' THEN
188: pa_fp_gen_amount_utils.fp_debug
189: ( p_msg => 'Status after calling
190: pa_fp_gen_amount_utils.get_plan_version_dtls: ' ||
191: x_return_status,
192: p_module_name => l_module_name,
193: p_log_level => 5 );
194: END IF;

Line 264: pa_fp_gen_amount_utils.fp_debug

260: l_TXN_PLAN_END_DATE_tab;
261: CLOSE map_to_target_fp_cur;
262:
263: /*IF p_pa_debug_mode = 'Y' THEN
264: pa_fp_gen_amount_utils.fp_debug
265: (p_msg => 'Value of l_txn_source_id_tab.count: '||l_txn_source_id_tab.count,
266: p_module_name => l_module_name,
267: p_log_level => 5);
268: END IF;*/

Line 273: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG (

269: --dbms_output.put_line('--l_txn_source_id_tab.count:'||l_txn_source_id_tab.count);
270:
271: IF ( l_TXN_SOURCE_ID_tab.count > 0 ) THEN
272: IF p_pa_debug_mode = 'Y' THEN
273: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG (
274: P_CALLED_MODE => p_called_mode,
275: P_MSG => 'Before calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS',
276: P_MODULE_NAME => l_module_name );
277: END IF;

Line 333: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

329: X_RETURN_STATUS => x_return_status,
330: X_MSG_COUNT => x_msg_count,
331: X_MSG_DATA => x_msg_data );
332: IF p_pa_debug_mode = 'Y' THEN
333: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
334: P_CALLED_MODE => p_called_mode,
335: P_MSG => 'After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||
336: x_return_status,
337: P_MODULE_NAME => l_module_name);

Line 351: pa_fp_gen_amount_utils.fp_debug

347:
348: --select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
349:
350: /*IF p_pa_debug_mode = 'Y' THEN
351: pa_fp_gen_amount_utils.fp_debug
352: (p_msg => 'Count of PA_FP_CALC_AMT_TMP1: '||l_count_tmp,
353: p_module_name => l_module_name,
354: p_log_level => 5);
355: END IF;*/

Line 366: pa_fp_gen_amount_utils.fp_debug

362: /* hr_utility.trace('==PA_FP_CALC_AMT_TMP1.count aft res map call'||l_count_tmp);
363: hr_utility.trace('map rlm id tab count '||l_map_rlm_id_tab.count);
364: hr_utility.trace('map src id tab count '||l_map_txn_source_id_tab.count); */
365: /*IF p_pa_debug_mode = 'Y' THEN
366: pa_fp_gen_amount_utils.fp_debug
367: (p_msg => 'Value of l_map_rlm_id_tab.count: '||l_map_rlm_id_tab.count,
368: p_module_name => l_module_name,
369: p_log_level => 5);
370: END IF;*/

Line 394: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

390: --dbms_output.put_line('@@before maintain_res_asg, count of pa_resource_asgs:' ||l_count_tmp);
391: --hr_utility.trace('before calling maintain res asg');
392:
393: IF P_PA_DEBUG_MODE = 'Y' THEN
394: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
395: P_CALLED_MODE => P_CALLED_MODE,
396: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.MAINTAIN_RES_ASG',
397: P_MODULE_NAME => l_module_name );
398: END IF;

Line 407: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

403: X_RETURN_STATUS => x_return_status,
404: X_MSG_COUNT => x_msg_count,
405: X_MSG_DATA => x_msg_data );
406: IF P_PA_DEBUG_MODE = 'Y' THEN
407: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
408: P_CALLED_MODE => P_CALLED_MODE,
409: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
410: 'MAINTAIN_RES_ASG: '||x_return_status,
411: P_MODULE_NAME => l_module_name);

Line 444: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(p_budget_version_id);

440: GROUP BY resource_assignment_id;
441: ELSIF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'Y' THEN
442: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
443: l_etc_start_date :=
444: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(p_budget_version_id);
445:
446: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N1)*/
447: tmp1.resource_assignment_id,
448: MIN(tmp1.planning_start_date),

Line 525: pa_fp_gen_amount_utils.fp_debug

521: l_upd_target_ra_id_tab;
522: CLOSE update_res_asg;
523:
524: /*IF p_pa_debug_mode = 'Y' THEN
525: pa_fp_gen_amount_utils.fp_debug
526: (p_msg => 'Value of l_upd_target_ra_id_tab.count: '||l_upd_target_ra_id_tab.count,
527: p_module_name => l_module_name,
528: p_log_level => 5);
529: END IF;*/

Line 642: pa_fp_gen_amount_utils.fp_debug

638: --hr_utility.trace('??l_upd_ra_id_tab1(i):'||l_upd_ra_id_tab1(i));
639: --hr_utility.trace('??l_upd_target_ra_id_tab1(i):'||l_upd_target_ra_id_tab1(i));
640: --END LOOP;
641: /*IF p_pa_debug_mode = 'Y' THEN
642: pa_fp_gen_amount_utils.fp_debug
643: (p_msg => 'Value of l_upd_ra_id_tab1.count: '||l_upd_ra_id_tab1.count,
644: p_module_name => l_module_name,
645: p_log_level => 5);
646: END IF;*/

Line 678: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

674: ROLLBACK;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676:
677: IF p_pa_debug_mode = 'Y' THEN
678: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
679: (p_msg => 'Invalid Arguments Passed',
680: p_module_name => l_module_name,
681: p_log_level => 5);
682: PA_DEBUG.RESET_CURR_FUNCTION;

Line 696: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

692: p_procedure_name => 'FCST_SRC_TXNS_RMAP',
693: p_error_text => substr(sqlerrm,1,240));
694:
695: IF p_pa_debug_mode = 'Y' THEN
696: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
697: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
698: p_module_name => l_module_name,
699: p_log_level => 5);
700: PA_DEBUG.RESET_CURR_FUNCTION;