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 159: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

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

Line 162: wsh_util_core.api_post_call(

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

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

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

Line 174: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

Line 176: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

Line 185: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

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

Line 192: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 323: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

Line 331: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 468: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

Line 477: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 534: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

Line 542: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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