DBA Data[Home] [Help]

APPS.WSH_LPN_SYNC_COMM_PKG dependencies on FND_API

Line 437: p_init_msg_list => FND_API.G_FALSE,

433: END IF;
434:
435: WMS_Container_GRP.Modify_LPNs (
436: p_api_version => 1.0,
437: p_init_msg_list => FND_API.G_FALSE,
438: p_commit => FND_API.G_FALSE,
439: x_return_status => l_return_status,
440: x_msg_count => l_msg_count,
441: x_msg_data => l_msg_data,

Line 438: p_commit => FND_API.G_FALSE,

434:
435: WMS_Container_GRP.Modify_LPNs (
436: p_api_version => 1.0,
437: p_init_msg_list => FND_API.G_FALSE,
438: p_commit => FND_API.G_FALSE,
439: x_return_status => l_return_status,
440: x_msg_count => l_msg_count,
441: x_msg_data => l_msg_data,
442: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

Line 472: RAISE FND_API.G_EXC_ERROR;

468:
469: wsh_wms_lpn_grp.g_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp + 1/86400;
470:
471: IF l_num_errors > 0 THEN
472: RAISE FND_API.G_EXC_ERROR;
473: ELSIF l_num_warnings > 0 THEN
474: x_return_status := wsh_util_core.g_ret_sts_warning;
475: END IF;
476:

Line 487: WHEN FND_API.G_EXC_ERROR THEN

483: END IF;
484: --
485: EXCEPTION
486: --{
487: WHEN FND_API.G_EXC_ERROR THEN
488: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
489: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
490: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
491: wsh_wms_lpn_grp.g_update_to_containers := 'N';

Line 499: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

495: --
496: -- Debug Statements
497: --
498: IF l_debug_on THEN
499: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
501: END IF;
502: --
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

496: -- Debug Statements
497: --
498: IF l_debug_on THEN
499: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
501: END IF;
502: --
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

499: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
501: END IF;
502: --
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
505: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
506: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
507: wsh_wms_lpn_grp.g_update_to_containers := 'N';

Line 515: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

511: --
512: -- Debug Statements
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
517: END IF;
518: --
519: WHEN OTHERS THEN

Line 516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

512: -- Debug Statements
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
517: END IF;
518: --
519: WHEN OTHERS THEN
520: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 649: p_init_msg_list => FND_API.G_FALSE,

645: END IF;
646:
647: WMS_Container_GRP.Modify_LPNs (
648: p_api_version => 1.0,
649: p_init_msg_list => FND_API.G_FALSE,
650: p_commit => FND_API.G_FALSE,
651: x_return_status => l_return_status,
652: x_msg_count => l_msg_count,
653: x_msg_data => l_msg_data,

Line 650: p_commit => FND_API.G_FALSE,

646:
647: WMS_Container_GRP.Modify_LPNs (
648: p_api_version => 1.0,
649: p_init_msg_list => FND_API.G_FALSE,
650: p_commit => FND_API.G_FALSE,
651: x_return_status => l_return_status,
652: x_msg_count => l_msg_count,
653: x_msg_data => l_msg_data,
654: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

Line 727: p_init_msg_list => FND_API.G_FALSE,

723: END IF;
724:
725: WMS_Container_GRP.Modify_LPNs (
726: p_api_version => 1.0,
727: p_init_msg_list => FND_API.G_FALSE,
728: p_commit => FND_API.G_FALSE,
729: x_return_status => l_return_status,
730: x_msg_count => l_msg_count,
731: x_msg_data => l_msg_data,

Line 728: p_commit => FND_API.G_FALSE,

724:
725: WMS_Container_GRP.Modify_LPNs (
726: p_api_version => 1.0,
727: p_init_msg_list => FND_API.G_FALSE,
728: p_commit => FND_API.G_FALSE,
729: x_return_status => l_return_status,
730: x_msg_count => l_msg_count,
731: x_msg_data => l_msg_data,
732: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

Line 762: RAISE FND_API.G_EXC_ERROR;

758:
759: wsh_wms_lpn_grp.g_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp + 1/86400;
760:
761: IF l_num_errors > 0 THEN
762: RAISE FND_API.G_EXC_ERROR;
763: ELSIF l_num_warnings > 0 THEN
764: x_return_status := wsh_util_core.g_ret_sts_warning;
765: END IF;
766:

Line 777: WHEN FND_API.G_EXC_ERROR THEN

773: END IF;
774: --
775: EXCEPTION
776: --{
777: WHEN FND_API.G_EXC_ERROR THEN
778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
779: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
780: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
781: wsh_wms_lpn_grp.g_update_to_containers := 'N';

Line 789: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

785: --
786: -- Debug Statements
787: --
788: IF l_debug_on THEN
789: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
791: END IF;
792: --
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

786: -- Debug Statements
787: --
788: IF l_debug_on THEN
789: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
791: END IF;
792: --
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

789: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
791: END IF;
792: --
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
795: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
796: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
797: wsh_wms_lpn_grp.g_update_to_containers := 'N';

Line 805: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

801: --
802: -- Debug Statements
803: --
804: IF l_debug_on THEN
805: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
806: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
807: END IF;
808: --
809: WHEN OTHERS THEN

Line 806: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

802: -- Debug Statements
803: --
804: IF l_debug_on THEN
805: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
806: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
807: END IF;
808: --
809: WHEN OTHERS THEN
810: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;