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 1206: hr_utility.trace('sel pay_element_types_f TMR');

1202: v_new_element_type_flag := 'Y';
1203:
1204: WHEN TOO_MANY_ROWS THEN
1205: hr_legislation.hrrunprc_trace_on;
1206: hr_utility.trace('sel pay_element_types_f TMR');
1207: hr_utility.trace('element_name ' ||
1208: r_distinct.c_true_key);
1209: hr_utility.trace(':lc: ' || ':' ||
1210: r_distinct.legislation_code || ':');

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

1203:
1204: WHEN TOO_MANY_ROWS THEN
1205: hr_legislation.hrrunprc_trace_on;
1206: hr_utility.trace('sel pay_element_types_f TMR');
1207: hr_utility.trace('element_name ' ||
1208: r_distinct.c_true_key);
1209: hr_utility.trace(':lc: ' || ':' ||
1210: r_distinct.legislation_code || ':');
1211: hr_legislation.hrrunprc_trace_off;

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

1205: hr_legislation.hrrunprc_trace_on;
1206: hr_utility.trace('sel pay_element_types_f TMR');
1207: hr_utility.trace('element_name ' ||
1208: r_distinct.c_true_key);
1209: hr_utility.trace(':lc: ' || ':' ||
1210: r_distinct.legislation_code || ':');
1211: hr_legislation.hrrunprc_trace_off;
1212: raise;
1213: END;

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

1264: v_new_input_value_flag := 'Y';
1265:
1266: WHEN TOO_MANY_ROWS THEN
1267: hr_legislation.hrrunprc_trace_on;
1268: hr_utility.trace('sel pay_input_values_f TMR');
1269: hr_utility.trace('iv name ' ||
1270: i_vals.name);
1271: hr_utility.trace('element_type_id ' ||
1272: to_char(l_new_element_Type_id));

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

