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_PO_INTEGRATION_GRP dependencies on WSH_DEBUG_SV

Line 73: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

69: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
70: --
71: IF l_debug_on IS NULL
72: THEN
73: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
74: END IF;
75: --
76: --
77: -- Debug Statements

Line 80: WSH_DEBUG_SV.push(l_module_name);

76: --
77: -- Debug Statements
78: --
79: IF l_debug_on THEN
80: WSH_DEBUG_SV.push(l_module_name);
81: --
82: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
83: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
84: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 82: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

78: --
79: IF l_debug_on THEN
80: WSH_DEBUG_SV.push(l_module_name);
81: --
82: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
83: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
84: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
85: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.COUNT',p_in_rec.header_ids.COUNT);
86: END IF;

Line 83: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

79: IF l_debug_on THEN
80: WSH_DEBUG_SV.push(l_module_name);
81: --
82: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
83: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
84: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
85: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.COUNT',p_in_rec.header_ids.COUNT);
86: END IF;
87: --

Line 84: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

80: WSH_DEBUG_SV.push(l_module_name);
81: --
82: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
83: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
84: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
85: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.COUNT',p_in_rec.header_ids.COUNT);
86: END IF;
87: --
88: IF NOT FND_API.compatible_api_call(

Line 85: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.COUNT',p_in_rec.header_ids.COUNT);

81: --
82: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
83: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
84: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
85: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.COUNT',p_in_rec.header_ids.COUNT);
86: END IF;
87: --
88: IF NOT FND_API.compatible_api_call(
89: l_api_version_number,

Line 107: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.CHECK_PENDING_TXNS',WSH_DEBUG_SV.C_PROC_LEVEL);

103: --
104: -- Debug Statements
105: --
106: IF l_debug_on THEN
107: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.CHECK_PENDING_TXNS',WSH_DEBUG_SV.C_PROC_LEVEL);
108: END IF;
109: --
110:
111: -- A function call to determine for checking pending transactions.

Line 139: WSH_DEBUG_SV.pop(l_module_name);

135: --
136: -- Debug Statements
137: --
138: IF l_debug_on THEN
139: WSH_DEBUG_SV.pop(l_module_name);
140: END IF;
141: --
142: EXCEPTION
143: WHEN OTHERS THEN

Line 150: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

146: --
147: -- Debug Statements
148: --
149: IF l_debug_on THEN
150: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
152: END IF;
153: --
154: END check_purge;

Line 151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

147: -- Debug Statements
148: --
149: IF l_debug_on THEN
150: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
152: END IF;
153: --
154: END check_purge;
155:

Line 217: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

213: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
214: --
215: IF l_debug_on IS NULL
216: THEN
217: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
218: END IF;
219: --
220: --
221: -- Debug Statements

Line 224: WSH_DEBUG_SV.push(l_module_name);

220: --
221: -- Debug Statements
222: --
223: IF l_debug_on THEN
224: WSH_DEBUG_SV.push(l_module_name);
225: --
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

222: --
223: IF l_debug_on THEN
224: WSH_DEBUG_SV.push(l_module_name);
225: --
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
229: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.count',p_in_rec.header_ids.count);
230: END IF;

Line 227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

223: IF l_debug_on THEN
224: WSH_DEBUG_SV.push(l_module_name);
225: --
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
229: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.count',p_in_rec.header_ids.count);
230: END IF;
231: --

Line 228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

224: WSH_DEBUG_SV.push(l_module_name);
225: --
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
229: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.count',p_in_rec.header_ids.count);
230: END IF;
231: --
232: SAVEPOINT PURGE_PVT;

Line 229: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.count',p_in_rec.header_ids.count);

225: --
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
229: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.count',p_in_rec.header_ids.count);
230: END IF;
231: --
232: SAVEPOINT PURGE_PVT;
233:

Line 261: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Delivery Details l_detail_tab count : ',l_detail_tab.COUNT);

257: -- Update of wsh_delivery_details where released_status
258: -- are changed, call DBI API after the update.
259: -- This API will also check for DBI Installed or not
260: IF l_debug_on THEN
261: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Delivery Details l_detail_tab count : ',l_detail_tab.COUNT);
262: END IF;
263: WSH_INTEGRATION.DBI_Update_Detail_Log
264: (p_delivery_detail_id_tab => l_detail_tab,
265: p_dml_type => 'UPDATE',

Line 269: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);

265: p_dml_type => 'UPDATE',
266: x_return_status => l_dbi_rs);
267:
268: IF l_debug_on THEN
269: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
270: END IF;
271: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
272: x_return_status := l_dbi_rs;
273: Rollback to PURGE_PVT;

Line 276: WSH_DEBUG_SV.logmsg(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

272: x_return_status := l_dbi_rs;
273: Rollback to PURGE_PVT;
274: -- just pass this return status to caller API
275: IF l_debug_on THEN
276: WSH_DEBUG_SV.logmsg(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
277: WSH_DEBUG_SV.pop(l_module_name);
278: END IF;
279: return;
280: END IF;

Line 277: WSH_DEBUG_SV.pop(l_module_name);

273: Rollback to PURGE_PVT;
274: -- just pass this return status to caller API
275: IF l_debug_on THEN
276: WSH_DEBUG_SV.logmsg(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
277: WSH_DEBUG_SV.pop(l_module_name);
278: END IF;
279: return;
280: END IF;
281: -- End of Code for DBI Project

Line 298: WSH_DEBUG_SV.pop(l_module_name);

294: --
295: -- Debug Statements
296: --
297: IF l_debug_on THEN
298: WSH_DEBUG_SV.pop(l_module_name);
299: END IF;
300: --
301: EXCEPTION
302:

Line 313: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

309: --
310: -- Debug Statements
311: --
312: IF l_debug_on THEN
313: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
314: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
315: END IF;
316: --
317: END purge;

Line 314: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

310: -- Debug Statements
311: --
312: IF l_debug_on THEN
313: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
314: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
315: END IF;
316: --
317: END purge;
318:

Line 353: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

349: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
350: --
351: IF l_debug_on IS NULL
352: THEN
353: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
354: END IF;
355: --
356: IF l_debug_on THEN
357: WSH_DEBUG_SV.push(l_module_name);

Line 357: WSH_DEBUG_SV.push(l_module_name);

353: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
354: END IF;
355: --
356: IF l_debug_on THEN
357: WSH_DEBUG_SV.push(l_module_name);
358: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
359: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
360: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
361: END IF;

Line 358: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

354: END IF;
355: --
356: IF l_debug_on THEN
357: WSH_DEBUG_SV.push(l_module_name);
358: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
359: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
360: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
361: END IF;
362: --

Line 359: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

355: --
356: IF l_debug_on THEN
357: WSH_DEBUG_SV.push(l_module_name);
358: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
359: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
360: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
361: END IF;
362: --
363: IF NOT FND_API.compatible_api_call(

Line 360: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

356: IF l_debug_on THEN
357: WSH_DEBUG_SV.push(l_module_name);
358: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
359: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
360: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
361: END IF;
362: --
363: IF NOT FND_API.compatible_api_call(
364: l_api_version_number,

Line 385: WSH_DEBUG_SV.pop(l_module_name);

381: COMMIT WORK;
382: END IF;
383: --
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.pop(l_module_name);
386: END IF;
387: --
388: EXCEPTION
389: --

Line 396: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

392: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
393: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.VENDOR_MERGE',l_module_name);
394: --
395: IF l_debug_on THEN
396: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
398: END IF;
399: --
400: END vendor_merge;

Line 397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

393: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.VENDOR_MERGE',l_module_name);
394: --
395: IF l_debug_on THEN
396: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
398: END IF;
399: --
400: END vendor_merge;
401:

Line 518: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

514: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
515: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
516: --
517: IF l_debug_on IS NULL THEN
518: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
519: END IF;
520: --
521: IF l_debug_on THEN
522: WSH_DEBUG_SV.push(l_module_name);

Line 522: WSH_DEBUG_SV.push(l_module_name);

518: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
519: END IF;
520: --
521: IF l_debug_on THEN
522: WSH_DEBUG_SV.push(l_module_name);
523: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',P_API_VERSION_NUMBER);
524: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',P_INIT_MSG_LIST);
525: WSH_DEBUG_SV.log(l_module_name,'p_commit',P_COMMIT);
526: WSH_DEBUG_SV.log(l_module_name,'Routing Response Number', p_in_rec.routingRespNum);

Line 523: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',P_API_VERSION_NUMBER);

519: END IF;
520: --
521: IF l_debug_on THEN
522: WSH_DEBUG_SV.push(l_module_name);
523: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',P_API_VERSION_NUMBER);
524: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',P_INIT_MSG_LIST);
525: WSH_DEBUG_SV.log(l_module_name,'p_commit',P_COMMIT);
526: WSH_DEBUG_SV.log(l_module_name,'Routing Response Number', p_in_rec.routingRespNum);
527: END IF;

Line 524: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',P_INIT_MSG_LIST);

520: --
521: IF l_debug_on THEN
522: WSH_DEBUG_SV.push(l_module_name);
523: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',P_API_VERSION_NUMBER);
524: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',P_INIT_MSG_LIST);
525: WSH_DEBUG_SV.log(l_module_name,'p_commit',P_COMMIT);
526: WSH_DEBUG_SV.log(l_module_name,'Routing Response Number', p_in_rec.routingRespNum);
527: END IF;
528: --

Line 525: WSH_DEBUG_SV.log(l_module_name,'p_commit',P_COMMIT);

521: IF l_debug_on THEN
522: WSH_DEBUG_SV.push(l_module_name);
523: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',P_API_VERSION_NUMBER);
524: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',P_INIT_MSG_LIST);
525: WSH_DEBUG_SV.log(l_module_name,'p_commit',P_COMMIT);
526: WSH_DEBUG_SV.log(l_module_name,'Routing Response Number', p_in_rec.routingRespNum);
527: END IF;
528: --
529: IF NOT FND_API.compatible_api_call(

Line 526: WSH_DEBUG_SV.log(l_module_name,'Routing Response Number', p_in_rec.routingRespNum);

522: WSH_DEBUG_SV.push(l_module_name);
523: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',P_API_VERSION_NUMBER);
524: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',P_INIT_MSG_LIST);
525: WSH_DEBUG_SV.log(l_module_name,'p_commit',P_COMMIT);
526: WSH_DEBUG_SV.log(l_module_name,'Routing Response Number', p_in_rec.routingRespNum);
527: END IF;
528: --
529: IF NOT FND_API.compatible_api_call(
530: l_api_version_number,

Line 548: wsh_debug_sv.log(l_module_name, 'Delivery Id', l_deliveryId);

544: FETCH c_GetDelId INTO l_deliveryId, l_ibUpdateDate, l_wndUpdateDate;
545: CLOSE c_GetDelId;
546: --
547: IF l_debug_on THEN
548: wsh_debug_sv.log(l_module_name, 'Delivery Id', l_deliveryId);
549: wsh_debug_sv.log(l_module_name, 'last update date in IB TXN history', l_ibUpdateDate);
550: wsh_debug_sv.log(l_module_name, 'WND Last Update Date', l_wndUpdateDate);
551: END IF;
552: --

Line 549: wsh_debug_sv.log(l_module_name, 'last update date in IB TXN history', l_ibUpdateDate);

545: CLOSE c_GetDelId;
546: --
547: IF l_debug_on THEN
548: wsh_debug_sv.log(l_module_name, 'Delivery Id', l_deliveryId);
549: wsh_debug_sv.log(l_module_name, 'last update date in IB TXN history', l_ibUpdateDate);
550: wsh_debug_sv.log(l_module_name, 'WND Last Update Date', l_wndUpdateDate);
551: END IF;
552: --
553: -- Get last_update_dates of various entities tied to delivery

Line 550: wsh_debug_sv.log(l_module_name, 'WND Last Update Date', l_wndUpdateDate);

546: --
547: IF l_debug_on THEN
548: wsh_debug_sv.log(l_module_name, 'Delivery Id', l_deliveryId);
549: wsh_debug_sv.log(l_module_name, 'last update date in IB TXN history', l_ibUpdateDate);
550: wsh_debug_sv.log(l_module_name, 'WND Last Update Date', l_wndUpdateDate);
551: END IF;
552: --
553: -- Get last_update_dates of various entities tied to delivery
554: --

Line 572: wsh_debug_sv.log(l_module_name, 'WND Update Date', l_wndUpdateDate);

568: FETCH c_GetCarrierLastUpdateDate INTO l_wcsUpdateDate, l_wocsUpdateDate;
569: CLOSE c_GetCarrierLastUpdateDate;
570: --
571: IF l_debug_on THEN
572: wsh_debug_sv.log(l_module_name, 'WND Update Date', l_wndUpdateDate);
573: wsh_debug_sv.log(l_module_name, 'WDA Update Date', l_wdaUpdateDate);
574: wsh_debug_sv.log(l_module_name, 'WDD Update Date', l_wddUpdateDate);
575: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Pickup Stop', l_wtsUpdateDate);
576: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Pickup Stop', l_wdlUpdateDate);

Line 573: wsh_debug_sv.log(l_module_name, 'WDA Update Date', l_wdaUpdateDate);

569: CLOSE c_GetCarrierLastUpdateDate;
570: --
571: IF l_debug_on THEN
572: wsh_debug_sv.log(l_module_name, 'WND Update Date', l_wndUpdateDate);
573: wsh_debug_sv.log(l_module_name, 'WDA Update Date', l_wdaUpdateDate);
574: wsh_debug_sv.log(l_module_name, 'WDD Update Date', l_wddUpdateDate);
575: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Pickup Stop', l_wtsUpdateDate);
576: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Pickup Stop', l_wdlUpdateDate);
577: wsh_debug_sv.log(l_module_name, 'WT Update Date using Pickup Stop', l_wtUpdateDate);

Line 574: wsh_debug_sv.log(l_module_name, 'WDD Update Date', l_wddUpdateDate);

570: --
571: IF l_debug_on THEN
572: wsh_debug_sv.log(l_module_name, 'WND Update Date', l_wndUpdateDate);
573: wsh_debug_sv.log(l_module_name, 'WDA Update Date', l_wdaUpdateDate);
574: wsh_debug_sv.log(l_module_name, 'WDD Update Date', l_wddUpdateDate);
575: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Pickup Stop', l_wtsUpdateDate);
576: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Pickup Stop', l_wdlUpdateDate);
577: wsh_debug_sv.log(l_module_name, 'WT Update Date using Pickup Stop', l_wtUpdateDate);
578: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Dropoff Stop', l_wtsUpdateDate1);

Line 575: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Pickup Stop', l_wtsUpdateDate);

571: IF l_debug_on THEN
572: wsh_debug_sv.log(l_module_name, 'WND Update Date', l_wndUpdateDate);
573: wsh_debug_sv.log(l_module_name, 'WDA Update Date', l_wdaUpdateDate);
574: wsh_debug_sv.log(l_module_name, 'WDD Update Date', l_wddUpdateDate);
575: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Pickup Stop', l_wtsUpdateDate);
576: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Pickup Stop', l_wdlUpdateDate);
577: wsh_debug_sv.log(l_module_name, 'WT Update Date using Pickup Stop', l_wtUpdateDate);
578: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Dropoff Stop', l_wtsUpdateDate1);
579: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Dropoff Stop', l_wdlUpdateDate1);

Line 576: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Pickup Stop', l_wdlUpdateDate);

572: wsh_debug_sv.log(l_module_name, 'WND Update Date', l_wndUpdateDate);
573: wsh_debug_sv.log(l_module_name, 'WDA Update Date', l_wdaUpdateDate);
574: wsh_debug_sv.log(l_module_name, 'WDD Update Date', l_wddUpdateDate);
575: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Pickup Stop', l_wtsUpdateDate);
576: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Pickup Stop', l_wdlUpdateDate);
577: wsh_debug_sv.log(l_module_name, 'WT Update Date using Pickup Stop', l_wtUpdateDate);
578: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Dropoff Stop', l_wtsUpdateDate1);
579: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Dropoff Stop', l_wdlUpdateDate1);
580: wsh_debug_sv.log(l_module_name, 'WT Update Date using Dropoff Stop', l_wtUpdateDate1);

Line 577: wsh_debug_sv.log(l_module_name, 'WT Update Date using Pickup Stop', l_wtUpdateDate);

573: wsh_debug_sv.log(l_module_name, 'WDA Update Date', l_wdaUpdateDate);
574: wsh_debug_sv.log(l_module_name, 'WDD Update Date', l_wddUpdateDate);
575: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Pickup Stop', l_wtsUpdateDate);
576: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Pickup Stop', l_wdlUpdateDate);
577: wsh_debug_sv.log(l_module_name, 'WT Update Date using Pickup Stop', l_wtUpdateDate);
578: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Dropoff Stop', l_wtsUpdateDate1);
579: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Dropoff Stop', l_wdlUpdateDate1);
580: wsh_debug_sv.log(l_module_name, 'WT Update Date using Dropoff Stop', l_wtUpdateDate1);
581: wsh_debug_sv.log(l_module_name, 'WCS Update Date', l_wcsUpdateDate);

Line 578: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Dropoff Stop', l_wtsUpdateDate1);

574: wsh_debug_sv.log(l_module_name, 'WDD Update Date', l_wddUpdateDate);
575: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Pickup Stop', l_wtsUpdateDate);
576: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Pickup Stop', l_wdlUpdateDate);
577: wsh_debug_sv.log(l_module_name, 'WT Update Date using Pickup Stop', l_wtUpdateDate);
578: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Dropoff Stop', l_wtsUpdateDate1);
579: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Dropoff Stop', l_wdlUpdateDate1);
580: wsh_debug_sv.log(l_module_name, 'WT Update Date using Dropoff Stop', l_wtUpdateDate1);
581: wsh_debug_sv.log(l_module_name, 'WCS Update Date', l_wcsUpdateDate);
582: wsh_debug_sv.log(l_module_name, 'WOCS Update Date', l_wocsUpdateDate);

Line 579: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Dropoff Stop', l_wdlUpdateDate1);

575: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Pickup Stop', l_wtsUpdateDate);
576: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Pickup Stop', l_wdlUpdateDate);
577: wsh_debug_sv.log(l_module_name, 'WT Update Date using Pickup Stop', l_wtUpdateDate);
578: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Dropoff Stop', l_wtsUpdateDate1);
579: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Dropoff Stop', l_wdlUpdateDate1);
580: wsh_debug_sv.log(l_module_name, 'WT Update Date using Dropoff Stop', l_wtUpdateDate1);
581: wsh_debug_sv.log(l_module_name, 'WCS Update Date', l_wcsUpdateDate);
582: wsh_debug_sv.log(l_module_name, 'WOCS Update Date', l_wocsUpdateDate);
583: END IF;

Line 580: wsh_debug_sv.log(l_module_name, 'WT Update Date using Dropoff Stop', l_wtUpdateDate1);

576: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Pickup Stop', l_wdlUpdateDate);
577: wsh_debug_sv.log(l_module_name, 'WT Update Date using Pickup Stop', l_wtUpdateDate);
578: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Dropoff Stop', l_wtsUpdateDate1);
579: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Dropoff Stop', l_wdlUpdateDate1);
580: wsh_debug_sv.log(l_module_name, 'WT Update Date using Dropoff Stop', l_wtUpdateDate1);
581: wsh_debug_sv.log(l_module_name, 'WCS Update Date', l_wcsUpdateDate);
582: wsh_debug_sv.log(l_module_name, 'WOCS Update Date', l_wocsUpdateDate);
583: END IF;
584: --

Line 581: wsh_debug_sv.log(l_module_name, 'WCS Update Date', l_wcsUpdateDate);

577: wsh_debug_sv.log(l_module_name, 'WT Update Date using Pickup Stop', l_wtUpdateDate);
578: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Dropoff Stop', l_wtsUpdateDate1);
579: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Dropoff Stop', l_wdlUpdateDate1);
580: wsh_debug_sv.log(l_module_name, 'WT Update Date using Dropoff Stop', l_wtUpdateDate1);
581: wsh_debug_sv.log(l_module_name, 'WCS Update Date', l_wcsUpdateDate);
582: wsh_debug_sv.log(l_module_name, 'WOCS Update Date', l_wocsUpdateDate);
583: END IF;
584: --
585: -- Compare the last_update_dates

Line 582: wsh_debug_sv.log(l_module_name, 'WOCS Update Date', l_wocsUpdateDate);

578: wsh_debug_sv.log(l_module_name, 'WTS Update Date using Dropoff Stop', l_wtsUpdateDate1);
579: wsh_debug_sv.log(l_module_name, 'WDL Update Date using Dropoff Stop', l_wdlUpdateDate1);
580: wsh_debug_sv.log(l_module_name, 'WT Update Date using Dropoff Stop', l_wtUpdateDate1);
581: wsh_debug_sv.log(l_module_name, 'WCS Update Date', l_wcsUpdateDate);
582: wsh_debug_sv.log(l_module_name, 'WOCS Update Date', l_wocsUpdateDate);
583: END IF;
584: --
585: -- Compare the last_update_dates
586: --

Line 609: wsh_debug_sv.log(l_module_name, 'l_changed', l_changed);

605: p_data => x_msg_data,
606: p_encoded => FND_API.G_FALSE);
607: --
608: IF l_debug_on THEN
609: wsh_debug_sv.log(l_module_name, 'l_changed', l_changed);
610: wsh_debug_sv.pop(l_module_name);
611: END IF;
612: --
613: EXCEPTION

Line 610: wsh_debug_sv.pop(l_module_name);

606: p_encoded => FND_API.G_FALSE);
607: --
608: IF l_debug_on THEN
609: wsh_debug_sv.log(l_module_name, 'l_changed', l_changed);
610: wsh_debug_sv.pop(l_module_name);
611: END IF;
612: --
613: EXCEPTION
614: --

Line 627: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);

623: p_encoded => FND_API.G_FALSE
624: );
625: --
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);
628: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
629: END IF;
630: --
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 628: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

624: );
625: --
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);
628: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
629: END IF;
630: --
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: --

Line 643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXP_ERROR',

639: p_encoded => FND_API.G_FALSE
640: );
641: --
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXP_ERROR',
644: WSH_DEBUG_SV.C_EXCEP_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
646: END IF;
647: --

Line 644: WSH_DEBUG_SV.C_EXCEP_LEVEL);

640: );
641: --
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXP_ERROR',
644: WSH_DEBUG_SV.C_EXCEP_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
646: END IF;
647: --
648: WHEN OTHERS THEN

Line 645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

641: --
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXP_ERROR',
644: WSH_DEBUG_SV.C_EXCEP_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
646: END IF;
647: --
648: WHEN OTHERS THEN
649: --

Line 656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '

652: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
653: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.HasDeliveryInfoChanged',l_module_name);
654: --
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '
657: || ' Oracle error message is '
658: || SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
659: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
660: END IF;

Line 658: || SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

654: --
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '
657: || ' Oracle error message is '
658: || SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
659: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
660: END IF;
661: --
662: END HasDeliveryInfoChanged;

Line 659: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '
657: || ' Oracle error message is '
658: || SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
659: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
660: END IF;
661: --
662: END HasDeliveryInfoChanged;
663:

Line 769: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

765: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
766: --
767: IF l_debug_on IS NULL
768: THEN
769: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
770: END IF;
771: --
772: --
773: -- Debug Statements

Line 776: WSH_DEBUG_SV.push(l_module_name);

772: --
773: -- Debug Statements
774: --
775: IF l_debug_on THEN
776: WSH_DEBUG_SV.push(l_module_name);
777: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
778: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
779: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
780: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl.count',p_in_rec.po_line_id_tbl.count);

Line 777: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);

773: -- Debug Statements
774: --
775: IF l_debug_on THEN
776: WSH_DEBUG_SV.push(l_module_name);
777: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
778: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
779: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
780: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl.count',p_in_rec.po_line_id_tbl.count);
781: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl.count',p_in_rec.po_shipment_line_id_tbl.count);

Line 778: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);

774: --
775: IF l_debug_on THEN
776: WSH_DEBUG_SV.push(l_module_name);
777: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
778: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
779: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
780: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl.count',p_in_rec.po_line_id_tbl.count);
781: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl.count',p_in_rec.po_shipment_line_id_tbl.count);
782: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.ship_from_location_id',p_in_rec.ship_from_location_id);

Line 779: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);

775: IF l_debug_on THEN
776: WSH_DEBUG_SV.push(l_module_name);
777: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
778: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
779: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
780: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl.count',p_in_rec.po_line_id_tbl.count);
781: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl.count',p_in_rec.po_shipment_line_id_tbl.count);
782: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.ship_from_location_id',p_in_rec.ship_from_location_id);
783: END IF;

Line 780: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl.count',p_in_rec.po_line_id_tbl.count);

776: WSH_DEBUG_SV.push(l_module_name);
777: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
778: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
779: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
780: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl.count',p_in_rec.po_line_id_tbl.count);
781: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl.count',p_in_rec.po_shipment_line_id_tbl.count);
782: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.ship_from_location_id',p_in_rec.ship_from_location_id);
783: END IF;
784: --

Line 781: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl.count',p_in_rec.po_shipment_line_id_tbl.count);

777: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
778: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
779: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
780: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl.count',p_in_rec.po_line_id_tbl.count);
781: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl.count',p_in_rec.po_shipment_line_id_tbl.count);
782: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.ship_from_location_id',p_in_rec.ship_from_location_id);
783: END IF;
784: --
785: IF NOT FND_API.compatible_api_call(

Line 782: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.ship_from_location_id',p_in_rec.ship_from_location_id);

778: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
779: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
780: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl.count',p_in_rec.po_line_id_tbl.count);
781: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl.count',p_in_rec.po_shipment_line_id_tbl.count);
782: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.ship_from_location_id',p_in_rec.ship_from_location_id);
783: END IF;
784: --
785: IF NOT FND_API.compatible_api_call(
786: l_api_version_number,

Line 802: WSH_DEBUG_SV.logmsg(l_module_name,' Table count of Shipment Line IDs or PO Line IDs are not equal is/are Zero');

798: --
799: IF p_in_rec.po_line_id_tbl.count = 0 or p_in_rec.po_shipment_line_id_tbl.count = 0
800: THEN
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.logmsg(l_module_name,' Table count of Shipment Line IDs or PO Line IDs are not equal is/are Zero');
803: END IF;
804: raise FND_API.G_EXC_ERROR;
805: END IF;
806: --

Line 809: WSH_DEBUG_SV.logmsg(l_module_name,' Table count of Shipment Line IDs and PO Line IDs are not equal');

805: END IF;
806: --
807: IF p_in_rec.po_line_id_tbl.count <> p_in_rec.po_shipment_line_id_tbl.count THEN
808: IF l_debug_on THEN
809: WSH_DEBUG_SV.logmsg(l_module_name,' Table count of Shipment Line IDs and PO Line IDs are not equal');
810: END IF;
811: raise FND_API.G_EXC_ERROR;
812: END IF;
813: --

Line 820: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.ship_from_location_id',p_in_rec.ship_from_location_id);

816: FETCH valid_wsh_sf_loc_csr INTO l_wsh_location_id;
817: CLOSE valid_wsh_sf_loc_csr;
818: --
819: IF l_debug_on THEN
820: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.ship_from_location_id',p_in_rec.ship_from_location_id);
821: WSH_DEBUG_SV.log(l_module_name,'l_wsh_location_id',l_wsh_location_id);
822: END IF;
823: --
824: IF l_wsh_location_id is NULL THEN

Line 821: WSH_DEBUG_SV.log(l_module_name,'l_wsh_location_id',l_wsh_location_id);

817: CLOSE valid_wsh_sf_loc_csr;
818: --
819: IF l_debug_on THEN
820: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.ship_from_location_id',p_in_rec.ship_from_location_id);
821: WSH_DEBUG_SV.log(l_module_name,'l_wsh_location_id',l_wsh_location_id);
822: END IF;
823: --
824: IF l_wsh_location_id is NULL THEN
825: IF l_debug_on THEN

Line 826: WSH_DEBUG_SV.logmsg(l_module_name,' Invalid ShipFromLocation ID from PO');

822: END IF;
823: --
824: IF l_wsh_location_id is NULL THEN
825: IF l_debug_on THEN
826: WSH_DEBUG_SV.logmsg(l_module_name,' Invalid ShipFromLocation ID from PO');
827: END IF;
828: --
829: FND_MESSAGE.SET_NAME('WSH', 'WSH_IB_INVALID_WSH_LOC');
830: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);

Line 838: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl(l_index)',p_in_rec.po_shipment_line_id_tbl(l_index));

834: --
835: l_index := p_in_rec.po_line_id_tbl.FIRST;
836: WHILE l_index is not null LOOP
837: IF l_debug_on THEN
838: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl(l_index)',p_in_rec.po_shipment_line_id_tbl(l_index));
839: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl(l_index)',p_in_rec.po_line_id_tbl(l_index));
840: END IF;
841: --
842: OPEN open_line_with_sf_csr (p_in_rec.po_shipment_line_id_tbl(l_index),

Line 839: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl(l_index)',p_in_rec.po_line_id_tbl(l_index));

835: l_index := p_in_rec.po_line_id_tbl.FIRST;
836: WHILE l_index is not null LOOP
837: IF l_debug_on THEN
838: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl(l_index)',p_in_rec.po_shipment_line_id_tbl(l_index));
839: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_line_id_tbl(l_index)',p_in_rec.po_line_id_tbl(l_index));
840: END IF;
841: --
842: OPEN open_line_with_sf_csr (p_in_rec.po_shipment_line_id_tbl(l_index),
843: p_in_rec.po_line_id_tbl(l_index),

Line 881: WSH_DEBUG_SV.pop(l_module_name);

877: --
878: -- Debug Statements
879: --
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.pop(l_module_name);
882: END IF;
883: --
884:
885: EXCEPTION

Line 899: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);

895: p_encoded => FND_API.G_FALSE
896: );
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);
900: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
901: END IF;
902: --
903: WHEN OTHERS THEN

Line 900: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

896: );
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);
900: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
901: END IF;
902: --
903: WHEN OTHERS THEN
904: --

Line 911: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '

907: --
908: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.validateASNReceiptShipFrom',l_module_name);
909: --
910: IF l_debug_on THEN
911: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '
912: || ' Oracle error message is '
913: || SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
914: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
915: END IF;

Line 913: || SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

909: --
910: IF l_debug_on THEN
911: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '
912: || ' Oracle error message is '
913: || SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
914: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
915: END IF;
916: --
917: END validateASNReceiptShipFrom;

Line 914: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

910: IF l_debug_on THEN
911: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '
912: || ' Oracle error message is '
913: || SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
914: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
915: END IF;
916: --
917: END validateASNReceiptShipFrom;
918: --IB-Phase-2