DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_WMS_SYNC_TMP_PKG

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

3184: l_sync_tmp_rec.delivery_id := l_del_id_for_detail.delivery_id;
3185: l_sync_tmp_rec.operation_type := 'PRIOR';
3186: --
3187: IF l_debug_on THEN
3188: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3189: END IF;
3190: --
3191: WSH_WMS_SYNC_TMP_PKG.MERGE
3192: (

Line 3191: WSH_WMS_SYNC_TMP_PKG.MERGE

3187: IF l_debug_on THEN
3188: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3189: END IF;
3190: --
3191: WSH_WMS_SYNC_TMP_PKG.MERGE
3192: (
3193: p_sync_tmp_rec => l_sync_tmp_rec,
3194: x_return_status => l_return_status
3195: );

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

3295: l_sync_tmp_rec.delivery_id := l_del_id_for_detail.delivery_id;
3296: l_sync_tmp_rec.operation_type := 'PRIOR';
3297: --
3298: IF l_debug_on THEN
3299: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3300: END IF;
3301: --
3302: WSH_WMS_SYNC_TMP_PKG.MERGE
3303: (

Line 3302: WSH_WMS_SYNC_TMP_PKG.MERGE

3298: IF l_debug_on THEN
3299: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3300: END IF;
3301: --
3302: WSH_WMS_SYNC_TMP_PKG.MERGE
3303: (
3304: p_sync_tmp_rec => l_sync_tmp_rec,
3305: x_return_status => l_return_status
3306: );

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

3441: THEN
3442: --{
3443: --
3444: IF l_debug_on THEN
3445: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
3446: END IF;
3447: --
3448: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
3449: (

Line 3448: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

3444: IF l_debug_on THEN
3445: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
3446: END IF;
3447: --
3448: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
3449: (
3450: p_sync_tmp_recTbl => l_sync_tmp_recTbl,
3451: x_return_status => l_return_status,
3452: p_operation_type => l_operation_type

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

3845: l_sync_tmp_rec.delivery_id := l_del_rec.delivery_id;
3846: l_sync_tmp_rec.operation_type := 'PRIOR';
3847: --
3848: IF l_debug_on THEN
3849: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3850: END IF;
3851: --
3852: WSH_WMS_SYNC_TMP_PKG.MERGE
3853: (

Line 3852: WSH_WMS_SYNC_TMP_PKG.MERGE

3848: IF l_debug_on THEN
3849: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3850: END IF;
3851: --
3852: WSH_WMS_SYNC_TMP_PKG.MERGE
3853: (
3854: p_sync_tmp_rec => l_sync_tmp_rec,
3855: x_return_status => l_return_status
3856: );

Line 3861: WSH_DEBUG_SV.log(l_module_name,'WSH_WMS_SYNC_TMP_PKG.MERGE returned ',l_return_status);

3857:
3858: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
3859: THEN
3860: IF l_debug_on THEN
3861: WSH_DEBUG_SV.log(l_module_name,'WSH_WMS_SYNC_TMP_PKG.MERGE returned ',l_return_status);
3862: END IF;
3863: RAISE e_abort;
3864: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3865: l_num_warnings := l_num_warnings + 1;

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

4531: l_sync_tmp_rec.delivery_detail_id := l_dd_id(j);
4532: l_sync_tmp_rec.operation_type := 'UPDATE';
4533: --
4534: IF l_debug_on THEN
4535: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4536: END IF;
4537: --
4538: WSH_WMS_SYNC_TMP_PKG.MERGE
4539: (

Line 4538: WSH_WMS_SYNC_TMP_PKG.MERGE

4534: IF l_debug_on THEN
4535: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4536: END IF;
4537: --
4538: WSH_WMS_SYNC_TMP_PKG.MERGE
4539: (
4540: p_sync_tmp_rec => l_sync_tmp_rec,
4541: x_return_status => l_return_status
4542: );

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

4836: l_sync_tmp_rec.delivery_id := l_detail.delivery_id;
4837: l_sync_tmp_rec.operation_type := 'PRIOR';
4838: --
4839: IF l_debug_on THEN
4840: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4841: END IF;
4842: --
4843: WSH_WMS_SYNC_TMP_PKG.MERGE
4844: (

Line 4843: WSH_WMS_SYNC_TMP_PKG.MERGE

4839: IF l_debug_on THEN
4840: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4841: END IF;
4842: --
4843: WSH_WMS_SYNC_TMP_PKG.MERGE
4844: (
4845: p_sync_tmp_rec => l_sync_tmp_rec,
4846: x_return_status => l_return_status
4847: );

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

6166: THEN
6167: --{
6168: --
6169: IF l_debug_on THEN
6170: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
6171: END IF;
6172: --
6173: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
6174: (

Line 6173: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

6169: IF l_debug_on THEN
6170: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
6171: END IF;
6172: --
6173: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
6174: (
6175: p_sync_tmp_recTbl => l_sync_tmp_recTbl,
6176: x_return_status => l_return_status,
6177: p_operation_type => l_operation_type

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

6330: THEN
6331: --{
6332: --
6333: IF l_debug_on THEN
6334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
6335: END IF;
6336: --
6337: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
6338: (

Line 6337: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

6333: IF l_debug_on THEN
6334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
6335: END IF;
6336: --
6337: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
6338: (
6339: p_sync_tmp_recTbl => l_sync_tmp_recTbl,
6340: x_return_status => l_return_status,
6341: p_operation_type => l_operation_type

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

6441: l_sync_tmp_rec.delivery_id := l_del_id_FOR_container1.delivery_id;
6442: l_sync_tmp_rec.operation_type := 'PRIOR';
6443: --
6444: IF l_debug_on THEN
6445: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
6446: END IF;
6447: --
6448: WSH_WMS_SYNC_TMP_PKG.MERGE
6449: (

Line 6448: WSH_WMS_SYNC_TMP_PKG.MERGE

6444: IF l_debug_on THEN
6445: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
6446: END IF;
6447: --
6448: WSH_WMS_SYNC_TMP_PKG.MERGE
6449: (
6450: p_sync_tmp_rec => l_sync_tmp_rec,
6451: x_return_status => l_return_status
6452: );

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

7120: l_sync_tmp_rec.delivery_id := l_del_id_tbl(j);
7121: l_sync_tmp_rec.operation_type := 'PRIOR';
7122: --
7123: IF l_debug_on THEN
7124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
7125: END IF;
7126: --
7127: WSH_WMS_SYNC_TMP_PKG.MERGE
7128: (

Line 7127: WSH_WMS_SYNC_TMP_PKG.MERGE

7123: IF l_debug_on THEN
7124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
7125: END IF;
7126: --
7127: WSH_WMS_SYNC_TMP_PKG.MERGE
7128: (
7129: p_sync_tmp_rec => l_sync_tmp_rec,
7130: x_return_status => l_return_status
7131: );

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

7223: l_sync_tmp_rec.delivery_detail_id := l_dd_id(j);
7224: l_sync_tmp_rec.operation_type := 'UPDATE';
7225: --
7226: IF l_debug_on THEN
7227: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
7228: END IF;
7229: --
7230: WSH_WMS_SYNC_TMP_PKG.MERGE
7231: (

Line 7230: WSH_WMS_SYNC_TMP_PKG.MERGE

7226: IF l_debug_on THEN
7227: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
7228: END IF;
7229: --
7230: WSH_WMS_SYNC_TMP_PKG.MERGE
7231: (
7232: p_sync_tmp_rec => l_sync_tmp_rec,
7233: x_return_status => l_return_status
7234: );

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

7470: l_sync_tmp_rec.delivery_id := l_assign.delivery_id;
7471: l_sync_tmp_rec.operation_type := 'PRIOR';
7472: --
7473: IF l_debug_on THEN
7474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
7475: END IF;
7476: --
7477: WSH_WMS_SYNC_TMP_PKG.MERGE
7478: (

Line 7477: WSH_WMS_SYNC_TMP_PKG.MERGE

7473: IF l_debug_on THEN
7474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
7475: END IF;
7476: --
7477: WSH_WMS_SYNC_TMP_PKG.MERGE
7478: (
7479: p_sync_tmp_rec => l_sync_tmp_rec,
7480: x_return_status => l_return_status
7481: );