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.WSH_PR_PICKING_SESSION dependencies on WSH_UTIL

Line 234: WSH_UTIL.Write_Log('Starting WSH_PR_PICKING_SESSION.Init');

230: cs BINARY_INTEGER;
231:
232: BEGIN
233:
234: WSH_UTIL.Write_Log('Starting WSH_PR_PICKING_SESSION.Init');
235:
236: IF initialized = TRUE THEN
237: RETURN SUCCESS;
238: END IF;

Line 242: WSH_UTIL.Write_Log('request_id = ' || to_char(request_id));

238: END IF;
239:
240: -- initialize the WHO session variables
241: request_id := p_request_id;
242: WSH_UTIL.Write_Log('request_id = ' || to_char(request_id));
243: application_id := p_application_id;
244: WSH_UTIL.Write_Log('application_id = ' || to_char(application_id));
245: program_id := p_program_id;
246: WSH_UTIL.Write_Log('program_id = ' || to_char(program_id));

Line 244: WSH_UTIL.Write_Log('application_id = ' || to_char(application_id));

240: -- initialize the WHO session variables
241: request_id := p_request_id;
242: WSH_UTIL.Write_Log('request_id = ' || to_char(request_id));
243: application_id := p_application_id;
244: WSH_UTIL.Write_Log('application_id = ' || to_char(application_id));
245: program_id := p_program_id;
246: WSH_UTIL.Write_Log('program_id = ' || to_char(program_id));
247: user_id := p_user_id;
248: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));

Line 246: WSH_UTIL.Write_Log('program_id = ' || to_char(program_id));

242: WSH_UTIL.Write_Log('request_id = ' || to_char(request_id));
243: application_id := p_application_id;
244: WSH_UTIL.Write_Log('application_id = ' || to_char(application_id));
245: program_id := p_program_id;
246: WSH_UTIL.Write_Log('program_id = ' || to_char(program_id));
247: user_id := p_user_id;
248: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));
249: login_id := p_login_id;
250: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));

Line 248: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));

244: WSH_UTIL.Write_Log('application_id = ' || to_char(application_id));
245: program_id := p_program_id;
246: WSH_UTIL.Write_Log('program_id = ' || to_char(program_id));
247: user_id := p_user_id;
248: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));
249: login_id := p_login_id;
250: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));
251:
252:

Line 250: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));

246: WSH_UTIL.Write_Log('program_id = ' || to_char(program_id));
247: user_id := p_user_id;
248: WSH_UTIL.Write_Log('user_id = ' || to_char(user_id));
249: login_id := p_login_id;
250: WSH_UTIL.Write_Log('login_id = ' || to_char(login_id));
251:
252:
253: -- initialize other session variables
254: batch_id := p_batch_id;

Line 261: WSH_UTIL.Write_Log('Fetching release criteria for batch');

257: ELSE
258: reservations := 'N';
259: END IF;
260:
261: WSH_UTIL.Write_Log('Fetching release criteria for batch');
262:
263: -- fetch release criteria for the batch and lock row
264: OPEN get_lock_batch(p_batch_id);
265: FETCH get_lock_batch

Line 296: WSH_UTIL.Write_Log('Batch ID ' || to_char(p_batch_id) || ' does not exist.');

292: report_set_id;
293:
294: -- handle batch does not exist condition
295: IF get_lock_batch%NOTFOUND THEN
296: WSH_UTIL.Write_Log('Batch ID ' || to_char(p_batch_id) || ' does not exist.');
297: RETURN FAILURE;
298: END IF;
299:
300: IF get_lock_batch%ISOPEN THEN

Line 304: WSH_UTIL.Write_Log('Pick Release parameters are...');

300: IF get_lock_batch%ISOPEN THEN
301: CLOSE get_lock_batch;
302: END IF;
303:
304: WSH_UTIL.Write_Log('Pick Release parameters are...');
305:
306: -- set all the out variables
307: p_backorders_flag := backorders_flag;
308: WSH_UTIL.Write_Log('backorders_flag = ' || p_backorders_flag);

Line 308: WSH_UTIL.Write_Log('backorders_flag = ' || p_backorders_flag);

304: WSH_UTIL.Write_Log('Pick Release parameters are...');
305:
306: -- set all the out variables
307: p_backorders_flag := backorders_flag;
308: WSH_UTIL.Write_Log('backorders_flag = ' || p_backorders_flag);
309:
310: p_header_id := header_id;
311: WSH_UTIL.Write_Log('header_id = ' || to_char(p_header_id));
312:

Line 311: WSH_UTIL.Write_Log('header_id = ' || to_char(p_header_id));

307: p_backorders_flag := backorders_flag;
308: WSH_UTIL.Write_Log('backorders_flag = ' || p_backorders_flag);
309:
310: p_header_id := header_id;
311: WSH_UTIL.Write_Log('header_id = ' || to_char(p_header_id));
312:
313: p_ship_set_number := ship_set_number;
314: WSH_UTIL.Write_Log('ship_set_number = ' || to_char(p_ship_set_number));
315:

