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

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

39: ) IS
40: --
41: l_proc varchar2(72) := g_package || 'CHK_NAME';
42: Begin
43: hr_utility.set_location('Entering:'||l_proc,10);
44: hr_api.mandatory_arg_error(p_api_name => l_proc
45: ,p_argument => 'NAME'
46: ,p_argument_value => p_name
47: );

Line 48: hr_utility.set_location(' Leaving:'||l_proc,30);

44: hr_api.mandatory_arg_error(p_api_name => l_proc
45: ,p_argument => 'NAME'
46: ,p_argument_value => p_name
47: );
48: hr_utility.set_location(' Leaving:'||l_proc,30);
49: exception
50: when app_exception.application_exception then
51: if hr_multi_message.exception_add
52: (p_associated_column1 => 'AME_APPROVAL_GROUPS.NAME'

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

50: when app_exception.application_exception then
51: if hr_multi_message.exception_add
52: (p_associated_column1 => 'AME_APPROVAL_GROUPS.NAME'
53: ) then
54: hr_utility.set_location(' Leaving:'||l_proc, 40);
55: raise;
56: end if;
57: hr_utility.set_location( ' Leaving:'||l_proc,50 );
58: End chk_name;

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

53: ) then
54: hr_utility.set_location(' Leaving:'||l_proc, 40);
55: raise;
56: end if;
57: hr_utility.set_location( ' Leaving:'||l_proc,50 );
58: End chk_name;
59:
60: procedure chk_delete(p_approval_group_id in number
61: ,p_effective_date in date) is

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

69: and approval_group_id = p_approval_group_id
70: and p_effective_date between start_date and
71: nvl(end_date -(1/86400), p_effective_date);
72: begin
73: hr_utility.set_location('Entering:'||l_proc,10);
74: --+
75: hr_utility.set_location(' Leaving:'||l_proc,30);
76: exception
77: when app_exception.application_exception then

Line 75: hr_utility.set_location(' Leaving:'||l_proc,30);

71: nvl(end_date -(1/86400), p_effective_date);
72: begin
73: hr_utility.set_location('Entering:'||l_proc,10);
74: --+
75: hr_utility.set_location(' Leaving:'||l_proc,30);
76: exception
77: when app_exception.application_exception then
78: if hr_multi_message.exception_add
79: (p_associated_column1 => 'AME_APPROVAL_GROUPS.DELETE'

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

77: when app_exception.application_exception then
78: if hr_multi_message.exception_add
79: (p_associated_column1 => 'AME_APPROVAL_GROUPS.DELETE'
80: ) then
81: hr_utility.set_location(' Leaving:'||l_proc, 40);
82: raise;
83: end if;
84: hr_utility.set_location( ' Leaving:'||l_proc,50 );
85: end chk_delete;

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

80: ) then
81: hr_utility.set_location(' Leaving:'||l_proc, 40);
82: raise;
83: end if;
84: hr_utility.set_location( ' Leaving:'||l_proc,50 );
85: end chk_delete;
86: -- ----------------------------------------------------------------------------
87: -- |-------------------------< CHK_UNIQUE >---------------------------|
88: -- ----------------------------------------------------------------------------

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

124: where t.name = p_name
125: and p_effective_date between t.start_date and t.end_date;
126:
127: Begin
128: hr_utility.set_location('Entering:'||l_proc,10);
129: -- Check if the name is already in use by another approval group
130: open C_Sel1;
131: fetch C_Sel1 into l_count;
132: close C_Sel1;

Line 137: hr_utility.set_location(' Leaving:'||l_proc,30);

133: if l_count <> 0 then
134: fnd_message.set_name('PER','AME_400561_APG_NAME_NOT_UNQ');
135: fnd_message.raise_error;
136: end if;
137: hr_utility.set_location(' Leaving:'||l_proc,30);
138: exception
139: when app_exception.application_exception then
140: if hr_multi_message.exception_add
141: (p_associated_column1 => 'AME_APPROVAL_GROUPS.NAME'

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

139: when app_exception.application_exception then
140: if hr_multi_message.exception_add
141: (p_associated_column1 => 'AME_APPROVAL_GROUPS.NAME'
142: ) then
143: hr_utility.set_location(' Leaving:'||l_proc, 40);
144: raise;
145: end if;
146: hr_utility.set_location( ' Leaving:'||l_proc,50 );
147: End chk_unique;

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

142: ) then
143: hr_utility.set_location(' Leaving:'||l_proc, 40);
144: raise;
145: end if;
146: hr_utility.set_location( ' Leaving:'||l_proc,50 );
147: End chk_unique;
148:
149: -- ----------------------------------------------------------------------------
150: -- |-------------------------< CHK_IS_STATIC >---------------------------|

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

177: l_proc varchar2(72) := g_package || 'CHK_IS_STATIC';
178: --
179:
180: Begin
181: hr_utility.set_location('Entering:'||l_proc,10);
182: hr_api.mandatory_arg_error(p_api_name => l_proc
183: ,p_argument => 'IS_STATIC'
184: ,p_argument_value => p_is_static
185: );

Line 190: hr_utility.set_location(' Leaving:'||l_proc,30);

186: if p_is_static not in('Y','N') then
187: fnd_message.set_name('PER','AME_400562_APG_INVALID_USG_TYP');
188: fnd_message.raise_error;
189: end if;
190: hr_utility.set_location(' Leaving:'||l_proc,30);
191: exception
192: when app_exception.application_exception then
193: if hr_multi_message.exception_add
194: (p_associated_column1 => 'AME_APPROVAL_GROUPS.IS_STATIC'

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

192: when app_exception.application_exception then
193: if hr_multi_message.exception_add
194: (p_associated_column1 => 'AME_APPROVAL_GROUPS.IS_STATIC'
195: ) then
196: hr_utility.set_location(' Leaving:'||l_proc, 40);
197: raise;
198: end if;
199: hr_utility.set_location( ' Leaving:'||l_proc,50 );
200: End chk_is_static;

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

195: ) then
196: hr_utility.set_location(' Leaving:'||l_proc, 40);
197: raise;
198: end if;
199: hr_utility.set_location( ' Leaving:'||l_proc,50 );
200: End chk_is_static;
201:
202:
203: -- ----------------------------------------------------------------------------

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

240: l_valid varchar2(1000);
241: --
242:
243: Begin
244: hr_utility.set_location('Entering:'||l_proc,10);
245: if (p_is_static = 'Y' and p_query_string is not null) then
246: fnd_message.set_name('PER','AME_400563_APG_INV_USG_QRY_CMB');
247: fnd_message.raise_error;
248: end if;

Line 294: hr_utility.set_location(' Leaving:'||l_proc,30);

290: if l_valid <> 'Y' then
291: fnd_message.raise_error;
292: end if;
293: end if;
294: hr_utility.set_location(' Leaving:'||l_proc,30);
295: exception
296: when app_exception.application_exception then
297: if hr_multi_message.exception_add
298: (p_associated_column1 => 'AME_APPROVAL_GROUPS.QUERY_STRING'

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

296: when app_exception.application_exception then
297: if hr_multi_message.exception_add
298: (p_associated_column1 => 'AME_APPROVAL_GROUPS.QUERY_STRING'
299: ) then
300: hr_utility.set_location(' Leaving:'||l_proc, 40);
301: raise;
302: end if;
303: hr_utility.set_location( ' Leaving:'||l_proc,50 );
304: End chk_query_string;

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

299: ) then
300: hr_utility.set_location(' Leaving:'||l_proc, 40);
301: raise;
302: end if;
303: hr_utility.set_location( ' Leaving:'||l_proc,50 );
304: End chk_query_string;
305:
306:
307: -- ----------------------------------------------------------------------------

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

612: --
613: l_proc varchar2(72) := g_package||'insert_validate';
614: --
615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: -- Validate Dependent Attributes
619: --
620: --

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

637: p_is_static => p_rec.is_static
638: ,p_query_string => p_rec.query_string
639: );
640:
641: hr_utility.set_location(' Leaving:'||l_proc, 10);
642: End insert_validate;
643: --
644: -- ----------------------------------------------------------------------------
645: -- |---------------------------< update_validate >----------------------------|

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

654: --
655: l_proc varchar2(72) := g_package||'update_validate';
656: --
657: Begin
658: hr_utility.set_location('Entering:'||l_proc, 5);
659: --
660: -- Validate Dependent Attributes
661: --
662: -- Call the datetrack update integrity operation

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

697: p_is_static => p_rec.is_static
698: ,p_query_string => p_rec.query_string
699: );
700:
701: hr_utility.set_location(' Leaving:'||l_proc, 10);
702: End update_validate;
703: --
704: -- ----------------------------------------------------------------------------
705: -- |---------------------------< delete_validate >----------------------------|

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

714: --
715: l_proc varchar2(72) := g_package||'delete_validate';
716: --
717: Begin
718: hr_utility.set_location('Entering:'||l_proc, 5);
719: --
720: -- Call all supporting business operations
721: --
722: dt_delete_validate

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

727: );
728: chk_delete(p_approval_group_id => p_rec.approval_group_id
729: ,p_effective_date => p_effective_date);
730: --
731: hr_utility.set_location(' Leaving:'||l_proc, 10);
732: End delete_validate;
733: --
734: end ame_apg_bus;