DBA Data[Home] [Help]

APPS.PA_CI_IMPACT_TYPE_USAGE_PUB dependencies on PA_CI_IMPACT_TYPE_USAGE_PUB

Line 1: PACKAGE BODY PA_CI_IMPACT_TYPE_USAGE_PUB AS

1: PACKAGE BODY PA_CI_IMPACT_TYPE_USAGE_PUB AS
2: /* $Header: PACIIMPB.pls 120.1 2009/03/24 17:36:09 cklee ship $ */
3:
4: PROCEDURE create_ci_impact_type_usage (
5: p_api_version IN NUMBER := 1.0,

Line 32: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PUB.CREATE_CI_IMPACT_TYPE_USAGE');

28:
29: l_msg_index_out NUMBER;
30:
31: BEGIN
32: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PUB.CREATE_CI_IMPACT_TYPE_USAGE');
33:
34: IF p_commit = 'T' THEN
35: SAVEPOINT create_ci_impact_type_usage;
36: END IF;

Line 90: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PUB',

86: ROLLBACK TO create_ci_impact_type_usage;
87: END IF;
88:
89: x_return_status := 'U';
90: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PUB',
91: p_procedure_name => 'CREATE_CI_IMPACT_TYPE_USAGE',
92: p_error_text => SUBSTRB(SQLERRM,1,240));
93:
94: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 118: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PUB.UPDATE_CI_IMPACT_TYPE_USAGE');

114: IS
115: l_msg_index_out NUMBER;
116:
117: BEGIN
118: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PUB.UPDATE_CI_IMPACT_TYPE_USAGE');
119:
120: IF p_commit = 'T' THEN
121: SAVEPOINT update_ci_impact_type_usage;
122: END IF;

Line 171: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PUB',

167: ROLLBACK TO create_ci_impact_type_usage;
168: END IF;
169:
170: x_return_status := 'U';
171: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PUB',
172: p_procedure_name => 'UPDATE_CI_IMPACT_TYPE_USAGE',
173: p_error_text => SUBSTRB(SQLERRM,1,240));
174:
175: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 204: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PUB.DELETE_CI_IMPACT_TYPE_USAGE');

200: IS
201: l_msg_index_out NUMBER;
202: l_temp VARCHAR2(1);
203: BEGIN
204: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PUB.DELETE_CI_IMPACT_TYPE_USAGE');
205:
206: IF p_commit = 'T' THEN
207: SAVEPOINT delete_ci_impact_type_usage;
208: END IF;

Line 300: END PA_CI_IMPACT_TYPE_USAGE_PUB;

296: RETURN 'Y';
297:
298: END ;
299:
300: END PA_CI_IMPACT_TYPE_USAGE_PUB;