DBA Data[Home] [Help]

APPS.PA_CI_TYPE_USAGE_PVT dependencies on PA_CI_TYPE_USAGE_PVT

Line 1: PACKAGE BODY pa_ci_type_usage_pvt AS

1: PACKAGE BODY pa_ci_type_usage_pvt AS
2: /* $Header: PACITUVB.pls 120.1 2005/08/19 16:19:02 mwasowic noship $ */
3:
4: PROCEDURE create_ci_type_usage (
5: p_api_version IN NUMBER := 1.0,

Line 23: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.CREATE_CI_TYPE_USAGE');

19: )
20: IS
21: l_rowid VARCHAR2(30);
22: BEGIN
23: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.CREATE_CI_TYPE_USAGE');
24:
25: IF p_commit = FND_API.G_TRUE THEN
26: SAVEPOINT create_ci_type_usage;
27: END IF;

Line 70: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PVT',

66: ROLLBACK TO create_ci_type_usage;
67: END IF;
68:
69: x_return_status := 'U';
70: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PVT',
71: p_procedure_name => 'CREATE_CI_TYPE_USAGE',
72: p_error_text => SUBSTRB(SQLERRM,1,240));
73:
74: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 96: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.UPDATE_CI_TYPE_USAGE');

92: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
93: )
94: IS
95: BEGIN
96: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.UPDATE_CI_TYPE_USAGE');
97:
98: IF p_commit = FND_API.G_TRUE THEN
99: SAVEPOINT update_ci_type_usage;
100: END IF;

Line 140: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PVT',

136: ROLLBACK TO update_ci_type_usage;
137: END IF;
138:
139: x_return_status := 'U';
140: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PVT',
141: p_procedure_name => 'UPDATE_CI_TYPE_USAGE',
142: p_error_text => SUBSTRB(SQLERRM,1,240));
143:
144: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 164: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.DELETE_CI_TYPE_USAGE');

160: )
161: IS
162: l_temp VARCHAR2(1);
163: BEGIN
164: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.DELETE_CI_TYPE_USAGE');
165:
166: IF p_commit = FND_API.G_TRUE THEN
167: SAVEPOINT delete_ci_type_usage;
168: END IF;

Line 217: END pa_ci_type_usage_pvt;

213: fnd_msg_pub.count_and_get(p_count => x_msg_count,
214: p_data => x_msg_data);
215: END delete_ci_type_usage;
216:
217: END pa_ci_type_usage_pvt;