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.FTE_PO_INTEGRATION_GRP dependencies on WSH_DEBUG_SV

Line 457: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

453: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
454: --
455: IF l_debug_on IS NULL
456: THEN
457: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
458: END IF;
459: --
460: -- Debug Statements
461: --

Line 464: l_debugfile := l_debugfile||'/'||WSH_DEBUG_SV.g_file;

460: -- Debug Statements
461: --
462: IF l_debug_on THEN
463: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_debugfile);
464: l_debugfile := l_debugfile||'/'||WSH_DEBUG_SV.g_file;
465:
466: WSH_DEBUG_SV.push(l_module_name);
467: WSH_DEBUG_SV.log(l_module_name,'Begin of the process ',l_debugfile);
468: WSH_DEBUG_SV.log(l_module_name,'Shipment Header id ',p_shipment_header_id);

Line 466: WSH_DEBUG_SV.push(l_module_name);

462: IF l_debug_on THEN
463: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_debugfile);
464: l_debugfile := l_debugfile||'/'||WSH_DEBUG_SV.g_file;
465:
466: WSH_DEBUG_SV.push(l_module_name);
467: WSH_DEBUG_SV.log(l_module_name,'Begin of the process ',l_debugfile);
468: WSH_DEBUG_SV.log(l_module_name,'Shipment Header id ',p_shipment_header_id);
469: END IF;
470: --

Line 467: WSH_DEBUG_SV.log(l_module_name,'Begin of the process ',l_debugfile);

463: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_debugfile);
464: l_debugfile := l_debugfile||'/'||WSH_DEBUG_SV.g_file;
465:
466: WSH_DEBUG_SV.push(l_module_name);
467: WSH_DEBUG_SV.log(l_module_name,'Begin of the process ',l_debugfile);
468: WSH_DEBUG_SV.log(l_module_name,'Shipment Header id ',p_shipment_header_id);
469: END IF;
470: --
471: -- initialize variables and tables

Line 468: WSH_DEBUG_SV.log(l_module_name,'Shipment Header id ',p_shipment_header_id);

464: l_debugfile := l_debugfile||'/'||WSH_DEBUG_SV.g_file;
465:
466: WSH_DEBUG_SV.push(l_module_name);
467: WSH_DEBUG_SV.log(l_module_name,'Begin of the process ',l_debugfile);
468: WSH_DEBUG_SV.log(l_module_name,'Shipment Header id ',p_shipment_header_id);
469: END IF;
470: --
471: -- initialize variables and tables
472: l_receipt_lines_tab.delete;

Line 480: WSH_DEBUG_SV.log(l_module_name,'Total deliveries found for the given header id : ',l_del_count);

476: OPEN c_get_deliveries(p_shipment_header_id);
477: FETCH c_get_deliveries BULK COLLECT
478: INTO l_del_table,l_rate_available_table,l_matching_table;
479: l_del_count := l_del_table.count ;
480: WSH_DEBUG_SV.log(l_module_name,'Total deliveries found for the given header id : ',l_del_count);
481: l_delivery_exist_flag := 'N';
482: l_no_rate_del_count := 0;
483: --
484: IF l_del_count > 0 then

Line 496: WSH_DEBUG_SV.log(l_module_name,'Total deliveries, which have no rates: ',l_no_rate_del_count);

492: OPEN c_get_no_rates_del;
493: FETCH c_get_no_rates_del BULK COLLECT
494: INTO l_del_table;
495: l_no_rate_del_count := l_del_table.count ;
496: WSH_DEBUG_SV.log(l_module_name,'Total deliveries, which have no rates: ',l_no_rate_del_count);
497: --
498: --Updating those deliveries with RATE_AVAILABLE_FLAG ='N'
499: IF l_no_rate_del_count > 0 then
500: FORALL j IN 1..l_no_rate_del_count

Line 526: WSH_DEBUG_SV.log(l_module_name,'cursor c_get_container_rates - All Rates except LTL - number '||

522: close c_get_container_rates;
523: --dbms_output.put_line('after close cursor c_get_container_rates for CNT Rates'||l_CNT_parent_cont_id_table.COUNT);
524: --
525: IF l_debug_on THEN
526: WSH_DEBUG_SV.log(l_module_name,'cursor c_get_container_rates - All Rates except LTL - number '||
527: 'of records found: ', l_CNT_parent_cont_id_table.COUNT);
528: END IF;
529: --
530: --

Line 562: WSH_DEBUG_SV.log(l_module_name,'cursor c_get_container_contents - number '||

558: l_CC_uom_code_table;
559: close c_get_container_contents;
560: --
561: IF l_debug_on THEN
562: WSH_DEBUG_SV.log(l_module_name,'cursor c_get_container_contents - number '||
563: 'of records found: ', l_CC_delivery_detail_table.COUNT);
564: END IF;
565: -- Initializing the net wt for each container
566: l_total_net_qty := 0;

Line 595: WSH_DEBUG_SV.log(l_module_name,'Total net Qty for the contents of the Container id '||l_CNT_parent_cont_id_table(i) ||

591: j := l_CC_delivery_detail_table.next(j);
592: --}
593: END LOOP;-- End of WHILE j is not NULL
594: IF l_total_net_qty <= 0 then
595: WSH_DEBUG_SV.log(l_module_name,'Total net Qty for the contents of the Container id '||l_CNT_parent_cont_id_table(i) ||
596: ' s zero '||l_total_net_qty);
597: END IF;
598: --VALIDATION CHECK
599: IF l_CNT_total_cost_table(i) > 0 and l_total_net_qty <= 0 then

Line 602: WSH_DEBUG_SV.log(l_module_name,'Total Cost at the container level is ',l_CNT_total_cost_table(i));

598: --VALIDATION CHECK
599: IF l_CNT_total_cost_table(i) > 0 and l_total_net_qty <= 0 then
600: --{
601: IF l_debug_on THEN
602: WSH_DEBUG_SV.log(l_module_name,'Total Cost at the container level is ',l_CNT_total_cost_table(i));
603: WSH_DEBUG_SV.log(l_module_name,'Total net Qty for the contents of the Container id ',l_CNT_parent_cont_id_table(i) ||
604: ' s zero '||l_total_net_qty);
605: END IF;
606: --dbms_output.put_line('Total Qty of the container contents is zero ');

Line 603: WSH_DEBUG_SV.log(l_module_name,'Total net Qty for the contents of the Container id ',l_CNT_parent_cont_id_table(i) ||

599: IF l_CNT_total_cost_table(i) > 0 and l_total_net_qty <= 0 then
600: --{
601: IF l_debug_on THEN
602: WSH_DEBUG_SV.log(l_module_name,'Total Cost at the container level is ',l_CNT_total_cost_table(i));
603: WSH_DEBUG_SV.log(l_module_name,'Total net Qty for the contents of the Container id ',l_CNT_parent_cont_id_table(i) ||
604: ' s zero '||l_total_net_qty);
605: END IF;
606: --dbms_output.put_line('Total Qty of the container contents is zero ');
607: FND_MESSAGE.SET_NAME('FTE','FTE_EC_MISSING_DETAIL_NET_QTY');

Line 633: WSH_DEBUG_SV.log(l_module_name,'Total cost for the rcv shipment line '||l_CC_rcv_ship_line_id_table(j)||' Cost-'

629: IF l_total_net_qty > 0 then
630: l_DET_total_cost_table(k) := (l_CC_net_wt_table(j)/l_total_net_qty) * l_CNT_total_cost_table(i);
631: --
632: IF l_debug_on THEN
633: WSH_DEBUG_SV.log(l_module_name,'Total cost for the rcv shipment line '||l_CC_rcv_ship_line_id_table(j)||' Cost-'
634: ||l_DET_total_cost_table(k) || ' '||l_CNT_wfc_corrency_code_table(i));
635: END IF;
636: IF l_CC_po_corrency_code_table(j) <> l_CNT_wfc_corrency_code_table(i) then
637: --{

Line 645: WSH_DEBUG_SV.log(l_module_name,'Total cost for the delivery detail after conversion '

641: x_conversion_date => sysdate,
642: x_amount => l_DET_total_cost_table(k));
643: IF l_debug_on THEN
644: --{
645: WSH_DEBUG_SV.log(l_module_name,'Total cost for the delivery detail after conversion '
646: ||l_DET_total_cost_table(k)||' '||l_CC_po_corrency_code_table(j));
647: --}
648: END IF;
649: --}

Line 695: WSH_DEBUG_SV.log(l_module_name,'cursor c_get_receipts_no_rates - number '||

691: l_NR_rcv_ship_line_id_table;
692: close c_get_receipts_no_rates;
693: l_NR_count := l_NR_rcv_ship_line_id_table.COUNT;
694: IF l_debug_on THEN
695: WSH_DEBUG_SV.log(l_module_name,'cursor c_get_receipts_no_rates - number '||
696: 'of records found: ', l_NR_count);
697: END IF;
698: END IF;
699: --

Line 719: WSH_DEBUG_SV.logmsg(l_module_name,'Storing the following info w/ zero cost ');

715: WHILE j is not null
716: LOOP
717: --{
718: IF l_debug_on THEN
719: WSH_DEBUG_SV.logmsg(l_module_name,'Storing the following info w/ zero cost ');
720: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id : ',p_shipment_header_id);
721: WSH_DEBUG_SV.log(l_module_name,'rcv shipment line id : ',l_NR_rcv_ship_line_id_table(j));
722: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_id_table(j) : ',l_NR_po_line_id_table(j));
723: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_loc_id_table(j) : ',l_NR_po_line_loc_id_table(j));

Line 720: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id : ',p_shipment_header_id);

716: LOOP
717: --{
718: IF l_debug_on THEN
719: WSH_DEBUG_SV.logmsg(l_module_name,'Storing the following info w/ zero cost ');
720: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id : ',p_shipment_header_id);
721: WSH_DEBUG_SV.log(l_module_name,'rcv shipment line id : ',l_NR_rcv_ship_line_id_table(j));
722: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_id_table(j) : ',l_NR_po_line_id_table(j));
723: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_loc_id_table(j) : ',l_NR_po_line_loc_id_table(j));
724: WSH_DEBUG_SV.log(l_module_name,'VENDOR_ID ',l_NR_vendor_id_table(j));

Line 721: WSH_DEBUG_SV.log(l_module_name,'rcv shipment line id : ',l_NR_rcv_ship_line_id_table(j));

717: --{
718: IF l_debug_on THEN
719: WSH_DEBUG_SV.logmsg(l_module_name,'Storing the following info w/ zero cost ');
720: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id : ',p_shipment_header_id);
721: WSH_DEBUG_SV.log(l_module_name,'rcv shipment line id : ',l_NR_rcv_ship_line_id_table(j));
722: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_id_table(j) : ',l_NR_po_line_id_table(j));
723: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_loc_id_table(j) : ',l_NR_po_line_loc_id_table(j));
724: WSH_DEBUG_SV.log(l_module_name,'VENDOR_ID ',l_NR_vendor_id_table(j));
725: WSH_DEBUG_SV.log(l_module_name,'VENDOR_SITE_ID ',l_NR_vendor_site_id_table(j));

Line 722: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_id_table(j) : ',l_NR_po_line_id_table(j));

718: IF l_debug_on THEN
719: WSH_DEBUG_SV.logmsg(l_module_name,'Storing the following info w/ zero cost ');
720: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id : ',p_shipment_header_id);
721: WSH_DEBUG_SV.log(l_module_name,'rcv shipment line id : ',l_NR_rcv_ship_line_id_table(j));
722: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_id_table(j) : ',l_NR_po_line_id_table(j));
723: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_loc_id_table(j) : ',l_NR_po_line_loc_id_table(j));
724: WSH_DEBUG_SV.log(l_module_name,'VENDOR_ID ',l_NR_vendor_id_table(j));
725: WSH_DEBUG_SV.log(l_module_name,'VENDOR_SITE_ID ',l_NR_vendor_site_id_table(j));
726: WSH_DEBUG_SV.log(l_module_name,'status','W');

Line 723: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_loc_id_table(j) : ',l_NR_po_line_loc_id_table(j));

719: WSH_DEBUG_SV.logmsg(l_module_name,'Storing the following info w/ zero cost ');
720: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id : ',p_shipment_header_id);
721: WSH_DEBUG_SV.log(l_module_name,'rcv shipment line id : ',l_NR_rcv_ship_line_id_table(j));
722: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_id_table(j) : ',l_NR_po_line_id_table(j));
723: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_loc_id_table(j) : ',l_NR_po_line_loc_id_table(j));
724: WSH_DEBUG_SV.log(l_module_name,'VENDOR_ID ',l_NR_vendor_id_table(j));
725: WSH_DEBUG_SV.log(l_module_name,'VENDOR_SITE_ID ',l_NR_vendor_site_id_table(j));
726: WSH_DEBUG_SV.log(l_module_name,'status','W');
727: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');

Line 724: WSH_DEBUG_SV.log(l_module_name,'VENDOR_ID ',l_NR_vendor_id_table(j));

720: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id : ',p_shipment_header_id);
721: WSH_DEBUG_SV.log(l_module_name,'rcv shipment line id : ',l_NR_rcv_ship_line_id_table(j));
722: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_id_table(j) : ',l_NR_po_line_id_table(j));
723: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_loc_id_table(j) : ',l_NR_po_line_loc_id_table(j));
724: WSH_DEBUG_SV.log(l_module_name,'VENDOR_ID ',l_NR_vendor_id_table(j));
725: WSH_DEBUG_SV.log(l_module_name,'VENDOR_SITE_ID ',l_NR_vendor_site_id_table(j));
726: WSH_DEBUG_SV.log(l_module_name,'status','W');
727: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
728: END IF;

Line 725: WSH_DEBUG_SV.log(l_module_name,'VENDOR_SITE_ID ',l_NR_vendor_site_id_table(j));

721: WSH_DEBUG_SV.log(l_module_name,'rcv shipment line id : ',l_NR_rcv_ship_line_id_table(j));
722: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_id_table(j) : ',l_NR_po_line_id_table(j));
723: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_loc_id_table(j) : ',l_NR_po_line_loc_id_table(j));
724: WSH_DEBUG_SV.log(l_module_name,'VENDOR_ID ',l_NR_vendor_id_table(j));
725: WSH_DEBUG_SV.log(l_module_name,'VENDOR_SITE_ID ',l_NR_vendor_site_id_table(j));
726: WSH_DEBUG_SV.log(l_module_name,'status','W');
727: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
728: END IF;
729: --PL/SQL table is building with the index of RCV Shipment Line Id

Line 726: WSH_DEBUG_SV.log(l_module_name,'status','W');

722: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_id_table(j) : ',l_NR_po_line_id_table(j));
723: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_loc_id_table(j) : ',l_NR_po_line_loc_id_table(j));
724: WSH_DEBUG_SV.log(l_module_name,'VENDOR_ID ',l_NR_vendor_id_table(j));
725: WSH_DEBUG_SV.log(l_module_name,'VENDOR_SITE_ID ',l_NR_vendor_site_id_table(j));
726: WSH_DEBUG_SV.log(l_module_name,'status','W');
727: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
728: END IF;
729: --PL/SQL table is building with the index of RCV Shipment Line Id
730: i := l_NR_rcv_ship_line_id_table(j);

Line 727: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');

723: WSH_DEBUG_SV.log(l_module_name,'l_NR_po_line_loc_id_table(j) : ',l_NR_po_line_loc_id_table(j));
724: WSH_DEBUG_SV.log(l_module_name,'VENDOR_ID ',l_NR_vendor_id_table(j));
725: WSH_DEBUG_SV.log(l_module_name,'VENDOR_SITE_ID ',l_NR_vendor_site_id_table(j));
726: WSH_DEBUG_SV.log(l_module_name,'status','W');
727: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
728: END IF;
729: --PL/SQL table is building with the index of RCV Shipment Line Id
730: i := l_NR_rcv_ship_line_id_table(j);
731: l_receipt_lines_tab(i).RCV_SHIPMENT_LINE_ID := l_NR_rcv_ship_line_id_table(j);

Line 775: WSH_DEBUG_SV.log(l_module_name,'cursor c_get_receipts_detail_rates - Rates - number '||

771: close c_get_receipts_detail_rates;
772: --dbms_output.put_line('after close cursor c_get_receipts_detail_rates for Rates '||l_rcv_ship_line_id_table.COUNT);
773: --
774: IF l_debug_on THEN
775: WSH_DEBUG_SV.log(l_module_name,'cursor c_get_receipts_detail_rates - Rates - number '||
776: 'of records found: ', l_rcv_ship_line_id_table.COUNT);
777: END IF;
778: -- Validating that if there are rates exist for all modes or container
779: -- if l_vendor_id_table.count = 0 means there no rates availble for non-packed items except LTL

Line 814: WSH_DEBUG_SV.log(l_module_name,'LOOP Counter 1. All modes, 2. Container Detail ',l_loop_counter );

810: l_total_cost_table := l_DET_total_cost_table;
811: --dbms_output.put_line('No of packed items -Rates lines '|| l_rcv_ship_line_id_table.count );
812: END IF;
813: IF l_debug_on THEN
814: WSH_DEBUG_SV.log(l_module_name,'LOOP Counter 1. All modes, 2. Container Detail ',l_loop_counter );
815: WSH_DEBUG_SV.log(l_module_name,'No of records to process : ',l_rcv_ship_line_id_table.COUNT );
816: END IF;
817: j := l_rcv_ship_line_id_table.FIRST;
818: WHILE j is NOT NULL

Line 815: WSH_DEBUG_SV.log(l_module_name,'No of records to process : ',l_rcv_ship_line_id_table.COUNT );

811: --dbms_output.put_line('No of packed items -Rates lines '|| l_rcv_ship_line_id_table.count );
812: END IF;
813: IF l_debug_on THEN
814: WSH_DEBUG_SV.log(l_module_name,'LOOP Counter 1. All modes, 2. Container Detail ',l_loop_counter );
815: WSH_DEBUG_SV.log(l_module_name,'No of records to process : ',l_rcv_ship_line_id_table.COUNT );
816: END IF;
817: j := l_rcv_ship_line_id_table.FIRST;
818: WHILE j is NOT NULL
819: LOOP

Line 827: WSH_DEBUG_SV.log(l_module_name,'Process for RCV Shipment Line : ',l_rcv_ship_line_id_table(j) );

823: --i := l_rcv_ship_line_id_table(j);
824: --Converting the Curency if the pos currency is different from rated curency
825: -- and if the cost > 0
826: IF l_debug_on THEN
827: WSH_DEBUG_SV.log(l_module_name,'Process for RCV Shipment Line : ',l_rcv_ship_line_id_table(j) );
828: WSH_DEBUG_SV.log(l_module_name,'Compare Currencies PO currency : ',l_po_corrency_code_table(j) );
829: WSH_DEBUG_SV.log(l_module_name,'Compare Currencies Rate currency : ',l_wfc_corrency_code_table(j));
830: WSH_DEBUG_SV.log(l_module_name,'Total Cost for conversion : ',l_total_cost_table(j));
831: END IF;

Line 828: WSH_DEBUG_SV.log(l_module_name,'Compare Currencies PO currency : ',l_po_corrency_code_table(j) );

824: --Converting the Curency if the pos currency is different from rated curency
825: -- and if the cost > 0
826: IF l_debug_on THEN
827: WSH_DEBUG_SV.log(l_module_name,'Process for RCV Shipment Line : ',l_rcv_ship_line_id_table(j) );
828: WSH_DEBUG_SV.log(l_module_name,'Compare Currencies PO currency : ',l_po_corrency_code_table(j) );
829: WSH_DEBUG_SV.log(l_module_name,'Compare Currencies Rate currency : ',l_wfc_corrency_code_table(j));
830: WSH_DEBUG_SV.log(l_module_name,'Total Cost for conversion : ',l_total_cost_table(j));
831: END IF;
832: --dbms_output.put_line('Compare currency code '||l_po_corrency_code_table(j)||' and '||l_wfc_corrency_code_table(j));

Line 829: WSH_DEBUG_SV.log(l_module_name,'Compare Currencies Rate currency : ',l_wfc_corrency_code_table(j));

825: -- and if the cost > 0
826: IF l_debug_on THEN
827: WSH_DEBUG_SV.log(l_module_name,'Process for RCV Shipment Line : ',l_rcv_ship_line_id_table(j) );
828: WSH_DEBUG_SV.log(l_module_name,'Compare Currencies PO currency : ',l_po_corrency_code_table(j) );
829: WSH_DEBUG_SV.log(l_module_name,'Compare Currencies Rate currency : ',l_wfc_corrency_code_table(j));
830: WSH_DEBUG_SV.log(l_module_name,'Total Cost for conversion : ',l_total_cost_table(j));
831: END IF;
832: --dbms_output.put_line('Compare currency code '||l_po_corrency_code_table(j)||' and '||l_wfc_corrency_code_table(j));
833: IF (l_po_corrency_code_table(j) <> l_wfc_corrency_code_table(j)) AND

Line 830: WSH_DEBUG_SV.log(l_module_name,'Total Cost for conversion : ',l_total_cost_table(j));

826: IF l_debug_on THEN
827: WSH_DEBUG_SV.log(l_module_name,'Process for RCV Shipment Line : ',l_rcv_ship_line_id_table(j) );
828: WSH_DEBUG_SV.log(l_module_name,'Compare Currencies PO currency : ',l_po_corrency_code_table(j) );
829: WSH_DEBUG_SV.log(l_module_name,'Compare Currencies Rate currency : ',l_wfc_corrency_code_table(j));
830: WSH_DEBUG_SV.log(l_module_name,'Total Cost for conversion : ',l_total_cost_table(j));
831: END IF;
832: --dbms_output.put_line('Compare currency code '||l_po_corrency_code_table(j)||' and '||l_wfc_corrency_code_table(j));
833: IF (l_po_corrency_code_table(j) <> l_wfc_corrency_code_table(j)) AND
834: nvl(l_total_cost_table(j),0) > 0 then

Line 856: WSH_DEBUG_SV.log(l_module_name,'Calling get_rcv_shipment_lines API since RCV Shipment Line id is NULL : ',l_rcv_ship_line_id_table(j) );

852: -- Need to call get_rcv_shipment_lines and pro-rated cost for each rcv shipment lines
853: if l_rcv_ship_line_id_table(j) is null then
854: --{
855: IF l_debug_on THEN
856: WSH_DEBUG_SV.log(l_module_name,'Calling get_rcv_shipment_lines API since RCV Shipment Line id is NULL : ',l_rcv_ship_line_id_table(j) );
857: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_ID : ',l_po_line_id_table(j) );
858: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_LOCATION_ID : ',l_po_line_loc_id_table(j) );
859: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_TOTAL_COST : ',l_total_cost_table(j) );
860: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY : ',l_ship_qty_table(j) );

Line 857: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_ID : ',l_po_line_id_table(j) );

853: if l_rcv_ship_line_id_table(j) is null then
854: --{
855: IF l_debug_on THEN
856: WSH_DEBUG_SV.log(l_module_name,'Calling get_rcv_shipment_lines API since RCV Shipment Line id is NULL : ',l_rcv_ship_line_id_table(j) );
857: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_ID : ',l_po_line_id_table(j) );
858: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_LOCATION_ID : ',l_po_line_loc_id_table(j) );
859: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_TOTAL_COST : ',l_total_cost_table(j) );
860: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY : ',l_ship_qty_table(j) );
861: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY_UOM : ',l_ship_qty_uom_table(j) );

Line 858: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_LOCATION_ID : ',l_po_line_loc_id_table(j) );

854: --{
855: IF l_debug_on THEN
856: WSH_DEBUG_SV.log(l_module_name,'Calling get_rcv_shipment_lines API since RCV Shipment Line id is NULL : ',l_rcv_ship_line_id_table(j) );
857: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_ID : ',l_po_line_id_table(j) );
858: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_LOCATION_ID : ',l_po_line_loc_id_table(j) );
859: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_TOTAL_COST : ',l_total_cost_table(j) );
860: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY : ',l_ship_qty_table(j) );
861: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY_UOM : ',l_ship_qty_uom_table(j) );
862: END IF;

Line 859: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_TOTAL_COST : ',l_total_cost_table(j) );

855: IF l_debug_on THEN
856: WSH_DEBUG_SV.log(l_module_name,'Calling get_rcv_shipment_lines API since RCV Shipment Line id is NULL : ',l_rcv_ship_line_id_table(j) );
857: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_ID : ',l_po_line_id_table(j) );
858: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_LOCATION_ID : ',l_po_line_loc_id_table(j) );
859: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_TOTAL_COST : ',l_total_cost_table(j) );
860: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY : ',l_ship_qty_table(j) );
861: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY_UOM : ',l_ship_qty_uom_table(j) );
862: END IF;
863: --dbms_output.put_line('RCV shipment line id is null, calling get_rcv_shipment_lines API to get the receipt lines');

Line 860: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY : ',l_ship_qty_table(j) );

856: WSH_DEBUG_SV.log(l_module_name,'Calling get_rcv_shipment_lines API since RCV Shipment Line id is NULL : ',l_rcv_ship_line_id_table(j) );
857: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_ID : ',l_po_line_id_table(j) );
858: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_LOCATION_ID : ',l_po_line_loc_id_table(j) );
859: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_TOTAL_COST : ',l_total_cost_table(j) );
860: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY : ',l_ship_qty_table(j) );
861: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY_UOM : ',l_ship_qty_uom_table(j) );
862: END IF;
863: --dbms_output.put_line('RCV shipment line id is null, calling get_rcv_shipment_lines API to get the receipt lines');
864: -- get all rcv shipment lines for the given po line id and po line location id

Line 861: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY_UOM : ',l_ship_qty_uom_table(j) );

857: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_ID : ',l_po_line_id_table(j) );
858: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_PO_LINE_LOCATION_ID : ',l_po_line_loc_id_table(j) );
859: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_TOTAL_COST : ',l_total_cost_table(j) );
860: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY : ',l_ship_qty_table(j) );
861: WSH_DEBUG_SV.log(l_module_name,'Calling Parameters - P_SHIP_QTY_UOM : ',l_ship_qty_uom_table(j) );
862: END IF;
863: --dbms_output.put_line('RCV shipment line id is null, calling get_rcv_shipment_lines API to get the receipt lines');
864: -- get all rcv shipment lines for the given po line id and po line location id
865: get_rcv_shipment_lines (x_return_status => x_return_status,

Line 879: WSH_DEBUG_SV.log(l_module_name,'Error after Calling get_rcv_shipment_lines API Status : ',x_return_status );

875: --dbms_output.put_line('error while calling get_rcv_shipment_lines API');
876: FND_MESSAGE.SET_NAME('FTE','FTE_EC_ERROR_SHP_LN_API');
877: FND_MESSAGE.SET_TOKEN('LOG_FILE',l_debugfile);
878: IF l_debug_on THEN
879: WSH_DEBUG_SV.log(l_module_name,'Error after Calling get_rcv_shipment_lines API Status : ',x_return_status );
880: END IF;
881: raise e_validation_error;
882: end if;
883: --

Line 888: WSH_DEBUG_SV.log(l_module_name,'store the one is matched into RCV_SHIP_LINES_TABLE ',l_rcv_ship_line_id_table(j));

884: --}
885: else
886: --{
887: IF l_debug_on THEN
888: WSH_DEBUG_SV.log(l_module_name,'store the one is matched into RCV_SHIP_LINES_TABLE ',l_rcv_ship_line_id_table(j));
889: END IF;
890: --dbms_output.put_line('RCV shipment line is not null ');
891: -- These are the matching receipts, store the one is matched into RCV_SHIP_LINES_TABLE, RCV_SHIP_COST_TABLE
892: l_rcv_ship_lines_table(1) := l_rcv_ship_line_id_table(j);

Line 908: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id -Status ',l_receipt_lines_tab(i).RETURN_STATUS);

904: i := l_rcv_ship_lines_table(k);
905: --dbms_output.put_line(' Rcv Shipment Line id '||i);
906: IF l_receipt_lines_tab.EXISTS(i) then
907: IF l_debug_on THEN
908: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id -Status ',l_receipt_lines_tab(i).RETURN_STATUS);
909: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id does exist and Existing cost from other deliveries ',l_receipt_lines_tab(i).TOTAL_COST);
910: WSH_DEBUG_SV.log(l_module_name,'New Cost from this delivery for the same Rcv Shipment Line id ',l_rcv_ship_cost_table(k));
911: END IF;
912: IF l_receipt_lines_tab(i).RETURN_STATUS ='S' THEN

Line 909: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id does exist and Existing cost from other deliveries ',l_receipt_lines_tab(i).TOTAL_COST);

905: --dbms_output.put_line(' Rcv Shipment Line id '||i);
906: IF l_receipt_lines_tab.EXISTS(i) then
907: IF l_debug_on THEN
908: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id -Status ',l_receipt_lines_tab(i).RETURN_STATUS);
909: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id does exist and Existing cost from other deliveries ',l_receipt_lines_tab(i).TOTAL_COST);
910: WSH_DEBUG_SV.log(l_module_name,'New Cost from this delivery for the same Rcv Shipment Line id ',l_rcv_ship_cost_table(k));
911: END IF;
912: IF l_receipt_lines_tab(i).RETURN_STATUS ='S' THEN
913: l_receipt_lines_tab(i).TOTAL_COST := nvl(l_receipt_lines_tab(i).TOTAL_COST,0) + nvl(l_rcv_ship_cost_table(k),0);

Line 910: WSH_DEBUG_SV.log(l_module_name,'New Cost from this delivery for the same Rcv Shipment Line id ',l_rcv_ship_cost_table(k));

906: IF l_receipt_lines_tab.EXISTS(i) then
907: IF l_debug_on THEN
908: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id -Status ',l_receipt_lines_tab(i).RETURN_STATUS);
909: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id does exist and Existing cost from other deliveries ',l_receipt_lines_tab(i).TOTAL_COST);
910: WSH_DEBUG_SV.log(l_module_name,'New Cost from this delivery for the same Rcv Shipment Line id ',l_rcv_ship_cost_table(k));
911: END IF;
912: IF l_receipt_lines_tab(i).RETURN_STATUS ='S' THEN
913: l_receipt_lines_tab(i).TOTAL_COST := nvl(l_receipt_lines_tab(i).TOTAL_COST,0) + nvl(l_rcv_ship_cost_table(k),0);
914: IF l_debug_on THEN

Line 915: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id does exist and added the cost',l_rcv_ship_cost_table(k));

911: END IF;
912: IF l_receipt_lines_tab(i).RETURN_STATUS ='S' THEN
913: l_receipt_lines_tab(i).TOTAL_COST := nvl(l_receipt_lines_tab(i).TOTAL_COST,0) + nvl(l_rcv_ship_cost_table(k),0);
914: IF l_debug_on THEN
915: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id does exist and added the cost',l_rcv_ship_cost_table(k));
916: END IF;
917: ELSE
918: IF l_debug_on THEN
919: WSH_DEBUG_SV.log(l_module_name,'One of the Delivery does not have the valid rate against the same Rcv Shipment Line id, '||

Line 919: WSH_DEBUG_SV.log(l_module_name,'One of the Delivery does not have the valid rate against the same Rcv Shipment Line id, '||

915: WSH_DEBUG_SV.log(l_module_name,'Rcv Shipment Line id does exist and added the cost',l_rcv_ship_cost_table(k));
916: END IF;
917: ELSE
918: IF l_debug_on THEN
919: WSH_DEBUG_SV.log(l_module_name,'One of the Delivery does not have the valid rate against the same Rcv Shipment Line id, '||
920: ' so the rate against this receipt line is incorrect and set to zero ',l_receipt_lines_tab(i).TOTAL_COST);
921: END IF;
922: END IF;
923: ELSE

Line 925: WSH_DEBUG_SV.log(l_module_name,'Storing output table for id ',i);

921: END IF;
922: END IF;
923: ELSE
924: IF l_debug_on THEN
925: WSH_DEBUG_SV.log(l_module_name,'Storing output table for id ',i);
926: WSH_DEBUG_SV.log(l_module_name,'Vendor Id ',l_vendor_id_table(j));
927: WSH_DEBUG_SV.log(l_module_name,'vendor site id ',l_vendor_site_id_table(j));
928: WSH_DEBUG_SV.log(l_module_name,'rcv id ',l_RCV_SHIP_LINES_TABLE(k));
929: WSH_DEBUG_SV.log(l_module_name,'cost ',l_RCV_SHIP_COST_TABLE(k));

Line 926: WSH_DEBUG_SV.log(l_module_name,'Vendor Id ',l_vendor_id_table(j));

922: END IF;
923: ELSE
924: IF l_debug_on THEN
925: WSH_DEBUG_SV.log(l_module_name,'Storing output table for id ',i);
926: WSH_DEBUG_SV.log(l_module_name,'Vendor Id ',l_vendor_id_table(j));
927: WSH_DEBUG_SV.log(l_module_name,'vendor site id ',l_vendor_site_id_table(j));
928: WSH_DEBUG_SV.log(l_module_name,'rcv id ',l_RCV_SHIP_LINES_TABLE(k));
929: WSH_DEBUG_SV.log(l_module_name,'cost ',l_RCV_SHIP_COST_TABLE(k));
930: WSH_DEBUG_SV.log(l_module_name,'currency code ',l_po_corrency_code_table(j));

Line 927: WSH_DEBUG_SV.log(l_module_name,'vendor site id ',l_vendor_site_id_table(j));

923: ELSE
924: IF l_debug_on THEN
925: WSH_DEBUG_SV.log(l_module_name,'Storing output table for id ',i);
926: WSH_DEBUG_SV.log(l_module_name,'Vendor Id ',l_vendor_id_table(j));
927: WSH_DEBUG_SV.log(l_module_name,'vendor site id ',l_vendor_site_id_table(j));
928: WSH_DEBUG_SV.log(l_module_name,'rcv id ',l_RCV_SHIP_LINES_TABLE(k));
929: WSH_DEBUG_SV.log(l_module_name,'cost ',l_RCV_SHIP_COST_TABLE(k));
930: WSH_DEBUG_SV.log(l_module_name,'currency code ',l_po_corrency_code_table(j));
931: WSH_DEBUG_SV.log(l_module_name,'status','S');

Line 928: WSH_DEBUG_SV.log(l_module_name,'rcv id ',l_RCV_SHIP_LINES_TABLE(k));

924: IF l_debug_on THEN
925: WSH_DEBUG_SV.log(l_module_name,'Storing output table for id ',i);
926: WSH_DEBUG_SV.log(l_module_name,'Vendor Id ',l_vendor_id_table(j));
927: WSH_DEBUG_SV.log(l_module_name,'vendor site id ',l_vendor_site_id_table(j));
928: WSH_DEBUG_SV.log(l_module_name,'rcv id ',l_RCV_SHIP_LINES_TABLE(k));
929: WSH_DEBUG_SV.log(l_module_name,'cost ',l_RCV_SHIP_COST_TABLE(k));
930: WSH_DEBUG_SV.log(l_module_name,'currency code ',l_po_corrency_code_table(j));
931: WSH_DEBUG_SV.log(l_module_name,'status','S');
932: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');

Line 929: WSH_DEBUG_SV.log(l_module_name,'cost ',l_RCV_SHIP_COST_TABLE(k));

925: WSH_DEBUG_SV.log(l_module_name,'Storing output table for id ',i);
926: WSH_DEBUG_SV.log(l_module_name,'Vendor Id ',l_vendor_id_table(j));
927: WSH_DEBUG_SV.log(l_module_name,'vendor site id ',l_vendor_site_id_table(j));
928: WSH_DEBUG_SV.log(l_module_name,'rcv id ',l_RCV_SHIP_LINES_TABLE(k));
929: WSH_DEBUG_SV.log(l_module_name,'cost ',l_RCV_SHIP_COST_TABLE(k));
930: WSH_DEBUG_SV.log(l_module_name,'currency code ',l_po_corrency_code_table(j));
931: WSH_DEBUG_SV.log(l_module_name,'status','S');
932: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
933: END IF;

Line 930: WSH_DEBUG_SV.log(l_module_name,'currency code ',l_po_corrency_code_table(j));

926: WSH_DEBUG_SV.log(l_module_name,'Vendor Id ',l_vendor_id_table(j));
927: WSH_DEBUG_SV.log(l_module_name,'vendor site id ',l_vendor_site_id_table(j));
928: WSH_DEBUG_SV.log(l_module_name,'rcv id ',l_RCV_SHIP_LINES_TABLE(k));
929: WSH_DEBUG_SV.log(l_module_name,'cost ',l_RCV_SHIP_COST_TABLE(k));
930: WSH_DEBUG_SV.log(l_module_name,'currency code ',l_po_corrency_code_table(j));
931: WSH_DEBUG_SV.log(l_module_name,'status','S');
932: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
933: END IF;
934: --

Line 931: WSH_DEBUG_SV.log(l_module_name,'status','S');

927: WSH_DEBUG_SV.log(l_module_name,'vendor site id ',l_vendor_site_id_table(j));
928: WSH_DEBUG_SV.log(l_module_name,'rcv id ',l_RCV_SHIP_LINES_TABLE(k));
929: WSH_DEBUG_SV.log(l_module_name,'cost ',l_RCV_SHIP_COST_TABLE(k));
930: WSH_DEBUG_SV.log(l_module_name,'currency code ',l_po_corrency_code_table(j));
931: WSH_DEBUG_SV.log(l_module_name,'status','S');
932: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
933: END IF;
934: --
935: l_receipt_lines_rec.VENDOR_ID := l_vendor_id_table(j);

Line 932: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');

928: WSH_DEBUG_SV.log(l_module_name,'rcv id ',l_RCV_SHIP_LINES_TABLE(k));
929: WSH_DEBUG_SV.log(l_module_name,'cost ',l_RCV_SHIP_COST_TABLE(k));
930: WSH_DEBUG_SV.log(l_module_name,'currency code ',l_po_corrency_code_table(j));
931: WSH_DEBUG_SV.log(l_module_name,'status','S');
932: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
933: END IF;
934: --
935: l_receipt_lines_rec.VENDOR_ID := l_vendor_id_table(j);
936: l_receipt_lines_rec.VENDOR_SITE_ID := l_vendor_site_id_table(j);

Line 969: WSH_DEBUG_SV.logmsg(l_module_name,' --End of process --After Storing output table x_receipt_lines_tab--- ');

965: --
966: -- End of building the output table - X_RECEIPT_LINES_TAB
967: --
968: IF l_debug_on THEN
969: WSH_DEBUG_SV.logmsg(l_module_name,' --End of process --After Storing output table x_receipt_lines_tab--- ');
970: end if;
971: /* this last secton is for testing only and this will be removed after the UT */
972: --dbms_output.put_line(' Total receipt lines '||x_receipt_lines_tab.COUNT);
973: /*

Line 1029: WSH_DEBUG_SV.pop(l_module_name);

1025: p_data => x_msg_data,
1026: p_encoded => FND_API.G_FALSE
1027: );
1028: IF l_debug_on THEN
1029: WSH_DEBUG_SV.pop(l_module_name);
1030: END IF;
1031:
1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1033: ROLLBACK TO FTE_PO_INTEGRATION_GRP;

Line 1042: WSH_DEBUG_SV.pop(l_module_name);

1038: p_data => x_msg_data,
1039: p_encoded => FND_API.G_FALSE
1040: );
1041: IF l_debug_on THEN
1042: WSH_DEBUG_SV.pop(l_module_name);
1043: END IF;
1044: WHEN e_validation_error THEN
1045: ROLLBACK TO FTE_PO_INTEGRATION_GRP;
1046: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 1054: WSH_DEBUG_SV.pop(l_module_name);

1050: p_data => x_msg_data,
1051: p_encoded => FND_API.G_FALSE
1052: );
1053: IF l_debug_on THEN
1054: WSH_DEBUG_SV.pop(l_module_name);
1055: END IF;
1056: WHEN OTHERS then
1057: ROLLBACK TO FTE_PO_INTEGRATION_GRP;
1058: WSH_DEBUG_SV.logmsg(l_module_name,'End of process with error : '||sqlerrm);

Line 1058: WSH_DEBUG_SV.logmsg(l_module_name,'End of process with error : '||sqlerrm);

1054: WSH_DEBUG_SV.pop(l_module_name);
1055: END IF;
1056: WHEN OTHERS then
1057: ROLLBACK TO FTE_PO_INTEGRATION_GRP;
1058: WSH_DEBUG_SV.logmsg(l_module_name,'End of process with error : '||sqlerrm);
1059: --dbms_output.put_line('Unhandled Exception '||sqlerrm );
1060: wsh_util_core.default_handler('FTE_PO_INTEGRATION_GRP.GET_ESTIMATED_RATES');
1061: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1062: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 1070: WSH_DEBUG_SV.pop(l_module_name);

1066: p_data => x_msg_data,
1067: p_encoded => FND_API.G_FALSE
1068: );
1069: IF l_debug_on THEN
1070: WSH_DEBUG_SV.pop(l_module_name);
1071: END IF;
1072: -- will be removed
1073: END GET_ESTIMATED_RATES;
1074:

Line 1144: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1140: /* Moved to global variable
1141: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1142: IF l_debug_on IS NULL
1143: THEN
1144: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1145: END IF;
1146: */
1147: OPEN c_get_rcv_shipment_lines(P_SHIPMENT_HEADER_ID,P_PO_LINE_ID,P_PO_LINE_LOCATION_ID);
1148: FETCH c_get_rcv_shipment_lines BULK COLLECT

Line 1157: WSH_DEBUG_SV.log(l_sub_module_name,'cursor c_get_rcv_shipment_lines - number '||

1153: x_rcv_ship_cost_table;
1154: close c_get_rcv_shipment_lines;
1155: --
1156: IF l_debug_on THEN
1157: WSH_DEBUG_SV.log(l_sub_module_name,'cursor c_get_rcv_shipment_lines - number '||
1158: 'of records found: ', x_rcv_ship_lines_table.COUNT);
1159: END IF;
1160: IF nvl(P_SHIP_QTY,0) <= 0 then
1161: WSH_DEBUG_SV.logmsg(l_sub_module_name,'Total Ship Qty for the PO Line'||p_po_line_id||'-'||P_PO_LINE_LOCATION_ID||

Line 1161: WSH_DEBUG_SV.logmsg(l_sub_module_name,'Total Ship Qty for the PO Line'||p_po_line_id||'-'||P_PO_LINE_LOCATION_ID||

1157: WSH_DEBUG_SV.log(l_sub_module_name,'cursor c_get_rcv_shipment_lines - number '||
1158: 'of records found: ', x_rcv_ship_lines_table.COUNT);
1159: END IF;
1160: IF nvl(P_SHIP_QTY,0) <= 0 then
1161: WSH_DEBUG_SV.logmsg(l_sub_module_name,'Total Ship Qty for the PO Line'||p_po_line_id||'-'||P_PO_LINE_LOCATION_ID||
1162: ' zero qty '||l_total_net_qty);
1163: --dbms_output.put_line('Total Ship Qty is zero ');
1164: FND_MESSAGE.SET_NAME('FTE','FTE_EC_SHIP_QTY_ZERO');
1165: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1184: WSH_DEBUG_SV.log(l_sub_module_name,'Rct Qty / UOM ',l_qty_table(h)||l_uom_code_table(h));

1180: WHILE h IS NOT NULL
1181: LOOP
1182: --{
1183: IF l_debug_on THEN
1184: WSH_DEBUG_SV.log(l_sub_module_name,'Rct Qty / UOM ',l_qty_table(h)||l_uom_code_table(h));
1185: END IF;
1186: -- get the uom code for the given unit of measure
1187: if l_uom_code_table(h) is not null and (P_SHIP_QTY_UOM <> l_uom_code_table(h)) then
1188: l_uom := l_uom_code_table(h);

Line 1216: WSH_DEBUG_SV.log(l_sub_module_name,'Rct Qty / Converted UOM ',l_qty_table(h)||l_uom_code);

1212: --
1213: x_rcv_ship_cost_table(h) := (l_qty_table(h)/P_SHIP_QTY) * p_total_cost;
1214: --
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.log(l_sub_module_name,'Rct Qty / Converted UOM ',l_qty_table(h)||l_uom_code);
1217: WSH_DEBUG_SV.log(l_sub_module_name,'Cost allocated for receipt line ',x_rcv_ship_lines_table(h)||
1218: ' Qty= '||l_qty_table(h)|| ' / '||l_total_net_qty|| ' Cost is '||x_rcv_ship_cost_table(h));
1219: END IF;
1220: --

Line 1217: WSH_DEBUG_SV.log(l_sub_module_name,'Cost allocated for receipt line ',x_rcv_ship_lines_table(h)||

1213: x_rcv_ship_cost_table(h) := (l_qty_table(h)/P_SHIP_QTY) * p_total_cost;
1214: --
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.log(l_sub_module_name,'Rct Qty / Converted UOM ',l_qty_table(h)||l_uom_code);
1217: WSH_DEBUG_SV.log(l_sub_module_name,'Cost allocated for receipt line ',x_rcv_ship_lines_table(h)||
1218: ' Qty= '||l_qty_table(h)|| ' / '||l_total_net_qty|| ' Cost is '||x_rcv_ship_cost_table(h));
1219: END IF;
1220: --
1221: h := x_rcv_ship_lines_table.NEXT(h);

Line 1234: WSH_DEBUG_SV.log(l_sub_module_name,'Could not find the UOM Code for the Rct Qty UOM ',l_qty_table(h)||l_uom);

1230: EXCEPTION
1231: WHEN e_validation_error THEN
1232: null;
1233: WHEN no_data_found then
1234: WSH_DEBUG_SV.log(l_sub_module_name,'Could not find the UOM Code for the Rct Qty UOM ',l_qty_table(h)||l_uom);
1235: WSH_DEBUG_SV.log(l_sub_module_name,'Pls query the UOM table to verify the Unit of Measure exist or not',l_uom);
1236: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1237: WHEN others then
1238: wsh_util_core.default_handler('FTE_PO_INTEGRATION_GRP.GET_RCV_SHIPMENT_LINES API');

Line 1235: WSH_DEBUG_SV.log(l_sub_module_name,'Pls query the UOM table to verify the Unit of Measure exist or not',l_uom);

1231: WHEN e_validation_error THEN
1232: null;
1233: WHEN no_data_found then
1234: WSH_DEBUG_SV.log(l_sub_module_name,'Could not find the UOM Code for the Rct Qty UOM ',l_qty_table(h)||l_uom);
1235: WSH_DEBUG_SV.log(l_sub_module_name,'Pls query the UOM table to verify the Unit of Measure exist or not',l_uom);
1236: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1237: WHEN others then
1238: wsh_util_core.default_handler('FTE_PO_INTEGRATION_GRP.GET_RCV_SHIPMENT_LINES API');
1239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;