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_FORECAST_ITEMS_UTILS dependencies on PA_FORECAST_ITEMS_UTILS

Line 1: PACKAGE BODY PA_FORECAST_ITEMS_UTILS AS

1: PACKAGE BODY PA_FORECAST_ITEMS_UTILS AS
2: /* $Header: PARFIUTB.pls 120.7.12010000.3 2008/09/24 10:20:47 rthumma ship $ */
3:
4: ------------------------------------------------------------------------------------------------------------------
5: -- This function gets the unique identifier for the forecast item

Line 85: pa_forecast_items_utils.allocate_unique(

81: Return -99;
82: END IF;
83:
84: /* Get lock handle for user lock */
85: pa_forecast_items_utils.allocate_unique(
86: p_lock_name =>lock_name,
87: p_lock_handle =>lockhndl);
88:
89: IF ( lockhndl IS NOT NULL ) then

Line 135: pa_forecast_items_utils.allocate_unique(

131: Return -99;
132: END IF;
133:
134: /* Get lock handle for user lock */
135: pa_forecast_items_utils.allocate_unique(
136: p_lock_name =>lock_name,
137: p_lock_handle =>lockhndl);
138:
139: IF ( lockhndl IS NOT NULL ) then

Line 222: 'PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules');

218: cur_res_asgn_rec cur_res_asgn%ROWTYPE;
219: li_cnt NUMBER:=0;
220: BEGIN
221: PA_DEBUG.Init_err_stack(
222: 'PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules');
223:
224: BEGIN
225: li_cnt :=1;
226:

Line 264: 'PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules',

260: x_msg_data := sqlerrm;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.add_exc_msg
263: (p_pkg_name =>
264: 'PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules',
265: p_procedure_name => PA_DEBUG.G_Err_Stack);
266: raise;
267:
268: END;

Line 354: 'PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules');

350: cur_asgn_sch_rec cur_asgn_sch%ROWTYPE;
351: li_cnt NUMBER:=0;
352: BEGIN
353: PA_DEBUG.Init_err_stack(
354: 'PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules');
355: BEGIN
356:
357: li_cnt :=1;
358:

Line 397: 'PA_FORECAST_ITEMS_UTILS.Get_Assignment_Schedule',

393: x_msg_data := sqlerrm;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: FND_MSG_PUB.add_exc_msg
396: (p_pkg_name =>
397: 'PA_FORECAST_ITEMS_UTILS.Get_Assignment_Schedule',
398: p_procedure_name => PA_DEBUG.G_Err_Stack);
399: raise;
400: END;
401:

Line 678: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'

674: x_StartDateTab.delete;
675: x_EndDateTab.delete;
676: x_PAPeriodNameTab.delete ;
677: FND_MSG_PUB.add_exc_msg
678: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'
679: , p_procedure_name => 'Get_PA_Period_Name'
680: , p_error_text => SUBSTRB(SQLERRM,1,240));
681: RAISE ;
682: END Get_PA_Period_Name;

Line 789: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'

785: x_StartDateTab.delete;
786: x_EndDateTab.delete;
787: x_PAPeriodNameTab.delete ;
788: FND_MSG_PUB.add_exc_msg
789: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'
790: , p_procedure_name => 'Get_GL_Period_Name'
791: , p_error_text => SUBSTRB(SQLERRM,1,240));
792: RAISE ;
793: END Get_GL_Period_Name;

Line 955: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'

951: x_ResourceOUTab.delete;
952: x_StartDateTab.delete;
953: x_EndDateTab.delete;
954: FND_MSG_PUB.add_exc_msg
955: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'
956: , p_procedure_name => 'Get_Resource_OU'
957: , p_error_text => SUBSTRB(SQLERRM,1,240));
958: RAISE ;
959: END Get_Resource_OU;

Line 1142: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'

1138: x_ResourceJobIDTab.delete;
1139: x_StartDateTab.delete;
1140: x_EndDateTab.delete;
1141: FND_MSG_PUB.add_exc_msg
1142: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'
1143: , p_procedure_name => 'Get_Res_Org_And_Job'
1144: , p_error_text => SUBSTRB(SQLERRM,1,240));
1145: RAISE ;
1146: END Get_Res_Org_And_Job;

Line 1242: 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions');

1238: -- 4537865 : Initialize x_return_status to SUCCESS
1239: x_return_status := FND_API.G_RET_STS_SUCCESS;
1240:
1241: PA_DEBUG.Init_err_stack(
1242: 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions');
1243: -- Selecting columns corresponding to the given org id
1244:
1245: PA_FORECASTITEM_PVT.print_message('p_org_id: ' || p_org_id );
1246:

Line 1312: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions',

1308: x_msg_data := sqlerrm;
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310:
1311: FND_MSG_PUB.add_exc_msg
1312: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions',
1313: p_procedure_name => PA_DEBUG.G_Err_Stack);
1314:
1315: RAISE;
1316:

Line 1323: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions',

1319: x_msg_data := sqlerrm;
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321:
1322: FND_MSG_PUB.add_exc_msg
1323: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions',
1324: p_procedure_name => PA_DEBUG.G_Err_Stack);
1325: RAISE;
1326:
1327:

Line 1362: 'PA_FORECAST_ITEMS_UTILS.Get_Week_Dates_Range_Fc');

1358: BEGIN
1359:
1360:
1361: PA_DEBUG.Init_err_stack(
1362: 'PA_FORECAST_ITEMS_UTILS.Get_Week_Dates_Range_Fc');
1363: -- Taking value of the day from the profile option
1364:
1365: l_week_starting_day_index := TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'));
1366:

Line 1407: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_Week_Dates_Range_Fc',

1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: x_msg_count := 1;
1405: x_msg_data := SQLERRM;
1406: FND_MSG_PUB.add_exc_msg
1407: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_Week_Dates_Range_Fc',
1408: p_procedure_name => PA_DEBUG.G_Err_Stack);
1409: RAISE;
1410: END Get_Week_Dates_Range_Fc;
1411:

Line 1441: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType');

1437:
1438: BEGIN
1439:
1440: PA_DEBUG.Init_err_stack(
1441: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType');
1442: IF p_tp_amount_type_code IS NOT NULL AND
1443: p_tp_amount_type_code<>FND_API.G_MISS_CHAR THEN
1444:
1445: IF p_check_id_flag = 'Y' THEN

Line 1489: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',

1485: --4537865 : End
1486:
1487: FND_MSG_PUB.add_exc_msg
1488: (p_pkg_name =>
1489: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',
1490: p_procedure_name => PA_DEBUG.G_Err_Stack);
1491: WHEN TOO_MANY_ROWS THEN
1492: x_return_status := FND_API.G_RET_STS_ERROR;
1493: x_msg_data := lv_error_msg;

Line 1502: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',

1498: --4537865 : End
1499:
1500: FND_MSG_PUB.add_exc_msg
1501: (p_pkg_name =>
1502: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',
1503: p_procedure_name => PA_DEBUG.G_Err_Stack);
1504: WHEN OTHERS THEN
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1506:

Line 1514: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',

1510: --4537865 : End
1511:
1512: FND_MSG_PUB.add_exc_msg
1513: (p_pkg_name =>
1514: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',
1515: p_procedure_name => PA_DEBUG.G_Err_Stack);
1516: --PA_Error_Utils.Set_Error_Stack
1517: -- (`pa_resource_utils.check_resourcename_or_id');
1518: -- This sets the current program unit name in the

Line 1611: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_assignment_default',

1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1608: x_msg_count := 1;
1609: x_msg_data := SQLERRM;
1610: FND_MSG_PUB.add_exc_msg
1611: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_assignment_default',
1612: p_procedure_name => PA_DEBUG.G_Err_Stack);
1613: raise;
1614:
1615: END Get_Assignment_Default;

Line 1691: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_project_default',

1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1688: x_msg_count := 1;
1689: x_msg_data := SQLERRM;
1690: FND_MSG_PUB.add_exc_msg
1691: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_project_default',
1692: p_procedure_name => PA_DEBUG.G_Err_Stack);
1693: raise;
1694:
1695: END Get_Project_Default;

Line 1743: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_Project_Role_default',

1739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1740: x_msg_count := 1;
1741: x_msg_data := SQLERRM;
1742: FND_MSG_PUB.add_exc_msg
1743: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_Project_Role_default',
1744: p_procedure_name => PA_DEBUG.G_Err_Stack);
1745: raise;
1746:
1747: END Get_Project_Role_Default;

Line 1749: END PA_FORECAST_ITEMS_UTILS;

1745: raise;
1746:
1747: END Get_Project_Role_Default;
1748:
1749: END PA_FORECAST_ITEMS_UTILS;
1750: