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 350: fnd_message.SET_NAME( 'INV', 'INV_MISS_OrgItem_ID' );

346:
347: IF ( p_Item_ID IS NULL ) OR
348: ( p_Org_ID IS NULL )
349: THEN
350: fnd_message.SET_NAME( 'INV', 'INV_MISS_OrgItem_ID' );
351: FND_MSG_PUB.Add;
352: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
353: END IF;
354:

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

359: /*
360: -- Check if item record has any attribute values assigned
361: --
362: IF ( INV_ITEM_Lib.Is_Item_rec_Missing( p_Item_rec ) ) THEN
363: fnd_message.SET_NAME( 'INV', 'INV_MISS_Item_rec' );
364: FND_MSG_PUB.Add;
365: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
366: END IF;
367: */

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

406: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
407:
408: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
409: CLOSE INV_ITEM_API.Item_csr;
410: fnd_message.SET_NAME( 'INV', 'INV_Update_Org_Items_notfound' );
411: FND_MSG_PUB.Add;
412: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
413: END IF;
414:

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

452: IF ( FND_API.to_Boolean (p_validate_Master) ) THEN
453:
454: IF (l_Item_rec.inventory_item_flag ='N' AND
455: l_Item_rec.stock_enabled_flag ='Y' ) THEN
456: fnd_message.SET_NAME('INV', 'INVALID_INV_STK_FLAG_COMB');
457: FND_MSG_PUB.Add;
458: l_return_status := FND_API.g_RET_STS_ERROR;
459: ELSIF (l_Item_rec.stock_enabled_flag ='N' AND
460: l_Item_rec.mtl_transactions_enabled_flag ='Y' )THEN

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

457: FND_MSG_PUB.Add;
458: l_return_status := FND_API.g_RET_STS_ERROR;
459: ELSIF (l_Item_rec.stock_enabled_flag ='N' AND
460: l_Item_rec.mtl_transactions_enabled_flag ='Y' )THEN
461: fnd_message.SET_NAME('INV', 'INVALID_STK_TRX_FLAG_COMB');
462: FND_MSG_PUB.Add;
463: l_return_status := FND_API.g_RET_STS_ERROR;
464: --added for bug 8575398, pop up exception when check_shortages_flag = Y and transactions_enabled_flag = N
465: ELSIF (l_Item_rec.check_shortages_flag ='Y' AND

Line 467: fnd_message.SET_NAME('INV', 'INVALID_CHK_TRX_FLAG_COMB');

463: l_return_status := FND_API.g_RET_STS_ERROR;
464: --added for bug 8575398, pop up exception when check_shortages_flag = Y and transactions_enabled_flag = N
465: ELSIF (l_Item_rec.check_shortages_flag ='Y' AND
466: l_Item_rec.mtl_transactions_enabled_flag ='N' )THEN
467: fnd_message.SET_NAME('INV', 'INVALID_CHK_TRX_FLAG_COMB');
468: FND_MSG_PUB.Add;
469: l_return_status := FND_API.g_RET_STS_ERROR;
470: ELSIF (l_Item_rec.purchasing_item_flag ='N' AND
471: l_Item_rec.purchasing_enabled_flag ='Y' )THEN

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

468: FND_MSG_PUB.Add;
469: l_return_status := FND_API.g_RET_STS_ERROR;
470: ELSIF (l_Item_rec.purchasing_item_flag ='N' AND
471: l_Item_rec.purchasing_enabled_flag ='Y' )THEN
472: fnd_message.SET_NAME('INV', 'INVALID_PI_PE_FLAG_COMB');
473: FND_MSG_PUB.Add;
474: l_return_status := FND_API.g_RET_STS_ERROR;
475: ELSIF (l_Item_rec.customer_order_flag ='N' AND
476: l_Item_rec.customer_order_enabled_flag ='Y' )THEN

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

473: FND_MSG_PUB.Add;
474: l_return_status := FND_API.g_RET_STS_ERROR;
475: ELSIF (l_Item_rec.customer_order_flag ='N' AND
476: l_Item_rec.customer_order_enabled_flag ='Y' )THEN
477: fnd_message.SET_NAME('INV', 'INVALID_CO_COE_FLAG_COMB');
478: FND_MSG_PUB.Add;
479: l_return_status := FND_API.g_RET_STS_ERROR;
480: ELSIF (l_Item_rec.internal_order_flag ='N' AND
481: l_Item_rec.internal_order_enabled_flag ='Y' )THEN

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

478: FND_MSG_PUB.Add;
479: l_return_status := FND_API.g_RET_STS_ERROR;
480: ELSIF (l_Item_rec.internal_order_flag ='N' AND
481: l_Item_rec.internal_order_enabled_flag ='Y' )THEN
482: fnd_message.SET_NAME('INV', 'INVALID_IO_IOE_FLAG_COMB');
483: FND_MSG_PUB.Add;
484: l_return_status := FND_API.g_RET_STS_ERROR;
485: /** Bug: 3546140 Removed for PLM RBOM
486: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND

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

485: /** Bug: 3546140 Removed for PLM RBOM
486: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND
487: l_Item_rec.contract_item_type_code IS NULL AND
488: l_Item_rec.bom_enabled_flag = 'Y') THEN
489: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
490: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_BOM_ENABLED', TRUE);
491: FND_MSG_PUB.Add;
492: l_return_status := FND_API.g_RET_STS_ERROR;
493: ***/

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

486: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND
487: l_Item_rec.contract_item_type_code IS NULL AND
488: l_Item_rec.bom_enabled_flag = 'Y') THEN
489: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
490: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_BOM_ENABLED', TRUE);
491: FND_MSG_PUB.Add;
492: l_return_status := FND_API.g_RET_STS_ERROR;
493: ***/
494: ELSIF ( ( l_item_rec.inventory_item_flag = 'N'

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

493: ***/
494: ELSIF ( ( l_item_rec.inventory_item_flag = 'N'
495: OR l_item_rec.bom_item_type <> 4 )
496: AND l_Item_rec.build_in_wip_flag ='Y' ) THEN
497: FND_MESSAGE.Set_Name ('INV', 'INVALID_INV_WIP_FLAG_COMB');
498: FND_MSG_PUB.Add;
499: l_return_status := FND_API.g_RET_STS_ERROR;
500:
501: ELSIF ( l_Item_rec.EFFECTIVITY_CONTROL = 2 ) AND

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

499: l_return_status := FND_API.g_RET_STS_ERROR;
500:
501: ELSIF ( l_Item_rec.EFFECTIVITY_CONTROL = 2 ) AND
502: ( l_Item_rec.SERIAL_NUMBER_CONTROL_CODE NOT IN (2, 5) ) THEN
503: fnd_message.SET_NAME('INV', 'ITM-EFFC-INVALID SERIAL CTRL-2');
504: FND_MSG_PUB.Add;
505: l_return_status := FND_API.g_RET_STS_ERROR;
506:
507: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND

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

505: l_return_status := FND_API.g_RET_STS_ERROR;
506:
507: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND
508: nvl(l_Item_rec.comms_nl_trackable_flag,'N') = 'N') THEN
509: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
510: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_IB_TRACKING_SERVICEABLE', TRUE);
511: FND_MSG_PUB.Add;
512: l_return_status := FND_API.g_RET_STS_ERROR;
513: --Added for 11.5.10 validations

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

506:
507: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND
508: nvl(l_Item_rec.comms_nl_trackable_flag,'N') = 'N') THEN
509: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
510: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_IB_TRACKING_SERVICEABLE', TRUE);
511: FND_MSG_PUB.Add;
512: l_return_status := FND_API.g_RET_STS_ERROR;
513: --Added for 11.5.10 validations
514: ELSE

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

525: NVL(l_Item_rec.stock_enabled_flag,'N') = 'N'))
526: OR
527: (l_consign_enabled = 1 AND NVL(l_Item_rec.inventory_asset_flag,'N') = 'N')
528: ) THEN
529: fnd_message.SET_NAME ('INV', 'INV_INVALID_VMI_COMB');
530: FND_MSG_PUB.Add;
531: l_return_status := FND_API.g_RET_STS_ERROR;
532: END IF;
533: END IF;

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

584: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
585: END IF;
586: /*
587: ELSE
588: fnd_message.Set_Name( 'INV', 'Master_Attribute.COUNT <> 0' );
589: FND_MSG_PUB.Add;
590: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
591: */
592:

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

2404: -- Invalid attribute code
2405: --------------------------
2406: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2407:
2408: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');
2409: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);
2410: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);
2411: FND_MESSAGE.Set_Token ('ATTRIBUTE_CODE', l_Attribute_Code);
2412: FND_MSG_PUB.Add;

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

2405: --------------------------
2406: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2407:
2408: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');
2409: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);
2410: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);
2411: FND_MESSAGE.Set_Token ('ATTRIBUTE_CODE', l_Attribute_Code);
2412: FND_MSG_PUB.Add;
2413: -- RETURN;

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

2406: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2407:
2408: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');
2409: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);
2410: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);
2411: FND_MESSAGE.Set_Token ('ATTRIBUTE_CODE', l_Attribute_Code);
2412: FND_MSG_PUB.Add;
2413: -- RETURN;
2414: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

2407:
2408: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');
2409: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);
2410: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);
2411: FND_MESSAGE.Set_Token ('ATTRIBUTE_CODE', l_Attribute_Code);
2412: FND_MSG_PUB.Add;
2413: -- RETURN;
2414: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2415:

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

2596: );
2597:
2598: IF (l_Item_rec.inventory_item_flag ='N' AND
2599: l_Item_rec.stock_enabled_flag ='Y' ) THEN
2600: fnd_message.SET_NAME('INV', 'INVALID_INV_STK_FLAG_COMB');
2601: FND_MSG_PUB.Add;
2602: l_return_status := FND_API.g_RET_STS_ERROR;
2603: ELSIF (l_Item_rec.stock_enabled_flag ='N' AND
2604: l_Item_rec.mtl_transactions_enabled_flag ='Y' )THEN

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

2601: FND_MSG_PUB.Add;
2602: l_return_status := FND_API.g_RET_STS_ERROR;
2603: ELSIF (l_Item_rec.stock_enabled_flag ='N' AND
2604: l_Item_rec.mtl_transactions_enabled_flag ='Y' )THEN
2605: fnd_message.SET_NAME('INV', 'INVALID_STK_TRX_FLAG_COMB');
2606: FND_MSG_PUB.Add;
2607: l_return_status := FND_API.g_RET_STS_ERROR;
2608: --added for bug 8575398, pop up exception when check_shortages_flag = Y and transactions_enabled_flag = N
2609: ELSIF (l_Item_rec.check_shortages_flag ='Y' AND

Line 2611: fnd_message.SET_NAME('INV', 'INVALID_CHK_TRX_FLAG_COMB');

2607: l_return_status := FND_API.g_RET_STS_ERROR;
2608: --added for bug 8575398, pop up exception when check_shortages_flag = Y and transactions_enabled_flag = N
2609: ELSIF (l_Item_rec.check_shortages_flag ='Y' AND
2610: l_Item_rec.mtl_transactions_enabled_flag ='N' )THEN
2611: fnd_message.SET_NAME('INV', 'INVALID_CHK_TRX_FLAG_COMB');
2612: FND_MSG_PUB.Add;
2613: l_return_status := FND_API.g_RET_STS_ERROR;
2614: ELSIF (l_Item_rec.purchasing_item_flag ='N' AND
2615: l_Item_rec.purchasing_enabled_flag ='Y' )THEN

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

2612: FND_MSG_PUB.Add;
2613: l_return_status := FND_API.g_RET_STS_ERROR;
2614: ELSIF (l_Item_rec.purchasing_item_flag ='N' AND
2615: l_Item_rec.purchasing_enabled_flag ='Y' )THEN
2616: fnd_message.SET_NAME('INV', 'INVALID_PI_PE_FLAG_COMB');
2617: FND_MSG_PUB.Add;
2618: l_return_status := FND_API.g_RET_STS_ERROR;
2619: ELSIF (l_Item_rec.customer_order_flag ='N' AND
2620: l_Item_rec.customer_order_enabled_flag ='Y' )THEN

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

2617: FND_MSG_PUB.Add;
2618: l_return_status := FND_API.g_RET_STS_ERROR;
2619: ELSIF (l_Item_rec.customer_order_flag ='N' AND
2620: l_Item_rec.customer_order_enabled_flag ='Y' )THEN
2621: fnd_message.SET_NAME('INV', 'INVALID_CO_COE_FLAG_COMB');
2622: FND_MSG_PUB.Add;
2623: l_return_status := FND_API.g_RET_STS_ERROR;
2624:
2625: -- Added for Bug 5443289

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

2624:
2625: -- Added for Bug 5443289
2626: ELSIF (l_Item_rec.bom_item_type IN (3,5) AND
2627: l_Item_rec.customer_order_flag ='Y' )THEN
2628: fnd_message.SET_NAME('INV', 'INV_CUSTOMER');
2629: FND_MSG_PUB.Add;
2630: l_return_status := FND_API.g_RET_STS_ERROR;
2631: -- End of Bug 5443289
2632:

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

2631: -- End of Bug 5443289
2632:
2633: ELSIF (l_Item_rec.internal_order_flag ='N' AND
2634: l_Item_rec.internal_order_enabled_flag ='Y' )THEN
2635: fnd_message.SET_NAME('INV', 'INVALID_IO_IOE_FLAG_COMB');
2636: FND_MSG_PUB.Add;
2637: l_return_status := FND_API.g_RET_STS_ERROR;
2638: /** Bug: 3546140 Removed for PLM RBOM
2639: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND

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

2638: /** Bug: 3546140 Removed for PLM RBOM
2639: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND
2640: l_Item_rec.contract_item_type_code IS NULL AND
2641: l_Item_rec.bom_enabled_flag = 'Y') THEN
2642: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2643: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_BOM_ENABLED', TRUE);
2644: FND_MSG_PUB.Add;
2645: l_return_status := FND_API.g_RET_STS_ERROR;
2646: ***/

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

2639: ELSIF (l_Item_rec.inventory_item_flag = 'N' AND
2640: l_Item_rec.contract_item_type_code IS NULL AND
2641: l_Item_rec.bom_enabled_flag = 'Y') THEN
2642: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2643: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_BOM_ENABLED', TRUE);
2644: FND_MSG_PUB.Add;
2645: l_return_status := FND_API.g_RET_STS_ERROR;
2646: ***/
2647: ELSIF ( ( l_item_rec.inventory_item_flag = 'N'

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

2646: ***/
2647: ELSIF ( ( l_item_rec.inventory_item_flag = 'N'
2648: OR l_item_rec.bom_item_type <> 4 )
2649: AND l_Item_rec.build_in_wip_flag ='Y' ) THEN
2650: FND_MESSAGE.Set_Name ('INV', 'INVALID_INV_WIP_FLAG_COMB');
2651: FND_MSG_PUB.Add;
2652: l_return_status := FND_API.g_RET_STS_ERROR;
2653:
2654: ELSIF ( l_Item_rec.EFFECTIVITY_CONTROL = 2 ) AND

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

2652: l_return_status := FND_API.g_RET_STS_ERROR;
2653:
2654: ELSIF ( l_Item_rec.EFFECTIVITY_CONTROL = 2 ) AND
2655: ( l_Item_rec.SERIAL_NUMBER_CONTROL_CODE NOT IN (2, 5) ) THEN
2656: fnd_message.SET_NAME('INV', 'ITM-EFFC-INVALID SERIAL CTRL-2');
2657: FND_MSG_PUB.Add;
2658: l_return_status := FND_API.g_RET_STS_ERROR;
2659:
2660: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND

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

2658: l_return_status := FND_API.g_RET_STS_ERROR;
2659:
2660: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND
2661: nvl(l_Item_rec.comms_nl_trackable_flag,'N') = 'N') THEN
2662: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2663: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_IB_TRACKING_SERVICEABLE', TRUE);
2664: FND_MSG_PUB.Add;
2665: l_return_status := FND_API.g_RET_STS_ERROR;
2666: --Added for 11.5.10 validations

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

2659:
2660: ELSIF (l_Item_rec.serviceable_product_flag = 'Y' AND
2661: nvl(l_Item_rec.comms_nl_trackable_flag,'N') = 'N') THEN
2662: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2663: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_IB_TRACKING_SERVICEABLE', TRUE);
2664: FND_MSG_PUB.Add;
2665: l_return_status := FND_API.g_RET_STS_ERROR;
2666: --Added for 11.5.10 validations
2667: ELSIF ( (l_vmiorconsign_enabled = 1 AND

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

2671: NVL(l_Item_rec.stock_enabled_flag,'N') = 'N'))
2672: OR
2673: (l_consign_enabled = 1 AND NVL(l_Item_rec.inventory_asset_flag,'N') = 'N')
2674: ) THEN
2675: fnd_message.SET_NAME ('INV', 'INV_INVALID_VMI_COMB');
2676: FND_MSG_PUB.Add;
2677: l_return_status := FND_API.g_RET_STS_ERROR;
2678:
2679: /* R12 Attribute validations -Anmurali */

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

2682: /* Changing this validation to exclude Process Org check -Bug 4902120 */
2683: /*Comment the code to fix 7477872
2684: ELSIF ((l_item_rec.bom_enabled_flag = 'Y' OR l_item_rec.bom_item_type IN (1,2)) AND
2685: l_item_rec.tracking_quantity_ind = 'PS') THEN
2686: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2687: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_TRACKING_OPM_BOM_ATTR', TRUE);
2688: FND_MSG_PUB.Add;
2689: l_return_status := FND_API.g_RET_STS_ERROR;
2690:

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

2683: /*Comment the code to fix 7477872
2684: ELSIF ((l_item_rec.bom_enabled_flag = 'Y' OR l_item_rec.bom_item_type IN (1,2)) AND
2685: l_item_rec.tracking_quantity_ind = 'PS') THEN
2686: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2687: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_TRACKING_OPM_BOM_ATTR', TRUE);
2688: FND_MSG_PUB.Add;
2689: l_return_status := FND_API.g_RET_STS_ERROR;
2690:
2691: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.grade_control_flag = 'Y' ) THEN

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

2688: FND_MSG_PUB.Add;
2689: l_return_status := FND_API.g_RET_STS_ERROR;
2690:
2691: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.grade_control_flag = 'Y' ) THEN
2692: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2693: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_GRADE_CONTROL', TRUE);
2694: FND_MSG_PUB.Add;
2695: l_return_status := FND_API.g_RET_STS_ERROR;
2696: */

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

2689: l_return_status := FND_API.g_RET_STS_ERROR;
2690:
2691: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.grade_control_flag = 'Y' ) THEN
2692: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2693: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_GRADE_CONTROL', TRUE);
2694: FND_MSG_PUB.Add;
2695: l_return_status := FND_API.g_RET_STS_ERROR;
2696: */
2697:

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