1265:
1266: WHEN TOO_MANY_ROWS THEN
1267: hr_legislation.hrrunprc_trace_on;
1268: hr_utility.trace('sel pay_input_values_f TMR');
1269: hr_utility.trace('iv name ' ||
1270: i_vals.name);
1271: hr_utility.trace('element_type_id ' ||
1272: to_char(l_new_element_Type_id));
1273: hr_utility.trace('element_name ' ||

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

1267: hr_legislation.hrrunprc_trace_on;
1268: hr_utility.trace('sel pay_input_values_f TMR');
1269: hr_utility.trace('iv name ' ||
1270: i_vals.name);
1271: hr_utility.trace('element_type_id ' ||
1272: to_char(l_new_element_Type_id));
1273: hr_utility.trace('element_name ' ||
1274: r_distinct.c_true_key);
1275: hr_legislation.hrrunprc_trace_off;

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

1269: hr_utility.trace('iv name ' ||
1270: i_vals.name);
1271: hr_utility.trace('element_type_id ' ||
1272: to_char(l_new_element_Type_id));
1273: hr_utility.trace('element_name ' ||
1274: r_distinct.c_true_key);
1275: hr_legislation.hrrunprc_trace_off;
1276: raise;
1277: END;

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

1396: from dual;
1397:
1398: WHEN TOO_MANY_ROWS THEN
1399: hr_legislation.hrrunprc_trace_on;
1400: hr_utility.trace('sel pay_status_processing_rules TMR');
1401:
1402: hr_utility.trace('assignment_status_type_id ' ||
1403: to_char(sprs.assignment_status_type_id));
1404: hr_utility.trace(':lc: ' || ':' ||

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

1398: WHEN TOO_MANY_ROWS THEN
1399: hr_legislation.hrrunprc_trace_on;
1400: hr_utility.trace('sel pay_status_processing_rules TMR');
1401:
1402: hr_utility.trace('assignment_status_type_id ' ||
1403: to_char(sprs.assignment_status_type_id));
1404: hr_utility.trace(':lc: ' || ':' ||
1405: r_distinct.legislation_code || ':');
1406: hr_legislation.hrrunprc_trace_off;

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

1400: hr_utility.trace('sel pay_status_processing_rules TMR');
1401:
1402: hr_utility.trace('assignment_status_type_id ' ||
1403: to_char(sprs.assignment_status_type_id));
1404: hr_utility.trace(':lc: ' || ':' ||
1405: r_distinct.legislation_code || ':');
1406: hr_legislation.hrrunprc_trace_off;
1407: raise;
1408: END;

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

2092: from hr_s_input_values_f
2093: where input_value_id = i_values.input_value_id;
2094: EXCEPTION WHEN OTHERS THEN
2095: hr_legislation.hrrunprc_trace_on;
2096: hr_utility.trace('ins pay_input_values_f');
2097: hr_utility.trace('iv id ' ||
2098: to_char(i_values.input_value_id));
2099: hr_utility.trace('iv name ' ||
2100: i_values.name);

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

2093: where input_value_id = i_values.input_value_id;
2094: EXCEPTION WHEN OTHERS THEN
2095: hr_legislation.hrrunprc_trace_on;
2096: hr_utility.trace('ins pay_input_values_f');
2097: hr_utility.trace('iv id ' ||
2098: to_char(i_values.input_value_id));
2099: hr_utility.trace('iv name ' ||
2100: i_values.name);
2101: hr_legislation.hrrunprc_trace_off;

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

2095: hr_legislation.hrrunprc_trace_on;
2096: hr_utility.trace('ins pay_input_values_f');
2097: hr_utility.trace('iv id ' ||
2098: to_char(i_values.input_value_id));
2099: hr_utility.trace('iv name ' ||
2100: i_values.name);
2101: hr_legislation.hrrunprc_trace_off;
2102: raise;
2103: END;

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

2365: ,each_row.TIME_DEFINITION_ID
2366: );
2367: EXCEPTION WHEN OTHERS THEN
2368: hr_legislation.hrrunprc_trace_on;
2369: hr_utility.trace('ins pay_element_types_f');
2370: hr_utility.trace('element type name ' ||
2371: each_row.element_name);
2372: hr_utility.trace('element_type_id ' ||
2373: to_char(each_row.element_type_id));

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

2366: );
2367: EXCEPTION WHEN OTHERS THEN
2368: hr_legislation.hrrunprc_trace_on;
2369: hr_utility.trace('ins pay_element_types_f');
2370: hr_utility.trace('element type name ' ||
2371: each_row.element_name);
2372: hr_utility.trace('element_type_id ' ||
2373: to_char(each_row.element_type_id));
2374: hr_utility.trace(':lc: ' || ':' ||

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

2368: hr_legislation.hrrunprc_trace_on;
2369: hr_utility.trace('ins pay_element_types_f');
2370: hr_utility.trace('element type name ' ||
2371: each_row.element_name);
2372: hr_utility.trace('element_type_id ' ||
2373: to_char(each_row.element_type_id));
2374: hr_utility.trace(':lc: ' || ':' ||
2375: each_row.legislation_code || ':');
2376: hr_legislation.hrrunprc_trace_off;

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

2370: hr_utility.trace('element type name ' ||
2371: each_row.element_name);
2372: hr_utility.trace('element_type_id ' ||
2373: to_char(each_row.element_type_id));
2374: hr_utility.trace(':lc: ' || ':' ||
2375: each_row.legislation_code || ':');
2376: hr_legislation.hrrunprc_trace_off;
2377: raise;
2378: END;

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

2424: ,s_rules.creation_date
2425: );
2426: EXCEPTION WHEN OTHERS THEN
2427: hr_legislation.hrrunprc_trace_on;
2428: hr_utility.trace('ins pay_sub_classification_rules_f');
2429: hr_utility.trace('sub_classification_rule_id ' ||
2430: to_char(s_rules.sub_classification_rule_id));
2431: hr_utility.trace('element_type_id ' ||
2432: to_char(s_rules.element_type_id));

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

2425: );
2426: EXCEPTION WHEN OTHERS THEN
2427: hr_legislation.hrrunprc_trace_on;
2428: hr_utility.trace('ins pay_sub_classification_rules_f');
2429: hr_utility.trace('sub_classification_rule_id ' ||
2430: to_char(s_rules.sub_classification_rule_id));
2431: hr_utility.trace('element_type_id ' ||
2432: to_char(s_rules.element_type_id));
2433: hr_utility.trace('classification_id ' ||

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

2427: hr_legislation.hrrunprc_trace_on;
2428: hr_utility.trace('ins pay_sub_classification_rules_f');
2429: hr_utility.trace('sub_classification_rule_id ' ||
2430: to_char(s_rules.sub_classification_rule_id));
2431: hr_utility.trace('element_type_id ' ||
2432: to_char(s_rules.element_type_id));
2433: hr_utility.trace('classification_id ' ||
2434: to_char(s_rules.classification_id));
2435: hr_utility.trace(':lc: ' || ':' ||

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

2429: hr_utility.trace('sub_classification_rule_id ' ||
2430: to_char(s_rules.sub_classification_rule_id));
2431: hr_utility.trace('element_type_id ' ||
2432: to_char(s_rules.element_type_id));
2433: hr_utility.trace('classification_id ' ||
2434: to_char(s_rules.classification_id));
2435: hr_utility.trace(':lc: ' || ':' ||
2436: s_rules.legislation_code || ':');
2437: hr_legislation.hrrunprc_trace_off;

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

2431: hr_utility.trace('element_type_id ' ||
2432: to_char(s_rules.element_type_id));
2433: hr_utility.trace('classification_id ' ||
2434: to_char(s_rules.classification_id));
2435: hr_utility.trace(':lc: ' || ':' ||
2436: s_rules.legislation_code || ':');
2437: hr_legislation.hrrunprc_trace_off;
2438: raise;
2439: END;

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

2507: ,all_rules.CREATION_DATE
2508: );
2509: EXCEPTION WHEN OTHERS THEN
2510: hr_legislation.hrrunprc_trace_on;
2511: hr_utility.trace('ins pay_status_processing_rules_f');
2512: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2513: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2514: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2515: to_char(all_rules.element_type_id));

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

2508: );
2509: EXCEPTION WHEN OTHERS THEN
2510: hr_legislation.hrrunprc_trace_on;
2511: hr_utility.trace('ins pay_status_processing_rules_f');
2512: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2513: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2514: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2515: to_char(all_rules.element_type_id));
2516: hr_utility.trace('PROCESSING_RULE ' ||

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

2510: hr_legislation.hrrunprc_trace_on;
2511: hr_utility.trace('ins pay_status_processing_rules_f');
2512: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2513: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2514: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2515: to_char(all_rules.element_type_id));
2516: hr_utility.trace('PROCESSING_RULE ' ||
2517: all_rules.PROCESSING_RULE);
2518: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||

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

2512: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2513: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2514: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2515: to_char(all_rules.element_type_id));
2516: hr_utility.trace('PROCESSING_RULE ' ||
2517: all_rules.PROCESSING_RULE);
2518: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||
2519: to_char(all_rules.ASSIGNMENT_STATUS_TYPE_ID));
2520: hr_utility.trace(':lc: ' || ':' ||

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

2514: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2515: to_char(all_rules.element_type_id));
2516: hr_utility.trace('PROCESSING_RULE ' ||
2517: all_rules.PROCESSING_RULE);
2518: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||
2519: to_char(all_rules.ASSIGNMENT_STATUS_TYPE_ID));
2520: hr_utility.trace(':lc: ' || ':' ||
2521: all_rules.legislation_code || ':');
2522: hr_legislation.hrrunprc_trace_off;

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

2516: hr_utility.trace('PROCESSING_RULE ' ||
2517: all_rules.PROCESSING_RULE);
2518: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||
2519: to_char(all_rules.ASSIGNMENT_STATUS_TYPE_ID));
2520: hr_utility.trace(':lc: ' || ':' ||
2521: all_rules.legislation_code || ':');
2522: hr_legislation.hrrunprc_trace_off;
2523: raise;
2524: END;

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

2568: ,all_frrs.CREATION_DATE
2569: );
2570: EXCEPTION WHEN OTHERS THEN
2571: hr_legislation.hrrunprc_trace_on;
2572: hr_utility.trace('ins pay_formula_result_rules_f');
2573: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2574: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2575: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2576: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));

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

