eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_UPDATE_ORDER dependencies on GMI_RESERVATION_UTIL

Line 103: gmi_reservation_util.println('Value of count in OPM_ORDERS for WSH J is '||p_stop_tab.count);

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
105: ---FOR del IN pickup_deliveries LOOP
106: GMI_RESERVATION_UTIL.Println ('Processing Stop: '||p_stop_tab(i) );
107: OPEN pickup_deliveries(p_stop_tab(i));

Line 106: GMI_RESERVATION_UTIL.Println ('Processing Stop: '||p_stop_tab(i) );

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
105: ---FOR del IN pickup_deliveries LOOP
106: GMI_RESERVATION_UTIL.Println ('Processing Stop: '||p_stop_tab(i) );
107: OPEN pickup_deliveries(p_stop_tab(i));
108: LOOP
109: gmi_reservation_util.println('Fetching pickup_deliveries');
110: FETCH pickup_deliveries into del_rec_stop_id ;

Line 109: gmi_reservation_util.println('Fetching pickup_deliveries');

105: ---FOR del IN pickup_deliveries LOOP
106: GMI_RESERVATION_UTIL.Println ('Processing Stop: '||p_stop_tab(i) );
107: OPEN pickup_deliveries(p_stop_tab(i));
108: LOOP
109: gmi_reservation_util.println('Fetching pickup_deliveries');
110: FETCH pickup_deliveries into del_rec_stop_id ;
111: l_delivery_id := del_rec_stop_id.delivery_id;
112: EXIT WHEN pickup_deliveries%NOTFOUND;
113: GMI_RESERVATION_UTIL.Println ('Found delivery: ' || l_delivery_id);

Line 113: GMI_RESERVATION_UTIL.Println ('Found delivery: ' || l_delivery_id);

109: gmi_reservation_util.println('Fetching pickup_deliveries');
110: FETCH pickup_deliveries into del_rec_stop_id ;
111: l_delivery_id := del_rec_stop_id.delivery_id;
112: EXIT WHEN pickup_deliveries%NOTFOUND;
113: GMI_RESERVATION_UTIL.Println ('Found delivery: ' || l_delivery_id);
114: OPEN c_detail_in_delivery ;
115:
116: LOOP
117: gmi_reservation_util.println('Fetching c_detail_in_delivery');

Line 117: gmi_reservation_util.println('Fetching c_detail_in_delivery');

113: GMI_RESERVATION_UTIL.Println ('Found delivery: ' || l_delivery_id);
114: OPEN c_detail_in_delivery ;
115:
116: LOOP
117: gmi_reservation_util.println('Fetching c_detail_in_delivery');
118: FETCH c_detail_in_delivery into l_detail_in_delivery;
119: EXIT WHEN c_detail_in_delivery%NOTFOUND;
120:
121: OPEN c_order_line_info(l_detail_in_delivery.source_line_id);

Line 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);

118: FETCH c_detail_in_delivery into l_detail_in_delivery;
119: EXIT WHEN c_detail_in_delivery%NOTFOUND;
120:
121: OPEN c_order_line_info(l_detail_in_delivery.source_line_id);
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;

Line 127: GMI_RESERVATION_UTIL.Println('Warning, Sales order not valid');

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;
131: CLOSE c_order_line_info;

Line 137: gmi_reservation_util.println('It is an internal Order');

133: IF (l_order_line_info.source_document_type_id = 10
134: and INV_GMI_RSV_BRANCH.Process_Branch(l_order_line_info.ship_from_org_id) )
135: THEN /* internal order */
136: l_if_internal := 1; -- internal order
137: gmi_reservation_util.println('It is an internal Order');
138: IF nvl(l_group_id,0) = 0 THEN
139: /* only do this once */
140: select RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM DUAL;
141: END IF;

Line 142: gmi_reservation_util.println('Going to open c_details_for_interface and value of l_detail_in_delivery.delivery_detail_id is '||l_detail_in_delivery.delivery_detail_id);

138: IF nvl(l_group_id,0) = 0 THEN
139: /* only do this once */
140: select RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM DUAL;
141: END IF;
142: gmi_reservation_util.println('Going to open c_details_for_interface and value of l_detail_in_delivery.delivery_detail_id is '||l_detail_in_delivery.delivery_detail_id);
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;

Line 157: gmi_reservation_util.println('Going to fetch c_trip_stop for stop '||p_stop_tab(i));

153: end if;
154: CLOSE c_details_for_interface;
155:
156: OPEN c_trip_stop(p_stop_tab(i));
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;

Line 171: GMI_RESERVATION_UTIL.Println ('found internal order line in this delivery ' || l_delivery_id);

167: end if;
168: oe_debug_pub.add('Found Trip Stop '|| p_stop_tab(i));
169: CLOSE c_trip_stop;
170:
171: GMI_RESERVATION_UTIL.Println ('found internal order line in this delivery ' || l_delivery_id);
172: -- internal orders, insert into rcv_transactions_interface
173: gmi_reservation_util.println('Going to call GMI_SHIPPING_UTIL.create_rcv_transaction');
174: GMI_SHIPPING_UTIL.create_rcv_transaction
175: ( p_shipping_line => l_detail_rec

Line 173: gmi_reservation_util.println('Going to call GMI_SHIPPING_UTIL.create_rcv_transaction');

169: CLOSE c_trip_stop;
170:
171: GMI_RESERVATION_UTIL.Println ('found internal order line in this delivery ' || l_delivery_id);
172: -- internal orders, insert into rcv_transactions_interface
173: gmi_reservation_util.println('Going to call GMI_SHIPPING_UTIL.create_rcv_transaction');
174: GMI_SHIPPING_UTIL.create_rcv_transaction
175: ( p_shipping_line => l_detail_rec
176: , p_trip_stop_rec => l_trip_stop_rec
177: , p_group_id => l_group_id

Line 182: gmi_reservation_util.println('Finished calling GMI_Shipping_Util.create_rcv_transaction');

178: , x_return_status => l_return_status
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 );

Line 232: gmi_reservation_util.println('Submitting Receivable Transaction failed');

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;
236: