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_OBJECTS dependencies on WSH_UTIL

Line 157: WSH_UTIL.Write_Log('Starting WSH_PR_PICKING_OBJECTS.Init');

153: FROM WSH_PARAMETERS
154: WHERE organization_id = x_warehouse_id;
155:
156: BEGIN
157: WSH_UTIL.Write_Log('Starting WSH_PR_PICKING_OBJECTS.Init');
158: IF initialized = TRUE THEN
159: RETURN SUCCESS;
160: END IF;
161:

Line 191: WSH_UTIL.Write_Log('Warning: Pick slip rule '

187: g_use_departure_ps,
188: g_use_delivery_ps;
189:
190: IF ps_rule%NOTFOUND THEN
191: WSH_UTIL.Write_Log('Warning: Pick slip rule '
192: || to_char(g_pick_slip_rule_id) ||
193: ' does not exist');
194: RETURN FAILURE;
195: END IF;

Line 203: WSH_UTIL.Write_Log('Warning: No autocreate rule will use Y');

199: FETCH get_autocreate_del_orders
200: INTO g_use_autocreate_del_orders;
201:
202: IF get_autocreate_del_orders%NOTFOUND THEN
203: WSH_UTIL.Write_Log('Warning: No autocreate rule will use Y');
204: g_use_autocreate_del_orders := 'Y';
205: END IF;
206:
207: CLOSE ps_rule;

Line 216: WSH_UTIL.DEFAULT_HANDLER('WSH_PR_PICKING_OBJECTS.Init', 'Error in Init');

212: RETURN SUCCESS;
213:
214: EXCEPTION
215: WHEN OTHERS THEN
216: WSH_UTIL.DEFAULT_HANDLER('WSH_PR_PICKING_OBJECTS.Init', 'Error in Init');
217: IF ps_rule%ISOPEN THEN
218: CLOSE ps_rule;
219: END IF;
220: IF get_autocreate_del_orders%ISOPEN THEN

Line 332: WSH_UTIL.Write_Log('In Insert_Lines...');

328: rc BINARY_INTEGER;
329: x_delivery_id BINARY_INTEGER := NULL;
330:
331: BEGIN
332: WSH_UTIL.Write_Log('In Insert_Lines...');
333:
334: -- Initialize out variables
335: p_picking_line_id := 0;
336: p_abo_picking_line_id := 0;

Line 344: WSH_UTIL.Write_Log('Processing unreleased line');

340: p_pld_recs := 0;
341: p_old_recs := 0;
342:
343: IF p_backorder_line = UNRELEASED_LINE THEN
344: WSH_UTIL.Write_Log('Processing unreleased line');
345: ELSIF p_backorder_line = BACKORDER_LINE THEN
346: WSH_UTIL.Write_Log('Processing backordered line');
347: END IF;
348:

Line 346: WSH_UTIL.Write_Log('Processing backordered line');

342:
343: IF p_backorder_line = UNRELEASED_LINE THEN
344: WSH_UTIL.Write_Log('Processing unreleased line');
345: ELSIF p_backorder_line = BACKORDER_LINE THEN
346: WSH_UTIL.Write_Log('Processing backordered line');
347: END IF;
348:
349: -- Determine if a new picking_header_id needs to be created
350: ph_id := Process_Key(

Line 364: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');

360: p_warehouse_id,
361: new_flag);
362:
363: IF ph_id = FAILURE THEN
364: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
365: RETURN FAILURE;
366: END IF;
367:
368: -- Create new picking header if necessary

Line 370: WSH_UTIL.Write_Log('Inserting picking header ' || to_char(ph_id));

366: END IF;
367:
368: -- Create new picking header if necessary
369: IF new_flag = 'Y' THEN
370: WSH_UTIL.Write_Log('Inserting picking header ' || to_char(ph_id));
371: INSERT INTO SO_PICKING_HEADERS_ALL (
372: PICKING_HEADER_ID,
373: CREATION_DATE,
374: CREATED_BY,

Line 425: WSH_UTIL.Write_Log('Invalid delivery id, ignoring...');

421: p_ship_to_site_use_id,
422: p_ship_method_code,
423: p_warehouse_id);
424: IF p_delivery_id = -1 THEN
425: WSH_UTIL.Write_Log('Invalid delivery id, ignoring...');
426: END IF;
427: END IF;
428:
429: -- If reservations are off

Line 431: WSH_UTIL.Write_Log('Reservations are off');

427: END IF;
428:
429: -- If reservations are off
430: IF g_reservations = 'N' THEN
431: WSH_UTIL.Write_Log('Reservations are off');
432: -- Determine the pick slip number
433: ps_number := Process_Key (
434: 'PICK_SLIP_NUMBER',
435: p_order_header_id,

Line 446: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));

