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.AMS_ITEM_OWNER_PVT dependencies on FND_API

Line 87: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

83:
84: -- Hint: Primary key needs to be returned.
85: PROCEDURE Create_item_owner(
86: P_Api_Version_Number IN NUMBER,
87: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
88: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90:
91: X_Return_Status OUT NOCOPY VARCHAR2,

Line 88: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

84: -- Hint: Primary key needs to be returned.
85: PROCEDURE Create_item_owner(
86: P_Api_Version_Number IN NUMBER,
87: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
88: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90:
91: X_Return_Status OUT NOCOPY VARCHAR2,
92: X_Msg_Count OUT NOCOPY NUMBER,

Line 89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

85: PROCEDURE Create_item_owner(
86: P_Api_Version_Number IN NUMBER,
87: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
88: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90:
91: X_Return_Status OUT NOCOPY VARCHAR2,
92: X_Msg_Count OUT NOCOPY NUMBER,
93: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 119: l_org_id NUMBER := FND_API.G_MISS_NUM;

115: l_api_name CONSTANT VARCHAR2(30) := 'Create_item_owner';
116: l_api_version_number CONSTANT NUMBER := 1.0;
117: l_return_status_full VARCHAR2(1);
118: l_object_version_number NUMBER := 1;
119: l_org_id NUMBER := FND_API.G_MISS_NUM;
120: l_ITEM_OWNER_ID NUMBER;
121: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;
122: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
123: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;

Line 121: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;

117: l_return_status_full VARCHAR2(1);
118: l_object_version_number NUMBER := 1;
119: l_org_id NUMBER := FND_API.G_MISS_NUM;
120: l_ITEM_OWNER_ID NUMBER;
121: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;
122: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
123: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;
124: l_error_tbl INV_Item_GRP.Error_tbl_Type ;
125: l_object_id NUMBER;

Line 134: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

130: -- Standard Start of API savepoint
131: SAVEPOINT CREATE_ITEM_OWNER_PVT;
132:
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
135: p_api_version_number,
136: l_api_name,
137: G_PKG_NAME)
138: THEN

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

135: p_api_version_number,
136: l_api_name,
137: G_PKG_NAME)
138: THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141:
142: -- Initialize message list if p_init_msg_list is set to TRUE.
143: IF FND_API.to_Boolean( p_init_msg_list )

Line 143: IF FND_API.to_Boolean( p_init_msg_list )

139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141:
142: -- Initialize message list if p_init_msg_list is set to TRUE.
143: IF FND_API.to_Boolean( p_init_msg_list )
144: THEN
145: FND_MSG_PUB.initialize;
146: END IF;
147:

Line 155: x_return_status := FND_API.G_RET_STS_SUCCESS;

151: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
152: END IF;
153:
154: -- Initialize API return status to SUCCESS
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156:
157:
158: -- Initialize inventory API return status to SUCCESS
159: x_item_return_status := FND_API.G_RET_STS_SUCCESS;

Line 159: x_item_return_status := FND_API.G_RET_STS_SUCCESS;

155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156:
157:
158: -- Initialize inventory API return status to SUCCESS
159: x_item_return_status := FND_API.G_RET_STS_SUCCESS;
160:
161: -- ******************************************************************
162: -- Validate Environment
163: -- ******************************************************************

Line 171: RAISE FND_API.G_EXC_ERROR;

167: THEN
168: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
169: FND_MSG_PUB.ADD;
170: END IF;
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
175: THEN

Line 174: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

170: END IF;
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
175: THEN
176: -- Debug message
177: IF (AMS_DEBUG_HIGH_ON) THEN
178:

Line 185: p_init_msg_list => FND_API.G_FALSE,

181:
182: -- Invoke validation procedures
183: Validate_item_owner(
184: p_api_version_number => 1.0,
185: p_init_msg_list => FND_API.G_FALSE,
186: p_validation_level => p_validation_level,
187: P_ITEM_OWNER_Rec => P_ITEM_OWNER_Rec,
188: P_ITEM_REC_In => p_item_rec_in,
189: x_return_status => x_return_status,

Line 194: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

190: x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);
192: END IF;
193:
194: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198:

Line 195: RAISE FND_API.G_EXC_ERROR;

191: x_msg_data => x_msg_data);
192: END IF;
193:
194: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198:
199:

Line 256: -- intiating the attributes only if its not null and not fnd_api.g_miss_char

252:
253: /** Flags added for DELV and EVEH requirements ************/
254: /** By ABHOLA *********************************************/
255:
256: -- intiating the attributes only if its not null and not fnd_api.g_miss_char
257: init_inv_item_rec(p_item_rec_in,l_inv_item_rec_in);
258:
259: /*
260: IF (p_item_rec_in.costing_enabled_flag IS NOT NULL)

Line 261: OR (p_item_rec_in.costing_enabled_flag <> FND_API.G_MISS_CHAR )

257: init_inv_item_rec(p_item_rec_in,l_inv_item_rec_in);
258:
259: /*
260: IF (p_item_rec_in.costing_enabled_flag IS NOT NULL)
261: OR (p_item_rec_in.costing_enabled_flag <> FND_API.G_MISS_CHAR )
262: THEN
263: l_inv_item_rec_in.costing_enabled_flag := p_item_rec_in.costing_enabled_flag;
264: END IF;
265:

Line 267: OR (p_item_rec_in.collateral_flag <> FND_API.G_MISS_CHAR )

263: l_inv_item_rec_in.costing_enabled_flag := p_item_rec_in.costing_enabled_flag;
264: END IF;
265:
266: IF (p_item_rec_in.collateral_flag IS NOT NULL)
267: OR (p_item_rec_in.collateral_flag <> FND_API.G_MISS_CHAR )
268: THEN
269: l_inv_item_rec_in.collateral_flag := p_item_rec_in.collateral_flag ;
270: END IF;
271:

Line 273: OR (p_item_rec_in.customer_order_flag <> FND_API.G_MISS_CHAR )

269: l_inv_item_rec_in.collateral_flag := p_item_rec_in.collateral_flag ;
270: END IF;
271:
272: IF (p_item_rec_in.customer_order_flag IS NOT NULL)
273: OR (p_item_rec_in.customer_order_flag <> FND_API.G_MISS_CHAR )
274: THEN
275: l_inv_item_rec_in.customer_order_flag := p_item_rec_in.customer_order_flag ;
276: END IF;
277:

Line 279: OR (p_item_rec_in.customer_order_enabled_flag <> FND_API.G_MISS_CHAR )

275: l_inv_item_rec_in.customer_order_flag := p_item_rec_in.customer_order_flag ;
276: END IF;
277:
278: IF (p_item_rec_in.customer_order_enabled_flag IS NOT NULL)
279: OR (p_item_rec_in.customer_order_enabled_flag <> FND_API.G_MISS_CHAR )
280: THEN
281: l_inv_item_rec_in.customer_order_enabled_flag := p_item_rec_in.customer_order_enabled_flag ;
282: END IF;
283:

Line 285: OR (p_item_rec_in.shippable_item_flag <> FND_API.G_MISS_CHAR )

281: l_inv_item_rec_in.customer_order_enabled_flag := p_item_rec_in.customer_order_enabled_flag ;
282: END IF;
283:
284: IF (p_item_rec_in.shippable_item_flag IS NOT NULL)
285: OR (p_item_rec_in.shippable_item_flag <> FND_API.G_MISS_CHAR )
286: THEN
287: l_inv_item_rec_in.shippable_item_flag := p_item_rec_in.shippable_item_flag ;
288: END IF;
289:

Line 291: OR (p_item_rec_in.event_flag <> FND_API.G_MISS_CHAR )

287: l_inv_item_rec_in.shippable_item_flag := p_item_rec_in.shippable_item_flag ;
288: END IF;
289:
290: IF (p_item_rec_in.event_flag IS NOT NULL)
291: OR (p_item_rec_in.event_flag <> FND_API.G_MISS_CHAR )
292: THEN
293: l_inv_item_rec_in.event_flag := p_item_rec_in.event_flag ;
294: END IF;
295: */

Line 335: IF l_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

331: );
332:
333:
334: x_item_return_status := l_item_return_status;
335: IF l_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
336: IF l_error_tbl.count >0 THEN
337: FOR l_cnt IN 1..l_error_tbl.count LOOP
338: x_error_tbl(l_cnt).transaction_id := l_error_tbl(l_cnt).transaction_id;
339: x_error_tbl(l_cnt).unique_id := l_error_tbl(l_cnt).unique_id;

Line 350: RAISE FND_API.G_EXC_ERROR;

346: --dbms_output.put_line('The coulmn name is '||x_error_tbl(l_cnt).column_name);
347: x_error_tbl(l_cnt).organization_id := l_error_tbl(l_cnt).organization_id;
348: END LOOP;
349: END IF;
350: RAISE FND_API.G_EXC_ERROR;
351: ELSE
352: p_item_rec_out.INVENTORY_ITEM_ID := l_inv_item_rec_out.INVENTORY_ITEM_ID ;
353: p_item_rec_out.ORGANIZATION_ID := l_inv_item_rec_out.ORGANIZATION_ID ;
354: p_item_rec_out.ITEM_NUMBER := l_inv_item_rec_out.ITEM_NUMBER ;

Line 417: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

413: p_IS_MASTER_ITEM => p_ITEM_OWNER_rec.IS_MASTER_ITEM,
414: p_ITEM_SETUP_TYPE => 'S', -- p_ITEM_OWNER_rec.ITEM_SETUP_TYPE,
415: p_CUSTOM_SETUP_ID => p_ITEM_OWNER_rec.CUSTOM_SETUP_ID); --'1200'
416:
417: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421: X_ITEM_OWNER_ID := l_ITEM_OWNER_ID;

Line 418: RAISE FND_API.G_EXC_ERROR;

414: p_ITEM_SETUP_TYPE => 'S', -- p_ITEM_OWNER_rec.ITEM_SETUP_TYPE,
415: p_CUSTOM_SETUP_ID => p_ITEM_OWNER_rec.CUSTOM_SETUP_ID); --'1200'
416:
417: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421: X_ITEM_OWNER_ID := l_ITEM_OWNER_ID;
422:

Line 428: IF FND_API.to_Boolean( p_commit )

424: -- End of API body
425: --
426:
427: -- Standard check for p_commit
428: IF FND_API.to_Boolean( p_commit )
429: THEN
430: COMMIT WORK;
431: END IF;
432:

Line 443: WHEN FND_API.G_EXC_ERROR THEN

439: (p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: -- Standard call to get message count and if count=1, get the message
447: FND_MSG_PUB.Count_And_Get (

Line 445: x_return_status := FND_API.G_RET_STS_ERROR;

441: );
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: -- Standard call to get message count and if count=1, get the message
447: FND_MSG_PUB.Count_And_Get (
448: p_encoded => FND_API.G_FALSE,
449: p_count => x_msg_count,

Line 448: p_encoded => FND_API.G_FALSE,

444: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: -- Standard call to get message count and if count=1, get the message
447: FND_MSG_PUB.Count_And_Get (
448: p_encoded => FND_API.G_FALSE,
449: p_count => x_msg_count,
450: p_data => x_msg_data
451: );
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

448: p_encoded => FND_API.G_FALSE,
449: p_count => x_msg_count,
450: p_data => x_msg_data
451: );
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: -- Standard call to get message count and if count=1, get the message
456: FND_MSG_PUB.Count_And_Get (

Line 454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

450: p_data => x_msg_data
451: );
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: -- Standard call to get message count and if count=1, get the message
456: FND_MSG_PUB.Count_And_Get (
457: p_encoded => FND_API.G_FALSE,
458: p_count => x_msg_count,

Line 457: p_encoded => FND_API.G_FALSE,

453: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: -- Standard call to get message count and if count=1, get the message
456: FND_MSG_PUB.Count_And_Get (
457: p_encoded => FND_API.G_FALSE,
458: p_count => x_msg_count,
459: p_data => x_msg_data
460: );
461: WHEN OTHERS THEN

Line 463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

459: p_data => x_msg_data
460: );
461: WHEN OTHERS THEN
462: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;

Line 470: p_encoded => FND_API.G_FALSE,

466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );
474: End Create_item_owner;

Line 479: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

475:
476:
477: PROCEDURE Update_item_owner(
478: P_Api_Version_Number IN NUMBER,
479: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
480: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482:
483: X_Return_Status OUT NOCOPY VARCHAR2,

Line 480: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

476:
477: PROCEDURE Update_item_owner(
478: P_Api_Version_Number IN NUMBER,
479: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
480: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482:
483: X_Return_Status OUT NOCOPY VARCHAR2,
484: X_Msg_Count OUT NOCOPY NUMBER,

Line 481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

477: PROCEDURE Update_item_owner(
478: P_Api_Version_Number IN NUMBER,
479: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
480: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482:
483: X_Return_Status OUT NOCOPY VARCHAR2,
484: X_Msg_Count OUT NOCOPY NUMBER,
485: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 538: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;

534: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
535: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;
536: l_error_tbl INV_Item_GRP.Error_tbl_Type ;
537:
538: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;
539:
540: l_can_update_inv_item VARCHAR2(1);
541:
542: l_status_controlled_item VARCHAR2(1) := 'N';

Line 549: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

545: -- Standard Start of API savepoint
546: SAVEPOINT UPDATE_ITEM_OWNER_PVT;
547:
548: -- Standard call to check for call compatibility.
549: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
550: p_api_version_number,
551: l_api_name,
552: G_PKG_NAME)
553: THEN

Line 554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

550: p_api_version_number,
551: l_api_name,
552: G_PKG_NAME)
553: THEN
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: END IF;
556:
557: -- Initialize message list if p_init_msg_list is set to TRUE.
558: IF FND_API.to_Boolean( p_init_msg_list )

Line 558: IF FND_API.to_Boolean( p_init_msg_list )

554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: END IF;
556:
557: -- Initialize message list if p_init_msg_list is set to TRUE.
558: IF FND_API.to_Boolean( p_init_msg_list )
559: THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:

Line 571: x_return_status := FND_API.G_RET_STS_SUCCESS;

567: END IF;
568:
569:
570: -- Initialize API return status to SUCCESS
571: x_return_status := FND_API.G_RET_STS_SUCCESS;
572:
573: -- Initialize inventory API return status to SUCCESS
574: x_item_return_status := FND_API.G_RET_STS_SUCCESS;
575:

Line 574: x_item_return_status := FND_API.G_RET_STS_SUCCESS;

570: -- Initialize API return status to SUCCESS
571: x_return_status := FND_API.G_RET_STS_SUCCESS;
572:
573: -- Initialize inventory API return status to SUCCESS
574: x_item_return_status := FND_API.G_RET_STS_SUCCESS;
575:
576: -- Debug Message
577: IF (AMS_DEBUG_HIGH_ON) THEN
578:

Line 606: raise FND_API.G_EXC_ERROR;

602: THEN
603: FND_MESSAGE.Set_Name('AMS', 'AMS_CANNOT_UPDATE_INV_ITEM');
604: FND_MSG_PUB.Add;
605: END IF;
606: raise FND_API.G_EXC_ERROR;
607: end if;
608: /******************* end by ABHOLA ****************************************/
609:
610: if (IS_OMO_ITEM = 'Y') then

Line 635: raise FND_API.G_EXC_ERROR;

631: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
632: FND_MESSAGE.Set_Token ('INFO', 'item_owner', FALSE);
633: FND_MSG_PUB.Add;
634: END IF;
635: raise FND_API.G_EXC_ERROR;
636: END IF;
637: -- Debug Message
638: IF (AMS_DEBUG_HIGH_ON) THEN
639:

Line 648: l_tar_ITEM_OWNER_rec.object_version_number = FND_API.G_MISS_NUM ) Then

644:
645: if (IS_OMO_ITEM = 'Y') then
646:
647: If (l_tar_ITEM_OWNER_rec.object_version_number is NULL or
648: l_tar_ITEM_OWNER_rec.object_version_number = FND_API.G_MISS_NUM ) Then
649: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
650: THEN
651: FND_MESSAGE.Set_Name('AMS', 'API_VERSION_MISSING');
652: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line 655: raise FND_API.G_EXC_ERROR;

651: FND_MESSAGE.Set_Name('AMS', 'API_VERSION_MISSING');
652: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
653: FND_MSG_PUB.ADD;
654: END IF;
655: raise FND_API.G_EXC_ERROR;
656: End if;
657:
658:
659:

Line 669: raise FND_API.G_EXC_ERROR;

665: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
666: FND_MESSAGE.Set_Token('INFO', 'item_owner', FALSE);
667: FND_MSG_PUB.ADD;
668: END IF;
669: raise FND_API.G_EXC_ERROR;
670: End if;
671:
672: end if ;-- end of if (IS_OMO_ITEM = 'Y') check
673:

Line 678: RAISE FND_API.G_EXC_ERROR;

674: /* Bug fix start */
675: IF (l_ref_ITEM_OWNER_rec.STATUS_CODE='CANCEL')THEN
676: FND_MESSAGE.Set_Name('AMS', 'AMS_CANNOT_UPDATE_PRODUCT');
677: FND_MSG_PUB.Add;
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680: /* Bug fix ends*/
681: /* calling validate item */
682: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 682: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680: /* Bug fix ends*/
681: /* calling validate item */
682: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
683: THEN
684:
685: -- Invoke validation procedures
686: Validate_item_owner(

Line 688: p_init_msg_list => FND_API.G_FALSE,

684:
685: -- Invoke validation procedures
686: Validate_item_owner(
687: p_api_version_number => 1.0,
688: p_init_msg_list => FND_API.G_FALSE,
689: p_validation_level => p_validation_level,
690: P_ITEM_OWNER_Rec => P_ITEM_OWNER_Rec,
691: P_ITEM_REC_In => p_item_rec_in,
692: x_return_status => x_return_status,

Line 697: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data);
695: END IF;
696:
697: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700:
701: /*******************************************************************/

Line 698: RAISE FND_API.G_EXC_ERROR;

694: x_msg_data => x_msg_data);
695: END IF;
696:
697: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700:
701: /*******************************************************************/
702: -- calling the Inventory update api

Line 770: OR (p_item_rec_in.COLLATERAL_FLAG <> FND_API.G_MISS_CHAR )

766: l_inv_item_rec_in.BACK_ORDERABLE_FLAG := p_item_rec_in.BACK_ORDERABLE_FLAG ;
767: /* Bug 2726989 Fix - by musman 26-dec-02*/
768: --l_inv_item_rec_in.COLLATERAL_FLAG := p_item_rec_in.COLLATERAL_FLAG;
769: IF (p_item_rec_in.COLLATERAL_FLAG IS NOT NULL)
770: OR (p_item_rec_in.COLLATERAL_FLAG <> FND_API.G_MISS_CHAR )
771: THEN
772: l_inv_item_rec_in.COLLATERAL_FLAG := p_item_rec_in.COLLATERAL_FLAG;
773: END IF;
774:

Line 838: IF l_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

834: , x_Error_tbl => l_Error_tbl /*x_Error_tbl*/
835: );
836:
837: x_item_return_status := l_item_return_status;
838: IF l_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
839: IF l_error_tbl.count >0 THEN
840: FOR l_cnt IN 1..l_error_tbl.count LOOP
841: x_error_tbl(l_cnt).transaction_id := l_error_tbl(l_cnt).transaction_id;
842: x_error_tbl(l_cnt).unique_id := l_error_tbl(l_cnt).unique_id;

Line 850: RAISE FND_API.G_EXC_ERROR;

846: x_error_tbl(l_cnt).column_name := l_error_tbl(l_cnt).column_name;
847: x_error_tbl(l_cnt).organization_id := l_error_tbl(l_cnt).organization_id;
848: END LOOP;
849: END IF;
850: RAISE FND_API.G_EXC_ERROR;
851: ELSE
852: p_item_rec_out.INVENTORY_ITEM_ID := l_inv_item_rec_out.INVENTORY_ITEM_ID ;
853: p_item_rec_out.ORGANIZATION_ID := l_inv_item_rec_out.ORGANIZATION_ID ;
854: p_item_rec_out.ITEM_NUMBER := l_inv_item_rec_out.ITEM_NUMBER ;

Line 929: IF FND_API.to_Boolean( p_commit )

925: -- End of API body.
926: --
927:
928: -- Standard check for p_commit
929: IF FND_API.to_Boolean( p_commit )
930: THEN
931: COMMIT WORK;
932: END IF;
933:

Line 944: WHEN FND_API.G_EXC_ERROR THEN

940: (p_count => x_msg_count,
941: p_data => x_msg_data
942: );
943: EXCEPTION
944: WHEN FND_API.G_EXC_ERROR THEN
945: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: -- Standard call to get message count and if count=1, get the message
948: FND_MSG_PUB.Count_And_Get (

Line 946: x_return_status := FND_API.G_RET_STS_ERROR;

942: );
943: EXCEPTION
944: WHEN FND_API.G_EXC_ERROR THEN
945: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: -- Standard call to get message count and if count=1, get the message
948: FND_MSG_PUB.Count_And_Get (
949: p_encoded => FND_API.G_FALSE,
950: p_count => x_msg_count,

Line 949: p_encoded => FND_API.G_FALSE,

945: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: -- Standard call to get message count and if count=1, get the message
948: FND_MSG_PUB.Count_And_Get (
949: p_encoded => FND_API.G_FALSE,
950: p_count => x_msg_count,
951: p_data => x_msg_data
952: );
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

949: p_encoded => FND_API.G_FALSE,
950: p_count => x_msg_count,
951: p_data => x_msg_data
952: );
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: -- Standard call to get message count and if count=1, get the message
957: FND_MSG_PUB.Count_And_Get (

Line 955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

951: p_data => x_msg_data
952: );
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: -- Standard call to get message count and if count=1, get the message
957: FND_MSG_PUB.Count_And_Get (
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,

Line 958: p_encoded => FND_API.G_FALSE,

954: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: -- Standard call to get message count and if count=1, get the message
957: FND_MSG_PUB.Count_And_Get (
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data
961: );
962: WHEN OTHERS THEN

Line 964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

960: p_data => x_msg_data
961: );
962: WHEN OTHERS THEN
963: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
966: THEN
967: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
968: END IF;

Line 971: p_encoded => FND_API.G_FALSE,

967: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
968: END IF;
969: -- Standard call to get message count and if count=1, get the message
970: FND_MSG_PUB.Count_And_Get (
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_msg_count,
973: p_data => x_msg_data
974: );
975: End Update_item_owner;

Line 980: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

976:
977:
978: PROCEDURE Delete_item_owner(
979: P_Api_Version_Number IN NUMBER,
980: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
981: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
982: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
983: X_Return_Status OUT NOCOPY VARCHAR2,
984: X_Msg_Count OUT NOCOPY NUMBER,

Line 981: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

977:
978: PROCEDURE Delete_item_owner(
979: P_Api_Version_Number IN NUMBER,
980: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
981: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
982: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
983: X_Return_Status OUT NOCOPY VARCHAR2,
984: X_Msg_Count OUT NOCOPY NUMBER,
985: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 982: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

978: PROCEDURE Delete_item_owner(
979: P_Api_Version_Number IN NUMBER,
980: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
981: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
982: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
983: X_Return_Status OUT NOCOPY VARCHAR2,
984: X_Msg_Count OUT NOCOPY NUMBER,
985: X_Msg_Data OUT NOCOPY VARCHAR2,
986: P_ITEM_OWNER_ID IN NUMBER,

Line 1000: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

996: -- Standard Start of API savepoint
997: SAVEPOINT DELETE_ITEM_OWNER_PVT;
998:
999: -- Standard call to check for call compatibility.
1000: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1001: p_api_version_number,
1002: l_api_name,
1003: G_PKG_NAME)
1004: THEN

Line 1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1001: p_api_version_number,
1002: l_api_name,
1003: G_PKG_NAME)
1004: THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007:
1008: -- Initialize message list if p_init_msg_list is set to TRUE.
1009: IF FND_API.to_Boolean( p_init_msg_list )

Line 1009: IF FND_API.to_Boolean( p_init_msg_list )

1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007:
1008: -- Initialize message list if p_init_msg_list is set to TRUE.
1009: IF FND_API.to_Boolean( p_init_msg_list )
1010: THEN
1011: FND_MSG_PUB.initialize;
1012: END IF;
1013:

Line 1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

1018: END IF;
1019:
1020:
1021: -- Initialize API return status to SUCCESS
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023:
1024: --
1025: -- Api body
1026: --

Line 1041: IF FND_API.to_Boolean( p_commit )

1037: -- End of API body
1038: --
1039:
1040: -- Standard check for p_commit
1041: IF FND_API.to_Boolean( p_commit )
1042: THEN
1043: COMMIT WORK;
1044: END IF;
1045:

Line 1059: WHEN FND_API.G_EXC_ERROR THEN

1055: (p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: ROLLBACK TO DELETE_ITEM_OWNER_PVT;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (

Line 1061: x_return_status := FND_API.G_RET_STS_ERROR;

1057: );
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: ROLLBACK TO DELETE_ITEM_OWNER_PVT;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,

Line 1064: p_encoded => FND_API.G_FALSE,

1060: ROLLBACK TO DELETE_ITEM_OWNER_PVT;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: ROLLBACK TO DELETE_ITEM_OWNER_PVT;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071: -- Standard call to get message count and if count=1, get the message
1072: FND_MSG_PUB.Count_And_Get (

Line 1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1066: p_data => x_msg_data
1067: );
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: ROLLBACK TO DELETE_ITEM_OWNER_PVT;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071: -- Standard call to get message count and if count=1, get the message
1072: FND_MSG_PUB.Count_And_Get (
1073: p_encoded => FND_API.G_FALSE,
1074: p_count => x_msg_count,

Line 1073: p_encoded => FND_API.G_FALSE,

1069: ROLLBACK TO DELETE_ITEM_OWNER_PVT;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071: -- Standard call to get message count and if count=1, get the message
1072: FND_MSG_PUB.Count_And_Get (
1073: p_encoded => FND_API.G_FALSE,
1074: p_count => x_msg_count,
1075: p_data => x_msg_data
1076: );
1077: WHEN OTHERS THEN

Line 1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1075: p_data => x_msg_data
1076: );
1077: WHEN OTHERS THEN
1078: ROLLBACK TO DELETE_ITEM_OWNER_PVT;
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1081: THEN
1082: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1083: END IF;

Line 1086: p_encoded => FND_API.G_FALSE,

1082: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1083: END IF;
1084: -- Standard call to get message count and if count=1, get the message
1085: FND_MSG_PUB.Count_And_Get (
1086: p_encoded => FND_API.G_FALSE,
1087: p_count => x_msg_count,
1088: p_data => x_msg_data
1089: );
1090: End Delete_item_owner;

Line 1121: RAISE FND_API.g_exc_error;

1117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1118: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1119: FND_MSG_PUB.add;
1120: END IF;
1121: RAISE FND_API.g_exc_error;
1122: END IF;
1123: CLOSE c_ITEM_OWNER;
1124:
1125: IF p_ITEM_OWNER_Rec.INVENTORY_ITEM_ID = FND_API.g_miss_num THEN

Line 1125: IF p_ITEM_OWNER_Rec.INVENTORY_ITEM_ID = FND_API.g_miss_num THEN

1121: RAISE FND_API.g_exc_error;
1122: END IF;
1123: CLOSE c_ITEM_OWNER;
1124:
1125: IF p_ITEM_OWNER_Rec.INVENTORY_ITEM_ID = FND_API.g_miss_num THEN
1126: x_complete_rec.INVENTORY_ITEM_ID := l_ITEM_OWNER_Rec_Type.INVENTORY_ITEM_ID;
1127: END IF;
1128:
1129: IF p_ITEM_OWNER_Rec.ORGANIZATION_ID = FND_API.g_miss_num THEN

Line 1129: IF p_ITEM_OWNER_Rec.ORGANIZATION_ID = FND_API.g_miss_num THEN

1125: IF p_ITEM_OWNER_Rec.INVENTORY_ITEM_ID = FND_API.g_miss_num THEN
1126: x_complete_rec.INVENTORY_ITEM_ID := l_ITEM_OWNER_Rec_Type.INVENTORY_ITEM_ID;
1127: END IF;
1128:
1129: IF p_ITEM_OWNER_Rec.ORGANIZATION_ID = FND_API.g_miss_num THEN
1130: x_complete_rec.ORGANIZATION_ID := l_ITEM_OWNER_Rec_Type.ORGANIZATION_ID;
1131: END IF;
1132:
1133: IF p_ITEM_OWNER_Rec.ITEM_NUMBER = FND_API.g_miss_num THEN

Line 1133: IF p_ITEM_OWNER_Rec.ITEM_NUMBER = FND_API.g_miss_num THEN

1129: IF p_ITEM_OWNER_Rec.ORGANIZATION_ID = FND_API.g_miss_num THEN
1130: x_complete_rec.ORGANIZATION_ID := l_ITEM_OWNER_Rec_Type.ORGANIZATION_ID;
1131: END IF;
1132:
1133: IF p_ITEM_OWNER_Rec.ITEM_NUMBER = FND_API.g_miss_num THEN
1134: x_complete_rec.ITEM_NUMBER := l_ITEM_OWNER_Rec_Type.ITEM_NUMBER;
1135: END IF;
1136:
1137: IF p_ITEM_OWNER_Rec.OWNER_ID = FND_API.g_miss_num THEN

Line 1137: IF p_ITEM_OWNER_Rec.OWNER_ID = FND_API.g_miss_num THEN

1133: IF p_ITEM_OWNER_Rec.ITEM_NUMBER = FND_API.g_miss_num THEN
1134: x_complete_rec.ITEM_NUMBER := l_ITEM_OWNER_Rec_Type.ITEM_NUMBER;
1135: END IF;
1136:
1137: IF p_ITEM_OWNER_Rec.OWNER_ID = FND_API.g_miss_num THEN
1138: x_complete_rec.OWNER_ID := l_ITEM_OWNER_Rec_Type.OWNER_ID;
1139: END IF;
1140:
1141: IF p_ITEM_OWNER_Rec.STATUS_CODE = FND_API.g_miss_char THEN

Line 1141: IF p_ITEM_OWNER_Rec.STATUS_CODE = FND_API.g_miss_char THEN

1137: IF p_ITEM_OWNER_Rec.OWNER_ID = FND_API.g_miss_num THEN
1138: x_complete_rec.OWNER_ID := l_ITEM_OWNER_Rec_Type.OWNER_ID;
1139: END IF;
1140:
1141: IF p_ITEM_OWNER_Rec.STATUS_CODE = FND_API.g_miss_char THEN
1142: x_complete_rec.STATUS_CODE := l_ITEM_OWNER_Rec_Type.STATUS_CODE;
1143: END IF;
1144:
1145: IF p_ITEM_OWNER_Rec.EFFECTIVE_DATE = FND_API.g_miss_date THEN

Line 1145: IF p_ITEM_OWNER_Rec.EFFECTIVE_DATE = FND_API.g_miss_date THEN

1141: IF p_ITEM_OWNER_Rec.STATUS_CODE = FND_API.g_miss_char THEN
1142: x_complete_rec.STATUS_CODE := l_ITEM_OWNER_Rec_Type.STATUS_CODE;
1143: END IF;
1144:
1145: IF p_ITEM_OWNER_Rec.EFFECTIVE_DATE = FND_API.g_miss_date THEN
1146: x_complete_rec.EFFECTIVE_DATE := l_ITEM_OWNER_Rec_Type.EFFECTIVE_DATE;
1147: END IF;
1148:
1149:

Line 1154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1150: END Complete_ITEM_OWNER_Rec;
1151:
1152: PROCEDURE Validate_item_owner(
1153: P_Api_Version_Number IN NUMBER,
1154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1155: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1156: P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type,
1157: P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC,
1158: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1155: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1151:
1152: PROCEDURE Validate_item_owner(
1153: P_Api_Version_Number IN NUMBER,
1154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1155: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1156: P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type,
1157: P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC,
1158: X_Return_Status OUT NOCOPY VARCHAR2,
1159: X_Msg_Count OUT NOCOPY NUMBER,

Line 1173: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1169: -- Standard Start of API savepoint
1170: SAVEPOINT VALIDATE_ITEM_OWNER_;
1171:
1172: -- Standard call to check for call compatibility.
1173: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1174: p_api_version_number,
1175: l_api_name,
1176: G_PKG_NAME)
1177: THEN

Line 1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1174: p_api_version_number,
1175: l_api_name,
1176: G_PKG_NAME)
1177: THEN
1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180:
1181: -- Initialize message list if p_init_msg_list is set to TRUE.
1182: IF FND_API.to_Boolean( p_init_msg_list )

Line 1182: IF FND_API.to_Boolean( p_init_msg_list )

1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180:
1181: -- Initialize message list if p_init_msg_list is set to TRUE.
1182: IF FND_API.to_Boolean( p_init_msg_list )
1183: THEN
1184: FND_MSG_PUB.initialize;
1185: END IF;
1186:

Line 1195: x_return_status := FND_API.G_RET_STS_SUCCESS;

1191: END IF;
1192:
1193:
1194: -- Initialize API return status to SUCCESS
1195: x_return_status := FND_API.G_RET_STS_SUCCESS;
1196:
1197: -- check 1 : both inv item flag and service item cannot be Y
1198: IF (( P_ITEM_REC_In.INVENTORY_ITEM_FLAG = 'Y')
1199: AND ( P_ITEM_REC_In.SERVICE_ITEM_FLAG = 'Y'))

Line 1206: RAISE FND_API.G_EXC_ERROR;

1202: THEN
1203: FND_MESSAGE.Set_Name('AMS', 'AMS_INV_SRV_ITM_FLG_ERR');
1204: FND_MSG_PUB.Add;
1205: END IF;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208:
1209: -- check 2 : both service item flag and service able product flag cannot be Y
1210: IF (( P_ITEM_REC_In.SERVICEABLE_PRODUCT_FLAG = 'Y')

Line 1218: raise FND_API.G_EXC_ERROR;

1214: THEN
1215: FND_MESSAGE.Set_Name('AMS', 'AMS_SRPRD_SRV_ITM_FLG_ERR');
1216: FND_MSG_PUB.Add;
1217: END IF;
1218: raise FND_API.G_EXC_ERROR;
1219: END IF;
1220:
1221: /* -- if the contract Item type code is Warranty, inv api automatically updates
1222: -- vendor_warrantty_flag,service_item_flag to 'Y'

Line 1232: raise FND_API.G_EXC_ERROR;

1228: THEN
1229: FND_MESSAGE.Set_Name('AMS', 'AMS_WARRANTY_SRV_ERR');
1230: FND_MSG_PUB.Add;
1231: END IF;
1232: raise FND_API.G_EXC_ERROR;
1233: END IF;
1234: */
1235: --- if warranty is Y, there has to be a value for Duration Period
1236: /**

Line 1245: raise FND_API.G_EXC_ERROR;

1241: THEN
1242: FND_MESSAGE.Set_Name('AMS', 'AMS_WARRANTY_SRVDUR_PER_ERR');
1243: FND_MSG_PUB.Add;
1244: END IF;
1245: raise FND_API.G_EXC_ERROR;
1246: END IF;
1247: **/
1248: /*-- by musman dec-30-2002
1249: -- because even the service items with vendor_warranty_flag (Contract itemType pf warranty)

Line 1260: raise FND_API.G_EXC_ERROR;

1256: THEN
1257: FND_MESSAGE.Set_Name('AMS', 'AMS_INV_BOM_FLG_ERR');
1258: FND_MSG_PUB.Add;
1259: END IF;
1260: raise FND_API.G_EXC_ERROR;
1261: END IF;
1262: */
1263: -- if service flag is N , and NO VALUES IN COVERage or DURATION
1264: /**

Line 1273: raise FND_API.G_EXC_ERROR;

1269: THEN
1270: FND_MESSAGE.Set_Name('AMS', 'AMS_WARRN_SRV_COMB_ERR');
1271: FND_MSG_PUB.Add;
1272: END IF;
1273: raise FND_API.G_EXC_ERROR;
1274: END IF;
1275: ***/
1276:
1277: -- if Bom Item Type is Model or option class, either "Assemble to order" or "pick components" has to be yes.

Line 1288: raise FND_API.G_EXC_ERROR;

1284: THEN
1285: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_BOM_ERROR');
1286: FND_MSG_PUB.Add;
1287: END IF;
1288: raise FND_API.G_EXC_ERROR;
1289: END IF;
1290:
1291: -- if SUBSCRIPTION_DEPEND_FLAG is "Y" then the contract item_type code has to be subscription
1292:

Line 1301: raise FND_API.G_EXC_ERROR;

1297: THEN
1298: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_SUBSCRIP_ERROR');
1299: FND_MSG_PUB.Add;
1300: END IF;
1301: raise FND_API.G_EXC_ERROR;
1302: END IF;
1303:
1304: /*
1305: -- if contract item type code is subscription ,service _item_flag has to 'Y'

Line 1314: raise FND_API.G_EXC_ERROR;

1310: THEN
1311: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_CONTRACT_ERROR');
1312: FND_MSG_PUB.Add;
1313: END IF;
1314: raise FND_API.G_EXC_ERROR;
1315: END IF;
1316: */
1317:
1318: -- Standard call to get message count and if count is 1, get message info.

Line 1324: WHEN FND_API.G_EXC_ERROR THEN

1320: (p_count => x_msg_count,
1321: p_data => x_msg_data
1322: );
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327: -- Standard call to get message count and if count=1, get the message
1328: FND_MSG_PUB.Count_And_Get (

Line 1326: x_return_status := FND_API.G_RET_STS_ERROR;

1322: );
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327: -- Standard call to get message count and if count=1, get the message
1328: FND_MSG_PUB.Count_And_Get (
1329: p_encoded => FND_API.G_FALSE,
1330: p_count => x_msg_count,

Line 1329: p_encoded => FND_API.G_FALSE,

1325: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327: -- Standard call to get message count and if count=1, get the message
1328: FND_MSG_PUB.Count_And_Get (
1329: p_encoded => FND_API.G_FALSE,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );
1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1329: p_encoded => FND_API.G_FALSE,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );
1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1334: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: -- Standard call to get message count and if count=1, get the message
1337: FND_MSG_PUB.Count_And_Get (

Line 1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1331: p_data => x_msg_data
1332: );
1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1334: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: -- Standard call to get message count and if count=1, get the message
1337: FND_MSG_PUB.Count_And_Get (
1338: p_encoded => FND_API.G_FALSE,
1339: p_count => x_msg_count,

Line 1338: p_encoded => FND_API.G_FALSE,

1334: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: -- Standard call to get message count and if count=1, get the message
1337: FND_MSG_PUB.Count_And_Get (
1338: p_encoded => FND_API.G_FALSE,
1339: p_count => x_msg_count,
1340: p_data => x_msg_data
1341: );
1342: WHEN OTHERS THEN

Line 1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1340: p_data => x_msg_data
1341: );
1342: WHEN OTHERS THEN
1343: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1346: THEN
1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1348: END IF;

Line 1351: p_encoded => FND_API.G_FALSE,

1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1348: END IF;
1349: -- Standard call to get message count and if count=1, get the message
1350: FND_MSG_PUB.Count_And_Get (
1351: p_encoded => FND_API.G_FALSE,
1352: p_count => x_msg_count,
1353: p_data => x_msg_data
1354: );
1355: End Validate_item_owner;

Line 1466: x_return_status := FND_API.G_RET_STS_SUCCESS;

1462:
1463: BEGIN
1464:
1465: -- Initialize API return status to SUCCESS
1466: x_return_status := FND_API.G_RET_STS_SUCCESS;
1467:
1468: --bug 3544835 fix start
1469:
1470: OPEN get_duration_period;

Line 1764: x_return_status := FND_API.G_RET_STS_SUCCESS;

1760:
1761: BEGIN
1762:
1763: -- Initialize API return status to SUCCESS
1764: x_return_status := FND_API.G_RET_STS_SUCCESS;
1765:
1766: IF (AMS_DEBUG_HIGH_ON) THEN
1767:
1768:

Line 1774: IF (( p_item_rec_in.inventory_item_flag <> FND_API.G_MISS_CHAR

1770: AMS_UTILITY_PVT.debug_message('IN the add_default_attributes');
1771:
1772: END IF;
1773:
1774: IF (( p_item_rec_in.inventory_item_flag <> FND_API.G_MISS_CHAR
1775: AND p_item_rec_in.inventory_item_flag IS NOT NULL
1776: AND p_item_rec_in.inventory_item_flag = 'Y')
1777: OR ( p_item_rec_in.service_item_flag <> FND_API.G_MISS_CHAR
1778: AND p_item_rec_in.service_item_flag IS NOT NULL

Line 1777: OR ( p_item_rec_in.service_item_flag <> FND_API.G_MISS_CHAR

1773:
1774: IF (( p_item_rec_in.inventory_item_flag <> FND_API.G_MISS_CHAR
1775: AND p_item_rec_in.inventory_item_flag IS NOT NULL
1776: AND p_item_rec_in.inventory_item_flag = 'Y')
1777: OR ( p_item_rec_in.service_item_flag <> FND_API.G_MISS_CHAR
1778: AND p_item_rec_in.service_item_flag IS NOT NULL
1779: AND p_item_rec_in.service_item_flag = 'N'))
1780: THEN
1781: l_flag := 'P';

Line 1782: ELSIF ((p_item_rec_in.service_item_flag <> FND_API.G_MISS_CHAR

1778: AND p_item_rec_in.service_item_flag IS NOT NULL
1779: AND p_item_rec_in.service_item_flag = 'N'))
1780: THEN
1781: l_flag := 'P';
1782: ELSIF ((p_item_rec_in.service_item_flag <> FND_API.G_MISS_CHAR
1783: AND p_item_rec_in.service_item_flag IS NOT NULL
1784: AND p_item_rec_in.service_item_flag = 'Y')
1785: OR ( p_item_rec_in.inventory_item_flag <> FND_API.G_MISS_CHAR
1786: AND p_item_rec_in.inventory_item_flag IS NOT NULL

Line 1785: OR ( p_item_rec_in.inventory_item_flag <> FND_API.G_MISS_CHAR

1781: l_flag := 'P';
1782: ELSIF ((p_item_rec_in.service_item_flag <> FND_API.G_MISS_CHAR
1783: AND p_item_rec_in.service_item_flag IS NOT NULL
1784: AND p_item_rec_in.service_item_flag = 'Y')
1785: OR ( p_item_rec_in.inventory_item_flag <> FND_API.G_MISS_CHAR
1786: AND p_item_rec_in.inventory_item_flag IS NOT NULL
1787: AND p_item_rec_in.inventory_item_flag = 'N'))
1788: THEN
1789: l_flag := 'S';

Line 1828: AND p_item_rec_in.costing_enabled_flag <> FND_API.G_MISS_CHAR )

1824:
1825: BEGIN
1826:
1827: IF (p_item_rec_in.costing_enabled_flag IS NOT NULL
1828: AND p_item_rec_in.costing_enabled_flag <> FND_API.G_MISS_CHAR )
1829: THEN
1830: l_inv_item_rec_in.costing_enabled_flag := p_item_rec_in.costing_enabled_flag;
1831: END IF;
1832:

Line 1834: AND p_item_rec_in.collateral_flag <> FND_API.G_MISS_CHAR )

1830: l_inv_item_rec_in.costing_enabled_flag := p_item_rec_in.costing_enabled_flag;
1831: END IF;
1832:
1833: IF (p_item_rec_in.collateral_flag IS NOT NULL
1834: AND p_item_rec_in.collateral_flag <> FND_API.G_MISS_CHAR )
1835: THEN
1836: l_inv_item_rec_in.collateral_flag := p_item_rec_in.collateral_flag ;
1837: END IF;
1838:

Line 1840: AND p_item_rec_in.customer_order_flag <> FND_API.G_MISS_CHAR )

1836: l_inv_item_rec_in.collateral_flag := p_item_rec_in.collateral_flag ;
1837: END IF;
1838:
1839: IF (p_item_rec_in.customer_order_flag IS NOT NULL
1840: AND p_item_rec_in.customer_order_flag <> FND_API.G_MISS_CHAR )
1841: THEN
1842: l_inv_item_rec_in.customer_order_flag := p_item_rec_in.customer_order_flag ;
1843: END IF;
1844:

Line 1846: AND p_item_rec_in.customer_order_enabled_flag <> FND_API.G_MISS_CHAR )

1842: l_inv_item_rec_in.customer_order_flag := p_item_rec_in.customer_order_flag ;
1843: END IF;
1844:
1845: IF (p_item_rec_in.customer_order_enabled_flag IS NOT NULL
1846: AND p_item_rec_in.customer_order_enabled_flag <> FND_API.G_MISS_CHAR )
1847: THEN
1848: l_inv_item_rec_in.customer_order_enabled_flag := p_item_rec_in.customer_order_enabled_flag ;
1849: END IF;
1850:

Line 1852: AND p_item_rec_in.shippable_item_flag <> FND_API.G_MISS_CHAR )

1848: l_inv_item_rec_in.customer_order_enabled_flag := p_item_rec_in.customer_order_enabled_flag ;
1849: END IF;
1850:
1851: IF (p_item_rec_in.shippable_item_flag IS NOT NULL
1852: AND p_item_rec_in.shippable_item_flag <> FND_API.G_MISS_CHAR )
1853: THEN
1854: l_inv_item_rec_in.shippable_item_flag := p_item_rec_in.shippable_item_flag ;
1855: END IF;
1856:

Line 1858: AND p_item_rec_in.event_flag <> FND_API.G_MISS_CHAR )

1854: l_inv_item_rec_in.shippable_item_flag := p_item_rec_in.shippable_item_flag ;
1855: END IF;
1856:
1857: IF (p_item_rec_in.event_flag IS NOT NULL
1858: AND p_item_rec_in.event_flag <> FND_API.G_MISS_CHAR )
1859: THEN
1860: l_inv_item_rec_in.event_flag := p_item_rec_in.event_flag ;
1861: END IF;
1862:

Line 1864: AND p_item_rec_in.inventory_item_status_code <> FND_API.G_MISS_CHAR )

1860: l_inv_item_rec_in.event_flag := p_item_rec_in.event_flag ;
1861: END IF;
1862:
1863: IF (p_item_rec_in.inventory_item_status_code IS NOT NULL
1864: AND p_item_rec_in.inventory_item_status_code <> FND_API.G_MISS_CHAR )
1865: THEN
1866: l_inv_item_rec_in.inventory_item_status_code := p_item_rec_in.inventory_item_status_code;
1867: END IF;
1868:

Line 1870: AND p_item_rec_in.stock_enabled_flag <> FND_API.G_MISS_CHAR )

1866: l_inv_item_rec_in.inventory_item_status_code := p_item_rec_in.inventory_item_status_code;
1867: END IF;
1868:
1869: IF (p_item_rec_in.stock_enabled_flag IS NOT NULL
1870: AND p_item_rec_in.stock_enabled_flag <> FND_API.G_MISS_CHAR )
1871: THEN
1872: l_inv_item_rec_in.stock_enabled_flag := p_item_rec_in.stock_enabled_flag ;
1873: END IF;
1874:

Line 1876: AND p_item_rec_in.mtl_transactions_enabled_flag <> FND_API.G_MISS_CHAR )

1872: l_inv_item_rec_in.stock_enabled_flag := p_item_rec_in.stock_enabled_flag ;
1873: END IF;
1874:
1875: IF (p_item_rec_in.mtl_transactions_enabled_flag IS NOT NULL
1876: AND p_item_rec_in.mtl_transactions_enabled_flag <> FND_API.G_MISS_CHAR )
1877: THEN
1878: l_inv_item_rec_in.mtl_transactions_enabled_flag := p_item_rec_in.mtl_transactions_enabled_flag ;
1879: END IF;
1880:

Line 1882: AND p_item_rec_in.bom_enabled_flag <> FND_API.G_MISS_CHAR )

1878: l_inv_item_rec_in.mtl_transactions_enabled_flag := p_item_rec_in.mtl_transactions_enabled_flag ;
1879: END IF;
1880:
1881: IF (p_item_rec_in.bom_enabled_flag IS NOT NULL
1882: AND p_item_rec_in.bom_enabled_flag <> FND_API.G_MISS_CHAR )
1883: THEN
1884: l_inv_item_rec_in.bom_enabled_flag := p_item_rec_in.bom_enabled_flag ;
1885: END IF;
1886:

Line 1888: AND p_item_rec_in.bom_item_type <> FND_API.G_MISS_NUM)

1884: l_inv_item_rec_in.bom_enabled_flag := p_item_rec_in.bom_enabled_flag ;
1885: END IF;
1886:
1887: IF (p_item_rec_in.bom_item_type IS NOT NULL
1888: AND p_item_rec_in.bom_item_type <> FND_API.G_MISS_NUM)
1889: THEN
1890: l_inv_item_rec_in.bom_item_type := p_item_rec_in.bom_item_type ;
1891: END IF;
1892:

Line 1894: AND p_item_rec_in.electronic_flag <> FND_API.G_MISS_CHAR )

1890: l_inv_item_rec_in.bom_item_type := p_item_rec_in.bom_item_type ;
1891: END IF;
1892:
1893: IF (p_item_rec_in.electronic_flag IS NOT NULL
1894: AND p_item_rec_in.electronic_flag <> FND_API.G_MISS_CHAR )
1895: THEN
1896: l_inv_item_rec_in.electronic_flag := p_item_rec_in.electronic_flag ;
1897: END IF;
1898:

Line 1900: AND p_item_rec_in.downloadable_flag <> FND_API.G_MISS_CHAR )

1896: l_inv_item_rec_in.electronic_flag := p_item_rec_in.electronic_flag ;
1897: END IF;
1898:
1899: IF (p_item_rec_in.downloadable_flag IS NOT NULL
1900: AND p_item_rec_in.downloadable_flag <> FND_API.G_MISS_CHAR )
1901: THEN
1902: l_inv_item_rec_in.downloadable_flag := p_item_rec_in.downloadable_flag ;
1903: END IF;
1904:

Line 1906: AND p_item_rec_in.internal_order_flag <> FND_API.G_MISS_CHAR )

1902: l_inv_item_rec_in.downloadable_flag := p_item_rec_in.downloadable_flag ;
1903: END IF;
1904:
1905: IF (p_item_rec_in.internal_order_flag IS NOT NULL
1906: AND p_item_rec_in.internal_order_flag <> FND_API.G_MISS_CHAR )
1907: THEN
1908: l_inv_item_rec_in.internal_order_flag := p_item_rec_in.internal_order_flag ;
1909: END IF;
1910:

Line 1912: AND p_item_rec_in.internal_order_enabled_flag <> FND_API.G_MISS_CHAR )

1908: l_inv_item_rec_in.internal_order_flag := p_item_rec_in.internal_order_flag ;
1909: END IF;
1910:
1911: IF (p_item_rec_in.internal_order_enabled_flag IS NOT NULL
1912: AND p_item_rec_in.internal_order_enabled_flag <> FND_API.G_MISS_CHAR )
1913: THEN
1914: l_inv_item_rec_in.internal_order_enabled_flag := p_item_rec_in.internal_order_enabled_flag ;
1915: END IF;
1916:

Line 1918: AND p_item_rec_in.returnable_flag <> FND_API.G_MISS_CHAR )

1914: l_inv_item_rec_in.internal_order_enabled_flag := p_item_rec_in.internal_order_enabled_flag ;
1915: END IF;
1916:
1917: IF (p_item_rec_in.returnable_flag IS NOT NULL
1918: AND p_item_rec_in.returnable_flag <> FND_API.G_MISS_CHAR )
1919: THEN
1920: l_inv_item_rec_in.returnable_flag := p_item_rec_in.returnable_flag ;
1921: END IF;
1922: /*

Line 1924: AND p_item_rec_in.service_item_flag <> FND_API.G_MISS_CHAR )

1920: l_inv_item_rec_in.returnable_flag := p_item_rec_in.returnable_flag ;
1921: END IF;
1922: /*
1923: IF (p_item_rec_in.service_item_flag IS NOT NULL
1924: AND p_item_rec_in.service_item_flag <> FND_API.G_MISS_CHAR )
1925: THEN
1926: l_inv_item_rec_in.service_item_flag := p_item_rec_in.service_item_flag ;
1927: END IF;
1928: */

Line 1931: AND p_item_rec_in.serviceable_product_flag <> FND_API.G_MISS_CHAR )

1927: END IF;
1928: */
1929:
1930: IF (p_item_rec_in.serviceable_product_flag IS NOT NULL
1931: AND p_item_rec_in.serviceable_product_flag <> FND_API.G_MISS_CHAR )
1932: THEN
1933: l_inv_item_rec_in.serviceable_product_flag := p_item_rec_in.serviceable_product_flag ;
1934: END IF;
1935:

Line 1937: AND p_item_rec_in.defect_tracking_on_flag <> FND_API.G_MISS_CHAR )

1933: l_inv_item_rec_in.serviceable_product_flag := p_item_rec_in.serviceable_product_flag ;
1934: END IF;
1935:
1936: IF (p_item_rec_in.defect_tracking_on_flag IS NOT NULL
1937: AND p_item_rec_in.defect_tracking_on_flag <> FND_API.G_MISS_CHAR )
1938: THEN
1939: l_inv_item_rec_in.defect_tracking_on_flag := p_item_rec_in.defect_tracking_on_flag ;
1940: END IF;
1941:

Line 1943: AND p_item_rec_in.orderable_on_web_flag <> FND_API.G_MISS_CHAR )

1939: l_inv_item_rec_in.defect_tracking_on_flag := p_item_rec_in.defect_tracking_on_flag ;
1940: END IF;
1941:
1942: IF (p_item_rec_in.orderable_on_web_flag IS NOT NULL
1943: AND p_item_rec_in.orderable_on_web_flag <> FND_API.G_MISS_CHAR )
1944: THEN
1945: l_inv_item_rec_in.orderable_on_web_flag := p_item_rec_in.orderable_on_web_flag ;
1946: END IF;
1947:

Line 1949: AND p_item_rec_in.back_orderable_flag <> FND_API.G_MISS_CHAR )

1945: l_inv_item_rec_in.orderable_on_web_flag := p_item_rec_in.orderable_on_web_flag ;
1946: END IF;
1947:
1948: IF (p_item_rec_in.back_orderable_flag IS NOT NULL
1949: AND p_item_rec_in.back_orderable_flag <> FND_API.G_MISS_CHAR )
1950: THEN
1951: l_inv_item_rec_in.back_orderable_flag := p_item_rec_in.back_orderable_flag ;
1952: END IF;
1953:

Line 1955: AND p_item_rec_in.comms_nl_trackable_flag <> FND_API.G_MISS_CHAR )

1951: l_inv_item_rec_in.back_orderable_flag := p_item_rec_in.back_orderable_flag ;
1952: END IF;
1953:
1954: IF (p_item_rec_in.comms_nl_trackable_flag IS NOT NULL
1955: AND p_item_rec_in.comms_nl_trackable_flag <> FND_API.G_MISS_CHAR )
1956: THEN
1957: l_inv_item_rec_in.comms_nl_trackable_flag := p_item_rec_in.comms_nl_trackable_flag ;
1958: END IF;
1959:

Line 1961: AND p_item_rec_in.contract_item_type_code <> FND_API.G_MISS_CHAR )

1957: l_inv_item_rec_in.comms_nl_trackable_flag := p_item_rec_in.comms_nl_trackable_flag ;
1958: END IF;
1959:
1960: IF (p_item_rec_in.contract_item_type_code IS NOT NULL
1961: AND p_item_rec_in.contract_item_type_code <> FND_API.G_MISS_CHAR )
1962: THEN
1963: l_inv_item_rec_in.contract_item_type_code := p_item_rec_in.contract_item_type_code ;
1964: END IF;
1965:

Line 1968: AND p_item_rec_in.web_status <> FND_API.G_MISS_CHAR )

1964: END IF;
1965:
1966:
1967: IF (p_item_rec_in.web_status IS NOT NULL
1968: AND p_item_rec_in.web_status <> FND_API.G_MISS_CHAR )
1969: THEN
1970: l_inv_item_rec_in.web_status := p_item_rec_in.web_status ;
1971: END IF;
1972:

Line 1974: AND p_item_rec_in.indivisible_flag <> FND_API.G_MISS_CHAR )

1970: l_inv_item_rec_in.web_status := p_item_rec_in.web_status ;
1971: END IF;
1972:
1973: IF (p_item_rec_in.indivisible_flag IS NOT NULL
1974: AND p_item_rec_in.indivisible_flag <> FND_API.G_MISS_CHAR )
1975: THEN
1976: l_inv_item_rec_in.indivisible_flag := p_item_rec_in.indivisible_flag ;
1977: END IF;
1978:

Line 1980: AND p_item_rec_in.revision_qty_control_code <> FND_API.G_MISS_NUM )

1976: l_inv_item_rec_in.indivisible_flag := p_item_rec_in.indivisible_flag ;
1977: END IF;
1978:
1979: IF (p_item_rec_in.revision_qty_control_code IS NOT NULL
1980: AND p_item_rec_in.revision_qty_control_code <> FND_API.G_MISS_NUM )
1981: THEN
1982: l_inv_item_rec_in.revision_qty_control_code := p_item_rec_in.revision_qty_control_code ;
1983: END IF;
1984:

Line 1986: AND p_item_rec_in.so_transactions_flag <> FND_API.G_MISS_CHAR )

1982: l_inv_item_rec_in.revision_qty_control_code := p_item_rec_in.revision_qty_control_code ;
1983: END IF;
1984:
1985: IF (p_item_rec_in.so_transactions_flag IS NOT NULL
1986: AND p_item_rec_in.so_transactions_flag <> FND_API.G_MISS_CHAR )
1987: THEN
1988: l_inv_item_rec_in.so_transactions_flag := p_item_rec_in.so_transactions_flag ;
1989: END IF;
1990: