DBA Data[Home] [Help]

APPS.PER_PMS_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_pms_bus.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --

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

43: l_legislation_code varchar2(150);
44: --
45: begin
46: --
47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error

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

83: --
84: hr_api.set_legislation_context(l_legislation_code);
85: end if;
86: --
87: hr_utility.set_location(' Leaving:'|| l_proc, 20);
88: --
89: end set_security_group_id;
90: --
91: -- ---------------------------------------------------------------------------

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

115: l_proc varchar2(72) := g_package||'return_legislation_code';
116: --
117: Begin
118: --
119: hr_utility.set_location('Entering:'|| l_proc, 10);
120: --
121: -- Ensure that all the mandatory parameter are not null
122: --
123: hr_api.mandatory_arg_error

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

133: -- call to this function. Just return the value in the global
134: -- variable.
135: --
136: l_legislation_code := per_pms_bus.g_legislation_code;
137: hr_utility.set_location(l_proc, 20);
138: else
139: --
140: -- The ID is different to the last call to this function
141: -- or this is the first call to this function.

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

150: close csr_leg_code;
151: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
152: fnd_message.raise_error;
153: end if;
154: hr_utility.set_location(l_proc,30);
155: --
156: -- Set the global variables so the values are
157: -- available for the next call to this function.
158: --

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

159: close csr_leg_code;
160: per_pms_bus.g_scorecard_id := p_scorecard_id;
161: per_pms_bus.g_legislation_code := l_legislation_code;
162: end if;
163: hr_utility.set_location(' Leaving:'|| l_proc, 40);
164: return l_legislation_code;
165: end return_legislation_code;
166: --
167: -- ----------------------------------------------------------------------------

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

198: --
199: l_proc varchar2(72) := g_package || 'chk_df';
200: --
201: begin
202: hr_utility.set_location('Entering:'||l_proc,10);
203: --
204: if ((p_rec.scorecard_id is not null) and (
205: nvl(per_pms_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

337: ,p_attribute30_value => p_rec.attribute30
338: );
339: end if;
340: --
341: hr_utility.set_location(' Leaving:'||l_proc,20);
342: end chk_df;
343: --
344: -- ----------------------------------------------------------------------------
345: -- |-----------------------< chk_non_updateable_args >------------------------|

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

391: fnd_message.set_token('STEP ', '5');
392: fnd_message.raise_error;
393: END IF;
394: --
395: hr_utility.set_location(l_proc, 10);
396: if nvl(p_rec.person_id,hr_api.g_number) <>
397: per_pms_shd.g_old_rec.person_id then
398: l_argument := 'person_id';
399: raise l_error;

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

398: l_argument := 'person_id';
399: raise l_error;
400: end if;
401: --
402: hr_utility.set_location(l_proc, 15);
403: if nvl(p_rec.assignment_id,hr_api.g_number) <>
404: per_pms_shd.g_old_rec.assignment_id then
405: l_argument := 'assignment_id';
406: raise l_error;

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

405: l_argument := 'assignment_id';
406: raise l_error;
407: end if;
408: --
409: hr_utility.set_location(l_proc, 20);
410: if nvl(p_rec.creator_type,hr_api.g_varchar2) <>
411: per_pms_shd.g_old_rec.creator_type then
412: l_argument := 'creator_type';
413: raise l_error;

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

412: l_argument := 'creator_type';
413: raise l_error;
414: end if;
415: --
416: hr_utility.set_location(l_proc, 30);
417: --
418: EXCEPTION
419: WHEN l_error THEN
420: hr_api.argument_changed_error

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

469: AND asg.assignment_type <> 'B';
470: --
471: BEGIN
472:
473: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
474:
475: --
476: hr_api.mandatory_arg_error
477: (p_api_name => l_proc

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

515: fnd_message.set_name('PER', 'HR_50263_PMS_INVALID_ASG');
516: fnd_message.raise_error;
517: END IF;
518:
519: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
520:
521: EXCEPTION
522:
523: WHEN app_exception.application_exception THEN

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

523: WHEN app_exception.application_exception THEN
524: IF hr_multi_message.exception_add
525: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.ASSIGNMENT_ID')
526: THEN
527: hr_utility.set_location(' Leaving:'|| l_proc, 980);
528: RAISE;
529: END IF;
530: hr_utility.set_location(' Leaving:'|| l_proc, 990);
531:

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

526: THEN
527: hr_utility.set_location(' Leaving:'|| l_proc, 980);
528: RAISE;
529: END IF;
530: hr_utility.set_location(' Leaving:'|| l_proc, 990);
531:
532: END chk_assignment_id;
533: --
534: -- ----------------------------------------------------------------------------

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

572: WHERE pmp.plan_id = p_plan_id;
573: --
574: BEGIN
575:
576: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
577:
578: --
579: -- Only proceed with validation if :
580: -- a) The current g_old_rec is current and

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

594: IF p_plan_id IS NOT null THEN
595: --
596: -- Check that plan exists.
597: --
598: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
599: OPEN csr_chk_plan_id;
600: FETCH csr_chk_plan_id INTO l_plan_id;
601: CLOSE csr_chk_plan_id;
602:

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

606: END IF;
607:
608: END IF;
609:
610: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
611:
612: EXCEPTION
613:
614: WHEN app_exception.application_exception THEN

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

614: WHEN app_exception.application_exception THEN
615: IF hr_multi_message.exception_add
616: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.PLAN_ID')
617: THEN
618: hr_utility.set_location(' Leaving:'|| l_proc, 980);
619: RAISE;
620: END IF;
621: hr_utility.set_location(' Leaving:'|| l_proc, 990);
622:

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

617: THEN
618: hr_utility.set_location(' Leaving:'|| l_proc, 980);
619: RAISE;
620: END IF;
621: hr_utility.set_location(' Leaving:'|| l_proc, 990);
622:
623: END chk_plan_id;
624: --
625: -- ----------------------------------------------------------------------------

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

667: AND pms.STATUS_CODE <> 'TRANSFER_OUT';
668: --
669: BEGIN
670:
671: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
672:
673: --
674: hr_api.mandatory_arg_error
675: (p_api_name => l_proc

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

698: IF p_plan_id IS NOT null THEN
699: --
700: -- Check that the plan is not a duplicate.
701: --
702: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
703: OPEN csr_chk_duplicate;
704: FETCH csr_chk_duplicate INTO l_dup;
705: CLOSE csr_chk_duplicate;
706:

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

710: END IF;
711:
712: END IF;
713:
714: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
715:
716: EXCEPTION
717:
718: WHEN app_exception.application_exception THEN

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

719: IF hr_multi_message.exception_add
720: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.PLAN_ID'
721: ,p_associated_column2 => 'PER_PERSONAL_SCORECARDS.ASSIGNMENT_ID')
722: THEN
723: hr_utility.set_location(' Leaving:'|| l_proc, 980);
724: RAISE;
725: END IF;
726: hr_utility.set_location(' Leaving:'|| l_proc, 990);
727:

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

722: THEN
723: hr_utility.set_location(' Leaving:'|| l_proc, 980);
724: RAISE;
725: END IF;
726: hr_utility.set_location(' Leaving:'|| l_proc, 990);
727:
728: END chk_duplicate;
729: --
730: -- ----------------------------------------------------------------------------

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

785:
786: --
787: BEGIN
788:
789: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
790: --
791: hr_api.mandatory_arg_error
792: (p_api_name => l_proc
793: ,p_argument => 'p_start_date'

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

819: THEN
820: RETURN;
821: END IF;
822:
823: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
824:
825: --
826: -- Check that the scorecard's start date is not later than the end date.
827: --

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

829: fnd_message.set_name('PER', 'HR_50266_PMS_START_END');
830: fnd_message.raise_error;
831: END IF;
832:
833: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
834:
835: IF p_plan_id IS NOT null THEN
836: --
837: -- Check that the scorecard's dates are within the plan dates.

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

835: IF p_plan_id IS NOT null THEN
836: --
837: -- Check that the scorecard's dates are within the plan dates.
838: --
839: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
840: OPEN csr_dates_within_plan;
841: FETCH csr_dates_within_plan INTO l_pmp_start_date
842: ,l_pmp_end_date;
843: CLOSE csr_dates_within_plan;

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

850: END IF;
851:
852: END IF;
853:
854: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;
855:
856: IF p_scorecard_id IS NOT null THEN
857: --
858: -- Check that there are no objectives outside the range of this scorecard.

Line 860: IF g_debug THEN hr_utility.set_location(l_proc, 60); END IF;

856: IF p_scorecard_id IS NOT null THEN
857: --
858: -- Check that there are no objectives outside the range of this scorecard.
859: --
860: IF g_debug THEN hr_utility.set_location(l_proc, 60); END IF;
861: OPEN csr_objs_outside_scorecard;
862: FETCH csr_objs_outside_scorecard INTO l_row_found;
863: CLOSE csr_objs_outside_scorecard;
864:

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

869: END IF;
870:
871: END IF;
872:
873: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
874:
875: EXCEPTION
876:
877: WHEN app_exception.application_exception THEN

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

878: IF hr_multi_message.exception_add
879: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.START_DATE'
880: ,p_associated_column2 => 'PER_PERSONAL_SCORECARDS.END_DATE')
881: THEN
882: hr_utility.set_location(' Leaving:'|| l_proc, 980);
883: RAISE;
884: END IF;
885: hr_utility.set_location(' Leaving:'|| l_proc, 990);
886:

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

881: THEN
882: hr_utility.set_location(' Leaving:'|| l_proc, 980);
883: RAISE;
884: END IF;
885: hr_utility.set_location(' Leaving:'|| l_proc, 990);
886:
887: END chk_dates;
888: --
889: -- ----------------------------------------------------------------------------

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

933: AND upper(trim(pms.scorecard_name)) = upper(trim(p_scorecard_name));
934: --
935: BEGIN
936:
937: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
938:
939: --
940: hr_api.mandatory_arg_error
941: (p_api_name => l_proc

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

966: THEN
967: RETURN;
968: END IF;
969:
970: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
971:
972: --
973: -- Warn if a scorecard with the same name already exists
974: -- (case and space insensitive).

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

978: CLOSE csr_chk_scorecard_name;
979:
980: p_duplicate_name_warning := (l_dup = 'TRUE');
981:
982: IF g_debug THEN hr_utility.trace('p_duplicate_name_warning: '||l_dup); END IF;
983: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
984:
985: END chk_scorecard_name;
986: --

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

979:
980: p_duplicate_name_warning := (l_dup = 'TRUE');
981:
982: IF g_debug THEN hr_utility.trace('p_duplicate_name_warning: '||l_dup); END IF;
983: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
984:
985: END chk_scorecard_name;
986: --
987: -- ----------------------------------------------------------------------------

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

1016:
1017: --
1018: BEGIN
1019:
1020: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
1021:
1022: hr_api.mandatory_arg_error
1023: (p_api_name => l_proc
1024: ,p_argument => 'p_creator_type'

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

1033: fnd_message.set_name('PER', 'HR_50269_PMS_CREATOR_TYPE');
1034: fnd_message.raise_error;
1035: END IF;
1036:
1037: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1038:
1039: EXCEPTION
1040:
1041: WHEN app_exception.application_exception THEN

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

1041: WHEN app_exception.application_exception THEN
1042: IF hr_multi_message.exception_add
1043: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.CREATOR_TYPE')
1044: THEN
1045: hr_utility.set_location(' Leaving:'|| l_proc, 980);
1046: RAISE;
1047: END IF;
1048: hr_utility.set_location(' Leaving:'|| l_proc, 990);
1049:

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

1044: THEN
1045: hr_utility.set_location(' Leaving:'|| l_proc, 980);
1046: RAISE;
1047: END IF;
1048: hr_utility.set_location(' Leaving:'|| l_proc, 990);
1049:
1050: END chk_creator_type;
1051: --
1052: -- ----------------------------------------------------------------------------

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

1085:
1086: --
1087: BEGIN
1088:
1089: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
1090:
1091: hr_api.mandatory_arg_error
1092: (p_api_name => l_proc
1093: ,p_argument => 'p_status_code'

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

1121: fnd_message.set_name('PER', 'HR_50271_PMS_STATUS_CODE');
1122: fnd_message.raise_error;
1123: END IF;
1124:
1125: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1126:
1127: EXCEPTION
1128:
1129: WHEN app_exception.application_exception THEN

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

1129: WHEN app_exception.application_exception THEN
1130: IF hr_multi_message.exception_add
1131: (p_associated_column1 =>'PER_PERSONAL_SCORECARDS.STATUS_CODE')
1132: THEN
1133: hr_utility.set_location(' Leaving:'|| l_proc, 980);
1134: RAISE;
1135: END IF;
1136: hr_utility.set_location(' Leaving:'|| l_proc, 990);
1137:

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

1132: THEN
1133: hr_utility.set_location(' Leaving:'|| l_proc, 980);
1134: RAISE;
1135: END IF;
1136: hr_utility.set_location(' Leaving:'|| l_proc, 990);
1137:
1138: END chk_status_code;
1139: --
1140: -- ----------------------------------------------------------------------------

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

1170:
1171: --
1172: BEGIN
1173:
1174: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
1175:
1176: p_created_by_plan_warning := (p_creator_type = 'AUTO');
1177:
1178: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;

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

1174: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
1175:
1176: p_created_by_plan_warning := (p_creator_type = 'AUTO');
1177:
1178: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1179:
1180: END chk_auto_creator_type;
1181: --
1182: -- ----------------------------------------------------------------------------

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

1219:
1220: --
1221: BEGIN
1222:
1223: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
1224:
1225: --
1226: -- Check whether this scorecard has any objectives.
1227: --

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

1229: FETCH csr_has_objectives INTO l_exists;
1230: CLOSE csr_has_objectives;
1231:
1232: IF l_exists = 'Y' THEN
1233: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1234: fnd_message.set_name('PER', 'HR_50229_PMS_DEL_NO_OBJ');
1235: fnd_message.raise_error;
1236: END IF;
1237:

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

1234: fnd_message.set_name('PER', 'HR_50229_PMS_DEL_NO_OBJ');
1235: fnd_message.raise_error;
1236: END IF;
1237:
1238: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1239:
1240: END chk_no_objectives;
1241: --
1242: -- ----------------------------------------------------------------------------

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

1252: l_proc varchar2(72) := g_package||'insert_validate';
1253: --
1254: Begin
1255:
1256: hr_utility.set_location('Entering:'||l_proc, 5);
1257:
1258: --
1259: -- Call all supporting business operations.
1260: --

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

1319: ,p_status_code => p_rec.status_code);
1320:
1321: per_pms_bus.chk_df(p_rec);
1322: --
1323: hr_utility.set_location(' Leaving:'||l_proc, 10);
1324: End insert_validate;
1325: --
1326: -- ----------------------------------------------------------------------------
1327: -- |---------------------------< update_validate >----------------------------|

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

1334: --
1335: l_proc varchar2(72) := g_package||'update_validate';
1336: --
1337: Begin
1338: hr_utility.set_location('Entering:'||l_proc, 5);
1339: --
1340: -- Call all supporting business operations
1341: --
1342: --

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

1394: ,p_status_code => p_rec.status_code);
1395:
1396: per_pms_bus.chk_df(p_rec);
1397: --
1398: hr_utility.set_location(' Leaving:'||l_proc, 10);
1399: End update_validate;
1400: --
1401: -- ----------------------------------------------------------------------------
1402: -- |---------------------------< delete_validate >----------------------------|

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

1409: l_proc varchar2(72) := g_package||'delete_validate';
1410: --
1411: Begin
1412:
1413: hr_utility.set_location('Entering:'||l_proc, 5);
1414:
1415: --
1416: -- Call all supporting business operations
1417: --

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

1418: chk_auto_creator_type
1419: (p_creator_type => p_rec.creator_type
1420: ,p_created_by_plan_warning => p_created_by_plan_warning);
1421:
1422: hr_utility.set_location('Entering:'||l_proc, 10);
1423:
1424: --
1425: -- Check if the scorecard has any objectives before deleting.
1426: --

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

1426: --
1427: chk_no_objectives
1428: (p_scorecard_id => p_rec.scorecard_id);
1429:
1430: hr_utility.set_location(' Leaving:'||l_proc, 980);
1431:
1432: End delete_validate;
1433: --
1434: end per_pms_bus;