[Home] [Help]
23: -- The key in key-value pair.
24: -- p_value IN NUMBER
25: -- The value in key-value pair.
26: -- IN OUT:
27: -- x_cachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
28: -- The key-value table where the key value is <= ( 2^31 - 1 )
29: -- x_cacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
30: -- The key-value table where the key value is > ( 2^31 - 1 )
31: -- OUT:
25: -- The value in key-value pair.
26: -- IN OUT:
27: -- x_cachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
28: -- The key-value table where the key value is <= ( 2^31 - 1 )
29: -- x_cacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
30: -- The key-value table where the key value is > ( 2^31 - 1 )
31: -- OUT:
32: -- x_return_status OUT NOCOPY VARCHAR2
33: -- Cache Tables :
52: PROCEDURE addWeightVolume
53: (
54: p_key IN NUMBER,
55: p_value IN NUMBER,
56: x_cachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
57: x_cacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
58: x_return_status OUT NOCOPY VARCHAR2
59: )
60: IS
53: (
54: p_key IN NUMBER,
55: p_value IN NUMBER,
56: x_cachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
57: x_cacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
58: x_return_status OUT NOCOPY VARCHAR2
59: )
60: IS
61: --{
93: --
94: --
95: --
96: IF l_debug_on THEN
97: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_cacheTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
98: END IF;
99: --
100: -- Searching the cache tables to find out, if they already have a entry
101: -- for the given key, if so get the corresponding value.
98: END IF;
99: --
100: -- Searching the cache tables to find out, if they already have a entry
101: -- for the given key, if so get the corresponding value.
102: wsh_util_core.get_cached_value
103: (
104: p_cache_tbl => x_cacheTbl,
105: p_cache_ext_tbl => x_cacheExtTbl,
106: p_key => p_key,
115: WSH_DEBUG_SV.log(l_module_name,'l_value',l_value);
116: END IF;
117: --
118: --
119: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
120: THEN
121: RAISE FND_API.G_EXC_ERROR;
122: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
123: THEN
118: --
119: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
120: THEN
121: RAISE FND_API.G_EXC_ERROR;
122: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
123: THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
126: THEN
121: RAISE FND_API.G_EXC_ERROR;
122: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
123: THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
126: THEN
127: l_value := 0;
128: END IF;
129: --
131: l_value := NVL(l_value,0) + NVL(p_value,0);
132: --
133: --
134: IF l_debug_on THEN
135: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_cacheTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
136: END IF;
137: --
138: wsh_util_core.get_cached_value
139: (
134: IF l_debug_on THEN
135: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_cacheTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
136: END IF;
137: --
138: wsh_util_core.get_cached_value
139: (
140: p_cache_tbl => x_cacheTbl,
141: p_cache_ext_tbl => x_cacheExtTbl,
142: p_key => p_key,
148: --
149: --
150: IF l_debug_on THEN
151: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
153: END IF;
154: --
155: wsh_util_core.api_post_call
156: (
151: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
153: END IF;
154: --
155: wsh_util_core.api_post_call
156: (
157: p_return_status => l_return_status,
158: x_num_warnings => l_num_warnings,
159: x_num_errors => l_num_errors
165: END IF;
166: --
167: IF l_num_errors > 0
168: THEN
169: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
170: ELSIF l_num_warnings > 0
171: THEN
172: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
173: ELSE
168: THEN
169: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
170: ELSIF l_num_warnings > 0
171: THEN
172: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
173: ELSE
174: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
175: END IF;
176: --
170: ELSIF l_num_warnings > 0
171: THEN
172: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
173: ELSE
174: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
175: END IF;
176: --
177: -- Debug Statements
178: --
183: --}
184: EXCEPTION
185: --{
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
188: --
189: -- Debug Statements
190: --
191: IF l_debug_on THEN
193: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
194: END IF;
195: --
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
198: --
199: -- Debug Statements
200: --
201: IF l_debug_on THEN
202: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
203: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
204: END IF;
205: --
206: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
207: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
208: --
209: -- Debug Statements
210: --
203: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
204: END IF;
205: --
206: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
207: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
208: --
209: -- Debug Statements
210: --
211: IF l_debug_on THEN
208: --
209: -- Debug Statements
210: --
211: IF l_debug_on THEN
212: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
214: END IF;
215: --
216: WHEN OTHERS THEN
209: -- Debug Statements
210: --
211: IF l_debug_on THEN
212: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
214: END IF;
215: --
216: WHEN OTHERS THEN
217: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
214: END IF;
215: --
216: WHEN OTHERS THEN
217: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
218: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.addWeightVolume');
219: --
220: -- Debug Statements
221: --
214: END IF;
215: --
216: WHEN OTHERS THEN
217: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
218: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.addWeightVolume');
219: --
220: -- Debug Statements
221: --
222: IF l_debug_on THEN
246: -- The difference in net weight that has happened for the input Delivery's lines.
247: -- p_diff_volume IN NUMBER
248: -- The difference in volume that has happened for the input Delivery's lines .
249: -- IN OUT:
250: -- x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
251: -- The key-value cache table,which contains the gross weight details.
252: -- The key's value is <= ( 2^31 - 1 ).
253: -- x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
254: -- The key-value cache table,which contains the gross weight details.
249: -- IN OUT:
250: -- x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
251: -- The key-value cache table,which contains the gross weight details.
252: -- The key's value is <= ( 2^31 - 1 ).
253: -- x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
254: -- The key-value cache table,which contains the gross weight details.
255: -- The key's value is > ( 2^31 - 1 ).
256: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
257: -- The key-value cache table,which contains the net weight details.
252: -- The key's value is <= ( 2^31 - 1 ).
253: -- x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
254: -- The key-value cache table,which contains the gross weight details.
255: -- The key's value is > ( 2^31 - 1 ).
256: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
257: -- The key-value cache table,which contains the net weight details.
258: -- The key's value is <= ( 2^31 - 1 ).
259: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
260: -- The key-value cache table,which contains the net weight details.
255: -- The key's value is > ( 2^31 - 1 ).
256: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
257: -- The key-value cache table,which contains the net weight details.
258: -- The key's value is <= ( 2^31 - 1 ).
259: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
260: -- The key-value cache table,which contains the net weight details.
261: -- The key's value is > ( 2^31 - 1 ).
262: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
263: -- The key-value cache table,which contains the volume details.
258: -- The key's value is <= ( 2^31 - 1 ).
259: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
260: -- The key-value cache table,which contains the net weight details.
261: -- The key's value is > ( 2^31 - 1 ).
262: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
263: -- The key-value cache table,which contains the volume details.
264: -- The key's value is <= ( 2^31 - 1 ).
265: -- x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
266: -- The key-value cache table,which contains the volume details.
261: -- The key's value is > ( 2^31 - 1 ).
262: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
263: -- The key-value cache table,which contains the volume details.
264: -- The key's value is <= ( 2^31 - 1 ).
265: -- x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
266: -- The key-value cache table,which contains the volume details.
267: -- The key's value is > ( 2^31 - 1 ).
268: -- OUT:
269: --Cache Tables :
292: p_delivery_lpn_id IN NUMBER,
293: p_diff_gross_weight IN NUMBER,
294: p_diff_net_weight IN NUMBER,
295: p_diff_volume IN NUMBER,
296: x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
297: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
298: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
299: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
300: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
293: p_diff_gross_weight IN NUMBER,
294: p_diff_net_weight IN NUMBER,
295: p_diff_volume IN NUMBER,
296: x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
297: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
298: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
299: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
300: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
301: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
294: p_diff_net_weight IN NUMBER,
295: p_diff_volume IN NUMBER,
296: x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
297: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
298: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
299: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
300: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
301: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
302: x_return_status OUT NOCOPY VARCHAR2
295: p_diff_volume IN NUMBER,
296: x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
297: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
298: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
299: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
300: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
301: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
302: x_return_status OUT NOCOPY VARCHAR2
303: )
296: x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
297: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
298: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
299: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
300: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
301: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
302: x_return_status OUT NOCOPY VARCHAR2
303: )
304: IS
297: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
298: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
299: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
300: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
301: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
302: x_return_status OUT NOCOPY VARCHAR2
303: )
304: IS
305: --{
357: --
358: --
359: IF l_debug_on THEN
360: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
361: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
362: END IF;
363: --
364: wsh_util_core.api_post_call
365: (
360: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
361: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
362: END IF;
363: --
364: wsh_util_core.api_post_call
365: (
366: p_return_status => l_return_status,
367: x_num_warnings => l_num_warnings,
368: x_num_errors => l_num_errors
386: --
387: --
388: IF l_debug_on THEN
389: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
390: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
391: END IF;
392: --
393: wsh_util_core.api_post_call
394: (
389: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
390: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
391: END IF;
392: --
393: wsh_util_core.api_post_call
394: (
395: p_return_status => l_return_status,
396: x_num_warnings => l_num_warnings,
397: x_num_errors => l_num_errors
415: --
416: --
417: IF l_debug_on THEN
418: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
419: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
420: END IF;
421: --
422: wsh_util_core.api_post_call
423: (
418: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
419: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
420: END IF;
421: --
422: wsh_util_core.api_post_call
423: (
424: p_return_status => l_return_status,
425: x_num_warnings => l_num_warnings,
426: x_num_errors => l_num_errors
437: END IF;
438: --
439: IF l_num_errors > 0
440: THEN
441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
442: ELSIF l_num_warnings > 0
443: THEN
444: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
445: ELSE
440: THEN
441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
442: ELSIF l_num_warnings > 0
443: THEN
444: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
445: ELSE
446: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
447: END IF;
448: --
442: ELSIF l_num_warnings > 0
443: THEN
444: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
445: ELSE
446: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
447: END IF;
448: --
449: -- Debug Statements
450: --
455: --}
456: EXCEPTION
457: --{
458: WHEN FND_API.G_EXC_ERROR THEN
459: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
460: --
461: -- Debug Statements
462: --
463: IF l_debug_on THEN
465: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
466: END IF;
467: --
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
470: --
471: -- Debug Statements
472: --
473: IF l_debug_on THEN
474: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
475: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
476: END IF;
477: --
478: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
479: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
480: --
481: -- Debug Statements
482: --
475: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
476: END IF;
477: --
478: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
479: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
480: --
481: -- Debug Statements
482: --
483: IF l_debug_on THEN
480: --
481: -- Debug Statements
482: --
483: IF l_debug_on THEN
484: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
485: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
486: END IF;
487: --
488: WHEN OTHERS THEN
481: -- Debug Statements
482: --
483: IF l_debug_on THEN
484: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
485: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
486: END IF;
487: --
488: WHEN OTHERS THEN
489: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
485: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
486: END IF;
487: --
488: WHEN OTHERS THEN
489: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
490: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.processWeightVolume');
491: --
492: -- Debug Statements
493: --
486: END IF;
487: --
488: WHEN OTHERS THEN
489: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
490: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.processWeightVolume');
491: --
492: -- Debug Statements
493: --
494: IF l_debug_on THEN
514: -- IN:
515: -- p_key IN NUMBER
516: -- The key based on which the cache tables are searched for matching entries.
517: -- IN OUT:
518: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
519: -- The key-value cache table having the net weight details for key values < (2^31 -1).
520: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
521: -- The key-value cache table having the net weight details for key values > (2^31 -1).
522: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
516: -- The key based on which the cache tables are searched for matching entries.
517: -- IN OUT:
518: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
519: -- The key-value cache table having the net weight details for key values < (2^31 -1).
520: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
521: -- The key-value cache table having the net weight details for key values > (2^31 -1).
522: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
523: -- The key-value cache table having the volume weight details for key values < (2^31 -1).
524: -- x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
518: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
519: -- The key-value cache table having the net weight details for key values < (2^31 -1).
520: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
521: -- The key-value cache table having the net weight details for key values > (2^31 -1).
522: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
523: -- The key-value cache table having the volume weight details for key values < (2^31 -1).
524: -- x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
525: -- The key-value cache table having the volume weight details for key values > (2^31 -1).
526: -- OUT:
520: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
521: -- The key-value cache table having the net weight details for key values > (2^31 -1).
522: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
523: -- The key-value cache table having the volume weight details for key values < (2^31 -1).
524: -- x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
525: -- The key-value cache table having the volume weight details for key values > (2^31 -1).
526: -- OUT:
527: -- x_return_status OUT NOCOPY VARCHAR2
528: -- Cache Tables:
542:
543: PROCEDURE getNetWeightVolume
544: (
545: p_key IN NUMBER,
546: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
547: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
548: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
549: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
550: x_diff_net_weight OUT NOCOPY NUMBER,
543: PROCEDURE getNetWeightVolume
544: (
545: p_key IN NUMBER,
546: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
547: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
548: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
549: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
550: x_diff_net_weight OUT NOCOPY NUMBER,
551: x_diff_volume OUT NOCOPY NUMBER,
544: (
545: p_key IN NUMBER,
546: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
547: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
548: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
549: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
550: x_diff_net_weight OUT NOCOPY NUMBER,
551: x_diff_volume OUT NOCOPY NUMBER,
552: x_return_status OUT NOCOPY VARCHAR2
545: p_key IN NUMBER,
546: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
547: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
548: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
549: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
550: x_diff_net_weight OUT NOCOPY NUMBER,
551: x_diff_volume OUT NOCOPY NUMBER,
552: x_return_status OUT NOCOPY VARCHAR2
553: )
582: WSH_DEBUG_SV.log(l_module_name,'p_key',p_key);
583: END IF;
584: --
585: IF l_debug_on THEN
586: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_NWTcacheTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
587: END IF;
588: --
589: wsh_util_core.get_cached_value
590: (
585: IF l_debug_on THEN
586: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_NWTcacheTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
587: END IF;
588: --
589: wsh_util_core.get_cached_value
590: (
591: p_cache_tbl => x_NWTcacheTbl,
592: p_cache_ext_tbl => x_NWTcacheExtTbl,
593: p_key => p_key,
602: WSH_DEBUG_SV.log(l_module_name,'x_diff_net_weight',x_diff_net_weight);
603: END IF;
604: --
605: --
606: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
607: THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
610: THEN
605: --
606: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
607: THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
610: THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
613: THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
610: THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
613: THEN
614: x_diff_net_weight := 0;
615: END IF;
616: --
615: END IF;
616: --
617: --
618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_VOLcacheTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
620: END IF;
621: --
622: wsh_util_core.get_cached_value
623: (
618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_VOLcacheTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
620: END IF;
621: --
622: wsh_util_core.get_cached_value
623: (
624: p_cache_tbl => x_VOLcacheTbl,
625: p_cache_ext_tbl => x_VOLcacheExtTbl,
626: p_key => p_key,
635: WSH_DEBUG_SV.log(l_module_name,'x_diff_volume',x_diff_volume);
636: END IF;
637: --
638: --
639: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
640: THEN
641: RAISE FND_API.G_EXC_ERROR;
642: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
643: THEN
638: --
639: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
640: THEN
641: RAISE FND_API.G_EXC_ERROR;
642: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
643: THEN
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
646: THEN
641: RAISE FND_API.G_EXC_ERROR;
642: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
643: THEN
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
646: THEN
647: x_diff_volume := 0;
648: END IF;
649: --
654: END IF;
655: --
656: IF l_num_errors > 0
657: THEN
658: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
659: ELSIF l_num_warnings > 0
660: THEN
661: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
662: ELSE
657: THEN
658: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
659: ELSIF l_num_warnings > 0
660: THEN
661: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
662: ELSE
663: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
664: END IF;
665: --
659: ELSIF l_num_warnings > 0
660: THEN
661: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
662: ELSE
663: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
664: END IF;
665: --
666: -- Debug Statements
667: --
672: --}
673: EXCEPTION
674: --{
675: WHEN FND_API.G_EXC_ERROR THEN
676: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
677: --
678: -- Debug Statements
679: --
680: IF l_debug_on THEN
682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
683: END IF;
684: --
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
687: --
688: -- Debug Statements
689: --
690: IF l_debug_on THEN
691: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
692: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
693: END IF;
694: --
695: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
696: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
697: --
698: -- Debug Statements
699: --
692: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
693: END IF;
694: --
695: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
696: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
697: --
698: -- Debug Statements
699: --
700: IF l_debug_on THEN
697: --
698: -- Debug Statements
699: --
700: IF l_debug_on THEN
701: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
703: END IF;
704: --
705: WHEN OTHERS THEN
698: -- Debug Statements
699: --
700: IF l_debug_on THEN
701: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
703: END IF;
704: --
705: WHEN OTHERS THEN
706: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
703: END IF;
704: --
705: WHEN OTHERS THEN
706: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
707: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.getNetWeightVolume');
708: --
709: -- Debug Statements
710: --
703: END IF;
704: --
705: WHEN OTHERS THEN
706: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
707: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.getNetWeightVolume');
708: --
709: -- Debug Statements
710: --
711: IF l_debug_on THEN
821: END IF;
822: --
823: IF l_num_errors > 0
824: THEN
825: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
826: ELSIF l_num_warnings > 0
827: THEN
828: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
829: ELSE
824: THEN
825: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
826: ELSIF l_num_warnings > 0
827: THEN
828: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
829: ELSE
830: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
831: END IF;
832: --
826: ELSIF l_num_warnings > 0
827: THEN
828: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
829: ELSE
830: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
831: END IF;
832: --
833: -- Debug Statements
834: --
839: --}
840: EXCEPTION
841: --{
842: WHEN FND_API.G_EXC_ERROR THEN
843: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
844: --
845: -- Debug Statements
846: --
847: IF l_debug_on THEN
849: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
850: END IF;
851: --
852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
853: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
854: --
855: -- Debug Statements
856: --
857: IF l_debug_on THEN
858: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
859: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
860: END IF;
861: --
862: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
863: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
864: --
865: -- Debug Statements
866: --
859: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
860: END IF;
861: --
862: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
863: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
864: --
865: -- Debug Statements
866: --
867: IF l_debug_on THEN
864: --
865: -- Debug Statements
866: --
867: IF l_debug_on THEN
868: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
870: END IF;
871: --
872: WHEN OTHERS THEN
865: -- Debug Statements
866: --
867: IF l_debug_on THEN
868: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
870: END IF;
871: --
872: WHEN OTHERS THEN
873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
870: END IF;
871: --
872: WHEN OTHERS THEN
873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
874: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.updateDlvyWeightVolume');
875: --
876: -- Debug Statements
877: --
870: END IF;
871: --
872: WHEN OTHERS THEN
873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
874: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.updateDlvyWeightVolume');
875: --
876: -- Debug Statements
877: --
878: IF l_debug_on THEN
988: END IF;
989: --
990: IF l_num_errors > 0
991: THEN
992: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
993: ELSIF l_num_warnings > 0
994: THEN
995: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
996: ELSE
991: THEN
992: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
993: ELSIF l_num_warnings > 0
994: THEN
995: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
996: ELSE
997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
998: END IF;
999: --
993: ELSIF l_num_warnings > 0
994: THEN
995: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
996: ELSE
997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
998: END IF;
999: --
1000: -- Debug Statements
1001: --
1006: --}
1007: EXCEPTION
1008: --{
1009: WHEN FND_API.G_EXC_ERROR THEN
1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1011: --
1012: -- Debug Statements
1013: --
1014: IF l_debug_on THEN
1016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1017: END IF;
1018: --
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1021: --
1022: -- Debug Statements
1023: --
1024: IF l_debug_on THEN
1025: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1027: END IF;
1028: --
1029: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1030: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1031: --
1032: -- Debug Statements
1033: --
1026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1027: END IF;
1028: --
1029: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1030: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1031: --
1032: -- Debug Statements
1033: --
1034: IF l_debug_on THEN
1031: --
1032: -- Debug Statements
1033: --
1034: IF l_debug_on THEN
1035: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1036: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1037: END IF;
1038: --
1039: WHEN OTHERS THEN
1032: -- Debug Statements
1033: --
1034: IF l_debug_on THEN
1035: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1036: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1037: END IF;
1038: --
1039: WHEN OTHERS THEN
1040: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1036: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1037: END IF;
1038: --
1039: WHEN OTHERS THEN
1040: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1041: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.updateLPNWeightVolume');
1042: --
1043: -- Debug Statements
1044: --
1037: END IF;
1038: --
1039: WHEN OTHERS THEN
1040: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1041: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.updateLPNWeightVolume');
1042: --
1043: -- Debug Statements
1044: --
1045: IF l_debug_on THEN
1062: -- Parameters :
1063: -- IN:
1064: -- p_entity IN VARCHAR2
1065: -- IN OUT:
1066: -- x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1067: -- x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1068: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1069: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1070: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1063: -- IN:
1064: -- p_entity IN VARCHAR2
1065: -- IN OUT:
1066: -- x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1067: -- x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1068: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1069: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1070: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1071: -- x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1064: -- p_entity IN VARCHAR2
1065: -- IN OUT:
1066: -- x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1067: -- x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1068: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1069: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1070: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1071: -- x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1072: -- OUT:
1065: -- IN OUT:
1066: -- x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1067: -- x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1068: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1069: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1070: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1071: -- x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1072: -- OUT:
1073: -- x_return_status OUT NOCOPY VARCHAR2
1066: -- x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1067: -- x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1068: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1069: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1070: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1071: -- x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1072: -- OUT:
1073: -- x_return_status OUT NOCOPY VARCHAR2
1074: -- Version : 1.0
1067: -- x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1068: -- x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1069: -- x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1070: -- x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1071: -- x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1072: -- OUT:
1073: -- x_return_status OUT NOCOPY VARCHAR2
1074: -- Version : 1.0
1075: --Cache Tables:
1091:
1092: PROCEDURE updateWeightVolume
1093: (
1094: p_entity IN VARCHAR2,
1095: x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1096: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1097: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1098: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1099: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1092: PROCEDURE updateWeightVolume
1093: (
1094: p_entity IN VARCHAR2,
1095: x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1096: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1097: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1098: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1099: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1100: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1093: (
1094: p_entity IN VARCHAR2,
1095: x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1096: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1097: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1098: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1099: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1100: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1101: x_return_status OUT NOCOPY VARCHAR2
1094: p_entity IN VARCHAR2,
1095: x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1096: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1097: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1098: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1099: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1100: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1101: x_return_status OUT NOCOPY VARCHAR2
1102: )
1095: x_GWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1096: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1097: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1098: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1099: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1100: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1101: x_return_status OUT NOCOPY VARCHAR2
1102: )
1103: IS
1096: x_GWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1097: x_NWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1098: x_NWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1099: x_VOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1100: x_VOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
1101: x_return_status OUT NOCOPY VARCHAR2
1102: )
1103: IS
1104: --{
1172: );
1173: --
1174: IF l_debug_on THEN
1175: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1176: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1177: END IF;
1178: --
1179: wsh_util_core.api_post_call
1180: (
1175: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1176: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1177: END IF;
1178: --
1179: wsh_util_core.api_post_call
1180: (
1181: p_return_status => l_return_status,
1182: x_num_warnings => l_num_warnings,
1183: x_num_errors => l_num_errors
1228: END IF;
1229: --
1230: IF l_debug_on THEN
1231: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1233: END IF;
1234: --
1235: wsh_util_core.api_post_call
1236: (
1231: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1233: END IF;
1234: --
1235: wsh_util_core.api_post_call
1236: (
1237: p_return_status => l_return_status,
1238: x_num_warnings => l_num_warnings,
1239: x_num_errors => l_num_errors
1281: );
1282: --
1283: IF l_debug_on THEN
1284: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1286: END IF;
1287: --
1288: wsh_util_core.api_post_call
1289: (
1284: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1286: END IF;
1287: --
1288: wsh_util_core.api_post_call
1289: (
1290: p_return_status => l_return_status,
1291: x_num_warnings => l_num_warnings,
1292: x_num_errors => l_num_errors
1337: END IF;
1338: --
1339: IF l_debug_on THEN
1340: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1342: END IF;
1343: --
1344: wsh_util_core.api_post_call
1345: (
1340: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1342: END IF;
1343: --
1344: wsh_util_core.api_post_call
1345: (
1346: p_return_status => l_return_status,
1347: x_num_warnings => l_num_warnings,
1348: x_num_errors => l_num_errors
1363: END IF;
1364: --
1365: IF l_num_errors > 0
1366: THEN
1367: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1368: ELSIF l_num_warnings > 0
1369: THEN
1370: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1371: ELSE
1366: THEN
1367: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1368: ELSIF l_num_warnings > 0
1369: THEN
1370: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1371: ELSE
1372: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1373: END IF;
1374: --
1368: ELSIF l_num_warnings > 0
1369: THEN
1370: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1371: ELSE
1372: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1373: END IF;
1374: --
1375: -- Debug Statements
1376: --
1381: --}
1382: EXCEPTION
1383: --{
1384: WHEN FND_API.G_EXC_ERROR THEN
1385: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1386: --
1387: -- Debug Statements
1388: --
1389: IF l_debug_on THEN
1391: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1392: END IF;
1393: --
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1396: --
1397: -- Debug Statements
1398: --
1399: IF l_debug_on THEN
1400: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1401: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1402: END IF;
1403: --
1404: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1405: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1406: --
1407: -- Debug Statements
1408: --
1401: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1402: END IF;
1403: --
1404: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1405: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1406: --
1407: -- Debug Statements
1408: --
1409: IF l_debug_on THEN
1406: --
1407: -- Debug Statements
1408: --
1409: IF l_debug_on THEN
1410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1412: END IF;
1413: --
1414: WHEN OTHERS THEN
1407: -- Debug Statements
1408: --
1409: IF l_debug_on THEN
1410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1412: END IF;
1413: --
1414: WHEN OTHERS THEN
1415: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1412: END IF;
1413: --
1414: WHEN OTHERS THEN
1415: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1416: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.updateWeightVolume');
1417: --
1418: -- Debug Statements
1419: --
1412: END IF;
1413: --
1414: WHEN OTHERS THEN
1415: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1416: wsh_util_core.default_handler('WSH_ASN_RECEIPT_PVT.updateWeightVolume');
1417: --
1418: -- Debug Statements
1419: --
1420: IF l_debug_on THEN
1627: l_temp_char VARCHAR2(1);
1628:
1629:
1630: --arun's change
1631: l_dd_ids WSH_UTIL_CORE.id_tab_type;
1632:
1633: l_index_dd_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1634: l_index_dd_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1635: l_index_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1629:
1630: --arun's change
1631: l_dd_ids WSH_UTIL_CORE.id_tab_type;
1632:
1633: l_index_dd_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1634: l_index_dd_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1635: l_index_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1636: l_index_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1637:
1630: --arun's change
1631: l_dd_ids WSH_UTIL_CORE.id_tab_type;
1632:
1633: l_index_dd_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1634: l_index_dd_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1635: l_index_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1636: l_index_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1637:
1638: l_uniq_del_ids_tab wsh_util_core.id_tab_type;
1631: l_dd_ids WSH_UTIL_CORE.id_tab_type;
1632:
1633: l_index_dd_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1634: l_index_dd_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1635: l_index_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1636: l_index_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1637:
1638: l_uniq_del_ids_tab wsh_util_core.id_tab_type;
1639:
1632:
1633: l_index_dd_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1634: l_index_dd_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1635: l_index_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1636: l_index_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1637:
1638: l_uniq_del_ids_tab wsh_util_core.id_tab_type;
1639:
1640: l_del_ids_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1634: l_index_dd_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1635: l_index_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1636: l_index_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1637:
1638: l_uniq_del_ids_tab wsh_util_core.id_tab_type;
1639:
1640: l_del_ids_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1641: l_del_ids_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1642:
1636: l_index_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1637:
1638: l_uniq_del_ids_tab wsh_util_core.id_tab_type;
1639:
1640: l_del_ids_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1641: l_del_ids_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1642:
1643: --change for consolidate qty
1644: l_sli_qty_cache WSH_UTIL_CORE.key_value_tab_type;
1637:
1638: l_uniq_del_ids_tab wsh_util_core.id_tab_type;
1639:
1640: l_del_ids_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1641: l_del_ids_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1642:
1643: --change for consolidate qty
1644: l_sli_qty_cache WSH_UTIL_CORE.key_value_tab_type;
1645: l_sli_qty_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1640: l_del_ids_del_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1641: l_del_ids_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1642:
1643: --change for consolidate qty
1644: l_sli_qty_cache WSH_UTIL_CORE.key_value_tab_type;
1645: l_sli_qty_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1646: l_sli_sli_cache WSH_UTIL_CORE.key_value_tab_type;
1647: l_sli_sli_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1648: l_shp_line_id NUMBER;
1641: l_del_ids_del_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1642:
1643: --change for consolidate qty
1644: l_sli_qty_cache WSH_UTIL_CORE.key_value_tab_type;
1645: l_sli_qty_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1646: l_sli_sli_cache WSH_UTIL_CORE.key_value_tab_type;
1647: l_sli_sli_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1648: l_shp_line_id NUMBER;
1649: l_quantity NUMBER;
1642:
1643: --change for consolidate qty
1644: l_sli_qty_cache WSH_UTIL_CORE.key_value_tab_type;
1645: l_sli_qty_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1646: l_sli_sli_cache WSH_UTIL_CORE.key_value_tab_type;
1647: l_sli_sli_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1648: l_shp_line_id NUMBER;
1649: l_quantity NUMBER;
1650: l_src_qty NUMBER;
1643: --change for consolidate qty
1644: l_sli_qty_cache WSH_UTIL_CORE.key_value_tab_type;
1645: l_sli_qty_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1646: l_sli_sli_cache WSH_UTIL_CORE.key_value_tab_type;
1647: l_sli_sli_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1648: l_shp_line_id NUMBER;
1649: l_quantity NUMBER;
1650: l_src_qty NUMBER;
1651: l_src_qty_uom VARCHAR2(3);
1660: --end of arun's change
1661: l_populate_p_line_rec VARCHAR2(1) := 'N';
1662:
1663:
1664: l_del_ids_tab WSH_UTIL_CORE.id_tab_type;
1665: l_del_reprice_tbl WSH_UTIL_CORE.key_value_tab_type;
1666: l_del_reprice_ext_tbl WSH_UTIL_CORE.key_value_tab_type;
1667: j NUMBER;
1668: l_ind NUMBER;
1661: l_populate_p_line_rec VARCHAR2(1) := 'N';
1662:
1663:
1664: l_del_ids_tab WSH_UTIL_CORE.id_tab_type;
1665: l_del_reprice_tbl WSH_UTIL_CORE.key_value_tab_type;
1666: l_del_reprice_ext_tbl WSH_UTIL_CORE.key_value_tab_type;
1667: j NUMBER;
1668: l_ind NUMBER;
1669: -- code copied after finding the diff
1662:
1663:
1664: l_del_ids_tab WSH_UTIL_CORE.id_tab_type;
1665: l_del_reprice_tbl WSH_UTIL_CORE.key_value_tab_type;
1666: l_del_reprice_ext_tbl WSH_UTIL_CORE.key_value_tab_type;
1667: j NUMBER;
1668: l_ind NUMBER;
1669: -- code copied after finding the diff
1670: l_object_version_number NUMBER;
1671:
1672: l_outermost_lpn NUMBER;
1673: l_outermost_lpn_name VARCHAR2(50);
1674:
1675: p_loc_id_index_cache WSH_UTIL_CORE.key_value_tab_type;
1676: p_loc_id_index_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1677: l_value NUMBER;
1678: l_cache_return_status VARCHAR2(1);
1679: l_pline_rec_count NUMBER;
1672: l_outermost_lpn NUMBER;
1673: l_outermost_lpn_name VARCHAR2(50);
1674:
1675: p_loc_id_index_cache WSH_UTIL_CORE.key_value_tab_type;
1676: p_loc_id_index_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1677: l_value NUMBER;
1678: l_cache_return_status VARCHAR2(1);
1679: l_pline_rec_count NUMBER;
1680:
1680:
1681: kk NUMBER;
1682:
1683: --{ --NNP-WV
1684: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1685: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1686: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1687: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1688: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1681: kk NUMBER;
1682:
1683: --{ --NNP-WV
1684: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1685: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1686: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1687: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1688: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1689: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1682:
1683: --{ --NNP-WV
1684: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1685: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1686: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1687: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1688: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1689: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1690: --
1683: --{ --NNP-WV
1684: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1685: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1686: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1687: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1688: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1689: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1690: --
1691: --
1684: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1685: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1686: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1687: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1688: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1689: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1690: --
1691: --
1692: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1685: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1686: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1687: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1688: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1689: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1690: --
1691: --
1692: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1693: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1688: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1689: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1690: --
1691: --
1692: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1693: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1694: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1695: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1696: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1689: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1690: --
1691: --
1692: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1693: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1694: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1695: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1696: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1697: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1690: --
1691: --
1692: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1693: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1694: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1695: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1696: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1697: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1698: --
1691: --
1692: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1693: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1694: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1695: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1696: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1697: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1698: --
1699: --
1692: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1693: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1694: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1695: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1696: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1697: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1698: --
1699: --
1700: l_org_wv_qty NUMBER;
1693: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1694: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
1695: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1696: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
1697: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
1698: --
1699: --
1700: l_org_wv_qty NUMBER;
1701: l_gross_wt_pc NUMBER;
1711: l_diff_dd_net_weight NUMBER;
1712: l_diff_dd_volume NUMBER;
1713: --} --NNP-WV
1714:
1715: l_lpnIdCacheTbl WSH_UTIL_CORE.key_value_tab_type;
1716: l_lpnIdCacheExtTbl WSH_UTIL_CORE.key_value_tab_type;
1717:
1718: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
1719: l_dbi_rs VARCHAR2(1); -- DBI Project
1712: l_diff_dd_volume NUMBER;
1713: --} --NNP-WV
1714:
1715: l_lpnIdCacheTbl WSH_UTIL_CORE.key_value_tab_type;
1716: l_lpnIdCacheExtTbl WSH_UTIL_CORE.key_value_tab_type;
1717:
1718: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
1719: l_dbi_rs VARCHAR2(1); -- DBI Project
1720:
1714:
1715: l_lpnIdCacheTbl WSH_UTIL_CORE.key_value_tab_type;
1716: l_lpnIdCacheExtTbl WSH_UTIL_CORE.key_value_tab_type;
1717:
1718: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
1719: l_dbi_rs VARCHAR2(1); -- DBI Project
1720:
1721: --
1722: l_debug_on BOOLEAN;
1743: WSH_DEBUG_SV.log(l_module_name,'P_MAX_TXN_ID',P_MAX_TXN_ID);
1744: END IF;
1745: --
1746: SAVEPOINT Process_Matched_Txns_PVT;
1747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1748: -- When the API is called from UI, p_line_Rec will not be populated.
1749: -- Need to populate the p_line_rec information in this case.
1750: -- If the API is called from matching algorithm, we have the entire p_line_rec
1751: -- populated.
1805: WSH_DEBUG_SV.log(l_module_name,'p_dd_rec.ship_from_location_id_tab(i)',p_dd_rec.ship_from_location_id_tab(i));
1806: END IF;
1807: --
1808:
1809: l_cache_return_status := wsh_util_core.g_ret_sts_success;
1810:
1811: IF l_populate_p_line_rec = 'Y' THEN
1812: --{
1813: IF l_debug_on THEN
1810:
1811: IF l_populate_p_line_rec = 'Y' THEN
1812: --{
1813: IF l_debug_on THEN
1814: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-p_loc_id_index_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
1815: END IF;
1816: --
1817: IF (p_dd_rec.process_asn_rcv_flag_tab(i) ='Y')
1818: THEN
1816: --
1817: IF (p_dd_rec.process_asn_rcv_flag_tab(i) ='Y')
1818: THEN
1819: --{
1820: wsh_util_core.get_cached_value(
1821: p_cache_tbl => p_loc_id_index_cache,
1822: p_cache_ext_tbl => p_loc_id_index_ext_cache,
1823: p_value => l_value,
1824: p_key => NVL(p_dd_rec.shipment_line_id_tab(i),-99999),
1828: IF l_debug_on THEN
1829: WSH_DEBUG_SV.log(l_module_name,'pointer to p_line_rec',l_value);
1830: END IF;
1831: --
1832: IF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1833: --{
1834: -- rcv_shipment_line_id is present in the cache table.
1835: p_dd_rec.shpmt_line_id_idx_tab(i) := l_value;
1836: ELSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1832: IF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1833: --{
1834: -- rcv_shipment_line_id is present in the cache table.
1835: p_dd_rec.shpmt_line_id_idx_tab(i) := l_value;
1836: ELSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1837: -- Need to derive the po information by calling WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes()
1838: --
1839: -- Debug Statements
1840: --
1850: --
1851: -- Debug Statements
1852: --
1853: IF l_debug_on THEN
1854: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1855: END IF;
1856: --
1857: wsh_util_core.api_post_call(
1858: p_return_status => l_return_status,
1853: IF l_debug_on THEN
1854: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1855: END IF;
1856: --
1857: wsh_util_core.api_post_call(
1858: p_return_status => l_return_status,
1859: x_num_warnings => l_num_warnings,
1860: x_num_errors => l_num_errors);
1861:
1871: THEN
1872: -- populate the shipment_line_id to p_dd_rec structure.
1873: --{
1874: IF l_debug_on THEN
1875: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-p_loc_id_index_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
1876: END IF;
1877: --
1878: wsh_util_core.get_cached_value(
1879: p_cache_tbl => p_loc_id_index_cache,
1874: IF l_debug_on THEN
1875: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-p_loc_id_index_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
1876: END IF;
1877: --
1878: wsh_util_core.get_cached_value(
1879: p_cache_tbl => p_loc_id_index_cache,
1880: p_cache_ext_tbl => p_loc_id_index_ext_cache,
1881: p_value => l_pline_rec_count,
1882: p_key => p_dd_rec.shipment_line_id_tab(i),
1881: p_value => l_pline_rec_count,
1882: p_key => p_dd_rec.shipment_line_id_tab(i),
1883: p_action => 'PUT',
1884: x_return_status => l_cache_return_status);
1885: IF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1886: raise FND_API.G_EXC_ERROR;
1887: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
1888: THEN
1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883: p_action => 'PUT',
1884: x_return_status => l_cache_return_status);
1885: IF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1886: raise FND_API.G_EXC_ERROR;
1887: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
1888: THEN
1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1890: END IF;
1891: --}
1890: END IF;
1891: --}
1892: END IF;
1893:
1894: ElSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1895: raise FND_API.G_EXC_ERROR;
1896: ELSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1897: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1898: END IF;
1892: END IF;
1893:
1894: ElSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1895: raise FND_API.G_EXC_ERROR;
1896: ELSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1897: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1898: END IF;
1899:
1900: --}
2114: --
2115: -- Debug Statements
2116: --
2117: IF l_debug_on THEN
2118: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2119: END IF;
2120: --
2121: wsh_util_core.api_post_call(
2122: p_return_status => l_return_status,
2117: IF l_debug_on THEN
2118: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2119: END IF;
2120: --
2121: wsh_util_core.api_post_call(
2122: p_return_status => l_return_status,
2123: x_num_warnings => l_num_warnings,
2124: x_num_errors => l_num_errors);
2125:
2146: --
2147: -- Debug Statements
2148: --
2149: IF l_debug_on THEN
2150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2151: END IF;
2152: --
2153: wsh_util_core.api_post_call(
2154: p_return_status => l_return_status,
2149: IF l_debug_on THEN
2150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2151: END IF;
2152: --
2153: wsh_util_core.api_post_call(
2154: p_return_status => l_return_status,
2155: x_num_warnings => l_num_warnings,
2156: x_num_errors => l_num_errors);
2157:
2187: --
2188: -- Debug Statements
2189: --
2190: IF l_debug_on THEN
2191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2192: END IF;
2193: --
2194: wsh_util_core.api_post_call(
2195: p_return_status => l_return_status,
2190: IF l_debug_on THEN
2191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2192: END IF;
2193: --
2194: wsh_util_core.api_post_call(
2195: p_return_status => l_return_status,
2196: x_num_warnings => l_num_warnings,
2197: x_num_errors => l_num_errors);
2198:
2240: --
2241: -- Debug Statements
2242: --
2243: IF l_debug_on THEN
2244: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2245: END IF;
2246: --
2247: wsh_util_core.api_post_call(
2248: p_return_status => l_return_status,
2243: IF l_debug_on THEN
2244: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2245: END IF;
2246: --
2247: wsh_util_core.api_post_call(
2248: p_return_status => l_return_status,
2249: x_num_warnings => l_num_warnings,
2250: x_num_errors => l_num_errors);
2251:
2487: IF l_debug_on THEN
2488: WSH_DEBUG_SV.log(l_module_name,'x_delivery_detail_id-new split ddid',x_delivery_detail_id);
2489: WSH_DEBUG_SV.log(l_module_name,'requested qty of record inserted is',p_dd_info.requested_quantity);
2490: WSH_DEBUG_SV.log(l_module_name,'received qty of record inserted is',p_dd_info.received_quantity);
2491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2492: END IF;
2493: --
2494: wsh_util_core.api_post_call(
2495: p_return_status => l_return_status,
2490: WSH_DEBUG_SV.log(l_module_name,'received qty of record inserted is',p_dd_info.received_quantity);
2491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2492: END IF;
2493: --
2494: wsh_util_core.api_post_call(
2495: p_return_status => l_return_status,
2496: x_num_warnings => l_num_warnings,
2497: x_num_errors => l_num_errors);
2498:
2527: --
2528: -- Debug Statements
2529: --
2530: IF l_debug_on THEN
2531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2532: END IF;
2533: --
2534: wsh_util_core.api_post_call(
2535: p_return_status => l_return_status,
2530: IF l_debug_on THEN
2531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2532: END IF;
2533: --
2534: wsh_util_core.api_post_call(
2535: p_return_status => l_return_status,
2536: x_num_warnings => l_num_warnings,
2537: x_num_errors => l_num_errors);
2538:
2600: --
2601: -- Debug Statements
2602: --
2603: IF l_debug_on THEN
2604: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2605: END IF;
2606: --
2607: wsh_util_core.api_post_call(
2608: p_return_status => l_return_status,
2603: IF l_debug_on THEN
2604: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2605: END IF;
2606: --
2607: wsh_util_core.api_post_call(
2608: p_return_status => l_return_status,
2609: x_num_warnings => l_num_warnings,
2610: x_num_errors => l_num_errors);
2611:
2637: --
2638: -- Debug Statements
2639: --
2640: IF l_debug_on THEN
2641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2642: END IF;
2643: --
2644: wsh_util_core.api_post_call(
2645: p_return_status => l_return_status,
2640: IF l_debug_on THEN
2641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2642: END IF;
2643: --
2644: wsh_util_core.api_post_call(
2645: p_return_status => l_return_status,
2646: x_num_warnings => l_num_warnings,
2647: x_num_errors => l_num_errors);
2648:
2687: --
2688: -- Debug Statements
2689: --
2690: IF l_debug_on THEN
2691: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2692: END IF;
2693: --
2694: wsh_util_core.api_post_call(
2695: p_return_status => l_return_status,
2690: IF l_debug_on THEN
2691: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2692: END IF;
2693: --
2694: wsh_util_core.api_post_call(
2695: p_return_status => l_return_status,
2696: x_num_warnings => l_num_warnings,
2697: x_num_errors => l_num_errors);
2698:
2729: --
2730: -- Debug Statements
2731: --
2732: IF l_debug_on THEN
2733: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2734: END IF;
2735: --
2736: wsh_util_core.api_post_call(
2737: p_return_status => l_return_status,
2732: IF l_debug_on THEN
2733: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2734: END IF;
2735: --
2736: wsh_util_core.api_post_call(
2737: p_return_status => l_return_status,
2738: x_num_warnings => l_num_warnings,
2739: x_num_errors => l_num_errors);
2740:
2824: --
2825: -- Debug Statements
2826: --
2827: IF l_debug_on THEN
2828: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2829: END IF;
2830: --
2831: wsh_util_core.api_post_call(
2832: p_return_status => l_return_status,
2827: IF l_debug_on THEN
2828: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2829: END IF;
2830: --
2831: wsh_util_core.api_post_call(
2832: p_return_status => l_return_status,
2833: x_num_warnings => l_num_warnings,
2834: x_num_errors => l_num_errors);
2835: END IF; --For remaining qty1.
2879: );
2880: --
2881: IF l_debug_on THEN
2882: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2883: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2884: END IF;
2885: --
2886: wsh_util_core.api_post_call
2887: (
2882: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2883: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2884: END IF;
2885: --
2886: wsh_util_core.api_post_call
2887: (
2888: p_return_status => l_return_status,
2889: x_num_warnings => l_num_warnings,
2890: x_num_errors => l_num_errors
2916: );
2917: --
2918: IF l_debug_on THEN
2919: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2920: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2921: END IF;
2922: --
2923: wsh_util_core.api_post_call
2924: (
2919: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2920: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2921: END IF;
2922: --
2923: wsh_util_core.api_post_call
2924: (
2925: p_return_status => l_return_status,
2926: x_num_warnings => l_num_warnings,
2927: x_num_errors => l_num_errors
3073: --
3074: -- Debug Statements
3075: --
3076: IF l_debug_on THEN
3077: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3078: END IF;
3079: --
3080: wsh_util_core.api_post_call(
3081: p_return_status => l_return_status,
3076: IF l_debug_on THEN
3077: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3078: END IF;
3079: --
3080: wsh_util_core.api_post_call(
3081: p_return_status => l_return_status,
3082: x_num_warnings => l_num_warnings,
3083: x_num_errors => l_num_errors);
3084:
3104: --
3105: -- Debug Statements
3106: --
3107: IF l_debug_on THEN
3108: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-l_index_dd_ids_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
3109: END IF;
3110: --
3111: wsh_util_core.get_cached_value(
3112: p_cache_tbl => l_index_dd_ids_cache,
3107: IF l_debug_on THEN
3108: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-l_index_dd_ids_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
3109: END IF;
3110: --
3111: wsh_util_core.get_cached_value(
3112: p_cache_tbl => l_index_dd_ids_cache,
3113: p_cache_ext_tbl => l_index_dd_ids_ext_cache,
3114: p_value => l_local_dd_rec(kk).del_detail_id ,
3115: p_key => kk,
3114: p_value => l_local_dd_rec(kk).del_detail_id ,
3115: p_key => kk,
3116: p_action => 'PUT',
3117: x_return_status => l_return_status);
3118: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3119: raise FND_API.G_EXC_ERROR;
3120: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3121: THEN
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: p_action => 'PUT',
3117: x_return_status => l_return_status);
3118: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3119: raise FND_API.G_EXC_ERROR;
3120: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3121: THEN
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: END IF;
3124:
3137: --
3138: -- Debug Statements
3139: --
3140: IF l_debug_on THEN
3141: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-l_index_del_ids_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
3142: END IF;
3143: --
3144: wsh_util_core.get_cached_value(
3145: p_cache_tbl => l_index_del_ids_cache,
3140: IF l_debug_on THEN
3141: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-l_index_del_ids_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
3142: END IF;
3143: --
3144: wsh_util_core.get_cached_value(
3145: p_cache_tbl => l_index_del_ids_cache,
3146: p_cache_ext_tbl => l_index_del_ids_ext_cache,
3147: p_value => l_local_dd_rec(kk).delivery_id,
3148: p_key => kk,
3147: p_value => l_local_dd_rec(kk).delivery_id,
3148: p_key => kk,
3149: p_action => 'PUT',
3150: x_return_status => l_return_status);
3151: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3152: raise FND_API.G_EXC_ERROR;
3153: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3154: THEN
3155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3149: p_action => 'PUT',
3150: x_return_status => l_return_status);
3151: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3152: raise FND_API.G_EXC_ERROR;
3153: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3154: THEN
3155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3156: END IF;
3157:
3160: --
3161: -- Debug Statements
3162: --
3163: IF l_debug_on THEN
3164: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-l_del_ids_del_ids_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
3165: END IF;
3166: --
3167: wsh_util_core.get_cached_value(
3168: p_cache_tbl => l_del_ids_del_ids_cache,
3163: IF l_debug_on THEN
3164: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-l_del_ids_del_ids_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
3165: END IF;
3166: --
3167: wsh_util_core.get_cached_value(
3168: p_cache_tbl => l_del_ids_del_ids_cache,
3169: p_cache_ext_tbl => l_del_ids_del_ids_ext_cache,
3170: p_value => l_local_dd_rec(kk).delivery_id,
3171: p_key => l_local_dd_rec(kk).delivery_id,
3170: p_value => l_local_dd_rec(kk).delivery_id,
3171: p_key => l_local_dd_rec(kk).delivery_id,
3172: p_action => 'PUT',
3173: x_return_status => l_return_status);
3174: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3175: raise FND_API.G_EXC_ERROR;
3176: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3177: THEN
3178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3172: p_action => 'PUT',
3173: x_return_status => l_return_status);
3174: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3175: raise FND_API.G_EXC_ERROR;
3176: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3177: THEN
3178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3179: END IF;
3180: END IF;
3191: --
3192: -- Debug Statements
3193: --
3194: IF l_debug_on THEN
3195: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-l_del_reprice_tbl',WSH_DEBUG_SV.C_PROC_LEVEL);
3196: END IF;
3197: --
3198: wsh_util_core.get_cached_value(
3199: p_cache_tbl => l_del_reprice_tbl,
3194: IF l_debug_on THEN
3195: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-l_del_reprice_tbl',WSH_DEBUG_SV.C_PROC_LEVEL);
3196: END IF;
3197: --
3198: wsh_util_core.get_cached_value(
3199: p_cache_tbl => l_del_reprice_tbl,
3200: p_cache_ext_tbl => l_del_reprice_ext_tbl,
3201: p_value => l_local_dd_rec(kk).delivery_id,
3202: p_key => l_local_dd_rec(kk).delivery_id,
3201: p_value => l_local_dd_rec(kk).delivery_id,
3202: p_key => l_local_dd_rec(kk).delivery_id,
3203: p_action => 'PUT',
3204: x_return_status => l_return_status);
3205: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3206: raise FND_API.G_EXC_ERROR;
3207: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3208: THEN
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3203: p_action => 'PUT',
3204: x_return_status => l_return_status);
3205: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3206: raise FND_API.G_EXC_ERROR;
3207: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3208: THEN
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210: END IF;
3211: END IF;
3249: --
3250: -- Debug Statements
3251: --
3252: IF l_debug_on THEN
3253: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3254: END IF;
3255: --
3256: wsh_util_core.api_post_call(
3257: p_return_status => l_return_status,
3252: IF l_debug_on THEN
3253: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3254: END IF;
3255: --
3256: wsh_util_core.api_post_call(
3257: p_return_status => l_return_status,
3258: x_num_warnings => l_num_warnings,
3259: x_num_errors => l_num_errors);
3260:
3320: WSH_DEBUG_SV.log(l_module_name,'l_update_dd_rec.delivery_detail_id.COUNT',l_update_dd_rec.delivery_detail_id.COUNT);
3321: END IF;
3322:
3323: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
3324: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3325: RAISE FND_API.G_EXC_ERROR;
3326: END IF;
3327: --
3328: -- DBI Project
3339:
3340: IF l_debug_on THEN
3341: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3342: END IF;
3343: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3344: x_return_status := l_dbi_rs;
3345: -- just pass this return status to caller API
3346: IF l_debug_on THEN
3347: WSH_DEBUG_SV.logmsg(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
3370: WSH_DEBUG_SV.log(l_module_name,'l_index',l_index);
3371: END IF;
3372: WHILE l_index IS NOT NULL
3373: LOOP
3374: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3375: --
3376: -- Debug Statements
3377: --
3378: IF l_debug_on THEN
3375: --
3376: -- Debug Statements
3377: --
3378: IF l_debug_on THEN
3379: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE',WSH_DEBUG_SV.C_PROC_LEVEL);
3380: END IF;
3381: --
3382: wsh_util_core.get_cached_value(
3383: p_cache_tbl => l_sli_qty_cache,
3378: IF l_debug_on THEN
3379: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE',WSH_DEBUG_SV.C_PROC_LEVEL);
3380: END IF;
3381: --
3382: wsh_util_core.get_cached_value(
3383: p_cache_tbl => l_sli_qty_cache,
3384: p_cache_ext_tbl => l_sli_qty_ext_cache,
3385: p_value => l_quantity,
3386: p_key => p_line_rec.po_shipment_line_id(l_index),
3391: WSH_DEBUG_SV.log(l_module_name,'p_line_rec.po_shipment_line_id(l_index)',p_line_rec.po_shipment_line_id(l_index));
3392: WSH_DEBUG_SV.log(l_module_name,'sli_qty_cache: l_quantity',l_quantity);
3393: END IF;
3394: --
3395: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3396:
3397: IF l_debug_on THEN
3398: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE',WSH_DEBUG_SV.C_PROC_LEVEL);
3399: END IF;
3394: --
3395: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3396:
3397: IF l_debug_on THEN
3398: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE',WSH_DEBUG_SV.C_PROC_LEVEL);
3399: END IF;
3400: --
3401: wsh_util_core.get_cached_value(
3402: p_cache_tbl => l_sli_sli_cache,
3397: IF l_debug_on THEN
3398: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE',WSH_DEBUG_SV.C_PROC_LEVEL);
3399: END IF;
3400: --
3401: wsh_util_core.get_cached_value(
3402: p_cache_tbl => l_sli_sli_cache,
3403: p_cache_ext_tbl => l_sli_sli_ext_cache,
3404: p_value => l_shp_line_id,
3405: p_key => p_line_rec.po_shipment_line_id(l_index),
3405: p_key => p_line_rec.po_shipment_line_id(l_index),
3406: p_action => 'GET',
3407: x_return_status => l_return_status );
3408:
3409: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3410: p_line_rec.consolidate_quantity(l_index) := 0;
3411:
3412: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3413:
3408:
3409: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3410: p_line_rec.consolidate_quantity(l_index) := 0;
3411:
3412: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3413:
3414: p_line_rec.consolidate_quantity(l_index) := l_quantity;
3415:
3416: IF l_debug_on THEN
3413:
3414: p_line_rec.consolidate_quantity(l_index) := l_quantity;
3415:
3416: IF l_debug_on THEN
3417: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE',WSH_DEBUG_SV.C_PROC_LEVEL);
3418: END IF;
3419: --
3420: wsh_util_core.get_cached_value(
3421: p_cache_tbl => l_sli_sli_cache,
3416: IF l_debug_on THEN
3417: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE',WSH_DEBUG_SV.C_PROC_LEVEL);
3418: END IF;
3419: --
3420: wsh_util_core.get_cached_value(
3421: p_cache_tbl => l_sli_sli_cache,
3422: p_cache_ext_tbl => l_sli_sli_ext_cache,
3423: p_value => p_line_rec.po_shipment_line_id(l_index),
3424: p_key => p_line_rec.po_shipment_line_id(l_index),
3423: p_value => p_line_rec.po_shipment_line_id(l_index),
3424: p_key => p_line_rec.po_shipment_line_id(l_index),
3425: p_action => 'PUT',
3426: x_return_status => l_return_status );
3427: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3428: raise FND_API.G_EXC_ERROR;
3429: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3430: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3431: END IF;
3425: p_action => 'PUT',
3426: x_return_status => l_return_status );
3427: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3428: raise FND_API.G_EXC_ERROR;
3429: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3430: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3431: END IF;
3432: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3433: raise FND_API.G_EXC_ERROR;
3428: raise FND_API.G_EXC_ERROR;
3429: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3430: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3431: END IF;
3432: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3433: raise FND_API.G_EXC_ERROR;
3434: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3435: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3436: END IF;
3430: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3431: END IF;
3432: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3433: raise FND_API.G_EXC_ERROR;
3434: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3435: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3436: END IF;
3437:
3438: OPEN c_src_qty2(p_line_rec.line_id(l_index),p_line_rec.po_shipment_line_id(l_index)); --performance
3452:
3453: l_ratio := l_src_qty2/l_src_qty;
3454: -- HW OPMCONV - No need to use OPM precision. Use current INV which is 5
3455: p_line_rec.requested_quantity2(l_index)
3456: := ROUND(l_ratio*l_quantity,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV); -- RV DEC_QTY
3457: p_line_rec.requested_quantity_uom2(l_index)
3458: := l_src_qty_uom2;
3459:
3460: IF l_debug_on THEN
3495: --
3496: -- Debug Statements
3497: --
3498: IF l_debug_on THEN
3499: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3500: END IF;
3501: --
3502: wsh_util_core.api_post_call(
3503: p_return_status => l_return_status,
3498: IF l_debug_on THEN
3499: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3500: END IF;
3501: --
3502: wsh_util_core.api_post_call(
3503: p_return_status => l_return_status,
3504: x_num_warnings => l_num_warnings,
3505: x_num_errors => l_num_errors);
3506:
3534: --
3535: -- Debug Statements
3536: --
3537: IF l_debug_on THEN
3538: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3539: END IF;
3540: --
3541: wsh_util_core.api_post_call(
3542: p_return_status => l_return_status,
3537: IF l_debug_on THEN
3538: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3539: END IF;
3540: --
3541: wsh_util_core.api_post_call(
3542: p_return_status => l_return_status,
3543: x_num_warnings => l_num_warnings,
3544: x_num_errors => l_num_errors);
3545:
3572: --
3573: -- Debug Statements
3574: --
3575: IF l_debug_on THEN
3576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3577: END IF;
3578: --
3579: wsh_util_core.api_post_call(
3580: p_return_status => l_return_status,
3575: IF l_debug_on THEN
3576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3577: END IF;
3578: --
3579: wsh_util_core.api_post_call(
3580: p_return_status => l_return_status,
3581: x_num_warnings => l_num_warnings,
3582: x_num_errors => l_num_errors);
3583:
3597: p_txn_type => p_dd_rec.transaction_type,
3598: p_object_version_number => l_object_version_number,
3599: x_return_status => l_return_status);
3600:
3601: wsh_util_core.api_post_call(
3602: p_return_status => l_return_status,
3603: x_num_warnings => l_num_warnings,
3604: x_num_errors => l_num_errors);
3605: --}
3670: END IF;
3671: --
3672:
3673: IF l_num_errors > 0 THEN
3674: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3675: ELSIF l_num_warnings > 0 THEN
3676: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3677: END IF;
3678:
3672:
3673: IF l_num_errors > 0 THEN
3674: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3675: ELSIF l_num_warnings > 0 THEN
3676: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3677: END IF;
3678:
3679:
3680: EXCEPTION
3679:
3680: EXCEPTION
3681: WHEN FND_API.G_EXC_ERROR THEN
3682: ROLLBACK TO Process_Matched_Txns_PVT;
3683: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3684: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3685:
3686: --
3687: -- Debug Statements
3680: EXCEPTION
3681: WHEN FND_API.G_EXC_ERROR THEN
3682: ROLLBACK TO Process_Matched_Txns_PVT;
3683: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3684: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3685:
3686: --
3687: -- Debug Statements
3688: --
3693: --
3694: WHEN OTHERS THEN
3695: ROLLBACK TO Process_Matched_Txns_PVT;
3696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3697: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_ASN_RECEIPT_PVT.Process_Matched_Txns',l_module_name);
3698:
3699:
3700: --
3701: -- Debug Statements
3792:
3793: l_line_rec OE_WSH_BULK_GRP.line_rec_type;
3794: l_max_txn_id NUMBER;
3795: l_dd_list WSH_PO_CMG_PVT.dd_list_type;
3796: l_Stop_ids wsh_util_core.Id_Tab_Type;
3797: l_Trip_ids wsh_util_core.Id_Tab_Type;
3798: l_Delivery_ids wsh_util_core.Id_Tab_Type;
3799: l_sf_locn_id_tbl wsh_util_core.Id_Tab_Type;
3800: l_picked_qty_tbl wsh_util_core.Id_Tab_Type;
3793: l_line_rec OE_WSH_BULK_GRP.line_rec_type;
3794: l_max_txn_id NUMBER;
3795: l_dd_list WSH_PO_CMG_PVT.dd_list_type;
3796: l_Stop_ids wsh_util_core.Id_Tab_Type;
3797: l_Trip_ids wsh_util_core.Id_Tab_Type;
3798: l_Delivery_ids wsh_util_core.Id_Tab_Type;
3799: l_sf_locn_id_tbl wsh_util_core.Id_Tab_Type;
3800: l_picked_qty_tbl wsh_util_core.Id_Tab_Type;
3801: l_validate_flag VARCHAR2(1) := 'Y';
3794: l_max_txn_id NUMBER;
3795: l_dd_list WSH_PO_CMG_PVT.dd_list_type;
3796: l_Stop_ids wsh_util_core.Id_Tab_Type;
3797: l_Trip_ids wsh_util_core.Id_Tab_Type;
3798: l_Delivery_ids wsh_util_core.Id_Tab_Type;
3799: l_sf_locn_id_tbl wsh_util_core.Id_Tab_Type;
3800: l_picked_qty_tbl wsh_util_core.Id_Tab_Type;
3801: l_validate_flag VARCHAR2(1) := 'Y';
3802: l_return_status VARCHAR2(1);
3795: l_dd_list WSH_PO_CMG_PVT.dd_list_type;
3796: l_Stop_ids wsh_util_core.Id_Tab_Type;
3797: l_Trip_ids wsh_util_core.Id_Tab_Type;
3798: l_Delivery_ids wsh_util_core.Id_Tab_Type;
3799: l_sf_locn_id_tbl wsh_util_core.Id_Tab_Type;
3800: l_picked_qty_tbl wsh_util_core.Id_Tab_Type;
3801: l_validate_flag VARCHAR2(1) := 'Y';
3802: l_return_status VARCHAR2(1);
3803: l_dd_list_count NUMBER;
3796: l_Stop_ids wsh_util_core.Id_Tab_Type;
3797: l_Trip_ids wsh_util_core.Id_Tab_Type;
3798: l_Delivery_ids wsh_util_core.Id_Tab_Type;
3799: l_sf_locn_id_tbl wsh_util_core.Id_Tab_Type;
3800: l_picked_qty_tbl wsh_util_core.Id_Tab_Type;
3801: l_validate_flag VARCHAR2(1) := 'Y';
3802: l_return_status VARCHAR2(1);
3803: l_dd_list_count NUMBER;
3804:
3805: l_num_warnings NUMBER := 0;
3806: l_num_errors NUMBER := 0;
3807: l_object_version_number NUMBER;
3808: --changes made by arun
3809: l_initial_pickup_date_tab wsh_util_core.Date_Tab_Type;
3810: l_expected_receipt_date_tab wsh_util_core.Date_Tab_Type;
3811: l_rcv_carrier_id_tab wsh_util_core.Id_Tab_Type;
3812: l_gross_weight_of_first NUMBER;
3813: l_net_weight_of_first NUMBER;
3806: l_num_errors NUMBER := 0;
3807: l_object_version_number NUMBER;
3808: --changes made by arun
3809: l_initial_pickup_date_tab wsh_util_core.Date_Tab_Type;
3810: l_expected_receipt_date_tab wsh_util_core.Date_Tab_Type;
3811: l_rcv_carrier_id_tab wsh_util_core.Id_Tab_Type;
3812: l_gross_weight_of_first NUMBER;
3813: l_net_weight_of_first NUMBER;
3814: l_shipment_header_id_tab wsh_util_core.id_Tab_Type;
3807: l_object_version_number NUMBER;
3808: --changes made by arun
3809: l_initial_pickup_date_tab wsh_util_core.Date_Tab_Type;
3810: l_expected_receipt_date_tab wsh_util_core.Date_Tab_Type;
3811: l_rcv_carrier_id_tab wsh_util_core.Id_Tab_Type;
3812: l_gross_weight_of_first NUMBER;
3813: l_net_weight_of_first NUMBER;
3814: l_shipment_header_id_tab wsh_util_core.id_Tab_Type;
3815:
3810: l_expected_receipt_date_tab wsh_util_core.Date_Tab_Type;
3811: l_rcv_carrier_id_tab wsh_util_core.Id_Tab_Type;
3812: l_gross_weight_of_first NUMBER;
3813: l_net_weight_of_first NUMBER;
3814: l_shipment_header_id_tab wsh_util_core.id_Tab_Type;
3815:
3816:
3817: l_dd_unassigned_tbl wsh_util_core.Id_Tab_Type;
3818: l_wdd_tbl wsh_util_core.Id_Tab_Type;
3813: l_net_weight_of_first NUMBER;
3814: l_shipment_header_id_tab wsh_util_core.id_Tab_Type;
3815:
3816:
3817: l_dd_unassigned_tbl wsh_util_core.Id_Tab_Type;
3818: l_wdd_tbl wsh_util_core.Id_Tab_Type;
3819:
3820: --changes made by arun
3821: l_action_prms WSH_BULK_TYPES_GRP.action_parameters_rectype;
3814: l_shipment_header_id_tab wsh_util_core.id_Tab_Type;
3815:
3816:
3817: l_dd_unassigned_tbl wsh_util_core.Id_Tab_Type;
3818: l_wdd_tbl wsh_util_core.Id_Tab_Type;
3819:
3820: --changes made by arun
3821: l_action_prms WSH_BULK_TYPES_GRP.action_parameters_rectype;
3822: l_status VARCHAR2(50);
3824: l_local_ddrec LOCAL_DD_REC_TABLE_TYPE;
3825:
3826: l_unassign_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
3827: --
3828: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3829: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3830: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3831: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3832: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3825:
3826: l_unassign_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
3827: --
3828: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3829: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3830: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3831: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3832: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3833: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3826: l_unassign_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
3827: --
3828: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3829: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3830: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3831: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3832: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3833: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3834: --
3827: --
3828: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3829: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3830: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3831: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3832: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3833: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3834: --
3835: --
3828: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3829: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3830: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3831: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3832: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3833: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3834: --
3835: --
3836: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3829: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3830: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3831: l_lpnNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3832: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3833: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3834: --
3835: --
3836: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3837: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3832: l_lpnVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3833: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3834: --
3835: --
3836: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3837: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3838: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3839: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3840: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3833: l_lpnVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3834: --
3835: --
3836: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3837: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3838: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3839: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3840: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3841: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3834: --
3835: --
3836: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3837: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3838: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3839: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3840: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3841: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3842:
3835: --
3836: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3837: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3838: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3839: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3840: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3841: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3842:
3843: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
3836: l_dlvyGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3837: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3838: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3839: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3840: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3841: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3842:
3843: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
3844: l_dbi_rs VARCHAR2(1); -- DBI Project
3837: l_dlvyGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3838: l_dlvyNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3839: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3840: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3841: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3842:
3843: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
3844: l_dbi_rs VARCHAR2(1); -- DBI Project
3845:
3839: l_dlvyNWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3840: l_dlvyVOLcachetbl WSH_UTIL_CORE.key_value_tab_type;
3841: l_dlvyVOLcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3842:
3843: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
3844: l_dbi_rs VARCHAR2(1); -- DBI Project
3845:
3846: --
3847: l_debug_on BOOLEAN;
3868: END IF;
3869: --
3870: SAVEPOINT Cancel_ASN_PVT;
3871:
3872: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3873:
3874: IF l_debug_on THEN
3875: WSH_DEBUG_SV.logmsg(l_module_name,'updating WDD');
3876: END IF;
3916: x_return_status => l_dbi_rs);
3917: IF l_debug_on THEN
3918: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3919: END IF;
3920: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3921: x_return_status := l_dbi_rs;
3922: rollback to Cancel_ASN_PVT;
3923: -- just pass this return status to caller API
3924: IF l_debug_on THEN
3951: --
3952: -- Debug Statements
3953: --
3954: IF l_debug_on THEN
3955: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3956: END IF;
3957: --
3958: wsh_util_core.api_post_call(
3959: p_return_status => l_return_status,
3954: IF l_debug_on THEN
3955: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3956: END IF;
3957: --
3958: wsh_util_core.api_post_call(
3959: p_return_status => l_return_status,
3960: x_num_warnings => l_num_warnings,
3961: x_num_errors => l_num_errors);
3962:
3981: --
3982: -- Debug Statements
3983: --
3984: IF l_debug_on THEN
3985: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3986: END IF;
3987: --
3988: wsh_util_core.api_post_call(
3989: p_return_status => l_return_status,
3984: IF l_debug_on THEN
3985: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3986: END IF;
3987: --
3988: wsh_util_core.api_post_call(
3989: p_return_status => l_return_status,
3990: x_num_warnings => l_num_warnings,
3991: x_num_errors => l_num_errors);
3992:
4013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4014: END IF;
4015:
4016: l_unassign_action_prms := p_action_prms;
4017: --l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
4018: l_unassign_action_prms.caller := wsh_util_core.C_IB_ASN_PREFIX;
4019:
4020: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(
4021: p_rec_of_detail_ids => l_dd_unassigned_tbl,
4014: END IF;
4015:
4016: l_unassign_action_prms := p_action_prms;
4017: --l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
4018: l_unassign_action_prms.caller := wsh_util_core.C_IB_ASN_PREFIX;
4019:
4020: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(
4021: p_rec_of_detail_ids => l_dd_unassigned_tbl,
4022: p_from_delivery => 'Y',
4024: x_return_status => l_return_status,
4025: p_validate_flag => 'Y',
4026: p_action_prms => l_unassign_action_prms);
4027:
4028: wsh_util_core.api_post_call(
4029: p_return_status => l_return_status,
4030: x_num_warnings => l_num_warnings,
4031: x_num_errors => l_num_errors);
4032:
4067: --
4068: -- Debug Statements
4069: --
4070: IF l_debug_on THEN
4071: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4072: END IF;
4073: --
4074: wsh_util_core.api_post_call(
4075: p_return_status => l_return_status,
4070: IF l_debug_on THEN
4071: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4072: END IF;
4073: --
4074: wsh_util_core.api_post_call(
4075: p_return_status => l_return_status,
4076: x_num_warnings => l_num_warnings,
4077: x_num_errors => l_num_errors);
4078:
4090: p_action_code => 'CANCEL',
4091: p_delivery_id_tab => l_delivery_ids,
4092: x_return_status => l_return_status);
4093:
4094: wsh_util_core.api_post_call(
4095: p_return_status => l_return_status,
4096: x_num_warnings => l_num_warnings,
4097: x_num_errors => l_num_errors);
4098:
4101: p_entity_type => 'DELIVERY',
4102: p_entity_ids => l_delivery_ids,
4103: x_return_status => l_return_status);
4104:
4105: wsh_util_core.api_post_call(
4106: p_return_status => l_return_status,
4107: x_num_warnings => l_num_warnings,
4108: x_num_errors => l_num_errors);
4109:
4118: p_override_flag => 'Y',
4119: p_calc_wv_if_frozen => 'N',
4120: x_return_status => l_return_status);
4121:
4122: wsh_util_core.api_post_call(
4123: p_return_status => l_return_status,
4124: x_num_warnings => l_num_warnings,
4125: x_num_errors => l_num_errors);
4126: --
4134: IF l_debug_on THEN
4135: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling calculate_cont_del_tpdates',l_return_status);
4136: END IF;
4137: --
4138: wsh_util_core.api_post_call(
4139: p_return_status => l_return_status,
4140: x_num_warnings => l_num_warnings,
4141: x_num_errors => l_num_errors);
4142:
4172: --
4173: -- Debug Statements
4174: --
4175: IF l_debug_on THEN
4176: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4177: END IF;
4178: --
4179: wsh_util_core.api_post_call(
4180: p_return_status => l_return_status,
4175: IF l_debug_on THEN
4176: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4177: END IF;
4178: --
4179: wsh_util_core.api_post_call(
4180: p_return_status => l_return_status,
4181: x_num_warnings => l_num_warnings,
4182: x_num_errors => l_num_errors);
4183: */
4188: WSH_DEBUG_SV.pop(l_module_name);
4189: END IF;
4190: --
4191: IF l_num_errors > 0 THEN
4192: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4193: ELSIF l_num_warnings > 0 THEN
4194: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4195: END IF;
4196:
4190: --
4191: IF l_num_errors > 0 THEN
4192: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4193: ELSIF l_num_warnings > 0 THEN
4194: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4195: END IF;
4196:
4197:
4198: EXCEPTION
4197:
4198: EXCEPTION
4199: WHEN FND_API.G_EXC_ERROR THEN
4200: ROLLBACK TO Cancel_ASN_PVT;
4201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4202: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4203:
4204: --
4205: -- Debug Statements
4198: EXCEPTION
4199: WHEN FND_API.G_EXC_ERROR THEN
4200: ROLLBACK TO Cancel_ASN_PVT;
4201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4202: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4203:
4204: --
4205: -- Debug Statements
4206: --
4211: --
4212: WHEN OTHERS THEN
4213: ROLLBACK TO Cancel_ASN_PVT;
4214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4215: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_ASN_RECEIPT_PVT.Cancel_ASN');
4216:
4217: --
4218: -- Debug Statements
4219: --
4233: -- deliveries (i/p parameter p_del_ids) and unassigns them from their
4234: -- respective deliveries.
4235: -- Parameters :
4236: -- IN:
4237: -- p_del_ids IN wsh_util_core.id_tab_type
4238: -- A table containing the list of delivery IDs for which the action
4239: -- should be carried out.
4240: -- p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
4241: -- contains the action code ,the caller ,the transaction type etc.
4247: -- Initial version 1.0
4248: -- End of comments
4249:
4250: PROCEDURE unassign_open_det_from_del(
4251: p_del_ids IN wsh_util_core.id_tab_type,
4252: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
4253: p_shipment_header_id IN NUMBER,
4254: x_return_status OUT NOCOPY VARCHAR2 ) IS
4255:
4303:
4304:
4305:
4306:
4307: lpn_ids_tab WSH_UTIL_CORE.ID_TAB_TYPE;
4308: dd_ids_tab WSH_UTIL_CORE.ID_TAB_TYPE;
4309: l_dd_id NUMBER;
4310: l_delivery_flag VARCHAR2(1) := 'Y';
4311: l_return_status VARCHAR2(1);
4304:
4305:
4306:
4307: lpn_ids_tab WSH_UTIL_CORE.ID_TAB_TYPE;
4308: dd_ids_tab WSH_UTIL_CORE.ID_TAB_TYPE;
4309: l_dd_id NUMBER;
4310: l_delivery_flag VARCHAR2(1) := 'Y';
4311: l_return_status VARCHAR2(1);
4312: l_num_warnings NUMBER := 0;
4340: WSH_DEBUG_SV.log(l_module_name,'p_del_ids.count',p_del_ids.count);
4341: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id',p_shipment_header_id);
4342: END IF;
4343: --
4344: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4345:
4346: i := p_del_ids.FIRST;
4347: WHILE i IS NOT NULL
4348: LOOP
4468: _ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4469: END IF;
4470:
4471: l_unassign_action_prms := p_action_prms;
4472: --l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
4473: l_unassign_action_prms.caller := wsh_util_core.C_IB_ASN_PREFIX;
4474:
4475: --Call API WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details.
4476: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(
4469: END IF;
4470:
4471: l_unassign_action_prms := p_action_prms;
4472: --l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
4473: l_unassign_action_prms.caller := wsh_util_core.C_IB_ASN_PREFIX;
4474:
4475: --Call API WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details.
4476: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(
4477: P_REC_OF_DETAIL_IDS => dd_ids_tab,
4484: --
4485: -- Debug Statements
4486: --
4487: IF l_debug_on THEN
4488: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4489: END IF;
4490: --
4491: wsh_util_core.api_post_call(
4492: p_return_status => l_return_status,
4487: IF l_debug_on THEN
4488: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4489: END IF;
4490: --
4491: wsh_util_core.api_post_call(
4492: p_return_status => l_return_status,
4493: x_num_warnings => l_num_warnings,
4494: x_num_errors => l_num_errors);
4495:
4513: --
4514: -- Debug Statements
4515: --
4516: IF l_debug_on THEN
4517: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4518: END IF;
4519: --
4520: wsh_util_core.api_post_call(
4521: p_return_status => l_return_status,
4516: IF l_debug_on THEN
4517: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4518: END IF;
4519: --
4520: wsh_util_core.api_post_call(
4521: p_return_status => l_return_status,
4522: x_num_warnings => l_num_warnings,
4523: x_num_errors => l_num_errors);
4524:
4537: WSH_DEBUG_SV.pop(l_module_name);
4538: END IF;
4539: --
4540: IF l_num_errors > 0 THEN
4541: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4542: ELSIF l_num_warnings > 0 THEN
4543: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4544: END IF;
4545:
4539: --
4540: IF l_num_errors > 0 THEN
4541: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4542: ELSIF l_num_warnings > 0 THEN
4543: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4544: END IF;
4545:
4546: EXCEPTION
4547: WHEN OTHERS THEN
4544: END IF;
4545:
4546: EXCEPTION
4547: WHEN OTHERS THEN
4548: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4549: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.UNASSIGN_OPEN_DET_FROM_DEL');
4550:
4551: --
4552: -- Debug Statements
4545:
4546: EXCEPTION
4547: WHEN OTHERS THEN
4548: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4549: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.UNASSIGN_OPEN_DET_FROM_DEL');
4550:
4551: --
4552: -- Debug Statements
4553: --
4581: -- Parameters :
4582: -- IN:
4583: -- IN OUT:
4584: -- p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE
4585: -- p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
4586: -- A key-value pair cache with the value as the delivery detail id and key
4587: -- as the index of the corresponding record in p_local_dd_rec.This contains
4588: -- those delivery detail ids for which both a delivery and a trip has to
4589: -- be created.The index is useful for populating the correct record in
4587: -- as the index of the corresponding record in p_local_dd_rec.This contains
4588: -- those delivery detail ids for which both a delivery and a trip has to
4589: -- be created.The index is useful for populating the correct record in
4590: -- p_local_dd_rec, once the delivery and trip are created.
4591: -- p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
4592: -- A key-value pair cache with the value as the delivery detail id and key
4593: -- as the index of the corresponding record in p_local_dd_rec.This contains
4594: -- those delivery detail ids for which both a delivery and a trip has to
4595: -- be created.Records are stored in this cache if the key exceeds 2^31.
4594: -- those delivery detail ids for which both a delivery and a trip has to
4595: -- be created.Records are stored in this cache if the key exceeds 2^31.
4596: -- The index is useful for populating the correct record in p_local_dd_rec,
4597: -- once the delivery and trip are created.
4598: -- p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
4599: -- A key-value pair cache with the value as the delivery id and key
4600: -- as the index of the corresponding record in p_local_dd_rec.This contains
4601: -- those delivery ids for which a trip has to be created.
4602: -- The index is useful for populating the correct record in p_local_dd_rec,
4600: -- as the index of the corresponding record in p_local_dd_rec.This contains
4601: -- those delivery ids for which a trip has to be created.
4602: -- The index is useful for populating the correct record in p_local_dd_rec,
4603: -- once the delivery and trip are created.
4604: -- p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
4605: -- A key-value pair cache with the value as the delivery id and key
4606: -- as the index of the corresponding record in p_local_dd_rec.This contains
4607: -- those delivery ids for which a trip has to be created.Records are
4608: -- stored in this cache if the key exceeds 2^31.
4607: -- those delivery ids for which a trip has to be created.Records are
4608: -- stored in this cache if the key exceeds 2^31.
4609: -- The index is useful for populating the correct record in p_local_dd_rec,
4610: -- once the trip is created.
4611: -- p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
4612: -- A key-value pair cache with the value as the delivery id and key
4613: -- as delivery id of the corresponding record in p_local_dd_rec.This contains
4614: -- those delivery ids for which a trip has to be created.This cache is just used
4615: -- for maintaining non-duplicate delivery ids and not used for mapping purpose
4613: -- as delivery id of the corresponding record in p_local_dd_rec.This contains
4614: -- those delivery ids for which a trip has to be created.This cache is just used
4615: -- for maintaining non-duplicate delivery ids and not used for mapping purpose
4616: -- like the previous cache tables viz..p_index_del_ids_cache and p_index_del_ids_ext_cache.
4617: -- p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
4618: -- A key-value pair cache with the value as the delivery id and key
4619: -- as delivery id of the corresponding record in p_local_dd_rec.This contains
4620: -- those delivery ids for which a trip has to be created.This cache is just used
4621: -- for maintaining non-duplicate delivery ids and not used for mapping purpose
4620: -- those delivery ids for which a trip has to be created.This cache is just used
4621: -- for maintaining non-duplicate delivery ids and not used for mapping purpose
4622: -- like the previous cache tables viz..p_index_del_ids_cache and p_index_del_ids_ext_cache.
4623: -- Records are stored in this cache if the key exceeds 2^31.
4624: -- p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
4625: -- This is a pl/sql table which contains the unique deliveries passed to this API.
4626: -- this table is also updated in this API once the deliveries are created for the
4627: -- delivery detail ids present in the cache tables p_index_dd_ids_cache and
4628: -- p_index_dd_ids_ext_cache.This table is not contiguous.
4655:
4656:
4657: PROCEDURE Initialize_txns(
4658: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
4659: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4660: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4661: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4662: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4663: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4656:
4657: PROCEDURE Initialize_txns(
4658: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
4659: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4660: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4661: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4662: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4663: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4664: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4657: PROCEDURE Initialize_txns(
4658: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
4659: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4660: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4661: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4662: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4663: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4664: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4665: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4658: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
4659: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4660: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4661: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4662: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4663: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4664: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4665: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4666: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
4659: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4660: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4661: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4662: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4663: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4664: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4665: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4666: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
4667: p_shipment_header_id IN NUMBER,
4660: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4661: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4662: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4663: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4664: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4665: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4666: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
4667: p_shipment_header_id IN NUMBER,
4668: x_return_status OUT NOCOPY VARCHAR2 ) IS
4661: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4662: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4663: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4664: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4665: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4666: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
4667: p_shipment_header_id IN NUMBER,
4668: x_return_status OUT NOCOPY VARCHAR2 ) IS
4669:
4697:
4698:
4699:
4700: l_new_trip_id_count NUMBER;
4701: l_new_trip_ids wsh_util_core.id_tab_type;
4702: l_del_ids wsh_util_core.id_tab_type;
4703: l_del_id_to_assign wsh_delivery_assignments_v.delivery_id%type;
4704: l_return_status VARCHAR2(1);
4705: l_num_warnings NUMBER := 0;
4698:
4699:
4700: l_new_trip_id_count NUMBER;
4701: l_new_trip_ids wsh_util_core.id_tab_type;
4702: l_del_ids wsh_util_core.id_tab_type;
4703: l_del_id_to_assign wsh_delivery_assignments_v.delivery_id%type;
4704: l_return_status VARCHAR2(1);
4705: l_num_warnings NUMBER := 0;
4706: l_num_errors NUMBER := 0;
4704: l_return_status VARCHAR2(1);
4705: l_num_warnings NUMBER := 0;
4706: l_num_errors NUMBER := 0;
4707: l_index NUMBER;
4708: l_del_rows WSH_UTIL_CORE.id_tab_type;
4709: l_trip_rows WSH_UTIL_CORE.id_tab_type;
4710: l_org_rows WSH_UTIL_CORE.id_tab_type;
4711: l_dd_ids_tab WSH_UTIL_CORE.id_tab_type;
4712: l_ind NUMBER;
4705: l_num_warnings NUMBER := 0;
4706: l_num_errors NUMBER := 0;
4707: l_index NUMBER;
4708: l_del_rows WSH_UTIL_CORE.id_tab_type;
4709: l_trip_rows WSH_UTIL_CORE.id_tab_type;
4710: l_org_rows WSH_UTIL_CORE.id_tab_type;
4711: l_dd_ids_tab WSH_UTIL_CORE.id_tab_type;
4712: l_ind NUMBER;
4713: j NUMBER := 0;
4706: l_num_errors NUMBER := 0;
4707: l_index NUMBER;
4708: l_del_rows WSH_UTIL_CORE.id_tab_type;
4709: l_trip_rows WSH_UTIL_CORE.id_tab_type;
4710: l_org_rows WSH_UTIL_CORE.id_tab_type;
4711: l_dd_ids_tab WSH_UTIL_CORE.id_tab_type;
4712: l_ind NUMBER;
4713: j NUMBER := 0;
4714:
4707: l_index NUMBER;
4708: l_del_rows WSH_UTIL_CORE.id_tab_type;
4709: l_trip_rows WSH_UTIL_CORE.id_tab_type;
4710: l_org_rows WSH_UTIL_CORE.id_tab_type;
4711: l_dd_ids_tab WSH_UTIL_CORE.id_tab_type;
4712: l_ind NUMBER;
4713: j NUMBER := 0;
4714:
4715: l_trip_ids wsh_util_core.id_tab_type;
4711: l_dd_ids_tab WSH_UTIL_CORE.id_tab_type;
4712: l_ind NUMBER;
4713: j NUMBER := 0;
4714:
4715: l_trip_ids wsh_util_core.id_tab_type;
4716: l_trip_names wsh_util_core.Column_Tab_Type;
4717: l_carrier_id NUMBER;
4718:
4719: --
4712: l_ind NUMBER;
4713: j NUMBER := 0;
4714:
4715: l_trip_ids wsh_util_core.id_tab_type;
4716: l_trip_names wsh_util_core.Column_Tab_Type;
4717: l_carrier_id NUMBER;
4718:
4719: --
4720: l_debug_on BOOLEAN;
4746: WSH_DEBUG_SV.log(l_module_name,'p_uniq_del_ids_tab.count',p_uniq_del_ids_tab.count);
4747: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id',p_shipment_header_id);
4748: END IF;
4749: --
4750: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
4751:
4752: l_carrier_id := p_local_dd_rec(p_local_dd_rec.FIRST).rcv_carrier_id;
4753:
4754: IF l_debug_on THEN
4808: --
4809: -- Debug Statements
4810: --
4811: IF l_debug_on THEN
4812: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4813: END IF;
4814: --
4815: wsh_util_core.api_post_call(
4816: p_return_status => l_return_status,
4811: IF l_debug_on THEN
4812: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4813: END IF;
4814: --
4815: wsh_util_core.api_post_call(
4816: p_return_status => l_return_status,
4817: x_num_warnings => l_num_warnings,
4818: x_num_errors => l_num_errors);
4819:
4925: -- Debug Statements
4926: --
4927: IF l_debug_on THEN
4928: WSH_DEBUG_SV.log(l_module_name,'RET STS OF WSH_TRIPS_ACTIONS.autocreate_trip_multi IS :', l_return_status);
4929: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4930: END IF;
4931: --
4932: wsh_util_core.api_post_call(
4933: p_return_status => l_return_status,
4928: WSH_DEBUG_SV.log(l_module_name,'RET STS OF WSH_TRIPS_ACTIONS.autocreate_trip_multi IS :', l_return_status);
4929: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4930: END IF;
4931: --
4932: wsh_util_core.api_post_call(
4933: p_return_status => l_return_status,
4934: x_num_warnings => l_num_warnings,
4935: x_num_errors => l_num_errors);
4936:
5041: --
5042: -- Debug Statements
5043: --
5044: IF l_debug_on THEN
5045: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5046: END IF;
5047: --
5048: wsh_util_core.api_post_call(
5049: p_return_status => l_return_status,
5044: IF l_debug_on THEN
5045: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5046: END IF;
5047: --
5048: wsh_util_core.api_post_call(
5049: p_return_status => l_return_status,
5050: x_num_warnings => l_num_warnings,
5051: x_num_errors => l_num_errors);
5052:
5060: WSH_DEBUG_SV.pop(l_module_name);
5061: END IF;
5062: --
5063: IF l_num_errors > 0 THEN
5064: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5065: ELSIF l_num_warnings > 0 THEN
5066: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5067: END IF;
5068:
5062: --
5063: IF l_num_errors > 0 THEN
5064: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5065: ELSIF l_num_warnings > 0 THEN
5066: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5067: END IF;
5068:
5069:
5070: EXCEPTION
5068:
5069:
5070: EXCEPTION
5071: WHEN FND_API.G_EXC_ERROR THEN
5072: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5073: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
5074:
5075: --
5076: -- Debug Statements
5069:
5070: EXCEPTION
5071: WHEN FND_API.G_EXC_ERROR THEN
5072: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5073: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
5074:
5075: --
5076: -- Debug Statements
5077: --
5080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5081: END IF;
5082: --
5083: WHEN OTHERS THEN
5084: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5085: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.UPDATE_STATUS');
5086:
5087: --
5088: -- Debug Statements
5081: END IF;
5082: --
5083: WHEN OTHERS THEN
5084: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5085: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.UPDATE_STATUS');
5086:
5087: --
5088: -- Debug Statements
5089: --
5119: -- The structure which contains necessary information of the changed attributes
5120: -- of the lines.
5121: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
5122: --- A record which contains the action code, transaction type etc..
5123: -- x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5124: -- A key-value cache (mapping table) which has the key as LPN id and value as
5125: -- Gross weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5126: -- x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5127: -- A key-value cache (mapping table) which has the key as LPN id and value as
5122: --- A record which contains the action code, transaction type etc..
5123: -- x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5124: -- A key-value cache (mapping table) which has the key as LPN id and value as
5125: -- Gross weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5126: -- x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5127: -- A key-value cache (mapping table) which has the key as LPN id and value as
5128: -- Gross weight for the corresponding LPN. The key ranges from 2^31 and greater.
5129: -- x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5130: -- A key-value cache (mapping table) which has the key as LPN id and value as
5125: -- Gross weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5126: -- x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5127: -- A key-value cache (mapping table) which has the key as LPN id and value as
5128: -- Gross weight for the corresponding LPN. The key ranges from 2^31 and greater.
5129: -- x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5130: -- A key-value cache (mapping table) which has the key as LPN id and value as
5131: -- Net weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5132: -- x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5133: -- A key-value cache (mapping table) which has the key as LPN id and value as
5128: -- Gross weight for the corresponding LPN. The key ranges from 2^31 and greater.
5129: -- x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5130: -- A key-value cache (mapping table) which has the key as LPN id and value as
5131: -- Net weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5132: -- x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5133: -- A key-value cache (mapping table) which has the key as LPN id and value as
5134: -- Net weight for the corresponding LPN. The key ranges from 2^31 and greater.
5135: -- x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5136: -- A key-value cache (mapping table) which has the key as LPN id and value as
5131: -- Net weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5132: -- x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5133: -- A key-value cache (mapping table) which has the key as LPN id and value as
5134: -- Net weight for the corresponding LPN. The key ranges from 2^31 and greater.
5135: -- x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5136: -- A key-value cache (mapping table) which has the key as LPN id and value as
5137: -- Volume for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5138: -- x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5139: -- A key-value cache (mapping table) which has the key as LPN id and value as
5134: -- Net weight for the corresponding LPN. The key ranges from 2^31 and greater.
5135: -- x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5136: -- A key-value cache (mapping table) which has the key as LPN id and value as
5137: -- Volume for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5138: -- x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5139: -- A key-value cache (mapping table) which has the key as LPN id and value as
5140: -- Volume for the corresponding LPN. The key ranges from 2^31 and greater.
5141: -- x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5142: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5137: -- Volume for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5138: -- x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5139: -- A key-value cache (mapping table) which has the key as LPN id and value as
5140: -- Volume for the corresponding LPN. The key ranges from 2^31 and greater.
5141: -- x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5142: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5143: -- Gross weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5144: -- x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5145: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5140: -- Volume for the corresponding LPN. The key ranges from 2^31 and greater.
5141: -- x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5142: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5143: -- Gross weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5144: -- x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5145: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5146: -- Gross weight for the corresponding LPN. The key ranges from 2^31 and greater.
5147: -- x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5148: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5143: -- Gross weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5144: -- x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5145: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5146: -- Gross weight for the corresponding LPN. The key ranges from 2^31 and greater.
5147: -- x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5148: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5149: -- Net weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5150: -- x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5151: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5146: -- Gross weight for the corresponding LPN. The key ranges from 2^31 and greater.
5147: -- x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5148: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5149: -- Net weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5150: -- x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5151: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5152: -- Net weight for the corresponding LPN. The key ranges from 2^31 and greater.
5153: -- x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5154: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5149: -- Net weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5150: -- x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5151: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5152: -- Net weight for the corresponding LPN. The key ranges from 2^31 and greater.
5153: -- x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5154: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5155: -- Volume for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5156: -- x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5157: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5152: -- Net weight for the corresponding LPN. The key ranges from 2^31 and greater.
5153: -- x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5154: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5155: -- Volume for the corresponding LPN. The key ranges from 1 to (2^31 -1)
5156: -- x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5157: -- A key-value cache (mapping table) which has the key as Delivery id and value as
5158: -- Volume for the corresponding LPN. The key ranges from 2^31 and greater.
5159:
5160: -- OUT:
5189:
5190: PROCEDURE reconfigure_del_trips(
5191: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
5192: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
5193: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5194: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5195: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5196: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5197: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5190: PROCEDURE reconfigure_del_trips(
5191: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
5192: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
5193: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5194: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5195: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5196: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5197: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5198: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5191: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
5192: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
5193: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5194: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5195: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5196: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5197: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5198: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5199: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5192: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
5193: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5194: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5195: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5196: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5197: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5198: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5199: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5200: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5193: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5194: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5195: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5196: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5197: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5198: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5199: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5200: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5201: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5194: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5195: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5196: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5197: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5198: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5199: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5200: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5201: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5202: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5195: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5196: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5197: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5198: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5199: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5200: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5201: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5202: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5203: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5196: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5197: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5198: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5199: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5200: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5201: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5202: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5203: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5204: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5197: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5198: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5199: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5200: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5201: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5202: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5203: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5204: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5205: p_shipment_header_id IN NUMBER, -- added by NPARIKH
5198: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5199: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5200: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5201: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5202: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5203: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5204: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5205: p_shipment_header_id IN NUMBER, -- added by NPARIKH
5206: x_return_status OUT NOCOPY VARCHAR2) IS
5199: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5200: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5201: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5202: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5203: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5204: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5205: p_shipment_header_id IN NUMBER, -- added by NPARIKH
5206: x_return_status OUT NOCOPY VARCHAR2) IS
5207:
5200: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5201: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5202: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5203: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5204: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5205: p_shipment_header_id IN NUMBER, -- added by NPARIKH
5206: x_return_status OUT NOCOPY VARCHAR2) IS
5207:
5208: --Cursor to get the Stop IDs corresponding to a Trip.
5245: curr_bol VARCHAR2(50);
5246: curr_del NUMBER;
5247: curr_del_det NUMBER;
5248: l_found NUMBER;
5249: temp_ids wsh_util_core.id_tab_type;
5250: pack_ids wsh_util_core.id_tab_type;
5251: temp_dels wsh_util_core.id_tab_type;
5252: l_wdd_tbl wsh_util_core.Id_Tab_Type;
5253: unique_trips wsh_util_core.id_tab_type;
5246: curr_del NUMBER;
5247: curr_del_det NUMBER;
5248: l_found NUMBER;
5249: temp_ids wsh_util_core.id_tab_type;
5250: pack_ids wsh_util_core.id_tab_type;
5251: temp_dels wsh_util_core.id_tab_type;
5252: l_wdd_tbl wsh_util_core.Id_Tab_Type;
5253: unique_trips wsh_util_core.id_tab_type;
5254: l_trips_tab wsh_util_core.id_tab_type;
5247: curr_del_det NUMBER;
5248: l_found NUMBER;
5249: temp_ids wsh_util_core.id_tab_type;
5250: pack_ids wsh_util_core.id_tab_type;
5251: temp_dels wsh_util_core.id_tab_type;
5252: l_wdd_tbl wsh_util_core.Id_Tab_Type;
5253: unique_trips wsh_util_core.id_tab_type;
5254: l_trips_tab wsh_util_core.id_tab_type;
5255: l_pack_status VARCHAR2(1);
5248: l_found NUMBER;
5249: temp_ids wsh_util_core.id_tab_type;
5250: pack_ids wsh_util_core.id_tab_type;
5251: temp_dels wsh_util_core.id_tab_type;
5252: l_wdd_tbl wsh_util_core.Id_Tab_Type;
5253: unique_trips wsh_util_core.id_tab_type;
5254: l_trips_tab wsh_util_core.id_tab_type;
5255: l_pack_status VARCHAR2(1);
5256: l_stop_ids_tab wsh_util_core.id_tab_type;
5249: temp_ids wsh_util_core.id_tab_type;
5250: pack_ids wsh_util_core.id_tab_type;
5251: temp_dels wsh_util_core.id_tab_type;
5252: l_wdd_tbl wsh_util_core.Id_Tab_Type;
5253: unique_trips wsh_util_core.id_tab_type;
5254: l_trips_tab wsh_util_core.id_tab_type;
5255: l_pack_status VARCHAR2(1);
5256: l_stop_ids_tab wsh_util_core.id_tab_type;
5257: l_stop_id NUMBER;
5250: pack_ids wsh_util_core.id_tab_type;
5251: temp_dels wsh_util_core.id_tab_type;
5252: l_wdd_tbl wsh_util_core.Id_Tab_Type;
5253: unique_trips wsh_util_core.id_tab_type;
5254: l_trips_tab wsh_util_core.id_tab_type;
5255: l_pack_status VARCHAR2(1);
5256: l_stop_ids_tab wsh_util_core.id_tab_type;
5257: l_stop_id NUMBER;
5258: l_del_ids_tab wsh_util_core.id_tab_type;
5252: l_wdd_tbl wsh_util_core.Id_Tab_Type;
5253: unique_trips wsh_util_core.id_tab_type;
5254: l_trips_tab wsh_util_core.id_tab_type;
5255: l_pack_status VARCHAR2(1);
5256: l_stop_ids_tab wsh_util_core.id_tab_type;
5257: l_stop_id NUMBER;
5258: l_del_ids_tab wsh_util_core.id_tab_type;
5259: j NUMBER;
5260: l_local_dd_rec LOCAL_DD_REC_TABLE_TYPE;
5254: l_trips_tab wsh_util_core.id_tab_type;
5255: l_pack_status VARCHAR2(1);
5256: l_stop_ids_tab wsh_util_core.id_tab_type;
5257: l_stop_id NUMBER;
5258: l_del_ids_tab wsh_util_core.id_tab_type;
5259: j NUMBER;
5260: l_local_dd_rec LOCAL_DD_REC_TABLE_TYPE;
5261: dd_rec_count NUMBER;
5262: l_num_warnings NUMBER := 0;
5273: curr_initial_pickup_date DATE;
5274: curr_expected_receipt_date DATE;
5275: curr_rcv_carrier_id NUMBER;
5276:
5277: l_initial_pickup_date_tab wsh_util_core.Date_Tab_Type;
5278: l_expected_receipt_date_tab wsh_util_core.Date_Tab_Type;
5279: l_rcv_carrier_id_tab wsh_util_core.Id_Tab_Type;
5280:
5281: l_gross_weight_of_first NUMBER;
5274: curr_expected_receipt_date DATE;
5275: curr_rcv_carrier_id NUMBER;
5276:
5277: l_initial_pickup_date_tab wsh_util_core.Date_Tab_Type;
5278: l_expected_receipt_date_tab wsh_util_core.Date_Tab_Type;
5279: l_rcv_carrier_id_tab wsh_util_core.Id_Tab_Type;
5280:
5281: l_gross_weight_of_first NUMBER;
5282: l_net_weight_of_first NUMBER;
5275: curr_rcv_carrier_id NUMBER;
5276:
5277: l_initial_pickup_date_tab wsh_util_core.Date_Tab_Type;
5278: l_expected_receipt_date_tab wsh_util_core.Date_Tab_Type;
5279: l_rcv_carrier_id_tab wsh_util_core.Id_Tab_Type;
5280:
5281: l_gross_weight_of_first NUMBER;
5282: l_net_weight_of_first NUMBER;
5283:
5281: l_gross_weight_of_first NUMBER;
5282: l_net_weight_of_first NUMBER;
5283:
5284: curr_header_id NUMBER;
5285: l_header_ids_for_del_ids_tab wsh_util_core.id_Tab_Type;
5286:
5287: l_dd_index NUMBER;
5288: --
5289: l_debug_on BOOLEAN;
5308: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.action_code',p_action_prms.action_code);
5309: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id',p_shipment_header_id);
5310: END IF;
5311: --
5312: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
5313: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
5314: SAVEPOINT RECONFIG_DEL_TRIPS_PVT;
5315:
5316:
5309: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id',p_shipment_header_id);
5310: END IF;
5311: --
5312: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
5313: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
5314: SAVEPOINT RECONFIG_DEL_TRIPS_PVT;
5315:
5316:
5317:
5329: --
5330: -- Debug Statements
5331: --
5332: IF l_debug_on THEN
5333: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5334: END IF;
5335: --
5336: wsh_util_core.api_post_call(
5337: p_return_status => l_return_status,
5332: IF l_debug_on THEN
5333: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5334: END IF;
5335: --
5336: wsh_util_core.api_post_call(
5337: p_return_status => l_return_status,
5338: x_num_warnings => l_num_warnings,
5339: x_num_errors => l_num_errors);
5340:
5440: --
5441: -- Debug Statements
5442: --
5443: IF l_debug_on THEN
5444: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5445: END IF;
5446: --
5447: wsh_util_core.api_post_call(
5448: p_return_status => l_return_status,
5443: IF l_debug_on THEN
5444: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5445: END IF;
5446: --
5447: wsh_util_core.api_post_call(
5448: p_return_status => l_return_status,
5449: x_num_warnings => l_num_warnings,
5450: x_num_errors => l_num_errors);
5451:
5482: --
5483: -- Debug Statements
5484: --
5485: IF l_debug_on THEN
5486: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5487: END IF;
5488: --
5489: wsh_util_core.api_post_call(
5490: p_return_status => l_return_status,
5485: IF l_debug_on THEN
5486: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5487: END IF;
5488: --
5489: wsh_util_core.api_post_call(
5490: p_return_status => l_return_status,
5491: x_num_warnings => l_num_warnings,
5492: x_num_errors => l_num_errors);
5493:
5527: --
5528: -- Debug Statements
5529: --
5530: IF l_debug_on THEN
5531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5532: END IF;
5533: --
5534: wsh_util_core.api_post_call(
5535: p_return_status => l_return_status,
5530: IF l_debug_on THEN
5531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5532: END IF;
5533: --
5534: wsh_util_core.api_post_call(
5535: p_return_status => l_return_status,
5536: x_num_warnings => l_num_warnings,
5537: x_num_errors => l_num_errors);
5538:
5673: --
5674: -- Debug Statements
5675: --
5676: IF l_debug_on THEN
5677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5678: END IF;
5679: --
5680: wsh_util_core.api_post_call(
5681: p_return_status => l_return_status,
5676: IF l_debug_on THEN
5677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5678: END IF;
5679: --
5680: wsh_util_core.api_post_call(
5681: p_return_status => l_return_status,
5682: x_num_warnings => l_num_warnings,
5683: x_num_errors => l_num_errors);
5684:
5719: --
5720: -- Debug Statements
5721: --
5722: IF l_debug_on THEN
5723: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5724: END IF;
5725: --
5726: wsh_util_core.api_post_call(
5727: p_return_status => l_return_status,
5722: IF l_debug_on THEN
5723: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5724: END IF;
5725: --
5726: wsh_util_core.api_post_call(
5727: p_return_status => l_return_status,
5728: x_num_warnings => l_num_warnings,
5729: x_num_errors => l_num_errors);
5730:
5737: p_delivery_id => temp_dels(i),
5738: p_delivery_leg_id => NULL,
5739: x_return_status => l_return_status) ;
5740:
5741: wsh_util_core.api_post_call(
5742: p_return_status => l_return_status,
5743: x_num_warnings => l_num_warnings,
5744: x_num_errors => l_num_errors);
5745: */
5791: --
5792: -- Debug Statements
5793: --
5794: IF l_debug_on THEN
5795: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5796: END IF;
5797: --
5798: wsh_util_core.api_post_call(
5799: p_return_status => l_return_status,
5794: IF l_debug_on THEN
5795: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5796: END IF;
5797: --
5798: wsh_util_core.api_post_call(
5799: p_return_status => l_return_status,
5800: x_num_warnings => l_num_warnings,
5801: x_num_errors => l_num_errors);
5802:
5815: l_in_rec.name := empty_it_dlvy_rec.name;
5816: l_in_rec.status_code := empty_it_dlvy_rec.status_code;
5817: l_in_rec.actual_date := empty_it_dlvy_rec.ultimate_dropoff_date;
5818: l_in_rec.manual_flag := 'N';
5819: l_in_rec.caller := WSH_UTIL_CORE.C_IB_RECEIPT_PREFIX;
5820: --
5821: temp_dels(temp_dels.COUNT + 1) := empty_it_dlvy_rec.delivery_id;
5822: --
5823: --
5836: --
5837: -- Debug Statements
5838: --
5839: IF l_debug_on THEN
5840: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5841: END IF;
5842: --
5843: wsh_util_core.api_post_call(
5844: p_return_status => l_return_status,
5839: IF l_debug_on THEN
5840: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5841: END IF;
5842: --
5843: wsh_util_core.api_post_call(
5844: p_return_status => l_return_status,
5845: x_num_warnings => l_num_warnings,
5846: x_num_errors => l_num_errors);
5847:
5876: --
5877: -- Debug Statements
5878: --
5879: IF l_debug_on THEN
5880: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5881: END IF;
5882: --
5883: wsh_util_core.api_post_call(
5884: p_return_status => l_return_status,
5879: IF l_debug_on THEN
5880: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
5881: END IF;
5882: --
5883: wsh_util_core.api_post_call(
5884: p_return_status => l_return_status,
5885: x_num_warnings => l_num_warnings,
5886: x_num_errors => l_num_errors);
5887:
5894: WSH_DEBUG_SV.pop(l_module_name);
5895: END IF;
5896: --
5897: IF l_num_errors > 0 THEN
5898: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5899: ELSIF l_num_warnings > 0 THEN
5900: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5901: END IF;
5902:
5896: --
5897: IF l_num_errors > 0 THEN
5898: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5899: ELSIF l_num_warnings > 0 THEN
5900: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5901: END IF;
5902:
5903:
5904: EXCEPTION
5903:
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: ROLLBACK TO RECONFIG_DEL_TRIPS_PVT;
5907: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5908: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
5909:
5910: --
5911: -- Debug Statements
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: ROLLBACK TO RECONFIG_DEL_TRIPS_PVT;
5907: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5908: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
5909:
5910: --
5911: -- Debug Statements
5912: --
5916: END IF;
5917: --
5918: WHEN OTHERS THEN
5919: ROLLBACK TO RECONFIG_DEL_TRIPS_PVT;
5920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5921: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.RECONFIGURE_DEL_TRIPS');
5922:
5923: --
5924: -- Debug Statements
5917: --
5918: WHEN OTHERS THEN
5919: ROLLBACK TO RECONFIG_DEL_TRIPS_PVT;
5920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5921: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.RECONFIGURE_DEL_TRIPS');
5922:
5923: --
5924: -- Debug Statements
5925: --
5981: IF l_debug_on THEN
5982: WSH_DEBUG_SV.push(l_module_name);
5983: END IF;
5984: --
5985: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5986: l_count := p_local_dd_rec.COUNT;
5987:
5988: IF l_debug_on THEN
5989: WSH_DEBUG_SV.log(l_module_name, 'l_count', l_count);
6100: WSH_DEBUG_SV.pop(l_module_name);
6101: END IF;
6102: --
6103: IF l_num_errors > 0 THEN
6104: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6105: ELSIF l_num_warnings > 0 THEN
6106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6107: END IF;
6108:
6102: --
6103: IF l_num_errors > 0 THEN
6104: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6105: ELSIF l_num_warnings > 0 THEN
6106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6107: END IF;
6108:
6109:
6110: EXCEPTION
6108:
6109:
6110: EXCEPTION
6111: WHEN OTHERS THEN
6112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
6113: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.SORT_DD_REC');
6114: --
6115: -- Debug Statements
6116: --
6109:
6110: EXCEPTION
6111: WHEN OTHERS THEN
6112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
6113: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.SORT_DD_REC');
6114: --
6115: -- Debug Statements
6116: --
6117: IF l_debug_on THEN
6194: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',P_DEL_ID);
6195: WSH_DEBUG_SV.log(l_module_name,'P_BOL',P_BOL);
6196: END IF;
6197: --
6198: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6199: OPEN c_BOL(p_del_id);
6200: FETCH C_BOL into
6201: l_delivery_leg_id,
6202: l_bol;
6245: --
6246: -- Debug Statements
6247: --
6248: IF l_debug_on THEN
6249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6250: END IF;
6251: --
6252: wsh_util_core.api_post_call(
6253: p_return_status => l_return_status,
6248: IF l_debug_on THEN
6249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6250: END IF;
6251: --
6252: wsh_util_core.api_post_call(
6253: p_return_status => l_return_status,
6254: x_num_warnings => l_num_warnings,
6255: x_num_errors => l_num_errors);
6256:
6269: WSH_DEBUG_SV.pop(l_module_name);
6270: END IF;
6271: --
6272: IF l_num_errors > 0 THEN
6273: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6274: ELSIF l_num_warnings > 0 THEN
6275: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6276: END IF;
6277:
6271: --
6272: IF l_num_errors > 0 THEN
6273: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6274: ELSIF l_num_warnings > 0 THEN
6275: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6276: END IF;
6277:
6278:
6279: EXCEPTION
6277:
6278:
6279: EXCEPTION
6280: WHEN FND_API.G_EXC_ERROR THEN
6281: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6282: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
6283:
6284: --
6285: -- Debug Statements
6278:
6279: EXCEPTION
6280: WHEN FND_API.G_EXC_ERROR THEN
6281: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6282: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
6283:
6284: --
6285: -- Debug Statements
6286: --
6289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6290: END IF;
6291: --
6292: WHEN OTHERS THEN
6293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
6294: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.SYNCH_BOLS',l_module_name);
6295:
6296: --
6297: -- Debug Statements
6290: END IF;
6291: --
6292: WHEN OTHERS THEN
6293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
6294: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.SYNCH_BOLS',l_module_name);
6295:
6296: --
6297: -- Debug Statements
6298: --
6338:
6339:
6340: PROCEDURE update_status (
6341: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
6342: p_del_ids IN wsh_util_core.id_tab_type,
6343: p_trip_ids IN wsh_util_core.id_tab_type,
6344: p_stop_ids IN wsh_util_core.id_tab_type,
6345: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
6346: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
6339:
6340: PROCEDURE update_status (
6341: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
6342: p_del_ids IN wsh_util_core.id_tab_type,
6343: p_trip_ids IN wsh_util_core.id_tab_type,
6344: p_stop_ids IN wsh_util_core.id_tab_type,
6345: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
6346: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
6347: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
6340: PROCEDURE update_status (
6341: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
6342: p_del_ids IN wsh_util_core.id_tab_type,
6343: p_trip_ids IN wsh_util_core.id_tab_type,
6344: p_stop_ids IN wsh_util_core.id_tab_type,
6345: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
6346: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
6347: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
6348: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
6341: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
6342: p_del_ids IN wsh_util_core.id_tab_type,
6343: p_trip_ids IN wsh_util_core.id_tab_type,
6344: p_stop_ids IN wsh_util_core.id_tab_type,
6345: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
6346: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
6347: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
6348: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
6349: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
6342: p_del_ids IN wsh_util_core.id_tab_type,
6343: p_trip_ids IN wsh_util_core.id_tab_type,
6344: p_stop_ids IN wsh_util_core.id_tab_type,
6345: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
6346: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
6347: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
6348: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
6349: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
6350: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6343: p_trip_ids IN wsh_util_core.id_tab_type,
6344: p_stop_ids IN wsh_util_core.id_tab_type,
6345: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
6346: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
6347: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
6348: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
6349: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
6350: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6351: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6344: p_stop_ids IN wsh_util_core.id_tab_type,
6345: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
6346: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
6347: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
6348: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
6349: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
6350: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6351: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6352: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6346: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
6347: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
6348: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
6349: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
6350: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6351: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6352: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6353: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6354: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6347: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
6348: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
6349: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
6350: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6351: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6352: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6353: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6354: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6355: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6348: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
6349: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
6350: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6351: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6352: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6353: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6354: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6355: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6356: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6349: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
6350: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6351: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6352: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6353: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6354: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6355: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6356: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6357: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6350: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6351: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6352: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6353: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6354: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6355: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6356: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6357: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6358: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6351: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6352: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6353: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6354: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6355: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6356: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6357: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6358: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6359: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6352: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6353: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6354: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6355: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6356: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6357: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6358: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6359: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6360: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6353: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6354: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6355: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6356: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6357: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6358: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6359: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6360: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6361: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6354: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6355: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6356: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6357: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6358: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6359: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6360: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6361: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6362: x_return_status OUT NOCOPY VARCHAR2) IS
6355: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6356: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6357: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6358: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6359: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6360: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6361: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6362: x_return_status OUT NOCOPY VARCHAR2) IS
6363:
6356: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6357: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6358: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6359: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6360: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6361: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6362: x_return_status OUT NOCOPY VARCHAR2) IS
6363:
6364:
6357: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6358: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6359: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6360: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6361: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6362: x_return_status OUT NOCOPY VARCHAR2) IS
6363:
6364:
6365: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
6419: WSH_DEBUG_SV.log(l_module_name,'p_expected_receipt_date_tab.COUNT',p_expected_receipt_date_tab.COUNT);
6420: WSH_DEBUG_SV.log(l_module_name,'p_rcv_carrier_id_tab.COUNT',p_rcv_carrier_id_tab.COUNT);
6421: END IF;
6422: --
6423: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6424: SAVEPOINT UPDATE_STATUS_PVT;
6425:
6426: IF p_del_ids.COUNT > 0 THEN
6427: FOR i IN 1..p_del_ids.COUNT LOOP
6634: --
6635: -- Debug Statements
6636: --
6637: IF l_debug_on THEN
6638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6639: END IF;
6640: --
6641: wsh_util_core.api_post_call(
6642: p_return_status => l_return_status,
6637: IF l_debug_on THEN
6638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6639: END IF;
6640: --
6641: wsh_util_core.api_post_call(
6642: p_return_status => l_return_status,
6643: x_num_warnings => l_num_warnings,
6644: x_num_errors => l_num_errors);
6645:
6661: --
6662: -- Debug Statements
6663: --
6664: IF l_debug_on THEN
6665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6666: END IF;
6667: --
6668: wsh_util_core.api_post_call(
6669: p_return_status => l_return_status,
6664: IF l_debug_on THEN
6665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6666: END IF;
6667: --
6668: wsh_util_core.api_post_call(
6669: p_return_status => l_return_status,
6670: x_num_warnings => l_num_warnings,
6671: x_num_errors => l_num_errors);
6672:
6699: );
6700: --
6701: IF l_debug_on THEN
6702: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6704: END IF;
6705: --
6706: wsh_util_core.api_post_call
6707: (
6702: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6704: END IF;
6705: --
6706: wsh_util_core.api_post_call
6707: (
6708: p_return_status => l_return_status,
6709: x_num_warnings => l_num_warnings,
6710: x_num_errors => l_num_errors
6728: );
6729: --
6730: IF l_debug_on THEN
6731: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6733: END IF;
6734: --
6735: wsh_util_core.api_post_call
6736: (
6731: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6733: END IF;
6734: --
6735: wsh_util_core.api_post_call
6736: (
6737: p_return_status => l_return_status,
6738: x_num_warnings => l_num_warnings,
6739: x_num_errors => l_num_errors
6752: WSH_DEBUG_SV.pop(l_module_name);
6753: END IF;
6754: --
6755: IF l_num_errors > 0 THEN
6756: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6757: ELSIF l_num_warnings > 0 THEN
6758: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6759: END IF;
6760:
6754: --
6755: IF l_num_errors > 0 THEN
6756: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6757: ELSIF l_num_warnings > 0 THEN
6758: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6759: END IF;
6760:
6761:
6762: EXCEPTION
6761:
6762: EXCEPTION
6763: WHEN OTHERS THEN
6764: ROLLBACK TO UPDATE_STATUS_PVT;
6765: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
6766: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.UPDATE_STATUS',l_module_name);
6767:
6768: --
6769: -- Debug Statements
6762: EXCEPTION
6763: WHEN OTHERS THEN
6764: ROLLBACK TO UPDATE_STATUS_PVT;
6765: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
6766: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.UPDATE_STATUS',l_module_name);
6767:
6768: --
6769: -- Debug Statements
6770: --
6787: -- po_shipment_line_id IN NUMBER
6788: -- The Shipment line ID based on which the quantities are consolidated
6789: -- against.
6790: -- IN OUT:
6791: -- p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
6792: -- A key-value mapping table.The key is the input parameter po_shipment_line_id
6793: -- and the value is the sum of the values of the input parameter p_remaining_qty
6794: -- corresponding to that po_shipment_line_id. Values are stored in this table
6795: -- only if the key value is <= (2^31 -1).
6792: -- A key-value mapping table.The key is the input parameter po_shipment_line_id
6793: -- and the value is the sum of the values of the input parameter p_remaining_qty
6794: -- corresponding to that po_shipment_line_id. Values are stored in this table
6795: -- only if the key value is <= (2^31 -1).
6796: -- p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
6797: -- A key-value mapping table.The key is the input parameter po_shipment_line_id
6798: -- and the value is the sum of the values of the input parameter p_remaining_qty
6799: -- corresponding to that po_shipment_line_id. Values are stored in this table
6800: -- only if the key value is > (2^31 -1).
6815: -- End of comments
6816:
6817:
6818: PROCEDURE consolidate_qty(
6819: p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6820: p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6821: p_remaining_qty IN OUT NOCOPY NUMBER,
6822: po_shipment_line_id IN NUMBER,
6823: x_return_status OUT NOCOPY VARCHAR2) IS
6816:
6817:
6818: PROCEDURE consolidate_qty(
6819: p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6820: p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6821: p_remaining_qty IN OUT NOCOPY NUMBER,
6822: po_shipment_line_id IN NUMBER,
6823: x_return_status OUT NOCOPY VARCHAR2) IS
6824:
6852: WSH_DEBUG_SV.log(l_module_name,'p_sli_qty_cache.count',p_sli_qty_cache.count);
6853: WSH_DEBUG_SV.log(l_module_name,'p_sli_qty_ext_cache.count',p_sli_qty_ext_cache.count);
6854: END IF;
6855: --
6856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6857: l_new_qty := p_remaining_qty;
6858:
6859: --
6860: -- Debug Statements
6859: --
6860: -- Debug Statements
6861: --
6862: IF l_debug_on THEN
6863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-p_sli_qty_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
6864: END IF;
6865: --
6866: wsh_util_core.get_cached_value(
6867: p_cache_tbl => p_sli_qty_cache,
6862: IF l_debug_on THEN
6863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-p_sli_qty_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
6864: END IF;
6865: --
6866: wsh_util_core.get_cached_value(
6867: p_cache_tbl => p_sli_qty_cache,
6868: p_cache_ext_tbl => p_sli_qty_ext_cache,
6869: p_value => p_remaining_qty,
6870: p_key => po_shipment_line_id,
6878: --
6879:
6880: --MEANS THE PO_LINE_LOCATION_ID IS NOT THERE IN THE CACHE
6881: --SO ADD IT TO THE CACHE WITH THE NEW QTY AS
6882: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
6883: p_remaining_qty := l_new_qty;
6884:
6885: --MEANS THE PO_LINE_LOCATION_ID IS ALREADY THERE.SO GET THE QTY(which is now available
6886: --in the p_remaining_qty) ...AND ADD THE NEW QTY
6884:
6885: --MEANS THE PO_LINE_LOCATION_ID IS ALREADY THERE.SO GET THE QTY(which is now available
6886: --in the p_remaining_qty) ...AND ADD THE NEW QTY
6887: --TO IT..AND ADD THE CONSILADTED QTY BACK TO THE CACHE FOR THIS PO_LINE_LOCATION_ID
6888: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6889: p_remaining_qty := p_remaining_qty + l_new_qty;
6890: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6891: raise FND_API.G_EXC_ERROR;
6892: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
6886: --in the p_remaining_qty) ...AND ADD THE NEW QTY
6887: --TO IT..AND ADD THE CONSILADTED QTY BACK TO THE CACHE FOR THIS PO_LINE_LOCATION_ID
6888: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6889: p_remaining_qty := p_remaining_qty + l_new_qty;
6890: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6891: raise FND_API.G_EXC_ERROR;
6892: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
6893: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6894: END IF;
6888: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6889: p_remaining_qty := p_remaining_qty + l_new_qty;
6890: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6891: raise FND_API.G_EXC_ERROR;
6892: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
6893: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6894: END IF;
6895:
6896: IF l_debug_on THEN
6900: --
6901: -- Debug Statements
6902: --
6903: IF l_debug_on THEN
6904: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-p_sli_qty_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
6905: END IF;
6906: --
6907: wsh_util_core.get_cached_value(
6908: p_cache_tbl => p_sli_qty_cache,
6903: IF l_debug_on THEN
6904: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-p_sli_qty_cache',WSH_DEBUG_SV.C_PROC_LEVEL);
6905: END IF;
6906: --
6907: wsh_util_core.get_cached_value(
6908: p_cache_tbl => p_sli_qty_cache,
6909: p_cache_ext_tbl => p_sli_qty_ext_cache,
6910: p_value => p_remaining_qty,
6911: p_key => po_shipment_line_id,
6911: p_key => po_shipment_line_id,
6912: p_action => 'PUT',
6913: x_return_status => l_return_status );
6914:
6915: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6916: raise FND_API.G_EXC_ERROR;
6917: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
6918: THEN
6919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6913: x_return_status => l_return_status );
6914:
6915: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6916: raise FND_API.G_EXC_ERROR;
6917: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
6918: THEN
6919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6920: END IF;
6921:
6925: WSH_DEBUG_SV.pop(l_module_name);
6926: END IF;
6927: --
6928: IF l_num_errors > 0 THEN
6929: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6930: ELSIF l_num_warnings > 0 THEN
6931: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6932: END IF;
6933:
6927: --
6928: IF l_num_errors > 0 THEN
6929: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6930: ELSIF l_num_warnings > 0 THEN
6931: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6932: END IF;
6933:
6934:
6935: EXCEPTION
6934:
6935: EXCEPTION
6936: WHEN OTHERS THEN
6937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6938: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.CONSOLIDATE_QTY',l_module_name);
6939:
6940: --
6941: -- Debug Statements
6942: --
6977: -- A table of records used only within this package.It gets its data
6978: -- from the record structure p_line_rec and also from other API calls
6979: -- made from the API process_matched_txns of this Package.
6980: -- l_update_dd_rec IN OUT NOCOPY update_dd_rec_type
6981: -- x_lpnIdCacheTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
6982: -- x_lpnIdCacheExtTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
6983: -- OUT:
6984: -- x_return_status OUT NOCOPY VARCHAR2
6985: --Cache Tables:
6978: -- from the record structure p_line_rec and also from other API calls
6979: -- made from the API process_matched_txns of this Package.
6980: -- l_update_dd_rec IN OUT NOCOPY update_dd_rec_type
6981: -- x_lpnIdCacheTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
6982: -- x_lpnIdCacheExtTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
6983: -- OUT:
6984: -- x_return_status OUT NOCOPY VARCHAR2
6985: --Cache Tables:
6986: -- ----------------------------------------------------------------------
7004: p_net_weight IN NUMBER DEFAULT NULL,
7005: p_volume IN NUMBER DEFAULT NULL,
7006: x_release_status IN VARCHAR2,
7007: l_update_dd_rec IN OUT NOCOPY update_dd_rec_type,
7008: x_lpnIdCacheTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
7009: x_lpnIdCacheExtTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
7010: x_return_status OUT NOCOPY VARCHAR2
7011: )
7012:
7005: p_volume IN NUMBER DEFAULT NULL,
7006: x_release_status IN VARCHAR2,
7007: l_update_dd_rec IN OUT NOCOPY update_dd_rec_type,
7008: x_lpnIdCacheTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
7009: x_lpnIdCacheExtTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
7010: x_return_status OUT NOCOPY VARCHAR2
7011: )
7012:
7013: IS
7057: WSH_DEBUG_SV.log(l_module_name,'X_RELEASE_STATUS',X_RELEASE_STATUS);
7058: WSH_DEBUG_SV.log(l_module_name,'l_update_dd_rec.delivery_detail_id.COUNT',l_update_dd_rec.delivery_detail_id.COUNT);
7059: END IF;
7060: --
7061: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7062:
7063: i:= (l_update_dd_rec.delivery_detail_id.COUNT)+1;
7064: l_index := p_dd_rec.shpmt_line_id_idx_tab(p_index);
7065:
7151: IF l_lpn_id IS NOT NULL
7152: THEN
7153: --{
7154: IF l_debug_on THEN
7155: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_lpnIdcacheTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
7156: END IF;
7157: --
7158:
7159: --Check whether the LPN is already there in the cache table. If the LPN is
7157: --
7158:
7159: --Check whether the LPN is already there in the cache table. If the LPN is
7160: --not in the cache table, this API will return a warning.
7161: wsh_util_core.get_cached_value
7162: (
7163: p_cache_tbl => x_lpnIdcacheTbl,
7164: p_cache_ext_tbl => x_lpnIdcacheExtTbl,
7165: p_key => l_lpn_id,
7173: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
7174: END IF;
7175: --
7176: --
7177: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
7178: THEN
7179: RAISE FND_API.G_EXC_ERROR;
7180: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
7181: THEN
7176: --
7177: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
7178: THEN
7179: RAISE FND_API.G_EXC_ERROR;
7180: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
7181: THEN
7182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7183: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
7184: THEN
7179: RAISE FND_API.G_EXC_ERROR;
7180: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
7181: THEN
7182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7183: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
7184: THEN
7185: --{
7186: IF l_debug_on THEN
7187: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_cacheTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
7183: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
7184: THEN
7185: --{
7186: IF l_debug_on THEN
7187: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_cacheTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
7188: END IF;
7189: --
7190:
7191: --Add the LPN ID into this table as it is not existing till now.
7188: END IF;
7189: --
7190:
7191: --Add the LPN ID into this table as it is not existing till now.
7192: wsh_util_core.get_cached_value
7193: (
7194: p_cache_tbl => x_lpnIdcacheTbl,
7195: p_cache_ext_tbl => x_lpnIdcacheExtTbl,
7196: p_key => l_lpn_id,
7201: --
7202: --
7203: IF l_debug_on THEN
7204: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
7205: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7206: END IF;
7207: --
7208: wsh_util_core.api_post_call
7209: (
7204: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
7205: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7206: END IF;
7207: --
7208: wsh_util_core.api_post_call
7209: (
7210: p_return_status => l_return_status,
7211: x_num_warnings => l_num_warnings,
7212: x_num_errors => l_num_errors
7274: END IF;
7275: --
7276:
7277: IF l_num_errors > 0 THEN
7278: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7279: ELSIF l_num_warnings > 0 THEN
7280: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7281: END IF;
7282:
7276:
7277: IF l_num_errors > 0 THEN
7278: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7279: ELSIF l_num_warnings > 0 THEN
7280: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7281: END IF;
7282:
7283:
7284: EXCEPTION
7283:
7284: EXCEPTION
7285: WHEN OTHERS THEN
7286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7287: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.POPULATE_UPDATE_DD_REC',l_module_name);
7288:
7289: --
7290: -- Debug Statements
7291: --
7313: -- The current record of the i/p parameter p_local_dd_rec .
7314: -- IN OUT:
7315: -- p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE
7316: -- A record structure which contains all...
7317: -- pack_ids IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type
7318: -- Contains a list of delivery detail IDs which have a common LPN or no LPN.
7319: -- curr_del IN OUT NOCOPY NUMBER
7320: -- The current delivery upon which all the other input parameters depend on.
7321: -- curr_bol IN OUT NOCOPY VARCHAR2
7351: -- If the value is 0, it means that the waybill # has remained the same for all those records
7352: -- of p_local_dd_rec which correspond to the current delivery.In this case the waybill
7353: -- is updated against the delivery ID.
7354: -- If the value is 1, then the waybill is updated as NULL for the current delivery.
7355: -- temp_dels IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type
7356: -- Contains non-duplicate delivery IDs belonging to the record structure p_local_dd_rec
7357: -- This is a dynamic container and goes on adding until all the records of the structure
7358: -- are scanned.
7359: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
7368:
7369: PROCEDURE create_update_waybill_psno_bol(
7370: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
7371: l_loop_index IN NUMBER,
7372: pack_ids IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
7373: curr_del IN OUT NOCOPY NUMBER,
7374: curr_bol IN OUT NOCOPY VARCHAR2,
7375: curr_lpn IN OUT NOCOPY NUMBER,
7376: curr_lpn_name IN OUT NOCOPY VARCHAR2,
7379: l_waybill IN OUT NOCOPY VARCHAR2,
7380: l_psno_flag IN OUT NOCOPY NUMBER,
7381: l_trigger IN OUT NOCOPY NUMBER,
7382: l_waybill_flag IN OUT NOCOPY NUMBER,
7383: temp_dels IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
7384: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
7385: x_return_status OUT NOCOPY VARCHAR2
7386: )
7387: IS
7420: l_new_del_id NUMBER;
7421: l_final_del_leg_id NUMBER;
7422: --
7423: l_row_id NUMBER;
7424: l_leg_id_tab WSH_UTIL_CORE.id_tab_type;
7425: --
7426: l_debug_on BOOLEAN;
7427: --
7428: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_WAYBILL_PSNO_BOL';
7427: --
7428: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_WAYBILL_PSNO_BOL';
7429: --
7430: BEGIN
7431: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7432: --
7433: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
7434: --
7435: IF l_debug_on IS NULL
7482: --
7483: -- Debug Statements
7484: --
7485: IF l_debug_on THEN
7486: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7487: END IF;
7488: --
7489: wsh_util_core.api_post_call(
7490: p_return_status => l_return_status,
7485: IF l_debug_on THEN
7486: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7487: END IF;
7488: --
7489: wsh_util_core.api_post_call(
7490: p_return_status => l_return_status,
7491: x_num_warnings => l_num_warnings,
7492: x_num_errors => l_num_errors);
7493: END IF;
7517: --
7518: -- Debug Statements
7519: --
7520: IF l_debug_on THEN
7521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7522: END IF;
7523: --
7524: wsh_util_core.api_post_call(
7525: p_return_status => l_return_status,
7520: IF l_debug_on THEN
7521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7522: END IF;
7523: --
7524: wsh_util_core.api_post_call(
7525: p_return_status => l_return_status,
7526: x_num_warnings => l_num_warnings,
7527: x_num_errors => l_num_errors);
7528:
7550: --
7551: -- Debug Statements
7552: --
7553: IF l_debug_on THEN
7554: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7555: END IF;
7556: --
7557: wsh_util_core.api_post_call(
7558: p_return_status => l_return_status,
7553: IF l_debug_on THEN
7554: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7555: END IF;
7556: --
7557: wsh_util_core.api_post_call(
7558: p_return_status => l_return_status,
7559: x_num_warnings => l_num_warnings,
7560: x_num_errors => l_num_errors);
7561: END IF;
7589: --
7590: -- Debug Statements
7591: --
7592: IF l_debug_on THEN
7593: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7594: END IF;
7595: --
7596:
7597: wsh_util_core.api_post_call(
7593: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7594: END IF;
7595: --
7596:
7597: wsh_util_core.api_post_call(
7598: p_return_status => l_return_status,
7599: x_num_warnings => l_num_warnings,
7600: x_num_errors => l_num_errors);
7601:
7647: --
7648: -- Debug Statements
7649: --
7650: IF l_debug_on THEN
7651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7652: END IF;
7653: --
7654: wsh_util_core.api_post_call(
7655: p_return_status => l_return_status,
7650: IF l_debug_on THEN
7651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7652: END IF;
7653: --
7654: wsh_util_core.api_post_call(
7655: p_return_status => l_return_status,
7656: x_num_warnings => l_num_warnings,
7657: x_num_errors => l_num_errors);
7658: END IF;
7693: WSH_DEBUG_SV.pop(l_module_name);
7694: END IF;
7695: --
7696: IF l_num_errors > 0 THEN
7697: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7698: ELSIF l_num_warnings > 0 THEN
7699: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7700: END IF;
7701:
7695: --
7696: IF l_num_errors > 0 THEN
7697: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7698: ELSIF l_num_warnings > 0 THEN
7699: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7700: END IF;
7701:
7702:
7703: EXCEPTION
7701:
7702:
7703: EXCEPTION
7704: WHEN FND_API.G_EXC_ERROR THEN
7705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7706: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
7707:
7708: --
7709: -- Debug Statements
7702:
7703: EXCEPTION
7704: WHEN FND_API.G_EXC_ERROR THEN
7705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7706: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
7707:
7708: --
7709: -- Debug Statements
7710: --
7713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7714: END IF;
7715: --
7716: WHEN OTHERS THEN
7717: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
7718: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.create_update_waybill_psno_bol',l_module_name);
7719:
7720: --
7721: -- Debug Statements
7714: END IF;
7715: --
7716: WHEN OTHERS THEN
7717: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
7718: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.create_update_waybill_psno_bol',l_module_name);
7719:
7720: --
7721: -- Debug Statements
7722: --
7841: --
7842: BEGIN
7843:
7844:
7845: x_return_status := wsh_util_core.g_ret_sts_success;
7846: --
7847: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
7848: --
7849: IF l_debug_on IS NULL
8042: WSH_DEBUG_SV.pop(l_module_name);
8043: END IF;
8044: --
8045: IF l_num_errors > 0 THEN
8046: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8047: ELSIF l_num_warnings > 0 THEN
8048: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8049: END IF;
8050:
8044: --
8045: IF l_num_errors > 0 THEN
8046: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8047: ELSIF l_num_warnings > 0 THEN
8048: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8049: END IF;
8050:
8051:
8052: EXCEPTION
8050:
8051:
8052: EXCEPTION
8053: WHEN FND_API.G_EXC_ERROR THEN
8054: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8055: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
8056:
8057: --
8058: -- Debug Statements
8051:
8052: EXCEPTION
8053: WHEN FND_API.G_EXC_ERROR THEN
8054: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8055: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
8056:
8057: --
8058: -- Debug Statements
8059: --
8062: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8063: END IF;
8064: --
8065: WHEN OTHERS THEN
8066: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8067: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.create_update_inbound_document ',l_module_name);
8068: --
8069: -- Debug Statements
8070: --
8063: END IF;
8064: --
8065: WHEN OTHERS THEN
8066: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8067: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.create_update_inbound_document ',l_module_name);
8068: --
8069: -- Debug Statements
8070: --
8071: IF l_debug_on THEN
8123: --
8124:
8125: BEGIN
8126:
8127: x_return_status := wsh_util_core.g_ret_sts_success;
8128: --
8129: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
8130: --
8131: IF l_debug_on IS NULL
8164: --
8165: -- Debug Statements
8166: --
8167: IF l_debug_on THEN
8168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
8169: END IF;
8170: --
8171: wsh_util_core.api_post_call(
8172: p_return_status => l_return_status,
8167: IF l_debug_on THEN
8168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
8169: END IF;
8170: --
8171: wsh_util_core.api_post_call(
8172: p_return_status => l_return_status,
8173: x_num_warnings => l_num_warnings,
8174: x_num_errors => l_num_errors);
8175:
8195: --
8196: -- Debug Statements
8197: --
8198: IF l_debug_on THEN
8199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
8200: END IF;
8201: --
8202: wsh_util_core.api_post_call(
8203: p_return_status => l_return_status,
8198: IF l_debug_on THEN
8199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
8200: END IF;
8201: --
8202: wsh_util_core.api_post_call(
8203: p_return_status => l_return_status,
8204: x_num_warnings => l_num_warnings,
8205: x_num_errors => l_num_errors);
8206:
8215: WSH_DEBUG_SV.pop(l_module_name);
8216: END IF;
8217: --
8218: IF l_num_errors > 0 THEN
8219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8220: ELSIF l_num_warnings > 0 THEN
8221: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8222: END IF;
8223:
8217: --
8218: IF l_num_errors > 0 THEN
8219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8220: ELSIF l_num_warnings > 0 THEN
8221: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8222: END IF;
8223:
8224:
8225: EXCEPTION
8223:
8224:
8225: EXCEPTION
8226: WHEN FND_API.G_EXC_ERROR THEN
8227: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8228: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
8229:
8230: --
8231: -- Debug Statements
8224:
8225: EXCEPTION
8226: WHEN FND_API.G_EXC_ERROR THEN
8227: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8228: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
8229:
8230: --
8231: -- Debug Statements
8232: --
8235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8236: END IF;
8237: --
8238: WHEN OTHERS THEN
8239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8240: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.cancel_close_pending_txns');
8241:
8242: --
8243: -- Debug Statements
8236: END IF;
8237: --
8238: WHEN OTHERS THEN
8239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8240: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.cancel_close_pending_txns');
8241:
8242: --
8243: -- Debug Statements
8244: --