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

Line 326: l_locIds WSH_UTIL_CORE.Id_Tab_Type;

322: PROCEDURE Fetch_Facility_Descriptions IS
323:
324: l_compNames Index_Varchar100_Tbl_Type;
325: l_compSites Index_Varchar100_Tbl_Type;
326: l_locIds WSH_UTIL_CORE.Id_Tab_Type;
327: l_company_types Index_Varchar100_Tbl_Type;
328: l_dates WSH_UTIL_CORE.Date_Tab_Type;
329: l_locId NUMBER;
330: l_desc VARCHAR2(100);

Line 328: l_dates WSH_UTIL_CORE.Date_Tab_Type;

324: l_compNames Index_Varchar100_Tbl_Type;
325: l_compSites Index_Varchar100_Tbl_Type;
326: l_locIds WSH_UTIL_CORE.Id_Tab_Type;
327: l_company_types Index_Varchar100_Tbl_Type;
328: l_dates WSH_UTIL_CORE.Date_Tab_Type;
329: l_locId NUMBER;
330: l_desc VARCHAR2(100);
331: l_locid_exists BOOLEAN;
332:

Line 590: -- i. WSH_UTIL_CORE.G_RET_STS_SUCCESS: All facilities created.

586: -- location ids, if applicable.
587: --
588: -- OUT Parameters : x_return_status VARCHAR2
589: -- The return status is one of the following:
590: -- i. WSH_UTIL_CORE.G_RET_STS_SUCCESS: All facilities created.
591: -- ii. WSH_UTIL_CORE.G_RET_STS_WARNING: If some of the location_ids
592: -- already had facilities created.
593: -- iii. WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
594: -- Version : 1.0

Line 591: -- ii. WSH_UTIL_CORE.G_RET_STS_WARNING: If some of the location_ids

587: --
588: -- OUT Parameters : x_return_status VARCHAR2
589: -- The return status is one of the following:
590: -- i. WSH_UTIL_CORE.G_RET_STS_SUCCESS: All facilities created.
591: -- ii. WSH_UTIL_CORE.G_RET_STS_WARNING: If some of the location_ids
592: -- already had facilities created.
593: -- iii. WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
594: -- Version : 1.0
595: -- Previous version 1.0

Line 593: -- iii. WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

589: -- The return status is one of the following:
590: -- i. WSH_UTIL_CORE.G_RET_STS_SUCCESS: All facilities created.
591: -- ii. WSH_UTIL_CORE.G_RET_STS_WARNING: If some of the location_ids
592: -- already had facilities created.
593: -- iii. WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
594: -- Version : 1.0
595: -- Previous version 1.0
596: -- Initial version 1.0
597: -- End of comments

Line 662: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

658: m NUMBER;
659: BEGIN
660: Init_Debug(l_module_name);
661:
662: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
663: g_dup_locations := STRINGARRAY();
664:
665: --Ensure that the company_names and location_id tables are the same length;
666: IF (p_company_names.COUNT <> p_location_ids.COUNT) THEN

Line 685: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

681: x_Param_Info => l_Param_Info,
682: x_return_status => l_return_status );
683:
684: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
685: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
686: END IF;
687:
688: l_LoadUnload_Time_Uom := l_param_info.Time_Uom;
689:

Line 691: IF (WSH_UTIL_CORE.Tp_Is_Installed = 'Y') THEN

687:
688: l_LoadUnload_Time_Uom := l_param_info.Time_Uom;
689:
690: --Get TP Global Attributes from TP Global Preferences
691: IF (WSH_UTIL_CORE.Tp_Is_Installed = 'Y') THEN
692: LogMsg(l_module_name, 'Calling TP API to Obtain Global Parameters');
693:
694: BEGIN
695: l_sql_str := 'BEGIN

Line 726: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

722: OUT l_msg_count,
723: OUT x_error_msg;
724:
725: IF (x_error_msg IS NOT NULL AND l_msg_count > 0) THEN
726: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
727: RETURN;
728: END IF;
729:
730: IF (l_pall_handling_uom = 'CONTAINER' OR l_pall_handling_uom = 'PALLET') THEN

Line 930: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

926: ELSE
927: x_error_msg := 'UNEXP. ERROR WHILE CREATING FACILITY FOR LOCATION ' || p_location_ids(l_start + sql%rowcount);
928: x_error_msg := x_error_msg || ' => ' || SQLERRM;
929: LogMsg(l_module_name, x_error_msg);
930: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
931: Exit_Debug(l_module_name);
932: RETURN;
933: END IF;
934: END;

Line 964: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

960: NULL;
961: WHEN OTHERS THEN
962: x_error_msg := 'UNEXPECTED ERROR WHILE DELETING CUSTOMER DUMMY FACILITIES ' || sqlerrm;
963: LogMsg(l_module_name, x_error_msg);
964: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
965: END;
966:
967: m := SQL%ROWCOUNT;
968: k := k - m;

Line 980: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

976: NULL;
977: WHEN OTHERS THEN
978: x_error_msg := 'UNEXPECTED ERROR WHILE DELETING BAD FACILITIES ' || sqlerrm;
979: LogMsg(l_module_name, x_error_msg);
980: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
981: END;
982:
983: l := SQL%ROWCOUNT;
984: k := k - l;

Line 1017: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN

1013: END LOOP;
1014: LogMsg(l_module_name, '***************************************************************');
1015: Fnd_File.Put_Line(Fnd_File.output, '***************************************************************');
1016:
1017: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1018: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1019: x_error_msg := 'Some facilities already exist. Please check log file for details';
1020: Fnd_File.Put_Line(Fnd_File.output,
1021: 'WARNING: Some facilities already exist. Please check log file for details');

Line 1018: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1014: LogMsg(l_module_name, '***************************************************************');
1015: Fnd_File.Put_Line(Fnd_File.output, '***************************************************************');
1016:
1017: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1018: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1019: x_error_msg := 'Some facilities already exist. Please check log file for details';
1020: Fnd_File.Put_Line(Fnd_File.output,
1021: 'WARNING: Some facilities already exist. Please check log file for details');
1022: END IF;

Line 1029: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1025: -- ************************** ERROR REPORTING ************************************
1026:
1027: Reset_All;
1028: IF l_debug_on THEN
1029: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1030: WSH_DEBUG_SV.pop(x_Module => l_module_name,
1031: x_Context => 'EXCEPTION:OTHERS');
1032: ELSE
1033: Exit_Debug(l_module_name);

Line 1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1035: END IF;
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: x_error_msg := 'UNEXPECTED ERROR ' || sqlerrm;
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1040: LogMsg(l_module_name, x_error_msg);
1041:
1042: IF l_debug_on THEN
1043: WSH_DEBUG_SV.pop(x_Module => l_module_name,

Line 1066: -- i. WSH_UTIL_CORE.G_RET_STS_SUCCESS: Facility created successfully

1062: -- generated from the company name and site name.
1063: --
1064: -- OUT: x_return_status OUT NOCOPY VARCHAR2
1065: -- The return status is one of the following:
1066: -- i. WSH_UTIL_CORE.G_RET_STS_SUCCESS: Facility created successfully
1067: -- iv. WSH_UTIL_CORE.G_RET_STS_WARNING: If facility already exists.
1068: -- iv. WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1069: -- x_error_msg OUT NOCOPY VARCHAR2
1070: -- The error message

Line 1067: -- iv. WSH_UTIL_CORE.G_RET_STS_WARNING: If facility already exists.

1063: --
1064: -- OUT: x_return_status OUT NOCOPY VARCHAR2
1065: -- The return status is one of the following:
1066: -- i. WSH_UTIL_CORE.G_RET_STS_SUCCESS: Facility created successfully
1067: -- iv. WSH_UTIL_CORE.G_RET_STS_WARNING: If facility already exists.
1068: -- iv. WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1069: -- x_error_msg OUT NOCOPY VARCHAR2
1070: -- The error message
1071: -- Version : 1.0

Line 1068: -- iv. WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1064: -- OUT: x_return_status OUT NOCOPY VARCHAR2
1065: -- The return status is one of the following:
1066: -- i. WSH_UTIL_CORE.G_RET_STS_SUCCESS: Facility created successfully
1067: -- iv. WSH_UTIL_CORE.G_RET_STS_WARNING: If facility already exists.
1068: -- iv. WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1069: -- x_error_msg OUT NOCOPY VARCHAR2
1070: -- The error message
1071: -- Version : 1.0
1072: -- Previous version 1.0

Line 1090: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1086:
1087: BEGIN
1088: Init_Debug(l_module_name);
1089:
1090: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1091: g_cache := FALSE;
1092:
1093: --Create an ID table with a single entry and call Create_Facilities
1094: l_location_id_tab(1) := p_location_id;

Line 1107: x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1103: x_error_msg => x_error_msg);
1104:
1105: --Update with the facility code, if it was supplied.
1106: IF (p_facility_code IS NOT NULL AND
1107: x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1108: BEGIN
1109: UPDATE fte_location_parameters
1110: SET facility_code = p_facility_code
1111: WHERE location_id = p_location_id;

Line 1115: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1111: WHERE location_id = p_location_id;
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: x_error_msg := ('UNEXPECTED ERROR AFTER CREATING FACILITY: ' || sqlerrm);
1115: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1116: LogMsg(l_module_name, x_error_msg);
1117: END;
1118: END IF;
1119:

Line 1121: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1117: END;
1118: END IF;
1119:
1120: IF l_debug_on THEN
1121: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1122: WSH_DEBUG_SV.pop(x_Module => l_module_name,
1123: x_Context => 'EXCEPTION:OTHERS');
1124: ELSE
1125: Exit_Debug(l_module_name);

Line 1179: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1175: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'Get_Fac_Info';
1176:
1177: BEGIN
1178: Init_Debug(l_module_name);
1179: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1180:
1181: k := x_fac_info_rows.FIRST;
1182: LOOP
1183: l_location_id := x_fac_info_rows(k).location_id;

Line 1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1228: WHEN OTHERS THEN
1229: x_error_msg := 'UNEXPECTED ERROR WHILE GETTING FACILITY INFO ';
1230: x_error_msg := x_error_msg || 'for location ID ' || l_location_id;
1231: LogMsg(l_module_name, x_error_msg);
1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1233: Exit_Debug(l_module_name);
1234: RETURN;
1235: END;
1236:

Line 1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1300: l_location.POSTAL_CODE := p_postalcode;
1301: l_location.COUNTY := p_county;
1302: l_location.PROVINCE := p_province;
1303:
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1305: x_msg_data := NULL;
1306: WSH_GEOCODING.Get_Lat_Long_and_TimeZone(p_api_version => 1.0,
1307: p_init_msg_list => NULL,
1308: x_return_status => x_return_status,

Line 1319: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1315: x_timezone := l_location.TIMEZONE_CODE;
1316: x_geometry := l_location.GEOMETRY;
1317:
1318: IF (x_return_status IS NULL) THEN
1319: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1320: END IF;
1321:
1322: EXCEPTION
1323: WHEN OTHERS THEN

Line 1326: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: x_error_msg := 'UNEXPECTED ERROR WHILE GETTING LATITUDE, LONGITUDE,TIMEZONE, GEOMETRY INFO ';
1325: LogMsg(l_module_name, x_error_msg);
1326: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1327: Exit_Debug(l_module_name);
1328: RETURN;
1329:
1330: END Get_Fac_Lat_Long_and_TimeZone;