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_PREFERENCE_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_preference(
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_preference(
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_preference(
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 65: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

61:
62:
63: -- Standard call to check for call compatibility.
64:
65: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
66: p_api_version_number,
67: l_api_name,
68: G_PKG_NAME)
69: THEN

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66: p_api_version_number,
67: l_api_name,
68: G_PKG_NAME)
69: THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 75: IF FND_API.to_Boolean( p_init_msg_list )

71: END IF;
72:
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean( p_init_msg_list )
76: THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79:

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: END IF;
85:
86:
87: -- Initialize API return status to SUCCESS
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90:
91: -- =========================================================================
92: -- Validate Environment

Line 98: RAISE FND_API.G_EXC_ERROR;

94:
95: IF FND_GLOBAL.User_Id IS NULL
96: THEN
97: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:
101: -- Debug Message
102: IF (AMS_DEBUG_HIGH_ON) THEN

Line 144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

140: );
141:
142:
143:
144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: x_msg_count := l_msg_count;
146: x_msg_data := l_msg_data;
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;

Line 147: RAISE FND_API.G_EXC_ERROR;

143:
144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: x_msg_count := l_msg_count;
146: x_msg_data := l_msg_data;
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
149: x_contact_preference_id:=l_contact_preference_id;
150:
151:

Line 158: IF FND_API.to_Boolean( p_commit )

154:
155: END IF;
156:
157: -- Standard check for p_commit
158: IF FND_API.to_Boolean( p_commit )
159: THEN
160: COMMIT WORK;
161: END IF;
162:

Line 178: x_return_status := FND_API.g_ret_sts_error;

174: );
175: EXCEPTION
176:
177: WHEN AMS_Utility_PVT.resource_locked THEN
178: x_return_status := FND_API.g_ret_sts_error;
179: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
180:
181: WHEN FND_API.G_EXC_ERROR THEN
182: ROLLBACK TO Create_Contact_Preference_PVT;

Line 181: WHEN FND_API.G_EXC_ERROR THEN

177: WHEN AMS_Utility_PVT.resource_locked THEN
178: x_return_status := FND_API.g_ret_sts_error;
179: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
180:
181: WHEN FND_API.G_EXC_ERROR THEN
182: ROLLBACK TO Create_Contact_Preference_PVT;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: -- Standard call to get message count and if count=1, get the message
185: FND_MSG_PUB.Count_And_Get (

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
180:
181: WHEN FND_API.G_EXC_ERROR THEN
182: ROLLBACK TO Create_Contact_Preference_PVT;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: -- Standard call to get message count and if count=1, get the message
185: FND_MSG_PUB.Count_And_Get (
186: p_encoded => FND_API.G_FALSE,
187: p_count => x_msg_count,

Line 186: p_encoded => FND_API.G_FALSE,

182: ROLLBACK TO Create_Contact_Preference_PVT;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: -- Standard call to get message count and if count=1, get the message
185: FND_MSG_PUB.Count_And_Get (
186: p_encoded => FND_API.G_FALSE,
187: p_count => x_msg_count,
188: p_data => x_msg_data
189: );
190:

Line 191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

187: p_count => x_msg_count,
188: p_data => x_msg_data
189: );
190:
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192: ROLLBACK TO Create_Contact_Preference_PVT;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: -- Standard call to get message count and if count=1, get the message
195: FND_MSG_PUB.Count_And_Get (

Line 193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

189: );
190:
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192: ROLLBACK TO Create_Contact_Preference_PVT;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: -- Standard call to get message count and if count=1, get the message
195: FND_MSG_PUB.Count_And_Get (
196: p_encoded => FND_API.G_FALSE,
197: p_count => x_msg_count,

Line 196: p_encoded => FND_API.G_FALSE,

192: ROLLBACK TO Create_Contact_Preference_PVT;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: -- Standard call to get message count and if count=1, get the message
195: FND_MSG_PUB.Count_And_Get (
196: p_encoded => FND_API.G_FALSE,
197: p_count => x_msg_count,
198: p_data => x_msg_data
199: );
200:

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

199: );
200:
201: WHEN OTHERS THEN
202: ROLLBACK TO Create_Contact_Preference_PVT;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
205: THEN
206: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
207: END IF;

Line 210: p_encoded => FND_API.G_FALSE,

206: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
207: END IF;
208: -- Standard call to get message count and if count=1, get the message
209: FND_MSG_PUB.Count_And_Get (
210: p_encoded => FND_API.G_FALSE,
211: p_count => x_msg_count,
212: p_data => x_msg_data
213: );
214: End create_contact_preference;

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

217:
218:
219: PROCEDURE update_contact_preference(
220: p_api_version_number IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224:
225: x_return_status OUT NOCOPY VARCHAR2,

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

218:
219: PROCEDURE update_contact_preference(
220: p_api_version_number IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224:
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,

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

219: PROCEDURE update_contact_preference(
220: p_api_version_number IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224:
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,

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

235: L_API_NAME CONSTANT VARCHAR2(30) := 'update_contact_preference';
236: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
237: l_object_version_number NUMBER;
238: l_contact_preference_id NUMBER;
239: l_commit VARCHAR2(1) := FND_API.g_true;
240: l_return_status VARCHAR2(1);
241: l_msg_count NUMBER;
242: l_msg_data VARCHAR2(2000);
243: l_hz_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;

Line 250: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

246: -- Standard Start of API savepoint
247: SAVEPOINT UPDATE_CONTACT_PREFERENCE_PVT;
248:
249: -- Standard call to check for call compatibility.
250: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
251: p_api_version_number,
252: l_api_name,
253: G_PKG_NAME)
254: THEN

Line 255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

251: p_api_version_number,
252: l_api_name,
253: G_PKG_NAME)
254: THEN
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257:
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list )

Line 259: IF FND_API.to_Boolean( p_init_msg_list )

255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257:
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list )
260: THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263:

Line 272: x_return_status := FND_API.G_RET_STS_SUCCESS;

268: END IF;
269:
270:
271: -- Initialize API return status to SUCCESS
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:
274: -- Debug Message
275: IF (AMS_DEBUG_HIGH_ON) THEN
276:

Line 320: IF FND_API.to_Boolean( p_commit )

316:
317: END IF;
318:
319: -- Standard check for p_commit
320: IF FND_API.to_Boolean( p_commit )
321: THEN
322: COMMIT WORK;
323: END IF;
324:

Line 340: x_return_status := FND_API.g_ret_sts_error;

336: );
337: EXCEPTION
338:
339: WHEN AMS_Utility_PVT.resource_locked THEN
340: x_return_status := FND_API.g_ret_sts_error;
341: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO UPDATE_CONTACT_PREFERENCE_PVT;

Line 343: WHEN FND_API.G_EXC_ERROR THEN

339: WHEN AMS_Utility_PVT.resource_locked THEN
340: x_return_status := FND_API.g_ret_sts_error;
341: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO UPDATE_CONTACT_PREFERENCE_PVT;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: -- Standard call to get message count and if count=1, get the message
347: FND_MSG_PUB.Count_And_Get (

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO UPDATE_CONTACT_PREFERENCE_PVT;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: -- Standard call to get message count and if count=1, get the message
347: FND_MSG_PUB.Count_And_Get (
348: p_encoded => FND_API.G_FALSE,
349: p_count => x_msg_count,

Line 348: p_encoded => FND_API.G_FALSE,

344: ROLLBACK TO UPDATE_CONTACT_PREFERENCE_PVT;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: -- Standard call to get message count and if count=1, get the message
347: FND_MSG_PUB.Count_And_Get (
348: p_encoded => FND_API.G_FALSE,
349: p_count => x_msg_count,
350: p_data => x_msg_data
351: );
352:

Line 353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

349: p_count => x_msg_count,
350: p_data => x_msg_data
351: );
352:
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK TO UPDATE_CONTACT_PREFERENCE_PVT;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: -- Standard call to get message count and if count=1, get the message
357: FND_MSG_PUB.Count_And_Get (

Line 355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

351: );
352:
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK TO UPDATE_CONTACT_PREFERENCE_PVT;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: -- Standard call to get message count and if count=1, get the message
357: FND_MSG_PUB.Count_And_Get (
358: p_encoded => FND_API.G_FALSE,
359: p_count => x_msg_count,

Line 358: p_encoded => FND_API.G_FALSE,

354: ROLLBACK TO UPDATE_CONTACT_PREFERENCE_PVT;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: -- Standard call to get message count and if count=1, get the message
357: FND_MSG_PUB.Count_And_Get (
358: p_encoded => FND_API.G_FALSE,
359: p_count => x_msg_count,
360: p_data => x_msg_data
361: );
362:

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

361: );
362:
363: WHEN OTHERS THEN
364: ROLLBACK TO UPDATE_CONTACT_PREFERENCE_PVT;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
367: THEN
368: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
369: END IF;

Line 372: p_encoded => FND_API.G_FALSE,

368: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
369: END IF;
370: -- Standard call to get message count and if count=1, get the message
371: FND_MSG_PUB.Count_And_Get (
372: p_encoded => FND_API.G_FALSE,
373: p_count => x_msg_count,
374: p_data => x_msg_data
375: );
376: End update_contact_preference;