eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LEGISLATION dependencies on HR_UTILITY

Line 404: hr_utility.trace_on(null, 'HRRUNPRC');

400:
401: PROCEDURE hrrunprc_trace_on is
402: begin
403: if hr_legislation.g_debug_cnt > 0 then
404: hr_utility.trace_on(null, 'HRRUNPRC');
405: end if;
406: end;
407:
408: PROCEDURE hrrunprc_trace_off is

Line 411: hr_utility.trace_off;

407:
408: PROCEDURE hrrunprc_trace_off is
409: begin
410: if hr_legislation.g_debug_cnt > 0 then
411: hr_utility.trace_off;
412: end if;
413: end;
414:
415: FUNCTION get_pseudo_enabled RETURN VARCHAR2 IS

Line 550: hr_utility.set_location ('Entering pseudo_seed_data_clash',10);

546:
547: l_table_name := p_table_name;
548:
549: if p_trace is not null then
550: hr_utility.set_location ('Entering pseudo_seed_data_clash',10);
551: hr_utility.set_location('P_SURROGATE_KEY_NAME'||P_SURROGATE_KEY_NAME,10);
552: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME1 '||P_ADDL_SURROGATE_KEY_NAME1,10);
553: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME2 '||P_ADDL_SURROGATE_KEY_NAME2,10);
554: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 551: hr_utility.set_location('P_SURROGATE_KEY_NAME'||P_SURROGATE_KEY_NAME,10);

547: l_table_name := p_table_name;
548:
549: if p_trace is not null then
550: hr_utility.set_location ('Entering pseudo_seed_data_clash',10);
551: hr_utility.set_location('P_SURROGATE_KEY_NAME'||P_SURROGATE_KEY_NAME,10);
552: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME1 '||P_ADDL_SURROGATE_KEY_NAME1,10);
553: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME2 '||P_ADDL_SURROGATE_KEY_NAME2,10);
554: hr_utility.set_location('p_effective_date '||p_effective_date,10);
555: end if;

Line 552: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME1 '||P_ADDL_SURROGATE_KEY_NAME1,10);

548:
549: if p_trace is not null then
550: hr_utility.set_location ('Entering pseudo_seed_data_clash',10);
551: hr_utility.set_location('P_SURROGATE_KEY_NAME'||P_SURROGATE_KEY_NAME,10);
552: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME1 '||P_ADDL_SURROGATE_KEY_NAME1,10);
553: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME2 '||P_ADDL_SURROGATE_KEY_NAME2,10);
554: hr_utility.set_location('p_effective_date '||p_effective_date,10);
555: end if;
556:

Line 553: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME2 '||P_ADDL_SURROGATE_KEY_NAME2,10);

549: if p_trace is not null then
550: hr_utility.set_location ('Entering pseudo_seed_data_clash',10);
551: hr_utility.set_location('P_SURROGATE_KEY_NAME'||P_SURROGATE_KEY_NAME,10);
552: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME1 '||P_ADDL_SURROGATE_KEY_NAME1,10);
553: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME2 '||P_ADDL_SURROGATE_KEY_NAME2,10);
554: hr_utility.set_location('p_effective_date '||p_effective_date,10);
555: end if;
556:
557: if l_table_name = 'PAY_ELEMENT_TYPES_F' then

Line 554: hr_utility.set_location('p_effective_date '||p_effective_date,10);

550: hr_utility.set_location ('Entering pseudo_seed_data_clash',10);
551: hr_utility.set_location('P_SURROGATE_KEY_NAME'||P_SURROGATE_KEY_NAME,10);
552: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME1 '||P_ADDL_SURROGATE_KEY_NAME1,10);
553: hr_utility.set_location('P_ADDL_SURROGATE_KEY_NAME2 '||P_ADDL_SURROGATE_KEY_NAME2,10);
554: hr_utility.set_location('p_effective_date '||p_effective_date,10);
555: end if;
556:
557: if l_table_name = 'PAY_ELEMENT_TYPES_F' then
558:

Line 691: hr_utility.trace('Error loading pseudo data ');

687:
688: if v_exists = 'Y' then
689:
690: if p_trace is not null then
691: hr_utility.trace('Error loading pseudo data ');
692: hr_utility.trace( 'pseudo Key type :'||l_table_name);
693: hr_utility.trace( 'pseudo Key Name :'||P_SURROGATE_KEY_NAME);
694: hr_utility.trace( 'pseudo Sub Key :'||P_ADDL_SURROGATE_KEY_NAME1);
695: hr_utility.trace( 'pseudo Sub Key2 :'||P_ADDL_SURROGATE_KEY_NAME2);

Line 692: hr_utility.trace( 'pseudo Key type :'||l_table_name);

688: if v_exists = 'Y' then
689:
690: if p_trace is not null then
691: hr_utility.trace('Error loading pseudo data ');
692: hr_utility.trace( 'pseudo Key type :'||l_table_name);
693: hr_utility.trace( 'pseudo Key Name :'||P_SURROGATE_KEY_NAME);
694: hr_utility.trace( 'pseudo Sub Key :'||P_ADDL_SURROGATE_KEY_NAME1);
695: hr_utility.trace( 'pseudo Sub Key2 :'||P_ADDL_SURROGATE_KEY_NAME2);
696: end if;

Line 693: hr_utility.trace( 'pseudo Key Name :'||P_SURROGATE_KEY_NAME);

689:
690: if p_trace is not null then
691: hr_utility.trace('Error loading pseudo data ');
692: hr_utility.trace( 'pseudo Key type :'||l_table_name);
693: hr_utility.trace( 'pseudo Key Name :'||P_SURROGATE_KEY_NAME);
694: hr_utility.trace( 'pseudo Sub Key :'||P_ADDL_SURROGATE_KEY_NAME1);
695: hr_utility.trace( 'pseudo Sub Key2 :'||P_ADDL_SURROGATE_KEY_NAME2);
696: end if;
697:

Line 694: hr_utility.trace( 'pseudo Sub Key :'||P_ADDL_SURROGATE_KEY_NAME1);

690: if p_trace is not null then
691: hr_utility.trace('Error loading pseudo data ');
692: hr_utility.trace( 'pseudo Key type :'||l_table_name);
693: hr_utility.trace( 'pseudo Key Name :'||P_SURROGATE_KEY_NAME);
694: hr_utility.trace( 'pseudo Sub Key :'||P_ADDL_SURROGATE_KEY_NAME1);
695: hr_utility.trace( 'pseudo Sub Key2 :'||P_ADDL_SURROGATE_KEY_NAME2);
696: end if;
697:
698: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 695: hr_utility.trace( 'pseudo Sub Key2 :'||P_ADDL_SURROGATE_KEY_NAME2);

691: hr_utility.trace('Error loading pseudo data ');
692: hr_utility.trace( 'pseudo Key type :'||l_table_name);
693: hr_utility.trace( 'pseudo Key Name :'||P_SURROGATE_KEY_NAME);
694: hr_utility.trace( 'pseudo Sub Key :'||P_ADDL_SURROGATE_KEY_NAME1);
695: hr_utility.trace( 'pseudo Sub Key2 :'||P_ADDL_SURROGATE_KEY_NAME2);
696: end if;
697:
698: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
699: hr_utility.set_message_token('PROCEDURE','PSEUDO_SEED_DATA_CLASH');

Line 698: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

694: hr_utility.trace( 'pseudo Sub Key :'||P_ADDL_SURROGATE_KEY_NAME1);
695: hr_utility.trace( 'pseudo Sub Key2 :'||P_ADDL_SURROGATE_KEY_NAME2);
696: end if;
697:
698: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
699: hr_utility.set_message_token('PROCEDURE','PSEUDO_SEED_DATA_CLASH');
700: hr_utility.set_message_token('STEP',l_table_name);
701: hr_utility.raise_error;
702:

Line 699: hr_utility.set_message_token('PROCEDURE','PSEUDO_SEED_DATA_CLASH');

695: hr_utility.trace( 'pseudo Sub Key2 :'||P_ADDL_SURROGATE_KEY_NAME2);
696: end if;
697:
698: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
699: hr_utility.set_message_token('PROCEDURE','PSEUDO_SEED_DATA_CLASH');
700: hr_utility.set_message_token('STEP',l_table_name);
701: hr_utility.raise_error;
702:
703: else

Line 700: hr_utility.set_message_token('STEP',l_table_name);

696: end if;
697:
698: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
699: hr_utility.set_message_token('PROCEDURE','PSEUDO_SEED_DATA_CLASH');
700: hr_utility.set_message_token('STEP',l_table_name);
701: hr_utility.raise_error;
702:
703: else
704: hr_utility.trace(' no clash found ');

Line 701: hr_utility.raise_error;

697:
698: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
699: hr_utility.set_message_token('PROCEDURE','PSEUDO_SEED_DATA_CLASH');
700: hr_utility.set_message_token('STEP',l_table_name);
701: hr_utility.raise_error;
702:
703: else
704: hr_utility.trace(' no clash found ');
705: END IF;

Line 704: hr_utility.trace(' no clash found ');

700: hr_utility.set_message_token('STEP',l_table_name);
701: hr_utility.raise_error;
702:
703: else
704: hr_utility.trace(' no clash found ');
705: END IF;
706:
707: END IF; -- pseudo enabled is not Y
708:

Line 712: hr_utility.set_location ('Exiting pseudo_seed_data_clash',100);

708:
709: EXCEPTION when no_data_found then
710: null;
711:
712: hr_utility.set_location ('Exiting pseudo_seed_data_clash',100);
713:
714: END pseudo_seed_data_clash;
715:
716: -- END PSEUDO SUPPORT DEFINITIONS

Line 723: hr_utility.trace('enter: zz_leg_rule');

719: IS
720: BEGIN
721:
722: hrrunprc_trace_on;
723: hr_utility.trace('enter: zz_leg_rule');
724: hrrunprc_trace_off;
725:
726: INSERT INTO hr_application_ownerships
727: (key_name

Line 803: hr_utility.trace('exit: zz_leg_rule');

799: AND ao2.product_name = ao.product_name
800: AND ao2.key_value = ao.key_value);
801:
802: hrrunprc_trace_on;
803: hr_utility.trace('exit: zz_leg_rule');
804: hrrunprc_trace_off;
805:
806: END create_zz_leg_rule;
807:

Line 998: hr_utility.trace('sel per_assignment_status_types TMR');

994: into l_new_surrogate_key
995: from dual;
996: WHEN TOO_MANY_ROWS THEN
997: hrrunprc_trace_on;
998: hr_utility.trace('sel per_assignment_status_types TMR');
999:
1000: hr_utility.trace('user_status ' ||
1001: stu_rec.user_status);
1002: hr_utility.trace('per_system_status ' ||

Line 1000: hr_utility.trace('user_status ' ||

996: WHEN TOO_MANY_ROWS THEN
997: hrrunprc_trace_on;
998: hr_utility.trace('sel per_assignment_status_types TMR');
999:
1000: hr_utility.trace('user_status ' ||
1001: stu_rec.user_status);
1002: hr_utility.trace('per_system_status ' ||
1003: stu_rec.per_system_status);
1004: hr_utility.trace('pay_system_status ' ||

Line 1002: hr_utility.trace('per_system_status ' ||

998: hr_utility.trace('sel per_assignment_status_types TMR');
999:
1000: hr_utility.trace('user_status ' ||
1001: stu_rec.user_status);
1002: hr_utility.trace('per_system_status ' ||
1003: stu_rec.per_system_status);
1004: hr_utility.trace('pay_system_status ' ||
1005: stu_rec.pay_system_status);
1006: hr_utility.trace(':lc: ' || ':' ||

Line 1004: hr_utility.trace('pay_system_status ' ||

1000: hr_utility.trace('user_status ' ||
1001: stu_rec.user_status);
1002: hr_utility.trace('per_system_status ' ||
1003: stu_rec.per_system_status);
1004: hr_utility.trace('pay_system_status ' ||
1005: stu_rec.pay_system_status);
1006: hr_utility.trace(':lc: ' || ':' ||
1007: stu_rec.c_leg_code || ':');
1008: hrrunprc_trace_off;

Line 1006: hr_utility.trace(':lc: ' || ':' ||

1002: hr_utility.trace('per_system_status ' ||
1003: stu_rec.per_system_status);
1004: hr_utility.trace('pay_system_status ' ||
1005: stu_rec.pay_system_status);
1006: hr_utility.trace(':lc: ' || ':' ||
1007: stu_rec.c_leg_code || ':');
1008: hrrunprc_trace_off;
1009: raise;
1010: END;

Line 1659: hr_utility.trace('ins pay_balance_categories');

1655: ,nvl(each_row.USER_CATEGORY_NAME,
1656: each_row.CATEGORY_NAME));
1657: EXCEPTION WHEN OTHERS THEN
1658: hrrunprc_trace_on;
1659: hr_utility.trace('ins pay_balance_categories');
1660: hr_utility.trace('cat id: ' ||
1661: to_char(each_row.BALANCE_CATEGORY_ID));
1662: hr_utility.trace('cat name ' ||
1663: each_row.CATEGORY_NAME);

Line 1660: hr_utility.trace('cat id: ' ||

1656: each_row.CATEGORY_NAME));
1657: EXCEPTION WHEN OTHERS THEN
1658: hrrunprc_trace_on;
1659: hr_utility.trace('ins pay_balance_categories');
1660: hr_utility.trace('cat id: ' ||
1661: to_char(each_row.BALANCE_CATEGORY_ID));
1662: hr_utility.trace('cat name ' ||
1663: each_row.CATEGORY_NAME);
1664: hr_utility.trace(':lc:bg: ' || ':' ||

Line 1662: hr_utility.trace('cat name ' ||

1658: hrrunprc_trace_on;
1659: hr_utility.trace('ins pay_balance_categories');
1660: hr_utility.trace('cat id: ' ||
1661: to_char(each_row.BALANCE_CATEGORY_ID));
1662: hr_utility.trace('cat name ' ||
1663: each_row.CATEGORY_NAME);
1664: hr_utility.trace(':lc:bg: ' || ':' ||
1665: each_row.LEGISLATION_CODE || ':' ||
1666: to_char(each_row.BUSINESS_GROUP_ID) || ':');

Line 1664: hr_utility.trace(':lc:bg: ' || ':' ||

1660: hr_utility.trace('cat id: ' ||
1661: to_char(each_row.BALANCE_CATEGORY_ID));
1662: hr_utility.trace('cat name ' ||
1663: each_row.CATEGORY_NAME);
1664: hr_utility.trace(':lc:bg: ' || ':' ||
1665: each_row.LEGISLATION_CODE || ':' ||
1666: to_char(each_row.BUSINESS_GROUP_ID) || ':');
1667: hrrunprc_trace_off;
1668: raise;

Line 2002: hr_utility.trace('sel pay_balance_types TMR');

1998: v_new_balance_type_flag := 'Y';
1999:
2000: WHEN TOO_MANY_ROWS THEN
2001: hrrunprc_trace_on;
2002: hr_utility.trace('sel pay_balance_types TMR');
2003: hr_utility.trace('balance_name ' ||
2004: stu_rec.c_true_key);
2005: hr_utility.trace(':lc: ' || ':' ||
2006: stu_rec.c_leg_code || ':');

Line 2003: hr_utility.trace('balance_name ' ||

1999:
2000: WHEN TOO_MANY_ROWS THEN
2001: hrrunprc_trace_on;
2002: hr_utility.trace('sel pay_balance_types TMR');
2003: hr_utility.trace('balance_name ' ||
2004: stu_rec.c_true_key);
2005: hr_utility.trace(':lc: ' || ':' ||
2006: stu_rec.c_leg_code || ':');
2007: hrrunprc_trace_off;

Line 2005: hr_utility.trace(':lc: ' || ':' ||

2001: hrrunprc_trace_on;
2002: hr_utility.trace('sel pay_balance_types TMR');
2003: hr_utility.trace('balance_name ' ||
2004: stu_rec.c_true_key);
2005: hr_utility.trace(':lc: ' || ':' ||
2006: stu_rec.c_leg_code || ':');
2007: hrrunprc_trace_off;
2008: raise;
2009: END;

Line 2062: hr_utility.trace('sel pay_defined_balances TMR');

2058: from dual;
2059:
2060: WHEN TOO_MANY_ROWS THEN
2061: hrrunprc_trace_on;
2062: hr_utility.trace('sel pay_defined_balances TMR');
2063: hr_utility.trace('balance_type_id ' ||
2064: to_char(l_new_surrogate_key));
2065: hr_utility.trace('balance_name ' ||
2066: stu_rec.c_true_key);

Line 2063: hr_utility.trace('balance_type_id ' ||

2059:
2060: WHEN TOO_MANY_ROWS THEN
2061: hrrunprc_trace_on;
2062: hr_utility.trace('sel pay_defined_balances TMR');
2063: hr_utility.trace('balance_type_id ' ||
2064: to_char(l_new_surrogate_key));
2065: hr_utility.trace('balance_name ' ||
2066: stu_rec.c_true_key);
2067: hr_utility.trace('balance_dimension_id ' ||

Line 2065: hr_utility.trace('balance_name ' ||

2061: hrrunprc_trace_on;
2062: hr_utility.trace('sel pay_defined_balances TMR');
2063: hr_utility.trace('balance_type_id ' ||
2064: to_char(l_new_surrogate_key));
2065: hr_utility.trace('balance_name ' ||
2066: stu_rec.c_true_key);
2067: hr_utility.trace('balance_dimension_id ' ||
2068: to_char(def_bals.balance_dimension_id));
2069: hr_utility.trace(':lc: ' || ':' ||

Line 2067: hr_utility.trace('balance_dimension_id ' ||

2063: hr_utility.trace('balance_type_id ' ||
2064: to_char(l_new_surrogate_key));
2065: hr_utility.trace('balance_name ' ||
2066: stu_rec.c_true_key);
2067: hr_utility.trace('balance_dimension_id ' ||
2068: to_char(def_bals.balance_dimension_id));
2069: hr_utility.trace(':lc: ' || ':' ||
2070: def_bals.legislation_code || ':');
2071: hrrunprc_trace_off;

Line 2069: hr_utility.trace(':lc: ' || ':' ||

2065: hr_utility.trace('balance_name ' ||
2066: stu_rec.c_true_key);
2067: hr_utility.trace('balance_dimension_id ' ||
2068: to_char(def_bals.balance_dimension_id));
2069: hr_utility.trace(':lc: ' || ':' ||
2070: def_bals.legislation_code || ':');
2071: hrrunprc_trace_off;
2072: raise;
2073: END;

Line 2400: hr_utility.trace('ins pay_balance_types');

2396: ,stu_rec.base_balance_type_id
2397: ,stu_rec.balance_category_id);
2398: EXCEPTION WHEN OTHERS THEN
2399: hrrunprc_trace_on;
2400: hr_utility.trace('ins pay_balance_types');
2401: hr_utility.trace('bal type id: ' ||
2402: to_char(stu_rec.c_surrogate_key));
2403: hr_utility.trace('bal type name ' ||
2404: stu_rec.c_true_key);

Line 2401: hr_utility.trace('bal type id: ' ||

2397: ,stu_rec.balance_category_id);
2398: EXCEPTION WHEN OTHERS THEN
2399: hrrunprc_trace_on;
2400: hr_utility.trace('ins pay_balance_types');
2401: hr_utility.trace('bal type id: ' ||
2402: to_char(stu_rec.c_surrogate_key));
2403: hr_utility.trace('bal type name ' ||
2404: stu_rec.c_true_key);
2405: hr_utility.trace(':lc: ' || ':' ||

Line 2403: hr_utility.trace('bal type name ' ||

2399: hrrunprc_trace_on;
2400: hr_utility.trace('ins pay_balance_types');
2401: hr_utility.trace('bal type id: ' ||
2402: to_char(stu_rec.c_surrogate_key));
2403: hr_utility.trace('bal type name ' ||
2404: stu_rec.c_true_key);
2405: hr_utility.trace(':lc: ' || ':' ||
2406: stu_rec.c_leg_code || ':');
2407: hrrunprc_trace_off;

Line 2405: hr_utility.trace(':lc: ' || ':' ||

2401: hr_utility.trace('bal type id: ' ||
2402: to_char(stu_rec.c_surrogate_key));
2403: hr_utility.trace('bal type name ' ||
2404: stu_rec.c_true_key);
2405: hr_utility.trace(':lc: ' || ':' ||
2406: stu_rec.c_leg_code || ':');
2407: hrrunprc_trace_off;
2408: raise;
2409: END;

Line 2494: hr_utility.trace('ins pay_balance_class');

2490: , bal_classes.creation_date
2491: from dual;
2492: EXCEPTION WHEN OTHERS THEN
2493: hrrunprc_trace_on;
2494: hr_utility.trace('ins pay_balance_class');
2495: hr_utility.trace('bal type id ' ||
2496: to_char(bal_classes.balance_type_id));
2497: hr_utility.trace('bal type name ' ||
2498: stu_rec.c_true_key);

Line 2495: hr_utility.trace('bal type id ' ||

2491: from dual;
2492: EXCEPTION WHEN OTHERS THEN
2493: hrrunprc_trace_on;
2494: hr_utility.trace('ins pay_balance_class');
2495: hr_utility.trace('bal type id ' ||
2496: to_char(bal_classes.balance_type_id));
2497: hr_utility.trace('bal type name ' ||
2498: stu_rec.c_true_key);
2499: hr_utility.trace('bal class id ' ||

Line 2497: hr_utility.trace('bal type name ' ||

2493: hrrunprc_trace_on;
2494: hr_utility.trace('ins pay_balance_class');
2495: hr_utility.trace('bal type id ' ||
2496: to_char(bal_classes.balance_type_id));
2497: hr_utility.trace('bal type name ' ||
2498: stu_rec.c_true_key);
2499: hr_utility.trace('bal class id ' ||
2500: to_char(bal_classes.classification_id));
2501: hr_utility.trace('bal class scale ' ||

Line 2499: hr_utility.trace('bal class id ' ||

2495: hr_utility.trace('bal type id ' ||
2496: to_char(bal_classes.balance_type_id));
2497: hr_utility.trace('bal type name ' ||
2498: stu_rec.c_true_key);
2499: hr_utility.trace('bal class id ' ||
2500: to_char(bal_classes.classification_id));
2501: hr_utility.trace('bal class scale ' ||
2502: to_char(bal_classes.scale));
2503: hr_utility.trace(':lc: ' || ':' ||

Line 2501: hr_utility.trace('bal class scale ' ||

2497: hr_utility.trace('bal type name ' ||
2498: stu_rec.c_true_key);
2499: hr_utility.trace('bal class id ' ||
2500: to_char(bal_classes.classification_id));
2501: hr_utility.trace('bal class scale ' ||
2502: to_char(bal_classes.scale));
2503: hr_utility.trace(':lc: ' || ':' ||
2504: bal_classes.legislation_code || ':');
2505: hrrunprc_trace_off;

Line 2503: hr_utility.trace(':lc: ' || ':' ||

2499: hr_utility.trace('bal class id ' ||
2500: to_char(bal_classes.classification_id));
2501: hr_utility.trace('bal class scale ' ||
2502: to_char(bal_classes.scale));
2503: hr_utility.trace(':lc: ' || ':' ||
2504: bal_classes.legislation_code || ':');
2505: hrrunprc_trace_off;
2506: raise;
2507: END;

Line 2606: hr_utility.trace('ins pay_def_bal');

2602: ,def_bals.save_run_balance
2603: ,def_bals.run_balance_status);
2604: EXCEPTION WHEN OTHERS THEN
2605: hrrunprc_trace_on;
2606: hr_utility.trace('ins pay_def_bal');
2607: hr_utility.trace('def bal id ' ||
2608: to_char(def_bals.defined_balance_id));
2609: hr_utility.trace('bal type id ' ||
2610: to_char(def_bals.balance_type_id));

Line 2607: hr_utility.trace('def bal id ' ||

2603: ,def_bals.run_balance_status);
2604: EXCEPTION WHEN OTHERS THEN
2605: hrrunprc_trace_on;
2606: hr_utility.trace('ins pay_def_bal');
2607: hr_utility.trace('def bal id ' ||
2608: to_char(def_bals.defined_balance_id));
2609: hr_utility.trace('bal type id ' ||
2610: to_char(def_bals.balance_type_id));
2611: hr_utility.trace('bal type name ' ||

Line 2609: hr_utility.trace('bal type id ' ||

2605: hrrunprc_trace_on;
2606: hr_utility.trace('ins pay_def_bal');
2607: hr_utility.trace('def bal id ' ||
2608: to_char(def_bals.defined_balance_id));
2609: hr_utility.trace('bal type id ' ||
2610: to_char(def_bals.balance_type_id));
2611: hr_utility.trace('bal type name ' ||
2612: stu_rec.c_true_key);
2613: hr_utility.trace('bal dim id ' ||

Line 2611: hr_utility.trace('bal type name ' ||

2607: hr_utility.trace('def bal id ' ||
2608: to_char(def_bals.defined_balance_id));
2609: hr_utility.trace('bal type id ' ||
2610: to_char(def_bals.balance_type_id));
2611: hr_utility.trace('bal type name ' ||
2612: stu_rec.c_true_key);
2613: hr_utility.trace('bal dim id ' ||
2614: to_char(def_bals.balance_dimension_id));
2615: hr_utility.trace('save_run_balance ' ||

Line 2613: hr_utility.trace('bal dim id ' ||

2609: hr_utility.trace('bal type id ' ||
2610: to_char(def_bals.balance_type_id));
2611: hr_utility.trace('bal type name ' ||
2612: stu_rec.c_true_key);
2613: hr_utility.trace('bal dim id ' ||
2614: to_char(def_bals.balance_dimension_id));
2615: hr_utility.trace('save_run_balance ' ||
2616: def_bals.save_run_balance);
2617: hr_utility.trace(':lc: ' || ':' ||

Line 2615: hr_utility.trace('save_run_balance ' ||

2611: hr_utility.trace('bal type name ' ||
2612: stu_rec.c_true_key);
2613: hr_utility.trace('bal dim id ' ||
2614: to_char(def_bals.balance_dimension_id));
2615: hr_utility.trace('save_run_balance ' ||
2616: def_bals.save_run_balance);
2617: hr_utility.trace(':lc: ' || ':' ||
2618: def_bals.legislation_code || ':');
2619: hrrunprc_trace_off;

Line 2617: hr_utility.trace(':lc: ' || ':' ||

2613: hr_utility.trace('bal dim id ' ||
2614: to_char(def_bals.balance_dimension_id));
2615: hr_utility.trace('save_run_balance ' ||
2616: def_bals.save_run_balance);
2617: hr_utility.trace(':lc: ' || ':' ||
2618: def_bals.legislation_code || ':');
2619: hrrunprc_trace_off;
2620: raise;
2621: END;

Line 2736: hr_utility.trace('ins pay_bal_feed');

2732: ,bal_feeds.creation_date
2733: from dual;
2734: EXCEPTION WHEN OTHERS THEN
2735: hrrunprc_trace_on;
2736: hr_utility.trace('ins pay_bal_feed');
2737: hr_utility.trace('bal type id ' ||
2738: to_char(bal_feeds.balance_type_id));
2739: hr_utility.trace('bal type name ' ||
2740: stu_rec.c_true_key);

Line 2737: hr_utility.trace('bal type id ' ||

2733: from dual;
2734: EXCEPTION WHEN OTHERS THEN
2735: hrrunprc_trace_on;
2736: hr_utility.trace('ins pay_bal_feed');
2737: hr_utility.trace('bal type id ' ||
2738: to_char(bal_feeds.balance_type_id));
2739: hr_utility.trace('bal type name ' ||
2740: stu_rec.c_true_key);
2741: hr_utility.trace('input value id ' ||

Line 2739: hr_utility.trace('bal type name ' ||

2735: hrrunprc_trace_on;
2736: hr_utility.trace('ins pay_bal_feed');
2737: hr_utility.trace('bal type id ' ||
2738: to_char(bal_feeds.balance_type_id));
2739: hr_utility.trace('bal type name ' ||
2740: stu_rec.c_true_key);
2741: hr_utility.trace('input value id ' ||
2742: to_char(bal_feeds.input_value_id));
2743: hr_utility.trace(':lc: ' || ':' ||

Line 2741: hr_utility.trace('input value id ' ||

2737: hr_utility.trace('bal type id ' ||
2738: to_char(bal_feeds.balance_type_id));
2739: hr_utility.trace('bal type name ' ||
2740: stu_rec.c_true_key);
2741: hr_utility.trace('input value id ' ||
2742: to_char(bal_feeds.input_value_id));
2743: hr_utility.trace(':lc: ' || ':' ||
2744: bal_feeds.legislation_code || ':');
2745: hrrunprc_trace_off;

Line 2743: hr_utility.trace(':lc: ' || ':' ||

2739: hr_utility.trace('bal type name ' ||
2740: stu_rec.c_true_key);
2741: hr_utility.trace('input value id ' ||
2742: to_char(bal_feeds.input_value_id));
2743: hr_utility.trace(':lc: ' || ':' ||
2744: bal_feeds.legislation_code || ':');
2745: hrrunprc_trace_off;
2746: raise;
2747: END;

Line 2984: hr_utility.trace('sel pay_balance_dimensions TMR');

2980: from dual;
2981:
2982: WHEN TOO_MANY_ROWS THEN
2983: hrrunprc_trace_on;
2984: hr_utility.trace('sel pay_balance_dimensions TMR');
2985: hr_utility.trace('dimension_name ' ||
2986: stu_rec.c_true_key);
2987: hr_utility.trace(':lc: ' || ':' ||
2988: stu_rec.c_leg_code || ':');

Line 2985: hr_utility.trace('dimension_name ' ||

2981:
2982: WHEN TOO_MANY_ROWS THEN
2983: hrrunprc_trace_on;
2984: hr_utility.trace('sel pay_balance_dimensions TMR');
2985: hr_utility.trace('dimension_name ' ||
2986: stu_rec.c_true_key);
2987: hr_utility.trace(':lc: ' || ':' ||
2988: stu_rec.c_leg_code || ':');
2989: hrrunprc_trace_off;

Line 2987: hr_utility.trace(':lc: ' || ':' ||

2983: hrrunprc_trace_on;
2984: hr_utility.trace('sel pay_balance_dimensions TMR');
2985: hr_utility.trace('dimension_name ' ||
2986: stu_rec.c_true_key);
2987: hr_utility.trace(':lc: ' || ':' ||
2988: stu_rec.c_leg_code || ':');
2989: hrrunprc_trace_off;
2990: raise;
2991: END;

Line 3402: hr_utility.trace('ins pay_bal_dim');

3398: ,stu_rec.save_run_balance_enabled
3399: ,stu_rec.start_date_code);
3400: EXCEPTION WHEN OTHERS THEN
3401: hrrunprc_trace_on;
3402: hr_utility.trace('ins pay_bal_dim');
3403: hr_utility.trace('bal dim id ' ||
3404: to_char(stu_rec.c_surrogate_key));
3405: hr_utility.trace('dimension name ' ||
3406: stu_rec.c_true_key);

Line 3403: hr_utility.trace('bal dim id ' ||

3399: ,stu_rec.start_date_code);
3400: EXCEPTION WHEN OTHERS THEN
3401: hrrunprc_trace_on;
3402: hr_utility.trace('ins pay_bal_dim');
3403: hr_utility.trace('bal dim id ' ||
3404: to_char(stu_rec.c_surrogate_key));
3405: hr_utility.trace('dimension name ' ||
3406: stu_rec.c_true_key);
3407: hr_utility.trace('dbi suffix ' ||

Line 3405: hr_utility.trace('dimension name ' ||

3401: hrrunprc_trace_on;
3402: hr_utility.trace('ins pay_bal_dim');
3403: hr_utility.trace('bal dim id ' ||
3404: to_char(stu_rec.c_surrogate_key));
3405: hr_utility.trace('dimension name ' ||
3406: stu_rec.c_true_key);
3407: hr_utility.trace('dbi suffix ' ||
3408: stu_rec.database_item_suffix);
3409: hr_utility.trace('save_run_balance_enabled ' ||

Line 3407: hr_utility.trace('dbi suffix ' ||

3403: hr_utility.trace('bal dim id ' ||
3404: to_char(stu_rec.c_surrogate_key));
3405: hr_utility.trace('dimension name ' ||
3406: stu_rec.c_true_key);
3407: hr_utility.trace('dbi suffix ' ||
3408: stu_rec.database_item_suffix);
3409: hr_utility.trace('save_run_balance_enabled ' ||
3410: stu_rec.save_run_balance_enabled);
3411: hr_utility.trace(':lc: ' || ':' ||

Line 3409: hr_utility.trace('save_run_balance_enabled ' ||

3405: hr_utility.trace('dimension name ' ||
3406: stu_rec.c_true_key);
3407: hr_utility.trace('dbi suffix ' ||
3408: stu_rec.database_item_suffix);
3409: hr_utility.trace('save_run_balance_enabled ' ||
3410: stu_rec.save_run_balance_enabled);
3411: hr_utility.trace(':lc: ' || ':' ||
3412: stu_rec.c_leg_code || ':');
3413: hrrunprc_trace_off;

Line 3411: hr_utility.trace(':lc: ' || ':' ||

3407: hr_utility.trace('dbi suffix ' ||
3408: stu_rec.database_item_suffix);
3409: hr_utility.trace('save_run_balance_enabled ' ||
3410: stu_rec.save_run_balance_enabled);
3411: hr_utility.trace(':lc: ' || ':' ||
3412: stu_rec.c_leg_code || ':');
3413: hrrunprc_trace_off;
3414: raise;
3415: END;

Line 3657: hr_utility.trace('ins pay dim routes');

3653: ,stu_rec.BALANCE_TYPE_COLUMN
3654: ,stu_rec.DECODE_REQUIRED);
3655: EXCEPTION WHEN OTHERS THEN
3656: hrrunprc_trace_on;
3657: hr_utility.trace('ins pay dim routes');
3658: hr_utility.trace('bal dim id ' ||
3659: to_char(stu_rec.BALANCE_DIMENSION_ID));
3660: hr_utility.trace('route id ' ||
3661: to_char(stu_rec.ROUTE_ID));

Line 3658: hr_utility.trace('bal dim id ' ||

3654: ,stu_rec.DECODE_REQUIRED);
3655: EXCEPTION WHEN OTHERS THEN
3656: hrrunprc_trace_on;
3657: hr_utility.trace('ins pay dim routes');
3658: hr_utility.trace('bal dim id ' ||
3659: to_char(stu_rec.BALANCE_DIMENSION_ID));
3660: hr_utility.trace('route id ' ||
3661: to_char(stu_rec.ROUTE_ID));
3662: hr_utility.trace('priority ' ||

Line 3660: hr_utility.trace('route id ' ||

3656: hrrunprc_trace_on;
3657: hr_utility.trace('ins pay dim routes');
3658: hr_utility.trace('bal dim id ' ||
3659: to_char(stu_rec.BALANCE_DIMENSION_ID));
3660: hr_utility.trace('route id ' ||
3661: to_char(stu_rec.ROUTE_ID));
3662: hr_utility.trace('priority ' ||
3663: to_char(stu_rec.PRIORITY));
3664: hr_utility.trace('route type ' ||

Line 3662: hr_utility.trace('priority ' ||

3658: hr_utility.trace('bal dim id ' ||
3659: to_char(stu_rec.BALANCE_DIMENSION_ID));
3660: hr_utility.trace('route id ' ||
3661: to_char(stu_rec.ROUTE_ID));
3662: hr_utility.trace('priority ' ||
3663: to_char(stu_rec.PRIORITY));
3664: hr_utility.trace('route type ' ||
3665: stu_rec.ROUTE_TYPE);
3666: hrrunprc_trace_off;

Line 3664: hr_utility.trace('route type ' ||

3660: hr_utility.trace('route id ' ||
3661: to_char(stu_rec.ROUTE_ID));
3662: hr_utility.trace('priority ' ||
3663: to_char(stu_rec.PRIORITY));
3664: hr_utility.trace('route type ' ||
3665: stu_rec.ROUTE_TYPE);
3666: hrrunprc_trace_off;
3667: raise;
3668: END;

Line 4035: hr_utility.trace('ins per_ass_info_type');

4031: ,stu_rec.multiple_occurences_flag
4032: );
4033: EXCEPTION WHEN OTHERS THEN
4034: hrrunprc_trace_on;
4035: hr_utility.trace('ins per_ass_info_type');
4036: hr_utility.trace('information_type ' ||
4037: stu_rec.c_true_key);
4038: hr_utility.trace(':lc: ' || ':' ||
4039: stu_rec.c_leg_code || ':');

Line 4036: hr_utility.trace('information_type ' ||

4032: );
4033: EXCEPTION WHEN OTHERS THEN
4034: hrrunprc_trace_on;
4035: hr_utility.trace('ins per_ass_info_type');
4036: hr_utility.trace('information_type ' ||
4037: stu_rec.c_true_key);
4038: hr_utility.trace(':lc: ' || ':' ||
4039: stu_rec.c_leg_code || ':');
4040: hrrunprc_trace_off;

Line 4038: hr_utility.trace(':lc: ' || ':' ||

4034: hrrunprc_trace_on;
4035: hr_utility.trace('ins per_ass_info_type');
4036: hr_utility.trace('information_type ' ||
4037: stu_rec.c_true_key);
4038: hr_utility.trace(':lc: ' || ':' ||
4039: stu_rec.c_leg_code || ':');
4040: hrrunprc_trace_off;
4041: raise;
4042: END;

Line 4161: hr_utility.trace('sel pay_legislative_field_info TMR');

4157: and nvl(target_location,'~') = nvl(stu_rec.target_location,'~')
4158: and nvl(validation_name,'~') = nvl(stu_rec.validation_name,'~');
4159: EXCEPTION WHEN TOO_MANY_ROWS THEN
4160: hrrunprc_trace_on;
4161: hr_utility.trace('sel pay_legislative_field_info TMR');
4162: hr_utility.trace('field_name ' ||
4163: stu_rec.field_name);
4164: hr_utility.trace('rule_type ' ||
4165: stu_rec.rule_type);

Line 4162: hr_utility.trace('field_name ' ||

4158: and nvl(validation_name,'~') = nvl(stu_rec.validation_name,'~');
4159: EXCEPTION WHEN TOO_MANY_ROWS THEN
4160: hrrunprc_trace_on;
4161: hr_utility.trace('sel pay_legislative_field_info TMR');
4162: hr_utility.trace('field_name ' ||
4163: stu_rec.field_name);
4164: hr_utility.trace('rule_type ' ||
4165: stu_rec.rule_type);
4166: hr_utility.trace('target_location ' ||

Line 4164: hr_utility.trace('rule_type ' ||

4160: hrrunprc_trace_on;
4161: hr_utility.trace('sel pay_legislative_field_info TMR');
4162: hr_utility.trace('field_name ' ||
4163: stu_rec.field_name);
4164: hr_utility.trace('rule_type ' ||
4165: stu_rec.rule_type);
4166: hr_utility.trace('target_location ' ||
4167: stu_rec.target_location);
4168: hr_utility.trace('validation_name ' ||

Line 4166: hr_utility.trace('target_location ' ||

4162: hr_utility.trace('field_name ' ||
4163: stu_rec.field_name);
4164: hr_utility.trace('rule_type ' ||
4165: stu_rec.rule_type);
4166: hr_utility.trace('target_location ' ||
4167: stu_rec.target_location);
4168: hr_utility.trace('validation_name ' ||
4169: stu_rec.validation_name);
4170: hr_utility.trace(':lc: ' || ':' ||

Line 4168: hr_utility.trace('validation_name ' ||

4164: hr_utility.trace('rule_type ' ||
4165: stu_rec.rule_type);
4166: hr_utility.trace('target_location ' ||
4167: stu_rec.target_location);
4168: hr_utility.trace('validation_name ' ||
4169: stu_rec.validation_name);
4170: hr_utility.trace(':lc: ' || ':' ||
4171: stu_rec.legislation_code || ':');
4172: hrrunprc_trace_off;

Line 4170: hr_utility.trace(':lc: ' || ':' ||

4166: hr_utility.trace('target_location ' ||
4167: stu_rec.target_location);
4168: hr_utility.trace('validation_name ' ||
4169: stu_rec.validation_name);
4170: hr_utility.trace(':lc: ' || ':' ||
4171: stu_rec.legislation_code || ':');
4172: hrrunprc_trace_off;
4173: raise;
4174: END;

Line 4248: hr_utility.trace('ins pay_leg_field_info');

4244: ,stu_rec.CATEGORY
4245: );
4246: EXCEPTION WHEN OTHERS THEN
4247: hrrunprc_trace_on;
4248: hr_utility.trace('ins pay_leg_field_info');
4249: hr_utility.trace('field_name ' ||
4250: stu_rec.field_name);
4251: hr_utility.trace('rule_type ' ||
4252: stu_rec.rule_type);

Line 4249: hr_utility.trace('field_name ' ||

4245: );
4246: EXCEPTION WHEN OTHERS THEN
4247: hrrunprc_trace_on;
4248: hr_utility.trace('ins pay_leg_field_info');
4249: hr_utility.trace('field_name ' ||
4250: stu_rec.field_name);
4251: hr_utility.trace('rule_type ' ||
4252: stu_rec.rule_type);
4253: hr_utility.trace('rule_mode ' ||

Line 4251: hr_utility.trace('rule_type ' ||

4247: hrrunprc_trace_on;
4248: hr_utility.trace('ins pay_leg_field_info');
4249: hr_utility.trace('field_name ' ||
4250: stu_rec.field_name);
4251: hr_utility.trace('rule_type ' ||
4252: stu_rec.rule_type);
4253: hr_utility.trace('rule_mode ' ||
4254: stu_rec.rule_mode);
4255: hr_utility.trace(':lc: ' || ':' ||

Line 4253: hr_utility.trace('rule_mode ' ||

4249: hr_utility.trace('field_name ' ||
4250: stu_rec.field_name);
4251: hr_utility.trace('rule_type ' ||
4252: stu_rec.rule_type);
4253: hr_utility.trace('rule_mode ' ||
4254: stu_rec.rule_mode);
4255: hr_utility.trace(':lc: ' || ':' ||
4256: stu_rec.legislation_code || ':');
4257: hrrunprc_trace_off;

Line 4255: hr_utility.trace(':lc: ' || ':' ||

4251: hr_utility.trace('rule_type ' ||
4252: stu_rec.rule_type);
4253: hr_utility.trace('rule_mode ' ||
4254: stu_rec.rule_mode);
4255: hr_utility.trace(':lc: ' || ':' ||
4256: stu_rec.legislation_code || ':');
4257: hrrunprc_trace_off;
4258: raise;
4259: END;

Line 4560: hr_utility.trace('ins payment_types');

4556: ,stu_rec.reconciliation_function
4557: );
4558: EXCEPTION WHEN OTHERS THEN
4559: hrrunprc_trace_on;
4560: hr_utility.trace('ins payment_types');
4561: hr_utility.trace('type_id ' ||
4562: to_char(stu_rec.c_surrogate_key));
4563: hr_utility.trace('type_name ' ||
4564: stu_rec.c_true_key);

Line 4561: hr_utility.trace('type_id ' ||

4557: );
4558: EXCEPTION WHEN OTHERS THEN
4559: hrrunprc_trace_on;
4560: hr_utility.trace('ins payment_types');
4561: hr_utility.trace('type_id ' ||
4562: to_char(stu_rec.c_surrogate_key));
4563: hr_utility.trace('type_name ' ||
4564: stu_rec.c_true_key);
4565: hr_utility.trace('currency_code ' ||

Line 4563: hr_utility.trace('type_name ' ||

4559: hrrunprc_trace_on;
4560: hr_utility.trace('ins payment_types');
4561: hr_utility.trace('type_id ' ||
4562: to_char(stu_rec.c_surrogate_key));
4563: hr_utility.trace('type_name ' ||
4564: stu_rec.c_true_key);
4565: hr_utility.trace('currency_code ' ||
4566: stu_rec.currency_code);
4567: hrrunprc_trace_off;

Line 4565: hr_utility.trace('currency_code ' ||

4561: hr_utility.trace('type_id ' ||
4562: to_char(stu_rec.c_surrogate_key));
4563: hr_utility.trace('type_name ' ||
4564: stu_rec.c_true_key);
4565: hr_utility.trace('currency_code ' ||
4566: stu_rec.currency_code);
4567: hrrunprc_trace_off;
4568: raise;
4569: END;

Line 5194: hr_utility.trace('ins pay_user_rows');

5190: ,each_row.creation_date
5191: );
5192: EXCEPTION WHEN OTHERS THEN
5193: hrrunprc_trace_on;
5194: hr_utility.trace('ins pay_user_rows');
5195: hr_utility.trace('table_id ' ||
5196: to_char(each_row.user_table_id));
5197: hr_utility.trace('name ' ||
5198: each_row.row_low_range_or_name);

Line 5195: hr_utility.trace('table_id ' ||

5191: );
5192: EXCEPTION WHEN OTHERS THEN
5193: hrrunprc_trace_on;
5194: hr_utility.trace('ins pay_user_rows');
5195: hr_utility.trace('table_id ' ||
5196: to_char(each_row.user_table_id));
5197: hr_utility.trace('name ' ||
5198: each_row.row_low_range_or_name);
5199: hr_utility.trace('high_range ' ||

Line 5197: hr_utility.trace('name ' ||

5193: hrrunprc_trace_on;
5194: hr_utility.trace('ins pay_user_rows');
5195: hr_utility.trace('table_id ' ||
5196: to_char(each_row.user_table_id));
5197: hr_utility.trace('name ' ||
5198: each_row.row_low_range_or_name);
5199: hr_utility.trace('high_range ' ||
5200: each_row.row_high_range);
5201: hr_utility.trace(':lc: ' || ':' ||

Line 5199: hr_utility.trace('high_range ' ||

5195: hr_utility.trace('table_id ' ||
5196: to_char(each_row.user_table_id));
5197: hr_utility.trace('name ' ||
5198: each_row.row_low_range_or_name);
5199: hr_utility.trace('high_range ' ||
5200: each_row.row_high_range);
5201: hr_utility.trace(':lc: ' || ':' ||
5202: each_row.legislation_code || ':');
5203: hr_utility.trace('eff start date ' ||

Line 5201: hr_utility.trace(':lc: ' || ':' ||

5197: hr_utility.trace('name ' ||
5198: each_row.row_low_range_or_name);
5199: hr_utility.trace('high_range ' ||
5200: each_row.row_high_range);
5201: hr_utility.trace(':lc: ' || ':' ||
5202: each_row.legislation_code || ':');
5203: hr_utility.trace('eff start date ' ||
5204: to_date(each_row.effective_start_date,'DD-MM-YYYY'));
5205: hrrunprc_trace_off;

Line 5203: hr_utility.trace('eff start date ' ||

5199: hr_utility.trace('high_range ' ||
5200: each_row.row_high_range);
5201: hr_utility.trace(':lc: ' || ':' ||
5202: each_row.legislation_code || ':');
5203: hr_utility.trace('eff start date ' ||
5204: to_date(each_row.effective_start_date,'DD-MM-YYYY'));
5205: hrrunprc_trace_off;
5206: raise;
5207: END;

Line 5256: hr_utility.trace('ins pay_user_col_inst');

5252: crt_exc('Parent Column not in live tables');
5253: RAISE row_in_error;
5254: WHEN OTHERS THEN
5255: hrrunprc_trace_on;
5256: hr_utility.trace('ins pay_user_col_inst');
5257: hr_utility.trace('value ' ||
5258: each_child.value);
5259: hr_utility.trace('column_id ' ||
5260: to_char(each_child.user_column_id));

Line 5257: hr_utility.trace('value ' ||

5253: RAISE row_in_error;
5254: WHEN OTHERS THEN
5255: hrrunprc_trace_on;
5256: hr_utility.trace('ins pay_user_col_inst');
5257: hr_utility.trace('value ' ||
5258: each_child.value);
5259: hr_utility.trace('column_id ' ||
5260: to_char(each_child.user_column_id));
5261: hr_utility.trace('row id ' ||

Line 5259: hr_utility.trace('column_id ' ||

5255: hrrunprc_trace_on;
5256: hr_utility.trace('ins pay_user_col_inst');
5257: hr_utility.trace('value ' ||
5258: each_child.value);
5259: hr_utility.trace('column_id ' ||
5260: to_char(each_child.user_column_id));
5261: hr_utility.trace('row id ' ||
5262: to_char(r_distinct.c_surrogate_key));
5263: hr_utility.trace('row low range ' ||

Line 5261: hr_utility.trace('row id ' ||

5257: hr_utility.trace('value ' ||
5258: each_child.value);
5259: hr_utility.trace('column_id ' ||
5260: to_char(each_child.user_column_id));
5261: hr_utility.trace('row id ' ||
5262: to_char(r_distinct.c_surrogate_key));
5263: hr_utility.trace('row low range ' ||
5264: r_distinct.c_true_key);
5265: hr_utility.trace('row eff start date ' ||

Line 5263: hr_utility.trace('row low range ' ||

5259: hr_utility.trace('column_id ' ||
5260: to_char(each_child.user_column_id));
5261: hr_utility.trace('row id ' ||
5262: to_char(r_distinct.c_surrogate_key));
5263: hr_utility.trace('row low range ' ||
5264: r_distinct.c_true_key);
5265: hr_utility.trace('row eff start date ' ||
5266: to_date(r_distinct.effective_start_date, 'DD-MM-YYYY'));
5267: hr_utility.trace('col eff start date ' ||

Line 5265: hr_utility.trace('row eff start date ' ||

5261: hr_utility.trace('row id ' ||
5262: to_char(r_distinct.c_surrogate_key));
5263: hr_utility.trace('row low range ' ||
5264: r_distinct.c_true_key);
5265: hr_utility.trace('row eff start date ' ||
5266: to_date(r_distinct.effective_start_date, 'DD-MM-YYYY'));
5267: hr_utility.trace('col eff start date ' ||
5268: to_date(each_child.effective_start_date, 'DD-MM-YYYY'));
5269: hrrunprc_trace_off;

Line 5267: hr_utility.trace('col eff start date ' ||

5263: hr_utility.trace('row low range ' ||
5264: r_distinct.c_true_key);
5265: hr_utility.trace('row eff start date ' ||
5266: to_date(r_distinct.effective_start_date, 'DD-MM-YYYY'));
5267: hr_utility.trace('col eff start date ' ||
5268: to_date(each_child.effective_start_date, 'DD-MM-YYYY'));
5269: hrrunprc_trace_off;
5270: raise;
5271: END;

Line 5946: hr_utility.trace('ins pay_rep_format_map');

5942: );
5943:
5944: EXCEPTION WHEN OTHERS THEN
5945: hrrunprc_trace_on;
5946: hr_utility.trace('ins pay_rep_format_map');
5947: hr_utility.trace('report_type ' ||
5948: stu_rec.report_type);
5949: hr_utility.trace('report_qualifier ' ||
5950: stu_rec.report_qualifier);

Line 5947: hr_utility.trace('report_type ' ||

5943:
5944: EXCEPTION WHEN OTHERS THEN
5945: hrrunprc_trace_on;
5946: hr_utility.trace('ins pay_rep_format_map');
5947: hr_utility.trace('report_type ' ||
5948: stu_rec.report_type);
5949: hr_utility.trace('report_qualifier ' ||
5950: stu_rec.report_qualifier);
5951: hr_utility.trace('report_format ' ||

Line 5949: hr_utility.trace('report_qualifier ' ||

5945: hrrunprc_trace_on;
5946: hr_utility.trace('ins pay_rep_format_map');
5947: hr_utility.trace('report_type ' ||
5948: stu_rec.report_type);
5949: hr_utility.trace('report_qualifier ' ||
5950: stu_rec.report_qualifier);
5951: hr_utility.trace('report_format ' ||
5952: stu_rec.report_format);
5953: hrrunprc_trace_off;

Line 5951: hr_utility.trace('report_format ' ||

5947: hr_utility.trace('report_type ' ||
5948: stu_rec.report_type);
5949: hr_utility.trace('report_qualifier ' ||
5950: stu_rec.report_qualifier);
5951: hr_utility.trace('report_format ' ||
5952: stu_rec.report_format);
5953: hrrunprc_trace_off;
5954: raise;
5955: END;

Line 6124: hr_utility.trace('sel pay_mag_blocks TMR');

6120: from dual;
6121:
6122: WHEN TOO_MANY_ROWS THEN
6123: hrrunprc_trace_on;
6124: hr_utility.trace('sel pay_mag_blocks TMR');
6125: hr_utility.trace('block_name ' ||
6126: stu_rec.c_true_key);
6127: hr_utility.trace('report_format ' ||
6128: stu_rec.report_format);

Line 6125: hr_utility.trace('block_name ' ||

6121:
6122: WHEN TOO_MANY_ROWS THEN
6123: hrrunprc_trace_on;
6124: hr_utility.trace('sel pay_mag_blocks TMR');
6125: hr_utility.trace('block_name ' ||
6126: stu_rec.c_true_key);
6127: hr_utility.trace('report_format ' ||
6128: stu_rec.report_format);
6129: hr_utility.trace('cursor_name ' ||

Line 6127: hr_utility.trace('report_format ' ||

6123: hrrunprc_trace_on;
6124: hr_utility.trace('sel pay_mag_blocks TMR');
6125: hr_utility.trace('block_name ' ||
6126: stu_rec.c_true_key);
6127: hr_utility.trace('report_format ' ||
6128: stu_rec.report_format);
6129: hr_utility.trace('cursor_name ' ||
6130: stu_rec.cursor_name);
6131: hrrunprc_trace_off;

Line 6129: hr_utility.trace('cursor_name ' ||

6125: hr_utility.trace('block_name ' ||
6126: stu_rec.c_true_key);
6127: hr_utility.trace('report_format ' ||
6128: stu_rec.report_format);
6129: hr_utility.trace('cursor_name ' ||
6130: stu_rec.cursor_name);
6131: hrrunprc_trace_off;
6132: raise;
6133: END;

Line 6223: hr_utility.trace('ins pay_mag_blocks');

6219: stu_rec.cursor_name ,
6220: stu_rec.no_column_returned);
6221: EXCEPTION WHEN OTHERS THEN
6222: hrrunprc_trace_on;
6223: hr_utility.trace('ins pay_mag_blocks');
6224: hr_utility.trace('block_name ' ||
6225: stu_rec.c_true_key);
6226: hr_utility.trace('report_format ' ||
6227: stu_rec.report_format);

Line 6224: hr_utility.trace('block_name ' ||

6220: stu_rec.no_column_returned);
6221: EXCEPTION WHEN OTHERS THEN
6222: hrrunprc_trace_on;
6223: hr_utility.trace('ins pay_mag_blocks');
6224: hr_utility.trace('block_name ' ||
6225: stu_rec.c_true_key);
6226: hr_utility.trace('report_format ' ||
6227: stu_rec.report_format);
6228: hr_utility.trace('cursor_name ' ||

Line 6226: hr_utility.trace('report_format ' ||

6222: hrrunprc_trace_on;
6223: hr_utility.trace('ins pay_mag_blocks');
6224: hr_utility.trace('block_name ' ||
6225: stu_rec.c_true_key);
6226: hr_utility.trace('report_format ' ||
6227: stu_rec.report_format);
6228: hr_utility.trace('cursor_name ' ||
6229: stu_rec.cursor_name);
6230: hrrunprc_trace_off;

Line 6228: hr_utility.trace('cursor_name ' ||

6224: hr_utility.trace('block_name ' ||
6225: stu_rec.c_true_key);
6226: hr_utility.trace('report_format ' ||
6227: stu_rec.report_format);
6228: hr_utility.trace('cursor_name ' ||
6229: stu_rec.cursor_name);
6230: hrrunprc_trace_off;
6231: raise;
6232: END;

Line 6347: hr_utility.trace('ins pay_magnetic_records');

6343: stu_rec.frequency ,
6344: stu_rec.last_run_executed_mode);
6345: EXCEPTION WHEN OTHERS THEN
6346: hrrunprc_trace_on;
6347: hr_utility.trace('ins pay_magnetic_records');
6348: hr_utility.trace('mag block id: ' ||
6349: to_char(stu_rec.magnetic_block_id));
6350: hr_utility.trace('next blk id: ' ||
6351: to_char(stu_rec.next_block_id));

Line 6348: hr_utility.trace('mag block id: ' ||

6344: stu_rec.last_run_executed_mode);
6345: EXCEPTION WHEN OTHERS THEN
6346: hrrunprc_trace_on;
6347: hr_utility.trace('ins pay_magnetic_records');
6348: hr_utility.trace('mag block id: ' ||
6349: to_char(stu_rec.magnetic_block_id));
6350: hr_utility.trace('next blk id: ' ||
6351: to_char(stu_rec.next_block_id));
6352: hr_utility.trace('sequence: ' ||

Line 6350: hr_utility.trace('next blk id: ' ||

6346: hrrunprc_trace_on;
6347: hr_utility.trace('ins pay_magnetic_records');
6348: hr_utility.trace('mag block id: ' ||
6349: to_char(stu_rec.magnetic_block_id));
6350: hr_utility.trace('next blk id: ' ||
6351: to_char(stu_rec.next_block_id));
6352: hr_utility.trace('sequence: ' ||
6353: to_char(stu_rec.sequence));
6354: hrrunprc_trace_off;

Line 6352: hr_utility.trace('sequence: ' ||

6348: hr_utility.trace('mag block id: ' ||
6349: to_char(stu_rec.magnetic_block_id));
6350: hr_utility.trace('next blk id: ' ||
6351: to_char(stu_rec.next_block_id));
6352: hr_utility.trace('sequence: ' ||
6353: to_char(stu_rec.sequence));
6354: hrrunprc_trace_off;
6355: raise;
6356: END;

Line 6512: hr_utility.trace('sel pay_report_format_items_f TMR');

6508: from dual;
6509:
6510: WHEN TOO_MANY_ROWS THEN
6511: hrrunprc_trace_on;
6512: hr_utility.trace('sel pay_report_format_items_f TMR');
6513: hr_utility.trace('report_type ' ||
6514: stu_rec.report_type);
6515: hr_utility.trace('report_qualifier ' ||
6516: stu_rec.report_qualifier);

Line 6513: hr_utility.trace('report_type ' ||

6509:
6510: WHEN TOO_MANY_ROWS THEN
6511: hrrunprc_trace_on;
6512: hr_utility.trace('sel pay_report_format_items_f TMR');
6513: hr_utility.trace('report_type ' ||
6514: stu_rec.report_type);
6515: hr_utility.trace('report_qualifier ' ||
6516: stu_rec.report_qualifier);
6517: hr_utility.trace('report_category ' ||

Line 6515: hr_utility.trace('report_qualifier ' ||

6511: hrrunprc_trace_on;
6512: hr_utility.trace('sel pay_report_format_items_f TMR');
6513: hr_utility.trace('report_type ' ||
6514: stu_rec.report_type);
6515: hr_utility.trace('report_qualifier ' ||
6516: stu_rec.report_qualifier);
6517: hr_utility.trace('report_category ' ||
6518: stu_rec.report_category);
6519: hr_utility.trace('user_entity_id ' ||

Line 6517: hr_utility.trace('report_category ' ||

6513: hr_utility.trace('report_type ' ||
6514: stu_rec.report_type);
6515: hr_utility.trace('report_qualifier ' ||
6516: stu_rec.report_qualifier);
6517: hr_utility.trace('report_category ' ||
6518: stu_rec.report_category);
6519: hr_utility.trace('user_entity_id ' ||
6520: stu_rec.user_entity_id);
6521: hrrunprc_trace_off;

Line 6519: hr_utility.trace('user_entity_id ' ||

6515: hr_utility.trace('report_qualifier ' ||
6516: stu_rec.report_qualifier);
6517: hr_utility.trace('report_category ' ||
6518: stu_rec.report_category);
6519: hr_utility.trace('user_entity_id ' ||
6520: stu_rec.user_entity_id);
6521: hrrunprc_trace_off;
6522: raise;
6523: END;

Line 6623: hr_utility.trace('ins pay_report_format_items_f');

6619: );
6620:
6621: EXCEPTION WHEN OTHERS THEN
6622: hrrunprc_trace_on;
6623: hr_utility.trace('ins pay_report_format_items_f');
6624: hr_utility.trace('report_type ' ||
6625: stu_rec.report_type);
6626: hr_utility.trace('report_qualifier ' ||
6627: stu_rec.report_qualifier);

Line 6624: hr_utility.trace('report_type ' ||

6620:
6621: EXCEPTION WHEN OTHERS THEN
6622: hrrunprc_trace_on;
6623: hr_utility.trace('ins pay_report_format_items_f');
6624: hr_utility.trace('report_type ' ||
6625: stu_rec.report_type);
6626: hr_utility.trace('report_qualifier ' ||
6627: stu_rec.report_qualifier);
6628: hr_utility.trace('report_category ' ||

Line 6626: hr_utility.trace('report_qualifier ' ||

6622: hrrunprc_trace_on;
6623: hr_utility.trace('ins pay_report_format_items_f');
6624: hr_utility.trace('report_type ' ||
6625: stu_rec.report_type);
6626: hr_utility.trace('report_qualifier ' ||
6627: stu_rec.report_qualifier);
6628: hr_utility.trace('report_category ' ||
6629: stu_rec.report_category);
6630: hr_utility.trace('ue_id ' ||

Line 6628: hr_utility.trace('report_category ' ||

6624: hr_utility.trace('report_type ' ||
6625: stu_rec.report_type);
6626: hr_utility.trace('report_qualifier ' ||
6627: stu_rec.report_qualifier);
6628: hr_utility.trace('report_category ' ||
6629: stu_rec.report_category);
6630: hr_utility.trace('ue_id ' ||
6631: to_char(stu_rec.user_entity_id));
6632: hrrunprc_trace_off;

Line 6630: hr_utility.trace('ue_id ' ||

6626: hr_utility.trace('report_qualifier ' ||
6627: stu_rec.report_qualifier);
6628: hr_utility.trace('report_category ' ||
6629: stu_rec.report_category);
6630: hr_utility.trace('ue_id ' ||
6631: to_char(stu_rec.user_entity_id));
6632: hrrunprc_trace_off;
6633: raise;
6634: END;

Line 6693: hr_utility.trace('start hr_legislation.install: ' || to_char(p_phase));

6689: IF maintain_history(p_phase) THEN
6690:
6691: -- Install all formula ditionary
6692: hrrunprc_trace_on;
6693: hr_utility.trace('start hr_legislation.install: ' || to_char(p_phase));
6694: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));
6695: hrrunprc_trace_off;
6696: ff_data_dict.install(p_phase);
6697:

Line 6694: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));

6690:
6691: -- Install all formula ditionary
6692: hrrunprc_trace_on;
6693: hr_utility.trace('start hr_legislation.install: ' || to_char(p_phase));
6694: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));
6695: hrrunprc_trace_off;
6696: ff_data_dict.install(p_phase);
6697:
6698: -- Install assignment status types

Line 6700: hr_utility.trace('start install_past: ' || to_char(p_phase));

6696: ff_data_dict.install(p_phase);
6697:
6698: -- Install assignment status types
6699: hrrunprc_trace_on;
6700: hr_utility.trace('start install_past: ' || to_char(p_phase));
6701: hrrunprc_trace_off;
6702: install_past(p_phase);
6703:
6704: -- Benefits

Line 6706: hr_utility.trace('start hr_legislation_benefits.install: ' || to_char(p_phase));

6702: install_past(p_phase);
6703:
6704: -- Benefits
6705: hrrunprc_trace_on;
6706: hr_utility.trace('start hr_legislation_benefits.install: ' || to_char(p_phase));
6707: hrrunprc_trace_off;
6708: hr_legislation_benefits.install(p_phase);
6709:
6710: -- Elements

Line 6712: hr_utility.trace('start hr_legislation_elements.install: ' || to_char(p_phase));

6708: hr_legislation_benefits.install(p_phase);
6709:
6710: -- Elements
6711: hrrunprc_trace_on;
6712: hr_utility.trace('start hr_legislation_elements.install: ' || to_char(p_phase));
6713: hrrunprc_trace_off;
6714: hr_legislation_elements.install(p_phase);
6715:
6716: -- Install payment types

Line 6718: hr_utility.trace('start install_payment_types: ' || to_char(p_phase));

6714: hr_legislation_elements.install(p_phase);
6715:
6716: -- Install payment types
6717: hrrunprc_trace_on;
6718: hr_utility.trace('start install_payment_types: ' || to_char(p_phase));
6719: hrrunprc_trace_off;
6720: install_payment_types(p_phase);
6721:
6722: -- Install user rows

Line 6724: hr_utility.trace('start install_urows: ' || to_char(p_phase));

6720: install_payment_types(p_phase);
6721:
6722: -- Install user rows
6723: hrrunprc_trace_on;
6724: hr_utility.trace('start install_urows: ' || to_char(p_phase));
6725: hrrunprc_trace_off;
6726: install_urows(p_phase);
6727:
6728: -- Balance dimensions

Line 6730: hr_utility.trace('start install_dimensions: ' || to_char(p_phase));

6726: install_urows(p_phase);
6727:
6728: -- Balance dimensions
6729: hrrunprc_trace_on;
6730: hr_utility.trace('start install_dimensions: ' || to_char(p_phase));
6731: hrrunprc_trace_off;
6732: install_dimensions(p_phase);
6733:
6734: -- Install dimension routes

Line 6736: hr_utility.trace('start install_dimension_routes: ' || to_char(p_phase));

6732: install_dimensions(p_phase);
6733:
6734: -- Install dimension routes
6735: hrrunprc_trace_on;
6736: hr_utility.trace('start install_dimension_routes: ' || to_char(p_phase));
6737: hrrunprc_trace_off;
6738: install_dimension_routes(p_phase);
6739:
6740: -- Install balance categories

Line 6742: hr_utility.trace('start install_bal_categories: ' || to_char(p_phase));

6738: install_dimension_routes(p_phase);
6739:
6740: -- Install balance categories
6741: hrrunprc_trace_on;
6742: hr_utility.trace('start install_bal_categories: ' || to_char(p_phase));
6743: hrrunprc_trace_off;
6744: install_bal_categories(p_phase);
6745:
6746: -- Install balances,classes,defined,feeds

Line 6748: hr_utility.trace('start install_bal_types: ' || to_char(p_phase));

6744: install_bal_categories(p_phase);
6745:
6746: -- Install balances,classes,defined,feeds
6747: hrrunprc_trace_on;
6748: hr_utility.trace('start install_bal_types: ' || to_char(p_phase));
6749: hrrunprc_trace_off;
6750: install_bal_types(p_phase);
6751:
6752: -- Localization hook

Line 6754: hr_utility.trace('start hr_legislation_local: ' || to_char(p_phase));

6750: install_bal_types(p_phase);
6751:
6752: -- Localization hook
6753: hrrunprc_trace_on;
6754: hr_utility.trace('start hr_legislation_local: ' || to_char(p_phase));
6755: hrrunprc_trace_off;
6756: hr_legislation_local.install(p_phase);
6757:
6758: -- Install hr org info details

Line 6760: hr_utility.trace('start install_org_info: ' || to_char(p_phase));

6756: hr_legislation_local.install(p_phase);
6757:
6758: -- Install hr org info details
6759: hrrunprc_trace_on;
6760: hr_utility.trace('start install_org_info: ' || to_char(p_phase));
6761: hrrunprc_trace_off;
6762: install_org_info(p_phase);
6763:
6764: -- Install assignment extra info

Line 6766: hr_utility.trace('start install_ass_info: ' || to_char(p_phase));

6762: install_org_info(p_phase);
6763:
6764: -- Install assignment extra info
6765: hrrunprc_trace_on;
6766: hr_utility.trace('start install_ass_info: ' || to_char(p_phase));
6767: hrrunprc_trace_off;
6768: install_ass_info(p_phase);
6769:
6770: -- Install legislative field info

Line 6772: hr_utility.trace('start install_leg_field: ' || to_char(p_phase));

6768: install_ass_info(p_phase);
6769:
6770: -- Install legislative field info
6771: hrrunprc_trace_on;
6772: hr_utility.trace('start install_leg_field: ' || to_char(p_phase));
6773: hrrunprc_trace_off;
6774: install_leg_field(p_phase);
6775:
6776: -- Install monetary units

Line 6778: hr_utility.trace('start install_monetary: ' || to_char(p_phase));

6774: install_leg_field(p_phase);
6775:
6776: -- Install monetary units
6777: hrrunprc_trace_on;
6778: hr_utility.trace('start install_monetary: ' || to_char(p_phase));
6779: hrrunprc_trace_off;
6780: install_monetary(p_phase);
6781:
6782: -- install report_format_mappings

Line 6784: hr_utility.trace('start install_report_mappings: ' || to_char(p_phase));

6780: install_monetary(p_phase);
6781:
6782: -- install report_format_mappings
6783: hrrunprc_trace_on;
6784: hr_utility.trace('start install_report_mappings: ' || to_char(p_phase));
6785: hrrunprc_trace_off;
6786: install_report_mappings(p_phase);
6787:
6788: -- install report_items

Line 6790: hr_utility.trace('start install_report_items: ' || to_char(p_phase));

6786: install_report_mappings(p_phase);
6787:
6788: -- install report_items
6789: hrrunprc_trace_on;
6790: hr_utility.trace('start install_report_items: ' || to_char(p_phase));
6791: hrrunprc_trace_off;
6792: install_report_items(p_phase);
6793:
6794: -- install magnetic blocks and records

Line 6796: hr_utility.trace('start install_magnetic_blocks: ' || to_char(p_phase));

6792: install_report_items(p_phase);
6793:
6794: -- install magnetic blocks and records
6795: hrrunprc_trace_on;
6796: hr_utility.trace('start install_magnetic_blocks: ' || to_char(p_phase));
6797: hrrunprc_trace_off;
6798: install_magnetic_blocks(p_phase);
6799:
6800: -- install magnetic_records

Line 6802: hr_utility.trace('start install_magnetic_records: ' || to_char(p_phase));

6798: install_magnetic_blocks(p_phase);
6799:
6800: -- install magnetic_records
6801: hrrunprc_trace_on;
6802: hr_utility.trace('start install_magnetic_records: ' || to_char(p_phase));
6803: hrrunprc_trace_off;
6804: install_magnetic_records(p_phase);
6805:
6806: -- Install lookup types/codes/usages

Line 6850: hr_utility.trace('exit hr_legislation.install: ' || to_char(p_phase));

6846:
6847: END IF; -- end exception check
6848:
6849: hrrunprc_trace_on;
6850: hr_utility.trace('exit hr_legislation.install: ' || to_char(p_phase));
6851: hrrunprc_trace_off;
6852:
6853: ELSE -- error occured in maintain history
6854: rollback;

Line 7851: hr_utility.set_Location('hr_legislation.install2',20);

7847: install(1);
7848:
7849: -- check for the existance of any exceptions after phase 1
7850:
7851: hr_utility.set_Location('hr_legislation.install2',20);
7852:
7853: select count(*)
7854: into v_exception_counter
7855: from hr_stu_exceptions;

Line 7859: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');

7855: from hr_stu_exceptions;
7856:
7857: IF v_exception_counter > 0 THEN
7858:
7859: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7860: hr_utility.set_message_token('PHASE_NUMBER','1');
7861: hr_utility.raise_error;
7862:
7863: END IF;

Line 7860: hr_utility.set_message_token('PHASE_NUMBER','1');

7856:
7857: IF v_exception_counter > 0 THEN
7858:
7859: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7860: hr_utility.set_message_token('PHASE_NUMBER','1');
7861: hr_utility.raise_error;
7862:
7863: END IF;
7864:

Line 7861: hr_utility.raise_error;

7857: IF v_exception_counter > 0 THEN
7858:
7859: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7860: hr_utility.set_message_token('PHASE_NUMBER','1');
7861: hr_utility.raise_error;
7862:
7863: END IF;
7864:
7865: -- perform phase 2 of the installation

Line 7867: hr_utility.set_Location('hr_legislation.install2',40);

7863: END IF;
7864:
7865: -- perform phase 2 of the installation
7866:
7867: hr_utility.set_Location('hr_legislation.install2',40);
7868:
7869: install(2);
7870:
7871: -- check for the existance of exceptions after phase 2

Line 7873: hr_utility.set_Location('hr_legislation.install2',50);

7869: install(2);
7870:
7871: -- check for the existance of exceptions after phase 2
7872:
7873: hr_utility.set_Location('hr_legislation.install2',50);
7874:
7875: select count(*)
7876: into v_exception_counter
7877: from hr_stu_exceptions;

Line 7881: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');

7877: from hr_stu_exceptions;
7878:
7879: IF v_exception_counter > 0 THEN
7880:
7881: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7882: hr_utility.set_message_token('PHASE_NUMBER','2');
7883: hr_utility.raise_error;
7884:
7885: END IF;

Line 7882: hr_utility.set_message_token('PHASE_NUMBER','2');

7878:
7879: IF v_exception_counter > 0 THEN
7880:
7881: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7882: hr_utility.set_message_token('PHASE_NUMBER','2');
7883: hr_utility.raise_error;
7884:
7885: END IF;
7886:

Line 7883: hr_utility.raise_error;

7879: IF v_exception_counter > 0 THEN
7880:
7881: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7882: hr_utility.set_message_token('PHASE_NUMBER','2');
7883: hr_utility.raise_error;
7884:
7885: END IF;
7886:
7887: -- Move the hr_s_application_ownership data to the HR_APPLICATION_OWNERSHIP