eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CI_ACTIONS_PVT dependencies on PA_CI_ACTIONS

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 75: l_action_number := PA_CI_ACTIONS_UTIL.get_next_ci_action_number(p_ci_id);

71:
72:
73:
74: if (p_ci_id IS NOT NULL) then
75: l_action_number := PA_CI_ACTIONS_UTIL.get_next_ci_action_number(p_ci_id);
76: end if;
77:
78: -- Validate the Input Values
79: If (x_return_status = fnd_api.g_ret_sts_success

Line 82: PA_CI_ACTIONS_PKG.INSERT_ROW(

78: -- Validate the Input Values
79: If (x_return_status = fnd_api.g_ret_sts_success
80: AND p_validate_only <> fnd_api.g_true) then
81:
82: PA_CI_ACTIONS_PKG.INSERT_ROW(
83: P_CI_ACTION_ID => l_ci_action_id,
84: P_CI_ID => P_CI_ID,
85: P_CI_ACTION_NUMBER => l_action_number,
86: P_STATUS_CODE => 'CI_ACTION_OPEN',

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 219: from pa_ci_actions

215: )
216: IS
217: Cursor check_record_changed IS
218: select rowid
219: from pa_ci_actions
220: where ci_action_id = p_ci_action_id
221: and record_version_number = p_record_version_number
222: for update;
223:

Line 227: from pa_ci_actions

223:
224: Cursor ci_action IS
225: select ci_id, type_code, assigned_to, date_required,
226: sign_off_required_flag, source_ci_action_id, created_by, creation_date
227: from pa_ci_actions
228: where ci_action_id = p_ci_action_id;
229:
230: l_party_id number;
231: l_created_by number;

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 295: PA_CI_ACTIONS_PKG.UPDATE_ROW(

291: CLOSE check_record_changed;
292: end if;
293: If (x_return_status = fnd_api.g_ret_sts_success
294: AND p_validate_only <> fnd_api.g_true) then
295: PA_CI_ACTIONS_PKG.UPDATE_ROW(
296: P_CI_ACTION_ID => P_CI_ACTION_ID,
297: P_CI_ID => l_ci_id,
298: P_STATUS_CODE => 'CI_ACTION_CLOSED',
299: P_TYPE_CODE => l_type_code,

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 426: from pa_ci_actions

422: )
423: IS
424: Cursor check_record_changed IS
425: select rowid
426: from pa_ci_actions
427: where ci_action_id = p_ci_action_id
428: and record_version_number = p_record_version_number
429: for update;
430:

Line 434: from pa_ci_actions

430:
431: Cursor ci_action IS
432: select ci_id, type_code, assigned_to, date_required,
433: sign_off_required_flag, source_ci_action_id
434: from pa_ci_actions
435: where ci_action_id = p_ci_action_id;
436:
437: l_new_ci_action_id number;
438: l_ci_id number;

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 495: from pa_ci_actions

491:
492: -- Validate if the action is being reassigned to the same person and check if date is before system date.
493: select assigned_to
494: into l_assigned_to_party
495: from pa_ci_actions
496: where ci_action_id = p_ci_action_id;
497:
498:
499: if (p_assigned_to is not null and (l_assigned_to_party = p_assigned_to OR ((P_DATE_REQUIRED is not null) and (P_DATE_REQUIRED < sysdate))))then

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 603: from pa_ci_actions

599: )
600: IS
601: Cursor check_record_changed IS
602: select rowid
603: from pa_ci_actions
604: where ci_action_id = p_ci_action_id
605: and record_version_number = p_record_version_number
606: for update;
607:

Line 611: from pa_ci_actions

607:
608: Cursor ci_action IS
609: select ci_id, type_code, assigned_to, date_required,
610: sign_off_required_flag, source_ci_action_id, created_by, creation_date, sign_off_flag
611: from pa_ci_actions
612: where ci_action_id = p_ci_action_id;
613:
614: l_party_id number;
615: l_created_by number;

Line 681: PA_CI_ACTIONS_PKG.UPDATE_ROW(

677: CLOSE check_record_changed;
678: end if;
679: If (x_return_status = fnd_api.g_ret_sts_success
680: AND p_validate_only <> fnd_api.g_true) then
681: PA_CI_ACTIONS_PKG.UPDATE_ROW(
682: P_CI_ACTION_ID => P_CI_ACTION_ID,
683: P_CI_ID => l_ci_id,
684: P_STATUS_CODE => 'CI_ACTION_CANCELED',
685: P_TYPE_CODE => l_type_code,

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 974: FROM PA_CI_ACTIONS pca

970: l_cancel_comment varchar2(32767);
971:
972: CURSOR cancel_action IS
973: SELECT ci_action_id, record_version_number
974: FROM PA_CI_ACTIONS pca
975: WHERE pca.ci_id = p_ci_id
976: AND status_code = 'CI_ACTION_OPEN';
977:
978:

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 1058: FROM PA_CI_ACTIONS

1054: l_ci_comment_id number;
1055:
1056: CURSOR delete_action IS
1057: SELECT ci_action_id
1058: FROM PA_CI_ACTIONS
1059: WHERE ci_id = p_ci_id;
1060:
1061: CURSOR delete_comment IS
1062: SELECT ci_comment_id

Line 1082: PA_CI_ACTIONS_PKG.DELETE_ROW(

1078: OPEN delete_action;
1079: LOOP
1080: FETCH delete_action INTO l_ci_action_id;
1081: EXIT WHEN delete_action%NOTFOUND;
1082: PA_CI_ACTIONS_PKG.DELETE_ROW(
1083: P_CI_ACTION_ID => l_ci_action_id);
1084: OPEN delete_comment;
1085: LOOP
1086: FETCH delete_comment INTO l_ci_comment_id;

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