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

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

40: l_proc VARCHAR2(72) := g_package||'set_security_group_id';
41: --
42: BEGIN
43: --
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not NULL
47: --
48: hr_api.mandatory_arg_error

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

71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: --
75: hr_utility.set_location(' Leaving:'|| l_proc, 20);
76: --
77: END set_security_group_id;
78: --
79: -- ---------------------------------------------------------------------------

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

104: l_proc VARCHAR2(72) := g_package||'return_legislation_code';
105: --
106: BEGIN
107: --
108: hr_utility.set_location('Entering:'|| l_proc, 10);
109: --
110: -- Ensure that all the mandatory parameter are not NULL
111: --
112: hr_api.mandatory_arg_error

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

122: -- call to this function. Just return the value IN the global
123: -- variable.
124: --
125: l_legislation_code := per_pce_bus.g_legislation_code;
126: hr_utility.set_location(l_proc, 20);
127: else
128: --
129: -- The ID IS different to the last call to this function
130: -- or this IS the first call to this function.

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

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

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

148: close csr_leg_code;
149: per_pce_bus.g_cagr_entitlement_id := p_cagr_entitlement_id;
150: per_pce_bus.g_legislation_code := l_legislation_code;
151: END IF;
152: hr_utility.set_location(' Leaving:'|| l_proc, 40);
153: RETURN l_legislation_code;
154: END return_legislation_code;
155: --
156: -- ----------------------------------------------------------------------------

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

290: l_proc VARCHAR2(72) := g_package||'chk_status';
291: --
292: BEGIN
293: --
294: hr_utility.set_location('Entering : '||l_proc,10);
295: --
296: -- Check mandatory parameter IS set
297: --
298: hr_api.mandatory_arg_error

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

306: ,p_argument => 'status'
307: ,p_argument_value => p_status
308: );
309: --
310: hr_utility.set_location(l_proc,20);
311: --
312: -- Only proceed with validation if :
313: -- a) Inserting or
314: -- b) The value for status has changed

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

316: IF ( (p_cagr_entitlement_id IS NULL) OR
317: ((p_cagr_entitlement_id IS NOT NULL) AND
318: (per_pce_shd.g_old_rec.status <> p_status))) THEN
319: --
320: hr_utility.set_location(l_proc,30);
321: --
322: -- Check that the status exists IN HR_LOOKUPS
323: --
324: IF hr_api.not_exists_in_hr_lookups

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

325: (p_effective_date => p_effective_date
326: ,p_lookup_type => 'CAGR_STATUS'
327: ,p_lookup_code => p_status) THEN
328: --
329: hr_utility.set_location(l_proc, 40);
330: --
331: hr_utility.set_message(800, 'HR_289267_STATUS_INVALID');
332: hr_utility.raise_error;
333: --

Line 331: hr_utility.set_message(800, 'HR_289267_STATUS_INVALID');

327: ,p_lookup_code => p_status) THEN
328: --
329: hr_utility.set_location(l_proc, 40);
330: --
331: hr_utility.set_message(800, 'HR_289267_STATUS_INVALID');
332: hr_utility.raise_error;
333: --
334: END IF;
335: --

Line 332: hr_utility.raise_error;

328: --
329: hr_utility.set_location(l_proc, 40);
330: --
331: hr_utility.set_message(800, 'HR_289267_STATUS_INVALID');
332: hr_utility.raise_error;
333: --
334: END IF;
335: --
336: END IF;

Line 338: hr_utility.set_location('Leaving : '||l_proc, 999);

334: END IF;
335: --
336: END IF;
337: --
338: hr_utility.set_location('Leaving : '||l_proc, 999);
339: --
340: END chk_status;
341: --
342: -- ---------------------------------------------------------------------------

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

381: l_proc VARCHAR2(72) := g_package||'chk_message_level';
382: --
383: BEGIN
384: --
385: hr_utility.set_location('Entering : '||l_proc,10);
386: --
387: IF p_message_level IS NOT NULL THEN
388: --
389: -- Check mandatory parameter IS set

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

393: ,p_argument => 'effective_date'
394: ,p_argument_value => p_effective_date
395: );
396: --
397: hr_utility.set_location(l_proc,20);
398: --
399: --
400: -- Only proceed with validation if :
401: -- a) Inserting or

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

404: IF ( (p_cagr_entitlement_id IS NULL) OR
405: ((p_cagr_entitlement_id IS NOT NULL) AND
406: (per_pce_shd.g_old_rec.message_level <> p_message_level))) THEN
407: --
408: hr_utility.set_location(l_proc,30);
409: --
410: -- Check that the unit_of_measure exists IN HR_LOOKUPS
411: --
412: IF hr_api.not_exists_in_hr_lookups

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

413: (p_effective_date => p_effective_date
414: ,p_lookup_type => 'CAGR_MESSAGE_LEVEL'
415: ,p_lookup_code => p_message_level) THEN
416: --
417: hr_utility.set_location(l_proc, 40);
418: --
419: hr_utility.set_message(800, 'HR_289268_MESSAGE_LEVEL_INV');
420: hr_utility.raise_error;
421: --

Line 419: hr_utility.set_message(800, 'HR_289268_MESSAGE_LEVEL_INV');

415: ,p_lookup_code => p_message_level) THEN
416: --
417: hr_utility.set_location(l_proc, 40);
418: --
419: hr_utility.set_message(800, 'HR_289268_MESSAGE_LEVEL_INV');
420: hr_utility.raise_error;
421: --
422: END IF;
423: --

Line 420: hr_utility.raise_error;

416: --
417: hr_utility.set_location(l_proc, 40);
418: --
419: hr_utility.set_message(800, 'HR_289268_MESSAGE_LEVEL_INV');
420: hr_utility.raise_error;
421: --
422: END IF;
423: --
424: END IF;

Line 428: hr_utility.set_location('Leaving : '||l_proc, 999);

424: END IF;
425: --
426: END IF;
427: --
428: hr_utility.set_location('Leaving : '||l_proc, 999);
429: --
430: END chk_message_level;
431: --
432: -- ---------------------------------------------------------------------------

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

471: l_proc VARCHAR2(72) := g_package||'chk_formula_criteria_mismatch';
472: --
473: BEGIN
474: --
475: hr_utility.set_location('Entering : '||l_proc,10);
476: --
477: -- Check that if the formula_id IS populated then the
478: -- formula_criteria value should be 'F'
479: --

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

478: -- formula_criteria value should be 'F'
479: --
480: IF p_formula_criteria = 'F' AND p_formula_id IS NULL THEN
481: --
482: hr_utility.set_location(l_proc, 30);
483: --
484: hr_utility.set_message(800, 'HR_289264_FORMULA_CRITERIA_INV');
485: hr_utility.raise_error;
486: --

Line 484: hr_utility.set_message(800, 'HR_289264_FORMULA_CRITERIA_INV');

480: IF p_formula_criteria = 'F' AND p_formula_id IS NULL THEN
481: --
482: hr_utility.set_location(l_proc, 30);
483: --
484: hr_utility.set_message(800, 'HR_289264_FORMULA_CRITERIA_INV');
485: hr_utility.raise_error;
486: --
487: ELSIF p_formula_criteria = 'C' AND p_formula_id IS NOT NULL THEN
488: --

Line 485: hr_utility.raise_error;

481: --
482: hr_utility.set_location(l_proc, 30);
483: --
484: hr_utility.set_message(800, 'HR_289264_FORMULA_CRITERIA_INV');
485: hr_utility.raise_error;
486: --
487: ELSIF p_formula_criteria = 'C' AND p_formula_id IS NOT NULL THEN
488: --
489: hr_utility.set_location(l_proc, 30);

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

485: hr_utility.raise_error;
486: --
487: ELSIF p_formula_criteria = 'C' AND p_formula_id IS NOT NULL THEN
488: --
489: hr_utility.set_location(l_proc, 30);
490: --
491: hr_utility.set_message(800, 'HR_289265_CRITERIA_FORMULA_MIS');
492: hr_utility.raise_error;
493: --

Line 491: hr_utility.set_message(800, 'HR_289265_CRITERIA_FORMULA_MIS');

487: ELSIF p_formula_criteria = 'C' AND p_formula_id IS NOT NULL THEN
488: --
489: hr_utility.set_location(l_proc, 30);
490: --
491: hr_utility.set_message(800, 'HR_289265_CRITERIA_FORMULA_MIS');
492: hr_utility.raise_error;
493: --
494: END IF;
495: --

Line 492: hr_utility.raise_error;

488: --
489: hr_utility.set_location(l_proc, 30);
490: --
491: hr_utility.set_message(800, 'HR_289265_CRITERIA_FORMULA_MIS');
492: hr_utility.raise_error;
493: --
494: END IF;
495: --
496: hr_utility.set_location('Leaving : '||l_proc, 999);

Line 496: hr_utility.set_location('Leaving : '||l_proc, 999);

492: hr_utility.raise_error;
493: --
494: END IF;
495: --
496: hr_utility.set_location('Leaving : '||l_proc, 999);
497: --
498: END chk_formula_criteria_mismatch;
499: --
500: -- ---------------------------------------------------------------------------

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

542: l_proc VARCHAR2(72) := g_package||'chk_formula_criteria';
543: --
544: BEGIN
545: --
546: hr_utility.set_location('Entering : '||l_proc,10);
547: --
548: -- Check mandatory parameter IS set
549: --
550: hr_api.mandatory_arg_error

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

558: ,p_argument => 'formula_criteria'
559: ,p_argument_value => p_formula_criteria
560: );
561: --
562: hr_utility.set_location(l_proc,20);
563: --
564: -- Only validate if we are inserting
565: --
566: IF ( (p_cagr_entitlement_id IS NULL) OR

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

566: IF ( (p_cagr_entitlement_id IS NULL) OR
567: ((p_cagr_entitlement_id IS NOT NULL) AND
568: (per_pce_shd.g_old_rec.formula_id <> p_formula_id))) THEN
569: --
570: hr_utility.set_location(l_proc,30);
571: --
572: -- Check that the formula_criteria exists IN HR_LOOKUPS
573: --
574: IF hr_api.not_exists_in_hr_lookups

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

575: (p_effective_date => p_effective_date
576: ,p_lookup_type => 'CAGR_CRITERIA_TYPE'
577: ,p_lookup_code => p_formula_criteria) THEN
578: --
579: hr_utility.set_location(l_proc, 40);
580: --
581: hr_utility.set_message(800, 'HR_289354_INV_FORM_CRITERIA');
582: hr_utility.raise_error;
583: --

Line 581: hr_utility.set_message(800, 'HR_289354_INV_FORM_CRITERIA');

577: ,p_lookup_code => p_formula_criteria) THEN
578: --
579: hr_utility.set_location(l_proc, 40);
580: --
581: hr_utility.set_message(800, 'HR_289354_INV_FORM_CRITERIA');
582: hr_utility.raise_error;
583: --
584: END IF;
585: --

Line 582: hr_utility.raise_error;

578: --
579: hr_utility.set_location(l_proc, 40);
580: --
581: hr_utility.set_message(800, 'HR_289354_INV_FORM_CRITERIA');
582: hr_utility.raise_error;
583: --
584: END IF;
585: --
586: hr_utility.set_location(l_proc, 50);

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

582: hr_utility.raise_error;
583: --
584: END IF;
585: --
586: hr_utility.set_location(l_proc, 50);
587: --
588: END IF;
589: --
590: hr_utility.set_location('Leaving : '||l_proc, 999);

Line 590: hr_utility.set_location('Leaving : '||l_proc, 999);

586: hr_utility.set_location(l_proc, 50);
587: --
588: END IF;
589: --
590: hr_utility.set_location('Leaving : '||l_proc, 999);
591: --
592: END chk_formula_criteria;
593: --
594: -- ---------------------------------------------------------------------------

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

639: l_item_id per_cagr_entitlements.cagr_entitlement_item_id%TYPE;
640: --
641: BEGIN
642: --
643: hr_utility.set_location('Entering : '||l_proc,10);
644: --
645: -- Only validate if we are inserting a record
646: --
647: IF p_cagr_entitlement_id IS NULL THEN

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

645: -- Only validate if we are inserting a record
646: --
647: IF p_cagr_entitlement_id IS NULL THEN
648: --
649: hr_utility.set_location(l_proc,20);
650: --
651: OPEN chk_id;
652: FETCH chk_id INTO l_item_id;
653: --

Line 661: hr_utility.set_message(800, 'HR_289353_ITEM_ID_INVALID');

657: IF chk_id%NOTFOUND THEN
658: --
659: CLOSE chk_id;
660: --
661: hr_utility.set_message(800, 'HR_289353_ITEM_ID_INVALID');
662: hr_utility.raise_error;
663: --
664: ELSE
665: --

Line 662: hr_utility.raise_error;

658: --
659: CLOSE chk_id;
660: --
661: hr_utility.set_message(800, 'HR_289353_ITEM_ID_INVALID');
662: hr_utility.raise_error;
663: --
664: ELSE
665: --
666: CLOSE chk_id;

Line 671: hr_utility.set_location('Leaving : '||l_proc,999);

667: --
668: END IF;
669: --
670: END IF;
671: hr_utility.set_location('Leaving : '||l_proc,999);
672: --
673: END chk_cagr_entitlement_item_id;
674: --
675: -- ---------------------------------------------------------------------------

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

722: l_item_id per_cagr_entitlements.collective_agreement_id%TYPE;
723: --
724: BEGIN
725: --
726: hr_utility.set_location('Entering : '||l_proc,10);
727: --
728: -- Only validate if we are inserting a record
729: --
730: IF p_cagr_entitlement_id IS NULL THEN

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

728: -- Only validate if we are inserting a record
729: --
730: IF p_cagr_entitlement_id IS NULL THEN
731: --
732: hr_utility.set_location(l_proc,20);
733: --
734: OPEN chk_id;
735: FETCH chk_id INTO l_item_id;
736: --

Line 744: hr_utility.set_message(800, 'PER_52816_COLLECTIVE_AGREEMENT');

740: IF chk_id%NOTFOUND THEN
741: --
742: CLOSE chk_id;
743: --
744: hr_utility.set_message(800, 'PER_52816_COLLECTIVE_AGREEMENT');
745: hr_utility.raise_error;
746: --
747: ELSE
748: --

Line 745: hr_utility.raise_error;

741: --
742: CLOSE chk_id;
743: --
744: hr_utility.set_message(800, 'PER_52816_COLLECTIVE_AGREEMENT');
745: hr_utility.raise_error;
746: --
747: ELSE
748: --
749: CLOSE chk_id;

Line 754: hr_utility.set_location('Leaving : '||l_proc,999);

750: --
751: END IF;
752: --
753: END IF;
754: hr_utility.set_location('Leaving : '||l_proc,999);
755: --
756: END chk_collective_agreement_id;
757: --
758: -- ---------------------------------------------------------------------------

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

820: l_dummy_id per_cagr_entitlements.formula_id%TYPE;
821: --
822: BEGIN
823: --
824: hr_utility.set_location('Entering : '||l_proc,10);
825: --
826: -- Check mandatory parameter IS set
827: --
828: hr_api.mandatory_arg_error

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

836: ,p_argument => 'formula_criteria'
837: ,p_argument_value => p_formula_criteria
838: );
839: --
840: hr_utility.set_location(l_proc,20);
841: --
842: -- Only proceed with validation if :
843: -- a) Inserting or
844: -- b) The value for formula id has changed

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

846: IF ( (p_cagr_entitlement_id IS NULL) OR
847: ((p_cagr_entitlement_id IS NOT NULL) AND
848: (per_pce_shd.g_old_rec.formula_id <> p_formula_id))) THEN
849: --
850: hr_utility.set_location(l_proc,30);
851: --
852: -- Only check the ff_formula_f table if the
853: -- p_formula_id has a values
854: --

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

858: FETCH chk_formula_id INTO l_dummy_id;
859: --
860: IF chk_formula_id%NOTFOUND THEN
861: --
862: hr_utility.set_location(l_proc, 40);
863: --
864: CLOSE chk_formula_id;
865: --
866: hr_utility.set_message(800, 'HR_289263_FORMULA_ID_INVALID');

Line 866: hr_utility.set_message(800, 'HR_289263_FORMULA_ID_INVALID');

862: hr_utility.set_location(l_proc, 40);
863: --
864: CLOSE chk_formula_id;
865: --
866: hr_utility.set_message(800, 'HR_289263_FORMULA_ID_INVALID');
867: hr_utility.raise_error;
868: --
869: ELSE
870: --

Line 867: hr_utility.raise_error;

863: --
864: CLOSE chk_formula_id;
865: --
866: hr_utility.set_message(800, 'HR_289263_FORMULA_ID_INVALID');
867: hr_utility.raise_error;
868: --
869: ELSE
870: --
871: hr_utility.set_location(l_proc, 50);

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

867: hr_utility.raise_error;
868: --
869: ELSE
870: --
871: hr_utility.set_location(l_proc, 50);
872: --
873: CLOSE chk_formula_id;
874: --
875: END IF;

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

875: END IF;
876: --
877: END IF;
878: --
879: hr_utility.set_location(l_proc, 60);
880: --
881: -- Check that if the formula_id IS populated then the
882: -- formula_criteria field IS set to 'FORMULA' and that
883: -- if the formula_id IS NULL then the formula_criteria

Line 893: hr_utility.set_location('Leaving : '||l_proc, 999);

889: );
890: --
891: END IF;
892: --
893: hr_utility.set_location('Leaving : '||l_proc, 999);
894: --
895: END chk_formula_id;
896: --
897: -- ---------------------------------------------------------------------------

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

946: l_dummy_date per_cagr_entitlements.start_date%TYPE;
947: --
948: BEGIN
949: --
950: hr_utility.set_location('Entering : '||l_proc,10);
951: --
952: -- Check mandatory parameter IS set
953: --
954: hr_api.mandatory_arg_error

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

956: ,p_argument => 'start_date'
957: ,p_argument_value => p_start_date
958: );
959: --
960: hr_utility.set_location(l_proc,20);
961: --
962: -- Check that the start_date IS not before the
963: -- start_date for the collective agreements.
964: --

Line 972: hr_utility.set_message(800, 'HR_289261_ST_DATE_BEFORE_CAGR');

968: IF chk_collective_agreement_date%FOUND THEN
969: --
970: CLOSE chk_collective_agreement_date;
971: --
972: hr_utility.set_message(800, 'HR_289261_ST_DATE_BEFORE_CAGR');
973: hr_utility.raise_error;
974: --
975: ELSE
976: --

Line 973: hr_utility.raise_error;

969: --
970: CLOSE chk_collective_agreement_date;
971: --
972: hr_utility.set_message(800, 'HR_289261_ST_DATE_BEFORE_CAGR');
973: hr_utility.raise_error;
974: --
975: ELSE
976: --
977: hr_utility.set_location(l_proc,40);

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

973: hr_utility.raise_error;
974: --
975: ELSE
976: --
977: hr_utility.set_location(l_proc,40);
978: --
979: CLOSE chk_collective_agreement_date;
980: --
981: END IF;

Line 987: hr_utility.set_message(800, 'HR_289262_ST_DATE_BEFORE_EDATE');

983: -- Check that start_date IS not after the end_date
984: --
985: IF p_start_date > p_end_date THEN
986: --
987: hr_utility.set_message(800, 'HR_289262_ST_DATE_BEFORE_EDATE');
988: hr_utility.raise_error;
989: --
990: END IF;
991: --

Line 988: hr_utility.raise_error;

984: --
985: IF p_start_date > p_end_date THEN
986: --
987: hr_utility.set_message(800, 'HR_289262_ST_DATE_BEFORE_EDATE');
988: hr_utility.raise_error;
989: --
990: END IF;
991: --
992: hr_utility.set_location('Leaving : '||l_proc, 999);

Line 992: hr_utility.set_location('Leaving : '||l_proc, 999);

988: hr_utility.raise_error;
989: --
990: END IF;
991: --
992: hr_utility.set_location('Leaving : '||l_proc, 999);
993: --
994: END chk_start_date;
995: --
996: -- ---------------------------------------------------------------------------

Line 1051: hr_utility.set_location('Entering : '||p_end_date||'/'||l_proc,10);

1047: l_dummy VARCHAR2(1);
1048: --
1049: BEGIN
1050: --
1051: hr_utility.set_location('Entering : '||p_end_date||'/'||l_proc,10);
1052: --
1053: --
1054: -- Only proceed with validation if :
1055: -- a) Inserting or

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

1060: ((p_cagr_entitlement_id IS NOT NULL) AND
1061: (per_pce_shd.g_old_rec.end_date <>
1062: NVL(p_end_date,hr_general.end_of_time)))) THEN*/
1063: --
1064: hr_utility.set_location(l_proc,20);
1065: --
1066: -- Check that start_date IS not after the end_date
1067: --
1068: IF NVL(p_end_date,hr_general.end_of_time) < p_start_date THEN

Line 1070: hr_utility.set_message(800, 'HR_289271_EDATE_AFTER_ST_DATE');

1066: -- Check that start_date IS not after the end_date
1067: --
1068: IF NVL(p_end_date,hr_general.end_of_time) < p_start_date THEN
1069: --
1070: hr_utility.set_message(800, 'HR_289271_EDATE_AFTER_ST_DATE');
1071: hr_utility.raise_error;
1072: --
1073: END IF;
1074: --

Line 1071: hr_utility.raise_error;

1067: --
1068: IF NVL(p_end_date,hr_general.end_of_time) < p_start_date THEN
1069: --
1070: hr_utility.set_message(800, 'HR_289271_EDATE_AFTER_ST_DATE');
1071: hr_utility.raise_error;
1072: --
1073: END IF;
1074: --
1075: -- Check that the end_date is not before any end dates for

Line 1085: hr_utility.set_message(800, 'HR_289393_INV_END_DATE');

1081: IF csr_check_line_end_dates%FOUND THEN
1082: --
1083: CLOSE csr_check_line_end_dates;
1084: --
1085: hr_utility.set_message(800, 'HR_289393_INV_END_DATE');
1086: hr_utility.raise_error;
1087: --
1088: ELSE
1089: --

Line 1086: hr_utility.raise_error;

1082: --
1083: CLOSE csr_check_line_end_dates;
1084: --
1085: hr_utility.set_message(800, 'HR_289393_INV_END_DATE');
1086: hr_utility.raise_error;
1087: --
1088: ELSE
1089: --
1090: CLOSE csr_check_line_end_dates;

Line 1099: hr_utility.set_message(800, 'HR_289394_EDATE_BEFORE_EFF_DAT');

1095: -- to a date before the effective date
1096: --
1097: IF NVL(p_end_date,hr_general.end_of_time) < p_effective_date THEN
1098: --
1099: hr_utility.set_message(800, 'HR_289394_EDATE_BEFORE_EFF_DAT');
1100: hr_utility.raise_error;
1101: --
1102: END IF;
1103: --

Line 1100: hr_utility.raise_error;

1096: --
1097: IF NVL(p_end_date,hr_general.end_of_time) < p_effective_date THEN
1098: --
1099: hr_utility.set_message(800, 'HR_289394_EDATE_BEFORE_EFF_DAT');
1100: hr_utility.raise_error;
1101: --
1102: END IF;
1103: --
1104: -- END IF;

Line 1106: hr_utility.set_location('Leaving : '||l_proc, 999);

1102: END IF;
1103: --
1104: -- END IF;
1105: --
1106: hr_utility.set_location('Leaving : '||l_proc, 999);
1107: --
1108: END chk_end_date;
1109: --
1110: -- ---------------------------------------------------------------------------

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

1158: l_dummy_id per_cagr_entitlements.cagr_entitlement_id%TYPE;
1159: --
1160: BEGIN
1161: --
1162: hr_utility.set_location('Entering : '||l_proc,10);
1163: --
1164: -- Check mandatory parameter IS set
1165: --
1166: hr_api.mandatory_arg_error

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

1174: ,p_argument => 'cagr_entitlement_item_id'
1175: ,p_argument_value => p_cagr_entitlement_item_id
1176: );
1177: --
1178: hr_utility.set_location(l_proc,20);
1179: --
1180: -- Validate that the entitlement item has not already
1181: -- been defined within the collective agreement.
1182: --

Line 1190: hr_utility.set_message(800, 'HR_289272_ENTITLEMENT_NOT_UNIQ');

1186: IF csr_chk_uniqueness%FOUND THEN
1187: --
1188: CLOSE csr_chk_uniqueness;
1189: --
1190: hr_utility.set_message(800, 'HR_289272_ENTITLEMENT_NOT_UNIQ');
1191: hr_utility.raise_error;
1192: --
1193: ELSE
1194: --

Line 1191: hr_utility.raise_error;

1187: --
1188: CLOSE csr_chk_uniqueness;
1189: --
1190: hr_utility.set_message(800, 'HR_289272_ENTITLEMENT_NOT_UNIQ');
1191: hr_utility.raise_error;
1192: --
1193: ELSE
1194: --
1195: hr_utility.set_location(l_proc,30);

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

1191: hr_utility.raise_error;
1192: --
1193: ELSE
1194: --
1195: hr_utility.set_location(l_proc,30);
1196: --
1197: CLOSE csr_chk_uniqueness;
1198: --
1199: END IF;

Line 1201: hr_utility.set_location('Leaving : '||l_proc, 999);

1197: CLOSE csr_chk_uniqueness;
1198: --
1199: END IF;
1200: --
1201: hr_utility.set_location('Leaving : '||l_proc, 999);
1202: --
1203: END chk_entitlement_uniqueness;
1204: --
1205: -- ----------------------------------------------------------------------------

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

1214: l_business_group_id NUMBER;
1215: --
1216: BEGIN
1217: --
1218: hr_utility.set_location('Entering:'||l_proc, 5);
1219: --
1220: -- Call procedure that returns the business_group_id
1221: -- that will be used in the chk procedures
1222: --

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

1231: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1232: ,p_collective_agreement_id => p_rec.collective_agreement_id
1233: ); */
1234: --
1235: hr_utility.set_location(l_proc,20);
1236: --
1237: per_pce_bus.chk_start_date
1238: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1239: ,p_start_date => p_rec.start_date

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

1240: ,p_end_date => p_rec.end_date
1241: ,p_collective_Agreement_id => p_rec.collective_agreement_id
1242: );
1243: --
1244: hr_utility.set_location(l_proc,25);
1245: --
1246: per_pce_bus.chk_end_date
1247: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1248: ,p_start_date => p_rec.start_date

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

1249: ,p_end_date => p_rec.end_date
1250: ,p_effective_date => p_effective_date
1251: );
1252: --
1253: hr_utility.set_location(l_proc,30);
1254: --
1255: per_pce_bus.chk_formula_id
1256: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1257: ,p_effective_date => p_effective_date

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

1259: ,p_business_group_id => l_business_group_id
1260: ,p_formula_criteria => p_rec.formula_criteria
1261: );
1262: --
1263: hr_utility.set_location(l_proc,40);
1264: --
1265: per_pce_bus.chk_formula_criteria
1266: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1267: ,p_effective_date => p_effective_date

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

1268: ,p_formula_id => p_rec.formula_id
1269: ,p_formula_criteria => p_rec.formula_criteria
1270: );
1271: --
1272: hr_utility.set_location(l_proc,50);
1273: --
1274: per_pce_bus.chk_formula_criteria_mismatch
1275: (p_formula_id => p_rec.formula_id
1276: ,p_formula_criteria => p_rec.formula_criteria

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

1275: (p_formula_id => p_rec.formula_id
1276: ,p_formula_criteria => p_rec.formula_criteria
1277: );
1278: --
1279: hr_utility.set_location(l_proc,60);
1280: --
1281: per_pce_bus.chk_status
1282: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1283: ,p_effective_date => p_effective_date

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

1283: ,p_effective_date => p_effective_date
1284: ,p_status => p_rec.status
1285: );
1286: --
1287: hr_utility.set_location(l_proc,70);
1288: --
1289: per_pce_bus.chk_message_level
1290: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1291: ,p_effective_date => p_effective_date

Line 1295: hr_utility.set_location(l_proc,80);

1291: ,p_effective_date => p_effective_date
1292: ,p_message_level => p_rec.message_level
1293: );
1294: --
1295: hr_utility.set_location(l_proc,80);
1296: --
1297: per_pce_bus.chk_cagr_entitlement_item_id
1298: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1299: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id);

Line 1301: hr_utility.set_location(l_proc,90);

1297: per_pce_bus.chk_cagr_entitlement_item_id
1298: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1299: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id);
1300: --
1301: hr_utility.set_location(l_proc,90);
1302: --
1303: per_pce_bus. chk_entitlement_uniqueness
1304: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1305: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id

Line 1309: hr_utility.set_location(l_proc,100);

1305: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
1306: ,p_collective_agreement_id => p_rec.collective_agreement_id
1307: );
1308: --
1309: hr_utility.set_location(l_proc,100);
1310: --
1311: per_pce_bus.chk_collective_agreement_id
1312: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1313: ,p_business_group_id => l_business_group_id

Line 1316: hr_utility.set_location(' Leaving:'||l_proc, 900);

1312: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1313: ,p_business_group_id => l_business_group_id
1314: ,p_collective_agreement_id => p_rec.collective_agreement_id);
1315: --
1316: hr_utility.set_location(' Leaving:'||l_proc, 900);
1317: --
1318: END insert_validate;
1319: --
1320: -- ----------------------------------------------------------------------------

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

1330: l_business_group_id NUMBER;
1331: --
1332: BEGIN
1333: --
1334: hr_utility.set_location('Entering:'||l_proc, 10);
1335: --
1336: -- Call all supporting business operations
1337: --
1338: per_pce_bus.set_security_group_id

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

1346: per_pce_shd.retrieve_cagr_info
1347: (p_collective_agreement_id => p_rec.collective_agreement_id
1348: ,p_business_group_id => l_business_group_id);
1349: --
1350: hr_utility.set_location(l_proc,20);
1351: --
1352: chk_non_updateable_args
1353: (p_effective_date => p_effective_date
1354: ,p_rec => p_rec

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

1353: (p_effective_date => p_effective_date
1354: ,p_rec => p_rec
1355: );
1356: --
1357: hr_utility.set_location(l_proc,30);
1358: --
1359: per_pce_bus.chk_formula_id
1360: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1361: ,p_effective_date => p_effective_date

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

1363: ,p_formula_id => p_rec.formula_id
1364: ,p_formula_criteria => p_Rec.formula_criteria
1365: );
1366: --
1367: hr_utility.set_location(l_proc,50);
1368: --
1369: per_pce_bus.chk_formula_criteria
1370: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1371: ,p_effective_date => p_effective_date

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

1372: ,p_formula_id => p_rec.formula_id
1373: ,p_formula_criteria => p_rec.formula_criteria
1374: );
1375: --
1376: hr_utility.set_location(l_proc,60);
1377: --
1378: per_pce_bus.chk_formula_criteria_mismatch
1379: (p_formula_id => p_rec.formula_id
1380: ,p_formula_criteria => p_rec.formula_criteria

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

1379: (p_formula_id => p_rec.formula_id
1380: ,p_formula_criteria => p_rec.formula_criteria
1381: );
1382: --
1383: hr_utility.set_location(l_proc,70);
1384: --
1385: per_pce_bus.chk_status
1386: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1387: ,p_effective_date => p_effective_date

Line 1391: hr_utility.set_location(l_proc,80);

1387: ,p_effective_date => p_effective_date
1388: ,p_status => p_rec.status
1389: );
1390: --
1391: hr_utility.set_location(l_proc,80);
1392: --
1393: per_pce_bus.chk_message_level
1394: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1395: ,p_effective_date => p_effective_date

Line 1399: hr_utility.set_location(' Leaving:'||l_proc, 999);

1395: ,p_effective_date => p_effective_date
1396: ,p_message_level => p_rec.message_level
1397: );
1398: --
1399: hr_utility.set_location(' Leaving:'||l_proc, 999);
1400: --
1401: END update_validate;
1402: --
1403: -- ----------------------------------------------------------------------------

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

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

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

1413: hr_utility.set_location('Entering:'||l_proc, 5);
1414: --
1415: -- Call all supporting business operations
1416: --
1417: hr_utility.set_location(' Leaving:'||l_proc, 10);
1418: --
1419: END delete_validate;
1420: --
1421: END per_pce_bus;