[Home] [Help]
63:
64: EXCEPTION
65:
66: WHEN OTHERS THEN
67: wsh_util_core.default_handler (
68: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_action', l_module_name);
69: IF l_debug_on THEN
70: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
71: ' Oracle error message is '|| SQLERRM,
93: -- SC Rule defaults
94: --========================================================================
95: PROCEDURE derive_sc_rule_details(p_rule_id IN NUMBER,
96: p_rule_name IN VARCHAR2,
97: p_delivery_id_tab IN wsh_util_core.id_tab_type,
98: x_out_params IN OUT NOCOPY WSH_DELIVERIES_GRP.action_parameters_rectype,
99: x_return_status OUT NOCOPY VARCHAR2) IS
100:
101: -- Use Ship Confirm Rule for the Organization
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.push(l_module_name);
191: END IF;
192:
193: x_return_status := wsh_util_core.g_ret_sts_success;
194:
195: l_first_ship_method := TRUE;
196:
197: IF (p_rule_id IS NOT NULL OR p_rule_name IS NOT NULL) THEN
212:
213: IF get_sc_rule%NOTFOUND THEN
214: fnd_message.set_name('WSH','WSH_ACTIVE_SC_RULE');
215: CLOSE get_sc_rule;
216: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
217: IF l_debug_on THEN
218: WSH_DEBUG_SV.logmsg(l_module_name,'No Valid Rule found');
219: WSH_DEBUG_SV.pop(l_module_name);
220: END IF;
330:
331: EXCEPTION
332:
333: WHEN others THEN
334: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.derive_sc_rule_details',l_module_name);
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
336: --
337: IF l_debug_on THEN
338: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
331: EXCEPTION
332:
333: WHEN others THEN
334: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.derive_sc_rule_details',l_module_name);
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
336: --
337: IF l_debug_on THEN
338: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
339: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
363: ( p_api_version_number IN NUMBER,
364: p_init_msg_list IN VARCHAR2,
365: p_commit IN VARCHAR2 , -- default fnd_api.g_false
366: p_action_prms IN WSH_DELIVERIES_GRP.action_parameters_rectype,
367: p_delivery_id_tab IN wsh_util_core.id_tab_type,
368: x_delivery_out_rec OUT NOCOPY WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2)
453: wsh_debug_sv.log (l_module_name,'After deriving SC Rule details', x_return_status);
454: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
455: END IF;
456:
457: wsh_util_core.api_post_call(
458: p_return_status =>x_return_status,
459: x_num_warnings =>l_num_warnings,
460: x_num_errors =>l_num_errors);
461: END IF;
510: IF l_debug_on THEN
511: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
512: END IF;
513:
514: wsh_util_core.api_post_call(
515: p_return_status =>x_return_status,
516: x_num_warnings =>l_num_warnings,
517: x_num_errors =>l_num_errors);
518:
516: x_num_warnings =>l_num_warnings,
517: x_num_errors =>l_num_errors);
518:
519: IF l_num_warnings > 0 THEN
520: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
521: END IF;
522: --
523: IF FND_API.To_Boolean( p_commit ) THEN
524: COMMIT WORK;
534: --
535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get
540: (
541: p_count => x_msg_count,
542: p_data => x_msg_data,
549: END IF;
550: --
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
553: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
554: FND_MSG_PUB.Count_And_Get
555: (
556: p_count => x_msg_count,
557: p_data => x_msg_data,
562: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
563: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
564: END IF;
565: --
566: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
567: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
568: FND_MSG_PUB.Count_And_Get
569: (
570: p_count => x_msg_count,
563: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
564: END IF;
565: --
566: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
567: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
568: FND_MSG_PUB.Count_And_Get
569: (
570: p_count => x_msg_count,
571: p_data => x_msg_data,
572: p_encoded => FND_API.G_FALSE
573: );
574: --
575: IF l_debug_on THEN
576: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
577: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
578: END IF;
579: --
580: WHEN OTHERS THEN
573: );
574: --
575: IF l_debug_on THEN
576: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
577: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
578: END IF;
579: --
580: WHEN OTHERS THEN
581: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
578: END IF;
579: --
580: WHEN OTHERS THEN
581: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
582: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
583: wsh_util_core.default_handler('WSH_INTERFACE_GRP.DELIVERY_ACTION');
584: FND_MSG_PUB.Count_And_Get
585: (
586: p_count => x_msg_count,
579: --
580: WHEN OTHERS THEN
581: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
582: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
583: wsh_util_core.default_handler('WSH_INTERFACE_GRP.DELIVERY_ACTION');
584: FND_MSG_PUB.Count_And_Get
585: (
586: p_count => x_msg_count,
587: p_data => x_msg_data,
732:
733: EXCEPTION
734:
735: WHEN OTHERS THEN
736: wsh_util_core.default_handler (
737: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_blank_space', l_module_name);
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
740: ' Oracle error message is '|| SQLERRM,
842: IF l_debug_on THEN
843: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
844: END IF;
845: --
846: wsh_util_core.api_post_call(
847: p_return_status =>x_return_status,
848: x_num_warnings =>l_num_warnings,
849: x_num_errors =>l_num_errors);
850: --
848: x_num_warnings =>l_num_warnings,
849: x_num_errors =>l_num_errors);
850: --
851: IF l_num_warnings > 0 THEN
852: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
853: END IF;
854: --
855: IF FND_API.To_Boolean( p_commit ) THEN
856: COMMIT WORK;
866: --
867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN
869: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
870: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
871: FND_MSG_PUB.Count_And_Get
872: (
873: p_count => x_msg_count,
874: p_data => x_msg_data,
881: END IF;
882: --
883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
886: FND_MSG_PUB.Count_And_Get
887: (
888: p_count => x_msg_count,
889: p_data => x_msg_data,
894: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
895: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
896: END IF;
897: --
898: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
899: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
900: FND_MSG_PUB.Count_And_Get
901: (
902: p_count => x_msg_count,
895: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
896: END IF;
897: --
898: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
899: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
900: FND_MSG_PUB.Count_And_Get
901: (
902: p_count => x_msg_count,
903: p_data => x_msg_data,
904: p_encoded => FND_API.G_FALSE
905: );
906: --
907: IF l_debug_on THEN
908: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
909: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
910: END IF;
911: --
912: WHEN OTHERS THEN
905: );
906: --
907: IF l_debug_on THEN
908: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
909: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
910: END IF;
911: --
912: WHEN OTHERS THEN
913: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
910: END IF;
911: --
912: WHEN OTHERS THEN
913: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
914: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
915: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_DELIVERY');
916: FND_MSG_PUB.Count_And_Get
917: (
918: p_count => x_msg_count,
911: --
912: WHEN OTHERS THEN
913: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
914: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
915: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_DELIVERY');
916: FND_MSG_PUB.Count_And_Get
917: (
918: p_count => x_msg_count,
919: p_data => x_msg_data,
954: x_msg_count OUT NOCOPY NUMBER,
955: x_msg_data OUT NOCOPY VARCHAR2,
956:
957: -- Procedure specific Parameters
958: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
959: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
960: ,
961: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
962: ) IS
1043: END IF;
1044: --
1045: --
1046: -- Initialize API return status to success
1047: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1048: l_number_of_errors := 0;
1049: l_number_of_warnings := 0;
1050:
1051:
1126: );
1127:
1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1131: END IF;
1132:
1133: wsh_util_core.api_post_call(
1134: p_return_status => l_return_status,
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1131: END IF;
1132:
1133: wsh_util_core.api_post_call(
1134: p_return_status => l_return_status,
1135: x_num_warnings => l_number_of_warnings,
1136: x_num_errors => l_number_of_errors,
1137: p_msg_data => l_msg_data
1138: );
1139:
1140:
1141: IF l_number_of_warnings > 0 THEN
1142: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1143: END IF;
1144:
1145: -- Standard check of p_commit.
1146: IF FND_API.To_Boolean( p_commit ) THEN
1190: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1192: END IF;
1193: --
1194: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1195: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1196: FND_MSG_PUB.Count_And_Get
1197: (
1198: p_count => x_msg_count,
1191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1192: END IF;
1193: --
1194: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1195: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1196: FND_MSG_PUB.Count_And_Get
1197: (
1198: p_count => x_msg_count,
1199: p_data => x_msg_data,
1200: p_encoded => FND_API.G_FALSE
1201: );
1202: --
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1205: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1206: END IF;
1207: --
1208: WHEN OTHERS THEN
1201: );
1202: --
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1205: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1206: END IF;
1207: --
1208: WHEN OTHERS THEN
1209: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');
1205: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1206: END IF;
1207: --
1208: WHEN OTHERS THEN
1209: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');
1210: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1212: FND_MSG_PUB.Count_And_Get
1213: (
1338:
1339: EXCEPTION
1340:
1341: WHEN OTHERS THEN
1342: wsh_util_core.default_handler (
1343: 'WSH_TRIP_STOPS_GRP.Rtrim_details_blank_space', l_module_name);
1344: IF l_debug_on THEN
1345: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
1346: ' Oracle error message is '|| SQLERRM,
1390: l_number_of_warnings NUMBER := 0;
1391: --
1392: l_counter NUMBER := 0;
1393:
1394: l_valid_index_tab wsh_util_core.id_tab_type;
1395: l_delivery_id NUMBER;
1396: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type
1397: ;
1398: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1440: END IF;
1441: --
1442: --
1443: -- Initialize API return status to success
1444: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1445: l_number_of_errors := 0;
1446: l_number_of_warnings := 0;
1447:
1448:
1481: );
1482:
1483: --
1484: IF l_debug_on THEN
1485: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1486: END IF;
1487: --
1488: wsh_util_core.api_post_call(
1489: p_return_status => l_return_status,
1484: IF l_debug_on THEN
1485: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1486: END IF;
1487: --
1488: wsh_util_core.api_post_call(
1489: p_return_status => l_return_status,
1490: x_num_warnings => l_number_of_warnings,
1491: x_num_errors => l_number_of_errors,
1492: p_msg_data => l_msg_data
1492: p_msg_data => l_msg_data
1493: );
1494:
1495: IF l_number_of_warnings > 0 THEN
1496: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1497: END IF;
1498:
1499: -- Standard check of p_commit.
1500: IF FND_API.To_Boolean( p_commit ) THEN
1545: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1547: END IF;
1548: --
1549: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1550: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1551: FND_MSG_PUB.Count_And_Get
1552: (
1553: p_count => x_msg_count,
1546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1547: END IF;
1548: --
1549: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1550: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1551: FND_MSG_PUB.Count_And_Get
1552: (
1553: p_count => x_msg_count,
1554: p_data => x_msg_data,
1555: p_encoded => FND_API.G_FALSE
1556: );
1557: --
1558: IF l_debug_on THEN
1559: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1560: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1561: END IF;
1562: --
1563: WHEN OTHERS THEN
1556: );
1557: --
1558: IF l_debug_on THEN
1559: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1560: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1561: END IF;
1562: --
1563: WHEN OTHERS THEN
1564: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Create_Update_Delivery_Detail');
1560: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1561: END IF;
1562: --
1563: WHEN OTHERS THEN
1564: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Create_Update_Delivery_Detail');
1565: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1567: FND_MSG_PUB.Count_And_Get
1568: (
1589: PROCEDURE Trip_Action
1590: ( p_api_version_number IN NUMBER,
1591: p_init_msg_list IN VARCHAR2,
1592: p_commit IN VARCHAR2,
1593: p_entity_id_tab IN wsh_util_core.id_tab_type,
1594: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
1595: x_trip_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripActionOutRecType,
1596: x_return_status OUT NOCOPY VARCHAR2,
1597: x_msg_count OUT NOCOPY NUMBER,
1645: wsh_debug_sv.push (l_module_name);
1646: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1647: END IF;
1648:
1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1650:
1651: l_action_prms := p_action_prms;
1652: l_action_prms.caller := RTRIM(p_action_prms.caller);
1653: l_action_prms.action_code := RTRIM(p_action_prms.action_code);
1719: IF l_debug_on THEN
1720: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
1721: END IF;
1722:
1723: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1724: x_num_warnings =>l_num_warning,
1725: x_num_errors =>l_num_errors);
1726:
1727: x_return_status := l_return_status;
1726:
1727: x_return_status := l_return_status;
1728:
1729: IF l_num_warning > 0 THEN
1730: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1731: END IF;
1732: FND_MSG_PUB.Count_And_Get
1733: ( p_count => x_msg_count
1734: , p_data => x_msg_data
1740: END IF;
1741:
1742: EXCEPTION
1743: WHEN FND_API.G_EXC_ERROR THEN
1744: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1745: FND_MSG_PUB.Count_And_Get
1746: ( p_count => x_msg_count
1747: , p_data => x_msg_data
1748: );
1750: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1751: WSH_DEBUG_SV.pop(l_module_name);
1752: END IF;
1753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1754: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1755: FND_MSG_PUB.Count_And_Get
1756: ( p_count => x_msg_count
1757: , p_data => x_msg_data
1758: );
1759: IF l_debug_on THEN
1760: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1761: WSH_DEBUG_SV.pop(l_module_name);
1762: END IF;
1763: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1764: FND_MSG_PUB.Count_And_Get
1765: ( p_count => x_msg_count
1766: , p_data => x_msg_data
1767: );
1764: FND_MSG_PUB.Count_And_Get
1765: ( p_count => x_msg_count
1766: , p_data => x_msg_data
1767: );
1768: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1769: IF l_debug_on THEN
1770: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1771: WSH_DEBUG_SV.pop(l_module_name);
1772: END IF;
1770: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1771: WSH_DEBUG_SV.pop(l_module_name);
1772: END IF;
1773: WHEN OTHERS THEN
1774: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1775: l_module_name);
1776: FND_MSG_PUB.Count_And_Get
1777: ( p_count => x_msg_count
1778: , p_data => x_msg_data
1777: ( p_count => x_msg_count
1778: , p_data => x_msg_data
1779: );
1780:
1781: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1782: IF l_debug_on THEN
1783: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
1784: WSH_DEBUG_SV.pop(l_module_name);
1785: END IF;
1794: PROCEDURE Stop_Action
1795: ( p_api_version_number IN NUMBER,
1796: p_init_msg_list IN VARCHAR2,
1797: p_commit IN VARCHAR2,
1798: p_entity_id_tab IN wsh_util_core.id_tab_type,
1799: p_action_prms IN WSH_TRIP_STOPS_GRP.action_parameters_rectype,
1800: x_stop_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopActionOutRecType,
1801: x_return_status OUT NOCOPY VARCHAR2,
1802: x_msg_count OUT NOCOPY NUMBER,
1802: x_msg_count OUT NOCOPY NUMBER,
1803: x_msg_data OUT NOCOPY VARCHAR2)
1804: IS
1805:
1806: --l_stop_id_tab wsh_util_core.id_tab_type;
1807: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1808: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1809: l_num_warning NUMBER := 0;
1810: l_num_errors NUMBER := 0;
1851: wsh_debug_sv.push (l_module_name);
1852: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1853: END IF;
1854:
1855: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1856:
1857: l_action_prms := p_action_prms;
1858: l_action_prms.caller := RTRIM(p_action_prms.caller);
1859: l_action_prms.action_code := RTRIM(p_action_prms.action_code);
1910: IF l_debug_on THEN
1911: wsh_debug_sv.log (l_module_name,'l_return_status', l_return_status);
1912: END IF;
1913:
1914: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1915: x_num_warnings =>l_num_warning,
1916: x_num_errors =>l_num_errors);
1917:
1918: IF l_num_warning > 0 THEN
1915: x_num_warnings =>l_num_warning,
1916: x_num_errors =>l_num_errors);
1917:
1918: IF l_num_warning > 0 THEN
1919: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1920: END IF;
1921:
1922: x_return_status := l_return_status;
1923:
1931: END IF;
1932:
1933: EXCEPTION
1934: WHEN FND_API.G_EXC_ERROR THEN
1935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1936: FND_MSG_PUB.Count_And_Get
1937: ( p_count => x_msg_count
1938: , p_data => x_msg_data
1939: );
1941: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1942: WSH_DEBUG_SV.pop(l_module_name);
1943: END IF;
1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1946: FND_MSG_PUB.Count_And_Get
1947: ( p_count => x_msg_count
1948: , p_data => x_msg_data
1949: );
1950: IF l_debug_on THEN
1951: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1952: WSH_DEBUG_SV.pop(l_module_name);
1953: END IF;
1954: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1955: FND_MSG_PUB.Count_And_Get
1956: ( p_count => x_msg_count
1957: , p_data => x_msg_data
1958: );
1955: FND_MSG_PUB.Count_And_Get
1956: ( p_count => x_msg_count
1957: , p_data => x_msg_data
1958: );
1959: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1960: IF l_debug_on THEN
1961: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1962: WSH_DEBUG_SV.pop(l_module_name);
1963: END IF;
1961: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1962: WSH_DEBUG_SV.pop(l_module_name);
1963: END IF;
1964: WHEN OTHERS THEN
1965: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',
1966: l_module_name);
1967: FND_MSG_PUB.Count_And_Get
1968: ( p_count => x_msg_count
1969: , p_data => x_msg_data
1968: ( p_count => x_msg_count
1969: , p_data => x_msg_data
1970: );
1971:
1972: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1973: IF l_debug_on THEN
1974: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
1975: WSH_DEBUG_SV.pop(l_module_name);
1976: END IF;
2051:
2052: EXCEPTION
2053:
2054: WHEN OTHERS THEN
2055: wsh_util_core.default_handler (
2056: 'WSH_TRIP_STOPS_GRP.Rtrim_stops_blank_space', l_module_name);
2057: IF l_debug_on THEN
2058: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2059: ' Oracle error message is '|| SQLERRM,
2147: x_msg_data => x_msg_data,
2148: x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab --bug 2796095
2149: );
2150:
2151: wsh_util_core.api_post_call(
2152: p_return_status =>x_return_status,
2153: x_num_warnings =>l_num_warnings,
2154: x_num_errors =>l_num_errors);
2155: --
2153: x_num_warnings =>l_num_warnings,
2154: x_num_errors =>l_num_errors);
2155: --
2156: IF l_num_warnings > 0 THEN
2157: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2158: END IF;
2159: --
2160: FND_MSG_PUB.Count_And_Get (
2161: p_count => x_msg_count,
2167: --
2168: EXCEPTION
2169: WHEN FND_API.G_EXC_ERROR THEN
2170: ROLLBACK TO create_update_stop_wrap_grp;
2171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2172: FND_MSG_PUB.Count_And_Get
2173: (
2174: p_count => x_msg_count,
2175: p_data => x_msg_data,
2182: END IF;
2183: --
2184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2185: ROLLBACK TO create_update_stop_wrap_grp;
2186: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2187: FND_MSG_PUB.Count_And_Get
2188: (
2189: p_count => x_msg_count,
2190: p_data => x_msg_data,
2195: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2197: END IF;
2198: --
2199: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2200: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2201: FND_MSG_PUB.Count_And_Get
2202: (
2203: p_count => x_msg_count,
2196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2197: END IF;
2198: --
2199: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2200: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2201: FND_MSG_PUB.Count_And_Get
2202: (
2203: p_count => x_msg_count,
2204: p_data => x_msg_data,
2205: p_encoded => FND_API.G_FALSE
2206: );
2207: --
2208: IF l_debug_on THEN
2209: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2211: END IF;
2212: WHEN OTHERS THEN
2213: ROLLBACK TO create_update_stop_wrap_grp;
2206: );
2207: --
2208: IF l_debug_on THEN
2209: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2211: END IF;
2212: WHEN OTHERS THEN
2213: ROLLBACK TO create_update_stop_wrap_grp;
2214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2211: END IF;
2212: WHEN OTHERS THEN
2213: ROLLBACK TO create_update_stop_wrap_grp;
2214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2215: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_STOP');
2216: FND_MSG_PUB.Count_And_Get
2217: (
2218: p_count => x_msg_count,
2211: END IF;
2212: WHEN OTHERS THEN
2213: ROLLBACK TO create_update_stop_wrap_grp;
2214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2215: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_STOP');
2216: FND_MSG_PUB.Count_And_Get
2217: (
2218: p_count => x_msg_count,
2219: p_data => x_msg_data,
2301:
2302: EXCEPTION
2303:
2304: WHEN OTHERS THEN
2305: wsh_util_core.default_handler (
2306: 'WSH_TRIP_STOPS_GRP.Rtrim_trips_blank_space', l_module_name);
2307: IF l_debug_on THEN
2308: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2309: ' Oracle error message is '|| SQLERRM,
2391: p_trip_info_tab => l_trip_info_tab,
2392: p_In_rec => l_In_rec,
2393: x_Out_tab => x_Out_Tab);
2394:
2395: wsh_util_core.api_post_call(
2396: p_return_status =>x_return_status,
2397: x_num_warnings =>l_num_warnings,
2398: x_num_errors =>l_num_errors);
2399: --
2397: x_num_warnings =>l_num_warnings,
2398: x_num_errors =>l_num_errors);
2399: --
2400: IF l_num_warnings > 0 THEN
2401: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2402: END IF;
2403: --
2404: FND_MSG_PUB.Count_And_Get (
2405: p_count => x_msg_count,
2411: --
2412: EXCEPTION
2413: WHEN FND_API.G_EXC_ERROR THEN
2414: ROLLBACK TO create_update_trip_wrap_grp;
2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2416: FND_MSG_PUB.Count_And_Get
2417: (
2418: p_count => x_msg_count,
2419: p_data => x_msg_data,
2426: END IF;
2427: --
2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2429: ROLLBACK TO create_update_trip_wrap_grp;
2430: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2431: FND_MSG_PUB.Count_And_Get
2432: (
2433: p_count => x_msg_count,
2434: p_data => x_msg_data,
2439: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2440: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2441: END IF;
2442: --
2443: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2444: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2445: FND_MSG_PUB.Count_And_Get
2446: (
2447: p_count => x_msg_count,
2440: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2441: END IF;
2442: --
2443: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2444: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2445: FND_MSG_PUB.Count_And_Get
2446: (
2447: p_count => x_msg_count,
2448: p_data => x_msg_data,
2449: p_encoded => FND_API.G_FALSE
2450: );
2451: --
2452: IF l_debug_on THEN
2453: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2455: END IF;
2456: WHEN OTHERS THEN
2457: ROLLBACK TO create_update_trip_wrap_grp;
2450: );
2451: --
2452: IF l_debug_on THEN
2453: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2455: END IF;
2456: WHEN OTHERS THEN
2457: ROLLBACK TO create_update_trip_wrap_grp;
2458: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2455: END IF;
2456: WHEN OTHERS THEN
2457: ROLLBACK TO create_update_trip_wrap_grp;
2458: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2459: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP');
2460: FND_MSG_PUB.Count_And_Get
2461: (
2462: p_count => x_msg_count,
2455: END IF;
2456: WHEN OTHERS THEN
2457: ROLLBACK TO create_update_trip_wrap_grp;
2458: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2459: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP');
2460: FND_MSG_PUB.Count_And_Get
2461: (
2462: p_count => x_msg_count,
2463: p_data => x_msg_data,
2527:
2528: EXCEPTION
2529:
2530: WHEN OTHERS THEN
2531: wsh_util_core.default_handler (
2532: 'WSH_TRIP_STOPS_GRP.Rtrim_freightcost_blank_space', l_module_name);
2533: IF l_debug_on THEN
2534: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2535: ' Oracle error message is '|| SQLERRM,
2603: p_freight_info_tab => l_freight_info_tab,
2604: p_in_rec => l_in_rec,
2605: x_out_tab => x_out_tab );
2606:
2607: wsh_util_core.api_post_call(
2608: p_return_status =>x_return_status,
2609: x_num_warnings =>l_num_warnings,
2610: x_num_errors =>l_num_errors);
2611: --
2609: x_num_warnings =>l_num_warnings,
2610: x_num_errors =>l_num_errors);
2611: --
2612: IF l_num_warnings > 0 THEN
2613: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2614: END IF;
2615: --
2616: FND_MSG_PUB.Count_And_Get (
2617: p_count => x_msg_count,
2623: --
2624: EXCEPTION
2625: WHEN FND_API.G_EXC_ERROR THEN
2626: ROLLBACK TO Create_Update_Freight_Costs_WG;
2627: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2628: FND_MSG_PUB.Count_And_Get
2629: (
2630: p_count => x_msg_count,
2631: p_data => x_msg_data,
2638: END IF;
2639: --
2640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2641: ROLLBACK TO Create_Update_Freight_Costs_WG;
2642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2643: FND_MSG_PUB.Count_And_Get
2644: (
2645: p_count => x_msg_count,
2646: p_data => x_msg_data,
2651: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2653: END IF;
2654: --
2655: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2656: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2657: FND_MSG_PUB.Count_And_Get
2658: (
2659: p_count => x_msg_count,
2652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2653: END IF;
2654: --
2655: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2656: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2657: FND_MSG_PUB.Count_And_Get
2658: (
2659: p_count => x_msg_count,
2660: p_data => x_msg_data,
2661: p_encoded => FND_API.G_FALSE
2662: );
2663: --
2664: IF l_debug_on THEN
2665: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2666: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2667: END IF;
2668: WHEN OTHERS THEN
2669: ROLLBACK TO Create_Update_Freight_Costs_WG;
2662: );
2663: --
2664: IF l_debug_on THEN
2665: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2666: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2667: END IF;
2668: WHEN OTHERS THEN
2669: ROLLBACK TO Create_Update_Freight_Costs_WG;
2670: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2666: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2667: END IF;
2668: WHEN OTHERS THEN
2669: ROLLBACK TO Create_Update_Freight_Costs_WG;
2670: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2671: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_FREIGHT_COSTS');
2672: FND_MSG_PUB.Count_And_Get
2673: (
2674: p_count => x_msg_count,
2667: END IF;
2668: WHEN OTHERS THEN
2669: ROLLBACK TO Create_Update_Freight_Costs_WG;
2670: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2671: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_FREIGHT_COSTS');
2672: FND_MSG_PUB.Count_And_Get
2673: (
2674: p_count => x_msg_count,
2675: p_data => x_msg_data,
2751:
2752: EXCEPTION
2753:
2754: WHEN others THEN
2755: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
2756: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2757: --
2758: IF l_debug_on THEN
2759: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2752: EXCEPTION
2753:
2754: WHEN others THEN
2755: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
2756: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2757: --
2758: IF l_debug_on THEN
2759: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2760: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');