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_ELEMENTS dependencies on HR_UTILITY

Line 268: hr_utility.trace('sel pay_element_classifications TMR');

264:
265: WHEN TOO_MANY_ROWS THEN
266:
267: hr_legislation.hrrunprc_trace_on;
268: hr_utility.trace('sel pay_element_classifications TMR');
269:
270: hr_utility.trace('classification_name ' ||
271: stu_rec.c_true_key);
272: hr_utility.trace(':lc: ' || ':' ||

Line 270: hr_utility.trace('classification_name ' ||

266:
267: hr_legislation.hrrunprc_trace_on;
268: hr_utility.trace('sel pay_element_classifications TMR');
269:
270: hr_utility.trace('classification_name ' ||
271: stu_rec.c_true_key);
272: hr_utility.trace(':lc: ' || ':' ||
273: stu_rec.c_leg_code || ':');
274: hr_legislation.hrrunprc_trace_off;

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

268: hr_utility.trace('sel pay_element_classifications TMR');
269:
270: hr_utility.trace('classification_name ' ||
271: stu_rec.c_true_key);
272: hr_utility.trace(':lc: ' || ':' ||
273: stu_rec.c_leg_code || ':');
274: hr_legislation.hrrunprc_trace_off;
275: raise;
276: END;

Line 605: hr_utility.trace('ins pay_element_classifications');

601: ,stu_rec.balance_initialization_flag
602: ,stu_rec.FREQ_RULE_ENABLED);
603: EXCEPTION WHEN OTHERS THEN
604: hr_legislation.hrrunprc_trace_on;
605: hr_utility.trace('ins pay_element_classifications');
606: hr_utility.trace('classification_name ' ||
607: stu_rec.c_true_key);
608: hr_utility.trace('classification_id ' ||
609: to_char(stu_rec.c_surrogate_key));

Line 606: hr_utility.trace('classification_name ' ||

602: ,stu_rec.FREQ_RULE_ENABLED);
603: EXCEPTION WHEN OTHERS THEN
604: hr_legislation.hrrunprc_trace_on;
605: hr_utility.trace('ins pay_element_classifications');
606: hr_utility.trace('classification_name ' ||
607: stu_rec.c_true_key);
608: hr_utility.trace('classification_id ' ||
609: to_char(stu_rec.c_surrogate_key));
610: hr_utility.trace(':lc: ' || ':' ||

Line 608: hr_utility.trace('classification_id ' ||

604: hr_legislation.hrrunprc_trace_on;
605: hr_utility.trace('ins pay_element_classifications');
606: hr_utility.trace('classification_name ' ||
607: stu_rec.c_true_key);
608: hr_utility.trace('classification_id ' ||
609: to_char(stu_rec.c_surrogate_key));
610: hr_utility.trace(':lc: ' || ':' ||
611: stu_rec.c_leg_code || ':');
612: hr_legislation.hrrunprc_trace_off;

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

606: hr_utility.trace('classification_name ' ||
607: stu_rec.c_true_key);
608: hr_utility.trace('classification_id ' ||
609: to_char(stu_rec.c_surrogate_key));
610: hr_utility.trace(':lc: ' || ':' ||
611: stu_rec.c_leg_code || ':');
612: hr_legislation.hrrunprc_trace_off;
613: raise;
614: END;

Line 1219: hr_utility.trace('sel pay_element_types_f TMR');

1215: v_new_element_type_flag := 'Y';
1216:
1217: WHEN TOO_MANY_ROWS THEN
1218: hr_legislation.hrrunprc_trace_on;
1219: hr_utility.trace('sel pay_element_types_f TMR');
1220: hr_utility.trace('element_name ' ||
1221: r_distinct.c_true_key);
1222: hr_utility.trace(':lc: ' || ':' ||
1223: r_distinct.legislation_code || ':');

Line 1220: hr_utility.trace('element_name ' ||

1216:
1217: WHEN TOO_MANY_ROWS THEN
1218: hr_legislation.hrrunprc_trace_on;
1219: hr_utility.trace('sel pay_element_types_f TMR');
1220: hr_utility.trace('element_name ' ||
1221: r_distinct.c_true_key);
1222: hr_utility.trace(':lc: ' || ':' ||
1223: r_distinct.legislation_code || ':');
1224: hr_legislation.hrrunprc_trace_off;

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

1218: hr_legislation.hrrunprc_trace_on;
1219: hr_utility.trace('sel pay_element_types_f TMR');
1220: hr_utility.trace('element_name ' ||
1221: r_distinct.c_true_key);
1222: hr_utility.trace(':lc: ' || ':' ||
1223: r_distinct.legislation_code || ':');
1224: hr_legislation.hrrunprc_trace_off;
1225: raise;
1226: END;

Line 1289: hr_utility.trace('sel pay_input_values_f TMR');

1285: v_new_input_value_flag := 'Y';
1286:
1287: WHEN TOO_MANY_ROWS THEN
1288: hr_legislation.hrrunprc_trace_on;
1289: hr_utility.trace('sel pay_input_values_f TMR');
1290: hr_utility.trace('iv name ' ||
1291: i_vals.name);
1292: hr_utility.trace('element_type_id ' ||
1293: to_char(l_new_element_Type_id));

Line 1290: hr_utility.trace('iv name ' ||

1286:
1287: WHEN TOO_MANY_ROWS THEN
1288: hr_legislation.hrrunprc_trace_on;
1289: hr_utility.trace('sel pay_input_values_f TMR');
1290: hr_utility.trace('iv name ' ||
1291: i_vals.name);
1292: hr_utility.trace('element_type_id ' ||
1293: to_char(l_new_element_Type_id));
1294: hr_utility.trace('element_name ' ||

Line 1292: hr_utility.trace('element_type_id ' ||

1288: hr_legislation.hrrunprc_trace_on;
1289: hr_utility.trace('sel pay_input_values_f TMR');
1290: hr_utility.trace('iv name ' ||
1291: i_vals.name);
1292: hr_utility.trace('element_type_id ' ||
1293: to_char(l_new_element_Type_id));
1294: hr_utility.trace('element_name ' ||
1295: r_distinct.c_true_key);
1296: hr_legislation.hrrunprc_trace_off;

Line 1294: hr_utility.trace('element_name ' ||

1290: hr_utility.trace('iv name ' ||
1291: i_vals.name);
1292: hr_utility.trace('element_type_id ' ||
1293: to_char(l_new_element_Type_id));
1294: hr_utility.trace('element_name ' ||
1295: r_distinct.c_true_key);
1296: hr_legislation.hrrunprc_trace_off;
1297: raise;
1298: END;

Line 1421: hr_utility.trace('sel pay_status_processing_rules TMR');

1417: from dual;
1418:
1419: WHEN TOO_MANY_ROWS THEN
1420: hr_legislation.hrrunprc_trace_on;
1421: hr_utility.trace('sel pay_status_processing_rules TMR');
1422:
1423: hr_utility.trace('assignment_status_type_id ' ||
1424: to_char(sprs.assignment_status_type_id));
1425: hr_utility.trace(':lc: ' || ':' ||

Line 1423: hr_utility.trace('assignment_status_type_id ' ||

1419: WHEN TOO_MANY_ROWS THEN
1420: hr_legislation.hrrunprc_trace_on;
1421: hr_utility.trace('sel pay_status_processing_rules TMR');
1422:
1423: hr_utility.trace('assignment_status_type_id ' ||
1424: to_char(sprs.assignment_status_type_id));
1425: hr_utility.trace(':lc: ' || ':' ||
1426: r_distinct.legislation_code || ':');
1427: hr_legislation.hrrunprc_trace_off;

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

1421: hr_utility.trace('sel pay_status_processing_rules TMR');
1422:
1423: hr_utility.trace('assignment_status_type_id ' ||
1424: to_char(sprs.assignment_status_type_id));
1425: hr_utility.trace(':lc: ' || ':' ||
1426: r_distinct.legislation_code || ':');
1427: hr_legislation.hrrunprc_trace_off;
1428: raise;
1429: END;

Line 2128: hr_utility.trace('ins pay_input_values_f');

2124: from hr_s_input_values_f
2125: where input_value_id = i_values.input_value_id;
2126: EXCEPTION WHEN OTHERS THEN
2127: hr_legislation.hrrunprc_trace_on;
2128: hr_utility.trace('ins pay_input_values_f');
2129: hr_utility.trace('iv id ' ||
2130: to_char(i_values.input_value_id));
2131: hr_utility.trace('iv name ' ||
2132: i_values.name);

Line 2129: hr_utility.trace('iv id ' ||

2125: where input_value_id = i_values.input_value_id;
2126: EXCEPTION WHEN OTHERS THEN
2127: hr_legislation.hrrunprc_trace_on;
2128: hr_utility.trace('ins pay_input_values_f');
2129: hr_utility.trace('iv id ' ||
2130: to_char(i_values.input_value_id));
2131: hr_utility.trace('iv name ' ||
2132: i_values.name);
2133: hr_legislation.hrrunprc_trace_off;

Line 2131: hr_utility.trace('iv name ' ||

2127: hr_legislation.hrrunprc_trace_on;
2128: hr_utility.trace('ins pay_input_values_f');
2129: hr_utility.trace('iv id ' ||
2130: to_char(i_values.input_value_id));
2131: hr_utility.trace('iv name ' ||
2132: i_values.name);
2133: hr_legislation.hrrunprc_trace_off;
2134: raise;
2135: END;

Line 2401: hr_utility.trace('ins pay_element_types_f');

2397: ,each_row.TIME_DEFINITION_ID
2398: );
2399: EXCEPTION WHEN OTHERS THEN
2400: hr_legislation.hrrunprc_trace_on;
2401: hr_utility.trace('ins pay_element_types_f');
2402: hr_utility.trace('element type name ' ||
2403: each_row.element_name);
2404: hr_utility.trace('element_type_id ' ||
2405: to_char(each_row.element_type_id));

Line 2402: hr_utility.trace('element type name ' ||

2398: );
2399: EXCEPTION WHEN OTHERS THEN
2400: hr_legislation.hrrunprc_trace_on;
2401: hr_utility.trace('ins pay_element_types_f');
2402: hr_utility.trace('element type name ' ||
2403: each_row.element_name);
2404: hr_utility.trace('element_type_id ' ||
2405: to_char(each_row.element_type_id));
2406: hr_utility.trace(':lc: ' || ':' ||

Line 2404: hr_utility.trace('element_type_id ' ||

2400: hr_legislation.hrrunprc_trace_on;
2401: hr_utility.trace('ins pay_element_types_f');
2402: hr_utility.trace('element type name ' ||
2403: each_row.element_name);
2404: hr_utility.trace('element_type_id ' ||
2405: to_char(each_row.element_type_id));
2406: hr_utility.trace(':lc: ' || ':' ||
2407: each_row.legislation_code || ':');
2408: hr_legislation.hrrunprc_trace_off;

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

2402: hr_utility.trace('element type name ' ||
2403: each_row.element_name);
2404: hr_utility.trace('element_type_id ' ||
2405: to_char(each_row.element_type_id));
2406: hr_utility.trace(':lc: ' || ':' ||
2407: each_row.legislation_code || ':');
2408: hr_legislation.hrrunprc_trace_off;
2409: raise;
2410: END;

Line 2460: hr_utility.trace('ins pay_sub_classification_rules_f');

2456: ,s_rules.creation_date
2457: );
2458: EXCEPTION WHEN OTHERS THEN
2459: hr_legislation.hrrunprc_trace_on;
2460: hr_utility.trace('ins pay_sub_classification_rules_f');
2461: hr_utility.trace('sub_classification_rule_id ' ||
2462: to_char(s_rules.sub_classification_rule_id));
2463: hr_utility.trace('element_type_id ' ||
2464: to_char(s_rules.element_type_id));

Line 2461: hr_utility.trace('sub_classification_rule_id ' ||

2457: );
2458: EXCEPTION WHEN OTHERS THEN
2459: hr_legislation.hrrunprc_trace_on;
2460: hr_utility.trace('ins pay_sub_classification_rules_f');
2461: hr_utility.trace('sub_classification_rule_id ' ||
2462: to_char(s_rules.sub_classification_rule_id));
2463: hr_utility.trace('element_type_id ' ||
2464: to_char(s_rules.element_type_id));
2465: hr_utility.trace('classification_id ' ||

Line 2463: hr_utility.trace('element_type_id ' ||

2459: hr_legislation.hrrunprc_trace_on;
2460: hr_utility.trace('ins pay_sub_classification_rules_f');
2461: hr_utility.trace('sub_classification_rule_id ' ||
2462: to_char(s_rules.sub_classification_rule_id));
2463: hr_utility.trace('element_type_id ' ||
2464: to_char(s_rules.element_type_id));
2465: hr_utility.trace('classification_id ' ||
2466: to_char(s_rules.classification_id));
2467: hr_utility.trace(':lc: ' || ':' ||

Line 2465: hr_utility.trace('classification_id ' ||

2461: hr_utility.trace('sub_classification_rule_id ' ||
2462: to_char(s_rules.sub_classification_rule_id));
2463: hr_utility.trace('element_type_id ' ||
2464: to_char(s_rules.element_type_id));
2465: hr_utility.trace('classification_id ' ||
2466: to_char(s_rules.classification_id));
2467: hr_utility.trace(':lc: ' || ':' ||
2468: s_rules.legislation_code || ':');
2469: hr_legislation.hrrunprc_trace_off;

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

2463: hr_utility.trace('element_type_id ' ||
2464: to_char(s_rules.element_type_id));
2465: hr_utility.trace('classification_id ' ||
2466: to_char(s_rules.classification_id));
2467: hr_utility.trace(':lc: ' || ':' ||
2468: s_rules.legislation_code || ':');
2469: hr_legislation.hrrunprc_trace_off;
2470: raise;
2471: END;

Line 2543: hr_utility.trace('ins pay_status_processing_rules_f');

2539: ,all_rules.CREATION_DATE
2540: );
2541: EXCEPTION WHEN OTHERS THEN
2542: hr_legislation.hrrunprc_trace_on;
2543: hr_utility.trace('ins pay_status_processing_rules_f');
2544: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2545: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2546: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2547: to_char(all_rules.element_type_id));

Line 2544: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||

2540: );
2541: EXCEPTION WHEN OTHERS THEN
2542: hr_legislation.hrrunprc_trace_on;
2543: hr_utility.trace('ins pay_status_processing_rules_f');
2544: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2545: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2546: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2547: to_char(all_rules.element_type_id));
2548: hr_utility.trace('PROCESSING_RULE ' ||

Line 2546: hr_utility.trace('ELEMENT_TYPE_ID ' ||

2542: hr_legislation.hrrunprc_trace_on;
2543: hr_utility.trace('ins pay_status_processing_rules_f');
2544: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2545: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2546: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2547: to_char(all_rules.element_type_id));
2548: hr_utility.trace('PROCESSING_RULE ' ||
2549: all_rules.PROCESSING_RULE);
2550: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||

Line 2548: hr_utility.trace('PROCESSING_RULE ' ||

2544: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2545: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2546: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2547: to_char(all_rules.element_type_id));
2548: hr_utility.trace('PROCESSING_RULE ' ||
2549: all_rules.PROCESSING_RULE);
2550: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||
2551: to_char(all_rules.ASSIGNMENT_STATUS_TYPE_ID));
2552: hr_utility.trace(':lc: ' || ':' ||

Line 2550: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||

2546: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2547: to_char(all_rules.element_type_id));
2548: hr_utility.trace('PROCESSING_RULE ' ||
2549: all_rules.PROCESSING_RULE);
2550: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||
2551: to_char(all_rules.ASSIGNMENT_STATUS_TYPE_ID));
2552: hr_utility.trace(':lc: ' || ':' ||
2553: all_rules.legislation_code || ':');
2554: hr_legislation.hrrunprc_trace_off;

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

2548: hr_utility.trace('PROCESSING_RULE ' ||
2549: all_rules.PROCESSING_RULE);
2550: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||
2551: to_char(all_rules.ASSIGNMENT_STATUS_TYPE_ID));
2552: hr_utility.trace(':lc: ' || ':' ||
2553: all_rules.legislation_code || ':');
2554: hr_legislation.hrrunprc_trace_off;
2555: raise;
2556: END;

Line 2604: hr_utility.trace('ins pay_formula_result_rules_f');

2600: ,all_frrs.CREATION_DATE
2601: );
2602: EXCEPTION WHEN OTHERS THEN
2603: hr_legislation.hrrunprc_trace_on;
2604: hr_utility.trace('ins pay_formula_result_rules_f');
2605: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2606: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2607: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2608: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));

Line 2605: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||

2601: );
2602: EXCEPTION WHEN OTHERS THEN
2603: hr_legislation.hrrunprc_trace_on;
2604: hr_utility.trace('ins pay_formula_result_rules_f');
2605: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2606: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2607: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2608: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));
2609: hr_utility.trace('RESULT_NAME ' ||

Line 2607: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||

2603: hr_legislation.hrrunprc_trace_on;
2604: hr_utility.trace('ins pay_formula_result_rules_f');
2605: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2606: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2607: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2608: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));
2609: hr_utility.trace('RESULT_NAME ' ||
2610: all_frrs.RESULT_NAME);
2611: hr_utility.trace(':lc: ' || ':' ||

Line 2609: hr_utility.trace('RESULT_NAME ' ||

2605: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2606: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2607: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2608: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));
2609: hr_utility.trace('RESULT_NAME ' ||
2610: all_frrs.RESULT_NAME);
2611: hr_utility.trace(':lc: ' || ':' ||
2612: all_frrs.legislation_code || ':');
2613: hr_legislation.hrrunprc_trace_off;

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

2607: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2608: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));
2609: hr_utility.trace('RESULT_NAME ' ||
2610: all_frrs.RESULT_NAME);
2611: hr_utility.trace(':lc: ' || ':' ||
2612: all_frrs.legislation_code || ':');
2613: hr_legislation.hrrunprc_trace_off;
2614: raise;
2615: END;

Line 2883: hr_utility.trace('sel pay_element_sets TMR');

2879:
2880: WHEN TOO_MANY_ROWS THEN
2881:
2882: hr_legislation.hrrunprc_trace_on;
2883: hr_utility.trace('sel pay_element_sets TMR');
2884: hr_utility.trace('element_set_name ' ||
2885: stu_rec.c_true_key);
2886: hr_utility.trace(':lc: ' || ':' ||
2887: stu_rec.c_leg_code || ':');

Line 2884: hr_utility.trace('element_set_name ' ||

2880: WHEN TOO_MANY_ROWS THEN
2881:
2882: hr_legislation.hrrunprc_trace_on;
2883: hr_utility.trace('sel pay_element_sets TMR');
2884: hr_utility.trace('element_set_name ' ||
2885: stu_rec.c_true_key);
2886: hr_utility.trace(':lc: ' || ':' ||
2887: stu_rec.c_leg_code || ':');
2888: hr_legislation.hrrunprc_trace_off;

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

2882: hr_legislation.hrrunprc_trace_on;
2883: hr_utility.trace('sel pay_element_sets TMR');
2884: hr_utility.trace('element_set_name ' ||
2885: stu_rec.c_true_key);
2886: hr_utility.trace(':lc: ' || ':' ||
2887: stu_rec.c_leg_code || ':');
2888: hr_legislation.hrrunprc_trace_off;
2889: raise;
2890: END;

Line 3142: hr_utility.trace('ins pay_element_sets');

3138: ,stu_rec.creation_date
3139: );
3140: EXCEPTION WHEN OTHERS THEN
3141: hr_legislation.hrrunprc_trace_on;
3142: hr_utility.trace('ins pay_element_sets');
3143: hr_utility.trace('element_set_name ' ||
3144: stu_rec.c_true_key);
3145: hr_utility.trace('element_set_id ' ||
3146: to_char(stu_rec.c_surrogate_key));

Line 3143: hr_utility.trace('element_set_name ' ||

3139: );
3140: EXCEPTION WHEN OTHERS THEN
3141: hr_legislation.hrrunprc_trace_on;
3142: hr_utility.trace('ins pay_element_sets');
3143: hr_utility.trace('element_set_name ' ||
3144: stu_rec.c_true_key);
3145: hr_utility.trace('element_set_id ' ||
3146: to_char(stu_rec.c_surrogate_key));
3147: hr_utility.trace('element_set_type ' ||

Line 3145: hr_utility.trace('element_set_id ' ||

3141: hr_legislation.hrrunprc_trace_on;
3142: hr_utility.trace('ins pay_element_sets');
3143: hr_utility.trace('element_set_name ' ||
3144: stu_rec.c_true_key);
3145: hr_utility.trace('element_set_id ' ||
3146: to_char(stu_rec.c_surrogate_key));
3147: hr_utility.trace('element_set_type ' ||
3148: stu_rec.element_set_type);
3149: hr_utility.trace(':lc: ' || ':' ||

Line 3147: hr_utility.trace('element_set_type ' ||

3143: hr_utility.trace('element_set_name ' ||
3144: stu_rec.c_true_key);
3145: hr_utility.trace('element_set_id ' ||
3146: to_char(stu_rec.c_surrogate_key));
3147: hr_utility.trace('element_set_type ' ||
3148: stu_rec.element_set_type);
3149: hr_utility.trace(':lc: ' || ':' ||
3150: stu_rec.c_leg_code || ':');
3151: hr_legislation.hrrunprc_trace_off;

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

3145: hr_utility.trace('element_set_id ' ||
3146: to_char(stu_rec.c_surrogate_key));
3147: hr_utility.trace('element_set_type ' ||
3148: stu_rec.element_set_type);
3149: hr_utility.trace(':lc: ' || ':' ||
3150: stu_rec.c_leg_code || ':');
3151: hr_legislation.hrrunprc_trace_off;
3152: raise;
3153: END;

Line 3191: hr_utility.trace('ins pay_element_type_rules');

3187: ,ele_types.created_by
3188: ,ele_types.creation_date);
3189: EXCEPTION WHEN OTHERS THEN
3190: hr_legislation.hrrunprc_trace_on;
3191: hr_utility.trace('ins pay_element_type_rules');
3192: hr_utility.trace('element_type_id ' ||
3193: to_char(ele_types.element_Type_id));
3194: hr_utility.trace('element_set_id ' ||
3195: to_char(ele_types.element_Set_id));

Line 3192: hr_utility.trace('element_type_id ' ||

3188: ,ele_types.creation_date);
3189: EXCEPTION WHEN OTHERS THEN
3190: hr_legislation.hrrunprc_trace_on;
3191: hr_utility.trace('ins pay_element_type_rules');
3192: hr_utility.trace('element_type_id ' ||
3193: to_char(ele_types.element_Type_id));
3194: hr_utility.trace('element_set_id ' ||
3195: to_char(ele_types.element_Set_id));
3196: hr_legislation.hrrunprc_trace_off;

Line 3194: hr_utility.trace('element_set_id ' ||

3190: hr_legislation.hrrunprc_trace_on;
3191: hr_utility.trace('ins pay_element_type_rules');
3192: hr_utility.trace('element_type_id ' ||
3193: to_char(ele_types.element_Type_id));
3194: hr_utility.trace('element_set_id ' ||
3195: to_char(ele_types.element_Set_id));
3196: hr_legislation.hrrunprc_trace_off;
3197: raise;
3198: END;

Line 3243: hr_utility.trace('ins pay_ele_classification_rules');

3239: ,ele_class.created_by
3240: ,ele_class.creation_date);
3241: EXCEPTION WHEN OTHERS THEN
3242: hr_legislation.hrrunprc_trace_on;
3243: hr_utility.trace('ins pay_ele_classification_rules');
3244: hr_utility.trace('element_set_id ' ||
3245: to_char(ele_class.element_set_id));
3246: hr_utility.trace('classification_id ' ||
3247: to_char(ele_class.classification_id));

Line 3244: hr_utility.trace('element_set_id ' ||

3240: ,ele_class.creation_date);
3241: EXCEPTION WHEN OTHERS THEN
3242: hr_legislation.hrrunprc_trace_on;
3243: hr_utility.trace('ins pay_ele_classification_rules');
3244: hr_utility.trace('element_set_id ' ||
3245: to_char(ele_class.element_set_id));
3246: hr_utility.trace('classification_id ' ||
3247: to_char(ele_class.classification_id));
3248: hr_legislation.hrrunprc_trace_off;

Line 3246: hr_utility.trace('classification_id ' ||

3242: hr_legislation.hrrunprc_trace_on;
3243: hr_utility.trace('ins pay_ele_classification_rules');
3244: hr_utility.trace('element_set_id ' ||
3245: to_char(ele_class.element_set_id));
3246: hr_utility.trace('classification_id ' ||
3247: to_char(ele_class.classification_id));
3248: hr_legislation.hrrunprc_trace_off;
3249: raise;
3250: END;

Line 3484: hr_utility.trace('sel pay_user_tables TMR');

3480: from dual;
3481:
3482: WHEN TOO_MANY_ROWS THEN
3483: hr_legislation.hrrunprc_trace_on;
3484: hr_utility.trace('sel pay_user_tables TMR');
3485: hr_utility.trace('user_table_name ' ||
3486: stu_rec.c_true_key);
3487: hr_utility.trace(':lc: ' || ':' ||
3488: stu_rec.c_leg_code || ':');

Line 3485: hr_utility.trace('user_table_name ' ||

3481:
3482: WHEN TOO_MANY_ROWS THEN
3483: hr_legislation.hrrunprc_trace_on;
3484: hr_utility.trace('sel pay_user_tables TMR');
3485: hr_utility.trace('user_table_name ' ||
3486: stu_rec.c_true_key);
3487: hr_utility.trace(':lc: ' || ':' ||
3488: stu_rec.c_leg_code || ':');
3489: hr_legislation.hrrunprc_trace_off;

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

3483: hr_legislation.hrrunprc_trace_on;
3484: hr_utility.trace('sel pay_user_tables TMR');
3485: hr_utility.trace('user_table_name ' ||
3486: stu_rec.c_true_key);
3487: hr_utility.trace(':lc: ' || ':' ||
3488: stu_rec.c_leg_code || ':');
3489: hr_legislation.hrrunprc_trace_off;
3490: raise;
3491:

Line 3760: hr_utility.trace('ins pay_user_tables');

3756: ,stu_rec.user_row_title
3757: );
3758: EXCEPTION WHEN OTHERS THEN
3759: hr_legislation.hrrunprc_trace_on;
3760: hr_utility.trace('ins pay_user_tables');
3761: hr_utility.trace('user_table_id ' ||
3762: to_char(stu_rec.c_surrogate_key));
3763: hr_utility.trace('user_table_name ' ||
3764: stu_rec.c_true_key);

Line 3761: hr_utility.trace('user_table_id ' ||

3757: );
3758: EXCEPTION WHEN OTHERS THEN
3759: hr_legislation.hrrunprc_trace_on;
3760: hr_utility.trace('ins pay_user_tables');
3761: hr_utility.trace('user_table_id ' ||
3762: to_char(stu_rec.c_surrogate_key));
3763: hr_utility.trace('user_table_name ' ||
3764: stu_rec.c_true_key);
3765: hr_utility.trace(':lc: ' || ':' ||

Line 3763: hr_utility.trace('user_table_name ' ||

3759: hr_legislation.hrrunprc_trace_on;
3760: hr_utility.trace('ins pay_user_tables');
3761: hr_utility.trace('user_table_id ' ||
3762: to_char(stu_rec.c_surrogate_key));
3763: hr_utility.trace('user_table_name ' ||
3764: stu_rec.c_true_key);
3765: hr_utility.trace(':lc: ' || ':' ||
3766: stu_rec.c_leg_code || ':');
3767: hr_legislation.hrrunprc_trace_off;

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

3761: hr_utility.trace('user_table_id ' ||
3762: to_char(stu_rec.c_surrogate_key));
3763: hr_utility.trace('user_table_name ' ||
3764: stu_rec.c_true_key);
3765: hr_utility.trace(':lc: ' || ':' ||
3766: stu_rec.c_leg_code || ':');
3767: hr_legislation.hrrunprc_trace_off;
3768: raise;
3769: END;

Line 4002: hr_utility.trace('sel pay_user_columns TMR');

3998: from dual;
3999:
4000: WHEN TOO_MANY_ROWS THEN
4001: hr_legislation.hrrunprc_trace_on;
4002: hr_utility.trace('sel pay_user_columns TMR');
4003: hr_utility.trace('user_column_name ' ||
4004: stu_rec.c_true_key);
4005: hr_utility.trace('user_table_id ' ||
4006: to_char(stu_rec.user_table_id));

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

3999:
4000: WHEN TOO_MANY_ROWS THEN
4001: hr_legislation.hrrunprc_trace_on;
4002: hr_utility.trace('sel pay_user_columns TMR');
4003: hr_utility.trace('user_column_name ' ||
4004: stu_rec.c_true_key);
4005: hr_utility.trace('user_table_id ' ||
4006: to_char(stu_rec.user_table_id));
4007: hr_utility.trace(':lc: ' || ':' ||

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

4001: hr_legislation.hrrunprc_trace_on;
4002: hr_utility.trace('sel pay_user_columns TMR');
4003: hr_utility.trace('user_column_name ' ||
4004: stu_rec.c_true_key);
4005: hr_utility.trace('user_table_id ' ||
4006: to_char(stu_rec.user_table_id));
4007: hr_utility.trace(':lc: ' || ':' ||
4008: stu_rec.c_leg_code || ':');
4009: hr_legislation.hrrunprc_trace_off;

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

4003: hr_utility.trace('user_column_name ' ||
4004: stu_rec.c_true_key);
4005: hr_utility.trace('user_table_id ' ||
4006: to_char(stu_rec.user_table_id));
4007: hr_utility.trace(':lc: ' || ':' ||
4008: stu_rec.c_leg_code || ':');
4009: hr_legislation.hrrunprc_trace_off;
4010: raise;
4011: END;

Line 4411: hr_utility.trace('ins pay_user_columns');

4407: ,stu_rec.creation_date
4408: );
4409: EXCEPTION WHEN OTHERS THEN
4410: hr_legislation.hrrunprc_trace_on;
4411: hr_utility.trace('ins pay_user_columns');
4412: hr_utility.trace('user_column_id ' ||
4413: to_char(stu_rec.c_surrogate_key));
4414: hr_utility.trace('user_column_name ' ||
4415: stu_rec.c_true_key);

Line 4412: hr_utility.trace('user_column_id ' ||

4408: );
4409: EXCEPTION WHEN OTHERS THEN
4410: hr_legislation.hrrunprc_trace_on;
4411: hr_utility.trace('ins pay_user_columns');
4412: hr_utility.trace('user_column_id ' ||
4413: to_char(stu_rec.c_surrogate_key));
4414: hr_utility.trace('user_column_name ' ||
4415: stu_rec.c_true_key);
4416: hr_utility.trace('user_table_id ' ||

Line 4414: hr_utility.trace('user_column_name ' ||

4410: hr_legislation.hrrunprc_trace_on;
4411: hr_utility.trace('ins pay_user_columns');
4412: hr_utility.trace('user_column_id ' ||
4413: to_char(stu_rec.c_surrogate_key));
4414: hr_utility.trace('user_column_name ' ||
4415: stu_rec.c_true_key);
4416: hr_utility.trace('user_table_id ' ||
4417: to_char(stu_rec.user_table_id));
4418: hr_utility.trace(':lc: ' || ':' ||

Line 4416: hr_utility.trace('user_table_id ' ||

4412: hr_utility.trace('user_column_id ' ||
4413: to_char(stu_rec.c_surrogate_key));
4414: hr_utility.trace('user_column_name ' ||
4415: stu_rec.c_true_key);
4416: hr_utility.trace('user_table_id ' ||
4417: to_char(stu_rec.user_table_id));
4418: hr_utility.trace(':lc: ' || ':' ||
4419: stu_rec.c_leg_code || ':');
4420: hr_legislation.hrrunprc_trace_off;

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

4414: hr_utility.trace('user_column_name ' ||
4415: stu_rec.c_true_key);
4416: hr_utility.trace('user_table_id ' ||
4417: to_char(stu_rec.user_table_id));
4418: hr_utility.trace(':lc: ' || ':' ||
4419: stu_rec.c_leg_code || ':');
4420: hr_legislation.hrrunprc_trace_off;
4421: raise;
4422: END;

Line 4489: hr_utility.trace('start install_ele_class: ' || to_char(p_phase));

4485:
4486: IF p_phase = 1 OR p_phase =2 THEN
4487:
4488: hr_legislation.hrrunprc_trace_on;
4489: hr_utility.trace('start install_ele_class: ' || to_char(p_phase));
4490: hr_legislation.hrrunprc_trace_off;
4491:
4492: install_ele_class(p_phase); --install element classifications
4493:

Line 4495: hr_utility.trace('start install_elements: ' || to_char(p_phase));

4491:
4492: install_ele_class(p_phase); --install element classifications
4493:
4494: hr_legislation.hrrunprc_trace_on;
4495: hr_utility.trace('start install_elements: ' || to_char(p_phase));
4496: hr_legislation.hrrunprc_trace_off;
4497:
4498: install_elements(p_phase); --install elements,sprs,frrs,inputs
4499:

Line 4501: hr_utility.trace('start install_ele_sets: ' || to_char(p_phase));

4497:
4498: install_elements(p_phase); --install elements,sprs,frrs,inputs
4499:
4500: hr_legislation.hrrunprc_trace_on;
4501: hr_utility.trace('start install_ele_sets: ' || to_char(p_phase));
4502: hr_legislation.hrrunprc_trace_off;
4503:
4504: install_ele_sets(p_phase); --install sets,type rules,class rules
4505:

Line 4507: hr_utility.trace('start install_utables: ' || to_char(p_phase));

4503:
4504: install_ele_sets(p_phase); --install sets,type rules,class rules
4505:
4506: hr_legislation.hrrunprc_trace_on;
4507: hr_utility.trace('start install_utables: ' || to_char(p_phase));
4508: hr_legislation.hrrunprc_trace_off;
4509:
4510: install_utables(p_phase); --install user tables
4511:

Line 4513: hr_utility.trace('start install_ucolumns: ' || to_char(p_phase));

4509:
4510: install_utables(p_phase); --install user tables
4511:
4512: hr_legislation.hrrunprc_trace_on;
4513: hr_utility.trace('start install_ucolumns: ' || to_char(p_phase));
4514: hr_legislation.hrrunprc_trace_off;
4515:
4516: install_ucolumns(p_phase); --install user columns
4517: