[Home] [Help]
121: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
122: --
123: IF l_debug_on IS NULL
124: THEN
125: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
126: END IF;
127: --
128: IF l_debug_on THEN
129: WSH_DEBUG_SV.push(l_module_name);
125: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
126: END IF;
127: --
128: IF l_debug_on THEN
129: WSH_DEBUG_SV.push(l_module_name);
130: --
131: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
132: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
133: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
127: --
128: IF l_debug_on THEN
129: WSH_DEBUG_SV.push(l_module_name);
130: --
131: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
132: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
133: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
134: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
135: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_ID',P_CONTAINER_ITEM_ID);
128: IF l_debug_on THEN
129: WSH_DEBUG_SV.push(l_module_name);
130: --
131: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
132: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
133: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
134: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
135: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_ID',P_CONTAINER_ITEM_ID);
136: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_NAME',P_CONTAINER_ITEM_NAME);
129: WSH_DEBUG_SV.push(l_module_name);
130: --
131: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
132: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
133: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
134: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
135: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_ID',P_CONTAINER_ITEM_ID);
136: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_NAME',P_CONTAINER_ITEM_NAME);
137: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
130: --
131: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
132: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
133: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
134: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
135: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_ID',P_CONTAINER_ITEM_ID);
136: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_NAME',P_CONTAINER_ITEM_NAME);
137: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
138: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_CODE',P_ORGANIZATION_CODE);
131: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
132: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
133: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
134: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
135: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_ID',P_CONTAINER_ITEM_ID);
136: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_NAME',P_CONTAINER_ITEM_NAME);
137: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
138: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_CODE',P_ORGANIZATION_CODE);
139: WSH_DEBUG_SV.log(l_module_name,'P_NAME_PREFIX',P_NAME_PREFIX);
132: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
133: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
134: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
135: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_ID',P_CONTAINER_ITEM_ID);
136: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_NAME',P_CONTAINER_ITEM_NAME);
137: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
138: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_CODE',P_ORGANIZATION_CODE);
139: WSH_DEBUG_SV.log(l_module_name,'P_NAME_PREFIX',P_NAME_PREFIX);
140: WSH_DEBUG_SV.log(l_module_name,'P_NAME_SUFFIX',P_NAME_SUFFIX);
133: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
134: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
135: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_ID',P_CONTAINER_ITEM_ID);
136: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_NAME',P_CONTAINER_ITEM_NAME);
137: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
138: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_CODE',P_ORGANIZATION_CODE);
139: WSH_DEBUG_SV.log(l_module_name,'P_NAME_PREFIX',P_NAME_PREFIX);
140: WSH_DEBUG_SV.log(l_module_name,'P_NAME_SUFFIX',P_NAME_SUFFIX);
141: WSH_DEBUG_SV.log(l_module_name,'P_BASE_NUMBER',P_BASE_NUMBER);
134: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
135: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_ID',P_CONTAINER_ITEM_ID);
136: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_NAME',P_CONTAINER_ITEM_NAME);
137: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
138: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_CODE',P_ORGANIZATION_CODE);
139: WSH_DEBUG_SV.log(l_module_name,'P_NAME_PREFIX',P_NAME_PREFIX);
140: WSH_DEBUG_SV.log(l_module_name,'P_NAME_SUFFIX',P_NAME_SUFFIX);
141: WSH_DEBUG_SV.log(l_module_name,'P_BASE_NUMBER',P_BASE_NUMBER);
142: WSH_DEBUG_SV.log(l_module_name,'P_NUM_DIGITS',P_NUM_DIGITS);
135: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_ID',P_CONTAINER_ITEM_ID);
136: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_NAME',P_CONTAINER_ITEM_NAME);
137: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
138: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_CODE',P_ORGANIZATION_CODE);
139: WSH_DEBUG_SV.log(l_module_name,'P_NAME_PREFIX',P_NAME_PREFIX);
140: WSH_DEBUG_SV.log(l_module_name,'P_NAME_SUFFIX',P_NAME_SUFFIX);
141: WSH_DEBUG_SV.log(l_module_name,'P_BASE_NUMBER',P_BASE_NUMBER);
142: WSH_DEBUG_SV.log(l_module_name,'P_NUM_DIGITS',P_NUM_DIGITS);
143: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
136: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_ITEM_NAME',P_CONTAINER_ITEM_NAME);
137: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
138: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_CODE',P_ORGANIZATION_CODE);
139: WSH_DEBUG_SV.log(l_module_name,'P_NAME_PREFIX',P_NAME_PREFIX);
140: WSH_DEBUG_SV.log(l_module_name,'P_NAME_SUFFIX',P_NAME_SUFFIX);
141: WSH_DEBUG_SV.log(l_module_name,'P_BASE_NUMBER',P_BASE_NUMBER);
142: WSH_DEBUG_SV.log(l_module_name,'P_NUM_DIGITS',P_NUM_DIGITS);
143: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
144: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
137: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
138: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_CODE',P_ORGANIZATION_CODE);
139: WSH_DEBUG_SV.log(l_module_name,'P_NAME_PREFIX',P_NAME_PREFIX);
140: WSH_DEBUG_SV.log(l_module_name,'P_NAME_SUFFIX',P_NAME_SUFFIX);
141: WSH_DEBUG_SV.log(l_module_name,'P_BASE_NUMBER',P_BASE_NUMBER);
142: WSH_DEBUG_SV.log(l_module_name,'P_NUM_DIGITS',P_NUM_DIGITS);
143: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
144: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
145: END IF;
138: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_CODE',P_ORGANIZATION_CODE);
139: WSH_DEBUG_SV.log(l_module_name,'P_NAME_PREFIX',P_NAME_PREFIX);
140: WSH_DEBUG_SV.log(l_module_name,'P_NAME_SUFFIX',P_NAME_SUFFIX);
141: WSH_DEBUG_SV.log(l_module_name,'P_BASE_NUMBER',P_BASE_NUMBER);
142: WSH_DEBUG_SV.log(l_module_name,'P_NUM_DIGITS',P_NUM_DIGITS);
143: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
144: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
145: END IF;
146: --
139: WSH_DEBUG_SV.log(l_module_name,'P_NAME_PREFIX',P_NAME_PREFIX);
140: WSH_DEBUG_SV.log(l_module_name,'P_NAME_SUFFIX',P_NAME_SUFFIX);
141: WSH_DEBUG_SV.log(l_module_name,'P_BASE_NUMBER',P_BASE_NUMBER);
142: WSH_DEBUG_SV.log(l_module_name,'P_NUM_DIGITS',P_NUM_DIGITS);
143: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
144: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
145: END IF;
146: --
147: SAVEPOINT Create_Containers_SP_GRP;
140: WSH_DEBUG_SV.log(l_module_name,'P_NAME_SUFFIX',P_NAME_SUFFIX);
141: WSH_DEBUG_SV.log(l_module_name,'P_BASE_NUMBER',P_BASE_NUMBER);
142: WSH_DEBUG_SV.log(l_module_name,'P_NUM_DIGITS',P_NUM_DIGITS);
143: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
144: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
145: END IF;
146: --
147: SAVEPOINT Create_Containers_SP_GRP;
148:
168: END IF;
169:
170: IF p_caller NOT LIKE 'WMS%' THEN
171: IF l_debug_on THEN
172: WSH_DEBUG_SV.log(l_module_name,'Invalid caller',p_caller);
173: END IF;
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:
175: END IF;
176:
177: IF p_lpn_ids.COUNT = 0 THEN
178: IF l_debug_on THEN
179: wsh_debug_sv.logmsg(l_module_name,'lpn_id cannot be null');
180: END IF;
181: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
182: FND_MESSAGE.SET_TOKEN('FIELD_NAME','LPN_ID');
183: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
209: l_organization_code := p_organization_code;
210:
211: IF l_verify_org_level = 1 THEN
212: IF l_debug_on THEN
213: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ORG',WSH_DEBUG_SV.C_PROC_LEVEL);
214: END IF;
215: --
216: WSH_UTIL_VALIDATE.Validate_Org (l_organization_id,
217: l_organization_code,
233: IF l_verify_cont_item = 1 THEN
234: /* wms change: Validate Item check is to be skipped if the Org. is WMS enabled */
235:
236: IF l_debug_on THEN
237: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_INSTALL.CHECK_INSTALL',WSH_DEBUG_SV.C_PROC_LEVEL);
238: END IF;
239:
240: wms_enabled := WMS_INSTALL.check_install(
241: wms_return_status,
243: wms_msg_data,
244: l_organization_id);
245:
246: IF l_debug_on THEN
247: wsh_debug_sv.log(l_module_name, 'wms enabled', wms_enabled);
248: END IF;
249:
250: IF (wms_enabled = FALSE) THEN
251: IF (l_cont_item_id IS NULL
255: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
256: RAISE WSH_NO_INV_ITEM;
257: ELSE
258: IF l_debug_on THEN
259: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
260: END IF;
261: --
262: WSH_UTIL_VALIDATE.Validate_Item
263: (p_inventory_item_id => l_cont_item_id,
324: );
325:
326:
327: IF l_debug_on THEN
328: WSH_DEBUG_SV.pop(l_module_name);
329: END IF;
330: --
331: EXCEPTION
332: WHEN FND_API.G_EXC_ERROR THEN
339: p_encoded => FND_API.G_FALSE
340: );
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
345: END IF;
346:
347: WHEN WSH_NO_INV_ITEM then
340: );
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
345: END IF;
346:
347: WHEN WSH_NO_INV_ITEM then
348: rollback to Create_Containers_SP_GRP;
355: );
356:
357:
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_INV_ITEM exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
360: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_NO_INV_ITEM');
361: END IF;
362: --
363: WHEN WSH_INVALID_QTY then
356:
357:
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_INV_ITEM exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
360: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_NO_INV_ITEM');
361: END IF;
362: --
363: WHEN WSH_INVALID_QTY then
364: rollback to Create_Containers_SP_GRP;
372: , p_encoded => FND_API.G_FALSE
373: );
374:
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_QTY');
378: END IF;
379: --
380: WHEN WSH_FAIL_CONT_CREATION then
373: );
374:
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_QTY');
378: END IF;
379: --
380: WHEN WSH_FAIL_CONT_CREATION then
381: rollback to Create_Containers_SP_GRP;
389: , p_encoded => FND_API.G_FALSE
390: );
391:
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_CREATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
394: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_CREATION');
395: END IF;
396: --
397: WHEN WSH_LPN_COUNT_INVALID then
390: );
391:
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_CREATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
394: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_CREATION');
395: END IF;
396: --
397: WHEN WSH_LPN_COUNT_INVALID then
398: rollback to Create_Containers_SP_GRP;
406: , p_encoded => FND_API.G_FALSE
407: );
408:
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_LPN_COUNT_INVALID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_LPN_COUNT_INVALID');
412: END IF;
413: --
414: WHEN OTHERS then
407: );
408:
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_LPN_COUNT_INVALID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_LPN_COUNT_INVALID');
412: END IF;
413: --
414: WHEN OTHERS then
415: rollback to Create_Containers_SP_GRP;
421: , p_encoded => FND_API.G_FALSE
422: );
423:
424: IF l_debug_on THEN
425: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
426: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
427: END IF;
428: --
429: END Create_Containers;
422: );
423:
424: IF l_debug_on THEN
425: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
426: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
427: END IF;
428: --
429: END Create_Containers;
430:
529: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
530: --
531: IF l_debug_on IS NULL
532: THEN
533: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
534: END IF;
535: --
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.push(l_module_name);
533: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
534: END IF;
535: --
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.push(l_module_name);
538: --
539: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
540: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
541: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
535: --
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.push(l_module_name);
538: --
539: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
540: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
541: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
542: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
543: END IF;
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.push(l_module_name);
538: --
539: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
540: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
541: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
542: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
543: END IF;
544: --
537: WSH_DEBUG_SV.push(l_module_name);
538: --
539: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
540: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
541: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
542: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
543: END IF;
544: --
545: SAVEPOINT Update_Containers_SP_Grp;
538: --
539: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
540: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
541: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
542: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
543: END IF;
544: --
545: SAVEPOINT Update_Containers_SP_Grp;
546:
559:
560: /*
561: IF p_caller NOT LIKE 'WMS%' THEN
562: IF l_debug_on THEN
563: WSH_DEBUG_SV.log(l_module_name,'Invalid caller',p_caller);
564: END IF;
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567: p_caller does not exist
908: --
909: -- Debug Statements
910: --
911: IF l_debug_on THEN
912: WSH_DEBUG_SV.pop(l_module_name);
913: END IF;
914: --
915: EXCEPTION
916:
936: --
937: -- Debug Statements
938: --
939: IF l_debug_on THEN
940: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
941: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT_UPDATE');
942: END IF;
943: --
944: WHEN WSH_INVALID_CONT then
937: -- Debug Statements
938: --
939: IF l_debug_on THEN
940: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
941: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT_UPDATE');
942: END IF;
943: --
944: WHEN WSH_INVALID_CONT then
945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
962: --
963: -- Debug Statements
964: --
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');
968: END IF;
969: --
970: WHEN WSH_FAIL_CONT_UPDATE then
963: -- Debug Statements
964: --
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');
968: END IF;
969: --
970: WHEN WSH_FAIL_CONT_UPDATE then
971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
989: --
990: -- Debug Statements
991: --
992: IF l_debug_on THEN
993: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
994: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_UPDATE');
995: END IF;
996: --
997: WHEN OTHERS then
990: -- Debug Statements
991: --
992: IF l_debug_on THEN
993: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
994: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_UPDATE');
995: END IF;
996: --
997: WHEN OTHERS then
998: wsh_util_core.default_handler('WSH_CONTAINER_GRP.Update_Container');
1018: --
1019: -- Debug Statements
1020: --
1021: IF l_debug_on THEN
1022: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1023: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1024: END IF;
1025: --
1026: END Update_Container;
1019: -- Debug Statements
1020: --
1021: IF l_debug_on THEN
1022: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1023: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1024: END IF;
1025: --
1026: END Update_Container;
1027:
1168: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1169: --
1170: IF l_debug_on IS NULL
1171: THEN
1172: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1173: END IF;
1174: --
1175: IF l_debug_on THEN
1176: WSH_DEBUG_SV.push(l_module_name);
1172: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1173: END IF;
1174: --
1175: IF l_debug_on THEN
1176: WSH_DEBUG_SV.push(l_module_name);
1177: --
1178: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1179: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1180: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1174: --
1175: IF l_debug_on THEN
1176: WSH_DEBUG_SV.push(l_module_name);
1177: --
1178: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1179: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1180: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1181: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1182: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1175: IF l_debug_on THEN
1176: WSH_DEBUG_SV.push(l_module_name);
1177: --
1178: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1179: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1180: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1181: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1182: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1183: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1176: WSH_DEBUG_SV.push(l_module_name);
1177: --
1178: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1179: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1180: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1181: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1182: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1183: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1184: END IF;
1177: --
1178: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1179: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1180: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1181: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1182: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1183: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1184: END IF;
1185: --
1178: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1179: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1180: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1181: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1182: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1183: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1184: END IF;
1185: --
1186: SAVEPOINT Autopack_SP_Grp;
1179: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1180: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1181: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1182: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1183: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1184: END IF;
1185: --
1186: SAVEPOINT Autopack_SP_Grp;
1187:
1239: --
1240: -- Debug Statements
1241: --
1242: IF l_debug_on THEN
1243: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.AUTO_PACK_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);
1244: END IF;
1245: --
1246: WSH_DLVB_COMMON_ACTIONS.Auto_Pack_Lines (
1247: p_group_id_tab => p_group_id_tab,
1267: END IF;
1268: ELSE
1269: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1270: IF l_debug_on THEN
1271: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TP_RELEASE.CALCULATE_CONT_DEL_TPDATES',WSH_DEBUG_SV.C_PROC_LEVEL);
1272: END IF;
1273: WSH_TP_RELEASE.calculate_cont_del_tpdates(
1274: p_entity => 'DLVB',
1275: p_entity_ids =>x_cont_inst_tab,
1325: --
1326: -- Debug Statements
1327: --
1328: IF l_debug_on THEN
1329: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1330: END IF;
1331: --
1332: WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery (
1333: l_del_tab,
1350: RAISE WSH_FAIL_AUTOPACK;
1351: END IF;
1352: ELSE
1353: IF l_debug_on THEN
1354: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TP_RELEASE.CALCULATE_CONT_DEL_TPDATES',WSH_DEBUG_SV.C_PROC_LEVEL);
1355: END IF;
1356: WSH_TP_RELEASE.calculate_cont_del_tpdates(
1357: p_entity => 'DLVY',
1358: p_entity_ids =>l_del_tab,
1382: );
1383: --
1384: --
1385: IF l_debug_on THEN
1386: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1387: END IF;
1388: --
1389: --
1390: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1412: p_reset_flags => FALSE,
1413: x_return_status => l_return_status);
1414:
1415: IF l_debug_on THEN
1416: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1417: END IF;
1418: END IF; --}
1419: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1420: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
1446:
1447: IF FND_API.TO_BOOLEAN(p_commit) THEN
1448:
1449: IF l_debug_on THEN
1450: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1451: END IF;
1452: WSH_UTIL_CORE.reset_stops_for_load_tender(
1453: p_reset_flags => TRUE,
1454: x_return_status => l_return_status);
1454: x_return_status => l_return_status);
1455: ELSE
1456:
1457: IF l_debug_on THEN
1458: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1459: END IF;
1460: WSH_UTIL_CORE.Process_stops_for_load_tender(
1461: p_reset_flags => TRUE,
1462: x_return_status => l_return_status);
1462: x_return_status => l_return_status);
1463: END IF;
1464:
1465: IF l_debug_on THEN
1466: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1467: END IF;
1468:
1469: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1470: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1493: --
1494: -- Debug Statements
1495: --
1496: IF l_debug_on THEN
1497: WSH_DEBUG_SV.pop(l_module_name);
1498: END IF;
1499: --
1500: EXCEPTION
1501:
1516: --Bugfix 4070732 {
1517: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1518: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1519: IF l_debug_on THEN
1520: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1521: END IF;
1522:
1523: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1524: x_return_status => l_return_status);
1524: x_return_status => l_return_status);
1525:
1526:
1527: IF l_debug_on THEN
1528: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1529: END IF;
1530:
1531: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1546: --
1547: -- Debug Statements
1548: --
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
1552: END IF;
1553: --
1554:
1547: -- Debug Statements
1548: --
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
1552: END IF;
1553: --
1554:
1555: WHEN FND_API.G_EXC_ERROR then
1558:
1559: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1560: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1561: IF l_debug_on THEN
1562: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1563: END IF;
1564:
1565: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1566: x_return_status => l_return_status);
1566: x_return_status => l_return_status);
1567:
1568:
1569: IF l_debug_on THEN
1570: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1571: END IF;
1572:
1573: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1574: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1588: --
1589: -- Debug Statements
1590: --
1591: IF l_debug_on THEN
1592: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1593: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_EXC_ERROR');
1594: END IF;
1595: --
1596: WHEN WSH_INVALID_CONT then
1589: -- Debug Statements
1590: --
1591: IF l_debug_on THEN
1592: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1593: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_EXC_ERROR');
1594: END IF;
1595: --
1596: WHEN WSH_INVALID_CONT then
1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1610: --Bugfix 4070732 {
1611: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1612: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1613: IF l_debug_on THEN
1614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1615: END IF;
1616:
1617: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1618: x_return_status => l_return_status);
1618: x_return_status => l_return_status);
1619:
1620:
1621: IF l_debug_on THEN
1622: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1623: END IF;
1624: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1625: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1626: END IF;
1639: --
1640: -- Debug Statements
1641: --
1642: IF l_debug_on THEN
1643: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');
1645: END IF;
1646: --
1647: WHEN WSH_INVALID_DELIVERY then
1640: -- Debug Statements
1641: --
1642: IF l_debug_on THEN
1643: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');
1645: END IF;
1646: --
1647: WHEN WSH_INVALID_DELIVERY then
1648: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1662: --Bugfix 4070732 {
1663: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1664: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1665: IF l_debug_on THEN
1666: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1667: END IF;
1668:
1669: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1670: x_return_status => l_return_status);
1670: x_return_status => l_return_status);
1671:
1672:
1673: IF l_debug_on THEN
1674: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1675: END IF;
1676: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1677: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1678: END IF;
1691: --
1692: -- Debug Statements
1693: --
1694: IF l_debug_on THEN
1695: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
1697: END IF;
1698: --
1699: WHEN WSH_UTIL_CORE.G_EXC_WARNING then
1692: -- Debug Statements
1693: --
1694: IF l_debug_on THEN
1695: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
1697: END IF;
1698: --
1699: WHEN WSH_UTIL_CORE.G_EXC_WARNING then
1700: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1712: );
1713: --
1714: --
1715: IF l_debug_on THEN
1716: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1717: END IF;
1718: --
1719: --
1720: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1730: --Bugfix 4070732 {
1731: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1732: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1733: IF l_debug_on THEN
1734: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1735: END IF;
1736:
1737: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1738: x_return_status => l_return_status);
1737: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1738: x_return_status => l_return_status);
1739:
1740: IF l_debug_on THEN
1741: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1742: END IF;
1743:
1744: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1745: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1758: , p_data => x_msg_data
1759: , p_encoded => FND_API.G_FALSE
1760: );
1761: IF l_debug_on THEN
1762: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1763: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');
1764: END IF;
1765: --
1766: WHEN WSH_FAIL_AUTOPACK then
1759: , p_encoded => FND_API.G_FALSE
1760: );
1761: IF l_debug_on THEN
1762: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1763: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');
1764: END IF;
1765: --
1766: WHEN WSH_FAIL_AUTOPACK then
1767: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1771: --Bugfix 4070732 {
1772: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1773: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1774: IF l_debug_on THEN
1775: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1776: END IF;
1777:
1778: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1779: x_return_status => l_return_status);
1779: x_return_status => l_return_status);
1780:
1781:
1782: IF l_debug_on THEN
1783: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1784: END IF;
1785:
1786: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1787: X_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1796: , p_data => x_msg_data
1797: , p_encoded => FND_API.G_FALSE
1798: );
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_AUTOPACK exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_AUTOPACK');
1802: END IF;
1803: --
1804: WHEN WSH_INVALID_ENTITY_TYPE then
1797: , p_encoded => FND_API.G_FALSE
1798: );
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_AUTOPACK exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_AUTOPACK');
1802: END IF;
1803: --
1804: WHEN WSH_INVALID_ENTITY_TYPE then
1805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1818: --Bugfix 4070732 {
1819: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1820: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1821: IF l_debug_on THEN
1822: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1823: END IF;
1824:
1825: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1826: x_return_status => l_return_status);
1826: x_return_status => l_return_status);
1827:
1828:
1829: IF l_debug_on THEN
1830: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1831: END IF;
1832: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1833: X_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1834: END IF;
1848: --
1849: -- Debug Statements
1850: --
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
1854: END IF;
1855: --
1856: WHEN OTHERS then
1849: -- Debug Statements
1850: --
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
1854: END IF;
1855: --
1856: WHEN OTHERS then
1857: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Auto_Pack');
1871: --Bugfix 4070732 {
1872: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1873: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1874: IF l_debug_on THEN
1875: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1876: END IF;
1877:
1878: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1879: x_return_status => l_return_status);
1879: x_return_status => l_return_status);
1880:
1881:
1882: IF l_debug_on THEN
1883: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1884: END IF;
1885:
1886: END IF;
1887: END IF;
1898: --
1899: -- Debug Statements
1900: --
1901: IF l_debug_on THEN
1902: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1903: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1904: END IF;
1905: --
1906: END Auto_Pack;
1899: -- Debug Statements
1900: --
1901: IF l_debug_on THEN
1902: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1903: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1904: END IF;
1905: --
1906: END Auto_Pack;
1907:
2068: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2069: --
2070: IF l_debug_on IS NULL
2071: THEN
2072: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2073: END IF;
2074: --
2075: SAVEPOINT Container_Action_SP_Grp;
2076: --
2074: --
2075: SAVEPOINT Container_Action_SP_Grp;
2076: --
2077: IF l_debug_on THEN
2078: WSH_DEBUG_SV.push(l_module_name);
2079: --
2080: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2081: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2082: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2076: --
2077: IF l_debug_on THEN
2078: WSH_DEBUG_SV.push(l_module_name);
2079: --
2080: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2081: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2082: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2083: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2084: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2077: IF l_debug_on THEN
2078: WSH_DEBUG_SV.push(l_module_name);
2079: --
2080: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2081: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2082: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2083: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2084: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2085: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2078: WSH_DEBUG_SV.push(l_module_name);
2079: --
2080: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2081: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2082: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2083: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2084: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2085: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2086: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2079: --
2080: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2081: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2082: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2083: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2084: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2085: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2086: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2087: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2080: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2081: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2082: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2083: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2084: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2085: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2086: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2087: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2088: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2081: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2082: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2083: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2084: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2085: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2086: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2087: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2088: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2089: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2082: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2083: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2084: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2085: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2086: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2087: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2088: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2089: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2090: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2083: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2084: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2085: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2086: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2087: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2088: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2089: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2090: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2091: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2084: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2085: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2086: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2087: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2088: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2089: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2090: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2091: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2092: END IF;
2085: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2086: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2087: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2088: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2089: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2090: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2091: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2092: END IF;
2093: --
2086: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2087: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2088: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2089: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2090: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2091: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2092: END IF;
2093: --
2094: -- Check p_init_msg_list
2087: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2088: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2089: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2090: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2091: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2092: END IF;
2093: --
2094: -- Check p_init_msg_list
2095: IF FND_API.to_boolean(p_init_msg_list) THEN
2134: l_verify_org := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONTAINER_ORG_LVL);
2135: l_verify_dlvy := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONT_DLVY_LVL);
2136:
2137: IF l_debug_on THEN
2138: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2139: ,l_verify_status_lvl);
2140: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2141: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2142: END IF;
2136:
2137: IF l_debug_on THEN
2138: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2139: ,l_verify_status_lvl);
2140: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2141: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2142: END IF;
2143:
2144: l_next := p_detail_tab.first;
2137: IF l_debug_on THEN
2138: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2139: ,l_verify_status_lvl);
2140: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2141: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2142: END IF;
2143:
2144: l_next := p_detail_tab.first;
2145: WHILE l_next IS NOT NULL LOOP
2212: IF UPPER(p_action_code) in ('PACK','UNPACK') THEN
2213: IF l_verify_org=1 THEN
2214: l_wms_enabled_flag := WSH_UTIL_VALIDATE.check_wms_org(l_cont_org_id);
2215: IF l_debug_on THEN
2216: WSH_DEBUG_SV.log(l_module_name,'l_wms_enabled_flag'
2217: ,l_wms_enabled_flag);
2218: END IF;
2219:
2220: IF NVL(l_wms_enabled_flag,'N') = 'Y' THEN
2242: END IF;
2243: ELSE l_cont_instance_id := p_cont_instance_id;
2244: END IF;
2245: IF l_debug_on THEN
2246: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2247: ,l_verify_status_lvl);
2248: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2249: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2250: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2244: END IF;
2245: IF l_debug_on THEN
2246: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2247: ,l_verify_status_lvl);
2248: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2249: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2250: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2251: ,l_cont_instance_id);
2252: END IF;
2245: IF l_debug_on THEN
2246: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2247: ,l_verify_status_lvl);
2248: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2249: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2250: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2251: ,l_cont_instance_id);
2252: END IF;
2253: IF l_verify_status_lvl =1 OR l_verify_org=1 OR l_verify_dlvy=1 THEN
2246: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2247: ,l_verify_status_lvl);
2248: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2249: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2250: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2251: ,l_cont_instance_id);
2252: END IF;
2253: IF l_verify_status_lvl =1 OR l_verify_org=1 OR l_verify_dlvy=1 THEN
2254:
2266: ELSE
2267: CLOSE Check_Detail;
2268: END IF;
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2271: ,l_cont_instance_id);
2272: WSH_DEBUG_SV.log(l_module_name,'l_cont_flag',l_cont_flag);
2273: WSH_DEBUG_SV.log(l_module_name,'l_cont_released_status'
2274: ,l_cont_released_status);
2268: END IF;
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2271: ,l_cont_instance_id);
2272: WSH_DEBUG_SV.log(l_module_name,'l_cont_flag',l_cont_flag);
2273: WSH_DEBUG_SV.log(l_module_name,'l_cont_released_status'
2274: ,l_cont_released_status);
2275: WSH_DEBUG_SV.log(l_module_name,'l_cont_org_id',l_cont_org_id);
2276: WSH_DEBUG_SV.log(l_module_name,'l_delivery_id',l_delivery_id);
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2271: ,l_cont_instance_id);
2272: WSH_DEBUG_SV.log(l_module_name,'l_cont_flag',l_cont_flag);
2273: WSH_DEBUG_SV.log(l_module_name,'l_cont_released_status'
2274: ,l_cont_released_status);
2275: WSH_DEBUG_SV.log(l_module_name,'l_cont_org_id',l_cont_org_id);
2276: WSH_DEBUG_SV.log(l_module_name,'l_delivery_id',l_delivery_id);
2277: END IF;
2271: ,l_cont_instance_id);
2272: WSH_DEBUG_SV.log(l_module_name,'l_cont_flag',l_cont_flag);
2273: WSH_DEBUG_SV.log(l_module_name,'l_cont_released_status'
2274: ,l_cont_released_status);
2275: WSH_DEBUG_SV.log(l_module_name,'l_cont_org_id',l_cont_org_id);
2276: WSH_DEBUG_SV.log(l_module_name,'l_delivery_id',l_delivery_id);
2277: END IF;
2278:
2279: IF l_verify_status_lvl=1 THEN
2272: WSH_DEBUG_SV.log(l_module_name,'l_cont_flag',l_cont_flag);
2273: WSH_DEBUG_SV.log(l_module_name,'l_cont_released_status'
2274: ,l_cont_released_status);
2275: WSH_DEBUG_SV.log(l_module_name,'l_cont_org_id',l_cont_org_id);
2276: WSH_DEBUG_SV.log(l_module_name,'l_delivery_id',l_delivery_id);
2277: END IF;
2278:
2279: IF l_verify_status_lvl=1 THEN
2280: IF (nvl(l_cont_flag,'N') = 'N')
2291: ELSE
2292: CLOSE c_dlvy;
2293: END IF;
2294: IF l_debug_on THEN
2295: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_status_code'
2296: ,l_dlvy_status_code);
2297: END IF;
2298: IF l_dlvy_status_code <> 'OP' THEN
2299: RAISE WSH_INVALID_DELIVERY ;
2315: -- call the private APIs to assign/unassign..
2316:
2317: IF (UPPER(p_action_code) = 'PACK') OR (UPPER(p_action_code) = 'ASSIGN') THEN
2318: IF l_debug_on THEN
2319: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.ASSIGN_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2320: END IF;
2321: --
2322: WSH_DLVB_COMMON_ACTIONS.Assign_Details (
2323: p_detail_tab => l_detail_tab,
2336: ELSE
2337: --Start of fix for bug 5234326/5282496
2338: IF ( l_cont_instance_id IS NOT NULL ) THEN
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TP_RELEASE.CALCULATE_CONT_DEL_TPDATES for entity LPN',WSH_DEBUG_SV.C_PROC_LEVEL);
2341: END IF;
2342:
2343: l_cont_tab(1) := l_cont_instance_id;
2344: WSH_TP_RELEASE.calculate_cont_del_tpdates(
2346: p_entity_ids =>l_cont_tab,
2347: x_return_status => x_return_status);
2348: ELSE
2349: IF l_debug_on THEN
2350: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TP_RELEASE.CALCULATE_CONT_DEL_TPDATES for entity DLVB',WSH_DEBUG_SV.C_PROC_LEVEL);
2351: END IF;
2352: WSH_TP_RELEASE.calculate_cont_del_tpdates(
2353: p_entity => 'DLVB',
2354: p_entity_ids =>l_detail_tab,
2358:
2359: END IF;
2360: ELSIF (UPPER(p_action_code) = 'UNPACK') OR (UPPER(p_action_code) = 'UNASSIGN') THEN
2361: IF l_debug_on THEN
2362: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.UNASSIGN_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2363: END IF;
2364: WSH_DLVB_COMMON_ACTIONS.Unassign_Details (
2365: p_detail_tab => l_detail_tab,
2366: p_parent_detail_flag => p_container_flag,
2393: );
2394: --
2395: --
2396: IF l_debug_on THEN
2397: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2398: WSH_DEBUG_SV.log(l_module_name,'Msg Count after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_msg_count);
2399: END IF;
2400: --
2401: --
2394: --
2395: --
2396: IF l_debug_on THEN
2397: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2398: WSH_DEBUG_SV.log(l_module_name,'Msg Count after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_msg_count);
2399: END IF;
2400: --
2401: --
2402: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2452: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2453: IF FND_API.TO_BOOLEAN(p_commit) THEN
2454:
2455: IF l_debug_on THEN
2456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2457: END IF;
2458: WSH_UTIL_CORE.reset_stops_for_load_tender(
2459: p_reset_flags => TRUE,
2460: x_return_status => l_return_status);
2462: ELSE
2463:
2464:
2465: IF l_debug_on THEN
2466: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2467: END IF;
2468: WSH_UTIL_CORE.Process_stops_for_load_tender(
2469: p_reset_flags => TRUE,
2470: x_return_status => l_return_status);
2470: x_return_status => l_return_status);
2471: END IF;
2472:
2473: IF l_debug_on THEN
2474: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2475: END IF;
2476:
2477: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
2478: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2497: , p_encoded => FND_API.G_FALSE
2498: );
2499: --
2500: IF l_debug_on THEN
2501: WSH_DEBUG_SV.pop(l_module_name);
2502: END IF;
2503: --
2504: EXCEPTION
2505:
2519: );
2520: --
2521: --
2522: IF l_debug_on THEN
2523: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2524: WSH_DEBUG_SV.log(l_module_name,'Msg Count after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_msg_count);
2525: END IF;
2526: --
2527: --
2520: --
2521: --
2522: IF l_debug_on THEN
2523: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2524: WSH_DEBUG_SV.log(l_module_name,'Msg Count after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_msg_count);
2525: END IF;
2526: --
2527: --
2528: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2538: --Bugfix 4070732 {
2539: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2540: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2541: IF l_debug_on THEN
2542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2543: END IF;
2544:
2545: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
2546: x_return_status => l_return_status);
2545: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
2546: x_return_status => l_return_status);
2547:
2548: IF l_debug_on THEN
2549: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2550: END IF;
2551:
2552: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2553: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2563: , p_data => x_msg_data
2564: , p_encoded => FND_API.G_FALSE
2565: );
2566: IF l_debug_on THEN
2567: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2568: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');
2569: END IF;
2570:
2571: WHEN WSH_INVALID_DETAIL then
2564: , p_encoded => FND_API.G_FALSE
2565: );
2566: IF l_debug_on THEN
2567: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2568: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');
2569: END IF;
2570:
2571: WHEN WSH_INVALID_DETAIL then
2572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2585: --Bugfix 4070732 {
2586: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2587: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2588: IF l_debug_on THEN
2589: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2590: END IF;
2591:
2592: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2593: x_return_status => l_return_status);
2593: x_return_status => l_return_status);
2594:
2595:
2596: IF l_debug_on THEN
2597: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2598: END IF;
2599:
2600: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2601: x_return_status := l_return_status;
2611: , p_data => x_msg_data
2612: , p_encoded => FND_API.G_FALSE
2613: );
2614: IF l_debug_on THEN
2615: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
2617: END IF;
2618:
2619: WHEN WSH_INVALID_CONT then
2612: , p_encoded => FND_API.G_FALSE
2613: );
2614: IF l_debug_on THEN
2615: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
2617: END IF;
2618:
2619: WHEN WSH_INVALID_CONT then
2620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2633: --Bugfix 4070732 {
2634: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2635: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2636: IF l_debug_on THEN
2637: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2638: END IF;
2639:
2640: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2641: x_return_status => l_return_status);
2641: x_return_status => l_return_status);
2642:
2643:
2644: IF l_debug_on THEN
2645: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2646: END IF;
2647:
2648: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2649: x_return_status := l_return_status;
2658: , p_data => x_msg_data
2659: , p_encoded => FND_API.G_FALSE
2660: );
2661: IF l_debug_on THEN
2662: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2663: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');
2664: END IF;
2665: --
2666: WHEN WSH_INVALID_DELIVERY then
2659: , p_encoded => FND_API.G_FALSE
2660: );
2661: IF l_debug_on THEN
2662: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2663: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');
2664: END IF;
2665: --
2666: WHEN WSH_INVALID_DELIVERY then
2667: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2680: --Bugfix 4070732 {
2681: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2682: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2683: IF l_debug_on THEN
2684: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2685: END IF;
2686:
2687: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2688: x_return_status => l_return_status);
2688: x_return_status => l_return_status);
2689:
2690:
2691: IF l_debug_on THEN
2692: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2693: END IF;
2694:
2695: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2696: x_return_status := l_return_status;
2705: , p_data => x_msg_data
2706: , p_encoded => FND_API.G_FALSE
2707: );
2708: IF l_debug_on THEN
2709: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2710: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
2711: END IF;
2712: --
2713: WHEN WSH_FAIL_CONT_ACTION then
2706: , p_encoded => FND_API.G_FALSE
2707: );
2708: IF l_debug_on THEN
2709: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2710: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
2711: END IF;
2712: --
2713: WHEN WSH_FAIL_CONT_ACTION then
2714: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2727: --Bugfix 4070732 {
2728: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2729: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2730: IF l_debug_on THEN
2731: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2732: END IF;
2733:
2734: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2735: x_return_status => l_return_status);
2735: x_return_status => l_return_status);
2736:
2737:
2738: IF l_debug_on THEN
2739: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2740: END IF;
2741:
2742: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2743: x_return_status := l_return_status;
2752: , p_data => x_msg_data
2753: , p_encoded => FND_API.G_FALSE
2754: );
2755: IF l_debug_on THEN
2756: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_ACTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_ACTION');
2758: END IF;
2759: --
2760: WHEN WSH_INVALID_ENTITY_TYPE then
2753: , p_encoded => FND_API.G_FALSE
2754: );
2755: IF l_debug_on THEN
2756: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_ACTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_ACTION');
2758: END IF;
2759: --
2760: WHEN WSH_INVALID_ENTITY_TYPE then
2761: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2773: --Bugfix 4070732 {
2774: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2775: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2776: IF l_debug_on THEN
2777: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2778: END IF;
2779:
2780: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2781: x_return_status => l_return_status);
2781: x_return_status => l_return_status);
2782:
2783:
2784: IF l_debug_on THEN
2785: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2786: END IF;
2787:
2788: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2789: x_return_status := l_return_status;
2798: , p_data => x_msg_data
2799: , p_encoded => FND_API.G_FALSE
2800: );
2801: IF l_debug_on THEN
2802: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2803: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
2804: END IF;
2805: --
2806: WHEN FND_API.G_EXC_ERROR THEN
2799: , p_encoded => FND_API.G_FALSE
2800: );
2801: IF l_debug_on THEN
2802: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2803: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
2804: END IF;
2805: --
2806: WHEN FND_API.G_EXC_ERROR THEN
2807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2809: --Bugfix 4070732 {
2810: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2811: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2812: IF l_debug_on THEN
2813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2814: END IF;
2815:
2816: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2817: x_return_status => l_return_status);
2817: x_return_status => l_return_status);
2818:
2819:
2820: IF l_debug_on THEN
2821: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2822: END IF;
2823: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2824: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2825: END IF;
2835: , p_encoded => FND_API.G_FALSE
2836: );
2837:
2838: IF l_debug_on THEN
2839: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2840: WSH_DEBUG_SV.pop(l_module_name);
2841: END IF;
2842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2843: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2836: );
2837:
2838: IF l_debug_on THEN
2839: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2840: WSH_DEBUG_SV.pop(l_module_name);
2841: END IF;
2842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2843: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2844: rollback to Container_Action_SP_Grp;
2845: --Bugfix 4070732 {
2846: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2847: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2848: IF l_debug_on THEN
2849: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2850: END IF;
2851:
2852: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2853: x_return_status => l_return_status);
2853: x_return_status => l_return_status);
2854:
2855:
2856: IF l_debug_on THEN
2857: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2858: END IF;
2859:
2860: END IF;
2861: END IF;
2868: , p_encoded => FND_API.G_FALSE
2869: );
2870:
2871: IF l_debug_on THEN
2872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2873: WSH_DEBUG_SV.pop(l_module_name);
2874: END IF;
2875: WHEN OTHERS then
2876: wsh_util_core.default_handler('WSH_CONTAINER_GRP.Container_Actions');
2869: );
2870:
2871: IF l_debug_on THEN
2872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2873: WSH_DEBUG_SV.pop(l_module_name);
2874: END IF;
2875: WHEN OTHERS then
2876: wsh_util_core.default_handler('WSH_CONTAINER_GRP.Container_Actions');
2877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2887: --Bugfix 4070732 {
2888: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2889: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2890: IF l_debug_on THEN
2891: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2892: END IF;
2893:
2894: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2895: x_return_status => l_return_status);
2895: x_return_status => l_return_status);
2896:
2897:
2898: IF l_debug_on THEN
2899: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2900: END IF;
2901:
2902: END IF;
2903: END IF;
2910: , p_encoded => FND_API.G_FALSE
2911: );
2912:
2913: IF l_debug_on THEN
2914: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2915: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2916: END IF;
2917: --
2918: END Container_Actions;
2911: );
2912:
2913: IF l_debug_on THEN
2914: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2915: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2916: END IF;
2917: --
2918: END Container_Actions;
2919: