DBA Data[Home] [Help]

APPS.PA_FORECAST_ITEMS_UTILS dependencies on FND_MSG_PUB

Line 262: FND_MSG_PUB.add_exc_msg

258: WHEN OTHERS THEN
259: x_msg_count := 1;
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;

Line 395: FND_MSG_PUB.add_exc_msg

391: WHEN OTHERS THEN
392: x_msg_count := 1;
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;

Line 677: FND_MSG_PUB.add_exc_msg

673: WHEN OTHERS THEN -- 4537865 : Included this block
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 ;

Line 795: FND_MSG_PUB.add_exc_msg

791: WHEN OTHERS THEN -- 4537865 : Included this block
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 ;

Line 961: FND_MSG_PUB.add_exc_msg

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

Line 1148: FND_MSG_PUB.add_exc_msg

1144: x_ResourceOrganizationIDTab.delete;
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 ;

Line 1295: x_msg_count := FND_MSG_PUB.Count_Msg;

1291: p_app_short_name => 'PA'
1292: ,p_msg_name =>'PA_UNASSIGNED_PROJ_NO_DEFN');
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: x_msg_data := 'PA_UNASSIGNED_PROJ_NO_DEFN';
1295: x_msg_count := FND_MSG_PUB.Count_Msg;
1296:
1297: END IF;
1298: /* Bug 2458198 -- End */
1299: exception

Line 1306: x_msg_count := FND_MSG_PUB.Count_Msg;

1302: p_app_short_name => 'PA'
1303: ,p_msg_name =>'PA_FORECAST_OPTIONS_NOT_SETUP');
1304: x_return_status := FND_API.G_RET_STS_ERROR;
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:

Line 1318: FND_MSG_PUB.add_exc_msg

1314: x_msg_count := 1;
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;

Line 1329: FND_MSG_PUB.add_exc_msg

1325: x_msg_count := 1;
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:

Line 1413: FND_MSG_PUB.add_exc_msg

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

Line 1494: FND_MSG_PUB.add_exc_msg

1490: x_tp_amount_type_code := NULL ;
1491: x_tp_amount_type_desc := NULL ;
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

Line 1507: FND_MSG_PUB.add_exc_msg

1503: x_tp_amount_type_code := NULL ;
1504: x_tp_amount_type_desc := NULL ;
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

Line 1519: FND_MSG_PUB.add_exc_msg

1515: x_tp_amount_type_code := NULL ;
1516: x_tp_amount_type_desc := NULL ;
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

Line 1595: IF FND_MSG_PUB.Count_Msg > 0 THEN

1591: x_return_status => x_return_status,
1592: x_msg_count => x_msg_count,
1593: x_msg_data => x_msg_data );
1594:
1595: IF FND_MSG_PUB.Count_Msg > 0 THEN
1596: x_return_status := FND_API.G_RET_STS_ERROR;
1597: x_msg_count := FND_MSG_PUB.Count_Msg;
1598: x_msg_data := NULL;
1599: END IF;

Line 1597: x_msg_count := FND_MSG_PUB.Count_Msg;

1593: x_msg_data => x_msg_data );
1594:
1595: IF FND_MSG_PUB.Count_Msg > 0 THEN
1596: x_return_status := FND_API.G_RET_STS_ERROR;
1597: x_msg_count := FND_MSG_PUB.Count_Msg;
1598: x_msg_data := NULL;
1599: END IF;
1600:
1601: EXCEPTION

Line 1617: FND_MSG_PUB.add_exc_msg

1613: -- 4537865 : End
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:

Line 1697: FND_MSG_PUB.add_exc_msg

1693: -- 4537865 : End
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:

Line 1749: FND_MSG_PUB.add_exc_msg

1745: -- 4537865 : End
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: