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.11.12020000.2 2012/07/19 09:57:34 admarath 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 796: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'

792: x_StartDateTab.delete;
793: x_EndDateTab.delete;
794: x_PAPeriodNameTab.delete ;
795: FND_MSG_PUB.add_exc_msg
796: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'
797: , p_procedure_name => 'Get_GL_Period_Name'
798: , p_error_text => SUBSTRB(SQLERRM,1,240));
799: RAISE ;
800: END Get_GL_Period_Name;

Line 962: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'

958: x_ResourceOUTab.delete;
959: x_StartDateTab.delete;
960: x_EndDateTab.delete;
961: FND_MSG_PUB.add_exc_msg
962: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'
963: , p_procedure_name => 'Get_Resource_OU'
964: , p_error_text => SUBSTRB(SQLERRM,1,240));
965: RAISE ;
966: END Get_Resource_OU;

Line 1149: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'

1145: x_ResourceJobIDTab.delete;
1146: x_StartDateTab.delete;
1147: x_EndDateTab.delete;
1148: FND_MSG_PUB.add_exc_msg
1149: ( p_pkg_name => 'PA_FORECAST_ITEMS_UTILS'
1150: , p_procedure_name => 'Get_Res_Org_And_Job'
1151: , p_error_text => SUBSTRB(SQLERRM,1,240));
1152: RAISE ;
1153: END Get_Res_Org_And_Job;

Line 1249: 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions');

1245: -- 4537865 : Initialize x_return_status to SUCCESS
1246: x_return_status := FND_API.G_RET_STS_SUCCESS;
1247:
1248: PA_DEBUG.Init_err_stack(
1249: 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions');
1250: -- Selecting columns corresponding to the given org id
1251:
1252: PA_FORECASTITEM_PVT.print_message('p_org_id: ' || p_org_id );
1253:

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

1315: x_msg_data := sqlerrm;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317:
1318: FND_MSG_PUB.add_exc_msg
1319: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions',
1320: p_procedure_name => PA_DEBUG.G_Err_Stack);
1321:
1322: RAISE;
1323:

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

1326: x_msg_data := sqlerrm;
1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328:
1329: FND_MSG_PUB.add_exc_msg
1330: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions',
1331: p_procedure_name => PA_DEBUG.G_Err_Stack);
1332: RAISE;
1333:
1334:

Line 1369: 'PA_FORECAST_ITEMS_UTILS.Get_Week_Dates_Range_Fc');

1365: BEGIN
1366:
1367:
1368: PA_DEBUG.Init_err_stack(
1369: 'PA_FORECAST_ITEMS_UTILS.Get_Week_Dates_Range_Fc');
1370: -- Taking value of the day from the profile option
1371:
1372: l_week_starting_day_index := TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'));
1373:

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

1410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1411: x_msg_count := 1;
1412: x_msg_data := SQLERRM;
1413: FND_MSG_PUB.add_exc_msg
1414: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_Week_Dates_Range_Fc',
1415: p_procedure_name => PA_DEBUG.G_Err_Stack);
1416: RAISE;
1417: END Get_Week_Dates_Range_Fc;
1418:

Line 1448: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType');

1444:
1445: BEGIN
1446:
1447: PA_DEBUG.Init_err_stack(
1448: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType');
1449: IF p_tp_amount_type_code IS NOT NULL AND
1450: p_tp_amount_type_code<>FND_API.G_MISS_CHAR THEN
1451:
1452: IF p_check_id_flag = 'Y' THEN

Line 1496: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',

1492: --4537865 : End
1493:
1494: FND_MSG_PUB.add_exc_msg
1495: (p_pkg_name =>
1496: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',
1497: p_procedure_name => PA_DEBUG.G_Err_Stack);
1498: WHEN TOO_MANY_ROWS THEN
1499: x_return_status := FND_API.G_RET_STS_ERROR;
1500: x_msg_data := lv_error_msg;

Line 1509: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',

1505: --4537865 : End
1506:
1507: FND_MSG_PUB.add_exc_msg
1508: (p_pkg_name =>
1509: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',
1510: p_procedure_name => PA_DEBUG.G_Err_Stack);
1511: WHEN OTHERS THEN
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1513:

Line 1521: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',

1517: --4537865 : End
1518:
1519: FND_MSG_PUB.add_exc_msg
1520: (p_pkg_name =>
1521: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',
1522: p_procedure_name => PA_DEBUG.G_Err_Stack);
1523: --PA_Error_Utils.Set_Error_Stack
1524: -- (`pa_resource_utils.check_resourcename_or_id');
1525: -- This sets the current program unit name in the

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

1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: x_msg_count := 1;
1616: x_msg_data := SQLERRM;
1617: FND_MSG_PUB.add_exc_msg
1618: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_assignment_default',
1619: p_procedure_name => PA_DEBUG.G_Err_Stack);
1620: raise;
1621:
1622: END Get_Assignment_Default;

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

1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1695: x_msg_count := 1;
1696: x_msg_data := SQLERRM;
1697: FND_MSG_PUB.add_exc_msg
1698: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_project_default',
1699: p_procedure_name => PA_DEBUG.G_Err_Stack);
1700: raise;
1701:
1702: END Get_Project_Default;

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

1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: x_msg_count := 1;
1748: x_msg_data := SQLERRM;
1749: FND_MSG_PUB.add_exc_msg
1750: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_Project_Role_default',
1751: p_procedure_name => PA_DEBUG.G_Err_Stack);
1752: raise;
1753:
1754: END Get_Project_Role_Default;

Line 1756: END PA_FORECAST_ITEMS_UTILS;

1752: raise;
1753:
1754: END Get_Project_Role_Default;
1755:
1756: END PA_FORECAST_ITEMS_UTILS;
1757: