451: IF NOT hr_cnp_shd.api_updating
452: (p_canvas_property_id => p_rec.canvas_property_id
453: ,p_object_version_number => p_rec.object_version_number
454: ) THEN
455: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
456: fnd_message.set_token('PROCEDURE ', l_proc);
457: fnd_message.set_token('STEP ', '5');
458: fnd_message.raise_error;
459: END IF;
452: (p_canvas_property_id => p_rec.canvas_property_id
453: ,p_object_version_number => p_rec.object_version_number
454: ) THEN
455: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
456: fnd_message.set_token('PROCEDURE ', l_proc);
457: fnd_message.set_token('STEP ', '5');
458: fnd_message.raise_error;
459: END IF;
460: --
453: ,p_object_version_number => p_rec.object_version_number
454: ) THEN
455: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
456: fnd_message.set_token('PROCEDURE ', l_proc);
457: fnd_message.set_token('STEP ', '5');
458: fnd_message.raise_error;
459: END IF;
460: --
461: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>
454: ) THEN
455: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
456: fnd_message.set_token('PROCEDURE ', l_proc);
457: fnd_message.set_token('STEP ', '5');
458: fnd_message.raise_error;
459: END IF;
460: --
461: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>
462: nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number)
502: if not ( ( p_form_canvas_id is not null
503: and p_template_canvas_id is null)
504: or ( p_form_canvas_id is null
505: and p_template_canvas_id is not null)) then
506: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
507: fnd_message.set_token('PROCEDURE', l_proc);
508: fnd_message.set_token('STEP','10');
509: fnd_message.raise_error;
510: end if;
503: and p_template_canvas_id is null)
504: or ( p_form_canvas_id is null
505: and p_template_canvas_id is not null)) then
506: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
507: fnd_message.set_token('PROCEDURE', l_proc);
508: fnd_message.set_token('STEP','10');
509: fnd_message.raise_error;
510: end if;
511: --
504: or ( p_form_canvas_id is null
505: and p_template_canvas_id is not null)) then
506: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
507: fnd_message.set_token('PROCEDURE', l_proc);
508: fnd_message.set_token('STEP','10');
509: fnd_message.raise_error;
510: end if;
511: --
512: hr_utility.set_location('Leaving:'||l_proc, 100);
505: and p_template_canvas_id is not null)) then
506: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
507: fnd_message.set_token('PROCEDURE', l_proc);
508: fnd_message.set_token('STEP','10');
509: fnd_message.raise_error;
510: end if;
511: --
512: hr_utility.set_location('Leaving:'||l_proc, 100);
513: End chk_form_and_template_canvas;
555: );
556: --
557: /*
558: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB','TAB_STACKED')) then
559: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
560: fnd_message.set_token('PROCEDURE', l_proc);
561: fnd_message.set_token('STEP','10');
562: fnd_message.raise_error;
563: end if;
556: --
557: /*
558: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB','TAB_STACKED')) then
559: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
560: fnd_message.set_token('PROCEDURE', l_proc);
561: fnd_message.set_token('STEP','10');
562: fnd_message.raise_error;
563: end if;
564: */
557: /*
558: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB','TAB_STACKED')) then
559: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
560: fnd_message.set_token('PROCEDURE', l_proc);
561: fnd_message.set_token('STEP','10');
562: fnd_message.raise_error;
563: end if;
564: */
565: --
558: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB','TAB_STACKED')) then
559: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
560: fnd_message.set_token('PROCEDURE', l_proc);
561: fnd_message.set_token('STEP','10');
562: fnd_message.raise_error;
563: end if;
564: */
565: --
566: end if;
612: (p_template_canvas_id => p_template_canvas_id
613: );
614: /*
615: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB')) then
616: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
617: fnd_message.set_token('PROCEDURE', l_proc);
618: fnd_message.set_token('STEP','10');
619: fnd_message.raise_error;
620: end if;
613: );
614: /*
615: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB')) then
616: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
617: fnd_message.set_token('PROCEDURE', l_proc);
618: fnd_message.set_token('STEP','10');
619: fnd_message.raise_error;
620: end if;
621: */
614: /*
615: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB')) then
616: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
617: fnd_message.set_token('PROCEDURE', l_proc);
618: fnd_message.set_token('STEP','10');
619: fnd_message.raise_error;
620: end if;
621: */
622: --
615: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB')) then
616: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
617: fnd_message.set_token('PROCEDURE', l_proc);
618: fnd_message.set_token('STEP','10');
619: fnd_message.raise_error;
620: end if;
621: */
622: --
623: end if;
648: --
649: hr_utility.set_location(l_proc,30);
650: --
651: if (p_height < 0) then
652: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
653: fnd_message.set_token('PROCEDURE', l_proc);
654: fnd_message.set_token('STEP','10');
655: fnd_message.raise_error;
656: end if;
649: hr_utility.set_location(l_proc,30);
650: --
651: if (p_height < 0) then
652: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
653: fnd_message.set_token('PROCEDURE', l_proc);
654: fnd_message.set_token('STEP','10');
655: fnd_message.raise_error;
656: end if;
657: --
650: --
651: if (p_height < 0) then
652: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
653: fnd_message.set_token('PROCEDURE', l_proc);
654: fnd_message.set_token('STEP','10');
655: fnd_message.raise_error;
656: end if;
657: --
658: end if;
651: if (p_height < 0) then
652: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
653: fnd_message.set_token('PROCEDURE', l_proc);
654: fnd_message.set_token('STEP','10');
655: fnd_message.raise_error;
656: end if;
657: --
658: end if;
659: --
710: (p_effective_date => p_effective_date
711: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
712: ,p_lookup_code => p_visible
713: ) then
714: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
715: fnd_message.set_token('PROCEDURE', l_proc);
716: fnd_message.set_token('STEP','10');
717: fnd_message.raise_error;
718: end if;
711: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
712: ,p_lookup_code => p_visible
713: ) then
714: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
715: fnd_message.set_token('PROCEDURE', l_proc);
716: fnd_message.set_token('STEP','10');
717: fnd_message.raise_error;
718: end if;
719: --
712: ,p_lookup_code => p_visible
713: ) then
714: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
715: fnd_message.set_token('PROCEDURE', l_proc);
716: fnd_message.set_token('STEP','10');
717: fnd_message.raise_error;
718: end if;
719: --
720: end if;
713: ) then
714: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
715: fnd_message.set_token('PROCEDURE', l_proc);
716: fnd_message.set_token('STEP','10');
717: fnd_message.raise_error;
718: end if;
719: --
720: end if;
721: --
745: --
746: hr_utility.set_location(l_proc,30);
747: --
748: if (p_width < 0) then
749: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
750: fnd_message.set_token('PROCEDURE', l_proc);
751: fnd_message.set_token('STEP','10');
752: fnd_message.raise_error;
753: end if;
746: hr_utility.set_location(l_proc,30);
747: --
748: if (p_width < 0) then
749: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
750: fnd_message.set_token('PROCEDURE', l_proc);
751: fnd_message.set_token('STEP','10');
752: fnd_message.raise_error;
753: end if;
754: --
747: --
748: if (p_width < 0) then
749: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
750: fnd_message.set_token('PROCEDURE', l_proc);
751: fnd_message.set_token('STEP','10');
752: fnd_message.raise_error;
753: end if;
754: --
755: end if;
748: if (p_width < 0) then
749: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
750: fnd_message.set_token('PROCEDURE', l_proc);
751: fnd_message.set_token('STEP','10');
752: fnd_message.raise_error;
753: end if;
754: --
755: end if;
756: --
778: --
779: hr_utility.set_location(l_proc,30);
780: --
781: if (p_x_position < 0) then
782: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
783: fnd_message.set_token('PROCEDURE', l_proc);
784: fnd_message.set_token('STEP','10');
785: fnd_message.raise_error;
786: end if;
779: hr_utility.set_location(l_proc,30);
780: --
781: if (p_x_position < 0) then
782: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
783: fnd_message.set_token('PROCEDURE', l_proc);
784: fnd_message.set_token('STEP','10');
785: fnd_message.raise_error;
786: end if;
787: --
780: --
781: if (p_x_position < 0) then
782: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
783: fnd_message.set_token('PROCEDURE', l_proc);
784: fnd_message.set_token('STEP','10');
785: fnd_message.raise_error;
786: end if;
787: --
788: end if;
781: if (p_x_position < 0) then
782: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
783: fnd_message.set_token('PROCEDURE', l_proc);
784: fnd_message.set_token('STEP','10');
785: fnd_message.raise_error;
786: end if;
787: --
788: end if;
789: --
811: --
812: hr_utility.set_location(l_proc,30);
813: --
814: if (p_y_position < 0) then
815: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
816: fnd_message.set_token('PROCEDURE', l_proc);
817: fnd_message.set_token('STEP','10');
818: fnd_message.raise_error;
819: end if;
812: hr_utility.set_location(l_proc,30);
813: --
814: if (p_y_position < 0) then
815: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
816: fnd_message.set_token('PROCEDURE', l_proc);
817: fnd_message.set_token('STEP','10');
818: fnd_message.raise_error;
819: end if;
820: --
813: --
814: if (p_y_position < 0) then
815: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
816: fnd_message.set_token('PROCEDURE', l_proc);
817: fnd_message.set_token('STEP','10');
818: fnd_message.raise_error;
819: end if;
820: --
821: end if;
814: if (p_y_position < 0) then
815: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
816: fnd_message.set_token('PROCEDURE', l_proc);
817: fnd_message.set_token('STEP','10');
818: fnd_message.raise_error;
819: end if;
820: --
821: end if;
822: --
878: close csr_template_window;
879: end if;
880: --
881: if (nvl(p_rec.height,hr_api.g_number) <> nvl(l_window_height,hr_api.g_number)) then
882: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
883: fnd_message.set_token('PROCEDURE', l_proc);
884: fnd_message.set_token('STEP','10');
885: fnd_message.raise_error;
886: end if;
879: end if;
880: --
881: if (nvl(p_rec.height,hr_api.g_number) <> nvl(l_window_height,hr_api.g_number)) then
882: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
883: fnd_message.set_token('PROCEDURE', l_proc);
884: fnd_message.set_token('STEP','10');
885: fnd_message.raise_error;
886: end if;
887: --
880: --
881: if (nvl(p_rec.height,hr_api.g_number) <> nvl(l_window_height,hr_api.g_number)) then
882: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
883: fnd_message.set_token('PROCEDURE', l_proc);
884: fnd_message.set_token('STEP','10');
885: fnd_message.raise_error;
886: end if;
887: --
888: if (nvl(p_rec.width,hr_api.g_number) <> nvl(l_window_width,hr_api.g_number)) then
881: if (nvl(p_rec.height,hr_api.g_number) <> nvl(l_window_height,hr_api.g_number)) then
882: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
883: fnd_message.set_token('PROCEDURE', l_proc);
884: fnd_message.set_token('STEP','10');
885: fnd_message.raise_error;
886: end if;
887: --
888: if (nvl(p_rec.width,hr_api.g_number) <> nvl(l_window_width,hr_api.g_number)) then
889: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
885: fnd_message.raise_error;
886: end if;
887: --
888: if (nvl(p_rec.width,hr_api.g_number) <> nvl(l_window_width,hr_api.g_number)) then
889: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
890: fnd_message.set_token('PROCEDURE', l_proc);
891: fnd_message.set_token('STEP','20');
892: fnd_message.raise_error;
893: end if;
886: end if;
887: --
888: if (nvl(p_rec.width,hr_api.g_number) <> nvl(l_window_width,hr_api.g_number)) then
889: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
890: fnd_message.set_token('PROCEDURE', l_proc);
891: fnd_message.set_token('STEP','20');
892: fnd_message.raise_error;
893: end if;
894: --
887: --
888: if (nvl(p_rec.width,hr_api.g_number) <> nvl(l_window_width,hr_api.g_number)) then
889: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
890: fnd_message.set_token('PROCEDURE', l_proc);
891: fnd_message.set_token('STEP','20');
892: fnd_message.raise_error;
893: end if;
894: --
895: end if;
888: if (nvl(p_rec.width,hr_api.g_number) <> nvl(l_window_width,hr_api.g_number)) then
889: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
890: fnd_message.set_token('PROCEDURE', l_proc);
891: fnd_message.set_token('STEP','20');
892: fnd_message.raise_error;
893: end if;
894: --
895: end if;
896: --
897: -- Visible is only applicable for TAB or STACKED canvases
898: --
899: if (p_rec.visible is not null) then
900: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
901: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
902: fnd_message.set_token('PROCEDURE', l_proc);
903: fnd_message.set_token('STEP','30');
904: fnd_message.raise_error;
905: end if;
898: --
899: if (p_rec.visible is not null) then
900: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
901: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
902: fnd_message.set_token('PROCEDURE', l_proc);
903: fnd_message.set_token('STEP','30');
904: fnd_message.raise_error;
905: end if;
906: end if;
899: if (p_rec.visible is not null) then
900: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
901: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
902: fnd_message.set_token('PROCEDURE', l_proc);
903: fnd_message.set_token('STEP','30');
904: fnd_message.raise_error;
905: end if;
906: end if;
907: --
900: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
901: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
902: fnd_message.set_token('PROCEDURE', l_proc);
903: fnd_message.set_token('STEP','30');
904: fnd_message.raise_error;
905: end if;
906: end if;
907: --
908: -- X position is only applicable for TAB or STACKED canvases
908: -- X position is only applicable for TAB or STACKED canvases
909: --
910: if (p_rec.x_position is not null) then
911: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
912: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
913: fnd_message.set_token('PROCEDURE', l_proc);
914: fnd_message.set_token('STEP','40');
915: fnd_message.raise_error;
916: end if;
909: --
910: if (p_rec.x_position is not null) then
911: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
912: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
913: fnd_message.set_token('PROCEDURE', l_proc);
914: fnd_message.set_token('STEP','40');
915: fnd_message.raise_error;
916: end if;
917: end if;
910: if (p_rec.x_position is not null) then
911: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
912: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
913: fnd_message.set_token('PROCEDURE', l_proc);
914: fnd_message.set_token('STEP','40');
915: fnd_message.raise_error;
916: end if;
917: end if;
918: --
911: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
912: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
913: fnd_message.set_token('PROCEDURE', l_proc);
914: fnd_message.set_token('STEP','40');
915: fnd_message.raise_error;
916: end if;
917: end if;
918: --
919: -- Y position is only applicable for TAB or STACKED canvases
919: -- Y position is only applicable for TAB or STACKED canvases
920: --
921: if (p_rec.y_position is not null) then
922: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
923: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
924: fnd_message.set_token('PROCEDURE', l_proc);
925: fnd_message.set_token('STEP','50');
926: fnd_message.raise_error;
927: end if;
920: --
921: if (p_rec.y_position is not null) then
922: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
923: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
924: fnd_message.set_token('PROCEDURE', l_proc);
925: fnd_message.set_token('STEP','50');
926: fnd_message.raise_error;
927: end if;
928: end if;
921: if (p_rec.y_position is not null) then
922: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
923: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
924: fnd_message.set_token('PROCEDURE', l_proc);
925: fnd_message.set_token('STEP','50');
926: fnd_message.raise_error;
927: end if;
928: end if;
929: --
922: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
923: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
924: fnd_message.set_token('PROCEDURE', l_proc);
925: fnd_message.set_token('STEP','50');
926: fnd_message.raise_error;
927: end if;
928: end if;
929: --
930: hr_utility.set_location('Leaving:'||l_proc, 100);