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

Line 75: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

71: IF l_debug_on IS NULL THEN
72: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
73: END IF;
74:
75: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
76: x_send_allowed := FALSE;
77:
78: IF l_debug_on THEN
79: WSH_DEBUG_SV.push(l_module_name);

Line 115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

111: x_substitute_entity => l_substitute_entity,
112: x_return_status => l_return_status
113: );
114: IF l_debug_on THEN
115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
116: END IF;
117: --
118: wsh_util_core.api_post_call(
119: p_return_status => l_return_status,

Line 118: wsh_util_core.api_post_call(

114: IF l_debug_on THEN
115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
116: END IF;
117: --
118: wsh_util_core.api_post_call(
119: p_return_status => l_return_status,
120: x_num_warnings => l_num_warnings,
121: x_num_errors => l_num_errors);
122:

Line 132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

128: p_entity_type => p_entity_type,
129: x_return_status => l_return_status
130: );
131: IF l_debug_on THEN
132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
133: END IF;
134: --
135: wsh_util_core.api_post_call(
136: p_return_status => l_return_status,

Line 135: wsh_util_core.api_post_call(

131: IF l_debug_on THEN
132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
133: END IF;
134: --
135: wsh_util_core.api_post_call(
136: p_return_status => l_return_status,
137: x_num_warnings => l_num_warnings,
138: x_num_errors => l_num_errors);
139:

Line 161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

157: p_entity_type => p_entity_type,
158: x_return_status => l_return_status
159: );
160: IF l_debug_on THEN
161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
162: END IF;
163: --
164: wsh_util_core.api_post_call(
165: p_return_status => l_return_status,

Line 164: wsh_util_core.api_post_call(

160: IF l_debug_on THEN
161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
162: END IF;
163: --
164: wsh_util_core.api_post_call(
165: p_return_status => l_return_status,
166: x_num_warnings => l_num_warnings,
167: x_num_errors => l_num_errors);
168:

Line 175: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

171: END IF;
172:
173: x_substitute_entity := l_substitute_entity;
174:
175: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
177: ELSE
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
179: END IF;

Line 176: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

172:
173: x_substitute_entity := l_substitute_entity;
174:
175: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
177: ELSE
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
179: END IF;
180:

Line 178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

174:
175: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
177: ELSE
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
179: END IF;
180:
181: IF l_debug_on THEN
182: WSH_DEBUG_SV.pop(l_module_name);

Line 187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

183: END IF;
184:
185: EXCEPTION
186: WHEN e_entity_type_error THEN
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.logmsg(l_module_name,'wrong entity type passed',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_ENTITY_TYPE');
191: raise;

Line 194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_ENTITY_TYPE');
191: raise;
192: END IF;
193: WHEN OTHERS THEN
194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
198: raise;

Line 325: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

321: FROM wsh_otm_sync_ref_data_log
322: WHERE transmission_id = p_transmission_id;
323: END IF;
324:
325: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
326:
327: IF l_debug_on THEN
328: WSH_DEBUG_SV.pop(l_module_name);
329: END IF;

Line 333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

329: END IF;
330:
331: EXCEPTION
332: WHEN OTHERS THEN
333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
334: IF l_debug_on THEN
335: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
336: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
337: raise;

Line 471: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

467: AND entity_type = p_entity_type;
468: END;
469:
470: x_substitute_entity := l_substitute_entity;
471: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
472:
473: IF l_debug_on THEN
474: WSH_DEBUG_SV.pop(l_module_name);
475: END IF;

Line 480: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

476: COMMIT;
477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
483: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
484: raise;

Line 537: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

533: FND_GLOBAL.USER_ID,
534: FND_GLOBAL.USER_ID
535: );
536:
537: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
538:
539: IF l_debug_on THEN
540: WSH_DEBUG_SV.pop(l_module_name);
541: END IF;

Line 545: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

541: END IF;
542:
543: EXCEPTION
544: WHEN OTHERS THEN
545: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
546: IF l_debug_on THEN
547: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
549: raise;