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_DETAILS_ACTIONS dependencies on WSH_DELIVERY_LEGS

Line 3611: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

3607: /* H integration: Pricing integration csun */
3608: IF l_del_tab.count > 0 THEN
3609: --
3610: IF l_debug_on THEN
3611: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3612: END IF;
3613: --
3614: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3615: p_entity_type => 'DELIVERY',

Line 3614: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

3610: IF l_debug_on THEN
3611: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3612: END IF;
3613: --
3614: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3615: p_entity_type => 'DELIVERY',
3616: p_entity_ids => l_del_tab,
3617: x_return_status => l_return_status);
3618: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 3991: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

3987: l_del_tab.delete;
3988: l_del_tab(1) := l_del_rec.delivery_id;
3989: --
3990: IF l_debug_on THEN
3991: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3992: END IF;
3993: --
3994: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3995: p_entity_type => 'DELIVERY',

Line 3994: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

3990: IF l_debug_on THEN
3991: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3992: END IF;
3993: --
3994: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3995: p_entity_type => 'DELIVERY',
3996: p_entity_ids => l_del_tab,
3997: x_return_status => l_return_status);
3998: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 5103: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

5099: l_del_tab(1) := p_delivery_id;
5100:
5101: --
5102: IF l_debug_on THEN
5103: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
5104: END IF;
5105: --
5106: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
5107: p_entity_type => 'DELIVERY',

Line 5106: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

5102: IF l_debug_on THEN
5103: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
5104: END IF;
5105: --
5106: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
5107: p_entity_type => 'DELIVERY',
5108: p_entity_ids => l_del_tab,
5109: x_return_status => l_return_status);
5110: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 6584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

6580: when plan a delivery
6581: */
6582: --
6583: IF l_debug_on THEN
6584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
6585: WSH_DEBUG_SV.log(l_module_name,'Count of l_del_tab',l_del_tab.count);
6586: END IF;
6587: --
6588: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

Line 6588: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

6584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
6585: WSH_DEBUG_SV.log(l_module_name,'Count of l_del_tab',l_del_tab.count);
6586: END IF;
6587: --
6588: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
6589: p_entity_type => 'DELIVERY',
6590: p_entity_ids => l_del_tab,
6591: x_return_status => l_return_status);
6592: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 7008: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

7004: l_del_tab(1) := l_assign.delivery_id;
7005:
7006: --
7007: IF l_debug_on THEN
7008: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
7009: END IF;
7010: --
7011: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
7012: p_entity_type => 'DELIVERY',

Line 7011: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

7007: IF l_debug_on THEN
7008: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
7009: END IF;
7010: --
7011: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
7012: p_entity_type => 'DELIVERY',
7013: p_entity_ids => l_del_tab,
7014: x_return_status => l_return_status);
7015: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 8724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

8720: END IF;
8721: IF l_del_tab.count > 0 THEN
8722: --
8723: IF l_debug_on THEN
8724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
8725: END IF;
8726: --
8727: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
8728: p_entity_type => 'DELIVERY',

Line 8727: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

8723: IF l_debug_on THEN
8724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
8725: END IF;
8726: --
8727: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
8728: p_entity_type => 'DELIVERY',
8729: p_entity_ids => l_del_tab,
8730: x_return_status => l_return_status);
8731: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 9120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

9116: l_entity_ids(1) := old_delivery_detail_rec.delivery_detail_id;
9117: --
9118: IF l_debug_on THEN
9119: WSH_DEBUG_SV.log(l_module_name,'entity id 1-',l_entity_ids(1));
9120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
9121: END IF;
9122: --
9123: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
9124: p_entity_type => 'DELIVERY_DETAIL',

Line 9123: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

9119: WSH_DEBUG_SV.log(l_module_name,'entity id 1-',l_entity_ids(1));
9120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
9121: END IF;
9122: --
9123: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
9124: p_entity_type => 'DELIVERY_DETAIL',
9125: p_entity_ids => l_entity_ids,
9126: x_return_status => l_return_status);
9127: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 10411: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

10407: */
10408: l_entity_ids(1) := old_delivery_detail_rec.delivery_detail_id;
10409: --
10410: IF l_debug_on THEN
10411: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
10412: END IF;
10413: --
10414: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
10415: p_entity_type => 'DELIVERY_DETAIL',

Line 10414: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

10410: IF l_debug_on THEN
10411: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
10412: END IF;
10413: --
10414: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
10415: p_entity_type => 'DELIVERY_DETAIL',
10416: p_entity_ids => l_entity_ids,
10417: x_return_status => l_return_status);
10418: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 13970: from wsh_delivery_legs l1, wsh_delivery_legs l2, wsh_delivery_assignments a

13966: x_return_status OUT NOCOPY VARCHAR2) IS
13967:
13968: cursor c_get_consolidation_delivery (p_det_id IN NUMBER) is
13969: select l1.delivery_id, l2.delivery_id
13970: from wsh_delivery_legs l1, wsh_delivery_legs l2, wsh_delivery_assignments a
13971: where a.delivery_detail_id = p_det_id
13972: and l1.delivery_id = a.delivery_id
13973: and l1.parent_delivery_leg_id = l2.delivery_leg_id
13974: and a.parent_delivery_detail_id is NULL