APPS.PA_CI_TYPES_PVT dependencies on PA_CI_TYPES_PVT

Line 1: PACKAGE BODY pa_ci_types_pvt AS

1: PACKAGE BODY pa_ci_types_pvt AS
2: /* $Header: PACITYVB.pls 120.2.12010000.11 2009/10/28 19:34:13 cklee ship $ */
3:
4: PROCEDURE create_ci_type (
5: p_api_version IN NUMBER := 1.0,

Line 71: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.CREATE_CI_TYPE');

67: l_dist_list_id NUMBER; -- Bug 4565156.
68: l_approval_required_flag varchar2(1) := p_approval_required_flag; --28-oct-2009 cklee fxied bug: 9063248
69:
70: BEGIN
71: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.CREATE_CI_TYPE');
72:
73: IF p_commit = FND_API.G_TRUE THEN
74: SAVEPOINT create_ci_type;
75: END IF;

Line 274: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',

270: ROLLBACK TO create_ci_type;
271: END IF;
272:
273: x_return_status := 'U';
274: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
275: p_procedure_name => 'CREATE_CI_TYPE',
276: p_error_text => SUBSTRB(SQLERRM,1,240));
277:
278: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 492: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.UPDATE_CI_TYPE');

488: imp_code_rec imp_code_csr%ROWTYPE;
489: l_approval_required_flag varchar2(1) := p_approval_required_flag; --28-oct-2009 cklee fxied bug: 9063248
490:
491: BEGIN
492: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.UPDATE_CI_TYPE');
493:
494: IF p_commit = FND_API.G_TRUE THEN
495: SAVEPOINT update_ci_type;
496: END IF;

Line 1006: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',

1002: ROLLBACK TO update_ci_type;
1003: END IF;
1004:
1005: x_return_status := 'U';
1006: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
1007: p_procedure_name => 'UPDATE_CI_TYPE',
1008: p_error_text => SUBSTRB(SQLERRM,1,240));
1009:
1010: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1046: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.DELETE_CI_TYPE');

1042: WHERE obj_status_list_id = p_obj_status_list_id;
1043:
1044: l_temp VARCHAR2(1);
1045: BEGIN
1046: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.DELETE_CI_TYPE');
1047:
1048: IF p_commit = FND_API.G_TRUE THEN
1049: SAVEPOINT delete_ci_type;
1050: END IF;

Line 1193: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',

1189: ROLLBACK TO delete_ci_type;
1190: END IF;
1191:
1192: x_return_status := 'U';
1193: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
1194: p_procedure_name => 'DELETE_CI_TYPE',
1195: p_error_text => SUBSTRB(SQLERRM,1,240));
1196:
1197: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1201: END pa_ci_types_pvt;

1197: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1198: p_data => x_msg_data);
1199: END delete_ci_type;
1200:
1201: END pa_ci_types_pvt;