DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_PUB dependencies on AHL_RM_ROUTE_UTIL

Line 604: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

600: -- If Id is null derive Route id from Route Number and revision
601:
602: l_route_id := p_route_rec.route_id;
603: IF l_route_id IS NULL THEN
604: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
605: (
606: p_route_number => p_route_rec.route_no,
607: p_route_revision => p_route_rec.revision_number,
608: x_route_id => l_route_id ,

Line 617: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'

613: fnd_log.string
614: (
615: fnd_log.level_error,
616: l_debug_module ,
617: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'
618: );
619: END IF;
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;

Line 1121: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

1117: l_route_id := p_route_id;
1118:
1119: -- If Id is null derive Route id from Route Number and revision
1120: IF l_route_id IS NULL THEN
1121: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
1122: (
1123: p_route_number => p_route_number,
1124: p_route_revision => p_route_revision,
1125: x_route_id => l_route_id,

Line 1134: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'

1130: fnd_log.string
1131: (
1132: fnd_log.level_error,
1133: l_debug_module ,
1134: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'
1135: );
1136: END IF;
1137: RAISE FND_API.G_EXC_ERROR;
1138: END IF;

Line 1317: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

1313: l_route_id = FND_API.G_MISS_NUM )
1314: THEN
1315:
1316: -- Function to convert Operation number, operation revision to id
1317: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
1318: (
1319: p_route_number => p_route_number,
1320: p_route_revision => p_route_revision,
1321: x_route_id => l_route_id,

Line 1549: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

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

Line 1562: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'

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

Line 1731: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

1727: IF ( p_route_id IS NULL OR
1728: p_route_id = FND_API.G_MISS_NUM )
1729: THEN
1730: -- Function to convert Operation number, operation revision to id
1731: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
1732: (
1733: p_route_number => p_route_number,
1734: p_route_revision => p_route_revision,
1735: x_route_id => l_source_route_id,

Line 1744: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'

1740: fnd_log.string
1741: (
1742: fnd_log.level_error,
1743: l_debug_module ,
1744: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1745: );
1746: END IF;
1747: RAISE FND_API.G_EXC_ERROR;
1748: END IF;

Line 1909: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

1905: IF ( l_route_id IS NULL OR
1906: l_route_id = FND_API.G_MISS_NUM )
1907: THEN
1908: -- Function to convert Route number, Route revision to id
1909: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
1910: (
1911: p_route_number => p_route_number,
1912: p_route_revision => p_route_revision,
1913: x_route_id => l_route_id,

Line 1922: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'

1918: fnd_log.string
1919: (
1920: fnd_log.level_error,
1921: l_debug_module ,
1922: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1923: );
1924: END IF;
1925: RAISE FND_API.G_EXC_ERROR;
1926: END IF;

Line 2117: AHL_RM_ROUTE_UTIL.Route_Number_To_Id

2113: -- If Id is null derive Route id from Route Number and revision
2114: IF l_route_id IS NULL THEN
2115:
2116: -- Function to convert Route number, Route revision to id
2117: AHL_RM_ROUTE_UTIL.Route_Number_To_Id
2118: (
2119: p_route_number => p_route_number,
2120: p_route_revision => p_route_revision,
2121: x_route_id => l_route_id,

Line 2131: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'

2127: fnd_log.string
2128: (
2129: fnd_log.level_error,
2130: l_debug_module ||':',
2131: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'
2132: );
2133: END IF;
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;