DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_DETAILS_PUB

Line 1793: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

1789: l_loaded_dock_door VARCHAR2(2000);
1790: l_delivery_count NUMBER;
1791: l_delivery_detail_ids VARCHAR2(1024);
1792:
1793: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
1794:
1795: l_index NUMBER := 1;
1796: l_return_status VARCHAR2(1);
1797: l_msg_count NUMBER;

Line 2000: wsh_delivery_details_pub.update_shipping_attributes

1996: Debug('About to call Shipping API to update the shipped quantity','LPN_SUBMIT');
1997: END IF;
1998:
1999: IF l_detail_attributes.COUNT > 0 THEN
2000: wsh_delivery_details_pub.update_shipping_attributes
2001: (p_api_version_number => 1.0,
2002: p_init_msg_list => G_TRUE,
2003: p_commit => G_FALSE,
2004: x_return_status => l_return_status,

Line 2012: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

2008: p_source_code => 'OE');
2009:
2010: IF l_return_status <> G_RET_STS_SUCCESS THEN
2011: IF l_debug = 1 THEN
2012: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
2013: || ' with status: ' || l_return_status, 'LPN_SUBMIT');
2014: debug('l_msg_count: ' || l_msg_count,'LPN_SUBMIT');
2015: debug('l_msg_data: ' || l_msg_data,'LPN_SUBMIT');
2016: END IF;

Line 2455: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;

2451: l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2452: l_delivery_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2453: l_open_del_ids WSH_UTIL_CORE.ID_TAB_TYPE;
2454: l_new_del_id WSH_UTIL_CORE.ID_TAB_TYPE;
2455: l_del_detail_id WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE;
2456: l_return_Status VARCHAR2(1);
2457: l_grouping_rows WSH_UTIL_CORE.ID_TAB_TYPE;
2458: l_del_index NUMBER;
2459: l_del_count NUMBER;

Line 2555: WSH_DELIVERY_DETAILS_PUB.detail_to_delivery

2551: IF (l_debug = 1) THEN
2552: DEBUG('The value of del_row is '||l_del_detail_id(1),'mob_ship');
2553: DEBUG('The value of del_id is '||l_open_del_ids(j),'mob_ship');
2554: END IF;
2555: WSH_DELIVERY_DETAILS_PUB.detail_to_delivery
2556: (p_api_version =>1.0
2557: ,x_return_status =>l_return_status
2558: ,x_msg_count =>l_msg_count
2559: ,x_msg_data =>l_msg_data

Line 2600: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries

2596: IF (l_debug = 1) THEN
2597: DEBUG('Calling Auto Create Deliveries - ASSIGNMENT UNSUCCESSFUL','mob_ship');
2598: END IF;
2599:
2600: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries
2601: (p_api_version_number =>1.0
2602: , p_init_msg_list =>FND_API.G_FALSE
2603: , p_commit =>FND_API.G_FALSE
2604: , x_return_status =>l_return_status

Line 2613: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries

2609: ELSIF l_open_del_ids.count =0 THEN
2610: IF (l_debug = 1) THEN
2611: DEBUG('cALLING aUTO CREATE DELIVIERIES -No open deliveries','mob_ship');
2612: END IF;
2613: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries
2614: (p_api_version_number =>1.0
2615: , p_init_msg_list =>FND_API.G_FALSE
2616: , p_commit =>FND_API.G_FALSE
2617: , x_return_status =>l_return_status

Line 5175: l_delivery_details wsh_delivery_details_pub.id_tab_type;

5171: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5172: l_planned_flag VARCHAR2(1);
5173: /* Bug: 5585359: 10/09/06 - End*/
5174:
5175: l_delivery_details wsh_delivery_details_pub.id_tab_type;
5176: l_msg_count NUMBER;
5177: l_msg_data VARCHAR2(2000);
5178: BEGIN
5179: IF g_debug IS NULL THEN

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

5186: /* Bug: 5585359: 10/09/06 */
5187: l_delivery_id_tab(1) := p_delivery_id;
5188:
5189: IF l_debug = 1 THEN
5190: debug('Calling WSH_DELIVERY_DETAILS_PUB.detail_to_delivery ', 'UNASSIGN_DELIVERY_LINE');
5191: debug('delivery_detail_id : ' || p_delivery_detail_id, 'UNASSIGN_DELIVERY_LINE');
5192: debug('delivery_id : ' || p_delivery_id, 'UNASSIGN_DELIVERY_LINE');
5193: END IF;
5194: -- {{ Test a case where delivery exist before ship confirm }}

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

5227: AND wda.delivery_id = wnd.delivery_id;
5228: EXCEPTION
5229: WHEN NO_DATA_FOUND THEN
5230: IF l_debug = 1 THEN
5231: debug('Calling WSH_DELIVERY_DETAILS_PUB.detail_to_delivery ', 'UNASSIGN_DELIVERY_LINE');
5232: END IF;
5233: null; -- It is OK
5234: END;
5235: END IF;

Line 5271: WSH_DELIVERY_DETAILS_PUB.detail_to_delivery

5267: debug('Unfirmed the Delivery !','UNASSIGN_DELIVERY_LINE');
5268: END IF;
5269: /* Bug: 5585359: 10/09/06 - End*/
5270:
5271: WSH_DELIVERY_DETAILS_PUB.detail_to_delivery
5272: (p_api_version => 1.0,
5273: p_init_msg_list => G_FALSE,
5274: p_commit => p_commit_flag,
5275: x_return_status => x_return_status,

Line 5282: debug('WSH_DELIVERY_DETAILS_PUB.detail_to_delivery '

5278: p_tabofdeldets => l_delivery_details,
5279: p_action => 'UNASSIGN');
5280:
5281: IF l_debug = 1 THEN
5282: debug('WSH_DELIVERY_DETAILS_PUB.detail_to_delivery '
5283: || 'return status: ' || x_return_status
5284: , 'UNASSIGN_DELIVERY_LINE');
5285:
5286: IF x_return_status <> 'S' THEN

Line 5629: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

5625: AND wdd.delivery_detail_id = wstt.delivery_detail_id
5626: AND NVL(oe_dual_uom_util.get_fulfillment_base(wdd.source_line_id), 'P') = 'P';
5627:
5628: l_index NUMBER;
5629: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
5630: l_return_status VARCHAR2(1);
5631: l_msg_data VARCHAR2(2000);
5632: l_msg_count NUMBER;
5633:

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

5666: l_index := l_index + 1;
5667: END LOOP;
5668:
5669: IF l_debug = 1 THEN
5670: debug('About to call wsh_delivery_details_pub.update_shipping_attributes','LPN_UNLOAD');
5671: debug('l_detail_attributes count: ' || l_detail_attributes.COUNT,'LPN_UNLOAD');
5672: END IF;
5673:
5674: IF l_detail_attributes.COUNT > 0 THEN

Line 5675: wsh_delivery_details_pub.update_shipping_attributes

5671: debug('l_detail_attributes count: ' || l_detail_attributes.COUNT,'LPN_UNLOAD');
5672: END IF;
5673:
5674: IF l_detail_attributes.COUNT > 0 THEN
5675: wsh_delivery_details_pub.update_shipping_attributes
5676: (p_api_version_number => 1.0,
5677: p_init_msg_list => G_TRUE,
5678: p_commit => G_FALSE,
5679: x_return_status => l_return_status,

Line 5687: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

5683: p_source_code => 'OE');
5684:
5685: IF l_return_status <> G_RET_STS_SUCCESS THEN
5686: IF l_debug = 1 THEN
5687: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
5688: || ' with status: ' || l_return_status, 'LPN_UNLOAD');
5689: END IF;
5690: RAISE fnd_api.g_exc_unexpected_error;
5691: END IF;