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.INV_TXN_VALIDATIONS dependencies on INV_LOG_UTIL

Line 3710: inv_log_util.trace('get_valid_to_locs Starting ', 'process_serial_subxfr');

3706: l_restrict_locators_code NUMBER;
3707: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3708: BEGIN
3709: IF (l_debug = 1) THEN
3710: inv_log_util.trace('get_valid_to_locs Starting ', 'process_serial_subxfr');
3711: END IF;
3712: IF p_transaction_action_id IN (3, 21) THEN
3713: l_org := p_to_organization_id;
3714: SELECT restrict_locators_code

Line 3724: inv_log_util.trace('get_valid_to_locs ::Fetch Locators ', 'process_serial_subxfr');

3720: l_org := p_organization_id;
3721: l_restrict_locators_code := p_restrict_locators_code;
3722: END IF;
3723: IF (l_debug = 1) THEN
3724: inv_log_util.trace('get_valid_to_locs ::Fetch Locators ', 'process_serial_subxfr');
3725: END IF;
3726: IF l_restrict_locators_code = 1 THEN --Locators restricted to predefined list
3727: OPEN x_locators FOR
3728: SELECT a.inventory_location_id

Line 3775: inv_log_util.trace('get_valid_prj_to_locs ::Starting ', 'process_serial_subxfr');

3771: l_restrict_locators_code NUMBER;
3772: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3773: BEGIN
3774: IF (l_debug = 1) THEN
3775: inv_log_util.trace('get_valid_prj_to_locs ::Starting ', 'process_serial_subxfr');
3776: END IF;
3777: IF p_transaction_action_id IN (3, 21) THEN
3778: l_org := p_to_organization_id;
3779:

Line 3790: inv_log_util.trace('get_valid_prj_to_locs ::Fetching Locators ', 'process_serial_subxfr');

3786: l_org := p_organization_id;
3787: l_restrict_locators_code := p_restrict_locators_code;
3788: END IF;
3789: IF (l_debug = 1) THEN
3790: inv_log_util.trace('get_valid_prj_to_locs ::Fetching Locators ', 'process_serial_subxfr');
3791: END IF;
3792: IF l_restrict_locators_code= 1 THEN --Locators restricted to predefined list
3793: OPEN x_locators FOR
3794: SELECT a.inventory_location_id

Line 3940: inv_log_util.trace('Status Allowed: ' || l_status_allowed, 'process_serial_subxfr');

3936: p_serial_number => p_serial_number,
3937: p_object_type => 'A');
3938:
3939: IF (l_debug = 1) THEN
3940: inv_log_util.trace('Status Allowed: ' || l_status_allowed, 'process_serial_subxfr');
3941: END IF;
3942: IF l_status_allowed <> 'Y' THEN
3943: fnd_message.set_name('INV', 'INV_TRX_SER_NA_DUE_MS');
3944: fnd_message.set_token('TOKEN1', p_serial_number);

Line 3978: inv_log_util.trace('l_to_subinventory_code: ' || l_to_subinventory_code, 'process_serial_subxfr');

3974:
3975: CLOSE l_ref_cur;
3976:
3977: IF (l_debug = 1) THEN
3978: inv_log_util.trace('l_to_subinventory_code: ' || l_to_subinventory_code, 'process_serial_subxfr');
3979: END IF;
3980:
3981: IF p_to_subinventory_code <> Nvl(l_to_subinventory_code, '@@@') THEN
3982: fnd_message.set_name('INV', 'INV_INVALID_SUB');

Line 4032: inv_log_util.trace('p_to_locator: ' || p_to_locator, 'process_serial_subxfr');

4028:
4029: CLOSE l_ref_cur;
4030:
4031: IF (l_debug = 1) THEN
4032: inv_log_util.trace('p_to_locator: ' || p_to_locator, 'process_serial_subxfr');
4033: inv_log_util.trace('p_to_locator_id: ' || p_to_locator_id, 'process_serial_subxfr');
4034: inv_log_util.trace('l_to_locator: ' || l_to_locator, 'process_serial_subxfr');
4035: inv_log_util.trace('l_to_locator_id: ' || l_to_locator_id, 'process_serial_subxfr');
4036: END IF;

Line 4033: inv_log_util.trace('p_to_locator_id: ' || p_to_locator_id, 'process_serial_subxfr');

4029: CLOSE l_ref_cur;
4030:
4031: IF (l_debug = 1) THEN
4032: inv_log_util.trace('p_to_locator: ' || p_to_locator, 'process_serial_subxfr');
4033: inv_log_util.trace('p_to_locator_id: ' || p_to_locator_id, 'process_serial_subxfr');
4034: inv_log_util.trace('l_to_locator: ' || l_to_locator, 'process_serial_subxfr');
4035: inv_log_util.trace('l_to_locator_id: ' || l_to_locator_id, 'process_serial_subxfr');
4036: END IF;
4037:

Line 4034: inv_log_util.trace('l_to_locator: ' || l_to_locator, 'process_serial_subxfr');

4030:
4031: IF (l_debug = 1) THEN
4032: inv_log_util.trace('p_to_locator: ' || p_to_locator, 'process_serial_subxfr');
4033: inv_log_util.trace('p_to_locator_id: ' || p_to_locator_id, 'process_serial_subxfr');
4034: inv_log_util.trace('l_to_locator: ' || l_to_locator, 'process_serial_subxfr');
4035: inv_log_util.trace('l_to_locator_id: ' || l_to_locator_id, 'process_serial_subxfr');
4036: END IF;
4037:
4038: IF p_to_locator_id <> Nvl(l_to_locator_id, -1) THEN

Line 4035: inv_log_util.trace('l_to_locator_id: ' || l_to_locator_id, 'process_serial_subxfr');

4031: IF (l_debug = 1) THEN
4032: inv_log_util.trace('p_to_locator: ' || p_to_locator, 'process_serial_subxfr');
4033: inv_log_util.trace('p_to_locator_id: ' || p_to_locator_id, 'process_serial_subxfr');
4034: inv_log_util.trace('l_to_locator: ' || l_to_locator, 'process_serial_subxfr');
4035: inv_log_util.trace('l_to_locator_id: ' || l_to_locator_id, 'process_serial_subxfr');
4036: END IF;
4037:
4038: IF p_to_locator_id <> Nvl(l_to_locator_id, -1) THEN
4039: fnd_message.set_name('INV', 'INV_INT_LOCCODE');

Line 4094: inv_log_util.trace('ATT: ' || l_att, 'process_serial_subxfr');

4090: x_return_msg := fnd_message.get;
4091: RETURN;
4092: END IF;
4093: IF (l_debug = 1) THEN
4094: inv_log_util.trace('ATT: ' || l_att, 'process_serial_subxfr');
4095: END IF;
4096:
4097: /** R12 Enhanced reservations project **/
4098: BEGIN

Line 4105: inv_log_util.trace('Serial is not reserved', 'process_serial_subxfr');

4101: serial_number = p_serial_number AND inventory_item_id = p_inventory_item_id;
4102: EXCEPTION
4103: WHEN no_data_found THEN
4104: IF (l_debug = 1) THEN
4105: inv_log_util.trace('Serial is not reserved', 'process_serial_subxfr');
4106: END IF;
4107: END;
4108: /** end - R12 Enhanced reservations project **/
4109:

Line 4151: inv_log_util.trace('ATT in source: ' || l_att, 'process_serial_subxfr');

4147: x_return_msg := fnd_message.get;
4148: RETURN;
4149: END IF;
4150: IF (l_debug = 1) THEN
4151: inv_log_util.trace('ATT in source: ' || l_att, 'process_serial_subxfr');
4152: END IF;
4153:
4154: inv_quantity_tree_pub.update_quantities
4155: (p_api_version_number => 1.0,

Line 4189: inv_log_util.trace('ATT in dest: ' || l_att, 'process_serial_subxfr');

4185: RETURN;
4186: END IF;
4187:
4188: IF (l_debug = 1) THEN
4189: inv_log_util.trace('ATT in dest: ' || l_att, 'process_serial_subxfr');
4190: END IF;
4191:
4192: -- Update the group mark ID on the serial record so that it is not
4193: -- available in the LOV any more

Line 4206: inv_log_util.trace('Updated Serial ' || p_serial_number || ' Item ID ' || p_inventory_item_id, 'process_serial_subxfr');

4202: END IF;
4203: /** End - R12 Enhanced reservation project **/
4204:
4205: IF (l_debug = 1) THEN
4206: inv_log_util.trace('Updated Serial ' || p_serial_number || ' Item ID ' || p_inventory_item_id, 'process_serial_subxfr');
4207: END IF;
4208:
4209: IF p_transaction_header_id IS NULL THEN
4210: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

Line 4218: inv_log_util.trace('Calling Insert MMTT', 'process_serial_subxfr');

4214: x_transaction_header_id := p_transaction_header_id;
4215: END IF;
4216:
4217: IF (l_debug = 1) THEN
4218: inv_log_util.trace('Calling Insert MMTT', 'process_serial_subxfr');
4219: END IF;
4220:
4221: -- Insert record into MMTT
4222: --I Development Bug 2634570

Line 4252: inv_log_util.trace('SQL Error while inserting MTTT: ' || Sqlerrm, 'process_serial_subxfr');

4248: x_proc_msg => l_proc_msg);
4249: EXCEPTION
4250: WHEN OTHERS THEN
4251: IF (l_debug = 1) THEN
4252: inv_log_util.trace('SQL Error while inserting MTTT: ' || Sqlerrm, 'process_serial_subxfr');
4253: END IF;
4254: END;
4255:
4256:

Line 4259: inv_log_util.trace('Inserted MMTT record', 'process_serial_subxfr');

4255:
4256:
4257: IF l_return_code = 0 THEN
4258: IF (l_debug = 1) THEN
4259: inv_log_util.trace('Inserted MMTT record', 'process_serial_subxfr');
4260: inv_log_util.trace('Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4261: inv_log_util.trace('Header ID = ' || x_transaction_header_id, 'process_serial_subxfr');
4262: END IF;
4263: ELSE

Line 4260: inv_log_util.trace('Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');

4256:
4257: IF l_return_code = 0 THEN
4258: IF (l_debug = 1) THEN
4259: inv_log_util.trace('Inserted MMTT record', 'process_serial_subxfr');
4260: inv_log_util.trace('Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4261: inv_log_util.trace('Header ID = ' || x_transaction_header_id, 'process_serial_subxfr');
4262: END IF;
4263: ELSE
4264: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4261: inv_log_util.trace('Header ID = ' || x_transaction_header_id, 'process_serial_subxfr');

4257: IF l_return_code = 0 THEN
4258: IF (l_debug = 1) THEN
4259: inv_log_util.trace('Inserted MMTT record', 'process_serial_subxfr');
4260: inv_log_util.trace('Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4261: inv_log_util.trace('Header ID = ' || x_transaction_header_id, 'process_serial_subxfr');
4262: END IF;
4263: ELSE
4264: x_return_status := fnd_api.g_ret_sts_unexp_error;
4265: IF (l_debug = 1) THEN

Line 4266: inv_log_util.trace(l_proc_msg, 'process_serial_subxfr');

4262: END IF;
4263: ELSE
4264: x_return_status := fnd_api.g_ret_sts_unexp_error;
4265: IF (l_debug = 1) THEN
4266: inv_log_util.trace(l_proc_msg, 'process_serial_subxfr');
4267: END IF;
4268: RETURN;
4269: END IF;
4270:

Line 4286: inv_log_util.trace('Inserted MTLT record', 'process_serial_subxfr');

4282:
4283: IF l_return_code = 0 THEN
4284: l_transaction_temp_id := l_serial_transaction_temp_id;
4285: IF (l_debug = 1) THEN
4286: inv_log_util.trace('Inserted MTLT record', 'process_serial_subxfr');
4287: inv_log_util.trace('Serial Temp ID = ' || l_serial_transaction_temp_id, 'process_serial_subxfr');
4288: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4289: END IF;
4290: ELSE

Line 4287: inv_log_util.trace('Serial Temp ID = ' || l_serial_transaction_temp_id, 'process_serial_subxfr');

4283: IF l_return_code = 0 THEN
4284: l_transaction_temp_id := l_serial_transaction_temp_id;
4285: IF (l_debug = 1) THEN
4286: inv_log_util.trace('Inserted MTLT record', 'process_serial_subxfr');
4287: inv_log_util.trace('Serial Temp ID = ' || l_serial_transaction_temp_id, 'process_serial_subxfr');
4288: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4289: END IF;
4290: ELSE
4291: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4288: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');

4284: l_transaction_temp_id := l_serial_transaction_temp_id;
4285: IF (l_debug = 1) THEN
4286: inv_log_util.trace('Inserted MTLT record', 'process_serial_subxfr');
4287: inv_log_util.trace('Serial Temp ID = ' || l_serial_transaction_temp_id, 'process_serial_subxfr');
4288: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4289: END IF;
4290: ELSE
4291: x_return_status := fnd_api.g_ret_sts_unexp_error;
4292: IF (l_debug = 1) THEN

Line 4293: inv_log_util.trace(l_proc_msg, 'process_serial_subxfr');

4289: END IF;
4290: ELSE
4291: x_return_status := fnd_api.g_ret_sts_unexp_error;
4292: IF (l_debug = 1) THEN
4293: inv_log_util.trace(l_proc_msg, 'process_serial_subxfr');
4294: END IF;
4295: RETURN;
4296: END IF;
4297: --Bug 2779646

Line 4311: inv_log_util.trace('Inserted MSNT record', 'process_serial_subxfr');

4307: x_proc_msg => l_proc_msg);
4308:
4309: IF l_return_code = 0 THEN
4310: IF (l_debug = 1) THEN
4311: inv_log_util.trace('Inserted MSNT record', 'process_serial_subxfr');
4312: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4313: END IF;
4314: ELSE
4315: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4312: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');

4308:
4309: IF l_return_code = 0 THEN
4310: IF (l_debug = 1) THEN
4311: inv_log_util.trace('Inserted MSNT record', 'process_serial_subxfr');
4312: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4313: END IF;
4314: ELSE
4315: x_return_status := fnd_api.g_ret_sts_unexp_error;
4316: IF (l_debug = 1) THEN

Line 4317: inv_log_util.trace(l_proc_msg, 'process_serial_subxfr');

4313: END IF;
4314: ELSE
4315: x_return_status := fnd_api.g_ret_sts_unexp_error;
4316: IF (l_debug = 1) THEN
4317: inv_log_util.trace(l_proc_msg, 'process_serial_subxfr');
4318: END IF;
4319: RETURN;
4320: END IF;
4321: