APPS.HRDYNDBI dependencies on HR_UTILITY

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

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

Line 747: hr_utility.trace_off;

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

Line 872: when hr_utility.hr_error then

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

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

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

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

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

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

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

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

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

Line 879: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1197: hr_utility.raise_error;

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

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

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

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

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

Line 1220: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 1418: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2305: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2552: when hr_utility.hr_error then

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

Line 2576: when hr_utility.hr_error then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5180:
5181: -- truncate_fcomp_info;
5182:
5183: hrrbdeib_trace_on;
5184: hr_utility.trace('leaving truncate_fcomp_info');
5185: hrrbdeib_trace_off;
5186:
5187: else
5188: dbms_lock.sleep(5);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

7184: from per_absence_attendance_types;
7185: begin
7186: for c1rec in c1 loop
7187: hrrbdeib_trace_on;
7188: hr_utility.trace ('creating database item absence type id: '||
7189: to_char (c1rec.type_id));
7190: hrrbdeib_trace_off;
7191: create_absence_dict (c1rec.type_id);
7192: end loop;

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

7214: -- delete the absence types
7215: --
7216: for c1rec in c1 loop
7217: hrrbdeib_trace_on;
7218: hr_utility.trace ('deleting database item absence type id: '||
7219: to_char (c1rec.type_id));
7220: hrrbdeib_trace_off;
7221: delete_absence_dict (c1rec.type_id);
7222: end loop;

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

7705: l_created_by := c1rec.c_created_by;
7706: l_last_login := c1rec.c_last_login;
7707: --
7708: hrrbdeib_trace_on;
7709: hr_utility.trace ('creating SCL flex entity for '|| p_entity_name);
7710: hrrbdeib_trace_off;
7711: insert_user_entity (p_route_name,
7712: p_entity_name,
7713: 'route for SCL level : '|| p_attribute_type,

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

8111: where context_name = p_user_name
8112: );
8113:
8114: hrrbdeib_trace_on;
8115: hr_utility.trace('DBI name clash in (' || p_leg_code || ',' || p_bg_id ||
8116: ') for ' || p_user_name);
8117: hrrbdeib_trace_off;
8118:
8119: exception

Line 8388: l_debug boolean := hr_utility.debug_enabled;

8384: ;
8385: --
8386: l_balance_name pay_balance_types_tl.balance_name%type;
8387: l_dbi_suffix pay_balance_dimensions_tl.database_item_suffix%type;
8388: l_debug boolean := hr_utility.debug_enabled;
8389: l_found boolean;
8390: begin
8391: open csr_balance_name
8392: (p_balance_type_id => p_balance_type_id

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

8416: -- later in the processing.
8417: --
8418: p_tl_name := l_balance_name || l_dbi_suffix;
8419: elsif l_debug then
8420: hr_utility.trace('Could not generate _TL DBI for defined balance (' ||
8421: p_balance_type_id || ',' || p_balance_dimension_id ||
8422: ')');
8423: end if;
8424:

Line 8448: l_debug boolean := hr_utility.debug_enabled;

8444: and ettl.language = p_language
8445: ;
8446: --
8447: l_found boolean := true;
8448: l_debug boolean := hr_utility.debug_enabled;
8449: begin
8450: open csr_prefix
8451: (p_element_type_id => p_element_type_id
8452: ,p_language => p_language

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

8457: close csr_prefix;
8458:
8459: if not l_found then
8460: if l_debug then
8461: hr_utility.trace('Could not generate _TL DBI for element type ' ||
8462: p_element_type_id);
8463: end if;
8464: end if;
8465:

Line 8511: l_debug boolean := hr_utility.debug_enabled;

8507: l_pay_value pay_input_values_f.name%type := null;
8508: l_ipv_name pay_input_values_f_tl.name%type;
8509: l_ele_name pay_element_types_f_tl.element_name%type;
8510: l_found boolean := true;
8511: l_debug boolean := hr_utility.debug_enabled;
8512: begin
8513: --
8514: -- Check if the input is PAY VALUE.
8515: --

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

8551: if l_found then
8552: p_prefix := l_ele_name || '_' || nvl(l_pay_value, l_ipv_name);
8553: else
8554: if l_debug then
8555: hr_utility.trace('Could not generate _TL DBI for element input value ' ||
8556: p_input_value_id);
8557: end if;
8558: end if;
8559:

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

8818: where context_name = p_tl_user_name
8819: );
8820:
8821: hrrbdeib_trace_on;
8822: hr_utility.trace('TL DBI name clash in (' || p_leg_code || ',' || p_bg_id ||
8823: ') for ' || p_user_name);
8824: hrrbdeib_trace_off;
8825:
8826: exception

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

8836: ) is
8837: l_debug_cnt number;
8838: begin
8839: if not p_condition then
8840: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');
8841: hr_utility.set_message_token('1', p_location || ':[' || p_extra_info || ']');
8842: hr_utility.raise_error;
8843: end if;
8844: end assert;

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

8837: l_debug_cnt number;
8838: begin
8839: if not p_condition then
8840: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');
8841: hr_utility.set_message_token('1', p_location || ':[' || p_extra_info || ']');
8842: hr_utility.raise_error;
8843: end if;
8844: end assert;
8845:

Line 8842: hr_utility.raise_error;

8838: begin
8839: if not p_condition then
8840: hr_utility.set_message(801, 'FFPLU01_ASSERTION_FAILED');
8841: hr_utility.set_message_token('1', p_location || ':[' || p_extra_info || ']');
8842: hr_utility.raise_error;
8843: end if;
8844: end assert;
8845:
8846: -- Check for DATE_PAID database items.

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

8940: else
8941: --
8942: -- For the MLS process, a name clash is a fatal error.
8943: --
8944: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');
8945: hr_utility.set_message_token('1', l_tl_user_name);
8946: hr_utility.raise_error;
8947: end if;
8948: elsif g_dyndbi_changes then

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

8941: --
8942: -- For the MLS process, a name clash is a fatal error.
8943: --
8944: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');
8945: hr_utility.set_message_token('1', l_tl_user_name);
8946: hr_utility.raise_error;
8947: end if;
8948: elsif g_dyndbi_changes then
8949: l_tl_user_name := p_tl_user_name;

Line 8946: hr_utility.raise_error;

8942: -- For the MLS process, a name clash is a fatal error.
8943: --
8944: hr_utility.set_message (801, 'PAY_33916_DYN_DBI_NAME_CLASH');
8945: hr_utility.set_message_token('1', l_tl_user_name);
8946: hr_utility.raise_error;
8947: end if;
8948: elsif g_dyndbi_changes then
8949: l_tl_user_name := p_tl_user_name;
8950: ff_database_items_pkg.update_seeded_tl_rows

Line 10075: l_debug boolean := hr_utility.debug_enabled;

10071: (p_errors in out nocopy dbms_sql.varchar2_table
10072: ) is
10073: l_dummy varchar2(1);
10074: l_package_name varchar2(1000);
10075: l_debug boolean := hr_utility.debug_enabled;
10076: --
10077: -- Cursor to fetch information on legislations that support translations.
10078: --
10079: cursor csr_fetch_legs is

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

10093: and uo.status ='VALID'
10094: ;
10095: begin
10096: if l_debug then
10097: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS', 5);
10098: end if;
10099:
10100: --
10101: -- Loop through the available legislations.

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

10102: --
10103: for crec in csr_fetch_legs loop
10104:
10105: if l_debug then
10106: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS:' || crec.legislation_code, 15);
10107: end if;
10108: --
10109: -- Build the package name, PAY__DBI_PKG, and only execute .TRANSLATE
10110: -- if it exists.

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

10116: into l_dummy
10117: ;
10118: if csr_package_exists%found then
10119: if l_debug then
10120: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS:' || l_package_name || '.TRANSLATE', 25);
10121: end if;
10122:
10123: execute immediate
10124: 'begin '|| l_package_name || '.TRANSLATE; end;';

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

10131: close csr_package_exists;
10132: end if;
10133:
10134: if l_debug then
10135: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS:' || sqlerrm, 30);
10136: end if;
10137:
10138: p_errors(p_errors.count + 1) := sqlerrm;
10139: end;

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

10140:
10141: end loop;
10142:
10143: if l_debug then
10144: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS', 35);
10145: end if;
10146:
10147: exception
10148: when others then

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

10147: exception
10148: when others then
10149:
10150: if l_debug then
10151: hr_utility.set_location('PROCESS_LEG_TRANSLATIONS', 45);
10152: end if;
10153:
10154: p_errors(p_errors.count + 1) := sqlerrm;
10155: end process_leg_translations;

Line 10245: l_debug boolean := hr_utility.debug_enabled;

10241: l_dummy varchar2(1);
10242: l_rowids dbms_sql.varchar2s;
10243: l_messages dbms_sql.varchar2_table;
10244: l_errors dbms_sql.varchar2_table;
10245: l_debug boolean := hr_utility.debug_enabled;
10246: l_newline varchar2(10) := '
10247: ';
10248: l_separator varchar2(100);
10249: --

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

10297: g_security_group_id :=
10298: fnd_global.lookup_security_group('NAME_TRANSLATIONS', 3);
10299:
10300: if l_debug then
10301: hr_utility.set_location('process_pay_dyndbi_changes', 0);
10302: end if;
10303:
10304: --
10305: -- Set log file message separator.

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

10311: -- ============== --
10312: if upper(p_element_types) = 'Y' then
10313:
10314: if l_debug then
10315: hr_utility.set_location('process_pay_dyndbi_changes', 10);
10316: end if;
10317:
10318: --
10319: -- Initialise everything.

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

10331: ,p_languages => l_languages
10332: );
10333:
10334: if l_debug then
10335: hr_utility.set_location('process_pay_dyndbi_changes', 20);
10336: end if;
10337:
10338: --
10339: -- Do the updates.

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

10342:
10343: while l_ids.exists(i) loop
10344:
10345: if l_debug then
10346: hr_utility.set_location('process_pay_dyndbi_changes', 30);
10347: end if;
10348:
10349: l_id_langs.delete;
10350: next_dyndbi_change

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

10365: l_found := csr_ele_eff_date%found;
10366: close csr_ele_eff_date;
10367:
10368: if l_debug then
10369: hr_utility.set_location('process_pay_dyndbi_changes', 40);
10370: end if;
10371:
10372: g_dyndbi_changes_ok := true;
10373: if l_found then

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

10372: g_dyndbi_changes_ok := true;
10373: if l_found then
10374:
10375: if l_debug then
10376: hr_utility.set_location('process_pay_dyndbi_changes', 50);
10377: end if;
10378:
10379: begin
10380: update_element_type

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

10391: retcode := 2;
10392: end;
10393:
10394: if l_debug then
10395: hr_utility.set_location('process_pay_dyndbi_changes', 60);
10396: end if;
10397: else
10398: hr_utility.trace(l_proc||'no such element '||l_id);
10399: end if;

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

10394: if l_debug then
10395: hr_utility.set_location('process_pay_dyndbi_changes', 60);
10396: end if;
10397: else
10398: hr_utility.trace(l_proc||'no such element '||l_id);
10399: end if;
10400:
10401: if l_debug then
10402: hr_utility.set_location('process_pay_dyndbi_changes', 70);

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

10398: hr_utility.trace(l_proc||'no such element '||l_id);
10399: end if;
10400:
10401: if l_debug then
10402: hr_utility.set_location('process_pay_dyndbi_changes', 70);
10403: end if;
10404:
10405: --
10406: -- Delete the PAY_DYNDBI_CHANGES rows.

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

10412: );
10413: end if;
10414:
10415: if l_debug then
10416: hr_utility.set_location('process_pay_dyndbi_changes', 80);
10417: end if;
10418:
10419: incr_cnt(p_cnt => l_cnt);
10420: end loop;

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

10425: commit;
10426: end if;
10427:
10428: if l_debug then
10429: hr_utility.set_location('process_pay_dyndbi_changes', 90);
10430: end if;
10431:
10432: -- ============= --
10433: -- Input Values. --

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

10434: -- ============= --
10435: if upper(p_input_values) = 'Y' then
10436:
10437: if l_debug then
10438: hr_utility.set_location('process_pay_dyndbi_changes', 100);
10439: end if;
10440:
10441: --
10442: -- Initialise everything.

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

10454: ,p_languages => l_languages
10455: );
10456:
10457: if l_debug then
10458: hr_utility.set_location('process_pay_dyndbi_changes', 110);
10459: end if;
10460:
10461: --
10462: -- Do the updates.

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

10465:
10466: while l_ids.exists(i) loop
10467:
10468: if l_debug then
10469: hr_utility.set_location('process_pay_dyndbi_changes', 120);
10470: end if;
10471:
10472: l_id_langs.delete;
10473: next_dyndbi_change

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

10488: l_found := csr_ipv_eff_date%found;
10489: close csr_ipv_eff_date;
10490:
10491: if l_debug then
10492: hr_utility.set_location('process_pay_dyndbi_changes', 130);
10493: end if;
10494:
10495: g_dyndbi_changes_ok := true;
10496: if l_found then

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

10508: errbuf := sqlerrm;
10509: retcode := 2;
10510: end;
10511: else
10512: hr_utility.trace(l_proc||'no such input value '||l_id);
10513: end if;
10514:
10515: if l_debug then
10516: hr_utility.set_location('process_pay_dyndbi_changes', 140);

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

10512: hr_utility.trace(l_proc||'no such input value '||l_id);
10513: end if;
10514:
10515: if l_debug then
10516: hr_utility.set_location('process_pay_dyndbi_changes', 140);
10517: end if;
10518:
10519: --
10520: -- Delete the PAY_DYNDBI_CHANGES rows.

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

10526: );
10527: end if;
10528:
10529: if l_debug then
10530: hr_utility.set_location('process_pay_dyndbi_changes', 150);
10531: end if;
10532:
10533: incr_cnt(p_cnt => l_cnt);
10534: end loop;

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

10539: commit;
10540: end if;
10541:
10542: if l_debug then
10543: hr_utility.set_location('process_pay_dyndbi_changes', 160);
10544: end if;
10545:
10546: -- ================= --
10547: -- Defined Balances. --

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

10548: -- ================= --
10549: if upper(p_defined_balances) = 'Y' then
10550:
10551: if l_debug then
10552: hr_utility.set_location('process_pay_dyndbi_changes', 170);
10553: end if;
10554:
10555: --
10556: -- Initialise everything.

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

10568: ,p_languages => l_languages
10569: );
10570:
10571: if l_debug then
10572: hr_utility.set_location('process_pay_dyndbi_changes', 180);
10573: end if;
10574:
10575: --
10576: -- Do the updates.

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

10579:
10580: while l_ids.exists(i) loop
10581:
10582: if l_debug then
10583: hr_utility.set_location('process_pay_dyndbi_changes', 190);
10584: end if;
10585:
10586: l_id_langs.delete;
10587: next_dyndbi_change

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

10599: l_found := csr_def_balance%found;
10600: close csr_def_balance;
10601:
10602: if l_debug then
10603: hr_utility.set_location('process_pay_dyndbi_changes', 200);
10604: end if;
10605:
10606: g_dyndbi_changes_ok := true;
10607: if l_found then

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

10606: g_dyndbi_changes_ok := true;
10607: if l_found then
10608:
10609: if l_debug then
10610: hr_utility.set_location('process_pay_dyndbi_changes', 210);
10611: end if;
10612:
10613: begin
10614: update_defined_balance

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

10623: errbuf := sqlerrm;
10624: retcode := 2;
10625: end;
10626: else
10627: hr_utility.trace(l_proc||'no defined balance '||l_id);
10628: end if;
10629:
10630: --
10631: -- Delete the PAY_DYNDBI_CHANGES rows.

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

10637: );
10638: end if;
10639:
10640: if l_debug then
10641: hr_utility.set_location('process_pay_dyndbi_changes', 220);
10642: end if;
10643:
10644: incr_cnt(p_cnt => l_cnt);
10645: end loop;

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

10650: commit;
10651: end if;
10652:
10653: if l_debug then
10654: hr_utility.set_location('process_pay_dyndbi_changes', 230);
10655: end if;
10656:
10657: --
10658: -- Do the legislation-specfic changes.

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

10659: --
10660: if upper(p_localization) = 'Y' then
10661:
10662: if l_debug then
10663: hr_utility.set_location('process_pay_dyndbi_changes', 235);
10664: end if;
10665:
10666: process_leg_translations(p_errors => l_errors);
10667: for i in 1 .. l_errors.count loop

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

10678: ,p_messages => l_messages
10679: );
10680:
10681: if l_debug then
10682: hr_utility.set_location('process_pay_dyndbi_changes', 240);
10683: end if;
10684:
10685: --
10686: -- Set error status if there are any error messages.

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

10711:
10712: g_dyndbi_changes := false;
10713:
10714: if l_debug then
10715: hr_utility.set_location('process_pay_dyndbi_changes', 250);
10716: end if;
10717:
10718: exception
10719: when others then

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

10721: errbuf := sqlerrm;
10722: retcode := 2;
10723:
10724: if l_debug then
10725: hr_utility.set_location('process_pay_dyndbi_changes', 300);
10726: end if;
10727: end process_pay_dyndbi_changes;
10728:
10729: end hrdyndbi;