DBA Data[Home] [Help]

APPS.PER_PML_BUS dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_pml_bus.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< chk_df >----------------------------------|
13: -- ----------------------------------------------------------------------------

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

42: --
43: l_proc varchar2(72) := g_package || 'chk_df';
44: --
45: begin
46: hr_utility.set_location('Entering:'||l_proc,10);
47: --
48: if ((p_rec.objective_id is not null) and (
49: nvl(per_pml_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

181: ,p_attribute30_value => p_rec.attribute30
182: );
183: end if;
184: --
185: hr_utility.set_location(' Leaving:'||l_proc,20);
186: end chk_df;
187: --
188: -- ----------------------------------------------------------------------------
189: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 308: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;

304: l_st_date date;
305: l_end_date date;
306: Begin
307:
308: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
309:
310: --
311: hr_api.mandatory_arg_error
312: (p_api_name => l_proc

Line 333: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

329: THEN
330: RETURN;
331: END IF;*/
332:
333: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
334:
335: --
336: -- Show erroe if an objective with this name already exists.
337: --

Line 360: IF g_debug THEN hr_utility.trace('p_duplicate_name_warning: '||l_dup); END IF;

356: if (l_dup ='Y') then
357: fnd_message.raise_error;
358: end if;
359:
360: IF g_debug THEN hr_utility.trace('p_duplicate_name_warning: '||l_dup); END IF;
361: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
362:
363: End chk_objective_name;
364: --

Line 361: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;

357: fnd_message.raise_error;
358: end if;
359:
360: IF g_debug THEN hr_utility.trace('p_duplicate_name_warning: '||l_dup); END IF;
361: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
362:
363: End chk_objective_name;
364: --
365: -- ----------------------------------------------------------------------------

Line 402: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

398: l_api_updating boolean;
399:
400: begin
401:
402: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
403:
404: --
405: -- Only proceed with validation if :
406: -- a) The current g_old_rec is current and

Line 422: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

418: THEN
419: RETURN;
420: END IF;
421:
422: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
423:
424: --
425: -- Only proceed if both parameters are populated.
426: --

Line 440: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;

436: end if;
437:
438: END IF;
439:
440: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
441:
442: exception
443: when app_exception.application_exception then
444: if hr_multi_message.exception_add

Line 448: hr_utility.set_location(' Leaving:'||l_proc, 980);

444: if hr_multi_message.exception_add
445: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.VALID_FROM'
446: ,p_associated_column2 => 'PER_OBJECTIVES_LIBRARY.VALID_TO'
447: ) then
448: hr_utility.set_location(' Leaving:'||l_proc, 980);
449: raise;
450: end if;
451: hr_utility.set_location(' Leaving:'||l_proc, 990);
452:

Line 451: hr_utility.set_location(' Leaving:'||l_proc, 990);

447: ) then
448: hr_utility.set_location(' Leaving:'||l_proc, 980);
449: raise;
450: end if;
451: hr_utility.set_location(' Leaving:'||l_proc, 990);
452:
453: end chk_valid_from_to_date;
454: --
455: -- ----------------------------------------------------------------------------

Line 494: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

490: l_api_updating boolean;
491:
492: begin
493:
494: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
495:
496: --
497: -- Only proceed with validation if :
498: -- a) The current g_old_rec is current and

Line 512: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

508: THEN
509: RETURN;
510: END IF;
511:
512: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
513:
514: --
515: -- Checks that the group code is valid
516: --

Line 529: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;

525: fnd_message.raise_error;
526: end if;
527: end if;
528:
529: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
530:
531: exception
532: when app_exception.application_exception then
533: if hr_multi_message.exception_add

Line 536: hr_utility.set_location(' Leaving:'||l_proc, 980);

532: when app_exception.application_exception then
533: if hr_multi_message.exception_add
534: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.GROUP_CODE'
535: ) then
536: hr_utility.set_location(' Leaving:'||l_proc, 980);
537: raise;
538: end if;
539: hr_utility.set_location(' Leaving:'||l_proc, 990);
540: --

Line 539: hr_utility.set_location(' Leaving:'||l_proc, 990);

535: ) then
536: hr_utility.set_location(' Leaving:'||l_proc, 980);
537: raise;
538: end if;
539: hr_utility.set_location(' Leaving:'||l_proc, 990);
540: --
541: end chk_group_code;
542: --
543: -- ----------------------------------------------------------------------------

Line 582: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

578: l_api_updating boolean;
579:
580: begin
581:
582: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
583:
584: --
585: -- Only proceed with validation if :
586: -- a) The current g_old_rec is current and

Line 600: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

596: THEN
597: RETURN;
598: END IF;
599:
600: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
601:
602: --
603: -- Checks that the priority code is valid
604: --

Line 617: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;

613: fnd_message.raise_error;
614: end if;
615: end if;
616:
617: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
618:
619: exception
620: when app_exception.application_exception then
621: if hr_multi_message.exception_add

Line 624: hr_utility.set_location(' Leaving:'||l_proc, 980);

620: when app_exception.application_exception then
621: if hr_multi_message.exception_add
622: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.PRIORITY_CODE'
623: ) then
624: hr_utility.set_location(' Leaving:'||l_proc, 980);
625: raise;
626: end if;
627: hr_utility.set_location(' Leaving:'||l_proc, 990);
628:

Line 627: hr_utility.set_location(' Leaving:'||l_proc, 990);

623: ) then
624: hr_utility.set_location(' Leaving:'||l_proc, 980);
625: raise;
626: end if;
627: hr_utility.set_location(' Leaving:'||l_proc, 990);
628:
629: end chk_priority_code;
630: --
631: -- ----------------------------------------------------------------------------

Line 670: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

666: l_api_updating boolean;
667:
668: begin
669:
670: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
671:
672: --
673: hr_api.mandatory_arg_error
674: (p_api_name => l_proc

Line 695: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

691: THEN
692: RETURN;
693: END IF;
694:
695: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
696:
697: --
698: -- Checks that the appraise flag is valid
699: --

Line 710: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;

706: fnd_message.set_name('PER', 'HR_50199_WPM_APPRAISE_FLAG');
707: fnd_message.raise_error;
708: end if;
709:
710: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
711:
712: exception
713: when app_exception.application_exception then
714: if hr_multi_message.exception_add

Line 717: hr_utility.set_location(' Leaving:'||l_proc, 980);

713: when app_exception.application_exception then
714: if hr_multi_message.exception_add
715: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
716: ) then
717: hr_utility.set_location(' Leaving:'||l_proc, 980);
718: raise;
719: end if;
720: hr_utility.set_location(' Leaving:'||l_proc, 990);
721:

Line 720: hr_utility.set_location(' Leaving:'||l_proc, 990);

716: ) then
717: hr_utility.set_location(' Leaving:'||l_proc, 980);
718: raise;
719: end if;
720: hr_utility.set_location(' Leaving:'||l_proc, 990);
721:
722: end chk_appraise_flag;
723: --
724: -- ----------------------------------------------------------------------------

Line 768: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

764: l_api_updating boolean;
765:
766: begin
767:
768: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
769:
770: --
771: -- Only proceed with validation if :
772: -- a) The current g_old_rec is current and

Line 788: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

784: THEN
785: RETURN;
786: END IF;
787:
788: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
789:
790: if p_weighting_percent is not null then
791:
792: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

Line 792: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

788: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
789:
790: if p_weighting_percent is not null then
791:
792: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
793: --
794: -- Warn if the objective is not marked for appraisal.
795: --
796: if hr_multi_message.no_exclusive_error

Line 803: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;

799: ) then
800: p_weighting_appraisal_warning := (p_appraise_flag = 'N');
801: end if;
802:
803: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
804: --
805: -- Checks that the weighting_percent is not a negative number
806: --
807: if (p_weighting_percent < 0) then

Line 812: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;

808: fnd_message.set_name('PER','HR_50193_WPM_WEIGHT_VALUE');
809: fnd_message.raise_error;
810: end if;
811:
812: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;
813: --
814: -- Warns that the weighting percent is greater than 100
815: --
816: p_weighting_over_100_warning := (p_weighting_percent > 100);

Line 820: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;

816: p_weighting_over_100_warning := (p_weighting_percent > 100);
817:
818: end if;
819:
820: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
821:
822: exception
823: when app_exception.application_exception then
824: if hr_multi_message.exception_add

Line 827: hr_utility.set_location(' Leaving:'||l_proc, 980);

823: when app_exception.application_exception then
824: if hr_multi_message.exception_add
825: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.WEIGHTING_PERCENT'
826: ) then
827: hr_utility.set_location(' Leaving:'||l_proc, 980);
828: raise;
829: end if;
830: hr_utility.set_location(' Leaving:'||l_proc, 990);
831:

Line 830: hr_utility.set_location(' Leaving:'||l_proc, 990);

826: ) then
827: hr_utility.set_location(' Leaving:'||l_proc, 980);
828: raise;
829: end if;
830: hr_utility.set_location(' Leaving:'||l_proc, 990);
831:
832: end chk_weighting_percent;
833: --
834: -- ----------------------------------------------------------------------------

Line 873: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

869: l_api_updating boolean;
870:
871: begin
872:
873: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
874:
875: --
876: hr_api.mandatory_arg_error
877: (p_api_name => l_proc

Line 898: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

894: THEN
895: RETURN;
896: END IF;
897:
898: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
899:
900: --
901: -- Checks that the measurement_style_code is valid
902: --

Line 913: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;

909: fnd_message.set_name('PER', 'HR_50194_WPM_INV_MEASR_STYL');
910: fnd_message.raise_error;
911: end if;
912:
913: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
914:
915: exception
916: when app_exception.application_exception then
917: if hr_multi_message.exception_add

Line 920: hr_utility.set_location(' Leaving:'||l_proc, 980);

916: when app_exception.application_exception then
917: if hr_multi_message.exception_add
918: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
919: ) then
920: hr_utility.set_location(' Leaving:'||l_proc, 980);
921: raise;
922: end if;
923: hr_utility.set_location(' Leaving:'||l_proc, 990);
924:

Line 923: hr_utility.set_location(' Leaving:'||l_proc, 990);

919: ) then
920: hr_utility.set_location(' Leaving:'||l_proc, 980);
921: raise;
922: end if;
923: hr_utility.set_location(' Leaving:'||l_proc, 990);
924:
925: end chk_measurement_style_code;
926: --
927: -- ----------------------------------------------------------------------------

Line 968: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

964: l_api_updating boolean;
965:
966: begin
967:
968: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
969:
970: --
971: -- Only proceed with validation if :
972: -- a) The current g_old_rec is current and

Line 988: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

984: THEN
985: RETURN;
986: END IF;
987:
988: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
989:
990: if hr_multi_message.no_exclusive_error
991: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
992: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

Line 997: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

993: ) then
994:
995: if p_measurement_style_code <> 'N_M'
996: then
997: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
998:
999: hr_api.mandatory_arg_error
1000: (p_api_name => l_proc
1001: ,p_argument => 'p_measure_name'

Line 1008: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;

1004: end if;
1005:
1006: end if;
1007:
1008: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
1009:
1010: exception
1011: when app_exception.application_exception then
1012: if hr_multi_message.exception_add

Line 1015: hr_utility.set_location(' Leaving:'||l_proc, 980);

1011: when app_exception.application_exception then
1012: if hr_multi_message.exception_add
1013: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASURE_NAME'
1014: ) then
1015: hr_utility.set_location(' Leaving:'||l_proc, 980);
1016: raise;
1017: end if;
1018: hr_utility.set_location(' Leaving:'||l_proc, 990);
1019:

Line 1018: hr_utility.set_location(' Leaving:'||l_proc, 990);

1014: ) then
1015: hr_utility.set_location(' Leaving:'||l_proc, 980);
1016: raise;
1017: end if;
1018: hr_utility.set_location(' Leaving:'||l_proc, 990);
1019:
1020: end chk_measure_name;
1021: --
1022: -- ----------------------------------------------------------------------------

Line 1063: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

1059: l_api_updating boolean;
1060:
1061: begin
1062:
1063: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
1064:
1065: --
1066: -- Only proceed with validation if :
1067: -- a) The current g_old_rec is current and

Line 1083: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

1079: THEN
1080: RETURN;
1081: END IF;
1082:
1083: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1084:
1085: if hr_multi_message.no_exclusive_error
1086: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1087: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

Line 1092: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

1088: ) then
1089:
1090: if p_measurement_style_code = 'QUANT_M'
1091: then
1092: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1093:
1094: hr_api.mandatory_arg_error
1095: (p_api_name => l_proc
1096: ,p_argument => 'p_target_value'

Line 1103: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;

1099: end if;
1100:
1101: end if;
1102:
1103: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
1104:
1105: exception
1106: when app_exception.application_exception then
1107: if hr_multi_message.exception_add

Line 1110: hr_utility.set_location(' Leaving:'||l_proc, 980);

1106: when app_exception.application_exception then
1107: if hr_multi_message.exception_add
1108: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.TARGET_VALUE'
1109: ) then
1110: hr_utility.set_location(' Leaving:'||l_proc, 980);
1111: raise;
1112: end if;
1113: hr_utility.set_location(' Leaving:'||l_proc, 990);
1114:

Line 1113: hr_utility.set_location(' Leaving:'||l_proc, 990);

1109: ) then
1110: hr_utility.set_location(' Leaving:'||l_proc, 980);
1111: raise;
1112: end if;
1113: hr_utility.set_location(' Leaving:'||l_proc, 990);
1114:
1115: end chk_target_value;
1116: --
1117: -- ----------------------------------------------------------------------------

Line 1157: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

1153: l_api_updating boolean;
1154:
1155: begin
1156:
1157: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
1158:
1159: --
1160: -- Only proceed with validation if :
1161: -- a) The current g_old_rec is current and

Line 1177: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

1173: THEN
1174: RETURN;
1175: END IF;
1176:
1177: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1178:
1179: if hr_multi_message.no_exclusive_error
1180: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1181: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

Line 1186: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

1182: ) then
1183:
1184: if p_measurement_style_code = 'QUANT_M'
1185: then
1186: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1187:
1188: hr_api.mandatory_arg_error
1189: (p_api_name => l_proc
1190: ,p_argument => 'p_uom_code'

Line 1197: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;

1193: end if;
1194:
1195: end if;
1196:
1197: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
1198:
1199: --
1200: -- Checks that the UOM code is valid
1201: --

Line 1214: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;

1210: fnd_message.raise_error;
1211: end if;
1212: end if;
1213:
1214: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
1215:
1216: exception
1217: when app_exception.application_exception then
1218: if hr_multi_message.exception_add

Line 1221: hr_utility.set_location(' Leaving:'||l_proc, 980);

1217: when app_exception.application_exception then
1218: if hr_multi_message.exception_add
1219: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.UOM_CODE'
1220: ) then
1221: hr_utility.set_location(' Leaving:'||l_proc, 980);
1222: raise;
1223: end if;
1224: hr_utility.set_location(' Leaving:'||l_proc, 990);
1225:

Line 1224: hr_utility.set_location(' Leaving:'||l_proc, 990);

1220: ) then
1221: hr_utility.set_location(' Leaving:'||l_proc, 980);
1222: raise;
1223: end if;
1224: hr_utility.set_location(' Leaving:'||l_proc, 990);
1225:
1226: end chk_uom_code;
1227: --
1228: -- ----------------------------------------------------------------------------

Line 1268: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

1264: l_api_updating boolean;
1265:
1266: begin
1267:
1268: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
1269:
1270: --
1271: -- Only proceed with validation if :
1272: -- a) The current g_old_rec is current and

Line 1288: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

1284: THEN
1285: RETURN;
1286: END IF;
1287:
1288: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1289:
1290: if hr_multi_message.no_exclusive_error
1291: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1292: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

Line 1297: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

1293: ) then
1294:
1295: if p_measurement_style_code = 'QUANT_M'
1296: then
1297: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1298:
1299: hr_api.mandatory_arg_error
1300: (p_api_name => l_proc
1301: ,p_argument => 'p_measure_type_code'

Line 1308: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;

1304: end if;
1305:
1306: end if;
1307:
1308: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
1309:
1310: --
1311: -- Checks that the measure type code is valid
1312: --

Line 1325: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;

1321: fnd_message.raise_error;
1322: end if;
1323: end if;
1324:
1325: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
1326:
1327: exception
1328: when app_exception.application_exception then
1329: if hr_multi_message.exception_add

Line 1332: hr_utility.set_location(' Leaving:'||l_proc, 980);

1328: when app_exception.application_exception then
1329: if hr_multi_message.exception_add
1330: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASURE_TYPE_CODE'
1331: ) then
1332: hr_utility.set_location(' Leaving:'||l_proc, 980);
1333: raise;
1334: end if;
1335: hr_utility.set_location(' Leaving:'||l_proc, 990);
1336:

Line 1335: hr_utility.set_location(' Leaving:'||l_proc, 990);

1331: ) then
1332: hr_utility.set_location(' Leaving:'||l_proc, 980);
1333: raise;
1334: end if;
1335: hr_utility.set_location(' Leaving:'||l_proc, 990);
1336:
1337: end chk_measure_type_code;
1338: --
1339: -- ----------------------------------------------------------------------------

Line 1378: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

1374: l_api_updating boolean;
1375:
1376: begin
1377:
1378: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
1379:
1380: --
1381: hr_api.mandatory_arg_error
1382: (p_api_name => l_proc

Line 1403: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

1399: THEN
1400: RETURN;
1401: END IF;
1402:
1403: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1404:
1405: --
1406: -- Checks that the eligibility type code is valid
1407: --

Line 1418: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;

1414: fnd_message.set_name('PER', 'HR_50197_WPM_INV_ELIGY_TYPE');
1415: fnd_message.raise_error;
1416: end if;
1417:
1418: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
1419:
1420: exception
1421: when app_exception.application_exception then
1422: if hr_multi_message.exception_add

Line 1425: hr_utility.set_location(' Leaving:'||l_proc, 980);

1421: when app_exception.application_exception then
1422: if hr_multi_message.exception_add
1423: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.ELIGIBILITY_TYPE_CODE'
1424: ) then
1425: hr_utility.set_location(' Leaving:'||l_proc, 980);
1426: raise;
1427: end if;
1428: hr_utility.set_location(' Leaving:'||l_proc, 990);
1429: --

Line 1428: hr_utility.set_location(' Leaving:'||l_proc, 990);

1424: ) then
1425: hr_utility.set_location(' Leaving:'||l_proc, 980);
1426: raise;
1427: end if;
1428: hr_utility.set_location(' Leaving:'||l_proc, 990);
1429: --
1430: end chk_eligibility_type_code;
1431: --
1432: -- ---------------------------------------------------------------------

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

1467: l_proc varchar2(72) := g_package||'chk_next_review_date';
1468: --
1469: begin
1470: --
1471: hr_utility.set_location('Entering:'|| l_proc,5);
1472: --
1473: if p_next_review_date < p_valid_from then
1474: hr_utility.set_message(800,'HR_50425_INV_NEXT_REV_DATE');
1475: hr_utility.raise_error;

Line 1474: hr_utility.set_message(800,'HR_50425_INV_NEXT_REV_DATE');

1470: --
1471: hr_utility.set_location('Entering:'|| l_proc,5);
1472: --
1473: if p_next_review_date < p_valid_from then
1474: hr_utility.set_message(800,'HR_50425_INV_NEXT_REV_DATE');
1475: hr_utility.raise_error;
1476: end if;
1477: --
1478: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1475: hr_utility.raise_error;

1471: hr_utility.set_location('Entering:'|| l_proc,5);
1472: --
1473: if p_next_review_date < p_valid_from then
1474: hr_utility.set_message(800,'HR_50425_INV_NEXT_REV_DATE');
1475: hr_utility.raise_error;
1476: end if;
1477: --
1478: hr_utility.set_location(' Leaving:'||l_proc, 10);
1479: --

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

1474: hr_utility.set_message(800,'HR_50425_INV_NEXT_REV_DATE');
1475: hr_utility.raise_error;
1476: end if;
1477: --
1478: hr_utility.set_location(' Leaving:'||l_proc, 10);
1479: --
1480: exception
1481: when app_exception.application_exception then
1482: if hr_multi_message.exception_add

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

1524: l_proc varchar2(72) := g_package||'chk_target_date';
1525: --
1526: begin
1527: --
1528: hr_utility.set_location('Entering:'|| l_proc,5);
1529: --
1530: if p_target_date < p_valid_from then
1531: hr_utility.set_message(800,'HR_50424_WPM_INV_TARGET_DATE');
1532: hr_utility.raise_error;

Line 1531: hr_utility.set_message(800,'HR_50424_WPM_INV_TARGET_DATE');

1527: --
1528: hr_utility.set_location('Entering:'|| l_proc,5);
1529: --
1530: if p_target_date < p_valid_from then
1531: hr_utility.set_message(800,'HR_50424_WPM_INV_TARGET_DATE');
1532: hr_utility.raise_error;
1533: end if;
1534: --
1535: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1532: hr_utility.raise_error;

1528: hr_utility.set_location('Entering:'|| l_proc,5);
1529: --
1530: if p_target_date < p_valid_from then
1531: hr_utility.set_message(800,'HR_50424_WPM_INV_TARGET_DATE');
1532: hr_utility.raise_error;
1533: end if;
1534: --
1535: hr_utility.set_location(' Leaving:'||l_proc, 10);
1536: --

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

1531: hr_utility.set_message(800,'HR_50424_WPM_INV_TARGET_DATE');
1532: hr_utility.raise_error;
1533: end if;
1534: --
1535: hr_utility.set_location(' Leaving:'||l_proc, 10);
1536: --
1537: exception
1538: when app_exception.application_exception then
1539: if hr_multi_message.exception_add

Line 1598: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;

1594: where copied_from_library_id = p_objective_id;
1595: --
1596: begin
1597: --
1598: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
1599:
1600: --
1601: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1602:

Line 1601: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

1597: --
1598: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
1599:
1600: --
1601: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1602:
1603: open csr_child_for_objlib_exists;
1604: fetch csr_child_for_objlib_exists into l_exists;
1605: if csr_child_for_objlib_exists%found then

Line 1614: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;

1610: else
1611: close csr_child_for_objlib_exists;
1612: end if;
1613: --
1614: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1615: --
1616:
1617: exception
1618: when app_exception.application_exception then

Line 1622: hr_utility.set_location(' Leaving:'||l_proc, 980);

1618: when app_exception.application_exception then
1619: if hr_multi_message.exception_add
1620: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.OBJECTIVE_ID'
1621: ) then
1622: hr_utility.set_location(' Leaving:'||l_proc, 980);
1623: raise;
1624: end if;
1625: hr_utility.set_location(' Leaving:'||l_proc, 990);
1626:

Line 1625: hr_utility.set_location(' Leaving:'||l_proc, 990);

1621: ) then
1622: hr_utility.set_location(' Leaving:'||l_proc, 980);
1623: raise;
1624: end if;
1625: hr_utility.set_location(' Leaving:'||l_proc, 990);
1626:
1627: --
1628: end chk_child_for_library_obj;
1629:

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

1645:
1646: --
1647: Begin
1648:
1649: hr_utility.set_location('Entering:'||l_proc, 5);
1650: --
1651: -- Call all supporting business operations
1652: --
1653: -- No business group context. HR_STANDARD_LOOKUPS used for validation.

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

1662: ,p_object_version_number => p_rec.object_version_number
1663: ,p_valid_from => p_rec.valid_from
1664: ,p_valid_to => p_rec.valid_to);
1665:
1666: hr_utility.set_location(l_proc, 10);
1667: --
1668: -- Check the uniqueness of the objective name.
1669: --
1670: chk_objective_name

Line 1679: hr_utility.set_location(l_proc, 15);

1675: ,p_valid_from =>p_rec.valid_from
1676: ,p_valid_to =>p_rec.valid_to);
1677:
1678:
1679: hr_utility.set_location(l_proc, 15);
1680: --
1681: -- Check the group code.
1682: --
1683: chk_group_code

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

1685: ,p_object_version_number => p_rec.object_version_number
1686: ,p_effective_date => p_effective_date
1687: ,p_group_code => p_rec.group_code);
1688:
1689: hr_utility.set_location(l_proc, 20);
1690: --
1691: -- Check the priority.
1692: --
1693: chk_priority_code

Line 1699: hr_utility.set_location(l_proc, 25);

1695: ,p_object_version_number => p_rec.object_version_number
1696: ,p_effective_date => p_effective_date
1697: ,p_priority_code => p_rec.priority_code);
1698:
1699: hr_utility.set_location(l_proc, 25);
1700: --
1701: -- Check the appraise flag.
1702: --
1703: chk_appraise_flag

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

1705: ,p_object_version_number => p_rec.object_version_number
1706: ,p_effective_date => p_effective_date
1707: ,p_appraise_flag => p_rec.appraise_flag);
1708:
1709: hr_utility.set_location(l_proc, 30);
1710: --
1711: -- Check the weighting percent.
1712: --
1713: chk_weighting_percent

Line 1721: hr_utility.set_location(l_proc, 35);

1717: ,p_weighting_percent => p_rec.weighting_percent
1718: ,p_weighting_over_100_warning => p_weighting_over_100_warning
1719: ,p_weighting_appraisal_warning => p_weighting_appraisal_warning);
1720:
1721: hr_utility.set_location(l_proc, 35);
1722: --
1723: -- Check the measurement style code.
1724: --
1725: chk_measurement_style_code

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

1727: ,p_object_version_number => p_rec.object_version_number
1728: ,p_effective_date => p_effective_date
1729: ,p_measurement_style_code => p_rec.measurement_style_code);
1730:
1731: hr_utility.set_location(l_proc, 40);
1732: --
1733: -- Check the measure name.
1734: --
1735: chk_measure_name

Line 1741: hr_utility.set_location(l_proc, 45);

1737: ,p_object_version_number => p_rec.object_version_number
1738: ,p_measurement_style_code => p_rec.measurement_style_code
1739: ,p_measure_name => p_rec.measure_name);
1740:
1741: hr_utility.set_location(l_proc, 45);
1742: --
1743: -- Check the target value.
1744: --
1745: chk_target_value

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

1747: ,p_object_version_number => p_rec.object_version_number
1748: ,p_measurement_style_code => p_rec.measurement_style_code
1749: ,p_target_value => p_rec.target_value);
1750:
1751: hr_utility.set_location(l_proc, 50);
1752: --
1753: -- Check the UOM code.
1754: --
1755: chk_uom_code

Line 1762: hr_utility.set_location(l_proc, 55);

1758: ,p_effective_date => p_effective_date
1759: ,p_measurement_style_code => p_rec.measurement_style_code
1760: ,p_uom_code => p_rec.uom_code);
1761:
1762: hr_utility.set_location(l_proc, 55);
1763: --
1764: -- Check the measure type code.
1765: --
1766: chk_measure_type_code

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

1769: ,p_effective_date => p_effective_date
1770: ,p_measurement_style_code => p_rec.measurement_style_code
1771: ,p_measure_type_code => p_rec.measure_type_code);
1772:
1773: hr_utility.set_location(l_proc, 60);
1774: --
1775: -- Check the eligibility type code.
1776: --
1777: chk_eligibility_type_code

Line 1783: hr_utility.set_location(l_proc, 65);

1779: ,p_object_version_number => p_rec.object_version_number
1780: ,p_effective_date => p_effective_date
1781: ,p_eligibility_type_code => p_rec.eligibility_type_code);
1782:
1783: hr_utility.set_location(l_proc, 65);
1784:
1785: --
1786: -- Check that the next review date is not before start date
1787: --

Line 1795: hr_utility.set_location(l_proc, 70);

1791: ,p_next_review_date => p_rec.next_review_date
1792: ,p_object_version_number => p_rec.object_version_number
1793: );
1794:
1795: hr_utility.set_location(l_proc, 70);
1796:
1797: --
1798: -- Check that the target date is not before start date
1799: --

Line 1807: hr_utility.set_location(l_proc, 75);

1803: ,p_target_date => p_rec.target_date
1804: ,p_object_version_number => p_rec.object_version_number
1805: );
1806:
1807: hr_utility.set_location(l_proc, 75);
1808:
1809: --
1810: -- Check the flexfield.
1811: --

Line 1814: hr_utility.set_location(' Leaving:'||l_proc, 150);

1810: -- Check the flexfield.
1811: --
1812: per_pml_bus.chk_df(p_rec);
1813:
1814: hr_utility.set_location(' Leaving:'||l_proc, 150);
1815:
1816: End insert_validate;
1817: --
1818: -- ----------------------------------------------------------------------------

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

1831:
1832: --
1833: Begin
1834:
1835: hr_utility.set_location('Entering:'||l_proc, 5);
1836: --
1837: -- Call all supporting business operations
1838: --
1839: -- No business group context. HR_STANDARD_LOOKUPS used for validation.

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

1855: ,p_valid_from => p_rec.valid_from
1856: ,p_valid_to => p_rec.valid_to
1857: );
1858:
1859: hr_utility.set_location('Entering:'||l_proc, 10);
1860: --
1861: -- Check the validity dates.
1862: --
1863: chk_valid_from_to_date

Line 1869: hr_utility.set_location('Entering:'||l_proc, 15);

1865: ,p_object_version_number => p_rec.object_version_number
1866: ,p_valid_from => p_rec.valid_from
1867: ,p_valid_to => p_rec.valid_to);
1868:
1869: hr_utility.set_location('Entering:'||l_proc, 15);
1870: --
1871: -- Check the group code.
1872: --
1873: chk_group_code

Line 1879: hr_utility.set_location('Entering:'||l_proc, 20);

1875: ,p_object_version_number => p_rec.object_version_number
1876: ,p_effective_date => p_effective_date
1877: ,p_group_code => p_rec.group_code);
1878:
1879: hr_utility.set_location('Entering:'||l_proc, 20);
1880: --
1881: -- Check the priority.
1882: --
1883: chk_priority_code

Line 1889: hr_utility.set_location('Entering:'||l_proc, 25);

1885: ,p_object_version_number => p_rec.object_version_number
1886: ,p_effective_date => p_effective_date
1887: ,p_priority_code => p_rec.priority_code);
1888:
1889: hr_utility.set_location('Entering:'||l_proc, 25);
1890: --
1891: -- Check the appraise flag.
1892: --
1893: chk_appraise_flag

Line 1899: hr_utility.set_location('Entering:'||l_proc, 30);

1895: ,p_object_version_number => p_rec.object_version_number
1896: ,p_effective_date => p_effective_date
1897: ,p_appraise_flag => p_rec.appraise_flag);
1898:
1899: hr_utility.set_location('Entering:'||l_proc, 30);
1900: --
1901: -- Check the weighting percent.
1902: --
1903: chk_weighting_percent

Line 1911: hr_utility.set_location(l_proc, 35);

1907: ,p_weighting_percent => p_rec.weighting_percent
1908: ,p_weighting_over_100_warning => p_weighting_over_100_warning
1909: ,p_weighting_appraisal_warning => p_weighting_appraisal_warning);
1910:
1911: hr_utility.set_location(l_proc, 35);
1912: --
1913: -- Check the measurement style code.
1914: --
1915: chk_measurement_style_code

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

1917: ,p_object_version_number => p_rec.object_version_number
1918: ,p_effective_date => p_effective_date
1919: ,p_measurement_style_code => p_rec.measurement_style_code);
1920:
1921: hr_utility.set_location(l_proc, 40);
1922: --
1923: -- Check the measure name.
1924: --
1925: chk_measure_name

Line 1931: hr_utility.set_location(l_proc, 45);

1927: ,p_object_version_number => p_rec.object_version_number
1928: ,p_measurement_style_code => p_rec.measurement_style_code
1929: ,p_measure_name => p_rec.measure_name);
1930:
1931: hr_utility.set_location(l_proc, 45);
1932: --
1933: -- Check the target value.
1934: --
1935: chk_target_value

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

1937: ,p_object_version_number => p_rec.object_version_number
1938: ,p_measurement_style_code => p_rec.measurement_style_code
1939: ,p_target_value => p_rec.target_value);
1940:
1941: hr_utility.set_location(l_proc, 50);
1942: --
1943: -- Check the UOM code.
1944: --
1945: chk_uom_code

Line 1952: hr_utility.set_location(l_proc, 55);

1948: ,p_effective_date => p_effective_date
1949: ,p_measurement_style_code => p_rec.measurement_style_code
1950: ,p_uom_code => p_rec.uom_code);
1951:
1952: hr_utility.set_location(l_proc, 55);
1953: --
1954: -- Check the measure type code.
1955: --
1956: chk_measure_type_code

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

1959: ,p_effective_date => p_effective_date
1960: ,p_measurement_style_code => p_rec.measurement_style_code
1961: ,p_measure_type_code => p_rec.measure_type_code);
1962:
1963: hr_utility.set_location(l_proc, 60);
1964: --
1965: -- Check the eligibility type code.
1966: --
1967: chk_eligibility_type_code

Line 1973: hr_utility.set_location(l_proc, 65);

1969: ,p_object_version_number => p_rec.object_version_number
1970: ,p_effective_date => p_effective_date
1971: ,p_eligibility_type_code => p_rec.eligibility_type_code);
1972:
1973: hr_utility.set_location(l_proc, 65);
1974: --
1975: -- Check that the next review dates is not before start date
1976: --
1977: chk_next_review_date

Line 1983: hr_utility.set_location(l_proc, 70);

1979: ,p_valid_from => p_rec.valid_from
1980: ,p_next_review_date => p_rec.next_review_date
1981: ,p_object_version_number => p_rec.object_version_number
1982: );
1983: hr_utility.set_location(l_proc, 70);
1984: --
1985: -- Check that the target date is not before start date
1986: --
1987: chk_target_date

Line 1994: hr_utility.set_location(l_proc, 75);

1990: ,p_target_date => p_rec.target_date
1991: ,p_object_version_number => p_rec.object_version_number
1992: );
1993:
1994: hr_utility.set_location(l_proc, 75);
1995:
1996:
1997: --
1998: -- Check the flexfield.

Line 2002: hr_utility.set_location(' Leaving:'||l_proc, 150);

1998: -- Check the flexfield.
1999: --
2000: per_pml_bus.chk_df(p_rec);
2001:
2002: hr_utility.set_location(' Leaving:'||l_proc, 150);
2003:
2004: End update_validate;
2005: --
2006: -- ----------------------------------------------------------------------------

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

2013: --
2014: l_proc varchar2(72) := g_package||'delete_validate';
2015: --
2016: Begin
2017: hr_utility.set_location('Entering:'||l_proc, 5);
2018: --
2019: -- Call all supporting business operations
2020: -- 9166842 Bug Fix Changes
2021: chk_child_for_library_obj

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

2023: ,p_object_version_number => p_rec.object_version_number
2024: );
2025:
2026:
2027: hr_utility.set_location(' Leaving:'||l_proc, 10);
2028: End delete_validate;
2029: --
2030: end per_pml_bus;