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_PUB dependencies on WSH_DELIVERY_DETAILS

Line 1: PACKAGE BODY WSH_DELIVERY_DETAILS_PUB as

1: PACKAGE BODY WSH_DELIVERY_DETAILS_PUB as
2: /* $Header: WSHDDPBB.pls 120.5.12020000.2 2013/05/17 05:42:54 skanduku ship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS_PUB';

1: PACKAGE BODY WSH_DELIVERY_DETAILS_PUB as
2: /* $Header: WSHDDPBB.pls 120.5.12020000.2 2013/05/17 05:42:54 skanduku ship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS_PUB';
6: p_message_type CONSTANT VARCHAR2(1) := 'E';
7:
8:
9: PROCEDURE Copy_Attributes(

Line 11: , x_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType);

7:
8:
9: PROCEDURE Copy_Attributes(
10: x_detail_info_tab OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type
11: , x_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType);
12:
13:
14: -- -----------------------------------------------------------------------
15: -- Procedure: detail_to_delivery

Line 239: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY');

235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
236: END IF;
237: WHEN others then
238: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
239: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY');
240: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_And_Get
242: (
243: p_count => x_msg_count,

Line 317: from wsh_delivery_details

313: cursor wdd_details IS
314: select organization_id,inventory_item_id,source_line_id,
315: lot_number,requested_quantity_uom,requested_quantity_uom2,
316: requested_quantity,requested_quantity2,released_status
317: from wsh_delivery_details
318: where delivery_detail_id = P_FROM_DETAIL_ID;
319:
320: --MUOM Bug 16806520 :End of changes
321:

Line 503: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Split_Line');

499: WHEN OTHERS THEN
500: ROLLBACK TO SPLIT_LINE_PUB;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: wsh_util_core.add_message(x_return_status, l_module_name);
503: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Split_Line');
504: FND_MSG_PUB.Count_And_Get
505: (
506: p_count => x_msg_count,
507: p_data => x_msg_data,

Line 523: -- This procedure takes in a record of WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType and

519: --===================
520:
521: -- Procedure Init_Changed_Attribute_Rec
522: -- Parameter p_init_rec record that needs to be initialized.
523: -- This procedure takes in a record of WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType and
524: -- initializes its attributes to the default FND_API_G values.
525:
526: Procedure Init_Changed_Attribute_Rec(p_init_rec IN OUT NOCOPY WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType,
527: x_return_status OUT NOCOPY VARCHAR2) IS

Line 526: Procedure Init_Changed_Attribute_Rec(p_init_rec IN OUT NOCOPY WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType,

522: -- Parameter p_init_rec record that needs to be initialized.
523: -- This procedure takes in a record of WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType and
524: -- initializes its attributes to the default FND_API_G values.
525:
526: Procedure Init_Changed_Attribute_Rec(p_init_rec IN OUT NOCOPY WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType,
527: x_return_status OUT NOCOPY VARCHAR2) IS
528: --
529: l_debug_on BOOLEAN;
530: --

Line 652: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Init_Changed_Attribute_Rec');

648: EXCEPTION
649: WHEN Others THEN
650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
651: WSH_UTIL_CORE.add_message (x_return_status);
652: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Init_Changed_Attribute_Rec');
653:
654:
655: --
656: -- Debug Statements

Line 698: , p_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType

694: , x_msg_count OUT NOCOPY NUMBER
695: , x_msg_data OUT NOCOPY VARCHAR2
696:
697: -- Procedure specific parameters
698: , p_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType
699: , p_source_code IN VARCHAR2
700: , p_container_flag IN VARCHAR2
701: )
702: IS

Line 814: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

810: l_index := l_detail_info_tab.NEXT(l_index);
811: END LOOP;
812: IF l_valid_index_tab.count >0 THEN
813: IF l_debug_on THEN
814: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
815: END IF;
816: wsh_delivery_details_pkg.Lock_Delivery_Details(
817: p_rec_attr_tab => l_detail_info_tab,
818: p_caller => l_In_rec.caller,

Line 816: wsh_delivery_details_pkg.Lock_Delivery_Details(

812: IF l_valid_index_tab.count >0 THEN
813: IF l_debug_on THEN
814: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
815: END IF;
816: wsh_delivery_details_pkg.Lock_Delivery_Details(
817: p_rec_attr_tab => l_detail_info_tab,
818: p_caller => l_In_rec.caller,
819: p_valid_index_tab => l_valid_index_tab,
820: x_valid_ids_tab => l_valid_ids_tab,

Line 863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

859: /* Patchset I: Harmonization Project. Call group API
860: All validations done by Group API */
861:
862: IF l_debug_on THEN
863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: wsh_interface_grp.create_update_delivery_detail(
866: p_api_version_number => p_api_version_number,
867: p_init_msg_list => FND_API.G_FALSE,

Line 968: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')

964: WHEN Others THEN
965: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
966: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
967: WSH_UTIL_CORE.add_message (x_return_status);
968: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
969: ;
970:
971: FND_MSG_PUB.Count_And_Get
972: (

Line 1017: , p_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType

1013: , x_msg_count OUT NOCOPY NUMBER
1014: , x_msg_data OUT NOCOPY VARCHAR2
1015:
1016: -- Procedure specific parameters
1017: , p_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType
1018: , p_source_code IN VARCHAR2
1019: , p_container_flag IN VARCHAR2
1020: , p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
1021: )

Line 1150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

1146: l_index := l_detail_info_tab.NEXT(l_index);
1147: END LOOP;
1148: IF l_valid_index_tab.count >0 THEN
1149: IF l_debug_on THEN
1150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1151: END IF;
1152: wsh_delivery_details_pkg.Lock_Delivery_Details(
1153: p_rec_attr_tab => l_detail_info_tab,
1154: p_caller => l_In_rec.caller,

Line 1152: wsh_delivery_details_pkg.Lock_Delivery_Details(

1148: IF l_valid_index_tab.count >0 THEN
1149: IF l_debug_on THEN
1150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1151: END IF;
1152: wsh_delivery_details_pkg.Lock_Delivery_Details(
1153: p_rec_attr_tab => l_detail_info_tab,
1154: p_caller => l_In_rec.caller,
1155: p_valid_index_tab => l_valid_index_tab,
1156: x_valid_ids_tab => l_valid_ids_tab,

Line 1199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

1195: /* Patchset I: Harmonization Project. Call group API
1196: All validations done by Group API */
1197:
1198: IF l_debug_on THEN
1199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1200: END IF;
1201:
1202: wsh_delivery_details_grp.create_update_delivery_detail(
1203: p_api_version_number => p_api_version_number,

Line 1202: wsh_delivery_details_grp.create_update_delivery_detail(

1198: IF l_debug_on THEN
1199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1200: END IF;
1201:
1202: wsh_delivery_details_grp.create_update_delivery_detail(
1203: p_api_version_number => p_api_version_number,
1204: p_init_msg_list => FND_API.G_FALSE,
1205: p_commit => FND_API.G_FALSE,
1206: x_return_status => l_return_status,

Line 1307: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')

1303: WHEN Others THEN
1304: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1305: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1306: WSH_UTIL_CORE.add_message (x_return_status);
1307: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
1308: ;
1309:
1310: FND_MSG_PUB.Count_And_Get
1311: (

Line 1589: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries');

1585: WHEN OTHERS THEN
1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1587: ROLLBACK TO AUTOCREATE_DEL_PUB;
1588: wsh_util_core.add_message(x_return_status, l_module_name);
1589: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries');
1590: FND_MSG_PUB.Count_And_Get
1591: (
1592: p_count => x_msg_count,
1593: p_data => x_msg_data,

Line 1643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip - multiple trips',WSH_DEBUG_SV.C_PROC_LEVEL);

1639: --
1640:
1641:
1642: IF l_debug_on THEN
1643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip - multiple trips',WSH_DEBUG_SV.C_PROC_LEVEL);
1644: END IF;
1645:
1646:
1647: WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip(

Line 1647: WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip(

1643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip - multiple trips',WSH_DEBUG_SV.C_PROC_LEVEL);
1644: END IF;
1645:
1646:
1647: WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip(
1648: -- Standard parameters
1649: p_api_version_number => p_api_version_number,
1650: p_init_msg_list => p_init_msg_list,
1651: p_commit => p_commit,

Line 1684: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');

1680:
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1682: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1683: wsh_util_core.add_message(x_return_status, l_module_name);
1684: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1685: FND_MSG_PUB.Count_And_Get
1686: (
1687: p_count => x_msg_count,
1688: p_data => x_msg_data,

Line 1881: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');

1877:
1878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1879: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1880: wsh_util_core.add_message(x_return_status, l_module_name);
1881: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1882: FND_MSG_PUB.Count_And_Get
1883: (
1884: p_count => x_msg_count,
1885: p_data => x_msg_data,

Line 1899: , x_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType)

1895:
1896:
1897: PROCEDURE Copy_Attributes(
1898: x_detail_info_tab OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type
1899: , x_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType)
1900:
1901: IS
1902:
1903: l_index NUMBER;

Line 2127: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.UPDATE_ATTRIBUTES');

2123:
2124:
2125: WHEN OTHERS THEN
2126:
2127: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.UPDATE_ATTRIBUTES');
2128: IF l_debug_on THEN
2129: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2130: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2131: END IF;

Line 2137: END WSH_DELIVERY_DETAILS_PUB;

2133:
2134: END Copy_Attributes;
2135:
2136:
2137: END WSH_DELIVERY_DETAILS_PUB;