DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_DETAILS_PUB

Line 1733: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

1729: l_loaded_dock_door VARCHAR2(2000);
1730: l_delivery_count NUMBER;
1731: l_delivery_detail_ids VARCHAR2(1024);
1732:
1733: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
1734:
1735: l_index NUMBER := 1;
1736: l_return_status VARCHAR2(1);
1737: l_msg_count NUMBER;

Line 1940: wsh_delivery_details_pub.update_shipping_attributes

1936: 'LPN_SUBMIT');
1937: Debug('About to call Shipping API to update the shipped quantity','LPN_SUBMIT');
1938: END IF;
1939:
1940: wsh_delivery_details_pub.update_shipping_attributes
1941: (p_api_version_number => 1.0,
1942: p_init_msg_list => G_TRUE,
1943: p_commit => G_FALSE,
1944: x_return_status => l_return_status,

Line 1952: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1948: p_source_code => 'OE');
1949:
1950: IF l_return_status <> G_RET_STS_SUCCESS THEN
1951: IF l_debug = 1 THEN
1952: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1953: || ' with status: ' || l_return_status, 'LPN_SUBMIT');
1954: debug('l_msg_count: ' || l_msg_count,'LPN_SUBMIT');
1955: debug('l_msg_data: ' || l_msg_data,'LPN_SUBMIT');
1956: END IF;

Line 2394: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;

2390: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2391: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2392: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2393: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2394: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;
2395: l_return_Status VARCHAR2(1);
2396: l_grouping_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2397: l_del_index NUMBER;
2398: l_del_count NUMBER;

Line 2494: WSH_DELIVERY_DETAILS_PUB.detail_to_delivery

2490: IF (l_debug = 1) THEN
2491: DEBUG('The value of del_row is '||l_del_detail_id(1),'mob_ship');
2492: DEBUG('The value of del_id is '||l_open_del_ids(j),'mob_ship');
2493: END IF;
2494: WSH_DELIVERY_DETAILS_PUB.detail_to_delivery
2495: (p_api_version =>1.0
2496: ,x_return_status =>l_return_status
2497: ,x_msg_count =>l_msg_count
2498: ,x_msg_data =>l_msg_data

Line 2539: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries

2535: IF (l_debug = 1) THEN
2536: DEBUG('Calling Auto Create Deliveries - ASSIGNMENT UNSUCCESSFUL','mob_ship');
2537: END IF;
2538:
2539: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries
2540: (p_api_version_number =>1.0
2541: , p_init_msg_list =>FND_API.G_FALSE
2542: , p_commit =>FND_API.G_FALSE
2543: , x_return_status =>l_return_status

Line 2552: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries

2548: ELSIF l_open_del_ids.count =0 THEN
2549: IF (l_debug = 1) THEN
2550: DEBUG('cALLING aUTO CREATE DELIVIERIES -No open deliveries','mob_ship');
2551: END IF;
2552: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries
2553: (p_api_version_number =>1.0
2554: , p_init_msg_list =>FND_API.G_FALSE
2555: , p_commit =>FND_API.G_FALSE
2556: , x_return_status =>l_return_status

Line 5015: l_delivery_details wsh_delivery_details_pub.id_tab_type;

5011: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5012: l_planned_flag VARCHAR2(1);
5013: /* Bug: 5585359: 10/09/06 - End*/
5014:
5015: l_delivery_details wsh_delivery_details_pub.id_tab_type;
5016: l_msg_count NUMBER;
5017: l_msg_data VARCHAR2(2000);
5018: BEGIN
5019: IF g_debug IS NULL THEN

Line 5030: debug('Calling WSH_DELIVERY_DETAILS_PUB.detail_to_delivery ', 'UNASSIGN_DELIVERY_LINE');

5026: /* Bug: 5585359: 10/09/06 */
5027: l_delivery_id_tab(1) := p_delivery_id;
5028:
5029: IF l_debug = 1 THEN
5030: debug('Calling WSH_DELIVERY_DETAILS_PUB.detail_to_delivery ', 'UNASSIGN_DELIVERY_LINE');
5031: debug('delivery_detail_id : ' || p_delivery_detail_id, 'UNASSIGN_DELIVERY_LINE');
5032: debug('delivery_id : ' || p_delivery_id, 'UNASSIGN_DELIVERY_LINE');
5033: END IF;
5034: -- {{ Test a case where delivery exist before ship confirm }}

Line 5071: debug('Calling WSH_DELIVERY_DETAILS_PUB.detail_to_delivery ', 'UNASSIGN_DELIVERY_LINE');

5067: AND wda.delivery_id = wnd.delivery_id;
5068: EXCEPTION
5069: WHEN NO_DATA_FOUND THEN
5070: IF l_debug = 1 THEN
5071: debug('Calling WSH_DELIVERY_DETAILS_PUB.detail_to_delivery ', 'UNASSIGN_DELIVERY_LINE');
5072: END IF;
5073: null; -- It is OK
5074: END;
5075: END IF;

Line 5111: WSH_DELIVERY_DETAILS_PUB.detail_to_delivery

5107: debug('Unfirmed the Delivery !','UNASSIGN_DELIVERY_LINE');
5108: END IF;
5109: /* Bug: 5585359: 10/09/06 - End*/
5110:
5111: WSH_DELIVERY_DETAILS_PUB.detail_to_delivery
5112: (p_api_version => 1.0,
5113: p_init_msg_list => G_FALSE,
5114: p_commit => p_commit_flag,
5115: x_return_status => x_return_status,

Line 5122: debug('WSH_DELIVERY_DETAILS_PUB.detail_to_delivery '

5118: p_tabofdeldets => l_delivery_details,
5119: p_action => 'UNASSIGN');
5120:
5121: IF l_debug = 1 THEN
5122: debug('WSH_DELIVERY_DETAILS_PUB.detail_to_delivery '
5123: || 'return status: ' || x_return_status
5124: , 'UNASSIGN_DELIVERY_LINE');
5125:
5126: IF x_return_status <> 'S' THEN

Line 5454: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

5450: AND nvl(direct_ship_flag,'N') = 'N'
5451: AND outermost_lpn_id = p_outermost_lpn_id;
5452:
5453: l_index NUMBER;
5454: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
5455: l_return_status VARCHAR2(1);
5456: l_msg_data VARCHAR2(2000);
5457: l_msg_count NUMBER;
5458:

Line 5495: debug('About to call wsh_delivery_details_pub.update_shipping_attributes','LPN_UNLOAD');

5491: l_index := l_index + 1;
5492: END LOOP;
5493:
5494: IF l_debug = 1 THEN
5495: debug('About to call wsh_delivery_details_pub.update_shipping_attributes','LPN_UNLOAD');
5496: debug('l_detail_attributes count: ' || l_detail_attributes.COUNT,'LPN_UNLOAD');
5497: END IF;
5498:
5499: wsh_delivery_details_pub.update_shipping_attributes

Line 5499: wsh_delivery_details_pub.update_shipping_attributes

5495: debug('About to call wsh_delivery_details_pub.update_shipping_attributes','LPN_UNLOAD');
5496: debug('l_detail_attributes count: ' || l_detail_attributes.COUNT,'LPN_UNLOAD');
5497: END IF;
5498:
5499: wsh_delivery_details_pub.update_shipping_attributes
5500: (p_api_version_number => 1.0,
5501: p_init_msg_list => G_TRUE,
5502: p_commit => G_FALSE,
5503: x_return_status => l_return_status,

Line 5511: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

5507: p_source_code => 'OE');
5508:
5509: IF l_return_status <> G_RET_STS_SUCCESS THEN
5510: IF l_debug = 1 THEN
5511: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
5512: || ' with status: ' || l_return_status, 'LPN_UNLOAD');
5513: END IF;
5514: RAISE fnd_api.g_exc_unexpected_error;
5515: END IF;