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.AMS_ACT_MARKET_SEGMENTS_PVT dependencies on FND_MSG_PUB

Line 52: FND_MSG_PUB.initialize;

48:
49: AMS_Utility_PVT.debug_message(l_full_name || ': start');
50:
51: IF FND_API.to_boolean(p_init_msg_list) THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:
55: IF NOT FND_API.compatible_api_call
56: (

Line 210: FND_MSG_PUB.count_and_get

206: IF FND_API.to_boolean(p_commit) THEN
207: COMMIT;
208: END IF;
209:
210: FND_MSG_PUB.count_and_get
211: (
212: p_encoded => FND_API.g_false,
213: p_count => x_msg_count,
214: p_data => x_msg_data

Line 224: FND_MSG_PUB.count_and_get

220:
221: WHEN FND_API.g_exc_error THEN
222: ROLLBACK TO create_market_segments;
223: x_return_status := FND_API.g_ret_sts_error;
224: FND_MSG_PUB.count_and_get
225: (
226: p_encoded => FND_API.g_false,
227: p_count => x_msg_count,
228: p_data => x_msg_data

Line 234: FND_MSG_PUB.count_and_get

230:
231: WHEN FND_API.g_exc_unexpected_error THEN
232: ROLLBACK TO create_market_segments;
233: x_return_status := FND_API.g_ret_sts_unexp_error;
234: FND_MSG_PUB.count_and_get
235: (
236: p_encoded => FND_API.g_false,
237: p_count => x_msg_count,
238: p_data => x_msg_data

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

240:
241: WHEN OTHERS THEN
242: ROLLBACK TO create_market_segments;
243: x_return_status :=FND_API.g_ret_sts_unexp_error;
244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
245: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
246: END IF;
247: FND_MSG_PUB.count_and_get
248: (

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

241: WHEN OTHERS THEN
242: ROLLBACK TO create_market_segments;
243: x_return_status :=FND_API.g_ret_sts_unexp_error;
244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
245: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
246: END IF;
247: FND_MSG_PUB.count_and_get
248: (
249: p_encoded => FND_API.g_false,

Line 247: FND_MSG_PUB.count_and_get

243: x_return_status :=FND_API.g_ret_sts_unexp_error;
244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
245: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
246: END IF;
247: FND_MSG_PUB.count_and_get
248: (
249: p_encoded => FND_API.g_false,
250: p_count => x_msg_count,
251: p_data => x_msg_data

Line 291: FND_MSG_PUB.initialize;

287:
288: AMS_Utility_PVT.debug_message(l_full_name || ': start');
289:
290: IF FND_API.to_boolean(p_init_msg_list) THEN
291: FND_MSG_PUB.initialize;
292: END IF;
293:
294: IF NOT FND_API.compatible_api_call
295: (

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

394: WHERE activity_market_segment_id = l_mks_rec.activity_market_segment_id
395: AND object_version_number = l_mks_rec.object_version_number;
396:
397: IF (SQL%NOTFOUND) THEN
398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
399: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
400: FND_MSG_PUB.add;
401: END IF;
402: RAISE FND_API.g_exc_error;

Line 400: FND_MSG_PUB.add;

396:
397: IF (SQL%NOTFOUND) THEN
398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
399: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
400: FND_MSG_PUB.add;
401: END IF;
402: RAISE FND_API.g_exc_error;
403: END IF;
404:

Line 410: FND_MSG_PUB.count_and_get

406: IF FND_API.to_boolean(p_commit) THEN
407: COMMIT;
408: END IF;
409:
410: FND_MSG_PUB.count_and_get
411: (
412: P_ENCODED => FND_API.g_false,
413: p_count => x_msg_count,
414: p_data => x_msg_data

Line 424: FND_MSG_PUB.count_and_get

420:
421: WHEN FND_API.g_exc_error THEN
422: ROLLBACK TO update_market_segments;
423: x_return_status := FND_API.g_ret_sts_error;
424: FND_MSG_PUB.count_and_get
425: (
426: p_encoded => FND_API.g_false,
427: p_count => x_msg_count,
428: p_data => x_msg_data

Line 434: FND_MSG_PUB.count_and_get

430:
431: WHEN FND_API.g_exc_unexpected_error THEN
432: ROLLBACK TO update_market_segments;
433: x_return_status := FND_API.g_ret_sts_unexp_error;
434: FND_MSG_PUB.count_and_get
435: (
436: p_encoded => FND_API.g_false,
437: p_count => x_msg_count,
438: p_data => x_msg_data

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

440:
441: WHEN OTHERS THEN
442: ROLLBACK TO update_market_segments;
443: x_return_status :=FND_API.g_ret_sts_unexp_error;
444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
445: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
446: END IF;
447: FND_MSG_PUB.count_and_get
448: (

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

441: WHEN OTHERS THEN
442: ROLLBACK TO update_market_segments;
443: x_return_status :=FND_API.g_ret_sts_unexp_error;
444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
445: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
446: END IF;
447: FND_MSG_PUB.count_and_get
448: (
449: p_encoded => FND_API.g_false,

Line 447: FND_MSG_PUB.count_and_get

443: x_return_status :=FND_API.g_ret_sts_unexp_error;
444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
445: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
446: END IF;
447: FND_MSG_PUB.count_and_get
448: (
449: p_encoded => FND_API.g_false,
450: p_count => x_msg_count,
451: p_data => x_msg_data

Line 504: FND_MSG_PUB.initialize;

500:
501: AMS_Utility_PVT.debug_message(l_full_name || ': start');
502:
503: IF FND_API.to_boolean(p_init_msg_list) THEN
504: FND_MSG_PUB.initialize;
505: END IF;
506:
507: IF NOT FND_API.compatible_api_call
508: (

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

532: WHERE activity_market_segment_id = p_act_mks_id
533: AND object_version_number = p_object_version;
534:
535: IF (SQL%NOTFOUND) THEN
536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
537: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
538: FND_MSG_PUB.add;
539: END IF;
540: RAISE FND_API.g_exc_error;

Line 538: FND_MSG_PUB.add;

534:
535: IF (SQL%NOTFOUND) THEN
536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
537: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
538: FND_MSG_PUB.add;
539: END IF;
540: RAISE FND_API.g_exc_error;
541: END IF;
542:

Line 581: FND_MSG_PUB.count_and_get

577: IF FND_API.to_boolean(p_commit) THEN
578: COMMIT;
579: END IF;
580:
581: FND_MSG_PUB.count_and_get
582: (
583: P_ENCODED => FND_API.g_false,
584: p_count => x_msg_count,
585: p_data => x_msg_data

Line 595: FND_MSG_PUB.count_and_get

591:
592: WHEN FND_API.g_exc_error THEN
593: ROLLBACK TO delete_market_segments;
594: x_return_status := FND_API.g_ret_sts_error;
595: FND_MSG_PUB.count_and_get
596: (
597: p_encoded => FND_API.g_false,
598: p_count => x_msg_count,
599: p_data => x_msg_data

Line 605: FND_MSG_PUB.count_and_get

601:
602: WHEN FND_API.g_exc_unexpected_error THEN
603: ROLLBACK TO delete_market_segments;
604: x_return_status := FND_API.g_ret_sts_unexp_error;
605: FND_MSG_PUB.count_and_get
606: (
607: p_encoded => FND_API.g_false,
608: p_count => x_msg_count,
609: p_data => x_msg_data

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

611:
612: WHEN OTHERS THEN
613: ROLLBACK TO delete_market_segments;
614: x_return_status :=FND_API.g_ret_sts_unexp_error;
615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
616: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
617: END IF;
618: FND_MSG_PUB.count_and_get
619: (

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

612: WHEN OTHERS THEN
613: ROLLBACK TO delete_market_segments;
614: x_return_status :=FND_API.g_ret_sts_unexp_error;
615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
616: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
617: END IF;
618: FND_MSG_PUB.count_and_get
619: (
620: p_encoded => FND_API.g_false,

Line 618: FND_MSG_PUB.count_and_get

614: x_return_status :=FND_API.g_ret_sts_unexp_error;
615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
616: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
617: END IF;
618: FND_MSG_PUB.count_and_get
619: (
620: p_encoded => FND_API.g_false,
621: p_count => x_msg_count,
622: p_data => x_msg_data

Line 665: FND_MSG_PUB.initialize;

661: -- initialize
662: AMS_Utility_PVT.debug_message(l_full_name || ': start');
663:
664: IF FND_API.to_boolean(p_init_msg_list) THEN
665: FND_MSG_PUB.initialize;
666: END IF;
667:
668: IF NOT FND_API.compatible_api_call
669: (

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

684: OPEN c_obj;
685: FETCH c_obj INTO l_mks_id;
686: IF (c_obj%NOTFOUND) THEN
687: CLOSE c_obj;
688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
689: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
690: FND_MSG_PUB.add;
691: END IF;
692: RAISE FND_API.g_exc_error;

Line 690: FND_MSG_PUB.add;

686: IF (c_obj%NOTFOUND) THEN
687: CLOSE c_obj;
688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
689: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
690: FND_MSG_PUB.add;
691: END IF;
692: RAISE FND_API.g_exc_error;
693: END IF;
694: CLOSE c_obj;

Line 697: FND_MSG_PUB.count_and_get

693: END IF;
694: CLOSE c_obj;
695:
696: -- finish
697: FND_MSG_PUB.count_and_get
698: (
699: p_encoded => FND_API.g_false,
700: p_count => x_msg_count,
701: p_data => x_msg_data

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

706: EXCEPTION
707:
708: WHEN AMS_Utility_PVT.resource_locked THEN
709: x_return_status := FND_API.g_ret_sts_error;
710: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
711: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
712: FND_MSG_PUB.add;
713: END IF;
714: FND_MSG_PUB.count_and_get

Line 712: FND_MSG_PUB.add;

708: WHEN AMS_Utility_PVT.resource_locked THEN
709: x_return_status := FND_API.g_ret_sts_error;
710: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
711: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
712: FND_MSG_PUB.add;
713: END IF;
714: FND_MSG_PUB.count_and_get
715: (
716: p_encoded => FND_API.g_false,

Line 714: FND_MSG_PUB.count_and_get

710: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
711: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
712: FND_MSG_PUB.add;
713: END IF;
714: FND_MSG_PUB.count_and_get
715: (
716: p_encoded => FND_API.g_false,
717: p_count => x_msg_count,
718: p_data => x_msg_data

Line 723: FND_MSG_PUB.count_and_get

719: );
720:
721: WHEN FND_API.g_exc_error THEN
722: x_return_status := FND_API.g_ret_sts_error;
723: FND_MSG_PUB.count_and_get
724: (
725: p_encoded => FND_API.g_false,
726: p_count => x_msg_count,
727: p_data => x_msg_data

Line 732: FND_MSG_PUB.count_and_get

728: );
729:
730: WHEN FND_API.g_exc_unexpected_error THEN
731: x_return_status := FND_API.g_ret_sts_unexp_error;
732: FND_MSG_PUB.count_and_get
733: (
734: p_encoded => FND_API.g_false,
735: p_count => x_msg_count,
736: p_data => x_msg_data

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

737: );
738:
739: WHEN OTHERS THEN
740: x_return_status :=FND_API.g_ret_sts_unexp_error;
741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
742: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
743: END IF;
744: FND_MSG_PUB.count_and_get
745: (

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

738:
739: WHEN OTHERS THEN
740: x_return_status :=FND_API.g_ret_sts_unexp_error;
741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
742: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
743: END IF;
744: FND_MSG_PUB.count_and_get
745: (
746: p_encoded => FND_API.g_false,

Line 744: FND_MSG_PUB.count_and_get

740: x_return_status :=FND_API.g_ret_sts_unexp_error;
741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
742: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
743: END IF;
744: FND_MSG_PUB.count_and_get
745: (
746: p_encoded => FND_API.g_false,
747: p_count => x_msg_count,
748: p_data => x_msg_data

Line 787: FND_MSG_PUB.initialize;

783: -- initialize
784: AMS_Utility_PVT.debug_message(l_full_name || ': start');
785:
786: IF FND_API.to_boolean(p_init_msg_list) THEN
787: FND_MSG_PUB.initialize;
788: END IF;
789:
790: IF NOT FND_API.compatible_api_call
791: (

Line 865: FND_MSG_PUB.count_and_get(

861: END IF;
862: END IF;
863:
864: -------------------- finish --------------------------
865: FND_MSG_PUB.count_and_get(
866: p_encoded => FND_API.g_false,
867: p_count => x_msg_count,
868: p_data => x_msg_data
869: );

Line 877: FND_MSG_PUB.count_and_get(

873: EXCEPTION
874:
875: WHEN FND_API.g_exc_error THEN
876: x_return_status := FND_API.g_ret_sts_error;
877: FND_MSG_PUB.count_and_get(
878: p_encoded => FND_API.g_false,
879: p_count => x_msg_count,
880: p_data => x_msg_data
881: );

Line 885: FND_MSG_PUB.count_and_get(

881: );
882:
883: WHEN FND_API.g_exc_unexpected_error THEN
884: x_return_status := FND_API.g_ret_sts_unexp_error ;
885: FND_MSG_PUB.count_and_get(
886: p_encoded => FND_API.g_false,
887: p_count => x_msg_count,
888: p_data => x_msg_data
889: );

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

889: );
890:
891: WHEN OTHERS THEN
892: x_return_status := FND_API.g_ret_sts_unexp_error;
893: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
894: THEN
895: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
896: END IF;
897:

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

891: WHEN OTHERS THEN
892: x_return_status := FND_API.g_ret_sts_unexp_error;
893: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
894: THEN
895: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
896: END IF;
897:
898: FND_MSG_PUB.count_and_get(
899: p_encoded => FND_API.g_false,

Line 898: FND_MSG_PUB.count_and_get(

894: THEN
895: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
896: END IF;
897:
898: FND_MSG_PUB.count_and_get(
899: p_encoded => FND_API.g_false,
900: p_count => x_msg_count,
901: p_data => x_msg_data
902: );

Line 930: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

926: -- check activity_market_segment_id
927: -- IF p_mks_rec.activity_market_segment_id IS NULL
928: -- AND p_validation_mode = JTF_PLSQL_API.g_update
929: -- THEN
930: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
931: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ACT_MKS_ID');
932: -- FND_MSG_PUB.add;
933: -- END IF;
934: --

Line 932: -- FND_MSG_PUB.add;

928: -- AND p_validation_mode = JTF_PLSQL_API.g_update
929: -- THEN
930: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
931: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ACT_MKS_ID');
932: -- FND_MSG_PUB.add;
933: -- END IF;
934: --
935: -- x_return_status := FND_API.g_ret_sts_error;
936: -- RETURN;

Line 944: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

940: -- check object_version_number
941: -- IF p_mks_rec.object_version_number IS NULL
942: -- AND p_validation_mode = JTF_PLSQL_API.g_update
943: -- THEN
944: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
945: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_OBJ_VER_NUM');
946: -- FND_MSG_PUB.add;
947: -- END IF;
948: --

Line 946: -- FND_MSG_PUB.add;

942: -- AND p_validation_mode = JTF_PLSQL_API.g_update
943: -- THEN
944: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
945: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_OBJ_VER_NUM');
946: -- FND_MSG_PUB.add;
947: -- END IF;
948: --
949: -- x_return_status := FND_API.g_ret_sts_error;
950: -- RETURN;

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

953:
954: -- check market_segment_id
955: /* comment by julou 29-MAY-2001
956: IF p_mks_rec.market_segment_id IS NULL THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_MKS_ID');
959: FND_MSG_PUB.add;
960: END IF;
961:

Line 959: FND_MSG_PUB.add;

955: /* comment by julou 29-MAY-2001
956: IF p_mks_rec.market_segment_id IS NULL THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_MKS_ID');
959: FND_MSG_PUB.add;
960: END IF;
961:
962: x_return_status := FND_API.g_ret_sts_error;
963: RETURN;

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

964: END IF;
965: */
966: -- check act_market_segment_used_by_id
967: IF p_mks_rec.act_market_segment_used_by_id IS NULL THEN
968: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
969: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ACT_MKS_USED_BY_ID');
970: FND_MSG_PUB.add;
971: END IF;
972:

Line 970: FND_MSG_PUB.add;

966: -- check act_market_segment_used_by_id
967: IF p_mks_rec.act_market_segment_used_by_id IS NULL THEN
968: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
969: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ACT_MKS_USED_BY_ID');
970: FND_MSG_PUB.add;
971: END IF;
972:
973: x_return_status := FND_API.g_ret_sts_error;
974: RETURN;

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

975: END IF;
976:
977: -- check arc_act_market_segment_used_by
978: IF p_mks_rec.arc_act_market_segment_used_by IS NULL THEN
979: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
980: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ARC_ACT_MKS_USED_BY');
981: FND_MSG_PUB.add;
982: END IF;
983:

Line 981: FND_MSG_PUB.add;

977: -- check arc_act_market_segment_used_by
978: IF p_mks_rec.arc_act_market_segment_used_by IS NULL THEN
979: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
980: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ARC_ACT_MKS_USED_BY');
981: FND_MSG_PUB.add;
982: END IF;
983:
984: x_return_status := FND_API.g_ret_sts_error;
985: RETURN;

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

989: -- check segment_type
990: -- Commented by skarumur as there is no segment type any more
991:
992: /* IF p_mks_rec.segment_type IS NULL THEN
993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
994: FND_MESSAGE.set_name('AMS', 'AMS_MKS_MISSING_MKS_TYPE');
995: FND_MSG_PUB.add;
996: END IF;
997:

Line 995: FND_MSG_PUB.add;

991:
992: /* IF p_mks_rec.segment_type IS NULL THEN
993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
994: FND_MESSAGE.set_name('AMS', 'AMS_MKS_MISSING_MKS_TYPE');
995: FND_MSG_PUB.add;
996: END IF;
997:
998: x_return_status := FND_API.g_ret_sts_error;
999: RETURN;

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

1023: x_return_status := FND_API.g_ret_sts_success;
1024: /*
1025: IF UPPER(p_mks_rec.arc_act_market_segment_used_by)
1026: NOT IN ('CAMP', 'EVEH', 'EVEO', 'CELL') THEN
1027: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1028: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');
1029: FND_MSG_PUB.add;
1030: END IF;
1031:

Line 1029: FND_MSG_PUB.add;

1025: IF UPPER(p_mks_rec.arc_act_market_segment_used_by)
1026: NOT IN ('CAMP', 'EVEH', 'EVEO', 'CELL') THEN
1027: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1028: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');
1029: FND_MSG_PUB.add;
1030: END IF;
1031:
1032: x_return_status := FND_API.g_ret_sts_error;
1033: RETURN;

Line 1064: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1060: -- 'event_offer_id',
1061: -- p_mks_rec.act_market_segment_used_by_id
1062: -- );
1063: -- ELSE
1064: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1065: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');
1066: -- FND_MSG_PUB.add;
1067: -- END IF;
1068: /* End of Comments by ptendulk on 16-dec-1999 */

Line 1066: -- FND_MSG_PUB.add;

1062: -- );
1063: -- ELSE
1064: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1065: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');
1066: -- FND_MSG_PUB.add;
1067: -- END IF;
1068: /* End of Comments by ptendulk on 16-dec-1999 */
1069:
1070: --=============================================================================

Line 1091: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1087: -- p_mks_rec.arc_act_market_segment_used_by <> 'EVEO' AND
1088: -- p_mks_rec.arc_act_market_segment_used_by <> 'OFFR'
1089: -- THEN
1090: -- -- invalid item
1091: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1092: -- THEN -- MMSG
1093: ---- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1094: -- FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');
1095: -- FND_MSG_PUB.Add;

Line 1095: -- FND_MSG_PUB.Add;

1091: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1092: -- THEN -- MMSG
1093: ---- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1094: -- FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');
1095: -- FND_MSG_PUB.Add;
1096: -- END IF;
1097: -- x_return_status := FND_API.G_RET_STS_ERROR;
1098: -- -- If any errors happen abort API/Procedure.
1099: -- RETURN;

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

1139: 'ams_act_market_segments',
1140: 'activity_market_segment_id = ' || p_mks_rec.activity_market_segment_id
1141: ) = FND_API.g_false
1142: THEN
1143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1144: THEN
1145: FND_MESSAGE.set_name('AMS', 'AMS_MKS_DUP_ACt_ID');
1146: FND_MSG_PUB.add;
1147: END IF;

Line 1146: FND_MSG_PUB.add;

1142: THEN
1143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1144: THEN
1145: FND_MESSAGE.set_name('AMS', 'AMS_MKS_DUP_ACt_ID');
1146: FND_MSG_PUB.add;
1147: END IF;
1148: x_return_status := FND_API.g_ret_sts_error;
1149: RETURN;
1150: END IF;

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

1180: );
1181: END IF;
1182:
1183: IF l_lookup_flag = FND_API.g_false THEN
1184: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1185: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_SEGMENT_TYPE');
1186: FND_MSG_PUB.add;
1187: END IF;
1188:

Line 1186: FND_MSG_PUB.add;

1182:
1183: IF l_lookup_flag = FND_API.g_false THEN
1184: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1185: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_SEGMENT_TYPE');
1186: FND_MSG_PUB.add;
1187: END IF;
1188:
1189: x_return_status := FND_API.g_ret_sts_error;
1190: RETURN;

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

1199: );
1200: END IF;
1201:
1202: IF l_lookup_flag = FND_API.g_false THEN
1203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1204: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_CONDITION_TYPE');
1205: FND_MSG_PUB.add;
1206: END IF;
1207:

Line 1205: FND_MSG_PUB.add;

1201:
1202: IF l_lookup_flag = FND_API.g_false THEN
1203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1204: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_CONDITION_TYPE');
1205: FND_MSG_PUB.add;
1206: END IF;
1207:
1208: x_return_status := FND_API.g_ret_sts_error;
1209: RETURN;

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

1340: p_table_name => 'ams_act_market_segments',
1341: p_where_clause => l_where_clause
1342: ) = FND_API.g_false
1343: THEN
1344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1345: THEN
1346: FND_MESSAGE.set_name('AMS', 'AMS_MKS_DUP_SEGMENT');
1347: FND_MSG_PUB.add;
1348: END IF;

Line 1347: FND_MSG_PUB.add;

1343: THEN
1344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1345: THEN
1346: FND_MESSAGE.set_name('AMS', 'AMS_MKS_DUP_SEGMENT');
1347: FND_MSG_PUB.add;
1348: END IF;
1349: x_return_status := FND_API.g_ret_sts_error;
1350: RETURN;
1351: END IF;

Line 1443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1439: ,p_pk_data_type => l_pk_data_type
1440: ,p_additional_where_clause => l_additional_where_clause
1441: ) = FND_API.G_FALSE
1442: THEN
1443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1444: FND_MESSAGE.Set_Name ('AMS', 'AMS_MKS_INVALID_USED_BY');
1445: FND_MSG_PUB.Add;
1446: END IF;
1447:

Line 1445: FND_MSG_PUB.Add;

1441: ) = FND_API.G_FALSE
1442: THEN
1443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1444: FND_MESSAGE.Set_Name ('AMS', 'AMS_MKS_INVALID_USED_BY');
1445: FND_MSG_PUB.Add;
1446: END IF;
1447:
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: RETURN;

Line 1488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1484: ,p_pk_value => l_pk_value
1485: ,p_pk_data_type => l_pk_data_type
1486: ) = FND_API.G_FALSE
1487: THEN
1488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1489: THEN
1490: FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_INVALID_MKS_ID');
1491: FND_MSG_PUB.Add;
1492: END IF;

Line 1491: FND_MSG_PUB.Add;

1487: THEN
1488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1489: THEN
1490: FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_INVALID_MKS_ID');
1491: FND_MSG_PUB.Add;
1492: END IF;
1493:
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: RETURN;

Line 1509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1505: FETCH c_mkt_seg_id INTO l_dummy;
1506: CLOSE c_mkt_seg_id;
1507:
1508: IF l_dummy = 0 THEN
1509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1510: FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_INVALID_MKS_ID');
1511: FND_MSG_PUB.Add;
1512: END IF;
1513: END IF;

Line 1511: FND_MSG_PUB.Add;

1507:
1508: IF l_dummy = 0 THEN
1509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1510: FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_INVALID_MKS_ID');
1511: FND_MSG_PUB.Add;
1512: END IF;
1513: END IF;
1514: END IF;*/
1515: -- end of comments

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

1549: OPEN c_obj;
1550: FETCH c_obj INTO l_mks_rec;
1551: IF (c_obj%NOTFOUND) THEN
1552: CLOSE c_obj;
1553: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1554: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1555: FND_MSG_PUB.add;
1556: END IF;
1557: RAISE FND_API.g_exc_error;

Line 1555: FND_MSG_PUB.add;

1551: IF (c_obj%NOTFOUND) THEN
1552: CLOSE c_obj;
1553: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1554: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1555: FND_MSG_PUB.add;
1556: END IF;
1557: RAISE FND_API.g_exc_error;
1558: END IF;
1559: CLOSE c_obj;