2569: );
2570: EXCEPTION WHEN OTHERS THEN
2571: hr_legislation.hrrunprc_trace_on;
2572: hr_utility.trace('ins pay_formula_result_rules_f');
2573: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2574: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2575: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2576: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));
2577: hr_utility.trace('RESULT_NAME ' ||

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

2571: hr_legislation.hrrunprc_trace_on;
2572: hr_utility.trace('ins pay_formula_result_rules_f');
2573: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2574: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2575: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2576: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));
2577: hr_utility.trace('RESULT_NAME ' ||
2578: all_frrs.RESULT_NAME);
2579: hr_utility.trace(':lc: ' || ':' ||

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

2573: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2574: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2575: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2576: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));
2577: hr_utility.trace('RESULT_NAME ' ||
2578: all_frrs.RESULT_NAME);
2579: hr_utility.trace(':lc: ' || ':' ||
2580: all_frrs.legislation_code || ':');
2581: hr_legislation.hrrunprc_trace_off;

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

2575: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2576: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));
2577: hr_utility.trace('RESULT_NAME ' ||
2578: all_frrs.RESULT_NAME);
2579: hr_utility.trace(':lc: ' || ':' ||
2580: all_frrs.legislation_code || ':');
2581: hr_legislation.hrrunprc_trace_off;
2582: raise;
2583: END;

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

2847:
2848: WHEN TOO_MANY_ROWS THEN
2849:
2850: hr_legislation.hrrunprc_trace_on;
2851: hr_utility.trace('sel pay_element_sets TMR');
2852: hr_utility.trace('element_set_name ' ||
2853: stu_rec.c_true_key);
2854: hr_utility.trace(':lc: ' || ':' ||
2855: stu_rec.c_leg_code || ':');

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

2848: WHEN TOO_MANY_ROWS THEN
2849:
2850: hr_legislation.hrrunprc_trace_on;
2851: hr_utility.trace('sel pay_element_sets TMR');
2852: hr_utility.trace('element_set_name ' ||
2853: stu_rec.c_true_key);
2854: hr_utility.trace(':lc: ' || ':' ||
2855: stu_rec.c_leg_code || ':');
2856: hr_legislation.hrrunprc_trace_off;

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

2850: hr_legislation.hrrunprc_trace_on;
2851: hr_utility.trace('sel pay_element_sets TMR');
2852: hr_utility.trace('element_set_name ' ||
2853: stu_rec.c_true_key);
2854: hr_utility.trace(':lc: ' || ':' ||
2855: stu_rec.c_leg_code || ':');
2856: hr_legislation.hrrunprc_trace_off;
2857: raise;
2858: END;

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

3106: ,stu_rec.creation_date
3107: );
3108: EXCEPTION WHEN OTHERS THEN
3109: hr_legislation.hrrunprc_trace_on;
3110: hr_utility.trace('ins pay_element_sets');
3111: hr_utility.trace('element_set_name ' ||
3112: stu_rec.c_true_key);
3113: hr_utility.trace('element_set_id ' ||
3114: to_char(stu_rec.c_surrogate_key));

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

3107: );
3108: EXCEPTION WHEN OTHERS THEN
3109: hr_legislation.hrrunprc_trace_on;
3110: hr_utility.trace('ins pay_element_sets');
3111: hr_utility.trace('element_set_name ' ||
3112: stu_rec.c_true_key);
3113: hr_utility.trace('element_set_id ' ||
3114: to_char(stu_rec.c_surrogate_key));
3115: hr_utility.trace('element_set_type ' ||

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

3109: hr_legislation.hrrunprc_trace_on;
3110: hr_utility.trace('ins pay_element_sets');
3111: hr_utility.trace('element_set_name ' ||
3112: stu_rec.c_true_key);
3113: hr_utility.trace('element_set_id ' ||
3114: to_char(stu_rec.c_surrogate_key));
3115: hr_utility.trace('element_set_type ' ||
3116: stu_rec.element_set_type);
3117: hr_utility.trace(':lc: ' || ':' ||

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

3111: hr_utility.trace('element_set_name ' ||
3112: stu_rec.c_true_key);
3113: hr_utility.trace('element_set_id ' ||
3114: to_char(stu_rec.c_surrogate_key));
3115: hr_utility.trace('element_set_type ' ||
3116: stu_rec.element_set_type);
3117: hr_utility.trace(':lc: ' || ':' ||
3118: stu_rec.c_leg_code || ':');
3119: hr_legislation.hrrunprc_trace_off;

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

3113: hr_utility.trace('element_set_id ' ||
3114: to_char(stu_rec.c_surrogate_key));
3115: hr_utility.trace('element_set_type ' ||
3116: stu_rec.element_set_type);
3117: hr_utility.trace(':lc: ' || ':' ||
3118: stu_rec.c_leg_code || ':');
3119: hr_legislation.hrrunprc_trace_off;
3120: raise;
3121: END;

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

3155: ,ele_types.created_by
3156: ,ele_types.creation_date);
3157: EXCEPTION WHEN OTHERS THEN
3158: hr_legislation.hrrunprc_trace_on;
3159: hr_utility.trace('ins pay_element_type_rules');
3160: hr_utility.trace('element_type_id ' ||
3161: to_char(ele_types.element_Type_id));
3162: hr_utility.trace('element_set_id ' ||
3163: to_char(ele_types.element_Set_id));

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

3156: ,ele_types.creation_date);
3157: EXCEPTION WHEN OTHERS THEN
3158: hr_legislation.hrrunprc_trace_on;
3159: hr_utility.trace('ins pay_element_type_rules');
3160: hr_utility.trace('element_type_id ' ||
3161: to_char(ele_types.element_Type_id));
3162: hr_utility.trace('element_set_id ' ||
3163: to_char(ele_types.element_Set_id));
3164: hr_legislation.hrrunprc_trace_off;

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

3158: hr_legislation.hrrunprc_trace_on;
3159: hr_utility.trace('ins pay_element_type_rules');
3160: hr_utility.trace('element_type_id ' ||
3161: to_char(ele_types.element_Type_id));
3162: hr_utility.trace('element_set_id ' ||
3163: to_char(ele_types.element_Set_id));
3164: hr_legislation.hrrunprc_trace_off;
3165: raise;
3166: END;

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

3207: ,ele_class.created_by
3208: ,ele_class.creation_date);
3209: EXCEPTION WHEN OTHERS THEN
3210: hr_legislation.hrrunprc_trace_on;
3211: hr_utility.trace('ins pay_ele_classification_rules');
3212: hr_utility.trace('element_set_id ' ||
3213: to_char(ele_class.element_set_id));
3214: hr_utility.trace('classification_id ' ||
3215: to_char(ele_class.classification_id));

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

3208: ,ele_class.creation_date);
3209: EXCEPTION WHEN OTHERS THEN
3210: hr_legislation.hrrunprc_trace_on;
3211: hr_utility.trace('ins pay_ele_classification_rules');
3212: hr_utility.trace('element_set_id ' ||
3213: to_char(ele_class.element_set_id));
3214: hr_utility.trace('classification_id ' ||
3215: to_char(ele_class.classification_id));
3216: hr_legislation.hrrunprc_trace_off;

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

3210: hr_legislation.hrrunprc_trace_on;
3211: hr_utility.trace('ins pay_ele_classification_rules');
3212: hr_utility.trace('element_set_id ' ||
3213: to_char(ele_class.element_set_id));
3214: hr_utility.trace('classification_id ' ||
3215: to_char(ele_class.classification_id));
3216: hr_legislation.hrrunprc_trace_off;
3217: raise;
3218: END;

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

3448: from dual;
3449:
3450: WHEN TOO_MANY_ROWS THEN
3451: hr_legislation.hrrunprc_trace_on;
3452: hr_utility.trace('sel pay_user_tables TMR');
3453: hr_utility.trace('user_table_name ' ||
3454: stu_rec.c_true_key);
3455: hr_utility.trace(':lc: ' || ':' ||
3456: stu_rec.c_leg_code || ':');

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

3449:
3450: WHEN TOO_MANY_ROWS THEN
3451: hr_legislation.hrrunprc_trace_on;
3452: hr_utility.trace('sel pay_user_tables TMR');
3453: hr_utility.trace('user_table_name ' ||
3454: stu_rec.c_true_key);
3455: hr_utility.trace(':lc: ' || ':' ||
3456: stu_rec.c_leg_code || ':');
3457: hr_legislation.hrrunprc_trace_off;

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

3451: hr_legislation.hrrunprc_trace_on;
3452: hr_utility.trace('sel pay_user_tables TMR');
3453: hr_utility.trace('user_table_name ' ||
3454: stu_rec.c_true_key);
3455: hr_utility.trace(':lc: ' || ':' ||
3456: stu_rec.c_leg_code || ':');
3457: hr_legislation.hrrunprc_trace_off;
3458: raise;
3459:

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

3724: ,stu_rec.user_row_title
3725: );
3726: EXCEPTION WHEN OTHERS THEN
3727: hr_legislation.hrrunprc_trace_on;
3728: hr_utility.trace('ins pay_user_tables');
3729: hr_utility.trace('user_table_id ' ||
3730: to_char(stu_rec.c_surrogate_key));
3731: hr_utility.trace('user_table_name ' ||
3732: stu_rec.c_true_key);

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

3725: );
3726: EXCEPTION WHEN OTHERS THEN
3727: hr_legislation.hrrunprc_trace_on;
3728: hr_utility.trace('ins pay_user_tables');
3729: hr_utility.trace('user_table_id ' ||
3730: to_char(stu_rec.c_surrogate_key));
3731: hr_utility.trace('user_table_name ' ||
3732: stu_rec.c_true_key);
3733: hr_utility.trace(':lc: ' || ':' ||

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

3727: hr_legislation.hrrunprc_trace_on;
3728: hr_utility.trace('ins pay_user_tables');
3729: hr_utility.trace('user_table_id ' ||
3730: to_char(stu_rec.c_surrogate_key));
3731: hr_utility.trace('user_table_name ' ||
3732: stu_rec.c_true_key);
3733: hr_utility.trace(':lc: ' || ':' ||
3734: stu_rec.c_leg_code || ':');
3735: hr_legislation.hrrunprc_trace_off;

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

3729: hr_utility.trace('user_table_id ' ||
3730: to_char(stu_rec.c_surrogate_key));
3731: hr_utility.trace('user_table_name ' ||
3732: stu_rec.c_true_key);
3733: hr_utility.trace(':lc: ' || ':' ||
3734: stu_rec.c_leg_code || ':');
3735: hr_legislation.hrrunprc_trace_off;
3736: raise;
3737: END;

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

3966: from dual;
3967:
3968: WHEN TOO_MANY_ROWS THEN
3969: hr_legislation.hrrunprc_trace_on;
3970: hr_utility.trace('sel pay_user_columns TMR');
3971: hr_utility.trace('user_column_name ' ||
3972: stu_rec.c_true_key);
3973: hr_utility.trace('user_table_id ' ||
3974: to_char(stu_rec.user_table_id));

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

3967:
3968: WHEN TOO_MANY_ROWS THEN
3969: hr_legislation.hrrunprc_trace_on;
3970: hr_utility.trace('sel pay_user_columns TMR');
3971: hr_utility.trace('user_column_name ' ||
3972: stu_rec.c_true_key);
3973: hr_utility.trace('user_table_id ' ||
3974: to_char(stu_rec.user_table_id));
3975: hr_utility.trace(':lc: ' || ':' ||

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

3969: hr_legislation.hrrunprc_trace_on;
3970: hr_utility.trace('sel pay_user_columns TMR');
3971: hr_utility.trace('user_column_name ' ||
3972: stu_rec.c_true_key);
3973: hr_utility.trace('user_table_id ' ||
3974: to_char(stu_rec.user_table_id));
3975: hr_utility.trace(':lc: ' || ':' ||
3976: stu_rec.c_leg_code || ':');
3977: hr_legislation.hrrunprc_trace_off;

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

3971: hr_utility.trace('user_column_name ' ||
3972: stu_rec.c_true_key);
3973: hr_utility.trace('user_table_id ' ||
3974: to_char(stu_rec.user_table_id));
3975: hr_utility.trace(':lc: ' || ':' ||
3976: stu_rec.c_leg_code || ':');
3977: hr_legislation.hrrunprc_trace_off;
3978: raise;
3979: END;

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

4375: ,stu_rec.creation_date
4376: );
4377: EXCEPTION WHEN OTHERS THEN
4378: hr_legislation.hrrunprc_trace_on;
4379: hr_utility.trace('ins pay_user_columns');
4380: hr_utility.trace('user_column_id ' ||
4381: to_char(stu_rec.c_surrogate_key));
4382: hr_utility.trace('user_column_name ' ||
4383: stu_rec.c_true_key);

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

4376: );
4377: EXCEPTION WHEN OTHERS THEN
4378: hr_legislation.hrrunprc_trace_on;
4379: hr_utility.trace('ins pay_user_columns');
4380: hr_utility.trace('user_column_id ' ||
4381: to_char(stu_rec.c_surrogate_key));
4382: hr_utility.trace('user_column_name ' ||
4383: stu_rec.c_true_key);
4384: hr_utility.trace('user_table_id ' ||

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

4378: hr_legislation.hrrunprc_trace_on;
4379: hr_utility.trace('ins pay_user_columns');
4380: hr_utility.trace('user_column_id ' ||
4381: to_char(stu_rec.c_surrogate_key));
4382: hr_utility.trace('user_column_name ' ||
4383: stu_rec.c_true_key);
4384: hr_utility.trace('user_table_id ' ||
4385: to_char(stu_rec.user_table_id));
4386: hr_utility.trace(':lc: ' || ':' ||

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

4380: hr_utility.trace('user_column_id ' ||
4381: to_char(stu_rec.c_surrogate_key));
4382: hr_utility.trace('user_column_name ' ||
4383: stu_rec.c_true_key);
4384: hr_utility.trace('user_table_id ' ||
4385: to_char(stu_rec.user_table_id));
4386: hr_utility.trace(':lc: ' || ':' ||
4387: stu_rec.c_leg_code || ':');
4388: hr_legislation.hrrunprc_trace_off;

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

4382: hr_utility.trace('user_column_name ' ||
4383: stu_rec.c_true_key);
4384: hr_utility.trace('user_table_id ' ||
4385: to_char(stu_rec.user_table_id));
4386: hr_utility.trace(':lc: ' || ':' ||
4387: stu_rec.c_leg_code || ':');
4388: hr_legislation.hrrunprc_trace_off;
4389: raise;
4390: END;

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

4453:
4454: IF p_phase = 1 OR p_phase =2 THEN
4455:
4456: hr_legislation.hrrunprc_trace_on;
4457: hr_utility.trace('start install_ele_class: ' || to_char(p_phase));
4458: hr_legislation.hrrunprc_trace_off;
4459:
4460: install_ele_class(p_phase); --install element classifications
4461:

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

4459:
4460: install_ele_class(p_phase); --install element classifications
4461:
4462: hr_legislation.hrrunprc_trace_on;
4463: hr_utility.trace('start install_elements: ' || to_char(p_phase));
4464: hr_legislation.hrrunprc_trace_off;
4465:
4466: install_elements(p_phase); --install elements,sprs,frrs,inputs
4467:

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

4465:
4466: install_elements(p_phase); --install elements,sprs,frrs,inputs
4467:
4468: hr_legislation.hrrunprc_trace_on;
4469: hr_utility.trace('start install_ele_sets: ' || to_char(p_phase));
4470: hr_legislation.hrrunprc_trace_off;
4471:
4472: install_ele_sets(p_phase); --install sets,type rules,class rules
4473:

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

4471:
4472: install_ele_sets(p_phase); --install sets,type rules,class rules
4473:
4474: hr_legislation.hrrunprc_trace_on;
4475: hr_utility.trace('start install_utables: ' || to_char(p_phase));
4476: hr_legislation.hrrunprc_trace_off;
4477:
4478: install_utables(p_phase); --install user tables
4479:

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

4477:
4478: install_utables(p_phase); --install user tables
4479:
4480: hr_legislation.hrrunprc_trace_on;
4481: hr_utility.trace('start install_ucolumns: ' || to_char(p_phase));
4482: hr_legislation.hrrunprc_trace_off;
4483:
4484: install_ucolumns(p_phase); --install user columns
4485: