DBA Data[Home] [Help]

APPS.PA_CI_IMPACTS_PUB dependencies on PA_CI_IMPACTS_PUB

Line 1: PACKAGE BODY PA_CI_IMPACTS_pub AS

1: PACKAGE BODY PA_CI_IMPACTS_pub AS
2: /* $Header: PACIIPPB.pls 120.1 2011/02/01 04:07:44 rmandali ship $ */
3:
4: PROCEDURE create_ci_impact (
5: p_api_version IN NUMBER := 1.0,

Line 42: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.CREATE_CI_IMPACTS');

38: and pt.task_name = p_impacted_task_name
39: AND pc.ci_id = p_ci_id;
40:
41: BEGIN
42: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.CREATE_CI_IMPACTS');
43:
44: IF p_commit = 'T' THEN
45: SAVEPOINT create_ci_impact;
46: END IF;

Line 121: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PUB',

117: ROLLBACK TO create_ci_impact;
118: END IF;
119:
120: x_return_status := 'U';
121: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PUB',
122: p_procedure_name => 'CREATE_CI_IMPACT',
123: p_error_text => SUBSTRB(SQLERRM,1,240));
124:
125: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 146: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.DELETE_CI_IMPACT');

142: IS
143: l_temp VARCHAR2(1);
144: l_msg_index_out NUMBER;
145: BEGIN
146: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.DELETE_CI_IMPACT');
147:
148: IF p_commit = 'T' THEN
149: SAVEPOINT delete_ci_impact;
150: END IF;

Line 256: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.CREATE_CI_IMPACTS');

252: SELECT * FROM pa_ci_impacts
253: WHERE ci_impact_id = p_ci_impact_id;
254:
255: BEGIN
256: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.CREATE_CI_IMPACTS');
257:
258: IF p_commit = 'T' THEN
259: SAVEPOINT update_ci_impact;
260: END IF;

Line 379: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PUB',

375: ROLLBACK TO update_ci_impact;
376: END IF;
377:
378: x_return_status := 'U';
379: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PUB',
380: p_procedure_name => 'UPDATE_CI_IMPACT',
381: p_error_text => SUBSTRB(SQLERRM,1,240));
382:
383: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 387: END PA_CI_IMPACTS_pub;

383: fnd_msg_pub.count_and_get(p_count => x_msg_count,
384: p_data => x_msg_data);
385: END update_ci_impact;
386:
387: END PA_CI_IMPACTS_pub;