DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE dependencies on PA_PROJECT_CORE

Line 1: package body PA_PROJECT_CORE as

1: package body PA_PROJECT_CORE as
2: -- $Header: PAXPCORB.pls 120.6.12010000.3 2008/09/30 09:40:24 sugupta ship $
3:
4:
5: --

Line 162: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

158: if((x_err_code <> 0) OR (l_delete_ok <> FND_API.G_TRUE)) then
159: x_err_code := 10;
160: x_err_stack := x_err_stack || '->check PA_EGO_WRAPPER_PUB.check_delete_project_ok '|| x_project_id;
161: if l_template_flag = 'Y' then
162: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
163: else
164: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
165: end if;
166: rollback to delete_project;

Line 164: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

160: x_err_stack := x_err_stack || '->check PA_EGO_WRAPPER_PUB.check_delete_project_ok '|| x_project_id;
161: if l_template_flag = 'Y' then
162: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
163: else
164: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
165: end if;
166: rollback to delete_project;
167: return;
168: end if;

Line 187: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

183: if((x_err_code <> 0) OR (l_delete_ok <> FND_API.G_TRUE)) then
184: x_err_code := 20;
185: x_err_stack := x_err_stack || '->check PA_EGO_WRAPPER_PUB.check_delete_project_ok_eng '|| x_project_id;
186: if l_template_flag = 'Y' then
187: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
188: else
189: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
190: end if;
191: rollback to delete_project;

Line 189: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

185: x_err_stack := x_err_stack || '->check PA_EGO_WRAPPER_PUB.check_delete_project_ok_eng '|| x_project_id;
186: if l_template_flag = 'Y' then
187: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
188: else
189: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
190: end if;
191: rollback to delete_project;
192: return;
193: end if;

Line 236: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

232:
233: IF (x_return_status <> 'S') THEN
234: x_err_code := 30;
235: x_err_stack := x_err_stack || '->Delete_PJR_Txns: '|| x_project_id;
236: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
237: ROLLBACK TO delete_project;
238: RETURN;
239: END IF;
240:

Line 268: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

264:
265: IF (x_return_status <> 'S') THEN
266: x_err_code := 30;
267: x_err_stack := x_err_stack || '->Delete_Subteam: '|| x_project_id;
268: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
269: ROLLBACK TO delete_project;
270: RETURN;
271: END IF;
272: END LOOP;

Line 314: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

310: IF (x_return_status <> 'S') Then
311: x_err_code := 30;
312: x_err_stack := x_err_stack || '->delete_project_party: '|| x_project_id;
313: if l_template_flag = 'Y' then
314: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
315: else
316: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
317: end if;
318: rollback to delete_project;

Line 316: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

312: x_err_stack := x_err_stack || '->delete_project_party: '|| x_project_id;
313: if l_template_flag = 'Y' then
314: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
315: else
316: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
317: end if;
318: rollback to delete_project;
319: return;
320: END IF;

Line 570: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

566: IF (x_return_status <> 'S') Then
567: x_err_code := 35;
568: x_err_stack := x_err_stack || '->delete_object_exception: '|| x_project_id;
569: if l_template_flag = 'Y' then
570: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
571: else
572: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
573: end if;
574: rollback to delete_project;

Line 572: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

568: x_err_stack := x_err_stack || '->delete_object_exception: '|| x_project_id;
569: if l_template_flag = 'Y' then
570: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
571: else
572: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
573: end if;
574: rollback to delete_project;
575: return;
576: END IF;

Line 598: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

594: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
595: x_err_code := 40;
596: x_err_stack := x_err_stack || '->delete_project_attributes: '|| x_project_id;
597: if l_template_flag = 'Y' then
598: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
599: else
600: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
601: end if;
602: rollback to delete_project;

Line 600: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

596: x_err_stack := x_err_stack || '->delete_project_attributes: '|| x_project_id;
597: if l_template_flag = 'Y' then
598: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
599: else
600: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
601: end if;
602: rollback to delete_project;
603: return;
604: END IF;

Line 619: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

615: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
616: x_err_code := 50;
617: x_err_stack := x_err_stack || '->delete_retention_rules: '|| x_project_id;
618: if l_template_flag = 'Y' then
619: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
620: else
621: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
622: end if;
623: rollback to delete_project;

Line 621: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

617: x_err_stack := x_err_stack || '->delete_retention_rules: '|| x_project_id;
618: if l_template_flag = 'Y' then
619: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
620: else
621: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
622: end if;
623: rollback to delete_project;
624: return;
625: END IF;

Line 649: pa_project_core.delete_task(

645: and t.task_id = t.top_task_id) loop
646:
647: x_err_stack := NULL;
648:
649: pa_project_core.delete_task(
650: x_task_id => task_rec.task_id,
651: x_validation_mode => x_validation_mode, --bug 2947492
652: x_err_code => x_err_code,
653: x_err_stage => x_err_stage,

Line 679: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

675: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
676: x_err_code := 60;
677: x_err_stack := x_err_stack || '->delete_project_structure: '|| x_project_id;
678: if l_template_flag = 'Y' then
679: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
680: else
681: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
682: end if;
683: rollback to delete_project;

Line 681: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

677: x_err_stack := x_err_stack || '->delete_project_structure: '|| x_project_id;
678: if l_template_flag = 'Y' then
679: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
680: else
681: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
682: end if;
683: rollback to delete_project;
684: return;
685: END IF;

Line 700: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

696: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
697: x_err_code := 70;
698: x_err_stack := x_err_stack || '->delete_all_control_items: '|| x_project_id;
699: if l_template_flag = 'Y' then
700: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
701: else
702: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
703: end if;
704: rollback to delete_project;

Line 702: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

698: x_err_stack := x_err_stack || '->delete_all_control_items: '|| x_project_id;
699: if l_template_flag = 'Y' then
700: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
701: else
702: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
703: end if;
704: rollback to delete_project;
705: return;
706: END IF;

Line 730: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

726: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
727: x_err_code := 80;
728: x_err_stack := x_err_stack || '->delete_relationship: '|| x_project_id;
729: if l_template_flag = 'Y' then
730: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
731: else
732: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
733: end if;
734: rollback to delete_project;

Line 732: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

728: x_err_stack := x_err_stack || '->delete_relationship: '|| x_project_id;
729: if l_template_flag = 'Y' then
730: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
731: else
732: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
733: end if;
734: rollback to delete_project;
735: return;
736: END IF;

Line 756: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

752: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
753: x_err_code := 90;
754: x_err_stack := x_err_stack || '->delete_all_item_assocs: '|| x_project_id;
755: if l_template_flag = 'Y' then
756: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
757: else
758: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
759: end if;
760: rollback to delete_project;

Line 758: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

754: x_err_stack := x_err_stack || '->delete_all_item_assocs: '|| x_project_id;
755: if l_template_flag = 'Y' then
756: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
757: else
758: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
759: end if;
760: rollback to delete_project;
761: return;
762: END IF;

Line 777: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

773: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
774: x_err_code := 100;
775: x_err_stack := x_err_stack || '->pa_project_ctx_search_pvt.delete_row: '|| x_project_id;
776: if l_template_flag = 'Y' then
777: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
778: else
779: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
780: end if;
781: rollback to delete_project;

Line 779: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

775: x_err_stack := x_err_stack || '->pa_project_ctx_search_pvt.delete_row: '|| x_project_id;
776: if l_template_flag = 'Y' then
777: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
778: else
779: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
780: end if;
781: rollback to delete_project;
782: return;
783: END IF;

Line 801: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

797: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
798: x_err_code := 105;
799: x_err_stack := x_err_stack || '->delete_all_user_attrs_data: '|| x_project_id;
800: if l_template_flag = 'Y' then
801: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
802: else
803: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
804: end if;
805: rollback to delete_project;

Line 803: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

799: x_err_stack := x_err_stack || '->delete_all_user_attrs_data: '|| x_project_id;
800: if l_template_flag = 'Y' then
801: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
802: else
803: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
804: end if;
805: rollback to delete_project;
806: return;
807: END IF;

Line 820: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

816: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
817: x_err_code := 110;
818: x_err_stack := x_err_stack || '->delete_proj_from_proj_set: '|| x_project_id;
819: if l_template_flag = 'Y' then
820: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
821: else
822: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
823: end if;
824: rollback to delete_project;

Line 822: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

818: x_err_stack := x_err_stack || '->delete_proj_from_proj_set: '|| x_project_id;
819: if l_template_flag = 'Y' then
820: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
821: else
822: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
823: end if;
824: rollback to delete_project;
825: return;
826: END IF;

Line 841: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

837: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
838: x_err_code := 115;
839: x_err_stack := x_err_stack || '->Delete_Proj_To_Task_Assoc: '|| x_project_id;
840: if l_template_flag = 'Y' then
841: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
842: else
843: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
844: end if;
845: rollback to delete_project;

Line 843: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

839: x_err_stack := x_err_stack || '->Delete_Proj_To_Task_Assoc: '|| x_project_id;
840: if l_template_flag = 'Y' then
841: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
842: else
843: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
844: end if;
845: rollback to delete_project;
846: return;
847: END IF;

Line 879: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

875: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
876: x_err_code := 120;
877: x_err_stack := x_err_stack || '->Delete_Proj_Specific_RBS: '|| x_project_id;
878: IF l_template_flag = 'Y' THEN
879: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
880: ELSE
881: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
882: END IF;
883: ROLLBACK TO delete_project;

Line 881: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

877: x_err_stack := x_err_stack || '->Delete_Proj_Specific_RBS: '|| x_project_id;
878: IF l_template_flag = 'Y' THEN
879: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
880: ELSE
881: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
882: END IF;
883: ROLLBACK TO delete_project;
884: RETURN;
885: END IF;

Line 897: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

893: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
894: x_err_code := 125;
895: x_err_stack := x_err_stack || '->Delete_Proj_Specific_Resource: '|| x_project_id;
896: IF l_template_flag = 'Y' THEN
897: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
898: ELSE
899: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
900: END IF;
901: ROLLBACK TO delete_project;

Line 899: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

895: x_err_stack := x_err_stack || '->Delete_Proj_Specific_Resource: '|| x_project_id;
896: IF l_template_flag = 'Y' THEN
897: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
898: ELSE
899: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
900: END IF;
901: ROLLBACK TO delete_project;
902: RETURN;
903: END IF;

Line 981: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

977: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
978: x_err_code := 130;
979: x_err_stack := x_err_stack || '->Delete_Version: '|| x_project_id;
980: IF l_template_flag = 'Y' THEN
981: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
982: ELSE
983: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
984: END IF;
985: ROLLBACK TO delete_project;

Line 983: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

979: x_err_stack := x_err_stack || '->Delete_Version: '|| x_project_id;
980: IF l_template_flag = 'Y' THEN
981: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
982: ELSE
983: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
984: END IF;
985: ROLLBACK TO delete_project;
986: RETURN;
987: END IF;

Line 999: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_TEMPLATE');

995: if x_err_code <> 0 Then
996: x_err_code := 140;
997: x_err_stack := x_err_stack ||'->Delete_Fp_Options: '|| x_project_id;
998: IF l_template_flag = 'Y' THEN
999: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_TEMPLATE');
1000: ELSE
1001: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_PROJECT');
1002: END IF;
1003: ROLLBACK TO delete_project;

Line 1001: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_PROJECT');

997: x_err_stack := x_err_stack ||'->Delete_Fp_Options: '|| x_project_id;
998: IF l_template_flag = 'Y' THEN
999: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_TEMPLATE');
1000: ELSE
1001: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_PROJECT');
1002: END IF;
1003: ROLLBACK TO delete_project;
1004: RETURN;
1005: end if;

Line 1019: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_TEMPLATE');

1015: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1016: x_err_code := 150;
1017: x_err_stack := x_err_stack || '->Delete_Obj_Status_Changes: '|| x_project_id;
1018: IF l_template_flag = 'Y' THEN
1019: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_TEMPLATE');
1020: ELSE
1021: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_PROJECT');
1022: END IF;
1023: ROLLBACK TO delete_project;

Line 1021: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_PROJECT');

1017: x_err_stack := x_err_stack || '->Delete_Obj_Status_Changes: '|| x_project_id;
1018: IF l_template_flag = 'Y' THEN
1019: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_TEMPLATE');
1020: ELSE
1021: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_PROJECT');
1022: END IF;
1023: ROLLBACK TO delete_project;
1024: return;
1025: END IF;

Line 1937: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

1933: --Added for bug 3617393
1934: x_err_code := 150;
1935: x_err_stack := x_err_stack || '->delete_retention_rules: '|| l_project_id;
1936: IF l_template_flag = 'Y' THEN
1937: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
1938: ELSE
1939: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
1940: END IF;
1941: ROLLBACK TO delete_task ;

Line 1939: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

1935: x_err_stack := x_err_stack || '->delete_retention_rules: '|| l_project_id;
1936: IF l_template_flag = 'Y' THEN
1937: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
1938: ELSE
1939: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
1940: END IF;
1941: ROLLBACK TO delete_task ;
1942: --End bug 3617393
1943: RETURN;

Line 1982: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

1978: --Added for bug 3617393
1979: x_err_code := 160;
1980: x_err_stack := x_err_stack || '->DELETE_RELATIONSHIP: '|| l_project_id;
1981: IF l_template_flag = 'Y' THEN
1982: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
1983: ELSE
1984: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
1985: END IF;
1986: ROLLBACK TO delete_task ;

Line 1984: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');

1980: x_err_stack := x_err_stack || '->DELETE_RELATIONSHIP: '|| l_project_id;
1981: IF l_template_flag = 'Y' THEN
1982: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');
1983: ELSE
1984: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_PROJECT');
1985: END IF;
1986: ROLLBACK TO delete_task ;
1987: --End bug 3617393
1988: return;

Line 2154: end PA_PROJECT_CORE;

2150: rollback to delete_class_code;
2151: return;
2152: end delete_class_code;
2153:
2154: end PA_PROJECT_CORE;