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_AUTOCREATE dependencies on WSH_UTIL_CORE

Line 65: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

61: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_BY_HEADER_FLAG',p_group_by_header_flag);
62: -- LSP PROJECT
63: END IF;
64: --
65: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
66: -- LSP PROJECT :
67: IF (p_organization_id IS NULL and p_client_id IS NULL) THEN
68: group_by_info := default_group_by_info;
69: --

Line 90: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

86: inv_cache.get_client_default_parameters (
87: p_client_id => p_client_id,
88: x_client_parameters_rec => l_client_params,
89: x_return_status => x_return_status);
90: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
91: --{
92: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
93: wsh_util_core.add_message(x_return_status);
94: --

Line 92: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

88: x_client_parameters_rec => l_client_params,
89: x_return_status => x_return_status);
90: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
91: --{
92: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
93: wsh_util_core.add_message(x_return_status);
94: --
95: -- Debug Statements
96: --

Line 93: wsh_util_core.add_message(x_return_status);

89: x_return_status => x_return_status);
90: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
91: --{
92: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
93: wsh_util_core.add_message(x_return_status);
94: --
95: -- Debug Statements
96: --
97: IF l_debug_on THEN

Line 153: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

149: x_param_info => l_shipping_params,
150: x_return_status => x_return_status);
151:
152:
153: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
154: FND_MESSAGE.SET_NAME('WSH','WSH_SHP_NOT_FOUND');
155: --
156: -- Debug Statements
157: --

Line 159: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

155: --
156: -- Debug Statements
157: --
158: IF l_debug_on THEN
159: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
160: END IF;
161: --
162: FND_MESSAGE.SET_TOKEN('ORG_NAME',wsh_util_core.get_org_name(p_organization_id));
163: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 162: FND_MESSAGE.SET_TOKEN('ORG_NAME',wsh_util_core.get_org_name(p_organization_id));

158: IF l_debug_on THEN
159: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
160: END IF;
161: --
162: FND_MESSAGE.SET_TOKEN('ORG_NAME',wsh_util_core.get_org_name(p_organization_id));
163: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
164: wsh_util_core.add_message(x_return_status);
165: --
166: -- Debug Statements

Line 163: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

159: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
160: END IF;
161: --
162: FND_MESSAGE.SET_TOKEN('ORG_NAME',wsh_util_core.get_org_name(p_organization_id));
163: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
164: wsh_util_core.add_message(x_return_status);
165: --
166: -- Debug Statements
167: --

Line 164: wsh_util_core.add_message(x_return_status);

160: END IF;
161: --
162: FND_MESSAGE.SET_TOKEN('ORG_NAME',wsh_util_core.get_org_name(p_organization_id));
163: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
164: wsh_util_core.add_message(x_return_status);
165: --
166: -- Debug Statements
167: --
168: IF l_debug_on THEN

Line 198: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

194: WSH_DEBUG_SV.logmsg(l_module_name, 'group_by_info.ship_method ' || group_by_info.ship_method );
195: WSH_DEBUG_SV.logmsg(l_module_name, 'group_by_info.carrier ' || group_by_info.carrier );
196: WSH_DEBUG_SV.logmsg(l_module_name, 'group_by_info.header ' || group_by_info.header );
197: END IF;
198: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
199: --
200: -- Debug Statements
201: --
202: IF l_debug_on THEN

Line 217: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR');

213: IF l_debug_on THEN
214: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM GET_GROUP_BY_ATTR IS ' || L_ERROR_TEXT );
215: END IF;
216: --
217: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR');
218: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
219:
220: --
221: -- Debug Statements

Line 218: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

214: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM GET_GROUP_BY_ATTR IS ' || L_ERROR_TEXT );
215: END IF;
216: --
217: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR');
218: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
219:
220: --
221: -- Debug Statements
222: --

Line 638: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

634:
635:
636: END LOOP;
637:
638: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
639:
640: IF l_debug_on THEN
641: WSH_DEBUG_SV.pop(l_module_name);
642: END IF;

Line 647: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Hash');

643:
644: EXCEPTION
645:
646: WHEN Others THEN
647: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Hash');
648: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
649: --
650: -- Debug Statements
651: --

Line 648: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

644: EXCEPTION
645:
646: WHEN Others THEN
647: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Hash');
648: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
649: --
650: -- Debug Statements
651: --
652: IF l_debug_on THEN

Line 686: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

682: --
683: IF l_debug_on THEN
684: WSH_DEBUG_SV.push(l_module_name);
685: END IF;
686: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
687:
688: l_grp_attr_tab(1).ship_to_location_id := p_delivery_rec.ultimate_dropoff_location_id;
689: l_grp_attr_tab(1).ship_from_location_id := p_delivery_rec.initial_pickup_location_id;
690: l_grp_attr_tab(1).customer_id := p_delivery_rec.customer_id;

Line 716: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

712: p_action_code => NULL,
713: x_return_status => x_return_status);
714:
715:
716: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
717:
718: RAISE FAIL_CREATE_HASH;
719:
720: END IF;

Line 734: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

730:
731: EXCEPTION
732:
733: WHEN FAIL_CREATE_HASH THEN
734: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
735: FND_MESSAGE.SET_NAME('WSH','WSH_FAIL_CREATE_HASH');
736: WSH_UTIL_CORE.Add_Message(x_return_status);
737: --
738: -- Debug Statements

Line 736: WSH_UTIL_CORE.Add_Message(x_return_status);

732:
733: WHEN FAIL_CREATE_HASH THEN
734: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
735: FND_MESSAGE.SET_NAME('WSH','WSH_FAIL_CREATE_HASH');
736: WSH_UTIL_CORE.Add_Message(x_return_status);
737: --
738: -- Debug Statements
739: --
740: IF l_debug_on THEN

Line 747: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Update_Hash');

743: END IF;
744: --
745:
746: WHEN Others THEN
747: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Update_Hash');
748: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
749: --
750: -- Debug Statements
751: --

Line 748: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

744: --
745:
746: WHEN Others THEN
747: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Update_Hash');
748: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
749: --
750: -- Debug Statements
751: --
752: IF l_debug_on THEN

Line 802: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

798: IF l_debug_on THEN
799: WSH_DEBUG_SV.push(l_module_name);
800: END IF;
801: --
802: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
803:
804: i := p_attr_tab.FIRST;
805: WHILE i is NOT NULL LOOP
806:

Line 1025: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1021:
1022:
1023: EXCEPTION
1024: WHEN MULTIPLE_GROUPS THEN
1025: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1026: FND_MESSAGE.SET_NAME('WSH','WSH_MULTIPLE_GROUPS');
1027: WSH_UTIL_CORE.Add_Message(x_return_status);
1028: --
1029: -- Debug Statements

Line 1027: WSH_UTIL_CORE.Add_Message(x_return_status);

1023: EXCEPTION
1024: WHEN MULTIPLE_GROUPS THEN
1025: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1026: FND_MESSAGE.SET_NAME('WSH','WSH_MULTIPLE_GROUPS');
1027: WSH_UTIL_CORE.Add_Message(x_return_status);
1028: --
1029: -- Debug Statements
1030: --
1031: IF l_debug_on THEN

Line 1038: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Groups');

1034: END IF;
1035: --
1036:
1037: WHEN Others THEN
1038: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Groups');
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1040: --
1041: -- Debug Statements
1042: --

Line 1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1035: --
1036:
1037: WHEN Others THEN
1038: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Create_Groups');
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1040: --
1041: -- Debug Statements
1042: --
1043: IF l_debug_on THEN

Line 1084: x_matched_entities OUT NOCOPY wsh_util_core.id_tab_type,

1080: procedure Find_Matching_Groups(p_attr_tab IN OUT NOCOPY grp_attr_tab_type,
1081: p_action_rec IN action_rec_type,
1082: p_target_rec IN grp_attr_rec_type,
1083: p_group_tab IN OUT NOCOPY grp_attr_tab_type,
1084: x_matched_entities OUT NOCOPY wsh_util_core.id_tab_type,
1085: x_out_rec OUT NOCOPY out_rec_type,
1086: x_return_status OUT NOCOPY varchar2) IS
1087:
1088: --Bug 5241742 Added organization_id in where clause for indexing

Line 1284: l_matched_entities wsh_util_core.id_tab_type;

1280: l_mode_of_transport VARCHAR2(30);
1281: l_ship_method_code VARCHAR2(30); --bug 6074966
1282: l_hash_value NUMBER;
1283: l_hash_string varchar2(1000);
1284: l_matched_entities wsh_util_core.id_tab_type;
1285: l_tmp_attr_tab grp_attr_tab_type;
1286: l_check_one_group varchar2(1);
1287: l_query_string varchar2(4000);
1288:

Line 1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1324: RAISE INVALID_ACTION;
1325:
1326: END IF;
1327:
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1329: -- Mahech : consider the changed action 'MATCH_GROUPS_AT_PICK'
1330: IF p_action_rec.action IN ('MATCH_GROUPS','MATCH_GROUPS_AT_PICK') AND p_target_rec.entity_id is NOT NULL THEN
1331:
1332: p_attr_tab(p_attr_tab.FIRST - 1).entity_id := p_target_rec.entity_id;

