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_CPA_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_cpa_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_cpa_bus.g_cagr_api_param_id := p_cagr_api_param_id;
150: per_cpa_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 201: hr_utility.set_location('Entering:'||l_proc, 10);

197: WHERE per.cagr_api_id = p_cagr_api_id;
198: --
199: BEGIN
200: --
201: hr_utility.set_location('Entering:'||l_proc, 10);
202: --
203: -- Check mandatory cagr_api_id is set
204: --
205: if p_cagr_api_id is null then

Line 207: hr_utility.set_message(800, 'HR_289135_CAGR_API_ID_NULL');

203: -- Check mandatory cagr_api_id is set
204: --
205: if p_cagr_api_id is null then
206: --
207: hr_utility.set_message(800, 'HR_289135_CAGR_API_ID_NULL');
208: hr_utility.raise_error;
209: --
210: end if;
211: --

Line 208: hr_utility.raise_error;

204: --
205: if p_cagr_api_id is null then
206: --
207: hr_utility.set_message(800, 'HR_289135_CAGR_API_ID_NULL');
208: hr_utility.raise_error;
209: --
210: end if;
211: --
212: hr_utility.set_location(l_proc, 20);

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

208: hr_utility.raise_error;
209: --
210: end if;
211: --
212: hr_utility.set_location(l_proc, 20);
213: --
214: -- Only proceed with validation if :
215: -- a) on insert (cagr_api_id is a non-updateable param)
216: --

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

215: -- a) on insert (cagr_api_id is a non-updateable param)
216: --
217: if (p_cagr_api_param_id is null) then
218: --
219: hr_utility.set_location(l_proc, 30);
220: --
221: -- Check that the person_id is in the per_people_f view on the effective_date.
222: --
223: open csr_cagr_api_id;

Line 230: hr_utility.set_message(800, 'HR_289136_CAGR_API_ID_INV');

226: if csr_cagr_api_id%notfound then
227: --
228: close csr_cagr_api_id;
229: --
230: hr_utility.set_message(800, 'HR_289136_CAGR_API_ID_INV');
231: hr_utility.raise_error;
232: --
233: end if;
234: --

Line 231: hr_utility.raise_error;

227: --
228: close csr_cagr_api_id;
229: --
230: hr_utility.set_message(800, 'HR_289136_CAGR_API_ID_INV');
231: hr_utility.raise_error;
232: --
233: end if;
234: --
235: close csr_cagr_api_id;

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

235: close csr_cagr_api_id;
236: --
237: end if;
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 40);
240: --
241: end chk_cagr_api_id;
242: --
243: -- ---------------------------------------------------------------------------

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

289: --
290:
291: BEGIN
292: --
293: hr_utility.set_location('Entering:'||l_proc, 10);
294: --
295: -- Check Display_Name is not null
296: --
297: IF p_display_name IS NULL THEN

Line 299: hr_utility.set_message(800, 'HR_289137_DISPLAY_NAME_NULL');

295: -- Check Display_Name is not null
296: --
297: IF p_display_name IS NULL THEN
298: --
299: hr_utility.set_message(800, 'HR_289137_DISPLAY_NAME_NULL');
300: hr_utility.raise_error;
301: --
302: END IF;
303: --

Line 300: hr_utility.raise_error;

296: --
297: IF p_display_name IS NULL THEN
298: --
299: hr_utility.set_message(800, 'HR_289137_DISPLAY_NAME_NULL');
300: hr_utility.raise_error;
301: --
302: END IF;
303: --
304: hr_utility.set_location(l_proc,20);

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

300: hr_utility.raise_error;
301: --
302: END IF;
303: --
304: hr_utility.set_location(l_proc,20);
305: --
306: -- Only proceed with validation if :
307: -- a) Inserting or
308: -- b) The value for consultation type has changed

Line 324: hr_utility.set_message(800, 'HR_289138_DISPLAY_NAME_INVALID');

320: IF csr_chk_display_name%FOUND THEN
321: --
322: CLOSE csr_chk_display_name;
323: --
324: hr_utility.set_message(800, 'HR_289138_DISPLAY_NAME_INVALID');
325: hr_utility.raise_error;
326: --
327: ELSE
328: --

Line 325: hr_utility.raise_error;

321: --
322: CLOSE csr_chk_display_name;
323: --
324: hr_utility.set_message(800, 'HR_289138_DISPLAY_NAME_INVALID');
325: hr_utility.raise_error;
326: --
327: ELSE
328: --
329: CLOSE csr_chk_display_name;

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

331: END IF;
332: --
333: END IF;
334: --
335: hr_utility.set_location('Leaving:'||l_proc, 30);
336: --
337: END chk_display_name;
338: --
339: -- ---------------------------------------------------------------------------

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

386: --
387:
388: BEGIN
389: --
390: hr_utility.set_location('Entering:'||l_proc, 10);
391: --
392: -- Check parameter_name is not null
393: --
394: IF p_parameter_name IS NULL THEN

Line 396: hr_utility.set_message(800, 'HR_289200_PARAMETER_NAME_NULL');

392: -- Check parameter_name is not null
393: --
394: IF p_parameter_name IS NULL THEN
395: --
396: hr_utility.set_message(800, 'HR_289200_PARAMETER_NAME_NULL');
397: hr_utility.raise_error;
398: --
399: END IF;
400: --

Line 397: hr_utility.raise_error;

393: --
394: IF p_parameter_name IS NULL THEN
395: --
396: hr_utility.set_message(800, 'HR_289200_PARAMETER_NAME_NULL');
397: hr_utility.raise_error;
398: --
399: END IF;
400: --
401: hr_utility.set_location(l_proc,20);

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

397: hr_utility.raise_error;
398: --
399: END IF;
400: --
401: hr_utility.set_location(l_proc,20);
402: --
403: -- Only proceed with validation if :
404: -- a) Inserting or
405: -- b) The value for consultation type has changed

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

407: IF ( (p_cagr_api_param_id IS NULL) OR
408: ((p_cagr_api_param_id IS NOT NULL) AND
409: (per_cpa_shd.g_old_rec.parameter_name <> p_parameter_name))) THEN
410: --
411: hr_utility.set_location(l_proc,30);
412: --
413: -- Check parameter_name is unique within the API.
414: --
415: OPEN csr_chk_parameter_name;

Line 422: hr_utility.set_message(800, 'HR_289201_PARAMETER_NAME_INVAL');

418: IF csr_chk_parameter_name%FOUND THEN
419: --
420: CLOSE csr_chk_parameter_name;
421: --
422: hr_utility.set_message(800, 'HR_289201_PARAMETER_NAME_INVAL');
423: hr_utility.raise_error;
424: --
425: ELSE
426: --

Line 423: hr_utility.raise_error;

419: --
420: CLOSE csr_chk_parameter_name;
421: --
422: hr_utility.set_message(800, 'HR_289201_PARAMETER_NAME_INVAL');
423: hr_utility.raise_error;
424: --
425: ELSE
426: --
427: CLOSE csr_chk_parameter_name;

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

429: END IF;
430: --
431: END IF;
432: --
433: hr_utility.set_location('Leaving:'||l_proc, 40);
434: --
435: END chk_parameter_name;
436: --
437: -- ---------------------------------------------------------------------------

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

473: l_proc VARCHAR2(72) := g_package || 'chk_hidden';
474: --
475: BEGIN
476: --
477: hr_utility.set_location('Entering '||l_proc, 10);
478: --
479: -- Check mandatory parameters has been set
480: --
481: hr_api.mandatory_arg_error

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

490: IF ( (p_cagr_api_param_id IS NULL) OR
491: ((p_cagr_api_param_id IS NOT NULL) AND
492: (per_cpa_shd.g_old_rec.hidden <> p_hidden))) THEN
493: --
494: hr_utility.set_location(l_proc, 20);
495: --
496: -- Check that the type exists in HR_LOOKUPS
497: --
498: IF hr_api.not_exists_in_hr_lookups

Line 503: hr_utility.set_message(800, 'HR_289472_HIDDEN_VALUE_INVALID');

499: (p_effective_date => p_effective_date
500: ,p_lookup_type => 'YES_NO'
501: ,p_lookup_code => p_hidden) THEN
502: --
503: hr_utility.set_message(800, 'HR_289472_HIDDEN_VALUE_INVALID');
504: hr_utility.raise_error;
505: --
506: END IF;
507: --

Line 504: hr_utility.raise_error;

500: ,p_lookup_type => 'YES_NO'
501: ,p_lookup_code => p_hidden) THEN
502: --
503: hr_utility.set_message(800, 'HR_289472_HIDDEN_VALUE_INVALID');
504: hr_utility.raise_error;
505: --
506: END IF;
507: --
508: END IF;

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

506: END IF;
507: --
508: END IF;
509: --
510: hr_utility.set_location('Leaving '||l_proc, 999);
511: --
512: END chk_hidden;
513: --
514: -- ---------------------------------------------------------------------------

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

550: l_proc VARCHAR2(72) := g_package || 'chk_column_type';
551: --
552: BEGIN
553: --
554: hr_utility.set_location('Entering '||l_proc, 10);
555: --
556: IF p_column_type IS NULL THEN
557: --
558: hr_utility.set_message(800, 'HR_289204_COLUMN_TYPE_NULL');

Line 558: hr_utility.set_message(800, 'HR_289204_COLUMN_TYPE_NULL');

554: hr_utility.set_location('Entering '||l_proc, 10);
555: --
556: IF p_column_type IS NULL THEN
557: --
558: hr_utility.set_message(800, 'HR_289204_COLUMN_TYPE_NULL');
559: hr_utility.raise_error;
560: --
561: END IF;
562: --

Line 559: hr_utility.raise_error;

555: --
556: IF p_column_type IS NULL THEN
557: --
558: hr_utility.set_message(800, 'HR_289204_COLUMN_TYPE_NULL');
559: hr_utility.raise_error;
560: --
561: END IF;
562: --
563: -- Only proceed with validation if :

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

567: IF ( (p_cagr_api_param_id IS NULL) OR
568: ((p_cagr_api_param_id IS NOT NULL) AND
569: (per_cpa_shd.g_old_rec.column_type <> p_column_type))) THEN
570: --
571: hr_utility.set_location(l_proc, 20);
572: --
573: -- Check that the type exists in HR_LOOKUPS
574: --
575: IF hr_api.not_exists_in_hr_lookups

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

576: (p_effective_date => p_effective_date
577: ,p_lookup_type => 'CAGR_PARAM_TYPES'
578: ,p_lookup_code => p_column_type) THEN
579: --
580: hr_utility.set_location(l_proc, 30);
581: --
582: hr_utility.set_message(800, 'HR_289205_COLUMN_TYPE_INVALID');
583: hr_utility.raise_error;
584: --

Line 582: hr_utility.set_message(800, 'HR_289205_COLUMN_TYPE_INVALID');

578: ,p_lookup_code => p_column_type) THEN
579: --
580: hr_utility.set_location(l_proc, 30);
581: --
582: hr_utility.set_message(800, 'HR_289205_COLUMN_TYPE_INVALID');
583: hr_utility.raise_error;
584: --
585: END IF;
586: --

Line 583: hr_utility.raise_error;

579: --
580: hr_utility.set_location(l_proc, 30);
581: --
582: hr_utility.set_message(800, 'HR_289205_COLUMN_TYPE_INVALID');
583: hr_utility.raise_error;
584: --
585: END IF;
586: --
587: END IF;

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

585: END IF;
586: --
587: END IF;
588: --
589: hr_utility.set_location('Leaving '||l_proc, 40);
590: --
591: END chk_column_type;
592: --
593: -- ---------------------------------------------------------------------------

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

625: l_proc VARCHAR2(72) := g_package || 'chk_column_size';
626: --
627: BEGIN
628: --
629: hr_utility.set_location('Entering '||l_proc, 10);
630: --
631: -- Check column_size is not null
632: --
633: IF p_column_size IS NULL THEN

Line 635: hr_utility.set_message(800, 'HR_289202_COLUMN_SIZE_NULL');

631: -- Check column_size is not null
632: --
633: IF p_column_size IS NULL THEN
634: --
635: hr_utility.set_message(800, 'HR_289202_COLUMN_SIZE_NULL');
636: hr_utility.raise_error;
637: --
638: END IF;
639: --

Line 636: hr_utility.raise_error;

632: --
633: IF p_column_size IS NULL THEN
634: --
635: hr_utility.set_message(800, 'HR_289202_COLUMN_SIZE_NULL');
636: hr_utility.raise_error;
637: --
638: END IF;
639: --
640: hr_utility.set_location('Leaving '||l_proc, 30);

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

636: hr_utility.raise_error;
637: --
638: END IF;
639: --
640: hr_utility.set_location('Leaving '||l_proc, 30);
641: --
642: END chk_column_size;
643: --
644: -- ---------------------------------------------------------------------------

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

687: (p_cagr_api_param_id IS NULL));
688: --
689: BEGIN
690: --
691: hr_utility.set_location('Entering :'||l_proc, 10);
692: --
693: -- Only proceed with validation if :
694: -- a) Inserting or
695: -- b) The value for consultation type has changed

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

697: IF ( (p_cagr_api_param_id IS NULL) OR
698: ((p_cagr_api_param_id IS NOT NULL) AND
699: (per_cpa_shd.g_old_rec.uom_parameter <> p_uom_parameter))) THEN
700: --
701: hr_utility.set_location(l_proc, 20);
702: --
703: OPEN csr_get_uom_parameter;
704: FETCH csr_get_uom_parameter INTO l_dummy;
705: --

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

704: FETCH csr_get_uom_parameter INTO l_dummy;
705: --
706: IF csr_get_uom_parameter%FOUND THEN
707: --
708: hr_utility.set_location(l_proc, 30);
709: --
710: CLOSE csr_get_uom_parameter;
711: --
712: hr_utility.set_message(800, 'HR_289206_UOM_PARAMETER_INVAL');

Line 712: hr_utility.set_message(800, 'HR_289206_UOM_PARAMETER_INVAL');

708: hr_utility.set_location(l_proc, 30);
709: --
710: CLOSE csr_get_uom_parameter;
711: --
712: hr_utility.set_message(800, 'HR_289206_UOM_PARAMETER_INVAL');
713: hr_utility.raise_error;
714: --
715: ELSE
716: --

Line 713: hr_utility.raise_error;

709: --
710: CLOSE csr_get_uom_parameter;
711: --
712: hr_utility.set_message(800, 'HR_289206_UOM_PARAMETER_INVAL');
713: hr_utility.raise_error;
714: --
715: ELSE
716: --
717: hr_utility.set_location(l_proc, 40);

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

713: hr_utility.raise_error;
714: --
715: ELSE
716: --
717: hr_utility.set_location(l_proc, 40);
718: --
719: CLOSE csr_get_uom_parameter;
720: --
721: END IF;

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

721: END IF;
722: --
723: END IF;
724: --
725: hr_utility.set_location('Leaving :'||l_proc, 50);
726: --
727: END chk_uom_parameter;
728: --
729: -- ---------------------------------------------------------------------------

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

773: AND NVL(hl.end_date_active,hr_general.end_of_time);
774: --
775: BEGIN
776: --
777: hr_utility.set_location('Entering :'||l_proc,10);
778: --
779: IF p_uom_lookup IS NOT NULL THEN
780: --
781: -- Only proceed with validation if :

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

786: ((p_cagr_api_param_id IS NOT NULL) AND
787: (NVL(per_cpa_shd.g_old_rec.uom_lookup,hr_api.g_varchar2) <>
788: NVL(p_uom_lookup,hr_api.g_varchar2)))) THEN
789: --
790: hr_utility.set_location(l_proc, 20);
791: --
792: -- Check that the type exists in HR_LOOKUPS
793: --
794: OPEN csr_get_lookup_type;

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

795: FETCH csr_get_lookup_type INTO l_dummy;
796: --
797: IF csr_get_lookup_type%NOTFOUND THEN
798: --
799: hr_utility.set_location(l_proc, 30);
800: --
801: CLOSE csr_get_lookup_type;
802: --
803: hr_utility.set_message(800, 'HR_289207_UOM_LOOKUP_INVALID');

Line 803: hr_utility.set_message(800, 'HR_289207_UOM_LOOKUP_INVALID');

799: hr_utility.set_location(l_proc, 30);
800: --
801: CLOSE csr_get_lookup_type;
802: --
803: hr_utility.set_message(800, 'HR_289207_UOM_LOOKUP_INVALID');
804: hr_utility.raise_error;
805: --
806: ELSE
807: --

Line 804: hr_utility.raise_error;

800: --
801: CLOSE csr_get_lookup_type;
802: --
803: hr_utility.set_message(800, 'HR_289207_UOM_LOOKUP_INVALID');
804: hr_utility.raise_error;
805: --
806: ELSE
807: --
808: hr_utility.set_location(l_proc, 40);

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

804: hr_utility.raise_error;
805: --
806: ELSE
807: --
808: hr_utility.set_location(l_proc, 40);
809: --
810: CLOSE csr_get_lookup_type;
811: --
812: END IF;

Line 820: hr_utility.set_message(800, 'HR_289512_DFLT_UOM_UOM_LOOKUP');

816: --
817: IF p_default_uom IS NOT NULL AND
818: p_uom_lookup IS NOT NULL THEN
819: --
820: hr_utility.set_message(800, 'HR_289512_DFLT_UOM_UOM_LOOKUP');
821: hr_utility.raise_error;
822: --
823: END IF;
824: --

Line 821: hr_utility.raise_error;

817: IF p_default_uom IS NOT NULL AND
818: p_uom_lookup IS NOT NULL THEN
819: --
820: hr_utility.set_message(800, 'HR_289512_DFLT_UOM_UOM_LOOKUP');
821: hr_utility.raise_error;
822: --
823: END IF;
824: --
825: END IF;

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

825: END IF;
826: --
827: END IF;
828: --
829: hr_utility.set_location('Leaving :'||l_proc,50);
830: --
831: END chk_uom_lookup;
832: --
833: -- ---------------------------------------------------------------------------

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

873: l_dummy per_cagr_api_parameters.uom_lookup%TYPE;
874: --
875: BEGIN
876: --
877: hr_utility.set_location('Entering :'||l_proc,10);
878: --
879: IF p_default_uom IS NOT NULL THEN
880: --
881: -- Only proceed with validation if :

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

886: ((p_cagr_api_param_id IS NOT NULL) AND
887: (NVL(per_cpa_shd.g_old_rec.default_uom,hr_api.g_varchar2) <>
888: NVL(p_default_uom,hr_api.g_varchar2)))) THEN
889: --
890: hr_utility.set_location(l_proc, 20);
891: --
892: -- Check that the default_uom exists in HR_LOOKUPS
893: -- for the UNITS lookup type
894: --

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

896: (p_effective_date => p_effective_date
897: ,p_lookup_type => 'UNITS'
898: ,p_lookup_code => p_default_uom) THEN
899: --
900: hr_utility.set_location(l_proc, 30);
901: --
902: hr_utility.set_message(800, 'HR_289511_DEFAULT_UOM_INVALID');
903: hr_utility.raise_error;
904: --

Line 902: hr_utility.set_message(800, 'HR_289511_DEFAULT_UOM_INVALID');

898: ,p_lookup_code => p_default_uom) THEN
899: --
900: hr_utility.set_location(l_proc, 30);
901: --
902: hr_utility.set_message(800, 'HR_289511_DEFAULT_UOM_INVALID');
903: hr_utility.raise_error;
904: --
905: END IF;
906: --

Line 903: hr_utility.raise_error;

899: --
900: hr_utility.set_location(l_proc, 30);
901: --
902: hr_utility.set_message(800, 'HR_289511_DEFAULT_UOM_INVALID');
903: hr_utility.raise_error;
904: --
905: END IF;
906: --
907: -- Check that the uom_lookup has not also been populated

Line 912: hr_utility.set_message(800, 'HR_289512_DFLT_UOM_UOM_LOOKUP');

908: --
909: IF p_default_uom IS NOT NULL AND
910: p_uom_lookup IS NOT NULL THEN
911: --
912: hr_utility.set_message(800, 'HR_289512_DFLT_UOM_UOM_LOOKUP');
913: hr_utility.raise_error;
914: --
915: END IF;
916: --

Line 913: hr_utility.raise_error;

909: IF p_default_uom IS NOT NULL AND
910: p_uom_lookup IS NOT NULL THEN
911: --
912: hr_utility.set_message(800, 'HR_289512_DFLT_UOM_UOM_LOOKUP');
913: hr_utility.raise_error;
914: --
915: END IF;
916: --
917: END IF;

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

917: END IF;
918: --
919: END IF;
920: --
921: hr_utility.set_location('Leaving :'||l_proc,50);
922: --
923: END chk_default_uom;
924: --
925: -- ---------------------------------------------------------------------------

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

964: WHERE cei.cagr_api_param_id = p_cagr_api_param_id;
965: --
966: BEGIN
967: --
968: hr_utility.set_location('Entering : '||l_proc,10);
969: --
970: OPEN csr_get_entitlement_item;
971: FETCH csr_get_entitlement_item INTO l_dummy;
972: --

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

971: FETCH csr_get_entitlement_item INTO l_dummy;
972: --
973: IF csr_get_entitlement_item%FOUND THEN
974: --
975: hr_utility.set_location(l_proc,20);
976: --
977: CLOSE csr_get_entitlement_item;
978: --
979: hr_utility.set_message(800, 'HR_289208_PARAMETER_IN_USE');

Line 979: hr_utility.set_message(800, 'HR_289208_PARAMETER_IN_USE');

975: hr_utility.set_location(l_proc,20);
976: --
977: CLOSE csr_get_entitlement_item;
978: --
979: hr_utility.set_message(800, 'HR_289208_PARAMETER_IN_USE');
980: hr_utility.raise_error;
981: --
982: ELSE
983: --

Line 980: hr_utility.raise_error;

976: --
977: CLOSE csr_get_entitlement_item;
978: --
979: hr_utility.set_message(800, 'HR_289208_PARAMETER_IN_USE');
980: hr_utility.raise_error;
981: --
982: ELSE
983: --
984: hr_utility.set_location(l_proc,30);

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

980: hr_utility.raise_error;
981: --
982: ELSE
983: --
984: hr_utility.set_location(l_proc,30);
985: --
986: CLOSE csr_get_entitlement_item;
987: --
988: END IF;

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

986: CLOSE csr_get_entitlement_item;
987: --
988: END IF;
989: --
990: hr_utility.set_location('Leaving : '||l_proc,100);
991: --
992: END chk_parameter_use;
993: --
994: --

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

1086: --
1087: l_proc varchar2(72) := g_package||'insert_validate';
1088: --
1089: Begin
1090: hr_utility.set_location('Entering:'||l_proc, 5);
1091: --
1092: -- Call all supporting business operations
1093: --
1094: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."

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

1099: per_cpa_bus.chk_cagr_api_id
1100: (p_cagr_api_id => p_rec.cagr_api_id
1101: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
1102: --
1103: hr_utility.set_location(l_proc, 10);
1104: --
1105: -- Validate Display Name
1106: --
1107: per_cpa_bus.chk_display_name

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

1108: (p_cagr_api_id => p_rec.cagr_api_id
1109: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1110: ,p_display_name => p_rec.display_name);
1111: --
1112: hr_utility.set_location(l_proc, 20);
1113: --
1114: -- Validate Parameter Name
1115: --
1116: per_cpa_bus.chk_parameter_name

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

1117: (p_parameter_name => p_rec.parameter_name
1118: ,p_cagr_api_id => p_rec.cagr_api_id
1119: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
1120: --
1121: hr_utility.set_location(l_proc, 30);
1122: --
1123: -- Validate Column Type
1124: --
1125: hr_utility.set_location(l_proc, 40);

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

1121: hr_utility.set_location(l_proc, 30);
1122: --
1123: -- Validate Column Type
1124: --
1125: hr_utility.set_location(l_proc, 40);
1126: --
1127: -- Validate Column Type
1128: --
1129: per_cpa_bus.chk_column_type

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

1130: (p_column_type => p_rec.column_type
1131: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1132: ,p_effective_date => p_effective_date);
1133: --
1134: hr_utility.set_location(l_proc, 50);
1135: --
1136: -- Validate Column Size
1137: --
1138: per_cpa_bus.chk_column_size

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

1137: --
1138: per_cpa_bus.chk_column_size
1139: (p_column_size => p_rec.column_size);
1140: --
1141: hr_utility.set_location(l_proc,60);
1142: --
1143: -- Validate uom parameter
1144: --
1145: per_cpa_bus.chk_uom_parameter

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

1146: (p_uom_parameter => p_rec.uom_parameter
1147: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1148: ,p_cagr_api_id => p_rec.cagr_api_id);
1149: --
1150: hr_utility.set_location(l_proc,70);
1151: --
1152: -- Validate uom lookup
1153: --
1154: per_cpa_bus.chk_uom_lookup

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

1156: ,p_uom_lookup => p_rec.uom_lookup
1157: ,p_default_uom => p_rec.default_uom
1158: ,p_effective_date => p_effective_date);
1159: --
1160: hr_utility.set_location(l_proc,80);
1161: --
1162: per_cpa_bus.chk_hidden
1163: (p_hidden => p_rec.hidden
1164: ,p_cagr_api_param_id => p_rec.cagr_api_param_id

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

1163: (p_hidden => p_rec.hidden
1164: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1165: ,p_effective_date => p_effective_date);
1166: --
1167: hr_utility.set_location(l_proc,90);
1168: --
1169: per_cpa_bus.chk_default_uom
1170: (p_cagr_api_param_id => p_rec.cagr_api_param_id
1171: ,p_default_uom => p_rec.default_uom

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

1171: ,p_default_uom => p_rec.default_uom
1172: ,p_uom_lookup => p_rec.uom_lookup
1173: ,p_effective_date => p_effective_date);
1174: --
1175: hr_utility.set_location(' Leaving:'||l_proc, 999);
1176: --
1177: End insert_validate;
1178: --
1179: -- ----------------------------------------------------------------------------

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

1186: --
1187: l_proc varchar2(72) := g_package||'update_validate';
1188: --
1189: Begin
1190: hr_utility.set_location('Entering:'||l_proc, 5);
1191: --
1192: -- Call all supporting business operations
1193: --
1194: chk_non_updateable_args

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

1202: (p_cagr_api_id => p_rec.cagr_api_id
1203: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1204: ,p_display_name => p_rec.display_name);
1205: --
1206: hr_utility.set_location(l_proc, 20);
1207: --
1208: -- Validate Parameter Name
1209: --
1210: per_cpa_bus.chk_parameter_name

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

1211: (p_parameter_name => p_rec.parameter_name
1212: ,p_cagr_api_id => p_rec.cagr_api_id
1213: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
1214: --
1215: hr_utility.set_location(l_proc, 30);
1216: --
1217: -- Validate Column Type
1218: --
1219: hr_utility.set_location(l_proc, 40);

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

1215: hr_utility.set_location(l_proc, 30);
1216: --
1217: -- Validate Column Type
1218: --
1219: hr_utility.set_location(l_proc, 40);
1220: --
1221: per_cpa_bus.chk_column_type
1222: (p_column_type => p_rec.column_type
1223: ,p_cagr_api_param_id => p_rec.cagr_api_param_id

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

1224: ,p_effective_date => p_effective_date);
1225: --
1226: -- Validate Column Size
1227: --
1228: hr_utility.set_location(l_proc, 50);
1229: --
1230: per_cpa_bus.chk_column_size
1231: (p_column_size => p_rec.column_size);
1232: --

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

1229: --
1230: per_cpa_bus.chk_column_size
1231: (p_column_size => p_rec.column_size);
1232: --
1233: hr_utility.set_location(l_proc, 60);
1234: --
1235: -- Validate uom parameter
1236: --
1237: per_cpa_bus.chk_uom_parameter

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

1238: (p_uom_parameter => p_rec.uom_parameter
1239: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1240: ,p_cagr_api_id => p_rec.cagr_api_id);
1241: --
1242: hr_utility.set_location(l_proc,70);
1243: --
1244: -- Validate uom lookup
1245: --
1246: per_cpa_bus.chk_uom_lookup

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

1248: ,p_uom_lookup => p_rec.uom_lookup
1249: ,p_default_uom => p_rec.default_uom
1250: ,p_effective_date => p_effective_date);
1251: --
1252: hr_utility.set_location(l_proc,80);
1253: --
1254: per_cpa_bus.chk_hidden
1255: (p_hidden => p_rec.hidden
1256: ,p_cagr_api_param_id => p_rec.cagr_api_param_id

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

1255: (p_hidden => p_rec.hidden
1256: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1257: ,p_effective_date => p_effective_date);
1258: --
1259: hr_utility.set_location(l_proc,90);
1260: --
1261: per_cpa_bus.chk_default_uom
1262: (p_cagr_api_param_id => p_rec.cagr_api_param_id
1263: ,p_default_uom => p_rec.default_uom

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

1263: ,p_default_uom => p_rec.default_uom
1264: ,p_uom_lookup => p_rec.uom_lookup
1265: ,p_effective_date => p_effective_date);
1266: --
1267: hr_utility.set_location(' Leaving:'||l_proc, 999);
1268: --
1269: End update_validate;
1270: --
1271: -- ----------------------------------------------------------------------------

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

1277: --
1278: l_proc varchar2(72) := g_package||'delete_validate';
1279: --
1280: Begin
1281: hr_utility.set_location('Entering:'||l_proc, 5);
1282: --
1283: -- Check the parameter is not being referenced
1284: --
1285: per_cpa_bus.chk_parameter_use

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

1284: --
1285: per_cpa_bus.chk_parameter_use
1286: (p_cagr_api_param_id => p_rec.cagr_api_param_id);
1287: --
1288: hr_utility.set_location(' Leaving:'||l_proc, 10);
1289: End delete_validate;
1290: --
1291: end per_cpa_bus;