DBA Data[Home] [Help]

APPS.AMS_SOURCECODE_PVT dependencies on FND_MSG_PUB

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

2: /*$Header: amsvscgb.pls 115.29 2002/11/22 23:38:55 dbiswas ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_SourceCode_PVT';
5:
6: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
7: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
8: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
9:
10: -- Forward declaration

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

3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_SourceCode_PVT';
5:
6: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
7: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
8: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
9:
10: -- Forward declaration
11: /*PROCEDURE modify_sourcecode(

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

4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_SourceCode_PVT';
5:
6: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
7: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
8: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
9:
10: -- Forward declaration
11: /*PROCEDURE modify_sourcecode(
12: p_source_code IN VARCHAR2,

Line 454: FND_MSG_PUB.initialize;

450:
451: END IF;
452:
453: IF FND_API.to_boolean(p_init_msg_list) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456:
457: IF NOT FND_API.compatible_api_call(
458: l_api_version,

Line 610: FND_MSG_PUB.count_and_get(

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

Line 621: FND_MSG_PUB.count_and_get(

617:
618: WHEN FND_API.g_exc_error THEN
619: ROLLBACK TO create_sourcecode;
620: x_return_status := FND_API.g_ret_sts_error;
621: FND_MSG_PUB.count_and_get(
622: p_encoded => FND_API.g_false,
623: p_count => x_msg_count,
624: p_data => x_msg_data
625: );

Line 630: FND_MSG_PUB.count_and_get(

626:
627: WHEN FND_API.g_exc_unexpected_error THEN
628: ROLLBACK TO create_sourcecode;
629: x_return_status := FND_API.g_ret_sts_unexp_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 641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

637: WHEN OTHERS THEN
638: ROLLBACK TO create_sourcecode;
639: x_return_status := FND_API.g_ret_sts_unexp_error ;
640:
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
642: THEN
643: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
644: END IF;
645:

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

639: x_return_status := FND_API.g_ret_sts_unexp_error ;
640:
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
642: THEN
643: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
644: END IF;
645:
646: FND_MSG_PUB.count_and_get(
647: p_encoded => FND_API.g_false,

Line 646: FND_MSG_PUB.count_and_get(

642: THEN
643: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
644: END IF;
645:
646: FND_MSG_PUB.count_and_get(
647: p_encoded => FND_API.g_false,
648: p_count => x_msg_count,
649: p_data => x_msg_data
650: );

Line 693: FND_MSG_PUB.initialize;

689:
690: END IF;
691:
692: IF FND_API.to_boolean(p_init_msg_list) THEN
693: FND_MSG_PUB.initialize;
694: END IF;
695:
696: IF NOT FND_API.compatible_api_call(
697: l_api_version,

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

709: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
710: where SOURCE_CODE = p_sourcecode;
711:
712: IF (SQL%NOTFOUND) THEN
713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
714: THEN
715: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
716: FND_MSG_PUB.add;
717: END IF;

Line 716: FND_MSG_PUB.add;

712: IF (SQL%NOTFOUND) THEN
713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
714: THEN
715: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
716: FND_MSG_PUB.add;
717: END IF;
718: RAISE FND_API.g_exc_error;
719: END IF;
720:

Line 726: FND_MSG_PUB.count_and_get(

722: IF FND_API.to_boolean(p_commit) THEN
723: COMMIT;
724: END IF;
725:
726: FND_MSG_PUB.count_and_get(
727: p_encoded => FND_API.g_false,
728: p_count => x_msg_count,
729: p_data => x_msg_data
730: );

Line 745: FND_MSG_PUB.count_and_get(

741:
742: WHEN FND_API.g_exc_error THEN
743: ROLLBACK TO revoke_sourcecode;
744: x_return_status := FND_API.g_ret_sts_error;
745: FND_MSG_PUB.count_and_get(
746: p_encoded => FND_API.g_false,
747: p_count => x_msg_count,
748: p_data => x_msg_data
749: );

Line 754: FND_MSG_PUB.count_and_get(

750:
751: WHEN FND_API.g_exc_unexpected_error THEN
752: ROLLBACK TO revoke_sourcecode;
753: x_return_status := FND_API.g_ret_sts_unexp_error ;
754: FND_MSG_PUB.count_and_get(
755: p_encoded => FND_API.g_false,
756: p_count => x_msg_count,
757: p_data => x_msg_data
758: );

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

760: WHEN OTHERS THEN
761: ROLLBACK TO revoke_sourcecode;
762: x_return_status := FND_API.g_ret_sts_unexp_error ;
763:
764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
765: THEN
766: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
767: END IF;
768:

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

762: x_return_status := FND_API.g_ret_sts_unexp_error ;
763:
764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
765: THEN
766: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
767: END IF;
768:
769: FND_MSG_PUB.count_and_get(
770: p_encoded => FND_API.g_false,

Line 769: FND_MSG_PUB.count_and_get(

765: THEN
766: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
767: END IF;
768:
769: FND_MSG_PUB.count_and_get(
770: p_encoded => FND_API.g_false,
771: p_count => x_msg_count,
772: p_data => x_msg_data
773: );

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

818: ,RELATED_SOURCE_ID = p_related_sourceid
819: where SOURCE_CODE_ID = p_sourcecode_id;
820:
821: IF (SQL%NOTFOUND) THEN
822: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
823: THEN
824: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
825: FND_MSG_PUB.add;
826: END IF;

Line 825: FND_MSG_PUB.add;

821: IF (SQL%NOTFOUND) THEN
822: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
823: THEN
824: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
825: FND_MSG_PUB.add;
826: END IF;
827: x_return_status := FND_API.g_ret_sts_error;
828: END IF;
829: