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

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

38: l_legislation_code varchar2(150);
39: --
40: begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Ensure that all the mandatory parameter are not null
45: --
46: hr_api.mandatory_arg_error

Line 82: hr_utility.set_location(' Leaving:'|| l_proc, 20);

78: --
79: hr_api.set_legislation_context(l_legislation_code);
80: end if;
81: --
82: hr_utility.set_location(' Leaving:'|| l_proc, 20);
83: --
84: end set_security_group_id;
85: --
86: -- ---------------------------------------------------------------------------

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

106: l_proc varchar2(72) := g_package||'return_legislation_code';
107: --
108: Begin
109: --
110: hr_utility.set_location('Entering:'|| l_proc, 10);
111: --
112: -- Ensure that all the mandatory parameter are not null
113: --
114: hr_api.mandatory_arg_error

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

124: -- call to this function. Just return the value in the global
125: -- variable.
126: --
127: l_legislation_code := per_ceo_bus.g_legislation_code;
128: hr_utility.set_location(l_proc, 20);
129: else
130: --
131: -- The ID is different to the last call to this function
132: -- or this is the first call to this function.

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

141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --
147: -- Set the global variables so the values are
148: -- available for the next call to this function.
149: --

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

150: close csr_leg_code;
151: per_ceo_bus.g_comp_element_outcome_id := p_comp_element_outcome_id;
152: per_ceo_bus.g_legislation_code := l_legislation_code;
153: end if;
154: hr_utility.set_location(' Leaving:'|| l_proc, 40);
155: return l_legislation_code;
156: end return_legislation_code;
157: --
158: -- ----------------------------------------------------------------------------

Line 248: hr_utility.set_location('Entering:'||l_proc, 5);

244: l_proc varchar2(72) := g_package||'chk_comp_element_outcome_id';
245: l_api_updating boolean;
246: --
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: l_api_updating := per_ceo_shd.api_updating
251: (p_comp_element_outcome_id => p_comp_element_outcome_id
252: ,p_object_version_number => p_object_version_number

Line 277: hr_utility.set_location('Leaving:'||l_proc, 10);

273: end if;
274: --
275: end if;
276: --
277: hr_utility.set_location('Leaving:'||l_proc, 10);
278: --
279: End chk_comp_element_outcome_id;
280: --
281: -- ---------------------------------------------------------------------------

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

328: l_api_updating boolean;
329: l_exists varchar2(1);
330: --
331: begin
332: hr_utility.set_location('Entering:'||l_proc, 10);
333: --
334: -- Check mandatory parameters have been set
335: --
336:

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

339: ,p_argument => 'competence_element_id'
340: ,p_argument_value => p_competence_element_id
341: );
342:
343: hr_utility.set_location(l_proc, 20);
344:
345: --
346: -- Only proceed with validation if :
347: -- a) The current g_old_rec is current and

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

359:
360: --
361: -- Check that competence_element_id is a foreign key
362: --
363: hr_utility.set_location(l_proc, 30);
364: --
365: open csr_competence_element;
366: fetch csr_competence_element into l_exists;
367: if csr_competence_element%NOTFOUND then

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

374: close csr_competence_element;
375: --
376: end if;
377: --
378: hr_utility.set_location(' Leaving:'||l_proc, 40);
379: end chk_competence_element_id;
380: --
381: --
382: --

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

430: l_api_updating boolean;
431: l_exists varchar2(1);
432: --
433: begin
434: hr_utility.set_location('Entering:'||l_proc, 10);
435: --
436: -- Check mandatory parameters have been set
437: --
438:

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

441: ,p_argument => 'outcome_id'
442: ,p_argument_value => p_outcome_id
443: );
444:
445: hr_utility.set_location(l_proc, 20);
446:
447: --
448: -- Only proceed with validation if :
449: -- a) The current g_old_rec is current and

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

460:
461: --
462: -- Check that outcome_id is a foreign key
463: --
464: hr_utility.set_location(l_proc, 30);
465: --
466: open csr_competence_outcome;
467: fetch csr_competence_outcome into l_exists;
468: if csr_competence_outcome%NOTFOUND then

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

475: close csr_competence_outcome;
476: --
477: end if;
478: --
479: hr_utility.set_location(' Leaving:'||l_proc, 40);
480: end chk_outcome_id;
481: --
482: -- ---------------------------------------------------------------------------
483: -- |-------------------< chk_uniq_comp_element_outcome >----------------------|

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

559: l_api_updating boolean;
560: l_exists varchar2(1);
561: --
562: begin
563: hr_utility.set_location('Entering:'||l_proc, 10);
564:
565: --
566: -- Only proceed with validation if :
567: -- a) The current g_old_rec is current and

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

582: --
583: -- Check that a combination is unique
584: --
585:
586: hr_utility.set_location(l_proc, 20);
587:
588: select name
589: into l_outcome_name
590: from per_competence_outcomes

Line 598: hr_utility.set_message(800,'HR_449132_QUA_FWK_OUTCM_EXISTS');

594: open csr_upd_uniq_comp_ele_outcome(l_outcome_name);
595: fetch csr_upd_uniq_comp_ele_outcome into l_exists;
596: if csr_upd_uniq_comp_ele_outcome%FOUND then
597: close csr_upd_uniq_comp_ele_outcome;
598: hr_utility.set_message(800,'HR_449132_QUA_FWK_OUTCM_EXISTS');
599: hr_multi_message.add
600: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
601:
602: hr_utility.raise_error;

Line 602: hr_utility.raise_error;

598: hr_utility.set_message(800,'HR_449132_QUA_FWK_OUTCM_EXISTS');
599: hr_multi_message.add
600: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
601:
602: hr_utility.raise_error;
603: end if;
604: close csr_upd_uniq_comp_ele_outcome;
605: --
606: elsif (NOT l_api_updating) then

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

603: end if;
604: close csr_upd_uniq_comp_ele_outcome;
605: --
606: elsif (NOT l_api_updating) then
607: hr_utility.set_location(l_proc, 30);
608:
609: --
610: open csr_uniq_comp_element_outcome;
611: fetch csr_uniq_comp_element_outcome into l_exists;

Line 614: hr_utility.set_message(800,'HR_449132_QUA_FWK_OUTCM_EXISTS');

610: open csr_uniq_comp_element_outcome;
611: fetch csr_uniq_comp_element_outcome into l_exists;
612: if csr_uniq_comp_element_outcome%FOUND then
613: close csr_uniq_comp_element_outcome;
614: hr_utility.set_message(800,'HR_449132_QUA_FWK_OUTCM_EXISTS');
615: hr_multi_message.add
616: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
617:
618: hr_utility.raise_error;

Line 618: hr_utility.raise_error;

614: hr_utility.set_message(800,'HR_449132_QUA_FWK_OUTCM_EXISTS');
615: hr_multi_message.add
616: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
617:
618: hr_utility.raise_error;
619: end if;
620: close csr_uniq_comp_element_outcome;
621: end if;
622: --

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

619: end if;
620: close csr_uniq_comp_element_outcome;
621: end if;
622: --
623: hr_utility.set_location(' Leaving:'||l_proc, 40);
624:
625: end chk_uniq_comp_element_outcome;
626: --
627: -- ---------------------------------------------------------------------------

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

674: l_proc varchar2(72) := g_package||'chk_dates';
675: l_api_updating boolean;
676: --
677: begin
678: hr_utility.set_location('Entering:'||l_proc, 10);
679: --
680: -- Check mandatory parameters have been set
681: --
682:

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

684: (p_api_name => l_proc
685: ,p_argument => 'date_from'
686: ,p_argument_value => p_date_from
687: );
688: hr_utility.set_location(l_proc, 20);
689: --
690: -- Only proceed with validation if :
691: -- a) The current g_old_rec is current and
692: -- b) The date_end value has changed

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

702: (NOT l_api_updating))) then
703: --
704: -- Check that date_from <= date_to
705: --
706: hr_utility.set_location(l_proc, 30);
707: --
708: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
709: hr_utility.set_message(800,'HR_6758_APPL_DATE_FROM_CHK');
710: hr_multi_message.add

Line 709: hr_utility.set_message(800,'HR_6758_APPL_DATE_FROM_CHK');

705: --
706: hr_utility.set_location(l_proc, 30);
707: --
708: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
709: hr_utility.set_message(800,'HR_6758_APPL_DATE_FROM_CHK');
710: hr_multi_message.add
711: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
712: hr_utility.raise_error;
713: end if;

Line 712: hr_utility.raise_error;

708: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
709: hr_utility.set_message(800,'HR_6758_APPL_DATE_FROM_CHK');
710: hr_multi_message.add
711: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
712: hr_utility.raise_error;
713: end if;
714: --
715: --
716: -- Check that date_from >= date on which the outcome was defined in the system

Line 718: hr_utility.set_location(l_proc, 50);

714: --
715: --
716: -- Check that date_from >= date on which the outcome was defined in the system
717: --
718: hr_utility.set_location(l_proc, 50);
719: --
720: open csr_get_outcome_active_date ;
721: fetch csr_get_outcome_active_date into l_outcome_active_date;
722: close csr_get_outcome_active_date;

Line 725: hr_utility.set_message(800,'HR_34724_COMP_OUTCME_DATE_INVL');

721: fetch csr_get_outcome_active_date into l_outcome_active_date;
722: close csr_get_outcome_active_date;
723:
724: if p_date_from < nvl( l_outcome_active_date,hr_api.g_eot) then
725: hr_utility.set_message(800,'HR_34724_COMP_OUTCME_DATE_INVL');
726: hr_multi_message.add
727: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
728: hr_utility.raise_error;
729: end if;

Line 728: hr_utility.raise_error;

724: if p_date_from < nvl( l_outcome_active_date,hr_api.g_eot) then
725: hr_utility.set_message(800,'HR_34724_COMP_OUTCME_DATE_INVL');
726: hr_multi_message.add
727: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
728: hr_utility.raise_error;
729: end if;
730: --
731:
732: end if;

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

730: --
731:
732: end if;
733: --
734: hr_utility.set_location(' Leaving:'||l_proc, 40);
735: end chk_dates;
736: --
737: -- ----------------------------------------------------------------------------
738: -- |-----------------------------< chk_ddf >----------------------------------|

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

768: --
769: l_proc varchar2(72) := g_package || 'chk_ddf';
770: --
771: begin
772: hr_utility.set_location('Entering:'||l_proc,10);
773: --
774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or

Line 869: hr_utility.set_location(' Leaving:'||l_proc,20);

865: ,p_attribute20_value => p_rec.information20
866: );
867: end if;
868: --
869: hr_utility.set_location(' Leaving:'||l_proc,20);
870: end chk_ddf;
871: --
872: -- ----------------------------------------------------------------------------
873: -- |------------------------------< chk_df >----------------------------------|

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

903: --
904: l_proc varchar2(72) := g_package || 'chk_df';
905: --
906: begin
907: hr_utility.set_location('Entering:'||l_proc,10);
908: --
909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or

Line 1004: hr_utility.set_location(' Leaving:'||l_proc,20);

1000: ,p_attribute20_value => p_rec.attribute20
1001: );
1002: end if;
1003: --
1004: hr_utility.set_location(' Leaving:'||l_proc,20);
1005: end chk_df;
1006: --
1007: --
1008: -- ----------------------------------------------------------------------------

Line 1019: hr_utility.set_location('Entering:'||l_proc, 5);

1015: --
1016: l_proc varchar2(72) := g_package||'insert_validate';
1017: --
1018: Begin
1019: hr_utility.set_location('Entering:'||l_proc, 5);
1020: --
1021: -- Call all supporting business operations
1022: --
1023:

Line 1032: hr_utility.set_location(l_proc, 10);

1028: (p_comp_element_outcome_id => p_rec.comp_element_outcome_id
1029: ,p_object_version_number => p_rec.object_version_number
1030: );
1031:
1032: hr_utility.set_location(l_proc, 10);
1033:
1034: --
1035: -- Validate competence_element_id
1036: --

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

1039: ,p_competence_element_id => p_rec.competence_element_id
1040: ,p_object_version_number => p_rec.object_version_number
1041: );
1042:
1043: hr_utility.set_location(l_proc, 20);
1044:
1045: --
1046: -- Validate dates
1047: --

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

1052: ,p_date_to => p_rec.date_to
1053: ,p_object_version_number => p_rec.object_version_number
1054: );
1055:
1056: hr_utility.set_location(l_proc, 30);
1057:
1058: --
1059: -- Validate a combination of competence_element_id and outcome_id is unique
1060: --

Line 1070: hr_utility.set_location(l_proc, 40);

1066: ,p_date_to => p_rec.date_to
1067: ,p_object_version_number => p_rec.object_version_number
1068: );
1069:
1070: hr_utility.set_location(l_proc, 40);
1071:
1072: --
1073: -- Validate Dependent Attributes
1074: --

