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 788: FND_MSG_PUB.add_exc_msg

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

Line 954: FND_MSG_PUB.add_exc_msg

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

Line 1141: FND_MSG_PUB.add_exc_msg

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

Line 1288: x_msg_count := FND_MSG_PUB.Count_Msg;

1284: p_app_short_name => 'PA'
1285: ,p_msg_name =>'PA_UNASSIGNED_PROJ_NO_DEFN');
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: x_msg_data := 'PA_UNASSIGNED_PROJ_NO_DEFN';
1288: x_msg_count := FND_MSG_PUB.Count_Msg;
1289:
1290: END IF;
1291: /* Bug 2458198 -- End */
1292: exception

Line 1299: x_msg_count := FND_MSG_PUB.Count_Msg;

1295: p_app_short_name => 'PA'
1296: ,p_msg_name =>'PA_FORECAST_OPTIONS_NOT_SETUP');
1297: x_return_status := FND_API.G_RET_STS_ERROR;
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:

Line 1311: FND_MSG_PUB.add_exc_msg

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

Line 1322: FND_MSG_PUB.add_exc_msg

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

Line 1406: FND_MSG_PUB.add_exc_msg

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

Line 1487: FND_MSG_PUB.add_exc_msg

1483: x_tp_amount_type_code := NULL ;
1484: x_tp_amount_type_desc := NULL ;
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

Line 1500: FND_MSG_PUB.add_exc_msg

1496: x_tp_amount_type_code := NULL ;
1497: x_tp_amount_type_desc := NULL ;
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

Line 1512: FND_MSG_PUB.add_exc_msg

1508: x_tp_amount_type_code := NULL ;
1509: x_tp_amount_type_desc := NULL ;
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

Line 1588: IF FND_MSG_PUB.Count_Msg > 0 THEN

1584: x_return_status => x_return_status,
1585: x_msg_count => x_msg_count,
1586: x_msg_data => x_msg_data );
1587:
1588: IF FND_MSG_PUB.Count_Msg > 0 THEN
1589: x_return_status := FND_API.G_RET_STS_ERROR;
1590: x_msg_count := FND_MSG_PUB.Count_Msg;
1591: x_msg_data := NULL;
1592: END IF;

Line 1590: x_msg_count := FND_MSG_PUB.Count_Msg;

1586: x_msg_data => x_msg_data );
1587:
1588: IF FND_MSG_PUB.Count_Msg > 0 THEN
1589: x_return_status := FND_API.G_RET_STS_ERROR;
1590: x_msg_count := FND_MSG_PUB.Count_Msg;
1591: x_msg_data := NULL;
1592: END IF;
1593:
1594: EXCEPTION

Line 1610: FND_MSG_PUB.add_exc_msg

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

Line 1690: FND_MSG_PUB.add_exc_msg

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

Line 1742: FND_MSG_PUB.add_exc_msg

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