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_FP_GEN_AMOUNT_UTILS

Line 14: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

10:
11: PROCEDURE UPD_REV_CALCULATION_ERR
12: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
13: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
14: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
15: P_ETC_START_DATE IN DATE,
16: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
17: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
18: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 31: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

27: **/
28: PROCEDURE GENERATE_FCST_AMT_WRP
29: ( P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
30: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
31: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
32: P_CALLED_MODE IN VARCHAR2,
33: P_COMMIT_FLAG IN VARCHAR2,
34: P_INIT_MSG_FLAG IN VARCHAR2,
35: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,

Line 102: pa_fp_gen_amount_utils.fp_debug

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',
106: p_module_name => l_module_name);

Line 116: pa_fp_gen_amount_utils.fp_debug

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,
120: p_module_name => l_module_name);

Line 127: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
131: P_MODULE_NAME => l_module_name);

Line 145: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
149: P_MODULE_NAME => l_module_name);

Line 183: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
187: END IF;

Line 199: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
203: P_MODULE_NAME => l_module_name);

Line 219: pa_fp_gen_amount_utils.fp_debug

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',
223: p_module_name => l_module_name,

Line 253: pa_fp_gen_amount_utils.fp_debug

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,
257: p_module_name => l_module_name,

Line 262: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
266: P_MODULE_NAME => l_module_name);

Line 291: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
295: P_MODULE_NAME => l_module_name);

Line 313: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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.'||
317: 'GENERATE_WP_BUDGET_AMT',

Line 346: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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.'||
350: 'GENERATE_WP_BUDGET_AMT: '||x_return_status,

Line 358: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
362: P_MODULE_NAME => l_module_name);

Line 380: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
384: P_MODULE_NAME => l_module_name);

Line 393: pa_fp_gen_amount_utils.fp_debug

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

Line 400: pa_fp_gen_amount_utils.fp_debug

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

Line 408: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
412: P_MODULE_NAME => l_module_name);

Line 424: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
428: P_MODULE_NAME => l_module_name);

Line 438: pa_fp_gen_amount_utils.fp_debug

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

Line 469: pa_fp_gen_amount_utils.fp_debug

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',
473: p_module_name => l_module_name,

Line 488: pa_fp_gen_amount_utils.fp_debug

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: '
492: ||x_return_status,

Line 502: pa_fp_gen_amount_utils.fp_debug

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',
506: p_module_name => l_module_name,

Line 520: pa_fp_gen_amount_utils.fp_debug

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: '
524: ||x_return_status,

Line 529: pa_fp_gen_amount_utils.fp_debug

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);
533: END IF;

Line 543: pa_fp_gen_amount_utils.fp_debug

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',
547: p_module_name => l_module_name,

Line 562: pa_fp_gen_amount_utils.fp_debug

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'
566: ||x_return_status,

Line 584: pa_fp_gen_amount_utils.fp_debug

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',
588: p_module_name => l_module_name,

Line 606: pa_fp_gen_amount_utils.fp_debug

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: '
610: ||x_return_status,

Line 618: pa_fp_gen_amount_utils.fp_debug

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',
622: p_module_name => l_module_name,

Line 635: pa_fp_gen_amount_utils.fp_debug

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: '
639: ||x_return_status,

Line 661: pa_fp_gen_amount_utils.fp_debug

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',
665: p_module_name => l_module_name,

Line 680: pa_fp_gen_amount_utils.fp_debug

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: '
684: ||x_return_status,

Line 691: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
695: P_MODULE_NAME => l_module_name);

Line 708: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
712: P_MODULE_NAME => l_module_name);

Line 739: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
743: P_MODULE_NAME => l_module_name);

Line 753: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
757: P_MODULE_NAME => l_module_name);

Line 770: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
774: P_MODULE_NAME => l_module_name);

Line 786: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
790: P_MODULE_NAME => l_module_name);

Line 804: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
808: P_MODULE_NAME => l_module_name);

Line 820: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
824: P_MODULE_NAME => l_module_name);

Line 838: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
842: P_MODULE_NAME => l_module_name);

Line 879: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
883: PA_DEBUG.Reset_Curr_Function;

Line 894: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
898: PA_DEBUG.Reset_Curr_Function;

Line 907: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

903:
904: PROCEDURE GEN_FCST_TASK_LEVEL_AMT
905: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
906: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
907: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
908: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
909: P_ETC_FP_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
910: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
911: P_ACTUALS_FROM_PERIOD IN VARCHAR2,

Line 925: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

921: l_latest_published_fwbs_id NUMBER;
922: l_proj_struc_sharing_code VARCHAR2(30);
923:
924: l_wp_version_id NUMBER;
925: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
926: l_fp_cols_rec_wp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
927: l_fp_cols_rec_fp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
928: l_fp_cols_rec_approved PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
929: l_resource_list_id NUMBER;

Line 926: l_fp_cols_rec_wp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

922: l_proj_struc_sharing_code VARCHAR2(30);
923:
924: l_wp_version_id NUMBER;
925: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
926: l_fp_cols_rec_wp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
927: l_fp_cols_rec_fp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
928: l_fp_cols_rec_approved PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
929: l_resource_list_id NUMBER;
930: l_struct_ver_id NUMBER;

Line 927: l_fp_cols_rec_fp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

923:
924: l_wp_version_id NUMBER;
925: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
926: l_fp_cols_rec_wp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
927: l_fp_cols_rec_fp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
928: l_fp_cols_rec_approved PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
929: l_resource_list_id NUMBER;
930: l_struct_ver_id NUMBER;
931: l_calendar_type VARCHAR2(3);

Line 928: l_fp_cols_rec_approved PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

924: l_wp_version_id NUMBER;
925: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
926: l_fp_cols_rec_wp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
927: l_fp_cols_rec_fp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
928: l_fp_cols_rec_approved PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
929: l_resource_list_id NUMBER;
930: l_struct_ver_id NUMBER;
931: l_calendar_type VARCHAR2(3);
932: l_record_type VARCHAR2(10);

Line 1109: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1105: l_init_raw_cost NUMBER;
1106: l_init_burdened_cost NUMBER;
1107: l_init_revenue NUMBER;
1108:
1109: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1110: /* Bug 4369741: Replaced l_planning_options_flag with 2 separate
1111: * planning options flags for WP and FP later in the declaration. */
1112: --l_planning_options_flag VARCHAR2(1);
1113: l_ra_txn_source_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;

Line 1603: pa_fp_gen_amount_utils.fp_debug

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

Line 1609: pa_fp_gen_amount_utils.fp_debug

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

Line 1615: pa_fp_gen_amount_utils.fp_debug

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

Line 1629: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
1633: END IF;

Line 1645: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
1649: P_MODULE_NAME => l_module_name);

Line 1664: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
1668: P_MODULE_NAME => l_module_name);

Line 1699: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
1703: P_MODULE_NAME => l_module_name);

Line 1732: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
1736: P_MODULE_NAME => l_module_name);

Line 1734: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||

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',
1736: P_MODULE_NAME => l_module_name);
1737: END IF;
1738: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

Line 1738: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

1734: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1735: 'GET_PLAN_VERSION_DTL',
1736: P_MODULE_NAME => l_module_name);
1737: END IF;
1738: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
1739: P_PROJECT_ID => P_PROJECT_ID,
1740: P_BUDGET_VERSION_ID => l_wp_version_id,
1741: X_FP_COLS_REC => l_fp_cols_rec_wp,
1742: X_RETURN_STATUS => x_return_status,

Line 1746: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
1750: P_MODULE_NAME => l_module_name);

Line 1748: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||

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,
1750: P_MODULE_NAME => l_module_name);
1751: END IF;
1752: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1758: pa_fp_gen_amount_utils.fp_debug

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

Line 1766: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
1770: P_MODULE_NAME => l_module_name);

Line 1768: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||

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',
1770: P_MODULE_NAME => l_module_name);
1771: END IF;
1772: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

Line 1772: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

1768: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1769: 'GET_PLAN_VERSION_DTLS',
1770: P_MODULE_NAME => l_module_name);
1771: END IF;
1772: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
1773: P_PROJECT_ID => P_PROJECT_ID,
1774: P_BUDGET_VERSION_ID => P_ETC_FP_PLAN_VERSION_ID,
1775: X_FP_COLS_REC => l_fp_cols_rec_fp,
1776: X_RETURN_STATUS => x_return_status,

Line 1780: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
1784: P_MODULE_NAME => l_module_name);

Line 1782: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||

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,
1784: P_MODULE_NAME => l_module_name);
1785: END IF;
1786: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1815: pa_fp_gen_amount_utils.fp_debug

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

Line 1821: pa_fp_gen_amount_utils.fp_debug

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

Line 1828: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
1832: P_MODULE_NAME => l_module_name);

Line 1854: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
1858: P_MODULE_NAME => l_module_name);

Line 1873: pa_fp_gen_amount_utils.fp_debug

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

Line 1879: pa_fp_gen_amount_utils.fp_debug

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

Line 1886: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
1890: P_MODULE_NAME => l_module_name);

Line 1912: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
1916: P_MODULE_NAME => l_module_name);

Line 1928: pa_fp_gen_amount_utils.fp_debug

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);
1932: END IF;

Line 1934: pa_fp_gen_amount_utils.fp_debug

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

Line 1940: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
1944: P_MODULE_NAME => l_module_name);

Line 1964: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
1968: P_MODULE_NAME => l_module_name);

Line 2027: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2031: P_MODULE_NAME => l_module_name);

Line 2053: pa_fp_gen_amount_utils.fp_debug

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

Line 2083: pa_fp_gen_amount_utils.fp_debug

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

Line 2092: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2096: P_MODULE_NAME => l_module_name);

Line 2130: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2134: P_MODULE_NAME => l_module_name);

Line 2138: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2142: P_MODULE_NAME => l_module_name);

Line 2153: pa_fp_gen_amount_utils.fp_debug

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);
2157: END IF;

Line 2159: pa_fp_gen_amount_utils.fp_debug

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);
2163: END IF;

Line 2165: pa_fp_gen_amount_utils.fp_debug

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

Line 2176: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2180: P_MODULE_NAME => l_module_name);

Line 2197: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2201: P_MODULE_NAME => l_module_name);

Line 2209: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
2213: END IF;

Line 2267: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
2271: END IF;

Line 2282: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2286: P_MODULE_NAME => l_module_name);

Line 2298: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
2302: END IF;

Line 2314: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2318: P_MODULE_NAME => l_module_name);

Line 2328: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2332: P_MODULE_NAME => l_module_name);

Line 2357: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2361: P_MODULE_NAME => l_module_name);

Line 2391: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2395: P_MODULE_NAME => l_module_name);

Line 2406: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2410: P_MODULE_NAME => l_module_name);

Line 2431: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2435: P_MODULE_NAME => l_module_name);

Line 2433: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||

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',
2435: P_MODULE_NAME => l_module_name);
2436: END IF;
2437: PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info(

Line 2437: PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info(

2433: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
2434: 'Get_Curr_Original_Version_Info',
2435: P_MODULE_NAME => l_module_name);
2436: END IF;
2437: PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info(
2438: p_project_id => P_PROJECT_ID,
2439: p_fin_plan_type_id => l_fin_plan_type_id,
2440: p_version_type => l_version_type,
2441: p_status_code => 'CURRENT_APPROVED',

Line 2447: --dbms_output.put_line('--!after PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info'||x_return_status);

2443: x_fin_plan_version_id => l_approved_fp_version_id,
2444: x_return_status => x_return_status,
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,

Line 2450: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2454: P_MODULE_NAME => l_module_name);

Line 2452: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||

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,
2454: P_MODULE_NAME => l_module_name);
2455: END IF;
2456: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 2467: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2471: P_MODULE_NAME => l_module_name);

