DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on INV_RESERVATION_PUB

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

979:
980: END Get_total_Reserved_quantity ;
981:
982:
983: -- This is a wrapper on inv_reservation_pub.query_reservation_om_hdr_line
984: -- X-dock, added parameter p_delivery_detail_id
985: PROCEDURE query_reservations (
986: p_source_code IN VARCHAR2,
987: p_source_header_id IN NUMBER,

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

1074: --
1075: -- Debug Statements
1076: --
1077: IF l_debug_on THEN
1078: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.QUERY_RESERVATION_OM_HDR_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
1079: END IF;
1080: --
1081: INV_RESERVATION_PUB.query_reservation_om_hdr_line
1082: (

Line 1081: INV_RESERVATION_PUB.query_reservation_om_hdr_line

1077: IF l_debug_on THEN
1078: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.QUERY_RESERVATION_OM_HDR_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
1079: END IF;
1080: --
1081: INV_RESERVATION_PUB.query_reservation_om_hdr_line
1082: (
1083: p_api_version_number => 1.0
1084: , p_init_msg_lst => fnd_api.g_true
1085: , x_return_status => x_return_status

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

1149: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:QUERY_RESERVATION_FAILED');
1150: END IF;
1151: END QUERY_RESERVATIONS;
1152:
1153: -- This is a wrapper on inv_reservation_pub.delete_reservation
1154: PROCEDURE delete_reservation (
1155: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1156: x_return_status OUT NOCOPY VARCHAR2)
1157: IS

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

1180: --
1181: IF l_debug_on THEN
1182: WSH_DEBUG_SV.push(l_module_name);
1183: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.DELETE_RESERVATION ORDER LINE = '|| P_QUERY_INPUT.DEMAND_SOURCE_LINE_ID );
1184: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1185: END IF;
1186:
1187: INV_RESERVATION_PUB.delete_reservation
1188: (

Line 1187: INV_RESERVATION_PUB.delete_reservation

1183: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.DELETE_RESERVATION ORDER LINE = '|| P_QUERY_INPUT.DEMAND_SOURCE_LINE_ID );
1184: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1185: END IF;
1186:
1187: INV_RESERVATION_PUB.delete_reservation
1188: (
1189: p_api_version_number => 1.0
1190: , p_init_msg_lst => fnd_api.g_true
1191: , x_return_status => x_return_status

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

1261: END IF;
1262: --
1263: END delete_reservation;
1264:
1265: -- This is a wrapper on inv_reservation_pub.create_reservation
1266: -- HW OPMCONV Pass Qty2 in order to call the correct INV_create_reservation
1267: PROCEDURE create_reservation (
1268: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1269: p_qty2 IN NUMBER default NULL,

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

1323: --
1324: -- Debug Statements
1325: --
1326: IF l_debug_on THEN
1327: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.CREATE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1328: END IF;
1329: --
1330:
1331:

Line 1334: INV_RESERVATION_PUB.create_reservation

1330:
1331:
1332: -- HW OPMCONV check if qty2 exists to call the correct API
1333: IF ( p_qty2 is NULL OR p_qty2 = FND_API.G_MISS_NUM ) THEN
1334: INV_RESERVATION_PUB.create_reservation
1335: (
1336: p_api_version_number => 1.0
1337: , p_init_msg_lst => fnd_api.g_true
1338: , x_return_status => x_return_status

Line 1353: INV_RESERVATION_PUB.create_reservation

1349: , x_quantity_reserved => x_qty_reserved
1350: , x_reservation_id => x_reservation_id
1351: );
1352: ELSE
1353: INV_RESERVATION_PUB.create_reservation
1354: (
1355: p_api_version_number => 1.0
1356: , p_init_msg_lst => fnd_api.g_true
1357: , x_return_status => x_return_status

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

1370: , x_reservation_id => x_reservation_id
1371: );
1372: END IF;
1373: IF l_debug_on THEN
1374: WSH_DEBUG_SV.log(l_module_name,'INV_RESERVATION_PUB.CREATE_RESERVATION',x_return_status);
1375: END IF;
1376:
1377: IF x_return_status = fnd_api.g_ret_sts_success THEN
1378: --

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

1433: --
1434: END;
1435:
1436:
1437: -- This is a wrapper on inv_reservation_pub.update_reservation
1438: PROCEDURE update_reservation (
1439: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1440: p_new_resv_rec IN inv_reservation_global.mtl_reservation_rec_type,
1441: x_return_status OUT NOCOPY VARCHAR2)

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

1485: --
1486: -- Debug Statements
1487: --
1488: IF l_debug_on THEN
1489: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.UPDATE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1490: END IF;
1491: --
1492:
1493:

Line 1494: INV_RESERVATION_PUB.update_reservation

1490: END IF;
1491: --
1492:
1493:
1494: INV_RESERVATION_PUB.update_reservation
1495: (
1496: p_api_version_number => 1.0
1497: , p_init_msg_lst => fnd_api.g_true
1498: , x_return_status => x_return_status

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

1506: -- Bug 5099694
1507: , p_over_reservation_flag =>3
1508: );
1509: IF l_debug_on THEN
1510: WSH_DEBUG_SV.log(l_module_name,'INV_RESERVATION_PUB.update_reservation',x_return_status);
1511: END IF;
1512:
1513: IF x_return_status = fnd_api.g_ret_sts_success THEN
1514: --

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

2715: --
2716: END cancel_nonstaged_reservation;
2717: -- bug # 9410461: Added to new out parameter x_new_rsv_id to return reservation id of the new reservation
2718: -- record created.
2719: -- This is a private procedure which wraps inv_reservation_pub.update_reservation
2720: -- or inv_reservation_pub.transfer_reservation as required
2721: -- COMMENT : p_rsv.demand_source_line_detail is required for X-dock lines
2722: -- Functionality added in R12
2723: -- Added parameter p_shipped_flag for bug 10105817

Line 2720: -- or inv_reservation_pub.transfer_reservation as required

2716: END cancel_nonstaged_reservation;
2717: -- bug # 9410461: Added to new out parameter x_new_rsv_id to return reservation id of the new reservation
2718: -- record created.
2719: -- This is a private procedure which wraps inv_reservation_pub.update_reservation
2720: -- or inv_reservation_pub.transfer_reservation as required
2721: -- COMMENT : p_rsv.demand_source_line_detail is required for X-dock lines
2722: -- Functionality added in R12
2723: -- Added parameter p_shipped_flag for bug 10105817
2724: PROCEDURE Reservation_split_action (

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

3011: --
3012: IF l_rsv_new.primary_reservation_quantity IS NOT NULL THEN --{
3013: --
3014: IF l_debug_on THEN
3015: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.TRANSFER_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
3016: WSH_DEBUG_SV.log(l_module_name,'l_rsv_new.primary_reservation_quantity',
3017: l_rsv_new.primary_reservation_quantity);
3018: WSH_DEBUG_SV.log(l_module_name,'l_rsv_new.secondary_reservation_quantity',
3019: l_rsv_new.secondary_reservation_quantity);

Line 3030: INV_RESERVATION_PUB.transfer_reservation

3026: ELSE
3027: l_validation_flag := 'Y';
3028: END IF;
3029:
3030: INV_RESERVATION_PUB.transfer_reservation
3031: (p_api_version_number => 1.0,
3032: p_init_msg_lst => fnd_api.g_true,
3033: x_return_status => l_status,
3034: x_msg_count => l_msg_count,