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 403: JMF_SHIKYU_UTIL.debug_output

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

Line 409: JMF_SHIKYU_UTIL.debug_output

405: p_output_to => 'FND_LOG.STRING'
406: ,p_api_name => l_api_name
407: ,p_message => 'procedure begin'
408: );
409: JMF_SHIKYU_UTIL.debug_output
410: (
411: p_output_to => 'FND_LOG.STRING'
412: ,p_api_name => l_api_name
413: ,p_message => 'p_header_id :'||p_header_id

Line 424: JMF_SHIKYU_UTIL.debug_output

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

Line 446: JMF_SHIKYU_UTIL.debug_output

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

Line 455: JMF_SHIKYU_UTIL.debug_output

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

Line 461: JMF_SHIKYU_UTIL.debug_output

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

Line 467: JMF_SHIKYU_UTIL.debug_output

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

Line 492: JMF_SHIKYU_UTIL.debug_output

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

Line 513: JMF_SHIKYU_UTIL.debug_output

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

Line 519: JMF_SHIKYU_UTIL.debug_output

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

Line 525: JMF_SHIKYU_UTIL.debug_output

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

Line 531: JMF_SHIKYU_UTIL.debug_output

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

Line 556: JMF_SHIKYU_UTIL.debug_output

552: );
553:
554:
555: -- begin log
556: JMF_SHIKYU_UTIL.debug_output
557: (
558: p_output_to => 'FND_LOG.STRING'
559: ,p_api_name => l_api_name
560: ,p_message => 'l_ship_flag is '|| l_ship_flag||' l_date_flag is '||l_date_flag

Line 570: JMF_SHIKYU_UTIL.debug_output

566: --add line id to l_lines_id
567: l_lines_id.EXTEND;
568: l_lines_id(l_lines_id.COUNT) := l_line_id;
569: ELSE /*l_ship_flag=0 OR l_date_flag=0*/
570: JMF_SHIKYU_UTIL.debug_output
571: (
572: p_output_to => 'FND_LOG.STRING'
573: ,p_api_name => l_api_name
574: ,p_message => 'complete'

Line 582: JMF_SHIKYU_UTIL.debug_output

578: END LOOP; /* end loop replenish_so_line_c*/
579: CLOSE replenish_so_line_c;
580:
581: -- log the line count
582: JMF_SHIKYU_UTIL.debug_output
583: (
584: p_output_to => 'FND_LOG.STRING'
585: ,p_api_name => l_api_name
586: ,p_message => 'lines count '|| l_lines_id.COUNT

Line 604: JMF_SHIKYU_UTIL.debug_output

600: );
601:
602: -- log the quantity should be auto receive
603: -- begin log
604: JMF_SHIKYU_UTIL.debug_output
605: (
606: p_output_to => 'FND_LOG.STRING'
607: ,p_api_name => l_api_name
608: ,p_message => 'p_header_id'||p_header_id

Line 610: JMF_SHIKYU_UTIL.debug_output

606: p_output_to => 'FND_LOG.STRING'
607: ,p_api_name => l_api_name
608: ,p_message => 'p_header_id'||p_header_id
609: );
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_inventory_org_id'||p_inventory_org_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_inventory_org_id'||p_inventory_org_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 => 'l_po_header_id'||l_po_header_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 => 'l_po_header_id'||l_po_header_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_line_id'||l_po_line_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_line_id'||l_po_line_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 => 'the quantity should be auto receive is '|| l_auto_receive_quantity

Line 634: JMF_SHIKYU_UTIL.debug_output

630: p_output_to => 'FND_LOG.STRING'
631: ,p_api_name => l_api_name
632: ,p_message => 'the quantity should be auto receive is '|| l_auto_receive_quantity
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 primary uom code is : '|| l_primary_uom_code

Line 656: JMF_SHIKYU_UTIL.debug_output

652: , p_primary_uom_code => l_primary_uom_code
653: );
654:
655: ELSE -- /*l_auto_receive_quantity <= 0*/
656: JMF_SHIKYU_UTIL.debug_output
657: (
658: p_output_to => 'FND_LOG.STRING'
659: ,p_api_name => l_api_name
660: ,p_message => 'the quantity should be auto receive is <= 0'

Line 667: JMF_SHIKYU_UTIL.debug_output

663:
664:
665: END IF; /*end if l_lines_id.count > 0 */
666:
667: JMF_SHIKYU_UTIL.debug_output
668: (
669: p_output_to => 'FND_LOG.STRING'
670: ,p_api_name => l_api_name
671: ,p_message => 'END procedure. '

Line 676: JMF_SHIKYU_UTIL.debug_output

672: );
673:
674: EXCEPTION
675: WHEN OTHERS THEN
676: JMF_SHIKYU_UTIL.debug_output
677: (
678: p_output_to => 'FND_LOG.STRING'
679: ,p_api_name => l_api_name
680: ,p_message => 'Unknown error '||SQLCODE||SQLERRM

Line 723: JMF_SHIKYU_UTIL.debug_output

719:
720: l_ship_flag NUMBER;
721:
722: BEGIN
723: JMF_SHIKYU_UTIL.debug_output
724: (
725: p_output_to => 'FND_LOG.STRING'
726: ,p_api_name => l_api_name
727: ,p_message => 'procedure begin'

Line 740: JMF_SHIKYU_UTIL.debug_output

736: FROM oe_order_headers_all h
737: WHERE h.header_id = p_header_id;
738: EXCEPTION
739: WHEN no_data_found THEN
740: JMF_SHIKYU_UTIL.debug_output
741: (
742: p_output_to => 'FND_LOG.STRING'
743: ,p_api_name => l_api_name
744: ,p_message => 'can find ship from, or ship to by SO_header_id'

Line 756: JMF_SHIKYU_UTIL.debug_output

752: END IF;
753:
754: x_ship_flag := l_ship_flag;
755:
756: JMF_SHIKYU_UTIL.debug_output
757: (
758: p_output_to => 'FND_LOG.STRING'
759: ,p_api_name => l_api_name
760: ,p_message => 'END procedure. '

Line 765: JMF_SHIKYU_UTIL.debug_output

761: );
762:
763: EXCEPTION
764: WHEN OTHERS THEN
765: JMF_SHIKYU_UTIL.debug_output
766: (
767: p_output_to => 'FND_LOG.STRING'
768: ,p_api_name => l_api_name
769: ,p_message => 'Unknown error, and ship flag is 0 '||SQLCODE||SQLERRM

Line 815: JMF_SHIKYU_UTIL.debug_output

811: l_tp_org_id NUMBER;
812: l_customer_information HR_ORGANIZATION_INFORMATION.Org_Information1%TYPE;
813:
814: BEGIN
815: JMF_SHIKYU_UTIL.debug_output
816: (
817: p_output_to => 'FND_LOG.STRING'
818: ,p_api_name => l_api_name
819: ,p_message => 'procedure begin'

Line 834: JMF_SHIKYU_UTIL.debug_output

830: WHERE hoi.org_information1 = l_customer_information;
831:
832: EXCEPTION
833: WHEN no_data_found THEN
834: JMF_SHIKYU_UTIL.debug_output
835: (
836: p_output_to => 'FND_LOG.STRING'
837: ,p_api_name => l_api_name
838: ,p_message => 'no data found , when find tp org id by ship_to_org_id'

Line 842: JMF_SHIKYU_UTIL.debug_output

838: ,p_message => 'no data found , when find tp org id by ship_to_org_id'
839: );
840: RAISE;
841: WHEN too_many_rows THEN
842: JMF_SHIKYU_UTIL.debug_output
843: (
844: p_output_to => 'FND_LOG.STRING'
845: ,p_api_name => l_api_name
846: ,p_message => 'find too many ship from or ship to by p_header_id'

Line 861: JMF_SHIKYU_UTIL.debug_output

857: WHERE ship_net.FROM_ORGANIZATION_ID = p_line_ship_from_org_id
858: AND ship_net.TO_ORGANIZATION_ID = l_tp_org_id;
859: EXCEPTION
860: WHEN no_data_found THEN
861: JMF_SHIKYU_UTIL.debug_output
862: (
863: p_output_to => 'FND_LOG.STRING'
864: ,p_api_name => l_api_name
865: ,p_message => 'no data found in-transit type'

Line 869: JMF_SHIKYU_UTIL.debug_output

865: ,p_message => 'no data found in-transit type'
866: );
867: RAISE;
868: WHEN too_many_rows THEN
869: JMF_SHIKYU_UTIL.debug_output
870: (
871: p_output_to => 'FND_LOG.STRING'
872: ,p_api_name => l_api_name
873: ,p_message => 'too many rows when find in-transit type'

Line 890: JMF_SHIKYU_UTIL.debug_output

886: , p_ship_method => p_ship_method
887: , x_in_transit => l_in_transit);
888:
889: ELSE -- the intransit_type is not 1 and 2 (direct and intransit)
890: JMF_SHIKYU_UTIL.debug_output
891: (
892: p_output_to => 'FND_LOG.STRING'
893: ,p_api_name => l_api_name
894: ,p_message => 'Error: intransit type is not direct nor intransit'

Line 899: JMF_SHIKYU_UTIL.debug_output

895: );
896: END IF; /*l_intransit_type = 1 */
897:
898: -- begin debug log
899: JMF_SHIKYU_UTIL.debug_output
900: (
901: p_output_to => 'FND_LOG.STRING'
902: ,p_api_name => l_api_name
903: ,p_message => 'l_in_transit'||l_in_transit

Line 916: JMF_SHIKYU_UTIL.debug_output

912: END IF; /*l_receive_date <= SYSDATE */
913:
914: x_date_flag := l_date_flag;
915:
916: JMF_SHIKYU_UTIL.debug_output
917: (
918: p_output_to => 'FND_LOG.STRING'
919: ,p_api_name => l_api_name
920: ,p_message => 'END procedure. '

Line 924: JMF_SHIKYU_UTIL.debug_output

920: ,p_message => 'END procedure. '
921: );
922: EXCEPTION
923: WHEN OTHERS THEN
924: JMF_SHIKYU_UTIL.debug_output
925: (
926: p_output_to => 'FND_LOG.STRING'
927: ,p_api_name => l_api_name
928: ,p_message => 'Unknown error and date flag is 0 '||SQLCODE||SQLERRM

Line 1005: JMF_SHIKYU_UTIL.debug_output

1001: l_index NUMBER;
1002:
1003: BEGIN
1004:
1005: JMF_SHIKYU_UTIL.debug_output
1006: (
1007: p_output_to => 'FND_LOG.STRING'
1008: ,p_api_name => l_api_name
1009: ,p_message => 'procedure begin'

Line 1040: JMF_SHIKYU_UTIL.debug_output

1036: WHERE l.line_id = p_lines_id(l_index);
1037:
1038: EXCEPTION
1039: WHEN no_data_found THEN
1040: JMF_SHIKYU_UTIL.debug_output
1041: (
1042: p_output_to => 'FND_LOG.STRING'
1043: ,p_api_name => l_api_name
1044: ,p_message => 'no data found when find shipped_quantity and item_id'

Line 1048: JMF_SHIKYU_UTIL.debug_output

1044: ,p_message => 'no data found when find shipped_quantity and item_id'
1045: );
1046: RAISE;
1047: WHEN too_many_rows THEN
1048: JMF_SHIKYU_UTIL.debug_output
1049: (
1050: p_output_to => 'FND_LOG.STRING'
1051: ,p_api_name => l_api_name
1052: ,p_message => 'too many rows when find shipped_quantity and item_id'

Line 1074: JMF_SHIKYU_UTIL.debug_output

1070: , p_current_uom_code => l_uom_code
1071: , p_current_qty => l_line_quantity
1072: );
1073:
1074: JMF_SHIKYU_UTIL.debug_output
1075: (
1076: p_output_to => 'FND_LOG.STRING'
1077: ,p_api_name => l_api_name
1078: ,p_message => 'l_prm_uom_quantity_so :' || l_prm_uom_quantity_so

Line 1088: JMF_SHIKYU_UTIL.debug_output

1084: ,p_inventory_org_id => p_inventory_org_id
1085: ,x_backorder_shipped_quantity => l_backorder_shipped_quantity
1086: );
1087:
1088: JMF_SHIKYU_UTIL.debug_output
1089: (
1090: p_output_to => 'FND_LOG.STRING'
1091: ,p_api_name => l_api_name
1092: ,p_message => 'l_backorder_shipped_quantity :' || l_backorder_shipped_quantity

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

1095: -- this should be open if this porcedure is avilable.
1096:
1097: -- sub the return quantity (the returned quantity is in primary UOM)
1098:
1099: l_returned_quantity := jmf_shikyu_util.Get_Replenish_So_Returned_Qty(p_replenishment_so_line_id => p_lines_id(l_index));
1100:
1101: JMF_SHIKYU_UTIL.debug_output
1102: (
1103: p_output_to => 'FND_LOG.STRING'

Line 1101: JMF_SHIKYU_UTIL.debug_output

1097: -- sub the return quantity (the returned quantity is in primary UOM)
1098:
1099: l_returned_quantity := jmf_shikyu_util.Get_Replenish_So_Returned_Qty(p_replenishment_so_line_id => p_lines_id(l_index));
1100:
1101: JMF_SHIKYU_UTIL.debug_output
1102: (
1103: p_output_to => 'FND_LOG.STRING'
1104: ,p_api_name => l_api_name
1105: ,p_message => 'l_returned_quantity :' || l_returned_quantity

Line 1125: JMF_SHIKYU_UTIL.debug_output

1121: WHERE locate.line_location_id = p_po_shipment_id;
1122:
1123: EXCEPTION
1124: WHEN no_data_found THEN
1125: JMF_SHIKYU_UTIL.debug_output
1126: (
1127: p_output_to => 'FND_LOG.STRING'
1128: ,p_api_name => l_api_name
1129: ,p_message => 'no data found , when find quantity_received by line_location_id'

Line 1143: JMF_SHIKYU_UTIL.debug_output

1139: AND uom.LANGUAGE = userenv('LANG');
1140:
1141: EXCEPTION
1142: WHEN no_data_found THEN
1143: JMF_SHIKYU_UTIL.debug_output
1144: (
1145: p_output_to => 'FND_LOG.STRING'
1146: ,p_api_name => l_api_name
1147: ,p_message => 'no data found , when find uom_code by unit_of_measure'

Line 1163: JMF_SHIKYU_UTIL.debug_output

1159:
1160: -- compare
1161: x_receive_quantity := l_shipped_quantity - l_prm_uom_quantity_po;
1162:
1163: JMF_SHIKYU_UTIL.debug_output
1164: (
1165: p_output_to => 'FND_LOG.STRING'
1166: ,p_api_name => l_api_name
1167: ,p_message => 'END procedure. '

Line 1171: JMF_SHIKYU_UTIL.debug_output

1167: ,p_message => 'END procedure. '
1168: );
1169: EXCEPTION
1170: WHEN OTHERS THEN
1171: JMF_SHIKYU_UTIL.debug_output
1172: (
1173: p_output_to => 'FND_LOG.STRING'
1174: ,p_api_name => l_api_name
1175: ,p_message => 'Unknown error and x_receive_quantity is 0 '||SQLCODE||SQLERRM

Line 1224: JMF_SHIKYU_UTIL.debug_output

1220: WHERE l.split_from_line_id = p_line_id
1221: AND l.header_id = p_so_header_id;
1222: BEGIN
1223:
1224: JMF_SHIKYU_UTIL.debug_output
1225: (
1226: p_output_to => 'FND_LOG.STRING'
1227: ,p_api_name => l_api_name
1228: ,p_message => 'procedure begin'

Line 1249: JMF_SHIKYU_UTIL.debug_output

1245: THEN
1246: x_backorder_shipped_quantity := 0;
1247: ELSE
1248: -- begin log
1249: JMF_SHIKYU_UTIL.debug_output
1250: (
1251: p_output_to => 'FND_LOG.STRING'
1252: ,p_api_name => l_api_name
1253: ,p_message => 'back order line exist in '||p_so_header_id

Line 1277: JMF_SHIKYU_UTIL.debug_output

1273: x_backorder_shipped_quantity := l_shipped_quantity_amount;
1274: END IF;
1275:
1276: -- begin log
1277: JMF_SHIKYU_UTIL.debug_output
1278: (
1279: p_output_to => 'FND_LOG.STRING'
1280: ,p_api_name => l_api_name
1281: ,p_message => 'back order line shipped quantity is '||l_shipped_quantity_amount

Line 1285: JMF_SHIKYU_UTIL.debug_output

1281: ,p_message => 'back order line shipped quantity is '||l_shipped_quantity_amount
1282: );
1283: -- end log
1284:
1285: JMF_SHIKYU_UTIL.debug_output
1286: (
1287: p_output_to => 'FND_LOG.STRING'
1288: ,p_api_name => l_api_name
1289: ,p_message => 'END procedure. '

Line 1294: JMF_SHIKYU_UTIL.debug_output

1290: );
1291:
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294: JMF_SHIKYU_UTIL.debug_output
1295: (
1296: p_output_to => 'FND_LOG.STRING'
1297: ,p_api_name => l_api_name
1298: ,p_message => 'Unknown error and x_receive_quantity is 0 '||SQLCODE||SQLERRM

Line 1343: JMF_SHIKYU_UTIL.debug_output

1339: AND ship_methods.To_Organization_Id = p_ship_to_org_id
1340: AND ship_methods.default_flag = 1;
1341:
1342: BEGIN
1343: JMF_SHIKYU_UTIL.debug_output
1344: (
1345: p_output_to => 'FND_LOG.STRING'
1346: ,p_api_name => l_api_name
1347: ,p_message => 'procedure begin'

Line 1364: JMF_SHIKYU_UTIL.debug_output

1360:
1361: END LOOP;
1362: CLOSE ship_method_c;
1363:
1364: JMF_SHIKYU_UTIL.debug_output
1365: (
1366: p_output_to => 'FND_LOG.STRING'
1367: ,p_api_name => l_api_name
1368: ,p_message => 'END procedure. '

Line 1398: JMF_SHIKYU_UTIL.debug_output

1394: l_api_name VARCHAR2(30) := 'get_customer_id';
1395: l_customer_id NUMBER;
1396: l_customer_site_id NUMBER;
1397: BEGIN
1398: JMF_SHIKYU_UTIL.debug_output
1399: (
1400: p_output_to => 'FND_LOG.STRING'
1401: ,p_api_name => l_api_name
1402: ,p_message => 'procedure begin'

Line 1420: JMF_SHIKYU_UTIL.debug_output

1416: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1417: AND hoi.organization_id = p_org_inventory_id;
1418: EXCEPTION
1419: WHEN no_data_found THEN
1420: JMF_SHIKYU_UTIL.debug_output
1421: (
1422: p_output_to => 'FND_LOG.STRING'
1423: ,p_api_name => l_api_name
1424: ,p_message => 'no data find customer name, customer site name'

Line 1428: JMF_SHIKYU_UTIL.debug_output

1424: ,p_message => 'no data find customer name, customer site name'
1425: );
1426: RAISE;
1427: WHEN too_many_rows THEN
1428: JMF_SHIKYU_UTIL.debug_output
1429: (
1430: p_output_to => 'FND_LOG.STRING'
1431: ,p_api_name => l_api_name
1432: ,p_message => 'too many rows when find customer name, customer site name'

Line 1440: JMF_SHIKYU_UTIL.debug_output

1436:
1437: x_customer_id := l_customer_id;
1438: x_customer_site_id := l_customer_site_id;
1439:
1440: JMF_SHIKYU_UTIL.debug_output
1441: (
1442: p_output_to => 'FND_LOG.STRING'
1443: ,p_api_name => l_api_name
1444: ,p_message => 'END procedure. '

Line 1449: JMF_SHIKYU_UTIL.debug_output

1445: );
1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: JMF_SHIKYU_UTIL.debug_output
1450: (
1451: p_output_to => 'FND_LOG.STRING'
1452: ,p_api_name => l_api_name
1453: ,p_message => 'Unknown error'||SQLCODE||SQLERRM

Line 1488: JMF_SHIKYU_UTIL.debug_output

1484: l_supplier_name po_vendors.vendor_name%TYPE;
1485:
1486: BEGIN
1487:
1488: JMF_SHIKYU_UTIL.debug_output
1489: (
1490: p_output_to => 'FND_LOG.STRING'
1491: ,p_api_name => l_api_name
1492: ,p_message => 'procedure begin'

Line 1508: JMF_SHIKYU_UTIL.debug_output

1504: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1505: AND hoi.organization_id = p_sold_from_org_id;
1506: EXCEPTION
1507: WHEN no_data_found THEN
1508: JMF_SHIKYU_UTIL.debug_output
1509: (
1510: p_output_to => 'FND_LOG.STRING'
1511: ,p_api_name => l_api_name
1512: ,p_message => 'no data find supplier id'

Line 1516: JMF_SHIKYU_UTIL.debug_output

1512: ,p_message => 'no data find supplier id'
1513: );
1514: RAISE;
1515: WHEN too_many_rows THEN
1516: JMF_SHIKYU_UTIL.debug_output
1517: (
1518: p_output_to => 'FND_LOG.STRING'
1519: ,p_api_name => l_api_name
1520: ,p_message => 'too many rows when find supplier id'

Line 1535: JMF_SHIKYU_UTIL.debug_output

1531: FROM po_vendors
1532: WHERE po_vendors.vendor_id = l_supplier_id;
1533: EXCEPTION
1534: WHEN no_data_found THEN
1535: JMF_SHIKYU_UTIL.debug_output
1536: (
1537: p_output_to => 'FND_LOG.STRING'
1538: ,p_api_name => l_api_name
1539: ,p_message => 'no data find supplier name'

Line 1543: JMF_SHIKYU_UTIL.debug_output

1539: ,p_message => 'no data find supplier name'
1540: );
1541: RAISE;
1542: WHEN too_many_rows THEN
1543: JMF_SHIKYU_UTIL.debug_output
1544: (
1545: p_output_to => 'FND_LOG.STRING'
1546: ,p_api_name => l_api_name
1547: ,p_message => 'too many rows when find supplier name'

Line 1553: JMF_SHIKYU_UTIL.debug_output

1549: RAISE;
1550:
1551: END;
1552:
1553: JMF_SHIKYU_UTIL.debug_output
1554: (
1555: p_output_to => 'FND_LOG.STRING'
1556: ,p_api_name => l_api_name
1557: ,p_message => 'END procedure. '

Line 1562: JMF_SHIKYU_UTIL.debug_output

1558: );
1559:
1560: EXCEPTION
1561: WHEN OTHERS THEN
1562: JMF_SHIKYU_UTIL.debug_output
1563: (
1564: p_output_to => 'FND_LOG.STRING'
1565: ,p_api_name => l_api_name
1566: ,p_message => 'Unknown error '||SQLCODE||SQLERRM

Line 1685: JMF_SHIKYU_UTIL.debug_output

1681: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1682: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1683:
1684: BEGIN
1685: JMF_SHIKYU_UTIL.debug_output
1686: (
1687: p_output_to => 'FND_LOG.STRING'
1688: ,p_api_name => l_api_name
1689: ,p_message => 'procedure begin'

Line 1691: /* JMF_SHIKYU_UTIL.debug_output

1687: p_output_to => 'FND_LOG.STRING'
1688: ,p_api_name => l_api_name
1689: ,p_message => 'procedure begin'
1690: );
1691: /* JMF_SHIKYU_UTIL.debug_output
1692: (
1693: p_output_to => 'FND_LOG.STRING'
1694: ,p_api_name => l_api_name
1695: ,p_message => 'p_line_id '||p_line_id

Line 1697: JMF_SHIKYU_UTIL.debug_output

1693: p_output_to => 'FND_LOG.STRING'
1694: ,p_api_name => l_api_name
1695: ,p_message => 'p_line_id '||p_line_id
1696: );*/
1697: JMF_SHIKYU_UTIL.debug_output
1698: (
1699: p_output_to => 'FND_LOG.STRING'
1700: ,p_api_name => l_api_name
1701: ,p_message => 'p_po_header_id '||p_po_header_id

Line 1703: JMF_SHIKYU_UTIL.debug_output

1699: p_output_to => 'FND_LOG.STRING'
1700: ,p_api_name => l_api_name
1701: ,p_message => 'p_po_header_id '||p_po_header_id
1702: );
1703: JMF_SHIKYU_UTIL.debug_output
1704: (
1705: p_output_to => 'FND_LOG.STRING'
1706: ,p_api_name => l_api_name
1707: ,p_message => 'p_po_line_id'||p_po_line_id

Line 1709: JMF_SHIKYU_UTIL.debug_output

1705: p_output_to => 'FND_LOG.STRING'
1706: ,p_api_name => l_api_name
1707: ,p_message => 'p_po_line_id'||p_po_line_id
1708: );
1709: JMF_SHIKYU_UTIL.debug_output
1710: (
1711: p_output_to => 'FND_LOG.STRING'
1712: ,p_api_name => l_api_name
1713: ,p_message => 'p_po_shipment_id'||p_po_shipment_id

Line 1715: JMF_SHIKYU_UTIL.debug_output

1711: p_output_to => 'FND_LOG.STRING'
1712: ,p_api_name => l_api_name
1713: ,p_message => 'p_po_shipment_id'||p_po_shipment_id
1714: );
1715: JMF_SHIKYU_UTIL.debug_output
1716: (
1717: p_output_to => 'FND_LOG.STRING'
1718: ,p_api_name => l_api_name
1719: ,p_message => 'p_ship_from_org_id'||p_ship_from_org_id

Line 1721: JMF_SHIKYU_UTIL.debug_output

1717: p_output_to => 'FND_LOG.STRING'
1718: ,p_api_name => l_api_name
1719: ,p_message => 'p_ship_from_org_id'||p_ship_from_org_id
1720: );
1721: JMF_SHIKYU_UTIL.debug_output
1722: (
1723: p_output_to => 'FND_LOG.STRING'
1724: ,p_api_name => l_api_name
1725: ,p_message => 'p_ship_to_org_id'||p_ship_to_org_id

Line 1727: JMF_SHIKYU_UTIL.debug_output

1723: p_output_to => 'FND_LOG.STRING'
1724: ,p_api_name => l_api_name
1725: ,p_message => 'p_ship_to_org_id'||p_ship_to_org_id
1726: );
1727: JMF_SHIKYU_UTIL.debug_output
1728: (
1729: p_output_to => 'FND_LOG.STRING'
1730: ,p_api_name => l_api_name
1731: ,p_message => 'p_receive_quantity'||p_receive_quantity

Line 1747: JMF_SHIKYU_UTIL.debug_output

1743: mtl_units_of_measure_vl uom
1744: WHERE uom.uom_code = p_primary_uom_code;
1745: EXCEPTION
1746: WHEN no_data_found THEN
1747: JMF_SHIKYU_UTIL.debug_output
1748: (
1749: p_output_to => 'FND_LOG.STRING'
1750: ,p_api_name => l_api_name
1751: ,p_message => 'no data found when select receiving_routing_id by line_location_id'

Line 1756: JMF_SHIKYU_UTIL.debug_output

1752: );
1753: RAISE;
1754: END;
1755:
1756: JMF_SHIKYU_UTIL.debug_output
1757: (
1758: p_output_to => 'FND_LOG.STRING'
1759: ,p_api_name => l_api_name
1760: ,p_message => 'l_unit_of_measure'||l_primary_uom

Line 1774: JMF_SHIKYU_UTIL.debug_output

1770: PO_LINE_LOCATIONS_ALL location
1771: WHERE location.line_location_id = p_po_shipment_id;
1772: EXCEPTION
1773: WHEN no_data_found THEN
1774: JMF_SHIKYU_UTIL.debug_output
1775: (
1776: p_output_to => 'FND_LOG.STRING'
1777: ,p_api_name => l_api_name
1778: ,p_message => 'no data found when select receiving_routing_id by line_location_id'

Line 1790: JMF_SHIKYU_UTIL.debug_output

1786: , x_supplier_site_id => l_supplier_site_id
1787: );
1788:
1789: -- begin debug log
1790: JMF_SHIKYU_UTIL.debug_output
1791: (
1792: p_output_to => 'FND_LOG.STRING'
1793: ,p_api_name => l_api_name
1794: ,p_message => 'begin process_rcv_header'

Line 1796: JMF_SHIKYU_UTIL.debug_output

1792: p_output_to => 'FND_LOG.STRING'
1793: ,p_api_name => l_api_name
1794: ,p_message => 'begin process_rcv_header'
1795: );
1796: JMF_SHIKYU_UTIL.debug_output
1797: (
1798: p_output_to => 'FND_LOG.STRING'
1799: ,p_api_name => l_api_name
1800: ,p_message => 'p_vendor_id '||l_supplier_id

Line 1802: JMF_SHIKYU_UTIL.debug_output

1798: p_output_to => 'FND_LOG.STRING'
1799: ,p_api_name => l_api_name
1800: ,p_message => 'p_vendor_id '||l_supplier_id
1801: );
1802: JMF_SHIKYU_UTIL.debug_output
1803: (
1804: p_output_to => 'FND_LOG.STRING'
1805: ,p_api_name => l_api_name
1806: ,p_message => 'p_vendor_site_id '||l_supplier_site_id

Line 1808: JMF_SHIKYU_UTIL.debug_output

1804: p_output_to => 'FND_LOG.STRING'
1805: ,p_api_name => l_api_name
1806: ,p_message => 'p_vendor_site_id '||l_supplier_site_id
1807: );
1808: JMF_SHIKYU_UTIL.debug_output
1809: (
1810: p_output_to => 'FND_LOG.STRING'
1811: ,p_api_name => l_api_name
1812: ,p_message => 'p_ship_to_org_id'||p_inventory_org_id

Line 1825: JMF_SHIKYU_UTIL.debug_output

1821: , x_group_id => l_group_id
1822: );
1823:
1824: -- begin debug log
1825: JMF_SHIKYU_UTIL.debug_output
1826: (
1827: p_output_to => 'FND_LOG.STRING'
1828: ,p_api_name => l_api_name
1829: ,p_message => 'l_rcv_header_id '||l_rcv_header_id

Line 1831: JMF_SHIKYU_UTIL.debug_output

1827: p_output_to => 'FND_LOG.STRING'
1828: ,p_api_name => l_api_name
1829: ,p_message => 'l_rcv_header_id '||l_rcv_header_id
1830: );
1831: JMF_SHIKYU_UTIL.debug_output
1832: (
1833: p_output_to => 'FND_LOG.STRING'
1834: ,p_api_name => l_api_name
1835: ,p_message => 'l_group_id'||l_group_id

Line 1837: JMF_SHIKYU_UTIL.debug_output

1833: p_output_to => 'FND_LOG.STRING'
1834: ,p_api_name => l_api_name
1835: ,p_message => 'l_group_id'||l_group_id
1836: );
1837: JMF_SHIKYU_UTIL.debug_output
1838: (
1839: p_output_to => 'FND_LOG.STRING'
1840: ,p_api_name => l_api_name
1841: ,p_message => 'end process_rcv_header'

Line 1846: JMF_SHIKYU_UTIL.debug_output

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

Line 1859: JMF_SHIKYU_UTIL.debug_output

1855: WHILE l_index IS NOT NULL
1856: LOOP
1857:
1858: -- begin debug log
1859: JMF_SHIKYU_UTIL.debug_output
1860: (
1861: p_output_to => 'FND_LOG.STRING'
1862: ,p_api_name => l_api_name
1863: ,p_message => 'Begin cursor po_distributions_c loop'

Line 1865: JMF_SHIKYU_UTIL.debug_output

1861: p_output_to => 'FND_LOG.STRING'
1862: ,p_api_name => l_api_name
1863: ,p_message => 'Begin cursor po_distributions_c loop'
1864: );
1865: JMF_SHIKYU_UTIL.debug_output
1866: (
1867: p_output_to => 'FND_LOG.STRING'
1868: ,p_api_name => l_api_name
1869: ,p_message => 'p_po_shipment_id'||p_po_shipment_id

Line 1871: JMF_SHIKYU_UTIL.debug_output

1867: p_output_to => 'FND_LOG.STRING'
1868: ,p_api_name => l_api_name
1869: ,p_message => 'p_po_shipment_id'||p_po_shipment_id
1870: );
1871: JMF_SHIKYU_UTIL.debug_output
1872: (
1873: p_output_to => 'FND_LOG.STRING'
1874: ,p_api_name => l_api_name
1875: ,p_message => 'p_lines_id(l_index)'||p_lines_id(l_index)

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

1896: -- Bug#5647346: convert l_quantity_ordered, l_quantity_delivered, l_allocated_quantity to primary UOM
1897: l_prm_uom_quantity_ordered := Jmf_Shikyu_Rpt_Util.get_item_primary_quantity
1898: ( p_org_id => p_inventory_org_id
1899: , p_item_id => l_item_id
1900: , p_current_uom_code => JMF_SHIKYU_UTIL.Get_Uom_Code(l_po_uom)
1901: , p_current_qty => l_quantity_ordered
1902: );
1903: l_prm_uom_quantity_delivered := Jmf_Shikyu_Rpt_Util.get_item_primary_quantity
1904: ( p_org_id => p_inventory_org_id

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

1902: );
1903: l_prm_uom_quantity_delivered := Jmf_Shikyu_Rpt_Util.get_item_primary_quantity
1904: ( p_org_id => p_inventory_org_id
1905: , p_item_id => l_item_id
1906: , p_current_uom_code => JMF_SHIKYU_UTIL.Get_Uom_Code(l_po_uom)
1907: , p_current_qty => l_quantity_delivered
1908: );
1909: l_prm_uom_allocated_quantity := Jmf_Shikyu_Rpt_Util.get_item_primary_quantity
1910: ( p_org_id => p_inventory_org_id

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

1908: );
1909: l_prm_uom_allocated_quantity := Jmf_Shikyu_Rpt_Util.get_item_primary_quantity
1910: ( p_org_id => p_inventory_org_id
1911: , p_item_id => l_item_id
1912: , p_current_uom_code => JMF_SHIKYU_UTIL.Get_Uom_Code(l_so_uom)
1913: , p_current_qty => l_allocated_quantity
1914: );
1915:
1916: -- begin insert data to interface,

Line 1943: JMF_SHIKYU_UTIL.debug_output

1939: -- find the default subinventory
1940: -- if default is not null
1941: -- then ok
1942: -- else send a message.
1943: JMF_SHIKYU_UTIL.debug_output
1944: (
1945: p_output_to => 'FND_LOG.STRING'
1946: ,p_api_name => l_api_name
1947: ,p_message => 'Dest_subinventory is null'

Line 1957: JMF_SHIKYU_UTIL.debug_output

1953: FROM wip_parameters wip_para
1954: WHERE wip_para.Organization_Id = p_inventory_org_id;
1955: EXCEPTION
1956: WHEN no_data_found THEN
1957: JMF_SHIKYU_UTIL.debug_output
1958: (
1959: p_output_to => 'FND_LOG.STRING'
1960: ,p_api_name => l_api_name
1961: ,p_message => 'no data found when found subinventory by org id'

Line 1966: JMF_SHIKYU_UTIL.debug_output

1962: );
1963:
1964: -- log a message that the default sub inventory should be setup
1965: fnd_message.set_name('JMF', 'JMF_SHK_WIP_SUBINV_MIS');
1966: JMF_SHIKYU_UTIL.debug_output
1967: (
1968: p_output_to => 'FND_LOG.STRING'
1969: ,p_api_name => l_api_name
1970: ,p_message => fnd_message.GET

Line 1975: JMF_SHIKYU_UTIL.debug_output

1971: );
1972:
1973: RAISE;
1974: WHEN too_many_rows THEN
1975: JMF_SHIKYU_UTIL.debug_output
1976: (
1977: p_output_to => 'FND_LOG.STRING'
1978: ,p_api_name => l_api_name
1979: ,p_message => 'too many rows when found sub inventory by org id'

Line 1987: JMF_SHIKYU_UTIL.debug_output

1983:
1984: END IF;
1985:
1986: -- begin debug log
1987: JMF_SHIKYU_UTIL.debug_output
1988: (
1989: p_output_to => 'FND_LOG.STRING'
1990: ,p_api_name => l_api_name
1991: ,p_message => 'l_dest_subinventory'||l_dest_subinventory

Line 2008: JMF_SHIKYU_UTIL.debug_output

2004: FROM wip_parameters wip_para
2005: WHERE wip_para.Organization_Id = p_inventory_org_id;
2006: EXCEPTION
2007: WHEN no_data_found THEN
2008: JMF_SHIKYU_UTIL.debug_output
2009: (
2010: p_output_to => 'FND_LOG.STRING'
2011: ,p_api_name => l_api_name
2012: ,p_message => 'no data found when found locator by org id'

Line 2017: JMF_SHIKYU_UTIL.debug_output

2013: );
2014:
2015: RAISE;
2016: WHEN too_many_rows THEN
2017: JMF_SHIKYU_UTIL.debug_output
2018: (
2019: p_output_to => 'FND_LOG.STRING'
2020: ,p_api_name => l_api_name
2021: ,p_message => 'too many rows when found default locator by org id'

Line 2027: JMF_SHIKYU_UTIL.debug_output

2023: RAISE;
2024: END;
2025:
2026: -- begin debug log
2027: JMF_SHIKYU_UTIL.debug_output
2028: (
2029: p_output_to => 'FND_LOG.STRING'
2030: ,p_api_name => l_api_name
2031: ,p_message => 'l_default_locator_id'||l_default_locator_id

Line 2044: JMF_SHIKYU_UTIL.debug_output

2040: WHERE msi.Organization_Id = p_inventory_org_id
2041: AND msi.SECONDARY_INVENTORY_NAME = l_dest_subinventory;
2042: EXCEPTION
2043: WHEN no_data_found THEN
2044: JMF_SHIKYU_UTIL.debug_output
2045: (
2046: p_output_to => 'FND_LOG.STRING'
2047: ,p_api_name => l_api_name
2048: ,p_message => 'no data found when found locator type by org id and locator id'

Line 2054: JMF_SHIKYU_UTIL.debug_output

2050: RAISE;
2051: END;
2052:
2053: -- begin debug log
2054: JMF_SHIKYU_UTIL.debug_output
2055: (
2056: p_output_to => 'FND_LOG.STRING'
2057: ,p_api_name => l_api_name
2058: ,p_message => 'l_locator_type'||l_locator_type

Line 2070: JMF_SHIKYU_UTIL.debug_output

2066: FROM OE_ORDER_LINES_ALL oola
2067: WHERE oola.line_id = p_lines_id(l_index);
2068: EXCEPTION
2069: WHEN no_data_found THEN
2070: JMF_SHIKYU_UTIL.debug_output
2071: (
2072: p_output_to => 'FND_LOG.STRING'
2073: ,p_api_name => l_api_name
2074: ,p_message => 'no data found when found project id and task id by org id and locator id'

Line 2080: JMF_SHIKYU_UTIL.debug_output

2076: RAISE;
2077: END;
2078:
2079: -- begin debug log
2080: JMF_SHIKYU_UTIL.debug_output
2081: (
2082: p_output_to => 'FND_LOG.STRING'
2083: ,p_api_name => l_api_name
2084: ,p_message => 'l_project_id'||l_project_id

Line 2086: JMF_SHIKYU_UTIL.debug_output

2082: p_output_to => 'FND_LOG.STRING'
2083: ,p_api_name => l_api_name
2084: ,p_message => 'l_project_id'||l_project_id
2085: );
2086: JMF_SHIKYU_UTIL.debug_output
2087: (
2088: p_output_to => 'FND_LOG.STRING'
2089: ,p_api_name => l_api_name
2090: ,p_message => 'l_task_id'||l_task_id

Line 2110: JMF_SHIKYU_UTIL.debug_output

2106: l_dest_locator_id := l_default_locator_id;
2107: END IF;
2108:
2109: -- begin debug log
2110: JMF_SHIKYU_UTIL.debug_output
2111: (
2112: p_output_to => 'FND_LOG.STRING'
2113: ,p_api_name => l_api_name
2114: ,p_message => 'l_dest_locator_id'||l_dest_locator_id

Line 2123: JMF_SHIKYU_UTIL.debug_output

2119:
2120: -- get all of the data
2121: ELSE /*l_quantity_ordered - l_quantity_delivered <= 0*/
2122: --begin log
2123: JMF_SHIKYU_UTIL.debug_output
2124: (
2125: p_output_to => 'FND_LOG.STRING'
2126: ,p_api_name => l_api_name
2127: ,p_message => 'the quantity auto receive finished '

Line 2133: JMF_SHIKYU_UTIL.debug_output

2129: --end log
2130: END IF ; /*end if l_quantity_ordered - l_quantity_delivered > 0 */
2131:
2132: -- begin debug log
2133: JMF_SHIKYU_UTIL.debug_output
2134: (
2135: p_output_to => 'FND_LOG.STRING'
2136: ,p_api_name => l_api_name
2137: ,p_message => 'begin process_rcv_trx'

Line 2139: JMF_SHIKYU_UTIL.debug_output

2135: p_output_to => 'FND_LOG.STRING'
2136: ,p_api_name => l_api_name
2137: ,p_message => 'begin process_rcv_trx'
2138: );
2139: JMF_SHIKYU_UTIL.debug_output
2140: (
2141: p_output_to => 'FND_LOG.STRING'
2142: ,p_api_name => l_api_name
2143: ,p_message => 'l_rcv_header_id '||l_rcv_header_id

Line 2145: JMF_SHIKYU_UTIL.debug_output

2141: p_output_to => 'FND_LOG.STRING'
2142: ,p_api_name => l_api_name
2143: ,p_message => 'l_rcv_header_id '||l_rcv_header_id
2144: );
2145: JMF_SHIKYU_UTIL.debug_output
2146: (
2147: p_output_to => 'FND_LOG.STRING'
2148: ,p_api_name => l_api_name
2149: ,p_message => 'l_insert_quantity'||l_insert_quantity

Line 2151: JMF_SHIKYU_UTIL.debug_output

2147: p_output_to => 'FND_LOG.STRING'
2148: ,p_api_name => l_api_name
2149: ,p_message => 'l_insert_quantity'||l_insert_quantity
2150: );
2151: JMF_SHIKYU_UTIL.debug_output
2152: (
2153: p_output_to => 'FND_LOG.STRING'
2154: ,p_api_name => l_api_name
2155: ,p_message => 'l_unit_of_measure'||l_so_uom

Line 2157: JMF_SHIKYU_UTIL.debug_output

2153: p_output_to => 'FND_LOG.STRING'
2154: ,p_api_name => l_api_name
2155: ,p_message => 'l_unit_of_measure'||l_so_uom
2156: );
2157: JMF_SHIKYU_UTIL.debug_output
2158: (
2159: p_output_to => 'FND_LOG.STRING'
2160: ,p_api_name => l_api_name
2161: ,p_message => 'p_po_header_id'||p_po_header_id

Line 2163: JMF_SHIKYU_UTIL.debug_output

2159: p_output_to => 'FND_LOG.STRING'
2160: ,p_api_name => l_api_name
2161: ,p_message => 'p_po_header_id'||p_po_header_id
2162: );
2163: JMF_SHIKYU_UTIL.debug_output
2164: (
2165: p_output_to => 'FND_LOG.STRING'
2166: ,p_api_name => l_api_name
2167: ,p_message => 'p_po_line_id'||p_po_line_id

Line 2169: JMF_SHIKYU_UTIL.debug_output

2165: p_output_to => 'FND_LOG.STRING'
2166: ,p_api_name => l_api_name
2167: ,p_message => 'p_po_line_id'||p_po_line_id
2168: );
2169: JMF_SHIKYU_UTIL.debug_output
2170: (
2171: p_output_to => 'FND_LOG.STRING'
2172: ,p_api_name => l_api_name
2173: ,p_message => 'l_dest_subinventory'||l_dest_subinventory

Line 2175: JMF_SHIKYU_UTIL.debug_output

2171: p_output_to => 'FND_LOG.STRING'
2172: ,p_api_name => l_api_name
2173: ,p_message => 'l_dest_subinventory'||l_dest_subinventory
2174: );
2175: JMF_SHIKYU_UTIL.debug_output
2176: (
2177: p_output_to => 'FND_LOG.STRING'
2178: ,p_api_name => l_api_name
2179: ,p_message => 'l_transaction_type'||l_transaction_type

Line 2181: JMF_SHIKYU_UTIL.debug_output

2177: p_output_to => 'FND_LOG.STRING'
2178: ,p_api_name => l_api_name
2179: ,p_message => 'l_transaction_type'||l_transaction_type
2180: );
2181: JMF_SHIKYU_UTIL.debug_output
2182: (
2183: p_output_to => 'FND_LOG.STRING'
2184: ,p_api_name => l_api_name
2185: ,p_message => 'l_dest_locator_id'||l_dest_locator_id

Line 2187: JMF_SHIKYU_UTIL.debug_output

2183: p_output_to => 'FND_LOG.STRING'
2184: ,p_api_name => l_api_name
2185: ,p_message => 'l_dest_locator_id'||l_dest_locator_id
2186: );
2187: JMF_SHIKYU_UTIL.debug_output
2188: (
2189: p_output_to => 'FND_LOG.STRING'
2190: ,p_api_name => l_api_name
2191: ,p_message => 'p_replenish_order_line_id '||p_lines_id(l_index)

Line 2247: JMF_SHIKYU_UTIL.debug_output

2243: , argument1 => 'BATCH'
2244: , argument2 => l_group_id
2245: );
2246:
2247: JMF_SHIKYU_UTIL.debug_output
2248: (
2249: p_output_to => 'FND_LOG.STRING'
2250: ,p_api_name => l_api_name
2251: ,p_message => 'The request id is : ' || l_return_number

Line 2254: JMF_SHIKYU_UTIL.debug_output

2250: ,p_api_name => l_api_name
2251: ,p_message => 'The request id is : ' || l_return_number
2252: );
2253:
2254: JMF_SHIKYU_UTIL.debug_output
2255: (
2256: p_output_to => 'FND_LOG.STRING'
2257: ,p_api_name => l_api_name
2258: ,p_message => 'END procedure. '

Line 2263: JMF_SHIKYU_UTIL.debug_output

2259: );
2260:
2261: EXCEPTION
2262: WHEN OTHERS THEN
2263: JMF_SHIKYU_UTIL.debug_output
2264: (
2265: p_output_to => 'FND_LOG.STRING'
2266: ,p_api_name => l_api_name
2267: ,p_message => 'Unknown error'||SQLCODE||SQLERRM