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 HR_UTILITY

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 72: hr_utility.set_message(801,'Sql Err Code: '||TO_CHAR(SQLCODE));

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;
76:

Line 73: hr_utility.raise_error;

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;
76:
77:

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 233: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));

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:
237: END chk_entry_in_lookup;

Line 234: hr_utility.trace('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));

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:
237: END chk_entry_in_lookup;
238:

Line 235: hr_utility.raise_error;

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:
237: END chk_entry_in_lookup;
238:
239:

Line 262: hr_utility.set_location ('hruserdt.get_table_value', 1);

258: -- Use either the supplied date, or the date from fnd_sessions
259: --
260: if (p_effective_date is null) then
261: begin
262: hr_utility.set_location ('hruserdt.get_table_value', 1);
263: select effective_date
264: into l_effective_date
265: from fnd_sessions
266: where session_id = userenv('sessionid');

Line 274: hr_utility.set_location ('hruserdt.get_table_value', 3);

270: end if;
271: --
272: -- get the type of query to be performed, either range or match
273: --
274: hr_utility.set_location ('hruserdt.get_table_value', 3);
275: select tab.range_or_match
276: , tab.user_table_id
277: into l_range_or_match
278: , l_table_id

Line 285: hr_utility.set_location ('hruserdt.get_table_value', 4);

281: and tab.legislation_code = g_leg_code;
282: --
283: if (l_range_or_match = 'M') then -- matched
284: begin
285: hr_utility.set_location ('hruserdt.get_table_value', 4);
286: select CINST.value
287: into l_value
288: from pay_user_column_instances_f CINST
289: , pay_user_columns C

Line 330: hr_utility.set_location ('hruserdt.get_table_value', 5);

326:
327: end;
328: else -- range
329: begin
330: hr_utility.set_location ('hruserdt.get_table_value', 5);
331: select CINST.value
332: into l_value
333: from pay_user_column_instances_f CINST
334: , pay_user_columns C

Line 393: hr_utility.set_location ('hruserdt.get_table_value', 1);

389: -- Use either the supplied date, or the date from fnd_sessions
390: --
391: if (p_effective_date is null) then
392: begin
393: hr_utility.set_location ('hruserdt.get_table_value', 1);
394: select effective_date
395: into l_effective_date
396: from fnd_sessions
397: where session_id = userenv('sessionid');

Line 405: hr_utility.set_location ('hruserdt.get_table_value', 3);

401: end if;
402: --
403: -- get the type of query to be performed, either range or match
404: --
405: hr_utility.set_location ('hruserdt.get_table_value', 3);
406: select tab.range_or_match
407: , tab.user_table_id
408: into l_range_or_match
409: , l_table_id

Line 416: hr_utility.set_location ('hruserdt.get_table_value', 4);

412: and tab.legislation_code = g_leg_code;
413: --
414: if (l_range_or_match = 'M') then -- matched
415: begin
416: hr_utility.set_location ('hruserdt.get_table_value', 4);
417: select CINST.value
418: into l_value
419: from pay_user_column_instances_f CINST
420: , pay_user_columns C

Line 461: hr_utility.set_location ('hruserdt.get_table_value', 5);

457:
458: end;
459: else -- range
460: begin
461: hr_utility.set_location ('hruserdt.get_table_value', 5);
462: select CINST.value
463: into l_value
464: from pay_user_column_instances_f CINST
465: , pay_user_columns C

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 569: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));

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:
573: -------------------------------------------------------------------------------

Line 570: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));

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:
573: -------------------------------------------------------------------------------
574: END insert_ipv_link;

Line 571: hr_utility.raise_error;

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:
573: -------------------------------------------------------------------------------
574: END insert_ipv_link;
575:

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 625: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));

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: -------------------------------------------------------------------------------
629: END insert_ee_value;

Line 626: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));

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: -------------------------------------------------------------------------------
629: END insert_ee_value;
630:

Line 627: hr_utility.raise_error;

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: -------------------------------------------------------------------------------
629: END insert_ee_value;
630:
631: -------------------------------------------------------------------------------

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 674: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));

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: -------------------------------------------------------------------------------
678: END elm_link_start_date;

Line 675: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));

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: -------------------------------------------------------------------------------
678: END elm_link_start_date;
679:

Line 676: hr_utility.raise_error;

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: -------------------------------------------------------------------------------
678: END elm_link_start_date;
679:
680: -------------------------------------------------------------------------------

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 723: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));

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: -------------------------------------------------------------------------------
727: END elm_link_end_date;

Line 724: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));

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: -------------------------------------------------------------------------------
727: END elm_link_end_date;
728:

Line 725: hr_utility.raise_error;

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: -------------------------------------------------------------------------------
727: END elm_link_end_date;
728:
729: -------------------------------------------------------------------------------

Line 809: -- hr_utility.trace_on(null,'perlegza_sql');

805: -------------------------------------------------------------------------------
806: BEGIN -- MAIN --
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

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 814: hr_utility.trace('Input Value ID: '||TO_CHAR(v_input_value.input_value_id));

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:
816: l_ipv_link_start_date := greatest( elm_link_start_date(v_input_value.element_link_id)
817: , v_input_value.effective_start_date);
818:

Line 841: hr_utility.trace('Element Entry ID: '||TO_CHAR(v_entry.element_entry_id));

837: FOR v_entry IN c_element_entries (
838: p_element_link_id => v_input_value.element_link_id
839: )
840: LOOP
841: hr_utility.trace('Element Entry ID: '||TO_CHAR(v_entry.element_entry_id));
842: -- Create a NULL entry for every element entry
843: insert_ee_value (
844: p_effective_start_date => v_entry.effective_start_date
845: , p_effective_end_date => v_entry.effective_end_date

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 859: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));

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: ------------------------
863: -- hr_utility.trace_off;

Line 860: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));

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: ------------------------
863: -- hr_utility.trace_off;
864: ------------------------

Line 861: hr_utility.raise_error;

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: ------------------------
863: -- hr_utility.trace_off;
864: ------------------------
865: -------------------------------------------------------------------------------

Line 863: -- hr_utility.trace_off;

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: ------------------------
863: -- hr_utility.trace_off;
864: ------------------------
865: -------------------------------------------------------------------------------
866: END maintain_ipv_links;
867: ----------------------------------------------------------------------------

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 1035: hr_utility.trace('Sql error code: '||TO_CHAR(SQLCODE));

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: ---------------------------------------------------------------------------
1039: END insert_rr_value;

Line 1036: hr_utility.trace('Sql error msg: ' ||SUBSTR(SQLERRM(SQLCODE), 1, 100));

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: ---------------------------------------------------------------------------
1039: END insert_rr_value;
1040: ---------------------------------------------------------------------------

Line 1037: hr_utility.raise_error;

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: ---------------------------------------------------------------------------
1039: END insert_rr_value;
1040: ---------------------------------------------------------------------------
1041: