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_ZA_UTILITY_PKG dependencies on PER_ZA_UTILITY_PKG

Line 1: PACKAGE BODY per_za_utility_pkg AS

1: PACKAGE BODY per_za_utility_pkg AS
2: /* $Header: pezautly.pkb 120.4 2005/08/17 10:47:27 nragavar noship $ */
3: /* Copyright (c) Oracle Corporation 2002. All rights reserved. */
4: /*
5: PRODUCT

Line 66: hr_utility.set_location('per_za_utility_pkg.za_term_cat_update',1);

62: AS
63: -------------------------------------------------------------------------------
64: BEGIN -- MAIN --
65: -------------------------------------------------------------------------------
66: hr_utility.set_location('per_za_utility_pkg.za_term_cat_update',1);
67: hr_utility.set_location('per_za_utility_pkg.za_term_cat_update',2);
68:
69: EXCEPTION
70: WHEN OTHERS THEN

Line 67: hr_utility.set_location('per_za_utility_pkg.za_term_cat_update',2);

63: -------------------------------------------------------------------------------
64: BEGIN -- MAIN --
65: -------------------------------------------------------------------------------
66: hr_utility.set_location('per_za_utility_pkg.za_term_cat_update',1);
67: hr_utility.set_location('per_za_utility_pkg.za_term_cat_update',2);
68:
69: EXCEPTION
70: WHEN OTHERS THEN
71: hr_utility.set_location('per_za_utility_pkg.za_term_cat_update',3);

Line 71: hr_utility.set_location('per_za_utility_pkg.za_term_cat_update',3);

67: hr_utility.set_location('per_za_utility_pkg.za_term_cat_update',2);
68:
69: EXCEPTION
70: WHEN OTHERS THEN
71: hr_utility.set_location('per_za_utility_pkg.za_term_cat_update',3);
72: hr_utility.set_message(801,'Sql Err Code: '||TO_CHAR(SQLCODE));
73: hr_utility.raise_error;
74: -------------------------------------------------------------------------------
75: END za_term_cat_update;

Line 187: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',1);

183: l_msg VARCHAR2(255) := ' ';
184:
185: BEGIN
186: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
187: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',1);
188:
189: -- Check if the value exists in the lookup
190: OPEN c_entry_in_lookup;
191: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',2);

Line 191: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',2);

187: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',1);
188:
189: -- Check if the value exists in the lookup
190: OPEN c_entry_in_lookup;
191: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',2);
192:
193: FETCH c_entry_in_lookup INTO l_found_value_in_lookup;
194: IF c_entry_in_lookup%FOUND THEN
195: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',3);

Line 195: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',3);

191: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',2);
192:
193: FETCH c_entry_in_lookup INTO l_found_value_in_lookup;
194: IF c_entry_in_lookup%FOUND THEN
195: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',3);
196: l_found_value_in_lookup := 'Y';
197: ELSE
198: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',4);
199: l_found_value_in_lookup := 'N';

Line 198: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',4);

194: IF c_entry_in_lookup%FOUND THEN
195: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',3);
196: l_found_value_in_lookup := 'Y';
197: ELSE
198: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',4);
199: l_found_value_in_lookup := 'N';
200: END IF;
201: CLOSE c_entry_in_lookup;
202:

Line 203: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',5);

199: l_found_value_in_lookup := 'N';
200: END IF;
201: CLOSE c_entry_in_lookup;
202:
203: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',5);
204:
205: -- If the value did not exist, create a message with all the
206: -- possible value in the lookup
207: IF l_found_value_in_lookup = 'N' THEN

Line 208: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',6);

204:
205: -- If the value did not exist, create a message with all the
206: -- possible value in the lookup
207: IF l_found_value_in_lookup = 'N' THEN
208: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',6);
209:
210: FOR v_lookup_values IN c_lookup_values LOOP
211: l_msg := l_msg||', '||v_lookup_values.meaning;
212: END LOOP;

Line 214: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',7);

210: FOR v_lookup_values IN c_lookup_values LOOP
211: l_msg := l_msg||', '||v_lookup_values.meaning;
212: END LOOP;
213:
214: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',7);
215:
216: l_msg := substr(l_msg,3,215);
217: l_msg := 'Value must be one of the following: '||l_msg;
218:

Line 221: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',8);

217: l_msg := 'Value must be one of the following: '||l_msg;
218:
219: END IF;
220:
221: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',8);
222:
223: -- Setup Out variables and Return statements
224: p_message := l_msg;
225: RETURN l_found_value_in_lookup;

Line 232: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',9);

228: WHEN OTHERS THEN
229: IF c_entry_in_lookup%ISOPEN THEN
230: CLOSE c_entry_in_lookup;
231: END IF;
232: hr_utility.set_location('per_za_utility_pkg.chk_entry_in_lookup',9);
233: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));
234: hr_utility.trace('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
235: hr_utility.raise_error;
236:

Line 523: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',1);

519:
520: -------------------------------------------------------------------------------
521: BEGIN -- MAIN --
522: -------------------------------------------------------------------------------
523: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',1);
524: -- get link_input_value_id from the sequence
525: SELECT pay_link_input_values_s.nextval
526: INTO l_link_input_pk
527: FROM dual;

Line 528: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',2);

524: -- get link_input_value_id from the sequence
525: SELECT pay_link_input_values_s.nextval
526: INTO l_link_input_pk
527: FROM dual;
528: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',2);
529: INSERT
530: INTO pay_link_input_values_f
531: ( link_input_value_id
532: , effective_start_date

Line 564: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',3);

560: , -1
561: , -1
562: , sysdate
563: );
564: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',3);
565:
566: EXCEPTION
567: WHEN OTHERS THEN
568: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',4);

Line 568: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',4);

564: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',3);
565:
566: EXCEPTION
567: WHEN OTHERS THEN
568: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',4);
569: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));
570: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));
571: hr_utility.raise_error;
572:

Line 595: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',1);

591:
592: -------------------------------------------------------------------------------
593: BEGIN -- MAIN --
594: -------------------------------------------------------------------------------
595: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',1);
596: -- Get the element_entry_value_id from the sequence
597: SELECT pay_element_entry_values_s.nextval
598: INTO l_entry_value_pk
599: FROM dual;

Line 600: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',2);

596: -- Get the element_entry_value_id from the sequence
597: SELECT pay_element_entry_values_s.nextval
598: INTO l_entry_value_pk
599: FROM dual;
600: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',2);
601: -- Insert a new row using the sequence value
602: INSERT
603: INTO pay_element_entry_values_f
604: ( element_entry_value_id

Line 620: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',3);

616: , p_element_entry_id
617: , p_screen_entry_value
618: );
619:
620: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',3);
621:
622: EXCEPTION
623: WHEN OTHERS THEN
624: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',4);

Line 624: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',4);

620: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',3);
621:
622: EXCEPTION
623: WHEN OTHERS THEN
624: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',4);
625: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));
626: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));
627: hr_utility.raise_error;
628: -------------------------------------------------------------------------------

Line 657: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',1);

653:
654: -------------------------------------------------------------------------------
655: BEGIN -- MAIN --
656: -------------------------------------------------------------------------------
657: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',1);
658:
659: OPEN c_start_date(p_element_link_id);
660: FETCH c_start_date INTO l_min_eff_start_date;
661: CLOSE c_start_date;

Line 663: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',2);

659: OPEN c_start_date(p_element_link_id);
660: FETCH c_start_date INTO l_min_eff_start_date;
661: CLOSE c_start_date;
662:
663: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',2);
664: RETURN l_min_eff_start_date;
665:
666: EXCEPTION
667: WHEN OTHERS THEN

Line 668: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',3);

664: RETURN l_min_eff_start_date;
665:
666: EXCEPTION
667: WHEN OTHERS THEN
668: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',3);
669: IF c_start_date%ISOPEN THEN
670: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',4);
671: CLOSE c_start_date;
672: END IF;

Line 670: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',4);

666: EXCEPTION
667: WHEN OTHERS THEN
668: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',3);
669: IF c_start_date%ISOPEN THEN
670: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',4);
671: CLOSE c_start_date;
672: END IF;
673: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',5);
674: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));

Line 673: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',5);

669: IF c_start_date%ISOPEN THEN
670: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',4);
671: CLOSE c_start_date;
672: END IF;
673: hr_utility.set_location('per_za_utility_pkg.elm_link_start_date',5);
674: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));
675: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));
676: hr_utility.raise_error;
677: -------------------------------------------------------------------------------

Line 706: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',1);

702:
703: -------------------------------------------------------------------------------
704: BEGIN -- MAIN --
705: -------------------------------------------------------------------------------
706: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',1);
707:
708: OPEN c_end_date(p_element_link_id);
709: FETCH c_end_date INTO l_max_eff_end_date;
710: CLOSE c_end_date;

Line 712: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',2);

708: OPEN c_end_date(p_element_link_id);
709: FETCH c_end_date INTO l_max_eff_end_date;
710: CLOSE c_end_date;
711:
712: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',2);
713: RETURN l_max_eff_end_date;
714:
715: EXCEPTION
716: WHEN OTHERS THEN

Line 717: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',3);

713: RETURN l_max_eff_end_date;
714:
715: EXCEPTION
716: WHEN OTHERS THEN
717: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',3);
718: IF c_end_date%ISOPEN THEN
719: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',4);
720: CLOSE c_end_date;
721: END IF;

Line 719: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',4);

715: EXCEPTION
716: WHEN OTHERS THEN
717: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',3);
718: IF c_end_date%ISOPEN THEN
719: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',4);
720: CLOSE c_end_date;
721: END IF;
722: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',5);
723: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));

Line 722: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',5);

718: IF c_end_date%ISOPEN THEN
719: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',4);
720: CLOSE c_end_date;
721: END IF;
722: hr_utility.set_location('per_za_utility_pkg.elm_link_end_date',5);
723: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));
724: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));
725: hr_utility.raise_error;
726: -------------------------------------------------------------------------------

Line 811: hr_utility.set_location('per_za_utility_pkg.maintain_ipv_links',1);

807: -------------------------------------------------------------------------------
808: ------------------------------------------
809: -- hr_utility.trace_on(null,'perlegza_sql');
810: ------------------------------------------
811: hr_utility.set_location('per_za_utility_pkg.maintain_ipv_links',1);
812: <>
813: FOR v_input_value IN c_input_values LOOP
814: hr_utility.trace('Input Value ID: '||TO_CHAR(v_input_value.input_value_id));
815:

Line 854: hr_utility.set_location('per_za_utility_pkg.maintain_ipv_links',2);

850:
851: END LOOP non_entered_input_values;
852: END LOOP non_linked_input_values;
853:
854: hr_utility.set_location('per_za_utility_pkg.maintain_ipv_links',2);
855:
856: EXCEPTION
857: WHEN OTHERS THEN
858: hr_utility.set_location('per_za_utility_pkg.maintain_ipv_links',3);

Line 858: hr_utility.set_location('per_za_utility_pkg.maintain_ipv_links',3);

854: hr_utility.set_location('per_za_utility_pkg.maintain_ipv_links',2);
855:
856: EXCEPTION
857: WHEN OTHERS THEN
858: hr_utility.set_location('per_za_utility_pkg.maintain_ipv_links',3);
859: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));
860: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));
861: hr_utility.raise_error;
862: ------------------------

Line 890: hr_utility.set_location('Entering: ' || 'per_za_utility_pkg.get_context_id', 10);

886: l_context_id NUMBER;
887: --
888: BEGIN
889: --
890: hr_utility.set_location('Entering: ' || 'per_za_utility_pkg.get_context_id', 10);
891: --
892: OPEN csr_context(p_context_name);
893: FETCH csr_context INTO l_context_id;
894: CLOSE csr_context;

Line 896: hr_utility.set_location('Leaving: ' || 'per_za_utility_pkg.get_context_id', 20);

892: OPEN csr_context(p_context_name);
893: FETCH csr_context INTO l_context_id;
894: CLOSE csr_context;
895: --
896: hr_utility.set_location('Leaving: ' || 'per_za_utility_pkg.get_context_id', 20);
897: --
898: RETURN l_context_id;
899: --
900: END get_context_id;

Line 940: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',1);

936: cur_run_res_con_rec cur_run_res_con%ROWTYPE;
937: -------------------------------------------------------------------------------
938: BEGIN -- MAIN --
939: -------------------------------------------------------------------------------
940: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',1);
941:
942: l_clar_no_con := get_context_id('SOURCE_NUMBER');
943: l_Dir_no_con := get_context_id('SOURCE_TEXT');
944:

Line 955: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',2);

951: from pay_input_values_f pivf
952: where pivf.INPUT_VALUE_ID = p_input_value_id
953: and rownum = 1;
954:
955: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',2);
956:
957: insert into pay_run_result_values (
958: INPUT_VALUE_ID
959: ,RUN_RESULT_ID

Line 1030: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',3);

1026:
1027: if cur_run_res_con%ISOPEN then
1028: close cur_run_res_con;
1029: end if;
1030: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',3);
1031:
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',4);

Line 1034: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',4);

1030: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',3);
1031:
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',4);
1035: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));
1036: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));
1037: hr_utility.raise_error;
1038: ---------------------------------------------------------------------------

Line 1043: END per_za_utility_pkg;

1039: END insert_rr_value;
1040: ---------------------------------------------------------------------------
1041:
1042:
1043: END per_za_utility_pkg;
1044: ---------------------------------------------------------------------------