[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;
1188:
1189: l_num_warnings := 0;
1190: l_num_errors := 0;
1191:
1192: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
1193: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
1194: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
1195: END IF;
1196:
1189: l_num_warnings := 0;
1190: l_num_errors := 0;
1191:
1192: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
1193: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
1194: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
1195: END IF;
1196:
1197: -- Standard begin of API savepoint
1190: l_num_errors := 0;
1191:
1192: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
1193: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
1194: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
1195: END IF;
1196:
1197: -- Standard begin of API savepoint
1198: --
1231: IF FND_API.to_boolean(p_init_msg_list) THEN
1232: FND_MSG_PUB.initialize;
1233: END IF;
1234:
1235: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1236:
1237: -- first decide which entity it is by checking entity type..
1238: -- based on entity type validate all the entity ids..
1239:
1250: l_cont_flag;
1251:
1252: IF Check_Detail%NOTFOUND THEN
1253: CLOSE Check_Detail;
1254: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1255: END IF;
1256:
1257: IF Check_Detail%ISOPEN THEN
1258: CLOSE Check_Detail;
1261: l_det_cnt := l_det_cnt + 1;
1262: l_det_tab(l_det_cnt) := p_entity_tab(i);
1263:
1264: ELSE
1265: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1266: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1267: END IF;
1268: END IF;
1269: END LOOP;
1262: l_det_tab(l_det_cnt) := p_entity_tab(i);
1263:
1264: ELSE
1265: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1266: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1267: END IF;
1268: END IF;
1269: END LOOP;
1270:
1284: p_group_api_flag => 'Y',
1285: x_cont_inst_tab => x_cont_inst_tab,
1286: x_return_status => l_ret_status);
1287:
1288: IF l_ret_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1289: IF l_ret_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1290: -- Bug#4280365 Start
1291: If p_pack_cont_flag = 'Y' then
1292: fnd_message.set_name('WSH', 'WSH_AUTO_PACK_MASTER_MSG');
1285: x_cont_inst_tab => x_cont_inst_tab,
1286: x_return_status => l_ret_status);
1287:
1288: IF l_ret_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1289: IF l_ret_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1290: -- Bug#4280365 Start
1291: If p_pack_cont_flag = 'Y' then
1292: fnd_message.set_name('WSH', 'WSH_AUTO_PACK_MASTER_MSG');
1293: -- Bug#4280365 End
1293: -- Bug#4280365 End
1294: Else
1295: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1296: End If;
1297: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
1298: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1299: ELSE
1300: RAISE WSH_FAIL_AUTOPACK;
1301: END IF;
1294: Else
1295: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1296: End If;
1297: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
1298: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1299: ELSE
1300: RAISE WSH_FAIL_AUTOPACK;
1301: END IF;
1302: ELSE
1299: ELSE
1300: RAISE WSH_FAIL_AUTOPACK;
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(
1329: l_del_status;
1330:
1331: IF Check_Delivery%NOTFOUND THEN
1332: CLOSE Check_Delivery;
1333: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1334: END IF;
1335:
1336: IF Check_Delivery%ISOPEN THEN
1337: CLOSE Check_Delivery;
1340: IF nvl(l_del_status,'OP') IN ('OP', 'SA') THEN
1341: l_del_cnt := l_del_cnt + 1;
1342: l_del_tab(l_del_cnt) := p_entity_tab(i);
1343: ELSE
1344: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1345: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1346: END IF;
1347: END IF;
1348:
1341: l_del_cnt := l_del_cnt + 1;
1342: l_del_tab(l_del_cnt) := p_entity_tab(i);
1343: ELSE
1344: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1345: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1346: END IF;
1347: END IF;
1348:
1349: ELSE
1346: END IF;
1347: END IF;
1348:
1349: ELSE
1350: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1351: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1352: END IF;
1353: END IF;
1354:
1347: END IF;
1348:
1349: ELSE
1350: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1351: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1352: END IF;
1353: END IF;
1354:
1355: END LOOP;
1368: p_pack_cont_flag,
1369: x_cont_inst_tab,
1370: x_return_status);
1371:
1372: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1373: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1374: -- Bug#4280365 Start
1375: If p_pack_cont_flag = 'Y' then
1376: fnd_message.set_name('WSH', 'WSH_AUTO_PACK_MASTER_MSG');
1369: x_cont_inst_tab,
1370: x_return_status);
1371:
1372: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1373: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1374: -- Bug#4280365 Start
1375: If p_pack_cont_flag = 'Y' then
1376: fnd_message.set_name('WSH', 'WSH_AUTO_PACK_MASTER_MSG');
1377: -- Bug#4280365 End
1377: -- Bug#4280365 End
1378: Else
1379: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1380: End If;
1381: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
1382: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1383: ELSE
1384: RAISE WSH_FAIL_AUTOPACK;
1385: END IF;
1378: Else
1379: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1380: End If;
1381: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
1382: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1383: ELSE
1384: RAISE WSH_FAIL_AUTOPACK;
1385: END IF;
1386: ELSE
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
1453: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1454: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1455: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1456: RAISE WSH_FAIL_AUTOPACK;
1449: END IF;
1450: --
1451: --
1452: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1453: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1454: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1455: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1456: RAISE WSH_FAIL_AUTOPACK;
1457: ELSE
1450: --
1451: --
1452: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1453: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1454: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1455: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1456: RAISE WSH_FAIL_AUTOPACK;
1457: ELSE
1458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1451: --
1452: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1453: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1454: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1455: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1456: RAISE WSH_FAIL_AUTOPACK;
1457: ELSE
1458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1459: END IF;
1465: --
1466: --Bugfix 4070732 {
1467: IF FND_API.TO_BOOLEAN(p_commit) THEN
1468:
1469: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1470:
1471: -- dbms_output.put_line('commit');
1472: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
1473: WSH_UTIL_CORE.Process_stops_for_load_tender(
1468:
1469: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1470:
1471: -- dbms_output.put_line('commit');
1472: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
1473: WSH_UTIL_CORE.Process_stops_for_load_tender(
1474: p_reset_flags => FALSE,
1475: x_return_status => l_return_status);
1476:
1469: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1470:
1471: -- dbms_output.put_line('commit');
1472: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
1473: WSH_UTIL_CORE.Process_stops_for_load_tender(
1474: p_reset_flags => FALSE,
1475: x_return_status => l_return_status);
1476:
1477: IF l_debug_on THEN
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 --{
1483:
1484: COMMIT;
1485:
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 --{
1483:
1484: COMMIT;
1485:
1486: END IF; --}
1484: COMMIT;
1485:
1486: END IF; --}
1487:
1488: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1489: x_num_warnings =>l_num_warnings,
1490: x_num_errors =>l_num_errors);
1491: END IF;
1492: --Bugfix 4070732 }
1492: --Bugfix 4070732 }
1493:
1494: /*
1495:
1496: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1497: if x_msg_count > 1 then
1498: x_msg_data := l_msg_summary || l_msg_details;
1499: else
1500: x_msg_data := l_msg_summary;
1499: else
1500: x_msg_data := l_msg_summary;
1501: end if;
1502: */
1503: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1504:
1505: --Bugfix 4070732 {
1506: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN --{
1507: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1502: */
1503: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1504:
1505: --Bugfix 4070732 {
1506: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN --{
1507: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1508:
1509: IF FND_API.TO_BOOLEAN(p_commit) THEN
1510:
1503: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1504:
1505: --Bugfix 4070732 {
1506: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN --{
1507: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1508:
1509: IF FND_API.TO_BOOLEAN(p_commit) THEN
1510:
1511: IF l_debug_on 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);
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);
1517: ELSE
1518:
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);
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);
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
1533: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
1534: rollback to Autopack_SP_Grp;
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 IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1532: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1533: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
1534: rollback to Autopack_SP_Grp;
1535: end if;
1536: END IF;
1561: --
1562: EXCEPTION
1563:
1564: WHEN WSH_INVALID_DETAIL then
1565: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1566: rollback to Autopack_SP_Grp;
1567: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1568: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1569: /*
1564: WHEN WSH_INVALID_DETAIL then
1565: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1566: rollback to Autopack_SP_Grp;
1567: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1568: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1569: /*
1570:
1571: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1572: if x_msg_count > 1 then
1567: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1568: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1569: /*
1570:
1571: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1572: if x_msg_count > 1 then
1573: x_msg_data := l_msg_summary || l_msg_details;
1574: else
1575: x_msg_data := l_msg_summary;
1575: x_msg_data := l_msg_summary;
1576: end if;
1577: */
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;
1576: end if;
1577: */
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:
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);
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);
1587:
1588:
1589: IF l_debug_on THEN
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;
1595: END IF;
1596: END IF;
1597: END IF;
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;
1595: END IF;
1596: END IF;
1597: END IF;
1598: --}
1614: END IF;
1615: --
1616:
1617: WHEN FND_API.G_EXC_ERROR then
1618: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1619: rollback to Autopack_SP_Grp;
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
1617: WHEN FND_API.G_EXC_ERROR then
1618: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1619: rollback to Autopack_SP_Grp;
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;
1618: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1619: rollback to Autopack_SP_Grp;
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:
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);
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);
1629:
1630:
1631: IF l_debug_on THEN
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;
1637: END IF;
1638: END IF;
1639: END IF;
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;
1637: END IF;
1638: END IF;
1639: END IF;
1640: --}
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;
1660: rollback to Autopack_SP_Grp;
1661: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
1662: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1663: /*
1658: WHEN WSH_INVALID_CONT then
1659: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1660: rollback to Autopack_SP_Grp;
1661: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
1662: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1663: /*
1664:
1665: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1666: if x_msg_count > 1 then
1661: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
1662: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1663: /*
1664:
1665: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1666: if x_msg_count > 1 then
1667: x_msg_data := l_msg_summary || l_msg_details;
1668: else
1669: x_msg_data := l_msg_summary;
1669: x_msg_data := l_msg_summary;
1670: end if;
1671: */
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;
1670: end if;
1671: */
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:
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);
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);
1681:
1682:
1683: IF l_debug_on THEN
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;
1689:
1690: END IF;
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;
1689:
1690: END IF;
1691: END IF;
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;
1711: rollback to Autopack_SP_Grp;
1712: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
1713: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1714: /*
1709: WHEN WSH_INVALID_DELIVERY then
1710: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1711: rollback to Autopack_SP_Grp;
1712: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
1713: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1714: /*
1715:
1716: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1717: if x_msg_count > 1 then
1712: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
1713: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1714: /*
1715:
1716: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1717: if x_msg_count > 1 then
1718: x_msg_data := l_msg_summary || l_msg_details;
1719: else
1720: x_msg_data := l_msg_summary;
1721: end if;
1722: */
1723:
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;
1722: */
1723:
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:
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);
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);
1733:
1734:
1735: IF l_debug_on THEN
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;
1741:
1742: END IF;
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;
1741:
1742: END IF;
1743: END IF;
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;
1763: --
1764: -- K LPN CONV. rv
1765: --
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;
1763: --
1764: -- K LPN CONV. rv
1765: --
1766: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
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
1783: x_return_status := l_return_status;
1784: END IF;
1785: --
1786: --}
1789: -- K LPN CONV. rv
1790: --
1791:
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;
1790: --
1791:
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:
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);
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);
1801:
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
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
1808: rollback to Autopack_SP_Grp;
1809: X_return_status := l_return_status;
1810: END IF;
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
1808: rollback to Autopack_SP_Grp;
1809: X_return_status := l_return_status;
1810: END IF;
1811:
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;
1830: rollback to Autopack_SP_Grp;
1831: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1832: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1833: --Bugfix 4070732 {
1828: WHEN WSH_FAIL_AUTOPACK then
1829: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1830: rollback to Autopack_SP_Grp;
1831: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1832: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
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
1830: rollback to Autopack_SP_Grp;
1831: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1832: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
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;
1831: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
1832: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
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:
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);
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);
1842:
1843:
1844: IF l_debug_on THEN
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;
1850: END IF;
1851: END IF;
1852: END IF;
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;
1850: END IF;
1851: END IF;
1852: END IF;
1853: --}
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;
1868: rollback to Autopack_SP_Grp;
1869: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
1870: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1871: /*
1866: WHEN WSH_INVALID_ENTITY_TYPE then
1867: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1868: rollback to Autopack_SP_Grp;
1869: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
1870: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1871: /*
1872:
1873: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1874: if x_msg_count > 1 then
1869: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
1870: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1871: /*
1872:
1873: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1874: if x_msg_count > 1 then
1875: x_msg_data := l_msg_summary || l_msg_details;
1876: else
1877: x_msg_data := l_msg_summary;
1877: x_msg_data := l_msg_summary;
1878: end if;
1879: */
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;
1878: end if;
1879: */
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:
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);
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);
1889:
1890:
1891: IF l_debug_on THEN
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;
1897:
1898: END IF;
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;
1897:
1898: END IF;
1899: END IF;
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');
1920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1921: rollback to Autopack_SP_Grp;
1922:
1923: /*
1916: END IF;
1917: --
1918: WHEN OTHERS then
1919: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Auto_Pack');
1920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1921: rollback to Autopack_SP_Grp;
1922:
1923: /*
1924:
1921: rollback to Autopack_SP_Grp;
1922:
1923: /*
1924:
1925: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1926: if x_msg_count > 1 then
1927: x_msg_data := l_msg_summary || l_msg_details;
1928: else
1929: x_msg_data := l_msg_summary;
1930: end if;
1931:
1932: */
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;
1931:
1932: */
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:
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);
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);
1942:
1943:
1944: IF l_debug_on THEN
2011: x_return_status OUT NOCOPY VARCHAR2,
2012: x_msg_count OUT NOCOPY NUMBER,
2013: x_msg_data OUT NOCOPY VARCHAR2,
2014: -- program specific parameters
2015: p_detail_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
2016: p_container_name IN VARCHAR2 DEFAULT NULL,
2017: p_cont_instance_id IN NUMBER DEFAULT NULL,
2018: p_container_flag IN VARCHAR2 DEFAULT 'N',
2019: p_delivery_flag IN VARCHAR2 DEFAULT 'N',
2026: -- Standard call to check for call compatibility
2027: l_api_version CONSTANT NUMBER := 1.0;
2028: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
2029:
2030: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2031: l_cont_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2032:
2033: l_delivery_detail_id NUMBER;
2034: l_delivery_id NUMBER;
2027: l_api_version CONSTANT NUMBER := 1.0;
2028: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
2029:
2030: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2031: l_cont_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2032:
2033: l_delivery_detail_id NUMBER;
2034: l_delivery_id NUMBER;
2035: l_del_sts VARCHAR2(10);
2059: l_wms_enabled_flag VARCHAR2(10);
2060: l_dlvy_status_code wsh_new_deliveries.status_code%TYPE;
2061: l_cont_org_id NUMBER;
2062: l_cont_released_status wsh_delivery_details.released_status%TYPE;
2063: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2064: l_num_warning NUMBER := 0;
2065: l_num_errors NUMBER := 0;
2066: l_next NUMBER ;
2067:
2121:
2122: BEGIN
2123: --
2124: --Bugfix 4070732
2125: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
2126: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
2127: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
2128: END IF;
2129: --
2122: BEGIN
2123: --
2124: --Bugfix 4070732
2125: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
2126: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
2127: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
2128: END IF;
2129: --
2130: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2123: --
2124: --Bugfix 4070732
2125: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
2126: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
2127: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
2128: END IF;
2129: --
2130: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2131: --
2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2167:
2168: END IF;
2169:
2170: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2171:
2172: IF p_caller LIKE 'WMS%' THEN
2173: l_group_api_flag := 'Y';
2174: END IF;
2186: p_phase => 1,
2187: p_action =>p_action_code ,
2188: x_return_status => l_return_status);
2189:
2190: wsh_util_core.api_post_call(p_return_status =>l_return_status,
2191: x_num_warnings =>l_num_warning,
2192: x_num_errors =>l_num_errors);
2193: END IF;
2194:
2215: l_delivery_id;
2216: IF Check_Detail%NOTFOUND THEN
2217: CLOSE Check_Detail;
2218: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
2219: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2220: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
2221: ELSE
2222: l_det_cnt := l_det_cnt + 1;
2223: l_detail_tab(l_det_cnt) := l_delivery_detail_id;
2216: IF Check_Detail%NOTFOUND THEN
2217: CLOSE Check_Detail;
2218: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
2219: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2220: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
2221: ELSE
2222: l_det_cnt := l_det_cnt + 1;
2223: l_detail_tab(l_det_cnt) := l_delivery_detail_id;
2224:
2388: p_group_api_flag => l_group_api_flag,
2389: x_pack_status => l_pack_status,
2390: x_return_status => x_return_status);
2391:
2392: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2393: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2394: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2395: ELSE
2396: RAISE WSH_FAIL_CONT_ACTION;
2389: x_pack_status => l_pack_status,
2390: x_return_status => x_return_status);
2391:
2392: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2393: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2394: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2395: ELSE
2396: RAISE WSH_FAIL_CONT_ACTION;
2397: END IF;
2390: x_return_status => x_return_status);
2391:
2392: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2393: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2394: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2395: ELSE
2396: RAISE WSH_FAIL_CONT_ACTION;
2397: END IF;
2398: ELSE
2429: p_delivery_flag => p_delivery_flag,
2430: p_group_api_flag => l_group_api_flag,
2431: x_return_status => x_return_status);
2432:
2433: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2434: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2435: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2436: ELSE
2437: RAISE WSH_FAIL_CONT_ACTION;
2430: p_group_api_flag => l_group_api_flag,
2431: x_return_status => x_return_status);
2432:
2433: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2434: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2435: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2436: ELSE
2437: RAISE WSH_FAIL_CONT_ACTION;
2438: END IF;
2431: x_return_status => x_return_status);
2432:
2433: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2434: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2435: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2436: ELSE
2437: RAISE WSH_FAIL_CONT_ACTION;
2438: END IF;
2439: END IF;
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
2465: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2466: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2467: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2468: RAISE WSH_FAIL_CONT_ACTION;
2461: END IF;
2462: --
2463: --
2464: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2465: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2466: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2467: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2468: RAISE WSH_FAIL_CONT_ACTION;
2469: ELSE
2462: --
2463: --
2464: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2465: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2466: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2467: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2468: RAISE WSH_FAIL_CONT_ACTION;
2469: ELSE
2470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: --
2464: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2465: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2466: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2467: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2468: RAISE WSH_FAIL_CONT_ACTION;
2469: ELSE
2470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2471: END IF;
2478:
2479:
2480: --Bugfix 4070732 {
2481: IF FND_API.TO_BOOLEAN(p_commit) THEN
2482: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2483: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2484: WSH_UTIL_CORE.Process_stops_for_load_tender(
2485: p_reset_flags => FALSE,
2486: x_return_status => l_return_status);
2479:
2480: --Bugfix 4070732 {
2481: IF FND_API.TO_BOOLEAN(p_commit) THEN
2482: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2483: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2484: WSH_UTIL_CORE.Process_stops_for_load_tender(
2485: p_reset_flags => FALSE,
2486: x_return_status => l_return_status);
2487: END IF;
2480: --Bugfix 4070732 {
2481: IF FND_API.TO_BOOLEAN(p_commit) THEN
2482: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2483: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2484: WSH_UTIL_CORE.Process_stops_for_load_tender(
2485: p_reset_flags => FALSE,
2486: x_return_status => l_return_status);
2487: END IF;
2488: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2484: WSH_UTIL_CORE.Process_stops_for_load_tender(
2485: p_reset_flags => FALSE,
2486: x_return_status => l_return_status);
2487: END IF;
2488: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2489: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
2490:
2491: COMMIT;
2492:
2485: p_reset_flags => FALSE,
2486: x_return_status => l_return_status);
2487: END IF;
2488: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2489: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
2490:
2491: COMMIT;
2492:
2493: END IF; --}
2491: COMMIT;
2492:
2493: END IF; --}
2494:
2495: wsh_util_core.api_post_call(p_return_status =>l_return_status,
2496: x_num_warnings =>l_num_warning,
2497: x_num_errors =>l_num_errors);
2498: END IF;
2499: --Bugfix 4070732 }
2498: END IF;
2499: --Bugfix 4070732 }
2500:
2501: /*
2502: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2503: if x_msg_count > 1 then
2504: x_msg_data := l_msg_summary || l_msg_details;
2505: else
2506: x_msg_data := l_msg_summary;
2506: x_msg_data := l_msg_summary;
2507: end if;
2508: */
2509:
2510: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2511: --Bugfix 4070732 {
2512: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) <> upper(l_api_session_name)
2513: THEN --{
2514: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2508: */
2509:
2510: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2511: --Bugfix 4070732 {
2512: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) <> upper(l_api_session_name)
2513: THEN --{
2514: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2515: IF FND_API.TO_BOOLEAN(p_commit) THEN
2516:
2510: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2511: --Bugfix 4070732 {
2512: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) <> upper(l_api_session_name)
2513: 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);
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);
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);
2523:
2524: ELSE
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);
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);
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
2541: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
2542: rollback to Container_Action_SP_Grp;
2543: end if;
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
2541: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
2542: rollback to Container_Action_SP_Grp;
2543: end if;
2544: END IF;
2564: END IF;
2565: --
2566: EXCEPTION
2567:
2568: WHEN WSH_UTIL_CORE.G_EXC_WARNING then
2569: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2570: --
2571: -- K LPN CONV. rv
2572: --
2565: --
2566: EXCEPTION
2567:
2568: WHEN WSH_UTIL_CORE.G_EXC_WARNING then
2569: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2570: --
2571: -- K LPN CONV. rv
2572: --
2573: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
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
2591: x_return_status := l_return_status;
2592: END IF;
2593: --
2594: --}
2597: -- K LPN CONV. rv
2598: --
2599:
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;
2598: --
2599:
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:
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);
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);
2609:
2610: IF l_debug_on THEN
2611: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
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
2616: rollback to Container_Action_SP_Grp;
2617: x_return_status := l_return_status;
2618: END IF;
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
2616: rollback to Container_Action_SP_Grp;
2617: x_return_status := l_return_status;
2618: END IF;
2619: END IF;
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;
2635: rollback to Container_Action_SP_Grp;
2636: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
2637: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2638: /*
2633: WHEN WSH_INVALID_DETAIL then
2634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2635: rollback to Container_Action_SP_Grp;
2636: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
2637: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2638: /*
2639: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2640: if x_msg_count > 1 then
2641: x_msg_data := l_msg_summary || l_msg_details;
2635: rollback to Container_Action_SP_Grp;
2636: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
2637: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2638: /*
2639: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2640: if x_msg_count > 1 then
2641: x_msg_data := l_msg_summary || l_msg_details;
2642: else
2643: x_msg_data := l_msg_summary;
2644: end if;
2645: */
2646:
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;
2645: */
2646:
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:
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);
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);
2656:
2657:
2658: IF l_debug_on THEN
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;
2664: END IF;
2665:
2666: END IF;
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;
2683: rollback to Container_Action_SP_Grp;
2684: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
2685: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2686: /*
2681: WHEN WSH_INVALID_CONT then
2682: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2683: rollback to Container_Action_SP_Grp;
2684: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
2685: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2686: /*
2687: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2688: if x_msg_count > 1 then
2689: x_msg_data := l_msg_summary || l_msg_details;
2683: rollback to Container_Action_SP_Grp;
2684: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_NAME');
2685: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2686: /*
2687: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2688: if x_msg_count > 1 then
2689: x_msg_data := l_msg_summary || l_msg_details;
2690: else
2691: x_msg_data := l_msg_summary;
2692: end if;
2693: */
2694:
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;
2693: */
2694:
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:
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);
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);
2704:
2705:
2706: IF l_debug_on THEN
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;
2712: END IF;
2713: END IF;
2714: END IF;
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;
2730: rollback to Container_Action_SP_Grp;
2731: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
2732: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2733: /*
2728: WHEN WSH_INVALID_DELIVERY then
2729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2730: rollback to Container_Action_SP_Grp;
2731: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
2732: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2733: /*
2734: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2735: if x_msg_count > 1 then
2736: x_msg_data := l_msg_summary || l_msg_details;
2730: rollback to Container_Action_SP_Grp;
2731: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
2732: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2733: /*
2734: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2735: if x_msg_count > 1 then
2736: x_msg_data := l_msg_summary || l_msg_details;
2737: else
2738: x_msg_data := l_msg_summary;
2739: end if;
2740: */
2741:
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;
2740: */
2741:
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:
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);
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);
2751:
2752:
2753: IF l_debug_on THEN
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;
2759: END IF;
2760: END IF;
2761: END IF;
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;
2777: rollback to Container_Action_SP_Grp;
2778: fnd_message.set_name('WSH', 'WSH_CONT_ACTION_ERROR');
2779: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2780: /*
2775: WHEN WSH_FAIL_CONT_ACTION then
2776: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2777: rollback to Container_Action_SP_Grp;
2778: fnd_message.set_name('WSH', 'WSH_CONT_ACTION_ERROR');
2779: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2780: /*
2781: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2782: if x_msg_count > 1 then
2783: x_msg_data := l_msg_summary || l_msg_details;
2777: rollback to Container_Action_SP_Grp;
2778: fnd_message.set_name('WSH', 'WSH_CONT_ACTION_ERROR');
2779: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2780: /*
2781: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2782: if x_msg_count > 1 then
2783: x_msg_data := l_msg_summary || l_msg_details;
2784: else
2785: x_msg_data := l_msg_summary;
2786: end if;
2787: */
2788:
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;
2787: */
2788:
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:
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);
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);
2798:
2799:
2800: IF l_debug_on THEN
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;
2806: END IF;
2807: END IF;
2808: END IF;
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;
2824: rollback to Container_Action_SP_Grp;
2825: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
2826: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2827: /*
2822: WHEN WSH_INVALID_ENTITY_TYPE then
2823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2824: rollback to Container_Action_SP_Grp;
2825: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
2826: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2827: /*
2828: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2829: if x_msg_count > 1 then
2830: x_msg_data := l_msg_summary || l_msg_details;
2824: rollback to Container_Action_SP_Grp;
2825: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
2826: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2827: /*
2828: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2829: if x_msg_count > 1 then
2830: x_msg_data := l_msg_summary || l_msg_details;
2831: else
2832: x_msg_data := l_msg_summary;
2832: x_msg_data := l_msg_summary;
2833: end if;
2834: */
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;
2833: end if;
2834: */
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:
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);
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);
2844:
2845:
2846: IF l_debug_on THEN
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;
2852: END IF;
2853: END IF;
2854: END IF;
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;
2870: rollback to Container_Action_SP_Grp;
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
2868: WHEN FND_API.G_EXC_ERROR THEN
2869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2870: rollback to Container_Action_SP_Grp;
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;
2869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2870: rollback to Container_Action_SP_Grp;
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:
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);
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);
2880:
2881:
2882: IF l_debug_on THEN
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;
2888:
2889: END IF;
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;
2888:
2889: END IF;
2890: END IF;
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
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;
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:
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);
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);
2916:
2917:
2918: 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;
2940: rollback to Container_Action_SP_Grp;
2941: /*
2942: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
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;
2940: rollback to Container_Action_SP_Grp;
2941: /*
2942: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2943: if x_msg_count > 1 then
2938: wsh_util_core.default_handler('WSH_CONTAINER_GRP.Container_Actions');
2939: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2940: rollback to Container_Action_SP_Grp;
2941: /*
2942: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2943: if x_msg_count > 1 then
2944: x_msg_data := l_msg_summary || l_msg_details;
2945: else
2946: x_msg_data := l_msg_summary;
2946: x_msg_data := l_msg_summary;
2947: end if;
2948: */
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;
2947: end if;
2948: */
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:
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);
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);
2958:
2959:
2960: IF l_debug_on THEN