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.57.12020000.6 2013/04/08 10:56:15 suppal 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.57.12020000.6 2013/04/08 10:56:15 suppal 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 2510: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Get_Delivery_Defaults');

2506: --
2507:
2508: EXCEPTION
2509: WHEN others THEN
2510: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Get_Delivery_Defaults');
2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2512: --
2513: IF l_debug_on THEN
2514: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

4081: l_num_error := l_num_error + 1 ;
4082: END IF;
4083:
4084: wsh_util_core.add_message(x_return_status);
4085: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
4086: --bug 2770400
4087: IF l_batch_id IS NOT NULL THEN
4088: -- in batch mode ,stop confirming the delivery
4089: wsh_util_core.add_message(x_return_status);

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

4956: IF l_debug_on THEN
4957: WSH_DEBUG_SV.log(l_module_name,'g_missing_inv_severity - '|| g_missing_inv_severity);
4958: End If;
4959: If g_missing_inv_severity is null then
4960: g_missing_inv_severity := wsh_ru_actions.get_message_severity (wsh_new_delivery_actions.g_ship_confirm_act
4961: ,wsh_new_delivery_actions.g_missing_inv_cntl_msg);
4962: End If;
4963:
4964: -- bug 2283621 - pass the l_inv_ctrl_dd_ids to the warning message

Line 4961: ,wsh_new_delivery_actions.g_missing_inv_cntl_msg);

4957: WSH_DEBUG_SV.log(l_module_name,'g_missing_inv_severity - '|| g_missing_inv_severity);
4958: End If;
4959: If g_missing_inv_severity is null then
4960: g_missing_inv_severity := wsh_ru_actions.get_message_severity (wsh_new_delivery_actions.g_ship_confirm_act
4961: ,wsh_new_delivery_actions.g_missing_inv_cntl_msg);
4962: End If;
4963:
4964: -- bug 2283621 - pass the l_inv_ctrl_dd_ids to the warning message
4965: IF l_debug_on THEN

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

4971: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DETAILS_INV_CONTROLS');
4972: FND_MESSAGE.Set_Token('DETAIL_IDS', l_inv_ctrl_dd_ids);
4973: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4974: wsh_util_core.add_message(x_return_status);
4975: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
4976: l_num_error := l_num_error + 1;
4977: goto confirm_error_no_msg;
4978: Else
4979: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DETAILS_INV_CONTROLS');

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

4979: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DETAILS_INV_CONTROLS');
4980: FND_MESSAGE.Set_Token('DETAIL_IDS', l_inv_ctrl_dd_ids);
4981: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4982: wsh_util_core.add_message(x_return_status);
4983: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
4984: End If;
4985: END IF;
4986: /***************************Material Status Project***************************************/
4987: IF (NOT l_inv_material_flag) THEN

Line 4993: wsh_new_delivery_actions.g_ship_confirm_act,

4989: WSH_DEBUG_SV.log(l_module_name,'g_missing_inv_severity - '|| g_missing_inv_severity);
4990: End If;
4991: If g_missing_inv_severity is null then
4992: g_missing_inv_severity := wsh_ru_actions.get_message_severity (
4993: wsh_new_delivery_actions.g_ship_confirm_act,
4994: wsh_new_delivery_actions.g_invalid_material_status_msg);
4995: End If;
4996:
4997: IF l_debug_on THEN

Line 4994: wsh_new_delivery_actions.g_invalid_material_status_msg);

4990: End If;
4991: If g_missing_inv_severity is null then
4992: g_missing_inv_severity := wsh_ru_actions.get_message_severity (
4993: wsh_new_delivery_actions.g_ship_confirm_act,
4994: wsh_new_delivery_actions.g_invalid_material_status_msg);
4995: End If;
4996:
4997: IF l_debug_on THEN
4998: WSH_DEBUG_SV.log(l_module_name,'l_inv_material_dd_ids - '|| l_inv_material_dd_ids);

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

5003: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_MATERIAL_STATUS');
5004: FND_MESSAGE.Set_Token('DETAIL_IDS', l_inv_material_dd_ids);
5005: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5006: wsh_util_core.add_message(x_return_status);
5007: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
5008: l_num_error := l_num_error + 1;
5009: goto confirm_error_no_msg;
5010: Else
5011: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_MATERIAL_STATUS');

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