Line 2469: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||

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',
2471: P_MODULE_NAME => l_module_name);
2472: END IF;
2473: --dbms_output.put_line('--before PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS');

Line 2473: --dbms_output.put_line('--before PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS');

2469: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
2470: 'GET_PLAN_VERSION_DTLS',
2471: P_MODULE_NAME => l_module_name);
2472: END IF;
2473: --dbms_output.put_line('--before PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS');
2474: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
2475: P_PROJECT_ID => P_PROJECT_ID,
2476: P_BUDGET_VERSION_ID => l_approved_fp_version_id,
2477: X_FP_COLS_REC => l_fp_cols_rec_approved,

Line 2474: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

2470: 'GET_PLAN_VERSION_DTLS',
2471: P_MODULE_NAME => l_module_name);
2472: END IF;
2473: --dbms_output.put_line('--before PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS');
2474: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
2475: P_PROJECT_ID => P_PROJECT_ID,
2476: P_BUDGET_VERSION_ID => l_approved_fp_version_id,
2477: X_FP_COLS_REC => l_fp_cols_rec_approved,
2478: X_RETURN_STATUS => x_return_status,

Line 2481: --dbms_output.put_line('--after PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS :'||x_return_status);

2477: X_FP_COLS_REC => l_fp_cols_rec_approved,
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.'||

Line 2483: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2487: P_MODULE_NAME => l_module_name);

Line 2485: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||

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,
2487: P_MODULE_NAME => l_module_name);
2488: END IF;
2489: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 2494: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2498: P_MODULE_NAME => l_module_name);

Line 2513: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2517: P_MODULE_NAME => l_module_name);

Line 2524: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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)',
2528: P_MODULE_NAME => l_module_name);

Line 2540: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2544: P_MODULE_NAME => l_module_name);

Line 2574: pa_fp_gen_amount_utils.fp_debug

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

Line 2583: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2587: P_MODULE_NAME => l_module_name);

Line 2604: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2608: P_MODULE_NAME => l_module_name);

Line 2620: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2624: P_MODULE_NAME => l_module_name);

Line 2635: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2639: P_MODULE_NAME => l_module_name);

Line 2651: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2655: P_MODULE_NAME => l_module_name);

Line 2667: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2671: P_MODULE_NAME => l_module_name);

Line 2679: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2683: P_MODULE_NAME => l_module_name);

Line 2709: pa_fp_gen_amount_utils.fp_debug

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);
2713: END IF;

Line 2715: pa_fp_gen_amount_utils.fp_debug

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);
2719: END IF;

Line 2721: pa_fp_gen_amount_utils.fp_debug

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);
2725: END IF;

Line 2727: pa_fp_gen_amount_utils.fp_debug

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);
2731: END IF;

Line 2733: pa_fp_gen_amount_utils.fp_debug

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

Line 2778: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2782: P_MODULE_NAME => l_module_name);

Line 2800: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2804: P_MODULE_NAME => l_module_name);

Line 2817: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2821: P_MODULE_NAME => l_module_name);

Line 2839: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2843: P_MODULE_NAME => l_module_name);

Line 2856: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2860: P_MODULE_NAME => l_module_name);

Line 2878: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2882: P_MODULE_NAME => l_module_name);

Line 2897: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
2901: P_MODULE_NAME => l_module_name);

Line 2915: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
2919: P_MODULE_NAME => l_module_name);

Line 2957: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(p_budget_version_id);

