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

Line 121: hr_utility.set_message(801,'HR_MANDATORY_PARAMETER');

117: begin
118: --
119: if p_group = 'Y' then null;
120: elsif p_business_group_id IS NULL then
121: hr_utility.set_message(801,'HR_MANDATORY_PARAMETER');
122: hr_utility.set_message_token('PARAMETER_NAME','Business Group');
123: hr_utility.raise_error;
124: end if;
125: --

Line 122: hr_utility.set_message_token('PARAMETER_NAME','Business Group');

118: --
119: if p_group = 'Y' then null;
120: elsif p_business_group_id IS NULL then
121: hr_utility.set_message(801,'HR_MANDATORY_PARAMETER');
122: hr_utility.set_message_token('PARAMETER_NAME','Business Group');
123: hr_utility.raise_error;
124: end if;
125: --
126: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',1);

Line 123: hr_utility.raise_error;

119: if p_group = 'Y' then null;
120: elsif p_business_group_id IS NULL then
121: hr_utility.set_message(801,'HR_MANDATORY_PARAMETER');
122: hr_utility.set_message_token('PARAMETER_NAME','Business Group');
123: hr_utility.raise_error;
124: end if;
125: --
126: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',1);
127: --

Line 126: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',1);

122: hr_utility.set_message_token('PARAMETER_NAME','Business Group');
123: hr_utility.raise_error;
124: end if;
125: --
126: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',1);
127: --
128: SELECT hr_organization_units_s.nextval
129: INTO l_organization_id
130: FROM sys.dual ;

Line 138: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',2);

134: --
135: hr_organization.date_range(nvl(p_date_from,trunc(SYSDATE)),p_date_to);
136: --
137: --
138: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',2);
139: --
140: INSERT INTO HR_ALL_ORGANIZATION_UNITS
141: (organization_id
142: ,business_group_id

Line 175: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',3);

171: ,0
172: ,SYSDATE
173: FROM sys.dual ;
174: --
175: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',3);
176: --
177: OPEN get_languages;
178: --
179: LOOP

Line 208: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',4);

204: FROM sys.dual ;
205: --
206: END LOOP;
207: --
208: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',4);
209: --
210: return l_organization_id;
211: --
212: --

Line 257: hr_utility.set_location('pay_us_db_per_setup.create_business_group',1);

253: --
254: begin
255: --
256: --
257: hr_utility.set_location('pay_us_db_per_setup.create_business_group',1);
258: SELECT id_flex_num
259: INTO l_position_num
260: FROM fnd_id_flex_structures_vl
261: WHERE id_flex_code = 'POS'

Line 264: hr_utility.set_location('pay_us_db_per_setup.create_business_group',2);

260: FROM fnd_id_flex_structures_vl
261: WHERE id_flex_code = 'POS'
262: AND id_flex_structure_name = p_position_structure;
263: --
264: hr_utility.set_location('pay_us_db_per_setup.create_business_group',2);
265: SELECT id_flex_num
266: INTO l_grade_num
267: FROM fnd_id_flex_structures_vl
268: WHERE id_flex_code = 'GRD'

Line 271: hr_utility.set_location('pay_us_db_per_setup.create_business_group',3);

267: FROM fnd_id_flex_structures_vl
268: WHERE id_flex_code = 'GRD'
269: AND id_flex_structure_name = p_grade_structure;
270: --
271: hr_utility.set_location('pay_us_db_per_setup.create_business_group',3);
272: SELECT id_flex_num
273: INTO l_job_num
274: FROM fnd_id_flex_structures_vl
275: WHERE id_flex_code = 'JOB'

Line 278: hr_utility.set_location('pay_us_db_per_setup.create_business_group',4);

274: FROM fnd_id_flex_structures_vl
275: WHERE id_flex_code = 'JOB'
276: AND id_flex_structure_name = p_job_structure;
277: --
278: hr_utility.set_location('pay_us_db_per_setup.create_business_group',4);
279: SELECT id_flex_num
280: INTO l_people_group_num
281: FROM fnd_id_flex_structures_vl
282: WHERE id_flex_code = 'GRP'

Line 285: hr_utility.set_location('pay_us_db_per_setup.create_business_group',5);

281: FROM fnd_id_flex_structures_vl
282: WHERE id_flex_code = 'GRP'
283: AND id_flex_structure_name = p_people_group_structure;
284: --
285: hr_utility.set_location('pay_us_db_per_setup.create_business_group',5);
286: SELECT id_flex_num
287: INTO l_cost_allocation_num
288: FROM fnd_id_flex_structures_vl
289: WHERE id_flex_code = 'COST'

Line 292: hr_utility.set_location('pay_us_db_per_setup.create_business_group',6);

288: FROM fnd_id_flex_structures_vl
289: WHERE id_flex_code = 'COST'
290: AND id_flex_structure_name = p_cost_allocation_structure;
291: --
292: hr_utility.set_location('pay_us_db_per_setup.create_business_group',6);
293: l_business_group_id := insert_organization_unit('Y'
294: ,p_name
295: ,null
296: ,null

Line 306: hr_utility.set_location('pay_us_db_per_setup.create_business_group',7);

302: ,p_internal_address_line
303: ,null);
304: --
305: --
306: hr_utility.set_location('pay_us_db_per_setup.create_business_group',7);
307: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
308: l_business_group_id
309: ,'CLASS'
310: ,'HR_BG'

Line 332: hr_utility.set_location('pay_us_db_per_setup.create_business_group',8);

328: ,null
329: ,null);
330: --
331: --
332: hr_utility.set_location('pay_us_db_per_setup.create_business_group',8);
333: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
334: l_business_group_id
335: ,'CLASS'
336: ,'HR_ORG'

Line 358: hr_utility.set_location('pay_us_db_per_setup.create_business_group',9);

354: ,null
355: ,null);
356: --
357: --
358: hr_utility.set_location('pay_us_db_per_setup.create_business_group',9);
359: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
360: l_business_group_id
361: ,'Business Group Information'
362: ,p_short_name

Line 384: hr_utility.set_location('pay_us_db_per_setup.create_business_group',10);

380: ,null
381: ,null);
382: --
383: --
384: hr_utility.set_location('pay_us_db_per_setup.create_business_group',10);
385: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
386: l_business_group_id
387: ,'Work Day Information'
388: ,p_default_start_time

Line 412: hr_utility.set_location('pay_us_db_per_setup.create_business_group',11);

408: --
409: -- Reporting Categories and Reporting Statuses are for use in VETS-100
410: -- System Test
411: --
412: hr_utility.set_location('pay_us_db_per_setup.create_business_group',11);
413: --
414: if p_employment_category_1 is not null then
415: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
416: l_business_group_id

Line 441: hr_utility.set_location('pay_us_db_per_setup.create_business_group',12);

437: ,null);
438: end if;
439: --
440: --
441: hr_utility.set_location('pay_us_db_per_setup.create_business_group',12);
442: if p_employment_category_2 is not null then
443: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
444: l_business_group_id
445: ,'Reporting Categories'

Line 469: hr_utility.set_location('pay_us_db_per_setup.create_business_group',13);

465: ,null);
466: end if;
467: --
468: --
469: hr_utility.set_location('pay_us_db_per_setup.create_business_group',13);
470: if p_assignment_status_1 is not null then
471: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
472: l_business_group_id
473: ,'Reporting Statuses'

Line 497: hr_utility.set_location('pay_us_db_per_setup.create_business_group',14);

493: ,null);
494: end if;
495: --
496: --
497: hr_utility.set_location('pay_us_db_per_setup.create_business_group',14);
498: if p_assignment_status_2 is not null then
499: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
500: l_business_group_id
501: ,'Reporting Statuses'

Line 554: hr_utility.trace('Entered Create_Per_Organization ');

550: --
551: begin
552: --
553: --
554: hr_utility.trace('Entered Create_Per_Organization ');
555: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);
556: --
557: SELECT business_group_id
558: INTO l_business_group_id

Line 555: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);

551: begin
552: --
553: --
554: hr_utility.trace('Entered Create_Per_Organization ');
555: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);
556: --
557: SELECT business_group_id
558: INTO l_business_group_id
559: FROM per_business_groups

Line 573: hr_utility.trace('Called insert_information_unit from CPO');

569: ,p_date_to
570: ,p_internal_external_flag
571: ,p_internal_address_line
572: ,p_type);
573: hr_utility.trace('Called insert_information_unit from CPO');
574: --
575: --
576: --
577: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(l_organization_id

Line 599: hr_utility.trace('Called insert_org_information once from CPO');

595: ,null
596: ,null
597: ,null
598: ,null);
599: hr_utility.trace('Called insert_org_information once from CPO');
600: --
601: --
602: --
603: hr_utility.trace('p_default_start_time '||p_default_start_time);

Line 603: hr_utility.trace('p_default_start_time '||p_default_start_time);

599: hr_utility.trace('Called insert_org_information once from CPO');
600: --
601: --
602: --
603: hr_utility.trace('p_default_start_time '||p_default_start_time);
604:
605: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(l_organization_id
606: ,'Work Day Information'
607: ,p_default_start_time

Line 627: hr_utility.trace('Called insert_org_information twice from CPO');

623: ,null
624: ,null
625: ,null
626: ,null);
627: hr_utility.trace('Called insert_org_information twice from CPO');
628: --
629: return l_organization_id;
630: --
631: end create_per_organization;

Line 667: hr_utility.trace('Entered Create_Est_Organization ');

663: --
664: begin
665: --
666: --
667: hr_utility.trace('Entered Create_Est_Organization ');
668: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);
669: --
670: SELECT business_group_id
671: INTO l_business_group_id

Line 668: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);

664: begin
665: --
666: --
667: hr_utility.trace('Entered Create_Est_Organization ');
668: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);
669: --
670: SELECT business_group_id
671: INTO l_business_group_id
672: FROM per_business_groups

Line 686: hr_utility.trace('Called insert_information_unit from CEO');

682: ,p_date_to
683: ,p_internal_external_flag
684: ,p_internal_address_line
685: ,p_type);
686: hr_utility.trace('Called insert_information_unit from CEO');
687: --
688: -- Add new classification : HR_ESTAB
689: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
690: l_organization_id

Line 737: hr_utility.trace('Called insert_org_information once from CEO');

733: ,null
734: ,null
735: ,null
736: ,null);
737: hr_utility.trace('Called insert_org_information once from CEO');
738: --
739: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information
740: (l_organization_id
741: ,'Establishment EEO-1 Filing'

Line 838: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',1);

834: l_business_group_id NUMBER;
835: --
836: begin
837: --
838: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',1);
839: --
840: SELECT business_group_id
841: INTO l_business_group_id
842: FROM hr_all_organization_units

Line 860: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',2);

856: ,p_org_type);
857: --
858: --
859: --
860: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',2);
861: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
862: l_legal_company_id
863: ,'CLASS'
864: ,'HR_ORG'

Line 887: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',3);

883: ,null);
884: --
885: --
886: --
887: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',3);
888: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
889: l_legal_company_id
890: ,'CLASS'
891: ,'HR_LEGAL'

Line 992: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',4);

988: end if;
989: --
990: -- Modified RMAMGAIN
991: -- Modified MSWANSON 'Nacha' to 'NACHA'.
992: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',4);
993: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
994: l_legal_company_id
995: ,'NACHA Rules'
996: ,P_NACHA_COMPANY_NAME

Line 1018: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',5);

1014: ,null
1015: ,null);
1016: --
1017: -- Inserted by RMAMGAIN
1018: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',5);
1019: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1020: l_legal_company_id
1021: ,'Multiple Worksite Reporting' -- context
1022: ,'Y' -- transmitter_flag

Line 1043: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',6);

1039: ,null
1040: ,null
1041: ,null);
1042: -- Inserted By RMAMGAIN
1043: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',6);
1044: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1045: l_legal_company_id
1046: ,'W2 Reporting Rules' -- context
1047: ,'Y' -- transmitter_flag

Line 1068: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',7);

1064: ,null
1065: ,null
1066: ,null);
1067: -- Inserted by RMAMGAIN
1068: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',7);
1069: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1070: l_legal_company_id
1071: ,'Employer Identification' -- context
1072: ,P_COMPANY_FEDERAL_IDENTIFIER

Line 1093: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',8);

1089: ,null
1090: ,null
1091: ,null);
1092: -- Inserted by AKELLY
1093: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',8);
1094: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1095: l_legal_company_id
1096: ,'Work Schedule' -- context
1097: ,P_WORK_SCHEDULE_TABLE

Line 1118: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',9);

1114: ,null
1115: ,null
1116: ,null);
1117: -- Inserted by AKELLY
1118: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',9);
1119: if P_SS_SELF_ADJUST_METHOD IS NULL
1120: and P_MED_SELF_ADJUST_METHOD IS NULL
1121: and P_FUTA_SELF_ADJUST_METHOD IS NULL
1122: and P_TYPE_OF_EMPLOYMENT IS NULL

Line 1153: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);

1149: ,null);
1150: end if;
1151: --
1152: -- Inserted by MSWANSON
1153: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);
1154: --
1155: -- Inserted by MSWANSON
1156: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);
1157: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(

Line 1156: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);

1152: -- Inserted by MSWANSON
1153: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);
1154: --
1155: -- Inserted by MSWANSON
1156: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',10);
1157: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information(
1158: l_legal_company_id
1159: ,'EEO-1 Filing' -- context
1160: ,P_EEO1_IDENTIFICATION_NUMBER

Line 1432: hr_utility.set_message(801,'PAY_7686_USER_JOB_TAB_UNIQUE');

1428: AND p_job_name = jb.name
1429: AND p_business_group_id = jb.business_group_id + 0;
1430: --
1431: if job_check = 'Y' then
1432: hr_utility.set_message(801,'PAY_7686_USER_JOB_TAB_UNIQUE');
1433: hr_utility.raise_error;
1434: end if;
1435: --
1436: exception

Line 1433: hr_utility.raise_error;

1429: AND p_business_group_id = jb.business_group_id + 0;
1430: --
1431: if job_check = 'Y' then
1432: hr_utility.set_message(801,'PAY_7686_USER_JOB_TAB_UNIQUE');
1433: hr_utility.raise_error;
1434: end if;
1435: --
1436: exception
1437: when NO_DATA_FOUND then null ;

Line 1448: hr_utility.set_location('pay_us_db_per_setup.insert_job_definition',1);

1444: l_job_definition_id NUMBER;
1445: --
1446: begin
1447: --
1448: hr_utility.set_location('pay_us_db_per_setup.insert_job_definition',1);
1449: --
1450: SELECT per_job_definitions_s.nextval
1451: INTO l_job_definition_id
1452: FROM sys.dual;

Line 1454: hr_utility.set_location('pay_us_db_per_setup.insert_job_definition',2);

1450: SELECT per_job_definitions_s.nextval
1451: INTO l_job_definition_id
1452: FROM sys.dual;
1453: --
1454: hr_utility.set_location('pay_us_db_per_setup.insert_job_definition',2);
1455: --
1456: INSERT INTO per_job_definitions
1457: (JOB_DEFINITION_ID
1458: ,ID_FLEX_NUM

Line 1544: hr_utility.set_location('pay_us_db_per_setup.insert_job',1);

1540: l_job_id NUMBER;
1541: --
1542: begin
1543: --
1544: hr_utility.set_location('pay_us_db_per_setup.insert_job',1);
1545: --
1546: SELECT per_jobs_s.nextval
1547: INTO l_job_id
1548: FROM sys.dual;

Line 1550: hr_utility.set_location('pay_us_db_per_setup.insert_job',2);

1546: SELECT per_jobs_s.nextval
1547: INTO l_job_id
1548: FROM sys.dual;
1549: --
1550: hr_utility.set_location('pay_us_db_per_setup.insert_job',2);
1551: --
1552: unique_name(l_business_group_id,l_job_id, p_name);
1553: --
1554: hr_utility.set_location('pay_us_db_per_setup.insert_job',3);

Line 1554: hr_utility.set_location('pay_us_db_per_setup.insert_job',3);

1550: hr_utility.set_location('pay_us_db_per_setup.insert_job',2);
1551: --
1552: unique_name(l_business_group_id,l_job_id, p_name);
1553: --
1554: hr_utility.set_location('pay_us_db_per_setup.insert_job',3);
1555: --
1556: INSERT INTO per_jobs
1557: (JOB_ID
1558: ,BUSINESS_GROUP_ID

Line 1595: hr_utility.set_location('pay_us_db_per_setup.create_job',1);

1591: --
1592: begin -- FUNCTION create_job
1593: --
1594: --
1595: hr_utility.set_location('pay_us_db_per_setup.create_job',1);
1596: --
1597: SELECT business_group_id
1598: , job_structure
1599: INTO l_business_group_id

Line 1708: hr_utility.set_message(801,'PAY_7688_USER_POS_TAB_UNIQUE');

1704: AND p_position_name = pos.name
1705: AND p_business_group_id = pos.business_group_id + 0;
1706: --
1707: if pos_check = 'Y' then
1708: hr_utility.set_message(801,'PAY_7688_USER_POS_TAB_UNIQUE');
1709: hr_utility.raise_error;
1710: end if;
1711: --
1712: exception

Line 1709: hr_utility.raise_error;

1705: AND p_business_group_id = pos.business_group_id + 0;
1706: --
1707: if pos_check = 'Y' then
1708: hr_utility.set_message(801,'PAY_7688_USER_POS_TAB_UNIQUE');
1709: hr_utility.raise_error;
1710: end if;
1711: --
1712: exception
1713: when NO_DATA_FOUND then null ;

Line 1724: hr_utility.set_location('pay_us_db_per_setup.insert_pos_definition',1);

1720: l_pos_definition_id NUMBER;
1721: --
1722: begin
1723: --
1724: hr_utility.set_location('pay_us_db_per_setup.insert_pos_definition',1);
1725: --
1726: SELECT per_position_definitions_s.nextval
1727: INTO l_pos_definition_id
1728: FROM sys.dual;

Line 1730: hr_utility.set_location('pay_us_db_per_setup.insert_pos_definition',2);

1726: SELECT per_position_definitions_s.nextval
1727: INTO l_pos_definition_id
1728: FROM sys.dual;
1729: --
1730: hr_utility.set_location('pay_us_db_per_setup.insert_pos_definition',2);
1731: --
1732: INSERT INTO per_position_definitions
1733: (POSITION_DEFINITION_ID
1734: ,ID_FLEX_NUM

Line 1820: hr_utility.set_location('pay_us_db_per_setup.insert_position',1);

1816: l_position_id NUMBER;
1817: --
1818: begin
1819: --
1820: hr_utility.set_location('pay_us_db_per_setup.insert_position',1);
1821: --
1822: SELECT per_positions_s.nextval
1823: INTO l_position_id
1824: FROM sys.dual;

Line 1826: hr_utility.set_location('pay_us_db_per_setup.insert_position',2);

1822: SELECT per_positions_s.nextval
1823: INTO l_position_id
1824: FROM sys.dual;
1825: --
1826: hr_utility.set_location('pay_us_db_per_setup.insert_position',2);
1827: --
1828: unique_name(l_business_group_id, l_position_id, p_name);
1829: --
1830: hr_utility.set_location('pay_us_db_per_setup.insert_position',3);

Line 1830: hr_utility.set_location('pay_us_db_per_setup.insert_position',3);

1826: hr_utility.set_location('pay_us_db_per_setup.insert_position',2);
1827: --
1828: unique_name(l_business_group_id, l_position_id, p_name);
1829: --
1830: hr_utility.set_location('pay_us_db_per_setup.insert_position',3);
1831: --
1832: INSERT INTO per_positions
1833: (POSITION_ID
1834: ,BUSINESS_GROUP_ID

Line 1892: hr_utility.set_location('pay_us_db_per_setup.create_position',1);

1888: begin -- FUNCTION create_position
1889: --
1890: --
1891: --
1892: hr_utility.set_location('pay_us_db_per_setup.create_position',1);
1893: --
1894: SELECT business_group_id
1895: , position_structure
1896: INTO l_business_group_id

Line 1902: hr_utility.set_location('pay_us_db_per_setup.create_position',2);

1898: FROM per_business_groups
1899: WHERE name = p_business_group
1900: AND business_group_id + 0 <> 0;
1901: --
1902: hr_utility.set_location('pay_us_db_per_setup.create_position',2);
1903: --
1904: SELECT job_id
1905: INTO l_job_id
1906: FROM per_jobs

Line 1910: hr_utility.set_location('pay_us_db_per_setup.create_position',3);

1906: FROM per_jobs
1907: WHERE name = p_job
1908: AND business_group_id + 0 = l_business_group_id;
1909: --
1910: hr_utility.set_location('pay_us_db_per_setup.create_position',3);
1911: --
1912: SELECT organization_id
1913: INTO l_organization_id
1914: FROM per_organization_units

Line 1920: hr_utility.set_location('pay_us_db_per_setup.create_position',4);

1916: AND business_group_id + 0 = l_business_group_id;
1917: --
1918: begin
1919: --
1920: hr_utility.set_location('pay_us_db_per_setup.create_position',4);
1921: --
1922: SELECT location_id
1923: INTO l_location_id
1924: FROM hr_locations

Line 1927: hr_utility.set_location('pay_us_db_per_setup.create_position',5);

1923: INTO l_location_id
1924: FROM hr_locations
1925: WHERE location_code = p_location;
1926: --
1927: hr_utility.set_location('pay_us_db_per_setup.create_position',5);
1928: --
1929: SELECT position_id
1930: INTO l_relief_position_id
1931: FROM per_positions

Line 1934: hr_utility.set_location('pay_us_db_per_setup.create_position',6);

1930: INTO l_relief_position_id
1931: FROM per_positions
1932: WHERE name = p_relief_position;
1933: --
1934: hr_utility.set_location('pay_us_db_per_setup.create_position',6);
1935: --
1936: SELECT position_id
1937: INTO l_successor_position_id
1938: FROM per_positions

Line 2030: hr_utility.set_message(801,'PAY_7687_USER_GRADE_TAB_UNIQUE');

2026: AND p_grade_name = grd.name
2027: AND p_business_group_id = grd.business_group_id + 0;
2028: --
2029: if grd_check = 'Y' then
2030: hr_utility.set_message(801,'PAY_7687_USER_GRADE_TAB_UNIQUE');
2031: hr_utility.raise_error;
2032: end if;
2033: --
2034: exception

Line 2031: hr_utility.raise_error;

2027: AND p_business_group_id = grd.business_group_id + 0;
2028: --
2029: if grd_check = 'Y' then
2030: hr_utility.set_message(801,'PAY_7687_USER_GRADE_TAB_UNIQUE');
2031: hr_utility.raise_error;
2032: end if;
2033: --
2034: exception
2035: when NO_DATA_FOUND then null ;

Line 2047: hr_utility.set_location('pay_us_db_per_setup.insert_grade_definition',1);

2043: l_grade_definition_id NUMBER;
2044: --
2045: begin
2046: --
2047: hr_utility.set_location('pay_us_db_per_setup.insert_grade_definition',1);
2048: --
2049: SELECT per_grade_definitions_s.nextval
2050: INTO l_grade_definition_id
2051: FROM sys.dual;

Line 2053: hr_utility.set_location('pay_us_db_per_setup.insert_grade_definition',2);

2049: SELECT per_grade_definitions_s.nextval
2050: INTO l_grade_definition_id
2051: FROM sys.dual;
2052: --
2053: hr_utility.set_location('pay_us_db_per_setup.insert_grade_definition',2);
2054: --
2055: INSERT INTO per_grade_definitions
2056: (GRADE_DEFINITION_ID
2057: ,ID_FLEX_NUM

Line 2143: hr_utility.set_location('pay_us_db_per_setup.insert_grade',1);

2139: l_grade_id NUMBER;
2140: --
2141: begin
2142: --
2143: hr_utility.set_location('pay_us_db_per_setup.insert_grade',1);
2144: --
2145: SELECT per_grades_s.nextval
2146: INTO l_grade_id
2147: FROM sys.dual;

Line 2149: hr_utility.set_location('pay_us_db_per_setup.insert_grade',2);

2145: SELECT per_grades_s.nextval
2146: INTO l_grade_id
2147: FROM sys.dual;
2148: --
2149: hr_utility.set_location('pay_us_db_per_setup.insert_grade',2);
2150: --
2151: unique_name(l_business_group_id, l_grade_id, p_name);
2152: --
2153: hr_utility.set_location('pay_us_db_per_setup.insert_grade',3);

Line 2153: hr_utility.set_location('pay_us_db_per_setup.insert_grade',3);

2149: hr_utility.set_location('pay_us_db_per_setup.insert_grade',2);
2150: --
2151: unique_name(l_business_group_id, l_grade_id, p_name);
2152: --
2153: hr_utility.set_location('pay_us_db_per_setup.insert_grade',3);
2154: --
2155: INSERT INTO per_grades
2156: (GRADE_ID
2157: ,BUSINESS_GROUP_ID

Line 2192: hr_utility.set_location('pay_us_db_per_setup.create_grade',1);

2188: --
2189: begin -- FUNCTION create_grade
2190: --
2191: --
2192: hr_utility.set_location('pay_us_db_per_setup.create_grade',1);
2193: --
2194: SELECT business_group_id
2195: , grade_structure
2196: INTO l_business_group_id

Line 2227: hr_utility.trace('Entered insert_wc_fund');

2223: --
2224: l_fund_id number(15);
2225: BEGIN
2226: --
2227: hr_utility.trace('Entered insert_wc_fund');
2228: hr_utility.set_location('scltstdat.insert_wc_fund',1);
2229: --
2230: SELECT PAY_WC_FUNDS_S.NEXTVAL
2231: INTO l_fund_id

Line 2228: hr_utility.set_location('scltstdat.insert_wc_fund',1);

2224: l_fund_id number(15);
2225: BEGIN
2226: --
2227: hr_utility.trace('Entered insert_wc_fund');
2228: hr_utility.set_location('scltstdat.insert_wc_fund',1);
2229: --
2230: SELECT PAY_WC_FUNDS_S.NEXTVAL
2231: INTO l_fund_id
2232: FROM DUAL;

Line 2234: hr_utility.set_location('scltstdat.insert_wc_fund',5);

2230: SELECT PAY_WC_FUNDS_S.NEXTVAL
2231: INTO l_fund_id
2232: FROM DUAL;
2233: --
2234: hr_utility.set_location('scltstdat.insert_wc_fund',5);
2235: --
2236: IF (SQL%NOTFOUND) THEN
2237: RAISE NO_DATA_FOUND;
2238: END IF;

Line 2240: hr_utility.set_location('scltstdat.insert_wc_fund',10);

2236: IF (SQL%NOTFOUND) THEN
2237: RAISE NO_DATA_FOUND;
2238: END IF;
2239: --
2240: hr_utility.set_location('scltstdat.insert_wc_fund',10);
2241: --
2242: INSERT INTO PAY_WC_FUNDS
2243: (FUND_ID, BUSINESS_GROUP_ID, CARRIER_ID, LOCATION_ID, STATE_CODE)
2244: VALUES

Line 2248: hr_utility.set_location('scltstdat.insert_wc_fund',15);

2244: VALUES
2245: (L_FUND_ID, P_BUSINESS_GROUP_ID, P_CARRIER_ID, P_LOCATION_ID,
2246: P_STATE_CODE);
2247: --
2248: hr_utility.set_location('scltstdat.insert_wc_fund',15);
2249: --
2250: return l_fund_id;
2251: --
2252: END INSERT_WC_FUND;

Line 2266: hr_utility.trace('Entered insert_wc_rate');

2262: l_wc_code NUMBER;
2263: --
2264: BEGIN
2265: --
2266: hr_utility.trace('Entered insert_wc_rate');
2267: hr_utility.set_location('scltstdat.insert_wc_rate',1);
2268: --
2269: SELECT PAY_WC_RATES_S.NEXTVAL
2270: INTO l_wc_code

Line 2267: hr_utility.set_location('scltstdat.insert_wc_rate',1);

2263: --
2264: BEGIN
2265: --
2266: hr_utility.trace('Entered insert_wc_rate');
2267: hr_utility.set_location('scltstdat.insert_wc_rate',1);
2268: --
2269: SELECT PAY_WC_RATES_S.NEXTVAL
2270: INTO l_wc_code
2271: FROM DUAL;

Line 2273: hr_utility.set_location('scltstdat.insert_wc_rate',5);

2269: SELECT PAY_WC_RATES_S.NEXTVAL
2270: INTO l_wc_code
2271: FROM DUAL;
2272: --
2273: hr_utility.set_location('scltstdat.insert_wc_rate',5);
2274: --
2275: IF (SQL%NOTFOUND) THEN
2276: RAISE NO_DATA_FOUND;
2277: END IF;

Line 2279: hr_utility.set_location('scltstdat.insert_wc_rate',10);

2275: IF (SQL%NOTFOUND) THEN
2276: RAISE NO_DATA_FOUND;
2277: END IF;
2278: --
2279: hr_utility.set_location('scltstdat.insert_wc_rate',10);
2280: --
2281: INSERT INTO
2282: pay_wc_rates
2283: (wc_code

Line 2303: hr_utility.set_location('scltstdat.insert_wc_rate',15);

2299: ,0
2300: ,sysdate
2301: ,0 );
2302: --
2303: hr_utility.set_location('scltstdat.insert_wc_rate',15);
2304: --
2305: return l_wc_code;
2306: --
2307: end insert_wc_rate;

Line 2328: hr_utility.trace('Entered Create_us_location');

2324: l_location_id NUMBER(15);
2325: --
2326: BEGIN
2327: --
2328: hr_utility.trace('Entered Create_us_location');
2329: hr_utility.set_location('scltstdat.create_us_location',1);
2330: --
2331: select hr_locations_s.nextval
2332: into l_location_id

Line 2329: hr_utility.set_location('scltstdat.create_us_location',1);

2325: --
2326: BEGIN
2327: --
2328: hr_utility.trace('Entered Create_us_location');
2329: hr_utility.set_location('scltstdat.create_us_location',1);
2330: --
2331: select hr_locations_s.nextval
2332: into l_location_id
2333: from sys.dual;

Line 2335: hr_utility.set_location('scltstdat.create_us_location',5);

2331: select hr_locations_s.nextval
2332: into l_location_id
2333: from sys.dual;
2334: --
2335: hr_utility.set_location('scltstdat.create_us_location',5);
2336: --
2337: INSERT INTO hr_locations
2338: (location_id
2339: ,entered_by

Line 2379: hr_utility.set_location('scltstdat.create_us_location',10);

2375: ,0
2376: ,sysdate
2377: ,0 );
2378: --
2379: hr_utility.set_location('scltstdat.create_us_location',10);
2380: --
2381: return l_location_id;
2382: --
2383: end create_us_location;

Line 2405: hr_utility.trace('Entered Create_wc_carrier');

2401: --
2402: begin
2403: --
2404: --
2405: hr_utility.trace('Entered Create_wc_carrier');
2406: hr_utility.set_location('scltstdat.create_wc_carrier',1);
2407: --
2408: SELECT business_group_id
2409: INTO l_business_group_id

Line 2406: hr_utility.set_location('scltstdat.create_wc_carrier',1);

2402: begin
2403: --
2404: --
2405: hr_utility.trace('Entered Create_wc_carrier');
2406: hr_utility.set_location('scltstdat.create_wc_carrier',1);
2407: --
2408: SELECT business_group_id
2409: INTO l_business_group_id
2410: FROM per_business_groups

Line 2425: hr_utility.trace('Called insert_information_unit from create_wc_carrier');

2421: ,p_date_to
2422: ,p_internal_external_flag
2423: ,p_internal_address_line
2424: ,p_type);
2425: hr_utility.trace('Called insert_information_unit from create_wc_carrier');
2426: --
2427: --
2428: l_org_information_id := pay_us_ins_org_info_pkg.insert_org_information
2429: (l_wc_carrier_id

Line 2451: hr_utility.trace('Called create_wc_carrier');

2447: ,null
2448: ,null
2449: ,null
2450: ,null);
2451: hr_utility.trace('Called create_wc_carrier');
2452: --
2453: --
2454: return l_wc_carrier_id;
2455: --