DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on INV_RESERVATION_PUB

Line 970: -- This is a wrapper on inv_reservation_pub.query_reservation_om_hdr_line

966:
967: END Get_total_Reserved_quantity ;
968:
969:
970: -- This is a wrapper on inv_reservation_pub.query_reservation_om_hdr_line
971: -- X-dock, added parameter p_delivery_detail_id
972: PROCEDURE query_reservations (
973: p_source_code IN VARCHAR2,
974: p_source_header_id IN NUMBER,

Line 1065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.QUERY_RESERVATION_OM_HDR_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);

1061: --
1062: -- Debug Statements
1063: --
1064: IF l_debug_on THEN
1065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.QUERY_RESERVATION_OM_HDR_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
1066: END IF;
1067: --
1068: INV_RESERVATION_PUB.query_reservation_om_hdr_line
1069: (

Line 1068: INV_RESERVATION_PUB.query_reservation_om_hdr_line

1064: IF l_debug_on THEN
1065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.QUERY_RESERVATION_OM_HDR_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
1066: END IF;
1067: --
1068: INV_RESERVATION_PUB.query_reservation_om_hdr_line
1069: (
1070: p_api_version_number => 1.0
1071: , p_init_msg_lst => fnd_api.g_true
1072: , x_return_status => x_return_status

Line 1140: -- This is a wrapper on inv_reservation_pub.delete_reservation

1136: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:QUERY_RESERVATION_FAILED');
1137: END IF;
1138: END QUERY_RESERVATIONS;
1139:
1140: -- This is a wrapper on inv_reservation_pub.delete_reservation
1141: PROCEDURE delete_reservation (
1142: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1143: x_return_status OUT NOCOPY VARCHAR2)
1144: IS

Line 1171: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);

1167: --
1168: IF l_debug_on THEN
1169: WSH_DEBUG_SV.push(l_module_name);
1170: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.DELETE_RESERVATION ORDER LINE = '|| P_QUERY_INPUT.DEMAND_SOURCE_LINE_ID );
1171: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1172: END IF;
1173:
1174: INV_RESERVATION_PUB.delete_reservation
1175: (

Line 1174: INV_RESERVATION_PUB.delete_reservation

1170: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.DELETE_RESERVATION ORDER LINE = '|| P_QUERY_INPUT.DEMAND_SOURCE_LINE_ID );
1171: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1172: END IF;
1173:
1174: INV_RESERVATION_PUB.delete_reservation
1175: (
1176: p_api_version_number => 1.0
1177: , p_init_msg_lst => fnd_api.g_true
1178: , x_return_status => x_return_status

Line 1252: -- This is a wrapper on inv_reservation_pub.create_reservation

1248: END IF;
1249: --
1250: END delete_reservation;
1251:
1252: -- This is a wrapper on inv_reservation_pub.create_reservation
1253: -- HW OPMCONV Pass Qty2 in order to call the correct INV_create_reservation
1254: PROCEDURE create_reservation (
1255: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1256: p_qty2 IN NUMBER default NULL,

Line 1314: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.CREATE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);

1310: --
1311: -- Debug Statements
1312: --
1313: IF l_debug_on THEN
1314: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.CREATE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1315: END IF;
1316: --
1317:
1318:

Line 1321: INV_RESERVATION_PUB.create_reservation

1317:
1318:
1319: -- HW OPMCONV check if qty2 exists to call the correct API
1320: IF ( p_qty2 is NULL OR p_qty2 = FND_API.G_MISS_NUM ) THEN
1321: INV_RESERVATION_PUB.create_reservation
1322: (
1323: p_api_version_number => 1.0
1324: , p_init_msg_lst => fnd_api.g_true
1325: , x_return_status => x_return_status

Line 1340: INV_RESERVATION_PUB.create_reservation

1336: , x_quantity_reserved => x_qty_reserved
1337: , x_reservation_id => x_reservation_id
1338: );
1339: ELSE
1340: INV_RESERVATION_PUB.create_reservation
1341: (
1342: p_api_version_number => 1.0
1343: , p_init_msg_lst => fnd_api.g_true
1344: , x_return_status => x_return_status

Line 1361: WSH_DEBUG_SV.log(l_module_name,'INV_RESERVATION_PUB.CREATE_RESERVATION',x_return_status);

1357: , x_reservation_id => x_reservation_id
1358: );
1359: END IF;
1360: IF l_debug_on THEN
1361: WSH_DEBUG_SV.log(l_module_name,'INV_RESERVATION_PUB.CREATE_RESERVATION',x_return_status);
1362: END IF;
1363:
1364: IF x_return_status = fnd_api.g_ret_sts_success THEN
1365: --

Line 1424: -- This is a wrapper on inv_reservation_pub.update_reservation

1420: --
1421: END;
1422:
1423:
1424: -- This is a wrapper on inv_reservation_pub.update_reservation
1425: PROCEDURE update_reservation (
1426: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1427: p_new_resv_rec IN inv_reservation_global.mtl_reservation_rec_type,
1428: x_return_status OUT NOCOPY VARCHAR2)

Line 1476: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.UPDATE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);

1472: --
1473: -- Debug Statements
1474: --
1475: IF l_debug_on THEN
1476: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.UPDATE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1477: END IF;
1478: --
1479:
1480:

Line 1481: INV_RESERVATION_PUB.update_reservation

1477: END IF;
1478: --
1479:
1480:
1481: INV_RESERVATION_PUB.update_reservation
1482: (
1483: p_api_version_number => 1.0
1484: , p_init_msg_lst => fnd_api.g_true
1485: , x_return_status => x_return_status

Line 1497: WSH_DEBUG_SV.log(l_module_name,'INV_RESERVATION_PUB.update_reservation',x_return_status);

1493: -- Bug 5099694
1494: , p_over_reservation_flag =>3
1495: );
1496: IF l_debug_on THEN
1497: WSH_DEBUG_SV.log(l_module_name,'INV_RESERVATION_PUB.update_reservation',x_return_status);
1498: END IF;
1499:
1500: IF x_return_status = fnd_api.g_ret_sts_success THEN
1501: --

Line 2559: -- This is a private procedure which wraps inv_reservation_pub.update_reservation

2555: END IF;
2556: --
2557: END cancel_nonstaged_reservation;
2558:
2559: -- This is a private procedure which wraps inv_reservation_pub.update_reservation
2560: -- or inv_reservation_pub.transfer_reservation as required
2561: -- COMMENT : p_rsv.demand_source_line_detail is required for X-dock lines
2562: -- Functionality added in R12
2563: PROCEDURE Reservation_split_action (

Line 2560: -- or inv_reservation_pub.transfer_reservation as required

2556: --
2557: END cancel_nonstaged_reservation;
2558:
2559: -- This is a private procedure which wraps inv_reservation_pub.update_reservation
2560: -- or inv_reservation_pub.transfer_reservation as required
2561: -- COMMENT : p_rsv.demand_source_line_detail is required for X-dock lines
2562: -- Functionality added in R12
2563: PROCEDURE Reservation_split_action (
2564: p_rsv IN inv_reservation_global.mtl_reservation_rec_type,

Line 2750: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.TRANSFER_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);

2746: --
2747: IF l_rsv_new.primary_reservation_quantity IS NOT NULL THEN --{
2748: --
2749: IF l_debug_on THEN
2750: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.TRANSFER_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
2751: WSH_DEBUG_SV.log(l_module_name,'l_rsv_new.primary_reservation_quantity',
2752: l_rsv_new.primary_reservation_quantity);
2753: WSH_DEBUG_SV.log(l_module_name,'l_rsv_new.secondary_reservation_quantity',
2754: l_rsv_new.secondary_reservation_quantity);

Line 2758: INV_RESERVATION_PUB.transfer_reservation

2754: l_rsv_new.secondary_reservation_quantity);
2755: END IF;
2756: --
2757:
2758: INV_RESERVATION_PUB.transfer_reservation
2759: (p_api_version_number => 1.0,
2760: p_init_msg_lst => fnd_api.g_true,
2761: x_return_status => l_status,
2762: x_msg_count => l_msg_count,