APPS.WSH_PARTY_MERGE dependencies on WSH_PARTY_MERGE

Line 1: PACKAGE BODY WSH_PARTY_MERGE as

1: PACKAGE BODY WSH_PARTY_MERGE as
2: /* $Header: WSHPAMRB.pls 120.12 2007/11/21 06:02:56 ueshanka noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PARTY_MERGE';
4:
5: --

Line 3: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PARTY_MERGE';

1: PACKAGE BODY WSH_PARTY_MERGE as
2: /* $Header: WSHPAMRB.pls 120.12 2007/11/21 06:02:56 ueshanka noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PARTY_MERGE';
4:
5: --
6: -- R12 FP Bug 5075838
7: --

Line 869: wsh_util_core.default_handler('WSH_PARTY_MERGE.Update_Entities_during_merge');

865: --
866: WHEN OTHERS THEN
867: --
868: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
869: wsh_util_core.default_handler('WSH_PARTY_MERGE.Update_Entities_during_merge');
870: IF l_debug_on THEN
871: --
872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occurred.
873: occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1099: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || 'WSH_PARTY_MERGE' || '.' || 'Adjust_Parent_WV';

1095: Weight_Volume_Exp EXCEPTION;
1096:
1097: --
1098: l_debug_on BOOLEAN;
1099: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || 'WSH_PARTY_MERGE' || '.' || 'Adjust_Parent_WV';
1100: --
1101: --
1102: BEGIN
1103:

Line 1835: WSH_DEBUG_SV.log(l_module_name,'WSH_PARTY_MERGE.merge_location()+', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));

1831: IF l_debug_on THEN
1832: WSH_DEBUG_SV.push(l_module_name);
1833:
1834: -- Printing the parameters passed to API
1835: WSH_DEBUG_SV.log(l_module_name,'WSH_PARTY_MERGE.merge_location()+', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
1836: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
1837: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
1838: WSH_DEBUG_SV.log(l_module_name, 'p_to_id', p_to_id);
1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);

Line 1946: WSH_PARTY_MERGE.Check_Wms_Details (

1942: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Check_Wms_Details', WSH_DEBUG_SV.C_PROC_LEVEL);
1943: END IF;
1944: --
1945:
1946: WSH_PARTY_MERGE.Check_Wms_Details (
1947: p_party_site_id => l_to_party_site_id,
1948: p_location_id => l_from_location_id,
1949: x_return_status => l_return_status );
1950:

Line 1956: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_PARTY_MERGE.Check_Wms_Details : ' || l_return_status);

1952: THEN
1953: -- { Error Handling
1954: --
1955: IF l_debug_on THEN
1956: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_PARTY_MERGE.Check_Wms_Details : ' || l_return_status);
1957: END IF;
1958: --
1959: x_return_status := l_return_status;
1960: RAISE Merge_Location_Exp;

Line 2161: p_exception_name => 'WSH_PARTY_MERGE_CHANGE',

2157: p_exception_location_id => l_to_location_id,
2158: p_logged_at_location_id => l_to_location_id,
2159: p_logging_entity => 'SHIPPER',
2160: p_logging_entity_id => Fnd_Global.user_id,
2161: p_exception_name => 'WSH_PARTY_MERGE_CHANGE',
2162: p_message => l_message_name,
2163: p_severity => 'LOW',
2164: p_manually_logged => 'N',
2165: p_delivery_detail_id => l_parent_del_detail_id_tab(ExpCnt),

Line 2327: p_exception_name => 'WSH_PARTY_MERGE_CHANGE',

2323: p_exception_location_id => l_to_location_id,
2324: p_logged_at_location_id => l_to_location_id,
2325: p_logging_entity => 'SHIPPER',
2326: p_logging_entity_id => Fnd_Global.user_id,
2327: p_exception_name => 'WSH_PARTY_MERGE_CHANGE',
2328: p_message => l_message_name,
2329: p_severity => 'LOW',
2330: p_manually_logged => 'N',
2331: p_delivery_id => l_delivery_id_tab(ExpCnt),

Line 2607: p_exception_name => 'WSH_PARTY_MERGE_CHANGE',

2603: p_exception_location_id => l_to_location_id,
2604: p_logged_at_location_id => l_to_location_id,
2605: p_logging_entity => 'SHIPPER',
2606: p_logging_entity_id => Fnd_Global.user_id,
2607: p_exception_name => 'WSH_PARTY_MERGE_CHANGE',
2608: p_message => l_message_name,
2609: p_severity => 'LOW',
2610: p_manually_logged => 'N',
2611: p_trip_id => l_trip_id_tab(ExpCnt),

Line 2874: END WSH_PARTY_MERGE;

2870: --
2871: -- End R12 FP Bug 5075838
2872: --
2873:
2874: END WSH_PARTY_MERGE;