[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:
1202: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1203: --
1204: IF l_debug_on IS NULL
1205: THEN
1206: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1207: END IF;
1208: --
1209: IF l_debug_on THEN
1210: WSH_DEBUG_SV.push(l_module_name);
1206: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1207: END IF;
1208: --
1209: IF l_debug_on THEN
1210: WSH_DEBUG_SV.push(l_module_name);
1211: --
1212: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1213: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1214: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1208: --
1209: IF l_debug_on THEN
1210: WSH_DEBUG_SV.push(l_module_name);
1211: --
1212: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1213: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1214: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1215: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1216: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1209: IF l_debug_on THEN
1210: WSH_DEBUG_SV.push(l_module_name);
1211: --
1212: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1213: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1214: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1215: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1216: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1217: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1210: WSH_DEBUG_SV.push(l_module_name);
1211: --
1212: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1213: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1214: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1215: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1216: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1217: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1218: END IF;
1211: --
1212: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1213: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1214: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1215: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1216: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1217: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1218: END IF;
1219: --
1212: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1213: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1214: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1215: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1216: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1217: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1218: END IF;
1219: --
1220: SAVEPOINT Autopack_SP_Grp;
1213: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1214: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1215: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1216: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
1217: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1218: END IF;
1219: --
1220: SAVEPOINT Autopack_SP_Grp;
1221:
1273: --
1274: -- Debug Statements
1275: --
1276: IF l_debug_on THEN
1277: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.AUTO_PACK_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);
1278: END IF;
1279: --
1280: WSH_DLVB_COMMON_ACTIONS.Auto_Pack_Lines (
1281: p_group_id_tab => p_group_id_tab,
1301: END IF;
1302: ELSE
1303: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1304: IF l_debug_on THEN
1305: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TP_RELEASE.CALCULATE_CONT_DEL_TPDATES',WSH_DEBUG_SV.C_PROC_LEVEL);
1306: END IF;
1307: WSH_TP_RELEASE.calculate_cont_del_tpdates(
1308: p_entity => 'DLVB',
1309: p_entity_ids =>x_cont_inst_tab,
1359: --
1360: -- Debug Statements
1361: --
1362: IF l_debug_on THEN
1363: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1364: END IF;
1365: --
1366: WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery (
1367: l_del_tab,
1384: RAISE WSH_FAIL_AUTOPACK;
1385: END IF;
1386: ELSE
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TP_RELEASE.CALCULATE_CONT_DEL_TPDATES',WSH_DEBUG_SV.C_PROC_LEVEL);
1389: END IF;
1390: WSH_TP_RELEASE.calculate_cont_del_tpdates(
1391: p_entity => 'DLVY',
1392: p_entity_ids =>l_del_tab,
1444: );
1445: --
1446: --
1447: IF l_debug_on THEN
1448: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1449: END IF;
1450: --
1451: --
1452: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1474: p_reset_flags => FALSE,
1475: x_return_status => l_return_status);
1476:
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1479: END IF;
1480: END IF; --}
1481: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1482: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
1508:
1509: IF FND_API.TO_BOOLEAN(p_commit) THEN
1510:
1511: IF l_debug_on THEN
1512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1513: END IF;
1514: WSH_UTIL_CORE.reset_stops_for_load_tender(
1515: p_reset_flags => TRUE,
1516: x_return_status => l_return_status);
1516: x_return_status => l_return_status);
1517: ELSE
1518:
1519: IF l_debug_on THEN
1520: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1521: END IF;
1522: WSH_UTIL_CORE.Process_stops_for_load_tender(
1523: p_reset_flags => TRUE,
1524: x_return_status => l_return_status);
1524: x_return_status => l_return_status);
1525: END IF;
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 IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1532: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1555: --
1556: -- Debug Statements
1557: --
1558: IF l_debug_on THEN
1559: WSH_DEBUG_SV.pop(l_module_name);
1560: END IF;
1561: --
1562: EXCEPTION
1563:
1578: --Bugfix 4070732 {
1579: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1580: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1581: IF l_debug_on THEN
1582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1583: END IF;
1584:
1585: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1586: x_return_status => l_return_status);
1586: x_return_status => l_return_status);
1587:
1588:
1589: IF l_debug_on THEN
1590: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1591: END IF;
1592:
1593: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1608: --
1609: -- Debug Statements
1610: --
1611: IF l_debug_on THEN
1612: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
1614: END IF;
1615: --
1616:
1609: -- Debug Statements
1610: --
1611: IF l_debug_on THEN
1612: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
1614: END IF;
1615: --
1616:
1617: WHEN FND_API.G_EXC_ERROR then
1620:
1621: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1622: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1625: END IF;
1626:
1627: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1628: x_return_status => l_return_status);
1628: x_return_status => l_return_status);
1629:
1630:
1631: IF l_debug_on THEN
1632: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1633: END IF;
1634:
1635: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1636: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1650: --
1651: -- Debug Statements
1652: --
1653: IF l_debug_on THEN
1654: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1655: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_EXC_ERROR');
1656: END IF;
1657: --
1658: WHEN WSH_INVALID_CONT then
1651: -- Debug Statements
1652: --
1653: IF l_debug_on THEN
1654: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1655: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_EXC_ERROR');
1656: END IF;
1657: --
1658: WHEN WSH_INVALID_CONT then
1659: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1672: --Bugfix 4070732 {
1673: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1674: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1675: IF l_debug_on THEN
1676: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1677: END IF;
1678:
1679: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1680: x_return_status => l_return_status);
1680: x_return_status => l_return_status);
1681:
1682:
1683: IF l_debug_on THEN
1684: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1685: END IF;
1686: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1687: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1688: END IF;
1701: --
1702: -- Debug Statements
1703: --
1704: IF l_debug_on THEN
1705: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');
1707: END IF;
1708: --
1709: WHEN WSH_INVALID_DELIVERY then
1702: -- Debug Statements
1703: --
1704: IF l_debug_on THEN
1705: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');
1707: END IF;
1708: --
1709: WHEN WSH_INVALID_DELIVERY then
1710: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1724: --Bugfix 4070732 {
1725: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1726: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1729: END IF;
1730:
1731: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1732: x_return_status => l_return_status);
1732: x_return_status => l_return_status);
1733:
1734:
1735: IF l_debug_on THEN
1736: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1737: END IF;
1738: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1739: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1740: END IF;
1753: --
1754: -- Debug Statements
1755: --
1756: IF l_debug_on THEN
1757: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1758: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
1759: END IF;
1760: --
1761: WHEN WSH_UTIL_CORE.G_EXC_WARNING then
1754: -- Debug Statements
1755: --
1756: IF l_debug_on THEN
1757: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1758: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
1759: END IF;
1760: --
1761: WHEN WSH_UTIL_CORE.G_EXC_WARNING then
1762: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1774: );
1775: --
1776: --
1777: IF l_debug_on THEN
1778: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1779: END IF;
1780: --
1781: --
1782: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1792: --Bugfix 4070732 {
1793: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1794: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1795: IF l_debug_on THEN
1796: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1797: END IF;
1798:
1799: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1800: x_return_status => l_return_status);
1799: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1800: x_return_status => l_return_status);
1801:
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1804: END IF;
1805:
1806: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1807: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1820: , p_data => x_msg_data
1821: , p_encoded => FND_API.G_FALSE
1822: );
1823: IF l_debug_on THEN
1824: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1825: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');
1826: END IF;
1827: --
1828: WHEN WSH_FAIL_AUTOPACK then
1821: , p_encoded => FND_API.G_FALSE
1822: );
1823: IF l_debug_on THEN
1824: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1825: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');
1826: END IF;
1827: --
1828: WHEN WSH_FAIL_AUTOPACK then
1829: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1833: --Bugfix 4070732 {
1834: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1835: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1836: IF l_debug_on THEN
1837: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1838: END IF;
1839:
1840: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1841: x_return_status => l_return_status);
1841: x_return_status => l_return_status);
1842:
1843:
1844: IF l_debug_on THEN
1845: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1846: END IF;
1847:
1848: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1849: X_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1858: , p_data => x_msg_data
1859: , p_encoded => FND_API.G_FALSE
1860: );
1861: IF l_debug_on THEN
1862: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_AUTOPACK exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_AUTOPACK');
1864: END IF;
1865: --
1866: WHEN WSH_INVALID_ENTITY_TYPE then
1859: , p_encoded => FND_API.G_FALSE
1860: );
1861: IF l_debug_on THEN
1862: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_AUTOPACK exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_AUTOPACK');
1864: END IF;
1865: --
1866: WHEN WSH_INVALID_ENTITY_TYPE then
1867: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1880: --Bugfix 4070732 {
1881: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1882: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1883: IF l_debug_on THEN
1884: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1885: END IF;
1886:
1887: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1888: x_return_status => l_return_status);
1888: x_return_status => l_return_status);
1889:
1890:
1891: IF l_debug_on THEN
1892: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1893: END IF;
1894: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1895: X_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1896: END IF;
1910: --
1911: -- Debug Statements
1912: --
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1915: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
1916: END IF;
1917: --
1918: WHEN OTHERS then
1911: -- Debug Statements
1912: --
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1915: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
1916: END IF;
1917: --
1918: WHEN OTHERS then
1919: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Auto_Pack');
1933: --Bugfix 4070732 {
1934: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1935: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1936: IF l_debug_on THEN
1937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1938: END IF;
1939:
1940: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1941: x_return_status => l_return_status);
1941: x_return_status => l_return_status);
1942:
1943:
1944: IF l_debug_on THEN
1945: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1946: END IF;
1947:
1948: END IF;
1949: END IF;
1960: --
1961: -- Debug Statements
1962: --
1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1966: END IF;
1967: --
1968: END Auto_Pack;
1961: -- Debug Statements
1962: --
1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1966: END IF;
1967: --
1968: END Auto_Pack;
1969:
2130: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2131: --
2132: IF l_debug_on IS NULL
2133: THEN
2134: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2135: END IF;
2136: --
2137: SAVEPOINT Container_Action_SP_Grp;
2138: --
2136: --
2137: SAVEPOINT Container_Action_SP_Grp;
2138: --
2139: IF l_debug_on THEN
2140: WSH_DEBUG_SV.push(l_module_name);
2141: --
2142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2138: --
2139: IF l_debug_on THEN
2140: WSH_DEBUG_SV.push(l_module_name);
2141: --
2142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2146: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2139: IF l_debug_on THEN
2140: WSH_DEBUG_SV.push(l_module_name);
2141: --
2142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2146: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2147: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2140: WSH_DEBUG_SV.push(l_module_name);
2141: --
2142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2146: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2147: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2148: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2141: --
2142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2146: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2147: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2148: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2149: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2146: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2147: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2148: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2149: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2150: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2146: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2147: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2148: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2149: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2150: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2151: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2146: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2147: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2148: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2149: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2150: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2151: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2152: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2146: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2147: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2148: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2149: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2150: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2151: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2152: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2153: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2146: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
2147: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2148: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2149: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2150: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2151: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2152: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2153: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2154: END IF;
2147: WSH_DEBUG_SV.log(l_module_name,'P_CONT_INSTANCE_ID',P_CONT_INSTANCE_ID);
2148: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2149: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2150: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2151: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2152: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2153: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2154: END IF;
2155: --
2148: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
2149: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2150: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2151: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2152: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2153: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2154: END IF;
2155: --
2156: -- Check p_init_msg_list
2149: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
2150: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2151: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2152: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
2153: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2154: END IF;
2155: --
2156: -- Check p_init_msg_list
2157: IF FND_API.to_boolean(p_init_msg_list) THEN
2196: l_verify_org := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONTAINER_ORG_LVL);
2197: l_verify_dlvy := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONT_DLVY_LVL);
2198:
2199: IF l_debug_on THEN
2200: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2201: ,l_verify_status_lvl);
2202: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2203: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2204: END IF;
2198:
2199: IF l_debug_on THEN
2200: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2201: ,l_verify_status_lvl);
2202: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2203: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2204: END IF;
2205:
2206: l_next := p_detail_tab.first;
2199: IF l_debug_on THEN
2200: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2201: ,l_verify_status_lvl);
2202: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2203: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2204: END IF;
2205:
2206: l_next := p_detail_tab.first;
2207: WHILE l_next IS NOT NULL LOOP
2274: IF UPPER(p_action_code) in ('PACK','UNPACK') THEN
2275: IF l_verify_org=1 THEN
2276: l_wms_enabled_flag := WSH_UTIL_VALIDATE.check_wms_org(l_cont_org_id);
2277: IF l_debug_on THEN
2278: WSH_DEBUG_SV.log(l_module_name,'l_wms_enabled_flag'
2279: ,l_wms_enabled_flag);
2280: END IF;
2281:
2282: IF NVL(l_wms_enabled_flag,'N') = 'Y' THEN
2304: END IF;
2305: ELSE l_cont_instance_id := p_cont_instance_id;
2306: END IF;
2307: IF l_debug_on THEN
2308: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2309: ,l_verify_status_lvl);
2310: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2311: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2312: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2306: END IF;
2307: IF l_debug_on THEN
2308: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2309: ,l_verify_status_lvl);
2310: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2311: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2312: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2313: ,l_cont_instance_id);
2314: END IF;
2307: IF l_debug_on THEN
2308: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2309: ,l_verify_status_lvl);
2310: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2311: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2312: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2313: ,l_cont_instance_id);
2314: END IF;
2315: IF l_verify_status_lvl =1 OR l_verify_org=1 OR l_verify_dlvy=1 THEN
2308: WSH_DEBUG_SV.log(l_module_name,'l_verify_status_lvl'
2309: ,l_verify_status_lvl);
2310: WSH_DEBUG_SV.log(l_module_name,'l_verify_org',l_verify_org);
2311: WSH_DEBUG_SV.log(l_module_name,'l_verify_dlvy',l_verify_dlvy);
2312: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2313: ,l_cont_instance_id);
2314: END IF;
2315: IF l_verify_status_lvl =1 OR l_verify_org=1 OR l_verify_dlvy=1 THEN
2316:
2328: ELSE
2329: CLOSE Check_Detail;
2330: END IF;
2331: IF l_debug_on THEN
2332: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2333: ,l_cont_instance_id);
2334: WSH_DEBUG_SV.log(l_module_name,'l_cont_flag',l_cont_flag);
2335: WSH_DEBUG_SV.log(l_module_name,'l_cont_released_status'
2336: ,l_cont_released_status);
2330: END IF;
2331: IF l_debug_on THEN
2332: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2333: ,l_cont_instance_id);
2334: WSH_DEBUG_SV.log(l_module_name,'l_cont_flag',l_cont_flag);
2335: WSH_DEBUG_SV.log(l_module_name,'l_cont_released_status'
2336: ,l_cont_released_status);
2337: WSH_DEBUG_SV.log(l_module_name,'l_cont_org_id',l_cont_org_id);
2338: WSH_DEBUG_SV.log(l_module_name,'l_delivery_id',l_delivery_id);
2331: IF l_debug_on THEN
2332: WSH_DEBUG_SV.log(l_module_name,'l_cont_instance_id'
2333: ,l_cont_instance_id);
2334: WSH_DEBUG_SV.log(l_module_name,'l_cont_flag',l_cont_flag);
2335: WSH_DEBUG_SV.log(l_module_name,'l_cont_released_status'
2336: ,l_cont_released_status);
2337: WSH_DEBUG_SV.log(l_module_name,'l_cont_org_id',l_cont_org_id);
2338: WSH_DEBUG_SV.log(l_module_name,'l_delivery_id',l_delivery_id);
2339: END IF;
2333: ,l_cont_instance_id);
2334: WSH_DEBUG_SV.log(l_module_name,'l_cont_flag',l_cont_flag);
2335: WSH_DEBUG_SV.log(l_module_name,'l_cont_released_status'
2336: ,l_cont_released_status);
2337: WSH_DEBUG_SV.log(l_module_name,'l_cont_org_id',l_cont_org_id);
2338: WSH_DEBUG_SV.log(l_module_name,'l_delivery_id',l_delivery_id);
2339: END IF;
2340:
2341: IF l_verify_status_lvl=1 THEN
2334: WSH_DEBUG_SV.log(l_module_name,'l_cont_flag',l_cont_flag);
2335: WSH_DEBUG_SV.log(l_module_name,'l_cont_released_status'
2336: ,l_cont_released_status);
2337: WSH_DEBUG_SV.log(l_module_name,'l_cont_org_id',l_cont_org_id);
2338: WSH_DEBUG_SV.log(l_module_name,'l_delivery_id',l_delivery_id);
2339: END IF;
2340:
2341: IF l_verify_status_lvl=1 THEN
2342: IF (nvl(l_cont_flag,'N') = 'N')
2353: ELSE
2354: CLOSE c_dlvy;
2355: END IF;
2356: IF l_debug_on THEN
2357: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_status_code'
2358: ,l_dlvy_status_code);
2359: END IF;
2360: IF l_dlvy_status_code <> 'OP' THEN
2361: RAISE WSH_INVALID_DELIVERY ;
2377: -- call the private APIs to assign/unassign..
2378:
2379: IF (UPPER(p_action_code) = 'PACK') OR (UPPER(p_action_code) = 'ASSIGN') THEN
2380: IF l_debug_on THEN
2381: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.ASSIGN_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2382: END IF;
2383: --
2384: WSH_DLVB_COMMON_ACTIONS.Assign_Details (
2385: p_detail_tab => l_detail_tab,
2398: ELSE
2399: --Start of fix for bug 5234326/5282496
2400: IF ( l_cont_instance_id IS NOT NULL ) THEN
2401: IF l_debug_on THEN
2402: 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);
2403: END IF;
2404:
2405: l_cont_tab(1) := l_cont_instance_id;
2406: WSH_TP_RELEASE.calculate_cont_del_tpdates(
2408: p_entity_ids =>l_cont_tab,
2409: x_return_status => x_return_status);
2410: ELSE
2411: IF l_debug_on THEN
2412: 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);
2413: END IF;
2414: WSH_TP_RELEASE.calculate_cont_del_tpdates(
2415: p_entity => 'DLVB',
2416: p_entity_ids =>l_detail_tab,
2420:
2421: END IF;
2422: ELSIF (UPPER(p_action_code) = 'UNPACK') OR (UPPER(p_action_code) = 'UNASSIGN') THEN
2423: IF l_debug_on THEN
2424: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.UNASSIGN_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2425: END IF;
2426: WSH_DLVB_COMMON_ACTIONS.Unassign_Details (
2427: p_detail_tab => l_detail_tab,
2428: p_parent_detail_flag => p_container_flag,
2455: );
2456: --
2457: --
2458: IF l_debug_on THEN
2459: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2460: WSH_DEBUG_SV.log(l_module_name,'Msg Count after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_msg_count);
2461: END IF;
2462: --
2463: --
2456: --
2457: --
2458: IF l_debug_on THEN
2459: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2460: WSH_DEBUG_SV.log(l_module_name,'Msg Count after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_msg_count);
2461: END IF;
2462: --
2463: --
2464: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2514: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2515: IF FND_API.TO_BOOLEAN(p_commit) THEN
2516:
2517: IF l_debug_on THEN
2518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2519: END IF;
2520: WSH_UTIL_CORE.reset_stops_for_load_tender(
2521: p_reset_flags => TRUE,
2522: x_return_status => l_return_status);
2524: ELSE
2525:
2526:
2527: IF l_debug_on THEN
2528: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2529: END IF;
2530: WSH_UTIL_CORE.Process_stops_for_load_tender(
2531: p_reset_flags => TRUE,
2532: x_return_status => l_return_status);
2532: x_return_status => l_return_status);
2533: END IF;
2534:
2535: IF l_debug_on THEN
2536: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2537: END IF;
2538:
2539: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
2540: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2559: , p_encoded => FND_API.G_FALSE
2560: );
2561: --
2562: IF l_debug_on THEN
2563: WSH_DEBUG_SV.pop(l_module_name);
2564: END IF;
2565: --
2566: EXCEPTION
2567:
2581: );
2582: --
2583: --
2584: IF l_debug_on THEN
2585: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2586: WSH_DEBUG_SV.log(l_module_name,'Msg Count after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_msg_count);
2587: END IF;
2588: --
2589: --
2582: --
2583: --
2584: IF l_debug_on THEN
2585: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2586: WSH_DEBUG_SV.log(l_module_name,'Msg Count after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_msg_count);
2587: END IF;
2588: --
2589: --
2590: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2600: --Bugfix 4070732 {
2601: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2602: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2603: IF l_debug_on THEN
2604: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2605: END IF;
2606:
2607: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
2608: x_return_status => l_return_status);
2607: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
2608: x_return_status => l_return_status);
2609:
2610: IF l_debug_on THEN
2611: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2612: END IF;
2613:
2614: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2615: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2625: , p_data => x_msg_data
2626: , p_encoded => FND_API.G_FALSE
2627: );
2628: IF l_debug_on THEN
2629: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');
2631: END IF;
2632:
2633: WHEN WSH_INVALID_DETAIL then
2626: , p_encoded => FND_API.G_FALSE
2627: );
2628: IF l_debug_on THEN
2629: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');
2631: END IF;
2632:
2633: WHEN WSH_INVALID_DETAIL then
2634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2647: --Bugfix 4070732 {
2648: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2649: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2650: IF l_debug_on THEN
2651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2652: END IF;
2653:
2654: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2655: x_return_status => l_return_status);
2655: x_return_status => l_return_status);
2656:
2657:
2658: IF l_debug_on THEN
2659: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2660: END IF;
2661:
2662: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2663: x_return_status := l_return_status;
2673: , p_data => x_msg_data
2674: , p_encoded => FND_API.G_FALSE
2675: );
2676: IF l_debug_on THEN
2677: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2678: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
2679: END IF;
2680:
2681: WHEN WSH_INVALID_CONT then
2674: , p_encoded => FND_API.G_FALSE
2675: );
2676: IF l_debug_on THEN
2677: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2678: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
2679: END IF;
2680:
2681: WHEN WSH_INVALID_CONT then
2682: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2695: --Bugfix 4070732 {
2696: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2697: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2698: IF l_debug_on THEN
2699: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2700: END IF;
2701:
2702: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2703: x_return_status => l_return_status);
2703: x_return_status => l_return_status);
2704:
2705:
2706: IF l_debug_on THEN
2707: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2708: END IF;
2709:
2710: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2711: x_return_status := l_return_status;
2720: , p_data => x_msg_data
2721: , p_encoded => FND_API.G_FALSE
2722: );
2723: IF l_debug_on THEN
2724: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');
2726: END IF;
2727: --
2728: WHEN WSH_INVALID_DELIVERY then
2721: , p_encoded => FND_API.G_FALSE
2722: );
2723: IF l_debug_on THEN
2724: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');
2726: END IF;
2727: --
2728: WHEN WSH_INVALID_DELIVERY then
2729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2742: --Bugfix 4070732 {
2743: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2744: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2745: IF l_debug_on THEN
2746: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2747: END IF;
2748:
2749: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2750: x_return_status => l_return_status);
2750: x_return_status => l_return_status);
2751:
2752:
2753: IF l_debug_on THEN
2754: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2755: END IF;
2756:
2757: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2758: x_return_status := l_return_status;
2767: , p_data => x_msg_data
2768: , p_encoded => FND_API.G_FALSE
2769: );
2770: IF l_debug_on THEN
2771: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2772: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
2773: END IF;
2774: --
2775: WHEN WSH_FAIL_CONT_ACTION then
2768: , p_encoded => FND_API.G_FALSE
2769: );
2770: IF l_debug_on THEN
2771: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2772: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
2773: END IF;
2774: --
2775: WHEN WSH_FAIL_CONT_ACTION then
2776: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2789: --Bugfix 4070732 {
2790: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2791: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2792: IF l_debug_on THEN
2793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2794: END IF;
2795:
2796: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2797: x_return_status => l_return_status);
2797: x_return_status => l_return_status);
2798:
2799:
2800: IF l_debug_on THEN
2801: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2802: END IF;
2803:
2804: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2805: x_return_status := l_return_status;
2814: , p_data => x_msg_data
2815: , p_encoded => FND_API.G_FALSE
2816: );
2817: IF l_debug_on THEN
2818: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_ACTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_ACTION');
2820: END IF;
2821: --
2822: WHEN WSH_INVALID_ENTITY_TYPE then
2815: , p_encoded => FND_API.G_FALSE
2816: );
2817: IF l_debug_on THEN
2818: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_ACTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_ACTION');
2820: END IF;
2821: --
2822: WHEN WSH_INVALID_ENTITY_TYPE then
2823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2835: --Bugfix 4070732 {
2836: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2837: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2838: IF l_debug_on THEN
2839: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2840: END IF;
2841:
2842: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2843: x_return_status => l_return_status);
2843: x_return_status => l_return_status);
2844:
2845:
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2848: END IF;
2849:
2850: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2851: x_return_status := l_return_status;
2860: , p_data => x_msg_data
2861: , p_encoded => FND_API.G_FALSE
2862: );
2863: IF l_debug_on THEN
2864: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2865: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
2866: END IF;
2867: --
2868: WHEN FND_API.G_EXC_ERROR THEN
2861: , p_encoded => FND_API.G_FALSE
2862: );
2863: IF l_debug_on THEN
2864: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2865: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
2866: END IF;
2867: --
2868: WHEN FND_API.G_EXC_ERROR THEN
2869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2871: --Bugfix 4070732 {
2872: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2873: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2874: IF l_debug_on THEN
2875: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2876: END IF;
2877:
2878: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2879: x_return_status => l_return_status);
2879: x_return_status => l_return_status);
2880:
2881:
2882: IF l_debug_on THEN
2883: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2884: END IF;
2885: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2886: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2887: END IF;
2897: , p_encoded => FND_API.G_FALSE
2898: );
2899:
2900: IF l_debug_on THEN
2901: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2902: WSH_DEBUG_SV.pop(l_module_name);
2903: END IF;
2904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2905: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2898: );
2899:
2900: IF l_debug_on THEN
2901: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2902: WSH_DEBUG_SV.pop(l_module_name);
2903: END IF;
2904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2905: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2906: rollback to Container_Action_SP_Grp;
2907: --Bugfix 4070732 {
2908: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2909: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2910: IF l_debug_on THEN
2911: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2912: END IF;
2913:
2914: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2915: x_return_status => l_return_status);
2915: x_return_status => l_return_status);
2916:
2917:
2918: IF l_debug_on THEN
2919: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2920: END IF;
2921:
2922: END IF;
2923: END IF;
2930: , p_encoded => FND_API.G_FALSE
2931: );
2932:
2933: IF l_debug_on THEN
2934: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2935: WSH_DEBUG_SV.pop(l_module_name);
2936: END IF;
2937: WHEN OTHERS then
2938: wsh_util_core.default_handler('WSH_CONTAINER_GRP.Container_Actions');
2931: );
2932:
2933: IF l_debug_on THEN
2934: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2935: WSH_DEBUG_SV.pop(l_module_name);
2936: END IF;
2937: WHEN OTHERS then
2938: wsh_util_core.default_handler('WSH_CONTAINER_GRP.Container_Actions');
2939: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2949: --Bugfix 4070732 {
2950: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2951: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2952: IF l_debug_on THEN
2953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2954: END IF;
2955:
2956: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
2957: x_return_status => l_return_status);
2957: x_return_status => l_return_status);
2958:
2959:
2960: IF l_debug_on THEN
2961: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2962: END IF;
2963:
2964: END IF;
2965: END IF;
2972: , p_encoded => FND_API.G_FALSE
2973: );
2974:
2975: IF l_debug_on THEN
2976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2977: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2978: END IF;
2979: --
2980: END Container_Actions;
2973: );
2974:
2975: IF l_debug_on THEN
2976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2977: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2978: END IF;
2979: --
2980: END Container_Actions;
2981: