DBA Data[Home] [Help]

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 2005/09/08 01:51:15 raluthra noship $ */
3:
4: PROCEDURE create_ci_type (
5: p_api_version IN NUMBER := 1.0,

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

52: l_obj_sl_rowid VARCHAR2(30);
53: l_obj_status_list_id NUMBER;
54: l_dist_list_id NUMBER; -- Bug 4565156.
55: BEGIN
56: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.CREATE_CI_TYPE');
57:
58: IF p_commit = FND_API.G_TRUE THEN
59: SAVEPOINT create_ci_type;
60: END IF;

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

213: ROLLBACK TO create_ci_type;
214: END IF;
215:
216: x_return_status := 'U';
217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
218: p_procedure_name => 'CREATE_CI_TYPE',
219: p_error_text => SUBSTRB(SQLERRM,1,240));
220:
221: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

276: l_reason_category VARCHAR2(150);
277: l_resolution_category VARCHAR2(150);
278:
279: BEGIN
280: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.UPDATE_CI_TYPE');
281:
282: IF p_commit = FND_API.G_TRUE THEN
283: SAVEPOINT update_ci_type;
284: END IF;

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

479: ROLLBACK TO update_ci_type;
480: END IF;
481:
482: x_return_status := 'U';
483: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
484: p_procedure_name => 'UPDATE_CI_TYPE',
485: p_error_text => SUBSTRB(SQLERRM,1,240));
486:
487: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

519: WHERE obj_status_list_id = p_obj_status_list_id;
520:
521: l_temp VARCHAR2(1);
522: BEGIN
523: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.DELETE_CI_TYPE');
524:
525: IF p_commit = FND_API.G_TRUE THEN
526: SAVEPOINT delete_ci_type;
527: END IF;

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

645: ROLLBACK TO delete_ci_type;
646: END IF;
647:
648: x_return_status := 'U';
649: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
650: p_procedure_name => 'DELETE_CI_TYPE',
651: p_error_text => SUBSTRB(SQLERRM,1,240));
652:
653: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 657: END pa_ci_types_pvt;

653: fnd_msg_pub.count_and_get(p_count => x_msg_count,
654: p_data => x_msg_data);
655: END delete_ci_type;
656:
657: END pa_ci_types_pvt;