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 121: pa_fp_gen_amount_utils.fp_debug

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

Line 135: pa_fp_gen_amount_utils.fp_debug

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

Line 146: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 164: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 202: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 218: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 238: pa_fp_gen_amount_utils.fp_debug

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

Line 272: pa_fp_gen_amount_utils.fp_debug

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

Line 281: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 310: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 332: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 365: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 377: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 399: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 412: pa_fp_gen_amount_utils.fp_debug

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

Line 419: pa_fp_gen_amount_utils.fp_debug

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

Line 427: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 443: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 457: pa_fp_gen_amount_utils.fp_debug

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

Line 488: pa_fp_gen_amount_utils.fp_debug

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

Line 507: pa_fp_gen_amount_utils.fp_debug

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

Line 521: pa_fp_gen_amount_utils.fp_debug

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

Line 539: pa_fp_gen_amount_utils.fp_debug

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

Line 548: pa_fp_gen_amount_utils.fp_debug

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

Line 562: pa_fp_gen_amount_utils.fp_debug

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

Line 581: pa_fp_gen_amount_utils.fp_debug

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

Line 603: pa_fp_gen_amount_utils.fp_debug

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

Line 625: pa_fp_gen_amount_utils.fp_debug

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

Line 637: pa_fp_gen_amount_utils.fp_debug

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

Line 654: pa_fp_gen_amount_utils.fp_debug

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

Line 675: pa_fp_gen_amount_utils.fp_debug

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

Line 732: pa_fp_gen_amount_utils.fp_debug

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

Line 761: pa_fp_gen_amount_utils.fp_debug

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

Line 780: pa_fp_gen_amount_utils.fp_debug

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

Line 791: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 808: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 839: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 853: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 870: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 886: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 904: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 920: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 938: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 956: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 974: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 1017: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 1032: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 1045: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1041:
1042: PROCEDURE GEN_FCST_TASK_LEVEL_AMT
1043: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
1044: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1045: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1046: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1047: P_ETC_FP_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1048: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1049: P_ACTUALS_FROM_PERIOD IN VARCHAR2,

Line 1063: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1059: l_latest_published_fwbs_id NUMBER;
1060: l_proj_struc_sharing_code VARCHAR2(30);
1061:
1062: l_wp_version_id NUMBER;
1063: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1064: l_fp_cols_rec_wp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1065: l_fp_cols_rec_fp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1066: l_fp_cols_rec_approved PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1067: l_resource_list_id NUMBER;

Line 1064: l_fp_cols_rec_wp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1060: l_proj_struc_sharing_code VARCHAR2(30);
1061:
1062: l_wp_version_id NUMBER;
1063: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1064: l_fp_cols_rec_wp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1065: l_fp_cols_rec_fp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1066: l_fp_cols_rec_approved PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1067: l_resource_list_id NUMBER;
1068: l_struct_ver_id NUMBER;

Line 1065: l_fp_cols_rec_fp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1061:
1062: l_wp_version_id NUMBER;
1063: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1064: l_fp_cols_rec_wp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1065: l_fp_cols_rec_fp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1066: l_fp_cols_rec_approved PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1067: l_resource_list_id NUMBER;
1068: l_struct_ver_id NUMBER;
1069: l_calendar_type VARCHAR2(3);

Line 1066: l_fp_cols_rec_approved PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1062: l_wp_version_id NUMBER;
1063: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1064: l_fp_cols_rec_wp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1065: l_fp_cols_rec_fp PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1066: l_fp_cols_rec_approved PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1067: l_resource_list_id NUMBER;
1068: l_struct_ver_id NUMBER;
1069: l_calendar_type VARCHAR2(3);
1070: l_record_type VARCHAR2(10);

Line 1265: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1261: l_init_raw_cost NUMBER;
1262: l_init_burdened_cost NUMBER;
1263: l_init_revenue NUMBER;
1264:
1265: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1266: /* Bug 4369741: Replaced l_planning_options_flag with 2 separate
1267: * planning options flags for WP and FP later in the declaration. */
1268: --l_planning_options_flag VARCHAR2(1);
1269: l_ra_txn_source_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;

Line 1772: pa_fp_gen_amount_utils.fp_debug

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

Line 1778: pa_fp_gen_amount_utils.fp_debug

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

Line 1784: pa_fp_gen_amount_utils.fp_debug

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

Line 1798: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 1814: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 1833: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 1868: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 1901: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

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

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',
1905: P_MODULE_NAME => l_module_name);
1906: END IF;
1907: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

Line 1907: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

1903: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1904: 'GET_PLAN_VERSION_DTL',
1905: P_MODULE_NAME => l_module_name);
1906: END IF;
1907: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
1908: P_PROJECT_ID => P_PROJECT_ID,
1909: P_BUDGET_VERSION_ID => l_wp_version_id,
1910: X_FP_COLS_REC => l_fp_cols_rec_wp,
1911: X_RETURN_STATUS => x_return_status,

Line 1915: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

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

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,
1919: P_MODULE_NAME => l_module_name);
1920: END IF;
1921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1927: pa_fp_gen_amount_utils.fp_debug

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

Line 1935: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

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

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',
1939: P_MODULE_NAME => l_module_name);
1940: END IF;
1941: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

Line 1941: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

1937: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1938: 'GET_PLAN_VERSION_DTLS',
1939: P_MODULE_NAME => l_module_name);
1940: END IF;
1941: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
1942: P_PROJECT_ID => P_PROJECT_ID,
1943: P_BUDGET_VERSION_ID => P_ETC_FP_PLAN_VERSION_ID,
1944: X_FP_COLS_REC => l_fp_cols_rec_fp,
1945: X_RETURN_STATUS => x_return_status,

Line 1949: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

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

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,
1953: P_MODULE_NAME => l_module_name);
1954: END IF;
1955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1984: pa_fp_gen_amount_utils.fp_debug

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

Line 1990: pa_fp_gen_amount_utils.fp_debug

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

Line 1997: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2023: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2042: pa_fp_gen_amount_utils.fp_debug

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

Line 2048: pa_fp_gen_amount_utils.fp_debug

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

Line 2055: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2081: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2097: pa_fp_gen_amount_utils.fp_debug

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

Line 2103: pa_fp_gen_amount_utils.fp_debug

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

Line 2109: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2133: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2196: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2231: pa_fp_gen_amount_utils.fp_debug

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

Line 2261: pa_fp_gen_amount_utils.fp_debug

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

Line 2270: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2309: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2317: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2332: pa_fp_gen_amount_utils.fp_debug

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

Line 2338: pa_fp_gen_amount_utils.fp_debug

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

Line 2344: pa_fp_gen_amount_utils.fp_debug

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

Line 2355: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2376: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2388: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2449: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2464: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2480: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2496: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2510: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2539: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2573: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2588: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2613: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

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

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',
2617: P_MODULE_NAME => l_module_name);
2618: END IF;
2619: PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info(

Line 2619: PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info(

2615: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
2616: 'Get_Curr_Original_Version_Info',
2617: P_MODULE_NAME => l_module_name);
2618: END IF;
2619: PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info(
2620: p_project_id => P_PROJECT_ID,
2621: p_fin_plan_type_id => l_fin_plan_type_id,
2622: p_version_type => l_version_type,
2623: p_status_code => 'CURRENT_APPROVED',

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

2625: x_fin_plan_version_id => l_approved_fp_version_id,
2626: x_return_status => x_return_status,
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,

Line 2632: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

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

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,
2636: P_MODULE_NAME => l_module_name);
2637: END IF;
2638: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 2649: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

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

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

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

2651: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
2652: 'GET_PLAN_VERSION_DTLS',
2653: P_MODULE_NAME => l_module_name);
2654: END IF;
2655: --dbms_output.put_line('--before PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS');
2656: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
2657: P_PROJECT_ID => P_PROJECT_ID,
2658: P_BUDGET_VERSION_ID => l_approved_fp_version_id,
2659: X_FP_COLS_REC => l_fp_cols_rec_approved,

Line 2656: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

2652: 'GET_PLAN_VERSION_DTLS',
2653: P_MODULE_NAME => l_module_name);
2654: END IF;
2655: --dbms_output.put_line('--before PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS');
2656: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
2657: P_PROJECT_ID => P_PROJECT_ID,
2658: P_BUDGET_VERSION_ID => l_approved_fp_version_id,
2659: X_FP_COLS_REC => l_fp_cols_rec_approved,
2660: X_RETURN_STATUS => x_return_status,

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

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

Line 2665: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

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

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,
2669: P_MODULE_NAME => l_module_name);
2670: END IF;
2671: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 2676: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2695: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2706: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2722: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2757: pa_fp_gen_amount_utils.fp_debug

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

Line 2766: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2787: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2803: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2818: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2834: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2850: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2862: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2893: pa_fp_gen_amount_utils.fp_debug

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

Line 2899: pa_fp_gen_amount_utils.fp_debug

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

Line 2905: pa_fp_gen_amount_utils.fp_debug

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

Line 2911: pa_fp_gen_amount_utils.fp_debug

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

Line 2917: pa_fp_gen_amount_utils.fp_debug

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

Line 2973: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 2996: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3013: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3035: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3052: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3075: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3094: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3112: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3125: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3140: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3184: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(p_budget_version_id);

3180: WHERE transaction_source_code = 'ETC';
3181: ELSIF p_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'Y' THEN
3182: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
3183: l_etc_start_date :=
3184: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(p_budget_version_id);
3185:
3186: SELECT /*+ INDEX(tmp1,PA_FP_CALC_AMT_TMP1_N1)*/
3187: DISTINCT tmp1.target_res_asg_id
3188: BULK COLLECT

Line 3569: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3587: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3638: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3654: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 3674: pa_fp_gen_amount_utils.fp_debug

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

Line 3680: pa_fp_gen_amount_utils.fp_debug

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

Line 3686: pa_fp_gen_amount_utils.fp_debug

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

Line 4031: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 4048: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 4155: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 4211: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 4711: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 4729: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 4801: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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

Line 4813: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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

Line 4826: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 4888: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 4923: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 4938: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 4950: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

4946:
4947: PROCEDURE MAINTAIN_RES_ASG(
4948: P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4949: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4950: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4951: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4952: X_MSG_COUNT OUT NOCOPY NUMBER,
4953: X_MSG_DATA OUT NOCOPY VARCHAR2)
4954: IS

Line 5033: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 5047: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 5057: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 5071: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 5103: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 5118: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 5146: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

5142: */
5143: PROCEDURE UPD_REV_CALCULATION_ERR
5144: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
5145: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5146: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5147: P_ETC_START_DATE IN DATE,
5148: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
5149: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5150: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5175: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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

Line 5181: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

5177: || l_module_name || '():',
5178: p_called_mode => p_called_mode,
5179: p_module_name => l_module_name,
5180: p_log_level => l_log_level );
5181: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5182: ( p_msg => 'P_PROJECT_ID:['||p_project_id||']',
5183: p_called_mode => p_called_mode,
5184: p_module_name => l_module_name,
5185: p_log_level => l_log_level );

Line 5186: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

5182: ( p_msg => 'P_PROJECT_ID:['||p_project_id||']',
5183: p_called_mode => p_called_mode,
5184: p_module_name => l_module_name,
5185: p_log_level => l_log_level );
5186: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5187: ( p_msg => 'P_BUDGET_VERSION_ID:['||p_budget_version_id||']',
5188: p_called_mode => p_called_mode,
5189: p_module_name => l_module_name,
5190: p_log_level => l_log_level );

Line 5191: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

5187: ( p_msg => 'P_BUDGET_VERSION_ID:['||p_budget_version_id||']',
5188: p_called_mode => p_called_mode,
5189: p_module_name => l_module_name,
5190: p_log_level => l_log_level );
5191: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
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 );

Line 5203: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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

Line 5259: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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

Line 5277: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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