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

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

130:
131: IF l_in_param_null THEN
132: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
133: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_param_name);
134: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
135: RAISE FND_API.G_EXC_ERROR;
136: END IF;
137: --
138: IF p_IN_rec.caller not like 'WMS%' THEN

Line 172: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

168: EXCEPTION
169: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
170: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');
171: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_delivery_detail_id);
172: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
173: RAISE FND_API.G_EXC_ERROR;
174: END;
175:
176: UPDATE wsh_delivery_details

Line 185: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

181:
182: IF SQL%ROWCOUNT <> 1 THEN
183: FND_MESSAGE.SET_NAME('WSH','WSH_LPN_UPDATE_FAILED'); --bms new
184: FND_MESSAGE.SET_TOKEN('LPNID',p_detail_info_tab(i).lpn_id);
185: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188: i := p_detail_info_tab.NEXT(i);
189: END LOOP; --}

Line 206: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

202: wsh_debug_sv.logmsg(l_module_name,'lpn_id cannot be null');
203: END IF;
204: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
205: FND_MESSAGE.SET_TOKEN('FIELD_NAME','LPN_ID');
206: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: BEGIN

Line 227: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

223: wsh_debug_sv.log(l_module_name,'There are no records in wsh_delivery_details for lpn_id: ', p_detail_info_tab(i).lpn_id);
224: END IF;
225:
226: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DETAIL'); --bmso new message
227: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
228: RAISE FND_API.G_EXC_ERROR;
229: END;
230: IF p_IN_rec.caller <> WSH_GLBL_VAR_STRCT_GRP.c_skip_miss_info THEN
231:

Line 248: wsh_util_core.api_post_call(

244: handle_miss_info( p_container_info_rec => p_detail_info_tab(i),
245: x_return_status => l_return_status
246: );
247:
248: wsh_util_core.api_post_call(
249: p_return_status => l_return_status,
250: x_num_warnings => l_num_warnings,
251: x_num_errors => l_num_errors);
252: END IF;

Line 278: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

274: CLOSE c_lpn_exist;
275:
276: IF l_dummy = 1 THEN
277: FND_MESSAGE.SET_NAME('WSH','WSH_DUPLICATE_RECORD');
278: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:
282: i := p_detail_info_tab.NEXT(i);

Line 296: wsh_util_core.api_post_call(

292: p_detail_info_tab => p_detail_info_tab,
293: p_IN_rec => p_in_rec,
294: x_OUT_rec => x_out_rec
295: );
296: wsh_util_core.api_post_call(
297: p_return_status => l_return_status,
298: x_num_warnings => l_num_warnings,
299: x_num_errors => l_num_errors,
300: p_msg_data => l_msg_data);

Line 308: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);

304: p_IN_rec.action_code);
305: END IF;
306: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
307: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_IN_rec.action_code);
308: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF; --}
311:
312: IF l_num_errors > 0

Line 314: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

310: END IF; --}
311:
312: IF l_num_errors > 0
313: THEN
314: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
315: ELSIF l_num_warnings > 0
316: THEN
317: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
318: ELSE

Line 317: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

313: THEN
314: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
315: ELSIF l_num_warnings > 0
316: THEN
317: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
318: ELSE
319: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
320: END IF;
321:

Line 319: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

315: ELSIF l_num_warnings > 0
316: THEN
317: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
318: ELSE
319: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
320: END IF;
321:
322: G_CALLBACK_REQUIRED := 'Y';
323: g_caller := NULL;

Line 345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

341: WHEN e_success THEN
342: G_CALLBACK_REQUIRED := 'Y';
343: g_caller := NULL;
344: --g_update_to_container := 'N';
345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
346: FND_MSG_PUB.Count_And_Get
347: (
348: p_count => x_msg_count,
349: p_data => x_msg_data,

Line 362: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

358: G_CALLBACK_REQUIRED := 'Y';
359: g_caller := NULL;
360: --g_update_to_container := 'N';
361: ROLLBACK TO create_update_WSHWLGPB;
362: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
363: FND_MSG_PUB.Count_And_Get
364: (
365: p_count => x_msg_count,
366: p_data => x_msg_data,

Line 380: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

376: G_CALLBACK_REQUIRED := 'Y';
377: g_caller := NULL;
378: --g_update_to_container := 'N';
379: ROLLBACK TO create_update_WSHWLGPB;
380: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
381:
382: FND_MSG_PUB.Count_And_Get
383: (
384: p_count => x_msg_count,

Line 395: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
393: END IF;
394: --
395: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
396: G_CALLBACK_REQUIRED := 'Y';
397: g_caller := NULL;
398: --g_update_to_container := 'N';
399: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 399: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

395: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
396: G_CALLBACK_REQUIRED := 'Y';
397: g_caller := NULL;
398: --g_update_to_container := 'N';
399: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
400: --
401: FND_MSG_PUB.Count_And_Get
402: (
403: p_count => x_msg_count,

Line 410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

406: );
407:
408: --
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
412: END IF;
413: --
414: WHEN OTHERS THEN

Line 411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

407:
408: --
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
412: END IF;
413: --
414: WHEN OTHERS THEN
415: G_CALLBACK_REQUIRED := 'Y';

Line 419: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

415: G_CALLBACK_REQUIRED := 'Y';
416: g_caller := NULL;
417: --g_update_to_container := 'N';
418: ROLLBACK TO create_update_WSHWLGPB;
419: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
420: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.create_update_containers');
421: FND_MSG_PUB.Count_And_Get
422: (
423: p_count => x_msg_count,

Line 420: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.create_update_containers');

416: g_caller := NULL;
417: --g_update_to_container := 'N';
418: ROLLBACK TO create_update_WSHWLGPB;
419: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
420: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.create_update_containers');
421: FND_MSG_PUB.Count_And_Get
422: (
423: p_count => x_msg_count,
424: p_data => x_msg_data,

Line 473: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

469: THEN
470: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
471: END IF;
472: --
473: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
474: IF l_debug_on THEN
475: --
476: wsh_debug_sv.push (l_module_name);
477: --

Line 685: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

681: --
682: EXCEPTION
683:
684: WHEN OTHERS THEN
685: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
686: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.Handle_miss_info');
687: --
688: IF l_debug_on THEN
689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 686: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.Handle_miss_info');

682: EXCEPTION
683:
684: WHEN OTHERS THEN
685: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
686: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.Handle_miss_info');
687: --
688: IF l_debug_on THEN
689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
690: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 730: p_lpn_id_tbl IN wsh_util_core.id_tab_type,

726: p_commit IN VARCHAR2,
727: x_return_status OUT NOCOPY VARCHAR2,
728: x_msg_count OUT NOCOPY NUMBER,
729: x_msg_data OUT NOCOPY VARCHAR2,
730: p_lpn_id_tbl IN wsh_util_core.id_tab_type,
731: p_del_det_id_tbl IN wsh_util_core.id_tab_type,
732: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
733: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type,
734: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type

Line 731: p_del_det_id_tbl IN wsh_util_core.id_tab_type,

727: x_return_status OUT NOCOPY VARCHAR2,
728: x_msg_count OUT NOCOPY NUMBER,
729: x_msg_data OUT NOCOPY VARCHAR2,
730: p_lpn_id_tbl IN wsh_util_core.id_tab_type,
731: p_del_det_id_tbl IN wsh_util_core.id_tab_type,
732: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
733: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type,
734: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
735: )

Line 808: l_del_det_id_tbl wsh_util_core.id_tab_type;

804: --LPN Reuse project
805: and wdd.released_status = 'X';
806:
807: l_delivery_id NUMBER;
808: l_del_det_id_tbl wsh_util_core.id_tab_type;
809: l_lpn_exists VARCHAR2(1);
810: l_call_for_update_flag BOOLEAN := FALSE;
811: l_calc_fill_pc_flag BOOLEAN := FALSE;
812: l_update_sub_loc_flag BOOLEAN := FALSE;

Line 878: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

874: WSH_DEBUG_SV.log(l_module_name,'Count of lpn_id tbl is',p_lpn_id_tbl.count);
875: WSH_DEBUG_SV.log(l_module_name,'Count of delivery_detail_id tbl is',p_del_det_id_tbl.count);
876: END IF;
877: --
878: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
879:
880: --
881: IF NOT FND_API.COMPATIBLE_API_CALL
882: ( l_api_version_number,

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

903:
904: IF l_raise_error_flag THEN
905: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
906: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_param_name);
907: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910:
911: IF NOT (p_action_prms.caller like 'WMS%') THEN

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

914:
915: IF p_action_prms.action_code NOT IN ('PACK', 'UNPACK', 'ASSIGN', 'UNASSIGN', 'DELETE') THEN
916: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
917: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_prms.action_code);
918: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921:
922: IF (g_call_group_api = 'N') THEN

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

972: --
973: -- Debug Statements
974: --
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
977: END IF;
978: --
979: wsh_util_core.api_post_call(
980: p_return_status => l_return_status,

Line 979: wsh_util_core.api_post_call(

975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
977: END IF;
978: --
979: wsh_util_core.api_post_call(
980: p_return_status => l_return_status,
981: x_num_warnings => l_num_warnings,
982: x_num_errors => l_num_errors,
983: p_msg_data => l_msg_data

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

1162: --
1163: -- Debug Statements
1164: --
1165: IF l_debug_on THEN
1166: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1167: END IF;
1168: --
1169: wsh_util_core.api_post_call(
1170: p_return_status => l_return_status,

Line 1169: wsh_util_core.api_post_call(

1165: IF l_debug_on THEN
1166: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1167: END IF;
1168: --
1169: wsh_util_core.api_post_call(
1170: p_return_status => l_return_status,
1171: x_num_warnings => l_num_warnings,
1172: x_num_errors => l_num_errors,
1173: p_msg_data => l_msg_data

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

1207: --
1208: -- Debug Statements
1209: --
1210: IF l_debug_on THEN
1211: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1212: END IF;
1213: --
1214: wsh_util_core.api_post_call(
1215: p_return_status => l_return_status,

Line 1214: wsh_util_core.api_post_call(

1210: IF l_debug_on THEN
1211: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1212: END IF;
1213: --
1214: wsh_util_core.api_post_call(
1215: p_return_status => l_return_status,
1216: x_num_warnings => l_num_warnings,
1217: x_num_errors => l_num_errors,
1218: p_msg_data => l_msg_data

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

1243: --
1244: -- Debug Statements
1245: --
1246: IF l_debug_on THEN
1247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1248: END IF;
1249: --
1250: wsh_util_core.api_post_call(
1251: p_return_status => l_return_status,

Line 1250: wsh_util_core.api_post_call(

1246: IF l_debug_on THEN
1247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1248: END IF;
1249: --
1250: wsh_util_core.api_post_call(
1251: p_return_status => l_return_status,
1252: x_num_warnings => l_num_warnings,
1253: x_num_errors => l_num_errors
1254: );

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

1281: --
1282: -- Debug Statements
1283: --
1284: IF l_debug_on THEN
1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1286: END IF;
1287: --
1288: wsh_util_core.api_post_call(
1289: p_return_status => l_return_status,

Line 1288: wsh_util_core.api_post_call(

1284: IF l_debug_on THEN
1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1286: END IF;
1287: --
1288: wsh_util_core.api_post_call(
1289: p_return_status => l_return_status,
1290: x_num_warnings => l_num_warnings,
1291: x_num_errors => l_num_errors
1292: );

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

1313: --
1314: -- Debug Statements
1315: --
1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1318: END IF;
1319: --
1320: wsh_util_core.api_post_call(
1321: p_return_status => l_return_status,

Line 1320: wsh_util_core.api_post_call(

1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1318: END IF;
1319: --
1320: wsh_util_core.api_post_call(
1321: p_return_status => l_return_status,
1322: x_num_warnings => l_num_warnings,
1323: x_num_errors => l_num_errors
1324: );

Line 1330: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);

1326: IF (l_fill_status = 'O') THEN
1327: --{
1328: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_OVERPACKED');
1329: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_action_prms.lpn_rec.container_name);
1330: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
1331: l_num_warnings := l_num_warnings + 1;
1332: --}
1333: ELSIF (l_fill_status = 'U') THEN
1334: --{

Line 1337: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);

1333: ELSIF (l_fill_status = 'U') THEN
1334: --{
1335: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_OVERPACKED');
1336: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_action_prms.lpn_rec.container_name);
1337: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
1338: l_num_warnings := l_num_warnings + 1;
1339: --}
1340: END IF;
1341: --

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

1362: --
1363: -- Debug Statements
1364: --
1365: IF l_debug_on THEN
1366: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1367: END IF;
1368: --
1369: wsh_util_core.api_post_call(
1370: p_return_status => l_return_status,

Line 1369: wsh_util_core.api_post_call(

1365: IF l_debug_on THEN
1366: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1367: END IF;
1368: --
1369: wsh_util_core.api_post_call(
1370: p_return_status => l_return_status,
1371: x_num_warnings => l_num_warnings,
1372: x_num_errors => l_num_errors);
1373:

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

1397: --
1398: -- Debug Statements
1399: --
1400: IF l_debug_on THEN
1401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1402: END IF;
1403: --
1404: WSH_UTIL_CORE.API_POST_CALL
1405: (

Line 1404: WSH_UTIL_CORE.API_POST_CALL

1400: IF l_debug_on THEN
1401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1402: END IF;
1403: --
1404: WSH_UTIL_CORE.API_POST_CALL
1405: (
1406: p_return_status => l_return_status,
1407: x_num_warnings => l_num_warnings,
1408: x_num_errors => l_num_errors

Line 1417: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

1413:
1414: IF l_num_errors > 0 THEN
1415: RAISE FND_API.G_EXC_ERROR;
1416: ELSIF l_num_warnings > 0 THEN
1417: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1418: ELSE
1419: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1420: END IF;
1421:

Line 1419: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1415: RAISE FND_API.G_EXC_ERROR;
1416: ELSIF l_num_warnings > 0 THEN
1417: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1418: ELSE
1419: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1420: END IF;
1421:
1422:
1423: IF FND_API.To_Boolean( p_commit ) THEN

Line 1434: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1430: p_encoded => FND_API.G_FALSE);
1431:
1432: --
1433: --
1434: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1435: --
1436: --}
1437: --
1438: -- Debug Statements

Line 1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1445: --{
1446: WHEN FND_API.G_EXC_ERROR THEN
1447: ROLLBACK TO DEL_DETAIL_ACTION_WMS_GRP;
1448: g_callback_required := 'N';
1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1450: FND_MSG_PUB.Count_And_Get
1451: (
1452: p_count => x_msg_count,
1453: p_data => x_msg_data,

Line 1467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1463: END IF;
1464: --
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: ROLLBACK TO DEL_DETAIL_ACTION_WMS_GRP;
1467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1468:
1469: FND_MSG_PUB.Count_And_Get
1470: (
1471: p_count => x_msg_count,

Line 1484: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

1480: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1481: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1482: END IF;
1483: --
1484: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1485: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1486: --
1487: IF l_debug_on THEN
1488: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1485: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1481: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1482: END IF;
1483: --
1484: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1485: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1486: --
1487: IF l_debug_on THEN
1488: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1489: END IF;

Line 1488: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1484: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1485: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1486: --
1487: IF l_debug_on THEN
1488: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1489: END IF;
1490: --
1491: IF (g_callback_required = 'Y') THEN
1492: --{

Line 1508: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

1504: x_out_rec => l_lpn_out_sync_comm_rec
1505: );
1506: --
1507: --
1508: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1509: WSH_UTIL_CORE.G_RET_STS_ERROR)
1510: )
1511: THEN
1512: x_return_status := l_return_status;

Line 1509: WSH_UTIL_CORE.G_RET_STS_ERROR)

1505: );
1506: --
1507: --
1508: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1509: WSH_UTIL_CORE.G_RET_STS_ERROR)
1510: )
1511: THEN
1512: x_return_status := l_return_status;
1513: END IF;

Line 1529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

1525: --
1526: -- Debug Statements
1527: --
1528: IF l_debug_on THEN
1529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1530: END IF;
1531: --
1532: WHEN OTHERS THEN
1533: ROLLBACK TO DEL_DETAIL_ACTION_WMS_GRP;

Line 1535: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1531: --
1532: WHEN OTHERS THEN
1533: ROLLBACK TO DEL_DETAIL_ACTION_WMS_GRP;
1534: g_callback_required := 'N';
1535: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1536: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');
1537: --
1538: --}
1539: --

Line 1536: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');

1532: WHEN OTHERS THEN
1533: ROLLBACK TO DEL_DETAIL_ACTION_WMS_GRP;
1534: g_callback_required := 'N';
1535: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1536: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');
1537: --
1538: --}
1539: --
1540: -- Debug Statements

Line 1703: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1699: END IF;
1700:
1701: END IF; --}
1702:
1703: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1704:
1705: FND_MSG_PUB.Count_And_Get (
1706: p_count => x_msg_count,
1707: p_data => x_msg_data,

Line 1719: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1715:
1716: WHEN OTHERS THEN
1717: ROLLBACK TO check_purge_WSHWLGPB;
1718: --p_lpn_rec.lpn_ids.DELETE;
1719: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1720: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.check_purge');
1721: FND_MSG_PUB.Count_And_Get
1722: (
1723: p_count => x_msg_count,

Line 1720: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.check_purge');

1716: WHEN OTHERS THEN
1717: ROLLBACK TO check_purge_WSHWLGPB;
1718: --p_lpn_rec.lpn_ids.DELETE;
1719: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1720: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.check_purge');
1721: FND_MSG_PUB.Count_And_Get
1722: (
1723: p_count => x_msg_count,
1724: p_data => x_msg_data,

Line 1754: p_input_delivery_id_tab IN WSH_UTIL_CORE.id_tab_type,

1750: -- This procedure is called from WMS.
1751: --
1752: --========================================================================
1753: PROCEDURE is_valid_consol( p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1754: p_input_delivery_id_tab IN WSH_UTIL_CORE.id_tab_type,
1755: p_target_consol_delivery_id IN NUMBER,
1756: p_caller IN VARCHAR2 DEFAULT NULL,
1757: x_deconsolidation_location OUT NOCOPY NUMBER,
1758: x_return_status OUT NOCOPY VARCHAR2,

Line 1818: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1814: --
1815:
1816:
1817:
1818: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1819:
1820: -- 1. Check if the deliveries are not on diff. pickup trips
1821: -- and diff. consol deliveries.
1822:

Line 1898: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

1894: x_msg_count => x_msg_count,
1895: x_msg_data => x_msg_data
1896: );
1897:
1898: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1899: RAISE WSH_INVALID_DECONSOL_POINT;
1900: END IF;
1901:
1902: IF l_debug_on THEN

Line 1909: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1905:
1906: EXCEPTION
1907:
1908: WHEN WSH_INVALID_PARENT THEN
1909: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1910: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_PARENT');
1911: WSH_UTIL_CORE.Add_Message(x_return_status);
1912: --
1913: -- Debug Statements

Line 1911: WSH_UTIL_CORE.Add_Message(x_return_status);

1907:
1908: WHEN WSH_INVALID_PARENT THEN
1909: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1910: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_PARENT');
1911: WSH_UTIL_CORE.Add_Message(x_return_status);
1912: --
1913: -- Debug Statements
1914: --
1915: IF l_debug_on THEN

Line 1922: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1918: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_PARENT');
1919: END IF;
1920: --
1921: WHEN WSH_INVALID_TRIP THEN
1922: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1923: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TRIP');
1924: WSH_UTIL_CORE.Add_Message(x_return_status);
1925: --
1926: -- Debug Statements

Line 1924: WSH_UTIL_CORE.Add_Message(x_return_status);

1920: --
1921: WHEN WSH_INVALID_TRIP THEN
1922: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1923: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TRIP');
1924: WSH_UTIL_CORE.Add_Message(x_return_status);
1925: --
1926: -- Debug Statements
1927: --
1928: IF l_debug_on THEN

Line 1935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1931: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_TRIP');
1932: END IF;
1933:
1934: WHEN WSH_INVALID_DECONSOL_POINT THEN
1935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1936: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DECONSOL_POINT');
1937: WSH_UTIL_CORE.Add_Message(x_return_status);
1938: --
1939: -- Debug Statements

Line 1937: WSH_UTIL_CORE.Add_Message(x_return_status);

1933:
1934: WHEN WSH_INVALID_DECONSOL_POINT THEN
1935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1936: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DECONSOL_POINT');
1937: WSH_UTIL_CORE.Add_Message(x_return_status);
1938: --
1939: -- Debug Statements
1940: --
1941: IF l_debug_on THEN

Line 1948: wsh_util_core.default_handler('wsh_new_delivery_actions.Unassign_Dels_from_Consol_Del',l_module_name);

1944: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DECONSOL_POINT');
1945: END IF;
1946:
1947: WHEN OTHERS THEN
1948: wsh_util_core.default_handler('wsh_new_delivery_actions.Unassign_Dels_from_Consol_Del',l_module_name);
1949: --
1950: IF l_debug_on THEN
1951: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
1952: END IF;