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_MSG_PUB

Line 74: FND_MSG_PUB.INITIALIZE;

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
78: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 117: FND_MSG_PUB.COUNT_AND_GET (

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:
121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 124: FND_MSG_PUB.COUNT_AND_GET (

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:
128: WHEN OTHERS THEN

Line 133: FND_MSG_PUB.ADD;

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 (
135: p_count => x_msg_count,
136: p_data => x_msg_data );
137: END add_to_cart;

Line 134: FND_MSG_PUB.COUNT_AND_GET (

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 (
135: p_count => x_msg_count,
136: p_data => x_msg_data );
137: END add_to_cart;
138:

Line 211: FND_MSG_PUB.INITIALIZE;

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
215: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 386: FND_MSG_PUB.COUNT_AND_GET (

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:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 393: FND_MSG_PUB.COUNT_AND_GET (

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:
397: WHEN OTHERS THEN

Line 402: FND_MSG_PUB.ADD;

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 (
404: p_count => x_msg_count,
405: p_data => x_msg_data );
406: END enroll_cart;

Line 403: FND_MSG_PUB.COUNT_AND_GET (

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 (
404: p_count => x_msg_count,
405: p_data => x_msg_data );
406: END enroll_cart;
407:

Line 467: FND_MSG_PUB.initialize;

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.
471: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 522: FND_MSG_PUB.Count_And_Get(

518: commit;
519: END IF;
520:
521: --Standard call to get message count and if count is 1, get message info.
522: FND_MSG_PUB.Count_And_Get(
523: p_count => l_messaage_count,
524: p_data => l_message_data);
525:
526: EXCEPTION

Line 530: FND_MSG_PUB.COUNT_AND_GET (

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:
534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 537: FND_MSG_PUB.COUNT_AND_GET (

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:
541: WHEN OTHERS THEN

Line 544: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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 (
548: p_count => x_msg_count,

Line 545: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );

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 (
548: p_count => x_msg_count,
549: p_data => l_message_data );

Line 547: FND_MSG_PUB.COUNT_AND_GET (

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 (
548: p_count => x_msg_count,
549: p_data => l_message_data );
550: END clean_up_cart;
551:

Line 593: FND_MSG_PUB.initialize;

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.
597: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 632: FND_MSG_PUB.Count_And_Get(

628: commit;
629: END IF;
630:
631: --Standard call to get message count and if count is 1, get message info.
632: FND_MSG_PUB.Count_And_Get(
633: p_count => l_messaage_count,
634: p_data => l_message_data);
635:
636: EXCEPTION

Line 640: FND_MSG_PUB.COUNT_AND_GET (

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:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 647: FND_MSG_PUB.COUNT_AND_GET (

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:
651: WHEN OTHERS THEN

Line 654: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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 (
658: p_count => x_msg_count,

Line 655: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );

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 (
658: p_count => x_msg_count,
659: p_data => l_message_data );

Line 657: FND_MSG_PUB.COUNT_AND_GET (

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 (
658: p_count => x_msg_count,
659: p_data => l_message_data );
660: END drop_all_section;
661:

Line 706: FND_MSG_PUB.initialize;

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.
710: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 745: FND_MSG_PUB.Count_And_Get(

741: commit;
742: END IF;
743:
744: --Standard call to get message count and if count is 1, get message info.
745: FND_MSG_PUB.Count_And_Get(
746: p_count => l_messaage_count,
747: p_data => l_message_data);
748:
749: EXCEPTION

Line 753: FND_MSG_PUB.COUNT_AND_GET (

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:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 760: FND_MSG_PUB.COUNT_AND_GET (

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:
764: WHEN OTHERS THEN

Line 767: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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 (
771: p_count => x_msg_count,

Line 768: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );

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 (
771: p_count => x_msg_count,
772: p_data => l_message_data );

Line 770: FND_MSG_PUB.COUNT_AND_GET (

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 (
771: p_count => x_msg_count,
772: p_data => l_message_data );
773: END drop_section_by_call_number;
774:

Line 827: FND_MSG_PUB.INITIALIZE;

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
831: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 896: FND_MSG_PUB.COUNT_AND_GET (

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:
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 902: FND_MSG_PUB.COUNT_AND_GET (

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:
906: WHEN OTHERS THEN

Line 910: FND_MSG_PUB.ADD;

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 (
912: p_count => x_msg_count,
913: p_data => x_msg_data );
914: END evaluate_person_steps;

Line 911: FND_MSG_PUB.COUNT_AND_GET (

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 (
912: p_count => x_msg_count,
913: p_data => x_msg_data );
914: END evaluate_person_steps;
915:

Line 1005: FND_MSG_PUB.initialize;

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.
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1090: FND_MSG_PUB.Count_And_Get(

1086: commit;
1087: END IF;
1088:
1089: --Standard call to get message count and if count is 1, get message info.
1090: FND_MSG_PUB.Count_And_Get(
1091: p_count => l_messaage_count,
1092: p_data => l_message_data);
1093:
1094: EXCEPTION

Line 1098: FND_MSG_PUB.COUNT_AND_GET (

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:
1102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1105: FND_MSG_PUB.COUNT_AND_GET (

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:
1109: WHEN OTHERS THEN

Line 1112: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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 (
1116: p_count => x_msg_count,

Line 1113: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );

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 (
1116: p_count => x_msg_count,
1117: p_data => x_msg_data );

Line 1115: FND_MSG_PUB.COUNT_AND_GET (

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 (
1116: p_count => x_msg_count,
1117: p_data => x_msg_data );
1118: END list_schedule;
1119:

Line 1189: FND_MSG_PUB.initialize;

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.
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1259: FND_MSG_PUB.Count_And_Get(

1255: commit;
1256: END IF;
1257:
1258: --Standard call to get message count and if count is 1, get message info.
1259: FND_MSG_PUB.Count_And_Get(
1260: p_count => l_messaage_count,
1261: p_data => l_message_data);
1262:
1263: EXCEPTION

Line 1267: FND_MSG_PUB.COUNT_AND_GET (

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:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1274: FND_MSG_PUB.COUNT_AND_GET (

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:
1278: WHEN OTHERS THEN

Line 1281: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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 (
1285: p_count => x_msg_count,

Line 1282: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );

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 (
1285: p_count => x_msg_count,
1286: p_data => x_msg_data );

Line 1284: FND_MSG_PUB.COUNT_AND_GET (

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 (
1285: p_count => x_msg_count,
1286: p_data => x_msg_data );
1287: END list_section_in_cart;
1288:

Line 1349: FND_MSG_PUB.initialize;

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.
1353: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1410: FND_MSG_PUB.Count_And_Get(

1406: commit;
1407: END IF;
1408:
1409: --Standard call to get message count and if count is 1, get message info.
1410: FND_MSG_PUB.Count_And_Get(
1411: p_count => l_messaage_count,
1412: p_data => l_message_data);
1413:
1414: EXCEPTION

Line 1418: FND_MSG_PUB.COUNT_AND_GET (

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:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1425: FND_MSG_PUB.COUNT_AND_GET (

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:
1429: WHEN OTHERS THEN

Line 1432: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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 (
1436: p_count => x_msg_count,

Line 1433: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );

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 (
1436: p_count => x_msg_count,
1437: p_data => x_msg_data );

Line 1435: FND_MSG_PUB.COUNT_AND_GET (

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 (
1436: p_count => x_msg_count,
1437: p_data => x_msg_data );
1438: END remove_from_cart;
1439:

Line 1501: FND_MSG_PUB.initialize;

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.
1505: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1609: FND_MSG_PUB.Count_And_Get(

1605: commit;
1606: END IF;
1607:
1608: --Standard call to get message count and if count is 1, get message info.
1609: FND_MSG_PUB.Count_And_Get(
1610: p_count => l_messaage_count,
1611: p_data => l_message_data);
1612:
1613: EXCEPTION

Line 1617: FND_MSG_PUB.COUNT_AND_GET (

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:
1621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1624: FND_MSG_PUB.COUNT_AND_GET (

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:
1628: WHEN OTHERS THEN

Line 1631: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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 (
1635: p_count => x_msg_count,

Line 1632: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );

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 (
1635: p_count => x_msg_count,
1636: p_data => x_msg_data );

Line 1634: FND_MSG_PUB.COUNT_AND_GET (

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 (
1635: p_count => x_msg_count,
1636: p_data => x_msg_data );
1637: END update_enroll_stats;
1638:

Line 1704: FND_MSG_PUB.initialize;

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.
1708: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1818: FND_MSG_PUB.Count_And_Get(

1814: commit;
1815: END IF;
1816:
1817: --Standard call to get message count and if count is 1, get message info.
1818: FND_MSG_PUB.Count_And_Get(
1819: p_count => l_messaage_count,
1820: p_data => l_message_data);
1821:
1822: EXCEPTION

Line 1826: FND_MSG_PUB.COUNT_AND_GET (

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:
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1833: FND_MSG_PUB.COUNT_AND_GET (

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:
1837: WHEN OTHERS THEN

Line 1840: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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 (
1844: p_count => x_msg_count,

Line 1841: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,l_api_name );

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 (
1844: p_count => x_msg_count,
1845: p_data => x_msg_data );

Line 1843: FND_MSG_PUB.COUNT_AND_GET (

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 (
1844: p_count => x_msg_count,
1845: p_data => x_msg_data );
1846: END validate_career_program;
1847:

Line 1935: FND_MSG_PUB.initialize;

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.
1939: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2045: FND_MSG_PUB.Count_And_Get(

2041: commit;
2042: END IF;
2043:
2044: --Standard call to get message count and if count is 1, get message info.
2045: FND_MSG_PUB.Count_And_Get(
2046: p_count => x_msg_count,
2047: p_data => x_msg_data);
2048:
2049: EXCEPTION

Line 2053: FND_MSG_PUB.Count_And_Get(

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:
2057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2060: FND_MSG_PUB.Count_And_Get(

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
2064: ROLLBACK TO validate_person_details;

Line 2068: FND_MSG_PUB.ADD;

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(
2070: p_count => x_msg_count,
2071: p_data => x_msg_data);
2072:

Line 2069: FND_MSG_PUB.Count_And_Get(

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(
2070: p_count => x_msg_count,
2071: p_data => x_msg_data);
2072:
2073: END validate_person_details;

Line 2118: FND_MSG_PUB.INITIALIZE;

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
2122: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2155: FND_MSG_PUB.COUNT_AND_GET (

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:
2159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2161: FND_MSG_PUB.COUNT_AND_GET (

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:
2165: WHEN OTHERS THEN

Line 2169: FND_MSG_PUB.ADD;

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 (
2171: p_count => x_msg_count,
2172: p_data => x_msg_data );
2173: END validate_term;

Line 2170: FND_MSG_PUB.COUNT_AND_GET (

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 (
2171: p_count => x_msg_count,
2172: p_data => x_msg_data );
2173: END validate_term;
2174:

Line 2223: FND_MSG_PUB.INITIALIZE;

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
2227: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2267: FND_MSG_PUB.COUNT_AND_GET (

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:
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2274: FND_MSG_PUB.COUNT_AND_GET (

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:
2278: WHEN OTHERS THEN

Line 2283: FND_MSG_PUB.ADD;

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 (
2285: p_count => x_msg_count,
2286: p_data => x_msg_data );
2287: END waitlist;

Line 2284: FND_MSG_PUB.COUNT_AND_GET (

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 (
2285: p_count => x_msg_count,
2286: p_data => x_msg_data );
2287: END waitlist;
2288: