APPS.AHL_RM_ROUTE_PVT dependencies on AHL_ROUTES_PKG

Line 2518: AHL_ROUTES_PKG.insert_row

2514: --dbms_output.put_line('p_x_route_rec.route_no is '||p_x_route_rec.route_no);
2515: --bachandr Enigma Phase I changes -- end
2516:
2517: -- Insert the record
2518: AHL_ROUTES_PKG.insert_row
2519: (
2520: X_ROWID => l_rowid ,
2521: X_ROUTE_ID => p_x_route_rec.route_id ,
2522: X_OBJECT_VERSION_NUMBER => 1 ,

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

2611: fnd_log.string
2612: (
2613: fnd_log.level_unexpected,
2614: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2615: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'
2616: );
2617: END IF;
2618: END IF;
2619: END;

Line 2628: AHL_ROUTES_PKG.update_row

2624: -- Update the record
2625:
2626: p_x_route_rec.object_version_number := p_x_route_rec.object_version_number + 1;
2627:
2628: AHL_ROUTES_PKG.update_row
2629: (
2630: X_ROUTE_ID => p_x_route_rec.route_id ,
2631: X_OBJECT_VERSION_NUMBER => p_x_route_rec.object_version_number ,
2632: X_ROUTE_NO => p_x_route_rec.route_no ,

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

2716: fnd_log.string
2717: (
2718: fnd_log.level_unexpected,
2719: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2720: 'AHL_ROUTES_PKG.update_row error = ['||SQLERRM||']'
2721: );
2722: END IF;
2723: END IF;
2724: END;

Line 3089: AHL_ROUTES_PKG.delete_row

3085: END IF;
3086:
3087: BEGIN
3088: -- Delete the record in AHL_ROUTES_B and AHL_ROUTES_TL
3089: AHL_ROUTES_PKG.delete_row
3090: (
3091: X_ROUTE_ID => p_route_id
3092: );
3093:

Line 3524: AHL_ROUTES_PKG.insert_row

3520: INTO l_route_id
3521: FROM DUAL;
3522:
3523: -- Insert the record
3524: AHL_ROUTES_PKG.insert_row
3525: (
3526: X_ROWID => l_rowid ,
3527: X_ROUTE_ID => l_route_id ,
3528: X_OBJECT_VERSION_NUMBER => 1 ,

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

3618: fnd_log.string
3619: (
3620: fnd_log.level_unexpected,
3621: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3622: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'
3623: );
3624: END IF;
3625: END IF;
3626: END;