DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_PUB dependencies on AHL_RM_ROUTE_UTIL

Line 522: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

518: -- If Id is null derive Route id from Route Number and revision
519:
520: l_route_id := p_route_rec.route_id;
521: IF l_route_id IS NULL THEN
522: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
523: (
524: p_route_number => p_route_rec.route_no,
525: p_route_revision => p_route_rec.revision_number,
526: x_route_id => l_route_id ,

Line 535: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'

531: fnd_log.string
532: (
533: fnd_log.level_error,
534: l_debug_module ,
535: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'
536: );
537: END IF;
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;

Line 948: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

944: l_route_id := p_route_id;
945:
946: -- If Id is null derive Route id from Route Number and revision
947: IF l_route_id IS NULL THEN
948: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
949: (
950: p_route_number => p_route_number,
951: p_route_revision => p_route_revision,
952: x_route_id => l_route_id,

Line 961: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'

957: fnd_log.string
958: (
959: fnd_log.level_error,
960: l_debug_module ,
961: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'
962: );
963: END IF;
964: RAISE FND_API.G_EXC_ERROR;
965: END IF;

Line 1144: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

1140: l_route_id = FND_API.G_MISS_NUM )
1141: THEN
1142:
1143: -- Function to convert Operation number, operation revision to id
1144: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
1145: (
1146: p_route_number => p_route_number,
1147: p_route_revision => p_route_revision,
1148: x_route_id => l_route_id,

Line 1364: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

1360: IF ( p_route_id IS NULL OR
1361: p_route_id = FND_API.G_MISS_NUM )
1362: THEN
1363: -- Function to convert Operation number, operation revision to id
1364: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
1365: (
1366: p_route_number => p_route_number,
1367: p_route_revision => p_route_revision,
1368: x_route_id => l_route_id,

Line 1377: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'

1373: fnd_log.string
1374: (
1375: fnd_log.level_error,
1376: l_debug_module ,
1377: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1378: );
1379: END IF;
1380: RAISE FND_API.G_EXC_ERROR;
1381: END IF;

Line 1546: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

1542: IF ( p_route_id IS NULL OR
1543: p_route_id = FND_API.G_MISS_NUM )
1544: THEN
1545: -- Function to convert Operation number, operation revision to id
1546: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
1547: (
1548: p_route_number => p_route_number,
1549: p_route_revision => p_route_revision,
1550: x_route_id => l_source_route_id,

Line 1559: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'

1555: fnd_log.string
1556: (
1557: fnd_log.level_error,
1558: l_debug_module ,
1559: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1560: );
1561: END IF;
1562: RAISE FND_API.G_EXC_ERROR;
1563: END IF;

Line 1724: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

1720: IF ( l_route_id IS NULL OR
1721: l_route_id = FND_API.G_MISS_NUM )
1722: THEN
1723: -- Function to convert Route number, Route revision to id
1724: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
1725: (
1726: p_route_number => p_route_number,
1727: p_route_revision => p_route_revision,
1728: x_route_id => l_route_id,

Line 1737: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'

1733: fnd_log.string
1734: (
1735: fnd_log.level_error,
1736: l_debug_module ,
1737: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1738: );
1739: END IF;
1740: RAISE FND_API.G_EXC_ERROR;
1741: END IF;

Line 1932: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

1928: -- If Id is null derive Route id from Route Number and revision
1929: IF l_route_id IS NULL THEN
1930:
1931: -- Function to convert Route number, Route revision to id
1932: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
1933: (
1934: p_route_number => p_route_number,
1935: p_route_revision => p_route_revision,
1936: x_route_id => l_route_id,

Line 1946: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'

1942: fnd_log.string
1943: (
1944: fnd_log.level_error,
1945: l_debug_module ||':',
1946: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'
1947: );
1948: END IF;
1949: RAISE FND_API.G_EXC_ERROR;
1950: END IF;