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_BUDGET_AMT_PUB dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 39: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

35: l_msg_data VARCHAR2(2000);
36: l_data VARCHAR2(2000);
37: l_msg_index_out NUMBER:=0;
38:
39: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
40: l_rev_gen_method VARCHAR2(3);
41:
42: -- Bug Fix: 4569365. Removed MRC code.
43: -- g_mrc_exception EXCEPTION;

Line 73: pa_fp_gen_amount_utils.fp_debug

69: END IF;
70:
71: --Calling the get_plan_version_dtls api
72: IF p_pa_debug_mode = 'Y' THEN
73: pa_fp_gen_amount_utils.fp_debug
74: (p_called_mode => p_called_mode,
75: p_msg => 'Before calling
76: pa_fp_gen_amount_utils.get_plan_version_dtls',
77: p_module_name => l_module_name,

Line 76: pa_fp_gen_amount_utils.get_plan_version_dtls',

72: IF p_pa_debug_mode = 'Y' THEN
73: pa_fp_gen_amount_utils.fp_debug
74: (p_called_mode => p_called_mode,
75: p_msg => 'Before calling
76: pa_fp_gen_amount_utils.get_plan_version_dtls',
77: p_module_name => l_module_name,
78: p_log_level => 5);
79: END IF;
80: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 80: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

76: pa_fp_gen_amount_utils.get_plan_version_dtls',
77: p_module_name => l_module_name,
78: p_log_level => 5);
79: END IF;
80: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
81: (P_PROJECT_ID => P_PROJECT_ID,
82: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
83: X_FP_COLS_REC => l_fp_cols_rec,
84: X_RETURN_STATUS => X_RETURN_STATUS,

Line 88: pa_fp_gen_amount_utils.fp_debug

84: X_RETURN_STATUS => X_RETURN_STATUS,
85: X_MSG_COUNT => X_MSG_COUNT,
86: X_MSG_DATA => X_MSG_DATA);
87: IF p_pa_debug_mode = 'Y' THEN
88: pa_fp_gen_amount_utils.fp_debug
89: (p_called_mode => p_called_mode,
90: p_msg => 'Status after calling
91: pa_fp_gen_amount_utils.get_plan_version_dtls: '
92: ||x_return_status,

Line 91: pa_fp_gen_amount_utils.get_plan_version_dtls: '

87: IF p_pa_debug_mode = 'Y' THEN
88: pa_fp_gen_amount_utils.fp_debug
89: (p_called_mode => p_called_mode,
90: p_msg => 'Status after calling
91: pa_fp_gen_amount_utils.get_plan_version_dtls: '
92: ||x_return_status,
93: p_module_name => l_module_name,
94: p_log_level => 5);
95: END IF;

Line 105: pa_fp_gen_amount_utils.fp_debug

101: * For a list of unsupported cases, please see comments at the
102: * beginning of the VALIDATE_SUPPORT_CASES API (PAFPGAUB.pls) */
103:
104: IF p_pa_debug_mode = 'Y' THEN
105: pa_fp_gen_amount_utils.fp_debug
106: ( p_msg => 'Before calling
107: pa_fp_gen_amount_utils.validate_support_cases',
108: p_module_name => l_module_name,
109: p_log_level => 5 );

Line 107: pa_fp_gen_amount_utils.validate_support_cases',

103:
104: IF p_pa_debug_mode = 'Y' THEN
105: pa_fp_gen_amount_utils.fp_debug
106: ( p_msg => 'Before calling
107: pa_fp_gen_amount_utils.validate_support_cases',
108: p_module_name => l_module_name,
109: p_log_level => 5 );
110: END IF;
111:

Line 112: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (

108: p_module_name => l_module_name,
109: p_log_level => 5 );
110: END IF;
111:
112: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (
113: P_FP_COLS_REC_TGT => l_fp_cols_rec,
114: P_CHECK_SRC_ERRORS_FLAG => P_CHECK_SRC_ERRORS_FLAG,
115: P_CALLING_CONTEXT => P_CALLED_MODE, /* Added for ER 4391321 */
116: X_WARNING_MESSAGE => X_WARNING_MESSAGE,

Line 122: pa_fp_gen_amount_utils.fp_debug

118: X_MSG_COUNT => X_MSG_COUNT,
119: X_MSG_DATA => X_MSG_DATA );
120:
121: IF p_pa_debug_mode = 'Y' THEN
122: pa_fp_gen_amount_utils.fp_debug
123: ( p_msg => 'Status after calling
124: pa_fp_gen_amount_utils.validate_support_cases: '
125: ||x_return_status,
126: p_module_name => l_module_name,

Line 124: pa_fp_gen_amount_utils.validate_support_cases: '

120:
121: IF p_pa_debug_mode = 'Y' THEN
122: pa_fp_gen_amount_utils.fp_debug
123: ( p_msg => 'Status after calling
124: pa_fp_gen_amount_utils.validate_support_cases: '
125: ||x_return_status,
126: p_module_name => l_module_name,
127: p_log_level => 5 );
128: END IF;

Line 155: pa_fp_gen_amount_utils.fp_debug

151: INTO l_record_version_number
152: FROM pa_budget_versions
153: WHERE budget_version_id = p_budget_version_id;
154: IF p_pa_debug_mode = 'Y' THEN
155: pa_fp_gen_amount_utils.fp_debug
156: (p_called_mode => p_called_mode,
157: p_msg => 'Before calling pa_fin_plan_pvt.lock_unlock_version',
158: p_module_name => l_module_name,
159: p_log_level => 5);

Line 171: pa_fp_gen_amount_utils.fp_debug

167: x_return_status => x_return_status,
168: x_msg_count => x_msg_count,
169: x_msg_data => x_msg_data);
170: IF p_pa_debug_mode = 'Y' THEN
171: pa_fp_gen_amount_utils.fp_debug
172: (p_called_mode => p_called_mode,
173: p_msg => 'Status after calling pa_fin_plan_pvt.lock_unlock_version:'
174: ||x_return_status,
175: p_module_name => l_module_name,

Line 198: pa_fp_gen_amount_utils.fp_debug

194: locking the main budget table */
195:
196: --Calling the acquire_locks_for_copy_actual api
197: IF p_pa_debug_mode = 'Y' THEN
198: pa_fp_gen_amount_utils.fp_debug
199: (p_called_mode => p_called_mode,
200: p_msg => 'Before calling
201: pa_fp_copy_from_pkg.acquire_locks_for_copy_actual',
202: p_module_name => l_module_name,

Line 221: pa_fp_gen_amount_utils.fp_debug

217: END IF;
218: RETURN;
219: END IF;
220: IF p_pa_debug_mode = 'Y' THEN
221: pa_fp_gen_amount_utils.fp_debug
222: (p_called_mode => p_called_mode,
223: p_msg => 'Status after calling
224: pa_fp_copy_from_pkg.acquire_locks_for_copy_actual: '
225: ||x_return_status,

Line 242: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

238:
239: -- IPM: New Entity ER ------------------------------------------
240: -- Call the maintenance api in DELETE mode
241: IF p_pa_debug_mode = 'Y' THEN
242: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
243: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
244: || 'MAINTAIN_DATA',
245: P_CALLED_MODE => p_called_mode,
246: P_MODULE_NAME => l_module_name,

Line 259: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

255: X_RETURN_STATUS => x_return_status,
256: X_MSG_COUNT => x_msg_count,
257: X_MSG_DATA => x_msg_data );
258: IF p_pa_debug_mode = 'Y' THEN
259: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
260: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
261: || 'MAINTAIN_DATA: ' || x_return_status,
262: P_CALLED_MODE => p_called_mode,
263: P_MODULE_NAME => l_module_name,

Line 313: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

309: 'Y' );
310:
311: -- Call the maintenance api in DELETE mode
312: IF p_pa_debug_mode = 'Y' THEN
313: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
314: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
315: || 'MAINTAIN_DATA',
316: P_CALLED_MODE => p_called_mode,
317: P_MODULE_NAME => l_module_name,

Line 330: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

326: X_RETURN_STATUS => x_return_status,
327: X_MSG_COUNT => x_msg_count,
328: X_MSG_DATA => x_msg_data );
329: IF p_pa_debug_mode = 'Y' THEN
330: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
331: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
332: || 'MAINTAIN_DATA: ' || x_return_status,
333: P_CALLED_MODE => p_called_mode,
334: P_MODULE_NAME => l_module_name,

Line 352: pa_fp_gen_amount_utils.fp_debug

348: IF l_fp_cols_rec.x_gen_src_code = 'RESOURCE_SCHEDULE' THEN
349: IF l_fp_cols_rec.x_version_type = 'REVENUE'
350: AND l_rev_gen_method = 'C' THEN
351: IF p_pa_debug_mode = 'Y' THEN
352: pa_fp_gen_amount_utils.fp_debug
353: (p_called_mode => p_called_mode,
354: p_msg => 'Before calling
355: pa_fp_gen_budget_amt_pub.gen_rev_bdgt_amt_res_sch_wrp',
356: p_module_name => l_module_name,

Line 387: pa_fp_gen_amount_utils.fp_debug

383: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
384: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
385: END IF;
386: IF p_pa_debug_mode = 'Y' THEN
387: pa_fp_gen_amount_utils.fp_debug
388: (p_called_mode => p_called_mode,
389: p_msg => 'Status after calling pa_fp_gen_budget_amt_pub.'||
390: 'gen_rev_bdgt_amt_res_sch_wrp:'||x_return_status,
391: p_module_name => l_module_name,

Line 397: pa_fp_gen_amount_utils.fp_debug

393: END IF;
394: ELSE
395: /* Calling Resource Schedule API */
396: IF p_pa_debug_mode = 'Y' THEN
397: pa_fp_gen_amount_utils.fp_debug
398: (p_called_mode => p_called_mode,
399: p_msg => 'Before calling
400: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
401: p_module_name => l_module_name,

Line 431: pa_fp_gen_amount_utils.fp_debug

427: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
428: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
429: END IF;
430: IF p_pa_debug_mode = 'Y' THEN
431: pa_fp_gen_amount_utils.fp_debug
432: (p_called_mode => p_called_mode,
433: p_msg => 'Status after calling
434: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '
435: ||x_return_status,

Line 448: pa_fp_gen_amount_utils.fp_debug

444: IF l_fp_cols_rec.x_version_type = 'REVENUE'
445: AND l_rev_gen_method = 'C'
446: AND l_wp_track_cost_flag <> 'Y' THEN
447: IF p_pa_debug_mode = 'Y' THEN
448: pa_fp_gen_amount_utils.fp_debug
449: (p_called_mode => p_called_mode,
450: p_msg => 'Before calling
451: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt',
452: p_module_name => l_module_name,

Line 479: pa_fp_gen_amount_utils.fp_debug

475: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
476: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
477: END IF;
478: IF p_pa_debug_mode = 'Y' THEN
479: pa_fp_gen_amount_utils.fp_debug
480: (p_called_mode => p_called_mode,
481: p_msg => 'Status after calling
482: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt: '
483: ||x_return_status,

Line 489: pa_fp_gen_amount_utils.fp_debug

485: p_log_level => 5);
486: END IF;
487: ELSE
488: IF p_pa_debug_mode = 'Y' THEN
489: pa_fp_gen_amount_utils.fp_debug
490: (p_called_mode => p_called_mode,
491: p_msg => 'Before calling
492: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt',
493: p_module_name => l_module_name,

Line 521: pa_fp_gen_amount_utils.fp_debug

517: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
518: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
519: END IF;
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 => 'Status after calling
524: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt: '
525: ||x_return_status,

Line 535: pa_fp_gen_amount_utils.fp_debug

531:
532: IF l_fp_cols_rec.x_gen_incl_open_comm_flag = 'Y' THEN
533: /* Calling Commitment API*/
534: IF p_pa_debug_mode = 'Y' THEN
535: pa_fp_gen_amount_utils.fp_debug
536: (p_called_mode => p_called_mode,
537: p_msg => 'Before calling
538: pa_fp_gen_commitment_amounts.gen_commitment_amounts',
539: p_module_name => l_module_name,

Line 556: pa_fp_gen_amount_utils.fp_debug

552: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
553: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
554: END IF;
555: IF p_pa_debug_mode = 'Y' THEN
556: pa_fp_gen_amount_utils.fp_debug
557: (p_called_mode => p_called_mode,
558: p_msg =>'Status after calling
559: pa_fp_gen_commitment_amounts.gen_commitment_amounts: '
560: ||x_return_status,

Line 596: pa_fp_gen_amount_utils.fp_debug

592: IF l_fp_cols_rec.x_version_type = 'ALL' AND
593: l_fp_cols_rec.x_gen_src_code <> 'RESOURCE_SCHEDULE' THEN
594: /* Calling the currency conversion API*/
595: IF p_pa_debug_mode = 'Y' THEN
596: pa_fp_gen_amount_utils.fp_debug
597: (p_called_mode => p_called_mode,
598: p_msg => 'Before calling
599: pa_fp_multi_currency_pkg.convert_txn_currency',
600: p_module_name => l_module_name,

Line 614: pa_fp_gen_amount_utils.fp_debug

610: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
611: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
612: END IF;
613: IF p_pa_debug_mode = 'Y' THEN
614: pa_fp_gen_amount_utils.fp_debug
615: (p_called_mode => p_called_mode,
616: p_msg => 'Status after calling
617: pa_fp_multi_currency_pkg.convert_txn_currency: '
618: ||x_return_status,

Line 636: pa_fp_gen_amount_utils.fp_debug

632: -- care of this already.
633:
634: /* Calling gen cost based revenue api */
635: IF p_pa_debug_mode = 'Y' THEN
636: pa_fp_gen_amount_utils.fp_debug
637: (p_called_mode => p_called_mode,
638: p_msg => 'Before calling
639: pa_fp_rev_gen_pub.gen_cost_based_revenue',
640: p_module_name => l_module_name,

Line 653: pa_fp_gen_amount_utils.fp_debug

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

Line 667: pa_fp_gen_amount_utils.fp_debug

663: /* Calling include_change_document_wrp api */
664: IF l_fp_cols_rec.x_gen_incl_change_doc_flag = 'Y' THEN
665: IF l_fp_cols_rec.x_gen_src_code = 'FINANCIAL_PLAN' THEN
666: IF p_pa_debug_mode = 'Y' THEN
667: pa_fp_gen_amount_utils.fp_debug
668: (p_called_mode => p_called_mode,
669: p_msg => 'Before calling
670: pa_fp_ci_merge.copy_merged_ctrl_items',
671: p_module_name => l_module_name,

Line 686: pa_fp_gen_amount_utils.fp_debug

682: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
683: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
684: END IF;
685: IF p_pa_debug_mode = 'Y' THEN
686: pa_fp_gen_amount_utils.fp_debug
687: (p_called_mode => p_called_mode,
688: p_msg => 'Status after calling
689: pa_fp_ci_merge.copy_merged_ctrl_items: '
690: ||x_return_status,

Line 697: pa_fp_gen_amount_utils.fp_debug

693: END IF;
694: END IF;
695:
696: IF p_pa_debug_mode = 'Y' THEN
697: pa_fp_gen_amount_utils.fp_debug
698: (p_called_mode => p_called_mode,
699: p_msg => 'Before calling PA_FP_GEN_PUB.include_change_document_wrp',
700: p_module_name => l_module_name,
701: p_log_level => 5);

Line 714: pa_fp_gen_amount_utils.fp_debug

710: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
711: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
712: END IF;
713: IF p_pa_debug_mode = 'Y' THEN
714: pa_fp_gen_amount_utils.fp_debug
715: (p_called_mode => p_called_mode,
716: p_msg => 'Status after calling PA_FP_GEN_PUB.include_change_document_wrp: '
717: ||x_return_status,
718: p_module_name => l_module_name,

Line 732: pa_fp_gen_amount_utils.fp_debug

728: AND (l_rev_gen_method = 'E'
729: OR l_fp_cols_rec.x_gen_incl_bill_event_flag = 'Y') THEN
730: /* Calling Billing Events API */
731: IF p_pa_debug_mode = 'Y' THEN
732: pa_fp_gen_amount_utils.fp_debug
733: (p_called_mode => p_called_mode,
734: p_msg => 'Before calling
735: pa_fp_gen_billing_amounts.gen_billing_amounts',
736: p_module_name => l_module_name,

Line 753: pa_fp_gen_amount_utils.fp_debug

749: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
750: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
751: END IF;
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 => 'Status after calling
756: pa_fp_gen_billing_amounts.gen_billing_amounts: '
757: ||x_return_status,

Line 765: pa_fp_gen_amount_utils.fp_debug

761: END IF;
762:
763: IF l_fp_cols_rec.x_version_type = 'REVENUE' THEN
764: IF p_pa_debug_mode = 'Y' THEN
765: pa_fp_gen_amount_utils.fp_debug
766: (p_called_mode => p_called_mode,
767: p_msg => 'Before calling
768: pa_fp_gen_budget_amt_pub.reset_cost_amounts',
769: p_module_name => l_module_name,

Line 782: pa_fp_gen_amount_utils.fp_debug

778: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
779: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
780: END IF;
781: IF p_pa_debug_mode = 'Y' THEN
782: pa_fp_gen_amount_utils.fp_debug
783: (p_called_mode => p_called_mode,
784: p_msg => 'Status after calling
785: pa_fp_gen_budget_amt_pub.reset_cost_amounts: '
786: ||x_return_status,

Line 792: pa_fp_gen_amount_utils.fp_debug

788: p_log_level => 5);
789: END IF;
790: END IF;
791: IF p_pa_debug_mode = 'Y' THEN
792: pa_fp_gen_amount_utils.fp_debug
793: (p_called_mode => p_called_mode,
794: p_msg => 'Before calling
795: pa_fp_gen_fcst_amt_pub1.maintain_budget_version',
796: p_module_name => l_module_name,

Line 811: pa_fp_gen_amount_utils.fp_debug

807: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
808: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
809: END IF;
810: IF p_pa_debug_mode = 'Y' THEN
811: pa_fp_gen_amount_utils.fp_debug
812: (p_called_mode => p_called_mode,
813: p_msg => 'Status after calling
814: pa_fp_gen_fcst_amt_pub1.maintain_budget_version: '
815: ||x_return_status,

Line 902: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

898: planning level is Resource Schedule */
899: PROCEDURE GENERATE_BUDGET_AMT_RES_SCH
900: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
901: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
902: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
903: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
904: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
905: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
906: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 1833: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1829: l_bill_rate_flag PA_FIN_PLAN_AMOUNT_SETS.BILL_RATE_FLAG%TYPE;
1830: l_cost_rate_flag PA_FIN_PLAN_AMOUNT_SETS.COST_RATE_FLAG%TYPE;
1831: l_burden_rate_flag PA_FIN_PLAN_AMOUNT_SETS.BURDEN_RATE_FLAG%TYPE;
1832:
1833: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1834:
1835: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1836: l_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1837: l_total_plan_quantity number;

Line 2327: pa_fp_gen_amount_utils.fp_debug

2323: END LOOP;
2324:
2325: --hr_utility.trace('l_proj_assignment_id.count:'||l_proj_assignment_id.count);
2326: IF p_pa_debug_mode = 'Y' THEN
2327: pa_fp_gen_amount_utils.fp_debug
2328: (p_called_mode => p_called_mode,
2329: p_msg => 'l_proj_assignment_id.count:'||l_proj_assignment_id.count,
2330: p_module_name => l_module_name,
2331: p_log_level => 5);

Line 2398: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

2394: l_TXN_RBS_ELEMENT_ID_tab(bb) := null;
2395: END LOOP;
2396:
2397: IF P_PA_DEBUG_MODE = 'Y' THEN
2398: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2399: P_MSG => 'Before calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS',
2400: P_MODULE_NAME => l_module_name);
2401: END IF;
2402: PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS (

Line 2452: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

2448: X_RETURN_STATUS => x_return_status,
2449: X_MSG_COUNT => x_msg_count,
2450: X_MSG_DATA => x_msg_data );
2451: IF P_PA_DEBUG_MODE = 'Y' THEN
2452: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2453: P_MSG => 'After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||
2454: x_return_status,
2455: P_MODULE_NAME => l_module_name);
2456: END IF;

Line 2476: pa_fp_gen_amount_utils.fp_debug

2472:
2473: SELECT count(*) INTO l_count
2474: FROM PA_RES_LIST_MAP_TMP4;
2475: IF p_pa_debug_mode = 'Y' THEN
2476: pa_fp_gen_amount_utils.fp_debug
2477: (p_called_mode => p_called_mode,
2478: p_msg => 'After calling pa_resource_mapping.map_resource_list,'||
2479: 'pa_res_list_map_tmp4.count has '||l_count||' rows',
2480: p_module_name => l_module_name,

Line 2487: pa_fp_gen_amount_utils.fp_debug

2483:
2484:
2485: /* Calling the API to get the resource_assignment_id */
2486: IF p_pa_debug_mode = 'Y' THEN
2487: pa_fp_gen_amount_utils.fp_debug
2488: (p_called_mode => p_called_mode,
2489: p_msg => 'Before calling
2490: pa_fp_gen_budget_amt_pub.create_res_asg',
2491: p_module_name => l_module_name,

Line 2508: pa_fp_gen_amount_utils.fp_debug

2504: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2505: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2506: END IF;
2507: IF p_pa_debug_mode = 'Y' THEN
2508: pa_fp_gen_amount_utils.fp_debug
2509: (p_called_mode => p_called_mode,
2510: p_msg => 'Status after calling
2511: pa_fp_gen_budget_amt_pub.create_res_asg: '
2512: ||x_return_status,

Line 2520: pa_fp_gen_amount_utils.fp_debug

2516:
2517: /* Calling the API to update the tmp4
2518: table with resource_assignment_id */
2519: IF p_pa_debug_mode = 'Y' THEN
2520: pa_fp_gen_amount_utils.fp_debug
2521: (p_called_mode => p_called_mode,
2522: p_msg => 'Before calling
2523: pa_fp_gen_budget_amt_pub.update_res_asg',
2524: p_module_name => l_module_name,

Line 2540: pa_fp_gen_amount_utils.fp_debug

2536: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2537: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2538: END IF;
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 => 'Status after calling
2543: pa_fp_gen_budget_amt_pub.update_res_asg: '
2544: ||x_return_status,

Line 2580: pa_fp_gen_amount_utils.fp_debug

2576:
2577: --dbms_output.put_line('From tmp4, l_proj_assgn_id_tab:'||l_proj_assgn_id_tab.count
2578: -- ||';l_proj_res_assgn_id_tab.count:'||l_proj_res_assgn_id_tab.count);
2579: IF p_pa_debug_mode = 'Y' THEN
2580: pa_fp_gen_amount_utils.fp_debug
2581: (p_called_mode => p_called_mode,
2582: p_msg => 'From tmp4, l_proj_assgn_id_tab.count:'||l_proj_assgn_id_tab.count
2583: ||';l_proj_res_assgn_id_tab.count:'||l_proj_res_assgn_id_tab.count,
2584: p_module_name => l_module_name,

Line 2616: pa_fp_gen_amount_utils.fp_debug

2612: IF p_fp_cols_rec.x_version_type = 'ALL' AND
2613: ( l_bill_rate_ovrd_exists_flag = 'Y' OR l_rev_gen_method = 'C' ) THEN
2614:
2615: IF p_pa_debug_mode = 'Y' THEN
2616: pa_fp_gen_amount_utils.fp_debug
2617: (p_called_mode => p_called_mode,
2618: p_msg => 'Honoring bill rate override and call Rate API',
2619: p_module_name => l_module_name,
2620: p_log_level => 5);

Line 2630: pa_fp_gen_amount_utils.fp_debug

2626: --dbms_output.put_line('before cursor:l_proj_res_assgn_id_tab('||j
2627: -- ||'):'||l_proj_res_assgn_id_tab(j)
2628: -- ||';p_actuals_thru_date:'||p_actuals_thru_date);
2629: IF p_pa_debug_mode = 'Y' THEN
2630: pa_fp_gen_amount_utils.fp_debug
2631: (p_called_mode => p_called_mode,
2632: p_msg => 'before cursor:l_proj_assgn_id_tab('||j
2633: ||'):'||l_proj_assgn_id_tab(j)
2634: ||';p_actuals_thru_date:'||p_actuals_thru_date,

Line 2772: pa_fp_gen_amount_utils.fp_debug

2768: -- to different budget lines.)
2769: FOR k in 1..l_rt_start_date_tab.COUNT LOOP
2770:
2771: IF p_pa_debug_mode = 'Y' THEN
2772: pa_fp_gen_amount_utils.fp_debug
2773: (p_called_mode => p_called_mode,
2774: p_msg => 'inside FOR k in 1..l_rt_start_date_tab.COUNT LOOP ('||k
2775: ||'):'||l_rt_start_date_tab(k),
2776: p_module_name => l_module_name,

Line 2805: pa_fp_gen_amount_utils.fp_debug

2801: END IF;
2802:
2803: IF p_pa_debug_mode = 'Y' THEN
2804:
2805: pa_fp_gen_amount_utils.fp_debug
2806: (p_called_mode => p_called_mode,
2807: p_msg => 'BEFORE calling pa_plan_revenue.Get_planning_Rates',
2808: p_module_name => l_module_name,
2809: p_log_level => 5);

Line 2810: pa_fp_gen_amount_utils.fp_debug

2806: (p_called_mode => p_called_mode,
2807: p_msg => 'BEFORE calling pa_plan_revenue.Get_planning_Rates',
2808: p_module_name => l_module_name,
2809: p_log_level => 5);
2810: pa_fp_gen_amount_utils.fp_debug
2811: (p_called_mode => p_called_mode,
2812: p_msg => 'p_person_id:'||l_rt_person_id_tab(k),
2813: p_module_name => l_module_name,
2814: p_log_level => 5);

Line 2815: pa_fp_gen_amount_utils.fp_debug

2811: (p_called_mode => p_called_mode,
2812: p_msg => 'p_person_id:'||l_rt_person_id_tab(k),
2813: p_module_name => l_module_name,
2814: p_log_level => 5);
2815: pa_fp_gen_amount_utils.fp_debug
2816: (p_called_mode => p_called_mode,
2817: p_msg => 'p_job_id:'||l_rt_job_id_tab(k),
2818: p_module_name => l_module_name,
2819: p_log_level => 5);

Line 2820: pa_fp_gen_amount_utils.fp_debug

2816: (p_called_mode => p_called_mode,
2817: p_msg => 'p_job_id:'||l_rt_job_id_tab(k),
2818: p_module_name => l_module_name,
2819: p_log_level => 5);
2820: pa_fp_gen_amount_utils.fp_debug
2821: (p_called_mode => p_called_mode,
2822: p_msg => 'p_bill_job_grp_id:'||rate_rec.bill_job_group_id,
2823: p_module_name => l_module_name,
2824: p_log_level => 5);

Line 2825: pa_fp_gen_amount_utils.fp_debug

2821: (p_called_mode => p_called_mode,
2822: p_msg => 'p_bill_job_grp_id:'||rate_rec.bill_job_group_id,
2823: p_module_name => l_module_name,
2824: p_log_level => 5);
2825: pa_fp_gen_amount_utils.fp_debug
2826: (p_called_mode => p_called_mode,
2827: p_msg => 'p_resource_class:'||l_rt_res_class_code_tab(k),
2828: p_module_name => l_module_name,
2829: p_log_level => 5);

Line 2959: pa_fp_gen_amount_utils.fp_debug

2955: RAISE;
2956: END;
2957:
2958: IF p_pa_debug_mode = 'Y' THEN
2959: pa_fp_gen_amount_utils.fp_debug
2960: (p_called_mode => p_called_mode,
2961: p_msg => 'calling client extensions',
2962: p_module_name => l_module_name,
2963: p_log_level => 5);

Line 3111: pa_fp_gen_amount_utils.fp_debug

3107: IF x_cost_txn_curr_code <> l_Final_Txn_Currency_Code AND
3108: l_calculate_mode IN ('COST_REVENUE', 'COST') THEN
3109:
3110: IF p_pa_debug_mode = 'Y' THEN
3111: pa_fp_gen_amount_utils.fp_debug
3112: (p_called_mode => p_called_mode,
3113: p_msg => 'convert cost from '|| x_cost_txn_curr_code ||
3114: ' to '||l_Final_Txn_Currency_Code,
3115: p_module_name => l_module_name,

Line 3194: pa_fp_gen_amount_utils.fp_debug

3190: IF x_rev_txn_curr_code <> l_Final_Txn_Currency_Code AND
3191: l_calculate_mode IN ('COST_REVENUE', 'REVENUE') THEN
3192:
3193: IF p_pa_debug_mode = 'Y' THEN
3194: pa_fp_gen_amount_utils.fp_debug
3195: (p_called_mode => p_called_mode,
3196: p_msg => 'convert revenue from '|| x_rev_txn_curr_code ||
3197: ' to '||l_Final_Txn_Currency_Code,
3198: p_module_name => l_module_name,

Line 3274: pa_fp_gen_amount_utils.fp_debug

3270:
3271: l_insert_Txn_Currency_Code := x_cost_txn_curr_code; -- Bug 4615589
3272:
3273: IF p_pa_debug_mode = 'Y' THEN
3274: pa_fp_gen_amount_utils.fp_debug
3275: (p_called_mode => p_called_mode,
3276: p_msg => 'cost cur <> rev cur, convert revenue from '|| x_rev_txn_curr_code ||
3277: ' to '||l_insert_Txn_Currency_Code, -- Bug 4615589
3278: p_module_name => l_module_name,

Line 3346: pa_fp_gen_amount_utils.fp_debug

3342:
3343: END IF; -- ELSIF x_cost_txn_curr_code <> x_rev_txn_curr_code THEN
3344:
3345: IF p_pa_debug_mode = 'Y' THEN
3346: pa_fp_gen_amount_utils.fp_debug
3347: (p_called_mode => p_called_mode,
3348: p_msg => 'Populate temporary table (pa_fp_rollup_tmp) with rates and rejection code',
3349: p_module_name => l_module_name,
3350: p_log_level => 5);

Line 3351: pa_fp_gen_amount_utils.fp_debug

3347: (p_called_mode => p_called_mode,
3348: p_msg => 'Populate temporary table (pa_fp_rollup_tmp) with rates and rejection code',
3349: p_module_name => l_module_name,
3350: p_log_level => 5);
3351: pa_fp_gen_amount_utils.fp_debug
3352: (p_called_mode => p_called_mode,
3353: p_msg => 'resource assignment id:'||l_rt_res_assignment_id_tab(k),
3354: p_module_name => l_module_name,
3355: p_log_level => 5);

Line 3356: pa_fp_gen_amount_utils.fp_debug

3352: (p_called_mode => p_called_mode,
3353: p_msg => 'resource assignment id:'||l_rt_res_assignment_id_tab(k),
3354: p_module_name => l_module_name,
3355: p_log_level => 5);
3356: pa_fp_gen_amount_utils.fp_debug
3357: (p_called_mode => p_called_mode,
3358: p_msg => 'start date:'||l_rt_start_date_tab(k),
3359: p_module_name => l_module_name,
3360: p_log_level => 5);

Line 3361: pa_fp_gen_amount_utils.fp_debug

3357: (p_called_mode => p_called_mode,
3358: p_msg => 'start date:'||l_rt_start_date_tab(k),
3359: p_module_name => l_module_name,
3360: p_log_level => 5);
3361: pa_fp_gen_amount_utils.fp_debug
3362: (p_called_mode => p_called_mode,
3363: p_msg => 'txn currency code:'||l_insert_Txn_Currency_Code,
3364: p_module_name => l_module_name,
3365: p_log_level => 5);

Line 3439: pa_fp_gen_amount_utils.fp_debug

3435: -- currencies in the PA_FP_ROLLUP_TMP table instead of in the
3436: -- PA_BUDGET_LINES table.
3437:
3438: IF p_pa_debug_mode = 'Y' THEN
3439: pa_fp_gen_amount_utils.fp_debug
3440: (p_called_mode => p_called_mode,
3441: p_msg => 'Before calling
3442: pa_fp_multi_currency_pkg.convert_txn_currency',
3443: p_module_name => l_module_name,

Line 3457: pa_fp_gen_amount_utils.fp_debug

3453: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3454: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3455: END IF;
3456: IF p_pa_debug_mode = 'Y' THEN
3457: pa_fp_gen_amount_utils.fp_debug
3458: (p_called_mode => p_called_mode,
3459: p_msg => 'Status after calling
3460: pa_fp_multi_currency_pkg.convert_txn_currency: '
3461: ||x_return_status,

Line 3683: pa_fp_gen_amount_utils.fp_debug

3679:
3680: END LOOP; -- FOR m IN 1..l_rej_res_assignment_id_tab.COUNT LOOP
3681:
3682: IF p_pa_debug_mode = 'Y' THEN
3683: pa_fp_gen_amount_utils.fp_debug
3684: (p_called_mode => p_called_mode,
3685: p_msg => 'Group temp table data by res asgmt, txn cur and period. Insert into budget lines',
3686: p_module_name => l_module_name,
3687: p_log_level => 5);

Line 3923: pa_fp_gen_amount_utils.fp_debug

3919: --dbms_output.put_line('before cursor:l_proj_res_assgn_id_tab('||j
3920: -- ||'):'||l_proj_res_assgn_id_tab(j)
3921: -- ||';p_actuals_thru_date:'||p_actuals_thru_date);
3922: IF p_pa_debug_mode = 'Y' THEN
3923: pa_fp_gen_amount_utils.fp_debug
3924: (p_called_mode => p_called_mode,
3925: p_msg => 'before cursor:l_proj_assgn_id_tab('||j
3926: ||'):'||l_proj_assgn_id_tab(j)
3927: ||';p_actuals_thru_date:'||p_actuals_thru_date,

Line 4008: pa_fp_gen_amount_utils.fp_debug

4004: CLOSE FCST_NONE;
4005: END IF;
4006:
4007: IF p_pa_debug_mode = 'Y' THEN
4008: pa_fp_gen_amount_utils.fp_debug
4009: (p_called_mode => p_called_mode,
4010: p_msg => '==j=='||j
4011: ||';==l_rt_start_date_tab.count:'||l_rt_start_date_tab.count,
4012: p_module_name => l_module_name,

Line 4026: pa_fp_gen_amount_utils.fp_debug

4022: -- ||';l_proj_res_assgn_id_tab(j):'||l_proj_res_assgn_id_tab(j)
4023: -- ||';count:'||l_count
4024: -- ||';l_rt_start_date_tab.count:'||l_rt_start_date_tab.count);
4025: IF p_pa_debug_mode = 'Y' THEN
4026: pa_fp_gen_amount_utils.fp_debug
4027: (p_called_mode => p_called_mode,
4028: p_msg => '==j=='||j
4029: ||';l_proj_res_assgn_id_tab(j):'||l_proj_res_assgn_id_tab(j)
4030: ||';count:'||l_count

Line 4268: pa_fp_gen_amount_utils.fp_debug

4264: -- PJI rollup api is bypassed for increased performance.
4265:
4266: /* Calling the calculate API */
4267: IF p_pa_debug_mode = 'Y' THEN
4268: pa_fp_gen_amount_utils.fp_debug
4269: (p_called_mode => p_called_mode,
4270: p_msg => 'Before calling
4271: pa_fp_calc_plan_pkg.calculate',
4272: p_module_name => l_module_name,

Line 4325: pa_fp_gen_amount_utils.fp_debug

4321: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4322: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4323: END IF;
4324: IF p_pa_debug_mode = 'Y' THEN
4325: pa_fp_gen_amount_utils.fp_debug
4326: (p_called_mode => p_called_mode,
4327: p_msg => 'Status after calling
4328: pa_fp_calc_plan_pkg.calculate: '
4329: ||x_return_status,

Line 4400: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

4396: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
4397: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4398: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
4399: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
4400: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4401: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
4402: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4403: X_MSG_COUNT OUT NOCOPY NUMBER,
4404: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 4857: pa_fp_gen_amount_utils.fp_debug

4853: RETURN;
4854: END IF;
4855: IF P_PA_DEBUG_MODE = 'Y' THEN
4856: FOR i IN 1..l_res_list_member_id.count LOOP
4857: pa_fp_gen_amount_utils.fp_debug
4858: (p_msg => 'in res_asg4:@@rlm in cursor:'||l_res_list_member_id(i)
4859: ||'; @@task in cursor:'||l_task_id(i)
4860: ||';@@start date in cursor:'||l_start_date_tab(i)
4861: ||';@@end date in cursor:'||l_end_date_tab(i),

Line 5001: pa_fp_gen_amount_utils.fp_debug

4997: END LOOP;
4998:
4999: --Calling resource defualt API
5000: IF p_pa_debug_mode = 'Y' THEN
5001: pa_fp_gen_amount_utils.fp_debug
5002: (p_msg => 'Before calling
5003: pa_planning_resource_utils.get_resource_defaults',
5004: p_module_name => l_module_name,
5005: p_log_level => 5);

Line 5056: pa_fp_gen_amount_utils.fp_debug

5052: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
5053: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5054: END IF;
5055: IF p_pa_debug_mode = 'Y' THEN
5056: pa_fp_gen_amount_utils.fp_debug
5057: (p_msg => 'Status after calling
5058: pa_planning_resource_utils.get_resource_defaults'
5059: ||x_return_status,
5060: p_module_name => l_module_name,

Line 5172: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

5168: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5169: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5170: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
5171: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
5172: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5173: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
5174: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5175: X_MSG_COUNT OUT NOCOPY NUMBER,
5176: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 5355: pa_fp_gen_amount_utils.fp_debug

5351:
5352: --@@
5353: IF P_PA_DEBUG_MODE = 'Y' THEN
5354: for i in 1..l_res_assgn_id_tab.count loop
5355: pa_fp_gen_amount_utils.fp_debug
5356: (p_msg => 'within update when share partial and planning at lowest task i:'
5357: ||i||'; ra id in cursor:'||l_res_assgn_id_tab(i)
5358: ||';rlm id in cursor:'||l_rlm_id_tab(i)
5359: ||';task id in cursor:'||l_txn_task_id_tab(i)

Line 5482: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE

5478: FROM pa_budget_lines bl
5479: WHERE bl.resource_assignment_id = ra.resource_assignment_id
5480: AND rownum = 1 ));
5481: ELSIF p_fp_cols_rec.x_plan_class_code = 'FORECAST' THEN
5482: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE
5483: ( p_budget_version_id );
5484: DELETE FROM pa_res_list_map_tmp4 tmp
5485: WHERE EXISTS
5486: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1

Line 5640: pa_fp_gen_amount_utils.fp_debug

5636: DELETE FROM PA_BUDGET_LINES
5637: WHERE RESOURCE_ASSIGNMENT_ID = PX_DELETED_RES_ASG_ID_TAB(i);
5638:
5639: IF p_pa_debug_mode = 'Y' THEN
5640: pa_fp_gen_amount_utils.fp_debug
5641: (p_msg => 'Before calling
5642: pa_fp_rollup_pkg.rollup_budget_version',
5643: p_module_name => l_module_name,
5644: p_log_level => 5);

Line 5657: pa_fp_gen_amount_utils.fp_debug

5653: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
5654: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5655: END IF;
5656: IF p_pa_debug_mode = 'Y' THEN
5657: pa_fp_gen_amount_utils.fp_debug
5658: (p_msg => 'Status after calling
5659: pa_fp_rollup_pkg.rollup_budget_version: '
5660: ||x_return_status,
5661: p_module_name => l_module_name,

Line 5896: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

5892: ******************************************************************************/
5893: PROCEDURE INSERT_TXN_CURRENCY
5894: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5895: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5896: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5897: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5898: X_MSG_COUNT OUT NOCOPY NUMBER,
5899: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5900: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.INSERT_TXN_CURRENCY';

Line 5906: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

5902: l_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
5903: l_budget_version_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5904: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5905:
5906: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
5907: l_pc pa_budget_lines.txn_currency_code%type;
5908: l_pfc pa_budget_lines.txn_currency_code%type;
5909:
5910: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

Line 5934: pa_fp_gen_amount_utils.fp_debug

5930: OR l_fp_cols_rec.x_fin_plan_type_id is null
5931: OR p_project_id is null) THEN
5932:
5933: IF p_pa_debug_mode = 'Y' THEN
5934: pa_fp_gen_amount_utils.fp_debug
5935: (p_msg => 'Before calling
5936: pa_fp_gen_amount_utils.get_plan_version_dtls',
5937: p_module_name => l_module_name,
5938: p_log_level => 5);

Line 5936: pa_fp_gen_amount_utils.get_plan_version_dtls',

5932:
5933: IF p_pa_debug_mode = 'Y' THEN
5934: pa_fp_gen_amount_utils.fp_debug
5935: (p_msg => 'Before calling
5936: pa_fp_gen_amount_utils.get_plan_version_dtls',
5937: p_module_name => l_module_name,
5938: p_log_level => 5);
5939: END IF;
5940:

Line 5941: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

5937: p_module_name => l_module_name,
5938: p_log_level => 5);
5939: END IF;
5940:
5941: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
5942: (P_PROJECT_ID => P_PROJECT_ID,
5943: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
5944: X_FP_COLS_REC => l_fp_cols_rec,
5945: X_RETURN_STATUS => X_RETURN_STATUS,

Line 5953: pa_fp_gen_amount_utils.fp_debug

5949: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
5950: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5951: END IF;
5952: IF p_pa_debug_mode = 'Y' THEN
5953: pa_fp_gen_amount_utils.fp_debug
5954: (p_msg => 'Status after calling
5955: pa_fp_gen_amount_utils.get_plan_version_dtls: '
5956: ||x_return_status,
5957: p_module_name => l_module_name,

Line 5955: pa_fp_gen_amount_utils.get_plan_version_dtls: '

5951: END IF;
5952: IF p_pa_debug_mode = 'Y' THEN
5953: pa_fp_gen_amount_utils.fp_debug
5954: (p_msg => 'Status after calling
5955: pa_fp_gen_amount_utils.get_plan_version_dtls: '
5956: ||x_return_status,
5957: p_module_name => l_module_name,
5958: p_log_level => 5);
5959: END IF;

Line 6153: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

6149:
6150: PROCEDURE GEN_REV_BDGT_AMT_RES_SCH_WRP
6151: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
6152: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6153: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6154: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6155: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6156: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6157: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 6293: pa_fp_gen_amount_utils.fp_debug

6289: END IF;
6290:
6291:
6292: IF p_pa_debug_mode = 'Y' THEN
6293: pa_fp_gen_amount_utils.fp_debug
6294: (p_msg => 'Before calling
6295: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
6296: p_module_name => l_module_name,
6297: p_log_level => 5);

Line 6325: pa_fp_gen_amount_utils.fp_debug

6321: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
6322: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6323: END IF;
6324: IF p_pa_debug_mode = 'Y' THEN
6325: pa_fp_gen_amount_utils.fp_debug
6326: (p_msg => 'Status after calling
6327: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '
6328: ||x_return_status,
6329: p_module_name => l_module_name,

Line 6443: pa_fp_gen_amount_utils.fp_debug

6439: AND ra.resource_list_member_id = rlm.resource_list_member_id;
6440:
6441: FOR i IN 1..l_res_asg_id_tab.count LOOP
6442: IF p_pa_debug_mode = 'Y' THEN
6443: pa_fp_gen_amount_utils.fp_debug
6444: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
6445: p_module_name => l_module_name,
6446: p_log_level => 5);
6447: END IF;

Line 6526: pa_fp_gen_amount_utils.fp_debug

6522: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
6523: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6524: END IF;
6525: IF p_pa_debug_mode = 'Y' THEN
6526: pa_fp_gen_amount_utils.fp_debug
6527: (p_msg => 'Status after calling pa_plan_revenue.Get_planning_Rates'
6528: ||x_return_status,
6529: p_module_name => l_module_name,
6530: p_log_level => 5);

Line 6586: pa_fp_gen_amount_utils.fp_debug

6582: -- PJI rollup api is bypassed for increased performance.
6583:
6584: /* Calling the calculate API */
6585: IF p_pa_debug_mode = 'Y' THEN
6586: pa_fp_gen_amount_utils.fp_debug
6587: (p_called_mode => p_called_mode,
6588: p_msg => 'Before calling
6589: pa_fp_calc_plan_pkg.calculate',
6590: p_module_name => l_module_name,

Line 6636: pa_fp_gen_amount_utils.fp_debug

6632: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
6633: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6634: END IF;
6635: IF p_pa_debug_mode = 'Y' THEN
6636: pa_fp_gen_amount_utils.fp_debug
6637: (p_called_mode => p_called_mode,
6638: p_msg => 'Status after calling
6639: pa_fp_calc_plan_pkg.calculate: '
6640: ||x_return_status,

Line 6838: pa_fp_gen_amount_utils.fp_debug

6834: p_debug_mode => p_pa_debug_mode);
6835: END IF;
6836:
6837: IF p_pa_debug_mode = 'Y' THEN
6838: pa_fp_gen_amount_utils.fp_debug
6839: (p_called_mode => p_called_mode,
6840: p_msg => 'Before calling
6841: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt',
6842: p_module_name => l_module_name,

Line 6869: pa_fp_gen_amount_utils.fp_debug

6865: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
6866: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6867: END IF;
6868: IF p_pa_debug_mode = 'Y' THEN
6869: pa_fp_gen_amount_utils.fp_debug
6870: (p_called_mode => p_called_mode,
6871: p_msg => 'Status after calling pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt:'
6872: ||x_return_status,
6873: p_module_name => l_module_name,

Line 6987: pa_fp_gen_amount_utils.fp_debug

6983: AND ra.resource_list_member_id = rlm.resource_list_member_id;
6984:
6985: FOR i IN 1..l_res_asg_id_tab.count LOOP
6986: IF p_pa_debug_mode = 'Y' THEN
6987: pa_fp_gen_amount_utils.fp_debug
6988: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
6989: p_module_name => l_module_name,
6990: p_log_level => 5);
6991: END IF;

Line 7070: pa_fp_gen_amount_utils.fp_debug

7066: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7067: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7068: END IF;
7069: IF p_pa_debug_mode = 'Y' THEN
7070: pa_fp_gen_amount_utils.fp_debug
7071: (p_msg => 'Status after calling pa_plan_revenue.Get_planning_Rates'
7072: ||x_return_status,
7073: p_module_name => l_module_name,
7074: p_log_level => 5);

Line 7130: pa_fp_gen_amount_utils.fp_debug

7126: -- PJI rollup api is bypassed for increased performance.
7127:
7128: /* Calling the calculate API */
7129: IF p_pa_debug_mode = 'Y' THEN
7130: pa_fp_gen_amount_utils.fp_debug
7131: (p_called_mode => p_called_mode,
7132: p_msg => 'Before calling pa_fp_calc_plan_pkg.calculate',
7133: p_module_name => l_module_name,
7134: p_log_level => 5);

Line 7179: pa_fp_gen_amount_utils.fp_debug

7175: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7176: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7177: END IF;
7178: IF p_pa_debug_mode = 'Y' THEN
7179: pa_fp_gen_amount_utils.fp_debug
7180: (p_called_mode => p_called_mode,
7181: p_msg => 'Status after calling
7182: pa_fp_calc_plan_pkg.calculate: '
7183: ||x_return_status,