DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_RMAP_PKG dependencies on PA_DEBUG

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

1: PACKAGE body PA_FP_GEN_FCST_RMAP_PKG as
2: /* $Header: PAFPFGRB.pls 120.2.12020000.2 2013/05/17 10:56:15 bpottipa ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: /** This method is used to map the ETC source txns to the target
7: * plan version resource list. */
8: PROCEDURE FCST_SRC_TXNS_RMAP

Line 151: IF p_pa_debug_mode = 'Y' THEN

147: BEGIN
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149: x_msg_count := 0;
150:
151: IF p_pa_debug_mode = 'Y' THEN
152: PA_DEBUG.SET_CURR_FUNCTION( p_function => 'FCST_SRC_TXNS_RMAP',
153: p_debug_mode => p_pa_debug_mode );
154: END IF;
155:

Line 152: PA_DEBUG.SET_CURR_FUNCTION( p_function => 'FCST_SRC_TXNS_RMAP',

148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149: x_msg_count := 0;
150:
151: IF p_pa_debug_mode = 'Y' THEN
152: PA_DEBUG.SET_CURR_FUNCTION( p_function => 'FCST_SRC_TXNS_RMAP',
153: p_debug_mode => p_pa_debug_mode );
154: END IF;
155:
156: SELECT NVL(uncategorized_flag,'N')

Line 153: p_debug_mode => p_pa_debug_mode );

149: x_msg_count := 0;
150:
151: IF p_pa_debug_mode = 'Y' THEN
152: PA_DEBUG.SET_CURR_FUNCTION( p_function => 'FCST_SRC_TXNS_RMAP',
153: p_debug_mode => p_pa_debug_mode );
154: END IF;
155:
156: SELECT NVL(uncategorized_flag,'N')
157: INTO l_uncategorized_flag

Line 173: IF p_pa_debug_mode = 'Y' THEN

169:
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,

Line 189: IF p_pa_debug_mode = 'Y' THEN

185: X_MSG_DATA => x_msg_data );
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,

Line 265: /*IF p_pa_debug_mode = 'Y' THEN

261: l_TXN_PLAN_START_DATE_tab,
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);

Line 274: IF p_pa_debug_mode = 'Y' THEN

270: END IF;*/
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 );

Line 334: IF p_pa_debug_mode = 'Y' THEN

330: X_TXN_ACCUM_HEADER_ID_TAB => l_map_txn_accum_header_id_tab,
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,

Line 352: /*IF p_pa_debug_mode = 'Y' THEN

348: version_id not needed in pa_budget_versions. So update deleted **/
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);

Line 367: /*IF p_pa_debug_mode = 'Y' THEN

363:
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);

Line 395: IF P_PA_DEBUG_MODE = 'Y' THEN

391: --from pa_resource_assignments where budget_version_id = P_BUDGET_VERSION_ID;
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 );

Line 408: IF P_PA_DEBUG_MODE = 'Y' THEN

404: P_FP_COLS_REC => P_FP_COLS_REC,
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,

Line 529: /*IF p_pa_debug_mode = 'Y' THEN

525: l_upd_cbs_id_tab, --bug#16791711
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);

Line 652: /*IF p_pa_debug_mode = 'Y' THEN

648: --for i in 1.. l_upd_ra_id_tab1.count LOOP
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);

Line 665: IF p_pa_debug_mode = 'Y' THEN

661: PA_FP_CALC_AMT_TMP2
662: SET target_res_asg_id = l_upd_target_ra_id_tab1(i)
663: WHERE resource_assignment_id = l_upd_ra_id_tab1(i);
664:
665: IF p_pa_debug_mode = 'Y' THEN
666: PA_DEBUG.RESET_CURR_FUNCTION;
667: END IF;
668: EXCEPTION
669: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 666: PA_DEBUG.RESET_CURR_FUNCTION;

662: SET target_res_asg_id = l_upd_target_ra_id_tab1(i)
663: WHERE resource_assignment_id = l_upd_ra_id_tab1(i);
664:
665: IF p_pa_debug_mode = 'Y' THEN
666: PA_DEBUG.RESET_CURR_FUNCTION;
667: END IF;
668: EXCEPTION
669: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
670: l_msg_count := FND_MSG_PUB.count_msg;

Line 688: IF p_pa_debug_mode = 'Y' THEN

684:
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);

Line 693: PA_DEBUG.RESET_CURR_FUNCTION;

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;
694: END IF;
695: RAISE;
696: WHEN OTHERS THEN
697: ROLLBACK;

Line 706: IF p_pa_debug_mode = 'Y' THEN

702: ( p_pkg_name => 'PA_FP_GEN_FCST_RMAP_PKG',
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);

Line 711: PA_DEBUG.RESET_CURR_FUNCTION;

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;
712: END IF;
713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714:
715: END FCST_SRC_TXNS_RMAP;