7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2
18: -- .
19: -- .
41: g_pkg_name CONSTANT VARCHAR2(30):= 'product_businessobject_apitype';
42:
43: PROCEDURE apiname(
44: p_api_version IN NUMBER
45: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
46: ,p_commit IN VARCHAR2 := fnd_api.g_false
47: ,p_validation_level IN NUMBER
48: := fnd_api.g_valid_level_full
49: ,x_return_status OUT NOCOPY VARCHAR2
42:
43: PROCEDURE apiname(
44: p_api_version IN NUMBER
45: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
46: ,p_commit IN VARCHAR2 := fnd_api.g_false
47: ,p_validation_level IN NUMBER
48: := fnd_api.g_valid_level_full
49: ,x_return_status OUT NOCOPY VARCHAR2
50: ,x_msg_count OUT NOCOPY NUMBER
44: p_api_version IN NUMBER
45: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
46: ,p_commit IN VARCHAR2 := fnd_api.g_false
47: ,p_validation_level IN NUMBER
48: := fnd_api.g_valid_level_full
49: ,x_return_status OUT NOCOPY VARCHAR2
50: ,x_msg_count OUT NOCOPY NUMBER
51: ,x_msg_data OUT NOCOPY VARCHAR2)
52: IS
57: -- Standard Start of API savepoint
58: SAVEPOINT apiname_apitype;
59:
60: -- Standard call to check for call compatibility.
61: IF NOT fnd_api.compatible_api_call(
62: l_api_version
63: ,p_api_version
64: ,l_api_name
65: ,g_pkg_name) THEN
62: l_api_version
63: ,p_api_version
64: ,l_api_name
65: ,g_pkg_name) THEN
66: RAISE fnd_api.g_exc_unexpected_error;
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF fnd_api.to_boolean(p_init_msg_list) THEN
66: RAISE fnd_api.g_exc_unexpected_error;
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF fnd_api.to_boolean(p_init_msg_list) THEN
71: fnd_msg_pub.initialize;
72: END IF;
73:
74: -- Initialize API return status to success
71: fnd_msg_pub.initialize;
72: END IF;
73:
74: -- Initialize API return status to success
75: x_return_status := fnd_api.g_ret_sts_success;
76:
77: -- API body
78:
79: -- End of API body.
77: -- API body
78:
79: -- End of API body.
80: -- Standard check of p_commit.
81: IF fnd_api.to_boolean(p_commit) THEN
82: COMMIT WORK;
83: END IF;
84:
85: -- Standard call to get message count and if count is 1, get message info.
86: fnd_msg_pub.count_and_get(
87: p_count => x_msg_count
88: ,p_data => x_msg_data);
89: EXCEPTION
90: WHEN fnd_api.g_exc_error THEN
91: ROLLBACK TO apiname_apitype;
92: x_return_status := fnd_api.g_ret_sts_error;
93: fnd_msg_pub.count_and_get(
94: p_count => x_msg_count
88: ,p_data => x_msg_data);
89: EXCEPTION
90: WHEN fnd_api.g_exc_error THEN
91: ROLLBACK TO apiname_apitype;
92: x_return_status := fnd_api.g_ret_sts_error;
93: fnd_msg_pub.count_and_get(
94: p_count => x_msg_count
95: ,p_data => x_msg_data);
96: WHEN fnd_api.g_exc_unexpected_error THEN
92: x_return_status := fnd_api.g_ret_sts_error;
93: fnd_msg_pub.count_and_get(
94: p_count => x_msg_count
95: ,p_data => x_msg_data);
96: WHEN fnd_api.g_exc_unexpected_error THEN
97: ROLLBACK TO apiname_apitype;
98: x_return_status := fnd_api.g_ret_sts_unexp_error;
99: fnd_msg_pub.count_and_get(
100: p_count => x_msg_count
94: p_count => x_msg_count
95: ,p_data => x_msg_data);
96: WHEN fnd_api.g_exc_unexpected_error THEN
97: ROLLBACK TO apiname_apitype;
98: x_return_status := fnd_api.g_ret_sts_unexp_error;
99: fnd_msg_pub.count_and_get(
100: p_count => x_msg_count
101: ,p_data => x_msg_data);
102: WHEN OTHERS THEN
100: p_count => x_msg_count
101: ,p_data => x_msg_data);
102: WHEN OTHERS THEN
103: ROLLBACK TO apiname_apitype;
104: x_return_status := fnd_api.g_ret_sts_unexp_error;
105:
106: IF fnd_msg_pub.check_msg_level(
107: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
108: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);