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

Line 47: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

43: -- Parameters
44: --
45: -- IN
46: -- p_api_version_number IN NUMBER Required
47: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
48: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
49: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
50: -- p_partner_access_rec IN partner_access_rec_type Required
51: --

Line 48: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

44: --
45: -- IN
46: -- p_api_version_number IN NUMBER Required
47: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
48: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
49: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
50: -- p_partner_access_rec IN partner_access_rec_type Required
51: --
52: -- OUT

Line 49: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

45: -- IN
46: -- p_api_version_number IN NUMBER Required
47: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
48: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
49: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
50: -- p_partner_access_rec IN partner_access_rec_type Required
51: --
52: -- OUT
53: -- x_return_status OUT VARCHAR2

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

65: -- ==============================================================================
66:
67: PROCEDURE Create_Partner_Accesses(
68: p_api_version_number IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,

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

66:
67: PROCEDURE Create_Partner_Accesses(
68: p_api_version_number IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,

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

67: PROCEDURE Create_Partner_Accesses(
68: p_api_version_number IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: p_partner_access_rec IN partner_access_rec_type := g_miss_partner_access_rec,

Line 103: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

99: -- Standard Start of API savepoint
100: SAVEPOINT create_partner_accesses_pvt;
101:
102: -- Standard call to check for call compatibility.
103: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
104: p_api_version_number,
105: l_api_name,
106: G_PKG_NAME)
107: THEN

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: p_api_version_number,
105: l_api_name,
106: G_PKG_NAME)
107: THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list )

Line 112: IF FND_API.to_Boolean( p_init_msg_list )

108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list )
113: THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116:

Line 123: x_return_status := FND_API.G_RET_STS_SUCCESS;

119: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start.');
120: END IF;
121:
122: -- Initialize API return status to SUCCESS
123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124:
125: -- =========================================================================
126: -- Validate Environment
127: -- =========================================================================

Line 132: RAISE FND_API.G_EXC_ERROR;

128:
129: IF FND_GLOBAL.USER_ID IS NULL
130: THEN
131: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
136: THEN

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

131: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
136: THEN
137: -- Debug message
138: IF (PV_DEBUG_HIGH_ON) THEN
139: PVX_UTILITY_PVT.debug_message('Private API: Validate_Partner_Accesses.');

Line 145: p_init_msg_list => FND_API.G_FALSE,

141:
142: -- Invoke validation procedures
143: Validate_partner_accesses(
144: p_api_version_number => 1.0,
145: p_init_msg_list => FND_API.G_FALSE,
146: p_validation_level => p_validation_level,
147: p_validation_mode => JTF_PLSQL_API.g_create,
148: p_partner_access_rec => p_partner_access_rec,
149: x_return_status => x_return_status,

Line 154: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

150: x_msg_count => x_msg_count,
151: x_msg_data => x_msg_data);
152: END IF;
153:
154: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157:
158: -- Local variable initialization

Line 155: RAISE FND_API.G_EXC_ERROR;

151: x_msg_data => x_msg_data);
152: END IF;
153:
154: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157:
158: -- Local variable initialization
159:

Line 160: IF p_partner_access_rec.partner_access_id IS NULL OR p_partner_access_rec.partner_access_id = FND_API.g_miss_num THEN

156: END IF;
157:
158: -- Local variable initialization
159:
160: IF p_partner_access_rec.partner_access_id IS NULL OR p_partner_access_rec.partner_access_id = FND_API.g_miss_num THEN
161: LOOP
162: l_dummy := NULL;
163: OPEN c_id;
164: FETCH c_id INTO l_partner_access_id;

Line 218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

214: p_attribute14 => p_partner_access_rec.attribute14,
215: p_attribute15 => p_partner_access_rec.attribute15,
216: x_return_status=> x_return_status);
217:
218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219: l_err_msg := substr(to_char(SQLCODE)||'-'||SQLERRM,1,2000);
220: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
221: FND_MESSAGE.set_token('ERROR', l_err_msg);
222: FND_MSG_PUB.add;

Line 223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

219: l_err_msg := substr(to_char(SQLCODE)||'-'||SQLERRM,1,2000);
220: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
221: FND_MESSAGE.set_token('ERROR', l_err_msg);
222: FND_MSG_PUB.add;
223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
224: RAISE FND_API.G_EXC_ERROR;
225: ELSE
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;

Line 224: RAISE FND_API.G_EXC_ERROR;

220: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
221: FND_MESSAGE.set_token('ERROR', l_err_msg);
222: FND_MSG_PUB.add;
223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
224: RAISE FND_API.G_EXC_ERROR;
225: ELSE
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
228: END IF;

Line 226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

222: FND_MSG_PUB.add;
223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
224: RAISE FND_API.G_EXC_ERROR;
225: ELSE
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
228: END IF;
229:
230: x_partner_access_id := l_partner_access_id;

Line 236: IF FND_API.to_Boolean( p_commit )

232: -- End of API body
233: --
234:
235: -- Standard check for p_commit
236: IF FND_API.to_Boolean( p_commit )
237: THEN
238: COMMIT WORK;
239: END IF;
240:

Line 254: x_return_status := FND_API.g_ret_sts_error;

250: );
251: EXCEPTION
252:
253: WHEN PVX_UTILITY_PVT.resource_locked THEN
254: x_return_status := FND_API.g_ret_sts_error;
255: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Partner_Accesses_PVT;

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253: WHEN PVX_UTILITY_PVT.resource_locked THEN
254: x_return_status := FND_API.g_ret_sts_error;
255: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Partner_Accesses_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Partner_Accesses_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,

Line 262: p_encoded => FND_API.G_FALSE,

258: ROLLBACK TO CREATE_Partner_Accesses_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266:

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO CREATE_Partner_Accesses_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 272: p_encoded => FND_API.G_FALSE,

268: ROLLBACK TO CREATE_Partner_Accesses_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
275: );
276:

Line 279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

275: );
276:
277: WHEN OTHERS THEN
278: ROLLBACK TO CREATE_Partner_Accesses_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
281: THEN
282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;

Line 286: p_encoded => FND_API.G_FALSE,

282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;
284: -- Standard call to get message count and if count=1, get the message
285: FND_MSG_PUB.Count_And_Get (
286: p_encoded => FND_API.G_FALSE,
287: p_count => x_msg_count,
288: p_data => x_msg_data
289: );
290: End Create_Partner_Accesses;

Line 305: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

301: -- Parameters
302: --
303: -- IN
304: -- p_api_version_number IN NUMBER Required
305: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
306: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
307: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
308: -- p_partner_access_rec IN partner_access_rec_type Required
309: --

Line 306: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

302: --
303: -- IN
304: -- p_api_version_number IN NUMBER Required
305: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
306: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
307: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
308: -- p_partner_access_rec IN partner_access_rec_type Required
309: --
310: -- OUT

Line 307: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

303: -- IN
304: -- p_api_version_number IN NUMBER Required
305: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
306: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
307: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
308: -- p_partner_access_rec IN partner_access_rec_type Required
309: --
310: -- OUT
311: -- x_return_status OUT VARCHAR2

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

323: -- ==============================================================================
324:
325: PROCEDURE Update_Partner_Accesses(
326: p_api_version_number IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,

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

324:
325: PROCEDURE Update_Partner_Accesses(
326: p_api_version_number IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,

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

325: PROCEDURE Update_Partner_Accesses(
326: p_api_version_number IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,
333: p_partner_access_rec IN partner_access_rec_type

Line 358: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

354: -- Standard Start of API savepoint
355: SAVEPOINT update_partner_accesses_pvt;
356:
357: -- Standard call to check for call compatibility.
358: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
359: p_api_version_number,
360: l_api_name,
361: G_PKG_NAME)
362: THEN

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359: p_api_version_number,
360: l_api_name,
361: G_PKG_NAME)
362: THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366:
367: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 368: IF FND_API.to_Boolean( p_init_msg_list )

364: END IF;
365:
366:
367: -- Initialize message list if p_init_msg_list is set to TRUE.
368: IF FND_API.to_Boolean( p_init_msg_list )
369: THEN
370: FND_MSG_PUB.initialize;
371: END IF;
372:

Line 379: x_return_status := FND_API.G_RET_STS_SUCCESS;

375: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
376: END IF;
377:
378: -- Initialize API return status to SUCCESS
379: x_return_status := FND_API.G_RET_STS_SUCCESS;
380:
381: -- Debug Message
382: IF (PV_DEBUG_HIGH_ON) THEN
383: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line 395: RAISE FND_API.G_EXC_ERROR;

391: PVX_UTILITY_PVT.Error_Message(
392: p_message_name => 'API_MISSING_UPDATE_TARGET',
393: p_token_name => 'INFO',
394: p_token_value => 'Partner_Accesses') ;
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397:
398: -- Debug Message
399: IF (PV_DEBUG_HIGH_ON) THEN

Line 406: l_tar_partner_access_rec.object_version_number = FND_API.G_MISS_NUM ) THEN

402:
403: CLOSE c_get_Partner_Accesses;
404:
405: IF (l_tar_partner_access_rec.object_version_number is NULL or
406: l_tar_partner_access_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
407: PVX_UTILITY_PVT.Error_Message(
408: p_message_name => 'API_VERSION_MISSING',
409: p_token_name => 'COLUMN',
410: p_token_value => 'OBJECT_VERSION_NUMBER') ;

Line 411: raise FND_API.G_EXC_ERROR;

407: PVX_UTILITY_PVT.Error_Message(
408: p_message_name => 'API_VERSION_MISSING',
409: p_token_name => 'COLUMN',
410: p_token_value => 'OBJECT_VERSION_NUMBER') ;
411: raise FND_API.G_EXC_ERROR;
412: End if;
413:
414: -- Check Whether record has been changed by someone else
415: IF (l_tar_partner_access_rec.object_version_number <> l_ref_partner_access_rec.object_version_number) THEN

Line 420: raise FND_API.G_EXC_ERROR;

416: PVX_UTILITY_PVT.Error_Message(
417: p_message_name => 'API_RECORD_CHANGED',
418: p_token_name => 'INFO',
419: p_token_value => 'Partner_Accesses') ;
420: raise FND_API.G_EXC_ERROR;
421: End if;
422:
423: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
424: THEN

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

419: p_token_value => 'Partner_Accesses') ;
420: raise FND_API.G_EXC_ERROR;
421: End if;
422:
423: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
424: THEN
425: -- Debug Message
426: IF (PV_DEBUG_HIGH_ON) THEN
427: PVX_UTILITY_PVT.debug_message('Private API: Validate_Partner_Accesses');

Line 432: p_init_msg_list => FND_API.G_FALSE,

428: END IF;
429:
430: Validate_partner_accesses(
431: p_api_version_number => 1.0,
432: p_init_msg_list => FND_API.G_FALSE,
433: p_validation_level => p_validation_level,
434: p_partner_access_rec => p_partner_access_rec,
435: p_validation_mode => JTF_PLSQL_API.g_update,
436: x_return_status => x_return_status,

Line 441: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

437: x_msg_count => x_msg_count,
438: x_msg_data => x_msg_data);
439: END IF;
440:
441: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445:

Line 442: RAISE FND_API.G_EXC_ERROR;

438: x_msg_data => x_msg_data);
439: END IF;
440:
441: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445:
446: -- Debug Message

Line 486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

482: p_attribute14 => p_partner_access_rec.attribute14,
483: p_attribute15 => p_partner_access_rec.attribute15,
484: x_return_status => x_return_status);
485:
486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
487: l_err_msg := substr(to_char(SQLCODE)||'-'||SQLERRM,1,2000);
488: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
489: FND_MESSAGE.set_token('ERROR', l_err_msg);
490: FND_MSG_PUB.add;

Line 491: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

487: l_err_msg := substr(to_char(SQLCODE)||'-'||SQLERRM,1,2000);
488: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
489: FND_MESSAGE.set_token('ERROR', l_err_msg);
490: FND_MSG_PUB.add;
491: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
492: RAISE FND_API.G_EXC_ERROR;
493: ELSE
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;

Line 492: RAISE FND_API.G_EXC_ERROR;

488: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
489: FND_MESSAGE.set_token('ERROR', l_err_msg);
490: FND_MSG_PUB.add;
491: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
492: RAISE FND_API.G_EXC_ERROR;
493: ELSE
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496: END IF;

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

490: FND_MSG_PUB.add;
491: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
492: RAISE FND_API.G_EXC_ERROR;
493: ELSE
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496: END IF;
497:
498: --

Line 503: IF FND_API.to_Boolean( p_commit )

499: -- End of API body.
500: --
501:
502: -- Standard check for p_commit
503: IF FND_API.to_Boolean( p_commit )
504: THEN
505: COMMIT WORK;
506: END IF;
507:

Line 522: x_return_status := FND_API.g_ret_sts_error;

518: );
519: EXCEPTION
520:
521: WHEN PVX_UTILITY_PVT.resource_locked THEN
522: x_return_status := FND_API.g_ret_sts_error;
523: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
524:
525: WHEN FND_API.G_EXC_ERROR THEN
526: ROLLBACK TO UPDATE_Partner_Accesses_PVT;

Line 525: WHEN FND_API.G_EXC_ERROR THEN

521: WHEN PVX_UTILITY_PVT.resource_locked THEN
522: x_return_status := FND_API.g_ret_sts_error;
523: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
524:
525: WHEN FND_API.G_EXC_ERROR THEN
526: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: -- Standard call to get message count and if count=1, get the message
529: FND_MSG_PUB.Count_And_Get (

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
524:
525: WHEN FND_API.G_EXC_ERROR THEN
526: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: -- Standard call to get message count and if count=1, get the message
529: FND_MSG_PUB.Count_And_Get (
530: p_encoded => FND_API.G_FALSE,
531: p_count => x_msg_count,

Line 530: p_encoded => FND_API.G_FALSE,

526: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: -- Standard call to get message count and if count=1, get the message
529: FND_MSG_PUB.Count_And_Get (
530: p_encoded => FND_API.G_FALSE,
531: p_count => x_msg_count,
532: p_data => x_msg_data
533: );
534:

Line 535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

531: p_count => x_msg_count,
532: p_data => x_msg_data
533: );
534:
535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
536: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: -- Standard call to get message count and if count=1, get the message
539: FND_MSG_PUB.Count_And_Get (

Line 537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

533: );
534:
535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
536: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: -- Standard call to get message count and if count=1, get the message
539: FND_MSG_PUB.Count_And_Get (
540: p_encoded => FND_API.G_FALSE,
541: p_count => x_msg_count,

Line 540: p_encoded => FND_API.G_FALSE,

536: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: -- Standard call to get message count and if count=1, get the message
539: FND_MSG_PUB.Count_And_Get (
540: p_encoded => FND_API.G_FALSE,
541: p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:

Line 547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

543: );
544:
545: WHEN OTHERS THEN
546: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN
550: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
551: END IF;

Line 554: p_encoded => FND_API.G_FALSE,

550: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
551: END IF;
552: -- Standard call to get message count and if count=1, get the message
553: FND_MSG_PUB.Count_And_Get (
554: p_encoded => FND_API.G_FALSE,
555: p_count => x_msg_count,
556: p_data => x_msg_data
557: );
558: End Update_Partner_Accesses;

Line 573: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

569: -- Parameters
570: --
571: -- IN
572: -- p_api_version_number IN NUMBER Required
573: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
574: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
575: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
576: -- p_partner_access_id IN NUMBER
577: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 574: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

570: --
571: -- IN
572: -- p_api_version_number IN NUMBER Required
573: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
574: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
575: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
576: -- p_partner_access_id IN NUMBER
577: -- p_object_version_number IN NUMBER Optional Default = NULL
578: --

Line 575: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

571: -- IN
572: -- p_api_version_number IN NUMBER Required
573: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
574: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
575: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
576: -- p_partner_access_id IN NUMBER
577: -- p_object_version_number IN NUMBER Optional Default = NULL
578: --
579: -- OUT

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

592: -- ==============================================================================
593:
594: PROCEDURE Delete_Partner_Accesses(
595: p_api_version_number IN NUMBER,
596: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
597: p_commit IN VARCHAR2 := FND_API.G_FALSE,
598: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
599: x_return_status OUT NOCOPY VARCHAR2,
600: x_msg_count OUT NOCOPY NUMBER,

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

593:
594: PROCEDURE Delete_Partner_Accesses(
595: p_api_version_number IN NUMBER,
596: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
597: p_commit IN VARCHAR2 := FND_API.G_FALSE,
598: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
599: x_return_status OUT NOCOPY VARCHAR2,
600: x_msg_count OUT NOCOPY NUMBER,
601: x_msg_data OUT NOCOPY VARCHAR2,

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

594: PROCEDURE Delete_Partner_Accesses(
595: p_api_version_number IN NUMBER,
596: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
597: p_commit IN VARCHAR2 := FND_API.G_FALSE,
598: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
599: x_return_status OUT NOCOPY VARCHAR2,
600: x_msg_count OUT NOCOPY NUMBER,
601: x_msg_data OUT NOCOPY VARCHAR2,
602: p_partner_access_id IN NUMBER,

Line 617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

613: -- Standard Start of API savepoint
614: SAVEPOINT delete_partner_accesses_pvt;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
618: p_api_version_number,
619: l_api_name,
620: G_PKG_NAME)
621: THEN

Line 622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

618: p_api_version_number,
619: l_api_name,
620: G_PKG_NAME)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625:
626: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 627: IF FND_API.to_Boolean( p_init_msg_list )

623: END IF;
624:
625:
626: -- Initialize message list if p_init_msg_list is set to TRUE.
627: IF FND_API.to_Boolean( p_init_msg_list )
628: THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631:

Line 638: x_return_status := FND_API.G_RET_STS_SUCCESS;

634: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
635: END IF;
636:
637: -- Initialize API return status to SUCCESS
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:
640: --
641: -- Api body
642: --

Line 655: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

651: p_partner_access_id => p_partner_access_id,
652: p_object_version_number => p_object_version_number ,
653: x_return_status => x_return_status);
654:
655: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
656: l_err_msg := substr(to_char(SQLCODE)||'-'||SQLERRM,1,2000);
657: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
658: FND_MESSAGE.set_token('ERROR', l_err_msg);
659: FND_MSG_PUB.add;

Line 660: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

656: l_err_msg := substr(to_char(SQLCODE)||'-'||SQLERRM,1,2000);
657: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
658: FND_MESSAGE.set_token('ERROR', l_err_msg);
659: FND_MSG_PUB.add;
660: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
661: RAISE FND_API.G_EXC_ERROR;
662: ELSE
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;

Line 661: RAISE FND_API.G_EXC_ERROR;

657: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
658: FND_MESSAGE.set_token('ERROR', l_err_msg);
659: FND_MSG_PUB.add;
660: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
661: RAISE FND_API.G_EXC_ERROR;
662: ELSE
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;
665: END IF;

Line 663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

659: FND_MSG_PUB.add;
660: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
661: RAISE FND_API.G_EXC_ERROR;
662: ELSE
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;
665: END IF;
666:
667: --

Line 672: IF FND_API.to_Boolean( p_commit )

668: -- End of API body
669: --
670:
671: -- Standard check for p_commit
672: IF FND_API.to_Boolean( p_commit )
673: THEN
674: COMMIT WORK;
675: END IF;
676:

Line 690: x_return_status := FND_API.g_ret_sts_error;

686: );
687: EXCEPTION
688:
689: WHEN PVX_UTILITY_PVT.resource_locked THEN
690: x_return_status := FND_API.g_ret_sts_error;
691: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
692:
693: WHEN FND_API.G_EXC_ERROR THEN
694: ROLLBACK TO DELETE_Partner_Accesses_PVT;

Line 693: WHEN FND_API.G_EXC_ERROR THEN

689: WHEN PVX_UTILITY_PVT.resource_locked THEN
690: x_return_status := FND_API.g_ret_sts_error;
691: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
692:
693: WHEN FND_API.G_EXC_ERROR THEN
694: ROLLBACK TO DELETE_Partner_Accesses_PVT;
695: x_return_status := FND_API.G_RET_STS_ERROR;
696:
697: -- Standard call to get message count and if count=1, get the message

Line 695: x_return_status := FND_API.G_RET_STS_ERROR;

691: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
692:
693: WHEN FND_API.G_EXC_ERROR THEN
694: ROLLBACK TO DELETE_Partner_Accesses_PVT;
695: x_return_status := FND_API.G_RET_STS_ERROR;
696:
697: -- Standard call to get message count and if count=1, get the message
698: FND_MSG_PUB.Count_And_Get (
699: p_encoded => FND_API.G_FALSE,

Line 699: p_encoded => FND_API.G_FALSE,

695: x_return_status := FND_API.G_RET_STS_ERROR;
696:
697: -- Standard call to get message count and if count=1, get the message
698: FND_MSG_PUB.Count_And_Get (
699: p_encoded => FND_API.G_FALSE,
700: p_count => x_msg_count,
701: p_data => x_msg_data
702: );
703:

Line 704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

700: p_count => x_msg_count,
701: p_data => x_msg_data
702: );
703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: ROLLBACK TO DELETE_Partner_Accesses_PVT;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707:
708: -- Standard call to get message count and if count=1, get the message

Line 706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

702: );
703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: ROLLBACK TO DELETE_Partner_Accesses_PVT;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707:
708: -- Standard call to get message count and if count=1, get the message
709: FND_MSG_PUB.Count_And_Get (
710: p_encoded => FND_API.G_FALSE,

Line 710: p_encoded => FND_API.G_FALSE,

706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707:
708: -- Standard call to get message count and if count=1, get the message
709: FND_MSG_PUB.Count_And_Get (
710: p_encoded => FND_API.G_FALSE,
711: p_count => x_msg_count,
712: p_data => x_msg_data
713: );
714:

Line 717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

713: );
714:
715: WHEN OTHERS THEN
716: ROLLBACK TO DELETE_Partner_Accesses_PVT;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718:
719: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
720: THEN
721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 726: p_encoded => FND_API.G_FALSE,

722: END IF;
723:
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data
729: );
730: End Delete_Partner_Accesses;

Line 746: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

742: -- Parameters
743: --
744: -- IN
745: -- p_api_version_number IN NUMBER Required
746: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
747: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
748: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
749: -- p_partner_access_rec IN partner_access_rec_type Required
750: --

Line 747: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

743: --
744: -- IN
745: -- p_api_version_number IN NUMBER Required
746: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
747: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
748: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
749: -- p_partner_access_rec IN partner_access_rec_type Required
750: --
751: -- OUT

Line 748: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

744: -- IN
745: -- p_api_version_number IN NUMBER Required
746: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
747: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
748: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
749: -- p_partner_access_rec IN partner_access_rec_type Required
750: --
751: -- OUT
752: -- x_return_status OUT VARCHAR2

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

764: -- ==============================================================================
765:
766: PROCEDURE Lock_Partner_Accesses(
767: p_api_version_number IN NUMBER,
768: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,
771: x_msg_data OUT NOCOPY VARCHAR2,
772: p_partner_access_id IN NUMBER,

Line 793: IF FND_API.to_Boolean( p_init_msg_list )

789: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
790: END IF;
791:
792: -- Initialize message list if p_init_msg_list is set to TRUE.
793: IF FND_API.to_Boolean( p_init_msg_list )
794: THEN
795: FND_MSG_PUB.initialize;
796: END IF;
797:

Line 799: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

795: FND_MSG_PUB.initialize;
796: END IF;
797:
798: -- Standard call to check for call compatibility.
799: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
800: p_api_version_number,
801: l_api_name,
802: G_PKG_NAME)
803: THEN

Line 804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

800: p_api_version_number,
801: l_api_name,
802: G_PKG_NAME)
803: THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806:
807: -- Initialize API return status to SUCCESS
808: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 808: x_return_status := FND_API.G_RET_STS_SUCCESS;

804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806:
807: -- Initialize API return status to SUCCESS
808: x_return_status := FND_API.G_RET_STS_SUCCESS;
809:
810: ------------------------ lock -------------------------
811: Pv_Partner_Accesses_Pkg.Lock_Row(
812: p_partner_access_id,

Line 816: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

812: p_partner_access_id,
813: p_object_version_number,
814: x_return_status);
815:
816: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
817: RAISE FND_API.G_EXC_ERROR;
818: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: END IF;

Line 817: RAISE FND_API.G_EXC_ERROR;

813: p_object_version_number,
814: x_return_status);
815:
816: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
817: RAISE FND_API.G_EXC_ERROR;
818: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: END IF;
821:

Line 818: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

814: x_return_status);
815:
816: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
817: RAISE FND_API.G_EXC_ERROR;
818: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: END IF;
821:
822: -------------------- finish --------------------------

Line 819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

815:
816: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
817: RAISE FND_API.G_EXC_ERROR;
818: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: END IF;
821:
822: -------------------- finish --------------------------
823:

Line 825: p_encoded => FND_API.g_false,

821:
822: -------------------- finish --------------------------
823:
824: FND_MSG_PUB.count_and_get(
825: p_encoded => FND_API.g_false,
826: p_count => x_msg_count,
827: p_data => x_msg_data);
828:
829: -- Debug Message

Line 837: x_return_status := FND_API.g_ret_sts_error;

833:
834: EXCEPTION
835:
836: WHEN PVX_UTILITY_PVT.resource_locked THEN
837: x_return_status := FND_API.g_ret_sts_error;
838: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
839:
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO Lock_Partner_Accesses;

Line 840: WHEN FND_API.G_EXC_ERROR THEN

836: WHEN PVX_UTILITY_PVT.resource_locked THEN
837: x_return_status := FND_API.g_ret_sts_error;
838: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
839:
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO Lock_Partner_Accesses;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (

Line 842: x_return_status := FND_API.G_RET_STS_ERROR;

838: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
839:
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO Lock_Partner_Accesses;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,

Line 845: p_encoded => FND_API.G_FALSE,

841: ROLLBACK TO Lock_Partner_Accesses;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => x_msg_data
848: );
849:

Line 850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

846: p_count => x_msg_count,
847: p_data => x_msg_data
848: );
849:
850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
851: ROLLBACK TO Lock_Partner_Accesses;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: -- Standard call to get message count and if count=1, get the message
854: FND_MSG_PUB.Count_And_Get (

Line 852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

848: );
849:
850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
851: ROLLBACK TO Lock_Partner_Accesses;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: -- Standard call to get message count and if count=1, get the message
854: FND_MSG_PUB.Count_And_Get (
855: p_encoded => FND_API.G_FALSE,
856: p_count => x_msg_count,

Line 855: p_encoded => FND_API.G_FALSE,

851: ROLLBACK TO Lock_Partner_Accesses;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: -- Standard call to get message count and if count=1, get the message
854: FND_MSG_PUB.Count_And_Get (
855: p_encoded => FND_API.G_FALSE,
856: p_count => x_msg_count,
857: p_data => x_msg_data
858: );
859:

Line 862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

858: );
859:
860: WHEN OTHERS THEN
861: ROLLBACK TO Lock_Partner_Accesses;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;

Line 869: p_encoded => FND_API.G_FALSE,

865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;
867: -- Standard call to get message count and if count=1, get the message
868: FND_MSG_PUB.Count_And_Get (
869: p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count,
871: p_data => x_msg_data
872: );
873: End Lock_Partner_Accesses;

Line 883: x_return_status := FND_API.g_ret_sts_success;

879: IS
880: l_valid_flag VARCHAR2(1);
881:
882: BEGIN
883: x_return_status := FND_API.g_ret_sts_success;
884: IF p_validation_mode = JTF_PLSQL_API.g_create AND
885: p_partner_access_rec.partner_access_id IS NOT NULL THEN
886: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
887: 'pv_partner_accesses',

Line 892: IF l_valid_flag = FND_API.g_false THEN

888: 'partner_access_id = ''' || p_partner_access_rec.partner_access_id ||''''
889: );
890: END IF;
891:
892: IF l_valid_flag = FND_API.g_false THEN
893: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_DUPLICATE_ID');
894: x_return_status := FND_API.g_ret_sts_error;
895: END IF;
896:

Line 894: x_return_status := FND_API.g_ret_sts_error;

890: END IF;
891:
892: IF l_valid_flag = FND_API.g_false THEN
893: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_DUPLICATE_ID');
894: x_return_status := FND_API.g_ret_sts_error;
895: END IF;
896:
897: END chk_Partner_Access_Uk_Items;
898:

Line 906: x_return_status := FND_API.g_ret_sts_success;

902: x_return_status OUT NOCOPY VARCHAR2
903: )
904: IS
905: BEGIN
906: x_return_status := FND_API.g_ret_sts_success;
907:
908: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
909:
910: -- Check for required paramter PARTNER_ID.

Line 911: IF p_partner_access_rec.partner_id = FND_API.G_MISS_NUM OR p_partner_access_rec.partner_id IS NULL THEN

907:
908: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
909:
910: -- Check for required paramter PARTNER_ID.
911: IF p_partner_access_rec.partner_id = FND_API.G_MISS_NUM OR p_partner_access_rec.partner_id IS NULL THEN
912: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915:

Line 913: x_return_status := FND_API.g_ret_sts_error;

909:
910: -- Check for required paramter PARTNER_ID.
911: IF p_partner_access_rec.partner_id = FND_API.G_MISS_NUM OR p_partner_access_rec.partner_id IS NULL THEN
912: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915:
916: -- Check for required paramter RESOURCE_ID.
917: IF p_partner_access_rec.resource_id = FND_API.G_MISS_NUM OR p_partner_access_rec.resource_id IS NULL THEN

Line 917: IF p_partner_access_rec.resource_id = FND_API.G_MISS_NUM OR p_partner_access_rec.resource_id IS NULL THEN

913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915:
916: -- Check for required paramter RESOURCE_ID.
917: IF p_partner_access_rec.resource_id = FND_API.G_MISS_NUM OR p_partner_access_rec.resource_id IS NULL THEN
918: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'RESOURCE_ID' );
919: x_return_status := FND_API.g_ret_sts_error;
920: END IF;
921:

Line 919: x_return_status := FND_API.g_ret_sts_error;

915:
916: -- Check for required paramter RESOURCE_ID.
917: IF p_partner_access_rec.resource_id = FND_API.G_MISS_NUM OR p_partner_access_rec.resource_id IS NULL THEN
918: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'RESOURCE_ID' );
919: x_return_status := FND_API.g_ret_sts_error;
920: END IF;
921:
922: -- Check for required paramter KEEP_FLAG.
923: IF p_partner_access_rec.keep_flag = FND_API.g_miss_char OR p_partner_access_rec.keep_flag IS NULL THEN

Line 923: IF p_partner_access_rec.keep_flag = FND_API.g_miss_char OR p_partner_access_rec.keep_flag IS NULL THEN

919: x_return_status := FND_API.g_ret_sts_error;
920: END IF;
921:
922: -- Check for required paramter KEEP_FLAG.
923: IF p_partner_access_rec.keep_flag = FND_API.g_miss_char OR p_partner_access_rec.keep_flag IS NULL THEN
924: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'KEEP_FLAG' );
925: x_return_status := FND_API.g_ret_sts_error;
926: END IF;
927:

Line 925: x_return_status := FND_API.g_ret_sts_error;

921:
922: -- Check for required paramter KEEP_FLAG.
923: IF p_partner_access_rec.keep_flag = FND_API.g_miss_char OR p_partner_access_rec.keep_flag IS NULL THEN
924: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'KEEP_FLAG' );
925: x_return_status := FND_API.g_ret_sts_error;
926: END IF;
927:
928: -- Check for required paramter CREATED_BY_TAP_FLAG.
929: IF p_partner_access_rec.created_by_tap_flag = FND_API.g_miss_char OR p_partner_access_rec.created_by_tap_flag IS NULL THEN

Line 929: IF p_partner_access_rec.created_by_tap_flag = FND_API.g_miss_char OR p_partner_access_rec.created_by_tap_flag IS NULL THEN

925: x_return_status := FND_API.g_ret_sts_error;
926: END IF;
927:
928: -- Check for required paramter CREATED_BY_TAP_FLAG.
929: IF p_partner_access_rec.created_by_tap_flag = FND_API.g_miss_char OR p_partner_access_rec.created_by_tap_flag IS NULL THEN
930: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'CREATED_BY_TAP_FLAG' );
931: x_return_status := FND_API.g_ret_sts_error;
932: END IF;
933:

Line 931: x_return_status := FND_API.g_ret_sts_error;

927:
928: -- Check for required paramter CREATED_BY_TAP_FLAG.
929: IF p_partner_access_rec.created_by_tap_flag = FND_API.g_miss_char OR p_partner_access_rec.created_by_tap_flag IS NULL THEN
930: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'CREATED_BY_TAP_FLAG' );
931: x_return_status := FND_API.g_ret_sts_error;
932: END IF;
933:
934: -- Check for required paramter ACCESS_TYPE.
935: IF p_partner_access_rec.access_type = FND_API.g_miss_char OR p_partner_access_rec.access_type IS NULL THEN

Line 935: IF p_partner_access_rec.access_type = FND_API.g_miss_char OR p_partner_access_rec.access_type IS NULL THEN

931: x_return_status := FND_API.g_ret_sts_error;
932: END IF;
933:
934: -- Check for required paramter ACCESS_TYPE.
935: IF p_partner_access_rec.access_type = FND_API.g_miss_char OR p_partner_access_rec.access_type IS NULL THEN
936: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'ACCESS_TYPE' );
937: x_return_status := FND_API.g_ret_sts_error;
938: END IF;
939:

Line 937: x_return_status := FND_API.g_ret_sts_error;

933:
934: -- Check for required paramter ACCESS_TYPE.
935: IF p_partner_access_rec.access_type = FND_API.g_miss_char OR p_partner_access_rec.access_type IS NULL THEN
936: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'ACCESS_TYPE' );
937: x_return_status := FND_API.g_ret_sts_error;
938: END IF;
939:
940: ELSE
941:

Line 943: IF p_partner_access_rec.partner_access_id = FND_API.G_MISS_NUM THEN

939:
940: ELSE
941:
942: -- Check for PARTNER_ACCESS_ID in case of Update only.
943: IF p_partner_access_rec.partner_access_id = FND_API.G_MISS_NUM THEN
944: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ACCESS_ID' );
945: x_return_status := FND_API.g_ret_sts_error;
946: END IF;
947:

Line 945: x_return_status := FND_API.g_ret_sts_error;

941:
942: -- Check for PARTNER_ACCESS_ID in case of Update only.
943: IF p_partner_access_rec.partner_access_id = FND_API.G_MISS_NUM THEN
944: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ACCESS_ID' );
945: x_return_status := FND_API.g_ret_sts_error;
946: END IF;
947:
948: -- Check for required paramter PARTNER_ID.
949: IF p_partner_access_rec.partner_id = FND_API.G_MISS_NUM THEN

Line 949: IF p_partner_access_rec.partner_id = FND_API.G_MISS_NUM THEN

945: x_return_status := FND_API.g_ret_sts_error;
946: END IF;
947:
948: -- Check for required paramter PARTNER_ID.
949: IF p_partner_access_rec.partner_id = FND_API.G_MISS_NUM THEN
950: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );
951: x_return_status := FND_API.g_ret_sts_error;
952: END IF;
953:

Line 951: x_return_status := FND_API.g_ret_sts_error;

947:
948: -- Check for required paramter PARTNER_ID.
949: IF p_partner_access_rec.partner_id = FND_API.G_MISS_NUM THEN
950: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );
951: x_return_status := FND_API.g_ret_sts_error;
952: END IF;
953:
954: -- Check for required paramter RESOURCE_ID.
955: IF p_partner_access_rec.resource_id = FND_API.G_MISS_NUM THEN

Line 955: IF p_partner_access_rec.resource_id = FND_API.G_MISS_NUM THEN

951: x_return_status := FND_API.g_ret_sts_error;
952: END IF;
953:
954: -- Check for required paramter RESOURCE_ID.
955: IF p_partner_access_rec.resource_id = FND_API.G_MISS_NUM THEN
956: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'RESOURCE_ID' );
957: x_return_status := FND_API.g_ret_sts_error;
958: END IF;
959:

Line 957: x_return_status := FND_API.g_ret_sts_error;

953:
954: -- Check for required paramter RESOURCE_ID.
955: IF p_partner_access_rec.resource_id = FND_API.G_MISS_NUM THEN
956: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'RESOURCE_ID' );
957: x_return_status := FND_API.g_ret_sts_error;
958: END IF;
959:
960: -- Check for required paramter KEEP_FLAG.
961: IF p_partner_access_rec.keep_flag = FND_API.g_miss_char THEN

Line 961: IF p_partner_access_rec.keep_flag = FND_API.g_miss_char THEN

957: x_return_status := FND_API.g_ret_sts_error;
958: END IF;
959:
960: -- Check for required paramter KEEP_FLAG.
961: IF p_partner_access_rec.keep_flag = FND_API.g_miss_char THEN
962: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'KEEP_FLAG' );
963: x_return_status := FND_API.g_ret_sts_error;
964: END IF;
965:

Line 963: x_return_status := FND_API.g_ret_sts_error;

959:
960: -- Check for required paramter KEEP_FLAG.
961: IF p_partner_access_rec.keep_flag = FND_API.g_miss_char THEN
962: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'KEEP_FLAG' );
963: x_return_status := FND_API.g_ret_sts_error;
964: END IF;
965:
966: -- Check for required paramter CREATED_BY_TAP_FLAG.
967: IF p_partner_access_rec.created_by_tap_flag = FND_API.g_miss_char THEN

Line 967: IF p_partner_access_rec.created_by_tap_flag = FND_API.g_miss_char THEN

963: x_return_status := FND_API.g_ret_sts_error;
964: END IF;
965:
966: -- Check for required paramter CREATED_BY_TAP_FLAG.
967: IF p_partner_access_rec.created_by_tap_flag = FND_API.g_miss_char THEN
968: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'CREATED_BY_TAP_FLAG' );
969: x_return_status := FND_API.g_ret_sts_error;
970: END IF;
971:

Line 969: x_return_status := FND_API.g_ret_sts_error;

965:
966: -- Check for required paramter CREATED_BY_TAP_FLAG.
967: IF p_partner_access_rec.created_by_tap_flag = FND_API.g_miss_char THEN
968: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'CREATED_BY_TAP_FLAG' );
969: x_return_status := FND_API.g_ret_sts_error;
970: END IF;
971:
972: -- Check for required paramter ACCESS_TYPE.
973: IF p_partner_access_rec.access_type = FND_API.g_miss_char THEN

Line 973: IF p_partner_access_rec.access_type = FND_API.g_miss_char THEN

969: x_return_status := FND_API.g_ret_sts_error;
970: END IF;
971:
972: -- Check for required paramter ACCESS_TYPE.
973: IF p_partner_access_rec.access_type = FND_API.g_miss_char THEN
974: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'ACCESS_TYPE' );
975: x_return_status := FND_API.g_ret_sts_error;
976: END IF;
977: END IF;

Line 975: x_return_status := FND_API.g_ret_sts_error;

971:
972: -- Check for required paramter ACCESS_TYPE.
973: IF p_partner_access_rec.access_type = FND_API.g_miss_char THEN
974: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'ACCESS_TYPE' );
975: x_return_status := FND_API.g_ret_sts_error;
976: END IF;
977: END IF;
978:
979: END chk_partner_access_Req_Items;

Line 1005: x_return_status := FND_API.g_ret_sts_success;

1001: l_partner_active VARCHAR2(1) := 'N';
1002: l_resource_active VARCHAR2(1) := 'N';
1003:
1004: BEGIN
1005: x_return_status := FND_API.g_ret_sts_success;
1006:
1007: -- check, the supplied partner is an ACTIVE partner.
1008: OPEN l_chk_partner_active_csr(p_partner_access_rec.partner_id);
1009: FETCH l_chk_partner_active_csr INTO l_partner_active;

Line 1014: x_return_status := FND_API.g_ret_sts_error;

1010:
1011: IF l_chk_partner_active_csr%NOTFOUND THEN
1012: CLOSE l_chk_partner_active_csr ;
1013: PVX_UTILITY_PVT.Error_Message('PV_PARTNER_NOT_ACTIVE');
1014: x_return_status := FND_API.g_ret_sts_error;
1015: ELSE
1016: CLOSE l_chk_partner_active_csr ;
1017: END IF;
1018:

Line 1026: x_return_status := FND_API.g_ret_sts_error;

1022:
1023: IF l_chk_resource_active_csr%NOTFOUND THEN
1024: CLOSE l_chk_resource_active_csr ;
1025: PVX_UTILITY_PVT.Error_Message('PV_INVALID_RESOURCE_ID');
1026: x_return_status := FND_API.g_ret_sts_error;
1027: ELSE
1028: CLOSE l_chk_resource_active_csr ;
1029: END IF;
1030:

Line 1042: l_return_status := FND_API.g_ret_sts_success;

1038: IS
1039: l_return_status VARCHAR2(1);
1040: BEGIN
1041:
1042: l_return_status := FND_API.g_ret_sts_success;
1043: -- Check Items Uniqueness API calls
1044:
1045: chk_Partner_Access_Uk_Items(
1046: p_partner_access_rec => p_partner_access_rec,

Line 1049: IF x_return_status <> FND_API.g_ret_sts_success THEN

1045: chk_Partner_Access_Uk_Items(
1046: p_partner_access_rec => p_partner_access_rec,
1047: p_validation_mode => p_validation_mode,
1048: x_return_status => x_return_status);
1049: IF x_return_status <> FND_API.g_ret_sts_success THEN
1050: l_return_status := FND_API.g_ret_sts_error;
1051: END IF;
1052:
1053: -- Check Items Required/NOT NULL API calls

Line 1050: l_return_status := FND_API.g_ret_sts_error;

1046: p_partner_access_rec => p_partner_access_rec,
1047: p_validation_mode => p_validation_mode,
1048: x_return_status => x_return_status);
1049: IF x_return_status <> FND_API.g_ret_sts_success THEN
1050: l_return_status := FND_API.g_ret_sts_error;
1051: END IF;
1052:
1053: -- Check Items Required/NOT NULL API calls
1054:

Line 1059: IF x_return_status <> FND_API.g_ret_sts_success THEN

1055: chk_partner_access_req_items(
1056: p_partner_access_rec => p_partner_access_rec,
1057: p_validation_mode => p_validation_mode,
1058: x_return_status => x_return_status);
1059: IF x_return_status <> FND_API.g_ret_sts_success THEN
1060: l_return_status := FND_API.g_ret_sts_error;
1061: END IF;
1062: -- Check Items Foreign Keys API calls
1063:

Line 1060: l_return_status := FND_API.g_ret_sts_error;

1056: p_partner_access_rec => p_partner_access_rec,
1057: p_validation_mode => p_validation_mode,
1058: x_return_status => x_return_status);
1059: IF x_return_status <> FND_API.g_ret_sts_success THEN
1060: l_return_status := FND_API.g_ret_sts_error;
1061: END IF;
1062: -- Check Items Foreign Keys API calls
1063:
1064: chk_partner_access_FK_items(

Line 1067: IF x_return_status <> FND_API.g_ret_sts_success THEN

1063:
1064: chk_partner_access_FK_items(
1065: p_partner_access_rec => p_partner_access_rec,
1066: x_return_status => x_return_status);
1067: IF x_return_status <> FND_API.g_ret_sts_success THEN
1068: l_return_status := FND_API.g_ret_sts_error;
1069: END IF;
1070:
1071: -- Check Items Lookups

Line 1068: l_return_status := FND_API.g_ret_sts_error;

1064: chk_partner_access_FK_items(
1065: p_partner_access_rec => p_partner_access_rec,
1066: x_return_status => x_return_status);
1067: IF x_return_status <> FND_API.g_ret_sts_success THEN
1068: l_return_status := FND_API.g_ret_sts_error;
1069: END IF;
1070:
1071: -- Check Items Lookups
1072: x_return_status := l_return_status;

Line 1263: IF p_partner_access_rec.keep_flag IS NULL OR p_partner_access_rec.keep_flag = FND_API.G_MISS_CHAR THEN

1259: IS
1260: l_partner_access_rec partner_access_rec_type := p_partner_access_rec;
1261: BEGIN
1262: -- Some default the setting for different column attributes.
1263: IF p_partner_access_rec.keep_flag IS NULL OR p_partner_access_rec.keep_flag = FND_API.G_MISS_CHAR THEN
1264: l_partner_access_rec.keep_flag := 'Y' ;
1265: END IF ;
1266:
1267: IF p_partner_access_rec.created_by_tap_flag IS NULL OR p_partner_access_rec.created_by_tap_flag = FND_API.G_MISS_CHAR THEN

Line 1267: IF p_partner_access_rec.created_by_tap_flag IS NULL OR p_partner_access_rec.created_by_tap_flag = FND_API.G_MISS_CHAR THEN

1263: IF p_partner_access_rec.keep_flag IS NULL OR p_partner_access_rec.keep_flag = FND_API.G_MISS_CHAR THEN
1264: l_partner_access_rec.keep_flag := 'Y' ;
1265: END IF ;
1266:
1267: IF p_partner_access_rec.created_by_tap_flag IS NULL OR p_partner_access_rec.created_by_tap_flag = FND_API.G_MISS_CHAR THEN
1268: l_partner_access_rec.keep_flag := 'Y' ;
1269: END IF ;
1270:
1271: IF p_partner_access_rec.access_type IS NULL OR p_partner_access_rec.access_type = FND_API.G_MISS_CHAR THEN

Line 1271: IF p_partner_access_rec.access_type IS NULL OR p_partner_access_rec.access_type = FND_API.G_MISS_CHAR THEN

1267: IF p_partner_access_rec.created_by_tap_flag IS NULL OR p_partner_access_rec.created_by_tap_flag = FND_API.G_MISS_CHAR THEN
1268: l_partner_access_rec.keep_flag := 'Y' ;
1269: END IF ;
1270:
1271: IF p_partner_access_rec.access_type IS NULL OR p_partner_access_rec.access_type = FND_API.G_MISS_CHAR THEN
1272: l_partner_access_rec.access_type := 'F' ;
1273: END IF ;
1274:
1275: x_partner_access_rec := l_partner_access_rec;

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

1276: END;
1277:
1278: PROCEDURE Validate_Partner_Accesses(
1279: p_api_version_number IN NUMBER,
1280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1282: p_partner_access_rec IN partner_access_rec_type,
1283: p_validation_mode IN VARCHAR2,
1284: x_return_status OUT NOCOPY VARCHAR2,

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

1277:
1278: PROCEDURE Validate_Partner_Accesses(
1279: p_api_version_number IN NUMBER,
1280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1282: p_partner_access_rec IN partner_access_rec_type,
1283: p_validation_mode IN VARCHAR2,
1284: x_return_status OUT NOCOPY VARCHAR2,
1285: x_msg_count OUT NOCOPY NUMBER,

Line 1300: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1296: -- Standard Start of API savepoint
1297: SAVEPOINT validate_partner_accesses;
1298:
1299: -- Standard call to check for call compatibility.
1300: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1301: p_api_version_number,
1302: l_api_name,
1303: G_PKG_NAME)
1304: THEN

Line 1305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1301: p_api_version_number,
1302: l_api_name,
1303: G_PKG_NAME)
1304: THEN
1305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1306: END IF;
1307:
1308: -- Debug Message
1309: IF (PV_DEBUG_HIGH_ON) THEN

Line 1314: IF FND_API.to_Boolean( p_init_msg_list )

1310: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
1311: END IF;
1312:
1313: -- Initialize message list if p_init_msg_list is set to TRUE.
1314: IF FND_API.to_Boolean( p_init_msg_list )
1315: THEN
1316: FND_MSG_PUB.initialize;
1317: END IF;
1318:

Line 1320: x_return_status := FND_API.G_RET_STS_SUCCESS;

1316: FND_MSG_PUB.initialize;
1317: END IF;
1318:
1319: -- Initialize API return status to SUCCESS
1320: x_return_status := FND_API.G_RET_STS_SUCCESS;
1321:
1322: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1323: chk_partner_access_Items(
1324: p_partner_access_rec => p_partner_access_rec,

Line 1329: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1325: p_validation_mode => p_validation_mode,
1326: x_return_status => x_return_status
1327: );
1328:
1329: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1330: RAISE FND_API.G_EXC_ERROR;
1331: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1333: END IF;

Line 1330: RAISE FND_API.G_EXC_ERROR;

1326: x_return_status => x_return_status
1327: );
1328:
1329: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1330: RAISE FND_API.G_EXC_ERROR;
1331: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1333: END IF;
1334: END IF;

Line 1331: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1327: );
1328:
1329: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1330: RAISE FND_API.G_EXC_ERROR;
1331: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1333: END IF;
1334: END IF;
1335:

Line 1332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1328:
1329: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1330: RAISE FND_API.G_EXC_ERROR;
1331: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1333: END IF;
1334: END IF;
1335:
1336: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1350: p_init_msg_list => FND_API.G_FALSE,

1346:
1347: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1348: Validate_partner_access_Rec(
1349: p_api_version_number => 1.0,
1350: p_init_msg_list => FND_API.G_FALSE,
1351: x_return_status => x_return_status,
1352: x_msg_count => x_msg_count,
1353: x_msg_data => x_msg_data,
1354: p_partner_access_rec => l_partner_access_rec);

Line 1356: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1352: x_msg_count => x_msg_count,
1353: x_msg_data => x_msg_data,
1354: p_partner_access_rec => l_partner_access_rec);
1355:
1356: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1357: RAISE FND_API.G_EXC_ERROR;
1358: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1360: END IF;

Line 1357: RAISE FND_API.G_EXC_ERROR;

1353: x_msg_data => x_msg_data,
1354: p_partner_access_rec => l_partner_access_rec);
1355:
1356: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1357: RAISE FND_API.G_EXC_ERROR;
1358: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1360: END IF;
1361: END IF;

Line 1358: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1354: p_partner_access_rec => l_partner_access_rec);
1355:
1356: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1357: RAISE FND_API.G_EXC_ERROR;
1358: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1360: END IF;
1361: END IF;
1362:

Line 1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1355:
1356: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1357: RAISE FND_API.G_EXC_ERROR;
1358: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1360: END IF;
1361: END IF;
1362:
1363:

Line 1377: x_return_status := FND_API.g_ret_sts_error;

1373: p_data => x_msg_data
1374: );
1375: EXCEPTION
1376: WHEN PVX_UTILITY_PVT.resource_locked THEN
1377: x_return_status := FND_API.g_ret_sts_error;
1378: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1379:
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO VALIDATE_Partner_Accesses;

Line 1380: WHEN FND_API.G_EXC_ERROR THEN

1376: WHEN PVX_UTILITY_PVT.resource_locked THEN
1377: x_return_status := FND_API.g_ret_sts_error;
1378: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1379:
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO VALIDATE_Partner_Accesses;
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383:
1384: -- Standard call to get message count and if count=1, get the message

Line 1382: x_return_status := FND_API.G_RET_STS_ERROR;

1378: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1379:
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO VALIDATE_Partner_Accesses;
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383:
1384: -- Standard call to get message count and if count=1, get the message
1385: FND_MSG_PUB.Count_And_Get (
1386: p_encoded => FND_API.G_FALSE,

Line 1386: p_encoded => FND_API.G_FALSE,

1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383:
1384: -- Standard call to get message count and if count=1, get the message
1385: FND_MSG_PUB.Count_And_Get (
1386: p_encoded => FND_API.G_FALSE,
1387: p_count => x_msg_count,
1388: p_data => x_msg_data
1389: );
1390:

Line 1391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1387: p_count => x_msg_count,
1388: p_data => x_msg_data
1389: );
1390:
1391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1392: ROLLBACK TO VALIDATE_Partner_Accesses;
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394:
1395: -- Standard call to get message count and if count=1, get the message

Line 1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1389: );
1390:
1391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1392: ROLLBACK TO VALIDATE_Partner_Accesses;
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394:
1395: -- Standard call to get message count and if count=1, get the message
1396: FND_MSG_PUB.Count_And_Get (
1397: p_encoded => FND_API.G_FALSE,

Line 1397: p_encoded => FND_API.G_FALSE,

1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394:
1395: -- Standard call to get message count and if count=1, get the message
1396: FND_MSG_PUB.Count_And_Get (
1397: p_encoded => FND_API.G_FALSE,
1398: p_count => x_msg_count,
1399: p_data => x_msg_data
1400: );
1401:

Line 1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1400: );
1401:
1402: WHEN OTHERS THEN
1403: ROLLBACK TO VALIDATE_Partner_Accesses;
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405:
1406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1407: THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1413: p_encoded => FND_API.G_FALSE,

1409: END IF;
1410:
1411: -- Standard call to get message count and if count=1, get the message
1412: FND_MSG_PUB.Count_And_Get (
1413: p_encoded => FND_API.G_FALSE,
1414: p_count => x_msg_count,
1415: p_data => x_msg_data
1416: );
1417: End Validate_Partner_Accesses;

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

1418:
1419:
1420: PROCEDURE Validate_Partner_Access_Rec (
1421: p_api_version_number IN NUMBER,
1422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1423: x_return_status OUT NOCOPY VARCHAR2,
1424: x_msg_count OUT NOCOPY NUMBER,
1425: x_msg_data OUT NOCOPY VARCHAR2,
1426: p_partner_access_rec IN partner_access_rec_type

Line 1431: IF FND_API.to_Boolean( p_init_msg_list )

1427: )
1428: IS
1429: BEGIN
1430: -- Initialize message list if p_init_msg_list is set to TRUE.
1431: IF FND_API.to_Boolean( p_init_msg_list )
1432: THEN
1433: FND_MSG_PUB.initialize;
1434: END IF;
1435:

Line 1437: x_return_status := FND_API.G_RET_STS_SUCCESS;

1433: FND_MSG_PUB.initialize;
1434: END IF;
1435:
1436: -- Initialize API return status to SUCCESS
1437: x_return_status := FND_API.G_RET_STS_SUCCESS;
1438:
1439: -- Hint: Validate data
1440: -- If data not valid
1441: -- THEN

Line 1442: -- x_return_status := FND_API.G_RET_STS_ERROR;

1438:
1439: -- Hint: Validate data
1440: -- If data not valid
1441: -- THEN
1442: -- x_return_status := FND_API.G_RET_STS_ERROR;
1443:
1444: -- Validate the FLAG value for KEEP_FLAG and CREATED_BY TAP_FLAG
1445: IF ( p_partner_access_rec.keep_flag <> 'Y' AND p_partner_access_rec.keep_flag <> 'N' ) THEN
1446: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');

Line 1447: x_return_status := FND_API.G_RET_STS_ERROR;

1443:
1444: -- Validate the FLAG value for KEEP_FLAG and CREATED_BY TAP_FLAG
1445: IF ( p_partner_access_rec.keep_flag <> 'Y' AND p_partner_access_rec.keep_flag <> 'N' ) THEN
1446: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: END IF;
1449:
1450: IF ( p_partner_access_rec.CREATED_BY_TAP_FLAG <> 'Y' AND p_partner_access_rec.CREATED_BY_TAP_FLAG <> 'N' ) THEN
1451: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');

Line 1452: x_return_status := FND_API.G_RET_STS_ERROR;

1448: END IF;
1449:
1450: IF ( p_partner_access_rec.CREATED_BY_TAP_FLAG <> 'Y' AND p_partner_access_rec.CREATED_BY_TAP_FLAG <> 'N' ) THEN
1451: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: END IF;
1454:
1455: -- Standard call to get message count and if count is 1, get message info.
1456: FND_MSG_PUB.Count_And_Get