2695: l_return_status := FND_API.g_RET_STS_ERROR;
2696: */
2697:
2698: ELSIF ( l_item_rec.grade_control_flag = 'N' AND l_item_rec.default_grade IS NOT NULL ) THEN
2699: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2700: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_DEFAULT_GRADE_NULL', TRUE);
2701: FND_MSG_PUB.Add;
2702: l_return_status := FND_API.g_RET_STS_ERROR;
2703: /* Bug #14232952, clear dependent field automatically if LOT CONTROL is NO CONTROL

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

2696: */
2697:
2698: ELSIF ( l_item_rec.grade_control_flag = 'N' AND l_item_rec.default_grade IS NOT NULL ) THEN
2699: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2700: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_DEFAULT_GRADE_NULL', TRUE);
2701: FND_MSG_PUB.Add;
2702: l_return_status := FND_API.g_RET_STS_ERROR;
2703: /* Bug #14232952, clear dependent field automatically if LOT CONTROL is NO CONTROL
2704: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_divisible_flag = 'Y' ) THEN

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

2701: FND_MSG_PUB.Add;
2702: l_return_status := FND_API.g_RET_STS_ERROR;
2703: /* Bug #14232952, clear dependent field automatically if LOT CONTROL is NO CONTROL
2704: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_divisible_flag = 'Y' ) THEN
2705: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2706: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_DIVISIBLE', TRUE);
2707: FND_MSG_PUB.Add;
2708: l_return_status := FND_API.g_RET_STS_ERROR;
2709: */

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

2702: l_return_status := FND_API.g_RET_STS_ERROR;
2703: /* Bug #14232952, clear dependent field automatically if LOT CONTROL is NO CONTROL
2704: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_divisible_flag = 'Y' ) THEN
2705: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2706: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_DIVISIBLE', TRUE);
2707: FND_MSG_PUB.Add;
2708: l_return_status := FND_API.g_RET_STS_ERROR;
2709: */
2710: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_split_enabled = 'Y' ) THEN

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

2707: FND_MSG_PUB.Add;
2708: l_return_status := FND_API.g_RET_STS_ERROR;
2709: */
2710: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_split_enabled = 'Y' ) THEN
2711: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2712: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_SPLIT_ENABLED', TRUE);
2713: FND_MSG_PUB.Add;
2714: l_return_status := FND_API.g_RET_STS_ERROR;
2715:

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

2708: l_return_status := FND_API.g_RET_STS_ERROR;
2709: */
2710: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.lot_split_enabled = 'Y' ) THEN
2711: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2712: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_SPLIT_ENABLED', TRUE);
2713: FND_MSG_PUB.Add;
2714: l_return_status := FND_API.g_RET_STS_ERROR;
2715:
2716: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.child_lot_flag = 'Y' ) THEN

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

2713: FND_MSG_PUB.Add;
2714: l_return_status := FND_API.g_RET_STS_ERROR;
2715:
2716: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.child_lot_flag = 'Y' ) THEN
2717: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2718: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_CHILD_LOT_FLAG', TRUE);
2719: FND_MSG_PUB.Add;
2720: l_return_status := FND_API.g_RET_STS_ERROR;
2721:

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

2714: l_return_status := FND_API.g_RET_STS_ERROR;
2715:
2716: ELSIF ( l_item_rec.lot_control_code = 1 AND l_item_rec.child_lot_flag = 'Y' ) THEN
2717: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2718: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_CHILD_LOT_FLAG', TRUE);
2719: FND_MSG_PUB.Add;
2720: l_return_status := FND_API.g_RET_STS_ERROR;
2721:
2722: /* Asset Management Attribute Group */

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

2723:
2724: ELSIF (( l_item_rec.eam_item_type = 1 OR
2725: (l_item_rec.eam_item_type = 3 AND l_item_rec.serial_number_control_code <> 1 )) AND
2726: NVL(l_item_rec.comms_nl_trackable_flag , 'N') <> 'Y') THEN
2727: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2728: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_IB_TRACKABLE', TRUE);
2729: FND_MSG_PUB.Add;
2730: l_return_status := FND_API.g_RET_STS_ERROR;
2731:

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

2724: ELSIF (( l_item_rec.eam_item_type = 1 OR
2725: (l_item_rec.eam_item_type = 3 AND l_item_rec.serial_number_control_code <> 1 )) AND
2726: NVL(l_item_rec.comms_nl_trackable_flag , 'N') <> 'Y') THEN
2727: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2728: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_IB_TRACKABLE', TRUE);
2729: FND_MSG_PUB.Add;
2730: l_return_status := FND_API.g_RET_STS_ERROR;
2731:
2732: ELSIF ( l_item_rec.eam_item_type = 2 AND l_item_rec.serial_number_control_code <> 1 ) THEN

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

2729: FND_MSG_PUB.Add;
2730: l_return_status := FND_API.g_RET_STS_ERROR;
2731:
2732: ELSIF ( l_item_rec.eam_item_type = 2 AND l_item_rec.serial_number_control_code <> 1 ) THEN
2733: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2734: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ACTIVITY_NEVER_SERIAL', TRUE);
2735: FND_MSG_PUB.Add;
2736: l_return_status := FND_API.g_RET_STS_ERROR;
2737:

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

2730: l_return_status := FND_API.g_RET_STS_ERROR;
2731:
2732: ELSIF ( l_item_rec.eam_item_type = 2 AND l_item_rec.serial_number_control_code <> 1 ) THEN
2733: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2734: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ACTIVITY_NEVER_SERIAL', TRUE);
2735: FND_MSG_PUB.Add;
2736: l_return_status := FND_API.g_RET_STS_ERROR;
2737:
2738: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.serial_number_control_code NOT IN (2,5) ) THEN

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

2735: FND_MSG_PUB.Add;
2736: l_return_status := FND_API.g_RET_STS_ERROR;
2737:
2738: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.serial_number_control_code NOT IN (2,5) ) THEN
2739: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2740: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_GRP_NO_SERIAL', TRUE);
2741: FND_MSG_PUB.Add;
2742: l_return_status := FND_API.g_RET_STS_ERROR;
2743:

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

2736: l_return_status := FND_API.g_RET_STS_ERROR;
2737:
2738: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.serial_number_control_code NOT IN (2,5) ) THEN
2739: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2740: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_GRP_NO_SERIAL', TRUE);
2741: FND_MSG_PUB.Add;
2742: l_return_status := FND_API.g_RET_STS_ERROR;
2743:
2744: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.effectivity_control <> 2 ) THEN

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

2741: FND_MSG_PUB.Add;
2742: l_return_status := FND_API.g_RET_STS_ERROR;
2743:
2744: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.effectivity_control <> 2 ) THEN
2745: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2746: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_UNIT_CONTROL', TRUE);
2747: FND_MSG_PUB.Add;
2748: l_return_status := FND_API.g_RET_STS_ERROR;
2749:

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

2742: l_return_status := FND_API.g_RET_STS_ERROR;
2743:
2744: ELSIF ( l_item_rec.eam_item_type = 1 AND l_item_rec.effectivity_control <> 2 ) THEN
2745: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2746: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_UNIT_CONTROL', TRUE);
2747: FND_MSG_PUB.Add;
2748: l_return_status := FND_API.g_RET_STS_ERROR;
2749:
2750: /* Purchasing Attribute Group */

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

2750: /* Purchasing Attribute Group */
2751:
2752: ELSIF ( l_item_rec.purchasing_tax_code IS NOT NULL AND
2753: NVL(l_item_rec.taxable_flag,'N') <> 'Y') THEN
2754: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2755: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_NOT_TAXABLE_ITEM', TRUE);
2756: FND_MSG_PUB.Add;
2757: l_return_status := FND_API.g_RET_STS_ERROR;
2758:

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

2751:
2752: ELSIF ( l_item_rec.purchasing_tax_code IS NOT NULL AND
2753: NVL(l_item_rec.taxable_flag,'N') <> 'Y') THEN
2754: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2755: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_NOT_TAXABLE_ITEM', TRUE);
2756: FND_MSG_PUB.Add;
2757: l_return_status := FND_API.g_RET_STS_ERROR;
2758:
2759: --

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

2763: -- ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2764: -- (l_process_enabled = 'Y' OR l_wms_enabled = 'Y' OR l_eam_enabled = 'Y') ) THEN
2765: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2766: (l_process_enabled = 'Y') ) THEN
2767: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2768: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_ORG', TRUE);
2769: FND_MSG_PUB.Add;
2770: l_return_status := FND_API.g_RET_STS_ERROR;
2771:

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

2764: -- (l_process_enabled = 'Y' OR l_wms_enabled = 'Y' OR l_eam_enabled = 'Y') ) THEN
2765: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2766: (l_process_enabled = 'Y') ) THEN
2767: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2768: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_ORG', TRUE);
2769: FND_MSG_PUB.Add;
2770: l_return_status := FND_API.g_RET_STS_ERROR;
2771:
2772: ELSIF ( NVL(l_item_rec.release_time_fence_code,6) <> 7 AND

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

2771:
2772: ELSIF ( NVL(l_item_rec.release_time_fence_code,6) <> 7 AND
2773: NVL(l_trading_partner_org,'N') = 'Y' AND
2774: l_item_rec.outsourced_assembly = 1 ) THEN
2775: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2776: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_TP_TIME_FENSE', TRUE);
2777: FND_MSG_PUB.Add;
2778: l_return_status := FND_API.g_RET_STS_ERROR;
2779: -- Fix for bug#6447581

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

2772: ELSIF ( NVL(l_item_rec.release_time_fence_code,6) <> 7 AND
2773: NVL(l_trading_partner_org,'N') = 'Y' AND
2774: l_item_rec.outsourced_assembly = 1 ) THEN
2775: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2776: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_TP_TIME_FENSE', TRUE);
2777: FND_MSG_PUB.Add;
2778: l_return_status := FND_API.g_RET_STS_ERROR;
2779: -- Fix for bug#6447581
2780: -- ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_primary_cost_method <> 1) THEN

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

2777: FND_MSG_PUB.Add;
2778: l_return_status := FND_API.g_RET_STS_ERROR;
2779: -- Fix for bug#6447581
2780: -- ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_primary_cost_method <> 1) THEN
2781: -- fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2782: -- fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);
2783: -- FND_MSG_PUB.Add;
2784: -- l_return_status := FND_API.g_RET_STS_ERROR;
2785:

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

2778: l_return_status := FND_API.g_RET_STS_ERROR;
2779: -- Fix for bug#6447581
2780: -- ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_primary_cost_method <> 1) THEN
2781: -- fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2782: -- fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);
2783: -- FND_MSG_PUB.Add;
2784: -- l_return_status := FND_API.g_RET_STS_ERROR;
2785:
2786: ELSIF ( l_item_rec.outsourced_assembly = 1 AND

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

2784: -- l_return_status := FND_API.g_RET_STS_ERROR;
2785:
2786: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2787: NOT(l_item_rec.bom_item_type = 4 AND l_item_rec.effectivity_control = 1) ) THEN
2788: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2789: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_BOM_ATTR', TRUE);
2790: FND_MSG_PUB.Add;
2791: l_return_status := FND_API.g_RET_STS_ERROR;
2792:

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

2785:
2786: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2787: NOT(l_item_rec.bom_item_type = 4 AND l_item_rec.effectivity_control = 1) ) THEN
2788: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2789: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_BOM_ATTR', TRUE);
2790: FND_MSG_PUB.Add;
2791: l_return_status := FND_API.g_RET_STS_ERROR;
2792:
2793: ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_item_rec.outside_operation_flag = 'Y') THEN

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

2790: FND_MSG_PUB.Add;
2791: l_return_status := FND_API.g_RET_STS_ERROR;
2792:
2793: ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_item_rec.outside_operation_flag = 'Y') THEN
2794: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2795: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_OUTSIDE_OPRN', TRUE);
2796: FND_MSG_PUB.Add;
2797: l_return_status := FND_API.g_RET_STS_ERROR;
2798:

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

2791: l_return_status := FND_API.g_RET_STS_ERROR;
2792:
2793: ELSIF ( l_item_rec.outsourced_assembly = 1 AND l_item_rec.outside_operation_flag = 'Y') THEN
2794: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2795: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_OUTSIDE_OPRN', TRUE);
2796: FND_MSG_PUB.Add;
2797: l_return_status := FND_API.g_RET_STS_ERROR;
2798:
2799: ELSIF ( l_item_rec.outsourced_assembly = 1 AND

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

2798:
2799: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2800: ( /*l_item_rec.internal_order_flag ='Y' OR l_item_rec.internal_order_enabled_flag = 'Y' OR*/-- Bug 9246127
2801: l_item_rec.pick_components_flag = 'Y' OR l_item_rec.replenish_to_order_flag = 'Y' ) ) THEN
2802: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2803: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_OM_ATTR', TRUE);
2804: FND_MSG_PUB.Add;
2805: l_return_status := FND_API.g_RET_STS_ERROR;
2806:

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

2799: ELSIF ( l_item_rec.outsourced_assembly = 1 AND
2800: ( /*l_item_rec.internal_order_flag ='Y' OR l_item_rec.internal_order_enabled_flag = 'Y' OR*/-- Bug 9246127
2801: l_item_rec.pick_components_flag = 'Y' OR l_item_rec.replenish_to_order_flag = 'Y' ) ) THEN
2802: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2803: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_OM_ATTR', TRUE);
2804: FND_MSG_PUB.Add;
2805: l_return_status := FND_API.g_RET_STS_ERROR;
2806:
2807: /* General Planning Attribute Group */

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

2809: ELSIF ( l_item_rec.mrp_safety_stock_code <> 1 AND
2810: l_item_rec.drp_planned_flag = 2 AND
2811: /* modified from in (6,9) to = 6 for bug 9838290 to keep align with INVIDITM forms validation*/
2812: l_item_rec.mrp_planning_code = 6 ) THEN
2813: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2814: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_SAFETY_STOCK', TRUE);
2815: FND_MSG_PUB.Add;
2816: l_return_status := FND_API.g_RET_STS_ERROR;
2817:

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

