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 1563: hr_utility.set_location('Entering:'||l_proc, 5);

1559:
1560: --
1561: Begin
1562:
1563: hr_utility.set_location('Entering:'||l_proc, 5);
1564: --
1565: -- Call all supporting business operations
1566: --
1567: -- No business group context. HR_STANDARD_LOOKUPS used for validation.

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

1576: ,p_object_version_number => p_rec.object_version_number
1577: ,p_valid_from => p_rec.valid_from
1578: ,p_valid_to => p_rec.valid_to);
1579:
1580: hr_utility.set_location(l_proc, 10);
1581: --
1582: -- Check the uniqueness of the objective name.
1583: --
1584: chk_objective_name

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

1589: ,p_valid_from =>p_rec.valid_from
1590: ,p_valid_to =>p_rec.valid_to);
1591:
1592:
1593: hr_utility.set_location(l_proc, 15);
1594: --
1595: -- Check the group code.
1596: --
1597: chk_group_code

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

1599: ,p_object_version_number => p_rec.object_version_number
1600: ,p_effective_date => p_effective_date
1601: ,p_group_code => p_rec.group_code);
1602:
1603: hr_utility.set_location(l_proc, 20);
1604: --
1605: -- Check the priority.
1606: --
1607: chk_priority_code

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

1609: ,p_object_version_number => p_rec.object_version_number
1610: ,p_effective_date => p_effective_date
1611: ,p_priority_code => p_rec.priority_code);
1612:
1613: hr_utility.set_location(l_proc, 25);
1614: --
1615: -- Check the appraise flag.
1616: --
1617: chk_appraise_flag

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

1619: ,p_object_version_number => p_rec.object_version_number
1620: ,p_effective_date => p_effective_date
1621: ,p_appraise_flag => p_rec.appraise_flag);
1622:
1623: hr_utility.set_location(l_proc, 30);
1624: --
1625: -- Check the weighting percent.
1626: --
1627: chk_weighting_percent

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

1631: ,p_weighting_percent => p_rec.weighting_percent
1632: ,p_weighting_over_100_warning => p_weighting_over_100_warning
1633: ,p_weighting_appraisal_warning => p_weighting_appraisal_warning);
1634:
1635: hr_utility.set_location(l_proc, 35);
1636: --
1637: -- Check the measurement style code.
1638: --
1639: chk_measurement_style_code

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

1641: ,p_object_version_number => p_rec.object_version_number
1642: ,p_effective_date => p_effective_date
1643: ,p_measurement_style_code => p_rec.measurement_style_code);
1644:
1645: hr_utility.set_location(l_proc, 40);
1646: --
1647: -- Check the measure name.
1648: --
1649: chk_measure_name

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

1651: ,p_object_version_number => p_rec.object_version_number
1652: ,p_measurement_style_code => p_rec.measurement_style_code
1653: ,p_measure_name => p_rec.measure_name);
1654:
1655: hr_utility.set_location(l_proc, 45);
1656: --
1657: -- Check the target value.
1658: --
1659: chk_target_value

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

1661: ,p_object_version_number => p_rec.object_version_number
1662: ,p_measurement_style_code => p_rec.measurement_style_code
1663: ,p_target_value => p_rec.target_value);
1664:
1665: hr_utility.set_location(l_proc, 50);
1666: --
1667: -- Check the UOM code.
1668: --
1669: chk_uom_code

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

1672: ,p_effective_date => p_effective_date
1673: ,p_measurement_style_code => p_rec.measurement_style_code
1674: ,p_uom_code => p_rec.uom_code);
1675:
1676: hr_utility.set_location(l_proc, 55);
1677: --
1678: -- Check the measure type code.
1679: --
1680: chk_measure_type_code

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

1683: ,p_effective_date => p_effective_date
1684: ,p_measurement_style_code => p_rec.measurement_style_code
1685: ,p_measure_type_code => p_rec.measure_type_code);
1686:
1687: hr_utility.set_location(l_proc, 60);
1688: --
1689: -- Check the eligibility type code.
1690: --
1691: chk_eligibility_type_code

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

1693: ,p_object_version_number => p_rec.object_version_number
1694: ,p_effective_date => p_effective_date
1695: ,p_eligibility_type_code => p_rec.eligibility_type_code);
1696:
1697: hr_utility.set_location(l_proc, 65);
1698:
1699: --
1700: -- Check that the next review date is not before start date
1701: --

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

1705: ,p_next_review_date => p_rec.next_review_date
1706: ,p_object_version_number => p_rec.object_version_number
1707: );
1708:
1709: hr_utility.set_location(l_proc, 70);
1710:
1711: --
1712: -- Check that the target date is not before start date
1713: --

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

1717: ,p_target_date => p_rec.target_date
1718: ,p_object_version_number => p_rec.object_version_number
1719: );
1720:
1721: hr_utility.set_location(l_proc, 75);
1722:
1723: --
1724: -- Check the flexfield.
1725: --

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

1724: -- Check the flexfield.
1725: --
1726: per_pml_bus.chk_df(p_rec);
1727:
1728: hr_utility.set_location(' Leaving:'||l_proc, 150);
1729:
1730: End insert_validate;
1731: --
1732: -- ----------------------------------------------------------------------------

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

1745:
1746: --
1747: Begin
1748:
1749: hr_utility.set_location('Entering:'||l_proc, 5);
1750: --
1751: -- Call all supporting business operations
1752: --
1753: -- No business group context. HR_STANDARD_LOOKUPS used for validation.

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

1769: ,p_valid_from => p_rec.valid_from
1770: ,p_valid_to => p_rec.valid_to
1771: );
1772:
1773: hr_utility.set_location('Entering:'||l_proc, 10);
1774: --
1775: -- Check the validity dates.
1776: --
1777: chk_valid_from_to_date

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

1779: ,p_object_version_number => p_rec.object_version_number
1780: ,p_valid_from => p_rec.valid_from
1781: ,p_valid_to => p_rec.valid_to);
1782:
1783: hr_utility.set_location('Entering:'||l_proc, 15);
1784: --
1785: -- Check the group code.
1786: --
1787: chk_group_code

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

1789: ,p_object_version_number => p_rec.object_version_number
1790: ,p_effective_date => p_effective_date
1791: ,p_group_code => p_rec.group_code);
1792:
1793: hr_utility.set_location('Entering:'||l_proc, 20);
1794: --
1795: -- Check the priority.
1796: --
1797: chk_priority_code

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

1799: ,p_object_version_number => p_rec.object_version_number
1800: ,p_effective_date => p_effective_date
1801: ,p_priority_code => p_rec.priority_code);
1802:
1803: hr_utility.set_location('Entering:'||l_proc, 25);
1804: --
1805: -- Check the appraise flag.
1806: --
1807: chk_appraise_flag

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

1809: ,p_object_version_number => p_rec.object_version_number
1810: ,p_effective_date => p_effective_date
1811: ,p_appraise_flag => p_rec.appraise_flag);
1812:
1813: hr_utility.set_location('Entering:'||l_proc, 30);
1814: --
1815: -- Check the weighting percent.
1816: --
1817: chk_weighting_percent

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

1821: ,p_weighting_percent => p_rec.weighting_percent
1822: ,p_weighting_over_100_warning => p_weighting_over_100_warning
1823: ,p_weighting_appraisal_warning => p_weighting_appraisal_warning);
1824:
1825: hr_utility.set_location(l_proc, 35);
1826: --
1827: -- Check the measurement style code.
1828: --
1829: chk_measurement_style_code

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

1831: ,p_object_version_number => p_rec.object_version_number
1832: ,p_effective_date => p_effective_date
1833: ,p_measurement_style_code => p_rec.measurement_style_code);
1834:
1835: hr_utility.set_location(l_proc, 40);
1836: --
1837: -- Check the measure name.
1838: --
1839: chk_measure_name

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

1841: ,p_object_version_number => p_rec.object_version_number
1842: ,p_measurement_style_code => p_rec.measurement_style_code
1843: ,p_measure_name => p_rec.measure_name);
1844:
1845: hr_utility.set_location(l_proc, 45);
1846: --
1847: -- Check the target value.
1848: --
1849: chk_target_value

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

1851: ,p_object_version_number => p_rec.object_version_number
1852: ,p_measurement_style_code => p_rec.measurement_style_code
1853: ,p_target_value => p_rec.target_value);
1854:
1855: hr_utility.set_location(l_proc, 50);
1856: --
1857: -- Check the UOM code.
1858: --
1859: chk_uom_code

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

1862: ,p_effective_date => p_effective_date
1863: ,p_measurement_style_code => p_rec.measurement_style_code
1864: ,p_uom_code => p_rec.uom_code);
1865:
1866: hr_utility.set_location(l_proc, 55);
1867: --
1868: -- Check the measure type code.
1869: --
1870: chk_measure_type_code

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

1873: ,p_effective_date => p_effective_date
1874: ,p_measurement_style_code => p_rec.measurement_style_code
1875: ,p_measure_type_code => p_rec.measure_type_code);
1876:
1877: hr_utility.set_location(l_proc, 60);
1878: --
1879: -- Check the eligibility type code.
1880: --
1881: chk_eligibility_type_code

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

1883: ,p_object_version_number => p_rec.object_version_number
1884: ,p_effective_date => p_effective_date
1885: ,p_eligibility_type_code => p_rec.eligibility_type_code);
1886:
1887: hr_utility.set_location(l_proc, 65);
1888: --
1889: -- Check that the next review dates is not before start date
1890: --
1891: chk_next_review_date

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

1893: ,p_valid_from => p_rec.valid_from
1894: ,p_next_review_date => p_rec.next_review_date
1895: ,p_object_version_number => p_rec.object_version_number
1896: );
1897: hr_utility.set_location(l_proc, 70);
1898: --
1899: -- Check that the target date is not before start date
1900: --
1901: chk_target_date

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

1904: ,p_target_date => p_rec.target_date
1905: ,p_object_version_number => p_rec.object_version_number
1906: );
1907:
1908: hr_utility.set_location(l_proc, 75);
1909:
1910:
1911: --
1912: -- Check the flexfield.

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

1912: -- Check the flexfield.
1913: --
1914: per_pml_bus.chk_df(p_rec);
1915:
1916: hr_utility.set_location(' Leaving:'||l_proc, 150);
1917:
1918: End update_validate;
1919: --
1920: -- ----------------------------------------------------------------------------

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

1927: --
1928: l_proc varchar2(72) := g_package||'delete_validate';
1929: --
1930: Begin
1931: hr_utility.set_location('Entering:'||l_proc, 5);
1932: --
1933: -- Call all supporting business operations
1934: --
1935: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1931: hr_utility.set_location('Entering:'||l_proc, 5);
1932: --
1933: -- Call all supporting business operations
1934: --
1935: hr_utility.set_location(' Leaving:'||l_proc, 10);
1936: End delete_validate;
1937: --
1938: end per_pml_bus;