DBA Data[Home] [Help]

APPS.WSH_ASN_RECEIPT_PVT dependencies on WSH_INBOUND_UTIL_PKG

Line 1788: -- if data is not in cache table call WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes() API.

1784: -- check if the rcv_shipment_line_id is present in the cache table for the current
1785: -- record
1786: -- if it is present, return the value from the cache table to
1787: -- p_dd_rec.shpmt_line_id_idx_tab
1788: -- if data is not in cache table call WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes() API.
1789: -- after calling WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes() API, put the value of
1790: -- rcv_shipment_line_id and the index of p_line_rec to the cache table, so that if
1791: -- another record belonging to the same rcv_shipment_line_id is encountered, then
1792: -- the p_line_rec index can be obtained from the cache table.

Line 1789: -- after calling WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes() API, put the value of

1785: -- record
1786: -- if it is present, return the value from the cache table to
1787: -- p_dd_rec.shpmt_line_id_idx_tab
1788: -- if data is not in cache table call WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes() API.
1789: -- after calling WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes() API, put the value of
1790: -- rcv_shipment_line_id and the index of p_line_rec to the cache table, so that if
1791: -- another record belonging to the same rcv_shipment_line_id is encountered, then
1792: -- the p_line_rec index can be obtained from the cache table.
1793: -- p_dd_rec.shipment_line_id_idx is the link between the two structures viz.p_line_rec

Line 1837: -- Need to derive the po information by calling WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes()

1833: --{
1834: -- rcv_shipment_line_id is present in the cache table.
1835: p_dd_rec.shpmt_line_id_idx_tab(i) := l_value;
1836: ELSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1837: -- Need to derive the po information by calling WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes()
1838: --
1839: -- Debug Statements
1840: --
1841: IF l_debug_on THEN

Line 1842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.GET_PO_RCV_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

1838: --
1839: -- Debug Statements
1840: --
1841: IF l_debug_on THEN
1842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.GET_PO_RCV_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
1843: END IF;
1844: --
1845: WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes(
1846: p_po_line_location_id => p_dd_rec.po_line_location_id_tab(i),

Line 1845: WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes(

1841: IF l_debug_on THEN
1842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.GET_PO_RCV_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
1843: END IF;
1844: --
1845: WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes(
1846: p_po_line_location_id => p_dd_rec.po_line_location_id_tab(i),
1847: p_rcv_shipment_line_id => p_dd_rec.shipment_line_id_tab(i),
1848: x_line_rec => p_line_rec,
1849: x_return_status => l_return_status);

Line 3059: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.GET_OUTERMOST_LPN',WSH_DEBUG_SV.C_PROC_LEVEL);

3055: --
3056: -- Debug Statements
3057: --
3058: IF l_debug_on THEN
3059: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.GET_OUTERMOST_LPN',WSH_DEBUG_SV.C_PROC_LEVEL);
3060: END IF;
3061: --
3062: -- Goods can me packed in multiple containers.
3063: -- So the lpn id that is passed need not necessary be the outermost lpn.

Line 3066: WSH_INBOUND_UTIL_PKG.GET_OUTERMOST_LPN(

3062: -- Goods can me packed in multiple containers.
3063: -- So the lpn id that is passed need not necessary be the outermost lpn.
3064: -- So we derive the outermost lpn using the GET_OUTERMOST_LPN API.
3065:
3066: WSH_INBOUND_UTIL_PKG.GET_OUTERMOST_LPN(
3067: p_lpn_id => l_local_dd_rec(kk).lpn_id,
3068: p_shipment_header_id => l_local_dd_rec(kk).shipment_header_id,
3069: p_lpn_context => 7,
3070: x_outermost_lpn => l_outermost_lpn,

Line 4085: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.SETTRIPSTOPSTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);

4081: --
4082: -- Debug Statements
4083: --
4084: IF l_debug_on THEN
4085: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.SETTRIPSTOPSTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
4086: END IF;
4087: --
4088: WSH_INBOUND_UTIL_PKG.setTripStopStatus(
4089: p_transaction_code => 'ASN',

Line 4088: WSH_INBOUND_UTIL_PKG.setTripStopStatus(

4084: IF l_debug_on THEN
4085: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.SETTRIPSTOPSTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
4086: END IF;
4087: --
4088: WSH_INBOUND_UTIL_PKG.setTripStopStatus(
4089: p_transaction_code => 'ASN',
4090: p_action_code => 'CANCEL',
4091: p_delivery_id_tab => l_delivery_ids,
4092: x_return_status => l_return_status);

Line 5347: --to the API WSH_INBOUND_UTIL_PKG.SPLIT_INBOUND_DELIVERY to create a new delivery

5343: --having the same Trip,Delivery ID and BOL
5344: --are considered to be a logical group.
5345: --For every such group we need to execute WSH_ASN_RECEIPT_PVT.SYNCH_BOLS
5346: --for the first group within the delivery. For the subsequent groups, a call is made
5347: --to the API WSH_INBOUND_UTIL_PKG.SPLIT_INBOUND_DELIVERY to create a new delivery
5348: --for this logical group based on the existing Delivery ID.But the calls to
5349: --above mentioned APIs are not directly made from the current Procedure, rather the API
5350: --CREATE_UPDATE_WAYBILL_PSNO_BOL takes care of the same.The variable
5351: --l_trigger is used to determine whether a logical group is the first group

Line 5853: -- If true -> Then call the the API WSH_INBOUND_UTIL_PKG.SETTRIPSTOPSTATUS to update various

5849: END LOOP;
5850: --}
5851: END IF;
5852:
5853: -- If true -> Then call the the API WSH_INBOUND_UTIL_PKG.SETTRIPSTOPSTATUS to update various
5854: -- trip stop status of the deliveries.
5855: IF temp_dels.COUNT > 0 THEN
5856:
5857: IF l_debug_on THEN

Line 5858: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.SETTRIPSTOPSTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);

5854: -- trip stop status of the deliveries.
5855: IF temp_dels.COUNT > 0 THEN
5856:
5857: IF l_debug_on THEN
5858: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.SETTRIPSTOPSTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
5859: END IF;
5860: --
5861:
5862: IF l_debug_on THEN

Line 5866: WSH_INBOUND_UTIL_PKG.setTripStopStatus(

5862: IF l_debug_on THEN
5863: WSH_DEBUG_SV.log(l_module_name,'action code to trip stop :',p_action_prms.action_code);
5864: END IF;
5865:
5866: WSH_INBOUND_UTIL_PKG.setTripStopStatus(
5867: p_transaction_code => l_local_dd_rec(1).transaction_type,
5868: p_action_code => 'APPLY',
5869: p_delivery_id_tab => temp_dels,
5870: x_return_status => l_return_status);

Line 7508: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.SPLIT_INBOUND_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

7504: --
7505: -- Debug Statements
7506: --
7507: IF l_debug_on THEN
7508: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.SPLIT_INBOUND_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
7509: END IF;
7510: --
7511: --Call to API WSH_INBOUND_UTIL_PKG.split_inbound_delivery
7512: WSH_INBOUND_UTIL_PKG.split_inbound_delivery(

Line 7511: --Call to API WSH_INBOUND_UTIL_PKG.split_inbound_delivery

7507: IF l_debug_on THEN
7508: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.SPLIT_INBOUND_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
7509: END IF;
7510: --
7511: --Call to API WSH_INBOUND_UTIL_PKG.split_inbound_delivery
7512: WSH_INBOUND_UTIL_PKG.split_inbound_delivery(
7513: p_delivery_detail_id_tbl => pack_ids,
7514: p_delivery_id => curr_del,
7515: x_delivery_id => l_new_del_id,

Line 7512: WSH_INBOUND_UTIL_PKG.split_inbound_delivery(

7508: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.SPLIT_INBOUND_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
7509: END IF;
7510: --
7511: --Call to API WSH_INBOUND_UTIL_PKG.split_inbound_delivery
7512: WSH_INBOUND_UTIL_PKG.split_inbound_delivery(
7513: p_delivery_detail_id_tbl => pack_ids,
7514: p_delivery_id => curr_del,
7515: x_delivery_id => l_new_del_id,
7516: x_return_status => l_return_status);