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_DIST_INT_PKG dependencies on WSH_UTIL_CORE

Line 259: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

255: --
256: -- Set the return flags for the start of the procedure
257: --
258: x_return_message := null;
259: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
260:
261: --
262: -- Clear the message tab
263: --

Line 644: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;

640: l_msg_ctr := msg_message_text_tab.COUNT + 1;
641: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGN_MAP_DEST_LOC');
642: FND_MESSAGE.SET_TOKEN('LOCATION_ID',to_char(p_distance_input_tab(eee).destination_id));
643: msg_message_text_tab(l_msg_ctr) := FND_MESSAGE.GET;
644: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;
645: msg_message_code_tab(l_msg_ctr) := 'NO_REGION_MAP_D';
646: msg_location_region_flag_tab(l_msg_ctr) := p_location_region_flag;
647: msg_level_tab(l_msg_ctr) := l_distance_profile;
648: msg_table_origin_id_tab(l_msg_ctr) := null;

Line 673: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;

669: l_msg_ctr := msg_message_text_tab.COUNT + 1;
670: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGN_MAP_ORIG_LOC');
671: FND_MESSAGE.SET_TOKEN('LOCATION_ID',to_char(p_distance_input_tab(eee).origin_id));
672: msg_message_text_tab(l_msg_ctr) := FND_MESSAGE.GET;
673: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;
674: msg_message_code_tab(l_msg_ctr) := 'NO_REGION_MAP_O';
675: msg_location_region_flag_tab(l_msg_ctr) := p_location_region_flag;
676: msg_level_tab(l_msg_ctr) := l_distance_profile;
677: msg_table_origin_id_tab(l_msg_ctr) := null;

Line 861: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR

857: WSH_DEBUG_SV.log(l_module_name,'x_return_status',l_return_status);
858: END IF;
859:
860:
861: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR
862: (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
863: --
864: -- A serious error occurred performing the search
865: --

Line 862: (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

858: END IF;
859:
860:
861: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR
862: (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
863: --
864: -- A serious error occurred performing the search
865: --
866: IF l_debug_on THEN

Line 940: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

936: END IF;
937:
938:
939: x_distance_output_tab := l_result_table;
940: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
941: x_return_message := null;
942: x_distance_message_tab := g_message_tab;
943: g_message_tab.DELETE;
944: --

Line 960: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

956: IF l_debug_on THEN
957: WSH_DEBUG_SV.logmsg(l_module_name,'The search executed successfully but no records were found - return with a warning status');
958: END IF;
959:
960: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
961: x_return_message := WSH_UTIL_CORE.G_RET_STS_WARNING;
962: x_distance_message_tab := g_message_tab;
963: g_message_tab.DELETE;
964:

Line 961: x_return_message := WSH_UTIL_CORE.G_RET_STS_WARNING;

957: WSH_DEBUG_SV.logmsg(l_module_name,'The search executed successfully but no records were found - return with a warning status');
958: END IF;
959:
960: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
961: x_return_message := WSH_UTIL_CORE.G_RET_STS_WARNING;
962: x_distance_message_tab := g_message_tab;
963: g_message_tab.DELETE;
964:
965: --

Line 989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

985: EXCEPTION
986: WHEN FTE_DIST_NO_INPUT_DATA THEN
987: --5067249
988: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_INPUT_DATA');
989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
990: x_return_message := 'FTE_DIST_NO_INPUT_DATA';
991: --WSH_UTIL_CORE.add_message(x_return_status);
992:
993: --

Line 991: --WSH_UTIL_CORE.add_message(x_return_status);

987: --5067249
988: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_INPUT_DATA');
989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
990: x_return_message := 'FTE_DIST_NO_INPUT_DATA';
991: --WSH_UTIL_CORE.add_message(x_return_status);
992:
993: --
994: -- Close any open cursors
995: --

Line 1012: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1008:
1009: WHEN FTE_DIST_INVALID_LOC_REG_FLAG THEN
1010: --5067249
1011: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_LOC_REG_FLAG');
1012: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1013: x_return_message := 'FTE_DIST_INVALID_LOC_REG_FLAG';
1014: --WSH_UTIL_CORE.add_message(x_return_status);
1015:
1016: --

Line 1014: --WSH_UTIL_CORE.add_message(x_return_status);

1010: --5067249
1011: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_LOC_REG_FLAG');
1012: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1013: x_return_message := 'FTE_DIST_INVALID_LOC_REG_FLAG';
1014: --WSH_UTIL_CORE.add_message(x_return_status);
1015:
1016: --
1017: -- Close any open cursors
1018: --

Line 1054: WSH_UTIL_CORE.default_handler('FTE_DIST_INT.GET_DISTANCE_TIME');

1050: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_DISTANCE_SEARCH_ERR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1051: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_DISTANCE_SEARCH_ERR');
1052: END IF;
1053: --
1054: WSH_UTIL_CORE.default_handler('FTE_DIST_INT.GET_DISTANCE_TIME');
1055:
1056: WHEN FTE_DIST_INVALID_PROFILE THEN
1057: --5067249
1058: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_PROFILE');

Line 1059: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1055:
1056: WHEN FTE_DIST_INVALID_PROFILE THEN
1057: --5067249
1058: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_PROFILE');
1059: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1060: x_return_message := 'FTE_DIST_INVALID_PROFILE';
1061: --WSH_UTIL_CORE.add_message(x_return_status);
1062:
1063: --

Line 1061: --WSH_UTIL_CORE.add_message(x_return_status);

1057: --5067249
1058: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_PROFILE');
1059: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1060: x_return_message := 'FTE_DIST_INVALID_PROFILE';
1061: --WSH_UTIL_CORE.add_message(x_return_status);
1062:
1063: --
1064: -- Close any open cursors
1065: --

Line 1083: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1079:
1080: WHEN FTE_DIST_NULL_PROFILE THEN
1081: --5067249
1082: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_PROFILE');
1083: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1084: x_return_message := 'FTE_DIST_NULL_PROFILE';
1085: --WSH_UTIL_CORE.add_message(x_return_status);
1086:
1087: --

Line 1085: --WSH_UTIL_CORE.add_message(x_return_status);

1081: --5067249
1082: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_PROFILE');
1083: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1084: x_return_message := 'FTE_DIST_NULL_PROFILE';
1085: --WSH_UTIL_CORE.add_message(x_return_status);
1086:
1087: --
1088: -- Close any open cursors
1089: --

Line 1107: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1103:
1104: WHEN FTE_DIST_NO_REGS_FOR_ANY_LOCS THEN
1105: --5067249
1106: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGS_FOR_ANY_LOCS');
1107: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1108: x_return_message := 'FTE_DIST_NO_REGS_FOR_ANY_LOCS';
1109: --WSH_UTIL_CORE.add_message(x_return_status);
1110:
1111: --

Line 1109: --WSH_UTIL_CORE.add_message(x_return_status);

1105: --5067249
1106: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGS_FOR_ANY_LOCS');
1107: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1108: x_return_message := 'FTE_DIST_NO_REGS_FOR_ANY_LOCS';
1109: --WSH_UTIL_CORE.add_message(x_return_status);
1110:
1111: --
1112: -- Close any open cursors
1113: --

Line 1131: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1127:
1128: WHEN FTE_DIST_NO_REGS_IN_SEARCH THEN
1129: --5067249
1130: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGS_IN_SEARCH');
1131: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1132: x_return_message := 'FTE_DIST_NO_REGS_IN_SEARCH';
1133: --WSH_UTIL_CORE.add_message(x_return_status);
1134:
1135: --

Line 1133: --WSH_UTIL_CORE.add_message(x_return_status);

1129: --5067249
1130: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGS_IN_SEARCH');
1131: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1132: x_return_message := 'FTE_DIST_NO_REGS_IN_SEARCH';
1133: --WSH_UTIL_CORE.add_message(x_return_status);
1134:
1135: --
1136: -- Close any open cursors
1137: --

Line 1155: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1151:
1152: WHEN FTE_DIST_NULL_REGION_TYPE THEN
1153: --5067249
1154: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_REGION_TYPE');
1155: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1156: x_return_message := 'FTE_DIST_NULL_REGION_TYPE';
1157: --WSH_UTIL_CORE.add_message(x_return_status);
1158:
1159: --

Line 1157: --WSH_UTIL_CORE.add_message(x_return_status);

1153: --5067249
1154: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_REGION_TYPE');
1155: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1156: x_return_message := 'FTE_DIST_NULL_REGION_TYPE';
1157: --WSH_UTIL_CORE.add_message(x_return_status);
1158:
1159: --
1160: -- Close any open cursors
1161: --

Line 1195: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.GET_DISTANCE_TIME');

1191: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1193: END IF;
1194: --
1195: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.GET_DISTANCE_TIME');
1196: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1197: x_return_message := l_error_text;
1198:
1199: END GET_DISTANCE_TIME;

Line 1196: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1193: END IF;
1194: --
1195: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.GET_DISTANCE_TIME');
1196: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1197: x_return_message := l_error_text;
1198:
1199: END GET_DISTANCE_TIME;
1200:

Line 1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1372: --
1373: -- Set the return parameters for the start of the procedure
1374: --
1375: x_return_message := null;
1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1377:
1378:
1379: l_ctr := 0;
1380: --

Line 1536: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;

1532: END IF;
1533:
1534: l_msg_ctr := msg_message_text_tab.COUNT + 1;
1535: msg_message_text_tab(l_msg_ctr) := l_msg_no_rcds_fnd;
1536: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;
1537: msg_message_code_tab(l_msg_ctr) := 'NO_RECORDS_FOUND';
1538: msg_location_region_flag_tab(l_msg_ctr) := p_location_region_flag;
1539: msg_level_tab(l_msg_ctr) := p_level;
1540: msg_table_origin_id_tab(l_msg_ctr) := null;

Line 1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1554: --
1555: -- set the return status to a warning
1556: --
1557: x_return_message := null;
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1559: --
1560: -- Debug Statements
1561: --
1562: -- IF l_debug_on THEN

Line 1589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1585: WSH_DEBUG_SV.logmsg(l_module_name,'We have a winner');
1586: END IF;
1587: x_result_table := l_result_table;
1588: x_return_message := null;
1589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1590: --
1591: -- Debug Statements
1592: --
1593: IF l_debug_on THEN

Line 1628: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;

1624: -- no result just return a warning
1625: --
1626: l_msg_ctr := msg_message_text_tab.COUNT + 1;
1627: msg_message_text_tab(l_msg_ctr) := l_msg_no_rcds_fnd;
1628: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;
1629: msg_message_code_tab(l_msg_ctr) := 'NO_RECORDS_FOUND';
1630: msg_location_region_flag_tab(l_msg_ctr) := p_location_region_flag;
1631: msg_level_tab(l_msg_ctr) := p_level;
1632: msg_table_origin_id_tab(l_msg_ctr) := null;

Line 1654: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1650: END IF;
1651:
1652: x_result_found := 'N';
1653: x_return_message := null;
1654: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1655: --
1656: -- Debug Statements
1657: --
1658: IF l_debug_on THEN

Line 1694: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.DISTANCE_SEARCH');

1690: IF l_debug_on THEN
1691: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.DISTANCE_SEARCH IS ' ||L_ERROR_TEXT );
1692: END IF;
1693: --
1694: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.DISTANCE_SEARCH');
1695: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1696: x_return_message := ('FTE_DIST_INT_PKG.DISTANCE_SEARCH '||l_error_text);
1697: --
1698: -- Debug Statements

Line 1695: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1691: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.DISTANCE_SEARCH IS ' ||L_ERROR_TEXT );
1692: END IF;
1693: --
1694: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.DISTANCE_SEARCH');
1695: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1696: x_return_message := ('FTE_DIST_INT_PKG.DISTANCE_SEARCH '||l_error_text);
1697: --
1698: -- Debug Statements
1699: --

Line 1805: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1801: IF l_debug_on THEN
1802: WSH_DEBUG_SV.push(l_module_name);
1803: END IF;
1804:
1805: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1806: x_return_message := null;
1807:
1808:
1809: FOR abcd IN p_message_type_tab.FIRST..p_message_type_tab.LAST LOOP

Line 1866: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1862: END IF;
1863:
1864: END LOOP;
1865:
1866: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1867: x_return_message := null;
1868: --
1869: -- Debug Statements
1870: --

Line 1888: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES');

1884: IF l_debug_on THEN
1885: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES IS ' ||L_ERROR_TEXT );
1886: END IF;
1887: --
1888: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES');
1889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1890: x_return_message := ('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES '||l_error_text);
1891: --
1892: -- Debug Statements

Line 1889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1885: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES IS ' ||L_ERROR_TEXT );
1886: END IF;
1887: --
1888: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES');
1889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1890: x_return_message := ('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES '||l_error_text);
1891: --
1892: -- Debug Statements
1893: --