Line 1078: hr_utility.set_location(l_proc, 50);

1074: --
1075: --
1076: per_ceo_bus.chk_df(p_rec);
1077:
1078: hr_utility.set_location(l_proc, 50);
1079:
1080: per_ceo_bus.chk_ddf(p_rec);
1081: --
1082: hr_utility.set_location(' Leaving:'||l_proc, 60);

Line 1082: hr_utility.set_location(' Leaving:'||l_proc, 60);

1078: hr_utility.set_location(l_proc, 50);
1079:
1080: per_ceo_bus.chk_ddf(p_rec);
1081: --
1082: hr_utility.set_location(' Leaving:'||l_proc, 60);
1083: --
1084: End insert_validate;
1085: --
1086: -- ----------------------------------------------------------------------------

Line 1097: hr_utility.set_location('Entering:'||l_proc, 5);

1093: --
1094: l_proc varchar2(72) := g_package||'update_validate';
1095: --
1096: Begin
1097: hr_utility.set_location('Entering:'||l_proc, 5);
1098: --
1099: -- Call all supporting business operations
1100: --
1101:

Line 1110: hr_utility.set_location(l_proc, 10);

1106: (p_comp_element_outcome_id => p_rec.comp_element_outcome_id
1107: ,p_object_version_number => p_rec.object_version_number
1108: );
1109:
1110: hr_utility.set_location(l_proc, 10);
1111:
1112: --
1113: -- Validate competence_element_id
1114: --

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

1117: ,p_competence_element_id => p_rec.competence_element_id
1118: ,p_object_version_number => p_rec.object_version_number
1119: );
1120:
1121: hr_utility.set_location(l_proc, 20);
1122:
1123: --
1124: -- Validate dates
1125: --

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

1130: p_date_to => p_rec.date_to,
1131: p_object_version_number => p_rec.object_version_number
1132: );
1133:
1134: hr_utility.set_location(l_proc, 30);
1135:
1136: --
1137: -- Validate a combination of competence_element_id and outcome_id is unique
1138: --

Line 1148: hr_utility.set_location(l_proc, 40);

1144: ,p_date_to => p_rec.date_to
1145: ,p_object_version_number => p_rec.object_version_number
1146: );
1147:
1148: hr_utility.set_location(l_proc, 40);
1149:
1150: --
1151: -- Validate Dependent Attributes
1152: --

Line 1158: hr_utility.set_location(l_proc, 50);

1154: (p_effective_date => p_effective_date
1155: ,p_rec => p_rec
1156: );
1157:
1158: hr_utility.set_location(l_proc, 50);
1159: --
1160: per_ceo_bus.chk_df(p_rec);
1161: --
1162: hr_utility.set_location(l_proc, 60);

Line 1162: hr_utility.set_location(l_proc, 60);

1158: hr_utility.set_location(l_proc, 50);
1159: --
1160: per_ceo_bus.chk_df(p_rec);
1161: --
1162: hr_utility.set_location(l_proc, 60);
1163:
1164: per_ceo_bus.chk_ddf(p_rec);
1165: --
1166: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 1166: hr_utility.set_location(' Leaving:'||l_proc, 70);

1162: hr_utility.set_location(l_proc, 60);
1163:
1164: per_ceo_bus.chk_ddf(p_rec);
1165: --
1166: hr_utility.set_location(' Leaving:'||l_proc, 70);
1167: End update_validate;
1168: --
1169: -- ----------------------------------------------------------------------------
1170: -- |---------------------------< delete_validate >----------------------------|

Line 1179: hr_utility.set_location('Entering:'||l_proc, 5);

1175: --
1176: l_proc varchar2(72) := g_package||'delete_validate';
1177: --
1178: Begin
1179: hr_utility.set_location('Entering:'||l_proc, 5);
1180: --
1181: -- Call all supporting business operations
1182: --
1183: per_ceo_bus.chk_df(p_rec);

Line 1185: hr_utility.set_location(l_proc, 10);

1181: -- Call all supporting business operations
1182: --
1183: per_ceo_bus.chk_df(p_rec);
1184:
1185: hr_utility.set_location(l_proc, 10);
1186:
1187: per_ceo_bus.chk_ddf(p_rec);
1188:
1189: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1189: hr_utility.set_location(' Leaving:'||l_proc, 10);

1185: hr_utility.set_location(l_proc, 10);
1186:
1187: per_ceo_bus.chk_ddf(p_rec);
1188:
1189: hr_utility.set_location(' Leaving:'||l_proc, 10);
1190: End delete_validate;
1191: --
1192: -- ----------------------------------------------------------------------------
1193: -- |------------------------< check_outcome_achieved >-------------------------|

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

1230: l_achieved_number number;
1231: l_max_date_from date;
1232:
1233: begin
1234: hr_utility.set_location('Entering:'|| l_proc, 10);
1235: hr_utility.trace('p_competence_id : ' || p_competence_id);
1236: hr_utility.trace('p_competence_element_id : ' || p_competence_element_id);
1237:
1238: open csr_get_outcome_number;

Line 1235: hr_utility.trace('p_competence_id : ' || p_competence_id);

1231: l_max_date_from date;
1232:
1233: begin
1234: hr_utility.set_location('Entering:'|| l_proc, 10);
1235: hr_utility.trace('p_competence_id : ' || p_competence_id);
1236: hr_utility.trace('p_competence_element_id : ' || p_competence_element_id);
1237:
1238: open csr_get_outcome_number;
1239: fetch csr_get_outcome_number into l_outcome_number;

Line 1236: hr_utility.trace('p_competence_element_id : ' || p_competence_element_id);

1232:
1233: begin
1234: hr_utility.set_location('Entering:'|| l_proc, 10);
1235: hr_utility.trace('p_competence_id : ' || p_competence_id);
1236: hr_utility.trace('p_competence_element_id : ' || p_competence_element_id);
1237:
1238: open csr_get_outcome_number;
1239: fetch csr_get_outcome_number into l_outcome_number;
1240: close csr_get_outcome_number;

Line 1241: hr_utility.trace('l_outcome_number : ' || l_outcome_number);

1237:
1238: open csr_get_outcome_number;
1239: fetch csr_get_outcome_number into l_outcome_number;
1240: close csr_get_outcome_number;
1241: hr_utility.trace('l_outcome_number : ' || l_outcome_number);
1242:
1243: open csr_get_achieved_number;
1244: fetch csr_get_achieved_number into l_achieved_number,l_max_date_from;
1245: close csr_get_achieved_number;

Line 1246: hr_utility.trace('l_achieved_number : ' || l_achieved_number);

1242:
1243: open csr_get_achieved_number;
1244: fetch csr_get_achieved_number into l_achieved_number,l_max_date_from;
1245: close csr_get_achieved_number;
1246: hr_utility.trace('l_achieved_number : ' || l_achieved_number);
1247: hr_utility.trace('l_max_date_from : ' || l_max_date_from);
1248:
1249: if l_outcome_number = l_achieved_number then
1250: l_return := l_max_date_from;

Line 1247: hr_utility.trace('l_max_date_from : ' || l_max_date_from);

1243: open csr_get_achieved_number;
1244: fetch csr_get_achieved_number into l_achieved_number,l_max_date_from;
1245: close csr_get_achieved_number;
1246: hr_utility.trace('l_achieved_number : ' || l_achieved_number);
1247: hr_utility.trace('l_max_date_from : ' || l_max_date_from);
1248:
1249: if l_outcome_number = l_achieved_number then
1250: l_return := l_max_date_from;
1251: hr_utility.set_location(l_proc, 20);

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

1247: hr_utility.trace('l_max_date_from : ' || l_max_date_from);
1248:
1249: if l_outcome_number = l_achieved_number then
1250: l_return := l_max_date_from;
1251: hr_utility.set_location(l_proc, 20);
1252: else
1253: l_return := NULL;
1254: hr_utility.set_location(l_proc, 30);
1255: end if;

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

1250: l_return := l_max_date_from;
1251: hr_utility.set_location(l_proc, 20);
1252: else
1253: l_return := NULL;
1254: hr_utility.set_location(l_proc, 30);
1255: end if;
1256: --
1257: hr_utility.set_location('Leaving:' || l_proc, 40);
1258: return(l_return);

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

1253: l_return := NULL;
1254: hr_utility.set_location(l_proc, 30);
1255: end if;
1256: --
1257: hr_utility.set_location('Leaving:' || l_proc, 40);
1258: return(l_return);
1259: --
1260: end check_outcome_achieved;
1261: --