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

Line 187: fnd_message.Set_Name( 'INV', 'Cannot_Lock_Item_rec' );

183: -- row locking exception
184: --
185: WHEN FND_API.g_EXC_ THEN
186: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
187: fnd_message.Set_Name( 'INV', 'Cannot_Lock_Item_rec' );
188: FND_MSG_PUB.Add;
189: RAISE;
190: */
191:

Line 203: fnd_message.Set_Name( 'INV', 'Cannot_Lock_Item_rec' );

199: CLOSE INV_ITEM_API.Item_TL_csr;
200: END IF;
201:
202: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
203: fnd_message.Set_Name( 'INV', 'Cannot_Lock_Item_rec' );
204: FND_MSG_PUB.Add;
205: RAISE;
206:
207: END Lock_Org_Items;

Line 323: fnd_message.SET_NAME( 'INV', 'INV_MISS_OrgItem_ID' );

319:
320: IF ( p_Item_ID IS NULL ) OR
321: ( p_Org_ID IS NULL )
322: THEN
323: fnd_message.SET_NAME( 'INV', 'INV_MISS_OrgItem_ID' );
324: FND_MSG_PUB.Add;
325: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
326: END IF;
327:

Line 336: fnd_message.SET_NAME( 'INV', 'INV_MISS_Item_rec' );

332: /*
333: -- Check if item record has any attribute values assigned
334: --
335: IF ( INV_ITEM_Lib.Is_Item_rec_Missing( p_Item_rec ) ) THEN
336: fnd_message.SET_NAME( 'INV', 'INV_MISS_Item_rec' );
337: FND_MSG_PUB.Add;
338: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
339: END IF;
340: */

Line 383: fnd_message.SET_NAME( 'INV', 'INV_Update_Org_Items_notfound' );

379: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
380:
381: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
382: CLOSE INV_ITEM_API.Item_csr;
383: fnd_message.SET_NAME( 'INV', 'INV_Update_Org_Items_notfound' );
384: FND_MSG_PUB.Add;
385: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
386: END IF;
387:

Line 429: fnd_message.SET_NAME('INV', 'INVALID_INV_STK_FLAG_COMB');

425: IF ( FND_API.to_Boolean (p_validate_Master) ) THEN
426:
427: IF (l_Item_rec.inventory_item_flag ='N' AND
428: l_Item_rec.stock_enabled_flag ='Y' ) THEN
429: fnd_message.SET_NAME('INV', 'INVALID_INV_STK_FLAG_COMB');
430: FND_MSG_PUB.Add;
431: l_return_status := FND_API.g_RET_STS_ERROR;
432: ELSIF (l_Item_rec.stock_enabled_flag ='N' AND
433: l_Item_rec.mtl_transactions_enabled_flag ='Y' )THEN

Line 434: fnd_message.SET_NAME('INV', 'INVALID_STK_TRX_FLAG_COMB');

430: FND_MSG_PUB.Add;
431: l_return_status := FND_API.g_RET_STS_ERROR;
432: ELSIF (l_Item_rec.stock_enabled_flag ='N' AND
433: l_Item_rec.mtl_transactions_enabled_flag ='Y' )THEN
434: fnd_message.SET_NAME('INV', 'INVALID_STK_TRX_FLAG_COMB');
435: FND_MSG_PUB.Add;
436: l_return_status := FND_API.g_RET_STS_ERROR;
437: ELSIF (l_Item_rec.purchasing_item_flag ='N' AND
438: l_Item_rec.purchasing_enabled_flag ='Y' )THEN

Line 439: fnd_message.SET_NAME('INV', 'INVALID_PI_PE_FLAG_COMB');

435: FND_MSG_PUB.Add;
436: l_return_status := FND_API.g_RET_STS_ERROR;
437: ELSIF (l_Item_rec.purchasing_item_flag ='N' AND
438: l_Item_rec.purchasing_enabled_flag ='Y' )THEN
439: fnd_message.SET_NAME('INV', 'INVALID_PI_PE_FLAG_COMB');
440: FND_MSG_PUB.Add;
441: l_return_status := FND_API.g_RET_STS_ERROR;
442: ELSIF (l_Item_rec.customer_order_flag ='N' AND
443: l_Item_rec.customer_order_enabled_flag ='Y' )THEN

Line 444: fnd_message.SET_NAME('INV', 'INVALID_CO_COE_FLAG_COMB');

440: FND_MSG_PUB.Add;
441: l_return_status := FND_API.g_RET_STS_ERROR;
442: ELSIF (l_Item_rec.customer_order_flag ='N' AND
443: l_Item_rec.customer_order_enabled_flag ='Y' )THEN
444: fnd_message.SET_NAME('INV', 'INVALID_CO_COE_FLAG_COMB');
445: FND_MSG_PUB.Add;
446: l_return_status := FND_API.g_RET_STS_ERROR;
447: ELSIF (l_Item_rec.internal_order_flag ='N' AND
448: l_Item_rec.internal_order_enabled_flag ='Y' )THEN

Line 449: fnd_message.SET_NAME('INV', 'INVALID_IO_IOE_FLAG_COMB');

445: FND_MSG_PUB.Add;
446: l_return_status := FND_API.g_RET_STS_ERROR;
447: ELSIF (l_Item_rec.internal_order_flag ='N' AND
448: l_Item_rec.internal_order_enabled_flag ='Y' )THEN
449: fnd_message.SET_NAME('INV', 'INVALID_IO_IOE_FLAG_COMB');
450: FND_MSG_PUB.Add;
451: l_return_status := FND_API.g_RET_STS_ERROR;
452: /** Bug: 3546140 Removed for PLM RBOM
453: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND

Line 456: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

452: /** Bug: 3546140 Removed for PLM RBOM
453: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND
454: l_Item_rec.contract_item_type_code IS NULL AND
455: l_Item_rec.bom_enabled_flag = 'Y') THEN
456: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
457: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_BOM_ENABLED', TRUE);
458: FND_MSG_PUB.Add;
459: l_return_status := FND_API.g_RET_STS_ERROR;
460: ***/

Line 457: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_BOM_ENABLED', TRUE);

453: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND
454: l_Item_rec.contract_item_type_code IS NULL AND
455: l_Item_rec.bom_enabled_flag = 'Y') THEN
456: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
457: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_BOM_ENABLED', TRUE);
458: FND_MSG_PUB.Add;
459: l_return_status := FND_API.g_RET_STS_ERROR;
460: ***/
461: ELSIF ( ( l_item_rec.inventory_item_flag = 'N'

Line 464: FND_MESSAGE.Set_Name ('INV', 'INVALID_INV_WIP_FLAG_COMB');

460: ***/
461: ELSIF ( ( l_item_rec.inventory_item_flag = 'N'
462: OR l_item_rec.bom_item_type <> 4 )
463: AND l_Item_rec.build_in_wip_flag ='Y' ) THEN
464: FND_MESSAGE.Set_Name ('INV', 'INVALID_INV_WIP_FLAG_COMB');
465: FND_MSG_PUB.Add;
466: l_return_status := FND_API.g_RET_STS_ERROR;
467:
468: ELSIF ( l_Item_rec.EFFECTIVITY_CONTROL = 2 ) AND

Line 470: fnd_message.SET_NAME('INV', 'ITM-EFFC-INVALID SERIAL CTRL-2');

466: l_return_status := FND_API.g_RET_STS_ERROR;
467:
468: ELSIF ( l_Item_rec.EFFECTIVITY_CONTROL = 2 ) AND
469: ( l_Item_rec.SERIAL_NUMBER_CONTROL_CODE NOT IN (2, 5) ) THEN
470: fnd_message.SET_NAME('INV', 'ITM-EFFC-INVALID SERIAL CTRL-2');
471: FND_MSG_PUB.Add;
472: l_return_status := FND_API.g_RET_STS_ERROR;
473:
474: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND

Line 476: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

472: l_return_status := FND_API.g_RET_STS_ERROR;
473:
474: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND
475: nvl(l_Item_rec.comms_nl_trackable_flag,'N') = 'N') THEN
476: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
477: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_IB_TRACKING_SERVICEABLE', TRUE);
478: FND_MSG_PUB.Add;
479: l_return_status := FND_API.g_RET_STS_ERROR;
480: --Added for 11.5.10 validations

Line 477: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_IB_TRACKING_SERVICEABLE', TRUE);

473:
474: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND
475: nvl(l_Item_rec.comms_nl_trackable_flag,'N') = 'N') THEN
476: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
477: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_IB_TRACKING_SERVICEABLE', TRUE);
478: FND_MSG_PUB.Add;
479: l_return_status := FND_API.g_RET_STS_ERROR;
480: --Added for 11.5.10 validations
481: ELSE

Line 496: fnd_message.SET_NAME ('INV', 'INV_INVALID_VMI_COMB');

492: NVL(l_Item_rec.stock_enabled_flag,'N') = 'N'))
493: OR
494: (l_consign_enabled = 1 AND NVL(l_Item_rec.inventory_asset_flag,'N') = 'N')
495: ) THEN
496: fnd_message.SET_NAME ('INV', 'INV_INVALID_VMI_COMB');
497: FND_MSG_PUB.Add;
498: l_return_status := FND_API.g_RET_STS_ERROR;
499: END IF;
500: END IF;

Line 555: fnd_message.Set_Name( 'INV', 'Master_Attribute.COUNT <> 0' );

551: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
552: END IF;
553: /*
554: ELSE
555: fnd_message.Set_Name( 'INV', 'Master_Attribute.COUNT <> 0' );
556: FND_MSG_PUB.Add;
557: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
558: */
559:

Line 2293: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');

2289: -- Invalid attribute code
2290: --------------------------
2291: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2292:
2293: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');
2294: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);
2295: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);
2296: FND_MESSAGE.Set_Token ('ATTRIBUTE_CODE', l_Attribute_Code);
2297: FND_MSG_PUB.Add;

Line 2294: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);

2290: --------------------------
2291: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2292:
2293: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');
2294: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);
2295: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);
2296: FND_MESSAGE.Set_Token ('ATTRIBUTE_CODE', l_Attribute_Code);
2297: FND_MSG_PUB.Add;
2298: -- RETURN;

Line 2295: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);

2291: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2292:
2293: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');
2294: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);
2295: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);
2296: FND_MESSAGE.Set_Token ('ATTRIBUTE_CODE', l_Attribute_Code);
2297: FND_MSG_PUB.Add;
2298: -- RETURN;
2299: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

Line 2296: FND_MESSAGE.Set_Token ('ATTRIBUTE_CODE', l_Attribute_Code);

2292:
2293: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');
2294: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);
2295: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);
2296: FND_MESSAGE.Set_Token ('ATTRIBUTE_CODE', l_Attribute_Code);
2297: FND_MSG_PUB.Add;
2298: -- RETURN;
2299: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2300:

Line 2360: fnd_message.SET_NAME('INV', 'INVALID_INV_STK_FLAG_COMB');

2356: );
2357:
2358: IF (l_Item_rec.inventory_item_flag ='N' AND
2359: l_Item_rec.stock_enabled_flag ='Y' ) THEN
2360: fnd_message.SET_NAME('INV', 'INVALID_INV_STK_FLAG_COMB');
2361: FND_MSG_PUB.Add;
2362: l_return_status := FND_API.g_RET_STS_ERROR;
2363: ELSIF (l_Item_rec.stock_enabled_flag ='N' AND
2364: l_Item_rec.mtl_transactions_enabled_flag ='Y' )THEN

Line 2365: fnd_message.SET_NAME('INV', 'INVALID_STK_TRX_FLAG_COMB');

2361: FND_MSG_PUB.Add;
2362: l_return_status := FND_API.g_RET_STS_ERROR;
2363: ELSIF (l_Item_rec.stock_enabled_flag ='N' AND
2364: l_Item_rec.mtl_transactions_enabled_flag ='Y' )THEN
2365: fnd_message.SET_NAME('INV', 'INVALID_STK_TRX_FLAG_COMB');
2366: FND_MSG_PUB.Add;
2367: l_return_status := FND_API.g_RET_STS_ERROR;
2368: ELSIF (l_Item_rec.purchasing_item_flag ='N' AND
2369: l_Item_rec.purchasing_enabled_flag ='Y' )THEN

Line 2370: fnd_message.SET_NAME('INV', 'INVALID_PI_PE_FLAG_COMB');

2366: FND_MSG_PUB.Add;
2367: l_return_status := FND_API.g_RET_STS_ERROR;
2368: ELSIF (l_Item_rec.purchasing_item_flag ='N' AND
2369: l_Item_rec.purchasing_enabled_flag ='Y' )THEN
2370: fnd_message.SET_NAME('INV', 'INVALID_PI_PE_FLAG_COMB');
2371: FND_MSG_PUB.Add;
2372: l_return_status := FND_API.g_RET_STS_ERROR;
2373: ELSIF (l_Item_rec.customer_order_flag ='N' AND
2374: l_Item_rec.customer_order_enabled_flag ='Y' )THEN

Line 2375: fnd_message.SET_NAME('INV', 'INVALID_CO_COE_FLAG_COMB');

2371: FND_MSG_PUB.Add;
2372: l_return_status := FND_API.g_RET_STS_ERROR;
2373: ELSIF (l_Item_rec.customer_order_flag ='N' AND
2374: l_Item_rec.customer_order_enabled_flag ='Y' )THEN
2375: fnd_message.SET_NAME('INV', 'INVALID_CO_COE_FLAG_COMB');
2376: FND_MSG_PUB.Add;
2377: l_return_status := FND_API.g_RET_STS_ERROR;
2378:
2379: -- Added for Bug 5443289

Line 2382: fnd_message.SET_NAME('INV', 'INV_CUSTOMER');

2378:
2379: -- Added for Bug 5443289
2380: ELSIF (l_Item_rec.bom_item_type IN (3,5) AND
2381: l_Item_rec.customer_order_flag ='Y' )THEN
2382: fnd_message.SET_NAME('INV', 'INV_CUSTOMER');
2383: FND_MSG_PUB.Add;
2384: l_return_status := FND_API.g_RET_STS_ERROR;
2385: -- End of Bug 5443289
2386:

Line 2389: fnd_message.SET_NAME('INV', 'INVALID_IO_IOE_FLAG_COMB');

2385: -- End of Bug 5443289
2386:
2387: ELSIF (l_Item_rec.internal_order_flag ='N' AND
2388: l_Item_rec.internal_order_enabled_flag ='Y' )THEN
2389: fnd_message.SET_NAME('INV', 'INVALID_IO_IOE_FLAG_COMB');
2390: FND_MSG_PUB.Add;
2391: l_return_status := FND_API.g_RET_STS_ERROR;
2392: /** Bug: 3546140 Removed for PLM RBOM
2393: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND

Line 2396: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2392: /** Bug: 3546140 Removed for PLM RBOM
2393: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND
2394: l_Item_rec.contract_item_type_code IS NULL AND
2395: l_Item_rec.bom_enabled_flag = 'Y') THEN
2396: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2397: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_BOM_ENABLED', TRUE);
2398: FND_MSG_PUB.Add;
2399: l_return_status := FND_API.g_RET_STS_ERROR;
2400: ***/

Line 2397: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_BOM_ENABLED', TRUE);

2393: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND
2394: l_Item_rec.contract_item_type_code IS NULL AND
2395: l_Item_rec.bom_enabled_flag = 'Y') THEN
2396: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2397: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_BOM_ENABLED', TRUE);
2398: FND_MSG_PUB.Add;
2399: l_return_status := FND_API.g_RET_STS_ERROR;
2400: ***/
2401: ELSIF ( ( l_item_rec.inventory_item_flag = 'N'

Line 2404: FND_MESSAGE.Set_Name ('INV', 'INVALID_INV_WIP_FLAG_COMB');

2400: ***/
2401: ELSIF ( ( l_item_rec.inventory_item_flag = 'N'
2402: OR l_item_rec.bom_item_type <> 4 )
2403: AND l_Item_rec.build_in_wip_flag ='Y' ) THEN
2404: FND_MESSAGE.Set_Name ('INV', 'INVALID_INV_WIP_FLAG_COMB');
2405: FND_MSG_PUB.Add;
2406: l_return_status := FND_API.g_RET_STS_ERROR;
2407:
2408: ELSIF ( l_Item_rec.EFFECTIVITY_CONTROL = 2 ) AND

Line 2410: fnd_message.SET_NAME('INV', 'ITM-EFFC-INVALID SERIAL CTRL-2');

2406: l_return_status := FND_API.g_RET_STS_ERROR;
2407:
2408: ELSIF ( l_Item_rec.EFFECTIVITY_CONTROL = 2 ) AND
2409: ( l_Item_rec.SERIAL_NUMBER_CONTROL_CODE NOT IN (2, 5) ) THEN
2410: fnd_message.SET_NAME('INV', 'ITM-EFFC-INVALID SERIAL CTRL-2');
2411: FND_MSG_PUB.Add;
2412: l_return_status := FND_API.g_RET_STS_ERROR;
2413:
2414: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND

Line 2416: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2412: l_return_status := FND_API.g_RET_STS_ERROR;
2413:
2414: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND
2415: nvl(l_Item_rec.comms_nl_trackable_flag,'N') = 'N') THEN
2416: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2417: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_IB_TRACKING_SERVICEABLE', TRUE);
2418: FND_MSG_PUB.Add;
2419: l_return_status := FND_API.g_RET_STS_ERROR;
2420: --Added for 11.5.10 validations

Line 2417: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_IB_TRACKING_SERVICEABLE', TRUE);

2413:
2414: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND
2415: nvl(l_Item_rec.comms_nl_trackable_flag,'N') = 'N') THEN
2416: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2417: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_IB_TRACKING_SERVICEABLE', TRUE);
2418: FND_MSG_PUB.Add;
2419: l_return_status := FND_API.g_RET_STS_ERROR;
2420: --Added for 11.5.10 validations
2421: ELSIF ( (l_vmiorconsign_enabled = 1 AND

Line 2429: fnd_message.SET_NAME ('INV', 'INV_INVALID_VMI_COMB');

2425: NVL(l_Item_rec.stock_enabled_flag,'N') = 'N'))
2426: OR
2427: (l_consign_enabled = 1 AND NVL(l_Item_rec.inventory_asset_flag,'N') = 'N')
2428: ) THEN
2429: fnd_message.SET_NAME ('INV', 'INV_INVALID_VMI_COMB');
2430: FND_MSG_PUB.Add;
2431: l_return_status := FND_API.g_RET_STS_ERROR;
2432:
2433: /* R12 Attribute validations -Anmurali */

Line 2439: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2435:
2436: /* Changing this validation to exclude Process Org check -Bug 4902120 */
2437: ELSIF ((l_item_rec.bom_enabled_flag = 'Y' OR l_item_rec.bom_item_type IN (1,2)) AND
2438: l_item_rec.tracking_quantity_ind = 'PS') THEN
2439: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2440: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_TRACKING_OPM_BOM_ATTR', TRUE);
2441: FND_MSG_PUB.Add;
2442: l_return_status := FND_API.g_RET_STS_ERROR;
2443:

Line 2440: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_TRACKING_OPM_BOM_ATTR', TRUE);

2436: /* Changing this validation to exclude Process Org check -Bug 4902120 */
2437: ELSIF ((l_item_rec.bom_enabled_flag = 'Y' OR l_item_rec.bom_item_type IN (1,2)) AND
2438: l_item_rec.tracking_quantity_ind = 'PS') THEN
2439: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2440: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_TRACKING_OPM_BOM_ATTR', TRUE);
2441: FND_MSG_PUB.Add;
2442: l_return_status := FND_API.g_RET_STS_ERROR;
2443:
2444: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.grade_control_flag = 'Y' ) THEN

Line 2445: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2441: FND_MSG_PUB.Add;
2442: l_return_status := FND_API.g_RET_STS_ERROR;
2443:
2444: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.grade_control_flag = 'Y' ) THEN
2445: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2446: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_GRADE_CONTROL', TRUE);
2447: FND_MSG_PUB.Add;
2448: l_return_status := FND_API.g_RET_STS_ERROR;
2449:

Line 2446: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_GRADE_CONTROL', TRUE);

2442: l_return_status := FND_API.g_RET_STS_ERROR;
2443:
2444: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.grade_control_flag = 'Y' ) THEN
2445: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2446: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_GRADE_CONTROL', TRUE);
2447: FND_MSG_PUB.Add;
2448: l_return_status := FND_API.g_RET_STS_ERROR;
2449:
2450: ELSIF ( l_item_rec.grade_control_flag = 'N' AND l_item_rec.default_grade IS NOT NULL ) THEN

Line 2451: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2447: FND_MSG_PUB.Add;
2448: l_return_status := FND_API.g_RET_STS_ERROR;
2449:
2450: ELSIF ( l_item_rec.grade_control_flag = 'N' AND l_item_rec.default_grade IS NOT NULL ) THEN
2451: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2452: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_DEFAULT_GRADE_NULL', TRUE);
2453: FND_MSG_PUB.Add;
2454: l_return_status := FND_API.g_RET_STS_ERROR;
2455:

Line 2452: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_DEFAULT_GRADE_NULL', TRUE);

2448: l_return_status := FND_API.g_RET_STS_ERROR;
2449:
2450: ELSIF ( l_item_rec.grade_control_flag = 'N' AND l_item_rec.default_grade IS NOT NULL ) THEN
2451: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2452: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_DEFAULT_GRADE_NULL', TRUE);
2453: FND_MSG_PUB.Add;
2454: l_return_status := FND_API.g_RET_STS_ERROR;
2455:
2456: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_divisible_flag = 'Y' ) THEN

Line 2457: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2453: FND_MSG_PUB.Add;
2454: l_return_status := FND_API.g_RET_STS_ERROR;
2455:
2456: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_divisible_flag = 'Y' ) THEN
2457: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2458: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_DIVISIBLE', TRUE);
2459: FND_MSG_PUB.Add;
2460: l_return_status := FND_API.g_RET_STS_ERROR;
2461:

Line 2458: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_DIVISIBLE', TRUE);

2454: l_return_status := FND_API.g_RET_STS_ERROR;
2455:
2456: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_divisible_flag = 'Y' ) THEN
2457: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2458: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_DIVISIBLE', TRUE);
2459: FND_MSG_PUB.Add;
2460: l_return_status := FND_API.g_RET_STS_ERROR;
2461:
2462: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_split_enabled = 'Y' ) THEN

Line 2463: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2459: FND_MSG_PUB.Add;
2460: l_return_status := FND_API.g_RET_STS_ERROR;
2461:
2462: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_split_enabled = 'Y' ) THEN
2463: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2464: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_SPLIT_ENABLED', TRUE);
2465: FND_MSG_PUB.Add;
2466: l_return_status := FND_API.g_RET_STS_ERROR;
2467:

Line 2464: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_SPLIT_ENABLED', TRUE);

2460: l_return_status := FND_API.g_RET_STS_ERROR;
2461:
2462: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_split_enabled = 'Y' ) THEN
2463: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2464: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_SPLIT_ENABLED', TRUE);
2465: FND_MSG_PUB.Add;
2466: l_return_status := FND_API.g_RET_STS_ERROR;
2467:
2468: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.child_lot_flag = 'Y' ) THEN

Line 2469: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2465: FND_MSG_PUB.Add;
2466: l_return_status := FND_API.g_RET_STS_ERROR;
2467:
2468: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.child_lot_flag = 'Y' ) THEN
2469: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2470: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_CHILD_LOT_FLAG', TRUE);
2471: FND_MSG_PUB.Add;
2472: l_return_status := FND_API.g_RET_STS_ERROR;
2473:

Line 2470: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_CHILD_LOT_FLAG', TRUE);

2466: l_return_status := FND_API.g_RET_STS_ERROR;
2467:
2468: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.child_lot_flag = 'Y' ) THEN
2469: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2470: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_CHILD_LOT_FLAG', TRUE);
2471: FND_MSG_PUB.Add;
2472: l_return_status := FND_API.g_RET_STS_ERROR;
2473:
2474: /* Asset Management Attribute Group */

Line 2479: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2475:
2476: ELSIF (( l_item_rec.eam_item_type = 1 OR
2477: (l_item_rec.eam_item_type = 3 AND l_item_rec.serial_number_control_code <> 1 )) AND
2478: NVL(l_item_rec.comms_nl_trackable_flag , 'N') <> 'Y') THEN
2479: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2480: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_IB_TRACKABLE', TRUE);
2481: FND_MSG_PUB.Add;
2482: l_return_status := FND_API.g_RET_STS_ERROR;
2483:

Line 2480: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_IB_TRACKABLE', TRUE);

2476: ELSIF (( l_item_rec.eam_item_type = 1 OR
2477: (l_item_rec.eam_item_type = 3 AND l_item_rec.serial_number_control_code <> 1 )) AND
2478: NVL(l_item_rec.comms_nl_trackable_flag , 'N') <> 'Y') THEN
2479: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2480: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_IB_TRACKABLE', TRUE);
2481: FND_MSG_PUB.Add;
2482: l_return_status := FND_API.g_RET_STS_ERROR;
2483:
2484: ELSIF ( l_item_rec.eam_item_type = 2 AND l_item_rec.serial_number_control_code <> 1 ) THEN

Line 2485: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2481: FND_MSG_PUB.Add;
2482: l_return_status := FND_API.g_RET_STS_ERROR;
2483:
2484: ELSIF ( l_item_rec.eam_item_type = 2 AND l_item_rec.serial_number_control_code <> 1 ) THEN
2485: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2486: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ACTIVITY_NEVER_SERIAL', TRUE);
2487: FND_MSG_PUB.Add;
2488: l_return_status := FND_API.g_RET_STS_ERROR;
2489:

Line 2486: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ACTIVITY_NEVER_SERIAL', TRUE);

2482: l_return_status := FND_API.g_RET_STS_ERROR;
2483:
2484: ELSIF ( l_item_rec.eam_item_type = 2 AND l_item_rec.serial_number_control_code <> 1 ) THEN
2485: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2486: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ACTIVITY_NEVER_SERIAL', TRUE);
2487: FND_MSG_PUB.Add;
2488: l_return_status := FND_API.g_RET_STS_ERROR;
2489:
2490: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.serial_number_control_code NOT IN (2,5) ) THEN

Line 2491: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2487: FND_MSG_PUB.Add;
2488: l_return_status := FND_API.g_RET_STS_ERROR;
2489:
2490: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.serial_number_control_code NOT IN (2,5) ) THEN
2491: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2492: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_GRP_NO_SERIAL', TRUE);
2493: FND_MSG_PUB.Add;
2494: l_return_status := FND_API.g_RET_STS_ERROR;
2495:

Line 2492: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_GRP_NO_SERIAL', TRUE);

2488: l_return_status := FND_API.g_RET_STS_ERROR;
2489:
2490: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.serial_number_control_code NOT IN (2,5) ) THEN
2491: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2492: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_GRP_NO_SERIAL', TRUE);
2493: FND_MSG_PUB.Add;
2494: l_return_status := FND_API.g_RET_STS_ERROR;
2495:
2496: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.effectivity_control <> 2 ) THEN

Line 2497: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2493: FND_MSG_PUB.Add;
2494: l_return_status := FND_API.g_RET_STS_ERROR;
2495:
2496: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.effectivity_control <> 2 ) THEN
2497: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2498: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_UNIT_CONTROL', TRUE);
2499: FND_MSG_PUB.Add;
2500: l_return_status := FND_API.g_RET_STS_ERROR;
2501:

Line 2498: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_UNIT_CONTROL', TRUE);

2494: l_return_status := FND_API.g_RET_STS_ERROR;
2495:
2496: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.effectivity_control <> 2 ) THEN
2497: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2498: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_UNIT_CONTROL', TRUE);
2499: FND_MSG_PUB.Add;
2500: l_return_status := FND_API.g_RET_STS_ERROR;
2501:
2502: /* Purchasing Attribute Group */

Line 2506: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2502: /* Purchasing Attribute Group */
2503:
2504: ELSIF ( l_item_rec.purchasing_tax_code IS NOT NULL AND
2505: NVL(l_item_rec.taxable_flag,'N') <> 'Y') THEN
2506: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2507: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_NOT_TAXABLE_ITEM', TRUE);
2508: FND_MSG_PUB.Add;
2509: l_return_status := FND_API.g_RET_STS_ERROR;
2510:

Line 2507: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_NOT_TAXABLE_ITEM', TRUE);

2503:
2504: ELSIF ( l_item_rec.purchasing_tax_code IS NOT NULL AND
2505: NVL(l_item_rec.taxable_flag,'N') <> 'Y') THEN
2506: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2507: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_NOT_TAXABLE_ITEM', TRUE);
2508: FND_MSG_PUB.Add;
2509: l_return_status := FND_API.g_RET_STS_ERROR;
2510:
2511: ELSIF ( l_item_rec.outsourced_assembly = 1 AND

Line 2513: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2509: l_return_status := FND_API.g_RET_STS_ERROR;
2510:
2511: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2512: (l_process_enabled = 'Y' OR l_wms_enabled = 'Y' OR l_eam_enabled = 'Y') ) THEN
2513: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2514: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_ORG', TRUE);
2515: FND_MSG_PUB.Add;
2516: l_return_status := FND_API.g_RET_STS_ERROR;
2517:

Line 2514: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_ORG', TRUE);

2510:
2511: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2512: (l_process_enabled = 'Y' OR l_wms_enabled = 'Y' OR l_eam_enabled = 'Y') ) THEN
2513: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2514: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_ORG', TRUE);
2515: FND_MSG_PUB.Add;
2516: l_return_status := FND_API.g_RET_STS_ERROR;
2517:
2518: ELSIF ( NVL(l_item_rec.release_time_fence_code,6) <> 7 AND

Line 2521: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2517:
2518: ELSIF ( NVL(l_item_rec.release_time_fence_code,6) <> 7 AND
2519: NVL(l_trading_partner_org,'N') = 'Y' AND
2520: l_item_rec.outsourced_assembly = 1 ) THEN
2521: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2522: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_TP_TIME_FENSE', TRUE);
2523: FND_MSG_PUB.Add;
2524: l_return_status := FND_API.g_RET_STS_ERROR;
2525: -- Fix for bug#6447581

Line 2522: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_TP_TIME_FENSE', TRUE);

2518: ELSIF ( NVL(l_item_rec.release_time_fence_code,6) <> 7 AND
2519: NVL(l_trading_partner_org,'N') = 'Y' AND
2520: l_item_rec.outsourced_assembly = 1 ) THEN
2521: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2522: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_TP_TIME_FENSE', TRUE);
2523: FND_MSG_PUB.Add;
2524: l_return_status := FND_API.g_RET_STS_ERROR;
2525: -- Fix for bug#6447581
2526: -- ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_primary_cost_method <> 1) THEN

Line 2527: -- fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2523: FND_MSG_PUB.Add;
2524: l_return_status := FND_API.g_RET_STS_ERROR;
2525: -- Fix for bug#6447581
2526: -- ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_primary_cost_method <> 1) THEN
2527: -- fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2528: -- fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);
2529: -- FND_MSG_PUB.Add;
2530: -- l_return_status := FND_API.g_RET_STS_ERROR;
2531:

Line 2528: -- fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);

2524: l_return_status := FND_API.g_RET_STS_ERROR;
2525: -- Fix for bug#6447581
2526: -- ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_primary_cost_method <> 1) THEN
2527: -- fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2528: -- fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);
2529: -- FND_MSG_PUB.Add;
2530: -- l_return_status := FND_API.g_RET_STS_ERROR;
2531:
2532: ELSIF ( l_item_rec.outsourced_assembly = 1 AND

Line 2534: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2530: -- l_return_status := FND_API.g_RET_STS_ERROR;
2531:
2532: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2533: NOT(l_item_rec.bom_item_type = 4 AND l_item_rec.effectivity_control = 1) ) THEN
2534: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2535: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_BOM_ATTR', TRUE);
2536: FND_MSG_PUB.Add;
2537: l_return_status := FND_API.g_RET_STS_ERROR;
2538:

Line 2535: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_BOM_ATTR', TRUE);

2531:
2532: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2533: NOT(l_item_rec.bom_item_type = 4 AND l_item_rec.effectivity_control = 1) ) THEN
2534: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2535: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_BOM_ATTR', TRUE);
2536: FND_MSG_PUB.Add;
2537: l_return_status := FND_API.g_RET_STS_ERROR;
2538:
2539: ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_item_rec.outside_operation_flag = 'Y') THEN

Line 2540: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2536: FND_MSG_PUB.Add;
2537: l_return_status := FND_API.g_RET_STS_ERROR;
2538:
2539: ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_item_rec.outside_operation_flag = 'Y') THEN
2540: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2541: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_OUTSIDE_OPRN', TRUE);
2542: FND_MSG_PUB.Add;
2543: l_return_status := FND_API.g_RET_STS_ERROR;
2544:

Line 2541: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_OUTSIDE_OPRN', TRUE);

2537: l_return_status := FND_API.g_RET_STS_ERROR;
2538:
2539: ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_item_rec.outside_operation_flag = 'Y') THEN
2540: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2541: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_OUTSIDE_OPRN', TRUE);
2542: FND_MSG_PUB.Add;
2543: l_return_status := FND_API.g_RET_STS_ERROR;
2544:
2545: ELSIF ( l_item_rec.outsourced_assembly = 1 AND

Line 2548: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2544:
2545: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2546: ( l_item_rec.internal_order_flag ='Y' OR l_item_rec.internal_order_enabled_flag = 'Y' OR
2547: l_item_rec.pick_components_flag = 'Y' OR l_item_rec.replenish_to_order_flag = 'Y' ) ) THEN
2548: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2549: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_OM_ATTR', TRUE);
2550: FND_MSG_PUB.Add;
2551: l_return_status := FND_API.g_RET_STS_ERROR;
2552:

Line 2549: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_OM_ATTR', TRUE);

2545: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2546: ( l_item_rec.internal_order_flag ='Y' OR l_item_rec.internal_order_enabled_flag = 'Y' OR
2547: l_item_rec.pick_components_flag = 'Y' OR l_item_rec.replenish_to_order_flag = 'Y' ) ) THEN
2548: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2549: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_OM_ATTR', TRUE);
2550: FND_MSG_PUB.Add;
2551: l_return_status := FND_API.g_RET_STS_ERROR;
2552:
2553: /* General Planning Attribute Group */

Line 2558: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2554:
2555: ELSIF ( l_item_rec.mrp_safety_stock_code <> 1 AND
2556: l_item_rec.drp_planned_flag = 2 AND
2557: l_item_rec.mrp_planning_code IN (6,9) ) THEN
2558: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2559: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_SAFETY_STOCK', TRUE);
2560: FND_MSG_PUB.Add;
2561: l_return_status := FND_API.g_RET_STS_ERROR;
2562:

Line 2559: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_SAFETY_STOCK', TRUE);

2555: ELSIF ( l_item_rec.mrp_safety_stock_code <> 1 AND
2556: l_item_rec.drp_planned_flag = 2 AND
2557: l_item_rec.mrp_planning_code IN (6,9) ) THEN
2558: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2559: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_SAFETY_STOCK', TRUE);
2560: FND_MSG_PUB.Add;
2561: l_return_status := FND_API.g_RET_STS_ERROR;
2562:
2563: ELSIF ( l_item_rec.subcontracting_component IN (2,3) AND

Line 2567: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2563: ELSIF ( l_item_rec.subcontracting_component IN (2,3) AND
2564: (NOT (l_process_enabled = 'N' AND
2565: l_wms_enabled = 'N' AND
2566: l_eam_enabled = 'N' ) ) ) THEN
2567: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2568: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_ORG', TRUE);
2569: FND_MSG_PUB.Add;
2570: l_return_status := FND_API.g_RET_STS_ERROR;
2571:

Line 2568: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_ORG', TRUE);

2564: (NOT (l_process_enabled = 'N' AND
2565: l_wms_enabled = 'N' AND
2566: l_eam_enabled = 'N' ) ) ) THEN
2567: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2568: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_ORG', TRUE);
2569: FND_MSG_PUB.Add;
2570: l_return_status := FND_API.g_RET_STS_ERROR;
2571:
2572: ELSIF ( l_item_rec.subcontracting_component IN (2,3) AND l_primary_cost_method <> 1 ) THEN

Line 2573: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');

2569: FND_MSG_PUB.Add;
2570: l_return_status := FND_API.g_RET_STS_ERROR;
2571:
2572: ELSIF ( l_item_rec.subcontracting_component IN (2,3) AND l_primary_cost_method <> 1 ) THEN
2573: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2574: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);
2575: FND_MSG_PUB.Add;
2576: l_return_status := FND_API.g_RET_STS_ERROR;
2577:

Line 2574: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);

2570: l_return_status := FND_API.g_RET_STS_ERROR;
2571:
2572: ELSIF ( l_item_rec.subcontracting_component IN (2,3) AND l_primary_cost_method <> 1 ) THEN
2573: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2574: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);
2575: FND_MSG_PUB.Add;
2576: l_return_status := FND_API.g_RET_STS_ERROR;
2577:
2578: END IF;

Line 2599: fnd_message.SET_NAME('INV', 'INV_IOI_INVALID_TAX_CODE_ORG');

2595: AND ORGANIZATION_ID=l_Item_rec.organization_id))
2596: AND rownum = 1;
2597: EXCEPTION
2598: WHEN NO_DATA_FOUND THEN
2599: fnd_message.SET_NAME('INV', 'INV_IOI_INVALID_TAX_CODE_ORG');
2600: FND_MSG_PUB.Add;
2601: l_return_status := FND_API.g_RET_STS_ERROR;
2602: END;
2603: END IF;

Line 2623: fnd_message.SET_NAME('INV', 'INV_IOI_PUR_TAX_CODE');

2619: AND ORGANIZATION_ID=l_Item_rec.organization_id))
2620: AND rownum = 1;
2621: EXCEPTION
2622: WHEN NO_DATA_FOUND THEN
2623: fnd_message.SET_NAME('INV', 'INV_IOI_PUR_TAX_CODE');
2624: FND_MSG_PUB.Add;
2625: l_return_status := FND_API.g_RET_STS_ERROR;
2626: END;
2627: END IF;

Line 2759: fnd_message.SET_NAME( 'INV', 'INV_MISS_OrgItem_ID' );

2755: IF ( p_Item_ID IS NULL ) OR
2756: ( p_Org_ID IS NULL )
2757: THEN
2758: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2759: fnd_message.SET_NAME( 'INV', 'INV_MISS_OrgItem_ID' );
2760: FND_MSG_PUB.Add;
2761: RETURN;
2762: END IF;
2763:

Line 2790: fnd_message.SET_NAME( 'INV', 'INV_Get_Org_Item_notfound' );

2786: FETCH INV_ITEM_API.Item_csr INTO x_Item_rec;
2787:
2788: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
2789: CLOSE INV_ITEM_API.Item_csr;
2790: fnd_message.SET_NAME( 'INV', 'INV_Get_Org_Item_notfound' );
2791: FND_MSG_PUB.Add;
2792: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2793: END IF;
2794:

Line 2889: fnd_message.SET_NAME( 'INV', 'INV_MISS_OrgItem_ID' );

2885: IF ( l_Item_ID IS NULL ) OR
2886: ( l_Org_ID IS NULL )
2887: THEN
2888: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2889: fnd_message.SET_NAME( 'INV', 'INV_MISS_OrgItem_ID' );
2890: FND_MSG_PUB.Add;
2891: RETURN;
2892: END IF;
2893:

Line 4072: FND_MESSAGE.Set_Encoded (l_msg_data);

4068: ' END;'
4069: USING IN l_Inventory_Item_ID, IN l_Organization_ID, OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
4070:
4071: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
4072: FND_MESSAGE.Set_Encoded (l_msg_data);
4073: APP_EXCEPTION.Raise_Exception;
4074: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4075: FND_MESSAGE.Set_Encoded (l_msg_data);
4076: APP_EXCEPTION.Raise_Exception;

Line 4075: FND_MESSAGE.Set_Encoded (l_msg_data);

4071: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
4072: FND_MESSAGE.Set_Encoded (l_msg_data);
4073: APP_EXCEPTION.Raise_Exception;
4074: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4075: FND_MESSAGE.Set_Encoded (l_msg_data);
4076: APP_EXCEPTION.Raise_Exception;
4077: END IF;
4078:
4079: END IF;

Line 4183: fnd_message.SET_ENCODED( l_msg_data );

4179: ,x_msg_count => l_msg_count
4180: ,x_msg_data => l_msg_data);
4181:
4182: IF ( l_return_status = fnd_api.g_RET_STS_ERROR ) THEN
4183: fnd_message.SET_ENCODED( l_msg_data );
4184: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4185: ELSIF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
4186: fnd_message.SET_ENCODED( l_msg_data );
4187: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

Line 4186: fnd_message.SET_ENCODED( l_msg_data );

4182: IF ( l_return_status = fnd_api.g_RET_STS_ERROR ) THEN
4183: fnd_message.SET_ENCODED( l_msg_data );
4184: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4185: ELSIF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
4186: fnd_message.SET_ENCODED( l_msg_data );
4187: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4188: END IF;
4189:
4190: --

Line 4221: FND_MESSAGE.SET_NAME('INV','INV_SEC_UOM_MISMATCH_CLASS');

4217: END IF;
4218: CLOSE c_check_sec_uom_class;
4219: --raise error if item exists anywhere else with a different sec uom class
4220: IF (l_sec_uom_class <> p_secondary_uom_class) THEN
4221: FND_MESSAGE.SET_NAME('INV','INV_SEC_UOM_MISMATCH_CLASS');
4222: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4223: END IF;
4224:
4225: END check_mismatch_of_secuom_class;

Line 4298: FND_MESSAGE.SET_NAME('INV','INV_DUPLICATE_ITEM');

4294:
4295: FETCH c_get_item_count INTO l_item_count;
4296: CLOSE c_get_item_count;
4297: IF l_item_count > 0 THEN
4298: FND_MESSAGE.SET_NAME('INV','INV_DUPLICATE_ITEM');
4299: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4300: END IF;
4301: IF l_catalog_grp_id <> P_Item_Rec.item_catalog_group_id THEN
4302: FND_MESSAGE.SET_NAME( 'INV','INV_MISMATCH_CATALOG' );

Line 4302: FND_MESSAGE.SET_NAME( 'INV','INV_MISMATCH_CATALOG' );

4298: FND_MESSAGE.SET_NAME('INV','INV_DUPLICATE_ITEM');
4299: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4300: END IF;
4301: IF l_catalog_grp_id <> P_Item_Rec.item_catalog_group_id THEN
4302: FND_MESSAGE.SET_NAME( 'INV','INV_MISMATCH_CATALOG' );
4303: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4304: END IF;
4305:
4306: OPEN c_get_uom_class(cp_uom => l_unit_of_measure, cp_uom_code => NULL);

Line 4314: FND_MESSAGE.SET_NAME('INV','INV_MISMATCH_CLASS');

4310: FETCH c_get_uom_class INTO l_rec_uom_class;
4311: CLOSE c_get_uom_class;
4312:
4313: IF l_uom_class <> l_rec_uom_class THEN
4314: FND_MESSAGE.SET_NAME('INV','INV_MISMATCH_CLASS');
4315: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4316: END IF;
4317: --Jalaj Srivastava Bug 5017588
4318: --check for mismatch of sec uom class.

Line 4719: FND_MESSAGE.Set_Encoded (l_msg_data);

4715: ' END;'
4716: USING IN P_Item_Rec.INVENTORY_ITEM_ID, IN P_Item_Rec.ORGANIZATION_ID, OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
4717:
4718: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
4719: FND_MESSAGE.Set_Encoded (l_msg_data);
4720: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4721: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4722: FND_MESSAGE.Set_Encoded (l_msg_data);
4723: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

Line 4722: FND_MESSAGE.Set_Encoded (l_msg_data);

4718: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
4719: FND_MESSAGE.Set_Encoded (l_msg_data);
4720: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4721: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4722: FND_MESSAGE.Set_Encoded (l_msg_data);
4723: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4724: END IF;
4725: END IF;
4726:

Line 5174: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

5170: FETCH c_item_details INTO recinfo;
5171:
5172: IF (c_item_details%NOTFOUND) THEN
5173: CLOSE c_item_details;
5174: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
5175: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5176: END IF;
5177:
5178: CLOSE c_item_details;

Line 5836: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');

5832: OR ((recinfo.DEFAULT_MATERIAL_STATUS_ID is null) AND (P_Item_Rec.DEFAULT_MATERIAL_STATUS_ID is null)) )
5833: THEN
5834: NULL;
5835: ELSE
5836: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
5837: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5838: END IF;
5839:
5840:

Line 5851: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');

5847: OR ((item_tl.LONG_DESCRIPTION is null) AND (P_Item_Rec.LONG_DESCRIPTION is null))))
5848: THEN
5849: NULL;
5850: ELSE
5851: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
5852: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5853: END IF;
5854: END IF;
5855: END LOOP;

Line 6017: fnd_message.Set_Name( 'INV', 'INV_DESCR_TRAILING_SPACES' );

6013: l_longdesc_control := 0;
6014: end;
6015:
6016: if ((length(x_description)) <> length(rtrim(x_description))) then
6017: fnd_message.Set_Name( 'INV', 'INV_DESCR_TRAILING_SPACES' );
6018: app_exception.raise_exception;
6019: end if;
6020:
6021: if ((length(x_long_description)) <> length(rtrim(x_long_description))) then

Line 6022: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_TRAILING_SPACES' );

6018: app_exception.raise_exception;
6019: end if;
6020:
6021: if ((length(x_long_description)) <> length(rtrim(x_long_description))) then
6022: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_TRAILING_SPACES' );
6023: app_exception.raise_exception;
6024: return ;
6025: end if;
6026: /*

Line 6128: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

6124: FETCH c_item_name INTO recinfo;
6125:
6126: IF (c_item_name%NOTFOUND) THEN
6127: CLOSE c_item_name;
6128: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
6129: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
6130: END IF;
6131:
6132: CLOSE c_item_name;