eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_MGMT_PUB dependencies on FND_PROFILE

Line 5: g_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);

1: PACKAGE BODY WMS_TASK_MGMT_PUB AS
2: /*$Header: WMSTKMPB.pls 120.13 2008/05/05 07:35:55 pbonthu noship $ */
3: ------------------------------------------------------------------------------------------------------
4: g_pkg_name VARCHAR2(30) := 'WMS_TASK_MGMT_PUB';
5: g_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
6: ------------------------------------------------------------------------------------------------------
7: -- START OF QUERY TASKS
8: PROCEDURE initialize_main_table
9: IS

Line 293: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

289: l_bulk_task VARCHAR2(2);
290: l_temp_del_detail_id NUMBER;
291: l_move_order_line_id NUMBER;
292: l_temp_del_id NUMBER;
293: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
294: l_api_name VARCHAR2(1000) := 'CHECK_CARTONIZATION';
295: l_error_msg VARCHAR2(2000);
296: l_msg_count NUMBER;
297: p_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

Line 554: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

550: l_error_code NUMBER;
551: l_std_task_type NUMBER;
552: l_usr_task_type_id NUMBER;
553: l_err_msg VARCHAR2(240);
554: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
555: l_api_name VARCHAR2(1000) := 'MODIFY_SINGLE_TASK';
556: l_msg VARCHAR2(2000);
557:
558: Cursor c_usr_task_type(p_std_task_type NUMBER,

Line 1262: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1258: l_bulk_task VARCHAR2(2);
1259: l_temp_del_detail_id NUMBER;
1260: l_move_order_line_id NUMBER;
1261: l_temp_del_id NUMBER;
1262: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1263: l_api_name VARCHAR2(1000) := 'CHECK_CARTONIZATION';
1264: l_error_msg VARCHAR2(2000);
1265: l_msg_count NUMBER;
1266: BEGIN

Line 2963: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

2959: -------------------------------------------------------------------------------------------------------------------
2960: --START OF DELETE TASK Process
2961:
2962: PROCEDURE debug_print (p_message IN VARCHAR2 ) IS
2963: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
2964: BEGIN
2965: IF (l_debug = 1) THEN
2966: inv_mobile_helper_functions.tracelog (p_err_msg => p_message,
2967: p_module => 'wms_delete_tasks',

Line 3208: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3204: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
3205: AND msi.inventory_item_id = mmtt.inventory_item_id
3206: AND msi.organization_id = mmtt.organization_id;
3207: BEGIN
3208: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3209: x_return_status := fnd_api.g_ret_sts_success;
3210: SAVEPOINT deltxn;
3211: IF l_debug = 1 THEN
3212: debug_print( 'Cleaning up MMTT, MTLT and MSNT for Txn Temp ID = ' || p_transaction_temp_id);

Line 3422: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');

3418: l_debug NUMBER;
3419: l_rsv_detailed_qty NUMBER;
3420: l_rsv_reservation_qty NUMBER;
3421: l_rsv_pri_reservation_qty NUMBER;
3422: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');
3423: exc_not_deleted EXCEPTION;
3424: BEGIN
3425: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3426: x_return_status := fnd_api.g_ret_sts_success;

Line 3425: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3421: l_rsv_pri_reservation_qty NUMBER;
3422: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');
3423: exc_not_deleted EXCEPTION;
3424: BEGIN
3425: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3426: x_return_status := fnd_api.g_ret_sts_success;
3427: SAVEPOINT delete_details;
3428: IF (l_debug = 1) THEN
3429: debug_print( 'Transaction Temp ID = ' || p_transaction_temp_id);

Line 3655: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3651: AND released_status = 'S';
3652: BEGIN
3653: SAVEPOINT backorder_source;
3654: x_return_status := fnd_api.g_ret_sts_success;
3655: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3656: l_qty_to_backorder := p_qty_to_backorder;
3657: IF l_qty_to_backorder < 0 THEN
3658: l_qty_to_backorder := 0;
3659: END IF;

Line 3806: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3802: )
3803: FOR UPDATE NOWAIT;
3804: BEGIN
3805: x_return_status := fnd_api.g_ret_sts_success;
3806: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3807: -- Set savepoint
3808: SAVEPOINT backorder;
3809: IF (l_debug = 1) THEN
3810: debug_print( 'Backordering for MO Line ID = ' || p_line_id);

Line 4051: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4047: AND mtrh.header_id = mtrl.header_id;
4048: BEGIN
4049: x_return_status := fnd_api.g_ret_sts_success;
4050: l_progress := '110';
4051: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4052: IF (l_debug = 1) THEN
4053: debug_print('IN DELETE_OUTBOUND_TASKS');
4054: debug_print ( 'l_progress: ' || l_progress );
4055: END IF;

Line 4431: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4427: );
4428: BEGIN
4429: x_return_status := fnd_api.g_ret_sts_success;
4430: l_progress := '210';
4431: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4432: IF (l_debug = 1) THEN
4433: debug_print('IN DELETE_MO_TASKS');
4434: debug_print ( 'delete_mo: l_progress: ' || l_progress );
4435: END IF;

Line 4664: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4660: orig_dest_loc_id
4661: FROM WMS_OP_PLAN_INSTANCES
4662: WHERE source_task_id = l_transaction_record.parent_line_id;
4663: BEGIN
4664: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4665: x_return_status := fnd_api.g_ret_sts_success;
4666: l_progress := '300';
4667: IF (l_debug = 1) THEN
4668: debug_print('IN DELETE_INBOUND_TASKS');

Line 4901: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4897: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4898: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4899: BEGIN
4900: x_return_status := fnd_api.g_ret_sts_success;
4901: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4902: l_cc_entry_id := p_task_rec.transaction_number ;
4903: SAVEPOINT delcyc;
4904: SELECT cycle_count_header_id
4905: INTO l_cyc_header_id

Line 5017: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

5013: BEGIN
5014: x_return_status := fnd_api.g_ret_sts_success;
5015: --anjana
5016: x_msg_count := 0;
5017: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5018: l_val_ret_status :='S' ;
5019: l_transaction_number:= p_transaction_number ;
5020: l_task_table := p_wms_task;
5021: IF l_debug = 1 THEN

Line 5224: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

5220:
5221: l_invalid_org EXCEPTION;
5222: l_qry_fail EXCEPTION;
5223:
5224: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5225: l_api_name VARCHAR2(1000) := 'QUERY_TASK';
5226:
5227: v_cycle_count_name varchar2(30) := NULL;
5228:

Line 6652: g_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);

6648: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
6649: -- l_split_uom_quantities qty_changed_tbl_type;
6650: l_procedure_name VARCHAR2(30) := 'SPLIT_TASK';
6651: l_task_tbl_qty_count NUMBER := p_split_quantities.COUNT;
6652: g_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
6653: l_decimal_precision CONSTANT NUMBER := 5;
6654: l_task_tbl_primary_qty NUMBER;
6655: l_task_tbl_transaction_qty NUMBER;
6656: l_sum_tbl_transaction_qty NUMBER := 0;

Line 7225: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

7221: P_msg_data VARCHAR2(30);
7222: l_valid_task_counter NUMBER;
7223: p_temp_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
7224: l_op_plan_rec WMS_TASK_MGMT_PUB.op_plan_rec;
7225: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7226: l_api_name VARCHAR2(1000) := 'MODIFY_TASK';
7227: l_msg VARCHAR2(2000);
7228: l_err_msg VARCHAR2(2000);
7229: l_error_msg VARCHAR2(2000);

Line 7718: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

7714: l_val_ret_status VARCHAR2(10) ;
7715: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
7716: l_transaction_number NUMBER ;
7717: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type;
7718: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7719: l_unprocessed_crossdock_count NUMBER := 1;
7720: l_msg VARCHAR2(2000);
7721:
7722: BEGIN