APPS.AMS_EVENTHEADER_PVT dependencies on FND_MSG_PUB

Line 12: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

8: -- Debug mode
9: -- g_debug boolean := FALSE;
10: -- g_debug boolean := TRUE;
11:
12: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
13: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
14: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
15:
16: PROCEDURE Check_Dates_Range (

Line 13: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

9: -- g_debug boolean := FALSE;
10: -- g_debug boolean := TRUE;
11:
12: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
13: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
14: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
15:
16: PROCEDURE Check_Dates_Range (
17: p_evh_rec IN evh_rec_type,

Line 14: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

10: -- g_debug boolean := TRUE;
11:
12: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
13: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
14: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
15:
16: PROCEDURE Check_Dates_Range (
17: p_evh_rec IN evh_rec_type,
18: x_return_status OUT NOCOPY VARCHAR2

Line 111: FND_MSG_PUB.initialize;

107:
108: END IF;
109:
110: IF FND_API.to_boolean(p_init_msg_list) THEN
111: FND_MSG_PUB.initialize;
112: END IF;
113:
114: IF NOT FND_API.compatible_api_call(l_api_version,
115: p_api_version,

Line 181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

177: fetch get_res_id into l_res_id;
178: close get_res_id;
179: end if;
180: if AMS_ACCESS_PVT.check_update_access(l_evh_rec.parent_event_header_id, 'EVEH', l_res_id, 'USER') = 'N' then
181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
182: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
183: FND_MSG_PUB.add;
184: END IF;
185: RAISE FND_API.g_exc_error;

Line 183: FND_MSG_PUB.add;

179: end if;
180: if AMS_ACCESS_PVT.check_update_access(l_evh_rec.parent_event_header_id, 'EVEH', l_res_id, 'USER') = 'N' then
181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
182: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
183: FND_MSG_PUB.add;
184: END IF;
185: RAISE FND_API.g_exc_error;
186: end if;
187: ELSIF l_evh_rec.event_level = 'MAIN' THEN

Line 282: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)

278: END IF;
279:
280: /* Code Added By GMadana for date/time validation for Agendas*/
281: IF l_start_time > l_end_time THEN
282: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
283: THEN
284: Fnd_Message.set_name('AMS', 'AMS_EVO_START_TM_GT_END_TM'); -- reusing EVEO message
285: Fnd_Msg_Pub.ADD;
286: END IF;

Line 285: Fnd_Msg_Pub.ADD;

281: IF l_start_time > l_end_time THEN
282: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
283: THEN
284: Fnd_Message.set_name('AMS', 'AMS_EVO_START_TM_GT_END_TM'); -- reusing EVEO message
285: Fnd_Msg_Pub.ADD;
286: END IF;
287: x_return_status := Fnd_Api.g_ret_sts_error;
288: RAISE Fnd_Api.g_exc_error;
289: END IF; -- st tm > end tm

Line 611: FND_MSG_PUB.count_and_get(

607: IF FND_API.to_boolean(p_commit) THEN
608: COMMIT;
609: END IF;
610:
611: FND_MSG_PUB.count_and_get(
612: p_encoded => FND_API.g_false,
613: p_count => x_msg_count,
614: p_data => x_msg_data
615: );

Line 630: FND_MSG_PUB.count_and_get(

626:
627: WHEN FND_API.g_exc_error THEN
628: ROLLBACK TO create_event_header;
629: x_return_status := FND_API.g_ret_sts_error;
630: FND_MSG_PUB.count_and_get(
631: p_encoded => FND_API.g_false,
632: p_count => x_msg_count,
633: p_data => x_msg_data
634: );

Line 639: FND_MSG_PUB.count_and_get(

635:
636: WHEN FND_API.g_exc_unexpected_error THEN
637: ROLLBACK TO create_event_header;
638: x_return_status := FND_API.g_ret_sts_unexp_error ;
639: FND_MSG_PUB.count_and_get(
640: p_encoded => FND_API.g_false,
641: p_count => x_msg_count,
642: p_data => x_msg_data
643: );

Line 650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

646: WHEN OTHERS THEN
647: ROLLBACK TO create_event_header;
648: x_return_status := FND_API.g_ret_sts_unexp_error ;
649:
650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
651: THEN
652: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
653: END IF;
654:

Line 652: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

648: x_return_status := FND_API.g_ret_sts_unexp_error ;
649:
650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
651: THEN
652: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
653: END IF;
654:
655: FND_MSG_PUB.count_and_get(
656: p_encoded => FND_API.g_false,

Line 655: FND_MSG_PUB.count_and_get(

651: THEN
652: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
653: END IF;
654:
655: FND_MSG_PUB.count_and_get(
656: p_encoded => FND_API.g_false,
657: p_count => x_msg_count,
658: p_data => x_msg_data
659: );

Line 717: FND_MSG_PUB.initialize;

713:
714: END IF;
715:
716: IF FND_API.to_boolean(p_init_msg_list) THEN
717: FND_MSG_PUB.initialize;
718: END IF;
719:
720: IF NOT FND_API.compatible_api_call(
721: l_api_version,

Line 753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

749:
750: AMS_Utility_PVT.debug_message('l_hdr_id:'||l_hdr_id || 'P_evh_id:' || p_evh_id || 'l_res_id:' || l_res_id);
751: END IF;
752: if AMS_ACCESS_PVT.check_update_access(l_hdr_id, 'EVEH', l_res_id, 'USER') = 'N' then
753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
754: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing the message
755: FND_MSG_PUB.add;
756: END IF;
757: RAISE FND_API.g_exc_error;

Line 755: FND_MSG_PUB.add;

751: END IF;
752: if AMS_ACCESS_PVT.check_update_access(l_hdr_id, 'EVEH', l_res_id, 'USER') = 'N' then
753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
754: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing the message
755: FND_MSG_PUB.add;
756: END IF;
757: RAISE FND_API.g_exc_error;
758: end if;
759: ------------------------ delete ------------------------

Line 771: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

767: WHERE event_header_id = p_evh_id
768: AND object_version_number = p_object_version;
769:
770: IF (SQL%NOTFOUND) THEN
771: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
772: THEN
773: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
774: FND_MSG_PUB.add;
775: END IF;

Line 774: FND_MSG_PUB.add;

770: IF (SQL%NOTFOUND) THEN
771: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
772: THEN
773: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
774: FND_MSG_PUB.add;
775: END IF;
776: RAISE FND_API.g_exc_error;
777: END IF;
778: /*

Line 783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

779: DELETE FROM ams_event_headers_all_tl
780: WHERE event_header_id = p_evh_id;
781: */
782: IF (SQL%NOTFOUND) THEN
783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
784: THEN
785: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
786: FND_MSG_PUB.add;
787: END IF;

Line 786: FND_MSG_PUB.add;

782: IF (SQL%NOTFOUND) THEN
783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
784: THEN
785: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
786: FND_MSG_PUB.add;
787: END IF;
788: RAISE FND_API.g_exc_error;
789: END IF;
790:

Line 796: FND_MSG_PUB.count_and_get(

792: IF FND_API.to_boolean(p_commit) THEN
793: COMMIT;
794: END IF;
795:
796: FND_MSG_PUB.count_and_get(
797: p_encoded => FND_API.g_false,
798: p_count => x_msg_count,
799: p_data => x_msg_data
800: );

Line 815: FND_MSG_PUB.count_and_get(

811:
812: WHEN FND_API.g_exc_error THEN
813: ROLLBACK TO delete_event_header;
814: x_return_status := FND_API.g_ret_sts_error;
815: FND_MSG_PUB.count_and_get(
816: p_encoded => FND_API.g_false,
817: p_count => x_msg_count,
818: p_data => x_msg_data
819: );

Line 824: FND_MSG_PUB.count_and_get(

820:
821: WHEN FND_API.g_exc_unexpected_error THEN
822: ROLLBACK TO delete_event_header;
823: x_return_status := FND_API.g_ret_sts_unexp_error ;
824: FND_MSG_PUB.count_and_get(
825: p_encoded => FND_API.g_false,
826: p_count => x_msg_count,
827: p_data => x_msg_data
828: );

Line 834: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

830: WHEN OTHERS THEN
831: ROLLBACK TO delete_event_header;
832: x_return_status := FND_API.g_ret_sts_unexp_error ;
833:
834: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
835: THEN
836: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
837: END IF;
838:

Line 836: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

832: x_return_status := FND_API.g_ret_sts_unexp_error ;
833:
834: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
835: THEN
836: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
837: END IF;
838:
839: FND_MSG_PUB.count_and_get(
840: p_encoded => FND_API.g_false,

Line 839: FND_MSG_PUB.count_and_get(

835: THEN
836: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
837: END IF;
838:
839: FND_MSG_PUB.count_and_get(
840: p_encoded => FND_API.g_false,
841: p_count => x_msg_count,
842: p_data => x_msg_data
843: );

Line 897: FND_MSG_PUB.initialize;

893: AMS_Utility_PVT.debug_message(l_full_name||': start');
894: END IF;
895:
896: IF FND_API.to_boolean(p_init_msg_list) THEN
897: FND_MSG_PUB.initialize;
898: END IF;
899:
900: IF NOT FND_API.compatible_api_call(
901: l_api_version,

Line 921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

917: OPEN c_evh_b;
918: FETCH c_evh_b INTO l_evh_id;
919: IF (c_evh_b%NOTFOUND) THEN
920: CLOSE c_evh_b;
921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
922: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
923: FND_MSG_PUB.add;
924: END IF;
925: RAISE FND_API.g_exc_error;

Line 923: FND_MSG_PUB.add;

919: IF (c_evh_b%NOTFOUND) THEN
920: CLOSE c_evh_b;
921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
922: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
923: FND_MSG_PUB.add;
924: END IF;
925: RAISE FND_API.g_exc_error;
926: END IF;
927: CLOSE c_evh_b;

Line 933: FND_MSG_PUB.count_and_get(

929: OPEN c_evh_tl;
930: CLOSE c_evh_tl;
931:
932: -------------------- finish --------------------------
933: FND_MSG_PUB.count_and_get(
934: p_encoded => FND_API.g_false,
935: p_count => x_msg_count,
936: p_data => x_msg_data
937: );

Line 951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

947: EXCEPTION
948:
949: WHEN AMS_Utility_PVT.resource_locked THEN
950: x_return_status := FND_API.g_ret_sts_error;
951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
952: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
953: FND_MSG_PUB.add;
954: END IF;
955:

Line 953: FND_MSG_PUB.add;

949: WHEN AMS_Utility_PVT.resource_locked THEN
950: x_return_status := FND_API.g_ret_sts_error;
951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
952: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
953: FND_MSG_PUB.add;
954: END IF;
955:
956: FND_MSG_PUB.count_and_get(
957: p_encoded => FND_API.g_false,

Line 956: FND_MSG_PUB.count_and_get(

952: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
953: FND_MSG_PUB.add;
954: END IF;
955:
956: FND_MSG_PUB.count_and_get(
957: p_encoded => FND_API.g_false,
958: p_count => x_msg_count,
959: p_data => x_msg_data
960: );

Line 964: FND_MSG_PUB.count_and_get(

960: );
961:
962: WHEN FND_API.g_exc_error THEN
963: x_return_status := FND_API.g_ret_sts_error;
964: FND_MSG_PUB.count_and_get(
965: p_encoded => FND_API.g_false,
966: p_count => x_msg_count,
967: p_data => x_msg_data
968: );

Line 972: FND_MSG_PUB.count_and_get(

968: );
969:
970: WHEN FND_API.g_exc_unexpected_error THEN
971: x_return_status := FND_API.g_ret_sts_unexp_error ;
972: FND_MSG_PUB.count_and_get(
973: p_encoded => FND_API.g_false,
974: p_count => x_msg_count,
975: p_data => x_msg_data
976: );

Line 980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

976: );
977:
978: WHEN OTHERS THEN
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
981: THEN
982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
983: END IF;
984:

Line 982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

978: WHEN OTHERS THEN
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
981: THEN
982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
983: END IF;
984:
985: FND_MSG_PUB.count_and_get(
986: p_encoded => FND_API.g_false,

Line 985: FND_MSG_PUB.count_and_get(

981: THEN
982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
983: END IF;
984:
985: FND_MSG_PUB.count_and_get(
986: p_encoded => FND_API.g_false,
987: p_count => x_msg_count,
988: p_data => x_msg_data
989: );

Line 1077: FND_MSG_PUB.initialize;

1073:
1074: END IF;
1075:
1076: IF FND_API.to_boolean(p_init_msg_list) THEN
1077: FND_MSG_PUB.initialize;
1078: END IF;
1079:
1080: IF NOT FND_API.compatible_api_call(
1081: l_api_version,

Line 1121: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1117: IF c_bdgt_line_yn%NOTFOUND THEN
1118: CLOSE c_bdgt_line_yn;
1119: else
1120: CLOSE c_bdgt_line_yn;
1121: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1122: FND_MESSAGE.set_name('AMS', 'AMS_EVENT_BUD_PRESENT');
1123: FND_MSG_PUB.add;
1124: END IF;
1125: RAISE FND_API.g_exc_error;

Line 1123: FND_MSG_PUB.add;

1119: else
1120: CLOSE c_bdgt_line_yn;
1121: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1122: FND_MESSAGE.set_name('AMS', 'AMS_EVENT_BUD_PRESENT');
1123: FND_MSG_PUB.add;
1124: END IF;
1125: RAISE FND_API.g_exc_error;
1126: END IF;
1127: END IF;

Line 1343: FND_MSG_PUB.add;

1339: RAISE FND_API.g_exc_unexpected_error;
1340: END IF;
1341: ELSE
1342: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_UPDATE_SRC_STAT');
1343: FND_MSG_PUB.add;
1344: RAISE FND_API.g_exc_error;
1345: END IF;
1346: END IF;
1347: ELSIF p_evh_rec.source_code IS NULL /* added by musman for bug 2618242 fix*/

Line 1384: FND_MSG_PUB.add;

1380: RAISE FND_API.g_exc_unexpected_error;
1381: END IF;
1382: ELSE
1383: FND_MESSAGE.set_name('AMS', 'AMS_EVNT_UPDATE_GFLG_STAT');
1384: FND_MSG_PUB.add;
1385: RAISE FND_API.g_exc_error;
1386: END IF;
1387: END IF;
1388: END IF;

Line 1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1404: l_hdr_id := l_evh_rec.event_header_id;
1405: END IF;
1406:
1407: if AMS_ACCESS_PVT.check_update_access(l_hdr_id, 'EVEH', l_res_id, 'USER') = 'N' then
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1409: THEN
1410: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
1411: FND_MSG_PUB.add;
1412: END IF;

Line 1411: FND_MSG_PUB.add;

1407: if AMS_ACCESS_PVT.check_update_access(l_hdr_id, 'EVEH', l_res_id, 'USER') = 'N' then
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1409: THEN
1410: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
1411: FND_MSG_PUB.add;
1412: END IF;
1413: RAISE FND_API.g_exc_error;
1414: end if;
1415:

Line 1693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1689:
1690: END IF;
1691:
1692: IF (SQL%NOTFOUND) THEN
1693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1694: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1695: FND_MSG_PUB.add;
1696: END IF;
1697: RAISE FND_API.g_exc_error;

Line 1695: FND_MSG_PUB.add;

1691:
1692: IF (SQL%NOTFOUND) THEN
1693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1694: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1695: FND_MSG_PUB.add;
1696: END IF;
1697: RAISE FND_API.g_exc_error;
1698: END IF;
1699:

Line 1731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1727: WHERE event_header_id = l_evh_rec.event_header_id
1728: AND USERENV('LANG') IN (language, source_lang);
1729:
1730: IF (SQL%NOTFOUND) THEN
1731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1732: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1733: FND_MSG_PUB.add;
1734: END IF;
1735: RAISE FND_API.g_exc_error;

Line 1733: FND_MSG_PUB.add;

1729:
1730: IF (SQL%NOTFOUND) THEN
1731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1732: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1733: FND_MSG_PUB.add;
1734: END IF;
1735: RAISE FND_API.g_exc_error;
1736: END IF;
1737:

Line 1797: FND_MSG_PUB.count_and_get(

1793: AMS_Utility_PVT.debug_message(l_full_name ||': getting messages');
1794:
1795: END IF;
1796:
1797: FND_MSG_PUB.count_and_get(
1798: p_encoded => FND_API.g_false,
1799: p_count => x_msg_count,
1800: p_data => x_msg_data
1801: );

Line 1816: FND_MSG_PUB.count_and_get(

1812:
1813: WHEN FND_API.g_exc_error THEN
1814: ROLLBACK TO update_event_header;
1815: x_return_status := FND_API.g_ret_sts_error;
1816: FND_MSG_PUB.count_and_get(
1817: p_encoded => FND_API.g_false,
1818: p_count => x_msg_count,
1819: p_data => x_msg_data
1820: );

Line 1825: FND_MSG_PUB.count_and_get(

1821:
1822: WHEN FND_API.g_exc_unexpected_error THEN
1823: ROLLBACK TO update_event_header;
1824: x_return_status := FND_API.g_ret_sts_unexp_error ;
1825: FND_MSG_PUB.count_and_get(
1826: p_encoded => FND_API.g_false,
1827: p_count => x_msg_count,
1828: p_data => x_msg_data
1829: );

Line 1835: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1831: WHEN OTHERS THEN
1832: ROLLBACK TO update_event_header;
1833: x_return_status := FND_API.g_ret_sts_unexp_error ;
1834:
1835: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1836: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1837: END IF;
1838:
1839: FND_MSG_PUB.count_and_get(

Line 1836: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1832: ROLLBACK TO update_event_header;
1833: x_return_status := FND_API.g_ret_sts_unexp_error ;
1834:
1835: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1836: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1837: END IF;
1838:
1839: FND_MSG_PUB.count_and_get(
1840: p_encoded => FND_API.g_false,

Line 1839: FND_MSG_PUB.count_and_get(

1835: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1836: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1837: END IF;
1838:
1839: FND_MSG_PUB.count_and_get(
1840: p_encoded => FND_API.g_false,
1841: p_count => x_msg_count,
1842: p_data => x_msg_data
1843: );

Line 1882: FND_MSG_PUB.initialize;

1878: AMS_Utility_PVT.debug_message(l_full_name||': start');
1879: END IF;
1880:
1881: IF FND_API.to_boolean(p_init_msg_list) THEN
1882: FND_MSG_PUB.initialize;
1883: END IF;
1884:
1885: IF NOT FND_API.compatible_api_call(
1886: l_api_version,

Line 1967: FND_MSG_PUB.count_and_get(

1963: END IF;
1964: END IF;
1965:
1966: -------------------- finish --------------------------
1967: FND_MSG_PUB.count_and_get(
1968: p_encoded => FND_API.g_false,
1969: p_count => x_msg_count,
1970: p_data => x_msg_data
1971: );

Line 1985: FND_MSG_PUB.count_and_get(

1981: EXCEPTION
1982:
1983: WHEN FND_API.g_exc_error THEN
1984: x_return_status := FND_API.g_ret_sts_error;
1985: FND_MSG_PUB.count_and_get(
1986: p_encoded => FND_API.g_false,
1987: p_count => x_msg_count,
1988: p_data => x_msg_data
1989: );

Line 1993: FND_MSG_PUB.count_and_get(

1989: );
1990:
1991: WHEN FND_API.g_exc_unexpected_error THEN
1992: x_return_status := FND_API.g_ret_sts_unexp_error ;
1993: FND_MSG_PUB.count_and_get(
1994: p_encoded => FND_API.g_false,
1995: p_count => x_msg_count,
1996: p_data => x_msg_data
1997: );

Line 2001: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1997: );
1998:
1999: WHEN OTHERS THEN
2000: x_return_status := FND_API.g_ret_sts_unexp_error;
2001: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2002: THEN
2003: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2004: END IF;
2005:

Line 2003: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1999: WHEN OTHERS THEN
2000: x_return_status := FND_API.g_ret_sts_unexp_error;
2001: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2002: THEN
2003: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2004: END IF;
2005:
2006: FND_MSG_PUB.count_and_get(
2007: p_encoded => FND_API.g_false,

Line 2006: FND_MSG_PUB.count_and_get(

2002: THEN
2003: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2004: END IF;
2005:
2006: FND_MSG_PUB.count_and_get(
2007: p_encoded => FND_API.g_false,
2008: p_count => x_msg_count,
2009: p_data => x_msg_data
2010: );

Line 2064: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2060: END IF;
2061:
2062: ------------------------ owner_user_id --------------------------
2063: IF p_evh_rec.owner_user_id IS NULL THEN
2064: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2065: THEN
2066: FND_MESSAGE.set_name('AMS', 'AMS_EVH_NO_OWNER_ID');
2067: FND_MSG_PUB.add;
2068: END IF;

Line 2067: FND_MSG_PUB.add;

2063: IF p_evh_rec.owner_user_id IS NULL THEN
2064: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2065: THEN
2066: FND_MESSAGE.set_name('AMS', 'AMS_EVH_NO_OWNER_ID');
2067: FND_MSG_PUB.add;
2068: END IF;
2069: x_return_status := FND_API.g_ret_sts_error;
2070: RETURN;
2071: END IF;

Line 2083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2079: -------------------- required only for MAIN event_level------
2080: IF p_evh_rec.event_level = 'MAIN' AND
2081: p_evh_rec.event_type_code IS NULL THEN
2082:
2083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2084: THEN
2085: FND_MESSAGE.set_name('AMS', 'AMS_EVH_NO_EVENT_TYPE_CODE');
2086: FND_MSG_PUB.add;
2087: END IF;

Line 2086: FND_MSG_PUB.add;

2082:
2083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2084: THEN
2085: FND_MESSAGE.set_name('AMS', 'AMS_EVH_NO_EVENT_TYPE_CODE');
2086: FND_MSG_PUB.add;
2087: END IF;
2088:
2089: x_return_status := FND_API.g_ret_sts_error;
2090: RETURN;

Line 2095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2091:
2092: END IF;
2093: ------------------------ event_level --------------------------
2094: IF p_evh_rec.event_level IS NULL THEN
2095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2096: THEN
2097: FND_MESSAGE.set_name('AMS', 'AMS_EVH_NO_EVENT_LEVEL');
2098: FND_MSG_PUB.add;
2099: END IF;

Line 2098: FND_MSG_PUB.add;

2094: IF p_evh_rec.event_level IS NULL THEN
2095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2096: THEN
2097: FND_MESSAGE.set_name('AMS', 'AMS_EVH_NO_EVENT_LEVEL');
2098: FND_MSG_PUB.add;
2099: END IF;
2100:
2101: x_return_status := FND_API.g_ret_sts_error;
2102: RETURN;

Line 2106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2102: RETURN;
2103: END IF;
2104: ------------------------ event_header_name --------------------------
2105: IF p_evh_rec.event_header_name IS NULL THEN
2106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2107: THEN
2108: FND_MESSAGE.set_name('AMS', 'AMS_EVH_NO_NAME');
2109: FND_MSG_PUB.add;
2110: END IF;

Line 2109: FND_MSG_PUB.add;

2105: IF p_evh_rec.event_header_name IS NULL THEN
2106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2107: THEN
2108: FND_MESSAGE.set_name('AMS', 'AMS_EVH_NO_NAME');
2109: FND_MSG_PUB.add;
2110: END IF;
2111: x_return_status := FND_API.g_ret_sts_error;
2112: RETURN;
2113: END IF;

Line 2117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2113: END IF;
2114:
2115: ------------------------ application_id --------------------------
2116: IF p_evh_rec.application_id IS NULL THEN
2117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2118: THEN
2119: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
2120: FND_MSG_PUB.add;
2121: END IF;

Line 2120: FND_MSG_PUB.add;

2116: IF p_evh_rec.application_id IS NULL THEN
2117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2118: THEN
2119: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
2120: FND_MSG_PUB.add;
2121: END IF;
2122:
2123: x_return_status := FND_API.g_ret_sts_error;
2124: RETURN;

Line 2130: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2126:
2127: ------------------------ custom_setup_id --------------------------
2128: IF (p_evh_rec.event_level = 'MAIN' AND
2129: (p_evh_rec.custom_setup_id IS NULL OR p_evh_rec.custom_setup_id = FND_API.g_miss_num)) THEN
2130: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2131: THEN
2132: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_SETUP_ID'); -- this message is generic enuf for EVO or EVH
2133: FND_MSG_PUB.add;
2134: END IF;

Line 2133: FND_MSG_PUB.add;

2129: (p_evh_rec.custom_setup_id IS NULL OR p_evh_rec.custom_setup_id = FND_API.g_miss_num)) THEN
2130: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2131: THEN
2132: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_SETUP_ID'); -- this message is generic enuf for EVO or EVH
2133: FND_MSG_PUB.add;
2134: END IF;
2135: x_return_status := FND_API.g_ret_sts_error;
2136: RETURN;
2137: END IF;

Line 2190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2186: 'ams_event_headers_vl',
2187: 'event_header_id = ' || p_evh_rec.event_header_id
2188: ) = FND_API.g_false
2189: THEN
2190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2191: THEN
2192: FND_MESSAGE.set_name('AMS', 'AMS_EVH_DUPLICATE_ID');
2193: FND_MSG_PUB.add;
2194: END IF;

Line 2193: FND_MSG_PUB.add;

2189: THEN
2190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2191: THEN
2192: FND_MESSAGE.set_name('AMS', 'AMS_EVH_DUPLICATE_ID');
2193: FND_MSG_PUB.add;
2194: END IF;
2195: x_return_status := FND_API.g_ret_sts_error;
2196: RETURN;
2197: END IF;

Line 2221: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2217: AMS_UTILITY_PVt.debug_message('the value of l_dummy is '||l_dummy);
2218: END IF;
2219: IF l_dummy = 1
2220: THEN
2221: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2222: THEN
2223: FND_MESSAGE.set_name('AMS', 'AMS_EVH_DUPLICATE_SOURCE_CODE');
2224: FND_MSG_PUB.add;
2225: END IF;

Line 2224: FND_MSG_PUB.add;

2220: THEN
2221: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2222: THEN
2223: FND_MESSAGE.set_name('AMS', 'AMS_EVH_DUPLICATE_SOURCE_CODE');
2224: FND_MSG_PUB.add;
2225: END IF;
2226: x_return_status := FND_API.g_ret_sts_error;
2227: RETURN;
2228: END IF;

Line 2240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2236: IF NECESSARY.
2237: HOWEVER, SOURCE CODE CANNOT BE CHANGED IF STATUS <> NEW... CHECKED IN BUSINESS RULES AS WELL...
2238:
2239: ELSIF p_evh_rec.source_code <> FND_API.g_miss_char THEN
2240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2241: THEN
2242: FND_MESSAGE.set_name('AMS', 'AMS_EVH_CANT_UPD_SRCCODE');
2243: FND_MSG_PUB.add;
2244: END IF;

Line 2243: FND_MSG_PUB.add;

2239: ELSIF p_evh_rec.source_code <> FND_API.g_miss_char THEN
2240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2241: THEN
2242: FND_MESSAGE.set_name('AMS', 'AMS_EVH_CANT_UPD_SRCCODE');
2243: FND_MSG_PUB.add;
2244: END IF;
2245: x_return_status := FND_API.g_ret_sts_error;
2246: RETURN;
2247: */

Line 2291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2287: 'resource_id',
2288: p_evh_rec.owner_user_id
2289: ) = FND_API.g_false
2290: THEN
2291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2292: THEN
2293: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_OWNER_USER_ID');
2294: FND_MSG_PUB.add;
2295: END IF;

Line 2294: FND_MSG_PUB.add;

2290: THEN
2291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2292: THEN
2293: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_OWNER_USER_ID');
2294: FND_MSG_PUB.add;
2295: END IF;
2296: x_return_status := FND_API.g_ret_sts_error;
2297: RETURN;
2298: END IF;

Line 2310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2306: 'application_id',
2307: p_evh_rec.application_id
2308: ) = FND_API.g_false
2309: THEN
2310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2311: THEN
2312: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_APPLICATION_ID');
2313: FND_MSG_PUB.add;
2314: END IF;

Line 2313: FND_MSG_PUB.add;

2309: THEN
2310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2311: THEN
2312: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_APPLICATION_ID');
2313: FND_MSG_PUB.add;
2314: END IF;
2315: x_return_status := FND_API.g_ret_sts_error;
2316: RETURN;
2317: END IF;

Line 2331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2327: p_evh_rec.inbound_script_name,
2328: AMS_Utility_PVT.g_varchar2
2329: ) = FND_API.g_false
2330: THEN
2331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2332: THEN
2333: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_INBOUND_SCRIPT');
2334: FND_MSG_PUB.add;
2335: END IF;

Line 2334: FND_MSG_PUB.add;

2330: THEN
2331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2332: THEN
2333: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_INBOUND_SCRIPT');
2334: FND_MSG_PUB.add;
2335: END IF;
2336: x_return_status := FND_API.g_ret_sts_error;
2337: RETURN;
2338: END IF;

Line 2349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2345: 'event_header_id',
2346: p_evh_rec.parent_event_header_id
2347: ) = FND_API.g_false
2348: THEN
2349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2350: THEN
2351: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_PARENT_EVEH');
2352: FND_MSG_PUB.add;
2353: END IF;

Line 2352: FND_MSG_PUB.add;

2348: THEN
2349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2350: THEN
2351: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_PARENT_EVEH');
2352: FND_MSG_PUB.add;
2353: END IF;
2354:
2355: x_return_status := FND_API.g_ret_sts_error;
2356: RETURN;

Line 2368: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2364: 'CAMPAIGN_ID',
2365: p_evh_rec.program_id
2366: ) = FND_API.g_false
2367: THEN
2368: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2369: THEN
2370: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_PARENT_EVEH');
2371: FND_MSG_PUB.add;
2372: END IF;

Line 2371: FND_MSG_PUB.add;

2367: THEN
2368: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2369: THEN
2370: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_PARENT_EVEH');
2371: FND_MSG_PUB.add;
2372: END IF;
2373:
2374: x_return_status := FND_API.g_ret_sts_error;
2375: RETURN;

Line 2390: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2386: p_evh_rec.currency_code_tc,
2387: AMS_Utility_PVT.g_varchar2
2388: ) = FND_API.g_false
2389: THEN
2390: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2391: THEN
2392: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CURRENCY_CODE_TC');
2393: FND_MSG_PUB.add;
2394: END IF;

Line 2393: FND_MSG_PUB.add;

2389: THEN
2390: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2391: THEN
2392: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CURRENCY_CODE_TC');
2393: FND_MSG_PUB.add;
2394: END IF;
2395: x_return_status := FND_API.g_ret_sts_error;
2396: RETURN;
2397: END IF;

Line 2411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2407: p_evh_rec.currency_code_fc,
2408: AMS_Utility_PVT.g_varchar2
2409: ) = FND_API.g_false
2410: THEN
2411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2412: THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CURRENCY_CODE_FC');
2414: FND_MSG_PUB.add;
2415: END IF;

Line 2414: FND_MSG_PUB.add;

2410: THEN
2411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2412: THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CURRENCY_CODE_FC');
2414: FND_MSG_PUB.add;
2415: END IF;
2416: x_return_status := FND_API.g_ret_sts_error;
2417: RETURN;
2418: END IF;

Line 2428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2424: 'user_status_id',
2425: p_evh_rec.user_status_id
2426: ) = FND_API.g_false
2427: THEN
2428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2429: THEN
2430: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_USER_STATUS_ID');
2431: FND_MSG_PUB.add;
2432: END IF;

Line 2431: FND_MSG_PUB.add;

2427: THEN
2428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2429: THEN
2430: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_USER_STATUS_ID');
2431: FND_MSG_PUB.add;
2432: END IF;
2433: x_return_status := FND_API.g_ret_sts_error;
2434: RETURN;
2435: END IF;

Line 2478: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2474: AMS_Utility_PVT.g_varchar2,
2475: NULL
2476: ) = FND_API.g_false
2477: THEN
2478: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2479: THEN
2480: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_CITY');
2481: FND_MSG_PUB.add;
2482: END IF;

Line 2481: FND_MSG_PUB.add;

2477: THEN
2478: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2479: THEN
2480: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_CITY');
2481: FND_MSG_PUB.add;
2482: END IF;
2483: x_return_status := FND_API.g_ret_sts_error;
2484: RETURN;
2485: END IF;

Line 2523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2519: p_lookup_type => 'AMS_EVENT_STATUS',
2520: p_lookup_code => p_evh_rec.system_status_code
2521: ) = FND_API.g_false
2522: THEN
2523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2524: THEN
2525: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_STATUS_CODE');
2526: FND_MSG_PUB.add;
2527: END IF;

Line 2526: FND_MSG_PUB.add;

2522: THEN
2523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2524: THEN
2525: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_STATUS_CODE');
2526: FND_MSG_PUB.add;
2527: END IF;
2528:
2529: x_return_status := FND_API.g_ret_sts_error;
2530: RETURN;

Line 2550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2546: p_lookup_type => 'AMS_EVENT_TYPE',
2547: p_lookup_code => p_evh_rec.event_type_code
2548: ) = FND_API.g_false
2549: THEN
2550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2551: THEN
2552: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_TYPE');
2553: FND_MSG_PUB.add;
2554: END IF;

Line 2553: FND_MSG_PUB.add;

2549: THEN
2550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2551: THEN
2552: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_TYPE');
2553: FND_MSG_PUB.add;
2554: END IF;
2555: x_return_status := FND_API.g_ret_sts_error;
2556: RETURN;
2557: END IF;

Line 2569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2565: p_lookup_type => 'AMS_EVENT_LEVEL',
2566: p_lookup_code => p_evh_rec.event_level
2567: ) = FND_API.g_false
2568: THEN
2569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2570: THEN
2571: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_EVENT_LEVEL');
2572: FND_MSG_PUB.add;
2573: END IF;

Line 2572: FND_MSG_PUB.add;

2568: THEN
2569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2570: THEN
2571: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_EVENT_LEVEL');
2572: FND_MSG_PUB.add;
2573: END IF;
2574: x_return_status := FND_API.g_ret_sts_error;
2575: RETURN;
2576: END IF;

Line 2588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2584: p_lookup_type => 'AMS_PRIORITY',
2585: p_lookup_code => p_evh_rec.priority_type_code
2586: ) = FND_API.g_false
2587: THEN
2588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2589: THEN
2590: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_PRIORITY');
2591: FND_MSG_PUB.add;
2592: END IF;

Line 2591: FND_MSG_PUB.add;

2587: THEN
2588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2589: THEN
2590: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_PRIORITY');
2591: FND_MSG_PUB.add;
2592: END IF;
2593: x_return_status := FND_API.g_ret_sts_error;
2594: RETURN;
2595: END IF;

Line 2608: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2604: p_lookup_type => 'AMS_FUND_SOURCE',
2605: p_lookup_code => p_evh_rec.fund_source_type_code
2606: ) = FND_API.g_false
2607: THEN
2608: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2609: THEN
2610: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_FUND_SOURCE');
2611: FND_MSG_PUB.add;
2612: END IF;

Line 2611: FND_MSG_PUB.add;

2607: THEN
2608: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2609: THEN
2610: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_FUND_SOURCE');
2611: FND_MSG_PUB.add;
2612: END IF;
2613: x_return_status := FND_API.g_ret_sts_error;
2614: RETURN;
2615: END IF;

Line 2627: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2623: p_lookup_type => 'AMS_EVENT_DAY',
2624: p_lookup_code => p_evh_rec.day_of_event
2625: ) = FND_API.g_false
2626: THEN
2627: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2628: THEN
2629: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_DAY_OF_EVENT');
2630: FND_MSG_PUB.add;
2631: END IF;

Line 2630: FND_MSG_PUB.add;

2626: THEN
2627: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2628: THEN
2629: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_DAY_OF_EVENT');
2630: FND_MSG_PUB.add;
2631: END IF;
2632: x_return_status := FND_API.g_ret_sts_error;
2633: RETURN;
2634: END IF;

Line 2646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2642: p_lookup_type => 'AMS_EVENT_CERT_CREDIT_TYPE',
2643: p_lookup_code => p_evh_rec.cert_credit_type_code
2644: ) = FND_API.g_false
2645: THEN
2646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2647: THEN
2648: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CERT_CREDIT_TYPE');
2649: FND_MSG_PUB.add;
2650: END IF;

Line 2649: FND_MSG_PUB.add;

2645: THEN
2646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2647: THEN
2648: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CERT_CREDIT_TYPE');
2649: FND_MSG_PUB.add;
2650: END IF;
2651: x_return_status := FND_API.g_ret_sts_error;
2652: RETURN;
2653: END IF;

Line 2665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2661: p_lookup_type => 'AMS_EVENT_CANCEL_REASON',
2662: p_lookup_code => p_evh_rec.cancellation_reason_code
2663: ) = FND_API.g_false
2664: THEN
2665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2666: THEN
2667: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CANCEL_REASON');
2668: FND_MSG_PUB.add;
2669: END IF;

Line 2668: FND_MSG_PUB.add;

2664: THEN
2665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2666: THEN
2667: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CANCEL_REASON');
2668: FND_MSG_PUB.add;
2669: END IF;
2670: x_return_status := FND_API.g_ret_sts_error;
2671: RETURN;
2672: END IF;

Line 2684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2680: p_lookup_type => 'AMS_EVENT_STREAM_TYPE',
2681: p_lookup_code => p_evh_rec.stream_type_code
2682: ) = FND_API.g_false
2683: THEN
2684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2685: THEN
2686: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_STREAM_TYPE');
2687: FND_MSG_PUB.add;
2688: END IF;

Line 2687: FND_MSG_PUB.add;

2683: THEN
2684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2685: THEN
2686: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_STREAM_TYPE');
2687: FND_MSG_PUB.add;
2688: END IF;
2689: x_return_status := FND_API.g_ret_sts_error;
2690: RETURN;
2691: END IF;

Line 2733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2729: AND p_evh_rec.active_flag IS NOT NULL
2730: THEN
2731: IF AMS_Utility_PVT.is_Y_or_N(p_evh_rec.active_flag) = FND_API.g_false
2732: THEN
2733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2734: THEN
2735: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_ACTIVE_FLAG');
2736: FND_MSG_PUB.add;
2737: END IF;

Line 2736: FND_MSG_PUB.add;

2732: THEN
2733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2734: THEN
2735: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_ACTIVE_FLAG');
2736: FND_MSG_PUB.add;
2737: END IF;
2738: x_return_status := FND_API.g_ret_sts_error;
2739: RETURN;
2740: END IF;

Line 2749: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2745: AND p_evh_rec.event_standalone_flag IS NOT NULL
2746: THEN
2747: IF AMS_Utility_PVT.is_Y_or_N(p_evh_rec.event_standalone_flag) = FND_API.g_false
2748: THEN
2749: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2750: THEN
2751: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_STANDALONE_FL');
2752: FND_MSG_PUB.add;
2753: END IF;

Line 2752: FND_MSG_PUB.add;

2748: THEN
2749: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2750: THEN
2751: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_STANDALONE_FL');
2752: FND_MSG_PUB.add;
2753: END IF;
2754: x_return_status := FND_API.g_ret_sts_error;
2755: RETURN;
2756: END IF;

Line 2765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2761: AND p_evh_rec.private_flag IS NOT NULL
2762: THEN
2763: IF AMS_Utility_PVT.is_Y_or_N(p_evh_rec.private_flag) = FND_API.g_false
2764: THEN
2765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2766: THEN
2767: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_PRIVATE_FLAG');
2768: FND_MSG_PUB.add;
2769: END IF;

Line 2768: FND_MSG_PUB.add;

2764: THEN
2765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2766: THEN
2767: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_PRIVATE_FLAG');
2768: FND_MSG_PUB.add;
2769: END IF;
2770: x_return_status := FND_API.g_ret_sts_error;
2771: RETURN;
2772: END IF;

Line 2781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2777: AND p_evh_rec.reg_required_flag IS NOT NULL
2778: THEN
2779: IF AMS_Utility_PVT.is_Y_or_N(p_evh_rec.reg_required_flag) = FND_API.g_false
2780: THEN
2781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2782: THEN
2783: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_REG_REQUIRED_FLAG');
2784: FND_MSG_PUB.add;
2785: END IF;

Line 2784: FND_MSG_PUB.add;

2780: THEN
2781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2782: THEN
2783: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_REG_REQUIRED_FLAG');
2784: FND_MSG_PUB.add;
2785: END IF;
2786:
2787: x_return_status := FND_API.g_ret_sts_error;
2788: RETURN;

Line 2798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2794: AND p_evh_rec.reg_invited_only_flag IS NOT NULL
2795: THEN
2796: IF AMS_Utility_PVT.is_Y_or_N(p_evh_rec.reg_invited_only_flag) = FND_API.g_false
2797: THEN
2798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2799: THEN
2800: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_REG_INV_ONLY');
2801: FND_MSG_PUB.add;
2802: END IF;

Line 2801: FND_MSG_PUB.add;

2797: THEN
2798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2799: THEN
2800: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_REG_INV_ONLY');
2801: FND_MSG_PUB.add;
2802: END IF;
2803:
2804: x_return_status := FND_API.g_ret_sts_error;
2805: RETURN;

Line 2815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2811: AND p_evh_rec.reg_charge_flag IS NOT NULL
2812: THEN
2813: IF AMS_Utility_PVT.is_Y_or_N(p_evh_rec.reg_charge_flag) = FND_API.g_false
2814: THEN
2815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2816: THEN
2817: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_REG_CHARGE_FLAG');
2818: FND_MSG_PUB.add;
2819: END IF;

Line 2818: FND_MSG_PUB.add;

2814: THEN
2815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2816: THEN
2817: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_REG_CHARGE_FLAG');
2818: FND_MSG_PUB.add;
2819: END IF;
2820:
2821: x_return_status := FND_API.g_ret_sts_error;
2822: RETURN;

Line 2833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2829: AND p_evh_rec.overflow_flag IS NOT NULL
2830: THEN
2831: IF AMS_Utility_PVT.is_Y_or_N(p_evh_rec.overflow_flag) = FND_API.g_false
2832: THEN
2833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2834: THEN
2835: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_OVERFLOW_FLAG');
2836: FND_MSG_PUB.add;
2837: END IF;

Line 2836: FND_MSG_PUB.add;

2832: THEN
2833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2834: THEN
2835: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_OVERFLOW_FLAG');
2836: FND_MSG_PUB.add;
2837: END IF;
2838:
2839: x_return_status := FND_API.g_ret_sts_error;
2840: RETURN;

Line 2993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2989: AMS_Utility_PVT.debug_message('L_END_DATE:'||to_char(l_end_date,'DD-MON-YYY'));
2990: END IF;
2991:
2992: IF (l_start_date > l_end_date) THEN
2993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2994: THEN
2995: FND_MESSAGE.set_name('AMS', 'AMS_EVH_START_DT_GT_END_DT');
2996: FND_MSG_PUB.add;
2997: END IF;

Line 2996: FND_MSG_PUB.add;

2992: IF (l_start_date > l_end_date) THEN
2993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2994: THEN
2995: FND_MESSAGE.set_name('AMS', 'AMS_EVH_START_DT_GT_END_DT');
2996: FND_MSG_PUB.add;
2997: END IF;
2998: x_return_status := FND_API.g_ret_sts_error;
2999: RAISE Fnd_Api.g_exc_error;
3000: return;

Line 3021: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3017: l_end_time := p_evh_rec.agenda_end_time;
3018: END IF;
3019:
3020: IF l_start_time > l_end_time THEN
3021: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3022: THEN
3023: FND_MESSAGE.set_name('AMS', 'AMS_EVO_START_TM_GT_END_TM'); -- reusing EVEO message
3024: FND_MSG_PUB.add;
3025: END IF;

Line 3024: FND_MSG_PUB.add;

3020: IF l_start_time > l_end_time THEN
3021: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3022: THEN
3023: FND_MESSAGE.set_name('AMS', 'AMS_EVO_START_TM_GT_END_TM'); -- reusing EVEO message
3024: FND_MSG_PUB.add;
3025: END IF;
3026: x_return_status := FND_API.g_ret_sts_error;
3027: RAISE Fnd_Api.g_exc_error;
3028: return;

Line 3351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3347: OPEN c_evh;
3348: FETCH c_evh INTO l_evh_rec;
3349: IF c_evh%NOTFOUND THEN
3350: CLOSE c_evh;
3351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3352: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3353: FND_MSG_PUB.add;
3354: END IF;
3355: RAISE FND_API.g_exc_error;

Line 3353: FND_MSG_PUB.add;

3349: IF c_evh%NOTFOUND THEN
3350: CLOSE c_evh;
3351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3352: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3353: FND_MSG_PUB.add;
3354: END IF;
3355: RAISE FND_API.g_exc_error;
3356: END IF;
3357: CLOSE c_evh;

Line 3363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3359: OPEN c_setup;
3360: FETCH c_setup INTO l_setup;
3361: IF c_setup%NOTFOUND THEN
3362: CLOSE c_setup;
3363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3364: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3365: FND_MSG_PUB.add;
3366: END IF;
3367: RAISE FND_API.g_exc_error;

Line 3365: FND_MSG_PUB.add;

3361: IF c_setup%NOTFOUND THEN
3362: CLOSE c_setup;
3363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3364: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3365: FND_MSG_PUB.add;
3366: END IF;
3367: RAISE FND_API.g_exc_error;
3368: END IF;
3369: CLOSE c_setup;

Line 3712: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

3708: --WHEN OTHERS THEN
3709: -- ROLLBACK TO update_campaign;
3710: --x_return_status := FND_API.g_ret_sts_unexp_error;
3711:
3712: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3713: --THEN
3714: --FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3715: --END IF;
3716:

Line 3714: --FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3710: --x_return_status := FND_API.g_ret_sts_unexp_error;
3711:
3712: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3713: --THEN
3714: --FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3715: --END IF;
3716:
3717: --FND_MSG_PUB.count_and_get(
3718: -- p_encoded => FND_API.g_false,

Line 3717: --FND_MSG_PUB.count_and_get(

3713: --THEN
3714: --FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3715: --END IF;
3716:
3717: --FND_MSG_PUB.count_and_get(
3718: -- p_encoded => FND_API.g_false,
3719: -- p_count => x_msg_count,
3720: -- p_data => x_msg_data
3721: --);

Line 3809: Fnd_Msg_Pub.ADD;

3805:
3806: Ams_Utility_Pvt.debug_message('The Parent is not Active');
3807: END IF;
3808: Fnd_Message.set_name('AMS', 'AMS_PROGRAM_NOT_ACTIVE');
3809: Fnd_Msg_Pub.ADD;
3810: x_return_status := Fnd_Api.g_ret_sts_error;
3811: RETURN;
3812: END IF;
3813:

Line 3858: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

3854: IF (AMS_DEBUG_HIGH_ON) THEN
3855:
3856: Ams_Utility_Pvt.debug_message('The start date of Event can not be lesser than that of Program');
3857: END IF;
3858: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3859: Fnd_Message.set_name('AMS', 'AMS_EVT_STDT_LS_PRG_STDT');
3860: Fnd_Msg_Pub.ADD;
3861: x_return_status := Fnd_Api.g_ret_sts_error;
3862: RETURN;

Line 3860: Fnd_Msg_Pub.ADD;

3856: Ams_Utility_Pvt.debug_message('The start date of Event can not be lesser than that of Program');
3857: END IF;
3858: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3859: Fnd_Message.set_name('AMS', 'AMS_EVT_STDT_LS_PRG_STDT');
3860: Fnd_Msg_Pub.ADD;
3861: x_return_status := Fnd_Api.g_ret_sts_error;
3862: RETURN;
3863: END IF;
3864: END IF;

Line 3873: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

3869: IF (AMS_DEBUG_HIGH_ON) THEN
3870:
3871: Ams_Utility_Pvt.debug_message('The end date of Event can not be greater than that of Program');
3872: END IF;
3873: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3874: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_PRG_EDDT');
3875: Fnd_Msg_Pub.ADD;
3876: x_return_status := Fnd_Api.g_ret_sts_error;
3877: RETURN;

Line 3875: Fnd_Msg_Pub.ADD;

3871: Ams_Utility_Pvt.debug_message('The end date of Event can not be greater than that of Program');
3872: END IF;
3873: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3874: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_PRG_EDDT');
3875: Fnd_Msg_Pub.ADD;
3876: x_return_status := Fnd_Api.g_ret_sts_error;
3877: RETURN;
3878: END IF;
3879: END IF;

Line 3886: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

3882: IF (AMS_DEBUG_HIGH_ON) THEN
3883:
3884: Ams_Utility_Pvt.debug_message('The end date of Event can not be greater than that of Program');
3885: END IF;
3886: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3887: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_PRG_EDDT');
3888: Fnd_Msg_Pub.ADD;
3889: x_return_status := Fnd_Api.g_ret_sts_error;
3890: RETURN;

Line 3888: Fnd_Msg_Pub.ADD;

3884: Ams_Utility_Pvt.debug_message('The end date of Event can not be greater than that of Program');
3885: END IF;
3886: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3887: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_PRG_EDDT');
3888: Fnd_Msg_Pub.ADD;
3889: x_return_status := Fnd_Api.g_ret_sts_error;
3890: RETURN;
3891: END IF;
3892: END IF;

Line 3902: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

3898: IF (l_eveo_rec.start_date < p_evh_rec.active_from_date) THEN
3899: IF (AMS_DEBUG_HIGH_ON) THEN
3900: Ams_Utility_Pvt.debug_message('The start date of an Offer can not be lesser than that of Event');
3901: END IF;
3902: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3903: Fnd_Message.set_name('AMS', 'AMS_EVEO_STDT_LS_EVT_STDT');
3904: Fnd_Msg_Pub.ADD;
3905: x_return_status := Fnd_Api.g_ret_sts_error;
3906: RETURN;

Line 3904: Fnd_Msg_Pub.ADD;

3900: Ams_Utility_Pvt.debug_message('The start date of an Offer can not be lesser than that of Event');
3901: END IF;
3902: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3903: Fnd_Message.set_name('AMS', 'AMS_EVEO_STDT_LS_EVT_STDT');
3904: Fnd_Msg_Pub.ADD;
3905: x_return_status := Fnd_Api.g_ret_sts_error;
3906: RETURN;
3907: END IF;
3908: END IF;

Line 3913: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

3909: ELSIF(p_evh_rec.active_from_date IS NULL AND l_eveo_rec.start_date IS NOT NULL) THEN
3910: IF (AMS_DEBUG_HIGH_ON) THEN
3911: Ams_Utility_Pvt.debug_message('The start date of an Offer can not be lesser than that of Event');
3912: END IF;
3913: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3914: Fnd_Message.set_name('AMS', 'AMS_EVEO_STDT_LS_EVT_STDT');
3915: Fnd_Msg_Pub.ADD;
3916: x_return_status := Fnd_Api.g_ret_sts_error;
3917: RETURN;

Line 3915: Fnd_Msg_Pub.ADD;

3911: Ams_Utility_Pvt.debug_message('The start date of an Offer can not be lesser than that of Event');
3912: END IF;
3913: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3914: Fnd_Message.set_name('AMS', 'AMS_EVEO_STDT_LS_EVT_STDT');
3915: Fnd_Msg_Pub.ADD;
3916: x_return_status := Fnd_Api.g_ret_sts_error;
3917: RETURN;
3918: END IF;
3919: END IF;

Line 3929: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

3925: IF (AMS_DEBUG_HIGH_ON) THEN
3926:
3927: Ams_Utility_Pvt.debug_message('The end date of Event can not be lesser than that of Offer');
3928: END IF;
3929: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3930: Fnd_Message.set_name('AMS', 'AMS_EVEO_EDDT_GT_EVT_EDDT');
3931: Fnd_Msg_Pub.ADD;
3932: x_return_status := Fnd_Api.g_ret_sts_error;
3933: RETURN;

Line 3931: Fnd_Msg_Pub.ADD;

3927: Ams_Utility_Pvt.debug_message('The end date of Event can not be lesser than that of Offer');
3928: END IF;
3929: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3930: Fnd_Message.set_name('AMS', 'AMS_EVEO_EDDT_GT_EVT_EDDT');
3931: Fnd_Msg_Pub.ADD;
3932: x_return_status := Fnd_Api.g_ret_sts_error;
3933: RETURN;
3934: END IF;
3935: END IF;

Line 3941: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

3937: IF (AMS_DEBUG_HIGH_ON) THEN
3938:
3939: Ams_Utility_Pvt.debug_message('The end date of Offer can not be greater than that of Event');
3940: END IF;
3941: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3942: Fnd_Message.set_name('AMS', 'AMS_EVEO_EDDT_GT_EVT_EDDT');
3943: Fnd_Msg_Pub.ADD;
3944: x_return_status := Fnd_Api.g_ret_sts_error;
3945: RETURN;

Line 3943: Fnd_Msg_Pub.ADD;

3939: Ams_Utility_Pvt.debug_message('The end date of Offer can not be greater than that of Event');
3940: END IF;
3941: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
3942: Fnd_Message.set_name('AMS', 'AMS_EVEO_EDDT_GT_EVT_EDDT');
3943: Fnd_Msg_Pub.ADD;
3944: x_return_status := Fnd_Api.g_ret_sts_error;
3945: RETURN;
3946: END IF;
3947: END IF;