DBA Data[Home] [Help]

APPS.PA_FORECAST_ITEMS_UTILS dependencies on PA_DEBUG

Line 221: PA_DEBUG.Init_err_stack(

217:
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;

Line 254: PA_DEBUG.Reset_Err_Stack;

250: END LOOP;
251:
252: CLOSE cur_res_asgn;
253:
254: PA_DEBUG.Reset_Err_Stack;
255:
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257: EXCEPTION
258: WHEN OTHERS THEN

Line 265: p_procedure_name => PA_DEBUG.G_Err_Stack);

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;
269:

Line 353: PA_DEBUG.Init_err_stack(

349:
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;

Line 389: PA_DEBUG.Reset_Err_Stack;

385:
386: CLOSE cur_asgn_sch;
387:
388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389: PA_DEBUG.Reset_Err_Stack;
390: EXCEPTION
391: WHEN OTHERS THEN
392: x_msg_count := 1;
393: x_msg_data := sqlerrm;

Line 398: p_procedure_name => PA_DEBUG.G_Err_Stack);

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:
402: END Get_Assignment_Schedule;

Line 1241: PA_DEBUG.Init_err_stack(

1237:
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 );

Line 1302: PA_DEBUG.Reset_Err_Stack;

1298: x_msg_data := 'PA_FORECAST_OPTIONS_NOT_SETUP';
1299: x_msg_count := FND_MSG_PUB.Count_Msg;
1300: end;
1301: end if;
1302: PA_DEBUG.Reset_Err_Stack;
1303:
1304: EXCEPTION
1305: WHEN NO_DATA_FOUND THEN
1306:

Line 1313: p_procedure_name => PA_DEBUG.G_Err_Stack);

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:
1317: WHEN OTHERS THEN

Line 1324: p_procedure_name => PA_DEBUG.G_Err_Stack);

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:
1328: END Get_ForecastOptions;

Line 1361: PA_DEBUG.Init_err_stack(

1357:
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'));

Line 1399: PA_DEBUG.Reset_Err_Stack;

1395: li_cnt := li_cnt +1;
1396:
1397: END LOOP;
1398: x_return_status := FND_API.G_RET_STS_SUCCESS;
1399: PA_DEBUG.Reset_Err_Stack;
1400:
1401: EXCEPTION
1402: WHEN OTHERS THEN
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1408: p_procedure_name => PA_DEBUG.G_Err_Stack);

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:
1412:

Line 1440: PA_DEBUG.Init_err_stack(

1436: lv_error_msg VARCHAR2(30);
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:

Line 1474: PA_DEBUG.Reset_Err_Stack;

1470:
1471:
1472: END IF;
1473:
1474: PA_DEBUG.Reset_Err_Stack;
1475:
1476: x_return_status := FND_API.G_RET_STS_SUCCESS;
1477: EXCEPTION
1478: WHEN NO_DATA_FOUND THEN

Line 1490: p_procedure_name => PA_DEBUG.G_Err_Stack);

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;
1494:

Line 1503: p_procedure_name => PA_DEBUG.G_Err_Stack);

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:
1507: -- 4537865 : Start

Line 1515: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
1519: -- error stack. Helpful in Debugging

Line 1612: p_procedure_name => PA_DEBUG.G_Err_Stack);

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;
1616:

Line 1692: p_procedure_name => PA_DEBUG.G_Err_Stack);

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;
1696:

Line 1744: p_procedure_name => PA_DEBUG.G_Err_Stack);

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;
1748: