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_CONTROL_ITEMS_PVT dependencies on FND_API

Line 7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

3:
4:
5: procedure ADD_CONTROL_ITEM(
6: p_api_version IN NUMBER := 1.0
7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
8: ,p_commit IN VARCHAR2 := FND_API.g_false
9: ,p_validate_only IN VARCHAR2 := FND_API.g_true
10: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
11: ,p_ci_type_id IN NUMBER

Line 8: ,p_commit IN VARCHAR2 := FND_API.g_false

4:
5: procedure ADD_CONTROL_ITEM(
6: p_api_version IN NUMBER := 1.0
7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
8: ,p_commit IN VARCHAR2 := FND_API.g_false
9: ,p_validate_only IN VARCHAR2 := FND_API.g_true
10: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
11: ,p_ci_type_id IN NUMBER
12: ,p_summary IN VARCHAR2

Line 9: ,p_validate_only IN VARCHAR2 := FND_API.g_true

5: procedure ADD_CONTROL_ITEM(
6: p_api_version IN NUMBER := 1.0
7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
8: ,p_commit IN VARCHAR2 := FND_API.g_false
9: ,p_validate_only IN VARCHAR2 := FND_API.g_true
10: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
11: ,p_ci_type_id IN NUMBER
12: ,p_summary IN VARCHAR2
13: ,p_status_code IN VARCHAR2

Line 10: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

6: p_api_version IN NUMBER := 1.0
7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
8: ,p_commit IN VARCHAR2 := FND_API.g_false
9: ,p_validate_only IN VARCHAR2 := FND_API.g_true
10: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
11: ,p_ci_type_id IN NUMBER
12: ,p_summary IN VARCHAR2
13: ,p_status_code IN VARCHAR2
14: ,p_owner_id IN NUMBER

Line 105: x_return_status := FND_API.G_RET_STS_SUCCESS;

101: BEGIN
102:
103: -- Initialize the Error Stack
104: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Add_Control_Item');
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: -- Issue API savepoint if the transaction is to be committed
108: IF p_commit = FND_API.G_TRUE THEN
109: SAVEPOINT add_control_item;

Line 108: IF p_commit = FND_API.G_TRUE THEN

104: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Add_Control_Item');
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: -- Issue API savepoint if the transaction is to be committed
108: IF p_commit = FND_API.G_TRUE THEN
109: SAVEPOINT add_control_item;
110: END IF;
111:
112:

Line 134: x_return_status := FND_API.G_RET_STS_ERROR;

130: ,p_status_code
131: ,p_owner_id
132: -- ,l_ci_number_char
133: ,p_summary) THEN
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: PA_DEBUG.Reset_Err_Stack;
136: RETURN;
137: END IF;
138:

Line 147: x_return_status := FND_API.G_RET_STS_ERROR;

143: if (c_item_type%notfound) then
144: close c_item_type;
145: PA_UTILS.Add_Message( p_app_short_name => 'PA'
146: ,p_msg_name => 'PA_CI_INVALID_TYPE_ID');
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: --PA_DEBUG.RESET_ERR_STACK;
149: -- return;
150: end if;
151: l_type_class_code := cp_type.ci_type_class_code;

Line 164: x_return_status := FND_API.G_RET_STS_ERROR;

160: if (c_system_stat%notfound) then
161: close c_system_stat;
162: PA_UTILS.Add_Message( p_app_short_name => 'PA'
163: ,p_msg_name => 'PA_CI_INVALID_STATUS_CODE');
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: -- PA_DEBUG.RESET_ERR_STACK;
166: -- return;
167: end if;
168: l_system_status_code := cp_stat_code.project_system_status_code;

Line 190: IF x_return_status <> FND_API.g_ret_sts_success THEN

186: ,x_return_status => x_return_status
187: ,x_msg_count => x_msg_count
188: ,x_msg_data => x_msg_data);
189:
190: IF x_return_status <> FND_API.g_ret_sts_success THEN
191: PA_DEBUG.Reset_Err_Stack;
192: raise API_ERROR;
193: END IF;
194: l_ci_number_char := TO_CHAR(l_ci_number_num);

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212:
213: if ci_number_exists(p_project_id, l_ci_number_char ,p_ci_type_id) = TRUE then
214: PA_UTILS.Add_Message( p_app_short_name => 'PA'
215: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: PA_DEBUG.RESET_ERR_STACK;
218: return;
219:
220: end if;

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223:
224: IF l_ci_number_char is NULL and l_system_status_code <> DRAFT_STATUS THEN
225: PA_UTILS.Add_Message( p_app_short_name => 'PA'
226: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: PA_DEBUG.Reset_Err_Stack;
229: RETURN;
230:
231: END IF;

Line 312: IF ( p_validate_only = FND_API.G_FALSE AND x_return_status = FND_API.g_ret_sts_success )THEN

308: END IF;
309:
310: -- Launch the workflow notification if it is not validate only mode and no errors occured till now.
311: -- Bug 3297238. FP M changes.
312: IF ( p_validate_only = FND_API.G_FALSE AND x_return_status = FND_API.g_ret_sts_success )THEN
313: pa_control_items_workflow.START_NOTIFICATION_WF
314: ( p_item_type => 'PAWFCISC'
315: ,p_process_name => 'PA_CI_OWNER_CHANGE_FYI'
316: ,p_ci_id => px_ci_id

Line 323: IF x_return_status <> FND_API.g_ret_sts_success THEN

319: ,x_return_status => x_return_status
320: ,x_msg_count => x_msg_count
321: ,x_msg_data => x_msg_data );
322:
323: IF x_return_status <> FND_API.g_ret_sts_success THEN
324: PA_DEBUG.Reset_Err_Stack;
325: raise API_ERROR;
326: END IF;
327: END IF;

Line 330: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN

326: END IF;
327: END IF;
328:
329: -- Commit if the flag is set and there is no error
330: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN
331: COMMIT;
332: END IF;
333:
334:

Line 344: IF p_commit = FND_API.G_TRUE THEN

340: WHEN API_ERROR THEN
341: x_return_status := x_return_status;
342:
343: WHEN OTHERS THEN
344: IF p_commit = FND_API.G_TRUE THEN
345: ROLLBACK TO add_control_item;
346: END IF;
347:
348: -- Set the excetption Message and the stack

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

349: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.add_control_item'
350: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
351:
352:
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354: RAISE;
355:
356: end ADD_CONTROL_ITEM;
357:

Line 360: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

356: end ADD_CONTROL_ITEM;
357:
358: procedure UPDATE_CONTROL_ITEM (
359: p_api_version IN NUMBER := 1.0
360: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validate_only IN VARCHAR2 := FND_API.g_true
363: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
364:

Line 361: ,p_commit IN VARCHAR2 := FND_API.g_false

357:
358: procedure UPDATE_CONTROL_ITEM (
359: p_api_version IN NUMBER := 1.0
360: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validate_only IN VARCHAR2 := FND_API.g_true
363: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
364:
365: ,p_ci_id IN NUMBER

Line 362: ,p_validate_only IN VARCHAR2 := FND_API.g_true

358: procedure UPDATE_CONTROL_ITEM (
359: p_api_version IN NUMBER := 1.0
360: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validate_only IN VARCHAR2 := FND_API.g_true
363: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
364:
365: ,p_ci_id IN NUMBER
366: ,p_ci_type_id IN NUMBER

Line 363: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

359: p_api_version IN NUMBER := 1.0
360: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validate_only IN VARCHAR2 := FND_API.g_true
363: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
364:
365: ,p_ci_id IN NUMBER
366: ,p_ci_type_id IN NUMBER
367: ,p_summary IN VARCHAR2

Line 459: x_return_status := FND_API.G_RET_STS_SUCCESS;

455:
456: -- Initialize the Error Stack
457: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Update_Control_Item');
458:
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461: -- Issue API savepoint if the transaction is to be committed
462: IF p_commit = FND_API.G_TRUE THEN
463: SAVEPOINT update_control_item;

Line 462: IF p_commit = FND_API.G_TRUE THEN

458:
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461: -- Issue API savepoint if the transaction is to be committed
462: IF p_commit = FND_API.G_TRUE THEN
463: SAVEPOINT update_control_item;
464: END IF;
465:
466: OPEN curr_row;

Line 472: x_return_status := FND_API.G_RET_STS_ERROR;

468: if curr_row%NOTFOUND then
469: close curr_row;
470: PA_UTILS.Add_Message( p_app_short_name => 'PA'
471: ,p_msg_name => 'PA_CI_INVALID_ITEM');
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: return;
474: PA_DEBUG.Reset_Err_Stack;
475: end if;
476:

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: else
541: close C;
542: PA_UTILS.Add_Message( p_app_short_name => 'PA'
543: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: PA_DEBUG.Reset_Err_Stack;
546: return;
547: end if;
548: else

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550: l_ci_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_status_code);
551: if l_ci_system_status is NULL then
552: PA_UTILS.Add_Message( p_app_short_name => 'PA'
553: ,p_msg_name => 'PA_CI_NO_STATUS');
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: PA_DEBUG.Reset_Err_Stack;
556: return;
557: end if;
558: if 'CI_DRAFT' <> l_ci_system_status then

Line 561: x_return_status := FND_API.G_RET_STS_ERROR;

557: end if;
558: if 'CI_DRAFT' <> l_ci_system_status then
559: PA_UTILS.Add_Message( p_app_short_name => 'PA'
560: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: PA_DEBUG.Reset_Err_Stack;
563: return;
564: end if;
565: end if;

Line 632: IF ( p_validate_only = FND_API.G_FALSE AND

628:
629: -- Launch the workflow notification if it is not validate only mode and no errors occured till now and
630: -- the owner is getting changed.
631: -- Bug 3297238. FP M Changes.
632: IF ( p_validate_only = FND_API.G_FALSE AND
633: x_return_status = FND_API.g_ret_sts_success AND
634: l_prev_owner_id <> p_owner_id )THEN -- owner id cannot be null as it is validated in public API.
635:
636: pa_control_items_workflow.START_NOTIFICATION_WF

Line 633: x_return_status = FND_API.g_ret_sts_success AND

629: -- Launch the workflow notification if it is not validate only mode and no errors occured till now and
630: -- the owner is getting changed.
631: -- Bug 3297238. FP M Changes.
632: IF ( p_validate_only = FND_API.G_FALSE AND
633: x_return_status = FND_API.g_ret_sts_success AND
634: l_prev_owner_id <> p_owner_id )THEN -- owner id cannot be null as it is validated in public API.
635:
636: pa_control_items_workflow.START_NOTIFICATION_WF
637: ( p_item_type => 'PAWFCISC'

Line 649: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN

645:
646: END IF;
647:
648: -- Commit if the flag is set and there is no error
649: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN
650: COMMIT;
651: END IF;
652:
653:

Line 660: IF p_commit = FND_API.G_TRUE THEN

656:
657:
658: EXCEPTION
659: WHEN OTHERS THEN
660: IF p_commit = FND_API.G_TRUE THEN
661: ROLLBACK TO update_control_item;
662: END IF;
663:
664: -- Set the excetption Message and the stack

Line 669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

665: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.update_control_item'
666: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
667:
668:
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: RAISE;
671: end UPDATE_CONTROL_ITEM;
672:
673:

Line 677: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

673:
674:
675: procedure DELETE_CONTROL_ITEM (
676: p_api_version IN NUMBER := 1.0
677: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
678: ,p_commit IN VARCHAR2 := FND_API.g_false
679: ,p_validate_only IN VARCHAR2 := FND_API.g_true
680: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
681:

Line 678: ,p_commit IN VARCHAR2 := FND_API.g_false

674:
675: procedure DELETE_CONTROL_ITEM (
676: p_api_version IN NUMBER := 1.0
677: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
678: ,p_commit IN VARCHAR2 := FND_API.g_false
679: ,p_validate_only IN VARCHAR2 := FND_API.g_true
680: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
681:
682: ,p_ci_id IN NUMBER

Line 679: ,p_validate_only IN VARCHAR2 := FND_API.g_true

675: procedure DELETE_CONTROL_ITEM (
676: p_api_version IN NUMBER := 1.0
677: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
678: ,p_commit IN VARCHAR2 := FND_API.g_false
679: ,p_validate_only IN VARCHAR2 := FND_API.g_true
680: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
681:
682: ,p_ci_id IN NUMBER
683: ,p_record_version_number IN NUMBER

Line 680: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

676: p_api_version IN NUMBER := 1.0
677: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
678: ,p_commit IN VARCHAR2 := FND_API.g_false
679: ,p_validate_only IN VARCHAR2 := FND_API.g_true
680: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
681:
682: ,p_ci_id IN NUMBER
683: ,p_record_version_number IN NUMBER
684: ,x_return_status OUT NOCOPY VARCHAR2

Line 701: x_return_status := FND_API.G_RET_STS_SUCCESS;

697:
698: -- Initialize the Error Stack
699: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_Control_Item');
700:
701: x_return_status := FND_API.G_RET_STS_SUCCESS;
702: -- Issue API savepoint if the transaction is to be committed
703: IF p_commit = FND_API.G_TRUE THEN
704: SAVEPOINT delete_control_item;
705: END IF;

Line 703: IF p_commit = FND_API.G_TRUE THEN

699: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_Control_Item');
700:
701: x_return_status := FND_API.G_RET_STS_SUCCESS;
702: -- Issue API savepoint if the transaction is to be committed
703: IF p_commit = FND_API.G_TRUE THEN
704: SAVEPOINT delete_control_item;
705: END IF;
706:
707: IF p_ci_id is NULL THEN

Line 710: x_return_status := FND_API.G_RET_STS_ERROR;

706:
707: IF p_ci_id is NULL THEN
708: PA_UTILS.Add_Message( p_app_short_name => 'PA'
709: ,p_msg_name => 'PA_CI_INVALID_ITEM');
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: ELSE
712: open valid_ci;
713: fetch valid_ci into l_status_code;
714: if (valid_ci%notfound) then

Line 718: x_return_status := FND_API.G_RET_STS_ERROR;

714: if (valid_ci%notfound) then
715: --- invalid ci_id error
716: PA_UTILS.Add_Message( p_app_short_name => 'PA'
717: ,p_msg_name => 'PA_CI_INVALID_ITEM');
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: else
720: if (l_status_code <> 'CI_DRAFT') then
721: --- invalid status error
722: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 724: x_return_status := FND_API.G_RET_STS_ERROR;

720: if (l_status_code <> 'CI_DRAFT') then
721: --- invalid status error
722: PA_UTILS.Add_Message( p_app_short_name => 'PA'
723: ,p_msg_name => 'PA_CI_ONLY_DRAFT_DEL');
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: end if;
726: end if;
727: close valid_ci;
728: END IF;

Line 729: IF x_return_status = FND_API.g_ret_sts_success THEN

725: end if;
726: end if;
727: close valid_ci;
728: END IF;
729: IF x_return_status = FND_API.g_ret_sts_success THEN
730: --- delete all actions
731: pa_ci_actions_pvt.delete_all_actions(p_validate_only => 'F',
732: p_init_msg_list => 'F',
733: p_ci_id => p_ci_id,

Line 786: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN

782: ,x_msg_data
783: );
784: END IF;
785: -- Commit if the flag is set and there is no error
786: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN
787: COMMIT;
788: END IF;
789:
790: -- Reset the error stack when returning to the calling program

Line 796: IF p_commit = FND_API.G_TRUE THEN

792:
793:
794: EXCEPTION
795: WHEN OTHERS THEN
796: IF p_commit = FND_API.G_TRUE THEN
797: ROLLBACK TO delete_control_item;
798: END IF;
799:
800: -- Set the excetption Message and the stack

Line 805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

801: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.delete_control_item'
802: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
803:
804:
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
806: RAISE;
807: end DELETE_CONTROL_ITEM;
808:
809: procedure DELETE_ALL_CONTROL_ITEMS(

Line 811: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

807: end DELETE_CONTROL_ITEM;
808:
809: procedure DELETE_ALL_CONTROL_ITEMS(
810: p_api_version IN NUMBER := 1.0
811: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
812: ,p_commit IN VARCHAR2 := FND_API.g_false
813: ,p_validate_only IN VARCHAR2 := FND_API.g_true
814: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
815:

Line 812: ,p_commit IN VARCHAR2 := FND_API.g_false

808:
809: procedure DELETE_ALL_CONTROL_ITEMS(
810: p_api_version IN NUMBER := 1.0
811: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
812: ,p_commit IN VARCHAR2 := FND_API.g_false
813: ,p_validate_only IN VARCHAR2 := FND_API.g_true
814: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
815:
816: ,p_project_id IN NUMBER

Line 813: ,p_validate_only IN VARCHAR2 := FND_API.g_true

809: procedure DELETE_ALL_CONTROL_ITEMS(
810: p_api_version IN NUMBER := 1.0
811: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
812: ,p_commit IN VARCHAR2 := FND_API.g_false
813: ,p_validate_only IN VARCHAR2 := FND_API.g_true
814: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
815:
816: ,p_project_id IN NUMBER
817: ,x_return_status OUT NOCOPY VARCHAR2

Line 814: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

810: p_api_version IN NUMBER := 1.0
811: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
812: ,p_commit IN VARCHAR2 := FND_API.g_false
813: ,p_validate_only IN VARCHAR2 := FND_API.g_true
814: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
815:
816: ,p_project_id IN NUMBER
817: ,x_return_status OUT NOCOPY VARCHAR2
818: ,x_msg_count OUT NOCOPY NUMBER

Line 828: x_return_status := FND_API.G_RET_STS_SUCCESS;

824: BEGIN
825:
826: -- Initialize the Error Stack
827: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_ALL_Control_Items');
828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: -- Issue API savepoint if the transaction is to be committed
831: IF p_commit = FND_API.G_TRUE THEN
832: SAVEPOINT delete_all_control_items;

Line 831: IF p_commit = FND_API.G_TRUE THEN

827: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_ALL_Control_Items');
828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: -- Issue API savepoint if the transaction is to be committed
831: IF p_commit = FND_API.G_TRUE THEN
832: SAVEPOINT delete_all_control_items;
833: END IF;
834:
835: --Clear the global PL/SQL message table

Line 836: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

832: SAVEPOINT delete_all_control_items;
833: END IF;
834:
835: --Clear the global PL/SQL message table
836: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
837: FND_MSG_PUB.initialize;
838: END IF;
839:
840: FOR ci_rec IN( SELECT ci_id, record_version_number

Line 856: EXIT WHEN x_return_status <> FND_API.g_ret_sts_success;

852: ,x_return_status
853: ,x_msg_count
854: ,x_msg_data );
855:
856: EXIT WHEN x_return_status <> FND_API.g_ret_sts_success;
857: END LOOP;
858:
859: -- IF the number of messaages is 1 then fetch the message code from the stack
860: -- and return its text

Line 863: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

859: -- IF the number of messaages is 1 then fetch the message code from the stack
860: -- and return its text
861: x_msg_count := FND_MSG_PUB.Count_Msg;
862: IF x_msg_count = 1 THEN
863: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
864: ,p_msg_index => 1
865: ,p_data => x_msg_data
866: ,p_msg_index_out => l_msg_index_out
867: );

Line 870: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN

866: ,p_msg_index_out => l_msg_index_out
867: );
868: END IF;
869: -- Commit if the flag is set and there is no error
870: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN
871: COMMIT;
872: END IF;
873:
874: -- Reset the error stack when returning to the calling program

Line 879: x_return_status := FND_API.G_RET_STS_SUCCESS;

875: PA_DEBUG.Reset_Err_Stack;
876:
877: EXCEPTION
878: WHEN NO_DATA_FOUND THEN
879: x_return_status := FND_API.G_RET_STS_SUCCESS;
880:
881: WHEN OTHERS THEN
882: IF p_commit = FND_API.G_TRUE THEN
883: ROLLBACK TO delete_all_control_items;

Line 882: IF p_commit = FND_API.G_TRUE THEN

878: WHEN NO_DATA_FOUND THEN
879: x_return_status := FND_API.G_RET_STS_SUCCESS;
880:
881: WHEN OTHERS THEN
882: IF p_commit = FND_API.G_TRUE THEN
883: ROLLBACK TO delete_all_control_items;
884: END IF;
885:
886: -- Set the excetption Message and the stack

Line 891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

887: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.delete_all_control_items'
888: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
889:
890:
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
892: RAISE;
893: end DELETE_ALL_CONTROL_ITEMS;
894:
895: procedure COPY_CONTROL_ITEM (

Line 897: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

893: end DELETE_ALL_CONTROL_ITEMS;
894:
895: procedure COPY_CONTROL_ITEM (
896: p_api_version IN NUMBER := 1.0
897: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
898: ,p_commit IN VARCHAR2 := FND_API.g_false
899: ,p_validate_only IN VARCHAR2 := FND_API.g_true
900: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
901:

Line 898: ,p_commit IN VARCHAR2 := FND_API.g_false

894:
895: procedure COPY_CONTROL_ITEM (
896: p_api_version IN NUMBER := 1.0
897: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
898: ,p_commit IN VARCHAR2 := FND_API.g_false
899: ,p_validate_only IN VARCHAR2 := FND_API.g_true
900: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
901:
902: ,p_project_id IN NUMBER

Line 899: ,p_validate_only IN VARCHAR2 := FND_API.g_true

895: procedure COPY_CONTROL_ITEM (
896: p_api_version IN NUMBER := 1.0
897: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
898: ,p_commit IN VARCHAR2 := FND_API.g_false
899: ,p_validate_only IN VARCHAR2 := FND_API.g_true
900: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
901:
902: ,p_project_id IN NUMBER
903: ,p_ci_id_from IN NUMBER -- copy from this

Line 900: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

896: p_api_version IN NUMBER := 1.0
897: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
898: ,p_commit IN VARCHAR2 := FND_API.g_false
899: ,p_validate_only IN VARCHAR2 := FND_API.g_true
900: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
901:
902: ,p_project_id IN NUMBER
903: ,p_ci_id_from IN NUMBER -- copy from this
904: ,p_ci_type_id IN NUMBER -- copy to this

Line 983: x_return_status := FND_API.G_RET_STS_SUCCESS;

979: -- Initialize the Error Stack
980: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.COPY_CONTROL_ITEM');
981:
982: -- Initialize the return status to success
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: --Clear the global PL/SQL message table
986: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
987: FND_MSG_PUB.initialize;

Line 986: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

982: -- Initialize the return status to success
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: --Clear the global PL/SQL message table
986: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
987: FND_MSG_PUB.initialize;
988: END IF;
989:
990: OPEN c_from_item;

Line 996: x_return_status := FND_API.G_RET_STS_ERROR;

992: if c_from_item%NOTFOUND then
993: close c_from_item;
994: PA_UTILS.Add_Message( p_app_short_name => 'PA'
995: ,p_msg_name => 'PA_CI_NO_FROM_ITEM');
996: x_return_status := FND_API.G_RET_STS_ERROR;
997: end if;
998:
999: ---- check that impacts of source ci_id_from should be less than or equalto the
1000: ---- impacts of the destination ci_type_id. (i.e. new ci)

Line 1005: x_return_status := FND_API.G_RET_STS_ERROR;

1001: if (x_return_status = 'S' and p_include = 'Y') then
1002: if (pa_control_items_utils.IsImpactOkToInclude(p_ci_type_id, null, p_ci_id_from) <> 'Y') then
1003: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1004: ,p_msg_name => 'PA_CI_NO_IMP_INCLUDE');
1005: x_return_status := FND_API.G_RET_STS_ERROR;
1006: end if;
1007: end if;
1008:
1009: if p_validate_only=fnd_api.g_false AND

Line 1009: if p_validate_only=fnd_api.g_false AND

1005: x_return_status := FND_API.G_RET_STS_ERROR;
1006: end if;
1007: end if;
1008:
1009: if p_validate_only=fnd_api.g_false AND
1010: x_return_status = FND_API.G_RET_STS_SUCCESS then
1011:
1012: --- only copy clasification and reason if the source classification and reason
1013: --- code is in classificationa and reason category of the destination ci

Line 1010: x_return_status = FND_API.G_RET_STS_SUCCESS then

1006: end if;
1007: end if;
1008:
1009: if p_validate_only=fnd_api.g_false AND
1010: x_return_status = FND_API.G_RET_STS_SUCCESS then
1011:
1012: --- only copy clasification and reason if the source classification and reason
1013: --- code is in classificationa and reason category of the destination ci
1014: l_from_type_id := copy_from_row.ci_type_id;

Line 1045: ,p_commit => FND_API.g_false

1041:
1042: PA_CONTROL_ITEMS_PVT.ADD_CONTROL_ITEM(
1043: p_api_version => p_api_version
1044: ,p_init_msg_list => p_init_msg_list
1045: ,p_commit => FND_API.g_false
1046: ,p_validate_only => p_validate_only
1047: ,p_max_msg_count => p_max_msg_count
1048:
1049: ,p_ci_type_id => p_ci_type_id

Line 1116: if (x_return_status = FND_API.g_ret_sts_success and p_include = 'N') then

1112: x_ci_id := l_ci_id;
1113: close c_from_item;
1114:
1115: ------- copy impacts
1116: if (x_return_status = FND_API.g_ret_sts_success and p_include = 'N') then
1117: pa_ci_impacts_util.copy_impact(p_validate_only => 'F',
1118: p_init_msg_list => 'F',
1119: P_DEST_CI_ID => x_ci_id,
1120: P_SOURCE_CI_ID => p_ci_id_from,

Line 1127: if x_return_status = FND_API.g_ret_sts_success and p_include = 'Y' THEN

1123: x_msg_count => x_msg_count,
1124: x_msg_data => x_msg_data);
1125: end if;
1126:
1127: if x_return_status = FND_API.g_ret_sts_success and p_include = 'Y' THEN
1128: PA_CONTROL_ITEMS_PVT.INCLUDE_CONTROL_ITEM(
1129: p_api_version => p_api_version
1130: ,p_init_msg_list => p_init_msg_list
1131: ,p_commit => 'F'

Line 1174: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1170: -- IF the number of messages is 1 then fetch the message code from the stack
1171: -- and return its text
1172: x_msg_count := FND_MSG_PUB.Count_Msg;
1173: IF x_msg_count = 1 THEN
1174: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1175: ,p_msg_index => 1
1176: ,p_data => x_msg_data
1177: ,p_msg_index_out => l_msg_index_out
1178: );

Line 1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1193: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.COPY_CONTROL_ITEM'
1194: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1195:
1196:
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1198: RAISE;
1199: end COPY_CONTROL_ITEM;
1200:
1201: procedure INCLUDE_CONTROL_ITEM(

Line 1203: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

1199: end COPY_CONTROL_ITEM;
1200:
1201: procedure INCLUDE_CONTROL_ITEM(
1202: p_api_version IN NUMBER := 1.0
1203: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1204: ,p_commit IN VARCHAR2 := FND_API.g_false
1205: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1206: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1207:

Line 1204: ,p_commit IN VARCHAR2 := FND_API.g_false

1200:
1201: procedure INCLUDE_CONTROL_ITEM(
1202: p_api_version IN NUMBER := 1.0
1203: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1204: ,p_commit IN VARCHAR2 := FND_API.g_false
1205: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1206: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1207:
1208: ,p_from_ci_id IN NUMBER

Line 1205: ,p_validate_only IN VARCHAR2 := FND_API.g_true

1201: procedure INCLUDE_CONTROL_ITEM(
1202: p_api_version IN NUMBER := 1.0
1203: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1204: ,p_commit IN VARCHAR2 := FND_API.g_false
1205: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1206: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1207:
1208: ,p_from_ci_id IN NUMBER
1209: ,p_to_ci_id IN NUMBER

Line 1206: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

1202: p_api_version IN NUMBER := 1.0
1203: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1204: ,p_commit IN VARCHAR2 := FND_API.g_false
1205: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1206: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1207:
1208: ,p_from_ci_id IN NUMBER
1209: ,p_to_ci_id IN NUMBER
1210: ,p_record_version_number_to IN NUMBER

Line 1242: x_return_status := FND_API.G_RET_STS_SUCCESS;

1238:
1239: -- Initialize the Error Stack
1240: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Include_Control_Item');
1241:
1242: x_return_status := FND_API.G_RET_STS_SUCCESS;
1243: -- Issue API savepoint if the transaction is to be committed
1244: IF p_commit = FND_API.G_TRUE THEN
1245: SAVEPOINT include_control_item;
1246: END IF;

Line 1244: IF p_commit = FND_API.G_TRUE THEN

1240: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Include_Control_Item');
1241:
1242: x_return_status := FND_API.G_RET_STS_SUCCESS;
1243: -- Issue API savepoint if the transaction is to be committed
1244: IF p_commit = FND_API.G_TRUE THEN
1245: SAVEPOINT include_control_item;
1246: END IF;
1247:
1248: -------Included in

Line 1347: p_init_msg_list => FND_API.G_TRUE

1343: FROM PA_CONTROL_ITEMS
1344: WHERE ci_id = p_to_ci_id;
1345:
1346: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
1347: p_init_msg_list => FND_API.G_TRUE
1348: ,p_validate_only => FND_API.G_FALSE
1349: ,p_ci_id => p_to_ci_id
1350: ,p_status => 'CI_CLOSED'
1351: ,p_record_version_number => l_record_version_number

Line 1348: ,p_validate_only => FND_API.G_FALSE

1344: WHERE ci_id = p_to_ci_id;
1345:
1346: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
1347: p_init_msg_list => FND_API.G_TRUE
1348: ,p_validate_only => FND_API.G_FALSE
1349: ,p_ci_id => p_to_ci_id
1350: ,p_status => 'CI_CLOSED'
1351: ,p_record_version_number => l_record_version_number
1352: ,x_num_of_actions => l_open_actions_num

Line 1374: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN

1370: END IF;
1371:
1372:
1373: -- Commit if the flag is set and there is no error
1374: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN
1375: COMMIT;
1376: END IF;
1377:
1378: -- Reset the error stack when returning to the calling program

Line 1384: IF p_commit = FND_API.G_TRUE THEN

1380:
1381:
1382: EXCEPTION
1383: WHEN OTHERS THEN
1384: IF p_commit = FND_API.G_TRUE THEN
1385: ROLLBACK TO include_control_item;
1386: END IF;
1387:
1388: -- Set the excetption Message and the stack

Line 1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1389: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.include_control_item'
1390: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1391:
1392:
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1394: RAISE;
1395: end INCLUDE_CONTROL_ITEM;
1396:
1397: procedure UPDATE_NUMBER_OF_ACTIONS (

Line 1399: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

1395: end INCLUDE_CONTROL_ITEM;
1396:
1397: procedure UPDATE_NUMBER_OF_ACTIONS (
1398: p_api_version IN NUMBER := 1.0
1399: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1400: ,p_commit IN VARCHAR2 := FND_API.g_false
1401: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1402: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1403:

Line 1400: ,p_commit IN VARCHAR2 := FND_API.g_false

1396:
1397: procedure UPDATE_NUMBER_OF_ACTIONS (
1398: p_api_version IN NUMBER := 1.0
1399: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1400: ,p_commit IN VARCHAR2 := FND_API.g_false
1401: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1402: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1403:
1404: ,p_ci_id IN NUMBER

Line 1401: ,p_validate_only IN VARCHAR2 := FND_API.g_true

1397: procedure UPDATE_NUMBER_OF_ACTIONS (
1398: p_api_version IN NUMBER := 1.0
1399: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1400: ,p_commit IN VARCHAR2 := FND_API.g_false
1401: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1402: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1403:
1404: ,p_ci_id IN NUMBER
1405: ,p_num_of_actions IN NUMBER

Line 1402: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

1398: p_api_version IN NUMBER := 1.0
1399: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1400: ,p_commit IN VARCHAR2 := FND_API.g_false
1401: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1402: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1403:
1404: ,p_ci_id IN NUMBER
1405: ,p_num_of_actions IN NUMBER
1406: ,p_record_version_number IN NUMBER

Line 1430: x_return_status := FND_API.G_RET_STS_SUCCESS;

1426:
1427: -- Initialize the Error Stack
1428: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS');
1429:
1430: x_return_status := FND_API.G_RET_STS_SUCCESS;
1431: -- Issue API savepoint if the transaction is to be committed
1432: IF p_commit = FND_API.G_TRUE THEN
1433: SAVEPOINT UPDATE_NUMBER_OF_ACTIONS;
1434: END IF;

Line 1432: IF p_commit = FND_API.G_TRUE THEN

1428: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS');
1429:
1430: x_return_status := FND_API.G_RET_STS_SUCCESS;
1431: -- Issue API savepoint if the transaction is to be committed
1432: IF p_commit = FND_API.G_TRUE THEN
1433: SAVEPOINT UPDATE_NUMBER_OF_ACTIONS;
1434: END IF;
1435:
1436: x_return_status := 'S';

Line 1523: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN

1519: end if;
1520:
1521:
1522: -- Commit if the flag is set and there is no error
1523: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN
1524: COMMIT;
1525: END IF;
1526:
1527: -- Reset the error stack when returning to the calling program

Line 1533: IF p_commit = FND_API.G_TRUE THEN

1529:
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: IF p_commit = FND_API.G_TRUE THEN
1534: ROLLBACK TO UPDATE_NUMBER_OF_ACTIONS;
1535: END IF;
1536:
1537: -- Set the excetption Message and the stack

Line 1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1538: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS'
1539: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1540:
1541:
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1543: RAISE;
1544: end UPDATE_NUMBER_OF_ACTIONS;
1545:
1546: procedure UPDATE_CONTROL_ITEM_STATUS (

Line 1548: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

1544: end UPDATE_NUMBER_OF_ACTIONS;
1545:
1546: procedure UPDATE_CONTROL_ITEM_STATUS (
1547: p_api_version IN NUMBER := 1.0
1548: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1549: ,p_commit IN VARCHAR2 := FND_API.g_false
1550: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1551: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1552:

Line 1549: ,p_commit IN VARCHAR2 := FND_API.g_false

1545:
1546: procedure UPDATE_CONTROL_ITEM_STATUS (
1547: p_api_version IN NUMBER := 1.0
1548: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1549: ,p_commit IN VARCHAR2 := FND_API.g_false
1550: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1551: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1552:
1553: ,p_ci_id IN NUMBER

Line 1550: ,p_validate_only IN VARCHAR2 := FND_API.g_true

1546: procedure UPDATE_CONTROL_ITEM_STATUS (
1547: p_api_version IN NUMBER := 1.0
1548: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1549: ,p_commit IN VARCHAR2 := FND_API.g_false
1550: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1551: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1552:
1553: ,p_ci_id IN NUMBER
1554: ,p_status_code IN VARCHAR2

Line 1551: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

1547: p_api_version IN NUMBER := 1.0
1548: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
1549: ,p_commit IN VARCHAR2 := FND_API.g_false
1550: ,p_validate_only IN VARCHAR2 := FND_API.g_true
1551: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
1552:
1553: ,p_ci_id IN NUMBER
1554: ,p_status_code IN VARCHAR2
1555: ,p_record_version_number IN NUMBER

Line 1597: x_return_status := FND_API.G_RET_STS_SUCCESS;

1593:
1594: -- Initialize the Error Stack
1595: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM_STATUS');
1596:
1597: x_return_status := FND_API.G_RET_STS_SUCCESS;
1598: -- Issue API savepoint if the transaction is to be committed
1599: IF p_commit = FND_API.G_TRUE THEN
1600: SAVEPOINT UPDATE_CONTROL_ITEM_STATUS;
1601: END IF;

Line 1599: IF p_commit = FND_API.G_TRUE THEN

1595: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM_STATUS');
1596:
1597: x_return_status := FND_API.G_RET_STS_SUCCESS;
1598: -- Issue API savepoint if the transaction is to be committed
1599: IF p_commit = FND_API.G_TRUE THEN
1600: SAVEPOINT UPDATE_CONTROL_ITEM_STATUS;
1601: END IF;
1602:
1603: x_return_status := 'S';

Line 1671: IF x_return_status <> FND_API.g_ret_sts_success THEN

1667: ,x_return_status => x_return_status
1668: ,x_msg_count => x_msg_count
1669: ,x_msg_data => x_msg_data);
1670:
1671: IF x_return_status <> FND_API.g_ret_sts_success THEN
1672: PA_DEBUG.Reset_Err_Stack;
1673: raise API_ERROR;
1674: END IF;
1675: l_ci_number_char := TO_CHAR(l_ci_number_num);

Line 1779: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN

1775: );
1776:
1777:
1778: -- Commit if the flag is set and there is no error
1779: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.g_ret_sts_success )THEN
1780: COMMIT;
1781: END IF;
1782:
1783: -- Reset the error stack when returning to the calling program

Line 1791: IF p_commit = FND_API.G_TRUE THEN

1787: WHEN API_ERROR THEN
1788: x_return_status := x_return_status;
1789:
1790: WHEN OTHERS THEN
1791: IF p_commit = FND_API.G_TRUE THEN
1792: ROLLBACK TO UPDATE_CONTROL_ITEM_STATUS;
1793: END IF;
1794:
1795: -- Set the excetption Message and the stack

Line 1800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1796: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM_STATUS'
1797: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1798:
1799:
1800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1801: RAISE;
1802: end UPDATE_CONTROL_ITEM_STATUS;
1803:
1804: FUNCTION ASSIGN_CONTROL_ITEM_NUMBER(

Line 1908: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1904: end if;
1905:
1906: EXCEPTION
1907: WHEN OTHERS THEN
1908: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1909: RAISE;
1910: END ci_number_exists;
1911:
1912: -- Validates pa_lookups which has p_lookup_type and p_lookup_code

Line 1959: x_return_status := FND_API.G_RET_STS_SUCCESS;

1955: AND obj.object_id_from1 = p_ci_id
1956: AND obj.object_id_to1 = ci.ci_id;
1957: BEGIN
1958:
1959: x_return_status := FND_API.G_RET_STS_SUCCESS;
1960:
1961: FOR cur in items_c LOOP
1962: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
1963: p_init_msg_list => FND_API.G_TRUE

Line 1963: p_init_msg_list => FND_API.G_TRUE

1959: x_return_status := FND_API.G_RET_STS_SUCCESS;
1960:
1961: FOR cur in items_c LOOP
1962: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
1963: p_init_msg_list => FND_API.G_TRUE
1964: ,p_validate_only => FND_API.G_FALSE
1965: ,p_ci_id => cur.included_ci_id
1966: ,p_status => 'CI_APPROVED'
1967: ,p_record_version_number => cur.record_version_number

Line 1964: ,p_validate_only => FND_API.G_FALSE

1960:
1961: FOR cur in items_c LOOP
1962: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
1963: p_init_msg_list => FND_API.G_TRUE
1964: ,p_validate_only => FND_API.G_FALSE
1965: ,p_ci_id => cur.included_ci_id
1966: ,p_status => 'CI_APPROVED'
1967: ,p_record_version_number => cur.record_version_number
1968: ,x_num_of_actions => l_open_actions_num

Line 1973: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1969: ,x_return_status => x_return_status
1970: ,x_msg_count => x_msg_count
1971: ,x_msg_data => x_msg_data);
1972:
1973: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1974: PA_UTILS.Add_Message (p_app_short_name => 'PA'
1975: ,p_msg_name => x_msg_data);
1976: RAISE FND_API.G_EXC_ERROR;
1977: END IF;

Line 1976: RAISE FND_API.G_EXC_ERROR;

1972:
1973: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1974: PA_UTILS.Add_Message (p_app_short_name => 'PA'
1975: ,p_msg_name => x_msg_data);
1976: RAISE FND_API.G_EXC_ERROR;
1977: END IF;
1978: END LOOP;
1979:
1980: END change_included_cr_status;

Line 1985: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

1981:
1982:
1983: PROCEDURE add_related_item (
1984: p_api_version IN NUMBER := 1.0,
1985: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
1986: p_commit IN VARCHAR2 := FND_API.g_false,
1987: p_validate_only IN VARCHAR2 := FND_API.g_true,
1988: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
1989: p_ci_id IN NUMBER,

Line 1986: p_commit IN VARCHAR2 := FND_API.g_false,

1982:
1983: PROCEDURE add_related_item (
1984: p_api_version IN NUMBER := 1.0,
1985: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
1986: p_commit IN VARCHAR2 := FND_API.g_false,
1987: p_validate_only IN VARCHAR2 := FND_API.g_true,
1988: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
1989: p_ci_id IN NUMBER,
1990: p_related_ci_id IN NUMBER,

Line 1987: p_validate_only IN VARCHAR2 := FND_API.g_true,

1983: PROCEDURE add_related_item (
1984: p_api_version IN NUMBER := 1.0,
1985: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
1986: p_commit IN VARCHAR2 := FND_API.g_false,
1987: p_validate_only IN VARCHAR2 := FND_API.g_true,
1988: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
1989: p_ci_id IN NUMBER,
1990: p_related_ci_id IN NUMBER,
1991: x_return_status OUT NOCOPY VARCHAR2,

Line 1988: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

1984: p_api_version IN NUMBER := 1.0,
1985: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
1986: p_commit IN VARCHAR2 := FND_API.g_false,
1987: p_validate_only IN VARCHAR2 := FND_API.g_true,
1988: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
1989: p_ci_id IN NUMBER,
1990: p_related_ci_id IN NUMBER,
1991: x_return_status OUT NOCOPY VARCHAR2,
1992: x_msg_count OUT NOCOPY NUMBER,

Line 2000: IF p_commit = FND_API.G_TRUE THEN

1996: l_object_relationship_id NUMBER;
1997: BEGIN
1998: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.ADD_RELATED_ITEM');
1999:
2000: IF p_commit = FND_API.G_TRUE THEN
2001: SAVEPOINT add_related_item;
2002: END IF;
2003:
2004: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 2004: IF p_init_msg_list = FND_API.G_TRUE THEN

2000: IF p_commit = FND_API.G_TRUE THEN
2001: SAVEPOINT add_related_item;
2002: END IF;
2003:
2004: IF p_init_msg_list = FND_API.G_TRUE THEN
2005: fnd_msg_pub.initialize;
2006: END IF;
2007:
2008: x_return_status := 'S';

Line 2012: IF p_validate_only = FND_API.G_TRUE THEN

2008: x_return_status := 'S';
2009: x_msg_count := 0;
2010: x_msg_data := '';
2011:
2012: IF p_validate_only = FND_API.G_TRUE THEN
2013: RETURN;
2014: END IF;
2015:
2016: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

Line 2039: IF p_commit = fnd_api.g_true THEN

2035: p_pm_product_code => NULL,
2036: x_object_relationship_id => l_object_relationship_id,
2037: x_return_status => x_return_status);
2038:
2039: IF p_commit = fnd_api.g_true THEN
2040: IF x_return_status = 'S' THEN
2041: COMMIT;
2042: ELSE
2043: ROLLBACK TO add_related_item;

Line 2054: IF p_commit = fnd_api.g_true THEN

2050: pa_debug.reset_err_stack;
2051:
2052: EXCEPTION
2053: WHEN OTHERS THEN
2054: IF p_commit = fnd_api.g_true THEN
2055: ROLLBACK TO add_related_item;
2056: END IF;
2057:
2058: x_return_status := 'U';

Line 2070: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

2066:
2067:
2068: PROCEDURE delete_related_item (
2069: p_api_version IN NUMBER := 1.0,
2070: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2071: p_commit IN VARCHAR2 := FND_API.g_false,
2072: p_validate_only IN VARCHAR2 := FND_API.g_true,
2073: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2074: p_ci_id IN NUMBER,

Line 2071: p_commit IN VARCHAR2 := FND_API.g_false,

2067:
2068: PROCEDURE delete_related_item (
2069: p_api_version IN NUMBER := 1.0,
2070: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2071: p_commit IN VARCHAR2 := FND_API.g_false,
2072: p_validate_only IN VARCHAR2 := FND_API.g_true,
2073: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2074: p_ci_id IN NUMBER,
2075: p_related_ci_id IN NUMBER,

Line 2072: p_validate_only IN VARCHAR2 := FND_API.g_true,

2068: PROCEDURE delete_related_item (
2069: p_api_version IN NUMBER := 1.0,
2070: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2071: p_commit IN VARCHAR2 := FND_API.g_false,
2072: p_validate_only IN VARCHAR2 := FND_API.g_true,
2073: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2074: p_ci_id IN NUMBER,
2075: p_related_ci_id IN NUMBER,
2076: x_return_status OUT NOCOPY VARCHAR2,

Line 2073: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

2069: p_api_version IN NUMBER := 1.0,
2070: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2071: p_commit IN VARCHAR2 := FND_API.g_false,
2072: p_validate_only IN VARCHAR2 := FND_API.g_true,
2073: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2074: p_ci_id IN NUMBER,
2075: p_related_ci_id IN NUMBER,
2076: x_return_status OUT NOCOPY VARCHAR2,
2077: x_msg_count OUT NOCOPY NUMBER,

Line 2086: IF p_commit = FND_API.G_TRUE THEN

2082: l_record_version_number NUMBER;
2083: BEGIN
2084: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_RELATED_ITEM');
2085:
2086: IF p_commit = FND_API.G_TRUE THEN
2087: SAVEPOINT delete_related_item;
2088: END IF;
2089:
2090: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 2090: IF p_init_msg_list = FND_API.G_TRUE THEN

2086: IF p_commit = FND_API.G_TRUE THEN
2087: SAVEPOINT delete_related_item;
2088: END IF;
2089:
2090: IF p_init_msg_list = FND_API.G_TRUE THEN
2091: fnd_msg_pub.initialize;
2092: END IF;
2093:
2094: x_return_status := 'S';

Line 2109: IF p_validate_only = FND_API.G_TRUE THEN

2105: AND object_id_from1 = p_ci_id)
2106: OR ( object_id_to1 = p_ci_id
2107: AND object_id_from1 = p_related_ci_id));
2108:
2109: IF p_validate_only = FND_API.G_TRUE THEN
2110: RETURN;
2111: END IF;
2112:
2113: pa_object_relationships_pkg.delete_row(

Line 2131: IF p_commit = fnd_api.g_true THEN

2127: p_pm_product_code => NULL,
2128: p_record_version_number => l_record_version_number,
2129: x_return_status => x_return_status);
2130:
2131: IF p_commit = fnd_api.g_true THEN
2132: IF x_return_status = 'S' THEN
2133: COMMIT;
2134: ELSE
2135: ROLLBACK TO delete_related_item;

Line 2146: IF p_commit = fnd_api.g_true THEN

2142: pa_debug.reset_err_stack;
2143:
2144: EXCEPTION
2145: WHEN OTHERS THEN
2146: IF p_commit = fnd_api.g_true THEN
2147: ROLLBACK TO delete_related_item;
2148: END IF;
2149:
2150: x_return_status := 'U';

Line 2161: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

2157: END delete_related_item;
2158:
2159: PROCEDURE delete_all_related_items (
2160: p_api_version IN NUMBER := 1.0,
2161: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2162: p_commit IN VARCHAR2 := FND_API.g_false,
2163: p_validate_only IN VARCHAR2 := FND_API.g_true,
2164: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2165: p_ci_id IN NUMBER,

Line 2162: p_commit IN VARCHAR2 := FND_API.g_false,

2158:
2159: PROCEDURE delete_all_related_items (
2160: p_api_version IN NUMBER := 1.0,
2161: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2162: p_commit IN VARCHAR2 := FND_API.g_false,
2163: p_validate_only IN VARCHAR2 := FND_API.g_true,
2164: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2165: p_ci_id IN NUMBER,
2166: x_return_status OUT NOCOPY VARCHAR2,

Line 2163: p_validate_only IN VARCHAR2 := FND_API.g_true,

2159: PROCEDURE delete_all_related_items (
2160: p_api_version IN NUMBER := 1.0,
2161: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2162: p_commit IN VARCHAR2 := FND_API.g_false,
2163: p_validate_only IN VARCHAR2 := FND_API.g_true,
2164: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2165: p_ci_id IN NUMBER,
2166: x_return_status OUT NOCOPY VARCHAR2,
2167: x_msg_count OUT NOCOPY NUMBER,

Line 2164: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

2160: p_api_version IN NUMBER := 1.0,
2161: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2162: p_commit IN VARCHAR2 := FND_API.g_false,
2163: p_validate_only IN VARCHAR2 := FND_API.g_true,
2164: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2165: p_ci_id IN NUMBER,
2166: x_return_status OUT NOCOPY VARCHAR2,
2167: x_msg_count OUT NOCOPY NUMBER,
2168: x_msg_data OUT NOCOPY VARCHAR2

Line 2191: IF p_commit = FND_API.G_TRUE THEN

2187:
2188: BEGIN
2189: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_ALL_RELATED_ITEMS');
2190:
2191: IF p_commit = FND_API.G_TRUE THEN
2192: SAVEPOINT delete_all_related_items;
2193: END IF;
2194:
2195: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 2195: IF p_init_msg_list = FND_API.G_TRUE THEN

2191: IF p_commit = FND_API.G_TRUE THEN
2192: SAVEPOINT delete_all_related_items;
2193: END IF;
2194:
2195: IF p_init_msg_list = FND_API.G_TRUE THEN
2196: fnd_msg_pub.initialize;
2197: END IF;
2198:
2199: x_return_status := 'S';

Line 2203: IF p_validate_only = FND_API.G_TRUE THEN

2199: x_return_status := 'S';
2200: x_msg_count := 0;
2201: x_msg_data := '';
2202:
2203: IF p_validate_only = FND_API.G_TRUE THEN
2204: RETURN;
2205: END IF;
2206:
2207: FOR cur in items_c LOOP

Line 2209: p_init_msg_list => FND_API.G_FALSE,

2205: END IF;
2206:
2207: FOR cur in items_c LOOP
2208: delete_related_item(
2209: p_init_msg_list => FND_API.G_FALSE,
2210: p_commit => FND_API.G_FALSE,
2211: p_validate_only => FND_API.G_FALSE,
2212: p_max_msg_count => p_max_msg_count,
2213: p_ci_id => p_ci_id,

Line 2210: p_commit => FND_API.G_FALSE,

2206:
2207: FOR cur in items_c LOOP
2208: delete_related_item(
2209: p_init_msg_list => FND_API.G_FALSE,
2210: p_commit => FND_API.G_FALSE,
2211: p_validate_only => FND_API.G_FALSE,
2212: p_max_msg_count => p_max_msg_count,
2213: p_ci_id => p_ci_id,
2214: p_related_ci_id => cur.related_ci_id,

Line 2211: p_validate_only => FND_API.G_FALSE,

2207: FOR cur in items_c LOOP
2208: delete_related_item(
2209: p_init_msg_list => FND_API.G_FALSE,
2210: p_commit => FND_API.G_FALSE,
2211: p_validate_only => FND_API.G_FALSE,
2212: p_max_msg_count => p_max_msg_count,
2213: p_ci_id => p_ci_id,
2214: p_related_ci_id => cur.related_ci_id,
2215: x_return_status => x_return_status,

Line 2220: IF p_commit = fnd_api.g_true THEN

2216: x_msg_count => x_msg_count,
2217: x_msg_data => x_msg_data);
2218: END LOOP;
2219:
2220: IF p_commit = fnd_api.g_true THEN
2221: IF x_return_status = 'S' THEN
2222: COMMIT;
2223: ELSE
2224: ROLLBACK TO delete_all_related_items;

Line 2235: IF p_commit = fnd_api.g_true THEN

2231: pa_debug.reset_err_stack;
2232:
2233: EXCEPTION
2234: WHEN OTHERS THEN
2235: IF p_commit = fnd_api.g_true THEN
2236: ROLLBACK TO delete_all_related_items;
2237: END IF;
2238:
2239: x_return_status := 'U';

Line 2251: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

2247:
2248:
2249: PROCEDURE delete_all_included_crs (
2250: p_api_version IN NUMBER := 1.0,
2251: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2252: p_commit IN VARCHAR2 := FND_API.g_false,
2253: p_validate_only IN VARCHAR2 := FND_API.g_true,
2254: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2255: p_ci_id IN NUMBER,

Line 2252: p_commit IN VARCHAR2 := FND_API.g_false,

2248:
2249: PROCEDURE delete_all_included_crs (
2250: p_api_version IN NUMBER := 1.0,
2251: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2252: p_commit IN VARCHAR2 := FND_API.g_false,
2253: p_validate_only IN VARCHAR2 := FND_API.g_true,
2254: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2255: p_ci_id IN NUMBER,
2256: x_return_status OUT NOCOPY VARCHAR2,

Line 2253: p_validate_only IN VARCHAR2 := FND_API.g_true,

2249: PROCEDURE delete_all_included_crs (
2250: p_api_version IN NUMBER := 1.0,
2251: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2252: p_commit IN VARCHAR2 := FND_API.g_false,
2253: p_validate_only IN VARCHAR2 := FND_API.g_true,
2254: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2255: p_ci_id IN NUMBER,
2256: x_return_status OUT NOCOPY VARCHAR2,
2257: x_msg_count OUT NOCOPY NUMBER,

Line 2254: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

2250: p_api_version IN NUMBER := 1.0,
2251: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2252: p_commit IN VARCHAR2 := FND_API.g_false,
2253: p_validate_only IN VARCHAR2 := FND_API.g_true,
2254: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2255: p_ci_id IN NUMBER,
2256: x_return_status OUT NOCOPY VARCHAR2,
2257: x_msg_count OUT NOCOPY NUMBER,
2258: x_msg_data OUT NOCOPY VARCHAR2

Line 2272: IF p_commit = FND_API.G_TRUE THEN

2268:
2269: BEGIN
2270: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_ALL_INCLUDED_CRS');
2271:
2272: IF p_commit = FND_API.G_TRUE THEN
2273: SAVEPOINT delete_all_included_crs;
2274: END IF;
2275:
2276: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 2276: IF p_init_msg_list = FND_API.G_TRUE THEN

2272: IF p_commit = FND_API.G_TRUE THEN
2273: SAVEPOINT delete_all_included_crs;
2274: END IF;
2275:
2276: IF p_init_msg_list = FND_API.G_TRUE THEN
2277: fnd_msg_pub.initialize;
2278: END IF;
2279:
2280: x_return_status := 'S';

Line 2284: IF p_validate_only = FND_API.G_TRUE THEN

2280: x_return_status := 'S';
2281: x_msg_count := 0;
2282: x_msg_data := '';
2283:
2284: IF p_validate_only = FND_API.G_TRUE THEN
2285: RETURN;
2286: END IF;
2287:
2288: FOR cur in items_c LOOP

Line 2310: IF p_commit = fnd_api.g_true THEN

2306: x_return_status => x_return_status);
2307:
2308: END LOOP;
2309:
2310: IF p_commit = fnd_api.g_true THEN
2311: IF x_return_status = 'S' THEN
2312: COMMIT;
2313: ELSE
2314: ROLLBACK TO delete_all_included_crs;

Line 2325: IF p_commit = fnd_api.g_true THEN

2321: pa_debug.reset_err_stack;
2322:
2323: EXCEPTION
2324: WHEN OTHERS THEN
2325: IF p_commit = fnd_api.g_true THEN
2326: ROLLBACK TO delete_all_included_crs;
2327: END IF;
2328:
2329: x_return_status := 'U';

Line 2340: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

2336: END delete_all_included_crs;
2337:
2338: PROCEDURE copy_related_items (
2339: p_api_version IN NUMBER := 1.0,
2340: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2341: p_commit IN VARCHAR2 := FND_API.g_false,
2342: p_validate_only IN VARCHAR2 := FND_API.g_true,
2343: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2344: p_from_ci_id IN NUMBER,

Line 2341: p_commit IN VARCHAR2 := FND_API.g_false,

2337:
2338: PROCEDURE copy_related_items (
2339: p_api_version IN NUMBER := 1.0,
2340: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2341: p_commit IN VARCHAR2 := FND_API.g_false,
2342: p_validate_only IN VARCHAR2 := FND_API.g_true,
2343: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2344: p_from_ci_id IN NUMBER,
2345: p_to_ci_id IN NUMBER,

Line 2342: p_validate_only IN VARCHAR2 := FND_API.g_true,

2338: PROCEDURE copy_related_items (
2339: p_api_version IN NUMBER := 1.0,
2340: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2341: p_commit IN VARCHAR2 := FND_API.g_false,
2342: p_validate_only IN VARCHAR2 := FND_API.g_true,
2343: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2344: p_from_ci_id IN NUMBER,
2345: p_to_ci_id IN NUMBER,
2346: x_return_status OUT NOCOPY VARCHAR2,

Line 2343: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

2339: p_api_version IN NUMBER := 1.0,
2340: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
2341: p_commit IN VARCHAR2 := FND_API.g_false,
2342: p_validate_only IN VARCHAR2 := FND_API.g_true,
2343: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
2344: p_from_ci_id IN NUMBER,
2345: p_to_ci_id IN NUMBER,
2346: x_return_status OUT NOCOPY VARCHAR2,
2347: x_msg_count OUT NOCOPY NUMBER,

Line 2370: IF p_commit = FND_API.G_TRUE THEN

2366:
2367: BEGIN
2368: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.COPY_RELATED_ITEMS');
2369:
2370: IF p_commit = FND_API.G_TRUE THEN
2371: SAVEPOINT copy_related_items;
2372: END IF;
2373:
2374: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 2374: IF p_init_msg_list = FND_API.G_TRUE THEN

2370: IF p_commit = FND_API.G_TRUE THEN
2371: SAVEPOINT copy_related_items;
2372: END IF;
2373:
2374: IF p_init_msg_list = FND_API.G_TRUE THEN
2375: fnd_msg_pub.initialize;
2376: END IF;
2377:
2378: x_return_status := 'S';

Line 2382: IF p_validate_only = FND_API.G_TRUE THEN

2378: x_return_status := 'S';
2379: x_msg_count := 0;
2380: x_msg_data := '';
2381:
2382: IF p_validate_only = FND_API.G_TRUE THEN
2383: RETURN;
2384: END IF;
2385:
2386: FOR cur in items_c LOOP

Line 2388: p_init_msg_list => FND_API.G_FALSE,

2384: END IF;
2385:
2386: FOR cur in items_c LOOP
2387: add_related_item(
2388: p_init_msg_list => FND_API.G_FALSE,
2389: p_commit => FND_API.G_FALSE,
2390: p_validate_only => FND_API.G_FALSE,
2391: p_max_msg_count => p_max_msg_count,
2392: p_ci_id => p_to_ci_id,

Line 2389: p_commit => FND_API.G_FALSE,

2385:
2386: FOR cur in items_c LOOP
2387: add_related_item(
2388: p_init_msg_list => FND_API.G_FALSE,
2389: p_commit => FND_API.G_FALSE,
2390: p_validate_only => FND_API.G_FALSE,
2391: p_max_msg_count => p_max_msg_count,
2392: p_ci_id => p_to_ci_id,
2393: p_related_ci_id => cur.related_ci_id,

Line 2390: p_validate_only => FND_API.G_FALSE,

2386: FOR cur in items_c LOOP
2387: add_related_item(
2388: p_init_msg_list => FND_API.G_FALSE,
2389: p_commit => FND_API.G_FALSE,
2390: p_validate_only => FND_API.G_FALSE,
2391: p_max_msg_count => p_max_msg_count,
2392: p_ci_id => p_to_ci_id,
2393: p_related_ci_id => cur.related_ci_id,
2394: x_return_status => x_return_status,

Line 2399: IF p_commit = fnd_api.g_true THEN

2395: x_msg_count => x_msg_count,
2396: x_msg_data => x_msg_data);
2397: END LOOP;
2398:
2399: IF p_commit = fnd_api.g_true THEN
2400: IF x_return_status = 'S' THEN
2401: COMMIT;
2402: ELSE
2403: ROLLBACK TO copy_related_items;

Line 2414: IF p_commit = fnd_api.g_true THEN

2410: pa_debug.reset_err_stack;
2411:
2412: EXCEPTION
2413: WHEN OTHERS THEN
2414: IF p_commit = fnd_api.g_true THEN
2415: ROLLBACK TO copy_related_items;
2416: END IF;
2417:
2418: x_return_status := 'U';