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 779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

775: --
776: -- Debug Statements
777: --
778: IF l_debug_on THEN
779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
780: END IF;
781: --
782: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
783: (

Line 782: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

778: IF l_debug_on THEN
779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
780: END IF;
781: --
782: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
783: (
784: p_sync_tmp_recTbl => l_sync_tmp_wms_recTbl,
785: x_return_status => l_return_status
786: );

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

785: x_return_status => l_return_status
786: );
787: --
788: IF l_debug_on THEN
789: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
790: END IF;
791: --
792: WSH_UTIL_CORE.API_POST_CALL
793: (

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

813: --
814: -- Debug Statements
815: --
816: IF l_debug_on THEN
817: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
818: END IF;
819: --
820: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
821: (

Line 820: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

816: IF l_debug_on THEN
817: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
818: END IF;
819: --
820: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
821: (
822: p_sync_tmp_recTbl => l_sync_tmp_inv_recTbl,
823: x_return_status => l_return_status
824: );

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

824: );
825:
826: --
827: IF l_debug_on THEN
828: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
829: END IF;
830: --
831: WSH_UTIL_CORE.API_POST_CALL
832: (

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

1324: --
1325: -- Debug Statements
1326: --
1327: IF l_debug_on THEN
1328: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1329: END IF;
1330: --
1331: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
1332: (

Line 1331: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

1327: IF l_debug_on THEN
1328: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1329: END IF;
1330: --
1331: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
1332: (
1333: p_sync_tmp_recTbl => l_sync_tmp_wms_recTbl,
1334: x_return_status => l_return_status
1335: );

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

1334: x_return_status => l_return_status
1335: );
1336: --
1337: IF l_debug_on THEN
1338: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
1339: END IF;
1340: --
1341: WSH_UTIL_CORE.API_POST_CALL
1342: (

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

1361: --
1362: -- Debug Statements
1363: --
1364: IF l_debug_on THEN
1365: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1366: END IF;
1367: --
1368: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
1369: (

Line 1368: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

1364: IF l_debug_on THEN
1365: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1366: END IF;
1367: --
1368: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
1369: (
1370: p_sync_tmp_recTbl => l_sync_tmp_inv_recTbl,
1371: x_return_status => l_return_status
1372: );

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

1372: );
1373:
1374: --
1375: IF l_debug_on THEN
1376: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
1377: END IF;
1378: --
1379: WSH_UTIL_CORE.API_POST_CALL
1380: (

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

3510: --
3511: -- Debug Statements
3512: --
3513: IF l_debug_on THEN
3514: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3515: END IF;
3516: --
3517: WSH_WMS_SYNC_TMP_PKG.MERGE
3518: (

Line 3517: WSH_WMS_SYNC_TMP_PKG.MERGE

3513: IF l_debug_on THEN
3514: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3515: END IF;
3516: --
3517: WSH_WMS_SYNC_TMP_PKG.MERGE
3518: (
3519: p_sync_tmp_rec => l_sync_tmp_rec,
3520: x_return_status => x_return_status
3521: );

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

3525: END IF;
3526: --
3527: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3528: IF l_debug_on THEN
3529: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE');
3530: WSH_DEBUG_SV.pop(l_module_name);
3531: END IF;
3532: return;
3533: END IF;