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 FND_API

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: IF P_PA_DEBUG_MODE = 'Y' THEN
77: pa_debug.set_process('get_forecast_option_details: ' || 'PLSQL','LOG',l_debug_mode);
78: END IF;
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);

Line 193: x_return_status := FND_API.G_RET_STS_ERROR;

189: l_org_struc_version_id IS NULL OR
190: l_fcst_start_date IS NULL OR
191: l_fcst_end_date IS NULL OR
192: l_org_id IS NULL THEN
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');

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
209: IF P_PA_DEBUG_MODE = 'Y' THEN
210: pa_debug.write_file('get_forecast_option_details: ' || SQLERRM);
211: END IF;

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

233: IF P_PA_DEBUG_MODE = 'Y' THEN
234: pa_debug.set_process('get_org_project_info: ' || 'PLSQL','LOG',l_debug_mode);
235: END IF;
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: ']';

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
279: IF P_PA_DEBUG_MODE = 'Y' THEN
280: pa_debug.write_file('get_org_project_info: ' || SQLERRM);
281: END IF;

Line 317: x_return_status := FND_API.G_RET_STS_SUCCESS;

313: IF P_PA_DEBUG_MODE = 'Y' THEN
314: pa_debug.set_process('get_org_task_info: ' || 'PLSQL','LOG',l_debug_mode);
315: END IF;
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

Line 339: x_return_status := FND_API.G_RET_STS_ERROR;

335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN
337: x_org_task_id := -9999;
338: x_organization_id := -9999;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: x_err_code := SQLERRM;
341: IF P_PA_DEBUG_MODE = 'Y' THEN
342: pa_debug.write_file('get_org_task_info: ' || 'Org Own Task Not Found');
343: END IF;

Line 352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
354: IF P_PA_DEBUG_MODE = 'Y' THEN
355: pa_debug.write_file('get_org_task_info: ' || SQLERRM);
356: END IF;

Line 427: x_return_status := FND_API.G_RET_STS_SUCCESS;

423: IF P_PA_DEBUG_MODE = 'Y' THEN
424: pa_debug.set_process('get_utilization_details: ' || 'PLSQL','LOG',l_debug_mode);
425: END IF;
426:
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428:
429: l_stage := 100;
430: -- hr_utility.trace('p_org_id ['||p_org_id ||']');
431: -- hr_utility.trace('p_organization_id ['||p_organization_id ||']');

Line 483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
485: IF P_PA_DEBUG_MODE = 'Y' THEN
486: pa_debug.write_file('get_utilization_details: ' || SQLERRM);
487: END IF;

Line 532: x_return_status := FND_API.G_RET_STS_SUCCESS;

