DBA Data[Home] [Help]

APPS.PSP_PERIOD_FREQUENCY_API dependencies on HR_API

Line 44: ,p_language_code in varchar2 default hr_api.userenv_lang

40: ,p_unit_of_measure in varchar2
41: ,p_period_duration in number
42: ,p_report_type in varchar2 default null
43: ,p_period_frequency in varchar2
44: ,p_language_code in varchar2 default hr_api.userenv_lang
45: ,p_period_frequency_id out nocopy number
46: ,p_object_version_number out nocopy number
47: ,p_api_warning out nocopy varchar2
48: ) is

Line 78: hr_api.validate_language_code(p_language_code => l_language_code);

74: -- Validate the language parameter. l_language_code should be passed
75: -- instead of p_language_code from now on, to allow an IN OUT parameter to
76: -- be passed through.
77: --
78: hr_api.validate_language_code(p_language_code => l_language_code);
79: --
80: open c_period_frequency;
81: fetch c_period_frequency into l_period_frequency_name;
82: close c_period_frequency;

Line 100: when hr_api.cannot_find_prog_unit then

96: ,p_period_frequency => p_period_frequency
97: );
98: hr_utility.set_location('After Calling User Hook Create_period_Frequency_b',25);
99: exception
100: when hr_api.cannot_find_prog_unit then
101: hr_api.cannot_find_prog_unit_error
102: (p_module_name => 'CREATE_PERIOD_FREQUENCY'
103: ,p_hook_type => 'BP'
104: );

Line 101: hr_api.cannot_find_prog_unit_error

97: );
98: hr_utility.set_location('After Calling User Hook Create_period_Frequency_b',25);
99: exception
100: when hr_api.cannot_find_prog_unit then
101: hr_api.cannot_find_prog_unit_error
102: (p_module_name => 'CREATE_PERIOD_FREQUENCY'
103: ,p_hook_type => 'BP'
104: );
105: end;

Line 142: when hr_api.cannot_find_prog_unit then

138: ,p_object_version_number => l_object_version_number
139: ,p_api_warning => l_api_warning
140: );
141: exception
142: when hr_api.cannot_find_prog_unit then
143: hr_api.cannot_find_prog_unit_error
144: (p_module_name => 'CREATE_PERIOD_FREQUENCY'
145: ,p_hook_type => 'AP'
146: );

Line 143: hr_api.cannot_find_prog_unit_error

139: ,p_api_warning => l_api_warning
140: );
141: exception
142: when hr_api.cannot_find_prog_unit then
143: hr_api.cannot_find_prog_unit_error
144: (p_module_name => 'CREATE_PERIOD_FREQUENCY'
145: ,p_hook_type => 'AP'
146: );
147: end;

Line 152: raise hr_api.validate_enabled;

148: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
149: -- When in validation only mode raise the Validate_Enabled exception
150: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
151: If p_validate Then
152: raise hr_api.validate_enabled;
153: End If;
154: --
155: -- Set all IN OUT and OUT parameters with out values
156: --

Line 165: when hr_api.validate_enabled then

161: when dup_data then
162: fnd_message.set_name('PSP','PSP_DUP_PERIOD_FREQUENCY');
163: fnd_message.set_token('PERIODFREQUENCY',p_period_frequency);
164: fnd_message.raise_error;
165: when hr_api.validate_enabled then
166: --
167: -- As the Validate_Enabled exception has been raised
168: -- we must rollback to the savepoint
169: --

Line 203: ,p_language_code in varchar2 default hr_api.userenv_lang

199: ,p_start_date in date
200: ,p_unit_of_measure in varchar2
201: ,p_period_duration in number
202: ,p_report_type in varchar2 default null
203: ,p_language_code in varchar2 default hr_api.userenv_lang
204: ,p_period_frequency in varchar2
205: ,p_period_frequency_id in number
206: ,p_object_version_number in out nocopy number
207: ,p_api_warning out nocopy varchar2

Line 237: when hr_api.cannot_find_prog_unit then

233: ,p_object_version_number => l_object_version_number
234: );
235: hr_utility.set_location('After Calling User Hook Update_Period_Frequency_b',20);
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_utility.set_location('Exception in User Hook Update_Period_Frequency_b',25);
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'Update_Period_Frequency'
241: ,p_hook_type => 'BP'

Line 239: hr_api.cannot_find_prog_unit_error

235: hr_utility.set_location('After Calling User Hook Update_Period_Frequency_b',20);
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_utility.set_location('Exception in User Hook Update_Period_Frequency_b',25);
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'Update_Period_Frequency'
241: ,p_hook_type => 'BP'
242: );
243: end;

Line 282: When hr_api.cannot_find_prog_unit Then

278: ,p_api_warning => l_api_warning
279: );
280: hr_utility.set_location(' After Calling User Hook :Update_Period_Frequency_a',20);
281: exception
282: When hr_api.cannot_find_prog_unit Then
283: hr_utility.set_location('Exception in User Hook :Update_Period_Frequency_a',25);
284: hr_api.cannot_find_prog_unit_error
285: (p_module_name => 'Update_Period_Frequency'
286: ,p_hook_type => 'AP'

Line 284: hr_api.cannot_find_prog_unit_error

280: hr_utility.set_location(' After Calling User Hook :Update_Period_Frequency_a',20);
281: exception
282: When hr_api.cannot_find_prog_unit Then
283: hr_utility.set_location('Exception in User Hook :Update_Period_Frequency_a',25);
284: hr_api.cannot_find_prog_unit_error
285: (p_module_name => 'Update_Period_Frequency'
286: ,p_hook_type => 'AP'
287: );
288: end;

Line 293: raise hr_api.validate_enabled;

289: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
290: -- When in validation only mode raise the Validate_Enabled exception
291: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
292: If p_validate Then
293: raise hr_api.validate_enabled;
294: End If;
295: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
296: -- Set all output arguments
297: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 302: When hr_api.validate_enabled Then

298: p_object_version_number := l_object_version_number;
299: p_api_warning := l_api_warning;
300: hr_utility.set_location(' Leaving:'||l_proc, 70);
301: Exception
302: When hr_api.validate_enabled Then
303: --
304: -- As the Validate_Enabled exception has been raised
305: -- we must rollback to the savepoint
306: --

Line 354: When hr_api.cannot_find_prog_unit Then

350: ,p_object_version_number => l_object_version_number
351: );
352: hr_utility.set_location('After Calling User Hook Delete_Period_Frequency_b',20);
353: Exception
354: When hr_api.cannot_find_prog_unit Then
355: hr_utility.set_location('Exception in User Hook Delete_Period_Frequency_b',25);
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'Delete_Period_Frequency'
358: ,p_hook_type => 'BP'

Line 356: hr_api.cannot_find_prog_unit_error

352: hr_utility.set_location('After Calling User Hook Delete_Period_Frequency_b',20);
353: Exception
354: When hr_api.cannot_find_prog_unit Then
355: hr_utility.set_location('Exception in User Hook Delete_Period_Frequency_b',25);
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'Delete_Period_Frequency'
358: ,p_hook_type => 'BP'
359: );
360: End;

Line 385: When hr_api.cannot_find_prog_unit Then

381: ,p_api_warning => l_api_warning
382: );
383: hr_utility.set_location('After Calling User Hook Delete_Period_Frequency_a',20);
384: Exception
385: When hr_api.cannot_find_prog_unit Then
386: hr_utility.set_location('Exception in User Hook Delete_Period_Frequency_a',25);
387: hr_api.cannot_find_prog_unit_error
388: (p_module_name => 'Delete_Period_Frequency'
389: ,p_hook_type => 'AP'

Line 387: hr_api.cannot_find_prog_unit_error

383: hr_utility.set_location('After Calling User Hook Delete_Period_Frequency_a',20);
384: Exception
385: When hr_api.cannot_find_prog_unit Then
386: hr_utility.set_location('Exception in User Hook Delete_Period_Frequency_a',25);
387: hr_api.cannot_find_prog_unit_error
388: (p_module_name => 'Delete_Period_Frequency'
389: ,p_hook_type => 'AP'
390: );
391: End;

Line 396: raise hr_api.validate_enabled;

392: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
393: -- When in validation only mode raise the Validate_Enabled exception
394: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
395: If p_validate Then
396: raise hr_api.validate_enabled;
397: End If;
398: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
399: -- Set all output arguments
400: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 407: When hr_api.validate_enabled Then

403: Exception
404: when dup_data then
405: fnd_message.set_name('PSP','PSP_DUP_PERIOD_FREQUENCY');
406: fnd_message.raise_error;
407: When hr_api.validate_enabled Then
408: --
409: -- As the Validate_Enabled exception has been raised
410: -- we must rollback to the savepoint
411: --