APPS.PA_CI_TYPE_USAGE_PUB dependencies on PA_CI_TYPE_USAGE_PUB

Line 1: PACKAGE BODY pa_ci_type_usage_pub AS

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

Line 27: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PUB.CREATE_CI_TYPE_USAGE');

23: l_error_message_code VARCHAR2(100);
24: l_project_type_id NUMBER := p_project_type_id;
25: l_ci_type_id NUMBER := p_ci_type_id;
26: BEGIN
27: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PUB.CREATE_CI_TYPE_USAGE');
28:
29: IF p_commit = FND_API.G_TRUE THEN
30: SAVEPOINT create_ci_type_usage;
31: END IF;

Line 114: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PUB',

110: ROLLBACK TO create_ci_type_usage;
111: END IF;
112:
113: x_return_status := 'U';
114: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PUB',
115: p_procedure_name => 'CREATE_CI_TYPE_USAGE',
116: p_error_text => SUBSTRB(SQLERRM,1,240));
117:
118: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 145: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PUB.UPDATE_CI_TYPE_USAGE');

141: l_error_message_code VARCHAR2(100);
142: l_project_type_id NUMBER := p_project_type_id;
143: l_ci_type_id NUMBER := p_ci_type_id;
144: BEGIN
145: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PUB.UPDATE_CI_TYPE_USAGE');
146:
147: IF p_commit = FND_API.G_TRUE THEN
148: SAVEPOINT update_ci_type_usage;
149: END IF;

Line 232: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PUB',

228: ROLLBACK TO update_ci_type_usage;
229: END IF;
230:
231: x_return_status := 'U';
232: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PUB',
233: p_procedure_name => 'UPDATE_CI_TYPE_USAGE',
234: p_error_text => SUBSTRB(SQLERRM,1,240));
235:
236: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 260: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PUB.DELETE_CI_TYPE_USAGE');

256: l_error_message_code VARCHAR2(100);
257: l_project_type_id NUMBER := p_project_type_id;
258: l_ci_type_id NUMBER := p_ci_type_id;
259: BEGIN
260: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PUB.DELETE_CI_TYPE_USAGE');
261:
262: IF p_commit = FND_API.G_TRUE THEN
263: SAVEPOINT delete_ci_type_usage;
264: END IF;

Line 353: END pa_ci_type_usage_pub;

349: fnd_msg_pub.count_and_get(p_count => x_msg_count,
350: p_data => x_msg_data);
351: END delete_ci_type_usage;
352:
353: END pa_ci_type_usage_pub;