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_MSG_PUB

Line 128: IF FND_MSG_PUB.Check_Msg_Level

124: END IF;
125:
126: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
127:
128: IF FND_MSG_PUB.Check_Msg_Level
129: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg
132: ( p_pkg_name => G_PKG_NAME

Line 129: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )

125:
126: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
127:
128: IF FND_MSG_PUB.Check_Msg_Level
129: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg
132: ( p_pkg_name => G_PKG_NAME
133: , p_procedure_name => l_api_name

Line 131: FND_MSG_PUB.Add_Exc_Msg

127:
128: IF FND_MSG_PUB.Check_Msg_Level
129: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg
132: ( p_pkg_name => G_PKG_NAME
133: , p_procedure_name => l_api_name
134: -- , p_error_text => 'UNEXP_ERROR : ' || SQLERRM
135: );

Line 188: FND_MSG_PUB.Add;

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:
192: WHEN OTHERS THEN

Line 204: FND_MSG_PUB.Add;

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;
208:

Line 337: FND_MSG_PUB.Initialize;

333:
334: -- Initialize message list
335: --
336: IF ( FND_API.to_Boolean (p_init_msg_list) ) THEN
337: FND_MSG_PUB.Initialize;
338: END IF;
339:
340: -- Initialize API return status to success
341: --

Line 351: FND_MSG_PUB.Add;

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:
355:

Line 364: FND_MSG_PUB.Add;

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: */
368:

Line 411: FND_MSG_PUB.Add;

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:
415: -- Get master org ID from the fetched record

Line 457: FND_MSG_PUB.Add;

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

Line 462: 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
466: l_Item_rec.mtl_transactions_enabled_flag ='N' )THEN

Line 468: FND_MSG_PUB.Add;

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

Line 473: 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
477: fnd_message.SET_NAME('INV', 'INVALID_CO_COE_FLAG_COMB');

Line 478: 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
482: fnd_message.SET_NAME('INV', 'INVALID_IO_IOE_FLAG_COMB');

Line 483: 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
487: l_Item_rec.contract_item_type_code IS NULL AND

Line 491: FND_MSG_PUB.Add;

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'
495: OR l_item_rec.bom_item_type <> 4 )

Line 498: FND_MSG_PUB.Add;

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
502: ( l_Item_rec.SERIAL_NUMBER_CONTROL_CODE NOT IN (2, 5) ) THEN

Line 504: FND_MSG_PUB.Add;

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
508: nvl(l_Item_rec.comms_nl_trackable_flag,'N') = 'N') THEN

Line 511: FND_MSG_PUB.Add;

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
515: INVIDIT3.VMI_Table_Queries(

Line 530: FND_MSG_PUB.Add;

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;
534:

Line 589: FND_MSG_PUB.Add;

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:
593: /* Following fix needs to be reverted for 5645595

Line 2412: FND_MSG_PUB.Add;

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:
2416: END IF; -- ( l_Attribute_Code = ... )

Line 2601: FND_MSG_PUB.Add;

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

Line 2606: 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
2610: l_Item_rec.mtl_transactions_enabled_flag ='N' )THEN

Line 2612: FND_MSG_PUB.Add;

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

Line 2617: 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
2621: fnd_message.SET_NAME('INV', 'INVALID_CO_COE_FLAG_COMB');

Line 2622: 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
2626: ELSIF (l_Item_rec.bom_item_type IN (3,5) AND

Line 2629: FND_MSG_PUB.Add;

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:
2633: ELSIF (l_Item_rec.internal_order_flag ='N' AND

Line 2636: FND_MSG_PUB.Add;

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
2640: l_Item_rec.contract_item_type_code IS NULL AND

Line 2644: FND_MSG_PUB.Add;

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'
2648: OR l_item_rec.bom_item_type <> 4 )

Line 2651: FND_MSG_PUB.Add;

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
2655: ( l_Item_rec.SERIAL_NUMBER_CONTROL_CODE NOT IN (2, 5) ) THEN

Line 2657: FND_MSG_PUB.Add;

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
2661: nvl(l_Item_rec.comms_nl_trackable_flag,'N') = 'N') THEN

Line 2664: FND_MSG_PUB.Add;

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
2668: (NVL(l_Item_rec.outside_operation_flag,'N') = 'Y' OR

Line 2676: FND_MSG_PUB.Add;

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 */
2680: /* Inventory Attribute Group */

Line 2688: FND_MSG_PUB.Add;

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

Line 2694: FND_MSG_PUB.Add;

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:
2698: ELSIF ( l_item_rec.grade_control_flag = 'N' AND l_item_rec.default_grade IS NOT NULL ) THEN

Line 2701: FND_MSG_PUB.Add;

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

Line 2707: FND_MSG_PUB.Add;

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

Line 2713: FND_MSG_PUB.Add;

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

Line 2719: FND_MSG_PUB.Add;

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 */
2723:

Line 2729: FND_MSG_PUB.Add;

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

Line 2735: FND_MSG_PUB.Add;

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

Line 2741: FND_MSG_PUB.Add;

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

Line 2747: FND_MSG_PUB.Add;

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 */
2751:

Line 2756: FND_MSG_PUB.Add;

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: --
2760: -- bug 13822871.

Line 2769: FND_MSG_PUB.Add;

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
2773: NVL(l_trading_partner_org,'N') = 'Y' AND

Line 2777: FND_MSG_PUB.Add;

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

Line 2783: -- FND_MSG_PUB.Add;

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
2787: NOT(l_item_rec.bom_item_type = 4 AND l_item_rec.effectivity_control = 1) ) THEN

Line 2790: FND_MSG_PUB.Add;

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

Line 2796: FND_MSG_PUB.Add;

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
2800: ( /*l_item_rec.internal_order_flag ='Y' OR l_item_rec.internal_order_enabled_flag = 'Y' OR*/-- Bug 9246127

Line 2804: FND_MSG_PUB.Add;

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 */
2808:

Line 2815: FND_MSG_PUB.Add;

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: --
2819: -- bug 13822871.

Line 2830: FND_MSG_PUB.Add;

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

Line 2836: FND_MSG_PUB.Add;

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;
2840:

Line 2861: FND_MSG_PUB.Add;

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;
2865: --* End of Bug 5207014

Line 2885: FND_MSG_PUB.Add;

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;
2889:

Line 2923: FND_MSG_PUB.Count_And_Get

2919: IF ( FND_API.to_Boolean (p_commit) ) THEN
2920: COMMIT WORK;
2921: END IF;
2922:
2923: FND_MSG_PUB.Count_And_Get
2924: ( p_count => x_msg_count
2925: , p_data => x_msg_data
2926: );
2927:

Line 2938: FND_MSG_PUB.Count_And_Get

2934: END IF;
2935:
2936: ROLLBACK TO Update_Org_Items_PVT;
2937: x_return_status := FND_API.g_RET_STS_ERROR;
2938: FND_MSG_PUB.Count_And_Get
2939: ( p_count => x_msg_count
2940: , p_data => x_msg_data
2941: );
2942:

Line 2951: FND_MSG_PUB.Count_And_Get

2947: END IF;
2948:
2949: ROLLBACK TO Update_Org_Items_PVT;
2950: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2951: FND_MSG_PUB.Count_And_Get
2952: ( p_count => x_msg_count
2953: , p_data => x_msg_data
2954: );
2955:

Line 2965: IF FND_MSG_PUB.Check_Msg_Level

2961:
2962: ROLLBACK TO Update_Org_Items_PVT;
2963: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2964:
2965: IF FND_MSG_PUB.Check_Msg_Level
2966: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2967: THEN
2968: FND_MSG_PUB.Add_Exc_Msg
2969: ( p_pkg_name => G_PKG_NAME

Line 2966: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )

2962: ROLLBACK TO Update_Org_Items_PVT;
2963: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2964:
2965: IF FND_MSG_PUB.Check_Msg_Level
2966: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2967: THEN
2968: FND_MSG_PUB.Add_Exc_Msg
2969: ( p_pkg_name => G_PKG_NAME
2970: , p_procedure_name => l_api_name

Line 2968: FND_MSG_PUB.Add_Exc_Msg

2964:
2965: IF FND_MSG_PUB.Check_Msg_Level
2966: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2967: THEN
2968: FND_MSG_PUB.Add_Exc_Msg
2969: ( p_pkg_name => G_PKG_NAME
2970: , p_procedure_name => l_api_name
2971: , p_error_text => 'UNEXP_ERROR : ' || SQLERRM
2972: );

Line 2975: FND_MSG_PUB.Count_And_Get

2971: , p_error_text => 'UNEXP_ERROR : ' || SQLERRM
2972: );
2973: END IF;
2974:
2975: FND_MSG_PUB.Count_And_Get
2976: ( p_count => x_msg_count
2977: , p_data => x_msg_data
2978: );
2979:

Line 3009: FND_MSG_PUB.Initialize;

3005:
3006: -- Initialize message list
3007: --
3008: IF ( FND_API.to_Boolean (p_init_msg_list) ) THEN
3009: FND_MSG_PUB.Initialize;
3010: END IF;
3011:
3012: -- Initialize API return status to success
3013: --

Line 3021: FND_MSG_PUB.Add;

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:
3025: /*

Line 3052: FND_MSG_PUB.Add;

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:
3056: CLOSE INV_ITEM_API.Item_csr;

Line 3058: FND_MSG_PUB.Count_And_Get

3054: END IF;
3055:
3056: CLOSE INV_ITEM_API.Item_csr;
3057:
3058: FND_MSG_PUB.Count_And_Get
3059: ( p_count => x_msg_count
3060: , p_data => x_msg_data
3061: );
3062:

Line 3072: FND_MSG_PUB.Count_And_Get

3068: CLOSE INV_ITEM_API.Item_csr;
3069: END IF;
3070:
3071: x_return_status := FND_API.g_RET_STS_ERROR;
3072: FND_MSG_PUB.Count_And_Get
3073: ( p_count => x_msg_count
3074: , p_data => x_msg_data
3075: );
3076:

Line 3084: FND_MSG_PUB.Count_And_Get

3080: CLOSE INV_ITEM_API.Item_csr;
3081: END IF;
3082:
3083: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
3084: FND_MSG_PUB.Count_And_Get
3085: ( p_count => x_msg_count
3086: , p_data => x_msg_data
3087: );
3088:

Line 3097: IF FND_MSG_PUB.Check_Msg_Level

3093: END IF;
3094:
3095: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
3096:
3097: IF FND_MSG_PUB.Check_Msg_Level
3098: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
3099: THEN
3100: FND_MSG_PUB.Add_Exc_Msg
3101: ( p_pkg_name => G_PKG_NAME

Line 3098: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )

3094:
3095: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
3096:
3097: IF FND_MSG_PUB.Check_Msg_Level
3098: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
3099: THEN
3100: FND_MSG_PUB.Add_Exc_Msg
3101: ( p_pkg_name => G_PKG_NAME
3102: , p_procedure_name => l_api_name

Line 3100: FND_MSG_PUB.Add_Exc_Msg

3096:
3097: IF FND_MSG_PUB.Check_Msg_Level
3098: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
3099: THEN
3100: FND_MSG_PUB.Add_Exc_Msg
3101: ( p_pkg_name => G_PKG_NAME
3102: , p_procedure_name => l_api_name
3103: -- , p_error_text => 'UNEXP_ERROR : '
3104: );

Line 3107: FND_MSG_PUB.Count_And_Get

3103: -- , p_error_text => 'UNEXP_ERROR : '
3104: );
3105: END IF;
3106:
3107: FND_MSG_PUB.Count_And_Get
3108: ( p_count => x_msg_count
3109: , p_data => x_msg_data
3110: );
3111:

Line 3151: FND_MSG_PUB.Add;

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:
3155: --

Line 3192: FND_MSG_PUB.Count_And_Get

3188:
3189: --
3190: --
3191:
3192: FND_MSG_PUB.Count_And_Get
3193: ( p_count => x_msg_count
3194: , p_data => x_msg_data
3195: );
3196:

Line 3201: FND_MSG_PUB.Count_And_Get

3197: EXCEPTION
3198:
3199: WHEN FND_API.g_EXC_ERROR THEN
3200: x_return_status := FND_API.g_RET_STS_ERROR;
3201: FND_MSG_PUB.Count_And_Get
3202: ( p_count => x_msg_count
3203: , p_data => x_msg_data
3204: );
3205:

Line 3208: FND_MSG_PUB.Count_And_Get

3204: );
3205:
3206: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3207: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
3208: FND_MSG_PUB.Count_And_Get
3209: ( p_count => x_msg_count
3210: , p_data => x_msg_data
3211: );
3212:

Line 3216: IF FND_MSG_PUB.Check_Msg_Level

3212:
3213: WHEN OTHERS THEN
3214: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
3215:
3216: IF FND_MSG_PUB.Check_Msg_Level
3217: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
3218: THEN
3219: FND_MSG_PUB.Add_Exc_Msg
3220: ( p_pkg_name => G_PKG_NAME

Line 3217: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )

3213: WHEN OTHERS THEN
3214: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
3215:
3216: IF FND_MSG_PUB.Check_Msg_Level
3217: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
3218: THEN
3219: FND_MSG_PUB.Add_Exc_Msg
3220: ( p_pkg_name => G_PKG_NAME
3221: , p_procedure_name => l_api_name

Line 3219: FND_MSG_PUB.Add_Exc_Msg

3215:
3216: IF FND_MSG_PUB.Check_Msg_Level
3217: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
3218: THEN
3219: FND_MSG_PUB.Add_Exc_Msg
3220: ( p_pkg_name => G_PKG_NAME
3221: , p_procedure_name => l_api_name
3222: -- , p_error_text => 'UNEXP_ERROR : XXX'
3223: );

Line 3226: FND_MSG_PUB.Count_And_Get

3222: -- , p_error_text => 'UNEXP_ERROR : XXX'
3223: );
3224: END IF;
3225:
3226: FND_MSG_PUB.Count_And_Get
3227: ( p_count => x_msg_count
3228: , p_data => x_msg_data
3229: );
3230: