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_EBI_ITEM_HELPER dependencies on FND_MESSAGE

Line 300: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');

296: );
297: INV_EBI_UTIL.debug_line('STEP 20: ORG ID '|| x_item.main_obj_type.organization_id);
298: l_pk_col_name_val_pairs.TRIM(1);
299: IF (x_item.main_obj_type.organization_id IS NULL) THEN
300: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
301: FND_MESSAGE.set_token('COL_VALUE', p_Item.main_obj_type.organization_code);
302: FND_MSG_PUB.add;
303: RAISE FND_API.g_exc_error;
304: END IF;

Line 301: FND_MESSAGE.set_token('COL_VALUE', p_Item.main_obj_type.organization_code);

297: INV_EBI_UTIL.debug_line('STEP 20: ORG ID '|| x_item.main_obj_type.organization_id);
298: l_pk_col_name_val_pairs.TRIM(1);
299: IF (x_item.main_obj_type.organization_id IS NULL) THEN
300: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
301: FND_MESSAGE.set_token('COL_VALUE', p_Item.main_obj_type.organization_code);
302: FND_MSG_PUB.add;
303: RAISE FND_API.g_exc_error;
304: END IF;
305: END IF;

Line 333: FND_MESSAGE.set_name('INV','INV_TEMPLATE_ERROR');

329: INV_EBI_UTIL.debug_line('STEP 40: TEMPLATE ID '|| x_item.main_obj_type.template_id);
330: l_pk_col_name_val_pairs.TRIM(1);
331:
332: IF (x_item.main_obj_type.template_id IS NULL) THEN
333: FND_MESSAGE.set_name('INV','INV_TEMPLATE_ERROR');
334: FND_MSG_PUB.add;
335: RAISE FND_API.g_exc_error;
336: END IF;
337: END IF;

Line 351: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');

347: );
348: INV_EBI_UTIL.debug_line('STEP 50: ORG ID '|| x_item.org_id_obj_type(i).org_id);
349: l_pk_col_name_val_pairs.TRIM(1);
350: IF (x_item.org_id_obj_type(i).org_id IS NULL) THEN
351: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
352: FND_MESSAGE.set_token('COL_VALUE', p_item.org_id_obj_type(i).org_code);
353: FND_MSG_PUB.add;
354: RAISE FND_API.g_exc_error;
355: END IF;

Line 352: FND_MESSAGE.set_token('COL_VALUE', p_item.org_id_obj_type(i).org_code);

348: INV_EBI_UTIL.debug_line('STEP 50: ORG ID '|| x_item.org_id_obj_type(i).org_id);
349: l_pk_col_name_val_pairs.TRIM(1);
350: IF (x_item.org_id_obj_type(i).org_id IS NULL) THEN
351: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
352: FND_MESSAGE.set_token('COL_VALUE', p_item.org_id_obj_type(i).org_code);
353: FND_MSG_PUB.add;
354: RAISE FND_API.g_exc_error;
355: END IF;
356: END IF;

Line 372: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');

368: );
369: INV_EBI_UTIL.debug_line('STEP 60: CATALOG GROUP ID '|| x_item.main_obj_type.item_catalog_group_id);
370: l_pk_col_name_val_pairs.TRIM(1);
371: IF (x_item.main_obj_type.item_catalog_group_id IS NULL ) THEN
372: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
373: FND_MESSAGE.set_token('COL_VALUE',p_item.main_obj_type.item_catalog_group_code);
374: FND_MSG_PUB.add;
375: RAISE FND_API.g_exc_error;
376: END IF;

Line 373: FND_MESSAGE.set_token('COL_VALUE',p_item.main_obj_type.item_catalog_group_code);

369: INV_EBI_UTIL.debug_line('STEP 60: CATALOG GROUP ID '|| x_item.main_obj_type.item_catalog_group_id);
370: l_pk_col_name_val_pairs.TRIM(1);
371: IF (x_item.main_obj_type.item_catalog_group_id IS NULL ) THEN
372: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
373: FND_MESSAGE.set_token('COL_VALUE',p_item.main_obj_type.item_catalog_group_code);
374: FND_MSG_PUB.add;
375: RAISE FND_API.g_exc_error;
376: END IF;
377: END IF;

Line 683: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_UOM');

679: flag:=0;
680: flag1:=0;
681: IF(validate_uom(uom_conv_details(j).to_uom)=FND_API.G_FALSE) THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_UOM');
684: FND_MESSAGE.set_token('UOM', uom_conv_details(j).to_uom);
685: FND_MSG_PUB.add;
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;

Line 684: FND_MESSAGE.set_token('UOM', uom_conv_details(j).to_uom);

680: flag1:=0;
681: IF(validate_uom(uom_conv_details(j).to_uom)=FND_API.G_FALSE) THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_UOM');
684: FND_MESSAGE.set_token('UOM', uom_conv_details(j).to_uom);
685: FND_MSG_PUB.add;
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688: IF(validate_uom(uom_conv_details(j).from_uom)=FND_API.G_FALSE) THEN

Line 690: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_UOM');

686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688: IF(validate_uom(uom_conv_details(j).from_uom)=FND_API.G_FALSE) THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_UOM');
691: FND_MESSAGE.set_token('UOM', uom_conv_details(j).from_uom);
692: FND_MSG_PUB.add;
693: RAISE fnd_api.g_exc_unexpected_error;
694: END IF;

Line 691: FND_MESSAGE.set_token('UOM', uom_conv_details(j).from_uom);

687: END IF;
688: IF(validate_uom(uom_conv_details(j).from_uom)=FND_API.G_FALSE) THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_UOM');
691: FND_MESSAGE.set_token('UOM', uom_conv_details(j).from_uom);
692: FND_MSG_PUB.add;
693: RAISE fnd_api.g_exc_unexpected_error;
694: END IF;
695: select UOM_CLASS into l_class1 from MTL_UNITS_OF_MEASURE where UOM_CODE=uom_conv_details(j).to_uom;

Line 764: FND_MESSAGE.set_name('INV','INV_EBI_MISMATCH_CONV_RATE');

760: l_conv_rate_from_unit1_to_bu1 :=1;
761: check_conversion(l_conv_rate_from_unit1_to_bu1,uom_conv_details(j).conversion_rate,l_convrate_from_unit_to_bu,l_conv_rate_from_bu2_to_bu1,l_ret);
762: if( l_ret = 'E') then
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: FND_MESSAGE.set_name('INV','INV_EBI_MISMATCH_CONV_RATE');
765: FND_MESSAGE.set_token('UOM1',uom_conv_details(j).from_uom);
766: FND_MESSAGE.set_token('UOM2',uom_conv_details(j).to_uom);
767: FND_MSG_PUB.add;
768: RAISE fnd_api.g_exc_unexpected_error;

Line 765: FND_MESSAGE.set_token('UOM1',uom_conv_details(j).from_uom);

761: check_conversion(l_conv_rate_from_unit1_to_bu1,uom_conv_details(j).conversion_rate,l_convrate_from_unit_to_bu,l_conv_rate_from_bu2_to_bu1,l_ret);
762: if( l_ret = 'E') then
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: FND_MESSAGE.set_name('INV','INV_EBI_MISMATCH_CONV_RATE');
765: FND_MESSAGE.set_token('UOM1',uom_conv_details(j).from_uom);
766: FND_MESSAGE.set_token('UOM2',uom_conv_details(j).to_uom);
767: FND_MSG_PUB.add;
768: RAISE fnd_api.g_exc_unexpected_error;
769: end if;

Line 766: FND_MESSAGE.set_token('UOM2',uom_conv_details(j).to_uom);

762: if( l_ret = 'E') then
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: FND_MESSAGE.set_name('INV','INV_EBI_MISMATCH_CONV_RATE');
765: FND_MESSAGE.set_token('UOM1',uom_conv_details(j).from_uom);
766: FND_MESSAGE.set_token('UOM2',uom_conv_details(j).to_uom);
767: FND_MSG_PUB.add;
768: RAISE fnd_api.g_exc_unexpected_error;
769: end if;
770: else

Line 783: FND_MESSAGE.set_name('INV','INV_EBI_MISMATCH_CONV_RATE');

779: else
780: check_conversion(l_conv_rate_from_unit1_to_bu1,uom_conv_details(j).conversion_rate,l_convrate_from_unit_to_bu,l_conv_rate_from_bu2_to_bu1,l_ret);
781: if( l_ret = 'E') THEN
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: FND_MESSAGE.set_name('INV','INV_EBI_MISMATCH_CONV_RATE');
784: FND_MSG_PUB.add;
785: RAISE fnd_api.g_exc_unexpected_error;
786: end if;
787: end if ;

Line 1642: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NUM_NULL');

1638: ,p_segment20 => l_item.main_obj_type.segment20
1639: );
1640: END IF;
1641: IF l_item_number IS NULL THEN
1642: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NUM_NULL');
1643: FND_MSG_PUB.add;
1644: RAISE FND_API.g_exc_error;
1645: END IF;
1646: IF p_operation = INV_EBI_ITEM_PUB.g_otype_sync THEN

Line 1700: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');

1696: AND ir2.effectivity_date <= sysdate
1697: AND ir2.implementation_date IS NOT NULL)
1698: OR ir.effectivity_date > sysdate);
1699: IF l_revised_item_exists = 0 then
1700: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');
1701: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1702: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1703: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1704: FND_MSG_PUB.add;

Line 1701: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);

1697: AND ir2.implementation_date IS NOT NULL)
1698: OR ir.effectivity_date > sysdate);
1699: IF l_revised_item_exists = 0 then
1700: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');
1701: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1702: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1703: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1704: FND_MSG_PUB.add;
1705: RAISE FND_API.g_exc_error;

Line 1702: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);

1698: OR ir.effectivity_date > sysdate);
1699: IF l_revised_item_exists = 0 then
1700: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');
1701: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1702: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1703: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1704: FND_MSG_PUB.add;
1705: RAISE FND_API.g_exc_error;
1706: END IF;

Line 1703: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);

1699: IF l_revised_item_exists = 0 then
1700: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');
1701: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1702: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1703: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1704: FND_MSG_PUB.add;
1705: RAISE FND_API.g_exc_error;
1706: END IF;
1707: END IF;

Line 1763: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');

1759: );
1760: FETCH c_item_description INTO l_description;
1761:
1762: IF(c_item_description%NOTFOUND) THEN
1763: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
1764: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1765: FND_MSG_PUB.add;
1766: RAISE FND_API.g_exc_error;
1767: END IF;

Line 1764: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);

1760: FETCH c_item_description INTO l_description;
1761:
1762: IF(c_item_description%NOTFOUND) THEN
1763: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
1764: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1765: FND_MSG_PUB.add;
1766: RAISE FND_API.g_exc_error;
1767: END IF;
1768:

Line 1789: FND_MESSAGE.set_name('INV','INV_EBI_ICC_CONFG_FOR_NIR');

1785: ) = fnd_api.g_true ) THEN
1786:
1787: IF(l_item.bom_obj_type.eng_item_flag ='N' ) THEN
1788:
1789: FND_MESSAGE.set_name('INV','INV_EBI_ICC_CONFG_FOR_NIR');
1790: FND_MESSAGE.set_token('ITEM',l_item.main_obj_type.item_number);
1791: FND_MESSAGE.set_token('ITEM_CATALOG', l_item.main_obj_type.item_catalog_group_code);
1792: FND_MSG_PUB.add;
1793: RAISE FND_API.g_exc_error;

Line 1790: FND_MESSAGE.set_token('ITEM',l_item.main_obj_type.item_number);

1786:
1787: IF(l_item.bom_obj_type.eng_item_flag ='N' ) THEN
1788:
1789: FND_MESSAGE.set_name('INV','INV_EBI_ICC_CONFG_FOR_NIR');
1790: FND_MESSAGE.set_token('ITEM',l_item.main_obj_type.item_number);
1791: FND_MESSAGE.set_token('ITEM_CATALOG', l_item.main_obj_type.item_catalog_group_code);
1792: FND_MSG_PUB.add;
1793: RAISE FND_API.g_exc_error;
1794:

Line 1791: FND_MESSAGE.set_token('ITEM_CATALOG', l_item.main_obj_type.item_catalog_group_code);

1787: IF(l_item.bom_obj_type.eng_item_flag ='N' ) THEN
1788:
1789: FND_MESSAGE.set_name('INV','INV_EBI_ICC_CONFG_FOR_NIR');
1790: FND_MESSAGE.set_token('ITEM',l_item.main_obj_type.item_number);
1791: FND_MESSAGE.set_token('ITEM_CATALOG', l_item.main_obj_type.item_catalog_group_code);
1792: FND_MSG_PUB.add;
1793: RAISE FND_API.g_exc_error;
1794:
1795: ELSIF(l_item.bom_obj_type.eng_item_flag = fnd_api.g_miss_char OR l_item.bom_obj_type.eng_item_flag IS NULL ) THEN

Line 2762: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_REVISION_CODE_NULL');

2758: WHERE inventory_item_id = p_inventory_item_id
2759: AND organization_id = p_organization_id
2760: AND revision = p_revision_code;
2761: ELSE
2762: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_REVISION_CODE_NULL');
2763: FND_MSG_PUB.add;
2764: RAISE FND_API.g_exc_error;
2765: END IF;
2766: ELSE

Line 3042: FND_MESSAGE.set_name('INV','INV_IOI_ITEM_UPDATE_PRIV');

3038: ,p_instance_pk1_value => p_inventory_item_id
3039: ,p_instance_pk2_value => p_organization_id
3040: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'
3041: THEN
3042: FND_MESSAGE.set_name('INV','INV_IOI_ITEM_UPDATE_PRIV');
3043: FND_MSG_PUB.add;
3044: RAISE FND_API.g_EXC_ERROR;
3045: ELSE
3046: INV_ITEM_CATEGORY_PUB.Update_Category_Assignment(

Line 3211: FND_MESSAGE.set_name('INV',' INV_ITEM_CAT_ASSIGN_NO_MULT');

3207: ELSIF l_no_multi_assign_cat_set_tbl IS NOT NULL AND l_no_multi_assign_cat_set_tbl.COUNT > 0
3208: AND table_of_number_contains(l_no_multi_assign_cat_set_tbl, p_category_id_tbl(i).cat_set_id) THEN
3209: -- fail if multiple category assignments are coming in for the category set
3210: -- with multi assign disabled
3211: FND_MESSAGE.set_name('INV',' INV_ITEM_CAT_ASSIGN_NO_MULT');
3212: FND_MSG_PUB.add;
3213: RAISE FND_API.g_exc_unexpected_error;
3214: END IF;
3215: END IF;

Line 3543: FND_MESSAGE.set_name('INV_EBI','INV_EBI_PART_NUM_NULL');

3539: END IF;
3540: END IF;
3541: CLOSE c_mfg_part_num;
3542: ELSE
3543: FND_MESSAGE.set_name('INV_EBI','INV_EBI_PART_NUM_NULL');
3544: FND_MESSAGE.set_token('PART_NUM', p_mfg_part_obj.mfg_part_num);
3545: FND_MSG_PUB.add;
3546: RAISE FND_API.g_exc_error;
3547: END IF;

Line 3544: FND_MESSAGE.set_token('PART_NUM', p_mfg_part_obj.mfg_part_num);

3540: END IF;
3541: CLOSE c_mfg_part_num;
3542: ELSE
3543: FND_MESSAGE.set_name('INV_EBI','INV_EBI_PART_NUM_NULL');
3544: FND_MESSAGE.set_token('PART_NUM', p_mfg_part_obj.mfg_part_num);
3545: FND_MSG_PUB.add;
3546: RAISE FND_API.g_exc_error;
3547: END IF;
3548: IF FND_API.to_boolean( p_commit ) THEN

Line 4108: FND_MESSAGE.set_name('INV','INV_EBI_MFG_NOT_EXIST');

4104: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING INV_EBI_ITEM_HELPER.process_part_num_association STATUS: '|| l_out.output_status.return_status);
4105: ELSE
4106:
4107: --If manufcaturer does not exist raise exception
4108: FND_MESSAGE.set_name('INV','INV_EBI_MFG_NOT_EXIST');
4109: IF l_mfg_part_num_obj.manufacturer_name IS NULL THEN
4110: l_pk_col_name_val_pairs.EXTEND(1);
4111: l_pk_col_name_val_pairs(1).name := 'manufacturer_id';
4112: l_pk_col_name_val_pairs(1).value := l_mfg_part_num_obj.manufacturer_id;

Line 4119: FND_MESSAGE.set_token('MFG_NAME', l_mfg_part_num_obj.manufacturer_name);

4115: ,p_entity_name => G_MANUFACTURER
4116: );
4117: l_pk_col_name_val_pairs.TRIM(1);
4118: END IF;
4119: FND_MESSAGE.set_token('MFG_NAME', l_mfg_part_num_obj.manufacturer_name);
4120: FND_MSG_PUB.add;
4121: RAISE FND_API.g_exc_error;
4122: END IF;
4123: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

