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_CONTROL_ITEMS_IMPACT_PKG dependencies on PA_DEBUG

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

1: PACKAGE BODY Pa_Fp_Control_Items_Impact_Pkg AS
2: /* $Header: PAFPCIIB.pls 120.4.12010000.5 2009/06/29 08:12:25 vgovvala ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4: PROCEDURE Maintain_Ctrl_Item_Version(
5: p_project_id IN Pa_Projects_All.Project_Id%TYPE,
6: p_ci_id IN NUMBER,
7: p_fp_pref_code IN VARCHAR2,

Line 82: IF p_pa_debug_mode = 'Y' THEN

78: BEGIN
79: FND_MSG_PUB.initialize;
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: l_agreement_id := p_agreement_id;
82: IF p_pa_debug_mode = 'Y' THEN
83: PA_DEBUG.init_err_stack('p_button_pressed_from_page '||p_button_pressed_from_page);
84: END IF;
85:
86: IF p_pa_debug_mode = 'Y' THEN

Line 83: PA_DEBUG.init_err_stack('p_button_pressed_from_page '||p_button_pressed_from_page);

79: FND_MSG_PUB.initialize;
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: l_agreement_id := p_agreement_id;
82: IF p_pa_debug_mode = 'Y' THEN
83: PA_DEBUG.init_err_stack('p_button_pressed_from_page '||p_button_pressed_from_page);
84: END IF;
85:
86: IF p_pa_debug_mode = 'Y' THEN
87: pa_debug.g_err_stage:= 'Entering Maintain_Ctrl_Item_Version';

Line 86: IF p_pa_debug_mode = 'Y' THEN

82: IF p_pa_debug_mode = 'Y' THEN
83: PA_DEBUG.init_err_stack('p_button_pressed_from_page '||p_button_pressed_from_page);
84: END IF;
85:
86: IF p_pa_debug_mode = 'Y' THEN
87: pa_debug.g_err_stage:= 'Entering Maintain_Ctrl_Item_Version';
88: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debUg.g_err_stage,3);
89:
90: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;

Line 87: pa_debug.g_err_stage:= 'Entering Maintain_Ctrl_Item_Version';

83: PA_DEBUG.init_err_stack('p_button_pressed_from_page '||p_button_pressed_from_page);
84: END IF;
85:
86: IF p_pa_debug_mode = 'Y' THEN
87: pa_debug.g_err_stage:= 'Entering Maintain_Ctrl_Item_Version';
88: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debUg.g_err_stage,3);
89:
90: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
91: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);

Line 88: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debUg.g_err_stage,3);

84: END IF;
85:
86: IF p_pa_debug_mode = 'Y' THEN
87: pa_debug.g_err_stage:= 'Entering Maintain_Ctrl_Item_Version';
88: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debUg.g_err_stage,3);
89:
90: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
91: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
92:

Line 90: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;

86: IF p_pa_debug_mode = 'Y' THEN
87: pa_debug.g_err_stage:= 'Entering Maintain_Ctrl_Item_Version';
88: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debUg.g_err_stage,3);
89:
90: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
91: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
92:
93: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
94: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);

Line 91: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);

87: pa_debug.g_err_stage:= 'Entering Maintain_Ctrl_Item_Version';
88: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debUg.g_err_stage,3);
89:
90: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
91: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
92:
93: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
94: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
95: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;

Line 93: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;

89:
90: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
91: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
92:
93: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
94: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
95: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
96: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
97: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;

Line 94: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);

90: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
91: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
92:
93: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
94: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
95: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
96: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
97: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
98: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);

Line 95: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;

91: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
92:
93: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
94: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
95: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
96: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
97: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
98: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
99: END IF;

Line 96: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);

92:
93: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
94: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
95: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
96: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
97: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
98: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
99: END IF;
100:

Line 97: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;

93: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
94: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
95: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
96: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
97: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
98: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
99: END IF;
100:
101: SELECT COUNT(*) INTO l_no_of_app_plan_types FROM Pa_Proj_Fp_Options

Line 98: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);

94: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
95: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
96: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
97: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
98: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
99: END IF;
100:
101: SELECT COUNT(*) INTO l_no_of_app_plan_types FROM Pa_Proj_Fp_Options
102: WHERE

Line 142: IF p_pa_debug_mode = 'Y' THEN

138: /* End of Addition for bug 5210100 */
139:
140:
141: IF l_no_of_app_plan_types = 0 THEN
142: IF p_pa_debug_mode = 'Y' THEN
143: PA_DEBUG.write_log (x_module =>
144: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.approved_plan_types'
145: ,x_msg => 'no of approved plan types is zero'
146: ,x_log_level => 5);

