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_REL_ITEM_PVT dependencies on FND_MSG_PUB

Line 18: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

14: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvritb.pls';
15:
16:
17:
18: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21:
22: PROCEDURE Complete_REL_ITEM_Rec (

Line 19: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

15:
16:
17:
18: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21:
22: PROCEDURE Complete_REL_ITEM_Rec (
23: P_REL_ITEM_Rec IN REL_ITEM_Rec_Type,

Line 20: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

16:
17:
18: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21:
22: PROCEDURE Complete_REL_ITEM_Rec (
23: P_REL_ITEM_Rec IN REL_ITEM_Rec_Type,
24: x_complete_rec OUT NOCOPY REL_ITEM_Rec_Type

Line 97: FND_MSG_PUB.initialize;

93:
94: -- Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.to_Boolean( p_init_msg_list )
96: THEN
97: FND_MSG_PUB.initialize;
98: END IF;
99:
100: -- Debug Message
101: IF (AMS_DEBUG_HIGH_ON) THEN

Line 115: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

111: -- Validate Environment
112: -- ******************************************************************
113: IF FND_GLOBAL.User_Id IS NULL
114: THEN
115: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
116: THEN
117: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
118: FND_MSG_PUB.ADD;
119: END IF;

Line 118: FND_MSG_PUB.ADD;

114: THEN
115: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
116: THEN
117: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
118: FND_MSG_PUB.ADD;
119: END IF;
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:

Line 132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

128: OPEN Check_item;
129: FETCH Check_item INTO Check_item_row;
130:
131: if (Check_item%FOUND) then
132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
133: THEN
134: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_DUP_REL');
135: FND_MSG_PUB.ADD;
136: END IF;

Line 135: FND_MSG_PUB.ADD;

131: if (Check_item%FOUND) then
132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
133: THEN
134: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_DUP_REL');
135: FND_MSG_PUB.ADD;
136: END IF;
137: CLOSE Check_item;
138: RAISE FND_API.G_EXC_ERROR ;
139: end if;

Line 179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

175: -- Item Cannot be realted to it self.
176: -- ******************************************************************
177: IF (p_REL_ITEM_rec.INVENTORY_ITEM_ID = p_REL_ITEM_rec.RELATED_ITEM_ID)
178: THEN
179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
180: THEN
181: FND_MESSAGE.Set_Name('AMS', 'AMS_INVALID_ITM_REL');
182: FND_MSG_PUB.ADD;
183: END IF;

Line 182: FND_MSG_PUB.ADD;

178: THEN
179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
180: THEN
181: FND_MESSAGE.Set_Name('AMS', 'AMS_INVALID_ITM_REL');
182: FND_MSG_PUB.ADD;
183: END IF;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:

Line 260: FND_MSG_PUB.Count_And_Get

256: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
257: END IF;
258:
259: -- Standard call to get message count and if count is 1, get message info.
260: FND_MSG_PUB.Count_And_Get
261: (p_count => x_msg_count,
262: p_data => x_msg_data
263: );
264: EXCEPTION

Line 269: FND_MSG_PUB.Count_And_Get (

265: WHEN FND_API.G_EXC_ERROR THEN
266: ROLLBACK TO CREATE_REL_ITEM_PVT;
267: x_return_status := FND_API.G_RET_STS_ERROR;
268: -- Standard call to get message count and if count=1, get the message
269: FND_MSG_PUB.Count_And_Get (
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
272: p_data => x_msg_data
273: );

Line 278: FND_MSG_PUB.Count_And_Get (

274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: ROLLBACK TO CREATE_REL_ITEM_PVT;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: -- Standard call to get message count and if count=1, get the message
278: FND_MSG_PUB.Count_And_Get (
279: p_encoded => FND_API.G_FALSE,
280: p_count => x_msg_count,
281: p_data => x_msg_data
282: );

Line 286: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

282: );
283: WHEN OTHERS THEN
284: ROLLBACK TO CREATE_REL_ITEM_PVT;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
287: THEN
288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
289: END IF;
290: -- Standard call to get message count and if count=1, get the message

Line 288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

284: ROLLBACK TO CREATE_REL_ITEM_PVT;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
287: THEN
288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
289: END IF;
290: -- Standard call to get message count and if count=1, get the message
291: FND_MSG_PUB.Count_And_Get (
292: p_encoded => FND_API.G_FALSE,

Line 291: FND_MSG_PUB.Count_And_Get (

287: THEN
288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
289: END IF;
290: -- Standard call to get message count and if count=1, get the message
291: FND_MSG_PUB.Count_And_Get (
292: p_encoded => FND_API.G_FALSE,
293: p_count => x_msg_count,
294: p_data => x_msg_data
295: );

Line 362: FND_MSG_PUB.initialize;

358:
359: -- Initialize message list if p_init_msg_list is set to TRUE.
360: IF FND_API.to_Boolean( p_init_msg_list )
361: THEN
362: FND_MSG_PUB.initialize;
363: END IF;
364:
365: -- Debug Message
366: IF (AMS_DEBUG_HIGH_ON) THEN

Line 402: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

398: l_ref_REL_ITEM_rec.PROGRAM_ID,
399: l_ref_REL_ITEM_rec.PROGRAM_UPDATE_DATE;
400:
401: If ( C_Get_rel_item%NOTFOUND) Then
402: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
403: THEN
404: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
405: FND_MESSAGE.Set_Token ('INFO', 'rel_item', FALSE);
406: FND_MSG_PUB.Add;

Line 406: FND_MSG_PUB.Add;

402: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
403: THEN
404: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
405: FND_MESSAGE.Set_Token ('INFO', 'rel_item', FALSE);
406: FND_MSG_PUB.Add;
407: END IF;
408: raise FND_API.G_EXC_ERROR;
409: END IF;
410: -- Debug Message

Line 477: FND_MSG_PUB.Count_And_Get

473: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
474: END IF;
475:
476: -- Standard call to get message count and if count is 1, get message info.
477: FND_MSG_PUB.Count_And_Get
478: (p_count => x_msg_count,
479: p_data => x_msg_data
480: );
481: EXCEPTION

Line 486: FND_MSG_PUB.Count_And_Get (

482: WHEN FND_API.G_EXC_ERROR THEN
483: ROLLBACK TO UPDATE_REL_ITEM_PVT;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data
490: );

Line 495: FND_MSG_PUB.Count_And_Get (

491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: ROLLBACK TO UPDATE_REL_ITEM_PVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: -- Standard call to get message count and if count=1, get the message
495: FND_MSG_PUB.Count_And_Get (
496: p_encoded => FND_API.G_FALSE,
497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );

Line 503: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

499: );
500: WHEN OTHERS THEN
501: ROLLBACK TO UPDATE_REL_ITEM_PVT;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
504: THEN
505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
506: END IF;
507: -- Standard call to get message count and if count=1, get the message

Line 505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

501: ROLLBACK TO UPDATE_REL_ITEM_PVT;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
504: THEN
505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
506: END IF;
507: -- Standard call to get message count and if count=1, get the message
508: FND_MSG_PUB.Count_And_Get (
509: p_encoded => FND_API.G_FALSE,

Line 508: FND_MSG_PUB.Count_And_Get (

504: THEN
505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
506: END IF;
507: -- Standard call to get message count and if count=1, get the message
508: FND_MSG_PUB.Count_And_Get (
509: p_encoded => FND_API.G_FALSE,
510: p_count => x_msg_count,
511: p_data => x_msg_data
512: );

Line 567: FND_MSG_PUB.initialize;

563:
564: -- Initialize message list if p_init_msg_list is set to TRUE.
565: IF FND_API.to_Boolean( p_init_msg_list )
566: THEN
567: FND_MSG_PUB.initialize;
568: END IF;
569:
570: -- Debug Message
571: IF (AMS_DEBUG_HIGH_ON) THEN

Line 677: FND_MSG_PUB.Count_And_Get

673: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
674: END IF;
675:
676: -- Standard call to get message count and if count is 1, get message info.
677: FND_MSG_PUB.Count_And_Get
678: (p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681: EXCEPTION

Line 686: FND_MSG_PUB.Count_And_Get (

682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO DELETE_REL_ITEM_PVT;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (
687: p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,
689: p_data => x_msg_data
690: );

Line 695: FND_MSG_PUB.Count_And_Get (

691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: ROLLBACK TO DELETE_REL_ITEM_PVT;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: -- Standard call to get message count and if count=1, get the message
695: FND_MSG_PUB.Count_And_Get (
696: p_encoded => FND_API.G_FALSE,
697: p_count => x_msg_count,
698: p_data => x_msg_data
699: );

Line 703: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

699: );
700: WHEN OTHERS THEN
701: ROLLBACK TO DELETE_REL_ITEM_PVT;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
707: -- Standard call to get message count and if count=1, get the message

Line 705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

701: ROLLBACK TO DELETE_REL_ITEM_PVT;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (
709: p_encoded => FND_API.G_FALSE,

Line 708: FND_MSG_PUB.Count_And_Get (

704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (
709: p_encoded => FND_API.G_FALSE,
710: p_count => x_msg_count,
711: p_data => x_msg_data
712: );

Line 756: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

752: OPEN c_rel_item_rec;
753: FETCH c_rel_item_rec INTO l_rel_item_rec;
754: IF c_rel_item_rec%NOTFOUND THEN
755: CLOSE c_rel_item_rec;
756: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
757: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
758: FND_MSG_PUB.add;
759: END IF;
760: RAISE FND_API.g_exc_error;

Line 758: FND_MSG_PUB.add;

754: IF c_rel_item_rec%NOTFOUND THEN
755: CLOSE c_rel_item_rec;
756: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
757: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
758: FND_MSG_PUB.add;
759: END IF;
760: RAISE FND_API.g_exc_error;
761: END IF;
762: CLOSE c_rel_item_rec;

Line 840: FND_MSG_PUB.initialize;

836:
837: -- Initialize message list if p_init_msg_list is set to TRUE.
838: IF FND_API.to_Boolean( p_init_msg_list )
839: THEN
840: FND_MSG_PUB.initialize;
841: END IF;
842: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
843: Check_REL_ITEM_Items(
844: p_REL_ITEM_rec => p_REL_ITEM_rec,

Line 891: FND_MSG_PUB.Count_And_Get

887: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
888: END IF;
889:
890: -- Standard call to get message count and if count is 1, get message info.
891: FND_MSG_PUB.Count_And_Get
892: (p_count => x_msg_count,
893: p_data => x_msg_data
894: );
895: EXCEPTION

Line 900: FND_MSG_PUB.Count_And_Get (

896: WHEN FND_API.G_EXC_ERROR THEN
897: ROLLBACK TO VALIDATE_REL_ITEM_;
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: -- Standard call to get message count and if count=1, get the message
900: FND_MSG_PUB.Count_And_Get (
901: p_encoded => FND_API.G_FALSE,
902: p_count => x_msg_count,
903: p_data => x_msg_data
904: );

Line 909: FND_MSG_PUB.Count_And_Get (

905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
906: ROLLBACK TO VALIDATE_REL_ITEM_;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: -- Standard call to get message count and if count=1, get the message
909: FND_MSG_PUB.Count_And_Get (
910: p_encoded => FND_API.G_FALSE,
911: p_count => x_msg_count,
912: p_data => x_msg_data
913: );

Line 917: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

913: );
914: WHEN OTHERS THEN
915: ROLLBACK TO VALIDATE_REL_ITEM_;
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
918: THEN
919: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
920: END IF;
921: -- Standard call to get message count and if count=1, get the message

Line 919: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

915: ROLLBACK TO VALIDATE_REL_ITEM_;
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
918: THEN
919: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
920: END IF;
921: -- Standard call to get message count and if count=1, get the message
922: FND_MSG_PUB.Count_And_Get (
923: p_encoded => FND_API.G_FALSE,

Line 922: FND_MSG_PUB.Count_And_Get (

918: THEN
919: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
920: END IF;
921: -- Standard call to get message count and if count=1, get the message
922: FND_MSG_PUB.Count_And_Get (
923: p_encoded => FND_API.G_FALSE,
924: p_count => x_msg_count,
925: p_data => x_msg_data
926: );

Line 943: FND_MSG_PUB.initialize;

939: BEGIN
940: -- Initialize message list if p_init_msg_list is set to TRUE.
941: IF FND_API.to_Boolean( p_init_msg_list )
942: THEN
943: FND_MSG_PUB.initialize;
944: END IF;
945:
946: -- Initialize API return status to SUCCESS
947: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 955: FND_MSG_PUB.Count_And_Get

951: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('API_INVALID_RECORD'); END IF;
952:
953:
954:
955: FND_MSG_PUB.Count_And_Get
956: (p_count => x_msg_count,
957: p_data => x_msg_data
958: );
959: END Validate_REL_ITEM_Rec;