DBA Data[Home] [Help]

APPS.WSH_LPN_SYNC_COMM_PKG dependencies on FND_API

Line 430: p_init_msg_list => FND_API.G_FALSE,

426: END IF;
427:
428: WMS_Container_GRP.Modify_LPNs (
429: p_api_version => 1.0,
430: p_init_msg_list => FND_API.G_FALSE,
431: p_commit => FND_API.G_FALSE,
432: x_return_status => l_return_status,
433: x_msg_count => l_msg_count,
434: x_msg_data => l_msg_data,

Line 431: p_commit => FND_API.G_FALSE,

427:
428: WMS_Container_GRP.Modify_LPNs (
429: p_api_version => 1.0,
430: p_init_msg_list => FND_API.G_FALSE,
431: p_commit => FND_API.G_FALSE,
432: x_return_status => l_return_status,
433: x_msg_count => l_msg_count,
434: x_msg_data => l_msg_data,
435: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

Line 465: RAISE FND_API.G_EXC_ERROR;

461:
462: wsh_wms_lpn_grp.g_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp + 1/86400;
463:
464: IF l_num_errors > 0 THEN
465: RAISE FND_API.G_EXC_ERROR;
466: ELSIF l_num_warnings > 0 THEN
467: x_return_status := wsh_util_core.g_ret_sts_warning;
468: END IF;
469:

Line 480: WHEN FND_API.G_EXC_ERROR THEN

476: END IF;
477: --
478: EXCEPTION
479: --{
480: WHEN FND_API.G_EXC_ERROR THEN
481: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
482: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
483: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
484: wsh_wms_lpn_grp.g_update_to_containers := 'N';

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

488: --
489: -- Debug Statements
490: --
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
493: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
494: END IF;
495: --
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

489: -- Debug Statements
490: --
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
493: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
494: END IF;
495: --
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

492: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
493: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
494: END IF;
495: --
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
498: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
499: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
500: wsh_wms_lpn_grp.g_update_to_containers := 'N';

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

504: --
505: -- Debug Statements
506: --
507: IF l_debug_on THEN
508: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
510: END IF;
511: --
512: WHEN OTHERS THEN

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

505: -- Debug Statements
506: --
507: IF l_debug_on THEN
508: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
510: END IF;
511: --
512: WHEN OTHERS THEN
513: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 642: p_init_msg_list => FND_API.G_FALSE,

638: END IF;
639:
640: WMS_Container_GRP.Modify_LPNs (
641: p_api_version => 1.0,
642: p_init_msg_list => FND_API.G_FALSE,
643: p_commit => FND_API.G_FALSE,
644: x_return_status => l_return_status,
645: x_msg_count => l_msg_count,
646: x_msg_data => l_msg_data,

Line 643: p_commit => FND_API.G_FALSE,

639:
640: WMS_Container_GRP.Modify_LPNs (
641: p_api_version => 1.0,
642: p_init_msg_list => FND_API.G_FALSE,
643: p_commit => FND_API.G_FALSE,
644: x_return_status => l_return_status,
645: x_msg_count => l_msg_count,
646: x_msg_data => l_msg_data,
647: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

Line 720: p_init_msg_list => FND_API.G_FALSE,

716: END IF;
717:
718: WMS_Container_GRP.Modify_LPNs (
719: p_api_version => 1.0,
720: p_init_msg_list => FND_API.G_FALSE,
721: p_commit => FND_API.G_FALSE,
722: x_return_status => l_return_status,
723: x_msg_count => l_msg_count,
724: x_msg_data => l_msg_data,

Line 721: p_commit => FND_API.G_FALSE,

717:
718: WMS_Container_GRP.Modify_LPNs (
719: p_api_version => 1.0,
720: p_init_msg_list => FND_API.G_FALSE,
721: p_commit => FND_API.G_FALSE,
722: x_return_status => l_return_status,
723: x_msg_count => l_msg_count,
724: x_msg_data => l_msg_data,
725: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

Line 755: RAISE FND_API.G_EXC_ERROR;

751:
752: wsh_wms_lpn_grp.g_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp + 1/86400;
753:
754: IF l_num_errors > 0 THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSIF l_num_warnings > 0 THEN
757: x_return_status := wsh_util_core.g_ret_sts_warning;
758: END IF;
759:

Line 770: WHEN FND_API.G_EXC_ERROR THEN

766: END IF;
767: --
768: EXCEPTION
769: --{
770: WHEN FND_API.G_EXC_ERROR THEN
771: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
772: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
773: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
774: wsh_wms_lpn_grp.g_update_to_containers := 'N';

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

778: --
779: -- Debug Statements
780: --
781: IF l_debug_on THEN
782: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
783: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
784: END IF;
785: --
786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

779: -- Debug Statements
780: --
781: IF l_debug_on THEN
782: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
783: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
784: END IF;
785: --
786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
787: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

782: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
783: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
784: END IF;
785: --
786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
787: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
788: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
789: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
790: wsh_wms_lpn_grp.g_update_to_containers := 'N';

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

794: --
795: -- Debug Statements
796: --
797: IF l_debug_on THEN
798: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
799: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
800: END IF;
801: --
802: WHEN OTHERS THEN

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

795: -- Debug Statements
796: --
797: IF l_debug_on THEN
798: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
799: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
800: END IF;
801: --
802: WHEN OTHERS THEN
803: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;