528: IF P_PA_DEBUG_MODE = 'Y' THEN
529: pa_debug.set_process('get_headcount: ' || 'PLSQL','LOG',l_debug_mode);
530: END IF;
531:
532: x_return_status := FND_API.G_RET_STS_SUCCESS;
533: /*
534: pa_debug.g_err_stage := 'p_organization_id ['||p_organization_id ||
535: '] p_effective_date ['||p_effective_date ||
536: ']';

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
562: IF P_PA_DEBUG_MODE = 'Y' THEN
563: pa_debug.write_file('get_headcount: ' || SQLERRM);
564: END IF;

Line 617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
619: pa_debug.write_file('get_probability_percent: ' || SQLERRM);
620: END IF;
621: x_err_code := SQLERRM;

Line 656: x_return_status := FND_API.G_RET_STS_SUCCESS;

652: IF P_PA_DEBUG_MODE = 'Y' THEN
653: pa_debug.set_process('get_period_profile: ' || 'PLSQL','LOG',l_debug_mode);
654: END IF;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657: BEGIN
658: SELECT ppp.period_profile_id
659: INTO x_period_profile_id
660: FROM pa_proj_period_profiles ppp

Line 673: x_return_status := FND_API.G_RET_STS_ERROR;

669: --pa_debug.write_file('Period_profile Found');
670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN
672: x_period_profile_id := -99;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: IF P_PA_DEBUG_MODE = 'Y' THEN
675: pa_debug.write_file('get_period_profile: ' || 'Period_profile Not Found');
676: END IF;
677: x_err_code := SQLERRM;

Line 692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
695: pa_debug.write_file('get_period_profile: ' || SQLERRM);
696: END IF;

Line 713: x_return_status := FND_API.G_RET_STS_SUCCESS;

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';
716:
717: SELECT 'Y'

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

718: INTO l_org_proj_template_exists
719: FROM pa_forecasting_options
720: WHERE org_fcst_project_template_id = p_project_id;
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;

Line 733: x_return_status := FND_API.G_RET_STS_SUCCESS;

729:
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN
732: l_org_proj_template_exists := 'N';
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'

Line 739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
742: pa_debug.write_file('check_org_proj_template: ' || SQLERRM);
743: END IF;

Line 756: x_return_status := FND_API.G_RET_STS_SUCCESS;

752: x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
753: l_org_id NUMBER;
754: BEGIN
755:
756: x_return_status := FND_API.G_RET_STS_SUCCESS;
757:
758: x_tp_amount_type := NULL;
759:
760: IF p_work_type_id IS NOT NULL THEN

Line 787: x_return_status := FND_API.G_RET_STS_ERROR;

783: WHEN NO_DATA_FOUND THEN
784: PA_UTILS.Add_Message(
785: p_app_short_name => 'PA'
786: ,p_msg_name =>'PA_FORECAST_OPTIONS_NOT_SETUP');
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: x_msg_data := 'PA_FORECAST_OPTIONS_NOT_SETUP';
789: x_msg_count := FND_MSG_PUB.Count_Msg;
790: END;
791: END IF;

Line 795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

791: END IF;
792: RETURN;
793: EXCEPTION
794: WHEN OTHERS THEN
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',

Line 817: x_return_status := FND_API.G_RET_STS_SUCCESS;

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';
820:
821: SELECT 'Y'

Line 838: x_return_status := FND_API.G_RET_STS_SUCCESS;

834:
835: EXCEPTION
836: WHEN NO_DATA_FOUND THEN
837: l_org_project_exists := 'N';
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'

Line 844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
847: IF P_PA_DEBUG_MODE = 'Y' THEN
848: pa_debug.write_file('check_org_project: ' || SQLERRM);

Line 1526: x_return_status := FND_API.G_RET_STS_SUCCESS;

1522: BEGIN
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

Line 1529: if x_return_status = FND_API.G_RET_STS_SUCCESS then

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;
1532: x_err_code := 'PA_FP_ORG_FCST_MSG';
1533: return;

Line 1531: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1532: x_err_code := 'PA_FP_ORG_FCST_MSG';
1533: return;
1534: else
1535: return;

Line 1538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1534: else
1535: return;
1536: end if;
1537: else
1538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1539: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1540: p_msg_name => l_err_code);
1541: return;
1542: end if;

Line 1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
1555: pa_debug.write_file('detect_org_project: ' || SQLERRM);
1556: END IF;

Line 1625: x_return_status := FND_API.G_RET_STS_SUCCESS;

1621: l_msg_data VARCHAR2(2000);
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;

Line 1629: x_return_status := FND_API.G_RET_STS_ERROR;

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',
1631: p_msg_name => 'PA_FP_ORG_ID_MISMATCH');
1632: l_msg_count := FND_MSG_PUB.count_msg;
1633: if l_msg_count = 1 then

Line 1635: (p_encoded => FND_API.G_TRUE,

1631: p_msg_name => 'PA_FP_ORG_ID_MISMATCH');
1632: l_msg_count := FND_MSG_PUB.count_msg;
1633: if l_msg_count = 1 then
1634: PA_INTERFACE_UTILS_PUB.get_messages
1635: (p_encoded => FND_API.G_TRUE,
1636: p_msg_index => 1,
1637: p_msg_count => l_msg_count,
1638: p_msg_data => l_msg_data,
1639: p_data => l_data,

Line 1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1644: return;
1645: end if;
1646: EXCEPTION
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');

Line 1653: raise FND_API.G_EXC_UNEXPECTED_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: */
1656:
1657: /* for Sheenie: function which takes in only 1 argument: