eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PSP_BUS dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

152: close csr_leg_code;
153: per_psp_bus.g_spinal_point_id := p_spinal_point_id;
154: per_psp_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: --

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

195: l_proc varchar2(72) := g_package||'chk_spinal_point_id';
196: l_api_updating boolean;
197: --
198: Begin
199: hr_utility.set_location('Entering:'||l_proc, 10);
200: --
201: l_api_updating := per_psp_shd.api_updating
202: (p_spinal_point_id => p_spinal_point_id
203: ,p_object_version_number => p_object_version_number

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

224: end if;
225: --
226: end if;
227: --
228: hr_utility.set_location('Leaving:'||l_proc, 20);
229: --
230: End chk_spinal_point_id;
231: --
232: -- ---------------------------------------------------------------------------

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

281: and pps.parent_spine_id = p_parent_spine_id;
282: --
283: begin
284:
285: hr_utility.set_location('Entering:'|| l_proc, 10);
286: --
287: -- Check mandatory parameters have been set
288: --
289: hr_api.mandatory_arg_error

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

315: --
316: end if;
317: close csr_valid_parent_spines;
318:
319: hr_utility.set_location(' Leaving:'|| l_proc, 20);
320:
321: end chk_parent_spine_id;
322: --
323: -- ---------------------------------------------------------------------------

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

370: and spinal_point = p_spinal_point;
371: --
372: BEGIN
373: --
374: hr_utility.set_location('Entering:'||l_proc, 10);
375: --
376: hr_api.mandatory_arg_error
377: (p_api_name => l_proc,
378: p_argument => 'sequence',

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

377: (p_api_name => l_proc,
378: p_argument => 'sequence',
379: p_argument_value => p_sequence);
380: --
381: hr_utility.set_location(l_proc,20);
382: --
383: l_api_updating := per_psp_shd.api_updating
384: (p_spinal_point_id => p_spinal_point_id
385: ,p_object_version_number => p_object_version_number);

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

385: ,p_object_version_number => p_object_version_number);
386: --
387: if (l_api_updating and nvl(per_psp_shd.g_old_rec.sequence,
388: hr_api.g_number) = nvl(p_sequence, hr_api.g_number)) then
389: hr_utility.set_location('Leaving:'||l_proc, 30);
390: return;
391: end if;
392:
393: open csr_unq_seq;

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

393: open csr_unq_seq;
394: --
395: FETCH csr_unq_seq INTO l_exists;
396:
397: hr_utility.set_location(l_proc,30);
398:
399: IF csr_unq_seq%FOUND THEN
400: hr_utility.set_message(801, 'PER_7925_POINT_SEQ_EXISTS');
401: CLOSE csr_unq_seq;

Line 400: hr_utility.set_message(801, 'PER_7925_POINT_SEQ_EXISTS');

396:
397: hr_utility.set_location(l_proc,30);
398:
399: IF csr_unq_seq%FOUND THEN
400: hr_utility.set_message(801, 'PER_7925_POINT_SEQ_EXISTS');
401: CLOSE csr_unq_seq;
402: hr_utility.raise_error;
403: END IF;
404:

Line 402: hr_utility.raise_error;

398:
399: IF csr_unq_seq%FOUND THEN
400: hr_utility.set_message(801, 'PER_7925_POINT_SEQ_EXISTS');
401: CLOSE csr_unq_seq;
402: hr_utility.raise_error;
403: END IF;
404:
405: CLOSE csr_unq_seq;
406: --

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

403: END IF;
404:
405: CLOSE csr_unq_seq;
406: --
407: hr_utility.set_location('Leaving:'||l_proc, 40);
408: --
409: end chk_sequence;
410:
411: --

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

458: and parent_spine_id = p_parent_spine_id;
459: --
460: BEGIN
461: --
462: hr_utility.set_location('Entering:'||l_proc, 10);
463: --
464: hr_api.mandatory_arg_error
465: (p_api_name => l_proc,
466: p_argument => 'spinal_point',

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

465: (p_api_name => l_proc,
466: p_argument => 'spinal_point',
467: p_argument_value => p_spinal_point);
468: --
469: hr_utility.set_location(l_proc,20);
470: --
471: l_api_updating := per_psp_shd.api_updating
472: (p_spinal_point_id => p_spinal_point_id
473: ,p_object_version_number => p_object_version_number);

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

473: ,p_object_version_number => p_object_version_number);
474: --
475: if (l_api_updating and nvl(per_psp_shd.g_old_rec.spinal_point,
476: hr_api.g_varchar2) = nvl(p_spinal_point, hr_api.g_varchar2)) then
477: hr_utility.set_location('Leaving:'||l_proc, 30);
478: return;
479: end if;
480:
481: hr_utility.set_location(l_proc,40);

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

477: hr_utility.set_location('Leaving:'||l_proc, 30);
478: return;
479: end if;
480:
481: hr_utility.set_location(l_proc,40);
482:
483: open csr_unq_spinal_point;
484: --
485: FETCH csr_unq_spinal_point INTO l_exists;

Line 488: hr_utility.set_message(801, 'PER_7924_POINT_EXISTS');

484: --
485: FETCH csr_unq_spinal_point INTO l_exists;
486:
487: IF csr_unq_spinal_point%FOUND THEN
488: hr_utility.set_message(801, 'PER_7924_POINT_EXISTS');
489: CLOSE csr_unq_spinal_point;
490: fnd_message.raise_error;
491: END IF;
492:

Line 495: hr_utility.set_location('Leaving:'||l_proc, 50);

491: END IF;
492:
493: CLOSE csr_unq_spinal_point;
494: --
495: hr_utility.set_location('Leaving:'||l_proc, 50);
496: --
497: end chk_spinal_point;
498:
499: --

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

549:
550: --
551: Begin
552: --
553: hr_utility.set_location('Entering:'||l_proc, 10);
554:
555: --
556: -- Check there are no values in per_spinal_point_steps_f and
557: -- per_grade_spines_f

Line 567: hr_utility.set_message(801, 'PER_7926_DEL_POINT_STEP');

563: If csr_step_grade_spine%found Then
564: --
565: close csr_step_grade_spine;
566: --
567: hr_utility.set_message(801, 'PER_7926_DEL_POINT_STEP');
568: hr_utility.raise_error;
569: --
570: End If;
571: --

Line 568: hr_utility.raise_error;

564: --
565: close csr_step_grade_spine;
566: --
567: hr_utility.set_message(801, 'PER_7926_DEL_POINT_STEP');
568: hr_utility.raise_error;
569: --
570: End If;
571: --
572: close csr_step_grade_spine;

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

570: End If;
571: --
572: close csr_step_grade_spine;
573:
574: hr_utility.set_location(l_proc, 20);
575:
576: --
577: -- Check there are no values in per_grade_rules_f
578: --

Line 587: hr_utility.set_message(801, 'PER_7927_DEL_POINT_VALUE');

583: If csr_grade_rule%found Then
584: --
585: close csr_grade_rule;
586: --
587: hr_utility.set_message(801, 'PER_7927_DEL_POINT_VALUE');
588: hr_utility.raise_error;
589: --
590: End If;
591: --

Line 588: hr_utility.raise_error;

584: --
585: close csr_grade_rule;
586: --
587: hr_utility.set_message(801, 'PER_7927_DEL_POINT_VALUE');
588: hr_utility.raise_error;
589: --
590: End If;
591: --
592: close csr_grade_rule;

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

590: End If;
591: --
592: close csr_grade_rule;
593:
594: hr_utility.set_location('Leaving:' || l_proc, 30);
595: --
596: end chk_delete;
597: --
598: -- ----------------------------------------------------------------------------

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

629: --
630: l_proc varchar2(72) := g_package || 'chk_ddf';
631: --
632: begin
633: hr_utility.set_location('Entering:'||l_proc,10);
634: --
635: if ((p_rec.spinal_point_id is not null) and (
636: nvl(per_psp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
637: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

701: -- a) During update, the structure column value or any
702: -- of the attribute values have actually changed.
703: -- b) During insert.
704: --
705: hr_utility.set_location('Entering:'||l_proc,20);
706:
707: hr_dflex_utility.ins_or_upd_descflex_attribs
708: (p_appl_short_name => 'PER'
709: ,p_descflex_name => 'Further Spinal Point DF'

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

770: ,p_attribute30_value => p_rec.information30
771: );
772: end if;
773: --
774: hr_utility.set_location(' Leaving:'||l_proc,20);
775: end chk_ddf;
776: --
777: --
778: -- ----------------------------------------------------------------------------

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

857: --
858: l_proc varchar2(72) := g_package||'insert_validate';
859: --
860: Begin
861: hr_utility.set_location('Entering:'||l_proc, 10);
862: --
863: -- Call all supporting business operations
864: --
865: hr_api.validate_bus_grp_id

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

873: (p_spinal_point_id => p_rec.spinal_point_id
874: ,p_object_version_number => p_rec.object_version_number
875: );
876:
877: hr_utility.set_location(l_proc, 20);
878:
879: -- After validating the set of important attributes,
880: -- if Multiple Message detection is enabled and at least
881: -- one error has been found then abort further validation.

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

895: ,p_business_group_id => p_rec.business_group_id
896: ,p_object_version_number => p_rec.object_version_number
897: );
898:
899: hr_utility.set_location(l_proc, 30);
900:
901: --
902: -- Validate sequence
903: --

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

908: ,p_spinal_point_id => p_rec.spinal_point_id
909: ,p_object_version_number => p_rec.object_version_number
910: ) ;
911:
912: hr_utility.set_location(l_proc, 40);
913:
914: --
915: -- Validate spinal point
916: --

Line 924: hr_utility.set_location(' Leaving:'||l_proc, 50);

920: ,p_spinal_point_id => p_rec.spinal_point_id
921: ,p_object_version_number => p_rec.object_version_number
922: ) ;
923:
924: hr_utility.set_location(' Leaving:'||l_proc, 50);
925:
926: --
927: -- Developer Descriptive Flexfield Validation
928: --

Line 931: hr_utility.set_location(' Leaving:'||l_proc, 100);

927: -- Developer Descriptive Flexfield Validation
928: --
929: per_psp_bus.chk_ddf(p_rec);
930:
931: hr_utility.set_location(' Leaving:'||l_proc, 100);
932:
933: End insert_validate;
934: --
935: -- ----------------------------------------------------------------------------

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

942: --
943: l_proc varchar2(72) := g_package||'update_validate';
944: --
945: Begin
946: hr_utility.set_location('Entering:'||l_proc, 10);
947: --
948: -- Call all supporting business operations
949: --
950: hr_api.validate_bus_grp_id

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

959: (p_spinal_point_id => p_rec.spinal_point_id
960: ,p_object_version_number => p_rec.object_version_number
961: );
962:
963: hr_utility.set_location(l_proc, 20);
964:
965: --
966: -- After validating the set of important attributes,
967: -- if Multiple Message detection is enabled and at least

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

976: (p_effective_date => p_effective_date
977: ,p_rec => p_rec
978: );
979:
980: hr_utility.set_location(l_proc, 30);
981:
982: --
983: -- Validate parent spine id
984: --

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

988: ,p_business_group_id => p_rec.business_group_id
989: ,p_object_version_number => p_rec.object_version_number
990: );
991:
992: hr_utility.set_location(l_proc, 40);
993:
994: --
995: -- Validate sequence
996: --

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

1001: ,p_spinal_point_id => p_rec.spinal_point_id
1002: ,p_object_version_number => p_rec.object_version_number
1003: ) ;
1004:
1005: hr_utility.set_location(l_proc, 50);
1006:
1007: --
1008: -- Validate spinal point
1009: --

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

1013: ,p_spinal_point_id => p_rec.spinal_point_id
1014: ,p_object_version_number => p_rec.object_version_number
1015: ) ;
1016:
1017: hr_utility.set_location(' Leaving:'||l_proc, 60);
1018:
1019: --
1020: -- Developer Descriptive Flexfield Validation
1021: --

Line 1024: hr_utility.set_location(' Leaving:'||l_proc, 100);

1020: -- Developer Descriptive Flexfield Validation
1021: --
1022: per_psp_bus.chk_ddf(p_rec);
1023:
1024: hr_utility.set_location(' Leaving:'||l_proc, 100);
1025:
1026: End update_validate;
1027: --
1028: -- ----------------------------------------------------------------------------

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

1034: --
1035: l_proc varchar2(72) := g_package||'delete_validate';
1036: --
1037: Begin
1038: hr_utility.set_location('Entering:'||l_proc, 10);
1039:
1040: --
1041: -- Call all supporting business operations
1042: --

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

1042: --
1043: chk_delete(p_spinal_point_id => p_rec.spinal_point_id
1044: ,p_parent_spine_id => p_rec.parent_spine_id);
1045:
1046: hr_utility.set_location(' Leaving:'||l_proc, 20);
1047: End delete_validate;
1048: --
1049: end per_psp_bus;