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 310: FND_MSG_PUB.Initialize;

306:
307: -- Initialize message list
308: --
309: IF ( FND_API.to_Boolean (p_init_msg_list) ) THEN
310: FND_MSG_PUB.Initialize;
311: END IF;
312:
313: -- Initialize API return status to success
314: --

Line 324: FND_MSG_PUB.Add;

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

Line 337: FND_MSG_PUB.Add;

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

Line 384: FND_MSG_PUB.Add;

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

Line 430: FND_MSG_PUB.Add;

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

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

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

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

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

Line 458: FND_MSG_PUB.Add;

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

Line 465: FND_MSG_PUB.Add;

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

Line 471: FND_MSG_PUB.Add;

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

Line 478: FND_MSG_PUB.Add;

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

Line 497: FND_MSG_PUB.Add;

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

Line 556: FND_MSG_PUB.Add;

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

Line 2297: FND_MSG_PUB.Add;

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

Line 2361: FND_MSG_PUB.Add;

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

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

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

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

Line 2383: FND_MSG_PUB.Add;

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

Line 2390: FND_MSG_PUB.Add;

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

Line 2398: FND_MSG_PUB.Add;

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

Line 2405: FND_MSG_PUB.Add;

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

Line 2411: FND_MSG_PUB.Add;

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

Line 2418: FND_MSG_PUB.Add;

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

Line 2430: FND_MSG_PUB.Add;

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

Line 2441: FND_MSG_PUB.Add;

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

Line 2447: FND_MSG_PUB.Add;

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

Line 2453: FND_MSG_PUB.Add;

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

Line 2459: FND_MSG_PUB.Add;

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

Line 2465: FND_MSG_PUB.Add;

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

Line 2471: FND_MSG_PUB.Add;

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

Line 2481: FND_MSG_PUB.Add;

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

Line 2487: FND_MSG_PUB.Add;

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

Line 2493: FND_MSG_PUB.Add;

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

Line 2499: FND_MSG_PUB.Add;

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

Line 2508: FND_MSG_PUB.Add;

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
2512: (l_process_enabled = 'Y' OR l_wms_enabled = 'Y' OR l_eam_enabled = 'Y') ) THEN

Line 2515: FND_MSG_PUB.Add;

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

Line 2523: FND_MSG_PUB.Add;

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

Line 2529: -- FND_MSG_PUB.Add;

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

Line 2536: FND_MSG_PUB.Add;

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

Line 2542: FND_MSG_PUB.Add;

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
2546: ( l_item_rec.internal_order_flag ='Y' OR l_item_rec.internal_order_enabled_flag = 'Y' OR

Line 2550: FND_MSG_PUB.Add;

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

Line 2560: FND_MSG_PUB.Add;

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
2564: (NOT (l_process_enabled = 'N' AND

Line 2569: FND_MSG_PUB.Add;

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

Line 2575: FND_MSG_PUB.Add;

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

Line 2600: FND_MSG_PUB.Add;

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

Line 2624: FND_MSG_PUB.Add;

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

Line 2662: FND_MSG_PUB.Count_And_Get

2658: IF ( FND_API.to_Boolean (p_commit) ) THEN
2659: COMMIT WORK;
2660: END IF;
2661:
2662: FND_MSG_PUB.Count_And_Get
2663: ( p_count => x_msg_count
2664: , p_data => x_msg_data
2665: );
2666:

Line 2677: FND_MSG_PUB.Count_And_Get

2673: END IF;
2674:
2675: ROLLBACK TO Update_Org_Items_PVT;
2676: x_return_status := FND_API.g_RET_STS_ERROR;
2677: FND_MSG_PUB.Count_And_Get
2678: ( p_count => x_msg_count
2679: , p_data => x_msg_data
2680: );
2681:

Line 2690: FND_MSG_PUB.Count_And_Get

2686: END IF;
2687:
2688: ROLLBACK TO Update_Org_Items_PVT;
2689: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2690: FND_MSG_PUB.Count_And_Get
2691: ( p_count => x_msg_count
2692: , p_data => x_msg_data
2693: );
2694:

Line 2704: IF FND_MSG_PUB.Check_Msg_Level

2700:
2701: ROLLBACK TO Update_Org_Items_PVT;
2702: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2703:
2704: IF FND_MSG_PUB.Check_Msg_Level
2705: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2706: THEN
2707: FND_MSG_PUB.Add_Exc_Msg
2708: ( p_pkg_name => G_PKG_NAME

Line 2705: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )

2701: ROLLBACK TO Update_Org_Items_PVT;
2702: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2703:
2704: IF FND_MSG_PUB.Check_Msg_Level
2705: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2706: THEN
2707: FND_MSG_PUB.Add_Exc_Msg
2708: ( p_pkg_name => G_PKG_NAME
2709: , p_procedure_name => l_api_name

Line 2707: FND_MSG_PUB.Add_Exc_Msg

2703:
2704: IF FND_MSG_PUB.Check_Msg_Level
2705: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2706: THEN
2707: FND_MSG_PUB.Add_Exc_Msg
2708: ( p_pkg_name => G_PKG_NAME
2709: , p_procedure_name => l_api_name
2710: , p_error_text => 'UNEXP_ERROR : ' || SQLERRM
2711: );

Line 2714: FND_MSG_PUB.Count_And_Get

2710: , p_error_text => 'UNEXP_ERROR : ' || SQLERRM
2711: );
2712: END IF;
2713:
2714: FND_MSG_PUB.Count_And_Get
2715: ( p_count => x_msg_count
2716: , p_data => x_msg_data
2717: );
2718:

Line 2748: FND_MSG_PUB.Initialize;

2744:
2745: -- Initialize message list
2746: --
2747: IF ( FND_API.to_Boolean (p_init_msg_list) ) THEN
2748: FND_MSG_PUB.Initialize;
2749: END IF;
2750:
2751: -- Initialize API return status to success
2752: --

Line 2760: FND_MSG_PUB.Add;

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

Line 2791: FND_MSG_PUB.Add;

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

Line 2797: FND_MSG_PUB.Count_And_Get

2793: END IF;
2794:
2795: CLOSE INV_ITEM_API.Item_csr;
2796:
2797: FND_MSG_PUB.Count_And_Get
2798: ( p_count => x_msg_count
2799: , p_data => x_msg_data
2800: );
2801:

Line 2811: FND_MSG_PUB.Count_And_Get

2807: CLOSE INV_ITEM_API.Item_csr;
2808: END IF;
2809:
2810: x_return_status := FND_API.g_RET_STS_ERROR;
2811: FND_MSG_PUB.Count_And_Get
2812: ( p_count => x_msg_count
2813: , p_data => x_msg_data
2814: );
2815:

Line 2823: FND_MSG_PUB.Count_And_Get

2819: CLOSE INV_ITEM_API.Item_csr;
2820: END IF;
2821:
2822: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2823: FND_MSG_PUB.Count_And_Get
2824: ( p_count => x_msg_count
2825: , p_data => x_msg_data
2826: );
2827:

Line 2836: IF FND_MSG_PUB.Check_Msg_Level

2832: END IF;
2833:
2834: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2835:
2836: IF FND_MSG_PUB.Check_Msg_Level
2837: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2838: THEN
2839: FND_MSG_PUB.Add_Exc_Msg
2840: ( p_pkg_name => G_PKG_NAME

Line 2837: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )

2833:
2834: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2835:
2836: IF FND_MSG_PUB.Check_Msg_Level
2837: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2838: THEN
2839: FND_MSG_PUB.Add_Exc_Msg
2840: ( p_pkg_name => G_PKG_NAME
2841: , p_procedure_name => l_api_name

Line 2839: FND_MSG_PUB.Add_Exc_Msg

2835:
2836: IF FND_MSG_PUB.Check_Msg_Level
2837: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2838: THEN
2839: FND_MSG_PUB.Add_Exc_Msg
2840: ( p_pkg_name => G_PKG_NAME
2841: , p_procedure_name => l_api_name
2842: -- , p_error_text => 'UNEXP_ERROR : '
2843: );

Line 2846: FND_MSG_PUB.Count_And_Get

2842: -- , p_error_text => 'UNEXP_ERROR : '
2843: );
2844: END IF;
2845:
2846: FND_MSG_PUB.Count_And_Get
2847: ( p_count => x_msg_count
2848: , p_data => x_msg_data
2849: );
2850:

Line 2890: FND_MSG_PUB.Add;

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

Line 2931: FND_MSG_PUB.Count_And_Get

2927:
2928: --
2929: --
2930:
2931: FND_MSG_PUB.Count_And_Get
2932: ( p_count => x_msg_count
2933: , p_data => x_msg_data
2934: );
2935:

Line 2940: FND_MSG_PUB.Count_And_Get

2936: EXCEPTION
2937:
2938: WHEN FND_API.g_EXC_ERROR THEN
2939: x_return_status := FND_API.g_RET_STS_ERROR;
2940: FND_MSG_PUB.Count_And_Get
2941: ( p_count => x_msg_count
2942: , p_data => x_msg_data
2943: );
2944:

Line 2947: FND_MSG_PUB.Count_And_Get

2943: );
2944:
2945: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
2946: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2947: FND_MSG_PUB.Count_And_Get
2948: ( p_count => x_msg_count
2949: , p_data => x_msg_data
2950: );
2951:

Line 2955: IF FND_MSG_PUB.Check_Msg_Level

2951:
2952: WHEN OTHERS THEN
2953: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2954:
2955: IF FND_MSG_PUB.Check_Msg_Level
2956: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2957: THEN
2958: FND_MSG_PUB.Add_Exc_Msg
2959: ( p_pkg_name => G_PKG_NAME

Line 2956: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )

2952: WHEN OTHERS THEN
2953: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2954:
2955: IF FND_MSG_PUB.Check_Msg_Level
2956: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2957: THEN
2958: FND_MSG_PUB.Add_Exc_Msg
2959: ( p_pkg_name => G_PKG_NAME
2960: , p_procedure_name => l_api_name

Line 2958: FND_MSG_PUB.Add_Exc_Msg

2954:
2955: IF FND_MSG_PUB.Check_Msg_Level
2956: ( FND_MSG_PUB.g_MSG_LVL_UNEXP_ERROR )
2957: THEN
2958: FND_MSG_PUB.Add_Exc_Msg
2959: ( p_pkg_name => G_PKG_NAME
2960: , p_procedure_name => l_api_name
2961: -- , p_error_text => 'UNEXP_ERROR : XXX'
2962: );

Line 2965: FND_MSG_PUB.Count_And_Get

2961: -- , p_error_text => 'UNEXP_ERROR : XXX'
2962: );
2963: END IF;
2964:
2965: FND_MSG_PUB.Count_And_Get
2966: ( p_count => x_msg_count
2967: , p_data => x_msg_data
2968: );
2969: