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_NEW_DELIVERY_ACTIONS dependencies on WSH_NEW_DELIVERY_ACTIONS

Line 1: PACKAGE BODY WSH_NEW_DELIVERY_ACTIONS as

1: PACKAGE BODY WSH_NEW_DELIVERY_ACTIONS as
2: /* $Header: WSHDEACB.pls 120.51 2008/01/14 15:39:25 skanduku ship $ */
3:
4:
5: g_object_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;

Line 5: g_object_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;

1: PACKAGE BODY WSH_NEW_DELIVERY_ACTIONS as
2: /* $Header: WSHDEACB.pls 120.51 2008/01/14 15:39:25 skanduku ship $ */
3:
4:
5: g_object_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
6:
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_NEW_DELIVERY_ACTIONS';

Line 9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_NEW_DELIVERY_ACTIONS';

5: g_object_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
6:
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_NEW_DELIVERY_ACTIONS';
10: --
11:
12: -- Global variables used in Cont_Tobe_Unassigned and Get_Topmost_Unassignable_Cont
13: g_container_lines wsh_util_core.id_tab_type ;

Line 239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.GET_TOPMOST_UNASSIGNABLE_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);

235: END LOOP;
236: g_traversed_containers(g_traversed_containers.count + 1) := l_container_id ;
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.logmsg(l_module_name,'Recursive call for container :'||l_container_id);
239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.GET_TOPMOST_UNASSIGNABLE_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
240: END IF;
241: get_topmost_unassignable_cont( l_container_id, p_staged_lines, l_return_status );
242: IF l_return_status IN ( WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
243: IF l_debug_on THEN

Line 244: WSH_DEBUG_SV.log(l_module_name, 'Return Status from WSH_NEW_DELIVERY_ACTIONS.GET_TOPMOST_UNASSIGNABLE_CONT : ', l_return_status);

240: END IF;
241: get_topmost_unassignable_cont( l_container_id, p_staged_lines, l_return_status );
242: IF l_return_status IN ( WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
243: IF l_debug_on THEN
244: WSH_DEBUG_SV.log(l_module_name, 'Return Status from WSH_NEW_DELIVERY_ACTIONS.GET_TOPMOST_UNASSIGNABLE_CONT : ', l_return_status);
245: END IF;
246: g_container_lines.delete;
247: RAISE NO_DATA_FOUND;
248: END IF;

Line 266: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Get_Topmost_Unassignable_Cont',l_module_name);

262: --
263:
264: EXCEPTION
265: WHEN OTHERS THEN
266: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Get_Topmost_Unassignable_Cont',l_module_name);
267: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
268: IF get_lines%ISOPEN THEN
269: CLOSE get_lines;
270: END IF;

Line 329: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.GET_TOPMOST_UNASSIGNABLE_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);

325: --
326: -- Debug Statements
327: --
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.GET_TOPMOST_UNASSIGNABLE_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
330: WSH_DEBUG_SV.log(l_module_name, 'Staged Detail Line: ', p_staged_lines(i));
331: END IF;
332: --
333: get_topmost_unassignable_cont( p_staged_lines(i), p_staged_lines, l_return_status );

Line 337: WSH_DEBUG_SV.log(l_module_name, 'Return Status from WSH_NEW_DELIVERY_ACTIONS.GET_TOPMOST_UNASSIGNABLE_CONT : ', l_return_status);

333: get_topmost_unassignable_cont( p_staged_lines(i), p_staged_lines, l_return_status );
334:
335: IF l_return_status IN ( WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
336: IF l_debug_on THEN
337: WSH_DEBUG_SV.log(l_module_name, 'Return Status from WSH_NEW_DELIVERY_ACTIONS.GET_TOPMOST_UNASSIGNABLE_CONT : ', l_return_status);
338: END IF;
339: x_unassigned_cont.delete;
340: RAISE NO_DATA_FOUND;
341: END IF;

Line 365: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Cont_ToBe_Unassigned',l_module_name);

361: --
362:
363: EXCEPTION
364: WHEN OTHERS THEN
365: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Cont_ToBe_Unassigned',l_module_name);
366: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
367: IF l_debug_on THEN
368: WSH_DEBUG_SV.pop(l_module_name,'When Others');
369: END IF;

Line 468: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.VALIDATE_DEL_CONTAINERS',l_module_name);

464: --}
465: EXCEPTION
466: --{
467: WHEN OTHERS THEN
468: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.VALIDATE_DEL_CONTAINERS',l_module_name);
469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
470: IF l_debug_on THEN
471: WSH_DEBUG_SV.pop(l_module_name,'When Others');
472: END IF;

Line 590: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.FIRM');

586: END IF;
587:
588: EXCEPTION
589: WHEN others THEN
590: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.FIRM');
591: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1457: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.ADJUST_PLANNED_FLAG',l_module_name);

1453: FND_MESSAGE.Set_Name('WSH', 'WSH_DLVY_LOCK_FAILED');
1454: FND_MESSAGE.Set_Token('ENTITY_NAME',to_char(l_delivery_id));
1455: wsh_util_core.add_message(x_return_status,l_module_name);
1456:
1457: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.ADJUST_PLANNED_FLAG',l_module_name);
1458: IF l_debug_on THEN
1459: wsh_debug_sv.logmsg(l_module_name,'Delivery cannot be locked, Oracle error message is ' || SQLERRM);
1460: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:record_locked');
1461: END IF;

Line 1552: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.PLAN');

1548: END IF;
1549:
1550: EXCEPTION
1551: WHEN others THEN
1552: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.PLAN');
1553: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1554:
1555:
1556: --

Line 1722: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UNPLAN');

1718: END IF;
1719: --
1720: EXCEPTION
1721: WHEN others THEN
1722: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UNPLAN');
1723: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1724:
1725: --
1726: -- Debug Statements

Line 2479: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Get_Delivery_Defaults');

2475: --
2476:
2477: EXCEPTION
2478: WHEN others THEN
2479: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Get_Delivery_Defaults');
2480: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2481: --
2482: IF l_debug_on THEN
2483: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4032: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';

4028: l_num_error := l_num_error + 1 ;
4029: END IF;
4030:
4031: wsh_util_core.add_message(x_return_status);
4032: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
4033: --bug 2770400
4034: IF l_batch_id IS NOT NULL THEN
4035: -- in batch mode ,stop confirming the delivery
4036: wsh_util_core.add_message(x_return_status);

Line 4876: g_missing_inv_severity := wsh_ru_actions.get_message_severity (wsh_new_delivery_actions.g_ship_confirm_act

4872: IF l_debug_on THEN
4873: WSH_DEBUG_SV.log(l_module_name,'g_missing_inv_severity - '|| g_missing_inv_severity);
4874: End If;
4875: If g_missing_inv_severity is null then
4876: g_missing_inv_severity := wsh_ru_actions.get_message_severity (wsh_new_delivery_actions.g_ship_confirm_act
4877: ,wsh_new_delivery_actions.g_missing_inv_cntl_msg);
4878: End If;
4879:
4880: -- bug 2283621 - pass the l_inv_ctrl_dd_ids to the warning message

Line 4877: ,wsh_new_delivery_actions.g_missing_inv_cntl_msg);

4873: WSH_DEBUG_SV.log(l_module_name,'g_missing_inv_severity - '|| g_missing_inv_severity);
4874: End If;
4875: If g_missing_inv_severity is null then
4876: g_missing_inv_severity := wsh_ru_actions.get_message_severity (wsh_new_delivery_actions.g_ship_confirm_act
4877: ,wsh_new_delivery_actions.g_missing_inv_cntl_msg);
4878: End If;
4879:
4880: -- bug 2283621 - pass the l_inv_ctrl_dd_ids to the warning message
4881: IF l_debug_on THEN

Line 4891: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';

4887: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DETAILS_INV_CONTROLS');
4888: FND_MESSAGE.Set_Token('DETAIL_IDS', l_inv_ctrl_dd_ids);
4889: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4890: wsh_util_core.add_message(x_return_status);
4891: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
4892: l_num_error := l_num_error + 1;
4893: goto confirm_error_no_msg;
4894: Else
4895: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DETAILS_INV_CONTROLS');

Line 4899: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';

4895: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DETAILS_INV_CONTROLS');
4896: FND_MESSAGE.Set_Token('DETAIL_IDS', l_inv_ctrl_dd_ids);
4897: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4898: wsh_util_core.add_message(x_return_status);
4899: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
4900: End If;
4901: END IF;
4902: /***************************Material Status Project***************************************/
4903: IF (NOT l_inv_material_flag) THEN

Line 4909: wsh_new_delivery_actions.g_ship_confirm_act,

4905: WSH_DEBUG_SV.log(l_module_name,'g_missing_inv_severity - '|| g_missing_inv_severity);
4906: End If;
4907: If g_missing_inv_severity is null then
4908: g_missing_inv_severity := wsh_ru_actions.get_message_severity (
4909: wsh_new_delivery_actions.g_ship_confirm_act,
4910: wsh_new_delivery_actions.g_invalid_material_status_msg);
4911: End If;
4912:
4913: IF l_debug_on THEN

Line 4910: wsh_new_delivery_actions.g_invalid_material_status_msg);

4906: End If;
4907: If g_missing_inv_severity is null then
4908: g_missing_inv_severity := wsh_ru_actions.get_message_severity (
4909: wsh_new_delivery_actions.g_ship_confirm_act,
4910: wsh_new_delivery_actions.g_invalid_material_status_msg);
4911: End If;
4912:
4913: IF l_debug_on THEN
4914: WSH_DEBUG_SV.log(l_module_name,'l_inv_material_dd_ids - '|| l_inv_material_dd_ids);

Line 4923: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';

4919: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_MATERIAL_STATUS');
4920: FND_MESSAGE.Set_Token('DETAIL_IDS', l_inv_material_dd_ids);
4921: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4922: wsh_util_core.add_message(x_return_status);
4923: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
4924: l_num_error := l_num_error + 1;
4925: goto confirm_error_no_msg;
4926: Else
4927: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_MATERIAL_STATUS');

Line 4931: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';

4927: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_MATERIAL_STATUS');
4928: FND_MESSAGE.Set_Token('DETAIL_IDS', l_inv_material_dd_ids);
4929: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4930: wsh_util_core.add_message(x_return_status);
4931: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
4932: End If;
4933: END IF;
4934: /***************************Material Status Project***************************************/
4935:

Line 5088: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.CONT_TOBE_UNASSIGNED',WSH_DEBUG_SV.C_PROC_LEVEL);

5084: --
5085: -- Debug Statements
5086: --
5087: IF l_debug_on THEN
5088: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.CONT_TOBE_UNASSIGNED',WSH_DEBUG_SV.C_PROC_LEVEL);
5089: END IF;
5090: -- Identify the Staged Lines or Containers to be Unassigned from the Delivery
5091: Cont_ToBe_Unassigned ( p_staged_lines => l_stage_rows,
5092: x_unassigned_cont => x_unassigned_cont,

Line 5234: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';

5230: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
5231: wsh_util_core.get_org_name(l_organization_id));
5232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5233: wsh_util_core.add_message(x_return_status);
5234: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
5235: goto confirm_error;
5236: END IF;
5237:
5238:

Line 5278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);

5274: END IF;
5275:
5276: --deliveryMerge
5277: IF l_debug_on THEN
5278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);
5279: END IF;
5280: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(
5281: p_delivery_ids => l_dummy_rows,
5282: p_caller => 'WSH_DLMG',

Line 5280: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(

5276: --deliveryMerge
5277: IF l_debug_on THEN
5278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);
5279: END IF;
5280: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(
5281: p_delivery_ids => l_dummy_rows,
5282: p_caller => 'WSH_DLMG',
5283: p_force_appending_limit => 'N',
5284: p_call_lcss => 'Y',

Line 6296: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';

6292: --
6293: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6294: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6295: wsh_util_core.add_message(x_return_status);
6296: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
6297: l_num_warn := l_num_warn + 1;
6298: END IF;
6299:
6300: l_mdc_index_i := 0;

Line 6310: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(

6306: -- K: MDC Remove the delivery from the consol delivery and trip.
6307: IF dg.parent_delivery_id IS NOT NULL THEN
6308: l_mdc_cl_del_tab(1) := p_del_rows(i);
6309: l_mdc_co_del_tab.delete(i);
6310: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(
6311: p_parent_del => NULL,
6312: p_caller => p_caller,
6313: p_del_tab => l_mdc_cl_del_tab,
6314: x_return_status => l_return_status);

Line 6805: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE',WSH_DEBUG_SV.C_PROC_LEVEL);

6801: --
6802: -- Debug Statements
6803: --
6804: IF l_debug_on THEN
6805: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE',WSH_DEBUG_SV.C_PROC_LEVEL);
6806: END IF;
6807: --
6808: wsh_new_delivery_actions.update_leg_sequence(
6809: p_delivery_id => u_del_rows(i),

Line 6808: wsh_new_delivery_actions.update_leg_sequence(

6804: IF l_debug_on THEN
6805: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE',WSH_DEBUG_SV.C_PROC_LEVEL);
6806: END IF;
6807: --
6808: wsh_new_delivery_actions.update_leg_sequence(
6809: p_delivery_id => u_del_rows(i),
6810: x_return_status => l_return_status);
6811:
6812: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 7261: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.CONFIRM_DELIVERY');

7257:
7258: IF get_del_first_trip%isopen THEN
7259: CLOSE get_del_first_trip;
7260: END IF;
7261: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.CONFIRM_DELIVERY');
7262: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7263:
7264: --
7265: -- Debug Statements

Line 7692: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.setInTransit',l_module_name);

7688: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7689: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7690: END IF;
7691: WHEN others THEN
7692: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.setInTransit',l_module_name);
7693: --
7694: --ROLLBACK TO dlvy_setInTransit_begin_sp;
7695: --
7696: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 8010: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.setClose',l_module_name);

8006: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8007: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
8008: END IF;
8009: WHEN others THEN
8010: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.setClose',l_module_name);
8011: --
8012: --ROLLBACK TO dlvy_close_begin_sp;
8013: --
8014: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 8551: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.CHANGE_STATUS',l_module_name);

8547: END IF;
8548: --
8549: WHEN others THEN
8550:
8551: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.CHANGE_STATUS',l_module_name);
8552: ROLLBACK TO dlvy_chg_status_begin_sp;
8553: --
8554: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8555:

Line 8800: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Complete_Leg_Sequence');

8796: END IF;
8797: --
8798: EXCEPTION
8799: WHEN others THEN
8800: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Complete_Leg_Sequence');
8801: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8802:
8803: IF l_debug_on THEN
8804: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 8875: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE');

8871: END IF;
8872: --
8873: EXCEPTION
8874: WHEN others THEN
8875: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE');
8876: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8877:
8878: IF l_debug_on THEN
8879: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 8965: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE');

8961: END IF;
8962: --
8963: EXCEPTION
8964: WHEN others THEN
8965: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE');
8966: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8967:
8968: IF l_debug_on THEN
8969: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 9228: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.GENERATE_LOADING_SEQ');

9224: END IF;
9225: IF (detailinfo_cv%ISOPEN) THEN
9226: CLOSE detailinfo_cv;
9227: END IF;
9228: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.GENERATE_LOADING_SEQ');
9229: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9230:
9231: --
9232: -- Debug Statements

Line 9747: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',l_module_name);

9743: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:e_locked');
9744: END IF;
9745: WHEN OTHERS THEN
9746: x_return_status := fnd_api.g_ret_sts_unexp_error;
9747: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',l_module_name);
9748: --
9749: IF l_debug_on THEN
9750: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
9751: END IF;

Line 10154: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.update_ship_from_location', l_module_name);

10150: WHEN OTHERS THEN
10151:
10152: ROLLBACK TO update_ship_from_location_sp;
10153: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10154: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.update_ship_from_location', l_module_name);
10155: IF l_debug_on THEN
10156: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
10157: END IF;
10158: --

Line 10241: wsh_util_core.default_handler('wsh_new_delivery_actions.check_last_del_trip',l_module_name);

10237:
10238: EXCEPTION
10239:
10240: WHEN OTHERS THEN
10241: wsh_util_core.default_handler('wsh_new_delivery_actions.check_last_del_trip',l_module_name);
10242: --
10243: IF l_debug_on THEN
10244: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
10245: END IF;

Line 10409: wsh_util_core.default_handler('wsh_new_delivery_actions.get_trip_status',l_module_name);

10405: END IF;
10406:
10407: EXCEPTION
10408: WHEN OTHERS THEN
10409: wsh_util_core.default_handler('wsh_new_delivery_actions.get_trip_status',l_module_name);
10410: --
10411: IF l_debug_on THEN
10412: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
10413: END IF;

Line 10483: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.IS_DLVY_CONTENT');

10479: IF c_get_console_delivery%ISOPEN THEN
10480: CLOSE c_get_console_delivery;
10481: END IF;
10482:
10483: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.IS_DLVY_CONTENT');
10484: --
10485: IF l_debug_on THEN
10486: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10487: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 10615: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.get_ship_to_site');

10611: IF ( c_get_ship_to_site%ISOPEN) THEN
10612: CLOSE c_get_ship_to_site;
10613: END IF;
10614: --
10615: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.get_ship_to_site');
10616: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10617: --
10618:
10619: IF l_debug_on THEN

Line 10752: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.get_ship_to_customer');

10748: IF (c_get_shipto_cust_from_dlvy%ISOPEN) THEN
10749: CLOSE c_get_shipto_cust_from_dlvy;
10750: END IF;
10751: --
10752: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.get_ship_to_customer');
10753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10754: --
10755: IF l_debug_on THEN
10756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 11028: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.SET_PICK_UP_DROP_OFF_DATES',l_module_name);

11024: EXCEPTION
11025:
11026: WHEN OTHERS THEN
11027:
11028: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.SET_PICK_UP_DROP_OFF_DATES',l_module_name);
11029: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
11030:
11031: IF get_transit_time%ISOPEN THEN
11032: CLOSE get_transit_time;

Line 11051: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --

11047: -- --
11048: -- TYPE: PROCEDURE --
11049: -- --
11050: -- --
11051: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11052: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11053: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11054: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11055: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --

Line 11052: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --

11048: -- TYPE: PROCEDURE --
11049: -- --
11050: -- --
11051: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11052: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11053: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11054: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11055: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11056: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --

Line 11053: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --

11049: -- --
11050: -- --
11051: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11052: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11053: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11054: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11055: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11056: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11057: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --

Line 11054: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --

11050: -- --
11051: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11052: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11053: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11054: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11055: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11056: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11057: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11058: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --

Line 11055: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --

11051: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11052: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11053: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11054: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11055: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11056: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11057: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11058: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11059: -- --

Line 11056: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --

11052: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11053: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11054: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11055: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11056: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11057: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11058: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11059: -- --
11060: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --

Line 11057: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --

11053: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11054: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11055: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11056: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11057: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11058: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11059: -- --
11060: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --
11061: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type

Line 11058: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --

11054: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11055: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11056: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11057: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11058: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11059: -- --
11060: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --
11061: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type
11062: --

Line 11077: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --

11073: -- DATE VERSION BY BUG DESCRIPTION --
11074: -- ---------- ------- -------- ------- ---------------------------------- --
11075: -- 2002/12/09 I ABLUNDEL ------- Created --
11076: -- Attribute passed initially --
11077: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11078: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11079: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11080: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11081: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --

Line 11078: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --

11074: -- ---------- ------- -------- ------- ---------------------------------- --
11075: -- 2002/12/09 I ABLUNDEL ------- Created --
11076: -- Attribute passed initially --
11077: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11078: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11079: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11080: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11081: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11082: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --

Line 11079: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --

11075: -- 2002/12/09 I ABLUNDEL ------- Created --
11076: -- Attribute passed initially --
11077: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11078: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11079: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11080: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11081: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11082: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11083: -- --

Line 11080: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --

11076: -- Attribute passed initially --
11077: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11078: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11079: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11080: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11081: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11082: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11083: -- --
11084: -- -------------------------------------------------------------------------- --

Line 11081: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --

11077: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11078: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11079: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11080: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11081: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11082: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11083: -- --
11084: -- -------------------------------------------------------------------------- --
11085:

Line 11082: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --

11078: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11079: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11080: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11081: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11082: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11083: -- --
11084: -- -------------------------------------------------------------------------- --
11085:
11086: -- Result table will be of type Shipping

Line 11496: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_NEW_DELIVERY_ACTIONS.FORMAT_DEL_UPDATE_TABLE IS ' ||l_error_text);

11492: --
11493: -- Debug Statements
11494: --
11495: IF l_debug_on THEN
11496: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_NEW_DELIVERY_ACTIONS.FORMAT_DEL_UPDATE_TABLE IS ' ||l_error_text);
11497: END IF;
11498: --
11499: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.FORMAT_DEL_UPDATE_TABLE');
11500: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);

Line 11499: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.FORMAT_DEL_UPDATE_TABLE');

11495: IF l_debug_on THEN
11496: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_NEW_DELIVERY_ACTIONS.FORMAT_DEL_UPDATE_TABLE IS ' ||l_error_text);
11497: END IF;
11498: --
11499: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.FORMAT_DEL_UPDATE_TABLE');
11500: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
11501: --
11502: -- Debug Statements
11503: --

Line 11634: l_trip_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;

11630: where wnd.delivery_id = p_del_id;
11631: */
11632:
11633:
11634: l_trip_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
11635: l_return_status VARCHAR2(1); -- returning error/success/warning
11636: l_return_message VARCHAR2(2000); -- hold a return error message
11637: l_BatchSize PLS_INTEGER := 500; -- max rows from a batch fetch
11638: l_current_rows PLS_INTEGER; -- number of current rows fetched

Line 12741: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.PROCESS_CARRIER_SELECTION');

12737: WHEN OTHERS THEN
12738: l_error_code := SQLCODE;
12739: l_error_text := SQLERRM;
12740:
12741: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.PROCESS_CARRIER_SELECTION');
12742: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
12743: x_return_message := l_error_text;
12744:
12745:

Line 13573: wsh_util_core.default_handler('wsh_new_delivery_actions.Assign_Del_to_Consol_Del',l_module_name);

13569: END IF;
13570: IF c_check_valid_child%ISOPEN THEN
13571: CLOSE c_check_valid_child;
13572: END IF;
13573: wsh_util_core.default_handler('wsh_new_delivery_actions.Assign_Del_to_Consol_Del',l_module_name);
13574: --
13575: IF l_debug_on THEN
13576: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
13577: END IF;

Line 14044: wsh_util_core.default_handler('wsh_new_delivery_actions.Unassign_Dels_from_Consol_Del',l_module_name);

14040: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CHILD_DELIVERIES');
14041: END IF;
14042: --
14043: WHEN OTHERS THEN
14044: wsh_util_core.default_handler('wsh_new_delivery_actions.Unassign_Dels_from_Consol_Del',l_module_name);
14045: --
14046: IF c_check_parent_exists%ISOPEN THEN
14047: CLOSE c_check_parent_exists;
14048: END IF;

Line 14335: wsh_util_core.default_handler('wsh_new_delivery_actions.Confirm_Consolidation_Delivery',l_module_name);

14331: --
14332: -- bug 4505105
14333: WHEN OTHERS THEN
14334: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
14335: wsh_util_core.default_handler('wsh_new_delivery_actions.Confirm_Consolidation_Delivery',l_module_name);
14336: --
14337: IF l_debug_on THEN
14338: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
14339: END IF;

Line 14542: wsh_util_core.default_handler('wsh_new_delivery_actions.Confirm_Consolidation_Delivery',l_module_name);

14538: END IF;
14539: --
14540: WHEN OTHERS THEN
14541: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
14542: wsh_util_core.default_handler('wsh_new_delivery_actions.Confirm_Consolidation_Delivery',l_module_name);
14543: --
14544: IF l_debug_on THEN
14545: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
14546: END IF;

Line 14625: wsh_util_core.default_handler('wsh_new_delivery_actions.is_delivery_empty',l_module_name);

14621: RETURN l_return_value;
14622: EXCEPTION
14623:
14624: WHEN OTHERS THEN
14625: wsh_util_core.default_handler('wsh_new_delivery_actions.is_delivery_empty',l_module_name);
14626: --
14627: IF (c_delivery_detail_count%ISOPEN) THEN
14628: CLOSE c_delivery_detail_count;
14629: END IF;

Line 14642: END WSH_NEW_DELIVERY_ACTIONS;

14638: RETURN l_return_value;
14639: END IS_DELIVERY_EMPTY;
14640: --END OTM R12
14641:
14642: END WSH_NEW_DELIVERY_ACTIONS;