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_CONTACT_POINT_PVT dependencies on FND_API

Line 33: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

29: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30:
31: PROCEDURE create_contact_POINT(
32: p_api_version_number IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34: p_commit IN VARCHAR2 := FND_API.G_FALSE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36:
37: x_return_status OUT NOCOPY VARCHAR2,

Line 34: p_commit IN VARCHAR2 := FND_API.G_FALSE,

30:
31: PROCEDURE create_contact_POINT(
32: p_api_version_number IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34: p_commit IN VARCHAR2 := FND_API.G_FALSE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36:
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,

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

31: PROCEDURE create_contact_POINT(
32: p_api_version_number IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34: p_commit IN VARCHAR2 := FND_API.G_FALSE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36:
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,

Line 76: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

72:
73:
74: -- Standard call to check for call compatibility.
75:
76: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
77: p_api_version_number,
78: l_api_name,
79: G_PKG_NAME)
80: THEN

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

77: p_api_version_number,
78: l_api_name,
79: G_PKG_NAME)
80: THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 86: IF FND_API.to_Boolean( p_init_msg_list )

82: END IF;
83:
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean( p_init_msg_list )
87: THEN
88: FND_MSG_PUB.initialize;
89: END IF;
90:

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: END IF;
96:
97:
98: -- Initialize API return status to SUCCESS
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101:
102: -- =========================================================================
103: -- Validate Environment

Line 109: RAISE FND_API.G_EXC_ERROR;

105:
106: IF FND_GLOBAL.User_Id IS NULL
107: THEN
108: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
109: RAISE FND_API.G_EXC_ERROR;
110: END IF;
111:
112: -- Debug Message
113: IF (AMS_DEBUG_HIGH_ON) THEN

Line 184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

180: x_msg_data => l_msg_data
181: );
182:
183:
184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: x_msg_count := l_msg_count;
186: x_msg_data := l_msg_data;
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;

Line 187: RAISE FND_API.G_EXC_ERROR;

183:
184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: x_msg_count := l_msg_count;
186: x_msg_data := l_msg_data;
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189: x_contact_POINT_id:=l_contact_POINT_id;
190:
191: -- Standard check for p_commit

Line 192: IF FND_API.to_Boolean( p_commit )

188: END IF;
189: x_contact_POINT_id:=l_contact_POINT_id;
190:
191: -- Standard check for p_commit
192: IF FND_API.to_Boolean( p_commit )
193: THEN
194: COMMIT WORK;
195: END IF;
196:

Line 212: x_return_status := FND_API.g_ret_sts_error;

208: );
209: EXCEPTION
210:
211: WHEN AMS_Utility_PVT.resource_locked THEN
212: x_return_status := FND_API.g_ret_sts_error;
213: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
214:
215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO Create_Contact_POINT_PVT;

Line 215: WHEN FND_API.G_EXC_ERROR THEN

211: WHEN AMS_Utility_PVT.resource_locked THEN
212: x_return_status := FND_API.g_ret_sts_error;
213: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
214:
215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO Create_Contact_POINT_PVT;
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: -- Standard call to get message count and if count=1, get the message
219: FND_MSG_PUB.Count_And_Get (

Line 217: x_return_status := FND_API.G_RET_STS_ERROR;

213: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
214:
215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO Create_Contact_POINT_PVT;
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: -- Standard call to get message count and if count=1, get the message
219: FND_MSG_PUB.Count_And_Get (
220: p_encoded => FND_API.G_FALSE,
221: p_count => x_msg_count,

Line 220: p_encoded => FND_API.G_FALSE,

216: ROLLBACK TO Create_Contact_POINT_PVT;
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: -- Standard call to get message count and if count=1, get the message
219: FND_MSG_PUB.Count_And_Get (
220: p_encoded => FND_API.G_FALSE,
221: p_count => x_msg_count,
222: p_data => x_msg_data
223: );
224:

Line 225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

221: p_count => x_msg_count,
222: p_data => x_msg_data
223: );
224:
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO Create_Contact_POINT_PVT;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: -- Standard call to get message count and if count=1, get the message
229: FND_MSG_PUB.Count_And_Get (

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

223: );
224:
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO Create_Contact_POINT_PVT;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: -- Standard call to get message count and if count=1, get the message
229: FND_MSG_PUB.Count_And_Get (
230: p_encoded => FND_API.G_FALSE,
231: p_count => x_msg_count,

Line 230: p_encoded => FND_API.G_FALSE,

226: ROLLBACK TO Create_Contact_POINT_PVT;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: -- Standard call to get message count and if count=1, get the message
229: FND_MSG_PUB.Count_And_Get (
230: p_encoded => FND_API.G_FALSE,
231: p_count => x_msg_count,
232: p_data => x_msg_data
233: );
234:

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

233: );
234:
235: WHEN OTHERS THEN
236: ROLLBACK TO Create_Contact_POINT_PVT;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
241: END IF;

Line 244: p_encoded => FND_API.G_FALSE,

240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
241: END IF;
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248: End create_contact_POINT;

Line 255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

251:
252:
253: PROCEDURE update_contact_POINT(
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258:
259: x_return_status OUT NOCOPY VARCHAR2,

Line 256: p_commit IN VARCHAR2 := FND_API.G_FALSE,

252:
253: PROCEDURE update_contact_POINT(
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258:
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,

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

253: PROCEDURE update_contact_POINT(
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258:
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,

Line 278: l_commit VARCHAR2(1) := FND_API.g_true;

274: L_API_NAME CONSTANT VARCHAR2(30) := 'update_contact_POINT';
275: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
276: l_object_version_number NUMBER;
277: l_contact_POINT_id NUMBER;
278: l_commit VARCHAR2(1) := FND_API.g_true;
279: l_return_status VARCHAR2(1);
280: l_msg_count NUMBER;
281: l_msg_data VARCHAR2(2000);
282:

Line 297: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

293: -- Standard Start of API savepoint
294: SAVEPOINT UPDATE_CONTACT_POINT_PVT;
295:
296: -- Standard call to check for call compatibility.
297: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
298: p_api_version_number,
299: l_api_name,
300: G_PKG_NAME)
301: THEN

Line 302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

298: p_api_version_number,
299: l_api_name,
300: G_PKG_NAME)
301: THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END IF;
304:
305: -- Initialize message list if p_init_msg_list is set to TRUE.
306: IF FND_API.to_Boolean( p_init_msg_list )

Line 306: IF FND_API.to_Boolean( p_init_msg_list )

302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END IF;
304:
305: -- Initialize message list if p_init_msg_list is set to TRUE.
306: IF FND_API.to_Boolean( p_init_msg_list )
307: THEN
308: FND_MSG_PUB.initialize;
309: END IF;
310:

Line 319: x_return_status := FND_API.G_RET_STS_SUCCESS;

315: END IF;
316:
317:
318: -- Initialize API return status to SUCCESS
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: -- Debug Message
322: IF (AMS_DEBUG_HIGH_ON) THEN
323:

Line 397: IF FND_API.to_Boolean( p_commit )

393: );
394:
395:
396: -- Standard check for p_commit
397: IF FND_API.to_Boolean( p_commit )
398: THEN
399: COMMIT WORK;
400: END IF;
401:

Line 417: x_return_status := FND_API.g_ret_sts_error;

413: );
414: EXCEPTION
415:
416: WHEN AMS_Utility_PVT.resource_locked THEN
417: x_return_status := FND_API.g_ret_sts_error;
418: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
419:
420: WHEN FND_API.G_EXC_ERROR THEN
421: ROLLBACK TO UPDATE_CONTACT_POINT_PVT;

Line 420: WHEN FND_API.G_EXC_ERROR THEN

416: WHEN AMS_Utility_PVT.resource_locked THEN
417: x_return_status := FND_API.g_ret_sts_error;
418: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
419:
420: WHEN FND_API.G_EXC_ERROR THEN
421: ROLLBACK TO UPDATE_CONTACT_POINT_PVT;
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: -- Standard call to get message count and if count=1, get the message
424: FND_MSG_PUB.Count_And_Get (

Line 422: x_return_status := FND_API.G_RET_STS_ERROR;

418: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
419:
420: WHEN FND_API.G_EXC_ERROR THEN
421: ROLLBACK TO UPDATE_CONTACT_POINT_PVT;
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: -- Standard call to get message count and if count=1, get the message
424: FND_MSG_PUB.Count_And_Get (
425: p_encoded => FND_API.G_FALSE,
426: p_count => x_msg_count,

Line 425: p_encoded => FND_API.G_FALSE,

421: ROLLBACK TO UPDATE_CONTACT_POINT_PVT;
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: -- Standard call to get message count and if count=1, get the message
424: FND_MSG_PUB.Count_And_Get (
425: p_encoded => FND_API.G_FALSE,
426: p_count => x_msg_count,
427: p_data => x_msg_data
428: );
429:

Line 430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

426: p_count => x_msg_count,
427: p_data => x_msg_data
428: );
429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: ROLLBACK TO UPDATE_CONTACT_POINT_PVT;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: -- Standard call to get message count and if count=1, get the message
434: FND_MSG_PUB.Count_And_Get (

Line 432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

428: );
429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: ROLLBACK TO UPDATE_CONTACT_POINT_PVT;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: -- Standard call to get message count and if count=1, get the message
434: FND_MSG_PUB.Count_And_Get (
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_msg_count,

Line 435: p_encoded => FND_API.G_FALSE,

431: ROLLBACK TO UPDATE_CONTACT_POINT_PVT;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: -- Standard call to get message count and if count=1, get the message
434: FND_MSG_PUB.Count_And_Get (
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_msg_count,
437: p_data => x_msg_data
438: );
439:

Line 442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

438: );
439:
440: WHEN OTHERS THEN
441: ROLLBACK TO UPDATE_CONTACT_POINT_PVT;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
444: THEN
445: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
446: END IF;

Line 449: p_encoded => FND_API.G_FALSE,

445: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
446: END IF;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
449: p_encoded => FND_API.G_FALSE,
450: p_count => x_msg_count,
451: p_data => x_msg_data
452: );
453: End update_contact_POINT;