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.PYNEGNET01 dependencies on HR_UTILITY

Line 49: 115.4 16-jun-1999 achauhan replaced dbms_output with hr_utility.trace

45: negative ammount.
46: 110.1 14/04/98 M.Lisiecki Removed changes introduced to fix bug 585429 as it proved not
47: to be a bug.
48: 115.1 21/04/99 S.Grant Multi-radix changes.
49: 115.4 16-jun-1999 achauhan replaced dbms_output with hr_utility.trace
50: ================================================================= */
51: --
52: -- ====================== declare tables ============================
53: --

Line 603: hr_utility.set_location('pynegnet01.init_arr_bal_feed_id',1);

599: total_feed NUMBER := 3;
600: ln_id NUMBER := 0;
601: BEGIN
602: --
603: hr_utility.set_location('pynegnet01.init_arr_bal_feed_id',1);
604: --
605: WHILE feed_cnt <= total_feed
606: LOOP
607: lc_name := arr_bal_feed_name_list (feed_cnt);

Line 616: hr_utility.set_location('pynegnet01.init_arr_bal_feed_id',2);

612: arr_bal_feed_id_list (feed_cnt) := ln_id;
613: feed_cnt := feed_cnt + 1;
614: END LOOP;
615: --
616: hr_utility.set_location('pynegnet01.init_arr_bal_feed_id',2);
617: --
618: END init_arr_bal_feed_id;
619: --
620: -- ===================== init_vertex_results =====================

Line 666: hr_utility.set_location('pynegnet01.init_whld_bal_feed_id',1);

662: total_feed NUMBER := v_total_elements;
663: ln_id NUMBER := 0;
664: BEGIN
665: --
666: hr_utility.set_location('pynegnet01.init_whld_bal_feed_id',1);
667: --
668: WHILE feed_cnt <= total_feed
669: LOOP
670: lc_name := whld_bal_feed_name_list (feed_cnt);

Line 679: hr_utility.set_location('pynegnet01.init_whld_bal_feed_id',2);

675: whld_bal_feed_id_list (feed_cnt) := ln_id;
676: feed_cnt := feed_cnt + 1;
677: END LOOP;
678: --
679: hr_utility.set_location('pynegnet01.init_whld_bal_feed_id',2);
680: --
681: END init_whld_bal_feed_id;
682: --
683: -- ===================== init_arr_bal_feed_rule =====================

Line 699: hr_utility.set_location('pynegnet01.init_all_tables',1);

695: PROCEDURE init_all_tables
696: IS
697: BEGIN
698: --
699: hr_utility.set_location('pynegnet01.init_all_tables',1);
700: --
701: init_jd_list;
702: init_arrear_bal_name;
703: init_proto_bal_name;

Line 722: hr_utility.set_location('pynegnet01.init_all_tables',2);

718:
719: init_other_variables;
720: init_vertex_results;
721: --
722: hr_utility.set_location('pynegnet01.init_all_tables',2);
723: --
724: END init_all_tables;
725: -- ====================== check_run_results =======================
726: FUNCTION check_run_results return varchar2

Line 780: hr_utility.set_location('pynegnet01.delete_bal_dim',1);

776: lc_name VARCHAR2(80);
777: ln_id NUMBER := 0;
778: BEGIN
779: --
780: hr_utility.set_location('pynegnet01.delete_bal_dim',1);
781: --
782: total_bal := v_total_balances;
783:
784: WHILE bal_cnt <= total_bal

Line 803: hr_utility.set_location('pynegnet01.delete_bal_dim',2);

799: end if;
800: bal_cnt := bal_cnt + 1;
801: END LOOP;
802: --
803: hr_utility.set_location('pynegnet01.delete_bal_dim',2);
804: --
805: END delete_bal_dim;
806: --
807: -- ====================== delete_bal_feed ===========================

Line 828: hr_utility.set_location('pynegnet01.delete_bal_feed',1);

824: ln_id NUMBER := 0;
825:
826: BEGIN
827: --
828: hr_utility.set_location('pynegnet01.delete_bal_feed',1);
829: --
830: total_bal := v_total_balances;
831: WHILE bal_cnt <= total_bal
832: LOOP

Line 849: hr_utility.set_location('pynegnet01.delete_bal_feed',2);

845: end if;
846: bal_cnt := bal_cnt + 1;
847: END LOOP;
848: --
849: hr_utility.set_location('pynegnet01.delete_bal_feed',2);
850: --
851: END delete_bal_feed;
852: --
853: -- ====================== delete_bal ===========================

Line 864: hr_utility.set_location('pynegnet01.delete_bal',1);

860: lc_name VARCHAR2(80);
861: ln_id NUMBER := 0;
862: BEGIN
863: --
864: hr_utility.set_location('pynegnet01.delete_bal',1);
865: --
866: total_bal := v_total_balances;
867: WHILE bal_cnt <= total_bal
868: LOOP

Line 881: hr_utility.set_location('pynegnet01.delete_bal',2);

877: end if;
878: bal_cnt := bal_cnt + 1;
879: END LOOP;
880: --
881: hr_utility.set_location('pynegnet01.delete_bal',2);
882: --
883: END delete_bal;
884: --
885: -- ====================== create_balances ===========================

Line 907: hr_utility.set_location('pynegnet01.create_balances',1);

903: ln_id NUMBER := 0;
904: lc_cur_dim VARCHAR2(80);
905: BEGIN
906: --
907: hr_utility.set_location('pynegnet01.create_balances',1);
908: --
909: total_bal := v_total_balances;
910: WHILE bal_cnt <= total_bal
911: LOOP

Line 946: hr_utility.set_location('pynegnet01.create_balances',2);

942: and legislation_code = 'US')
943: where balance_type_id = ln_id;
944: --
945: --
946: hr_utility.set_location('pynegnet01.create_balances',2);
947: --
948: --
949: -- build all dimensions from prototype
950: --

Line 962: hr_utility.set_location('pynegnet01.create_balances',3);

958: p_balance_dimension => lc_cur_dim,
959: p_legislation_code => v_legislation_code);
960: END LOOP;
961: --
962: hr_utility.set_location('pynegnet01.create_balances',3);
963: --
964: end if;
965: bal_cnt := bal_cnt + 1;
966:

Line 982: hr_utility.set_location('pynegnet01.delete_ff_el',1);

978: lc_ff_name VARCHAR2(80);
979: ln_formula_id NUMBER :=1;
980: BEGIN
981: --
982: hr_utility.set_location('pynegnet01.delete_ff_el',1);
983: --
984: total_el := v_total_elements;
985: WHILE el_cnt <= total_el
986: LOOP

Line 999: hr_utility.set_location('pynegnet01.delete_ff_el',2);

995: end if;
996: el_cnt := el_cnt + 1;
997: END LOOP;
998: --
999: hr_utility.set_location('pynegnet01.delete_ff_el',2);
1000: --
1001: END delete_ff_el;
1002: --
1003: -- ====================== create_ff_el ===========================

Line 1021: hr_utility.set_location('pynegnet01.create_ff_el',1);

1017: lc_sticky_flag VARCHAR2(1) := ' ';
1018: ln_formula_id NUMBER :=1;
1019: BEGIN
1020: --
1021: hr_utility.set_location('pynegnet01.create_ff_el',1);
1022: --
1023: total_el := v_total_elements;
1024: WHILE el_cnt <= total_el
1025: LOOP

Line 1082: hr_utility.set_location('pynegnet01.create_ff_el',2);

1078: el_cnt := el_cnt + 1;
1079: --
1080: END LOOP;
1081: --
1082: hr_utility.set_location('pynegnet01.create_ff_el',2);
1083: --
1084: END create_ff_el;
1085: --
1086: -- ====================== delete_arr_inp ===========================

Line 1107: hr_utility.set_location('pynegnet01.delete_arr_inp',1);

1103: total_spec BINARY_INTEGER := 3;
1104: ln_spec_id NUMBER := 0;
1105: BEGIN
1106: --
1107: hr_utility.set_location('pynegnet01.delete_arr_inp',1);
1108: --
1109: total_el := v_total_elements;
1110: WHILE el_cnt <= total_el
1111: LOOP

Line 1143: hr_utility.set_location('pynegnet01.delete_arr_inp',2);

1139: end if;
1140: el_cnt := el_cnt + 1;
1141: END LOOP;
1142: --
1143: hr_utility.set_location('pynegnet01.delete_arr_inp',2);
1144: --
1145: END delete_arr_inp;
1146: --
1147: -- ====================== delete_arr_el ===========================

Line 1157: hr_utility.set_location('pynegnet01.delete_arr_el',1);

1153: el_cnt BINARY_INTEGER := 1;
1154: lc_name VARCHAR2(80);
1155: BEGIN
1156: --
1157: hr_utility.set_location('pynegnet01.delete_arr_el',1);
1158: --
1159: total_el := v_total_elements;
1160: WHILE el_cnt <= total_el
1161: LOOP

Line 1191: hr_utility.set_location('pynegnet01.delete_arr_el',2);

1187: end if;
1188: el_cnt := el_cnt + 1;
1189: END LOOP;
1190: --
1191: hr_utility.set_location('pynegnet01.delete_arr_el',2);
1192: --
1193: END delete_arr_el;
1194: --
1195: -- ====================== delete_arr_spec ===========================

Line 1217: hr_utility.set_location('pynegnet01.delete_arr_spec',1);

1213: ln_spec_id NUMBER := 0;
1214: ln_whld_id NUMBER := 0;
1215: BEGIN
1216: --
1217: hr_utility.set_location('pynegnet01.delete_arr_spec',1);
1218: --
1219: total_el := v_total_elements;
1220: WHILE el_cnt <= total_el
1221: LOOP

Line 1249: hr_utility.set_location('pynegnet01.delete_arr_spec',2);

1245: end if;
1246: el_cnt := el_cnt + 1;
1247: END LOOP;
1248: --
1249: hr_utility.set_location('pynegnet01.delete_arr_spec',2);
1250: --
1251: END delete_arr_spec;
1252: --
1253: -- ====================== create_arr_el ===========================

Line 1292: hr_utility.set_location('pynegnet01.create_arr_el',1);

1288: spec_cnt BINARY_INTEGER := 1;
1289: total_spec BINARY_INTEGER := 3;
1290: BEGIN
1291: --
1292: hr_utility.set_location('pynegnet01.create_arr_el',1);
1293: --
1294: SELECT classification_id
1295: INTO ln_prim_class_id
1296: FROM pay_element_classifications

Line 1327: hr_utility.set_location('pynegnet01.create_arr_el',2);

1323: p_effective_start_date => v_effective_start_date,
1324: p_effective_end_date => v_effective_end_date,
1325: p_legislation_code => v_legislation_code);
1326: --
1327: hr_utility.set_location('pynegnet01.create_arr_el',2);
1328: --
1329: inp_cnt := 1;
1330:
1331: /* input values loop */

Line 1355: hr_utility.set_location('pynegnet01.create_arr_el',3);

1351: arr_element_id_list (el_cnt) := ln_id;
1352: end if;
1353: el_cnt := el_cnt + 1;
1354: --
1355: hr_utility.set_location('pynegnet01.create_arr_el',3);
1356: --
1357: END LOOP;
1358: --
1359: hr_utility.set_location('pynegnet01.create_arr_el',4);

Line 1359: hr_utility.set_location('pynegnet01.create_arr_el',4);

1355: hr_utility.set_location('pynegnet01.create_arr_el',3);
1356: --
1357: END LOOP;
1358: --
1359: hr_utility.set_location('pynegnet01.create_arr_el',4);
1360: --
1361: END create_arr_el;
1362: --
1363: -- ====================== create_arr_feed ===========================

Line 1405: hr_utility.set_location('pynegnet01.create_arr_feed',1);

1401: --
1402: --
1403: BEGIN
1404: --
1405: hr_utility.set_location('pynegnet01.create_arr_feed',1);
1406: --
1407: SELECT classification_id
1408: INTO ln_prim_class_id
1409: FROM pay_element_classifications

Line 1449: hr_utility.set_location('pynegnet01.create_arr_feed',2);

1445: p_business_group => lc_business_group,
1446: p_legislation_code => lc_legislation_code,
1447: p_mode => lc_mode);
1448: --
1449: hr_utility.set_location('pynegnet01.create_arr_feed',2);
1450: --
1451: /* withheld balance feed */
1452: ln_inp := (el_cnt-1)*2+1;
1453: lc_option := 'INS_MANUAL_FEED';

Line 1479: hr_utility.set_location('pynegnet01.create_arr_feed',3);

1475: p_business_group => lc_business_group,
1476: p_legislation_code => lc_legislation_code,
1477: p_mode => lc_mode);
1478: --
1479: hr_utility.set_location('pynegnet01.create_arr_feed',3);
1480: --
1481: /* special balances feed Tax Deductions, Net, Payments */
1482: spec_cnt := 1;
1483: total_spec := 3;

Line 1551: hr_utility.set_location('pynegnet01.create_arr_feed',4);

1547:
1548: end if;
1549: el_cnt := el_cnt + 1;
1550: --
1551: hr_utility.set_location('pynegnet01.create_arr_feed',4);
1552: --
1553: -- package above does not support effective_start_date
1554: --
1555: update pay_balance_feeds_f

Line 1563: hr_utility.set_location('pynegnet01.create_arr_feed',5);

1559: ;
1560: --
1561: END LOOP;
1562: --
1563: hr_utility.set_location('pynegnet01.create_arr_feed',5);
1564: --
1565: --
1566:
1567:

Line 1588: hr_utility.set_location('pynegnet01.delete_post_input',1);

1584: lc_name VARCHAR2(80);
1585: ln_id NUMBER := 0;
1586: BEGIN
1587: --
1588: hr_utility.set_location('pynegnet01.delete_post_input',1);
1589: --
1590: total_el := v_total_elements;
1591: WHILE el_cnt <= total_el
1592: LOOP

Line 1611: hr_utility.set_location('pynegnet01.delete_post_input',2);

1607: end if;
1608: el_cnt := el_cnt + 1;
1609: END LOOP;
1610: --
1611: hr_utility.set_location('pynegnet01.delete_post_input',2);
1612: --
1613: END delete_post_inp;
1614: --
1615: -- ====================== delete_post_el ===========================

Line 1635: hr_utility.set_location('pynegnet01.delete_post_el',1);

1631: petf.element_name = p_lc_name and
1632: petf.business_group_id is null;
1633: BEGIN
1634: --
1635: hr_utility.set_location('pynegnet01.delete_post_el',1);
1636: --
1637: total_el := v_total_elements;
1638: WHILE el_cnt <= total_el
1639: LOOP

Line 1654: hr_utility.set_location('pynegnet01.delete_post_el',2);

1650: end if;
1651: el_cnt := el_cnt + 1;
1652: END LOOP;
1653: --
1654: hr_utility.set_location('pynegnet01.delete_post_el',2);
1655: --
1656: el_cnt := 1;
1657: total_el := v_total_elements;
1658: WHILE el_cnt <= total_el

Line 1670: hr_utility.set_location('pynegnet01.delete_post_el',3);

1666: end if;
1667: el_cnt := el_cnt + 1;
1668: END LOOP;
1669: --
1670: hr_utility.set_location('pynegnet01.delete_post_el',3);
1671: --
1672: el_cnt := 1;
1673: total_el := v_total_elements;
1674: WHILE el_cnt <= total_el

Line 1711: hr_utility.set_location('pynegnet01.delete_post_el',4);

1707: end if;
1708: el_cnt := el_cnt + 1;
1709: END LOOP;
1710: --
1711: hr_utility.set_location('pynegnet01.delete_post_el',4);
1712: --
1713: END delete_post_el;
1714: --
1715: -- ====================== create_post_el ===========================

Line 1751: hr_utility.set_location('pynegnet01.create_post_el',1);

1747: total_rule BINARY_INTEGER :=2;
1748: lc_severity_level VARCHAR2(1) := 'W';
1749: BEGIN
1750: --
1751: hr_utility.set_location('pynegnet01.create_post_el',1);
1752: --
1753: total_el := v_total_elements; /* element_name_list.COUNT; */
1754: el_cnt := v_total_elements;
1755: WHILE el_cnt > 0 LOOP

Line 1781: hr_utility.set_location('pynegnet01.create_post_el',2);

1777: p_effective_end_date => v_effective_end_date,
1778: p_legislation_code => v_legislation_code);
1779: inp_cnt := 1;
1780: --
1781: hr_utility.set_location('pynegnet01.create_post_el',2);
1782: --
1783: WHILE inp_cnt <= total_inp
1784: LOOP
1785: lc_inp_name := post_inp_value_list (inp_cnt);

Line 1803: hr_utility.set_location('pynegnet01.create_post_el',3);

1799: post_inp_id_list (v_post_inp_cnt) := ln_inp_id;
1800: inp_cnt := inp_cnt + 1;
1801: END LOOP;
1802: --
1803: hr_utility.set_location('pynegnet01.create_post_el',3);
1804: --
1805: /* insert status processing rule */
1806: ln_formula_id := ff_id_list (el_cnt);
1807: ln_stat_id := pay_formula_results.ins_stat_proc_rule(

Line 1816: hr_utility.set_location('pynegnet01.create_post_el',4);

1812: p_element_type_id => ln_id,
1813: p_formula_id => ln_formula_id,
1814: p_processing_rule => lc_processing_rule);
1815: --
1816: hr_utility.set_location('pynegnet01.create_post_el',4);
1817: --
1818: post_element_id_list (el_cnt) := ln_id;
1819: --
1820: else

Line 1849: hr_utility.set_location('pynegnet01.create_post_el',5);

1845: p_result_rule_type => lc_result_rule_type,
1846: p_element_type_id => ln_element_type_id);
1847: rule_cnt := rule_cnt + 1;
1848: --
1849: hr_utility.set_location('pynegnet01.create_post_el',5);
1850: --
1851: END LOOP;
1852: /* part 2 */
1853: lc_result_name := 'ARR_RET_MSG';

Line 1866: hr_utility.set_location('pynegnet01.create_post_el',6);

1862: p_result_name => lc_result_name,
1863: p_result_rule_type => lc_result_rule_type,
1864: p_severity_level => lc_severity_level);
1865: --
1866: hr_utility.set_location('pynegnet01.create_post_el',6);
1867: --
1868: /* part 3 */
1869: IF el_cnt < v_total_elements THEN
1870: rule_cnt := 1;

Line 1892: hr_utility.set_location('pynegnet01.create_post_el',7);

1888: p_result_rule_type => lc_result_rule_type,
1889: p_element_type_id => ln_element_type_id);
1890: rule_cnt := rule_cnt + 1;
1891: --
1892: hr_utility.set_location('pynegnet01.create_post_el',7);
1893: --
1894: END LOOP;
1895: END IF;
1896: --

Line 1901: hr_utility.set_location('pynegnet01.create_post_el',8);

1897: el_cnt := el_cnt - 1;
1898: --
1899: END LOOP;
1900: --
1901: hr_utility.set_location('pynegnet01.create_post_el',8);
1902: --
1903: END create_post_el;
1904: --
1905: -- ====================== delete_vertex_results ===========================

Line 1925: hr_utility.set_location('pynegnet.delete_vertex_results',1);

1921:
1922:
1923: BEGIN
1924: --
1925: hr_utility.set_location('pynegnet.delete_vertex_results',1);
1926: --
1927: BEGIN
1928: SELECT element_type_id
1929: INTO ln_vertex_id

Line 1948: hr_utility.set_location('pynegnet.delete_vertex_results',2);

1944: -- sd1 AND input_value_id = ln_id;
1945: END LOOP;
1946: END IF;
1947: --
1948: hr_utility.set_location('pynegnet.delete_vertex_results',2);
1949: --
1950: END delete_vertex_results;
1951: --
1952: -- ====================== create_vertex_results ===========================

Line 1968: hr_utility.set_location('pynegnet.create_vertex_results',1);

1964: lc_result_rule_type VARCHAR2(20);
1965: lc_severity_level VARCHAR2(1) := 'W';
1966: BEGIN
1967: --
1968: hr_utility.set_location('pynegnet.create_vertex_results',1);
1969: --
1970: BEGIN
1971: SELECT status_processing_rule_id
1972: INTO ln_stat_id

Line 1999: hr_utility.set_location('pynegnet.create_vertex_results',2);

1995: p_result_rule_type => lc_result_rule_type,
1996: p_element_type_id => ln_element_type_id);
1997: rule_cnt := rule_cnt + 1;
1998: --
1999: hr_utility.set_location('pynegnet.create_vertex_results',2);
2000: --
2001: END LOOP;
2002: END IF;
2003: --

Line 2004: hr_utility.set_location('pynegnet.create_vertex_results',3);

2000: --
2001: END LOOP;
2002: END IF;
2003: --
2004: hr_utility.set_location('pynegnet.create_vertex_results',3);
2005: --
2006: END create_vertex_results;
2007: --
2008: -----------------------cleanup-------------------------------------------

Line 2281: hr_utility.trace('Error. Run results exist, this script has already been applied. Contact your Oracle representative');

2277:
2278: else
2279: -- run results exist so be careful about what gets updated.
2280:
2281: hr_utility.trace('Error. Run results exist, this script has already been applied. Contact your Oracle representative');
2282:
2283: cleanup;
2284:
2285: end if;