2953: WHERE transaction_source_code = 'ETC';
2954: ELSIF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'Y' THEN
2955: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
2956: l_etc_start_date :=
2957: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(p_budget_version_id);
2958:
2959: SELECT /*+ INDEX(tmp1,PA_FP_CALC_AMT_TMP1_N1)*/
2960: DISTINCT tmp1.target_res_asg_id
2961: BULK COLLECT

Line 3329: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
3333: P_MODULE_NAME => l_module_name);

Line 3347: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
3351: P_MODULE_NAME => l_module_name);

Line 3398: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
3402: P_MODULE_NAME => l_module_name);

Line 3414: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
3418: P_MODULE_NAME => l_module_name);

Line 3434: pa_fp_gen_amount_utils.fp_debug

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);
3438: END IF;

Line 3440: pa_fp_gen_amount_utils.fp_debug

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);
3444: END IF;

Line 3446: pa_fp_gen_amount_utils.fp_debug

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

Line 3787: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
3791: P_MODULE_NAME => l_module_name);

Line 3804: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
3808: P_MODULE_NAME => l_module_name);

Line 3911: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
3915: P_MODULE_NAME => l_module_name);

Line 3967: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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: '
3971: ||x_return_status,

Line 4455: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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',
4459: P_MODULE_NAME => l_module_name);

Line 4473: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
4477: P_MODULE_NAME => l_module_name);

Line 4545: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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,
4549: p_log_level => 5 );

Line 4557: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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,
4561: p_module_name => l_module_name,

Line 4570: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
4574: END IF;

Line 4632: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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,
4636: P_MODULE_NAME => l_module_name);

Line 4667: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
4671: PA_DEBUG.Reset_Curr_Function;

Line 4682: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
4686: PA_DEBUG.Reset_Curr_Function;

Line 4694: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

4690:
4691: PROCEDURE MAINTAIN_RES_ASG(
4692: P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4693: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4694: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4695: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4696: X_MSG_COUNT OUT NOCOPY NUMBER,
4697: X_MSG_DATA OUT NOCOPY VARCHAR2)
4698: IS

Line 4771: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
4775: END IF;

Line 4785: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
4789: END IF;

Line 4795: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
4799: END IF;

Line 4809: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
4813: END IF;

Line 4841: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
4845: PA_DEBUG.Reset_Curr_Function;

Line 4856: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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);
4860: PA_DEBUG.Reset_Curr_Function;

Line 4884: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

4880: */
4881: PROCEDURE UPD_REV_CALCULATION_ERR
4882: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4883: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4884: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4885: P_ETC_START_DATE IN DATE,
4886: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
4887: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4888: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 4913: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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,
4917: p_module_name => l_module_name,

Line 4919: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

4915: || l_module_name || '():',
4916: p_called_mode => p_called_mode,
4917: p_module_name => l_module_name,
4918: p_log_level => l_log_level );
4919: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4920: ( p_msg => 'P_PROJECT_ID:['||p_project_id||']',
4921: p_called_mode => p_called_mode,
4922: p_module_name => l_module_name,
4923: p_log_level => l_log_level );

Line 4924: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

4920: ( p_msg => 'P_PROJECT_ID:['||p_project_id||']',
4921: p_called_mode => p_called_mode,
4922: p_module_name => l_module_name,
4923: p_log_level => l_log_level );
4924: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4925: ( p_msg => 'P_BUDGET_VERSION_ID:['||p_budget_version_id||']',
4926: p_called_mode => p_called_mode,
4927: p_module_name => l_module_name,
4928: p_log_level => l_log_level );

Line 4929: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

4925: ( p_msg => 'P_BUDGET_VERSION_ID:['||p_budget_version_id||']',
4926: p_called_mode => p_called_mode,
4927: p_module_name => l_module_name,
4928: p_log_level => l_log_level );
4929: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
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 );

Line 4941: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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,
4945: p_log_level => l_log_level );

Line 4997: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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);
5001: PA_DEBUG.RESET_CURR_FUNCTION;

Line 5015: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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);
5019: PA_DEBUG.RESET_CURR_FUNCTION;