DBA Data[Home] [Help]

APPS.WSH_TP_RELEASE dependencies on WSH_WMS_SYNC_TMP_PKG

Line 393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

389: --
390: -- Debug Statements
391: --
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
394: END IF;
395: --
396: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
397: (

Line 396: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
394: END IF;
395: --
396: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
397: (
398: p_sync_tmp_recTbl => l_sync_tmp_wms_recTbl,
399: x_return_status => l_return_status
400: );

Line 403: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);

399: x_return_status => l_return_status
400: );
401: --
402: IF l_debug_on THEN
403: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
404: END IF;
405: --
406: WSH_UTIL_CORE.API_POST_CALL
407: (

Line 431: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

427: --
428: -- Debug Statements
429: --
430: IF l_debug_on THEN
431: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;
433: --
434: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
435: (

Line 434: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

430: IF l_debug_on THEN
431: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;
433: --
434: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
435: (
436: p_sync_tmp_recTbl => l_sync_tmp_inv_recTbl,
437: x_return_status => l_return_status
438: );

Line 442: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);

438: );
439:
440: --
441: IF l_debug_on THEN
442: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
443: END IF;
444: --
445: WSH_UTIL_CORE.API_POST_CALL
446: (

Line 706: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

702: --
703: -- Debug Statements
704: --
705: IF l_debug_on THEN
706: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
707: END IF;
708: --
709: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
710: (

Line 709: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

705: IF l_debug_on THEN
706: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
707: END IF;
708: --
709: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
710: (
711: p_sync_tmp_recTbl => l_sync_tmp_wms_recTbl,
712: x_return_status => l_return_status
713: );

Line 716: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);

712: x_return_status => l_return_status
713: );
714: --
715: IF l_debug_on THEN
716: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
717: END IF;
718: --
719: WSH_UTIL_CORE.API_POST_CALL
720: (

Line 744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

740: --
741: -- Debug Statements
742: --
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
745: END IF;
746: --
747: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
748: (

Line 747: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
745: END IF;
746: --
747: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
748: (
749: p_sync_tmp_recTbl => l_sync_tmp_inv_recTbl,
750: x_return_status => l_return_status
751: );

Line 755: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);

751: );
752:
753: --
754: IF l_debug_on THEN
755: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
756: END IF;
757: --
758: WSH_UTIL_CORE.API_POST_CALL
759: (

Line 1183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

1179: --
1180: -- Debug Statements
1181: --
1182: IF l_debug_on THEN
1183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1184: END IF;
1185: --
1186: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
1187: (

Line 1186: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

1182: IF l_debug_on THEN
1183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1184: END IF;
1185: --
1186: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
1187: (
1188: p_sync_tmp_recTbl => l_sync_tmp_wms_recTbl,
1189: x_return_status => l_return_status
1190: );

Line 1193: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);

1189: x_return_status => l_return_status
1190: );
1191: --
1192: IF l_debug_on THEN
1193: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
1194: END IF;
1195: --
1196: WSH_UTIL_CORE.API_POST_CALL
1197: (

Line 1220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

1216: --
1217: -- Debug Statements
1218: --
1219: IF l_debug_on THEN
1220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1221: END IF;
1222: --
1223: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
1224: (

Line 1223: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

1219: IF l_debug_on THEN
1220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1221: END IF;
1222: --
1223: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
1224: (
1225: p_sync_tmp_recTbl => l_sync_tmp_inv_recTbl,
1226: x_return_status => l_return_status
1227: );

Line 1231: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);

1227: );
1228:
1229: --
1230: IF l_debug_on THEN
1231: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
1232: END IF;
1233: --
1234: WSH_UTIL_CORE.API_POST_CALL
1235: (

Line 3367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);

3363: --
3364: -- Debug Statements
3365: --
3366: IF l_debug_on THEN
3367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3368: END IF;
3369: --
3370: WSH_WMS_SYNC_TMP_PKG.MERGE
3371: (

Line 3370: WSH_WMS_SYNC_TMP_PKG.MERGE

3366: IF l_debug_on THEN
3367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3368: END IF;
3369: --
3370: WSH_WMS_SYNC_TMP_PKG.MERGE
3371: (
3372: p_sync_tmp_rec => l_sync_tmp_rec,
3373: x_return_status => x_return_status
3374: );

Line 3382: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE');

3378: END IF;
3379: --
3380: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3381: IF l_debug_on THEN
3382: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE');
3383: WSH_DEBUG_SV.pop(l_module_name);
3384: END IF;
3385: return;
3386: END IF;