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 1248: PA_DEBUG.Init_err_stack(

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

Line 1309: PA_DEBUG.Reset_Err_Stack;

1305: x_msg_data := 'PA_FORECAST_OPTIONS_NOT_SETUP';
1306: x_msg_count := FND_MSG_PUB.Count_Msg;
1307: end;
1308: end if;
1309: PA_DEBUG.Reset_Err_Stack;
1310:
1311: EXCEPTION
1312: WHEN NO_DATA_FOUND THEN
1313:

Line 1320: p_procedure_name => PA_DEBUG.G_Err_Stack);

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

Line 1331: p_procedure_name => PA_DEBUG.G_Err_Stack);

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

Line 1368: PA_DEBUG.Init_err_stack(

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

Line 1406: PA_DEBUG.Reset_Err_Stack;

1402: li_cnt := li_cnt +1;
1403:
1404: END LOOP;
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;
1406: PA_DEBUG.Reset_Err_Stack;
1407:
1408: EXCEPTION
1409: WHEN OTHERS THEN
1410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1415: p_procedure_name => PA_DEBUG.G_Err_Stack);

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

Line 1447: PA_DEBUG.Init_err_stack(

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

Line 1481: PA_DEBUG.Reset_Err_Stack;

1477:
1478:
1479: END IF;
1480:
1481: PA_DEBUG.Reset_Err_Stack;
1482:
1483: x_return_status := FND_API.G_RET_STS_SUCCESS;
1484: EXCEPTION
1485: WHEN NO_DATA_FOUND THEN

Line 1497: p_procedure_name => PA_DEBUG.G_Err_Stack);

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

Line 1510: p_procedure_name => PA_DEBUG.G_Err_Stack);

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

Line 1522: p_procedure_name => PA_DEBUG.G_Err_Stack);

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

Line 1619: p_procedure_name => PA_DEBUG.G_Err_Stack);

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

Line 1699: p_procedure_name => PA_DEBUG.G_Err_Stack);

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

Line 1751: p_procedure_name => PA_DEBUG.G_Err_Stack);

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