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

Line 65: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,

61: -- Standard Start of API savepoint
62: SAVEPOINT ADDTOCART_PUB;
63:
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
66: p_api_version,
67: l_api_name,
68: g_pkg_name ) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
66: p_api_version,
67: l_api_name,
68: g_pkg_name ) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

Line 73: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
74: FND_MSG_PUB.INITIALIZE;
75: END IF;
76:
77: -- Initialize API return status to success

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74: FND_MSG_PUB.INITIALIZE;
75: END IF;
76:
77: -- Initialize API return status to success
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79:
80: --Invoke the procedure add_to_cart_waitlist by passing the relevant parameters.
81: --Parameter p_action should be 'CART' .
82: --The invoke source parameter should have 'IVR' as the input.

Line 101: p_init_msg_list => FND_API.G_FALSE,

97: ROLLBACK TO ADDTOCART_PUB;
98: igs_en_gen_017.enrp_msg_string_to_list (
99: p_message_string => l_message_data,
100: p_delimiter => ';',
101: p_init_msg_list => FND_API.G_FALSE,
102: x_message_count => l_message_count,
103: x_message_data => l_message_data);
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: x_msg_data := l_message_data;

Line 104: x_return_status := FND_API.G_RET_STS_ERROR;

100: p_delimiter => ';',
101: p_init_msg_list => FND_API.G_FALSE,
102: x_message_count => l_message_count,
103: x_message_data => l_message_data);
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: x_msg_data := l_message_data;
106: x_msg_count := l_message_count;
107: ELSE
108: IF FND_API.TO_BOOLEAN( p_commit ) THEN

Line 108: IF FND_API.TO_BOOLEAN( p_commit ) THEN

104: x_return_status := FND_API.G_RET_STS_ERROR;
105: x_msg_data := l_message_data;
106: x_msg_count := l_message_count;
107: ELSE
108: IF FND_API.TO_BOOLEAN( p_commit ) THEN
109: COMMIT WORK;
110: END IF;
111: END IF;
112:

Line 114: WHEN FND_API.G_EXC_ERROR THEN

110: END IF;
111: END IF;
112:
113: EXCEPTION
114: WHEN FND_API.G_EXC_ERROR THEN
115: ROLLBACK TO ADDTOCART_PUB;
116: x_return_status := FND_API.G_RET_STS_ERROR ;
117: FND_MSG_PUB.COUNT_AND_GET (
118: p_count => x_msg_count,

Line 116: x_return_status := FND_API.G_RET_STS_ERROR ;

112:
113: EXCEPTION
114: WHEN FND_API.G_EXC_ERROR THEN
115: ROLLBACK TO ADDTOCART_PUB;
116: x_return_status := FND_API.G_RET_STS_ERROR ;
117: FND_MSG_PUB.COUNT_AND_GET (
118: p_count => x_msg_count,
119: p_data => x_msg_data );
120:

Line 121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

117: FND_MSG_PUB.COUNT_AND_GET (
118: p_count => x_msg_count,
119: p_data => x_msg_data );
120:
121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
122: ROLLBACK TO ADDTOCART_PUB;
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124: FND_MSG_PUB.COUNT_AND_GET (
125: p_count => x_msg_count,

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

119: p_data => x_msg_data );
120:
121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
122: ROLLBACK TO ADDTOCART_PUB;
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124: FND_MSG_PUB.COUNT_AND_GET (
125: p_count => x_msg_count,
126: p_data => x_msg_data );
127:

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

126: p_data => x_msg_data );
127:
128: WHEN OTHERS THEN
129: ROLLBACK TO ADDTOCART_PUB;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
133: FND_MSG_PUB.ADD;
134: FND_MSG_PUB.COUNT_AND_GET (

Line 202: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,

198:
199: SAVEPOINT ENROL_CART_PUB;
200:
201: -- Standard call to check for call compatibility.
202: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
203: p_api_version,
204: l_api_name,
205: g_pkg_name ) THEN
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

202: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
203: p_api_version,
204: l_api_name,
205: g_pkg_name ) THEN
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF;
208:
209: -- Initialize message list if p_init_msg_list is set to TRUE.
210: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

Line 210: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF;
208:
209: -- Initialize message list if p_init_msg_list is set to TRUE.
210: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
211: FND_MSG_PUB.INITIALIZE;
212: END IF;
213:
214: -- Initialize API return status to success

Line 215: x_return_status := FND_API.G_RET_STS_SUCCESS;

211: FND_MSG_PUB.INITIALIZE;
212: END IF;
213:
214: -- Initialize API return status to success
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216:
217: --Validate the input parameters and if valid, also fetch the internal calculated
218: --values. Pass the Validation level as No Call Number.
219: igs_en_gen_017.enrp_validate_input_parameters(

Line 241: p_init_msg_list => FND_API.G_FALSE,

237: IF l_ret_status = 'FALSE' THEN
238: igs_en_gen_017.enrp_msg_string_to_list (
239: p_message_string => l_message_data,
240: p_delimiter => ';',
241: p_init_msg_list => FND_API.G_FALSE,
242: x_message_count => x_msg_count,
243: x_message_data => x_msg_data);
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: RETURN;

Line 244: x_return_status := FND_API.G_RET_STS_ERROR;

240: p_delimiter => ';',
241: p_init_msg_list => FND_API.G_FALSE,
242: x_message_count => x_msg_count,
243: x_message_data => x_msg_data);
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: RETURN;
246: END IF;
247:
248: l_ret_status := NULL;

Line 270: p_init_msg_list => FND_API.G_FALSE,

266: IF l_step_eval_result = 'FALSE' THEN
267: igs_en_gen_017.enrp_msg_string_to_list (
268: p_message_string => l_error_message,
269: p_delimiter => ';',
270: p_init_msg_list => FND_API.G_FALSE,
271: x_message_count => l_message_count,
272: x_message_data => l_message_data);
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: x_msg_data := l_message_data;

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269: p_delimiter => ';',
270: p_init_msg_list => FND_API.G_FALSE,
271: x_message_count => l_message_count,
272: x_message_data => l_message_data);
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: x_msg_data := l_message_data;
275: x_msg_count := l_message_count;
276: RETURN;
277: END IF;

Line 292: p_init_msg_list => FND_API.G_FALSE,

288: IF l_ret_status = 'FALSE' THEN
289: igs_en_gen_017.enrp_msg_string_to_list (
290: p_message_string => l_error_message,
291: p_delimiter => ';',
292: p_init_msg_list => FND_API.G_FALSE,
293: x_message_count => l_message_count,
294: x_message_data => l_message_data);
295: x_return_status := FND_API.G_RET_STS_ERROR;
296: x_msg_data := l_message_data;

Line 295: x_return_status := FND_API.G_RET_STS_ERROR;

291: p_delimiter => ';',
292: p_init_msg_list => FND_API.G_FALSE,
293: x_message_count => l_message_count,
294: x_message_data => l_message_data);
295: x_return_status := FND_API.G_RET_STS_ERROR;
296: x_msg_data := l_message_data;
297: x_msg_count := l_message_count;
298: RETURN;
299: END IF;

Line 324: p_init_msg_list => FND_API.G_FALSE,

320: IF l_deny_warn = 'DENY' THEN
321: igs_en_gen_017.enrp_msg_string_to_list (
322: p_message_string => l_error_message,
323: p_delimiter => ';',
324: p_init_msg_list => FND_API.G_FALSE,
325: x_message_count => l_message_count,
326: x_message_data => l_message_data);
327:
328: x_return_status := FND_API.G_RET_STS_ERROR;

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

324: p_init_msg_list => FND_API.G_FALSE,
325: x_message_count => l_message_count,
326: x_message_data => l_message_data);
327:
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: x_msg_data := l_message_data;
330: x_msg_count := l_message_count;
331: RETURN;
332: ELSE

Line 369: p_init_msg_list => FND_API.G_FALSE,

365: IF l_ret_status = 'DENY' THEN
366: igs_en_gen_017.enrp_msg_string_to_list (
367: p_message_string => l_message_data,
368: p_delimiter => ';',
369: p_init_msg_list => FND_API.G_FALSE,
370: x_message_count => l_message_count,
371: x_message_data => l_message_data);
372:
373: x_return_status := FND_API.G_RET_STS_ERROR;

Line 373: x_return_status := FND_API.G_RET_STS_ERROR;

369: p_init_msg_list => FND_API.G_FALSE,
370: x_message_count => l_message_count,
371: x_message_data => l_message_data);
372:
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: x_msg_data := l_message_data;
375: x_msg_count := l_message_count;
376: ELSE
377: IF p_commit = FND_API.G_TRUE THEN

Line 377: IF p_commit = FND_API.G_TRUE THEN

373: x_return_status := FND_API.G_RET_STS_ERROR;
374: x_msg_data := l_message_data;
375: x_msg_count := l_message_count;
376: ELSE
377: IF p_commit = FND_API.G_TRUE THEN
378: COMMIT WORK;
379: END IF;
380: END IF;
381:

Line 383: WHEN FND_API.G_EXC_ERROR THEN

379: END IF;
380: END IF;
381:
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO ENROL_CART_PUB;
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: FND_MSG_PUB.COUNT_AND_GET (
387: p_count => x_msg_count,

Line 385: x_return_status := FND_API.G_RET_STS_ERROR ;

381:
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO ENROL_CART_PUB;
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: FND_MSG_PUB.COUNT_AND_GET (
387: p_count => x_msg_count,
388: p_data => x_msg_data );
389:

Line 390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

386: FND_MSG_PUB.COUNT_AND_GET (
387: p_count => x_msg_count,
388: p_data => x_msg_data );
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO ENROL_CART_PUB;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: FND_MSG_PUB.COUNT_AND_GET (
394: p_count => x_msg_count,

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

388: p_data => x_msg_data );
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO ENROL_CART_PUB;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: FND_MSG_PUB.COUNT_AND_GET (
394: p_count => x_msg_count,
395: p_data => x_msg_data );
396:

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

395: p_data => x_msg_data );
396:
397: WHEN OTHERS THEN
398: ROLLBACK TO ENROL_CART_PUB;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
402: FND_MSG_PUB.ADD;
403: FND_MSG_PUB.COUNT_AND_GET (

Line 458: IF NOT FND_API.compatible_api_call(l_api_version,

454: --Standard start of API savepoint
455: SAVEPOINT clean_up_cart;
456:
457: --Standard call to check for call compatibility.
458: IF NOT FND_API.compatible_api_call(l_api_version,
459: p_api_version,
460: l_api_name,
461: G_PKG_NAME) THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

458: IF NOT FND_API.compatible_api_call(l_api_version,
459: p_api_version,
460: l_api_name,
461: G_PKG_NAME) THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;
464:
465: --Initialize message list if p_init_msg_list is set to TRUE.
466: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 466: IF FND_API.to_Boolean(p_init_msg_list) THEN

462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;
464:
465: --Initialize message list if p_init_msg_list is set to TRUE.
466: IF FND_API.to_Boolean(p_init_msg_list) THEN
467: FND_MSG_PUB.initialize;
468: END IF;
469:
470: --Initialize API return status to success.

Line 471: x_return_status := FND_API.G_RET_STS_SUCCESS;

467: FND_MSG_PUB.initialize;
468: END IF;
469:
470: --Initialize API return status to success.
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472: l_return_status := 'TRUE';
473:
474: --
475: -- Main code logic begins

Line 501: p_init_msg_list => FND_API.G_FALSE,

497: -- Add to msg stack
498: igs_en_gen_017.enrp_msg_string_to_list(
499: p_message_string => l_error_message,
500: p_delimiter => ';',
501: p_init_msg_list => FND_API.G_FALSE,
502: x_message_count => l_messaage_count,
503: x_message_data => l_message_data);
504:
505: x_return_status := FND_API.G_RET_STS_ERROR;

Line 505: x_return_status := FND_API.G_RET_STS_ERROR;

501: p_init_msg_list => FND_API.G_FALSE,
502: x_message_count => l_messaage_count,
503: x_message_data => l_message_data);
504:
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: x_msg_count := l_messaage_count;
507: x_msg_data := l_message_data;
508: RETURN;
509: END IF;

Line 517: IF FND_API.to_Boolean(p_commit) THEN

513: igs_en_su_attempt_pkg.delete_row(rec_sua.row_id);
514: END LOOP;
515:
516: --Standard check of p_commit.
517: IF FND_API.to_Boolean(p_commit) THEN
518: commit;
519: END IF;
520:
521: --Standard call to get message count and if count is 1, get message info.

Line 527: WHEN FND_API.G_EXC_ERROR THEN

523: p_count => l_messaage_count,
524: p_data => l_message_data);
525:
526: EXCEPTION
527: WHEN FND_API.G_EXC_ERROR THEN
528: ROLLBACK TO clean_up_cart;
529: x_return_status := FND_API.G_RET_STS_ERROR ;
530: FND_MSG_PUB.COUNT_AND_GET (
531: p_count => x_msg_count,

Line 529: x_return_status := FND_API.G_RET_STS_ERROR ;

525:
526: EXCEPTION
527: WHEN FND_API.G_EXC_ERROR THEN
528: ROLLBACK TO clean_up_cart;
529: x_return_status := FND_API.G_RET_STS_ERROR ;
530: FND_MSG_PUB.COUNT_AND_GET (
531: p_count => x_msg_count,
532: p_data => l_message_data );
533:

Line 534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

530: FND_MSG_PUB.COUNT_AND_GET (
531: p_count => x_msg_count,
532: p_data => l_message_data );
533:
534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
535: ROLLBACK TO clean_up_cart;
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
537: FND_MSG_PUB.COUNT_AND_GET (
538: p_count => x_msg_count,

Line 536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

532: p_data => l_message_data );
533:
534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
535: ROLLBACK TO clean_up_cart;
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
537: FND_MSG_PUB.COUNT_AND_GET (
538: p_count => x_msg_count,
539: p_data => l_message_data );
540:

Line 543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

539: p_data => l_message_data );
540:
541: WHEN OTHERS THEN
542: ROLLBACK TO clean_up_cart;
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
545: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );
546: END IF;
547: FND_MSG_PUB.COUNT_AND_GET (

Line 584: IF NOT FND_API.Compatible_API_Call(l_api_version,

580: --Standard start of API savepoint
581: SAVEPOINT drop_all_section;
582:
583: --Standard call to check for call compatibility.
584: IF NOT FND_API.Compatible_API_Call(l_api_version,
585: p_api_version,
586: l_api_name,
587: G_PKG_NAME) THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

584: IF NOT FND_API.Compatible_API_Call(l_api_version,
585: p_api_version,
586: l_api_name,
587: G_PKG_NAME) THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: --Initialize message list if p_init_msg_list is set to TRUE.
592: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 592: IF FND_API.to_Boolean(p_init_msg_list) THEN

588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: --Initialize message list if p_init_msg_list is set to TRUE.
592: IF FND_API.to_Boolean(p_init_msg_list) THEN
593: FND_MSG_PUB.initialize;
594: END IF;
595:
596: --Initialize API return status to success.

Line 597: x_return_status := FND_API.G_RET_STS_SUCCESS;

593: FND_MSG_PUB.initialize;
594: END IF;
595:
596: --Initialize API return status to success.
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598: l_return_status := 'TRUE';
599:
600: -- main code logic begins
601: igs_en_gen_017.drop_section(

Line 617: p_init_msg_list => FND_API.G_FALSE,

613: IF l_return_status = 'FALSE' THEN
614: -- add to msg stack
615: igs_en_gen_017.enrp_msg_string_to_list(
616: p_message_string => l_error_message,
617: p_init_msg_list => FND_API.G_FALSE,
618: x_message_count => l_messaage_count,
619: x_message_data => l_message_data);
620:
621: x_return_status := FND_API.G_RET_STS_ERROR;

Line 621: x_return_status := FND_API.G_RET_STS_ERROR;

617: p_init_msg_list => FND_API.G_FALSE,
618: x_message_count => l_messaage_count,
619: x_message_data => l_message_data);
620:
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: x_msg_count := l_messaage_count;
623: x_msg_data := l_message_data;
624: END IF;
625:

Line 627: IF FND_API.to_Boolean(p_commit) THEN

623: x_msg_data := l_message_data;
624: END IF;
625:
626: --Standard check of p_commit.
627: IF FND_API.to_Boolean(p_commit) THEN
628: commit;
629: END IF;
630:
631: --Standard call to get message count and if count is 1, get message info.

Line 637: WHEN FND_API.G_EXC_ERROR THEN

633: p_count => l_messaage_count,
634: p_data => l_message_data);
635:
636: EXCEPTION
637: WHEN FND_API.G_EXC_ERROR THEN
638: ROLLBACK TO drop_all_section;
639: x_return_status := FND_API.G_RET_STS_ERROR ;
640: FND_MSG_PUB.COUNT_AND_GET (
641: p_count => x_msg_count,

Line 639: x_return_status := FND_API.G_RET_STS_ERROR ;

635:
636: EXCEPTION
637: WHEN FND_API.G_EXC_ERROR THEN
638: ROLLBACK TO drop_all_section;
639: x_return_status := FND_API.G_RET_STS_ERROR ;
640: FND_MSG_PUB.COUNT_AND_GET (
641: p_count => x_msg_count,
642: p_data => l_message_data );
643:

Line 644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

640: FND_MSG_PUB.COUNT_AND_GET (
641: p_count => x_msg_count,
642: p_data => l_message_data );
643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: ROLLBACK TO drop_all_section;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647: FND_MSG_PUB.COUNT_AND_GET (
648: p_count => x_msg_count,

Line 646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

642: p_data => l_message_data );
643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: ROLLBACK TO drop_all_section;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647: FND_MSG_PUB.COUNT_AND_GET (
648: p_count => x_msg_count,
649: p_data => l_message_data );
650:

Line 653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

649: p_data => l_message_data );
650:
651: WHEN OTHERS THEN
652: ROLLBACK TO drop_all_section;
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
654: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
655: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );
656: END IF;
657: FND_MSG_PUB.COUNT_AND_GET (

Line 697: IF NOT FND_API.Compatible_API_Call(l_api_version,

693: --Standard start of API savepoint
694: SAVEPOINT drop_section_by_call_number;
695:
696: --Standard call to check for call compatibility.
697: IF NOT FND_API.Compatible_API_Call(l_api_version,
698: p_api_version,
699: l_api_name,
700: G_PKG_NAME) THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

697: IF NOT FND_API.Compatible_API_Call(l_api_version,
698: p_api_version,
699: l_api_name,
700: G_PKG_NAME) THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703:
704: --Initialize message list if p_init_msg_list is set to TRUE.
705: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 705: IF FND_API.to_Boolean(p_init_msg_list) THEN

701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703:
704: --Initialize message list if p_init_msg_list is set to TRUE.
705: IF FND_API.to_Boolean(p_init_msg_list) THEN
706: FND_MSG_PUB.initialize;
707: END IF;
708:
709: --Initialize API return status to success.

Line 710: x_return_status := FND_API.G_RET_STS_SUCCESS;

706: FND_MSG_PUB.initialize;
707: END IF;
708:
709: --Initialize API return status to success.
710: x_return_status := FND_API.G_RET_STS_SUCCESS;
711: l_return_status := 'TRUE';
712:
713: -- main code logic begins
714: igs_en_gen_017.drop_section(

Line 730: p_init_msg_list => FND_API.G_FALSE,

726: IF l_return_status = 'FALSE' THEN
727: -- add to msg stack
728: igs_en_gen_017.enrp_msg_string_to_list(
729: p_message_string => l_error_message,
730: p_init_msg_list => FND_API.G_FALSE,
731: x_message_count => l_messaage_count,
732: x_message_data => l_message_data
733: );
734: x_msg_count := l_messaage_count;

Line 736: x_return_status := FND_API.G_RET_STS_ERROR;

732: x_message_data => l_message_data
733: );
734: x_msg_count := l_messaage_count;
735: x_msg_data := l_message_data;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: END IF;
738:
739: --Standard check of p_commit.
740: IF FND_API.to_Boolean(p_commit) THEN

Line 740: IF FND_API.to_Boolean(p_commit) THEN

736: x_return_status := FND_API.G_RET_STS_ERROR;
737: END IF;
738:
739: --Standard check of p_commit.
740: IF FND_API.to_Boolean(p_commit) THEN
741: commit;
742: END IF;
743:
744: --Standard call to get message count and if count is 1, get message info.

Line 750: WHEN FND_API.G_EXC_ERROR THEN

746: p_count => l_messaage_count,
747: p_data => l_message_data);
748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_ERROR THEN
751: ROLLBACK TO drop_section_by_call_number;
752: x_return_status := FND_API.G_RET_STS_ERROR ;
753: FND_MSG_PUB.COUNT_AND_GET (
754: p_count => x_msg_count,

Line 752: x_return_status := FND_API.G_RET_STS_ERROR ;

748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_ERROR THEN
751: ROLLBACK TO drop_section_by_call_number;
752: x_return_status := FND_API.G_RET_STS_ERROR ;
753: FND_MSG_PUB.COUNT_AND_GET (
754: p_count => x_msg_count,
755: p_data => l_message_data );
756:

Line 757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

753: FND_MSG_PUB.COUNT_AND_GET (
754: p_count => x_msg_count,
755: p_data => l_message_data );
756:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: ROLLBACK TO drop_section_by_call_number;
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
760: FND_MSG_PUB.COUNT_AND_GET (
761: p_count => x_msg_count,

Line 759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

755: p_data => l_message_data );
756:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: ROLLBACK TO drop_section_by_call_number;
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
760: FND_MSG_PUB.COUNT_AND_GET (
761: p_count => x_msg_count,
762: p_data => l_message_data );
763:

Line 766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

762: p_data => l_message_data );
763:
764: WHEN OTHERS THEN
765: ROLLBACK TO drop_section_by_call_number;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
767: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
768: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );
769: END IF;
770: FND_MSG_PUB.COUNT_AND_GET (

Line 818: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,

814: l_step_eval_result VARCHAR2(6);
815:
816: BEGIN
817: -- Standard call to check for call compatibility.
818: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
819: p_api_version,
820: l_api_name,
821: g_pkg_name ) THEN
822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

818: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
819: p_api_version,
820: l_api_name,
821: g_pkg_name ) THEN
822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
823: END IF;
824:
825: -- Initialize message list if p_init_msg_list is set to TRUE.
826: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

Line 826: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
823: END IF;
824:
825: -- Initialize message list if p_init_msg_list is set to TRUE.
826: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
827: FND_MSG_PUB.INITIALIZE;
828: END IF;
829:
830: -- Initialize API return status to success

Line 831: x_return_status := FND_API.G_RET_STS_SUCCESS;

827: FND_MSG_PUB.INITIALIZE;
828: END IF;
829:
830: -- Initialize API return status to success
831: x_return_status := FND_API.G_RET_STS_SUCCESS;
832:
833: --Validate the input parameters and if valid would also fetch the internal calculated
834: --values. Validation level here is No Call Number.
835: igs_en_gen_017.enrp_validate_input_parameters(

Line 857: p_init_msg_list => FND_API.G_FALSE,

853: IF l_ret_status = 'FALSE' THEN
854: igs_en_gen_017.enrp_msg_string_to_list (
855: p_message_string => l_message_data,
856: p_delimiter => ';',
857: p_init_msg_list => FND_API.G_FALSE,
858: x_message_count => x_msg_count,
859: x_message_data => x_msg_data);
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: ELSE

Line 860: x_return_status := FND_API.G_RET_STS_ERROR;

856: p_delimiter => ';',
857: p_init_msg_list => FND_API.G_FALSE,
858: x_message_count => x_msg_count,
859: x_message_data => x_msg_data);
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: ELSE
862: --If the parameters are valid, then call the below procedure to evaluate Person Steps.
863: igs_ss_en_wrappers.enrp_ss_val_person_step(
864: p_person_id => l_person_id,

Line 882: p_init_msg_list => FND_API.G_FALSE,

878: IF l_step_eval_result = 'FALSE' THEN
879: igs_en_gen_017.enrp_msg_string_to_list (
880: p_message_string => l_message_data,
881: p_delimiter => ';',
882: p_init_msg_list => FND_API.G_FALSE,
883: x_message_count => x_msg_count,
884: x_message_data => x_msg_data);
885: x_return_status := FND_API.G_RET_STS_ERROR;
886:

Line 885: x_return_status := FND_API.G_RET_STS_ERROR;

881: p_delimiter => ';',
882: p_init_msg_list => FND_API.G_FALSE,
883: x_message_count => x_msg_count,
884: x_message_data => x_msg_data);
885: x_return_status := FND_API.G_RET_STS_ERROR;
886:
887: END IF;
888: END IF;
889: IF FND_API.TO_BOOLEAN( p_commit ) THEN

Line 889: IF FND_API.TO_BOOLEAN( p_commit ) THEN

885: x_return_status := FND_API.G_RET_STS_ERROR;
886:
887: END IF;
888: END IF;
889: IF FND_API.TO_BOOLEAN( p_commit ) THEN
890: COMMIT WORK;
891: END IF;
892:
893: EXCEPTION

Line 894: WHEN FND_API.G_EXC_ERROR THEN

890: COMMIT WORK;
891: END IF;
892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_ERROR THEN
895: x_return_status := FND_API.G_RET_STS_ERROR ;
896: FND_MSG_PUB.COUNT_AND_GET (
897: p_count => x_msg_count,
898: p_data => x_msg_data );

Line 895: x_return_status := FND_API.G_RET_STS_ERROR ;

891: END IF;
892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_ERROR THEN
895: x_return_status := FND_API.G_RET_STS_ERROR ;
896: FND_MSG_PUB.COUNT_AND_GET (
897: p_count => x_msg_count,
898: p_data => x_msg_data );
899:

Line 900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

896: FND_MSG_PUB.COUNT_AND_GET (
897: p_count => x_msg_count,
898: p_data => x_msg_data );
899:
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
902: FND_MSG_PUB.COUNT_AND_GET (
903: p_count => x_msg_count,
904: p_data => x_msg_data );

Line 901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

897: p_count => x_msg_count,
898: p_data => x_msg_data );
899:
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
902: FND_MSG_PUB.COUNT_AND_GET (
903: p_count => x_msg_count,
904: p_data => x_msg_data );
905:

Line 907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

903: p_count => x_msg_count,
904: p_data => x_msg_data );
905:
906: WHEN OTHERS THEN
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
910: FND_MSG_PUB.ADD;
911: FND_MSG_PUB.COUNT_AND_GET (

Line 996: IF NOT FND_API.Compatible_API_Call(l_api_version,

992: --Standard start of API savepoint
993: SAVEPOINT list_schedule;
994:
995: --Standard call to check for call compatibility.
996: IF NOT FND_API.Compatible_API_Call(l_api_version,
997: p_api_version,
998: l_api_name,
999: G_PKG_NAME) THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

996: IF NOT FND_API.Compatible_API_Call(l_api_version,
997: p_api_version,
998: l_api_name,
999: G_PKG_NAME) THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END IF;
1002:
1003: --Initialize message list if p_init_msg_list is set to TRUE.
1004: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1004: IF FND_API.to_Boolean(p_init_msg_list) THEN

1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END IF;
1002:
1003: --Initialize message list if p_init_msg_list is set to TRUE.
1004: IF FND_API.to_Boolean(p_init_msg_list) THEN
1005: FND_MSG_PUB.initialize;
1006: END IF;
1007:
1008: --Initialize API return status to success.

Line 1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

1005: FND_MSG_PUB.initialize;
1006: END IF;
1007:
1008: --Initialize API return status to success.
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010: l_return_status := 'TRUE';
1011: l_rec_count := 0;
1012:
1013: --

Line 1039: p_init_msg_list => FND_API.G_FALSE,

1035: IF l_return_status = 'FALSE' THEN
1036: -- Add to msg stack
1037: igs_en_gen_017.enrp_msg_string_to_list(
1038: p_message_string => l_error_message,
1039: p_init_msg_list => FND_API.G_FALSE,
1040: x_message_count => l_messaage_count,
1041: x_message_data => l_message_data
1042: );
1043: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1043: x_return_status := FND_API.G_RET_STS_ERROR;

1039: p_init_msg_list => FND_API.G_FALSE,
1040: x_message_count => l_messaage_count,
1041: x_message_data => l_message_data
1042: );
1043: x_return_status := FND_API.G_RET_STS_ERROR;
1044: x_msg_count := l_messaage_count;
1045: x_msg_data := l_message_data;
1046: RETURN;
1047: END IF;

Line 1075: p_init_msg_list => FND_API.G_FALSE,

1071: IF l_rec_count = 0 THEN
1072: -- Add to msg stack
1073: igs_en_gen_017.enrp_msg_string_to_list(
1074: p_message_string => 'IGS_EN_NO_SECTION',
1075: p_init_msg_list => FND_API.G_FALSE,
1076: x_message_count => l_messaage_count,
1077: x_message_data => l_message_data);
1078:
1079: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR;

1075: p_init_msg_list => FND_API.G_FALSE,
1076: x_message_count => l_messaage_count,
1077: x_message_data => l_message_data);
1078:
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: x_msg_count := l_messaage_count;
1081: x_msg_data := l_message_data;
1082: END IF;
1083:

Line 1085: IF FND_API.to_Boolean(p_commit) THEN

1081: x_msg_data := l_message_data;
1082: END IF;
1083:
1084: --Standard check of p_commit.
1085: IF FND_API.to_Boolean(p_commit) THEN
1086: commit;
1087: END IF;
1088:
1089: --Standard call to get message count and if count is 1, get message info.

Line 1095: WHEN FND_API.G_EXC_ERROR THEN

1091: p_count => l_messaage_count,
1092: p_data => l_message_data);
1093:
1094: EXCEPTION
1095: WHEN FND_API.G_EXC_ERROR THEN
1096: ROLLBACK TO list_schedule;
1097: x_return_status := FND_API.G_RET_STS_ERROR ;
1098: FND_MSG_PUB.COUNT_AND_GET (
1099: p_count => x_msg_count,

Line 1097: x_return_status := FND_API.G_RET_STS_ERROR ;

1093:
1094: EXCEPTION
1095: WHEN FND_API.G_EXC_ERROR THEN
1096: ROLLBACK TO list_schedule;
1097: x_return_status := FND_API.G_RET_STS_ERROR ;
1098: FND_MSG_PUB.COUNT_AND_GET (
1099: p_count => x_msg_count,
1100: p_data => x_msg_data );
1101:

Line 1102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1098: FND_MSG_PUB.COUNT_AND_GET (
1099: p_count => x_msg_count,
1100: p_data => x_msg_data );
1101:
1102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1103: ROLLBACK TO list_schedule;
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1105: FND_MSG_PUB.COUNT_AND_GET (
1106: p_count => x_msg_count,

Line 1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1100: p_data => x_msg_data );
1101:
1102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1103: ROLLBACK TO list_schedule;
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1105: FND_MSG_PUB.COUNT_AND_GET (
1106: p_count => x_msg_count,
1107: p_data => x_msg_data );
1108:

Line 1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1107: p_data => x_msg_data );
1108:
1109: WHEN OTHERS THEN
1110: ROLLBACK TO list_schedule;
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1112: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1113: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );
1114: END IF;
1115: FND_MSG_PUB.COUNT_AND_GET (

Line 1180: IF NOT FND_API.compatible_api_call(l_api_version,

1176: --Standard start of API savepoint
1177: SAVEPOINT list_section_in_cart;
1178:
1179: --Standard call to check for call compatibility.
1180: IF NOT FND_API.compatible_api_call(l_api_version,
1181: p_api_version,
1182: l_api_name,
1183: G_PKG_NAME) THEN
1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1180: IF NOT FND_API.compatible_api_call(l_api_version,
1181: p_api_version,
1182: l_api_name,
1183: G_PKG_NAME) THEN
1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1185: END IF;
1186:
1187: --Initialize message list if p_init_msg_list is set to TRUE.
1188: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1188: IF FND_API.to_Boolean(p_init_msg_list) THEN

1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1185: END IF;
1186:
1187: --Initialize message list if p_init_msg_list is set to TRUE.
1188: IF FND_API.to_Boolean(p_init_msg_list) THEN
1189: FND_MSG_PUB.initialize;
1190: END IF;
1191:
1192: --Initialize API return status to success.

Line 1193: x_return_status := FND_API.G_RET_STS_SUCCESS;

1189: FND_MSG_PUB.initialize;
1190: END IF;
1191:
1192: --Initialize API return status to success.
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;
1194: l_return_status := 'TRUE';
1195: l_rec_count := 0;
1196:
1197: --

Line 1224: p_init_msg_list => FND_API.G_FALSE,

1220: -- Add to msg stack
1221: igs_en_gen_017.enrp_msg_string_to_list(
1222: p_message_string => l_error_message,
1223: p_delimiter => ';',
1224: p_init_msg_list => FND_API.G_FALSE,
1225: x_message_count => l_messaage_count,
1226: x_message_data => l_message_data);
1227:
1228: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1228: x_return_status := FND_API.G_RET_STS_ERROR;

1224: p_init_msg_list => FND_API.G_FALSE,
1225: x_message_count => l_messaage_count,
1226: x_message_data => l_message_data);
1227:
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: x_msg_count := l_messaage_count;
1230: x_msg_data := l_message_data;
1231: RETURN;
1232: END IF;

Line 1244: p_init_msg_list => FND_API.G_FALSE,

1240: IF l_rec_count = 0 THEN
1241: -- Add to msg stack
1242: igs_en_gen_017.enrp_msg_string_to_list(
1243: p_message_string => 'IGS_EN_NO_SECTION',
1244: p_init_msg_list => FND_API.G_FALSE,
1245: x_message_count => l_messaage_count,
1246: x_message_data => l_message_data);
1247:
1248: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1248: x_return_status := FND_API.G_RET_STS_ERROR;

1244: p_init_msg_list => FND_API.G_FALSE,
1245: x_message_count => l_messaage_count,
1246: x_message_data => l_message_data);
1247:
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: x_msg_count := l_messaage_count;
1250: x_msg_data := l_message_data;
1251: END IF;
1252:

