[Home] [Help]
16:
17:
18: PROCEDURE DEBUG(p_message IN VARCHAR2,
19: p_module IN VARCHAR2) IS
20: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
21: BEGIN
22: if( G_Debug = TRUE ) then
23: -- inv_debug.message('wshtxn', p_message);
24: IF (l_debug = 1) THEN
39: x_return_status OUT nocopy VARCHAR2,
40: x_msg_count OUT nocopy NUMBER,
41: x_msg_data OUT nocopy varchar2) IS
42:
43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44:
45: l_entity_table WSH_FTE_COMP_CONSTRAINT_GRP.wshfte_ccin_tab_type;
46: l_return_status VARCHAR2(1);
47: l_msg_count NUMBER;
633: CONNECT BY lpn_id = PRIOR parent_lpn_id;
634:
635: l_return_status VARCHAR2(1);
636: l_delivery_id NUMBER := p_delivery_id;
637: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
638:
639: l_requested_quantity NUMBER;
640: l_requested_quantity2 NUMBER;
641: l_picked_quantity NUMBER;
840: p_shipped_quantity IN NUMBER,
841: x_return_status OUT NOCOPY VARCHAR2,
842: x_msg_data OUT NOCOPY VARCHAR2,
843: x_msg_count OUT NOCOPY NUMBER) IS
844: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
845: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
846: l_details VARCHAR2(2000);
847: BEGIN
848:
944: l_msg_data VARCHAR2(2000);
945:
946: l_bo_mode VARCHAR2(10);
947:
948: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
949: BEGIN
950: x_return_status := fnd_api.g_ret_sts_success;
951:
952: --this cursor only returns 1 record because delivery_line_id is an
1247: l_return_status VARCHAR2(1);
1248: l_msg_count NUMBER;
1249: l_msg_data VARCHAR2(2000);
1250:
1251: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1252: BEGIN
1253: x_return_status := fnd_api.g_ret_sts_success;
1254:
1255: --this cursor only returns 1 record because delivery_line_id is an
1456: p_missing_quantity IN NUMBER,
1457: x_return_status OUT NOCOPY VARCHAR2,
1458: x_msg_data OUT NOCOPY VARCHAR2,
1459: x_msg_count OUT NOCOPY NUMBER) IS
1460: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1461: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1462: l_details VARCHAR2(2000);
1463: BEGIN
1464: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1510: p_sec_missing_quantity IN NUMBER,
1511: x_return_status OUT NOCOPY VARCHAR2,
1512: x_msg_data OUT NOCOPY VARCHAR2,
1513: x_msg_count OUT NOCOPY NUMBER) IS
1514: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1515: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1516: l_details VARCHAR2(2000);
1517: BEGIN
1518: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1567: p_trackingNumber IN VARCHAR2,
1568: x_return_status OUT NOCOPY VARCHAR2,
1569: x_msg_data OUT NOCOPY VARCHAR2,
1570: x_msg_count OUT NOCOPY NUMBER ) IS
1571: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1572: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1573:
1574:
1575: l_details VARCHAR2(2000);
1692: p_trackingNumber IN VARCHAR2,
1693: x_return_status OUT NOCOPY VARCHAR2,
1694: x_msg_data OUT NOCOPY VARCHAR2,
1695: x_msg_count OUT NOCOPY NUMBER ) IS
1696: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1697: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1698:
1699:
1700: l_details VARCHAR2(2000);
1853: l_trx_src_type NUMBER;
1854: l_trx_act_id NUMBER;
1855: l_intransit_type NUMBER;
1856:
1857: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1858: BEGIN
1859: x_return_status := 'C';
1860: l_trx_type_code := -1;
1861:
1980: l_trx_src_type_id NUMBER;
1981: l_trx_act_id NUMBER;
1982: l_status_applicable VARCHAR2(1);
1983:
1984: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1985: BEGIN
1986: FOR l_detail_rec IN c_delivery_details LOOP
1987: l_trx_type_code := GET_DELIVERY_TRANSACTION_TYPE(l_detail_rec.delivery_detail_id,
1988: l_trx_src_type_id,
2400:
2401: unspec_ship_set_exists EXCEPTION;
2402: incomplete_delivery EXCEPTION;
2403:
2404: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2405: BEGIN
2406: x_return_status := FND_API.G_RET_STS_SUCCESS;
2407: x_ret_code := 0;
2408: fnd_msg_pub.initialize;
2522: x_msg_data OUT NOCOPY VARCHAR2,
2523: x_msg_count OUT NOCOPY NUMBER) IS
2524: l_error_msg VARCHAR2(2000) := NULL;
2525: unassign_lines_exc EXCEPTION;
2526: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2527: BEGIN
2528: fnd_msg_pub.initialize;
2529:
2530: INV_SHIPPING_TRANSACTION_PUB.UNASSIGN_DELIVERY_LINES(
2598:
2599:
2600: l_detail_attributes wsh_interface.ChangedAttributeTabType;
2601: l_InvPCInRecType wsh_integration.InvPCInRecType;
2602: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2603: BEGIN
2604: IF l_debug = 1 THEN
2605: debug('Entered procedure','INV_SPLIT_DELIVERY_LINE');
2606: debug('p_delivery_detail_id: ' || p_delivery_detail_id,'INV_SPLIT_DELIVERY_LINE');
2738:
2739:
2740: l_detail_attributes wsh_interface.ChangedAttributeTabType;
2741: l_InvPCInRecType wsh_integration.InvPCInRecType;
2742: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2743:
2744: --Bug No 3952081
2745: --New field to hol sec delay qty
2746: l_sec_delay_quantity NUMBER;
2915: x_enforce_ship OUT NOCOPY VARCHAR2,
2916: x_return_status OUT nocopy VARCHAR2,
2917: x_msg_data OUT nocopy VARCHAR,
2918: x_msg_count OUT nocopy NUMBER) IS
2919: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2920: l_shipping_params WSH_SHIPPING_PARAMS_GRP.Global_Params_Rec;
2921: BEGIN
2922: x_return_status := FND_API.G_RET_STS_SUCCESS;
2923:
2955: x_trip_shipmethod_meaning OUT NOCOPY VARCHAR2,
2956: x_return_status OUT NOCOPY VARCHAR2,
2957: x_msg_data OUT NOCOPY VARCHAR,
2958: x_msg_count OUT NOCOPY NUMBER) IS
2959: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2960: BEGIN
2961: IF (l_debug = 1) THEN
2962: debug('inside get_shipmethod_details ' , 'get_shipmethod_details');
2963: debug('p_org_id : ' || p_org_id, 'get_shipmethod_details');