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 803: g_debug := hr_utility.debug_enabled;

799: --
800: --
801: -- print the debug messages if debug is enabled.
802: --
803: g_debug := hr_utility.debug_enabled;
804:
805: IF g_debug THEN
806: l_procedure := g_package || 'initialization_code' ;
807: hr_utility.set_location('Entering ' || l_procedure,10);

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

803: g_debug := hr_utility.debug_enabled;
804:
805: IF g_debug THEN
806: l_procedure := g_package || 'initialization_code' ;
807: hr_utility.set_location('Entering ' || l_procedure,10);
808: END IF;
809:
810: -- Get the legislative parameters and store them in global variables.
811: get_legislative_parameters(p_payroll_action_id);

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

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

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

819: FETCH csr_get_element_ids INTO g_element_type_id, g_input_value_id ;
820: CLOSE csr_get_element_ids ;
821:
822: IF g_debug THEN
823: hr_utility.set_location('g_element_type_id -> ' ||g_element_type_id ,20);
824: hr_utility.set_location('g_input_value_id -> ' ||g_input_value_id ,30);
825: END IF;
826:
827: --

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

820: CLOSE csr_get_element_ids ;
821:
822: IF g_debug THEN
823: hr_utility.set_location('g_element_type_id -> ' ||g_element_type_id ,20);
824: hr_utility.set_location('g_input_value_id -> ' ||g_input_value_id ,30);
825: END IF;
826:
827: --
828: -- Modified the cursor to have all three balances name and Dimension so as to

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

848: g_def_balance_tab(3).defined_balance_id := csr_bal_rec.defined_balance_id;
849:
850: END IF;
851: IF g_debug THEN
852: hr_utility.set_location('Balance Name -> ' || csr_bal_rec.balance_name,40);
853: hr_utility.set_location('Defined Balance ID -> ' ||csr_bal_rec.defined_balance_id ,50);
854: END IF;
855:
856: END LOOP;

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

849:
850: END IF;
851: IF g_debug THEN
852: hr_utility.set_location('Balance Name -> ' || csr_bal_rec.balance_name,40);
853: hr_utility.set_location('Defined Balance ID -> ' ||csr_bal_rec.defined_balance_id ,50);
854: END IF;
855:
856: END LOOP;
857:

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

855:
856: END LOOP;
857:
858: IF g_debug THEN
859: hr_utility.set_location('Leaving ' || l_procedure,60);
860: END IF;
861:
862: --
863: EXCEPTION

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

875: --
876: END IF;
877:
878: IF g_debug THEN
879: hr_utility.set_location('Error in ' || l_procedure,30);
880: END IF;
881:
882: RAISE;
883: --

Line 1037: g_debug := hr_utility.debug_enabled;

1033: BEGIN
1034: --
1035: -- print the debug messages if debug is enabled.
1036: --
1037: g_debug := hr_utility.debug_enabled;
1038: IF g_debug THEN
1039: l_procedure := g_package||'archive_code';
1040: hr_utility.set_location('Entering '||l_procedure, 10);
1041: hr_utility.trace('Assignment Action ID-> ' || p_assignment_action_id);

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

1036: --
1037: g_debug := hr_utility.debug_enabled;
1038: IF g_debug THEN
1039: l_procedure := g_package||'archive_code';
1040: hr_utility.set_location('Entering '||l_procedure, 10);
1041: hr_utility.trace('Assignment Action ID-> ' || p_assignment_action_id);
1042: hr_utility.trace('Effective Date-> ' || p_effective_date);
1043: END IF;
1044:

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

1037: g_debug := hr_utility.debug_enabled;
1038: IF g_debug THEN
1039: l_procedure := g_package||'archive_code';
1040: hr_utility.set_location('Entering '||l_procedure, 10);
1041: hr_utility.trace('Assignment Action ID-> ' || p_assignment_action_id);
1042: hr_utility.trace('Effective Date-> ' || p_effective_date);
1043: END IF;
1044:
1045: --

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

1038: IF g_debug THEN
1039: l_procedure := g_package||'archive_code';
1040: hr_utility.set_location('Entering '||l_procedure, 10);
1041: hr_utility.trace('Assignment Action ID-> ' || p_assignment_action_id);
1042: hr_utility.trace('Effective Date-> ' || p_effective_date);
1043: END IF;
1044:
1045: --
1046: -- Fetch employee details like name, assignment number, number of periods

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

1055: , l_total_periods;
1056: CLOSE csr_employees;
1057: --
1058: IF g_debug THEN
1059: hr_utility.set_location('In '||l_procedure, 20);
1060: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1061: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1062: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1063: hr_utility.trace('Periods -> ' || l_periods);

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

1056: CLOSE csr_employees;
1057: --
1058: IF g_debug THEN
1059: hr_utility.set_location('In '||l_procedure, 20);
1060: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1061: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1062: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1063: hr_utility.trace('Periods -> ' || l_periods);
1064: hr_utility.trace('Total Periods -> ' || l_total_periods);

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

1057: --
1058: IF g_debug THEN
1059: hr_utility.set_location('In '||l_procedure, 20);
1060: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1061: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1062: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1063: hr_utility.trace('Periods -> ' || l_periods);
1064: hr_utility.trace('Total Periods -> ' || l_total_periods);
1065: END IF;

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

1058: IF g_debug THEN
1059: hr_utility.set_location('In '||l_procedure, 20);
1060: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1061: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1062: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1063: hr_utility.trace('Periods -> ' || l_periods);
1064: hr_utility.trace('Total Periods -> ' || l_total_periods);
1065: END IF;
1066:

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

1059: hr_utility.set_location('In '||l_procedure, 20);
1060: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1061: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1062: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1063: hr_utility.trace('Periods -> ' || l_periods);
1064: hr_utility.trace('Total Periods -> ' || l_total_periods);
1065: END IF;
1066:
1067: --

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

1060: hr_utility.trace('Employee Full Name -> ' || l_employee_full_name);
1061: hr_utility.trace('Assignment Number -> ' || l_assignment_number);
1062: hr_utility.trace('Assignment ID -> ' || l_assignment_id);
1063: hr_utility.trace('Periods -> ' || l_periods);
1064: hr_utility.trace('Total Periods -> ' || l_total_periods);
1065: END IF;
1066:
1067: --
1068: IF l_periods = 0 THEN

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

1067: --
1068: IF l_periods = 0 THEN
1069: --
1070: IF g_debug THEN
1071: hr_utility.set_location('Before creating action Information' || l_procedure, 30);
1072: END IF;
1073: --
1074:
1075: pay_action_information_api.create_action_information

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

1109: FETCH csr_assignment_action INTO l_assignment_action_id;
1110: CLOSE csr_assignment_action;
1111: --
1112: IF g_debug THEN
1113: hr_utility.set_location('l_assignment_action_id -> '||l_assignment_action_id, 40);
1114: hr_utility.set_location('Before calling procedure pay_balance_pkg.get_value', 50);
1115: END IF;
1116:
1117: -- 3. Calculate the YTD balance values for the required balances.

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

1110: CLOSE csr_assignment_action;
1111: --
1112: IF g_debug THEN
1113: hr_utility.set_location('l_assignment_action_id -> '||l_assignment_action_id, 40);
1114: hr_utility.set_location('Before calling procedure pay_balance_pkg.get_value', 50);
1115: END IF;
1116:
1117: -- 3. Calculate the YTD balance values for the required balances.
1118: --

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

1123: );
1124:
1125: --
1126: IF g_debug THEN
1127: hr_utility.set_location('In '||l_procedure, 60);
1128: hr_utility.trace('Ordinary Taxable Earnings -> ' || g_def_balance_tab(1).balance_value);
1129:
1130: /* Change for Bug 5904043 start*/
1131: -- Changed g_def_balance_tab(3).balance_value to g_def_balance_tab(2).balance_value

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

1124:
1125: --
1126: IF g_debug THEN
1127: hr_utility.set_location('In '||l_procedure, 60);
1128: hr_utility.trace('Ordinary Taxable Earnings -> ' || g_def_balance_tab(1).balance_value);
1129:
1130: /* Change for Bug 5904043 start*/
1131: -- Changed g_def_balance_tab(3).balance_value to g_def_balance_tab(2).balance_value
1132: hr_utility.trace('Extra Emoluments Taxable Earanings -> ' || g_def_balance_tab(2).balance_value);

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

1128: hr_utility.trace('Ordinary Taxable Earnings -> ' || g_def_balance_tab(1).balance_value);
1129:
1130: /* Change for Bug 5904043 start*/
1131: -- Changed g_def_balance_tab(3).balance_value to g_def_balance_tab(2).balance_value
1132: hr_utility.trace('Extra Emoluments Taxable Earanings -> ' || g_def_balance_tab(2).balance_value);
1133: /* Change for Bug 5904043 end*/
1134: /* Change for Bug 5846247 */
1135: hr_utility.trace('KiwiSaver Employer Contributions -> ' || g_def_balance_tab(3).balance_value);
1136: END IF;

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

1131: -- Changed g_def_balance_tab(3).balance_value to g_def_balance_tab(2).balance_value
1132: hr_utility.trace('Extra Emoluments Taxable Earanings -> ' || g_def_balance_tab(2).balance_value);
1133: /* Change for Bug 5904043 end*/
1134: /* Change for Bug 5846247 */
1135: hr_utility.trace('KiwiSaver Employer Contributions -> ' || g_def_balance_tab(3).balance_value);
1136: END IF;
1137:
1138: -- 4. Calculate the Yearly Value
1139: --

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

1151: -- a correct rate of calculation.
1152: --
1153: l_yearly_value := (l_yearly_value / l_periods) * l_total_periods;
1154: IF g_debug THEN
1155: hr_utility.set_location('l_yearly_value ->' ||l_yearly_value, 70);
1156: END IF;
1157:
1158: --
1159: -- 5. Calculate the New SSCWT Rate

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

1173: FETCH csr_get_old_sscwt_rate into l_sscwt_old_rate, l_element_entry_id;
1174: CLOSE csr_get_old_sscwt_rate;
1175: --
1176: IF g_debug = true THEN
1177: hr_utility.set_location('In '|| l_procedure,80);
1178: hr_utility.trace('Old SSCWT Rate -> ' || l_sscwt_old_rate);
1179: hr_utility.trace('New SSCWT Rate -> ' || l_sscwt_new_rate);
1180: hr_utility.trace('Yearly Value -> ' || l_yearly_value);
1181: END IF;

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

1174: CLOSE csr_get_old_sscwt_rate;
1175: --
1176: IF g_debug = true THEN
1177: hr_utility.set_location('In '|| l_procedure,80);
1178: hr_utility.trace('Old SSCWT Rate -> ' || l_sscwt_old_rate);
1179: hr_utility.trace('New SSCWT Rate -> ' || l_sscwt_new_rate);
1180: hr_utility.trace('Yearly Value -> ' || l_yearly_value);
1181: END IF;
1182:

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

1175: --
1176: IF g_debug = true THEN
1177: hr_utility.set_location('In '|| l_procedure,80);
1178: hr_utility.trace('Old SSCWT Rate -> ' || l_sscwt_old_rate);
1179: hr_utility.trace('New SSCWT Rate -> ' || l_sscwt_new_rate);
1180: hr_utility.trace('Yearly Value -> ' || l_yearly_value);
1181: END IF;
1182:
1183: --

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

1176: IF g_debug = true THEN
1177: hr_utility.set_location('In '|| l_procedure,80);
1178: hr_utility.trace('Old SSCWT Rate -> ' || l_sscwt_old_rate);
1179: hr_utility.trace('New SSCWT Rate -> ' || l_sscwt_new_rate);
1180: hr_utility.trace('Yearly Value -> ' || l_yearly_value);
1181: END IF;
1182:
1183: --
1184: -- 7. Archive the details if the Rate is to be changed.

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

1187: --
1188: IF g_processing_mode = 'A' THEN
1189: --
1190: IF g_debug THEN
1191: hr_utility.set_location('Processing Automatic mode in '||l_procedure, 90);
1192: END IF;
1193: --
1194: -- 1. Update the SSCWT Rate in SSCWT Information element.
1195: --

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

