eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_SPLITTER_PKG dependencies on WSH_UTIL_CORE

Line 86: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

82: p_exception_name);
83:
84: END IF;
85:
86: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
87: l_num_error := 0;
88: l_num_warn := 0;
89:
90: IF (p_exception_name IS NULL OR p_delivery_rec.entity_id IS NULL) THEN

Line 180: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

176: IF l_debug_on THEN
177: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);
178: END IF;
179:
180: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
181: l_num_error := l_num_error+1;
182: END IF;
183:
184: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 184: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

180: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
181: l_num_error := l_num_error+1;
182: END IF;
183:
184: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
185: l_num_warn := l_num_warn+1;
186: END IF;
187:
188: IF l_num_error > 0 THEN

Line 189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

185: l_num_warn := l_num_warn+1;
186: END IF;
187:
188: IF l_num_error > 0 THEN
189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
190: ELSIF l_num_warn > 0 THEN
191: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
192: ELSE
193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 191: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

187:
188: IF l_num_error > 0 THEN
189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
190: ELSIF l_num_warn > 0 THEN
191: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
192: ELSE
193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
194: END IF;
195:

Line 193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
190: ELSIF l_num_warn > 0 THEN
191: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
192: ELSE
193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
194: END IF;
195:
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);

Line 205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

201: END IF;
202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
206: --
207:
208: WSH_UTIL_CORE.default_handler(
209: 'WSH_DELIVERY_SPLITTER_PKG.LOG_DEL_SPLITTER_EXCEPTION', l_module_name);

Line 208: WSH_UTIL_CORE.default_handler(

204: WHEN OTHERS THEN
205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
206: --
207:
208: WSH_UTIL_CORE.default_handler(
209: 'WSH_DELIVERY_SPLITTER_PKG.LOG_DEL_SPLITTER_EXCEPTION', l_module_name);
210: IF l_debug_on THEN
211: WSH_DEBUG_SV.logmsg(l_module_name,
212: 'Unexpected error has occured. Oracle error message is '||

Line 290: l_line_and_container_id WSH_UTIL_CORE.ID_TAB_TYPE;

286: l_content_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE; -- variable used to track total content weight
287:
288: -- variable used to track delivery weight for new delivery
289: l_new_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
290: l_line_and_container_id WSH_UTIL_CORE.ID_TAB_TYPE;
291: l_line_and_container_weight WSH_UTIL_CORE.ID_TAB_TYPE;
292: l_line_status WSH_UTIL_CORE.COLUMN_TAB_TYPE;
293:
294: -- used to keep the list of delivery ids for the splitted delivery

Line 291: l_line_and_container_weight WSH_UTIL_CORE.ID_TAB_TYPE;

287:
288: -- variable used to track delivery weight for new delivery
289: l_new_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
290: l_line_and_container_id WSH_UTIL_CORE.ID_TAB_TYPE;
291: l_line_and_container_weight WSH_UTIL_CORE.ID_TAB_TYPE;
292: l_line_status WSH_UTIL_CORE.COLUMN_TAB_TYPE;
293:
294: -- used to keep the list of delivery ids for the splitted delivery
295: l_curr_del_split_list WSH_UTIL_CORE.ID_TAB_TYPE;

Line 292: l_line_status WSH_UTIL_CORE.COLUMN_TAB_TYPE;

288: -- variable used to track delivery weight for new delivery
289: l_new_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
290: l_line_and_container_id WSH_UTIL_CORE.ID_TAB_TYPE;
291: l_line_and_container_weight WSH_UTIL_CORE.ID_TAB_TYPE;
292: l_line_status WSH_UTIL_CORE.COLUMN_TAB_TYPE;
293:
294: -- used to keep the list of delivery ids for the splitted delivery
295: l_curr_del_split_list WSH_UTIL_CORE.ID_TAB_TYPE;
296: l_curr_del_split_name WSH_UTIL_CORE.COLUMN_TAB_TYPE;

Line 295: l_curr_del_split_list WSH_UTIL_CORE.ID_TAB_TYPE;

291: l_line_and_container_weight WSH_UTIL_CORE.ID_TAB_TYPE;
292: l_line_status WSH_UTIL_CORE.COLUMN_TAB_TYPE;
293:
294: -- used to keep the list of delivery ids for the splitted delivery
295: l_curr_del_split_list WSH_UTIL_CORE.ID_TAB_TYPE;
296: l_curr_del_split_name WSH_UTIL_CORE.COLUMN_TAB_TYPE;
297: l_count NUMBER;
298: -- used to keep the list of delivery ids for the new delivery creation
299: l_current_ids WSH_UTIL_CORE.ID_TAB_TYPE;

Line 296: l_curr_del_split_name WSH_UTIL_CORE.COLUMN_TAB_TYPE;

292: l_line_status WSH_UTIL_CORE.COLUMN_TAB_TYPE;
293:
294: -- used to keep the list of delivery ids for the splitted delivery
295: l_curr_del_split_list WSH_UTIL_CORE.ID_TAB_TYPE;
296: l_curr_del_split_name WSH_UTIL_CORE.COLUMN_TAB_TYPE;
297: l_count NUMBER;
298: -- used to keep the list of delivery ids for the new delivery creation
299: l_current_ids WSH_UTIL_CORE.ID_TAB_TYPE;
300:

Line 299: l_current_ids WSH_UTIL_CORE.ID_TAB_TYPE;

295: l_curr_del_split_list WSH_UTIL_CORE.ID_TAB_TYPE;
296: l_curr_del_split_name WSH_UTIL_CORE.COLUMN_TAB_TYPE;
297: l_count NUMBER;
298: -- used to keep the list of delivery ids for the new delivery creation
299: l_current_ids WSH_UTIL_CORE.ID_TAB_TYPE;
300:
301: l_temp_ids WSH_UTIL_CORE.ID_TAB_TYPE;
302: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
303: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;

Line 301: l_temp_ids WSH_UTIL_CORE.ID_TAB_TYPE;

297: l_count NUMBER;
298: -- used to keep the list of delivery ids for the new delivery creation
299: l_current_ids WSH_UTIL_CORE.ID_TAB_TYPE;
300:
301: l_temp_ids WSH_UTIL_CORE.ID_TAB_TYPE;
302: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
303: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;
304: l_new_delivery_name WSH_NEW_DELIVERIES.NAME%TYPE; -- new delivery id
305: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

Line 343: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

339: wsh_debug_sv.log(l_module_name, 'p_autosplit_flag',
340: p_autosplit_flag);
341: END IF;
342: --
343: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
344: --
345:
346: --intialize
347: l_temp_num := 0;

Line 378: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters: ' || l_return_status);
376: END IF;
377:
378: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
379: l_num_warn := l_num_warn + 1;
380: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
381: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
382: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_GLOBAL_PARAMETER');

Line 380: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

376: END IF;
377:
378: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
379: l_num_warn := l_num_warn + 1;
380: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
381: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
382: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_GLOBAL_PARAMETER');
383: wsh_util_core.add_message(l_return_status,l_module_name);
384:

Line 381: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

377:
378: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
379: l_num_warn := l_num_warn + 1;
380: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
381: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
382: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_GLOBAL_PARAMETER');
383: wsh_util_core.add_message(l_return_status,l_module_name);
384:
385: x_return_status := l_return_status;

Line 383: wsh_util_core.add_message(l_return_status,l_module_name);

379: l_num_warn := l_num_warn + 1;
380: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
381: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
382: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_GLOBAL_PARAMETER');
383: wsh_util_core.add_message(l_return_status,l_module_name);
384:
385: x_return_status := l_return_status;
386: --
387: IF l_debug_on THEN

Line 439: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

435: IF l_debug_on THEN
436: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);
437: END IF;
438:
439: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
440: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
441:
442: --reject failed delivery
443: IF l_debug_on THEN

Line 440: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

436: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);
437: END IF;
438:
439: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
440: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
441:
442: --reject failed delivery
443: IF l_debug_on THEN
444: wsh_debug_sv.logmsg(l_module_name, 'Error: cannot get delivery record');

Line 451: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

447: l_num_error := l_num_error + 1;
448: x_rejected_del_id.EXTEND;
449: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;
450: GOTO loop_end;
451: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
452: l_num_warn := l_num_warn + 1;
453: END IF;
454:
455: --accept all delete required or ignore for planning deliveries, no need to split

Line 493: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

489: l_return_status);
490: END IF;
491:
492: --only locking one delivery, should have no warning status for l_return_status
493: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
494:
495: IF l_debug_on THEN
496: wsh_debug_sv.logmsg(l_module_name,
497: 'Unable to lock the delivery');

Line 536: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

532: IF l_debug_on THEN
533: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);
534: END IF;
535:
536: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
537: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
538:
539: ROLLBACK TO delivery_record;
540:

Line 537: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

533: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);
534: END IF;
535:
536: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
537: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
538:
539: ROLLBACK TO delivery_record;
540:
541: --reject failed delivery

Line 550: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

546: l_num_error := l_num_error + 1;
547: x_rejected_del_id.EXTEND;
548: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;
549: GOTO loop_end;
550: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
551: l_num_warn := l_num_warn + 1;
552: END IF;
553:
554: IF l_debug_on THEN

Line 568: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

564: IF l_debug_on THEN
565: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get: ' || l_return_status);
566: END IF;
567:
568: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
569: l_num_warn := l_num_warn + 1;
570: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
571: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
572:

Line 570: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

566: END IF;
567:
568: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
569: l_num_warn := l_num_warn + 1;
570: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
571: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
572:
573: ROLLBACK TO delivery_record;
574: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');

Line 571: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

567:
568: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
569: l_num_warn := l_num_warn + 1;
570: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
571: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
572:
573: ROLLBACK TO delivery_record;
574: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
575: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',

Line 576: wsh_util_core.get_org_name(p_delivery_tab(i).organization_id));

572:
573: ROLLBACK TO delivery_record;
574: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
575: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
576: wsh_util_core.get_org_name(p_delivery_tab(i).organization_id));
577: wsh_util_core.add_message(l_return_status,l_module_name);
578: l_num_error := l_num_error+1;
579:
580: IF l_debug_on THEN

Line 577: wsh_util_core.add_message(l_return_status,l_module_name);

573: ROLLBACK TO delivery_record;
574: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
575: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
576: wsh_util_core.get_org_name(p_delivery_tab(i).organization_id));
577: wsh_util_core.add_message(l_return_status,l_module_name);
578: l_num_error := l_num_error+1;
579:
580: IF l_debug_on THEN
581: wsh_debug_sv.logmsg(l_module_name, 'Error: cannot get shipping parameter info');

Line 641: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

637: IF l_debug_on THEN
638: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
639: END IF;
640:
641: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
642: l_num_error := l_num_error+1;
643: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
644: l_num_warn := l_num_warn+1;
645: END IF;

Line 643: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

639: END IF;
640:
641: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
642: l_num_error := l_num_error+1;
643: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
644: l_num_warn := l_num_warn+1;
645: END IF;
646:
647: x_rejected_del_id.EXTEND;

Line 760: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

756: IF l_debug_on THEN
757: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
758: END IF;
759:
760: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
761: l_num_error := l_num_error+1;
762: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
763: l_num_warn := l_num_warn+1;
764: END IF;

Line 762: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

758: END IF;
759:
760: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
761: l_num_error := l_num_error+1;
762: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
763: l_num_warn := l_num_warn+1;
764: END IF;
765:
766: x_rejected_del_id.EXTEND;

Line 801: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

797: IF l_debug_on THEN
798: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
799: END IF;
800:
801: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
802: l_num_error := l_num_error+1;
803: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
804: l_num_warn := l_num_warn+1;
805: END IF;

Line 803: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

799: END IF;
800:
801: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
802: l_num_error := l_num_error+1;
803: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
804: l_num_warn := l_num_warn+1;
805: END IF;
806:
807: x_rejected_del_id.EXTEND;

