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_ORG_FCST_UTILS dependencies on PA_FP_ORG_FCST_UTILS

Line 1: PACKAGE BODY pa_fp_org_fcst_utils as

1: PACKAGE BODY pa_fp_org_fcst_utils as
2: /* $Header: PAFPORUB.pls 120.4 2007/02/06 10:02:46 dthakker ship $ */
3: -- Start of Comments
4: -- Package name : PA_FP_ORG_FCST_UTILS
5: -- Purpose :

Line 4: -- Package name : PA_FP_ORG_FCST_UTILS

1: PACKAGE BODY pa_fp_org_fcst_utils as
2: /* $Header: PAFPORUB.pls 120.4 2007/02/06 10:02:46 dthakker ship $ */
3: -- Start of Comments
4: -- Package name : PA_FP_ORG_FCST_UTILS
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 70: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_forecast_option_details');

66: ORDER BY gp.start_date;
67:
68: BEGIN
69: IF P_PA_DEBUG_MODE = 'Y' THEN
70: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
71: END IF;
72:
73: --fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
74: l_debug_mode := 'Y';

Line 83: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.get_forecast_option_details');

79:
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: IF P_PA_DEBUG_MODE = 'Y' THEN
83: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
84: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);
85: END IF;
86: l_stage := 100;
87:

Line 197: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.get_forecast_option_details');

193: x_return_status := FND_API.G_RET_STS_ERROR;
194: x_err_code := -1;
195: END IF;
196: IF P_PA_DEBUG_MODE = 'Y' THEN
197: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
198: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);
199: END IF;
200: pa_debug.reset_err_stack;
201: EXCEPTION

Line 204: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_forecast_options_details'

200: pa_debug.reset_err_stack;
201: EXCEPTION
202: WHEN OTHERS THEN
203: FND_MSG_PUB.add_exc_msg(
204: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_forecast_options_details'
205: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
206:
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: x_err_code := SQLERRM;

Line 227: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_project_info');

223: l_debug_mode VARCHAR2(30);
224:
225: BEGIN
226: IF P_PA_DEBUG_MODE = 'Y' THEN
227: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_project_info');
228: END IF;
229:
230: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
231: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 240: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_project_info for Org ['||p_organization_id ||

236:
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: l_stage := 100;
240: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_project_info for Org ['||p_organization_id ||
241: ']';
242: IF P_PA_DEBUG_MODE = 'Y' THEN
243: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);
244: END IF;

Line 259: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_project_info';

255: WHERE ppt.org_project_flag = 'Y')
256: AND pp.template_flag = 'N';
257: -- bug 3106741 AND NVL(pp.template_flag,'N') = 'N';
258:
259: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_project_info';
260: IF P_PA_DEBUG_MODE = 'Y' THEN
261: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);
262: END IF;
263: pa_debug.reset_err_stack;

Line 274: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.org_project_exists'

270: END IF;
271: pa_debug.reset_err_stack;
272: WHEN OTHERS THEN
273: FND_MSG_PUB.add_exc_msg(
274: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.org_project_exists'
275: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
276:
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: x_err_code := SQLERRM;

Line 307: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_task_info');

303:
304: BEGIN
305: BEGIN
306: IF P_PA_DEBUG_MODE = 'Y' THEN
307: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_task_info');
308: END IF;
309:
310: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
311: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 320: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_task_info for Project ['||p_project_id || ']';

316:
317: x_return_status := FND_API.G_RET_STS_SUCCESS;
318:
319: l_stage := 100;
320: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_task_info for Project ['||p_project_id || ']';
321: IF P_PA_DEBUG_MODE = 'Y' THEN
322: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);
323: END IF;
324:

Line 329: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_task_info';

325: OPEN own_task;
326: FETCH own_task into x_org_task_id, x_organization_id;
327: CLOSE own_task;
328: l_stage := 200;
329: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_task_info';
330: IF P_PA_DEBUG_MODE = 'Y' THEN
331: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);
332: END IF;
333: pa_debug.reset_err_stack;

Line 349: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.org_project_exists'

345: END;
346: EXCEPTION
347: WHEN OTHERS THEN
348: FND_MSG_PUB.add_exc_msg(
349: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.org_project_exists'
350: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
351:
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: x_err_code := SQLERRM;

Line 417: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_utilization_details');

413: l_stage NUMBER := 0;
414:
415: BEGIN
416: IF P_PA_DEBUG_MODE = 'Y' THEN
417: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_utilization_details');
418: END IF;
419:
420: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
421: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 480: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_utilization_details'

476: pa_debug.reset_err_stack;
477: EXCEPTION
478: WHEN OTHERS THEN
479: FND_MSG_PUB.add_exc_msg(
480: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_utilization_details'
481: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
482:
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: x_err_code := SQLERRM;

Line 522: pa_debug.init_err_stack('get_headcount: ' || 'PA_FP_ORG_FCST_UTILS.get_utilization_details');

518:
519:
520: BEGIN
521: IF P_PA_DEBUG_MODE = 'Y' THEN
522: pa_debug.init_err_stack('get_headcount: ' || 'PA_FP_ORG_FCST_UTILS.get_utilization_details');
523: END IF;
524:
525: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
526: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 557: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_headcount'

553: pa_debug.reset_err_stack;
554: EXCEPTION
555: WHEN OTHERS THEN
556: FND_MSG_PUB.add_exc_msg(
557: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_headcount'
558: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
559:
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: x_err_code := SQLERRM;

Line 579: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_probability_percent');

575: l_debug_mode VARCHAR2(30);
576: l_probability_member_id pa_projects_all.probability_member_id%TYPE;
577: BEGIN
578: IF P_PA_DEBUG_MODE = 'Y' THEN
579: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_probability_percent');
580: END IF;
581:
582: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
583: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 614: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_probability_percent'

610: pa_debug.reset_err_stack;
611: EXCEPTION
612: WHEN OTHERS THEN
613: FND_MSG_PUB.add_exc_msg(
614: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_probability_percent'
615: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 646: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_period_profile');

642: IS
643: l_debug_mode VARCHAR2(30);
644: BEGIN
645: IF P_PA_DEBUG_MODE = 'Y' THEN
646: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_period_profile');
647: END IF;
648:
649: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
650: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 690: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_period_profile'

686: pa_debug.reset_err_stack;
687: EXCEPTION
688: WHEN OTHERS THEN
689: FND_MSG_PUB.add_exc_msg(
690: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_period_profile'
691: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: x_err_code := SQLERRM;
694: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 711: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.check_org_proj_template');

707: l_org_proj_template_exists varchar2(1);
708:
709: BEGIN
710: IF P_PA_DEBUG_MODE = 'Y' THEN
711: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.check_org_proj_template');
712: END IF;
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714:
715: l_org_proj_template_exists := 'N';

Line 725: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_proj_template');

721:
722: x_return_status := FND_API.G_RET_STS_ERROR;
723:
724: IF P_PA_DEBUG_MODE = 'Y' THEN
725: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_proj_template');
726: END IF;
727: pa_debug.reset_err_stack;
728: return(l_org_proj_template_exists);
729:

Line 737: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'

733: x_return_status := FND_API.G_RET_STS_SUCCESS;
734: return(l_org_proj_template_exists);
735: WHEN OTHERS THEN
736: FND_MSG_PUB.add_exc_msg(
737: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'
738: ,p_procedure_name => 'check_org_proj_template');
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: x_err_code := SQLERRM;
741: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 799: ( p_pkg_name => 'PA_FP_ORG_FCST_UTILS',

795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: x_msg_count := 1;
797: x_msg_data := SUBSTR(SQLERRM,1,30);
798: FND_MSG_PUB.add_exc_msg
799: ( p_pkg_name => 'PA_FP_ORG_FCST_UTILS',
800: p_procedure_name => 'Get_Tp_Amount_Type');
801: RAISE;
802: END Get_Tp_Amount_Type;
803:

Line 815: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.check_org_project');

811: l_org_project_exists varchar2(1);
812:
813: BEGIN
814: IF P_PA_DEBUG_MODE = 'Y' THEN
815: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.check_org_project');
816: END IF;
817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818:
819: l_org_project_exists := 'N';

Line 830: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_project');

826: AND pt.project_type = pp.project_type
827: AND pt.org_project_flag = 'Y';
828:
829: IF P_PA_DEBUG_MODE = 'Y' THEN
830: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_project');
831: END IF;
832: pa_debug.reset_err_stack;
833: return(l_org_project_exists);
834:

Line 842: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'

838: x_return_status := FND_API.G_RET_STS_SUCCESS;
839: return(l_org_project_exists);
840: WHEN OTHERS THEN
841: FND_MSG_PUB.add_exc_msg(
842: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'
843: ,p_procedure_name => 'check_org_project');
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: --x_err_code := SQLERRM; bug 4338407
846: x_err_code := SQLCODE;

Line 1527: l_is_org_project := PA_FP_ORG_FCST_UTILS.is_org_project

1523: IF P_PA_DEBUG_MODE = 'Y' THEN
1524: pa_debug.write_file('Entered PA_FIN_PLAN_UTILS.detect_org_project');
1525: END IF;
1526: x_return_status := FND_API.G_RET_STS_SUCCESS;
1527: l_is_org_project := PA_FP_ORG_FCST_UTILS.is_org_project
1528: (p_project_id => p_project_id);
1529: if x_return_status = FND_API.G_RET_STS_SUCCESS then
1530: if l_is_org_project = 'Y' then
1531: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1550: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'

1546:
1547: EXCEPTION
1548: WHEN OTHERS THEN
1549: FND_MSG_PUB.add_exc_msg(
1550: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'
1551: ,p_procedure_name => 'detect_org_project');
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: x_err_code := SQLERRM;
1554: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1577: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.same_org_id');

1573: l_same_org_id VARCHAR2(1);
1574: org_id_endpoint NUMBER(15);
1575: BEGIN
1576: IF P_PA_DEBUG_MODE = 'Y' THEN
1577: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.same_org_id');
1578: pa_debug.set_process('same_org_id: ' || 'PLSQL','LOG', 'Y');
1579: pa_debug.write('plsql.pa.pa_fp_org_fcst_utils.same_org_id', 'Entered PA_FP_ORG_FCST_UTILS.same_org_id', 1);
1580: END IF;
1581: l_same_org_id := 'N';

Line 1579: pa_debug.write('plsql.pa.pa_fp_org_fcst_utils.same_org_id', 'Entered PA_FP_ORG_FCST_UTILS.same_org_id', 1);

1575: BEGIN
1576: IF P_PA_DEBUG_MODE = 'Y' THEN
1577: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.same_org_id');
1578: pa_debug.set_process('same_org_id: ' || 'PLSQL','LOG', 'Y');
1579: pa_debug.write('plsql.pa.pa_fp_org_fcst_utils.same_org_id', 'Entered PA_FP_ORG_FCST_UTILS.same_org_id', 1);
1580: END IF;
1581: l_same_org_id := 'N';
1582:
1583: select org_id, USERENV('CLIENT_INFO')

Line 1605: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'

1601: l_same_org_id := 'E';
1602: return(l_same_org_id);
1603: WHEN OTHERS THEN
1604: FND_MSG_PUB.add_exc_msg(
1605: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'
1606: ,p_procedure_name => 'same_org_id');
1607: pa_debug.reset_err_stack;
1608: return('U');
1609: END same_org_id;

Line 1626: l_same_org_id := pa_fp_org_fcst_utils.same_org_id

1622: l_data VARCHAR2(2000);
1623: l_msg_index_out NUMBER;
1624: BEGIN
1625: x_return_status := FND_API.G_RET_STS_SUCCESS;
1626: l_same_org_id := pa_fp_org_fcst_utils.same_org_id
1627: (p_project_id => p_project_id);
1628: if l_same_org_id = 'N' then
1629: x_return_status := FND_API.G_RET_STS_ERROR;
1630: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 1651: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ORG_FCST_UTILS',

1647: when others then
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649: x_msg_count := 1;
1650: x_msg_data := SQLERRM;
1651: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ORG_FCST_UTILS',
1652: p_procedure_name => 'check_same_org_id');
1653: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1654: END check_same_org_id;
1655: */

Line 1690: END pa_fp_org_fcst_utils;

1686: return(l_org_project_exists);
1687: END is_org_project;
1688:
1689:
1690: END pa_fp_org_fcst_utils;