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

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

49: -- Parameters
50: --
51: -- IN
52: -- p_api_version_number IN NUMBER Required
53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
56: -- p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type Required
57: --

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

50: --
51: -- IN
52: -- p_api_version_number IN NUMBER Required
53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
56: -- p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type Required
57: --
58: -- OUT

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

51: -- IN
52: -- p_api_version_number IN NUMBER Required
53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
56: -- p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type Required
57: --
58: -- OUT
59: -- x_return_status OUT VARCHAR2

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

75: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
76:
77: PROCEDURE Create_Ge_Ptnr_Resps(
78: p_api_version_number IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82:
83: x_return_status OUT NOCOPY VARCHAR2,

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

76:
77: PROCEDURE Create_Ge_Ptnr_Resps(
78: p_api_version_number IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82:
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,

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

77: PROCEDURE Create_Ge_Ptnr_Resps(
78: p_api_version_number IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82:
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,

Line 96: l_org_id NUMBER := FND_API.G_MISS_NUM;

92: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Ge_Ptnr_Resps';
93: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
94: l_return_status_full VARCHAR2(1);
95: l_object_version_number NUMBER := 1;
96: l_org_id NUMBER := FND_API.G_MISS_NUM;
97: l_ptnr_resp_id NUMBER;
98: l_dummy NUMBER;
99: CURSOR c_id IS
100: SELECT pv_ge_ptnr_resps_s.NEXTVAL

Line 112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

108: -- Standard Start of API savepoint
109: SAVEPOINT create_ge_ptnr_resps_pvt;
110:
111: -- Standard call to check for call compatibility.
112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
113: p_api_version_number,
114: l_api_name,
115: G_PKG_NAME)
116: THEN

Line 117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

113: p_api_version_number,
114: l_api_name,
115: G_PKG_NAME)
116: THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120:
121: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 122: IF FND_API.to_Boolean( p_init_msg_list )

118: END IF;
119:
120:
121: -- Initialize message list if p_init_msg_list is set to TRUE.
122: IF FND_API.to_Boolean( p_init_msg_list )
123: THEN
124: FND_MSG_PUB.initialize;
125: END IF;
126:

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134:
135:
136:
137: -- Initialize API return status to SUCCESS
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: -- =========================================================================
141: -- Validate Environment
142: -- =========================================================================

Line 147: RAISE FND_API.G_EXC_ERROR;

143:
144: IF FND_GLOBAL.USER_ID IS NULL
145: THEN
146: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
149:
150:
151:

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

148: END IF;
149:
150:
151:
152: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
153: THEN
154: -- Debug message
155: IF (PV_DEBUG_HIGH_ON) THEN
156:

Line 163: p_init_msg_list => FND_API.G_FALSE,

159:
160: -- Invoke validation procedures
161: Validate_ge_ptnr_resps(
162: p_api_version_number => 1.0,
163: p_init_msg_list => FND_API.G_FALSE,
164: p_validation_level => p_validation_level,
165: p_validation_mode => JTF_PLSQL_API.g_create,
166: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
167: x_return_status => x_return_status,

Line 172: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

168: x_msg_count => x_msg_count,
169: x_msg_data => x_msg_data);
170: END IF;
171:
172: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:
176: -- Local variable initialization

Line 173: RAISE FND_API.G_EXC_ERROR;

169: x_msg_data => x_msg_data);
170: END IF;
171:
172: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:
176: -- Local variable initialization
177:

Line 178: IF p_ge_ptnr_resps_rec.ptnr_resp_id IS NULL OR p_ge_ptnr_resps_rec.ptnr_resp_id = FND_API.g_miss_num THEN

174: END IF;
175:
176: -- Local variable initialization
177:
178: IF p_ge_ptnr_resps_rec.ptnr_resp_id IS NULL OR p_ge_ptnr_resps_rec.ptnr_resp_id = FND_API.g_miss_num THEN
179: LOOP
180: l_dummy := NULL;
181: OPEN c_id;
182: FETCH c_id INTO l_ptnr_resp_id;

Line 218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

214: p_last_update_login => FND_GLOBAL.conc_login_id
215: );
216:
217: x_ptnr_resp_id := l_ptnr_resp_id;
218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221: --
222: -- End of API body

Line 219: RAISE FND_API.G_EXC_ERROR;

215: );
216:
217: x_ptnr_resp_id := l_ptnr_resp_id;
218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221: --
222: -- End of API body
223: --

Line 226: IF FND_API.to_Boolean( p_commit )

222: -- End of API body
223: --
224:
225: -- Standard check for p_commit
226: IF FND_API.to_Boolean( p_commit )
227: THEN
228: COMMIT WORK;
229: END IF;
230:

Line 247: x_return_status := FND_API.g_ret_sts_error;

243: );
244: EXCEPTION
245:
246: WHEN PVX_UTILITY_PVT.resource_locked THEN
247: x_return_status := FND_API.g_ret_sts_error;
248: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
249:
250: WHEN FND_API.G_EXC_ERROR THEN
251: ROLLBACK TO CREATE_Ge_Ptnr_Resps_PVT;

Line 250: WHEN FND_API.G_EXC_ERROR THEN

246: WHEN PVX_UTILITY_PVT.resource_locked THEN
247: x_return_status := FND_API.g_ret_sts_error;
248: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
249:
250: WHEN FND_API.G_EXC_ERROR THEN
251: ROLLBACK TO CREATE_Ge_Ptnr_Resps_PVT;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

248: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
249:
250: WHEN FND_API.G_EXC_ERROR THEN
251: ROLLBACK TO CREATE_Ge_Ptnr_Resps_PVT;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,

Line 255: p_encoded => FND_API.G_FALSE,

251: ROLLBACK TO CREATE_Ge_Ptnr_Resps_PVT;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data
258: );
259:

Line 260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

256: p_count => x_msg_count,
257: p_data => x_msg_data
258: );
259:
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261: ROLLBACK TO CREATE_Ge_Ptnr_Resps_PVT;
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: -- Standard call to get message count and if count=1, get the message
264: FND_MSG_PUB.Count_And_Get (

Line 262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 265: p_encoded => FND_API.G_FALSE,

261: ROLLBACK TO CREATE_Ge_Ptnr_Resps_PVT;
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: -- Standard call to get message count and if count=1, get the message
264: FND_MSG_PUB.Count_And_Get (
265: p_encoded => FND_API.G_FALSE,
266: p_count => x_msg_count,
267: p_data => x_msg_data
268: );
269:

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

268: );
269:
270: WHEN OTHERS THEN
271: ROLLBACK TO CREATE_Ge_Ptnr_Resps_PVT;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
274: THEN
275: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
276: END IF;

Line 279: p_encoded => FND_API.G_FALSE,

275: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
276: END IF;
277: -- Standard call to get message count and if count=1, get the message
278: FND_MSG_PUB.Count_And_Get (
279: p_encoded => FND_API.G_FALSE,
280: p_count => x_msg_count,
281: p_data => x_msg_data
282: );
283: End Create_Ge_Ptnr_Resps;

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

295: -- Parameters
296: --
297: -- IN
298: -- p_api_version_number IN NUMBER Required
299: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
300: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
301: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
302: -- p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type Required
303: --

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

296: --
297: -- IN
298: -- p_api_version_number IN NUMBER Required
299: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
300: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
301: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
302: -- p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type Required
303: --
304: -- OUT

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

297: -- IN
298: -- p_api_version_number IN NUMBER Required
299: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
300: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
301: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
302: -- p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type Required
303: --
304: -- OUT
305: -- x_return_status OUT VARCHAR2

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

317: -- ==============================================================================
318:
319: PROCEDURE Update_Ge_Ptnr_Resps(
320: p_api_version_number IN NUMBER,
321: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
322: p_commit IN VARCHAR2 := FND_API.G_FALSE,
323: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
324:
325: x_return_status OUT NOCOPY VARCHAR2,

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

318:
319: PROCEDURE Update_Ge_Ptnr_Resps(
320: p_api_version_number IN NUMBER,
321: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
322: p_commit IN VARCHAR2 := FND_API.G_FALSE,
323: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
324:
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,

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

319: PROCEDURE Update_Ge_Ptnr_Resps(
320: p_api_version_number IN NUMBER,
321: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
322: p_commit IN VARCHAR2 := FND_API.G_FALSE,
323: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
324:
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,

Line 356: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 366: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 382: x_return_status := FND_API.G_RET_STS_SUCCESS;

378:
379:
380:
381: -- Initialize API return status to SUCCESS
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383:
384: -- Debug Message
385: IF (PV_DEBUG_HIGH_ON) THEN
386:

Line 398: RAISE FND_API.G_EXC_ERROR;

394: If ( c_get_Ge_Ptnr_Resps%NOTFOUND) THEN
395: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
396: p_token_name => 'INFO',
397: p_token_value => 'Ge_Ptnr_Resps') ;
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400: -- Debug Message
401: IF (PV_DEBUG_HIGH_ON) THEN
402:

Line 409: l_tar_ge_ptnr_resps_rec.object_version_number = FND_API.G_MISS_NUM ) Then

405: CLOSE c_get_Ge_Ptnr_Resps;
406:
407:
408: If (l_tar_ge_ptnr_resps_rec.object_version_number is NULL or
409: l_tar_ge_ptnr_resps_rec.object_version_number = FND_API.G_MISS_NUM ) Then
410: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
411: p_token_name => 'COLUMN',
412: p_token_value => 'Last_Update_Date') ;
413: raise FND_API.G_EXC_ERROR;

Line 413: raise FND_API.G_EXC_ERROR;

409: l_tar_ge_ptnr_resps_rec.object_version_number = FND_API.G_MISS_NUM ) Then
410: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
411: p_token_name => 'COLUMN',
412: p_token_value => 'Last_Update_Date') ;
413: raise FND_API.G_EXC_ERROR;
414: End if;
415: -- Check Whether record has been changed by someone else
416: If (l_tar_ge_ptnr_resps_rec.object_version_number <> l_ref_ge_ptnr_resps_rec.object_version_number) Then
417: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 420: raise FND_API.G_EXC_ERROR;

416: If (l_tar_ge_ptnr_resps_rec.object_version_number <> l_ref_ge_ptnr_resps_rec.object_version_number) Then
417: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
418: p_token_name => 'INFO',
419: p_token_value => 'Ge_Ptnr_Resps') ;
420: raise FND_API.G_EXC_ERROR;
421: End if;
422:
423:
424: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

420: raise FND_API.G_EXC_ERROR;
421: End if;
422:
423:
424: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
425: THEN
426: -- Debug message
427: IF (PV_DEBUG_HIGH_ON) THEN
428:

Line 435: p_init_msg_list => FND_API.G_FALSE,

431:
432: -- Invoke validation procedures
433: Validate_ge_ptnr_resps(
434: p_api_version_number => 1.0,
435: p_init_msg_list => FND_API.G_FALSE,
436: p_validation_level => p_validation_level,
437: p_validation_mode => JTF_PLSQL_API.g_update,
438: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
439: x_return_status => x_return_status,

Line 448: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

444:
445: PVX_UTILITY_PVT.debug_message('Private API: x_return_status = ' || x_return_status);
446: END IF;
447:
448: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
449: IF (PV_DEBUG_HIGH_ON) THEN
450:
451: PVX_UTILITY_PVT.debug_message('Private API: x_return_status<>FND_API.G_RET_STS_SUCCESS');
452: END IF;

Line 451: PVX_UTILITY_PVT.debug_message('Private API: x_return_status<>FND_API.G_RET_STS_SUCCESS');

447:
448: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
449: IF (PV_DEBUG_HIGH_ON) THEN
450:
451: PVX_UTILITY_PVT.debug_message('Private API: x_return_status<>FND_API.G_RET_STS_SUCCESS');
452: END IF;
453: RAISE FND_API.G_EXC_ERROR;
454: END IF;
455:

Line 453: RAISE FND_API.G_EXC_ERROR;

449: IF (PV_DEBUG_HIGH_ON) THEN
450:
451: PVX_UTILITY_PVT.debug_message('Private API: x_return_status<>FND_API.G_RET_STS_SUCCESS');
452: END IF;
453: RAISE FND_API.G_EXC_ERROR;
454: END IF;
455:
456:
457: -- Debug Message

Line 482: IF FND_API.to_Boolean( p_commit )

478: -- End of API body.
479: --
480:
481: -- Standard check for p_commit
482: IF FND_API.to_Boolean( p_commit )
483: THEN
484: COMMIT WORK;
485: END IF;
486:

Line 503: x_return_status := FND_API.g_ret_sts_error;

499: );
500: EXCEPTION
501:
502: WHEN PVX_UTILITY_PVT.resource_locked THEN
503: x_return_status := FND_API.g_ret_sts_error;
504: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
505:
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;

