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.25.12020000.3 2013/06/07 10:43:38 bpottipa 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 115: IF p_pa_debug_mode = 'Y' THEN

111: END IF;
112: X_MSG_COUNT := 0;
113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
114:
115: IF p_pa_debug_mode = 'Y' THEN
116: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',
117: p_debug_mode => p_pa_debug_mode);
118: END IF;
119:

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

112: X_MSG_COUNT := 0;
113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
114:
115: IF p_pa_debug_mode = 'Y' THEN
116: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',
117: p_debug_mode => p_pa_debug_mode);
118: END IF;
119:
120: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 117: p_debug_mode => p_pa_debug_mode);

113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
114:
115: IF p_pa_debug_mode = 'Y' THEN
116: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',
117: p_debug_mode => p_pa_debug_mode);
118: END IF;
119:
120: IF P_PA_DEBUG_MODE = 'Y' THEN
121: pa_fp_gen_amount_utils.fp_debug

Line 120: IF P_PA_DEBUG_MODE = 'Y' THEN

116: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',
117: p_debug_mode => p_pa_debug_mode);
118: END IF;
119:
120: IF P_PA_DEBUG_MODE = 'Y' THEN
121: pa_fp_gen_amount_utils.fp_debug
122: (p_called_mode => P_CALLED_MODE,
123: p_msg =>
124: 'Before calling PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_BV_FOR_GEN_DATE',

Line 134: IF P_PA_DEBUG_MODE = 'Y' THEN

130: P_ETC_START_DATE => P_ACTUALS_THRU_DATE + 1,
131: X_RETURN_STATUS => X_RETURN_STATUS,
132: X_MSG_COUNT => X_MSG_COUNT,
133: X_MSG_DATA => X_MSG_DATA);
134: IF P_PA_DEBUG_MODE = 'Y' THEN
135: pa_fp_gen_amount_utils.fp_debug
136: (p_called_mode => P_CALLED_MODE,
137: p_msg => 'After calling PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_BV_FOR_GEN_DATE,
138: ret status: '||x_return_status,

Line 145: IF p_pa_debug_mode = 'Y' THEN

141:
142: DELETE FROM PA_FP_CALC_AMT_TMP1;
143: DELETE FROM PA_FP_CALC_AMT_TMP2;
144: IF p_fp_cols_rec.x_gen_incl_open_comm_flag = 'Y' THEN
145: IF p_pa_debug_mode = 'Y' THEN
146: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
147: P_CALLED_MODE => P_CALLED_MODE,
148: P_MSG => 'Before calling pa_fp_commitment_amounts.'||
149: 'get_commitment_amts',

Line 163: IF p_pa_debug_mode = 'Y' THEN

159: X_MSG_COUNT => X_MSG_COUNT,
160: X_MSG_DATA => X_MSG_DATA);
161: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
162: x_msg_count := 0;
163: IF p_pa_debug_mode = 'Y' THEN
164: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
165: P_CALLED_MODE => P_CALLED_MODE,
166: P_MSG => 'After calling pa_fp_commitment_amounts.'||
167: 'get_commitment_amts: '||x_return_status,

Line 201: IF p_pa_debug_mode = 'Y' THEN

197: -- and postpone calling it until after CREATE_RES_ASG and UPDATE_RES_ASG
198: -- have been called in the remaining two cases (see conditional logic below).
199: IF (P_FP_COLS_REC.X_VERSION_TYPE = 'REVENUE' AND l_rev_gen_method = 'E') OR
200: (P_FP_COLS_REC.X_GEN_ETC_SRC_CODE = 'RESOURCE_SCHEDULE') THEN
201: IF p_pa_debug_mode = 'Y' THEN
202: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
203: P_CALLED_MODE => P_CALLED_MODE,
204: P_MSG => 'Before calling pa_fp_copy_actuals_pub.copy_actuals',
205: P_MODULE_NAME => l_module_name);

Line 217: IF p_pa_debug_mode = 'Y' THEN

213: P_COMMIT_FLAG => 'N',
214: X_RETURN_STATUS => X_RETURN_STATUS,
215: X_MSG_COUNT => X_MSG_COUNT,
216: X_MSG_DATA => X_MSG_DATA);
217: IF p_pa_debug_mode = 'Y' THEN
218: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
219: P_CALLED_MODE => P_CALLED_MODE,
220: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
221: ||x_return_status,

Line 237: IF p_pa_debug_mode = 'Y' THEN

233: ELSIF P_FP_COLS_REC.X_GEN_ETC_SRC_CODE = 'RESOURCE_SCHEDULE' THEN
234: -- Bug 4222555: When the Target is a Revenue version and the accrual
235: -- method is Cost, we need to call the GEN_REV_BDGT_AMT_RES_SCH_WRP API.
236: IF p_fp_cols_rec.x_version_type = 'REVENUE' AND l_rev_gen_method = 'C' THEN
237: IF p_pa_debug_mode = 'Y' THEN
238: pa_fp_gen_amount_utils.fp_debug
239: ( p_called_mode => p_called_mode,
240: p_msg => 'Before calling
241: pa_fp_gen_budget_amt_pub.gen_rev_bdgt_amt_res_sch_wrp',

Line 271: IF p_pa_debug_mode = 'Y' THEN

267: X_MSG_DATA => X_MSG_DATA );
268: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
269: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
270: END IF;
271: IF p_pa_debug_mode = 'Y' THEN
272: pa_fp_gen_amount_utils.fp_debug
273: ( p_called_mode => p_called_mode,
274: p_msg => 'Status after calling pa_fp_gen_budget_amt_pub.'||
275: 'gen_rev_bdgt_amt_res_sch_wrp:'||x_return_status,

Line 280: IF p_pa_debug_mode = 'Y' THEN

276: p_module_name => l_module_name,
277: p_log_level => 5 );
278: END IF;
279: ELSE
280: IF p_pa_debug_mode = 'Y' THEN
281: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
282: P_CALLED_MODE => P_CALLED_MODE,
283: P_MSG => 'Before calling pa_fp_gen_budget_amt_pub.'||
284: 'generate_budget_amt_res_sch',

Line 309: IF p_pa_debug_mode = 'Y' THEN

305: P_INIT_MSG_FLAG => 'N',
306: X_RETURN_STATUS => X_RETURN_STATUS,
307: X_MSG_COUNT => X_MSG_COUNT,
308: X_MSG_DATA => X_MSG_DATA);
309: IF p_pa_debug_mode = 'Y' THEN
310: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
311: P_CALLED_MODE => P_CALLED_MODE,
312: P_MSG => 'After calling pa_fp_gen_budget_amt_pub.'||
313: 'generate_budget_amt_res_sch: '||x_return_status,

Line 331: IF p_pa_debug_mode = 'Y' THEN

327:
328: /* For revenue fcst generation, source can only be cost and all.
329: From revenue version is provented from UI.
330: Revenue fcst generation should follow the budget generation logic.*/
331: IF p_pa_debug_mode = 'Y' THEN
332: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
333: P_CALLED_MODE => P_CALLED_MODE,
334: P_MSG =>
335: 'Before calling PA_FP_WP_GEN_BUDGET_AMT_PUB.'||

Line 364: IF p_pa_debug_mode = 'Y' THEN

360: PX_GEN_RES_ASG_ID_TAB => lx_gen_res_asg_id_tab,
361: X_RETURN_STATUS => X_RETURN_STATUS,
362: X_MSG_COUNT => X_MSG_COUNT,
363: X_MSG_DATA => X_MSG_DATA );
364: IF p_pa_debug_mode = 'Y' THEN
365: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
366: P_CALLED_MODE => P_CALLED_MODE,
367: P_MSG =>
368: 'After calling PA_FP_WP_GEN_BUDGET_AMT_PUB.'||

Line 376: IF p_pa_debug_mode = 'Y' THEN

372: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
373: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
374: END IF;
375: ELSE
376: IF p_pa_debug_mode = 'Y' THEN
377: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
378: P_CALLED_MODE => P_CALLED_MODE,
379: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
380: 'gen_fcst_task_level_amt',

Line 398: IF p_pa_debug_mode = 'Y' THEN

394: X_RETURN_STATUS => X_RETURN_STATUS,
395: X_MSG_COUNT => X_MSG_COUNT,
396: X_MSG_DATA => X_MSG_DATA);
397:
398: IF p_pa_debug_mode = 'Y' THEN
399: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
400: P_CALLED_MODE => P_CALLED_MODE,
401: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
402: 'gen_fcst_task_level_amt: '||x_return_status,

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

407: END IF;
408: END IF;
409:
410: --hr_utility.trace('p_fp_cols_rec.x_gen_incl_open_comm_flag:'||p_fp_cols_rec.x_gen_incl_open_comm_flag);
411: /* IF p_pa_debug_mode = 'Y' THEN
412: pa_fp_gen_amount_utils.fp_debug
413: (p_msg => 'Value of gen_incl_open_comm_flag: '||p_fp_cols_rec.x_gen_incl_open_comm_flag,
414: p_module_name => l_module_name,
415: p_log_level => 5);

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

414: p_module_name => l_module_name,
415: p_log_level => 5);
416: END IF;*/
417:
418: /*IF p_pa_debug_mode = 'Y' THEN
419: pa_fp_gen_amount_utils.fp_debug
420: (p_msg => 'Value of gen_incl_change_doc_flag: '||p_fp_cols_rec.x_gen_incl_change_doc_flag,
421: p_module_name => l_module_name,
422: p_log_level => 5);

Line 426: IF p_pa_debug_mode = 'Y' THEN

422: p_log_level => 5);
423: END IF;*/
424:
425: IF p_fp_cols_rec.x_gen_incl_open_comm_flag = 'Y' THEN
426: IF p_pa_debug_mode = 'Y' THEN
427: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
428: P_CALLED_MODE => P_CALLED_MODE,
429: P_MSG => 'Before calling PA_FP_GEN_COMMITMENT_AMOUNTS.'||
430: 'GEN_COMMITMENT_AMOUNTS',

Line 442: IF p_pa_debug_mode = 'Y' THEN

438: PX_DELETED_RES_ASG_ID_TAB => l_deleted_res_asg_id_tab,
439: X_RETURN_STATUS => X_RETURN_STATUS,
440: X_MSG_COUNT => X_MSG_COUNT,
441: X_MSG_DATA => X_MSG_DATA);
442: IF p_pa_debug_mode = 'Y' THEN
443: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
444: P_CALLED_MODE => P_CALLED_MODE,
445: P_MSG => 'After calling PA_FP_GEN_COMMITMENT_AMOUNTS.'||
446: 'GEN_COMMITMENT_AMOUNTS: '||x_return_status,

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

