APPS.HRDYNDBI dependencies on HR_UTILITY

Line 743: hr_utility.trace_on(null, 'HRRBDEIB');

739: --
740: PROCEDURE hrrbdeib_trace_on IS
741: BEGIN
742: if g_debug_cnt > 0 then
743: hr_utility.trace_on(null, 'HRRBDEIB');
744: end if;
745: END;
746:
747: PROCEDURE hrrbdeib_trace_off is

Line 750: hr_utility.trace_off;

746:
747: PROCEDURE hrrbdeib_trace_off is
748: BEGIN
749: if g_debug_cnt > 0 then
750: hr_utility.trace_off;
751: end if;
752: END;
753: --
754: -- Function/Procedure declarations.

Line 875: when hr_utility.hr_error then

871: -- Check if name legal format eg no spaces, or special characters
872: hr_chkfmt.checkformat (p_db_item_name, 'DB_ITEM_NAME', p_db_item_name,
873: null,null,'Y',rgeflg,null);
874: exception
875: when hr_utility.hr_error then
876: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
877: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
878: hrrbdeib_trace_on;
879: hr_utility.trace('checkformat create_user_entity');

Line 876: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');

872: hr_chkfmt.checkformat (p_db_item_name, 'DB_ITEM_NAME', p_db_item_name,
873: null,null,'Y',rgeflg,null);
874: exception
875: when hr_utility.hr_error then
876: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
877: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
878: hrrbdeib_trace_on;
879: hr_utility.trace('checkformat create_user_entity');
880: hr_utility.trace('ue name:' || p_db_item_name);

Line 877: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');

873: null,null,'Y',rgeflg,null);
874: exception
875: when hr_utility.hr_error then
876: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
877: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
878: hrrbdeib_trace_on;
879: hr_utility.trace('checkformat create_user_entity');
880: hr_utility.trace('ue name:' || p_db_item_name);
881: hrrbdeib_trace_off;

Line 879: hr_utility.trace('checkformat create_user_entity');

875: when hr_utility.hr_error then
876: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
877: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
878: hrrbdeib_trace_on;
879: hr_utility.trace('checkformat create_user_entity');
880: hr_utility.trace('ue name:' || p_db_item_name);
881: hrrbdeib_trace_off;
882: hr_utility.raise_error;
883: end;

Line 880: hr_utility.trace('ue name:' || p_db_item_name);

876: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
877: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
878: hrrbdeib_trace_on;
879: hr_utility.trace('checkformat create_user_entity');
880: hr_utility.trace('ue name:' || p_db_item_name);
881: hrrbdeib_trace_off;
882: hr_utility.raise_error;
883: end;
884: --

Line 882: hr_utility.raise_error;

878: hrrbdeib_trace_on;
879: hr_utility.trace('checkformat create_user_entity');
880: hr_utility.trace('ue name:' || p_db_item_name);
881: hrrbdeib_trace_off;
882: hr_utility.raise_error;
883: end;
884: --
885: -- create user entity
886: select ff_user_entities_s.nextval

Line 946: hr_utility.trace('hrrbdeib ins user entity: ');

942: )
943: ));
944: EXCEPTION WHEN OTHERS THEN
945: hrrbdeib_trace_on;
946: hr_utility.trace('hrrbdeib ins user entity: ');
947: hr_utility.trace(p_db_item_name || ' :routeid:');
948: hr_utility.trace(to_char(p_route_id) || ' :legcode:');
949: hr_utility.trace(p_legislation_code || ' :bgid:');
950: hr_utility.trace(to_char(p_business_group_id));

Line 947: hr_utility.trace(p_db_item_name || ' :routeid:');

943: ));
944: EXCEPTION WHEN OTHERS THEN
945: hrrbdeib_trace_on;
946: hr_utility.trace('hrrbdeib ins user entity: ');
947: hr_utility.trace(p_db_item_name || ' :routeid:');
948: hr_utility.trace(to_char(p_route_id) || ' :legcode:');
949: hr_utility.trace(p_legislation_code || ' :bgid:');
950: hr_utility.trace(to_char(p_business_group_id));
951: hrrbdeib_trace_off;

Line 948: hr_utility.trace(to_char(p_route_id) || ' :legcode:');

944: EXCEPTION WHEN OTHERS THEN
945: hrrbdeib_trace_on;
946: hr_utility.trace('hrrbdeib ins user entity: ');
947: hr_utility.trace(p_db_item_name || ' :routeid:');
948: hr_utility.trace(to_char(p_route_id) || ' :legcode:');
949: hr_utility.trace(p_legislation_code || ' :bgid:');
950: hr_utility.trace(to_char(p_business_group_id));
951: hrrbdeib_trace_off;
952: raise;

Line 949: hr_utility.trace(p_legislation_code || ' :bgid:');

945: hrrbdeib_trace_on;
946: hr_utility.trace('hrrbdeib ins user entity: ');
947: hr_utility.trace(p_db_item_name || ' :routeid:');
948: hr_utility.trace(to_char(p_route_id) || ' :legcode:');
949: hr_utility.trace(p_legislation_code || ' :bgid:');
950: hr_utility.trace(to_char(p_business_group_id));
951: hrrbdeib_trace_off;
952: raise;
953: END;

Line 950: hr_utility.trace(to_char(p_business_group_id));

946: hr_utility.trace('hrrbdeib ins user entity: ');
947: hr_utility.trace(p_db_item_name || ' :routeid:');
948: hr_utility.trace(to_char(p_route_id) || ' :legcode:');
949: hr_utility.trace(p_legislation_code || ' :bgid:');
950: hr_utility.trace(to_char(p_business_group_id));
951: hrrbdeib_trace_off;
952: raise;
953: END;
954: ELSE -- g_triggers_altered is FALSE so use existing trigger validation

Line 1032: hr_utility.trace('hrrbdeib ins dbi: ');

1028: end if;
1029: exception
1030: when others then
1031: hrrbdeib_trace_on;
1032: hr_utility.trace('hrrbdeib ins dbi: ');
1033: hr_utility.trace(p_db_item_name || ' :ue id:');
1034: hr_utility.trace(to_char(p_user_entity_id) || ' :legcode:');
1035: hr_utility.trace(p_legislation_code || ' :bgid:');
1036: hr_utility.trace(to_char(p_business_group_id));

Line 1033: hr_utility.trace(p_db_item_name || ' :ue id:');

1029: exception
1030: when others then
1031: hrrbdeib_trace_on;
1032: hr_utility.trace('hrrbdeib ins dbi: ');
1033: hr_utility.trace(p_db_item_name || ' :ue id:');
1034: hr_utility.trace(to_char(p_user_entity_id) || ' :legcode:');
1035: hr_utility.trace(p_legislation_code || ' :bgid:');
1036: hr_utility.trace(to_char(p_business_group_id));
1037: hrrbdeib_trace_off;

Line 1034: hr_utility.trace(to_char(p_user_entity_id) || ' :legcode:');

1030: when others then
1031: hrrbdeib_trace_on;
1032: hr_utility.trace('hrrbdeib ins dbi: ');
1033: hr_utility.trace(p_db_item_name || ' :ue id:');
1034: hr_utility.trace(to_char(p_user_entity_id) || ' :legcode:');
1035: hr_utility.trace(p_legislation_code || ' :bgid:');
1036: hr_utility.trace(to_char(p_business_group_id));
1037: hrrbdeib_trace_off;
1038: raise;

Line 1035: hr_utility.trace(p_legislation_code || ' :bgid:');

1031: hrrbdeib_trace_on;
1032: hr_utility.trace('hrrbdeib ins dbi: ');
1033: hr_utility.trace(p_db_item_name || ' :ue id:');
1034: hr_utility.trace(to_char(p_user_entity_id) || ' :legcode:');
1035: hr_utility.trace(p_legislation_code || ' :bgid:');
1036: hr_utility.trace(to_char(p_business_group_id));
1037: hrrbdeib_trace_off;
1038: raise;
1039: end;

Line 1036: hr_utility.trace(to_char(p_business_group_id));

1032: hr_utility.trace('hrrbdeib ins dbi: ');
1033: hr_utility.trace(p_db_item_name || ' :ue id:');
1034: hr_utility.trace(to_char(p_user_entity_id) || ' :legcode:');
1035: hr_utility.trace(p_legislation_code || ' :bgid:');
1036: hr_utility.trace(to_char(p_business_group_id));
1037: hrrbdeib_trace_off;
1038: raise;
1039: end;
1040: ---------------------------------------------------------------------------

Line 1196: hr_utility.set_message(801, 'HR_ERROR');

1192: from ff_route_parameters RP
1193: where RP.route_id = rrrec.route_id
1194: and RP.sequence_no = 1;
1195: if sql%rowcount <> 1 then
1196: hr_utility.set_message(801, 'HR_ERROR');
1197: hrrbdeib_trace_on;
1198: hr_utility.trace('missing seq 1 route param for route : ' || to_char(rrrec.route_id) || ' :user ent id:' || to_char(usr_ent_id));
1199: hrrbdeib_trace_off;
1200: hr_utility.raise_error;

Line 1198: hr_utility.trace('missing seq 1 route param for route : ' || to_char(rrrec.route_id) || ' :user ent id:' || to_char(usr_ent_id));

1194: and RP.sequence_no = 1;
1195: if sql%rowcount <> 1 then
1196: hr_utility.set_message(801, 'HR_ERROR');
1197: hrrbdeib_trace_on;
1198: hr_utility.trace('missing seq 1 route param for route : ' || to_char(rrrec.route_id) || ' :user ent id:' || to_char(usr_ent_id));
1199: hrrbdeib_trace_off;
1200: hr_utility.raise_error;
1201: end if;
1202: --

Line 1200: hr_utility.raise_error;

1196: hr_utility.set_message(801, 'HR_ERROR');
1197: hrrbdeib_trace_on;
1198: hr_utility.trace('missing seq 1 route param for route : ' || to_char(rrrec.route_id) || ' :user ent id:' || to_char(usr_ent_id));
1199: hrrbdeib_trace_off;
1200: hr_utility.raise_error;
1201: end if;
1202: --
1203: if rrrec.route_type = 'SRB' then
1204: --

Line 1219: hr_utility.set_message(801, 'HR_ERROR');

1215: from ff_route_parameters RP
1216: where RP.route_id = rrrec.route_id
1217: and RP.sequence_no = 2;
1218: if sql%rowcount <> 1 then
1219: hr_utility.set_message(801, 'HR_ERROR');
1220: hrrbdeib_trace_on;
1221: hr_utility.trace('missing seq 2 route param for route : ' || to_char(rrrec.route_id) || ' :user ent id:' || to_char(usr_ent_id));
1222: hrrbdeib_trace_off;
1223: hr_utility.raise_error;

Line 1221: hr_utility.trace('missing seq 2 route param for route : ' || to_char(rrrec.route_id) || ' :user ent id:' || to_char(usr_ent_id));

1217: and RP.sequence_no = 2;
1218: if sql%rowcount <> 1 then
1219: hr_utility.set_message(801, 'HR_ERROR');
1220: hrrbdeib_trace_on;
1221: hr_utility.trace('missing seq 2 route param for route : ' || to_char(rrrec.route_id) || ' :user ent id:' || to_char(usr_ent_id));
1222: hrrbdeib_trace_off;
1223: hr_utility.raise_error;
1224: end if;
1225: end if;

Line 1223: hr_utility.raise_error;

1219: hr_utility.set_message(801, 'HR_ERROR');
1220: hrrbdeib_trace_on;
1221: hr_utility.trace('missing seq 2 route param for route : ' || to_char(rrrec.route_id) || ' :user ent id:' || to_char(usr_ent_id));
1222: hrrbdeib_trace_off;
1223: hr_utility.raise_error;
1224: end if;
1225: end if;
1226: --
1227:

Line 1354: hr_utility.trace('update pay_def_bal.save_run_balance:def_bal_id:' || to_char(p_defined_balance_id) ||

1350: where defined_balance_id = p_defined_balance_id;
1351: exception
1352: when others then
1353: hrrbdeib_trace_on;
1354: hr_utility.trace('update pay_def_bal.save_run_balance:def_bal_id:' || to_char(p_defined_balance_id) ||
1355: 'to save_run_balance:' || nvl(l_run_bal_flag, 'NULL') || ':');
1356: hrrbdeib_trace_off;
1357: raise;
1358: end;

Line 1380: hr_utility.trace('missing baldim type info : baldim: ' || to_char(p_balance_dimension_id) ||

1376: where BALDIM.balance_dimension_id = p_balance_dimension_id
1377: and BALTYPE.balance_type_id = p_balance_type_id;
1378: EXCEPTION WHEN OTHERS THEN
1379: hrrbdeib_trace_on;
1380: hr_utility.trace('missing baldim type info : baldim: ' || to_char(p_balance_dimension_id) ||
1381: ' bal type: ' || to_char(p_balance_type_id));
1382: hrrbdeib_trace_off;
1383: END;
1384: --

Line 1417: hr_utility.set_message(801, 'HR_ERROR');

1413: from ff_route_parameters RP
1414: where RP.route_id = l_route_id
1415: and RP.sequence_no = 1;
1416: if sql%rowcount <> 1 then
1417: hr_utility.set_message(801, 'HR_ERROR');
1418: hrrbdeib_trace_on;
1419: hr_utility.trace('missing seq 1 route param for route : ' || to_char(l_route_id));
1420: hrrbdeib_trace_off;
1421: hr_utility.raise_error;

Line 1419: hr_utility.trace('missing seq 1 route param for route : ' || to_char(l_route_id));

1415: and RP.sequence_no = 1;
1416: if sql%rowcount <> 1 then
1417: hr_utility.set_message(801, 'HR_ERROR');
1418: hrrbdeib_trace_on;
1419: hr_utility.trace('missing seq 1 route param for route : ' || to_char(l_route_id));
1420: hrrbdeib_trace_off;
1421: hr_utility.raise_error;
1422: end if;
1423: --

Line 1421: hr_utility.raise_error;

1417: hr_utility.set_message(801, 'HR_ERROR');
1418: hrrbdeib_trace_on;
1419: hr_utility.trace('missing seq 1 route param for route : ' || to_char(l_route_id));
1420: hrrbdeib_trace_off;
1421: hr_utility.raise_error;
1422: end if;
1423: --
1424: --
1425: -- Use Rule hint on balances if LOW_VOLUME pay_action_paremeter set

Line 1574: hr_utility.trace('entering refresh_defined_balances all' ||

1570:
1571: begin
1572:
1573: hrrbdeib_trace_on;
1574: hr_utility.trace('entering refresh_defined_balances all' ||
1575: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
1576: to_char(p_maxworkers));
1577: hrrbdeib_trace_off;
1578:

Line 1585: hr_utility.trace('RDB:B :' || to_char(p_worker_id + 1) || ':' ||

1581: -- create missing B and RB data
1582:
1583: for c1rec in c1 loop
1584: hrrbdeib_trace_on;
1585: hr_utility.trace('RDB:B :' || to_char(p_worker_id + 1) || ':' ||
1586: c1rec.legislation_code || '.' ||
1587: to_char(c1rec.business_group_id) || '.' ||
1588: to_char(c1rec.defined_balance_id) || '.' ||
1589: to_char(c1rec.balance_dimension_id) || '.' ||

Line 1617: hr_utility.trace('RDB:RB:' || to_char(p_worker_id + 1) || ':' ||

1613:
1614: for c2rec in c2 loop
1615:
1616: hrrbdeib_trace_on;
1617: hr_utility.trace('RDB:RB:' || to_char(p_worker_id + 1) || ':' ||
1618: c2rec.legislation_code || '.' ||
1619: to_char(c2rec.business_group_id) || '.' ||
1620: to_char(c2rec.defined_balance_id) || '.' ||
1621: to_char(c2rec.balance_dimension_id) || '.' ||

Line 1637: hr_utility.trace('missing baldim type2 info : baldim: ' ||

1633: where BALDIM.balance_dimension_id = c2rec.balance_dimension_id
1634: and BALTYPE.balance_type_id = c2rec.balance_type_id;
1635: EXCEPTION WHEN OTHERS THEN
1636: hrrbdeib_trace_on;
1637: hr_utility.trace('missing baldim type2 info : baldim: ' ||
1638: to_char(c2rec.balance_dimension_id) ||
1639: ' bal type: ' || to_char(c2rec.balance_type_id));
1640: hrrbdeib_trace_off;
1641: END;

Line 1674: hr_utility.trace('leaving refresh_defined_balances all' ||

1670:
1671: end loop;
1672:
1673: hrrbdeib_trace_on;
1674: hr_utility.trace('leaving refresh_defined_balances all' ||
1675: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
1676: to_char(p_maxworkers));
1677: hrrbdeib_trace_off;
1678:

Line 1755: hr_utility.trace('entering refresh_defined_balances ' || p_leg_code ||

1751:
1752: begin
1753:
1754: hrrbdeib_trace_on;
1755: hr_utility.trace('entering refresh_defined_balances ' || p_leg_code ||
1756: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
1757: to_char(p_maxworkers));
1758: hrrbdeib_trace_off;
1759:

Line 1767: hr_utility.trace('RDB:B :' || to_char(p_worker_id + 1) || ':' ||

1763:
1764: for c1rec in c1 loop
1765:
1766: hrrbdeib_trace_on;
1767: hr_utility.trace('RDB:B :' || to_char(p_worker_id + 1) || ':' ||
1768: c1rec.legislation_code || '.' ||
1769: to_char(c1rec.business_group_id) || '.' ||
1770: to_char(c1rec.defined_balance_id) || '.' ||
1771: to_char(c1rec.balance_dimension_id) || '.' ||

Line 1799: hr_utility.trace('RDB:RB:' || to_char(p_worker_id + 1) || ':' ||

1795:
1796: for c2rec in c2 loop
1797:
1798: hrrbdeib_trace_on;
1799: hr_utility.trace('RDB:RB:' || to_char(p_worker_id + 1) || ':' ||
1800: c2rec.legislation_code || '.' ||
1801: to_char(c2rec.business_group_id) || '.' ||
1802: to_char(c2rec.defined_balance_id) || '.' ||
1803: to_char(c2rec.balance_dimension_id) || '.' ||

Line 1819: hr_utility.trace('missing baldim type2 info : baldim: ' ||

1815: where BALDIM.balance_dimension_id = c2rec.balance_dimension_id
1816: and BALTYPE.balance_type_id = c2rec.balance_type_id;
1817: EXCEPTION WHEN OTHERS THEN
1818: hrrbdeib_trace_on;
1819: hr_utility.trace('missing baldim type2 info : baldim: ' ||
1820: to_char(c2rec.balance_dimension_id) ||
1821: ' bal type: ' || to_char(c2rec.balance_type_id));
1822: hrrbdeib_trace_off;
1823: END;

Line 1856: hr_utility.trace('leaving refresh_defined_balances ' || p_leg_code ||

1852:
1853: end loop;
1854:
1855: hrrbdeib_trace_on;
1856: hr_utility.trace('leaving refresh_defined_balances ' || p_leg_code ||
1857: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
1858: to_char(p_maxworkers));
1859: hrrbdeib_trace_off;
1860:

Line 1958: hr_utility.trace(SQLCODE || '-' || SQLERRM);

1954: and RPARAM.route_id = ENTITY.route_id
1955: and RPARAM.sequence_no = p_sequence_no;
1956: EXCEPTION WHEN OTHERS THEN
1957: hrrbdeib_trace_on;
1958: hr_utility.trace(SQLCODE || '-' || SQLERRM);
1959: hr_utility.trace('insert param val');
1960: hr_utility.trace(' seqno: ' || to_char(p_sequence_no));
1961: hr_utility.trace('Checking for user entity ' || to_char(l_user_entity_id)
1962: || ' details');

Line 1959: hr_utility.trace('insert param val');

1955: and RPARAM.sequence_no = p_sequence_no;
1956: EXCEPTION WHEN OTHERS THEN
1957: hrrbdeib_trace_on;
1958: hr_utility.trace(SQLCODE || '-' || SQLERRM);
1959: hr_utility.trace('insert param val');
1960: hr_utility.trace(' seqno: ' || to_char(p_sequence_no));
1961: hr_utility.trace('Checking for user entity ' || to_char(l_user_entity_id)
1962: || ' details');
1963: BEGIN

Line 1960: hr_utility.trace(' seqno: ' || to_char(p_sequence_no));

1956: EXCEPTION WHEN OTHERS THEN
1957: hrrbdeib_trace_on;
1958: hr_utility.trace(SQLCODE || '-' || SQLERRM);
1959: hr_utility.trace('insert param val');
1960: hr_utility.trace(' seqno: ' || to_char(p_sequence_no));
1961: hr_utility.trace('Checking for user entity ' || to_char(l_user_entity_id)
1962: || ' details');
1963: BEGIN
1964: select ENTITY.user_entity_name,

Line 1961: hr_utility.trace('Checking for user entity ' || to_char(l_user_entity_id)

1957: hrrbdeib_trace_on;
1958: hr_utility.trace(SQLCODE || '-' || SQLERRM);
1959: hr_utility.trace('insert param val');
1960: hr_utility.trace(' seqno: ' || to_char(p_sequence_no));
1961: hr_utility.trace('Checking for user entity ' || to_char(l_user_entity_id)
1962: || ' details');
1963: BEGIN
1964: select ENTITY.user_entity_name,
1965: ENTITY.route_id,

Line 1975: hr_utility.trace('entity_name: ' || l_user_entity_name);

1971: l_ent_lc
1972: from ff_user_entities ENTITY
1973: where ENTITY.user_entity_id = l_user_entity_id;
1974:
1975: hr_utility.trace('entity_name: ' || l_user_entity_name);
1976: hr_utility.trace('entity route id: ' || to_char(l_route_id));
1977: hr_utility.trace('entity BG id: ' || to_char(l_ent_bg_id));
1978: hr_utility.trace('entity LC: ' || l_ent_lc);
1979:

Line 1976: hr_utility.trace('entity route id: ' || to_char(l_route_id));

1972: from ff_user_entities ENTITY
1973: where ENTITY.user_entity_id = l_user_entity_id;
1974:
1975: hr_utility.trace('entity_name: ' || l_user_entity_name);
1976: hr_utility.trace('entity route id: ' || to_char(l_route_id));
1977: hr_utility.trace('entity BG id: ' || to_char(l_ent_bg_id));
1978: hr_utility.trace('entity LC: ' || l_ent_lc);
1979:
1980: IF l_route_id is not null THEN

Line 1977: hr_utility.trace('entity BG id: ' || to_char(l_ent_bg_id));

1973: where ENTITY.user_entity_id = l_user_entity_id;
1974:
1975: hr_utility.trace('entity_name: ' || l_user_entity_name);
1976: hr_utility.trace('entity route id: ' || to_char(l_route_id));
1977: hr_utility.trace('entity BG id: ' || to_char(l_ent_bg_id));
1978: hr_utility.trace('entity LC: ' || l_ent_lc);
1979:
1980: IF l_route_id is not null THEN
1981: select route_name,

Line 1978: hr_utility.trace('entity LC: ' || l_ent_lc);

1974:
1975: hr_utility.trace('entity_name: ' || l_user_entity_name);
1976: hr_utility.trace('entity route id: ' || to_char(l_route_id));
1977: hr_utility.trace('entity BG id: ' || to_char(l_ent_bg_id));
1978: hr_utility.trace('entity LC: ' || l_ent_lc);
1979:
1980: IF l_route_id is not null THEN
1981: select route_name,
1982: to_char(CREATION_DATE, 'DD-MM-YYYY'),

Line 1992: hr_utility.trace('route_name: ' || l_route_name);

1988: l_route_lub
1989: from ff_routes
1990: where route_id = l_route_id;
1991:
1992: hr_utility.trace('route_name: ' || l_route_name);
1993: hr_utility.trace('route creation date: ' || l_route_cd);
1994: hr_utility.trace('route LUD: ' || l_route_lud);
1995: hr_utility.trace('route LUB: ' || to_char(l_route_lub));
1996: hrrbdeib_trace_off;

Line 1993: hr_utility.trace('route creation date: ' || l_route_cd);

1989: from ff_routes
1990: where route_id = l_route_id;
1991:
1992: hr_utility.trace('route_name: ' || l_route_name);
1993: hr_utility.trace('route creation date: ' || l_route_cd);
1994: hr_utility.trace('route LUD: ' || l_route_lud);
1995: hr_utility.trace('route LUB: ' || to_char(l_route_lub));
1996: hrrbdeib_trace_off;
1997:

Line 1994: hr_utility.trace('route LUD: ' || l_route_lud);

1990: where route_id = l_route_id;
1991:
1992: hr_utility.trace('route_name: ' || l_route_name);
1993: hr_utility.trace('route creation date: ' || l_route_cd);
1994: hr_utility.trace('route LUD: ' || l_route_lud);
1995: hr_utility.trace('route LUB: ' || to_char(l_route_lub));
1996: hrrbdeib_trace_off;
1997:
1998: END IF;

Line 1995: hr_utility.trace('route LUB: ' || to_char(l_route_lub));

1991:
1992: hr_utility.trace('route_name: ' || l_route_name);
1993: hr_utility.trace('route creation date: ' || l_route_cd);
1994: hr_utility.trace('route LUD: ' || l_route_lud);
1995: hr_utility.trace('route LUB: ' || to_char(l_route_lub));
1996: hrrbdeib_trace_off;
1997:
1998: END IF;
1999: EXCEPTION WHEN OTHERS THEN NULL;

Line 2221: hr_utility.trace('ins dbi: g_trigger TRUE');

2217: EXCEPTION
2218: WHEN OTHERS THEN
2219: hrrbdeib_trace_on;
2220: IF (g_triggers_altered) THEN
2221: hr_utility.trace('ins dbi: g_trigger TRUE');
2222: ELSE
2223: hr_utility.trace('ins dbi: g_trigger FALSE');
2224: END IF;
2225: hr_utility.trace('ins dbi: dbi: ' || l_user_name);

Line 2223: hr_utility.trace('ins dbi: g_trigger FALSE');

2219: hrrbdeib_trace_on;
2220: IF (g_triggers_altered) THEN
2221: hr_utility.trace('ins dbi: g_trigger TRUE');
2222: ELSE
2223: hr_utility.trace('ins dbi: g_trigger FALSE');
2224: END IF;
2225: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2226: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2227: hr_utility.trace('ins dbi: item: ' || l_item_name);

Line 2225: hr_utility.trace('ins dbi: dbi: ' || l_user_name);

2221: hr_utility.trace('ins dbi: g_trigger TRUE');
2222: ELSE
2223: hr_utility.trace('ins dbi: g_trigger FALSE');
2224: END IF;
2225: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2226: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2227: hr_utility.trace('ins dbi: item: ' || l_item_name);
2228: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));
2229: hr_utility.trace('ins dbi: lang: ' || c_lang_rec.language_code);

Line 2226: hr_utility.trace('ins dbi: ue: ' || p_entity_name);

2222: ELSE
2223: hr_utility.trace('ins dbi: g_trigger FALSE');
2224: END IF;
2225: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2226: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2227: hr_utility.trace('ins dbi: item: ' || l_item_name);
2228: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));
2229: hr_utility.trace('ins dbi: lang: ' || c_lang_rec.language_code);
2230: hrrbdeib_trace_off;

Line 2227: hr_utility.trace('ins dbi: item: ' || l_item_name);

2223: hr_utility.trace('ins dbi: g_trigger FALSE');
2224: END IF;
2225: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2226: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2227: hr_utility.trace('ins dbi: item: ' || l_item_name);
2228: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));
2229: hr_utility.trace('ins dbi: lang: ' || c_lang_rec.language_code);
2230: hrrbdeib_trace_off;
2231:

Line 2228: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));

2224: END IF;
2225: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2226: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2227: hr_utility.trace('ins dbi: item: ' || l_item_name);
2228: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));
2229: hr_utility.trace('ins dbi: lang: ' || c_lang_rec.language_code);
2230: hrrbdeib_trace_off;
2231:
2232: if c_dbi_exists%isopen then

Line 2229: hr_utility.trace('ins dbi: lang: ' || c_lang_rec.language_code);

2225: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2226: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2227: hr_utility.trace('ins dbi: item: ' || l_item_name);
2228: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));
2229: hr_utility.trace('ins dbi: lang: ' || c_lang_rec.language_code);
2230: hrrbdeib_trace_off;
2231:
2232: if c_dbi_exists%isopen then
2233: close c_dbi_exists;

Line 2306: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');

2302: else
2303: --
2304: -- For the full MLS process, a name clash is a fatal error.
2305: --
2306: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');
2307: hr_utility.set_message_token('1', l_user_name);
2308: hr_utility.raise_error;
2309: end if;
2310: EXCEPTION

Line 2307: hr_utility.set_message_token('1', l_user_name);

2303: --
2304: -- For the full MLS process, a name clash is a fatal error.
2305: --
2306: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');
2307: hr_utility.set_message_token('1', l_user_name);
2308: hr_utility.raise_error;
2309: end if;
2310: EXCEPTION
2311: WHEN OTHERS THEN

Line 2308: hr_utility.raise_error;

2304: -- For the full MLS process, a name clash is a fatal error.
2305: --
2306: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');
2307: hr_utility.set_message_token('1', l_user_name);
2308: hr_utility.raise_error;
2309: end if;
2310: EXCEPTION
2311: WHEN OTHERS THEN
2312: hrrbdeib_trace_on;

Line 2314: hr_utility.trace('ins dbi: g_trigger TRUE');

2310: EXCEPTION
2311: WHEN OTHERS THEN
2312: hrrbdeib_trace_on;
2313: IF (g_triggers_altered) THEN
2314: hr_utility.trace('ins dbi: g_trigger TRUE');
2315: ELSE
2316: hr_utility.trace('ins dbi: g_trigger FALSE');
2317: END IF;
2318: hr_utility.trace('ins dbi: dbi: ' || l_user_name);

Line 2316: hr_utility.trace('ins dbi: g_trigger FALSE');

2312: hrrbdeib_trace_on;
2313: IF (g_triggers_altered) THEN
2314: hr_utility.trace('ins dbi: g_trigger TRUE');
2315: ELSE
2316: hr_utility.trace('ins dbi: g_trigger FALSE');
2317: END IF;
2318: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2319: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2320: hr_utility.trace('ins dbi: item: ' || l_item_name);

Line 2318: hr_utility.trace('ins dbi: dbi: ' || l_user_name);

2314: hr_utility.trace('ins dbi: g_trigger TRUE');
2315: ELSE
2316: hr_utility.trace('ins dbi: g_trigger FALSE');
2317: END IF;
2318: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2319: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2320: hr_utility.trace('ins dbi: item: ' || l_item_name);
2321: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));
2322: hr_utility.trace('ins dbi: base name' );

Line 2319: hr_utility.trace('ins dbi: ue: ' || p_entity_name);

2315: ELSE
2316: hr_utility.trace('ins dbi: g_trigger FALSE');
2317: END IF;
2318: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2319: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2320: hr_utility.trace('ins dbi: item: ' || l_item_name);
2321: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));
2322: hr_utility.trace('ins dbi: base name' );
2323: hrrbdeib_trace_off;

Line 2320: hr_utility.trace('ins dbi: item: ' || l_item_name);

2316: hr_utility.trace('ins dbi: g_trigger FALSE');
2317: END IF;
2318: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2319: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2320: hr_utility.trace('ins dbi: item: ' || l_item_name);
2321: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));
2322: hr_utility.trace('ins dbi: base name' );
2323: hrrbdeib_trace_off;
2324:

Line 2321: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));

2317: END IF;
2318: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2319: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2320: hr_utility.trace('ins dbi: item: ' || l_item_name);
2321: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));
2322: hr_utility.trace('ins dbi: base name' );
2323: hrrbdeib_trace_off;
2324:
2325: if c_dbi_exists%isopen then

Line 2322: hr_utility.trace('ins dbi: base name' );

2318: hr_utility.trace('ins dbi: dbi: ' || l_user_name);
2319: hr_utility.trace('ins dbi: ue: ' || p_entity_name);
2320: hr_utility.trace('ins dbi: item: ' || l_item_name);
2321: hr_utility.trace('ins dbi: ueid: ' || to_char(l_user_entity_id));
2322: hr_utility.trace('ins dbi: base name' );
2323: hrrbdeib_trace_off;
2324:
2325: if c_dbi_exists%isopen then
2326: close c_dbi_exists;

Line 2555: when hr_utility.hr_error then

2551: begin
2552: hr_chkfmt.checkformat (l_user_entity_name, 'DB_ITEM_NAME', l_user_entity_name,
2553: null,null,'Y',rgeflg,null);
2554: exception
2555: when hr_utility.hr_error then
2556: -- FFHR_6016_ALL_RES_WORDS error condition
2557: -- so add quotes
2558: --Bug 5930272
2559: fnd_message.retrieve(l_message);

Line 2579: when hr_utility.hr_error then

2575: -- Check if name legal format eg no spaces, or special characters
2576: hr_chkfmt.checkformat (l_user_entity_name, 'DB_ITEM_NAME', l_user_entity_name,
2577: null,null,'Y',rgeflg,null);
2578: exception
2579: when hr_utility.hr_error then
2580: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
2581: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
2582: hrrbdeib_trace_on;
2583: hr_utility.trace('chkfmt DB_ITEM_NAME');

Line 2580: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');

2576: hr_chkfmt.checkformat (l_user_entity_name, 'DB_ITEM_NAME', l_user_entity_name,
2577: null,null,'Y',rgeflg,null);
2578: exception
2579: when hr_utility.hr_error then
2580: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
2581: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
2582: hrrbdeib_trace_on;
2583: hr_utility.trace('chkfmt DB_ITEM_NAME');
2584: hr_utility.trace('ue: ' || l_user_entity_name);

Line 2581: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');

2577: null,null,'Y',rgeflg,null);
2578: exception
2579: when hr_utility.hr_error then
2580: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
2581: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
2582: hrrbdeib_trace_on;
2583: hr_utility.trace('chkfmt DB_ITEM_NAME');
2584: hr_utility.trace('ue: ' || l_user_entity_name);
2585: hr_utility.trace('route_name: ' || p_route_name);

Line 2583: hr_utility.trace('chkfmt DB_ITEM_NAME');

2579: when hr_utility.hr_error then
2580: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
2581: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
2582: hrrbdeib_trace_on;
2583: hr_utility.trace('chkfmt DB_ITEM_NAME');
2584: hr_utility.trace('ue: ' || l_user_entity_name);
2585: hr_utility.trace('route_name: ' || p_route_name);
2586: hr_utility.trace('creator_id: ' || to_char(p_creator_id));
2587: hr_utility.trace('creator_type: ' || p_creator_type);

Line 2584: hr_utility.trace('ue: ' || l_user_entity_name);

2580: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
2581: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
2582: hrrbdeib_trace_on;
2583: hr_utility.trace('chkfmt DB_ITEM_NAME');
2584: hr_utility.trace('ue: ' || l_user_entity_name);
2585: hr_utility.trace('route_name: ' || p_route_name);
2586: hr_utility.trace('creator_id: ' || to_char(p_creator_id));
2587: hr_utility.trace('creator_type: ' || p_creator_type);
2588: hr_utility.trace('rgeflg: ' || rgeflg);

Line 2585: hr_utility.trace('route_name: ' || p_route_name);

2581: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
2582: hrrbdeib_trace_on;
2583: hr_utility.trace('chkfmt DB_ITEM_NAME');
2584: hr_utility.trace('ue: ' || l_user_entity_name);
2585: hr_utility.trace('route_name: ' || p_route_name);
2586: hr_utility.trace('creator_id: ' || to_char(p_creator_id));
2587: hr_utility.trace('creator_type: ' || p_creator_type);
2588: hr_utility.trace('rgeflg: ' || rgeflg);
2589: hrrbdeib_trace_off;

Line 2586: hr_utility.trace('creator_id: ' || to_char(p_creator_id));

2582: hrrbdeib_trace_on;
2583: hr_utility.trace('chkfmt DB_ITEM_NAME');
2584: hr_utility.trace('ue: ' || l_user_entity_name);
2585: hr_utility.trace('route_name: ' || p_route_name);
2586: hr_utility.trace('creator_id: ' || to_char(p_creator_id));
2587: hr_utility.trace('creator_type: ' || p_creator_type);
2588: hr_utility.trace('rgeflg: ' || rgeflg);
2589: hrrbdeib_trace_off;
2590: raise;

Line 2587: hr_utility.trace('creator_type: ' || p_creator_type);

2583: hr_utility.trace('chkfmt DB_ITEM_NAME');
2584: hr_utility.trace('ue: ' || l_user_entity_name);
2585: hr_utility.trace('route_name: ' || p_route_name);
2586: hr_utility.trace('creator_id: ' || to_char(p_creator_id));
2587: hr_utility.trace('creator_type: ' || p_creator_type);
2588: hr_utility.trace('rgeflg: ' || rgeflg);
2589: hrrbdeib_trace_off;
2590: raise;
2591: end;

Line 2588: hr_utility.trace('rgeflg: ' || rgeflg);

2584: hr_utility.trace('ue: ' || l_user_entity_name);
2585: hr_utility.trace('route_name: ' || p_route_name);
2586: hr_utility.trace('creator_id: ' || to_char(p_creator_id));
2587: hr_utility.trace('creator_type: ' || p_creator_type);
2588: hr_utility.trace('rgeflg: ' || rgeflg);
2589: hrrbdeib_trace_off;
2590: raise;
2591: end;
2592: END IF; -- g_triggers_altered

Line 2617: hr_utility.trace('insert_user_entity_main : missing route : ' ||

2613: WHERE route_name = p_route_name;
2614:
2615: EXCEPTION WHEN OTHERS THEN
2616: hrrbdeib_trace_on;
2617: hr_utility.trace('insert_user_entity_main : missing route : ' ||
2618: p_route_name);
2619: hrrbdeib_trace_off;
2620: raise;
2621: END;

Line 2724: hr_utility.trace('insert ff_user_entities: ue: ' || l_user_entity_name);

2720: END IF;
2721: p_record_inserted := TRUE;
2722: EXCEPTION WHEN OTHERS THEN
2723: hrrbdeib_trace_on;
2724: hr_utility.trace('insert ff_user_entities: ue: ' || l_user_entity_name);
2725: hr_utility.trace('insert ff_user_entities: route_name: ' || p_route_name);
2726: hrrbdeib_trace_off;
2727: raise;
2728: END;

Line 2725: hr_utility.trace('insert ff_user_entities: route_name: ' || p_route_name);

2721: p_record_inserted := TRUE;
2722: EXCEPTION WHEN OTHERS THEN
2723: hrrbdeib_trace_on;
2724: hr_utility.trace('insert ff_user_entities: ue: ' || l_user_entity_name);
2725: hr_utility.trace('insert ff_user_entities: route_name: ' || p_route_name);
2726: hrrbdeib_trace_off;
2727: raise;
2728: END;
2729:

Line 4011: hr_utility.trace('create_input_value select');

4007: and ET.effective_end_date;
4008: EXCEPTION WHEN OTHERS THEN
4009: BEGIN
4010: hrrbdeib_trace_on;
4011: hr_utility.trace('create_input_value select');
4012: hr_utility.trace('effective_date: ' ||
4013: to_char(p_effective_date, 'DD-MM-YYYY'));
4014: hr_utility.trace('input_value_id : ' || to_char(p_input_value_id));
4015:

Line 4012: hr_utility.trace('effective_date: ' ||

4008: EXCEPTION WHEN OTHERS THEN
4009: BEGIN
4010: hrrbdeib_trace_on;
4011: hr_utility.trace('create_input_value select');
4012: hr_utility.trace('effective_date: ' ||
4013: to_char(p_effective_date, 'DD-MM-YYYY'));
4014: hr_utility.trace('input_value_id : ' || to_char(p_input_value_id));
4015:
4016: FOR iv IN c_list_ivs(p_input_value_id) LOOP

Line 4014: hr_utility.trace('input_value_id : ' || to_char(p_input_value_id));

4010: hrrbdeib_trace_on;
4011: hr_utility.trace('create_input_value select');
4012: hr_utility.trace('effective_date: ' ||
4013: to_char(p_effective_date, 'DD-MM-YYYY'));
4014: hr_utility.trace('input_value_id : ' || to_char(p_input_value_id));
4015:
4016: FOR iv IN c_list_ivs(p_input_value_id) LOOP
4017: hr_utility.trace('input name: ' || iv.name);
4018: hr_utility.trace('input el_type_id: ' ||

Line 4017: hr_utility.trace('input name: ' || iv.name);

4013: to_char(p_effective_date, 'DD-MM-YYYY'));
4014: hr_utility.trace('input_value_id : ' || to_char(p_input_value_id));
4015:
4016: FOR iv IN c_list_ivs(p_input_value_id) LOOP
4017: hr_utility.trace('input name: ' || iv.name);
4018: hr_utility.trace('input el_type_id: ' ||
4019: to_char(iv.element_type_id));
4020: hr_utility.trace('input leg_code: ' || iv.legislation_code);
4021: hr_utility.trace('input BG id: ' || to_char(iv.business_group_id));

Line 4018: hr_utility.trace('input el_type_id: ' ||

4014: hr_utility.trace('input_value_id : ' || to_char(p_input_value_id));
4015:
4016: FOR iv IN c_list_ivs(p_input_value_id) LOOP
4017: hr_utility.trace('input name: ' || iv.name);
4018: hr_utility.trace('input el_type_id: ' ||
4019: to_char(iv.element_type_id));
4020: hr_utility.trace('input leg_code: ' || iv.legislation_code);
4021: hr_utility.trace('input BG id: ' || to_char(iv.business_group_id));
4022: hr_utility.trace('input ESD: ' || iv.esd);

Line 4020: hr_utility.trace('input leg_code: ' || iv.legislation_code);

4016: FOR iv IN c_list_ivs(p_input_value_id) LOOP
4017: hr_utility.trace('input name: ' || iv.name);
4018: hr_utility.trace('input el_type_id: ' ||
4019: to_char(iv.element_type_id));
4020: hr_utility.trace('input leg_code: ' || iv.legislation_code);
4021: hr_utility.trace('input BG id: ' || to_char(iv.business_group_id));
4022: hr_utility.trace('input ESD: ' || iv.esd);
4023: hr_utility.trace('input EED: ' || iv.eed);
4024: END LOOP;

Line 4021: hr_utility.trace('input BG id: ' || to_char(iv.business_group_id));

4017: hr_utility.trace('input name: ' || iv.name);
4018: hr_utility.trace('input el_type_id: ' ||
4019: to_char(iv.element_type_id));
4020: hr_utility.trace('input leg_code: ' || iv.legislation_code);
4021: hr_utility.trace('input BG id: ' || to_char(iv.business_group_id));
4022: hr_utility.trace('input ESD: ' || iv.esd);
4023: hr_utility.trace('input EED: ' || iv.eed);
4024: END LOOP;
4025:

Line 4022: hr_utility.trace('input ESD: ' || iv.esd);

4018: hr_utility.trace('input el_type_id: ' ||
4019: to_char(iv.element_type_id));
4020: hr_utility.trace('input leg_code: ' || iv.legislation_code);
4021: hr_utility.trace('input BG id: ' || to_char(iv.business_group_id));
4022: hr_utility.trace('input ESD: ' || iv.esd);
4023: hr_utility.trace('input EED: ' || iv.eed);
4024: END LOOP;
4025:
4026: select distinct element_type_id

Line 4023: hr_utility.trace('input EED: ' || iv.eed);

4019: to_char(iv.element_type_id));
4020: hr_utility.trace('input leg_code: ' || iv.legislation_code);
4021: hr_utility.trace('input BG id: ' || to_char(iv.business_group_id));
4022: hr_utility.trace('input ESD: ' || iv.esd);
4023: hr_utility.trace('input EED: ' || iv.eed);
4024: END LOOP;
4025:
4026: select distinct element_type_id
4027: into l_iv_eltypeid

Line 4033: hr_utility.trace('element name: ' || el.element_name);

4029: where input_value_id = p_input_value_id
4030: and rownum = 1;
4031:
4032: FOR el in c_list_elements(l_iv_eltypeid) LOOP
4033: hr_utility.trace('element name: ' || el.element_name);
4034: hr_utility.trace('element ESD: ' || el.esd);
4035: hr_utility.trace('element EED: ' || el.eed);
4036: hr_utility.trace('element leg_code: ' || el.legislation_code);
4037: hr_utility.trace('element BG id: ' || to_char(el.business_group_id));

Line 4034: hr_utility.trace('element ESD: ' || el.esd);

4030: and rownum = 1;
4031:
4032: FOR el in c_list_elements(l_iv_eltypeid) LOOP
4033: hr_utility.trace('element name: ' || el.element_name);
4034: hr_utility.trace('element ESD: ' || el.esd);
4035: hr_utility.trace('element EED: ' || el.eed);
4036: hr_utility.trace('element leg_code: ' || el.legislation_code);
4037: hr_utility.trace('element BG id: ' || to_char(el.business_group_id));
4038: END LOOP;

Line 4035: hr_utility.trace('element EED: ' || el.eed);

4031:
4032: FOR el in c_list_elements(l_iv_eltypeid) LOOP
4033: hr_utility.trace('element name: ' || el.element_name);
4034: hr_utility.trace('element ESD: ' || el.esd);
4035: hr_utility.trace('element EED: ' || el.eed);
4036: hr_utility.trace('element leg_code: ' || el.legislation_code);
4037: hr_utility.trace('element BG id: ' || to_char(el.business_group_id));
4038: END LOOP;
4039: hrrbdeib_trace_off;

Line 4036: hr_utility.trace('element leg_code: ' || el.legislation_code);

4032: FOR el in c_list_elements(l_iv_eltypeid) LOOP
4033: hr_utility.trace('element name: ' || el.element_name);
4034: hr_utility.trace('element ESD: ' || el.esd);
4035: hr_utility.trace('element EED: ' || el.eed);
4036: hr_utility.trace('element leg_code: ' || el.legislation_code);
4037: hr_utility.trace('element BG id: ' || to_char(el.business_group_id));
4038: END LOOP;
4039: hrrbdeib_trace_off;
4040: raise;

Line 4037: hr_utility.trace('element BG id: ' || to_char(el.business_group_id));

4033: hr_utility.trace('element name: ' || el.element_name);
4034: hr_utility.trace('element ESD: ' || el.esd);
4035: hr_utility.trace('element EED: ' || el.eed);
4036: hr_utility.trace('element leg_code: ' || el.legislation_code);
4037: hr_utility.trace('element BG id: ' || to_char(el.business_group_id));
4038: END LOOP;
4039: hrrbdeib_trace_off;
4040: raise;
4041: END;

Line 4838: hr_utility.trace('entering refresh_el types elements all' ||

4834: --
4835: -- create element types
4836: --
4837: hrrbdeib_trace_on;
4838: hr_utility.trace('entering refresh_el types elements all' ||
4839: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
4840: to_char(p_maxworkers));
4841: hrrbdeib_trace_off;
4842:

Line 4851: hr_utility.trace('RELE:'|| to_char(p_worker_id + 1) || ':' ||

4847: fetch c1 into l_element_type_id,
4848: l_date;
4849: EXIT when c1%notfound;
4850: hrrbdeib_trace_on;
4851: hr_utility.trace('RELE:'|| to_char(p_worker_id + 1) || ':' ||
4852: to_char(l_element_type_id) || '.' ||
4853: to_char(l_date,'DD-MM-YYYY'));
4854: hrrbdeib_trace_off;
4855: create_element_type_dict (l_element_type_id, l_date);

Line 4869: hr_utility.trace('leaving refresh_el types elements all' ||

4865: --
4866: -- create input values
4867: --
4868: hrrbdeib_trace_on;
4869: hr_utility.trace('leaving refresh_el types elements all' ||
4870: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
4871: to_char(p_maxworkers));
4872:
4873: hr_utility.trace('entering refresh_el types ivs all' ||

Line 4873: hr_utility.trace('entering refresh_el types ivs all' ||

4869: hr_utility.trace('leaving refresh_el types elements all' ||
4870: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
4871: to_char(p_maxworkers));
4872:
4873: hr_utility.trace('entering refresh_el types ivs all' ||
4874: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
4875: to_char(p_maxworkers));
4876: hrrbdeib_trace_off;
4877:

Line 4886: hr_utility.trace('RELI:'|| to_char(p_worker_id + 1) || ':' ||

4882: fetch c2 into l_input_value_id,
4883: l_date;
4884: EXIT when c2%notfound;
4885: hrrbdeib_trace_on;
4886: hr_utility.trace('RELI:'|| to_char(p_worker_id + 1) || ':' ||
4887: to_char(l_input_value_id) || '.' ||
4888: to_char(l_date,'DD-MM-YYYY'));
4889: hrrbdeib_trace_off;
4890: create_input_value_dict (l_input_value_id, l_date);

Line 4902: hr_utility.trace('leaving refresh_el types ivs all' ||

4898: end loop;
4899: close c2;
4900:
4901: hrrbdeib_trace_on;
4902: hr_utility.trace('leaving refresh_el types ivs all' ||
4903: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
4904: to_char(p_maxworkers));
4905: hrrbdeib_trace_off;
4906:

Line 4972: hr_utility.trace('entering refresh_el types elements ' || p_leg_code ||

4968: --
4969: -- create element types
4970: --
4971: hrrbdeib_trace_on;
4972: hr_utility.trace('entering refresh_el types elements ' || p_leg_code ||
4973: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
4974: to_char(p_maxworkers));
4975: hrrbdeib_trace_off;
4976:

Line 4985: hr_utility.trace('RELE:'|| to_char(p_worker_id + 1) || ':' ||

4981: fetch c1 into l_element_type_id,
4982: l_date;
4983: EXIT when c1%notfound;
4984: hrrbdeib_trace_on;
4985: hr_utility.trace('RELE:'|| to_char(p_worker_id + 1) || ':' ||
4986: to_char(l_element_type_id) || '.' ||
4987: to_char(l_date,'DD-MM-YYYY'));
4988: hrrbdeib_trace_off;
4989: create_element_type_dict (l_element_type_id, l_date);

Line 5001: hr_utility.trace('leaving refresh_el types elements ' || p_leg_code ||

4997: end loop;
4998: close c1;
4999: --
5000: hrrbdeib_trace_on;
5001: hr_utility.trace('leaving refresh_el types elements ' || p_leg_code ||
5002: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
5003: to_char(p_maxworkers));
5004:
5005: -- create input values

Line 5007: hr_utility.trace('entering refresh_el types ivs ' || p_leg_code ||

5003: to_char(p_maxworkers));
5004:
5005: -- create input values
5006: --
5007: hr_utility.trace('entering refresh_el types ivs ' || p_leg_code ||
5008: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
5009: to_char(p_maxworkers));
5010: hrrbdeib_trace_off;
5011:

Line 5020: hr_utility.trace('RELI:'|| to_char(p_worker_id + 1) || ':' ||

5016: fetch c2 into l_input_value_id,
5017: l_date;
5018: EXIT when c2%notfound;
5019: hrrbdeib_trace_on;
5020: hr_utility.trace('RELI:'|| to_char(p_worker_id + 1) || ':' ||
5021: to_char(l_input_value_id) || '.' ||
5022: to_char(l_date,'DD-MM-YYYY'));
5023: hrrbdeib_trace_off;
5024: create_input_value_dict (l_input_value_id, l_date);

Line 5036: hr_utility.trace('leaving refresh_el types ivs ' || p_leg_code ||

5032: end loop;
5033: close c2;
5034:
5035: hrrbdeib_trace_on;
5036: hr_utility.trace('leaving refresh_el types ivs ' || p_leg_code ||
5037: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
5038: to_char(p_maxworkers));
5039: hrrbdeib_trace_off;
5040:

Line 5168: hr_utility.trace('entering rebuild_ele_input_bal all' ||

5164: from pay_patch_status
5165: where patch_name = 'HRGLOBAL_DEBUG2';
5166:
5167: hrrbdeib_trace_on;
5168: hr_utility.trace('entering rebuild_ele_input_bal all' ||
5169: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
5170: to_char(p_maxworkers));
5171: hrrbdeib_trace_off;
5172:

Line 5181: hr_utility.trace('entering truncate_fcomp_info');

5177: enable_refbal_trig;
5178:
5179: -- Running Core so delete all compiled info and usages
5180: hrrbdeib_trace_on;
5181: hr_utility.trace('entering truncate_fcomp_info');
5182: hrrbdeib_trace_off;
5183:
5184: -- truncate_fcomp_info;
5185:

Line 5187: hr_utility.trace('leaving truncate_fcomp_info');

5183:
5184: -- truncate_fcomp_info;
5185:
5186: hrrbdeib_trace_on;
5187: hr_utility.trace('leaving truncate_fcomp_info');
5188: hrrbdeib_trace_off;
5189:
5190: else
5191: dbms_lock.sleep(5);

Line 5430: hr_utility.trace('leaving rebuild_ele_input_bal all' ||

5426: -- reset global
5427: g_triggers_altered := FALSE;
5428: --
5429: hrrbdeib_trace_on;
5430: hr_utility.trace('leaving rebuild_ele_input_bal all' ||
5431: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
5432: to_char(p_maxworkers));
5433: hrrbdeib_trace_off;
5434: --

Line 5439: hr_utility.trace('exception raised in rebuild_ele_input_bal all' ||

5435: exception
5436: when others then
5437: -- re-enable any disabled triggers
5438: hrrbdeib_trace_on;
5439: hr_utility.trace('exception raised in rebuild_ele_input_bal all' ||
5440: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
5441: to_char(p_maxworkers));
5442: hrrbdeib_trace_off;
5443: insert_mthread_pps_err(p_worker_id, 'ZZ');

Line 5579: hr_utility.trace('entering rebuild_ele_input_bal ' || p_leg_code ||

5575: from pay_patch_status
5576: where patch_name = 'HRGLOBAL_DEBUG2';
5577:
5578: hrrbdeib_trace_on;
5579: hr_utility.trace('entering rebuild_ele_input_bal ' || p_leg_code ||
5580: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
5581: to_char(p_maxworkers));
5582: hrrbdeib_trace_off;
5583: --

Line 5594: hr_utility.trace('entering delete fcomp info: LC: ' || p_leg_code);

5590: --
5591: -- delete legislative formulae usages and compiled info
5592: --
5593: hrrbdeib_trace_on;
5594: hr_utility.trace('entering delete fcomp info: LC: ' || p_leg_code);
5595: hrrbdeib_trace_off;
5596:
5597: /*
5598: open csr_affected_fdiu_rows(p_leg_code => p_leg_code);

Line 5632: hr_utility.trace('leaving delete fcomp info: LC: ' || p_leg_code);

5628: close csr_affected_fdiu_rows;
5629: */
5630:
5631: hrrbdeib_trace_on;
5632: hr_utility.trace('leaving delete fcomp info: LC: ' || p_leg_code);
5633: hrrbdeib_trace_off;
5634:
5635: end if;
5636: --

Line 5859: hr_utility.trace('leaving rebuild_ele_input_bal ' || p_leg_code ||

5855: -- reset global
5856: g_triggers_altered := FALSE;
5857: --
5858: hrrbdeib_trace_on;
5859: hr_utility.trace('leaving rebuild_ele_input_bal ' || p_leg_code ||
5860: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
5861: to_char(p_maxworkers));
5862: hrrbdeib_trace_off;
5863: --

Line 5867: hr_utility.trace('exception in rebuild_ele_input_bal ' || p_leg_code ||

5863: --
5864: exception
5865: when others then
5866: hrrbdeib_trace_on;
5867: hr_utility.trace('exception in rebuild_ele_input_bal ' || p_leg_code ||
5868: ' worker: ' || to_char(p_worker_id + 1) || '/' ||
5869: to_char(p_maxworkers));
5870: hrrbdeib_trace_off;
5871: --

Line 6078: hr_utility.trace ('creating database item grade/ spine rate id: '||

6074: and u.creator_type = 'G');
6075: begin
6076: for c1rec in c1 loop
6077: hrrbdeib_trace_on;
6078: hr_utility.trace ('creating database item grade/ spine rate id: '||
6079: to_char (c1rec.rate_id));
6080: hrrbdeib_trace_off;
6081: create_grade_spine_dict (c1rec.rate_id);
6082: end loop;

Line 6108: hr_utility.trace ('deleting database item grade/ spine rate id: '||

6104: -- delete the grade/ spine rates
6105: --
6106: for c1rec in c1 loop
6107: hrrbdeib_trace_on;
6108: hr_utility.trace ('deleting database item grade/ spine rate id: '||
6109: to_char (c1rec.rate_id));
6110: hrrbdeib_trace_off;
6111: delete_grade_spine_dict (c1rec.rate_id);
6112: end loop;

Line 7265: hr_utility.trace ('creating database item absence type id: '||

7261: from per_absence_attendance_types;
7262: begin
7263: for c1rec in c1 loop
7264: hrrbdeib_trace_on;
7265: hr_utility.trace ('creating database item absence type id: '||
7266: to_char (c1rec.type_id));
7267: hrrbdeib_trace_off;
7268: create_absence_dict (c1rec.type_id);
7269: end loop;

Line 7295: hr_utility.trace ('deleting database item absence type id: '||

7291: -- delete the absence types
7292: --
7293: for c1rec in c1 loop
7294: hrrbdeib_trace_on;
7295: hr_utility.trace ('deleting database item absence type id: '||
7296: to_char (c1rec.type_id));
7297: hrrbdeib_trace_off;
7298: delete_absence_dict (c1rec.type_id);
7299: end loop;

Line 7786: hr_utility.trace ('creating SCL flex entity for '|| p_entity_name);

7782: l_created_by := c1rec.c_created_by;
7783: l_last_login := c1rec.c_last_login;
7784: --
7785: hrrbdeib_trace_on;
7786: hr_utility.trace ('creating SCL flex entity for '|| p_entity_name);
7787: hrrbdeib_trace_off;
7788: insert_user_entity (p_route_name,
7789: p_entity_name,
7790: 'route for SCL level : '|| p_attribute_type,

Line 8192: hr_utility.trace('DBI name clash in (' || p_leg_code || ',' || p_bg_id ||

8188: where context_name = p_user_name
8189: );
8190:
8191: hrrbdeib_trace_on;
8192: hr_utility.trace('DBI name clash in (' || p_leg_code || ',' || p_bg_id ||
8193: ') for ' || p_user_name);
8194: hrrbdeib_trace_off;
8195:
8196: exception

Line 8465: l_debug boolean := hr_utility.debug_enabled;

8461: ;
8462: --
8463: l_balance_name pay_balance_types_tl.balance_name%type;
8464: l_dbi_suffix pay_balance_dimensions_tl.database_item_suffix%type;
8465: l_debug boolean := hr_utility.debug_enabled;
8466: l_found boolean;
8467: begin
8468: open csr_balance_name
8469: (p_balance_type_id => p_balance_type_id

Line 8497: hr_utility.trace('Could not generate _TL DBI for defined balance (' ||

8493: -- later in the processing.
8494: --
8495: p_tl_name := l_balance_name || l_dbi_suffix;
8496: elsif l_debug then
8497: hr_utility.trace('Could not generate _TL DBI for defined balance (' ||
8498: p_balance_type_id || ',' || p_balance_dimension_id ||
8499: ')');
8500: end if;
8501:

Line 8525: l_debug boolean := hr_utility.debug_enabled;

8521: and ettl.language = p_language
8522: ;
8523: --
8524: l_found boolean := true;
8525: l_debug boolean := hr_utility.debug_enabled;
8526: begin
8527: open csr_prefix
8528: (p_element_type_id => p_element_type_id
8529: ,p_language => p_language

Line 8538: hr_utility.trace('Could not generate _TL DBI for element type ' ||

8534: close csr_prefix;
8535:
8536: if not l_found then
8537: if l_debug then
8538: hr_utility.trace('Could not generate _TL DBI for element type ' ||
8539: p_element_type_id);
8540: end if;
8541: end if;
8542:

Line 8588: l_debug boolean := hr_utility.debug_enabled;

8584: l_pay_value pay_input_values_f.name%type := null;
8585: l_ipv_name pay_input_values_f_tl.name%type;
8586: l_ele_name pay_element_types_f_tl.element_name%type;
8587: l_found boolean := true;
8588: l_debug boolean := hr_utility.debug_enabled;
8589: begin
8590: --
8591: -- Check if the input is PAY VALUE.
8592: --

Line 8632: hr_utility.trace('Could not generate _TL DBI for element input value ' ||

8628: if l_found then
8629: p_prefix := l_ele_name || '_' || nvl(l_pay_value, l_ipv_name);
8630: else
8631: if l_debug then
8632: hr_utility.trace('Could not generate _TL DBI for element input value ' ||
8633: p_input_value_id);
8634: end if;
8635: end if;
8636:

Line 8899: hr_utility.trace('TL DBI name clash in (' || p_leg_code || ',' || p_bg_id ||

8895: where context_name = p_tl_user_name
8896: );
8897:
8898: hrrbdeib_trace_on;
8899: hr_utility.trace('TL DBI name clash in (' || p_leg_code || ',' || p_bg_id ||
8900: ') for ' || p_user_name);
8901: hrrbdeib_trace_off;
8902:
8903: exception

Line 8917: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');

8913: ) is
8914: l_debug_cnt number;
8915: begin
8916: if not p_condition then
8917: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');
8918: hr_utility.set_message_token('1', p_location || ':[' || p_extra_info || ']');
8919: hr_utility.raise_error;
8920: end if;
8921: end assert;

Line 8918: hr_utility.set_message_token('1', p_location || ':[' || p_extra_info || ']');

8914: l_debug_cnt number;
8915: begin
8916: if not p_condition then
8917: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');
8918: hr_utility.set_message_token('1', p_location || ':[' || p_extra_info || ']');
8919: hr_utility.raise_error;
8920: end if;
8921: end assert;
8922:

Line 8919: hr_utility.raise_error;

8915: begin
8916: if not p_condition then
8917: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');
8918: hr_utility.set_message_token('1', p_location || ':[' || p_extra_info || ']');
8919: hr_utility.raise_error;
8920: end if;
8921: end assert;
8922:
8923: -- Check for DATE_PAID database items.

Line 9021: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');

9017: else
9018: --
9019: -- For the MLS process, a name clash is a fatal error.
9020: --
9021: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');
9022: hr_utility.set_message_token('1', l_tl_user_name);
9023: hr_utility.raise_error;
9024: end if;
9025: elsif g_dyndbi_changes then

Line 9022: hr_utility.set_message_token('1', l_tl_user_name);

9018: --
9019: -- For the MLS process, a name clash is a fatal error.
9020: --
9021: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');
9022: hr_utility.set_message_token('1', l_tl_user_name);
9023: hr_utility.raise_error;
9024: end if;
9025: elsif g_dyndbi_changes then
9026: l_tl_user_name := p_tl_user_name;

Line 9023: hr_utility.raise_error;

9019: -- For the MLS process, a name clash is a fatal error.
9020: --
9021: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');
9022: hr_utility.set_message_token('1', l_tl_user_name);
9023: hr_utility.raise_error;
9024: end if;
9025: elsif g_dyndbi_changes then
9026: l_tl_user_name := p_tl_user_name;
9027: ff_database_items_pkg.update_seeded_tl_rows

Line 10152: l_debug boolean := hr_utility.debug_enabled;

10148: (p_errors in out nocopy dbms_sql.varchar2_table
10149: ) is
10150: l_dummy varchar2(1);
10151: l_package_name varchar2(1000);
10152: l_debug boolean := hr_utility.debug_enabled;
10153: --
10154: -- Cursor to fetch information on legislations that support translations.
10155: --
10156: cursor csr_fetch_legs is

Line 10174: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS', 5);

10170: and uo.status ='VALID'
10171: ;
10172: begin
10173: if l_debug then
10174: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS', 5);
10175: end if;
10176:
10177: --
10178: -- Loop through the available legislations.

Line 10183: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS:' || crec.legislation_code, 15);

10179: --
10180: for crec in csr_fetch_legs loop
10181:
10182: if l_debug then
10183: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS:' || crec.legislation_code, 15);
10184: end if;
10185: --
10186: -- Build the package name, PAY__DBI_PKG, and only execute .TRANSLATE
10187: -- if it exists.

Line 10197: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS:' || l_package_name || '.TRANSLATE', 25);

10193: into l_dummy
10194: ;
10195: if csr_package_exists%found then
10196: if l_debug then
10197: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS:' || l_package_name || '.TRANSLATE', 25);
10198: end if;
10199:
10200: execute immediate
10201: 'begin '|| l_package_name || '.TRANSLATE; end;';

Line 10212: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS:' || sqlerrm, 30);

10208: close csr_package_exists;
10209: end if;
10210:
10211: if l_debug then
10212: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS:' || sqlerrm, 30);
10213: end if;
10214:
10215: p_errors(p_errors.count + 1) := sqlerrm;
10216: end;

Line 10221: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS', 35);

10217:
10218: end loop;
10219:
10220: if l_debug then
10221: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS', 35);
10222: end if;
10223:
10224: exception
10225: when others then

Line 10228: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS', 45);

10224: exception
10225: when others then
10226:
10227: if l_debug then
10228: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS', 45);
10229: end if;
10230:
10231: p_errors(p_errors.count + 1) := sqlerrm;
10232: end process_leg_translations;

Line 10322: l_debug boolean := hr_utility.debug_enabled;

10318: l_dummy varchar2(1);
10319: l_rowids dbms_sql.varchar2s;
10320: l_messages dbms_sql.varchar2_table;
10321: l_errors dbms_sql.varchar2_table;
10322: l_debug boolean := hr_utility.debug_enabled;
10323: l_newline varchar2(10) := '
10324: ';
10325: l_separator varchar2(100);
10326: --

Line 10378: hr_utility.set_location('process_pay_dyndbi_changes', 0);

10374: g_security_group_id :=
10375: fnd_global.lookup_security_group('NAME_TRANSLATIONS', 3);
10376:
10377: if l_debug then
10378: hr_utility.set_location('process_pay_dyndbi_changes', 0);
10379: end if;
10380:
10381: --
10382: -- Set log file message separator.

Line 10392: hr_utility.set_location('process_pay_dyndbi_changes', 10);

10388: -- ============== --
10389: if upper(p_element_types) = 'Y' then
10390:
10391: if l_debug then
10392: hr_utility.set_location('process_pay_dyndbi_changes', 10);
10393: end if;
10394:
10395: --
10396: -- Initialise everything.

Line 10412: hr_utility.set_location('process_pay_dyndbi_changes', 20);

10408: ,p_languages => l_languages
10409: );
10410:
10411: if l_debug then
10412: hr_utility.set_location('process_pay_dyndbi_changes', 20);
10413: end if;
10414:
10415: --
10416: -- Do the updates.

Line 10423: hr_utility.set_location('process_pay_dyndbi_changes', 30);

10419:
10420: while l_ids.exists(i) loop
10421:
10422: if l_debug then
10423: hr_utility.set_location('process_pay_dyndbi_changes', 30);
10424: end if;
10425:
10426: l_id_langs.delete;
10427: next_dyndbi_change

Line 10446: hr_utility.set_location('process_pay_dyndbi_changes', 40);

10442: l_found := csr_ele_eff_date%found;
10443: close csr_ele_eff_date;
10444:
10445: if l_debug then
10446: hr_utility.set_location('process_pay_dyndbi_changes', 40);
10447: end if;
10448:
10449: g_dyndbi_changes_ok := true;
10450: if l_found then

Line 10453: hr_utility.set_location('process_pay_dyndbi_changes', 50);

10449: g_dyndbi_changes_ok := true;
10450: if l_found then
10451:
10452: if l_debug then
10453: hr_utility.set_location('process_pay_dyndbi_changes', 50);
10454: end if;
10455:
10456: begin
10457: update_element_type

Line 10472: hr_utility.set_location('process_pay_dyndbi_changes', 60);

10468: retcode := 2;
10469: end;
10470:
10471: if l_debug then
10472: hr_utility.set_location('process_pay_dyndbi_changes', 60);
10473: end if;
10474: else
10475: hr_utility.trace(l_proc||'no such element '||l_id);
10476: end if;

Line 10475: hr_utility.trace(l_proc||'no such element '||l_id);

10471: if l_debug then
10472: hr_utility.set_location('process_pay_dyndbi_changes', 60);
10473: end if;
10474: else
10475: hr_utility.trace(l_proc||'no such element '||l_id);
10476: end if;
10477:
10478: if l_debug then
10479: hr_utility.set_location('process_pay_dyndbi_changes', 70);

Line 10479: hr_utility.set_location('process_pay_dyndbi_changes', 70);

10475: hr_utility.trace(l_proc||'no such element '||l_id);
10476: end if;
10477:
10478: if l_debug then
10479: hr_utility.set_location('process_pay_dyndbi_changes', 70);
10480: end if;
10481:
10482: --
10483: -- Delete the PAY_DYNDBI_CHANGES rows.

Line 10493: hr_utility.set_location('process_pay_dyndbi_changes', 80);

10489: );
10490: end if;
10491:
10492: if l_debug then
10493: hr_utility.set_location('process_pay_dyndbi_changes', 80);
10494: end if;
10495:
10496: incr_cnt(p_cnt => l_cnt);
10497: end loop;

Line 10506: hr_utility.set_location('process_pay_dyndbi_changes', 90);

10502: commit;
10503: end if;
10504:
10505: if l_debug then
10506: hr_utility.set_location('process_pay_dyndbi_changes', 90);
10507: end if;
10508:
10509: -- ============= --
10510: -- Input Values. --

Line 10515: hr_utility.set_location('process_pay_dyndbi_changes', 100);

10511: -- ============= --
10512: if upper(p_input_values) = 'Y' then
10513:
10514: if l_debug then
10515: hr_utility.set_location('process_pay_dyndbi_changes', 100);
10516: end if;
10517:
10518: --
10519: -- Initialise everything.

Line 10535: hr_utility.set_location('process_pay_dyndbi_changes', 110);

10531: ,p_languages => l_languages
10532: );
10533:
10534: if l_debug then
10535: hr_utility.set_location('process_pay_dyndbi_changes', 110);
10536: end if;
10537:
10538: --
10539: -- Do the updates.

Line 10546: hr_utility.set_location('process_pay_dyndbi_changes', 120);

10542:
10543: while l_ids.exists(i) loop
10544:
10545: if l_debug then
10546: hr_utility.set_location('process_pay_dyndbi_changes', 120);
10547: end if;
10548:
10549: l_id_langs.delete;
10550: next_dyndbi_change

Line 10569: hr_utility.set_location('process_pay_dyndbi_changes', 130);

10565: l_found := csr_ipv_eff_date%found;
10566: close csr_ipv_eff_date;
10567:
10568: if l_debug then
10569: hr_utility.set_location('process_pay_dyndbi_changes', 130);
10570: end if;
10571:
10572: g_dyndbi_changes_ok := true;
10573: if l_found then

Line 10589: hr_utility.trace(l_proc||'no such input value '||l_id);

10585: errbuf := sqlerrm;
10586: retcode := 2;
10587: end;
10588: else
10589: hr_utility.trace(l_proc||'no such input value '||l_id);
10590: end if;
10591:
10592: if l_debug then
10593: hr_utility.set_location('process_pay_dyndbi_changes', 140);

Line 10593: hr_utility.set_location('process_pay_dyndbi_changes', 140);

10589: hr_utility.trace(l_proc||'no such input value '||l_id);
10590: end if;
10591:
10592: if l_debug then
10593: hr_utility.set_location('process_pay_dyndbi_changes', 140);
10594: end if;
10595:
10596: --
10597: -- Delete the PAY_DYNDBI_CHANGES rows.

Line 10607: hr_utility.set_location('process_pay_dyndbi_changes', 150);

10603: );
10604: end if;
10605:
10606: if l_debug then
10607: hr_utility.set_location('process_pay_dyndbi_changes', 150);
10608: end if;
10609:
10610: incr_cnt(p_cnt => l_cnt);
10611: end loop;

Line 10620: hr_utility.set_location('process_pay_dyndbi_changes', 160);

10616: commit;
10617: end if;
10618:
10619: if l_debug then
10620: hr_utility.set_location('process_pay_dyndbi_changes', 160);
10621: end if;
10622:
10623: -- ================= --
10624: -- Defined Balances. --

Line 10629: hr_utility.set_location('process_pay_dyndbi_changes', 170);

10625: -- ================= --
10626: if upper(p_defined_balances) = 'Y' then
10627:
10628: if l_debug then
10629: hr_utility.set_location('process_pay_dyndbi_changes', 170);
10630: end if;
10631:
10632: --
10633: -- Initialise everything.

Line 10649: hr_utility.set_location('process_pay_dyndbi_changes', 180);

10645: ,p_languages => l_languages
10646: );
10647:
10648: if l_debug then
10649: hr_utility.set_location('process_pay_dyndbi_changes', 180);
10650: end if;
10651:
10652: --
10653: -- Do the updates.

Line 10660: hr_utility.set_location('process_pay_dyndbi_changes', 190);

10656:
10657: while l_ids.exists(i) loop
10658:
10659: if l_debug then
10660: hr_utility.set_location('process_pay_dyndbi_changes', 190);
10661: end if;
10662:
10663: l_id_langs.delete;
10664: next_dyndbi_change

Line 10680: hr_utility.set_location('process_pay_dyndbi_changes', 200);

10676: l_found := csr_def_balance%found;
10677: close csr_def_balance;
10678:
10679: if l_debug then
10680: hr_utility.set_location('process_pay_dyndbi_changes', 200);
10681: end if;
10682:
10683: g_dyndbi_changes_ok := true;
10684: if l_found then

Line 10687: hr_utility.set_location('process_pay_dyndbi_changes', 210);

10683: g_dyndbi_changes_ok := true;
10684: if l_found then
10685:
10686: if l_debug then
10687: hr_utility.set_location('process_pay_dyndbi_changes', 210);
10688: end if;
10689:
10690: begin
10691: update_defined_balance

Line 10704: hr_utility.trace(l_proc||'no defined balance '||l_id);

10700: errbuf := sqlerrm;
10701: retcode := 2;
10702: end;
10703: else
10704: hr_utility.trace(l_proc||'no defined balance '||l_id);
10705: end if;
10706:
10707: --
10708: -- Delete the PAY_DYNDBI_CHANGES rows.

Line 10718: hr_utility.set_location('process_pay_dyndbi_changes', 220);

10714: );
10715: end if;
10716:
10717: if l_debug then
10718: hr_utility.set_location('process_pay_dyndbi_changes', 220);
10719: end if;
10720:
10721: incr_cnt(p_cnt => l_cnt);
10722: end loop;

Line 10731: hr_utility.set_location('process_pay_dyndbi_changes', 230);

10727: commit;
10728: end if;
10729:
10730: if l_debug then
10731: hr_utility.set_location('process_pay_dyndbi_changes', 230);
10732: end if;
10733:
10734: --
10735: -- Do the legislation-specfic changes.

Line 10740: hr_utility.set_location('process_pay_dyndbi_changes', 235);

10736: --
10737: if upper(p_localization) = 'Y' then
10738:
10739: if l_debug then
10740: hr_utility.set_location('process_pay_dyndbi_changes', 235);
10741: end if;
10742:
10743: process_leg_translations(p_errors => l_errors);
10744: for i in 1 .. l_errors.count loop

Line 10759: hr_utility.set_location('process_pay_dyndbi_changes', 240);

10755: ,p_messages => l_messages
10756: );
10757:
10758: if l_debug then
10759: hr_utility.set_location('process_pay_dyndbi_changes', 240);
10760: end if;
10761:
10762: --
10763: -- Set error status if there are any error messages.

Line 10792: hr_utility.set_location('process_pay_dyndbi_changes', 250);

10788:
10789: g_dyndbi_changes := false;
10790:
10791: if l_debug then
10792: hr_utility.set_location('process_pay_dyndbi_changes', 250);
10793: end if;
10794:
10795: commit; /*Bug 8512762 Added commit as FND is not commiting if status is error (retcode =2 )*/
10796:

Line 10804: hr_utility.set_location('process_pay_dyndbi_changes', 300);

10800: errbuf := sqlerrm;
10801: retcode := 2;
10802:
10803: if l_debug then
10804: hr_utility.set_location('process_pay_dyndbi_changes', 300);
10805: end if;
10806: end process_pay_dyndbi_changes;
10807:
10808: end hrdyndbi;