Line 1254: IF FND_API.to_Boolean(p_commit) THEN

1250: x_msg_data := l_message_data;
1251: END IF;
1252:
1253: --Standard check of p_commit.
1254: IF FND_API.to_Boolean(p_commit) THEN
1255: commit;
1256: END IF;
1257:
1258: --Standard call to get message count and if count is 1, get message info.

Line 1264: WHEN FND_API.G_EXC_ERROR THEN

1260: p_count => l_messaage_count,
1261: p_data => l_message_data);
1262:
1263: EXCEPTION
1264: WHEN FND_API.G_EXC_ERROR THEN
1265: ROLLBACK TO list_section_in_cart;
1266: x_return_status := FND_API.G_RET_STS_ERROR ;
1267: FND_MSG_PUB.COUNT_AND_GET (
1268: p_count => x_msg_count,

Line 1266: x_return_status := FND_API.G_RET_STS_ERROR ;

1262:
1263: EXCEPTION
1264: WHEN FND_API.G_EXC_ERROR THEN
1265: ROLLBACK TO list_section_in_cart;
1266: x_return_status := FND_API.G_RET_STS_ERROR ;
1267: FND_MSG_PUB.COUNT_AND_GET (
1268: p_count => x_msg_count,
1269: p_data => x_msg_data );
1270:

Line 1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1267: FND_MSG_PUB.COUNT_AND_GET (
1268: p_count => x_msg_count,
1269: p_data => x_msg_data );
1270:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1272: ROLLBACK TO list_section_in_cart;
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1274: FND_MSG_PUB.COUNT_AND_GET (
1275: p_count => x_msg_count,

Line 1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1269: p_data => x_msg_data );
1270:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1272: ROLLBACK TO list_section_in_cart;
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1274: FND_MSG_PUB.COUNT_AND_GET (
1275: p_count => x_msg_count,
1276: p_data => x_msg_data );
1277:

Line 1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1276: p_data => x_msg_data );
1277:
1278: WHEN OTHERS THEN
1279: ROLLBACK TO list_section_in_cart;
1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1281: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1282: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );
1283: END IF;
1284: FND_MSG_PUB.COUNT_AND_GET (

Line 1340: IF NOT FND_API.compatible_api_call(l_api_version,

1336: --Standard start of API savepoint
1337: SAVEPOINT remove_from_cart;
1338:
1339: --Standard call to check for call compatibility.
1340: IF NOT FND_API.compatible_api_call(l_api_version,
1341: p_api_version,
1342: l_api_name,
1343: G_PKG_NAME) THEN
1344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1340: IF NOT FND_API.compatible_api_call(l_api_version,
1341: p_api_version,
1342: l_api_name,
1343: G_PKG_NAME) THEN
1344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1345: END IF;
1346:
1347: --Initialize message list if p_init_msg_list is set to TRUE.
1348: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1348: IF FND_API.to_Boolean(p_init_msg_list) THEN

1344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1345: END IF;
1346:
1347: --Initialize message list if p_init_msg_list is set to TRUE.
1348: IF FND_API.to_Boolean(p_init_msg_list) THEN
1349: FND_MSG_PUB.initialize;
1350: END IF;
1351:
1352: --Initialize API return status to success.

Line 1353: x_return_status := FND_API.G_RET_STS_SUCCESS;

1349: FND_MSG_PUB.initialize;
1350: END IF;
1351:
1352: --Initialize API return status to success.
1353: x_return_status := FND_API.G_RET_STS_SUCCESS;
1354: l_return_status := 'TRUE';
1355: l_rec_count := 0;
1356:
1357: --

Line 1384: p_init_msg_list => FND_API.G_FALSE,

1380: -- Add to msg stack
1381: igs_en_gen_017.enrp_msg_string_to_list(
1382: p_message_string => l_error_message,
1383: p_delimiter => ';',
1384: p_init_msg_list => FND_API.G_FALSE,
1385: x_message_count => l_messaage_count,
1386: x_message_data => l_message_data);
1387:
1388: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1388: x_return_status := FND_API.G_RET_STS_ERROR;

1384: p_init_msg_list => FND_API.G_FALSE,
1385: x_message_count => l_messaage_count,
1386: x_message_data => l_message_data);
1387:
1388: x_return_status := FND_API.G_RET_STS_ERROR;
1389: x_msg_count := l_messaage_count;
1390: x_msg_data := l_message_data;
1391: RETURN;
1392: END IF;

Line 1405: IF FND_API.to_Boolean(p_commit) THEN

1401: END IF;
1402: CLOSE cur_cart;
1403:
1404: --Standard check of p_commit.
1405: IF FND_API.to_Boolean(p_commit) THEN
1406: commit;
1407: END IF;
1408:
1409: --Standard call to get message count and if count is 1, get message info.

Line 1415: WHEN FND_API.G_EXC_ERROR THEN

1411: p_count => l_messaage_count,
1412: p_data => l_message_data);
1413:
1414: EXCEPTION
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: ROLLBACK TO remove_from_cart;
1417: x_return_status := FND_API.G_RET_STS_ERROR ;
1418: FND_MSG_PUB.COUNT_AND_GET (
1419: p_count => x_msg_count,

Line 1417: x_return_status := FND_API.G_RET_STS_ERROR ;

1413:
1414: EXCEPTION
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: ROLLBACK TO remove_from_cart;
1417: x_return_status := FND_API.G_RET_STS_ERROR ;
1418: FND_MSG_PUB.COUNT_AND_GET (
1419: p_count => x_msg_count,
1420: p_data => x_msg_data );
1421:

Line 1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1418: FND_MSG_PUB.COUNT_AND_GET (
1419: p_count => x_msg_count,
1420: p_data => x_msg_data );
1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: ROLLBACK TO remove_from_cart;
1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1425: FND_MSG_PUB.COUNT_AND_GET (
1426: p_count => x_msg_count,

Line 1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1420: p_data => x_msg_data );
1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: ROLLBACK TO remove_from_cart;
1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1425: FND_MSG_PUB.COUNT_AND_GET (
1426: p_count => x_msg_count,
1427: p_data => x_msg_data );
1428:

Line 1431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1427: p_data => x_msg_data );
1428:
1429: WHEN OTHERS THEN
1430: ROLLBACK TO remove_from_cart;
1431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1432: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1433: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );
1434: END IF;
1435: FND_MSG_PUB.COUNT_AND_GET (

Line 1492: IF NOT FND_API.compatible_api_call(l_api_version,

1488: --Standard start of API savepoint
1489: SAVEPOINT update_enroll_stats;
1490:
1491: --Standard call to check for call compatibility.
1492: IF NOT FND_API.compatible_api_call(l_api_version,
1493: p_api_version,
1494: l_api_name,
1495: G_PKG_NAME) THEN
1496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1492: IF NOT FND_API.compatible_api_call(l_api_version,
1493: p_api_version,
1494: l_api_name,
1495: G_PKG_NAME) THEN
1496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1497: END IF;
1498:
1499: --Initialize message list if p_init_msg_list is set to TRUE.
1500: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1500: IF FND_API.to_Boolean(p_init_msg_list) THEN

1496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1497: END IF;
1498:
1499: --Initialize message list if p_init_msg_list is set to TRUE.
1500: IF FND_API.to_Boolean(p_init_msg_list) THEN
1501: FND_MSG_PUB.initialize;
1502: END IF;
1503:
1504: --Initialize API return status to success.

Line 1505: x_return_status := FND_API.G_RET_STS_SUCCESS;

1501: FND_MSG_PUB.initialize;
1502: END IF;
1503:
1504: --Initialize API return status to success.
1505: x_return_status := FND_API.G_RET_STS_SUCCESS;
1506: l_return_status := 'TRUE';
1507:
1508: --
1509: -- Main code logic begins

Line 1535: p_init_msg_list => FND_API.G_FALSE,

1531: -- Add to msg stack
1532: igs_en_gen_017.enrp_msg_string_to_list(
1533: p_message_string => l_error_message,
1534: p_delimiter => ';',
1535: p_init_msg_list => FND_API.G_FALSE,
1536: x_message_count => l_messaage_count,
1537: x_message_data => l_message_data);
1538:
1539: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1539: x_return_status := FND_API.G_RET_STS_ERROR;

1535: p_init_msg_list => FND_API.G_FALSE,
1536: x_message_count => l_messaage_count,
1537: x_message_data => l_message_data);
1538:
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: x_msg_count := l_messaage_count;
1541: x_msg_data := l_message_data;
1542: RETURN;
1543: END IF;

Line 1604: IF FND_API.to_Boolean(p_commit) THEN

1600: END IF;
1601: CLOSE cur_enroll_stat;
1602:
1603: --Standard check of p_commit.
1604: IF FND_API.to_Boolean(p_commit) THEN
1605: commit;
1606: END IF;
1607:
1608: --Standard call to get message count and if count is 1, get message info.

Line 1614: WHEN FND_API.G_EXC_ERROR THEN

1610: p_count => l_messaage_count,
1611: p_data => l_message_data);
1612:
1613: EXCEPTION
1614: WHEN FND_API.G_EXC_ERROR THEN
1615: ROLLBACK TO update_enroll_stats;
1616: x_return_status := FND_API.G_RET_STS_ERROR ;
1617: FND_MSG_PUB.COUNT_AND_GET (
1618: p_count => x_msg_count,

Line 1616: x_return_status := FND_API.G_RET_STS_ERROR ;

1612:
1613: EXCEPTION
1614: WHEN FND_API.G_EXC_ERROR THEN
1615: ROLLBACK TO update_enroll_stats;
1616: x_return_status := FND_API.G_RET_STS_ERROR ;
1617: FND_MSG_PUB.COUNT_AND_GET (
1618: p_count => x_msg_count,
1619: p_data => x_msg_data );
1620:

Line 1621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1617: FND_MSG_PUB.COUNT_AND_GET (
1618: p_count => x_msg_count,
1619: p_data => x_msg_data );
1620:
1621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1622: ROLLBACK TO update_enroll_stats;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1624: FND_MSG_PUB.COUNT_AND_GET (
1625: p_count => x_msg_count,

Line 1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1619: p_data => x_msg_data );
1620:
1621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1622: ROLLBACK TO update_enroll_stats;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1624: FND_MSG_PUB.COUNT_AND_GET (
1625: p_count => x_msg_count,
1626: p_data => x_msg_data );
1627:

Line 1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1626: p_data => x_msg_data );
1627:
1628: WHEN OTHERS THEN
1629: ROLLBACK TO update_enroll_stats;
1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1631: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1632: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );
1633: END IF;
1634: FND_MSG_PUB.COUNT_AND_GET (

Line 1695: IF NOT FND_API.compatible_api_call(l_api_version,

1691: --Standard start of API savepoint
1692: SAVEPOINT validate_career_program;
1693:
1694: --Standard call to check for call compatibility.
1695: IF NOT FND_API.compatible_api_call(l_api_version,
1696: p_api_version,
1697: l_api_name,
1698: G_PKG_NAME) THEN
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1695: IF NOT FND_API.compatible_api_call(l_api_version,
1696: p_api_version,
1697: l_api_name,
1698: G_PKG_NAME) THEN
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: END IF;
1701:
1702: --Initialize message list if p_init_msg_list is set to TRUE.
1703: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1703: IF FND_API.to_Boolean(p_init_msg_list) THEN

1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: END IF;
1701:
1702: --Initialize message list if p_init_msg_list is set to TRUE.
1703: IF FND_API.to_Boolean(p_init_msg_list) THEN
1704: FND_MSG_PUB.initialize;
1705: END IF;
1706:
1707: --Initialize API return status to success.

Line 1708: x_return_status := FND_API.G_RET_STS_SUCCESS;

1704: FND_MSG_PUB.initialize;
1705: END IF;
1706:
1707: --Initialize API return status to success.
1708: x_return_status := FND_API.G_RET_STS_SUCCESS;
1709: l_return_status := 'TRUE';
1710:
1711: --
1712: -- Main code logic begins

Line 1725: p_init_msg_list => FND_API.G_FALSE,

1721: IF l_return_status = 'FALSE' THEN
1722: -- add to msg stack
1723: igs_en_gen_017.enrp_msg_string_to_list(
1724: p_message_string => l_error_message,
1725: p_init_msg_list => FND_API.G_FALSE,
1726: x_message_count => l_messaage_count,
1727: x_message_data => l_message_data);
1728:
1729: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1729: x_return_status := FND_API.G_RET_STS_ERROR;

1725: p_init_msg_list => FND_API.G_FALSE,
1726: x_message_count => l_messaage_count,
1727: x_message_data => l_message_data);
1728:
1729: x_return_status := FND_API.G_RET_STS_ERROR;
1730: x_msg_count := l_messaage_count;
1731: x_msg_data := l_message_data;
1732: RETURN;
1733: END IF;

Line 1740: p_init_msg_list => FND_API.G_FALSE,

1736: IF NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' THEN
1737: IF p_career IS NULL THEN
1738: igs_en_gen_017.enrp_msg_string_to_list(
1739: p_message_string => 'IGS_EN_NO_CAREER',
1740: p_init_msg_list => FND_API.G_FALSE,
1741: x_message_count => l_messaage_count,
1742: x_message_data => l_message_data);
1743:
1744: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1744: x_return_status := FND_API.G_RET_STS_ERROR;

1740: p_init_msg_list => FND_API.G_FALSE,
1741: x_message_count => l_messaage_count,
1742: x_message_data => l_message_data);
1743:
1744: x_return_status := FND_API.G_RET_STS_ERROR;
1745: x_msg_count := l_messaage_count;
1746: x_msg_data := l_message_data;
1747: RETURN;
1748: END IF;

Line 1762: p_init_msg_list => FND_API.G_FALSE,

1758: p_term_sequence_number => NULL);
1759: IF l_primary_code IS NULL THEN
1760: igs_en_gen_017.enrp_msg_string_to_list(
1761: p_message_string => 'IGS_SS_EN_NO_CAREER',
1762: p_init_msg_list => FND_API.G_FALSE,
1763: x_message_count => l_messaage_count,
1764: x_message_data => l_message_data);
1765:
1766: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1766: x_return_status := FND_API.G_RET_STS_ERROR;

1762: p_init_msg_list => FND_API.G_FALSE,
1763: x_message_count => l_messaage_count,
1764: x_message_data => l_message_data);
1765:
1766: x_return_status := FND_API.G_RET_STS_ERROR;
1767: x_msg_count := l_messaage_count;
1768: x_msg_data := l_message_data;
1769: RETURN;
1770: END IF;

Line 1777: p_init_msg_list => FND_API.G_FALSE,

1773: ELSE
1774: IF p_program_code IS NULL THEN
1775: igs_en_gen_017.enrp_msg_string_to_list(
1776: p_message_string => 'IGS_EN_NO_PROGRAM',
1777: p_init_msg_list => FND_API.G_FALSE,
1778: x_message_count => l_messaage_count,
1779: x_message_data => l_message_data);
1780:
1781: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1781: x_return_status := FND_API.G_RET_STS_ERROR;

1777: p_init_msg_list => FND_API.G_FALSE,
1778: x_message_count => l_messaage_count,
1779: x_message_data => l_message_data);
1780:
1781: x_return_status := FND_API.G_RET_STS_ERROR;
1782: x_msg_count := l_messaage_count;
1783: x_msg_data := l_message_data;
1784: RETURN;
1785: END IF;

Line 1793: p_init_msg_list => FND_API.G_FALSE,

1789: FETCH cur_get_ver INTO l_rec_ver;
1790: IF cur_get_ver%NOTFOUND THEN
1791: igs_en_gen_017.enrp_msg_string_to_list(
1792: p_message_string => 'IGS_EN_NO_ACTIVE_PROGRAM',
1793: p_init_msg_list => FND_API.G_FALSE,
1794: x_message_count => l_messaage_count,
1795: x_message_data => l_message_data);
1796:
1797: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1797: x_return_status := FND_API.G_RET_STS_ERROR;

1793: p_init_msg_list => FND_API.G_FALSE,
1794: x_message_count => l_messaage_count,
1795: x_message_data => l_message_data);
1796:
1797: x_return_status := FND_API.G_RET_STS_ERROR;
1798: x_msg_count := l_messaage_count;
1799: x_msg_data := l_message_data;
1800: RETURN;
1801: ELSE

Line 1806: x_return_status := FND_API.G_RET_STS_SUCCESS;

1802: x_primary_code := p_program_code;
1803: x_primary_version := l_rec_ver.version_number;
1804: END IF;
1805: CLOSE cur_get_ver;
1806: x_return_status := FND_API.G_RET_STS_SUCCESS;
1807: x_msg_count := NULL;
1808: x_msg_data := NULL;
1809: RETURN;
1810: END IF;

Line 1813: IF FND_API.to_Boolean(p_commit) THEN

1809: RETURN;
1810: END IF;
1811:
1812: --Standard check of p_commit.
1813: IF FND_API.to_Boolean(p_commit) THEN
1814: commit;
1815: END IF;
1816:
1817: --Standard call to get message count and if count is 1, get message info.

Line 1823: WHEN FND_API.G_EXC_ERROR THEN

1819: p_count => l_messaage_count,
1820: p_data => l_message_data);
1821:
1822: EXCEPTION
1823: WHEN FND_API.G_EXC_ERROR THEN
1824: ROLLBACK TO validate_career_program;
1825: x_return_status := FND_API.G_RET_STS_ERROR ;
1826: FND_MSG_PUB.COUNT_AND_GET (
1827: p_count => x_msg_count,

Line 1825: x_return_status := FND_API.G_RET_STS_ERROR ;

1821:
1822: EXCEPTION
1823: WHEN FND_API.G_EXC_ERROR THEN
1824: ROLLBACK TO validate_career_program;
1825: x_return_status := FND_API.G_RET_STS_ERROR ;
1826: FND_MSG_PUB.COUNT_AND_GET (
1827: p_count => x_msg_count,
1828: p_data => x_msg_data );
1829:

Line 1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1826: FND_MSG_PUB.COUNT_AND_GET (
1827: p_count => x_msg_count,
1828: p_data => x_msg_data );
1829:
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: ROLLBACK TO validate_career_program;
1832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1833: FND_MSG_PUB.COUNT_AND_GET (
1834: p_count => x_msg_count,

Line 1832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1828: p_data => x_msg_data );
1829:
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: ROLLBACK TO validate_career_program;
1832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1833: FND_MSG_PUB.COUNT_AND_GET (
1834: p_count => x_msg_count,
1835: p_data => x_msg_data );
1836:

Line 1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1835: p_data => x_msg_data );
1836:
1837: WHEN OTHERS THEN
1838: ROLLBACK TO validate_career_program;
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1840: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1841: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );
1842: END IF;
1843: FND_MSG_PUB.COUNT_AND_GET (

Line 1924: IF NOT FND_API.Compatible_API_Call(

1920: --Standard start of API savepoint
1921: SAVEPOINT validate_person_details;
1922:
1923: --Standard call to check for call compatibility.
1924: IF NOT FND_API.Compatible_API_Call(
1925: l_api_version,
1926: p_api_version,
1927: l_api_name,
1928: G_PKG_NAME)

Line 1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1926: p_api_version,
1927: l_api_name,
1928: G_PKG_NAME)
1929: THEN
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END IF;
1932:
1933: --Initialize message list if p_init_msg_list is set to TRUE.
1934: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1934: IF FND_API.to_Boolean(p_init_msg_list) THEN

1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END IF;
1932:
1933: --Initialize message list if p_init_msg_list is set to TRUE.
1934: IF FND_API.to_Boolean(p_init_msg_list) THEN
1935: FND_MSG_PUB.initialize;
1936: END IF;
1937:
1938: --Initialize API return status to success.

Line 1939: x_return_status := FND_API.G_RET_STS_SUCCESS;

1935: FND_MSG_PUB.initialize;
1936: END IF;
1937:
1938: --Initialize API return status to success.
1939: x_return_status := FND_API.G_RET_STS_SUCCESS;
1940:
1941:
1942: -- main code logic begins
1943: /*

Line 1959: p_init_msg_list => FND_API.G_FALSE,

1955: -- add to msg stack
1956: igs_en_gen_017.enrp_msg_string_to_list
1957: (
1958: p_message_string => l_error_message,
1959: p_init_msg_list => FND_API.G_FALSE,
1960: x_message_count => l_message_count,
1961: x_message_data => l_message_data
1962: );
1963: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1963: x_return_status := FND_API.G_RET_STS_ERROR;

1959: p_init_msg_list => FND_API.G_FALSE,
1960: x_message_count => l_message_count,
1961: x_message_data => l_message_data
1962: );
1963: x_return_status := FND_API.G_RET_STS_ERROR;
1964: END IF;
1965:
1966: /*
1967: determine default term

Line 1994: p_init_msg_list => FND_API.G_FALSE,

1990: -- add to msg stack
1991: igs_en_gen_017.enrp_msg_string_to_list
1992: (
1993: p_message_string => l_error_message,
1994: p_init_msg_list => FND_API.G_FALSE,
1995: x_message_count => l_message_count,
1996: x_message_data => l_message_data
1997: );
1998: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1998: x_return_status := FND_API.G_RET_STS_ERROR;

1994: p_init_msg_list => FND_API.G_FALSE,
1995: x_message_count => l_message_count,
1996: x_message_data => l_message_data
1997: );
1998: x_return_status := FND_API.G_RET_STS_ERROR;
1999: END IF;
2000: /*
2001: Determine if single or multiple program for the student
2002: and set the career_program pl/sql table

Line 2026: p_init_msg_list => FND_API.G_FALSE,

2022: IF l_rec_count = 0 THEN
2023: igs_en_gen_017.enrp_msg_string_to_list
2024: (
2025: p_message_string => 'IGS_SS_EN_NO_CONF_PRG',
2026: p_init_msg_list => FND_API.G_FALSE,
2027: x_message_count => l_message_count,
2028: x_message_data => l_message_data
2029: );
2030: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2030: x_return_status := FND_API.G_RET_STS_ERROR;

2026: p_init_msg_list => FND_API.G_FALSE,
2027: x_message_count => l_message_count,
2028: x_message_data => l_message_data
2029: );
2030: x_return_status := FND_API.G_RET_STS_ERROR;
2031: ELSIF l_rec_count = 1 THEN
2032: x_multiple_career_program := 'N';
2033: ELSIF l_rec_count >= 2 THEN
2034: x_multiple_career_program := 'Y';

Line 2040: IF FND_API.to_Boolean(p_commit) THEN

2036:
2037:
2038:
2039: --Standard check of p_commit.
2040: IF FND_API.to_Boolean(p_commit) THEN
2041: commit;
2042: END IF;
2043:
2044: --Standard call to get message count and if count is 1, get message info.

Line 2050: WHEN FND_API.G_EXC_ERROR THEN

2046: p_count => x_msg_count,
2047: p_data => x_msg_data);
2048:
2049: EXCEPTION
2050: WHEN FND_API.G_EXC_ERROR THEN
2051: ROLLBACK TO validate_person_details;
2052: x_return_status := FND_API.G_RET_STS_ERROR;
2053: FND_MSG_PUB.Count_And_Get(
2054: p_count => x_msg_count,

Line 2052: x_return_status := FND_API.G_RET_STS_ERROR;

2048:
2049: EXCEPTION
2050: WHEN FND_API.G_EXC_ERROR THEN
2051: ROLLBACK TO validate_person_details;
2052: x_return_status := FND_API.G_RET_STS_ERROR;
2053: FND_MSG_PUB.Count_And_Get(
2054: p_count => x_msg_count,
2055: p_data => x_msg_data);
2056:

Line 2057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2053: FND_MSG_PUB.Count_And_Get(
2054: p_count => x_msg_count,
2055: p_data => x_msg_data);
2056:
2057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2058: ROLLBACK TO validate_person_details;
2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060: FND_MSG_PUB.Count_And_Get(
2061: p_count => x_msg_count,

Line 2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2055: p_data => x_msg_data);
2056:
2057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2058: ROLLBACK TO validate_person_details;
2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060: FND_MSG_PUB.Count_And_Get(
2061: p_count => x_msg_count,
2062: p_data => x_msg_data);
2063: WHEN OTHERS THEN

Line 2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2061: p_count => x_msg_count,
2062: p_data => x_msg_data);
2063: WHEN OTHERS THEN
2064: ROLLBACK TO validate_person_details;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
2067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2068: FND_MSG_PUB.ADD;
2069: FND_MSG_PUB.Count_And_Get(

Line 2109: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,

2105:
2106: BEGIN
2107:
2108: -- Standard call to check for call compatibility.
2109: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,
2110: p_api_version,
2111: l_api_name,
2112: g_pkg_name ) THEN
2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2109: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,
2110: p_api_version,
2111: l_api_name,
2112: g_pkg_name ) THEN
2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2114: END IF;
2115:
2116: -- Initialize message list if p_init_msg_list is set to TRUE.
2117: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

Line 2117: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2114: END IF;
2115:
2116: -- Initialize message list if p_init_msg_list is set to TRUE.
2117: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
2118: FND_MSG_PUB.INITIALIZE;
2119: END IF;
2120:
2121: -- Initialize API return status to success

Line 2122: x_return_status := FND_API.G_RET_STS_SUCCESS;

2118: FND_MSG_PUB.INITIALIZE;
2119: END IF;
2120:
2121: -- Initialize API return status to success
2122: x_return_status := FND_API.G_RET_STS_SUCCESS;
2123:
2124: --Validate the p_term_alt_code parameter by calling the procedure enrp_validate_term_alt_code.
2125: --This procedure will validate the parameter and also return the cal_type and seq_number (which is of no use here.)
2126: igs_en_gen_017.enrp_validate_term_alt_code(

Line 2139: p_init_msg_list => FND_API.G_FALSE,

2135: -- Call the function enrp_msg_string_to_list to set the error message. And set the return status to Error.
2136: igs_en_gen_017.enrp_msg_string_to_list (
2137: p_message_string => l_message,
2138: p_delimiter => ';',
2139: p_init_msg_list => FND_API.G_FALSE,
2140: x_message_count => l_message_count,
2141: x_message_data => l_message_data);
2142:
2143: --Set the Message Count and Message Data parameters to the out parameter of the above procedure call;

Line 2146: x_return_status := FND_API.G_RET_STS_ERROR;

2142:
2143: --Set the Message Count and Message Data parameters to the out parameter of the above procedure call;
2144: x_msg_count := l_message_count;
2145: x_msg_data := l_message_data;
2146: x_return_status := FND_API.G_RET_STS_ERROR;
2147: END IF;
2148: IF FND_API.TO_BOOLEAN( p_commit ) THEN
2149: COMMIT WORK;
2150: END IF;

Line 2148: IF FND_API.TO_BOOLEAN( p_commit ) THEN

2144: x_msg_count := l_message_count;
2145: x_msg_data := l_message_data;
2146: x_return_status := FND_API.G_RET_STS_ERROR;
2147: END IF;
2148: IF FND_API.TO_BOOLEAN( p_commit ) THEN
2149: COMMIT WORK;
2150: END IF;
2151:
2152: EXCEPTION

Line 2153: WHEN FND_API.G_EXC_ERROR THEN

2149: COMMIT WORK;
2150: END IF;
2151:
2152: EXCEPTION
2153: WHEN FND_API.G_EXC_ERROR THEN
2154: x_return_status := FND_API.G_RET_STS_ERROR ;
2155: FND_MSG_PUB.COUNT_AND_GET (
2156: p_count => x_msg_count,
2157: p_data => x_msg_data );

Line 2154: x_return_status := FND_API.G_RET_STS_ERROR ;

2150: END IF;
2151:
2152: EXCEPTION
2153: WHEN FND_API.G_EXC_ERROR THEN
2154: x_return_status := FND_API.G_RET_STS_ERROR ;
2155: FND_MSG_PUB.COUNT_AND_GET (
2156: p_count => x_msg_count,
2157: p_data => x_msg_data );
2158:

Line 2159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2155: FND_MSG_PUB.COUNT_AND_GET (
2156: p_count => x_msg_count,
2157: p_data => x_msg_data );
2158:
2159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2161: FND_MSG_PUB.COUNT_AND_GET (
2162: p_count => x_msg_count,
2163: p_data => x_msg_data );

Line 2160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2156: p_count => x_msg_count,
2157: p_data => x_msg_data );
2158:
2159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2161: FND_MSG_PUB.COUNT_AND_GET (
2162: p_count => x_msg_count,
2163: p_data => x_msg_data );
2164:

Line 2166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2162: p_count => x_msg_count,
2163: p_data => x_msg_data );
2164:
2165: WHEN OTHERS THEN
2166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2167: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
2168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2169: FND_MSG_PUB.ADD;
2170: FND_MSG_PUB.COUNT_AND_GET (

Line 2214: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,

2210: -- Standard Start of API savepoint
2211: SAVEPOINT WAITLIST_PUB;
2212:
2213: -- Standard call to check for call compatibility.
2214: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
2215: p_api_version,
2216: l_api_name,
2217: g_pkg_name ) THEN
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2214: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
2215: p_api_version,
2216: l_api_name,
2217: g_pkg_name ) THEN
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: END IF;
2220:
2221: -- Initialize message list if p_init_msg_list is set to TRUE.
2222: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

Line 2222: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: END IF;
2220:
2221: -- Initialize message list if p_init_msg_list is set to TRUE.
2222: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
2223: FND_MSG_PUB.INITIALIZE;
2224: END IF;
2225:
2226: -- Initialize API return status to success

Line 2227: x_return_status := FND_API.G_RET_STS_SUCCESS;

2223: FND_MSG_PUB.INITIALIZE;
2224: END IF;
2225:
2226: -- Initialize API return status to success
2227: x_return_status := FND_API.G_RET_STS_SUCCESS;
2228: l_waitlist := p_waitlist;
2229:
2230: --Invoke the procedure add_to_cart_waitlist by passing the relevant parameters.
2231: --Parameter p_action should be 'WLIST' in this case and the parameter p_waitlist_ind

Line 2249: x_return_status := FND_API.G_RET_STS_ERROR ;

2245:
2246: --If return status is FALSE above then log error message and RETURN.
2247: IF l_ret_status = 'FALSE' THEN
2248: ROLLBACK TO WAITLIST_PUB;
2249: x_return_status := FND_API.G_RET_STS_ERROR ;
2250: igs_en_gen_017.enrp_msg_string_to_list (
2251: p_message_string => l_message_data,
2252: p_delimiter => ';',
2253: p_init_msg_list => FND_API.G_FALSE,

Line 2253: p_init_msg_list => FND_API.G_FALSE,

2249: x_return_status := FND_API.G_RET_STS_ERROR ;
2250: igs_en_gen_017.enrp_msg_string_to_list (
2251: p_message_string => l_message_data,
2252: p_delimiter => ';',
2253: p_init_msg_list => FND_API.G_FALSE,
2254: x_message_count => x_msg_count,
2255: x_message_data => x_msg_data);
2256: x_return_status := FND_API.G_RET_STS_ERROR ;
2257: ELSE

Line 2256: x_return_status := FND_API.G_RET_STS_ERROR ;

2252: p_delimiter => ';',
2253: p_init_msg_list => FND_API.G_FALSE,
2254: x_message_count => x_msg_count,
2255: x_message_data => x_msg_data);
2256: x_return_status := FND_API.G_RET_STS_ERROR ;
2257: ELSE
2258: IF FND_API.TO_BOOLEAN( p_commit ) THEN
2259: COMMIT WORK;
2260: END IF;

Line 2258: IF FND_API.TO_BOOLEAN( p_commit ) THEN

2254: x_message_count => x_msg_count,
2255: x_message_data => x_msg_data);
2256: x_return_status := FND_API.G_RET_STS_ERROR ;
2257: ELSE
2258: IF FND_API.TO_BOOLEAN( p_commit ) THEN
2259: COMMIT WORK;
2260: END IF;
2261: END IF;
2262:

Line 2264: WHEN FND_API.G_EXC_ERROR THEN

2260: END IF;
2261: END IF;
2262:
2263: EXCEPTION
2264: WHEN FND_API.G_EXC_ERROR THEN
2265: ROLLBACK TO WAITLIST_PUB;
2266: x_return_status := FND_API.G_RET_STS_ERROR ;
2267: FND_MSG_PUB.COUNT_AND_GET (
2268: p_count => x_msg_count,

Line 2266: x_return_status := FND_API.G_RET_STS_ERROR ;

2262:
2263: EXCEPTION
2264: WHEN FND_API.G_EXC_ERROR THEN
2265: ROLLBACK TO WAITLIST_PUB;
2266: x_return_status := FND_API.G_RET_STS_ERROR ;
2267: FND_MSG_PUB.COUNT_AND_GET (
2268: p_count => x_msg_count,
2269: p_data => x_msg_data );
2270:

Line 2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2267: FND_MSG_PUB.COUNT_AND_GET (
2268: p_count => x_msg_count,
2269: p_data => x_msg_data );
2270:
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272: ROLLBACK TO WAITLIST_PUB;
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2274: FND_MSG_PUB.COUNT_AND_GET (
2275: p_count => x_msg_count,

Line 2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2269: p_data => x_msg_data );
2270:
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272: ROLLBACK TO WAITLIST_PUB;
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2274: FND_MSG_PUB.COUNT_AND_GET (
2275: p_count => x_msg_count,
2276: p_data => x_msg_data );
2277:

Line 2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2276: p_data => x_msg_data );
2277:
2278: WHEN OTHERS THEN
2279: ROLLBACK TO WAITLIST_PUB;
2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2281: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
2282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2283: FND_MSG_PUB.ADD;
2284: FND_MSG_PUB.COUNT_AND_GET (