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 RCV_SHIPMENT_LINES

Line 24: -- (by calling get_rcv_shipment_lines API)

20: -- step-1. Find the shipment header has a match delivery or not
21: -- step-2. if there is a match, go to main-step-3 for matching receipt rates
22: -- step-3 if there is a mismatch, find all corresponding po lines for the given shipment header id
23: -- from wdd/rcv and get the rates from wfc tables
24: -- (by calling get_rcv_shipment_lines API)
25: -- 3. Matched Receipts w/ Delivery (it means you can have a receipt line id
26: -- at WDD level and Shipment header id at WND
27: -- --Get the detail rates for TL, LTL, Parcel, etc.. for non packed items
28: -- --Get all contaner rates for TL, LTL, and Parcel, etc for packed items.

Line 71: PROCEDURE get_rcv_shipment_lines ( x_return_status OUT NOCOPY VARCHAR2,

67: for the given shipment header id, po line id, po line location id
68: Prorate the cost at po line location level to each receipt lines based on the qty
69: */
70:
71: PROCEDURE get_rcv_shipment_lines ( x_return_status OUT NOCOPY VARCHAR2,
72: P_SHIPMENT_HEADER_ID IN VARCHAR2,
73: P_PO_LINE_ID IN NUMBER,
74: P_PO_LINE_LOCATION_ID IN NUMBER,
75: P_TOTAL_COST IN NUMBER,

Line 107: rcv_shipment_lines rsl

103: union
104: select distinct wda.DELIVERY_ID, 'Y' RATE_AVAILABLE_FLAG,'N' MATCHING_FLAG
105: from WSH_DELIVERY_ASSIGNMENTS_V wda,
106: wsh_delivery_details wdd,
107: rcv_shipment_lines rsl
108: where wda.delivery_detail_id=wdd.delivery_detail_id
109: and wdd.rcv_shipment_line_id is null
110: and rsl.shipment_header_id = l_shipment_header_id
111: AND rsl.po_line_location_id = wdd.PO_SHIPMENT_LINE_ID

Line 174: rcv_shipment_lines rsl,

170: wdd.po_shipment_line_id,
171: rsl.shipment_line_id
172: FROM WSH_DELIVERY_DETAILS WDD,
173: WSH_DELIVERY_ASSIGNMENTS_V WDA,
174: rcv_shipment_lines rsl,
175: fte_estimate_rates_del_temp tmp2
176: WHERE WDA.delivery_detail_id = wdd.delivery_detail_id
177: AND rsl.po_line_location_id = wdd.PO_SHIPMENT_LINE_ID
178: and rsl.po_line_id = wdd.source_line_id

Line 369: --Get RCV shipment Lines out variables

365: l_message varchar2(1000);
366: l_loop_counter number;
367: l_rcv_count number ;
368:
369: --Get RCV shipment Lines out variables
370: l_RCV_SHIP_LINES_TABLE FTE_PO_INTEGRATION_GRP.fte_number_table;
371: l_RCV_SHIP_COST_TABLE FTE_PO_INTEGRATION_GRP.fte_number_table;
372:
373: -- Container level rates variable

Line 852: -- Need to call get_rcv_shipment_lines and pro-rated cost for each rcv shipment lines

848: l_rcv_ship_cost_table.delete;
849: --dbms_output.put_line('After purging RCV Tables ');
850: -- Validating that shipment is matched or not
851: -- If the rcv shipment line is NULL, the shipment line is not matched
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) );

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 863: --dbms_output.put_line('RCV shipment line id is null, calling get_rcv_shipment_lines API to get the receipt lines');

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,
866: P_SHIPMENT_HEADER_ID =>p_shipment_header_id,
867: P_PO_LINE_ID =>l_po_line_id_table(j),

Line 864: -- get all rcv shipment lines for the given po line id and po line location id

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,
866: P_SHIPMENT_HEADER_ID =>p_shipment_header_id,
867: P_PO_LINE_ID =>l_po_line_id_table(j),
868: P_PO_LINE_LOCATION_ID =>l_po_line_loc_id_table(j),

Line 865: get_rcv_shipment_lines (x_return_status => x_return_status,

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,
866: P_SHIPMENT_HEADER_ID =>p_shipment_header_id,
867: P_PO_LINE_ID =>l_po_line_id_table(j),
868: P_PO_LINE_LOCATION_ID =>l_po_line_loc_id_table(j),
869: P_TOTAL_COST =>l_total_cost_table(j),

Line 875: --dbms_output.put_line('error while calling get_rcv_shipment_lines API');

871: P_SHIP_QTY =>l_ship_qty_table(j),
872: X_RCV_SHIP_LINES_TABLE =>l_rcv_ship_lines_table,
873: X_RCV_SHIP_COST_TABLE =>l_rcv_ship_cost_table);
874: if x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
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 );

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 1099: PROCEDURE get_rcv_shipment_lines ( x_return_status OUT NOCOPY VARCHAR2,

1095: for the given shipment header id, po line id, po line location id
1096: Prorate the cost at po line location level to each receipt lines based on the qty
1097: */
1098:
1099: PROCEDURE get_rcv_shipment_lines ( x_return_status OUT NOCOPY VARCHAR2,
1100: P_SHIPMENT_HEADER_ID IN VARCHAR2,
1101: P_PO_LINE_ID IN NUMBER,
1102: P_PO_LINE_LOCATION_ID IN NUMBER,
1103: P_TOTAL_COST IN NUMBER,

Line 1111: -- Get all receipt shipment lines from RCV_SHIPMENT_LINES for the given po_line_id and po_line_location_id

1107: X_RCV_SHIP_COST_TABLE OUT NOCOPY FTE_PO_INTEGRATION_GRP.fte_number_table) IS
1108:
1109: -- Need to verify the item id and qty uom (or unit of measure )
1110: -- get the item id from wdd instead of rsl since it will be same for the same po line location id
1111: -- Get all receipt shipment lines from RCV_SHIPMENT_LINES for the given po_line_id and po_line_location_id
1112: cursor c_get_rcv_shipment_lines (l_shipment_header_id number, l_po_line_id number, l_po_line_loc_id number) IS
1113: select shipment_line_id,
1114: item_id,
1115: quantity_received,

Line 1112: cursor c_get_rcv_shipment_lines (l_shipment_header_id number, l_po_line_id number, l_po_line_loc_id number) IS

1108:
1109: -- Need to verify the item id and qty uom (or unit of measure )
1110: -- get the item id from wdd instead of rsl since it will be same for the same po line location id
1111: -- Get all receipt shipment lines from RCV_SHIPMENT_LINES for the given po_line_id and po_line_location_id
1112: cursor c_get_rcv_shipment_lines (l_shipment_header_id number, l_po_line_id number, l_po_line_loc_id number) IS
1113: select shipment_line_id,
1114: item_id,
1115: quantity_received,
1116: unit_of_measure,

Line 1118: from rcv_shipment_lines

1114: item_id,
1115: quantity_received,
1116: unit_of_measure,
1117: 0 total_cost
1118: from rcv_shipment_lines
1119: where shipment_header_id = l_shipment_header_id
1120: and po_line_id = l_po_line_id
1121: and po_line_location_id = l_po_line_loc_id;
1122:

Line 1136: l_sub_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'GET_RCV_SHIPMENT_LINES';

1132: l_qty_table FTE_PO_INTEGRATION_GRP.fte_number_table;
1133: l_uom_code_table FTE_PO_INTEGRATION_GRP.fte_varchar25_table;
1134: l_rcv_ship_line_id_table FTE_PO_INTEGRATION_GRP.fte_number_table;
1135:
1136: l_sub_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'GET_RCV_SHIPMENT_LINES';
1137: --
1138: BEGIN
1139: --dbms_output.put_line('You are calling GET_RCV_SHIPMENT_LINES API');
1140: /* Moved to global variable

Line 1139: --dbms_output.put_line('You are calling GET_RCV_SHIPMENT_LINES API');

1135:
1136: l_sub_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'GET_RCV_SHIPMENT_LINES';
1137: --
1138: BEGIN
1139: --dbms_output.put_line('You are calling GET_RCV_SHIPMENT_LINES API');
1140: /* Moved to global variable
1141: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1142: IF l_debug_on IS NULL
1143: THEN

Line 1147: OPEN c_get_rcv_shipment_lines(P_SHIPMENT_HEADER_ID,P_PO_LINE_ID,P_PO_LINE_LOCATION_ID);

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
1149: INTO x_rcv_ship_lines_table,
1150: l_item_id_table,
1151: l_qty_table,

Line 1148: FETCH c_get_rcv_shipment_lines BULK COLLECT

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
1149: INTO x_rcv_ship_lines_table,
1150: l_item_id_table,
1151: l_qty_table,
1152: l_uom_code_table,

Line 1154: close c_get_rcv_shipment_lines;

1150: l_item_id_table,
1151: l_qty_table,
1152: l_uom_code_table,
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);

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 1228: --dbms_output.put_line('End of getting rcv shipment lines for the non-matching shipments ');

1224: --}
1225: END IF; -- nvl(P_TOTAL_COST,0) > 0
1226: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1227: --
1228: --dbms_output.put_line('End of getting rcv shipment lines for the non-matching shipments ');
1229:
1230: EXCEPTION
1231: WHEN e_validation_error THEN
1232: null;

Line 1238: wsh_util_core.default_handler('FTE_PO_INTEGRATION_GRP.GET_RCV_SHIPMENT_LINES API');

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;
1240: --dbms_output.put_line('Unhandled Exception '||sqlerrm );
1241: END GET_RCV_SHIPMENT_LINES;
1242:

Line 1241: END GET_RCV_SHIPMENT_LINES;

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;
1240: --dbms_output.put_line('Unhandled Exception '||sqlerrm );
1241: END GET_RCV_SHIPMENT_LINES;
1242:
1243: END FTE_PO_INTEGRATION_GRP;