DBA Data[Home] [Help]

APPS.PA_CI_ACTIONS_PVT dependencies on PA_CI_ACTIONS_PVT

Line 1: PACKAGE BODY PA_CI_ACTIONS_PVT AS

1: PACKAGE BODY PA_CI_ACTIONS_PVT AS
2: /* $Header: PACIACVB.pls 120.0 2005/06/03 13:27:41 appldev noship $ */
3:
4:
5: PROCEDURE CREATE_CI_ACTION (

Line 52: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_PVT.CREATE_CI_ACTION');

48: where ci_id = p_ci_id;
49:
50: BEGIN
51: -- Initialize the Error Stack
52: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_PVT.CREATE_CI_ACTION');
53:
54: -- Initialize the return status to success
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:

Line 110: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(

106: end if;
107:
108: If (x_return_status = fnd_api.g_ret_sts_success
109: AND p_validate_only <> fnd_api.g_true) then
110: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
111: p_api_version => P_API_VERSION,
112: p_init_msg_list => P_INIT_MSG_LIST,
113: p_commit => P_COMMIT,
114: p_validate_only => P_VALIDATE_ONLY,

Line 192: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',

188: THEN
189: ROLLBACK TO ADD_ACTION;
190: END IF;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
193: p_procedure_name => 'CREATE_CI_ACTIONS',
194: p_error_text => SUBSTRB(SQLERRM,1,240));
195: RAISE;
196: END CREATE_CI_ACTION;

Line 255: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_PVT.CLOSE_CI_ACTION');

251: from pa_control_items
252: where ci_id = l_ci_id;
253: BEGIN
254: -- Initialize the Error Stack
255: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_PVT.CLOSE_CI_ACTION');
256:
257: -- Initialize the return status to success
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259:

Line 322: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(

318: end if;
319:
320: If (x_return_status = fnd_api.g_ret_sts_success
321: AND p_validate_only <> fnd_api.g_true) then
322: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
323: p_api_version => P_API_VERSION,
324: p_init_msg_list => P_INIT_MSG_LIST,
325: p_commit => P_COMMIT,
326: p_validate_only => P_VALIDATE_ONLY,

Line 394: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',

390: IF p_commit = FND_API.G_TRUE THEN
391: ROLLBACK TO CLOSE_CI_ACTION;
392: END IF;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
395: p_procedure_name => 'CLOSE_CI_ACTIONS',
396: p_error_text => SUBSTRB(SQLERRM,1,240));
397: RAISE;
398: END CLOSE_CI_ACTION;

Line 453: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_PVT.REASSIGN_CI_ACTION');

449:
450:
451: BEGIN
452: -- Initialize the Error Stack
453: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_PVT.REASSIGN_CI_ACTION');
454:
455: -- Initialize the return status to success
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457: x_msg_data := 0;

Line 520: PA_CI_ACTIONS_PVT.CLOSE_CI_ACTION

516:
517:
518: If (x_return_status = fnd_api.g_ret_sts_success
519: AND p_validate_only <> fnd_api.g_true) then
520: PA_CI_ACTIONS_PVT.CLOSE_CI_ACTION
521: (
522: p_api_version => P_API_VERSION,
523: p_init_msg_list => P_INIT_MSG_LIST,
524: p_commit => P_COMMIT,

Line 541: PA_CI_ACTIONS_PVT.CREATE_CI_ACTION

537:
538: If (x_return_status = fnd_api.g_ret_sts_success
539: AND p_validate_only <> fnd_api.g_true) then
540:
541: PA_CI_ACTIONS_PVT.CREATE_CI_ACTION
542: (
543: P_API_VERSION => P_API_VERSION,
544: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
545: P_COMMIT => P_COMMIT,

Line 578: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',

574: IF p_commit = FND_API.G_TRUE THEN
575: ROLLBACK TO REASSIGN_CI_ACTION;
576: END IF;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
579: p_procedure_name => 'REASSIGN_CI_ACTION',
580: p_error_text => SUBSTRB(SQLERRM,1,240));
581: RAISE;
582: END REASSIGN_CI_ACTION;

Line 709: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(

705: end if;
706:
707: If (x_return_status = fnd_api.g_ret_sts_success
708: AND p_validate_only <> fnd_api.g_true) then
709: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
710: p_api_version => P_API_VERSION,
711: p_init_msg_list => P_INIT_MSG_LIST,
712: p_commit => P_COMMIT,
713: p_validate_only => P_VALIDATE_ONLY,

Line 763: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',

759: IF p_commit = FND_API.G_TRUE THEN
760: ROLLBACK TO CLOSE_CI_ACTION;
761: END IF;
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
764: p_procedure_name => 'CLOSE_CI_ACTIONS',
765: p_error_text => SUBSTRB(SQLERRM,1,240));
766: RAISE;
767: END CANCEL_CI_ACTION;

Line 871: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',

867: IF p_commit = FND_API.G_TRUE THEN
868: ROLLBACK TO UPDATE_CI_COMMENT;
869: END IF;
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
872: p_procedure_name => 'UPDATE_CI_COMMENT',
873: p_error_text => SUBSTRB(SQLERRM,1,240));
874: RAISE;
875:

Line 943: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',

939: IF p_commit = FND_API.G_TRUE THEN
940: ROLLBACK TO ADD_CI_COMMENT;
941: END IF;
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
943: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
944: p_procedure_name => 'ADD_CI_COMMENT',
945: p_error_text => SUBSTRB(SQLERRM,1,240));
946: RAISE;
947: END ADD_CI_COMMENT;

Line 1001: PA_CI_ACTIONS_PVT.CANCEL_CI_ACTION

997: LOOP
998: FETCH cancel_action INTO l_ci_action_id,
999: l_record_version_number;
1000: EXIT WHEN cancel_action%NOTFOUND;
1001: PA_CI_ACTIONS_PVT.CANCEL_CI_ACTION
1002: (
1003: p_api_version => P_API_VERSION,
1004: p_init_msg_list => P_INIT_MSG_LIST,
1005: p_commit => P_COMMIT,

Line 1033: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',

1029: IF p_commit = FND_API.G_TRUE THEN
1030: ROLLBACK TO ADD_CI_COMMENT;
1031: END IF;
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1033: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
1034: p_procedure_name => 'DELETE_ALL_ACTIONS',
1035: p_error_text => SUBSTRB(SQLERRM,1,240));
1036: RAISE;
1037: END CANCEL_ALL_ACTIONS;

Line 1112: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',

1108: IF p_commit = FND_API.G_TRUE THEN
1109: ROLLBACK TO ADD_CI_COMMENT;
1110: END IF;
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
1113: p_procedure_name => 'DELETE_ALL_ACTIONS',
1114: p_error_text => SUBSTRB(SQLERRM,1,240));
1115: RAISE;
1116: END DELETE_ALL_ACTIONS;

Line 1119: END PA_CI_ACTIONS_PVT; -- Package Body PA_CI_ACTIONS_PVT

1115: RAISE;
1116: END DELETE_ALL_ACTIONS;
1117:
1118:
1119: END PA_CI_ACTIONS_PVT; -- Package Body PA_CI_ACTIONS_PVT