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 3431: inv_log_util.trace('get_valid_to_locs Starting ', 'process_serial_subxfr');

3427: l_restrict_locators_code NUMBER;
3428: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3429: BEGIN
3430: IF (l_debug = 1) THEN
3431: inv_log_util.trace('get_valid_to_locs Starting ', 'process_serial_subxfr');
3432: END IF;
3433: IF p_transaction_action_id IN (3, 21) THEN
3434: l_org := p_to_organization_id;
3435: SELECT restrict_locators_code

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

3441: l_org := p_organization_id;
3442: l_restrict_locators_code := p_restrict_locators_code;
3443: END IF;
3444: IF (l_debug = 1) THEN
3445: inv_log_util.trace('get_valid_to_locs ::Fetch Locators ', 'process_serial_subxfr');
3446: END IF;
3447: IF l_restrict_locators_code = 1 THEN --Locators restricted to predefined list
3448: OPEN x_locators FOR
3449: SELECT a.inventory_location_id

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

3492: l_restrict_locators_code NUMBER;
3493: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3494: BEGIN
3495: IF (l_debug = 1) THEN
3496: inv_log_util.trace('get_valid_prj_to_locs ::Starting ', 'process_serial_subxfr');
3497: END IF;
3498: IF p_transaction_action_id IN (3, 21) THEN
3499: l_org := p_to_organization_id;
3500:

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

3507: l_org := p_organization_id;
3508: l_restrict_locators_code := p_restrict_locators_code;
3509: END IF;
3510: IF (l_debug = 1) THEN
3511: inv_log_util.trace('get_valid_prj_to_locs ::Fetching Locators ', 'process_serial_subxfr');
3512: END IF;
3513: IF l_restrict_locators_code= 1 THEN --Locators restricted to predefined list
3514: OPEN x_locators FOR
3515: SELECT a.inventory_location_id

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

3657: p_serial_number => p_serial_number,
3658: p_object_type => 'A');
3659:
3660: IF (l_debug = 1) THEN
3661: inv_log_util.trace('Status Allowed: ' || l_status_allowed, 'process_serial_subxfr');
3662: END IF;
3663: IF l_status_allowed <> 'Y' THEN
3664: fnd_message.set_name('INV', 'INV_TRX_SER_NA_DUE_MS');
3665: fnd_message.set_token('TOKEN1', p_serial_number);

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

3695:
3696: CLOSE l_ref_cur;
3697:
3698: IF (l_debug = 1) THEN
3699: inv_log_util.trace('l_to_subinventory_code: ' || l_to_subinventory_code, 'process_serial_subxfr');
3700: END IF;
3701:
3702: IF p_to_subinventory_code <> Nvl(l_to_subinventory_code, '@@@') THEN
3703: fnd_message.set_name('INV', 'INV_INVALID_SUB');

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

3749:
3750: CLOSE l_ref_cur;
3751:
3752: IF (l_debug = 1) THEN
3753: inv_log_util.trace('p_to_locator: ' || p_to_locator, 'process_serial_subxfr');
3754: inv_log_util.trace('p_to_locator_id: ' || p_to_locator_id, 'process_serial_subxfr');
3755: inv_log_util.trace('l_to_locator: ' || l_to_locator, 'process_serial_subxfr');
3756: inv_log_util.trace('l_to_locator_id: ' || l_to_locator_id, 'process_serial_subxfr');
3757: END IF;

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

3750: CLOSE l_ref_cur;
3751:
3752: IF (l_debug = 1) THEN
3753: inv_log_util.trace('p_to_locator: ' || p_to_locator, 'process_serial_subxfr');
3754: inv_log_util.trace('p_to_locator_id: ' || p_to_locator_id, 'process_serial_subxfr');
3755: inv_log_util.trace('l_to_locator: ' || l_to_locator, 'process_serial_subxfr');
3756: inv_log_util.trace('l_to_locator_id: ' || l_to_locator_id, 'process_serial_subxfr');
3757: END IF;
3758:

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

3751:
3752: IF (l_debug = 1) THEN
3753: inv_log_util.trace('p_to_locator: ' || p_to_locator, 'process_serial_subxfr');
3754: inv_log_util.trace('p_to_locator_id: ' || p_to_locator_id, 'process_serial_subxfr');
3755: inv_log_util.trace('l_to_locator: ' || l_to_locator, 'process_serial_subxfr');
3756: inv_log_util.trace('l_to_locator_id: ' || l_to_locator_id, 'process_serial_subxfr');
3757: END IF;
3758:
3759: IF p_to_locator_id <> Nvl(l_to_locator_id, -1) THEN

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

3752: IF (l_debug = 1) THEN
3753: inv_log_util.trace('p_to_locator: ' || p_to_locator, 'process_serial_subxfr');
3754: inv_log_util.trace('p_to_locator_id: ' || p_to_locator_id, 'process_serial_subxfr');
3755: inv_log_util.trace('l_to_locator: ' || l_to_locator, 'process_serial_subxfr');
3756: inv_log_util.trace('l_to_locator_id: ' || l_to_locator_id, 'process_serial_subxfr');
3757: END IF;
3758:
3759: IF p_to_locator_id <> Nvl(l_to_locator_id, -1) THEN
3760: fnd_message.set_name('INV', 'INV_INT_LOCCODE');

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

3811: x_return_msg := fnd_message.get;
3812: RETURN;
3813: END IF;
3814: IF (l_debug = 1) THEN
3815: inv_log_util.trace('ATT: ' || l_att, 'process_serial_subxfr');
3816: END IF;
3817:
3818: /** R12 Enhanced reservations project **/
3819: BEGIN

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

3822: serial_number = p_serial_number AND inventory_item_id = p_inventory_item_id;
3823: EXCEPTION
3824: WHEN no_data_found THEN
3825: IF (l_debug = 1) THEN
3826: inv_log_util.trace('Serial is not reserved', 'process_serial_subxfr');
3827: END IF;
3828: END;
3829: /** end - R12 Enhanced reservations project **/
3830:

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

3868: x_return_msg := fnd_message.get;
3869: RETURN;
3870: END IF;
3871: IF (l_debug = 1) THEN
3872: inv_log_util.trace('ATT in source: ' || l_att, 'process_serial_subxfr');
3873: END IF;
3874:
3875: inv_quantity_tree_pub.update_quantities
3876: (p_api_version_number => 1.0,

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

3906: RETURN;
3907: END IF;
3908:
3909: IF (l_debug = 1) THEN
3910: inv_log_util.trace('ATT in dest: ' || l_att, 'process_serial_subxfr');
3911: END IF;
3912:
3913: -- Update the group mark ID on the serial record so that it is not
3914: -- available in the LOV any more

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

3923: END IF;
3924: /** End - R12 Enhanced reservation project **/
3925:
3926: IF (l_debug = 1) THEN
3927: inv_log_util.trace('Updated Serial ' || p_serial_number || ' Item ID ' || p_inventory_item_id, 'process_serial_subxfr');
3928: END IF;
3929:
3930: IF p_transaction_header_id IS NULL THEN
3931: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

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

3935: x_transaction_header_id := p_transaction_header_id;
3936: END IF;
3937:
3938: IF (l_debug = 1) THEN
3939: inv_log_util.trace('Calling Insert MMTT', 'process_serial_subxfr');
3940: END IF;
3941:
3942: -- Insert record into MMTT
3943: --I Development Bug 2634570

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

3969: x_proc_msg => l_proc_msg);
3970: EXCEPTION
3971: WHEN OTHERS THEN
3972: IF (l_debug = 1) THEN
3973: inv_log_util.trace('SQL Error while inserting MTTT: ' || Sqlerrm, 'process_serial_subxfr');
3974: END IF;
3975: END;
3976:
3977:

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

3976:
3977:
3978: IF l_return_code = 0 THEN
3979: IF (l_debug = 1) THEN
3980: inv_log_util.trace('Inserted MMTT record', 'process_serial_subxfr');
3981: inv_log_util.trace('Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
3982: inv_log_util.trace('Header ID = ' || x_transaction_header_id, 'process_serial_subxfr');
3983: END IF;
3984: ELSE

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

3977:
3978: IF l_return_code = 0 THEN
3979: IF (l_debug = 1) THEN
3980: inv_log_util.trace('Inserted MMTT record', 'process_serial_subxfr');
3981: inv_log_util.trace('Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
3982: inv_log_util.trace('Header ID = ' || x_transaction_header_id, 'process_serial_subxfr');
3983: END IF;
3984: ELSE
3985: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3978: IF l_return_code = 0 THEN
3979: IF (l_debug = 1) THEN
3980: inv_log_util.trace('Inserted MMTT record', 'process_serial_subxfr');
3981: inv_log_util.trace('Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
3982: inv_log_util.trace('Header ID = ' || x_transaction_header_id, 'process_serial_subxfr');
3983: END IF;
3984: ELSE
3985: x_return_status := fnd_api.g_ret_sts_unexp_error;
3986: IF (l_debug = 1) THEN

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

3983: END IF;
3984: ELSE
3985: x_return_status := fnd_api.g_ret_sts_unexp_error;
3986: IF (l_debug = 1) THEN
3987: inv_log_util.trace(l_proc_msg, 'process_serial_subxfr');
3988: END IF;
3989: RETURN;
3990: END IF;
3991:

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

4003:
4004: IF l_return_code = 0 THEN
4005: l_transaction_temp_id := l_serial_transaction_temp_id;
4006: IF (l_debug = 1) THEN
4007: inv_log_util.trace('Inserted MTLT record', 'process_serial_subxfr');
4008: inv_log_util.trace('Serial Temp ID = ' || l_serial_transaction_temp_id, 'process_serial_subxfr');
4009: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4010: END IF;
4011: ELSE

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

4004: IF l_return_code = 0 THEN
4005: l_transaction_temp_id := l_serial_transaction_temp_id;
4006: IF (l_debug = 1) THEN
4007: inv_log_util.trace('Inserted MTLT record', 'process_serial_subxfr');
4008: inv_log_util.trace('Serial Temp ID = ' || l_serial_transaction_temp_id, 'process_serial_subxfr');
4009: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4010: END IF;
4011: ELSE
4012: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4005: l_transaction_temp_id := l_serial_transaction_temp_id;
4006: IF (l_debug = 1) THEN
4007: inv_log_util.trace('Inserted MTLT record', 'process_serial_subxfr');
4008: inv_log_util.trace('Serial Temp ID = ' || l_serial_transaction_temp_id, 'process_serial_subxfr');
4009: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4010: END IF;
4011: ELSE
4012: x_return_status := fnd_api.g_ret_sts_unexp_error;
4013: IF (l_debug = 1) THEN

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

4010: END IF;
4011: ELSE
4012: x_return_status := fnd_api.g_ret_sts_unexp_error;
4013: IF (l_debug = 1) THEN
4014: inv_log_util.trace(l_proc_msg, 'process_serial_subxfr');
4015: END IF;
4016: RETURN;
4017: END IF;
4018: --Bug 2779646

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

4028: x_proc_msg => l_proc_msg);
4029:
4030: IF l_return_code = 0 THEN
4031: IF (l_debug = 1) THEN
4032: inv_log_util.trace('Inserted MSNT record', 'process_serial_subxfr');
4033: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4034: END IF;
4035: ELSE
4036: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4029:
4030: IF l_return_code = 0 THEN
4031: IF (l_debug = 1) THEN
4032: inv_log_util.trace('Inserted MSNT record', 'process_serial_subxfr');
4033: inv_log_util.trace('Serial Temp ID = ' || l_transaction_temp_id, 'process_serial_subxfr');
4034: END IF;
4035: ELSE
4036: x_return_status := fnd_api.g_ret_sts_unexp_error;
4037: IF (l_debug = 1) THEN

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

4034: END IF;
4035: ELSE
4036: x_return_status := fnd_api.g_ret_sts_unexp_error;
4037: IF (l_debug = 1) THEN
4038: inv_log_util.trace(l_proc_msg, 'process_serial_subxfr');
4039: END IF;
4040: RETURN;
4041: END IF;
4042: