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_UTIL_CORE

Line 447: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

443: END IF;
444: --
445: --
446: -- Initialize API return status to success
447: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
448: x_msg_count := 0;
449: x_msg_data := '';
450:
451: -- Debug

Line 609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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');
608: FND_MESSAGE.SET_TOKEN('LOG_FILE',l_debugfile);
609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
610: raise e_validation_error;
611: --}
612: END IF;
613: j := l_CC_delivery_detail_table.FIRST;

Line 785: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

781:
782: if l_vendor_id_table.count = 0 and l_CNT_parent_cont_id_table.count = 0 then
783: --{
784: --dbms_output.put_line('Delivery w/ rates not found for shipment header id '||p_shipment_header_id);
785: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
786: l_number_of_warnings := l_number_of_warnings + 1;
787: FND_MESSAGE.SET_NAME('FTE','FTE_EC_RATES_NOT_AVAILABLE');
788: FND_MESSAGE.SET_TOKEN('LOG_FILE',l_debugfile);
789: raise e_validation_error;

Line 874: if x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

870: P_SHIP_QTY_UOM =>l_ship_qty_uom_table(j),
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

Line 996: wsh_util_core.api_post_call(

992: -- clearing the cache after each call.
993: delete from fte_estimate_rates_del_temp;
994: /* end of temporary section to be removed after UT */
995: --dbms_output.put_line(' just before calling api_post_call ');
996: wsh_util_core.api_post_call(
997: p_return_status =>x_return_status,
998: x_num_warnings =>l_number_of_warnings,
999: x_num_errors =>l_number_of_errors,
1000: p_msg_data =>l_msg_data);

Line 1004: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1000: p_msg_data =>l_msg_data);
1001: --dbms_output.put_line(' just after calling api_post_call ');
1002: IF l_number_of_errors > 0
1003: THEN
1004: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1005: ELSIF l_number_of_warnings > 0
1006: THEN
1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1008: ELSE

Line 1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1003: THEN
1004: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1005: ELSIF l_number_of_warnings > 0
1006: THEN
1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1008: ELSE
1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1010: END IF;
1011:

Line 1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1005: ELSIF l_number_of_warnings > 0
1006: THEN
1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1008: ELSE
1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1010: END IF;
1011:
1012: FND_MSG_PUB.Count_And_Get
1013: (

Line 1034: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1030: END IF;
1031:
1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1033: ROLLBACK TO FTE_PO_INTEGRATION_GRP;
1034: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1035: FND_MSG_PUB.Count_And_Get
1036: (
1037: p_count => x_msg_count,
1038: p_data => x_msg_data,

Line 1046: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

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);
1047: FND_MSG_PUB.Count_And_Get
1048: (
1049: p_count => x_msg_count,
1050: p_data => x_msg_data,

Line 1060: wsh_util_core.default_handler('FTE_PO_INTEGRATION_GRP.GET_ESTIMATED_RATES');

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);
1063: FND_MSG_PUB.Count_And_Get
1064: (

Line 1061: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
1063: FND_MSG_PUB.Count_And_Get
1064: (
1065: p_count => x_msg_count,

Line 1062: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

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);
1063: FND_MSG_PUB.Count_And_Get
1064: (
1065: p_count => x_msg_count,
1066: p_data => x_msg_data,

Line 1165: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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;
1166: --dbms_output.put_line('Total Ship Qty for the given po line id, po line location id is zero ');
1167: -- raise e_validation_error;
1168: END IF;
1169: -- Only if P_TOTAL_COST is > 0 and Ship Qty > 0, distribute the cost to all receipts, otherwise just return all receipts with zero cost

Line 1226: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1222: --}
1223: END LOOP; --End of x_rcv_ship_lines_table Table
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

Line 1236: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

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 1239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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:
1243: END FTE_PO_INTEGRATION_GRP;