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_FIM_BUS dependencies on HR_API

Line 113: IF (nvl(p_rec.application_id,hr_api.g_number) <>

109: fnd_message.set_token('STEP ', '5');
110: fnd_message.raise_error;
111: END IF;
112: --
113: IF (nvl(p_rec.application_id,hr_api.g_number) <>
114: nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number)
115: ) THEN
116: l_argument := 'application_id';
117: RAISE l_error;

Line 114: nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number)

110: fnd_message.raise_error;
111: END IF;
112: --
113: IF (nvl(p_rec.application_id,hr_api.g_number) <>
114: nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number)
115: ) THEN
116: l_argument := 'application_id';
117: RAISE l_error;
118: END IF;

Line 120: IF (nvl(p_rec.form_id,hr_api.g_number) <>

116: l_argument := 'application_id';
117: RAISE l_error;
118: END IF;
119: --
120: IF (nvl(p_rec.form_id,hr_api.g_number) <>
121: nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number)
122: ) THEN
123: l_argument := 'form_id';
124: RAISE l_error;

Line 121: nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number)

117: RAISE l_error;
118: END IF;
119: --
120: IF (nvl(p_rec.form_id,hr_api.g_number) <>
121: nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number)
122: ) THEN
123: l_argument := 'form_id';
124: RAISE l_error;
125: END IF;

Line 127: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>

123: l_argument := 'form_id';
124: RAISE l_error;
125: END IF;
126: --
127: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>
128: nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number)
129: ) THEN
130: l_argument := 'form_canvas_id';
131: RAISE l_error;

Line 128: nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number)

124: RAISE l_error;
125: END IF;
126: --
127: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>
128: nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number)
129: ) THEN
130: l_argument := 'form_canvas_id';
131: RAISE l_error;
132: END IF;

Line 134: IF (nvl(p_rec.form_tab_page_id,hr_api.g_number) <>

130: l_argument := 'form_canvas_id';
131: RAISE l_error;
132: END IF;
133: --
134: IF (nvl(p_rec.form_tab_page_id,hr_api.g_number) <>
135: nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number)
136: ) THEN
137: l_argument := 'form_tab_page_id';
138: RAISE l_error;

Line 135: nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number)

131: RAISE l_error;
132: END IF;
133: --
134: IF (nvl(p_rec.form_tab_page_id,hr_api.g_number) <>
135: nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number)
136: ) THEN
137: l_argument := 'form_tab_page_id';
138: RAISE l_error;
139: END IF;

Line 141: IF (nvl(p_rec.item_type,hr_api.g_varchar2) <>

137: l_argument := 'form_tab_page_id';
138: RAISE l_error;
139: END IF;
140: --
141: IF (nvl(p_rec.item_type,hr_api.g_varchar2) <>
142: nvl(hr_fim_shd.g_old_rec.item_type,hr_api.g_varchar2)
143: ) THEN
144: l_argument := 'item_type';
145: RAISE l_error;

Line 142: nvl(hr_fim_shd.g_old_rec.item_type,hr_api.g_varchar2)

138: RAISE l_error;
139: END IF;
140: --
141: IF (nvl(p_rec.item_type,hr_api.g_varchar2) <>
142: nvl(hr_fim_shd.g_old_rec.item_type,hr_api.g_varchar2)
143: ) THEN
144: l_argument := 'item_type';
145: RAISE l_error;
146: END IF;

Line 150: hr_api.argument_changed_error

146: END IF;
147: --
148: EXCEPTION
149: WHEN l_error THEN
150: hr_api.argument_changed_error
151: (p_api_name => l_proc
152: ,p_argument => l_argument);
153: WHEN OTHERS THEN
154: RAISE;

Line 181: hr_api.mandatory_arg_error

177: hr_utility.set_location('Entering:'||l_proc, 10);
178: --
179: -- Check value has been passed
180: --
181: hr_api.mandatory_arg_error
182: (p_api_name => l_proc
183: ,p_argument => 'application_id'
184: ,p_argument_value => p_application_id
185: );

Line 228: hr_api.mandatory_arg_error

224: hr_utility.set_location('Entering:'||l_proc, 10);
225: --
226: -- Check value has been passed
227: --
228: hr_api.mandatory_arg_error
229: (p_api_name => l_proc
230: ,p_argument => 'form_id'
231: ,p_argument_value => p_form_id
232: );

Line 280: and nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

276: --
277: -- Only proceed with SQL validation if absolutely necessary
278: --
279: if ( ( l_api_updating
280: and nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
281: nvl(p_form_canvas_id,hr_api.g_number))
282: or (NOT l_api_updating)) then
283: --
284: hr_utility.set_location(l_proc,30);

Line 281: nvl(p_form_canvas_id,hr_api.g_number))

