eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_USA_INV_PVT dependencies on FND_API

Line 537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');
534: END IF;
535:
536: WHEN e_return THEN
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');
539: -- OTM R12 : unassign delivery detail
540: IF (c_detail_cont_planning_cur%ISOPEN) THEN
541: CLOSE c_detail_cont_planning_cur;

Line 550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UNASSIGN_BACKORDERED_DETAILS');
547: END IF;
548:
549: WHEN OTHERS THEN
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
551: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');
552: -- OTM R12 : unassign delivery detail
553: IF (c_detail_cont_planning_cur%ISOPEN) THEN
554: CLOSE c_detail_cont_planning_cur;

Line 850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

846:
847: EXCEPTION
848:
849: WHEN OTHERS THEN
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.backorder_delivery_detail');
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.logmsg(l_module_name,'BACKORDER_DELIVERY_DETAIL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
854: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:BACKORDER_DELIVERY_DETAIL');

Line 912: p_lock_records => fnd_api.g_true,

908: p_source_code => p_source_code,
909: p_source_header_id => p_source_header_id,
910: p_source_line_id => p_source_line_id,
911: p_organization_id => p_organization_id,
912: p_lock_records => fnd_api.g_true,
913: p_delivery_detail_id => null, --X-dock
914: x_mtl_reservation_tbl => l_rsv_array,
915: x_mtl_reservation_tbl_count => l_size,
916: x_return_status => l_return_status);

Line 918: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

914: x_mtl_reservation_tbl => l_rsv_array,
915: x_mtl_reservation_tbl_count => l_size,
916: x_return_status => l_return_status);
917:
918: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
919: raise totals_failed;
920: END IF;
921:
922: IF l_size = 0 THEN -- This case is specific for non staged reservations as

Line 960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

956: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GET_TOTAL_RESERVED_QUANTITY');
957: END IF;
958:
959: WHEN OTHERS THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.Get_total_Reserved_quantity');
962: IF l_debug_on THEN
963: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
964: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1071: , p_init_msg_lst => fnd_api.g_true

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
1073: , x_msg_count => l_msg_count
1074: , x_msg_data => l_msg_data
1075: , p_query_input => l_rsv

Line 1087: IF x_return_status = fnd_api.g_ret_sts_success THEN

1083: WSH_DEBUG_SV.log(l_module_name,'query_reservation_om_hdr_line x_return_status',x_return_status);
1084: END IF;
1085:
1086:
1087: IF x_return_status = fnd_api.g_ret_sts_success THEN
1088: --
1089: -- Debug Statements
1090: --
1091: IF l_debug_on THEN

Line 1177: , p_init_msg_lst => fnd_api.g_true

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
1179: , x_msg_count => l_msg_count
1180: , x_msg_data => l_msg_data
1181: , p_rsv_rec => p_query_input

Line 1188: IF x_return_status = fnd_api.g_ret_sts_success THEN

1184: IF l_debug_on THEN
1185: WSH_DEBUG_SV.log(l_module_name,'delete_reservation x_return_status',x_return_status);
1186: END IF;
1187:
1188: IF x_return_status = fnd_api.g_ret_sts_success THEN
1189: --
1190: -- Debug Statements
1191: --
1192: IF l_debug_on THEN

Line 1320: IF ( p_qty2 is NULL OR p_qty2 = FND_API.G_MISS_NUM ) THEN

1316: --
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

Line 1324: , p_init_msg_lst => fnd_api.g_true

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
1326: , x_msg_count => l_msg_count
1327: , x_msg_data => l_msg_data
1328: , p_rsv_rec => p_query_input

Line 1331: , p_partial_reservation_flag => fnd_api.g_true

1327: , x_msg_data => l_msg_data
1328: , p_rsv_rec => p_query_input
1329: , p_serial_number => l_dummy_sn
1330: , x_serial_number => l_dummy_sn
1331: , p_partial_reservation_flag => fnd_api.g_true
1332: , p_force_reservation_flag => fnd_api.g_false
1333: , p_validation_flag => fnd_api.g_true
1334: -- bug 5333667: remove p_over_reservation_flag added by bug 5099694
1335: -- because it is necessary to validate the new reservation.

Line 1332: , p_force_reservation_flag => fnd_api.g_false

1328: , p_rsv_rec => p_query_input
1329: , p_serial_number => l_dummy_sn
1330: , x_serial_number => l_dummy_sn
1331: , p_partial_reservation_flag => fnd_api.g_true
1332: , p_force_reservation_flag => fnd_api.g_false
1333: , p_validation_flag => fnd_api.g_true
1334: -- bug 5333667: remove p_over_reservation_flag added by bug 5099694
1335: -- because it is necessary to validate the new reservation.
1336: , x_quantity_reserved => x_qty_reserved

Line 1333: , p_validation_flag => fnd_api.g_true

1329: , p_serial_number => l_dummy_sn
1330: , x_serial_number => l_dummy_sn
1331: , p_partial_reservation_flag => fnd_api.g_true
1332: , p_force_reservation_flag => fnd_api.g_false
1333: , p_validation_flag => fnd_api.g_true
1334: -- bug 5333667: remove p_over_reservation_flag added by bug 5099694
1335: -- because it is necessary to validate the new reservation.
1336: , x_quantity_reserved => x_qty_reserved
1337: , x_reservation_id => x_reservation_id

Line 1343: , p_init_msg_lst => fnd_api.g_true

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
1345: , x_msg_count => l_msg_count
1346: , x_msg_data => l_msg_data
1347: , p_rsv_rec => p_query_input

Line 1350: , p_partial_reservation_flag => fnd_api.g_true

1346: , x_msg_data => l_msg_data
1347: , p_rsv_rec => p_query_input
1348: , p_serial_number => l_dummy_sn
1349: , x_serial_number => l_dummy_sn
1350: , p_partial_reservation_flag => fnd_api.g_true
1351: , p_force_reservation_flag => fnd_api.g_false
1352: -- Bug 5099694
1353: , p_over_reservation_flag =>3
1354: , p_validation_flag => fnd_api.g_true

Line 1351: , p_force_reservation_flag => fnd_api.g_false

1347: , p_rsv_rec => p_query_input
1348: , p_serial_number => l_dummy_sn
1349: , x_serial_number => l_dummy_sn
1350: , p_partial_reservation_flag => fnd_api.g_true
1351: , p_force_reservation_flag => fnd_api.g_false
1352: -- Bug 5099694
1353: , p_over_reservation_flag =>3
1354: , p_validation_flag => fnd_api.g_true
1355: , x_quantity_reserved => x_qty_reserved

Line 1354: , p_validation_flag => fnd_api.g_true

1350: , p_partial_reservation_flag => fnd_api.g_true
1351: , p_force_reservation_flag => fnd_api.g_false
1352: -- Bug 5099694
1353: , p_over_reservation_flag =>3
1354: , p_validation_flag => fnd_api.g_true
1355: , x_quantity_reserved => x_qty_reserved
1356: , x_secondary_quantity_reserved => x_secondary_qty_reserved
1357: , x_reservation_id => x_reservation_id
1358: );

Line 1364: IF x_return_status = fnd_api.g_ret_sts_success THEN

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: --
1366: -- Debug Statements
1367: --
1368: IF l_debug_on THEN

Line 1484: , p_init_msg_lst => fnd_api.g_true

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
1486: , x_msg_count => l_msg_count
1487: , x_msg_data => l_msg_data
1488: , p_original_rsv_rec => p_query_input

Line 1492: , p_validation_flag => fnd_api.g_true

1488: , p_original_rsv_rec => p_query_input
1489: , p_to_rsv_rec => p_new_resv_rec
1490: , p_original_serial_number => l_dummy_sn -- no serial contorl
1491: , p_to_serial_number => l_dummy_sn -- no serial control
1492: , p_validation_flag => fnd_api.g_true
1493: -- Bug 5099694
1494: , p_over_reservation_flag =>3
1495: );
1496: IF l_debug_on THEN

Line 1500: IF x_return_status = fnd_api.g_ret_sts_success THEN

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: --
1502: -- Debug Statements
1503: --
1504: IF l_debug_on THEN

Line 1858: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1854: p_move_order_line_id => p_delivery_detail_split_rec.move_order_line_id,
1855: x_detail_id => l_delivery_detail_id,
1856: x_return_status => x_return_status);
1857:
1858: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1859: raise cancel_failed;
1860: END IF;
1861: --end of X-dock
1862:

Line 1870: p_lock_records => fnd_api.g_true,

1866: p_source_code => p_source_code,
1867: p_source_header_id => p_source_header_id,
1868: p_source_line_id => p_source_line_id,
1869: p_organization_id => p_delivery_detail_split_rec.organization_id,
1870: p_lock_records => fnd_api.g_true,
1871: p_delivery_detail_id => l_delivery_detail_id, --X-dock changes
1872: x_mtl_reservation_tbl => l_rsv_array,
1873: x_mtl_reservation_tbl_count => l_size,
1874: x_return_status => x_return_status);

Line 1885: IF (x_return_status <> fnd_api.g_ret_sts_success) OR (l_size = 0) THEN

1881: WSH_DEBUG_SV.log(l_module_name, 'query_reservations x_return_status',x_return_status);
1882: WSH_DEBUG_SV.logmsg(l_module_name, 'L_SIZE: '||L_SIZE );
1883: END IF;
1884:
1885: IF (x_return_status <> fnd_api.g_ret_sts_success) OR (l_size = 0) THEN
1886: IF x_return_status = fnd_api.g_ret_sts_success THEN
1887: OPEN pickable_flag(p_delivery_detail_split_rec.delivery_detail_id);
1888: FETCH pickable_flag INTO l_pickable_flag;
1889: CLOSE pickable_flag;

Line 1886: IF x_return_status = fnd_api.g_ret_sts_success THEN

1882: WSH_DEBUG_SV.logmsg(l_module_name, 'L_SIZE: '||L_SIZE );
1883: END IF;
1884:
1885: IF (x_return_status <> fnd_api.g_ret_sts_success) OR (l_size = 0) THEN
1886: IF x_return_status = fnd_api.g_ret_sts_success THEN
1887: OPEN pickable_flag(p_delivery_detail_split_rec.delivery_detail_id);
1888: FETCH pickable_flag INTO l_pickable_flag;
1889: CLOSE pickable_flag;
1890: --

Line 1963: IF l_rsv_array(l_counter).secondary_reservation_quantity = FND_API.G_MISS_NUM THEN

1959: END IF;
1960: --
1961:
1962: -- HW OPMCONV - Update qty2 using new reservation flds
1963: IF l_rsv_array(l_counter).secondary_reservation_quantity = FND_API.G_MISS_NUM THEN
1964: l_rsv_array(l_counter).secondary_reservation_quantity := null;
1965: END IF;
1966:
1967: -- Bug3012297 (Included reference to parameters)

Line 1990: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1986: IF l_debug_on THEN
1987: WSH_DEBUG_SV.log(l_module_name, 'delete_reservation x_return_status',x_return_status);
1988: END IF;
1989:
1990: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1991: raise cancel_failed;
1992: END IF;
1993:
1994: l_cancelled_reservation_qty := l_rsv_array(l_counter).primary_reservation_quantity;

Line 2014: l_rsv_new.secondary_reservation_quantity = FND_API.G_MISS_NUM ) THEN

2010: END IF;
2011: --
2012: -- HW OPMCONV - Ensure Qty2 are NULL before updating
2013: IF ( l_rsv_new.secondary_reservation_quantity = 0 OR
2014: l_rsv_new.secondary_reservation_quantity = FND_API.G_MISS_NUM ) THEN
2015: l_rsv_new.secondary_reservation_quantity := NULL;
2016: END IF;
2017:
2018: update_reservation (p_query_input => l_rsv_array(l_counter),

Line 2025: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2021: IF l_debug_on THEN
2022: WSH_DEBUG_SV.log(l_module_name, 'update_reservation x_return_status',x_return_status);
2023: END IF;
2024:
2025: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2026: raise cancel_failed;
2027: END IF;
2028:
2029: EXIT;

Line 2170: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2166: p_move_order_line_id => null,
2167: x_detail_id => l_delivery_detail_id,
2168: x_return_status => x_return_status);
2169:
2170: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2171: raise cancel_failed;
2172: END IF;
2173: --end of X-dock
2174:

Line 2184: p_lock_records => fnd_api.g_true,

2180: p_source_header_id => p_source_header_id,
2181: p_source_line_id => p_source_line_id,
2182: p_organization_id => p_organization_id,
2183: p_delivery_detail_id => l_delivery_detail_id, -- X-dock changes
2184: p_lock_records => fnd_api.g_true,
2185: x_mtl_reservation_tbl => l_rsv_array,
2186: x_mtl_reservation_tbl_count => l_size,
2187: x_return_status => x_return_status);
2188:

Line 2194: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

2190: IF l_debug_on THEN
2191: WSH_DEBUG_SV.log(l_module_name,'query_reservations x_return_status',x_return_status);
2192: END IF;
2193:
2194: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2195: raise cancel_failed;
2196: END IF;
2197:
2198: IF l_size = 0 THEN -- This case is specific for non staged reservations as

Line 2295: IF l_rsv_array(l_counter).secondary_reservation_quantity = FND_API.G_MISS_NUM

2291: --End Bug3012297
2292:
2293: -- HW OPMCONV - Update correct Qty2 using new reservation flds.
2294:
2295: IF l_rsv_array(l_counter).secondary_reservation_quantity = FND_API.G_MISS_NUM
2296: OR l_rsv_array(l_counter).secondary_reservation_quantity = 0 THEN
2297: l_rsv_array(l_counter).secondary_reservation_quantity := null;
2298: END IF;
2299:

Line 2365: IF l_rsv_array(l_counter).secondary_reservation_quantity = FND_API.G_MISS_NUM THEN

2361: --
2362:
2363: -- HW OPMCONV -Update Qty2 using new reservation flds.
2364:
2365: IF l_rsv_array(l_counter).secondary_reservation_quantity = FND_API.G_MISS_NUM THEN
2366: l_rsv_array(l_counter).secondary_reservation_quantity := null;
2367: END IF;
2368:
2369: -- Bug3012297

Line 2404: l_rsv_new.secondary_reservation_quantity = FND_API.G_MISS_NUM ) THEN

2400:
2401: -- HW OPMCONV - Ensure Qty2 are NULL before updating
2402:
2403: IF ( l_rsv_new.secondary_reservation_quantity = 0 OR
2404: l_rsv_new.secondary_reservation_quantity = FND_API.G_MISS_NUM ) THEN
2405: l_rsv_new.secondary_reservation_quantity := NULL;
2406: END IF;
2407:
2408: IF l_debug_on THEN

Line 2423: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2419:
2420: IF l_debug_on THEN
2421: WSH_DEBUG_SV.log(l_module_name,'update_reservation x_return_status',x_return_status);
2422: END IF;
2423: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2424: raise cancel_failed;
2425: END IF;
2426:
2427: ELSE

