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 336: IF ( FND_API.to_Boolean (p_init_msg_list) ) THEN

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

Line 342: x_return_status := FND_API.g_RET_STS_SUCCESS;

338: END IF;
339:
340: -- Initialize API return status to success
341: --
342: x_return_status := FND_API.g_RET_STS_SUCCESS;
343:
344: p_Item_ID := p_Item_rec.INVENTORY_ITEM_ID ;
345: p_Org_ID := p_Item_rec.ORGANIZATION_ID ;
346:

Line 352: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 365: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

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

369: ------------------------
370: -- Lock org item rows --
371: ------------------------
372:
373: IF ( FND_API.to_Boolean (p_lock_rows) ) THEN
374:
375: INV_ITEM_PVT.Lock_Org_Items
376: (
377: p_Item_ID => p_Item_ID

Line 379: , p_lock_Master => FND_API.g_TRUE

375: INV_ITEM_PVT.Lock_Org_Items
376: (
377: p_Item_ID => p_Item_ID
378: , p_Org_ID => p_Org_ID
379: , p_lock_Master => FND_API.g_TRUE
380: , p_lock_Orgs => FND_API.g_TRUE
381: , x_return_status => l_return_status
382: );
383:

Line 380: , p_lock_Orgs => FND_API.g_TRUE

376: (
377: p_Item_ID => p_Item_ID
378: , p_Org_ID => p_Org_ID
379: , p_lock_Master => FND_API.g_TRUE
380: , p_lock_Orgs => FND_API.g_TRUE
381: , x_return_status => l_return_status
382: );
383:
384: END IF; -- Lock org item rows

Line 403: , p_fetch_Master => FND_API.g_TRUE

399: OPEN INV_ITEM_API.Item_csr
400: (
401: p_Item_ID => p_Item_ID
402: , p_Org_ID => p_Org_ID
403: , p_fetch_Master => FND_API.g_TRUE
404: , p_fetch_Orgs => FND_API.g_TRUE
405: );
406: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
407:

Line 404: , p_fetch_Orgs => FND_API.g_TRUE

400: (
401: p_Item_ID => p_Item_ID
402: , p_Org_ID => p_Org_ID
403: , p_fetch_Master => FND_API.g_TRUE
404: , p_fetch_Orgs => FND_API.g_TRUE
405: );
406: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
407:
408: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN

Line 412: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

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

423: -- Depending on the input parameter, copy either --
424: -- input item record "as is", or changed atributes only --
425: ----------------------------------------------------------
426:
427: IF ( FND_API.to_Boolean (p_update_changes_only) )
428: THEN
429: -- Update changed attributes only - not implemented yet
430: /*
431: INV_ITEM_Lib.Copy_Changed_Attributes

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

448: -------------------------------------------------------
449: -- Item validation, depending on the input parameter --
450: -------------------------------------------------------
451:
452: IF ( FND_API.to_Boolean (p_validate_Master) ) THEN
453:
454: IF (l_Item_rec.inventory_item_flag ='N' AND
455: l_Item_rec.stock_enabled_flag ='Y' ) THEN
456: fnd_message.SET_NAME('INV', 'INVALID_INV_STK_FLAG_COMB');

Line 458: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 463: 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
467: fnd_message.SET_NAME('INV', 'INVALID_CHK_TRX_FLAG_COMB');

Line 469: l_return_status := FND_API.g_RET_STS_ERROR;

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

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

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

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

Line 492: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 499: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 505: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 512: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 531: l_return_status := FND_API.g_RET_STS_ERROR;

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

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

542: , x_msg_data => x_msg_data
543: );
544: */
545:
546: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
547: RAISE FND_API.g_EXC_ERROR;
548: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
549: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
550: END IF;

Line 547: RAISE FND_API.g_EXC_ERROR;

543: );
544: */
545:
546: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
547: RAISE FND_API.g_EXC_ERROR;
548: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
549: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
550: END IF;
551:

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

544: */
545:
546: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
547: RAISE FND_API.g_EXC_ERROR;
548: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
549: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
550: END IF;
551:
552: END IF; -- validate master

Line 549: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

545:
546: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
547: RAISE FND_API.g_EXC_ERROR;
548: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
549: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
550: END IF;
551:
552: END IF; -- validate master
553:

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

577: -- Get a list of master control level attributes
578:
579: Get_Master_Attributes ( x_return_status => l_return_status );
580:
581: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
582: RAISE FND_API.g_EXC_ERROR;
583: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
584: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
585: END IF;

Line 582: RAISE FND_API.g_EXC_ERROR;

578:
579: Get_Master_Attributes ( x_return_status => l_return_status );
580:
581: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
582: RAISE FND_API.g_EXC_ERROR;
583: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
584: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
585: END IF;
586: /*

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

579: Get_Master_Attributes ( x_return_status => l_return_status );
580:
581: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
582: RAISE FND_API.g_EXC_ERROR;
583: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
584: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
585: END IF;
586: /*
587: ELSE

Line 584: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

580:
581: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
582: RAISE FND_API.g_EXC_ERROR;
583: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
584: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
585: END IF;
586: /*
587: ELSE
588: fnd_message.Set_Name( 'INV', 'Master_Attribute.COUNT <> 0' );

Line 590: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 2406: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

2402: ELSE
2403: --------------------------
2404: -- Invalid attribute code
2405: --------------------------
2406: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2407:
2408: FND_MESSAGE.Set_Name ('INV', 'INV_INVALID_ATTRIBUTE_CODE');
2409: FND_MESSAGE.Set_Token ('PACKAGE_NAME', G_PKG_NAME);
2410: FND_MESSAGE.Set_Token ('PROCEDURE_NAME', l_api_name);

Line 2414: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

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

2425: , x_return_status => l_return_status
2426: );
2427:
2428: x_return_status := l_return_status;
2429: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2430: RAISE FND_API.g_EXC_ERROR;
2431: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2432: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2433: END IF;

Line 2430: RAISE FND_API.g_EXC_ERROR;

2426: );
2427:
2428: x_return_status := l_return_status;
2429: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2430: RAISE FND_API.g_EXC_ERROR;
2431: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2432: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2433: END IF;
2434: */

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

2427:
2428: x_return_status := l_return_status;
2429: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2430: RAISE FND_API.g_EXC_ERROR;
2431: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2432: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2433: END IF;
2434: */
2435:

Line 2432: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

2428: x_return_status := l_return_status;
2429: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2430: RAISE FND_API.g_EXC_ERROR;
2431: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2432: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2433: END IF;
2434: */
2435:
2436: END LOOP; -- loop through item attributes

Line 2602: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2607: 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
2611: fnd_message.SET_NAME('INV', 'INVALID_CHK_TRX_FLAG_COMB');

Line 2613: l_return_status := FND_API.g_RET_STS_ERROR;

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

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

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

Line 2630: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2637: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2645: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2652: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2658: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2665: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2677: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2689: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2695: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2702: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2708: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2714: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2720: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2730: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2736: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2742: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2748: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2757: l_return_status := FND_API.g_RET_STS_ERROR;

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.
2761: -- The restriction on EAM and WMS enabled orgs has to be relaxed

Line 2770: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2778: l_return_status := FND_API.g_RET_STS_ERROR;

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

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

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

Line 2791: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2797: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2805: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2816: l_return_status := FND_API.g_RET_STS_ERROR;

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.
2820: -- The restriction on EAM and WMS enabled orgs has to be relaxed

Line 2831: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2837: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2862: l_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2886: l_return_status := FND_API.g_RET_STS_ERROR;

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

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

2888: END IF;
2889:
2890:
2891: -- Check for errors
2892: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2893: RAISE FND_API.g_EXC_ERROR;
2894: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2895: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2896: END IF;

Line 2893: RAISE FND_API.g_EXC_ERROR;

2889:
2890:
2891: -- Check for errors
2892: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2893: RAISE FND_API.g_EXC_ERROR;
2894: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2895: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2896: END IF;
2897:

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

2890:
2891: -- Check for errors
2892: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2893: RAISE FND_API.g_EXC_ERROR;
2894: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2895: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2896: END IF;
2897:
2898: ---------------------------------

Line 2895: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

2891: -- Check for errors
2892: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
2893: RAISE FND_API.g_EXC_ERROR;
2894: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
2895: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2896: END IF;
2897:
2898: ---------------------------------
2899: -- Update current org item row --

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

2915: ----------------------------------- p_Org is master ---
2916:
2917: CLOSE INV_ITEM_API.Item_csr;
2918:
2919: IF ( FND_API.to_Boolean (p_commit) ) THEN
2920: COMMIT WORK;
2921: END IF;
2922:
2923: FND_MSG_PUB.Count_And_Get

Line 2930: WHEN FND_API.g_EXC_ERROR THEN

2926: );
2927:
2928: EXCEPTION
2929:
2930: WHEN FND_API.g_EXC_ERROR THEN
2931:
2932: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2933: CLOSE INV_ITEM_API.Item_csr;
2934: END IF;

Line 2937: x_return_status := FND_API.g_RET_STS_ERROR;

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

Line 2943: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

2939: ( p_count => x_msg_count
2940: , p_data => x_msg_data
2941: );
2942:
2943: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
2944:
2945: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2946: CLOSE INV_ITEM_API.Item_csr;
2947: END IF;

Line 2950: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

Line 2963: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

Line 2987: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE

2983: /*------------------------------- Get_Org_Item -------------------------------*/
2984:
2985: PROCEDURE Get_Org_Item
2986: (
2987: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
2988: , p_Item_ID IN NUMBER
2989: , p_Org_ID IN NUMBER
2990: , p_Language IN VARCHAR2 := FND_API.g_MISS_CHAR
2991: , x_Item_rec OUT NOCOPY INV_ITEM_API.Item_rec_type

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

2986: (
2987: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
2988: , p_Item_ID IN NUMBER
2989: , p_Org_ID IN NUMBER
2990: , p_Language IN VARCHAR2 := FND_API.g_MISS_CHAR
2991: , x_Item_rec OUT NOCOPY INV_ITEM_API.Item_rec_type
2992: , x_return_status OUT NOCOPY VARCHAR2
2993: , x_msg_count OUT NOCOPY NUMBER
2994: , x_msg_data OUT NOCOPY VARCHAR2

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

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

Line 3014: x_return_status := FND_API.g_RET_STS_SUCCESS;

3010: END IF;
3011:
3012: -- Initialize API return status to success
3013: --
3014: x_return_status := FND_API.g_RET_STS_SUCCESS;
3015:
3016: IF ( p_Item_ID IS NULL ) OR
3017: ( p_Org_ID IS NULL )
3018: THEN

Line 3019: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

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

3024:
3025: /*
3026: -- Get the translation row
3027: --
3028: IF ( p_Language <> FND_API.g_MISS_CHAR ) THEN
3029:
3030: END IF;
3031: */
3032:

Line 3041: , p_fetch_Master => FND_API.g_TRUE

3037: OPEN INV_ITEM_API.Item_csr
3038: (
3039: p_Item_ID => p_Item_ID
3040: , p_Org_ID => p_Org_ID
3041: , p_fetch_Master => FND_API.g_TRUE
3042: , p_fetch_Orgs => FND_API.g_FALSE
3043: );
3044:
3045: -- Fetch org item row

Line 3042: , p_fetch_Orgs => FND_API.g_FALSE

3038: (
3039: p_Item_ID => p_Item_ID
3040: , p_Org_ID => p_Org_ID
3041: , p_fetch_Master => FND_API.g_TRUE
3042: , p_fetch_Orgs => FND_API.g_FALSE
3043: );
3044:
3045: -- Fetch org item row
3046: --

Line 3053: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 3065: WHEN FND_API.g_EXC_ERROR THEN

3061: );
3062:
3063: EXCEPTION
3064:
3065: WHEN FND_API.g_EXC_ERROR THEN
3066:
3067: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
3068: CLOSE INV_ITEM_API.Item_csr;
3069: END IF;

Line 3071: x_return_status := FND_API.g_RET_STS_ERROR;

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

Line 3077: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

3073: ( p_count => x_msg_count
3074: , p_data => x_msg_data
3075: );
3076:
3077: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3078:
3079: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
3080: CLOSE INV_ITEM_API.Item_csr;
3081: END IF;

Line 3083: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

Line 3095: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

Line 3123: p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL

3119:
3120: /*
3121: PROCEDURE Validate_Item
3122: (
3123: p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
3124: , p_Item_rec IN INV_ITEM_API.Item_rec_type
3125: , x_return_status OUT NOCOPY VARCHAR2
3126: , x_msg_count OUT NOCOPY NUMBER
3127: , x_msg_data OUT NOCOPY VARCHAR2

Line 3144: x_return_status := FND_API.g_RET_STS_SUCCESS;

3140: l_Org_ID := p_Item_rec.ORGANIZATION_ID ;
3141:
3142: -- Initialize API return status to success
3143: --
3144: x_return_status := FND_API.g_RET_STS_SUCCESS;
3145:
3146: IF ( l_Item_ID IS NULL ) OR
3147: ( l_Org_ID IS NULL )
3148: THEN

Line 3149: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

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

3163: );
3164:
3165: -- Raise an error as soon as the first fault is encountered
3166:
3167: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
3168: RAISE FND_API.g_EXC_ERROR;
3169: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
3170: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3171: END IF;

Line 3168: RAISE FND_API.g_EXC_ERROR;

3164:
3165: -- Raise an error as soon as the first fault is encountered
3166:
3167: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
3168: RAISE FND_API.g_EXC_ERROR;
3169: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
3170: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3171: END IF;
3172:

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

3165: -- Raise an error as soon as the first fault is encountered
3166:
3167: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
3168: RAISE FND_API.g_EXC_ERROR;
3169: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
3170: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3171: END IF;
3172:
3173: --

Line 3170: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

3166:
3167: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
3168: RAISE FND_API.g_EXC_ERROR;
3169: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
3170: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3171: END IF;
3172:
3173: --
3174: -- Validate Effectivity_Control attribute

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

3179: p_Item_rec => p_Item_rec
3180: , x_return_status => l_return_status
3181: );
3182:
3183: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
3184: RAISE FND_API.g_EXC_ERROR;
3185: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
3186: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3187: END IF;

Line 3184: RAISE FND_API.g_EXC_ERROR;

3180: , x_return_status => l_return_status
3181: );
3182:
3183: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
3184: RAISE FND_API.g_EXC_ERROR;
3185: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
3186: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3187: END IF;
3188:

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

3181: );
3182:
3183: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
3184: RAISE FND_API.g_EXC_ERROR;
3185: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
3186: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3187: END IF;
3188:
3189: --

Line 3186: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

3182:
3183: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
3184: RAISE FND_API.g_EXC_ERROR;
3185: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
3186: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3187: END IF;
3188:
3189: --
3190: --

Line 3199: WHEN FND_API.g_EXC_ERROR THEN

3195: );
3196:
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

Line 3200: x_return_status := FND_API.g_RET_STS_ERROR;

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

Line 3206: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

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

Line 3207: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

Line 3214: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

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

4323: EXECUTE IMMEDIATE
4324: ' BEGIN '||
4325: ' ENI_ITEMS_STAR_PKG.Insert_Items_In_Star( '||
4326: ' p_api_version => 1.0 '||
4327: ' , p_init_msg_list => FND_API.g_TRUE '||
4328: ' , p_inventory_item_id => :l_Inventory_Item_ID '||
4329: ' , p_organization_id => :l_Organization_ID '||
4330: ' , x_return_status => :l_return_status '||
4331: ' , x_msg_count => :l_msg_count '||

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

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

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

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

Line 4437: p_init_msg_list => fnd_api.g_TRUE

4433:
4434: BEGIN
4435:
4436: INV_ITEM_PVT.Update_Org_Items(
4437: p_init_msg_list => fnd_api.g_TRUE
4438: ,p_commit => fnd_api.g_FALSE
4439: ,p_lock_rows => fnd_api.g_FALSE
4440: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4441: ,p_Item_rec => P_Item_Rec

Line 4438: ,p_commit => fnd_api.g_FALSE

4434: BEGIN
4435:
4436: INV_ITEM_PVT.Update_Org_Items(
4437: p_init_msg_list => fnd_api.g_TRUE
4438: ,p_commit => fnd_api.g_FALSE
4439: ,p_lock_rows => fnd_api.g_FALSE
4440: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4441: ,p_Item_rec => P_Item_Rec
4442: ,p_validate_Master => fnd_api.g_FALSE

Line 4439: ,p_lock_rows => fnd_api.g_FALSE

4435:
4436: INV_ITEM_PVT.Update_Org_Items(
4437: p_init_msg_list => fnd_api.g_TRUE
4438: ,p_commit => fnd_api.g_FALSE
4439: ,p_lock_rows => fnd_api.g_FALSE
4440: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4441: ,p_Item_rec => P_Item_Rec
4442: ,p_validate_Master => fnd_api.g_FALSE
4443: ,x_return_status => l_return_status

Line 4440: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL

4436: INV_ITEM_PVT.Update_Org_Items(
4437: p_init_msg_list => fnd_api.g_TRUE
4438: ,p_commit => fnd_api.g_FALSE
4439: ,p_lock_rows => fnd_api.g_FALSE
4440: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4441: ,p_Item_rec => P_Item_Rec
4442: ,p_validate_Master => fnd_api.g_FALSE
4443: ,x_return_status => l_return_status
4444: ,x_msg_count => l_msg_count

Line 4442: ,p_validate_Master => fnd_api.g_FALSE

4438: ,p_commit => fnd_api.g_FALSE
4439: ,p_lock_rows => fnd_api.g_FALSE
4440: ,p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4441: ,p_Item_rec => P_Item_Rec
4442: ,p_validate_Master => fnd_api.g_FALSE
4443: ,x_return_status => l_return_status
4444: ,x_msg_count => l_msg_count
4445: ,x_msg_data => l_msg_data);
4446:

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

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

Line 4449: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

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

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

Line 4452: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

4448: fnd_message.SET_ENCODED( l_msg_data );
4449: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4450: ELSIF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
4451: fnd_message.SET_ENCODED( l_msg_data );
4452: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
4453: END IF;
4454:
4455: --
4456: -- Finally, send messages to dependent business objects.

Line 4487: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 4564: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 4568: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 4580: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 4675: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

4671: NULL;
4672: END;
4673:
4674: EXCEPTION
4675: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
4676: x_row_Id := NULL;
4677: IF c_get_uom_class%ISOPEN THEN
4678: CLOSE c_get_uom_class;
4679: END IF;

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

5057: EXECUTE IMMEDIATE
5058: ' BEGIN '||
5059: ' ENI_ITEMS_STAR_PKG.Update_Items_In_Star( '||
5060: ' p_api_version => 1.0 '||
5061: ' , p_init_msg_list => FND_API.g_TRUE '||
5062: ' , p_inventory_item_id => :P_Item_Rec.INVENTORY_ITEM_ID '||
5063: ' , p_organization_id => :P_Item_Rec.ORGANIZATION_ID '||
5064: ' , x_return_status => :l_return_status '||
5065: ' , x_msg_count => :l_msg_count '||

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

5066: ' , x_msg_data => :l_msg_data ); '||
5067: ' END;'
5068: USING IN P_Item_Rec.INVENTORY_ITEM_ID, IN P_Item_Rec.ORGANIZATION_ID, OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
5069:
5070: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
5071: FND_MESSAGE.Set_Encoded (l_msg_data);
5072: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5073: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
5074: FND_MESSAGE.Set_Encoded (l_msg_data);

Line 5072: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

5068: USING IN P_Item_Rec.INVENTORY_ITEM_ID, IN P_Item_Rec.ORGANIZATION_ID, OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
5069:
5070: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
5071: FND_MESSAGE.Set_Encoded (l_msg_data);
5072: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5073: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
5074: FND_MESSAGE.Set_Encoded (l_msg_data);
5075: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5076: END IF;

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

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

Line 5075: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

5071: FND_MESSAGE.Set_Encoded (l_msg_data);
5072: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5073: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
5074: FND_MESSAGE.Set_Encoded (l_msg_data);
5075: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
5076: END IF;
5077: END IF;
5078:
5079: /* R12: Business Event Enhancement :

Line 5116: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

5112: --R12: Business Event Enhancement
5113:
5114:
5115: EXCEPTION
5116: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
5117: IF c_get_uom_class%ISOPEN THEN
5118: CLOSE c_get_uom_class;
5119: END IF;
5120: app_exception.raise_exception;

Line 5529: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 6194: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

6190: THEN
6191: NULL;
6192: ELSE
6193: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
6194: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
6195: END IF;
6196:
6197:
6198: FOR item_tl IN c_get_item_description

Line 6209: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

6205: THEN
6206: NULL;
6207: ELSE
6208: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
6209: Raise FND_API.g_EXC_UNEXPECTED_ERROR;
6210: END IF;
6211: END IF;
6212: END LOOP;
6213:

Line 6220: , p_lock_Master => fnd_api.g_TRUE

6216: -- Lock organization items
6217: INV_ITEM_PVT.Lock_Org_Items (
6218: p_Item_ID => P_Item_Rec.inventory_item_id
6219: , p_Org_ID => P_Item_rec.organization_id
6220: , p_lock_Master => fnd_api.g_TRUE
6221: , p_lock_Orgs => fnd_api.g_TRUE
6222: , x_return_status => l_return_status);
6223:
6224: END IF;

Line 6221: , p_lock_Orgs => fnd_api.g_TRUE

6217: INV_ITEM_PVT.Lock_Org_Items (
6218: p_Item_ID => P_Item_Rec.inventory_item_id
6219: , p_Org_ID => P_Item_rec.organization_id
6220: , p_lock_Master => fnd_api.g_TRUE
6221: , p_lock_Orgs => fnd_api.g_TRUE
6222: , x_return_status => l_return_status);
6223:
6224: END IF;
6225:

Line 6227: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

6223:
6224: END IF;
6225:
6226: EXCEPTION
6227: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
6228: IF ( c_item_details%ISOPEN ) THEN
6229: CLOSE c_item_details;
6230: END IF;
6231: IF ( c_get_item_description%ISOPEN ) THEN

Line 6632: Raise FND_API.g_EXC_UNEXPECTED_ERROR;

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

Line 6638: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

6634:
6635: CLOSE c_item_name;
6636:
6637: EXCEPTION
6638: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
6639: IF ( c_item_name%ISOPEN ) THEN
6640: CLOSE c_item_name;
6641: END IF;
6642: app_exception.raise_exception;