DBA Data[Home] [Help]

APPS.INV_TROLIN_UTIL dependencies on INV_VALUE_TO_ID

Line 3404: l_trolin_rec.from_locator_id := INV_Value_To_Id.from_locator

3400: END IF;
3401:
3402: ELSE
3403:
3404: l_trolin_rec.from_locator_id := INV_Value_To_Id.from_locator
3405: ( p_organizatoin_id => p_trolin_rec.organization_id,
3406: p_from_locator => p_trolin_val_rec.from_locator
3407: );
3408:

Line 3428: l_trolin_rec.from_subinventory_id := inv_value_to_id.from_subinventory(p_organization_id => p_trolin_rec.organization_id, p_from_subinventory => p_trolin_val_rec.from_subinventory);

3424: fnd_message.set_token('ATTRIBUTE', 'from_subinventory');
3425: fnd_msg_pub.ADD;
3426: END IF;
3427: ELSE
3428: l_trolin_rec.from_subinventory_id := inv_value_to_id.from_subinventory(p_organization_id => p_trolin_rec.organization_id, p_from_subinventory => p_trolin_val_rec.from_subinventory);
3429:
3430: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
3431: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3432: END IF;

Line 3446: l_trolin_rec.header_id := inv_value_to_id.header(p_header => p_trolin_val_rec.header);

3442: fnd_message.set_token('ATTRIBUTE', 'header');
3443: fnd_msg_pub.ADD;
3444: END IF;
3445: ELSE
3446: l_trolin_rec.header_id := inv_value_to_id.header(p_header => p_trolin_val_rec.header);
3447:
3448: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
3449: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3450: END IF;

Line 3464: l_trolin_rec.inventory_item_id := inv_value_to_id.inventory_item(p_organization_id => p_trolin_rec.organization_id, p_inventory_item => p_trolin_val_rec.inventory_item);

3460: fnd_message.set_token('ATTRIBUTE', 'inventory_item');
3461: fnd_msg_pub.ADD;
3462: END IF;
3463: ELSE
3464: l_trolin_rec.inventory_item_id := inv_value_to_id.inventory_item(p_organization_id => p_trolin_rec.organization_id, p_inventory_item => p_trolin_val_rec.inventory_item);
3465:
3466: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
3467: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3468: END IF;

Line 3482: l_trolin_rec.line_id := inv_value_to_id.line(p_line => p_trolin_val_rec.line);

3478: fnd_message.set_token('ATTRIBUTE', 'line');
3479: fnd_msg_pub.ADD;
3480: END IF;
3481: ELSE
3482: l_trolin_rec.line_id := inv_value_to_id.line(p_line => p_trolin_val_rec.line);
3483:
3484: IF l_trolin_rec.line_id = fnd_api.g_miss_num THEN
3485: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3486: END IF;

Line 3500: l_trolin_rec.organization_id := inv_value_to_id.ORGANIZATION(p_organization => p_trolin_val_rec.ORGANIZATION);

3496: fnd_message.set_token('ATTRIBUTE', 'organization');
3497: fnd_msg_pub.ADD;
3498: END IF;
3499: ELSE
3500: l_trolin_rec.organization_id := inv_value_to_id.ORGANIZATION(p_organization => p_trolin_val_rec.ORGANIZATION);
3501:
3502: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
3503: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3504: END IF;

Line 3518: l_trolin_rec.to_organization_id := inv_value_to_id.to_organization(p_to_organization => p_trolin_val_rec.to_organization);

3514: fnd_message.set_token('ATTRIBUTE', 'to_organization');
3515: fnd_msg_pub.ADD;
3516: END IF;
3517: ELSE
3518: l_trolin_rec.to_organization_id := inv_value_to_id.to_organization(p_to_organization => p_trolin_val_rec.to_organization);
3519:
3520: IF l_trolin_rec.to_organization_id = fnd_api.g_miss_num THEN
3521: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3522: END IF;

Line 3536: l_trolin_rec.project_id := inv_value_to_id.project(p_project => p_trolin_val_rec.project);

3532: fnd_message.set_token('ATTRIBUTE', 'project');
3533: fnd_msg_pub.ADD;
3534: END IF;
3535: ELSE
3536: l_trolin_rec.project_id := inv_value_to_id.project(p_project => p_trolin_val_rec.project);
3537:
3538: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
3539: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3540: END IF;

Line 3554: l_trolin_rec.reason_id := inv_value_to_id.reason(p_reason => p_trolin_val_rec.reason);

3550: fnd_message.set_token('ATTRIBUTE', 'reason');
3551: fnd_msg_pub.ADD;
3552: END IF;
3553: ELSE
3554: l_trolin_rec.reason_id := inv_value_to_id.reason(p_reason => p_trolin_val_rec.reason);
3555:
3556: IF l_trolin_rec.reason_id = fnd_api.g_miss_num THEN
3557: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3558: END IF;

Line 3572: l_trolin_rec.reference_id := inv_value_to_id.REFERENCE(p_reference => p_trolin_val_rec.REFERENCE);

3568: fnd_message.set_token('ATTRIBUTE', 'reference');
3569: fnd_msg_pub.ADD;
3570: END IF;
3571: ELSE
3572: l_trolin_rec.reference_id := inv_value_to_id.REFERENCE(p_reference => p_trolin_val_rec.REFERENCE);
3573:
3574: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
3575: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3576: END IF;

Line 3590: l_trolin_rec.reference_type_code := inv_value_to_id.reference_type(p_reference_type => p_trolin_val_rec.reference_type);

3586: fnd_message.set_token('ATTRIBUTE', 'reference_type');
3587: fnd_msg_pub.ADD;
3588: END IF;
3589: ELSE
3590: l_trolin_rec.reference_type_code := inv_value_to_id.reference_type(p_reference_type => p_trolin_val_rec.reference_type);
3591:
3592: IF l_trolin_rec.reference_type_code = fnd_api.g_miss_num THEN
3593: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3594: END IF;

Line 3608: l_trolin_rec.task_id := inv_value_to_id.task(p_task => p_trolin_val_rec.task);

3604: fnd_message.set_token('ATTRIBUTE', 'task');
3605: fnd_msg_pub.ADD;
3606: END IF;
3607: ELSE
3608: l_trolin_rec.task_id := inv_value_to_id.task(p_task => p_trolin_val_rec.task);
3609:
3610: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
3611: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3612: END IF;

Line 3626: l_trolin_rec.to_account_id := inv_value_to_id.to_account(p_organization_id => p_trolin_rec.organization_id, p_to_account => p_trolin_val_rec.to_account);

3622: fnd_message.set_token('ATTRIBUTE', 'to_account');
3623: fnd_msg_pub.ADD;
3624: END IF;
3625: ELSE
3626: l_trolin_rec.to_account_id := inv_value_to_id.to_account(p_organization_id => p_trolin_rec.organization_id, p_to_account => p_trolin_val_rec.to_account);
3627:
3628: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
3629: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3630: END IF;

Line 3653: l_trolin_rec.to_locator_id := INV_Value_To_Id.to_locator

3649: END IF;
3650:
3651: ELSE
3652:
3653: l_trolin_rec.to_locator_id := INV_Value_To_Id.to_locator
3654: ( p_to_locator => p_trolin_val_rec.to_locator
3655: );
3656:
3657: IF l_trolin_rec.to_locator_id = FND_API.G_MISS_NUM THEN

Line 3676: l_trolin_rec.to_subinventory_code := inv_value_to_id.to_subinventory(p_organization_id => p_trolin_rec.organization_id, p_to_subinventory => p_trolin_val_rec.to_subinventory);

3672: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3673: fnd_msg_pub.ADD;
3674: END IF;
3675: ELSE
3676: l_trolin_rec.to_subinventory_code := inv_value_to_id.to_subinventory(p_organization_id => p_trolin_rec.organization_id, p_to_subinventory => p_trolin_val_rec.to_subinventory);
3677:
3678: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
3679: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3680: END IF;

Line 3695: l_trolin_rec.to_subinventory_id := inv_value_to_id.to_subinventory(p_organization_id => p_trolin_rec.organization_id, p_to_subinventory => p_trolin_val_rec.to_subinventory);

3691: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3692: fnd_msg_pub.ADD;
3693: END IF;
3694: ELSE
3695: l_trolin_rec.to_subinventory_id := inv_value_to_id.to_subinventory(p_organization_id => p_trolin_rec.organization_id, p_to_subinventory => p_trolin_val_rec.to_subinventory);
3696:
3697: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
3698: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3699: END IF;

Line 3713: l_trolin_rec.transaction_header_id := inv_value_to_id.transaction_header(p_transaction_header => p_trolin_val_rec.transaction_header);

3709: fnd_message.set_token('ATTRIBUTE', 'transaction_header');
3710: fnd_msg_pub.ADD;
3711: END IF;
3712: ELSE
3713: l_trolin_rec.transaction_header_id := inv_value_to_id.transaction_header(p_transaction_header => p_trolin_val_rec.transaction_header);
3714:
3715: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
3716: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3717: END IF;

Line 3731: l_trolin_rec.transaction_type_id := inv_value_to_id.transaction_type(p_transaction_type => p_trolin_val_rec.transaction_type);

3727: fnd_message.set_token('ATTRIBUTE', 'transaction_type');
3728: fnd_msg_pub.ADD;
3729: END IF;
3730: ELSE
3731: l_trolin_rec.transaction_type_id := inv_value_to_id.transaction_type(p_transaction_type => p_trolin_val_rec.transaction_type);
3732:
3733: IF l_trolin_rec.transaction_type_id = fnd_api.g_miss_num THEN
3734: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3735: END IF;

Line 3751: l_trolin_rec.uom_code := inv_value_to_id.uom(p_uom => p_trolin_val_rec.uom);

3747: fnd_msg_pub.ADD;
3748: END IF;
3749: ELSE
3750: -- Line2917
3751: l_trolin_rec.uom_code := inv_value_to_id.uom(p_uom => p_trolin_val_rec.uom);
3752:
3753: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
3754: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3755: END IF;