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

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

64: --
65: -- end of cursor
66: --
67: begin
68: hr_utility.set_location('Entering:'|| l_proc, 10);
69: --
70: -- Issue a savepoint
71: --
72: savepoint Create_Period_frequency;

Line 90: hr_utility.set_location('Before Calling User Hook Create_period_Frequency_b',20);

86: --
87: -- Call Before Process User Hook
88: --
89: begin
90: hr_utility.set_location('Before Calling User Hook Create_period_Frequency_b',20);
91: PSP_Period_frequency_BK1.Create_Period_frequency_b
92: ( p_start_date => p_start_date
93: ,p_unit_of_measure => p_unit_of_measure
94: ,p_period_duration => p_period_duration

Line 98: hr_utility.set_location('After Calling User Hook Create_period_Frequency_b',25);

94: ,p_period_duration => p_period_duration
95: ,p_report_type => p_report_type
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'

Line 178: hr_utility.set_location(' Leaving:'||l_proc, 80);

174: -- when validation only mode is being used.)
175: p_period_frequency_id := null;
176: p_object_version_number := null;
177: p_api_warning := l_api_warning;
178: hr_utility.set_location(' Leaving:'||l_proc, 80);
179: when others then
180: --
181: -- A validation or unexpected error has occured
182: --

Line 190: hr_utility.set_location('error is : '||SQLERRM,85);

186: -- OUT parameters, including warnings, to null
187: p_period_frequency_id := null;
188: p_object_version_number := null;
189: p_api_warning := l_api_warning;
190: hr_utility.set_location('error is : '||SQLERRM,85);
191: hr_utility.set_location(' Leaving:'||l_proc, 90);
192: end Create_Period_frequency;
193: --
194: -- -------------------------------------------------------------------------------

Line 191: hr_utility.set_location(' Leaving:'||l_proc, 90);

187: p_period_frequency_id := null;
188: p_object_version_number := null;
189: p_api_warning := l_api_warning;
190: hr_utility.set_location('error is : '||SQLERRM,85);
191: hr_utility.set_location(' Leaving:'||l_proc, 90);
192: end Create_Period_frequency;
193: --
194: -- -------------------------------------------------------------------------------
195: -- |--------------------------< Update_Period_Frequency >--------------------------|

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

210: l_api_warning varchar2(250);
211: l_object_version_number psp_report_period_frequency_b.object_version_number%TYPE;
212: l_language_code varchar2(30);
213: begin
214: hr_utility.set_location('Entering:'|| l_proc, 10);
215: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
216: -- Issue a savepoint
217: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
218: savepoint Update_Period_Frequency ;

Line 225: hr_utility.set_location('Before Calling User Hook Update_Period_Frequency_b',20);

221: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
222: -- Call Before Process User Hook
223: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
224: begin
225: hr_utility.set_location('Before Calling User Hook Update_Period_Frequency_b',20);
226: PSP_Period_frequency_BK2.Update_Period_Frequency_b
227: ( p_start_date => p_start_date
228: ,p_unit_of_measure => p_unit_of_measure
229: ,p_period_duration => p_period_duration

Line 235: hr_utility.set_location('After Calling User Hook Update_Period_Frequency_b',20);

231: ,p_period_frequency => p_period_frequency
232: ,p_period_frequency_id => p_period_frequency_id
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

Line 238: hr_utility.set_location('Exception in User Hook Update_Period_Frequency_b',25);

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'
242: );

Line 250: hr_utility.set_location('Before calling row-handler psp_pfb_upd.upd',30);

246: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
247: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
248: -- Process Logic - Call the row-handler ins procedure
249: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
250: hr_utility.set_location('Before calling row-handler psp_pfb_upd.upd',30);
251: psp_pfb_upd.upd
252: (p_period_frequency_id => p_period_frequency_id
253: ,p_object_version_number => l_object_version_number
254: ,p_start_date => p_start_date

Line 269: hr_utility.set_location(' Before Calling User Hook : Update_Period_Frequency_a',20);

265: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
266: -- Call After Process User Hook
267: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
268: begin
269: hr_utility.set_location(' Before Calling User Hook : Update_Period_Frequency_a',20);
270: PSP_Period_Frequency_Bk2.Update_Period_Frequency_a
271: (p_start_date => p_start_date
272: ,p_unit_of_measure => p_unit_of_measure
273: ,p_period_duration => p_period_duration

Line 280: hr_utility.set_location(' After Calling User Hook :Update_Period_Frequency_a',20);

276: ,p_period_frequency_id => p_period_frequency_id
277: ,p_object_version_number => l_object_version_number
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

Line 283: hr_utility.set_location('Exception in User Hook :Update_Period_Frequency_a',25);

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'
287: );

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

296: -- Set all output arguments
297: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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

Line 314: hr_utility.set_location(' Leaving:'||l_proc, 80);

310: -- (Any key or derived arguments must be set to null
311: -- when validation only mode is being used.)
312: --
313: p_api_warning := l_api_warning;
314: hr_utility.set_location(' Leaving:'||l_proc, 80);
315: When Others Then
316: --
317: -- A validation or unexpected error has occured
318: --

Line 320: hr_utility.set_location(' Leaving:'||l_proc, 90);

316: --
317: -- A validation or unexpected error has occured
318: --
319: Rollback to Update_Period_Frequency;
320: hr_utility.set_location(' Leaving:'||l_proc, 90);
321: Raise;
322: End Update_Period_Frequency ;
323: --
324: -- -------------------------------------------------------------------------------

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

333: l_proc varchar2(150) := g_package||'Delete_Period_Frequency';
334: l_object_version_number psp_report_period_frequency_b.object_version_number%TYPE;
335: l_api_warning varchar2(250);
336: begin
337: hr_utility.set_location('Entering:'|| l_proc, 10);
338: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
339: -- Issue a savepoint
340: savepoint Delete_Period_Frequency;
341:

Line 347: hr_utility.set_location('Before Calling User Hook Delete_Period_Frequency_b',20);

343:
344: l_object_version_number := p_object_version_number;
345: -- Call Before Process User Hook
346: Begin
347: hr_utility.set_location('Before Calling User Hook Delete_Period_Frequency_b',20);
348: PSP_Period_frequency_BK3.Delete_Period_Frequency_b
349: ( p_period_frequency_id => p_period_frequency_id
350: ,p_object_version_number => l_object_version_number
351: );

Line 352: hr_utility.set_location('After Calling User Hook Delete_Period_Frequency_b',20);

348: PSP_Period_frequency_BK3.Delete_Period_Frequency_b
349: ( p_period_frequency_id => p_period_frequency_id
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

Line 355: hr_utility.set_location('Exception in User Hook Delete_Period_Frequency_b',25);

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'
359: );

Line 365: hr_utility.set_location('Before calling row-handler psp_pft_del.del_tl',30);

361: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
362: -- Process Logic - Call the row-handler del procedure
363: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
364: -- call the procedure to delete from the _tl table
365: hr_utility.set_location('Before calling row-handler psp_pft_del.del_tl',30);
366: psp_pft_del.del_tl( p_period_frequency_id => p_period_frequency_id) ;
367: -- call the procedure to delete from the Base table
368:
369: hr_utility.set_location('Before calling row-handler psp_pft_del.del',35);

Line 369: hr_utility.set_location('Before calling row-handler psp_pft_del.del',35);

365: hr_utility.set_location('Before calling row-handler psp_pft_del.del_tl',30);
366: psp_pft_del.del_tl( p_period_frequency_id => p_period_frequency_id) ;
367: -- call the procedure to delete from the Base table
368:
369: hr_utility.set_location('Before calling row-handler psp_pft_del.del',35);
370: psp_pfb_del.del
371: ( p_period_frequency_id => p_period_frequency_id
372: ,p_object_version_number => l_object_version_number) ;
373: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 377: hr_utility.set_location('Before Calling User Hook Delete_Period_Frequency_a',20);

373: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
374: -- Call After Process User Hook
375: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
376: Begin
377: hr_utility.set_location('Before Calling User Hook Delete_Period_Frequency_a',20);
378: PSP_Period_frequency_BK3.Delete_Period_Frequency_a
379: (p_period_frequency_id => p_period_frequency_id
380: ,p_object_version_number => l_object_version_number
381: ,p_api_warning => l_api_warning

Line 383: hr_utility.set_location('After Calling User Hook Delete_Period_Frequency_a',20);

379: (p_period_frequency_id => p_period_frequency_id
380: ,p_object_version_number => l_object_version_number
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

Line 386: hr_utility.set_location('Exception in User Hook Delete_Period_Frequency_a',25);

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'
390: );

Line 402: hr_utility.set_location(' Leaving:'||l_proc, 70);

398: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
399: -- Set all output arguments
400: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
401: p_object_version_number := l_object_version_number;
402: hr_utility.set_location(' Leaving:'||l_proc, 70);
403: Exception
404: when dup_data then
405: fnd_message.set_name('PSP','PSP_DUP_PERIOD_FREQUENCY');
406: fnd_message.raise_error;

Line 418: hr_utility.set_location(' Leaving:'||l_proc, 80);

414: -- Only set output warning arguments
415: -- (Any key or derived arguments must be set to null
416: -- when validation only mode is being used.)
417: --
418: hr_utility.set_location(' Leaving:'||l_proc, 80);
419: When Others Then
420: --
421: -- A validation or unexpected error has occured
422: --

Line 424: hr_utility.set_location(' Leaving:'||l_proc, 90);

420: --
421: -- A validation or unexpected error has occured
422: --
423: Rollback to Delete_Period_Frequency;
424: hr_utility.set_location(' Leaving:'||l_proc, 90);
425: Raise;
426: End Delete_Period_Frequency;
427: end PSP_Period_frequency_API;