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.10 2007/11/27 11:34:27 vgovvala 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 205: IF p_pa_debug_mode = 'Y' THEN

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

Line 206: PA_DEBUG.Reset_Curr_Function;

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

Line 227: IF p_pa_debug_mode = 'Y' THEN

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

Line 228: PA_DEBUG.Reset_Curr_Function;

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

Line 232: IF p_pa_debug_mode = 'Y' THEN

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

Line 233: PA_DEBUG.Reset_Curr_Function;

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

Line 238: IF p_pa_debug_mode = 'Y' THEN

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

Line 239: PA_DEBUG.Reset_Curr_Function;

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

Line 268: IF p_pa_debug_mode = 'Y' THEN

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

Line 269: PA_DEBUG.Reset_Curr_Function;

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

Line 275: IF p_pa_debug_mode = 'Y' THEN

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

Line 276: PA_DEBUG.Reset_Curr_Function;

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

Line 280: IF p_pa_debug_mode = 'Y' THEN

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

Line 281: PA_DEBUG.Reset_Curr_Function;

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

Line 301: IF p_pa_debug_mode = 'Y' THEN

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

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

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

Line 303: p_debug_mode => p_pa_debug_mode);

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

Line 306: IF p_pa_debug_mode = 'Y' THEN

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

Line 322: IF p_pa_debug_mode = 'Y' THEN

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

Line 340: IF p_pa_debug_mode = 'Y' THEN

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

Line 341: PA_DEBUG.Reset_Curr_Function;

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

Line 356: IF p_pa_debug_mode = 'Y' THEN

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

Line 357: PA_DEBUG.Reset_Curr_Function;

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

Line 362: IF p_pa_debug_mode = 'Y' THEN

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

Line 363: PA_DEBUG.Reset_Curr_Function;

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

Line 368: IF p_pa_debug_mode = 'Y' THEN

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

Line 369: PA_DEBUG.Reset_Curr_Function;

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

Line 373: IF p_pa_debug_mode = 'Y' THEN

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

Line 374: PA_DEBUG.Reset_Curr_Function;

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

Line 393: IF p_pa_debug_mode = 'Y' THEN

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

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

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

Line 395: p_debug_mode => p_pa_debug_mode);

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

Line 398: IF p_pa_debug_mode = 'Y' THEN

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

Line 415: IF p_pa_debug_mode = 'Y' THEN

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

Line 443: IF p_pa_debug_mode = 'Y' THEN

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

Line 444: PA_DEBUG.Reset_Curr_Function;

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

Line 466: IF p_pa_debug_mode = 'Y' THEN

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

Line 467: PA_DEBUG.Reset_Curr_Function;

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

Line 479: IF p_pa_debug_mode = 'Y' THEN

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

Line 480: PA_DEBUG.Reset_Curr_Function;

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

Line 485: IF p_pa_debug_mode = 'Y' THEN

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

Line 486: PA_DEBUG.Reset_Curr_Function;

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

Line 490: IF p_pa_debug_mode = 'Y' THEN

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

Line 491: PA_DEBUG.Reset_Curr_Function;

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

Line 510: IF p_pa_debug_mode = 'Y' THEN

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

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

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

Line 512: p_debug_mode => p_pa_debug_mode);

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

Line 515: IF p_pa_debug_mode = 'Y' THEN

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

Line 532: IF p_pa_debug_mode = 'Y' THEN

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

Line 552: IF p_pa_debug_mode = 'Y' THEN

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

Line 553: PA_DEBUG.Reset_Curr_Function;

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

Line 566: IF p_pa_debug_mode = 'Y' THEN

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

Line 567: PA_DEBUG.Reset_Curr_Function;

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

Line 572: IF p_pa_debug_mode = 'Y' THEN

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

Line 573: PA_DEBUG.Reset_Curr_Function;

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

Line 578: IF p_pa_debug_mode = 'Y' THEN

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

Line 579: PA_DEBUG.Reset_Curr_Function;

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

Line 604: IF p_pa_debug_mode = 'Y' THEN

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

Line 605: PA_DEBUG.Reset_Curr_Function;

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

Line 609: IF p_pa_debug_mode = 'Y' THEN

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

Line 610: PA_DEBUG.Reset_Curr_Function;

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

Line 629: IF p_pa_debug_mode = 'Y' THEN

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

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

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

Line 631: p_debug_mode => p_pa_debug_mode);

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

Line 634: IF p_pa_debug_mode = 'Y' THEN

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

Line 650: IF p_pa_debug_mode = 'Y' THEN

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

Line 675: IF p_pa_debug_mode = 'Y' THEN

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

Line 676: PA_DEBUG.Reset_Curr_Function;

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

Line 695: IF p_pa_debug_mode = 'Y' THEN

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

Line 696: PA_DEBUG.Reset_Curr_Function;

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

Line 701: IF p_pa_debug_mode = 'Y' THEN

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

Line 702: PA_DEBUG.Reset_Curr_Function;

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

Line 707: IF p_pa_debug_mode = 'Y' THEN

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

Line 708: PA_DEBUG.Reset_Curr_Function;

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

Line 712: IF p_pa_debug_mode = 'Y' THEN

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

Line 713: PA_DEBUG.Reset_Curr_Function;

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

Line 748: IF p_pa_debug_mode = 'Y' THEN

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

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

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

Line 750: ,p_debug_mode => p_pa_debug_mode);

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

Line 759: IF P_PA_DEBUG_MODE = 'Y' THEN

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

Line 760: PA_DEBUG.Reset_Curr_Function;

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

Line 783: IF P_PA_DEBUG_MODE = 'Y' THEN

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

Line 788: PA_DEBUG.Reset_Curr_Function;

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

Line 798: IF P_PA_DEBUG_MODE = 'Y' THEN

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

Line 803: PA_DEBUG.Reset_Curr_Function;

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

Line 889: IF p_pa_debug_mode = 'Y' THEN

885: X_MSG_COUNT := 0;
886: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
887: l_return_status := FND_API.G_RET_STS_SUCCESS;
888:
889: IF p_pa_debug_mode = 'Y' THEN
890: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'
891: ,p_debug_mode => p_pa_debug_mode);
892: END IF;
893:

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

886: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
887: l_return_status := FND_API.G_RET_STS_SUCCESS;
888:
889: IF p_pa_debug_mode = 'Y' THEN
890: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'
891: ,p_debug_mode => p_pa_debug_mode);
892: END IF;
893:
894: /*Bug fix:3818180 for locking*/

Line 891: ,p_debug_mode => p_pa_debug_mode);

887: l_return_status := FND_API.G_RET_STS_SUCCESS;
888:
889: IF p_pa_debug_mode = 'Y' THEN
890: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'
891: ,p_debug_mode => p_pa_debug_mode);
892: END IF;
893:
894: /*Bug fix:3818180 for locking*/
895: --acquire version lock

Line 901: IF p_pa_debug_mode = 'Y' THEN

897: SELECT record_version_number
898: INTO l_record_version_number
899: FROM pa_budget_versions
900: WHERE budget_version_id = p_budget_version_id;
901: IF p_pa_debug_mode = 'Y' THEN
902: pa_fp_gen_amount_utils.fp_debug
903: (p_msg => 'Before calling pa_fin_plan_pvt.lock_unlock_version',
904: p_module_name => l_module_name);
905: END IF;

Line 915: IF p_pa_debug_mode = 'Y' THEN

911: p_person_id => NULL,
912: x_return_status => x_return_status,
913: x_msg_count => x_msg_count,
914: x_msg_data => x_msg_data);
915: IF p_pa_debug_mode = 'Y' THEN
916: pa_fp_gen_amount_utils.fp_debug
917: (p_msg => 'Status after calling pa_fin_plan_pvt.lock_unlock_version:'
918: ||x_return_status,
919: p_module_name => l_module_name);

Line 923: IF p_pa_debug_mode = 'Y' THEN

919: p_module_name => l_module_name);
920: END IF;
921:
922: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
923: IF p_pa_debug_mode = 'Y' THEN
924: PA_DEBUG.Reset_Curr_Function;
925: END IF;
926: RETURN;
927: END IF;

Line 924: PA_DEBUG.Reset_Curr_Function;

920: END IF;
921:
922: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
923: IF p_pa_debug_mode = 'Y' THEN
924: PA_DEBUG.Reset_Curr_Function;
925: END IF;
926: RETURN;
927: END IF;
928:

Line 935: IF p_pa_debug_mode = 'Y' THEN

931: /* we need to commit the changes so that the locked by person info
932: will be available for other sessions. */
933:
934: --acquire lock for copy_actual
935: IF p_pa_debug_mode = 'Y' THEN
936: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
937: P_MSG => 'Before calling PA_FP_COPY_FROM_PKG.'
938: ||'ACQUIRE_LOCKS_FOR_COPY_ACTUAL',
939: P_MODULE_NAME => l_module_name);

Line 950: IF p_pa_debug_mode = 'Y' THEN

946: X_MSG_DATA => X_MSG_DATA);
947: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
948: --If can't acquire lock, customized message is thrown from within
949: -- the API, so we should suppress exception error
950: IF p_pa_debug_mode = 'Y' THEN
951: PA_DEBUG.Reset_Curr_Function;
952: END IF;
953: RETURN;
954: END IF;

Line 951: PA_DEBUG.Reset_Curr_Function;

947: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
948: --If can't acquire lock, customized message is thrown from within
949: -- the API, so we should suppress exception error
950: IF p_pa_debug_mode = 'Y' THEN
951: PA_DEBUG.Reset_Curr_Function;
952: END IF;
953: RETURN;
954: END IF;
955:

Line 956: IF p_pa_debug_mode = 'Y' THEN

952: END IF;
953: RETURN;
954: END IF;
955:
956: IF p_pa_debug_mode = 'Y' THEN
957: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
958: P_MSG => 'After calling PA_FP_COPY_FROM_PKG.'
959: ||'ACQUIRE_LOCKS_FOR_COPY_ACTUAL: '
960: ||x_return_status,

Line 970: IF p_pa_debug_mode = 'Y' THEN

966: l_PLAN_VERSION_ID := P_PLAN_VERSION_ID;
967: l_ETC_PLAN_VERSION_ID := P_ETC_PLAN_VERSION_ID;
968:
969: --Calling the Util API
970: IF p_pa_debug_mode = 'Y' THEN
971: pa_fp_gen_amount_utils.fp_debug
972: (p_msg => 'Before calling
973: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
974: p_module_name => l_module_name,

Line 986: IF p_pa_debug_mode = 'Y' THEN

982: X_MSG_DATA => X_MSG_DATA);
983: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
984: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
985: END IF;
986: IF p_pa_debug_mode = 'Y' THEN
987: pa_fp_gen_amount_utils.fp_debug
988: (p_msg => 'Status after calling
989: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
990: ||x_return_status,

Line 1009: IF p_pa_debug_mode = 'Y' THEN

1005: /* the validation should not happen when the forecast gen source is
1006: RESOURCE SCHEDULE. */
1007:
1008: IF L_FP_COLS_REC.X_GEN_ETC_SRC_CODE <> 'RESOURCE_SCHEDULE' THEN
1009: IF p_pa_debug_mode = 'Y' THEN
1010: pa_fp_gen_amount_utils.fp_debug
1011: (p_msg => 'Before calling
1012: pa_fp_gen_fcst_pg_pkg.validate_periods',
1013: p_module_name => l_module_name,

Line 1032: IF p_pa_debug_mode = 'Y' THEN

1028: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1029: l_return_status := X_RETURN_STATUS;
1030: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1031: END IF;
1032: IF p_pa_debug_mode = 'Y' THEN
1033: pa_fp_gen_amount_utils.fp_debug
1034: (p_msg => 'Status after calling
1035: pa_fp_gen_fcst_pg_pkg.validate_periods: '
1036: ||x_return_status,

Line 1046: IF p_pa_debug_mode = 'Y' THEN

1042: /* Calling Validate plan type or version api -> etc_generation_source'*/
1043: IF P_ETC_PLAN_TYPE_ID IS NOT NULL AND
1044: P_ETC_PLAN_VERSION_NAME IS NOT NULL AND
1045: l_ETC_PLAN_VERSION_ID IS NULL THEN
1046: IF p_pa_debug_mode = 'Y' THEN
1047: pa_fp_gen_amount_utils.fp_debug
1048: (p_msg => 'Before calling
1049: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version',
1050: p_module_name => l_module_name,

Line 1066: IF p_pa_debug_mode = 'Y' THEN

1062: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1063: l_return_status := X_RETURN_STATUS;
1064: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1065: END IF;
1066: IF p_pa_debug_mode = 'Y' THEN
1067: pa_fp_gen_amount_utils.fp_debug
1068: ( p_msg => 'Status after calling
1069: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version for etc_generation_source: '
1070: ||x_return_status,

Line 1090: IF p_pa_debug_mode = 'Y' THEN

1086: WHERE budget_version_id = P_BUDGET_VERSION_ID;
1087:
1088: -- IPM: New Entity ER ------------------------------------------
1089: -- Call the maintenance api in DELETE mode
1090: IF p_pa_debug_mode = 'Y' THEN
1091: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1092: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1093: || 'MAINTAIN_DATA',
1094: --P_CALLED_MODE => p_called_mode,

Line 1107: IF p_pa_debug_mode = 'Y' THEN

1103: --P_CALLED_MODE => p_called_mode,
1104: X_RETURN_STATUS => x_return_status,
1105: X_MSG_COUNT => x_msg_count,
1106: X_MSG_DATA => x_msg_data );
1107: IF p_pa_debug_mode = 'Y' THEN
1108: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1109: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1110: || 'MAINTAIN_DATA: ' || x_return_status,
1111: --P_CALLED_MODE => p_called_mode,

Line 1163: IF p_pa_debug_mode = 'Y' THEN

1159: l_res_asg_id_del_tab(k),
1160: 'Y' );
1161:
1162: -- Call the maintenance api in DELETE mode
1163: IF p_pa_debug_mode = 'Y' THEN
1164: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1165: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1166: || 'MAINTAIN_DATA',
1167: --P_CALLED_MODE => p_called_mode,

Line 1180: IF p_pa_debug_mode = 'Y' THEN

1176: --P_CALLED_MODE => p_called_mode,
1177: X_RETURN_STATUS => x_return_status,
1178: X_MSG_COUNT => x_msg_count,
1179: X_MSG_DATA => x_msg_data );
1180: IF p_pa_debug_mode = 'Y' THEN
1181: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1182: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1183: || 'MAINTAIN_DATA: ' || x_return_status,
1184: --P_CALLED_MODE => p_called_mode,

Line 1284: IF p_pa_debug_mode = 'Y' THEN

1280:
1281: /* We need to get version details again after validation logic and
1282: * updates to the budget version so that we pass the most current
1283: * information to lower level APIs via the l_fp_cols_rec parameter. */
1284: IF p_pa_debug_mode = 'Y' THEN
1285: pa_fp_gen_amount_utils.fp_debug
1286: ( p_msg => 'Before calling
1287: pa_fp_gen_amount_utils.get_plan_version_dtls',
1288: p_module_name => l_module_name,

Line 1301: IF p_pa_debug_mode = 'Y' THEN

1297:
1298: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1299: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1300: END IF;
1301: IF p_pa_debug_mode = 'Y' THEN
1302: pa_fp_gen_amount_utils.fp_debug
1303: ( p_msg => 'Status after calling
1304: pa_fp_gen_amount_utils.get_plan_version_dtls: '
1305: ||x_return_status,

Line 1314: IF p_pa_debug_mode = 'Y' THEN

1310: /* This API validates that the current generation is supported.
1311: * For a list of unsupported cases, please see comments at the
1312: * beginning of the VALIDATE_SUPPORT_CASES API (PAFPGAUB.pls) */
1313:
1314: IF p_pa_debug_mode = 'Y' THEN
1315: pa_fp_gen_amount_utils.fp_debug
1316: ( p_msg => 'Before calling
1317: pa_fp_gen_amount_utils.validate_support_cases',
1318: p_module_name => l_module_name,

Line 1328: IF p_pa_debug_mode = 'Y' THEN

1324: X_WARNING_MESSAGE => X_WARNING_MESSAGE,
1325: X_RETURN_STATUS => X_RETURN_STATUS,
1326: X_MSG_COUNT => X_MSG_COUNT,
1327: X_MSG_DATA => X_MSG_DATA );
1328: IF p_pa_debug_mode = 'Y' THEN
1329: pa_fp_gen_amount_utils.fp_debug
1330: ( p_msg => 'Status after calling
1331: pa_fp_gen_amount_utils.validate_support_cases: '
1332: ||x_return_status,

Line 1350: IF p_pa_debug_mode = 'Y' THEN

1346: IF P_CHECK_SRC_ERRORS_FLAG = 'Y' THEN
1347: -- Added the above IF and Commented below if condition bug 4901256
1348: -- IF X_WARNING_MESSAGE IS NOT NULL THEN
1349: -- Before returning, we always have the following check.
1350: IF p_pa_debug_mode = 'Y' THEN
1351: PA_DEBUG.Reset_Curr_Function;
1352: END IF;
1353:
1354: RETURN;

Line 1351: PA_DEBUG.Reset_Curr_Function;

1347: -- Added the above IF and Commented below if condition bug 4901256
1348: -- IF X_WARNING_MESSAGE IS NOT NULL THEN
1349: -- Before returning, we always have the following check.
1350: IF p_pa_debug_mode = 'Y' THEN
1351: PA_DEBUG.Reset_Curr_Function;
1352: END IF;
1353:
1354: RETURN;
1355: END IF;

Line 1358: IF p_pa_debug_mode = 'Y' THEN

1354: RETURN;
1355: END IF;
1356:
1357: --Calling Gen FCST Amt Wrapper API
1358: IF p_pa_debug_mode = 'Y' THEN
1359: pa_fp_gen_amount_utils.fp_debug
1360: (p_msg => 'Before calling
1361: pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp',
1362: p_module_name => l_module_name,

Line 1396: IF p_pa_debug_mode = 'Y' THEN

1392: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1393: l_return_status := X_RETURN_STATUS;
1394: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1395: END IF;
1396: IF p_pa_debug_mode = 'Y' THEN
1397: pa_fp_gen_amount_utils.fp_debug
1398: (p_msg => 'Status after calling
1399: pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp: '
1400: ||x_return_status,

Line 1412: IF p_pa_debug_mode = 'Y' THEN

1408: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1409: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1410: END IF;
1411:
1412: IF p_pa_debug_mode = 'Y' THEN
1413: PA_DEBUG.Reset_Curr_Function;
1414: END IF;
1415:
1416: EXCEPTION

Line 1413: PA_DEBUG.Reset_Curr_Function;

1409: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1410: END IF;
1411:
1412: IF p_pa_debug_mode = 'Y' THEN
1413: PA_DEBUG.Reset_Curr_Function;
1414: END IF;
1415:
1416: EXCEPTION
1417: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1438: IF P_PA_DEBUG_MODE = 'Y' THEN

1434: ROLLBACK;
1435:
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437:
1438: IF P_PA_DEBUG_MODE = 'Y' THEN
1439: pa_fp_gen_amount_utils.fp_debug
1440: (p_msg => 'Invalid Arguments Passed',
1441: p_module_name => l_module_name,
1442: p_log_level => 5);

Line 1443: PA_DEBUG.Reset_Curr_Function;

1439: pa_fp_gen_amount_utils.fp_debug
1440: (p_msg => 'Invalid Arguments Passed',
1441: p_module_name => l_module_name,
1442: p_log_level => 5);
1443: PA_DEBUG.Reset_Curr_Function;
1444: END IF;
1445: RAISE;
1446:
1447: WHEN OTHERS THEN

Line 1456: IF P_PA_DEBUG_MODE = 'Y' THEN

1452:
1453: FND_MSG_PUB.add_exc_msg
1454: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1455: ,p_procedure_name => 'UPD_VER_DTLS_AND_GEN_AMT');
1456: IF P_PA_DEBUG_MODE = 'Y' THEN
1457: pa_fp_gen_amount_utils.fp_debug
1458: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1459: p_module_name => l_module_name,
1460: p_log_level => 5);

Line 1461: PA_DEBUG.Reset_Curr_Function;

1457: pa_fp_gen_amount_utils.fp_debug
1458: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1459: p_module_name => l_module_name,
1460: p_log_level => 5);
1461: PA_DEBUG.Reset_Curr_Function;
1462: END IF;
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464:
1465: END UPD_VER_DTLS_AND_GEN_AMT;

Line 1506: IF p_pa_debug_mode = 'Y' THEN

1502: --X_MSG_COUNT := 0;
1503: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1504: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1505:
1506: IF p_pa_debug_mode = 'Y' THEN
1507: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'
1508: ,p_debug_mode => p_pa_debug_mode);
1509: END IF;
1510:

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

1503: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1504: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1505:
1506: IF p_pa_debug_mode = 'Y' THEN
1507: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'
1508: ,p_debug_mode => p_pa_debug_mode);
1509: END IF;
1510:
1511: --Validating unspent amount period

Line 1508: ,p_debug_mode => p_pa_debug_mode);

1504: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1505:
1506: IF p_pa_debug_mode = 'Y' THEN
1507: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'
1508: ,p_debug_mode => p_pa_debug_mode);
1509: END IF;
1510:
1511: --Validating unspent amount period
1512: IF P_FP_COLS_REC.X_TIME_PHASED_CODE <> 'N'

