APPS.PA_FP_GEN_FCST_PG_PKG 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_FCST_PG_PKG as
2: /* $Header: PAFPGFPB.pls 120.13.12020000.2 2013/05/16 06:37:12 djambhek ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: FUNCTION GET_REV_GEN_METHOD( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE)
7: RETURN VARCHAR2 IS
8:

Line 14: IF p_pa_debug_mode = 'Y' THEN

10: l_error_msg VARCHAR2(30);
11: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_REV_GEN_METHOD';
12:
13: BEGIN
14: IF p_pa_debug_mode = 'Y' THEN
15: pa_debug.set_curr_function( p_function => 'GET_REV_GEN_METHOD',
16: p_debug_mode => p_pa_debug_mode);
17: END IF;
18:

Line 15: pa_debug.set_curr_function( p_function => 'GET_REV_GEN_METHOD',

11: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_REV_GEN_METHOD';
12:
13: BEGIN
14: IF p_pa_debug_mode = 'Y' THEN
15: pa_debug.set_curr_function( p_function => 'GET_REV_GEN_METHOD',
16: p_debug_mode => p_pa_debug_mode);
17: END IF;
18:
19: -- Bug 4711164: Previously, distribution_rule was selected from

Line 16: p_debug_mode => p_pa_debug_mode);

12:
13: BEGIN
14: IF p_pa_debug_mode = 'Y' THEN
15: pa_debug.set_curr_function( p_function => 'GET_REV_GEN_METHOD',
16: p_debug_mode => p_pa_debug_mode);
17: END IF;
18:
19: -- Bug 4711164: Previously, distribution_rule was selected from
20: -- pa_projects_all and passed to Get_Revenue_Generation_Method.

Line 26: IF p_pa_debug_mode = 'Y' THEN

22: -- parameter value and derives the value on its own. Code to get
23: -- the distribution_rule has been removed to improve performance.
24:
25: --Calling the get rev gen method to get the value for l_rev_gen_method
26: IF p_pa_debug_mode = 'Y' THEN
27: pa_fp_gen_amount_utils.fp_debug
28: (p_msg => 'Before calling
29: PA_RATE_PVT_PKG.Get_Revenue_Generation_Method',
30: p_module_name => l_module_name,

Line 38: IF p_pa_debug_mode = 'Y' THEN

34: (P_PROJECT_ID => p_project_id,
35: P_DISTRIBUTION_RULE => null, -- Modified for Bug 4711164
36: X_REV_GEN_METHOD => x_rev_gen_method,
37: X_ERROR_MSG => l_error_msg );
38: IF p_pa_debug_mode = 'Y' THEN
39: pa_fp_gen_amount_utils.fp_debug
40: (p_msg => 'After calling
41: PA_RATE_PVT_PKG.Get_Revenue_Generation_Method',
42: p_module_name => l_module_name,

Line 45: IF p_pa_debug_mode = 'Y' THEN

41: PA_RATE_PVT_PKG.Get_Revenue_Generation_Method',
42: p_module_name => l_module_name,
43: p_log_level => 5);
44: END IF;
45: IF p_pa_debug_mode = 'Y' THEN
46: PA_DEBUG.Reset_Curr_Function;
47: END IF;
48: RETURN x_rev_gen_method;
49:

Line 46: PA_DEBUG.Reset_Curr_Function;

42: p_module_name => l_module_name,
43: p_log_level => 5);
44: END IF;
45: IF p_pa_debug_mode = 'Y' THEN
46: PA_DEBUG.Reset_Curr_Function;
47: END IF;
48: RETURN x_rev_gen_method;
49:
50: EXCEPTION

Line 52: IF p_pa_debug_mode = 'Y' THEN

48: RETURN x_rev_gen_method;
49:
50: EXCEPTION
51: WHEN NO_DATA_FOUND THEN
52: IF p_pa_debug_mode = 'Y' THEN
53: PA_DEBUG.Reset_Curr_Function;
54: END IF;
55: RETURN NULL;
56: WHEN OTHERS THEN

Line 53: PA_DEBUG.Reset_Curr_Function;

49:
50: EXCEPTION
51: WHEN NO_DATA_FOUND THEN
52: IF p_pa_debug_mode = 'Y' THEN
53: PA_DEBUG.Reset_Curr_Function;
54: END IF;
55: RETURN NULL;
56: WHEN OTHERS THEN
57: IF p_pa_debug_mode = 'Y' THEN

Line 57: IF p_pa_debug_mode = 'Y' THEN

53: PA_DEBUG.Reset_Curr_Function;
54: END IF;
55: RETURN NULL;
56: WHEN OTHERS THEN
57: IF p_pa_debug_mode = 'Y' THEN
58: PA_DEBUG.Reset_Curr_Function;
59: END IF;
60: RETURN NULL;
61: END;

Line 58: PA_DEBUG.Reset_Curr_Function;

54: END IF;
55: RETURN NULL;
56: WHEN OTHERS THEN
57: IF p_pa_debug_mode = 'Y' THEN
58: PA_DEBUG.Reset_Curr_Function;
59: END IF;
60: RETURN NULL;
61: END;
62:

Line 78: IF p_pa_debug_mode = 'Y' THEN

74: l_msg_data VARCHAR2(2000);
75: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACTUALS_THRU_PERIOD_DTLS';
76:
77: BEGIN
78: IF p_pa_debug_mode = 'Y' THEN
79: pa_debug.set_curr_function( p_function => 'GET_ACTUALS_THRU_PERIOD_DTLS',
80: p_debug_mode => p_pa_debug_mode);
81: END IF;
82: --Calling the Util API

Line 79: pa_debug.set_curr_function( p_function => 'GET_ACTUALS_THRU_PERIOD_DTLS',

75: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACTUALS_THRU_PERIOD_DTLS';
76:
77: BEGIN
78: IF p_pa_debug_mode = 'Y' THEN
79: pa_debug.set_curr_function( p_function => 'GET_ACTUALS_THRU_PERIOD_DTLS',
80: p_debug_mode => p_pa_debug_mode);
81: END IF;
82: --Calling the Util API
83: IF p_pa_debug_mode = 'Y' THEN

Line 80: p_debug_mode => p_pa_debug_mode);

76:
77: BEGIN
78: IF p_pa_debug_mode = 'Y' THEN
79: pa_debug.set_curr_function( p_function => 'GET_ACTUALS_THRU_PERIOD_DTLS',
80: p_debug_mode => p_pa_debug_mode);
81: END IF;
82: --Calling the Util API
83: IF p_pa_debug_mode = 'Y' THEN
84: pa_fp_gen_amount_utils.fp_debug

Line 83: IF p_pa_debug_mode = 'Y' THEN

79: pa_debug.set_curr_function( p_function => 'GET_ACTUALS_THRU_PERIOD_DTLS',
80: p_debug_mode => p_pa_debug_mode);
81: END IF;
82: --Calling the Util API
83: IF p_pa_debug_mode = 'Y' THEN
84: pa_fp_gen_amount_utils.fp_debug
85: (p_msg => 'Before calling
86: pa_fp_gen_amount_utils.get_plan_version_dtls',
87: p_module_name => l_module_name,

Line 99: IF p_pa_debug_mode = 'Y' THEN

95: X_MSG_DATA => L_MSG_DATA);
96: IF L_RET_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
97: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
98: END IF;
99: IF p_pa_debug_mode = 'Y' THEN
100: pa_fp_gen_amount_utils.fp_debug
101: (p_msg => 'Status after calling
102: pa_fp_gen_amount_utils.get_plan_version_dtls: '
103: ||L_RET_STATUS,

Line 206: IF p_pa_debug_mode = 'Y' THEN

202: l_end_date := l_end_date2;
203: END IF;
204:
205: IF P_CONTEXT = 'PERIOD' THEN
206: IF p_pa_debug_mode = 'Y' THEN
207: PA_DEBUG.Reset_Curr_Function;
208: END IF;
209: RETURN x_period_name;
210: ELSIF P_CONTEXT = 'END_DATE' THEN

Line 207: PA_DEBUG.Reset_Curr_Function;

203: END IF;
204:
205: IF P_CONTEXT = 'PERIOD' THEN
206: IF p_pa_debug_mode = 'Y' THEN
207: PA_DEBUG.Reset_Curr_Function;
208: END IF;
209: RETURN x_period_name;
210: ELSIF P_CONTEXT = 'END_DATE' THEN
211: IF l_end_date IS NULL THEN

Line 228: IF p_pa_debug_mode = 'Y' THEN

224: FROM pa_periods_all
225: WHERE l_end_date between start_date and end_date
226: AND org_id = l_fp_cols_rec.x_org_id;
227: END IF;
228: IF p_pa_debug_mode = 'Y' THEN
229: PA_DEBUG.Reset_Curr_Function;
230: END IF;
231: RETURN to_char(nvl(l_end_date1,trunc(sysdate)),'RRRRMMDD');
232: END IF;

Line 229: PA_DEBUG.Reset_Curr_Function;

225: WHERE l_end_date between start_date and end_date
226: AND org_id = l_fp_cols_rec.x_org_id;
227: END IF;
228: IF p_pa_debug_mode = 'Y' THEN
229: PA_DEBUG.Reset_Curr_Function;
230: END IF;
231: RETURN to_char(nvl(l_end_date1,trunc(sysdate)),'RRRRMMDD');
232: END IF;
233: IF p_pa_debug_mode = 'Y' THEN

Line 233: IF p_pa_debug_mode = 'Y' THEN

229: PA_DEBUG.Reset_Curr_Function;
230: END IF;
231: RETURN to_char(nvl(l_end_date1,trunc(sysdate)),'RRRRMMDD');
232: END IF;
233: IF p_pa_debug_mode = 'Y' THEN
234: PA_DEBUG.Reset_Curr_Function;
235: END IF;
236: EXCEPTION
237: WHEN NO_DATA_FOUND THEN

Line 234: PA_DEBUG.Reset_Curr_Function;

230: END IF;
231: RETURN to_char(nvl(l_end_date1,trunc(sysdate)),'RRRRMMDD');
232: END IF;
233: IF p_pa_debug_mode = 'Y' THEN
234: PA_DEBUG.Reset_Curr_Function;
235: END IF;
236: EXCEPTION
237: WHEN NO_DATA_FOUND THEN
238: IF P_CONTEXT = 'PERIOD' THEN

Line 239: IF p_pa_debug_mode = 'Y' THEN

235: END IF;
236: EXCEPTION
237: WHEN NO_DATA_FOUND THEN
238: IF P_CONTEXT = 'PERIOD' THEN
239: IF p_pa_debug_mode = 'Y' THEN
240: PA_DEBUG.Reset_Curr_Function;
241: END IF;
242: RETURN NULL;
243: ELSIF P_CONTEXT = 'END_DATE' THEN

Line 240: PA_DEBUG.Reset_Curr_Function;

236: EXCEPTION
237: WHEN NO_DATA_FOUND THEN
238: IF P_CONTEXT = 'PERIOD' THEN
239: IF p_pa_debug_mode = 'Y' THEN
240: PA_DEBUG.Reset_Curr_Function;
241: END IF;
242: RETURN NULL;
243: ELSIF P_CONTEXT = 'END_DATE' THEN
244: /*To address bug 4233703: when specified period doesn't exist,

Line 269: IF p_pa_debug_mode = 'Y' THEN

265: EXCEPTION
266: WHEN OTHERS THEN
267: l_end_date := trunc(sysdate);
268: END ;
269: IF p_pa_debug_mode = 'Y' THEN
270: PA_DEBUG.Reset_Curr_Function;
271: END IF;
272: RETURN to_char(NVL(l_end_date, trunc(sysdate)),'RRRRMMDD');
273: END IF;

Line 270: PA_DEBUG.Reset_Curr_Function;

266: WHEN OTHERS THEN
267: l_end_date := trunc(sysdate);
268: END ;
269: IF p_pa_debug_mode = 'Y' THEN
270: PA_DEBUG.Reset_Curr_Function;
271: END IF;
272: RETURN to_char(NVL(l_end_date, trunc(sysdate)),'RRRRMMDD');
273: END IF;
274: WHEN OTHERS THEN

Line 276: IF p_pa_debug_mode = 'Y' THEN

272: RETURN to_char(NVL(l_end_date, trunc(sysdate)),'RRRRMMDD');
273: END IF;
274: WHEN OTHERS THEN
275: IF P_CONTEXT = 'PERIOD' THEN
276: IF p_pa_debug_mode = 'Y' THEN
277: PA_DEBUG.Reset_Curr_Function;
278: END IF;
279: RETURN NULL;
280: ELSIF P_CONTEXT = 'END_DATE' THEN

Line 277: PA_DEBUG.Reset_Curr_Function;

273: END IF;
274: WHEN OTHERS THEN
275: IF P_CONTEXT = 'PERIOD' THEN
276: IF p_pa_debug_mode = 'Y' THEN
277: PA_DEBUG.Reset_Curr_Function;
278: END IF;
279: RETURN NULL;
280: ELSIF P_CONTEXT = 'END_DATE' THEN
281: IF p_pa_debug_mode = 'Y' THEN

Line 281: IF p_pa_debug_mode = 'Y' THEN

277: PA_DEBUG.Reset_Curr_Function;
278: END IF;
279: RETURN NULL;
280: ELSIF P_CONTEXT = 'END_DATE' THEN
281: IF p_pa_debug_mode = 'Y' THEN
282: PA_DEBUG.Reset_Curr_Function;
283: END IF;
284: RETURN to_char(trunc(sysdate),'RRRRMMDD');
285: END IF;

Line 282: PA_DEBUG.Reset_Curr_Function;

278: END IF;
279: RETURN NULL;
280: ELSIF P_CONTEXT = 'END_DATE' THEN
281: IF p_pa_debug_mode = 'Y' THEN
282: PA_DEBUG.Reset_Curr_Function;
283: END IF;
284: RETURN to_char(trunc(sysdate),'RRRRMMDD');
285: END IF;
286: END;

Line 302: IF p_pa_debug_mode = 'Y' THEN

298:
299: l_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
300:
301: BEGIN
302: IF p_pa_debug_mode = 'Y' THEN
303: pa_debug.set_curr_function( p_function => 'GET_ACT_FRM_PERIOD',
304: p_debug_mode => p_pa_debug_mode);
305: END IF;
306: --Calling the Util API

Line 303: pa_debug.set_curr_function( p_function => 'GET_ACT_FRM_PERIOD',

299: l_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
300:
301: BEGIN
302: IF p_pa_debug_mode = 'Y' THEN
303: pa_debug.set_curr_function( p_function => 'GET_ACT_FRM_PERIOD',
304: p_debug_mode => p_pa_debug_mode);
305: END IF;
306: --Calling the Util API
307: IF p_pa_debug_mode = 'Y' THEN

Line 304: p_debug_mode => p_pa_debug_mode);

300:
301: BEGIN
302: IF p_pa_debug_mode = 'Y' THEN
303: pa_debug.set_curr_function( p_function => 'GET_ACT_FRM_PERIOD',
304: p_debug_mode => p_pa_debug_mode);
305: END IF;
306: --Calling the Util API
307: IF p_pa_debug_mode = 'Y' THEN
308: pa_fp_gen_amount_utils.fp_debug

Line 307: IF p_pa_debug_mode = 'Y' THEN

303: pa_debug.set_curr_function( p_function => 'GET_ACT_FRM_PERIOD',
304: p_debug_mode => p_pa_debug_mode);
305: END IF;
306: --Calling the Util API
307: IF p_pa_debug_mode = 'Y' THEN
308: pa_fp_gen_amount_utils.fp_debug
309: (p_msg => 'Before calling
310: pa_fp_gen_amount_utils.get_plan_version_dtls',
311: p_module_name => l_module_name,

Line 323: IF p_pa_debug_mode = 'Y' THEN

319: X_MSG_DATA => l_MSG_DATA);
320: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
321: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
322: END IF;
323: IF p_pa_debug_mode = 'Y' THEN
324: pa_fp_gen_amount_utils.fp_debug
325: (p_msg => 'Status after calling
326: pa_fp_gen_amount_utils.get_plan_version_dtls: '
327: ||l_RETURN_STATUS,

Line 341: IF p_pa_debug_mode = 'Y' THEN

337: WHERE p.org_id = l_fp_cols_rec.x_org_id
338: AND proj.project_id = l_fp_cols_rec.x_project_id
339: AND proj.start_date between p.start_date and p.end_date;
340:
341: IF p_pa_debug_mode = 'Y' THEN
342: PA_DEBUG.Reset_Curr_Function;
343: END IF;
344: RETURN l_period_name;
345:

Line 342: PA_DEBUG.Reset_Curr_Function;

338: AND proj.project_id = l_fp_cols_rec.x_project_id
339: AND proj.start_date between p.start_date and p.end_date;
340:
341: IF p_pa_debug_mode = 'Y' THEN
342: PA_DEBUG.Reset_Curr_Function;
343: END IF;
344: RETURN l_period_name;
345:
346: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN

Line 357: IF p_pa_debug_mode = 'Y' THEN

353: AND g.adjustment_period_flag = 'N'
354: AND proj.project_id = l_fp_cols_rec.x_project_id
355: AND proj.start_date between g.start_date and g.end_date;
356:
357: IF p_pa_debug_mode = 'Y' THEN
358: PA_DEBUG.Reset_Curr_Function;
359: END IF;
360: RETURN l_period_name;
361:

Line 358: PA_DEBUG.Reset_Curr_Function;

354: AND proj.project_id = l_fp_cols_rec.x_project_id
355: AND proj.start_date between g.start_date and g.end_date;
356:
357: IF p_pa_debug_mode = 'Y' THEN
358: PA_DEBUG.Reset_Curr_Function;
359: END IF;
360: RETURN l_period_name;
361:
362: ELSE

Line 363: IF p_pa_debug_mode = 'Y' THEN

359: END IF;
360: RETURN l_period_name;
361:
362: ELSE
363: IF p_pa_debug_mode = 'Y' THEN
364: PA_DEBUG.Reset_Curr_Function;
365: END IF;
366: RETURN null;
367:

Line 364: PA_DEBUG.Reset_Curr_Function;

360: RETURN l_period_name;
361:
362: ELSE
363: IF p_pa_debug_mode = 'Y' THEN
364: PA_DEBUG.Reset_Curr_Function;
365: END IF;
366: RETURN null;
367:
368: END IF;

Line 369: IF p_pa_debug_mode = 'Y' THEN

365: END IF;
366: RETURN null;
367:
368: END IF;
369: IF p_pa_debug_mode = 'Y' THEN
370: PA_DEBUG.Reset_Curr_Function;
371: END IF;
372: EXCEPTION
373: WHEN OTHERS THEN

Line 370: PA_DEBUG.Reset_Curr_Function;

366: RETURN null;
367:
368: END IF;
369: IF p_pa_debug_mode = 'Y' THEN
370: PA_DEBUG.Reset_Curr_Function;
371: END IF;
372: EXCEPTION
373: WHEN OTHERS THEN
374: IF p_pa_debug_mode = 'Y' THEN

Line 374: IF p_pa_debug_mode = 'Y' THEN

370: PA_DEBUG.Reset_Curr_Function;
371: END IF;
372: EXCEPTION
373: WHEN OTHERS THEN
374: IF p_pa_debug_mode = 'Y' THEN
375: PA_DEBUG.Reset_Curr_Function;
376: END IF;
377: RETURN null;
378: END;

Line 375: PA_DEBUG.Reset_Curr_Function;

371: END IF;
372: EXCEPTION
373: WHEN OTHERS THEN
374: IF p_pa_debug_mode = 'Y' THEN
375: PA_DEBUG.Reset_Curr_Function;
376: END IF;
377: RETURN null;
378: END;
379:

Line 394: IF p_pa_debug_mode = 'Y' THEN

390: l_act_to_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
391: l_act_from_period_name varchar2(1000); -- bug 6142328 added for comparing act_from_period with act_to_period
392:
393: BEGIN
394: IF p_pa_debug_mode = 'Y' THEN
395: pa_debug.set_curr_function( p_function => 'GET_ACT_TO_PERIOD',
396: p_debug_mode => p_pa_debug_mode);
397: END IF;
398: --Calling the Util API

Line 395: pa_debug.set_curr_function( p_function => 'GET_ACT_TO_PERIOD',

391: l_act_from_period_name varchar2(1000); -- bug 6142328 added for comparing act_from_period with act_to_period
392:
393: BEGIN
394: IF p_pa_debug_mode = 'Y' THEN
395: pa_debug.set_curr_function( p_function => 'GET_ACT_TO_PERIOD',
396: p_debug_mode => p_pa_debug_mode);
397: END IF;
398: --Calling the Util API
399: IF p_pa_debug_mode = 'Y' THEN

Line 396: p_debug_mode => p_pa_debug_mode);

392:
393: BEGIN
394: IF p_pa_debug_mode = 'Y' THEN
395: pa_debug.set_curr_function( p_function => 'GET_ACT_TO_PERIOD',
396: p_debug_mode => p_pa_debug_mode);
397: END IF;
398: --Calling the Util API
399: IF p_pa_debug_mode = 'Y' THEN
400: pa_fp_gen_amount_utils.fp_debug

Line 399: IF p_pa_debug_mode = 'Y' THEN

395: pa_debug.set_curr_function( p_function => 'GET_ACT_TO_PERIOD',
396: p_debug_mode => p_pa_debug_mode);
397: END IF;
398: --Calling the Util API
399: IF p_pa_debug_mode = 'Y' THEN
400: pa_fp_gen_amount_utils.fp_debug
401: (p_msg => 'Before calling
402: pa_fp_gen_amount_utils.get_plan_version_dtls',
403: p_module_name => l_module_name,

Line 416: IF p_pa_debug_mode = 'Y' THEN

412: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
413: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
414: END IF;
415:
416: IF p_pa_debug_mode = 'Y' THEN
417: pa_fp_gen_amount_utils.fp_debug
418: (p_msg => 'Status after calling
419: pa_fp_gen_amount_utils.get_plan_version_dtls: '
420: ||l_RETURN_STATUS,

Line 444: IF p_pa_debug_mode = 'Y' THEN

440: EXCEPTION
441: WHEN NO_DATA_FOUND THEN
442: l_act_to_period_name := l_act_from_period_name;
443: END;
444: IF p_pa_debug_mode = 'Y' THEN
445: PA_DEBUG.Reset_Curr_Function;
446: END IF;
447: RETURN l_act_to_period_name;
448: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN

Line 445: PA_DEBUG.Reset_Curr_Function;

441: WHEN NO_DATA_FOUND THEN
442: l_act_to_period_name := l_act_from_period_name;
443: END;
444: IF p_pa_debug_mode = 'Y' THEN
445: PA_DEBUG.Reset_Curr_Function;
446: END IF;
447: RETURN l_act_to_period_name;
448: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
449: BEGIN

Line 467: IF p_pa_debug_mode = 'Y' THEN

463: WHEN NO_DATA_FOUND THEN
464: l_act_to_period_name := l_act_from_period_name;
465: END;
466:
467: IF p_pa_debug_mode = 'Y' THEN
468: PA_DEBUG.Reset_Curr_Function;
469: END IF;
470: -- bug 6142328; adding the below if condition for validating the l_act_to_period
471: --bug6142328 l_act_from_period_name := GET_ACT_FRM_PERIOD(P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID);

Line 468: PA_DEBUG.Reset_Curr_Function;

464: l_act_to_period_name := l_act_from_period_name;
465: END;
466:
467: IF p_pa_debug_mode = 'Y' THEN
468: PA_DEBUG.Reset_Curr_Function;
469: END IF;
470: -- bug 6142328; adding the below if condition for validating the l_act_to_period
471: --bug6142328 l_act_from_period_name := GET_ACT_FRM_PERIOD(P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID);
472:

Line 480: IF p_pa_debug_mode = 'Y' THEN

476: END IF; */
477: RETURN l_act_to_period_name;
478:
479: ELSE
480: IF p_pa_debug_mode = 'Y' THEN
481: PA_DEBUG.Reset_Curr_Function;
482: END IF;
483: RETURN null;
484:

