DBA Data[Home] [Help]

APPS.INV_TROLIN_UTIL dependencies on INV_VALUE_TO_ID

Line 3369: l_trolin_rec.from_locator_id := INV_Value_To_Id.from_locator

3365: END IF;
3366:
3367: ELSE
3368:
3369: l_trolin_rec.from_locator_id := INV_Value_To_Id.from_locator
3370: ( p_organizatoin_id => p_trolin_rec.organization_id,
3371: p_from_locator => p_trolin_val_rec.from_locator
3372: );
3373:

Line 3393: 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);

3389: fnd_message.set_token('ATTRIBUTE', 'from_subinventory');
3390: fnd_msg_pub.ADD;
3391: END IF;
3392: ELSE
3393: 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);
3394:
3395: IF l_trolin_rec.from_subinventory_id = fnd_api.g_miss_num THEN
3396: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3397: END IF;

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

3407: fnd_message.set_token('ATTRIBUTE', 'header');
3408: fnd_msg_pub.ADD;
3409: END IF;
3410: ELSE
3411: l_trolin_rec.header_id := inv_value_to_id.header(p_header => p_trolin_val_rec.header);
3412:
3413: IF l_trolin_rec.header_id = fnd_api.g_miss_num THEN
3414: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3415: END IF;

Line 3429: 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);

3425: fnd_message.set_token('ATTRIBUTE', 'inventory_item');
3426: fnd_msg_pub.ADD;
3427: END IF;
3428: ELSE
3429: 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);
3430:
3431: IF l_trolin_rec.inventory_item_id = fnd_api.g_miss_num THEN
3432: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3433: END IF;

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

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

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

3461: fnd_message.set_token('ATTRIBUTE', 'organization');
3462: fnd_msg_pub.ADD;
3463: END IF;
3464: ELSE
3465: l_trolin_rec.organization_id := inv_value_to_id.ORGANIZATION(p_organization => p_trolin_val_rec.ORGANIZATION);
3466:
3467: IF l_trolin_rec.organization_id = fnd_api.g_miss_num THEN
3468: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3469: END IF;

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

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

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

3497: fnd_message.set_token('ATTRIBUTE', 'project');
3498: fnd_msg_pub.ADD;
3499: END IF;
3500: ELSE
3501: l_trolin_rec.project_id := inv_value_to_id.project(p_project => p_trolin_val_rec.project);
3502:
3503: IF l_trolin_rec.project_id = fnd_api.g_miss_num THEN
3504: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3505: END IF;

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

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

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

3533: fnd_message.set_token('ATTRIBUTE', 'reference');
3534: fnd_msg_pub.ADD;
3535: END IF;
3536: ELSE
3537: l_trolin_rec.reference_id := inv_value_to_id.REFERENCE(p_reference => p_trolin_val_rec.REFERENCE);
3538:
3539: IF l_trolin_rec.reference_id = fnd_api.g_miss_num THEN
3540: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3541: END IF;

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

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

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

3569: fnd_message.set_token('ATTRIBUTE', 'task');
3570: fnd_msg_pub.ADD;
3571: END IF;
3572: ELSE
3573: l_trolin_rec.task_id := inv_value_to_id.task(p_task => p_trolin_val_rec.task);
3574:
3575: IF l_trolin_rec.task_id = fnd_api.g_miss_num THEN
3576: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3577: END IF;

Line 3591: 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);

3587: fnd_message.set_token('ATTRIBUTE', 'to_account');
3588: fnd_msg_pub.ADD;
3589: END IF;
3590: ELSE
3591: 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);
3592:
3593: IF l_trolin_rec.to_account_id = fnd_api.g_miss_num THEN
3594: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3595: END IF;

Line 3618: l_trolin_rec.to_locator_id := INV_Value_To_Id.to_locator

3614: END IF;
3615:
3616: ELSE
3617:
3618: l_trolin_rec.to_locator_id := INV_Value_To_Id.to_locator
3619: ( p_to_locator => p_trolin_val_rec.to_locator
3620: );
3621:
3622: IF l_trolin_rec.to_locator_id = FND_API.G_MISS_NUM THEN

Line 3641: 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);

3637: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3638: fnd_msg_pub.ADD;
3639: END IF;
3640: ELSE
3641: 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);
3642:
3643: IF l_trolin_rec.to_subinventory_code = fnd_api.g_miss_char THEN
3644: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3645: END IF;

Line 3660: 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);

3656: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3657: fnd_msg_pub.ADD;
3658: END IF;
3659: ELSE
3660: 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);
3661:
3662: IF l_trolin_rec.to_subinventory_id = fnd_api.g_miss_num THEN
3663: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3664: END IF;

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

3674: fnd_message.set_token('ATTRIBUTE', 'transaction_header');
3675: fnd_msg_pub.ADD;
3676: END IF;
3677: ELSE
3678: l_trolin_rec.transaction_header_id := inv_value_to_id.transaction_header(p_transaction_header => p_trolin_val_rec.transaction_header);
3679:
3680: IF l_trolin_rec.transaction_header_id = fnd_api.g_miss_num THEN
3681: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3682: END IF;

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

3692: fnd_message.set_token('ATTRIBUTE', 'transaction_type');
3693: fnd_msg_pub.ADD;
3694: END IF;
3695: ELSE
3696: l_trolin_rec.transaction_type_id := inv_value_to_id.transaction_type(p_transaction_type => p_trolin_val_rec.transaction_type);
3697:
3698: IF l_trolin_rec.transaction_type_id = fnd_api.g_miss_num THEN
3699: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3700: END IF;

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

3712: fnd_msg_pub.ADD;
3713: END IF;
3714: ELSE
3715: -- Line2917
3716: l_trolin_rec.uom_code := inv_value_to_id.uom(p_uom => p_trolin_val_rec.uom);
3717:
3718: IF l_trolin_rec.uom_code = fnd_api.g_miss_char THEN
3719: l_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3720: END IF;