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_GEO_AREAS_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: --
9: -- History
10: -- 12/3/1999 julou created
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 create_geo_area

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

9: -- History
10: -- 12/3/1999 julou created
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 create_geo_area
17: (

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

10: -- 12/3/1999 julou created
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 create_geo_area
17: (
18: p_api_version IN NUMBER,

Line 53: FND_MSG_PUB.initialize;

49: -- initialize
50: SAVEPOINT create_geo_area;
51:
52: IF FND_API.to_boolean(p_init_msg_list) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: IF (AMS_DEBUG_HIGH_ON) THEN
57:

Line 216: FND_MSG_PUB.count_and_get

212: IF FND_API.to_boolean(p_commit) THEN
213: COMMIT;
214: END IF;
215:
216: FND_MSG_PUB.count_and_get
217: (
218: p_encoded => FND_API.g_false,
219: p_count => x_msg_count,
220: p_data => x_msg_data

Line 236: FND_MSG_PUB.count_and_get

232:
233: WHEN FND_API.g_exc_error THEN
234: ROLLBACK TO create_geo_area;
235: x_return_status := FND_API.g_ret_sts_error;
236: FND_MSG_PUB.count_and_get
237: (
238: p_encoded => FND_API.g_false,
239: p_count => x_msg_count,
240: p_data => x_msg_data

Line 246: FND_MSG_PUB.count_and_get

242:
243: WHEN FND_API.g_exc_unexpected_error THEN
244: ROLLBACK TO create_geo_area;
245: x_return_status := FND_API.g_ret_sts_unexp_error;
246: FND_MSG_PUB.count_and_get
247: (
248: p_encoded => FND_API.g_false,
249: p_count => x_msg_count,
250: p_data => x_msg_data

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

252:
253: WHEN OTHERS THEN
254: ROLLBACK TO create_geo_area;
255: x_return_status :=FND_API.g_ret_sts_unexp_error;
256: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
257: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
258: END IF;
259: FND_MSG_PUB.count_and_get
260: (

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

253: WHEN OTHERS THEN
254: ROLLBACK TO create_geo_area;
255: x_return_status :=FND_API.g_ret_sts_unexp_error;
256: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
257: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
258: END IF;
259: FND_MSG_PUB.count_and_get
260: (
261: p_encoded => FND_API.g_false,

Line 259: FND_MSG_PUB.count_and_get

255: x_return_status :=FND_API.g_ret_sts_unexp_error;
256: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
257: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
258: END IF;
259: FND_MSG_PUB.count_and_get
260: (
261: p_encoded => FND_API.g_false,
262: p_count => x_msg_count,
263: p_data => x_msg_data

Line 301: FND_MSG_PUB.initialize;

297: -- initialize
298: SAVEPOINT update_geo_area;
299:
300: IF FND_API.to_boolean(p_init_msg_list) THEN
301: FND_MSG_PUB.initialize;
302: END IF;
303:
304: IF (AMS_DEBUG_HIGH_ON) THEN
305:

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

383: WHERE activity_geo_area_id = l_geo_area_rec.activity_geo_area_id
384: AND object_version_number = l_geo_area_rec.object_version_number;
385:
386: IF (SQL%NOTFOUND) THEN
387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
388: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
389: FND_MSG_PUB.add;
390: END IF;
391: RAISE FND_API.g_exc_error;

Line 389: FND_MSG_PUB.add;

385:
386: IF (SQL%NOTFOUND) THEN
387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
388: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
389: FND_MSG_PUB.add;
390: END IF;
391: RAISE FND_API.g_exc_error;
392: END IF;
393:

Line 399: FND_MSG_PUB.count_and_get

395: IF FND_API.to_boolean(p_commit) THEN
396: COMMIT;
397: END IF;
398:
399: FND_MSG_PUB.count_and_get
400: (
401: P_ENCODED => FND_API.g_false,
402: p_count => x_msg_count,
403: p_data => x_msg_data

Line 419: FND_MSG_PUB.count_and_get

415:
416: WHEN FND_API.g_exc_error THEN
417: ROLLBACK TO update_geo_area;
418: x_return_status := FND_API.g_ret_sts_error;
419: FND_MSG_PUB.count_and_get
420: (
421: p_encoded => FND_API.g_false,
422: p_count => x_msg_count,
423: p_data => x_msg_data

Line 429: FND_MSG_PUB.count_and_get

425:
426: WHEN FND_API.g_exc_unexpected_error THEN
427: ROLLBACK TO update_geo_area;
428: x_return_status := FND_API.g_ret_sts_unexp_error;
429: FND_MSG_PUB.count_and_get
430: (
431: p_encoded => FND_API.g_false,
432: p_count => x_msg_count,
433: p_data => x_msg_data

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

435:
436: WHEN OTHERS THEN
437: ROLLBACK TO update_geo_area;
438: x_return_status :=FND_API.g_ret_sts_unexp_error;
439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
440: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
441: END IF;
442: FND_MSG_PUB.count_and_get
443: (

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

436: WHEN OTHERS THEN
437: ROLLBACK TO update_geo_area;
438: x_return_status :=FND_API.g_ret_sts_unexp_error;
439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
440: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
441: END IF;
442: FND_MSG_PUB.count_and_get
443: (
444: p_encoded => FND_API.g_false,

Line 442: FND_MSG_PUB.count_and_get

438: x_return_status :=FND_API.g_ret_sts_unexp_error;
439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
440: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
441: END IF;
442: FND_MSG_PUB.count_and_get
443: (
444: p_encoded => FND_API.g_false,
445: p_count => x_msg_count,
446: p_data => x_msg_data

Line 504: FND_MSG_PUB.initialize;

500:
501: END IF;
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 535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

Line 537: FND_MSG_PUB.add;

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

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 601: FND_MSG_PUB.count_and_get

597:
598: WHEN FND_API.g_exc_error THEN
599: ROLLBACK TO delete_geo_area;
600: x_return_status := FND_API.g_ret_sts_error;
601: FND_MSG_PUB.count_and_get
602: (
603: p_encoded => FND_API.g_false,
604: p_count => x_msg_count,
605: p_data => x_msg_data

Line 611: FND_MSG_PUB.count_and_get

607:
608: WHEN FND_API.g_exc_unexpected_error THEN
609: ROLLBACK TO delete_geo_area;
610: x_return_status := FND_API.g_ret_sts_unexp_error;
611: FND_MSG_PUB.count_and_get
612: (
613: p_encoded => FND_API.g_false,
614: p_count => x_msg_count,
615: p_data => x_msg_data

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

617:
618: WHEN OTHERS THEN
619: ROLLBACK TO delete_geo_area;
620: x_return_status :=FND_API.g_ret_sts_unexp_error;
621: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
622: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
623: END IF;
624: FND_MSG_PUB.count_and_get
625: (

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

618: WHEN OTHERS THEN
619: ROLLBACK TO delete_geo_area;
620: x_return_status :=FND_API.g_ret_sts_unexp_error;
621: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
622: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
623: END IF;
624: FND_MSG_PUB.count_and_get
625: (
626: p_encoded => FND_API.g_false,

Line 624: FND_MSG_PUB.count_and_get

620: x_return_status :=FND_API.g_ret_sts_unexp_error;
621: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
622: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
623: END IF;
624: FND_MSG_PUB.count_and_get
625: (
626: p_encoded => FND_API.g_false,
627: p_count => x_msg_count,
628: p_data => x_msg_data

Line 674: FND_MSG_PUB.initialize;

670: AMS_Utility_PVT.debug_message(l_full_name || ': start');
671: END IF;
672:
673: IF FND_API.to_boolean(p_init_msg_list) THEN
674: FND_MSG_PUB.initialize;
675: END IF;
676:
677: IF NOT FND_API.compatible_api_call
678: (

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

696: OPEN c_geo_area;
697: FETCH c_geo_area INTO l_geo_area_id;
698: IF (c_geo_area%NOTFOUND) THEN
699: CLOSE c_geo_area;
700: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
701: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
702: FND_MSG_PUB.add;
703: END IF;
704: RAISE FND_API.g_exc_error;

Line 702: FND_MSG_PUB.add;

698: IF (c_geo_area%NOTFOUND) THEN
699: CLOSE c_geo_area;
700: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
701: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
702: FND_MSG_PUB.add;
703: END IF;
704: RAISE FND_API.g_exc_error;
705: END IF;
706: CLOSE c_geo_area;

Line 709: FND_MSG_PUB.count_and_get

705: END IF;
706: CLOSE c_geo_area;
707:
708: -- finish
709: FND_MSG_PUB.count_and_get
710: (
711: p_encoded => FND_API.g_false,
712: p_count => x_msg_count,
713: p_data => x_msg_data

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

724: EXCEPTION
725:
726: WHEN AMS_Utility_PVT.resource_locked THEN
727: x_return_status := FND_API.g_ret_sts_error;
728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
729: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
730: FND_MSG_PUB.add;
731: END IF;
732: FND_MSG_PUB.count_and_get

Line 730: FND_MSG_PUB.add;

726: WHEN AMS_Utility_PVT.resource_locked THEN
727: x_return_status := FND_API.g_ret_sts_error;
728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
729: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
730: FND_MSG_PUB.add;
731: END IF;
732: FND_MSG_PUB.count_and_get
733: (
734: p_encoded => FND_API.g_false,

Line 732: FND_MSG_PUB.count_and_get

728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
729: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
730: FND_MSG_PUB.add;
731: END IF;
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: FND_MSG_PUB.count_and_get

737: );
738:
739: WHEN FND_API.g_exc_error THEN
740: x_return_status := FND_API.g_ret_sts_error;
741: FND_MSG_PUB.count_and_get
742: (
743: p_encoded => FND_API.g_false,
744: p_count => x_msg_count,
745: p_data => x_msg_data

Line 750: FND_MSG_PUB.count_and_get

746: );
747:
748: WHEN FND_API.g_exc_unexpected_error THEN
749: x_return_status := FND_API.g_ret_sts_unexp_error;
750: FND_MSG_PUB.count_and_get
751: (
752: p_encoded => FND_API.g_false,
753: p_count => x_msg_count,
754: p_data => x_msg_data

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

755: );
756:
757: WHEN OTHERS THEN
758: x_return_status :=FND_API.g_ret_sts_unexp_error;
759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
760: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
761: END IF;
762: FND_MSG_PUB.count_and_get
763: (

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

756:
757: WHEN OTHERS THEN
758: x_return_status :=FND_API.g_ret_sts_unexp_error;
759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
760: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
761: END IF;
762: FND_MSG_PUB.count_and_get
763: (
764: p_encoded => FND_API.g_false,

Line 762: FND_MSG_PUB.count_and_get

758: x_return_status :=FND_API.g_ret_sts_unexp_error;
759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
760: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
761: END IF;
762: FND_MSG_PUB.count_and_get
763: (
764: p_encoded => FND_API.g_false,
765: p_count => x_msg_count,
766: p_data => x_msg_data

Line 808: -- FND_MSG_PUB.initialize;

804: AMS_Utility_PVT.debug_message(l_full_name||': start');
805: END IF;
806:
807: -- IF FND_API.to_boolean(p_init_msg_list) THEN
808: -- FND_MSG_PUB.initialize;
809: -- END IF;
810:
811: IF NOT FND_API.compatible_api_call(
812: l_api_version,

Line 843: FND_MSG_PUB.count_and_get(

839: END IF;
840: END IF;
841:
842: -------------------- finish --------------------------
843: FND_MSG_PUB.count_and_get(
844: p_encoded => FND_API.g_false,
845: p_count => x_msg_count,
846: p_data => x_msg_data
847: );

Line 860: FND_MSG_PUB.count_and_get

856:
857: EXCEPTION
858: WHEN FND_API.g_exc_error THEN
859: x_return_status := FND_API.g_ret_sts_error;
860: FND_MSG_PUB.count_and_get
861: (
862: p_encoded => FND_API.g_false,
863: p_count => x_msg_count,
864: p_data => x_msg_data

Line 869: FND_MSG_PUB.count_and_get

865: );
866:
867: WHEN FND_API.g_exc_unexpected_error THEN
868: x_return_status := FND_API.g_ret_sts_unexp_error ;
869: FND_MSG_PUB.count_and_get
870: (
871: p_encoded => FND_API.g_false,
872: p_count => x_msg_count,
873: p_data => x_msg_data

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

874: );
875:
876: WHEN OTHERS THEN
877: x_return_status := FND_API.g_ret_sts_unexp_error;
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
879: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;
881:
882: FND_MSG_PUB.count_and_get

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

875:
876: WHEN OTHERS THEN
877: x_return_status := FND_API.g_ret_sts_unexp_error;
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
879: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;
881:
882: FND_MSG_PUB.count_and_get
883: (

Line 882: FND_MSG_PUB.count_and_get

878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
879: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;
881:
882: FND_MSG_PUB.count_and_get
883: (
884: p_encoded => FND_API.g_false,
885: p_count => x_msg_count,
886: p_data => x_msg_data

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

985:
986: -- check activity_geo_area_id
987: IF p_geo_area_rec.activity_geo_area_id IS NULL
988: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
990: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_ACT_AREA_ID');
991: FND_MSG_PUB.add;
992: END IF;
993:

Line 991: FND_MSG_PUB.add;

987: IF p_geo_area_rec.activity_geo_area_id IS NULL
988: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
990: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_ACT_AREA_ID');
991: FND_MSG_PUB.add;
992: END IF;
993:
994: x_return_status := FND_API.g_ret_sts_error;
995: RETURN;

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

998: -- check object_version_number
999: IF p_geo_area_rec.object_version_number IS NULL
1000: AND p_validation_mode = JTF_PLSQL_API.g_update
1001: THEN
1002: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1003: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');
1004: FND_MSG_PUB.add;
1005: END IF;
1006:

Line 1004: FND_MSG_PUB.add;

1000: AND p_validation_mode = JTF_PLSQL_API.g_update
1001: THEN
1002: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1003: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');
1004: FND_MSG_PUB.add;
1005: END IF;
1006:
1007: x_return_status := FND_API.g_ret_sts_error;
1008: RETURN;

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

1009: END IF;
1010:
1011: -- check act_geo_area_used_by_id
1012: IF p_geo_area_rec.act_geo_area_used_by_id IS NULL THEN
1013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1014: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_USED_BY_ID');
1015: FND_MSG_PUB.add;
1016: END IF;
1017:

Line 1015: FND_MSG_PUB.add;

1011: -- check act_geo_area_used_by_id
1012: IF p_geo_area_rec.act_geo_area_used_by_id IS NULL THEN
1013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1014: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_USED_BY_ID');
1015: FND_MSG_PUB.add;
1016: END IF;
1017:
1018: x_return_status := FND_API.g_ret_sts_error;
1019: RETURN;

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

1020: END IF;
1021:
1022: -- check arc_act_geo_area_used_by
1023: IF p_geo_area_rec.arc_act_geo_area_used_by IS NULL THEN
1024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1025: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_USED_BY');
1026: FND_MSG_PUB.add;
1027: END IF;
1028:

Line 1026: FND_MSG_PUB.add;

1022: -- check arc_act_geo_area_used_by
1023: IF p_geo_area_rec.arc_act_geo_area_used_by IS NULL THEN
1024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1025: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_USED_BY');
1026: FND_MSG_PUB.add;
1027: END IF;
1028:
1029: x_return_status := FND_API.g_ret_sts_error;
1030: RETURN;

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

1031: END IF;
1032:
1033: -- commented out by soagrawa on 29-Jun-2001
1034: -- IF p_geo_area_rec.arc_act_geo_area_used_by NOT IN ('CAMP','ECAM','RCAM') THEN
1035: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1036: -- FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_USED_BY');
1037: -- FND_MSG_PUB.add;
1038: -- END IF;
1039:

Line 1037: -- FND_MSG_PUB.add;

1033: -- commented out by soagrawa on 29-Jun-2001
1034: -- IF p_geo_area_rec.arc_act_geo_area_used_by NOT IN ('CAMP','ECAM','RCAM') THEN
1035: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1036: -- FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_USED_BY');
1037: -- FND_MSG_PUB.add;
1038: -- END IF;
1039:
1040: -- x_return_status := FND_API.g_ret_sts_error;
1041: -- RETURN;

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

1042: -- END IF;
1043:
1044: -- check geo_area_type_code
1045: IF p_geo_area_rec.geo_area_type_code IS NULL THEN
1046: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1047: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_TYPE_CODE');
1048: FND_MSG_PUB.add;
1049: END IF;
1050:

Line 1048: FND_MSG_PUB.add;

1044: -- check geo_area_type_code
1045: IF p_geo_area_rec.geo_area_type_code IS NULL THEN
1046: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1047: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_TYPE_CODE');
1048: FND_MSG_PUB.add;
1049: END IF;
1050:
1051: x_return_status := FND_API.g_ret_sts_error;
1052: RETURN;

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

1053: END IF;
1054:
1055: -- check geo_hierarchy_id
1056: IF p_geo_area_rec.geo_hierarchy_id IS NULL THEN
1057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1058: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_HIERARCHY_ID');
1059: FND_MSG_PUB.add;
1060: END IF;
1061:

Line 1059: FND_MSG_PUB.add;

1055: -- check geo_hierarchy_id
1056: IF p_geo_area_rec.geo_hierarchy_id IS NULL THEN
1057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1058: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_HIERARCHY_ID');
1059: FND_MSG_PUB.add;
1060: END IF;
1061:
1062: x_return_status := FND_API.g_ret_sts_error;
1063: RETURN;

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

1097: );
1098: END IF;
1099:
1100: IF l_uk_flag = FND_API.g_false THEN
1101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1102: FND_MESSAGE.set_name('AMS', 'AMS_ACT_GEO_AREAS_DUP_ID');
1103: FND_MSG_PUB.add;
1104: END IF;
1105:

Line 1103: FND_MSG_PUB.add;

1099:
1100: IF l_uk_flag = FND_API.g_false THEN
1101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1102: FND_MESSAGE.set_name('AMS', 'AMS_ACT_GEO_AREAS_DUP_ID');
1103: FND_MSG_PUB.add;
1104: END IF;
1105:
1106: x_return_status := FND_API.g_ret_sts_error;
1107: RETURN;

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

1128: );
1129: END IF;
1130:
1131: IF l_uk_flag = FND_API.g_false THEN
1132: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1133: FND_MESSAGE.set_name('AMS', 'AMS_GEO_DUP_USED_BY_AND_ID');
1134: FND_MSG_PUB.add;
1135: END IF;
1136:

Line 1134: FND_MSG_PUB.add;

1130:
1131: IF l_uk_flag = FND_API.g_false THEN
1132: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1133: FND_MESSAGE.set_name('AMS', 'AMS_GEO_DUP_USED_BY_AND_ID');
1134: FND_MSG_PUB.add;
1135: END IF;
1136:
1137: x_return_status := FND_API.g_ret_sts_error;
1138: RETURN;

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

1203:
1204: -- end soagrawa
1205:
1206: IF l_fk_flag = FND_API.g_false THEN
1207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1208: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_USED_BY_ID');
1209: FND_MSG_PUB.add;
1210: END IF;
1211:

Line 1209: FND_MSG_PUB.add;

1205:
1206: IF l_fk_flag = FND_API.g_false THEN
1207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1208: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_USED_BY_ID');
1209: FND_MSG_PUB.add;
1210: END IF;
1211:
1212: x_return_status := FND_API.g_ret_sts_error;
1213: RETURN;

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

1225: 2 --varchar2 types
1226: );
1227:
1228: IF l_fk_flag = FND_API.g_false THEN
1229: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1230: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_TYPE_CODE');
1231: FND_MSG_PUB.add;
1232: END IF;
1233:

Line 1231: FND_MSG_PUB.add;

1227:
1228: IF l_fk_flag = FND_API.g_false THEN
1229: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1230: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_TYPE_CODE');
1231: FND_MSG_PUB.add;
1232: END IF;
1233:
1234: x_return_status := FND_API.g_ret_sts_error;
1235: RETURN;

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

1243: p_geo_area_rec.geo_hierarchy_id
1244: );
1245:
1246: IF l_fk_flag = FND_API.g_false THEN
1247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1248: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_HIERARCHY_ID');
1249: FND_MSG_PUB.add;
1250: END IF;
1251:

Line 1249: FND_MSG_PUB.add;

1245:
1246: IF l_fk_flag = FND_API.g_false THEN
1247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1248: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_HIERARCHY_ID');
1249: FND_MSG_PUB.add;
1250: END IF;
1251:
1252: x_return_status := FND_API.g_ret_sts_error;
1253: RETURN;

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

1282: OPEN c_geo_area;
1283: FETCH c_geo_area INTO l_geo_area_rec;
1284: IF (c_geo_area%NOTFOUND) THEN
1285: CLOSE c_geo_area;
1286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1287: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1288: FND_MSG_PUB.add;
1289: END IF;
1290: RAISE FND_API.g_exc_error;

Line 1288: FND_MSG_PUB.add;

1284: IF (c_geo_area%NOTFOUND) THEN
1285: CLOSE c_geo_area;
1286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1287: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1288: FND_MSG_PUB.add;
1289: END IF;
1290: RAISE FND_API.g_exc_error;
1291: END IF;
1292: CLOSE c_geo_area;