Line 506: WHEN FND_API.G_EXC_ERROR THEN

502: WHEN PVX_UTILITY_PVT.resource_locked THEN
503: x_return_status := FND_API.g_ret_sts_error;
504: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
505:
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: -- Standard call to get message count and if count=1, get the message
510: FND_MSG_PUB.Count_And_Get (

Line 508: x_return_status := FND_API.G_RET_STS_ERROR;

504: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
505:
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: -- Standard call to get message count and if count=1, get the message
510: FND_MSG_PUB.Count_And_Get (
511: p_encoded => FND_API.G_FALSE,
512: p_count => x_msg_count,

Line 511: p_encoded => FND_API.G_FALSE,

507: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: -- Standard call to get message count and if count=1, get the message
510: FND_MSG_PUB.Count_And_Get (
511: p_encoded => FND_API.G_FALSE,
512: p_count => x_msg_count,
513: p_data => x_msg_data
514: );
515:

Line 516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

512: p_count => x_msg_count,
513: p_data => x_msg_data
514: );
515:
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: -- Standard call to get message count and if count=1, get the message
520: FND_MSG_PUB.Count_And_Get (

Line 518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

514: );
515:
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: -- Standard call to get message count and if count=1, get the message
520: FND_MSG_PUB.Count_And_Get (
521: p_encoded => FND_API.G_FALSE,
522: p_count => x_msg_count,

Line 521: p_encoded => FND_API.G_FALSE,

517: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: -- Standard call to get message count and if count=1, get the message
520: FND_MSG_PUB.Count_And_Get (
521: p_encoded => FND_API.G_FALSE,
522: p_count => x_msg_count,
523: p_data => x_msg_data
524: );
525:

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

524: );
525:
526: WHEN OTHERS THEN
527: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;

Line 535: p_encoded => FND_API.G_FALSE,

531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data
538: );
539: End Update_Ge_Ptnr_Resps;

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

551: -- Parameters
552: --
553: -- IN
554: -- p_api_version_number IN NUMBER Required
555: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
556: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
557: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
558: -- p_ptnr_resp_id IN NUMBER
559: -- p_object_version_number IN NUMBER Optional Default = NULL

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

552: --
553: -- IN
554: -- p_api_version_number IN NUMBER Required
555: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
556: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
557: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
558: -- p_ptnr_resp_id IN NUMBER
559: -- p_object_version_number IN NUMBER Optional Default = NULL
560: --

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

553: -- IN
554: -- p_api_version_number IN NUMBER Required
555: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
556: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
557: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
558: -- p_ptnr_resp_id IN NUMBER
559: -- p_object_version_number IN NUMBER Optional Default = NULL
560: --
561: -- OUT

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

574: -- ==============================================================================
575:
576: PROCEDURE Delete_Ge_Ptnr_Resps(
577: p_api_version_number IN NUMBER,
578: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
579: p_commit IN VARCHAR2 := FND_API.G_FALSE,
580: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
581: x_return_status OUT NOCOPY VARCHAR2,
582: x_msg_count OUT NOCOPY NUMBER,

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

575:
576: PROCEDURE Delete_Ge_Ptnr_Resps(
577: p_api_version_number IN NUMBER,
578: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
579: p_commit IN VARCHAR2 := FND_API.G_FALSE,
580: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
581: x_return_status OUT NOCOPY VARCHAR2,
582: x_msg_count OUT NOCOPY NUMBER,
583: x_msg_data OUT NOCOPY VARCHAR2,

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

576: PROCEDURE Delete_Ge_Ptnr_Resps(
577: p_api_version_number IN NUMBER,
578: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
579: p_commit IN VARCHAR2 := FND_API.G_FALSE,
580: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
581: x_return_status OUT NOCOPY VARCHAR2,
582: x_msg_count OUT NOCOPY NUMBER,
583: x_msg_data OUT NOCOPY VARCHAR2,
584: p_ptnr_resp_id IN NUMBER,

Line 598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

594: -- Standard Start of API savepoint
595: SAVEPOINT delete_ge_ptnr_resps_pvt;
596:
597: -- Standard call to check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
599: p_api_version_number,
600: l_api_name,
601: G_PKG_NAME)
602: THEN

Line 603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

599: p_api_version_number,
600: l_api_name,
601: G_PKG_NAME)
602: THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606:
607: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 608: IF FND_API.to_Boolean( p_init_msg_list )

604: END IF;
605:
606:
607: -- Initialize message list if p_init_msg_list is set to TRUE.
608: IF FND_API.to_Boolean( p_init_msg_list )
609: THEN
610: FND_MSG_PUB.initialize;
611: END IF;
612:

Line 624: x_return_status := FND_API.G_RET_STS_SUCCESS;

620:
621:
622:
623: -- Initialize API return status to SUCCESS
624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625:
626: --
627: -- Api body
628: --

Line 644: IF FND_API.to_Boolean( p_commit )

640: -- End of API body
641: --
642:
643: -- Standard check for p_commit
644: IF FND_API.to_Boolean( p_commit )
645: THEN
646: COMMIT WORK;
647: END IF;
648:

Line 665: x_return_status := FND_API.g_ret_sts_error;

661: );
662: EXCEPTION
663:
664: WHEN PVX_UTILITY_PVT.resource_locked THEN
665: x_return_status := FND_API.g_ret_sts_error;
666: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
667:
668: WHEN FND_API.G_EXC_ERROR THEN
669: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;

Line 668: WHEN FND_API.G_EXC_ERROR THEN

664: WHEN PVX_UTILITY_PVT.resource_locked THEN
665: x_return_status := FND_API.g_ret_sts_error;
666: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
667:
668: WHEN FND_API.G_EXC_ERROR THEN
669: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: -- Standard call to get message count and if count=1, get the message
672: FND_MSG_PUB.Count_And_Get (

Line 670: x_return_status := FND_API.G_RET_STS_ERROR;

666: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
667:
668: WHEN FND_API.G_EXC_ERROR THEN
669: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: -- Standard call to get message count and if count=1, get the message
672: FND_MSG_PUB.Count_And_Get (
673: p_encoded => FND_API.G_FALSE,
674: p_count => x_msg_count,

Line 673: p_encoded => FND_API.G_FALSE,

669: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: -- Standard call to get message count and if count=1, get the message
672: FND_MSG_PUB.Count_And_Get (
673: p_encoded => FND_API.G_FALSE,
674: p_count => x_msg_count,
675: p_data => x_msg_data
676: );
677:

Line 678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

674: p_count => x_msg_count,
675: p_data => x_msg_data
676: );
677:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (

Line 680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

676: );
677:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,

Line 683: p_encoded => FND_API.G_FALSE,

679: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data
686: );
687:

Line 690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

686: );
687:
688: WHEN OTHERS THEN
689: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
692: THEN
693: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
694: END IF;

Line 697: p_encoded => FND_API.G_FALSE,

693: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
694: END IF;
695: -- Standard call to get message count and if count=1, get the message
696: FND_MSG_PUB.Count_And_Get (
697: p_encoded => FND_API.G_FALSE,
698: p_count => x_msg_count,
699: p_data => x_msg_data
700: );
701: End Delete_Ge_Ptnr_Resps;

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

715: -- Parameters
716: --
717: -- IN
718: -- p_api_version_number IN NUMBER Required
719: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
720: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
721: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
722: -- p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type Required
723: --

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

716: --
717: -- IN
718: -- p_api_version_number IN NUMBER Required
719: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
720: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
721: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
722: -- p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type Required
723: --
724: -- OUT

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

717: -- IN
718: -- p_api_version_number IN NUMBER Required
719: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
720: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
721: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
722: -- p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type Required
723: --
724: -- OUT
725: -- x_return_status OUT VARCHAR2

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

737: -- ==============================================================================
738:
739: PROCEDURE Lock_Ge_Ptnr_Resps(
740: p_api_version_number IN NUMBER,
741: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
742:
743: x_return_status OUT NOCOPY VARCHAR2,
744: x_msg_count OUT NOCOPY NUMBER,
745: x_msg_data OUT NOCOPY VARCHAR2,

Line 767: IF FND_API.to_Boolean( p_init_msg_list )

763: END IF;
764:
765:
766: -- Initialize message list if p_init_msg_list is set to TRUE.
767: IF FND_API.to_Boolean( p_init_msg_list )
768: THEN
769: FND_MSG_PUB.initialize;
770: END IF;
771:

Line 775: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

771:
772:
773:
774: -- Standard call to check for call compatibility.
775: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
776: p_api_version_number,
777: l_api_name,
778: G_PKG_NAME)
779: THEN

Line 780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

776: p_api_version_number,
777: l_api_name,
778: G_PKG_NAME)
779: THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782:
783:
784:

Line 786: x_return_status := FND_API.G_RET_STS_SUCCESS;

782:
783:
784:
785: -- Initialize API return status to SUCCESS
786: x_return_status := FND_API.G_RET_STS_SUCCESS;
787:
788:
789: ------------------------ lock -------------------------
790: Pv_Ge_Ptnr_Resps_Pkg.Lock_Row(l_ptnr_resp_id,p_object_version);

Line 795: p_encoded => FND_API.g_false,

791:
792:
793: -------------------- finish --------------------------
794: FND_MSG_PUB.count_and_get(
795: p_encoded => FND_API.g_false,
796: p_count => x_msg_count,
797: p_data => x_msg_data);
798: IF (PV_DEBUG_HIGH_ON) THEN
799:

Line 805: x_return_status := FND_API.g_ret_sts_error;

801: END IF;
802: EXCEPTION
803:
804: WHEN PVX_UTILITY_PVT.resource_locked THEN
805: x_return_status := FND_API.g_ret_sts_error;
806: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
807:
808: WHEN FND_API.G_EXC_ERROR THEN
809: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;

Line 808: WHEN FND_API.G_EXC_ERROR THEN

804: WHEN PVX_UTILITY_PVT.resource_locked THEN
805: x_return_status := FND_API.g_ret_sts_error;
806: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
807:
808: WHEN FND_API.G_EXC_ERROR THEN
809: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: -- Standard call to get message count and if count=1, get the message
812: FND_MSG_PUB.Count_And_Get (

Line 810: x_return_status := FND_API.G_RET_STS_ERROR;

806: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
807:
808: WHEN FND_API.G_EXC_ERROR THEN
809: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: -- Standard call to get message count and if count=1, get the message
812: FND_MSG_PUB.Count_And_Get (
813: p_encoded => FND_API.G_FALSE,
814: p_count => x_msg_count,

Line 813: p_encoded => FND_API.G_FALSE,

809: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: -- Standard call to get message count and if count=1, get the message
812: FND_MSG_PUB.Count_And_Get (
813: p_encoded => FND_API.G_FALSE,
814: p_count => x_msg_count,
815: p_data => x_msg_data
816: );
817:

Line 818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

814: p_count => x_msg_count,
815: p_data => x_msg_data
816: );
817:
818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
819: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: -- Standard call to get message count and if count=1, get the message
822: FND_MSG_PUB.Count_And_Get (

Line 820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

816: );
817:
818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
819: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: -- Standard call to get message count and if count=1, get the message
822: FND_MSG_PUB.Count_And_Get (
823: p_encoded => FND_API.G_FALSE,
824: p_count => x_msg_count,

Line 823: p_encoded => FND_API.G_FALSE,

819: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: -- Standard call to get message count and if count=1, get the message
822: FND_MSG_PUB.Count_And_Get (
823: p_encoded => FND_API.G_FALSE,
824: p_count => x_msg_count,
825: p_data => x_msg_data
826: );
827:

Line 830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

826: );
827:
828: WHEN OTHERS THEN
829: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
832: THEN
833: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
834: END IF;

Line 837: p_encoded => FND_API.G_FALSE,

833: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
834: END IF;
835: -- Standard call to get message count and if count=1, get the message
836: FND_MSG_PUB.Count_And_Get (
837: p_encoded => FND_API.G_FALSE,
838: p_count => x_msg_count,
839: p_data => x_msg_data
840: );
841: End Lock_Ge_Ptnr_Resps;

Line 854: x_return_status := FND_API.g_ret_sts_success;

850: IS
851: l_valid_flag VARCHAR2(1);
852:
853: BEGIN
854: x_return_status := FND_API.g_ret_sts_success;
855: IF p_validation_mode = JTF_PLSQL_API.g_create
856: AND p_ge_ptnr_resps_rec.ptnr_resp_id IS NOT NULL
857: THEN
858: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

Line 864: IF l_valid_flag = FND_API.g_false THEN

860: 'ptnr_resp_id = ''' || p_ge_ptnr_resps_rec.ptnr_resp_id ||''''
861: );
862: END IF;
863:
864: IF l_valid_flag = FND_API.g_false THEN
865: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_ptnr_resp_id_DUPLICATE');
866: x_return_status := FND_API.g_ret_sts_error;
867: END IF;
868:

Line 866: x_return_status := FND_API.g_ret_sts_error;

862: END IF;
863:
864: IF l_valid_flag = FND_API.g_false THEN
865: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_ptnr_resp_id_DUPLICATE');
866: x_return_status := FND_API.g_ret_sts_error;
867: END IF;
868:
869: IF p_ge_ptnr_resps_rec.PROGRAM_ID is null THEN
870: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

Line 890: IF l_valid_flag = FND_API.g_false THEN

886: ''' AND RESP_TYPE_CODE = ''' || p_ge_ptnr_resps_rec.RESP_TYPE_CODE || ''''
887: );
888: END IF;
889:
890: IF l_valid_flag = FND_API.g_false THEN
891: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_ptnr_resp_id_DUPLICATE');
892: x_return_status := FND_API.g_ret_sts_error;
893: END IF;
894:

Line 892: x_return_status := FND_API.g_ret_sts_error;

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

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: /*

Line 911: IF p_ge_ptnr_resps_rec.ptnr_resp_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.ptnr_resp_id IS NULL THEN

907:
908: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
909:
910: /*
911: IF p_ge_ptnr_resps_rec.ptnr_resp_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.ptnr_resp_id IS NULL THEN
912: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PTNR_RESP_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: /*
911: IF p_ge_ptnr_resps_rec.ptnr_resp_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.ptnr_resp_id IS NULL THEN
912: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PTNR_RESP_ID' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: */
916:
917:

Line 918: IF p_ge_ptnr_resps_rec.user_role_code = FND_API.g_miss_char OR p_ge_ptnr_resps_rec.user_role_code IS NULL THEN

914: END IF;
915: */
916:
917:
918: IF p_ge_ptnr_resps_rec.user_role_code = FND_API.g_miss_char OR p_ge_ptnr_resps_rec.user_role_code IS NULL THEN
919: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_ROLE_CODE' );
920: x_return_status := FND_API.g_ret_sts_error;
921: END IF;
922:

Line 920: x_return_status := FND_API.g_ret_sts_error;

916:
917:
918: IF p_ge_ptnr_resps_rec.user_role_code = FND_API.g_miss_char OR p_ge_ptnr_resps_rec.user_role_code IS NULL THEN
919: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_ROLE_CODE' );
920: x_return_status := FND_API.g_ret_sts_error;
921: END IF;
922:
923: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.responsibility_id IS NULL THEN
924: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );

Line 923: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.responsibility_id IS NULL THEN

919: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_ROLE_CODE' );
920: x_return_status := FND_API.g_ret_sts_error;
921: END IF;
922:
923: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.responsibility_id IS NULL THEN
924: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );
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: END IF;
922:
923: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.responsibility_id IS NULL THEN
924: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );
925: x_return_status := FND_API.g_ret_sts_error;
926: END IF;
927:
928: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.source_resp_map_rule_id IS NULL THEN
929: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );

Line 928: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.source_resp_map_rule_id IS NULL THEN

924: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );
925: x_return_status := FND_API.g_ret_sts_error;
926: END IF;
927:
928: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.source_resp_map_rule_id IS NULL THEN
929: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932:

Line 930: x_return_status := FND_API.g_ret_sts_error;

926: END IF;
927:
928: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.source_resp_map_rule_id IS NULL THEN
929: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932:
933: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char OR p_ge_ptnr_resps_rec.resp_type_code IS NULL THEN
934: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );

Line 933: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char OR p_ge_ptnr_resps_rec.resp_type_code IS NULL THEN

929: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932:
933: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char OR p_ge_ptnr_resps_rec.resp_type_code IS NULL THEN
934: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );
935: x_return_status := FND_API.g_ret_sts_error;
936: END IF;
937:

Line 935: x_return_status := FND_API.g_ret_sts_error;

931: END IF;
932:
933: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char OR p_ge_ptnr_resps_rec.resp_type_code IS NULL THEN
934: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );
935: x_return_status := FND_API.g_ret_sts_error;
936: END IF;
937:
938: ELSE
939:

Line 941: IF p_ge_ptnr_resps_rec.ptnr_resp_id = FND_API.G_MISS_NUM THEN

937:
938: ELSE
939:
940:
941: IF p_ge_ptnr_resps_rec.ptnr_resp_id = FND_API.G_MISS_NUM THEN
942: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PTNR_RESP_ID' );
943: x_return_status := FND_API.g_ret_sts_error;
944: END IF;
945:

Line 943: x_return_status := FND_API.g_ret_sts_error;

939:
940:
941: IF p_ge_ptnr_resps_rec.ptnr_resp_id = FND_API.G_MISS_NUM THEN
942: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PTNR_RESP_ID' );
943: x_return_status := FND_API.g_ret_sts_error;
944: END IF;
945:
946:
947: IF p_ge_ptnr_resps_rec.user_role_code = FND_API.g_miss_char THEN

Line 947: IF p_ge_ptnr_resps_rec.user_role_code = FND_API.g_miss_char THEN

943: x_return_status := FND_API.g_ret_sts_error;
944: END IF;
945:
946:
947: IF p_ge_ptnr_resps_rec.user_role_code = FND_API.g_miss_char THEN
948: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_ROLE_CODE' );
949: x_return_status := FND_API.g_ret_sts_error;
950: END IF;
951:

Line 949: x_return_status := FND_API.g_ret_sts_error;

945:
946:
947: IF p_ge_ptnr_resps_rec.user_role_code = FND_API.g_miss_char THEN
948: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_ROLE_CODE' );
949: x_return_status := FND_API.g_ret_sts_error;
950: END IF;
951:
952:
953: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM THEN

Line 953: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM THEN

949: x_return_status := FND_API.g_ret_sts_error;
950: END IF;
951:
952:
953: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM THEN
954: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );
955: x_return_status := FND_API.g_ret_sts_error;
956: END IF;
957:

Line 955: x_return_status := FND_API.g_ret_sts_error;

951:
952:
953: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM THEN
954: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );
955: x_return_status := FND_API.g_ret_sts_error;
956: END IF;
957:
958: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM THEN
959: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );

Line 958: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM THEN

954: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );
955: x_return_status := FND_API.g_ret_sts_error;
956: END IF;
957:
958: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM THEN
959: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );
960: x_return_status := FND_API.g_ret_sts_error;
961: END IF;
962:

Line 960: x_return_status := FND_API.g_ret_sts_error;

956: END IF;
957:
958: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM THEN
959: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );
960: x_return_status := FND_API.g_ret_sts_error;
961: END IF;
962:
963: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char THEN
964: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );

Line 963: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char THEN

959: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );
960: x_return_status := FND_API.g_ret_sts_error;
961: END IF;
962:
963: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char THEN
964: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );
965: x_return_status := FND_API.g_ret_sts_error;
966: END IF;
967:

Line 965: x_return_status := FND_API.g_ret_sts_error;

961: END IF;
962:
963: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char THEN
964: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );
965: x_return_status := FND_API.g_ret_sts_error;
966: END IF;
967:
968: IF p_ge_ptnr_resps_rec.object_version_number = FND_API.G_MISS_NUM THEN
969: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

Line 968: IF p_ge_ptnr_resps_rec.object_version_number = FND_API.G_MISS_NUM THEN

964: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );
965: x_return_status := FND_API.g_ret_sts_error;
966: END IF;
967:
968: IF p_ge_ptnr_resps_rec.object_version_number = FND_API.G_MISS_NUM THEN
969: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
970: x_return_status := FND_API.g_ret_sts_error;
971: END IF;
972: END IF;

Line 970: x_return_status := FND_API.g_ret_sts_error;

966: END IF;
967:
968: IF p_ge_ptnr_resps_rec.object_version_number = FND_API.G_MISS_NUM THEN
969: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
970: x_return_status := FND_API.g_ret_sts_error;
971: END IF;
972: END IF;
973:
974: END check_Ge_Ptnr_Resps_Req_Items;

Line 984: x_return_status := FND_API.g_ret_sts_success;

980: x_return_status OUT NOCOPY VARCHAR2
981: )
982: IS
983: BEGIN
984: x_return_status := FND_API.g_ret_sts_success;
985:
986: IF (p_ge_ptnr_resps_rec.resp_type_code = 'PROGRAMS') THEN
987: IF PVX_Utility_PVT.check_fk_exists(
988: 'pv_ge_resp_map_rules', -- Parent schema object having the primary key

Line 993: ) = FND_API.g_false THEN

989: 'resp_map_rule_id', -- Column name in the parent object that maps to the fk value
990: p_ge_ptnr_resps_rec.source_resp_map_rule_id, -- Value of fk to be validated against the parent object's pk column
991: PVX_utility_PVT.g_number, -- datatype of fk
992: null
993: ) = FND_API.g_false THEN
994: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
995: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_RESP_MAP_RULE_ID');
996: FND_MSG_PUB.add;
997: END IF;

Line 1006: ) = FND_API.g_false THEN

1002: 'program_benefits_id', -- Column name in the parent object that maps to the fk value
1003: p_ge_ptnr_resps_rec.source_resp_map_rule_id, -- Value of fk to be validated against the parent object's pk column
1004: PVX_utility_PVT.g_number, -- datatype of fk
1005: null
1006: ) = FND_API.g_false THEN
1007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1008: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_RESP_MAP_RULE_ID');
1009: FND_MSG_PUB.add;
1010: END IF;

Line 1022: x_return_status := FND_API.g_ret_sts_success;

1018: x_return_status OUT NOCOPY VARCHAR2
1019: )
1020: IS
1021: BEGIN
1022: x_return_status := FND_API.g_ret_sts_success;
1023:
1024: -- Enter custom code here
1025:
1026: END check_Ge_Ptr_Resp_Lkup_Item;

Line 1037: l_return_status := FND_API.g_ret_sts_success;

1033: IS
1034: l_return_status VARCHAR2(1);
1035: BEGIN
1036:
1037: l_return_status := FND_API.g_ret_sts_success;
1038: -- Check Items Uniqueness API calls
1039: check_Ge_ptnr_resps_Uk_Items(
1040: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
1041: p_validation_mode => p_validation_mode,

Line 1043: IF x_return_status <> FND_API.g_ret_sts_success THEN

1039: check_Ge_ptnr_resps_Uk_Items(
1040: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
1041: p_validation_mode => p_validation_mode,
1042: x_return_status => x_return_status);
1043: IF x_return_status <> FND_API.g_ret_sts_success THEN
1044: l_return_status := FND_API.g_ret_sts_error;
1045: END IF;
1046:
1047: -- Check Items Required/NOT NULL API calls

Line 1044: l_return_status := FND_API.g_ret_sts_error;

1040: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
1041: p_validation_mode => p_validation_mode,
1042: x_return_status => x_return_status);
1043: IF x_return_status <> FND_API.g_ret_sts_success THEN
1044: l_return_status := FND_API.g_ret_sts_error;
1045: END IF;
1046:
1047: -- Check Items Required/NOT NULL API calls
1048: check_ge_ptnr_resps_req_items(

Line 1052: IF x_return_status <> FND_API.g_ret_sts_success THEN

1048: check_ge_ptnr_resps_req_items(
1049: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
1050: p_validation_mode => p_validation_mode,
1051: x_return_status => x_return_status);
1052: IF x_return_status <> FND_API.g_ret_sts_success THEN
1053: l_return_status := FND_API.g_ret_sts_error;
1054: END IF;
1055: -- Check Items Foreign Keys API calls
1056: check_ge_ptnr_resps_FK_items(

Line 1053: l_return_status := FND_API.g_ret_sts_error;

1049: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
1050: p_validation_mode => p_validation_mode,
1051: x_return_status => x_return_status);
1052: IF x_return_status <> FND_API.g_ret_sts_success THEN
1053: l_return_status := FND_API.g_ret_sts_error;
1054: END IF;
1055: -- Check Items Foreign Keys API calls
1056: check_ge_ptnr_resps_FK_items(
1057: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,

Line 1059: IF x_return_status <> FND_API.g_ret_sts_success THEN

1055: -- Check Items Foreign Keys API calls
1056: check_ge_ptnr_resps_FK_items(
1057: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
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 Lookups
1063: check_Ge_Ptr_Resp_Lkup_Item(

Line 1060: l_return_status := FND_API.g_ret_sts_error;

1056: check_ge_ptnr_resps_FK_items(
1057: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
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 Lookups
1063: check_Ge_Ptr_Resp_Lkup_Item(
1064: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,

Line 1066: IF x_return_status <> FND_API.g_ret_sts_success THEN

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

Line 1067: l_return_status := FND_API.g_ret_sts_error;

1063: check_Ge_Ptr_Resp_Lkup_Item(
1064: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
1065: x_return_status => x_return_status);
1066: IF x_return_status <> FND_API.g_ret_sts_success THEN
1067: l_return_status := FND_API.g_ret_sts_error;
1068: END IF;
1069: x_return_status := l_return_status;
1070:
1071: END Check_ge_ptnr_resps_Items;

Line 1174: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN

1170: l_ge_ptnr_resps_rec ge_ptnr_resps_rec_type := p_ge_ptnr_resps_rec;
1171: BEGIN
1172: -- Developers should put their code to default the record type
1173: -- e.g. IF p_campaign_rec.status_code IS NULL
1174: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1175: -- l_campaign_rec.status_code := 'NEW' ;
1176: -- END IF ;
1177: --
1178: NULL ;

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

1182:
1183:
1184: PROCEDURE Validate_Ge_Ptnr_Resps(
1185: p_api_version_number IN NUMBER,
1186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1188: p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type,
1189: p_validation_mode IN VARCHAR2,
1190: x_return_status OUT NOCOPY VARCHAR2,

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

1183:
1184: PROCEDURE Validate_Ge_Ptnr_Resps(
1185: p_api_version_number IN NUMBER,
1186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1188: p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type,
1189: p_validation_mode IN VARCHAR2,
1190: x_return_status OUT NOCOPY VARCHAR2,
1191: x_msg_count OUT NOCOPY NUMBER,

Line 1206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1202: -- Standard Start of API savepoint
1203: SAVEPOINT validate_ge_ptnr_resps_;
1204:
1205: -- Standard call to check for call compatibility.
1206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1207: p_api_version_number,
1208: l_api_name,
1209: G_PKG_NAME)
1210: THEN

Line 1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1207: p_api_version_number,
1208: l_api_name,
1209: G_PKG_NAME)
1210: THEN
1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: END IF;
1213:
1214:
1215: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1216: IF FND_API.to_Boolean( p_init_msg_list )

1212: END IF;
1213:
1214:
1215: -- Initialize message list if p_init_msg_list is set to TRUE.
1216: IF FND_API.to_Boolean( p_init_msg_list )
1217: THEN
1218: FND_MSG_PUB.initialize;
1219: END IF;
1220:

Line 1228: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1224: p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec,
1225: p_validation_mode => p_validation_mode,
1226: x_return_status => x_return_status
1227: );
1228: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1229: RAISE FND_API.G_EXC_ERROR;
1230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1232: END IF;

Line 1229: RAISE FND_API.G_EXC_ERROR;

1225: p_validation_mode => p_validation_mode,
1226: x_return_status => x_return_status
1227: );
1228: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1229: RAISE FND_API.G_EXC_ERROR;
1230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1232: END IF;
1233: END IF;

Line 1230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1226: x_return_status => x_return_status
1227: );
1228: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1229: RAISE FND_API.G_EXC_ERROR;
1230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1232: END IF;
1233: END IF;
1234: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1227: );
1228: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1229: RAISE FND_API.G_EXC_ERROR;
1230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1232: END IF;
1233: END IF;
1234: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1235: Default_Ge_Ptnr_Resps_Items (p_ge_ptnr_resps_rec => p_ge_ptnr_resps_rec ,

Line 1250: p_init_msg_list => FND_API.G_FALSE,

1246:
1247: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1248: Validate_ge_ptnr_resps_Rec(
1249: p_api_version_number => 1.0,
1250: p_init_msg_list => FND_API.G_FALSE,
1251: x_return_status => x_return_status,
1252: x_msg_count => x_msg_count,
1253: x_msg_data => x_msg_data,
1254: p_ge_ptnr_resps_rec => l_ge_ptnr_resps_rec);

Line 1256: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1252: x_msg_count => x_msg_count,
1253: x_msg_data => x_msg_data,
1254: p_ge_ptnr_resps_rec => l_ge_ptnr_resps_rec);
1255:
1256: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: END IF;

Line 1257: RAISE FND_API.G_EXC_ERROR;

1253: x_msg_data => x_msg_data,
1254: p_ge_ptnr_resps_rec => l_ge_ptnr_resps_rec);
1255:
1256: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: END IF;
1261: END IF;

Line 1258: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1254: p_ge_ptnr_resps_rec => l_ge_ptnr_resps_rec);
1255:
1256: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: END IF;
1261: END IF;
1262:

Line 1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1255:
1256: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: END IF;
1261: END IF;
1262:
1263: -- Debug Message

Line 1272: x_return_status := FND_API.G_RET_STS_SUCCESS;

1268:
1269:
1270:
1271: -- Initialize API return status to SUCCESS
1272: x_return_status := FND_API.G_RET_STS_SUCCESS;
1273:
1274:
1275: -- Debug Message
1276: IF (PV_DEBUG_HIGH_ON) THEN

Line 1290: x_return_status := FND_API.g_ret_sts_error;

1286: );
1287: EXCEPTION
1288:
1289: WHEN PVX_UTILITY_PVT.resource_locked THEN
1290: x_return_status := FND_API.g_ret_sts_error;
1291: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1292:
1293: WHEN FND_API.G_EXC_ERROR THEN
1294: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;

Line 1293: WHEN FND_API.G_EXC_ERROR THEN

1289: WHEN PVX_UTILITY_PVT.resource_locked THEN
1290: x_return_status := FND_API.g_ret_sts_error;
1291: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1292:
1293: WHEN FND_API.G_EXC_ERROR THEN
1294: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296: -- Standard call to get message count and if count=1, get the message
1297: FND_MSG_PUB.Count_And_Get (

Line 1295: x_return_status := FND_API.G_RET_STS_ERROR;

1291: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1292:
1293: WHEN FND_API.G_EXC_ERROR THEN
1294: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296: -- Standard call to get message count and if count=1, get the message
1297: FND_MSG_PUB.Count_And_Get (
1298: p_encoded => FND_API.G_FALSE,
1299: p_count => x_msg_count,

Line 1298: p_encoded => FND_API.G_FALSE,

1294: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296: -- Standard call to get message count and if count=1, get the message
1297: FND_MSG_PUB.Count_And_Get (
1298: p_encoded => FND_API.G_FALSE,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );
1302:

Line 1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1299: p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );
1302:
1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1304: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: -- Standard call to get message count and if count=1, get the message
1307: FND_MSG_PUB.Count_And_Get (

Line 1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1301: );
1302:
1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1304: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: -- Standard call to get message count and if count=1, get the message
1307: FND_MSG_PUB.Count_And_Get (
1308: p_encoded => FND_API.G_FALSE,
1309: p_count => x_msg_count,

Line 1308: p_encoded => FND_API.G_FALSE,

1304: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: -- Standard call to get message count and if count=1, get the message
1307: FND_MSG_PUB.Count_And_Get (
1308: p_encoded => FND_API.G_FALSE,
1309: p_count => x_msg_count,
1310: p_data => x_msg_data
1311: );
1312:

Line 1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1311: );
1312:
1313: WHEN OTHERS THEN
1314: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1317: THEN
1318: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1319: END IF;

Line 1322: p_encoded => FND_API.G_FALSE,

1318: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1319: END IF;
1320: -- Standard call to get message count and if count=1, get the message
1321: FND_MSG_PUB.Count_And_Get (
1322: p_encoded => FND_API.G_FALSE,
1323: p_count => x_msg_count,
1324: p_data => x_msg_data
1325: );
1326: End Validate_Ge_Ptnr_Resps;

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

1327:
1328:
1329: PROCEDURE Validate_Ge_Ptnr_Resps_Rec (
1330: p_api_version_number IN NUMBER,
1331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1332: x_return_status OUT NOCOPY VARCHAR2,
1333: x_msg_count OUT NOCOPY NUMBER,
1334: x_msg_data OUT NOCOPY VARCHAR2,
1335: p_ge_ptnr_resps_rec IN ge_ptnr_resps_rec_type

Line 1340: IF FND_API.to_Boolean( p_init_msg_list )

1336: )
1337: IS
1338: BEGIN
1339: -- Initialize message list if p_init_msg_list is set to TRUE.
1340: IF FND_API.to_Boolean( p_init_msg_list )
1341: THEN
1342: FND_MSG_PUB.initialize;
1343: END IF;
1344:

Line 1348: x_return_status := FND_API.G_RET_STS_SUCCESS;

1344:
1345:
1346:
1347: -- Initialize API return status to SUCCESS
1348: x_return_status := FND_API.G_RET_STS_SUCCESS;
1349:
1350: -- Hint: Validate data
1351: -- If data not valid
1352: -- THEN

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

1349:
1350: -- Hint: Validate data
1351: -- If data not valid
1352: -- THEN
1353: -- x_return_status := FND_API.G_RET_STS_ERROR;
1354:
1355: -- Debug Message
1356: IF (PV_DEBUG_HIGH_ON) THEN
1357: