1: PACKAGE BODY AMS_access_denorm_PVT AS
2: /* $Header: amsvdenb.pls 115.13 2004/06/16 10:49:19 vmodur ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30):='AMS_access_denorm_PVT';
4: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8: /* sunkumar: 02-10-03 overloaded insert resource to error_message also */
1: PACKAGE BODY AMS_access_denorm_PVT AS
2: /* $Header: amsvdenb.pls 115.13 2004/06/16 10:49:19 vmodur ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30):='AMS_access_denorm_PVT';
4: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8: /* sunkumar: 02-10-03 overloaded insert resource to error_message also */
9:
2: /* $Header: amsvdenb.pls 115.13 2004/06/16 10:49:19 vmodur ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30):='AMS_access_denorm_PVT';
4: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8: /* sunkumar: 02-10-03 overloaded insert resource to error_message also */
9:
10: PROCEDURE insert_resource( p_resource_id IN NUMBER
31:
32: EXCEPTION
33: WHEN OTHERS THEN
34: x_return_status := FND_API.g_ret_sts_unexp_error ;
35: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
36: THEN
37: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
38: END IF;
39: FND_MSG_PUB.count_and_get (
33: WHEN OTHERS THEN
34: x_return_status := FND_API.g_ret_sts_unexp_error ;
35: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
36: THEN
37: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
38: END IF;
39: FND_MSG_PUB.count_and_get (
40: p_encoded => FND_API.g_false,
41: p_count => x_msg_count,
35: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
36: THEN
37: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
38: END IF;
39: FND_MSG_PUB.count_and_get (
40: p_encoded => FND_API.g_false,
41: p_count => x_msg_count,
42: p_data => x_msg_data
43: );
95:
96: EXCEPTION
97: WHEN OTHERS THEN
98: x_return_status := FND_API.g_ret_sts_unexp_error ;
99: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
100: THEN
101: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
102: END IF;
103: FND_MSG_PUB.count_and_get (
97: WHEN OTHERS THEN
98: x_return_status := FND_API.g_ret_sts_unexp_error ;
99: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
100: THEN
101: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
102: END IF;
103: FND_MSG_PUB.count_and_get (
104: p_encoded => FND_API.g_false,
105: p_count => x_msg_count,
99: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
100: THEN
101: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
102: END IF;
103: FND_MSG_PUB.count_and_get (
104: p_encoded => FND_API.g_false,
105: p_count => x_msg_count,
106: p_data => x_msg_data
107: );
157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: x_return_status := FND_API.g_ret_sts_unexp_error ;
161: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
162: THEN
163: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
164: END IF;
165: FND_MSG_PUB.count_and_get (
159: WHEN OTHERS THEN
160: x_return_status := FND_API.g_ret_sts_unexp_error ;
161: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
162: THEN
163: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
164: END IF;
165: FND_MSG_PUB.count_and_get (
166: p_encoded => FND_API.g_false,
167: p_count => x_msg_count,
161: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
162: THEN
163: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
164: END IF;
165: FND_MSG_PUB.count_and_get (
166: p_encoded => FND_API.g_false,
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );