APPS.GMI_UPDATE_ORDER dependencies on WSH_UTIL_CORE

Line 23: PROCEDURE process_order(P_stop_tab IN wsh_util_core.id_tab_type

19: | HAW Initianl release 115.0 |
20: +=========================================================================+
21: */
22:
23: PROCEDURE process_order(P_stop_tab IN wsh_util_core.id_tab_type
24: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
25:
26:
27: l_completion_status VARCHAR2(30) := 'NORMAL';

Line 100: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

96:
97: BEGIN
98:
99:
100: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
101: l_if_internal := 0 ;
102:
103: gmi_reservation_util.println('Value of count in OPM_ORDERS for WSH J is '||p_stop_tab.count);
104: for i in 1.. p_stop_tab.count LOOP

Line 126: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

122: gmi_reservation_util.println('Fetching c_order_line_info for l_detail_in_delivery.source_line_id'||l_detail_in_delivery.source_line_id);
123: FETCH c_order_line_info into l_order_line_info;
124: if (c_order_line_info%NOTFOUND) THEN
125: CLOSE c_order_line_info;
126: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
127: GMI_RESERVATION_UTIL.Println('Warning, Sales order not valid');
128: CLOSE c_detail_in_delivery; /* B2886561 close this cursor before return */
129: return;
130: END if;

Line 147: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

143: OPEN c_details_for_interface(l_detail_in_delivery.delivery_detail_id);
144: FETCH c_details_for_interface into l_detail_rec;
145: if c_details_for_interface%NOTFOUND then
146: CLOSE c_details_for_interface;
147: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
148: WSH_UTIL_CORE.Println('Warning, Delivery Detail ' ||l_detail_in_delivery.delivery_detail_id ||' not found');
149: IF c_detail_in_delivery%ISOPEN THEN /* B2886561 close this cursor before return */
150: CLOSE c_detail_in_delivery;
151: END IF;

Line 148: WSH_UTIL_CORE.Println('Warning, Delivery Detail ' ||l_detail_in_delivery.delivery_detail_id ||' not found');

144: FETCH c_details_for_interface into l_detail_rec;
145: if c_details_for_interface%NOTFOUND then
146: CLOSE c_details_for_interface;
147: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
148: WSH_UTIL_CORE.Println('Warning, Delivery Detail ' ||l_detail_in_delivery.delivery_detail_id ||' not found');
149: IF c_detail_in_delivery%ISOPEN THEN /* B2886561 close this cursor before return */
150: CLOSE c_detail_in_delivery;
151: END IF;
152: return;

Line 161: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

157: gmi_reservation_util.println('Going to fetch c_trip_stop for stop '||p_stop_tab(i));
158: FETCH c_trip_stop into l_trip_stop_rec;
159: if c_trip_stop%NOTFOUND then
160: CLOSE c_trip_stop;
161: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
162: WSH_UTIL_CORE.Println('Warning, Trip Stop '|| p_stop_tab(i) ||' not found');
163: IF c_detail_in_delivery%ISOPEN THEN /* B2886561 close this cursor before return */
164: CLOSE c_detail_in_delivery;
165: END IF;

Line 162: WSH_UTIL_CORE.Println('Warning, Trip Stop '|| p_stop_tab(i) ||' not found');

158: FETCH c_trip_stop into l_trip_stop_rec;
159: if c_trip_stop%NOTFOUND then
160: CLOSE c_trip_stop;
161: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
162: WSH_UTIL_CORE.Println('Warning, Trip Stop '|| p_stop_tab(i) ||' not found');
163: IF c_detail_in_delivery%ISOPEN THEN /* B2886561 close this cursor before return */
164: CLOSE c_detail_in_delivery;
165: END IF;
166: return;

Line 183: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

179: , x_msg_count => l_msg_count
180: , x_msg_data => l_msg_data
181: );
182: gmi_reservation_util.println('Finished calling GMI_Shipping_Util.create_rcv_transaction');
183: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
184: WSH_UTIL_CORE.printmsg('Warning ...');
185: WSH_UTIL_CORE.println('Failed GMI_Shipping_Util.create_rcv_transaction for delivery ID '
186: || l_detail_rec.DELIVERY_DETAIL_ID );
187: END IF;

Line 184: WSH_UTIL_CORE.printmsg('Warning ...');

180: , x_msg_data => l_msg_data
181: );
182: gmi_reservation_util.println('Finished calling GMI_Shipping_Util.create_rcv_transaction');
183: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
184: WSH_UTIL_CORE.printmsg('Warning ...');
185: WSH_UTIL_CORE.println('Failed GMI_Shipping_Util.create_rcv_transaction for delivery ID '
186: || l_detail_rec.DELIVERY_DETAIL_ID );
187: END IF;
188:

Line 185: WSH_UTIL_CORE.println('Failed GMI_Shipping_Util.create_rcv_transaction for delivery ID '

181: );
182: gmi_reservation_util.println('Finished calling GMI_Shipping_Util.create_rcv_transaction');
183: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
184: WSH_UTIL_CORE.printmsg('Warning ...');
185: WSH_UTIL_CORE.println('Failed GMI_Shipping_Util.create_rcv_transaction for delivery ID '
186: || l_detail_rec.DELIVERY_DETAIL_ID );
187: END IF;
188:
189: END IF;

Line 231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

227: END IF;
228:
229: EXCEPTION
230: WHEN rcv_inter_req_submission THEN
231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
232: gmi_reservation_util.println('Submitting Receivable Transaction failed');
233:
234:
235: END process_order;