Line 481: PA_DEBUG.Reset_Curr_Function;

477: RETURN l_act_to_period_name;
478:
479: ELSE
480: IF p_pa_debug_mode = 'Y' THEN
481: PA_DEBUG.Reset_Curr_Function;
482: END IF;
483: RETURN null;
484:
485: END IF;

Line 486: IF p_pa_debug_mode = 'Y' THEN

482: END IF;
483: RETURN null;
484:
485: END IF;
486: IF p_pa_debug_mode = 'Y' THEN
487: PA_DEBUG.Reset_Curr_Function;
488: END IF;
489: EXCEPTION
490: WHEN OTHERS THEN

Line 487: PA_DEBUG.Reset_Curr_Function;

483: RETURN null;
484:
485: END IF;
486: IF p_pa_debug_mode = 'Y' THEN
487: PA_DEBUG.Reset_Curr_Function;
488: END IF;
489: EXCEPTION
490: WHEN OTHERS THEN
491: IF p_pa_debug_mode = 'Y' THEN

Line 491: IF p_pa_debug_mode = 'Y' THEN

487: PA_DEBUG.Reset_Curr_Function;
488: END IF;
489: EXCEPTION
490: WHEN OTHERS THEN
491: IF p_pa_debug_mode = 'Y' THEN
492: PA_DEBUG.Reset_Curr_Function;
493: END IF;
494: RETURN null;
495: END;

Line 492: PA_DEBUG.Reset_Curr_Function;

488: END IF;
489: EXCEPTION
490: WHEN OTHERS THEN
491: IF p_pa_debug_mode = 'Y' THEN
492: PA_DEBUG.Reset_Curr_Function;
493: END IF;
494: RETURN null;
495: END;
496:

Line 511: IF p_pa_debug_mode = 'Y' THEN

507: l_etc_from_period_date DATE;
508: l_etc_from_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
509:
510: BEGIN
511: IF p_pa_debug_mode = 'Y' THEN
512: pa_debug.set_curr_function( p_function => 'GET_ETC_FRM_PERIOD',
513: p_debug_mode => p_pa_debug_mode);
514: END IF;
515: --Calling the Util API

Line 512: pa_debug.set_curr_function( p_function => 'GET_ETC_FRM_PERIOD',

508: l_etc_from_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
509:
510: BEGIN
511: IF p_pa_debug_mode = 'Y' THEN
512: pa_debug.set_curr_function( p_function => 'GET_ETC_FRM_PERIOD',
513: p_debug_mode => p_pa_debug_mode);
514: END IF;
515: --Calling the Util API
516: IF p_pa_debug_mode = 'Y' THEN

Line 513: p_debug_mode => p_pa_debug_mode);

509:
510: BEGIN
511: IF p_pa_debug_mode = 'Y' THEN
512: pa_debug.set_curr_function( p_function => 'GET_ETC_FRM_PERIOD',
513: p_debug_mode => p_pa_debug_mode);
514: END IF;
515: --Calling the Util API
516: IF p_pa_debug_mode = 'Y' THEN
517: pa_fp_gen_amount_utils.fp_debug

Line 516: IF p_pa_debug_mode = 'Y' THEN

512: pa_debug.set_curr_function( p_function => 'GET_ETC_FRM_PERIOD',
513: p_debug_mode => p_pa_debug_mode);
514: END IF;
515: --Calling the Util API
516: IF p_pa_debug_mode = 'Y' THEN
517: pa_fp_gen_amount_utils.fp_debug
518: (p_msg => 'Before calling
519: pa_fp_gen_amount_utils.get_plan_version_dtls',
520: p_module_name => l_module_name,

Line 533: IF p_pa_debug_mode = 'Y' THEN

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

Line 553: IF p_pa_debug_mode = 'Y' THEN

549: FROM pa_periods_all
550: WHERE org_id = l_fp_cols_rec.x_org_id
551: AND l_etc_from_period_date between start_date and end_date;
552:
553: IF p_pa_debug_mode = 'Y' THEN
554: PA_DEBUG.Reset_Curr_Function;
555: END IF;
556: RETURN l_etc_from_period_name;
557: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN

Line 554: PA_DEBUG.Reset_Curr_Function;

550: WHERE org_id = l_fp_cols_rec.x_org_id
551: AND l_etc_from_period_date between start_date and end_date;
552:
553: IF p_pa_debug_mode = 'Y' THEN
554: PA_DEBUG.Reset_Curr_Function;
555: END IF;
556: RETURN l_etc_from_period_name;
557: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
558:

Line 567: IF p_pa_debug_mode = 'Y' THEN

563: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
564: AND adjustment_period_flag = 'N'
565: AND l_etc_from_period_date between start_date and end_date;
566:
567: IF p_pa_debug_mode = 'Y' THEN
568: PA_DEBUG.Reset_Curr_Function;
569: END IF;
570: RETURN l_etc_from_period_name;
571:

Line 568: PA_DEBUG.Reset_Curr_Function;

564: AND adjustment_period_flag = 'N'
565: AND l_etc_from_period_date between start_date and end_date;
566:
567: IF p_pa_debug_mode = 'Y' THEN
568: PA_DEBUG.Reset_Curr_Function;
569: END IF;
570: RETURN l_etc_from_period_name;
571:
572: ELSE

Line 573: IF p_pa_debug_mode = 'Y' THEN

569: END IF;
570: RETURN l_etc_from_period_name;
571:
572: ELSE
573: IF p_pa_debug_mode = 'Y' THEN
574: PA_DEBUG.Reset_Curr_Function;
575: END IF;
576: RETURN null;
577:

Line 574: PA_DEBUG.Reset_Curr_Function;

570: RETURN l_etc_from_period_name;
571:
572: ELSE
573: IF p_pa_debug_mode = 'Y' THEN
574: PA_DEBUG.Reset_Curr_Function;
575: END IF;
576: RETURN null;
577:
578: END IF;

Line 579: IF p_pa_debug_mode = 'Y' THEN

575: END IF;
576: RETURN null;
577:
578: END IF;
579: IF p_pa_debug_mode = 'Y' THEN
580: PA_DEBUG.Reset_Curr_Function;
581: END IF;
582: EXCEPTION
583: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 580: PA_DEBUG.Reset_Curr_Function;

576: RETURN null;
577:
578: END IF;
579: IF p_pa_debug_mode = 'Y' THEN
580: PA_DEBUG.Reset_Curr_Function;
581: END IF;
582: EXCEPTION
583: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
584: -- Bug Fix: 4569365. Removed MRC code.

Line 605: IF p_pa_debug_mode = 'Y' THEN

601: ROLLBACK;
602:
603: l_return_status := FND_API.G_RET_STS_ERROR;
604:
605: IF p_pa_debug_mode = 'Y' THEN
606: PA_DEBUG.Reset_Curr_Function;
607: END IF;
608:
609: WHEN OTHERS THEN

Line 606: PA_DEBUG.Reset_Curr_Function;

602:
603: l_return_status := FND_API.G_RET_STS_ERROR;
604:
605: IF p_pa_debug_mode = 'Y' THEN
606: PA_DEBUG.Reset_Curr_Function;
607: END IF;
608:
609: WHEN OTHERS THEN
610: IF p_pa_debug_mode = 'Y' THEN

Line 610: IF p_pa_debug_mode = 'Y' THEN

606: PA_DEBUG.Reset_Curr_Function;
607: END IF;
608:
609: WHEN OTHERS THEN
610: IF p_pa_debug_mode = 'Y' THEN
611: PA_DEBUG.Reset_Curr_Function;
612: END IF;
613: RETURN null;
614: END;

Line 611: PA_DEBUG.Reset_Curr_Function;

607: END IF;
608:
609: WHEN OTHERS THEN
610: IF p_pa_debug_mode = 'Y' THEN
611: PA_DEBUG.Reset_Curr_Function;
612: END IF;
613: RETURN null;
614: END;
615:

Line 630: IF p_pa_debug_mode = 'Y' THEN

626: l_etc_to_period PA_PERIODS_ALL.PERIOD_NAME%TYPE;
627: l_actual_thru_date DATE;
628:
629: BEGIN
630: IF p_pa_debug_mode = 'Y' THEN
631: pa_debug.set_curr_function( p_function => 'GET_ETC_TO_PERIOD',
632: p_debug_mode => p_pa_debug_mode);
633: END IF;
634: --Calling the Util API

Line 631: pa_debug.set_curr_function( p_function => 'GET_ETC_TO_PERIOD',

627: l_actual_thru_date DATE;
628:
629: BEGIN
630: IF p_pa_debug_mode = 'Y' THEN
631: pa_debug.set_curr_function( p_function => 'GET_ETC_TO_PERIOD',
632: p_debug_mode => p_pa_debug_mode);
633: END IF;
634: --Calling the Util API
635: IF p_pa_debug_mode = 'Y' THEN

Line 632: p_debug_mode => p_pa_debug_mode);

628:
629: BEGIN
630: IF p_pa_debug_mode = 'Y' THEN
631: pa_debug.set_curr_function( p_function => 'GET_ETC_TO_PERIOD',
632: p_debug_mode => p_pa_debug_mode);
633: END IF;
634: --Calling the Util API
635: IF p_pa_debug_mode = 'Y' THEN
636: pa_fp_gen_amount_utils.fp_debug

Line 635: IF p_pa_debug_mode = 'Y' THEN

631: pa_debug.set_curr_function( p_function => 'GET_ETC_TO_PERIOD',
632: p_debug_mode => p_pa_debug_mode);
633: END IF;
634: --Calling the Util API
635: IF p_pa_debug_mode = 'Y' THEN
636: pa_fp_gen_amount_utils.fp_debug
637: (p_msg => 'Before calling
638: pa_fp_gen_amount_utils.get_plan_version_dtls',
639: p_module_name => l_module_name,

Line 651: IF p_pa_debug_mode = 'Y' THEN

647: X_MSG_DATA => l_MSG_DATA);
648: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
649: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
650: END IF;
651: IF p_pa_debug_mode = 'Y' THEN
652: pa_fp_gen_amount_utils.fp_debug
653: (p_msg => 'Status after calling
654: pa_fp_gen_amount_utils.get_plan_version_dtls: '
655: ||l_RETURN_STATUS,

Line 676: IF p_pa_debug_mode = 'Y' THEN

672: IF l_actual_thru_date+1 >= l_proj_comp_date THEN
673: l_etc_to_period := GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID);
674: END IF;
675:
676: IF p_pa_debug_mode = 'Y' THEN
677: PA_DEBUG.Reset_Curr_Function;
678: END IF;
679: RETURN l_etc_to_period;
680:

Line 677: PA_DEBUG.Reset_Curr_Function;

673: l_etc_to_period := GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID);
674: END IF;
675:
676: IF p_pa_debug_mode = 'Y' THEN
677: PA_DEBUG.Reset_Curr_Function;
678: END IF;
679: RETURN l_etc_to_period;
680:
681: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN

Line 696: IF p_pa_debug_mode = 'Y' THEN

692: IF l_actual_thru_date+1 >= l_proj_comp_date THEN
693: l_etc_to_period := GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID);
694: END IF;
695:
696: IF p_pa_debug_mode = 'Y' THEN
697: PA_DEBUG.Reset_Curr_Function;
698: END IF;
699: RETURN l_etc_to_period;
700:

Line 697: PA_DEBUG.Reset_Curr_Function;

693: l_etc_to_period := GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID);
694: END IF;
695:
696: IF p_pa_debug_mode = 'Y' THEN
697: PA_DEBUG.Reset_Curr_Function;
698: END IF;
699: RETURN l_etc_to_period;
700:
701: ELSE

Line 702: IF p_pa_debug_mode = 'Y' THEN

698: END IF;
699: RETURN l_etc_to_period;
700:
701: ELSE
702: IF p_pa_debug_mode = 'Y' THEN
703: PA_DEBUG.Reset_Curr_Function;
704: END IF;
705: RETURN null;
706:

Line 703: PA_DEBUG.Reset_Curr_Function;

699: RETURN l_etc_to_period;
700:
701: ELSE
702: IF p_pa_debug_mode = 'Y' THEN
703: PA_DEBUG.Reset_Curr_Function;
704: END IF;
705: RETURN null;
706:
707: END IF;

Line 708: IF p_pa_debug_mode = 'Y' THEN

704: END IF;
705: RETURN null;
706:
707: END IF;
708: IF p_pa_debug_mode = 'Y' THEN
709: PA_DEBUG.Reset_Curr_Function;
710: END IF;
711: EXCEPTION
712: WHEN OTHERS THEN

Line 709: PA_DEBUG.Reset_Curr_Function;

705: RETURN null;
706:
707: END IF;
708: IF p_pa_debug_mode = 'Y' THEN
709: PA_DEBUG.Reset_Curr_Function;
710: END IF;
711: EXCEPTION
712: WHEN OTHERS THEN
713: IF p_pa_debug_mode = 'Y' THEN

Line 713: IF p_pa_debug_mode = 'Y' THEN

709: PA_DEBUG.Reset_Curr_Function;
710: END IF;
711: EXCEPTION
712: WHEN OTHERS THEN
713: IF p_pa_debug_mode = 'Y' THEN
714: PA_DEBUG.Reset_Curr_Function;
715: END IF;
716: RETURN null;
717: END;

Line 714: PA_DEBUG.Reset_Curr_Function;

710: END IF;
711: EXCEPTION
712: WHEN OTHERS THEN
713: IF p_pa_debug_mode = 'Y' THEN
714: PA_DEBUG.Reset_Curr_Function;
715: END IF;
716: RETURN null;
717: END;
718:

Line 749: IF p_pa_debug_mode = 'Y' THEN

745: --Setting initial values
746: X_MSG_COUNT := 0;
747: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
748:
749: IF p_pa_debug_mode = 'Y' THEN
750: pa_debug.set_curr_function( p_function => 'GET_VERSION_DETAILS'
751: ,p_debug_mode => p_pa_debug_mode);
752: END IF;
753:

Line 750: pa_debug.set_curr_function( p_function => 'GET_VERSION_DETAILS'

746: X_MSG_COUNT := 0;
747: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
748:
749: IF p_pa_debug_mode = 'Y' THEN
750: pa_debug.set_curr_function( p_function => 'GET_VERSION_DETAILS'
751: ,p_debug_mode => p_pa_debug_mode);
752: END IF;
753:
754: SELECT VERSION_TYPE

Line 751: ,p_debug_mode => p_pa_debug_mode);

747: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
748:
749: IF p_pa_debug_mode = 'Y' THEN
750: pa_debug.set_curr_function( p_function => 'GET_VERSION_DETAILS'
751: ,p_debug_mode => p_pa_debug_mode);
752: END IF;
753:
754: SELECT VERSION_TYPE
755: INTO X_VERSION_TYPE

Line 760: IF P_PA_DEBUG_MODE = 'Y' THEN

756: FROM PA_BUDGET_VERSIONS
757: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
758: --dbms_output.put_line('Version type from get_version_dtls api:'||X_VERSION_TYPE);
759:
760: IF P_PA_DEBUG_MODE = 'Y' THEN
761: PA_DEBUG.Reset_Curr_Function;
762:
763: END IF;
764:

Line 761: PA_DEBUG.Reset_Curr_Function;

757: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
758: --dbms_output.put_line('Version type from get_version_dtls api:'||X_VERSION_TYPE);
759:
760: IF P_PA_DEBUG_MODE = 'Y' THEN
761: PA_DEBUG.Reset_Curr_Function;
762:
763: END IF;
764:
765: EXCEPTION

Line 784: IF P_PA_DEBUG_MODE = 'Y' THEN

780: END IF;
781: ROLLBACK;
782:
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: IF P_PA_DEBUG_MODE = 'Y' THEN
785: pa_fp_gen_amount_utils.fp_debug
786: (p_msg => 'Invalid Arguments Passed',
787: p_module_name => l_module_name,
788: p_log_level => 5);

Line 789: PA_DEBUG.Reset_Curr_Function;

785: pa_fp_gen_amount_utils.fp_debug
786: (p_msg => 'Invalid Arguments Passed',
787: p_module_name => l_module_name,
788: p_log_level => 5);
789: PA_DEBUG.Reset_Curr_Function;
790: END IF;
791: RAISE;
792:
793: WHEN OTHERS THEN

Line 799: IF P_PA_DEBUG_MODE = 'Y' THEN

795: x_msg_data := SUBSTR(SQLERRM,1,240);
796: FND_MSG_PUB.add_exc_msg
797: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
798: ,p_procedure_name => 'GET_VERSION_DETAILS');
799: IF P_PA_DEBUG_MODE = 'Y' THEN
800: pa_fp_gen_amount_utils.fp_debug
801: (p_msg => 'Unexpected Error'||SUBSTR(SQLERRM,1,240),
802: p_module_name => l_module_name,
803: p_log_level => 5);

Line 804: PA_DEBUG.Reset_Curr_Function;

800: pa_fp_gen_amount_utils.fp_debug
801: (p_msg => 'Unexpected Error'||SUBSTR(SQLERRM,1,240),
802: p_module_name => l_module_name,
803: p_log_level => 5);
804: PA_DEBUG.Reset_Curr_Function;
805: END IF;
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807:
808: END GET_VERSION_DETAILS;

Line 842: IF p_pa_debug_mode = 'Y' THEN

838:
839: BEGIN
840: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
841:
842: IF p_pa_debug_mode = 'Y' THEN
843: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
844: ,p_debug_mode => p_pa_debug_mode);
845: END IF;
846:

Line 843: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'

839: BEGIN
840: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
841:
842: IF p_pa_debug_mode = 'Y' THEN
843: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
844: ,p_debug_mode => p_pa_debug_mode);
845: END IF;
846:
847: -- Get the work plan details by calling the following method

Line 844: ,p_debug_mode => p_pa_debug_mode);

840: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
841:
842: IF p_pa_debug_mode = 'Y' THEN
843: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
844: ,p_debug_mode => p_pa_debug_mode);
845: END IF;
846:
847: -- Get the work plan details by calling the following method
848: -- with work plan version id

Line 850: IF p_pa_debug_mode = 'Y' THEN

846:
847: -- Get the work plan details by calling the following method
848: -- with work plan version id
849: IF P_WP_VERSION_ID IS NOT NULL THEN
850: IF p_pa_debug_mode = 'Y' THEN
851: pa_fp_gen_amount_utils.fp_debug
852: (p_msg => 'Before calling
853: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
854: p_module_name => l_module_name,

Line 866: IF p_pa_debug_mode = 'Y' THEN

862: X_MSG_DATA => X_MSG_DATA);
863: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
864: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
865: END IF;
866: IF p_pa_debug_mode = 'Y' THEN
867: pa_fp_gen_amount_utils.fp_debug
868: (p_msg => 'Status after calling
869: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
870: ||x_return_status,

Line 891: IF p_pa_debug_mode = 'Y' THEN

887:
888: -- Get the financial plan details by calling the following
889: -- method with financial paln id
890: IF P_ETC_PLAN_VERSION_ID IS NOT NULL THEN
891: IF p_pa_debug_mode = 'Y' THEN
892: pa_fp_gen_amount_utils.fp_debug
893: (p_msg => 'Before calling
894: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
895: p_module_name => l_module_name,

Line 907: IF p_pa_debug_mode = 'Y' THEN

903: X_MSG_DATA => X_MSG_DATA);
904: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
905: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
906: END IF;
907: IF p_pa_debug_mode = 'Y' THEN
908: pa_fp_gen_amount_utils.fp_debug
909: (p_msg => 'Status after calling
910: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
911: ||x_return_status,

Line 945: IF P_PA_DEBUG_MODE = 'Y' THEN

941: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
942: END IF;
943: END LOOP;
944:
945: IF P_PA_DEBUG_MODE = 'Y' THEN
946: PA_DEBUG.Reset_Curr_Function;
947: END IF;
948:
949: EXCEPTION

Line 946: PA_DEBUG.Reset_Curr_Function;

942: END IF;
943: END LOOP;
944:
945: IF P_PA_DEBUG_MODE = 'Y' THEN
946: PA_DEBUG.Reset_Curr_Function;
947: END IF;
948:
949: EXCEPTION
950: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 968: IF P_PA_DEBUG_MODE = 'Y' THEN

964: END IF;
965: ROLLBACK;
966:
967: x_return_status := FND_API.G_RET_STS_ERROR;
968: IF P_PA_DEBUG_MODE = 'Y' THEN
969: pa_fp_gen_amount_utils.fp_debug
970: (p_msg => 'Validation failed',
971: p_module_name => l_module_name,
972: p_log_level => 5);

Line 973: PA_DEBUG.Reset_Curr_Function;

969: pa_fp_gen_amount_utils.fp_debug
970: (p_msg => 'Validation failed',
971: p_module_name => l_module_name,
972: p_log_level => 5);
973: PA_DEBUG.Reset_Curr_Function;
974: END IF;
975: RAISE;
976: WHEN OTHERS THEN
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 982: IF P_PA_DEBUG_MODE = 'Y' THEN

978: x_msg_data := SUBSTR(SQLERRM,1,240);
979: FND_MSG_PUB.add_exc_msg
980: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
981: ,p_procedure_name => 'VALIDATE_PLAN_TYPE_OR_VERSION');
982: IF P_PA_DEBUG_MODE = 'Y' THEN
983: pa_fp_gen_amount_utils.fp_debug
984: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
985: p_module_name => l_module_name,
986: p_log_level => 5);

Line 987: PA_DEBUG.Reset_Curr_Function;

983: pa_fp_gen_amount_utils.fp_debug
984: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
985: p_module_name => l_module_name,
986: p_log_level => 5);
987: PA_DEBUG.Reset_Curr_Function;
988: END IF;
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990:
991: END VALIDATION_FOR_COPY_ETC_FLAG;

Line 1086: IF p_pa_debug_mode = 'Y' THEN

1082: X_MSG_COUNT := 0;
1083: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1084: l_return_status := FND_API.G_RET_STS_SUCCESS;
1085:
1086: IF p_pa_debug_mode = 'Y' THEN
1087: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'
1088: ,p_debug_mode => p_pa_debug_mode);
1089: END IF;
1090:

Line 1087: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'

1083: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1084: l_return_status := FND_API.G_RET_STS_SUCCESS;
1085:
1086: IF p_pa_debug_mode = 'Y' THEN
1087: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'
1088: ,p_debug_mode => p_pa_debug_mode);
1089: END IF;
1090:
1091: /*CBS enhancement to validate Planning Options of the budget bug#16604989 */

Line 1088: ,p_debug_mode => p_pa_debug_mode);

1084: l_return_status := FND_API.G_RET_STS_SUCCESS;
1085:
1086: IF p_pa_debug_mode = 'Y' THEN
1087: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'
1088: ,p_debug_mode => p_pa_debug_mode);
1089: END IF;
1090:
1091: /*CBS enhancement to validate Planning Options of the budget bug#16604989 */
1092: PA_ALTERNATE_TASK_PVT.Is_Planning_Options_Valid(

Line 1110: IF p_pa_debug_mode = 'Y' THEN

1106: SELECT record_version_number
1107: INTO l_record_version_number
1108: FROM pa_budget_versions
1109: WHERE budget_version_id = p_budget_version_id;
1110: IF p_pa_debug_mode = 'Y' THEN
1111: pa_fp_gen_amount_utils.fp_debug
1112: (p_msg => 'Before calling pa_fin_plan_pvt.lock_unlock_version',
1113: p_module_name => l_module_name);
1114: END IF;

Line 1124: IF p_pa_debug_mode = 'Y' THEN

1120: p_person_id => NULL,
1121: x_return_status => x_return_status,
1122: x_msg_count => x_msg_count,
1123: x_msg_data => x_msg_data);
1124: IF p_pa_debug_mode = 'Y' THEN
1125: pa_fp_gen_amount_utils.fp_debug
1126: (p_msg => 'Status after calling pa_fin_plan_pvt.lock_unlock_version:'
1127: ||x_return_status,
1128: p_module_name => l_module_name);

Line 1132: IF p_pa_debug_mode = 'Y' THEN

1128: p_module_name => l_module_name);
1129: END IF;
1130:
1131: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1132: IF p_pa_debug_mode = 'Y' THEN
1133: PA_DEBUG.Reset_Curr_Function;
1134: END IF;
1135: RETURN;
1136: END IF;

Line 1133: PA_DEBUG.Reset_Curr_Function;

1129: END IF;
1130:
1131: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1132: IF p_pa_debug_mode = 'Y' THEN
1133: PA_DEBUG.Reset_Curr_Function;
1134: END IF;
1135: RETURN;
1136: END IF;
1137:

Line 1144: IF p_pa_debug_mode = 'Y' THEN

1140: /* we need to commit the changes so that the locked by person info
1141: will be available for other sessions. */
1142:
1143: --acquire lock for copy_actual
1144: IF p_pa_debug_mode = 'Y' THEN
1145: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1146: P_MSG => 'Before calling PA_FP_COPY_FROM_PKG.'
1147: ||'ACQUIRE_LOCKS_FOR_COPY_ACTUAL',
1148: P_MODULE_NAME => l_module_name);

Line 1159: IF p_pa_debug_mode = 'Y' THEN

1155: X_MSG_DATA => X_MSG_DATA);
1156: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1157: --If can't acquire lock, customized message is thrown from within
1158: -- the API, so we should suppress exception error
1159: IF p_pa_debug_mode = 'Y' THEN
1160: PA_DEBUG.Reset_Curr_Function;
1161: END IF;
1162: RETURN;
1163: END IF;

Line 1160: PA_DEBUG.Reset_Curr_Function;

1156: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1157: --If can't acquire lock, customized message is thrown from within
1158: -- the API, so we should suppress exception error
1159: IF p_pa_debug_mode = 'Y' THEN
1160: PA_DEBUG.Reset_Curr_Function;
1161: END IF;
1162: RETURN;
1163: END IF;
1164:

Line 1165: IF p_pa_debug_mode = 'Y' THEN

1161: END IF;
1162: RETURN;
1163: END IF;
1164:
1165: IF p_pa_debug_mode = 'Y' THEN
1166: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1167: P_MSG => 'After calling PA_FP_COPY_FROM_PKG.'
1168: ||'ACQUIRE_LOCKS_FOR_COPY_ACTUAL: '
1169: ||x_return_status,

Line 1179: IF p_pa_debug_mode = 'Y' THEN

1175: l_PLAN_VERSION_ID := P_PLAN_VERSION_ID;
1176: l_ETC_PLAN_VERSION_ID := P_ETC_PLAN_VERSION_ID;
1177:
1178: --Calling the Util API
1179: IF p_pa_debug_mode = 'Y' THEN
1180: pa_fp_gen_amount_utils.fp_debug
1181: (p_msg => 'Before calling
1182: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
1183: p_module_name => l_module_name,

Line 1195: IF p_pa_debug_mode = 'Y' THEN

1191: X_MSG_DATA => X_MSG_DATA);
1192: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1193: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1194: END IF;
1195: IF p_pa_debug_mode = 'Y' THEN
1196: pa_fp_gen_amount_utils.fp_debug
1197: (p_msg => 'Status after calling
1198: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
1199: ||x_return_status,

Line 1246: IF p_pa_debug_mode = 'Y' THEN

1242:
1243: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1244: END IF;
1245:
1246: IF p_pa_debug_mode = 'Y' THEN
1247: pa_fp_gen_amount_utils.fp_debug
1248: (p_msg => 'Before calling
1249: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag',
1250: p_module_name => l_module_name,

Line 1265: IF p_pa_debug_mode = 'Y' THEN

1261: X_MSG_DATA => X_MSG_DATA);
1262: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1263: l_return_status := X_RETURN_STATUS;
1264: END IF;
1265: IF p_pa_debug_mode = 'Y' THEN
1266: pa_fp_gen_amount_utils.fp_debug
1267: (p_msg => 'Status after calling
1268: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag: '
1269: ||x_return_status,

Line 1282: IF p_pa_debug_mode = 'Y' THEN

1278: /* the validation should not happen when the forecast gen source is
1279: RESOURCE SCHEDULE. */
1280:
1281: IF L_FP_COLS_REC.X_GEN_ETC_SRC_CODE <> 'RESOURCE_SCHEDULE' THEN
1282: IF p_pa_debug_mode = 'Y' THEN
1283: pa_fp_gen_amount_utils.fp_debug
1284: (p_msg => 'Before calling
1285: pa_fp_gen_fcst_pg_pkg.validate_periods',
1286: p_module_name => l_module_name,

Line 1305: IF p_pa_debug_mode = 'Y' THEN

1301: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1302: l_return_status := X_RETURN_STATUS;
1303: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1304: END IF;
1305: IF p_pa_debug_mode = 'Y' THEN
1306: pa_fp_gen_amount_utils.fp_debug
1307: (p_msg => 'Status after calling
1308: pa_fp_gen_fcst_pg_pkg.validate_periods: '
1309: ||x_return_status,

Line 1319: IF p_pa_debug_mode = 'Y' THEN

1315: /* Calling Validate plan type or version api -> etc_generation_source'*/
1316: IF P_ETC_PLAN_TYPE_ID IS NOT NULL AND
1317: P_ETC_PLAN_VERSION_NAME IS NOT NULL AND
1318: l_ETC_PLAN_VERSION_ID IS NULL THEN
1319: IF p_pa_debug_mode = 'Y' THEN
1320: pa_fp_gen_amount_utils.fp_debug
1321: (p_msg => 'Before calling
1322: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version',
1323: p_module_name => l_module_name,

Line 1339: IF p_pa_debug_mode = 'Y' THEN

1335: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1336: l_return_status := X_RETURN_STATUS;
1337: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1338: END IF;
1339: IF p_pa_debug_mode = 'Y' THEN
1340: pa_fp_gen_amount_utils.fp_debug
1341: ( p_msg => 'Status after calling
1342: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version for etc_generation_source: '
1343: ||x_return_status,

Line 1363: IF p_pa_debug_mode = 'Y' THEN

1359: WHERE budget_version_id = P_BUDGET_VERSION_ID;
1360:
1361: -- IPM: New Entity ER ------------------------------------------
1362: -- Call the maintenance api in DELETE mode
1363: IF p_pa_debug_mode = 'Y' THEN
1364: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1365: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1366: || 'MAINTAIN_DATA',
1367: --P_CALLED_MODE => p_called_mode,

Line 1380: IF p_pa_debug_mode = 'Y' THEN

1376: --P_CALLED_MODE => p_called_mode,
1377: X_RETURN_STATUS => x_return_status,
1378: X_MSG_COUNT => x_msg_count,
1379: X_MSG_DATA => x_msg_data );
1380: IF p_pa_debug_mode = 'Y' THEN
1381: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1382: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1383: || 'MAINTAIN_DATA: ' || x_return_status,
1384: --P_CALLED_MODE => p_called_mode,

Line 1444: IF p_pa_debug_mode = 'Y' THEN

1440: l_res_asg_id_del_tab(k),
1441: 'Y' );
1442:
1443: -- Call the maintenance api in DELETE mode
1444: IF p_pa_debug_mode = 'Y' THEN
1445: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1446: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1447: || 'MAINTAIN_DATA',
1448: --P_CALLED_MODE => p_called_mode,

Line 1461: IF p_pa_debug_mode = 'Y' THEN

1457: --P_CALLED_MODE => p_called_mode,
1458: X_RETURN_STATUS => x_return_status,
1459: X_MSG_COUNT => x_msg_count,
1460: X_MSG_DATA => x_msg_data );
1461: IF p_pa_debug_mode = 'Y' THEN
1462: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1463: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1464: || 'MAINTAIN_DATA: ' || x_return_status,
1465: --P_CALLED_MODE => p_called_mode,

Line 1565: IF p_pa_debug_mode = 'Y' THEN

1561:
1562: /* We need to get version details again after validation logic and
1563: * updates to the budget version so that we pass the most current
1564: * information to lower level APIs via the l_fp_cols_rec parameter. */
1565: IF p_pa_debug_mode = 'Y' THEN
1566: pa_fp_gen_amount_utils.fp_debug
1567: ( p_msg => 'Before calling
1568: pa_fp_gen_amount_utils.get_plan_version_dtls',
1569: p_module_name => l_module_name,

Line 1582: IF p_pa_debug_mode = 'Y' THEN

1578:
1579: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1580: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1581: END IF;
1582: IF p_pa_debug_mode = 'Y' THEN
1583: pa_fp_gen_amount_utils.fp_debug
1584: ( p_msg => 'Status after calling
1585: pa_fp_gen_amount_utils.get_plan_version_dtls: '
1586: ||x_return_status,

Line 1595: IF p_pa_debug_mode = 'Y' THEN

1591: /* This API validates that the current generation is supported.
1592: * For a list of unsupported cases, please see comments at the
1593: * beginning of the VALIDATE_SUPPORT_CASES API (PAFPGAUB.pls) */
1594:
1595: IF p_pa_debug_mode = 'Y' THEN
1596: pa_fp_gen_amount_utils.fp_debug
1597: ( p_msg => 'Before calling
1598: pa_fp_gen_amount_utils.validate_support_cases',
1599: p_module_name => l_module_name,

Line 1609: IF p_pa_debug_mode = 'Y' THEN

1605: X_WARNING_MESSAGE => X_WARNING_MESSAGE,
1606: X_RETURN_STATUS => X_RETURN_STATUS,
1607: X_MSG_COUNT => X_MSG_COUNT,
1608: X_MSG_DATA => X_MSG_DATA );
1609: IF p_pa_debug_mode = 'Y' THEN
1610: pa_fp_gen_amount_utils.fp_debug
1611: ( p_msg => 'Status after calling
1612: pa_fp_gen_amount_utils.validate_support_cases: '
1613: ||x_return_status,

Line 1631: IF p_pa_debug_mode = 'Y' THEN

1627: IF P_CHECK_SRC_ERRORS_FLAG = 'Y' THEN
1628: -- Added the above IF and Commented below if condition bug 4901256
1629: -- IF X_WARNING_MESSAGE IS NOT NULL THEN
1630: -- Before returning, we always have the following check.
1631: IF p_pa_debug_mode = 'Y' THEN
1632: PA_DEBUG.Reset_Curr_Function;
1633: END IF;
1634:
1635: RETURN;

Line 1632: PA_DEBUG.Reset_Curr_Function;

1628: -- Added the above IF and Commented below if condition bug 4901256
1629: -- IF X_WARNING_MESSAGE IS NOT NULL THEN
1630: -- Before returning, we always have the following check.
1631: IF p_pa_debug_mode = 'Y' THEN
1632: PA_DEBUG.Reset_Curr_Function;
1633: END IF;
1634:
1635: RETURN;
1636: END IF;

Line 1639: IF p_pa_debug_mode = 'Y' THEN

1635: RETURN;
1636: END IF;
1637:
1638: --Calling Gen FCST Amt Wrapper API
1639: IF p_pa_debug_mode = 'Y' THEN
1640: pa_fp_gen_amount_utils.fp_debug
1641: (p_msg => 'Before calling
1642: pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp',
1643: p_module_name => l_module_name,

Line 1677: IF p_pa_debug_mode = 'Y' THEN

1673: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1674: l_return_status := X_RETURN_STATUS;
1675: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1676: END IF;
1677: IF p_pa_debug_mode = 'Y' THEN
1678: pa_fp_gen_amount_utils.fp_debug
1679: (p_msg => 'Status after calling
1680: pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp: '
1681: ||x_return_status,

Line 1693: IF p_pa_debug_mode = 'Y' THEN

1689: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1690: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1691: END IF;
1692:
1693: IF p_pa_debug_mode = 'Y' THEN
1694: PA_DEBUG.Reset_Curr_Function;
1695: END IF;
1696:
1697: EXCEPTION

Line 1694: PA_DEBUG.Reset_Curr_Function;

1690: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1691: END IF;
1692:
1693: IF p_pa_debug_mode = 'Y' THEN
1694: PA_DEBUG.Reset_Curr_Function;
1695: END IF;
1696:
1697: EXCEPTION
1698: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1719: IF P_PA_DEBUG_MODE = 'Y' THEN

1715: ROLLBACK;
1716:
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718:
1719: IF P_PA_DEBUG_MODE = 'Y' THEN
1720: pa_fp_gen_amount_utils.fp_debug
1721: (p_msg => 'Invalid Arguments Passed',
1722: p_module_name => l_module_name,
1723: p_log_level => 5);

Line 1724: PA_DEBUG.Reset_Curr_Function;

1720: pa_fp_gen_amount_utils.fp_debug
1721: (p_msg => 'Invalid Arguments Passed',
1722: p_module_name => l_module_name,
1723: p_log_level => 5);
1724: PA_DEBUG.Reset_Curr_Function;
1725: END IF;
1726: RAISE;
1727:
1728: WHEN OTHERS THEN

Line 1737: IF P_PA_DEBUG_MODE = 'Y' THEN

1733:
1734: FND_MSG_PUB.add_exc_msg
1735: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1736: ,p_procedure_name => 'UPD_VER_DTLS_AND_GEN_AMT');
1737: IF P_PA_DEBUG_MODE = 'Y' THEN
1738: pa_fp_gen_amount_utils.fp_debug
1739: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1740: p_module_name => l_module_name,
1741: p_log_level => 5);

Line 1742: PA_DEBUG.Reset_Curr_Function;

1738: pa_fp_gen_amount_utils.fp_debug
1739: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1740: p_module_name => l_module_name,
1741: p_log_level => 5);
1742: PA_DEBUG.Reset_Curr_Function;
1743: END IF;
1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1745:
1746: END UPD_VER_DTLS_AND_GEN_AMT;

Line 1787: IF p_pa_debug_mode = 'Y' THEN

1783: --X_MSG_COUNT := 0;
1784: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1785: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1786:
1787: IF p_pa_debug_mode = 'Y' THEN
1788: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'
1789: ,p_debug_mode => p_pa_debug_mode);
1790: END IF;
1791:

Line 1788: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'

1784: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1785: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1786:
1787: IF p_pa_debug_mode = 'Y' THEN
1788: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'
1789: ,p_debug_mode => p_pa_debug_mode);
1790: END IF;
1791:
1792: --Validating unspent amount period

Line 1789: ,p_debug_mode => p_pa_debug_mode);

1785: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1786:
1787: IF p_pa_debug_mode = 'Y' THEN
1788: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'
1789: ,p_debug_mode => p_pa_debug_mode);
1790: END IF;
1791:
1792: --Validating unspent amount period
1793: IF P_FP_COLS_REC.X_TIME_PHASED_CODE <> 'N'

Line 1803: IF p_pa_debug_mode = 'Y' THEN

1799: END IF;
1800:
1801: IF P_UNSPENT_AMT_FLAG = 'Y' AND P_UNSPENT_AMT_PERIOD IS NOT NULL THEN
1802: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date) api
1803: IF p_pa_debug_mode = 'Y' THEN
1804: pa_fp_gen_amount_utils.fp_debug
1805: (p_msg => 'Before calling
1806: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',
1807: p_module_name => l_module_name,

Line 1819: IF p_pa_debug_mode = 'Y' THEN

1815: X_RETURN_STATUS => X_RETURN_STATUS,
1816: X_MSG_COUNT => X_MSG_COUNT,
1817: X_MSG_DATA => X_MSG_DATA);
1818: l_return_status := X_RETURN_STATUS;
1819: IF p_pa_debug_mode = 'Y' THEN
1820: pa_fp_gen_amount_utils.fp_debug
1821: (p_msg => 'Status after calling
1822: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date): '
1823: ||x_return_status,

Line 1838: IF p_pa_debug_mode = 'Y' THEN

1834: ELSE*/
1835:
1836: IF P_ACTUALS_FROM_PERIOD IS NOT NULL THEN
1837: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from) api
1838: IF p_pa_debug_mode = 'Y' THEN
1839: pa_fp_gen_amount_utils.fp_debug
1840: (p_msg => 'Before calling
1841: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',
1842: p_module_name => l_module_name,

Line 1853: IF p_pa_debug_mode = 'Y' THEN

1849: X_END_DATE => l_act_frm_date,
1850: X_RETURN_STATUS => X_RETURN_STATUS,
1851: X_MSG_COUNT => X_MSG_COUNT,
1852: X_MSG_DATA => X_MSG_DATA);
1853: IF p_pa_debug_mode = 'Y' THEN
1854: pa_fp_gen_amount_utils.fp_debug
1855: (p_msg => 'Status after calling
1856: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from): '
1857: ||x_return_status,

Line 1878: IF p_pa_debug_mode = 'Y' THEN

1874: ELSE */
1875:
1876: IF P_ACTUALS_TO_PERIOD IS NOT NULL THEN
1877: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to) api
1878: IF p_pa_debug_mode = 'Y' THEN
1879: pa_fp_gen_amount_utils.fp_debug
1880: (p_msg => 'Before calling
1881: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',
1882: p_module_name => l_module_name,

Line 1893: IF p_pa_debug_mode = 'Y' THEN

1889: X_END_DATE => l_act_to_date,
1890: X_RETURN_STATUS => X_RETURN_STATUS,
1891: X_MSG_COUNT => X_MSG_COUNT,
1892: X_MSG_DATA => X_MSG_DATA);
1893: IF p_pa_debug_mode = 'Y' THEN
1894: pa_fp_gen_amount_utils.fp_debug
1895: ( p_msg => 'Status after calling
1896: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to): '
1897: ||x_return_status,

Line 1917: IF p_pa_debug_mode = 'Y' THEN

1913: p_msg_name => 'PA_FP_NO_ETC_FROM_PERIOD');
1914: ELSE*/
1915: IF P_ETC_FROM_PERIOD IS NOT NULL THEN
1916: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from) api
1917: IF p_pa_debug_mode = 'Y' THEN
1918: pa_fp_gen_amount_utils.fp_debug
1919: (p_msg => 'Before calling
1920: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',
1921: p_module_name => l_module_name,

Line 1932: IF p_pa_debug_mode = 'Y' THEN

1928: X_END_DATE => l_etc_frm_date,
1929: X_RETURN_STATUS => X_RETURN_STATUS,
1930: X_MSG_COUNT => X_MSG_COUNT,
1931: X_MSG_DATA => X_MSG_DATA);
1932: IF p_pa_debug_mode = 'Y' THEN
1933: pa_fp_gen_amount_utils.fp_debug
1934: (p_msg => 'Status after calling
1935: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from): '
1936: ||x_return_status,

Line 1957: IF p_pa_debug_mode = 'Y' THEN

1953: p_msg_name => 'PA_FP_NO_ETC_TO_PERIOD');
1954: ELSE */
1955: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to) api
1956: IF P_ETC_TO_PERIOD IS NOT NULL THEN
1957: IF p_pa_debug_mode = 'Y' THEN
1958: pa_fp_gen_amount_utils.fp_debug
1959: (p_msg => 'Before calling
1960: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to)',
1961: p_module_name => l_module_name,

Line 1972: IF p_pa_debug_mode = 'Y' THEN

1968: X_END_DATE => l_etc_to_date,
1969: X_RETURN_STATUS => X_RETURN_STATUS,
1970: X_MSG_COUNT => X_MSG_COUNT,
1971: X_MSG_DATA => X_MSG_DATA);
1972: IF p_pa_debug_mode = 'Y' THEN
1973: pa_fp_gen_amount_utils.fp_debug
1974: (p_msg => 'Status after calling
1975: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to): '
1976: ||x_return_status,

Line 2041: IF p_pa_debug_mode = 'Y' THEN

2037: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2038: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2039: END IF;
2040:
2041: IF p_pa_debug_mode = 'Y' THEN
2042: PA_DEBUG.Reset_Curr_Function;
2043: END IF;
2044:
2045: EXCEPTION

Line 2042: PA_DEBUG.Reset_Curr_Function;

2038: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2039: END IF;
2040:
2041: IF p_pa_debug_mode = 'Y' THEN
2042: PA_DEBUG.Reset_Curr_Function;
2043: END IF;
2044:
2045: EXCEPTION
2046: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 2066: IF P_PA_DEBUG_MODE = 'Y' THEN

2062: END IF;
2063: ROLLBACK;
2064:
2065: x_return_status := FND_API.G_RET_STS_ERROR;
2066: IF P_PA_DEBUG_MODE = 'Y' THEN
2067: pa_fp_gen_amount_utils.fp_debug
2068: (p_msg => 'Invalid Arguments Passed',
2069: p_module_name => l_module_name,
2070: p_log_level => 5);

Line 2071: PA_DEBUG.Reset_Curr_Function;

2067: pa_fp_gen_amount_utils.fp_debug
2068: (p_msg => 'Invalid Arguments Passed',
2069: p_module_name => l_module_name,
2070: p_log_level => 5);
2071: PA_DEBUG.Reset_Curr_Function;
2072: END IF;
2073: RAISE;
2074:
2075: WHEN OTHERS THEN

Line 2081: IF P_PA_DEBUG_MODE = 'Y' THEN

2077: x_msg_data := SUBSTR(SQLERRM,1,240);
2078: FND_MSG_PUB.add_exc_msg
2079: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2080: ,p_procedure_name => 'VALIDATE_PERIODS');
2081: IF P_PA_DEBUG_MODE = 'Y' THEN
2082: pa_fp_gen_amount_utils.fp_debug
2083: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2084: p_module_name => l_module_name,
2085: p_log_level => 5);

Line 2086: PA_DEBUG.Reset_Curr_Function;

2082: pa_fp_gen_amount_utils.fp_debug
2083: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2084: p_module_name => l_module_name,
2085: p_log_level => 5);
2086: PA_DEBUG.Reset_Curr_Function;
2087: END IF;
2088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2089: END VALIDATE_PERIODS;
2090:

Line 2115: IF p_pa_debug_mode = 'Y' THEN

2111: --FND_MSG_PUB.initialize;
2112: --X_MSG_COUNT := 0;
2113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2114:
2115: IF p_pa_debug_mode = 'Y' THEN
2116: pa_debug.set_curr_function( p_function => 'VALIDATE_PA_GL_PERIODS'
2117: ,p_debug_mode => p_pa_debug_mode);
2118: END IF;
2119:

Line 2116: pa_debug.set_curr_function( p_function => 'VALIDATE_PA_GL_PERIODS'

2112: --X_MSG_COUNT := 0;
2113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2114:
2115: IF p_pa_debug_mode = 'Y' THEN
2116: pa_debug.set_curr_function( p_function => 'VALIDATE_PA_GL_PERIODS'
2117: ,p_debug_mode => p_pa_debug_mode);
2118: END IF;
2119:
2120: IF P_FP_COLS_REC.X_TIME_PHASED_CODE = 'P' THEN

Line 2117: ,p_debug_mode => p_pa_debug_mode);

2113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2114:
2115: IF p_pa_debug_mode = 'Y' THEN
2116: pa_debug.set_curr_function( p_function => 'VALIDATE_PA_GL_PERIODS'
2117: ,p_debug_mode => p_pa_debug_mode);
2118: END IF;
2119:
2120: IF P_FP_COLS_REC.X_TIME_PHASED_CODE = 'P' THEN
2121: SELECT END_DATE

Line 2140: IF P_PA_DEBUG_MODE = 'Y' THEN

2136: --dbms_output.put_line('End date from validate_pa_gl_periods(G) api:'||X_END_DATE);
2137:
2138: END IF;
2139:
2140: IF P_PA_DEBUG_MODE = 'Y' THEN
2141: PA_DEBUG.Reset_Curr_Function;
2142: END IF;
2143:
2144: --dbms_output.put_line('return status from pa_gl_periods api before exception: '||x_return_status);

Line 2141: PA_DEBUG.Reset_Curr_Function;

2137:
2138: END IF;
2139:
2140: IF P_PA_DEBUG_MODE = 'Y' THEN
2141: PA_DEBUG.Reset_Curr_Function;
2142: END IF;
2143:
2144: --dbms_output.put_line('return status from pa_gl_periods api before exception: '||x_return_status);
2145: EXCEPTION

Line 2185: IF P_PA_DEBUG_MODE = 'Y' THEN

2181: END IF;
2182: ROLLBACK;
2183:
2184: x_return_status := FND_API.G_RET_STS_ERROR;
2185: IF P_PA_DEBUG_MODE = 'Y' THEN
2186: pa_fp_gen_amount_utils.fp_debug
2187: (p_msg => 'Invalid periods',
2188: p_module_name => l_module_name,
2189: p_log_level => 5);

Line 2190: PA_DEBUG.Reset_Curr_Function;

2186: pa_fp_gen_amount_utils.fp_debug
2187: (p_msg => 'Invalid periods',
2188: p_module_name => l_module_name,
2189: p_log_level => 5);
2190: PA_DEBUG.Reset_Curr_Function;
2191: END IF;
2192: RAISE;
2193:
2194:

Line 2215: IF P_PA_DEBUG_MODE = 'Y' THEN

2211: END IF;
2212: ROLLBACK;
2213:
2214: x_return_status := FND_API.G_RET_STS_ERROR;
2215: IF P_PA_DEBUG_MODE = 'Y' THEN
2216: pa_fp_gen_amount_utils.fp_debug
2217: (p_msg => 'Invalid Arguments Passed',
2218: p_module_name => l_module_name,
2219: p_log_level => 5);

Line 2220: PA_DEBUG.Reset_Curr_Function;

2216: pa_fp_gen_amount_utils.fp_debug
2217: (p_msg => 'Invalid Arguments Passed',
2218: p_module_name => l_module_name,
2219: p_log_level => 5);
2220: PA_DEBUG.Reset_Curr_Function;
2221: END IF;
2222: RAISE;
2223:
2224: WHEN OTHERS THEN

Line 2230: IF P_PA_DEBUG_MODE = 'Y' THEN

2226: x_msg_data := SUBSTR(SQLERRM,1,240);
2227: FND_MSG_PUB.add_exc_msg
2228: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2229: ,p_procedure_name => 'VALIDATE_PA_GL_PERIODS');
2230: IF P_PA_DEBUG_MODE = 'Y' THEN
2231: pa_fp_gen_amount_utils.fp_debug
2232: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2233: p_module_name => l_module_name,
2234: p_log_level => 5);

Line 2235: PA_DEBUG.Reset_Curr_Function;

2231: pa_fp_gen_amount_utils.fp_debug
2232: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2233: p_module_name => l_module_name,
2234: p_log_level => 5);
2235: PA_DEBUG.Reset_Curr_Function;
2236: END IF;
2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2238: --dbms_output.put_line('return status from pa_gl_periods api inside exception(O): '||x_return_status);
2239:

Line 2265: IF p_pa_debug_mode = 'Y' THEN

2261: --FND_MSG_PUB.initialize;
2262: --X_MSG_COUNT := 0;
2263: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2264:
2265: IF p_pa_debug_mode = 'Y' THEN
2266: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
2267: ,p_debug_mode => p_pa_debug_mode);
2268: END IF;
2269:

Line 2266: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'

2262: --X_MSG_COUNT := 0;
2263: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2264:
2265: IF p_pa_debug_mode = 'Y' THEN
2266: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
2267: ,p_debug_mode => p_pa_debug_mode);
2268: END IF;
2269:
2270: IF p_plan_type_id IS NULL THEN

Line 2267: ,p_debug_mode => p_pa_debug_mode);

2263: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2264:
2265: IF p_pa_debug_mode = 'Y' THEN
2266: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
2267: ,p_debug_mode => p_pa_debug_mode);
2268: END IF;
2269:
2270: IF p_plan_type_id IS NULL THEN
2271: IF p_calling_context = 'GENERATION_SOURCE' THEN

Line 2283: IF P_PA_DEBUG_MODE = 'Y' THEN

2279: END IF;
2280: END IF;
2281:
2282: IF px_plan_version_id IS NOT NULL THEN
2283: IF P_PA_DEBUG_MODE = 'Y' THEN
2284: PA_DEBUG.RESET_CURR_FUNCTION;
2285: END IF;
2286: RETURN;
2287: END IF;

Line 2284: PA_DEBUG.RESET_CURR_FUNCTION;

2280: END IF;
2281:
2282: IF px_plan_version_id IS NOT NULL THEN
2283: IF P_PA_DEBUG_MODE = 'Y' THEN
2284: PA_DEBUG.RESET_CURR_FUNCTION;
2285: END IF;
2286: RETURN;
2287: END IF;
2288:

Line 2305: IF P_PA_DEBUG_MODE = 'Y' THEN

2301: AND bv.version_type in ('COST','ALL');
2302:
2303: px_plan_version_id := l_plan_version_id;
2304:
2305: IF P_PA_DEBUG_MODE = 'Y' THEN
2306: PA_DEBUG.Reset_Curr_Function;
2307:
2308: END IF;
2309:

Line 2306: PA_DEBUG.Reset_Curr_Function;

2302:
2303: px_plan_version_id := l_plan_version_id;
2304:
2305: IF P_PA_DEBUG_MODE = 'Y' THEN
2306: PA_DEBUG.Reset_Curr_Function;
2307:
2308: END IF;
2309:
2310:

Line 2321: IF P_PA_DEBUG_MODE = 'Y' THEN

2317: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN
2318: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2319: p_msg_name => 'PA_FP_INV_ETC_BV');
2320: END IF;
2321: IF P_PA_DEBUG_MODE = 'Y' THEN
2322: pa_fp_gen_amount_utils.fp_debug
2323: (p_msg => 'Invalid source',
2324: p_module_name => l_module_name,
2325: p_log_level => 5);

Line 2326: PA_DEBUG.Reset_Curr_Function;

2322: pa_fp_gen_amount_utils.fp_debug
2323: (p_msg => 'Invalid source',
2324: p_module_name => l_module_name,
2325: p_log_level => 5);
2326: PA_DEBUG.Reset_Curr_Function;
2327: END IF;
2328: RAISE;
2329:
2330: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 2348: IF P_PA_DEBUG_MODE = 'Y' THEN

2344: END IF;
2345: ROLLBACK;
2346:
2347: x_return_status := FND_API.G_RET_STS_ERROR;
2348: IF P_PA_DEBUG_MODE = 'Y' THEN
2349: pa_fp_gen_amount_utils.fp_debug
2350: (p_msg => 'Invalid Arguments Passed',
2351: p_module_name => l_module_name,
2352: p_log_level => 5);

Line 2353: PA_DEBUG.Reset_Curr_Function;

2349: pa_fp_gen_amount_utils.fp_debug
2350: (p_msg => 'Invalid Arguments Passed',
2351: p_module_name => l_module_name,
2352: p_log_level => 5);
2353: PA_DEBUG.Reset_Curr_Function;
2354: END IF;
2355: RAISE;
2356:
2357: WHEN OTHERS THEN

Line 2363: IF P_PA_DEBUG_MODE = 'Y' THEN

2359: x_msg_data := SUBSTR(SQLERRM,1,240);
2360: FND_MSG_PUB.add_exc_msg
2361: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2362: ,p_procedure_name => 'VALIDATE_PLAN_TYPE_OR_VERSION');
2363: IF P_PA_DEBUG_MODE = 'Y' THEN
2364: pa_fp_gen_amount_utils.fp_debug
2365: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2366: p_module_name => l_module_name,
2367: p_log_level => 5);

Line 2368: PA_DEBUG.Reset_Curr_Function;

2364: pa_fp_gen_amount_utils.fp_debug
2365: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2366: p_module_name => l_module_name,
2367: p_log_level => 5);
2368: PA_DEBUG.Reset_Curr_Function;
2369: END IF;
2370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2371:
2372: END VALIDATE_PLAN_TYPE_OR_VERSION;