Line 4507: FND_MESSAGE.set_name('INV','INV_EBI_NO_ITEM_ID_NAME');

4503: BEGIN
4504: FND_MSG_PUB.initialize();
4505: IF((p_get_opr_attrs_rec.item_id IS NULL) AND
4506: (p_get_opr_attrs_rec.item_name IS NULL)) THEN
4507: FND_MESSAGE.set_name('INV','INV_EBI_NO_ITEM_ID_NAME');
4508: FND_MSG_PUB.add;
4509: RAISE FND_API.G_EXC_ERROR;
4510: ELSIF((p_get_opr_attrs_rec.organization_id IS NULL) AND
4511: (p_get_opr_attrs_rec.organization_code IS NULL))THEN

Line 4512: FND_MESSAGE.set_name('INV','INV_EBI_NO_ORGID_ORGCODE');

4508: FND_MSG_PUB.add;
4509: RAISE FND_API.G_EXC_ERROR;
4510: ELSIF((p_get_opr_attrs_rec.organization_id IS NULL) AND
4511: (p_get_opr_attrs_rec.organization_code IS NULL))THEN
4512: FND_MESSAGE.set_name('INV','INV_EBI_NO_ORGID_ORGCODE');
4513: FND_MSG_PUB.add;
4514: RAISE FND_API.G_EXC_ERROR;
4515: ELSE
4516: x_status := FND_API.G_RET_STS_SUCCESS;

Line 4881: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');

4877: );
4878:
4879: IF(l_application_id IS NULL ) THEN
4880:
4881: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
4882: FND_MESSAGE.set_token('COL_VALUE', 'EGO');
4883: FND_MSG_PUB.add;
4884: RAISE FND_API.g_exc_error;
4885: END IF;

Line 4882: FND_MESSAGE.set_token('COL_VALUE', 'EGO');

4878:
4879: IF(l_application_id IS NULL ) THEN
4880:
4881: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
4882: FND_MESSAGE.set_token('COL_VALUE', 'EGO');
4883: FND_MSG_PUB.add;
4884: RAISE FND_API.g_exc_error;
4885: END IF;
4886:

Line 5176: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');

5172: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
5173: ,p_entity_name=> INV_EBI_ITEM_HELPER.G_ORGANIZATION
5174: );
5175: IF (l_org_id IS NULL) THEN
5176: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
5177: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_code);
5178: FND_MSG_PUB.add;
5179: RAISE FND_API.G_EXC_ERROR;
5180: END IF;

Line 5177: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_code);

5173: ,p_entity_name=> INV_EBI_ITEM_HELPER.G_ORGANIZATION
5174: );
5175: IF (l_org_id IS NULL) THEN
5176: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
5177: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_code);
5178: FND_MSG_PUB.add;
5179: RAISE FND_API.G_EXC_ERROR;
5180: END IF;
5181: END IF;

Line 5194: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');

5190: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
5191: ,p_entity_name=> INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM
5192: );
5193: IF (l_item_id IS NULL ) THEN
5194: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
5195: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_name);
5196: FND_MSG_PUB.add;
5197: RAISE FND_API.G_EXC_ERROR;
5198: END IF;

Line 5195: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_name);

5191: ,p_entity_name=> INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM
5192: );
5193: IF (l_item_id IS NULL ) THEN
5194: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
5195: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_name);
5196: FND_MSG_PUB.add;
5197: RAISE FND_API.G_EXC_ERROR;
5198: END IF;
5199: END IF;

Line 6314: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');

6310: l_entity_count := l_entity_count +1;
6311: l_valid_item_tbl.EXTEND();
6312: l_valid_item_tbl(l_entity_count) := l_item_tbl(i);
6313: ELSE
6314: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
6315: FND_MESSAGE.set_token('COL_VALUE', l_item_tbl(i));
6316: FND_MSG_PUB.add;
6317: RAISE FND_API.G_EXC_ERROR;
6318: END IF;

Line 6315: FND_MESSAGE.set_token('COL_VALUE', l_item_tbl(i));

6311: l_valid_item_tbl.EXTEND();
6312: l_valid_item_tbl(l_entity_count) := l_item_tbl(i);
6313: ELSE
6314: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
6315: FND_MESSAGE.set_token('COL_VALUE', l_item_tbl(i));
6316: FND_MSG_PUB.add;
6317: RAISE FND_API.G_EXC_ERROR;
6318: END IF;
6319: EXCEPTION

Line 6347: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');

6343: l_entity_count := l_entity_count +1;
6344: l_valid_org_tbl.EXTEND();
6345: l_valid_org_tbl(l_entity_count) := l_org_tbl(i);
6346: ELSE
6347: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
6348: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
6349: FND_MSG_PUB.add;
6350: RAISE FND_API.G_EXC_ERROR;
6351: END IF;

Line 6348: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));

6344: l_valid_org_tbl.EXTEND();
6345: l_valid_org_tbl(l_entity_count) := l_org_tbl(i);
6346: ELSE
6347: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
6348: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
6349: FND_MSG_PUB.add;
6350: RAISE FND_API.G_EXC_ERROR;
6351: END IF;
6352: EXCEPTION

Line 6411: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');

6407: END LOOP;
6408: END IF;
6409:
6410: IF l_count = 0 THEN
6411: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
6412: FND_MESSAGE.set_token('USER_INPUT', l_valid_item_tbl(i));
6413: FND_MSG_PUB.add;
6414: RAISE FND_API.G_EXC_ERROR;
6415: END IF;

Line 6412: FND_MESSAGE.set_token('USER_INPUT', l_valid_item_tbl(i));

6408: END IF;
6409:
6410: IF l_count = 0 THEN
6411: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
6412: FND_MESSAGE.set_token('USER_INPUT', l_valid_item_tbl(i));
6413: FND_MSG_PUB.add;
6414: RAISE FND_API.G_EXC_ERROR;
6415: END IF;
6416: EXCEPTION