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

Line 54: -- 115.1 28-JAN-2004 sshankar Removed hr_utility.debug_enabled call--

50: --------------------------------------------------------------------------
51: -- Rev# Date Userid Description --
52: --------------------------------------------------------------------------
53: -- 115.0 22-JAN-2004 sshankar Initial Version --
54: -- 115.1 28-JAN-2004 sshankar Removed hr_utility.debug_enabled call--
55: --------------------------------------------------------------------------
56: --
57: PROCEDURE submit_sscwt_report
58: IS

Line 67: hr_utility.set_location('Entering ' ||l_procedure, 10);

63: --
64:
65: IF g_debug THEN
66: l_procedure := g_package||'submit_sscwt_report';
67: hr_utility.set_location('Entering ' ||l_procedure, 10);
68: hr_utility.trace('Report Name -> ' || g_report_short_name);
69: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
70: hr_utility.trace('Financial Year -> ' || g_financial_year);
71: hr_utility.trace('Processing Mode -> ' || g_processing_mode);

Line 68: hr_utility.trace('Report Name -> ' || g_report_short_name);

64:
65: IF g_debug THEN
66: l_procedure := g_package||'submit_sscwt_report';
67: hr_utility.set_location('Entering ' ||l_procedure, 10);
68: hr_utility.trace('Report Name -> ' || g_report_short_name);
69: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
70: hr_utility.trace('Financial Year -> ' || g_financial_year);
71: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
72: hr_utility.trace('Archive ID -> ' || g_archive_pact);

Line 69: hr_utility.trace('Business Group ID -> ' || g_business_group_id);

65: IF g_debug THEN
66: l_procedure := g_package||'submit_sscwt_report';
67: hr_utility.set_location('Entering ' ||l_procedure, 10);
68: hr_utility.trace('Report Name -> ' || g_report_short_name);
69: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
70: hr_utility.trace('Financial Year -> ' || g_financial_year);
71: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
72: hr_utility.trace('Archive ID -> ' || g_archive_pact);
73: hr_utility.trace('Payroll ID -> ' || g_payroll_id);

Line 70: hr_utility.trace('Financial Year -> ' || g_financial_year);

66: l_procedure := g_package||'submit_sscwt_report';
67: hr_utility.set_location('Entering ' ||l_procedure, 10);
68: hr_utility.trace('Report Name -> ' || g_report_short_name);
69: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
70: hr_utility.trace('Financial Year -> ' || g_financial_year);
71: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
72: hr_utility.trace('Archive ID -> ' || g_archive_pact);
73: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
74: hr_utility.trace('Assignment Set ID -> ' || g_assignment_set_id);

Line 71: hr_utility.trace('Processing Mode -> ' || g_processing_mode);

67: hr_utility.set_location('Entering ' ||l_procedure, 10);
68: hr_utility.trace('Report Name -> ' || g_report_short_name);
69: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
70: hr_utility.trace('Financial Year -> ' || g_financial_year);
71: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
72: hr_utility.trace('Archive ID -> ' || g_archive_pact);
73: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
74: hr_utility.trace('Assignment Set ID -> ' || g_assignment_set_id);
75: END IF;

Line 72: hr_utility.trace('Archive ID -> ' || g_archive_pact);

68: hr_utility.trace('Report Name -> ' || g_report_short_name);
69: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
70: hr_utility.trace('Financial Year -> ' || g_financial_year);
71: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
72: hr_utility.trace('Archive ID -> ' || g_archive_pact);
73: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
74: hr_utility.trace('Assignment Set ID -> ' || g_assignment_set_id);
75: END IF;
76:

Line 73: hr_utility.trace('Payroll ID -> ' || g_payroll_id);

69: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
70: hr_utility.trace('Financial Year -> ' || g_financial_year);
71: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
72: hr_utility.trace('Archive ID -> ' || g_archive_pact);
73: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
74: hr_utility.trace('Assignment Set ID -> ' || g_assignment_set_id);
75: END IF;
76:
77: --

Line 74: hr_utility.trace('Assignment Set ID -> ' || g_assignment_set_id);

70: hr_utility.trace('Financial Year -> ' || g_financial_year);
71: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
72: hr_utility.trace('Archive ID -> ' || g_archive_pact);
73: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
74: hr_utility.trace('Assignment Set ID -> ' || g_assignment_set_id);
75: END IF;
76:
77: --
78: -- Submit the SSCWT text report using fnd_request.submit_request

Line 95: hr_utility.set_location('Error submitting report', 20);

91: --
92: -- If the request is not submitted, then error out.
93: --
94: IF l_request_id = 0 THEN
95: hr_utility.set_location('Error submitting report', 20);
96: hr_utility.raise_error;
97: END IF;
98: --
99: IF g_debug THEN

Line 96: hr_utility.raise_error;

92: -- If the request is not submitted, then error out.
93: --
94: IF l_request_id = 0 THEN
95: hr_utility.set_location('Error submitting report', 20);
96: hr_utility.raise_error;
97: END IF;
98: --
99: IF g_debug THEN
100: hr_utility.set_location('Leaving '||l_procedure,30);

Line 100: hr_utility.set_location('Leaving '||l_procedure,30);

96: hr_utility.raise_error;
97: END IF;
98: --
99: IF g_debug THEN
100: hr_utility.set_location('Leaving '||l_procedure,30);
101: END IF;
102: --
103: EXCEPTION
104: WHEN OTHERS THEN

Line 106: hr_utility.set_location('Error in ' ||l_procedure, 40);

102: --
103: EXCEPTION
104: WHEN OTHERS THEN
105: IF g_debug THEN
106: hr_utility.set_location('Error in ' ||l_procedure, 40);
107: END IF;
108: RAISE;
109:
110: END submit_sscwt_report;

Line 133: -- 115.1 28-JAN-2004 sshankar Removed hr_utility.debug_enabled call--

129: --------------------------------------------------------------------------
130: -- Rev# Date Userid Description --
131: --------------------------------------------------------------------------
132: -- 115.0 22-JAN-2004 sshankar Initial Version --
133: -- 115.1 28-JAN-2004 sshankar Removed hr_utility.debug_enabled call--
134: -- Removed using l_update_change_insert --
135: -- as update mode. --
136: --------------------------------------------------------------------------
137: --

Line 175: hr_utility.set_location('Entering '||l_procedure, 10);

171: --
172:
173: IF g_debug THEN
174: l_procedure := g_package || 'update_sscwt_rate';
175: hr_utility.set_location('Entering '||l_procedure, 10);
176: hr_utility.trace('SSCWT Rate -> ' || p_sscwt_rate);
177: hr_utility.trace('Element Entry ID -> ' || p_sscwt_element_entry_id);
178: END IF;
179: --

Line 176: hr_utility.trace('SSCWT Rate -> ' || p_sscwt_rate);

172:
173: IF g_debug THEN
174: l_procedure := g_package || 'update_sscwt_rate';
175: hr_utility.set_location('Entering '||l_procedure, 10);
176: hr_utility.trace('SSCWT Rate -> ' || p_sscwt_rate);
177: hr_utility.trace('Element Entry ID -> ' || p_sscwt_element_entry_id);
178: END IF;
179: --
180: --

Line 177: hr_utility.trace('Element Entry ID -> ' || p_sscwt_element_entry_id);

173: IF g_debug THEN
174: l_procedure := g_package || 'update_sscwt_rate';
175: hr_utility.set_location('Entering '||l_procedure, 10);
176: hr_utility.trace('SSCWT Rate -> ' || p_sscwt_rate);
177: hr_utility.trace('Element Entry ID -> ' || p_sscwt_element_entry_id);
178: END IF;
179: --
180: --
181: -- Determine the update mode to be used in element entry value updation.

Line 197: hr_utility.set_location('After calling DT_Api.Find_DT_Upd_MOdes', 20);

193: ,p_update_change_insert=> l_update_change_insert);
194: --
195:
196: IF g_debug THEN
197: hr_utility.set_location('After calling DT_Api.Find_DT_Upd_MOdes', 20);
198: END IF;
199: --
200: --
201: -- Check which flag has been set by DT_API.Find_DT_Upd_Modes

Line 222: hr_utility.set_location('Update Mode -> ' || l_update_mode, 30);

218: return FALSE;
219: END IF;
220: --
221: IF g_debug THEN
222: hr_utility.set_location('Update Mode -> ' || l_update_mode, 30);
223: END IF;
224: --
225: OPEN csr_get_object_version;
226: FETCH csr_get_object_version INTO l_object_version_number;

Line 230: hr_utility.set_location('Object Version Number -> ' || l_object_version_number, 40);

226: FETCH csr_get_object_version INTO l_object_version_number;
227: CLOSE csr_get_object_version;
228: --
229: IF g_debug THEN
230: hr_utility.set_location('Object Version Number -> ' || l_object_version_number, 40);
231: END IF;
232: --
233: --
234: IF g_debug THEN

Line 235: hr_utility.set_location('G_Input Value ID -> ' || g_input_value_id, 50);

231: END IF;
232: --
233: --
234: IF g_debug THEN
235: hr_utility.set_location('G_Input Value ID -> ' || g_input_value_id, 50);
236: END IF;
237: --
238: pay_element_entry_api.update_element_entry
239: (p_datetrack_update_mode => l_update_mode

Line 252: hr_utility.set_location('After calling update_element_entry ', 60);

248: ,p_update_warning => l_warning);
249: --
250:
251: IF g_debug THEN
252: hr_utility.set_location('After calling update_element_entry ', 60);
253: hr_utility.trace('Effective Start -> '||l_effective_start_date);
254: hr_utility.trace('Effective End -> ' ||l_effective_end_date);
255:
256: END IF;

Line 253: hr_utility.trace('Effective Start -> '||l_effective_start_date);

249: --
250:
251: IF g_debug THEN
252: hr_utility.set_location('After calling update_element_entry ', 60);
253: hr_utility.trace('Effective Start -> '||l_effective_start_date);
254: hr_utility.trace('Effective End -> ' ||l_effective_end_date);
255:
256: END IF;
257: --

Line 254: hr_utility.trace('Effective End -> ' ||l_effective_end_date);

250:
251: IF g_debug THEN
252: hr_utility.set_location('After calling update_element_entry ', 60);
253: hr_utility.trace('Effective Start -> '||l_effective_start_date);
254: hr_utility.trace('Effective End -> ' ||l_effective_end_date);
255:
256: END IF;
257: --
258: RETURN true;

Line 263: hr_utility.set_location('Error in '|| l_procedure, 70);

259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: IF g_debug THEN
263: hr_utility.set_location('Error in '|| l_procedure, 70);
264: END IF;
265: RETURN false;
266: END update_sscwt_rate;
267:

Line 288: -- 115.1 28-JAN-2004 sshankar Removed hr_utility.debug_enabled call--

284: --------------------------------------------------------------------------
285: -- Rev# Date Userid Description --
286: --------------------------------------------------------------------------
287: -- 115.0 22-JAN-2004 sshankar Initial Version --
288: -- 115.1 28-JAN-2004 sshankar Removed hr_utility.debug_enabled call--
289: -- --
290: --------------------------------------------------------------------------
291: --
292:

Line 320: hr_utility.set_location('Entering '||l_procedure, 10);

316: --
317:
318: IF g_debug THEN
319: l_procedure := g_package||'get_legislative_parameters';
320: hr_utility.set_location('Entering '||l_procedure, 10);
321: END IF;
322: --
323: -- Set the global variables
324: --

Line 340: hr_utility.set_location('In '||l_procedure, 20);

336: -- Append 'DD-MM-' part to the Year part obtained from legislative parameters
337: g_financial_year := TO_DATE(g_start_dd_mm || l_financial_year, 'DD-MM-YYYY') ;
338:
339: IF g_debug THEN
340: hr_utility.set_location('In '||l_procedure, 20);
341: hr_utility.trace('Payroll Action ID -> ' || g_archive_pact);
342: hr_utility.trace('G_Financial Year -> ' || g_financial_year);
343: hr_utility.trace('L_Financial Year -> ' || l_financial_year);
344: hr_utility.trace('Processing Mode -> ' || g_processing_mode);

Line 341: hr_utility.trace('Payroll Action ID -> ' || g_archive_pact);

337: g_financial_year := TO_DATE(g_start_dd_mm || l_financial_year, 'DD-MM-YYYY') ;
338:
339: IF g_debug THEN
340: hr_utility.set_location('In '||l_procedure, 20);
341: hr_utility.trace('Payroll Action ID -> ' || g_archive_pact);
342: hr_utility.trace('G_Financial Year -> ' || g_financial_year);
343: hr_utility.trace('L_Financial Year -> ' || l_financial_year);
344: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
345: hr_utility.trace('Payroll ID -> ' || g_payroll_id);

Line 342: hr_utility.trace('G_Financial Year -> ' || g_financial_year);

338:
339: IF g_debug THEN
340: hr_utility.set_location('In '||l_procedure, 20);
341: hr_utility.trace('Payroll Action ID -> ' || g_archive_pact);
342: hr_utility.trace('G_Financial Year -> ' || g_financial_year);
343: hr_utility.trace('L_Financial Year -> ' || l_financial_year);
344: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
345: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
346: hr_utility.trace('Assignment set ID -> ' || g_assignment_set_id);

Line 343: hr_utility.trace('L_Financial Year -> ' || l_financial_year);

339: IF g_debug THEN
340: hr_utility.set_location('In '||l_procedure, 20);
341: hr_utility.trace('Payroll Action ID -> ' || g_archive_pact);
342: hr_utility.trace('G_Financial Year -> ' || g_financial_year);
343: hr_utility.trace('L_Financial Year -> ' || l_financial_year);
344: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
345: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
346: hr_utility.trace('Assignment set ID -> ' || g_assignment_set_id);
347: hr_utility.trace('Business Group ID -> ' || g_business_group_id);

Line 344: hr_utility.trace('Processing Mode -> ' || g_processing_mode);

340: hr_utility.set_location('In '||l_procedure, 20);
341: hr_utility.trace('Payroll Action ID -> ' || g_archive_pact);
342: hr_utility.trace('G_Financial Year -> ' || g_financial_year);
343: hr_utility.trace('L_Financial Year -> ' || l_financial_year);
344: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
345: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
346: hr_utility.trace('Assignment set ID -> ' || g_assignment_set_id);
347: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
348: END IF;

Line 345: hr_utility.trace('Payroll ID -> ' || g_payroll_id);

341: hr_utility.trace('Payroll Action ID -> ' || g_archive_pact);
342: hr_utility.trace('G_Financial Year -> ' || g_financial_year);
343: hr_utility.trace('L_Financial Year -> ' || l_financial_year);
344: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
345: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
346: hr_utility.trace('Assignment set ID -> ' || g_assignment_set_id);
347: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
348: END IF;
349: --

Line 346: hr_utility.trace('Assignment set ID -> ' || g_assignment_set_id);

342: hr_utility.trace('G_Financial Year -> ' || g_financial_year);
343: hr_utility.trace('L_Financial Year -> ' || l_financial_year);
344: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
345: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
346: hr_utility.trace('Assignment set ID -> ' || g_assignment_set_id);
347: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
348: END IF;
349: --
350: EXCEPTION

Line 347: hr_utility.trace('Business Group ID -> ' || g_business_group_id);

343: hr_utility.trace('L_Financial Year -> ' || l_financial_year);
344: hr_utility.trace('Processing Mode -> ' || g_processing_mode);
345: hr_utility.trace('Payroll ID -> ' || g_payroll_id);
346: hr_utility.trace('Assignment set ID -> ' || g_assignment_set_id);
347: hr_utility.trace('Business Group ID -> ' || g_business_group_id);
348: END IF;
349: --
350: EXCEPTION
351: WHEN OTHERS THEN

Line 356: hr_utility.set_location('Error in '||l_procedure, 30);

352: IF csr_get_parameters%ISOPEN THEN
353: CLOSE csr_get_parameters;
354: END IF;
355: IF g_debug THEN
356: hr_utility.set_location('Error in '||l_procedure, 30);
357: END IF;
358: RAISE;
359: END get_legislative_parameters;
360: --

Line 433: g_debug := hr_utility.debug_enabled;

429: AND paf.assignment_id = p_assignment_id;
430: --
431: BEGIN
432: --
433: g_debug := hr_utility.debug_enabled;
434: IF g_debug THEN
435: l_procedure := g_package||'periods_in_span';
436: hr_utility.set_location('Entering ' ||l_procedure, 10);
437: hr_utility.trace('Assignment ID -> ' || p_assignment_id);

Line 436: hr_utility.set_location('Entering ' ||l_procedure, 10);

432: --
433: g_debug := hr_utility.debug_enabled;
434: IF g_debug THEN
435: l_procedure := g_package||'periods_in_span';
436: hr_utility.set_location('Entering ' ||l_procedure, 10);
437: hr_utility.trace('Assignment ID -> ' || p_assignment_id);
438: hr_utility.trace('Start Date -> ' || p_start_date);
439: hr_utility.trace('End Date -> ' || p_end_date);
440: END IF;

Line 437: hr_utility.trace('Assignment ID -> ' || p_assignment_id);

433: g_debug := hr_utility.debug_enabled;
434: IF g_debug THEN
435: l_procedure := g_package||'periods_in_span';
436: hr_utility.set_location('Entering ' ||l_procedure, 10);
437: hr_utility.trace('Assignment ID -> ' || p_assignment_id);
438: hr_utility.trace('Start Date -> ' || p_start_date);
439: hr_utility.trace('End Date -> ' || p_end_date);
440: END IF;
441:

Line 438: hr_utility.trace('Start Date -> ' || p_start_date);

434: IF g_debug THEN
435: l_procedure := g_package||'periods_in_span';
436: hr_utility.set_location('Entering ' ||l_procedure, 10);
437: hr_utility.trace('Assignment ID -> ' || p_assignment_id);
438: hr_utility.trace('Start Date -> ' || p_start_date);
439: hr_utility.trace('End Date -> ' || p_end_date);
440: END IF;
441:
442: -- Get the previous Fiscal year.

