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.JMF_SHIKYU_AUTO_RCV_PROC dependencies on JMF_SHIKYU_UTIL

Line 56: --| jmf_shikyu_util.Get_Replenish_So_Returned_Qty|

52: --| 15-JUN-2006 THE2 Add locator_id process logic |
53: --| 27-JUN-2006 THE2 Removed the logic for checking duplicated |
54: --| RCV transactions. |
55: --| 28-JUN-2006 THE2 Met the interface change of procedure |
56: --| jmf_shikyu_util.Get_Replenish_So_Returned_Qty|
57: --| and JMF_SHIKYU_RCV_PVT.process_rcv_trx |
58: --| 03-AUG-2006 THE2 Modified cursor po_distributions_c to fix |
59: --| bug #5434983 |
60: --| 18-AUG-2006 THE2 Modified cursor po_distributions_c again |

Line 131: JMF_SHIKYU_UTIL.debug_output

127: AND hoi.org_information3 = MO_GLOBAL.get_current_org_id
128: AND haoutl.LANGUAGE = USERENV('LANG');
129:
130: BEGIN
131: JMF_SHIKYU_UTIL.debug_output
132: (
133: p_output_to => 'FND_LOG.STRING'
134: ,p_api_name => l_api_name
135: ,p_message => 'procedure begin'

Line 137: JMF_SHIKYU_UTIL.debug_output

133: p_output_to => 'FND_LOG.STRING'
134: ,p_api_name => l_api_name
135: ,p_message => 'procedure begin'
136: );
137: JMF_SHIKYU_UTIL.debug_output
138: (
139: p_output_to => 'FND_LOG.STRING'
140: ,p_api_name => l_api_name
141: ,p_message => 'p_tp_org_id:'||p_tp_org_id

Line 143: JMF_SHIKYU_UTIL.debug_output

139: p_output_to => 'FND_LOG.STRING'
140: ,p_api_name => l_api_name
141: ,p_message => 'p_tp_org_id:'||p_tp_org_id
142: );
143: JMF_SHIKYU_UTIL.debug_output
144: (
145: p_output_to => 'FND_LOG.STRING'
146: ,p_api_name => l_api_name
147: ,p_message => 'l_org_id :'||l_org_id

Line 159: JMF_SHIKYU_UTIL.debug_output

155: THEN
156: IF p_tp_org_id IS NULL
157: THEN
158: -- begin log
159: JMF_SHIKYU_UTIL.debug_output
160: (
161: p_output_to => 'FND_LOG.STRING'
162: ,p_api_name => l_api_name
163: ,p_message => 'p_tp_org_id is null. '

Line 175: JMF_SHIKYU_UTIL.debug_output

171: INTO l_inventory_org_id;
172: EXIT WHEN all_inventory_c%NOTFOUND;
173:
174: -- begin log
175: JMF_SHIKYU_UTIL.debug_output
176: (
177: p_output_to => 'FND_LOG.STRING'
178: ,p_api_name => l_api_name
179: ,p_message => 'The inventory org id is : '||l_inventory_org_id

Line 201: JMF_SHIKYU_UTIL.debug_output

197: ELSE/*FND_PROFILE.VALUE('JMF_SHIKYU_ENABLED')='Y'*/
198: fnd_message.SET_NAME('JMF', 'JMF_SHK_NOT_ENABLE');
199: l_shikyu_not_enable := fnd_message.get;
200:
201: JMF_SHIKYU_UTIL.debug_output
202: (
203: p_output_to => 'FND_LOG.STRING'
204: ,p_api_name => l_api_name
205: ,p_message => l_shikyu_not_enable

Line 213: JMF_SHIKYU_UTIL.debug_output

209: , message => l_shikyu_not_enable
210: );
211: END IF; /*FND_PROFILE.VALUE('JMF_SHIKYU_ENABLED')='Y'*/
212:
213: JMF_SHIKYU_UTIL.debug_output
214: (
215: p_output_to => 'FND_LOG.STRING'
216: ,p_api_name => l_api_name
217: ,p_message => 'END procedure. '

Line 222: JMF_SHIKYU_UTIL.debug_output

218: );
219:
220: EXCEPTION
221: WHEN OTHERS THEN
222: JMF_SHIKYU_UTIL.debug_output
223: (
224: p_output_to => 'FND_LOG.STRING'
225: ,p_api_name => l_api_name
226: ,p_message => 'Unknown error : '||SQLCODE||SQLERRM

Line 286: JMF_SHIKYU_UTIL.debug_output

282: OR h.flow_status_code = 'CLOSED');
283:
284: BEGIN
285:
286: JMF_SHIKYU_UTIL.debug_output
287: (
288: p_output_to => 'FND_LOG.STRING'
289: ,p_api_name => l_api_name
290: ,p_message => 'procedure begin'

Line 292: JMF_SHIKYU_UTIL.debug_output

288: p_output_to => 'FND_LOG.STRING'
289: ,p_api_name => l_api_name
290: ,p_message => 'procedure begin'
291: );
292: JMF_SHIKYU_UTIL.debug_output
293: (
294: p_output_to => 'FND_LOG.STRING'
295: ,p_api_name => l_api_name
296: ,p_message => ' org_id : '||p_org_id||' inv_org_id:'||p_inventory_org_id

Line 307: JMF_SHIKYU_UTIL.debug_output

303: );
304:
305:
306: -- debug log
307: JMF_SHIKYU_UTIL.debug_output
308: (
309: p_output_to => 'FND_LOG.STRING'
310: ,p_api_name => l_api_name
311: ,p_message => 'customer_site_id : '||l_customer_site_id

Line 320: JMF_SHIKYU_UTIL.debug_output

316: LOOP
317: FETCH replenish_so_c INTO l_header_id;
318: EXIT WHEN replenish_so_c%NOTFOUND;
319: -- begin log
320: JMF_SHIKYU_UTIL.debug_output
321: (
322: p_output_to => 'FND_LOG.STRING'
323: ,p_api_name => l_api_name
324: ,p_message => 'The SO header id is :'||l_header_id

Line 335: JMF_SHIKYU_UTIL.debug_output

331:
332: END LOOP;
333: CLOSE replenish_so_c;
334:
335: JMF_SHIKYU_UTIL.debug_output
336: (
337: p_output_to => 'FND_LOG.STRING'
338: ,p_api_name => l_api_name
339: ,p_message => 'END procedure.'

Line 344: JMF_SHIKYU_UTIL.debug_output

340: );
341:
342: EXCEPTION
343: WHEN OTHERS THEN
344: JMF_SHIKYU_UTIL.debug_output
345: (
346: p_output_to => 'FND_LOG.STRING'
347: ,p_api_name => l_api_name
348: ,p_message => 'Unknown error'||SQLCODE||SQLERRM

Line 406: JMF_SHIKYU_UTIL.debug_output

402: WHERE r.replenishment_so_header_id = p_header_id;
403:
404: BEGIN
405:
406: JMF_SHIKYU_UTIL.debug_output
407: (
408: p_output_to => 'FND_LOG.STRING'
409: ,p_api_name => l_api_name
410: ,p_message => 'procedure begin'

Line 412: JMF_SHIKYU_UTIL.debug_output

408: p_output_to => 'FND_LOG.STRING'
409: ,p_api_name => l_api_name
410: ,p_message => 'procedure begin'
411: );
412: JMF_SHIKYU_UTIL.debug_output
413: (
414: p_output_to => 'FND_LOG.STRING'
415: ,p_api_name => l_api_name
416: ,p_message => 'p_header_id :'||p_header_id || ' p_inventory_org_id:' || p_inventory_org_id

Line 427: JMF_SHIKYU_UTIL.debug_output

423: FETCH replenish_so_line_c INTO l_line_id;
424: EXIT WHEN replenish_so_line_c%NOTFOUND;
425:
426: -- begin log
427: JMF_SHIKYU_UTIL.debug_output
428: (
429: p_output_to => 'FND_LOG.STRING'
430: ,p_api_name => l_api_name
431: ,p_message => 'l_line_id'||l_line_id

Line 449: JMF_SHIKYU_UTIL.debug_output

445: FROM jmf_shikyu_replenishments r
446: WHERE r.replenishment_so_line_id = l_line_id;
447: EXCEPTION
448: WHEN no_data_found THEN
449: JMF_SHIKYU_UTIL.debug_output
450: (
451: p_output_to => 'FND_LOG.STRING'
452: ,p_api_name => l_api_name
453: ,p_message => 'no data find when select PO info by so_line_id in jmf_shikyu_replenishments'

Line 458: JMF_SHIKYU_UTIL.debug_output

454: );
455: END;
456:
457: -- begin debug log
458: JMF_SHIKYU_UTIL.debug_output
459: (
460: p_output_to => 'FND_LOG.STRING'
461: ,p_api_name => l_api_name
462: ,p_message => 'l_po_header_id'||l_po_header_id

Line 464: JMF_SHIKYU_UTIL.debug_output

460: p_output_to => 'FND_LOG.STRING'
461: ,p_api_name => l_api_name
462: ,p_message => 'l_po_header_id'||l_po_header_id
463: );
464: JMF_SHIKYU_UTIL.debug_output
465: (
466: p_output_to => 'FND_LOG.STRING'
467: ,p_api_name => l_api_name
468: ,p_message => 'l_po_line_id'||l_po_line_id

Line 470: JMF_SHIKYU_UTIL.debug_output

466: p_output_to => 'FND_LOG.STRING'
467: ,p_api_name => l_api_name
468: ,p_message => 'l_po_line_id'||l_po_line_id
469: );
470: JMF_SHIKYU_UTIL.debug_output
471: (
472: p_output_to => 'FND_LOG.STRING'
473: ,p_api_name => l_api_name
474: ,p_message => 'l_po_shipment_id'||l_po_shipment_id

Line 495: JMF_SHIKYU_UTIL.debug_output

491: WHERE l.line_id = l_line_id;
492:
493: EXCEPTION
494: WHEN no_data_found THEN
495: JMF_SHIKYU_UTIL.debug_output
496: (
497: p_output_to => 'FND_LOG.STRING'
498: ,p_api_name => l_api_name
499: ,p_message => 'no data find when select ship org id or other info by line_id in oe_order_lines_all'

Line 516: JMF_SHIKYU_UTIL.debug_output

512:
513: END IF;
514:
515: -- begin debug log
516: JMF_SHIKYU_UTIL.debug_output
517: (
518: p_output_to => 'FND_LOG.STRING'
519: ,p_api_name => l_api_name
520: ,p_message => 'l_ship_date'||l_ship_date

Line 522: JMF_SHIKYU_UTIL.debug_output

518: p_output_to => 'FND_LOG.STRING'
519: ,p_api_name => l_api_name
520: ,p_message => 'l_ship_date'||l_ship_date
521: );
522: JMF_SHIKYU_UTIL.debug_output
523: (
524: p_output_to => 'FND_LOG.STRING'
525: ,p_api_name => l_api_name
526: ,p_message => 'l_ship_from_org_id'||l_ship_from_org_id

Line 528: JMF_SHIKYU_UTIL.debug_output

524: p_output_to => 'FND_LOG.STRING'
525: ,p_api_name => l_api_name
526: ,p_message => 'l_ship_from_org_id'||l_ship_from_org_id
527: );
528: JMF_SHIKYU_UTIL.debug_output
529: (
530: p_output_to => 'FND_LOG.STRING'
531: ,p_api_name => l_api_name
532: ,p_message => 'l_ship_to_org_id'||l_ship_to_org_id

Line 534: JMF_SHIKYU_UTIL.debug_output

530: p_output_to => 'FND_LOG.STRING'
531: ,p_api_name => l_api_name
532: ,p_message => 'l_ship_to_org_id'||l_ship_to_org_id
533: );
534: JMF_SHIKYU_UTIL.debug_output
535: (
536: p_output_to => 'FND_LOG.STRING'
537: ,p_api_name => l_api_name
538: ,p_message => 'l_ship_method'||l_ship_method

Line 562: JMF_SHIKYU_UTIL.debug_output

558: );
559:
560:
561: -- begin log
562: JMF_SHIKYU_UTIL.debug_output
563: (
564: p_output_to => 'FND_LOG.STRING'
565: ,p_api_name => l_api_name
566: ,p_message => 'l_ship_flag is '|| l_ship_flag||' l_date_flag is '||l_date_flag

Line 576: JMF_SHIKYU_UTIL.debug_output

572: --add line id to l_lines_id
573: l_lines_id.EXTEND;
574: l_lines_id(l_lines_id.COUNT) := l_line_id;
575: ELSE /*l_ship_flag=0 OR l_date_flag=0*/
576: JMF_SHIKYU_UTIL.debug_output
577: (
578: p_output_to => 'FND_LOG.STRING'
579: ,p_api_name => l_api_name
580: ,p_message => 'complete'

Line 588: JMF_SHIKYU_UTIL.debug_output

584: END LOOP; /* end loop replenish_so_line_c*/
585: CLOSE replenish_so_line_c;
586:
587: -- log the line count
588: JMF_SHIKYU_UTIL.debug_output
589: (
590: p_output_to => 'FND_LOG.STRING'
591: ,p_api_name => l_api_name
592: ,p_message => 'lines count '|| l_lines_id.COUNT

Line 610: JMF_SHIKYU_UTIL.debug_output

606: );
607:
608: -- log the quantity should be auto receive
609: -- begin log
610: JMF_SHIKYU_UTIL.debug_output
611: (
612: p_output_to => 'FND_LOG.STRING'
613: ,p_api_name => l_api_name
614: ,p_message => 'p_header_id'||p_header_id

Line 616: JMF_SHIKYU_UTIL.debug_output

612: p_output_to => 'FND_LOG.STRING'
613: ,p_api_name => l_api_name
614: ,p_message => 'p_header_id'||p_header_id
615: );
616: JMF_SHIKYU_UTIL.debug_output
617: (
618: p_output_to => 'FND_LOG.STRING'
619: ,p_api_name => l_api_name
620: ,p_message => 'p_inventory_org_id'||p_inventory_org_id

Line 622: JMF_SHIKYU_UTIL.debug_output

618: p_output_to => 'FND_LOG.STRING'
619: ,p_api_name => l_api_name
620: ,p_message => 'p_inventory_org_id'||p_inventory_org_id
621: );
622: JMF_SHIKYU_UTIL.debug_output
623: (
624: p_output_to => 'FND_LOG.STRING'
625: ,p_api_name => l_api_name
626: ,p_message => 'l_po_header_id'||l_po_header_id

Line 628: JMF_SHIKYU_UTIL.debug_output

624: p_output_to => 'FND_LOG.STRING'
625: ,p_api_name => l_api_name
626: ,p_message => 'l_po_header_id'||l_po_header_id
627: );
628: JMF_SHIKYU_UTIL.debug_output
629: (
630: p_output_to => 'FND_LOG.STRING'
631: ,p_api_name => l_api_name
632: ,p_message => 'l_po_line_id'||l_po_line_id

Line 634: JMF_SHIKYU_UTIL.debug_output

630: p_output_to => 'FND_LOG.STRING'
631: ,p_api_name => l_api_name
632: ,p_message => 'l_po_line_id'||l_po_line_id
633: );
634: JMF_SHIKYU_UTIL.debug_output
635: (
636: p_output_to => 'FND_LOG.STRING'
637: ,p_api_name => l_api_name
638: ,p_message => 'the quantity should be auto receive is '|| l_auto_receive_quantity

Line 640: JMF_SHIKYU_UTIL.debug_output

636: p_output_to => 'FND_LOG.STRING'
637: ,p_api_name => l_api_name
638: ,p_message => 'the quantity should be auto receive is '|| l_auto_receive_quantity
639: );
640: JMF_SHIKYU_UTIL.debug_output
641: (
642: p_output_to => 'FND_LOG.STRING'
643: ,p_api_name => l_api_name
644: ,p_message => 'the primary uom code is : '|| l_primary_uom_code

Line 662: JMF_SHIKYU_UTIL.debug_output

658: , p_primary_uom_code => l_primary_uom_code
659: );
660:
661: ELSE -- /*l_auto_receive_quantity <= 0*/
662: JMF_SHIKYU_UTIL.debug_output
663: (
664: p_output_to => 'FND_LOG.STRING'
665: ,p_api_name => l_api_name
666: ,p_message => 'the quantity should be auto receive is <= 0'

Line 673: JMF_SHIKYU_UTIL.debug_output

669:
670:
671: END IF; /*end if l_lines_id.count > 0 */
672:
673: JMF_SHIKYU_UTIL.debug_output
674: (
675: p_output_to => 'FND_LOG.STRING'
676: ,p_api_name => l_api_name
677: ,p_message => 'END procedure. '

Line 682: JMF_SHIKYU_UTIL.debug_output

678: );
679:
680: EXCEPTION
681: WHEN OTHERS THEN
682: JMF_SHIKYU_UTIL.debug_output
683: (
684: p_output_to => 'FND_LOG.STRING'
685: ,p_api_name => l_api_name
686: ,p_message => 'Unknown error '||SQLCODE||SQLERRM

Line 729: JMF_SHIKYU_UTIL.debug_output

725:
726: l_ship_flag NUMBER;
727:
728: BEGIN
729: JMF_SHIKYU_UTIL.debug_output
730: (
731: p_output_to => 'FND_LOG.STRING'
732: ,p_api_name => l_api_name
733: ,p_message => 'procedure begin'

Line 746: JMF_SHIKYU_UTIL.debug_output

742: FROM oe_order_headers_all h
743: WHERE h.header_id = p_header_id;
744: EXCEPTION
745: WHEN no_data_found THEN
746: JMF_SHIKYU_UTIL.debug_output
747: (
748: p_output_to => 'FND_LOG.STRING'
749: ,p_api_name => l_api_name
750: ,p_message => 'can find ship from, or ship to by SO_header_id'

Line 762: JMF_SHIKYU_UTIL.debug_output

758: END IF;
759:
760: x_ship_flag := l_ship_flag;
761:
762: JMF_SHIKYU_UTIL.debug_output
763: (
764: p_output_to => 'FND_LOG.STRING'
765: ,p_api_name => l_api_name
766: ,p_message => 'END procedure. '

Line 771: JMF_SHIKYU_UTIL.debug_output

767: );
768:
769: EXCEPTION
770: WHEN OTHERS THEN
771: JMF_SHIKYU_UTIL.debug_output
772: (
773: p_output_to => 'FND_LOG.STRING'
774: ,p_api_name => l_api_name
775: ,p_message => 'Unknown error, and ship flag is 0 '||SQLCODE||SQLERRM

Line 824: JMF_SHIKYU_UTIL.debug_output

820: --Bugfix 10281833: Variable l_customer_information is not needed
821: --l_customer_information HR_ORGANIZATION_INFORMATION.Org_Information1%TYPE;
822:
823: BEGIN
824: JMF_SHIKYU_UTIL.debug_output
825: (
826: p_output_to => 'FND_LOG.STRING'
827: ,p_api_name => l_api_name
828: ,p_message => 'procedure begin'

Line 844: JMF_SHIKYU_UTIL.debug_output

840: WHERE hoi.org_information1 = l_customer_information;
841:
842: EXCEPTION
843: WHEN no_data_found THEN
844: JMF_SHIKYU_UTIL.debug_output
845: (
846: p_output_to => 'FND_LOG.STRING'
847: ,p_api_name => l_api_name
848: ,p_message => 'no data found , when find tp org id by ship_to_org_id'

Line 852: JMF_SHIKYU_UTIL.debug_output

848: ,p_message => 'no data found , when find tp org id by ship_to_org_id'
849: );
850: RAISE;
851: WHEN too_many_rows THEN
852: JMF_SHIKYU_UTIL.debug_output
853: (
854: p_output_to => 'FND_LOG.STRING'
855: ,p_api_name => l_api_name
856: ,p_message => 'find too many ship from or ship to by p_header_id'

Line 863: JMF_SHIKYU_UTIL.debug_output

859: END;
860: */
861:
862: l_tp_org_id := p_inventory_org_id;
863: JMF_SHIKYU_UTIL.debug_output
864: (
865: p_output_to => 'FND_LOG.STRING'
866: ,p_api_name => l_api_name
867: ,p_message => 'p_inventory_org_id:' || p_inventory_org_id || ' l_tp_org_id:' || l_tp_org_id

Line 881: JMF_SHIKYU_UTIL.debug_output

877: WHERE ship_net.FROM_ORGANIZATION_ID = p_line_ship_from_org_id
878: AND ship_net.TO_ORGANIZATION_ID = l_tp_org_id;
879: EXCEPTION
880: WHEN no_data_found THEN
881: JMF_SHIKYU_UTIL.debug_output
882: (
883: p_output_to => 'FND_LOG.STRING'
884: ,p_api_name => l_api_name
885: ,p_message => 'no data found in-transit type'

Line 889: JMF_SHIKYU_UTIL.debug_output

885: ,p_message => 'no data found in-transit type'
886: );
887: RAISE;
888: WHEN too_many_rows THEN
889: JMF_SHIKYU_UTIL.debug_output
890: (
891: p_output_to => 'FND_LOG.STRING'
892: ,p_api_name => l_api_name
893: ,p_message => 'too many rows when find in-transit type'

Line 910: JMF_SHIKYU_UTIL.debug_output

906: , p_ship_method => p_ship_method
907: , x_in_transit => l_in_transit);
908:
909: ELSE -- the intransit_type is not 1 and 2 (direct and intransit)
910: JMF_SHIKYU_UTIL.debug_output
911: (
912: p_output_to => 'FND_LOG.STRING'
913: ,p_api_name => l_api_name
914: ,p_message => 'Error: intransit type is not direct nor intransit'

Line 919: JMF_SHIKYU_UTIL.debug_output

915: );
916: END IF; /*l_intransit_type = 1 */
917:
918: -- begin debug log
919: JMF_SHIKYU_UTIL.debug_output
920: (
921: p_output_to => 'FND_LOG.STRING'
922: ,p_api_name => l_api_name
923: ,p_message => 'l_in_transit'||l_in_transit

Line 936: JMF_SHIKYU_UTIL.debug_output

932: END IF; /*l_receive_date <= SYSDATE */
933:
934: x_date_flag := l_date_flag;
935:
936: JMF_SHIKYU_UTIL.debug_output
937: (
938: p_output_to => 'FND_LOG.STRING'
939: ,p_api_name => l_api_name
940: ,p_message => 'END procedure. '

Line 944: JMF_SHIKYU_UTIL.debug_output

940: ,p_message => 'END procedure. '
941: );
942: EXCEPTION
943: WHEN OTHERS THEN
944: JMF_SHIKYU_UTIL.debug_output
945: (
946: p_output_to => 'FND_LOG.STRING'
947: ,p_api_name => l_api_name
948: ,p_message => 'Unknown error and date flag is 0 '||SQLCODE||SQLERRM

Line 1025: JMF_SHIKYU_UTIL.debug_output

1021: l_index NUMBER;
1022:
1023: BEGIN
1024:
1025: JMF_SHIKYU_UTIL.debug_output
1026: (
1027: p_output_to => 'FND_LOG.STRING'
1028: ,p_api_name => l_api_name
1029: ,p_message => 'procedure begin'

Line 1060: JMF_SHIKYU_UTIL.debug_output

1056: WHERE l.line_id = p_lines_id(l_index);
1057:
1058: EXCEPTION
1059: WHEN no_data_found THEN
1060: JMF_SHIKYU_UTIL.debug_output
1061: (
1062: p_output_to => 'FND_LOG.STRING'
1063: ,p_api_name => l_api_name
1064: ,p_message => 'no data found when find shipped_quantity and item_id'

Line 1068: JMF_SHIKYU_UTIL.debug_output

1064: ,p_message => 'no data found when find shipped_quantity and item_id'
1065: );
1066: RAISE;
1067: WHEN too_many_rows THEN
1068: JMF_SHIKYU_UTIL.debug_output
1069: (
1070: p_output_to => 'FND_LOG.STRING'
1071: ,p_api_name => l_api_name
1072: ,p_message => 'too many rows when find shipped_quantity and item_id'

Line 1094: JMF_SHIKYU_UTIL.debug_output

1090: , p_current_uom_code => l_uom_code
1091: , p_current_qty => l_line_quantity
1092: );
1093:
1094: JMF_SHIKYU_UTIL.debug_output
1095: (
1096: p_output_to => 'FND_LOG.STRING'
1097: ,p_api_name => l_api_name
1098: ,p_message => 'l_prm_uom_quantity_so :' || l_prm_uom_quantity_so

Line 1108: JMF_SHIKYU_UTIL.debug_output

1104: ,p_inventory_org_id => p_inventory_org_id
1105: ,x_backorder_shipped_quantity => l_backorder_shipped_quantity
1106: );
1107:
1108: JMF_SHIKYU_UTIL.debug_output
1109: (
1110: p_output_to => 'FND_LOG.STRING'
1111: ,p_api_name => l_api_name
1112: ,p_message => 'l_backorder_shipped_quantity :' || l_backorder_shipped_quantity

Line 1119: l_returned_quantity := jmf_shikyu_util.Get_Replenish_So_Returned_Qty(p_replenishment_so_line_id => p_lines_id(l_index));

1115: -- this should be open if this porcedure is avilable.
1116:
1117: -- sub the return quantity (the returned quantity is in primary UOM)
1118:
1119: l_returned_quantity := jmf_shikyu_util.Get_Replenish_So_Returned_Qty(p_replenishment_so_line_id => p_lines_id(l_index));
1120:
1121: JMF_SHIKYU_UTIL.debug_output
1122: (
1123: p_output_to => 'FND_LOG.STRING'

Line 1121: JMF_SHIKYU_UTIL.debug_output

1117: -- sub the return quantity (the returned quantity is in primary UOM)
1118:
1119: l_returned_quantity := jmf_shikyu_util.Get_Replenish_So_Returned_Qty(p_replenishment_so_line_id => p_lines_id(l_index));
1120:
1121: JMF_SHIKYU_UTIL.debug_output
1122: (
1123: p_output_to => 'FND_LOG.STRING'
1124: ,p_api_name => l_api_name
1125: ,p_message => 'l_returned_quantity :' || l_returned_quantity

Line 1145: JMF_SHIKYU_UTIL.debug_output

1141: WHERE locate.line_location_id = p_po_shipment_id;
1142:
1143: EXCEPTION
1144: WHEN no_data_found THEN
1145: JMF_SHIKYU_UTIL.debug_output
1146: (
1147: p_output_to => 'FND_LOG.STRING'
1148: ,p_api_name => l_api_name
1149: ,p_message => 'no data found , when find quantity_received by line_location_id'

Line 1163: JMF_SHIKYU_UTIL.debug_output

1159: AND uom.LANGUAGE = userenv('LANG');
1160:
1161: EXCEPTION
1162: WHEN no_data_found THEN
1163: JMF_SHIKYU_UTIL.debug_output
1164: (
1165: p_output_to => 'FND_LOG.STRING'
1166: ,p_api_name => l_api_name
1167: ,p_message => 'no data found , when find uom_code by unit_of_measure'

Line 1183: JMF_SHIKYU_UTIL.debug_output

1179:
1180: -- compare
1181: x_receive_quantity := l_shipped_quantity - l_prm_uom_quantity_po;
1182:
1183: JMF_SHIKYU_UTIL.debug_output
1184: (
1185: p_output_to => 'FND_LOG.STRING'
1186: ,p_api_name => l_api_name
1187: ,p_message => 'END procedure. '

Line 1191: JMF_SHIKYU_UTIL.debug_output

1187: ,p_message => 'END procedure. '
1188: );
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: JMF_SHIKYU_UTIL.debug_output
1192: (
1193: p_output_to => 'FND_LOG.STRING'
1194: ,p_api_name => l_api_name
1195: ,p_message => 'Unknown error and x_receive_quantity is 0 '||SQLCODE||SQLERRM

Line 1244: JMF_SHIKYU_UTIL.debug_output

1240: WHERE l.split_from_line_id = p_line_id
1241: AND l.header_id = p_so_header_id;
1242: BEGIN
1243:
1244: JMF_SHIKYU_UTIL.debug_output
1245: (
1246: p_output_to => 'FND_LOG.STRING'
1247: ,p_api_name => l_api_name
1248: ,p_message => 'procedure begin'

Line 1269: JMF_SHIKYU_UTIL.debug_output

1265: THEN
1266: x_backorder_shipped_quantity := 0;
1267: ELSE
1268: -- begin log
1269: JMF_SHIKYU_UTIL.debug_output
1270: (
1271: p_output_to => 'FND_LOG.STRING'
1272: ,p_api_name => l_api_name
1273: ,p_message => 'back order line exist in '||p_so_header_id

Line 1297: JMF_SHIKYU_UTIL.debug_output

1293: x_backorder_shipped_quantity := l_shipped_quantity_amount;
1294: END IF;
1295:
1296: -- begin log
1297: JMF_SHIKYU_UTIL.debug_output
1298: (
1299: p_output_to => 'FND_LOG.STRING'
1300: ,p_api_name => l_api_name
1301: ,p_message => 'back order line shipped quantity is '||l_shipped_quantity_amount

Line 1305: JMF_SHIKYU_UTIL.debug_output

1301: ,p_message => 'back order line shipped quantity is '||l_shipped_quantity_amount
1302: );
1303: -- end log
1304:
1305: JMF_SHIKYU_UTIL.debug_output
1306: (
1307: p_output_to => 'FND_LOG.STRING'
1308: ,p_api_name => l_api_name
1309: ,p_message => 'END procedure. '

Line 1314: JMF_SHIKYU_UTIL.debug_output

1310: );
1311:
1312: EXCEPTION
1313: WHEN OTHERS THEN
1314: JMF_SHIKYU_UTIL.debug_output
1315: (
1316: p_output_to => 'FND_LOG.STRING'
1317: ,p_api_name => l_api_name
1318: ,p_message => 'Unknown error and x_receive_quantity is 0 '||SQLCODE||SQLERRM

Line 1363: JMF_SHIKYU_UTIL.debug_output

1359: AND ship_methods.To_Organization_Id = p_ship_to_org_id
1360: AND ship_methods.default_flag = 1;
1361:
1362: BEGIN
1363: JMF_SHIKYU_UTIL.debug_output
1364: (
1365: p_output_to => 'FND_LOG.STRING'
1366: ,p_api_name => l_api_name
1367: ,p_message => 'procedure begin'

Line 1384: JMF_SHIKYU_UTIL.debug_output

1380:
1381: END LOOP;
1382: CLOSE ship_method_c;
1383:
1384: JMF_SHIKYU_UTIL.debug_output
1385: (
1386: p_output_to => 'FND_LOG.STRING'
1387: ,p_api_name => l_api_name
1388: ,p_message => 'END procedure. '

Line 1418: JMF_SHIKYU_UTIL.debug_output

1414: l_api_name VARCHAR2(30) := 'get_customer_id';
1415: l_customer_id NUMBER;
1416: l_customer_site_id NUMBER;
1417: BEGIN
1418: JMF_SHIKYU_UTIL.debug_output
1419: (
1420: p_output_to => 'FND_LOG.STRING'
1421: ,p_api_name => l_api_name
1422: ,p_message => 'procedure begin'

Line 1440: JMF_SHIKYU_UTIL.debug_output

1436: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1437: AND hoi.organization_id = p_org_inventory_id;
1438: EXCEPTION
1439: WHEN no_data_found THEN
1440: JMF_SHIKYU_UTIL.debug_output
1441: (
1442: p_output_to => 'FND_LOG.STRING'
1443: ,p_api_name => l_api_name
1444: ,p_message => 'no data find customer name, customer site name'

Line 1448: JMF_SHIKYU_UTIL.debug_output

1444: ,p_message => 'no data find customer name, customer site name'
1445: );
1446: RAISE;
1447: WHEN too_many_rows THEN
1448: JMF_SHIKYU_UTIL.debug_output
1449: (
1450: p_output_to => 'FND_LOG.STRING'
1451: ,p_api_name => l_api_name
1452: ,p_message => 'too many rows when find customer name, customer site name'

Line 1460: JMF_SHIKYU_UTIL.debug_output

1456:
1457: x_customer_id := l_customer_id;
1458: x_customer_site_id := l_customer_site_id;
1459:
1460: JMF_SHIKYU_UTIL.debug_output
1461: (
1462: p_output_to => 'FND_LOG.STRING'
1463: ,p_api_name => l_api_name
1464: ,p_message => 'END procedure. '

Line 1469: JMF_SHIKYU_UTIL.debug_output

1465: );
1466:
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: JMF_SHIKYU_UTIL.debug_output
1470: (
1471: p_output_to => 'FND_LOG.STRING'
1472: ,p_api_name => l_api_name
1473: ,p_message => 'Unknown error'||SQLCODE||SQLERRM

Line 1508: JMF_SHIKYU_UTIL.debug_output

1504: l_supplier_name po_vendors.vendor_name%TYPE;
1505:
1506: BEGIN
1507:
1508: JMF_SHIKYU_UTIL.debug_output
1509: (
1510: p_output_to => 'FND_LOG.STRING'
1511: ,p_api_name => l_api_name
1512: ,p_message => 'procedure begin'

Line 1528: JMF_SHIKYU_UTIL.debug_output

1524: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1525: AND hoi.organization_id = p_sold_from_org_id;
1526: EXCEPTION
1527: WHEN no_data_found THEN
1528: JMF_SHIKYU_UTIL.debug_output
1529: (
1530: p_output_to => 'FND_LOG.STRING'
1531: ,p_api_name => l_api_name
1532: ,p_message => 'no data find supplier id'

Line 1536: JMF_SHIKYU_UTIL.debug_output

1532: ,p_message => 'no data find supplier id'
1533: );
1534: RAISE;
1535: WHEN too_many_rows THEN
1536: JMF_SHIKYU_UTIL.debug_output
1537: (
1538: p_output_to => 'FND_LOG.STRING'
1539: ,p_api_name => l_api_name
1540: ,p_message => 'too many rows when find supplier id'

Line 1555: JMF_SHIKYU_UTIL.debug_output

1551: FROM po_vendors
1552: WHERE po_vendors.vendor_id = l_supplier_id;
1553: EXCEPTION
1554: WHEN no_data_found THEN
1555: JMF_SHIKYU_UTIL.debug_output
1556: (
1557: p_output_to => 'FND_LOG.STRING'
1558: ,p_api_name => l_api_name
1559: ,p_message => 'no data find supplier name'

Line 1563: JMF_SHIKYU_UTIL.debug_output

1559: ,p_message => 'no data find supplier name'
1560: );
1561: RAISE;
1562: WHEN too_many_rows THEN
1563: JMF_SHIKYU_UTIL.debug_output
1564: (
1565: p_output_to => 'FND_LOG.STRING'
1566: ,p_api_name => l_api_name
1567: ,p_message => 'too many rows when find supplier name'

Line 1573: JMF_SHIKYU_UTIL.debug_output

1569: RAISE;
1570:
1571: END;
1572:
1573: JMF_SHIKYU_UTIL.debug_output
1574: (
1575: p_output_to => 'FND_LOG.STRING'
1576: ,p_api_name => l_api_name
1577: ,p_message => 'END procedure. '

Line 1582: JMF_SHIKYU_UTIL.debug_output

1578: );
1579:
1580: EXCEPTION
1581: WHEN OTHERS THEN
1582: JMF_SHIKYU_UTIL.debug_output
1583: (
1584: p_output_to => 'FND_LOG.STRING'
1585: ,p_api_name => l_api_name
1586: ,p_message => 'Unknown error '||SQLCODE||SQLERRM

Line 1705: JMF_SHIKYU_UTIL.debug_output

1701: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1702: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1703:
1704: BEGIN
1705: JMF_SHIKYU_UTIL.debug_output
1706: (
1707: p_output_to => 'FND_LOG.STRING'
1708: ,p_api_name => l_api_name
1709: ,p_message => 'procedure begin'

Line 1711: /* JMF_SHIKYU_UTIL.debug_output

1707: p_output_to => 'FND_LOG.STRING'
1708: ,p_api_name => l_api_name
1709: ,p_message => 'procedure begin'
1710: );
1711: /* JMF_SHIKYU_UTIL.debug_output
1712: (
1713: p_output_to => 'FND_LOG.STRING'
1714: ,p_api_name => l_api_name
1715: ,p_message => 'p_line_id '||p_line_id

Line 1717: JMF_SHIKYU_UTIL.debug_output

1713: p_output_to => 'FND_LOG.STRING'
1714: ,p_api_name => l_api_name
1715: ,p_message => 'p_line_id '||p_line_id
1716: );*/
1717: JMF_SHIKYU_UTIL.debug_output
1718: (
1719: p_output_to => 'FND_LOG.STRING'
1720: ,p_api_name => l_api_name
1721: ,p_message => 'p_po_header_id '||p_po_header_id

Line 1723: JMF_SHIKYU_UTIL.debug_output

1719: p_output_to => 'FND_LOG.STRING'
1720: ,p_api_name => l_api_name
1721: ,p_message => 'p_po_header_id '||p_po_header_id
1722: );
1723: JMF_SHIKYU_UTIL.debug_output
1724: (
1725: p_output_to => 'FND_LOG.STRING'
1726: ,p_api_name => l_api_name
1727: ,p_message => 'p_po_line_id'||p_po_line_id

Line 1729: JMF_SHIKYU_UTIL.debug_output

1725: p_output_to => 'FND_LOG.STRING'
1726: ,p_api_name => l_api_name
1727: ,p_message => 'p_po_line_id'||p_po_line_id
1728: );
1729: JMF_SHIKYU_UTIL.debug_output
1730: (
1731: p_output_to => 'FND_LOG.STRING'
1732: ,p_api_name => l_api_name
1733: ,p_message => 'p_po_shipment_id'||p_po_shipment_id

Line 1735: JMF_SHIKYU_UTIL.debug_output

1731: p_output_to => 'FND_LOG.STRING'
1732: ,p_api_name => l_api_name
1733: ,p_message => 'p_po_shipment_id'||p_po_shipment_id
1734: );
1735: JMF_SHIKYU_UTIL.debug_output
1736: (
1737: p_output_to => 'FND_LOG.STRING'
1738: ,p_api_name => l_api_name
1739: ,p_message => 'p_ship_from_org_id'||p_ship_from_org_id

Line 1741: JMF_SHIKYU_UTIL.debug_output

1737: p_output_to => 'FND_LOG.STRING'
1738: ,p_api_name => l_api_name
1739: ,p_message => 'p_ship_from_org_id'||p_ship_from_org_id
1740: );
1741: JMF_SHIKYU_UTIL.debug_output
1742: (
1743: p_output_to => 'FND_LOG.STRING'
1744: ,p_api_name => l_api_name
1745: ,p_message => 'p_ship_to_org_id'||p_ship_to_org_id

Line 1747: JMF_SHIKYU_UTIL.debug_output

1743: p_output_to => 'FND_LOG.STRING'
1744: ,p_api_name => l_api_name
1745: ,p_message => 'p_ship_to_org_id'||p_ship_to_org_id
1746: );
1747: JMF_SHIKYU_UTIL.debug_output
1748: (
1749: p_output_to => 'FND_LOG.STRING'
1750: ,p_api_name => l_api_name
1751: ,p_message => 'p_receive_quantity'||p_receive_quantity

Line 1767: JMF_SHIKYU_UTIL.debug_output

1763: mtl_units_of_measure_vl uom
1764: WHERE uom.uom_code = p_primary_uom_code;
1765: EXCEPTION
1766: WHEN no_data_found THEN
1767: JMF_SHIKYU_UTIL.debug_output
1768: (
1769: p_output_to => 'FND_LOG.STRING'
1770: ,p_api_name => l_api_name
1771: ,p_message => 'no data found when select receiving_routing_id by line_location_id'

Line 1776: JMF_SHIKYU_UTIL.debug_output

1772: );
1773: RAISE;
1774: END;
1775:
1776: JMF_SHIKYU_UTIL.debug_output
1777: (
1778: p_output_to => 'FND_LOG.STRING'
1779: ,p_api_name => l_api_name
1780: ,p_message => 'l_unit_of_measure'||l_primary_uom

Line 1794: JMF_SHIKYU_UTIL.debug_output

1790: PO_LINE_LOCATIONS_ALL location
1791: WHERE location.line_location_id = p_po_shipment_id;
1792: EXCEPTION
1793: WHEN no_data_found THEN
1794: JMF_SHIKYU_UTIL.debug_output
1795: (
1796: p_output_to => 'FND_LOG.STRING'
1797: ,p_api_name => l_api_name
1798: ,p_message => 'no data found when select receiving_routing_id by line_location_id'

Line 1810: JMF_SHIKYU_UTIL.debug_output

1806: , x_supplier_site_id => l_supplier_site_id
1807: );
1808:
1809: -- begin debug log
1810: JMF_SHIKYU_UTIL.debug_output
1811: (
1812: p_output_to => 'FND_LOG.STRING'
1813: ,p_api_name => l_api_name
1814: ,p_message => 'begin process_rcv_header'

Line 1816: JMF_SHIKYU_UTIL.debug_output

1812: p_output_to => 'FND_LOG.STRING'
1813: ,p_api_name => l_api_name
1814: ,p_message => 'begin process_rcv_header'
1815: );
1816: JMF_SHIKYU_UTIL.debug_output
1817: (
1818: p_output_to => 'FND_LOG.STRING'
1819: ,p_api_name => l_api_name
1820: ,p_message => 'p_vendor_id '||l_supplier_id

Line 1822: JMF_SHIKYU_UTIL.debug_output

1818: p_output_to => 'FND_LOG.STRING'
1819: ,p_api_name => l_api_name
1820: ,p_message => 'p_vendor_id '||l_supplier_id
1821: );
1822: JMF_SHIKYU_UTIL.debug_output
1823: (
1824: p_output_to => 'FND_LOG.STRING'
1825: ,p_api_name => l_api_name
1826: ,p_message => 'p_vendor_site_id '||l_supplier_site_id

Line 1828: JMF_SHIKYU_UTIL.debug_output

1824: p_output_to => 'FND_LOG.STRING'
1825: ,p_api_name => l_api_name
1826: ,p_message => 'p_vendor_site_id '||l_supplier_site_id
1827: );
1828: JMF_SHIKYU_UTIL.debug_output
1829: (
1830: p_output_to => 'FND_LOG.STRING'
1831: ,p_api_name => l_api_name
1832: ,p_message => 'p_ship_to_org_id'||p_inventory_org_id

Line 1845: JMF_SHIKYU_UTIL.debug_output

1841: , x_group_id => l_group_id
1842: );
1843:
1844: -- begin debug log
1845: JMF_SHIKYU_UTIL.debug_output
1846: (
1847: p_output_to => 'FND_LOG.STRING'
1848: ,p_api_name => l_api_name
1849: ,p_message => 'l_rcv_header_id '||l_rcv_header_id

Line 1851: JMF_SHIKYU_UTIL.debug_output

1847: p_output_to => 'FND_LOG.STRING'
1848: ,p_api_name => l_api_name
1849: ,p_message => 'l_rcv_header_id '||l_rcv_header_id
1850: );
1851: JMF_SHIKYU_UTIL.debug_output
1852: (
1853: p_output_to => 'FND_LOG.STRING'
1854: ,p_api_name => l_api_name
1855: ,p_message => 'l_group_id'||l_group_id

Line 1857: JMF_SHIKYU_UTIL.debug_output

1853: p_output_to => 'FND_LOG.STRING'
1854: ,p_api_name => l_api_name
1855: ,p_message => 'l_group_id'||l_group_id
1856: );
1857: JMF_SHIKYU_UTIL.debug_output
1858: (
1859: p_output_to => 'FND_LOG.STRING'
1860: ,p_api_name => l_api_name
1861: ,p_message => 'end process_rcv_header'

Line 1866: JMF_SHIKYU_UTIL.debug_output

1862: );
1863: -- end debug log
1864:
1865: -- begin debug log
1866: JMF_SHIKYU_UTIL.debug_output
1867: (
1868: p_output_to => 'FND_LOG.STRING'
1869: ,p_api_name => l_api_name
1870: ,p_message => 'l_routing_header_id'||l_routing_header_id

Line 1879: JMF_SHIKYU_UTIL.debug_output

1875: WHILE l_index IS NOT NULL
1876: LOOP
1877:
1878: -- begin debug log
1879: JMF_SHIKYU_UTIL.debug_output
1880: (
1881: p_output_to => 'FND_LOG.STRING'
1882: ,p_api_name => l_api_name
1883: ,p_message => 'Begin cursor po_distributions_c loop'

Line 1885: JMF_SHIKYU_UTIL.debug_output

1881: p_output_to => 'FND_LOG.STRING'
1882: ,p_api_name => l_api_name
1883: ,p_message => 'Begin cursor po_distributions_c loop'
1884: );
1885: JMF_SHIKYU_UTIL.debug_output
1886: (
1887: p_output_to => 'FND_LOG.STRING'
1888: ,p_api_name => l_api_name
1889: ,p_message => 'p_po_shipment_id'||p_po_shipment_id

Line 1891: JMF_SHIKYU_UTIL.debug_output

1887: p_output_to => 'FND_LOG.STRING'
1888: ,p_api_name => l_api_name
1889: ,p_message => 'p_po_shipment_id'||p_po_shipment_id
1890: );
1891: JMF_SHIKYU_UTIL.debug_output
1892: (
1893: p_output_to => 'FND_LOG.STRING'
1894: ,p_api_name => l_api_name
1895: ,p_message => 'p_lines_id(l_index)'||p_lines_id(l_index)

Line 1920: , p_current_uom_code => JMF_SHIKYU_UTIL.Get_Uom_Code(l_po_uom)

1916: -- Bug#5647346: convert l_quantity_ordered, l_quantity_delivered, l_allocated_quantity to primary UOM
1917: l_prm_uom_quantity_ordered := Jmf_Shikyu_Rpt_Util.get_item_primary_quantity
1918: ( p_org_id => p_inventory_org_id
1919: , p_item_id => l_item_id
1920: , p_current_uom_code => JMF_SHIKYU_UTIL.Get_Uom_Code(l_po_uom)
1921: , p_current_qty => l_quantity_ordered
1922: );
1923: l_prm_uom_quantity_delivered := Jmf_Shikyu_Rpt_Util.get_item_primary_quantity
1924: ( p_org_id => p_inventory_org_id

Line 1926: , p_current_uom_code => JMF_SHIKYU_UTIL.Get_Uom_Code(l_po_uom)

1922: );
1923: l_prm_uom_quantity_delivered := Jmf_Shikyu_Rpt_Util.get_item_primary_quantity
1924: ( p_org_id => p_inventory_org_id
1925: , p_item_id => l_item_id
1926: , p_current_uom_code => JMF_SHIKYU_UTIL.Get_Uom_Code(l_po_uom)
1927: , p_current_qty => l_quantity_delivered
1928: );
1929: l_prm_uom_allocated_quantity := Jmf_Shikyu_Rpt_Util.get_item_primary_quantity
1930: ( p_org_id => p_inventory_org_id

Line 1932: , p_current_uom_code => JMF_SHIKYU_UTIL.Get_Uom_Code(l_so_uom)

1928: );
1929: l_prm_uom_allocated_quantity := Jmf_Shikyu_Rpt_Util.get_item_primary_quantity
1930: ( p_org_id => p_inventory_org_id
1931: , p_item_id => l_item_id
1932: , p_current_uom_code => JMF_SHIKYU_UTIL.Get_Uom_Code(l_so_uom)
1933: , p_current_qty => l_allocated_quantity
1934: );
1935:
1936: -- begin insert data to interface,

Line 1963: JMF_SHIKYU_UTIL.debug_output

1959: -- find the default subinventory
1960: -- if default is not null
1961: -- then ok
1962: -- else send a message.
1963: JMF_SHIKYU_UTIL.debug_output
1964: (
1965: p_output_to => 'FND_LOG.STRING'
1966: ,p_api_name => l_api_name
1967: ,p_message => 'Dest_subinventory is null'

Line 1977: JMF_SHIKYU_UTIL.debug_output

1973: FROM wip_parameters wip_para
1974: WHERE wip_para.Organization_Id = p_inventory_org_id;
1975: EXCEPTION
1976: WHEN no_data_found THEN
1977: JMF_SHIKYU_UTIL.debug_output
1978: (
1979: p_output_to => 'FND_LOG.STRING'
1980: ,p_api_name => l_api_name
1981: ,p_message => 'no data found when found subinventory by org id'

Line 1986: JMF_SHIKYU_UTIL.debug_output

1982: );
1983:
1984: -- log a message that the default sub inventory should be setup
1985: fnd_message.set_name('JMF', 'JMF_SHK_WIP_SUBINV_MIS');
1986: JMF_SHIKYU_UTIL.debug_output
1987: (
1988: p_output_to => 'FND_LOG.STRING'
1989: ,p_api_name => l_api_name
1990: ,p_message => fnd_message.GET

Line 1995: JMF_SHIKYU_UTIL.debug_output

1991: );
1992:
1993: RAISE;
1994: WHEN too_many_rows THEN
1995: JMF_SHIKYU_UTIL.debug_output
1996: (
1997: p_output_to => 'FND_LOG.STRING'
1998: ,p_api_name => l_api_name
1999: ,p_message => 'too many rows when found sub inventory by org id'

Line 2007: JMF_SHIKYU_UTIL.debug_output

2003:
2004: END IF;
2005:
2006: -- begin debug log
2007: JMF_SHIKYU_UTIL.debug_output
2008: (
2009: p_output_to => 'FND_LOG.STRING'
2010: ,p_api_name => l_api_name
2011: ,p_message => 'l_dest_subinventory'||l_dest_subinventory

Line 2028: JMF_SHIKYU_UTIL.debug_output

2024: FROM wip_parameters wip_para
2025: WHERE wip_para.Organization_Id = p_inventory_org_id;
2026: EXCEPTION
2027: WHEN no_data_found THEN
2028: JMF_SHIKYU_UTIL.debug_output
2029: (
2030: p_output_to => 'FND_LOG.STRING'
2031: ,p_api_name => l_api_name
2032: ,p_message => 'no data found when found locator by org id'

Line 2037: JMF_SHIKYU_UTIL.debug_output

2033: );
2034:
2035: RAISE;
2036: WHEN too_many_rows THEN
2037: JMF_SHIKYU_UTIL.debug_output
2038: (
2039: p_output_to => 'FND_LOG.STRING'
2040: ,p_api_name => l_api_name
2041: ,p_message => 'too many rows when found default locator by org id'

Line 2047: JMF_SHIKYU_UTIL.debug_output

2043: RAISE;
2044: END;
2045:
2046: -- begin debug log
2047: JMF_SHIKYU_UTIL.debug_output
2048: (
2049: p_output_to => 'FND_LOG.STRING'
2050: ,p_api_name => l_api_name
2051: ,p_message => 'l_default_locator_id'||l_default_locator_id

Line 2064: JMF_SHIKYU_UTIL.debug_output

2060: WHERE msi.Organization_Id = p_inventory_org_id
2061: AND msi.SECONDARY_INVENTORY_NAME = l_dest_subinventory;
2062: EXCEPTION
2063: WHEN no_data_found THEN
2064: JMF_SHIKYU_UTIL.debug_output
2065: (
2066: p_output_to => 'FND_LOG.STRING'
2067: ,p_api_name => l_api_name
2068: ,p_message => 'no data found when found locator type by org id and locator id'

Line 2074: JMF_SHIKYU_UTIL.debug_output

2070: RAISE;
2071: END;
2072:
2073: -- begin debug log
2074: JMF_SHIKYU_UTIL.debug_output
2075: (
2076: p_output_to => 'FND_LOG.STRING'
2077: ,p_api_name => l_api_name
2078: ,p_message => 'l_locator_type'||l_locator_type

Line 2090: JMF_SHIKYU_UTIL.debug_output

2086: FROM OE_ORDER_LINES_ALL oola
2087: WHERE oola.line_id = p_lines_id(l_index);
2088: EXCEPTION
2089: WHEN no_data_found THEN
2090: JMF_SHIKYU_UTIL.debug_output
2091: (
2092: p_output_to => 'FND_LOG.STRING'
2093: ,p_api_name => l_api_name
2094: ,p_message => 'no data found when found project id and task id by org id and locator id'

Line 2100: JMF_SHIKYU_UTIL.debug_output

2096: RAISE;
2097: END;
2098:
2099: -- begin debug log
2100: JMF_SHIKYU_UTIL.debug_output
2101: (
2102: p_output_to => 'FND_LOG.STRING'
2103: ,p_api_name => l_api_name
2104: ,p_message => 'l_project_id'||l_project_id

Line 2106: JMF_SHIKYU_UTIL.debug_output

2102: p_output_to => 'FND_LOG.STRING'
2103: ,p_api_name => l_api_name
2104: ,p_message => 'l_project_id'||l_project_id
2105: );
2106: JMF_SHIKYU_UTIL.debug_output
2107: (
2108: p_output_to => 'FND_LOG.STRING'
2109: ,p_api_name => l_api_name
2110: ,p_message => 'l_task_id'||l_task_id

Line 2130: JMF_SHIKYU_UTIL.debug_output

2126: l_dest_locator_id := l_default_locator_id;
2127: END IF;
2128:
2129: -- begin debug log
2130: JMF_SHIKYU_UTIL.debug_output
2131: (
2132: p_output_to => 'FND_LOG.STRING'
2133: ,p_api_name => l_api_name
2134: ,p_message => 'l_dest_locator_id'||l_dest_locator_id

Line 2143: JMF_SHIKYU_UTIL.debug_output

2139:
2140: -- get all of the data
2141: ELSE /*l_quantity_ordered - l_quantity_delivered <= 0*/
2142: --begin log
2143: JMF_SHIKYU_UTIL.debug_output
2144: (
2145: p_output_to => 'FND_LOG.STRING'
2146: ,p_api_name => l_api_name
2147: ,p_message => 'the quantity auto receive finished '

Line 2153: JMF_SHIKYU_UTIL.debug_output

2149: --end log
2150: END IF ; /*end if l_quantity_ordered - l_quantity_delivered > 0 */
2151:
2152: -- begin debug log
2153: JMF_SHIKYU_UTIL.debug_output
2154: (
2155: p_output_to => 'FND_LOG.STRING'
2156: ,p_api_name => l_api_name
2157: ,p_message => 'begin process_rcv_trx'

Line 2159: JMF_SHIKYU_UTIL.debug_output

2155: p_output_to => 'FND_LOG.STRING'
2156: ,p_api_name => l_api_name
2157: ,p_message => 'begin process_rcv_trx'
2158: );
2159: JMF_SHIKYU_UTIL.debug_output
2160: (
2161: p_output_to => 'FND_LOG.STRING'
2162: ,p_api_name => l_api_name
2163: ,p_message => 'l_rcv_header_id '||l_rcv_header_id

Line 2165: JMF_SHIKYU_UTIL.debug_output

2161: p_output_to => 'FND_LOG.STRING'
2162: ,p_api_name => l_api_name
2163: ,p_message => 'l_rcv_header_id '||l_rcv_header_id
2164: );
2165: JMF_SHIKYU_UTIL.debug_output
2166: (
2167: p_output_to => 'FND_LOG.STRING'
2168: ,p_api_name => l_api_name
2169: ,p_message => 'l_insert_quantity'||l_insert_quantity

Line 2171: JMF_SHIKYU_UTIL.debug_output

2167: p_output_to => 'FND_LOG.STRING'
2168: ,p_api_name => l_api_name
2169: ,p_message => 'l_insert_quantity'||l_insert_quantity
2170: );
2171: JMF_SHIKYU_UTIL.debug_output
2172: (
2173: p_output_to => 'FND_LOG.STRING'
2174: ,p_api_name => l_api_name
2175: ,p_message => 'l_unit_of_measure'||l_so_uom

Line 2177: JMF_SHIKYU_UTIL.debug_output

2173: p_output_to => 'FND_LOG.STRING'
2174: ,p_api_name => l_api_name
2175: ,p_message => 'l_unit_of_measure'||l_so_uom
2176: );
2177: JMF_SHIKYU_UTIL.debug_output
2178: (
2179: p_output_to => 'FND_LOG.STRING'
2180: ,p_api_name => l_api_name
2181: ,p_message => 'p_po_header_id'||p_po_header_id

Line 2183: JMF_SHIKYU_UTIL.debug_output

2179: p_output_to => 'FND_LOG.STRING'
2180: ,p_api_name => l_api_name
2181: ,p_message => 'p_po_header_id'||p_po_header_id
2182: );
2183: JMF_SHIKYU_UTIL.debug_output
2184: (
2185: p_output_to => 'FND_LOG.STRING'
2186: ,p_api_name => l_api_name
2187: ,p_message => 'p_po_line_id'||p_po_line_id

Line 2189: JMF_SHIKYU_UTIL.debug_output

2185: p_output_to => 'FND_LOG.STRING'
2186: ,p_api_name => l_api_name
2187: ,p_message => 'p_po_line_id'||p_po_line_id
2188: );
2189: JMF_SHIKYU_UTIL.debug_output
2190: (
2191: p_output_to => 'FND_LOG.STRING'
2192: ,p_api_name => l_api_name
2193: ,p_message => 'l_dest_subinventory'||l_dest_subinventory

Line 2195: JMF_SHIKYU_UTIL.debug_output

2191: p_output_to => 'FND_LOG.STRING'
2192: ,p_api_name => l_api_name
2193: ,p_message => 'l_dest_subinventory'||l_dest_subinventory
2194: );
2195: JMF_SHIKYU_UTIL.debug_output
2196: (
2197: p_output_to => 'FND_LOG.STRING'
2198: ,p_api_name => l_api_name
2199: ,p_message => 'l_transaction_type'||l_transaction_type

Line 2201: JMF_SHIKYU_UTIL.debug_output

2197: p_output_to => 'FND_LOG.STRING'
2198: ,p_api_name => l_api_name
2199: ,p_message => 'l_transaction_type'||l_transaction_type
2200: );
2201: JMF_SHIKYU_UTIL.debug_output
2202: (
2203: p_output_to => 'FND_LOG.STRING'
2204: ,p_api_name => l_api_name
2205: ,p_message => 'l_dest_locator_id'||l_dest_locator_id

Line 2207: JMF_SHIKYU_UTIL.debug_output

2203: p_output_to => 'FND_LOG.STRING'
2204: ,p_api_name => l_api_name
2205: ,p_message => 'l_dest_locator_id'||l_dest_locator_id
2206: );
2207: JMF_SHIKYU_UTIL.debug_output
2208: (
2209: p_output_to => 'FND_LOG.STRING'
2210: ,p_api_name => l_api_name
2211: ,p_message => 'p_replenish_order_line_id '||p_lines_id(l_index)

Line 2267: JMF_SHIKYU_UTIL.debug_output

2263: , argument1 => 'BATCH'
2264: , argument2 => l_group_id
2265: );
2266:
2267: JMF_SHIKYU_UTIL.debug_output
2268: (
2269: p_output_to => 'FND_LOG.STRING'
2270: ,p_api_name => l_api_name
2271: ,p_message => 'The request id is : ' || l_return_number

Line 2274: JMF_SHIKYU_UTIL.debug_output

2270: ,p_api_name => l_api_name
2271: ,p_message => 'The request id is : ' || l_return_number
2272: );
2273:
2274: JMF_SHIKYU_UTIL.debug_output
2275: (
2276: p_output_to => 'FND_LOG.STRING'
2277: ,p_api_name => l_api_name
2278: ,p_message => 'END procedure. '

Line 2283: JMF_SHIKYU_UTIL.debug_output

2279: );
2280:
2281: EXCEPTION
2282: WHEN OTHERS THEN
2283: JMF_SHIKYU_UTIL.debug_output
2284: (
2285: p_output_to => 'FND_LOG.STRING'
2286: ,p_api_name => l_api_name
2287: ,p_message => 'Unknown error'||SQLCODE||SQLERRM