Line 2442: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2438: IF l_debug_on THEN
2439: WSH_DEBUG_SV.log(l_module_name,'delete_reservation x_return_status',x_return_status);
2440: END IF;
2441:
2442: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2443: raise cancel_failed;
2444: END IF;
2445:
2446: END IF;

Line 2466: IF l_rsv_array(l_counter).secondary_uom_code <> FND_API.G_MISS_CHAR THEN

2462: -- =====================
2463: -- Ensure cancellation_quantity2 is computed in accordance with any
2464: -- lot specific calculation in play for the reservation line
2465: -- otherwise we may be mixing item level and lot specific level calculations
2466: IF l_rsv_array(l_counter).secondary_uom_code <> FND_API.G_MISS_CHAR THEN
2467: -- For dual tracked items compute the secondary cancellation qty in
2468: -- accordance with any lot specific calculation in play
2469: l_cancellation_quantity2 := WSH_WV_UTILS.convert_uom(
2470: item_id => l_rsv_array(l_counter).inventory_item_id

Line 2503: l_rsv_new.secondary_reservation_quantity = FND_API.G_MISS_NUM ) THEN

2499:
2500:
2501: -- HW OPMCONV - Ensure Qty2 are NULL before updating
2502: IF ( l_rsv_new.secondary_reservation_quantity = 0 OR
2503: l_rsv_new.secondary_reservation_quantity = FND_API.G_MISS_NUM ) THEN
2504: l_rsv_new.secondary_reservation_quantity := NULL;
2505: END IF;
2506:
2507: update_reservation (

Line 2515: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2511: IF l_debug_on THEN
2512: WSH_DEBUG_SV.log(l_module_name,'update_reservation x_return_status',x_return_status);
2513: END IF;
2514:
2515: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2516: raise cancel_failed;
2517: END IF;
2518:
2519: EXIT;

Line 2598: l_status := FND_API.G_RET_STS_SUCCESS;

2594: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PACKAGE_NAME || '.' || 'RESERVATION_SPLIT_ACTION';
2595: --
2596: BEGIN
2597: --
2598: l_status := FND_API.G_RET_STS_SUCCESS;
2599: --
2600: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2601: --
2602: IF l_debug_on IS NULL THEN

Line 2659: IF p_rsv.secondary_uom_code <> FND_API.G_MISS_CHAR THEN

2655: -- This calculation is mixing item level UOM conversions (p_split_quantity2) with
2656: -- lot specific conversions (secondary_reservation_quantity).
2657: -- The wisest course of action is to compute the secondary based on the
2658: -- lot information available to us from the originating lot.
2659: IF p_rsv.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
2660: IF l_debug_on THEN
2661: WSH_DEBUG_SV.log(l_module_name,'DUAL tracked item so convert for lot ',p_rsv.lot_number);
2662: END IF;
2663: l_quantity2_to_split := WSH_WV_UTILS.convert_uom(

Line 2760: p_init_msg_lst => fnd_api.g_true,

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,
2763: x_msg_data => l_msg_data,
2764: p_original_rsv_rec => p_rsv,

Line 2768: p_validation_flag => fnd_api.g_true,

2764: p_original_rsv_rec => p_rsv,
2765: p_to_rsv_rec => l_rsv_new,
2766: p_original_serial_number => l_dummy_sn, -- no serial contorl
2767: p_to_serial_number => l_dummy_sn, -- no serial control
2768: p_validation_flag => fnd_api.g_true,
2769: -- Bug 5099694
2770: p_over_reservation_flag =>3,
2771: x_to_reservation_id => l_new_rsv_id
2772: );

Line 2777: IF l_status = fnd_api.g_ret_sts_success THEN

2773: IF l_debug_on THEN
2774: WSH_DEBUG_SV.log(l_module_name,'transfer_reservation l_status',l_status);
2775: END IF;
2776:
2777: IF l_status = fnd_api.g_ret_sts_success THEN
2778: IF l_debug_on THEN
2779: -- HW OPMCONV - Print Qty2
2780: WSH_DEBUG_SV.logmsg(l_module_name, 'Rsvn. Transferred FOR Rsvn.ID :'
2781: ||P_RSV.RESERVATION_ID || ' : TO Rsvn.ID : '||L_NEW_RSV_ID||

Line 2827: IF l_status = fnd_api.g_ret_sts_success THEN

2823: IF l_debug_on THEN
2824: WSH_DEBUG_SV.log(l_module_name,'update_staged_flag l_status',l_status);
2825: END IF;
2826:
2827: IF l_status = fnd_api.g_ret_sts_success THEN
2828: IF l_debug_on THEN
2829: WSH_DEBUG_SV.logmsg(l_module_name, 'STAGED FLAG UPDATED FOR RESERVATION ID : '||L_NEW_RSV_ID );
2830: END IF;
2831: ELSE

Line 2855: OR p_split_quantity2 = FND_API.G_MISS_NUM) THEN

2851:
2852: p_split_quantity := p_split_quantity - l_quantity_to_split;
2853: -- HW OPMCONV -Added Qty2
2854: IF ( p_split_quantity2 IS NULL
2855: OR p_split_quantity2 = FND_API.G_MISS_NUM) THEN
2856: p_split_quantity2 :=0;
2857: ELSE
2858: p_split_quantity2 := p_split_quantity2 - l_quantity2_to_split;
2859: END IF;

Line 2979: IF x_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR,FND_API.G_RET_STS_ERROR) THEN

2975: x_detail_id => l_delivery_detail_id,
2976: x_return_status => x_return_status);
2977:
2978: -- Above call populates l_delivery_detail_id and is used at multiple places in this API
2979: IF x_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR,FND_API.G_RET_STS_ERROR) THEN
2980: IF l_debug_on THEN
2981: WSH_DEBUG_SV.log(l_module_name,'Exception has occured after WSHUSAIB.get_putaway_detail_id');
2982: WSH_DEBUG_SV.pop(l_module_name);
2983: END IF;

Line 3034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3030: IF l_debug_on THEN
3031: WSH_DEBUG_SV.log(l_module_name,'Cancel_Move_Order_Line returned unexpected error');
3032: END IF;
3033:
3034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3035: --
3036: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3037: --
3038: IF l_debug_on THEN

Line 3129: IF ( p_split_quantity2 = 0 OR p_split_quantity2 = FND_API.G_MISS_NUM) THEN

3125: --}
3126:
3127: l_split_quantity := p_split_quantity;
3128: -- HW OPMCONV. Added split_quantity2
3129: IF ( p_split_quantity2 = 0 OR p_split_quantity2 = FND_API.G_MISS_NUM) THEN
3130: l_split_quantity2 := NULL;
3131: ELSE
3132: l_split_quantity2 := p_split_quantity2;
3133: END IF;

Line 3149: p_lock_records => fnd_api.g_true,

3145: p_source_code => p_source_code,
3146: p_source_header_id => p_source_header_id,
3147: p_source_line_id => p_original_source_line_id,
3148: p_organization_id => p_delivery_detail_split_rec.organization_id,
3149: p_lock_records => fnd_api.g_true,
3150: p_direction_flag => p_direction_flag ,
3151: p_delivery_detail_id => l_delivery_detail_id, -- X-dock
3152: x_mtl_reservation_tbl => l_rsv_array,
3153: x_mtl_reservation_tbl_count => l_size,

Line 3250: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3246: x_return_status => x_return_status);
3247: IF l_debug_on THEN
3248: WSH_DEBUG_SV.log(l_module_name, 'reservation_split_action',x_return_status);
3249: END IF;
3250: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3251: raise split_failed;
3252: END IF;
3253: END IF; -- <> 'Y','C'
3254: END IF;

Line 3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3284: END IF;
3285: --
3286: -- bug 5226867
3287: -- Added the new excpetion for unexpected error
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3290: --
3291: -- Debug Statements
3292: --

Line 3294: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3290: --
3291: -- Debug Statements
3292: --
3293: IF l_debug_on THEN
3294: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3296: END IF;
3297: --
3298: -- bug 5226867

Line 3295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3291: -- Debug Statements
3292: --
3293: IF l_debug_on THEN
3294: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3296: END IF;
3297: --
3298: -- bug 5226867
3299: WHEN others THEN

Line 3364: x_return_status := FND_API.G_RET_STS_SUCCESS;

3360: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS' );
3361: END IF;
3362: --
3363: IF (p_serial_number IS NULL) AND (p_transaction_temp_id IS NULL) THEN
3364: x_return_status := FND_API.G_RET_STS_SUCCESS;
3365: --
3366: -- Debug Statements
3367: --
3368: IF l_debug_on THEN

Line 3377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3373: ELSE
3374: OPEN Get_Sl_Num_Ctrl_Cd;
3375: FETCH Get_Sl_Num_Ctrl_Cd INTO l_serial_number_control_code;
3376: IF Get_Sl_Num_Ctrl_Cd%NOTFOUND THEN
3377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3378: CLOSE Get_Sl_Num_Ctrl_Cd;
3379: --
3380: -- Debug Statements
3381: --

Line 3399: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3395: x_return_status => x_return_status);
3396: IF l_debug_on THEN
3397: WSH_DEBUG_SV.log(l_module_name,'Unmark_Serial_Number x_return_status',x_return_status);
3398: END IF;
3399: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3400: x_return_status := FND_API.G_RET_STS_ERROR;
3401: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3402: --
3403: -- Debug Statements

Line 3400: x_return_status := FND_API.G_RET_STS_ERROR;

3396: IF l_debug_on THEN
3397: WSH_DEBUG_SV.log(l_module_name,'Unmark_Serial_Number x_return_status',x_return_status);
3398: END IF;
3399: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3400: x_return_status := FND_API.G_RET_STS_ERROR;
3401: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3402: --
3403: -- Debug Statements
3404: --

Line 3417: x_return_status := FND_API.G_RET_STS_SUCCESS;

3413: to_serial_number = NULL,
3414: transaction_temp_id = NULL,
3415: shipped_quantity = 0
3416: WHERE delivery_detail_id = p_delivery_detail_id;
3417: x_return_status := FND_API.G_RET_STS_SUCCESS;
3418: END IF;
3419:
3420: --
3421: -- Debug Statements

Line 3430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3426: --
3427: EXCEPTION
3428:
3429: WHEN OTHERS THEN
3430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3431: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.update_serial_numbers',l_module_name);
3432:
3433: --
3434: -- Debug Statements

Line 3658: -- Bug 3390514 : Treating FND_API.G_MISS_NUM in pending_quantity as Zero

3654: l_txn_return_status VARCHAR2(1); -- DBI Project
3655:
3656: l_wf_rs VARCHAR2(1); --Pick to POD WF Project
3657:
3658: -- Bug 3390514 : Treating FND_API.G_MISS_NUM in pending_quantity as Zero
3659: l_pending_quantity NUMBER;
3660: l_backordered_item_id NUMBER;
3661: l_top_model_item_id NUMBER;
3662:

Line 3668: --Bug 3878429: treat fnd_api.g_miss_num in pending_quantity2 as zero

3664: l_original_caller VARCHAR2(100) := WSH_WMS_LPN_GRP.g_caller;
3665: l_orig_callback_reqd VARCHAR2(100) := WSH_WMS_LPN_GRP.g_callback_required;
3666: -- LPN CONV rv
3667:
3668: --Bug 3878429: treat fnd_api.g_miss_num in pending_quantity2 as zero
3669: l_pending_quantity2 NUMBER;
3670: -- /==Workflow Change
3671: Cursor c_get_picked_lines_count (c_delivery_detail_id NUMBER)
3672: IS

Line 3755: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as

3751: -- action_flag is M, recursive call to update_inventory_info is done with action_flag as U.
3752: -- So values will be lost during the 2nd call. That is why it is not reset for action_flag as M.
3753: IF p_changed_attributes(p_changed_attributes.FIRST).action_flag <> 'M' THEN
3754: --{
3755: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
3756: --
3757: IF ( l_transaction_id <> FND_API.G_MISS_NUM OR l_transaction_id IS NULL
3758: OR l_transaction_temp_id <> FND_API.G_MISS_NUM OR l_transaction_temp_id IS NULL) THEN
3759: --{

Line 3757: IF ( l_transaction_id <> FND_API.G_MISS_NUM OR l_transaction_id IS NULL

3753: IF p_changed_attributes(p_changed_attributes.FIRST).action_flag <> 'M' THEN
3754: --{
3755: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
3756: --
3757: IF ( l_transaction_id <> FND_API.G_MISS_NUM OR l_transaction_id IS NULL
3758: OR l_transaction_temp_id <> FND_API.G_MISS_NUM OR l_transaction_temp_id IS NULL) THEN
3759: --{
3760: l_InvPCInRecType.transaction_id := FND_API.G_MISS_NUM;
3761: l_InvPCInRecType.transaction_temp_id := FND_API.G_MISS_NUM;

Line 3758: OR l_transaction_temp_id <> FND_API.G_MISS_NUM OR l_transaction_temp_id IS NULL) THEN

3754: --{
3755: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
3756: --
3757: IF ( l_transaction_id <> FND_API.G_MISS_NUM OR l_transaction_id IS NULL
3758: OR l_transaction_temp_id <> FND_API.G_MISS_NUM OR l_transaction_temp_id IS NULL) THEN
3759: --{
3760: l_InvPCInRecType.transaction_id := FND_API.G_MISS_NUM;
3761: l_InvPCInRecType.transaction_temp_id := FND_API.G_MISS_NUM;
3762: l_InvPCInRecType.source_code := 'INV';

Line 3760: l_InvPCInRecType.transaction_id := FND_API.G_MISS_NUM;

3756: --
3757: IF ( l_transaction_id <> FND_API.G_MISS_NUM OR l_transaction_id IS NULL
3758: OR l_transaction_temp_id <> FND_API.G_MISS_NUM OR l_transaction_temp_id IS NULL) THEN
3759: --{
3760: l_InvPCInRecType.transaction_id := FND_API.G_MISS_NUM;
3761: l_InvPCInRecType.transaction_temp_id := FND_API.G_MISS_NUM;
3762: l_InvPCInRecType.source_code := 'INV';
3763: l_InvPCInRecType.api_version_number := 1.0;
3764: --

Line 3761: l_InvPCInRecType.transaction_temp_id := FND_API.G_MISS_NUM;

3757: IF ( l_transaction_id <> FND_API.G_MISS_NUM OR l_transaction_id IS NULL
3758: OR l_transaction_temp_id <> FND_API.G_MISS_NUM OR l_transaction_temp_id IS NULL) THEN
3759: --{
3760: l_InvPCInRecType.transaction_id := FND_API.G_MISS_NUM;
3761: l_InvPCInRecType.transaction_temp_id := FND_API.G_MISS_NUM;
3762: l_InvPCInRecType.source_code := 'INV';
3763: l_InvPCInRecType.api_version_number := 1.0;
3764: --
3765: IF l_debug_on THEN

Line 3789: --Bug#5104847:transaction_temp_id default value is FND_API.G_MISS_NUM

3785: END IF;
3786:
3787: -- Assumption : Whenever Inventory calls with transaction_temp_id, they will pass only 1 record in
3788: -- p_changed_attributes. If not, return error for the transaction
3789: --Bug#5104847:transaction_temp_id default value is FND_API.G_MISS_NUM
3790: IF ( l_transaction_temp_id IS NOT NULL AND l_transaction_temp_id <> FND_API.G_MISS_NUM ) AND p_changed_attributes.COUNT > 1 THEN
3791:
3792: IF l_debug_on THEN
3793: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of records passed by inventory ' || p_changed_attributes.COUNT );

Line 3790: IF ( l_transaction_temp_id IS NOT NULL AND l_transaction_temp_id <> FND_API.G_MISS_NUM ) AND p_changed_attributes.COUNT > 1 THEN

3786:
3787: -- Assumption : Whenever Inventory calls with transaction_temp_id, they will pass only 1 record in
3788: -- p_changed_attributes. If not, return error for the transaction
3789: --Bug#5104847:transaction_temp_id default value is FND_API.G_MISS_NUM
3790: IF ( l_transaction_temp_id IS NOT NULL AND l_transaction_temp_id <> FND_API.G_MISS_NUM ) AND p_changed_attributes.COUNT > 1 THEN
3791:
3792: IF l_debug_on THEN
3793: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of records passed by inventory ' || p_changed_attributes.COUNT );
3794: WSH_DEBUG_SV.logmsg(l_module_name, 'Reject request as transaction_temp_id is passed for more than 1 record by inventory ');

Line 3836: -- Bug 3390514 : Treating FND_API.G_MISS_NUM in pending_quantity as Zero

3832: WSH_DEBUG_SV.logmsg(l_module_name, 'DELDET ID IS ' || P_CHANGED_ATTRIBUTES ( L_COUNTER ) .DELIVERY_DETAIL_ID );
3833: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDERED QTY IS ' || P_CHANGED_ATTRIBUTES ( L_COUNTER ) .ORDERED_QUANTITY );
3834: END IF;
3835:
3836: -- Bug 3390514 : Treating FND_API.G_MISS_NUM in pending_quantity as Zero
3837: IF p_changed_attributes(l_counter).pending_quantity = FND_API.G_MISS_NUM THEN
3838: --{
3839: l_pending_quantity := 0;
3840: --}

Line 3837: IF p_changed_attributes(l_counter).pending_quantity = FND_API.G_MISS_NUM THEN

3833: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDERED QTY IS ' || P_CHANGED_ATTRIBUTES ( L_COUNTER ) .ORDERED_QUANTITY );
3834: END IF;
3835:
3836: -- Bug 3390514 : Treating FND_API.G_MISS_NUM in pending_quantity as Zero
3837: IF p_changed_attributes(l_counter).pending_quantity = FND_API.G_MISS_NUM THEN
3838: --{
3839: l_pending_quantity := 0;
3840: --}
3841: ELSE

Line 3848: IF p_changed_attributes(l_counter).pending_quantity2 = FND_API.G_MISS_NUM THEN

3844: --}
3845: END IF;
3846:
3847: --Bug 3878429.
3848: IF p_changed_attributes(l_counter).pending_quantity2 = FND_API.G_MISS_NUM THEN
3849: --{
3850: l_pending_quantity2 := 0;
3851: --}
3852: ELSE

Line 3991: IF (p_changed_attributes(l_counter).picked_quantity = FND_API.G_MISS_NUM) THEN

3987: --
3988: l_multiple_update := 'Y';
3989: l_changed_attributes(l_counter) := p_changed_attributes(l_counter);
3990:
3991: IF (p_changed_attributes(l_counter).picked_quantity = FND_API.G_MISS_NUM) THEN
3992:
3993: -- Can l_split_quantity is null ? If yes , then we need to handle that condition here.
3994: l_split_quantity := p_changed_attributes(l_counter).ordered_quantity ;
3995:

Line 3997: if ( p_changed_attributes(l_Counter).ordered_quantity2 = FND_API.G_MISS_NUM ) then

3993: -- Can l_split_quantity is null ? If yes , then we need to handle that condition here.
3994: l_split_quantity := p_changed_attributes(l_counter).ordered_quantity ;
3995:
3996: -- odaboval : Begin of OPM Changes (Pick_Confirm)
3997: if ( p_changed_attributes(l_Counter).ordered_quantity2 = FND_API.G_MISS_NUM ) then
3998: l_split_quantity2 := null ;
3999: else
4000: l_split_quantity2 := p_changed_attributes(l_Counter).ordered_quantity2 ;
4001: end if ;

Line 4050: if ( p_changed_attributes(l_Counter).picked_quantity2 = FND_API.G_MISS_NUM ) then

4046: l_dummy_detail_id := p_changed_attributes(l_counter).delivery_detail_id;
4047: l_split_quantity := p_changed_attributes(l_counter).picked_quantity ;
4048:
4049: -- begin of OPM
4050: if ( p_changed_attributes(l_Counter).picked_quantity2 = FND_API.G_MISS_NUM ) then
4051: l_split_quantity2 := null ;
4052: else
4053: l_split_quantity2 := p_changed_attributes(l_Counter).picked_quantity2 ;
4054: end if ;

Line 4064: --because p_changed_attributes(l_counter).pending_quantity2 could be fnd_api.g_miss_num

4060: + l_pending_quantity; -- Bug#: 3390514
4061:
4062: --Fix for bug 3878429
4063: --Use l_pending_quantity2 instead of p_changed_attributes(l_counter).pending_quantity2
4064: --because p_changed_attributes(l_counter).pending_quantity2 could be fnd_api.g_miss_num
4065:
4066: old_delivery_detail_rec.picked_quantity2 := l_split_quantity2 + l_pending_quantity2;
4067:
4068: /*

Line 4078: FND_API.G_MISS_CHAR, requested_quantity_uom2,

4074: picked_quantity2 = old_delivery_detail_rec.picked_quantity2,
4075: requested_quantity_uom2 = DECODE(l_wms_enabled_flag,
4076: 'Y',
4077: DECODE(p_changed_attributes(l_counter).ordered_quantity_uom2,
4078: FND_API.G_MISS_CHAR, requested_quantity_uom2,
4079: p_changed_attributes(l_counter).ordered_quantity_uom2),
4080: requested_quantity_uom2)
4081: WHERE delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
4082:

Line 4115: END IF; -- (p_changed_attributes(l_counter).picked_quantity = FND_API.G_MISS_NUM) for 'M'

4111: WHERE delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
4112:
4113: l_changed_attributes(l_counter).delivery_detail_id := l_dummy_detail_id;
4114:
4115: END IF; -- (p_changed_attributes(l_counter).picked_quantity = FND_API.G_MISS_NUM) for 'M'
4116:
4117: /* NC - Added - OPM Changes BUG# 1675561 */
4118: -- HW OPMCONV. Removed code forking
4119:

Line 4135: IF p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM THEN

4131: WSH_DEBUG_SV.log(l_module_name, 'l_pending_quantity2', l_pending_quantity2);
4132: END IF;
4133: --
4134:
4135: IF p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM THEN
4136:
4137: -- begin of OPM
4138: if ( p_changed_attributes(l_Counter).picked_quantity2 = FND_API.G_MISS_NUM ) then
4139: l_split_quantity2 := null ;

Line 4138: if ( p_changed_attributes(l_Counter).picked_quantity2 = FND_API.G_MISS_NUM ) then

4134:
4135: IF p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM THEN
4136:
4137: -- begin of OPM
4138: if ( p_changed_attributes(l_Counter).picked_quantity2 = FND_API.G_MISS_NUM ) then
4139: l_split_quantity2 := null ;
4140: else
4141: l_split_quantity2 := p_changed_attributes(l_Counter).picked_quantity2 ;
4142: end if ;

Line 4151: --because p_changed_attributes(l_counter).pending_quantity2 could be fnd_api.g_miss_num

4147: + l_pending_quantity; -- Bug#: 3390514
4148:
4149: --Fix for bug 3878429
4150: --Use l_pending_quantity2 instead of p_changed_attributes(l_counter).pending_quantity2
4151: --because p_changed_attributes(l_counter).pending_quantity2 could be fnd_api.g_miss_num
4152:
4153: old_delivery_detail_rec.picked_quantity2 := l_split_quantity2 + l_pending_quantity2;
4154:
4155: /* old_delivery_detail_rec.picked_quantity2 := l_split_quantity2

Line 4170: IF (p_changed_attributes(l_counter).pending_quantity2 = FND_API.G_MISS_NUM) THEN

4166: WHERE delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
4167:
4168: l_split_quantity := l_pending_quantity; -- Bug#: 3390514
4169:
4170: IF (p_changed_attributes(l_counter).pending_quantity2 = FND_API.G_MISS_NUM) THEN
4171: l_split_quantity2 := old_delivery_detail_rec.requested_quantity2;
4172: ELSE
4173: l_split_quantity2 := p_changed_attributes(l_counter).pending_quantity2;
4174: END IF;

Line 4182: if ( p_changed_attributes(l_Counter).ordered_quantity2 = FND_API.G_MISS_NUM ) then

4178: -- this split quantity to have the newly create delivery detail
4179: -- to be backorder detail
4180: l_split_quantity := old_delivery_detail_rec.requested_quantity - p_Changed_attributes(l_Counter).ordered_quantity;
4181: -- odaboval : Begin of OPM Changes (Pick_Confirm)
4182: if ( p_changed_attributes(l_Counter).ordered_quantity2 = FND_API.G_MISS_NUM ) then
4183: l_split_quantity2 := old_delivery_detail_rec.requested_quantity2 ;
4184: else
4185: l_split_quantity2 := old_delivery_detail_rec.requested_quantity2 - p_changed_attributes(l_Counter).ordered_quantity2 ;
4186: end if ;

Line 4219: IF p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM THEN

4215:
4216: /* LG BUG#:2005977 */
4217: -- HW OPMCONV. Removed code forking
4218:
4219: IF p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM THEN
4220: -- correct the requested quantities of the split lines.
4221: -- be sure to clear the picked quantities if line has requested_quantity > 0.
4222:
4223: UPDATE wsh_delivery_details

Line 4391: IF l_split_quantity2 = FND_API.G_MISS_NUM THEN

4387: END IF;
4388:
4389: l_split_quantity := p_Changed_attributes(l_Counter).cycle_count_quantity;
4390: l_split_quantity2 := p_Changed_attributes(l_Counter).cycle_count_quantity2;
4391: IF l_split_quantity2 = FND_API.G_MISS_NUM THEN
4392: l_split_quantity2 := NULL;
4393: END IF;
4394:
4395: IF (l_split_quantity < old_Delivery_detail_rec.requested_quantity) THEN

Line 4457: p_changed_attributes(l_Counter).cycle_count_quantity = FND_API.G_MISS_NUM OR

4453: -- and action is backorder
4454: l_request_id := fnd_global.conc_request_id;
4455: -- 1729516
4456: IF ( l_request_id <> -1 OR
4457: p_changed_attributes(l_Counter).cycle_count_quantity = FND_API.G_MISS_NUM OR
4458: WSH_PICK_LIST.G_BATCH_ID IS NOT NULL ) THEN
4459: --
4460: -- Debug Statements
4461: --

Line 4915: IF l_split_quantity2 = FND_API.G_MISS_NUM THEN

4911: -- BUG#:1549665 hwahdani end of changes
4912:
4913: l_split_quantity := p_Changed_attributes(l_Counter).cycle_count_quantity;
4914: l_split_quantity2 := p_Changed_attributes(l_Counter).cycle_count_quantity2;
4915: IF l_split_quantity2 = FND_API.G_MISS_NUM THEN
4916: l_split_quantity2 := NULL;
4917: END IF;
4918:
4919: -- Start of Consolidation Of BO DD's.

Line 5147: IF (p_changed_attributes(l_Counter).transfer_lpn_id <> FND_API.G_MISS_NUM ) THEN

5143: l_parent_detail_id := NULL;
5144: l_container_name := NULL;
5145: END;
5146:
5147: IF (p_changed_attributes(l_Counter).transfer_lpn_id <> FND_API.G_MISS_NUM ) THEN
5148:
5149: --
5150: -- Debug Statements
5151: --

Line 5484: IF (p_changed_attributes(l_counter).subinventory <> FND_API.G_MISS_CHAR AND

5480: END IF; -- End of if reject_update
5481: END IF; -- End of if transfer_lpn_id
5482:
5483: -- HW OPMCONV. Removed OPM specific logic
5484: IF (p_changed_attributes(l_counter).subinventory <> FND_API.G_MISS_CHAR AND
5485: (NVL(old_delivery_detail_rec.subinventory,'-99') <> NVL(p_changed_attributes(l_Counter).subinventory,'-99'))) THEN
5486: --
5487: -- Debug Statements
5488: --

Line 5510: IF (p_changed_attributes(l_counter).locator_id <> FND_API.G_MISS_NUM AND

5506: END IF; -- End of if shipped_details >= 1
5507: END IF; -- End of if subinventory
5508:
5509: -- HW OPMCONV. Removed OPM specific logic
5510: IF (p_changed_attributes(l_counter).locator_id <> FND_API.G_MISS_NUM AND
5511: (NVL(old_delivery_detail_rec.locator_id,-99) <> NVL(p_changed_attributes(l_Counter).locator_id,-99))) THEN
5512: --
5513: -- Debug Statements
5514: --

Line 5536: IF (p_changed_attributes(l_counter).revision <> FND_API.G_MISS_CHAR AND

5532: l_update_loc := 'Y';
5533: END IF; -- End of if shipped_details >= 1
5534: END IF; -- End of if locator_id
5535:
5536: IF (p_changed_attributes(l_counter).revision <> FND_API.G_MISS_CHAR AND
5537: (NVL(old_delivery_detail_rec.revision,'-99') <> NVL(p_changed_attributes(l_Counter).revision,'-99'))) THEN
5538: --
5539: -- Debug Statements
5540: --

Line 5565: -- IF (p_changed_attributes(l_counter).lot_number <> FND_API.G_MISS_CHAR AND

5561:
5562: -- odaboval : Begin of OPM Changes (Pick_Confirm)
5563: -- HW OPMCONV - Removed sublot code
5564:
5565: -- IF (p_changed_attributes(l_counter).lot_number <> FND_API.G_MISS_CHAR AND
5566: -- ((NVL(old_delivery_detail_rec.lot_number,'-99') <> NVL(p_changed_attributes(l_Counter).lot_number,'-99')))) THEN
5567: --bug 6675904 changed if condition as Inv allows any value for lot number so -99 was
5568: --not getting updated in WDD
5569: IF ( ( ( old_delivery_detail_rec.lot_number IS NULL AND p_changed_attributes(l_Counter).lot_number IS NOT NULL ) OR

Line 5573: p_changed_attributes(l_counter).lot_number <> FND_API.G_MISS_CHAR) THEN

5569: IF ( ( ( old_delivery_detail_rec.lot_number IS NULL AND p_changed_attributes(l_Counter).lot_number IS NOT NULL ) OR
5570: ( old_delivery_detail_rec.lot_number IS NOT NULL AND p_changed_attributes(l_Counter).lot_number IS NULL ) OR
5571: ( old_delivery_detail_rec.lot_number IS NOT NULL AND p_changed_attributes(l_Counter).lot_number IS NOT NULL AND
5572: old_delivery_detail_rec.lot_number <> p_changed_attributes(l_Counter).lot_number )) and
5573: p_changed_attributes(l_counter).lot_number <> FND_API.G_MISS_CHAR) THEN
5574: --
5575: -- Debug Statements
5576: --
5577: IF l_debug_on THEN

Line 5601: IF (p_changed_attributes(l_counter).preferred_grade <> FND_API.G_MISS_CHAR AND

5597:
5598:
5599: -- Hverddin 12-SEP-200 Start of OPM changes For Grade
5600: -- NOTE LOG EXCEPTIONS PUT VALUE INTO LOT_NUMBER UNTIL RESOLVED
5601: IF (p_changed_attributes(l_counter).preferred_grade <> FND_API.G_MISS_CHAR AND
5602: (NVL(old_delivery_detail_rec.preferred_grade,'-99') <> NVL(p_changed_attributes(l_Counter).preferred_grade,'-99'))) THEN
5603: --
5604: -- Debug Statements
5605: --

Line 5629: IF (l_transaction_temp_id <> FND_API.G_MISS_NUM AND

5625: END IF; -- End of if preferred_grade
5626: -- Hverddin 12-SEP-200 End of OPM changes For Grade
5627:
5628: -- Bug 2657652 : Added transaction_temp_id
5629: IF (l_transaction_temp_id <> FND_API.G_MISS_NUM AND
5630: (NVL(old_delivery_detail_rec.transaction_temp_id,-99) <> NVL(l_transaction_temp_id,-99))) THEN
5631: --
5632: -- Debug Statements
5633: --

Line 5654: IF (p_changed_attributes(l_counter).serial_number <> FND_API.G_MISS_CHAR AND

5650: l_update_transaction_temp_id := 'Y';
5651: END IF; -- End of if l_reject_update = 'Y'
5652: END IF; -- End of if transaction_temp_id
5653:
5654: IF (p_changed_attributes(l_counter).serial_number <> FND_API.G_MISS_CHAR AND
5655: (NVL(old_delivery_detail_rec.serial_number,'-99') <> NVL(p_changed_attributes(l_Counter).serial_number,'-99'))) THEN
5656: --
5657: -- Debug Statements
5658: --

Line 5680: IF (p_changed_attributes(l_counter).released_status <> FND_API.G_MISS_CHAR AND

5676: l_update_serial_number := 'Y';
5677: END IF; -- End of if shipped_details >= 1
5678: END IF; -- End of if serial_number
5679:
5680: IF (p_changed_attributes(l_counter).released_status <> FND_API.G_MISS_CHAR AND
5681: NVL(old_delivery_detail_rec.released_status, 'N') <> NVL(p_changed_attributes(l_Counter).released_status, 'N')) THEN
5682: --
5683: -- Debug Statements
5684: --

Line 5707: IF p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM THEN

5703: --
5704: -- When that happens, we call update_ordered_quantity in order to update
5705: -- other unstaged delivery lines so that the total requested quantity will
5706: -- still match the order line's ordered quantity.
5707: IF p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM THEN
5708:
5709: DECLARE -- BLOCK for managing requested quantity changes
5710: CURSOR c_detail_info(x_delivery_detail_id IN NUMBER) IS
5711: SELECT source_line_id,

Line 5735: l_process_flag VARCHAR2(1) :=FND_API.G_FALSE;

5731: l_max_quantity NUMBER;
5732: l_avail_quantity NUMBER;
5733: -- HW OPM added qty2 variables
5734:
5735: l_process_flag VARCHAR2(1) :=FND_API.G_FALSE;
5736: l_max_quantity2 NUMBER;
5737: l_avail_quantity2 NUMBER;
5738: l_allowed_flag VARCHAR2(1);
5739: l_rs VARCHAR2(1);

Line 5801: l_process_flag := FND_API.G_FALSE;

5797: END IF;
5798:
5799: -- bug 7131800
5800: IF NOT INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => l_detail_info.organization_id) THEN
5801: l_process_flag := FND_API.G_FALSE;
5802: ELSE
5803: l_process_flag := FND_API.G_TRUE;
5804: END IF;
5805:

Line 5803: l_process_flag := FND_API.G_TRUE;

5799: -- bug 7131800
5800: IF NOT INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => l_detail_info.organization_id) THEN
5801: l_process_flag := FND_API.G_FALSE;
5802: ELSE
5803: l_process_flag := FND_API.G_TRUE;
5804: END IF;
5805:
5806: IF l_debug_on THEN
5807: WSH_DEBUG_SV.log(l_module_name,'l_process_flag',l_process_flag);

Line 5813: IF ( l_process_flag = FND_API.G_FALSE AND l_retain_nonstaged_dd_param = 'Y') THEN

5809:
5810:
5811: IF l_ret_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5812: l_retain_nonstaged_dd_param := nvl(l_ship_params.retain_nonstaged_det_flag,'N');
5813: IF ( l_process_flag = FND_API.G_FALSE AND l_retain_nonstaged_dd_param = 'Y') THEN
5814: l_new_req_quantity := l_detail_info.requested_quantity + (l_avail_quantity - LEAST(l_max_quantity -(p_changed_attributes(l_counter).picked_quantity - l_detail_info.requested_quantity), l_avail_quantity));
5815: ELSE
5816: l_new_req_quantity := LEAST(p_changed_attributes(l_counter).picked_quantity,
5817: l_avail_quantity);

Line 5875: END IF; -- p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM

5871: END IF; -- l_new_req_quantity > l_detail_info.requested_quantity
5872: END IF; -- l_found AND requested_quantity <> picked_quantity
5873:
5874: END; -- BLOCK for managing requested quantity changes
5875: END IF; -- p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM
5876: -- end overpicking logic
5877:
5878: END IF; -- End of if shipped_details >= 1
5879: END IF; -- End of if released_status

Line 5903: ((p_changed_attributes(l_counter).picked_quantity = FND_API.G_MISS_NUM AND

5899: -- WMS has UI where user can enter serial number and attributes, hence this
5900: -- requirement.This API is also called during Pick Confirm, test cases for Inv.
5901: IF ((l_update_transaction_temp_id = 'Y' AND l_update_serial_number = 'Y') OR
5902: (l_update_serial_number = 'Y' AND
5903: ((p_changed_attributes(l_counter).picked_quantity = FND_API.G_MISS_NUM AND
5904: NVL(l_new_req_quantity, old_delivery_detail_rec.requested_quantity) > 1) OR
5905: (p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM AND
5906: p_changed_attributes(l_counter).picked_quantity > 1))
5907: )

Line 5905: (p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM AND

5901: IF ((l_update_transaction_temp_id = 'Y' AND l_update_serial_number = 'Y') OR
5902: (l_update_serial_number = 'Y' AND
5903: ((p_changed_attributes(l_counter).picked_quantity = FND_API.G_MISS_NUM AND
5904: NVL(l_new_req_quantity, old_delivery_detail_rec.requested_quantity) > 1) OR
5905: (p_changed_attributes(l_counter).picked_quantity <> FND_API.G_MISS_NUM AND
5906: p_changed_attributes(l_counter).picked_quantity > 1))
5907: )
5908: ) THEN
5909:

Line 5951: IF l_split_quantity2 = FND_API.G_MISS_NUM THEN

5947: AND p_Changed_Attributes(l_counter).picked_quantity < old_Delivery_detail_rec.requested_quantity )
5948: THEN
5949: -- HW OPM split_qty2 should get value of picked_quantity2
5950: l_split_quantity2 := p_Changed_attributes(l_Counter).picked_quantity2;
5951: IF l_split_quantity2 = FND_API.G_MISS_NUM THEN
5952: l_split_quantity2 := NULL;
5953: END IF;
5954:
5955: l_split_quantity := p_Changed_Attributes(l_counter).picked_quantity;

Line 6147: FND_API.G_MISS_NUM, NVL(l_new_req_quantity, requested_quantity),

6143: transaction_temp_id = decode(l_update_transaction_temp_id, 'Y',l_transaction_temp_id,transaction_temp_id),
6144: serial_number = decode(l_update_serial_number,'Y',p_Changed_Attributes(l_Counter).serial_number,serial_number),
6145: shipped_quantity = decode(l_update_shipped_quantity,
6146: 'Y',decode(p_changed_attributes(l_counter).picked_quantity,
6147: FND_API.G_MISS_NUM, NVL(l_new_req_quantity, requested_quantity),
6148: p_changed_attributes(l_counter).picked_quantity),
6149: shipped_quantity),
6150: shipped_quantity2 = decode(l_update_shipped_quantity,
6151: 'Y',decode(p_changed_attributes(l_counter).picked_quantity2,

Line 6152: FND_API.G_MISS_NUM, NVL(l_new_req_quantity2, requested_quantity2),

6148: p_changed_attributes(l_counter).picked_quantity),
6149: shipped_quantity),
6150: shipped_quantity2 = decode(l_update_shipped_quantity,
6151: 'Y',decode(p_changed_attributes(l_counter).picked_quantity2,
6152: FND_API.G_MISS_NUM, NVL(l_new_req_quantity2, requested_quantity2),
6153: p_changed_attributes(l_counter).picked_quantity2),
6154: shipped_quantity2),
6155:
6156: -- Bug 1851473 : Set backordered qty = 0 in STF

Line 6162: picked_quantity = DECODE(p_changed_attributes(l_counter).picked_quantity, FND_API.G_MISS_NUM, NULL,

6158: cycle_count_quantity2 = decode(l_update_shipped_quantity,'Y',0,cycle_count_quantity2),
6159: released_status = decode(l_update_rel_status,'Y',decode(pickable_flag,'Y',p_Changed_Attributes(l_Counter).released_status,'X'), released_status),
6160: requested_quantity = NVL(l_new_req_quantity, requested_quantity),
6161: requested_quantity2 = NVL(l_new_req_quantity2, requested_quantity2),
6162: picked_quantity = DECODE(p_changed_attributes(l_counter).picked_quantity, FND_API.G_MISS_NUM, NULL,
6163: p_changed_attributes(l_counter).picked_quantity),
6164: picked_quantity2 = DECODE(p_changed_attributes(l_counter).picked_quantity2, FND_API.G_MISS_NUM, NULL,
6165: p_changed_attributes(l_counter).picked_quantity2),
6166: requested_quantity_uom2 = DECODE(l_wms_enabled_flag,

Line 6164: picked_quantity2 = DECODE(p_changed_attributes(l_counter).picked_quantity2, FND_API.G_MISS_NUM, NULL,

6160: requested_quantity = NVL(l_new_req_quantity, requested_quantity),
6161: requested_quantity2 = NVL(l_new_req_quantity2, requested_quantity2),
6162: picked_quantity = DECODE(p_changed_attributes(l_counter).picked_quantity, FND_API.G_MISS_NUM, NULL,
6163: p_changed_attributes(l_counter).picked_quantity),
6164: picked_quantity2 = DECODE(p_changed_attributes(l_counter).picked_quantity2, FND_API.G_MISS_NUM, NULL,
6165: p_changed_attributes(l_counter).picked_quantity2),
6166: requested_quantity_uom2 = DECODE(l_wms_enabled_flag,
6167: 'Y',
6168: DECODE(p_changed_attributes(l_counter).ordered_quantity_uom2,

Line 6169: FND_API.G_MISS_CHAR, requested_quantity_uom2,

6165: p_changed_attributes(l_counter).picked_quantity2),
6166: requested_quantity_uom2 = DECODE(l_wms_enabled_flag,
6167: 'Y',
6168: DECODE(p_changed_attributes(l_counter).ordered_quantity_uom2,
6169: FND_API.G_MISS_CHAR, requested_quantity_uom2,
6170: p_changed_attributes(l_counter).ordered_quantity_uom2),
6171: requested_quantity_uom2),
6172: batch_id = DECODE(batch_id, NULL, WSH_PICK_LIST.G_BATCH_ID, batch_id),
6173: last_update_date = SYSDATE,

Line 6176: ----Bug#5104847:transaction_id updated only when l_transaction_id is not FND_API.G_MISS_NUM (default value).

6172: batch_id = DECODE(batch_id, NULL, WSH_PICK_LIST.G_BATCH_ID, batch_id),
6173: last_update_date = SYSDATE,
6174: last_updated_by = l_user_id,
6175: last_update_login = l_login_id,
6176: ----Bug#5104847:transaction_id updated only when l_transaction_id is not FND_API.G_MISS_NUM (default value).
6177: transaction_id = DECODE(l_transaction_id,FND_API.G_MISS_NUM,transaction_id,l_transaction_id)
6178: ,tracking_number = old_Delivery_detail_rec.tracking_number --Bug# 3632485
6179: WHERE delivery_detail_id = l_dummy_detail_id
6180: RETURNING organization_id -- Done for Workflow Project

Line 6177: transaction_id = DECODE(l_transaction_id,FND_API.G_MISS_NUM,transaction_id,l_transaction_id)

6173: last_update_date = SYSDATE,
6174: last_updated_by = l_user_id,
6175: last_update_login = l_login_id,
6176: ----Bug#5104847:transaction_id updated only when l_transaction_id is not FND_API.G_MISS_NUM (default value).
6177: transaction_id = DECODE(l_transaction_id,FND_API.G_MISS_NUM,transaction_id,l_transaction_id)
6178: ,tracking_number = old_Delivery_detail_rec.tracking_number --Bug# 3632485
6179: WHERE delivery_detail_id = l_dummy_detail_id
6180: RETURNING organization_id -- Done for Workflow Project
6181: INTO l_organization_id;

Line 6244: IF (p_changed_attributes(l_Counter).transfer_lpn_id <> FND_API.G_MISS_NUM ) THEN

6240: --Bug 7307755 : No need to post weight changes to LPN records as
6241: -- WMS is taking care of populating w/v values including
6242: -- overpicked qty on LPN records.
6243: l_post_process_flag := 'Y';
6244: IF (p_changed_attributes(l_Counter).transfer_lpn_id <> FND_API.G_MISS_NUM ) THEN
6245: l_post_process_flag := 'N';
6246: END IF;
6247: --
6248: IF l_debug_on THEN

Line 6529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6525:
6526:
6527: WHEN OTHERS THEN
6528:
6529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6530: IF c_detailed_qty%ISOPEN THEN
6531: CLOSE c_detailed_qty;
6532: END IF;
6533: IF l_debug_on THEN

Line 6685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6681: WHEN OTHERS THEN
6682: IF c_get_line_details%ISOPEN THEN
6683: CLOSE c_get_line_details;
6684: END IF;
6685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6686: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.get_putaway_detail_id',l_module_name);
6687: IF l_debug_on THEN
6688: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6689: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');