Line 1373: IF x_return_status <> wsh_util_core.g_ret_sts_success THEN

1369: p_container_instance_id => p_attr_tab(p_attr_tab.FIRST).entity_id,
1370: x_empty_flag => l_empty_container,
1371: x_return_status => x_return_status);
1372:
1373: IF x_return_status <> wsh_util_core.g_ret_sts_success THEN
1374: RAISE fnd_api.g_exc_error;
1375: END IF;
1376:
1377: IF l_debug_on THEN

Line 1397: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1393: p_group_by_header => p_action_rec.group_by_header_flag,
1394: p_action_code => p_action_rec.action,
1395: x_return_status => x_return_status);
1396:
1397: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1398:
1399: RAISE FAIL_CREATE_HASH;
1400:
1401: END IF;

Line 1422: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1418: p_check_one_group => l_check_one_group,
1419: p_action_code => p_action_rec.action,
1420: x_return_status => x_return_status);
1421:
1422: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1423:
1424: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1425:
1426: IF p_action_rec.check_single_grp = 'Y' THEN

Line 1424: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1420: x_return_status => x_return_status);
1421:
1422: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1423:
1424: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1425:
1426: IF p_action_rec.check_single_grp = 'Y' THEN
1427:
1428: -- We need to check only if the records can be grouped together.

Line 1606: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1602:
1603: FORALL i IN 1..l_matched_entities.count
1604: INSERT INTO wsh_tmp (id) VALUES(l_matched_entities(i));
1605:
1606: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1607:
1608: IF l_debug_on THEN
1609: WSH_DEBUG_SV.pop(l_module_name);
1610: END IF;

Line 1620: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1616:
1617: x_matched_entities := l_matched_entities;
1618:
1619:
1620: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1621:
1622: IF l_debug_on THEN
1623: WSH_DEBUG_SV.pop(l_module_name);
1624: END IF;

Line 1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1675: x_out_rec.bind_mode_of_transport := l_mode_of_transport;
1676: x_out_rec.bind_ship_method_code := l_ship_method_code;
1677: x_out_rec.bind_client_id := l_client_id; -- LSP PROJECT
1678:
1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1680:
1681: IF l_debug_on THEN
1682: WSH_DEBUG_SV.pop(l_module_name);
1683: END IF;

Line 1706: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1702: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1703: END IF;
1704: --
1705: WHEN DELIVERY_NOT_MATCH THEN
1706: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1707: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_NOT_MATCH');
1708: WSH_UTIL_CORE.Add_Message(x_return_status);
1709: --
1710: -- Debug Statements

Line 1708: WSH_UTIL_CORE.Add_Message(x_return_status);

1704: --
1705: WHEN DELIVERY_NOT_MATCH THEN
1706: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1707: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_NOT_MATCH');
1708: WSH_UTIL_CORE.Add_Message(x_return_status);
1709: --
1710: -- Debug Statements
1711: --
1712: IF l_debug_on THEN

Line 1718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1714: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIVERY_NOT_MATCH');
1715: END IF;
1716: --
1717: WHEN FAIL_CREATE_GROUP THEN
1718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1719: FND_MESSAGE.SET_NAME('WSH','WSH_FAIL_CREATE_GROUP');
1720: WSH_UTIL_CORE.Add_Message(x_return_status);
1721: --
1722: -- Debug Statements

Line 1720: WSH_UTIL_CORE.Add_Message(x_return_status);

1716: --
1717: WHEN FAIL_CREATE_GROUP THEN
1718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1719: FND_MESSAGE.SET_NAME('WSH','WSH_FAIL_CREATE_GROUP');
1720: WSH_UTIL_CORE.Add_Message(x_return_status);
1721: --
1722: -- Debug Statements
1723: --
1724: IF l_debug_on THEN

Line 1730: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FAIL_CREATE_GROUP');
1727: END IF;
1728: --
1729: WHEN FAIL_CREATE_HASH THEN
1730: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1731: FND_MESSAGE.SET_NAME('WSH','WSH_FAIL_CREATE_HASH');
1732: WSH_UTIL_CORE.Add_Message(x_return_status);
1733: --
1734: -- Debug Statements

Line 1732: WSH_UTIL_CORE.Add_Message(x_return_status);

1728: --
1729: WHEN FAIL_CREATE_HASH THEN
1730: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1731: FND_MESSAGE.SET_NAME('WSH','WSH_FAIL_CREATE_HASH');
1732: WSH_UTIL_CORE.Add_Message(x_return_status);
1733: --
1734: -- Debug Statements
1735: --
1736: IF l_debug_on THEN

Line 1744: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups');

1740: END IF;
1741: --
1742:
1743: WHEN Others THEN
1744: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups');
1745: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1746:
1747: IF c_matching_deliveries%ISOPEN THEN
1748: CLOSE c_matching_deliveries;

Line 1745: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1741: --
1742:
1743: WHEN Others THEN
1744: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups');
1745: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1746:
1747: IF c_matching_deliveries%ISOPEN THEN
1748: CLOSE c_matching_deliveries;
1749: END IF;

Line 1901: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1897: IF l_debug_on IS NULL THEN
1898: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1899: END IF;
1900:
1901: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1902:
1903: IF l_debug_on THEN
1904: WSH_DEBUG_SV.push(l_module_name);
1905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1908: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1904: WSH_DEBUG_SV.push(l_module_name);
1905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1906: END IF;
1907: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);
1908: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1911: END IF;
1912: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 1912: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1908: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1911: END IF;
1912: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');
1915: END IF;
1916: RAISE OTHERS;

Line 1939: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1935: (p_table_name => 'WSH_NEW_DELIVERIES',
1936: p_primary_id => x_delivery_id,
1937: x_return_status => x_return_status);
1938:
1939: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1940: IF l_debug_on THEN
1941: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_FLEXFIELD_UTILS.WRITE_DFF_ATTRIBUTES RETURNED ERROR' );
1942: WSH_DEBUG_SV.pop(l_module_name);
1943: END IF;

Line 1952: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1948: IF l_debug_on THEN
1949: WSH_DEBUG_SV.log(l_module_name,'Autonomous Return status ', x_return_status);
1950: END IF;
1951:
1952: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1953: COMMIT;
1954: ELSE
1955: ROLLBACK;
1956: END IF;

Line 1964: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTONOMOUS_CREATE_DELIVERY');

1960: END IF;
1961:
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTONOMOUS_CREATE_DELIVERY');
1965: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1966: IF l_debug_on THEN
1967: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1968: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1965: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1961:
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTONOMOUS_CREATE_DELIVERY');
1965: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1966: IF l_debug_on THEN
1967: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1968: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1969: END IF;

Line 1996: p_line_rows IN wsh_util_core.id_tab_type,

1992: -- x_return_status - Status of execution
1993: --------------------------------------------------------------------------
1994:
1995: PROCEDURE autocreate_deliveries(
1996: p_line_rows IN wsh_util_core.id_tab_type,
1997: p_init_flag IN VARCHAR2,
1998: p_pick_release_flag IN VARCHAR2,
1999: p_container_flag IN VARCHAR2 := 'N',
2000: p_check_flag IN VARCHAR2 := 'N',

Line 2004: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,

2000: p_check_flag IN VARCHAR2 := 'N',
2001: p_caller IN VARCHAR2 DEFAULT NULL,
2002: p_generate_carton_group_id IN VARCHAR2 := 'N',
2003: p_max_detail_commit IN NUMBER := 1000,
2004: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,
2005: x_grouping_rows OUT NOCOPY wsh_util_core.id_tab_type,
2006: x_return_status OUT NOCOPY VARCHAR2 ) IS
2007:
2008:

Line 2005: x_grouping_rows OUT NOCOPY wsh_util_core.id_tab_type,

2001: p_caller IN VARCHAR2 DEFAULT NULL,
2002: p_generate_carton_group_id IN VARCHAR2 := 'N',
2003: p_max_detail_commit IN NUMBER := 1000,
2004: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,
2005: x_grouping_rows OUT NOCOPY wsh_util_core.id_tab_type,
2006: x_return_status OUT NOCOPY VARCHAR2 ) IS
2007:
2008:
2009: /* Bug 3206620 : cursor to get the container flag of the delivery detail*/

Line 2069: l_matched_entities wsh_util_core.id_tab_type;

2065:
2066: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2067: l_action_rec wsh_delivery_autocreate.action_rec_type;
2068: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2069: l_matched_entities wsh_util_core.id_tab_type;
2070: l_out_rec wsh_delivery_autocreate.out_rec_type;
2071: l_del_select_carrier wsh_util_core.id_tab_type;
2072: l_del_rate wsh_util_core.id_tab_type;
2073: l_del_rate_location wsh_util_core.id_tab_type;

Line 2071: l_del_select_carrier wsh_util_core.id_tab_type;

2067: l_action_rec wsh_delivery_autocreate.action_rec_type;
2068: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2069: l_matched_entities wsh_util_core.id_tab_type;
2070: l_out_rec wsh_delivery_autocreate.out_rec_type;
2071: l_del_select_carrier wsh_util_core.id_tab_type;
2072: l_del_rate wsh_util_core.id_tab_type;
2073: l_del_rate_location wsh_util_core.id_tab_type;
2074:
2075: l_delivery_tab wsh_util_core.id_tab_type;