Line 439: hr_utility.trace('End Date -> ' || p_end_date);

435: l_procedure := g_package||'periods_in_span';
436: hr_utility.set_location('Entering ' ||l_procedure, 10);
437: hr_utility.trace('Assignment ID -> ' || p_assignment_id);
438: hr_utility.trace('Start Date -> ' || p_start_date);
439: hr_utility.trace('End Date -> ' || p_end_date);
440: END IF;
441:
442: -- Get the previous Fiscal year.
443: l_year := TO_NUMBER(TO_CHAR(p_end_date,'YYYY'))-1;

Line 456: hr_utility.trace('Modified Start Date -> ' || l_start);

452: l_start := TO_DATE(g_start_dd_mm||TO_CHAR(l_year),'DD-MM-YYYY');
453: END IF;
454: --
455: IF g_debug THEN
456: hr_utility.trace('Modified Start Date -> ' || l_start);
457: END IF;
458: OPEN csr_pay_periods(l_start);
459: FETCH csr_pay_periods INTO l_periods;
460: CLOSE csr_pay_periods;

Line 463: hr_utility.set_location('Periods: ' || l_periods, 30);

459: FETCH csr_pay_periods INTO l_periods;
460: CLOSE csr_pay_periods;
461: --
462: IF g_debug THEN
463: hr_utility.set_location('Periods: ' || l_periods, 30);
464: END IF;
465: RETURN l_periods;
466: --
467: EXCEPTION

Line 471: hr_utility.set_location('Error Closing cursor csr_pay_periods', 40);

467: EXCEPTION
468: WHEN OTHERS THEN
469: IF csr_pay_periods%ISOPEN THEN
470: IF g_debug THEN
471: hr_utility.set_location('Error Closing cursor csr_pay_periods', 40);
472: END IF;
473: CLOSE csr_pay_periods;
474: END IF;
475: IF g_debug THEN

Line 476: hr_utility.set_location('Error in periods_in_span', 50);

472: END IF;
473: CLOSE csr_pay_periods;
474: END IF;
475: IF g_debug THEN
476: hr_utility.set_location('Error in periods_in_span', 50);
477: END IF;
478: RAISE;
479: END periods_in_span;
480:

Line 517: g_debug := hr_utility.debug_enabled;

513: --
514: --
515: -- print the debug messages if debug is enabled.
516: --
517: g_debug := hr_utility.debug_enabled;
518:
519: IF g_debug THEN
520: l_procedure := g_package || 'range_code' ;
521: hr_utility.set_location('Entering ' || l_procedure,10);

Line 521: hr_utility.set_location('Entering ' || l_procedure,10);

517: g_debug := hr_utility.debug_enabled;
518:
519: IF g_debug THEN
520: l_procedure := g_package || 'range_code' ;
521: hr_utility.set_location('Entering ' || l_procedure,10);
522: END IF;
523: --
524: -- sql string to SELECT a range of assignments eligible for archival.
525: --

Line 535: hr_utility.set_location('Leaving ' || l_procedure,20);

531: ' AND ppa.business_group_id = ppf.business_group_id' ||
532: ' ORDER BY ppf.person_id';
533:
534: IF g_debug THEN
535: hr_utility.set_location('Leaving ' || l_procedure,20);
536: END IF;
537:
538: --
539: EXCEPTION

Line 542: hr_utility.set_location('Error in ' || l_procedure,30);

538: --
539: EXCEPTION
540: WHEN OTHERS THEN
541: IF g_debug THEN
542: hr_utility.set_location('Error in ' || l_procedure,30);
543: END IF;
544:
545: RAISE;
546: --

Line 636: g_debug := hr_utility.debug_enabled;

632: --
633: --
634: -- print the debug messages if debug is enabled.
635: --
636: g_debug := hr_utility.debug_enabled;
637:
638: IF g_debug THEN
639: l_procedure := g_package || 'assignment_action_code' ;
640: hr_utility.set_location('Entering ' || l_procedure,10);

Line 640: hr_utility.set_location('Entering ' || l_procedure,10);

636: g_debug := hr_utility.debug_enabled;
637:
638: IF g_debug THEN
639: l_procedure := g_package || 'assignment_action_code' ;
640: hr_utility.set_location('Entering ' || l_procedure,10);
641: END IF;
642:
643: -- Get the legislative parameters of the concurrent request for archive
644: -- and store them in global variables.

Line 648: hr_utility.set_location('Opening Cursor csr_get_assignments.',20);

644: -- and store them in global variables.
645: get_legislative_parameters(p_payroll_action_id);
646:
647: IF g_debug THEN
648: hr_utility.set_location('Opening Cursor csr_get_assignments.',20);
649: END IF;
650:
651: FOR csr_record IN csr_get_assignments
652:

Line 657: hr_utility.set_location('For Assignment id.....:'||csr_record.assignment_id,30);

653: LOOP
654: --
655:
656: IF g_debug THEN
657: hr_utility.set_location('For Assignment id.....:'||csr_record.assignment_id,30);
658: hr_utility.set_location('Creating new archive assignment action id',40);
659: END IF;
660:
661: OPEN csr_next_action_id ;

Line 658: hr_utility.set_location('Creating new archive assignment action id',40);

654: --
655:
656: IF g_debug THEN
657: hr_utility.set_location('For Assignment id.....:'||csr_record.assignment_id,30);
658: hr_utility.set_location('Creating new archive assignment action id',40);
659: END IF;
660:
661: OPEN csr_next_action_id ;
662: FETCH csr_next_action_id INTO l_next_assignment_action_id ;

Line 666: hr_utility.set_location('New archive assignment action id:'||l_next_assignment_action_id,50);

662: FETCH csr_next_action_id INTO l_next_assignment_action_id ;
663: CLOSE csr_next_action_id ;
664:
665: IF g_debug THEN
666: hr_utility.set_location('New archive assignment action id:'||l_next_assignment_action_id,50);
667: hr_utility.set_location('Creating the archive assignment action id for the ...:'||csr_record.assignment_id,60);
668: END IF;
669:
670: -- Insert the new assignment actions

Line 667: hr_utility.set_location('Creating the archive assignment action id for the ...:'||csr_record.assignment_id,60);

663: CLOSE csr_next_action_id ;
664:
665: IF g_debug THEN
666: hr_utility.set_location('New archive assignment action id:'||l_next_assignment_action_id,50);
667: hr_utility.set_location('Creating the archive assignment action id for the ...:'||csr_record.assignment_id,60);
668: END IF;
669:
670: -- Insert the new assignment actions
671:

Line 686: hr_utility.set_location('Leaving ' || l_procedure,70);

682:
683:
684: END LOOP;
685: IF g_debug THEN
686: hr_utility.set_location('Leaving ' || l_procedure,70);
687: END IF;
688:
689:
690: EXCEPTION

Line 693: hr_utility.trace('Error occured in '||l_procedure);

689:
690: EXCEPTION
691: WHEN OTHERS THEN
692: IF g_debug THEN
693: hr_utility.trace('Error occured in '||l_procedure);
694: END IF;
695:
696: IF csr_get_assignments%ISOPEN THEN
697: --

Line 808: g_debug := hr_utility.debug_enabled;

804: --
805: --
806: -- print the debug messages if debug is enabled.
807: --
808: g_debug := hr_utility.debug_enabled;
809:
810: IF g_debug THEN
811: l_procedure := g_package || 'initialization_code' ;
812: hr_utility.set_location('Entering ' || l_procedure,10);

Line 812: hr_utility.set_location('Entering ' || l_procedure,10);

808: g_debug := hr_utility.debug_enabled;
809:
810: IF g_debug THEN
811: l_procedure := g_package || 'initialization_code' ;
812: hr_utility.set_location('Entering ' || l_procedure,10);
813: END IF;
814:
815: -- Get the legislative parameters and store them in global variables.
816: get_legislative_parameters(p_payroll_action_id);

Line 819: hr_utility.set_location('p_payroll_action_id -> ' || p_payroll_action_id, 15);

815: -- Get the legislative parameters and store them in global variables.
816: get_legislative_parameters(p_payroll_action_id);
817:
818: IF g_debug THEN
819: hr_utility.set_location('p_payroll_action_id -> ' || p_payroll_action_id, 15);
820: END IF;
821:
822: -- Fetch element_type_id and input_value_id into global variables.
823: OPEN csr_get_element_ids(g_financial_year) ;

Line 828: hr_utility.set_location('g_element_type_id -> ' ||g_element_type_id ,20);

824: FETCH csr_get_element_ids INTO g_element_type_id, g_input_value_id ;
825: CLOSE csr_get_element_ids ;
826:
827: IF g_debug THEN
828: hr_utility.set_location('g_element_type_id -> ' ||g_element_type_id ,20);
829: hr_utility.set_location('g_input_value_id -> ' ||g_input_value_id ,30);
830: END IF;
831:
832: --

Line 829: hr_utility.set_location('g_input_value_id -> ' ||g_input_value_id ,30);

825: CLOSE csr_get_element_ids ;
826:
827: IF g_debug THEN
828: hr_utility.set_location('g_element_type_id -> ' ||g_element_type_id ,20);
829: hr_utility.set_location('g_input_value_id -> ' ||g_input_value_id ,30);
830: END IF;
831:
832: --
833: -- Modified the cursor to have all three balances name and Dimension so as to

Line 865: hr_utility.set_location('Balance Name -> ' || csr_bal_rec.balance_name,40);

861: g_def_balance_tab(5).defined_balance_id := csr_bal_rec.defined_balance_id;
862:
863: END IF;
864: IF g_debug THEN
865: hr_utility.set_location('Balance Name -> ' || csr_bal_rec.balance_name,40);
866: hr_utility.set_location('Defined Balance ID -> ' ||csr_bal_rec.defined_balance_id ,50);
867: END IF;
868:
869: END LOOP;

Line 866: hr_utility.set_location('Defined Balance ID -> ' ||csr_bal_rec.defined_balance_id ,50);

862:
863: END IF;
864: IF g_debug THEN
865: hr_utility.set_location('Balance Name -> ' || csr_bal_rec.balance_name,40);
866: hr_utility.set_location('Defined Balance ID -> ' ||csr_bal_rec.defined_balance_id ,50);
867: END IF;
868:
869: END LOOP;
870:

Line 872: hr_utility.set_location('Leaving ' || l_procedure,60);

868:
869: END LOOP;
870:
871: IF g_debug THEN
872: hr_utility.set_location('Leaving ' || l_procedure,60);
873: END IF;
874:
875: --
876: EXCEPTION

Line 892: hr_utility.set_location('Error in ' || l_procedure,30);

888: --
889: END IF;
890:
891: IF g_debug THEN
892: hr_utility.set_location('Error in ' || l_procedure,30);
893: END IF;
894:
895: RAISE;
896: --

Line 1052: g_debug := hr_utility.debug_enabled;

1048: BEGIN
1049: --
1050: -- print the debug messages if debug is enabled.
1051: --
1052: g_debug := hr_utility.debug_enabled;
1053: IF g_debug THEN
1054: l_procedure := g_package||'archive_code';
1055: hr_utility.set_location('Entering '||l_procedure, 10);
1056: hr_utility.trace('Assignment Action ID-> ' || p_assignment_action_id);

Line 1055: hr_utility.set_location('Entering '||l_procedure, 10);

1051: --
1052: g_debug := hr_utility.debug_enabled;
1053: IF g_debug THEN
1054: l_procedure := g_package||'archive_code';
1055: hr_utility.set_location('Entering '||l_procedure, 10);
1056: hr_utility.trace('Assignment Action ID-> ' || p_assignment_action_id);
1057: hr_utility.trace('Effective Date-> ' || p_effective_date);
1058: END IF;
1059:

Line 1056: hr_utility.trace('Assignment Action ID-> ' || p_assignment_action_id);

1052: g_debug := hr_utility.debug_enabled;
1053: IF g_debug THEN
1054: l_procedure := g_package||'archive_code';
1055: hr_utility.set_location('Entering '||l_procedure, 10);
1056: hr_utility.trace('Assignment Action ID-> ' || p_assignment_action_id);
1057: hr_utility.trace('Effective Date-> ' || p_effective_date);
1058: END IF;
1059:
1060: --

Line 1057: hr_utility.trace('Effective Date-> ' || p_effective_date);

1053: IF g_debug THEN
1054: l_procedure := g_package||'archive_code';
1055: hr_utility.set_location('Entering '||l_procedure, 10);
1056: hr_utility.trace('Assignment Action ID-> ' || p_assignment_action_id);
1057: hr_utility.trace('Effective Date-> ' || p_effective_date);
1058: END IF;
1059:
1060: --
1061: -- Fetch employee details like name, assignment number, number of periods

Line 1074: hr_utility.set_location('In '||l_procedure, 20);

1070: , l_total_periods;
1071: CLOSE csr_employees;
1072: --
1073: IF g_debug THEN
1074: hr_utility.set_location('In '||l_procedure, 20);
1075: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1076: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1077: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1078: hr_utility.trace('Periods -> ' || l_periods);

Line 1075: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);

1071: CLOSE csr_employees;
1072: --
1073: IF g_debug THEN
1074: hr_utility.set_location('In '||l_procedure, 20);
1075: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1076: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1077: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1078: hr_utility.trace('Periods -> ' || l_periods);
1079: hr_utility.trace('Total Periods -> ' || l_total_periods);

Line 1076: hr_utility.trace('Assignment Number -> ' || l_assignment_number);

1072: --
1073: IF g_debug THEN
1074: hr_utility.set_location('In '||l_procedure, 20);
1075: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1076: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1077: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1078: hr_utility.trace('Periods -> ' || l_periods);
1079: hr_utility.trace('Total Periods -> ' || l_total_periods);
1080: END IF;

Line 1077: hr_utility.trace('Assignment ID -> ' || l_assignment_id);

1073: IF g_debug THEN
1074: hr_utility.set_location('In '||l_procedure, 20);
1075: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1076: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1077: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1078: hr_utility.trace('Periods -> ' || l_periods);
1079: hr_utility.trace('Total Periods -> ' || l_total_periods);
1080: END IF;
1081:

Line 1078: hr_utility.trace('Periods -> ' || l_periods);

1074: hr_utility.set_location('In '||l_procedure, 20);
1075: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1076: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1077: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1078: hr_utility.trace('Periods -> ' || l_periods);
1079: hr_utility.trace('Total Periods -> ' || l_total_periods);
1080: END IF;
1081:
1082: --

Line 1079: hr_utility.trace('Total Periods -> ' || l_total_periods);

1075: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1076: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1077: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1078: hr_utility.trace('Periods -> ' || l_periods);
1079: hr_utility.trace('Total Periods -> ' || l_total_periods);
1080: END IF;
1081:
1082: --
1083: IF l_periods = 0 THEN

Line 1086: hr_utility.set_location('Before creating action Information' || l_procedure, 30);

1082: --
1083: IF l_periods = 0 THEN
1084: --
1085: IF g_debug THEN
1086: hr_utility.set_location('Before creating action Information' || l_procedure, 30);
1087: END IF;
1088: --
1089:
1090: pay_action_information_api.create_action_information

Line 1128: hr_utility.set_location('l_assignment_action_id -> '||l_assignment_action_id, 40);

1124: FETCH csr_assignment_action INTO l_assignment_action_id;
1125: CLOSE csr_assignment_action;
1126: --
1127: IF g_debug THEN
1128: hr_utility.set_location('l_assignment_action_id -> '||l_assignment_action_id, 40);
1129: hr_utility.set_location('Before calling procedure pay_balance_pkg.get_value', 50);
1130: END IF;
1131:
1132: -- 3. Calculate the YTD balance values for the required balances.

Line 1129: hr_utility.set_location('Before calling procedure pay_balance_pkg.get_value', 50);

1125: CLOSE csr_assignment_action;
1126: --
1127: IF g_debug THEN
1128: hr_utility.set_location('l_assignment_action_id -> '||l_assignment_action_id, 40);
1129: hr_utility.set_location('Before calling procedure pay_balance_pkg.get_value', 50);
1130: END IF;
1131:
1132: -- 3. Calculate the YTD balance values for the required balances.
1133: --

Line 1142: hr_utility.set_location('In '||l_procedure, 60);

1138: );
1139:
1140: --
1141: IF g_debug THEN
1142: hr_utility.set_location('In '||l_procedure, 60);
1143: hr_utility.trace('Ordinary Taxable Earnings -> ' || g_def_balance_tab(1).balance_value);
1144:
1145: /* Change for Bug 5904043 start*/
1146: -- Changed g_def_balance_tab(3).balance_value to g_def_balance_tab(2).balance_value

Line 1143: hr_utility.trace('Ordinary Taxable Earnings -> ' || g_def_balance_tab(1).balance_value);

1139:
1140: --
1141: IF g_debug THEN
1142: hr_utility.set_location('In '||l_procedure, 60);
1143: hr_utility.trace('Ordinary Taxable Earnings -> ' || g_def_balance_tab(1).balance_value);
1144:
1145: /* Change for Bug 5904043 start*/
1146: -- Changed g_def_balance_tab(3).balance_value to g_def_balance_tab(2).balance_value
1147: hr_utility.trace('Extra Emoluments Taxable Earanings -> ' || g_def_balance_tab(2).balance_value);

Line 1147: hr_utility.trace('Extra Emoluments Taxable Earanings -> ' || g_def_balance_tab(2).balance_value);

1143: hr_utility.trace('Ordinary Taxable Earnings -> ' || g_def_balance_tab(1).balance_value);
1144:
1145: /* Change for Bug 5904043 start*/
1146: -- Changed g_def_balance_tab(3).balance_value to g_def_balance_tab(2).balance_value
1147: hr_utility.trace('Extra Emoluments Taxable Earanings -> ' || g_def_balance_tab(2).balance_value);
1148: /* Change for Bug 5904043 end*/
1149: /* Change for Bug 5846247 */
1150: hr_utility.trace('KiwiSaver Employer Contributions -> ' || g_def_balance_tab(3).balance_value);
1151: /* Added below condition for bug 7668520 */

Line 1150: hr_utility.trace('KiwiSaver Employer Contributions -> ' || g_def_balance_tab(3).balance_value);

1146: -- Changed g_def_balance_tab(3).balance_value to g_def_balance_tab(2).balance_value
1147: hr_utility.trace('Extra Emoluments Taxable Earanings -> ' || g_def_balance_tab(2).balance_value);
1148: /* Change for Bug 5904043 end*/
1149: /* Change for Bug 5846247 */
1150: hr_utility.trace('KiwiSaver Employer Contributions -> ' || g_def_balance_tab(3).balance_value);
1151: /* Added below condition for bug 7668520 */
1152: if g_financial_year >= TO_DATE(g_start_dd_mm ||'2009', 'DD-MM-YYYY') then
1153: hr_utility.trace('Employer Specified Superannuation Contributions -> ' || g_def_balance_tab(4).balance_value);
1154: end if;

Line 1153: hr_utility.trace('Employer Specified Superannuation Contributions -> ' || g_def_balance_tab(4).balance_value);

1149: /* Change for Bug 5846247 */
1150: hr_utility.trace('KiwiSaver Employer Contributions -> ' || g_def_balance_tab(3).balance_value);
1151: /* Added below condition for bug 7668520 */
1152: if g_financial_year >= TO_DATE(g_start_dd_mm ||'2009', 'DD-MM-YYYY') then
1153: hr_utility.trace('Employer Specified Superannuation Contributions -> ' || g_def_balance_tab(4).balance_value);
1154: end if;
1155: hr_utility.trace('Retro Ordinary Taxable Earnings -> ' || g_def_balance_tab(5).balance_value);
1156:
1157: END IF;

Line 1155: hr_utility.trace('Retro Ordinary Taxable Earnings -> ' || g_def_balance_tab(5).balance_value);

1151: /* Added below condition for bug 7668520 */
1152: if g_financial_year >= TO_DATE(g_start_dd_mm ||'2009', 'DD-MM-YYYY') then
1153: hr_utility.trace('Employer Specified Superannuation Contributions -> ' || g_def_balance_tab(4).balance_value);
1154: end if;
1155: hr_utility.trace('Retro Ordinary Taxable Earnings -> ' || g_def_balance_tab(5).balance_value);
1156:
1157: END IF;
1158:
1159: -- 4. Calculate the Yearly Value

Line 1183: hr_utility.set_location('l_yearly_value ->' ||l_yearly_value, 70);

1179: -- a correct rate of calculation.
1180: --
1181: l_yearly_value := (l_yearly_value / l_periods) * l_total_periods;
1182: IF g_debug THEN
1183: hr_utility.set_location('l_yearly_value ->' ||l_yearly_value, 70);
1184: END IF;
1185:
1186: --
1187: -- 5. Calculate the New SSCWT Rate

Line 1205: hr_utility.set_location('In '|| l_procedure,80);

1201: FETCH csr_get_old_sscwt_rate into l_sscwt_old_rate, l_element_entry_id;
1202: CLOSE csr_get_old_sscwt_rate;
1203: --
1204: IF g_debug = true THEN
1205: hr_utility.set_location('In '|| l_procedure,80);
1206: hr_utility.trace('Old SSCWT Rate -> ' || l_sscwt_old_rate);
1207: hr_utility.trace('New SSCWT Rate -> ' || l_sscwt_new_rate);
1208: hr_utility.trace('Yearly Value -> ' || l_yearly_value);
1209: END IF;

Line 1206: hr_utility.trace('Old SSCWT Rate -> ' || l_sscwt_old_rate);

1202: CLOSE csr_get_old_sscwt_rate;
1203: --
1204: IF g_debug = true THEN
1205: hr_utility.set_location('In '|| l_procedure,80);
1206: hr_utility.trace('Old SSCWT Rate -> ' || l_sscwt_old_rate);
1207: hr_utility.trace('New SSCWT Rate -> ' || l_sscwt_new_rate);
1208: hr_utility.trace('Yearly Value -> ' || l_yearly_value);
1209: END IF;
1210:

Line 1207: hr_utility.trace('New SSCWT Rate -> ' || l_sscwt_new_rate);

1203: --
1204: IF g_debug = true THEN
1205: hr_utility.set_location('In '|| l_procedure,80);
1206: hr_utility.trace('Old SSCWT Rate -> ' || l_sscwt_old_rate);
1207: hr_utility.trace('New SSCWT Rate -> ' || l_sscwt_new_rate);
1208: hr_utility.trace('Yearly Value -> ' || l_yearly_value);
1209: END IF;
1210:
1211: --

Line 1208: hr_utility.trace('Yearly Value -> ' || l_yearly_value);

1204: IF g_debug = true THEN
1205: hr_utility.set_location('In '|| l_procedure,80);
1206: hr_utility.trace('Old SSCWT Rate -> ' || l_sscwt_old_rate);
1207: hr_utility.trace('New SSCWT Rate -> ' || l_sscwt_new_rate);
1208: hr_utility.trace('Yearly Value -> ' || l_yearly_value);
1209: END IF;
1210:
1211: --
1212: -- 7. Archive the details if the Rate is to be changed.

Line 1219: hr_utility.set_location('Processing Automatic mode in '||l_procedure, 90);

1215: --
1216: IF g_processing_mode = 'A' THEN
1217: --
1218: IF g_debug THEN
1219: hr_utility.set_location('Processing Automatic mode in '||l_procedure, 90);
1220: END IF;
1221: --
1222: -- 1. Update the SSCWT Rate in SSCWT Information element.
1223: --

Line 1230: hr_utility.set_location('On successful update of element entry value', 100);

1226: ,p_effective_date => g_financial_year);
1227: --
1228: IF l_flag = true THEN
1229: IF g_debug THEN
1230: hr_utility.set_location('On successful update of element entry value', 100);
1231: END IF;
1232:
1233: pay_action_information_api.create_action_information
1234: (

Line 1252: hr_utility.set_location('On failure of update of element entry value', 110);

1248: );
1249:
1250: ELSE --if updation failed.
1251: IF g_debug THEN
1252: hr_utility.set_location('On failure of update of element entry value', 110);
1253: END IF;
1254:
1255: pay_action_information_api.create_action_information
1256: (

Line 1276: hr_utility.set_location('Processing Manual Mode', 110);

1272: END IF; --l_flag is true
1273:
1274: ELSE --If processing mode is manual
1275: IF g_debug THEN
1276: hr_utility.set_location('Processing Manual Mode', 110);
1277: END IF;
1278:
1279: pay_action_information_api.create_action_information
1280: (

Line 1299: hr_utility.set_location('After Creating action Information in Maual mode', 120);

1295:
1296: END IF; --l_processing mode is automatic
1297: --
1298: IF g_debug THEN
1299: hr_utility.set_location('After Creating action Information in Maual mode', 120);
1300: END IF;
1301: --
1302: END IF; -- old sscwt rate not equal to new sscwt rate
1303:

Line 1305: hr_utility.set_location('Leaving ' ||l_procedure, 130);

1301: --
1302: END IF; -- old sscwt rate not equal to new sscwt rate
1303:
1304: IF g_debug THEN
1305: hr_utility.set_location('Leaving ' ||l_procedure, 130);
1306: END IF;
1307:
1308: EXCEPTION
1309: WHEN OTHERS THEN

Line 1312: hr_utility.set_location('Error: Closing cursor csr_assignment_action', 140);

1308: EXCEPTION
1309: WHEN OTHERS THEN
1310: IF csr_assignment_action%ISOPEN THEN
1311: IF g_debug THEN
1312: hr_utility.set_location('Error: Closing cursor csr_assignment_action', 140);
1313: END IF;
1314: CLOSE csr_assignment_action;
1315: END IF;
1316: IF csr_get_old_sscwt_rate%ISOPEN THEN

Line 1318: hr_utility.set_location('Error: Closing cursor csr_sscwt_route', 140);

1314: CLOSE csr_assignment_action;
1315: END IF;
1316: IF csr_get_old_sscwt_rate%ISOPEN THEN
1317: IF g_debug THEN
1318: hr_utility.set_location('Error: Closing cursor csr_sscwt_route', 140);
1319: END IF;
1320: CLOSE csr_get_old_sscwt_rate;
1321: END IF;
1322: IF csr_employees%ISOPEN THEN

Line 1324: hr_utility.set_location('Error: Closing cursor csr_employees', 140);

1320: CLOSE csr_get_old_sscwt_rate;
1321: END IF;
1322: IF csr_employees%ISOPEN THEN
1323: IF g_debug THEN
1324: hr_utility.set_location('Error: Closing cursor csr_employees', 140);
1325: END IF;
1326: CLOSE csr_employees;
1327: END IF;
1328: IF g_debug THEN

Line 1329: hr_utility.set_location('Error: In archive_code', 150);

1325: END IF;
1326: CLOSE csr_employees;
1327: END IF;
1328: IF g_debug THEN
1329: hr_utility.set_location('Error: In archive_code', 150);
1330: END IF;
1331: RAISE;
1332: END archive_code;
1333:

Line 1354: -- 115.1 22-JAN-2004 sshankar Added hr_utility.debug_enabled call to--

1350: --------------------------------------------------------------------------
1351: -- Rev# Date Userid Description --
1352: --------------------------------------------------------------------------
1353: -- 115.0 22-JAN-2004 sshankar Initial Version --
1354: -- 115.1 22-JAN-2004 sshankar Added hr_utility.debug_enabled call to--
1355: -- initialize g_debug variable. --
1356: --------------------------------------------------------------------------
1357: --
1358: PROCEDURE deinitialize_code (p_payroll_action_id IN NUMBER)

Line 1367: g_debug := hr_utility.debug_enabled;

1363: BEGIN
1364: --
1365: -- print the debug messages if debug is enabled.
1366: --
1367: g_debug := hr_utility.debug_enabled;
1368:
1369: IF g_debug THEN
1370: l_procedure := g_package || 'deinitialize_code' ;
1371: hr_utility.set_location('Entering '||l_procedure,10);

Line 1371: hr_utility.set_location('Entering '||l_procedure,10);

1367: g_debug := hr_utility.debug_enabled;
1368:
1369: IF g_debug THEN
1370: l_procedure := g_package || 'deinitialize_code' ;
1371: hr_utility.set_location('Entering '||l_procedure,10);
1372: END IF;
1373:
1374: get_legislative_parameters(p_payroll_action_id);
1375:

Line 1377: hr_utility.set_location('After Calling get_legislative_parameters',20);

1373:
1374: get_legislative_parameters(p_payroll_action_id);
1375:
1376: IF g_debug THEN
1377: hr_utility.set_location('After Calling get_legislative_parameters',20);
1378: END IF;
1379:
1380: -- Call procedure to submit request for report.
1381: submit_sscwt_report;

Line 1384: hr_utility.set_location('Leaving '||l_procedure,30);

1380: -- Call procedure to submit request for report.
1381: submit_sscwt_report;
1382:
1383: IF g_debug THEN
1384: hr_utility.set_location('Leaving '||l_procedure,30);
1385: END IF;
1386:
1387: EXCEPTION
1388: WHEN OTHERS THEN

Line 1390: hr_utility.set_location('Error in '||l_procedure,40);

1386:
1387: EXCEPTION
1388: WHEN OTHERS THEN
1389: IF g_debug THEN
1390: hr_utility.set_location('Error in '||l_procedure,40);
1391: END IF;
1392: RAISE;
1393:
1394: END deinitialize_code;

Line 1401: g_debug := hr_utility.debug_enabled ;

1397: -- Assign Global variables in this unnamed block. This is to avoid assigning global variables within procedures
1398: -- for each thread that executes the procedure.
1399: --
1400: Begin
1401: g_debug := hr_utility.debug_enabled ;
1402: g_package := 'pay_nz_sscwt_rate_archive.' ;
1403: g_start_dd_mm := '01-04-' ;
1404: g_legislation_code := 'NZ' ;
1405: g_report_short_name := 'PYNZSSRP' ;