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_API

Line 116: x_return_status := FND_API.g_RET_STS_SUCCESS;

112:
113: END IF; -- (g_Master_Attribute_tbl.COUNT = 0)
114:
115: -- Set return status
116: x_return_status := FND_API.g_RET_STS_SUCCESS;
117:
118: EXCEPTION
119:
120: WHEN others THEN

Line 126: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

122: IF ( Master_Attribute_csr%ISOPEN ) THEN
123: CLOSE Master_Attribute_csr;
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

Line 147: , p_lock_Master IN VARCHAR2 := FND_API.g_TRUE

143: PROCEDURE Lock_Org_Items
144: (
145: p_Item_ID IN NUMBER
146: , p_Org_ID IN NUMBER
147: , p_lock_Master IN VARCHAR2 := FND_API.g_TRUE
148: , p_lock_Orgs IN VARCHAR2 := FND_API.g_FALSE
149: , x_return_status OUT NOCOPY VARCHAR2
150: )
151: IS

Line 148: , p_lock_Orgs IN VARCHAR2 := FND_API.g_FALSE

144: (
145: p_Item_ID IN NUMBER
146: , p_Org_ID IN NUMBER
147: , p_lock_Master IN VARCHAR2 := FND_API.g_TRUE
148: , p_lock_Orgs IN VARCHAR2 := FND_API.g_FALSE
149: , x_return_status OUT NOCOPY VARCHAR2
150: )
151: IS
152: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Org_Items';

Line 185: WHEN FND_API.g_EXC_ THEN

181:
182: /*
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;

Line 186: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

Line 202: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

198: IF ( INV_ITEM_API.Item_TL_csr%ISOPEN ) THEN
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:

Line 214: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE

210: /*----------------------------- Update_Org_Items -----------------------------*/
211:
212: PROCEDURE Update_Org_Items
213: (
214: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
215: , p_commit IN VARCHAR2 := FND_API.g_FALSE
216: , p_lock_rows IN VARCHAR2 := FND_API.g_TRUE
217: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
218: , p_Item_rec IN INV_ITEM_API.Item_rec_type

Line 215: , p_commit IN VARCHAR2 := FND_API.g_FALSE

211:
212: PROCEDURE Update_Org_Items
213: (
214: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
215: , p_commit IN VARCHAR2 := FND_API.g_FALSE
216: , p_lock_rows IN VARCHAR2 := FND_API.g_TRUE
217: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
218: , p_Item_rec IN INV_ITEM_API.Item_rec_type
219: , p_update_changes_only IN VARCHAR2 := FND_API.g_FALSE

Line 216: , p_lock_rows IN VARCHAR2 := FND_API.g_TRUE

212: PROCEDURE Update_Org_Items
213: (
214: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
215: , p_commit IN VARCHAR2 := FND_API.g_FALSE
216: , p_lock_rows IN VARCHAR2 := FND_API.g_TRUE
217: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
218: , p_Item_rec IN INV_ITEM_API.Item_rec_type
219: , p_update_changes_only IN VARCHAR2 := FND_API.g_FALSE
220: , p_validate_Master IN VARCHAR2 := FND_API.g_TRUE

Line 217: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL

213: (
214: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
215: , p_commit IN VARCHAR2 := FND_API.g_FALSE
216: , p_lock_rows IN VARCHAR2 := FND_API.g_TRUE
217: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
218: , p_Item_rec IN INV_ITEM_API.Item_rec_type
219: , p_update_changes_only IN VARCHAR2 := FND_API.g_FALSE
220: , p_validate_Master IN VARCHAR2 := FND_API.g_TRUE
221: , x_return_status OUT NOCOPY VARCHAR2

Line 219: , p_update_changes_only IN VARCHAR2 := FND_API.g_FALSE

215: , p_commit IN VARCHAR2 := FND_API.g_FALSE
216: , p_lock_rows IN VARCHAR2 := FND_API.g_TRUE
217: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
218: , p_Item_rec IN INV_ITEM_API.Item_rec_type
219: , p_update_changes_only IN VARCHAR2 := FND_API.g_FALSE
220: , p_validate_Master IN VARCHAR2 := FND_API.g_TRUE
221: , x_return_status OUT NOCOPY VARCHAR2
222: , x_msg_count OUT NOCOPY NUMBER
223: , x_msg_data OUT NOCOPY VARCHAR2

Line 220: , p_validate_Master IN VARCHAR2 := FND_API.g_TRUE

216: , p_lock_rows IN VARCHAR2 := FND_API.g_TRUE
217: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
218: , p_Item_rec IN INV_ITEM_API.Item_rec_type
219: , p_update_changes_only IN VARCHAR2 := FND_API.g_FALSE
220: , p_validate_Master IN VARCHAR2 := FND_API.g_TRUE
221: , x_return_status OUT NOCOPY VARCHAR2
222: , x_msg_count OUT NOCOPY NUMBER
223: , x_msg_data OUT NOCOPY VARCHAR2
224: )

Line 309: IF ( FND_API.to_Boolean (p_init_msg_list) ) THEN

305: SAVEPOINT Update_Org_Items_PVT;
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

Line 315: x_return_status := FND_API.g_RET_STS_SUCCESS;

311: END IF;
312:
313: -- Initialize API return status to success
314: --
315: x_return_status := FND_API.g_RET_STS_SUCCESS;
316:
317: p_Item_ID := p_Item_rec.INVENTORY_ITEM_ID ;
318: p_Org_ID := p_Item_rec.ORGANIZATION_ID ;
319:

Line 325: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 338: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 346: IF ( FND_API.to_Boolean (p_lock_rows) ) THEN

342: ------------------------
343: -- Lock org item rows --
344: ------------------------
345:
346: IF ( FND_API.to_Boolean (p_lock_rows) ) THEN
347:
348: INV_ITEM_PVT.Lock_Org_Items
349: (
350: p_Item_ID => p_Item_ID

Line 352: , p_lock_Master => FND_API.g_TRUE

348: INV_ITEM_PVT.Lock_Org_Items
349: (
350: p_Item_ID => p_Item_ID
351: , p_Org_ID => p_Org_ID
352: , p_lock_Master => FND_API.g_TRUE
353: , p_lock_Orgs => FND_API.g_TRUE
354: , x_return_status => l_return_status
355: );
356:

Line 353: , p_lock_Orgs => FND_API.g_TRUE

349: (
350: p_Item_ID => p_Item_ID
351: , p_Org_ID => p_Org_ID
352: , p_lock_Master => FND_API.g_TRUE
353: , p_lock_Orgs => FND_API.g_TRUE
354: , x_return_status => l_return_status
355: );
356:
357: END IF; -- Lock org item rows

Line 376: , p_fetch_Master => FND_API.g_TRUE

372: OPEN INV_ITEM_API.Item_csr
373: (
374: p_Item_ID => p_Item_ID
375: , p_Org_ID => p_Org_ID
376: , p_fetch_Master => FND_API.g_TRUE
377: , p_fetch_Orgs => FND_API.g_TRUE
378: );
379: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
380:

Line 377: , p_fetch_Orgs => FND_API.g_TRUE

373: (
374: p_Item_ID => p_Item_ID
375: , p_Org_ID => p_Org_ID
376: , p_fetch_Master => FND_API.g_TRUE
377: , p_fetch_Orgs => FND_API.g_TRUE
378: );
379: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
380:
381: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN

Line 385: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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
389: -- (parameter p_Item_rec may not have this value)

Line 400: IF ( FND_API.to_Boolean (p_update_changes_only) )

396: -- Depending on the input parameter, copy either --
397: -- input item record "as is", or changed atributes only --
398: ----------------------------------------------------------
399:
400: IF ( FND_API.to_Boolean (p_update_changes_only) )
401: THEN
402: -- Update changed attributes only - not implemented yet
403: /*
404: INV_ITEM_Lib.Copy_Changed_Attributes

Line 425: IF ( FND_API.to_Boolean (p_validate_Master) ) THEN

421: -------------------------------------------------------
422: -- Item validation, depending on the input parameter --
423: -------------------------------------------------------
424:
425: IF ( FND_API.to_Boolean (p_validate_Master) ) THEN
426:
427: IF (l_Item_rec.inventory_item_flag ='N' AND
428: l_Item_rec.stock_enabled_flag ='Y' ) THEN
429: fnd_message.SET_NAME('INV', 'INVALID_INV_STK_FLAG_COMB');

Line 431: l_return_status := FND_API.g_RET_STS_ERROR;

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');
435: FND_MSG_PUB.Add;

Line 436: 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');
440: FND_MSG_PUB.Add;

Line 441: 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');
445: FND_MSG_PUB.Add;

Line 446: 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');
450: FND_MSG_PUB.Add;

Line 451: 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
455: l_Item_rec.bom_enabled_flag = 'Y') THEN

Line 459: l_return_status := FND_API.g_RET_STS_ERROR;

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 )
463: AND l_Item_rec.build_in_wip_flag ='Y' ) THEN

Line 466: l_return_status := FND_API.g_RET_STS_ERROR;

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
470: fnd_message.SET_NAME('INV', 'ITM-EFFC-INVALID SERIAL CTRL-2');

Line 472: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 479: l_return_status := FND_API.g_RET_STS_ERROR;

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(
483: P_org_id => l_Item_rec.organization_id

Line 498: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 513: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN

509: , x_msg_data => x_msg_data
510: );
511: */
512:
513: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
514: RAISE FND_API.g_EXC_ERROR;
515: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
516: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
517: END IF;

Line 514: RAISE FND_API.g_EXC_ERROR;

510: );
511: */
512:
513: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
514: RAISE FND_API.g_EXC_ERROR;
515: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
516: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
517: END IF;
518:

Line 515: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN

511: */
512:
513: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
514: RAISE FND_API.g_EXC_ERROR;
515: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
516: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
519: END IF; -- validate master

Line 516: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

512:
513: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
514: RAISE FND_API.g_EXC_ERROR;
515: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
516: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
519: END IF; -- validate master
520:

Line 548: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN

544: -- Get a list of master control level attributes
545:
546: Get_Master_Attributes ( x_return_status => l_return_status );
547:
548: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
549: RAISE FND_API.g_EXC_ERROR;
550: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
551: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
552: END IF;

Line 549: RAISE FND_API.g_EXC_ERROR;

545:
546: Get_Master_Attributes ( x_return_status => l_return_status );
547:
548: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
549: RAISE FND_API.g_EXC_ERROR;
550: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
551: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
552: END IF;
553: /*

Line 550: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN

546: Get_Master_Attributes ( x_return_status => l_return_status );
547:
548: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
549: RAISE FND_API.g_EXC_ERROR;
550: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
551: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
552: END IF;
553: /*
554: ELSE

Line 551: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

547:
548: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
549: RAISE FND_API.g_EXC_ERROR;
550: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
551: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
552: END IF;
553: /*
554: ELSE
555: fnd_message.Set_Name( 'INV', 'Master_Attribute.COUNT <> 0' );

Line 557: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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
561: -- Added for bug 5236494

Line 2291: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

2287: ELSE
2288: --------------------------
2289: -- Invalid attribute code
2290: --------------------------
2291: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2292:
2293: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');
2294: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);
2295: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);

Line 2299: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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 = ... )
2302:
2303: -- Copy attributes done by code above.

Line 2314: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN

2310: , x_return_status => l_return_status
2311: );
2312:
2313: x_return_status := l_return_status;
2314: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2315: RAISE FND_API.g_EXC_ERROR;
2316: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2317: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2318: END IF;

Line 2315: RAISE FND_API.g_EXC_ERROR;

2311: );
2312:
2313: x_return_status := l_return_status;
2314: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2315: RAISE FND_API.g_EXC_ERROR;
2316: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2317: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2318: END IF;
2319: */

Line 2316: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN

2312:
2313: x_return_status := l_return_status;
2314: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2315: RAISE FND_API.g_EXC_ERROR;
2316: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2317: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2318: END IF;
2319: */
2320:

Line 2317: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

2313: x_return_status := l_return_status;
2314: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2315: RAISE FND_API.g_EXC_ERROR;
2316: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2317: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2318: END IF;
2319: */
2320:
2321: END LOOP; -- loop through item attributes

Line 2362: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2366: FND_MSG_PUB.Add;

Line 2367: 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');
2371: FND_MSG_PUB.Add;

Line 2372: 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');
2376: FND_MSG_PUB.Add;

Line 2377: 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
2381: l_Item_rec.customer_order_flag ='Y' )THEN

Line 2384: l_return_status := FND_API.g_RET_STS_ERROR;

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
2388: l_Item_rec.internal_order_enabled_flag ='Y' )THEN

Line 2391: l_return_status := FND_API.g_RET_STS_ERROR;

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
2395: l_Item_rec.bom_enabled_flag = 'Y') THEN

