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_RULE_PVT dependencies on INV_LOG_UTIL

Line 921: inv_log_util.TRACE(p_message, 'RULE_ENGINE', 4);

917: -- Procedure to log message for Label Printing
918: -- =============================================
919: PROCEDURE TRACE(p_message IN VARCHAR2) IS
920: BEGIN
921: inv_log_util.TRACE(p_message, 'RULE_ENGINE', 4);
922: END TRACE;
923:
924: --Procedures for logging messages
925: PROCEDURE log_event(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS

Line 929: inv_log_util.trace(p_message, l_module, 9);

925: PROCEDURE log_event(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
926: l_module VARCHAR2(255);
927: BEGIN
928: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
929: inv_log_util.trace(p_message, l_module, 9);
930: /* fnd_log.STRING(log_level => fnd_log.level_event, module => l_module, message => p_message);
931: inv_log_util.trace(p_message, l_module, 9);
932: gmi_reservation_util.println(p_message); */
933: END log_event;

Line 931: inv_log_util.trace(p_message, l_module, 9);

927: BEGIN
928: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
929: inv_log_util.trace(p_message, l_module, 9);
930: /* fnd_log.STRING(log_level => fnd_log.level_event, module => l_module, message => p_message);
931: inv_log_util.trace(p_message, l_module, 9);
932: gmi_reservation_util.println(p_message); */
933: END log_event;
934:
935: PROCEDURE log_error(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS

Line 939: inv_log_util.trace(p_message, l_module, 9); /*

935: PROCEDURE log_error(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
936: l_module VARCHAR2(255);
937: BEGIN
938: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
939: inv_log_util.trace(p_message, l_module, 9); /*
940: fnd_log.STRING(log_level => fnd_log.level_error, module => l_module, message => p_message);
941: inv_log_util.trace(p_message, l_module, 9);
942: gmi_reservation_util.println(p_message); */
943: END log_error;

Line 941: inv_log_util.trace(p_message, l_module, 9);

937: BEGIN
938: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
939: inv_log_util.trace(p_message, l_module, 9); /*
940: fnd_log.STRING(log_level => fnd_log.level_error, module => l_module, message => p_message);
941: inv_log_util.trace(p_message, l_module, 9);
942: gmi_reservation_util.println(p_message); */
943: END log_error;
944:
945: PROCEDURE log_error_msg(p_api_name VARCHAR2, p_label VARCHAR2) IS

Line 949: inv_log_util.trace('err:', l_module, 9); /*

945: PROCEDURE log_error_msg(p_api_name VARCHAR2, p_label VARCHAR2) IS
946: l_module VARCHAR2(255);
947: BEGIN
948: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
949: inv_log_util.trace('err:', l_module, 9); /*
950: fnd_log.message(log_level => fnd_log.level_error, module => l_module, pop_message => FALSE);
951: inv_log_util.trace('err:', l_module, 9);
952: gmi_reservation_util.println(p_label); */
953: END log_error_msg;

Line 951: inv_log_util.trace('err:', l_module, 9);

947: BEGIN
948: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
949: inv_log_util.trace('err:', l_module, 9); /*
950: fnd_log.message(log_level => fnd_log.level_error, module => l_module, pop_message => FALSE);
951: inv_log_util.trace('err:', l_module, 9);
952: gmi_reservation_util.println(p_label); */
953: END log_error_msg;
954:
955: PROCEDURE log_procedure(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS

Line 959: inv_log_util.trace(p_message, l_module, 9);/*

955: PROCEDURE log_procedure(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
956: l_module VARCHAR2(255);
957: BEGIN
958: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
959: inv_log_util.trace(p_message, l_module, 9);/*
960: fnd_log.STRING(log_level => fnd_log.level_procedure, module => l_module, message => p_message);
961: inv_log_util.trace(p_message, l_module, 9);
962: gmi_reservation_util.println(p_message); */
963: END log_procedure;

Line 961: inv_log_util.trace(p_message, l_module, 9);

957: BEGIN
958: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
959: inv_log_util.trace(p_message, l_module, 9);/*
960: fnd_log.STRING(log_level => fnd_log.level_procedure, module => l_module, message => p_message);
961: inv_log_util.trace(p_message, l_module, 9);
962: gmi_reservation_util.println(p_message); */
963: END log_procedure;
964:
965: PROCEDURE log_statement(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS

Line 969: inv_log_util.trace(p_message, l_module, 9);/*

965: PROCEDURE log_statement(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
966: l_module VARCHAR2(255);
967: BEGIN
968: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
969: inv_log_util.trace(p_message, l_module, 9);/*
970: fnd_log.STRING(log_level => fnd_log.level_statement, module => l_module, message => p_message);
971: inv_log_util.trace(p_message, l_module, 9);
972: gmi_reservation_util.println(p_label||' '||p_message);*/
973: END log_statement;

Line 971: inv_log_util.trace(p_message, l_module, 9);

967: BEGIN
968: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
969: inv_log_util.trace(p_message, l_module, 9);/*
970: fnd_log.STRING(log_level => fnd_log.level_statement, module => l_module, message => p_message);
971: inv_log_util.trace(p_message, l_module, 9);
972: gmi_reservation_util.println(p_label||' '||p_message);*/
973: END log_statement;
974: ----
975: ---- Function to check if Restriction , Sort-criteria and Consistency was defined for a given picking rule

Line 4883: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);

4879:
4880: BEGIN
4881:
4882: IF(l_debug=1) THEN
4883: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);
4884: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
4885: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
4886: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
4887: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);

Line 4884: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);

4880: BEGIN
4881:
4882: IF(l_debug=1) THEN
4883: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);
4884: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
4885: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
4886: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
4887: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
4888: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);

Line 4885: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);

4881:
4882: IF(l_debug=1) THEN
4883: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);
4884: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
4885: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
4886: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
4887: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
4888: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);
4889: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);

Line 4886: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);

4882: IF(l_debug=1) THEN
4883: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);
4884: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
4885: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
4886: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
4887: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
4888: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);
4889: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);
4890: END IF;

Line 4887: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);

4883: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);
4884: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
4885: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
4886: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
4887: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
4888: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);
4889: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);
4890: END IF;
4891:

Line 4888: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);

4884: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
4885: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
4886: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
4887: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
4888: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);
4889: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);
4890: END IF;
4891:
4892: IF p_lpn_id IS NOT NULL THEN

Line 4889: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);

4885: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
4886: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
4887: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
4888: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);
4889: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);
4890: END IF;
4891:
4892: IF p_lpn_id IS NOT NULL THEN
4893: -- LPN level

Line 4906: inv_log_util.trace('Total MOQ quantity LPN Level: ' || to_char(l_moq_qty), 'GET_AVAIL_QTY_FOR_XFER', 9);

4902: AND moq.locator_id = p_locator_id
4903: AND moq.lpn_id = p_lpn_id;
4904:
4905: IF(l_debug=1) THEN
4906: inv_log_util.trace('Total MOQ quantity LPN Level: ' || to_char(l_moq_qty), 'GET_AVAIL_QTY_FOR_XFER', 9);
4907: END IF;
4908:
4909: SELECT SUM(Decode(mmtt.transaction_status, 2, 1,
4910: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,

Line 4930: inv_log_util.trace('Total MMTT Trx quantity Source Org Sub : ' || to_char(l_mmtt_qty_src), 'GET_AVAIL_QTY_FOR_XFER', 9);

4926: )
4927: AND mmtt.transaction_action_id NOT IN (5,6,24,30);
4928:
4929: IF(l_debug=1) THEN
4930: inv_log_util.trace('Total MMTT Trx quantity Source Org Sub : ' || to_char(l_mmtt_qty_src), 'GET_AVAIL_QTY_FOR_XFER', 9);
4931: END IF;
4932:
4933: SELECT SUM(Abs(mmtt.primary_quantity))
4934: INTO l_mmtt_qty_dest

Line 4949: inv_log_util.trace('Total MMTT Trx quantity Dest Org Sub : ' || to_char(l_mmtt_qty_dest), 'GET_AVAIL_QTY_FOR_XFER', 9);

4945: AND mmtt.transaction_action_id in (2,28,3)
4946: AND mmtt.wip_supply_type IS NULL;
4947:
4948: IF(l_debug=1) THEN
4949: inv_log_util.trace('Total MMTT Trx quantity Dest Org Sub : ' || to_char(l_mmtt_qty_dest), 'GET_AVAIL_QTY_FOR_XFER', 9);
4950: END IF;
4951:
4952: l_lpn_qoh := nvl(l_moq_qty,0);
4953: l_lpn_att := nvl(l_moq_qty,0) + nvl(l_mmtt_qty_src,0) + nvl(l_mmtt_qty_dest,0);

Line 4981: inv_log_util.trace('Total MMTT Trx quantity Source Org Sub : ' || to_char(l_mmtt_qty_src), 'GET_AVAIL_QTY_FOR_XFER', 9);

4977: )
4978: AND mmtt.transaction_action_id NOT IN (5,6,24,30);
4979:
4980: IF(l_debug=1) THEN
4981: inv_log_util.trace('Total MMTT Trx quantity Source Org Sub : ' || to_char(l_mmtt_qty_src), 'GET_AVAIL_QTY_FOR_XFER', 9);
4982: END IF;
4983:
4984: SELECT SUM(moq.primary_transaction_quantity)
4985: INTO l_moq_qty

Line 4995: inv_log_util.trace('Total MOQ quantity LPN Level: ' || to_char(l_moq_qty), 'GET_AVAIL_QTY_FOR_XFER', 9);

4991: AND decode(p_lot_number,null,'@@',moq.lot_number) = nvl(p_lot_number,'@@')
4992: AND moq.locator_id = p_locator_id;
4993:
4994: IF(l_debug=1) THEN
4995: inv_log_util.trace('Total MOQ quantity LPN Level: ' || to_char(l_moq_qty), 'GET_AVAIL_QTY_FOR_XFER', 9);
4996: END IF;
4997:
4998: SELECT SUM(Decode(mmtt.transaction_status, 2, 1,
4999: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,

Line 5035: inv_log_util.trace('Total quantity on-hand: ' || to_char(l_qoh), 'GET_AVAIL_QTY_FOR_XFER', 9);

5031: END IF;
5032: END IF;
5033:
5034: IF(l_debug=1) THEN
5035: inv_log_util.trace('Total quantity on-hand: ' || to_char(l_qoh), 'GET_AVAIL_QTY_FOR_XFER', 9);
5036: END IF;
5037: END GET_AVAIL_QTY_FOR_XFER;
5038:
5039:

Line 10650: inv_log_util.trace('Serial not found', 'delete_serial_numbers', 9);

10646: LOOP
10647: FETCH l_get_serial INTO l_serial_number;
10648: IF l_get_serial%NOTFOUND THEN
10649: IF l_debug = 1 THEN
10650: inv_log_util.trace('Serial not found', 'delete_serial_numbers', 9);
10651: END IF;
10652: exit;
10653: ELSE
10654: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN

Line 10656: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);

10652: exit;
10653: ELSE
10654: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN
10655: IF l_debug = 1 THEN
10656: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
10657: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
10658: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
10659: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10660: END IF;

Line 10657: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);

10653: ELSE
10654: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN
10655: IF l_debug = 1 THEN
10656: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
10657: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
10658: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
10659: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10660: END IF;
10661:

Line 10658: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);

10654: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN
10655: IF l_debug = 1 THEN
10656: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
10657: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
10658: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
10659: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10660: END IF;
10661:
10662: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP

Line 10659: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);

10655: IF l_debug = 1 THEN
10656: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
10657: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
10658: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
10659: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10660: END IF;
10661:
10662: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP
10663: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id) AND

Line 10675: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);

10671:
10672: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
10673: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
10674: IF l_debug = 1 THEN
10675: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10676: END IF;
10677:
10678: ELSE
10679: inv_detail_util_pvt.g_output_serial_rows.delete;

Line 10682: inv_log_util.trace('Array cleared', 'delete_serial_numbers', 9);

10678: ELSE
10679: inv_detail_util_pvt.g_output_serial_rows.delete;
10680: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
10681: IF l_debug = 1 THEN
10682: inv_log_util.trace('Array cleared', 'delete_serial_numbers', 9);
10683: END IF;
10684:
10685: END IF;--End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1)
10686: exit; --if a serial has been deleted, needn't check other serials present in g_output_serial_rows

Line 12368: inv_log_util.trace( l_package_length ,'l_package_length' , 9);

12364: l_cur_start := 1;
12365: -- get last filled row of table
12366: l_row := g_build_package_row;
12367: l_package_length := LENGTH(p_package_string);
12368: inv_log_util.trace( l_package_length ,'l_package_length' , 9);
12369: inv_log_util.trace( p_package_string ,'p_package_string' , 9);
12370: -- return if string is null
12371: IF l_package_length IS NULL
12372: OR l_package_length = 0 THEN

Line 12369: inv_log_util.trace( p_package_string ,'p_package_string' , 9);

12365: -- get last filled row of table
12366: l_row := g_build_package_row;
12367: l_package_length := LENGTH(p_package_string);
12368: inv_log_util.trace( l_package_length ,'l_package_length' , 9);
12369: inv_log_util.trace( p_package_string ,'p_package_string' , 9);
12370: -- return if string is null
12371: IF l_package_length IS NULL
12372: OR l_package_length = 0 THEN
12373: RETURN;

Line 14367: --inv_log_util.TRACE('found the rule', 'RULE_ENGINE', 4);

14363: LOOP -- loop through the rules
14364: FETCH c_rules INTO l_rule_id, l_type_hdr_id, l_organization_id, l_wms_task_type;
14365: EXIT WHEN c_rules%NOTFOUND;
14366:
14367: --inv_log_util.TRACE('found the rule', 'RULE_ENGINE', 4);
14368:
14369: BEGIN
14370: -- get the pre-generated package name for this rule
14371: getpackagename(l_rule_id, l_package_name);

Line 14441: --inv_log_util.TRACE('NOT found the rule: g_current_organization_id'||g_current_organization_id, 'RULE_ENGINE', 4);

14437: when others then
14438: null;
14439: end;
14440:
14441: --inv_log_util.TRACE('NOT found the rule: g_current_organization_id'||g_current_organization_id, 'RULE_ENGINE', 4);
14442: --inv_log_util.TRACE('NOT found the rule: l_organization_id:'||l_organization_id, 'RULE_ENGINE', 4);
14443: IF NVL(g_current_organization_id, -1) <> l_organization_id THEN
14444: g_current_organization_id := l_organization_id;
14445:

Line 14442: --inv_log_util.TRACE('NOT found the rule: l_organization_id:'||l_organization_id, 'RULE_ENGINE', 4);

14438: null;
14439: end;
14440:
14441: --inv_log_util.TRACE('NOT found the rule: g_current_organization_id'||g_current_organization_id, 'RULE_ENGINE', 4);
14442: --inv_log_util.TRACE('NOT found the rule: l_organization_id:'||l_organization_id, 'RULE_ENGINE', 4);
14443: IF NVL(g_current_organization_id, -1) <> l_organization_id THEN
14444: g_current_organization_id := l_organization_id;
14445:
14446:

Line 14470: --inv_log_util.TRACE('default_task_type not found', 'RULE_ENGINE', 4);

14466: g_default_repl_task_type_id := NULL;
14467: g_default_moxfer_task_type_id := NULL;
14468: g_default_moissue_task_type_id := NULL;
14469: g_default_operation_plan_id := NULL;
14470: --inv_log_util.TRACE('default_task_type not found', 'RULE_ENGINE', 4);
14471: END IF;
14472:
14473: CLOSE c_default_task_type;
14474: END IF;

Line 14476: --inv_log_util.TRACE('inside cursor c_defualt_task_type', 'RULE_ENGINE', 4);

14472:
14473: CLOSE c_default_task_type;
14474: END IF;
14475:
14476: --inv_log_util.TRACE('inside cursor c_defualt_task_type', 'RULE_ENGINE', 4);
14477:
14478:
14479: IF l_wms_task_type = 1 THEN
14480: l_task_type_id := g_default_pick_task_type_id;

Line 14495: --inv_log_util.TRACE('wms_task_type = 1, task_type_id=:' || l_task_type_id, 'RULE_ENGINE', 4);

14491: ELSE
14492: l_task_type_id := NULL;
14493: END IF;
14494:
14495: --inv_log_util.TRACE('wms_task_type = 1, task_type_id=:' || l_task_type_id, 'RULE_ENGINE', 4);
14496: --inv_log_util.TRACE('before update statement', 'RULE_ENGINE', 4);
14497:
14498: UPDATE mtl_material_transactions_temp mmtt
14499: SET mmtt.standard_operation_id = l_task_type_id

Line 14496: --inv_log_util.TRACE('before update statement', 'RULE_ENGINE', 4);

14492: l_task_type_id := NULL;
14493: END IF;
14494:
14495: --inv_log_util.TRACE('wms_task_type = 1, task_type_id=:' || l_task_type_id, 'RULE_ENGINE', 4);
14496: --inv_log_util.TRACE('before update statement', 'RULE_ENGINE', 4);
14497:
14498: UPDATE mtl_material_transactions_temp mmtt
14499: SET mmtt.standard_operation_id = l_task_type_id
14500: WHERE mmtt.transaction_temp_id = p_task_id;

Line 14502: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);

14498: UPDATE mtl_material_transactions_temp mmtt
14499: SET mmtt.standard_operation_id = l_task_type_id
14500: WHERE mmtt.transaction_temp_id = p_task_id;
14501:
14502: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);
14503: END IF;
14504:
14505: -- Standard check of p_commit
14506: IF fnd_api.to_boolean(p_commit) THEN