Line 314: WSH_UTIL.Write_Log('ship_set_number = ' || to_char(p_ship_set_number));

310: p_header_id := header_id;
311: WSH_UTIL.Write_Log('header_id = ' || to_char(p_header_id));
312:
313: p_ship_set_number := ship_set_number;
314: WSH_UTIL.Write_Log('ship_set_number = ' || to_char(p_ship_set_number));
315:
316: p_order_type_id := order_type_id;
317: WSH_UTIL.Write_Log('order_type_id = ' || to_char(p_order_type_id));
318:

Line 317: WSH_UTIL.Write_Log('order_type_id = ' || to_char(p_order_type_id));

313: p_ship_set_number := ship_set_number;
314: WSH_UTIL.Write_Log('ship_set_number = ' || to_char(p_ship_set_number));
315:
316: p_order_type_id := order_type_id;
317: WSH_UTIL.Write_Log('order_type_id = ' || to_char(p_order_type_id));
318:
319: p_warehouse_id := warehouse_id;
320: WSH_UTIL.Write_Log('warehouse_id = ' || to_char(p_warehouse_id));
321:

Line 320: WSH_UTIL.Write_Log('warehouse_id = ' || to_char(p_warehouse_id));

316: p_order_type_id := order_type_id;
317: WSH_UTIL.Write_Log('order_type_id = ' || to_char(p_order_type_id));
318:
319: p_warehouse_id := warehouse_id;
320: WSH_UTIL.Write_Log('warehouse_id = ' || to_char(p_warehouse_id));
321:
322: p_customer_id := customer_id;
323: WSH_UTIL.Write_Log('customer_id = ' || to_char(p_customer_id));
324:

Line 323: WSH_UTIL.Write_Log('customer_id = ' || to_char(p_customer_id));

319: p_warehouse_id := warehouse_id;
320: WSH_UTIL.Write_Log('warehouse_id = ' || to_char(p_warehouse_id));
321:
322: p_customer_id := customer_id;
323: WSH_UTIL.Write_Log('customer_id = ' || to_char(p_customer_id));
324:
325: p_ship_site_use_id := ship_site_use_id;
326: WSH_UTIL.Write_Log('ship_site_use_id = ' || to_char(p_ship_site_use_id));
327:

Line 326: WSH_UTIL.Write_Log('ship_site_use_id = ' || to_char(p_ship_site_use_id));

322: p_customer_id := customer_id;
323: WSH_UTIL.Write_Log('customer_id = ' || to_char(p_customer_id));
324:
325: p_ship_site_use_id := ship_site_use_id;
326: WSH_UTIL.Write_Log('ship_site_use_id = ' || to_char(p_ship_site_use_id));
327:
328: p_shipment_priority := shipment_priority;
329: WSH_UTIL.Write_Log('shipment_priority = ' || p_shipment_priority);
330:

Line 329: WSH_UTIL.Write_Log('shipment_priority = ' || p_shipment_priority);

325: p_ship_site_use_id := ship_site_use_id;
326: WSH_UTIL.Write_Log('ship_site_use_id = ' || to_char(p_ship_site_use_id));
327:
328: p_shipment_priority := shipment_priority;
329: WSH_UTIL.Write_Log('shipment_priority = ' || p_shipment_priority);
330:
331: p_ship_method_code := ship_method_code;
332: WSH_UTIL.Write_Log('ship_method_code = ' || p_ship_method_code);
333:

Line 332: WSH_UTIL.Write_Log('ship_method_code = ' || p_ship_method_code);

328: p_shipment_priority := shipment_priority;
329: WSH_UTIL.Write_Log('shipment_priority = ' || p_shipment_priority);
330:
331: p_ship_method_code := ship_method_code;
332: WSH_UTIL.Write_Log('ship_method_code = ' || p_ship_method_code);
333:
334: p_from_request_date := to_char(from_request_date, 'YYYY/MM/DD HH24:MI:SS');
335: WSH_UTIL.Write_Log('from_request_date = ' || p_from_request_date);
336:

Line 335: WSH_UTIL.Write_Log('from_request_date = ' || p_from_request_date);

331: p_ship_method_code := ship_method_code;
332: WSH_UTIL.Write_Log('ship_method_code = ' || p_ship_method_code);
333:
334: p_from_request_date := to_char(from_request_date, 'YYYY/MM/DD HH24:MI:SS');
335: WSH_UTIL.Write_Log('from_request_date = ' || p_from_request_date);
336:
337: p_to_request_date := to_char(to_request_date, 'YYYY/MM/DD HH24:MI:SS');
338: WSH_UTIL.Write_Log('to_request_date = ' || p_to_request_date);
339:

