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.14.12020000.4 2013/04/15 06:52:35 raminoch ship $ */
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 3052: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

3048: -------------------------------------------------------------------------------------------------------------------
3049: --START OF DELETE TASK Process
3050:
3051: PROCEDURE debug_print (p_message IN VARCHAR2 ) IS
3052: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
3053: BEGIN
3054: IF (l_debug = 1) THEN
3055: inv_mobile_helper_functions.tracelog (p_err_msg => p_message,
3056: p_module => 'wms_delete_tasks',

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

3293: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
3294: AND msi.inventory_item_id = mmtt.inventory_item_id
3295: AND msi.organization_id = mmtt.organization_id;
3296: BEGIN
3297: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3298: x_return_status := fnd_api.g_ret_sts_success;
3299: SAVEPOINT deltxn;
3300: IF l_debug = 1 THEN
3301: debug_print( 'Cleaning up MMTT, MTLT and MSNT for Txn Temp ID = ' || p_transaction_temp_id);

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

3507: l_debug NUMBER;
3508: l_rsv_detailed_qty NUMBER;
3509: l_rsv_reservation_qty NUMBER;
3510: l_rsv_pri_reservation_qty NUMBER;
3511: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');
3512: exc_not_deleted EXCEPTION;
3513: BEGIN
3514: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3515: x_return_status := fnd_api.g_ret_sts_success;

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

3510: l_rsv_pri_reservation_qty NUMBER;
3511: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');
3512: exc_not_deleted EXCEPTION;
3513: BEGIN
3514: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3515: x_return_status := fnd_api.g_ret_sts_success;
3516: SAVEPOINT delete_details;
3517: IF (l_debug = 1) THEN
3518: debug_print( 'Transaction Temp ID = ' || p_transaction_temp_id);

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

3740: AND released_status = 'S';
3741: BEGIN
3742: SAVEPOINT backorder_source;
3743: x_return_status := fnd_api.g_ret_sts_success;
3744: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3745: l_qty_to_backorder := p_qty_to_backorder;
3746: IF l_qty_to_backorder < 0 THEN
3747: l_qty_to_backorder := 0;
3748: END IF;

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

3891: )
3892: FOR UPDATE NOWAIT;
3893: BEGIN
3894: x_return_status := fnd_api.g_ret_sts_success;
3895: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3896: -- Set savepoint
3897: SAVEPOINT backorder;
3898: IF (l_debug = 1) THEN
3899: debug_print( 'Backordering for MO Line ID = ' || p_line_id);

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

4136: AND mtrh.header_id = mtrl.header_id;
4137: BEGIN
4138: x_return_status := fnd_api.g_ret_sts_success;
4139: l_progress := '110';
4140: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4141: IF (l_debug = 1) THEN
4142: debug_print('IN DELETE_OUTBOUND_TASKS');
4143: debug_print ( 'l_progress: ' || l_progress );
4144: END IF;

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

4516: );
4517: BEGIN
4518: x_return_status := fnd_api.g_ret_sts_success;
4519: l_progress := '210';
4520: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4521: IF (l_debug = 1) THEN
4522: debug_print('IN DELETE_MO_TASKS');
4523: debug_print ( 'delete_mo: l_progress: ' || l_progress );
4524: END IF;

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

4749: orig_dest_loc_id
4750: FROM WMS_OP_PLAN_INSTANCES
4751: WHERE source_task_id = l_transaction_record.parent_line_id;
4752: BEGIN
4753: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4754: x_return_status := fnd_api.g_ret_sts_success;
4755: l_progress := '300';
4756: IF (l_debug = 1) THEN
4757: debug_print('IN DELETE_INBOUND_TASKS');

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

4986: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4987: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4988: BEGIN
4989: x_return_status := fnd_api.g_ret_sts_success;
4990: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4991: l_cc_entry_id := p_task_rec.transaction_number ;
4992: SAVEPOINT delcyc;
4993: SELECT cycle_count_header_id
4994: INTO l_cyc_header_id

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

5102: BEGIN
5103: x_return_status := fnd_api.g_ret_sts_success;
5104: --anjana
5105: x_msg_count := 0;
5106: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5107: l_val_ret_status :='S' ;
5108: l_transaction_number:= p_transaction_number ;
5109: l_task_table := p_wms_task;
5110: IF l_debug = 1 THEN

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

5309:
5310: l_invalid_org EXCEPTION;
5311: l_qry_fail EXCEPTION;
5312:
5313: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5314: l_api_name VARCHAR2(1000) := 'QUERY_TASK';
5315:
5316: v_cycle_count_name varchar2(30) := NULL;
5317:

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

6743: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
6744: -- l_split_uom_quantities qty_changed_tbl_type;
6745: l_procedure_name VARCHAR2(30) := 'SPLIT_TASK';
6746: l_task_tbl_qty_count NUMBER := p_split_quantities.COUNT;
6747: g_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
6748: l_decimal_precision CONSTANT NUMBER := 5;
6749: l_task_tbl_primary_qty NUMBER;
6750: l_task_tbl_transaction_qty NUMBER;
6751: l_sum_tbl_transaction_qty NUMBER := 0;

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

7320: P_msg_data VARCHAR2(30);
7321: l_valid_task_counter NUMBER;
7322: p_temp_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
7323: l_op_plan_rec WMS_TASK_MGMT_PUB.op_plan_rec;
7324: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7325: l_api_name VARCHAR2(1000) := 'MODIFY_TASK';
7326: l_msg VARCHAR2(2000);
7327: l_err_msg VARCHAR2(2000);
7328: l_error_msg VARCHAR2(2000);

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

7813: l_val_ret_status VARCHAR2(10) ;
7814: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
7815: l_transaction_number NUMBER ;
7816: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type;
7817: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7818: l_unprocessed_crossdock_count NUMBER := 1;
7819: l_msg VARCHAR2(2000);
7820:
7821: BEGIN