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

Line 60: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN --Bugfix 4070732

56: e_success EXCEPTION;
57:
58: BEGIN
59:
60: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN --Bugfix 4070732
61: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
62: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
63: END IF;
64:

Line 61: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;

57:
58: BEGIN
59:
60: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN --Bugfix 4070732
61: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
62: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
63: END IF;
64:
65: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 62: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;

58: BEGIN
59:
60: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN --Bugfix 4070732
61: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
62: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
63: END IF;
64:
65: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
66: IF l_debug_on IS NULL

Line 106: l_return_status:=wsh_util_core.g_ret_sts_unexp_error;

102:
103: IF l_token_name IS NOT NULL THEN
104: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
105: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_token_name);
106: l_return_status:=wsh_util_core.g_ret_sts_unexp_error;
107: wsh_util_core.add_message(x_return_status,l_module_name);
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --bms should we raise unexpected??
109: END IF;
110:

Line 107: wsh_util_core.add_message(x_return_status,l_module_name);

103: IF l_token_name IS NOT NULL THEN
104: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
105: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_token_name);
106: l_return_status:=wsh_util_core.g_ret_sts_unexp_error;
107: wsh_util_core.add_message(x_return_status,l_module_name);
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --bms should we raise unexpected??
109: END IF;
110:
111: -- IF caller is neither 'OM' or 'PO', raise an exception.

Line 119: l_otm_installed := WSH_UTIL_CORE.Get_Otm_Install_Profile_Value;

115: END IF;
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;
118:
119: l_otm_installed := WSH_UTIL_CORE.Get_Otm_Install_Profile_Value;
120: IF l_otm_installed IN ( 'Y','P')
121: AND NVL(p_action_prms.caller,'PO') <> 'OM'
122: THEN --{
123: RAISE e_success;

Line 127: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

123: RAISE e_success;
124: END IF;
125:
126:
127: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
128:
129: -- Added the condition on caller for Inbound logistics.
130: -- added for testing purpose
131: /*

Line 142: wsh_util_core.fte_is_installed = 'Y' AND

138: -- IF True -> Calls API WSH_bulk_process_pvt.create_delivery_details to create
139: -- new delivery lines.
140: IF p_action_prms.action_code = 'CREATE' OR
141: (p_action_prms.caller like '%PO%' AND
142: wsh_util_core.fte_is_installed = 'Y' AND
143: p_action_prms.action_code in ('APPROVE_PO','FINAL_CLOSE','CANCEL_PO',
144: 'CLOSE_PO','CLOSE_PO_FOR_RECEIVING',
145: 'PURGE_PO','REOPEN_PO')) THEN
146: l_action_prms := p_action_prms;

Line 158: wsh_util_core.fte_is_installed = 'Y' AND

154: --Calls API WSH_IB_TXN_MATCH_PKG.matchTransaction to match the Records
155: --based on Action code.
156: elsif
157: (p_action_prms.caller like '%PO%' AND
158: wsh_util_core.fte_is_installed = 'Y' AND
159: p_action_prms.action_code in
160: (
161: 'ASN',
162: 'CANCEL_ASN',

Line 174: --l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

170: )
171: )
172: THEN
173:
174: --l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
175: --l_action_prms := p_action_prms;
176: WSH_IB_TXN_MATCH_PKG.matchTransaction
177: (
178: p_action_prms => p_action_prms,

Line 190: wsh_util_core.api_post_call(

186: IF l_debug_on THEN
187: wsh_debug_sv.log (l_module_name,'return status from create_delivery_details',l_return_status);
188: END IF;
189:
190: wsh_util_core.api_post_call(
191: p_return_status => l_return_status,
192: x_num_warnings => l_num_warnings,
193: x_num_errors => l_num_errors);
194: IF l_debug_on THEN

Line 201: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

197:
198: IF (l_num_errors > 0 ) THEN
199: RAISE FND_API.G_EXC_ERROR;
200: ELSE
201: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
202: END IF;
203:
204:
205: IF FND_API.To_Boolean( p_commit ) THEN

Line 208: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

204:
205: IF FND_API.To_Boolean( p_commit ) THEN
206:
207: --bug 4070732
208: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
209: --{
210:
211: l_reset_flags := FALSE;
212:

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

210:
211: l_reset_flags := FALSE;
212:
213: IF l_debug_on THEN
214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
215: END IF;
216:
217: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
218: x_return_status => l_return_status);

Line 217: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,

213: IF l_debug_on THEN
214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
215: END IF;
216:
217: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
218: x_return_status => l_return_status);
219:
220: IF l_debug_on THEN
221: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 224: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

220: IF l_debug_on THEN
221: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
222: END IF;
223:
224: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 226: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

222: END IF;
223:
224: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
229: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
230: END IF;

Line 228: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

224: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
229: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
230: END IF;
231:
232: --}

Line 229: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
229: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
230: END IF;
231:
232: --}
233: END IF;

Line 240: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

236: COMMIT WORK;
237: END IF;
238: --
239: --bug 4070732
240: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
241: --{
242: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
243: --{
244:

Line 242: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

238: --
239: --bug 4070732
240: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
241: --{
242: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
243: --{
244:
245: IF FND_API.To_Boolean( p_commit ) THEN
246: IF l_debug_on THEN

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

243: --{
244:
245: IF FND_API.To_Boolean( p_commit ) THEN
246: IF l_debug_on THEN
247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
248: END IF;
249:
250: WSH_UTIL_CORE.reset_stops_for_load_tender(p_reset_flags => TRUE,
251: x_return_status => l_return_status);

Line 250: WSH_UTIL_CORE.reset_stops_for_load_tender(p_reset_flags => TRUE,

246: IF l_debug_on THEN
247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
248: END IF;
249:
250: WSH_UTIL_CORE.reset_stops_for_load_tender(p_reset_flags => TRUE,
251: x_return_status => l_return_status);
252:
253: ELSE
254:

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

252:
253: ELSE
254:
255: IF l_debug_on THEN
256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
257: END IF;
258:
259: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
260: x_return_status => l_return_status);

Line 259: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,

255: IF l_debug_on THEN
256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
257: END IF;
258:
259: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
260: x_return_status => l_return_status);
261: END IF;
262:
263: IF l_debug_on THEN

Line 267: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

263: IF l_debug_on THEN
264: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
265: END IF;
266:
267: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
268: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
269: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
270: x_return_status := l_return_status;
271: END IF;

Line 268: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

264: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
265: END IF;
266:
267: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
268: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
269: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
270: x_return_status := l_return_status;
271: END IF;
272:

Line 269: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

265: END IF;
266:
267: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
268: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
269: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
270: x_return_status := l_return_status;
271: END IF;
272:
273: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

Line 273: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

269: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
270: x_return_status := l_return_status;
271: END IF;
272:
273: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
274: IF NOT FND_API.To_Boolean( p_commit ) THEN
275: ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;
276: END IF;
277: END IF;

Line 302: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

298: END IF;
299: --
300: EXCEPTION
301: WHEN e_success THEN
302: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
303: --
304:
305: /*
306: if any messages are set before this exception is

Line 321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

317: END IF;
318:
319: WHEN FND_API.G_EXC_ERROR THEN
320: --ROLLBACK TO S_CREATE_UPDATE_DETAILS; bms
321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
322: --
323: --
324: -- Start code for Bugfix 4070732
325: --

Line 326: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

322: --
323: --
324: -- Start code for Bugfix 4070732
325: --
326: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
327: --{
328: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
329: --{
330: IF l_debug_on THEN

Line 328: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

324: -- Start code for Bugfix 4070732
325: --
326: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
327: --{
328: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
329: --{
330: IF l_debug_on THEN
331: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
332: END IF;

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

327: --{
328: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
329: --{
330: IF l_debug_on THEN
331: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
332: END IF;
333:
334: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
335: x_return_status => l_return_status);

Line 334: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

330: IF l_debug_on THEN
331: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
332: END IF;
333:
334: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
335: x_return_status => l_return_status);
336:
337:
338: IF l_debug_on THEN

Line 342: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

338: IF l_debug_on THEN
339: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
340: END IF;
341:
342: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
343: x_return_status := l_return_status;
344: END IF;
345: --}
346: END IF;

Line 367: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

363:
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;
367: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
368: --
369: --
370: -- Start code for Bugfix 4070732
371: --

Line 372: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

368: --
369: --
370: -- Start code for Bugfix 4070732
371: --
372: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
373: --{
374: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
375: --{
376: IF l_debug_on THEN

Line 374: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

370: -- Start code for Bugfix 4070732
371: --
372: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
373: --{
374: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
375: --{
376: IF l_debug_on THEN
377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
378: END IF;

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

373: --{
374: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
375: --{
376: IF l_debug_on THEN
377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
378: END IF;
379:
380: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
381: x_return_status => l_return_status);

Line 380: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

376: IF l_debug_on THEN
377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
378: END IF;
379:
380: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
381: x_return_status => l_return_status);
382:
383:
384: IF l_debug_on THEN

Line 388: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

384: IF l_debug_on THEN
385: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
386: END IF;
387:
388: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
389: x_return_status := l_return_status;
390: END IF;
391: --}
392: END IF;

Line 410: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

406: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
407: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
408: END IF;
409:
410: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
411: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
412: --
413: --
414: -- Start code for Bugfix 4070732

Line 411: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

407: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
408: END IF;
409:
410: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
411: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
412: --
413: --
414: -- Start code for Bugfix 4070732
415: --

Line 416: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

412: --
413: --
414: -- Start code for Bugfix 4070732
415: --
416: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
417: --{
418: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
419: --{
420: IF l_debug_on THEN

Line 418: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

414: -- Start code for Bugfix 4070732
415: --
416: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
417: --{
418: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
419: --{
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
422: END IF;

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

417: --{
418: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
419: --{
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
422: END IF;
423:
424: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
425: x_return_status => l_return_status);

Line 424: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,

420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
422: END IF;
423:
424: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
425: x_return_status => l_return_status);
426:
427:
428: IF l_debug_on THEN

Line 432: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

428: IF l_debug_on THEN
429: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
430: END IF;
431:
432: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
433: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
434: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
435: x_return_status := l_return_status;
436: END IF;

Line 433: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

429: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
430: END IF;
431:
432: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
433: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
434: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
435: x_return_status := l_return_status;
436: END IF;
437: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

Line 434: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

430: END IF;
431:
432: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
433: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
434: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
435: x_return_status := l_return_status;
436: END IF;
437: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
438: ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;

Line 437: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

433: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
434: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
435: x_return_status := l_return_status;
436: END IF;
437: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
438: ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;
439: END IF;
440:
441: --}

Line 455: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING '||

451: p_data => x_msg_data,
452: p_encoded => FND_API.G_FALSE
453: );
454: IF l_debug_on THEN
455: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING '||
456: 'exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
458: END IF;
459: --

Line 457: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

453: );
454: IF l_debug_on THEN
455: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING '||
456: 'exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
458: END IF;
459: --
460:
461: WHEN OTHERS THEN

Line 463: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

459: --
460:
461: WHEN OTHERS THEN
462: ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;
463: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
464: wsh_util_core.default_handler('WSH_BULK_PROCESS_GRP.CREATE_UPDATE_DELIVERY_DETAILS');
465: --
466: --
467: -- Start code for Bugfix 4070732

Line 464: wsh_util_core.default_handler('WSH_BULK_PROCESS_GRP.CREATE_UPDATE_DELIVERY_DETAILS');

460:
461: WHEN OTHERS THEN
462: ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;
463: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
464: wsh_util_core.default_handler('WSH_BULK_PROCESS_GRP.CREATE_UPDATE_DELIVERY_DETAILS');
465: --
466: --
467: -- Start code for Bugfix 4070732
468: --

Line 469: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

465: --
466: --
467: -- Start code for Bugfix 4070732
468: --
469: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
470: --{
471: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
472: --{
473: IF l_debug_on THEN

Line 471: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

467: -- Start code for Bugfix 4070732
468: --
469: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
470: --{
471: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
472: --{
473: IF l_debug_on THEN
474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
475: END IF;

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

470: --{
471: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
472: --{
473: IF l_debug_on THEN
474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
475: END IF;
476:
477: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
478: x_return_status => l_return_status);

Line 477: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

473: IF l_debug_on THEN
474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
475: END IF;
476:
477: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
478: x_return_status => l_return_status);
479:
480:
481: IF l_debug_on THEN

Line 485: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

481: IF l_debug_on THEN
482: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
483: END IF;
484:
485: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
486: x_return_status := l_return_status;
487: END IF;
488: --}
489: END IF;