Line 338: WSH_UTIL.Write_Log('to_request_date = ' || p_to_request_date);

334: p_from_request_date := to_char(from_request_date, 'YYYY/MM/DD HH24:MI:SS');
335: WSH_UTIL.Write_Log('from_request_date = ' || p_from_request_date);
336:
337: p_to_request_date := to_char(to_request_date, 'YYYY/MM/DD HH24:MI:SS');
338: WSH_UTIL.Write_Log('to_request_date = ' || p_to_request_date);
339:
340: p_from_sched_ship_date := to_char(from_sched_ship_date, 'YYYY/MM/DD HH24:MI:SS');
341: WSH_UTIL.Write_Log('from_sched_ship_date = ' || p_from_sched_ship_date);
342:

Line 341: WSH_UTIL.Write_Log('from_sched_ship_date = ' || p_from_sched_ship_date);

337: p_to_request_date := to_char(to_request_date, 'YYYY/MM/DD HH24:MI:SS');
338: WSH_UTIL.Write_Log('to_request_date = ' || p_to_request_date);
339:
340: p_from_sched_ship_date := to_char(from_sched_ship_date, 'YYYY/MM/DD HH24:MI:SS');
341: WSH_UTIL.Write_Log('from_sched_ship_date = ' || p_from_sched_ship_date);
342:
343: p_to_sched_ship_date := to_char(to_sched_ship_date, 'YYYY/MM/DD HH24:MI:SS');
344: WSH_UTIL.Write_Log('to_sched_ship_date = ' || p_to_sched_ship_date);
345:

Line 344: WSH_UTIL.Write_Log('to_sched_ship_date = ' || p_to_sched_ship_date);

340: p_from_sched_ship_date := to_char(from_sched_ship_date, 'YYYY/MM/DD HH24:MI:SS');
341: WSH_UTIL.Write_Log('from_sched_ship_date = ' || p_from_sched_ship_date);
342:
343: p_to_sched_ship_date := to_char(to_sched_ship_date, 'YYYY/MM/DD HH24:MI:SS');
344: WSH_UTIL.Write_Log('to_sched_ship_date = ' || p_to_sched_ship_date);
345:
346: p_existing_rsvs_only_flag := existing_rsvs_only_flag;
347: WSH_UTIL.Write_Log('existing_rsvs_only_flag = ' || p_existing_rsvs_only_flag);
348:

Line 347: WSH_UTIL.Write_Log('existing_rsvs_only_flag = ' || p_existing_rsvs_only_flag);

343: p_to_sched_ship_date := to_char(to_sched_ship_date, 'YYYY/MM/DD HH24:MI:SS');
344: WSH_UTIL.Write_Log('to_sched_ship_date = ' || p_to_sched_ship_date);
345:
346: p_existing_rsvs_only_flag := existing_rsvs_only_flag;
347: WSH_UTIL.Write_Log('existing_rsvs_only_flag = ' || p_existing_rsvs_only_flag);
348:
349: p_subinventory := subinventory;
350: WSH_UTIL.Write_Log('subinventory = ' || p_subinventory);
351:

Line 350: WSH_UTIL.Write_Log('subinventory = ' || p_subinventory);

346: p_existing_rsvs_only_flag := existing_rsvs_only_flag;
347: WSH_UTIL.Write_Log('existing_rsvs_only_flag = ' || p_existing_rsvs_only_flag);
348:
349: p_subinventory := subinventory;
350: WSH_UTIL.Write_Log('subinventory = ' || p_subinventory);
351:
352: p_inventory_item_id := inventory_item_id;
353: WSH_UTIL.Write_Log('inventory_item_id = ' || to_char(p_inventory_item_id));
354:

Line 353: WSH_UTIL.Write_Log('inventory_item_id = ' || to_char(p_inventory_item_id));

349: p_subinventory := subinventory;
350: WSH_UTIL.Write_Log('subinventory = ' || p_subinventory);
351:
352: p_inventory_item_id := inventory_item_id;
353: WSH_UTIL.Write_Log('inventory_item_id = ' || to_char(p_inventory_item_id));
354:
355: p_departure_id := departure_id;
356: WSH_UTIL.Write_Log('departure_id = ' || to_char(p_departure_id));
357:

Line 356: WSH_UTIL.Write_Log('departure_id = ' || to_char(p_departure_id));

352: p_inventory_item_id := inventory_item_id;
353: WSH_UTIL.Write_Log('inventory_item_id = ' || to_char(p_inventory_item_id));
354:
355: p_departure_id := departure_id;
356: WSH_UTIL.Write_Log('departure_id = ' || to_char(p_departure_id));
357:
358: p_delivery_id := delivery_id;
359: WSH_UTIL.Write_Log('delivery_id = ' || to_char(p_delivery_id));
360:

Line 359: WSH_UTIL.Write_Log('delivery_id = ' || to_char(p_delivery_id));

355: p_departure_id := departure_id;
356: WSH_UTIL.Write_Log('departure_id = ' || to_char(p_departure_id));
357:
358: p_delivery_id := delivery_id;
359: WSH_UTIL.Write_Log('delivery_id = ' || to_char(p_delivery_id));
360:
361: p_pick_slip_rule_id := pick_slip_rule_id;
362: WSH_UTIL.Write_Log('pick_slip_rule_id = ' || to_char(p_pick_slip_rule_id));
363:

Line 362: WSH_UTIL.Write_Log('pick_slip_rule_id = ' || to_char(p_pick_slip_rule_id));

358: p_delivery_id := delivery_id;
359: WSH_UTIL.Write_Log('delivery_id = ' || to_char(p_delivery_id));
360:
361: p_pick_slip_rule_id := pick_slip_rule_id;
362: WSH_UTIL.Write_Log('pick_slip_rule_id = ' || to_char(p_pick_slip_rule_id));
363:
364: p_release_seq_rule_id := release_seq_rule_id;
365: WSH_UTIL.Write_Log('release_seq_rule_id = ' || to_char(p_release_seq_rule_id));
366:

Line 365: WSH_UTIL.Write_Log('release_seq_rule_id = ' || to_char(p_release_seq_rule_id));

361: p_pick_slip_rule_id := pick_slip_rule_id;
362: WSH_UTIL.Write_Log('pick_slip_rule_id = ' || to_char(p_pick_slip_rule_id));
363:
364: p_release_seq_rule_id := release_seq_rule_id;
365: WSH_UTIL.Write_Log('release_seq_rule_id = ' || to_char(p_release_seq_rule_id));
366:
367: p_report_set_id := report_set_id;
368: WSH_UTIL.Write_Log('report_set_id = ' || to_char(p_report_set_id));
369:

Line 368: WSH_UTIL.Write_Log('report_set_id = ' || to_char(p_report_set_id));

364: p_release_seq_rule_id := release_seq_rule_id;
365: WSH_UTIL.Write_Log('release_seq_rule_id = ' || to_char(p_release_seq_rule_id));
366:
367: p_report_set_id := report_set_id;
368: WSH_UTIL.Write_Log('report_set_id = ' || to_char(p_report_set_id));
369:
370: p_include_planned_lines := include_planned_lines;
371: WSH_UTIL.Write_Log('include_planned_lines = ' || p_include_planned_lines);
372:

Line 371: WSH_UTIL.Write_Log('include_planned_lines = ' || p_include_planned_lines);

367: p_report_set_id := report_set_id;
368: WSH_UTIL.Write_Log('report_set_id = ' || to_char(p_report_set_id));
369:
370: p_include_planned_lines := include_planned_lines;
371: WSH_UTIL.Write_Log('include_planned_lines = ' || p_include_planned_lines);
372:
373: p_partial_allowed_flag := partial_allowed_flag;
374: WSH_UTIL.Write_Log('partial_allowed_flag = ' || p_partial_allowed_flag);
375:

Line 374: WSH_UTIL.Write_Log('partial_allowed_flag = ' || p_partial_allowed_flag);

370: p_include_planned_lines := include_planned_lines;
371: WSH_UTIL.Write_Log('include_planned_lines = ' || p_include_planned_lines);
372:
373: p_partial_allowed_flag := partial_allowed_flag;
374: WSH_UTIL.Write_Log('partial_allowed_flag = ' || p_partial_allowed_flag);
375:
376: WSH_UTIL.Write_Log('autocreate_delivery_flag = ' || autocreate_deliveries);
377:
378: WSH_UTIL.Write_Log('order_line_id = ' || order_line_id);

Line 376: WSH_UTIL.Write_Log('autocreate_delivery_flag = ' || autocreate_deliveries);

372:
373: p_partial_allowed_flag := partial_allowed_flag;
374: WSH_UTIL.Write_Log('partial_allowed_flag = ' || p_partial_allowed_flag);
375:
376: WSH_UTIL.Write_Log('autocreate_delivery_flag = ' || autocreate_deliveries);
377:
378: WSH_UTIL.Write_Log('order_line_id = ' || order_line_id);
379:
380: --

Line 378: WSH_UTIL.Write_Log('order_line_id = ' || order_line_id);

374: WSH_UTIL.Write_Log('partial_allowed_flag = ' || p_partial_allowed_flag);
375:
376: WSH_UTIL.Write_Log('autocreate_delivery_flag = ' || autocreate_deliveries);
377:
378: WSH_UTIL.Write_Log('order_line_id = ' || order_line_id);
379:
380: --
381: -- Validating order_line_id
382: --

Line 392: WSH_UTIL.Write_Log('Order Line ID ' || to_char(order_line_id) || 'does not exist');

388: INTO v_header_id,
389: v_parent_line_id;
390:
391: IF get_line_info%NOTFOUND THEN
392: WSH_UTIL.Write_Log('Order Line ID ' || to_char(order_line_id) || 'does not exist');
393: RETURN FAILURE;
394: END IF;
395:
396: IF v_header_id <> header_id THEN

Line 397: WSH_UTIL.Write_Log('Order Line ID ' || to_char(order_line_id) || 'does not belong to');

393: RETURN FAILURE;
394: END IF;
395:
396: IF v_header_id <> header_id THEN
397: WSH_UTIL.Write_Log('Order Line ID ' || to_char(order_line_id) || 'does not belong to');
398: WSH_UTIL.Write_Log('Order Header ID ' || to_char(header_id));
399: RETURN FAILURE;
400: END IF;
401:

Line 398: WSH_UTIL.Write_Log('Order Header ID ' || to_char(header_id));

394: END IF;
395:
396: IF v_header_id <> header_id THEN
397: WSH_UTIL.Write_Log('Order Line ID ' || to_char(order_line_id) || 'does not belong to');
398: WSH_UTIL.Write_Log('Order Header ID ' || to_char(header_id));
399: RETURN FAILURE;
400: END IF;
401:
402: IF v_parent_line_id <> -1 THEN

Line 403: WSH_UTIL.Write_Log('Order Line ID ' || to_char(order_line_id) || 'is not a top model line');

399: RETURN FAILURE;
400: END IF;
401:
402: IF v_parent_line_id <> -1 THEN
403: WSH_UTIL.Write_Log('Order Line ID ' || to_char(order_line_id) || 'is not a top model line');
404: RETURN FAILURE;
405: END IF;
406:
407: IF get_line_info%ISOPEN THEN

Line 418: WSH_UTIL.Write_Log('Warehouse is not available for this batch.');

414: -- If warehouse id is NULL (-1), must error out here since Pick Release
415: -- is warehouse specific.
416: --
417: IF p_warehouse_id = -1 THEN
418: WSH_UTIL.Write_Log('Warehouse is not available for this batch.');
419: WSH_UTIL.Write_Log('Cannot release batch.');
420: RETURN FAILURE;
421: END IF;
422:

Line 419: WSH_UTIL.Write_Log('Cannot release batch.');

415: -- is warehouse specific.
416: --
417: IF p_warehouse_id = -1 THEN
418: WSH_UTIL.Write_Log('Warehouse is not available for this batch.');
419: WSH_UTIL.Write_Log('Cannot release batch.');
420: RETURN FAILURE;
421: END IF;
422:
423: WSH_UTIL.Write_Log('Fetching release sequence rule information for the batch');

Line 423: WSH_UTIL.Write_Log('Fetching release sequence rule information for the batch');

419: WSH_UTIL.Write_Log('Cannot release batch.');
420: RETURN FAILURE;
421: END IF;
422:
423: WSH_UTIL.Write_Log('Fetching release sequence rule information for the batch');
424:
425: -- fetch release sequence rule parameters
426: OPEN rel_seq_rule(release_seq_rule_id);
427: FETCH rel_seq_rule

Line 442: WSH_UTIL.Write_Log('Release sequence rule ID ' || to_char(release_seq_rule_id) || ' does not exist.');

438: departure_sort;
439:
440: -- handle release sequence rule does not exist
441: IF rel_seq_rule%NOTFOUND THEN
442: WSH_UTIL.Write_Log('Release sequence rule ID ' || to_char(release_seq_rule_id) || ' does not exist.');
443: RETURN FAILURE;
444: END IF;
445: IF rel_seq_rule%ISOPEN THEN
446: CLOSE rel_seq_rule;

Line 506: WSH_UTIL.Write_Log('Primary release rule is ' || primary_rsr);

502: END LOOP;
503:
504: -- determine the most significant release sequence rule attribute
505: primary_rsr := ordered_rsr(1).attribute_name;
506: WSH_UTIL.Write_Log('Primary release rule is ' || primary_rsr);
507:
508: -- print release sequence rule information for debugging purposes
509: FOR i IN 1..total_release_criteria LOOP
510: WSH_UTIL.Write_Log('attribute = ' || ordered_rsr(i).attribute_name || ' ' ||

Line 510: WSH_UTIL.Write_Log('attribute = ' || ordered_rsr(i).attribute_name || ' ' ||

506: WSH_UTIL.Write_Log('Primary release rule is ' || primary_rsr);
507:
508: -- print release sequence rule information for debugging purposes
509: FOR i IN 1..total_release_criteria LOOP
510: WSH_UTIL.Write_Log('attribute = ' || ordered_rsr(i).attribute_name || ' ' ||
511: 'priority = ' || to_char(ordered_rsr(i).priority) || ' ' ||
512: 'sort = ' || ordered_rsr(i).sort_order );
513: END LOOP;
514:

Line 515: WSH_UTIL.Write_Log('Determining if order number is in grouping rule...');

511: 'priority = ' || to_char(ordered_rsr(i).priority) || ' ' ||
512: 'sort = ' || ordered_rsr(i).sort_order );
513: END LOOP;
514:
515: WSH_UTIL.Write_Log('Determining if order number is in grouping rule...');
516: OPEN order_ps_group(pick_slip_rule_id);
517: FETCH order_ps_group
518: INTO use_order_ps;
519: IF order_ps_group%NOTFOUND THEN

Line 526: WSH_UTIL.Write_Log('Determining print pick slip parameter...');

522: IF order_ps_group%ISOPEN THEN
523: CLOSE order_ps_group;
524: END IF;
525:
526: WSH_UTIL.Write_Log('Determining print pick slip parameter...');
527:
528: -- Use warehouse_id and not org_id, as the Shipping Parameters table
529: -- is Warehouse (i.e. Organization ID) specific, and not specific
530: -- to any Operating Unit/Org

Line 544: WSH_UTIL.Write_Log('Print Pick slip mode is Immediate');

540:
541: IF ((ordered_rsr(1).attribute IN (C_INVOICE_VALUE, C_ORDER_NUMBER))
542: AND (print_ps_mode_param = 'I') AND (use_order_ps = 'Y')) THEN
543: print_ps_mode := IMMEDIATE_PRINT_PS;
544: WSH_UTIL.Write_Log('Print Pick slip mode is Immediate');
545: ELSE
546: print_ps_mode := DEFERRED_PRINT_PS;
547: WSH_UTIL.Write_Log('Print Pick slip mode is Deferred');
548: END IF;

Line 547: WSH_UTIL.Write_Log('Print Pick slip mode is Deferred');

543: print_ps_mode := IMMEDIATE_PRINT_PS;
544: WSH_UTIL.Write_Log('Print Pick slip mode is Immediate');
545: ELSE
546: print_ps_mode := DEFERRED_PRINT_PS;
547: WSH_UTIL.Write_Log('Print Pick slip mode is Deferred');
548: END IF;
549:
550: p_print_ps_mode := print_ps_mode;
551:

Line 552: WSH_UTIL.Write_Log('Updating request id for batch');

548: END IF;
549:
550: p_print_ps_mode := print_ps_mode;
551:
552: WSH_UTIL.Write_Log('Updating request id for batch');
553:
554: -- Update picking batch setting request id and other who parameters
555:
556: -- Use the parameters passed to the Init Function, instead of using the

Line 572: WSH_UTIL.Write_Log('Picking Batch ' || to_char(p_batch_id) || ' does not exist ');

568: WHERE BATCH_ID = p_batch_id
569: AND (REQUEST_ID IS NULL OR REQUEST_ID = p_request_id);
570:
571: IF SQL%NOTFOUND THEN
572: WSH_UTIL.Write_Log('Picking Batch ' || to_char(p_batch_id) || ' does not exist ');
573: WSH_UTIL.Write_Log('or another pick release request has already released this batch');
574: END IF;
575:
576: -- package WSH_PR_PICKING_SESSION has been initialized

Line 573: WSH_UTIL.Write_Log('or another pick release request has already released this batch');

569: AND (REQUEST_ID IS NULL OR REQUEST_ID = p_request_id);
570:
571: IF SQL%NOTFOUND THEN
572: WSH_UTIL.Write_Log('Picking Batch ' || to_char(p_batch_id) || ' does not exist ');
573: WSH_UTIL.Write_Log('or another pick release request has already released this batch');
574: END IF;
575:
576: -- package WSH_PR_PICKING_SESSION has been initialized
577: initialized := TRUE;

Line 584: WSH_UTIL.Write_Log('Could not lock Batch ID ' || to_char(p_batch_id) || ' for update.');

580:
581: EXCEPTION
582: -- handle unable to lock situation
583: WHEN record_locked THEN
584: WSH_UTIL.Write_Log('Could not lock Batch ID ' || to_char(p_batch_id) || ' for update.');
585: RETURN FAILURE;
586:
587: -- handle other errors
588: WHEN OTHERS THEN

Line 605: WSH_UTIL.Default_Handler('WSH_PR_PICKING_SESSION.Init','');

601: IF ps_mode_param%ISOPEN THEN
602: CLOSE ps_mode_param;
603: END IF;
604:
605: WSH_UTIL.Default_Handler('WSH_PR_PICKING_SESSION.Init','');
606: RETURN FAILURE;
607:
608: END Init;
609:

Line 690: WSH_UTIL.Write_Log('No Document Set specified');

686: END IF;
687:
688: -- Validate Document Set
689: IF p_doc_set IS NULL THEN
690: WSH_UTIL.Write_Log('No Document Set specified');
691: ELSE
692: OPEN doc_set(to_number(p_doc_set));
693: FETCH doc_set INTO count_temp;
694: IF doc_set%NOTFOUND THEN

Line 695: WSH_UTIL.Write_Log('The document set ' || p_doc_set || ' is not in valid period');

691: ELSE
692: OPEN doc_set(to_number(p_doc_set));
693: FETCH doc_set INTO count_temp;
694: IF doc_set%NOTFOUND THEN
695: WSH_UTIL.Write_Log('The document set ' || p_doc_set || ' is not in valid period');
696: ELSE
697: WSH_UTIL.Write_Log('The document set is valid');
698: END IF;
699: END IF;

Line 697: WSH_UTIL.Write_Log('The document set is valid');

693: FETCH doc_set INTO count_temp;
694: IF doc_set%NOTFOUND THEN
695: WSH_UTIL.Write_Log('The document set ' || p_doc_set || ' is not in valid period');
696: ELSE
697: WSH_UTIL.Write_Log('The document set is valid');
698: END IF;
699: END IF;
700:
701: -- Validate Picking Rule

Line 706: WSH_UTIL.Write_Log('The picking rule '|| p_rule_name ||

702:
703: OPEN pick_rule(p_rule_name);
704: FETCH pick_rule INTO count_temp;
705: IF pick_rule%NOTFOUND THEN
706: WSH_UTIL.Write_Log('The picking rule '|| p_rule_name ||
707: ' does not exist or has expired');
708: RETURN FAILURE;
709: END IF;
710:

Line 741: WSH_UTIL.Write_Log('Checking batch name ' || x_batch_name);

737: x_batch_name := p_batch_prefix || '-' || to_char(x_batch_id);
738: END IF;
739:
740: -- Check if batch already exists with this name
741: WSH_UTIL.Write_Log('Checking batch name ' || x_batch_name);
742: SELECT COUNT(*)
743: INTO count_temp
744: FROM SO_PICKING_BATCHES_ALL
745: WHERE NAME = x_batch_name;

Line 823: WSH_UTIL.Write_Log('Inserted batch name ' || x_batch_name

819: operating_org -- Insert Operating Org
820: FROM SO_PICKING_RULES
821: WHERE PICKING_RULE = p_rule_name;
822:
823: WSH_UTIL.Write_Log('Inserted batch name ' || x_batch_name
824: || ' with batch_id ' ||
825: to_char(p_new_batch_id));
826:
827: RETURN SUCCESS;

Line 831: WSH_UTIL.Default_Handler('WSH_PR_PICKING_SESSION.Launc_Doc_Set','');

827: RETURN SUCCESS;
828:
829: EXCEPTION
830: WHEN OTHERS THEN
831: WSH_UTIL.Default_Handler('WSH_PR_PICKING_SESSION.Launc_Doc_Set','');
832: RETURN FAILURE;
833:
834: END SRS_Picking_Batch;
835:

Line 860: WSH_UTIL.Write_Log('The package must be initialized before use');

856:
857: BEGIN
858: -- handle uninitialized package errors here
859: IF initialized = FALSE THEN
860: WSH_UTIL.Write_Log('The package must be initialized before use');
861: RETURN FAILURE;
862: END IF;
863:
864: IF unreleased_SQL IS NULL THEN

Line 898: WSH_UTIL.Write_Log('The package must be initialized before use');

894:
895: BEGIN
896: -- handle uninitialized package errors here
897: IF initialized = FALSE THEN
898: WSH_UTIL.Write_Log('The package must be initialized before use');
899: RETURN FAILURE;
900: END IF;
901:
902: IF backordered_SQL IS NULL THEN

Line 936: WSH_UTIL.Write_Log('The package must be initialized before use');

932:
933: BEGIN
934: -- handle uninitialized package errors here
935: IF initialized = FALSE THEN
936: WSH_UTIL.Write_Log('The package must be initialized before use');
937: RETURN FAILURE;
938: END IF;
939:
940: cs := Construct_SQL('SYNC');

Line 972: WSH_UTIL.Write_Log('The package must be initialized before use');

968:
969: BEGIN
970: -- handle uninitialized package errors here
971: IF initialized = FALSE THEN
972: WSH_UTIL.Write_Log('The package must be initialized before use');
973: RETURN FAILURE;
974: END IF;
975:
976: cs := Construct_SQL('NON_SHIPPABLE');

Line 1179: WSH_UTIL.Write_Log(orderby_SQL);

1175: Process_Buffer('u', ' OR (NVL(LD.DEP_PLAN_REQUIRED_FLAG,''N'') = ''N'')) ');
1176:
1177: -- Determine the order by clause
1178: orderby_SQL := ' ORDER BY ';
1179: WSH_UTIL.Write_Log(orderby_SQL);
1180:
1181: FOR i IN 1..total_release_criteria LOOP
1182: IF (ordered_rsr(i).attribute = C_INVOICE_VALUE) THEN
1183: Process_Buffer('o', ' WSH_PR_CUSTOM.OUTSTANDING_ORDER_VALUE(H.HEADER_ID) ' || ordered_rsr(i).sort_order || ', ');

Line 1372: WSH_UTIL.Write_Log(orderby_SQL);

1368: Process_Buffer('b', ' OR (NVL(PL.DEP_PLAN_REQUIRED_FLAG,''N'') = ''N'')) ');
1369:
1370: -- Determine the order by clause
1371: orderby_SQL := ' ORDER BY ';
1372: WSH_UTIL.Write_Log(orderby_SQL);
1373:
1374: FOR i IN 1..total_release_criteria LOOP
1375: IF (ordered_rsr(i).attribute = C_INVOICE_VALUE) THEN
1376: Process_Buffer('o', ' WSH_PR_CUSTOM.OUTSTANDING_ORDER_VALUE(H.HEADER_ID) ' || ordered_rsr(i).sort_order || ', ');

Line 1669: WSH_UTIL.Write_Log('Invalid parameter');

1665: Process_Buffer('sreq', ' to_date(:X_from_sched_ship_date,''YYYY/MM/DD HH24:MI:SS'') OR :X_from_sched_ship_date IS NULL) ');
1666: Process_Buffer('sreq', ' AND (NVL(LD.SCHEDULE_DATE,to_date(:X_to_sched_ship_date,''YYYY/MM/DD HH24:MI:SS'')) <= ');
1667: Process_Buffer('sreq', ' to_date(:X_to_sched_ship_date,''YYYY/MM/DD HH24:MI:SS'') OR :X_to_sched_ship_date IS NULL)) ');
1668: ELSE
1669: WSH_UTIL.Write_Log('Invalid parameter');
1670: RETURN FAILURE;
1671: END IF;
1672:
1673: RETURN SUCCESS;

Line 1850: WSH_UTIL.Write_Log(p_buffer_text);

1846:
1847: cs BINARY_INTEGER;
1848:
1849: BEGIN
1850: WSH_UTIL.Write_Log(p_buffer_text);
1851: IF p_buffer_name = 'u' THEN
1852: Unreleased_SQL := Unreleased_SQL || p_buffer_text;
1853: ELSIF p_buffer_name = 'b' THEN
1854: Backordered_SQL := Backordered_SQL || p_buffer_text;

Line 1903: WSH_UTIL.Write_Log('Error in WSH_DOC_SETS.Print_Document_Sets');

1899: P_WAREHOUSE_ID => warehouse_id,
1900: message_string => message,
1901: status => cs);
1902: IF cs = FALSE THEN
1903: WSH_UTIL.Write_Log('Error in WSH_DOC_SETS.Print_Document_Sets');
1904: WSH_UTIL.Write_Log(message);
1905: RETURN FAILURE;
1906: END IF;
1907:

Line 1904: WSH_UTIL.Write_Log(message);

1900: message_string => message,
1901: status => cs);
1902: IF cs = FALSE THEN
1903: WSH_UTIL.Write_Log('Error in WSH_DOC_SETS.Print_Document_Sets');
1904: WSH_UTIL.Write_Log(message);
1905: RETURN FAILURE;
1906: END IF;
1907:
1908: ELSE

Line 1909: WSH_UTIL.Write_Log('Invalid documnet set');

1905: RETURN FAILURE;
1906: END IF;
1907:
1908: ELSE
1909: WSH_UTIL.Write_Log('Invalid documnet set');
1910: return FAILURE;
1911: END IF;
1912:
1913: RETURN SUCCESS;

Line 1917: WSH_UTIL.Default_Handler('WSH_PR_PICKING_SESSION.Launc_Doc_Set','');

1913: RETURN SUCCESS;
1914:
1915: EXCEPTION
1916: WHEN OTHERS THEN
1917: WSH_UTIL.Default_Handler('WSH_PR_PICKING_SESSION.Launc_Doc_Set','');
1918: RETURN FAILURE;
1919:
1920: END;
1921:

Line 1949: WSH_UTIL.Write_Log('The package must be initialized before use');

1945:
1946: BEGIN
1947: -- handle uninitialized package errors here
1948: IF initialized = FALSE THEN
1949: WSH_UTIL.Write_Log('The package must be initialized before use');
1950: RETURN FAILURE;
1951: END IF;
1952:
1953: IF p_token = 'UNRELEASED_SQL' THEN

Line 1965: WSH_UTIL.Write_Log('Invalid Token ' || p_token);

1961: ELSIF p_token = 'SET_REQUEST_SQL' THEN
1962: RETURN sreq_SQL;
1963: ELSE
1964: -- handle invalid token
1965: WSH_UTIL.Write_Log('Invalid Token ' || p_token);
1966: RETURN to_char(FAILURE);
1967: END IF;
1968:
1969: RETURN SUCCESS;