eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_SHORTCUTS_PKG dependencies on PA_DEBUG

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

1: PACKAGE BODY pa_fp_shortcuts_pkg AS
2: /* $Header: PAFPSHPB.pls 120.3 2006/06/12 06:25:26 nkumbi noship $ */
3: p_pa_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4: l_module VARCHAR2(50) := 'pa_fp_shortcuts_pkg';
5: /* Calling Module : Project Home shortcut Financial dummy page
6: Budgeting and Forecasting page
7: When called from dummy page, this pakcage identify the

Line 54: IF P_PA_DEBUG_MODE = 'Y' THEN

50: BEGIN
51: FND_MSG_PUB.initialize;
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: IF P_PA_DEBUG_MODE = 'Y' THEN
55: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.identify_plan_version_id');
56: pa_debug.write( x_module => l_module,
57: x_msg => 'proj id :'||p_project_id||' fn code :'||p_function_code,
58: x_log_level => 3);

Line 55: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.identify_plan_version_id');

51: FND_MSG_PUB.initialize;
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: IF P_PA_DEBUG_MODE = 'Y' THEN
55: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.identify_plan_version_id');
56: pa_debug.write( x_module => l_module,
57: x_msg => 'proj id :'||p_project_id||' fn code :'||p_function_code,
58: x_log_level => 3);
59: pa_debug.write( x_module => l_module,

Line 56: pa_debug.write( x_module => l_module,

52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: IF P_PA_DEBUG_MODE = 'Y' THEN
55: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.identify_plan_version_id');
56: pa_debug.write( x_module => l_module,
57: x_msg => 'proj id :'||p_project_id||' fn code :'||p_function_code,
58: x_log_level => 3);
59: pa_debug.write( x_module => l_module,
60: x_msg => 'context :'||p_context||' uid :'||p_user_id,

Line 59: pa_debug.write( x_module => l_module,

55: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.identify_plan_version_id');
56: pa_debug.write( x_module => l_module,
57: x_msg => 'proj id :'||p_project_id||' fn code :'||p_function_code,
58: x_log_level => 3);
59: pa_debug.write( x_module => l_module,
60: x_msg => 'context :'||p_context||' uid :'||p_user_id,
61: x_log_level => 3);
62: pa_debug.write( x_module => l_module,
63: x_msg => 'ptype id :'||px_fin_plan_type_id,

Line 62: pa_debug.write( x_module => l_module,

58: x_log_level => 3);
59: pa_debug.write( x_module => l_module,
60: x_msg => 'context :'||p_context||' uid :'||p_user_id,
61: x_log_level => 3);
62: pa_debug.write( x_module => l_module,
63: x_msg => 'ptype id :'||px_fin_plan_type_id,
64: x_log_level => 3);
65: END IF;
66: l_same_org_id := p_same_org_id_flag;

Line 82: IF P_PA_DEBUG_MODE = 'Y' THEN

78: --If the financial structure is not enabled for the project then the budget creation/updation
79: --should not be possible
80: IF pa_project_structure_utils.get_fin_struc_ver_id( p_project_id => p_project_id) IS NULL THEN
81:
82: IF P_PA_DEBUG_MODE = 'Y' THEN
83: pa_debug.write( x_module => l_module,
84: x_msg => 'Financial structure is not enabled for the project '||p_project_id,
85: x_log_level => 5);
86: END IF;

Line 83: pa_debug.write( x_module => l_module,

79: --should not be possible
80: IF pa_project_structure_utils.get_fin_struc_ver_id( p_project_id => p_project_id) IS NULL THEN
81:
82: IF P_PA_DEBUG_MODE = 'Y' THEN
83: pa_debug.write( x_module => l_module,
84: x_msg => 'Financial structure is not enabled for the project '||p_project_id,
85: x_log_level => 5);
86: END IF;
87:

Line 95: IF p_pa_debug_mode = 'Y' THEN

91:
92: IF p_context IS NOT NULL THEN
93: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
94: END IF;
95: IF p_pa_debug_mode = 'Y' THEN
96: PA_DEBUG.Reset_Err_stack;
97: END IF;
98: RETURN;
99:

Line 96: PA_DEBUG.Reset_Err_stack;

92: IF p_context IS NOT NULL THEN
93: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
94: END IF;
95: IF p_pa_debug_mode = 'Y' THEN
96: PA_DEBUG.Reset_Err_stack;
97: END IF;
98: RETURN;
99:
100: END IF;

Line 134: IF p_pa_debug_mode = 'Y' THEN

130: x_msg_count := 1;
131: ELSE
132: x_msg_count := fnd_msg_pub.count_msg;
133: END IF;
134: IF p_pa_debug_mode = 'Y' THEN
135: PA_DEBUG.Reset_Err_stack;
136: END IF;
137: RETURN;
138: END;

Line 135: PA_DEBUG.Reset_Err_stack;

131: ELSE
132: x_msg_count := fnd_msg_pub.count_msg;
133: END IF;
134: IF p_pa_debug_mode = 'Y' THEN
135: PA_DEBUG.Reset_Err_stack;
136: END IF;
137: RETURN;
138: END;
139:

Line 169: IF p_pa_debug_mode = 'Y' THEN

165:
166: IF p_context IS NOT NULL THEN
167: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
168: END IF;
169: IF p_pa_debug_mode = 'Y' THEN
170: PA_DEBUG.Reset_Err_stack;
171: END IF;
172: RETURN;
173:

Line 170: PA_DEBUG.Reset_Err_stack;

166: IF p_context IS NOT NULL THEN
167: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
168: END IF;
169: IF p_pa_debug_mode = 'Y' THEN
170: PA_DEBUG.Reset_Err_stack;
171: END IF;
172: RETURN;
173:
174: END IF;

Line 218: IF P_PA_DEBUG_MODE = 'Y' THEN

214: IF px_fin_plan_type_id IS NULL THEN
215: IF l_version_type = 'BOTH' THEN
216:
217: IF l_plan_class_code = 'BUDGET' THEN
218: IF P_PA_DEBUG_MODE = 'Y' THEN
219: pa_debug.write( x_module => l_module,
220: x_msg => 'calling get_app_budget_pt_id api',
221: x_log_level => 3);
222: END IF;

Line 219: pa_debug.write( x_module => l_module,

215: IF l_version_type = 'BOTH' THEN
216:
217: IF l_plan_class_code = 'BUDGET' THEN
218: IF P_PA_DEBUG_MODE = 'Y' THEN
219: pa_debug.write( x_module => l_module,
220: x_msg => 'calling get_app_budget_pt_id api',
221: x_log_level => 3);
222: END IF;
223:

Line 235: IF p_pa_debug_mode = 'Y' THEN

231: x_return_status => x_return_status,
232: x_msg_count => x_msg_count,
233: x_msg_data => x_msg_data );
234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
235: IF p_pa_debug_mode = 'Y' THEN
236: PA_DEBUG.Reset_Err_stack;
237: END IF;
238: RETURN;
239: END IF;

Line 236: PA_DEBUG.Reset_Err_stack;

232: x_msg_count => x_msg_count,
233: x_msg_data => x_msg_data );
234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
235: IF p_pa_debug_mode = 'Y' THEN
236: PA_DEBUG.Reset_Err_stack;
237: END IF;
238: RETURN;
239: END IF;
240:

Line 252: IF p_pa_debug_mode = 'Y' THEN

248: x_return_status => x_return_status,
249: x_msg_count => x_msg_count,
250: x_msg_data => x_msg_data );
251: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
252: IF p_pa_debug_mode = 'Y' THEN
253: PA_DEBUG.Reset_Err_stack;
254: END IF;
255: RETURN;
256: END IF;

Line 253: PA_DEBUG.Reset_Err_stack;

249: x_msg_count => x_msg_count,
250: x_msg_data => x_msg_data );
251: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
252: IF p_pa_debug_mode = 'Y' THEN
253: PA_DEBUG.Reset_Err_stack;
254: END IF;
255: RETURN;
256: END IF;
257:

Line 267: IF p_pa_debug_mode = 'Y' THEN

263:
264: IF p_context IS NOT NULL THEN
265: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
266: END IF;
267: IF p_pa_debug_mode = 'Y' THEN
268: PA_DEBUG.Reset_Err_stack;
269: END IF;
270: RETURN;
271: END IF;

Line 268: PA_DEBUG.Reset_Err_stack;

264: IF p_context IS NOT NULL THEN
265: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
266: END IF;
267: IF p_pa_debug_mode = 'Y' THEN
268: PA_DEBUG.Reset_Err_stack;
269: END IF;
270: RETURN;
271: END IF;
272:

Line 274: IF P_PA_DEBUG_MODE = 'Y' THEN

270: RETURN;
271: END IF;
272:
273: ELSIF l_plan_class_code = 'FORECAST' THEN
274: IF P_PA_DEBUG_MODE = 'Y' THEN
275: pa_debug.write( x_module => l_module,
276: x_msg => 'calling get_fcst_plan_type_id api',
277: x_log_level => 3);
278: END IF;

Line 275: pa_debug.write( x_module => l_module,

271: END IF;
272:
273: ELSIF l_plan_class_code = 'FORECAST' THEN
274: IF P_PA_DEBUG_MODE = 'Y' THEN
275: pa_debug.write( x_module => l_module,
276: x_msg => 'calling get_fcst_plan_type_id api',
277: x_log_level => 3);
278: END IF;
279: pa_fp_shortcuts_pkg.get_fcst_plan_type_id(

Line 290: IF p_pa_debug_mode = 'Y' THEN

286: x_return_status => x_return_status,
287: x_msg_count => x_msg_count,
288: x_msg_data => x_msg_data );
289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
290: IF p_pa_debug_mode = 'Y' THEN
291: PA_DEBUG.Reset_Err_stack;
292: END IF;
293: RETURN;
294: END IF;

Line 291: PA_DEBUG.Reset_Err_stack;

287: x_msg_count => x_msg_count,
288: x_msg_data => x_msg_data );
289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
290: IF p_pa_debug_mode = 'Y' THEN
291: PA_DEBUG.Reset_Err_stack;
292: END IF;
293: RETURN;
294: END IF;
295:

Line 307: IF p_pa_debug_mode = 'Y' THEN

303: x_return_status => x_return_status,
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data );
306: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
307: IF p_pa_debug_mode = 'Y' THEN
308: PA_DEBUG.Reset_Err_stack;
309: END IF;
310: RETURN;
311: END IF;

Line 308: PA_DEBUG.Reset_Err_stack;

304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data );
306: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
307: IF p_pa_debug_mode = 'Y' THEN
308: PA_DEBUG.Reset_Err_stack;
309: END IF;
310: RETURN;
311: END IF;
312:

Line 322: IF p_pa_debug_mode = 'Y' THEN

318:
319: IF p_context IS NOT NULL THEN
320: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
321: END IF;
322: IF p_pa_debug_mode = 'Y' THEN
323: PA_DEBUG.Reset_Err_stack;
324: END IF;
325: RETURN;
326: END IF;

Line 323: PA_DEBUG.Reset_Err_stack;

319: IF p_context IS NOT NULL THEN
320: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
321: END IF;
322: IF p_pa_debug_mode = 'Y' THEN
323: PA_DEBUG.Reset_Err_stack;
324: END IF;
325: RETURN;
326: END IF;
327:

Line 333: IF P_PA_DEBUG_MODE = 'Y' THEN

329:
330: ELSE -- l_version_type
331:
332: IF l_plan_class_code = 'BUDGET' THEN
333: IF P_PA_DEBUG_MODE = 'Y' THEN
334: pa_debug.write( x_module => l_module,
335: x_msg => 'calling get_app_budget_pt_id api',
336: x_log_level => 3);
337: END IF;

Line 334: pa_debug.write( x_module => l_module,

330: ELSE -- l_version_type
331:
332: IF l_plan_class_code = 'BUDGET' THEN
333: IF P_PA_DEBUG_MODE = 'Y' THEN
334: pa_debug.write( x_module => l_module,
335: x_msg => 'calling get_app_budget_pt_id api',
336: x_log_level => 3);
337: END IF;
338:

Line 352: IF p_pa_debug_mode = 'Y' THEN

348: x_msg_data => x_msg_data );
349: px_fin_plan_type_id := l_fin_plan_type_id;
350: IF x_redirect_url IS NOT NULL OR
351: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
352: IF p_pa_debug_mode = 'Y' THEN
353: PA_DEBUG.Reset_Err_stack;
354: END IF;
355: RETURN;
356: END IF;

Line 353: PA_DEBUG.Reset_Err_stack;

349: px_fin_plan_type_id := l_fin_plan_type_id;
350: IF x_redirect_url IS NOT NULL OR
351: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
352: IF p_pa_debug_mode = 'Y' THEN
353: PA_DEBUG.Reset_Err_stack;
354: END IF;
355: RETURN;
356: END IF;
357: ELSIF l_plan_class_code = 'FORECAST' THEN

Line 358: IF P_PA_DEBUG_MODE = 'Y' THEN

354: END IF;
355: RETURN;
356: END IF;
357: ELSIF l_plan_class_code = 'FORECAST' THEN
358: IF P_PA_DEBUG_MODE = 'Y' THEN
359: pa_debug.write( x_module => l_module,
360: x_msg => 'calling get_fcst_plan_type_id api',
361: x_log_level => 3);
362: END IF;

Line 359: pa_debug.write( x_module => l_module,

355: RETURN;
356: END IF;
357: ELSIF l_plan_class_code = 'FORECAST' THEN
358: IF P_PA_DEBUG_MODE = 'Y' THEN
359: pa_debug.write( x_module => l_module,
360: x_msg => 'calling get_fcst_plan_type_id api',
361: x_log_level => 3);
362: END IF;
363: pa_fp_shortcuts_pkg.get_fcst_plan_type_id(

Line 376: IF p_pa_debug_mode = 'Y' THEN

372: x_msg_data => x_msg_data );
373: px_fin_plan_type_id := l_fin_plan_type_id;
374: IF x_redirect_url IS NOT NULL OR
375: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
376: IF p_pa_debug_mode = 'Y' THEN
377: PA_DEBUG.Reset_Err_stack;
378: END IF;
379: RETURN;
380: END IF;

Line 377: PA_DEBUG.Reset_Err_stack;

373: px_fin_plan_type_id := l_fin_plan_type_id;
374: IF x_redirect_url IS NOT NULL OR
375: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
376: IF p_pa_debug_mode = 'Y' THEN
377: PA_DEBUG.Reset_Err_stack;
378: END IF;
379: RETURN;
380: END IF;
381: END IF;

Line 384: IF P_PA_DEBUG_MODE = 'Y' THEN

380: END IF;
381: END IF;
382: END IF; -- l_version_type
383: ELSE
384: IF P_PA_DEBUG_MODE = 'Y' THEN
385: pa_debug.write( x_module => l_module,
386: x_msg => 'plan type id passed, validating plan type pref code',
387: x_log_level => 3);
388: END IF;

Line 385: pa_debug.write( x_module => l_module,

381: END IF;
382: END IF; -- l_version_type
383: ELSE
384: IF P_PA_DEBUG_MODE = 'Y' THEN
385: pa_debug.write( x_module => l_module,
386: x_msg => 'plan type id passed, validating plan type pref code',
387: x_log_level => 3);
388: END IF;
389:

Line 406: IF p_pa_debug_mode = 'Y' THEN

402:
403: IF p_context IS NOT NULL THEN
404: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
405: END IF;
406: IF p_pa_debug_mode = 'Y' THEN
407: PA_DEBUG.Reset_Err_stack;
408: END IF;
409: RETURN;
410: ELSIF l_version_type = 'REVENUE' AND

Line 407: PA_DEBUG.Reset_Err_stack;

403: IF p_context IS NOT NULL THEN
404: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
405: END IF;
406: IF p_pa_debug_mode = 'Y' THEN
407: PA_DEBUG.Reset_Err_stack;
408: END IF;
409: RETURN;
410: ELSIF l_version_type = 'REVENUE' AND
411: l_fin_plan_preference_code = 'COST_ONLY' THEN

Line 420: IF p_pa_debug_mode = 'Y' THEN

416:
417: IF p_context IS NOT NULL THEN
418: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
419: END IF;
420: IF p_pa_debug_mode = 'Y' THEN
421: PA_DEBUG.Reset_Err_stack;
422: END IF;
423: RETURN;
424: END IF;

Line 421: PA_DEBUG.Reset_Err_stack;

417: IF p_context IS NOT NULL THEN
418: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
419: END IF;
420: IF p_pa_debug_mode = 'Y' THEN
421: PA_DEBUG.Reset_Err_stack;
422: END IF;
423: RETURN;
424: END IF;
425: END IF;

Line 427: IF P_PA_DEBUG_MODE = 'Y' THEN

423: RETURN;
424: END IF;
425: END IF;
426:
427: IF P_PA_DEBUG_MODE = 'Y' THEN
428: pa_debug.write( x_module => l_module,
429: x_msg => 'getting current working version',
430: x_log_level => 3);
431: END IF;

Line 428: pa_debug.write( x_module => l_module,

424: END IF;
425: END IF;
426:
427: IF P_PA_DEBUG_MODE = 'Y' THEN
428: pa_debug.write( x_module => l_module,
429: x_msg => 'getting current working version',
430: x_log_level => 3);
431: END IF;
432:

Line 438: IF P_PA_DEBUG_MODE = 'Y' THEN

434: IF l_cost_fin_plan_type_id is NOT NULL THEN
435: /* Bug 3658139: Getting the preference_code to check for the
436: * case of approved budget with COST_AND_REV_SAME.
437: */
438: IF P_PA_DEBUG_MODE = 'Y' THEN
439: pa_debug.write( x_module => l_module,
440: x_msg => 'getting the preference code',
441: x_log_level => 3);
442: END IF;

Line 439: pa_debug.write( x_module => l_module,

435: /* Bug 3658139: Getting the preference_code to check for the
436: * case of approved budget with COST_AND_REV_SAME.
437: */
438: IF P_PA_DEBUG_MODE = 'Y' THEN
439: pa_debug.write( x_module => l_module,
440: x_msg => 'getting the preference code',
441: x_log_level => 3);
442: END IF;
443: BEGIN

Line 468: IF p_pa_debug_mode = 'Y' THEN

464:
465: l_bdgt_version_id := x_budget_version_id; /*Added for bug 4089561. If its a 'COST_AND_REV_SAME' case then
466: paRevContextVersionId should also be set equal to x_budget_version_id derived above.*/
467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
468: IF p_pa_debug_mode = 'Y' THEN
469: PA_DEBUG.Reset_Err_stack;
470: END IF;
471: RETURN;
472: END IF;

Line 469: PA_DEBUG.Reset_Err_stack;

465: l_bdgt_version_id := x_budget_version_id; /*Added for bug 4089561. If its a 'COST_AND_REV_SAME' case then
466: paRevContextVersionId should also be set equal to x_budget_version_id derived above.*/
467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
468: IF p_pa_debug_mode = 'Y' THEN
469: PA_DEBUG.Reset_Err_stack;
470: END IF;
471: RETURN;
472: END IF;
473: ELSE

Line 487: IF p_pa_debug_mode = 'Y' THEN

483:
484: l_bdgt_version_id := -99; /*Added for bug 4089561. If its not 'COST_AND_REV_SAME' case then
485: paRevContextVersionId should be set equal to -99*/
486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
487: IF p_pa_debug_mode = 'Y' THEN
488: PA_DEBUG.Reset_Err_stack;
489: END IF;
490: RETURN;
491: END IF;

Line 488: PA_DEBUG.Reset_Err_stack;

484: l_bdgt_version_id := -99; /*Added for bug 4089561. If its not 'COST_AND_REV_SAME' case then
485: paRevContextVersionId should be set equal to -99*/
486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
487: IF p_pa_debug_mode = 'Y' THEN
488: PA_DEBUG.Reset_Err_stack;
489: END IF;
490: RETURN;
491: END IF;
492: END IF;

Line 502: IF p_pa_debug_mode = 'Y' THEN

498: ||'&paFinTypeId=' || l_cost_fin_plan_type_id
499: ||'&paCstContextVersionId=' || x_budget_version_id
500: ||'&paRevContextVersionId=' || l_bdgt_version_id; --changed for bug 4089561
501:
502: IF p_pa_debug_mode = 'Y' THEN
503: PA_DEBUG.Reset_Err_stack;
504: END IF;
505: RETURN;
506: ELSIF l_plan_class_code = 'FORECAST' THEN --'PJI_VIEW_FCST_TASK_SUMMARY' THEN -- Changed hkulkarn

Line 503: PA_DEBUG.Reset_Err_stack;

499: ||'&paCstContextVersionId=' || x_budget_version_id
500: ||'&paRevContextVersionId=' || l_bdgt_version_id; --changed for bug 4089561
501:
502: IF p_pa_debug_mode = 'Y' THEN
503: PA_DEBUG.Reset_Err_stack;
504: END IF;
505: RETURN;
506: ELSIF l_plan_class_code = 'FORECAST' THEN --'PJI_VIEW_FCST_TASK_SUMMARY' THEN -- Changed hkulkarn
507: x_redirect_url := 'OA.jsp?page=/oracle/apps/pji/viewplan/reporting/webui/ForecastTaskSummaryPG'

Line 513: IF p_pa_debug_mode = 'Y' THEN

509: ||'&paFinTypeId=' || l_cost_fin_plan_type_id
510: ||'&paCstContextVersionId=' || x_budget_version_id
511: ||'&paRevContextVersionId=' || l_bdgt_version_id; --changed for bug 4089561
512:
513: IF p_pa_debug_mode = 'Y' THEN
514: PA_DEBUG.Reset_Err_stack;
515: END IF;
516: RETURN;
517: END IF;

Line 514: PA_DEBUG.Reset_Err_stack;

510: ||'&paCstContextVersionId=' || x_budget_version_id
511: ||'&paRevContextVersionId=' || l_bdgt_version_id; --changed for bug 4089561
512:
513: IF p_pa_debug_mode = 'Y' THEN
514: PA_DEBUG.Reset_Err_stack;
515: END IF;
516: RETURN;
517: END IF;
518: END IF; -- x_budget_version_id

Line 536: IF p_pa_debug_mode = 'Y' THEN

532: x_msg_count => x_msg_count,
533: x_msg_data => x_msg_data );
534:
535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
536: IF p_pa_debug_mode = 'Y' THEN
537: PA_DEBUG.Reset_Err_stack;
538: END IF;
539: RETURN;
540: END IF;

Line 537: PA_DEBUG.Reset_Err_stack;

533: x_msg_data => x_msg_data );
534:
535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
536: IF p_pa_debug_mode = 'Y' THEN
537: PA_DEBUG.Reset_Err_stack;
538: END IF;
539: RETURN;
540: END IF;
541:

Line 551: IF p_pa_debug_mode = 'Y' THEN

547: ||'&paFinTypeId=' || l_rev_fin_plan_type_id
548: ||'&paCstContextVersionId=-99'
549: ||'&paRevContextVersionId=' || x_budget_version_id;
550:
551: IF p_pa_debug_mode = 'Y' THEN
552: PA_DEBUG.Reset_Err_stack;
553: END IF;
554: RETURN;
555: ELSIF l_plan_class_code = 'FORECAST' THEN --'PJI_VIEW_FCST_TASK_SUMMARY' THEN -- Changed hkulkarn

Line 552: PA_DEBUG.Reset_Err_stack;

548: ||'&paCstContextVersionId=-99'
549: ||'&paRevContextVersionId=' || x_budget_version_id;
550:
551: IF p_pa_debug_mode = 'Y' THEN
552: PA_DEBUG.Reset_Err_stack;
553: END IF;
554: RETURN;
555: ELSIF l_plan_class_code = 'FORECAST' THEN --'PJI_VIEW_FCST_TASK_SUMMARY' THEN -- Changed hkulkarn
556: x_redirect_url := 'OA.jsp?page=/oracle/apps/pji/viewplan/reporting/webui/ForecastTaskSummaryPG'

Line 562: IF p_pa_debug_mode = 'Y' THEN

558: ||'&paFinTypeId=' || l_rev_fin_plan_type_id
559: ||'&paCstContextVersionId=-99'
560: ||'&paRevContextVersionId=' || x_budget_version_id;
561:
562: IF p_pa_debug_mode = 'Y' THEN
563: PA_DEBUG.Reset_Err_stack;
564: END IF;
565: RETURN;
566: END IF;

Line 563: PA_DEBUG.Reset_Err_stack;

559: ||'&paCstContextVersionId=-99'
560: ||'&paRevContextVersionId=' || x_budget_version_id;
561:
562: IF p_pa_debug_mode = 'Y' THEN
563: PA_DEBUG.Reset_Err_stack;
564: END IF;
565: RETURN;
566: END IF;
567: END IF; -- x_budget_version_id

Line 579: IF p_pa_debug_mode = 'Y' THEN

575:
576: IF p_context IS NOT NULL THEN
577: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
578: END IF;
579: IF p_pa_debug_mode = 'Y' THEN
580: PA_DEBUG.Reset_Err_stack;
581: END IF;
582: RETURN;
583:

Line 580: PA_DEBUG.Reset_Err_stack;

576: IF p_context IS NOT NULL THEN
577: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
578: END IF;
579: IF p_pa_debug_mode = 'Y' THEN
580: PA_DEBUG.Reset_Err_stack;
581: END IF;
582: RETURN;
583:
584: END IF; -- x_budget_version_id

Line 607: IF p_pa_debug_mode = 'Y' THEN

603: x_msg_data => x_msg_data );
604:
605:
606: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
607: IF p_pa_debug_mode = 'Y' THEN
608: PA_DEBUG.Reset_Err_stack;
609: END IF;
610: RETURN;
611: END IF;

Line 608: PA_DEBUG.Reset_Err_stack;

604:
605:
606: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
607: IF p_pa_debug_mode = 'Y' THEN
608: PA_DEBUG.Reset_Err_stack;
609: END IF;
610: RETURN;
611: END IF;
612: -- S.N. hkulkarn

Line 613: IF p_pa_debug_mode = 'Y' THEN

609: END IF;
610: RETURN;
611: END IF;
612: -- S.N. hkulkarn
613: IF p_pa_debug_mode = 'Y' THEN
614: PA_DEBUG.Reset_Err_stack;
615: END IF;
616: -- E.N. hkulkarn
617:

Line 614: PA_DEBUG.Reset_Err_stack;

610: RETURN;
611: END IF;
612: -- S.N. hkulkarn
613: IF p_pa_debug_mode = 'Y' THEN
614: PA_DEBUG.Reset_Err_stack;
615: END IF;
616: -- E.N. hkulkarn
617:
618: END IF; -- l_version_type

Line 622: IF p_pa_debug_mode = 'Y' THEN

618: END IF; -- l_version_type
619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: IF p_pa_debug_mode = 'Y' THEN
623: PA_DEBUG.Reset_Err_stack;
624: END IF;
625:
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 623: PA_DEBUG.Reset_Err_stack;

619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: IF p_pa_debug_mode = 'Y' THEN
623: PA_DEBUG.Reset_Err_stack;
624: END IF;
625:
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_SHORTCUTS_PKG',

Line 692: IF P_PA_DEBUG_MODE = 'Y' THEN

688: approved_revenue_rec approved_revenue_csr%ROWTYPE;
689:
690: BEGIN
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: IF P_PA_DEBUG_MODE = 'Y' THEN
693: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_app_budget_pt_id');
694: pa_debug.write( x_module => l_module,
695: x_msg => 'checking for approved budget',
696: x_log_level => 3);

Line 693: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_app_budget_pt_id');

689:
690: BEGIN
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: IF P_PA_DEBUG_MODE = 'Y' THEN
693: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_app_budget_pt_id');
694: pa_debug.write( x_module => l_module,
695: x_msg => 'checking for approved budget',
696: x_log_level => 3);
697: END IF;

Line 694: pa_debug.write( x_module => l_module,

690: BEGIN
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: IF P_PA_DEBUG_MODE = 'Y' THEN
693: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_app_budget_pt_id');
694: pa_debug.write( x_module => l_module,
695: x_msg => 'checking for approved budget',
696: x_log_level => 3);
697: END IF;
698: OPEN approved_budget_csr;

Line 703: IF p_pa_debug_mode = 'Y' THEN

699: FETCH approved_budget_csr INTO approved_budget_rec;
700: IF approved_budget_csr%NOTFOUND THEN
701: IF p_function_code = 'PJI_VIEW_BDGT_TASK_SUMMARY' THEN
702: NULL;
703: IF p_pa_debug_mode = 'Y' THEN
704: PA_DEBUG.Reset_Err_stack;
705: END IF;
706: RETURN;
707: ELSE

Line 704: PA_DEBUG.Reset_Err_stack;

700: IF approved_budget_csr%NOTFOUND THEN
701: IF p_function_code = 'PJI_VIEW_BDGT_TASK_SUMMARY' THEN
702: NULL;
703: IF p_pa_debug_mode = 'Y' THEN
704: PA_DEBUG.Reset_Err_stack;
705: END IF;
706: RETURN;
707: ELSE
708: /* setting url for Budgets and Forecasts page */

Line 717: IF p_pa_debug_mode = 'Y' THEN

713: IF p_context IS NOT NULL THEN
714: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
715: END IF;
716: CLOSE approved_budget_csr;
717: IF p_pa_debug_mode = 'Y' THEN
718: PA_DEBUG.Reset_Err_stack;
719: END IF;
720: RETURN;
721: END IF;

Line 718: PA_DEBUG.Reset_Err_stack;

714: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
715: END IF;
716: CLOSE approved_budget_csr;
717: IF p_pa_debug_mode = 'Y' THEN
718: PA_DEBUG.Reset_Err_stack;
719: END IF;
720: RETURN;
721: END IF;
722: END IF;

Line 728: IF P_PA_DEBUG_MODE = 'Y' THEN

724:
725: IF p_version_type = 'COST' THEN
726: -- COST BUDGET
727: -- Validate: Approved Budget Plan type allows for cost numbers
728: IF P_PA_DEBUG_MODE = 'Y' THEN
729: pa_debug.write( x_module => l_module,
730: x_msg => 'checking for cost approved budget',
731: x_log_level => 3);
732: END IF;

Line 729: pa_debug.write( x_module => l_module,

725: IF p_version_type = 'COST' THEN
726: -- COST BUDGET
727: -- Validate: Approved Budget Plan type allows for cost numbers
728: IF P_PA_DEBUG_MODE = 'Y' THEN
729: pa_debug.write( x_module => l_module,
730: x_msg => 'checking for cost approved budget',
731: x_log_level => 3);
732: END IF;
733: OPEN approved_cost_csr;

Line 744: IF p_pa_debug_mode = 'Y' THEN

740:
741: IF p_context IS NOT NULL THEN
742: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
743: END IF;
744: IF p_pa_debug_mode = 'Y' THEN
745: PA_DEBUG.Reset_Err_stack;
746: END IF;
747: RETURN;
748: ELSE

Line 745: PA_DEBUG.Reset_Err_stack;

741: IF p_context IS NOT NULL THEN
742: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
743: END IF;
744: IF p_pa_debug_mode = 'Y' THEN
745: PA_DEBUG.Reset_Err_stack;
746: END IF;
747: RETURN;
748: ELSE
749: x_fin_plan_type_id := approved_cost_rec.fin_plan_type_id;

Line 753: IF P_PA_DEBUG_MODE = 'Y' THEN

749: x_fin_plan_type_id := approved_cost_rec.fin_plan_type_id;
750: END IF;
751: CLOSE approved_cost_csr;
752: ELSIF p_version_type = 'REVENUE' THEN
753: IF P_PA_DEBUG_MODE = 'Y' THEN
754: pa_debug.write( x_module => l_module,
755: x_msg => 'checking for revenue approved budget',
756: x_log_level => 3);
757: END IF;

Line 754: pa_debug.write( x_module => l_module,

750: END IF;
751: CLOSE approved_cost_csr;
752: ELSIF p_version_type = 'REVENUE' THEN
753: IF P_PA_DEBUG_MODE = 'Y' THEN
754: pa_debug.write( x_module => l_module,
755: x_msg => 'checking for revenue approved budget',
756: x_log_level => 3);
757: END IF;
758: OPEN approved_revenue_csr;

Line 770: IF p_pa_debug_mode = 'Y' THEN

766: IF p_context IS NOT NULL THEN
767: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
768: END IF;
769: CLOSE approved_revenue_csr;
770: IF p_pa_debug_mode = 'Y' THEN
771: PA_DEBUG.Reset_Err_stack;
772: END IF;
773: RETURN;
774: ELSE

Line 771: PA_DEBUG.Reset_Err_stack;

767: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
768: END IF;
769: CLOSE approved_revenue_csr;
770: IF p_pa_debug_mode = 'Y' THEN
771: PA_DEBUG.Reset_Err_stack;
772: END IF;
773: RETURN;
774: ELSE
775: x_fin_plan_type_id := approved_revenue_rec.fin_plan_type_id;

Line 782: IF p_pa_debug_mode = 'Y' THEN

778: END IF;
779:
780: EXCEPTION
781: WHEN OTHERS THEN
782: IF p_pa_debug_mode = 'Y' THEN
783: PA_DEBUG.Reset_Err_stack;
784: END IF;
785:
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 783: PA_DEBUG.Reset_Err_stack;

779:
780: EXCEPTION
781: WHEN OTHERS THEN
782: IF p_pa_debug_mode = 'Y' THEN
783: PA_DEBUG.Reset_Err_stack;
784: END IF;
785:
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_SHORTCUTS_PKG',

Line 851: IF P_PA_DEBUG_MODE = 'Y' THEN

847: primary_revenue_rec primary_revenue_csr%ROWTYPE;
848:
849: BEGIN
850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851: IF P_PA_DEBUG_MODE = 'Y' THEN
852: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_fcst_plan_type_id');
853: pa_debug.write( x_module => l_module,
854: x_msg => 'checking for primary forecast plan type',
855: x_log_level => 3);

Line 852: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_fcst_plan_type_id');

848:
849: BEGIN
850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851: IF P_PA_DEBUG_MODE = 'Y' THEN
852: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_fcst_plan_type_id');
853: pa_debug.write( x_module => l_module,
854: x_msg => 'checking for primary forecast plan type',
855: x_log_level => 3);
856: END IF;

Line 853: pa_debug.write( x_module => l_module,

849: BEGIN
850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851: IF P_PA_DEBUG_MODE = 'Y' THEN
852: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_fcst_plan_type_id');
853: pa_debug.write( x_module => l_module,
854: x_msg => 'checking for primary forecast plan type',
855: x_log_level => 3);
856: END IF;
857: OPEN primary_budget_csr;

Line 862: IF p_pa_debug_mode = 'Y' THEN

858: FETCH primary_budget_csr INTO primary_budget_rec;
859: IF primary_budget_csr%NOTFOUND THEN
860: IF p_function_code = 'PJI_VIEW_FCST_TASK_SUMMARY' THEN
861: NULL;
862: IF p_pa_debug_mode = 'Y' THEN
863: PA_DEBUG.Reset_Err_stack;
864: END IF;
865: RETURN;
866: ELSE

Line 863: PA_DEBUG.Reset_Err_stack;

859: IF primary_budget_csr%NOTFOUND THEN
860: IF p_function_code = 'PJI_VIEW_FCST_TASK_SUMMARY' THEN
861: NULL;
862: IF p_pa_debug_mode = 'Y' THEN
863: PA_DEBUG.Reset_Err_stack;
864: END IF;
865: RETURN;
866: ELSE
867: /* setting url for Budgets and Forecasts page */

Line 876: IF p_pa_debug_mode = 'Y' THEN

872: IF p_context IS NOT NULL THEN
873: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
874: END IF;
875: CLOSE primary_budget_csr;
876: IF p_pa_debug_mode = 'Y' THEN
877: PA_DEBUG.Reset_Err_stack;
878: END IF;
879: RETURN;
880: END IF;

Line 877: PA_DEBUG.Reset_Err_stack;

873: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
874: END IF;
875: CLOSE primary_budget_csr;
876: IF p_pa_debug_mode = 'Y' THEN
877: PA_DEBUG.Reset_Err_stack;
878: END IF;
879: RETURN;
880: END IF;
881: END IF;

Line 886: IF P_PA_DEBUG_MODE = 'Y' THEN

882: CLOSE primary_budget_csr;
883: IF p_version_type = 'COST' THEN
884: -- COST BUDGET
885: -- Validate: primary Budget Plan type allows for cost numbers
886: IF P_PA_DEBUG_MODE = 'Y' THEN
887: pa_debug.write( x_module => l_module,
888: x_msg => 'checking for primary cost forecast',
889: x_log_level => 3);
890: END IF;

Line 887: pa_debug.write( x_module => l_module,

883: IF p_version_type = 'COST' THEN
884: -- COST BUDGET
885: -- Validate: primary Budget Plan type allows for cost numbers
886: IF P_PA_DEBUG_MODE = 'Y' THEN
887: pa_debug.write( x_module => l_module,
888: x_msg => 'checking for primary cost forecast',
889: x_log_level => 3);
890: END IF;
891: OPEN primary_cost_csr;

Line 902: IF p_pa_debug_mode = 'Y' THEN

898:
899: IF p_context IS NOT NULL THEN
900: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
901: END IF;
902: IF p_pa_debug_mode = 'Y' THEN
903: PA_DEBUG.Reset_Err_stack;
904: END IF;
905: RETURN;
906: ELSE

Line 903: PA_DEBUG.Reset_Err_stack;

899: IF p_context IS NOT NULL THEN
900: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
901: END IF;
902: IF p_pa_debug_mode = 'Y' THEN
903: PA_DEBUG.Reset_Err_stack;
904: END IF;
905: RETURN;
906: ELSE
907: x_fin_plan_type_id := primary_cost_rec.fin_plan_type_id;

Line 911: IF P_PA_DEBUG_MODE = 'Y' THEN

907: x_fin_plan_type_id := primary_cost_rec.fin_plan_type_id;
908: END IF;
909: CLOSE primary_cost_csr;
910: ELSIF p_version_type = 'REVENUE' THEN
911: IF P_PA_DEBUG_MODE = 'Y' THEN
912: pa_debug.write( x_module => l_module,
913: x_msg => 'checking for primary revenue forecast',
914: x_log_level => 3);
915: END IF;

Line 912: pa_debug.write( x_module => l_module,

908: END IF;
909: CLOSE primary_cost_csr;
910: ELSIF p_version_type = 'REVENUE' THEN
911: IF P_PA_DEBUG_MODE = 'Y' THEN
912: pa_debug.write( x_module => l_module,
913: x_msg => 'checking for primary revenue forecast',
914: x_log_level => 3);
915: END IF;
916: OPEN primary_revenue_csr;

Line 928: IF p_pa_debug_mode = 'Y' THEN

924: IF p_context IS NOT NULL THEN
925: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
926: END IF;
927: CLOSE primary_revenue_csr;
928: IF p_pa_debug_mode = 'Y' THEN
929: PA_DEBUG.Reset_Err_stack;
930: END IF;
931: RETURN;
932: ELSE

Line 929: PA_DEBUG.Reset_Err_stack;

925: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
926: END IF;
927: CLOSE primary_revenue_csr;
928: IF p_pa_debug_mode = 'Y' THEN
929: PA_DEBUG.Reset_Err_stack;
930: END IF;
931: RETURN;
932: ELSE
933: x_fin_plan_type_id := primary_revenue_rec.fin_plan_type_id;

Line 939: IF p_pa_debug_mode = 'Y' THEN

935: CLOSE primary_revenue_csr;
936: END IF;
937: EXCEPTION
938: WHEN OTHERS THEN
939: IF p_pa_debug_mode = 'Y' THEN
940: PA_DEBUG.Reset_Err_stack;
941: END IF;
942:
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 940: PA_DEBUG.Reset_Err_stack;

936: END IF;
937: EXCEPTION
938: WHEN OTHERS THEN
939: IF p_pa_debug_mode = 'Y' THEN
940: PA_DEBUG.Reset_Err_stack;
941: END IF;
942:
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_SHORTCUTS_PKG',

Line 1000: IF P_PA_DEBUG_MODE = 'Y' THEN

996: project_id = p_project_id AND
997: fin_plan_option_level_code = 'PLAN_TYPE' AND
998: fin_plan_type_id = p_fin_plan_type_id;
999:
1000: IF P_PA_DEBUG_MODE = 'Y' THEN
1001: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_cw_version');
1002: pa_debug.write( x_module => l_module,
1003: x_msg => 'selecting the CW version',
1004: x_log_level => 3);

Line 1001: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_cw_version');

997: fin_plan_option_level_code = 'PLAN_TYPE' AND
998: fin_plan_type_id = p_fin_plan_type_id;
999:
1000: IF P_PA_DEBUG_MODE = 'Y' THEN
1001: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_cw_version');
1002: pa_debug.write( x_module => l_module,
1003: x_msg => 'selecting the CW version',
1004: x_log_level => 3);
1005: END IF;

Line 1002: pa_debug.write( x_module => l_module,

998: fin_plan_type_id = p_fin_plan_type_id;
999:
1000: IF P_PA_DEBUG_MODE = 'Y' THEN
1001: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_cw_version');
1002: pa_debug.write( x_module => l_module,
1003: x_msg => 'selecting the CW version',
1004: x_log_level => 3);
1005: END IF;
1006:

Line 1027: IF P_PA_DEBUG_MODE = 'Y' THEN

1023: current_working_Flag ='Y' AND
1024: version_type IN (p_version_type,'ALL');
1025: EXCEPTION
1026: WHEN NO_DATA_FOUND THEN
1027: IF P_PA_DEBUG_MODE = 'Y' THEN
1028: pa_debug.write( x_module => l_module,
1029: x_msg => 'no CW version',
1030: x_log_level => 3);
1031: END IF;

Line 1028: pa_debug.write( x_module => l_module,

1024: version_type IN (p_version_type,'ALL');
1025: EXCEPTION
1026: WHEN NO_DATA_FOUND THEN
1027: IF P_PA_DEBUG_MODE = 'Y' THEN
1028: pa_debug.write( x_module => l_module,
1029: x_msg => 'no CW version',
1030: x_log_level => 3);
1031: END IF;
1032: IF p_version_type = 'COST' THEN

Line 1061: IF p_pa_debug_mode = 'Y' THEN

1057: IF l_fin_plan_preference_code = 'COST_AND_REV_SEP' THEN
1058: x_redirect_url := x_redirect_url ||'&paCostOrRev='||
1059: initcap(p_version_type);
1060: END IF;
1061: IF p_pa_debug_mode = 'Y' THEN
1062: PA_DEBUG.Reset_Err_stack;
1063: END IF;
1064: RETURN;
1065: END;

Line 1062: PA_DEBUG.Reset_Err_stack;

1058: x_redirect_url := x_redirect_url ||'&paCostOrRev='||
1059: initcap(p_version_type);
1060: END IF;
1061: IF p_pa_debug_mode = 'Y' THEN
1062: PA_DEBUG.Reset_Err_stack;
1063: END IF;
1064: RETURN;
1065: END;
1066:

Line 1076: IF p_pa_debug_mode = 'Y' THEN

1072:
1073: IF p_context IS NOT NULL THEN
1074: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1075: END IF;
1076: IF p_pa_debug_mode = 'Y' THEN
1077: PA_DEBUG.Reset_Err_stack;
1078: END IF;
1079: RETURN;
1080: END IF;

Line 1077: PA_DEBUG.Reset_Err_stack;

1073: IF p_context IS NOT NULL THEN
1074: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1075: END IF;
1076: IF p_pa_debug_mode = 'Y' THEN
1077: PA_DEBUG.Reset_Err_stack;
1078: END IF;
1079: RETURN;
1080: END IF;
1081:

Line 1082: IF P_PA_DEBUG_MODE = 'Y' THEN

1078: END IF;
1079: RETURN;
1080: END IF;
1081:
1082: IF P_PA_DEBUG_MODE = 'Y' THEN
1083: pa_debug.write( x_module => l_module,
1084: x_msg => 'calling Pa_fin_plan_utils.Check_if_plan_type_editable',
1085: x_log_level => 3);
1086: END IF;

Line 1083: pa_debug.write( x_module => l_module,

1079: RETURN;
1080: END IF;
1081:
1082: IF P_PA_DEBUG_MODE = 'Y' THEN
1083: pa_debug.write( x_module => l_module,
1084: x_msg => 'calling Pa_fin_plan_utils.Check_if_plan_type_editable',
1085: x_log_level => 3);
1086: END IF;
1087:

Line 1098: IF p_pa_debug_mode = 'Y' THEN

1094: X_msg_count => x_msg_count,
1095: X_msg_data => x_msg_data);
1096:
1097: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1098: IF p_pa_debug_mode = 'Y' THEN
1099: PA_DEBUG.Reset_Err_stack;
1100: END IF;
1101: RETURN;
1102: END IF;

Line 1099: PA_DEBUG.Reset_Err_stack;

1095: X_msg_data => x_msg_data);
1096:
1097: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1098: IF p_pa_debug_mode = 'Y' THEN
1099: PA_DEBUG.Reset_Err_stack;
1100: END IF;
1101: RETURN;
1102: END IF;
1103:

Line 1112: IF p_pa_debug_mode = 'Y' THEN

1108:
1109: IF p_context IS NOT NULL THEN
1110: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1111: END IF;
1112: IF p_pa_debug_mode = 'Y' THEN
1113: PA_DEBUG.Reset_Err_stack;
1114: END IF;
1115: RETURN;
1116: END IF;

Line 1113: PA_DEBUG.Reset_Err_stack;

1109: IF p_context IS NOT NULL THEN
1110: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1111: END IF;
1112: IF p_pa_debug_mode = 'Y' THEN
1113: PA_DEBUG.Reset_Err_stack;
1114: END IF;
1115: RETURN;
1116: END IF;
1117:

Line 1118: IF P_PA_DEBUG_MODE = 'Y' THEN

1114: END IF;
1115: RETURN;
1116: END IF;
1117:
1118: IF P_PA_DEBUG_MODE = 'Y' THEN
1119: pa_debug.write( x_module => l_module,
1120: x_msg => 'calling PA_COMP_PROFILE_PUB.get_user_info api for person id',
1121: x_log_level => 3);
1122: END IF;

Line 1119: pa_debug.write( x_module => l_module,

1115: RETURN;
1116: END IF;
1117:
1118: IF P_PA_DEBUG_MODE = 'Y' THEN
1119: pa_debug.write( x_module => l_module,
1120: x_msg => 'calling PA_COMP_PROFILE_PUB.get_user_info api for person id',
1121: x_log_level => 3);
1122: END IF;
1123: PA_COMP_PROFILE_PUB.GET_USER_INFO

Line 1146: IF p_pa_debug_mode = 'Y' THEN

1142:
1143: IF p_context IS NOT NULL THEN
1144: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1145: END IF;
1146: IF p_pa_debug_mode = 'Y' THEN
1147: PA_DEBUG.Reset_Err_stack;
1148: END IF;
1149: RETURN;
1150: else

Line 1147: PA_DEBUG.Reset_Err_stack;

1143: IF p_context IS NOT NULL THEN
1144: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1145: END IF;
1146: IF p_pa_debug_mode = 'Y' THEN
1147: PA_DEBUG.Reset_Err_stack;
1148: END IF;
1149: RETURN;
1150: else
1151: /* setting url for Budgets and Forecasts page */

Line 1158: IF p_pa_debug_mode = 'Y' THEN

1154:
1155: IF p_context IS NOT NULL THEN
1156: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1157: END IF;
1158: IF p_pa_debug_mode = 'Y' THEN
1159: PA_DEBUG.Reset_Err_stack;
1160: END IF;
1161: RETURN;
1162: end if;

Line 1159: PA_DEBUG.Reset_Err_stack;

1155: IF p_context IS NOT NULL THEN
1156: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1157: END IF;
1158: IF p_pa_debug_mode = 'Y' THEN
1159: PA_DEBUG.Reset_Err_stack;
1160: END IF;
1161: RETURN;
1162: end if;
1163: END IF;

Line 1166: IF P_PA_DEBUG_MODE = 'Y' THEN

1162: end if;
1163: END IF;
1164:
1165: IF l_locked_by_person_id IS NULL THEN
1166: IF P_PA_DEBUG_MODE = 'Y' THEN
1167: pa_debug.write( x_module => l_module,
1168: x_msg => 'calling pa_fin_plan_pvt.lock_unlock_version api',
1169: x_log_level => 3);
1170: END IF;

Line 1167: pa_debug.write( x_module => l_module,

1163: END IF;
1164:
1165: IF l_locked_by_person_id IS NULL THEN
1166: IF P_PA_DEBUG_MODE = 'Y' THEN
1167: pa_debug.write( x_module => l_module,
1168: x_msg => 'calling pa_fin_plan_pvt.lock_unlock_version api',
1169: x_log_level => 3);
1170: END IF;
1171: pa_fin_plan_pvt.lock_unlock_version

Line 1182: IF p_pa_debug_mode = 'Y' THEN

1178: x_msg_count => x_msg_count,
1179: x_msg_data => x_msg_data);
1180:
1181: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1182: IF p_pa_debug_mode = 'Y' THEN
1183: PA_DEBUG.Reset_Err_stack;
1184: END IF;
1185: RETURN;
1186: END IF;

Line 1183: PA_DEBUG.Reset_Err_stack;

1179: x_msg_data => x_msg_data);
1180:
1181: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1182: IF p_pa_debug_mode = 'Y' THEN
1183: PA_DEBUG.Reset_Err_stack;
1184: END IF;
1185: RETURN;
1186: END IF;
1187:

Line 1188: IF P_PA_DEBUG_MODE = 'Y' THEN

1184: END IF;
1185: RETURN;
1186: END IF;
1187:
1188: IF P_PA_DEBUG_MODE = 'Y' THEN
1189: pa_debug.write( x_module => l_module,
1190: x_msg => 'version locked successfully.',
1191: x_log_level => 3);
1192: END IF;

Line 1189: pa_debug.write( x_module => l_module,

1185: RETURN;
1186: END IF;
1187:
1188: IF P_PA_DEBUG_MODE = 'Y' THEN
1189: pa_debug.write( x_module => l_module,
1190: x_msg => 'version locked successfully.',
1191: x_log_level => 3);
1192: END IF;
1193: END IF;

Line 1212: IF p_pa_debug_mode = 'Y' THEN

1208: END IF;
1209:
1210: ELSE ** 3604167 */
1211: x_redirect_url := 'WEBADI';
1212: IF p_pa_debug_mode = 'Y' THEN
1213: PA_DEBUG.Reset_Err_stack;
1214: END IF;
1215: -- END IF;
1216: RETURN;

Line 1213: PA_DEBUG.Reset_Err_stack;

1209:
1210: ELSE ** 3604167 */
1211: x_redirect_url := 'WEBADI';
1212: IF p_pa_debug_mode = 'Y' THEN
1213: PA_DEBUG.Reset_Err_stack;
1214: END IF;
1215: -- END IF;
1216: RETURN;
1217: ELSE

Line 1227: IF p_pa_debug_mode = 'Y' THEN

1223:
1224: IF p_context IS NOT NULL THEN
1225: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1226: END IF;
1227: IF p_pa_debug_mode = 'Y' THEN
1228: PA_DEBUG.Reset_Err_stack;
1229: END IF;
1230: RETURN;
1231: END IF;

Line 1228: PA_DEBUG.Reset_Err_stack;

1224: IF p_context IS NOT NULL THEN
1225: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1226: END IF;
1227: IF p_pa_debug_mode = 'Y' THEN
1228: PA_DEBUG.Reset_Err_stack;
1229: END IF;
1230: RETURN;
1231: END IF;
1232: ELSE

Line 1242: IF p_pa_debug_mode = 'Y' THEN

1238: -- 2979654: use -1 to eliminate URL persistence
1239: IF p_context IS NOT NULL THEN
1240: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1241: END IF;
1242: IF p_pa_debug_mode = 'Y' THEN
1243: PA_DEBUG.Reset_Err_stack;
1244: END IF;
1245: RETURN;
1246: END IF;

Line 1243: PA_DEBUG.Reset_Err_stack;

1239: IF p_context IS NOT NULL THEN
1240: x_redirect_url := x_redirect_url ||'&pContext='||p_context;
1241: END IF;
1242: IF p_pa_debug_mode = 'Y' THEN
1243: PA_DEBUG.Reset_Err_stack;
1244: END IF;
1245: RETURN;
1246: END IF;
1247: EXCEPTION

Line 1250: IF p_pa_debug_mode = 'Y' THEN

1246: END IF;
1247: EXCEPTION
1248: WHEN OTHERS THEN
1249: ROLLBACK TO lock_cw_version_PH;
1250: IF p_pa_debug_mode = 'Y' THEN
1251: PA_DEBUG.Reset_Err_stack;
1252: END IF;
1253:
1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1251: PA_DEBUG.Reset_Err_stack;

1247: EXCEPTION
1248: WHEN OTHERS THEN
1249: ROLLBACK TO lock_cw_version_PH;
1250: IF p_pa_debug_mode = 'Y' THEN
1251: PA_DEBUG.Reset_Err_stack;
1252: END IF;
1253:
1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_SHORTCUTS_PKG',