Line 143: PA_DEBUG.write_log (x_module =>

139:
140:
141: IF l_no_of_app_plan_types = 0 THEN
142: IF p_pa_debug_mode = 'Y' THEN
143: PA_DEBUG.write_log (x_module =>
144: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.approved_plan_types'
145: ,x_msg => 'no of approved plan types is zero'
146: ,x_log_level => 5);
147: END IF;

Line 173: IF p_pa_debug_mode = 'Y' THEN

169: p_data => x_msg_data,
170: p_msg_index_out => l_msg_index_out );
171: -- x_msg_data := l_data;
172: END IF;
173: IF p_pa_debug_mode = 'Y' THEN
174: PA_DEBUG.Reset_Err_stack;
175: END IF;
176: RETURN;
177: END IF;

Line 174: PA_DEBUG.Reset_Err_stack;

170: p_msg_index_out => l_msg_index_out );
171: -- x_msg_data := l_data;
172: END IF;
173: IF p_pa_debug_mode = 'Y' THEN
174: PA_DEBUG.Reset_Err_stack;
175: END IF;
176: RETURN;
177: END IF;
178:

Line 230: IF p_pa_debug_mode = 'Y' THEN

226: NVL(l_est_qty,0) <> NVL(est_amt_rec.est_quantity,0) OR
227: NVL(l_est_equip_qty,0) <> NVL(est_amt_rec.est_equipment_quantity,0) OR
228: NVL(p_agreement_id,0) <> NVL(est_amt_rec.agreement_id,0) OR --Impact should be created even when only agreement is entered and saved
229: NVL(p_est_proj_revenue,0) <> NVL(est_amt_rec.est_project_revenue,0)THEN
230: IF p_pa_debug_mode = 'Y' THEN
231: PA_DEBUG.write_log (x_module =>
232: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.check_for_fp_impact'
233: ,x_msg => 'inside edit buttons check'
234: ,x_log_level => 5);

Line 231: PA_DEBUG.write_log (x_module =>

227: NVL(l_est_equip_qty,0) <> NVL(est_amt_rec.est_equipment_quantity,0) OR
228: NVL(p_agreement_id,0) <> NVL(est_amt_rec.agreement_id,0) OR --Impact should be created even when only agreement is entered and saved
229: NVL(p_est_proj_revenue,0) <> NVL(est_amt_rec.est_project_revenue,0)THEN
230: IF p_pa_debug_mode = 'Y' THEN
231: PA_DEBUG.write_log (x_module =>
232: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.check_for_fp_impact'
233: ,x_msg => 'inside edit buttons check'
234: ,x_log_level => 5);
235: END IF;

Line 239: IF p_pa_debug_mode = 'Y' THEN

235: END IF;
236: /* FP.M -The following function call is used to get the impact information
237: */
238: l_impact_type_code := Pa_Fp_Control_Items_Utils.is_impact_exists(p_ci_id);
239: IF p_pa_debug_mode = 'Y' THEN
240: PA_DEBUG.write_log (x_module => 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.calling_ci_impact_pkg'
241: ,x_msg => 'calling create ci impact '
242: ,x_log_level => 5);
243: END IF;

Line 240: PA_DEBUG.write_log (x_module => 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.calling_ci_impact_pkg'

236: /* FP.M -The following function call is used to get the impact information
237: */
238: l_impact_type_code := Pa_Fp_Control_Items_Utils.is_impact_exists(p_ci_id);
239: IF p_pa_debug_mode = 'Y' THEN
240: PA_DEBUG.write_log (x_module => 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.calling_ci_impact_pkg'
241: ,x_msg => 'calling create ci impact '
242: ,x_log_level => 5);
243: END IF;
244: /* FP.M - Apart from the record with Impact_type_code of FINPLAN

Line 284: IF p_pa_debug_mode = 'Y' THEN

280: p_msg_data => l_msg_data ,
281: p_data => x_msg_data,
282: p_msg_index_out => l_msg_index_out );
283: END IF;
284: IF p_pa_debug_mode = 'Y' THEN
285: PA_DEBUG.Reset_Err_stack;
286: END IF;
287: RETURN;
288: END IF;

Line 285: PA_DEBUG.Reset_Err_stack;

281: p_data => x_msg_data,
282: p_msg_index_out => l_msg_index_out );
283: END IF;
284: IF p_pa_debug_mode = 'Y' THEN
285: PA_DEBUG.Reset_Err_stack;
286: END IF;
287: RETURN;
288: END IF;
289: END IF;

Line 319: IF p_pa_debug_mode = 'Y' THEN

315: p_msg_data => l_msg_data ,
316: p_data => x_msg_data,
317: p_msg_index_out => l_msg_index_out );
318: END IF;
319: IF p_pa_debug_mode = 'Y' THEN
320: PA_DEBUG.Reset_Err_stack;
321: END IF;
322: RETURN;
323: END IF;

Line 320: PA_DEBUG.Reset_Err_stack;

316: p_data => x_msg_data,
317: p_msg_index_out => l_msg_index_out );
318: END IF;
319: IF p_pa_debug_mode = 'Y' THEN
320: PA_DEBUG.Reset_Err_stack;
321: END IF;
322: RETURN;
323: END IF;
324: END IF;

Line 377: IF p_pa_debug_mode = 'Y' THEN

373: p_msg_data => l_msg_data ,
374: p_data => x_msg_data,
375: p_msg_index_out => l_msg_index_out );
376: END IF;
377: IF p_pa_debug_mode = 'Y' THEN
378: PA_DEBUG.Reset_Err_stack;
379: END IF;
380: RETURN;
381: END IF;

Line 378: PA_DEBUG.Reset_Err_stack;

374: p_data => x_msg_data,
375: p_msg_index_out => l_msg_index_out );
376: END IF;
377: IF p_pa_debug_mode = 'Y' THEN
378: PA_DEBUG.Reset_Err_stack;
379: END IF;
380: RETURN;
381: END IF;
382: END IF;

Line 420: IF p_pa_debug_mode = 'Y' THEN

416: p_data => x_msg_data,
417: p_msg_index_out => l_msg_index_out );
418: -- x_msg_data := l_data;
419: END IF;
420: IF p_pa_debug_mode = 'Y' THEN
421: PA_DEBUG.Reset_Err_stack;
422: END IF;
423: RETURN;
424: END IF;

Line 421: PA_DEBUG.Reset_Err_stack;

417: p_msg_index_out => l_msg_index_out );
418: -- x_msg_data := l_data;
419: END IF;
420: IF p_pa_debug_mode = 'Y' THEN
421: PA_DEBUG.Reset_Err_stack;
422: END IF;
423: RETURN;
424: END IF;
425: ELSIF l_no_of_app_plan_types = 2 OR

Line 486: IF p_pa_debug_mode = 'Y' THEN

482: p_data => x_msg_data,
483: p_msg_index_out => l_msg_index_out );
484: -- x_msg_data := l_data;
485: END IF;
486: IF p_pa_debug_mode = 'Y' THEN
487: PA_DEBUG.Reset_Err_stack;
488: END IF;
489: RETURN;
490: END IF;

Line 487: PA_DEBUG.Reset_Err_stack;

483: p_msg_index_out => l_msg_index_out );
484: -- x_msg_data := l_data;
485: END IF;
486: IF p_pa_debug_mode = 'Y' THEN
487: PA_DEBUG.Reset_Err_stack;
488: END IF;
489: RETURN;
490: END IF;
491:

Line 537: IF p_pa_debug_mode = 'Y' THEN

533: p_msg_data => l_msg_data ,
534: p_data => x_msg_data,
535: p_msg_index_out => l_msg_index_out );
536: END IF;
537: IF p_pa_debug_mode = 'Y' THEN
538: PA_DEBUG.Reset_Err_stack;
539: END IF;
540: RETURN;
541: END IF;

Line 538: PA_DEBUG.Reset_Err_stack;

534: p_data => x_msg_data,
535: p_msg_index_out => l_msg_index_out );
536: END IF;
537: IF p_pa_debug_mode = 'Y' THEN
538: PA_DEBUG.Reset_Err_stack;
539: END IF;
540: RETURN;
541: END IF;
542: END IF;

Line 580: IF p_pa_debug_mode = 'Y' THEN

576: p_data => x_msg_data,
577: p_msg_index_out => l_msg_index_out );
578: -- x_msg_data := l_data;
579: END IF;
580: IF p_pa_debug_mode = 'Y' THEN
581: PA_DEBUG.Reset_Err_stack;
582: END IF;
583: RETURN;
584: END IF;

Line 581: PA_DEBUG.Reset_Err_stack;

577: p_msg_index_out => l_msg_index_out );
578: -- x_msg_data := l_data;
579: END IF;
580: IF p_pa_debug_mode = 'Y' THEN
581: PA_DEBUG.Reset_Err_stack;
582: END IF;
583: RETURN;
584: END IF;
585: END IF;

Line 666: IF p_pa_debug_mode = 'Y' THEN

662:
663: BEGIN
664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: IF p_pa_debug_mode = 'Y' THEN
667: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
668: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);
669:
670: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;

Line 667: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';

663: BEGIN
664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: IF p_pa_debug_mode = 'Y' THEN
667: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
668: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);
669:
670: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
671: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

Line 668: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);

664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: IF p_pa_debug_mode = 'Y' THEN
667: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
668: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);
669:
670: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
671: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
672:

Line 670: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;

666: IF p_pa_debug_mode = 'Y' THEN
667: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
668: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);
669:
670: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
671: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
672:
673: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
674: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

Line 671: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

667: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
668: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);
669:
670: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
671: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
672:
673: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
674: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
675:

Line 673: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;

669:
670: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
671: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
672:
673: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
674: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
675:
676: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
677: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

Line 674: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

670: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
671: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
672:
673: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
674: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
675:
676: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
677: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
678:

Line 676: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;

672:
673: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
674: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
675:
676: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
677: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
678:
679: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
680: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

Line 677: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

673: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
674: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
675:
676: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
677: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
678:
679: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
680: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
681:

Line 679: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;

675:
676: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
677: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
678:
679: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
680: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
681:
682: pa_debug.g_err_stage:= 'p_element_type' || p_element_type;
683: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3); /* bug 7584903 */

Line 680: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

676: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
677: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
678:
679: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
680: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
681:
682: pa_debug.g_err_stage:= 'p_element_type' || p_element_type;
683: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3); /* bug 7584903 */
684:

Line 682: pa_debug.g_err_stage:= 'p_element_type' || p_element_type;

678:
679: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
680: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
681:
682: pa_debug.g_err_stage:= 'p_element_type' || p_element_type;
683: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3); /* bug 7584903 */
684:
685: END IF;
686: l_create_ver_called_flag := 'N';

Line 683: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3); /* bug 7584903 */

679: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
680: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
681:
682: pa_debug.g_err_stage:= 'p_element_type' || p_element_type;
683: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3); /* bug 7584903 */
684:
685: END IF;
686: l_create_ver_called_flag := 'N';
687:

Line 926: IF p_pa_debug_mode = 'Y' THEN

922: l_module VARCHAR2(255);
923: BEGIN
924: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';
925:
926: IF p_pa_debug_mode = 'Y' THEN
927: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');
928: PA_DEBUG.write_log (x_module => l_module
929: ,x_msg => 'inside del API call'
930: ,x_log_level => 5);

Line 927: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');

923: BEGIN
924: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';
925:
926: IF p_pa_debug_mode = 'Y' THEN
927: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');
928: PA_DEBUG.write_log (x_module => l_module
929: ,x_msg => 'inside del API call'
930: ,x_log_level => 5);
931: END IF;

Line 928: PA_DEBUG.write_log (x_module => l_module

924: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';
925:
926: IF p_pa_debug_mode = 'Y' THEN
927: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');
928: PA_DEBUG.write_log (x_module => l_module
929: ,x_msg => 'inside del API call'
930: ,x_log_level => 5);
931: END IF;
932:

Line 958: IF p_pa_debug_mode = 'Y' THEN

954: l_chk := 1;
955: END;
956:
957: FOR I IN 1 .. l_bv_id_tab.COUNT LOOP
958: IF p_pa_debug_mode = 'Y' THEN
959: PA_DEBUG.write_log (x_module => l_module
960: ,x_msg => 'before calling dele version in finplan pub'
961: ,x_log_level => 5);
962: END IF;

Line 959: PA_DEBUG.write_log (x_module => l_module

955: END;
956:
957: FOR I IN 1 .. l_bv_id_tab.COUNT LOOP
958: IF p_pa_debug_mode = 'Y' THEN
959: PA_DEBUG.write_log (x_module => l_module
960: ,x_msg => 'before calling dele version in finplan pub'
961: ,x_log_level => 5);
962: END IF;
963: pa_fin_plan_pub.Delete_Version(

Line 983: IF p_pa_debug_mode = 'Y' THEN

979: p_msg_data => l_msg_data ,
980: p_data => x_msg_data,
981: p_msg_index_out => l_msg_index_out );
982: END IF;
983: IF p_pa_debug_mode = 'Y' THEN
984: PA_DEBUG.Reset_Err_stack;
985: END IF;
986: RETURN;
987: END IF;

Line 984: PA_DEBUG.Reset_Err_stack;

980: p_data => x_msg_data,
981: p_msg_index_out => l_msg_index_out );
982: END IF;
983: IF p_pa_debug_mode = 'Y' THEN
984: PA_DEBUG.Reset_Err_stack;
985: END IF;
986: RETURN;
987: END IF;
988:

Line 1000: IF p_pa_debug_mode = 'Y' THEN

996:
997: IF p_commit_flag = 'Y' THEN
998: COMMIT;
999: END IF;
1000: IF p_pa_debug_mode = 'Y' THEN
1001: PA_DEBUG.Reset_Err_stack;
1002: END IF;
1003: RETURN;
1004: EXCEPTION

Line 1001: PA_DEBUG.Reset_Err_stack;

997: IF p_commit_flag = 'Y' THEN
998: COMMIT;
999: END IF;
1000: IF p_pa_debug_mode = 'Y' THEN
1001: PA_DEBUG.Reset_Err_stack;
1002: END IF;
1003: RETURN;
1004: EXCEPTION
1005: WHEN OTHERS THEN

Line 1007: IF p_pa_debug_mode = 'Y' THEN

1003: RETURN;
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: ROLLBACK;
1007: IF p_pa_debug_mode = 'Y' THEN
1008: PA_DEBUG.Reset_Err_stack;
1009: END IF;
1010:
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1008: PA_DEBUG.Reset_Err_stack;

1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: ROLLBACK;
1007: IF p_pa_debug_mode = 'Y' THEN
1008: PA_DEBUG.Reset_Err_stack;
1009: END IF;
1010:
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',