APPS.HR_LEGISLATION dependencies on HR_UTILITY

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

393:
394: PROCEDURE hrrunprc_trace_on is
395: begin
396: if hr_legislation.g_debug_cnt > 0 then
397: hr_utility.trace_on(null, 'HRRUNPRC');
398: end if;
399: end;
400:
401: PROCEDURE hrrunprc_trace_off is

Line 404: hr_utility.trace_off;

400:
401: PROCEDURE hrrunprc_trace_off is
402: begin
403: if hr_legislation.g_debug_cnt > 0 then
404: hr_utility.trace_off;
405: end if;
406: end;
407:
408: PROCEDURE insert_hr_stu_exceptions (p_table_name varchar2,

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

514: IS
515: BEGIN
516:
517: hrrunprc_trace_on;
518: hr_utility.trace('enter: zz_leg_rule');
519: hrrunprc_trace_off;
520:
521: INSERT INTO hr_application_ownerships
522: (key_name

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

594: AND ao2.product_name = ao.product_name
595: AND ao2.key_value = ao.key_value);
596:
597: hrrunprc_trace_on;
598: hr_utility.trace('exit: zz_leg_rule');
599: hrrunprc_trace_off;
600:
601: END create_zz_leg_rule;
602:

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

789: into l_new_surrogate_key
790: from dual;
791: WHEN TOO_MANY_ROWS THEN
792: hrrunprc_trace_on;
793: hr_utility.trace('sel per_assignment_status_types TMR');
794:
795: hr_utility.trace('user_status ' ||
796: stu_rec.user_status);
797: hr_utility.trace('per_system_status ' ||

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

791: WHEN TOO_MANY_ROWS THEN
792: hrrunprc_trace_on;
793: hr_utility.trace('sel per_assignment_status_types TMR');
794:
795: hr_utility.trace('user_status ' ||
796: stu_rec.user_status);
797: hr_utility.trace('per_system_status ' ||
798: stu_rec.per_system_status);
799: hr_utility.trace('pay_system_status ' ||

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

793: hr_utility.trace('sel per_assignment_status_types TMR');
794:
795: hr_utility.trace('user_status ' ||
796: stu_rec.user_status);
797: hr_utility.trace('per_system_status ' ||
798: stu_rec.per_system_status);
799: hr_utility.trace('pay_system_status ' ||
800: stu_rec.pay_system_status);
801: hr_utility.trace(':lc: ' || ':' ||

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

795: hr_utility.trace('user_status ' ||
796: stu_rec.user_status);
797: hr_utility.trace('per_system_status ' ||
798: stu_rec.per_system_status);
799: hr_utility.trace('pay_system_status ' ||
800: stu_rec.pay_system_status);
801: hr_utility.trace(':lc: ' || ':' ||
802: stu_rec.c_leg_code || ':');
803: hrrunprc_trace_off;

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

797: hr_utility.trace('per_system_status ' ||
798: stu_rec.per_system_status);
799: hr_utility.trace('pay_system_status ' ||
800: stu_rec.pay_system_status);
801: hr_utility.trace(':lc: ' || ':' ||
802: stu_rec.c_leg_code || ':');
803: hrrunprc_trace_off;
804: raise;
805: END;

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

1450: ,nvl(each_row.USER_CATEGORY_NAME,
1451: each_row.CATEGORY_NAME));
1452: EXCEPTION WHEN OTHERS THEN
1453: hrrunprc_trace_on;
1454: hr_utility.trace('ins pay_balance_categories');
1455: hr_utility.trace('cat id: ' ||
1456: to_char(each_row.BALANCE_CATEGORY_ID));
1457: hr_utility.trace('cat name ' ||
1458: each_row.CATEGORY_NAME);

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

1451: each_row.CATEGORY_NAME));
1452: EXCEPTION WHEN OTHERS THEN
1453: hrrunprc_trace_on;
1454: hr_utility.trace('ins pay_balance_categories');
1455: hr_utility.trace('cat id: ' ||
1456: to_char(each_row.BALANCE_CATEGORY_ID));
1457: hr_utility.trace('cat name ' ||
1458: each_row.CATEGORY_NAME);
1459: hr_utility.trace(':lc:bg: ' || ':' ||

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

1453: hrrunprc_trace_on;
1454: hr_utility.trace('ins pay_balance_categories');
1455: hr_utility.trace('cat id: ' ||
1456: to_char(each_row.BALANCE_CATEGORY_ID));
1457: hr_utility.trace('cat name ' ||
1458: each_row.CATEGORY_NAME);
1459: hr_utility.trace(':lc:bg: ' || ':' ||
1460: each_row.LEGISLATION_CODE || ':' ||
1461: to_char(each_row.BUSINESS_GROUP_ID) || ':');

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

1455: hr_utility.trace('cat id: ' ||
1456: to_char(each_row.BALANCE_CATEGORY_ID));
1457: hr_utility.trace('cat name ' ||
1458: each_row.CATEGORY_NAME);
1459: hr_utility.trace(':lc:bg: ' || ':' ||
1460: each_row.LEGISLATION_CODE || ':' ||
1461: to_char(each_row.BUSINESS_GROUP_ID) || ':');
1462: hrrunprc_trace_off;
1463: raise;

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

1781: v_new_balance_type_flag := 'Y';
1782:
1783: WHEN TOO_MANY_ROWS THEN
1784: hrrunprc_trace_on;
1785: hr_utility.trace('sel pay_balance_types TMR');
1786: hr_utility.trace('balance_name ' ||
1787: stu_rec.c_true_key);
1788: hr_utility.trace(':lc: ' || ':' ||
1789: stu_rec.c_leg_code || ':');

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

1782:
1783: WHEN TOO_MANY_ROWS THEN
1784: hrrunprc_trace_on;
1785: hr_utility.trace('sel pay_balance_types TMR');
1786: hr_utility.trace('balance_name ' ||
1787: stu_rec.c_true_key);
1788: hr_utility.trace(':lc: ' || ':' ||
1789: stu_rec.c_leg_code || ':');
1790: hrrunprc_trace_off;

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

1784: hrrunprc_trace_on;
1785: hr_utility.trace('sel pay_balance_types TMR');
1786: hr_utility.trace('balance_name ' ||
1787: stu_rec.c_true_key);
1788: hr_utility.trace(':lc: ' || ':' ||
1789: stu_rec.c_leg_code || ':');
1790: hrrunprc_trace_off;
1791: raise;
1792: END;

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

1841: from dual;
1842:
1843: WHEN TOO_MANY_ROWS THEN
1844: hrrunprc_trace_on;
1845: hr_utility.trace('sel pay_defined_balances TMR');
1846: hr_utility.trace('balance_type_id ' ||
1847: to_char(l_new_surrogate_key));
1848: hr_utility.trace('balance_name ' ||
1849: stu_rec.c_true_key);

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

1842:
1843: WHEN TOO_MANY_ROWS THEN
1844: hrrunprc_trace_on;
1845: hr_utility.trace('sel pay_defined_balances TMR');
1846: hr_utility.trace('balance_type_id ' ||
1847: to_char(l_new_surrogate_key));
1848: hr_utility.trace('balance_name ' ||
1849: stu_rec.c_true_key);
1850: hr_utility.trace('balance_dimension_id ' ||

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

1844: hrrunprc_trace_on;
1845: hr_utility.trace('sel pay_defined_balances TMR');
1846: hr_utility.trace('balance_type_id ' ||
1847: to_char(l_new_surrogate_key));
1848: hr_utility.trace('balance_name ' ||
1849: stu_rec.c_true_key);
1850: hr_utility.trace('balance_dimension_id ' ||
1851: to_char(def_bals.balance_dimension_id));
1852: hr_utility.trace(':lc: ' || ':' ||

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

1846: hr_utility.trace('balance_type_id ' ||
1847: to_char(l_new_surrogate_key));
1848: hr_utility.trace('balance_name ' ||
1849: stu_rec.c_true_key);
1850: hr_utility.trace('balance_dimension_id ' ||
1851: to_char(def_bals.balance_dimension_id));
1852: hr_utility.trace(':lc: ' || ':' ||
1853: def_bals.legislation_code || ':');
1854: hrrunprc_trace_off;

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

1848: hr_utility.trace('balance_name ' ||
1849: stu_rec.c_true_key);
1850: hr_utility.trace('balance_dimension_id ' ||
1851: to_char(def_bals.balance_dimension_id));
1852: hr_utility.trace(':lc: ' || ':' ||
1853: def_bals.legislation_code || ':');
1854: hrrunprc_trace_off;
1855: raise;
1856: END;

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

2169: ,stu_rec.base_balance_type_id
2170: ,stu_rec.balance_category_id);
2171: EXCEPTION WHEN OTHERS THEN
2172: hrrunprc_trace_on;
2173: hr_utility.trace('ins pay_balance_types');
2174: hr_utility.trace('bal type id: ' ||
2175: to_char(stu_rec.c_surrogate_key));
2176: hr_utility.trace('bal type name ' ||
2177: stu_rec.c_true_key);

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

2170: ,stu_rec.balance_category_id);
2171: EXCEPTION WHEN OTHERS THEN
2172: hrrunprc_trace_on;
2173: hr_utility.trace('ins pay_balance_types');
2174: hr_utility.trace('bal type id: ' ||
2175: to_char(stu_rec.c_surrogate_key));
2176: hr_utility.trace('bal type name ' ||
2177: stu_rec.c_true_key);
2178: hr_utility.trace(':lc: ' || ':' ||

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

2172: hrrunprc_trace_on;
2173: hr_utility.trace('ins pay_balance_types');
2174: hr_utility.trace('bal type id: ' ||
2175: to_char(stu_rec.c_surrogate_key));
2176: hr_utility.trace('bal type name ' ||
2177: stu_rec.c_true_key);
2178: hr_utility.trace(':lc: ' || ':' ||
2179: stu_rec.c_leg_code || ':');
2180: hrrunprc_trace_off;

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

2174: hr_utility.trace('bal type id: ' ||
2175: to_char(stu_rec.c_surrogate_key));
2176: hr_utility.trace('bal type name ' ||
2177: stu_rec.c_true_key);
2178: hr_utility.trace(':lc: ' || ':' ||
2179: stu_rec.c_leg_code || ':');
2180: hrrunprc_trace_off;
2181: raise;
2182: END;

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

2263: , bal_classes.creation_date
2264: from dual;
2265: EXCEPTION WHEN OTHERS THEN
2266: hrrunprc_trace_on;
2267: hr_utility.trace('ins pay_balance_class');
2268: hr_utility.trace('bal type id ' ||
2269: to_char(bal_classes.balance_type_id));
2270: hr_utility.trace('bal type name ' ||
2271: stu_rec.c_true_key);

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

2264: from dual;
2265: EXCEPTION WHEN OTHERS THEN
2266: hrrunprc_trace_on;
2267: hr_utility.trace('ins pay_balance_class');
2268: hr_utility.trace('bal type id ' ||
2269: to_char(bal_classes.balance_type_id));
2270: hr_utility.trace('bal type name ' ||
2271: stu_rec.c_true_key);
2272: hr_utility.trace('bal class id ' ||

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

2266: hrrunprc_trace_on;
2267: hr_utility.trace('ins pay_balance_class');
2268: hr_utility.trace('bal type id ' ||
2269: to_char(bal_classes.balance_type_id));
2270: hr_utility.trace('bal type name ' ||
2271: stu_rec.c_true_key);
2272: hr_utility.trace('bal class id ' ||
2273: to_char(bal_classes.classification_id));
2274: hr_utility.trace('bal class scale ' ||

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

2268: hr_utility.trace('bal type id ' ||
2269: to_char(bal_classes.balance_type_id));
2270: hr_utility.trace('bal type name ' ||
2271: stu_rec.c_true_key);
2272: hr_utility.trace('bal class id ' ||
2273: to_char(bal_classes.classification_id));
2274: hr_utility.trace('bal class scale ' ||
2275: to_char(bal_classes.scale));
2276: hr_utility.trace(':lc: ' || ':' ||

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

2270: hr_utility.trace('bal type name ' ||
2271: stu_rec.c_true_key);
2272: hr_utility.trace('bal class id ' ||
2273: to_char(bal_classes.classification_id));
2274: hr_utility.trace('bal class scale ' ||
2275: to_char(bal_classes.scale));
2276: hr_utility.trace(':lc: ' || ':' ||
2277: bal_classes.legislation_code || ':');
2278: hrrunprc_trace_off;

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

2272: hr_utility.trace('bal class id ' ||
2273: to_char(bal_classes.classification_id));
2274: hr_utility.trace('bal class scale ' ||
2275: to_char(bal_classes.scale));
2276: hr_utility.trace(':lc: ' || ':' ||
2277: bal_classes.legislation_code || ':');
2278: hrrunprc_trace_off;
2279: raise;
2280: END;

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

2375: ,def_bals.save_run_balance
2376: ,def_bals.run_balance_status);
2377: EXCEPTION WHEN OTHERS THEN
2378: hrrunprc_trace_on;
2379: hr_utility.trace('ins pay_def_bal');
2380: hr_utility.trace('def bal id ' ||
2381: to_char(def_bals.defined_balance_id));
2382: hr_utility.trace('bal type id ' ||
2383: to_char(def_bals.balance_type_id));

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

2376: ,def_bals.run_balance_status);
2377: EXCEPTION WHEN OTHERS THEN
2378: hrrunprc_trace_on;
2379: hr_utility.trace('ins pay_def_bal');
2380: hr_utility.trace('def bal id ' ||
2381: to_char(def_bals.defined_balance_id));
2382: hr_utility.trace('bal type id ' ||
2383: to_char(def_bals.balance_type_id));
2384: hr_utility.trace('bal type name ' ||

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

2378: hrrunprc_trace_on;
2379: hr_utility.trace('ins pay_def_bal');
2380: hr_utility.trace('def bal id ' ||
2381: to_char(def_bals.defined_balance_id));
2382: hr_utility.trace('bal type id ' ||
2383: to_char(def_bals.balance_type_id));
2384: hr_utility.trace('bal type name ' ||
2385: stu_rec.c_true_key);
2386: hr_utility.trace('bal dim id ' ||

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

2380: hr_utility.trace('def bal id ' ||
2381: to_char(def_bals.defined_balance_id));
2382: hr_utility.trace('bal type id ' ||
2383: to_char(def_bals.balance_type_id));
2384: hr_utility.trace('bal type name ' ||
2385: stu_rec.c_true_key);
2386: hr_utility.trace('bal dim id ' ||
2387: to_char(def_bals.balance_dimension_id));
2388: hr_utility.trace('save_run_balance ' ||

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

2382: hr_utility.trace('bal type id ' ||
2383: to_char(def_bals.balance_type_id));
2384: hr_utility.trace('bal type name ' ||
2385: stu_rec.c_true_key);
2386: hr_utility.trace('bal dim id ' ||
2387: to_char(def_bals.balance_dimension_id));
2388: hr_utility.trace('save_run_balance ' ||
2389: def_bals.save_run_balance);
2390: hr_utility.trace(':lc: ' || ':' ||

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

2384: hr_utility.trace('bal type name ' ||
2385: stu_rec.c_true_key);
2386: hr_utility.trace('bal dim id ' ||
2387: to_char(def_bals.balance_dimension_id));
2388: hr_utility.trace('save_run_balance ' ||
2389: def_bals.save_run_balance);
2390: hr_utility.trace(':lc: ' || ':' ||
2391: def_bals.legislation_code || ':');
2392: hrrunprc_trace_off;

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

2386: hr_utility.trace('bal dim id ' ||
2387: to_char(def_bals.balance_dimension_id));
2388: hr_utility.trace('save_run_balance ' ||
2389: def_bals.save_run_balance);
2390: hr_utility.trace(':lc: ' || ':' ||
2391: def_bals.legislation_code || ':');
2392: hrrunprc_trace_off;
2393: raise;
2394: END;

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

2486: ,bal_feeds.creation_date
2487: from dual;
2488: EXCEPTION WHEN OTHERS THEN
2489: hrrunprc_trace_on;
2490: hr_utility.trace('ins pay_bal_feed');
2491: hr_utility.trace('bal type id ' ||
2492: to_char(bal_feeds.balance_type_id));
2493: hr_utility.trace('bal type name ' ||
2494: stu_rec.c_true_key);

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

2487: from dual;
2488: EXCEPTION WHEN OTHERS THEN
2489: hrrunprc_trace_on;
2490: hr_utility.trace('ins pay_bal_feed');
2491: hr_utility.trace('bal type id ' ||
2492: to_char(bal_feeds.balance_type_id));
2493: hr_utility.trace('bal type name ' ||
2494: stu_rec.c_true_key);
2495: hr_utility.trace('input value id ' ||

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

2489: hrrunprc_trace_on;
2490: hr_utility.trace('ins pay_bal_feed');
2491: hr_utility.trace('bal type id ' ||
2492: to_char(bal_feeds.balance_type_id));
2493: hr_utility.trace('bal type name ' ||
2494: stu_rec.c_true_key);
2495: hr_utility.trace('input value id ' ||
2496: to_char(bal_feeds.input_value_id));
2497: hr_utility.trace(':lc: ' || ':' ||

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

2491: hr_utility.trace('bal type id ' ||
2492: to_char(bal_feeds.balance_type_id));
2493: hr_utility.trace('bal type name ' ||
2494: stu_rec.c_true_key);
2495: hr_utility.trace('input value id ' ||
2496: to_char(bal_feeds.input_value_id));
2497: hr_utility.trace(':lc: ' || ':' ||
2498: bal_feeds.legislation_code || ':');
2499: hrrunprc_trace_off;

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

2493: hr_utility.trace('bal type name ' ||
2494: stu_rec.c_true_key);
2495: hr_utility.trace('input value id ' ||
2496: to_char(bal_feeds.input_value_id));
2497: hr_utility.trace(':lc: ' || ':' ||
2498: bal_feeds.legislation_code || ':');
2499: hrrunprc_trace_off;
2500: raise;
2501: END;

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

2734: from dual;
2735:
2736: WHEN TOO_MANY_ROWS THEN
2737: hrrunprc_trace_on;
2738: hr_utility.trace('sel pay_balance_dimensions TMR');
2739: hr_utility.trace('dimension_name ' ||
2740: stu_rec.c_true_key);
2741: hr_utility.trace(':lc: ' || ':' ||
2742: stu_rec.c_leg_code || ':');

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

2735:
2736: WHEN TOO_MANY_ROWS THEN
2737: hrrunprc_trace_on;
2738: hr_utility.trace('sel pay_balance_dimensions TMR');
2739: hr_utility.trace('dimension_name ' ||
2740: stu_rec.c_true_key);
2741: hr_utility.trace(':lc: ' || ':' ||
2742: stu_rec.c_leg_code || ':');
2743: hrrunprc_trace_off;

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

2737: hrrunprc_trace_on;
2738: hr_utility.trace('sel pay_balance_dimensions TMR');
2739: hr_utility.trace('dimension_name ' ||
2740: stu_rec.c_true_key);
2741: hr_utility.trace(':lc: ' || ':' ||
2742: stu_rec.c_leg_code || ':');
2743: hrrunprc_trace_off;
2744: raise;
2745: END;

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

3152: ,stu_rec.save_run_balance_enabled
3153: ,stu_rec.start_date_code);
3154: EXCEPTION WHEN OTHERS THEN
3155: hrrunprc_trace_on;
3156: hr_utility.trace('ins pay_bal_dim');
3157: hr_utility.trace('bal dim id ' ||
3158: to_char(stu_rec.c_surrogate_key));
3159: hr_utility.trace('dimension name ' ||
3160: stu_rec.c_true_key);

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

3153: ,stu_rec.start_date_code);
3154: EXCEPTION WHEN OTHERS THEN
3155: hrrunprc_trace_on;
3156: hr_utility.trace('ins pay_bal_dim');
3157: hr_utility.trace('bal dim id ' ||
3158: to_char(stu_rec.c_surrogate_key));
3159: hr_utility.trace('dimension name ' ||
3160: stu_rec.c_true_key);
3161: hr_utility.trace('dbi suffix ' ||

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

3155: hrrunprc_trace_on;
3156: hr_utility.trace('ins pay_bal_dim');
3157: hr_utility.trace('bal dim id ' ||
3158: to_char(stu_rec.c_surrogate_key));
3159: hr_utility.trace('dimension name ' ||
3160: stu_rec.c_true_key);
3161: hr_utility.trace('dbi suffix ' ||
3162: stu_rec.database_item_suffix);
3163: hr_utility.trace('save_run_balance_enabled ' ||

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

3157: hr_utility.trace('bal dim id ' ||
3158: to_char(stu_rec.c_surrogate_key));
3159: hr_utility.trace('dimension name ' ||
3160: stu_rec.c_true_key);
3161: hr_utility.trace('dbi suffix ' ||
3162: stu_rec.database_item_suffix);
3163: hr_utility.trace('save_run_balance_enabled ' ||
3164: stu_rec.save_run_balance_enabled);
3165: hr_utility.trace(':lc: ' || ':' ||

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

3159: hr_utility.trace('dimension name ' ||
3160: stu_rec.c_true_key);
3161: hr_utility.trace('dbi suffix ' ||
3162: stu_rec.database_item_suffix);
3163: hr_utility.trace('save_run_balance_enabled ' ||
3164: stu_rec.save_run_balance_enabled);
3165: hr_utility.trace(':lc: ' || ':' ||
3166: stu_rec.c_leg_code || ':');
3167: hrrunprc_trace_off;

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

3161: hr_utility.trace('dbi suffix ' ||
3162: stu_rec.database_item_suffix);
3163: hr_utility.trace('save_run_balance_enabled ' ||
3164: stu_rec.save_run_balance_enabled);
3165: hr_utility.trace(':lc: ' || ':' ||
3166: stu_rec.c_leg_code || ':');
3167: hrrunprc_trace_off;
3168: raise;
3169: END;

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

3407: ,stu_rec.BALANCE_TYPE_COLUMN
3408: ,stu_rec.DECODE_REQUIRED);
3409: EXCEPTION WHEN OTHERS THEN
3410: hrrunprc_trace_on;
3411: hr_utility.trace('ins pay dim routes');
3412: hr_utility.trace('bal dim id ' ||
3413: to_char(stu_rec.BALANCE_DIMENSION_ID));
3414: hr_utility.trace('route id ' ||
3415: to_char(stu_rec.ROUTE_ID));

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

3408: ,stu_rec.DECODE_REQUIRED);
3409: EXCEPTION WHEN OTHERS THEN
3410: hrrunprc_trace_on;
3411: hr_utility.trace('ins pay dim routes');
3412: hr_utility.trace('bal dim id ' ||
3413: to_char(stu_rec.BALANCE_DIMENSION_ID));
3414: hr_utility.trace('route id ' ||
3415: to_char(stu_rec.ROUTE_ID));
3416: hr_utility.trace('priority ' ||

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

3410: hrrunprc_trace_on;
3411: hr_utility.trace('ins pay dim routes');
3412: hr_utility.trace('bal dim id ' ||
3413: to_char(stu_rec.BALANCE_DIMENSION_ID));
3414: hr_utility.trace('route id ' ||
3415: to_char(stu_rec.ROUTE_ID));
3416: hr_utility.trace('priority ' ||
3417: to_char(stu_rec.PRIORITY));
3418: hr_utility.trace('route type ' ||

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

3412: hr_utility.trace('bal dim id ' ||
3413: to_char(stu_rec.BALANCE_DIMENSION_ID));
3414: hr_utility.trace('route id ' ||
3415: to_char(stu_rec.ROUTE_ID));
3416: hr_utility.trace('priority ' ||
3417: to_char(stu_rec.PRIORITY));
3418: hr_utility.trace('route type ' ||
3419: stu_rec.ROUTE_TYPE);
3420: hrrunprc_trace_off;

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

3414: hr_utility.trace('route id ' ||
3415: to_char(stu_rec.ROUTE_ID));
3416: hr_utility.trace('priority ' ||
3417: to_char(stu_rec.PRIORITY));
3418: hr_utility.trace('route type ' ||
3419: stu_rec.ROUTE_TYPE);
3420: hrrunprc_trace_off;
3421: raise;
3422: END;

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

3785: ,stu_rec.multiple_occurences_flag
3786: );
3787: EXCEPTION WHEN OTHERS THEN
3788: hrrunprc_trace_on;
3789: hr_utility.trace('ins per_ass_info_type');
3790: hr_utility.trace('information_type ' ||
3791: stu_rec.c_true_key);
3792: hr_utility.trace(':lc: ' || ':' ||
3793: stu_rec.c_leg_code || ':');

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

3786: );
3787: EXCEPTION WHEN OTHERS THEN
3788: hrrunprc_trace_on;
3789: hr_utility.trace('ins per_ass_info_type');
3790: hr_utility.trace('information_type ' ||
3791: stu_rec.c_true_key);
3792: hr_utility.trace(':lc: ' || ':' ||
3793: stu_rec.c_leg_code || ':');
3794: hrrunprc_trace_off;

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

3788: hrrunprc_trace_on;
3789: hr_utility.trace('ins per_ass_info_type');
3790: hr_utility.trace('information_type ' ||
3791: stu_rec.c_true_key);
3792: hr_utility.trace(':lc: ' || ':' ||
3793: stu_rec.c_leg_code || ':');
3794: hrrunprc_trace_off;
3795: raise;
3796: END;

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

3911: and nvl(target_location,'~') = nvl(stu_rec.target_location,'~')
3912: and nvl(validation_name,'~') = nvl(stu_rec.validation_name,'~');
3913: EXCEPTION WHEN TOO_MANY_ROWS THEN
3914: hrrunprc_trace_on;
3915: hr_utility.trace('sel pay_legislative_field_info TMR');
3916: hr_utility.trace('field_name ' ||
3917: stu_rec.field_name);
3918: hr_utility.trace('rule_type ' ||
3919: stu_rec.rule_type);

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

3912: and nvl(validation_name,'~') = nvl(stu_rec.validation_name,'~');
3913: EXCEPTION WHEN TOO_MANY_ROWS THEN
3914: hrrunprc_trace_on;
3915: hr_utility.trace('sel pay_legislative_field_info TMR');
3916: hr_utility.trace('field_name ' ||
3917: stu_rec.field_name);
3918: hr_utility.trace('rule_type ' ||
3919: stu_rec.rule_type);
3920: hr_utility.trace('target_location ' ||

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

3914: hrrunprc_trace_on;
3915: hr_utility.trace('sel pay_legislative_field_info TMR');
3916: hr_utility.trace('field_name ' ||
3917: stu_rec.field_name);
3918: hr_utility.trace('rule_type ' ||
3919: stu_rec.rule_type);
3920: hr_utility.trace('target_location ' ||
3921: stu_rec.target_location);
3922: hr_utility.trace('validation_name ' ||

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

3916: hr_utility.trace('field_name ' ||
3917: stu_rec.field_name);
3918: hr_utility.trace('rule_type ' ||
3919: stu_rec.rule_type);
3920: hr_utility.trace('target_location ' ||
3921: stu_rec.target_location);
3922: hr_utility.trace('validation_name ' ||
3923: stu_rec.validation_name);
3924: hr_utility.trace(':lc: ' || ':' ||

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

3918: hr_utility.trace('rule_type ' ||
3919: stu_rec.rule_type);
3920: hr_utility.trace('target_location ' ||
3921: stu_rec.target_location);
3922: hr_utility.trace('validation_name ' ||
3923: stu_rec.validation_name);
3924: hr_utility.trace(':lc: ' || ':' ||
3925: stu_rec.legislation_code || ':');
3926: hrrunprc_trace_off;

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

3920: hr_utility.trace('target_location ' ||
3921: stu_rec.target_location);
3922: hr_utility.trace('validation_name ' ||
3923: stu_rec.validation_name);
3924: hr_utility.trace(':lc: ' || ':' ||
3925: stu_rec.legislation_code || ':');
3926: hrrunprc_trace_off;
3927: raise;
3928: END;

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

3998: ,stu_rec.CATEGORY
3999: );
4000: EXCEPTION WHEN OTHERS THEN
4001: hrrunprc_trace_on;
4002: hr_utility.trace('ins pay_leg_field_info');
4003: hr_utility.trace('field_name ' ||
4004: stu_rec.field_name);
4005: hr_utility.trace('rule_type ' ||
4006: stu_rec.rule_type);

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

3999: );
4000: EXCEPTION WHEN OTHERS THEN
4001: hrrunprc_trace_on;
4002: hr_utility.trace('ins pay_leg_field_info');
4003: hr_utility.trace('field_name ' ||
4004: stu_rec.field_name);
4005: hr_utility.trace('rule_type ' ||
4006: stu_rec.rule_type);
4007: hr_utility.trace('rule_mode ' ||

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

4001: hrrunprc_trace_on;
4002: hr_utility.trace('ins pay_leg_field_info');
4003: hr_utility.trace('field_name ' ||
4004: stu_rec.field_name);
4005: hr_utility.trace('rule_type ' ||
4006: stu_rec.rule_type);
4007: hr_utility.trace('rule_mode ' ||
4008: stu_rec.rule_mode);
4009: hr_utility.trace(':lc: ' || ':' ||

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

4003: hr_utility.trace('field_name ' ||
4004: stu_rec.field_name);
4005: hr_utility.trace('rule_type ' ||
4006: stu_rec.rule_type);
4007: hr_utility.trace('rule_mode ' ||
4008: stu_rec.rule_mode);
4009: hr_utility.trace(':lc: ' || ':' ||
4010: stu_rec.legislation_code || ':');
4011: hrrunprc_trace_off;

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

4005: hr_utility.trace('rule_type ' ||
4006: stu_rec.rule_type);
4007: hr_utility.trace('rule_mode ' ||
4008: stu_rec.rule_mode);
4009: hr_utility.trace(':lc: ' || ':' ||
4010: stu_rec.legislation_code || ':');
4011: hrrunprc_trace_off;
4012: raise;
4013: END;

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

4306: ,stu_rec.creation_date
4307: );
4308: EXCEPTION WHEN OTHERS THEN
4309: hrrunprc_trace_on;
4310: hr_utility.trace('ins payment_types');
4311: hr_utility.trace('type_id ' ||
4312: to_char(stu_rec.c_surrogate_key));
4313: hr_utility.trace('type_name ' ||
4314: stu_rec.c_true_key);

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

4307: );
4308: EXCEPTION WHEN OTHERS THEN
4309: hrrunprc_trace_on;
4310: hr_utility.trace('ins payment_types');
4311: hr_utility.trace('type_id ' ||
4312: to_char(stu_rec.c_surrogate_key));
4313: hr_utility.trace('type_name ' ||
4314: stu_rec.c_true_key);
4315: hr_utility.trace('currency_code ' ||

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

4309: hrrunprc_trace_on;
4310: hr_utility.trace('ins payment_types');
4311: hr_utility.trace('type_id ' ||
4312: to_char(stu_rec.c_surrogate_key));
4313: hr_utility.trace('type_name ' ||
4314: stu_rec.c_true_key);
4315: hr_utility.trace('currency_code ' ||
4316: stu_rec.currency_code);
4317: hrrunprc_trace_off;

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

4311: hr_utility.trace('type_id ' ||
4312: to_char(stu_rec.c_surrogate_key));
4313: hr_utility.trace('type_name ' ||
4314: stu_rec.c_true_key);
4315: hr_utility.trace('currency_code ' ||
4316: stu_rec.currency_code);
4317: hrrunprc_trace_off;
4318: raise;
4319: END;

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

4940: ,each_row.creation_date
4941: );
4942: EXCEPTION WHEN OTHERS THEN
4943: hrrunprc_trace_on;
4944: hr_utility.trace('ins pay_user_rows');
4945: hr_utility.trace('table_id ' ||
4946: to_char(each_row.user_table_id));
4947: hr_utility.trace('name ' ||
4948: each_row.row_low_range_or_name);

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

4941: );
4942: EXCEPTION WHEN OTHERS THEN
4943: hrrunprc_trace_on;
4944: hr_utility.trace('ins pay_user_rows');
4945: hr_utility.trace('table_id ' ||
4946: to_char(each_row.user_table_id));
4947: hr_utility.trace('name ' ||
4948: each_row.row_low_range_or_name);
4949: hr_utility.trace('high_range ' ||

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

4943: hrrunprc_trace_on;
4944: hr_utility.trace('ins pay_user_rows');
4945: hr_utility.trace('table_id ' ||
4946: to_char(each_row.user_table_id));
4947: hr_utility.trace('name ' ||
4948: each_row.row_low_range_or_name);
4949: hr_utility.trace('high_range ' ||
4950: each_row.row_high_range);
4951: hr_utility.trace(':lc: ' || ':' ||

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

4945: hr_utility.trace('table_id ' ||
4946: to_char(each_row.user_table_id));
4947: hr_utility.trace('name ' ||
4948: each_row.row_low_range_or_name);
4949: hr_utility.trace('high_range ' ||
4950: each_row.row_high_range);
4951: hr_utility.trace(':lc: ' || ':' ||
4952: each_row.legislation_code || ':');
4953: hr_utility.trace('eff start date ' ||

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

4947: hr_utility.trace('name ' ||
4948: each_row.row_low_range_or_name);
4949: hr_utility.trace('high_range ' ||
4950: each_row.row_high_range);
4951: hr_utility.trace(':lc: ' || ':' ||
4952: each_row.legislation_code || ':');
4953: hr_utility.trace('eff start date ' ||
4954: to_date(each_row.effective_start_date,'DD-MM-YYYY'));
4955: hrrunprc_trace_off;

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

4949: hr_utility.trace('high_range ' ||
4950: each_row.row_high_range);
4951: hr_utility.trace(':lc: ' || ':' ||
4952: each_row.legislation_code || ':');
4953: hr_utility.trace('eff start date ' ||
4954: to_date(each_row.effective_start_date,'DD-MM-YYYY'));
4955: hrrunprc_trace_off;
4956: raise;
4957: END;

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

5002: crt_exc('Parent Column not in live tables');
5003: RAISE row_in_error;
5004: WHEN OTHERS THEN
5005: hrrunprc_trace_on;
5006: hr_utility.trace('ins pay_user_col_inst');
5007: hr_utility.trace('value ' ||
5008: each_child.value);
5009: hr_utility.trace('column_id ' ||
5010: to_char(each_child.user_column_id));

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

5003: RAISE row_in_error;
5004: WHEN OTHERS THEN
5005: hrrunprc_trace_on;
5006: hr_utility.trace('ins pay_user_col_inst');
5007: hr_utility.trace('value ' ||
5008: each_child.value);
5009: hr_utility.trace('column_id ' ||
5010: to_char(each_child.user_column_id));
5011: hr_utility.trace('row id ' ||

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

5005: hrrunprc_trace_on;
5006: hr_utility.trace('ins pay_user_col_inst');
5007: hr_utility.trace('value ' ||
5008: each_child.value);
5009: hr_utility.trace('column_id ' ||
5010: to_char(each_child.user_column_id));
5011: hr_utility.trace('row id ' ||
5012: to_char(r_distinct.c_surrogate_key));
5013: hr_utility.trace('row low range ' ||

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

5007: hr_utility.trace('value ' ||
5008: each_child.value);
5009: hr_utility.trace('column_id ' ||
5010: to_char(each_child.user_column_id));
5011: hr_utility.trace('row id ' ||
5012: to_char(r_distinct.c_surrogate_key));
5013: hr_utility.trace('row low range ' ||
5014: r_distinct.c_true_key);
5015: hr_utility.trace('row eff start date ' ||

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

5009: hr_utility.trace('column_id ' ||
5010: to_char(each_child.user_column_id));
5011: hr_utility.trace('row id ' ||
5012: to_char(r_distinct.c_surrogate_key));
5013: hr_utility.trace('row low range ' ||
5014: r_distinct.c_true_key);
5015: hr_utility.trace('row eff start date ' ||
5016: to_date(r_distinct.effective_start_date, 'DD-MM-YYYY'));
5017: hr_utility.trace('col eff start date ' ||

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

5011: hr_utility.trace('row id ' ||
5012: to_char(r_distinct.c_surrogate_key));
5013: hr_utility.trace('row low range ' ||
5014: r_distinct.c_true_key);
5015: hr_utility.trace('row eff start date ' ||
5016: to_date(r_distinct.effective_start_date, 'DD-MM-YYYY'));
5017: hr_utility.trace('col eff start date ' ||
5018: to_date(each_child.effective_start_date, 'DD-MM-YYYY'));
5019: hrrunprc_trace_off;

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

5013: hr_utility.trace('row low range ' ||
5014: r_distinct.c_true_key);
5015: hr_utility.trace('row eff start date ' ||
5016: to_date(r_distinct.effective_start_date, 'DD-MM-YYYY'));
5017: hr_utility.trace('col eff start date ' ||
5018: to_date(each_child.effective_start_date, 'DD-MM-YYYY'));
5019: hrrunprc_trace_off;
5020: raise;
5021: END;

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

5692: );
5693:
5694: EXCEPTION WHEN OTHERS THEN
5695: hrrunprc_trace_on;
5696: hr_utility.trace('ins pay_rep_format_map');
5697: hr_utility.trace('report_type ' ||
5698: stu_rec.report_type);
5699: hr_utility.trace('report_qualifier ' ||
5700: stu_rec.report_qualifier);

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

5693:
5694: EXCEPTION WHEN OTHERS THEN
5695: hrrunprc_trace_on;
5696: hr_utility.trace('ins pay_rep_format_map');
5697: hr_utility.trace('report_type ' ||
5698: stu_rec.report_type);
5699: hr_utility.trace('report_qualifier ' ||
5700: stu_rec.report_qualifier);
5701: hr_utility.trace('report_format ' ||

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

5695: hrrunprc_trace_on;
5696: hr_utility.trace('ins pay_rep_format_map');
5697: hr_utility.trace('report_type ' ||
5698: stu_rec.report_type);
5699: hr_utility.trace('report_qualifier ' ||
5700: stu_rec.report_qualifier);
5701: hr_utility.trace('report_format ' ||
5702: stu_rec.report_format);
5703: hrrunprc_trace_off;

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

5697: hr_utility.trace('report_type ' ||
5698: stu_rec.report_type);
5699: hr_utility.trace('report_qualifier ' ||
5700: stu_rec.report_qualifier);
5701: hr_utility.trace('report_format ' ||
5702: stu_rec.report_format);
5703: hrrunprc_trace_off;
5704: raise;
5705: END;

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

5870: from dual;
5871:
5872: WHEN TOO_MANY_ROWS THEN
5873: hrrunprc_trace_on;
5874: hr_utility.trace('sel pay_mag_blocks TMR');
5875: hr_utility.trace('block_name ' ||
5876: stu_rec.c_true_key);
5877: hr_utility.trace('report_format ' ||
5878: stu_rec.report_format);

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

5871:
5872: WHEN TOO_MANY_ROWS THEN
5873: hrrunprc_trace_on;
5874: hr_utility.trace('sel pay_mag_blocks TMR');
5875: hr_utility.trace('block_name ' ||
5876: stu_rec.c_true_key);
5877: hr_utility.trace('report_format ' ||
5878: stu_rec.report_format);
5879: hr_utility.trace('cursor_name ' ||

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

5873: hrrunprc_trace_on;
5874: hr_utility.trace('sel pay_mag_blocks TMR');
5875: hr_utility.trace('block_name ' ||
5876: stu_rec.c_true_key);
5877: hr_utility.trace('report_format ' ||
5878: stu_rec.report_format);
5879: hr_utility.trace('cursor_name ' ||
5880: stu_rec.cursor_name);
5881: hrrunprc_trace_off;

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

5875: hr_utility.trace('block_name ' ||
5876: stu_rec.c_true_key);
5877: hr_utility.trace('report_format ' ||
5878: stu_rec.report_format);
5879: hr_utility.trace('cursor_name ' ||
5880: stu_rec.cursor_name);
5881: hrrunprc_trace_off;
5882: raise;
5883: END;

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

5969: stu_rec.cursor_name ,
5970: stu_rec.no_column_returned);
5971: EXCEPTION WHEN OTHERS THEN
5972: hrrunprc_trace_on;
5973: hr_utility.trace('ins pay_mag_blocks');
5974: hr_utility.trace('block_name ' ||
5975: stu_rec.c_true_key);
5976: hr_utility.trace('report_format ' ||
5977: stu_rec.report_format);

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

5970: stu_rec.no_column_returned);
5971: EXCEPTION WHEN OTHERS THEN
5972: hrrunprc_trace_on;
5973: hr_utility.trace('ins pay_mag_blocks');
5974: hr_utility.trace('block_name ' ||
5975: stu_rec.c_true_key);
5976: hr_utility.trace('report_format ' ||
5977: stu_rec.report_format);
5978: hr_utility.trace('cursor_name ' ||

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

5972: hrrunprc_trace_on;
5973: hr_utility.trace('ins pay_mag_blocks');
5974: hr_utility.trace('block_name ' ||
5975: stu_rec.c_true_key);
5976: hr_utility.trace('report_format ' ||
5977: stu_rec.report_format);
5978: hr_utility.trace('cursor_name ' ||
5979: stu_rec.cursor_name);
5980: hrrunprc_trace_off;

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

5974: hr_utility.trace('block_name ' ||
5975: stu_rec.c_true_key);
5976: hr_utility.trace('report_format ' ||
5977: stu_rec.report_format);
5978: hr_utility.trace('cursor_name ' ||
5979: stu_rec.cursor_name);
5980: hrrunprc_trace_off;
5981: raise;
5982: END;

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

6093: stu_rec.frequency ,
6094: stu_rec.last_run_executed_mode);
6095: EXCEPTION WHEN OTHERS THEN
6096: hrrunprc_trace_on;
6097: hr_utility.trace('ins pay_magnetic_records');
6098: hr_utility.trace('mag block id: ' ||
6099: to_char(stu_rec.magnetic_block_id));
6100: hr_utility.trace('next blk id: ' ||
6101: to_char(stu_rec.next_block_id));

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

6094: stu_rec.last_run_executed_mode);
6095: EXCEPTION WHEN OTHERS THEN
6096: hrrunprc_trace_on;
6097: hr_utility.trace('ins pay_magnetic_records');
6098: hr_utility.trace('mag block id: ' ||
6099: to_char(stu_rec.magnetic_block_id));
6100: hr_utility.trace('next blk id: ' ||
6101: to_char(stu_rec.next_block_id));
6102: hr_utility.trace('sequence: ' ||

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

6096: hrrunprc_trace_on;
6097: hr_utility.trace('ins pay_magnetic_records');
6098: hr_utility.trace('mag block id: ' ||
6099: to_char(stu_rec.magnetic_block_id));
6100: hr_utility.trace('next blk id: ' ||
6101: to_char(stu_rec.next_block_id));
6102: hr_utility.trace('sequence: ' ||
6103: to_char(stu_rec.sequence));
6104: hrrunprc_trace_off;

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

6098: hr_utility.trace('mag block id: ' ||
6099: to_char(stu_rec.magnetic_block_id));
6100: hr_utility.trace('next blk id: ' ||
6101: to_char(stu_rec.next_block_id));
6102: hr_utility.trace('sequence: ' ||
6103: to_char(stu_rec.sequence));
6104: hrrunprc_trace_off;
6105: raise;
6106: END;

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

6258: from dual;
6259:
6260: WHEN TOO_MANY_ROWS THEN
6261: hrrunprc_trace_on;
6262: hr_utility.trace('sel pay_report_format_items_f TMR');
6263: hr_utility.trace('report_type ' ||
6264: stu_rec.report_type);
6265: hr_utility.trace('report_qualifier ' ||
6266: stu_rec.report_qualifier);

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

6259:
6260: WHEN TOO_MANY_ROWS THEN
6261: hrrunprc_trace_on;
6262: hr_utility.trace('sel pay_report_format_items_f TMR');
6263: hr_utility.trace('report_type ' ||
6264: stu_rec.report_type);
6265: hr_utility.trace('report_qualifier ' ||
6266: stu_rec.report_qualifier);
6267: hr_utility.trace('report_category ' ||

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

6261: hrrunprc_trace_on;
6262: hr_utility.trace('sel pay_report_format_items_f TMR');
6263: hr_utility.trace('report_type ' ||
6264: stu_rec.report_type);
6265: hr_utility.trace('report_qualifier ' ||
6266: stu_rec.report_qualifier);
6267: hr_utility.trace('report_category ' ||
6268: stu_rec.report_category);
6269: hr_utility.trace('user_entity_id ' ||

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

6263: hr_utility.trace('report_type ' ||
6264: stu_rec.report_type);
6265: hr_utility.trace('report_qualifier ' ||
6266: stu_rec.report_qualifier);
6267: hr_utility.trace('report_category ' ||
6268: stu_rec.report_category);
6269: hr_utility.trace('user_entity_id ' ||
6270: stu_rec.user_entity_id);
6271: hrrunprc_trace_off;

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

6265: hr_utility.trace('report_qualifier ' ||
6266: stu_rec.report_qualifier);
6267: hr_utility.trace('report_category ' ||
6268: stu_rec.report_category);
6269: hr_utility.trace('user_entity_id ' ||
6270: stu_rec.user_entity_id);
6271: hrrunprc_trace_off;
6272: raise;
6273: END;

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

6369: );
6370:
6371: EXCEPTION WHEN OTHERS THEN
6372: hrrunprc_trace_on;
6373: hr_utility.trace('ins pay_report_format_items_f');
6374: hr_utility.trace('report_type ' ||
6375: stu_rec.report_type);
6376: hr_utility.trace('report_qualifier ' ||
6377: stu_rec.report_qualifier);

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

6370:
6371: EXCEPTION WHEN OTHERS THEN
6372: hrrunprc_trace_on;
6373: hr_utility.trace('ins pay_report_format_items_f');
6374: hr_utility.trace('report_type ' ||
6375: stu_rec.report_type);
6376: hr_utility.trace('report_qualifier ' ||
6377: stu_rec.report_qualifier);
6378: hr_utility.trace('report_category ' ||

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

6372: hrrunprc_trace_on;
6373: hr_utility.trace('ins pay_report_format_items_f');
6374: hr_utility.trace('report_type ' ||
6375: stu_rec.report_type);
6376: hr_utility.trace('report_qualifier ' ||
6377: stu_rec.report_qualifier);
6378: hr_utility.trace('report_category ' ||
6379: stu_rec.report_category);
6380: hr_utility.trace('ue_id ' ||

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

6374: hr_utility.trace('report_type ' ||
6375: stu_rec.report_type);
6376: hr_utility.trace('report_qualifier ' ||
6377: stu_rec.report_qualifier);
6378: hr_utility.trace('report_category ' ||
6379: stu_rec.report_category);
6380: hr_utility.trace('ue_id ' ||
6381: to_char(stu_rec.user_entity_id));
6382: hrrunprc_trace_off;

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

6376: hr_utility.trace('report_qualifier ' ||
6377: stu_rec.report_qualifier);
6378: hr_utility.trace('report_category ' ||
6379: stu_rec.report_category);
6380: hr_utility.trace('ue_id ' ||
6381: to_char(stu_rec.user_entity_id));
6382: hrrunprc_trace_off;
6383: raise;
6384: END;

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

6439: IF maintain_history(p_phase) THEN
6440:
6441: -- Install all formula ditionary
6442: hrrunprc_trace_on;
6443: hr_utility.trace('start hr_legislation.install: ' || to_char(p_phase));
6444: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));
6445: hrrunprc_trace_off;
6446: ff_data_dict.install(p_phase);
6447:

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

6440:
6441: -- Install all formula ditionary
6442: hrrunprc_trace_on;
6443: hr_utility.trace('start hr_legislation.install: ' || to_char(p_phase));
6444: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));
6445: hrrunprc_trace_off;
6446: ff_data_dict.install(p_phase);
6447:
6448: -- Install assignment status types

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

6446: ff_data_dict.install(p_phase);
6447:
6448: -- Install assignment status types
6449: hrrunprc_trace_on;
6450: hr_utility.trace('start install_past: ' || to_char(p_phase));
6451: hrrunprc_trace_off;
6452: install_past(p_phase);
6453:
6454: -- Benefits

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

6452: install_past(p_phase);
6453:
6454: -- Benefits
6455: hrrunprc_trace_on;
6456: hr_utility.trace('start hr_legislation_benefits.install: ' || to_char(p_phase));
6457: hrrunprc_trace_off;
6458: hr_legislation_benefits.install(p_phase);
6459:
6460: -- Elements

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

6458: hr_legislation_benefits.install(p_phase);
6459:
6460: -- Elements
6461: hrrunprc_trace_on;
6462: hr_utility.trace('start hr_legislation_elements.install: ' || to_char(p_phase));
6463: hrrunprc_trace_off;
6464: hr_legislation_elements.install(p_phase);
6465:
6466: -- Install payment types

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

6464: hr_legislation_elements.install(p_phase);
6465:
6466: -- Install payment types
6467: hrrunprc_trace_on;
6468: hr_utility.trace('start install_payment_types: ' || to_char(p_phase));
6469: hrrunprc_trace_off;
6470: install_payment_types(p_phase);
6471:
6472: -- Install user rows

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

6470: install_payment_types(p_phase);
6471:
6472: -- Install user rows
6473: hrrunprc_trace_on;
6474: hr_utility.trace('start install_urows: ' || to_char(p_phase));
6475: hrrunprc_trace_off;
6476: install_urows(p_phase);
6477:
6478: -- Balance dimensions

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

6476: install_urows(p_phase);
6477:
6478: -- Balance dimensions
6479: hrrunprc_trace_on;
6480: hr_utility.trace('start install_dimensions: ' || to_char(p_phase));
6481: hrrunprc_trace_off;
6482: install_dimensions(p_phase);
6483:
6484: -- Install dimension routes

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

6482: install_dimensions(p_phase);
6483:
6484: -- Install dimension routes
6485: hrrunprc_trace_on;
6486: hr_utility.trace('start install_dimension_routes: ' || to_char(p_phase));
6487: hrrunprc_trace_off;
6488: install_dimension_routes(p_phase);
6489:
6490: -- Install balance categories

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

6488: install_dimension_routes(p_phase);
6489:
6490: -- Install balance categories
6491: hrrunprc_trace_on;
6492: hr_utility.trace('start install_bal_categories: ' || to_char(p_phase));
6493: hrrunprc_trace_off;
6494: install_bal_categories(p_phase);
6495:
6496: -- Install balances,classes,defined,feeds

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

6494: install_bal_categories(p_phase);
6495:
6496: -- Install balances,classes,defined,feeds
6497: hrrunprc_trace_on;
6498: hr_utility.trace('start install_bal_types: ' || to_char(p_phase));
6499: hrrunprc_trace_off;
6500: install_bal_types(p_phase);
6501:
6502: -- Localization hook

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

6500: install_bal_types(p_phase);
6501:
6502: -- Localization hook
6503: hrrunprc_trace_on;
6504: hr_utility.trace('start hr_legislation_local: ' || to_char(p_phase));
6505: hrrunprc_trace_off;
6506: hr_legislation_local.install(p_phase);
6507:
6508: -- Install hr org info details

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

6506: hr_legislation_local.install(p_phase);
6507:
6508: -- Install hr org info details
6509: hrrunprc_trace_on;
6510: hr_utility.trace('start install_org_info: ' || to_char(p_phase));
6511: hrrunprc_trace_off;
6512: install_org_info(p_phase);
6513:
6514: -- Install assignment extra info

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

6512: install_org_info(p_phase);
6513:
6514: -- Install assignment extra info
6515: hrrunprc_trace_on;
6516: hr_utility.trace('start install_ass_info: ' || to_char(p_phase));
6517: hrrunprc_trace_off;
6518: install_ass_info(p_phase);
6519:
6520: -- Install legislative field info

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

6518: install_ass_info(p_phase);
6519:
6520: -- Install legislative field info
6521: hrrunprc_trace_on;
6522: hr_utility.trace('start install_leg_field: ' || to_char(p_phase));
6523: hrrunprc_trace_off;
6524: install_leg_field(p_phase);
6525:
6526: -- Install monetary units

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

6524: install_leg_field(p_phase);
6525:
6526: -- Install monetary units
6527: hrrunprc_trace_on;
6528: hr_utility.trace('start install_monetary: ' || to_char(p_phase));
6529: hrrunprc_trace_off;
6530: install_monetary(p_phase);
6531:
6532: -- install report_format_mappings

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

6530: install_monetary(p_phase);
6531:
6532: -- install report_format_mappings
6533: hrrunprc_trace_on;
6534: hr_utility.trace('start install_report_mappings: ' || to_char(p_phase));
6535: hrrunprc_trace_off;
6536: install_report_mappings(p_phase);
6537:
6538: -- install report_items

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

6536: install_report_mappings(p_phase);
6537:
6538: -- install report_items
6539: hrrunprc_trace_on;
6540: hr_utility.trace('start install_report_items: ' || to_char(p_phase));
6541: hrrunprc_trace_off;
6542: install_report_items(p_phase);
6543:
6544: -- install magnetic blocks and records

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

6542: install_report_items(p_phase);
6543:
6544: -- install magnetic blocks and records
6545: hrrunprc_trace_on;
6546: hr_utility.trace('start install_magnetic_blocks: ' || to_char(p_phase));
6547: hrrunprc_trace_off;
6548: install_magnetic_blocks(p_phase);
6549:
6550: -- install magnetic_records

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

6548: install_magnetic_blocks(p_phase);
6549:
6550: -- install magnetic_records
6551: hrrunprc_trace_on;
6552: hr_utility.trace('start install_magnetic_records: ' || to_char(p_phase));
6553: hrrunprc_trace_off;
6554: install_magnetic_records(p_phase);
6555:
6556: -- Install lookup types/codes/usages

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

6596:
6597: END IF; -- end exception check
6598:
6599: hrrunprc_trace_on;
6600: hr_utility.trace('exit hr_legislation.install: ' || to_char(p_phase));
6601: hrrunprc_trace_off;
6602:
6603: ELSE -- error occured in maintain history
6604: rollback;

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

7589: install(1);
7590:
7591: -- check for the existance of any exceptions after phase 1
7592:
7593: hr_utility.set_Location('hr_legislation.install2',20);
7594:
7595: select count(*)
7596: into v_exception_counter
7597: from hr_stu_exceptions;

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

7597: from hr_stu_exceptions;
7598:
7599: IF v_exception_counter > 0 THEN
7600:
7601: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7602: hr_utility.set_message_token('PHASE_NUMBER','1');
7603: hr_utility.raise_error;
7604:
7605: END IF;

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

7598:
7599: IF v_exception_counter > 0 THEN
7600:
7601: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7602: hr_utility.set_message_token('PHASE_NUMBER','1');
7603: hr_utility.raise_error;
7604:
7605: END IF;
7606:

Line 7603: hr_utility.raise_error;

7599: IF v_exception_counter > 0 THEN
7600:
7601: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7602: hr_utility.set_message_token('PHASE_NUMBER','1');
7603: hr_utility.raise_error;
7604:
7605: END IF;
7606:
7607: -- perform phase 2 of the installation

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

7605: END IF;
7606:
7607: -- perform phase 2 of the installation
7608:
7609: hr_utility.set_Location('hr_legislation.install2',40);
7610:
7611: install(2);
7612:
7613: -- check for the existance of exceptions after phase 2

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

7611: install(2);
7612:
7613: -- check for the existance of exceptions after phase 2
7614:
7615: hr_utility.set_Location('hr_legislation.install2',50);
7616:
7617: select count(*)
7618: into v_exception_counter
7619: from hr_stu_exceptions;

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

7619: from hr_stu_exceptions;
7620:
7621: IF v_exception_counter > 0 THEN
7622:
7623: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7624: hr_utility.set_message_token('PHASE_NUMBER','2');
7625: hr_utility.raise_error;
7626:
7627: END IF;

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

7620:
7621: IF v_exception_counter > 0 THEN
7622:
7623: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7624: hr_utility.set_message_token('PHASE_NUMBER','2');
7625: hr_utility.raise_error;
7626:
7627: END IF;
7628:

Line 7625: hr_utility.raise_error;

7621: IF v_exception_counter > 0 THEN
7622:
7623: hr_utility.set_message(801,'HR_7129_STARTUP_EXCEPTIONS');
7624: hr_utility.set_message_token('PHASE_NUMBER','2');
7625: hr_utility.raise_error;
7626:
7627: END IF;
7628:
7629: -- Move the hr_s_application_ownership data to the HR_APPLICATION_OWNERSHIP