[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)
451: wsh_debug_sv.log (l_module_name,'After deriving SC Rule details', x_return_status);
452: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
453: END IF;
454:
455: wsh_util_core.api_post_call(
456: p_return_status =>x_return_status,
457: x_num_warnings =>l_num_warnings,
458: x_num_errors =>l_num_errors);
459: END IF;
506: IF l_debug_on THEN
507: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
508: END IF;
509:
510: wsh_util_core.api_post_call(
511: p_return_status =>x_return_status,
512: x_num_warnings =>l_num_warnings,
513: x_num_errors =>l_num_errors);
514:
512: x_num_warnings =>l_num_warnings,
513: x_num_errors =>l_num_errors);
514:
515: IF l_num_warnings > 0 THEN
516: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
517: END IF;
518: --
519: IF FND_API.To_Boolean( p_commit ) THEN
520: COMMIT WORK;
530: --
531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
534: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
535: FND_MSG_PUB.Count_And_Get
536: (
537: p_count => x_msg_count,
538: p_data => x_msg_data,
545: END IF;
546: --
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
550: FND_MSG_PUB.Count_And_Get
551: (
552: p_count => x_msg_count,
553: p_data => x_msg_data,
558: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
559: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
560: END IF;
561: --
562: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
563: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
564: FND_MSG_PUB.Count_And_Get
565: (
566: p_count => x_msg_count,
559: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
560: END IF;
561: --
562: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
563: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
564: FND_MSG_PUB.Count_And_Get
565: (
566: p_count => x_msg_count,
567: p_data => x_msg_data,
568: p_encoded => FND_API.G_FALSE
569: );
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
573: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
574: END IF;
575: --
576: WHEN OTHERS THEN
569: );
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
573: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
574: END IF;
575: --
576: WHEN OTHERS THEN
577: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
574: END IF;
575: --
576: WHEN OTHERS THEN
577: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
579: wsh_util_core.default_handler('WSH_INTERFACE_GRP.DELIVERY_ACTION');
580: FND_MSG_PUB.Count_And_Get
581: (
582: p_count => x_msg_count,
575: --
576: WHEN OTHERS THEN
577: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
579: wsh_util_core.default_handler('WSH_INTERFACE_GRP.DELIVERY_ACTION');
580: FND_MSG_PUB.Count_And_Get
581: (
582: p_count => x_msg_count,
583: p_data => x_msg_data,
728:
729: EXCEPTION
730:
731: WHEN OTHERS THEN
732: wsh_util_core.default_handler (
733: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_blank_space', l_module_name);
734: IF l_debug_on THEN
735: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
736: ' Oracle error message is '|| SQLERRM,
838: IF l_debug_on THEN
839: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
840: END IF;
841: --
842: wsh_util_core.api_post_call(
843: p_return_status =>x_return_status,
844: x_num_warnings =>l_num_warnings,
845: x_num_errors =>l_num_errors);
846: --
844: x_num_warnings =>l_num_warnings,
845: x_num_errors =>l_num_errors);
846: --
847: IF l_num_warnings > 0 THEN
848: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
849: END IF;
850: --
851: IF FND_API.To_Boolean( p_commit ) THEN
852: COMMIT WORK;
862: --
863: EXCEPTION
864: WHEN FND_API.G_EXC_ERROR THEN
865: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
866: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
867: FND_MSG_PUB.Count_And_Get
868: (
869: p_count => x_msg_count,
870: p_data => x_msg_data,
877: END IF;
878: --
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
882: FND_MSG_PUB.Count_And_Get
883: (
884: p_count => x_msg_count,
885: p_data => x_msg_data,
890: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
892: END IF;
893: --
894: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
895: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
896: FND_MSG_PUB.Count_And_Get
897: (
898: p_count => x_msg_count,
891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
892: END IF;
893: --
894: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
895: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
896: FND_MSG_PUB.Count_And_Get
897: (
898: p_count => x_msg_count,
899: p_data => x_msg_data,
900: p_encoded => FND_API.G_FALSE
901: );
902: --
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
905: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
906: END IF;
907: --
908: WHEN OTHERS THEN
901: );
902: --
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
905: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
906: END IF;
907: --
908: WHEN OTHERS THEN
909: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
906: END IF;
907: --
908: WHEN OTHERS THEN
909: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
910: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
911: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_DELIVERY');
912: FND_MSG_PUB.Count_And_Get
913: (
914: p_count => x_msg_count,
907: --
908: WHEN OTHERS THEN
909: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
910: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
911: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_DELIVERY');
912: FND_MSG_PUB.Count_And_Get
913: (
914: p_count => x_msg_count,
915: p_data => x_msg_data,
950: x_msg_count OUT NOCOPY NUMBER,
951: x_msg_data OUT NOCOPY VARCHAR2,
952:
953: -- Procedure specific Parameters
954: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
955: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
956: ,
957: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
958: ) IS
1039: END IF;
1040: --
1041: --
1042: -- Initialize API return status to success
1043: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1044: l_number_of_errors := 0;
1045: l_number_of_warnings := 0;
1046:
1047:
1122: );
1123:
1124: --
1125: IF l_debug_on THEN
1126: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1127: END IF;
1128:
1129: wsh_util_core.api_post_call(
1130: p_return_status => l_return_status,
1125: IF l_debug_on THEN
1126: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1127: END IF;
1128:
1129: wsh_util_core.api_post_call(
1130: p_return_status => l_return_status,
1131: x_num_warnings => l_number_of_warnings,
1132: x_num_errors => l_number_of_errors,
1133: p_msg_data => l_msg_data
1134: );
1135:
1136:
1137: IF l_number_of_warnings > 0 THEN
1138: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1139: END IF;
1140:
1141: -- Standard check of p_commit.
1142: IF FND_API.To_Boolean( p_commit ) THEN
1186: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1188: END IF;
1189: --
1190: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1191: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1192: FND_MSG_PUB.Count_And_Get
1193: (
1194: p_count => x_msg_count,
1187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1188: END IF;
1189: --
1190: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1191: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1192: FND_MSG_PUB.Count_And_Get
1193: (
1194: p_count => x_msg_count,
1195: p_data => x_msg_data,
1196: p_encoded => FND_API.G_FALSE
1197: );
1198: --
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1202: END IF;
1203: --
1204: WHEN OTHERS THEN
1197: );
1198: --
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1202: END IF;
1203: --
1204: WHEN OTHERS THEN
1205: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');
1201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1202: END IF;
1203: --
1204: WHEN OTHERS THEN
1205: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');
1206: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208: FND_MSG_PUB.Count_And_Get
1209: (
1334:
1335: EXCEPTION
1336:
1337: WHEN OTHERS THEN
1338: wsh_util_core.default_handler (
1339: 'WSH_TRIP_STOPS_GRP.Rtrim_details_blank_space', l_module_name);
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
1342: ' Oracle error message is '|| SQLERRM,
1386: l_number_of_warnings NUMBER := 0;
1387: --
1388: l_counter NUMBER := 0;
1389:
1390: l_valid_index_tab wsh_util_core.id_tab_type;
1391: l_delivery_id NUMBER;
1392: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type
1393: ;
1394: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1436: END IF;
1437: --
1438: --
1439: -- Initialize API return status to success
1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1441: l_number_of_errors := 0;
1442: l_number_of_warnings := 0;
1443:
1444:
1477: );
1478:
1479: --
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1482: END IF;
1483: --
1484: wsh_util_core.api_post_call(
1485: p_return_status => l_return_status,
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1482: END IF;
1483: --
1484: wsh_util_core.api_post_call(
1485: p_return_status => l_return_status,
1486: x_num_warnings => l_number_of_warnings,
1487: x_num_errors => l_number_of_errors,
1488: p_msg_data => l_msg_data
1488: p_msg_data => l_msg_data
1489: );
1490:
1491: IF l_number_of_warnings > 0 THEN
1492: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1493: END IF;
1494:
1495: -- Standard check of p_commit.
1496: IF FND_API.To_Boolean( p_commit ) THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1543: END IF;
1544: --
1545: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1546: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1547: FND_MSG_PUB.Count_And_Get
1548: (
1549: p_count => x_msg_count,
1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1543: END IF;
1544: --
1545: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1546: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1547: FND_MSG_PUB.Count_And_Get
1548: (
1549: p_count => x_msg_count,
1550: p_data => x_msg_data,
1551: p_encoded => FND_API.G_FALSE
1552: );
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1557: END IF;
1558: --
1559: WHEN OTHERS THEN
1552: );
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1557: END IF;
1558: --
1559: WHEN OTHERS THEN
1560: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Create_Update_Delivery_Detail');
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1557: END IF;
1558: --
1559: WHEN OTHERS THEN
1560: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Create_Update_Delivery_Detail');
1561: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1563: FND_MSG_PUB.Count_And_Get
1564: (
1585: PROCEDURE Trip_Action
1586: ( p_api_version_number IN NUMBER,
1587: p_init_msg_list IN VARCHAR2,
1588: p_commit IN VARCHAR2,
1589: p_entity_id_tab IN wsh_util_core.id_tab_type,
1590: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
1591: x_trip_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripActionOutRecType,
1592: x_return_status OUT NOCOPY VARCHAR2,
1593: x_msg_count OUT NOCOPY NUMBER,
1641: wsh_debug_sv.push (l_module_name);
1642: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1643: END IF;
1644:
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1646:
1647: l_action_prms := p_action_prms;
1648: l_action_prms.caller := RTRIM(p_action_prms.caller);
1649: l_action_prms.action_code := RTRIM(p_action_prms.action_code);
1715: IF l_debug_on THEN
1716: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
1717: END IF;
1718:
1719: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1720: x_num_warnings =>l_num_warning,
1721: x_num_errors =>l_num_errors);
1722:
1723: x_return_status := l_return_status;
1722:
1723: x_return_status := l_return_status;
1724:
1725: IF l_num_warning > 0 THEN
1726: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1727: END IF;
1728: FND_MSG_PUB.Count_And_Get
1729: ( p_count => x_msg_count
1730: , p_data => x_msg_data
1736: END IF;
1737:
1738: EXCEPTION
1739: WHEN FND_API.G_EXC_ERROR THEN
1740: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1741: FND_MSG_PUB.Count_And_Get
1742: ( p_count => x_msg_count
1743: , p_data => x_msg_data
1744: );
1746: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1747: WSH_DEBUG_SV.pop(l_module_name);
1748: END IF;
1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1750: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1751: FND_MSG_PUB.Count_And_Get
1752: ( p_count => x_msg_count
1753: , p_data => x_msg_data
1754: );
1755: IF l_debug_on THEN
1756: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1757: WSH_DEBUG_SV.pop(l_module_name);
1758: END IF;
1759: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1760: FND_MSG_PUB.Count_And_Get
1761: ( p_count => x_msg_count
1762: , p_data => x_msg_data
1763: );
1760: FND_MSG_PUB.Count_And_Get
1761: ( p_count => x_msg_count
1762: , p_data => x_msg_data
1763: );
1764: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1765: IF l_debug_on THEN
1766: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1767: WSH_DEBUG_SV.pop(l_module_name);
1768: END IF;
1766: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1767: WSH_DEBUG_SV.pop(l_module_name);
1768: END IF;
1769: WHEN OTHERS THEN
1770: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1771: l_module_name);
1772: FND_MSG_PUB.Count_And_Get
1773: ( p_count => x_msg_count
1774: , p_data => x_msg_data
1773: ( p_count => x_msg_count
1774: , p_data => x_msg_data
1775: );
1776:
1777: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1778: IF l_debug_on THEN
1779: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
1780: WSH_DEBUG_SV.pop(l_module_name);
1781: END IF;
1790: PROCEDURE Stop_Action
1791: ( p_api_version_number IN NUMBER,
1792: p_init_msg_list IN VARCHAR2,
1793: p_commit IN VARCHAR2,
1794: p_entity_id_tab IN wsh_util_core.id_tab_type,
1795: p_action_prms IN WSH_TRIP_STOPS_GRP.action_parameters_rectype,
1796: x_stop_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopActionOutRecType,
1797: x_return_status OUT NOCOPY VARCHAR2,
1798: x_msg_count OUT NOCOPY NUMBER,
1798: x_msg_count OUT NOCOPY NUMBER,
1799: x_msg_data OUT NOCOPY VARCHAR2)
1800: IS
1801:
1802: --l_stop_id_tab wsh_util_core.id_tab_type;
1803: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1804: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1805: l_num_warning NUMBER := 0;
1806: l_num_errors NUMBER := 0;
1847: wsh_debug_sv.push (l_module_name);
1848: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1849: END IF;
1850:
1851: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1852:
1853: l_action_prms := p_action_prms;
1854: l_action_prms.caller := RTRIM(p_action_prms.caller);
1855: l_action_prms.action_code := RTRIM(p_action_prms.action_code);
1906: IF l_debug_on THEN
1907: wsh_debug_sv.log (l_module_name,'l_return_status', l_return_status);
1908: END IF;
1909:
1910: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1911: x_num_warnings =>l_num_warning,
1912: x_num_errors =>l_num_errors);
1913:
1914: IF l_num_warning > 0 THEN
1911: x_num_warnings =>l_num_warning,
1912: x_num_errors =>l_num_errors);
1913:
1914: IF l_num_warning > 0 THEN
1915: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1916: END IF;
1917:
1918: x_return_status := l_return_status;
1919:
1927: END IF;
1928:
1929: EXCEPTION
1930: WHEN FND_API.G_EXC_ERROR THEN
1931: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1932: FND_MSG_PUB.Count_And_Get
1933: ( p_count => x_msg_count
1934: , p_data => x_msg_data
1935: );
1937: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1938: WSH_DEBUG_SV.pop(l_module_name);
1939: END IF;
1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1941: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1942: FND_MSG_PUB.Count_And_Get
1943: ( p_count => x_msg_count
1944: , p_data => x_msg_data
1945: );
1946: IF l_debug_on THEN
1947: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1948: WSH_DEBUG_SV.pop(l_module_name);
1949: END IF;
1950: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1951: FND_MSG_PUB.Count_And_Get
1952: ( p_count => x_msg_count
1953: , p_data => x_msg_data
1954: );
1951: FND_MSG_PUB.Count_And_Get
1952: ( p_count => x_msg_count
1953: , p_data => x_msg_data
1954: );
1955: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1956: IF l_debug_on THEN
1957: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1958: WSH_DEBUG_SV.pop(l_module_name);
1959: END IF;
1957: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1958: WSH_DEBUG_SV.pop(l_module_name);
1959: END IF;
1960: WHEN OTHERS THEN
1961: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',
1962: l_module_name);
1963: FND_MSG_PUB.Count_And_Get
1964: ( p_count => x_msg_count
1965: , p_data => x_msg_data
1964: ( p_count => x_msg_count
1965: , p_data => x_msg_data
1966: );
1967:
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: IF l_debug_on THEN
1970: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
1971: WSH_DEBUG_SV.pop(l_module_name);
1972: END IF;
2047:
2048: EXCEPTION
2049:
2050: WHEN OTHERS THEN
2051: wsh_util_core.default_handler (
2052: 'WSH_TRIP_STOPS_GRP.Rtrim_stops_blank_space', l_module_name);
2053: IF l_debug_on THEN
2054: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2055: ' Oracle error message is '|| SQLERRM,
2143: x_msg_data => x_msg_data,
2144: x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab --bug 2796095
2145: );
2146:
2147: wsh_util_core.api_post_call(
2148: p_return_status =>x_return_status,
2149: x_num_warnings =>l_num_warnings,
2150: x_num_errors =>l_num_errors);
2151: --
2149: x_num_warnings =>l_num_warnings,
2150: x_num_errors =>l_num_errors);
2151: --
2152: IF l_num_warnings > 0 THEN
2153: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2154: END IF;
2155: --
2156: FND_MSG_PUB.Count_And_Get (
2157: p_count => x_msg_count,
2163: --
2164: EXCEPTION
2165: WHEN FND_API.G_EXC_ERROR THEN
2166: ROLLBACK TO create_update_stop_wrap_grp;
2167: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2168: FND_MSG_PUB.Count_And_Get
2169: (
2170: p_count => x_msg_count,
2171: p_data => x_msg_data,
2178: END IF;
2179: --
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181: ROLLBACK TO create_update_stop_wrap_grp;
2182: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2183: FND_MSG_PUB.Count_And_Get
2184: (
2185: p_count => x_msg_count,
2186: p_data => x_msg_data,
2191: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2193: END IF;
2194: --
2195: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2196: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2197: FND_MSG_PUB.Count_And_Get
2198: (
2199: p_count => x_msg_count,
2192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2193: END IF;
2194: --
2195: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2196: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2197: FND_MSG_PUB.Count_And_Get
2198: (
2199: p_count => x_msg_count,
2200: p_data => x_msg_data,
2201: p_encoded => FND_API.G_FALSE
2202: );
2203: --
2204: IF l_debug_on THEN
2205: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2207: END IF;
2208: WHEN OTHERS THEN
2209: ROLLBACK TO create_update_stop_wrap_grp;
2202: );
2203: --
2204: IF l_debug_on THEN
2205: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2207: END IF;
2208: WHEN OTHERS THEN
2209: ROLLBACK TO create_update_stop_wrap_grp;
2210: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2207: END IF;
2208: WHEN OTHERS THEN
2209: ROLLBACK TO create_update_stop_wrap_grp;
2210: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2211: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_STOP');
2212: FND_MSG_PUB.Count_And_Get
2213: (
2214: p_count => x_msg_count,
2207: END IF;
2208: WHEN OTHERS THEN
2209: ROLLBACK TO create_update_stop_wrap_grp;
2210: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2211: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_STOP');
2212: FND_MSG_PUB.Count_And_Get
2213: (
2214: p_count => x_msg_count,
2215: p_data => x_msg_data,
2297:
2298: EXCEPTION
2299:
2300: WHEN OTHERS THEN
2301: wsh_util_core.default_handler (
2302: 'WSH_TRIP_STOPS_GRP.Rtrim_trips_blank_space', l_module_name);
2303: IF l_debug_on THEN
2304: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2305: ' Oracle error message is '|| SQLERRM,
2387: p_trip_info_tab => l_trip_info_tab,
2388: p_In_rec => l_In_rec,
2389: x_Out_tab => x_Out_Tab);
2390:
2391: wsh_util_core.api_post_call(
2392: p_return_status =>x_return_status,
2393: x_num_warnings =>l_num_warnings,
2394: x_num_errors =>l_num_errors);
2395: --
2393: x_num_warnings =>l_num_warnings,
2394: x_num_errors =>l_num_errors);
2395: --
2396: IF l_num_warnings > 0 THEN
2397: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2398: END IF;
2399: --
2400: FND_MSG_PUB.Count_And_Get (
2401: p_count => x_msg_count,
2407: --
2408: EXCEPTION
2409: WHEN FND_API.G_EXC_ERROR THEN
2410: ROLLBACK TO create_update_trip_wrap_grp;
2411: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2412: FND_MSG_PUB.Count_And_Get
2413: (
2414: p_count => x_msg_count,
2415: p_data => x_msg_data,
2422: END IF;
2423: --
2424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2425: ROLLBACK TO create_update_trip_wrap_grp;
2426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2427: FND_MSG_PUB.Count_And_Get
2428: (
2429: p_count => x_msg_count,
2430: p_data => x_msg_data,
2435: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2437: END IF;
2438: --
2439: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2440: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2441: FND_MSG_PUB.Count_And_Get
2442: (
2443: p_count => x_msg_count,
2436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2437: END IF;
2438: --
2439: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2440: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2441: FND_MSG_PUB.Count_And_Get
2442: (
2443: p_count => x_msg_count,
2444: p_data => x_msg_data,
2445: p_encoded => FND_API.G_FALSE
2446: );
2447: --
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2450: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2451: END IF;
2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_update_trip_wrap_grp;
2446: );
2447: --
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2450: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2451: END IF;
2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_update_trip_wrap_grp;
2454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2450: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2451: END IF;
2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_update_trip_wrap_grp;
2454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2455: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP');
2456: FND_MSG_PUB.Count_And_Get
2457: (
2458: p_count => x_msg_count,
2451: END IF;
2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_update_trip_wrap_grp;
2454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2455: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP');
2456: FND_MSG_PUB.Count_And_Get
2457: (
2458: p_count => x_msg_count,
2459: p_data => x_msg_data,
2523:
2524: EXCEPTION
2525:
2526: WHEN OTHERS THEN
2527: wsh_util_core.default_handler (
2528: 'WSH_TRIP_STOPS_GRP.Rtrim_freightcost_blank_space', l_module_name);
2529: IF l_debug_on THEN
2530: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2531: ' Oracle error message is '|| SQLERRM,
2599: p_freight_info_tab => l_freight_info_tab,
2600: p_in_rec => l_in_rec,
2601: x_out_tab => x_out_tab );
2602:
2603: wsh_util_core.api_post_call(
2604: p_return_status =>x_return_status,
2605: x_num_warnings =>l_num_warnings,
2606: x_num_errors =>l_num_errors);
2607: --
2605: x_num_warnings =>l_num_warnings,
2606: x_num_errors =>l_num_errors);
2607: --
2608: IF l_num_warnings > 0 THEN
2609: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2610: END IF;
2611: --
2612: FND_MSG_PUB.Count_And_Get (
2613: p_count => x_msg_count,
2619: --
2620: EXCEPTION
2621: WHEN FND_API.G_EXC_ERROR THEN
2622: ROLLBACK TO Create_Update_Freight_Costs_WG;
2623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2624: FND_MSG_PUB.Count_And_Get
2625: (
2626: p_count => x_msg_count,
2627: p_data => x_msg_data,
2634: END IF;
2635: --
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2637: ROLLBACK TO Create_Update_Freight_Costs_WG;
2638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2639: FND_MSG_PUB.Count_And_Get
2640: (
2641: p_count => x_msg_count,
2642: p_data => x_msg_data,
2647: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2648: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2649: END IF;
2650: --
2651: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2652: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2653: FND_MSG_PUB.Count_And_Get
2654: (
2655: p_count => x_msg_count,
2648: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2649: END IF;
2650: --
2651: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2652: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2653: FND_MSG_PUB.Count_And_Get
2654: (
2655: p_count => x_msg_count,
2656: p_data => x_msg_data,
2657: p_encoded => FND_API.G_FALSE
2658: );
2659: --
2660: IF l_debug_on THEN
2661: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2663: END IF;
2664: WHEN OTHERS THEN
2665: ROLLBACK TO Create_Update_Freight_Costs_WG;
2658: );
2659: --
2660: IF l_debug_on THEN
2661: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2663: END IF;
2664: WHEN OTHERS THEN
2665: ROLLBACK TO Create_Update_Freight_Costs_WG;
2666: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2663: END IF;
2664: WHEN OTHERS THEN
2665: ROLLBACK TO Create_Update_Freight_Costs_WG;
2666: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2667: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_FREIGHT_COSTS');
2668: FND_MSG_PUB.Count_And_Get
2669: (
2670: p_count => x_msg_count,
2663: END IF;
2664: WHEN OTHERS THEN
2665: ROLLBACK TO Create_Update_Freight_Costs_WG;
2666: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2667: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_FREIGHT_COSTS');
2668: FND_MSG_PUB.Count_And_Get
2669: (
2670: p_count => x_msg_count,
2671: p_data => x_msg_data,
2747:
2748: EXCEPTION
2749:
2750: WHEN others THEN
2751: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2753: --
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2748: EXCEPTION
2749:
2750: WHEN others THEN
2751: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2753: --
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2756: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');