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 129: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

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

Line 162: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID

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

Line 174: pa_fp_gen_amount_utils.fp_debug

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

Line 176: pa_fp_gen_amount_utils.get_plan_version_dtls',

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

Line 180: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

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

Line 190: pa_fp_gen_amount_utils.fp_debug

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

Line 192: pa_fp_gen_amount_utils.get_plan_version_dtls: ' ||

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

Line 266: pa_fp_gen_amount_utils.fp_debug

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

Line 275: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG (

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

Line 335: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 353: pa_fp_gen_amount_utils.fp_debug

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

Line 368: pa_fp_gen_amount_utils.fp_debug

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

Line 396: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 409: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 446: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(p_budget_version_id);

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

Line 530: pa_fp_gen_amount_utils.fp_debug

526: l_upd_target_ra_id_tab;
527: CLOSE update_res_asg;
528:
529: /*IF p_pa_debug_mode = 'Y' THEN
530: pa_fp_gen_amount_utils.fp_debug
531: (p_msg => 'Value of l_upd_target_ra_id_tab.count: '||l_upd_target_ra_id_tab.count,
532: p_module_name => l_module_name,
533: p_log_level => 5);
534: END IF;*/

Line 653: pa_fp_gen_amount_utils.fp_debug

649: --hr_utility.trace('??l_upd_ra_id_tab1(i):'||l_upd_ra_id_tab1(i));
650: --hr_utility.trace('??l_upd_target_ra_id_tab1(i):'||l_upd_target_ra_id_tab1(i));
651: --END LOOP;
652: /*IF p_pa_debug_mode = 'Y' THEN
653: pa_fp_gen_amount_utils.fp_debug
654: (p_msg => 'Value of l_upd_ra_id_tab1.count: '||l_upd_ra_id_tab1.count,
655: p_module_name => l_module_name,
656: p_log_level => 5);
657: END IF;*/

Line 689: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

685: ROLLBACK;
686: x_return_status := FND_API.G_RET_STS_ERROR;
687:
688: IF p_pa_debug_mode = 'Y' THEN
689: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
690: (p_msg => 'Invalid Arguments Passed',
691: p_module_name => l_module_name,
692: p_log_level => 5);
693: PA_DEBUG.RESET_CURR_FUNCTION;

Line 707: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

703: p_procedure_name => 'FCST_SRC_TXNS_RMAP',
704: p_error_text => substr(sqlerrm,1,240));
705:
706: IF p_pa_debug_mode = 'Y' THEN
707: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
708: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
709: p_module_name => l_module_name,
710: p_log_level => 5);
711: PA_DEBUG.RESET_CURR_FUNCTION;