eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SHIPMENT_ADVICE_PUB dependencies on WSH_FREIGHT_COSTS_INTERFACE

Line 361: wsh_debug_sv.logmsg(l_module_name, 'Inserting WSH_FREIGHT_COSTS_INTERFACE for the delivery');

357:
358: IF p_delivery_rec.delivery_freight_tab.count>0 THEN --Delivery's Freight costs
359: --{
360: IF l_debug_on THEN
361: wsh_debug_sv.logmsg(l_module_name, 'Inserting WSH_FREIGHT_COSTS_INTERFACE for the delivery');
362: END IF;
363: FOR k in 1..p_delivery_rec.delivery_freight_tab.count LOOP --Looping through Delivery's Freight costs
364:
365: INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(

Line 365: INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(

361: wsh_debug_sv.logmsg(l_module_name, 'Inserting WSH_FREIGHT_COSTS_INTERFACE for the delivery');
362: END IF;
363: FOR k in 1..p_delivery_rec.delivery_freight_tab.count LOOP --Looping through Delivery's Freight costs
364:
365: INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
366: FREIGHT_COST_INTERFACE_ID,
367: INTERFACE_ACTION_CODE,
368: ATTRIBUTE_CATEGORY,
369: ATTRIBUTE1,

Line 394: wsh_freight_costs_interface_s.nextval,

390: FREIGHT_COST_TYPE_CODE,
391: UNIT_AMOUNT,
392: CURRENCY_CODE)
393: VALUES(
394: wsh_freight_costs_interface_s.nextval,
395: G_INTERFACE_ACTION_CODE,
396: p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE_CATEGORY,
397: p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE1,
398: p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE2,

Line 580: INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(

576: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WFCI for delivery detail rec ' || i);
577: END IF;
578: FOR k in 1..p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab.count LOOP
579: --{
580: INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
581: FREIGHT_COST_INTERFACE_ID,
582: INTERFACE_ACTION_CODE,
583: ATTRIBUTE_CATEGORY,
584: ATTRIBUTE1,

Line 609: wsh_freight_costs_interface_s.nextval,

605: FREIGHT_COST_TYPE_CODE,
606: UNIT_AMOUNT,
607: CURRENCY_CODE)
608: VALUES(
609: wsh_freight_costs_interface_s.nextval,
610: G_INTERFACE_ACTION_CODE,
611: p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE_CATEGORY,
612: p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE1,
613: p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE2,

Line 763: INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(

759: wsh_debug_sv.logmsg(l_module_name, 'Inserting Master Container Freight records into WFCI');
760: END IF;
761: FOR k in 1..p_delivery_rec.container_tab(i).Master_Container_Freight_Tab.count LOOP --Master Containers Freight
762: --{
763: INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
764: FREIGHT_COST_INTERFACE_ID,
765: INTERFACE_ACTION_CODE,
766: ATTRIBUTE_CATEGORY,
767: ATTRIBUTE1,

Line 792: wsh_freight_costs_interface_s.nextval,

788: FREIGHT_COST_TYPE_CODE,
789: UNIT_AMOUNT,
790: CURRENCY_CODE)
791: VALUES(
792: wsh_freight_costs_interface_s.nextval,
793: G_INTERFACE_ACTION_CODE,
794: p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE_CATEGORY,
795: p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE1,
796: p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE2,

Line 947: INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(

943: wsh_debug_sv.logmsg(l_module_name, 'Inserting Inner Container Freight records into WFCI');
944: END IF;
945: FOR l in 1..p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab.count LOOP --Inner Containers Freight Costs
946: --{
947: INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
948: FREIGHT_COST_INTERFACE_ID,
949: INTERFACE_ACTION_CODE,
950: ATTRIBUTE_CATEGORY,
951: ATTRIBUTE1,

Line 976: wsh_freight_costs_interface_s.nextval,

972: FREIGHT_COST_TYPE_CODE,
973: UNIT_AMOUNT,
974: CURRENCY_CODE)
975: VALUES(
976: wsh_freight_costs_interface_s.nextval,
977: G_INTERFACE_ACTION_CODE,
978: p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE_CATEGORY,
979: p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE1,
980: p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE2,

Line 1434: --WSH_FREIGHT_COSTS_INTERFACE info

1430: WSH_DEBUG_SV.log(l_module_name,' operator',p_delivery_rec.operator);
1431: WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1432:
1433: WSH_DEBUG_SV.log(l_module_name,'p_delivery_rec.delivery_freight_tab.count',p_delivery_rec.delivery_freight_tab.count);
1434: --WSH_FREIGHT_COSTS_INTERFACE info
1435: IF p_delivery_rec.delivery_freight_tab.count > 0 THEN
1436: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_FREIGHT_COSTS_INTERFACE info for the delivery');
1437: WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1438: FOR k in 1..p_delivery_rec.delivery_freight_tab.count LOOP

Line 1436: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_FREIGHT_COSTS_INTERFACE info for the delivery');

1432:
1433: WSH_DEBUG_SV.log(l_module_name,'p_delivery_rec.delivery_freight_tab.count',p_delivery_rec.delivery_freight_tab.count);
1434: --WSH_FREIGHT_COSTS_INTERFACE info
1435: IF p_delivery_rec.delivery_freight_tab.count > 0 THEN
1436: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_FREIGHT_COSTS_INTERFACE info for the delivery');
1437: WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1438: FOR k in 1..p_delivery_rec.delivery_freight_tab.count LOOP
1439: WSH_DEBUG_SV.log(l_module_name,' freight_cost_type_code',p_delivery_rec.delivery_freight_tab(k).freight_cost_type_code);
1440: WSH_DEBUG_SV.log(l_module_name,' unit_amount',p_delivery_rec.delivery_freight_tab(k).unit_amount);