eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_DEBUG

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

1: PACKAGE body PA_FP_GEN_FCST_AMT_PUB as
2: /* $Header: PAFPFGPB.pls 120.16 2007/11/28 14:05:05 vgovvala ship $ */
3:
4:
5: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
6:
7: -----------------------------------------------------------------------
8: --------- Forward declarations for local/private procedures -----------
9: -----------------------------------------------------------------------

Line 96: IF p_pa_debug_mode = 'Y' THEN

92: END IF;
93: X_MSG_COUNT := 0;
94: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
95:
96: IF p_pa_debug_mode = 'Y' THEN
97: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',
98: p_debug_mode => p_pa_debug_mode);
99: END IF;
100:

Line 97: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',

93: X_MSG_COUNT := 0;
94: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
95:
96: IF p_pa_debug_mode = 'Y' THEN
97: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',
98: p_debug_mode => p_pa_debug_mode);
99: END IF;
100:
101: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 98: p_debug_mode => p_pa_debug_mode);

94: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
95:
96: IF p_pa_debug_mode = 'Y' THEN
97: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',
98: p_debug_mode => p_pa_debug_mode);
99: END IF;
100:
101: IF P_PA_DEBUG_MODE = 'Y' THEN
102: pa_fp_gen_amount_utils.fp_debug

Line 101: IF P_PA_DEBUG_MODE = 'Y' THEN

97: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',
98: p_debug_mode => p_pa_debug_mode);
99: END IF;
100:
101: IF P_PA_DEBUG_MODE = 'Y' THEN
102: pa_fp_gen_amount_utils.fp_debug
103: (p_called_mode => P_CALLED_MODE,
104: p_msg =>
105: 'Before calling PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_BV_FOR_GEN_DATE',

Line 115: IF P_PA_DEBUG_MODE = 'Y' THEN

111: P_ETC_START_DATE => P_ACTUALS_THRU_DATE + 1,
112: X_RETURN_STATUS => X_RETURN_STATUS,
113: X_MSG_COUNT => X_MSG_COUNT,
114: X_MSG_DATA => X_MSG_DATA);
115: IF P_PA_DEBUG_MODE = 'Y' THEN
116: pa_fp_gen_amount_utils.fp_debug
117: (p_called_mode => P_CALLED_MODE,
118: p_msg => 'After calling PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_BV_FOR_GEN_DATE,
119: ret status: '||x_return_status,

Line 126: IF p_pa_debug_mode = 'Y' THEN

122:
123: DELETE FROM PA_FP_CALC_AMT_TMP1;
124: DELETE FROM PA_FP_CALC_AMT_TMP2;
125: IF p_fp_cols_rec.x_gen_incl_open_comm_flag = 'Y' THEN
126: IF p_pa_debug_mode = 'Y' THEN
127: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
128: P_CALLED_MODE => P_CALLED_MODE,
129: P_MSG => 'Before calling pa_fp_commitment_amounts.'||
130: 'get_commitment_amts',

Line 144: IF p_pa_debug_mode = 'Y' THEN

140: X_MSG_COUNT => X_MSG_COUNT,
141: X_MSG_DATA => X_MSG_DATA);
142: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
143: x_msg_count := 0;
144: IF p_pa_debug_mode = 'Y' THEN
145: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
146: P_CALLED_MODE => P_CALLED_MODE,
147: P_MSG => 'After calling pa_fp_commitment_amounts.'||
148: 'get_commitment_amts: '||x_return_status,

Line 182: IF p_pa_debug_mode = 'Y' THEN

178: -- and postpone calling it until after CREATE_RES_ASG and UPDATE_RES_ASG
179: -- have been called in the remaining two cases (see conditional logic below).
180: IF (P_FP_COLS_REC.X_VERSION_TYPE = 'REVENUE' AND l_rev_gen_method = 'E') OR
181: (P_FP_COLS_REC.X_GEN_ETC_SRC_CODE = 'RESOURCE_SCHEDULE') THEN
182: IF p_pa_debug_mode = 'Y' THEN
183: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
184: P_CALLED_MODE => P_CALLED_MODE,
185: P_MSG => 'Before calling pa_fp_copy_actuals_pub.copy_actuals',
186: P_MODULE_NAME => l_module_name);

Line 198: IF p_pa_debug_mode = 'Y' THEN

194: P_COMMIT_FLAG => 'N',
195: X_RETURN_STATUS => X_RETURN_STATUS,
196: X_MSG_COUNT => X_MSG_COUNT,
197: X_MSG_DATA => X_MSG_DATA);
198: IF p_pa_debug_mode = 'Y' THEN
199: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
200: P_CALLED_MODE => P_CALLED_MODE,
201: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
202: ||x_return_status,

Line 218: IF p_pa_debug_mode = 'Y' THEN

214: ELSIF P_FP_COLS_REC.X_GEN_ETC_SRC_CODE = 'RESOURCE_SCHEDULE' THEN
215: -- Bug 4222555: When the Target is a Revenue version and the accrual
216: -- method is Cost, we need to call the GEN_REV_BDGT_AMT_RES_SCH_WRP API.
217: IF p_fp_cols_rec.x_version_type = 'REVENUE' AND l_rev_gen_method = 'C' THEN
218: IF p_pa_debug_mode = 'Y' THEN
219: pa_fp_gen_amount_utils.fp_debug
220: ( p_called_mode => p_called_mode,
221: p_msg => 'Before calling
222: pa_fp_gen_budget_amt_pub.gen_rev_bdgt_amt_res_sch_wrp',

Line 252: IF p_pa_debug_mode = 'Y' THEN

248: X_MSG_DATA => X_MSG_DATA );
249: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
250: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
251: END IF;
252: IF p_pa_debug_mode = 'Y' THEN
253: pa_fp_gen_amount_utils.fp_debug
254: ( p_called_mode => p_called_mode,
255: p_msg => 'Status after calling pa_fp_gen_budget_amt_pub.'||
256: 'gen_rev_bdgt_amt_res_sch_wrp:'||x_return_status,

Line 261: IF p_pa_debug_mode = 'Y' THEN

257: p_module_name => l_module_name,
258: p_log_level => 5 );
259: END IF;
260: ELSE
261: IF p_pa_debug_mode = 'Y' THEN
262: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
263: P_CALLED_MODE => P_CALLED_MODE,
264: P_MSG => 'Before calling pa_fp_gen_budget_amt_pub.'||
265: 'generate_budget_amt_res_sch',

Line 290: IF p_pa_debug_mode = 'Y' THEN

286: P_INIT_MSG_FLAG => 'N',
287: X_RETURN_STATUS => X_RETURN_STATUS,
288: X_MSG_COUNT => X_MSG_COUNT,
289: X_MSG_DATA => X_MSG_DATA);
290: IF p_pa_debug_mode = 'Y' THEN
291: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
292: P_CALLED_MODE => P_CALLED_MODE,
293: P_MSG => 'After calling pa_fp_gen_budget_amt_pub.'||
294: 'generate_budget_amt_res_sch: '||x_return_status,

Line 312: IF p_pa_debug_mode = 'Y' THEN

308:
309: /* For revenue fcst generation, source can only be cost and all.
310: From revenue version is provented from UI.
311: Revenue fcst generation should follow the budget generation logic.*/
312: IF p_pa_debug_mode = 'Y' THEN
313: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
314: P_CALLED_MODE => P_CALLED_MODE,
315: P_MSG =>
316: 'Before calling PA_FP_WP_GEN_BUDGET_AMT_PUB.'||

Line 345: IF p_pa_debug_mode = 'Y' THEN

341: PX_GEN_RES_ASG_ID_TAB => lx_gen_res_asg_id_tab,
342: X_RETURN_STATUS => X_RETURN_STATUS,
343: X_MSG_COUNT => X_MSG_COUNT,
344: X_MSG_DATA => X_MSG_DATA );
345: IF p_pa_debug_mode = 'Y' THEN
346: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
347: P_CALLED_MODE => P_CALLED_MODE,
348: P_MSG =>
349: 'After calling PA_FP_WP_GEN_BUDGET_AMT_PUB.'||

Line 357: IF p_pa_debug_mode = 'Y' THEN

353: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
354: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
355: END IF;
356: ELSE
357: IF p_pa_debug_mode = 'Y' THEN
358: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
359: P_CALLED_MODE => P_CALLED_MODE,
360: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
361: 'gen_fcst_task_level_amt',

Line 379: IF p_pa_debug_mode = 'Y' THEN

375: X_RETURN_STATUS => X_RETURN_STATUS,
376: X_MSG_COUNT => X_MSG_COUNT,
377: X_MSG_DATA => X_MSG_DATA);
378:
379: IF p_pa_debug_mode = 'Y' THEN
380: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
381: P_CALLED_MODE => P_CALLED_MODE,
382: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
383: 'gen_fcst_task_level_amt: '||x_return_status,

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

388: END IF;
389: END IF;
390:
391: --hr_utility.trace('p_fp_cols_rec.x_gen_incl_open_comm_flag:'||p_fp_cols_rec.x_gen_incl_open_comm_flag);
392: /* IF p_pa_debug_mode = 'Y' THEN
393: pa_fp_gen_amount_utils.fp_debug
394: (p_msg => 'Value of gen_incl_open_comm_flag: '||p_fp_cols_rec.x_gen_incl_open_comm_flag,
395: p_module_name => l_module_name,
396: p_log_level => 5);

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

395: p_module_name => l_module_name,
396: p_log_level => 5);
397: END IF;*/
398:
399: /*IF p_pa_debug_mode = 'Y' THEN
400: pa_fp_gen_amount_utils.fp_debug
401: (p_msg => 'Value of gen_incl_change_doc_flag: '||p_fp_cols_rec.x_gen_incl_change_doc_flag,
402: p_module_name => l_module_name,
403: p_log_level => 5);

Line 407: IF p_pa_debug_mode = 'Y' THEN

403: p_log_level => 5);
404: END IF;*/
405:
406: IF p_fp_cols_rec.x_gen_incl_open_comm_flag = 'Y' THEN
407: IF p_pa_debug_mode = 'Y' THEN
408: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
409: P_CALLED_MODE => P_CALLED_MODE,
410: P_MSG => 'Before calling PA_FP_GEN_COMMITMENT_AMOUNTS.'||
411: 'GEN_COMMITMENT_AMOUNTS',

Line 423: IF p_pa_debug_mode = 'Y' THEN

419: PX_DELETED_RES_ASG_ID_TAB => l_deleted_res_asg_id_tab,
420: X_RETURN_STATUS => X_RETURN_STATUS,
421: X_MSG_COUNT => X_MSG_COUNT,
422: X_MSG_DATA => X_MSG_DATA);
423: IF p_pa_debug_mode = 'Y' THEN
424: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
425: P_CALLED_MODE => P_CALLED_MODE,
426: P_MSG => 'After calling PA_FP_GEN_COMMITMENT_AMOUNTS.'||
427: 'GEN_COMMITMENT_AMOUNTS: '||x_return_status,

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

433: END IF;--p_fp_cols_rec.x_gen_incl_open_comm_flag = 'Y'
434:
435: --dbms_output.put_line('++Before reven++');
436: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
437: /* IF p_pa_debug_mode = 'Y' THEN
438: pa_fp_gen_amount_utils.fp_debug
439: (p_msg => 'Value of version_type: '||p_fp_cols_rec.x_version_type,
440: p_module_name => l_module_name,
441: p_log_level => 5);

Line 468: IF p_pa_debug_mode = 'Y' THEN

464: p_fp_cols_rec.x_version_type = 'REVENUE' AND
465: l_rev_gen_method = 'C' AND
466: p_fp_cols_rec.x_time_phased_code = 'N') THEN
467: --Calling the currency conversion API
468: IF p_pa_debug_mode = 'Y' THEN
469: pa_fp_gen_amount_utils.fp_debug
470: (p_called_mode => p_called_mode,
471: p_msg => 'Before calling
472: pa_fp_multi_currency_pkg.convert_txn_currency',

Line 487: IF p_pa_debug_mode = 'Y' THEN

483: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
484: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
485: END IF;
486:
487: IF p_pa_debug_mode = 'Y' THEN
488: pa_fp_gen_amount_utils.fp_debug
489: (p_called_mode => p_called_mode,
490: p_msg => 'Status after calling
491: pa_fp_multi_currency_pkg.convert_txn_currency: '

Line 501: IF p_pa_debug_mode = 'Y' THEN

497:
498: /* Calling rollup budget version api
499: rollup amounts for the version level not required as the
500: amounts are derived from budget lines data
501: IF p_pa_debug_mode = 'Y' THEN
502: pa_fp_gen_amount_utils.fp_debug
503: (p_called_mode => p_called_mode,
504: p_msg => 'Before calling
505: pa_fp_rollup_pkg.rollup_budget_version',

Line 519: IF p_pa_debug_mode = 'Y' THEN

515:
516: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
517: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
518: END IF;
519: IF p_pa_debug_mode = 'Y' THEN
520: pa_fp_gen_amount_utils.fp_debug
521: (p_called_mode => p_called_mode,
522: p_msg => 'Status after calling
523: pa_fp_rollup_pkg.rollup_budget_version: '

Line 528: IF p_pa_debug_mode = 'Y' THEN

524: ||x_return_status,
525: p_module_name => l_module_name,
526: p_log_level => 5);
527: END IF;
528: IF p_pa_debug_mode = 'Y' THEN
529: pa_fp_gen_amount_utils.fp_debug
530: (p_msg => 'Value of project_value: '||p_fp_cols_rec.x_project_value,
531: p_module_name => l_module_name,
532: p_log_level => 5);

Line 542: IF p_pa_debug_mode = 'Y' THEN

538: END IF;
539: the error for project value null chk is handled in
540: gen cost based revenue gen API */
541: --Calling gen cost based revenue api
542: IF p_pa_debug_mode = 'Y' THEN
543: pa_fp_gen_amount_utils.fp_debug
544: (p_called_mode => p_called_mode,
545: p_msg => 'Before calling
546: pa_fp_rev_gen_pub.gen_cost_based_revenue',

Line 561: IF p_pa_debug_mode = 'Y' THEN

557: X_MSG_DATA => X_MSG_DATA);
558: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
559: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
560: END IF;
561: IF p_pa_debug_mode = 'Y' THEN
562: pa_fp_gen_amount_utils.fp_debug
563: (p_called_mode => p_called_mode,
564: p_msg => 'Status after calling
565: pa_fp_rev_gen_pub.gen_cost_based_revenue'

Line 583: IF p_pa_debug_mode = 'Y' THEN

579: OR p_fp_cols_rec.x_version_type = 'REVENUE')
580: AND (l_rev_gen_method = 'E'
581: OR p_fp_cols_rec.x_gen_incl_bill_event_flag = 'Y') THEN
582: --Calling Billing Events API
583: IF p_pa_debug_mode = 'Y' THEN
584: pa_fp_gen_amount_utils.fp_debug
585: (p_called_mode => p_called_mode,
586: p_msg => 'Before calling
587: pa_fp_gen_billing_amounts.gen_billing_amounts',

Line 605: IF p_pa_debug_mode = 'Y' THEN

601:
602: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
603: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
604: END IF;
605: IF p_pa_debug_mode = 'Y' THEN
606: pa_fp_gen_amount_utils.fp_debug
607: (p_called_mode => p_called_mode,
608: p_msg => 'Status after calling
609: pa_fp_gen_billing_amounts.gen_billing_amounts: '

Line 617: IF p_pa_debug_mode = 'Y' THEN

613: END IF;
614: END IF;
615:
616: IF p_fp_cols_rec.x_version_type = 'REVENUE' THEN
617: IF p_pa_debug_mode = 'Y' THEN
618: pa_fp_gen_amount_utils.fp_debug
619: (p_called_mode => p_called_mode,
620: p_msg => 'Before calling
621: pa_fp_gen_budget_amt_pub.reset_cost_amounts',

Line 634: IF p_pa_debug_mode = 'Y' THEN

630: X_MSG_DATA => X_MSG_DATA);
631: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
632: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
633: END IF;
634: IF p_pa_debug_mode = 'Y' THEN
635: pa_fp_gen_amount_utils.fp_debug
636: (p_called_mode => p_called_mode,
637: p_msg => 'Status after calling
638: pa_fp_gen_budget_amt_pub.reset_cost_amounts: '

Line 660: IF p_pa_debug_mode = 'Y' THEN

656: AND gen_etc_source_code = 'FINANCIAL_PLAN'
657: AND gen_etc_source_code IS NOT NULL;
658:
659: IF l_task_count > 0 THEN
660: IF p_pa_debug_mode = 'Y' THEN
661: pa_fp_gen_amount_utils.fp_debug
662: (p_called_mode => p_called_mode,
663: p_msg => 'Before calling
664: pa_fp_ci_merge.copy_merged_ctrl_items',

Line 679: IF p_pa_debug_mode = 'Y' THEN

675: ,x_msg_data => x_msg_data);
676: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
677: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
678: END IF;
679: IF p_pa_debug_mode = 'Y' THEN
680: pa_fp_gen_amount_utils.fp_debug
681: (p_called_mode => p_called_mode,
682: p_msg => 'Status after calling
683: pa_fp_ci_merge.copy_merged_ctrl_items: '

Line 690: IF p_pa_debug_mode = 'Y' THEN

686: p_log_level => 5);
687: END IF;
688: END IF;
689: END IF;
690: IF p_pa_debug_mode = 'Y' THEN
691: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
692: P_CALLED_MODE => P_CALLED_MODE,
693: P_MSG => 'Before calling pa_fp_gen_pub.'||
694: 'include_change_document_wrp',

Line 707: IF p_pa_debug_mode = 'Y' THEN

703: --dbms_output.put_line('++After chg doc is: '||x_return_status);
704: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
705: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
706: END IF;
707: IF p_pa_debug_mode = 'Y' THEN
708: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
709: P_CALLED_MODE => P_CALLED_MODE,
710: P_MSG => 'After calling pa_fp_gen_pub.'||
711: 'include_change_document_wrp:'||x_return_status,

Line 738: IF p_pa_debug_mode = 'Y' THEN

734:
735: /* Begin Comment for Bug 4292083 ************************************************
736:
737: IF p_fp_cols_rec.x_time_phased_code = 'N' THEN
738: IF p_pa_debug_mode = 'Y' THEN
739: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
740: P_CALLED_MODE => P_CALLED_MODE,
741: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
742: 'update_total_plan_amts',

Line 752: IF p_pa_debug_mode = 'Y' THEN

748: X_MSG_COUNT => X_MSG_COUNT,
749: X_MSG_DATA => X_MSG_DATA);
750: --dbms_output.put_line('Status of update total plan amts api: '||X_RETURN_STATUS);
751: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
752: IF p_pa_debug_mode = 'Y' THEN
753: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
754: P_CALLED_MODE => P_CALLED_MODE,
755: P_MSG => 'AFTER CALLING PA_FP_GEN_FCST_AMT_PUB.'||
756: 'UPDATE_TOTAL_PLAN_AMTS:'||x_return_status,

Line 769: IF p_pa_debug_mode = 'Y' THEN

765:
766: -- Call API to update pa_budget_lines.other_rejection_code
767: -- with any ETC revenue amount calculation errors.
768: -- See bug 5203622 for more details.
769: IF p_pa_debug_mode = 'Y' THEN
770: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
771: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.' ||
772: 'UPD_REV_CALCULATION_ERR',
773: P_CALLED_MODE => p_called_mode,

Line 785: IF p_pa_debug_mode = 'Y' THEN

781: P_CALLED_MODE => p_called_mode,
782: X_RETURN_STATUS => X_RETURN_STATUS,
783: X_MSG_COUNT => X_MSG_COUNT,
784: X_MSG_DATA => X_MSG_DATA);
785: IF p_pa_debug_mode = 'Y' THEN
786: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
787: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.' ||
788: 'UPD_REV_CALCULATION_ERR: '||x_return_status,
789: P_CALLED_MODE => p_called_mode,

Line 803: IF p_pa_debug_mode = 'Y' THEN

799: ,x_return_status => x_return_status
800: ,x_msg_count => x_msg_count
801: ,x_msg_data => x_msg_data);
802:
803: IF p_pa_debug_mode = 'Y' THEN
804: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
805: P_CALLED_MODE => P_CALLED_MODE,
806: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
807: 'call_clnt_extn_and_update_bl '||x_return_status,

Line 819: IF p_pa_debug_mode = 'Y' THEN

815:
816: --End Bug 5726785
817:
818:
819: IF p_pa_debug_mode = 'Y' THEN
820: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
821: P_CALLED_MODE => P_CALLED_MODE,
822: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
823: 'MAINTAIN_BUDGET_VERSION',

Line 837: IF p_pa_debug_mode = 'Y' THEN

833: X_MSG_COUNT => x_msg_count,
834: X_MSG_DATA => x_msg_data );
835: --dbms_output.put_line('++AFter pub1.maintain_bv++:'||x_return_status);
836: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
837: IF p_pa_debug_mode = 'Y' THEN
838: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
839: P_CALLED_MODE => P_CALLED_MODE,
840: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
841: 'MAINTAIN_BUDGET_VERSION: '||x_return_status,

Line 851: IF p_pa_debug_mode = 'Y' THEN

847:
848: IF P_COMMIT_FLAG = 'Y' THEN
849: COMMIT;
850: END IF;
851: IF p_pa_debug_mode = 'Y' THEN
852: PA_DEBUG.Reset_Curr_Function;
853: END IF;
854: --dbms_output.put_line('??END: x_msg_count:'||x_msg_count);
855: /*temp */

Line 852: PA_DEBUG.Reset_Curr_Function;

848: IF P_COMMIT_FLAG = 'Y' THEN
849: COMMIT;
850: END IF;
851: IF p_pa_debug_mode = 'Y' THEN
852: PA_DEBUG.Reset_Curr_Function;
853: END IF;
854: --dbms_output.put_line('??END: x_msg_count:'||x_msg_count);
855: /*temp */
856: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 878: IF P_PA_DEBUG_MODE = 'Y' THEN

874: END IF;
875: ROLLBACK;
876:
877: x_return_status := FND_API.G_RET_STS_ERROR;
878: IF P_PA_DEBUG_MODE = 'Y' THEN
879: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
880: P_CALLED_MODE => P_CALLED_MODE,
881: P_MSG => 'Invalid Arguments Passed',
882: P_MODULE_NAME => l_module_name);

Line 883: PA_DEBUG.Reset_Curr_Function;

879: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
880: P_CALLED_MODE => P_CALLED_MODE,
881: P_MSG => 'Invalid Arguments Passed',
882: P_MODULE_NAME => l_module_name);
883: PA_DEBUG.Reset_Curr_Function;
884: END IF;
885: RAISE;
886:
887: WHEN OTHERS THEN

Line 893: IF P_PA_DEBUG_MODE = 'Y' THEN

889: x_msg_data := SUBSTR(SQLERRM,1,240);
890: FND_MSG_PUB.add_exc_msg
891: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
892: ,p_procedure_name => 'GENERATE_FCST_AMT_WRP');
893: IF P_PA_DEBUG_MODE = 'Y' THEN
894: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
895: P_CALLED_MODE => P_CALLED_MODE,
896: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
897: P_MODULE_NAME => l_module_name);

Line 898: PA_DEBUG.Reset_Curr_Function;

894: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
895: P_CALLED_MODE => P_CALLED_MODE,
896: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
897: P_MODULE_NAME => l_module_name);
898: PA_DEBUG.Reset_Curr_Function;
899: END IF;
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901:
902: END GENERATE_FCST_AMT_WRP;

Line 1595: IF p_pa_debug_mode = 'Y' THEN

1591:
1592: BEGIN
1593: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1594: X_MSG_COUNT := 0;
1595: IF p_pa_debug_mode = 'Y' THEN
1596: pa_debug.set_curr_function( p_function => 'GEN_FCST_TASK_LEVEL_AMT',
1597: p_debug_mode => p_pa_debug_mode);
1598: END IF;
1599: l_latest_published_fwbs_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(P_PROJECT_ID);

Line 1596: pa_debug.set_curr_function( p_function => 'GEN_FCST_TASK_LEVEL_AMT',

1592: BEGIN
1593: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1594: X_MSG_COUNT := 0;
1595: IF p_pa_debug_mode = 'Y' THEN
1596: pa_debug.set_curr_function( p_function => 'GEN_FCST_TASK_LEVEL_AMT',
1597: p_debug_mode => p_pa_debug_mode);
1598: END IF;
1599: l_latest_published_fwbs_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(P_PROJECT_ID);
1600: l_proj_struc_sharing_code := NVL(PA_PROJECT_STRUCTURE_UTILS.

Line 1597: p_debug_mode => p_pa_debug_mode);

1593: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1594: X_MSG_COUNT := 0;
1595: IF p_pa_debug_mode = 'Y' THEN
1596: pa_debug.set_curr_function( p_function => 'GEN_FCST_TASK_LEVEL_AMT',
1597: p_debug_mode => p_pa_debug_mode);
1598: END IF;
1599: l_latest_published_fwbs_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(P_PROJECT_ID);
1600: l_proj_struc_sharing_code := NVL(PA_PROJECT_STRUCTURE_UTILS.
1601: get_Structure_sharing_code(P_PROJECT_ID),'SHARE_FULL');

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

1598: END IF;
1599: l_latest_published_fwbs_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(P_PROJECT_ID);
1600: l_proj_struc_sharing_code := NVL(PA_PROJECT_STRUCTURE_UTILS.
1601: get_Structure_sharing_code(P_PROJECT_ID),'SHARE_FULL');
1602: /*IF p_pa_debug_mode = 'Y' THEN
1603: pa_fp_gen_amount_utils.fp_debug
1604: (p_msg => 'Value of l_latest_published_fwbs_id: '||l_latest_published_fwbs_id,
1605: p_module_name => l_module_name,
1606: p_log_level => 5);

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

1604: (p_msg => 'Value of l_latest_published_fwbs_id: '||l_latest_published_fwbs_id,
1605: p_module_name => l_module_name,
1606: p_log_level => 5);
1607: END IF;*/
1608: /*IF p_pa_debug_mode = 'Y' THEN
1609: pa_fp_gen_amount_utils.fp_debug
1610: (p_msg => 'Value of l_proj_struc_sharing_code: '||l_proj_struc_sharing_code,
1611: p_module_name => l_module_name,
1612: p_log_level => 5);

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

1610: (p_msg => 'Value of l_proj_struc_sharing_code: '||l_proj_struc_sharing_code,
1611: p_module_name => l_module_name,
1612: p_log_level => 5);
1613: END IF;*/
1614: /*IF p_pa_debug_mode = 'Y' THEN
1615: pa_fp_gen_amount_utils.fp_debug
1616: (p_msg => 'Value of p_wp_structure_version_id: '||p_wp_structure_version_id,
1617: p_module_name => l_module_name,
1618: p_log_level => 5);

Line 1628: IF p_pa_debug_mode = 'Y' THEN

1624:
1625: IF p_fp_cols_rec.x_version_type = 'REVENUE' AND
1626: l_fcst_gen_src_code IN ('NONE','AVERAGE_ACTUALS') THEN
1627:
1628: IF p_pa_debug_mode = 'Y' THEN
1629: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1630: P_CALLED_MODE => P_CALLED_MODE,
1631: P_MSG => 'Before calling pa_fp_copy_actuals_pub.copy_actuals',
1632: P_MODULE_NAME => l_module_name);

Line 1644: IF p_pa_debug_mode = 'Y' THEN

1640: P_COMMIT_FLAG => 'N',
1641: X_RETURN_STATUS => X_RETURN_STATUS,
1642: X_MSG_COUNT => X_MSG_COUNT,
1643: X_MSG_DATA => X_MSG_DATA);
1644: IF p_pa_debug_mode = 'Y' THEN
1645: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1646: P_CALLED_MODE => P_CALLED_MODE,
1647: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
1648: ||x_return_status,

Line 1656: IF p_pa_debug_mode = 'Y' THEN

1652: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1653: END IF;
1654:
1655: IF l_fcst_gen_src_code = 'NONE' THEN
1656: IF p_pa_debug_mode = 'Y' THEN
1657: PA_DEBUG.Reset_Curr_Function;
1658: END IF;
1659: RETURN;
1660: END IF;

Line 1657: PA_DEBUG.Reset_Curr_Function;

1653: END IF;
1654:
1655: IF l_fcst_gen_src_code = 'NONE' THEN
1656: IF p_pa_debug_mode = 'Y' THEN
1657: PA_DEBUG.Reset_Curr_Function;
1658: END IF;
1659: RETURN;
1660: END IF;
1661:

Line 1663: IF p_pa_debug_mode = 'Y' THEN

1659: RETURN;
1660: END IF;
1661:
1662: IF l_fcst_gen_src_code = 'AVERAGE_ACTUALS' THEN
1663: IF p_pa_debug_mode = 'Y' THEN
1664: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1665: P_CALLED_MODE => P_CALLED_MODE,
1666: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.'||
1667: 'GEN_AVERAGE_OF_ACTUALS_WRP for Revenue only version',

Line 1698: IF p_pa_debug_mode = 'Y' THEN

1694: X_MSG_COUNT => X_MSG_COUNT,
1695: X_MSG_DATA => X_MSG_DATA );
1696: -- hr_utility.trace('Return status after calling GEN_AVERAGE_OF_ACTUALS_WRP: '
1697: -- ||x_return_status);
1698: IF p_pa_debug_mode = 'Y' THEN
1699: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1700: P_CALLED_MODE => P_CALLED_MODE,
1701: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
1702: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,

Line 1707: IF p_pa_debug_mode = 'Y' THEN

1703: P_MODULE_NAME => l_module_name);
1704: END IF;
1705:
1706: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1707: IF p_pa_debug_mode = 'Y' THEN
1708: PA_DEBUG.Reset_Curr_Function;
1709: END IF;
1710: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1711: END IF;

Line 1708: PA_DEBUG.Reset_Curr_Function;

1704: END IF;
1705:
1706: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1707: IF p_pa_debug_mode = 'Y' THEN
1708: PA_DEBUG.Reset_Curr_Function;
1709: END IF;
1710: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1711: END IF;
1712:

Line 1713: IF p_pa_debug_mode = 'Y' THEN

1709: END IF;
1710: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1711: END IF;
1712:
1713: IF p_pa_debug_mode = 'Y' THEN
1714: PA_DEBUG.Reset_Curr_Function;
1715: END IF;
1716:
1717: RETURN;

Line 1714: PA_DEBUG.Reset_Curr_Function;

1710: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1711: END IF;
1712:
1713: IF p_pa_debug_mode = 'Y' THEN
1714: PA_DEBUG.Reset_Curr_Function;
1715: END IF;
1716:
1717: RETURN;
1718: END IF; -- for average actual check

Line 1731: IF P_PA_DEBUG_MODE = 'Y' THEN

1727: ( p_project_id => P_PROJECT_ID,
1728: p_plan_type_id => -1,
1729: p_proj_str_ver_id => P_WP_STRUCTURE_VERSION_ID );
1730:
1731: IF P_PA_DEBUG_MODE = 'Y' THEN
1732: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1733: P_CALLED_MODE => P_CALLED_MODE,
1734: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1735: 'GET_PLAN_VERSION_DTL',

Line 1745: IF P_PA_DEBUG_MODE = 'Y' THEN

1741: X_FP_COLS_REC => l_fp_cols_rec_wp,
1742: X_RETURN_STATUS => x_return_status,
1743: X_MSG_COUNT => x_msg_count,
1744: X_MSG_DATA => x_msg_data);
1745: IF P_PA_DEBUG_MODE = 'Y' THEN
1746: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1747: P_CALLED_MODE => P_CALLED_MODE,
1748: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1749: 'GET_PLAN_VERSION_DTL:'||x_return_status,

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

1753: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1754: END IF;
1755: END IF;
1756:
1757: /*IF p_pa_debug_mode = 'Y' THEN
1758: pa_fp_gen_amount_utils.fp_debug
1759: (p_msg => 'Value of p_etc_fp_plan_version_id: '||p_etc_fp_plan_version_id,
1760: p_module_name => l_module_name,
1761: p_log_level => 5);

Line 1765: IF P_PA_DEBUG_MODE = 'Y' THEN

1761: p_log_level => 5);
1762: END IF;*/
1763:
1764: IF P_ETC_FP_PLAN_VERSION_ID IS NOT NULL THEN
1765: IF P_PA_DEBUG_MODE = 'Y' THEN
1766: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1767: P_CALLED_MODE => P_CALLED_MODE,
1768: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1769: 'GET_PLAN_VERSION_DTLS',

Line 1779: IF P_PA_DEBUG_MODE = 'Y' THEN

1775: X_FP_COLS_REC => l_fp_cols_rec_fp,
1776: X_RETURN_STATUS => x_return_status,
1777: X_MSG_COUNT => x_msg_count,
1778: X_MSG_DATA => x_msg_data);
1779: IF P_PA_DEBUG_MODE = 'Y' THEN
1780: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1781: P_CALLED_MODE => P_CALLED_MODE,
1782: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1783: 'GET_PLAN_VERSION_DTLS: '||x_return_status,

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

1810: IF P_WP_STRUCTURE_VERSION_ID IS NOT NULL THEN
1811: l_resource_list_id := l_fp_cols_rec_wp.X_RESOURCE_LIST_ID;
1812: l_struct_ver_id := l_fp_cols_rec_wp.X_PROJECT_STRUCTURE_VERSION_ID;
1813:
1814: /*IF p_pa_debug_mode = 'Y' THEN
1815: pa_fp_gen_amount_utils.fp_debug
1816: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
1817: p_module_name => l_module_name,
1818: p_log_level => 5);

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

1816: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
1817: p_module_name => l_module_name,
1818: p_log_level => 5);
1819: END IF;*/
1820: /*IF p_pa_debug_mode = 'Y' THEN
1821: pa_fp_gen_amount_utils.fp_debug
1822: (p_msg => 'Value of l_struct_ver_id: '||l_struct_ver_id,
1823: p_module_name => l_module_name,
1824: p_log_level => 5);

Line 1827: IF P_PA_DEBUG_MODE = 'Y' THEN

1823: p_module_name => l_module_name,
1824: p_log_level => 5);
1825: END IF;*/
1826:
1827: IF P_PA_DEBUG_MODE = 'Y' THEN
1828: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1829: P_CALLED_MODE => P_CALLED_MODE,
1830: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
1831: 'CALL_SUMM_POP_TMPS',

Line 1853: IF P_PA_DEBUG_MODE = 'Y' THEN

1849: X_RETURN_STATUS => x_return_status,
1850: X_MSG_COUNT => x_msg_count,
1851: X_MSG_DATA => x_msg_data );
1852: -- hr_utility.trace('1.Status after calling call_summ_pop_tmps api: '||x_return_status);
1853: IF P_PA_DEBUG_MODE = 'Y' THEN
1854: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1855: P_CALLED_MODE => P_CALLED_MODE,
1856: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
1857: 'CALL_SUMM_POP_TMPS:'||x_return_status,

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

1868: IF P_ETC_FP_PLAN_VERSION_ID IS NOT NULL THEN
1869: l_resource_list_id := l_fp_cols_rec_fp.X_RESOURCE_LIST_ID;
1870: l_struct_ver_id := l_fp_cols_rec_fp.X_PROJECT_STRUCTURE_VERSION_ID;
1871:
1872: /*IF p_pa_debug_mode = 'Y' THEN
1873: pa_fp_gen_amount_utils.fp_debug
1874: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
1875: p_module_name => l_module_name,
1876: p_log_level => 5);

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

1874: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
1875: p_module_name => l_module_name,
1876: p_log_level => 5);
1877: END IF;*/
1878: /*IF p_pa_debug_mode = 'Y' THEN
1879: pa_fp_gen_amount_utils.fp_debug
1880: (p_msg => 'Value of l_struct_ver_id: '||l_struct_ver_id,
1881: p_module_name => l_module_name,
1882: p_log_level => 5);

Line 1885: IF P_PA_DEBUG_MODE = 'Y' THEN

1881: p_module_name => l_module_name,
1882: p_log_level => 5);
1883: END IF;*/
1884:
1885: IF P_PA_DEBUG_MODE = 'Y' THEN
1886: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1887: P_CALLED_MODE => P_CALLED_MODE,
1888: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
1889: 'CALL_SUMM_POP_TMPS',

Line 1911: IF P_PA_DEBUG_MODE = 'Y' THEN

1907: X_RETURN_STATUS => x_return_status,
1908: X_MSG_COUNT => x_msg_count,
1909: X_MSG_DATA => x_msg_data );
1910: -- hr_utility.trace('2.Status after calling call_summ_pop_tmps api: '||x_return_status);
1911: IF P_PA_DEBUG_MODE = 'Y' THEN
1912: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1913: P_CALLED_MODE => P_CALLED_MODE,
1914: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
1915: 'CALL_SUMM_POP_TMPS:'||x_return_status,

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

1923:
1924: --*****Populate pji tmp1,fcst tmp1 tables from target financial version******--
1925: l_resource_list_id := l_fp_cols_rec_target.X_RESOURCE_LIST_ID;
1926: l_struct_ver_id := l_fp_cols_rec_target.X_PROJECT_STRUCTURE_VERSION_ID;
1927: /*IF p_pa_debug_mode = 'Y' THEN
1928: pa_fp_gen_amount_utils.fp_debug
1929: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
1930: p_module_name => l_module_name,
1931: p_log_level => 5);

Line 1933: IF p_pa_debug_mode = 'Y' THEN

1929: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
1930: p_module_name => l_module_name,
1931: p_log_level => 5);
1932: END IF;
1933: IF p_pa_debug_mode = 'Y' THEN
1934: pa_fp_gen_amount_utils.fp_debug
1935: (p_msg => 'Value of l_struct_ver_id: '||l_struct_ver_id,
1936: p_module_name => l_module_name,
1937: p_log_level => 5);

Line 1939: IF P_PA_DEBUG_MODE = 'Y' THEN

1935: (p_msg => 'Value of l_struct_ver_id: '||l_struct_ver_id,
1936: p_module_name => l_module_name,
1937: p_log_level => 5);
1938: END IF;*/
1939: IF P_PA_DEBUG_MODE = 'Y' THEN
1940: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1941: P_CALLED_MODE => P_CALLED_MODE,
1942: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
1943: 'CALL_SUMM_POP_TMPS',

Line 1963: IF P_PA_DEBUG_MODE = 'Y' THEN

1959: X_RETURN_STATUS => x_return_status,
1960: X_MSG_COUNT => x_msg_count,
1961: X_MSG_DATA => x_msg_data );
1962: -- hr_utility.trace('3.Status after calling call_summ_pop_tmps api: '||x_return_status);
1963: IF P_PA_DEBUG_MODE = 'Y' THEN
1964: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1965: P_CALLED_MODE => P_CALLED_MODE,
1966: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
1967: 'CALL_SUMM_POP_TMPS:'||x_return_status,

Line 2026: IF P_PA_DEBUG_MODE = 'Y' THEN

2022: l_gen_etc_source_code_tab;
2023: CLOSE traverse_tasks_cur;
2024: END IF; -- for plan level check
2025:
2026: IF P_PA_DEBUG_MODE = 'Y' THEN
2027: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2028: P_CALLED_MODE => P_CALLED_MODE,
2029: P_MSG => 'In traverse cursor, we have how many records?'||
2030: l_task_id_tab.count,

Line 2034: IF p_pa_debug_mode = 'Y' THEN

2030: l_task_id_tab.count,
2031: P_MODULE_NAME => l_module_name);
2032: END IF;
2033: IF l_task_id_tab.count = 0 THEN
2034: IF p_pa_debug_mode = 'Y' THEN
2035: PA_DEBUG.Reset_Curr_Function;
2036: END IF;
2037: RETURN;
2038: END IF;

Line 2035: PA_DEBUG.Reset_Curr_Function;

2031: P_MODULE_NAME => l_module_name);
2032: END IF;
2033: IF l_task_id_tab.count = 0 THEN
2034: IF p_pa_debug_mode = 'Y' THEN
2035: PA_DEBUG.Reset_Curr_Function;
2036: END IF;
2037: RETURN;
2038: END IF;
2039: /* hr_utility.trace('--Before traverse any task node');

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

2048: hr_utility.trace('--curr etc source is fin/wp/wkqty/avgact:'||
2049: l_gen_etc_source_code_tab(i)); */
2050: --dbms_output.put_line('--task id is:'||l_task_id_tab(i));
2051: --dbms_output.put_line('--curr etc source is fin/wp/wkqty/avgact:'||l_gen_etc_source_code_tab(i));
2052: /* IF p_pa_debug_mode = 'Y' THEN
2053: pa_fp_gen_amount_utils.fp_debug
2054: (p_msg => 'Value of l_curr_etc_source: '||l_curr_etc_source,
2055: p_module_name => l_module_name,
2056: p_log_level => 5);

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

2078: ELSIF l_curr_etc_source = 'WORKPLAN_RESOURCES' THEN
2079: l_calling_context := 'WORK_PLAN';
2080: END IF;
2081:
2082: /*IF p_pa_debug_mode = 'Y' THEN
2083: pa_fp_gen_amount_utils.fp_debug
2084: (p_msg => 'Value of l_calling_context: '||l_calling_context,
2085: p_module_name => l_module_name,
2086: p_log_level => 5);

Line 2091: IF P_PA_DEBUG_MODE = 'Y' THEN

2087: END IF;*/
2088:
2089: /**Calling the total_plan_txn_amts api to get the total
2090: *transaction amts for a given task**/
2091: IF P_PA_DEBUG_MODE = 'Y' THEN
2092: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2093: P_CALLED_MODE => P_CALLED_MODE,
2094: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
2095: 'get_total_plan_txn_amts',

Line 2129: IF p_pa_debug_mode = 'Y' THEN

2125: X_MSG_COUNT => x_msg_count,
2126: X_MSG_DATA => x_msg_data );
2127: EXCEPTION
2128: WHEN no_data_found THEN
2129: IF p_pa_debug_mode = 'Y' THEN
2130: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2131: P_CALLED_MODE => P_CALLED_MODE,
2132: P_MSG => 'PA_FP_GEN_FCST_AMT_PVT.GET_TOTAL_PLAN_TXN_AMTS '||
2133: 'throws out no_data_found exception',

Line 2137: IF p_pa_debug_mode = 'Y' THEN

2133: 'throws out no_data_found exception',
2134: P_MODULE_NAME => l_module_name);
2135: END IF;
2136: END;
2137: IF p_pa_debug_mode = 'Y' THEN
2138: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2139: P_CALLED_MODE => P_CALLED_MODE,
2140: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
2141: 'get_total_plan_txn_amts: '||x_return_status,

Line 2145: IF p_pa_debug_mode = 'Y' THEN

2141: 'get_total_plan_txn_amts: '||x_return_status,
2142: P_MODULE_NAME => l_module_name);
2143: END IF;
2144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2145: IF p_pa_debug_mode = 'Y' THEN
2146: PA_DEBUG.Reset_Curr_Function;
2147: END IF;
2148: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2149: END IF;

Line 2146: PA_DEBUG.Reset_Curr_Function;

2142: P_MODULE_NAME => l_module_name);
2143: END IF;
2144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2145: IF p_pa_debug_mode = 'Y' THEN
2146: PA_DEBUG.Reset_Curr_Function;
2147: END IF;
2148: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2149: END IF;
2150: END IF;

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

2148: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2149: END IF;
2150: END IF;
2151: ELSIF l_curr_etc_source = 'WORK_QUANTITY' THEN
2152: /*IF p_pa_debug_mode = 'Y' THEN
2153: pa_fp_gen_amount_utils.fp_debug
2154: (p_msg => 'Value of l_curr_etc_source: '||l_curr_etc_source,
2155: p_module_name => l_module_name,
2156: p_log_level => 5);

Line 2158: IF p_pa_debug_mode = 'Y' THEN

2154: (p_msg => 'Value of l_curr_etc_source: '||l_curr_etc_source,
2155: p_module_name => l_module_name,
2156: p_log_level => 5);
2157: END IF;
2158: IF p_pa_debug_mode = 'Y' THEN
2159: pa_fp_gen_amount_utils.fp_debug
2160: (p_msg => 'Value of l_work_qty_cnt: '||l_work_qty_cnt,
2161: p_module_name => l_module_name,
2162: p_log_level => 5);

Line 2164: IF p_pa_debug_mode = 'Y' THEN

2160: (p_msg => 'Value of l_work_qty_cnt: '||l_work_qty_cnt,
2161: p_module_name => l_module_name,
2162: p_log_level => 5);
2163: END IF;
2164: IF p_pa_debug_mode = 'Y' THEN
2165: pa_fp_gen_amount_utils.fp_debug
2166: (p_msg => 'Value of l_proj_struc_sharing_code: '||l_proj_struc_sharing_code,
2167: p_module_name => l_module_name,
2168: p_log_level => 5);

Line 2175: IF P_PA_DEBUG_MODE = 'Y' THEN

2171: IF l_proj_struc_sharing_code = 'SPLIT_NO_MAPPING' THEN
2172: l_work_qty_cnt := 1;
2173: l_curr_task_id := NULL;
2174: END IF;
2175: IF P_PA_DEBUG_MODE = 'Y' THEN
2176: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2177: P_CALLED_MODE => P_CALLED_MODE,
2178: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.'||
2179: 'GET_ETC_WORK_QTY_AMTS',

Line 2196: IF p_pa_debug_mode = 'Y' THEN

2192: P_WP_STRUCTURE_VERSION_ID => P_WP_STRUCTURE_VERSION_ID,
2193: X_RETURN_STATUS => x_return_status,
2194: X_MSG_COUNT => x_msg_count,
2195: X_MSG_DATA => x_msg_data);
2196: IF p_pa_debug_mode = 'Y' THEN
2197: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2198: P_CALLED_MODE => P_CALLED_MODE,
2199: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub1.'||
2200: 'GET_ETC_WORK_QTY_AMTS: '||x_return_status,

Line 2208: IF P_PA_DEBUG_MODE = 'Y' THEN

2204: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2205: END IF;
2206: END IF;
2207: ELSIF l_curr_etc_source = 'NONE' THEN
2208: IF P_PA_DEBUG_MODE = 'Y' THEN
2209: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2210: P_CALLED_MODE => P_CALLED_MODE,
2211: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.none_etc_src',
2212: P_MODULE_NAME => l_module_name);

Line 2223: IF p_pa_debug_mode = 'Y' THEN

2219: X_RETURN_STATUS => x_return_status,
2220: X_MSG_COUNT => x_msg_count,
2221: X_MSG_DATA => x_msg_data );
2222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2223: IF p_pa_debug_mode = 'Y' THEN
2224: PA_DEBUG.Reset_Curr_Function;
2225: END IF;
2226: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2227: END IF;

Line 2224: PA_DEBUG.Reset_Curr_Function;

2220: X_MSG_COUNT => x_msg_count,
2221: X_MSG_DATA => x_msg_data );
2222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2223: IF p_pa_debug_mode = 'Y' THEN
2224: PA_DEBUG.Reset_Curr_Function;
2225: END IF;
2226: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2227: END IF;
2228: END IF;

Line 2266: IF p_pa_debug_mode = 'Y' THEN

2262: target forecast verion resource list before calculating the ETC numbers.
2263: The ETC calculation is based on the rate based flag of the target
2264: planning resource. */
2265:
2266: IF p_pa_debug_mode = 'Y' THEN
2267: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2268: P_CALLED_MODE => P_CALLED_MODE,
2269: P_MSG => 'Before calling pa_fp_gen_fcst_rmap_pkg.fcst_src_txns_rmap',
2270: P_MODULE_NAME => l_module_name);

Line 2281: IF p_pa_debug_mode = 'Y' THEN

2277: X_RETURN_STATUS => X_RETURN_STATUS,
2278: X_MSG_COUNT => X_MSG_COUNT,
2279: X_MSG_DATA => X_MSG_DATA);
2280: -- hr_utility.trace('after fcst src txns rmap');
2281: IF p_pa_debug_mode = 'Y' THEN
2282: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2283: P_CALLED_MODE => P_CALLED_MODE,
2284: P_MSG => 'After calling pa_fp_gen_fcst_rmap_pkg.fcst_src_txns_rmap'
2285: ||x_return_status,

Line 2297: IF p_pa_debug_mode = 'Y' THEN

2293: -- resource mapping, which also calls CREATE_RES_ASG and UPDATE_RES_ASG
2294: -- via call to MAINTAIN_RES_ASG, so that planning dates from the source
2295: -- are honored when possible, since resources created by the Copy Actuals
2296: -- API use task/project-level default dates.
2297: IF p_pa_debug_mode = 'Y' THEN
2298: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2299: P_CALLED_MODE => P_CALLED_MODE,
2300: P_MSG => 'Before calling pa_fp_copy_actuals_pub.copy_actuals',
2301: P_MODULE_NAME => l_module_name);

Line 2313: IF p_pa_debug_mode = 'Y' THEN

2309: P_COMMIT_FLAG => 'N',
2310: X_RETURN_STATUS => X_RETURN_STATUS,
2311: X_MSG_COUNT => X_MSG_COUNT,
2312: X_MSG_DATA => X_MSG_DATA);
2313: IF p_pa_debug_mode = 'Y' THEN
2314: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2315: P_CALLED_MODE => P_CALLED_MODE,
2316: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
2317: ||x_return_status,

Line 2327: IF p_pa_debug_mode = 'Y' THEN

2323:
2324: -- Now that we have copied the actuals, we do the delayed processing
2325: -- for tasks with source of Average of Actuals.
2326: FOR i IN 1..l_avg_actuals_task_id_tab.count LOOP
2327: IF p_pa_debug_mode = 'Y' THEN
2328: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2329: P_CALLED_MODE => P_CALLED_MODE,
2330: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.'||
2331: 'GEN_AVERAGE_OF_ACTUALS_WRP',

Line 2356: IF p_pa_debug_mode = 'Y' THEN

2352: X_MSG_COUNT => X_MSG_COUNT,
2353: X_MSG_DATA => X_MSG_DATA );
2354: -- hr_utility.trace('Return status after calling GEN_AVERAGE_OF_ACTUALS_WRP: '
2355: -- ||x_return_status);
2356: IF p_pa_debug_mode = 'Y' THEN
2357: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2358: P_CALLED_MODE => P_CALLED_MODE,
2359: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
2360: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,

Line 2364: IF p_pa_debug_mode = 'Y' THEN

2360: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,
2361: P_MODULE_NAME => l_module_name);
2362: END IF;
2363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2364: IF p_pa_debug_mode = 'Y' THEN
2365: PA_DEBUG.Reset_Curr_Function;
2366: END IF;
2367: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2368: END IF;

Line 2365: PA_DEBUG.Reset_Curr_Function;

2361: P_MODULE_NAME => l_module_name);
2362: END IF;
2363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2364: IF p_pa_debug_mode = 'Y' THEN
2365: PA_DEBUG.Reset_Curr_Function;
2366: END IF;
2367: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2368: END IF;
2369: END LOOP;

Line 2390: /* IF P_PA_DEBUG_MODE = 'Y' THEN

2386:
2387: DELETE FROM PA_FP_CALC_AMT_TMP3;
2388: /* the following code is commented. We are not going to use the
2389: baselined budget cost for ETC gen method Plan to Complete. */
2390: /* IF P_PA_DEBUG_MODE = 'Y' THEN
2391: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2392: P_CALLED_MODE => P_CALLED_MODE,
2393: P_MSG => 'Before calling PA_FIN_PLAN_UTILS.'||
2394: 'Get_Appr_Cost_Plan_Type_Info',

Line 2405: IF P_PA_DEBUG_MODE = 'Y' THEN

2401: x_msg_count => x_msg_count,
2402: x_msg_data => x_msg_data);
2403:
2404: --dbms_output.put_line('l_fin_plan_type_id is '||l_fin_plan_type_id);
2405: IF P_PA_DEBUG_MODE = 'Y' THEN
2406: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2407: P_CALLED_MODE => P_CALLED_MODE,
2408: P_MSG => 'After calling PA_FIN_PLAN_UTILS.'||
2409: 'Get_Appr_Cost_Plan_Type_Info: '||x_return_status,

Line 2430: IF P_PA_DEBUG_MODE = 'Y' THEN

2426: AND fin_plan_option_level_code = 'PLAN_TYPE'
2427: AND project_id = P_PROJECT_ID;
2428:
2429: --dbms_output.put_line('--l_version_type: '||l_version_type);
2430: IF P_PA_DEBUG_MODE = 'Y' THEN
2431: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2432: P_CALLED_MODE => P_CALLED_MODE,
2433: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
2434: 'Get_Curr_Original_Version_Info',

Line 2449: IF P_PA_DEBUG_MODE = 'Y' THEN

2445: x_msg_count => x_msg_count,
2446: x_msg_data => x_msg_data);
2447: --dbms_output.put_line('--!after PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info'||x_return_status);
2448: --dbms_output.put_line('--l_approved_fp_version_id is:'||l_approved_fp_version_id);
2449: IF P_PA_DEBUG_MODE = 'Y' THEN
2450: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2451: P_CALLED_MODE => P_CALLED_MODE,
2452: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
2453: 'Get_Curr_Original_Version_Info: '||x_return_status,

Line 2466: IF P_PA_DEBUG_MODE = 'Y' THEN

2462: p_msg_name => 'PA_FP_GENFCST_NO_APPR_FPVER');
2463: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2464: END IF;
2465:
2466: IF P_PA_DEBUG_MODE = 'Y' THEN
2467: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2468: P_CALLED_MODE => P_CALLED_MODE,
2469: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
2470: 'GET_PLAN_VERSION_DTLS',

Line 2482: IF P_PA_DEBUG_MODE = 'Y' THEN

2478: X_RETURN_STATUS => x_return_status,
2479: X_MSG_COUNT => x_msg_count,
2480: X_MSG_DATA => x_msg_data);
2481: --dbms_output.put_line('--after PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS :'||x_return_status);
2482: IF P_PA_DEBUG_MODE = 'Y' THEN
2483: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2484: P_CALLED_MODE => P_CALLED_MODE,
2485: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
2486: 'GET_PLAN_VERSION_DTLS: '||x_return_status,

Line 2493: IF P_PA_DEBUG_MODE = 'Y' THEN

2489: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2490: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2491: END IF;
2492:
2493: IF P_PA_DEBUG_MODE = 'Y' THEN
2494: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2495: P_CALLED_MODE => P_CALLED_MODE,
2496: P_MSG => 'Before calling PA_FP_MAP_BV_PUB.'||
2497: 'GEN_MAP_BV_TO_TARGET_RL',

Line 2512: IF P_PA_DEBUG_MODE = 'Y' THEN

2508: X_MSG_COUNT => x_msg_count,
2509: X_MSG_DATA => x_msg_data);
2510: --dbms_output.put_line('--PA_FP_MAP_BV_PUB.GEN_MAP_BV_TO_TARGET_RL:' ||x_return_status);
2511: --hr_utility.trace('aft call GEN_MAP_BV_TO_TARGET_RL api:'||x_return_status);
2512: IF P_PA_DEBUG_MODE = 'Y' THEN
2513: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2514: P_CALLED_MODE => P_CALLED_MODE,
2515: P_MSG => 'After calling PA_FP_MAP_BV_PUB.'||
2516: 'GEN_MAP_BV_TO_TARGET_RL: '||x_return_status,

Line 2523: IF P_PA_DEBUG_MODE = 'Y' THEN

2519: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2520: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2521: END IF;
2522:
2523: IF P_PA_DEBUG_MODE = 'Y' THEN
2524: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2525: P_CALLED_MODE => P_CALLED_MODE,
2526: P_MSG => 'Before calling PA_FP_MAP_BV_PUB.'||
2527: 'GEN_MAP_BV_TO_TARGET_RL(2nd time)',

Line 2539: IF P_PA_DEBUG_MODE = 'Y' THEN

2535: X_RETURN_STATUS => x_return_status,
2536: X_MSG_COUNT => x_msg_count,
2537: X_MSG_DATA => x_msg_data);
2538: --tmp3's basedline value will be used in method api
2539: IF P_PA_DEBUG_MODE = 'Y' THEN
2540: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2541: P_CALLED_MODE => P_CALLED_MODE,
2542: P_MSG => 'After calling PA_FP_MAP_BV_PUB.'||
2543: 'GEN_MAP_BV_TO_TARGET_RL:(2nd time) '||x_return_status,

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

2569: l_tgt_ra_id_tab2,
2570: l_rlm_id_tab2,
2571: l_etc_method_tab2;
2572: CLOSE traverse_tasks_rlm_cur;
2573: /*IF p_pa_debug_mode = 'Y' THEN
2574: pa_fp_gen_amount_utils.fp_debug
2575: (p_msg => 'Value of l_ra_id_tab2.count: '||l_ra_id_tab2.count,
2576: p_module_name => l_module_name,
2577: p_log_level => 5);

Line 2582: IF P_PA_DEBUG_MODE = 'Y' THEN

2578: END IF;*/
2579: --dbms_output.put_line('++l_ra_id_tab2.count:'||l_ra_id_tab2.count);
2580: --dbms_output.put_line('++l_ra_id_tab2.first:'||l_ra_id_tab2.first);
2581: --dbms_output.put_line('++l_ra_id_tab2.last:'||l_ra_id_tab2.last);
2582: IF P_PA_DEBUG_MODE = 'Y' THEN
2583: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2584: P_CALLED_MODE => P_CALLED_MODE,
2585: P_MSG => 'second traverse cursor, we have how many records?'
2586: ||l_src_ra_id_tab2.count,

Line 2603: IF P_PA_DEBUG_MODE = 'Y' THEN

2599:
2600: IF l_wp_version_id IS NOT NULL AND
2601: p_fp_cols_rec.x_gen_etc_src_code IN ('WORKPLAN_RESOURCES','TASK_LEVEL_SEL') THEN
2602:
2603: IF P_PA_DEBUG_MODE = 'Y' THEN
2604: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2605: P_CALLED_MODE => P_CALLED_MODE,
2606: P_MSG => 'Before calling PA_FP_FCST_GEN_AMT_UTILS.'||
2607: 'COMPARE_ETC_SRC_TARGET_FP_OPT',

Line 2619: IF P_PA_DEBUG_MODE = 'Y' THEN

2615: X_SAME_PLANNING_OPTION_FLAG => l_wp_planning_options_flag, /* Bug 4369741 */
2616: X_RETURN_STATUS => X_RETURN_STATUS,
2617: X_MSG_COUNT => X_MSG_COUNT,
2618: X_MSG_DATA => X_MSG_DATA);
2619: IF P_PA_DEBUG_MODE = 'Y' THEN
2620: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2621: P_CALLED_MODE => P_CALLED_MODE,
2622: P_MSG => 'After calling PA_FP_FCST_GEN_AMT_UTILS.'||
2623: 'COMPARE_ETC_SRC_TARGET_FP_OPT:'||l_wp_planning_options_flag,

Line 2634: IF P_PA_DEBUG_MODE = 'Y' THEN

2630:
2631: IF p_etc_fp_plan_version_id IS NOT NULL AND
2632: p_fp_cols_rec.x_gen_etc_src_code IN ('FINANCIAL_PLAN','TASK_LEVEL_SEL') THEN
2633:
2634: IF P_PA_DEBUG_MODE = 'Y' THEN
2635: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2636: P_CALLED_MODE => P_CALLED_MODE,
2637: P_MSG => 'Before calling PA_FP_FCST_GEN_AMT_UTILS.'||
2638: 'COMPARE_ETC_SRC_TARGET_FP_OPT',

Line 2650: IF P_PA_DEBUG_MODE = 'Y' THEN

2646: X_SAME_PLANNING_OPTION_FLAG => l_fp_planning_options_flag, /* Bug 4369741 */
2647: X_RETURN_STATUS => X_RETURN_STATUS,
2648: X_MSG_COUNT => X_MSG_COUNT,
2649: X_MSG_DATA => X_MSG_DATA);
2650: IF P_PA_DEBUG_MODE = 'Y' THEN
2651: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2652: P_CALLED_MODE => P_CALLED_MODE,
2653: P_MSG => 'After calling PA_FP_FCST_GEN_AMT_UTILS.'||
2654: 'COMPARE_ETC_SRC_TARGET_FP_OPT:'||l_fp_planning_options_flag,

Line 2666: IF P_PA_DEBUG_MODE = 'Y' THEN

2662:
2663: /* hr_utility.trace('l_src_ra_id_tab2.COUNT :'||l_src_ra_id_tab2.COUNT);
2664: hr_utility.trace('before for loop :'); */
2665:
2666: IF P_PA_DEBUG_MODE = 'Y' THEN
2667: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2668: P_CALLED_MODE => P_CALLED_MODE,
2669: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PVT.'||
2670: 'UPD_TGT_RATE_BASED_FLAG',

Line 2678: IF P_PA_DEBUG_MODE = 'Y' THEN

2674: P_FP_COLS_REC => P_FP_COLS_REC,
2675: X_RETURN_STATUS => x_return_status,
2676: X_MSG_COUNT => x_msg_count,
2677: X_MSG_DATA => x_msg_data);
2678: IF P_PA_DEBUG_MODE = 'Y' THEN
2679: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2680: P_CALLED_MODE => P_CALLED_MODE,
2681: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PVT.'||
2682: 'UPD_TGT_RATE_BASED_FLAG: '||x_return_status,

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

2704: l_curr_src_ra_id := l_src_ra_id_tab2(i);
2705: l_curr_tgt_ra_id := l_tgt_ra_id_tab2(i);
2706: l_curr_rlm_id := l_rlm_id_tab2(i);
2707: l_curr_etc_method_code := l_etc_method_tab2(i);
2708: /*IF p_pa_debug_mode = 'Y' THEN
2709: pa_fp_gen_amount_utils.fp_debug
2710: (p_msg => 'Value of l_curr_task_id: '||l_curr_task_id,
2711: p_module_name => l_module_name,
2712: p_log_level => 5);

Line 2714: IF p_pa_debug_mode = 'Y' THEN

2710: (p_msg => 'Value of l_curr_task_id: '||l_curr_task_id,
2711: p_module_name => l_module_name,
2712: p_log_level => 5);
2713: END IF;
2714: IF p_pa_debug_mode = 'Y' THEN
2715: pa_fp_gen_amount_utils.fp_debug
2716: (p_msg => 'Value of l_curr_etc_source: '||l_curr_etc_source,
2717: p_module_name => l_module_name,
2718: p_log_level => 5);

Line 2720: IF p_pa_debug_mode = 'Y' THEN

2716: (p_msg => 'Value of l_curr_etc_source: '||l_curr_etc_source,
2717: p_module_name => l_module_name,
2718: p_log_level => 5);
2719: END IF;
2720: IF p_pa_debug_mode = 'Y' THEN
2721: pa_fp_gen_amount_utils.fp_debug
2722: (p_msg => 'Value of l_curr_ra_id: '||l_curr_ra_id,
2723: p_module_name => l_module_name,
2724: p_log_level => 5);

Line 2726: IF p_pa_debug_mode = 'Y' THEN

2722: (p_msg => 'Value of l_curr_ra_id: '||l_curr_ra_id,
2723: p_module_name => l_module_name,
2724: p_log_level => 5);
2725: END IF;
2726: IF p_pa_debug_mode = 'Y' THEN
2727: pa_fp_gen_amount_utils.fp_debug
2728: (p_msg => 'Value of l_curr_rlm_id: '||l_curr_rlm_id,
2729: p_module_name => l_module_name,
2730: p_log_level => 5);

Line 2732: IF p_pa_debug_mode = 'Y' THEN

2728: (p_msg => 'Value of l_curr_rlm_id: '||l_curr_rlm_id,
2729: p_module_name => l_module_name,
2730: p_log_level => 5);
2731: END IF;
2732: IF p_pa_debug_mode = 'Y' THEN
2733: pa_fp_gen_amount_utils.fp_debug
2734: (p_msg => 'Value of l_curr_etc_method_code: '||l_curr_etc_method_code,
2735: p_module_name => l_module_name,
2736: p_log_level => 5);

Line 2777: IF P_PA_DEBUG_MODE = 'Y' THEN

2773: /* Bug 4369741: Pass NULL for the P_PLANNING_OPTIONS_FLAG parameter
2774: * to make explicit the fact that the ETC method APIs do not make
2775: * use of the planning options flag. All of the planning options logic
2776: * is present in this API itself. */
2777: IF P_PA_DEBUG_MODE = 'Y' THEN
2778: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2779: P_CALLED_MODE => P_CALLED_MODE,
2780: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||
2781: 'GET_ETC_REMAIN_BDGT_AMTS_BLK',

Line 2799: IF p_pa_debug_mode = 'Y' THEN

2795: P_PLANNING_OPTIONS_FLAG => NULL, /* Bug 4369741 */
2796: X_RETURN_STATUS => x_return_status,
2797: X_MSG_COUNT => x_msg_count,
2798: X_MSG_DATA => x_msg_data);
2799: IF p_pa_debug_mode = 'Y' THEN
2800: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2801: P_CALLED_MODE => P_CALLED_MODE,
2802: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||
2803: 'GET_ETC_REMAIN_BDGT_AMTS_BLK: '||x_return_status,

Line 2816: IF P_PA_DEBUG_MODE = 'Y' THEN

2812: /* Bug 4369741: Pass NULL for the P_PLANNING_OPTIONS_FLAG parameter
2813: * to make explicit the fact that the ETC method APIs do not make
2814: * use of the planning options flag. All of the planning options logic
2815: * is present in this API itself. */
2816: IF P_PA_DEBUG_MODE = 'Y' THEN
2817: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2818: P_CALLED_MODE => P_CALLED_MODE,
2819: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub4.'||
2820: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK',

Line 2838: IF p_pa_debug_mode = 'Y' THEN

2834: P_PLANNING_OPTIONS_FLAG => NULL, /* Bug 4369741 */
2835: X_RETURN_STATUS => x_return_status,
2836: X_MSG_COUNT => x_msg_count,
2837: X_MSG_DATA => x_msg_data);
2838: IF p_pa_debug_mode = 'Y' THEN
2839: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2840: P_CALLED_MODE => P_CALLED_MODE,
2841: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub4.'||
2842: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK: '||x_return_status,

Line 2855: IF P_PA_DEBUG_MODE = 'Y' THEN

2851: /* Bug 4369741: Pass NULL for the P_PLANNING_OPTIONS_FLAG parameter
2852: * to make explicit the fact that the ETC method APIs do not make
2853: * use of the planning options flag. All of the planning options logic
2854: * is present in this API itself. */
2855: IF P_PA_DEBUG_MODE = 'Y' THEN
2856: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2857: P_CALLED_MODE => P_CALLED_MODE,
2858: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub5.'||
2859: 'GET_ETC_EARNED_VALUE_AMTS_BLK',

Line 2877: IF p_pa_debug_mode = 'Y' THEN

2873: P_PLANNING_OPTIONS_FLAG => NULL, /* Bug 4369741 */
2874: X_RETURN_STATUS => x_return_status,
2875: X_MSG_COUNT => x_msg_count,
2876: X_MSG_DATA => x_msg_data);
2877: IF p_pa_debug_mode = 'Y' THEN
2878: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2879: P_CALLED_MODE => P_CALLED_MODE,
2880: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub5.'||
2881: 'GET_ETC_EARNED_VALUE_AMTS_BLK: '||x_return_status,

Line 2896: IF P_PA_DEBUG_MODE = 'Y' THEN

2892: * API to reflect spec change from a single planning options
2893: * flag to 2 separate flags for Workplan and Financial Plan sources. */
2894:
2895: -- hr_utility.trace('after for loop :');
2896: IF P_PA_DEBUG_MODE = 'Y' THEN
2897: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2898: P_CALLED_MODE => P_CALLED_MODE,
2899: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB3.'||
2900: 'GET_ETC_COMMITMENT_AMTS',

Line 2914: IF p_pa_debug_mode = 'Y' THEN

2910: X_MSG_DATA => x_msg_data);
2911:
2912: -- hr_utility.trace('after pub3 cmt amts:');
2913:
2914: IF p_pa_debug_mode = 'Y' THEN
2915: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2916: P_CALLED_MODE => P_CALLED_MODE,
2917: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB3.'||
2918: 'GET_ETC_COMMITMENT_AMTS: '||x_return_status,

Line 3328: IF p_pa_debug_mode = 'Y' THEN

3324: SELECT DISTINCT column_value
3325: FROM TABLE( CAST( l_ra_id_tab_table(i) AS SYSTEM.pa_num_tbl_type ));
3326:
3327: -- Call the maintenance api in COPY mode
3328: IF p_pa_debug_mode = 'Y' THEN
3329: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3330: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3331: 'MAINTAIN_DATA',
3332: P_CALLED_MODE => p_called_mode,

Line 3346: IF p_pa_debug_mode = 'Y' THEN

3342: P_CALLED_MODE => p_called_mode,
3343: X_RETURN_STATUS => x_return_status,
3344: X_MSG_COUNT => x_msg_count,
3345: X_MSG_DATA => x_msg_data );
3346: IF p_pa_debug_mode = 'Y' THEN
3347: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3348: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3349: 'MAINTAIN_DATA: '||x_return_status,
3350: P_CALLED_MODE => p_called_mode,

Line 3397: IF p_pa_debug_mode = 'Y' THEN

3393: l_count := SQL%ROWCOUNT;
3394:
3395: IF l_count > 0 THEN
3396: -- CALL the maintenance api in INSERT mode
3397: IF p_pa_debug_mode = 'Y' THEN
3398: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3399: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3400: 'MAINTAIN_DATA',
3401: P_CALLED_MODE => p_called_mode,

Line 3413: IF p_pa_debug_mode = 'Y' THEN

3409: P_CALLED_MODE => p_called_mode,
3410: X_RETURN_STATUS => x_return_status,
3411: X_MSG_COUNT => x_msg_count,
3412: X_MSG_DATA => x_msg_data );
3413: IF p_pa_debug_mode = 'Y' THEN
3414: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3415: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3416: 'MAINTAIN_DATA: '||x_return_status,
3417: P_CALLED_MODE => p_called_mode,

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

3429:
3430: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' and l_rev_gen_method = 'C' THEN
3431: l_cal_etc_revenue_tab := l_cal_etc_burdened_cost_tab;
3432: END IF;
3433: /*IF p_pa_debug_mode = 'Y' THEN
3434: pa_fp_gen_amount_utils.fp_debug
3435: (p_msg => 'Value of l_rev_gen_method: '||l_rev_gen_method,
3436: p_module_name => l_module_name,
3437: p_log_level => 5);

Line 3439: IF p_pa_debug_mode = 'Y' THEN

3435: (p_msg => 'Value of l_rev_gen_method: '||l_rev_gen_method,
3436: p_module_name => l_module_name,
3437: p_log_level => 5);
3438: END IF;
3439: IF p_pa_debug_mode = 'Y' THEN
3440: pa_fp_gen_amount_utils.fp_debug
3441: (p_msg => 'Value of l_cal_etc_revenue_tab.count: '||l_cal_etc_revenue_tab.count,
3442: p_module_name => l_module_name,
3443: p_log_level => 5);

Line 3445: IF p_pa_debug_mode = 'Y' THEN

3441: (p_msg => 'Value of l_cal_etc_revenue_tab.count: '||l_cal_etc_revenue_tab.count,
3442: p_module_name => l_module_name,
3443: p_log_level => 5);
3444: END IF;
3445: IF p_pa_debug_mode = 'Y' THEN
3446: pa_fp_gen_amount_utils.fp_debug
3447: (p_msg => 'Value of l_cal_ra_id_tab.count: '||l_cal_ra_id_tab.count,
3448: p_module_name => l_module_name,
3449: p_log_level => 5);

Line 3610: IF P_PA_DEBUG_MODE = 'Y' THEN

3606: l_target_version_type = 'REVENUE' AND
3607: l_rev_gen_method = 'E' THEN
3608: /*Revenue is only based on billing events, which is handled seperately*/
3609: l_dummy := 1;
3610: IF P_PA_DEBUG_MODE = 'Y' THEN
3611: PA_DEBUG.RESET_CURR_FUNCTION;
3612: END IF;
3613: RETURN;
3614: ELSIF l_source_version_type_tab(i) = 'ALL' AND

Line 3611: PA_DEBUG.RESET_CURR_FUNCTION;

3607: l_rev_gen_method = 'E' THEN
3608: /*Revenue is only based on billing events, which is handled seperately*/
3609: l_dummy := 1;
3610: IF P_PA_DEBUG_MODE = 'Y' THEN
3611: PA_DEBUG.RESET_CURR_FUNCTION;
3612: END IF;
3613: RETURN;
3614: ELSIF l_source_version_type_tab(i) = 'ALL' AND
3615: l_target_version_type = 'ALL' AND

Line 3786: IF P_PA_DEBUG_MODE = 'Y' THEN

3782: NOT ( p_fp_cols_rec.x_version_type = 'ALL' AND l_rev_gen_method = 'T' AND
3783: l_rev_only_src_txn_flag_tab(i) = 'Y' AND l_cal_rate_based_flag_tab(i) = 'N') THEN
3784:
3785: -- hr_utility.trace('==inside plan option same flag = Y ');
3786: IF P_PA_DEBUG_MODE = 'Y' THEN
3787: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3788: P_CALLED_MODE => P_CALLED_MODE,
3789: P_MSG =>
3790: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',

Line 3803: IF P_PA_DEBUG_MODE = 'Y' THEN

3799: X_MSG_DATA => x_msg_data);
3800: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3801: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3802: END IF;
3803: IF P_PA_DEBUG_MODE = 'Y' THEN
3804: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3805: P_CALLED_MODE => P_CALLED_MODE,
3806: P_MSG =>
3807: 'After calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE: '||x_return_status,

Line 3910: IF P_PA_DEBUG_MODE = 'Y' THEN

3906: END IF;
3907: END IF; -- ER 4376722 billability logic for ALL versions
3908:
3909:
3910: IF P_PA_DEBUG_MODE = 'Y' THEN
3911: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3912: P_CALLED_MODE => P_CALLED_MODE,
3913: P_MSG =>
3914: 'Before calling pa_fp_fcst_gen_client_ext.fcst_gen_client_extn',

Line 3966: IF P_PA_DEBUG_MODE = 'Y' THEN

3962: X_MSG_COUNT => x_msg_count);
3963:
3964: -- hr_utility.trace('==after calling client extn api ');
3965:
3966: IF P_PA_DEBUG_MODE = 'Y' THEN
3967: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3968: P_CALLED_MODE => P_CALLED_MODE,
3969: P_MSG =>
3970: 'After calling pa_fp_fcst_gen_client_ext.fcst_gen_client_extn: '

Line 4454: IF P_PA_DEBUG_MODE = 'Y' THEN

4450: -- burdened cost based on the revenue accrual method.
4451: l_amt_dtls_tbl(1).txn_revenue := l_amt_dtls_tbl(1).quantity;
4452: END IF;
4453:
4454: IF P_PA_DEBUG_MODE = 'Y' THEN
4455: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4456: P_CALLED_MODE => P_CALLED_MODE,
4457: P_MSG => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.'||
4458: 'MAINTAIN_ACTUAL_AMT_RA',

Line 4472: IF P_PA_DEBUG_MODE = 'Y' THEN

4468: P_TXN_AMT_TYPE_CODE => 'PLANNING_TXN',
4469: X_RETURN_STATUS => x_return_Status,
4470: X_MSG_COUNT => x_msg_count,
4471: X_MSG_DATA => x_msg_data );
4472: IF P_PA_DEBUG_MODE = 'Y' THEN
4473: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4474: P_CALLED_MODE => P_CALLED_MODE,
4475: P_MSG => 'After calling PA_FP_MAINTAIN_ACTUAL_PUB.'||
4476: 'MAINTAIN_ACTUAL_AMT_RA: '||x_return_status,

Line 4483: IF p_pa_debug_mode = 'Y' THEN

4479: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4480: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4481: END IF;
4482: END LOOP;
4483: IF p_pa_debug_mode = 'Y' THEN
4484: PA_DEBUG.Reset_Curr_Function;
4485: END IF;
4486: RETURN;
4487: END IF;

Line 4484: PA_DEBUG.Reset_Curr_Function;

4480: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4481: END IF;
4482: END LOOP;
4483: IF p_pa_debug_mode = 'Y' THEN
4484: PA_DEBUG.Reset_Curr_Function;
4485: END IF;
4486: RETURN;
4487: END IF;
4488:

Line 4544: IF p_pa_debug_mode = 'Y' THEN

4540: INSERT INTO pa_res_list_map_tmp1
4541: ( txn_resource_assignment_id )
4542: VALUES ( l_cal_ra_id_tab(i) );
4543:
4544: IF p_pa_debug_mode = 'Y' THEN
4545: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4546: ( p_msg => 'Before calling PA_FP_GEN_PUB.' ||
4547: 'COPY_SRC_ATTRS_TO_TARGET_FCST',
4548: p_module_name => l_module_name,

Line 4556: IF p_pa_debug_mode = 'Y' THEN

4552: ( P_FP_COLS_REC => p_fp_cols_rec,
4553: X_RETURN_STATUS => x_return_status,
4554: X_MSG_COUNT => x_msg_count,
4555: X_MSG_DATA => x_msg_data );
4556: IF p_pa_debug_mode = 'Y' THEN
4557: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4558: ( p_msg => 'Status after calling PA_FP_GEN_PUB.' ||
4559: 'COPY_SRC_ATTRS_TO_TARGET_FCST: ' ||
4560: x_return_status,

Line 4569: IF P_PA_DEBUG_MODE = 'Y' THEN

4565: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4566: END IF;
4567: -- Bug 3991151: End changes.
4568:
4569: IF P_PA_DEBUG_MODE = 'Y' THEN
4570: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4571: P_CALLED_MODE => P_CALLED_MODE,
4572: P_MSG => 'Before calling PA_FP_CALC_PLAN_PKG.calculate',
4573: P_MODULE_NAME => l_module_name);

Line 4631: IF P_PA_DEBUG_MODE = 'Y' THEN

4627: X_MSG_DATA => x_msg_data );
4628:
4629: -- hr_utility.trace('==Leaving Calculate==================:'||x_return_status);
4630:
4631: IF P_PA_DEBUG_MODE = 'Y' THEN
4632: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4633: P_CALLED_MODE => P_CALLED_MODE,
4634: P_MSG => 'After calling PA_FP_CALC_PLAN_PKG.calculate: '||
4635: x_return_status,

Line 4642: IF p_pa_debug_mode = 'Y' THEN

4638: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4639: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4640: END IF;
4641:
4642: IF p_pa_debug_mode = 'Y' THEN
4643: PA_DEBUG.Reset_Curr_Function;
4644: END IF;
4645: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4646: EXCEPTION

Line 4643: PA_DEBUG.Reset_Curr_Function;

4639: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4640: END IF;
4641:
4642: IF p_pa_debug_mode = 'Y' THEN
4643: PA_DEBUG.Reset_Curr_Function;
4644: END IF;
4645: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4646: EXCEPTION
4647: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 4666: IF P_PA_DEBUG_MODE = 'Y' THEN

4662: END IF;
4663: ROLLBACK;
4664:
4665: x_return_status := FND_API.G_RET_STS_ERROR;
4666: IF P_PA_DEBUG_MODE = 'Y' THEN
4667: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4668: P_CALLED_MODE => P_CALLED_MODE,
4669: P_MSG => 'Invalid Arguments Passed',
4670: P_MODULE_NAME => l_module_name);

Line 4671: PA_DEBUG.Reset_Curr_Function;

4667: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4668: P_CALLED_MODE => P_CALLED_MODE,
4669: P_MSG => 'Invalid Arguments Passed',
4670: P_MODULE_NAME => l_module_name);
4671: PA_DEBUG.Reset_Curr_Function;
4672: END IF;
4673: RAISE;
4674:
4675: WHEN OTHERS THEN

Line 4681: IF P_PA_DEBUG_MODE = 'Y' THEN

4677: x_msg_data := SUBSTR(SQLERRM,1,240);
4678: FND_MSG_PUB.add_exc_msg
4679: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
4680: ,p_procedure_name => 'GEN_FCST_TASK_LEVEL_AMT');
4681: IF P_PA_DEBUG_MODE = 'Y' THEN
4682: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4683: P_CALLED_MODE => P_CALLED_MODE,
4684: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
4685: P_MODULE_NAME => l_module_name);

Line 4686: PA_DEBUG.Reset_Curr_Function;

4682: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4683: P_CALLED_MODE => P_CALLED_MODE,
4684: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
4685: P_MODULE_NAME => l_module_name);
4686: PA_DEBUG.Reset_Curr_Function;
4687: END IF;
4688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4689: END GEN_FCST_TASK_LEVEL_AMT;
4690:

Line 4710: IF p_pa_debug_mode = 'Y' THEN

4706: l_count number;
4707: BEGIN
4708: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4709: X_MSG_COUNT := 0;
4710: IF p_pa_debug_mode = 'Y' THEN
4711: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',
4712: p_debug_mode => p_pa_debug_mode);
4713: END IF;
4714:

Line 4711: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',

4707: BEGIN
4708: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4709: X_MSG_COUNT := 0;
4710: IF p_pa_debug_mode = 'Y' THEN
4711: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',
4712: p_debug_mode => p_pa_debug_mode);
4713: END IF;
4714:
4715: DELETE FROM PA_FP_PLANNING_RES_TMP1;

Line 4712: p_debug_mode => p_pa_debug_mode);

4708: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4709: X_MSG_COUNT := 0;
4710: IF p_pa_debug_mode = 'Y' THEN
4711: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',
4712: p_debug_mode => p_pa_debug_mode);
4713: END IF;
4714:
4715: DELETE FROM PA_FP_PLANNING_RES_TMP1;
4716: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'L' THEN

Line 4770: IF P_PA_DEBUG_MODE = 'Y' THEN

4766: to_number(NULL) );
4767: END IF;
4768: -- select count(*) into l_count from PA_FP_PLANNING_RES_TMP1;
4769: -- hr_utility.trace('in maintain res asg plan res tmp1 count :'||l_count);
4770: IF P_PA_DEBUG_MODE = 'Y' THEN
4771: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4772: P_MSG => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',
4773: P_MODULE_NAME => l_module_name,
4774: p_log_level => 5);

Line 4784: IF P_PA_DEBUG_MODE = 'Y' THEN

4780: P_CALLING_PROCESS => 'FORECAST_GENERATION',
4781: X_RETURN_STATUS => x_return_status,
4782: X_MSG_COUNT => x_msg_count,
4783: X_MSG_DATA => x_msg_data );
4784: IF P_PA_DEBUG_MODE = 'Y' THEN
4785: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4786: P_MSG => 'After calling create_res_asg,return status is: '||x_return_status,
4787: P_MODULE_NAME => l_module_name,
4788: p_log_level => 5);

Line 4794: IF P_PA_DEBUG_MODE = 'Y' THEN

4790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4791: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4792: END IF;
4793:
4794: IF P_PA_DEBUG_MODE = 'Y' THEN
4795: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4796: P_MSG => 'Before calling pa_fp_copy_actuals_pub.update_res_asg',
4797: P_MODULE_NAME => l_module_name,
4798: p_log_level => 5);

Line 4808: IF P_PA_DEBUG_MODE = 'Y' THEN

4804: P_CALLING_PROCESS => 'FORECAST_GENERATION',
4805: X_RETURN_STATUS => x_return_status,
4806: X_MSG_COUNT => x_msg_count,
4807: X_MSG_DATA => x_msg_data );
4808: IF P_PA_DEBUG_MODE = 'Y' THEN
4809: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4810: P_MSG => 'After calling update_res_asg,return status is: '||x_return_status,
4811: P_MODULE_NAME => l_module_name,
4812: p_log_level => 5);

Line 4818: IF p_pa_debug_mode = 'Y' THEN

4814: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4815: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4816: END IF;
4817:
4818: IF p_pa_debug_mode = 'Y' THEN
4819: PA_DEBUG.Reset_Curr_Function;
4820: END IF;
4821: EXCEPTION
4822: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 4819: PA_DEBUG.Reset_Curr_Function;

4815: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4816: END IF;
4817:
4818: IF p_pa_debug_mode = 'Y' THEN
4819: PA_DEBUG.Reset_Curr_Function;
4820: END IF;
4821: EXCEPTION
4822: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4823: l_msg_count := FND_MSG_PUB.count_msg;

Line 4840: IF P_PA_DEBUG_MODE = 'Y' THEN

4836: END IF;
4837: ROLLBACK;
4838:
4839: x_return_status := FND_API.G_RET_STS_ERROR;
4840: IF P_PA_DEBUG_MODE = 'Y' THEN
4841: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4842: P_MSG => 'Invalid Arguments Passed',
4843: P_MODULE_NAME => l_module_name,
4844: p_log_level => 5);

Line 4845: PA_DEBUG.Reset_Curr_Function;

4841: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4842: P_MSG => 'Invalid Arguments Passed',
4843: P_MODULE_NAME => l_module_name,
4844: p_log_level => 5);
4845: PA_DEBUG.Reset_Curr_Function;
4846: END IF;
4847: RAISE;
4848:
4849: WHEN OTHERS THEN

Line 4855: IF P_PA_DEBUG_MODE = 'Y' THEN

4851: x_msg_data := SUBSTR(SQLERRM,1,240);
4852: FND_MSG_PUB.add_exc_msg
4853: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
4854: ,p_procedure_name => 'MAINTAIN_RES_ASG');
4855: IF P_PA_DEBUG_MODE = 'Y' THEN
4856: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4857: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
4858: P_MODULE_NAME => l_module_name,
4859: p_log_level => 5);

Line 4860: PA_DEBUG.Reset_Curr_Function;

4856: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4857: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
4858: P_MODULE_NAME => l_module_name,
4859: p_log_level => 5);
4860: PA_DEBUG.Reset_Curr_Function;
4861: END IF;
4862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4863: END MAINTAIN_RES_ASG;
4864:

Line 4906: IF p_pa_debug_mode = 'Y' THEN

4902:
4903: x_return_status := FND_API.G_RET_STS_SUCCESS;
4904: x_msg_count := 0;
4905:
4906: IF p_pa_debug_mode = 'Y' THEN
4907: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
4908: p_debug_mode => p_pa_debug_mode );
4909: END IF;
4910:

Line 4907: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,

4903: x_return_status := FND_API.G_RET_STS_SUCCESS;
4904: x_msg_count := 0;
4905:
4906: IF p_pa_debug_mode = 'Y' THEN
4907: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
4908: p_debug_mode => p_pa_debug_mode );
4909: END IF;
4910:
4911: -- Print values of Input Parameters to debug log

Line 4908: p_debug_mode => p_pa_debug_mode );

4904: x_msg_count := 0;
4905:
4906: IF p_pa_debug_mode = 'Y' THEN
4907: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
4908: p_debug_mode => p_pa_debug_mode );
4909: END IF;
4910:
4911: -- Print values of Input Parameters to debug log
4912: IF p_pa_debug_mode = 'Y' THEN

Line 4912: IF p_pa_debug_mode = 'Y' THEN

4908: p_debug_mode => p_pa_debug_mode );
4909: END IF;
4910:
4911: -- Print values of Input Parameters to debug log
4912: IF p_pa_debug_mode = 'Y' THEN
4913: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4914: ( p_msg => 'Input Parameters for '
4915: || l_module_name || '():',
4916: p_called_mode => p_called_mode,

Line 4934: END IF; -- IF p_pa_debug_mode = 'Y' THEN

4930: ( p_msg => 'P_ETC_START_DATE:['||p_etc_start_date||']',
4931: p_called_mode => p_called_mode,
4932: p_module_name => l_module_name,
4933: p_log_level => l_log_level );
4934: END IF; -- IF p_pa_debug_mode = 'Y' THEN
4935:
4936: -- Validate input parameters
4937: IF p_project_id is NULL OR
4938: p_budget_version_id is NULL OR

Line 4940: IF p_pa_debug_mode = 'Y' THEN

4936: -- Validate input parameters
4937: IF p_project_id is NULL OR
4938: p_budget_version_id is NULL OR
4939: p_etc_start_date is NULL THEN
4940: IF p_pa_debug_mode = 'Y' THEN
4941: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4942: ( p_msg => 'Input Parameter Validation FAILED',
4943: p_called_mode => p_called_mode,
4944: p_module_name => l_module_name,

Line 4946: PA_DEBUG.RESET_CURR_FUNCTION;

4942: ( p_msg => 'Input Parameter Validation FAILED',
4943: p_called_mode => p_called_mode,
4944: p_module_name => l_module_name,
4945: p_log_level => l_log_level );
4946: PA_DEBUG.RESET_CURR_FUNCTION;
4947: END IF;
4948: RETURN;
4949: END IF;
4950:

Line 4973: IF p_pa_debug_mode = 'Y' THEN

4969: AND tmp2.txn_currency_code is not null
4970: AND bl.resource_assignment_id = tmp2.target_res_asg_id
4971: AND bl.txn_currency_code = tmp2.etc_currency_code );
4972:
4973: IF p_pa_debug_mode = 'Y' THEN
4974: PA_DEBUG.RESET_CURR_FUNCTION;
4975: END IF;
4976: EXCEPTION
4977: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 4974: PA_DEBUG.RESET_CURR_FUNCTION;

4970: AND bl.resource_assignment_id = tmp2.target_res_asg_id
4971: AND bl.txn_currency_code = tmp2.etc_currency_code );
4972:
4973: IF p_pa_debug_mode = 'Y' THEN
4974: PA_DEBUG.RESET_CURR_FUNCTION;
4975: END IF;
4976: EXCEPTION
4977: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4978: l_msg_count := FND_MSG_PUB.count_msg;

Line 4996: IF p_pa_debug_mode = 'Y' THEN

4992:
4993: ROLLBACK;
4994: x_return_status := FND_API.G_RET_STS_ERROR;
4995:
4996: IF p_pa_debug_mode = 'Y' THEN
4997: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4998: (p_msg => 'Invalid Arguments Passed',
4999: p_module_name => l_module_name,
5000: p_log_level => 5);

Line 5001: PA_DEBUG.RESET_CURR_FUNCTION;

4997: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4998: (p_msg => 'Invalid Arguments Passed',
4999: p_module_name => l_module_name,
5000: p_log_level => 5);
5001: PA_DEBUG.RESET_CURR_FUNCTION;
5002: END IF;
5003: RAISE;
5004: WHEN OTHERS THEN
5005: ROLLBACK;

Line 5014: IF p_pa_debug_mode = 'Y' THEN

5010: ( p_pkg_name => l_package_name,
5011: p_procedure_name => l_procedure_name,
5012: p_error_text => substr(sqlerrm,1,240));
5013:
5014: IF p_pa_debug_mode = 'Y' THEN
5015: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5016: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5017: p_module_name => l_module_name,
5018: p_log_level => 5);

Line 5019: PA_DEBUG.RESET_CURR_FUNCTION;

5015: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5016: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5017: p_module_name => l_module_name,
5018: p_log_level => 5);
5019: PA_DEBUG.RESET_CURR_FUNCTION;
5020: END IF;
5021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5022:
5023: END UPD_REV_CALCULATION_ERR;