452: END IF;--p_fp_cols_rec.x_gen_incl_open_comm_flag = 'Y'
453:
454: --dbms_output.put_line('++Before reven++');
455: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
456: /* IF p_pa_debug_mode = 'Y' THEN
457: pa_fp_gen_amount_utils.fp_debug
458: (p_msg => 'Value of version_type: '||p_fp_cols_rec.x_version_type,
459: p_module_name => l_module_name,
460: p_log_level => 5);

Line 487: IF p_pa_debug_mode = 'Y' THEN

483: p_fp_cols_rec.x_version_type = 'REVENUE' AND
484: l_rev_gen_method = 'C' AND
485: p_fp_cols_rec.x_time_phased_code = 'N') THEN
486: --Calling the currency conversion API
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 => 'Before calling
491: pa_fp_multi_currency_pkg.convert_txn_currency',

Line 506: IF p_pa_debug_mode = 'Y' THEN

502: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
504: END IF;
505:
506: IF p_pa_debug_mode = 'Y' THEN
507: pa_fp_gen_amount_utils.fp_debug
508: (p_called_mode => p_called_mode,
509: p_msg => 'Status after calling
510: pa_fp_multi_currency_pkg.convert_txn_currency: '

Line 520: IF p_pa_debug_mode = 'Y' THEN

516:
517: /* Calling rollup budget version api
518: rollup amounts for the version level not required as the
519: amounts are derived from budget lines data
520: IF p_pa_debug_mode = 'Y' THEN
521: pa_fp_gen_amount_utils.fp_debug
522: (p_called_mode => p_called_mode,
523: p_msg => 'Before calling
524: pa_fp_rollup_pkg.rollup_budget_version',

Line 538: IF p_pa_debug_mode = 'Y' THEN

534:
535: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
536: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
537: END IF;
538: IF p_pa_debug_mode = 'Y' THEN
539: pa_fp_gen_amount_utils.fp_debug
540: (p_called_mode => p_called_mode,
541: p_msg => 'Status after calling
542: pa_fp_rollup_pkg.rollup_budget_version: '

Line 547: IF p_pa_debug_mode = 'Y' THEN

543: ||x_return_status,
544: p_module_name => l_module_name,
545: p_log_level => 5);
546: END IF;
547: IF p_pa_debug_mode = 'Y' THEN
548: pa_fp_gen_amount_utils.fp_debug
549: (p_msg => 'Value of project_value: '||p_fp_cols_rec.x_project_value,
550: p_module_name => l_module_name,
551: p_log_level => 5);

Line 561: IF p_pa_debug_mode = 'Y' THEN

557: END IF;
558: the error for project value null chk is handled in
559: gen cost based revenue gen API */
560: --Calling gen cost based revenue api
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 => 'Before calling
565: pa_fp_rev_gen_pub.gen_cost_based_revenue',

Line 580: IF p_pa_debug_mode = 'Y' THEN

576: X_MSG_DATA => X_MSG_DATA);
577: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
578: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
579: END IF;
580: IF p_pa_debug_mode = 'Y' THEN
581: pa_fp_gen_amount_utils.fp_debug
582: (p_called_mode => p_called_mode,
583: p_msg => 'Status after calling
584: pa_fp_rev_gen_pub.gen_cost_based_revenue'

Line 602: IF p_pa_debug_mode = 'Y' THEN

598: OR p_fp_cols_rec.x_version_type = 'REVENUE')
599: AND (l_rev_gen_method = 'E'
600: OR p_fp_cols_rec.x_gen_incl_bill_event_flag = 'Y') THEN
601: --Calling Billing Events API
602: IF p_pa_debug_mode = 'Y' THEN
603: pa_fp_gen_amount_utils.fp_debug
604: (p_called_mode => p_called_mode,
605: p_msg => 'Before calling
606: pa_fp_gen_billing_amounts.gen_billing_amounts',

Line 624: IF p_pa_debug_mode = 'Y' THEN

620:
621: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
622: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
623: END IF;
624: IF p_pa_debug_mode = 'Y' THEN
625: pa_fp_gen_amount_utils.fp_debug
626: (p_called_mode => p_called_mode,
627: p_msg => 'Status after calling
628: pa_fp_gen_billing_amounts.gen_billing_amounts: '

Line 636: IF p_pa_debug_mode = 'Y' THEN

632: END IF;
633: END IF;
634:
635: IF p_fp_cols_rec.x_version_type = 'REVENUE' THEN
636: IF p_pa_debug_mode = 'Y' THEN
637: pa_fp_gen_amount_utils.fp_debug
638: (p_called_mode => p_called_mode,
639: p_msg => 'Before calling
640: pa_fp_gen_budget_amt_pub.reset_cost_amounts',

Line 653: IF p_pa_debug_mode = 'Y' THEN

649: X_MSG_DATA => X_MSG_DATA);
650: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
652: END IF;
653: IF p_pa_debug_mode = 'Y' THEN
654: pa_fp_gen_amount_utils.fp_debug
655: (p_called_mode => p_called_mode,
656: p_msg => 'Status after calling
657: pa_fp_gen_budget_amt_pub.reset_cost_amounts: '

Line 674: IF p_pa_debug_mode = 'Y' THEN

670: -- the system is not regenrating the change order changes and hence it
671: -- not visible for next include nor its amounts are seen budget.
672: IF P_fp_cols_rec.x_gen_ret_manual_line_flag <> 'Y' THEN
673:
674: IF p_pa_debug_mode = 'Y' THEN
675: pa_fp_gen_amount_utils.fp_debug
676: (p_msg => 'Before calling
677: pa_fp_ci_merge.implement_change_document',
678: p_module_name => l_module_name,

Line 731: IF p_pa_debug_mode = 'Y' THEN

727: x_msg_data =>
728: x_msg_data);
729:
730:
731: IF p_pa_debug_mode = 'Y' THEN
732: pa_fp_gen_amount_utils.fp_debug
733: (p_msg => 'Status after calling pa_fp_ci_merge.implement_change_document'
734: ||x_return_status,
735: p_module_name => l_module_name,

Line 760: IF p_pa_debug_mode = 'Y' THEN

756: AND gen_etc_source_code = 'FINANCIAL_PLAN'
757: AND gen_etc_source_code IS NOT NULL;
758:
759: IF l_task_count > 0 THEN
760: IF p_pa_debug_mode = 'Y' THEN
761: pa_fp_gen_amount_utils.fp_debug
762: (p_called_mode => p_called_mode,
763: p_msg => 'Before calling
764: pa_fp_ci_merge.copy_merged_ctrl_items',

Line 779: IF p_pa_debug_mode = 'Y' THEN

775: ,x_msg_data => x_msg_data);
776: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
777: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
778: END IF;
779: IF p_pa_debug_mode = 'Y' THEN
780: pa_fp_gen_amount_utils.fp_debug
781: (p_called_mode => p_called_mode,
782: p_msg => 'Status after calling
783: pa_fp_ci_merge.copy_merged_ctrl_items: '

Line 790: IF p_pa_debug_mode = 'Y' THEN

786: p_log_level => 5);
787: END IF;
788: END IF;
789: END IF;
790: IF p_pa_debug_mode = 'Y' THEN
791: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
792: P_CALLED_MODE => P_CALLED_MODE,
793: P_MSG => 'Before calling pa_fp_gen_pub.'||
794: 'include_change_document_wrp',

Line 807: IF p_pa_debug_mode = 'Y' THEN

803: --dbms_output.put_line('++After chg doc is: '||x_return_status);
804: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
805: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
806: END IF;
807: IF p_pa_debug_mode = 'Y' THEN
808: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
809: P_CALLED_MODE => P_CALLED_MODE,
810: P_MSG => 'After calling pa_fp_gen_pub.'||
811: 'include_change_document_wrp:'||x_return_status,

Line 838: IF p_pa_debug_mode = 'Y' THEN

834:
835: /* Begin Comment for Bug 4292083 ************************************************
836:
837: IF p_fp_cols_rec.x_time_phased_code = 'N' THEN
838: IF p_pa_debug_mode = 'Y' THEN
839: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
840: P_CALLED_MODE => P_CALLED_MODE,
841: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
842: 'update_total_plan_amts',

Line 852: IF p_pa_debug_mode = 'Y' THEN

848: X_MSG_COUNT => X_MSG_COUNT,
849: X_MSG_DATA => X_MSG_DATA);
850: --dbms_output.put_line('Status of update total plan amts api: '||X_RETURN_STATUS);
851: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
852: IF p_pa_debug_mode = 'Y' THEN
853: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
854: P_CALLED_MODE => P_CALLED_MODE,
855: P_MSG => 'AFTER CALLING PA_FP_GEN_FCST_AMT_PUB.'||
856: 'UPDATE_TOTAL_PLAN_AMTS:'||x_return_status,

Line 869: IF p_pa_debug_mode = 'Y' THEN

865:
866: -- Call API to update pa_budget_lines.other_rejection_code
867: -- with any ETC revenue amount calculation errors.
868: -- See bug 5203622 for more details.
869: IF p_pa_debug_mode = 'Y' THEN
870: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
871: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.' ||
872: 'UPD_REV_CALCULATION_ERR',
873: P_CALLED_MODE => p_called_mode,

Line 885: IF p_pa_debug_mode = 'Y' THEN

881: P_CALLED_MODE => p_called_mode,
882: X_RETURN_STATUS => X_RETURN_STATUS,
883: X_MSG_COUNT => X_MSG_COUNT,
884: X_MSG_DATA => X_MSG_DATA);
885: IF p_pa_debug_mode = 'Y' THEN
886: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
887: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.' ||
888: 'UPD_REV_CALCULATION_ERR: '||x_return_status,
889: P_CALLED_MODE => p_called_mode,

Line 903: IF p_pa_debug_mode = 'Y' THEN

899: ,x_return_status => x_return_status
900: ,x_msg_count => x_msg_count
901: ,x_msg_data => x_msg_data);
902:
903: IF p_pa_debug_mode = 'Y' THEN
904: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
905: P_CALLED_MODE => P_CALLED_MODE,
906: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
907: 'call_clnt_extn_and_update_bl '||x_return_status,

Line 919: IF p_pa_debug_mode = 'Y' THEN

915:
916: --End Bug 5726785
917:
918:
919: IF p_pa_debug_mode = 'Y' THEN
920: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
921: P_CALLED_MODE => P_CALLED_MODE,
922: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
923: 'MAINTAIN_BUDGET_VERSION',

Line 937: IF p_pa_debug_mode = 'Y' THEN

933: X_MSG_COUNT => x_msg_count,
934: X_MSG_DATA => x_msg_data );
935: --dbms_output.put_line('++AFter pub1.maintain_bv++:'||x_return_status);
936: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
937: IF p_pa_debug_mode = 'Y' THEN
938: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
939: P_CALLED_MODE => P_CALLED_MODE,
940: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
941: 'MAINTAIN_BUDGET_VERSION: '||x_return_status,

Line 955: IF P_PA_DEBUG_MODE = 'Y' THEN

951: OPEN res_asgn_csr;
952: FETCH res_asgn_csr BULK COLLECT INTO l_res_asgn_id_tab, l_txn_curr_code_tab;
953: CLOSE res_asgn_csr;
954:
955: IF P_PA_DEBUG_MODE = 'Y' THEN
956: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
957: P_CALLED_MODE => P_CALLED_MODE,
958: P_MSG => 'Calling PA_FP_CALC_PLAN_PKG.calculate l_res_asgn_id_tab.count '|| l_res_asgn_id_tab.count,
959: P_MODULE_NAME => l_module_name);

Line 973: IF P_PA_DEBUG_MODE = 'Y' THEN

969: x_return_status => x_return_status,
970: x_msg_count => x_msg_count,
971: x_msg_data => x_msg_data);
972:
973: IF P_PA_DEBUG_MODE = 'Y' THEN
974: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
975: P_CALLED_MODE => P_CALLED_MODE,
976: P_MSG => 'After calling PA_FP_CALC_PLAN_PKG.calculate: '|| x_return_status,
977: P_MODULE_NAME => l_module_name);

Line 989: IF p_pa_debug_mode = 'Y' THEN

985:
986: IF P_COMMIT_FLAG = 'Y' THEN
987: COMMIT;
988: END IF;
989: IF p_pa_debug_mode = 'Y' THEN
990: PA_DEBUG.Reset_Curr_Function;
991: END IF;
992: --dbms_output.put_line('??END: x_msg_count:'||x_msg_count);
993: /*temp */

Line 990: PA_DEBUG.Reset_Curr_Function;

986: IF P_COMMIT_FLAG = 'Y' THEN
987: COMMIT;
988: END IF;
989: IF p_pa_debug_mode = 'Y' THEN
990: PA_DEBUG.Reset_Curr_Function;
991: END IF;
992: --dbms_output.put_line('??END: x_msg_count:'||x_msg_count);
993: /*temp */
994: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1016: IF P_PA_DEBUG_MODE = 'Y' THEN

1012: END IF;
1013: ROLLBACK;
1014:
1015: x_return_status := FND_API.G_RET_STS_ERROR;
1016: IF P_PA_DEBUG_MODE = 'Y' THEN
1017: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1018: P_CALLED_MODE => P_CALLED_MODE,
1019: P_MSG => 'Invalid Arguments Passed',
1020: P_MODULE_NAME => l_module_name);

Line 1021: PA_DEBUG.Reset_Curr_Function;

1017: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1018: P_CALLED_MODE => P_CALLED_MODE,
1019: P_MSG => 'Invalid Arguments Passed',
1020: P_MODULE_NAME => l_module_name);
1021: PA_DEBUG.Reset_Curr_Function;
1022: END IF;
1023: RAISE;
1024:
1025: WHEN OTHERS THEN

Line 1031: IF P_PA_DEBUG_MODE = 'Y' THEN

1027: x_msg_data := SUBSTR(SQLERRM,1,240);
1028: FND_MSG_PUB.add_exc_msg
1029: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
1030: ,p_procedure_name => 'GENERATE_FCST_AMT_WRP');
1031: IF P_PA_DEBUG_MODE = 'Y' THEN
1032: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1033: P_CALLED_MODE => P_CALLED_MODE,
1034: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1035: P_MODULE_NAME => l_module_name);

Line 1036: PA_DEBUG.Reset_Curr_Function;

1032: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1033: P_CALLED_MODE => P_CALLED_MODE,
1034: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1035: P_MODULE_NAME => l_module_name);
1036: PA_DEBUG.Reset_Curr_Function;
1037: END IF;
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039:
1040: END GENERATE_FCST_AMT_WRP;

Line 1764: IF p_pa_debug_mode = 'Y' THEN

1760:
1761: BEGIN
1762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1763: X_MSG_COUNT := 0;
1764: IF p_pa_debug_mode = 'Y' THEN
1765: pa_debug.set_curr_function( p_function => 'GEN_FCST_TASK_LEVEL_AMT',
1766: p_debug_mode => p_pa_debug_mode);
1767: END IF;
1768: l_latest_published_fwbs_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(P_PROJECT_ID);

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

1761: BEGIN
1762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1763: X_MSG_COUNT := 0;
1764: IF p_pa_debug_mode = 'Y' THEN
1765: pa_debug.set_curr_function( p_function => 'GEN_FCST_TASK_LEVEL_AMT',
1766: p_debug_mode => p_pa_debug_mode);
1767: END IF;
1768: l_latest_published_fwbs_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(P_PROJECT_ID);
1769: l_proj_struc_sharing_code := NVL(PA_PROJECT_STRUCTURE_UTILS.

Line 1766: p_debug_mode => p_pa_debug_mode);

1762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1763: X_MSG_COUNT := 0;
1764: IF p_pa_debug_mode = 'Y' THEN
1765: pa_debug.set_curr_function( p_function => 'GEN_FCST_TASK_LEVEL_AMT',
1766: p_debug_mode => p_pa_debug_mode);
1767: END IF;
1768: l_latest_published_fwbs_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(P_PROJECT_ID);
1769: l_proj_struc_sharing_code := NVL(PA_PROJECT_STRUCTURE_UTILS.
1770: get_Structure_sharing_code(P_PROJECT_ID),'SHARE_FULL');

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

1767: END IF;
1768: l_latest_published_fwbs_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(P_PROJECT_ID);
1769: l_proj_struc_sharing_code := NVL(PA_PROJECT_STRUCTURE_UTILS.
1770: get_Structure_sharing_code(P_PROJECT_ID),'SHARE_FULL');
1771: /*IF p_pa_debug_mode = 'Y' THEN
1772: pa_fp_gen_amount_utils.fp_debug
1773: (p_msg => 'Value of l_latest_published_fwbs_id: '||l_latest_published_fwbs_id,
1774: p_module_name => l_module_name,
1775: p_log_level => 5);

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

1773: (p_msg => 'Value of l_latest_published_fwbs_id: '||l_latest_published_fwbs_id,
1774: p_module_name => l_module_name,
1775: p_log_level => 5);
1776: END IF;*/
1777: /*IF p_pa_debug_mode = 'Y' THEN
1778: pa_fp_gen_amount_utils.fp_debug
1779: (p_msg => 'Value of l_proj_struc_sharing_code: '||l_proj_struc_sharing_code,
1780: p_module_name => l_module_name,
1781: p_log_level => 5);

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

1779: (p_msg => 'Value of l_proj_struc_sharing_code: '||l_proj_struc_sharing_code,
1780: p_module_name => l_module_name,
1781: p_log_level => 5);
1782: END IF;*/
1783: /*IF p_pa_debug_mode = 'Y' THEN
1784: pa_fp_gen_amount_utils.fp_debug
1785: (p_msg => 'Value of p_wp_structure_version_id: '||p_wp_structure_version_id,
1786: p_module_name => l_module_name,
1787: p_log_level => 5);

Line 1797: IF p_pa_debug_mode = 'Y' THEN

1793:
1794: IF p_fp_cols_rec.x_version_type = 'REVENUE' AND
1795: l_fcst_gen_src_code IN ('NONE','AVERAGE_ACTUALS') THEN
1796:
1797: IF p_pa_debug_mode = 'Y' THEN
1798: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1799: P_CALLED_MODE => P_CALLED_MODE,
1800: P_MSG => 'Before calling pa_fp_copy_actuals_pub.copy_actuals',
1801: P_MODULE_NAME => l_module_name);

Line 1813: IF p_pa_debug_mode = 'Y' THEN

1809: P_COMMIT_FLAG => 'N',
1810: X_RETURN_STATUS => X_RETURN_STATUS,
1811: X_MSG_COUNT => X_MSG_COUNT,
1812: X_MSG_DATA => X_MSG_DATA);
1813: IF p_pa_debug_mode = 'Y' THEN
1814: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1815: P_CALLED_MODE => P_CALLED_MODE,
1816: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
1817: ||x_return_status,

Line 1825: IF p_pa_debug_mode = 'Y' THEN

1821: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1822: END IF;
1823:
1824: IF l_fcst_gen_src_code = 'NONE' THEN
1825: IF p_pa_debug_mode = 'Y' THEN
1826: PA_DEBUG.Reset_Curr_Function;
1827: END IF;
1828: RETURN;
1829: END IF;

Line 1826: PA_DEBUG.Reset_Curr_Function;

1822: END IF;
1823:
1824: IF l_fcst_gen_src_code = 'NONE' THEN
1825: IF p_pa_debug_mode = 'Y' THEN
1826: PA_DEBUG.Reset_Curr_Function;
1827: END IF;
1828: RETURN;
1829: END IF;
1830:

Line 1832: IF p_pa_debug_mode = 'Y' THEN

1828: RETURN;
1829: END IF;
1830:
1831: IF l_fcst_gen_src_code = 'AVERAGE_ACTUALS' THEN
1832: IF p_pa_debug_mode = 'Y' THEN
1833: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1834: P_CALLED_MODE => P_CALLED_MODE,
1835: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.'||
1836: 'GEN_AVERAGE_OF_ACTUALS_WRP for Revenue only version',

Line 1867: IF p_pa_debug_mode = 'Y' THEN

1863: X_MSG_COUNT => X_MSG_COUNT,
1864: X_MSG_DATA => X_MSG_DATA );
1865: -- hr_utility.trace('Return status after calling GEN_AVERAGE_OF_ACTUALS_WRP: '
1866: -- ||x_return_status);
1867: IF p_pa_debug_mode = 'Y' THEN
1868: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1869: P_CALLED_MODE => P_CALLED_MODE,
1870: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
1871: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,

Line 1876: IF p_pa_debug_mode = 'Y' THEN

1872: P_MODULE_NAME => l_module_name);
1873: END IF;
1874:
1875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1876: IF p_pa_debug_mode = 'Y' THEN
1877: PA_DEBUG.Reset_Curr_Function;
1878: END IF;
1879: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1880: END IF;

Line 1877: PA_DEBUG.Reset_Curr_Function;

1873: END IF;
1874:
1875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1876: IF p_pa_debug_mode = 'Y' THEN
1877: PA_DEBUG.Reset_Curr_Function;
1878: END IF;
1879: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1880: END IF;
1881:

Line 1882: IF p_pa_debug_mode = 'Y' THEN

1878: END IF;
1879: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1880: END IF;
1881:
1882: IF p_pa_debug_mode = 'Y' THEN
1883: PA_DEBUG.Reset_Curr_Function;
1884: END IF;
1885:
1886: RETURN;

Line 1883: PA_DEBUG.Reset_Curr_Function;

1879: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1880: END IF;
1881:
1882: IF p_pa_debug_mode = 'Y' THEN
1883: PA_DEBUG.Reset_Curr_Function;
1884: END IF;
1885:
1886: RETURN;
1887: END IF; -- for average actual check

Line 1900: IF P_PA_DEBUG_MODE = 'Y' THEN

1896: ( p_project_id => P_PROJECT_ID,
1897: p_plan_type_id => -1,
1898: p_proj_str_ver_id => P_WP_STRUCTURE_VERSION_ID );
1899:
1900: IF P_PA_DEBUG_MODE = 'Y' THEN
1901: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1902: P_CALLED_MODE => P_CALLED_MODE,
1903: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1904: 'GET_PLAN_VERSION_DTL',

Line 1914: IF P_PA_DEBUG_MODE = 'Y' THEN

1910: X_FP_COLS_REC => l_fp_cols_rec_wp,
1911: X_RETURN_STATUS => x_return_status,
1912: X_MSG_COUNT => x_msg_count,
1913: X_MSG_DATA => x_msg_data);
1914: IF P_PA_DEBUG_MODE = 'Y' THEN
1915: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1916: P_CALLED_MODE => P_CALLED_MODE,
1917: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1918: 'GET_PLAN_VERSION_DTL:'||x_return_status,

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

1922: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1923: END IF;
1924: END IF;
1925:
1926: /*IF p_pa_debug_mode = 'Y' THEN
1927: pa_fp_gen_amount_utils.fp_debug
1928: (p_msg => 'Value of p_etc_fp_plan_version_id: '||p_etc_fp_plan_version_id,
1929: p_module_name => l_module_name,
1930: p_log_level => 5);

Line 1934: IF P_PA_DEBUG_MODE = 'Y' THEN

1930: p_log_level => 5);
1931: END IF;*/
1932:
1933: IF P_ETC_FP_PLAN_VERSION_ID IS NOT NULL THEN
1934: IF P_PA_DEBUG_MODE = 'Y' THEN
1935: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1936: P_CALLED_MODE => P_CALLED_MODE,
1937: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1938: 'GET_PLAN_VERSION_DTLS',

Line 1948: IF P_PA_DEBUG_MODE = 'Y' THEN

1944: X_FP_COLS_REC => l_fp_cols_rec_fp,
1945: X_RETURN_STATUS => x_return_status,
1946: X_MSG_COUNT => x_msg_count,
1947: X_MSG_DATA => x_msg_data);
1948: IF P_PA_DEBUG_MODE = 'Y' THEN
1949: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1950: P_CALLED_MODE => P_CALLED_MODE,
1951: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1952: 'GET_PLAN_VERSION_DTLS: '||x_return_status,

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

1979: IF P_WP_STRUCTURE_VERSION_ID IS NOT NULL THEN
1980: l_resource_list_id := l_fp_cols_rec_wp.X_RESOURCE_LIST_ID;
1981: l_struct_ver_id := l_fp_cols_rec_wp.X_PROJECT_STRUCTURE_VERSION_ID;
1982:
1983: /*IF p_pa_debug_mode = 'Y' THEN
1984: pa_fp_gen_amount_utils.fp_debug
1985: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
1986: p_module_name => l_module_name,
1987: p_log_level => 5);

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

1985: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
1986: p_module_name => l_module_name,
1987: p_log_level => 5);
1988: END IF;*/
1989: /*IF p_pa_debug_mode = 'Y' THEN
1990: pa_fp_gen_amount_utils.fp_debug
1991: (p_msg => 'Value of l_struct_ver_id: '||l_struct_ver_id,
1992: p_module_name => l_module_name,
1993: p_log_level => 5);

Line 1996: IF P_PA_DEBUG_MODE = 'Y' THEN

1992: p_module_name => l_module_name,
1993: p_log_level => 5);
1994: END IF;*/
1995:
1996: IF P_PA_DEBUG_MODE = 'Y' THEN
1997: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1998: P_CALLED_MODE => P_CALLED_MODE,
1999: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
2000: 'CALL_SUMM_POP_TMPS',

Line 2022: IF P_PA_DEBUG_MODE = 'Y' THEN

2018: X_RETURN_STATUS => x_return_status,
2019: X_MSG_COUNT => x_msg_count,
2020: X_MSG_DATA => x_msg_data );
2021: -- hr_utility.trace('1.Status after calling call_summ_pop_tmps api: '||x_return_status);
2022: IF P_PA_DEBUG_MODE = 'Y' THEN
2023: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2024: P_CALLED_MODE => P_CALLED_MODE,
2025: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
2026: 'CALL_SUMM_POP_TMPS:'||x_return_status,

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

2037: IF P_ETC_FP_PLAN_VERSION_ID IS NOT NULL THEN
2038: l_resource_list_id := l_fp_cols_rec_fp.X_RESOURCE_LIST_ID;
2039: l_struct_ver_id := l_fp_cols_rec_fp.X_PROJECT_STRUCTURE_VERSION_ID;
2040:
2041: /*IF p_pa_debug_mode = 'Y' THEN
2042: pa_fp_gen_amount_utils.fp_debug
2043: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
2044: p_module_name => l_module_name,
2045: p_log_level => 5);

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

2043: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
2044: p_module_name => l_module_name,
2045: p_log_level => 5);
2046: END IF;*/
2047: /*IF p_pa_debug_mode = 'Y' THEN
2048: pa_fp_gen_amount_utils.fp_debug
2049: (p_msg => 'Value of l_struct_ver_id: '||l_struct_ver_id,
2050: p_module_name => l_module_name,
2051: p_log_level => 5);

Line 2054: IF P_PA_DEBUG_MODE = 'Y' THEN

2050: p_module_name => l_module_name,
2051: p_log_level => 5);
2052: END IF;*/
2053:
2054: IF P_PA_DEBUG_MODE = 'Y' THEN
2055: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2056: P_CALLED_MODE => P_CALLED_MODE,
2057: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
2058: 'CALL_SUMM_POP_TMPS',

Line 2080: IF P_PA_DEBUG_MODE = 'Y' THEN

2076: X_RETURN_STATUS => x_return_status,
2077: X_MSG_COUNT => x_msg_count,
2078: X_MSG_DATA => x_msg_data );
2079: -- hr_utility.trace('2.Status after calling call_summ_pop_tmps api: '||x_return_status);
2080: IF P_PA_DEBUG_MODE = 'Y' THEN
2081: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2082: P_CALLED_MODE => P_CALLED_MODE,
2083: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
2084: 'CALL_SUMM_POP_TMPS:'||x_return_status,

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

2092:
2093: --*****Populate pji tmp1,fcst tmp1 tables from target financial version******--
2094: l_resource_list_id := l_fp_cols_rec_target.X_RESOURCE_LIST_ID;
2095: l_struct_ver_id := l_fp_cols_rec_target.X_PROJECT_STRUCTURE_VERSION_ID;
2096: /*IF p_pa_debug_mode = 'Y' THEN
2097: pa_fp_gen_amount_utils.fp_debug
2098: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
2099: p_module_name => l_module_name,
2100: p_log_level => 5);

Line 2102: IF p_pa_debug_mode = 'Y' THEN

2098: (p_msg => 'Value of l_resource_list_id: '||l_resource_list_id,
2099: p_module_name => l_module_name,
2100: p_log_level => 5);
2101: END IF;
2102: IF p_pa_debug_mode = 'Y' THEN
2103: pa_fp_gen_amount_utils.fp_debug
2104: (p_msg => 'Value of l_struct_ver_id: '||l_struct_ver_id,
2105: p_module_name => l_module_name,
2106: p_log_level => 5);

Line 2108: IF P_PA_DEBUG_MODE = 'Y' THEN

2104: (p_msg => 'Value of l_struct_ver_id: '||l_struct_ver_id,
2105: p_module_name => l_module_name,
2106: p_log_level => 5);
2107: END IF;*/
2108: IF P_PA_DEBUG_MODE = 'Y' THEN
2109: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2110: P_CALLED_MODE => P_CALLED_MODE,
2111: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
2112: 'CALL_SUMM_POP_TMPS',

Line 2132: IF P_PA_DEBUG_MODE = 'Y' THEN

2128: X_RETURN_STATUS => x_return_status,
2129: X_MSG_COUNT => x_msg_count,
2130: X_MSG_DATA => x_msg_data );
2131: -- hr_utility.trace('3.Status after calling call_summ_pop_tmps api: '||x_return_status);
2132: IF P_PA_DEBUG_MODE = 'Y' THEN
2133: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2134: P_CALLED_MODE => P_CALLED_MODE,
2135: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
2136: 'CALL_SUMM_POP_TMPS:'||x_return_status,

Line 2195: IF P_PA_DEBUG_MODE = 'Y' THEN

2191: l_gen_etc_source_code_tab;
2192: CLOSE traverse_tasks_cur;
2193: END IF; -- for plan level check
2194:
2195: IF P_PA_DEBUG_MODE = 'Y' THEN
2196: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2197: P_CALLED_MODE => P_CALLED_MODE,
2198: P_MSG => 'In traverse cursor, we have how many records?'||
2199: l_task_id_tab.count,

Line 2203: IF p_pa_debug_mode = 'Y' THEN

2199: l_task_id_tab.count,
2200: P_MODULE_NAME => l_module_name);
2201: END IF;
2202: IF l_task_id_tab.count = 0 THEN
2203: IF p_pa_debug_mode = 'Y' THEN
2204: PA_DEBUG.Reset_Curr_Function;
2205: END IF;
2206: RETURN;
2207: END IF;

Line 2204: PA_DEBUG.Reset_Curr_Function;

2200: P_MODULE_NAME => l_module_name);
2201: END IF;
2202: IF l_task_id_tab.count = 0 THEN
2203: IF p_pa_debug_mode = 'Y' THEN
2204: PA_DEBUG.Reset_Curr_Function;
2205: END IF;
2206: RETURN;
2207: END IF;
2208:

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

2226: hr_utility.trace('--curr etc source is fin/wp/wkqty/avgact:'||
2227: l_gen_etc_source_code_tab(i)); */
2228: --dbms_output.put_line('--task id is:'||l_task_id_tab(i));
2229: --dbms_output.put_line('--curr etc source is fin/wp/wkqty/avgact:'||l_gen_etc_source_code_tab(i));
2230: /* IF p_pa_debug_mode = 'Y' THEN
2231: pa_fp_gen_amount_utils.fp_debug
2232: (p_msg => 'Value of l_curr_etc_source: '||l_curr_etc_source,
2233: p_module_name => l_module_name,
2234: p_log_level => 5);

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

2256: ELSIF l_curr_etc_source = 'WORKPLAN_RESOURCES' THEN
2257: l_calling_context := 'WORK_PLAN';
2258: END IF;
2259:
2260: /*IF p_pa_debug_mode = 'Y' THEN
2261: pa_fp_gen_amount_utils.fp_debug
2262: (p_msg => 'Value of l_calling_context: '||l_calling_context,
2263: p_module_name => l_module_name,
2264: p_log_level => 5);

Line 2269: IF P_PA_DEBUG_MODE = 'Y' THEN

2265: END IF;*/
2266:
2267: /**Calling the total_plan_txn_amts api to get the total
2268: *transaction amts for a given task**/
2269: IF P_PA_DEBUG_MODE = 'Y' THEN
2270: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2271: P_CALLED_MODE => P_CALLED_MODE,
2272: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
2273: 'get_total_plan_txn_amts',

Line 2308: IF p_pa_debug_mode = 'Y' THEN

2304: X_MSG_COUNT => x_msg_count,
2305: X_MSG_DATA => x_msg_data );
2306: EXCEPTION
2307: WHEN no_data_found THEN
2308: IF p_pa_debug_mode = 'Y' THEN
2309: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2310: P_CALLED_MODE => P_CALLED_MODE,
2311: P_MSG => 'PA_FP_GEN_FCST_AMT_PVT.GET_TOTAL_PLAN_TXN_AMTS '||
2312: 'throws out no_data_found exception',

Line 2316: IF p_pa_debug_mode = 'Y' THEN

2312: 'throws out no_data_found exception',
2313: P_MODULE_NAME => l_module_name);
2314: END IF;
2315: END;
2316: IF p_pa_debug_mode = 'Y' THEN
2317: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2318: P_CALLED_MODE => P_CALLED_MODE,
2319: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
2320: 'get_total_plan_txn_amts: '||x_return_status,

Line 2324: IF p_pa_debug_mode = 'Y' THEN

2320: 'get_total_plan_txn_amts: '||x_return_status,
2321: P_MODULE_NAME => l_module_name);
2322: END IF;
2323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2324: IF p_pa_debug_mode = 'Y' THEN
2325: PA_DEBUG.Reset_Curr_Function;
2326: END IF;
2327: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2328: END IF;

Line 2325: PA_DEBUG.Reset_Curr_Function;

2321: P_MODULE_NAME => l_module_name);
2322: END IF;
2323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2324: IF p_pa_debug_mode = 'Y' THEN
2325: PA_DEBUG.Reset_Curr_Function;
2326: END IF;
2327: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2328: END IF;
2329: END IF;

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

2327: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2328: END IF;
2329: END IF;
2330: ELSIF l_curr_etc_source = 'WORK_QUANTITY' THEN
2331: /*IF p_pa_debug_mode = 'Y' THEN
2332: pa_fp_gen_amount_utils.fp_debug
2333: (p_msg => 'Value of l_curr_etc_source: '||l_curr_etc_source,
2334: p_module_name => l_module_name,
2335: p_log_level => 5);

Line 2337: IF p_pa_debug_mode = 'Y' THEN

2333: (p_msg => 'Value of l_curr_etc_source: '||l_curr_etc_source,
2334: p_module_name => l_module_name,
2335: p_log_level => 5);
2336: END IF;
2337: IF p_pa_debug_mode = 'Y' THEN
2338: pa_fp_gen_amount_utils.fp_debug
2339: (p_msg => 'Value of l_work_qty_cnt: '||l_work_qty_cnt,
2340: p_module_name => l_module_name,
2341: p_log_level => 5);

Line 2343: IF p_pa_debug_mode = 'Y' THEN

2339: (p_msg => 'Value of l_work_qty_cnt: '||l_work_qty_cnt,
2340: p_module_name => l_module_name,
2341: p_log_level => 5);
2342: END IF;
2343: IF p_pa_debug_mode = 'Y' THEN
2344: pa_fp_gen_amount_utils.fp_debug
2345: (p_msg => 'Value of l_proj_struc_sharing_code: '||l_proj_struc_sharing_code,
2346: p_module_name => l_module_name,
2347: p_log_level => 5);

Line 2354: IF P_PA_DEBUG_MODE = 'Y' THEN

2350: IF l_proj_struc_sharing_code = 'SPLIT_NO_MAPPING' THEN
2351: l_work_qty_cnt := 1;
2352: l_curr_task_id := NULL;
2353: END IF;
2354: IF P_PA_DEBUG_MODE = 'Y' THEN
2355: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2356: P_CALLED_MODE => P_CALLED_MODE,
2357: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.'||
2358: 'GET_ETC_WORK_QTY_AMTS',

Line 2375: IF p_pa_debug_mode = 'Y' THEN

2371: P_WP_STRUCTURE_VERSION_ID => P_WP_STRUCTURE_VERSION_ID,
2372: X_RETURN_STATUS => x_return_status,
2373: X_MSG_COUNT => x_msg_count,
2374: X_MSG_DATA => x_msg_data);
2375: IF p_pa_debug_mode = 'Y' THEN
2376: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2377: P_CALLED_MODE => P_CALLED_MODE,
2378: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub1.'||
2379: 'GET_ETC_WORK_QTY_AMTS: '||x_return_status,

Line 2387: IF P_PA_DEBUG_MODE = 'Y' THEN

2383: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2384: END IF;
2385: END IF;
2386: ELSIF l_curr_etc_source = 'NONE' THEN
2387: IF P_PA_DEBUG_MODE = 'Y' THEN
2388: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2389: P_CALLED_MODE => P_CALLED_MODE,
2390: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.none_etc_src',
2391: P_MODULE_NAME => l_module_name);

Line 2402: IF p_pa_debug_mode = 'Y' THEN

2398: X_RETURN_STATUS => x_return_status,
2399: X_MSG_COUNT => x_msg_count,
2400: X_MSG_DATA => x_msg_data );
2401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2402: IF p_pa_debug_mode = 'Y' THEN
2403: PA_DEBUG.Reset_Curr_Function;
2404: END IF;
2405: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2406: END IF;

Line 2403: PA_DEBUG.Reset_Curr_Function;

2399: X_MSG_COUNT => x_msg_count,
2400: X_MSG_DATA => x_msg_data );
2401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2402: IF p_pa_debug_mode = 'Y' THEN
2403: PA_DEBUG.Reset_Curr_Function;
2404: END IF;
2405: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2406: END IF;
2407: END IF;

Line 2448: IF p_pa_debug_mode = 'Y' THEN

2444: target forecast verion resource list before calculating the ETC numbers.
2445: The ETC calculation is based on the rate based flag of the target
2446: planning resource. */
2447:
2448: IF p_pa_debug_mode = 'Y' THEN
2449: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2450: P_CALLED_MODE => P_CALLED_MODE,
2451: P_MSG => 'Before calling pa_fp_gen_fcst_rmap_pkg.fcst_src_txns_rmap',
2452: P_MODULE_NAME => l_module_name);

Line 2463: IF p_pa_debug_mode = 'Y' THEN

2459: X_RETURN_STATUS => X_RETURN_STATUS,
2460: X_MSG_COUNT => X_MSG_COUNT,
2461: X_MSG_DATA => X_MSG_DATA);
2462: -- hr_utility.trace('after fcst src txns rmap');
2463: IF p_pa_debug_mode = 'Y' THEN
2464: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2465: P_CALLED_MODE => P_CALLED_MODE,
2466: P_MSG => 'After calling pa_fp_gen_fcst_rmap_pkg.fcst_src_txns_rmap'
2467: ||x_return_status,

Line 2479: IF p_pa_debug_mode = 'Y' THEN

2475: -- resource mapping, which also calls CREATE_RES_ASG and UPDATE_RES_ASG
2476: -- via call to MAINTAIN_RES_ASG, so that planning dates from the source
2477: -- are honored when possible, since resources created by the Copy Actuals
2478: -- API use task/project-level default dates.
2479: IF p_pa_debug_mode = 'Y' THEN
2480: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2481: P_CALLED_MODE => P_CALLED_MODE,
2482: P_MSG => 'Before calling pa_fp_copy_actuals_pub.copy_actuals',
2483: P_MODULE_NAME => l_module_name);

Line 2495: IF p_pa_debug_mode = 'Y' THEN

2491: P_COMMIT_FLAG => 'N',
2492: X_RETURN_STATUS => X_RETURN_STATUS,
2493: X_MSG_COUNT => X_MSG_COUNT,
2494: X_MSG_DATA => X_MSG_DATA);
2495: IF p_pa_debug_mode = 'Y' THEN
2496: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2497: P_CALLED_MODE => P_CALLED_MODE,
2498: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
2499: ||x_return_status,

Line 2509: IF p_pa_debug_mode = 'Y' THEN

2505:
2506: -- Now that we have copied the actuals, we do the delayed processing
2507: -- for tasks with source of Average of Actuals.
2508: FOR i IN 1..l_avg_actuals_task_id_tab.count LOOP
2509: IF p_pa_debug_mode = 'Y' THEN
2510: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2511: P_CALLED_MODE => P_CALLED_MODE,
2512: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.'||
2513: 'GEN_AVERAGE_OF_ACTUALS_WRP',

Line 2538: IF p_pa_debug_mode = 'Y' THEN

2534: X_MSG_COUNT => X_MSG_COUNT,
2535: X_MSG_DATA => X_MSG_DATA );
2536: -- hr_utility.trace('Return status after calling GEN_AVERAGE_OF_ACTUALS_WRP: '
2537: -- ||x_return_status);
2538: IF p_pa_debug_mode = 'Y' THEN
2539: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2540: P_CALLED_MODE => P_CALLED_MODE,
2541: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
2542: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,

Line 2546: IF p_pa_debug_mode = 'Y' THEN

2542: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,
2543: P_MODULE_NAME => l_module_name);
2544: END IF;
2545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2546: IF p_pa_debug_mode = 'Y' THEN
2547: PA_DEBUG.Reset_Curr_Function;
2548: END IF;
2549: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2550: END IF;

Line 2547: PA_DEBUG.Reset_Curr_Function;

2543: P_MODULE_NAME => l_module_name);
2544: END IF;
2545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2546: IF p_pa_debug_mode = 'Y' THEN
2547: PA_DEBUG.Reset_Curr_Function;
2548: END IF;
2549: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2550: END IF;
2551: END LOOP;

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

2568:
2569: DELETE FROM PA_FP_CALC_AMT_TMP3;
2570: /* the following code is commented. We are not going to use the
2571: baselined budget cost for ETC gen method Plan to Complete. */
2572: /* IF P_PA_DEBUG_MODE = 'Y' THEN
2573: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2574: P_CALLED_MODE => P_CALLED_MODE,
2575: P_MSG => 'Before calling PA_FIN_PLAN_UTILS.'||
2576: 'Get_Appr_Cost_Plan_Type_Info',

Line 2587: IF P_PA_DEBUG_MODE = 'Y' THEN

2583: x_msg_count => x_msg_count,
2584: x_msg_data => x_msg_data);
2585:
2586: --dbms_output.put_line('l_fin_plan_type_id is '||l_fin_plan_type_id);
2587: IF P_PA_DEBUG_MODE = 'Y' THEN
2588: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2589: P_CALLED_MODE => P_CALLED_MODE,
2590: P_MSG => 'After calling PA_FIN_PLAN_UTILS.'||
2591: 'Get_Appr_Cost_Plan_Type_Info: '||x_return_status,

Line 2612: IF P_PA_DEBUG_MODE = 'Y' THEN

2608: AND fin_plan_option_level_code = 'PLAN_TYPE'
2609: AND project_id = P_PROJECT_ID;
2610:
2611: --dbms_output.put_line('--l_version_type: '||l_version_type);
2612: IF P_PA_DEBUG_MODE = 'Y' THEN
2613: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2614: P_CALLED_MODE => P_CALLED_MODE,
2615: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
2616: 'Get_Curr_Original_Version_Info',

Line 2631: IF P_PA_DEBUG_MODE = 'Y' THEN

2627: x_msg_count => x_msg_count,
2628: x_msg_data => x_msg_data);
2629: --dbms_output.put_line('--!after PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info'||x_return_status);
2630: --dbms_output.put_line('--l_approved_fp_version_id is:'||l_approved_fp_version_id);
2631: IF P_PA_DEBUG_MODE = 'Y' THEN
2632: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2633: P_CALLED_MODE => P_CALLED_MODE,
2634: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
2635: 'Get_Curr_Original_Version_Info: '||x_return_status,

Line 2648: IF P_PA_DEBUG_MODE = 'Y' THEN

2644: p_msg_name => 'PA_FP_GENFCST_NO_APPR_FPVER');
2645: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2646: END IF;
2647:
2648: IF P_PA_DEBUG_MODE = 'Y' THEN
2649: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2650: P_CALLED_MODE => P_CALLED_MODE,
2651: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
2652: 'GET_PLAN_VERSION_DTLS',

Line 2664: IF P_PA_DEBUG_MODE = 'Y' THEN

2660: X_RETURN_STATUS => x_return_status,
2661: X_MSG_COUNT => x_msg_count,
2662: X_MSG_DATA => x_msg_data);
2663: --dbms_output.put_line('--after PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS :'||x_return_status);
2664: IF P_PA_DEBUG_MODE = 'Y' THEN
2665: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2666: P_CALLED_MODE => P_CALLED_MODE,
2667: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
2668: 'GET_PLAN_VERSION_DTLS: '||x_return_status,

Line 2675: IF P_PA_DEBUG_MODE = 'Y' THEN

2671: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2672: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2673: END IF;
2674:
2675: IF P_PA_DEBUG_MODE = 'Y' THEN
2676: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2677: P_CALLED_MODE => P_CALLED_MODE,
2678: P_MSG => 'Before calling PA_FP_MAP_BV_PUB.'||
2679: 'GEN_MAP_BV_TO_TARGET_RL',

Line 2694: IF P_PA_DEBUG_MODE = 'Y' THEN

2690: X_MSG_COUNT => x_msg_count,
2691: X_MSG_DATA => x_msg_data);
2692: --dbms_output.put_line('--PA_FP_MAP_BV_PUB.GEN_MAP_BV_TO_TARGET_RL:' ||x_return_status);
2693: --hr_utility.trace('aft call GEN_MAP_BV_TO_TARGET_RL api:'||x_return_status);
2694: IF P_PA_DEBUG_MODE = 'Y' THEN
2695: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2696: P_CALLED_MODE => P_CALLED_MODE,
2697: P_MSG => 'After calling PA_FP_MAP_BV_PUB.'||
2698: 'GEN_MAP_BV_TO_TARGET_RL: '||x_return_status,

Line 2705: IF P_PA_DEBUG_MODE = 'Y' THEN

2701: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2702: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2703: END IF;
2704:
2705: IF P_PA_DEBUG_MODE = 'Y' THEN
2706: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2707: P_CALLED_MODE => P_CALLED_MODE,
2708: P_MSG => 'Before calling PA_FP_MAP_BV_PUB.'||
2709: 'GEN_MAP_BV_TO_TARGET_RL(2nd time)',

Line 2721: IF P_PA_DEBUG_MODE = 'Y' THEN

2717: X_RETURN_STATUS => x_return_status,
2718: X_MSG_COUNT => x_msg_count,
2719: X_MSG_DATA => x_msg_data);
2720: --tmp3's basedline value will be used in method api
2721: IF P_PA_DEBUG_MODE = 'Y' THEN
2722: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2723: P_CALLED_MODE => P_CALLED_MODE,
2724: P_MSG => 'After calling PA_FP_MAP_BV_PUB.'||
2725: 'GEN_MAP_BV_TO_TARGET_RL:(2nd time) '||x_return_status,

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

2752: l_rlm_id_tab2,
2753: l_cbs_id_tab2, --bug#16791711
2754: l_etc_method_tab2;
2755: CLOSE traverse_tasks_rlm_cur;
2756: /*IF p_pa_debug_mode = 'Y' THEN
2757: pa_fp_gen_amount_utils.fp_debug
2758: (p_msg => 'Value of l_ra_id_tab2.count: '||l_ra_id_tab2.count,
2759: p_module_name => l_module_name,
2760: p_log_level => 5);

Line 2765: IF P_PA_DEBUG_MODE = 'Y' THEN

2761: END IF;*/
2762: --dbms_output.put_line('++l_ra_id_tab2.count:'||l_ra_id_tab2.count);
2763: --dbms_output.put_line('++l_ra_id_tab2.first:'||l_ra_id_tab2.first);
2764: --dbms_output.put_line('++l_ra_id_tab2.last:'||l_ra_id_tab2.last);
2765: IF P_PA_DEBUG_MODE = 'Y' THEN
2766: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2767: P_CALLED_MODE => P_CALLED_MODE,
2768: P_MSG => 'second traverse cursor, we have how many records?'
2769: ||l_src_ra_id_tab2.count,

Line 2786: IF P_PA_DEBUG_MODE = 'Y' THEN

2782:
2783: IF l_wp_version_id IS NOT NULL AND
2784: p_fp_cols_rec.x_gen_etc_src_code IN ('WORKPLAN_RESOURCES','TASK_LEVEL_SEL') THEN
2785:
2786: IF P_PA_DEBUG_MODE = 'Y' THEN
2787: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2788: P_CALLED_MODE => P_CALLED_MODE,
2789: P_MSG => 'Before calling PA_FP_FCST_GEN_AMT_UTILS.'||
2790: 'COMPARE_ETC_SRC_TARGET_FP_OPT',

Line 2802: IF P_PA_DEBUG_MODE = 'Y' THEN

2798: X_SAME_PLANNING_OPTION_FLAG => l_wp_planning_options_flag, /* Bug 4369741 */
2799: X_RETURN_STATUS => X_RETURN_STATUS,
2800: X_MSG_COUNT => X_MSG_COUNT,
2801: X_MSG_DATA => X_MSG_DATA);
2802: IF P_PA_DEBUG_MODE = 'Y' THEN
2803: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2804: P_CALLED_MODE => P_CALLED_MODE,
2805: P_MSG => 'After calling PA_FP_FCST_GEN_AMT_UTILS.'||
2806: 'COMPARE_ETC_SRC_TARGET_FP_OPT:'||l_wp_planning_options_flag,

Line 2817: IF P_PA_DEBUG_MODE = 'Y' THEN

2813:
2814: IF p_etc_fp_plan_version_id IS NOT NULL AND
2815: p_fp_cols_rec.x_gen_etc_src_code IN ('FINANCIAL_PLAN','TASK_LEVEL_SEL') THEN
2816:
2817: IF P_PA_DEBUG_MODE = 'Y' THEN
2818: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2819: P_CALLED_MODE => P_CALLED_MODE,
2820: P_MSG => 'Before calling PA_FP_FCST_GEN_AMT_UTILS.'||
2821: 'COMPARE_ETC_SRC_TARGET_FP_OPT',

Line 2833: IF P_PA_DEBUG_MODE = 'Y' THEN

2829: X_SAME_PLANNING_OPTION_FLAG => l_fp_planning_options_flag, /* Bug 4369741 */
2830: X_RETURN_STATUS => X_RETURN_STATUS,
2831: X_MSG_COUNT => X_MSG_COUNT,
2832: X_MSG_DATA => X_MSG_DATA);
2833: IF P_PA_DEBUG_MODE = 'Y' THEN
2834: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2835: P_CALLED_MODE => P_CALLED_MODE,
2836: P_MSG => 'After calling PA_FP_FCST_GEN_AMT_UTILS.'||
2837: 'COMPARE_ETC_SRC_TARGET_FP_OPT:'||l_fp_planning_options_flag,

Line 2849: IF P_PA_DEBUG_MODE = 'Y' THEN

2845:
2846: /* hr_utility.trace('l_src_ra_id_tab2.COUNT :'||l_src_ra_id_tab2.COUNT);
2847: hr_utility.trace('before for loop :'); */
2848:
2849: IF P_PA_DEBUG_MODE = 'Y' THEN
2850: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2851: P_CALLED_MODE => P_CALLED_MODE,
2852: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PVT.'||
2853: 'UPD_TGT_RATE_BASED_FLAG',

Line 2861: IF P_PA_DEBUG_MODE = 'Y' THEN

2857: P_FP_COLS_REC => P_FP_COLS_REC,
2858: X_RETURN_STATUS => x_return_status,
2859: X_MSG_COUNT => x_msg_count,
2860: X_MSG_DATA => x_msg_data);
2861: IF P_PA_DEBUG_MODE = 'Y' THEN
2862: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2863: P_CALLED_MODE => P_CALLED_MODE,
2864: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PVT.'||
2865: 'UPD_TGT_RATE_BASED_FLAG: '||x_return_status,

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

2888: l_curr_tgt_ra_id := l_tgt_ra_id_tab2(i);
2889: l_curr_rlm_id := l_rlm_id_tab2(i);
2890: l_curr_cbs_id := l_cbs_id_tab2(i);--bug#16791711
2891: l_curr_etc_method_code := l_etc_method_tab2(i);
2892: /*IF p_pa_debug_mode = 'Y' THEN
2893: pa_fp_gen_amount_utils.fp_debug
2894: (p_msg => 'Value of l_curr_task_id: '||l_curr_task_id,
2895: p_module_name => l_module_name,
2896: p_log_level => 5);

Line 2898: IF p_pa_debug_mode = 'Y' THEN

2894: (p_msg => 'Value of l_curr_task_id: '||l_curr_task_id,
2895: p_module_name => l_module_name,
2896: p_log_level => 5);
2897: END IF;
2898: IF p_pa_debug_mode = 'Y' THEN
2899: pa_fp_gen_amount_utils.fp_debug
2900: (p_msg => 'Value of l_curr_etc_source: '||l_curr_etc_source,
2901: p_module_name => l_module_name,
2902: p_log_level => 5);

Line 2904: IF p_pa_debug_mode = 'Y' THEN

2900: (p_msg => 'Value of l_curr_etc_source: '||l_curr_etc_source,
2901: p_module_name => l_module_name,
2902: p_log_level => 5);
2903: END IF;
2904: IF p_pa_debug_mode = 'Y' THEN
2905: pa_fp_gen_amount_utils.fp_debug
2906: (p_msg => 'Value of l_curr_ra_id: '||l_curr_ra_id,
2907: p_module_name => l_module_name,
2908: p_log_level => 5);

Line 2910: IF p_pa_debug_mode = 'Y' THEN

2906: (p_msg => 'Value of l_curr_ra_id: '||l_curr_ra_id,
2907: p_module_name => l_module_name,
2908: p_log_level => 5);
2909: END IF;
2910: IF p_pa_debug_mode = 'Y' THEN
2911: pa_fp_gen_amount_utils.fp_debug
2912: (p_msg => 'Value of l_curr_rlm_id: '||l_curr_rlm_id,
2913: p_module_name => l_module_name,
2914: p_log_level => 5);

Line 2916: IF p_pa_debug_mode = 'Y' THEN

2912: (p_msg => 'Value of l_curr_rlm_id: '||l_curr_rlm_id,
2913: p_module_name => l_module_name,
2914: p_log_level => 5);
2915: END IF;
2916: IF p_pa_debug_mode = 'Y' THEN
2917: pa_fp_gen_amount_utils.fp_debug
2918: (p_msg => 'Value of l_curr_etc_method_code: '||l_curr_etc_method_code,
2919: p_module_name => l_module_name,
2920: p_log_level => 5);

Line 2972: IF P_PA_DEBUG_MODE = 'Y' THEN

2968: /* Bug 4369741: Pass NULL for the P_PLANNING_OPTIONS_FLAG parameter
2969: * to make explicit the fact that the ETC method APIs do not make
2970: * use of the planning options flag. All of the planning options logic
2971: * is present in this API itself. */
2972: IF P_PA_DEBUG_MODE = 'Y' THEN
2973: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2974: P_CALLED_MODE => P_CALLED_MODE,
2975: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||
2976: 'GET_ETC_REMAIN_BDGT_AMTS_BLK',

Line 2995: IF p_pa_debug_mode = 'Y' THEN

2991: P_PLANNING_OPTIONS_FLAG => NULL, /* Bug 4369741 */
2992: X_RETURN_STATUS => x_return_status,
2993: X_MSG_COUNT => x_msg_count,
2994: X_MSG_DATA => x_msg_data);
2995: IF p_pa_debug_mode = 'Y' THEN
2996: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2997: P_CALLED_MODE => P_CALLED_MODE,
2998: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||
2999: 'GET_ETC_REMAIN_BDGT_AMTS_BLK: '||x_return_status,

Line 3012: IF P_PA_DEBUG_MODE = 'Y' THEN

3008: /* Bug 4369741: Pass NULL for the P_PLANNING_OPTIONS_FLAG parameter
3009: * to make explicit the fact that the ETC method APIs do not make
3010: * use of the planning options flag. All of the planning options logic
3011: * is present in this API itself. */
3012: IF P_PA_DEBUG_MODE = 'Y' THEN
3013: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3014: P_CALLED_MODE => P_CALLED_MODE,
3015: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub4.'||
3016: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK',

Line 3034: IF p_pa_debug_mode = 'Y' THEN

3030: P_PLANNING_OPTIONS_FLAG => NULL, /* Bug 4369741 */
3031: X_RETURN_STATUS => x_return_status,
3032: X_MSG_COUNT => x_msg_count,
3033: X_MSG_DATA => x_msg_data);
3034: IF p_pa_debug_mode = 'Y' THEN
3035: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3036: P_CALLED_MODE => P_CALLED_MODE,
3037: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub4.'||
3038: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK: '||x_return_status,

Line 3051: IF P_PA_DEBUG_MODE = 'Y' THEN

3047: /* Bug 4369741: Pass NULL for the P_PLANNING_OPTIONS_FLAG parameter
3048: * to make explicit the fact that the ETC method APIs do not make
3049: * use of the planning options flag. All of the planning options logic
3050: * is present in this API itself. */
3051: IF P_PA_DEBUG_MODE = 'Y' THEN
3052: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3053: P_CALLED_MODE => P_CALLED_MODE,
3054: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub5.'||
3055: 'GET_ETC_EARNED_VALUE_AMTS_BLK',

Line 3074: IF p_pa_debug_mode = 'Y' THEN

3070: P_PLANNING_OPTIONS_FLAG => NULL, /* Bug 4369741 */
3071: X_RETURN_STATUS => x_return_status,
3072: X_MSG_COUNT => x_msg_count,
3073: X_MSG_DATA => x_msg_data);
3074: IF p_pa_debug_mode = 'Y' THEN
3075: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3076: P_CALLED_MODE => P_CALLED_MODE,
3077: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub5.'||
3078: 'GET_ETC_EARNED_VALUE_AMTS_BLK: '||x_return_status,

Line 3093: IF P_PA_DEBUG_MODE = 'Y' THEN

3089: * API to reflect spec change from a single planning options
3090: * flag to 2 separate flags for Workplan and Financial Plan sources. */
3091:
3092: -- hr_utility.trace('after for loop :');
3093: IF P_PA_DEBUG_MODE = 'Y' THEN
3094: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3095: P_CALLED_MODE => P_CALLED_MODE,
3096: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB3.'||
3097: 'GET_ETC_COMMITMENT_AMTS',

Line 3111: IF p_pa_debug_mode = 'Y' THEN

3107: X_MSG_DATA => x_msg_data);
3108:
3109: -- hr_utility.trace('after pub3 cmt amts:');
3110:
3111: IF p_pa_debug_mode = 'Y' THEN
3112: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3113: P_CALLED_MODE => P_CALLED_MODE,
3114: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB3.'||
3115: 'GET_ETC_COMMITMENT_AMTS: '||x_return_status,

Line 3124: IF P_PA_DEBUG_MODE = 'Y' THEN

3120: END IF;
3121: END IF;
3122: -- gboomina Bug 8318932 for AAI Enhancement - Start
3123: ELSE
3124: IF P_PA_DEBUG_MODE = 'Y' THEN
3125: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3126: P_CALLED_MODE => P_CALLED_MODE,
3127: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||
3128: 'GET_ETC_FROM_SRC_BDGT',

Line 3139: IF p_pa_debug_mode = 'Y' THEN

3135: P_ACTUALS_THRU_DATE => P_ACTUALS_THRU_DATE,
3136: X_RETURN_STATUS => x_return_status,
3137: X_MSG_COUNT => x_msg_count,
3138: X_MSG_DATA => x_msg_data);
3139: IF p_pa_debug_mode = 'Y' THEN
3140: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3141: P_CALLED_MODE => P_CALLED_MODE,
3142: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||
3143: 'GET_ETC_FROM_SRC_BDGT: '||x_return_status,

Line 3568: IF p_pa_debug_mode = 'Y' THEN

3564: SELECT DISTINCT column_value
3565: FROM TABLE( CAST( l_ra_id_tab_table(i) AS SYSTEM.pa_num_tbl_type ));
3566:
3567: -- Call the maintenance api in COPY mode
3568: IF p_pa_debug_mode = 'Y' THEN
3569: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3570: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3571: 'MAINTAIN_DATA',
3572: P_CALLED_MODE => p_called_mode,

Line 3586: IF p_pa_debug_mode = 'Y' THEN

3582: P_CALLED_MODE => p_called_mode,
3583: X_RETURN_STATUS => x_return_status,
3584: X_MSG_COUNT => x_msg_count,
3585: X_MSG_DATA => x_msg_data );
3586: IF p_pa_debug_mode = 'Y' THEN
3587: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3588: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3589: 'MAINTAIN_DATA: '||x_return_status,
3590: P_CALLED_MODE => p_called_mode,

Line 3637: IF p_pa_debug_mode = 'Y' THEN

3633: l_count := SQL%ROWCOUNT;
3634:
3635: IF l_count > 0 THEN
3636: -- CALL the maintenance api in INSERT mode
3637: IF p_pa_debug_mode = 'Y' THEN
3638: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3639: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3640: 'MAINTAIN_DATA',
3641: P_CALLED_MODE => p_called_mode,

Line 3653: IF p_pa_debug_mode = 'Y' THEN

3649: P_CALLED_MODE => p_called_mode,
3650: X_RETURN_STATUS => x_return_status,
3651: X_MSG_COUNT => x_msg_count,
3652: X_MSG_DATA => x_msg_data );
3653: IF p_pa_debug_mode = 'Y' THEN
3654: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3655: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3656: 'MAINTAIN_DATA: '||x_return_status,
3657: P_CALLED_MODE => p_called_mode,

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

3669:
3670: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' and l_rev_gen_method = 'C' THEN
3671: l_cal_etc_revenue_tab := l_cal_etc_burdened_cost_tab;
3672: END IF;
3673: /*IF p_pa_debug_mode = 'Y' THEN
3674: pa_fp_gen_amount_utils.fp_debug
3675: (p_msg => 'Value of l_rev_gen_method: '||l_rev_gen_method,
3676: p_module_name => l_module_name,
3677: p_log_level => 5);

Line 3679: IF p_pa_debug_mode = 'Y' THEN

3675: (p_msg => 'Value of l_rev_gen_method: '||l_rev_gen_method,
3676: p_module_name => l_module_name,
3677: p_log_level => 5);
3678: END IF;
3679: IF p_pa_debug_mode = 'Y' THEN
3680: pa_fp_gen_amount_utils.fp_debug
3681: (p_msg => 'Value of l_cal_etc_revenue_tab.count: '||l_cal_etc_revenue_tab.count,
3682: p_module_name => l_module_name,
3683: p_log_level => 5);

Line 3685: IF p_pa_debug_mode = 'Y' THEN

3681: (p_msg => 'Value of l_cal_etc_revenue_tab.count: '||l_cal_etc_revenue_tab.count,
3682: p_module_name => l_module_name,
3683: p_log_level => 5);
3684: END IF;
3685: IF p_pa_debug_mode = 'Y' THEN
3686: pa_fp_gen_amount_utils.fp_debug
3687: (p_msg => 'Value of l_cal_ra_id_tab.count: '||l_cal_ra_id_tab.count,
3688: p_module_name => l_module_name,
3689: p_log_level => 5);

Line 3854: IF P_PA_DEBUG_MODE = 'Y' THEN

3850: l_target_version_type = 'REVENUE' AND
3851: l_rev_gen_method = 'E' THEN
3852: /*Revenue is only based on billing events, which is handled seperately*/
3853: l_dummy := 1;
3854: IF P_PA_DEBUG_MODE = 'Y' THEN
3855: PA_DEBUG.RESET_CURR_FUNCTION;
3856: END IF;
3857: RETURN;
3858: ELSIF l_source_version_type_tab(i) = 'ALL' AND

Line 3855: PA_DEBUG.RESET_CURR_FUNCTION;

3851: l_rev_gen_method = 'E' THEN
3852: /*Revenue is only based on billing events, which is handled seperately*/
3853: l_dummy := 1;
3854: IF P_PA_DEBUG_MODE = 'Y' THEN
3855: PA_DEBUG.RESET_CURR_FUNCTION;
3856: END IF;
3857: RETURN;
3858: ELSIF l_source_version_type_tab(i) = 'ALL' AND
3859: l_target_version_type = 'ALL' AND

Line 4030: IF P_PA_DEBUG_MODE = 'Y' THEN

4026: NOT ( p_fp_cols_rec.x_version_type = 'ALL' AND l_rev_gen_method = 'T' AND
4027: l_rev_only_src_txn_flag_tab(i) = 'Y' AND l_cal_rate_based_flag_tab(i) = 'N') THEN
4028:
4029: -- hr_utility.trace('==inside plan option same flag = Y ');
4030: IF P_PA_DEBUG_MODE = 'Y' THEN
4031: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4032: P_CALLED_MODE => P_CALLED_MODE,
4033: P_MSG =>
4034: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',

Line 4047: IF P_PA_DEBUG_MODE = 'Y' THEN

4043: X_MSG_DATA => x_msg_data);
4044: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4045: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4046: END IF;
4047: IF P_PA_DEBUG_MODE = 'Y' THEN
4048: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4049: P_CALLED_MODE => P_CALLED_MODE,
4050: P_MSG =>
4051: 'After calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE: '||x_return_status,

Line 4154: IF P_PA_DEBUG_MODE = 'Y' THEN

4150: END IF;
4151: END IF; -- ER 4376722 billability logic for ALL versions
4152:
4153:
4154: IF P_PA_DEBUG_MODE = 'Y' THEN
4155: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4156: P_CALLED_MODE => P_CALLED_MODE,
4157: P_MSG =>
4158: 'Before calling pa_fp_fcst_gen_client_ext.fcst_gen_client_extn',

Line 4210: IF P_PA_DEBUG_MODE = 'Y' THEN

4206: X_MSG_COUNT => x_msg_count);
4207:
4208: -- hr_utility.trace('==after calling client extn api ');
4209:
4210: IF P_PA_DEBUG_MODE = 'Y' THEN
4211: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4212: P_CALLED_MODE => P_CALLED_MODE,
4213: P_MSG =>
4214: 'After calling pa_fp_fcst_gen_client_ext.fcst_gen_client_extn: '

Line 4710: IF P_PA_DEBUG_MODE = 'Y' THEN

4706: -- burdened cost based on the revenue accrual method.
4707: l_amt_dtls_tbl(1).txn_revenue := l_amt_dtls_tbl(1).quantity;
4708: END IF;
4709:
4710: IF P_PA_DEBUG_MODE = 'Y' THEN
4711: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4712: P_CALLED_MODE => P_CALLED_MODE,
4713: P_MSG => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.'||
4714: 'MAINTAIN_ACTUAL_AMT_RA',

Line 4728: IF P_PA_DEBUG_MODE = 'Y' THEN

4724: P_TXN_AMT_TYPE_CODE => 'PLANNING_TXN',
4725: X_RETURN_STATUS => x_return_Status,
4726: X_MSG_COUNT => x_msg_count,
4727: X_MSG_DATA => x_msg_data );
4728: IF P_PA_DEBUG_MODE = 'Y' THEN
4729: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4730: P_CALLED_MODE => P_CALLED_MODE,
4731: P_MSG => 'After calling PA_FP_MAINTAIN_ACTUAL_PUB.'||
4732: 'MAINTAIN_ACTUAL_AMT_RA: '||x_return_status,

Line 4739: IF p_pa_debug_mode = 'Y' THEN

4735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4736: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4737: END IF;
4738: END LOOP;
4739: IF p_pa_debug_mode = 'Y' THEN
4740: PA_DEBUG.Reset_Curr_Function;
4741: END IF;
4742: -- RETURN; --bug#13330980
4743: END IF;

Line 4740: PA_DEBUG.Reset_Curr_Function;

4736: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4737: END IF;
4738: END LOOP;
4739: IF p_pa_debug_mode = 'Y' THEN
4740: PA_DEBUG.Reset_Curr_Function;
4741: END IF;
4742: -- RETURN; --bug#13330980
4743: END IF;
4744:

Line 4800: IF p_pa_debug_mode = 'Y' THEN

4796: INSERT INTO pa_res_list_map_tmp1
4797: ( txn_resource_assignment_id )
4798: VALUES ( l_cal_ra_id_tab(i) );
4799:
4800: IF p_pa_debug_mode = 'Y' THEN
4801: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4802: ( p_msg => 'Before calling PA_FP_GEN_PUB.' ||
4803: 'COPY_SRC_ATTRS_TO_TARGET_FCST',
4804: p_module_name => l_module_name,

Line 4812: IF p_pa_debug_mode = 'Y' THEN

4808: ( P_FP_COLS_REC => p_fp_cols_rec,
4809: X_RETURN_STATUS => x_return_status,
4810: X_MSG_COUNT => x_msg_count,
4811: X_MSG_DATA => x_msg_data );
4812: IF p_pa_debug_mode = 'Y' THEN
4813: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4814: ( p_msg => 'Status after calling PA_FP_GEN_PUB.' ||
4815: 'COPY_SRC_ATTRS_TO_TARGET_FCST: ' ||
4816: x_return_status,

Line 4825: IF P_PA_DEBUG_MODE = 'Y' THEN

4821: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4822: END IF;
4823: -- Bug 3991151: End changes.
4824:
4825: IF P_PA_DEBUG_MODE = 'Y' THEN
4826: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4827: P_CALLED_MODE => P_CALLED_MODE,
4828: P_MSG => 'Before calling PA_FP_CALC_PLAN_PKG.calculate',
4829: P_MODULE_NAME => l_module_name);

Line 4887: IF P_PA_DEBUG_MODE = 'Y' THEN

4883: X_MSG_DATA => x_msg_data );
4884:
4885: -- hr_utility.trace('==Leaving Calculate==================:'||x_return_status);
4886:
4887: IF P_PA_DEBUG_MODE = 'Y' THEN
4888: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4889: P_CALLED_MODE => P_CALLED_MODE,
4890: P_MSG => 'After calling PA_FP_CALC_PLAN_PKG.calculate: '||
4891: x_return_status,

Line 4898: IF p_pa_debug_mode = 'Y' THEN

4894: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4895: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4896: END IF;
4897:
4898: IF p_pa_debug_mode = 'Y' THEN
4899: PA_DEBUG.Reset_Curr_Function;
4900: END IF;
4901: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4902: EXCEPTION

Line 4899: PA_DEBUG.Reset_Curr_Function;

4895: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4896: END IF;
4897:
4898: IF p_pa_debug_mode = 'Y' THEN
4899: PA_DEBUG.Reset_Curr_Function;
4900: END IF;
4901: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4902: EXCEPTION
4903: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 4922: IF P_PA_DEBUG_MODE = 'Y' THEN

4918: END IF;
4919: ROLLBACK;
4920:
4921: x_return_status := FND_API.G_RET_STS_ERROR;
4922: IF P_PA_DEBUG_MODE = 'Y' THEN
4923: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4924: P_CALLED_MODE => P_CALLED_MODE,
4925: P_MSG => 'Invalid Arguments Passed',
4926: P_MODULE_NAME => l_module_name);

Line 4927: PA_DEBUG.Reset_Curr_Function;

4923: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4924: P_CALLED_MODE => P_CALLED_MODE,
4925: P_MSG => 'Invalid Arguments Passed',
4926: P_MODULE_NAME => l_module_name);
4927: PA_DEBUG.Reset_Curr_Function;
4928: END IF;
4929: RAISE;
4930:
4931: WHEN OTHERS THEN

Line 4937: IF P_PA_DEBUG_MODE = 'Y' THEN

4933: x_msg_data := SUBSTR(SQLERRM,1,240);
4934: FND_MSG_PUB.add_exc_msg
4935: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
4936: ,p_procedure_name => 'GEN_FCST_TASK_LEVEL_AMT');
4937: IF P_PA_DEBUG_MODE = 'Y' THEN
4938: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4939: P_CALLED_MODE => P_CALLED_MODE,
4940: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
4941: P_MODULE_NAME => l_module_name);

Line 4942: PA_DEBUG.Reset_Curr_Function;

4938: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4939: P_CALLED_MODE => P_CALLED_MODE,
4940: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
4941: P_MODULE_NAME => l_module_name);
4942: PA_DEBUG.Reset_Curr_Function;
4943: END IF;
4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4945: END GEN_FCST_TASK_LEVEL_AMT;
4946:

Line 4966: IF p_pa_debug_mode = 'Y' THEN

4962: l_count number;
4963: BEGIN
4964: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4965: X_MSG_COUNT := 0;
4966: IF p_pa_debug_mode = 'Y' THEN
4967: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',
4968: p_debug_mode => p_pa_debug_mode);
4969: END IF;
4970:

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

4963: BEGIN
4964: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4965: X_MSG_COUNT := 0;
4966: IF p_pa_debug_mode = 'Y' THEN
4967: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',
4968: p_debug_mode => p_pa_debug_mode);
4969: END IF;
4970:
4971: DELETE FROM PA_FP_PLANNING_RES_TMP1;

Line 4968: p_debug_mode => p_pa_debug_mode);

4964: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4965: X_MSG_COUNT := 0;
4966: IF p_pa_debug_mode = 'Y' THEN
4967: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',
4968: p_debug_mode => p_pa_debug_mode);
4969: END IF;
4970:
4971: DELETE FROM PA_FP_PLANNING_RES_TMP1;
4972: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'L' THEN

Line 5032: IF P_PA_DEBUG_MODE = 'Y' THEN

5028: to_number(NULL) );
5029: END IF;
5030: -- select count(*) into l_count from PA_FP_PLANNING_RES_TMP1;
5031: -- hr_utility.trace('in maintain res asg plan res tmp1 count :'||l_count);
5032: IF P_PA_DEBUG_MODE = 'Y' THEN
5033: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5034: P_MSG => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',
5035: P_MODULE_NAME => l_module_name,
5036: p_log_level => 5);

Line 5046: IF P_PA_DEBUG_MODE = 'Y' THEN

5042: P_CALLING_PROCESS => 'FORECAST_GENERATION',
5043: X_RETURN_STATUS => x_return_status,
5044: X_MSG_COUNT => x_msg_count,
5045: X_MSG_DATA => x_msg_data );
5046: IF P_PA_DEBUG_MODE = 'Y' THEN
5047: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5048: P_MSG => 'After calling create_res_asg,return status is: '||x_return_status,
5049: P_MODULE_NAME => l_module_name,
5050: p_log_level => 5);

Line 5056: IF P_PA_DEBUG_MODE = 'Y' THEN

5052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5053: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5054: END IF;
5055:
5056: IF P_PA_DEBUG_MODE = 'Y' THEN
5057: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5058: P_MSG => 'Before calling pa_fp_copy_actuals_pub.update_res_asg',
5059: P_MODULE_NAME => l_module_name,
5060: p_log_level => 5);

Line 5070: IF P_PA_DEBUG_MODE = 'Y' THEN

5066: P_CALLING_PROCESS => 'FORECAST_GENERATION',
5067: X_RETURN_STATUS => x_return_status,
5068: X_MSG_COUNT => x_msg_count,
5069: X_MSG_DATA => x_msg_data );
5070: IF P_PA_DEBUG_MODE = 'Y' THEN
5071: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5072: P_MSG => 'After calling update_res_asg,return status is: '||x_return_status,
5073: P_MODULE_NAME => l_module_name,
5074: p_log_level => 5);

Line 5080: IF p_pa_debug_mode = 'Y' THEN

5076: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5077: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5078: END IF;
5079:
5080: IF p_pa_debug_mode = 'Y' THEN
5081: PA_DEBUG.Reset_Curr_Function;
5082: END IF;
5083: EXCEPTION
5084: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 5081: PA_DEBUG.Reset_Curr_Function;

5077: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5078: END IF;
5079:
5080: IF p_pa_debug_mode = 'Y' THEN
5081: PA_DEBUG.Reset_Curr_Function;
5082: END IF;
5083: EXCEPTION
5084: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5085: l_msg_count := FND_MSG_PUB.count_msg;

Line 5102: IF P_PA_DEBUG_MODE = 'Y' THEN

5098: END IF;
5099: ROLLBACK;
5100:
5101: x_return_status := FND_API.G_RET_STS_ERROR;
5102: IF P_PA_DEBUG_MODE = 'Y' THEN
5103: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5104: P_MSG => 'Invalid Arguments Passed',
5105: P_MODULE_NAME => l_module_name,
5106: p_log_level => 5);

Line 5107: PA_DEBUG.Reset_Curr_Function;

5103: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5104: P_MSG => 'Invalid Arguments Passed',
5105: P_MODULE_NAME => l_module_name,
5106: p_log_level => 5);
5107: PA_DEBUG.Reset_Curr_Function;
5108: END IF;
5109: RAISE;
5110:
5111: WHEN OTHERS THEN

Line 5117: IF P_PA_DEBUG_MODE = 'Y' THEN

5113: x_msg_data := SUBSTR(SQLERRM,1,240);
5114: FND_MSG_PUB.add_exc_msg
5115: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
5116: ,p_procedure_name => 'MAINTAIN_RES_ASG');
5117: IF P_PA_DEBUG_MODE = 'Y' THEN
5118: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5119: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5120: P_MODULE_NAME => l_module_name,
5121: p_log_level => 5);

Line 5122: PA_DEBUG.Reset_Curr_Function;

5118: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5119: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5120: P_MODULE_NAME => l_module_name,
5121: p_log_level => 5);
5122: PA_DEBUG.Reset_Curr_Function;
5123: END IF;
5124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5125: END MAINTAIN_RES_ASG;
5126:

Line 5168: IF p_pa_debug_mode = 'Y' THEN

5164:
5165: x_return_status := FND_API.G_RET_STS_SUCCESS;
5166: x_msg_count := 0;
5167:
5168: IF p_pa_debug_mode = 'Y' THEN
5169: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
5170: p_debug_mode => p_pa_debug_mode );
5171: END IF;
5172:

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

5165: x_return_status := FND_API.G_RET_STS_SUCCESS;
5166: x_msg_count := 0;
5167:
5168: IF p_pa_debug_mode = 'Y' THEN
5169: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
5170: p_debug_mode => p_pa_debug_mode );
5171: END IF;
5172:
5173: -- Print values of Input Parameters to debug log

Line 5170: p_debug_mode => p_pa_debug_mode );

5166: x_msg_count := 0;
5167:
5168: IF p_pa_debug_mode = 'Y' THEN
5169: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,
5170: p_debug_mode => p_pa_debug_mode );
5171: END IF;
5172:
5173: -- Print values of Input Parameters to debug log
5174: IF p_pa_debug_mode = 'Y' THEN

Line 5174: IF p_pa_debug_mode = 'Y' THEN

5170: p_debug_mode => p_pa_debug_mode );
5171: END IF;
5172:
5173: -- Print values of Input Parameters to debug log
5174: IF p_pa_debug_mode = 'Y' THEN
5175: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5176: ( p_msg => 'Input Parameters for '
5177: || l_module_name || '():',
5178: p_called_mode => p_called_mode,

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

5192: ( p_msg => 'P_ETC_START_DATE:['||p_etc_start_date||']',
5193: p_called_mode => p_called_mode,
5194: p_module_name => l_module_name,
5195: p_log_level => l_log_level );
5196: END IF; -- IF p_pa_debug_mode = 'Y' THEN
5197:
5198: -- Validate input parameters
5199: IF p_project_id is NULL OR
5200: p_budget_version_id is NULL OR

Line 5202: IF p_pa_debug_mode = 'Y' THEN

5198: -- Validate input parameters
5199: IF p_project_id is NULL OR
5200: p_budget_version_id is NULL OR
5201: p_etc_start_date is NULL THEN
5202: IF p_pa_debug_mode = 'Y' THEN
5203: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5204: ( p_msg => 'Input Parameter Validation FAILED',
5205: p_called_mode => p_called_mode,
5206: p_module_name => l_module_name,

Line 5208: PA_DEBUG.RESET_CURR_FUNCTION;

5204: ( p_msg => 'Input Parameter Validation FAILED',
5205: p_called_mode => p_called_mode,
5206: p_module_name => l_module_name,
5207: p_log_level => l_log_level );
5208: PA_DEBUG.RESET_CURR_FUNCTION;
5209: END IF;
5210: RETURN;
5211: END IF;
5212:

Line 5235: IF p_pa_debug_mode = 'Y' THEN

5231: AND tmp2.txn_currency_code is not null
5232: AND bl.resource_assignment_id = tmp2.target_res_asg_id
5233: AND bl.txn_currency_code = tmp2.etc_currency_code );
5234:
5235: IF p_pa_debug_mode = 'Y' THEN
5236: PA_DEBUG.RESET_CURR_FUNCTION;
5237: END IF;
5238: EXCEPTION
5239: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 5236: PA_DEBUG.RESET_CURR_FUNCTION;

5232: AND bl.resource_assignment_id = tmp2.target_res_asg_id
5233: AND bl.txn_currency_code = tmp2.etc_currency_code );
5234:
5235: IF p_pa_debug_mode = 'Y' THEN
5236: PA_DEBUG.RESET_CURR_FUNCTION;
5237: END IF;
5238: EXCEPTION
5239: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5240: l_msg_count := FND_MSG_PUB.count_msg;

Line 5258: IF p_pa_debug_mode = 'Y' THEN

5254:
5255: ROLLBACK;
5256: x_return_status := FND_API.G_RET_STS_ERROR;
5257:
5258: IF p_pa_debug_mode = 'Y' THEN
5259: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5260: (p_msg => 'Invalid Arguments Passed',
5261: p_module_name => l_module_name,
5262: p_log_level => 5);

Line 5263: PA_DEBUG.RESET_CURR_FUNCTION;

5259: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5260: (p_msg => 'Invalid Arguments Passed',
5261: p_module_name => l_module_name,
5262: p_log_level => 5);
5263: PA_DEBUG.RESET_CURR_FUNCTION;
5264: END IF;
5265: RAISE;
5266: WHEN OTHERS THEN
5267: ROLLBACK;

Line 5276: IF p_pa_debug_mode = 'Y' THEN

5272: ( p_pkg_name => l_package_name,
5273: p_procedure_name => l_procedure_name,
5274: p_error_text => substr(sqlerrm,1,240));
5275:
5276: IF p_pa_debug_mode = 'Y' THEN
5277: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5278: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5279: p_module_name => l_module_name,
5280: p_log_level => 5);

Line 5281: PA_DEBUG.RESET_CURR_FUNCTION;

5277: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5278: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5279: p_module_name => l_module_name,
5280: p_log_level => 5);
5281: PA_DEBUG.RESET_CURR_FUNCTION;
5282: END IF;
5283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5284:
5285: END UPD_REV_CALCULATION_ERR;