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.HR_CNP_BUS dependencies on HR_UTILITY

Line 36: hr_utility.set_location('Entering:'|| l_proc, 10);

32: l_proc varchar2(72) := g_package||'set_security_group_id';
33: --
34: begin
35: --
36: hr_utility.set_location('Entering:'|| l_proc, 10);
37: --
38: -- No business group context. Security group is not applicable.
39: --
40: null;

Line 42: hr_utility.set_location(' Leaving:'|| l_proc, 20);

38: -- No business group context. Security group is not applicable.
39: --
40: null;
41: --
42: hr_utility.set_location(' Leaving:'|| l_proc, 20);
43: --
44: end set_security_group_id;
45: --
46: -- ---------------------------------------------------------------------------

Line 75: hr_utility.set_location('Entering:'|| l_proc, 10);

71: l_proc varchar2(72) := g_package||'return_legislation_code';
72: --
73: Begin
74: --
75: hr_utility.set_location('Entering:'|| l_proc, 10);
76: --
77: -- Ensure that all the mandatory parameter are not null
78: --
79: hr_api.mandatory_arg_error

Line 93: hr_utility.set_location(l_proc, 20);

89: -- call to this function. Just return the value in the global
90: -- variable.
91: --
92: l_legislation_code := hr_cnp_bus.g_legislation_code;
93: hr_utility.set_location(l_proc, 20);
94: else
95: --
96: -- The ID is different to the last call to this function
97: -- or this is the first call to this function.

Line 109: hr_utility.set_location(l_proc,30);

105: -- properties.
106: --
107: l_legislation_code := null;
108: end if;
109: hr_utility.set_location(l_proc,30);
110: --
111: -- Set the global variables so the values are
112: -- available for the next call to this function.
113: --

Line 118: hr_utility.set_location(' Leaving:'|| l_proc, 40);

114: close csr_leg_code;
115: hr_cnp_bus.g_canvas_property_id := p_canvas_property_id;
116: hr_cnp_bus.g_legislation_code := l_legislation_code;
117: end if;
118: hr_utility.set_location(' Leaving:'|| l_proc, 40);
119: return l_legislation_code;
120: end return_legislation_code;
121: --
122: -- ---------------------------------------------------------------------------

Line 173: hr_utility.set_location('Entering:'|| l_proc, 10);

169: l_proc varchar2(72) := g_package||'return_canvas_type';
170: --
171: Begin
172: --
173: hr_utility.set_location('Entering:'|| l_proc, 10);
174: --
175: if ( nvl(hr_cnp_bus.g_form_canvas_id, hr_api.g_number) = nvl(p_form_canvas_id, hr_api.g_number)
176: and nvl(hr_cnp_bus.g_template_canvas_id, hr_api.g_number) = nvl(p_template_canvas_id, hr_api.g_number)
177: ) then

Line 184: hr_utility.set_location(l_proc, 20);

180: -- call to this function. Just return the value in the global
181: -- variable.
182: --
183: l_canvas_type := hr_cnp_bus.g_canvas_type;
184: hr_utility.set_location(l_proc, 20);
185: else
186: --
187: -- The IDs are different to the last call to this function
188: -- or this is the first call to this function.

Line 202: hr_utility.set_location(l_proc,30);

198: --
199: close csr_form_canvas;
200: hr_cnp_shd.constraint_error('HR_CANVAS_PROPERTIES_FK1');
201: end if;
202: hr_utility.set_location(l_proc,30);
203: close csr_form_canvas;
204: --
205: elsif (nvl(p_template_canvas_id, hr_api.g_number) <> hr_api.g_number) then
206: --

Line 217: hr_utility.set_location(l_proc,40);

213: --
214: close csr_template_canvas;
215: hr_cnp_shd.constraint_error('HR_CANVAS_PROPERTIES_FK2');
216: end if;
217: hr_utility.set_location(l_proc,40);
218: close csr_template_canvas;
219: --
220: end if;
221: --

Line 229: hr_utility.set_location(' Leaving:'|| l_proc, 50);

225: hr_cnp_bus.g_form_canvas_id := p_form_canvas_id;
226: hr_cnp_bus.g_template_canvas_id := p_template_canvas_id;
227: hr_cnp_bus.g_canvas_type := l_canvas_type;
228: end if;
229: hr_utility.set_location(' Leaving:'|| l_proc, 50);
230: return l_canvas_type;
231: end return_canvas_type;
232: --
233: -- ----------------------------------------------------------------------------

Line 268: hr_utility.set_location('Entering:'||l_proc,10);

264: --
265: l_proc varchar2(72) := g_package || 'chk_ddf';
266: --
267: begin
268: hr_utility.set_location('Entering:'||l_proc,10);
269: --
270: if ((p_rec.canvas_property_id is not null) and (
271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
272: nvl(p_rec.information_category, hr_api.g_varchar2) or

Line 407: hr_utility.set_location(' Leaving:'||l_proc,20);

403: ,p_attribute30_value => p_rec.information30
404: );
405: end if;
406: --
407: hr_utility.set_location(' Leaving:'||l_proc,20);
408: end chk_ddf;
409: --
410: -- ----------------------------------------------------------------------------
411: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 498: hr_utility.set_location('Entering:'||l_proc, 10);

494: l_proc varchar2(72) := g_package || 'chk_form_and_template_canvas';
495: l_api_updating boolean;
496: --
497: Begin
498: hr_utility.set_location('Entering:'||l_proc, 10);
499: --
500: -- One and only one of form_canvas_id and template_canvas_id must be given
501: --
502: if not ( ( p_form_canvas_id is not null

Line 512: hr_utility.set_location('Leaving:'||l_proc, 100);

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;
514: --
515: -- ----------------------------------------------------------------------------
516: -- |--------------------------< chk_form_canvas_id >--------------------------|

Line 530: hr_utility.set_location('Entering:'||l_proc, 10);

526: l_api_updating boolean;
527: l_canvas_type varchar2(30);
528: --
529: Begin
530: hr_utility.set_location('Entering:'||l_proc, 10);
531: --
532: l_api_updating := hr_cnp_shd.api_updating
533: (p_canvas_property_id => p_canvas_property_id
534: ,p_object_version_number => p_object_version_number

Line 536: hr_utility.set_location(l_proc,20);

532: l_api_updating := hr_cnp_shd.api_updating
533: (p_canvas_property_id => p_canvas_property_id
534: ,p_object_version_number => p_object_version_number
535: );
536: hr_utility.set_location(l_proc,20);
537: --
538: -- Only proceed with SQL validation if absolutely necessary
539: --
540: if ( ( l_api_updating

Line 545: hr_utility.set_location(l_proc,30);

541: and nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
542: nvl(p_form_canvas_id,hr_api.g_number))
543: or (NOT l_api_updating)) then
544: --
545: hr_utility.set_location(l_proc,30);
546: --
547: if (p_form_canvas_id is not null) then
548: --
549: hr_utility.set_location(l_proc,40);

Line 549: hr_utility.set_location(l_proc,40);

545: hr_utility.set_location(l_proc,30);
546: --
547: if (p_form_canvas_id is not null) then
548: --
549: hr_utility.set_location(l_proc,40);
550: --
551: -- Associated canvas must be of type CONTENT or TAB
552: --
553: l_canvas_type := return_canvas_type

Line 570: hr_utility.set_location('Leaving:'||l_proc, 100);

566: end if;
567: --
568: end if;
569: --
570: hr_utility.set_location('Leaving:'||l_proc, 100);
571: End chk_form_canvas_id;
572: --
573: -- ----------------------------------------------------------------------------
574: -- |------------------------< chk_template_canvas_id >------------------------|

Line 588: hr_utility.set_location('Entering:'||l_proc, 10);

584: l_api_updating boolean;
585: l_canvas_type varchar2(30);
586: --
587: Begin
588: hr_utility.set_location('Entering:'||l_proc, 10);
589: --
590: l_api_updating := hr_cnp_shd.api_updating
591: (p_canvas_property_id => p_canvas_property_id
592: ,p_object_version_number => p_object_version_number

Line 594: hr_utility.set_location(l_proc,20);

590: l_api_updating := hr_cnp_shd.api_updating
591: (p_canvas_property_id => p_canvas_property_id
592: ,p_object_version_number => p_object_version_number
593: );
594: hr_utility.set_location(l_proc,20);
595: --
596: -- Only proceed with SQL validation if absolutely necessary
597: --
598: if ( ( l_api_updating

Line 603: hr_utility.set_location(l_proc,30);

599: and nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number) <>
600: nvl(p_template_canvas_id,hr_api.g_number))
601: or (NOT l_api_updating)) then
602: --
603: hr_utility.set_location(l_proc,30);
604: --
605: if (p_template_canvas_id is not null) then
606: --
607: hr_utility.set_location(l_proc,40);

Line 607: hr_utility.set_location(l_proc,40);

603: hr_utility.set_location(l_proc,30);
604: --
605: if (p_template_canvas_id is not null) then
606: --
607: hr_utility.set_location(l_proc,40);
608: --
609: -- Associated canvas must be of type CONTENT or TAB
610: --
611: l_canvas_type := return_canvas_type

Line 627: hr_utility.set_location('Leaving:'||l_proc, 100);

623: end if;
624: --
625: end if;
626: --
627: hr_utility.set_location('Leaving:'||l_proc, 100);
628: End chk_template_canvas_id;
629: --
630: -- ----------------------------------------------------------------------------
631: -- |------------------------------< chk_height >------------------------------|

Line 643: hr_utility.set_location('Entering:'||l_proc, 10);

639: l_proc varchar2(72) := g_package || 'chk_height';
640: l_api_updating boolean;
641: --
642: Begin
643: hr_utility.set_location('Entering:'||l_proc, 10);
644: --
645: -- Height must be greater than or equal to zero, if given
646: --
647: if (p_height is not null) then

Line 649: hr_utility.set_location(l_proc,30);

645: -- Height must be greater than or equal to zero, if given
646: --
647: if (p_height is not null) then
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);

Line 660: hr_utility.set_location('Leaving:'||l_proc, 100);

656: end if;
657: --
658: end if;
659: --
660: hr_utility.set_location('Leaving:'||l_proc, 100);
661: End chk_height;
662: --
663: -- ----------------------------------------------------------------------------
664: -- |-----------------------------< chk_visible >------------------------------|

Line 677: hr_utility.set_location('Entering:'||l_proc, 10);

673: l_proc varchar2(72) := g_package || 'chk_visible';
674: l_api_updating boolean;
675: --
676: Begin
677: hr_utility.set_location('Entering:'||l_proc, 10);
678: --
679: -- Check mandatory arguments have been set
680: --
681: hr_api.mandatory_arg_error

Line 691: hr_utility.set_location(l_proc,20);

687: l_api_updating := hr_cnp_shd.api_updating
688: (p_canvas_property_id => p_canvas_property_id
689: ,p_object_version_number => p_object_version_number
690: );
691: hr_utility.set_location(l_proc,20);
692: --
693: -- Only proceed with SQL validation if absolutely necessary
694: --
695: if ( ( l_api_updating

Line 700: hr_utility.set_location(l_proc,30);

696: and nvl(hr_cnp_shd.g_old_rec.visible,hr_api.g_number) <>
697: nvl(p_visible,hr_api.g_number))
698: or (NOT l_api_updating)) then
699: --
700: hr_utility.set_location(l_proc,30);
701: --
702: if (p_visible is not null) then
703: --
704: hr_utility.set_location(l_proc,40);

Line 704: hr_utility.set_location(l_proc,40);

700: hr_utility.set_location(l_proc,30);
701: --
702: if (p_visible is not null) then
703: --
704: hr_utility.set_location(l_proc,40);
705: --
706: -- Must exist in hr_standard_lookups where lookup_type is
707: -- PROPERTY_TRUE_OR_FALSE
708: --

Line 724: hr_utility.set_location('Leaving:'||l_proc, 100);

720: end if;
721: --
722: end if;
723: --
724: hr_utility.set_location('Leaving:'||l_proc, 100);
725: End chk_visible;
726: --
727: -- ----------------------------------------------------------------------------
728: -- |------------------------------< chk_width >-------------------------------|

Line 740: hr_utility.set_location('Entering:'||l_proc, 10);

736: l_proc varchar2(72) := g_package || 'chk_width';
737: l_api_updating boolean;
738: --
739: Begin
740: hr_utility.set_location('Entering:'||l_proc, 10);
741: --
742: -- Width must be greater than or equal to zero, if given
743: --
744: if (p_width is not null) then

Line 746: hr_utility.set_location(l_proc,30);

742: -- Width must be greater than or equal to zero, if given
743: --
744: if (p_width is not null) then
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);

Line 757: hr_utility.set_location('Leaving:'||l_proc, 100);

753: end if;
754: --
755: end if;
756: --
757: hr_utility.set_location('Leaving:'||l_proc, 100);
758: End chk_width;
759: --
760: -- ----------------------------------------------------------------------------
761: -- |-----------------------------< chk_x_position >---------------------------|

Line 773: hr_utility.set_location('Entering:'||l_proc, 10);

769: l_proc varchar2(72) := g_package || 'chk_x_position';
770: l_api_updating boolean;
771: --
772: Begin
773: hr_utility.set_location('Entering:'||l_proc, 10);
774: --
775: -- X position must be greater than or equal to zero,if given
776: --
777: if (p_x_position is not null) then

Line 779: hr_utility.set_location(l_proc,30);

775: -- X position must be greater than or equal to zero,if given
776: --
777: if (p_x_position is not null) then
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);

Line 790: hr_utility.set_location('Leaving:'||l_proc, 100);

786: end if;
787: --
788: end if;
789: --
790: hr_utility.set_location('Leaving:'||l_proc, 100);
791: End chk_x_position;
792: --
793: -- ----------------------------------------------------------------------------
794: -- |-----------------------------< chk_y_position >---------------------------|

Line 806: hr_utility.set_location('Entering:'||l_proc, 10);

802: l_proc varchar2(72) := g_package || 'chk_y_position';
803: l_api_updating boolean;
804: --
805: Begin
806: hr_utility.set_location('Entering:'||l_proc, 10);
807: --
808: -- Y position must be greater than or equal to zero, if given
809: --
810: if (p_y_position is not null) then

Line 812: hr_utility.set_location(l_proc,30);

808: -- Y position must be greater than or equal to zero, if given
809: --
810: if (p_y_position is not null) then
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);

Line 823: hr_utility.set_location('Leaving:'||l_proc, 100);

819: end if;
820: --
821: end if;
822: --
823: hr_utility.set_location('Leaving:'||l_proc, 100);
824: End chk_y_position;
825: --
826: -- ----------------------------------------------------------------------------
827: -- |---------------------< chk_canvas_type_dependencies >---------------------|

Line 859: hr_utility.set_location('Entering:'||l_proc, 10);

855: l_window_height number;
856: l_window_width number;
857: --
858: Begin
859: hr_utility.set_location('Entering:'||l_proc, 10);
860: --
861: l_canvas_type := return_canvas_type
862: (p_form_canvas_id => p_rec.form_canvas_id
863: ,p_template_canvas_id => p_rec.template_canvas_id

Line 865: hr_utility.set_location(l_proc,30);

861: l_canvas_type := return_canvas_type
862: (p_form_canvas_id => p_rec.form_canvas_id
863: ,p_template_canvas_id => p_rec.template_canvas_id
864: );
865: hr_utility.set_location(l_proc,30);
866: --
867: -- Content canvases must be the same height and width as their window
868: --
869: if (l_canvas_type = 'CONTENT') then

Line 930: hr_utility.set_location('Leaving:'||l_proc, 100);

926: fnd_message.raise_error;
927: end if;
928: end if;
929: --
930: hr_utility.set_location('Leaving:'||l_proc, 100);
931: End chk_canvas_type_dependencies;
932: --
933: -- ----------------------------------------------------------------------------
934: -- |------------------------------< chk_delete >------------------------------|

Line 943: hr_utility.set_location('Entering:'||l_proc, 5);

939: --
940: l_proc varchar2(72) := g_package||'chk_delete';
941: --
942: Begin
943: hr_utility.set_location('Entering:'||l_proc, 5);
944: --
945: -- No additional validation required
946: --
947: null;

Line 949: hr_utility.set_location(' Leaving:'||l_proc, 10);

945: -- No additional validation required
946: --
947: null;
948: --
949: hr_utility.set_location(' Leaving:'||l_proc, 10);
950: End chk_delete;
951: --
952: -- ----------------------------------------------------------------------------
953: -- |---------------------------< insert_validate >----------------------------|

Line 963: hr_utility.set_location('Entering:'||l_proc, 5);

959: --
960: l_proc varchar2(72) := g_package||'insert_validate';
961: --
962: Begin
963: hr_utility.set_location('Entering:'||l_proc, 5);
964: --
965: -- Check mandatory arguments have been set
966: --
967: hr_api.mandatory_arg_error

Line 1037: hr_utility.set_location(' Leaving:'||l_proc, 10);

1033: chk_ddf
1034: (p_rec => p_rec
1035: );
1036: --
1037: hr_utility.set_location(' Leaving:'||l_proc, 10);
1038: End insert_validate;
1039: --
1040: -- ----------------------------------------------------------------------------
1041: -- |---------------------------< update_validate >----------------------------|

Line 1051: hr_utility.set_location('Entering:'||l_proc, 5);

1047: --
1048: l_proc varchar2(72) := g_package||'update_validate';
1049: --
1050: Begin
1051: hr_utility.set_location('Entering:'||l_proc, 5);
1052: --
1053: -- Check mandatory arguments have been set
1054: --
1055: hr_api.mandatory_arg_error

Line 1130: hr_utility.set_location(' Leaving:'||l_proc, 10);

1126: chk_ddf
1127: (p_rec => p_rec
1128: );
1129: --
1130: hr_utility.set_location(' Leaving:'||l_proc, 10);
1131: End update_validate;
1132: --
1133: -- ----------------------------------------------------------------------------
1134: -- |---------------------------< delete_validate >----------------------------|

Line 1143: hr_utility.set_location('Entering:'||l_proc, 5);

1139: --
1140: l_proc varchar2(72) := g_package||'delete_validate';
1141: --
1142: Begin
1143: hr_utility.set_location('Entering:'||l_proc, 5);
1144: --
1145: -- Call all supporting business operations
1146: --
1147: chk_delete

Line 1151: hr_utility.set_location(' Leaving:'||l_proc, 10);

1147: chk_delete
1148: (p_rec => p_rec
1149: );
1150: --
1151: hr_utility.set_location(' Leaving:'||l_proc, 10);
1152: End delete_validate;
1153: --
1154: end hr_cnp_bus;