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.3.12020000.2 2012/07/31 14:23:48 svmohamm ship $ */
3:
4:
5: PROCEDURE CREATE_CI_ACTION (

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

54: and sv.project_status_code = ci.status_code ;
55:
56: BEGIN
57: -- Initialize the Error Stack
58: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_PVT.CREATE_CI_ACTION');
59:
60: -- Initialize the return status to success
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:

Line 113: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(

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

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

199: THEN
200: ROLLBACK TO ADD_ACTION;
201: END IF;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
204: p_procedure_name => 'CREATE_CI_ACTIONS',
205: p_error_text => SUBSTRB(SQLERRM,1,240));
206: RAISE;
207: END CREATE_CI_ACTION;

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

264: from pa_control_items
265: where ci_id = l_ci_id;
266: BEGIN
267: -- Initialize the Error Stack
268: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_PVT.CLOSE_CI_ACTION');
269:
270: -- Initialize the return status to success
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272:

Line 346: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(

342: end if;
343:
344: If (x_return_status = fnd_api.g_ret_sts_success
345: AND p_validate_only <> fnd_api.g_true) then
346: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
347: p_api_version => P_API_VERSION,
348: p_init_msg_list => P_INIT_MSG_LIST,
349: p_commit => P_COMMIT,
350: p_validate_only => P_VALIDATE_ONLY,

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

415: IF p_commit = FND_API.G_TRUE THEN
416: ROLLBACK TO CLOSE_CI_ACTION;
417: END IF;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
420: p_procedure_name => 'CLOSE_CI_ACTIONS',
421: p_error_text => SUBSTRB(SQLERRM,1,240));
422: RAISE;
423: END CLOSE_CI_ACTION;

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

474:
475:
476: BEGIN
477: -- Initialize the Error Stack
478: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_PVT.REASSIGN_CI_ACTION');
479:
480: -- Initialize the return status to success
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482: x_msg_data := 0;

Line 545: PA_CI_ACTIONS_PVT.CLOSE_CI_ACTION

541:
542:
543: If (x_return_status = fnd_api.g_ret_sts_success
544: AND p_validate_only <> fnd_api.g_true) then
545: PA_CI_ACTIONS_PVT.CLOSE_CI_ACTION
546: (
547: p_api_version => P_API_VERSION,
548: p_init_msg_list => P_INIT_MSG_LIST,
549: p_commit => P_COMMIT,

Line 566: PA_CI_ACTIONS_PVT.CREATE_CI_ACTION

562:
563: If (x_return_status = fnd_api.g_ret_sts_success
564: AND p_validate_only <> fnd_api.g_true) then
565:
566: PA_CI_ACTIONS_PVT.CREATE_CI_ACTION
567: (
568: P_API_VERSION => P_API_VERSION,
569: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
570: P_COMMIT => P_COMMIT,

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

599: IF p_commit = FND_API.G_TRUE THEN
600: ROLLBACK TO REASSIGN_CI_ACTION;
601: END IF;
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
604: p_procedure_name => 'REASSIGN_CI_ACTION',
605: p_error_text => SUBSTRB(SQLERRM,1,240));
606: RAISE;
607: END REASSIGN_CI_ACTION;

Line 734: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(

730: end if;
731:
732: If (x_return_status = fnd_api.g_ret_sts_success
733: AND p_validate_only <> fnd_api.g_true) then
734: PA_CI_ACTIONS_PVT.ADD_CI_COMMENT(
735: p_api_version => P_API_VERSION,
736: p_init_msg_list => P_INIT_MSG_LIST,
737: p_commit => P_COMMIT,
738: p_validate_only => P_VALIDATE_ONLY,

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

791: IF p_commit = FND_API.G_TRUE THEN
792: ROLLBACK TO CLOSE_CI_ACTION;
793: END IF;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
796: p_procedure_name => 'CLOSE_CI_ACTIONS',
797: p_error_text => SUBSTRB(SQLERRM,1,240));
798: RAISE;
799: END CANCEL_CI_ACTION;

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

899: IF p_commit = FND_API.G_TRUE THEN
900: ROLLBACK TO UPDATE_CI_COMMENT;
901: END IF;
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
904: p_procedure_name => 'UPDATE_CI_COMMENT',
905: p_error_text => SUBSTRB(SQLERRM,1,240));
906: RAISE;
907:

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

971: IF p_commit = FND_API.G_TRUE THEN
972: ROLLBACK TO ADD_CI_COMMENT;
973: END IF;
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
975: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
976: p_procedure_name => 'ADD_CI_COMMENT',
977: p_error_text => SUBSTRB(SQLERRM,1,240));
978: RAISE;
979: END ADD_CI_COMMENT;

Line 1033: PA_CI_ACTIONS_PVT.CANCEL_CI_ACTION

1029: LOOP
1030: FETCH cancel_action INTO l_ci_action_id,
1031: l_record_version_number;
1032: EXIT WHEN cancel_action%NOTFOUND;
1033: PA_CI_ACTIONS_PVT.CANCEL_CI_ACTION
1034: (
1035: p_api_version => P_API_VERSION,
1036: p_init_msg_list => P_INIT_MSG_LIST,
1037: p_commit => P_COMMIT,

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

1061: IF p_commit = FND_API.G_TRUE THEN
1062: ROLLBACK TO ADD_CI_COMMENT;
1063: END IF;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
1066: p_procedure_name => 'DELETE_ALL_ACTIONS',
1067: p_error_text => SUBSTRB(SQLERRM,1,240));
1068: RAISE;
1069: END CANCEL_ALL_ACTIONS;

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

1140: IF p_commit = FND_API.G_TRUE THEN
1141: ROLLBACK TO ADD_CI_COMMENT;
1142: END IF;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_ACTIONS_PVT',
1145: p_procedure_name => 'DELETE_ALL_ACTIONS',
1146: p_error_text => SUBSTRB(SQLERRM,1,240));
1147: RAISE;
1148: END DELETE_ALL_ACTIONS;

Line 1151: END PA_CI_ACTIONS_PVT; -- Package Body PA_CI_ACTIONS_PVT

1147: RAISE;
1148: END DELETE_ALL_ACTIONS;
1149:
1150:
1151: END PA_CI_ACTIONS_PVT; -- Package Body PA_CI_ACTIONS_PVT