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

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: package body pay_jp_itwb_dml_pkg as
2: /* $Header: pyjpiwba.pkb 120.0.12020000.2 2013/01/24 13:52:57 dduvvuri ship $ */
3: --
4: c_package constant varchar2(30) := 'pay_jp_itwb_dml_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;
6: --
7: c_legislation_code varchar2(2) := 'JP';
8: c_org_information_context varchar2(40) := 'JP_ITWB_ITEM_INFO';
9: --

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

16: l_proc varchar2(80) := c_package||'next_action_information_id';
17: begin
18: --
19: if g_debug then
20: hr_utility.set_location(l_proc,0);
21: end if;
22: --
23: select pay_action_information_s.nextval
24: into l_action_information_id

Line 28: hr_utility.set_location(l_proc,1000);

24: into l_action_information_id
25: from dual;
26: --
27: if g_debug then
28: hr_utility.set_location(l_proc,1000);
29: end if;
30: --
31: return l_action_information_id;
32: --

Line 51: hr_utility.set_location(l_proc,0);

47: l_proc varchar2(80) := c_package||'copy_pai';
48: begin
49: --
50: if g_debug then
51: hr_utility.set_location(l_proc,0);
52: end if;
53: --
54: p_action_information_id := pay_jp_itwb_dml_pkg.next_action_information_id;
55: p_object_version_number := 1;

Line 145: hr_utility.set_location(l_proc,1000);

141: --
142: end if;
143: --
144: if g_debug then
145: hr_utility.set_location(l_proc,1000);
146: end if;
147: --
148: end copy_pai;
149: --

Line 167: hr_utility.set_location(l_proc,0);

163: l_proc varchar2(80) := c_package||'copy_pai_type';
164: begin
165: --
166: if g_debug then
167: hr_utility.set_location(l_proc,0);
168: end if;
169: --
170: p_action_information_id := pay_jp_itwb_dml_pkg.next_action_information_id;
171: p_object_version_number := 1;

Line 262: hr_utility.set_location(l_proc,1000);

258: --
259: end if;
260: --
261: if g_debug then
262: hr_utility.set_location(l_proc,1000);
263: end if;
264: --
265: end copy_pai_type;
266: --

Line 286: hr_utility.set_location(l_proc,0);

282: l_proc varchar2(80) := c_package||'copy_pai_item';
283: begin
284: --
285: if g_debug then
286: hr_utility.set_location(l_proc,0);
287: end if;
288: --
289: p_action_information_id := pay_jp_itwb_dml_pkg.next_action_information_id;
290: p_object_version_number := 1;

Line 383: hr_utility.set_location(l_proc,1000);

379: --
380: end if;
381: --
382: if g_debug then
383: hr_utility.set_location(l_proc,1000);
384: end if;
385: --
386: end copy_pai_item;
387: --

Line 421: hr_utility.set_location(l_proc,0);

417: --
418: begin
419: --
420: if g_debug then
421: hr_utility.set_location(l_proc,0);
422: end if;
423: --
424: open csr_pai_item;
425: loop

Line 446: hr_utility.set_location(l_proc,1000);

442: end loop;
443: close csr_pai_item;
444: --
445: if g_debug then
446: hr_utility.set_location(l_proc,1000);
447: end if;
448: --
449: end copy_pai_all_item;
450: --

Line 470: hr_utility.set_location(l_proc,0);

466: l_proc varchar2(80) := c_package||'create_pact';
467: begin
468: --
469: if g_debug then
470: hr_utility.set_location(l_proc,0);
471: end if;
472: --
473: p_object_version_number := 1;
474: --

Line 499: hr_utility.set_location(l_proc,1000);

495: fnd_number.number_to_canonical(p_archive_sequence),
496: fnd_number.number_to_canonical(p_payroll_action_id_o));
497: --
498: if g_debug then
499: hr_utility.set_location(l_proc,1000);
500: end if;
501: --
502: end create_pact;
503: --

Line 529: hr_utility.set_location(l_proc,0);

525: l_proc varchar2(80) := c_package||'create_itax_org';
526: begin
527: --
528: if g_debug then
529: hr_utility.set_location(l_proc,0);
530: end if;
531: --
532: p_object_version_number := 1;
533: --

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

566: p_serial1,
567: p_serial2);
568: --
569: if g_debug then
570: hr_utility.set_location(l_proc,1000);
571: end if;
572: --
573: end create_itax_org;
574: --

Line 600: hr_utility.set_location(l_proc,0);

596: l_proc varchar2(80) := c_package||'create_assact';
597: begin
598: --
599: if g_debug then
600: hr_utility.set_location(l_proc,0);
601: end if;
602: --
603: p_object_version_number := 1;
604: --

Line 641: hr_utility.set_location(l_proc,1000);

637: p_leaving_reason,
638: fnd_number.number_to_canonical(p_arch_assignment_action_id_o));
639: --
640: if g_debug then
641: hr_utility.set_location(l_proc,1000);
642: end if;
643: --
644: end create_assact;
645: --

Line 671: hr_utility.set_location(l_proc,0);

667: --
668: begin
669: --
670: if g_debug then
671: hr_utility.set_location(l_proc,0);
672: end if;
673: --
674: copy_pai(
675: p_assignment_action_id,

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

680: p_action_information_id,
681: p_object_version_number);
682: --
683: if g_debug then
684: hr_utility.set_location(l_proc,10);
685: end if;
686: --
687: if p_action_information_id is null then
688: --

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

686: --
687: if p_action_information_id is null then
688: --
689: if g_debug then
690: hr_utility.set_location(l_proc,20);
691: end if;
692: --
693: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
694: fnd_message.raise_error;

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

695: --
696: else
697: --
698: if g_debug then
699: hr_utility.set_location(l_proc,30);
700: end if;
701: --
702: p_object_version_number := p_object_version_number + 1;
703: --

Line 778: hr_utility.set_location(l_proc,1000);

774: --
775: end if;
776: --
777: if g_debug then
778: hr_utility.set_location(l_proc,1000);
779: end if;
780: --
781: end update_assact;
782: --

Line 801: hr_utility.set_location(l_proc,0);

797: --
798: begin
799: --
800: if g_debug then
801: hr_utility.set_location(l_proc,0);
802: end if;
803: --
804: copy_pai(
805: p_assignment_action_id,

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

810: p_action_information_id,
811: p_object_version_number);
812: --
813: if g_debug then
814: hr_utility.set_location(l_proc,10);
815: end if;
816: --
817: if p_action_information_id is null then
818: --

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

816: --
817: if p_action_information_id is null then
818: --
819: if g_debug then
820: hr_utility.set_location(l_proc,20);
821: end if;
822: --
823: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
824: fnd_message.raise_error;

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

825: --
826: else
827: --
828: if g_debug then
829: hr_utility.set_location(l_proc,30);
830: end if;
831: --
832: p_object_version_number := p_object_version_number + 1;
833: --

Line 849: hr_utility.set_location(l_proc,1000);

845: --
846: end if;
847: --
848: if g_debug then
849: hr_utility.set_location(l_proc,1000);
850: end if;
851: --
852: end add_assact;
853: --

Line 878: hr_utility.set_location(l_proc,0);

874: l_proc varchar2(80) := c_package||'create_emp';
875: begin
876: --
877: if g_debug then
878: hr_utility.set_location(l_proc,0);
879: end if;
880: --
881: p_object_version_number := 1;
882: --

Line 917: hr_utility.set_location(l_proc,1000);

913: p_sex,
914: fnd_date.date_to_canonical(p_birth_date));
915: --
916: if g_debug then
917: hr_utility.set_location(l_proc,1000);
918: end if;
919: --
920: end create_emp;
921: --

Line 948: hr_utility.set_location(l_proc,0);

944: --
945: begin
946: --
947: if g_debug then
948: hr_utility.set_location(l_proc,0);
949: end if;
950: --
951: copy_pai(
952: p_assignment_action_id,

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

957: p_action_information_id,
958: p_object_version_number);
959: --
960: if g_debug then
961: hr_utility.set_location(l_proc,10);
962: end if;
963: --
964: if p_action_information_id is null then
965: --

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

963: --
964: if p_action_information_id is null then
965: --
966: if g_debug then
967: hr_utility.set_location(l_proc,20);
968: end if;
969: --
970: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
971: fnd_message.raise_error;

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

972: --
973: else
974: --
975: if g_debug then
976: hr_utility.set_location(l_proc,30);
977: end if;
978: --
979: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
980: --

Line 1044: hr_utility.set_location(l_proc,1000);

1040: --
1041: end if;
1042: --
1043: if g_debug then
1044: hr_utility.set_location(l_proc,1000);
1045: end if;
1046: --
1047: end update_emp;
1048: --

Line 1075: hr_utility.set_location(l_proc,0);

1071: l_proc varchar2(80) := c_package||'create_emp_add';
1072: begin
1073: --
1074: if g_debug then
1075: hr_utility.set_location(l_proc,0);
1076: end if;
1077: --
1078: p_object_version_number := 1;
1079: --

Line 1118: hr_utility.set_location(l_proc,1000);

1114: p_phone1,
1115: p_phone2);
1116: --
1117: if g_debug then
1118: hr_utility.set_location(l_proc,1000);
1119: end if;
1120: --
1121: end create_emp_add;
1122: --

Line 1151: hr_utility.set_location(l_proc,0);

1147: --
1148: begin
1149: --
1150: if g_debug then
1151: hr_utility.set_location(l_proc,0);
1152: end if;
1153: --
1154: copy_pai(
1155: p_assignment_action_id,

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

1160: p_action_information_id,
1161: p_object_version_number);
1162: --
1163: if g_debug then
1164: hr_utility.set_location(l_proc,10);
1165: end if;
1166: --
1167: if p_action_information_id is null then
1168: --

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

1166: --
1167: if p_action_information_id is null then
1168: --
1169: if g_debug then
1170: hr_utility.set_location(l_proc,20);
1171: end if;
1172: --
1173: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1174: fnd_message.raise_error;

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

1175: --
1176: else
1177: --
1178: if g_debug then
1179: hr_utility.set_location(l_proc,30);
1180: end if;
1181: --
1182: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
1183: --

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

1255: --
1256: end if;
1257: --
1258: if g_debug then
1259: hr_utility.set_location(l_proc,1000);
1260: end if;
1261: --
1262: end update_emp_add;
1263: --

Line 1285: hr_utility.set_location(l_proc,0);

1281: l_proc varchar2(80) := c_package||'create_emp_ass';
1282: begin
1283: --
1284: if g_debug then
1285: hr_utility.set_location(l_proc,0);
1286: end if;
1287: --
1288: p_object_version_number := 1;
1289: --

Line 1318: hr_utility.set_location(l_proc,1000);

1314: p_payroll_name,
1315: p_location_name);
1316: --
1317: if g_debug then
1318: hr_utility.set_location(l_proc,1000);
1319: end if;
1320: --
1321: end create_emp_ass;
1322: --

Line 1346: hr_utility.set_location(l_proc,0);

1342: --
1343: begin
1344: --
1345: if g_debug then
1346: hr_utility.set_location(l_proc,0);
1347: end if;
1348: --
1349: copy_pai(
1350: p_assignment_action_id,

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

1355: p_action_information_id,
1356: p_object_version_number);
1357: --
1358: if g_debug then
1359: hr_utility.set_location(l_proc,10);
1360: end if;
1361: --
1362: if p_action_information_id is null then
1363: --

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

1361: --
1362: if p_action_information_id is null then
1363: --
1364: if g_debug then
1365: hr_utility.set_location(l_proc,20);
1366: end if;
1367: --
1368: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1369: fnd_message.raise_error;

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

1370: --
1371: else
1372: --
1373: if g_debug then
1374: hr_utility.set_location(l_proc,30);
1375: end if;
1376: --
1377: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
1378: --

Line 1424: hr_utility.set_location(l_proc,1000);

1420: --
1421: end if;
1422: --
1423: if g_debug then
1424: hr_utility.set_location(l_proc,1000);
1425: end if;
1426: --
1427: end update_emp_ass;
1428: --

Line 1458: hr_utility.set_location(l_proc,0);

1454: l_proc varchar2(80) := c_package||'create_emp_si';
1455: begin
1456: --
1457: if g_debug then
1458: hr_utility.set_location(l_proc,0);
1459: end if;
1460: --
1461: p_object_version_number := 1;
1462: --

Line 1507: hr_utility.set_location(l_proc,1000);

1503: fnd_date.date_to_canonical(p_nres_start_date),
1504: fnd_date.date_to_canonical(p_projected_res_date));
1505: --
1506: if g_debug then
1507: hr_utility.set_location(l_proc,1000);
1508: end if;
1509: --
1510: end create_emp_si;
1511: --

Line 1543: hr_utility.set_location(l_proc,0);

1539: --
1540: begin
1541: --
1542: if g_debug then
1543: hr_utility.set_location(l_proc,0);
1544: end if;
1545: --
1546: copy_pai(
1547: p_assignment_action_id,

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

1552: p_action_information_id,
1553: p_object_version_number);
1554: --
1555: if g_debug then
1556: hr_utility.set_location(l_proc,10);
1557: end if;
1558: --
1559: if p_action_information_id is null then
1560: --

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

1558: --
1559: if p_action_information_id is null then
1560: --
1561: if g_debug then
1562: hr_utility.set_location(l_proc,20);
1563: end if;
1564: --
1565: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1566: fnd_message.raise_error;

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

1567: --
1568: else
1569: --
1570: if g_debug then
1571: hr_utility.set_location(l_proc,30);
1572: end if;
1573: --
1574: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
1575: --

Line 1669: hr_utility.set_location(l_proc,1000);

1665: --
1666: end if;
1667: --
1668: if g_debug then
1669: hr_utility.set_location(l_proc,1000);
1670: end if;
1671: --
1672: end update_emp_si;
1673: --

Line 1703: hr_utility.set_location(l_proc,0);

1699: l_proc varchar2(80) := c_package||'create_sal_act';
1700: begin
1701: --
1702: if g_debug then
1703: hr_utility.set_location(l_proc,0);
1704: end if;
1705: --
1706: p_object_version_number := 1;
1707: --

Line 1752: hr_utility.set_location(l_proc,1000);

1748: p_col_mth11,
1749: p_col_mth12);
1750: --
1751: if g_debug then
1752: hr_utility.set_location(l_proc,1000);
1753: end if;
1754: --
1755: end create_sal_act;
1756: --

Line 1786: hr_utility.set_location(l_proc,0);

1782: --
1783: begin
1784: --
1785: if g_debug then
1786: hr_utility.set_location(l_proc,0);
1787: end if;
1788: --
1789: copy_pai_type(
1790: p_assignment_action_id,

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

1796: p_action_information_id,
1797: p_object_version_number);
1798: --
1799: if g_debug then
1800: hr_utility.set_location(l_proc,10);
1801: end if;
1802: --
1803: if p_action_information_id is null then
1804: --

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

1802: --
1803: if p_action_information_id is null then
1804: --
1805: if g_debug then
1806: hr_utility.set_location(l_proc,20);
1807: end if;
1808: --
1809: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1810: fnd_message.raise_error;

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

1811: --
1812: else
1813: --
1814: if g_debug then
1815: hr_utility.set_location(l_proc,30);
1816: end if;
1817: --
1818: p_object_version_number := p_object_version_number + 1;
1819: --

Line 1953: hr_utility.set_location(l_proc,1000);

1949: --
1950: end if;
1951: --
1952: if g_debug then
1953: hr_utility.set_location(l_proc,1000);
1954: end if;
1955: --
1956: end update_sal_act;
1957: --

Line 1987: hr_utility.set_location(l_proc,0);

1983: --
1984: begin
1985: --
1986: if g_debug then
1987: hr_utility.set_location(l_proc,0);
1988: end if;
1989: --
1990: copy_pai_type(
1991: p_assignment_action_id,

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

1997: p_action_information_id,
1998: p_object_version_number);
1999: --
2000: if g_debug then
2001: hr_utility.set_location(l_proc,10);
2002: end if;
2003: --
2004: if p_action_information_id is null then
2005: --

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

2003: --
2004: if p_action_information_id is null then
2005: --
2006: if g_debug then
2007: hr_utility.set_location(l_proc,20);
2008: end if;
2009: --
2010: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2011: fnd_message.raise_error;

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

2012: --
2013: else
2014: --
2015: if g_debug then
2016: hr_utility.set_location(l_proc,30);
2017: end if;
2018: --
2019: p_object_version_number := p_object_version_number + 1;
2020: --

Line 2070: hr_utility.set_location(l_proc,1000);

2066: --
2067: end if;
2068: --
2069: if g_debug then
2070: hr_utility.set_location(l_proc,1000);
2071: end if;
2072: --
2073: end add_sal_act;
2074: --

Line 2105: hr_utility.set_location(l_proc,0);

2101: l_proc varchar2(80) := c_package||'create_sal_pay';
2102: begin
2103: --
2104: if g_debug then
2105: hr_utility.set_location(l_proc,0);
2106: end if;
2107: --
2108: p_object_version_number := 1;
2109: --

Line 2156: hr_utility.set_location(l_proc,1000);

2152: fnd_number.number_to_canonical(p_col_mth12),
2153: fnd_number.number_to_canonical(p_col_tot));
2154: --
2155: if g_debug then
2156: hr_utility.set_location(l_proc,1000);
2157: end if;
2158: --
2159: end create_sal_pay;
2160: --

Line 2191: hr_utility.set_location(l_proc,0);

2187: --
2188: begin
2189: --
2190: if g_debug then
2191: hr_utility.set_location(l_proc,0);
2192: end if;
2193: --
2194: copy_pai_type(
2195: p_assignment_action_id,

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

2201: p_action_information_id,
2202: p_object_version_number);
2203: --
2204: if g_debug then
2205: hr_utility.set_location(l_proc,10);
2206: end if;
2207: --
2208: if p_action_information_id is null then
2209: --

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

2207: --
2208: if p_action_information_id is null then
2209: --
2210: if g_debug then
2211: hr_utility.set_location(l_proc,20);
2212: end if;
2213: --
2214: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2215: fnd_message.raise_error;

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

2216: --
2217: else
2218: --
2219: if g_debug then
2220: hr_utility.set_location(l_proc,30);
2221: end if;
2222: --
2223: p_object_version_number := p_object_version_number + 1;
2224: --

Line 2364: hr_utility.set_location(l_proc,1000);

2360: --
2361: end if;
2362: --
2363: if g_debug then
2364: hr_utility.set_location(l_proc,1000);
2365: end if;
2366: --
2367: end update_sal_pay;
2368: --

Line 2399: hr_utility.set_location(l_proc,0);

2395: --
2396: begin
2397: --
2398: if g_debug then
2399: hr_utility.set_location(l_proc,0);
2400: end if;
2401: --
2402: copy_pai_type(
2403: p_assignment_action_id,

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

2409: p_action_information_id,
2410: p_object_version_number);
2411: --
2412: if g_debug then
2413: hr_utility.set_location(l_proc,10);
2414: end if;
2415: --
2416: if p_action_information_id is null then
2417: --

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

2415: --
2416: if p_action_information_id is null then
2417: --
2418: if g_debug then
2419: hr_utility.set_location(l_proc,20);
2420: end if;
2421: --
2422: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2423: fnd_message.raise_error;

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

2424: --
2425: else
2426: --
2427: if g_debug then
2428: hr_utility.set_location(l_proc,30);
2429: end if;
2430: --
2431: p_object_version_number := p_object_version_number + 1;
2432: --

Line 2484: hr_utility.set_location(l_proc,1000);

2480: --
2481: end if;
2482: --
2483: if g_debug then
2484: hr_utility.set_location(l_proc,1000);
2485: end if;
2486: --
2487: end add_sal_pay;
2488: --

Line 2521: hr_utility.set_location(l_proc,0);

2517: l_proc varchar2(80) := c_package||'create_bon_act';
2518: begin
2519: --
2520: if g_debug then
2521: hr_utility.set_location(l_proc,0);
2522: end if;
2523: --
2524: p_object_version_number := 1;
2525: --

Line 2576: hr_utility.set_location(l_proc,1000);

2572: p_col_cnt14,
2573: p_col_cnt15);
2574: --
2575: if g_debug then
2576: hr_utility.set_location(l_proc,1000);
2577: end if;
2578: --
2579: end create_bon_act;
2580: --

Line 2635: hr_utility.set_location(l_proc,0);

2631: --
2632: begin
2633: --
2634: if g_debug then
2635: hr_utility.set_location(l_proc,0);
2636: end if;
2637: --
2638: copy_pai_type(
2639: p_assignment_action_id,

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

2645: p_action_information_id,
2646: p_object_version_number);
2647: --
2648: if g_debug then
2649: hr_utility.set_location(l_proc,10);
2650: end if;
2651: --
2652: if p_action_information_id is null then
2653: --

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

2651: --
2652: if p_action_information_id is null then
2653: --
2654: if g_debug then
2655: hr_utility.set_location(l_proc,20);
2656: end if;
2657: --
2658: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2659: fnd_message.raise_error;

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

2660: --
2661: else
2662: --
2663: if g_debug then
2664: hr_utility.set_location(l_proc,30);
2665: end if;
2666: --
2667: open csr_act_efd;
2668: fetch csr_act_efd into l_csr_act_efd;

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

2668: fetch csr_act_efd into l_csr_act_efd;
2669: close csr_act_efd;
2670: --
2671: if g_debug then
2672: hr_utility.set_location(l_proc,40);
2673: end if;
2674: --
2675: p_object_version_number := p_object_version_number + 1;
2676: --

Line 2840: hr_utility.set_location(l_proc,1000);

2836: --
2837: end if;
2838: --
2839: if g_debug then
2840: hr_utility.set_location(l_proc,1000);
2841: end if;
2842: --
2843: end update_bon_act;
2844: --

Line 2877: hr_utility.set_location(l_proc,0);

2873: --
2874: begin
2875: --
2876: if g_debug then
2877: hr_utility.set_location(l_proc,0);
2878: end if;
2879: --
2880: copy_pai_type(
2881: p_assignment_action_id,

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

2887: p_action_information_id,
2888: p_object_version_number);
2889: --
2890: if g_debug then
2891: hr_utility.set_location(l_proc,10);
2892: end if;
2893: --
2894: if p_action_information_id is null then
2895: --

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

2893: --
2894: if p_action_information_id is null then
2895: --
2896: if g_debug then
2897: hr_utility.set_location(l_proc,20);
2898: end if;
2899: --
2900: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2901: fnd_message.raise_error;

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

2902: --
2903: else
2904: --
2905: if g_debug then
2906: hr_utility.set_location(l_proc,30);
2907: end if;
2908: --
2909: p_object_version_number := p_object_version_number + 1;
2910: --

Line 2969: hr_utility.set_location(l_proc,1000);

2965: --
2966: end if;
2967: --
2968: if g_debug then
2969: hr_utility.set_location(l_proc,1000);
2970: end if;
2971: --
2972: end add_bon_act;
2973: --

Line 3007: hr_utility.set_location(l_proc,0);

3003: l_proc varchar2(80) := c_package||'create_bon_pay';
3004: begin
3005: --
3006: if g_debug then
3007: hr_utility.set_location(l_proc,0);
3008: end if;
3009: --
3010: p_object_version_number := 1;
3011: --

Line 3064: hr_utility.set_location(l_proc,1000);

3060: p_col_cnt15,
3061: p_col_tot);
3062: --
3063: if g_debug then
3064: hr_utility.set_location(l_proc,1000);
3065: end if;
3066: --
3067: end create_bon_pay;
3068: --

Line 3102: hr_utility.set_location(l_proc,0);

3098: l_proc varchar2(80) := c_package||'create_bon_pay';
3099: begin
3100: --
3101: if g_debug then
3102: hr_utility.set_location(l_proc,0);
3103: end if;
3104: --
3105: create_bon_pay(
3106: p_action_information_id => p_action_information_id,

Line 3132: hr_utility.set_location(l_proc,1000);

3128: p_col_tot => fnd_number.number_to_canonical(p_col_tot),
3129: p_object_version_number => p_object_version_number);
3130: --
3131: if g_debug then
3132: hr_utility.set_location(l_proc,1000);
3133: end if;
3134: --
3135: end create_bon_pay;
3136: --

Line 3192: hr_utility.set_location(l_proc,0);

3188: --
3189: begin
3190: --
3191: if g_debug then
3192: hr_utility.set_location(l_proc,0);
3193: end if;
3194: --
3195: copy_pai_type(
3196: p_assignment_action_id,

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

3202: p_action_information_id,
3203: p_object_version_number);
3204: --
3205: if g_debug then
3206: hr_utility.set_location(l_proc,10);
3207: end if;
3208: --
3209: if p_action_information_id is null then
3210: --

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

3208: --
3209: if p_action_information_id is null then
3210: --
3211: if g_debug then
3212: hr_utility.set_location(l_proc,20);
3213: end if;
3214: --
3215: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
3216: fnd_message.raise_error;

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

3217: --
3218: else
3219: --
3220: if g_debug then
3221: hr_utility.set_location(l_proc,30);
3222: end if;
3223: --
3224: open csr_act_efd;
3225: fetch csr_act_efd into l_csr_act_efd;

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

3225: fetch csr_act_efd into l_csr_act_efd;
3226: close csr_act_efd;
3227: --
3228: if g_debug then
3229: hr_utility.set_location(l_proc,40);
3230: end if;
3231: --
3232: p_object_version_number := p_object_version_number + 1;
3233: --

Line 3403: hr_utility.set_location(l_proc,1000);

3399: --
3400: end if;
3401: --
3402: if g_debug then
3403: hr_utility.set_location(l_proc,1000);
3404: end if;
3405: --
3406: end update_bon_pay;
3407: --

Line 3441: hr_utility.set_location(l_proc,0);

3437: --
3438: begin
3439: --
3440: if g_debug then
3441: hr_utility.set_location(l_proc,0);
3442: end if;
3443: --
3444: update_bon_pay(
3445: p_assignment_action_id => p_assignment_action_id,

Line 3469: hr_utility.set_location(l_proc,1000);

3465: p_action_information_id => p_action_information_id,
3466: p_object_version_number => p_object_version_number);
3467: --
3468: if g_debug then
3469: hr_utility.set_location(l_proc,1000);
3470: end if;
3471: --
3472: end update_bon_pay;
3473: --

Line 3507: hr_utility.set_location(l_proc,0);

3503: --
3504: begin
3505: --
3506: if g_debug then
3507: hr_utility.set_location(l_proc,0);
3508: end if;
3509: --
3510: copy_pai_type(
3511: p_assignment_action_id,

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

3517: p_action_information_id,
3518: p_object_version_number);
3519: --
3520: if g_debug then
3521: hr_utility.set_location(l_proc,10);
3522: end if;
3523: --
3524: if p_action_information_id is null then
3525: --

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

3523: --
3524: if p_action_information_id is null then
3525: --
3526: if g_debug then
3527: hr_utility.set_location(l_proc,20);
3528: end if;
3529: --
3530: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
3531: fnd_message.raise_error;

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

3532: --
3533: else
3534: --
3535: if g_debug then
3536: hr_utility.set_location(l_proc,30);
3537: end if;
3538: --
3539: p_object_version_number := p_object_version_number + 1;
3540: --

Line 3601: hr_utility.set_location(l_proc,1000);

3597: --
3598: end if;
3599: --
3600: if g_debug then
3601: hr_utility.set_location(l_proc,1000);
3602: end if;
3603: --
3604: end add_bon_pay;
3605: --

Line 3639: hr_utility.set_location(l_proc,0);

3635: --
3636: begin
3637: --
3638: if g_debug then
3639: hr_utility.set_location(l_proc,0);
3640: end if;
3641: --
3642: add_bon_pay(
3643: p_assignment_action_id => p_assignment_action_id,

Line 3667: hr_utility.set_location(l_proc,1000);

3663: p_action_information_id => p_action_information_id,
3664: p_object_version_number => p_object_version_number);
3665: --
3666: if g_debug then
3667: hr_utility.set_location(l_proc,1000);
3668: end if;
3669: --
3670: end add_bon_pay;
3671: --

Line 3707: hr_utility.set_location(l_proc,0);

3703: l_proc varchar2(80) := c_package||'create_sal_earn';
3704: begin
3705: --
3706: if g_debug then
3707: hr_utility.set_location(l_proc,0);
3708: end if;
3709: --
3710: p_object_version_number := 1;
3711: --

Line 3768: hr_utility.set_location(l_proc,1000);

3764: fnd_number.number_to_canonical(p_col_mth12),
3765: fnd_number.number_to_canonical(p_col_tot));
3766: --
3767: if g_debug then
3768: hr_utility.set_location(l_proc,1000);
3769: end if;
3770: --
3771: end create_sal_earn;
3772: --

Line 3819: hr_utility.set_location(l_proc,0);

3815: --
3816: begin
3817: --
3818: if g_debug then
3819: hr_utility.set_location(l_proc,0);
3820: end if;
3821: --
3822: -- pai have been already bulk copied for all items.
3823: open csr_sal_earn;

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

3824: fetch csr_sal_earn into p_action_information_id, p_object_version_number;
3825: close csr_sal_earn;
3826: --
3827: if g_debug then
3828: hr_utility.set_location(l_proc,10);
3829: end if;
3830: --
3831: if p_action_information_id is not null then
3832: --

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

3830: --
3831: if p_action_information_id is not null then
3832: --
3833: if g_debug then
3834: hr_utility.set_location(l_proc,20);
3835: end if;
3836: --
3837: p_object_version_number := p_object_version_number + 1;
3838: --

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

3989: -- case when new item is added
3990: else
3991: --
3992: if g_debug then
3993: hr_utility.set_location(l_proc,30);
3994: end if;
3995: --
3996: create_sal_earn(
3997: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,

Line 4027: hr_utility.set_location(l_proc,1000);

4023: --
4024: end if;
4025: --
4026: if g_debug then
4027: hr_utility.set_location(l_proc,1000);
4028: end if;
4029: --
4030: end update_sal_earn;
4031: --

Line 4077: hr_utility.set_location(l_proc,0);

4073: --
4074: begin
4075: --
4076: if g_debug then
4077: hr_utility.set_location(l_proc,0);
4078: end if;
4079: --
4080: open csr_sal_earn;
4081: fetch csr_sal_earn into p_action_information_id, p_object_version_number;

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

4081: fetch csr_sal_earn into p_action_information_id, p_object_version_number;
4082: close csr_sal_earn;
4083: --
4084: if g_debug then
4085: hr_utility.set_location(l_proc,10);
4086: end if;
4087: --
4088: if p_action_information_id is not null then
4089: --

Line 4175: hr_utility.set_location(l_proc,1000);

4171: p_object_version_number => p_object_version_number);
4172: --
4173: end if;
4174: if g_debug then
4175: hr_utility.set_location(l_proc,1000);
4176: end if;
4177: --
4178: end add_sal_earn;
4179: --

Line 4215: hr_utility.set_location(l_proc,0);

4211: l_proc varchar2(80) := c_package||'create_sal_dct';
4212: begin
4213: --
4214: if g_debug then
4215: hr_utility.set_location(l_proc,0);
4216: end if;
4217: --
4218: p_object_version_number := 1;
4219: --

Line 4276: hr_utility.set_location(l_proc,1000);

4272: fnd_number.number_to_canonical(p_col_mth12),
4273: fnd_number.number_to_canonical(p_col_tot));
4274: --
4275: if g_debug then
4276: hr_utility.set_location(l_proc,1000);
4277: end if;
4278: --
4279: end create_sal_dct;
4280: --

Line 4327: hr_utility.set_location(l_proc,0);

4323: --
4324: begin
4325: --
4326: if g_debug then
4327: hr_utility.set_location(l_proc,0);
4328: end if;
4329: --
4330: -- pai have been already bulk copied for all items.
4331: open csr_sal_dct;

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

4332: fetch csr_sal_dct into p_action_information_id, p_object_version_number;
4333: close csr_sal_dct;
4334: --
4335: if g_debug then
4336: hr_utility.set_location(l_proc,10);
4337: end if;
4338: --
4339: if p_action_information_id is not null then
4340: --

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

4338: --
4339: if p_action_information_id is not null then
4340: --
4341: if g_debug then
4342: hr_utility.set_location(l_proc,20);
4343: end if;
4344: --
4345: p_object_version_number := p_object_version_number + 1;
4346: --

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

4497: -- case when new item is added
4498: else
4499: --
4500: if g_debug then
4501: hr_utility.set_location(l_proc,30);
4502: end if;
4503: --
4504: create_sal_dct(
4505: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,

Line 4535: hr_utility.set_location(l_proc,1000);

4531: --
4532: end if;
4533: --
4534: if g_debug then
4535: hr_utility.set_location(l_proc,1000);
4536: end if;
4537: --
4538: end update_sal_dct;
4539: --

Line 4585: hr_utility.set_location(l_proc,0);

4581: --
4582: begin
4583: --
4584: if g_debug then
4585: hr_utility.set_location(l_proc,0);
4586: end if;
4587: --
4588: open csr_sal_dct;
4589: fetch csr_sal_dct into p_action_information_id, p_object_version_number;

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

4589: fetch csr_sal_dct into p_action_information_id, p_object_version_number;
4590: close csr_sal_dct;
4591: --
4592: if g_debug then
4593: hr_utility.set_location(l_proc,10);
4594: end if;
4595: --
4596: if p_action_information_id is not null then
4597: --

Line 4683: hr_utility.set_location(l_proc,1000);

4679: p_object_version_number => p_object_version_number);
4680: --
4681: end if;
4682: if g_debug then
4683: hr_utility.set_location(l_proc,1000);
4684: end if;
4685: --
4686: end add_sal_dct;
4687: --

Line 4726: hr_utility.set_location(l_proc,0);

4722: l_proc varchar2(80) := c_package||'create_bon_earn';
4723: begin
4724: --
4725: if g_debug then
4726: hr_utility.set_location(l_proc,0);
4727: end if;
4728: --
4729: p_object_version_number := 1;
4730: --

Line 4793: hr_utility.set_location(l_proc,1000);

4789: fnd_number.number_to_canonical(p_col_cnt15),
4790: fnd_number.number_to_canonical(p_col_tot));
4791: --
4792: if g_debug then
4793: hr_utility.set_location(l_proc,1000);
4794: end if;
4795: --
4796: end create_bon_earn;
4797: --

Line 4869: hr_utility.set_location(l_proc,0);

4865: --
4866: begin
4867: --
4868: if g_debug then
4869: hr_utility.set_location(l_proc,0);
4870: end if;
4871: --
4872: -- pai have been already bulk copied for all items.
4873: open csr_bon_earn;

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

4874: fetch csr_bon_earn into p_action_information_id, p_object_version_number;
4875: close csr_bon_earn;
4876: --
4877: if g_debug then
4878: hr_utility.set_location(l_proc,10);
4879: end if;
4880: --
4881: if p_action_information_id is not null then
4882: --

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

4884: fetch csr_act_efd into l_csr_act_efd;
4885: close csr_act_efd;
4886: --
4887: if g_debug then
4888: hr_utility.set_location(l_proc,20);
4889: end if;
4890: --
4891: p_object_version_number := p_object_version_number + 1;
4892: --

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

5073: -- case when new item is added
5074: else
5075: --
5076: if g_debug then
5077: hr_utility.set_location(l_proc,30);
5078: end if;
5079: --
5080: create_bon_earn(
5081: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,

Line 5114: hr_utility.set_location(l_proc,1000);

5110: --
5111: end if;
5112: --
5113: if g_debug then
5114: hr_utility.set_location(l_proc,1000);
5115: end if;
5116: --
5117: end update_bon_earn;
5118: --

Line 5167: hr_utility.set_location(l_proc,0);

5163: --
5164: begin
5165: --
5166: if g_debug then
5167: hr_utility.set_location(l_proc,0);
5168: end if;
5169: --
5170: open csr_bon_earn;
5171: fetch csr_bon_earn into p_action_information_id, p_object_version_number;

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

5171: fetch csr_bon_earn into p_action_information_id, p_object_version_number;
5172: close csr_bon_earn;
5173: --
5174: if g_debug then
5175: hr_utility.set_location(l_proc,10);
5176: end if;
5177: --
5178: if p_action_information_id is not null then
5179: --

Line 5277: hr_utility.set_location(l_proc,1000);

5273: p_object_version_number => p_object_version_number);
5274: --
5275: end if;
5276: if g_debug then
5277: hr_utility.set_location(l_proc,1000);
5278: end if;
5279: --
5280: end add_bon_earn;
5281: --

Line 5320: hr_utility.set_location(l_proc,0);

5316: l_proc varchar2(80) := c_package||'create_bon_dct';
5317: begin
5318: --
5319: if g_debug then
5320: hr_utility.set_location(l_proc,0);
5321: end if;
5322: --
5323: p_object_version_number := 1;
5324: --

Line 5387: hr_utility.set_location(l_proc,1000);

5383: fnd_number.number_to_canonical(p_col_cnt15),
5384: fnd_number.number_to_canonical(p_col_tot));
5385: --
5386: if g_debug then
5387: hr_utility.set_location(l_proc,1000);
5388: end if;
5389: --
5390: end create_bon_dct;
5391: --

Line 5463: hr_utility.set_location(l_proc,0);

5459: --
5460: begin
5461: --
5462: if g_debug then
5463: hr_utility.set_location(l_proc,0);
5464: end if;
5465: --
5466: -- pai have been already bulk copied for all items.
5467: open csr_bon_dct;

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

5468: fetch csr_bon_dct into p_action_information_id, p_object_version_number;
5469: close csr_bon_dct;
5470: --
5471: if g_debug then
5472: hr_utility.set_location(l_proc,10);
5473: end if;
5474: --
5475: if p_action_information_id is not null then
5476: --

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

5478: fetch csr_act_efd into l_csr_act_efd;
5479: close csr_act_efd;
5480: --
5481: if g_debug then
5482: hr_utility.set_location(l_proc,20);
5483: end if;
5484: --
5485: p_object_version_number := p_object_version_number + 1;
5486: --

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

5667: -- case when new item is added
5668: else
5669: --
5670: if g_debug then
5671: hr_utility.set_location(l_proc,30);
5672: end if;
5673: --
5674: create_bon_dct(
5675: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,

Line 5708: hr_utility.set_location(l_proc,1000);

5704: --
5705: end if;
5706: --
5707: if g_debug then
5708: hr_utility.set_location(l_proc,1000);
5709: end if;
5710: --
5711: end update_bon_dct;
5712: --

Line 5761: hr_utility.set_location(l_proc,0);

5757: --
5758: begin
5759: --
5760: if g_debug then
5761: hr_utility.set_location(l_proc,0);
5762: end if;
5763: --
5764: open csr_bon_dct;
5765: fetch csr_bon_dct into p_action_information_id, p_object_version_number;

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

5765: fetch csr_bon_dct into p_action_information_id, p_object_version_number;
5766: close csr_bon_dct;
5767: --
5768: if g_debug then
5769: hr_utility.set_location(l_proc,10);
5770: end if;
5771: --
5772: if p_action_information_id is not null then
5773: --

Line 5871: hr_utility.set_location(l_proc,1000);

5867: p_object_version_number => p_object_version_number);
5868: --
5869: end if;
5870: if g_debug then
5871: hr_utility.set_location(l_proc,1000);
5872: end if;
5873: --
5874: end add_bon_dct;
5875: --

Line 5911: hr_utility.set_location(l_proc,0);

5907: l_proc varchar2(80) := c_package||'create_wrk';
5908: begin
5909: --
5910: if g_debug then
5911: hr_utility.set_location(l_proc,0);
5912: end if;
5913: --
5914: p_object_version_number := 1;
5915: --

Line 5972: hr_utility.set_location(l_proc,1000);

5968: fnd_number.number_to_canonical(p_col_mth12),
5969: fnd_number.number_to_canonical(p_col_tot));
5970: --
5971: if g_debug then
5972: hr_utility.set_location(l_proc,1000);
5973: end if;
5974: --
5975: end create_wrk;
5976: --

Line 6023: hr_utility.set_location(l_proc,0);

6019: --
6020: begin
6021: --
6022: if g_debug then
6023: hr_utility.set_location(l_proc,0);
6024: end if;
6025: --
6026: open csr_wrk;
6027: fetch csr_wrk into p_action_information_id, p_object_version_number;

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

6027: fetch csr_wrk into p_action_information_id, p_object_version_number;
6028: close csr_wrk;
6029: --
6030: if g_debug then
6031: hr_utility.set_location(l_proc,10);
6032: end if;
6033: --
6034: if p_action_information_id is not null then
6035: --

Line 6186: hr_utility.set_location(l_proc,1000);

6182: --
6183: end if;
6184: --
6185: if g_debug then
6186: hr_utility.set_location(l_proc,1000);
6187: end if;
6188: --
6189: end update_wrk;
6190: --

Line 6236: hr_utility.set_location(l_proc,0);

6232: --
6233: begin
6234: --
6235: if g_debug then
6236: hr_utility.set_location(l_proc,0);
6237: end if;
6238: --
6239: open csr_wrk;
6240: fetch csr_wrk into p_action_information_id, p_object_version_number;

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

6240: fetch csr_wrk into p_action_information_id, p_object_version_number;
6241: close csr_wrk;
6242: --
6243: if g_debug then
6244: hr_utility.set_location(l_proc,10);
6245: end if;
6246: --
6247: if p_action_information_id is not null then
6248: --

Line 6334: hr_utility.set_location(l_proc,1000);

6330: p_object_version_number => p_object_version_number);
6331: --
6332: end if;
6333: if g_debug then
6334: hr_utility.set_location(l_proc,1000);
6335: end if;
6336: --
6337: end add_wrk;
6338: --

Line 6364: hr_utility.set_location(l_proc,0);

6360: l_proc varchar2(80) := c_package||'create_pjob';
6361: begin
6362: --
6363: if g_debug then
6364: hr_utility.set_location(l_proc,0);
6365: end if;
6366: --
6367: p_object_version_number := 1;
6368: --

Line 6405: hr_utility.set_location(l_proc,1000);

6401: fnd_number.number_to_canonical(p_mutual_aid_prem),
6402: fnd_number.number_to_canonical(p_itax));
6403: --
6404: if g_debug then
6405: hr_utility.set_location(l_proc,1000);
6406: end if;
6407: --
6408: end create_pjob;
6409: --

Line 6438: hr_utility.set_location(l_proc,0);

6434: --
6435: begin
6436: --
6437: if g_debug then
6438: hr_utility.set_location(l_proc,0);
6439: end if;
6440: --
6441: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
6442: --

Line 6466: hr_utility.set_location(l_proc,1000);

6462: --
6463: end if;
6464: --
6465: if g_debug then
6466: hr_utility.set_location(l_proc,1000);
6467: end if;
6468: --
6469: end update_pjob;
6470: --

Line 6504: hr_utility.set_location(l_proc,0);

6500: --
6501: begin
6502: --
6503: if g_debug then
6504: hr_utility.set_location(l_proc,0);
6505: end if;
6506: --
6507: open csr_pjob;
6508: loop

Line 6535: hr_utility.set_location(l_proc,1000);

6531: end loop;
6532: close csr_pjob;
6533: --
6534: if g_debug then
6535: hr_utility.set_location(l_proc,1000);
6536: end if;
6537: --
6538: end copy_pjob;
6539: --

Line 6574: hr_utility.set_location(l_proc,0);

6570: l_proc varchar2(80) := c_package||'create_dep';
6571: begin
6572: --
6573: if g_debug then
6574: hr_utility.set_location(l_proc,0);
6575: end if;
6576: --
6577: p_object_version_number := 1;
6578: --

Line 6633: hr_utility.set_location(l_proc,1000);

6629: fnd_number.number_to_canonical(p_otsu_spouse_dep_num),
6630: p_non_res_flag);
6631: --
6632: if g_debug then
6633: hr_utility.set_location(l_proc,1000);
6634: end if;
6635: --
6636: end create_dep;
6637: --

Line 6673: hr_utility.set_location(l_proc,0);

6669: --
6670: begin
6671: --
6672: if g_debug then
6673: hr_utility.set_location(l_proc,0);
6674: end if;
6675: --
6676: copy_pai(
6677: p_assignment_action_id,

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

6682: p_action_information_id,
6683: p_object_version_number);
6684: --
6685: if g_debug then
6686: hr_utility.set_location(l_proc,10);
6687: end if;
6688: --
6689: if p_action_information_id is null then
6690: --

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

6688: --
6689: if p_action_information_id is null then
6690: --
6691: if g_debug then
6692: hr_utility.set_location(l_proc,20);
6693: end if;
6694: --
6695: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
6696: fnd_message.raise_error;

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

6697: --
6698: else
6699: --
6700: if g_debug then
6701: hr_utility.set_location(l_proc,30);
6702: end if;
6703: --
6704: p_object_version_number := p_object_version_number + 1;
6705: --

Line 6825: hr_utility.set_location(l_proc,1000);

6821: --
6822: end if;
6823: --
6824: if g_debug then
6825: hr_utility.set_location(l_proc,1000);
6826: end if;
6827: --
6828: end update_dep;
6829: --

Line 6852: hr_utility.set_location(l_proc,0);

6848: l_proc varchar2(80) := c_package||'create_yea_act';
6849: begin
6850: --
6851: if g_debug then
6852: hr_utility.set_location(l_proc,0);
6853: end if;
6854: --
6855: p_object_version_number := 1;
6856: --

Line 6887: hr_utility.set_location(l_proc,1000);

6883: p_yea_type,
6884: p_yea_flag);
6885: --
6886: if g_debug then
6887: hr_utility.set_location(l_proc,1000);
6888: end if;
6889: --
6890: end create_yea_act;
6891: --

Line 6916: hr_utility.set_location(l_proc,0);

6912: --
6913: begin
6914: --
6915: if g_debug then
6916: hr_utility.set_location(l_proc,0);
6917: end if;
6918: --
6919: copy_pai(
6920: p_assignment_action_id,

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

6925: p_action_information_id,
6926: p_object_version_number);
6927: --
6928: if g_debug then
6929: hr_utility.set_location(l_proc,10);
6930: end if;
6931: --
6932: if p_action_information_id is null
6933: or p_object_version_number is null then

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

6932: if p_action_information_id is null
6933: or p_object_version_number is null then
6934: --
6935: if g_debug then
6936: hr_utility.set_location(l_proc,20);
6937: end if;
6938: --
6939: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
6940: fnd_message.raise_error;

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

6941: --
6942: else
6943: --
6944: if g_debug then
6945: hr_utility.set_location(l_proc,30);
6946: end if;
6947: --
6948: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
6949: --

Line 7001: hr_utility.set_location(l_proc,1000);

6997: --
6998: end if;
6999: --
7000: if g_debug then
7001: hr_utility.set_location(l_proc,1000);
7002: end if;
7003: --
7004: end update_yea_act;
7005: --

Line 7028: hr_utility.set_location(l_proc,0);

7024: --
7025: begin
7026: --
7027: if g_debug then
7028: hr_utility.set_location(l_proc,0);
7029: end if;
7030: --
7031: copy_pai(
7032: p_assignment_action_id,

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

7037: p_action_information_id,
7038: p_object_version_number);
7039: --
7040: if g_debug then
7041: hr_utility.set_location(l_proc,10);
7042: end if;
7043: --
7044: if p_action_information_id is null
7045: or p_object_version_number is null then

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

7044: if p_action_information_id is null
7045: or p_object_version_number is null then
7046: --
7047: if g_debug then
7048: hr_utility.set_location(l_proc,20);
7049: end if;
7050: --
7051: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7052: fnd_message.raise_error;

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

7053: --
7054: else
7055: --
7056: if g_debug then
7057: hr_utility.set_location(l_proc,30);
7058: end if;
7059: --
7060: p_object_version_number := p_object_version_number + 1;
7061: --

Line 7092: hr_utility.set_location(l_proc,1000);

7088: --
7089: end if;
7090: --
7091: if g_debug then
7092: hr_utility.set_location(l_proc,1000);
7093: end if;
7094: --
7095: end add_yea_act;
7096: --

Line 7129: hr_utility.set_location(l_proc,0);

7125: l_proc varchar2(80) := c_package||'create_yea_pay';
7126: begin
7127: --
7128: if g_debug then
7129: hr_utility.set_location(l_proc,0);
7130: end if;
7131: --
7132: p_object_version_number := 1;
7133: --

Line 7184: hr_utility.set_location(l_proc,1000);

7180: fnd_number.number_to_canonical(p_bon_itx_tot),
7181: fnd_number.number_to_canonical(p_withhold_itx));
7182: --
7183: if g_debug then
7184: hr_utility.set_location(l_proc,1000);
7185: end if;
7186: --
7187: end create_yea_pay;
7188: --

Line 7223: hr_utility.set_location(l_proc,0);

7219: --
7220: begin
7221: --
7222: if g_debug then
7223: hr_utility.set_location(l_proc,0);
7224: end if;
7225: --
7226: copy_pai(
7227: p_assignment_action_id,

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

7232: p_action_information_id,
7233: p_object_version_number);
7234: --
7235: if g_debug then
7236: hr_utility.set_location(l_proc,10);
7237: end if;
7238: --
7239: if p_action_information_id is null
7240: or p_object_version_number is null then

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

7239: if p_action_information_id is null
7240: or p_object_version_number is null then
7241: --
7242: if g_debug then
7243: hr_utility.set_location(l_proc,20);
7244: end if;
7245: --
7246: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7247: fnd_message.raise_error;

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

7248: --
7249: else
7250: --
7251: if g_debug then
7252: hr_utility.set_location(l_proc,30);
7253: end if;
7254: --
7255: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
7256: --

Line 7368: hr_utility.set_location(l_proc,1000);

7364: --
7365: end if;
7366: --
7367: if g_debug then
7368: hr_utility.set_location(l_proc,1000);
7369: end if;
7370: --
7371: end update_yea_pay;
7372: --

Line 7405: hr_utility.set_location(l_proc,0);

7401: --
7402: begin
7403: --
7404: if g_debug then
7405: hr_utility.set_location(l_proc,0);
7406: end if;
7407: --
7408: copy_pai(
7409: p_assignment_action_id,

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

7414: p_action_information_id,
7415: p_object_version_number);
7416: --
7417: if g_debug then
7418: hr_utility.set_location(l_proc,10);
7419: end if;
7420: --
7421: if p_action_information_id is null
7422: or p_object_version_number is null then

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

7421: if p_action_information_id is null
7422: or p_object_version_number is null then
7423: --
7424: if g_debug then
7425: hr_utility.set_location(l_proc,20);
7426: end if;
7427: --
7428: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7429: fnd_message.raise_error;

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

7430: --
7431: else
7432: --
7433: if g_debug then
7434: hr_utility.set_location(l_proc,30);
7435: end if;
7436: --
7437: p_object_version_number := p_object_version_number + 1;
7438: --

Line 7499: hr_utility.set_location(l_proc,1000);

7495: --
7496: end if;
7497: --
7498: if g_debug then
7499: hr_utility.set_location(l_proc,1000);
7500: end if;
7501: --
7502: end add_yea_pay;
7503: --

Line 7548: hr_utility.set_location(l_proc,0);

7544: l_proc varchar2(80) := c_package||'create_yea_dct';
7545: begin
7546: --
7547: if g_debug then
7548: hr_utility.set_location(l_proc,0);
7549: end if;
7550: --
7551: p_object_version_number := 1;
7552: --

Line 7627: hr_utility.set_location(l_proc,1000);

7623: fnd_number.number_to_canonical(p_national_pension_prem),
7624: fnd_number.number_to_canonical(p_income_exm));
7625: --
7626: if g_debug then
7627: hr_utility.set_location(l_proc,1000);
7628: end if;
7629: --
7630: end create_yea_dct;
7631: --

Line 7678: hr_utility.set_location(l_proc,0);

7674: --
7675: begin
7676: --
7677: if g_debug then
7678: hr_utility.set_location(l_proc,0);
7679: end if;
7680: --
7681: copy_pai(
7682: p_assignment_action_id,

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

7687: p_action_information_id,
7688: p_object_version_number);
7689: --
7690: if g_debug then
7691: hr_utility.set_location(l_proc,10);
7692: end if;
7693: --
7694: if p_action_information_id is null
7695: or p_object_version_number is null then

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

7694: if p_action_information_id is null
7695: or p_object_version_number is null then
7696: --
7697: if g_debug then
7698: hr_utility.set_location(l_proc,20);
7699: end if;
7700: --
7701: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7702: fnd_message.raise_error;

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

7703: --
7704: else
7705: --
7706: if g_debug then
7707: hr_utility.set_location(l_proc,30);
7708: end if;
7709: --
7710: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
7711: --

Line 7895: hr_utility.set_location(l_proc,1000);

7891: --
7892: end if;
7893: --
7894: if g_debug then
7895: hr_utility.set_location(l_proc,1000);
7896: end if;
7897: --
7898: end update_yea_dct;
7899: --

Line 7944: hr_utility.set_location(l_proc,0);

7940: --
7941: begin
7942: --
7943: if g_debug then
7944: hr_utility.set_location(l_proc,0);
7945: end if;
7946: --
7947: copy_pai(
7948: p_assignment_action_id,

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

7953: p_action_information_id,
7954: p_object_version_number);
7955: --
7956: if g_debug then
7957: hr_utility.set_location(l_proc,10);
7958: end if;
7959: --
7960: if p_action_information_id is null
7961: or p_object_version_number is null then

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

7960: if p_action_information_id is null
7961: or p_object_version_number is null then
7962: --
7963: if g_debug then
7964: hr_utility.set_location(l_proc,20);
7965: end if;
7966: --
7967: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7968: fnd_message.raise_error;

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

7969: --
7970: else
7971: --
7972: if g_debug then
7973: hr_utility.set_location(l_proc,30);
7974: end if;
7975: --
7976: p_object_version_number := p_object_version_number + 1;
7977: --

Line 8074: hr_utility.set_location(l_proc,1000);

8070: --
8071: end if;
8072: --
8073: if g_debug then
8074: hr_utility.set_location(l_proc,1000);
8075: end if;
8076: --
8077: end add_yea_dct;
8078: --

Line 8102: hr_utility.set_location(l_proc,0);

8098: l_proc varchar2(80) := c_package||'create_yea_tax';
8099: begin
8100: --
8101: if g_debug then
8102: hr_utility.set_location(l_proc,0);
8103: end if;
8104: --
8105: p_object_version_number := 1;
8106: --

Line 8139: hr_utility.set_location(l_proc,1000);

8135: fnd_number.number_to_canonical(p_yea_tax_pay),
8136: fnd_number.number_to_canonical(p_yea_income_tax));
8137: --
8138: if g_debug then
8139: hr_utility.set_location(l_proc,1000);
8140: end if;
8141: --
8142: end create_yea_tax;
8143: --

Line 8169: hr_utility.set_location(l_proc,0);

8165: --
8166: begin
8167: --
8168: if g_debug then
8169: hr_utility.set_location(l_proc,0);
8170: end if;
8171: --
8172: copy_pai(
8173: p_assignment_action_id,

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

8178: p_action_information_id,
8179: p_object_version_number);
8180: --
8181: if g_debug then
8182: hr_utility.set_location(l_proc,10);
8183: end if;
8184: --
8185: if p_action_information_id is null
8186: or p_object_version_number is null then

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

8185: if p_action_information_id is null
8186: or p_object_version_number is null then
8187: --
8188: if g_debug then
8189: hr_utility.set_location(l_proc,20);
8190: end if;
8191: --
8192: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
8193: fnd_message.raise_error;

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

8194: --
8195: else
8196: --
8197: if g_debug then
8198: hr_utility.set_location(l_proc,30);
8199: end if;
8200: --
8201: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
8202: --

Line 8260: hr_utility.set_location(l_proc,1000);

8256: --
8257: end if;
8258: --
8259: if g_debug then
8260: hr_utility.set_location(l_proc,1000);
8261: end if;
8262: --
8263: end update_yea_tax;
8264: --

Line 8288: hr_utility.set_location(l_proc,0);

8284: --
8285: begin
8286: --
8287: if g_debug then
8288: hr_utility.set_location(l_proc,0);
8289: end if;
8290: --
8291: copy_pai(
8292: p_assignment_action_id,

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

8297: p_action_information_id,
8298: p_object_version_number);
8299: --
8300: if g_debug then
8301: hr_utility.set_location(l_proc,10);
8302: end if;
8303: --
8304: if p_action_information_id is null
8305: or p_object_version_number is null then

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

8304: if p_action_information_id is null
8305: or p_object_version_number is null then
8306: --
8307: if g_debug then
8308: hr_utility.set_location(l_proc,20);
8309: end if;
8310: --
8311: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
8312: fnd_message.raise_error;

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

8313: --
8314: else
8315: --
8316: if g_debug then
8317: hr_utility.set_location(l_proc,30);
8318: end if;
8319: --
8320: p_object_version_number := p_object_version_number + 1;
8321: --

Line 8355: hr_utility.set_location(l_proc,1000);

8351: --
8352: end if;
8353: --
8354: if g_debug then
8355: hr_utility.set_location(l_proc,1000);
8356: end if;
8357: --
8358: end add_yea_tax;
8359: --

Line 8402: hr_utility.set_location(l_proc,0);

8398: l_proc varchar2(80) := c_package||'create_emp_cust';
8399: begin
8400: --
8401: if g_debug then
8402: hr_utility.set_location(l_proc,0);
8403: end if;
8404: --
8405: p_object_version_number := 1;
8406: --

Line 8477: hr_utility.set_location(l_proc,1000);

8473: p_information24,
8474: p_information25);
8475: --
8476: if g_debug then
8477: hr_utility.set_location(l_proc,1000);
8478: end if;
8479: --
8480: end create_emp_cust;
8481: --

Line 8525: hr_utility.set_location(l_proc,0);

8521: --
8522: begin
8523: --
8524: if g_debug then
8525: hr_utility.set_location(l_proc,0);
8526: end if;
8527: --
8528: copy_pai_type(
8529: p_assignment_action_id,

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

8535: p_action_information_id,
8536: p_object_version_number);
8537: --
8538: if g_debug then
8539: hr_utility.set_location(l_proc,10);
8540: end if;
8541: --
8542: if p_action_information_id is not null then
8543: --

Line 8721: hr_utility.set_location(l_proc,1000);

8717: --
8718: end if;
8719: --
8720: if g_debug then
8721: hr_utility.set_location(l_proc,1000);
8722: end if;
8723: --
8724: end update_emp_cust;
8725: --

Line 8768: hr_utility.set_location(l_proc,0);

8764: l_proc varchar2(80) := c_package||'create_emp_cust';
8765: begin
8766: --
8767: if g_debug then
8768: hr_utility.set_location(l_proc,0);
8769: end if;
8770: --
8771: create_emp_cust(
8772: p_action_information_id => p_action_information_id,

Line 8807: hr_utility.set_location(l_proc,1000);

8803: p_information25 => fnd_date.date_to_canonical(p_information25),
8804: p_object_version_number => p_object_version_number);
8805: --
8806: if g_debug then
8807: hr_utility.set_location(l_proc,1000);
8808: end if;
8809: --
8810: end create_emp_cust;
8811: --

Line 8854: hr_utility.set_location(l_proc,0);

8850: l_proc varchar2(80) := c_package||'create_emp_cust';
8851: begin
8852: --
8853: if g_debug then
8854: hr_utility.set_location(l_proc,0);
8855: end if;
8856: --
8857: create_emp_cust(
8858: p_action_information_id => p_action_information_id,

Line 8893: hr_utility.set_location(l_proc,1000);

8889: p_information25 => fnd_number.number_to_canonical(p_information25),
8890: p_object_version_number => p_object_version_number);
8891: --
8892: if g_debug then
8893: hr_utility.set_location(l_proc,1000);
8894: end if;
8895: --
8896: end create_emp_cust;
8897: --

Line 8941: hr_utility.set_location(l_proc,0);

8937: --
8938: begin
8939: --
8940: if g_debug then
8941: hr_utility.set_location(l_proc,0);
8942: end if;
8943: --
8944: update_emp_cust(
8945: p_assignment_action_id => p_assignment_action_id,

Line 8979: hr_utility.set_location(l_proc,1000);

8975: p_action_information_id => p_action_information_id,
8976: p_object_version_number => p_object_version_number);
8977: --
8978: if g_debug then
8979: hr_utility.set_location(l_proc,1000);
8980: end if;
8981: --
8982: end update_emp_cust;
8983: --

Line 9027: hr_utility.set_location(l_proc,0);

9023: --
9024: begin
9025: --
9026: if g_debug then
9027: hr_utility.set_location(l_proc,0);
9028: end if;
9029: --
9030: update_emp_cust(
9031: p_assignment_action_id => p_assignment_action_id,

Line 9065: hr_utility.set_location(l_proc,1000);

9061: p_action_information_id => p_action_information_id,
9062: p_object_version_number => p_object_version_number);
9063: --
9064: if g_debug then
9065: hr_utility.set_location(l_proc,1000);
9066: end if;
9067: --
9068: end update_emp_cust;
9069: --

Line 9149: hr_utility.set_location(l_proc,0);

9145: begin
9146: --
9147: if g_debug then
9148: --
9149: hr_utility.set_location(l_proc,0);
9150: --
9151: end if;
9152: --
9153: open csr_item_info;

Line 9197: hr_utility.trace(l_csr_item_info.payroll_name||','||to_char(l_csr_item_info.payroll_id)||','||

9193: l_item_elm||','||l_item_iv||','||l_item_bal||','||l_item_dim||','||l_csr_item_info.rep_name||','||to_char(l_csr_item_info.rep_seq)||','||l_csr_item_info.null_valid);
9194: --
9195: if g_debug then
9196: --
9197: hr_utility.trace(l_csr_item_info.payroll_name||','||to_char(l_csr_item_info.payroll_id)||','||
9198: l_csr_item_info.category||','||l_csr_item_info.type||','||
9199: l_item_elm||','||to_char(l_csr_item_info.elm_id)||','||l_item_iv||','||to_char(l_csr_item_info.iv_id)||','||
9200: l_item_bal||','||to_char(l_csr_item_info.bal_id)||','||l_item_dim||','||to_char(l_csr_item_info.dbal_id)||','||
9201: l_csr_item_info.rep_name||','||to_char(l_csr_item_info.rep_seq)||','||l_csr_item_info.null_valid);

Line 9212: hr_utility.trace('l_item_cnt : '||to_char(l_item_cnt));

9208: close csr_item_info;
9209: --
9210: if g_debug then
9211: --
9212: hr_utility.trace('l_item_cnt : '||to_char(l_item_cnt));
9213: hr_utility.set_location(l_proc,1000);
9214: --
9215: end if;
9216: --

Line 9213: hr_utility.set_location(l_proc,1000);

9209: --
9210: if g_debug then
9211: --
9212: hr_utility.trace('l_item_cnt : '||to_char(l_item_cnt));
9213: hr_utility.set_location(l_proc,1000);
9214: --
9215: end if;
9216: --
9217: end select_item_info;

Line 9306: hr_utility.set_location(l_proc,0);

9302: begin
9303: --
9304: if g_debug then
9305: --
9306: hr_utility.set_location(l_proc,0);
9307: --
9308: end if;
9309: --
9310: hr_api.mandatory_arg_error(l_proc, 'p_business_group_id', p_business_group_id);

Line 9418: hr_utility.set_location(l_proc,1000);

9414: end if;
9415: --
9416: if g_debug then
9417: --
9418: hr_utility.set_location(l_proc,1000);
9419: --
9420: end if;
9421: --
9422: end validate_item_info;

Line 9459: hr_utility.set_location(l_proc,0);

9455: begin
9456: --
9457: if g_debug then
9458: --
9459: hr_utility.set_location(l_proc,0);
9460: --
9461: end if;
9462: --
9463: if p_validate then

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

9480: end if;
9481: --
9482: if g_debug then
9483: --
9484: hr_utility.set_location(l_proc,10);
9485: --
9486: end if;
9487: --
9488: if p_type = 'IV' then

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

9500: end if;
9501: --
9502: if g_debug then
9503: --
9504: hr_utility.set_location(l_proc,20);
9505: hr_utility.trace('p_type : '||p_type);
9506: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9507: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9508: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));

Line 9505: hr_utility.trace('p_type : '||p_type);

9501: --
9502: if g_debug then
9503: --
9504: hr_utility.set_location(l_proc,20);
9505: hr_utility.trace('p_type : '||p_type);
9506: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9507: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9508: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));
9509: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));

Line 9506: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));

9502: if g_debug then
9503: --
9504: hr_utility.set_location(l_proc,20);
9505: hr_utility.trace('p_type : '||p_type);
9506: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9507: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9508: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));
9509: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));
9510: --

Line 9507: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));

9503: --
9504: hr_utility.set_location(l_proc,20);
9505: hr_utility.trace('p_type : '||p_type);
9506: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9507: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9508: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));
9509: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));
9510: --
9511: end if;

Line 9508: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));

9504: hr_utility.set_location(l_proc,20);
9505: hr_utility.trace('p_type : '||p_type);
9506: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9507: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9508: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));
9509: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));
9510: --
9511: end if;
9512: --

Line 9509: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));

9505: hr_utility.trace('p_type : '||p_type);
9506: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9507: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9508: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));
9509: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));
9510: --
9511: end if;
9512: --
9513: hr_org_information_pkg.insert_row(

Line 9562: hr_utility.trace('l_org_information_id : '||to_char(l_org_information_id));

9558: x_attribute20 => null);
9559: --
9560: if g_debug then
9561: --
9562: hr_utility.trace('l_org_information_id : '||to_char(l_org_information_id));
9563: hr_utility.set_location(l_proc,1000);
9564: --
9565: end if;
9566: --

Line 9563: hr_utility.set_location(l_proc,1000);

9559: --
9560: if g_debug then
9561: --
9562: hr_utility.trace('l_org_information_id : '||to_char(l_org_information_id));
9563: hr_utility.set_location(l_proc,1000);
9564: --
9565: end if;
9566: --
9567: end insert_item_info;

Line 9602: hr_utility.set_location(l_proc,0);

9598: begin
9599: --
9600: if g_debug then
9601: --
9602: hr_utility.set_location(l_proc,0);
9603: --
9604: end if;
9605: --
9606: if p_type = 'IV' then

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

9616: end if;
9617: --
9618: if g_debug then
9619: --
9620: hr_utility.set_location(l_proc,10);
9621: hr_utility.trace('p_type : '||p_type);
9622: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9623: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9624: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));

Line 9621: hr_utility.trace('p_type : '||p_type);

9617: --
9618: if g_debug then
9619: --
9620: hr_utility.set_location(l_proc,10);
9621: hr_utility.trace('p_type : '||p_type);
9622: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9623: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9624: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));
9625: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));

Line 9622: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));

9618: if g_debug then
9619: --
9620: hr_utility.set_location(l_proc,10);
9621: hr_utility.trace('p_type : '||p_type);
9622: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9623: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9624: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));
9625: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));
9626: --

Line 9623: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));

9619: --
9620: hr_utility.set_location(l_proc,10);
9621: hr_utility.trace('p_type : '||p_type);
9622: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9623: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9624: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));
9625: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));
9626: --
9627: end if;

Line 9624: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));

9620: hr_utility.set_location(l_proc,10);
9621: hr_utility.trace('p_type : '||p_type);
9622: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9623: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9624: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));
9625: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));
9626: --
9627: end if;
9628: --

Line 9625: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));

9621: hr_utility.trace('p_type : '||p_type);
9622: hr_utility.trace('l_element_type_id : '||to_char(l_element_type_id));
9623: hr_utility.trace('l_input_value_id : '||to_char(l_input_value_id));
9624: hr_utility.trace('l_balance_type_id : '||to_char(l_balance_type_id));
9625: hr_utility.trace('l_defined_balance_id : '||to_char(l_defined_balance_id));
9626: --
9627: end if;
9628: --
9629: insert_item_info(

Line 9647: hr_utility.set_location(l_proc,1000);

9643: p_validate => p_validate);
9644: --
9645: if g_debug then
9646: --
9647: hr_utility.set_location(l_proc,1000);
9648: --
9649: end if;
9650: --
9651: end insert_item_info;

Line 9688: hr_utility.set_location(l_proc,0);

9684: begin
9685: --
9686: if g_debug then
9687: --
9688: hr_utility.set_location(l_proc,0);
9689: --
9690: end if;
9691: --
9692: open csr_item_info;

Line 9703: hr_utility.trace('delete l_org_information_id : '||to_char(l_org_information_id));

9699: x_rowid => l_rowid);
9700: --
9701: if g_debug then
9702: --
9703: hr_utility.trace('delete l_org_information_id : '||to_char(l_org_information_id));
9704: --
9705: end if;
9706: --
9707: l_item_cnt := l_item_cnt + 1;

Line 9714: hr_utility.trace('l_item_cnt : '||to_char(l_item_cnt));

9710: close csr_item_info;
9711: --
9712: if g_debug then
9713: --
9714: hr_utility.trace('l_item_cnt : '||to_char(l_item_cnt));
9715: hr_utility.set_location(l_proc,1000);
9716: --
9717: end if;
9718: --

Line 9715: hr_utility.set_location(l_proc,1000);

9711: --
9712: if g_debug then
9713: --
9714: hr_utility.trace('l_item_cnt : '||to_char(l_item_cnt));
9715: hr_utility.set_location(l_proc,1000);
9716: --
9717: end if;
9718: --
9719: end delete_item_info;