277: -- Only proceed with SQL validation if absolutely necessary
278: --
279: if ( ( l_api_updating
280: and nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
281: nvl(p_form_canvas_id,hr_api.g_number))
282: or (NOT l_api_updating)) then
283: --
284: hr_utility.set_location(l_proc,30);
285: --

Line 288: hr_api.mandatory_arg_error

284: hr_utility.set_location(l_proc,30);
285: --
286: -- Check value has been passed
287: --
288: hr_api.mandatory_arg_error
289: (p_api_name => l_proc
290: ,p_argument => 'form_canvas_id'
291: ,p_argument_value => p_form_canvas_id
292: );

Line 311: if nvl(l_canvas_type,hr_api.g_varchar2) not in ('CONTENT','TAB','STACKED') then

307: close csr_form_canvas;
308: --
309: hr_utility.set_location(l_proc,50);
310: --
311: if nvl(l_canvas_type,hr_api.g_varchar2) not in ('CONTENT','TAB','STACKED') then
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','20');
315: fnd_message.raise_error;

Line 366: hr_api.mandatory_arg_error

362: hr_utility.set_location('Entering:'||l_proc, 10);
363: --
364: -- Check value has been passed
365: --
366: hr_api.mandatory_arg_error
367: (p_api_name => l_proc
368: ,p_argument => 'full_item_name'
369: ,p_argument_value => p_full_item_name
370: );

Line 437: hr_api.mandatory_arg_error

433: hr_utility.set_location('Entering:'||l_proc, 10);
434: --
435: -- Check mandatory arguments have been set
436: --
437: hr_api.mandatory_arg_error
438: (p_api_name => l_proc
439: ,p_argument => 'effective_date'
440: ,p_argument_value => p_effective_date
441: );

Line 452: and nvl(hr_fim_shd.g_old_rec.item_type,hr_api.g_varchar2) <>

448: --
449: -- Only proceed with SQL validation if absolutely necessary
450: --
451: if ( ( l_api_updating
452: and nvl(hr_fim_shd.g_old_rec.item_type,hr_api.g_varchar2) <>
453: nvl(p_item_type,hr_api.g_varchar2))
454: or (NOT l_api_updating)) then
455: --
456: hr_utility.set_location(l_proc,30);

Line 453: nvl(p_item_type,hr_api.g_varchar2))

449: -- Only proceed with SQL validation if absolutely necessary
450: --
451: if ( ( l_api_updating
452: and nvl(hr_fim_shd.g_old_rec.item_type,hr_api.g_varchar2) <>
453: nvl(p_item_type,hr_api.g_varchar2))
454: or (NOT l_api_updating)) then
455: --
456: hr_utility.set_location(l_proc,30);
457: --

Line 460: hr_api.mandatory_arg_error

456: hr_utility.set_location(l_proc,30);
457: --
458: -- Check value has been passed
459: --
460: hr_api.mandatory_arg_error
461: (p_api_name => l_proc
462: ,p_argument => 'item_type'
463: ,p_argument_value => p_item_type
464: );

Line 470: if hr_api.not_exists_in_hrstanlookups

466: hr_utility.set_location(l_proc,40);
467: --
468: -- Must exist in hr_standard_lookups where lookup_type is ITEM_TYPES
469: --
470: if hr_api.not_exists_in_hrstanlookups
471: (p_effective_date => p_effective_date
472: ,p_lookup_type => 'ITEM_TYPES'
473: ,p_lookup_code => p_item_type
474: ) then

Line 568: hr_api.mandatory_arg_error

564: hr_utility.set_location('Entering:'||l_proc, 10);
565: --
566: -- Check mandatory arguments have been set
567: --
568: hr_api.mandatory_arg_error
569: (p_api_name => l_proc
570: ,p_argument => 'effective_date'
571: ,p_argument_value => p_effective_date
572: );

Line 583: and nvl(hr_fim_shd.g_old_rec.required_override,hr_api.g_number) <>

579: --
580: -- Only proceed with SQL validation if absolutely necessary
581: --
582: if ( ( l_api_updating
583: and nvl(hr_fim_shd.g_old_rec.required_override,hr_api.g_number) <>
584: nvl(p_required_override,hr_api.g_number))
585: or (NOT l_api_updating)) then
586: --
587: hr_utility.set_location(l_proc,30);

Line 584: nvl(p_required_override,hr_api.g_number))

580: -- Only proceed with SQL validation if absolutely necessary
581: --
582: if ( ( l_api_updating
583: and nvl(hr_fim_shd.g_old_rec.required_override,hr_api.g_number) <>
584: nvl(p_required_override,hr_api.g_number))
585: or (NOT l_api_updating)) then
586: --
587: hr_utility.set_location(l_proc,30);
588: --

Line 596: if hr_api.not_exists_in_hrstanlookups

592: --
593: -- Must exist in hr_standard_lookups where lookup_type is
594: -- PROPERTY_TRUE_OR_FALSE
595: --
596: if hr_api.not_exists_in_hrstanlookups
597: (p_effective_date => p_effective_date
598: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
599: ,p_lookup_code => p_required_override
600: ) then

Line 632: hr_api.mandatory_arg_error

628: hr_utility.set_location('Entering:'||l_proc, 10);
629: --
630: -- Check mandatory arguments have been set
631: --
632: hr_api.mandatory_arg_error
633: (p_api_name => l_proc
634: ,p_argument => 'effective_date'
635: ,p_argument_value => p_effective_date
636: );

Line 647: and nvl(hr_fim_shd.g_old_rec.visible_override,hr_api.g_number) <>

643: --
644: -- Only proceed with SQL validation if absolutely necessary
645: --
646: if ( ( l_api_updating
647: and nvl(hr_fim_shd.g_old_rec.visible_override,hr_api.g_number) <>
648: nvl(p_visible_override,hr_api.g_number))
649: or (NOT l_api_updating)) then
650: --
651: hr_utility.set_location(l_proc,30);

Line 648: nvl(p_visible_override,hr_api.g_number))

644: -- Only proceed with SQL validation if absolutely necessary
645: --
646: if ( ( l_api_updating
647: and nvl(hr_fim_shd.g_old_rec.visible_override,hr_api.g_number) <>
648: nvl(p_visible_override,hr_api.g_number))
649: or (NOT l_api_updating)) then
650: --
651: hr_utility.set_location(l_proc,30);
652: --

Line 660: if hr_api.not_exists_in_hrstanlookups

656: --
657: -- Must exist in hr_standard_lookups where lookup_type is
658: -- PROPERTY_TRUE_OR_FALSE
659: --
660: if hr_api.not_exists_in_hrstanlookups
661: (p_effective_date => p_effective_date
662: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
663: ,p_lookup_code => p_visible_override
664: ) then

Line 715: and ( (nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number) <>

711: --
712: -- Only proceed with SQL validation if absolutely necessary
713: --
714: if ( ( l_api_updating
715: and ( (nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number) <>
716: nvl(p_application_id,hr_api.g_number))
717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>
718: nvl(p_form_id,hr_api.g_number))
719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

Line 716: nvl(p_application_id,hr_api.g_number))

712: -- Only proceed with SQL validation if absolutely necessary
713: --
714: if ( ( l_api_updating
715: and ( (nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number) <>
716: nvl(p_application_id,hr_api.g_number))
717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>
718: nvl(p_form_id,hr_api.g_number))
719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
720: nvl(p_form_canvas_id,hr_api.g_number))))

Line 717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>

713: --
714: if ( ( l_api_updating
715: and ( (nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number) <>
716: nvl(p_application_id,hr_api.g_number))
717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>
718: nvl(p_form_id,hr_api.g_number))
719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
720: nvl(p_form_canvas_id,hr_api.g_number))))
721: or (NOT l_api_updating)) then

Line 718: nvl(p_form_id,hr_api.g_number))

714: if ( ( l_api_updating
715: and ( (nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number) <>
716: nvl(p_application_id,hr_api.g_number))
717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>
718: nvl(p_form_id,hr_api.g_number))
719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
720: nvl(p_form_canvas_id,hr_api.g_number))))
721: or (NOT l_api_updating)) then
722: --

Line 719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

715: and ( (nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number) <>
716: nvl(p_application_id,hr_api.g_number))
717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>
718: nvl(p_form_id,hr_api.g_number))
719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
720: nvl(p_form_canvas_id,hr_api.g_number))))
721: or (NOT l_api_updating)) then
722: --
723: hr_utility.set_location(l_proc,30);

Line 720: nvl(p_form_canvas_id,hr_api.g_number))))

716: nvl(p_application_id,hr_api.g_number))
717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>
718: nvl(p_form_id,hr_api.g_number))
719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
720: nvl(p_form_canvas_id,hr_api.g_number))))
721: or (NOT l_api_updating)) then
722: --
723: hr_utility.set_location(l_proc,30);
724: --

Line 740: if ( (nvl(p_application_id,hr_api.g_number) <> nvl(l_application_id,hr_api.g_number))

736: close csr_form_canvas;
737: --
738: hr_utility.set_location(l_proc,40);
739: --
740: if ( (nvl(p_application_id,hr_api.g_number) <> nvl(l_application_id,hr_api.g_number))
741: or (nvl(p_form_id,hr_api.g_number) <> nvl(l_form_id,hr_api.g_number))) then
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','10');

Line 741: or (nvl(p_form_id,hr_api.g_number) <> nvl(l_form_id,hr_api.g_number))) then

737: --
738: hr_utility.set_location(l_proc,40);
739: --
740: if ( (nvl(p_application_id,hr_api.g_number) <> nvl(l_application_id,hr_api.g_number))
741: or (nvl(p_form_id,hr_api.g_number) <> nvl(l_form_id,hr_api.g_number))) then
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','10');
745: fnd_message.raise_error;

Line 793: and ( (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

789: --
790: -- Only proceed with SQL validation if absolutely necessary
791: --
792: if ( ( l_api_updating
793: and ( (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
794: nvl(p_form_canvas_id,hr_api.g_number))
795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
796: nvl(p_form_tab_page_id,hr_api.g_number))
797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>

Line 794: nvl(p_form_canvas_id,hr_api.g_number))

790: -- Only proceed with SQL validation if absolutely necessary
791: --
792: if ( ( l_api_updating
793: and ( (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
794: nvl(p_form_canvas_id,hr_api.g_number))
795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
796: nvl(p_form_tab_page_id,hr_api.g_number))
797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>
798: nvl(p_form_tab_page_id_override,hr_api.g_number))))

Line 795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>

791: --
792: if ( ( l_api_updating
793: and ( (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
794: nvl(p_form_canvas_id,hr_api.g_number))
795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
796: nvl(p_form_tab_page_id,hr_api.g_number))
797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>
798: nvl(p_form_tab_page_id_override,hr_api.g_number))))
799: or (NOT l_api_updating)) then

Line 796: nvl(p_form_tab_page_id,hr_api.g_number))

792: if ( ( l_api_updating
793: and ( (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
794: nvl(p_form_canvas_id,hr_api.g_number))
795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
796: nvl(p_form_tab_page_id,hr_api.g_number))
797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>
798: nvl(p_form_tab_page_id_override,hr_api.g_number))))
799: or (NOT l_api_updating)) then
800: --

Line 797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>

793: and ( (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
794: nvl(p_form_canvas_id,hr_api.g_number))
795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
796: nvl(p_form_tab_page_id,hr_api.g_number))
797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>
798: nvl(p_form_tab_page_id_override,hr_api.g_number))))
799: or (NOT l_api_updating)) then
800: --
801: hr_utility.set_location(l_proc,30);

Line 798: nvl(p_form_tab_page_id_override,hr_api.g_number))))

794: nvl(p_form_canvas_id,hr_api.g_number))
795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
796: nvl(p_form_tab_page_id,hr_api.g_number))
797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>
798: nvl(p_form_tab_page_id_override,hr_api.g_number))))
799: or (NOT l_api_updating)) then
800: --
801: hr_utility.set_location(l_proc,30);
802: --

Line 821: if nvl(l_canvas_type,hr_api.g_varchar2) = 'TAB' then

817: --
818: -- Check tab page has been specified for items on tab canvases and the tab
819: -- page references the same canvas as the canvas specified for the item.
820: --
821: if nvl(l_canvas_type,hr_api.g_varchar2) = 'TAB' then
822: --
823: hr_utility.set_location(l_proc,50);
824: --
825: if p_form_tab_page_id is null then

Line 847: if nvl(p_form_canvas_id,hr_api.g_number) <>

843: close csr_form_tab_page;
844: --
845: hr_utility.set_location(l_proc,70);
846: --
847: if nvl(p_form_canvas_id,hr_api.g_number) <>
848: nvl(l_form_canvas_id,hr_api.g_number) then
849: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
850: fnd_message.set_token('PROCEDURE', l_proc);
851: fnd_message.set_token('STEP','40');

Line 848: nvl(l_form_canvas_id,hr_api.g_number) then

844: --
845: hr_utility.set_location(l_proc,70);
846: --
847: if nvl(p_form_canvas_id,hr_api.g_number) <>
848: nvl(l_form_canvas_id,hr_api.g_number) then
849: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
850: fnd_message.set_token('PROCEDURE', l_proc);
851: fnd_message.set_token('STEP','40');
852: fnd_message.raise_error;

Line 874: if p_form_tab_page_id_override <> nvl(p_form_tab_page_id,hr_api.g_number) then

870: -- Check the override tab page is the same as the standard tab page if
871: -- specified
872: --
873: if p_form_tab_page_id_override is not null then
874: if p_form_tab_page_id_override <> nvl(p_form_tab_page_id,hr_api.g_number) then
875: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
876: fnd_message.set_token('PROCEDURE', l_proc);
877: fnd_message.set_token('STEP','60');
878: fnd_message.raise_error;