APPS.AHL_RM_ROUTE_PVT dependencies on AHL_ROUTES_PKG

Line 2218: AHL_ROUTES_PKG.insert_row

2214: --dbms_output.put_line('p_x_route_rec.route_no is '||p_x_route_rec.route_no);
2215: --bachandr Enigma Phase I changes -- end
2216:
2217: -- Insert the record
2218: AHL_ROUTES_PKG.insert_row
2219: (
2220: X_ROWID => l_rowid ,
2221: X_ROUTE_ID => p_x_route_rec.route_id ,
2222: X_OBJECT_VERSION_NUMBER => 1 ,

Line 2306: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'

2302: fnd_log.string
2303: (
2304: fnd_log.level_unexpected,
2305: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2306: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'
2307: );
2308: END IF;
2309: END IF;
2310: END;

Line 2319: AHL_ROUTES_PKG.update_row

2315: -- Update the record
2316:
2317: p_x_route_rec.object_version_number := p_x_route_rec.object_version_number + 1;
2318:
2319: AHL_ROUTES_PKG.update_row
2320: (
2321: X_ROUTE_ID => p_x_route_rec.route_id ,
2322: X_OBJECT_VERSION_NUMBER => p_x_route_rec.object_version_number ,
2323: X_ROUTE_NO => p_x_route_rec.route_no ,

Line 2401: 'AHL_ROUTES_PKG.update_row error = ['||SQLERRM||']'

2397: fnd_log.string
2398: (
2399: fnd_log.level_unexpected,
2400: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2401: 'AHL_ROUTES_PKG.update_row error = ['||SQLERRM||']'
2402: );
2403: END IF;
2404: END IF;
2405: END;

Line 2758: AHL_ROUTES_PKG.delete_row

2754: END IF;
2755:
2756: BEGIN
2757: -- Delete the record in AHL_ROUTES_B and AHL_ROUTES_TL
2758: AHL_ROUTES_PKG.delete_row
2759: (
2760: X_ROUTE_ID => p_route_id
2761: );
2762:

Line 3116: AHL_ROUTES_PKG.insert_row

3112: INTO l_route_id
3113: FROM DUAL;
3114:
3115: -- Insert the record
3116: AHL_ROUTES_PKG.insert_row
3117: (
3118: X_ROWID => l_rowid ,
3119: X_ROUTE_ID => l_route_id ,
3120: X_OBJECT_VERSION_NUMBER => 1 ,

Line 3205: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'

3201: fnd_log.string
3202: (
3203: fnd_log.level_unexpected,
3204: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3205: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'
3206: );
3207: END IF;
3208: END IF;
3209: END;