442: p_delivery_id,
443: p_warehouse_id,
444: new_flag);
445:
446: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
447:
448: IF ps_number = FAILURE THEN
449: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
450: RETURN FAILURE;

Line 449: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');

445:
446: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
447:
448: IF ps_number = FAILURE THEN
449: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
450: RETURN FAILURE;
451: END IF;
452:
453: SELECT SO_PICKING_LINES_S.NEXTVAL

Line 484: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

480: p_warehouse_id,
481: p_org_id);
482:
483: IF rc = FAILURE THEN
484: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
485: RETURN FAILURE;
486: END IF;
487:
488: p_picking_line_id := x_pl_id;

Line 494: WSH_UTIL.Write_Log('Could not fine a subinventory in nores_sub');

490: IF p_transactable_flag = 'Y' THEN
491: OPEN nores_sub(p_ccid, p_order_line_id, p_delivery);
492: FETCH nores_sub INTO current_sub;
493: IF nores_sub%NOTFOUND THEN
494: WSH_UTIL.Write_Log('Could not fine a subinventory in nores_sub');
495: current_sub := NULL;
496: ELSE
497: WSH_UTIL.Write_Log('Using Subinventory ' || current_sub ||
498: ' for Transactable, Non-reservable');

Line 497: WSH_UTIL.Write_Log('Using Subinventory ' || current_sub ||

493: IF nores_sub%NOTFOUND THEN
494: WSH_UTIL.Write_Log('Could not fine a subinventory in nores_sub');
495: current_sub := NULL;
496: ELSE
497: WSH_UTIL.Write_Log('Using Subinventory ' || current_sub ||
498: ' for Transactable, Non-reservable');
499: END IF;
500: CLOSE nores_sub;
501:

Line 516: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));

512: p_delivery_id,
513: p_warehouse_id,
514: new_flag);
515:
516: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
517:
518: IF ps_number = FAILURE THEN
519: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
520: RETURN FAILURE;

Line 519: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');

515:
516: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
517:
518: IF ps_number = FAILURE THEN
519: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
520: RETURN FAILURE;
521: END IF;
522:
523: rc := Insert_Picking_Line_Details (

Line 582: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

578:
579: END IF;
580:
581: IF rc = FAILURE THEN
582: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
583: RETURN FAILURE;
584: END IF;
585:
586: p_pld_recs := p_pld_recs + rc;

Line 590: WSH_UTIL.Write_Log('Reservations are on');

586: p_pld_recs := p_pld_recs + rc;
587:
588: ELSIF g_reservations = 'Y' THEN /* Reservations on */
589:
590: WSH_UTIL.Write_Log('Reservations are on');
591:
592: -- Process transactable and reservable lines
593: IF ((p_transactable_flag = 'Y') AND (p_reservable_flag = 'Y'))THEN
594: WSH_UTIL.Write_Log('Transactable and Reservable');

Line 594: WSH_UTIL.Write_Log('Transactable and Reservable');

590: WSH_UTIL.Write_Log('Reservations are on');
591:
592: -- Process transactable and reservable lines
593: IF ((p_transactable_flag = 'Y') AND (p_reservable_flag = 'Y'))THEN
594: WSH_UTIL.Write_Log('Transactable and Reservable');
595:
596: IF p_autodetailed_quantity > 0 THEN
597: -- Insert picking line
598: SELECT SO_PICKING_LINES_S.NEXTVAL

Line 629: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

625: p_warehouse_id,
626: p_org_id);
627:
628: IF rc = FAILURE THEN
629: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
630: RETURN FAILURE;
631: END IF;
632:
633: p_picking_line_id := x_pl_id;

Line 659: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));

655: p_delivery_id,
656: p_warehouse_id,
657: new_flag);
658:
659: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
660:
661: IF ps_number = FAILURE THEN
662: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
663: RETURN FAILURE;

Line 662: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');

658:
659: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
660:
661: IF ps_number = FAILURE THEN
662: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
663: RETURN FAILURE;
664: END IF;
665:
666: rc := Insert_Picking_Line_Details (

Line 695: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

691: NULL,
692: p_warehouse_id);
693:
694: IF rc = FAILURE THEN
695: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
696: RETURN FAILURE;
697: END IF;
698:
699: p_pld_recs := p_pld_recs + rc;

Line 719: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));

715: p_delivery_id,
716: p_warehouse_id,
717: new_flag);
718:
719: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
720:
721: IF ps_number = FAILURE THEN
722: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
723: RETURN FAILURE;

Line 722: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');

718:
719: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
720:
721: IF ps_number = FAILURE THEN
722: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
723: RETURN FAILURE;
724: END IF;
725:
726: rc := Insert_Picking_Line_Details (

Line 755: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

751: NULL,
752: p_warehouse_id);
753:
754: IF rc = FAILURE THEN
755: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
756: RETURN FAILURE;
757: END IF;
758:
759: p_pld_recs := p_pld_recs + rc;

Line 772: WSH_UTIL.Write_Log('Incomplete Reservations made');

768: ------------------------------------------------------------------
769: IF ((p_autodetailed_quantity <> p_original_requested_quantity) AND
770: (p_autodetailed_quantity > 0)) THEN
771:
772: WSH_UTIL.Write_Log('Incomplete Reservations made');
773:
774: IF p_backorder_line = BACKORDER_LINE THEN
775: -- Create a picking line for the remaining quantity with
776: -- picking header id = 0

Line 809: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

805: p_warehouse_id,
806: p_org_id);
807:
808: IF rc = FAILURE THEN
809: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
810: RETURN FAILURE;
811: END IF;
812:
813: p_abo_picking_line_id := x_pl_id;

Line 814: WSH_UTIL.Write_Log('Backorder picking_line_id = ' ||

810: RETURN FAILURE;
811: END IF;
812:
813: p_abo_picking_line_id := x_pl_id;
814: WSH_UTIL.Write_Log('Backorder picking_line_id = ' ||
815: to_char(p_abo_picking_line_id));
816:
817: IF p_autodetailed_quantity = 0 THEN
818: p_new_delivery := 0;

Line 855: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

851: 'N',
852: p_warehouse_id);
853:
854: IF rc = FAILURE THEN
855: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
856: RETURN FAILURE;
857: END IF;
858:
859: WSH_UTIL.Write_Log('Picking Line Detail created with delivery = ' || to_char(p_new_delivery));

Line 859: WSH_UTIL.Write_Log('Picking Line Detail created with delivery = ' || to_char(p_new_delivery));

855: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
856: RETURN FAILURE;
857: END IF;
858:
859: WSH_UTIL.Write_Log('Picking Line Detail created with delivery = ' || to_char(p_new_delivery));
860:
861: p_abo_recs := p_abo_recs + rc;
862:
863: ELSIF p_backorder_line = UNRELEASED_LINE THEN

Line 878: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

874: p_autodetailed_quantity,
875: p_new_delivery);
876:
877: IF rc = FAILURE THEN
878: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
879: RETURN FAILURE;
880: END IF;
881:
882: WSH_UTIL.Write_Log('Order Line Detail created with delivery = ' || to_char(p_new_delivery));

Line 882: WSH_UTIL.Write_Log('Order Line Detail created with delivery = ' || to_char(p_new_delivery));

878: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
879: RETURN FAILURE;
880: END IF;
881:
882: WSH_UTIL.Write_Log('Order Line Detail created with delivery = ' || to_char(p_new_delivery));
883:
884: p_old_recs := p_old_recs + rc;
885:
886: END IF;

Line 889: WSH_UTIL.Write_Log('Invalid line status');

885:
886: END IF;
887:
888: ELSE
889: WSH_UTIL.Write_Log('Invalid line status');
890: RETURN FAILURE;
891:
892: END IF; /* p_backorder_line = 'Y' */
893:

Line 898: WSH_UTIL.Write_Log('Transactable, Not Reservable');

894: END IF; /* p_autodetailed_quantity <> p_original_requested_quantity */
895:
896: ELSIF (p_transactable_flag = 'Y') AND (p_reservable_flag = 'N') THEN
897:
898: WSH_UTIL.Write_Log('Transactable, Not Reservable');
899:
900: -- Insert picking line
901: SELECT SO_PICKING_LINES_S.NEXTVAL
902: INTO x_pl_id

Line 932: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

928: p_warehouse_id,
929: p_org_id);
930:
931: IF rc = FAILURE THEN
932: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
933: RETURN FAILURE;
934: END IF;
935:
936: OPEN nores_sub(p_ccid, p_order_line_id, p_delivery);

Line 939: WSH_UTIL.Write_Log('Could not fine a subinventory in nores_sub');

935:
936: OPEN nores_sub(p_ccid, p_order_line_id, p_delivery);
937: FETCH nores_sub INTO current_sub;
938: IF nores_sub%NOTFOUND THEN
939: WSH_UTIL.Write_Log('Could not fine a subinventory in nores_sub');
940: current_sub := NULL;
941: ELSE
942: WSH_UTIL.Write_Log('Using Subinventory ' || current_sub ||
943: ' for Transactable, Non-reservable');

Line 942: WSH_UTIL.Write_Log('Using Subinventory ' || current_sub ||

938: IF nores_sub%NOTFOUND THEN
939: WSH_UTIL.Write_Log('Could not fine a subinventory in nores_sub');
940: current_sub := NULL;
941: ELSE
942: WSH_UTIL.Write_Log('Using Subinventory ' || current_sub ||
943: ' for Transactable, Non-reservable');
944: END IF;
945: CLOSE nores_sub;
946:

Line 961: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));

957: p_delivery_id,
958: p_warehouse_id,
959: new_flag);
960:
961: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
962:
963: IF ps_number = FAILURE THEN
964: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
965: RETURN FAILURE;

Line 964: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');

960:
961: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
962:
963: IF ps_number = FAILURE THEN
964: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
965: RETURN FAILURE;
966: END IF;
967:
968: rc := Insert_Picking_Line_Details (

Line 997: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

993: NULL,
994: p_warehouse_id);
995:
996: IF rc = FAILURE THEN
997: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
998: RETURN FAILURE;
999: END IF;
1000:
1001: ELSIF (p_transactable_flag = 'N') THEN

Line 1003: WSH_UTIL.Write_Log('Not Transactable');

999: END IF;
1000:
1001: ELSIF (p_transactable_flag = 'N') THEN
1002:
1003: WSH_UTIL.Write_Log('Not Transactable');
1004:
1005: -- Determine the pick slip number
1006: ps_number := Process_Key (
1007: 'PICK_SLIP_NUMBER',

Line 1019: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));

1015: p_delivery_id,
1016: p_warehouse_id,
1017: new_flag);
1018:
1019: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
1020:
1021: IF ps_number = FAILURE THEN
1022: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
1023: RETURN FAILURE;

Line 1022: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');

1018:
1019: WSH_UTIL.Write_Log('Pick Slip Number is ' || to_char(ps_number));
1020:
1021: IF ps_number = FAILURE THEN
1022: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Process_Key');
1023: RETURN FAILURE;
1024: END IF;
1025:
1026: SELECT SO_PICKING_LINES_S.NEXTVAL

Line 1057: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

1053: p_warehouse_id,
1054: p_org_id);
1055:
1056: IF rc = FAILURE THEN
1057: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
1058: RETURN FAILURE;
1059: END IF;
1060:
1061: rc := Insert_Picking_Line_Details (

Line 1090: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');

1086: NULL,
1087: p_warehouse_id);
1088:
1089: IF rc = FAILURE THEN
1090: WSH_UTIL.Write_Log('WSH_PR_PICKING_OBJECTS: Error in Insert_Lines');
1091: RETURN FAILURE;
1092: END IF;
1093:
1094: END IF; /* Reservable, transactable etc */

Line 1107: WSH_UTIL.Default_Handler('WSH_PR_PICKING_OBJECTS.Insert_Lines');

1103: END IF;
1104: IF nores_sub%ISOPEN THEN
1105: CLOSE res_sub;
1106: END IF;
1107: WSH_UTIL.Default_Handler('WSH_PR_PICKING_OBJECTS.Insert_Lines');
1108: RETURN FAILURE;
1109:
1110: END Insert_Lines;
1111:

Line 1155: WSH_UTIL.Write_Log('--------------------');

1151: )
1152: RETURN BINARY_INTEGER IS
1153: BEGIN
1154:
1155: WSH_UTIL.Write_Log('--------------------');
1156: WSH_UTIL.Write_Log('Inserting Picking Line');
1157: WSH_UTIL.Write_Log('picking_line_id = ' || to_char(p_picking_line_id) ||
1158: ' picking_header_id = ' || to_char(p_pick_header_id));
1159: WSH_UTIL.Write_Log('order_line_id = ' || to_char(p_order_line_id) ||

Line 1156: WSH_UTIL.Write_Log('Inserting Picking Line');

1152: RETURN BINARY_INTEGER IS
1153: BEGIN
1154:
1155: WSH_UTIL.Write_Log('--------------------');
1156: WSH_UTIL.Write_Log('Inserting Picking Line');
1157: WSH_UTIL.Write_Log('picking_line_id = ' || to_char(p_picking_line_id) ||
1158: ' picking_header_id = ' || to_char(p_pick_header_id));
1159: WSH_UTIL.Write_Log('order_line_id = ' || to_char(p_order_line_id) ||
1160: ' original_line_detail_id = ' || to_char(p_original_line_detail_id));

Line 1157: WSH_UTIL.Write_Log('picking_line_id = ' || to_char(p_picking_line_id) ||

1153: BEGIN
1154:
1155: WSH_UTIL.Write_Log('--------------------');
1156: WSH_UTIL.Write_Log('Inserting Picking Line');
1157: WSH_UTIL.Write_Log('picking_line_id = ' || to_char(p_picking_line_id) ||
1158: ' picking_header_id = ' || to_char(p_pick_header_id));
1159: WSH_UTIL.Write_Log('order_line_id = ' || to_char(p_order_line_id) ||
1160: ' original_line_detail_id = ' || to_char(p_original_line_detail_id));
1161: WSH_UTIL.Write_Log('requested_quantity = ' || to_char(p_requested_quantity));

Line 1159: WSH_UTIL.Write_Log('order_line_id = ' || to_char(p_order_line_id) ||

1155: WSH_UTIL.Write_Log('--------------------');
1156: WSH_UTIL.Write_Log('Inserting Picking Line');
1157: WSH_UTIL.Write_Log('picking_line_id = ' || to_char(p_picking_line_id) ||
1158: ' picking_header_id = ' || to_char(p_pick_header_id));
1159: WSH_UTIL.Write_Log('order_line_id = ' || to_char(p_order_line_id) ||
1160: ' original_line_detail_id = ' || to_char(p_original_line_detail_id));
1161: WSH_UTIL.Write_Log('requested_quantity = ' || to_char(p_requested_quantity));
1162: WSH_UTIL.Write_Log('--------------------');
1163:

Line 1161: WSH_UTIL.Write_Log('requested_quantity = ' || to_char(p_requested_quantity));

1157: WSH_UTIL.Write_Log('picking_line_id = ' || to_char(p_picking_line_id) ||
1158: ' picking_header_id = ' || to_char(p_pick_header_id));
1159: WSH_UTIL.Write_Log('order_line_id = ' || to_char(p_order_line_id) ||
1160: ' original_line_detail_id = ' || to_char(p_original_line_detail_id));
1161: WSH_UTIL.Write_Log('requested_quantity = ' || to_char(p_requested_quantity));
1162: WSH_UTIL.Write_Log('--------------------');
1163:
1164: INSERT INTO SO_PICKING_LINES_ALL (
1165: PICKING_LINE_ID,

Line 1162: WSH_UTIL.Write_Log('--------------------');

1158: ' picking_header_id = ' || to_char(p_pick_header_id));
1159: WSH_UTIL.Write_Log('order_line_id = ' || to_char(p_order_line_id) ||
1160: ' original_line_detail_id = ' || to_char(p_original_line_detail_id));
1161: WSH_UTIL.Write_Log('requested_quantity = ' || to_char(p_requested_quantity));
1162: WSH_UTIL.Write_Log('--------------------');
1163:
1164: INSERT INTO SO_PICKING_LINES_ALL (
1165: PICKING_LINE_ID,
1166: CREATED_BY,

Line 1243: WSH_UTIL.Default_Handler('WSH_PR_PICKING_OBJECTS.Insert_Picking_Line');

1239: RETURN SUCCESS;
1240:
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: WSH_UTIL.Default_Handler('WSH_PR_PICKING_OBJECTS.Insert_Picking_Line');
1244: RETURN FAILURE;
1245:
1246: END Insert_Picking_Line;
1247:

Line 1297: WSH_UTIL.Write_Log('--------------------');

1293: l_dpw_assigned_flag VARCHAR2(1);
1294: default_subinventory VARCHAR2(10);
1295:
1296: BEGIN
1297: WSH_UTIL.Write_Log('--------------------');
1298: WSH_UTIL.Write_Log('Mode is ' || to_char(p_mode));
1299:
1300: IF p_departure_id = -1 AND p_delivery_id = -1 THEN
1301: l_dpw_assigned_flag := 'N';

Line 1298: WSH_UTIL.Write_Log('Mode is ' || to_char(p_mode));

1294: default_subinventory VARCHAR2(10);
1295:
1296: BEGIN
1297: WSH_UTIL.Write_Log('--------------------');
1298: WSH_UTIL.Write_Log('Mode is ' || to_char(p_mode));
1299:
1300: IF p_departure_id = -1 AND p_delivery_id = -1 THEN
1301: l_dpw_assigned_flag := 'N';
1302: ELSE

Line 1619: WSH_UTIL.Write_Log('Invalid picking line detail insertion mode');

1615:
1616: rows_inserted := SQL%ROWCOUNT;
1617:
1618: ELSE
1619: WSH_UTIL.Write_Log('Invalid picking line detail insertion mode');
1620: RETURN FAILURE;
1621: END IF;
1622:
1623: WSH_UTIL.Write_Log('Inserted ' || to_char(rows_inserted) ||

Line 1623: WSH_UTIL.Write_Log('Inserted ' || to_char(rows_inserted) ||

1619: WSH_UTIL.Write_Log('Invalid picking line detail insertion mode');
1620: RETURN FAILURE;
1621: END IF;
1622:
1623: WSH_UTIL.Write_Log('Inserted ' || to_char(rows_inserted) ||
1624: ' picking_line_details for picking_line '|| to_char(p_picking_line_id));
1625:
1626: IF rows_inserted = 0 THEN
1627: RETURN FAILURE;

Line 1634: WSH_UTIL.Default_Handler('WSH_PR_PICKING_OBJECTS.Insert_Picking_Line_Details',

1630: END IF;
1631:
1632: EXCEPTION
1633: WHEN OTHERS THEN
1634: WSH_UTIL.Default_Handler('WSH_PR_PICKING_OBJECTS.Insert_Picking_Line_Details',
1635: to_char(p_mode));
1636: RETURN FAILURE;
1637:
1638: END Insert_Picking_Line_Details;

Line 1664: WSH_UTIL.Write_Log('--------------------');

1660:
1661: rows_inserted BINARY_INTEGER;
1662:
1663: BEGIN
1664: WSH_UTIL.Write_Log('--------------------');
1665: WSH_UTIL.Write_Log('Inserting new order line detail');
1666:
1667: SELECT SO_LINE_DETAILS_S.NEXTVAL
1668: INTO p_new_line_detail_id

Line 1665: WSH_UTIL.Write_Log('Inserting new order line detail');

1661: rows_inserted BINARY_INTEGER;
1662:
1663: BEGIN
1664: WSH_UTIL.Write_Log('--------------------');
1665: WSH_UTIL.Write_Log('Inserting new order line detail');
1666:
1667: SELECT SO_LINE_DETAILS_S.NEXTVAL
1668: INTO p_new_line_detail_id
1669: FROM DUAL;

Line 1816: WSH_UTIL.Write_Log('Inserted ' || to_char(rows_inserted) ||

1812: WHERE line_detail_id = p_original_line_detail_id;
1813:
1814: rows_inserted := SQL%ROWCOUNT;
1815:
1816: WSH_UTIL.Write_Log('Inserted ' || to_char(rows_inserted) ||
1817: ' order_line_detail = ' || to_char(p_new_line_detail_id));
1818:
1819: RETURN rows_inserted;
1820:

Line 1823: WSH_UTIL.Default_Handler('WSH_PR_PICKING_OBJECTS.Insert_Order_Line_Detail');

1819: RETURN rows_inserted;
1820:
1821: EXCEPTION
1822: WHEN OTHERS THEN
1823: WSH_UTIL.Default_Handler('WSH_PR_PICKING_OBJECTS.Insert_Order_Line_Detail');
1824: RETURN FAILURE;
1825:
1826: END Insert_Order_Line_Detail;
1827:

Line 1950: WSH_UTIL.Default_Handler('WSH_PR_PICKING_OBJECTS.Process_Key');

1946: END IF;
1947:
1948: EXCEPTION
1949: WHEN OTHERS THEN
1950: WSH_UTIL.Default_Handler('WSH_PR_PICKING_OBJECTS.Process_Key');
1951: RETURN FAILURE;
1952:
1953: END Process_Key;
1954: