[Home] [Help]
54: p_base_number IN NUMBER,
55: p_num_digits IN NUMBER,
56: p_quantity IN NUMBER,
57: p_container_name IN VARCHAR2,
58: p_lpn_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
59:
60: -- program specific out parameters
61: x_container_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
62: p_caller IN VARCHAR2 -- Has default 'WMS' in spec
57: p_container_name IN VARCHAR2,
58: p_lpn_ids IN WSH_UTIL_CORE.ID_TAB_TYPE,
59:
60: -- program specific out parameters
61: x_container_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
62: p_caller IN VARCHAR2 -- Has default 'WMS' in spec
63: ) IS
64:
65:
72: l_cont_item_seg FND_FLEX_EXT.SegmentArray;
73: l_cont_item_name VARCHAR2(30) := NULL;
74: l_cont_name VARCHAR2(30) := NULL;
75:
76: l_cont_inst_tab WSH_UTIL_CORE.ID_TAB_TYPE;
77: l_msg_summary VARCHAR2(2000) := NULL;
78: l_msg_details VARCHAR2(4000) := NULL;
79:
80: l_organization_id NUMBER := NULL;
158: IF FND_API.to_boolean(p_init_msg_list) THEN
159: FND_MSG_PUB.initialize;
160: END IF;
161:
162: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
163:
164: --lpn conv
165: -- validate quantity
166: IF NVL(p_quantity,0) <> 1 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);
184: RAISE FND_API.G_EXC_ERROR;
185: ELSIF p_lpn_ids(1) = NULL THEN
186: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
187: FND_MESSAGE.SET_TOKEN('FIELD_NAME','LPN_ID');
184: RAISE FND_API.G_EXC_ERROR;
185: ELSIF p_lpn_ids(1) = NULL THEN
186: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
187: FND_MESSAGE.SET_TOKEN('FIELD_NAME','LPN_ID');
188: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:
192: -- Bug fix 2657429
215: --
216: WSH_UTIL_VALIDATE.Validate_Org (l_organization_id,
217: l_organization_code,
218: x_return_status);
219: IF x_return_status <> wsh_util_core.g_ret_sts_success THEN
220: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ORG');
221: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
222: raise fnd_api.g_exc_error;
223: END IF;
217: l_organization_code,
218: x_return_status);
219: IF x_return_status <> wsh_util_core.g_ret_sts_success THEN
220: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ORG');
221: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
222: raise fnd_api.g_exc_error;
223: END IF;
224:
225: END IF;
251: IF (l_cont_item_id IS NULL
252: AND l_cont_item_name IS NULL
253: AND l_cont_item_seg.count = 0) then
254: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_ITEM');
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);
266: p_seg_array => l_cont_item_seg,
267: x_return_status => x_return_status,
268: p_item_type => 'CONT_ITEM');
269:
270: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
271: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_ITEM');
272: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
273: RAISE WSH_NO_INV_ITEM;
274: END IF;
268: p_item_type => 'CONT_ITEM');
269:
270: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
271: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_ITEM');
272: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
273: RAISE WSH_NO_INV_ITEM;
274: END IF;
275: END IF;
276: ELSE
275: END IF;
276: ELSE
277: fnd_message.set_name('WSH', 'WSH_INCORRECT_ORG');
278: fnd_message.set_token('ORG_CODE', l_organization_code);
279: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
280: RAISE FND_API.G_EXC_ERROR;
281: END IF; -- wms_enabled
282: END IF;
283:
300: p_detail_info_tab => l_detail_info_tab,
301: p_IN_rec => l_IN_rec,
302: x_OUT_rec => l_OUT_rec
303: );
304: IF l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)
305: THEN
306: RAISE WSH_FAIL_CONT_CREATION;
307: END IF;
308:
345: END IF;
346:
347: WHEN WSH_NO_INV_ITEM then
348: rollback to Create_Containers_SP_GRP;
349: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
350:
351: FND_MSG_PUB.Count_And_Get
352: ( p_count => x_msg_count
353: , p_data => x_msg_data
361: END IF;
362: --
363: WHEN WSH_INVALID_QTY then
364: rollback to Create_Containers_SP_GRP;
365: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
366: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_QTY');
367: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
368:
369: FND_MSG_PUB.Count_And_Get
363: WHEN WSH_INVALID_QTY then
364: rollback to Create_Containers_SP_GRP;
365: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
366: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_QTY');
367: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
368:
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count
371: , p_data => x_msg_data
378: END IF;
379: --
380: WHEN WSH_FAIL_CONT_CREATION then
381: rollback to Create_Containers_SP_GRP;
382: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
383: fnd_message.set_name('WSH', 'WSH_CONT_CREATE_ERROR');
384: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
385:
386: FND_MSG_PUB.Count_And_Get
380: WHEN WSH_FAIL_CONT_CREATION then
381: rollback to Create_Containers_SP_GRP;
382: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
383: fnd_message.set_name('WSH', 'WSH_CONT_CREATE_ERROR');
384: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
385:
386: FND_MSG_PUB.Count_And_Get
387: ( p_count => x_msg_count
388: , p_data => x_msg_data
395: END IF;
396: --
397: WHEN WSH_LPN_COUNT_INVALID then
398: rollback to Create_Containers_SP_GRP;
399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
400: fnd_message.set_name('WSH', 'WSH_LPN_COUNT_INVALID');
401: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
402:
403: FND_MSG_PUB.Count_And_Get
397: WHEN WSH_LPN_COUNT_INVALID then
398: rollback to Create_Containers_SP_GRP;
399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
400: fnd_message.set_name('WSH', 'WSH_LPN_COUNT_INVALID');
401: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
402:
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count
405: , p_data => x_msg_data
412: END IF;
413: --
414: WHEN OTHERS then
415: rollback to Create_Containers_SP_GRP;
416: wsh_util_core.default_handler('WSH_CONTAINER_GRP.Create_Containers');
417: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
418: FND_MSG_PUB.Count_And_Get
419: ( p_count => x_msg_count
420: , p_data => x_msg_data
413: --
414: WHEN OTHERS then
415: rollback to Create_Containers_SP_GRP;
416: wsh_util_core.default_handler('WSH_CONTAINER_GRP.Create_Containers');
417: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
418: FND_MSG_PUB.Count_And_Get
419: ( p_count => x_msg_count
420: , p_data => x_msg_data
421: , p_encoded => FND_API.G_FALSE
566: END IF;
567: p_caller does not exist
568: */
569:
570: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
571:
572: -- check to make sure that the container record being input for update
573: -- does not have null delivery detail ids or container name or the
574: -- container flag is null or 'N'
637: l_delivery_id,
638: l_del_status,
639: x_return_status);
640:
641: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
642: RAISE WSH_FAIL_CONT_UPDATE;
643: END IF;
644:
645: -- Bug: 1577876.
883: x_OUT_rec => l_OUT_rec
884: );
885:
886:
887: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
888: RAISE WSH_FAIL_CONT_UPDATE;
889: END IF;
890:
891: END IF; -- if p_container_rec is not null
902: , p_encoded => FND_API.G_FALSE
903: );
904:
905:
906: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
907:
908: --
909: -- Debug Statements
910: --
914: --
915: EXCEPTION
916:
917: WHEN WSH_INVALID_CONT_UPDATE then
918: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
919: rollback to Update_Containers_SP_Grp;
920: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_UPDATE');
921: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
922: /*
917: WHEN WSH_INVALID_CONT_UPDATE then
918: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
919: rollback to Update_Containers_SP_Grp;
920: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_UPDATE');
921: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
922: /*
923: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
924: if x_msg_count > 1 then
925: x_msg_data := l_msg_summary || l_msg_details;
919: rollback to Update_Containers_SP_Grp;
920: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_UPDATE');
921: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
922: /*
923: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
924: if x_msg_count > 1 then
925: x_msg_data := l_msg_summary || l_msg_details;
926: else
927: x_msg_data := l_msg_summary;
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;
946: rollback to Update_Containers_SP_Grp;
947: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
948: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
949: /*
944: WHEN WSH_INVALID_CONT then
945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
946: rollback to Update_Containers_SP_Grp;
947: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
948: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
949: /*
950: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
951: if x_msg_count > 1 then
952: x_msg_data := l_msg_summary || l_msg_details;
946: rollback to Update_Containers_SP_Grp;
947: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
948: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
949: /*
950: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
951: if x_msg_count > 1 then
952: x_msg_data := l_msg_summary || l_msg_details;
953: else
954: x_msg_data := l_msg_summary;
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;
972: rollback to Update_Containers_SP_Grp;
973: fnd_message.set_name('WSH', 'WSH_CONT_UPDATE_ERROR');
974: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
975: /*
970: WHEN WSH_FAIL_CONT_UPDATE then
971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
972: rollback to Update_Containers_SP_Grp;
973: fnd_message.set_name('WSH', 'WSH_CONT_UPDATE_ERROR');
974: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
975: /*
976: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
977: if x_msg_count > 1 then
978: x_msg_data := l_msg_summary || l_msg_details;
972: rollback to Update_Containers_SP_Grp;
973: fnd_message.set_name('WSH', 'WSH_CONT_UPDATE_ERROR');
974: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
975: /*
976: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
977: if x_msg_count > 1 then
978: x_msg_data := l_msg_summary || l_msg_details;
979: else
980: x_msg_data := l_msg_summary;
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');
999: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1000: rollback to Update_Containers_SP_Grp;
1001: /*
1002:
995: END IF;
996: --
997: WHEN OTHERS then
998: wsh_util_core.default_handler('WSH_CONTAINER_GRP.Update_Container');
999: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1000: rollback to Update_Containers_SP_Grp;
1001: /*
1002:
1003: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
999: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1000: rollback to Update_Containers_SP_Grp;
1001: /*
1002:
1003: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1004: if x_msg_count > 1 then
1005: x_msg_data := l_msg_summary || l_msg_details;
1006: else
1007: x_msg_data := l_msg_summary;
1069: x_msg_count OUT NOCOPY NUMBER,
1070: x_msg_data OUT NOCOPY VARCHAR2,
1071:
1072: -- program specific parameters
1073: p_entity_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
1074: p_entity_type IN VARCHAR2,
1075: p_group_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
1076: p_pack_cont_flag IN VARCHAR2,
1077:
1071:
1072: -- program specific parameters
1073: p_entity_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
1074: p_entity_type IN VARCHAR2,
1075: p_group_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
1076: p_pack_cont_flag IN VARCHAR2,
1077:
1078: -- program specific out parameters
1079: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
1075: p_group_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
1076: p_pack_cont_flag IN VARCHAR2,
1077:
1078: -- program specific out parameters
1079: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
1080:
1081: ) IS
1082:
1083: -- Standard call to check for call compatibility
1083: -- Standard call to check for call compatibility
1084: l_api_version CONSTANT NUMBER := 1.0;
1085: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
1086:
1087: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1088:
1089: l_det_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1090: l_cont_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1091: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1085: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
1086:
1087: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1088:
1089: l_det_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1090: l_cont_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1091: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1092:
1093: l_delivery_detail_id NUMBER;
1086:
1087: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1088:
1089: l_det_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1090: l_cont_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1091: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1092:
1093: l_delivery_detail_id NUMBER;
1094: l_delivery_id NUMBER;
1087: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1088:
1089: l_det_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1090: l_cont_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1091: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1092:
1093: l_delivery_detail_id NUMBER;
1094: l_delivery_id NUMBER;
1095: l_del_status VARCHAR2(10);
1107: l_del_cnt NUMBER := 0;
1108:
1109: l_msg_summary VARCHAR2(2000) := NULL;
1110: l_msg_details VARCHAR2(4000) := NULL;
1111: l_ret_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1112:
1113:
1114:
1115: WSH_INVALID_CONT EXCEPTION;
1154:
1155: l_num_warnings := 0;
1156: l_num_errors := 0;
1157:
1158: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
1159: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
1160: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
1161: END IF;
1162:
1155: l_num_warnings := 0;
1156: l_num_errors := 0;
1157:
1158: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
1159: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
1160: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
1161: END IF;
1162:
1163: -- Standard begin of API savepoint
1156: l_num_errors := 0;
1157:
1158: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
1159: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
1160: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
1161: END IF;
1162:
1163: -- Standard begin of API savepoint
1164: --
1197: IF FND_API.to_boolean(p_init_msg_list) THEN
1198: FND_MSG_PUB.initialize;
1199: END IF;
1200:
1201: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1202:
1203: -- first decide which entity it is by checking entity type..
1204: -- based on entity type validate all the entity ids..
1205:
1216: l_cont_flag;
1217:
1218: IF Check_Detail%NOTFOUND THEN
1219: CLOSE Check_Detail;
1220: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1221: END IF;
1222:
1223: IF Check_Detail%ISOPEN THEN
1224: CLOSE Check_Detail;
1227: l_det_cnt := l_det_cnt + 1;
1228: l_det_tab(l_det_cnt) := p_entity_tab(i);
1229:
1230: ELSE
1231: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1232: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1233: END IF;
1234: END IF;
1235: END LOOP;
1228: l_det_tab(l_det_cnt) := p_entity_tab(i);
1229:
1230: ELSE
1231: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1232: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1233: END IF;
1234: END IF;
1235: END LOOP;
1236:
1250: p_group_api_flag => 'Y',
1251: x_cont_inst_tab => x_cont_inst_tab,
1252: x_return_status => l_ret_status);
1253:
1254: IF l_ret_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1255: IF l_ret_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1256: -- Bug#4280365 Start
1257: If p_pack_cont_flag = 'Y' then
1258: fnd_message.set_name('WSH', 'WSH_AUTO_PACK_MASTER_MSG');
1251: x_cont_inst_tab => x_cont_inst_tab,
1252: x_return_status => l_ret_status);
1253:
1254: IF l_ret_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1255: IF l_ret_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1256: -- Bug#4280365 Start
1257: If p_pack_cont_flag = 'Y' then
1258: fnd_message.set_name('WSH', 'WSH_AUTO_PACK_MASTER_MSG');
1259: -- Bug#4280365 End
1259: -- Bug#4280365 End
1260: Else
1261: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1262: End If;
1263: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
1264: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1265: ELSE
1266: RAISE WSH_FAIL_AUTOPACK;
1267: END IF;
1260: Else
1261: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1262: End If;
1263: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
1264: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1265: ELSE
1266: RAISE WSH_FAIL_AUTOPACK;
1267: END IF;
1268: ELSE
1265: ELSE
1266: RAISE WSH_FAIL_AUTOPACK;
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(
1295: l_del_status;
1296:
1297: IF Check_Delivery%NOTFOUND THEN
1298: CLOSE Check_Delivery;
1299: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1300: END IF;
1301:
1302: IF Check_Delivery%ISOPEN THEN
1303: CLOSE Check_Delivery;
1306: IF nvl(l_del_status,'OP') IN ('OP', 'SA') THEN
1307: l_del_cnt := l_del_cnt + 1;
1308: l_del_tab(l_del_cnt) := p_entity_tab(i);
1309: ELSE
1310: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1311: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1312: END IF;
1313: END IF;
1314:
1307: l_del_cnt := l_del_cnt + 1;
1308: l_del_tab(l_del_cnt) := p_entity_tab(i);
1309: ELSE
1310: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1311: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1312: END IF;
1313: END IF;
1314:
1315: ELSE
1312: END IF;
1313: END IF;
1314:
1315: ELSE
1316: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1317: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1318: END IF;
1319: END IF;
1320:
1313: END IF;
1314:
1315: ELSE
1316: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1317: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1318: END IF;
1319: END IF;
1320:
1321: END LOOP;
1334: p_pack_cont_flag,
1335: x_cont_inst_tab,
1336: x_return_status);
1337:
1338: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1339: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1340: -- Bug#4280365 Start
1341: If p_pack_cont_flag = 'Y' then
1342: fnd_message.set_name('WSH', 'WSH_AUTO_PACK_MASTER_MSG');
1335: x_cont_inst_tab,
1336: x_return_status);
1337:
1338: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1339: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1340: -- Bug#4280365 Start
1341: If p_pack_cont_flag = 'Y' then
1342: fnd_message.set_name('WSH', 'WSH_AUTO_PACK_MASTER_MSG');
1343: -- Bug#4280365 End
1343: -- Bug#4280365 End
1344: Else
1345: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1346: End If;
1347: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
1348: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1349: ELSE
1350: RAISE WSH_FAIL_AUTOPACK;
1351: END IF;
1344: Else
1345: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1346: End If;
1347: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
1348: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1349: ELSE
1350: RAISE WSH_FAIL_AUTOPACK;
1351: END IF;
1352: ELSE
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
1391: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1392: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1393: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1394: RAISE WSH_FAIL_AUTOPACK;
1387: END IF;
1388: --
1389: --
1390: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1391: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1392: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1393: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1394: RAISE WSH_FAIL_AUTOPACK;
1395: ELSE
1388: --
1389: --
1390: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1391: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1392: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1393: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1394: RAISE WSH_FAIL_AUTOPACK;
1395: ELSE
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1389: --
1390: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1391: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1392: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1393: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1394: RAISE WSH_FAIL_AUTOPACK;
1395: ELSE
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: END IF;
1403: --
1404: --Bugfix 4070732 {
1405: IF FND_API.TO_BOOLEAN(p_commit) THEN
1406:
1407: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1408:
1409: -- dbms_output.put_line('commit');
1410: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
1411: WSH_UTIL_CORE.Process_stops_for_load_tender(
1406:
1407: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1408:
1409: -- dbms_output.put_line('commit');
1410: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
1411: WSH_UTIL_CORE.Process_stops_for_load_tender(
1412: p_reset_flags => FALSE,
1413: x_return_status => l_return_status);
1414:
1407: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1408:
1409: -- dbms_output.put_line('commit');
1410: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
1411: WSH_UTIL_CORE.Process_stops_for_load_tender(
1412: p_reset_flags => FALSE,
1413: x_return_status => l_return_status);
1414:
1415: IF l_debug_on THEN
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 --{
1421:
1422: COMMIT;
1423:
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 --{
1421:
1422: COMMIT;
1423:
1424: END IF; --}
1422: COMMIT;
1423:
1424: END IF; --}
1425:
1426: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1427: x_num_warnings =>l_num_warnings,
1428: x_num_errors =>l_num_errors);
1429: END IF;
1430: --Bugfix 4070732 }
1430: --Bugfix 4070732 }
1431:
1432: /*
1433:
1434: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1435: if x_msg_count > 1 then
1436: x_msg_data := l_msg_summary || l_msg_details;
1437: else
1438: x_msg_data := l_msg_summary;
1437: else
1438: x_msg_data := l_msg_summary;
1439: end if;
1440: */
1441: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1442:
1443: --Bugfix 4070732 {
1444: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN --{
1445: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1440: */
1441: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1442:
1443: --Bugfix 4070732 {
1444: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN --{
1445: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1446:
1447: IF FND_API.TO_BOOLEAN(p_commit) THEN
1448:
1441: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1442:
1443: --Bugfix 4070732 {
1444: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN --{
1445: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1446:
1447: IF FND_API.TO_BOOLEAN(p_commit) THEN
1448:
1449: IF l_debug_on 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);
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);
1455: ELSE
1456:
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);
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);
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
1471: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
1472: rollback to Autopack_SP_Grp;
1473: end if;
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
1471: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
1472: rollback to Autopack_SP_Grp;
1473: end if;
1474: END IF;
1499: --
1500: EXCEPTION
1501:
1502: WHEN WSH_INVALID_DETAIL then
1503: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1504: rollback to Autopack_SP_Grp;
1505: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1506: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1507: /*
1502: WHEN WSH_INVALID_DETAIL then
1503: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1504: rollback to Autopack_SP_Grp;
1505: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1506: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1507: /*
1508:
1509: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1510: if x_msg_count > 1 then
1505: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1506: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1507: /*
1508:
1509: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1510: if x_msg_count > 1 then
1511: x_msg_data := l_msg_summary || l_msg_details;
1512: else
1513: x_msg_data := l_msg_summary;
1513: x_msg_data := l_msg_summary;
1514: end if;
1515: */
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;
1514: end if;
1515: */
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:
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);
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);
1525:
1526:
1527: IF l_debug_on THEN
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;
1533: END IF;
1534: END IF;
1535: END IF;
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;
1533: END IF;
1534: END IF;
1535: END IF;
1536: --}
1552: END IF;
1553: --
1554:
1555: WHEN FND_API.G_EXC_ERROR then
1556: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1557: rollback to Autopack_SP_Grp;
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
1555: WHEN FND_API.G_EXC_ERROR then
1556: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1557: rollback to Autopack_SP_Grp;
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;
1556: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1557: rollback to Autopack_SP_Grp;
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:
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);
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);
1567:
1568:
1569: IF l_debug_on THEN
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;
1575: END IF;
1576: END IF;
1577: END IF;
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;
1575: END IF;
1576: END IF;
1577: END IF;
1578: --}
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;
1598: rollback to Autopack_SP_Grp;
1599: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
1600: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1601: /*
1596: WHEN WSH_INVALID_CONT then
1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1598: rollback to Autopack_SP_Grp;
1599: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
1600: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1601: /*
1602:
1603: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1604: if x_msg_count > 1 then
1599: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
1600: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1601: /*
1602:
1603: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1604: if x_msg_count > 1 then
1605: x_msg_data := l_msg_summary || l_msg_details;
1606: else
1607: x_msg_data := l_msg_summary;
1607: x_msg_data := l_msg_summary;
1608: end if;
1609: */
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;
1608: end if;
1609: */
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:
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);
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);
1619:
1620:
1621: IF l_debug_on THEN
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;
1627:
1628: END IF;
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;
1627:
1628: END IF;
1629: END IF;
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;
1649: rollback to Autopack_SP_Grp;
1650: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
1651: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1652: /*
1647: WHEN WSH_INVALID_DELIVERY then
1648: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1649: rollback to Autopack_SP_Grp;
1650: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
1651: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1652: /*
1653:
1654: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1655: if x_msg_count > 1 then
1650: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
1651: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1652: /*
1653:
1654: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1655: if x_msg_count > 1 then
1656: x_msg_data := l_msg_summary || l_msg_details;
1657: else
1658: x_msg_data := l_msg_summary;
1659: end if;
1660: */
1661:
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;
1660: */
1661:
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:
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);
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);
1671:
1672:
1673: IF l_debug_on THEN
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;
1679:
1680: END IF;
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;
1679:
1680: END IF;
1681: END IF;
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;
1701: --
1702: -- K LPN CONV. rv
1703: --
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;
1701: --
1702: -- K LPN CONV. rv
1703: --
1704: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
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
1721: x_return_status := l_return_status;
1722: END IF;
1723: --
1724: --}
1727: -- K LPN CONV. rv
1728: --
1729:
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;
1728: --
1729:
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:
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);
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);
1739:
1740: IF l_debug_on THEN
1741: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
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
1746: rollback to Autopack_SP_Grp;
1747: X_return_status := l_return_status;
1748: END IF;
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
1746: rollback to Autopack_SP_Grp;
1747: X_return_status := l_return_status;
1748: END IF;
1749:
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;
1768: rollback to Autopack_SP_Grp;
1769: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1770: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1771: --Bugfix 4070732 {
1766: WHEN WSH_FAIL_AUTOPACK then
1767: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1768: rollback to Autopack_SP_Grp;
1769: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1770: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
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
1768: rollback to Autopack_SP_Grp;
1769: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1770: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
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;
1769: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1770: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
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:
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);
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);
1780:
1781:
1782: IF l_debug_on THEN
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;
1788: END IF;
1789: END IF;
1790: END IF;
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;
1788: END IF;
1789: END IF;
1790: END IF;
1791: --}
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;
1806: rollback to Autopack_SP_Grp;
1807: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
1808: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1809: /*
1804: WHEN WSH_INVALID_ENTITY_TYPE then
1805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1806: rollback to Autopack_SP_Grp;
1807: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
1808: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1809: /*
1810:
1811: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1812: if x_msg_count > 1 then
1807: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
1808: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1809: /*
1810:
1811: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1812: if x_msg_count > 1 then
1813: x_msg_data := l_msg_summary || l_msg_details;
1814: else
1815: x_msg_data := l_msg_summary;
1815: x_msg_data := l_msg_summary;
1816: end if;
1817: */
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;
1816: end if;
1817: */
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:
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);
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);
1827:
1828:
1829: IF l_debug_on THEN
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;
1835:
1836: END IF;
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;
1835:
1836: END IF;
1837: END IF;
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');
1858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1859: rollback to Autopack_SP_Grp;
1860:
1861: /*
1854: END IF;
1855: --
1856: WHEN OTHERS then
1857: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Auto_Pack');
1858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1859: rollback to Autopack_SP_Grp;
1860:
1861: /*
1862:
1859: rollback to Autopack_SP_Grp;
1860:
1861: /*
1862:
1863: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1864: if x_msg_count > 1 then
1865: x_msg_data := l_msg_summary || l_msg_details;
1866: else
1867: x_msg_data := l_msg_summary;
1868: end if;
1869:
1870: */
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;
1869:
1870: */
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:
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);
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);
1880:
1881:
1882: IF l_debug_on THEN
1949: x_return_status OUT NOCOPY VARCHAR2,
1950: x_msg_count OUT NOCOPY NUMBER,
1951: x_msg_data OUT NOCOPY VARCHAR2,
1952: -- program specific parameters
1953: p_detail_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
1954: p_container_name IN VARCHAR2 DEFAULT NULL,
1955: p_cont_instance_id IN NUMBER DEFAULT NULL,
1956: p_container_flag IN VARCHAR2 DEFAULT 'N',
1957: p_delivery_flag IN VARCHAR2 DEFAULT 'N',
1964: -- Standard call to check for call compatibility
1965: l_api_version CONSTANT NUMBER := 1.0;
1966: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
1967:
1968: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1969: l_cont_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1970:
1971: l_delivery_detail_id NUMBER;
1972: l_delivery_id NUMBER;
1965: l_api_version CONSTANT NUMBER := 1.0;
1966: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
1967:
1968: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1969: l_cont_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1970:
1971: l_delivery_detail_id NUMBER;
1972: l_delivery_id NUMBER;
1973: l_del_sts VARCHAR2(10);
1997: l_wms_enabled_flag VARCHAR2(10);
1998: l_dlvy_status_code wsh_new_deliveries.status_code%TYPE;
1999: l_cont_org_id NUMBER;
2000: l_cont_released_status wsh_delivery_details.released_status%TYPE;
2001: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2002: l_num_warning NUMBER := 0;
2003: l_num_errors NUMBER := 0;
2004: l_next NUMBER ;
2005:
2059:
2060: BEGIN
2061: --
2062: --Bugfix 4070732
2063: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
2064: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
2065: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
2066: END IF;
2067: --
2060: BEGIN
2061: --
2062: --Bugfix 4070732
2063: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
2064: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
2065: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
2066: END IF;
2067: --
2068: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2061: --
2062: --Bugfix 4070732
2063: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
2064: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
2065: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
2066: END IF;
2067: --
2068: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2069: --
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105:
2106: END IF;
2107:
2108: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2109:
2110: IF p_caller LIKE 'WMS%' THEN
2111: l_group_api_flag := 'Y';
2112: END IF;
2124: p_phase => 1,
2125: p_action =>p_action_code ,
2126: x_return_status => l_return_status);
2127:
2128: wsh_util_core.api_post_call(p_return_status =>l_return_status,
2129: x_num_warnings =>l_num_warning,
2130: x_num_errors =>l_num_errors);
2131: END IF;
2132:
2153: l_delivery_id;
2154: IF Check_Detail%NOTFOUND THEN
2155: CLOSE Check_Detail;
2156: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
2157: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2158: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
2159: ELSE
2160: l_det_cnt := l_det_cnt + 1;
2161: l_detail_tab(l_det_cnt) := l_delivery_detail_id;
2154: IF Check_Detail%NOTFOUND THEN
2155: CLOSE Check_Detail;
2156: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
2157: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2158: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
2159: ELSE
2160: l_det_cnt := l_det_cnt + 1;
2161: l_detail_tab(l_det_cnt) := l_delivery_detail_id;
2162:
2326: p_group_api_flag => l_group_api_flag,
2327: x_pack_status => l_pack_status,
2328: x_return_status => x_return_status);
2329:
2330: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2331: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2332: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2333: ELSE
2334: RAISE WSH_FAIL_CONT_ACTION;
2327: x_pack_status => l_pack_status,
2328: x_return_status => x_return_status);
2329:
2330: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2331: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2332: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2333: ELSE
2334: RAISE WSH_FAIL_CONT_ACTION;
2335: END IF;
2328: x_return_status => x_return_status);
2329:
2330: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2331: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2332: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2333: ELSE
2334: RAISE WSH_FAIL_CONT_ACTION;
2335: END IF;
2336: ELSE
2367: p_delivery_flag => p_delivery_flag,
2368: p_group_api_flag => l_group_api_flag,
2369: x_return_status => x_return_status);
2370:
2371: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2372: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2373: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2374: ELSE
2375: RAISE WSH_FAIL_CONT_ACTION;
2368: p_group_api_flag => l_group_api_flag,
2369: x_return_status => x_return_status);
2370:
2371: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2372: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2373: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2374: ELSE
2375: RAISE WSH_FAIL_CONT_ACTION;
2376: END IF;
2369: x_return_status => x_return_status);
2370:
2371: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2372: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2373: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2374: ELSE
2375: RAISE WSH_FAIL_CONT_ACTION;
2376: END IF;
2377: END IF;
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
2403: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2404: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2405: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2406: RAISE WSH_FAIL_CONT_ACTION;
2399: END IF;
2400: --
2401: --
2402: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2403: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2404: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2405: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2406: RAISE WSH_FAIL_CONT_ACTION;
2407: ELSE
2400: --
2401: --
2402: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2403: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2404: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2405: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2406: RAISE WSH_FAIL_CONT_ACTION;
2407: ELSE
2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: --
2402: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2403: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2404: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2405: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2406: RAISE WSH_FAIL_CONT_ACTION;
2407: ELSE
2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409: END IF;
2416:
2417:
2418: --Bugfix 4070732 {
2419: IF FND_API.TO_BOOLEAN(p_commit) THEN
2420: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2421: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2422: WSH_UTIL_CORE.Process_stops_for_load_tender(
2423: p_reset_flags => FALSE,
2424: x_return_status => l_return_status);
2417:
2418: --Bugfix 4070732 {
2419: IF FND_API.TO_BOOLEAN(p_commit) THEN
2420: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2421: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2422: WSH_UTIL_CORE.Process_stops_for_load_tender(
2423: p_reset_flags => FALSE,
2424: x_return_status => l_return_status);
2425: END IF;
2418: --Bugfix 4070732 {
2419: IF FND_API.TO_BOOLEAN(p_commit) THEN
2420: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2421: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2422: WSH_UTIL_CORE.Process_stops_for_load_tender(
2423: p_reset_flags => FALSE,
2424: x_return_status => l_return_status);
2425: END IF;
2426: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2422: WSH_UTIL_CORE.Process_stops_for_load_tender(
2423: p_reset_flags => FALSE,
2424: x_return_status => l_return_status);
2425: END IF;
2426: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2427: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
2428:
2429: COMMIT;
2430:
2423: p_reset_flags => FALSE,
2424: x_return_status => l_return_status);
2425: END IF;
2426: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2427: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
2428:
2429: COMMIT;
2430:
2431: END IF; --}
2429: COMMIT;
2430:
2431: END IF; --}
2432:
2433: wsh_util_core.api_post_call(p_return_status =>l_return_status,
2434: x_num_warnings =>l_num_warning,
2435: x_num_errors =>l_num_errors);
2436: END IF;
2437: --Bugfix 4070732 }
2436: END IF;
2437: --Bugfix 4070732 }
2438:
2439: /*
2440: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2441: if x_msg_count > 1 then
2442: x_msg_data := l_msg_summary || l_msg_details;
2443: else
2444: x_msg_data := l_msg_summary;
2444: x_msg_data := l_msg_summary;
2445: end if;
2446: */
2447:
2448: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2449: --Bugfix 4070732 {
2450: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) <> upper(l_api_session_name)
2451: THEN --{
2452: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2446: */
2447:
2448: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2449: --Bugfix 4070732 {
2450: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) <> upper(l_api_session_name)
2451: THEN --{
2452: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2453: IF FND_API.TO_BOOLEAN(p_commit) THEN
2454:
2448: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2449: --Bugfix 4070732 {
2450: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) <> upper(l_api_session_name)
2451: 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);
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);
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);
2461:
2462: ELSE
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);
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);
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
2479: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
2480: rollback to Container_Action_SP_Grp;
2481: end if;
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
2479: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
2480: rollback to Container_Action_SP_Grp;
2481: end if;
2482: END IF;
2502: END IF;
2503: --
2504: EXCEPTION
2505:
2506: WHEN WSH_UTIL_CORE.G_EXC_WARNING then
2507: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2508: --
2509: -- K LPN CONV. rv
2510: --
2503: --
2504: EXCEPTION
2505:
2506: WHEN WSH_UTIL_CORE.G_EXC_WARNING then
2507: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2508: --
2509: -- K LPN CONV. rv
2510: --
2511: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
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
2529: x_return_status := l_return_status;
2530: END IF;
2531: --
2532: --}
2535: -- K LPN CONV. rv
2536: --
2537:
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;
2536: --
2537:
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:
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);
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);
2547:
2548: IF l_debug_on THEN
2549: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
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
2554: rollback to Container_Action_SP_Grp;
2555: x_return_status := l_return_status;
2556: END IF;
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
2554: rollback to Container_Action_SP_Grp;
2555: x_return_status := l_return_status;
2556: END IF;
2557: END IF;
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;
2573: rollback to Container_Action_SP_Grp;
2574: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
2575: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2576: /*
2571: WHEN WSH_INVALID_DETAIL then
2572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2573: rollback to Container_Action_SP_Grp;
2574: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
2575: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2576: /*
2577: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2578: if x_msg_count > 1 then
2579: x_msg_data := l_msg_summary || l_msg_details;
2573: rollback to Container_Action_SP_Grp;
2574: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
2575: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2576: /*
2577: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2578: if x_msg_count > 1 then
2579: x_msg_data := l_msg_summary || l_msg_details;
2580: else
2581: x_msg_data := l_msg_summary;
2582: end if;
2583: */
2584:
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;
2583: */
2584:
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:
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);
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);
2594:
2595:
2596: IF l_debug_on THEN
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;
2602: END IF;
2603:
2604: END IF;
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;
2621: rollback to Container_Action_SP_Grp;
2622: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
2623: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2624: /*
2619: WHEN WSH_INVALID_CONT then
2620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2621: rollback to Container_Action_SP_Grp;
2622: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
2623: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2624: /*
2625: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2626: if x_msg_count > 1 then
2627: x_msg_data := l_msg_summary || l_msg_details;
2621: rollback to Container_Action_SP_Grp;
2622: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
2623: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2624: /*
2625: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2626: if x_msg_count > 1 then
2627: x_msg_data := l_msg_summary || l_msg_details;
2628: else
2629: x_msg_data := l_msg_summary;
2630: end if;
2631: */
2632:
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;
2631: */
2632:
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:
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);
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);
2642:
2643:
2644: IF l_debug_on THEN
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;
2650: END IF;
2651: END IF;
2652: END IF;
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;
2668: rollback to Container_Action_SP_Grp;
2669: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
2670: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2671: /*
2666: WHEN WSH_INVALID_DELIVERY then
2667: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2668: rollback to Container_Action_SP_Grp;
2669: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
2670: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2671: /*
2672: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2673: if x_msg_count > 1 then
2674: x_msg_data := l_msg_summary || l_msg_details;
2668: rollback to Container_Action_SP_Grp;
2669: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
2670: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2671: /*
2672: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2673: if x_msg_count > 1 then
2674: x_msg_data := l_msg_summary || l_msg_details;
2675: else
2676: x_msg_data := l_msg_summary;
2677: end if;
2678: */
2679:
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;
2678: */
2679:
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:
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);
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);
2689:
2690:
2691: IF l_debug_on THEN
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;
2697: END IF;
2698: END IF;
2699: END IF;
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;
2715: rollback to Container_Action_SP_Grp;
2716: fnd_message.set_name('WSH', 'WSH_CONT_ACTION_ERROR');
2717: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2718: /*
2713: WHEN WSH_FAIL_CONT_ACTION then
2714: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2715: rollback to Container_Action_SP_Grp;
2716: fnd_message.set_name('WSH', 'WSH_CONT_ACTION_ERROR');
2717: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2718: /*
2719: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2720: if x_msg_count > 1 then
2721: x_msg_data := l_msg_summary || l_msg_details;
2715: rollback to Container_Action_SP_Grp;
2716: fnd_message.set_name('WSH', 'WSH_CONT_ACTION_ERROR');
2717: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2718: /*
2719: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2720: if x_msg_count > 1 then
2721: x_msg_data := l_msg_summary || l_msg_details;
2722: else
2723: x_msg_data := l_msg_summary;
2724: end if;
2725: */
2726:
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;
2725: */
2726:
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:
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);
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);
2736:
2737:
2738: IF l_debug_on THEN
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;
2744: END IF;
2745: END IF;
2746: END IF;
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;
2762: rollback to Container_Action_SP_Grp;
2763: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
2764: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2765: /*
2760: WHEN WSH_INVALID_ENTITY_TYPE then
2761: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2762: rollback to Container_Action_SP_Grp;
2763: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
2764: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2765: /*
2766: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2767: if x_msg_count > 1 then
2768: x_msg_data := l_msg_summary || l_msg_details;
2762: rollback to Container_Action_SP_Grp;
2763: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
2764: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2765: /*
2766: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2767: if x_msg_count > 1 then
2768: x_msg_data := l_msg_summary || l_msg_details;
2769: else
2770: x_msg_data := l_msg_summary;
2770: x_msg_data := l_msg_summary;
2771: end if;
2772: */
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;
2771: end if;
2772: */
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:
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);
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);
2782:
2783:
2784: IF l_debug_on THEN
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;
2790: END IF;
2791: END IF;
2792: END IF;
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;
2808: rollback to Container_Action_SP_Grp;
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
2806: WHEN FND_API.G_EXC_ERROR THEN
2807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2808: rollback to Container_Action_SP_Grp;
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;
2807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2808: rollback to Container_Action_SP_Grp;
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:
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);
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);
2818:
2819:
2820: IF l_debug_on THEN
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;
2826:
2827: END IF;
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;
2826:
2827: END IF;
2828: END IF;
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
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;
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:
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);
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);
2854:
2855:
2856: 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;
2878: rollback to Container_Action_SP_Grp;
2879: /*
2880: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
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;
2878: rollback to Container_Action_SP_Grp;
2879: /*
2880: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2881: if x_msg_count > 1 then
2876: wsh_util_core.default_handler('WSH_CONTAINER_GRP.Container_Actions');
2877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2878: rollback to Container_Action_SP_Grp;
2879: /*
2880: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2881: if x_msg_count > 1 then
2882: x_msg_data := l_msg_summary || l_msg_details;
2883: else
2884: x_msg_data := l_msg_summary;
2884: x_msg_data := l_msg_summary;
2885: end if;
2886: */
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;
2885: end if;
2886: */
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:
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);
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);
2896:
2897:
2898: IF l_debug_on THEN