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

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

60: -- Parameters
61: --
62: -- IN
63: -- p_api_version_number IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
65: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
67: -- p_enrl_request_rec IN enrl_request_rec_type Required
68: --

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

61: --
62: -- IN
63: -- p_api_version_number IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
65: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
67: -- p_enrl_request_rec IN enrl_request_rec_type Required
68: --
69: -- OUT

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

62: -- IN
63: -- p_api_version_number IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
65: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
67: -- p_enrl_request_rec IN enrl_request_rec_type Required
68: --
69: -- OUT
70: -- x_return_status OUT VARCHAR2

Line 171: ,p_init_msg_list => FND_API.G_FALSE

167: END IF;
168:
169: PV_Partner_Contracts_PVT.Is_Contract_Exist_Then_Create(
170: p_api_version_number => 1.0
171: ,p_init_msg_list => FND_API.G_FALSE
172: ,x_return_status => x_return_status
173: ,x_msg_count => x_msg_count
174: ,x_msg_data => x_msg_data
175: ,p_partner_id => p_partner_id

Line 187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

183: PVX_UTILITY_PVT.debug_message('x_exist: ' || x_exist);
184: PVX_UTILITY_PVT.debug_message('x_return_status: ' || x_return_status);
185: END IF;
186:
187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
188: RAISE FND_API.G_EXC_ERROR;
189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;

Line 188: RAISE FND_API.G_EXC_ERROR;

184: PVX_UTILITY_PVT.debug_message('x_return_status: ' || x_return_status);
185: END IF;
186:
187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
188: RAISE FND_API.G_EXC_ERROR;
189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:

Line 189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

185: END IF;
186:
187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
188: RAISE FND_API.G_EXC_ERROR;
189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193: FND_MSG_PUB.Count_And_Get

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186:
187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
188: RAISE FND_API.G_EXC_ERROR;
189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193: FND_MSG_PUB.Count_And_Get
194: ( p_encoded => FND_API.G_FALSE,

Line 194: ( p_encoded => FND_API.G_FALSE,

190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193: FND_MSG_PUB.Count_And_Get
194: ( p_encoded => FND_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data
197: );
198:

Line 207: WHEN Fnd_Api.G_EXC_ERROR THEN

203: RETURN x_exist;
204:
205: EXCEPTION
206:
207: WHEN Fnd_Api.G_EXC_ERROR THEN
208: x_return_status := Fnd_Api.G_RET_STS_ERROR;
209:
210: -- Standard call to get message count and if count=1, get the message
211: Fnd_Msg_Pub.Count_And_Get (

Line 208: x_return_status := Fnd_Api.G_RET_STS_ERROR;

204:
205: EXCEPTION
206:
207: WHEN Fnd_Api.G_EXC_ERROR THEN
208: x_return_status := Fnd_Api.G_RET_STS_ERROR;
209:
210: -- Standard call to get message count and if count=1, get the message
211: Fnd_Msg_Pub.Count_And_Get (
212: p_encoded => Fnd_Api.G_FALSE

Line 212: p_encoded => Fnd_Api.G_FALSE

208: x_return_status := Fnd_Api.G_RET_STS_ERROR;
209:
210: -- Standard call to get message count and if count=1, get the message
211: Fnd_Msg_Pub.Count_And_Get (
212: p_encoded => Fnd_Api.G_FALSE
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data
215: );
216:

Line 217: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

213: ,p_count => x_msg_count
214: ,p_data => x_msg_data
215: );
216:
217: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
219: -- Standard call to get message count and if count=1, get the message
220: Fnd_Msg_Pub.Count_And_Get (
221: p_encoded => Fnd_Api.G_FALSE

Line 218: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

214: ,p_data => x_msg_data
215: );
216:
217: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
219: -- Standard call to get message count and if count=1, get the message
220: Fnd_Msg_Pub.Count_And_Get (
221: p_encoded => Fnd_Api.G_FALSE
222: ,p_count => x_msg_count

Line 221: p_encoded => Fnd_Api.G_FALSE

217: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
219: -- Standard call to get message count and if count=1, get the message
220: Fnd_Msg_Pub.Count_And_Get (
221: p_encoded => Fnd_Api.G_FALSE
222: ,p_count => x_msg_count
223: ,p_data => x_msg_data
224: );
225:

Line 227: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

223: ,p_data => x_msg_data
224: );
225:
226: WHEN OTHERS THEN
227: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
228: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name);
231: END IF;

Line 234: p_encoded => Fnd_Api.G_FALSE

230: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name);
231: END IF;
232: -- Standard call to get message count and if count=1, get the message
233: Fnd_Msg_Pub.Count_And_Get (
234: p_encoded => Fnd_Api.G_FALSE
235: ,p_count => x_msg_count
236: ,p_data => x_msg_data
237: );
238:

Line 287: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

283:
284:
285: PROCEDURE Create_Pg_Enrl_Requests(
286: p_api_version_number IN NUMBER,
287: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
288: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
289: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
290:
291: x_return_status OUT NOCOPY VARCHAR2,

Line 288: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

284:
285: PROCEDURE Create_Pg_Enrl_Requests(
286: p_api_version_number IN NUMBER,
287: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
288: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
289: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
290:
291: x_return_status OUT NOCOPY VARCHAR2,
292: x_msg_count OUT NOCOPY NUMBER,

Line 289: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

285: PROCEDURE Create_Pg_Enrl_Requests(
286: p_api_version_number IN NUMBER,
287: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
288: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
289: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
290:
291: x_return_status OUT NOCOPY VARCHAR2,
292: x_msg_count OUT NOCOPY NUMBER,
293: x_msg_data OUT NOCOPY VARCHAR2,

Line 304: l_org_id NUMBER := Fnd_Api.G_MISS_NUM;

300: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Pg_Enrl_Requests';
301: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
302: l_return_status_full VARCHAR2(1);
303: l_object_version_number NUMBER := 1;
304: l_org_id NUMBER := Fnd_Api.G_MISS_NUM;
305: l_enrl_request_id NUMBER;
306: l_custom_setup_id NUMBER;
307: l_score_result_code VARCHAR2(30) := p_enrl_request_rec.score_result_code;
308: l_dummy NUMBER;

Line 323: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,

319: -- Standard Start of API savepoint
320: SAVEPOINT create_pg_enrl_requests_pvt;
321:
322: -- Standard call to check for call compatibility.
323: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
324: p_api_version_number,
325: l_api_name,
326: G_PKG_NAME)
327: THEN

Line 328: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

324: p_api_version_number,
325: l_api_name,
326: G_PKG_NAME)
327: THEN
328: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331:
332: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 333: IF Fnd_Api.to_Boolean( p_init_msg_list )

329: END IF;
330:
331:
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF Fnd_Api.to_Boolean( p_init_msg_list )
334: THEN
335: Fnd_Msg_Pub.initialize;
336: END IF;
337:

Line 349: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

345:
346:
347:
348: -- Initialize API return status to SUCCESS
349: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
350:
351: -- =========================================================================
352: -- Validate Environment
353: -- =========================================================================

Line 359: RAISE Fnd_Api.G_EXC_ERROR;

355: IF Fnd_Global.USER_ID IS NULL
356: THEN
357: FND_MESSAGE.Set_Name ('PV', 'USER_PROFILE_MISSING');
358: FND_MSG_PUB.Add;
359: RAISE Fnd_Api.G_EXC_ERROR;
360: END IF;
361:
362:
363:

Line 364: IF ( P_validation_level >= Fnd_Api.G_VALID_LEVEL_FULL)

360: END IF;
361:
362:
363:
364: IF ( P_validation_level >= Fnd_Api.G_VALID_LEVEL_FULL)
365: THEN
366: -- Debug message
367: IF (PV_DEBUG_HIGH_ON) THEN
368:

Line 375: p_init_msg_list => Fnd_Api.G_FALSE,

371:
372: -- Invoke validation procedures
373: Validate_pg_enrl_requests(
374: p_api_version_number => 1.0,
375: p_init_msg_list => Fnd_Api.G_FALSE,
376: p_validation_level => p_validation_level,
377: p_validation_mode => Jtf_Plsql_Api.g_create,
378: p_enrl_request_rec => p_enrl_request_rec,
379: x_return_status => x_return_status,

Line 384: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data);
382: END IF;
383:
384: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
385: RAISE Fnd_Api.G_EXC_ERROR;
386: END IF;
387:
388: -- Local variable initialization

Line 385: RAISE Fnd_Api.G_EXC_ERROR;

381: x_msg_data => x_msg_data);
382: END IF;
383:
384: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
385: RAISE Fnd_Api.G_EXC_ERROR;
386: END IF;
387:
388: -- Local variable initialization
389:

Line 390: IF p_enrl_request_rec.enrl_request_id IS NULL OR p_enrl_request_rec.enrl_request_id = Fnd_Api.g_miss_num THEN

386: END IF;
387:
388: -- Local variable initialization
389:
390: IF p_enrl_request_rec.enrl_request_id IS NULL OR p_enrl_request_rec.enrl_request_id = Fnd_Api.g_miss_num THEN
391: LOOP
392: l_dummy := NULL;
393: OPEN c_id;
394: FETCH c_id INTO l_enrl_request_id;

Line 468: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

464: p_attribute15 => p_enrl_request_rec.attribute15
465: );
466:
467: x_enrl_request_id := l_enrl_request_id;
468: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
469: RAISE Fnd_Api.G_EXC_ERROR;
470: END IF;
471:
472: -- invoke Create_Gc_Responses_Rec

Line 469: RAISE Fnd_Api.G_EXC_ERROR;

465: );
466:
467: x_enrl_request_id := l_enrl_request_id;
468: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
469: RAISE Fnd_Api.G_EXC_ERROR;
470: END IF;
471:
472: -- invoke Create_Gc_Responses_Rec
473: Pv_Ge_Chklst_Resp_Pvt.Create_Enrq_Responses(

Line 475: p_init_msg_list => Fnd_Api.G_FALSE,

471:
472: -- invoke Create_Gc_Responses_Rec
473: Pv_Ge_Chklst_Resp_Pvt.Create_Enrq_Responses(
474: p_api_version_number => 1.0,
475: p_init_msg_list => Fnd_Api.G_FALSE,
476: p_commit =>Fnd_Api.G_FALSE,
477: p_validation_level => p_validation_level,
478: x_return_status => x_return_status,
479: x_msg_count => x_msg_count,

Line 476: p_commit =>Fnd_Api.G_FALSE,

472: -- invoke Create_Gc_Responses_Rec
473: Pv_Ge_Chklst_Resp_Pvt.Create_Enrq_Responses(
474: p_api_version_number => 1.0,
475: p_init_msg_list => Fnd_Api.G_FALSE,
476: p_commit =>Fnd_Api.G_FALSE,
477: p_validation_level => p_validation_level,
478: x_return_status => x_return_status,
479: x_msg_count => x_msg_count,
480: x_msg_data => x_msg_data,

Line 484: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

480: x_msg_data => x_msg_data,
481: p_programId => p_enrl_request_rec.program_id,
482: p_enrollmentId => l_enrl_request_id);
483:
484: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
485: RAISE Fnd_Api.G_EXC_ERROR;
486: END IF;
487:
488: --

Line 485: RAISE Fnd_Api.G_EXC_ERROR;

481: p_programId => p_enrl_request_rec.program_id,
482: p_enrollmentId => l_enrl_request_id);
483:
484: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
485: RAISE Fnd_Api.G_EXC_ERROR;
486: END IF;
487:
488: --
489: -- End of API body

Line 493: IF Fnd_Api.to_Boolean( p_commit )

489: -- End of API body
490: --
491:
492: -- Standard check for p_commit
493: IF Fnd_Api.to_Boolean( p_commit )
494: THEN
495: COMMIT WORK;
496: END IF;
497:

Line 514: x_return_status := Fnd_Api.g_ret_sts_error;

510: );
511: EXCEPTION
512:
513: WHEN Pvx_Utility_Pvt.resource_locked THEN
514: x_return_status := Fnd_Api.g_ret_sts_error;
515: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
516: FND_MSG_PUB.Add;
517:
518: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 518: WHEN Fnd_Api.G_EXC_ERROR THEN

514: x_return_status := Fnd_Api.g_ret_sts_error;
515: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
516: FND_MSG_PUB.Add;
517:
518: WHEN Fnd_Api.G_EXC_ERROR THEN
519: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
520: x_return_status := Fnd_Api.G_RET_STS_ERROR;
521: -- Standard call to get message count and if count=1, get the message
522: Fnd_Msg_Pub.Count_And_Get (

Line 520: x_return_status := Fnd_Api.G_RET_STS_ERROR;

516: FND_MSG_PUB.Add;
517:
518: WHEN Fnd_Api.G_EXC_ERROR THEN
519: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
520: x_return_status := Fnd_Api.G_RET_STS_ERROR;
521: -- Standard call to get message count and if count=1, get the message
522: Fnd_Msg_Pub.Count_And_Get (
523: p_encoded => Fnd_Api.G_FALSE,
524: p_count => x_msg_count,

Line 523: p_encoded => Fnd_Api.G_FALSE,

519: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
520: x_return_status := Fnd_Api.G_RET_STS_ERROR;
521: -- Standard call to get message count and if count=1, get the message
522: Fnd_Msg_Pub.Count_And_Get (
523: p_encoded => Fnd_Api.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data
526: );
527:

Line 528: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

524: p_count => x_msg_count,
525: p_data => x_msg_data
526: );
527:
528: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
529: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
530: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
531: -- Standard call to get message count and if count=1, get the message
532: Fnd_Msg_Pub.Count_And_Get (

Line 530: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

526: );
527:
528: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
529: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
530: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
531: -- Standard call to get message count and if count=1, get the message
532: Fnd_Msg_Pub.Count_And_Get (
533: p_encoded => Fnd_Api.G_FALSE,
534: p_count => x_msg_count,

Line 533: p_encoded => Fnd_Api.G_FALSE,

529: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
530: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
531: -- Standard call to get message count and if count=1, get the message
532: Fnd_Msg_Pub.Count_And_Get (
533: p_encoded => Fnd_Api.G_FALSE,
534: p_count => x_msg_count,
535: p_data => x_msg_data
536: );
537:

Line 540: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

536: );
537:
538: WHEN OTHERS THEN
539: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
540: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
541: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
542: THEN
543: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
544: END IF;

Line 547: p_encoded => Fnd_Api.G_FALSE,

543: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
544: END IF;
545: -- Standard call to get message count and if count=1, get the message
546: Fnd_Msg_Pub.Count_And_Get (
547: p_encoded => Fnd_Api.G_FALSE,
548: p_count => x_msg_count,
549: p_data => x_msg_data
550: );
551: END Create_Pg_Enrl_Requests;

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

563: -- Parameters
564: --
565: -- IN
566: -- p_api_version_number IN NUMBER Required
567: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
568: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
569: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
570: -- p_enrl_request_rec IN enrl_request_rec_type Required
571: --

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

564: --
565: -- IN
566: -- p_api_version_number IN NUMBER Required
567: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
568: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
569: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
570: -- p_enrl_request_rec IN enrl_request_rec_type Required
571: --
572: -- OUT

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

565: -- IN
566: -- p_api_version_number IN NUMBER Required
567: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
568: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
569: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
570: -- p_enrl_request_rec IN enrl_request_rec_type Required
571: --
572: -- OUT
573: -- x_return_status OUT VARCHAR2

Line 589: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

585: -- ==============================================================================
586:
587: PROCEDURE Update_Pg_Enrl_Requests(
588: p_api_version_number IN NUMBER,
589: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
590: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
591: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
592:
593: x_return_status OUT NOCOPY VARCHAR2,

Line 590: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

586:
587: PROCEDURE Update_Pg_Enrl_Requests(
588: p_api_version_number IN NUMBER,
589: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
590: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
591: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
592:
593: x_return_status OUT NOCOPY VARCHAR2,
594: x_msg_count OUT NOCOPY NUMBER,

Line 591: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

587: PROCEDURE Update_Pg_Enrl_Requests(
588: p_api_version_number IN NUMBER,
589: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
590: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
591: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
592:
593: x_return_status OUT NOCOPY VARCHAR2,
594: x_msg_count OUT NOCOPY NUMBER,
595: x_msg_data OUT NOCOPY VARCHAR2,

Line 624: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,

620: -- Standard Start of API savepoint
621: SAVEPOINT update_pg_enrl_requests_pvt;
622:
623: -- Standard call to check for call compatibility.
624: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
625: p_api_version_number,
626: l_api_name,
627: G_PKG_NAME)
628: THEN

Line 629: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

625: p_api_version_number,
626: l_api_name,
627: G_PKG_NAME)
628: THEN
629: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631:
632:
633: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 634: IF Fnd_Api.to_Boolean( p_init_msg_list )

630: END IF;
631:
632:
633: -- Initialize message list if p_init_msg_list is set to TRUE.
634: IF Fnd_Api.to_Boolean( p_init_msg_list )
635: THEN
636: Fnd_Msg_Pub.initialize;
637: END IF;
638:

Line 650: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

646:
647:
648:
649: -- Initialize API return status to SUCCESS
650: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
651:
652: -- Debug Message
653: IF (PV_DEBUG_HIGH_ON) THEN
654:

Line 666: RAISE Fnd_Api.G_EXC_ERROR;

662: IF ( c_get_Pg_Enrl_Requests%NOTFOUND) THEN
663: FND_MESSAGE.Set_Name ('PV', 'API_MISSING_UPDATE_TARGET');
664: FND_MESSAGE.Set_Token('INFO', 'Pg_Enrl_Requests');
665: FND_MSG_PUB.Add;
666: RAISE Fnd_Api.G_EXC_ERROR;
667: END IF;
668: -- Debug Message
669: IF (PV_DEBUG_HIGH_ON) THEN
670:

Line 677: l_tar_enrl_request_rec.object_version_number = Fnd_Api.G_MISS_NUM ) THEN

673: CLOSE c_get_Pg_Enrl_Requests;
674:
675:
676: IF (l_tar_enrl_request_rec.object_version_number IS NULL OR
677: l_tar_enrl_request_rec.object_version_number = Fnd_Api.G_MISS_NUM ) THEN
678: FND_MESSAGE.Set_Name ('PV', 'API_VERSION_MISSING');
679: FND_MESSAGE.Set_Token('INFO', 'Pg_Enrl_Requests');
680: FND_MSG_PUB.Add;
681: RAISE Fnd_Api.G_EXC_ERROR;

Line 681: RAISE Fnd_Api.G_EXC_ERROR;

677: l_tar_enrl_request_rec.object_version_number = Fnd_Api.G_MISS_NUM ) THEN
678: FND_MESSAGE.Set_Name ('PV', 'API_VERSION_MISSING');
679: FND_MESSAGE.Set_Token('INFO', 'Pg_Enrl_Requests');
680: FND_MSG_PUB.Add;
681: RAISE Fnd_Api.G_EXC_ERROR;
682: END IF;
683: -- Check Whether record has been changed by someone else
684: IF (l_tar_enrl_request_rec.object_version_number <> l_ref_enrl_request_rec.object_version_number) THEN
685: FND_MESSAGE.Set_Name ('PV', 'API_RECORD_CHANGED');

Line 688: RAISE Fnd_Api.G_EXC_ERROR;

684: IF (l_tar_enrl_request_rec.object_version_number <> l_ref_enrl_request_rec.object_version_number) THEN
685: FND_MESSAGE.Set_Name ('PV', 'API_RECORD_CHANGED');
686: FND_MESSAGE.Set_Token('INFO', 'Pg_Enrl_Requests');
687: FND_MSG_PUB.Add;
688: RAISE Fnd_Api.G_EXC_ERROR;
689: END IF;
690:
691:
692: IF ( P_validation_level >= Fnd_Api.G_VALID_LEVEL_FULL)

Line 692: IF ( P_validation_level >= Fnd_Api.G_VALID_LEVEL_FULL)

688: RAISE Fnd_Api.G_EXC_ERROR;
689: END IF;
690:
691:
692: IF ( P_validation_level >= Fnd_Api.G_VALID_LEVEL_FULL)
693: THEN
694: -- Debug message
695: IF (PV_DEBUG_HIGH_ON) THEN
696:

Line 703: p_init_msg_list => Fnd_Api.G_FALSE,

699:
700: -- Invoke validation procedures
701: Validate_pg_enrl_requests(
702: p_api_version_number => 1.0,
703: p_init_msg_list => Fnd_Api.G_FALSE,
704: p_validation_level => p_validation_level,
705: p_validation_mode => Jtf_Plsql_Api.g_update,
706: p_enrl_request_rec => p_enrl_request_rec,
707: x_return_status => x_return_status,

Line 712: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

708: x_msg_count => x_msg_count,
709: x_msg_data => x_msg_data);
710: END IF;
711:
712: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
713: RAISE Fnd_Api.G_EXC_ERROR;
714: END IF;
715:
716:

Line 713: RAISE Fnd_Api.G_EXC_ERROR;

709: x_msg_data => x_msg_data);
710: END IF;
711:
712: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
713: RAISE Fnd_Api.G_EXC_ERROR;
714: END IF;
715:
716:
717: -- Debug Message

Line 726: RAISE FND_API.G_EXC_ERROR;

722:
723: IF p_enrl_request_rec.tentative_end_date is not null and ( p_enrl_request_rec.tentative_start_date>p_enrl_request_rec.tentative_end_date ) THEN
724: FND_MESSAGE.set_name('PV', 'PV_END_DATE_SMALL_START_DATE');
725: FND_MSG_PUB.add;
726: RAISE FND_API.G_EXC_ERROR;
727: END IF;
728:
729: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Update_Row)
730: Pv_Pg_Enrl_Requests_Pkg.Update_Row(

Line 779: IF Fnd_Api.to_Boolean( p_commit )

775: -- End of API body.
776: --
777:
778: -- Standard check for p_commit
779: IF Fnd_Api.to_Boolean( p_commit )
780: THEN
781: COMMIT WORK;
782: END IF;
783:

Line 799: x_return_status := Fnd_Api.G_RET_STS_ERROR;

795: p_data => x_msg_data
796: );
797: EXCEPTION
798: WHEN PVX_Utility_PVT.API_RECORD_CHANGED THEN
799: x_return_status := Fnd_Api.G_RET_STS_ERROR;
800: IF (PV_DEBUG_HIGH_ON) THEN
801: Pvx_Utility_Pvt.debug_message('PRIVATE API: - OPEN CURSOR');
802: END IF;
803: OPEN c_get_Pg_Enrl_Requests( l_tar_enrl_request_rec.enrl_request_id);

Line 816: x_return_status := Fnd_Api.G_RET_STS_ERROR;

812: Pvx_Utility_Pvt.debug_message('PRIVATE API: - CLOSE CURSOR');
813: END IF;
814: CLOSE c_get_Pg_Enrl_Requests;
815: IF (l_tar_enrl_request_rec.object_version_number <> l_ref_enrl_request_rec.object_version_number) THEN
816: x_return_status := Fnd_Api.G_RET_STS_ERROR;
817: FND_MESSAGE.Set_Name ('PV', 'API_RECORD_CHANGED');
818: FND_MESSAGE.Set_Token('INFO', 'Pv_Pg_Enrl_Requests');
819: FND_MSG_PUB.Add;
820: END IF;

Line 822: p_encoded => Fnd_Api.G_FALSE,

818: FND_MESSAGE.Set_Token('INFO', 'Pv_Pg_Enrl_Requests');
819: FND_MSG_PUB.Add;
820: END IF;
821: Fnd_Msg_Pub.Count_And_Get (
822: p_encoded => Fnd_Api.G_FALSE,
823: p_count => x_msg_count,
824: p_data => x_msg_data
825: );
826:

Line 828: x_return_status := Fnd_Api.g_ret_sts_error;

824: p_data => x_msg_data
825: );
826:
827: WHEN Pvx_Utility_Pvt.resource_locked THEN
828: x_return_status := Fnd_Api.g_ret_sts_error;
829: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
830: FND_MSG_PUB.Add;
831: WHEN Fnd_Api.G_EXC_ERROR THEN
832: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;

Line 831: WHEN Fnd_Api.G_EXC_ERROR THEN

827: WHEN Pvx_Utility_Pvt.resource_locked THEN
828: x_return_status := Fnd_Api.g_ret_sts_error;
829: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
830: FND_MSG_PUB.Add;
831: WHEN Fnd_Api.G_EXC_ERROR THEN
832: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
833: x_return_status := Fnd_Api.G_RET_STS_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: Fnd_Msg_Pub.Count_And_Get (

Line 833: x_return_status := Fnd_Api.G_RET_STS_ERROR;

829: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
830: FND_MSG_PUB.Add;
831: WHEN Fnd_Api.G_EXC_ERROR THEN
832: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
833: x_return_status := Fnd_Api.G_RET_STS_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: Fnd_Msg_Pub.Count_And_Get (
836: p_encoded => Fnd_Api.G_FALSE,
837: p_count => x_msg_count,

Line 836: p_encoded => Fnd_Api.G_FALSE,

832: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
833: x_return_status := Fnd_Api.G_RET_STS_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: Fnd_Msg_Pub.Count_And_Get (
836: p_encoded => Fnd_Api.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );
840:

Line 841: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );
840:
841: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
843: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
844: -- Standard call to get message count and if count=1, get the message
845: Fnd_Msg_Pub.Count_And_Get (

Line 843: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

839: );
840:
841: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
843: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
844: -- Standard call to get message count and if count=1, get the message
845: Fnd_Msg_Pub.Count_And_Get (
846: p_encoded => Fnd_Api.G_FALSE,
847: p_count => x_msg_count,

Line 846: p_encoded => Fnd_Api.G_FALSE,

842: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
843: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
844: -- Standard call to get message count and if count=1, get the message
845: Fnd_Msg_Pub.Count_And_Get (
846: p_encoded => Fnd_Api.G_FALSE,
847: p_count => x_msg_count,
848: p_data => x_msg_data
849: );
850:

Line 853: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

849: );
850:
851: WHEN OTHERS THEN
852: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
853: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
854: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
855: THEN
856: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
857: END IF;

Line 860: p_encoded => Fnd_Api.G_FALSE,

856: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
857: END IF;
858: -- Standard call to get message count and if count=1, get the message
859: Fnd_Msg_Pub.Count_And_Get (
860: p_encoded => Fnd_Api.G_FALSE,
861: p_count => x_msg_count,
862: p_data => x_msg_data
863: );
864: END Update_Pg_Enrl_Requests;

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

876: -- Parameters
877: --
878: -- IN
879: -- p_api_version_number IN NUMBER Required
880: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
881: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
882: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
883: -- p_enrl_request_id IN NUMBER
884: -- p_object_version_number IN NUMBER Optional Default = NULL

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

877: --
878: -- IN
879: -- p_api_version_number IN NUMBER Required
880: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
881: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
882: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
883: -- p_enrl_request_id IN NUMBER
884: -- p_object_version_number IN NUMBER Optional Default = NULL
885: --

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

878: -- IN
879: -- p_api_version_number IN NUMBER Required
880: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
881: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
882: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
883: -- p_enrl_request_id IN NUMBER
884: -- p_object_version_number IN NUMBER Optional Default = NULL
885: --
886: -- OUT

Line 903: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

899: -- ==============================================================================
900:
901: PROCEDURE Delete_Pg_Enrl_Requests(
902: p_api_version_number IN NUMBER,
903: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
904: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
905: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
906: x_return_status OUT NOCOPY VARCHAR2,
907: x_msg_count OUT NOCOPY NUMBER,

Line 904: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

900:
901: PROCEDURE Delete_Pg_Enrl_Requests(
902: p_api_version_number IN NUMBER,
903: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
904: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
905: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
906: x_return_status OUT NOCOPY VARCHAR2,
907: x_msg_count OUT NOCOPY NUMBER,
908: x_msg_data OUT NOCOPY VARCHAR2,

Line 905: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

901: PROCEDURE Delete_Pg_Enrl_Requests(
902: p_api_version_number IN NUMBER,
903: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
904: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
905: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
906: x_return_status OUT NOCOPY VARCHAR2,
907: x_msg_count OUT NOCOPY NUMBER,
908: x_msg_data OUT NOCOPY VARCHAR2,
909: p_enrl_request_id IN NUMBER,

Line 923: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,

919: -- Standard Start of API savepoint
920: SAVEPOINT delete_pg_enrl_requests_pvt;
921:
922: -- Standard call to check for call compatibility.
923: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
924: p_api_version_number,
925: l_api_name,
926: G_PKG_NAME)
927: THEN

Line 928: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

924: p_api_version_number,
925: l_api_name,
926: G_PKG_NAME)
927: THEN
928: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
929: END IF;
930:
931:
932: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 933: IF Fnd_Api.to_Boolean( p_init_msg_list )

929: END IF;
930:
931:
932: -- Initialize message list if p_init_msg_list is set to TRUE.
933: IF Fnd_Api.to_Boolean( p_init_msg_list )
934: THEN
935: Fnd_Msg_Pub.initialize;
936: END IF;
937:

Line 949: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

945:
946:
947:
948: -- Initialize API return status to SUCCESS
949: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
950:
951: --
952: -- Api body
953: --

Line 969: IF Fnd_Api.to_Boolean( p_commit )

965: -- End of API body
966: --
967:
968: -- Standard check for p_commit
969: IF Fnd_Api.to_Boolean( p_commit )
970: THEN
971: COMMIT WORK;
972: END IF;
973:

Line 990: x_return_status := Fnd_Api.g_ret_sts_error;

986: );
987: EXCEPTION
988:
989: WHEN Pvx_Utility_Pvt.resource_locked THEN
990: x_return_status := Fnd_Api.g_ret_sts_error;
991: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
992: FND_MSG_PUB.Add;
993:
994: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 994: WHEN Fnd_Api.G_EXC_ERROR THEN

990: x_return_status := Fnd_Api.g_ret_sts_error;
991: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
992: FND_MSG_PUB.Add;
993:
994: WHEN Fnd_Api.G_EXC_ERROR THEN
995: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
996: x_return_status := Fnd_Api.G_RET_STS_ERROR;
997: -- Standard call to get message count and if count=1, get the message
998: Fnd_Msg_Pub.Count_And_Get (

Line 996: x_return_status := Fnd_Api.G_RET_STS_ERROR;

992: FND_MSG_PUB.Add;
993:
994: WHEN Fnd_Api.G_EXC_ERROR THEN
995: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
996: x_return_status := Fnd_Api.G_RET_STS_ERROR;
997: -- Standard call to get message count and if count=1, get the message
998: Fnd_Msg_Pub.Count_And_Get (
999: p_encoded => Fnd_Api.G_FALSE,
1000: p_count => x_msg_count,

Line 999: p_encoded => Fnd_Api.G_FALSE,

995: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
996: x_return_status := Fnd_Api.G_RET_STS_ERROR;
997: -- Standard call to get message count and if count=1, get the message
998: Fnd_Msg_Pub.Count_And_Get (
999: p_encoded => Fnd_Api.G_FALSE,
1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );
1003:

Line 1004: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );
1003:
1004: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1005: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
1006: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1007: -- Standard call to get message count and if count=1, get the message
1008: Fnd_Msg_Pub.Count_And_Get (

Line 1006: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1002: );
1003:
1004: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1005: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
1006: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1007: -- Standard call to get message count and if count=1, get the message
1008: Fnd_Msg_Pub.Count_And_Get (
1009: p_encoded => Fnd_Api.G_FALSE,
1010: p_count => x_msg_count,

Line 1009: p_encoded => Fnd_Api.G_FALSE,

1005: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
1006: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1007: -- Standard call to get message count and if count=1, get the message
1008: Fnd_Msg_Pub.Count_And_Get (
1009: p_encoded => Fnd_Api.G_FALSE,
1010: p_count => x_msg_count,
1011: p_data => x_msg_data
1012: );
1013:

Line 1016: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1012: );
1013:
1014: WHEN OTHERS THEN
1015: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
1016: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1017: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1018: THEN
1019: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1020: END IF;

Line 1023: p_encoded => Fnd_Api.G_FALSE,

1019: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1020: END IF;
1021: -- Standard call to get message count and if count=1, get the message
1022: Fnd_Msg_Pub.Count_And_Get (
1023: p_encoded => Fnd_Api.G_FALSE,
1024: p_count => x_msg_count,
1025: p_data => x_msg_data
1026: );
1027: END Delete_Pg_Enrl_Requests;

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

1041: -- Parameters
1042: --
1043: -- IN
1044: -- p_api_version_number IN NUMBER Required
1045: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1046: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1047: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1048: -- p_enrl_request_rec IN enrl_request_rec_type Required
1049: --

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

1042: --
1043: -- IN
1044: -- p_api_version_number IN NUMBER Required
1045: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1046: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1047: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1048: -- p_enrl_request_rec IN enrl_request_rec_type Required
1049: --
1050: -- OUT

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

1043: -- IN
1044: -- p_api_version_number IN NUMBER Required
1045: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1046: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1047: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1048: -- p_enrl_request_rec IN enrl_request_rec_type Required
1049: --
1050: -- OUT
1051: -- x_return_status OUT VARCHAR2

Line 1067: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

1063: -- ==============================================================================
1064:
1065: PROCEDURE Lock_Pg_Enrl_Requests(
1066: p_api_version_number IN NUMBER,
1067: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1068:
1069: x_return_status OUT NOCOPY VARCHAR2,
1070: x_msg_count OUT NOCOPY NUMBER,
1071: x_msg_data OUT NOCOPY VARCHAR2,

Line 1093: IF Fnd_Api.to_Boolean( p_init_msg_list )

1089: END IF;
1090:
1091:
1092: -- Initialize message list if p_init_msg_list is set to TRUE.
1093: IF Fnd_Api.to_Boolean( p_init_msg_list )
1094: THEN
1095: Fnd_Msg_Pub.initialize;
1096: END IF;
1097:

Line 1101: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,

1097:
1098:
1099:
1100: -- Standard call to check for call compatibility.
1101: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1102: p_api_version_number,
1103: l_api_name,
1104: G_PKG_NAME)
1105: THEN

Line 1106: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1102: p_api_version_number,
1103: l_api_name,
1104: G_PKG_NAME)
1105: THEN
1106: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1107: END IF;
1108:
1109:
1110:

Line 1112: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1108:
1109:
1110:
1111: -- Initialize API return status to SUCCESS
1112: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1113:
1114:
1115: ------------------------ lock -------------------------
1116: Pv_Pg_Enrl_Requests_Pkg.Lock_Row(l_enrl_request_id,p_object_version);

Line 1121: p_encoded => Fnd_Api.g_false,

1117:
1118:
1119: -------------------- finish --------------------------
1120: Fnd_Msg_Pub.count_and_get(
1121: p_encoded => Fnd_Api.g_false,
1122: p_count => x_msg_count,
1123: p_data => x_msg_data);
1124: IF (PV_DEBUG_HIGH_ON) THEN
1125:

Line 1131: x_return_status := Fnd_Api.g_ret_sts_error;

1127: END IF;
1128: EXCEPTION
1129:
1130: WHEN Pvx_Utility_Pvt.resource_locked THEN
1131: x_return_status := Fnd_Api.g_ret_sts_error;
1132: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
1133: FND_MSG_PUB.Add;
1134:
1135: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1135: WHEN Fnd_Api.G_EXC_ERROR THEN

1131: x_return_status := Fnd_Api.g_ret_sts_error;
1132: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
1133: FND_MSG_PUB.Add;
1134:
1135: WHEN Fnd_Api.G_EXC_ERROR THEN
1136: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1137: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: Fnd_Msg_Pub.Count_And_Get (

Line 1137: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1133: FND_MSG_PUB.Add;
1134:
1135: WHEN Fnd_Api.G_EXC_ERROR THEN
1136: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1137: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: Fnd_Msg_Pub.Count_And_Get (
1140: p_encoded => Fnd_Api.G_FALSE,
1141: p_count => x_msg_count,

Line 1140: p_encoded => Fnd_Api.G_FALSE,

1136: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1137: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: Fnd_Msg_Pub.Count_And_Get (
1140: p_encoded => Fnd_Api.G_FALSE,
1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144:

Line 1145: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144:
1145: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1146: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1147: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1148: -- Standard call to get message count and if count=1, get the message
1149: Fnd_Msg_Pub.Count_And_Get (

Line 1147: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1143: );
1144:
1145: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1146: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1147: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1148: -- Standard call to get message count and if count=1, get the message
1149: Fnd_Msg_Pub.Count_And_Get (
1150: p_encoded => Fnd_Api.G_FALSE,
1151: p_count => x_msg_count,

Line 1150: p_encoded => Fnd_Api.G_FALSE,

1146: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1147: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1148: -- Standard call to get message count and if count=1, get the message
1149: Fnd_Msg_Pub.Count_And_Get (
1150: p_encoded => Fnd_Api.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1153: );
1154:

Line 1157: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1153: );
1154:
1155: WHEN OTHERS THEN
1156: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1157: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1158: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1161: END IF;

Line 1164: p_encoded => Fnd_Api.G_FALSE,

1160: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1161: END IF;
1162: -- Standard call to get message count and if count=1, get the message
1163: Fnd_Msg_Pub.Count_And_Get (
1164: p_encoded => Fnd_Api.G_FALSE,
1165: p_count => x_msg_count,
1166: p_data => x_msg_data
1167: );
1168: END Lock_Pg_Enrl_Requests;

Line 1181: x_return_status := Fnd_Api.g_ret_sts_success;

1177: IS
1178: l_valid_flag VARCHAR2(1);
1179:
1180: BEGIN
1181: x_return_status := Fnd_Api.g_ret_sts_success;
1182: IF p_validation_mode = Jtf_Plsql_Api.g_create
1183: AND p_enrl_request_rec.enrl_request_id IS NOT NULL
1184: THEN
1185: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(

Line 1191: IF l_valid_flag = Fnd_Api.g_false THEN

1187: 'enrl_request_id = ''' || p_enrl_request_rec.enrl_request_id ||''''
1188: );
1189: END IF;
1190:
1191: IF l_valid_flag = Fnd_Api.g_false THEN
1192: FND_MESSAGE.Set_Name ('PV', 'PV_enrl_request_id_DUPLICATE');
1193: FND_MSG_PUB.Add;
1194: END IF;
1195:

Line 1207: x_return_status := Fnd_Api.g_ret_sts_success;

1203: x_return_status OUT NOCOPY VARCHAR2
1204: )
1205: IS
1206: BEGIN
1207: x_return_status := Fnd_Api.g_ret_sts_success;
1208:
1209: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
1210:
1211: IF p_enrl_request_rec.program_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.program_id IS NULL THEN

Line 1211: IF p_enrl_request_rec.program_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.program_id IS NULL THEN

1207: x_return_status := Fnd_Api.g_ret_sts_success;
1208:
1209: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
1210:
1211: IF p_enrl_request_rec.program_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.program_id IS NULL THEN
1212: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1213: FND_MESSAGE.Set_Token('MISS_FIELD', 'PROGRAM_ID');
1214: FND_MSG_PUB.Add;
1215:

Line 1216: x_return_status := Fnd_Api.g_ret_sts_error;

1212: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1213: FND_MESSAGE.Set_Token('MISS_FIELD', 'PROGRAM_ID');
1214: FND_MSG_PUB.Add;
1215:
1216: x_return_status := Fnd_Api.g_ret_sts_error;
1217: END IF;
1218:
1219:
1220: IF p_enrl_request_rec.partner_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.partner_id IS NULL THEN

Line 1220: IF p_enrl_request_rec.partner_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.partner_id IS NULL THEN

1216: x_return_status := Fnd_Api.g_ret_sts_error;
1217: END IF;
1218:
1219:
1220: IF p_enrl_request_rec.partner_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.partner_id IS NULL THEN
1221: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1222: FND_MESSAGE.Set_Token('MISS_FIELD', 'PARTNER_ID');
1223: FND_MSG_PUB.Add;
1224: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1224: x_return_status := Fnd_Api.g_ret_sts_error;

1220: IF p_enrl_request_rec.partner_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.partner_id IS NULL THEN
1221: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1222: FND_MESSAGE.Set_Token('MISS_FIELD', 'PARTNER_ID');
1223: FND_MSG_PUB.Add;
1224: x_return_status := Fnd_Api.g_ret_sts_error;
1225: END IF;
1226:
1227: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.requestor_resource_id IS NULL THEN
1228: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');

Line 1227: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.requestor_resource_id IS NULL THEN

1223: FND_MSG_PUB.Add;
1224: x_return_status := Fnd_Api.g_ret_sts_error;
1225: END IF;
1226:
1227: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.requestor_resource_id IS NULL THEN
1228: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1229: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUESTOR_RESOURCE_ID');
1230: FND_MSG_PUB.Add;
1231: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1231: x_return_status := Fnd_Api.g_ret_sts_error;

1227: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.requestor_resource_id IS NULL THEN
1228: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1229: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUESTOR_RESOURCE_ID');
1230: FND_MSG_PUB.Add;
1231: x_return_status := Fnd_Api.g_ret_sts_error;
1232: END IF;
1233:
1234:
1235: IF p_enrl_request_rec.request_status_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.request_status_code IS NULL THEN

Line 1235: IF p_enrl_request_rec.request_status_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.request_status_code IS NULL THEN

1231: x_return_status := Fnd_Api.g_ret_sts_error;
1232: END IF;
1233:
1234:
1235: IF p_enrl_request_rec.request_status_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.request_status_code IS NULL THEN
1236: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1237: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_STATUS_CODE');
1238: FND_MSG_PUB.Add;
1239: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1239: x_return_status := Fnd_Api.g_ret_sts_error;

1235: IF p_enrl_request_rec.request_status_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.request_status_code IS NULL THEN
1236: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1237: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_STATUS_CODE');
1238: FND_MSG_PUB.Add;
1239: x_return_status := Fnd_Api.g_ret_sts_error;
1240: END IF;
1241:
1242:
1243: IF p_enrl_request_rec.enrollment_type_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.enrollment_type_code IS NULL THEN

Line 1243: IF p_enrl_request_rec.enrollment_type_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.enrollment_type_code IS NULL THEN

1239: x_return_status := Fnd_Api.g_ret_sts_error;
1240: END IF;
1241:
1242:
1243: IF p_enrl_request_rec.enrollment_type_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.enrollment_type_code IS NULL THEN
1244: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1245: FND_MESSAGE.Set_Token('MISS_FIELD', 'ENROLLMENT_TYPE_CODE');
1246: FND_MSG_PUB.Add;
1247: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1247: x_return_status := Fnd_Api.g_ret_sts_error;

1243: IF p_enrl_request_rec.enrollment_type_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.enrollment_type_code IS NULL THEN
1244: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1245: FND_MESSAGE.Set_Token('MISS_FIELD', 'ENROLLMENT_TYPE_CODE');
1246: FND_MSG_PUB.Add;
1247: x_return_status := Fnd_Api.g_ret_sts_error;
1248: END IF;
1249:
1250:
1251: IF p_enrl_request_rec.request_initiated_by_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.request_initiated_by_code IS NULL THEN

Line 1251: IF p_enrl_request_rec.request_initiated_by_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.request_initiated_by_code IS NULL THEN

1247: x_return_status := Fnd_Api.g_ret_sts_error;
1248: END IF;
1249:
1250:
1251: IF p_enrl_request_rec.request_initiated_by_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.request_initiated_by_code IS NULL THEN
1252: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1253: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_INITIATED_BY_CODE');
1254: FND_MSG_PUB.Add;
1255: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1255: x_return_status := Fnd_Api.g_ret_sts_error;

1251: IF p_enrl_request_rec.request_initiated_by_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.request_initiated_by_code IS NULL THEN
1252: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1253: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_INITIATED_BY_CODE');
1254: FND_MSG_PUB.Add;
1255: x_return_status := Fnd_Api.g_ret_sts_error;
1256: END IF;
1257:
1258:
1259: ELSE

Line 1262: IF p_enrl_request_rec.enrl_request_id = Fnd_Api.G_MISS_NUM THEN

1258:
1259: ELSE
1260:
1261:
1262: IF p_enrl_request_rec.enrl_request_id = Fnd_Api.G_MISS_NUM THEN
1263: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1264: FND_MESSAGE.Set_Token('MISS_FIELD', 'ENRL_REQUEST_ID');
1265: FND_MSG_PUB.Add;
1266: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1266: x_return_status := Fnd_Api.g_ret_sts_error;

1262: IF p_enrl_request_rec.enrl_request_id = Fnd_Api.G_MISS_NUM THEN
1263: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1264: FND_MESSAGE.Set_Token('MISS_FIELD', 'ENRL_REQUEST_ID');
1265: FND_MSG_PUB.Add;
1266: x_return_status := Fnd_Api.g_ret_sts_error;
1267: END IF;
1268:
1269:
1270: IF p_enrl_request_rec.object_version_number = Fnd_Api.G_MISS_NUM THEN

Line 1270: IF p_enrl_request_rec.object_version_number = Fnd_Api.G_MISS_NUM THEN

1266: x_return_status := Fnd_Api.g_ret_sts_error;
1267: END IF;
1268:
1269:
1270: IF p_enrl_request_rec.object_version_number = Fnd_Api.G_MISS_NUM THEN
1271: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1272: FND_MESSAGE.Set_Token('MISS_FIELD', 'OBJECT_VERSION_NUMBER');
1273: FND_MSG_PUB.Add;
1274: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1274: x_return_status := Fnd_Api.g_ret_sts_error;

1270: IF p_enrl_request_rec.object_version_number = Fnd_Api.G_MISS_NUM THEN
1271: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1272: FND_MESSAGE.Set_Token('MISS_FIELD', 'OBJECT_VERSION_NUMBER');
1273: FND_MSG_PUB.Add;
1274: x_return_status := Fnd_Api.g_ret_sts_error;
1275: END IF;
1276:
1277:
1278: IF p_enrl_request_rec.program_id = Fnd_Api.G_MISS_NUM THEN

Line 1278: IF p_enrl_request_rec.program_id = Fnd_Api.G_MISS_NUM THEN

1274: x_return_status := Fnd_Api.g_ret_sts_error;
1275: END IF;
1276:
1277:
1278: IF p_enrl_request_rec.program_id = Fnd_Api.G_MISS_NUM THEN
1279: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1280: FND_MESSAGE.Set_Token('MISS_FIELD', 'PROGRAM_ID');
1281: FND_MSG_PUB.Add;
1282: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1282: x_return_status := Fnd_Api.g_ret_sts_error;

1278: IF p_enrl_request_rec.program_id = Fnd_Api.G_MISS_NUM THEN
1279: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1280: FND_MESSAGE.Set_Token('MISS_FIELD', 'PROGRAM_ID');
1281: FND_MSG_PUB.Add;
1282: x_return_status := Fnd_Api.g_ret_sts_error;
1283: END IF;
1284:
1285:
1286: IF p_enrl_request_rec.partner_id = Fnd_Api.G_MISS_NUM THEN

Line 1286: IF p_enrl_request_rec.partner_id = Fnd_Api.G_MISS_NUM THEN

1282: x_return_status := Fnd_Api.g_ret_sts_error;
1283: END IF;
1284:
1285:
1286: IF p_enrl_request_rec.partner_id = Fnd_Api.G_MISS_NUM THEN
1287: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1288: FND_MESSAGE.Set_Token('MISS_FIELD', 'PARTNER_ID');
1289: FND_MSG_PUB.Add;
1290: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1290: x_return_status := Fnd_Api.g_ret_sts_error;

1286: IF p_enrl_request_rec.partner_id = Fnd_Api.G_MISS_NUM THEN
1287: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1288: FND_MESSAGE.Set_Token('MISS_FIELD', 'PARTNER_ID');
1289: FND_MSG_PUB.Add;
1290: x_return_status := Fnd_Api.g_ret_sts_error;
1291: END IF;
1292:
1293:
1294: IF p_enrl_request_rec.custom_setup_id = Fnd_Api.G_MISS_NUM THEN

Line 1294: IF p_enrl_request_rec.custom_setup_id = Fnd_Api.G_MISS_NUM THEN

1290: x_return_status := Fnd_Api.g_ret_sts_error;
1291: END IF;
1292:
1293:
1294: IF p_enrl_request_rec.custom_setup_id = Fnd_Api.G_MISS_NUM THEN
1295: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1296: FND_MESSAGE.Set_Token('MISS_FIELD', 'CUSTOM_SETUP_ID');
1297: FND_MSG_PUB.Add;
1298: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1298: x_return_status := Fnd_Api.g_ret_sts_error;

1294: IF p_enrl_request_rec.custom_setup_id = Fnd_Api.G_MISS_NUM THEN
1295: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1296: FND_MESSAGE.Set_Token('MISS_FIELD', 'CUSTOM_SETUP_ID');
1297: FND_MSG_PUB.Add;
1298: x_return_status := Fnd_Api.g_ret_sts_error;
1299: END IF;
1300:
1301:
1302: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM THEN

Line 1302: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM THEN

1298: x_return_status := Fnd_Api.g_ret_sts_error;
1299: END IF;
1300:
1301:
1302: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM THEN
1303: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1304: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUESTOR_RESOURCE_ID');
1305: FND_MSG_PUB.Add;
1306: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1306: x_return_status := Fnd_Api.g_ret_sts_error;

1302: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM THEN
1303: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1304: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUESTOR_RESOURCE_ID');
1305: FND_MSG_PUB.Add;
1306: x_return_status := Fnd_Api.g_ret_sts_error;
1307: END IF;
1308:
1309:
1310: IF p_enrl_request_rec.request_status_code = Fnd_Api.g_miss_char THEN

Line 1310: IF p_enrl_request_rec.request_status_code = Fnd_Api.g_miss_char THEN

1306: x_return_status := Fnd_Api.g_ret_sts_error;
1307: END IF;
1308:
1309:
1310: IF p_enrl_request_rec.request_status_code = Fnd_Api.g_miss_char THEN
1311: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1312: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_STATUS_CODE');
1313: FND_MSG_PUB.Add;
1314: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1314: x_return_status := Fnd_Api.g_ret_sts_error;

1310: IF p_enrl_request_rec.request_status_code = Fnd_Api.g_miss_char THEN
1311: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1312: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_STATUS_CODE');
1313: FND_MSG_PUB.Add;
1314: x_return_status := Fnd_Api.g_ret_sts_error;
1315: END IF;
1316:
1317:
1318: IF p_enrl_request_rec.enrollment_type_code = Fnd_Api.g_miss_char THEN

Line 1318: IF p_enrl_request_rec.enrollment_type_code = Fnd_Api.g_miss_char THEN

1314: x_return_status := Fnd_Api.g_ret_sts_error;
1315: END IF;
1316:
1317:
1318: IF p_enrl_request_rec.enrollment_type_code = Fnd_Api.g_miss_char THEN
1319: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1320: FND_MESSAGE.Set_Token('MISS_FIELD', 'ENROLLMENT_TYPE_CODE');
1321: FND_MSG_PUB.Add;
1322: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1322: x_return_status := Fnd_Api.g_ret_sts_error;

1318: IF p_enrl_request_rec.enrollment_type_code = Fnd_Api.g_miss_char THEN
1319: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1320: FND_MESSAGE.Set_Token('MISS_FIELD', 'ENROLLMENT_TYPE_CODE');
1321: FND_MSG_PUB.Add;
1322: x_return_status := Fnd_Api.g_ret_sts_error;
1323: END IF;
1324:
1325:
1326: IF p_enrl_request_rec.request_initiated_by_code = Fnd_Api.g_miss_char THEN

Line 1326: IF p_enrl_request_rec.request_initiated_by_code = Fnd_Api.g_miss_char THEN

1322: x_return_status := Fnd_Api.g_ret_sts_error;
1323: END IF;
1324:
1325:
1326: IF p_enrl_request_rec.request_initiated_by_code = Fnd_Api.g_miss_char THEN
1327: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1328: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_INITIATED_BY_CODE');
1329: FND_MSG_PUB.Add;
1330: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1330: x_return_status := Fnd_Api.g_ret_sts_error;

1326: IF p_enrl_request_rec.request_initiated_by_code = Fnd_Api.g_miss_char THEN
1327: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1328: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_INITIATED_BY_CODE');
1329: FND_MSG_PUB.Add;
1330: x_return_status := Fnd_Api.g_ret_sts_error;
1331: END IF;
1332: END IF;
1333:
1334: END check_Enrl_Request_Req_Items;

Line 1344: x_return_status := Fnd_Api.g_ret_sts_success;

1340: x_return_status OUT NOCOPY VARCHAR2
1341: )
1342: IS
1343: BEGIN
1344: x_return_status := Fnd_Api.g_ret_sts_success;
1345:
1346: -- Enter custom code here
1347:
1348: END check_Enrl_Request_Fk_Items;

Line 1358: x_return_status := Fnd_Api.g_ret_sts_success;

1354: x_return_status OUT NOCOPY VARCHAR2
1355: )
1356: IS
1357: BEGIN
1358: x_return_status := Fnd_Api.g_ret_sts_success;
1359:
1360: -- Enter custom code here
1361:
1362: END CHECK_ENRL_REQ_LOOKUP_ITEMS;

Line 1375: l_return_status := Fnd_Api.g_ret_sts_success;

1371: IS
1372: l_return_status VARCHAR2(1);
1373: BEGIN
1374:
1375: l_return_status := Fnd_Api.g_ret_sts_success;
1376: -- Check Items Uniqueness API calls
1377:
1378: check_Enrl_request_Uk_Items(
1379: p_enrl_request_rec => p_enrl_request_rec,

Line 1382: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN

1378: check_Enrl_request_Uk_Items(
1379: p_enrl_request_rec => p_enrl_request_rec,
1380: p_validation_mode => p_validation_mode,
1381: x_return_status => x_return_status);
1382: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1383: l_return_status := Fnd_Api.g_ret_sts_error;
1384: END IF;
1385:
1386: -- Check Items Required/NOT NULL API calls

Line 1383: l_return_status := Fnd_Api.g_ret_sts_error;

1379: p_enrl_request_rec => p_enrl_request_rec,
1380: p_validation_mode => p_validation_mode,
1381: x_return_status => x_return_status);
1382: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1383: l_return_status := Fnd_Api.g_ret_sts_error;
1384: END IF;
1385:
1386: -- Check Items Required/NOT NULL API calls
1387:

Line 1392: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN

1388: check_enrl_request_req_items(
1389: p_enrl_request_rec => p_enrl_request_rec,
1390: p_validation_mode => p_validation_mode,
1391: x_return_status => x_return_status);
1392: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1393: l_return_status := Fnd_Api.g_ret_sts_error;
1394: END IF;
1395: -- Check Items Foreign Keys API calls
1396:

Line 1393: l_return_status := Fnd_Api.g_ret_sts_error;

1389: p_enrl_request_rec => p_enrl_request_rec,
1390: p_validation_mode => p_validation_mode,
1391: x_return_status => x_return_status);
1392: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1393: l_return_status := Fnd_Api.g_ret_sts_error;
1394: END IF;
1395: -- Check Items Foreign Keys API calls
1396:
1397: check_enrl_request_FK_items(

Line 1400: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN

1396:
1397: check_enrl_request_FK_items(
1398: p_enrl_request_rec => p_enrl_request_rec,
1399: x_return_status => x_return_status);
1400: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1401: l_return_status := Fnd_Api.g_ret_sts_error;
1402: END IF;
1403: -- Check Items Lookups
1404:

Line 1401: l_return_status := Fnd_Api.g_ret_sts_error;

1397: check_enrl_request_FK_items(
1398: p_enrl_request_rec => p_enrl_request_rec,
1399: x_return_status => x_return_status);
1400: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1401: l_return_status := Fnd_Api.g_ret_sts_error;
1402: END IF;
1403: -- Check Items Lookups
1404:
1405: CHECK_ENRL_REQ_LOOKUP_ITEMS(

Line 1408: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN

1404:
1405: CHECK_ENRL_REQ_LOOKUP_ITEMS(
1406: p_enrl_request_rec => p_enrl_request_rec,
1407: x_return_status => x_return_status);
1408: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1409: l_return_status := Fnd_Api.g_ret_sts_error;
1410: END IF;
1411:
1412: x_return_status := l_return_status;

Line 1409: l_return_status := Fnd_Api.g_ret_sts_error;

1405: CHECK_ENRL_REQ_LOOKUP_ITEMS(
1406: p_enrl_request_rec => p_enrl_request_rec,
1407: x_return_status => x_return_status);
1408: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1409: l_return_status := Fnd_Api.g_ret_sts_error;
1410: END IF;
1411:
1412: x_return_status := l_return_status;
1413:

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

1597: l_enrl_request_rec enrl_request_rec_type := p_enrl_request_rec;
1598: BEGIN
1599: -- Developers should put their code to default the record type
1600: -- e.g. IF p_campaign_rec.status_code IS NULL
1601: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1602: -- l_campaign_rec.status_code := 'NEW' ;
1603: -- END IF ;
1604: --
1605: NULL ;

Line 1613: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

1609:
1610:
1611: PROCEDURE Validate_Pg_Enrl_Requests(
1612: p_api_version_number IN NUMBER,
1613: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1614: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1615: p_enrl_request_rec IN enrl_request_rec_type,
1616: p_validation_mode IN VARCHAR2,
1617: x_return_status OUT NOCOPY VARCHAR2,

Line 1614: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

1610:
1611: PROCEDURE Validate_Pg_Enrl_Requests(
1612: p_api_version_number IN NUMBER,
1613: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1614: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1615: p_enrl_request_rec IN enrl_request_rec_type,
1616: p_validation_mode IN VARCHAR2,
1617: x_return_status OUT NOCOPY VARCHAR2,
1618: x_msg_count OUT NOCOPY NUMBER,

Line 1633: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,

1629: -- Standard Start of API savepoint
1630: SAVEPOINT validate_pg_enrl_requests_;
1631:
1632: -- Standard call to check for call compatibility.
1633: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1634: p_api_version_number,
1635: l_api_name,
1636: G_PKG_NAME)
1637: THEN

Line 1638: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1634: p_api_version_number,
1635: l_api_name,
1636: G_PKG_NAME)
1637: THEN
1638: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1639: END IF;
1640:
1641:
1642: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1643: IF Fnd_Api.to_Boolean( p_init_msg_list )

1639: END IF;
1640:
1641:
1642: -- Initialize message list if p_init_msg_list is set to TRUE.
1643: IF Fnd_Api.to_Boolean( p_init_msg_list )
1644: THEN
1645: Fnd_Msg_Pub.initialize;
1646: END IF;
1647:

Line 1656: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN

1652: p_validation_mode => p_validation_mode,
1653: x_return_status => x_return_status
1654: );
1655:
1656: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1657: RAISE Fnd_Api.G_EXC_ERROR;
1658: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1659: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1660: END IF;

Line 1657: RAISE Fnd_Api.G_EXC_ERROR;

1653: x_return_status => x_return_status
1654: );
1655:
1656: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1657: RAISE Fnd_Api.G_EXC_ERROR;
1658: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1659: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1660: END IF;
1661: END IF;

Line 1658: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

1654: );
1655:
1656: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1657: RAISE Fnd_Api.G_EXC_ERROR;
1658: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1659: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1660: END IF;
1661: END IF;
1662:

Line 1659: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1655:
1656: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1657: RAISE Fnd_Api.G_EXC_ERROR;
1658: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1659: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1660: END IF;
1661: END IF;
1662:
1663: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

Line 1679: p_init_msg_list => Fnd_Api.G_FALSE,

1675:
1676: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1677: Validate_enrl_request_Rec(
1678: p_api_version_number => 1.0,
1679: p_init_msg_list => Fnd_Api.G_FALSE,
1680: x_return_status => x_return_status,
1681: x_msg_count => x_msg_count,
1682: x_msg_data => x_msg_data,
1683: p_enrl_request_rec => l_enrl_request_rec);

Line 1685: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN

1681: x_msg_count => x_msg_count,
1682: x_msg_data => x_msg_data,
1683: p_enrl_request_rec => l_enrl_request_rec);
1684:
1685: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1686: RAISE Fnd_Api.G_EXC_ERROR;
1687: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1688: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1689: END IF;

Line 1686: RAISE Fnd_Api.G_EXC_ERROR;

1682: x_msg_data => x_msg_data,
1683: p_enrl_request_rec => l_enrl_request_rec);
1684:
1685: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1686: RAISE Fnd_Api.G_EXC_ERROR;
1687: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1688: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1689: END IF;
1690: END IF;

Line 1687: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

1683: p_enrl_request_rec => l_enrl_request_rec);
1684:
1685: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1686: RAISE Fnd_Api.G_EXC_ERROR;
1687: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1688: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1689: END IF;
1690: END IF;
1691:

Line 1688: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1684:
1685: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1686: RAISE Fnd_Api.G_EXC_ERROR;
1687: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1688: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1689: END IF;
1690: END IF;
1691:
1692:

Line 1702: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1698:
1699:
1700:
1701: -- Initialize API return status to SUCCESS
1702: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1703:
1704:
1705: -- Debug Message
1706: IF (PV_DEBUG_HIGH_ON) THEN

Line 1720: x_return_status := Fnd_Api.g_ret_sts_error;

1716: );
1717: EXCEPTION
1718:
1719: WHEN Pvx_Utility_Pvt.resource_locked THEN
1720: x_return_status := Fnd_Api.g_ret_sts_error;
1721: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
1722: FND_MSG_PUB.Add;
1723:
1724: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1724: WHEN Fnd_Api.G_EXC_ERROR THEN

1720: x_return_status := Fnd_Api.g_ret_sts_error;
1721: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
1722: FND_MSG_PUB.Add;
1723:
1724: WHEN Fnd_Api.G_EXC_ERROR THEN
1725: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1726: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1727: -- Standard call to get message count and if count=1, get the message
1728: Fnd_Msg_Pub.Count_And_Get (

Line 1726: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1722: FND_MSG_PUB.Add;
1723:
1724: WHEN Fnd_Api.G_EXC_ERROR THEN
1725: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1726: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1727: -- Standard call to get message count and if count=1, get the message
1728: Fnd_Msg_Pub.Count_And_Get (
1729: p_encoded => Fnd_Api.G_FALSE,
1730: p_count => x_msg_count,

Line 1729: p_encoded => Fnd_Api.G_FALSE,

1725: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1726: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1727: -- Standard call to get message count and if count=1, get the message
1728: Fnd_Msg_Pub.Count_And_Get (
1729: p_encoded => Fnd_Api.G_FALSE,
1730: p_count => x_msg_count,
1731: p_data => x_msg_data
1732: );
1733:

Line 1734: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1730: p_count => x_msg_count,
1731: p_data => x_msg_data
1732: );
1733:
1734: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1735: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1736: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1737: -- Standard call to get message count and if count=1, get the message
1738: Fnd_Msg_Pub.Count_And_Get (

Line 1736: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1732: );
1733:
1734: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1735: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1736: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1737: -- Standard call to get message count and if count=1, get the message
1738: Fnd_Msg_Pub.Count_And_Get (
1739: p_encoded => Fnd_Api.G_FALSE,
1740: p_count => x_msg_count,

Line 1739: p_encoded => Fnd_Api.G_FALSE,

1735: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1736: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1737: -- Standard call to get message count and if count=1, get the message
1738: Fnd_Msg_Pub.Count_And_Get (
1739: p_encoded => Fnd_Api.G_FALSE,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data
1742: );
1743:

Line 1746: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1742: );
1743:
1744: WHEN OTHERS THEN
1745: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1746: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1747: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1748: THEN
1749: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1750: END IF;

Line 1753: p_encoded => Fnd_Api.G_FALSE,

1749: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1750: END IF;
1751: -- Standard call to get message count and if count=1, get the message
1752: Fnd_Msg_Pub.Count_And_Get (
1753: p_encoded => Fnd_Api.G_FALSE,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data
1756: );
1757: END Validate_Pg_Enrl_Requests;

Line 1762: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

1758:
1759:
1760: PROCEDURE Validate_Enrl_Request_Rec (
1761: p_api_version_number IN NUMBER,
1762: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1763: x_return_status OUT NOCOPY VARCHAR2,
1764: x_msg_count OUT NOCOPY NUMBER,
1765: x_msg_data OUT NOCOPY VARCHAR2,
1766: p_enrl_request_rec IN enrl_request_rec_type

Line 1771: IF Fnd_Api.to_Boolean( p_init_msg_list )

1767: )
1768: IS
1769: BEGIN
1770: -- Initialize message list if p_init_msg_list is set to TRUE.
1771: IF Fnd_Api.to_Boolean( p_init_msg_list )
1772: THEN
1773: Fnd_Msg_Pub.initialize;
1774: END IF;
1775:

Line 1779: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1775:
1776:
1777:
1778: -- Initialize API return status to SUCCESS
1779: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1780:
1781: -- Hint: Validate data
1782: -- If data not valid
1783: -- THEN

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

1780:
1781: -- Hint: Validate data
1782: -- If data not valid
1783: -- THEN
1784: -- x_return_status := FND_API.G_RET_STS_ERROR;
1785:
1786: -- Debug Message
1787: IF (PV_DEBUG_HIGH_ON) THEN
1788: