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 965: inv_log_util.TRACE(p_message, 'RULE_ENGINE', 4);

961: -- Procedure to log message for Label Printing
962: -- =============================================
963: PROCEDURE TRACE(p_message IN VARCHAR2) IS
964: BEGIN
965: inv_log_util.TRACE(p_message, 'RULE_ENGINE', 4);
966: END TRACE;
967:
968: --Procedures for logging messages
969: PROCEDURE log_event(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS

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

969: PROCEDURE log_event(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
970: l_module VARCHAR2(255);
971: BEGIN
972: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
973: inv_log_util.trace(p_message, l_module, 9);
974: /* fnd_log.STRING(log_level => fnd_log.level_event, module => l_module, message => p_message);
975: inv_log_util.trace(p_message, l_module, 9);
976: gmi_reservation_util.println(p_message); */
977: END log_event;

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

971: BEGIN
972: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
973: inv_log_util.trace(p_message, l_module, 9);
974: /* fnd_log.STRING(log_level => fnd_log.level_event, module => l_module, message => p_message);
975: inv_log_util.trace(p_message, l_module, 9);
976: gmi_reservation_util.println(p_message); */
977: END log_event;
978:
979: PROCEDURE log_error(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS

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

979: PROCEDURE log_error(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
980: l_module VARCHAR2(255);
981: BEGIN
982: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
983: inv_log_util.trace(p_message, l_module, 9); /*
984: fnd_log.STRING(log_level => fnd_log.level_error, module => l_module, message => p_message);
985: inv_log_util.trace(p_message, l_module, 9);
986: gmi_reservation_util.println(p_message); */
987: END log_error;

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

981: BEGIN
982: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
983: inv_log_util.trace(p_message, l_module, 9); /*
984: fnd_log.STRING(log_level => fnd_log.level_error, module => l_module, message => p_message);
985: inv_log_util.trace(p_message, l_module, 9);
986: gmi_reservation_util.println(p_message); */
987: END log_error;
988:
989: PROCEDURE log_error_msg(p_api_name VARCHAR2, p_label VARCHAR2) IS

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

989: PROCEDURE log_error_msg(p_api_name VARCHAR2, p_label VARCHAR2) IS
990: l_module VARCHAR2(255);
991: BEGIN
992: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
993: inv_log_util.trace('err:', l_module, 9); /*
994: fnd_log.message(log_level => fnd_log.level_error, module => l_module, pop_message => FALSE);
995: inv_log_util.trace('err:', l_module, 9);
996: gmi_reservation_util.println(p_label); */
997: END log_error_msg;

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

991: BEGIN
992: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
993: inv_log_util.trace('err:', l_module, 9); /*
994: fnd_log.message(log_level => fnd_log.level_error, module => l_module, pop_message => FALSE);
995: inv_log_util.trace('err:', l_module, 9);
996: gmi_reservation_util.println(p_label); */
997: END log_error_msg;
998:
999: PROCEDURE log_procedure(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS

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

999: PROCEDURE log_procedure(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
1000: l_module VARCHAR2(255);
1001: BEGIN
1002: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
1003: inv_log_util.trace(p_message, l_module, 9);/*
1004: fnd_log.STRING(log_level => fnd_log.level_procedure, module => l_module, message => p_message);
1005: inv_log_util.trace(p_message, l_module, 9);
1006: gmi_reservation_util.println(p_message); */
1007: END log_procedure;

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

1001: BEGIN
1002: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
1003: inv_log_util.trace(p_message, l_module, 9);/*
1004: fnd_log.STRING(log_level => fnd_log.level_procedure, module => l_module, message => p_message);
1005: inv_log_util.trace(p_message, l_module, 9);
1006: gmi_reservation_util.println(p_message); */
1007: END log_procedure;
1008:
1009: PROCEDURE log_statement(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS

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

1009: PROCEDURE log_statement(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
1010: l_module VARCHAR2(255);
1011: BEGIN
1012: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
1013: inv_log_util.trace(p_message, l_module, 9);/*
1014: fnd_log.STRING(log_level => fnd_log.level_statement, module => l_module, message => p_message);
1015: inv_log_util.trace(p_message, l_module, 9);
1016: gmi_reservation_util.println(p_label||' '||p_message);*/
1017: END log_statement;

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

1011: BEGIN
1012: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
1013: inv_log_util.trace(p_message, l_module, 9);/*
1014: fnd_log.STRING(log_level => fnd_log.level_statement, module => l_module, message => p_message);
1015: inv_log_util.trace(p_message, l_module, 9);
1016: gmi_reservation_util.println(p_label||' '||p_message);*/
1017: END log_statement;
1018:
1019: -- Start 1 of Bug 13026723

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

6610:
6611: BEGIN
6612:
6613: IF(l_debug=1) THEN
6614: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);
6615: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
6616: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
6617: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
6618: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);

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

6611: BEGIN
6612:
6613: IF(l_debug=1) THEN
6614: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);
6615: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
6616: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
6617: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
6618: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
6619: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);

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

6612:
6613: IF(l_debug=1) THEN
6614: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);
6615: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
6616: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
6617: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
6618: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
6619: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);
6620: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);

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

6613: IF(l_debug=1) THEN
6614: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);
6615: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
6616: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
6617: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
6618: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
6619: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);
6620: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);
6621: END IF;

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

6614: inv_log_util.trace('Inside :GET_AVAIL_QTY_FOR_XFER ' , 'Start', 9);
6615: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
6616: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
6617: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
6618: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
6619: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);
6620: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);
6621: END IF;
6622:

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

6615: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_organization_id :'||p_organization_id, 9);
6616: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
6617: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
6618: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
6619: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);
6620: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);
6621: END IF;
6622:
6623: IF p_lpn_id IS NOT NULL THEN

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

6616: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_inventory_item_id :'||p_inventory_item_id, 9);
6617: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_revision :'||p_revision, 9);
6618: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_subinventory_code :'||p_subinventory_code, 9);
6619: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lot_number :'||p_lot_number, 9);
6620: inv_log_util.trace('GET_AVAIL_QTY_FOR_XFER ' , 'p_lpn_id :'||p_lpn_id, 9);
6621: END IF;
6622:
6623: IF p_lpn_id IS NOT NULL THEN
6624: -- LPN level

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

6633: AND moq.locator_id = p_locator_id
6634: AND moq.lpn_id = p_lpn_id;
6635:
6636: IF(l_debug=1) THEN
6637: inv_log_util.trace('Total MOQ quantity LPN Level: ' || to_char(l_moq_qty), 'GET_AVAIL_QTY_FOR_XFER', 9);
6638: END IF;
6639:
6640: SELECT SUM(Decode(mmtt.transaction_status, 2, 1,
6641: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,

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

6657: )
6658: AND mmtt.transaction_action_id NOT IN (5,6,24,30);
6659:
6660: IF(l_debug=1) THEN
6661: inv_log_util.trace('Total MMTT Trx quantity Source Org Sub : ' || to_char(l_mmtt_qty_src), 'GET_AVAIL_QTY_FOR_XFER', 9);
6662: END IF;
6663:
6664: SELECT SUM(Abs(mmtt.primary_quantity))
6665: INTO l_mmtt_qty_dest

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

6676: AND mmtt.transaction_action_id in (2,28,3)
6677: AND mmtt.wip_supply_type IS NULL;
6678:
6679: IF(l_debug=1) THEN
6680: inv_log_util.trace('Total MMTT Trx quantity Dest Org Sub : ' || to_char(l_mmtt_qty_dest), 'GET_AVAIL_QTY_FOR_XFER', 9);
6681: END IF;
6682:
6683: l_lpn_qoh := nvl(l_moq_qty,0);
6684: l_lpn_att := nvl(l_moq_qty,0) + nvl(l_mmtt_qty_src,0) + nvl(l_mmtt_qty_dest,0);

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

6708: )
6709: AND mmtt.transaction_action_id NOT IN (5,6,24,30);
6710:
6711: IF(l_debug=1) THEN
6712: inv_log_util.trace('Total MMTT Trx quantity Source Org Sub : ' || to_char(l_mmtt_qty_src), 'GET_AVAIL_QTY_FOR_XFER', 9);
6713: END IF;
6714:
6715: SELECT SUM(moq.primary_transaction_quantity)
6716: INTO l_moq_qty

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

6722: AND decode(p_lot_number,null,'@@',moq.lot_number) = nvl(p_lot_number,'@@')
6723: AND moq.locator_id = p_locator_id;
6724:
6725: IF(l_debug=1) THEN
6726: inv_log_util.trace('Total MOQ quantity LPN Level: ' || to_char(l_moq_qty), 'GET_AVAIL_QTY_FOR_XFER', 9);
6727: END IF;
6728:
6729: SELECT SUM(Decode(mmtt.transaction_status, 2, 1,
6730: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,

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

6762: END IF;
6763: END IF;
6764:
6765: IF(l_debug=1) THEN
6766: inv_log_util.trace('Total quantity on-hand: ' || to_char(l_qoh), 'GET_AVAIL_QTY_FOR_XFER', 9);
6767: END IF;
6768: END GET_AVAIL_QTY_FOR_XFER;
6769:
6770:

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

13173: LOOP --{
13174: FETCH l_get_serial INTO l_serial_number;
13175: IF l_get_serial%NOTFOUND THEN
13176: IF l_debug = 1 THEN
13177: inv_log_util.trace('Serial not found', 'delete_serial_numbers', 9);
13178: END IF;
13179: EXIT;
13180: ELSE --{
13181: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN --{

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

13179: EXIT;
13180: ELSE --{
13181: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN --{
13182: IF l_debug = 1 THEN
13183: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
13184: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
13185: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
13186: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13187: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);

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

13180: ELSE --{
13181: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN --{
13182: IF l_debug = 1 THEN
13183: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
13184: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
13185: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
13186: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13187: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13188: END IF;

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

13181: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN --{
13182: IF l_debug = 1 THEN
13183: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
13184: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
13185: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
13186: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13187: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13188: END IF;
13189:

Line 13186: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '

13182: IF l_debug = 1 THEN
13183: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
13184: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
13185: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
13186: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13187: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13188: END IF;
13189:
13190: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP --{

Line 13207: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '

13203: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
13204: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
13205:
13206: IF l_debug = 1 THEN
13207: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13208: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13209: END IF;
13210:
13211: ELSE

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

13212: inv_detail_util_pvt.g_output_serial_rows.DELETE;
13213: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
13214:
13215: IF l_debug = 1 THEN
13216: inv_log_util.trace('Array cleared', 'delete_serial_numbers', 9);
13217: END IF;
13218:
13219: END IF; -- End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1)
13220:

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

14965: l_cur_start := 1;
14966: -- get last filled row of table
14967: l_row := g_build_package_row;
14968: l_package_length := LENGTH(p_package_string);
14969: inv_log_util.trace( l_package_length ,'l_package_length' , 9);
14970: inv_log_util.trace( p_package_string ,'p_package_string' , 9);
14971: -- return if string is null
14972: IF l_package_length IS NULL
14973: OR l_package_length = 0 THEN

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

14966: -- get last filled row of table
14967: l_row := g_build_package_row;
14968: l_package_length := LENGTH(p_package_string);
14969: inv_log_util.trace( l_package_length ,'l_package_length' , 9);
14970: inv_log_util.trace( p_package_string ,'p_package_string' , 9);
14971: -- return if string is null
14972: IF l_package_length IS NULL
14973: OR l_package_length = 0 THEN
14974: RETURN;

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

17014: LOOP -- loop through the rules
17015: FETCH c_rules INTO l_rule_id, l_type_hdr_id, l_organization_id, l_wms_task_type;
17016: EXIT WHEN c_rules%NOTFOUND;
17017:
17018: --inv_log_util.TRACE('found the rule', 'RULE_ENGINE', 4);
17019:
17020: BEGIN
17021: -- get the pre-generated package name for this rule
17022: getpackagename(l_rule_id, l_package_name);

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

17088: when others then
17089: null;
17090: end;
17091:
17092: --inv_log_util.TRACE('NOT found the rule: g_current_organization_id'||g_current_organization_id, 'RULE_ENGINE', 4);
17093: --inv_log_util.TRACE('NOT found the rule: l_organization_id:'||l_organization_id, 'RULE_ENGINE', 4);
17094: IF NVL(g_current_organization_id, -1) <> l_organization_id THEN
17095: g_current_organization_id := l_organization_id;
17096:

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

17089: null;
17090: end;
17091:
17092: --inv_log_util.TRACE('NOT found the rule: g_current_organization_id'||g_current_organization_id, 'RULE_ENGINE', 4);
17093: --inv_log_util.TRACE('NOT found the rule: l_organization_id:'||l_organization_id, 'RULE_ENGINE', 4);
17094: IF NVL(g_current_organization_id, -1) <> l_organization_id THEN
17095: g_current_organization_id := l_organization_id;
17096:
17097:

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

17117: g_default_repl_task_type_id := NULL;
17118: g_default_moxfer_task_type_id := NULL;
17119: g_default_moissue_task_type_id := NULL;
17120: g_default_operation_plan_id := NULL;
17121: --inv_log_util.TRACE('default_task_type not found', 'RULE_ENGINE', 4);
17122: END IF;
17123:
17124: CLOSE c_default_task_type;
17125: END IF;

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

17123:
17124: CLOSE c_default_task_type;
17125: END IF;
17126:
17127: --inv_log_util.TRACE('inside cursor c_defualt_task_type', 'RULE_ENGINE', 4);
17128:
17129:
17130: IF l_wms_task_type = 1 THEN
17131: l_task_type_id := g_default_pick_task_type_id;

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

17142: ELSE
17143: l_task_type_id := NULL;
17144: END IF;
17145:
17146: --inv_log_util.TRACE('wms_task_type = 1, task_type_id=:' || l_task_type_id, 'RULE_ENGINE', 4);
17147: --inv_log_util.TRACE('before update statement', 'RULE_ENGINE', 4);
17148:
17149: UPDATE mtl_material_transactions_temp mmtt
17150: SET mmtt.standard_operation_id = l_task_type_id

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

17143: l_task_type_id := NULL;
17144: END IF;
17145:
17146: --inv_log_util.TRACE('wms_task_type = 1, task_type_id=:' || l_task_type_id, 'RULE_ENGINE', 4);
17147: --inv_log_util.TRACE('before update statement', 'RULE_ENGINE', 4);
17148:
17149: UPDATE mtl_material_transactions_temp mmtt
17150: SET mmtt.standard_operation_id = l_task_type_id
17151: WHERE mmtt.transaction_temp_id = p_task_id;

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

17149: UPDATE mtl_material_transactions_temp mmtt
17150: SET mmtt.standard_operation_id = l_task_type_id
17151: WHERE mmtt.transaction_temp_id = p_task_id;
17152:
17153: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);
17154: END IF;
17155:
17156: -- Standard check of p_commit
17157: IF fnd_api.to_boolean(p_commit) THEN

Line 17564: --inv_log_util.trace( 'errbuf : '||errbuf ,'compile_all_rule_packages' , 9);

17560: -- an online patch is in progress, return error
17561: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');
17562: retcode := 2;
17563: errbuf := errbuf || 'Error: ' || fnd_message.get;
17564: --inv_log_util.trace( 'errbuf : '||errbuf ,'compile_all_rule_packages' , 9);
17565: RETURN;
17566: END IF;
17567:
17568: BEGIN