2810: l_item_rec.drp_planned_flag = 2 AND
2811: /* modified from in (6,9) to = 6 for bug 9838290 to keep align with INVIDITM forms validation*/
2812: l_item_rec.mrp_planning_code = 6 ) THEN
2813: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2814: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_SAFETY_STOCK', TRUE);
2815: FND_MSG_PUB.Add;
2816: l_return_status := FND_API.g_RET_STS_ERROR;
2817:
2818: --

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

2824: -- l_wms_enabled = 'N' AND
2825: -- l_eam_enabled = 'N' ) ) ) THEN
2826: ELSIF ( l_item_rec.subcontracting_component IN (2,3) AND
2827: (NOT (l_process_enabled = 'N') ) ) THEN
2828: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2829: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_ORG', TRUE);
2830: FND_MSG_PUB.Add;
2831: l_return_status := FND_API.g_RET_STS_ERROR;
2832:

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

2825: -- l_eam_enabled = 'N' ) ) ) THEN
2826: ELSIF ( l_item_rec.subcontracting_component IN (2,3) AND
2827: (NOT (l_process_enabled = 'N') ) ) THEN
2828: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2829: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_INVALID_ORG', TRUE);
2830: FND_MSG_PUB.Add;
2831: l_return_status := FND_API.g_RET_STS_ERROR;
2832:
2833: ELSIF ( l_item_rec.subcontracting_component IN (2,3) AND l_primary_cost_method <> 1 ) THEN

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

2830: FND_MSG_PUB.Add;
2831: l_return_status := FND_API.g_RET_STS_ERROR;
2832:
2833: ELSIF ( l_item_rec.subcontracting_component IN (2,3) AND l_primary_cost_method <> 1 ) THEN
2834: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2835: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);
2836: FND_MSG_PUB.Add;
2837: l_return_status := FND_API.g_RET_STS_ERROR;
2838:

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

2831: l_return_status := FND_API.g_RET_STS_ERROR;
2832:
2833: ELSIF ( l_item_rec.subcontracting_component IN (2,3) AND l_primary_cost_method <> 1 ) THEN
2834: fnd_message.SET_NAME ('INV', 'INV_ITEM_MASTER_CTRL_ATTR_ERR');
2835: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);
2836: FND_MSG_PUB.Add;
2837: l_return_status := FND_API.g_RET_STS_ERROR;
2838:
2839: END IF;

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

2856: AND ORGANIZATION_ID=l_Item_rec.organization_id))
2857: AND rownum = 1;
2858: EXCEPTION
2859: WHEN NO_DATA_FOUND THEN
2860: fnd_message.SET_NAME('INV', 'INV_IOI_INVALID_TAX_CODE_ORG');
2861: FND_MSG_PUB.Add;
2862: l_return_status := FND_API.g_RET_STS_ERROR;
2863: END;
2864: END IF;

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

2880: AND ORGANIZATION_ID=l_Item_rec.organization_id))
2881: AND rownum = 1;
2882: EXCEPTION
2883: WHEN NO_DATA_FOUND THEN
2884: fnd_message.SET_NAME('INV', 'INV_IOI_PUR_TAX_CODE');
2885: FND_MSG_PUB.Add;
2886: l_return_status := FND_API.g_RET_STS_ERROR;
2887: END;
2888: END IF;

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

3016: IF ( p_Item_ID IS NULL ) OR
3017: ( p_Org_ID IS NULL )
3018: THEN
3019: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
3020: fnd_message.SET_NAME( 'INV', 'INV_MISS_OrgItem_ID' );
3021: FND_MSG_PUB.Add;
3022: RETURN;
3023: END IF;
3024:

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

3047: FETCH INV_ITEM_API.Item_csr INTO x_Item_rec;
3048:
3049: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
3050: CLOSE INV_ITEM_API.Item_csr;
3051: fnd_message.SET_NAME( 'INV', 'INV_Get_Org_Item_notfound' );
3052: FND_MSG_PUB.Add;
3053: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3054: END IF;
3055:

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

3146: IF ( l_Item_ID IS NULL ) OR
3147: ( l_Org_ID IS NULL )
3148: THEN
3149: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
3150: fnd_message.SET_NAME( 'INV', 'INV_MISS_OrgItem_ID' );
3151: FND_MSG_PUB.Add;
3152: RETURN;
3153: END IF;
3154:

Line 4337: FND_MESSAGE.Set_Encoded (l_msg_data);

4333: ' END;'
4334: USING IN l_Inventory_Item_ID, IN l_Organization_ID, OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
4335:
4336: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
4337: FND_MESSAGE.Set_Encoded (l_msg_data);
4338: APP_EXCEPTION.Raise_Exception;
4339: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4340: FND_MESSAGE.Set_Encoded (l_msg_data);
4341: APP_EXCEPTION.Raise_Exception;

Line 4340: FND_MESSAGE.Set_Encoded (l_msg_data);

4336: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
4337: FND_MESSAGE.Set_Encoded (l_msg_data);
4338: APP_EXCEPTION.Raise_Exception;
4339: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4340: FND_MESSAGE.Set_Encoded (l_msg_data);
4341: APP_EXCEPTION.Raise_Exception;
4342: END IF;
4343:
4344: END IF;

Line 4448: fnd_message.SET_ENCODED( l_msg_data );

4444: ,x_msg_count => l_msg_count
4445: ,x_msg_data => l_msg_data);
4446:
4447: IF ( l_return_status = fnd_api.g_RET_STS_ERROR ) THEN
4448: fnd_message.SET_ENCODED( l_msg_data );
4449: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4450: ELSIF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
4451: fnd_message.SET_ENCODED( l_msg_data );
4452: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

Line 4451: fnd_message.SET_ENCODED( l_msg_data );

4447: IF ( l_return_status = fnd_api.g_RET_STS_ERROR ) THEN
4448: fnd_message.SET_ENCODED( l_msg_data );
4449: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4450: ELSIF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
4451: fnd_message.SET_ENCODED( l_msg_data );
4452: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4453: END IF;
4454:
4455: --

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

4482: END IF;
4483: CLOSE c_check_sec_uom_class;
4484: --raise error if item exists anywhere else with a different sec uom class
4485: IF (l_sec_uom_class <> p_secondary_uom_class) THEN
4486: FND_MESSAGE.SET_NAME('INV','INV_SEC_UOM_MISMATCH_CLASS');
4487: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4488: END IF;
4489:
4490: END check_mismatch_of_secuom_class;

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

4559:
4560: FETCH c_get_item_count INTO l_item_count;
4561: CLOSE c_get_item_count;
4562: IF l_item_count > 0 THEN
4563: FND_MESSAGE.SET_NAME('INV','INV_DUPLICATE_ITEM');
4564: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4565: END IF;
4566: IF l_catalog_grp_id <> P_Item_Rec.item_catalog_group_id THEN
4567: FND_MESSAGE.SET_NAME( 'INV','INV_MISMATCH_CATALOG' );

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

4563: FND_MESSAGE.SET_NAME('INV','INV_DUPLICATE_ITEM');
4564: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4565: END IF;
4566: IF l_catalog_grp_id <> P_Item_Rec.item_catalog_group_id THEN
4567: FND_MESSAGE.SET_NAME( 'INV','INV_MISMATCH_CATALOG' );
4568: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4569: END IF;
4570:
4571: OPEN c_get_uom_class(cp_uom => l_unit_of_measure, cp_uom_code => NULL);

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

4575: FETCH c_get_uom_class INTO l_rec_uom_class;
4576: CLOSE c_get_uom_class;
4577:
4578: IF l_uom_class <> l_rec_uom_class THEN
4579: FND_MESSAGE.SET_NAME('INV','INV_MISMATCH_CLASS');
4580: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4581: END IF;
4582: --Jalaj Srivastava Bug 5017588
4583: --check for mismatch of sec uom class.

Line 5071: FND_MESSAGE.Set_Encoded (l_msg_data);

5067: ' END;'
5068: 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;
5069:
5070: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
5071: FND_MESSAGE.Set_Encoded (l_msg_data);
5072: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5073: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
5074: FND_MESSAGE.Set_Encoded (l_msg_data);
5075: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

Line 5074: FND_MESSAGE.Set_Encoded (l_msg_data);

5070: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
5071: FND_MESSAGE.Set_Encoded (l_msg_data);
5072: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5073: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
5074: FND_MESSAGE.Set_Encoded (l_msg_data);
5075: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5076: END IF;
5077: END IF;
5078:

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

5524: FETCH c_item_details INTO recinfo;
5525:
5526: IF (c_item_details%NOTFOUND) THEN
5527: CLOSE c_item_details;
5528: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
5529: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5530: END IF;
5531:
5532: CLOSE c_item_details;

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

6189: OR ((recinfo.SERIAL_TAGGING_FLAG is null) AND (P_Item_Rec.SERIAL_TAGGING_FLAG is null)) )
6190: THEN
6191: NULL;
6192: ELSE
6193: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
6194: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
6195: END IF;
6196:
6197:

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

6204: OR ((item_tl.LONG_DESCRIPTION is null) AND (P_Item_Rec.LONG_DESCRIPTION is null))))
6205: THEN
6206: NULL;
6207: ELSE
6208: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
6209: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
6210: END IF;
6211: END IF;
6212: END LOOP;

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

6502: l_longdesc_control := 0;
6503: end;
6504:
6505: if ((length(x_description)) <> length(rtrim(x_description))) then
6506: fnd_message.Set_Name( 'INV', 'INV_DESCR_TRAILING_SPACES' );
6507: app_exception.raise_exception;
6508: end if;
6509:
6510: if ((length(x_long_description)) <> length(rtrim(x_long_description))) then

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

6507: app_exception.raise_exception;
6508: end if;
6509:
6510: if ((length(x_long_description)) <> length(rtrim(x_long_description))) then
6511: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_TRAILING_SPACES' );
6512: app_exception.raise_exception;
6513: return ;
6514: end if;
6515:

Line 6518: fnd_message.Set_Name( 'INV', 'INV_DESCR_LEADING_SPACES' );

6514: end if;
6515:
6516: --- bug 8717482 vggarg added validations for leaing spaces also.
6517: if ((length(x_description)) <> length(ltrim(x_description))) then
6518: fnd_message.Set_Name( 'INV', 'INV_DESCR_LEADING_SPACES' );
6519: app_exception.raise_exception;
6520: end if;
6521:
6522: if ((length(x_long_description)) <> length(ltrim(x_long_description))) then

Line 6523: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_LEADING_SPACES' );

6519: app_exception.raise_exception;
6520: end if;
6521:
6522: if ((length(x_long_description)) <> length(ltrim(x_long_description))) then
6523: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_LEADING_SPACES' );
6524: app_exception.raise_exception;
6525: return ;
6526: end if;
6527: --- bug 8717482 vggarg end changes

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

6627: FETCH c_item_name INTO recinfo;
6628:
6629: IF (c_item_name%NOTFOUND) THEN
6630: CLOSE c_item_name;
6631: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
6632: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
6633: END IF;
6634:
6635: CLOSE c_item_name;