1198: ,p_effective_date => g_financial_year);
1199: --
1200: IF l_flag = true THEN
1201: IF g_debug THEN
1202: hr_utility.set_location('On successful update of element entry value', 100);
1203: END IF;
1204:
1205: pay_action_information_api.create_action_information
1206: (

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

1220: );
1221:
1222: ELSE --if updation failed.
1223: IF g_debug THEN
1224: hr_utility.set_location('On failure of update of element entry value', 110);
1225: END IF;
1226:
1227: pay_action_information_api.create_action_information
1228: (

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

1244: END IF; --l_flag is true
1245:
1246: ELSE --If processing mode is manual
1247: IF g_debug THEN
1248: hr_utility.set_location('Processing Manual Mode', 110);
1249: END IF;
1250:
1251: pay_action_information_api.create_action_information
1252: (

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

1267:
1268: END IF; --l_processing mode is automatic
1269: --
1270: IF g_debug THEN
1271: hr_utility.set_location('After Creating action Information in Maual mode', 120);
1272: END IF;
1273: --
1274: END IF; -- old sscwt rate not equal to new sscwt rate
1275:

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

1273: --
1274: END IF; -- old sscwt rate not equal to new sscwt rate
1275:
1276: IF g_debug THEN
1277: hr_utility.set_location('Leaving ' ||l_procedure, 130);
1278: END IF;
1279:
1280: EXCEPTION
1281: WHEN OTHERS THEN

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

1280: EXCEPTION
1281: WHEN OTHERS THEN
1282: IF csr_assignment_action%ISOPEN THEN
1283: IF g_debug THEN
1284: hr_utility.set_location('Error: Closing cursor csr_assignment_action', 140);
1285: END IF;
1286: CLOSE csr_assignment_action;
1287: END IF;
1288: IF csr_get_old_sscwt_rate%ISOPEN THEN

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

1286: CLOSE csr_assignment_action;
1287: END IF;
1288: IF csr_get_old_sscwt_rate%ISOPEN THEN
1289: IF g_debug THEN
1290: hr_utility.set_location('Error: Closing cursor csr_sscwt_route', 140);
1291: END IF;
1292: CLOSE csr_get_old_sscwt_rate;
1293: END IF;
1294: IF csr_employees%ISOPEN THEN

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

1292: CLOSE csr_get_old_sscwt_rate;
1293: END IF;
1294: IF csr_employees%ISOPEN THEN
1295: IF g_debug THEN
1296: hr_utility.set_location('Error: Closing cursor csr_employees', 140);
1297: END IF;
1298: CLOSE csr_employees;
1299: END IF;
1300: IF g_debug THEN

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

1297: END IF;
1298: CLOSE csr_employees;
1299: END IF;
1300: IF g_debug THEN
1301: hr_utility.set_location('Error: In archive_code', 150);
1302: END IF;
1303: RAISE;
1304: END archive_code;
1305:

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

1322: --------------------------------------------------------------------------
1323: -- Rev# Date Userid Description --
1324: --------------------------------------------------------------------------
1325: -- 115.0 22-JAN-2004 sshankar Initial Version --
1326: -- 115.1 22-JAN-2004 sshankar Added hr_utility.debug_enabled call to--
1327: -- initialize g_debug variable. --
1328: --------------------------------------------------------------------------
1329: --
1330: PROCEDURE deinitialize_code (p_payroll_action_id IN NUMBER)

Line 1339: g_debug := hr_utility.debug_enabled;

1335: BEGIN
1336: --
1337: -- print the debug messages if debug is enabled.
1338: --
1339: g_debug := hr_utility.debug_enabled;
1340:
1341: IF g_debug THEN
1342: l_procedure := g_package || 'deinitialize_code' ;
1343: hr_utility.set_location('Entering '||l_procedure,10);

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

1339: g_debug := hr_utility.debug_enabled;
1340:
1341: IF g_debug THEN
1342: l_procedure := g_package || 'deinitialize_code' ;
1343: hr_utility.set_location('Entering '||l_procedure,10);
1344: END IF;
1345:
1346: get_legislative_parameters(p_payroll_action_id);
1347:

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

1345:
1346: get_legislative_parameters(p_payroll_action_id);
1347:
1348: IF g_debug THEN
1349: hr_utility.set_location('After Calling get_legislative_parameters',20);
1350: END IF;
1351:
1352: -- Call procedure to submit request for report.
1353: submit_sscwt_report;

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

1352: -- Call procedure to submit request for report.
1353: submit_sscwt_report;
1354:
1355: IF g_debug THEN
1356: hr_utility.set_location('Leaving '||l_procedure,30);
1357: END IF;
1358:
1359: EXCEPTION
1360: WHEN OTHERS THEN

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

1358:
1359: EXCEPTION
1360: WHEN OTHERS THEN
1361: IF g_debug THEN
1362: hr_utility.set_location('Error in '||l_procedure,40);
1363: END IF;
1364: RAISE;
1365:
1366: END deinitialize_code;

Line 1373: g_debug := hr_utility.debug_enabled ;

1369: -- Assign Global variables in this unnamed block. This is to avoid assigning global variables within procedures
1370: -- for each thread that executes the procedure.
1371: --
1372: Begin
1373: g_debug := hr_utility.debug_enabled ;
1374: g_package := 'pay_nz_sscwt_rate_archive.' ;
1375: g_start_dd_mm := '01-04-' ;
1376: g_legislation_code := 'NZ' ;
1377: g_report_short_name := 'PYNZSSRP' ;