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_PICK_RELEASE_UTIL dependencies on GMI_RESERVATION_UTIL

Line 68: GMI_Reservation_Util.PrintLn('In Get_Delivery_Details mo_line_id='||p_mo_line_id);

64:
65: /* Init Return Status */
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: GMI_Reservation_Util.PrintLn('In Get_Delivery_Details mo_line_id='||p_mo_line_id);
69:
70: OPEN c_delivery( p_mo_line_id);
71: FETCH c_delivery
72: INTO x_inv_delivery_details;

Line 82: GMI_Reservation_Util.PrintLn('In Get_Delivery_Details NO Error');

78: FND_MSG_PUB.Add;
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;
81:
82: GMI_Reservation_Util.PrintLn('In Get_Delivery_Details NO Error');
83:
84: EXCEPTION
85: WHEN FND_API.G_EXC_ERROR THEN
86: x_return_status := FND_API.G_RET_STS_ERROR;

Line 184: GMI_Reservation_Util.PrintLn('Entering Create_Pick_Slip_and_Print ');

180: AND organization_id = mo_organization_id;
181:
182:
183: BEGIN
184: GMI_Reservation_Util.PrintLn('Entering Create_Pick_Slip_and_Print ');
185:
186: SAVEPOINT Process_Pick_Slip_Number;
187:
188: /* Obtain the pick slip number for each Move Order Line Detail created */

Line 195: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print trans_id='||l_trans_id||', whse_code='||l_sub_code);

191: /* Retrieve each Move Order Line Detail and get the pick slip number for each */
192: FETCH c_mold_crs INTO l_trans_id, l_sub_code;
193: EXIT WHEN c_mold_crs%NOTFOUND;
194:
195: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print trans_id='||l_trans_id||', whse_code='||l_sub_code);
196:
197: -- Bug 1717145 : Apr-2001 odaboval replaced package GMI by WSH
198: -- (Theorically, the GMI package GMI_Pr_Pick_Slip_Number becomes useless)
199: -- HW BUG#:2009229 added new parameter x_call_mode since shipping

Line 202: gmi_reservation_util.println('Value of p_pick_slip_mode is '||p_pick_slip_mode);

198: -- (Theorically, the GMI package GMI_Pr_Pick_Slip_Number becomes useless)
199: -- HW BUG#:2009229 added new parameter x_call_mode since shipping
200: -- changed the number of paramters passed to this routine
201: l_call_mode:=NULL;
202: gmi_reservation_util.println('Value of p_pick_slip_mode is '||p_pick_slip_mode);
203: gmi_reservation_util.println('Value of p_grouping_rule_id is '||p_grouping_rule_id);
204: gmi_reservation_util.println('Value of p_mo_line_rec.organization_id is '||p_mo_line_rec.organization_id);
205: gmi_reservation_util.println('Value of p_inv_delivery_details.oe_header_id is '||p_inv_delivery_details.oe_header_id);
206: gmi_reservation_util.println('Value of p_inv_delivery_details.customer_id is '||p_inv_delivery_details.customer_id);

Line 203: gmi_reservation_util.println('Value of p_grouping_rule_id is '||p_grouping_rule_id);

199: -- HW BUG#:2009229 added new parameter x_call_mode since shipping
200: -- changed the number of paramters passed to this routine
201: l_call_mode:=NULL;
202: gmi_reservation_util.println('Value of p_pick_slip_mode is '||p_pick_slip_mode);
203: gmi_reservation_util.println('Value of p_grouping_rule_id is '||p_grouping_rule_id);
204: gmi_reservation_util.println('Value of p_mo_line_rec.organization_id is '||p_mo_line_rec.organization_id);
205: gmi_reservation_util.println('Value of p_inv_delivery_details.oe_header_id is '||p_inv_delivery_details.oe_header_id);
206: gmi_reservation_util.println('Value of p_inv_delivery_details.customer_id is '||p_inv_delivery_details.customer_id);
207: gmi_reservation_util.println('Value of p_inv_delivery_details.freight_code is '||p_inv_delivery_details.freight_code);

Line 204: gmi_reservation_util.println('Value of p_mo_line_rec.organization_id is '||p_mo_line_rec.organization_id);

200: -- changed the number of paramters passed to this routine
201: l_call_mode:=NULL;
202: gmi_reservation_util.println('Value of p_pick_slip_mode is '||p_pick_slip_mode);
203: gmi_reservation_util.println('Value of p_grouping_rule_id is '||p_grouping_rule_id);
204: gmi_reservation_util.println('Value of p_mo_line_rec.organization_id is '||p_mo_line_rec.organization_id);
205: gmi_reservation_util.println('Value of p_inv_delivery_details.oe_header_id is '||p_inv_delivery_details.oe_header_id);
206: gmi_reservation_util.println('Value of p_inv_delivery_details.customer_id is '||p_inv_delivery_details.customer_id);
207: gmi_reservation_util.println('Value of p_inv_delivery_details.freight_code is '||p_inv_delivery_details.freight_code);
208: gmi_reservation_util.println('Value of p_inv_delivery_details.ship_to_location is '||p_inv_delivery_details.ship_to_location);

Line 205: gmi_reservation_util.println('Value of p_inv_delivery_details.oe_header_id is '||p_inv_delivery_details.oe_header_id);

201: l_call_mode:=NULL;
202: gmi_reservation_util.println('Value of p_pick_slip_mode is '||p_pick_slip_mode);
203: gmi_reservation_util.println('Value of p_grouping_rule_id is '||p_grouping_rule_id);
204: gmi_reservation_util.println('Value of p_mo_line_rec.organization_id is '||p_mo_line_rec.organization_id);
205: gmi_reservation_util.println('Value of p_inv_delivery_details.oe_header_id is '||p_inv_delivery_details.oe_header_id);
206: gmi_reservation_util.println('Value of p_inv_delivery_details.customer_id is '||p_inv_delivery_details.customer_id);
207: gmi_reservation_util.println('Value of p_inv_delivery_details.freight_code is '||p_inv_delivery_details.freight_code);
208: gmi_reservation_util.println('Value of p_inv_delivery_details.ship_to_location is '||p_inv_delivery_details.ship_to_location);
209: gmi_reservation_util.println('Value of p_inv_delivery_details.shipment_priority_code is '||p_inv_delivery_details.shipment_priority_code);

Line 206: gmi_reservation_util.println('Value of p_inv_delivery_details.customer_id is '||p_inv_delivery_details.customer_id);

202: gmi_reservation_util.println('Value of p_pick_slip_mode is '||p_pick_slip_mode);
203: gmi_reservation_util.println('Value of p_grouping_rule_id is '||p_grouping_rule_id);
204: gmi_reservation_util.println('Value of p_mo_line_rec.organization_id is '||p_mo_line_rec.organization_id);
205: gmi_reservation_util.println('Value of p_inv_delivery_details.oe_header_id is '||p_inv_delivery_details.oe_header_id);
206: gmi_reservation_util.println('Value of p_inv_delivery_details.customer_id is '||p_inv_delivery_details.customer_id);
207: gmi_reservation_util.println('Value of p_inv_delivery_details.freight_code is '||p_inv_delivery_details.freight_code);
208: gmi_reservation_util.println('Value of p_inv_delivery_details.ship_to_location is '||p_inv_delivery_details.ship_to_location);
209: gmi_reservation_util.println('Value of p_inv_delivery_details.shipment_priority_code is '||p_inv_delivery_details.shipment_priority_code);
210: gmi_reservation_util.println('Value of l_sub_code is '||l_sub_code);

Line 207: gmi_reservation_util.println('Value of p_inv_delivery_details.freight_code is '||p_inv_delivery_details.freight_code);

203: gmi_reservation_util.println('Value of p_grouping_rule_id is '||p_grouping_rule_id);
204: gmi_reservation_util.println('Value of p_mo_line_rec.organization_id is '||p_mo_line_rec.organization_id);
205: gmi_reservation_util.println('Value of p_inv_delivery_details.oe_header_id is '||p_inv_delivery_details.oe_header_id);
206: gmi_reservation_util.println('Value of p_inv_delivery_details.customer_id is '||p_inv_delivery_details.customer_id);
207: gmi_reservation_util.println('Value of p_inv_delivery_details.freight_code is '||p_inv_delivery_details.freight_code);
208: gmi_reservation_util.println('Value of p_inv_delivery_details.ship_to_location is '||p_inv_delivery_details.ship_to_location);
209: gmi_reservation_util.println('Value of p_inv_delivery_details.shipment_priority_code is '||p_inv_delivery_details.shipment_priority_code);
210: gmi_reservation_util.println('Value of l_sub_code is '||l_sub_code);
211: gmi_reservation_util.println('Value of p_inv_delivery_details.trip_stop_id is '||p_inv_delivery_details.trip_stop_id);

Line 208: gmi_reservation_util.println('Value of p_inv_delivery_details.ship_to_location is '||p_inv_delivery_details.ship_to_location);

204: gmi_reservation_util.println('Value of p_mo_line_rec.organization_id is '||p_mo_line_rec.organization_id);
205: gmi_reservation_util.println('Value of p_inv_delivery_details.oe_header_id is '||p_inv_delivery_details.oe_header_id);
206: gmi_reservation_util.println('Value of p_inv_delivery_details.customer_id is '||p_inv_delivery_details.customer_id);
207: gmi_reservation_util.println('Value of p_inv_delivery_details.freight_code is '||p_inv_delivery_details.freight_code);
208: gmi_reservation_util.println('Value of p_inv_delivery_details.ship_to_location is '||p_inv_delivery_details.ship_to_location);
209: gmi_reservation_util.println('Value of p_inv_delivery_details.shipment_priority_code is '||p_inv_delivery_details.shipment_priority_code);
210: gmi_reservation_util.println('Value of l_sub_code is '||l_sub_code);
211: gmi_reservation_util.println('Value of p_inv_delivery_details.trip_stop_id is '||p_inv_delivery_details.trip_stop_id);
212: gmi_reservation_util.println('Value of p_inv_delivery_details.shipping_delivery_id is '||p_inv_delivery_details.shipping_delivery_id);

Line 209: gmi_reservation_util.println('Value of p_inv_delivery_details.shipment_priority_code is '||p_inv_delivery_details.shipment_priority_code);

205: gmi_reservation_util.println('Value of p_inv_delivery_details.oe_header_id is '||p_inv_delivery_details.oe_header_id);
206: gmi_reservation_util.println('Value of p_inv_delivery_details.customer_id is '||p_inv_delivery_details.customer_id);
207: gmi_reservation_util.println('Value of p_inv_delivery_details.freight_code is '||p_inv_delivery_details.freight_code);
208: gmi_reservation_util.println('Value of p_inv_delivery_details.ship_to_location is '||p_inv_delivery_details.ship_to_location);
209: gmi_reservation_util.println('Value of p_inv_delivery_details.shipment_priority_code is '||p_inv_delivery_details.shipment_priority_code);
210: gmi_reservation_util.println('Value of l_sub_code is '||l_sub_code);
211: gmi_reservation_util.println('Value of p_inv_delivery_details.trip_stop_id is '||p_inv_delivery_details.trip_stop_id);
212: gmi_reservation_util.println('Value of p_inv_delivery_details.shipping_delivery_id is '||p_inv_delivery_details.shipping_delivery_id);
213:

Line 210: gmi_reservation_util.println('Value of l_sub_code is '||l_sub_code);

206: gmi_reservation_util.println('Value of p_inv_delivery_details.customer_id is '||p_inv_delivery_details.customer_id);
207: gmi_reservation_util.println('Value of p_inv_delivery_details.freight_code is '||p_inv_delivery_details.freight_code);
208: gmi_reservation_util.println('Value of p_inv_delivery_details.ship_to_location is '||p_inv_delivery_details.ship_to_location);
209: gmi_reservation_util.println('Value of p_inv_delivery_details.shipment_priority_code is '||p_inv_delivery_details.shipment_priority_code);
210: gmi_reservation_util.println('Value of l_sub_code is '||l_sub_code);
211: gmi_reservation_util.println('Value of p_inv_delivery_details.trip_stop_id is '||p_inv_delivery_details.trip_stop_id);
212: gmi_reservation_util.println('Value of p_inv_delivery_details.shipping_delivery_id is '||p_inv_delivery_details.shipping_delivery_id);
213:
214: -- HAW 2837671 Check if 110509 is installed and call the correct package

Line 211: gmi_reservation_util.println('Value of p_inv_delivery_details.trip_stop_id is '||p_inv_delivery_details.trip_stop_id);

207: gmi_reservation_util.println('Value of p_inv_delivery_details.freight_code is '||p_inv_delivery_details.freight_code);
208: gmi_reservation_util.println('Value of p_inv_delivery_details.ship_to_location is '||p_inv_delivery_details.ship_to_location);
209: gmi_reservation_util.println('Value of p_inv_delivery_details.shipment_priority_code is '||p_inv_delivery_details.shipment_priority_code);
210: gmi_reservation_util.println('Value of l_sub_code is '||l_sub_code);
211: gmi_reservation_util.println('Value of p_inv_delivery_details.trip_stop_id is '||p_inv_delivery_details.trip_stop_id);
212: gmi_reservation_util.println('Value of p_inv_delivery_details.shipping_delivery_id is '||p_inv_delivery_details.shipping_delivery_id);
213:
214: -- HAW 2837671 Check if 110509 is installed and call the correct package
215: IF (wsh_code_control.get_code_release_level < '110509') THEN

Line 212: gmi_reservation_util.println('Value of p_inv_delivery_details.shipping_delivery_id is '||p_inv_delivery_details.shipping_delivery_id);

208: gmi_reservation_util.println('Value of p_inv_delivery_details.ship_to_location is '||p_inv_delivery_details.ship_to_location);
209: gmi_reservation_util.println('Value of p_inv_delivery_details.shipment_priority_code is '||p_inv_delivery_details.shipment_priority_code);
210: gmi_reservation_util.println('Value of l_sub_code is '||l_sub_code);
211: gmi_reservation_util.println('Value of p_inv_delivery_details.trip_stop_id is '||p_inv_delivery_details.trip_stop_id);
212: gmi_reservation_util.println('Value of p_inv_delivery_details.shipping_delivery_id is '||p_inv_delivery_details.shipping_delivery_id);
213:
214: -- HAW 2837671 Check if 110509 is installed and call the correct package
215: IF (wsh_code_control.get_code_release_level < '110509') THEN
216: WSH_Pr_Pick_Slip_Number.Get_Pick_Slip_Number

Line 255: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print pick_slip_number='||l_pick_slip_number||', ret_stat='||l_api_return_status);

251: , x_call_mode => l_call_mode);
252:
253: END IF; -- 2837671 End of checking release value
254:
255: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print pick_slip_number='||l_pick_slip_number||', ret_stat='||l_api_return_status);
256: IF (l_api_return_status <> FND_API.G_RET_STS_SUCCESS
257: OR l_pick_slip_number = -1)
258: THEN
259: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print Error returned by Get_Pick_Slip_Number, status='||l_api_return_status);

Line 259: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print Error returned by Get_Pick_Slip_Number, status='||l_api_return_status);

255: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print pick_slip_number='||l_pick_slip_number||', ret_stat='||l_api_return_status);
256: IF (l_api_return_status <> FND_API.G_RET_STS_SUCCESS
257: OR l_pick_slip_number = -1)
258: THEN
259: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print Error returned by Get_Pick_Slip_Number, status='||l_api_return_status);
260: ROLLBACK TO Process_Pick_Slip_Number;
261: FND_MESSAGE.SET_NAME('INV','INV_NO_PICK_SLIP_NUMBER');
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;

Line 269: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print update ic_tran_pnd with pick_slip_number='||l_pick_slip_number);

265:
266:
267:
268: /* Assign the pick slip number to the record in IC_TRAN_PND */
269: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print update ic_tran_pnd with pick_slip_number='||l_pick_slip_number);
270: UPDATE ic_tran_pnd
271: SET pick_slip_number = l_pick_slip_number
272: WHERE trans_id = l_trans_id;
273:

Line 278: GMI_Reservation_Util.PrintLn('(opm_dbg) In Create_Pick_Slip_and_Print ready_to_prt='||l_ready_to_print||', allow_partial_pick='||p_allow_partial_pick);

274: /* If the pick slip is ready to be printed (and partial picking is allowed) commit */
275:
276: /* and print at this point. */
277: -- HW BUG#:2009229 added check for l_call_mode
278: GMI_Reservation_Util.PrintLn('(opm_dbg) In Create_Pick_Slip_and_Print ready_to_prt='||l_ready_to_print||', allow_partial_pick='||p_allow_partial_pick);
279:
280: -- HW BUG#:2296620 added a check for ship_set_id
281: GMI_Reservation_Util.PrintLn('(opm_dbg) In Create_Pick_Slip_and_Print ready_to_prt='||l_ready_to_print||', allow_partial_pick='||p_allow_partial_pick);
282: IF (l_ready_to_print = FND_API.G_TRUE

Line 281: GMI_Reservation_Util.PrintLn('(opm_dbg) In Create_Pick_Slip_and_Print ready_to_prt='||l_ready_to_print||', allow_partial_pick='||p_allow_partial_pick);

277: -- HW BUG#:2009229 added check for l_call_mode
278: GMI_Reservation_Util.PrintLn('(opm_dbg) In Create_Pick_Slip_and_Print ready_to_prt='||l_ready_to_print||', allow_partial_pick='||p_allow_partial_pick);
279:
280: -- HW BUG#:2296620 added a check for ship_set_id
281: GMI_Reservation_Util.PrintLn('(opm_dbg) In Create_Pick_Slip_and_Print ready_to_prt='||l_ready_to_print||', allow_partial_pick='||p_allow_partial_pick);
282: IF (l_ready_to_print = FND_API.G_TRUE
283: AND p_allow_partial_pick = FND_API.G_TRUE
284: AND p_mo_line_rec.ship_set_id IS NULL
285: AND l_call_mode is NULL )

Line 299: GMI_Reservation_Util.PrintLn('(opm_dbg) In Create_Pick_Slip_and_Print Request_number not found for header_id='||p_mo_line_rec.header_id);

295: FETCH c_mo_header
296: INTO l_request_number;
297: IF ( c_mo_header%NOTFOUND )
298: THEN
299: GMI_Reservation_Util.PrintLn('(opm_dbg) In Create_Pick_Slip_and_Print Request_number not found for header_id='||p_mo_line_rec.header_id);
300: CLOSE c_mo_header;
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303: CLOSE c_mo_header;

Line 310: GMI_Reservation_Util.PrintLn('(opm_dbg) In Create_Pick_Slip_and_Print doc_set_id not found for request_number='||l_request_number);

306: FETCH c_doc_set
307: INTO l_report_set_id;
308: IF (c_doc_set%NOTFOUND)
309: THEN
310: GMI_Reservation_Util.PrintLn('(opm_dbg) In Create_Pick_Slip_and_Print doc_set_id not found for request_number='||l_request_number);
311: CLOSE c_doc_set;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314: CLOSE c_doc_set;

Line 316: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print call Print_Pick_Slip report_set_id='||l_report_set_id);

312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314: CLOSE c_doc_set;
315:
316: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print call Print_Pick_Slip report_set_id='||l_report_set_id);
317: -- Bug 1717145 : Apr-2001 odaboval replaced package GMI by WSH
318: -- (Theorically, the GMI package GMI_Pr_Pick_Slip_Number becomes useless)
319: WSH_Pr_Pick_Slip_Number.Print_Pick_Slip
320: ( p_pick_slip_number => l_pick_slip_number

Line 327: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print Error returned by Print_Pick_Slip, status='||l_api_return_status);

323: , x_api_status => l_api_return_status
324: , x_error_message => l_api_error_msg);
325:
326: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
327: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print Error returned by Print_Pick_Slip, status='||l_api_return_status);
328: ROLLBACK TO Process_Pick_Slip_Number;
329: FND_MESSAGE.SET_NAME('INV','INV_PRINT_PICK_SLIP_FAILED');
330: FND_MESSAGE.SET_TOKEN('PICK_SLIP_NUM', to_char(l_pick_slip_number));
331: FND_MSG_PUB.Add;

Line 335: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print before loop');

331: FND_MSG_PUB.Add;
332: RAISE FND_API.G_EXC_ERROR;
333: END IF;
334: END IF;
335: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print before loop');
336: END LOOP;
337: CLOSE c_mold_crs;
338:
339: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print NO Error');

Line 339: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print NO Error');

335: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print before loop');
336: END LOOP;
337: CLOSE c_mold_crs;
338:
339: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print NO Error');
340:
341: EXCEPTION
342: WHEN FND_API.G_EXC_ERROR THEN
343: x_return_status := FND_API.G_RET_STS_ERROR;

Line 383: AND (location <> GMI_Reservation_Util.G_DEFAULT_LOCT OR lot_id <> 0)

379: SELECT pick_slip_number
380: FROM ic_tran_pnd
381: WHERE line_id = mo_source_line_id
382: AND pick_slip_number is NOT NULL
383: AND (location <> GMI_Reservation_Util.G_DEFAULT_LOCT OR lot_id <> 0)
384: AND delete_mark = 0
385: AND completed_ind = 0
386: AND doc_type = 'OMSO';
387:

Line 440: GMI_Reservation_Util.PrintLn('IN create Manual alloc pickslip');

436: l_call_mode VARCHAR2(1);
437: l_whse_code VARCHAR2(10);
438: BEGIN
439:
440: GMI_Reservation_Util.PrintLn('IN create Manual alloc pickslip');
441: l_mo_line_rec := GMI_MOVE_ORDER_LINE_util.Query_Row( p_line_id );
442: -- Bug3294071
443: -- Modified and included the following code.
444: -- This ensures that if there is a pick slip number for

Line 496: GMI_Reservation_Util.PrintLn('WARNING: print_pick_slip_mode not defined for org_id='||p_organization_id);

492: FROM WSH_SHIPPING_PARAMETERS
493: WHERE organization_id = p_organization_id;
494: EXCEPTION
495: WHEN no_data_found THEN
496: GMI_Reservation_Util.PrintLn('WARNING: print_pick_slip_mode not defined for org_id='||p_organization_id);
497: l_print_mode := 'E';
498: END;
499:
500: OPEN mo_header_CUR(l_mo_line_rec.header_id);

Line 525: GMI_Reservation_Util.PrintLn(' Calling appropriate WSH or INV wrapper as to get the pick slip number ');

521: FND_MSG_PUB.Add;
522: RAISE FND_API.G_EXC_ERROR;
523: END IF; */
524:
525: GMI_Reservation_Util.PrintLn(' Calling appropriate WSH or INV wrapper as to get the pick slip number ');
526: IF (wsh_code_control.get_code_release_level < '110509') THEN
527: WSH_Pr_Pick_Slip_Number.Get_Pick_Slip_Number
528: ( p_ps_mode => l_print_mode
529: , p_pick_grouping_rule_id => l_grouping_rule_id

Line 566: GMI_Reservation_Util.PrintLn('In Create_Manual_alloc_pickslip pick_slip_number='||x_pick_slip_number||', ret_stat='||x_return_status);

562: , x_call_mode => l_call_mode);
563:
564: END IF; -- 2837671 End of checking release value
565:
566: GMI_Reservation_Util.PrintLn('In Create_Manual_alloc_pickslip pick_slip_number='||x_pick_slip_number||', ret_stat='||x_return_status);
567: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS
568: OR x_pick_slip_number = -1)
569: THEN
570: GMI_Reservation_Util.PrintLn('In Create_Manual_alloc_pickslip Error returned by Get_Pick_Slip_Number, status='||x_return_status);

Line 570: GMI_Reservation_Util.PrintLn('In Create_Manual_alloc_pickslip Error returned by Get_Pick_Slip_Number, status='||x_return_status);

566: GMI_Reservation_Util.PrintLn('In Create_Manual_alloc_pickslip pick_slip_number='||x_pick_slip_number||', ret_stat='||x_return_status);
567: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS
568: OR x_pick_slip_number = -1)
569: THEN
570: GMI_Reservation_Util.PrintLn('In Create_Manual_alloc_pickslip Error returned by Get_Pick_Slip_Number, status='||x_return_status);
571: ROLLBACK TO Process_Pick_Slip_Number;
572: FND_MESSAGE.SET_NAME('INV','INV_NO_PICK_SLIP_NUMBER');
573: FND_MSG_PUB.Add;
574: RAISE FND_API.G_EXC_ERROR;

Line 577: GMI_Reservation_Util.PrintLn('In Create_Manual_alloc_pickslip NO Error');

573: FND_MSG_PUB.Add;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:
577: GMI_Reservation_Util.PrintLn('In Create_Manual_alloc_pickslip NO Error');
578:
579:
580: EXCEPTION
581: WHEN FND_API.G_EXC_ERROR THEN

Line 691: GMI_Reservation_Util.PrintLn('In UPDATE_TXN_WITH_PICK_SLIP NO Error');

687: WHERE trans_id = l_trans_id;
688: END IF;
689: END IF;
690:
691: GMI_Reservation_Util.PrintLn('In UPDATE_TXN_WITH_PICK_SLIP NO Error');
692:
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;