APPS.PA_CI_IMPACT_TYPE_USAGE_PVT dependencies on PA_CI_IMPACT_TYPE_USAGE_PVT

Line 1: PACKAGE BODY PA_CI_IMPACT_TYPE_USAGE_pvt AS

1: PACKAGE BODY PA_CI_IMPACT_TYPE_USAGE_pvt AS
2: /* $Header: PACIIMVB.pls 120.0.12010000.4 2009/10/06 21:58:32 cklee ship $ */
3:
4: PROCEDURE create_ci_impact_type_usage (
5: p_api_version IN NUMBER := 1.0,

Line 41: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PVT.CREATE_CI_IMPACT_TYPE_USAGE');

37:
38: l_dummy VARCHAR2(1);
39:
40: BEGIN
41: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PVT.CREATE_CI_IMPACT_TYPE_USAGE');
42:
43: IF p_commit = 'T' THEN
44: SAVEPOINT create_ci_impact_type_usage;
45: END IF;

Line 105: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',

101: ROLLBACK TO create_ci_impact_type_usage;
102: END IF;
103:
104: x_return_status := 'U';
105: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',
106: p_procedure_name => 'CREATE_CI_IMPACT_TYPE_USAGE',
107: p_error_text => SUBSTRB(SQLERRM,1,240));
108:
109: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 132: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PVT.UPDATE_CI_IMPACT_TYPE_USAGE');

128: )
129: is
130:
131: BEGIN
132: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PVT.UPDATE_CI_IMPACT_TYPE_USAGE');
133:
134: IF p_commit = 'T' THEN
135: SAVEPOINT update_ci_impact_type_usage;
136: END IF;

Line 172: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',

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

Line 221: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PVT.DELETE_CI_IMPACT_TYPE_USAGE');

217:
218:
219: l_dummy VARCHAR2(1);
220: BEGIN
221: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PVT.DELETE_CI_IMPACT_TYPE_USAGE');
222:
223: IF p_commit = 'T' THEN
224: SAVEPOINT delete_ci_impact_type_usage;
225: END IF;

Line 392: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PVT.APPLY_CI_IMPACT_TYPE_USAGE');

388:
389: BEGIN
390:
391:
392: pa_debug.set_err_stack ('PA_CI_IMPACT_TYPE_USAGE_PVT.APPLY_CI_IMPACT_TYPE_USAGE');
393:
394: IF p_commit = 'T' THEN
395: SAVEPOINT apply_ci_impact_type_usage;
396: END IF;

Line 427: PA_CI_IMPACT_TYPE_USAGE_pvt.delete_CI_IMPACT_TYPE_USAGE(

423: IF p_ui_mode = 'UPDATE' AND p_ci_class_code <> 'ISSUE' THEN
424:
425: FOR delete_impacts_rec IN delete_impacts_csr (p_ci_type_id)
426: LOOP
427: PA_CI_IMPACT_TYPE_USAGE_pvt.delete_CI_IMPACT_TYPE_USAGE(
428: --p_api_version => p_api_version,
429: --p_init_msg_list => p_init_msg_list,
430: --p_commit => p_commit,
431: p_validate_only => p_validate_only,

Line 573: PA_CI_IMPACT_TYPE_USAGE_pvt.CREATE_CI_IMPACT_TYPE_USAGE(

569:
570: FOR i in l_impact_tbl.FIRST..l_impact_tbl.LAST LOOP
571:
572:
573: PA_CI_IMPACT_TYPE_USAGE_pvt.CREATE_CI_IMPACT_TYPE_USAGE(
574: --p_api_version => p_api_version,
575: --p_init_msg_list => p_init_msg_list,
576: --p_commit => p_commit,
577: p_validate_only => p_validate_only,

Line 668: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',

664: ROLLBACK TO apply_ci_impact_type_usage;
665: END IF;
666:
667: x_return_status := 'U';
668: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',
669: p_procedure_name => 'APPLY_CI_IMPACT_TYPE_USAGE',
670: p_error_text => SUBSTRB(SQLERRM,1,240));
671:
672: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 679: END PA_CI_IMPACT_TYPE_USAGE_pvt;

675:
676:
677: END apply_ci_impact_type_usage;
678:
679: END PA_CI_IMPACT_TYPE_USAGE_pvt;