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 274: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');

270: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
271: );
272: l_pk_col_name_val_pairs.TRIM(1);
273: IF (x_item.main_obj_type.organization_id IS NULL) THEN
274: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
275: FND_MESSAGE.set_token('COL_VALUE', p_Item.main_obj_type.organization_code);
276: FND_MSG_PUB.add;
277: RAISE FND_API.g_exc_error;
278: END IF;

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

271: );
272: l_pk_col_name_val_pairs.TRIM(1);
273: IF (x_item.main_obj_type.organization_id IS NULL) THEN
274: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
275: FND_MESSAGE.set_token('COL_VALUE', p_Item.main_obj_type.organization_code);
276: FND_MSG_PUB.add;
277: RAISE FND_API.g_exc_error;
278: END IF;
279: END IF;

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

312: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
313: );
314: l_pk_col_name_val_pairs.TRIM(1);
315: IF (x_item.org_id_obj_type(i).org_id IS NULL) THEN
316: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
317: FND_MESSAGE.set_token('COL_VALUE', p_item.org_id_obj_type(i).org_code);
318: FND_MSG_PUB.add;
319: RAISE FND_API.g_exc_error;
320: END IF;

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

313: );
314: l_pk_col_name_val_pairs.TRIM(1);
315: IF (x_item.org_id_obj_type(i).org_id IS NULL) THEN
316: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
317: FND_MESSAGE.set_token('COL_VALUE', p_item.org_id_obj_type(i).org_code);
318: FND_MSG_PUB.add;
319: RAISE FND_API.g_exc_error;
320: END IF;
321: END IF;

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

332: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ITEM_CATALOG_GROUP
333: );
334: l_pk_col_name_val_pairs.TRIM(1);
335: IF (x_item.main_obj_type.item_catalog_group_id IS NULL ) THEN
336: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
337: FND_MESSAGE.set_token('COL_VALUE',p_item.main_obj_type.item_catalog_group_code);
338: FND_MSG_PUB.add;
339: RAISE FND_API.g_exc_error;
340: END IF;

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

333: );
334: l_pk_col_name_val_pairs.TRIM(1);
335: IF (x_item.main_obj_type.item_catalog_group_id IS NULL ) THEN
336: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
337: FND_MESSAGE.set_token('COL_VALUE',p_item.main_obj_type.item_catalog_group_code);
338: FND_MSG_PUB.add;
339: RAISE FND_API.g_exc_error;
340: END IF;
341: END IF;

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

1227: ,p_segment20 => l_item.main_obj_type.segment20
1228: );
1229: END IF;
1230: IF l_item_number IS NULL THEN
1231: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NUM_NULL');
1232: FND_MSG_PUB.add;
1233: RAISE FND_API.g_exc_error;
1234: END IF;
1235: IF p_operation = INV_EBI_ITEM_PUB.g_otype_sync THEN

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

1285: AND ir2.effectivity_date <= sysdate
1286: AND ir2.implementation_date IS NOT NULL)
1287: OR ir.effectivity_date > sysdate);
1288: IF l_revised_item_exists = 0 then
1289: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');
1290: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1291: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1292: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1293: FND_MSG_PUB.add;

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

1286: AND ir2.implementation_date IS NOT NULL)
1287: OR ir.effectivity_date > sysdate);
1288: IF l_revised_item_exists = 0 then
1289: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');
1290: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1291: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1292: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1293: FND_MSG_PUB.add;
1294: RAISE FND_API.g_exc_error;

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

1287: OR ir.effectivity_date > sysdate);
1288: IF l_revised_item_exists = 0 then
1289: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');
1290: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1291: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1292: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1293: FND_MSG_PUB.add;
1294: RAISE FND_API.g_exc_error;
1295: END IF;

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

1288: IF l_revised_item_exists = 0 then
1289: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');
1290: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1291: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1292: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1293: FND_MSG_PUB.add;
1294: RAISE FND_API.g_exc_error;
1295: END IF;
1296: END IF;

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

1320: ,p_organization_id => l_master_org
1321: );
1322: FETCH c_item_description INTO l_description;
1323: IF(c_item_description%NOTFOUND) THEN
1324: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
1325: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1326: FND_MSG_PUB.add;
1327: RAISE FND_API.g_exc_error;
1328: END IF;

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

1321: );
1322: FETCH c_item_description INTO l_description;
1323: IF(c_item_description%NOTFOUND) THEN
1324: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
1325: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1326: FND_MSG_PUB.add;
1327: RAISE FND_API.g_exc_error;
1328: END IF;
1329: l_item.main_obj_type.description := l_description;

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

1993: WHERE inventory_item_id = p_inventory_item_id
1994: AND organization_id = p_organization_id
1995: AND revision = p_revision_code;
1996: ELSE
1997: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_REVISION_CODE_NULL');
1998: FND_MSG_PUB.add;
1999: RAISE FND_API.g_exc_error;
2000: END IF;
2001: ELSE

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

2518: END IF;
2519: END IF;
2520: CLOSE c_mfg_part_num;
2521: ELSE
2522: FND_MESSAGE.set_name('INV_EBI','INV_EBI_PART_NUM_NULL');
2523: FND_MESSAGE.set_token('PART_NUM', p_mfg_part_obj.mfg_part_num);
2524: FND_MSG_PUB.add;
2525: RAISE FND_API.g_exc_error;
2526: END IF;

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

2519: END IF;
2520: CLOSE c_mfg_part_num;
2521: ELSE
2522: FND_MESSAGE.set_name('INV_EBI','INV_EBI_PART_NUM_NULL');
2523: FND_MESSAGE.set_token('PART_NUM', p_mfg_part_obj.mfg_part_num);
2524: FND_MSG_PUB.add;
2525: RAISE FND_API.g_exc_error;
2526: END IF;
2527: IF FND_API.to_boolean( p_commit ) THEN

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

2680: );
2681: ELSE
2682:
2683: --If manufcaturer does not exist raise exception
2684: FND_MESSAGE.set_name('INV','INV_EBI_MFG_NOT_EXIST');
2685: IF l_mfg_part_num_obj.manufacturer_name IS NULL THEN
2686: l_pk_col_name_val_pairs.EXTEND(1);
2687: l_pk_col_name_val_pairs(1).name := 'manufacturer_id';
2688: l_pk_col_name_val_pairs(1).value := l_mfg_part_num_obj.manufacturer_id;

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

2691: ,p_entity_name => G_MANUFACTURER
2692: );
2693: l_pk_col_name_val_pairs.TRIM(1);
2694: END IF;
2695: FND_MESSAGE.set_token('MFG_NAME', l_mfg_part_num_obj.manufacturer_name);
2696: FND_MSG_PUB.add;
2697: RAISE FND_API.g_exc_error;
2698: END IF;
2699: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

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

3062: BEGIN
3063: FND_MSG_PUB.initialize();
3064: IF((p_get_opr_attrs_rec.item_id IS NULL) AND
3065: (p_get_opr_attrs_rec.item_name IS NULL)) THEN
3066: FND_MESSAGE.set_name('INV','INV_EBI_NO_ITEM_ID_NAME');
3067: FND_MSG_PUB.add;
3068: RAISE FND_API.G_EXC_ERROR;
3069: ELSIF((p_get_opr_attrs_rec.organization_id IS NULL) AND
3070: (p_get_opr_attrs_rec.organization_code IS NULL))THEN

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

3067: FND_MSG_PUB.add;
3068: RAISE FND_API.G_EXC_ERROR;
3069: ELSIF((p_get_opr_attrs_rec.organization_id IS NULL) AND
3070: (p_get_opr_attrs_rec.organization_code IS NULL))THEN
3071: FND_MESSAGE.set_name('INV','INV_EBI_NO_ORGID_ORGCODE');
3072: FND_MSG_PUB.add;
3073: RAISE FND_API.G_EXC_ERROR;
3074: ELSE
3075: x_status := FND_API.G_RET_STS_SUCCESS;

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

3361: );
3362:
3363: IF(l_application_id IS NULL ) THEN
3364:
3365: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
3366: FND_MESSAGE.set_token('COL_VALUE', 'EGO');
3367: FND_MSG_PUB.add;
3368: RAISE FND_API.g_exc_error;
3369: END IF;

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

3362:
3363: IF(l_application_id IS NULL ) THEN
3364:
3365: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
3366: FND_MESSAGE.set_token('COL_VALUE', 'EGO');
3367: FND_MSG_PUB.add;
3368: RAISE FND_API.g_exc_error;
3369: END IF;
3370:

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

3650: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
3651: ,p_entity_name=> INV_EBI_ITEM_HELPER.G_ORGANIZATION
3652: );
3653: IF (l_org_id IS NULL) THEN
3654: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
3655: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_code);
3656: FND_MSG_PUB.add;
3657: RAISE FND_API.G_EXC_ERROR;
3658: END IF;

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

3651: ,p_entity_name=> INV_EBI_ITEM_HELPER.G_ORGANIZATION
3652: );
3653: IF (l_org_id IS NULL) THEN
3654: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
3655: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_code);
3656: FND_MSG_PUB.add;
3657: RAISE FND_API.G_EXC_ERROR;
3658: END IF;
3659: END IF;

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

3668: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
3669: ,p_entity_name=> INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM
3670: );
3671: IF (l_item_id IS NULL ) THEN
3672: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
3673: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_name);
3674: FND_MSG_PUB.add;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;

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

3669: ,p_entity_name=> INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM
3670: );
3671: IF (l_item_id IS NULL ) THEN
3672: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
3673: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_name);
3674: FND_MSG_PUB.add;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: END IF;

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

4771: l_entity_count := l_entity_count +1;
4772: l_valid_item_tbl.EXTEND();
4773: l_valid_item_tbl(l_entity_count) := l_item_tbl(i);
4774: ELSE
4775: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
4776: FND_MESSAGE.set_token('COL_VALUE', l_item_tbl(i));
4777: FND_MSG_PUB.add;
4778: RAISE FND_API.G_EXC_ERROR;
4779: END IF;

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

4772: l_valid_item_tbl.EXTEND();
4773: l_valid_item_tbl(l_entity_count) := l_item_tbl(i);
4774: ELSE
4775: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
4776: FND_MESSAGE.set_token('COL_VALUE', l_item_tbl(i));
4777: FND_MSG_PUB.add;
4778: RAISE FND_API.G_EXC_ERROR;
4779: END IF;
4780: EXCEPTION

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

4804: l_entity_count := l_entity_count +1;
4805: l_valid_org_tbl.EXTEND();
4806: l_valid_org_tbl(l_entity_count) := l_org_tbl(i);
4807: ELSE
4808: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
4809: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
4810: FND_MSG_PUB.add;
4811: RAISE FND_API.G_EXC_ERROR;
4812: END IF;

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

4805: l_valid_org_tbl.EXTEND();
4806: l_valid_org_tbl(l_entity_count) := l_org_tbl(i);
4807: ELSE
4808: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
4809: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
4810: FND_MSG_PUB.add;
4811: RAISE FND_API.G_EXC_ERROR;
4812: END IF;
4813: EXCEPTION

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

4868: END LOOP;
4869: END IF;
4870:
4871: IF l_count = 0 THEN
4872: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
4873: FND_MESSAGE.set_token('USER_INPUT', l_valid_item_tbl(i));
4874: FND_MSG_PUB.add;
4875: RAISE FND_API.G_EXC_ERROR;
4876: END IF;

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

4869: END IF;
4870:
4871: IF l_count = 0 THEN
4872: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
4873: FND_MESSAGE.set_token('USER_INPUT', l_valid_item_tbl(i));
4874: FND_MSG_PUB.add;
4875: RAISE FND_API.G_EXC_ERROR;
4876: END IF;
4877: EXCEPTION