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_DEBUG

Line 4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE body PA_FP_GEN_BUDGET_AMT_PUB as
2: /* $Header: PAFPGAMB.pls 120.20 2007/11/28 07:46:11 vgovvala ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: /**
7: * Wrapper API
8: *

Line 64: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

60:
61: X_MSG_COUNT := 0;
62: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
63:
64: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
65: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP');
66: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
67: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_WRP'
68: ,p_debug_mode => p_pa_debug_mode);

Line 65: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP');

61: X_MSG_COUNT := 0;
62: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
63:
64: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
65: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP');
66: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
67: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_WRP'
68: ,p_debug_mode => p_pa_debug_mode);
69: END IF;

Line 66: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

62: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
63:
64: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
65: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP');
66: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
67: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_WRP'
68: ,p_debug_mode => p_pa_debug_mode);
69: END IF;
70:

Line 67: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_WRP'

63:
64: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
65: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP');
66: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
67: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_WRP'
68: ,p_debug_mode => p_pa_debug_mode);
69: END IF;
70:
71: --Calling the get_plan_version_dtls api

Line 68: ,p_debug_mode => p_pa_debug_mode);

64: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
65: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP');
66: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
67: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_WRP'
68: ,p_debug_mode => p_pa_debug_mode);
69: END IF;
70:
71: --Calling the get_plan_version_dtls api
72: IF p_pa_debug_mode = 'Y' THEN

Line 72: IF p_pa_debug_mode = 'Y' THEN

68: ,p_debug_mode => p_pa_debug_mode);
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',

Line 87: IF p_pa_debug_mode = 'Y' THEN

83: X_FP_COLS_REC => l_fp_cols_rec,
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: '

Line 104: IF p_pa_debug_mode = 'Y' THEN

100: /* This API validates that the current generation is supported.
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,

Line 121: IF p_pa_debug_mode = 'Y' THEN

117: X_RETURN_STATUS => X_RETURN_STATUS,
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,

Line 139: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

135: * can be displayed asking the user whether or not to proceed.
136: */
137: IF X_WARNING_MESSAGE IS NOT NULL THEN
138: -- Before returning, we always have the following check.
139: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
140: PA_DEBUG.reset_err_stack;
141: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
142: PA_DEBUG.Reset_Curr_Function;
143: END IF;

Line 140: PA_DEBUG.reset_err_stack;

136: */
137: IF X_WARNING_MESSAGE IS NOT NULL THEN
138: -- Before returning, we always have the following check.
139: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
140: PA_DEBUG.reset_err_stack;
141: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
142: PA_DEBUG.Reset_Curr_Function;
143: END IF;
144:

Line 141: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

137: IF X_WARNING_MESSAGE IS NOT NULL THEN
138: -- Before returning, we always have the following check.
139: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
140: PA_DEBUG.reset_err_stack;
141: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
142: PA_DEBUG.Reset_Curr_Function;
143: END IF;
144:
145: RETURN;

Line 142: PA_DEBUG.Reset_Curr_Function;

138: -- Before returning, we always have the following check.
139: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
140: PA_DEBUG.reset_err_stack;
141: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
142: PA_DEBUG.Reset_Curr_Function;
143: END IF;
144:
145: RETURN;
146: END IF;

Line 154: IF p_pa_debug_mode = 'Y' THEN

150: SELECT record_version_number
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,

Line 170: IF p_pa_debug_mode = 'Y' THEN

166: p_person_id => NULL,
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,

Line 179: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

175: p_module_name => l_module_name,
176: p_log_level => 5);
177: END IF;
178: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
179: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
180: PA_DEBUG.reset_err_stack;
181: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
182: PA_DEBUG.Reset_Curr_Function;
183: END IF;

Line 180: PA_DEBUG.reset_err_stack;

176: p_log_level => 5);
177: END IF;
178: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
179: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
180: PA_DEBUG.reset_err_stack;
181: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
182: PA_DEBUG.Reset_Curr_Function;
183: END IF;
184: RETURN;

Line 181: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

177: END IF;
178: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
179: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
180: PA_DEBUG.reset_err_stack;
181: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
182: PA_DEBUG.Reset_Curr_Function;
183: END IF;
184: RETURN;
185: END IF;

Line 182: PA_DEBUG.Reset_Curr_Function;

178: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
179: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
180: PA_DEBUG.reset_err_stack;
181: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
182: PA_DEBUG.Reset_Curr_Function;
183: END IF;
184: RETURN;
185: END IF;
186:

Line 197: IF p_pa_debug_mode = 'Y' THEN

193: can be used for any other process for
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',

Line 213: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

209: X_MSG_DATA => X_MSG_DATA);
210: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
211: --If we can't acquire lock, customized message is thrown from within
212: -- the API, so we should suppress exception error.
213: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
214: PA_DEBUG.reset_err_stack;
215: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
216: PA_DEBUG.Reset_Curr_Function;
217: END IF;

Line 214: PA_DEBUG.reset_err_stack;

210: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
211: --If we can't acquire lock, customized message is thrown from within
212: -- the API, so we should suppress exception error.
213: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
214: PA_DEBUG.reset_err_stack;
215: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
216: PA_DEBUG.Reset_Curr_Function;
217: END IF;
218: RETURN;

Line 215: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

211: --If we can't acquire lock, customized message is thrown from within
212: -- the API, so we should suppress exception error.
213: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
214: PA_DEBUG.reset_err_stack;
215: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
216: PA_DEBUG.Reset_Curr_Function;
217: END IF;
218: RETURN;
219: END IF;

Line 216: PA_DEBUG.Reset_Curr_Function;

212: -- the API, so we should suppress exception error.
213: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
214: PA_DEBUG.reset_err_stack;
215: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
216: PA_DEBUG.Reset_Curr_Function;
217: END IF;
218: RETURN;
219: END IF;
220: IF p_pa_debug_mode = 'Y' THEN

Line 220: IF p_pa_debug_mode = 'Y' THEN

216: PA_DEBUG.Reset_Curr_Function;
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: '

Line 241: IF p_pa_debug_mode = 'Y' THEN

237: WHERE budget_version_id = p_budget_version_id ;
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,

Line 258: IF p_pa_debug_mode = 'Y' THEN

254: P_CALLED_MODE => p_called_mode,
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,

Line 312: IF p_pa_debug_mode = 'Y' THEN

308: l_res_as_id(k),
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,

Line 329: IF p_pa_debug_mode = 'Y' THEN

325: P_CALLED_MODE => p_called_mode,
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,

Line 351: IF p_pa_debug_mode = 'Y' THEN

347: /* Checking for the planning level and calling appropriate API */
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',

Line 386: IF p_pa_debug_mode = 'Y' THEN

382:
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,

Line 396: IF p_pa_debug_mode = 'Y' THEN

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

Line 430: IF p_pa_debug_mode = 'Y' THEN

426: --dbms_output.put_line('after PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH:'||x_return_status);
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: '

Line 447: IF p_pa_debug_mode = 'Y' THEN

443: l_wp_track_cost_flag := Pa_Fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag (p_project_id);
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',

Line 478: IF p_pa_debug_mode = 'Y' THEN

474: X_MSG_DATA => X_MSG_DATA);
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: '

Line 488: IF p_pa_debug_mode = 'Y' THEN

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

Line 520: IF p_pa_debug_mode = 'Y' THEN

516:
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: '

Line 534: IF p_pa_debug_mode = 'Y' THEN

530: END IF;
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',

Line 555: IF p_pa_debug_mode = 'Y' THEN

551:
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: '

Line 595: IF p_pa_debug_mode = 'Y' THEN

591:
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',

Line 613: IF p_pa_debug_mode = 'Y' THEN

609: X_MSG_DATA => X_MSG_DATA);
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: '

Line 635: IF p_pa_debug_mode = 'Y' THEN

631: -- rolled up amounts, but the Change Document wrapper API takes
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',

Line 652: IF p_pa_debug_mode = 'Y' THEN

648: X_MSG_DATA => X_MSG_DATA);
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: '

Line 666: IF p_pa_debug_mode = 'Y' THEN

662:
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',

Line 685: IF p_pa_debug_mode = 'Y' THEN

681: ,x_msg_data => x_msg_data);
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: '

Line 696: IF p_pa_debug_mode = 'Y' THEN

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

Line 713: IF p_pa_debug_mode = 'Y' THEN

709: --dbms_output.put_line('after chg_doc:'||x_return_status);
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,

Line 731: IF p_pa_debug_mode = 'Y' THEN

727: OR l_fp_cols_rec.x_version_type = 'REVENUE')
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',

Line 752: IF p_pa_debug_mode = 'Y' THEN

748:
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: '

Line 764: IF p_pa_debug_mode = 'Y' THEN

760: END IF;
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',

Line 781: IF p_pa_debug_mode = 'Y' THEN

777:
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: '

Line 791: IF p_pa_debug_mode = 'Y' THEN

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

Line 810: IF p_pa_debug_mode = 'Y' THEN

806: --hr_utility.trace('after pub1.maintain bv:'||x_return_status);
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: '

Line 824: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

820: IF P_COMMIT_FLAG = 'Y' THEN
821: COMMIT;
822: END IF;
823:
824: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
825: PA_DEBUG.reset_err_stack;
826: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
827: PA_DEBUG.Reset_Curr_Function;
828: END IF;

Line 825: PA_DEBUG.reset_err_stack;

821: COMMIT;
822: END IF;
823:
824: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
825: PA_DEBUG.reset_err_stack;
826: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
827: PA_DEBUG.Reset_Curr_Function;
828: END IF;
829:

Line 826: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

822: END IF;
823:
824: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
825: PA_DEBUG.reset_err_stack;
826: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
827: PA_DEBUG.Reset_Curr_Function;
828: END IF;
829:
830: EXCEPTION

Line 827: PA_DEBUG.Reset_Curr_Function;

823:
824: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
825: PA_DEBUG.reset_err_stack;
826: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
827: PA_DEBUG.Reset_Curr_Function;
828: END IF;
829:
830: EXCEPTION
831: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 851: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

847: END IF;
848: ROLLBACK;
849: x_return_status := FND_API.G_RET_STS_ERROR;
850:
851: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
852: PA_DEBUG.reset_err_stack;
853: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
854: PA_DEBUG.Reset_Curr_Function;
855: END IF;

Line 852: PA_DEBUG.reset_err_stack;

848: ROLLBACK;
849: x_return_status := FND_API.G_RET_STS_ERROR;
850:
851: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
852: PA_DEBUG.reset_err_stack;
853: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
854: PA_DEBUG.Reset_Curr_Function;
855: END IF;
856:

Line 853: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

849: x_return_status := FND_API.G_RET_STS_ERROR;
850:
851: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
852: PA_DEBUG.reset_err_stack;
853: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
854: PA_DEBUG.Reset_Curr_Function;
855: END IF;
856:
857: WHEN OTHERS THEN

Line 854: PA_DEBUG.Reset_Curr_Function;

850:
851: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
852: PA_DEBUG.reset_err_stack;
853: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
854: PA_DEBUG.Reset_Curr_Function;
855: END IF;
856:
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 864: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

860: FND_MSG_PUB.add_exc_msg
861: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
862: ,p_procedure_name => 'GENERATE_BUDGET_AMT_WRP');
863:
864: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
865: PA_DEBUG.reset_err_stack;
866: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
867: PA_DEBUG.Reset_Curr_Function;
868: END IF;

Line 865: PA_DEBUG.reset_err_stack;

861: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
862: ,p_procedure_name => 'GENERATE_BUDGET_AMT_WRP');
863:
864: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
865: PA_DEBUG.reset_err_stack;
866: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
867: PA_DEBUG.Reset_Curr_Function;
868: END IF;
869:

Line 866: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

862: ,p_procedure_name => 'GENERATE_BUDGET_AMT_WRP');
863:
864: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
865: PA_DEBUG.reset_err_stack;
866: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
867: PA_DEBUG.Reset_Curr_Function;
868: END IF;
869:
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 867: PA_DEBUG.Reset_Curr_Function;

863:
864: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
865: PA_DEBUG.reset_err_stack;
866: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
867: PA_DEBUG.Reset_Curr_Function;
868: END IF;
869:
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871:

Line 2065: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

2061: END IF;
2062: X_MSG_COUNT := 0;
2063: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2064:
2065: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2066: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
2067: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2068: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_RES_SCH'
2069: ,p_debug_mode => p_pa_debug_mode);

Line 2066: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');

2062: X_MSG_COUNT := 0;
2063: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2064:
2065: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2066: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
2067: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2068: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_RES_SCH'
2069: ,p_debug_mode => p_pa_debug_mode);
2070: END IF;

Line 2067: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

2063: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2064:
2065: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2066: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
2067: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2068: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_RES_SCH'
2069: ,p_debug_mode => p_pa_debug_mode);
2070: END IF;
2071:

Line 2068: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_RES_SCH'

2064:
2065: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2066: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
2067: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2068: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_RES_SCH'
2069: ,p_debug_mode => p_pa_debug_mode);
2070: END IF;
2071:
2072: -- Bug 4549862: Added counter to track unique budget_line_id values for

Line 2069: ,p_debug_mode => p_pa_debug_mode);

2065: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2066: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
2067: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2068: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_RES_SCH'
2069: ,p_debug_mode => p_pa_debug_mode);
2070: END IF;
2071:
2072: -- Bug 4549862: Added counter to track unique budget_line_id values for
2073: -- the PA_FP_ROLLUP_TMP table. Will be arbitrarily initialized to 0 and

Line 2326: IF p_pa_debug_mode = 'Y' THEN

2322: END IF;
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,

Line 2335: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

2331: p_log_level => 5);
2332: END IF;
2333:
2334: if l_proj_resource_id.count = 0 then
2335: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2336: PA_DEBUG.reset_err_stack;
2337: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2338: PA_DEBUG.Reset_Curr_Function;
2339: END IF;

Line 2336: PA_DEBUG.reset_err_stack;

2332: END IF;
2333:
2334: if l_proj_resource_id.count = 0 then
2335: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2336: PA_DEBUG.reset_err_stack;
2337: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2338: PA_DEBUG.Reset_Curr_Function;
2339: END IF;
2340: return;

Line 2337: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

2333:
2334: if l_proj_resource_id.count = 0 then
2335: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2336: PA_DEBUG.reset_err_stack;
2337: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2338: PA_DEBUG.Reset_Curr_Function;
2339: END IF;
2340: return;
2341: end if;

Line 2338: PA_DEBUG.Reset_Curr_Function;

2334: if l_proj_resource_id.count = 0 then
2335: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2336: PA_DEBUG.reset_err_stack;
2337: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2338: PA_DEBUG.Reset_Curr_Function;
2339: END IF;
2340: return;
2341: end if;
2342:

Line 2397: IF P_PA_DEBUG_MODE = 'Y' THEN

2393: l_TXN_WBS_ELEMENT_VER_ID_tab(bb):= null;
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;

Line 2451: IF P_PA_DEBUG_MODE = 'Y' THEN

2447: X_TXN_ACCUM_HEADER_ID_TAB =>l_map_txn_accum_header_id_tab,
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);

Line 2475: IF p_pa_debug_mode = 'Y' THEN

2471: END IF;
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',

Line 2486: IF p_pa_debug_mode = 'Y' THEN

2482: END IF;
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',

Line 2507: IF p_pa_debug_mode = 'Y' THEN

2503: X_MSG_DATA => X_MSG_DATA);
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: '

Line 2519: IF p_pa_debug_mode = 'Y' THEN

2515: END IF;
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',

Line 2539: IF p_pa_debug_mode = 'Y' THEN

2535: X_MSG_DATA => X_MSG_DATA);
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: '

Line 2579: IF p_pa_debug_mode = 'Y' THEN

2575: AND WB.WORK_TYPE_ID = PA.WORK_TYPE_ID(+);
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,

Line 2615: IF p_pa_debug_mode = 'Y' THEN

2611:
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,

Line 2629: IF p_pa_debug_mode = 'Y' THEN

2625: FOR j IN 1..l_proj_assgn_id_tab.count LOOP
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)

Line 2771: IF p_pa_debug_mode = 'Y' THEN

2767: -- assignments with different bill rate override currency are mapped
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),

Line 2803: IF p_pa_debug_mode = 'Y' THEN

2799: ELSE
2800: l_txn_currency_code := rate_rec.project_currency_code;
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',

Line 2958: IF p_pa_debug_mode = 'Y' THEN

2954: x_return_status := l_return_status;
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,

Line 3110: IF p_pa_debug_mode = 'Y' THEN

3106:
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,

Line 3193: IF p_pa_debug_mode = 'Y' THEN

3189:
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,

Line 3273: IF p_pa_debug_mode = 'Y' THEN

3269: l_calculate_mode IN ('COST_REVENUE', 'REVENUE') THEN
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

Line 3345: IF p_pa_debug_mode = 'Y' THEN

3341: l_insert_Txn_Currency_Code := x_cost_txn_curr_code; -- Bug 4615589
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,

Line 3438: IF p_pa_debug_mode = 'Y' THEN

3434: -- the p_entire_version parameter tells to the API to convert
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',

Line 3456: IF p_pa_debug_mode = 'Y' THEN

3452: X_MSG_DATA => X_MSG_DATA );
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: '

Line 3682: IF p_pa_debug_mode = 'Y' THEN

3678: revenue_rejection_code is null);
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,

Line 3922: IF p_pa_debug_mode = 'Y' THEN

3918: FOR j IN 1..l_proj_assgn_id_tab.count LOOP
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)

Line 4007: IF p_pa_debug_mode = 'Y' THEN

4003: ELSE
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,

Line 4025: IF p_pa_debug_mode = 'Y' THEN

4021: --dbms_output.put_line('==j=='||j
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)

Line 4157: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

4153: END LOOP; -- FOR j IN 1..l_proj_assgn_id_tab.count LOOP
4154:
4155: /*Duplicate res_assignment needs to be filtered before calling calculate API*/
4156: IF l_proj_res_assgn_id_tab.count = 0 THEN
4157: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4158: PA_DEBUG.reset_err_stack;
4159: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4160: PA_DEBUG.Reset_Curr_Function;
4161: END IF;

Line 4158: PA_DEBUG.reset_err_stack;

4154:
4155: /*Duplicate res_assignment needs to be filtered before calling calculate API*/
4156: IF l_proj_res_assgn_id_tab.count = 0 THEN
4157: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4158: PA_DEBUG.reset_err_stack;
4159: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4160: PA_DEBUG.Reset_Curr_Function;
4161: END IF;
4162: RETURN;

Line 4159: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

4155: /*Duplicate res_assignment needs to be filtered before calling calculate API*/
4156: IF l_proj_res_assgn_id_tab.count = 0 THEN
4157: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4158: PA_DEBUG.reset_err_stack;
4159: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4160: PA_DEBUG.Reset_Curr_Function;
4161: END IF;
4162: RETURN;
4163: END IF;

Line 4160: PA_DEBUG.Reset_Curr_Function;

4156: IF l_proj_res_assgn_id_tab.count = 0 THEN
4157: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4158: PA_DEBUG.reset_err_stack;
4159: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4160: PA_DEBUG.Reset_Curr_Function;
4161: END IF;
4162: RETURN;
4163: END IF;
4164: l_dp_counter := 0;

Line 4203: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

4199: VALUES(
4200: l_res_assgn_id_tmp_tab(i),
4201: l_total_plan_quantity);
4202: END LOOP;
4203: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4204: PA_DEBUG.reset_err_stack;
4205: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4206: PA_DEBUG.Reset_Curr_Function;
4207: END IF;

Line 4204: PA_DEBUG.reset_err_stack;

4200: l_res_assgn_id_tmp_tab(i),
4201: l_total_plan_quantity);
4202: END LOOP;
4203: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4204: PA_DEBUG.reset_err_stack;
4205: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4206: PA_DEBUG.Reset_Curr_Function;
4207: END IF;
4208: RETURN;

Line 4205: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

4201: l_total_plan_quantity);
4202: END LOOP;
4203: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4204: PA_DEBUG.reset_err_stack;
4205: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4206: PA_DEBUG.Reset_Curr_Function;
4207: END IF;
4208: RETURN;
4209: END IF;

Line 4206: PA_DEBUG.Reset_Curr_Function;

4202: END LOOP;
4203: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4204: PA_DEBUG.reset_err_stack;
4205: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4206: PA_DEBUG.Reset_Curr_Function;
4207: END IF;
4208: RETURN;
4209: END IF;
4210: --dbms_output.put_line('gen_ret_manual_line_flag: '||p_fp_cols_rec.x_gen_ret_manual_line_flag);

Line 4267: IF p_pa_debug_mode = 'Y' THEN

4263: -- Calculate API with values 'BUDGET_GENERATION' and 'N', respectively, so that calling
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',

Line 4324: IF p_pa_debug_mode = 'Y' THEN

4320:
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: '

Line 4342: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

4338: IF P_COMMIT_FLAG = 'Y' THEN
4339: COMMIT;
4340: END IF;
4341:
4342: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4343: PA_DEBUG.reset_err_stack;
4344: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4345: PA_DEBUG.Reset_Curr_Function;
4346: END IF;

Line 4343: PA_DEBUG.reset_err_stack;

4339: COMMIT;
4340: END IF;
4341:
4342: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4343: PA_DEBUG.reset_err_stack;
4344: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4345: PA_DEBUG.Reset_Curr_Function;
4346: END IF;
4347:

Line 4344: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

4340: END IF;
4341:
4342: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4343: PA_DEBUG.reset_err_stack;
4344: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4345: PA_DEBUG.Reset_Curr_Function;
4346: END IF;
4347:
4348:

Line 4345: PA_DEBUG.Reset_Curr_Function;

4341:
4342: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4343: PA_DEBUG.reset_err_stack;
4344: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4345: PA_DEBUG.Reset_Curr_Function;
4346: END IF;
4347:
4348:
4349: EXCEPTION

Line 4371: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

4367: END IF;
4368: ROLLBACK;
4369: x_return_status := FND_API.G_RET_STS_ERROR;
4370:
4371: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4372: PA_DEBUG.reset_err_stack;
4373: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4374: PA_DEBUG.Reset_Curr_Function;
4375: END IF;

Line 4372: PA_DEBUG.reset_err_stack;

4368: ROLLBACK;
4369: x_return_status := FND_API.G_RET_STS_ERROR;
4370:
4371: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4372: PA_DEBUG.reset_err_stack;
4373: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4374: PA_DEBUG.Reset_Curr_Function;
4375: END IF;
4376:

Line 4373: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

4369: x_return_status := FND_API.G_RET_STS_ERROR;
4370:
4371: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4372: PA_DEBUG.reset_err_stack;
4373: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4374: PA_DEBUG.Reset_Curr_Function;
4375: END IF;
4376:
4377: RAISE;

Line 4374: PA_DEBUG.Reset_Curr_Function;

4370:
4371: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4372: PA_DEBUG.reset_err_stack;
4373: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4374: PA_DEBUG.Reset_Curr_Function;
4375: END IF;
4376:
4377: RAISE;
4378:

Line 4386: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

4382: FND_MSG_PUB.add_exc_msg
4383: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
4384: ,p_procedure_name => 'GENERATE_BUDGET_AMT_RES_SCH');
4385:
4386: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4387: PA_DEBUG.reset_err_stack;
4388: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4389: PA_DEBUG.Reset_Curr_Function;
4390: END IF;

Line 4387: PA_DEBUG.reset_err_stack;

4383: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
4384: ,p_procedure_name => 'GENERATE_BUDGET_AMT_RES_SCH');
4385:
4386: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4387: PA_DEBUG.reset_err_stack;
4388: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4389: PA_DEBUG.Reset_Curr_Function;
4390: END IF;
4391:

Line 4388: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

4384: ,p_procedure_name => 'GENERATE_BUDGET_AMT_RES_SCH');
4385:
4386: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4387: PA_DEBUG.reset_err_stack;
4388: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4389: PA_DEBUG.Reset_Curr_Function;
4390: END IF;
4391:
4392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4389: PA_DEBUG.Reset_Curr_Function;

4385:
4386: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4387: PA_DEBUG.reset_err_stack;
4388: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4389: PA_DEBUG.Reset_Curr_Function;
4390: END IF;
4391:
4392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4393: END GENERATE_BUDGET_AMT_RES_SCH;

Line 4648: IF p_pa_debug_mode = 'Y' THEN

4644: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4645:
4646: l_project_id := p_project_id;
4647:
4648: IF p_pa_debug_mode = 'Y' THEN
4649: PA_DEBUG.SET_CURR_FUNCTION
4650: ( p_function => 'CREATE_RES_ASG',
4651: p_debug_mode => p_pa_debug_mode );
4652: END IF;

Line 4649: PA_DEBUG.SET_CURR_FUNCTION

4645:
4646: l_project_id := p_project_id;
4647:
4648: IF p_pa_debug_mode = 'Y' THEN
4649: PA_DEBUG.SET_CURR_FUNCTION
4650: ( p_function => 'CREATE_RES_ASG',
4651: p_debug_mode => p_pa_debug_mode );
4652: END IF;
4653:

Line 4651: p_debug_mode => p_pa_debug_mode );

4647:
4648: IF p_pa_debug_mode = 'Y' THEN
4649: PA_DEBUG.SET_CURR_FUNCTION
4650: ( p_function => 'CREATE_RES_ASG',
4651: p_debug_mode => p_pa_debug_mode );
4652: END IF;
4653:
4654: l_stru_sharing_code :=
4655: PA_PROJECT_STRUCTURE_UTILS.GET_STRUCTURE_SHARING_CODE

Line 4674: IF P_PA_DEBUG_MODE = 'Y' THEN

4670: l_end_date_tab;
4671: CLOSE RES_ASG1;
4672:
4673: IF l_res_list_member_id.count = 0 THEN
4674: IF P_PA_DEBUG_MODE = 'Y' THEN
4675: PA_DEBUG.Reset_Curr_Function;
4676: END IF;
4677: RETURN;
4678: END IF;

Line 4675: PA_DEBUG.Reset_Curr_Function;

4671: CLOSE RES_ASG1;
4672:
4673: IF l_res_list_member_id.count = 0 THEN
4674: IF P_PA_DEBUG_MODE = 'Y' THEN
4675: PA_DEBUG.Reset_Curr_Function;
4676: END IF;
4677: RETURN;
4678: END IF;
4679:

Line 4736: IF P_PA_DEBUG_MODE = 'Y' THEN

4732: l_end_date_tab;
4733: CLOSE RES_ASG2;
4734:
4735: IF l_res_list_member_id.count = 0 then
4736: IF P_PA_DEBUG_MODE = 'Y' THEN
4737: PA_DEBUG.Reset_Curr_Function;
4738: END IF;
4739: RETURN;
4740: END IF;

Line 4737: PA_DEBUG.Reset_Curr_Function;

4733: CLOSE RES_ASG2;
4734:
4735: IF l_res_list_member_id.count = 0 then
4736: IF P_PA_DEBUG_MODE = 'Y' THEN
4737: PA_DEBUG.Reset_Curr_Function;
4738: END IF;
4739: RETURN;
4740: END IF;
4741:

Line 4792: IF P_PA_DEBUG_MODE = 'Y' THEN

4788: l_end_date_tab;
4789: CLOSE RES_ASG3;
4790:
4791: IF l_res_list_member_id.count = 0 then
4792: IF P_PA_DEBUG_MODE = 'Y' THEN
4793: PA_DEBUG.Reset_Curr_Function;
4794: END IF;
4795: RETURN;
4796: END IF;

Line 4793: PA_DEBUG.Reset_Curr_Function;

4789: CLOSE RES_ASG3;
4790:
4791: IF l_res_list_member_id.count = 0 then
4792: IF P_PA_DEBUG_MODE = 'Y' THEN
4793: PA_DEBUG.Reset_Curr_Function;
4794: END IF;
4795: RETURN;
4796: END IF;
4797: FORALL i IN 1..l_res_list_member_id.count

Line 4850: IF P_PA_DEBUG_MODE = 'Y' THEN

4846: l_end_date_tab;
4847: CLOSE RES_ASG4;
4848:
4849: IF l_res_list_member_id.count = 0 then
4850: IF P_PA_DEBUG_MODE = 'Y' THEN
4851: PA_DEBUG.Reset_Curr_Function;
4852: END IF;
4853: RETURN;
4854: END IF;

Line 4851: PA_DEBUG.Reset_Curr_Function;

4847: CLOSE RES_ASG4;
4848:
4849: IF l_res_list_member_id.count = 0 then
4850: IF P_PA_DEBUG_MODE = 'Y' THEN
4851: PA_DEBUG.Reset_Curr_Function;
4852: END IF;
4853: RETURN;
4854: END IF;
4855: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4855: IF P_PA_DEBUG_MODE = 'Y' THEN

4851: PA_DEBUG.Reset_Curr_Function;
4852: END IF;
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)

Line 4924: IF P_PA_DEBUG_MODE = 'Y' THEN

4920: l_end_date_tab;
4921: CLOSE RES_ASG5;
4922:
4923: IF l_res_list_member_id.count = 0 then
4924: IF P_PA_DEBUG_MODE = 'Y' THEN
4925: PA_DEBUG.Reset_Curr_Function;
4926: END IF;
4927: RETURN;
4928: END IF;

Line 4925: PA_DEBUG.Reset_Curr_Function;

4921: CLOSE RES_ASG5;
4922:
4923: IF l_res_list_member_id.count = 0 then
4924: IF P_PA_DEBUG_MODE = 'Y' THEN
4925: PA_DEBUG.Reset_Curr_Function;
4926: END IF;
4927: RETURN;
4928: END IF;
4929: FORALL i IN 1..l_res_list_member_id.count

Line 4969: IF P_PA_DEBUG_MODE = 'Y' THEN

4965: RETURNING resource_assignment_id BULK COLLECT INTO l_ins_ra_id_tbl;
4966: END IF;
4967:
4968: IF SQL%ROWCOUNT = 0 THEN
4969: IF P_PA_DEBUG_MODE = 'Y' THEN
4970: PA_DEBUG.Reset_Curr_Function;
4971: END IF;
4972: RETURN;
4973: END IF;

Line 4970: PA_DEBUG.Reset_Curr_Function;

4966: END IF;
4967:
4968: IF SQL%ROWCOUNT = 0 THEN
4969: IF P_PA_DEBUG_MODE = 'Y' THEN
4970: PA_DEBUG.Reset_Curr_Function;
4971: END IF;
4972: RETURN;
4973: END IF;
4974: --dbms_output.put_line('before res_list_map');

Line 5000: IF p_pa_debug_mode = 'Y' THEN

4996: l_da_resource_list_members_tab(kk) := l_unique_rlm_id_tab(kk);
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,

Line 5055: IF p_pa_debug_mode = 'Y' THEN

5051: --dbms_output.put_line('after get_resource_defaults:'||x_return_status);
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,

Line 5119: IF P_PA_DEBUG_MODE = 'Y' THEN

5115: AND RESOURCE_LIST_MEMBER_ID = l_da_resource_list_members_tab(i)
5116: AND (resource_assignment_id
5117: BETWEEN l_ins_ra_id_tbl(l_ins_ra_id_tbl.FIRST) AND l_ins_ra_id_tbl(l_ins_ra_id_tbl.LAST));
5118:
5119: IF P_PA_DEBUG_MODE = 'Y' THEN
5120: PA_DEBUG.Reset_Curr_Function;
5121: END IF;
5122: RETURN;
5123:

Line 5120: PA_DEBUG.Reset_Curr_Function;

5116: AND (resource_assignment_id
5117: BETWEEN l_ins_ra_id_tbl(l_ins_ra_id_tbl.FIRST) AND l_ins_ra_id_tbl(l_ins_ra_id_tbl.LAST));
5118:
5119: IF P_PA_DEBUG_MODE = 'Y' THEN
5120: PA_DEBUG.Reset_Curr_Function;
5121: END IF;
5122: RETURN;
5123:
5124: EXCEPTION

Line 5145: IF P_PA_DEBUG_MODE = 'Y' THEN

5141: END IF;
5142: ROLLBACK;
5143: x_return_status := FND_API.G_RET_STS_ERROR;
5144:
5145: IF P_PA_DEBUG_MODE = 'Y' THEN
5146: PA_DEBUG.Reset_Curr_Function;
5147: END IF;
5148: WHEN OTHERS THEN
5149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5146: PA_DEBUG.Reset_Curr_Function;

5142: ROLLBACK;
5143: x_return_status := FND_API.G_RET_STS_ERROR;
5144:
5145: IF P_PA_DEBUG_MODE = 'Y' THEN
5146: PA_DEBUG.Reset_Curr_Function;
5147: END IF;
5148: WHEN OTHERS THEN
5149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5150: x_msg_data := SUBSTR(SQLERRM,1,240);

Line 5157: IF P_PA_DEBUG_MODE = 'Y' THEN

5153: FND_MSG_PUB.add_exc_msg
5154: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5155: ,p_procedure_name => 'CREATE_RES_ASG');
5156:
5157: IF P_PA_DEBUG_MODE = 'Y' THEN
5158: PA_DEBUG.Reset_Curr_Function;
5159: END IF;
5160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5161:

Line 5158: PA_DEBUG.Reset_Curr_Function;

5154: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5155: ,p_procedure_name => 'CREATE_RES_ASG');
5156:
5157: IF P_PA_DEBUG_MODE = 'Y' THEN
5158: PA_DEBUG.Reset_Curr_Function;
5159: END IF;
5160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5161:
5162: END CREATE_RES_ASG;

Line 5211: IF p_pa_debug_mode = 'Y' THEN

5207: BEGIN
5208: X_MSG_COUNT := 0;
5209: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5210:
5211: IF p_pa_debug_mode = 'Y' THEN
5212: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG'
5213: ,p_debug_mode => p_pa_debug_mode);
5214: END IF;
5215: l_project_id := p_project_id;

Line 5212: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG'

5208: X_MSG_COUNT := 0;
5209: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5210:
5211: IF p_pa_debug_mode = 'Y' THEN
5212: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG'
5213: ,p_debug_mode => p_pa_debug_mode);
5214: END IF;
5215: l_project_id := p_project_id;
5216:

Line 5213: ,p_debug_mode => p_pa_debug_mode);

5209: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5210:
5211: IF p_pa_debug_mode = 'Y' THEN
5212: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG'
5213: ,p_debug_mode => p_pa_debug_mode);
5214: END IF;
5215: l_project_id := p_project_id;
5216:
5217: l_stru_sharing_code := PA_PROJECT_STRUCTURE_UTILS.

Line 5353: IF P_PA_DEBUG_MODE = 'Y' THEN

5349: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID
5350: AND NVL(P.TASK_ID,0) = 0 );
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)

Line 5555: IF P_PA_DEBUG_MODE = 'Y' THEN

5551: FROM pa_res_list_map_tmp4 tmp
5552: WHERE tmp.txn_resource_assignment_id = resource_assignment_id
5553: AND rownum = 1 );
5554:
5555: IF P_PA_DEBUG_MODE = 'Y' THEN
5556: PA_DEBUG.Reset_Curr_Function;
5557: END IF;
5558: RETURN;
5559:

Line 5556: PA_DEBUG.Reset_Curr_Function;

5552: WHERE tmp.txn_resource_assignment_id = resource_assignment_id
5553: AND rownum = 1 );
5554:
5555: IF P_PA_DEBUG_MODE = 'Y' THEN
5556: PA_DEBUG.Reset_Curr_Function;
5557: END IF;
5558: RETURN;
5559:
5560: EXCEPTION

Line 5567: IF P_PA_DEBUG_MODE = 'Y' THEN

5563: x_msg_data := SUBSTR(SQLERRM,1,240);
5564: FND_MSG_PUB.add_exc_msg
5565: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5566: ,p_procedure_name => 'UPDATE_RES_ASG');
5567: IF P_PA_DEBUG_MODE = 'Y' THEN
5568: PA_DEBUG.Reset_Curr_Function;
5569: END IF;
5570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5571:

Line 5568: PA_DEBUG.Reset_Curr_Function;

5564: FND_MSG_PUB.add_exc_msg
5565: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5566: ,p_procedure_name => 'UPDATE_RES_ASG');
5567: IF P_PA_DEBUG_MODE = 'Y' THEN
5568: PA_DEBUG.Reset_Curr_Function;
5569: END IF;
5570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5571:
5572: END UPDATE_RES_ASG;

Line 5603: IF p_pa_debug_mode = 'Y' THEN

5599:
5600: X_MSG_COUNT := 0;
5601: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5602:
5603: IF p_pa_debug_mode = 'Y' THEN
5604: pa_debug.set_curr_function( p_function => 'DEL_MANUAL_BDGT_LINES'
5605: ,p_debug_mode => p_pa_debug_mode);
5606: END IF;
5607:

Line 5604: pa_debug.set_curr_function( p_function => 'DEL_MANUAL_BDGT_LINES'

5600: X_MSG_COUNT := 0;
5601: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5602:
5603: IF p_pa_debug_mode = 'Y' THEN
5604: pa_debug.set_curr_function( p_function => 'DEL_MANUAL_BDGT_LINES'
5605: ,p_debug_mode => p_pa_debug_mode);
5606: END IF;
5607:
5608: FOR i IN 1..PX_RES_ASG_ID_TAB.count LOOP

Line 5605: ,p_debug_mode => p_pa_debug_mode);

5601: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5602:
5603: IF p_pa_debug_mode = 'Y' THEN
5604: pa_debug.set_curr_function( p_function => 'DEL_MANUAL_BDGT_LINES'
5605: ,p_debug_mode => p_pa_debug_mode);
5606: END IF;
5607:
5608: FOR i IN 1..PX_RES_ASG_ID_TAB.count LOOP
5609: l_del_res_asg_id_tab(i) := PX_RES_ASG_ID_TAB(i);

Line 5639: IF p_pa_debug_mode = 'Y' THEN

5635: FORALL i in 1..PX_DELETED_RES_ASG_ID_TAB.count
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,

Line 5656: IF p_pa_debug_mode = 'Y' THEN

5652:
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,

Line 5665: IF P_PA_DEBUG_MODE = 'Y' THEN

5661: p_module_name => l_module_name,
5662: p_log_level => 5);
5663: END IF;
5664:
5665: IF P_PA_DEBUG_MODE = 'Y' THEN
5666: PA_DEBUG.Reset_Curr_Function;
5667: END IF;
5668:
5669: EXCEPTION

Line 5666: PA_DEBUG.Reset_Curr_Function;

5662: p_log_level => 5);
5663: END IF;
5664:
5665: IF P_PA_DEBUG_MODE = 'Y' THEN
5666: PA_DEBUG.Reset_Curr_Function;
5667: END IF;
5668:
5669: EXCEPTION
5670: WHEN OTHERS THEN

Line 5677: IF P_PA_DEBUG_MODE = 'Y' THEN

5673: FND_MSG_PUB.add_exc_msg
5674: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5675: ,p_procedure_name => 'DEL_MANUAL_BDGT_LINES');
5676:
5677: IF P_PA_DEBUG_MODE = 'Y' THEN
5678: PA_DEBUG.Reset_Curr_Function;
5679: END IF;
5680:
5681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5678: PA_DEBUG.Reset_Curr_Function;

5674: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5675: ,p_procedure_name => 'DEL_MANUAL_BDGT_LINES');
5676:
5677: IF P_PA_DEBUG_MODE = 'Y' THEN
5678: PA_DEBUG.Reset_Curr_Function;
5679: END IF;
5680:
5681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5682: END DEL_MANUAL_BDGT_LINES;

Line 5700: IF p_pa_debug_mode = 'Y' THEN

5696:
5697: X_MSG_COUNT := 0;
5698: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5699:
5700: IF p_pa_debug_mode = 'Y' THEN
5701: pa_debug.set_curr_function( p_function => 'UPDATE_INIT_AMOUNTS'
5702: ,p_debug_mode => p_pa_debug_mode);
5703: END IF;
5704:

Line 5701: pa_debug.set_curr_function( p_function => 'UPDATE_INIT_AMOUNTS'

5697: X_MSG_COUNT := 0;
5698: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5699:
5700: IF p_pa_debug_mode = 'Y' THEN
5701: pa_debug.set_curr_function( p_function => 'UPDATE_INIT_AMOUNTS'
5702: ,p_debug_mode => p_pa_debug_mode);
5703: END IF;
5704:
5705: FORALL i IN 1..P_RES_ASG_ID_TAB.count

Line 5702: ,p_debug_mode => p_pa_debug_mode);

5698: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5699:
5700: IF p_pa_debug_mode = 'Y' THEN
5701: pa_debug.set_curr_function( p_function => 'UPDATE_INIT_AMOUNTS'
5702: ,p_debug_mode => p_pa_debug_mode);
5703: END IF;
5704:
5705: FORALL i IN 1..P_RES_ASG_ID_TAB.count
5706: UPDATE PA_BUDGET_LINES

Line 5723: IF P_PA_DEBUG_MODE = 'Y' THEN

5719: TXN_INIT_BURDENED_COST = TXN_BURDENED_COST,
5720: TXN_INIT_REVENUE = TXN_REVENUE
5721: WHERE RESOURCE_ASSIGNMENT_ID = P_RES_ASG_ID_TAB(i);
5722:
5723: IF P_PA_DEBUG_MODE = 'Y' THEN
5724: PA_DEBUG.Reset_Curr_Function;
5725: END IF;
5726:
5727: EXCEPTION

Line 5724: PA_DEBUG.Reset_Curr_Function;

5720: TXN_INIT_REVENUE = TXN_REVENUE
5721: WHERE RESOURCE_ASSIGNMENT_ID = P_RES_ASG_ID_TAB(i);
5722:
5723: IF P_PA_DEBUG_MODE = 'Y' THEN
5724: PA_DEBUG.Reset_Curr_Function;
5725: END IF;
5726:
5727: EXCEPTION
5728: WHEN OTHERS THEN

Line 5735: IF P_PA_DEBUG_MODE = 'Y' THEN

5731: FND_MSG_PUB.add_exc_msg
5732: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5733: ,p_procedure_name => 'UPDATE_INIT_AMOUNTS');
5734:
5735: IF P_PA_DEBUG_MODE = 'Y' THEN
5736: PA_DEBUG.Reset_Curr_Function;
5737: END IF;
5738:
5739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5736: PA_DEBUG.Reset_Curr_Function;

5732: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5733: ,p_procedure_name => 'UPDATE_INIT_AMOUNTS');
5734:
5735: IF P_PA_DEBUG_MODE = 'Y' THEN
5736: PA_DEBUG.Reset_Curr_Function;
5737: END IF;
5738:
5739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5740:

Line 5764: IF p_pa_debug_mode = 'Y' THEN

5760:
5761: X_MSG_COUNT := 0;
5762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5763:
5764: IF p_pa_debug_mode = 'Y' THEN
5765: pa_debug.set_curr_function( p_function => 'UPDATE_BV_FOR_GEN_DATE'
5766: ,p_debug_mode => p_pa_debug_mode);
5767: END IF;
5768:

Line 5765: pa_debug.set_curr_function( p_function => 'UPDATE_BV_FOR_GEN_DATE'

5761: X_MSG_COUNT := 0;
5762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5763:
5764: IF p_pa_debug_mode = 'Y' THEN
5765: pa_debug.set_curr_function( p_function => 'UPDATE_BV_FOR_GEN_DATE'
5766: ,p_debug_mode => p_pa_debug_mode);
5767: END IF;
5768:
5769: UPDATE PA_BUDGET_VERSIONS

Line 5766: ,p_debug_mode => p_pa_debug_mode);

5762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5763:
5764: IF p_pa_debug_mode = 'Y' THEN
5765: pa_debug.set_curr_function( p_function => 'UPDATE_BV_FOR_GEN_DATE'
5766: ,p_debug_mode => p_pa_debug_mode);
5767: END IF;
5768:
5769: UPDATE PA_BUDGET_VERSIONS
5770: SET LAST_AMT_GEN_DATE = l_sysdate,

Line 5780: IF P_PA_DEBUG_MODE = 'Y' THEN

5776: record_version_number = nvl(record_version_number,0)+1,
5777: ETC_START_DATE = p_etc_start_date
5778: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
5779:
5780: IF P_PA_DEBUG_MODE = 'Y' THEN
5781: PA_DEBUG.Reset_Curr_Function;
5782: END IF;
5783:
5784: EXCEPTION

Line 5781: PA_DEBUG.Reset_Curr_Function;

5777: ETC_START_DATE = p_etc_start_date
5778: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
5779:
5780: IF P_PA_DEBUG_MODE = 'Y' THEN
5781: PA_DEBUG.Reset_Curr_Function;
5782: END IF;
5783:
5784: EXCEPTION
5785: WHEN OTHERS THEN

Line 5793: IF P_PA_DEBUG_MODE = 'Y' THEN

5789: FND_MSG_PUB.add_exc_msg
5790: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5791: ,p_procedure_name => 'UPDATE_BV_FOR_GEN_DATE');
5792:
5793: IF P_PA_DEBUG_MODE = 'Y' THEN
5794: PA_DEBUG.Reset_Curr_Function;
5795: END IF;
5796:
5797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5794: PA_DEBUG.Reset_Curr_Function;

5790: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5791: ,p_procedure_name => 'UPDATE_BV_FOR_GEN_DATE');
5792:
5793: IF P_PA_DEBUG_MODE = 'Y' THEN
5794: PA_DEBUG.Reset_Curr_Function;
5795: END IF;
5796:
5797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5798:

Line 5819: IF p_pa_debug_mode = 'Y' THEN

5815: BEGIN
5816: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5817: X_MSG_COUNT := 0;
5818:
5819: IF p_pa_debug_mode = 'Y' THEN
5820: pa_debug.set_curr_function( p_function => 'GET_GENERATED_RES_ASG'
5821: ,p_debug_mode => p_pa_debug_mode);
5822: END IF;
5823:

Line 5820: pa_debug.set_curr_function( p_function => 'GET_GENERATED_RES_ASG'

5816: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5817: X_MSG_COUNT := 0;
5818:
5819: IF p_pa_debug_mode = 'Y' THEN
5820: pa_debug.set_curr_function( p_function => 'GET_GENERATED_RES_ASG'
5821: ,p_debug_mode => p_pa_debug_mode);
5822: END IF;
5823:
5824: /* For first time call PA_GEN_RES_ASG_ID_TAB will

Line 5821: ,p_debug_mode => p_pa_debug_mode);

5817: X_MSG_COUNT := 0;
5818:
5819: IF p_pa_debug_mode = 'Y' THEN
5820: pa_debug.set_curr_function( p_function => 'GET_GENERATED_RES_ASG'
5821: ,p_debug_mode => p_pa_debug_mode);
5822: END IF;
5823:
5824: /* For first time call PA_GEN_RES_ASG_ID_TAB will
5825: be empty so it is bulk collected from tmp4 table*/

Line 5858: IF P_PA_DEBUG_MODE = 'Y' THEN

5854: END IF;
5855: END LOOP;
5856: END IF;
5857:
5858: IF P_PA_DEBUG_MODE = 'Y' THEN
5859: PA_DEBUG.Reset_Curr_Function;
5860: END IF;
5861:
5862: EXCEPTION

Line 5859: PA_DEBUG.Reset_Curr_Function;

5855: END LOOP;
5856: END IF;
5857:
5858: IF P_PA_DEBUG_MODE = 'Y' THEN
5859: PA_DEBUG.Reset_Curr_Function;
5860: END IF;
5861:
5862: EXCEPTION
5863: WHEN OTHERS THEN

Line 5870: IF P_PA_DEBUG_MODE = 'Y' THEN

5866: FND_MSG_PUB.add_exc_msg
5867: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5868: ,p_procedure_name => 'GET_GENERATED_RES_ASG');
5869:
5870: IF P_PA_DEBUG_MODE = 'Y' THEN
5871: PA_DEBUG.Reset_Curr_Function;
5872: END IF;
5873:
5874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5871: PA_DEBUG.Reset_Curr_Function;

5867: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5868: ,p_procedure_name => 'GET_GENERATED_RES_ASG');
5869:
5870: IF P_PA_DEBUG_MODE = 'Y' THEN
5871: PA_DEBUG.Reset_Curr_Function;
5872: END IF;
5873:
5874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5875: END GET_GENERATED_RES_ASG;

Line 5920: IF p_pa_debug_mode = 'Y' THEN

5916: BEGIN
5917: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5918: X_MSG_COUNT := 0;
5919:
5920: IF p_pa_debug_mode = 'Y' THEN
5921: pa_debug.set_curr_function( p_function => 'INSERT_TXN_CURRENCY'
5922: ,p_debug_mode => p_pa_debug_mode);
5923: END IF;
5924:

Line 5921: pa_debug.set_curr_function( p_function => 'INSERT_TXN_CURRENCY'

5917: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5918: X_MSG_COUNT := 0;
5919:
5920: IF p_pa_debug_mode = 'Y' THEN
5921: pa_debug.set_curr_function( p_function => 'INSERT_TXN_CURRENCY'
5922: ,p_debug_mode => p_pa_debug_mode);
5923: END IF;
5924:
5925: l_fp_cols_rec := P_FP_COLS_REC;

Line 5922: ,p_debug_mode => p_pa_debug_mode);

5918: X_MSG_COUNT := 0;
5919:
5920: IF p_pa_debug_mode = 'Y' THEN
5921: pa_debug.set_curr_function( p_function => 'INSERT_TXN_CURRENCY'
5922: ,p_debug_mode => p_pa_debug_mode);
5923: END IF;
5924:
5925: l_fp_cols_rec := P_FP_COLS_REC;
5926:

Line 5933: IF p_pa_debug_mode = 'Y' THEN

5929: IF ( l_fp_cols_rec.x_proj_fp_options_id is null
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,

Line 5952: IF p_pa_debug_mode = 'Y' THEN

5948:
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,

Line 6078: IF P_PA_DEBUG_MODE = 'Y' THEN

6074: l_sysdate );
6075:
6076: END LOOP; -- FOR j IN l_proj_fp_options_id_tbl.first .. l_proj_fp_options_id_tbl.last
6077:
6078: IF P_PA_DEBUG_MODE = 'Y' THEN
6079: PA_DEBUG.Reset_Curr_Function;
6080: END IF;
6081:
6082: EXCEPTION

Line 6079: PA_DEBUG.Reset_Curr_Function;

6075:
6076: END LOOP; -- FOR j IN l_proj_fp_options_id_tbl.first .. l_proj_fp_options_id_tbl.last
6077:
6078: IF P_PA_DEBUG_MODE = 'Y' THEN
6079: PA_DEBUG.Reset_Curr_Function;
6080: END IF;
6081:
6082: EXCEPTION
6083: WHEN OTHERS THEN

Line 6090: IF P_PA_DEBUG_MODE = 'Y' THEN

6086: FND_MSG_PUB.add_exc_msg
6087: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6088: ,p_procedure_name => 'INSERT_TXN_CURRENCY');
6089:
6090: IF P_PA_DEBUG_MODE = 'Y' THEN
6091: PA_DEBUG.Reset_Curr_Function;
6092: END IF;
6093:
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6091: PA_DEBUG.Reset_Curr_Function;

6087: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6088: ,p_procedure_name => 'INSERT_TXN_CURRENCY');
6089:
6090: IF P_PA_DEBUG_MODE = 'Y' THEN
6091: PA_DEBUG.Reset_Curr_Function;
6092: END IF;
6093:
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END INSERT_TXN_CURRENCY;

Line 6108: IF p_pa_debug_mode = 'Y' THEN

6104:
6105: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6106: X_MSG_COUNT := 0;
6107:
6108: IF p_pa_debug_mode = 'Y' THEN
6109: pa_debug.set_curr_function( p_function => 'RESET_COST_AMOUNTS'
6110: ,p_debug_mode => p_pa_debug_mode);
6111: END IF;
6112:

Line 6109: pa_debug.set_curr_function( p_function => 'RESET_COST_AMOUNTS'

6105: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6106: X_MSG_COUNT := 0;
6107:
6108: IF p_pa_debug_mode = 'Y' THEN
6109: pa_debug.set_curr_function( p_function => 'RESET_COST_AMOUNTS'
6110: ,p_debug_mode => p_pa_debug_mode);
6111: END IF;
6112:
6113: UPDATE PA_BUDGET_LINES

Line 6110: ,p_debug_mode => p_pa_debug_mode);

6106: X_MSG_COUNT := 0;
6107:
6108: IF p_pa_debug_mode = 'Y' THEN
6109: pa_debug.set_curr_function( p_function => 'RESET_COST_AMOUNTS'
6110: ,p_debug_mode => p_pa_debug_mode);
6111: END IF;
6112:
6113: UPDATE PA_BUDGET_LINES
6114: SET RAW_COST = null,

Line 6130: IF P_PA_DEBUG_MODE = 'Y' THEN

6126: PROJECT_COST_RATE_DATE_TYPE = null,
6127: PROJECT_COST_RATE_DATE = null
6128: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
6129:
6130: IF P_PA_DEBUG_MODE = 'Y' THEN
6131: PA_DEBUG.Reset_Curr_Function;
6132: END IF;
6133:
6134: EXCEPTION

Line 6131: PA_DEBUG.Reset_Curr_Function;

6127: PROJECT_COST_RATE_DATE = null
6128: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
6129:
6130: IF P_PA_DEBUG_MODE = 'Y' THEN
6131: PA_DEBUG.Reset_Curr_Function;
6132: END IF;
6133:
6134: EXCEPTION
6135: WHEN OTHERS THEN

Line 6142: IF P_PA_DEBUG_MODE = 'Y' THEN

6138: FND_MSG_PUB.add_exc_msg
6139: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6140: ,p_procedure_name => 'RESET_COST_AMOUNTS');
6141:
6142: IF P_PA_DEBUG_MODE = 'Y' THEN
6143: PA_DEBUG.Reset_Curr_Function;
6144: END IF;
6145:
6146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6143: PA_DEBUG.Reset_Curr_Function;

6139: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6140: ,p_procedure_name => 'RESET_COST_AMOUNTS');
6141:
6142: IF P_PA_DEBUG_MODE = 'Y' THEN
6143: PA_DEBUG.Reset_Curr_Function;
6144: END IF;
6145:
6146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6147:

Line 6284: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

6280: END IF;
6281: X_MSG_COUNT := 0;
6282: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6283:
6284: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6285: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6286: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6287: pa_debug.set_curr_function( p_function => 'GEN_REV_BDGT_AMT_RES_SCH_WRP',
6288: p_debug_mode => p_pa_debug_mode);

Line 6285: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');

6281: X_MSG_COUNT := 0;
6282: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6283:
6284: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6285: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6286: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6287: pa_debug.set_curr_function( p_function => 'GEN_REV_BDGT_AMT_RES_SCH_WRP',
6288: p_debug_mode => p_pa_debug_mode);
6289: END IF;

Line 6286: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

6282: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6283:
6284: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6285: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6286: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6287: pa_debug.set_curr_function( p_function => 'GEN_REV_BDGT_AMT_RES_SCH_WRP',
6288: p_debug_mode => p_pa_debug_mode);
6289: END IF;
6290:

Line 6287: pa_debug.set_curr_function( p_function => 'GEN_REV_BDGT_AMT_RES_SCH_WRP',

6283:
6284: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6285: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6286: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6287: pa_debug.set_curr_function( p_function => 'GEN_REV_BDGT_AMT_RES_SCH_WRP',
6288: p_debug_mode => p_pa_debug_mode);
6289: END IF;
6290:
6291:

Line 6288: p_debug_mode => p_pa_debug_mode);

6284: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6285: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6286: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6287: pa_debug.set_curr_function( p_function => 'GEN_REV_BDGT_AMT_RES_SCH_WRP',
6288: p_debug_mode => p_pa_debug_mode);
6289: END IF;
6290:
6291:
6292: IF p_pa_debug_mode = 'Y' THEN

Line 6292: IF p_pa_debug_mode = 'Y' THEN

6288: p_debug_mode => p_pa_debug_mode);
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,

Line 6324: IF p_pa_debug_mode = 'Y' THEN

6320: X_MSG_DATA => X_MSG_DATA);
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,

Line 6442: IF p_pa_debug_mode = 'Y' THEN

6438: AND fp.fin_plan_version_id = ra.budget_version_id
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);

Line 6525: IF p_pa_debug_mode = 'Y' THEN

6521: x_msg_count => x_msg_count);
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,

Line 6585: IF p_pa_debug_mode = 'Y' THEN

6581: -- Calculate API with values 'BUDGET_GENERATION' and 'N', respectively, so that calling
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',

Line 6635: IF p_pa_debug_mode = 'Y' THEN

6631: ,X_MSG_DATA => X_MSG_DATA);
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: '

Line 6649: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

6645: IF P_COMMIT_FLAG = 'Y' THEN
6646: COMMIT;
6647: END IF;
6648:
6649: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6650: PA_DEBUG.reset_err_stack;
6651: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6652: PA_DEBUG.Reset_Curr_Function;
6653: END IF;

Line 6650: PA_DEBUG.reset_err_stack;

6646: COMMIT;
6647: END IF;
6648:
6649: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6650: PA_DEBUG.reset_err_stack;
6651: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6652: PA_DEBUG.Reset_Curr_Function;
6653: END IF;
6654:

Line 6651: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

6647: END IF;
6648:
6649: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6650: PA_DEBUG.reset_err_stack;
6651: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6652: PA_DEBUG.Reset_Curr_Function;
6653: END IF;
6654:
6655: EXCEPTION

Line 6652: PA_DEBUG.Reset_Curr_Function;

6648:
6649: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6650: PA_DEBUG.reset_err_stack;
6651: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6652: PA_DEBUG.Reset_Curr_Function;
6653: END IF;
6654:
6655: EXCEPTION
6656: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 6676: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

6672: END IF;
6673: ROLLBACK;
6674: x_return_status := FND_API.G_RET_STS_ERROR;
6675:
6676: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6677: PA_DEBUG.reset_err_stack;
6678: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6679: PA_DEBUG.Reset_Curr_Function;
6680: END IF;

Line 6677: PA_DEBUG.reset_err_stack;

6673: ROLLBACK;
6674: x_return_status := FND_API.G_RET_STS_ERROR;
6675:
6676: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6677: PA_DEBUG.reset_err_stack;
6678: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6679: PA_DEBUG.Reset_Curr_Function;
6680: END IF;
6681:

Line 6678: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

6674: x_return_status := FND_API.G_RET_STS_ERROR;
6675:
6676: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6677: PA_DEBUG.reset_err_stack;
6678: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6679: PA_DEBUG.Reset_Curr_Function;
6680: END IF;
6681:
6682: WHEN OTHERS THEN

Line 6679: PA_DEBUG.Reset_Curr_Function;

6675:
6676: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6677: PA_DEBUG.reset_err_stack;
6678: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6679: PA_DEBUG.Reset_Curr_Function;
6680: END IF;
6681:
6682: WHEN OTHERS THEN
6683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6689: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

6685: FND_MSG_PUB.add_exc_msg
6686: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6687: ,p_procedure_name => 'GEN_REV_BDGT_AMT_RES_SCH_WRP');
6688:
6689: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6690: PA_DEBUG.reset_err_stack;
6691: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6692: PA_DEBUG.Reset_Curr_Function;
6693: END IF;

Line 6690: PA_DEBUG.reset_err_stack;

6686: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6687: ,p_procedure_name => 'GEN_REV_BDGT_AMT_RES_SCH_WRP');
6688:
6689: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6690: PA_DEBUG.reset_err_stack;
6691: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6692: PA_DEBUG.Reset_Curr_Function;
6693: END IF;
6694:

Line 6691: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

6687: ,p_procedure_name => 'GEN_REV_BDGT_AMT_RES_SCH_WRP');
6688:
6689: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6690: PA_DEBUG.reset_err_stack;
6691: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6692: PA_DEBUG.Reset_Curr_Function;
6693: END IF;
6694:
6695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6692: PA_DEBUG.Reset_Curr_Function;

6688:
6689: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6690: PA_DEBUG.reset_err_stack;
6691: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6692: PA_DEBUG.Reset_Curr_Function;
6693: END IF;
6694:
6695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6696:

Line 6830: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

6826: END IF;
6827: X_MSG_COUNT := 0;
6828: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6829:
6830: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6831: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6832: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6833: pa_debug.set_curr_function(p_function => 'GEN_WP_REV_BDGT_AMT_WRP',
6834: p_debug_mode => p_pa_debug_mode);

Line 6831: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');

6827: X_MSG_COUNT := 0;
6828: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6829:
6830: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6831: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6832: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6833: pa_debug.set_curr_function(p_function => 'GEN_WP_REV_BDGT_AMT_WRP',
6834: p_debug_mode => p_pa_debug_mode);
6835: END IF;

Line 6832: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

6828: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6829:
6830: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6831: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6832: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6833: pa_debug.set_curr_function(p_function => 'GEN_WP_REV_BDGT_AMT_WRP',
6834: p_debug_mode => p_pa_debug_mode);
6835: END IF;
6836:

Line 6833: pa_debug.set_curr_function(p_function => 'GEN_WP_REV_BDGT_AMT_WRP',

6829:
6830: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6831: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6832: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6833: pa_debug.set_curr_function(p_function => 'GEN_WP_REV_BDGT_AMT_WRP',
6834: p_debug_mode => p_pa_debug_mode);
6835: END IF;
6836:
6837: IF p_pa_debug_mode = 'Y' THEN

Line 6834: p_debug_mode => p_pa_debug_mode);

6830: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6831: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6832: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6833: pa_debug.set_curr_function(p_function => 'GEN_WP_REV_BDGT_AMT_WRP',
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

Line 6837: IF p_pa_debug_mode = 'Y' THEN

6833: pa_debug.set_curr_function(p_function => 'GEN_WP_REV_BDGT_AMT_WRP',
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',

Line 6868: IF p_pa_debug_mode = 'Y' THEN

6864: X_MSG_DATA => X_MSG_DATA);
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,

Line 6986: IF p_pa_debug_mode = 'Y' THEN

6982: AND fp.fin_plan_version_id = ra.budget_version_id
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);

Line 7069: IF p_pa_debug_mode = 'Y' THEN

7065: x_msg_count => x_msg_count);
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,

Line 7129: IF p_pa_debug_mode = 'Y' THEN

7125: -- Calculate API with values 'BUDGET_GENERATION' and 'N', respectively, so that calling
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,

Line 7178: IF p_pa_debug_mode = 'Y' THEN

7174: ,X_MSG_DATA => X_MSG_DATA);
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: '

Line 7192: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

7188: IF P_COMMIT_FLAG = 'Y' THEN
7189: COMMIT;
7190: END IF;
7191:
7192: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7193: PA_DEBUG.reset_err_stack;
7194: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7195: PA_DEBUG.Reset_Curr_Function;
7196: END IF;

Line 7193: PA_DEBUG.reset_err_stack;

7189: COMMIT;
7190: END IF;
7191:
7192: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7193: PA_DEBUG.reset_err_stack;
7194: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7195: PA_DEBUG.Reset_Curr_Function;
7196: END IF;
7197:

Line 7194: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

7190: END IF;
7191:
7192: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7193: PA_DEBUG.reset_err_stack;
7194: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7195: PA_DEBUG.Reset_Curr_Function;
7196: END IF;
7197:
7198: EXCEPTION

Line 7195: PA_DEBUG.Reset_Curr_Function;

7191:
7192: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7193: PA_DEBUG.reset_err_stack;
7194: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7195: PA_DEBUG.Reset_Curr_Function;
7196: END IF;
7197:
7198: EXCEPTION
7199: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 7219: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

7215: END IF;
7216: ROLLBACK;
7217: x_return_status := FND_API.G_RET_STS_ERROR;
7218:
7219: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7220: PA_DEBUG.reset_err_stack;
7221: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7222: PA_DEBUG.Reset_Curr_Function;
7223: END IF;

Line 7220: PA_DEBUG.reset_err_stack;

7216: ROLLBACK;
7217: x_return_status := FND_API.G_RET_STS_ERROR;
7218:
7219: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7220: PA_DEBUG.reset_err_stack;
7221: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7222: PA_DEBUG.Reset_Curr_Function;
7223: END IF;
7224: WHEN OTHERS THEN

Line 7221: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

7217: x_return_status := FND_API.G_RET_STS_ERROR;
7218:
7219: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7220: PA_DEBUG.reset_err_stack;
7221: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7222: PA_DEBUG.Reset_Curr_Function;
7223: END IF;
7224: WHEN OTHERS THEN
7225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7222: PA_DEBUG.Reset_Curr_Function;

7218:
7219: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7220: PA_DEBUG.reset_err_stack;
7221: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7222: PA_DEBUG.Reset_Curr_Function;
7223: END IF;
7224: WHEN OTHERS THEN
7225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7226: x_msg_data := SUBSTR(SQLERRM,1,240);

Line 7231: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

7227: FND_MSG_PUB.add_exc_msg
7228: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
7229: ,p_procedure_name => 'GEN_WP_REV_BDGT_AMT_WRP');
7230:
7231: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7232: PA_DEBUG.reset_err_stack;
7233: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7234: PA_DEBUG.Reset_Curr_Function;
7235: END IF;

Line 7232: PA_DEBUG.reset_err_stack;

7228: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
7229: ,p_procedure_name => 'GEN_WP_REV_BDGT_AMT_WRP');
7230:
7231: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7232: PA_DEBUG.reset_err_stack;
7233: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7234: PA_DEBUG.Reset_Curr_Function;
7235: END IF;
7236:

Line 7233: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

7229: ,p_procedure_name => 'GEN_WP_REV_BDGT_AMT_WRP');
7230:
7231: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7232: PA_DEBUG.reset_err_stack;
7233: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7234: PA_DEBUG.Reset_Curr_Function;
7235: END IF;
7236:
7237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7234: PA_DEBUG.Reset_Curr_Function;

7230:
7231: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7232: PA_DEBUG.reset_err_stack;
7233: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7234: PA_DEBUG.Reset_Curr_Function;
7235: END IF;
7236:
7237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7238: