19: ,p_level NUMBER DEFAULT 4)
20: IS
21: l_debug NUMBER;
22: BEGIN
23: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
24: inv_mobile_helper_functions.tracelog
25: (p_err_msg => p_err_msg
26: ,p_module => 'INV_RCV_RESERVATION_UTIL.'||p_module
27: ,p_level => p_level);
54: l_module_name VARCHAR2(30);
55:
56: BEGIN
57:
58: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
59: l_progress := '10';
60: l_module_name := 'UPDATE_WDD';
61:
62: l_progress := '@@@';
169: l_progress VARCHAR2(10);
170: l_module_name VARCHAR2(30);
171: BEGIN
172:
173: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
174: l_progress := '10';
175: l_module_name := 'SPLIT_WDD';
176: x_return_status := fnd_api.g_ret_sts_success;
177:
308: l_progress VARCHAR2(10);
309: l_module_name VARCHAR2(30);
310: BEGIN
311:
312: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
313: l_progress := '10';
314: l_module_name := 'QUERY_RESERVATION';
315: x_return_status := fnd_api.g_ret_sts_success;
316:
390: l_debug NUMBER;
391: l_progress VARCHAR2(10);
392: l_module_name VARCHAR2(30);
393: BEGIN
394: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
395: l_progress := '10';
396: l_module_name := 'TRANSFER_RESERVATIONS';
397:
398: x_return_status := fnd_api.g_ret_sts_success;
473: l_module_name VARCHAR2(30);
474:
475: BEGIN
476:
477: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
478: l_progress := '10';
479: l_module_name := 'RELIEVE_RESERVATIONS';
480:
481: x_return_status := fnd_api.g_ret_sts_success;
557: l_module_name VARCHAR2(30);
558:
559: BEGIN
560:
561: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
562: l_progress := '10';
563: l_module_name := 'DELETE_RESERVATION';
564:
565: IF NOT wms_install.check_install(l_return_status,
632: l_module_name VARCHAR2(30);
633:
634: BEGIN
635:
636: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
637: l_progress := '10';
638: l_module_name := 'REDUCE_RESERVATION';
639:
640: IF NOT wms_install.check_install(l_return_status,
713: l_module_name VARCHAR2(30);
714:
715: BEGIN
716:
717: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
718: l_progress := '10';
719: l_module_name := 'SET_MOL_WDD_TBL';
720:
721:
824:
825: --{{
826: --********** PROCEDURE maintain_rsv_import_asn *********}}
827:
828: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
829: l_progress := '10';
830: l_module_name := 'maintain_rsv_import_asn';
831: x_return_status := fnd_api.g_ret_sts_success;
832:
1056:
1057: --{{
1058: --********** PROCEDURE maintain_rsv_cancel_asn *********}}
1059:
1060: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1061: l_progress := '10';
1062: l_module_name := 'MAINTAIN_RSV_CANCEL_ASN';
1063: x_return_status := fnd_api.g_ret_sts_success;
1064:
1260:
1261: --{{
1262: --********** PROCEDURE maintain_rsv_receive *********}}
1263:
1264: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1265: l_progress := '10';
1266: l_module_name := 'MAINTAIN_RSV_RECEIVE';
1267: x_return_status := fnd_api.g_ret_sts_success;
1268:
1803:
1804: --{{
1805: --********** PROCEDURE maintain_rsv_deliver *********}}
1806:
1807: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1808: l_progress := '10';
1809: l_module_name := 'MAINTAIN_RSV_DELIVER';
1810: x_return_status := fnd_api.g_ret_sts_success;
1811:
2286: l_module_name VARCHAR2(30);
2287:
2288: BEGIN
2289:
2290: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2291: l_progress := '10';
2292: l_module_name := 'MAINTAIN_RSV_RETURNS';
2293:
2294: --For - Corr, primary_qty will come as a negative number. Take the abs
3071: l_module_name VARCHAR2(30);
3072:
3073: BEGIN
3074:
3075: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3076:
3077: IF (l_debug = 1) THEN
3078: print_debug('Entering split_close_mo_for_ret_corr...',l_module_name,4);
3079: print_debug(' p_cas_mol_tb(1).organization_id => '||p_cas_mol_tb(1).organization_id,l_module_name,4);
3290: l_debug NUMBER;
3291: l_progress VARCHAR2(10);
3292: l_module_name VARCHAR2(30);
3293: BEGIN
3294: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3295:
3296: IF (l_debug = 1) THEN
3297: print_debug('Entering maintain_reservations...',l_module_name,4);
3298: print_debug(' p_cas_mol_tb(1).transaction_type => ' ||p_cas_mol_tb(1).transaction_type,l_module_name,4);