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

81: END IF;
82:
83: --Calling the get_plan_version_dtls api
84: IF p_pa_debug_mode = 'Y' THEN
85: pa_fp_gen_amount_utils.fp_debug
86: (p_called_mode => p_called_mode,
87: p_msg => 'Before calling
88: pa_fp_gen_amount_utils.get_plan_version_dtls',
89: p_module_name => l_module_name,

Line 88: pa_fp_gen_amount_utils.get_plan_version_dtls',

84: IF p_pa_debug_mode = 'Y' THEN
85: pa_fp_gen_amount_utils.fp_debug
86: (p_called_mode => p_called_mode,
87: p_msg => 'Before calling
88: pa_fp_gen_amount_utils.get_plan_version_dtls',
89: p_module_name => l_module_name,
90: p_log_level => 5);
91: END IF;
92: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 92: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

88: pa_fp_gen_amount_utils.get_plan_version_dtls',
89: p_module_name => l_module_name,
90: p_log_level => 5);
91: END IF;
92: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
93: (P_PROJECT_ID => P_PROJECT_ID,
94: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
95: X_FP_COLS_REC => l_fp_cols_rec,
96: X_RETURN_STATUS => X_RETURN_STATUS,

Line 100: pa_fp_gen_amount_utils.fp_debug

96: X_RETURN_STATUS => X_RETURN_STATUS,
97: X_MSG_COUNT => X_MSG_COUNT,
98: X_MSG_DATA => X_MSG_DATA);
99: IF p_pa_debug_mode = 'Y' THEN
100: pa_fp_gen_amount_utils.fp_debug
101: (p_called_mode => p_called_mode,
102: p_msg => 'Status after calling
103: pa_fp_gen_amount_utils.get_plan_version_dtls: '
104: ||x_return_status,

Line 103: pa_fp_gen_amount_utils.get_plan_version_dtls: '

99: IF p_pa_debug_mode = 'Y' THEN
100: pa_fp_gen_amount_utils.fp_debug
101: (p_called_mode => p_called_mode,
102: p_msg => 'Status after calling
103: pa_fp_gen_amount_utils.get_plan_version_dtls: '
104: ||x_return_status,
105: p_module_name => l_module_name,
106: p_log_level => 5);
107: END IF;

Line 117: pa_fp_gen_amount_utils.fp_debug

113: * For a list of unsupported cases, please see comments at the
114: * beginning of the VALIDATE_SUPPORT_CASES API (PAFPGAUB.pls) */
115:
116: IF p_pa_debug_mode = 'Y' THEN
117: pa_fp_gen_amount_utils.fp_debug
118: ( p_msg => 'Before calling
119: pa_fp_gen_amount_utils.validate_support_cases',
120: p_module_name => l_module_name,
121: p_log_level => 5 );

Line 119: pa_fp_gen_amount_utils.validate_support_cases',

115:
116: IF p_pa_debug_mode = 'Y' THEN
117: pa_fp_gen_amount_utils.fp_debug
118: ( p_msg => 'Before calling
119: pa_fp_gen_amount_utils.validate_support_cases',
120: p_module_name => l_module_name,
121: p_log_level => 5 );
122: END IF;
123:

Line 124: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (

120: p_module_name => l_module_name,
121: p_log_level => 5 );
122: END IF;
123:
124: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (
125: P_FP_COLS_REC_TGT => l_fp_cols_rec,
126: P_CHECK_SRC_ERRORS_FLAG => P_CHECK_SRC_ERRORS_FLAG,
127: P_CALLING_CONTEXT => P_CALLED_MODE, /* Added for ER 4391321 */
128: X_WARNING_MESSAGE => X_WARNING_MESSAGE,

Line 134: pa_fp_gen_amount_utils.fp_debug

130: X_MSG_COUNT => X_MSG_COUNT,
131: X_MSG_DATA => X_MSG_DATA );
132:
133: IF p_pa_debug_mode = 'Y' THEN
134: pa_fp_gen_amount_utils.fp_debug
135: ( p_msg => 'Status after calling
136: pa_fp_gen_amount_utils.validate_support_cases: '
137: ||x_return_status,
138: p_module_name => l_module_name,

Line 136: pa_fp_gen_amount_utils.validate_support_cases: '

132:
133: IF p_pa_debug_mode = 'Y' THEN
134: pa_fp_gen_amount_utils.fp_debug
135: ( p_msg => 'Status after calling
136: pa_fp_gen_amount_utils.validate_support_cases: '
137: ||x_return_status,
138: p_module_name => l_module_name,
139: p_log_level => 5 );
140: END IF;

Line 167: pa_fp_gen_amount_utils.fp_debug

163: INTO l_record_version_number
164: FROM pa_budget_versions
165: WHERE budget_version_id = p_budget_version_id;
166: IF p_pa_debug_mode = 'Y' THEN
167: pa_fp_gen_amount_utils.fp_debug
168: (p_called_mode => p_called_mode,
169: p_msg => 'Before calling pa_fin_plan_pvt.lock_unlock_version',
170: p_module_name => l_module_name,
171: p_log_level => 5);

Line 183: pa_fp_gen_amount_utils.fp_debug

179: x_return_status => x_return_status,
180: x_msg_count => x_msg_count,
181: x_msg_data => x_msg_data);
182: IF p_pa_debug_mode = 'Y' THEN
183: pa_fp_gen_amount_utils.fp_debug
184: (p_called_mode => p_called_mode,
185: p_msg => 'Status after calling pa_fin_plan_pvt.lock_unlock_version:'
186: ||x_return_status,
187: p_module_name => l_module_name,

Line 210: pa_fp_gen_amount_utils.fp_debug

206: locking the main budget table */
207:
208: --Calling the acquire_locks_for_copy_actual api
209: IF p_pa_debug_mode = 'Y' THEN
210: pa_fp_gen_amount_utils.fp_debug
211: (p_called_mode => p_called_mode,
212: p_msg => 'Before calling
213: pa_fp_copy_from_pkg.acquire_locks_for_copy_actual',
214: p_module_name => l_module_name,

Line 233: pa_fp_gen_amount_utils.fp_debug

229: END IF;
230: RETURN;
231: END IF;
232: IF p_pa_debug_mode = 'Y' THEN
233: pa_fp_gen_amount_utils.fp_debug
234: (p_called_mode => p_called_mode,
235: p_msg => 'Status after calling
236: pa_fp_copy_from_pkg.acquire_locks_for_copy_actual: '
237: ||x_return_status,

Line 254: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

250:
251: -- IPM: New Entity ER ------------------------------------------
252: -- Call the maintenance api in DELETE mode
253: IF p_pa_debug_mode = 'Y' THEN
254: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
255: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
256: || 'MAINTAIN_DATA',
257: P_CALLED_MODE => p_called_mode,
258: P_MODULE_NAME => l_module_name,

Line 271: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

267: X_RETURN_STATUS => x_return_status,
268: X_MSG_COUNT => x_msg_count,
269: X_MSG_DATA => x_msg_data );
270: IF p_pa_debug_mode = 'Y' THEN
271: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
272: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
273: || 'MAINTAIN_DATA: ' || x_return_status,
274: P_CALLED_MODE => p_called_mode,
275: P_MODULE_NAME => l_module_name,

Line 325: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

321: 'Y' );
322:
323: -- Call the maintenance api in DELETE mode
324: IF p_pa_debug_mode = 'Y' THEN
325: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
326: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
327: || 'MAINTAIN_DATA',
328: P_CALLED_MODE => p_called_mode,
329: P_MODULE_NAME => l_module_name,

Line 342: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

338: X_RETURN_STATUS => x_return_status,
339: X_MSG_COUNT => x_msg_count,
340: X_MSG_DATA => x_msg_data );
341: IF p_pa_debug_mode = 'Y' THEN
342: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
343: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
344: || 'MAINTAIN_DATA: ' || x_return_status,
345: P_CALLED_MODE => p_called_mode,
346: P_MODULE_NAME => l_module_name,

Line 364: pa_fp_gen_amount_utils.fp_debug

360: IF l_fp_cols_rec.x_gen_src_code = 'RESOURCE_SCHEDULE' THEN
361: IF l_fp_cols_rec.x_version_type = 'REVENUE'
362: AND l_rev_gen_method = 'C' THEN
363: IF p_pa_debug_mode = 'Y' THEN
364: pa_fp_gen_amount_utils.fp_debug
365: (p_called_mode => p_called_mode,
366: p_msg => 'Before calling
367: pa_fp_gen_budget_amt_pub.gen_rev_bdgt_amt_res_sch_wrp',
368: p_module_name => l_module_name,

Line 399: pa_fp_gen_amount_utils.fp_debug

395: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
396: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
397: END IF;
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 => 'Status after calling pa_fp_gen_budget_amt_pub.'||
402: 'gen_rev_bdgt_amt_res_sch_wrp:'||x_return_status,
403: p_module_name => l_module_name,

Line 409: pa_fp_gen_amount_utils.fp_debug

405: END IF;
406: ELSE
407: /* Calling Resource Schedule API */
408: IF p_pa_debug_mode = 'Y' THEN
409: pa_fp_gen_amount_utils.fp_debug
410: (p_called_mode => p_called_mode,
411: p_msg => 'Before calling
412: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
413: p_module_name => l_module_name,

Line 443: pa_fp_gen_amount_utils.fp_debug

439: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
440: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
441: END IF;
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 => 'Status after calling
446: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '
447: ||x_return_status,

Line 460: pa_fp_gen_amount_utils.fp_debug

456: IF l_fp_cols_rec.x_version_type = 'REVENUE'
457: AND l_rev_gen_method = 'C'
458: AND l_wp_track_cost_flag <> 'Y' THEN
459: IF p_pa_debug_mode = 'Y' THEN
460: pa_fp_gen_amount_utils.fp_debug
461: (p_called_mode => p_called_mode,
462: p_msg => 'Before calling
463: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt',
464: p_module_name => l_module_name,

Line 491: pa_fp_gen_amount_utils.fp_debug

487: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
488: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
489: END IF;
490: IF p_pa_debug_mode = 'Y' THEN
491: pa_fp_gen_amount_utils.fp_debug
492: (p_called_mode => p_called_mode,
493: p_msg => 'Status after calling
494: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt: '
495: ||x_return_status,

Line 501: pa_fp_gen_amount_utils.fp_debug

497: p_log_level => 5);
498: END IF;
499: ELSE
500: IF p_pa_debug_mode = 'Y' THEN
501: pa_fp_gen_amount_utils.fp_debug
502: (p_called_mode => p_called_mode,
503: p_msg => 'Before calling
504: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt',
505: p_module_name => l_module_name,

Line 533: pa_fp_gen_amount_utils.fp_debug

529: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
530: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
531: END IF;
532: IF p_pa_debug_mode = 'Y' THEN
533: pa_fp_gen_amount_utils.fp_debug
534: (p_called_mode => p_called_mode,
535: p_msg => 'Status after calling
536: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt: '
537: ||x_return_status,

Line 547: pa_fp_gen_amount_utils.fp_debug

543:
544: IF l_fp_cols_rec.x_gen_incl_open_comm_flag = 'Y' THEN
545: /* Calling Commitment API*/
546: IF p_pa_debug_mode = 'Y' THEN
547: pa_fp_gen_amount_utils.fp_debug
548: (p_called_mode => p_called_mode,
549: p_msg => 'Before calling
550: pa_fp_gen_commitment_amounts.gen_commitment_amounts',
551: p_module_name => l_module_name,

Line 568: pa_fp_gen_amount_utils.fp_debug

564: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
565: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
566: END IF;
567: IF p_pa_debug_mode = 'Y' THEN
568: pa_fp_gen_amount_utils.fp_debug
569: (p_called_mode => p_called_mode,
570: p_msg =>'Status after calling
571: pa_fp_gen_commitment_amounts.gen_commitment_amounts: '
572: ||x_return_status,

Line 608: pa_fp_gen_amount_utils.fp_debug

604: IF l_fp_cols_rec.x_version_type = 'ALL' AND
605: l_fp_cols_rec.x_gen_src_code <> 'RESOURCE_SCHEDULE' THEN
606: /* Calling the currency conversion API*/
607: IF p_pa_debug_mode = 'Y' THEN
608: pa_fp_gen_amount_utils.fp_debug
609: (p_called_mode => p_called_mode,
610: p_msg => 'Before calling
611: pa_fp_multi_currency_pkg.convert_txn_currency',
612: p_module_name => l_module_name,

Line 626: pa_fp_gen_amount_utils.fp_debug

622: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
623: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
624: END IF;
625: IF p_pa_debug_mode = 'Y' THEN
626: pa_fp_gen_amount_utils.fp_debug
627: (p_called_mode => p_called_mode,
628: p_msg => 'Status after calling
629: pa_fp_multi_currency_pkg.convert_txn_currency: '
630: ||x_return_status,

Line 648: pa_fp_gen_amount_utils.fp_debug

644: -- care of this already.
645:
646: /* Calling gen cost based revenue api */
647: IF p_pa_debug_mode = 'Y' THEN
648: pa_fp_gen_amount_utils.fp_debug
649: (p_called_mode => p_called_mode,
650: p_msg => 'Before calling
651: pa_fp_rev_gen_pub.gen_cost_based_revenue',
652: p_module_name => l_module_name,

Line 665: pa_fp_gen_amount_utils.fp_debug

661: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
662: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
663: END IF;
664: IF p_pa_debug_mode = 'Y' THEN
665: pa_fp_gen_amount_utils.fp_debug
666: (p_called_mode => p_called_mode,
667: p_msg => 'Status after calling
668: pa_fp_rev_gen_pub.gen_cost_based_revenue: '
669: ||x_return_status,

Line 679: pa_fp_gen_amount_utils.fp_debug

675: /* Calling include_change_document_wrp api */
676: IF l_fp_cols_rec.x_gen_incl_change_doc_flag = 'Y' THEN
677: IF l_fp_cols_rec.x_gen_src_code = 'FINANCIAL_PLAN' THEN
678: IF p_pa_debug_mode = 'Y' THEN
679: pa_fp_gen_amount_utils.fp_debug
680: (p_called_mode => p_called_mode,
681: p_msg => 'Before calling
682: pa_fp_ci_merge.copy_merged_ctrl_items',
683: p_module_name => l_module_name,

Line 698: pa_fp_gen_amount_utils.fp_debug

694: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
695: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
696: END IF;
697: IF p_pa_debug_mode = 'Y' THEN
698: pa_fp_gen_amount_utils.fp_debug
699: (p_called_mode => p_called_mode,
700: p_msg => 'Status after calling
701: pa_fp_ci_merge.copy_merged_ctrl_items: '
702: ||x_return_status,

Line 709: pa_fp_gen_amount_utils.fp_debug

705: END IF;
706: END IF;
707:
708: IF p_pa_debug_mode = 'Y' THEN
709: pa_fp_gen_amount_utils.fp_debug
710: (p_called_mode => p_called_mode,
711: p_msg => 'Before calling PA_FP_GEN_PUB.include_change_document_wrp',
712: p_module_name => l_module_name,
713: p_log_level => 5);

Line 726: pa_fp_gen_amount_utils.fp_debug

722: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
723: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
724: END IF;
725: IF p_pa_debug_mode = 'Y' THEN
726: pa_fp_gen_amount_utils.fp_debug
727: (p_called_mode => p_called_mode,
728: p_msg => 'Status after calling PA_FP_GEN_PUB.include_change_document_wrp: '
729: ||x_return_status,
730: p_module_name => l_module_name,

Line 744: pa_fp_gen_amount_utils.fp_debug

740: AND (l_rev_gen_method = 'E'
741: OR l_fp_cols_rec.x_gen_incl_bill_event_flag = 'Y') THEN
742: /* Calling Billing Events API */
743: IF p_pa_debug_mode = 'Y' THEN
744: pa_fp_gen_amount_utils.fp_debug
745: (p_called_mode => p_called_mode,
746: p_msg => 'Before calling
747: pa_fp_gen_billing_amounts.gen_billing_amounts',
748: p_module_name => l_module_name,

Line 765: pa_fp_gen_amount_utils.fp_debug

761: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
762: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
763: END IF;
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 => 'Status after calling
768: pa_fp_gen_billing_amounts.gen_billing_amounts: '
769: ||x_return_status,

Line 777: pa_fp_gen_amount_utils.fp_debug

773: END IF;
774:
775: IF l_fp_cols_rec.x_version_type = 'REVENUE' THEN
776: IF p_pa_debug_mode = 'Y' THEN
777: pa_fp_gen_amount_utils.fp_debug
778: (p_called_mode => p_called_mode,
779: p_msg => 'Before calling
780: pa_fp_gen_budget_amt_pub.reset_cost_amounts',
781: p_module_name => l_module_name,

Line 794: pa_fp_gen_amount_utils.fp_debug

790: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
791: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
792: END IF;
793: IF p_pa_debug_mode = 'Y' THEN
794: pa_fp_gen_amount_utils.fp_debug
795: (p_called_mode => p_called_mode,
796: p_msg => 'Status after calling
797: pa_fp_gen_budget_amt_pub.reset_cost_amounts: '
798: ||x_return_status,

Line 804: pa_fp_gen_amount_utils.fp_debug

800: p_log_level => 5);
801: END IF;
802: END IF;
803: IF p_pa_debug_mode = 'Y' THEN
804: pa_fp_gen_amount_utils.fp_debug
805: (p_called_mode => p_called_mode,
806: p_msg => 'Before calling
807: pa_fp_gen_fcst_amt_pub1.maintain_budget_version',
808: p_module_name => l_module_name,

Line 823: pa_fp_gen_amount_utils.fp_debug

819: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
820: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
821: END IF;
822: IF p_pa_debug_mode = 'Y' THEN
823: pa_fp_gen_amount_utils.fp_debug
824: (p_called_mode => p_called_mode,
825: p_msg => 'Status after calling
826: pa_fp_gen_fcst_amt_pub1.maintain_budget_version: '
827: ||x_return_status,

Line 914: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

910: planning level is Resource Schedule */
911: PROCEDURE GENERATE_BUDGET_AMT_RES_SCH
912: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
913: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
914: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
915: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
916: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
917: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
918: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 1845: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1841: l_bill_rate_flag PA_FIN_PLAN_AMOUNT_SETS.BILL_RATE_FLAG%TYPE;
1842: l_cost_rate_flag PA_FIN_PLAN_AMOUNT_SETS.COST_RATE_FLAG%TYPE;
1843: l_burden_rate_flag PA_FIN_PLAN_AMOUNT_SETS.BURDEN_RATE_FLAG%TYPE;
1844:
1845: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1846:
1847: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1848: l_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1849: l_total_plan_quantity number;

Line 2339: pa_fp_gen_amount_utils.fp_debug

2335: END LOOP;
2336:
2337: --hr_utility.trace('l_proj_assignment_id.count:'||l_proj_assignment_id.count);
2338: IF p_pa_debug_mode = 'Y' THEN
2339: pa_fp_gen_amount_utils.fp_debug
2340: (p_called_mode => p_called_mode,
2341: p_msg => 'l_proj_assignment_id.count:'||l_proj_assignment_id.count,
2342: p_module_name => l_module_name,
2343: p_log_level => 5);

Line 2410: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

2406: l_TXN_RBS_ELEMENT_ID_tab(bb) := null;
2407: END LOOP;
2408:
2409: IF P_PA_DEBUG_MODE = 'Y' THEN
2410: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2411: P_MSG => 'Before calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS',
2412: P_MODULE_NAME => l_module_name);
2413: END IF;
2414: PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS (

Line 2464: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

2460: X_RETURN_STATUS => x_return_status,
2461: X_MSG_COUNT => x_msg_count,
2462: X_MSG_DATA => x_msg_data );
2463: IF P_PA_DEBUG_MODE = 'Y' THEN
2464: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2465: P_MSG => 'After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||
2466: x_return_status,
2467: P_MODULE_NAME => l_module_name);
2468: END IF;

Line 2488: pa_fp_gen_amount_utils.fp_debug

2484:
2485: SELECT count(*) INTO l_count
2486: FROM PA_RES_LIST_MAP_TMP4;
2487: IF p_pa_debug_mode = 'Y' THEN
2488: pa_fp_gen_amount_utils.fp_debug
2489: (p_called_mode => p_called_mode,
2490: p_msg => 'After calling pa_resource_mapping.map_resource_list,'||
2491: 'pa_res_list_map_tmp4.count has '||l_count||' rows',
2492: p_module_name => l_module_name,

Line 2499: pa_fp_gen_amount_utils.fp_debug

2495:
2496:
2497: /* Calling the API to get the resource_assignment_id */
2498: IF p_pa_debug_mode = 'Y' THEN
2499: pa_fp_gen_amount_utils.fp_debug
2500: (p_called_mode => p_called_mode,
2501: p_msg => 'Before calling
2502: pa_fp_gen_budget_amt_pub.create_res_asg',
2503: p_module_name => l_module_name,

Line 2520: pa_fp_gen_amount_utils.fp_debug

2516: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2517: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2518: END IF;
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 => 'Status after calling
2523: pa_fp_gen_budget_amt_pub.create_res_asg: '
2524: ||x_return_status,

Line 2532: pa_fp_gen_amount_utils.fp_debug

2528:
2529: /* Calling the API to update the tmp4
2530: table with resource_assignment_id */
2531: IF p_pa_debug_mode = 'Y' THEN
2532: pa_fp_gen_amount_utils.fp_debug
2533: (p_called_mode => p_called_mode,
2534: p_msg => 'Before calling
2535: pa_fp_gen_budget_amt_pub.update_res_asg',
2536: p_module_name => l_module_name,

Line 2552: pa_fp_gen_amount_utils.fp_debug

2548: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2549: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2550: END IF;
2551: IF p_pa_debug_mode = 'Y' THEN
2552: pa_fp_gen_amount_utils.fp_debug
2553: (p_called_mode => p_called_mode,
2554: p_msg => 'Status after calling
2555: pa_fp_gen_budget_amt_pub.update_res_asg: '
2556: ||x_return_status,

Line 2592: pa_fp_gen_amount_utils.fp_debug

2588:
2589: --dbms_output.put_line('From tmp4, l_proj_assgn_id_tab:'||l_proj_assgn_id_tab.count
2590: -- ||';l_proj_res_assgn_id_tab.count:'||l_proj_res_assgn_id_tab.count);
2591: IF p_pa_debug_mode = 'Y' THEN
2592: pa_fp_gen_amount_utils.fp_debug
2593: (p_called_mode => p_called_mode,
2594: p_msg => 'From tmp4, l_proj_assgn_id_tab.count:'||l_proj_assgn_id_tab.count
2595: ||';l_proj_res_assgn_id_tab.count:'||l_proj_res_assgn_id_tab.count,
2596: p_module_name => l_module_name,

Line 2628: pa_fp_gen_amount_utils.fp_debug

2624: IF p_fp_cols_rec.x_version_type = 'ALL' AND
2625: ( l_bill_rate_ovrd_exists_flag = 'Y' OR l_rev_gen_method = 'C' ) THEN
2626:
2627: IF p_pa_debug_mode = 'Y' THEN
2628: pa_fp_gen_amount_utils.fp_debug
2629: (p_called_mode => p_called_mode,
2630: p_msg => 'Honoring bill rate override and call Rate API',
2631: p_module_name => l_module_name,
2632: p_log_level => 5);

Line 2642: pa_fp_gen_amount_utils.fp_debug

2638: --dbms_output.put_line('before cursor:l_proj_res_assgn_id_tab('||j
2639: -- ||'):'||l_proj_res_assgn_id_tab(j)
2640: -- ||';p_actuals_thru_date:'||p_actuals_thru_date);
2641: IF p_pa_debug_mode = 'Y' THEN
2642: pa_fp_gen_amount_utils.fp_debug
2643: (p_called_mode => p_called_mode,
2644: p_msg => 'before cursor:l_proj_assgn_id_tab('||j
2645: ||'):'||l_proj_assgn_id_tab(j)
2646: ||';p_actuals_thru_date:'||p_actuals_thru_date,

Line 2784: pa_fp_gen_amount_utils.fp_debug

2780: -- to different budget lines.)
2781: FOR k in 1..l_rt_start_date_tab.COUNT LOOP
2782:
2783: IF p_pa_debug_mode = 'Y' THEN
2784: pa_fp_gen_amount_utils.fp_debug
2785: (p_called_mode => p_called_mode,
2786: p_msg => 'inside FOR k in 1..l_rt_start_date_tab.COUNT LOOP ('||k
2787: ||'):'||l_rt_start_date_tab(k),
2788: p_module_name => l_module_name,

Line 2817: pa_fp_gen_amount_utils.fp_debug

2813: END IF;
2814:
2815: IF p_pa_debug_mode = 'Y' THEN
2816:
2817: pa_fp_gen_amount_utils.fp_debug
2818: (p_called_mode => p_called_mode,
2819: p_msg => 'BEFORE calling pa_plan_revenue.Get_planning_Rates',
2820: p_module_name => l_module_name,
2821: p_log_level => 5);

Line 2822: pa_fp_gen_amount_utils.fp_debug

2818: (p_called_mode => p_called_mode,
2819: p_msg => 'BEFORE calling pa_plan_revenue.Get_planning_Rates',
2820: p_module_name => l_module_name,
2821: p_log_level => 5);
2822: pa_fp_gen_amount_utils.fp_debug
2823: (p_called_mode => p_called_mode,
2824: p_msg => 'p_person_id:'||l_rt_person_id_tab(k),
2825: p_module_name => l_module_name,
2826: p_log_level => 5);

Line 2827: pa_fp_gen_amount_utils.fp_debug

2823: (p_called_mode => p_called_mode,
2824: p_msg => 'p_person_id:'||l_rt_person_id_tab(k),
2825: p_module_name => l_module_name,
2826: p_log_level => 5);
2827: pa_fp_gen_amount_utils.fp_debug
2828: (p_called_mode => p_called_mode,
2829: p_msg => 'p_job_id:'||l_rt_job_id_tab(k),
2830: p_module_name => l_module_name,
2831: p_log_level => 5);

Line 2832: pa_fp_gen_amount_utils.fp_debug

2828: (p_called_mode => p_called_mode,
2829: p_msg => 'p_job_id:'||l_rt_job_id_tab(k),
2830: p_module_name => l_module_name,
2831: p_log_level => 5);
2832: pa_fp_gen_amount_utils.fp_debug
2833: (p_called_mode => p_called_mode,
2834: p_msg => 'p_bill_job_grp_id:'||rate_rec.bill_job_group_id,
2835: p_module_name => l_module_name,
2836: p_log_level => 5);

Line 2837: pa_fp_gen_amount_utils.fp_debug

2833: (p_called_mode => p_called_mode,
2834: p_msg => 'p_bill_job_grp_id:'||rate_rec.bill_job_group_id,
2835: p_module_name => l_module_name,
2836: p_log_level => 5);
2837: pa_fp_gen_amount_utils.fp_debug
2838: (p_called_mode => p_called_mode,
2839: p_msg => 'p_resource_class:'||l_rt_res_class_code_tab(k),
2840: p_module_name => l_module_name,
2841: p_log_level => 5);

Line 2971: pa_fp_gen_amount_utils.fp_debug

2967: RAISE;
2968: END;
2969:
2970: IF p_pa_debug_mode = 'Y' THEN
2971: pa_fp_gen_amount_utils.fp_debug
2972: (p_called_mode => p_called_mode,
2973: p_msg => 'calling client extensions',
2974: p_module_name => l_module_name,
2975: p_log_level => 5);

Line 3123: pa_fp_gen_amount_utils.fp_debug

3119: IF x_cost_txn_curr_code <> l_Final_Txn_Currency_Code AND
3120: l_calculate_mode IN ('COST_REVENUE', 'COST') THEN
3121:
3122: IF p_pa_debug_mode = 'Y' THEN
3123: pa_fp_gen_amount_utils.fp_debug
3124: (p_called_mode => p_called_mode,
3125: p_msg => 'convert cost from '|| x_cost_txn_curr_code ||
3126: ' to '||l_Final_Txn_Currency_Code,
3127: p_module_name => l_module_name,

Line 3206: pa_fp_gen_amount_utils.fp_debug

3202: IF x_rev_txn_curr_code <> l_Final_Txn_Currency_Code AND
3203: l_calculate_mode IN ('COST_REVENUE', 'REVENUE') THEN
3204:
3205: IF p_pa_debug_mode = 'Y' THEN
3206: pa_fp_gen_amount_utils.fp_debug
3207: (p_called_mode => p_called_mode,
3208: p_msg => 'convert revenue from '|| x_rev_txn_curr_code ||
3209: ' to '||l_Final_Txn_Currency_Code,
3210: p_module_name => l_module_name,

Line 3286: pa_fp_gen_amount_utils.fp_debug

3282:
3283: l_insert_Txn_Currency_Code := x_cost_txn_curr_code; -- Bug 4615589
3284:
3285: IF p_pa_debug_mode = 'Y' THEN
3286: pa_fp_gen_amount_utils.fp_debug
3287: (p_called_mode => p_called_mode,
3288: p_msg => 'cost cur <> rev cur, convert revenue from '|| x_rev_txn_curr_code ||
3289: ' to '||l_insert_Txn_Currency_Code, -- Bug 4615589
3290: p_module_name => l_module_name,

Line 3358: pa_fp_gen_amount_utils.fp_debug

3354:
3355: END IF; -- ELSIF x_cost_txn_curr_code <> x_rev_txn_curr_code THEN
3356:
3357: IF p_pa_debug_mode = 'Y' THEN
3358: pa_fp_gen_amount_utils.fp_debug
3359: (p_called_mode => p_called_mode,
3360: p_msg => 'Populate temporary table (pa_fp_rollup_tmp) with rates and rejection code',
3361: p_module_name => l_module_name,
3362: p_log_level => 5);

Line 3363: pa_fp_gen_amount_utils.fp_debug

3359: (p_called_mode => p_called_mode,
3360: p_msg => 'Populate temporary table (pa_fp_rollup_tmp) with rates and rejection code',
3361: p_module_name => l_module_name,
3362: p_log_level => 5);
3363: pa_fp_gen_amount_utils.fp_debug
3364: (p_called_mode => p_called_mode,
3365: p_msg => 'resource assignment id:'||l_rt_res_assignment_id_tab(k),
3366: p_module_name => l_module_name,
3367: p_log_level => 5);

Line 3368: pa_fp_gen_amount_utils.fp_debug

3364: (p_called_mode => p_called_mode,
3365: p_msg => 'resource assignment id:'||l_rt_res_assignment_id_tab(k),
3366: p_module_name => l_module_name,
3367: p_log_level => 5);
3368: pa_fp_gen_amount_utils.fp_debug
3369: (p_called_mode => p_called_mode,
3370: p_msg => 'start date:'||l_rt_start_date_tab(k),
3371: p_module_name => l_module_name,
3372: p_log_level => 5);

Line 3373: pa_fp_gen_amount_utils.fp_debug

3369: (p_called_mode => p_called_mode,
3370: p_msg => 'start date:'||l_rt_start_date_tab(k),
3371: p_module_name => l_module_name,
3372: p_log_level => 5);
3373: pa_fp_gen_amount_utils.fp_debug
3374: (p_called_mode => p_called_mode,
3375: p_msg => 'txn currency code:'||l_insert_Txn_Currency_Code,
3376: p_module_name => l_module_name,
3377: p_log_level => 5);

Line 3451: pa_fp_gen_amount_utils.fp_debug

3447: -- currencies in the PA_FP_ROLLUP_TMP table instead of in the
3448: -- PA_BUDGET_LINES table.
3449:
3450: IF p_pa_debug_mode = 'Y' THEN
3451: pa_fp_gen_amount_utils.fp_debug
3452: (p_called_mode => p_called_mode,
3453: p_msg => 'Before calling
3454: pa_fp_multi_currency_pkg.convert_txn_currency',
3455: p_module_name => l_module_name,

Line 3469: pa_fp_gen_amount_utils.fp_debug

3465: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3466: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3467: END IF;
3468: IF p_pa_debug_mode = 'Y' THEN
3469: pa_fp_gen_amount_utils.fp_debug
3470: (p_called_mode => p_called_mode,
3471: p_msg => 'Status after calling
3472: pa_fp_multi_currency_pkg.convert_txn_currency: '
3473: ||x_return_status,

Line 3695: pa_fp_gen_amount_utils.fp_debug

3691:
3692: END LOOP; -- FOR m IN 1..l_rej_res_assignment_id_tab.COUNT LOOP
3693:
3694: IF p_pa_debug_mode = 'Y' THEN
3695: pa_fp_gen_amount_utils.fp_debug
3696: (p_called_mode => p_called_mode,
3697: p_msg => 'Group temp table data by res asgmt, txn cur and period. Insert into budget lines',
3698: p_module_name => l_module_name,
3699: p_log_level => 5);

Line 3935: pa_fp_gen_amount_utils.fp_debug

3931: --dbms_output.put_line('before cursor:l_proj_res_assgn_id_tab('||j
3932: -- ||'):'||l_proj_res_assgn_id_tab(j)
3933: -- ||';p_actuals_thru_date:'||p_actuals_thru_date);
3934: IF p_pa_debug_mode = 'Y' THEN
3935: pa_fp_gen_amount_utils.fp_debug
3936: (p_called_mode => p_called_mode,
3937: p_msg => 'before cursor:l_proj_assgn_id_tab('||j
3938: ||'):'||l_proj_assgn_id_tab(j)
3939: ||';p_actuals_thru_date:'||p_actuals_thru_date,

Line 4020: pa_fp_gen_amount_utils.fp_debug

4016: CLOSE FCST_NONE;
4017: END IF;
4018:
4019: IF p_pa_debug_mode = 'Y' THEN
4020: pa_fp_gen_amount_utils.fp_debug
4021: (p_called_mode => p_called_mode,
4022: p_msg => '==j=='||j
4023: ||';==l_rt_start_date_tab.count:'||l_rt_start_date_tab.count,
4024: p_module_name => l_module_name,

Line 4038: pa_fp_gen_amount_utils.fp_debug

4034: -- ||';l_proj_res_assgn_id_tab(j):'||l_proj_res_assgn_id_tab(j)
4035: -- ||';count:'||l_count
4036: -- ||';l_rt_start_date_tab.count:'||l_rt_start_date_tab.count);
4037: IF p_pa_debug_mode = 'Y' THEN
4038: pa_fp_gen_amount_utils.fp_debug
4039: (p_called_mode => p_called_mode,
4040: p_msg => '==j=='||j
4041: ||';l_proj_res_assgn_id_tab(j):'||l_proj_res_assgn_id_tab(j)
4042: ||';count:'||l_count

Line 4280: pa_fp_gen_amount_utils.fp_debug

4276: -- PJI rollup api is bypassed for increased performance.
4277:
4278: /* Calling the calculate API */
4279: IF p_pa_debug_mode = 'Y' THEN
4280: pa_fp_gen_amount_utils.fp_debug
4281: (p_called_mode => p_called_mode,
4282: p_msg => 'Before calling
4283: pa_fp_calc_plan_pkg.calculate',
4284: p_module_name => l_module_name,

Line 4337: pa_fp_gen_amount_utils.fp_debug

4333: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4334: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4335: END IF;
4336: IF p_pa_debug_mode = 'Y' THEN
4337: pa_fp_gen_amount_utils.fp_debug
4338: (p_called_mode => p_called_mode,
4339: p_msg => 'Status after calling
4340: pa_fp_calc_plan_pkg.calculate: '
4341: ||x_return_status,

Line 4412: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

4408: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
4409: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4410: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
4411: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
4412: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4413: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
4414: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4415: X_MSG_COUNT OUT NOCOPY NUMBER,
4416: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 5052: pa_fp_gen_amount_utils.fp_debug

5048: RETURN;
5049: END IF;
5050: IF P_PA_DEBUG_MODE = 'Y' THEN
5051: FOR i IN 1..l_res_list_member_id.count LOOP
5052: pa_fp_gen_amount_utils.fp_debug
5053: (p_msg => 'in res_asg4:@@rlm in cursor:'||l_res_list_member_id(i)
5054: ||'; @@task in cursor:'||l_task_id(i)
5055: ||';@@start date in cursor:'||l_start_date_tab(i)
5056: ||';@@end date in cursor:'||l_end_date_tab(i),

Line 5201: pa_fp_gen_amount_utils.fp_debug

5197: END LOOP;
5198:
5199: --Calling resource defualt API
5200: IF p_pa_debug_mode = 'Y' THEN
5201: pa_fp_gen_amount_utils.fp_debug
5202: (p_msg => 'Before calling
5203: pa_planning_resource_utils.get_resource_defaults',
5204: p_module_name => l_module_name,
5205: p_log_level => 5);

Line 5256: pa_fp_gen_amount_utils.fp_debug

5252: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
5253: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5254: END IF;
5255: IF p_pa_debug_mode = 'Y' THEN
5256: pa_fp_gen_amount_utils.fp_debug
5257: (p_msg => 'Status after calling
5258: pa_planning_resource_utils.get_resource_defaults'
5259: ||x_return_status,
5260: p_module_name => l_module_name,

Line 5480: pa_fp_gen_amount_utils.fp_debug

5476: RETURN;
5477: END IF;
5478: IF P_PA_DEBUG_MODE = 'Y' THEN
5479: FOR i IN 1..l_res_list_member_id.count LOOP
5480: pa_fp_gen_amount_utils.fp_debug
5481: (p_msg => 'in res_asg4:@@rlm in cursor:'||l_res_list_member_id(i)
5482: ||'; @@task in cursor:'||l_task_id(i)
5483: ||';@@start date in cursor:'||l_start_date_tab(i)
5484: ||';@@end date in cursor:'||l_end_date_tab(i),

Line 5628: pa_fp_gen_amount_utils.fp_debug

5624: END LOOP;
5625:
5626: --Calling resource defualt API
5627: IF p_pa_debug_mode = 'Y' THEN
5628: pa_fp_gen_amount_utils.fp_debug
5629: (p_msg => 'Before calling
5630: pa_planning_resource_utils.get_resource_defaults',
5631: p_module_name => l_module_name,
5632: p_log_level => 5);

Line 5684: pa_fp_gen_amount_utils.fp_debug

5680: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
5681: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5682: END IF;
5683: IF p_pa_debug_mode = 'Y' THEN
5684: pa_fp_gen_amount_utils.fp_debug
5685: (p_msg => 'Status after calling
5686: pa_planning_resource_utils.get_resource_defaults'
5687: ||x_return_status,
5688: p_module_name => l_module_name,

Line 5804: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

5800: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5801: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5802: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
5803: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
5804: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5805: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
5806: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5807: X_MSG_COUNT OUT NOCOPY NUMBER,
5808: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 6004: pa_fp_gen_amount_utils.fp_debug

6000:
6001: --@@
6002: IF P_PA_DEBUG_MODE = 'Y' THEN
6003: for i in 1..l_res_assgn_id_tab.count loop
6004: pa_fp_gen_amount_utils.fp_debug
6005: (p_msg => 'within update when share partial and planning at lowest task i:'
6006: ||i||'; ra id in cursor:'||l_res_assgn_id_tab(i)
6007: ||';rlm id in cursor:'||l_rlm_id_tab(i)
6008: ||';task id in cursor:'||l_txn_task_id_tab(i)

Line 6139: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE

6135: FROM pa_budget_lines bl
6136: WHERE bl.resource_assignment_id = ra.resource_assignment_id
6137: AND rownum = 1 ));
6138: ELSIF p_fp_cols_rec.x_plan_class_code = 'FORECAST' THEN
6139: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE
6140: ( p_budget_version_id );
6141: DELETE FROM pa_res_list_map_tmp4 tmp
6142: WHERE EXISTS
6143: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1

Line 6297: pa_fp_gen_amount_utils.fp_debug

6293: DELETE FROM PA_BUDGET_LINES
6294: WHERE RESOURCE_ASSIGNMENT_ID = PX_DELETED_RES_ASG_ID_TAB(i);
6295:
6296: IF p_pa_debug_mode = 'Y' THEN
6297: pa_fp_gen_amount_utils.fp_debug
6298: (p_msg => 'Before calling
6299: pa_fp_rollup_pkg.rollup_budget_version',
6300: p_module_name => l_module_name,
6301: p_log_level => 5);

Line 6314: pa_fp_gen_amount_utils.fp_debug

6310: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
6311: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6312: END IF;
6313: IF p_pa_debug_mode = 'Y' THEN
6314: pa_fp_gen_amount_utils.fp_debug
6315: (p_msg => 'Status after calling
6316: pa_fp_rollup_pkg.rollup_budget_version: '
6317: ||x_return_status,
6318: p_module_name => l_module_name,

Line 6553: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

6549: ******************************************************************************/
6550: PROCEDURE INSERT_TXN_CURRENCY
6551: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6552: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6553: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6554: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6555: X_MSG_COUNT OUT NOCOPY NUMBER,
6556: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6557: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.INSERT_TXN_CURRENCY';

Line 6563: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

6559: l_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6560: l_budget_version_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6561: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6562:
6563: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
6564: l_pc pa_budget_lines.txn_currency_code%type;
6565: l_pfc pa_budget_lines.txn_currency_code%type;
6566:
6567: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

Line 6591: pa_fp_gen_amount_utils.fp_debug

6587: OR l_fp_cols_rec.x_fin_plan_type_id is null
6588: OR p_project_id is null) THEN
6589:
6590: IF p_pa_debug_mode = 'Y' THEN
6591: pa_fp_gen_amount_utils.fp_debug
6592: (p_msg => 'Before calling
6593: pa_fp_gen_amount_utils.get_plan_version_dtls',
6594: p_module_name => l_module_name,
6595: p_log_level => 5);

Line 6593: pa_fp_gen_amount_utils.get_plan_version_dtls',

6589:
6590: IF p_pa_debug_mode = 'Y' THEN
6591: pa_fp_gen_amount_utils.fp_debug
6592: (p_msg => 'Before calling
6593: pa_fp_gen_amount_utils.get_plan_version_dtls',
6594: p_module_name => l_module_name,
6595: p_log_level => 5);
6596: END IF;
6597:

Line 6598: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

6594: p_module_name => l_module_name,
6595: p_log_level => 5);
6596: END IF;
6597:
6598: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
6599: (P_PROJECT_ID => P_PROJECT_ID,
6600: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
6601: X_FP_COLS_REC => l_fp_cols_rec,
6602: X_RETURN_STATUS => X_RETURN_STATUS,

Line 6610: pa_fp_gen_amount_utils.fp_debug

6606: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
6607: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6608: END IF;
6609: IF p_pa_debug_mode = 'Y' THEN
6610: pa_fp_gen_amount_utils.fp_debug
6611: (p_msg => 'Status after calling
6612: pa_fp_gen_amount_utils.get_plan_version_dtls: '
6613: ||x_return_status,
6614: p_module_name => l_module_name,

Line 6612: pa_fp_gen_amount_utils.get_plan_version_dtls: '

6608: END IF;
6609: IF p_pa_debug_mode = 'Y' THEN
6610: pa_fp_gen_amount_utils.fp_debug
6611: (p_msg => 'Status after calling
6612: pa_fp_gen_amount_utils.get_plan_version_dtls: '
6613: ||x_return_status,
6614: p_module_name => l_module_name,
6615: p_log_level => 5);
6616: END IF;

Line 6810: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

6806:
6807: PROCEDURE GEN_REV_BDGT_AMT_RES_SCH_WRP
6808: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
6809: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6810: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6811: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6812: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6813: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6814: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 6950: pa_fp_gen_amount_utils.fp_debug

6946: END IF;
6947:
6948:
6949: IF p_pa_debug_mode = 'Y' THEN
6950: pa_fp_gen_amount_utils.fp_debug
6951: (p_msg => 'Before calling
6952: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
6953: p_module_name => l_module_name,
6954: p_log_level => 5);

Line 6982: pa_fp_gen_amount_utils.fp_debug

6978: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
6979: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6980: END IF;
6981: IF p_pa_debug_mode = 'Y' THEN
6982: pa_fp_gen_amount_utils.fp_debug
6983: (p_msg => 'Status after calling
6984: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '
6985: ||x_return_status,
6986: p_module_name => l_module_name,

Line 7100: pa_fp_gen_amount_utils.fp_debug

7096: AND ra.resource_list_member_id = rlm.resource_list_member_id;
7097:
7098: FOR i IN 1..l_res_asg_id_tab.count LOOP
7099: IF p_pa_debug_mode = 'Y' THEN
7100: pa_fp_gen_amount_utils.fp_debug
7101: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
7102: p_module_name => l_module_name,
7103: p_log_level => 5);
7104: END IF;

Line 7183: pa_fp_gen_amount_utils.fp_debug

7179: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7180: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7181: END IF;
7182: IF p_pa_debug_mode = 'Y' THEN
7183: pa_fp_gen_amount_utils.fp_debug
7184: (p_msg => 'Status after calling pa_plan_revenue.Get_planning_Rates'
7185: ||x_return_status,
7186: p_module_name => l_module_name,
7187: p_log_level => 5);

Line 7243: pa_fp_gen_amount_utils.fp_debug

7239: -- PJI rollup api is bypassed for increased performance.
7240:
7241: /* Calling the calculate API */
7242: IF p_pa_debug_mode = 'Y' THEN
7243: pa_fp_gen_amount_utils.fp_debug
7244: (p_called_mode => p_called_mode,
7245: p_msg => 'Before calling
7246: pa_fp_calc_plan_pkg.calculate',
7247: p_module_name => l_module_name,

Line 7293: pa_fp_gen_amount_utils.fp_debug

7289: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7290: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7291: END IF;
7292: IF p_pa_debug_mode = 'Y' THEN
7293: pa_fp_gen_amount_utils.fp_debug
7294: (p_called_mode => p_called_mode,
7295: p_msg => 'Status after calling
7296: pa_fp_calc_plan_pkg.calculate: '
7297: ||x_return_status,

Line 7495: pa_fp_gen_amount_utils.fp_debug

7491: p_debug_mode => p_pa_debug_mode);
7492: END IF;
7493:
7494: IF p_pa_debug_mode = 'Y' THEN
7495: pa_fp_gen_amount_utils.fp_debug
7496: (p_called_mode => p_called_mode,
7497: p_msg => 'Before calling
7498: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt',
7499: p_module_name => l_module_name,

Line 7526: pa_fp_gen_amount_utils.fp_debug

7522: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7523: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7524: END IF;
7525: IF p_pa_debug_mode = 'Y' THEN
7526: pa_fp_gen_amount_utils.fp_debug
7527: (p_called_mode => p_called_mode,
7528: p_msg => 'Status after calling pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt:'
7529: ||x_return_status,
7530: p_module_name => l_module_name,

Line 7644: pa_fp_gen_amount_utils.fp_debug

7640: AND ra.resource_list_member_id = rlm.resource_list_member_id;
7641:
7642: FOR i IN 1..l_res_asg_id_tab.count LOOP
7643: IF p_pa_debug_mode = 'Y' THEN
7644: pa_fp_gen_amount_utils.fp_debug
7645: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
7646: p_module_name => l_module_name,
7647: p_log_level => 5);
7648: END IF;

Line 7727: pa_fp_gen_amount_utils.fp_debug

7723: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7724: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7725: END IF;
7726: IF p_pa_debug_mode = 'Y' THEN
7727: pa_fp_gen_amount_utils.fp_debug
7728: (p_msg => 'Status after calling pa_plan_revenue.Get_planning_Rates'
7729: ||x_return_status,
7730: p_module_name => l_module_name,
7731: p_log_level => 5);

Line 7787: pa_fp_gen_amount_utils.fp_debug

7783: -- PJI rollup api is bypassed for increased performance.
7784:
7785: /* Calling the calculate API */
7786: IF p_pa_debug_mode = 'Y' THEN
7787: pa_fp_gen_amount_utils.fp_debug
7788: (p_called_mode => p_called_mode,
7789: p_msg => 'Before calling pa_fp_calc_plan_pkg.calculate',
7790: p_module_name => l_module_name,
7791: p_log_level => 5);

Line 7836: pa_fp_gen_amount_utils.fp_debug

7832: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7833: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7834: END IF;
7835: IF p_pa_debug_mode = 'Y' THEN
7836: pa_fp_gen_amount_utils.fp_debug
7837: (p_called_mode => p_called_mode,
7838: p_msg => 'Status after calling
7839: pa_fp_calc_plan_pkg.calculate: '
7840: ||x_return_status,