DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_PUB dependencies on WSH_UTIL_CORE

Line 228: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

224: --{
225: FND_MSG_PUB.initialize;
226: --}
227: END IF;
228: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
229: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
230:
231: l_rule_id := p_rule_id;
232: l_rule_name := p_rule_name;

Line 229: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

225: FND_MSG_PUB.initialize;
226: --}
227: END IF;
228: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
229: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
230:
231: l_rule_id := p_rule_id;
232: l_rule_name := p_rule_name;
233: l_batch_rec := p_batch_rec;

Line 261: wsh_util_core.api_post_call(

257: (p_criterion_id => l_batch_rec.crossdock_criteria_id,
258: p_criterion_name => l_batch_rec.crossdock_criteria_name,
259: x_return_status => l_return_status);
260:
261: wsh_util_core.api_post_call(
262: p_return_status => l_return_status,
263: x_num_warnings => l_number_of_warnings,
264: x_num_errors => l_number_of_errors,
265: p_msg_data => l_msg_data

Line 280: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

276: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,
277: WSH_PICK_LIST.C_PRIORITIZE_INVENTORY) THEN
278: ROLLBACK TO PICKING_BATCH_PUB;
279: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_COMBINATION');
280: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
281: wsh_util_core.add_message(x_return_status);
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.pop(l_module_name);
284: END IF;

Line 281: wsh_util_core.add_message(x_return_status);

277: WSH_PICK_LIST.C_PRIORITIZE_INVENTORY) THEN
278: ROLLBACK TO PICKING_BATCH_PUB;
279: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_COMBINATION');
280: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
281: wsh_util_core.add_message(x_return_status);
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.pop(l_module_name);
284: END IF;
285: --

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

302: x_batch_id => l_batch_id);
303:
304: IF l_debug_on THEN
305: --{
306: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
307: --}
308: END IF;
309: --
310:

Line 311: wsh_util_core.api_post_call(

307: --}
308: END IF;
309: --
310:
311: wsh_util_core.api_post_call(
312: p_return_status => l_return_status,
313: x_num_warnings => l_number_of_warnings,
314: x_num_errors => l_number_of_errors,
315: p_msg_data => l_msg_data

Line 322: x_return_status := wsh_util_core.g_ret_sts_warning;

318: x_batch_id := l_batch_id;
319:
320: IF l_number_of_warnings > 0 THEN
321: --{
322: x_return_status := wsh_util_core.g_ret_sts_warning;
323: --}
324: END IF;
325:
326:

Line 352: wsh_util_core.add_message(x_return_status);

348: EXCEPTION
349: WHEN FND_API.G_EXC_ERROR THEN
350: ROLLBACK TO PICKING_BATCH_PUB;
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: wsh_util_core.add_message(x_return_status);
353: FND_MSG_PUB.Count_And_Get
354: (
355: p_count => x_msg_count,
356: p_data => x_msg_data,

Line 371: wsh_util_core.add_message(x_return_status, l_module_name);

367:
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO PICKING_BATCH_PUB;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371: wsh_util_core.add_message(x_return_status, l_module_name);
372: FND_MSG_PUB.Count_And_Get
373: (
374: p_count => x_msg_count,
375: p_data => x_msg_data,

Line 388: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');

384: --}
385: END IF;
386: WHEN OTHERS THEN
387: ROLLBACK TO PICKING_BATCH_PUB;
388: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
390: FND_MSG_PUB.Count_And_Get
391: (
392: p_count => x_msg_count,

Line 389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

385: END IF;
386: WHEN OTHERS THEN
387: ROLLBACK TO PICKING_BATCH_PUB;
388: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
390: FND_MSG_PUB.Count_And_Get
391: (
392: p_count => x_msg_count,
393: p_data => x_msg_data,

Line 524: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

520: FND_MSG_PUB.initialize;
521: --}
522: END IF;
523:
524: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
525: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
526:
527: l_batch_id := p_batch_id;
528: l_batch_name := p_batch_name;

Line 525: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

521: --}
522: END IF;
523:
524: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
525: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
526:
527: l_batch_id := p_batch_id;
528: l_batch_name := p_batch_name;
529: l_release_mode := p_release_mode;

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

559: x_request_id => l_request_id);
560:
561: IF l_debug_on THEN
562: --{
563: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
564: --}
565: END IF;
566: --
567:

Line 568: wsh_util_core.api_post_call(

564: --}
565: END IF;
566: --
567:
568: wsh_util_core.api_post_call(
569: p_return_status => l_return_status,
570: x_num_warnings => l_number_of_warnings,
571: x_num_errors => l_number_of_errors,
572: p_msg_data => l_msg_data

Line 579: x_return_status := wsh_util_core.g_ret_sts_warning;

575: x_request_id := l_request_id;
576:
577: IF l_number_of_warnings > 0 THEN
578: --{
579: x_return_status := wsh_util_core.g_ret_sts_warning;
580: --}
581: END IF;
582:
583:

Line 606: wsh_util_core.add_message(x_return_status);

602: --
603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN
605: x_return_status := FND_API.G_RET_STS_ERROR ;
606: wsh_util_core.add_message(x_return_status);
607: FND_MSG_PUB.Count_And_Get
608: (
609: p_count => x_msg_count,
610: p_data => x_msg_data,

Line 624: wsh_util_core.add_message(x_return_status, l_module_name);

620: --
621:
622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
624: wsh_util_core.add_message(x_return_status, l_module_name);
625: FND_MSG_PUB.Count_And_Get
626: (
627: p_count => x_msg_count,
628: p_data => x_msg_data,

Line 640: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.RELEASE_BATCH');

636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
637: --}
638: END IF;
639: WHEN OTHERS THEN
640: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.RELEASE_BATCH');
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get
643: (
644: p_count => x_msg_count,

Line 641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

637: --}
638: END IF;
639: WHEN OTHERS THEN
640: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.RELEASE_BATCH');
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get
643: (
644: p_count => x_msg_count,
645: p_data => x_msg_data,

Line 851: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

847: FND_MSG_PUB.initialize;
848: --}
849: END IF;
850:
851: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
852: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
853:
854: l_batch_id := p_batch_id;
855: l_batch_name := p_batch_name;

Line 852: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

848: --}
849: END IF;
850:
851: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
852: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
853:
854: l_batch_id := p_batch_id;
855: l_batch_name := p_batch_name;
856:

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

875: x_return_status => l_return_status);
876:
877: IF l_debug_on THEN
878: --{
879: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
880: --}
881: END IF;
882: --
883: wsh_util_core.api_post_call(

Line 883: wsh_util_core.api_post_call(

879: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
880: --}
881: END IF;
882: --
883: wsh_util_core.api_post_call(
884: p_return_status => l_return_status,
885: x_num_warnings => l_number_of_warnings,
886: x_num_errors => l_number_of_errors,
887: p_msg_data => l_msg_data

Line 896: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

892: --
893: --
894: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
895: FND_MESSAGE.SET_TOKEN('FIELD_NAME ',' BATCH_ID OR BATCH_NAME ');
896: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
897: wsh_util_core.add_message(x_return_status);
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.pop(l_module_name);
900: END IF;

Line 897: wsh_util_core.add_message(x_return_status);

893: --
894: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
895: FND_MESSAGE.SET_TOKEN('FIELD_NAME ',' BATCH_ID OR BATCH_NAME ');
896: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
897: wsh_util_core.add_message(x_return_status);
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.pop(l_module_name);
900: END IF;
901: --

Line 1026: wsh_util_core.add_message(x_return_status);

1022: IF c_batch_info%ISOPEN THEN
1023: CLOSE c_batch_info;
1024: END IF;
1025: x_return_status := FND_API.G_RET_STS_ERROR ;
1026: wsh_util_core.add_message(x_return_status);
1027: FND_MSG_PUB.Count_And_Get
1028: (
1029: p_count => x_msg_count,
1030: p_data => x_msg_data,

Line 1047: wsh_util_core.add_message(x_return_status, l_module_name);

1043: IF c_batch_info%ISOPEN THEN
1044: CLOSE c_batch_info;
1045: END IF;
1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1047: wsh_util_core.add_message(x_return_status, l_module_name);
1048: FND_MSG_PUB.Count_And_Get
1049: (
1050: p_count => x_msg_count,
1051: p_data => x_msg_data,

Line 1067: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.GET_BATCH_RECORD');

1063: WHEN OTHERS THEN
1064: IF c_batch_info%ISOPEN THEN
1065: CLOSE c_batch_info;
1066: END IF;
1067: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.GET_BATCH_RECORD');
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1069: FND_MSG_PUB.Count_And_Get
1070: (
1071: p_count => x_msg_count,

Line 1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1064: IF c_batch_info%ISOPEN THEN
1065: CLOSE c_batch_info;
1066: END IF;
1067: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.GET_BATCH_RECORD');
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1069: FND_MSG_PUB.Count_And_Get
1070: (
1071: p_count => x_msg_count,
1072: p_data => x_msg_data,