Line 2072: l_del_rate wsh_util_core.id_tab_type;

2068: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2069: l_matched_entities wsh_util_core.id_tab_type;
2070: l_out_rec wsh_delivery_autocreate.out_rec_type;
2071: l_del_select_carrier wsh_util_core.id_tab_type;
2072: l_del_rate wsh_util_core.id_tab_type;
2073: l_del_rate_location wsh_util_core.id_tab_type;
2074:
2075: l_delivery_tab wsh_util_core.id_tab_type;
2076: l_delivery_rows wsh_util_core.id_tab_type;

Line 2073: l_del_rate_location wsh_util_core.id_tab_type;

2069: l_matched_entities wsh_util_core.id_tab_type;
2070: l_out_rec wsh_delivery_autocreate.out_rec_type;
2071: l_del_select_carrier wsh_util_core.id_tab_type;
2072: l_del_rate wsh_util_core.id_tab_type;
2073: l_del_rate_location wsh_util_core.id_tab_type;
2074:
2075: l_delivery_tab wsh_util_core.id_tab_type;
2076: l_delivery_rows wsh_util_core.id_tab_type;
2077: j NUMBER;

Line 2075: l_delivery_tab wsh_util_core.id_tab_type;

2071: l_del_select_carrier wsh_util_core.id_tab_type;
2072: l_del_rate wsh_util_core.id_tab_type;
2073: l_del_rate_location wsh_util_core.id_tab_type;
2074:
2075: l_delivery_tab wsh_util_core.id_tab_type;
2076: l_delivery_rows wsh_util_core.id_tab_type;
2077: j NUMBER;
2078:
2079: l_exception_id NUMBER;

Line 2076: l_delivery_rows wsh_util_core.id_tab_type;

2072: l_del_rate wsh_util_core.id_tab_type;
2073: l_del_rate_location wsh_util_core.id_tab_type;
2074:
2075: l_delivery_tab wsh_util_core.id_tab_type;
2076: l_delivery_rows wsh_util_core.id_tab_type;
2077: j NUMBER;
2078:
2079: l_exception_id NUMBER;
2080: l_exception_message VARCHAR2(2000);

Line 2140: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2136: WSH_DEBUG_SV.log(l_module_name,'P_MAX_DETAIL_COMMIT',P_MAX_DETAIL_COMMIT);
2137: WSH_DEBUG_SV.log(l_module_name,'P_CALLER', P_CALLER);
2138: END IF;
2139: --
2140: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2141:
2142:
2143: IF (p_line_rows.count = 0) THEN
2144: IF l_debug_on THEN

Line 2180: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2176: x_matched_entities => l_matched_entities,
2177: x_out_rec => l_out_rec,
2178: x_return_status => x_return_status);
2179:
2180: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2181: raise e_return_excp;
2182: END IF;
2183:
2184: IF l_debug_on THEN

Line 2221: IF (l_return_status IN(WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

2217: WSH_CONTAINER_UTILITIES.Is_Empty (p_container_instance_id => l_attr_tab(i).entity_id,
2218: x_empty_flag => l_detail_is_empty_cont,
2219: x_return_status => l_return_status);
2220:
2221: IF (l_return_status IN(WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2222: x_return_status := l_return_status;
2223: wsh_util_core.add_message(x_return_status);
2224: IF l_debug_on THEN
2225: WSH_DEBUG_SV.logmsg(l_module_name,'Error returned from WSH_CONTAINER_UTILITIES.Is_Empty');

Line 2223: wsh_util_core.add_message(x_return_status);

2219: x_return_status => l_return_status);
2220:
2221: IF (l_return_status IN(WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2222: x_return_status := l_return_status;
2223: wsh_util_core.add_message(x_return_status);
2224: IF l_debug_on THEN
2225: WSH_DEBUG_SV.logmsg(l_module_name,'Error returned from WSH_CONTAINER_UTILITIES.Is_Empty');
2226: END IF;
2227: raise e_return_excp; -- LPN CONV. rv

Line 2236: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2232: END IF;
2233:
2234: IF l_detail_is_empty_cont = 'Y' then
2235: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EMPTY');
2236: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2237: wsh_util_core.add_message(x_return_status);
2238: IF l_debug_on THEN
2239: WSH_DEBUG_SV.logmsg(l_module_name, 'container empty,autocreate delivery not allowed');
2240: WSH_DEBUG_SV.pop(l_module_name);

Line 2237: wsh_util_core.add_message(x_return_status);

2233:
2234: IF l_detail_is_empty_cont = 'Y' then
2235: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EMPTY');
2236: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2237: wsh_util_core.add_message(x_return_status);
2238: IF l_debug_on THEN
2239: WSH_DEBUG_SV.logmsg(l_module_name, 'container empty,autocreate delivery not allowed');
2240: WSH_DEBUG_SV.pop(l_module_name);
2241: END IF;

Line 2246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2242: raise e_return_excp; -- LPN CONV. rv
2243: ELSE
2244: FND_MESSAGE.SET_NAME('WSH','WSH_ULT_DROPOFF_LOC_ID_NOT_FND');
2245: FND_MESSAGE.SET_TOKEN('LINE_LPN_ID',l_line_lpn_id);
2246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2247: wsh_util_core.add_message(x_return_status);
2248: IF l_debug_on THEN
2249: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIPTO LOCATION NOT FOUND FOR '||P_LINE_ROWS ( I ) );
2250: END IF;

Line 2247: wsh_util_core.add_message(x_return_status);

2243: ELSE
2244: FND_MESSAGE.SET_NAME('WSH','WSH_ULT_DROPOFF_LOC_ID_NOT_FND');
2245: FND_MESSAGE.SET_TOKEN('LINE_LPN_ID',l_line_lpn_id);
2246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2247: wsh_util_core.add_message(x_return_status);
2248: IF l_debug_on THEN
2249: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIPTO LOCATION NOT FOUND FOR '||P_LINE_ROWS ( I ) );
2250: END IF;
2251: raise e_return_excp; -- LPN CONV. rv

Line 2256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2252: END IF;
2253: ELSE
2254: FND_MESSAGE.SET_NAME('WSH','WSH_ULT_DROPOFF_LOC_ID_NOT_FND');
2255: FND_MESSAGE.SET_TOKEN('LINE_LPN_ID',l_line_lpn_id);
2256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2257: wsh_util_core.add_message(x_return_status);
2258: IF l_debug_on THEN
2259: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIPTO LOCATION NOT FOUND FOR '||P_LINE_ROWS ( I ) );
2260: END IF;

Line 2257: wsh_util_core.add_message(x_return_status);

2253: ELSE
2254: FND_MESSAGE.SET_NAME('WSH','WSH_ULT_DROPOFF_LOC_ID_NOT_FND');
2255: FND_MESSAGE.SET_TOKEN('LINE_LPN_ID',l_line_lpn_id);
2256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2257: wsh_util_core.add_message(x_return_status);
2258: IF l_debug_on THEN
2259: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIPTO LOCATION NOT FOUND FOR '||P_LINE_ROWS ( I ) );
2260: END IF;
2261: raise e_return_excp; -- LPN CONV. rv

Line 2277: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);

2273: --
2274: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_ASSIGNED_DEL');
2275: FND_MESSAGE.SET_TOKEN('DET_NAME', l_attr_tab(i).entity_id);
2276: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.get_name(l_attr_tab(i).DELIVERY_ID));
2277: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
2278:
2279: l_assigned_flag := 'Y';
2280:
2281: ELSE --{ not assigned

Line 2355: WSH_UTIL_CORE.api_post_call(

2351: IF l_debug_on THEN
2352: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WV_UTILS.GET_DEFAULT_UOMS',x_return_status);
2353: END IF;
2354: --
2355: WSH_UTIL_CORE.api_post_call(
2356: p_return_status => x_return_status,
2357: x_num_warnings => l_num_warnings,
2358: x_num_errors => l_num_errors);
2359:

Line 2411: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2407: END IF;
2408: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2409: l_lock_handle := NULL;
2410:
2411: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2412: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2413: raise others;
2414: ELSE
2415: IF l_debug_on THEN

Line 2412: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2408: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2409: l_lock_handle := NULL;
2410:
2411: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2412: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2413: raise others;
2414: ELSE
2415: IF l_debug_on THEN
2416: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_AUTOCREATE.Autonomous_Create_Delivery RETURNED ERROR');

Line 2441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2437: -- Any other problems in acquiring the lock,
2438: -- raise error and return
2439: -- This can happen only if there's a timeout issue
2440: -- or unexpected error
2441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2442: IF l_debug_on THEN
2443: WSH_DEBUG_SV.logmsg(l_module_name, 'Error when trying to acquire User Lock, Lock Status :'||l_lock_status );
2444: END IF;
2445: raise e_return_excp;

Line 2454: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

2450: IF l_debug_on THEN
2451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2452: END IF;
2453: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);
2454: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2455: IF l_debug_on THEN
2456: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2457: END IF;
2458: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 2458: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2454: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2455: IF l_debug_on THEN
2456: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2457: END IF;
2458: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2459: IF l_debug_on THEN
2460: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');
2461: END IF;
2462: raise others;

Line 2485: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

2481: (p_table_name => 'WSH_NEW_DELIVERIES',
2482: p_primary_id => l_delivery_id,
2483: x_return_status => x_return_status);
2484:
2485: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2486: IF l_debug_on THEN
2487: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_FLEXFIELD_UTILS.WRITE_DFF_ATTRIBUTES RETURNED ERROR' );
2488: END IF;
2489: raise e_return_excp;

Line 2514: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2510: -- Only modification is to add message. Since there was no code
2511: -- to exit or return after
2512: -- call to the above procedure, leaving that behavior the same.
2513:
2514: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2515: FND_MESSAGE.SET_NAME('WSH', 'WSH_PARAM_NOT_DEFINED');
2516: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
2517: wsh_util_core.get_org_name(l_delivery_info.organization_id));
2518: wsh_util_core.add_message(l_return_status,l_module_name);

Line 2517: wsh_util_core.get_org_name(l_delivery_info.organization_id));

2513:
2514: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2515: FND_MESSAGE.SET_NAME('WSH', 'WSH_PARAM_NOT_DEFINED');
2516: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
2517: wsh_util_core.get_org_name(l_delivery_info.organization_id));
2518: wsh_util_core.add_message(l_return_status,l_module_name);
2519: END IF;
2520:
2521: --

Line 2518: wsh_util_core.add_message(l_return_status,l_module_name);

2514: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2515: FND_MESSAGE.SET_NAME('WSH', 'WSH_PARAM_NOT_DEFINED');
2516: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
2517: wsh_util_core.get_org_name(l_delivery_info.organization_id));
2518: wsh_util_core.add_message(l_return_status,l_module_name);
2519: END IF;
2520:
2521: --
2522: -- ITM Check is required only for outbound lines

Line 2544: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

2540: IF l_debug_on THEN
2541: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);
2542: END IF;
2543:
2544: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2545: x_return_status := l_return_status;
2546: raise e_return_excp; -- LPN CONV. rv
2547: END IF;
2548:

Line 2562: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

2558: IF l_debug_on THEN
2559: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',l_return_status);
2560: END IF;
2561:
2562: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2563: x_return_status := l_return_status;
2564: raise e_return_excp; -- LPN CONV. rv
2565: END IF;
2566: END IF;

Line 2616: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

2612: x_return_status => x_return_status,
2613: p_caller => 'AUTOCREATE'); --bug 5100229
2614:
2615:
2616: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2617: IF l_debug_on THEN
2618: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY FOR '||P_LINE_ROWS ( I ) || ' TO '||L_DELIVERY_ID );
2619: END IF;
2620: --

Line 2621: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2617: IF l_debug_on THEN
2618: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY FOR '||P_LINE_ROWS ( I ) || ' TO '||L_DELIVERY_ID );
2619: END IF;
2620: --
2621: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2622: IF l_debug_on THEN
2623: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY RETURNED UNEXPECTED ERROR' );
2624: END IF;
2625: --

Line 2644: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

2640: END LOOP;
2641:
2642:
2643: IF (l_assigned_flag = 'Y') THEN
2644: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2645: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2646: ELSE
2647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2648: END IF;

Line 2645: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2641:
2642:
2643: IF (l_assigned_flag = 'Y') THEN
2644: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2645: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2646: ELSE
2647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2648: END IF;
2649: END IF;

Line 2647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2643: IF (l_assigned_flag = 'Y') THEN
2644: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2645: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2646: ELSE
2647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2648: END IF;
2649: END IF;
2650:
2651: IF (l_group_info.count = 0) THEN

Line 2664: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2660: wsh_tp_release.calculate_cont_del_tpdates(
2661: p_entity => 'DLVY',
2662: p_entity_ids => l_delivery_rows,
2663: x_return_status => l_return_status);
2664: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2665: raise others;
2666: ELSIF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR , WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2667: l_warn_num := l_warn_num + 1;
2668: END IF;

Line 2666: ELSIF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR , WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

2662: p_entity_ids => l_delivery_rows,
2663: x_return_status => l_return_status);
2664: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2665: raise others;
2666: ELSIF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR , WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2667: l_warn_num := l_warn_num + 1;
2668: END IF;
2669: -- Bug 4658241 end
2670:

Line 2688: l_check_fte_inst := WSH_UTIL_CORE.FTE_Is_Installed;

2684: -- [BUG: 2301717] added check to IF statement below to ensure that
2685: -- a table of deliveries is populated with at least one delivery so
2686: -- that processing can be done correctly
2687: --
2688: l_check_fte_inst := WSH_UTIL_CORE.FTE_Is_Installed;
2689: IF (l_check_fte_inst = 'Y') THEN
2690:
2691: IF ((WSH_PICK_LIST.G_BATCH_ID is null) AND
2692: (l_delivery_rows.COUNT > 0) AND l_del_select_carrier.count > 0 ) THEN

Line 2714: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2710: p_caller => l_caller,
2711: x_return_message => l_error_text,
2712: x_return_status => l_return_status);
2713:
2714: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2715: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2716: raise others;
2717: ELSE
2718: IF l_debug_on THEN

Line 2715: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2711: x_return_message => l_error_text,
2712: x_return_status => l_return_status);
2713:
2714: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2715: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2716: raise others;
2717: ELSE
2718: IF l_debug_on THEN
2719: WSH_DEBUG_SV.log(l_module_name, 'Return status from WSH_NEW_DELIVERY_ACTIONS.Process_Carrier_Selection', l_return_status );

Line 2757: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2753: IF l_debug_on THEN
2754: wsh_debug_sv.log(l_module_name,'Return Status from WSH_FTE_INTEGRATION.Rate_Delivery' ,l_return_status);
2755: END IF;
2756:
2757: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2758: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2759: raise others;
2760: ELSE
2761: i := l_out_param_rec.failed_delivery_id_list.FIRST;

Line 2758: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2754: wsh_debug_sv.log(l_module_name,'Return Status from WSH_FTE_INTEGRATION.Rate_Delivery' ,l_return_status);
2755: END IF;
2756:
2757: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2758: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2759: raise others;
2760: ELSE
2761: i := l_out_param_rec.failed_delivery_id_list.FIRST;
2762: WHILE i is not NULL LOOP

Line 2766: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);

2762: WHILE i is not NULL LOOP
2763:
2764: FND_MESSAGE.SET_NAME('WSH', 'WSH_RATE_CREATE_DEL');
2765: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' , to_char(l_out_param_rec.failed_delivery_id_list(i)));
2766: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
2767:
2768: FND_MESSAGE.SET_NAME('WSH', 'WSH_RATE_CREATE_DEL');
2769: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' , to_char(l_out_param_rec.failed_delivery_id_list(i)));
2770: l_exception_message := FND_MESSAGE.Get;

Line 2814: WSH_UTIL_CORE.API_POST_CALL

2810: IF l_debug_on THEN
2811: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
2812: END IF;
2813: --
2814: WSH_UTIL_CORE.API_POST_CALL
2815: (
2816: p_return_status => l_return_status,
2817: x_num_warnings => l_warn_num,
2818: x_num_errors => l_error_num,

Line 2828: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2824: --
2825:
2826: x_del_rows := l_delivery_rows;
2827: IF l_error_num > 0 THEN -- LPN CONV. rv
2828: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2829: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
2830: AND l_warn_num > 0 THEN
2831: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2832: END IF;

Line 2829: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS

2825:
2826: x_del_rows := l_delivery_rows;
2827: IF l_error_num > 0 THEN -- LPN CONV. rv
2828: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2829: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
2830: AND l_warn_num > 0 THEN
2831: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2832: END IF;
2833:

Line 2831: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

2827: IF l_error_num > 0 THEN -- LPN CONV. rv
2828: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2829: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
2830: AND l_warn_num > 0 THEN
2831: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2832: END IF;
2833:
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.log(l_module_name, 'Return status from WSH_DELIVERY_AUTOCREATE.autocreate_deliveries', x_return_status);

Line 2846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2842: -- LPN CONV. rv
2843: WHEN e_return_excp THEN
2844: --
2845: FND_MESSAGE.SET_NAME('WSH','WSH_AUTOCREATE_DEL_ERROR');
2846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2847: wsh_util_core.add_message(x_return_status);
2848: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2849: --{
2850: --

Line 2847: wsh_util_core.add_message(x_return_status);

2843: WHEN e_return_excp THEN
2844: --
2845: FND_MESSAGE.SET_NAME('WSH','WSH_AUTOCREATE_DEL_ERROR');
2846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2847: wsh_util_core.add_message(x_return_status);
2848: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2849: --{
2850: --
2851: IF l_debug_on THEN

Line 2866: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2862: IF l_debug_on THEN
2863: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
2864: WSH_DEBUG_SV.pop(l_module_name);
2865: END IF;
2866: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2867: x_return_status := l_return_status;
2868: END IF;
2869: --}
2870: END IF;

Line 2886: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2882: END IF;
2883:
2884: WHEN cannot_autocreate_del THEN
2885: FND_MESSAGE.SET_NAME('WSH','WSH_AUTOCREATE_DEL_ERROR');
2886: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2887: wsh_util_core.add_message(x_return_status);
2888: --
2889: -- LPN CONV. rv
2890: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN

Line 2887: wsh_util_core.add_message(x_return_status);

2883:
2884: WHEN cannot_autocreate_del THEN
2885: FND_MESSAGE.SET_NAME('WSH','WSH_AUTOCREATE_DEL_ERROR');
2886: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2887: wsh_util_core.add_message(x_return_status);
2888: --
2889: -- LPN CONV. rv
2890: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2891: --{

Line 2906: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2902: --
2903: IF l_debug_on THEN
2904: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
2905: END IF;
2906: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2907: x_return_status := l_return_status;
2908: END IF;
2909: --
2910: --}

Line 2972: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES');

2968: IF l_debug_on THEN
2969: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES IS ' || L_ERROR_TEXT );
2970: END IF;
2971: --
2972: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES');
2973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2974:
2975: IF l_debug_on THEN
2976: WSH_DEBUG_SV.pop(l_module_name);

Line 2973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2969: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES IS ' || L_ERROR_TEXT );
2970: END IF;
2971: --
2972: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES');
2973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2974:
2975: IF l_debug_on THEN
2976: WSH_DEBUG_SV.pop(l_module_name);
2977: END IF;

Line 3005: p_line_rows IN wsh_util_core.id_tab_type,

3001: -- x_return_status - Status of execution
3002: --------------------------------------------------------------------------
3003:
3004: PROCEDURE autocreate_del_across_orgs(
3005: p_line_rows IN wsh_util_core.id_tab_type,
3006: p_org_rows IN wsh_util_core.id_tab_type,
3007: p_container_flag IN VARCHAR2 := 'N',
3008: p_check_flag IN VARCHAR2 := 'N',
3009: p_caller IN VARCHAR2 DEFAULT NULL,

Line 3006: p_org_rows IN wsh_util_core.id_tab_type,

3002: --------------------------------------------------------------------------
3003:
3004: PROCEDURE autocreate_del_across_orgs(
3005: p_line_rows IN wsh_util_core.id_tab_type,
3006: p_org_rows IN wsh_util_core.id_tab_type,
3007: p_container_flag IN VARCHAR2 := 'N',
3008: p_check_flag IN VARCHAR2 := 'N',
3009: p_caller IN VARCHAR2 DEFAULT NULL,
3010: p_max_detail_commit IN NUMBER := 1000,

Line 3012: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,

3008: p_check_flag IN VARCHAR2 := 'N',
3009: p_caller IN VARCHAR2 DEFAULT NULL,
3010: p_max_detail_commit IN NUMBER := 1000,
3011: p_group_by_header_flag IN VARCHAR2 DEFAULT NULL,
3012: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,
3013: x_grouping_rows OUT NOCOPY wsh_util_core.id_tab_type,
3014: x_return_status OUT NOCOPY VARCHAR2 ) IS
3015:
3016: lower_bound NUMBER;

Line 3013: x_grouping_rows OUT NOCOPY wsh_util_core.id_tab_type,

3009: p_caller IN VARCHAR2 DEFAULT NULL,
3010: p_max_detail_commit IN NUMBER := 1000,
3011: p_group_by_header_flag IN VARCHAR2 DEFAULT NULL,
3012: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,
3013: x_grouping_rows OUT NOCOPY wsh_util_core.id_tab_type,
3014: x_return_status OUT NOCOPY VARCHAR2 ) IS
3015:
3016: lower_bound NUMBER;
3017: upper_bound NUMBER;

Line 3029: temp_ids wsh_util_core.id_tab_type;

3025: t_line_warehouse_id line_org_rec_type;
3026:
3027: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
3028:
3029: temp_ids wsh_util_core.id_tab_type;
3030: curr_warehouse_id NUMBER;
3031:
3032: l_count NUMBER;
3033: l_prev_count NUMBER;

Line 3035: l_del_rows wsh_util_core.id_tab_type;

3031:
3032: l_count NUMBER;
3033: l_prev_count NUMBER;
3034: delcount NUMBER;
3035: l_del_rows wsh_util_core.id_tab_type;
3036: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3037: l_warn_num NUMBER := 0;
3038: --BUG 3379499
3039: l_err_num NUMBER := 0;

Line 3036: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3032: l_count NUMBER;
3033: l_prev_count NUMBER;
3034: delcount NUMBER;
3035: l_del_rows wsh_util_core.id_tab_type;
3036: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3037: l_warn_num NUMBER := 0;
3038: --BUG 3379499
3039: l_err_num NUMBER := 0;
3040: l_ac_dlvy_count NUMBER := 0;

Line 3071: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3067: WSH_DEBUG_SV.log(l_module_name,'P_MAX_DETAIL_COMMIT',P_MAX_DETAIL_COMMIT);
3068: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);
3069: END IF;
3070: --
3071: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3072:
3073: IF (p_line_rows.count = 0) THEN
3074: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3075: fnd_message.SET_name('WSH', 'WSH_NOT_ELIGIBLE_DELIVERIES');

Line 3074: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3070: --
3071: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3072:
3073: IF (p_line_rows.count = 0) THEN
3074: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3075: fnd_message.SET_name('WSH', 'WSH_NOT_ELIGIBLE_DELIVERIES');
3076: wsh_util_core.add_message(x_return_status);
3077: --
3078: -- Debug Statements

Line 3076: wsh_util_core.add_message(x_return_status);

3072:
3073: IF (p_line_rows.count = 0) THEN
3074: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3075: fnd_message.SET_name('WSH', 'WSH_NOT_ELIGIBLE_DELIVERIES');
3076: wsh_util_core.add_message(x_return_status);
3077: --
3078: -- Debug Statements
3079: --
3080: IF l_debug_on THEN

Line 3138: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3134: Only modification is to add message. Since there was no code to exit or return after
3135: call to the above procedure, leaving that behavior the same.
3136:
3137:
3138: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3139: FND_MESSAGE.SET_NAME('WSH', 'WSH_PARAM_NOT_DEFINED');
3140: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3141: wsh_util_core.get_org_name(curr_warehouse_id));
3142: wsh_util_core.add_message(x_return_status,l_module_name);

Line 3141: wsh_util_core.get_org_name(curr_warehouse_id));

3137:
3138: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3139: FND_MESSAGE.SET_NAME('WSH', 'WSH_PARAM_NOT_DEFINED');
3140: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3141: wsh_util_core.get_org_name(curr_warehouse_id));
3142: wsh_util_core.add_message(x_return_status,l_module_name);
3143: END IF;
3144:
3145:

Line 3142: wsh_util_core.add_message(x_return_status,l_module_name);

3138: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3139: FND_MESSAGE.SET_NAME('WSH', 'WSH_PARAM_NOT_DEFINED');
3140: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3141: wsh_util_core.get_org_name(curr_warehouse_id));
3142: wsh_util_core.add_message(x_return_status,l_module_name);
3143: END IF;
3144:
3145:
3146: -- Process Deliveries change, use set up from shipping parameter only if

Line 3178: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3174: FOR delcount IN 1..l_count LOOP
3175: x_del_rows(l_prev_count+delcount):=l_del_rows(delcount);
3176: END LOOP;
3177:
3178: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3179: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3180: raise others;
3181: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3182: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_ERR');

Line 3179: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3175: x_del_rows(l_prev_count+delcount):=l_del_rows(delcount);
3176: END LOOP;
3177:
3178: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3179: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3180: raise others;
3181: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3182: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_ERR');
3183: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',

Line 3181: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

3177:
3178: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3179: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3180: raise others;
3181: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3182: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_ERR');
3183: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3184: wsh_util_core.get_org_name(curr_warehouse_id));
3185: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 3184: wsh_util_core.get_org_name(curr_warehouse_id));

3180: raise others;
3181: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3182: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_ERR');
3183: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3184: wsh_util_core.get_org_name(curr_warehouse_id));
3185: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3186: --BUG 3379499
3187: --Keep count of errors
3188: l_err_num := l_err_num + 1;

Line 3185: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3181: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3182: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_ERR');
3183: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3184: wsh_util_core.get_org_name(curr_warehouse_id));
3185: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3186: --BUG 3379499
3187: --Keep count of errors
3188: l_err_num := l_err_num + 1;
3189: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 3189: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3185: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3186: --BUG 3379499
3187: --Keep count of errors
3188: l_err_num := l_err_num + 1;
3189: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3190: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_WRN');
3191: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3192: wsh_util_core.get_org_name(curr_warehouse_id));
3193: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

Line 3192: wsh_util_core.get_org_name(curr_warehouse_id));

3188: l_err_num := l_err_num + 1;
3189: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3190: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_WRN');
3191: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3192: wsh_util_core.get_org_name(curr_warehouse_id));
3193: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3194: l_warn_num := l_warn_num + 1;
3195: END IF;
3196: END IF;

Line 3193: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

3189: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3190: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_WRN');
3191: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3192: wsh_util_core.get_org_name(curr_warehouse_id));
3193: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3194: l_warn_num := l_warn_num + 1;
3195: END IF;
3196: END IF;
3197: -- Bug 4658241

Line 3202: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3198: /*wsh_tp_release.calculate_cont_del_tpdates(
3199: p_entity => 'DLVY',
3200: p_entity_ids => x_del_rows,
3201: x_return_status => l_return_status);
3202: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3203: raise others;
3204: ELSIF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR , WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3205: l_warn_num := l_warn_num + 1;
3206: END IF; */

Line 3204: ELSIF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR , WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

3200: p_entity_ids => x_del_rows,
3201: x_return_status => l_return_status);
3202: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3203: raise others;
3204: ELSIF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR , WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3205: l_warn_num := l_warn_num + 1;
3206: END IF; */
3207: -- Bug 4658241 end
3208: temp_ids.delete;

Line 3231: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3227: Only modification is to add message. Since there was no code to exit or return after
3228: call to the above procedure, leaving that behavior the same.
3229:
3230:
3231: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3232: FND_MESSAGE.SET_NAME('WSH', 'WSH_PARAM_NOT_DEFINED');
3233: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3234: wsh_util_core.get_org_name(curr_warehouse_id));
3235: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

Line 3234: wsh_util_core.get_org_name(curr_warehouse_id));

3230:
3231: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3232: FND_MESSAGE.SET_NAME('WSH', 'WSH_PARAM_NOT_DEFINED');
3233: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3234: wsh_util_core.get_org_name(curr_warehouse_id));
3235: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3236: l_warn_num := l_warn_num + 1;
3237: END IF;
3238:

Line 3235: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

3231: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3232: FND_MESSAGE.SET_NAME('WSH', 'WSH_PARAM_NOT_DEFINED');
3233: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3234: wsh_util_core.get_org_name(curr_warehouse_id));
3235: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3236: l_warn_num := l_warn_num + 1;
3237: END IF;
3238:
3239: -- Process Deliveries change, use set up from shipping parameter only if

Line 3269: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3265: FOR delcount IN 1..l_count LOOP
3266: x_del_rows(l_prev_count+delcount):=l_del_rows(delcount);
3267: END LOOP;
3268:
3269: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3270: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3271: raise others;
3272: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3273: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_ERR');

Line 3270: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3266: x_del_rows(l_prev_count+delcount):=l_del_rows(delcount);
3267: END LOOP;
3268:
3269: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3270: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3271: raise others;
3272: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3273: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_ERR');
3274: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',

Line 3272: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

3268:
3269: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3270: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3271: raise others;
3272: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3273: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_ERR');
3274: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3275: wsh_util_core.get_org_name(curr_warehouse_id));
3276: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 3275: wsh_util_core.get_org_name(curr_warehouse_id));

3271: raise others;
3272: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3273: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_ERR');
3274: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3275: wsh_util_core.get_org_name(curr_warehouse_id));
3276: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3277: --BUG 3379499
3278: --Keep count of errors
3279: l_err_num := l_err_num + 1;

Line 3276: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3272: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3273: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_ERR');
3274: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3275: wsh_util_core.get_org_name(curr_warehouse_id));
3276: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3277: --BUG 3379499
3278: --Keep count of errors
3279: l_err_num := l_err_num + 1;
3280: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 3280: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3276: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3277: --BUG 3379499
3278: --Keep count of errors
3279: l_err_num := l_err_num + 1;
3280: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3281: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_WRN');
3282: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3283: wsh_util_core.get_org_name(curr_warehouse_id));
3284: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

Line 3283: wsh_util_core.get_org_name(curr_warehouse_id));

3279: l_err_num := l_err_num + 1;
3280: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3281: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_WRN');
3282: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3283: wsh_util_core.get_org_name(curr_warehouse_id));
3284: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3285: l_warn_num := l_warn_num + 1;
3286: END IF;
3287: END IF;

Line 3284: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

3280: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3281: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_DEL_ORG_WRN');
3282: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',
3283: wsh_util_core.get_org_name(curr_warehouse_id));
3284: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3285: l_warn_num := l_warn_num + 1;
3286: END IF;
3287: END IF;
3288:

Line 3295: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3291: /*wsh_tp_release.calculate_cont_del_tpdates(
3292: p_entity => 'DLVY',
3293: p_entity_ids => x_del_rows,
3294: x_return_status => l_return_status);
3295: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3296: raise others;
3297: ELSIF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR , WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3298: l_warn_num := l_warn_num + 1;
3299: END IF; */

Line 3297: ELSIF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR , WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

3293: p_entity_ids => x_del_rows,
3294: x_return_status => l_return_status);
3295: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3296: raise others;
3297: ELSIF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR , WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3298: l_warn_num := l_warn_num + 1;
3299: END IF; */
3300: -- Bug 4658241 end
3301: END IF;

Line 3313: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3309: END IF;
3310: IF l_err_num > 0 THEN
3311: IF l_err_num < l_ac_dlvy_count
3312: THEN
3313: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3314: ELSE
3315: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3316: END IF;
3317: ELSIF l_warn_num > 0 THEN

Line 3315: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3311: IF l_err_num < l_ac_dlvy_count
3312: THEN
3313: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3314: ELSE
3315: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3316: END IF;
3317: ELSIF l_warn_num > 0 THEN
3318: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3319: END IF;

Line 3318: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3314: ELSE
3315: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3316: END IF;
3317: ELSIF l_warn_num > 0 THEN
3318: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3319: END IF;
3320:
3321: --
3322: -- Debug Statements

Line 3335: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS');

3331: --
3332: EXCEPTION
3333: WHEN Others THEN
3334:
3335: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS');
3336: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3337: --
3338: -- Debug Statements
3339: --

Line 3336: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3332: EXCEPTION
3333: WHEN Others THEN
3334:
3335: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS');
3336: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3337: --
3338: -- Debug Statements
3339: --
3340: IF l_debug_on THEN

Line 3392: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable

3388: WSH_DEBUG_SV.logmsg(l_module_name, 'DELETING EMPTY DELIVERIES FOR BATCH '||P_BATCH_ID );
3389: END IF;
3390: --
3391: --OTM R12
3392: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
3393:
3394: IF l_gc3_is_installed IS NULL THEN
3395: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function
3396: END IF; --

Line 3395: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function

3391: --OTM R12
3392: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
3393:
3394: IF l_gc3_is_installed IS NULL THEN
3395: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function
3396: END IF; --
3397: --
3398:
3399: IF (p_batch_id is NOT NULL and p_batch_id > 0) THEN

Line 3435: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3431: END IF;
3432: --
3433:
3434: END IF;
3435: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3436:
3437: --
3438: -- Debug Statements
3439: --

Line 3446: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.DELETE_EMPTY_DELIVERIES');

3442: END IF;
3443: --
3444: EXCEPTION
3445: WHEN OTHERS THEN
3446: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.DELETE_EMPTY_DELIVERIES');
3447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3448: --
3449: -- Debug Statements
3450: --

Line 3447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3443: --
3444: EXCEPTION
3445: WHEN OTHERS THEN
3446: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.DELETE_EMPTY_DELIVERIES');
3447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3448: --
3449: -- Debug Statements
3450: --
3451: IF l_debug_on THEN

Line 3489: l_del_det_id_tbl wsh_util_core.id_tab_type;

3485: l_msg_count NUMBER;
3486: l_msg_data VARCHAR2(32767);
3487: l_index NUMBER;
3488:
3489: l_del_det_id_tbl wsh_util_core.id_tab_type;
3490: l_organization_id_tbl wsh_util_core.id_tab_type;
3491: l_line_direction_tbl wsh_util_core.column_tab_type;
3492:
3493: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

Line 3490: l_organization_id_tbl wsh_util_core.id_tab_type;

3486: l_msg_data VARCHAR2(32767);
3487: l_index NUMBER;
3488:
3489: l_del_det_id_tbl wsh_util_core.id_tab_type;
3490: l_organization_id_tbl wsh_util_core.id_tab_type;
3491: l_line_direction_tbl wsh_util_core.column_tab_type;
3492:
3493: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
3494: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

Line 3491: l_line_direction_tbl wsh_util_core.column_tab_type;

3487: l_index NUMBER;
3488:
3489: l_del_det_id_tbl wsh_util_core.id_tab_type;
3490: l_organization_id_tbl wsh_util_core.id_tab_type;
3491: l_line_direction_tbl wsh_util_core.column_tab_type;
3492:
3493: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
3494: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
3495: l_operation_type VARCHAR2(100);

Line 3505: l_gross_weight_tbl wsh_util_core.id_tab_type;

3501: where delivery_detail_id = p_detail_id;
3502: -- LPN CONV. rv
3503:
3504: -- bug 4416863
3505: l_gross_weight_tbl wsh_util_core.id_tab_type;
3506: l_net_weight_tbl wsh_util_core.id_tab_type;
3507: l_volume_tbl wsh_util_core.id_tab_type;
3508: l_filled_volume_tbl wsh_util_core.id_tab_type;
3509:

Line 3506: l_net_weight_tbl wsh_util_core.id_tab_type;

3502: -- LPN CONV. rv
3503:
3504: -- bug 4416863
3505: l_gross_weight_tbl wsh_util_core.id_tab_type;
3506: l_net_weight_tbl wsh_util_core.id_tab_type;
3507: l_volume_tbl wsh_util_core.id_tab_type;
3508: l_filled_volume_tbl wsh_util_core.id_tab_type;
3509:
3510: --

Line 3507: l_volume_tbl wsh_util_core.id_tab_type;

3503:
3504: -- bug 4416863
3505: l_gross_weight_tbl wsh_util_core.id_tab_type;
3506: l_net_weight_tbl wsh_util_core.id_tab_type;
3507: l_volume_tbl wsh_util_core.id_tab_type;
3508: l_filled_volume_tbl wsh_util_core.id_tab_type;
3509:
3510: --
3511: l_debug_on BOOLEAN;

Line 3508: l_filled_volume_tbl wsh_util_core.id_tab_type;

3504: -- bug 4416863
3505: l_gross_weight_tbl wsh_util_core.id_tab_type;
3506: l_net_weight_tbl wsh_util_core.id_tab_type;
3507: l_volume_tbl wsh_util_core.id_tab_type;
3508: l_filled_volume_tbl wsh_util_core.id_tab_type;
3509:
3510: --
3511: l_debug_on BOOLEAN;
3512: --

Line 3676: WSH_UTIL_CORE.API_POST_CALL

3672: IF l_debug_on THEN
3673: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
3674: END IF;
3675: --
3676: WSH_UTIL_CORE.API_POST_CALL
3677: (
3678: p_return_status => l_return_status,
3679: x_num_warnings => l_num_warnings,
3680: x_num_errors => l_num_errors

Line 3707: WSH_UTIL_CORE.API_POST_CALL

3703: IF l_debug_on THEN
3704: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
3705: END IF;
3706: --
3707: WSH_UTIL_CORE.API_POST_CALL
3708: (
3709: p_return_status => l_return_status,
3710: x_num_warnings => l_num_warnings,
3711: x_num_errors => l_num_errors

Line 3750: WSH_UTIL_CORE.API_POST_CALL

3746: IF l_debug_on THEN
3747: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
3748: END IF;
3749: --
3750: WSH_UTIL_CORE.API_POST_CALL
3751: (
3752: p_return_status => l_return_status,
3753: x_num_warnings => l_num_warnings,
3754: x_num_errors => l_num_errors

Line 3780: WSH_UTIL_CORE.API_POST_CALL

3776: IF l_debug_on THEN
3777: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
3778: END IF;
3779: --
3780: WSH_UTIL_CORE.API_POST_CALL
3781: (
3782: p_return_status => l_return_status,
3783: x_num_warnings => l_num_warnings,
3784: x_num_errors => l_num_errors

Line 3815: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

3811: p_diff_volume => -1 * nvl(l_volume_tbl(l_counter), 0),
3812: p_diff_fill_volume => -1 * nvl(l_filled_volume_tbl(l_counter), 0),
3813: x_return_status => l_return_status);
3814:
3815: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3816: --
3817: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3818: WSH_UTIL_CORE.Add_Message(x_return_status);
3819: IF l_debug_on THEN

Line 3817: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3813: x_return_status => l_return_status);
3814:
3815: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3816: --
3817: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3818: WSH_UTIL_CORE.Add_Message(x_return_status);
3819: IF l_debug_on THEN
3820: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);
3821: WSH_DEBUG_SV.pop(l_module_name);

Line 3818: WSH_UTIL_CORE.Add_Message(x_return_status);

3814:
3815: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3816: --
3817: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3818: WSH_UTIL_CORE.Add_Message(x_return_status);
3819: IF l_debug_on THEN
3820: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);
3821: WSH_DEBUG_SV.pop(l_module_name);
3822: END IF;

Line 3899: WSH_UTIL_CORE.API_POST_CALL

3895: IF l_debug_on THEN
3896: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
3897: END IF;
3898: --
3899: WSH_UTIL_CORE.API_POST_CALL
3900: (
3901: p_return_status => l_return_status,
3902: x_num_warnings => l_num_warnings,
3903: x_num_errors => l_num_errors,

Line 3913: x_return_status := wsh_util_core.g_ret_sts_error;

3909: --
3910: --
3911: --
3912: IF l_num_errors > 0 THEN
3913: x_return_status := wsh_util_core.g_ret_sts_error;
3914: ELSIF l_num_warnings > 0 THEN
3915: x_return_status := wsh_util_core.g_ret_sts_warning;
3916: ELSE
3917: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3915: x_return_status := wsh_util_core.g_ret_sts_warning;

3911: --
3912: IF l_num_errors > 0 THEN
3913: x_return_status := wsh_util_core.g_ret_sts_error;
3914: ELSIF l_num_warnings > 0 THEN
3915: x_return_status := wsh_util_core.g_ret_sts_warning;
3916: ELSE
3917: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3918: END IF;
3919: -- LPN CONV. rv

Line 3917: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3913: x_return_status := wsh_util_core.g_ret_sts_error;
3914: ELSIF l_num_warnings > 0 THEN
3915: x_return_status := wsh_util_core.g_ret_sts_warning;
3916: ELSE
3917: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3918: END IF;
3919: -- LPN CONV. rv
3920: --
3921: -- Debug Statements

Line 3927: --x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; LPN CONV. rv

3923: IF l_debug_on THEN
3924: WSH_DEBUG_SV.logmsg(l_module_name, 'END OF API FOR UNASSIGNING EMPTY CONTAINERS FROM DELIVERIES' );
3925: END IF;
3926: --
3927: --x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; LPN CONV. rv
3928:
3929: --
3930: -- Debug Statements
3931: --

Line 3939: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3935: --
3936: EXCEPTION
3937: WHEN FND_API.G_EXC_ERROR THEN
3938: --
3939: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3940: --
3941: IF l_debug_on THEN
3942: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_PROC_LEVEL);
3943: END IF;

Line 3962: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3958: --
3959: IF l_debug_on THEN
3960: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
3961: END IF;
3962: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3963: x_return_status := l_return_status;
3964: END IF;
3965: --}
3966: END IF;

Line 3977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3973: END IF;
3974: --
3975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3976: --
3977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3978: --
3979: IF l_debug_on THEN
3980: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM FND_API.G_EXC_UNEXPECTED_ERROR',WSH_DEBUG_SV.C_PROC_LEVEL);
3981: END IF;

Line 4002: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3998: --
3999: IF l_debug_on THEN
4000: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
4001: END IF;
4002: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4003: x_return_status := l_return_status;
4004: END IF;
4005: --}
4006: END IF;

Line 4044: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.unassign_empty_containers');

4040: END IF;
4041: --
4042: -- LPN CONV. rv
4043: --
4044: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.unassign_empty_containers');
4045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4046: --
4047: -- Debug Statements
4048: --

Line 4045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4041: --
4042: -- LPN CONV. rv
4043: --
4044: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.unassign_empty_containers');
4045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4046: --
4047: -- Debug Statements
4048: --
4049: IF l_debug_on THEN

Line 4117: l_del_tab WSH_UTIL_CORE.id_tab_type;

4113: l_trip_id_temp NUMBER;
4114: -- l_trip_info_rec_tab is table of c_trip_info%rowtype index by binary_integer;
4115:
4116: l_del_attributes WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4117: l_del_tab WSH_UTIL_CORE.id_tab_type;
4118: l_trip_del_tab WSH_UTIL_CORE.id_tab_type;
4119: l_intermediate_loc_tab WSH_UTIL_CORE.id_tab_type;
4120: l_pickup_stop_id NUMBER;
4121: l_dropoff_stop_id NUMBER;

Line 4118: l_trip_del_tab WSH_UTIL_CORE.id_tab_type;

4114: -- l_trip_info_rec_tab is table of c_trip_info%rowtype index by binary_integer;
4115:
4116: l_del_attributes WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4117: l_del_tab WSH_UTIL_CORE.id_tab_type;
4118: l_trip_del_tab WSH_UTIL_CORE.id_tab_type;
4119: l_intermediate_loc_tab WSH_UTIL_CORE.id_tab_type;
4120: l_pickup_stop_id NUMBER;
4121: l_dropoff_stop_id NUMBER;
4122: l_caller VARCHAR2(30);

Line 4119: l_intermediate_loc_tab WSH_UTIL_CORE.id_tab_type;

4115:
4116: l_del_attributes WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4117: l_del_tab WSH_UTIL_CORE.id_tab_type;
4118: l_trip_del_tab WSH_UTIL_CORE.id_tab_type;
4119: l_intermediate_loc_tab WSH_UTIL_CORE.id_tab_type;
4120: l_pickup_stop_id NUMBER;
4121: l_dropoff_stop_id NUMBER;
4122: l_caller VARCHAR2(30);
4123: l_delivery_leg_id_dummy NUMBER;

Line 4136: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;

4132: l_dummy VARCHAR2(1);
4133: l_rowid VARCHAR2(30);
4134: l_delivery_id NUMBER;
4135: l_delivery_name VARCHAR2(30);
4136: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
4137: l_valid_trip VARCHAR2(1);
4138: l_trip_name_tab wsh_util_core.Column_Tab_Type;
4139: l_trip_id_tab wsh_util_core.id_tab_type;
4140: l_empty_stops_tab wsh_util_core.id_tab_type;

Line 4138: l_trip_name_tab wsh_util_core.Column_Tab_Type;

4134: l_delivery_id NUMBER;
4135: l_delivery_name VARCHAR2(30);
4136: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
4137: l_valid_trip VARCHAR2(1);
4138: l_trip_name_tab wsh_util_core.Column_Tab_Type;
4139: l_trip_id_tab wsh_util_core.id_tab_type;
4140: l_empty_stops_tab wsh_util_core.id_tab_type;
4141: l_transit_time NUMBER;
4142: l_deconsol_do_date DATE;

Line 4139: l_trip_id_tab wsh_util_core.id_tab_type;

4135: l_delivery_name VARCHAR2(30);
4136: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
4137: l_valid_trip VARCHAR2(1);
4138: l_trip_name_tab wsh_util_core.Column_Tab_Type;
4139: l_trip_id_tab wsh_util_core.id_tab_type;
4140: l_empty_stops_tab wsh_util_core.id_tab_type;
4141: l_transit_time NUMBER;
4142: l_deconsol_do_date DATE;
4143: l_num_warnings NUMBER := 0;

Line 4140: l_empty_stops_tab wsh_util_core.id_tab_type;

4136: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
4137: l_valid_trip VARCHAR2(1);
4138: l_trip_name_tab wsh_util_core.Column_Tab_Type;
4139: l_trip_id_tab wsh_util_core.id_tab_type;
4140: l_empty_stops_tab wsh_util_core.id_tab_type;
4141: l_transit_time NUMBER;
4142: l_deconsol_do_date DATE;
4143: l_num_warnings NUMBER := 0;
4144: l_num_errors NUMBER := 0;

Line 4150: l_non_trip_del_tab WSH_UTIL_CORE.id_tab_type;

4146:
4147: WSH_INVALID_TRIPS EXCEPTION;
4148:
4149: --OTM R12, changes for MDC
4150: l_non_trip_del_tab WSH_UTIL_CORE.id_tab_type;
4151: l_non_trip_del_count NUMBER;
4152: l_trip_ignore VARCHAR2(1);
4153: l_trip_ignore_temp VARCHAR2(1);
4154: l_gc3_is_installed VARCHAR2(1);

Line 4155: l_otm_trip_tab WSH_UTIL_CORE.id_tab_type;

4151: l_non_trip_del_count NUMBER;
4152: l_trip_ignore VARCHAR2(1);
4153: l_trip_ignore_temp VARCHAR2(1);
4154: l_gc3_is_installed VARCHAR2(1);
4155: l_otm_trip_tab WSH_UTIL_CORE.id_tab_type;
4156: --END OTM R12
4157:
4158: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Autocreate_Consol_Delivery';
4159: l_debug_on BOOLEAN;

Line 4179: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable

4175: END IF;
4176:
4177: --OTM R12, initialize
4178: l_non_trip_del_count := 1;
4179: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
4180:
4181: IF l_gc3_is_installed IS NULL THEN
4182: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function
4183: END IF;

Line 4182: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function

4178: l_non_trip_del_count := 1;
4179: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable
4180:
4181: IF l_gc3_is_installed IS NULL THEN
4182: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED; -- this is actual function
4183: END IF;
4184: --END OTM R12
4185:
4186: -- If the caller is consolidation SRS program then

Line 4250: wsh_util_core.api_post_call

4246: x_msg_count => l_msg_count,
4247: x_msg_data => l_msg_data
4248: );
4249:
4250: wsh_util_core.api_post_call
4251: (
4252: p_return_status => l_return_status,
4253: x_num_warnings => l_num_warnings,
4254: x_num_errors => l_num_errors

Line 4289: wsh_util_core.api_post_call

4285: p_in_ids => l_otm_trip_tab,
4286: p_action_code => 'IGNORE_PLAN',
4287: x_return_status => l_return_status);
4288:
4289: wsh_util_core.api_post_call
4290: (
4291: p_return_status => l_return_status,
4292: x_num_warnings => l_num_warnings,
4293: x_num_errors => l_num_errors

Line 4308: wsh_util_core.api_post_call

4304: p_in_ids => l_non_trip_del_tab,
4305: p_action_code => 'IGNORE_PLAN',
4306: x_return_status => l_return_status);
4307:
4308: wsh_util_core.api_post_call
4309: (
4310: p_return_status => l_return_status,
4311: x_num_warnings => l_num_warnings,
4312: x_num_errors => l_num_errors

Line 4431: wsh_util_core.api_post_call

4427: END IF;
4428:
4429: wsh_new_deliveries_pvt.create_delivery(l_del_attributes, l_rowid, l_delivery_id, l_delivery_name, l_return_status);
4430:
4431: wsh_util_core.api_post_call
4432: (
4433: p_return_status => l_return_status,
4434: x_num_warnings => l_num_warnings,
4435: x_num_errors => l_num_errors

Line 4453: wsh_util_core.api_post_call

4449: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_trip_del_tab,
4450: p_trip_id => l_trip_id,
4451: x_return_status => l_return_status);
4452:
4453: wsh_util_core.api_post_call
4454: (
4455: p_return_status => l_return_status,
4456: x_num_warnings => l_num_warnings,
4457: x_num_errors => l_num_errors

Line 4472: WSH_UTIL_CORE.Delete(p_type => 'STOP',

4468: WSH_DEBUG_SV.log(l_module_name,'empty stop '||i,l_empty_stops_tab(i));
4469: END LOOP;
4470: END IF;
4471:
4472: WSH_UTIL_CORE.Delete(p_type => 'STOP',
4473: p_rows => l_empty_stops_tab,
4474: x_return_status => l_return_status);
4475:
4476: wsh_util_core.api_post_call

Line 4476: wsh_util_core.api_post_call

4472: WSH_UTIL_CORE.Delete(p_type => 'STOP',
4473: p_rows => l_empty_stops_tab,
4474: x_return_status => l_return_status);
4475:
4476: wsh_util_core.api_post_call
4477: (
4478: p_return_status => l_return_status,
4479: x_num_warnings => l_num_warnings,
4480: x_num_errors => l_num_errors

Line 4500: wsh_util_core.api_post_call

4496: p_dropoff_dep_date => l_del_attributes.ultimate_dropoff_date,
4497: x_return_status => l_return_status,
4498: p_caller => p_caller);
4499:
4500: wsh_util_core.api_post_call
4501: (
4502: p_return_status => l_return_status,
4503: x_num_warnings => l_num_warnings,
4504: x_num_errors => l_num_errors

Line 4520: wsh_util_core.api_post_call

4516: x_trip_ids => l_trip_id_tab,
4517: x_trip_names => l_trip_name_tab,
4518: x_return_status => l_return_status);
4519:
4520: wsh_util_core.api_post_call
4521: (
4522: p_return_status => l_return_status,
4523: x_num_warnings => l_num_warnings,
4524: x_num_errors => l_num_errors

Line 4551: wsh_util_core.api_post_call

4547: p_parent_del_id => l_delivery_id,
4548: p_caller => l_caller,
4549: x_return_status => l_return_status);
4550:
4551: wsh_util_core.api_post_call
4552: (
4553: p_return_status => l_return_status,
4554: x_num_warnings => l_num_warnings,
4555: x_num_errors => l_num_errors

Line 4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4563:
4564:
4565: IF l_num_errors > 0
4566: THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4568: ELSIF l_num_warnings > 0
4569: THEN
4570: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4571: ELSE

Line 4570: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4566: THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4568: ELSIF l_num_warnings > 0
4569: THEN
4570: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4571: ELSE
4572: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4573: END IF;
4574:

Line 4572: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4568: ELSIF l_num_warnings > 0
4569: THEN
4570: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4571: ELSE
4572: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4573: END IF;
4574:
4575: x_parent_del_id := l_delivery_id;
4576: x_parent_trip_id := l_trip_id;

Line 4583: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4579: wsh_debug_sv.pop(l_module_name);
4580: END IF;
4581: EXCEPTION
4582: WHEN FND_API.G_EXC_ERROR THEN
4583: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4584: --
4585: -- Debug Statements
4586: --
4587: IF l_debug_on THEN

Line 4593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4589: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4590: END IF;
4591: --
4592: WHEN WSH_INVALID_TRIPS THEN
4593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4594: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TRIPS');
4595: WSH_UTIL_CORE.Add_Message(x_return_status);
4596: --
4597: -- Debug Statements

Line 4595: WSH_UTIL_CORE.Add_Message(x_return_status);

4591: --
4592: WHEN WSH_INVALID_TRIPS THEN
4593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4594: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TRIPS');
4595: WSH_UTIL_CORE.Add_Message(x_return_status);
4596: --
4597: -- Debug Statements
4598: --
4599: IF l_debug_on THEN

Line 4607: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.Autocreate_Consol_Delivery',l_module_name);

4603: END IF;
4604: --
4605:
4606: WHEN OTHERS THEN
4607: wsh_util_core.default_handler('WSH_DELIVERY_AUTOCREATE.Autocreate_Consol_Delivery',l_module_name);
4608: --
4609: IF l_debug_on THEN
4610: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
4611: END IF;