Line 2399: l_return_status := FND_API.g_RET_STS_ERROR;

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 )
2403: AND l_Item_rec.build_in_wip_flag ='Y' ) THEN

Line 2406: l_return_status := FND_API.g_RET_STS_ERROR;

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
2410: fnd_message.SET_NAME('INV', 'ITM-EFFC-INVALID SERIAL CTRL-2');

Line 2412: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2419: l_return_status := FND_API.g_RET_STS_ERROR;

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
2423: l_Item_rec.eam_item_type IS NOT NULL OR

Line 2431: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2442: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2446: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_GRADE_CONTROL', TRUE);

Line 2448: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2452: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_DEFAULT_GRADE_NULL', TRUE);

Line 2454: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2458: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_DIVISIBLE', TRUE);

Line 2460: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2464: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_LOT_SPLIT_ENABLED', TRUE);

Line 2466: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2470: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_INVALID_CHILD_LOT_FLAG', TRUE);

Line 2472: l_return_status := FND_API.g_RET_STS_ERROR;

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:
2476: ELSIF (( l_item_rec.eam_item_type = 1 OR

Line 2482: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2486: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ACTIVITY_NEVER_SERIAL', TRUE);

Line 2488: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2492: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_GRP_NO_SERIAL', TRUE);

Line 2494: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2498: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_EAM_ASSET_UNIT_CONTROL', TRUE);

Line 2500: l_return_status := FND_API.g_RET_STS_ERROR;

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:
2504: ELSIF ( l_item_rec.purchasing_tax_code IS NOT NULL AND

Line 2509: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2516: l_return_status := FND_API.g_RET_STS_ERROR;

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
2520: l_item_rec.outsourced_assembly = 1 ) THEN

Line 2524: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2528: -- fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);

Line 2530: -- l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2537: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2541: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_OUTSIDE_OPRN', TRUE);

Line 2543: l_return_status := FND_API.g_RET_STS_ERROR;

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
2547: l_item_rec.pick_components_flag = 'Y' OR l_item_rec.replenish_to_order_flag = 'Y' ) ) THEN

Line 2551: l_return_status := FND_API.g_RET_STS_ERROR;

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:
2555: ELSIF ( l_item_rec.mrp_safety_stock_code <> 1 AND

Line 2561: l_return_status := FND_API.g_RET_STS_ERROR;

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
2565: l_wms_enabled = 'N' AND

Line 2570: l_return_status := FND_API.g_RET_STS_ERROR;

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');
2574: fnd_message.SET_TOKEN ('ERROR_MESSAGE_NAME', 'INV_OS_ASMBLY_STD_COST_ORG', TRUE);

Line 2576: l_return_status := FND_API.g_RET_STS_ERROR;

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:
2580: /* Invoicing Attribute Group */

Line 2601: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2625: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2631: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN

2627: END IF;
2628:
2629:
2630: -- Check for errors
2631: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2632: RAISE FND_API.g_EXC_ERROR;
2633: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2634: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2635: END IF;

Line 2632: RAISE FND_API.g_EXC_ERROR;

2628:
2629:
2630: -- Check for errors
2631: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2632: RAISE FND_API.g_EXC_ERROR;
2633: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2634: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2635: END IF;
2636:

Line 2633: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN

2629:
2630: -- Check for errors
2631: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2632: RAISE FND_API.g_EXC_ERROR;
2633: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2634: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2635: END IF;
2636:
2637: ---------------------------------

Line 2634: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

2630: -- Check for errors
2631: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2632: RAISE FND_API.g_EXC_ERROR;
2633: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2634: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2635: END IF;
2636:
2637: ---------------------------------
2638: -- Update current org item row --

Line 2658: IF ( FND_API.to_Boolean (p_commit) ) THEN

2654: ----------------------------------- p_Org is master ---
2655:
2656: CLOSE INV_ITEM_API.Item_csr;
2657:
2658: IF ( FND_API.to_Boolean (p_commit) ) THEN
2659: COMMIT WORK;
2660: END IF;
2661:
2662: FND_MSG_PUB.Count_And_Get

Line 2669: WHEN FND_API.g_EXC_ERROR THEN

2665: );
2666:
2667: EXCEPTION
2668:
2669: WHEN FND_API.g_EXC_ERROR THEN
2670:
2671: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2672: CLOSE INV_ITEM_API.Item_csr;
2673: END IF;

Line 2676: x_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2682: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

2678: ( p_count => x_msg_count
2679: , p_data => x_msg_data
2680: );
2681:
2682: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
2683:
2684: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2685: CLOSE INV_ITEM_API.Item_csr;
2686: END IF;

Line 2689: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

Line 2702: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

2698: CLOSE INV_ITEM_API.Item_csr;
2699: END IF;
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

Line 2726: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE

2722: /*------------------------------- Get_Org_Item -------------------------------*/
2723:
2724: PROCEDURE Get_Org_Item
2725: (
2726: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
2727: , p_Item_ID IN NUMBER
2728: , p_Org_ID IN NUMBER
2729: , p_Language IN VARCHAR2 := FND_API.g_MISS_CHAR
2730: , x_Item_rec OUT NOCOPY INV_ITEM_API.Item_rec_type

Line 2729: , p_Language IN VARCHAR2 := FND_API.g_MISS_CHAR

2725: (
2726: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
2727: , p_Item_ID IN NUMBER
2728: , p_Org_ID IN NUMBER
2729: , p_Language IN VARCHAR2 := FND_API.g_MISS_CHAR
2730: , x_Item_rec OUT NOCOPY INV_ITEM_API.Item_rec_type
2731: , x_return_status OUT NOCOPY VARCHAR2
2732: , x_msg_count OUT NOCOPY NUMBER
2733: , x_msg_data OUT NOCOPY VARCHAR2

Line 2747: IF ( FND_API.to_Boolean (p_init_msg_list) ) THEN

2743: BEGIN
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

Line 2753: x_return_status := FND_API.g_RET_STS_SUCCESS;

2749: END IF;
2750:
2751: -- Initialize API return status to success
2752: --
2753: x_return_status := FND_API.g_RET_STS_SUCCESS;
2754:
2755: IF ( p_Item_ID IS NULL ) OR
2756: ( p_Org_ID IS NULL )
2757: THEN

Line 2758: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

Line 2767: IF ( p_Language <> FND_API.g_MISS_CHAR ) THEN

2763:
2764: /*
2765: -- Get the translation row
2766: --
2767: IF ( p_Language <> FND_API.g_MISS_CHAR ) THEN
2768:
2769: END IF;
2770: */
2771:

Line 2780: , p_fetch_Master => FND_API.g_TRUE

2776: OPEN INV_ITEM_API.Item_csr
2777: (
2778: p_Item_ID => p_Item_ID
2779: , p_Org_ID => p_Org_ID
2780: , p_fetch_Master => FND_API.g_TRUE
2781: , p_fetch_Orgs => FND_API.g_FALSE
2782: );
2783:
2784: -- Fetch org item row

Line 2781: , p_fetch_Orgs => FND_API.g_FALSE

2777: (
2778: p_Item_ID => p_Item_ID
2779: , p_Org_ID => p_Org_ID
2780: , p_fetch_Master => FND_API.g_TRUE
2781: , p_fetch_Orgs => FND_API.g_FALSE
2782: );
2783:
2784: -- Fetch org item row
2785: --

Line 2792: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 2804: WHEN FND_API.g_EXC_ERROR THEN

2800: );
2801:
2802: EXCEPTION
2803:
2804: WHEN FND_API.g_EXC_ERROR THEN
2805:
2806: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2807: CLOSE INV_ITEM_API.Item_csr;
2808: END IF;

Line 2810: x_return_status := FND_API.g_RET_STS_ERROR;

2806: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
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: );

Line 2816: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

2812: ( p_count => x_msg_count
2813: , p_data => x_msg_data
2814: );
2815:
2816: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
2817:
2818: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2819: CLOSE INV_ITEM_API.Item_csr;
2820: END IF;

Line 2822: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

2818: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
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: );

Line 2834: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

2830: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2831: CLOSE INV_ITEM_API.Item_csr;
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

Line 2862: p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL

2858:
2859: /*
2860: PROCEDURE Validate_Item
2861: (
2862: p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
2863: , p_Item_rec IN INV_ITEM_API.Item_rec_type
2864: , x_return_status OUT NOCOPY VARCHAR2
2865: , x_msg_count OUT NOCOPY NUMBER
2866: , x_msg_data OUT NOCOPY VARCHAR2

Line 2883: x_return_status := FND_API.g_RET_STS_SUCCESS;

2879: l_Org_ID := p_Item_rec.ORGANIZATION_ID ;
2880:
2881: -- Initialize API return status to success
2882: --
2883: x_return_status := FND_API.g_RET_STS_SUCCESS;
2884:
2885: IF ( l_Item_ID IS NULL ) OR
2886: ( l_Org_ID IS NULL )
2887: THEN

Line 2888: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

Line 2906: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN

2902: );
2903:
2904: -- Raise an error as soon as the first fault is encountered
2905:
2906: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2907: RAISE FND_API.g_EXC_ERROR;
2908: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2909: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2910: END IF;

Line 2907: RAISE FND_API.g_EXC_ERROR;

2903:
2904: -- Raise an error as soon as the first fault is encountered
2905:
2906: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2907: RAISE FND_API.g_EXC_ERROR;
2908: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2909: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2910: END IF;
2911:

Line 2908: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN

2904: -- Raise an error as soon as the first fault is encountered
2905:
2906: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2907: RAISE FND_API.g_EXC_ERROR;
2908: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2909: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2910: END IF;
2911:
2912: --

Line 2909: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

2905:
2906: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2907: RAISE FND_API.g_EXC_ERROR;
2908: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2909: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2910: END IF;
2911:
2912: --
2913: -- Validate Effectivity_Control attribute

Line 2922: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN

2918: p_Item_rec => p_Item_rec
2919: , x_return_status => l_return_status
2920: );
2921:
2922: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2923: RAISE FND_API.g_EXC_ERROR;
2924: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2925: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2926: END IF;

Line 2923: RAISE FND_API.g_EXC_ERROR;

2919: , x_return_status => l_return_status
2920: );
2921:
2922: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2923: RAISE FND_API.g_EXC_ERROR;
2924: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2925: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2926: END IF;
2927:

Line 2924: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN

2920: );
2921:
2922: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2923: RAISE FND_API.g_EXC_ERROR;
2924: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2925: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2926: END IF;
2927:
2928: --

Line 2925: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

2921:
2922: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2923: RAISE FND_API.g_EXC_ERROR;
2924: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2925: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2926: END IF;
2927:
2928: --
2929: --

Line 2938: WHEN FND_API.g_EXC_ERROR THEN

2934: );
2935:
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

Line 2939: x_return_status := FND_API.g_RET_STS_ERROR;

2935:
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: );

Line 2945: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

2941: ( p_count => x_msg_count
2942: , p_data => x_msg_data
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

Line 2946: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

2942: , p_data => x_msg_data
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: );

Line 2953: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

2949: , p_data => x_msg_data
2950: );
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

Line 4062: ' , p_init_msg_list => FND_API.g_TRUE '||

4058: EXECUTE IMMEDIATE
4059: ' BEGIN '||
4060: ' ENI_ITEMS_STAR_PKG.Insert_Items_In_Star( '||
4061: ' p_api_version => 1.0 '||
4062: ' , p_init_msg_list => FND_API.g_TRUE '||
4063: ' , p_inventory_item_id => :l_Inventory_Item_ID '||
4064: ' , p_organization_id => :l_Organization_ID '||
4065: ' , x_return_status => :l_return_status '||
4066: ' , x_msg_count => :l_msg_count '||

Line 4071: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN

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

Line 4074: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN

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

Line 4172: p_init_msg_list => fnd_api.g_TRUE

4168:
4169: BEGIN
4170:
4171: INV_ITEM_PVT.Update_Org_Items(
4172: p_init_msg_list => fnd_api.g_TRUE
4173: ,p_commit => fnd_api.g_FALSE
4174: ,p_lock_rows => fnd_api.g_FALSE
4175: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4176: ,p_Item_rec => P_Item_Rec

Line 4173: ,p_commit => fnd_api.g_FALSE

4169: BEGIN
4170:
4171: INV_ITEM_PVT.Update_Org_Items(
4172: p_init_msg_list => fnd_api.g_TRUE
4173: ,p_commit => fnd_api.g_FALSE
4174: ,p_lock_rows => fnd_api.g_FALSE
4175: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4176: ,p_Item_rec => P_Item_Rec
4177: ,p_validate_Master => fnd_api.g_FALSE

Line 4174: ,p_lock_rows => fnd_api.g_FALSE

4170:
4171: INV_ITEM_PVT.Update_Org_Items(
4172: p_init_msg_list => fnd_api.g_TRUE
4173: ,p_commit => fnd_api.g_FALSE
4174: ,p_lock_rows => fnd_api.g_FALSE
4175: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4176: ,p_Item_rec => P_Item_Rec
4177: ,p_validate_Master => fnd_api.g_FALSE
4178: ,x_return_status => l_return_status

Line 4175: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL

4171: INV_ITEM_PVT.Update_Org_Items(
4172: p_init_msg_list => fnd_api.g_TRUE
4173: ,p_commit => fnd_api.g_FALSE
4174: ,p_lock_rows => fnd_api.g_FALSE
4175: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4176: ,p_Item_rec => P_Item_Rec
4177: ,p_validate_Master => fnd_api.g_FALSE
4178: ,x_return_status => l_return_status
4179: ,x_msg_count => l_msg_count

Line 4177: ,p_validate_Master => fnd_api.g_FALSE

4173: ,p_commit => fnd_api.g_FALSE
4174: ,p_lock_rows => fnd_api.g_FALSE
4175: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4176: ,p_Item_rec => P_Item_Rec
4177: ,p_validate_Master => fnd_api.g_FALSE
4178: ,x_return_status => l_return_status
4179: ,x_msg_count => l_msg_count
4180: ,x_msg_data => l_msg_data);
4181:

Line 4182: IF ( l_return_status = fnd_api.g_RET_STS_ERROR ) THEN

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

Line 4184: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 4185: ELSIF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN

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

Line 4187: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

4183: fnd_message.SET_ENCODED( l_msg_data );
4184: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4185: ELSIF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
4186: fnd_message.SET_ENCODED( l_msg_data );
4187: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4188: END IF;
4189:
4190: --
4191: -- Finally, send messages to dependent business objects.

Line 4222: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 4299: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 4303: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 4315: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 4410: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

4406: NULL;
4407: END;
4408:
4409: EXCEPTION
4410: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
4411: x_row_Id := NULL;
4412: IF c_get_uom_class%ISOPEN THEN
4413: CLOSE c_get_uom_class;
4414: END IF;

Line 4709: ' , p_init_msg_list => FND_API.g_TRUE '||

4705: EXECUTE IMMEDIATE
4706: ' BEGIN '||
4707: ' ENI_ITEMS_STAR_PKG.Update_Items_In_Star( '||
4708: ' p_api_version => 1.0 '||
4709: ' , p_init_msg_list => FND_API.g_TRUE '||
4710: ' , p_inventory_item_id => :P_Item_Rec.INVENTORY_ITEM_ID '||
4711: ' , p_organization_id => :P_Item_Rec.ORGANIZATION_ID '||
4712: ' , x_return_status => :l_return_status '||
4713: ' , x_msg_count => :l_msg_count '||

Line 4718: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN

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

Line 4720: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 4721: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN

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

Line 4723: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

4719: FND_MESSAGE.Set_Encoded (l_msg_data);
4720: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4721: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4722: FND_MESSAGE.Set_Encoded (l_msg_data);
4723: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4724: END IF;
4725: END IF;
4726:
4727: /* R12: Business Event Enhancement :

Line 4764: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

4760: --R12: Business Event Enhancement
4761:
4762:
4763: EXCEPTION
4764: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
4765: IF c_get_uom_class%ISOPEN THEN
4766: CLOSE c_get_uom_class;
4767: END IF;
4768: app_exception.raise_exception;

Line 5175: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 5837: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

5833: THEN
5834: NULL;
5835: ELSE
5836: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
5837: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5838: END IF;
5839:
5840:
5841: FOR item_tl IN c_get_item_description

Line 5852: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

5848: THEN
5849: NULL;
5850: ELSE
5851: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
5852: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5853: END IF;
5854: END IF;
5855: END LOOP;
5856:

Line 5863: , p_lock_Master => fnd_api.g_TRUE

5859: -- Lock organization items
5860: INV_ITEM_PVT.Lock_Org_Items (
5861: p_Item_ID => P_Item_Rec.inventory_item_id
5862: , p_Org_ID => P_Item_rec.organization_id
5863: , p_lock_Master => fnd_api.g_TRUE
5864: , p_lock_Orgs => fnd_api.g_TRUE
5865: , x_return_status => l_return_status);
5866:
5867: END IF;

Line 5864: , p_lock_Orgs => fnd_api.g_TRUE

5860: INV_ITEM_PVT.Lock_Org_Items (
5861: p_Item_ID => P_Item_Rec.inventory_item_id
5862: , p_Org_ID => P_Item_rec.organization_id
5863: , p_lock_Master => fnd_api.g_TRUE
5864: , p_lock_Orgs => fnd_api.g_TRUE
5865: , x_return_status => l_return_status);
5866:
5867: END IF;
5868:

Line 5870: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

5866:
5867: END IF;
5868:
5869: EXCEPTION
5870: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
5871: IF ( c_item_details%ISOPEN ) THEN
5872: CLOSE c_item_details;
5873: END IF;
5874: IF ( c_get_item_description%ISOPEN ) THEN

Line 6129: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 6135: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

6131:
6132: CLOSE c_item_name;
6133:
6134: EXCEPTION
6135: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
6136: IF ( c_item_name%ISOPEN ) THEN
6137: CLOSE c_item_name;
6138: END IF;
6139: app_exception.raise_exception;