Line 837: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

833: IF l_debug_on THEN
834: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
835: END IF;
836:
837: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
838: l_num_error := l_num_error+1;
839: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
840: l_num_warn := l_num_warn+1;
841: END IF;

Line 839: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

835: END IF;
836:
837: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
838: l_num_error := l_num_error+1;
839: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
840: l_num_warn := l_num_warn+1;
841: END IF;
842:
843: x_rejected_del_id.EXTEND;

Line 874: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

870: IF l_debug_on THEN
871: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
872: END IF;
873:
874: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
875: l_num_error := l_num_error+1;
876: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
877: l_num_warn := l_num_warn+1;
878: END IF;

Line 876: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

872: END IF;
873:
874: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
875: l_num_error := l_num_error+1;
876: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
877: l_num_warn := l_num_warn+1;
878: END IF;
879:
880: x_rejected_del_id.EXTEND;

Line 915: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

911: IF l_debug_on THEN
912: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
913: END IF;
914:
915: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
916: l_num_error := l_num_error+1;
917: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
918: l_num_warn := l_num_warn+1;
919: END IF;

Line 917: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

913: END IF;
914:
915: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
916: l_num_error := l_num_error+1;
917: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
918: l_num_warn := l_num_warn+1;
919: END IF;
920:
921: x_rejected_del_id.EXTEND;

Line 961: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

957: IF l_debug_on THEN
958: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
959: END IF;
960:
961: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
962: l_num_error := l_num_error+1;
963: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
964: l_num_warn := l_num_warn+1;
965: END IF;

Line 963: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

959: END IF;
960:
961: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
962: l_num_error := l_num_error+1;
963: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
964: l_num_warn := l_num_warn+1;
965: END IF;
966:
967: x_rejected_del_id.EXTEND;

Line 1017: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1013: IF l_debug_on THEN
1014: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS: ' || l_return_status);
1015: END IF;
1016:
1017: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1018:
1019: ROLLBACK TO delivery_record;
1020:
1021: l_num_error := l_num_error+1;

Line 1047: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1043: x_rejected_del_id.EXTEND;
1044: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;
1045: GOTO loop_end;
1046:
1047: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1048: l_num_warn := l_num_warn+1;
1049: END IF;
1050:
1051: l_new_weight := 0;

Line 1095: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES: ' || l_return_status);
1093: END IF;
1094:
1095: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1096:
1097: ROLLBACK TO delivery_record;
1098:
1099: l_num_error := l_num_error+1;

Line 1124: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1120: x_rejected_del_id.EXTEND;
1121: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;
1122: GOTO loop_end;
1123:
1124: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1125: l_num_warn := l_num_warn+1;
1126: END IF;
1127:
1128: z := l_temp_ids.FIRST;

Line 1152: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
1150: END IF;
1151:
1152: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1153:
1154: ROLLBACK TO delivery_record;
1155: IF l_debug_on THEN
1156: wsh_debug_sv.logmsg(l_module_name, 'Error during log delivery exception');

Line 1163: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1159: l_num_error := l_num_error+1;
1160: x_rejected_del_id.EXTEND;
1161: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;
1162: GOTO loop_end;
1163: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1164: l_num_warn := l_num_warn+1;
1165: END IF;
1166:
1167: l_curr_del_split_list(l_curr_del_split_list.COUNT+1) := l_temp_ids(z);

Line 1209: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1205: IF l_debug_on THEN
1206: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES: ' || l_return_status);
1207: END IF;
1208:
1209: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1210:
1211: ROLLBACK TO delivery_record;
1212:
1213: l_num_error := l_num_error+1;

Line 1239: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1235: x_rejected_del_id.EXTEND;
1236: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;
1237: GOTO loop_end;
1238:
1239: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1240: l_num_warn := l_num_warn+1;
1241: END IF;
1242:
1243: z := l_temp_ids.FIRST;

Line 1267: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1263: IF l_debug_on THEN
1264: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
1265: END IF;
1266:
1267: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1268:
1269: ROLLBACK TO delivery_record;
1270:
1271: IF l_debug_on THEN

Line 1279: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1275: l_num_error := l_num_error+1;
1276: x_rejected_del_id.EXTEND;
1277: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;
1278: GOTO loop_end;
1279: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1280: l_num_warn := l_num_warn+1;
1281: END IF;
1282:
1283: l_curr_del_split_list(l_curr_del_split_list.COUNT+1) := l_temp_ids(z);

Line 1345: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1341: IF l_debug_on THEN
1342: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
1343: END IF;
1344:
1345: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1346:
1347: ROLLBACK TO delivery_record;
1348:
1349: --reject failed delivery

Line 1358: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1354: l_num_error := l_num_error+1;
1355: x_rejected_del_id.EXTEND;
1356: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;
1357: GOTO loop_end;
1358: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1359: l_num_warn := l_num_warn+1;
1360: END IF;
1361:
1362: z := l_curr_del_split_list.FIRST;

Line 1395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1391: NULL;
1392: END LOOP;
1393:
1394: IF (l_num_error > 0 AND l_num_error = p_delivery_tab.COUNT) THEN
1395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1396: ELSIF (l_num_error > 0 OR l_num_warn > 0) THEN
1397: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1398: ELSE
1399: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1397: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1393:
1394: IF (l_num_error > 0 AND l_num_error = p_delivery_tab.COUNT) THEN
1395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1396: ELSIF (l_num_error > 0 OR l_num_warn > 0) THEN
1397: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1398: ELSE
1399: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1400: END IF;
1401: --

Line 1399: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1396: ELSIF (l_num_error > 0 OR l_num_warn > 0) THEN
1397: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1398: ELSE
1399: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1400: END IF;
1401: --
1402: -- Debug Statements
1403: --

Line 1416: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1412: --
1413: WHEN FND_API.G_EXC_ERROR THEN
1414:
1415: ROLLBACK TO delivery_record;
1416: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1417: --
1418: IF (c_get_delivery_line_and_cont%ISOPEN) THEN
1419: CLOSE c_get_delivery_line_and_cont;
1420: END IF;

Line 1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1436: --
1437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1438: --
1439: ROLLBACK TO delivery_record;
1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1441: --
1442: IF (c_get_delivery_line_and_cont%ISOPEN) THEN
1443: CLOSE c_get_delivery_line_and_cont;
1444: END IF;

Line 1467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1463: WHEN NO_DATA_FOUND THEN
1464:
1465: ROLLBACK TO delivery_record;
1466: FND_MESSAGE.Set_Name('WSH','WSH_DEL_NOT_FOUND');
1467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1468: --
1469: IF (c_get_delivery_line_and_cont%ISOPEN) THEN
1470: CLOSE c_get_delivery_line_and_cont;
1471: END IF;

Line 1481: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

1477: IF c_get_delivery_line%ISOPEN THEN
1478: CLOSE c_get_delivery_line;
1479: END IF;
1480: --
1481: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1482: --
1483: IF l_debug_on THEN
1484: WSH_DEBUG_SV.logmsg(l_module_name,
1485: 'NO_DATA_FOUND exception has occured.',

Line 1494: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1490:
1491: WHEN OTHERS THEN
1492:
1493: ROLLBACK TO delivery_record;
1494: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1495: --
1496: IF (c_get_delivery_line_and_cont%ISOPEN) THEN
1497: CLOSE c_get_delivery_line_and_cont;
1498: END IF;

Line 1508: WSH_UTIL_CORE.DEFAULT_HANDLER(

1504: IF c_get_delivery_line%ISOPEN THEN
1505: CLOSE c_get_delivery_line;
1506: END IF;
1507: --
1508: WSH_UTIL_CORE.DEFAULT_HANDLER(
1509: 'WSH_DELIVERY_SPLITTER_PKG.DELIVERY_SPLITTER', l_module_name);
1510: IF l_debug_on THEN
1511: WSH_DEBUG_SV.logmsg(l_module_name,
1512: 'Unexpected error has occured. Oracle error message is '||