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

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

111: begin
112: --
113: if p_group = 'Y' then null;
114: elsif p_business_group_id IS NULL then
115: hr_utility.set_message(801,'HR_MANDATORY_PARAMETER');
116: hr_utility.set_message_token('PARAMETER_NAME','Business Group');
117: hr_utility.raise_error;
118: end if;
119: --

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

112: --
113: if p_group = 'Y' then null;
114: elsif p_business_group_id IS NULL then
115: hr_utility.set_message(801,'HR_MANDATORY_PARAMETER');
116: hr_utility.set_message_token('PARAMETER_NAME','Business Group');
117: hr_utility.raise_error;
118: end if;
119: --
120: hr_utility.set_location('per_db_per_setup.insert_organization_unit',1);

Line 117: hr_utility.raise_error;

113: if p_group = 'Y' then null;
114: elsif p_business_group_id IS NULL then
115: hr_utility.set_message(801,'HR_MANDATORY_PARAMETER');
116: hr_utility.set_message_token('PARAMETER_NAME','Business Group');
117: hr_utility.raise_error;
118: end if;
119: --
120: hr_utility.set_location('per_db_per_setup.insert_organization_unit',1);
121: --

Line 120: hr_utility.set_location('per_db_per_setup.insert_organization_unit',1);

116: hr_utility.set_message_token('PARAMETER_NAME','Business Group');
117: hr_utility.raise_error;
118: end if;
119: --
120: hr_utility.set_location('per_db_per_setup.insert_organization_unit',1);
121: --
122: SELECT hr_organization_units_s.nextval
123: INTO l_organization_id
124: FROM sys.dual ;

Line 133: hr_utility.set_location('per_db_per_setup.insert_organization_unit',2);

129: hr_organization.date_range(nvl(p_date_from,trunc(SYSDATE)),p_date_to);
130: --
131: --
132: --
133: hr_utility.set_location('per_db_per_setup.insert_organization_unit',2);
134: --
135: INSERT INTO HR_ALL_ORGANIZATION_UNITS
136: (organization_id
137: ,business_group_id

Line 242: hr_utility.trace('Entered insert_org_information');

238: l_check VARCHAR2(1);
239: --
240: begin
241: --
242: hr_utility.trace('Entered insert_org_information');
243: --
244: hr_utility.set_location('per_db_per_setup.insert_org_information',1);
245: if p_organization_id IS NULL
246: OR p_org_information_context IS NULL

Line 244: hr_utility.set_location('per_db_per_setup.insert_org_information',1);

240: begin
241: --
242: hr_utility.trace('Entered insert_org_information');
243: --
244: hr_utility.set_location('per_db_per_setup.insert_org_information',1);
245: if p_organization_id IS NULL
246: OR p_org_information_context IS NULL
247: OR p_org_information1 IS NULL
248: then

Line 249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

245: if p_organization_id IS NULL
246: OR p_org_information_context IS NULL
247: OR p_org_information1 IS NULL
248: then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','insert_org_information');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;

Line 250: hr_utility.set_message_token('PROCEDURE','insert_org_information');

246: OR p_org_information_context IS NULL
247: OR p_org_information1 IS NULL
248: then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','insert_org_information');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254: --

Line 251: hr_utility.set_message_token('STEP','1');

247: OR p_org_information1 IS NULL
248: then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','insert_org_information');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254: --
255: hr_utility.set_location('per_db_per_setup.insert_org_information',5);

Line 252: hr_utility.raise_error;

248: then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','insert_org_information');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254: --
255: hr_utility.set_location('per_db_per_setup.insert_org_information',5);
256: SELECT organization_id

Line 255: hr_utility.set_location('per_db_per_setup.insert_org_information',5);

251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254: --
255: hr_utility.set_location('per_db_per_setup.insert_org_information',5);
256: SELECT organization_id
257: INTO l_organization_id
258: FROM hr_organization_units
259: WHERE organization_id = p_organization_id;

Line 261: hr_utility.set_location('per_db_per_setup.insert_org_information',8);

257: INTO l_organization_id
258: FROM hr_organization_units
259: WHERE organization_id = p_organization_id;
260: --
261: hr_utility.set_location('per_db_per_setup.insert_org_information',8);
262: if p_org_information_context = 'CLASS' then
263: SELECT lookup_code
264: INTO l_org_information1
265: FROM hr_lookups

Line 273: hr_utility.set_location('per_db_per_setup.insert_org_information',10);

269: l_org_information_type := p_org_information_context;
270: else
271: l_org_information1 := p_org_information1;
272: begin
273: hr_utility.set_location('per_db_per_setup.insert_org_information',10);
274: SELECT oit.org_information_type
275: INTO l_org_information_type
276: FROM hr_organization_information hoi
277: , hr_org_info_types_by_class tbc

Line 286: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

282: AND hoi.org_information_context = 'CLASS'
283: AND hoi.organization_id = l_organization_id;
284: --
285: exception when NO_DATA_FOUND then
286: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
287: hr_utility.set_message_token('PROCEDURE','insert_org_information');
288: hr_utility.set_message_token('STEP','10');
289: hr_utility.raise_error;
290: end;

Line 287: hr_utility.set_message_token('PROCEDURE','insert_org_information');

283: AND hoi.organization_id = l_organization_id;
284: --
285: exception when NO_DATA_FOUND then
286: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
287: hr_utility.set_message_token('PROCEDURE','insert_org_information');
288: hr_utility.set_message_token('STEP','10');
289: hr_utility.raise_error;
290: end;
291: --

Line 288: hr_utility.set_message_token('STEP','10');

284: --
285: exception when NO_DATA_FOUND then
286: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
287: hr_utility.set_message_token('PROCEDURE','insert_org_information');
288: hr_utility.set_message_token('STEP','10');
289: hr_utility.raise_error;
290: end;
291: --
292: end if;

Line 289: hr_utility.raise_error;

285: exception when NO_DATA_FOUND then
286: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
287: hr_utility.set_message_token('PROCEDURE','insert_org_information');
288: hr_utility.set_message_token('STEP','10');
289: hr_utility.raise_error;
290: end;
291: --
292: end if;
293: --

Line 295: hr_utility.set_location('per_db_per_setup.insert_org_information',15);

291: --
292: end if;
293: --
294: begin
295: hr_utility.set_location('per_db_per_setup.insert_org_information',15);
296: SELECT 'Y'
297: INTO l_check
298: FROM hr_organization_information
299: WHERE organization_id = l_organization_id

Line 304: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

300: AND org_information_context = l_org_information_type
301: AND org_information1 = l_org_information1;
302: --
303: if l_check = 'Y' then
304: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
305: hr_utility.set_message_token('PROCEDURE','insert_org_information');
306: hr_utility.set_message_token('STEP','15');
307: hr_utility.raise_error;
308: end if;

Line 305: hr_utility.set_message_token('PROCEDURE','insert_org_information');

301: AND org_information1 = l_org_information1;
302: --
303: if l_check = 'Y' then
304: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
305: hr_utility.set_message_token('PROCEDURE','insert_org_information');
306: hr_utility.set_message_token('STEP','15');
307: hr_utility.raise_error;
308: end if;
309: --

Line 306: hr_utility.set_message_token('STEP','15');

302: --
303: if l_check = 'Y' then
304: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
305: hr_utility.set_message_token('PROCEDURE','insert_org_information');
306: hr_utility.set_message_token('STEP','15');
307: hr_utility.raise_error;
308: end if;
309: --
310: exception when NO_DATA_FOUND then null;

Line 307: hr_utility.raise_error;

303: if l_check = 'Y' then
304: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
305: hr_utility.set_message_token('PROCEDURE','insert_org_information');
306: hr_utility.set_message_token('STEP','15');
307: hr_utility.raise_error;
308: end if;
309: --
310: exception when NO_DATA_FOUND then null;
311: end;

Line 313: hr_utility.set_location('per_db_per_setup.insert_org_information',20);

309: --
310: exception when NO_DATA_FOUND then null;
311: end;
312: --
313: hr_utility.set_location('per_db_per_setup.insert_org_information',20);
314: SELECT hr_organization_information_s.nextval
315: INTO l_org_information_id
316: FROM sys.dual;
317: --

Line 318: hr_utility.set_location('per_db_per_setup.insert_org_information',25);

314: SELECT hr_organization_information_s.nextval
315: INTO l_org_information_id
316: FROM sys.dual;
317: --
318: hr_utility.set_location('per_db_per_setup.insert_org_information',25);
319: INSERT INTO HR_ORGANIZATION_INFORMATION
320: (org_information_id
321: ,organization_id
322: ,attribute_category

Line 423: hr_utility.set_location('per_db_per_setup.create_business_group',1);

419: --
420: begin
421: --
422: --
423: hr_utility.set_location('per_db_per_setup.create_business_group',1);
424: SELECT id_flex_num
425: INTO l_position_num
426: FROM fnd_id_flex_structures_vl
427: WHERE id_flex_code = 'POS'

Line 430: hr_utility.set_location('per_db_per_setup.create_business_group',2);

426: FROM fnd_id_flex_structures_vl
427: WHERE id_flex_code = 'POS'
428: AND id_flex_structure_name = p_position_structure;
429: --
430: hr_utility.set_location('per_db_per_setup.create_business_group',2);
431: SELECT id_flex_num
432: INTO l_grade_num
433: FROM fnd_id_flex_structures_vl
434: WHERE id_flex_code = 'GRD'

Line 437: hr_utility.set_location('per_db_per_setup.create_business_group',3);

433: FROM fnd_id_flex_structures_vl
434: WHERE id_flex_code = 'GRD'
435: AND id_flex_structure_name = p_grade_structure;
436: --
437: hr_utility.set_location('per_db_per_setup.create_business_group',3);
438: SELECT id_flex_num
439: INTO l_job_num
440: FROM fnd_id_flex_structures_vl
441: WHERE id_flex_code = 'JOB'

Line 444: hr_utility.set_location('per_db_per_setup.create_business_group',4);

440: FROM fnd_id_flex_structures_vl
441: WHERE id_flex_code = 'JOB'
442: AND id_flex_structure_name = p_job_structure;
443: --
444: hr_utility.set_location('per_db_per_setup.create_business_group',4);
445: SELECT id_flex_num
446: INTO l_people_group_num
447: FROM fnd_id_flex_structures_vl
448: WHERE id_flex_code = 'GRP'

Line 451: hr_utility.set_location('per_db_per_setup.create_business_group',5);

447: FROM fnd_id_flex_structures_vl
448: WHERE id_flex_code = 'GRP'
449: AND id_flex_structure_name = p_people_group_structure;
450: --
451: hr_utility.set_location('per_db_per_setup.create_business_group',5);
452: SELECT id_flex_num
453: INTO l_cost_allocation_num
454: FROM fnd_id_flex_structures_vl
455: WHERE id_flex_code = 'COST'

Line 458: hr_utility.set_location('per_db_per_setup.create_business_group',6);

454: FROM fnd_id_flex_structures_vl
455: WHERE id_flex_code = 'COST'
456: AND id_flex_structure_name = p_cost_allocation_structure;
457: --
458: hr_utility.set_location('per_db_per_setup.create_business_group',6);
459: l_business_group_id := insert_organization_unit('Y'
460: ,p_name
461: ,null
462: ,null

Line 472: hr_utility.set_location('per_db_per_setup.create_business_group',7);

468: ,p_internal_address_line
469: ,null);
470: --
471: --
472: hr_utility.set_location('per_db_per_setup.create_business_group',7);
473: l_org_information_id := per_db_per_setup.insert_org_information(
474: l_business_group_id
475: ,'CLASS'
476: ,'HR_BG'

Line 498: -- hr_utility.set_location('per_db_per_setup.create_business_group',8);

494: ,null
495: ,null);
496: --
497: --
498: -- hr_utility.set_location('per_db_per_setup.create_business_group',8);
499: -- l_org_information_id := per_db_per_setup.insert_org_information(
500: -- l_business_group_id
501: -- ,'CLASS'
502: -- ,'HR_ORG'

Line 524: hr_utility.set_location('per_db_per_setup.create_business_group',9);

520: -- ,null
521: -- ,null);
522: --
523: --
524: hr_utility.set_location('per_db_per_setup.create_business_group',9);
525: l_org_information_id := per_db_per_setup.insert_org_information(
526: l_business_group_id
527: ,'Business Group Information'
528: ,p_short_name

Line 550: hr_utility.set_location('per_db_per_setup.create_business_group',10);

546: ,null
547: ,null);
548: --
549: --
550: hr_utility.set_location('per_db_per_setup.create_business_group',10);
551: l_org_information_id := per_db_per_setup.insert_org_information(
552: l_business_group_id
553: ,'Work Day Information'
554: ,p_default_start_time

Line 604: hr_utility.set_location('per_db_per_setup.create_per_organization',1);

600: --
601: begin
602: --
603: --
604: hr_utility.set_location('per_db_per_setup.create_per_organization',1);
605: --
606: SELECT business_group_id
607: INTO l_business_group_id
608: FROM per_business_groups

Line 700: hr_utility.set_location('per_db_per_setup.create_pay_legal_company',1);

696: l_business_group_id NUMBER;
697: --
698: begin
699: --
700: hr_utility.set_location('per_db_per_setup.create_pay_legal_company',1);
701: --
702: SELECT business_group_id
703: INTO l_business_group_id
704: FROM per_business_groups

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

866: AND p_job_name = jb.name
867: AND p_business_group_id = jb.business_group_id + 0;
868: --
869: if job_check = 'Y' then
870: hr_utility.set_message(801,'PAY_7686_USER_JOB_TAB_UNIQUE');
871: hr_utility.raise_error;
872: end if;
873: --
874: exception

Line 871: hr_utility.raise_error;

867: AND p_business_group_id = jb.business_group_id + 0;
868: --
869: if job_check = 'Y' then
870: hr_utility.set_message(801,'PAY_7686_USER_JOB_TAB_UNIQUE');
871: hr_utility.raise_error;
872: end if;
873: --
874: exception
875: when NO_DATA_FOUND then null ;

Line 886: hr_utility.set_location('per_db_per_setup.insert_job_definition',1);

882: l_job_definition_id NUMBER;
883: --
884: begin
885: --
886: hr_utility.set_location('per_db_per_setup.insert_job_definition',1);
887: --
888: SELECT per_job_definitions_s.nextval
889: INTO l_job_definition_id
890: FROM sys.dual;

Line 892: hr_utility.set_location('per_db_per_setup.insert_job_definition',2);

888: SELECT per_job_definitions_s.nextval
889: INTO l_job_definition_id
890: FROM sys.dual;
891: --
892: hr_utility.set_location('per_db_per_setup.insert_job_definition',2);
893: --
894: INSERT INTO per_job_definitions
895: (JOB_DEFINITION_ID
896: ,ID_FLEX_NUM

Line 982: hr_utility.set_location('per_db_per_setup.insert_job',1);

978: l_job_id NUMBER;
979: --
980: begin
981: --
982: hr_utility.set_location('per_db_per_setup.insert_job',1);
983: --
984: SELECT per_jobs_s.nextval
985: INTO l_job_id
986: FROM sys.dual;

Line 988: hr_utility.set_location('per_db_per_setup.insert_job',2);

984: SELECT per_jobs_s.nextval
985: INTO l_job_id
986: FROM sys.dual;
987: --
988: hr_utility.set_location('per_db_per_setup.insert_job',2);
989: --
990: unique_name(l_business_group_id,l_job_id, p_name);
991: --
992: hr_utility.set_location('per_db_per_setup.insert_job',3);

Line 992: hr_utility.set_location('per_db_per_setup.insert_job',3);

988: hr_utility.set_location('per_db_per_setup.insert_job',2);
989: --
990: unique_name(l_business_group_id,l_job_id, p_name);
991: --
992: hr_utility.set_location('per_db_per_setup.insert_job',3);
993: --
994: INSERT INTO per_jobs
995: (JOB_ID
996: ,BUSINESS_GROUP_ID

Line 1027: hr_utility.set_location('per_db_per_setup.create_job',1);

1023: --
1024: begin -- FUNCTION create_job
1025: --
1026: --
1027: hr_utility.set_location('per_db_per_setup.create_job',1);
1028: --
1029: SELECT business_group_id
1030: , job_structure
1031: INTO l_business_group_id

Line 1149: hr_utility.set_message(801,'PAY_7683_USER_POS_TABLE_UNIQUE');

1145: AND p_position_name = pos.name
1146: AND p_business_group_id = pos.business_group_id + 0;
1147: --
1148: if pos_check = 'Y' then
1149: hr_utility.set_message(801,'PAY_7683_USER_POS_TABLE_UNIQUE');
1150: hr_utility.raise_error;
1151: end if;
1152: --
1153: exception

Line 1150: hr_utility.raise_error;

1146: AND p_business_group_id = pos.business_group_id + 0;
1147: --
1148: if pos_check = 'Y' then
1149: hr_utility.set_message(801,'PAY_7683_USER_POS_TABLE_UNIQUE');
1150: hr_utility.raise_error;
1151: end if;
1152: --
1153: exception
1154: when NO_DATA_FOUND then null ;

Line 1165: hr_utility.set_location('per_db_per_setup.insert_pos_definition',1);

1161: l_pos_definition_id NUMBER;
1162: --
1163: begin
1164: --
1165: hr_utility.set_location('per_db_per_setup.insert_pos_definition',1);
1166: --
1167: SELECT per_position_definitions_s.nextval
1168: INTO l_pos_definition_id
1169: FROM sys.dual;

Line 1171: hr_utility.set_location('per_db_per_setup.insert_pos_definition',2);

1167: SELECT per_position_definitions_s.nextval
1168: INTO l_pos_definition_id
1169: FROM sys.dual;
1170: --
1171: hr_utility.set_location('per_db_per_setup.insert_pos_definition',2);
1172: --
1173: INSERT INTO per_position_definitions
1174: (POSITION_DEFINITION_ID
1175: ,ID_FLEX_NUM

Line 1261: hr_utility.set_location('per_db_per_setup.insert_position',1);

1257: l_position_id NUMBER;
1258: --
1259: begin
1260: --
1261: hr_utility.set_location('per_db_per_setup.insert_position',1);
1262: --
1263: -- Changed 05-Oct-99 SCNair change insert as an API call
1264: --
1265: -- SELECT per_positions_s.nextval

Line 1269: hr_utility.set_location('per_db_per_setup.insert_position',2);

1265: -- SELECT per_positions_s.nextval
1266: -- INTO l_position_id
1267: -- FROM sys.dual;
1268: --
1269: hr_utility.set_location('per_db_per_setup.insert_position',2);
1270: --
1271: unique_name(l_business_group_id, l_position_id, p_name);
1272: --
1273: hr_utility.set_location('per_db_per_setup.insert_position',3);

Line 1273: hr_utility.set_location('per_db_per_setup.insert_position',3);

1269: hr_utility.set_location('per_db_per_setup.insert_position',2);
1270: --
1271: unique_name(l_business_group_id, l_position_id, p_name);
1272: --
1273: hr_utility.set_location('per_db_per_setup.insert_position',3);
1274: --
1275: -- INSERT INTO per_positions
1276: -- (POSITION_ID
1277: -- ,BUSINESS_GROUP_ID

Line 1428: hr_utility.set_location('per_db_per_setup.create_position',1);

1424: begin -- FUNCTION create_position
1425: --
1426: --
1427: --
1428: hr_utility.set_location('per_db_per_setup.create_position',1);
1429: --
1430: SELECT business_group_id
1431: , position_structure
1432: INTO l_business_group_id

Line 1438: hr_utility.set_location('per_db_per_setup.create_position',2);

1434: FROM per_business_groups
1435: WHERE name = p_business_group
1436: AND business_group_id <> 0;
1437: --
1438: hr_utility.set_location('per_db_per_setup.create_position',2);
1439: --
1440: SELECT job_id
1441: INTO l_job_id
1442: FROM per_jobs

Line 1446: hr_utility.set_location('per_db_per_setup.create_position',3);

1442: FROM per_jobs
1443: WHERE name = p_job
1444: AND business_group_id + 0 = l_business_group_id;
1445: --
1446: hr_utility.set_location('per_db_per_setup.create_position',3);
1447: --
1448: SELECT organization_id
1449: INTO l_organization_id
1450: FROM per_organization_units

Line 1456: hr_utility.set_location('per_db_per_setup.create_position',4);

1452: AND business_group_id + 0 = l_business_group_id;
1453: --
1454: begin
1455: --
1456: hr_utility.set_location('per_db_per_setup.create_position',4);
1457: --
1458: SELECT location_id
1459: INTO l_location_id
1460: FROM hr_locations

Line 1463: hr_utility.set_location('per_db_per_setup.create_position',5);

1459: INTO l_location_id
1460: FROM hr_locations
1461: WHERE location_code = p_location;
1462: --
1463: hr_utility.set_location('per_db_per_setup.create_position',5);
1464: --
1465: --
1466: open c0(p_relief_position);
1467: fetch c0 into l_relief_position_id;

Line 1469: hr_utility.set_location('per_db_per_setup.create_position',6);

1465: --
1466: open c0(p_relief_position);
1467: fetch c0 into l_relief_position_id;
1468: close c0;
1469: hr_utility.set_location('per_db_per_setup.create_position',6);
1470: open c0(p_successor_position);
1471: fetch c0 into l_successor_position_id;
1472: close c0;
1473: --

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

1564: AND p_grade_name = grd.name
1565: AND p_business_group_id = grd.business_group_id + 0;
1566: --
1567: if grd_check = 'Y' then
1568: hr_utility.set_message(801,'PAY_7687_USER_GRADE_TAB_UNIQUE');
1569: hr_utility.raise_error;
1570: end if;
1571: --
1572: exception

Line 1569: hr_utility.raise_error;

1565: AND p_business_group_id = grd.business_group_id + 0;
1566: --
1567: if grd_check = 'Y' then
1568: hr_utility.set_message(801,'PAY_7687_USER_GRADE_TAB_UNIQUE');
1569: hr_utility.raise_error;
1570: end if;
1571: --
1572: exception
1573: when NO_DATA_FOUND then null ;

Line 1585: hr_utility.set_location('per_db_per_setup.insert_grade_definition',1);

1581: l_grade_definition_id NUMBER;
1582: --
1583: begin
1584: --
1585: hr_utility.set_location('per_db_per_setup.insert_grade_definition',1);
1586: --
1587: SELECT per_grade_definitions_s.nextval
1588: INTO l_grade_definition_id
1589: FROM sys.dual;

Line 1591: hr_utility.set_location('per_db_per_setup.insert_grade_definition',2);

1587: SELECT per_grade_definitions_s.nextval
1588: INTO l_grade_definition_id
1589: FROM sys.dual;
1590: --
1591: hr_utility.set_location('per_db_per_setup.insert_grade_definition',2);
1592: --
1593: INSERT INTO per_grade_definitions
1594: (GRADE_DEFINITION_ID
1595: ,ID_FLEX_NUM

Line 1681: hr_utility.set_location('per_db_per_setup.insert_grade',1);

1677: l_grade_id NUMBER;
1678: --
1679: begin
1680: --
1681: hr_utility.set_location('per_db_per_setup.insert_grade',1);
1682: --
1683: SELECT per_grades_s.nextval
1684: INTO l_grade_id
1685: FROM sys.dual;

Line 1687: hr_utility.set_location('per_db_per_setup.insert_grade',2);

1683: SELECT per_grades_s.nextval
1684: INTO l_grade_id
1685: FROM sys.dual;
1686: --
1687: hr_utility.set_location('per_db_per_setup.insert_grade',2);
1688: --
1689: unique_name(l_business_group_id, l_grade_id, p_name);
1690: --
1691: hr_utility.set_location('per_db_per_setup.insert_grade',3);

Line 1691: hr_utility.set_location('per_db_per_setup.insert_grade',3);

1687: hr_utility.set_location('per_db_per_setup.insert_grade',2);
1688: --
1689: unique_name(l_business_group_id, l_grade_id, p_name);
1690: --
1691: hr_utility.set_location('per_db_per_setup.insert_grade',3);
1692: --
1693: INSERT INTO per_grades
1694: (GRADE_ID
1695: ,BUSINESS_GROUP_ID

Line 1730: hr_utility.set_location('per_db_per_setup.create_grade',1);

1726: --
1727: begin -- FUNCTION create_grade
1728: --
1729: --
1730: hr_utility.set_location('per_db_per_setup.create_grade',1);
1731: --
1732: SELECT business_group_id
1733: , grade_structure
1734: INTO l_business_group_id