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.3 2008/11/18 15:41:06 bnoorbha 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 79: IF p_pa_debug_mode = 'Y' THEN

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

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

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

Line 83: IF p_pa_debug_mode = 'Y' THEN

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

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

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

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

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

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

83: IF p_pa_debug_mode = 'Y' THEN
84: pa_debug.g_err_stage:= 'Entering Maintain_Ctrl_Item_Version';
85: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debUg.g_err_stage,3);
86:
87: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
88: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
89:
90: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_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: pa_debug.g_err_stage:= 'Entering Maintain_Ctrl_Item_Version';
85: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debUg.g_err_stage,3);
86:
87: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
88: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
89:
90: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
91: pa_debug.write('Maintain_Ctrl_Item_Version',pa_debug.g_err_stage,3);
92: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;

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

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

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

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

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

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

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

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

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

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

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

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

Line 139: IF p_pa_debug_mode = 'Y' THEN

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

Line 140: PA_DEBUG.write_log (x_module =>

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

Line 170: IF p_pa_debug_mode = 'Y' THEN

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

Line 171: PA_DEBUG.Reset_Err_stack;

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

Line 226: IF p_pa_debug_mode = 'Y' THEN

222: NVL(l_est_qty,0) <> NVL(est_amt_rec.est_quantity,0) OR
223: NVL(l_est_equip_qty,0) <> NVL(est_amt_rec.est_equipment_quantity,0) OR
224: 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
225: NVL(p_est_proj_revenue,0) <> NVL(est_amt_rec.est_project_revenue,0)THEN
226: IF p_pa_debug_mode = 'Y' THEN
227: PA_DEBUG.write_log (x_module =>
228: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.check_for_fp_impact'
229: ,x_msg => 'inside edit buttons check'
230: ,x_log_level => 5);

Line 227: PA_DEBUG.write_log (x_module =>

223: NVL(l_est_equip_qty,0) <> NVL(est_amt_rec.est_equipment_quantity,0) OR
224: 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
225: NVL(p_est_proj_revenue,0) <> NVL(est_amt_rec.est_project_revenue,0)THEN
226: IF p_pa_debug_mode = 'Y' THEN
227: PA_DEBUG.write_log (x_module =>
228: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.check_for_fp_impact'
229: ,x_msg => 'inside edit buttons check'
230: ,x_log_level => 5);
231: END IF;

Line 235: IF p_pa_debug_mode = 'Y' THEN

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

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

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

Line 280: IF p_pa_debug_mode = 'Y' THEN

276: p_msg_data => l_msg_data ,
277: p_data => x_msg_data,
278: p_msg_index_out => l_msg_index_out );
279: END IF;
280: IF p_pa_debug_mode = 'Y' THEN
281: PA_DEBUG.Reset_Err_stack;
282: END IF;
283: RETURN;
284: END IF;

Line 281: PA_DEBUG.Reset_Err_stack;

277: p_data => x_msg_data,
278: p_msg_index_out => l_msg_index_out );
279: END IF;
280: IF p_pa_debug_mode = 'Y' THEN
281: PA_DEBUG.Reset_Err_stack;
282: END IF;
283: RETURN;
284: END IF;
285: END IF;

Line 315: IF p_pa_debug_mode = 'Y' THEN

311: p_msg_data => l_msg_data ,
312: p_data => x_msg_data,
313: p_msg_index_out => l_msg_index_out );
314: END IF;
315: IF p_pa_debug_mode = 'Y' THEN
316: PA_DEBUG.Reset_Err_stack;
317: END IF;
318: RETURN;
319: END IF;

Line 316: PA_DEBUG.Reset_Err_stack;

312: p_data => x_msg_data,
313: p_msg_index_out => l_msg_index_out );
314: END IF;
315: IF p_pa_debug_mode = 'Y' THEN
316: PA_DEBUG.Reset_Err_stack;
317: END IF;
318: RETURN;
319: END IF;
320: END IF;

Line 373: IF p_pa_debug_mode = 'Y' THEN

369: p_msg_data => l_msg_data ,
370: p_data => x_msg_data,
371: p_msg_index_out => l_msg_index_out );
372: END IF;
373: IF p_pa_debug_mode = 'Y' THEN
374: PA_DEBUG.Reset_Err_stack;
375: END IF;
376: RETURN;
377: END IF;

Line 374: PA_DEBUG.Reset_Err_stack;

370: p_data => x_msg_data,
371: p_msg_index_out => l_msg_index_out );
372: END IF;
373: IF p_pa_debug_mode = 'Y' THEN
374: PA_DEBUG.Reset_Err_stack;
375: END IF;
376: RETURN;
377: END IF;
378: END IF;

Line 416: IF p_pa_debug_mode = 'Y' THEN

412: p_data => x_msg_data,
413: p_msg_index_out => l_msg_index_out );
414: -- x_msg_data := l_data;
415: END IF;
416: IF p_pa_debug_mode = 'Y' THEN
417: PA_DEBUG.Reset_Err_stack;
418: END IF;
419: RETURN;
420: END IF;

Line 417: PA_DEBUG.Reset_Err_stack;

413: p_msg_index_out => l_msg_index_out );
414: -- x_msg_data := l_data;
415: END IF;
416: IF p_pa_debug_mode = 'Y' THEN
417: PA_DEBUG.Reset_Err_stack;
418: END IF;
419: RETURN;
420: END IF;
421: ELSIF l_no_of_app_plan_types = 2 OR

Line 473: IF p_pa_debug_mode = 'Y' THEN

469: p_data => x_msg_data,
470: p_msg_index_out => l_msg_index_out );
471: -- x_msg_data := l_data;
472: END IF;
473: IF p_pa_debug_mode = 'Y' THEN
474: PA_DEBUG.Reset_Err_stack;
475: END IF;
476: RETURN;
477: END IF;

Line 474: PA_DEBUG.Reset_Err_stack;

470: p_msg_index_out => l_msg_index_out );
471: -- x_msg_data := l_data;
472: END IF;
473: IF p_pa_debug_mode = 'Y' THEN
474: PA_DEBUG.Reset_Err_stack;
475: END IF;
476: RETURN;
477: END IF;
478:

Line 512: IF p_pa_debug_mode = 'Y' THEN

508: p_msg_data => l_msg_data ,
509: p_data => x_msg_data,
510: p_msg_index_out => l_msg_index_out );
511: END IF;
512: IF p_pa_debug_mode = 'Y' THEN
513: PA_DEBUG.Reset_Err_stack;
514: END IF;
515: RETURN;
516: END IF;

Line 513: PA_DEBUG.Reset_Err_stack;

509: p_data => x_msg_data,
510: p_msg_index_out => l_msg_index_out );
511: END IF;
512: IF p_pa_debug_mode = 'Y' THEN
513: PA_DEBUG.Reset_Err_stack;
514: END IF;
515: RETURN;
516: END IF;
517: END IF;

Line 555: IF p_pa_debug_mode = 'Y' THEN

551: p_data => x_msg_data,
552: p_msg_index_out => l_msg_index_out );
553: -- x_msg_data := l_data;
554: END IF;
555: IF p_pa_debug_mode = 'Y' THEN
556: PA_DEBUG.Reset_Err_stack;
557: END IF;
558: RETURN;
559: END IF;

Line 556: PA_DEBUG.Reset_Err_stack;

552: p_msg_index_out => l_msg_index_out );
553: -- x_msg_data := l_data;
554: END IF;
555: IF p_pa_debug_mode = 'Y' THEN
556: PA_DEBUG.Reset_Err_stack;
557: END IF;
558: RETURN;
559: END IF;
560: END IF;

Line 636: IF p_pa_debug_mode = 'Y' THEN

632: lx_cur_work_bv_id NUMBER;
633: BEGIN
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: IF p_pa_debug_mode = 'Y' THEN
637: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
638: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);
639:
640: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;

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

633: BEGIN
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: IF p_pa_debug_mode = 'Y' THEN
637: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
638: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);
639:
640: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
641: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

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

634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: IF p_pa_debug_mode = 'Y' THEN
637: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
638: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);
639:
640: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
641: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
642:

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

636: IF p_pa_debug_mode = 'Y' THEN
637: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
638: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);
639:
640: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
641: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
642:
643: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
644: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

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

637: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
638: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);
639:
640: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
641: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
642:
643: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
644: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
645:

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

639:
640: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
641: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
642:
643: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
644: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
645:
646: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
647: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

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

640: pa_debug.g_err_stage:= 'Project_id:'|| p_project_id;
641: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
642:
643: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
644: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
645:
646: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
647: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
648:

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

642:
643: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
644: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
645:
646: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
647: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
648:
649: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
650: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);

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

643: pa_debug.g_err_stage:= 'p_ci_id:'|| p_ci_id;
644: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
645:
646: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
647: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
648:
649: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
650: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
651: END IF;

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

645:
646: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
647: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
648:
649: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
650: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
651: END IF;
652: l_create_ver_called_flag := 'N';
653:

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

646: pa_debug.g_err_stage:= 'p_agreement_id:' || p_agreement_id;
647: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
648:
649: pa_debug.g_err_stage:= 'p_agreement_number:'|| p_agreement_number;
650: pa_debug.write('Maintain_Plan_Version',pa_debug.g_err_stage,3);
651: END IF;
652: l_create_ver_called_flag := 'N';
653:
654: IF p_element_type = 'REVENUE' OR p_element_type = 'ALL' THEN

Line 876: IF p_pa_debug_mode = 'Y' THEN

872: l_module VARCHAR2(255);
873: BEGIN
874: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';
875:
876: IF p_pa_debug_mode = 'Y' THEN
877: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');
878: PA_DEBUG.write_log (x_module => l_module
879: ,x_msg => 'inside del API call'
880: ,x_log_level => 5);

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

873: BEGIN
874: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';
875:
876: IF p_pa_debug_mode = 'Y' THEN
877: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');
878: PA_DEBUG.write_log (x_module => l_module
879: ,x_msg => 'inside del API call'
880: ,x_log_level => 5);
881: END IF;

Line 878: PA_DEBUG.write_log (x_module => l_module

874: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';
875:
876: IF p_pa_debug_mode = 'Y' THEN
877: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');
878: PA_DEBUG.write_log (x_module => l_module
879: ,x_msg => 'inside del API call'
880: ,x_log_level => 5);
881: END IF;
882:

Line 908: IF p_pa_debug_mode = 'Y' THEN

904: l_chk := 1;
905: END;
906:
907: FOR I IN 1 .. l_bv_id_tab.COUNT LOOP
908: IF p_pa_debug_mode = 'Y' THEN
909: PA_DEBUG.write_log (x_module => l_module
910: ,x_msg => 'before calling dele version in finplan pub'
911: ,x_log_level => 5);
912: END IF;

Line 909: PA_DEBUG.write_log (x_module => l_module

905: END;
906:
907: FOR I IN 1 .. l_bv_id_tab.COUNT LOOP
908: IF p_pa_debug_mode = 'Y' THEN
909: PA_DEBUG.write_log (x_module => l_module
910: ,x_msg => 'before calling dele version in finplan pub'
911: ,x_log_level => 5);
912: END IF;
913: pa_fin_plan_pub.Delete_Version(

Line 933: IF p_pa_debug_mode = 'Y' THEN

929: p_msg_data => l_msg_data ,
930: p_data => x_msg_data,
931: p_msg_index_out => l_msg_index_out );
932: END IF;
933: IF p_pa_debug_mode = 'Y' THEN
934: PA_DEBUG.Reset_Err_stack;
935: END IF;
936: RETURN;
937: END IF;

Line 934: PA_DEBUG.Reset_Err_stack;

930: p_data => x_msg_data,
931: p_msg_index_out => l_msg_index_out );
932: END IF;
933: IF p_pa_debug_mode = 'Y' THEN
934: PA_DEBUG.Reset_Err_stack;
935: END IF;
936: RETURN;
937: END IF;
938:

Line 950: IF p_pa_debug_mode = 'Y' THEN

946:
947: IF p_commit_flag = 'Y' THEN
948: COMMIT;
949: END IF;
950: IF p_pa_debug_mode = 'Y' THEN
951: PA_DEBUG.Reset_Err_stack;
952: END IF;
953: RETURN;
954: EXCEPTION

Line 951: PA_DEBUG.Reset_Err_stack;

947: IF p_commit_flag = 'Y' THEN
948: COMMIT;
949: END IF;
950: IF p_pa_debug_mode = 'Y' THEN
951: PA_DEBUG.Reset_Err_stack;
952: END IF;
953: RETURN;
954: EXCEPTION
955: WHEN OTHERS THEN

Line 957: IF p_pa_debug_mode = 'Y' THEN

953: RETURN;
954: EXCEPTION
955: WHEN OTHERS THEN
956: ROLLBACK;
957: IF p_pa_debug_mode = 'Y' THEN
958: PA_DEBUG.Reset_Err_stack;
959: END IF;
960:
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 958: PA_DEBUG.Reset_Err_stack;

954: EXCEPTION
955: WHEN OTHERS THEN
956: ROLLBACK;
957: IF p_pa_debug_mode = 'Y' THEN
958: PA_DEBUG.Reset_Err_stack;
959: END IF;
960:
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',