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

Line 200: hr_utility.set_location('Entering:'|| l_proc, 10);

196: l_proc VARCHAR2(72) := g_package||'create_pl_secondary_emp_asg OLD';
197:
198: --
199: BEGIN
200: hr_utility.set_location('Entering:'|| l_proc, 10);
201: --
202: -- Initialise local variable
203: --
204: /*Replaced code with call to new overloaded procedure

Line 217: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

213: FETCH csr_legislation
214: INTO l_legislation_code;
215: IF csr_legislation%notfound THEN
216: CLOSE csr_legislation;
217: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
218: hr_utility.set_message_token('LEG_CODE', 'PL');
219: hr_utility.raise_error;
220: END IF;
221: CLOSE csr_legislation;

Line 218: hr_utility.set_message_token('LEG_CODE', 'PL');

214: INTO l_legislation_code;
215: IF csr_legislation%notfound THEN
216: CLOSE csr_legislation;
217: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
218: hr_utility.set_message_token('LEG_CODE', 'PL');
219: hr_utility.raise_error;
220: END IF;
221: CLOSE csr_legislation;
222: --

Line 219: hr_utility.raise_error;

215: IF csr_legislation%notfound THEN
216: CLOSE csr_legislation;
217: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
218: hr_utility.set_message_token('LEG_CODE', 'PL');
219: hr_utility.raise_error;
220: END IF;
221: CLOSE csr_legislation;
222: --
223: --

Line 390: hr_utility.set_location(' Leaving:'||l_proc, 30);

386: ,p_hourly_salaried_warning =>p_hourly_salaried_warning
387: ,p_gsp_post_process_warning =>p_gsp_post_process_warning
388: );
389:
390: hr_utility.set_location(' Leaving:'||l_proc, 30);
391: --
392: END create_pl_secondary_emp_asg;
393: -- ----------------------------------------------------------------------------
394: -- |-------------------< create_pl_secondary_emp_asg NEW >---------------------|

Line 583: hr_utility.set_location('Entering:'|| l_proc, 10);

579: AND pbg.legislation_code = 'PL';
580: --
581: --
582: BEGIN
583: hr_utility.set_location('Entering:'|| l_proc, 10);
584: --
585: -- Initialise local variable
586: --
587: l_effective_date := trunc(p_effective_date);

Line 598: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

594: FETCH csr_legislation
595: INTO l_legislation_code;
596: IF csr_legislation%notfound THEN
597: CLOSE csr_legislation;
598: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
599: hr_utility.set_message_token('LEG_CODE', 'PL');
600: hr_utility.raise_error;
601: END IF;
602: CLOSE csr_legislation;

Line 599: hr_utility.set_message_token('LEG_CODE', 'PL');

595: INTO l_legislation_code;
596: IF csr_legislation%notfound THEN
597: CLOSE csr_legislation;
598: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
599: hr_utility.set_message_token('LEG_CODE', 'PL');
600: hr_utility.raise_error;
601: END IF;
602: CLOSE csr_legislation;
603: --

Line 600: hr_utility.raise_error;

596: IF csr_legislation%notfound THEN
597: CLOSE csr_legislation;
598: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
599: hr_utility.set_message_token('LEG_CODE', 'PL');
600: hr_utility.raise_error;
601: END IF;
602: CLOSE csr_legislation;
603: --
604: --

Line 769: hr_utility.set_location(' Leaving:'||l_proc, 30);

765: ,p_hourly_salaried_warning => p_hourly_salaried_warning
766: ,p_gsp_post_process_warning => p_gsp_post_process_warning
767:
768: );
769: hr_utility.set_location(' Leaving:'||l_proc, 30);
770: --
771: END create_pl_secondary_emp_asg;
772: -- ----------------------------------------------------------------------------
773: -- |-------------------< update_pl_emp_asg OLD>-------------------------|

Line 918: hr_utility.set_location('Entering:'|| l_proc, 10);

914: --
915: l_proc VARCHAR2(72) := g_package||'update_pl_emp_asg OLD';
916:
917: BEGIN
918: hr_utility.set_location('Entering:'|| l_proc, 10);
919:
920: /* Replaced code with call to new procedure
921: --
922: -- Truncate DATE variables

Line 934: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

930: OPEN check_legislation(p_assignment_id, l_effective_date);
931: FETCH check_legislation into l_legislation_code;
932: IF check_legislation%notfound THEN
933: CLOSE check_legislation;
934: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
935: hr_utility.raise_error;
936: END IF;
937: CLOSE check_legislation;
938: hr_utility.set_location(l_proc, 20);

Line 935: hr_utility.raise_error;

931: FETCH check_legislation into l_legislation_code;
932: IF check_legislation%notfound THEN
933: CLOSE check_legislation;
934: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
935: hr_utility.raise_error;
936: END IF;
937: CLOSE check_legislation;
938: hr_utility.set_location(l_proc, 20);
939: --

Line 938: hr_utility.set_location(l_proc, 20);

934: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
935: hr_utility.raise_error;
936: END IF;
937: CLOSE check_legislation;
938: hr_utility.set_location(l_proc, 20);
939: --
940: -- Check that the legislation of the specified business group IS 'PL'.
941: --
942: IF l_legislation_code <> 'PL' THEN

Line 943: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

939: --
940: -- Check that the legislation of the specified business group IS 'PL'.
941: --
942: IF l_legislation_code <> 'PL' THEN
943: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
944: hr_utility.set_message_token('LEG_CODE','PL');
945: hr_utility.raise_error;
946: END IF;
947: hr_utility.set_location(l_proc, 30);

Line 944: hr_utility.set_message_token('LEG_CODE','PL');

940: -- Check that the legislation of the specified business group IS 'PL'.
941: --
942: IF l_legislation_code <> 'PL' THEN
943: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
944: hr_utility.set_message_token('LEG_CODE','PL');
945: hr_utility.raise_error;
946: END IF;
947: hr_utility.set_location(l_proc, 30);
948: --

Line 945: hr_utility.raise_error;

941: --
942: IF l_legislation_code <> 'PL' THEN
943: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
944: hr_utility.set_message_token('LEG_CODE','PL');
945: hr_utility.raise_error;
946: END IF;
947: hr_utility.set_location(l_proc, 30);
948: --
949: --

Line 947: hr_utility.set_location(l_proc, 30);

943: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
944: hr_utility.set_message_token('LEG_CODE','PL');
945: hr_utility.raise_error;
946: END IF;
947: hr_utility.set_location(l_proc, 30);
948: --
949: --
950: -- Call update_emp_asg business process
951: --

Line 1075: hr_utility.set_location(' Leaving:'||l_proc, 40);

1071: ,p_hourly_salaried_warning =>p_hourly_salaried_warning
1072: ,p_gsp_post_process_warning =>p_gsp_post_process_warning
1073: );
1074:
1075: hr_utility.set_location(' Leaving:'||l_proc, 40);
1076: END update_pl_emp_asg;
1077:
1078: -- ----------------------------------------------------------------------------
1079: -- |-------------------< update_pl_emp_asg NEW>-------------------------|

Line 1226: hr_utility.set_location('Entering:'|| l_proc, 10);

1222: --
1223:
1224:
1225: BEGIN
1226: hr_utility.set_location('Entering:'|| l_proc, 10);
1227:
1228: --
1229: -- Truncate DATE variables
1230: --

Line 1241: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

1237: OPEN check_legislation(p_assignment_id, l_effective_date);
1238: FETCH check_legislation into l_legislation_code;
1239: IF check_legislation%notfound THEN
1240: CLOSE check_legislation;
1241: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1242: hr_utility.raise_error;
1243: END IF;
1244: CLOSE check_legislation;
1245: hr_utility.set_location(l_proc, 20);

Line 1242: hr_utility.raise_error;

1238: FETCH check_legislation into l_legislation_code;
1239: IF check_legislation%notfound THEN
1240: CLOSE check_legislation;
1241: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1242: hr_utility.raise_error;
1243: END IF;
1244: CLOSE check_legislation;
1245: hr_utility.set_location(l_proc, 20);
1246: --

Line 1245: hr_utility.set_location(l_proc, 20);

1241: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1242: hr_utility.raise_error;
1243: END IF;
1244: CLOSE check_legislation;
1245: hr_utility.set_location(l_proc, 20);
1246: --
1247: -- Check that the legislation of the specified business group IS 'PL'.
1248: --
1249: IF l_legislation_code <> 'PL' THEN

Line 1250: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

1246: --
1247: -- Check that the legislation of the specified business group IS 'PL'.
1248: --
1249: IF l_legislation_code <> 'PL' THEN
1250: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1251: hr_utility.set_message_token('LEG_CODE','PL');
1252: hr_utility.raise_error;
1253: END IF;
1254: hr_utility.set_location(l_proc, 30);

Line 1251: hr_utility.set_message_token('LEG_CODE','PL');

1247: -- Check that the legislation of the specified business group IS 'PL'.
1248: --
1249: IF l_legislation_code <> 'PL' THEN
1250: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1251: hr_utility.set_message_token('LEG_CODE','PL');
1252: hr_utility.raise_error;
1253: END IF;
1254: hr_utility.set_location(l_proc, 30);
1255: --

Line 1252: hr_utility.raise_error;

1248: --
1249: IF l_legislation_code <> 'PL' THEN
1250: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1251: hr_utility.set_message_token('LEG_CODE','PL');
1252: hr_utility.raise_error;
1253: END IF;
1254: hr_utility.set_location(l_proc, 30);
1255: --
1256: --

Line 1254: hr_utility.set_location(l_proc, 30);

1250: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1251: hr_utility.set_message_token('LEG_CODE','PL');
1252: hr_utility.raise_error;
1253: END IF;
1254: hr_utility.set_location(l_proc, 30);
1255: --
1256: --
1257: -- Call update_emp_asg business process
1258: --

Line 1381: hr_utility.set_location(' Leaving:'||l_proc, 40);

1377: ,p_gsp_post_process_warning => p_gsp_post_process_warning
1378:
1379: );
1380:
1381: hr_utility.set_location(' Leaving:'||l_proc, 40);
1382: END update_pl_emp_asg;
1383: END hr_pl_assignment_api;