Line 1522: IF p_pa_debug_mode = 'Y' THEN

1518: END IF;
1519:
1520: IF P_UNSPENT_AMT_FLAG = 'Y' AND P_UNSPENT_AMT_PERIOD IS NOT NULL THEN
1521: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date) api
1522: IF p_pa_debug_mode = 'Y' THEN
1523: pa_fp_gen_amount_utils.fp_debug
1524: (p_msg => 'Before calling
1525: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',
1526: p_module_name => l_module_name,

Line 1538: IF p_pa_debug_mode = 'Y' THEN

1534: X_RETURN_STATUS => X_RETURN_STATUS,
1535: X_MSG_COUNT => X_MSG_COUNT,
1536: X_MSG_DATA => X_MSG_DATA);
1537: l_return_status := X_RETURN_STATUS;
1538: IF p_pa_debug_mode = 'Y' THEN
1539: pa_fp_gen_amount_utils.fp_debug
1540: (p_msg => 'Status after calling
1541: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date): '
1542: ||x_return_status,

Line 1557: IF p_pa_debug_mode = 'Y' THEN

1553: ELSE*/
1554:
1555: IF P_ACTUALS_FROM_PERIOD IS NOT NULL THEN
1556: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from) api
1557: IF p_pa_debug_mode = 'Y' THEN
1558: pa_fp_gen_amount_utils.fp_debug
1559: (p_msg => 'Before calling
1560: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',
1561: p_module_name => l_module_name,

Line 1572: IF p_pa_debug_mode = 'Y' THEN

1568: X_END_DATE => l_act_frm_date,
1569: X_RETURN_STATUS => X_RETURN_STATUS,
1570: X_MSG_COUNT => X_MSG_COUNT,
1571: X_MSG_DATA => X_MSG_DATA);
1572: IF p_pa_debug_mode = 'Y' THEN
1573: pa_fp_gen_amount_utils.fp_debug
1574: (p_msg => 'Status after calling
1575: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from): '
1576: ||x_return_status,

Line 1597: IF p_pa_debug_mode = 'Y' THEN

1593: ELSE */
1594:
1595: IF P_ACTUALS_TO_PERIOD IS NOT NULL THEN
1596: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to) api
1597: IF p_pa_debug_mode = 'Y' THEN
1598: pa_fp_gen_amount_utils.fp_debug
1599: (p_msg => 'Before calling
1600: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',
1601: p_module_name => l_module_name,

Line 1612: IF p_pa_debug_mode = 'Y' THEN

1608: X_END_DATE => l_act_to_date,
1609: X_RETURN_STATUS => X_RETURN_STATUS,
1610: X_MSG_COUNT => X_MSG_COUNT,
1611: X_MSG_DATA => X_MSG_DATA);
1612: IF p_pa_debug_mode = 'Y' THEN
1613: pa_fp_gen_amount_utils.fp_debug
1614: ( p_msg => 'Status after calling
1615: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to): '
1616: ||x_return_status,

Line 1636: IF p_pa_debug_mode = 'Y' THEN

1632: p_msg_name => 'PA_FP_NO_ETC_FROM_PERIOD');
1633: ELSE*/
1634: IF P_ETC_FROM_PERIOD IS NOT NULL THEN
1635: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from) api
1636: IF p_pa_debug_mode = 'Y' THEN
1637: pa_fp_gen_amount_utils.fp_debug
1638: (p_msg => 'Before calling
1639: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',
1640: p_module_name => l_module_name,

Line 1651: IF p_pa_debug_mode = 'Y' THEN

1647: X_END_DATE => l_etc_frm_date,
1648: X_RETURN_STATUS => X_RETURN_STATUS,
1649: X_MSG_COUNT => X_MSG_COUNT,
1650: X_MSG_DATA => X_MSG_DATA);
1651: IF p_pa_debug_mode = 'Y' THEN
1652: pa_fp_gen_amount_utils.fp_debug
1653: (p_msg => 'Status after calling
1654: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from): '
1655: ||x_return_status,

Line 1676: IF p_pa_debug_mode = 'Y' THEN

1672: p_msg_name => 'PA_FP_NO_ETC_TO_PERIOD');
1673: ELSE */
1674: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to) api
1675: IF P_ETC_TO_PERIOD IS NOT NULL THEN
1676: IF p_pa_debug_mode = 'Y' THEN
1677: pa_fp_gen_amount_utils.fp_debug
1678: (p_msg => 'Before calling
1679: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to)',
1680: p_module_name => l_module_name,

Line 1691: IF p_pa_debug_mode = 'Y' THEN

1687: X_END_DATE => l_etc_to_date,
1688: X_RETURN_STATUS => X_RETURN_STATUS,
1689: X_MSG_COUNT => X_MSG_COUNT,
1690: X_MSG_DATA => X_MSG_DATA);
1691: IF p_pa_debug_mode = 'Y' THEN
1692: pa_fp_gen_amount_utils.fp_debug
1693: (p_msg => 'Status after calling
1694: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to): '
1695: ||x_return_status,

Line 1760: IF p_pa_debug_mode = 'Y' THEN

1756: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1757: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1758: END IF;
1759:
1760: IF p_pa_debug_mode = 'Y' THEN
1761: PA_DEBUG.Reset_Curr_Function;
1762: END IF;
1763:
1764: EXCEPTION

Line 1761: PA_DEBUG.Reset_Curr_Function;

1757: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1758: END IF;
1759:
1760: IF p_pa_debug_mode = 'Y' THEN
1761: PA_DEBUG.Reset_Curr_Function;
1762: END IF;
1763:
1764: EXCEPTION
1765: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1785: IF P_PA_DEBUG_MODE = 'Y' THEN

1781: END IF;
1782: ROLLBACK;
1783:
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: IF P_PA_DEBUG_MODE = 'Y' THEN
1786: pa_fp_gen_amount_utils.fp_debug
1787: (p_msg => 'Invalid Arguments Passed',
1788: p_module_name => l_module_name,
1789: p_log_level => 5);

Line 1790: PA_DEBUG.Reset_Curr_Function;

1786: pa_fp_gen_amount_utils.fp_debug
1787: (p_msg => 'Invalid Arguments Passed',
1788: p_module_name => l_module_name,
1789: p_log_level => 5);
1790: PA_DEBUG.Reset_Curr_Function;
1791: END IF;
1792: RAISE;
1793:
1794: WHEN OTHERS THEN

Line 1800: IF P_PA_DEBUG_MODE = 'Y' THEN

1796: x_msg_data := SUBSTR(SQLERRM,1,240);
1797: FND_MSG_PUB.add_exc_msg
1798: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1799: ,p_procedure_name => 'VALIDATE_PERIODS');
1800: IF P_PA_DEBUG_MODE = 'Y' THEN
1801: pa_fp_gen_amount_utils.fp_debug
1802: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1803: p_module_name => l_module_name,
1804: p_log_level => 5);

Line 1805: PA_DEBUG.Reset_Curr_Function;

1801: pa_fp_gen_amount_utils.fp_debug
1802: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1803: p_module_name => l_module_name,
1804: p_log_level => 5);
1805: PA_DEBUG.Reset_Curr_Function;
1806: END IF;
1807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1808: END VALIDATE_PERIODS;
1809:

Line 1834: IF p_pa_debug_mode = 'Y' THEN

1830: --FND_MSG_PUB.initialize;
1831: --X_MSG_COUNT := 0;
1832: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1833:
1834: IF p_pa_debug_mode = 'Y' THEN
1835: pa_debug.set_curr_function( p_function => 'VALIDATE_PA_GL_PERIODS'
1836: ,p_debug_mode => p_pa_debug_mode);
1837: END IF;
1838:

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

1831: --X_MSG_COUNT := 0;
1832: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1833:
1834: IF p_pa_debug_mode = 'Y' THEN
1835: pa_debug.set_curr_function( p_function => 'VALIDATE_PA_GL_PERIODS'
1836: ,p_debug_mode => p_pa_debug_mode);
1837: END IF;
1838:
1839: IF P_FP_COLS_REC.X_TIME_PHASED_CODE = 'P' THEN

Line 1836: ,p_debug_mode => p_pa_debug_mode);

1832: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1833:
1834: IF p_pa_debug_mode = 'Y' THEN
1835: pa_debug.set_curr_function( p_function => 'VALIDATE_PA_GL_PERIODS'
1836: ,p_debug_mode => p_pa_debug_mode);
1837: END IF;
1838:
1839: IF P_FP_COLS_REC.X_TIME_PHASED_CODE = 'P' THEN
1840: SELECT END_DATE

Line 1859: IF P_PA_DEBUG_MODE = 'Y' THEN

1855: --dbms_output.put_line('End date from validate_pa_gl_periods(G) api:'||X_END_DATE);
1856:
1857: END IF;
1858:
1859: IF P_PA_DEBUG_MODE = 'Y' THEN
1860: PA_DEBUG.Reset_Curr_Function;
1861: END IF;
1862:
1863: --dbms_output.put_line('return status from pa_gl_periods api before exception: '||x_return_status);

Line 1860: PA_DEBUG.Reset_Curr_Function;

1856:
1857: END IF;
1858:
1859: IF P_PA_DEBUG_MODE = 'Y' THEN
1860: PA_DEBUG.Reset_Curr_Function;
1861: END IF;
1862:
1863: --dbms_output.put_line('return status from pa_gl_periods api before exception: '||x_return_status);
1864: EXCEPTION

Line 1904: IF P_PA_DEBUG_MODE = 'Y' THEN

1900: END IF;
1901: ROLLBACK;
1902:
1903: x_return_status := FND_API.G_RET_STS_ERROR;
1904: IF P_PA_DEBUG_MODE = 'Y' THEN
1905: pa_fp_gen_amount_utils.fp_debug
1906: (p_msg => 'Invalid periods',
1907: p_module_name => l_module_name,
1908: p_log_level => 5);

Line 1909: PA_DEBUG.Reset_Curr_Function;

1905: pa_fp_gen_amount_utils.fp_debug
1906: (p_msg => 'Invalid periods',
1907: p_module_name => l_module_name,
1908: p_log_level => 5);
1909: PA_DEBUG.Reset_Curr_Function;
1910: END IF;
1911: RAISE;
1912:
1913:

Line 1934: IF P_PA_DEBUG_MODE = 'Y' THEN

1930: END IF;
1931: ROLLBACK;
1932:
1933: x_return_status := FND_API.G_RET_STS_ERROR;
1934: IF P_PA_DEBUG_MODE = 'Y' THEN
1935: pa_fp_gen_amount_utils.fp_debug
1936: (p_msg => 'Invalid Arguments Passed',
1937: p_module_name => l_module_name,
1938: p_log_level => 5);

Line 1939: PA_DEBUG.Reset_Curr_Function;

1935: pa_fp_gen_amount_utils.fp_debug
1936: (p_msg => 'Invalid Arguments Passed',
1937: p_module_name => l_module_name,
1938: p_log_level => 5);
1939: PA_DEBUG.Reset_Curr_Function;
1940: END IF;
1941: RAISE;
1942:
1943: WHEN OTHERS THEN

Line 1949: IF P_PA_DEBUG_MODE = 'Y' THEN

1945: x_msg_data := SUBSTR(SQLERRM,1,240);
1946: FND_MSG_PUB.add_exc_msg
1947: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1948: ,p_procedure_name => 'VALIDATE_PA_GL_PERIODS');
1949: IF P_PA_DEBUG_MODE = 'Y' THEN
1950: pa_fp_gen_amount_utils.fp_debug
1951: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1952: p_module_name => l_module_name,
1953: p_log_level => 5);

Line 1954: PA_DEBUG.Reset_Curr_Function;

1950: pa_fp_gen_amount_utils.fp_debug
1951: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1952: p_module_name => l_module_name,
1953: p_log_level => 5);
1954: PA_DEBUG.Reset_Curr_Function;
1955: END IF;
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957: --dbms_output.put_line('return status from pa_gl_periods api inside exception(O): '||x_return_status);
1958:

Line 1984: IF p_pa_debug_mode = 'Y' THEN

1980: --FND_MSG_PUB.initialize;
1981: --X_MSG_COUNT := 0;
1982: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1983:
1984: IF p_pa_debug_mode = 'Y' THEN
1985: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
1986: ,p_debug_mode => p_pa_debug_mode);
1987: END IF;
1988:

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

1981: --X_MSG_COUNT := 0;
1982: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1983:
1984: IF p_pa_debug_mode = 'Y' THEN
1985: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
1986: ,p_debug_mode => p_pa_debug_mode);
1987: END IF;
1988:
1989: IF p_plan_type_id IS NULL THEN

Line 1986: ,p_debug_mode => p_pa_debug_mode);

1982: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1983:
1984: IF p_pa_debug_mode = 'Y' THEN
1985: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
1986: ,p_debug_mode => p_pa_debug_mode);
1987: END IF;
1988:
1989: IF p_plan_type_id IS NULL THEN
1990: IF p_calling_context = 'GENERATION_SOURCE' THEN

Line 2002: IF P_PA_DEBUG_MODE = 'Y' THEN

1998: END IF;
1999: END IF;
2000:
2001: IF px_plan_version_id IS NOT NULL THEN
2002: IF P_PA_DEBUG_MODE = 'Y' THEN
2003: PA_DEBUG.RESET_CURR_FUNCTION;
2004: END IF;
2005: RETURN;
2006: END IF;

Line 2003: PA_DEBUG.RESET_CURR_FUNCTION;

1999: END IF;
2000:
2001: IF px_plan_version_id IS NOT NULL THEN
2002: IF P_PA_DEBUG_MODE = 'Y' THEN
2003: PA_DEBUG.RESET_CURR_FUNCTION;
2004: END IF;
2005: RETURN;
2006: END IF;
2007:

Line 2024: IF P_PA_DEBUG_MODE = 'Y' THEN

2020: AND bv.version_type in ('COST','ALL');
2021:
2022: px_plan_version_id := l_plan_version_id;
2023:
2024: IF P_PA_DEBUG_MODE = 'Y' THEN
2025: PA_DEBUG.Reset_Curr_Function;
2026:
2027: END IF;
2028:

Line 2025: PA_DEBUG.Reset_Curr_Function;

2021:
2022: px_plan_version_id := l_plan_version_id;
2023:
2024: IF P_PA_DEBUG_MODE = 'Y' THEN
2025: PA_DEBUG.Reset_Curr_Function;
2026:
2027: END IF;
2028:
2029:

Line 2040: IF P_PA_DEBUG_MODE = 'Y' THEN

2036: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN
2037: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2038: p_msg_name => 'PA_FP_INV_ETC_BV');
2039: END IF;
2040: IF P_PA_DEBUG_MODE = 'Y' THEN
2041: pa_fp_gen_amount_utils.fp_debug
2042: (p_msg => 'Invalid source',
2043: p_module_name => l_module_name,
2044: p_log_level => 5);

Line 2045: PA_DEBUG.Reset_Curr_Function;

2041: pa_fp_gen_amount_utils.fp_debug
2042: (p_msg => 'Invalid source',
2043: p_module_name => l_module_name,
2044: p_log_level => 5);
2045: PA_DEBUG.Reset_Curr_Function;
2046: END IF;
2047: RAISE;
2048:
2049: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 2067: IF P_PA_DEBUG_MODE = 'Y' THEN

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

Line 2072: PA_DEBUG.Reset_Curr_Function;

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

Line 2082: IF P_PA_DEBUG_MODE = 'Y' THEN

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

Line 2087: PA_DEBUG.Reset_Curr_Function;

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