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_ZA_CALENDARS_PKG dependencies on HR_UTILITY

Line 144: hr_utility.set_message(801, 'PAY_6601_PAYROLL_INV_PERIOD_TP');

140: l_period_type2 := WEEKLY;
141: l_multiple := 1;
142: else
143: -- Unknown period type.
144: hr_utility.set_message(801, 'PAY_6601_PAYROLL_INV_PERIOD_TP');
145: hr_utility.raise_error;
146: end if;
147:
148: -- Call the procedure that creates the ZA calendars with the necessary parameters.

Line 145: hr_utility.raise_error;

141: l_multiple := 1;
142: else
143: -- Unknown period type.
144: hr_utility.set_message(801, 'PAY_6601_PAYROLL_INV_PERIOD_TP');
145: hr_utility.raise_error;
146: end if;
147:
148: -- Call the procedure that creates the ZA calendars with the necessary parameters.
149: create_calendar

Line 204: hr_utility.set_location(func_name, 1);

200: func_name CONSTANT varchar2(50) := 'za_pay_calendars.create_calendar';
201:
202: begin
203:
204: hr_utility.set_location(func_name, 1);
205: -- Obtain the Business Group Id of the current user
206: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
207: -- Obtain the day on which the Company Financial Year starts
208: l_fiscal_start_day := to_number(

Line 273: hr_utility.set_location(func_name, 1);

269: func_name CONSTANT varchar2(50) := 'za_pay_calendars.retrieve_tax_year_start';
270:
271: begin
272:
273: hr_utility.set_location(func_name, 1);
274: -- Obtain the Tax Year Start from pay_legislation_rules
275: select
276: rule_mode
277: into

Line 306: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');

302:
303: exception
304: -- The Tax Year is not in DD-MON format
305: when no_data_found then
306: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
307: hr_utility.raise_error;
308: when too_many_rows then
309: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
310: hr_utility.raise_error;

Line 307: hr_utility.raise_error;

303: exception
304: -- The Tax Year is not in DD-MON format
305: when no_data_found then
306: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
307: hr_utility.raise_error;
308: when too_many_rows then
309: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
310: hr_utility.raise_error;
311: when invalid_number then

Line 309: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');

305: when no_data_found then
306: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
307: hr_utility.raise_error;
308: when too_many_rows then
309: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
310: hr_utility.raise_error;
311: when invalid_number then
312: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
313: hr_utility.raise_error;

Line 310: hr_utility.raise_error;

306: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
307: hr_utility.raise_error;
308: when too_many_rows then
309: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
310: hr_utility.raise_error;
311: when invalid_number then
312: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
313: hr_utility.raise_error;
314:

Line 312: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');

308: when too_many_rows then
309: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
310: hr_utility.raise_error;
311: when invalid_number then
312: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
313: hr_utility.raise_error;
314:
315: end retrieve_tax_year_start;
316:

Line 313: hr_utility.raise_error;

309: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
310: hr_utility.raise_error;
311: when invalid_number then
312: hr_utility.set_message(800, 'PAY_PAYROLL_TAX_YEAR');
313: hr_utility.raise_error;
314:
315: end retrieve_tax_year_start;
316:
317: ---------------------------------------------------------------------------------------

Line 337: hr_utility.set_location(func_name, 1);

333: func_name CONSTANT varchar2(50) := 'za_pay_calendars.retrieve_fiscal_year_start';
334:
335: begin
336:
337: hr_utility.set_location(func_name, 1);
338: -- Determine the Company Fiscal Year Start for the current Business Group
339: select
340: fnd_date.canonical_to_date(org_information11)
341: into

Line 354: hr_utility.set_message(800, 'PAY_COMPANY_FISCAL_YEAR');

350: return l_fiscal_start;
351:
352: exception
353: when no_data_found then
354: hr_utility.set_message(800, 'PAY_COMPANY_FISCAL_YEAR');
355: hr_utility.raise_error;
356:
357: end retrieve_fiscal_year_start;
358:

Line 355: hr_utility.raise_error;

351:
352: exception
353: when no_data_found then
354: hr_utility.set_message(800, 'PAY_COMPANY_FISCAL_YEAR');
355: hr_utility.raise_error;
356:
357: end retrieve_fiscal_year_start;
358:
359: ---------------------------------------------------------------------------------------

Line 425: hr_utility.set_location(func_name, 1);

421: end_date;
422:
423: begin
424:
425: hr_utility.set_location(func_name, 1);
426: open get_periods;
427: -- Store the first period end date
428: fetch get_periods into l_store_end_date;
429:

Line 537: hr_utility.set_location(func_name, 1);

533: func_name CONSTANT varchar2(50) := 'za_pay_calendars.generate_fiscal_month_start';
534:
535: begin
536:
537: hr_utility.set_location(func_name, 1);
538: -- As a first try, try using the day of the fiscal year and the month and year
539: -- of the period's end date
540: -- next_lower_day checks whether the date exist, otherwise it subtracts days until
541: -- the date does exist

Line 576: hr_utility.set_location(func_name, 1);

572: func_name CONSTANT varchar2(50) := 'za_pay_calendars.next_lower_day';
573:
574: begin
575:
576: hr_utility.set_location(func_name, 1);
577: -- Determine the date of the last day of the month
578: l_last := last_day(p_date);
579:
580: -- Determine the day of the last day of the month

Line 629: hr_utility.set_location(func_name, 1);

625: begin
626:
627: -- Errors can occur when performing date manipulation.
628: if p_base_period_type = WEEKLY then
629: hr_utility.set_location(func_name, 1);
630: return (p_target_date + (7 * p_multiple));
631: elsif p_base_period_type = MONTHLY then
632: hr_utility.set_location(func_name, 2);
633: return (add_months(p_target_date, p_multiple));

Line 632: hr_utility.set_location(func_name, 2);

628: if p_base_period_type = WEEKLY then
629: hr_utility.set_location(func_name, 1);
630: return (p_target_date + (7 * p_multiple));
631: elsif p_base_period_type = MONTHLY then
632: hr_utility.set_location(func_name, 2);
633: return (add_months(p_target_date, p_multiple));
634: else
635: -- This is semi-monthly. A pair of semi-months always spand a whole calendar
636: -- month. Their start and end dates are either 1st - 15th or 16th - last day of

Line 656: hr_utility.trace('pay date ' || to_char(temp_date, 'dd-mon-yyyy'));

652: -- pay-date -> Current end-date -> Previous period's end-date -> Previous
653: -- period's pay-date.
654: temp_date := prev_semi_month(p_target_date - p_pay_date_offset,
655: p_fpe_date) + p_pay_date_offset;
656: hr_utility.trace('pay date ' || to_char(temp_date, 'dd-mon-yyyy'));
657: return(temp_date);
658: -- OLD CODE
659: -- Now period's are not guaranteed to end on the 15th or the end_of_month.
660: --

Line 669: -- hr_utility.trace('1st half ' || to_char(temp_date, 'dd-mon-yyyy'));

665: -- then
666: -- -- First half of month, put to 15th and subtract a period.
667: -- temp_date := to_date(('15' || rest_of_date), 'DD-MON-YYYY');
668: -- temp_date := prev_semi_month(temp_date) + p_pay_date_offset;
669: -- hr_utility.trace('1st half ' || to_char(temp_date, 'dd-mon-yyyy'));
670: -- return(temp_date);
671: -- else
672: -- -- We are in second half of month.
673: -- temp_date := last_day(p_target_date);

Line 675: -- hr_utility.trace('2nd half ' || to_char(temp_date, 'dd-mon-yyyy'));

671: -- else
672: -- -- We are in second half of month.
673: -- temp_date := last_day(p_target_date);
674: -- temp_date := prev_semi_month(temp_date) + p_pay_date_offset;
675: -- hr_utility.trace('2nd half ' || to_char(temp_date, 'dd-mon-yyyy'));
676: -- return(temp_date);
677: -- end if;
678: -- OLD CODE
679: end if;

Line 703: hr_utility.set_location(func_name, 1);

699: temp_day varchar2(2);
700: func_name CONSTANT varchar2(50) := 'za_pay_calendars.next_semi_month';
701:
702: begin
703: hr_utility.set_location(func_name, 1);
704: day_of_month := substr(to_char(p_fpe_date, 'DD-MON-YYYY'), 1, 2);
705: if (day_of_month = '15') OR (last_day(p_fpe_date) = p_fpe_date) then
706: -- The first period's end-date is either the 15th or the end-of-month
707: if last_day(p_semi_month_date) = p_semi_month_date then

Line 760: hr_utility.set_location(func_name, 1);

756: func_name CONSTANT varchar2(50) := 'za_pay_calendars.prev_semi_month';
757:
758: begin
759: -- Get the day of the current month.
760: hr_utility.set_location(func_name, 1);
761: day_of_month := substr(to_char(p_fpe_date, 'DD-MON-YYYY'), 1, 2);
762: if (day_of_month = '15') OR (last_day(p_fpe_date) = p_fpe_date) then
763: -- The first period's end-date is either the 15th or the end-of-month
764: if last_day(p_semi_month_date) = p_semi_month_date then

Line 893: hr_utility.set_location(func_name, 1);

889:
890: ---------------------------------------------------------------------------------------
891: -- Determine the first tax year start in the generation period
892: ---------------------------------------------------------------------------------------
893: hr_utility.set_location(func_name, 1);
894: declare
895: l_tax_year2 date;
896: begin
897: -- Obtain the first period's start date

Line 1054: hr_utility.set_message(800, 'PAY_NO_PERIOD_DETAILS');

1050:
1051: exception
1052: -- No details exists for this period type
1053: when no_data_found then
1054: hr_utility.set_message(800, 'PAY_NO_PERIOD_DETAILS');
1055: hr_utility.raise_error;
1056: end;
1057:
1058: -- Loop through all the periods until you are finished

Line 1055: hr_utility.raise_error;

1051: exception
1052: -- No details exists for this period type
1053: when no_data_found then
1054: hr_utility.set_message(800, 'PAY_NO_PERIOD_DETAILS');
1055: hr_utility.raise_error;
1056: end;
1057:
1058: -- Loop through all the periods until you are finished
1059: while not get_periods%notfound loop

Line 1215: hr_utility.set_location(func_name, 1);

1211:
1212: ---------------------------------------------------------------------------------------
1213: -- Determine the first calendar year start in the generation period
1214: ---------------------------------------------------------------------------------------
1215: hr_utility.set_location(func_name, 1);
1216: declare
1217: l_cal_year2 date;
1218: begin
1219: -- Obtain the first period's start date

Line 1374: hr_utility.set_message(800, 'PAY_NO_PERIOD_DETAILS');

1370:
1371: exception
1372: -- No details exists for this period type
1373: when no_data_found then
1374: hr_utility.set_message(800, 'PAY_NO_PERIOD_DETAILS');
1375: hr_utility.raise_error;
1376:
1377: end;
1378:

Line 1375: hr_utility.raise_error;

1371: exception
1372: -- No details exists for this period type
1373: when no_data_found then
1374: hr_utility.set_message(800, 'PAY_NO_PERIOD_DETAILS');
1375: hr_utility.raise_error;
1376:
1377: end;
1378:
1379: -- Loop through all the periods until you are finished

Line 1531: hr_utility.set_location(func_name, 1);

1527: end_date DESC;
1528:
1529: begin
1530:
1531: hr_utility.set_location(func_name, 1);
1532: begin
1533: -- Determine the tax year of the first period
1534: select
1535: prd_information1

Line 1790: hr_utility.set_location(func_name, 1);

1786: end_date;
1787:
1788: begin
1789:
1790: hr_utility.set_location(func_name, 1);
1791: open tax_years;
1792: fetch tax_years into l_tax_year;
1793: if tax_years%notfound then
1794: -- This should never happen