DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PUB dependencies on WSH_DELIVERY_DETAILS_PUB

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 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 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 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;