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

Line 12: G_WMS_ENABLED WSH_UTIL_CORE.Column_Tab_Type;

8: TYPE Shipping_Param_Tab IS TABLE OF WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ INDEX BY BINARY_INTEGER;
9:
10: --
11: G_PARAM_INFO_TAB Shipping_Param_Tab;
12: G_WMS_ENABLED WSH_UTIL_CORE.Column_Tab_Type;
13: G_DELIVERY_ID WSH_UTIL_CORE.Id_Tab_Type;
14: G_FTE_INSTALLED VARCHAR2(10);
15: G_FETCH_LIMIT CONSTANT NUMBER := 10000;
16:

Line 13: G_DELIVERY_ID WSH_UTIL_CORE.Id_Tab_Type;

9:
10: --
11: G_PARAM_INFO_TAB Shipping_Param_Tab;
12: G_WMS_ENABLED WSH_UTIL_CORE.Column_Tab_Type;
13: G_DELIVERY_ID WSH_UTIL_CORE.Id_Tab_Type;
14: G_FTE_INSTALLED VARCHAR2(10);
15: G_FETCH_LIMIT CONSTANT NUMBER := 10000;
16:
17:

Line 263: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

259: END IF;
260: IF c_check_duplicate%ISOPEN THEN
261: CLOSE c_check_duplicate;
262: END IF;
263: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
264: END check_duplicate_rec;
265:
266:
267: --========================================================================

Line 425: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

421: EXCEPTION
422: WHEN RESOURCE_BUSY THEN
423: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
424: FND_MSG_PUB.ADD;
425: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
428: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
429: FND_MSG_PUB.ADD;

Line 569: wsh_util_core.add_message (WSH_UTIL_CORE.G_RET_STS_ERROR, l_Module_name);

565: IF l_query_count > 0 THEN
566: --{
567: --Put an error messge on stack
568: fnd_message.set_name ( 'WSH', 'WSH_IB_SP_SHIP_SITE_NO_MERGE' );
569: wsh_util_core.add_message (WSH_UTIL_CORE.G_RET_STS_ERROR, l_Module_name);
570: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
571: --
572: IF l_debug_on THEN
573: WSH_DEBUG_SV.logmsg(l_module_name, 'Supplier SF sites cannot be merged', WSH_DEBUG_SV.C_STMT_LEVEL);

Line 570: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

566: --{
567: --Put an error messge on stack
568: fnd_message.set_name ( 'WSH', 'WSH_IB_SP_SHIP_SITE_NO_MERGE' );
569: wsh_util_core.add_message (WSH_UTIL_CORE.G_RET_STS_ERROR, l_Module_name);
570: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
571: --
572: IF l_debug_on THEN
573: WSH_DEBUG_SV.logmsg(l_module_name, 'Supplier SF sites cannot be merged', WSH_DEBUG_SV.C_STMT_LEVEL);
574: WSH_DEBUG_SV.log(l_module_name, 'x_Return_Status', x_Return_Status);

Line 635: WSH_UTIL_CORE.api_post_call

631: IF l_debug_on THEN
632: WSH_DEBUG_SV.log(l_module_name, 'After calling Create_Site, return status', l_return_status);
633: END IF;
634: --
635: WSH_UTIL_CORE.api_post_call
636: (
637: p_return_status => l_return_status,
638: x_num_warnings => l_num_warnings,
639: x_num_errors => l_num_errors

Line 651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

647: --}
648: END IF;
649: --
650: IF l_num_errors > 0 THEN
651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
652: ELSIF l_num_warnings > 0 THEN
653: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
654: ELSE
655: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 653: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

649: --
650: IF l_num_errors > 0 THEN
651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
652: ELSIF l_num_warnings > 0 THEN
653: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
654: ELSE
655: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
656: END IF;
657: --

Line 655: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
652: ELSIF l_num_warnings > 0 THEN
653: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
654: ELSE
655: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
656: END IF;
657: --
658: IF l_debug_on THEN
659: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status', x_return_status);

Line 747: WSH_UTIL_CORE.enable_concurrent_log_print;

743: l_dummy NUMBER;
744: --
745: BEGIN
746: --
747: WSH_UTIL_CORE.enable_concurrent_log_print;
748: --
749: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
750: --
751: IF l_debug_on IS NULL THEN

Line 755: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

751: IF l_debug_on IS NULL THEN
752: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
753: END IF;
754: --
755: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
756: --
757: IF l_debug_on THEN
758: WSH_DEBUG_SV.push(l_module_name);
759: WSH_DEBUG_SV.log(l_module_name,'P_TO_ID',p_to_id);

Line 849: wsh_util_core.printMsg(l_msg);

845: --
846: fnd_message.set_token('SUPPLIER_NAME' , p_from_supplier_name );
847: fnd_message.set_token('CAL_TYPE' , check_calendar_Rec.calendar_type );
848: l_msg := FND_MESSAGE.GET;
849: wsh_util_core.printMsg(l_msg);
850: --}
851: END IF;-- IF (check_dup_assignment %NOTFOUND)
852: --
853: CLOSE check_dup_assignment;

Line 868: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

864: EXCEPTION
865: --
866: WHEN OTHERS THEN
867: --
868: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
869: wsh_util_core.default_handler('WSH_PARTY_MERGE.Update_Entities_during_merge');
870: IF l_debug_on THEN
871: --
872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occurred.

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

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

Line 916: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,

912: -- unassigning delivery from Trip.
913:
914: PROCEDURE Adjust_Weight_Volume (
915: p_entity_type IN VARCHAR2,
916: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
917: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
918: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
919: p_delivery_leg_id IN WSH_UTIL_CORE.Id_Tab_Type,
920: p_net_weight IN WSH_UTIL_CORE.Id_Tab_Type,

Line 917: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,

913:
914: PROCEDURE Adjust_Weight_Volume (
915: p_entity_type IN VARCHAR2,
916: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
917: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
918: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
919: p_delivery_leg_id IN WSH_UTIL_CORE.Id_Tab_Type,
920: p_net_weight IN WSH_UTIL_CORE.Id_Tab_Type,
921: p_gross_weight IN WSH_UTIL_CORE.Id_Tab_Type,

Line 918: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,

914: PROCEDURE Adjust_Weight_Volume (
915: p_entity_type IN VARCHAR2,
916: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
917: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
918: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
919: p_delivery_leg_id IN WSH_UTIL_CORE.Id_Tab_Type,
920: p_net_weight IN WSH_UTIL_CORE.Id_Tab_Type,
921: p_gross_weight IN WSH_UTIL_CORE.Id_Tab_Type,
922: p_volume IN WSH_UTIL_CORE.Id_Tab_Type,

Line 919: p_delivery_leg_id IN WSH_UTIL_CORE.Id_Tab_Type,

915: p_entity_type IN VARCHAR2,
916: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
917: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
918: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
919: p_delivery_leg_id IN WSH_UTIL_CORE.Id_Tab_Type,
920: p_net_weight IN WSH_UTIL_CORE.Id_Tab_Type,
921: p_gross_weight IN WSH_UTIL_CORE.Id_Tab_Type,
922: p_volume IN WSH_UTIL_CORE.Id_Tab_Type,
923: x_return_status OUT NOCOPY VARCHAR2 )

Line 920: p_net_weight IN WSH_UTIL_CORE.Id_Tab_Type,

916: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
917: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
918: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
919: p_delivery_leg_id IN WSH_UTIL_CORE.Id_Tab_Type,
920: p_net_weight IN WSH_UTIL_CORE.Id_Tab_Type,
921: p_gross_weight IN WSH_UTIL_CORE.Id_Tab_Type,
922: p_volume IN WSH_UTIL_CORE.Id_Tab_Type,
923: x_return_status OUT NOCOPY VARCHAR2 )
924: IS

Line 921: p_gross_weight IN WSH_UTIL_CORE.Id_Tab_Type,

917: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
918: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
919: p_delivery_leg_id IN WSH_UTIL_CORE.Id_Tab_Type,
920: p_net_weight IN WSH_UTIL_CORE.Id_Tab_Type,
921: p_gross_weight IN WSH_UTIL_CORE.Id_Tab_Type,
922: p_volume IN WSH_UTIL_CORE.Id_Tab_Type,
923: x_return_status OUT NOCOPY VARCHAR2 )
924: IS
925: l_return_status VARCHAR2(10);

Line 922: p_volume IN WSH_UTIL_CORE.Id_Tab_Type,

918: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
919: p_delivery_leg_id IN WSH_UTIL_CORE.Id_Tab_Type,
920: p_net_weight IN WSH_UTIL_CORE.Id_Tab_Type,
921: p_gross_weight IN WSH_UTIL_CORE.Id_Tab_Type,
922: p_volume IN WSH_UTIL_CORE.Id_Tab_Type,
923: x_return_status OUT NOCOPY VARCHAR2 )
924: IS
925: l_return_status VARCHAR2(10);
926: Weight_Volume_Exp EXCEPTION;

Line 964: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

960: p_entity_type => 'DELIVERY',
961: p_entity_ids => p_delivery_id,
962: x_return_status => l_return_status);
963:
964: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
965: WSH_UTIL_CORE.G_RET_STS_WARNING) )
966: THEN
967: --
968: IF ( l_debug_on ) THEN

Line 965: WSH_UTIL_CORE.G_RET_STS_WARNING) )

961: p_entity_ids => p_delivery_id,
962: x_return_status => l_return_status);
963:
964: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
965: WSH_UTIL_CORE.G_RET_STS_WARNING) )
966: THEN
967: --
968: IF ( l_debug_on ) THEN
969: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required');

Line 1014: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

1010: p_diff_fill_volume => -1 * p_volume(wvCnt),
1011: p_check_for_empty => 'Y',
1012: x_return_status => l_return_status );
1013:
1014: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
1015: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1016: THEN
1017: --
1018: IF l_debug_on THEN

Line 1015: WSH_UTIL_CORE.G_RET_STS_WARNING) )

1011: p_check_for_empty => 'Y',
1012: x_return_status => l_return_status );
1013:
1014: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
1015: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1016: THEN
1017: --
1018: IF l_debug_on THEN
1019: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_WV_UTILS.DD_WV_Post_Process : ' || l_return_status);

Line 1083: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,

1079: -- when p_entity_type is 'DEL-CONT'
1080: -- ===============================================================================
1081: PROCEDURE Adjust_Parent_WV (
1082: p_entity_type IN VARCHAR2,
1083: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1084: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1085: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
1086: p_inventory_item_id IN WSH_UTIL_CORE.Id_Tab_Type,
1087: p_organization_id IN WSH_UTIL_CORE.Id_Tab_Type,

Line 1084: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,

1080: -- ===============================================================================
1081: PROCEDURE Adjust_Parent_WV (
1082: p_entity_type IN VARCHAR2,
1083: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1084: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1085: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
1086: p_inventory_item_id IN WSH_UTIL_CORE.Id_Tab_Type,
1087: p_organization_id IN WSH_UTIL_CORE.Id_Tab_Type,
1088: p_weight_uom IN WSH_UTIL_CORE.Column_Tab_Type,

Line 1085: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,

1081: PROCEDURE Adjust_Parent_WV (
1082: p_entity_type IN VARCHAR2,
1083: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1084: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1085: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
1086: p_inventory_item_id IN WSH_UTIL_CORE.Id_Tab_Type,
1087: p_organization_id IN WSH_UTIL_CORE.Id_Tab_Type,
1088: p_weight_uom IN WSH_UTIL_CORE.Column_Tab_Type,
1089: p_volume_uom IN WSH_UTIL_CORE.Column_Tab_Type,

Line 1086: p_inventory_item_id IN WSH_UTIL_CORE.Id_Tab_Type,

1082: p_entity_type IN VARCHAR2,
1083: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1084: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1085: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
1086: p_inventory_item_id IN WSH_UTIL_CORE.Id_Tab_Type,
1087: p_organization_id IN WSH_UTIL_CORE.Id_Tab_Type,
1088: p_weight_uom IN WSH_UTIL_CORE.Column_Tab_Type,
1089: p_volume_uom IN WSH_UTIL_CORE.Column_Tab_Type,
1090: x_return_status OUT NOCOPY VARCHAR2 )

Line 1087: p_organization_id IN WSH_UTIL_CORE.Id_Tab_Type,

1083: p_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1084: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1085: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
1086: p_inventory_item_id IN WSH_UTIL_CORE.Id_Tab_Type,
1087: p_organization_id IN WSH_UTIL_CORE.Id_Tab_Type,
1088: p_weight_uom IN WSH_UTIL_CORE.Column_Tab_Type,
1089: p_volume_uom IN WSH_UTIL_CORE.Column_Tab_Type,
1090: x_return_status OUT NOCOPY VARCHAR2 )
1091: IS

Line 1088: p_weight_uom IN WSH_UTIL_CORE.Column_Tab_Type,

1084: p_parent_delivery_detail IN WSH_UTIL_CORE.Id_Tab_Type,
1085: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
1086: p_inventory_item_id IN WSH_UTIL_CORE.Id_Tab_Type,
1087: p_organization_id IN WSH_UTIL_CORE.Id_Tab_Type,
1088: p_weight_uom IN WSH_UTIL_CORE.Column_Tab_Type,
1089: p_volume_uom IN WSH_UTIL_CORE.Column_Tab_Type,
1090: x_return_status OUT NOCOPY VARCHAR2 )
1091: IS
1092: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

Line 1089: p_volume_uom IN WSH_UTIL_CORE.Column_Tab_Type,

1085: p_delivery_id IN WSH_UTIL_CORE.Id_Tab_Type,
1086: p_inventory_item_id IN WSH_UTIL_CORE.Id_Tab_Type,
1087: p_organization_id IN WSH_UTIL_CORE.Id_Tab_Type,
1088: p_weight_uom IN WSH_UTIL_CORE.Column_Tab_Type,
1089: p_volume_uom IN WSH_UTIL_CORE.Column_Tab_Type,
1090: x_return_status OUT NOCOPY VARCHAR2 )
1091: IS
1092: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1093: l_return_status VARCHAR2(10);

Line 1155: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

1151: p_organization_id => p_organization_id(wvCnt),
1152: x_param_info => l_param_info,
1153: x_return_status => l_return_status);
1154:
1155: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1156: --
1157: IF ( l_debug_on ) THEN
1158: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
1159: END IF;

Line 1191: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

1187: p_vol_uom_code => p_volume_uom(wvCnt),
1188: p_inv_item_id => p_inventory_item_id(wvCnt),
1189: x_return_status => l_return_status);
1190:
1191: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
1192: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1193: THEN
1194: --
1195: IF l_debug_on THEN

Line 1192: WSH_UTIL_CORE.G_RET_STS_WARNING) )

1188: p_inv_item_id => p_inventory_item_id(wvCnt),
1189: x_return_status => l_return_status);
1190:
1191: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
1192: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1193: THEN
1194: --
1195: IF l_debug_on THEN
1196: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_WV_UTILS.Adjust_Parent_WV : ' || l_return_status);

Line 1285: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1281: WSH_DEBUG_SV.push(l_module_name);
1282: END IF;
1283: --
1284:
1285: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1286:
1287:
1288:
1289: IF ( NOT G_DELIVERY_ID.EXISTS(p_delivery_id) )

Line 1317: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

1313: --
1314:
1315: --
1316:
1317: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
1318: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1319: THEN
1320: --
1321: IF ( l_debug_on ) THEN

Line 1318: WSH_UTIL_CORE.G_RET_STS_WARNING) )

1314:
1315: --
1316:
1317: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
1318: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1319: THEN
1320: --
1321: IF ( l_debug_on ) THEN
1322: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_DELIVERY_AUTOCREATE.Create_Hash : ' || l_return_status);

Line 1350: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1346: WSH_DEBUG_SV.pop(l_module_name);
1347: END IF;
1348: --
1349: WHEN OTHERS THEN
1350: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1351: --
1352: IF ( l_debug_on ) THEN
1353: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Get_Delivery_Hash');
1354: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);

Line 1410: l_org_id_tab WSH_UTIL_CORE.Id_Tab_Type;

1406: where det.ship_to_site_use_id <> wdd.ship_to_site_use_id
1407: and det.delivery_detail_id = asgn.delivery_detail_id
1408: and asgn.delivery_id = wda.delivery_id );
1409:
1410: l_org_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1411: Wms_Exception EXCEPTION;
1412: --
1413: l_debug_on BOOLEAN;
1414: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Check_Wms_Details';

Line 1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1428: WSH_DEBUG_SV.logmsg(l_module_name, 'Party Site Id : ' || p_party_site_id || ', Location Id : ' || p_location_id);
1429: END IF;
1430: --
1431:
1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1433:
1434: OPEN C1;
1435: LOOP
1436: -- { Cursor Loop

Line 1452: WSH_DEBUG_SV.logmsg(l_module_name, 'There exists WMS records in shipping which are assigned to Containers for organization : ' || WSH_UTIL_CORE.Get_Org_Name(l_org_id_tab(orgCnt)) );

1448: IF ( G_WMS_ENABLED(l_org_id_tab(orgCnt)) = 'Y' )
1449: THEN
1450: --
1451: IF ( l_debug_on ) THEN
1452: WSH_DEBUG_SV.logmsg(l_module_name, 'There exists WMS records in shipping which are assigned to Containers for organization : ' || WSH_UTIL_CORE.Get_Org_Name(l_org_id_tab(orgCnt)) );
1453: END IF;
1454: --
1455: CLOSE C1;
1456: RAISE Wms_Exception;

Line 1484: WSH_DEBUG_SV.logmsg(l_module_name, 'There exists WMS records in shipping which are assigned to Containers and Deliveries for organization : ' || WSH_UTIL_CORE.Get_Org_Name(l_org_id_tab(orgCnt)) );

1480: IF ( G_WMS_ENABLED(l_org_id_tab(orgCnt)) = 'Y' )
1481: THEN
1482: --
1483: IF ( l_debug_on ) THEN
1484: WSH_DEBUG_SV.logmsg(l_module_name, 'There exists WMS records in shipping which are assigned to Containers and Deliveries for organization : ' || WSH_UTIL_CORE.Get_Org_Name(l_org_id_tab(orgCnt)) );
1485: END IF;
1486: --
1487: CLOSE C2;
1488: RAISE Wms_Exception;

Line 1505: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1501: END IF;
1502: --
1503: EXCEPTION
1504: WHEN Wms_Exception THEN
1505: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1506: --
1507: IF ( l_debug_on ) THEN
1508: WSH_DEBUG_SV.pop(l_module_name);
1509: END IF;

Line 1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1521: WSH_DEBUG_SV.pop(l_module_name);
1522: END IF;
1523: --
1524: WHEN OTHERS THEN
1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1526: --
1527: IF ( l_debug_on ) THEN
1528: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Check_Wms_Details');
1529: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);

Line 1782: l_delivery_name_tab WSH_UTIL_CORE.Column_Tab_Type;

1778: l_stop_rowid_tab Rowid_Tab_Type;
1779: l_legs_rowid_tab Rowid_Tab_Type;
1780: l_tmp_rowid_tab Rowid_Tab_Type;
1781:
1782: l_delivery_name_tab WSH_UTIL_CORE.Column_Tab_Type;
1783: l_weight_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1784: l_volume_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1785: l_released_status_tab WSH_UTIL_CORE.Column_Tab_Type;
1786:

Line 1783: l_weight_uom_tab WSH_UTIL_CORE.Column_Tab_Type;

1779: l_legs_rowid_tab Rowid_Tab_Type;
1780: l_tmp_rowid_tab Rowid_Tab_Type;
1781:
1782: l_delivery_name_tab WSH_UTIL_CORE.Column_Tab_Type;
1783: l_weight_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1784: l_volume_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1785: l_released_status_tab WSH_UTIL_CORE.Column_Tab_Type;
1786:
1787: l_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1784: l_volume_uom_tab WSH_UTIL_CORE.Column_Tab_Type;

1780: l_tmp_rowid_tab Rowid_Tab_Type;
1781:
1782: l_delivery_name_tab WSH_UTIL_CORE.Column_Tab_Type;
1783: l_weight_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1784: l_volume_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1785: l_released_status_tab WSH_UTIL_CORE.Column_Tab_Type;
1786:
1787: l_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1788: l_parent_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1785: l_released_status_tab WSH_UTIL_CORE.Column_Tab_Type;

1781:
1782: l_delivery_name_tab WSH_UTIL_CORE.Column_Tab_Type;
1783: l_weight_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1784: l_volume_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1785: l_released_status_tab WSH_UTIL_CORE.Column_Tab_Type;
1786:
1787: l_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1788: l_parent_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1789: l_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1787: l_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;

1783: l_weight_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1784: l_volume_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1785: l_released_status_tab WSH_UTIL_CORE.Column_Tab_Type;
1786:
1787: l_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1788: l_parent_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1789: l_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1790: l_delivery_leg_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1791: l_stop_id_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1788: l_parent_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;

1784: l_volume_uom_tab WSH_UTIL_CORE.Column_Tab_Type;
1785: l_released_status_tab WSH_UTIL_CORE.Column_Tab_Type;
1786:
1787: l_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1788: l_parent_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1789: l_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1790: l_delivery_leg_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1791: l_stop_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1792: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1789: l_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;

1785: l_released_status_tab WSH_UTIL_CORE.Column_Tab_Type;
1786:
1787: l_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1788: l_parent_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1789: l_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1790: l_delivery_leg_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1791: l_stop_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1792: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1793: l_net_weight_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1790: l_delivery_leg_id_tab WSH_UTIL_CORE.Id_Tab_Type;

1786:
1787: l_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1788: l_parent_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1789: l_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1790: l_delivery_leg_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1791: l_stop_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1792: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1793: l_net_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1794: l_gross_weight_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1791: l_stop_id_tab WSH_UTIL_CORE.Id_Tab_Type;

1787: l_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1788: l_parent_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1789: l_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1790: l_delivery_leg_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1791: l_stop_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1792: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1793: l_net_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1794: l_gross_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1795: l_volume_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1792: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;

1788: l_parent_del_detail_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1789: l_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1790: l_delivery_leg_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1791: l_stop_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1792: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1793: l_net_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1794: l_gross_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1795: l_volume_tab WSH_UTIL_CORE.Id_Tab_Type;
1796: l_organization_id_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1793: l_net_weight_tab WSH_UTIL_CORE.Id_Tab_Type;

1789: l_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1790: l_delivery_leg_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1791: l_stop_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1792: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1793: l_net_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1794: l_gross_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1795: l_volume_tab WSH_UTIL_CORE.Id_Tab_Type;
1796: l_organization_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1797: l_inventory_item_id_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1794: l_gross_weight_tab WSH_UTIL_CORE.Id_Tab_Type;

1790: l_delivery_leg_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1791: l_stop_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1792: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1793: l_net_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1794: l_gross_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1795: l_volume_tab WSH_UTIL_CORE.Id_Tab_Type;
1796: l_organization_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1797: l_inventory_item_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1798: l_move_order_line_id_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1795: l_volume_tab WSH_UTIL_CORE.Id_Tab_Type;

1791: l_stop_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1792: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1793: l_net_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1794: l_gross_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1795: l_volume_tab WSH_UTIL_CORE.Id_Tab_Type;
1796: l_organization_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1797: l_inventory_item_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1798: l_move_order_line_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1799:

Line 1796: l_organization_id_tab WSH_UTIL_CORE.Id_Tab_Type;

1792: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1793: l_net_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1794: l_gross_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1795: l_volume_tab WSH_UTIL_CORE.Id_Tab_Type;
1796: l_organization_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1797: l_inventory_item_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1798: l_move_order_line_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1799:
1800: --Bug 5606960# Variable(s) added for G-Log changes

Line 1797: l_inventory_item_id_tab WSH_UTIL_CORE.Id_Tab_Type;

1793: l_net_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1794: l_gross_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1795: l_volume_tab WSH_UTIL_CORE.Id_Tab_Type;
1796: l_organization_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1797: l_inventory_item_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1798: l_move_order_line_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1799:
1800: --Bug 5606960# Variable(s) added for G-Log changes
1801: l_delivery_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

Line 1798: l_move_order_line_id_tab WSH_UTIL_CORE.Id_Tab_Type;

1794: l_gross_weight_tab WSH_UTIL_CORE.Id_Tab_Type;
1795: l_volume_tab WSH_UTIL_CORE.Id_Tab_Type;
1796: l_organization_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1797: l_inventory_item_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1798: l_move_order_line_id_tab WSH_UTIL_CORE.Id_Tab_Type;
1799:
1800: --Bug 5606960# Variable(s) added for G-Log changes
1801: l_delivery_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1802: l_hash_string VARCHAR2(100);

Line 1921: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1917: p_online_region_mapping => FALSE,
1918: x_loc_rec => l_loc_rec,
1919: x_return_status => l_return_status );
1920:
1921: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1922: THEN -- { Error Handling
1923: --
1924: IF l_debug_on THEN
1925: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_MAP_LOCATION_REGION_PKG.Transfer_Location : ' || l_return_status);

Line 1935: G_FTE_INSTALLED := WSH_UTIL_CORE.Fte_Is_Installed;

1931:
1932: -- Check whether FTE is Installed
1933: IF ( G_FTE_INSTALLED IS NULL )
1934: THEN
1935: G_FTE_INSTALLED := WSH_UTIL_CORE.Fte_Is_Installed;
1936: END IF;
1937:
1938: -- Check for WMS records
1939: l_return_status := NULL;

Line 1951: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

1947: p_party_site_id => l_to_party_site_id,
1948: p_location_id => l_from_location_id,
1949: x_return_status => l_return_status );
1950:
1951: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1952: THEN
1953: -- { Error Handling
1954: --
1955: IF l_debug_on THEN

Line 2070: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

2066: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont (
2067: p_detail_id => l_del_detail_id_tab(unassignCnt),
2068: x_return_status => l_return_status );
2069:
2070: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
2071: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2072: THEN
2073: --
2074: IF l_debug_on THEN

Line 2071: WSH_UTIL_CORE.G_RET_STS_WARNING) )

2067: p_detail_id => l_del_detail_id_tab(unassignCnt),
2068: x_return_status => l_return_status );
2069:
2070: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
2071: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2072: THEN
2073: --
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.logmsg(l_module_name, 'Unassign_Detail_from_Cont returned error : ' || l_return_status);

Line 2169: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2165: p_delivery_detail_id => l_parent_del_detail_id_tab(ExpCnt),
2166: p_error_message => l_message_text
2167: );
2168:
2169: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2170: THEN
2171: --
2172: IF l_debug_on THEN
2173: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_XC_UTIL.Log_Exception : ' || l_return_status);

Line 2254: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

2250: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_delivery (
2251: p_detail_id => l_del_detail_id_tab(unassignDelCnt),
2252: x_return_status => l_return_status );
2253:
2254: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
2255: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2256: THEN
2257: --
2258: IF l_debug_on THEN

Line 2255: WSH_UTIL_CORE.G_RET_STS_WARNING) )

2251: p_detail_id => l_del_detail_id_tab(unassignDelCnt),
2252: x_return_status => l_return_status );
2253:
2254: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
2255: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2256: THEN
2257: --
2258: IF l_debug_on THEN
2259: WSH_DEBUG_SV.logmsg(l_module_name, 'Unassign_Detail_from_Delivery returned error : ' || l_return_status);

Line 2336: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2332: p_delivery_name => l_delivery_name_tab(ExpCnt),
2333: p_error_message => l_message_text
2334: );
2335:
2336: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2337: THEN
2338: --
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);

Line 2424: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2420: p_delivery_id => TmpDelRec.Delivery_Id,
2421: x_delivery_rec => l_delivery_rec,
2422: x_return_status => l_return_status );
2423:
2424: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2425: THEN
2426: --
2427: IF l_debug_on THEN
2428: WSH_DEBUG_SV.log(l_module_name, 'Error returned from WSH_NEW_DELIVERIES_PVT.Table_To_Record : ' || l_return_status);

Line 2442: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2438: x_hash_string => l_hash_string,
2439: x_hash_value => l_hash_value,
2440: x_return_status => l_return_status );
2441:
2442: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2443: THEN
2444: --
2445: IF l_debug_on THEN
2446: WSH_DEBUG_SV.log(l_module_name, 'Error returned from Get_Delivery_Hash : ' || l_return_status);

Line 2474: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2470: p_rowid => TmpDelRec.Rowid,
2471: p_delivery_info => l_delivery_rec,
2472: x_return_status => l_return_status );
2473:
2474: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2475: THEN
2476: --
2477: IF l_debug_on THEN
2478: WSH_DEBUG_SV.log(l_module_name, 'Error returned from WSH_NEW_DELIVERIES_PVT.Update_Delivery : ' || l_return_status);

Line 2535: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2531: x_return_status => l_return_status,
2532: x_msg_count => l_msg_count,
2533: x_msg_data => l_msg_data );
2534:
2535: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2536: THEN
2537: --
2538: IF l_debug_on THEN
2539: WSH_DEBUG_SV.log(l_module_name, 'Error returned from WSH_DELIVERIES_GRP.Delivery_Action : ' || l_return_status);

Line 2616: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

2612: p_trip_stop_id => l_stop_id_tab(ExpCnt),
2613: p_error_message => l_message_text
2614: );
2615:
2616: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2617: THEN
2618: --
2619: IF l_debug_on THEN
2620: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);