1: PACKAGE BODY WSH_INTERFACE_EXT_GRP as
2: /* $Header: WSHEXGPB.pls 120.4 2007/12/21 14:52:22 mvudugul noship $ */
3:
4: --===================
5: -- CONSTANTS
3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INTERFACE_EXT_GRP';
8: -- add your constants here if any
9: --===================
10: -- PUBLIC VARS
11: --===================
172: raise;
173: END Handle_missing_info;
174:
175: Procedure Map_del_act_params_rectype(
176: p_in_rec IN WSH_INTERFACE_EXT_GRP.del_action_parameters_rectype,
177: x_out_rec OUT NOCOPY WSH_DELIVERIES_GRP.action_parameters_rectype) IS
178:
179: Begin
180: x_out_rec.caller := p_in_rec.caller ;
222:
223:
224: Procedure Map_del_act_OutRecType(
225: p_in_rec IN WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type,
226: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Action_Out_Rec_Type) IS
227:
228:
229: Begin
230:
258: PROCEDURE Delivery_Action
259: ( p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2,
261: p_commit IN VARCHAR2 , -- default fnd_api.g_false
262: p_action_prms IN WSH_INTERFACE_EXT_GRP.del_action_parameters_rectype,
263: p_delivery_id_tab IN wsh_util_core.id_tab_type,
264: x_delivery_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Action_Out_Rec_Type,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
260: p_init_msg_list IN VARCHAR2,
261: p_commit IN VARCHAR2 , -- default fnd_api.g_false
262: p_action_prms IN WSH_INTERFACE_EXT_GRP.del_action_parameters_rectype,
263: p_delivery_id_tab IN wsh_util_core.id_tab_type,
264: x_delivery_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Action_Out_Rec_Type,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2)
268: IS
292: EXCEPTION
293: --
294: WHEN OTHERS THEN
295: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
296: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.DELIVERY_ACTION');
297: --
298: END Delivery_Action;
299:
300: Procedure Map_Del_InRecType(
297: --
298: END Delivery_Action;
299:
300: Procedure Map_Del_InRecType(
301: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,
302: x_out_rec OUT NOCOPY WSH_DELIVERIES_GRP.Del_In_Rec_Type) IS
303:
304: Begin
305:
309:
310: End Map_Del_InRecType;
311:
312: Procedure Map_Del_Attr_Tbl_Type (
313: p_in_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
314: x_out_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type) Is
315:
316: Begin
317:
463:
464:
465: Procedure Map_Del_OutTblType(
466: p_in_tab IN WSH_DELIVERIES_GRP.Del_Out_Tbl_Type,
467: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type) IS
468:
469:
470: Begin
471:
503: PROCEDURE Create_Update_Delivery
504: ( p_api_version_number IN NUMBER,
505: p_init_msg_list IN VARCHAR2,
506: p_commit IN VARCHAR2 , -- default fnd_api.g_false
507: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,
508: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
509: x_del_out_rec_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type,
510: x_return_status OUT NOCOPY VARCHAR2,
511: x_msg_count OUT NOCOPY NUMBER,
504: ( p_api_version_number IN NUMBER,
505: p_init_msg_list IN VARCHAR2,
506: p_commit IN VARCHAR2 , -- default fnd_api.g_false
507: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,
508: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
509: x_del_out_rec_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type,
510: x_return_status OUT NOCOPY VARCHAR2,
511: x_msg_count OUT NOCOPY NUMBER,
512: x_msg_data OUT NOCOPY VARCHAR2)
505: p_init_msg_list IN VARCHAR2,
506: p_commit IN VARCHAR2 , -- default fnd_api.g_false
507: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,
508: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
509: x_del_out_rec_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type,
510: x_return_status OUT NOCOPY VARCHAR2,
511: x_msg_count OUT NOCOPY NUMBER,
512: x_msg_data OUT NOCOPY VARCHAR2)
513: IS
540: EXCEPTION
541: --
542: WHEN OTHERS THEN
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
544: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_DELIVERY');
545: --
546:
547: END Create_Update_Delivery;
548: --========================================================================
550: -- I Harmonization: rvishnuv ******* Create/Update ******
551:
552:
553: Procedure map_det_act_params_rec_type(
554: p_in_rec IN WSH_INTERFACE_EXT_GRP.det_action_parameters_rec_type,
555: x_out_rec OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type) IS
556:
557: Begin
558:
578:
579:
580: Procedure map_det_act_OutRecType(
581: p_in_rec IN wsh_glbl_var_strct_grp.dd_action_out_rec_type,
582: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.det_action_out_rec_type) IS
583:
584: Begin
585:
586: x_out_rec.valid_id_tab := p_in_rec.valid_id_tab ;
616: x_msg_data OUT NOCOPY VARCHAR2,
617:
618: -- Procedure specific Parameters
619: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
620: p_action_prms IN WSH_INTERFACE_EXT_GRP.det_action_parameters_rec_type,
621: x_action_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.det_action_out_rec_type
622: ) IS
623:
624: --
617:
618: -- Procedure specific Parameters
619: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
620: p_action_prms IN WSH_INTERFACE_EXT_GRP.det_action_parameters_rec_type,
621: x_action_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.det_action_out_rec_type
622: ) IS
623:
624: --
625: l_det_act_params_rec_type wsh_glbl_var_strct_grp.dd_action_parameters_rec_type;
648: --
649: EXCEPTION
650: --
651: WHEN OTHERS THEN
652: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Detail_Action');
653: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: --
656: END Delivery_Detail_Action;
656: END Delivery_Detail_Action;
657:
658:
659: Procedure map_det_Attr_tbl_Type(
660: p_in_tab IN WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,
661: x_out_tab OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_Attr_tbl_Type,
662: p_action IN VARCHAR2) IS
663:
664: l_entity VARCHAR2(4):='DLVB';
838: END LOOP;
839: End map_det_Attr_tbl_Type;
840:
841: Procedure Map_detailInRecType(
842: p_in_rec IN WSH_INTERFACE_EXT_GRP.detailInRecType,
843: x_out_rec OUT NOCOPY wsh_glbl_var_strct_grp.detailInRecType) IS
844:
845: Begin
846:
863: End Map_detailInRecType;
864:
865: Procedure Map_detailOutRecType(
866: p_in_rec IN wsh_glbl_var_strct_grp.detailOutRecType,
867: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.detailOutRecType) IS
868:
869: BEGIN
870:
871: x_out_rec.detail_ids := p_in_rec.detail_ids;
893: x_msg_count OUT NOCOPY NUMBER,
894: x_msg_data OUT NOCOPY VARCHAR2,
895:
896: -- Procedure Specific Parameters
897: p_detail_info_tab IN WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,
898: p_IN_rec IN WSH_INTERFACE_EXT_GRP.detailInRecType,
899: x_OUT_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.detailOutRecType
900: ) IS
901:
894: x_msg_data OUT NOCOPY VARCHAR2,
895:
896: -- Procedure Specific Parameters
897: p_detail_info_tab IN WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,
898: p_IN_rec IN WSH_INTERFACE_EXT_GRP.detailInRecType,
899: x_OUT_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.detailOutRecType
900: ) IS
901:
902: l_det_Attr_tbl_Type wsh_glbl_var_strct_grp.delivery_details_Attr_tbl_Type;
895:
896: -- Procedure Specific Parameters
897: p_detail_info_tab IN WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,
898: p_IN_rec IN WSH_INTERFACE_EXT_GRP.detailInRecType,
899: x_OUT_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.detailOutRecType
900: ) IS
901:
902: l_det_Attr_tbl_Type wsh_glbl_var_strct_grp.delivery_details_Attr_tbl_Type;
903: l_detailInRecType wsh_glbl_var_strct_grp.detailInRecType;
946:
947: --
948: EXCEPTION
949: WHEN OTHERS THEN
950: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail');
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: END Create_Update_Delivery_Detail;
953:
954:
952: END Create_Update_Delivery_Detail;
953:
954:
955: Procedure Map_trip_act_params_rectype(
956: p_in_rec IN WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype,
957: x_out_rec OUT NOCOPY WSH_TRIPS_GRP.action_parameters_rectype) IS
958:
959: Begin
960:
982:
983:
984: Procedure map_tripActionOutRecType(
985: p_in_rec IN WSH_TRIPS_GRP.tripActionOutRecType,
986: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.tripActionOutRecType) IS
987:
988: Begin
989:
990: x_out_rec.result_id_tab := p_in_rec.result_id_tab ;
1004: ( p_api_version_number IN NUMBER,
1005: p_init_msg_list IN VARCHAR2,
1006: p_commit IN VARCHAR2,
1007: p_entity_id_tab IN wsh_util_core.id_tab_type,
1008: p_action_prms IN WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype,
1009: x_trip_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.tripActionOutRecType,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,
1012: x_msg_data OUT NOCOPY VARCHAR2)
1005: p_init_msg_list IN VARCHAR2,
1006: p_commit IN VARCHAR2,
1007: p_entity_id_tab IN wsh_util_core.id_tab_type,
1008: p_action_prms IN WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype,
1009: x_trip_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.tripActionOutRecType,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,
1012: x_msg_data OUT NOCOPY VARCHAR2)
1013: IS
1041: END Trip_Action;
1042:
1043:
1044: Procedure map_stop_act_params_rectype(
1045: p_in_rec IN WSH_INTERFACE_EXT_GRP.stop_action_parameters_rectype,
1046: x_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.action_parameters_rectype) IS
1047:
1048: Begin
1049:
1061:
1062:
1063: Procedure map_stopActionOutRecType(
1064: p_in_rec IN WSH_TRIP_STOPS_GRP.stopActionOutRecType,
1065: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.stopActionOutRecType) IS
1066:
1067: Begin
1068:
1069: x_out_rec.result_id_tab := p_in_rec.result_id_tab ;
1080: ( p_api_version_number IN NUMBER,
1081: p_init_msg_list IN VARCHAR2,
1082: p_commit IN VARCHAR2,
1083: p_entity_id_tab IN wsh_util_core.id_tab_type,
1084: p_action_prms IN WSH_INTERFACE_EXT_GRP.stop_action_parameters_rectype,
1085: x_stop_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.stopActionOutRecType,
1086: x_return_status OUT NOCOPY VARCHAR2,
1087: x_msg_count OUT NOCOPY NUMBER,
1088: x_msg_data OUT NOCOPY VARCHAR2)
1081: p_init_msg_list IN VARCHAR2,
1082: p_commit IN VARCHAR2,
1083: p_entity_id_tab IN wsh_util_core.id_tab_type,
1084: p_action_prms IN WSH_INTERFACE_EXT_GRP.stop_action_parameters_rectype,
1085: x_stop_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.stopActionOutRecType,
1086: x_return_status OUT NOCOPY VARCHAR2,
1087: x_msg_count OUT NOCOPY NUMBER,
1088: x_msg_data OUT NOCOPY VARCHAR2)
1089: IS
1120: --heali
1121:
1122:
1123: Procedure Map_stopInRecType(
1124: p_in_rec IN WSH_INTERFACE_EXT_GRP.stopInRecType,
1125: x_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopInRecType) IS
1126:
1127: Begin
1128:
1133: END Map_stopInRecType;
1134:
1135:
1136: Procedure map_Stop_Attr_Tbl_Type(
1137: p_in_tab IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,
1138: x_out_tab OUT NOCOPY WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type) IS
1139:
1140: Begin
1141:
1221: End Map_Stop_Attr_Tbl_Type;
1222:
1223: Procedure map_stop_out_tab_type(
1224: p_in_tab IN WSH_TRIP_STOPS_GRP.stop_out_tab_type,
1225: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type) IS
1226:
1227: Begin
1228:
1229: for i in 1..p_in_tab.count LOOP
1254: PROCEDURE CREATE_UPDATE_STOP(
1255: p_api_version_number IN NUMBER,
1256: p_init_msg_list IN VARCHAR2,
1257: p_commit IN VARCHAR2,
1258: p_in_rec IN WSH_INTERFACE_EXT_GRP.stopInRecType,
1259: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,
1260: x_stop_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type,
1261: x_return_status OUT NOCOPY VARCHAR2,
1262: x_msg_count OUT NOCOPY NUMBER,
1255: p_api_version_number IN NUMBER,
1256: p_init_msg_list IN VARCHAR2,
1257: p_commit IN VARCHAR2,
1258: p_in_rec IN WSH_INTERFACE_EXT_GRP.stopInRecType,
1259: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,
1260: x_stop_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type,
1261: x_return_status OUT NOCOPY VARCHAR2,
1262: x_msg_count OUT NOCOPY NUMBER,
1263: x_msg_data OUT NOCOPY VARCHAR2) IS
1256: p_init_msg_list IN VARCHAR2,
1257: p_commit IN VARCHAR2,
1258: p_in_rec IN WSH_INTERFACE_EXT_GRP.stopInRecType,
1259: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,
1260: x_stop_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type,
1261: x_return_status OUT NOCOPY VARCHAR2,
1262: x_msg_count OUT NOCOPY NUMBER,
1263: x_msg_data OUT NOCOPY VARCHAR2) IS
1264:
1285: --
1286: EXCEPTION
1287: WHEN OTHERS THEN
1288: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1289: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_STOP');
1290: --
1291: END Create_Update_Stop;
1292:
1293:
1291: END Create_Update_Stop;
1292:
1293:
1294: Procedure Map_Trip_Attr_Tbl_Type(
1295: p_in_tab IN WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,
1296: x_out_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type) IS
1297:
1298: Begin
1299: for i in 1..p_in_tab.count LOOP
1368: End Map_Trip_Attr_Tbl_Type;
1369:
1370:
1371: Procedure map_tripInRecType(
1372: p_in_rec IN WSH_INTERFACE_EXT_GRP.tripInRecType,
1373: x_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripInRecType) IS
1374:
1375: Begin
1376:
1382: End map_tripInRecType;
1383:
1384: Procedure map_trip_Out_Tab_Type(
1385: p_in_tab IN WSH_TRIPS_GRP.trip_Out_Tab_Type,
1386: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) Is
1387:
1388: Begin
1389:
1390: for i in 1..p_in_tab.count LOOP
1417: p_commit IN VARCHAR2,
1418: x_return_status OUT NOCOPY VARCHAR2,
1419: x_msg_count OUT NOCOPY NUMBER,
1420: x_msg_data OUT NOCOPY VARCHAR2,
1421: p_trip_info_tab IN WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,
1422: p_In_rec IN WSH_INTERFACE_EXT_GRP.tripInRecType,
1423: x_Out_Tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) IS
1424:
1425: l_Trip_Attr_Tbl_Type WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1418: x_return_status OUT NOCOPY VARCHAR2,
1419: x_msg_count OUT NOCOPY NUMBER,
1420: x_msg_data OUT NOCOPY VARCHAR2,
1421: p_trip_info_tab IN WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,
1422: p_In_rec IN WSH_INTERFACE_EXT_GRP.tripInRecType,
1423: x_Out_Tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) IS
1424:
1425: l_Trip_Attr_Tbl_Type WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1426: l_tripInRecType WSH_TRIPS_GRP.tripInRecType;
1419: x_msg_count OUT NOCOPY NUMBER,
1420: x_msg_data OUT NOCOPY VARCHAR2,
1421: p_trip_info_tab IN WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,
1422: p_In_rec IN WSH_INTERFACE_EXT_GRP.tripInRecType,
1423: x_Out_Tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) IS
1424:
1425: l_Trip_Attr_Tbl_Type WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1426: l_tripInRecType WSH_TRIPS_GRP.tripInRecType;
1427: l_trip_Out_Tab_Type WSH_TRIPS_GRP.trip_Out_Tab_Type;
1445:
1446: EXCEPTION
1447: WHEN OTHERS THEN
1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1449: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_TRIP');
1450: --
1451: END Create_Update_Trip;
1452:
1453:
1451: END Create_Update_Trip;
1452:
1453:
1454: Procedure map_freight_rec_tab_type(
1455: p_in_tab IN WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,
1456: x_out_tab OUT NOCOPY WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type) IS
1457:
1458: Begin
1459:
1518: End map_freight_rec_tab_type;
1519:
1520:
1521: Procedure map_freightInRecType(
1522: p_in_rec IN WSH_INTERFACE_EXT_GRP.freightInRecType,
1523: x_out_rec OUT NOCOPY WSH_FREIGHT_COSTS_GRP.freightInRecType) IS
1524:
1525: Begin
1526:
1532:
1533:
1534: Procedure map_freight_out_tab_type(
1535: p_in_tab IN WSH_FREIGHT_COSTS_GRP.freight_out_tab_type,
1536: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS
1537:
1538: Begin
1539:
1540:
1553: p_commit IN VARCHAR2,
1554: x_return_status OUT NOCOPY VARCHAR2,
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_freight_info_tab IN WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,
1558: p_in_rec IN WSH_INTERFACE_EXT_GRP.freightInRecType,
1559: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS
1560:
1561: l_freight_rec_tab_type WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
1554: x_return_status OUT NOCOPY VARCHAR2,
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_freight_info_tab IN WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,
1558: p_in_rec IN WSH_INTERFACE_EXT_GRP.freightInRecType,
1559: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS
1560:
1561: l_freight_rec_tab_type WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
1562: l_freightInRecType WSH_FREIGHT_COSTS_GRP.freightInRecType;
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_freight_info_tab IN WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,
1558: p_in_rec IN WSH_INTERFACE_EXT_GRP.freightInRecType,
1559: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS
1560:
1561: l_freight_rec_tab_type WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
1562: l_freightInRecType WSH_FREIGHT_COSTS_GRP.freightInRecType;
1563: l_freight_out_tab_type WSH_FREIGHT_COSTS_GRP.freight_out_tab_type;
1581: --
1582: EXCEPTION
1583: WHEN OTHERS THEN
1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1585: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_FREIGHT_COSTS');
1586: END Create_Update_Freight_costs;
1587: --heali
1588:
1589: PROCEDURE Get_Exceptions (
1598: p_logging_entity_id IN NUMBER,
1599: p_logging_entity_name IN VARCHAR2,
1600:
1601: -- program specific out parameters
1602: x_exceptions_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.XC_TAB_TYPE
1603: )
1604: IS
1605:
1606: BEGIN
1610: --
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1614: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Get_Exceptions');
1615: END Get_Exceptions;
1616:
1617:
1618: PROCEDURE Exception_Action (
1623: x_msg_count OUT NOCOPY NUMBER,
1624: x_msg_data OUT NOCOPY VARCHAR2,
1625: x_return_status OUT NOCOPY VARCHAR2,
1626:
1627: p_exception_rec IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.XC_ACTION_REC_TYPE,
1628: p_action IN VARCHAR2
1629: )
1630:
1631: IS
1637: --
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1641: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Exception_Action');
1642: END Exception_Action;
1643:
1644:
1645:
1647: p_api_version_number IN NUMBER,
1648: p_init_msg_list IN VARCHAR2,
1649: p_commit IN VARCHAR2,
1650: p_dlvy_leg_id_tab IN wsh_util_core.id_tab_type,
1651: p_action_prms IN WSH_INTERFACE_EXT_GRP.dlvy_leg_action_prms_rectype,
1652: x_action_out_rec IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.dlvy_leg_action_out_rec_type,
1653: x_return_status OUT NOCOPY VARCHAR2,
1654: x_msg_count OUT NOCOPY NUMBER,
1655: x_msg_data OUT NOCOPY VARCHAR2
1648: p_init_msg_list IN VARCHAR2,
1649: p_commit IN VARCHAR2,
1650: p_dlvy_leg_id_tab IN wsh_util_core.id_tab_type,
1651: p_action_prms IN WSH_INTERFACE_EXT_GRP.dlvy_leg_action_prms_rectype,
1652: x_action_out_rec IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.dlvy_leg_action_out_rec_type,
1653: x_return_status OUT NOCOPY VARCHAR2,
1654: x_msg_count OUT NOCOPY NUMBER,
1655: x_msg_data OUT NOCOPY VARCHAR2
1656: ) IS
1662: --
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1666: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Leg_Action');
1667: END Delivery_Leg_Action;
1668:
1669:
1670: --OTM R12
1821: END IF;
1822:
1823: WHEN Others THEN
1824:
1825: WSH_UTIL_CORE.Default_Handler('WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM', l_module_name);
1826: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1827:
1828: IF l_debug_on THEN
1829: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1832:
1833: END OTM_PRE_SHIP_CONFIRM;
1834: --END OTM R12
1835:
1836: END WSH_INTERFACE_EXT_GRP;