5011: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_MATERIAL_STATUS');
5012: FND_MESSAGE.Set_Token('DETAIL_IDS', l_inv_material_dd_ids);
5013: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5014: wsh_util_core.add_message(x_return_status);
5015: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
5016: End If;
5017: END IF;
5018: /***************************Material Status Project***************************************/
5019:

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

5168: --
5169: -- Debug Statements
5170: --
5171: IF l_debug_on THEN
5172: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.CONT_TOBE_UNASSIGNED',WSH_DEBUG_SV.C_PROC_LEVEL);
5173: END IF;
5174: -- Identify the Staged Lines or Containers to be Unassigned from the Delivery
5175: Cont_ToBe_Unassigned ( p_staged_lines => l_stage_rows,
5176: x_unassigned_cont => x_unassigned_cont,

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

5314: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
5315: wsh_util_core.get_org_name(l_organization_id));
5316: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5317: wsh_util_core.add_message(x_return_status);
5318: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
5319: goto confirm_error;
5320: END IF;
5321: --/== Workflow Changes
5322: l_enable_sc_wf := 'N'; --Workflow Changes

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

5383: END IF;
5384:
5385: --deliveryMerge
5386: IF l_debug_on THEN
5387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);
5388: END IF;
5389: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(
5390: p_delivery_ids => l_dummy_rows,
5391: p_caller => 'WSH_DLMG',

Line 5389: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(

5385: --deliveryMerge
5386: IF l_debug_on THEN
5387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);
5388: END IF;
5389: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(
5390: p_delivery_ids => l_dummy_rows,
5391: p_caller => 'WSH_DLMG',
5392: p_force_appending_limit => 'N',
5393: p_call_lcss => 'Y',

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

6432: --
6433: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6434: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6435: wsh_util_core.add_message(x_return_status);
6436: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
6437: l_num_warn := l_num_warn + 1;
6438: END IF;
6439:
6440: l_mdc_index_i := 0;

Line 6450: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(

6446: -- K: MDC Remove the delivery from the consol delivery and trip.
6447: IF dg.parent_delivery_id IS NOT NULL THEN
6448: l_mdc_cl_del_tab(1) := p_del_rows(i);
6449: l_mdc_co_del_tab.delete(i);
6450: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(
6451: p_parent_del => NULL,
6452: p_caller => p_caller,
6453: p_del_tab => l_mdc_cl_del_tab,
6454: x_return_status => l_return_status);

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

6941: --
6942: -- Debug Statements
6943: --
6944: IF l_debug_on THEN
6945: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE',WSH_DEBUG_SV.C_PROC_LEVEL);
6946: END IF;
6947: --
6948: wsh_new_delivery_actions.update_leg_sequence(
6949: p_delivery_id => u_del_rows(i),

Line 6948: wsh_new_delivery_actions.update_leg_sequence(

6944: IF l_debug_on THEN
6945: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE',WSH_DEBUG_SV.C_PROC_LEVEL);
6946: END IF;
6947: --
6948: wsh_new_delivery_actions.update_leg_sequence(
6949: p_delivery_id => u_del_rows(i),
6950: x_return_status => l_return_status);
6951:
6952: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

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

7397:
7398: IF get_del_first_trip%isopen THEN
7399: CLOSE get_del_first_trip;
7400: END IF;
7401: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.CONFIRM_DELIVERY');
7402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7403:
7404: --
7405: -- Debug Statements

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

7884: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7885: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7886: END IF;
7887: WHEN others THEN
7888: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.setInTransit',l_module_name);
7889: --
7890: --ROLLBACK TO dlvy_setInTransit_begin_sp;
7891: --
7892: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

8202: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8203: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
8204: END IF;
8205: WHEN others THEN
8206: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.setClose',l_module_name);
8207: --
8208: --ROLLBACK TO dlvy_close_begin_sp;
8209: --
8210: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

8743: END IF;
8744: --
8745: WHEN others THEN
8746:
8747: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.CHANGE_STATUS',l_module_name);
8748: ROLLBACK TO dlvy_chg_status_begin_sp;
8749: --
8750: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8751:

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

8992: END IF;
8993: --
8994: EXCEPTION
8995: WHEN others THEN
8996: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.Complete_Leg_Sequence');
8997: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8998:
8999: IF l_debug_on THEN
9000: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

9067: END IF;
9068: --
9069: EXCEPTION
9070: WHEN others THEN
9071: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE');
9072: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9073:
9074: IF l_debug_on THEN
9075: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

9157: END IF;
9158: --
9159: EXCEPTION
9160: WHEN others THEN
9161: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.UPDATE_LEG_SEQUENCE');
9162: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9163:
9164: IF l_debug_on THEN
9165: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

9420: END IF;
9421: IF (detailinfo_cv%ISOPEN) THEN
9422: CLOSE detailinfo_cv;
9423: END IF;
9424: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.GENERATE_LOADING_SEQ');
9425: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9426:
9427: --
9428: -- Debug Statements

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

9939: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:e_locked');
9940: END IF;
9941: WHEN OTHERS THEN
9942: x_return_status := fnd_api.g_ret_sts_unexp_error;
9943: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',l_module_name);
9944: --
9945: IF l_debug_on THEN
9946: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
9947: END IF;

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

10346: WHEN OTHERS THEN
10347:
10348: ROLLBACK TO update_ship_from_location_sp;
10349: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10350: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.update_ship_from_location', l_module_name);
10351: IF l_debug_on THEN
10352: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
10353: END IF;
10354: --

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

10433:
10434: EXCEPTION
10435:
10436: WHEN OTHERS THEN
10437: wsh_util_core.default_handler('wsh_new_delivery_actions.check_last_del_trip',l_module_name);
10438: --
10439: IF l_debug_on THEN
10440: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
10441: END IF;

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

10601: END IF;
10602:
10603: EXCEPTION
10604: WHEN OTHERS THEN
10605: wsh_util_core.default_handler('wsh_new_delivery_actions.get_trip_status',l_module_name);
10606: --
10607: IF l_debug_on THEN
10608: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
10609: END IF;

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

10675: IF c_get_console_delivery%ISOPEN THEN
10676: CLOSE c_get_console_delivery;
10677: END IF;
10678:
10679: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.IS_DLVY_CONTENT');
10680: --
10681: IF l_debug_on THEN
10682: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10683: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

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

10807: IF ( c_get_ship_to_site%ISOPEN) THEN
10808: CLOSE c_get_ship_to_site;
10809: END IF;
10810: --
10811: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.get_ship_to_site');
10812: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10813: --
10814:
10815: IF l_debug_on THEN

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

10944: IF (c_get_shipto_cust_from_dlvy%ISOPEN) THEN
10945: CLOSE c_get_shipto_cust_from_dlvy;
10946: END IF;
10947: --
10948: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.get_ship_to_customer');
10949: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10950: --
10951: IF l_debug_on THEN
10952: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

11220: EXCEPTION
11221:
11222: WHEN OTHERS THEN
11223:
11224: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.SET_PICK_UP_DROP_OFF_DATES',l_module_name);
11225: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
11226:
11227: IF get_transit_time%ISOPEN THEN
11228: CLOSE get_transit_time;

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

11243: -- --
11244: -- TYPE: PROCEDURE --
11245: -- --
11246: -- --
11247: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11248: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11249: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11250: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11251: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --

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

11244: -- TYPE: PROCEDURE --
11245: -- --
11246: -- --
11247: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11248: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11249: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11250: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11251: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11252: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --

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

11245: -- --
11246: -- --
11247: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11248: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11249: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11250: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11251: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11252: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11253: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --

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

11246: -- --
11247: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11248: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11249: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11250: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11251: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11252: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11253: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11254: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --

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

11247: -- PARAMETERS (IN): p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11248: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11249: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11250: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11251: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11252: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11253: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11254: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11255: -- --

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

11248: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11249: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11250: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11251: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11252: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11253: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11254: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11255: -- --
11256: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --

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

11249: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11250: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11251: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11252: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11253: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11254: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11255: -- --
11256: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --
11257: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type

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

11250: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11251: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11252: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11253: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11254: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11255: -- --
11256: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --
11257: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type
11258: --

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

11269: -- DATE VERSION BY BUG DESCRIPTION --
11270: -- ---------- ------- -------- ------- ---------------------------------- --
11271: -- 2002/12/09 I ABLUNDEL ------- Created --
11272: -- Attribute passed initially --
11273: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11274: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11275: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11276: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11277: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --

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

11270: -- ---------- ------- -------- ------- ---------------------------------- --
11271: -- 2002/12/09 I ABLUNDEL ------- Created --
11272: -- Attribute passed initially --
11273: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11274: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11275: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11276: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11277: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11278: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --

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

11271: -- 2002/12/09 I ABLUNDEL ------- Created --
11272: -- Attribute passed initially --
11273: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11274: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11275: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11276: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11277: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11278: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11279: -- --

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

11272: -- Attribute passed initially --
11273: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11274: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11275: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11276: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11277: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11278: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11279: -- --
11280: -- -------------------------------------------------------------------------- --

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

11273: -- p_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11274: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11275: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11276: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11277: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11278: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11279: -- --
11280: -- -------------------------------------------------------------------------- --
11281:

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

11274: -- p_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers, --
11275: -- p_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11276: -- p_mode_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11277: -- p_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11278: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30, --
11279: -- --
11280: -- -------------------------------------------------------------------------- --
11281:
11282: -- Result table will be of type Shipping

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

11688: --
11689: -- Debug Statements
11690: --
11691: IF l_debug_on THEN
11692: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_NEW_DELIVERY_ACTIONS.FORMAT_DEL_UPDATE_TABLE IS ' ||l_error_text);
11693: END IF;
11694: --
11695: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.FORMAT_DEL_UPDATE_TABLE');
11696: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);

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

11691: IF l_debug_on THEN
11692: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_NEW_DELIVERY_ACTIONS.FORMAT_DEL_UPDATE_TABLE IS ' ||l_error_text);
11693: END IF;
11694: --
11695: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.FORMAT_DEL_UPDATE_TABLE');
11696: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
11697: --
11698: -- Debug Statements
11699: --

Line 11830: l_trip_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;

11826: where wnd.delivery_id = p_del_id;
11827: */
11828:
11829:
11830: l_trip_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
11831: l_return_status VARCHAR2(1); -- returning error/success/warning
11832: l_return_message VARCHAR2(2000); -- hold a return error message
11833: l_BatchSize PLS_INTEGER := 500; -- max rows from a batch fetch
11834: l_current_rows PLS_INTEGER; -- number of current rows fetched

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

12934: WHEN OTHERS THEN
12935: l_error_code := SQLCODE;
12936: l_error_text := SQLERRM;
12937:
12938: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.PROCESS_CARRIER_SELECTION');
12939: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
12940: x_return_message := l_error_text;
12941:
12942:

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

13766: END IF;
13767: IF c_check_valid_child%ISOPEN THEN
13768: CLOSE c_check_valid_child;
13769: END IF;
13770: wsh_util_core.default_handler('wsh_new_delivery_actions.Assign_Del_to_Consol_Del',l_module_name);
13771: --
13772: IF l_debug_on THEN
13773: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
13774: END IF;

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

14237: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CHILD_DELIVERIES');
14238: END IF;
14239: --
14240: WHEN OTHERS THEN
14241: wsh_util_core.default_handler('wsh_new_delivery_actions.Unassign_Dels_from_Consol_Del',l_module_name);
14242: --
14243: IF c_check_parent_exists%ISOPEN THEN
14244: CLOSE c_check_parent_exists;
14245: END IF;

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

14528: --
14529: -- bug 4505105
14530: WHEN OTHERS THEN
14531: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
14532: wsh_util_core.default_handler('wsh_new_delivery_actions.Confirm_Consolidation_Delivery',l_module_name);
14533: --
14534: IF l_debug_on THEN
14535: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
14536: END IF;

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

14735: END IF;
14736: --
14737: WHEN OTHERS THEN
14738: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
14739: wsh_util_core.default_handler('wsh_new_delivery_actions.Confirm_Consolidation_Delivery',l_module_name);
14740: --
14741: IF l_debug_on THEN
14742: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
14743: END IF;

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

14818: RETURN l_return_value;
14819: EXCEPTION
14820:
14821: WHEN OTHERS THEN
14822: wsh_util_core.default_handler('wsh_new_delivery_actions.is_delivery_empty',l_module_name);
14823: --
14824: IF (c_delivery_detail_count%ISOPEN) THEN
14825: CLOSE c_delivery_detail_count;
14826: END IF;

Line 14839: END WSH_NEW_DELIVERY_ACTIONS;

14835: RETURN l_return_value;
14836: END IS_DELIVERY_EMPTY;
14837: --END OTM R12
14838:
14839: END WSH_NEW_DELIVERY_ACTIONS;