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.PAY_AU_RETRO_UPGRADE dependencies on HR_UTILITY

Line 35: 13-Sep-2006 abhargav 120.4 5461629 Added check whether debug is enabled before printing hr_utility trace messages.

31: ----------- ---------- ------ ------- -----------------------------------
32: 05-JAN-2006 ksingla 120.0 4753806 Intial Version
33: 29-AUG-2006 priupadh 120.2 5461632 Removed Trace on and Off in Package
34: 11-Sep-2006 abhargav 120.3 5461629 Added log messages.
35: 13-Sep-2006 abhargav 120.4 5461629 Added check whether debug is enabled before printing hr_utility trace messages.
36: 18-Sep-2006 abhargav 120.5 5461633 Modified procedure upgrade_element() and function create_element() so that
37: element get upgraded for the cases where retro element for the element
38: has already been upgraded.
39: 19-Sep-2006 abhargav 120.7 5461633 Modified the comments.

Line 156: g_debug := hr_utility.debug_enabled;

152: l_element_name_warning BOOLEAN;
153: l_element_name_change_warning BOOLEAN;
154:
155: BEGIN
156: g_debug := hr_utility.debug_enabled;
157: lv_procedure_name := 'insert_event_group';
158:
159: IF g_debug THEN
160: hr_utility.trace('Entering ' || lv_procedure_name);

Line 160: hr_utility.trace('Entering ' || lv_procedure_name);

156: g_debug := hr_utility.debug_enabled;
157: lv_procedure_name := 'insert_event_group';
158:
159: IF g_debug THEN
160: hr_utility.trace('Entering ' || lv_procedure_name);
161: END if;
162:
163:
164: open c_get_retro_element_info;

Line 236: hr_utility.trace('Updated Event Group for Element: ' || p_element_type_id);

232: ,p_element_name_change_warning => l_element_name_change_warning
233: );
234:
235: IF g_debug THEN
236: hr_utility.trace('Updated Event Group for Element: ' || p_element_type_id);
237: END if;
238:
239: END IF;
240:

Line 246: hr_utility.trace('Leaving ' || lv_procedure_name);

242:
243: close c_get_retro_element_info;
244:
245: IF g_debug THEN
246: hr_utility.trace('Leaving ' || lv_procedure_name);
247: END if;
248:
249: exception
250: when others then

Line 252: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

248:
249: exception
250: when others then
251: IF g_debug THEN
252: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
253: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
254: End if;
255:
256: raise;

Line 253: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

249: exception
250: when others then
251: IF g_debug THEN
252: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
253: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
254: End if;
255:
256: raise;
257:

Line 293: g_debug := hr_utility.debug_enabled;

289: l_ele_entry_value_table_id NUMBER;
290:
291:
292: BEGIN
293: g_debug := hr_utility.debug_enabled;
294: l_effective_date := to_date('1900/01/01','YYYY/MM/DD');
295:
296: lv_procedure_name := 'create_event_group';
297:

Line 299: hr_utility.trace('Entering ' || lv_procedure_name);

295:
296: lv_procedure_name := 'create_event_group';
297:
298: IF g_debug THEN
299: hr_utility.trace('Entering ' || lv_procedure_name);
300: END if;
301:
302: /* Checks whether event group already exist */
303: OPEN c_get_event_group_id;

Line 394: hr_utility.trace('p_event_group_id: ' || p_event_group_id);

390:
391: p_event_group_id := l_event_group_id;
392:
393: IF g_debug THEN
394: hr_utility.trace('p_event_group_id: ' || p_event_group_id);
395: hr_utility.trace('Leaving ' || lv_procedure_name);
396: End If;
397:
398: exception

Line 395: hr_utility.trace('Leaving ' || lv_procedure_name);

391: p_event_group_id := l_event_group_id;
392:
393: IF g_debug THEN
394: hr_utility.trace('p_event_group_id: ' || p_event_group_id);
395: hr_utility.trace('Leaving ' || lv_procedure_name);
396: End If;
397:
398: exception
399: when others then

Line 401: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

397:
398: exception
399: when others then
400: IF g_debug THEN
401: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
402: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
403: End If;
404:
405: raise;

Line 402: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

398: exception
399: when others then
400: IF g_debug THEN
401: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
402: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
403: End If;
404:
405: raise;
406: END;

Line 480: g_debug := hr_utility.debug_enabled;

476: l_element_type_id NUMBER;
477: lv_procedure_name VARCHAR2(50);
478:
479: BEGIN
480: g_debug := hr_utility.debug_enabled;
481: lv_procedure_name := 'create_ff_results';
482:
483: IF g_debug THEN
484: hr_utility.trace('Entering ' || lv_procedure_name);

Line 484: hr_utility.trace('Entering ' || lv_procedure_name);

480: g_debug := hr_utility.debug_enabled;
481: lv_procedure_name := 'create_ff_results';
482:
483: IF g_debug THEN
484: hr_utility.trace('Entering ' || lv_procedure_name);
485: End if;
486:
487:
488: l_legislation_code := 'AU';

Line 496: hr_utility.trace('p_business_group_id: ' || p_business_group_id);

492: l_result_name := 'L_DUMMY';
493: l_result_rule_type := 'I';
494:
495: IF g_debug THEN
496: hr_utility.trace('p_business_group_id: ' || p_business_group_id);
497: hr_utility.trace('p_retro_type: ' || p_retro_type);
498: hr_utility.trace('p_element_type_id: ' || p_element_type_id);
499: End if;
500:

Line 497: hr_utility.trace('p_retro_type: ' || p_retro_type);

493: l_result_rule_type := 'I';
494:
495: IF g_debug THEN
496: hr_utility.trace('p_business_group_id: ' || p_business_group_id);
497: hr_utility.trace('p_retro_type: ' || p_retro_type);
498: hr_utility.trace('p_element_type_id: ' || p_element_type_id);
499: End if;
500:
501: /* Gets the processing rule id for element */

Line 498: hr_utility.trace('p_element_type_id: ' || p_element_type_id);

494:
495: IF g_debug THEN
496: hr_utility.trace('p_business_group_id: ' || p_business_group_id);
497: hr_utility.trace('p_retro_type: ' || p_retro_type);
498: hr_utility.trace('p_element_type_id: ' || p_element_type_id);
499: End if;
500:
501: /* Gets the processing rule id for element */
502: OPEN c_get_formula_results(p_element_type_id);

Line 512: hr_utility.trace('l_formula_id: ' || l_formula_id);

508: FETCH c_get_formula_id INTO l_formula_id;
509: CLOSE c_get_formula_id;
510:
511: IF g_debug THEN
512: hr_utility.trace('l_formula_id: ' || l_formula_id);
513: End if;
514:
515: IF nvl(l_status_processing_rule_id,9999) = 9999 THEN
516:

Line 574: hr_utility.trace('Leaving ' || lv_procedure_name);

570: );
571: END IF;
572:
573: IF g_debug THEN
574: hr_utility.trace('Leaving ' || lv_procedure_name);
575: End if;
576:
577: exception
578: when others then

Line 580: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

576:
577: exception
578: when others then
579: IF g_debug THEN
580: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
581: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
582: End if;
583: raise;
584: END;

Line 581: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

577: exception
578: when others then
579: IF g_debug THEN
580: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
581: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
582: End if;
583: raise;
584: END;
585:

Line 645: g_debug := hr_utility.debug_enabled;

641: l_effective_date DATE;
642: lv_procedure_name VARCHAR2(50);
643:
644: BEGIN
645: g_debug := hr_utility.debug_enabled;
646:
647: lv_procedure_name := 'create_balance_feeds';
648:
649: IF g_debug THEN

Line 650: hr_utility.trace('Entering ' || lv_procedure_name);

646:
647: lv_procedure_name := 'create_balance_feeds';
648:
649: IF g_debug THEN
650: hr_utility.trace('Entering ' || lv_procedure_name);
651: End if;
652:
653: l_effective_date := to_date('2005/07/01','YYYY/MM/DD');
654:

Line 667: hr_utility.trace('Creating Balance Feed for input value ' || csr_rec_iv.name);

663: FETCH c_get_input_value_id INTO l_input_value_id;
664: CLOSE c_get_input_value_id;
665:
666: IF g_debug THEN
667: hr_utility.trace('Creating Balance Feed for input value ' || csr_rec_iv.name);
668: hr_utility.trace('Input Value ID: ' || l_input_value_id);
669: End if;
670:
671: IF UPPER(csr_rec_iv.NAME) = UPPER('Pay Value') THEN

Line 668: hr_utility.trace('Input Value ID: ' || l_input_value_id);

664: CLOSE c_get_input_value_id;
665:
666: IF g_debug THEN
667: hr_utility.trace('Creating Balance Feed for input value ' || csr_rec_iv.name);
668: hr_utility.trace('Input Value ID: ' || l_input_value_id);
669: End if;
670:
671: IF UPPER(csr_rec_iv.NAME) = UPPER('Pay Value') THEN
672: /* Checks whether seeded balance feed exist for element created by upgrade process */

Line 680: hr_utility.trace('Create Seeded Balance Feed');

676: /* Checks whether balance feed does not exist and element classification is not of type Pre Tax Deductions */
677: IF l_exists = 0 AND p_scale <> 0 THEN
678:
679: IF g_debug THEN
680: hr_utility.trace('Create Seeded Balance Feed');
681: End if;
682: /* Creates balance feeds for the elements created by upgrade process */
683: hr_balances.ins_balance_feed(
684: p_option => 'INS_MANUAL_FEED',

Line 697: hr_utility.trace('Created Seeded Balance Feed');

693: p_business_group => p_business_group_id,
694: p_legislation_code => NULL,
695: p_mode => 'USER');
696: IF g_debug THEN
697: hr_utility.trace('Created Seeded Balance Feed');
698: End if;
699: END IF;
700: END IF;
701: /* Checks whether user balance feed exist for element created by upgrade process */

Line 709: hr_utility.trace('Create User Balance Feed FOR balance TYPE id: ' || csr_rec_bf.balance_type_id);

705:
706: IF l_exists = 0 THEN
707:
708: IF g_debug THEN
709: hr_utility.trace('Create User Balance Feed FOR balance TYPE id: ' || csr_rec_bf.balance_type_id);
710: End if;
711:
712: hr_balances.ins_balance_feed(
713: p_option => 'INS_MANUAL_FEED',

Line 726: hr_utility.trace('Created User Balance Feed');

722: p_business_group => p_business_group_id,
723: p_legislation_code => NULL,
724: p_mode => 'USER');
725: IF g_debug THEN
726: hr_utility.trace('Created User Balance Feed');
727: End if;
728:
729: END IF;
730:

Line 736: hr_utility.trace('Leaving ' || lv_procedure_name);

732:
733: END LOOP;
734:
735: IF g_debug THEN
736: hr_utility.trace('Leaving ' || lv_procedure_name);
737: End if;
738: exception
739: when others then
740: IF g_debug THEN

Line 741: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

737: End if;
738: exception
739: when others then
740: IF g_debug THEN
741: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
742: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
743: End if;
744: raise;
745: END;

Line 742: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

738: exception
739: when others then
740: IF g_debug THEN
741: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
742: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
743: End if;
744: raise;
745: END;
746:

Line 819: g_debug := hr_utility.debug_enabled;

815: lv_ovn_invl number;
816:
817: rec_input_values_user c_input_exists%ROWTYPE;
818: begin
819: g_debug := hr_utility.debug_enabled;
820: lv_procedure_name := 'create_input_value';
821:
822: IF g_debug THEN
823: hr_utility.trace('Entering ' || lv_procedure_name);

Line 823: hr_utility.trace('Entering ' || lv_procedure_name);

819: g_debug := hr_utility.debug_enabled;
820: lv_procedure_name := 'create_input_value';
821:
822: IF g_debug THEN
823: hr_utility.trace('Entering ' || lv_procedure_name);
824: End if;
825:
826: l_effective_date := to_date('2005/07/01','YYYY/MM/DD');
827:

Line 829: hr_utility.trace(p_business_group_id || ' p_business_group_id');

825:
826: l_effective_date := to_date('2005/07/01','YYYY/MM/DD');
827:
828: IF g_debug THEN
829: hr_utility.trace(p_business_group_id || ' p_business_group_id');
830: hr_utility.trace(p_retro_element_id || ' p_retro_element_id');
831: hr_utility.trace(p_element_type_id || ' p_element_type_id');
832: hr_utility.trace(p_retro_type || ' p_retro_type');
833: End if;

Line 830: hr_utility.trace(p_retro_element_id || ' p_retro_element_id');

826: l_effective_date := to_date('2005/07/01','YYYY/MM/DD');
827:
828: IF g_debug THEN
829: hr_utility.trace(p_business_group_id || ' p_business_group_id');
830: hr_utility.trace(p_retro_element_id || ' p_retro_element_id');
831: hr_utility.trace(p_element_type_id || ' p_element_type_id');
832: hr_utility.trace(p_retro_type || ' p_retro_type');
833: End if;
834:

Line 831: hr_utility.trace(p_element_type_id || ' p_element_type_id');

827:
828: IF g_debug THEN
829: hr_utility.trace(p_business_group_id || ' p_business_group_id');
830: hr_utility.trace(p_retro_element_id || ' p_retro_element_id');
831: hr_utility.trace(p_element_type_id || ' p_element_type_id');
832: hr_utility.trace(p_retro_type || ' p_retro_type');
833: End if;
834:
835: /* Fetches the details of input value of retro element */

Line 832: hr_utility.trace(p_retro_type || ' p_retro_type');

828: IF g_debug THEN
829: hr_utility.trace(p_business_group_id || ' p_business_group_id');
830: hr_utility.trace(p_retro_element_id || ' p_retro_element_id');
831: hr_utility.trace(p_element_type_id || ' p_element_type_id');
832: hr_utility.trace(p_retro_type || ' p_retro_type');
833: End if;
834:
835: /* Fetches the details of input value of retro element */
836: open c_get_input_value_info;

Line 874: hr_utility.trace(rec_input_values.NAME || ' does not exists');

870: end if;
871:
872: if c_input_exists%notfound then
873: IF g_debug THEN
874: hr_utility.trace(rec_input_values.NAME || ' does not exists');
875: End if;
876: /* Created input value similar to retro element for the element created by Upgrade process */
877: PAY_INPUT_VALUE_API.CREATE_INPUT_VALUE
878: ( P_EFFECTIVE_DATE => l_effective_date

Line 906: hr_utility.trace(rec_input_values.NAME || ' Created');

902: ,P_FORMULA_MESSAGE => l_message
903: );
904:
905: IF g_debug THEN
906: hr_utility.trace(rec_input_values.NAME || ' Created');
907: End if;
908:
909: end if;
910: close c_input_exists;

Line 917: hr_utility.trace('Leaving ' || lv_procedure_name);

913:
914: close c_get_input_value_info;
915:
916: IF g_debug THEN
917: hr_utility.trace('Leaving ' || lv_procedure_name);
918: End if;
919: exception
920: when others then
921: IF g_debug THEN

Line 922: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

918: End if;
919: exception
920: when others then
921: IF g_debug THEN
922: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
923: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
924: End if;
925: raise;
926: end;

Line 923: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

919: exception
920: when others then
921: IF g_debug THEN
922: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
923: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
924: End if;
925: raise;
926: end;
927:

Line 1077: g_debug := hr_utility.debug_enabled;

1073: l_effective_start_date_li date;
1074: l_effective_end_date_li date;
1075: l_entries_warning_li boolean;
1076: begin
1077: g_debug := hr_utility.debug_enabled;
1078: l_upgraded_element :='N'; /* Flag to check whether element was created by Upgrade process */
1079: l_effective_date := to_date('2005/07/01','YYYY/MM/DD');
1080:
1081: lv_procedure_name := 'create_element';

Line 1084: hr_utility.trace('Entering ' || lv_procedure_name);

1080:
1081: lv_procedure_name := 'create_element';
1082:
1083: IF g_debug THEN
1084: hr_utility.trace('Entering ' || lv_procedure_name);
1085: End if;
1086:
1087: /* Gets the details of Retro Element */
1088: open c_get_retro_element_info;

Line 1093: hr_utility.trace('Retro Element Name: ' || rec_element_types.element_name);

1089: fetch c_get_retro_element_info into rec_element_types;
1090: close c_get_retro_element_info;
1091:
1092: IF g_debug THEN
1093: hr_utility.trace('Retro Element Name: ' || rec_element_types.element_name);
1094: End if;
1095: /* Checks whether element already exist before creating the element + */
1096: OPEN c_element_exists;
1097: FETCH c_element_exists INTO l_element_type_id;

Line 1101: hr_utility.trace('Creating New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );

1097: FETCH c_element_exists INTO l_element_type_id;
1098: IF c_element_exists%NOTFOUND THEN
1099:
1100: IF g_debug THEN
1101: hr_utility.trace('Creating New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );
1102: End if;
1103: /* Creates element + */
1104: /* Bug 5749509 - ONCE_EACH_PERIOD_FLAG - Specify default of 'N' if existing value is Null
1105: - TIME_DEFINITION_TYPE,TIME_DEFINITION_TYPE added in API call

Line 1177: hr_utility.trace('Created New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );

1173: ,p_element_type_extra_info_id => l_eei_info_id
1174: ,p_object_version_number => l_ovn_eei);
1175:
1176: IF g_debug THEN
1177: hr_utility.trace('Created New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );
1178: End if;
1179: /* Gets the details of element link of retro element, if link exist
1180: create the similar element link for newly created element */
1181:

Line 1190: hr_utility.trace('Creating Element links for New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );

1186: IF c_get_element_links%NOTFOUND THEN
1187: exit;
1188: ELSE
1189: IF g_debug THEN
1190: hr_utility.trace('Creating Element links for New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );
1191: End if;
1192:
1193: pay_element_link_api.create_element_link
1194: (p_effective_date => rec_element_links.effective_start_date /* 5731490 */

Line 1223: hr_utility.trace('Created Element links for New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );

1219: ,p_effective_start_date => l_effective_start_date
1220: ,p_effective_end_date => l_effective_end_date
1221: );
1222: IF g_debug THEN
1223: hr_utility.trace('Created Element links for New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );
1224: End if;
1225: /* 5731490 End dates link*/
1226: if to_char(rec_element_links.effective_end_date,'YYYY/MM/DD') <> '4712/12/31' then
1227: pay_element_link_api.delete_element_link

Line 1250: hr_utility.trace('Leaving ' || lv_procedure_name);

1246:
1247: CLOSE c_element_exists;
1248:
1249: IF g_debug THEN
1250: hr_utility.trace('Leaving ' || lv_procedure_name);
1251: End if;
1252: exception
1253: when others then
1254: IF g_debug THEN

Line 1255: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

1251: End if;
1252: exception
1253: when others then
1254: IF g_debug THEN
1255: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1256: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1257: End if;
1258: raise;
1259: end;

Line 1256: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

1252: exception
1253: when others then
1254: IF g_debug THEN
1255: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1256: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1257: End if;
1258: raise;
1259: end;
1260: /*

Line 1291: g_debug := hr_utility.debug_enabled;

1287: AND retro_component_id = p_retro_component_id;
1288:
1289:
1290: BEGIN
1291: g_debug := hr_utility.debug_enabled;
1292: lv_procedure_name := '.insert_retro_comp_usages';
1293:
1294: IF g_debug THEN
1295: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

Line 1295: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

1291: g_debug := hr_utility.debug_enabled;
1292: lv_procedure_name := '.insert_retro_comp_usages';
1293:
1294: IF g_debug THEN
1295: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1296: End if;
1297: /* Checks whether retro compnoned already exist */
1298: OPEN c_retro_comp_exists;
1299: FETCH c_retro_comp_exists INTO ln_retro_component_usage_id;

Line 1319: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);

1315:
1316: p_retro_comp_usage_id := ln_retro_component_usage_id;
1317:
1318: IF g_debug THEN
1319: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);
1320: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
1321: End if;
1322: ELSE
1323: p_retro_comp_usage_id := ln_retro_component_usage_id;

Line 1320: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

1316: p_retro_comp_usage_id := ln_retro_component_usage_id;
1317:
1318: IF g_debug THEN
1319: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);
1320: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
1321: End if;
1322: ELSE
1323: p_retro_comp_usage_id := ln_retro_component_usage_id;
1324: END IF;

Line 1329: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

1325:
1326: exception
1327: when others then
1328: IF g_debug THEN
1329: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1330: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1331: End if;
1332:
1333: raise;

Line 1330: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

1326: exception
1327: when others then
1328: IF g_debug THEN
1329: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1330: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1331: End if;
1332:
1333: raise;
1334: END insert_retro_comp_usages;

Line 1356: g_debug := hr_utility.debug_enabled;

1352:
1353: lv_procedure_name VARCHAR2(100);
1354:
1355: BEGIN
1356: g_debug := hr_utility.debug_enabled;
1357: lv_procedure_name := '.insert_element_span_usages';
1358:
1359: IF g_debug THEN
1360: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

Line 1360: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

1356: g_debug := hr_utility.debug_enabled;
1357: lv_procedure_name := '.insert_element_span_usages';
1358:
1359: IF g_debug THEN
1360: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1361: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
1362: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
1363: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1364: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);

Line 1361: hr_utility.trace('p_business_group_id ='|| p_business_group_id);

1357: lv_procedure_name := '.insert_element_span_usages';
1358:
1359: IF g_debug THEN
1360: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1361: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
1362: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
1363: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1364: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
1365: End if;

Line 1362: hr_utility.trace('p_time_span_id ='|| p_time_span_id);

1358:
1359: IF g_debug THEN
1360: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1361: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
1362: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
1363: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1364: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
1365: End if;
1366:

Line 1363: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);

1359: IF g_debug THEN
1360: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1361: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
1362: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
1363: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1364: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
1365: End if;
1366:
1367: insert into pay_element_span_usages

Line 1364: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);

1360: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1361: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
1362: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
1363: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1364: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
1365: End if;
1366:
1367: insert into pay_element_span_usages
1368: (element_span_usage_id, business_group_id, time_span_id,

Line 1378: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

1374: p_retro_comp_usage_id, p_retro_element_type_id,
1375: sysdate, 2, sysdate, 2, 2, 1);
1376:
1377: IF g_debug THEN
1378: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
1379: End if;
1380:
1381: exception
1382: when others then

Line 1384: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

1380:
1381: exception
1382: when others then
1383: IF g_debug THEN
1384: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1385: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1386: End if;
1387: raise;
1388: END insert_element_span_usages;

Line 1385: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

1381: exception
1382: when others then
1383: IF g_debug THEN
1384: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1385: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1386: End if;
1387: raise;
1388: END insert_element_span_usages;
1389:

Line 1427: g_debug := hr_utility.debug_enabled;

1423: l_user_element_exist char(1);
1424: l_upgrade_element_exist char(1);
1425: lv_procedure_name varchar2(30);
1426: Begin
1427: g_debug := hr_utility.debug_enabled;
1428:
1429: lv_procedure_name := '.element_exist_check';
1430: l_upgraded_element:='N';
1431: l_user_element_exist :='N';

Line 1464: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

1460:
1461: exception
1462: when others then
1463: IF g_debug THEN
1464: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1465: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1466: End if;
1467: raise;
1468: end element_exist_check;

Line 1465: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

1461: exception
1462: when others then
1463: IF g_debug THEN
1464: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1465: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1466: End if;
1467: raise;
1468: end element_exist_check;
1469:

Line 1606: g_debug := hr_utility.debug_enabled;

1602: ln_retro_summ_ele_id NUMBER; /* Bug 5731490 */
1603: ln_element_set_exist boolean; /* Bug 5731490 */
1604:
1605: BEGIN
1606: g_debug := hr_utility.debug_enabled;
1607:
1608: lv_procedure_name := '.qualify_element';
1609:
1610: IF g_debug THEN

Line 1611: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

1607:
1608: lv_procedure_name := '.qualify_element';
1609:
1610: IF g_debug THEN
1611: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1612: End if;
1613:
1614: lv_qualified := 'N';
1615: lv_legislation_code := null;

Line 1634: hr_utility.trace('ln_classification_id: ' || ln_classification_id);

1630: close c_element_class;
1631:
1632: IF ln_classification_id IS NOT NULL THEN
1633: IF g_debug THEN
1634: hr_utility.trace('ln_classification_id: ' || ln_classification_id);
1635: hr_utility.trace('lv_element_name: ' || lv_element_name);
1636: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1637: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1638: hr_utility.trace('lv_label: ' || lv_label);

Line 1635: hr_utility.trace('lv_element_name: ' || lv_element_name);

1631:
1632: IF ln_classification_id IS NOT NULL THEN
1633: IF g_debug THEN
1634: hr_utility.trace('ln_classification_id: ' || ln_classification_id);
1635: hr_utility.trace('lv_element_name: ' || lv_element_name);
1636: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1637: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1638: hr_utility.trace('lv_label: ' || lv_label);
1639: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);

Line 1636: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);

1632: IF ln_classification_id IS NOT NULL THEN
1633: IF g_debug THEN
1634: hr_utility.trace('ln_classification_id: ' || ln_classification_id);
1635: hr_utility.trace('lv_element_name: ' || lv_element_name);
1636: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1637: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1638: hr_utility.trace('lv_label: ' || lv_label);
1639: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);
1640: End if;

Line 1637: hr_utility.trace('lv_classification_name: ' || lv_classification_name);

1633: IF g_debug THEN
1634: hr_utility.trace('ln_classification_id: ' || ln_classification_id);
1635: hr_utility.trace('lv_element_name: ' || lv_element_name);
1636: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1637: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1638: hr_utility.trace('lv_label: ' || lv_label);
1639: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);
1640: End if;
1641:

Line 1638: hr_utility.trace('lv_label: ' || lv_label);

1634: hr_utility.trace('ln_classification_id: ' || ln_classification_id);
1635: hr_utility.trace('lv_element_name: ' || lv_element_name);
1636: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1637: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1638: hr_utility.trace('lv_label: ' || lv_label);
1639: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);
1640: End if;
1641:
1642: if lv_legislation_code is null and

Line 1639: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);

1635: hr_utility.trace('lv_element_name: ' || lv_element_name);
1636: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1637: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1638: hr_utility.trace('lv_label: ' || lv_label);
1639: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);
1640: End if;
1641:
1642: if lv_legislation_code is null and
1643: ln_business_group_id is not null then

Line 1675: hr_utility.trace('Element Set ID ' || ln_element_set_id);

1671: exit;
1672: end if;
1673: ln_element_set_exist := TRUE; /* 5731490 */
1674: IF g_debug THEN
1675: hr_utility.trace('Element Set ID ' || ln_element_set_id);
1676: End if;
1677: /* Chechk whether Element set is used for retropayment */
1678: /* Bug 5731490 - Check Added for summary element */
1679: open c_element_check(ln_element_set_id);

Line 1688: hr_utility.trace('UPGRADE Element ' || lv_element_name ||

1684:
1685: lv_qualified := 'Y';
1686:
1687: IF g_debug THEN
1688: hr_utility.trace('UPGRADE Element ' || lv_element_name ||
1689: '(' || p_object_id || ')');
1690: End if;
1691: exit;
1692: else

Line 1695: hr_utility.trace('Element ' || lv_element_name ||

1691: exit;
1692: else
1693: lv_qualified := 'N';
1694: IF g_debug THEN
1695: hr_utility.trace('Element ' || lv_element_name ||
1696: '(' || p_object_id || ') does not need to be upgraded');
1697: End if;
1698:
1699: end if;

Line 1720: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

1716: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Element ' || lv_element_name || ' (Element Type ID: ' || p_object_id|| ')'|| ' with classification ' ||lv_classification_name||' '||lv_label||' does not require upgrade.');
1717: end if;
1718:
1719: IF g_debug THEN
1720: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
1721: End if;
1722:
1723: exception
1724: when others then

Line 1726: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

1722:
1723: exception
1724: when others then
1725: IF g_debug THEN
1726: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1727: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1728: End if;
1729:
1730: raise;

Line 1727: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

1723: exception
1724: when others then
1725: IF g_debug THEN
1726: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1727: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1728: End if;
1729:
1730: raise;
1731: END qualify_element;

Line 1896: g_debug := hr_utility.debug_enabled;

1892: l_retro_balance_name VARCHAR2(80);
1893:
1894:
1895: BEGIN
1896: g_debug := hr_utility.debug_enabled;
1897: lv_procedure_name := '.upgrade_element';
1898: l_warning_flag := -1;
1899:
1900: /* Bug 5749509 - Set the data migrator Mode */

Line 1905: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

1901: l_migrator_mode_status := hr_general.g_data_migrator_mode;
1902: hr_general.g_data_migrator_mode := 'Y';
1903:
1904: IF g_debug THEN
1905: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1906: End if;
1907: /* Gets the details of element */
1908: open c_element_dtl(p_element_type_id);
1909: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,

Line 1915: hr_utility.trace('p_element_type_id ='|| p_element_type_id);

1911: lv_element_name, lv_classification_name,ln_retro_summ_ele_id,lv_class_label; /* Bug 5731490 */
1912: close c_element_dtl;
1913:
1914: IF g_debug THEN
1915: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
1916: hr_utility.trace('lv_element_name ='|| lv_element_name);
1917: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
1918: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
1919: hr_utility.trace('lv_classification_name ='|| lv_classification_name);

Line 1916: hr_utility.trace('lv_element_name ='|| lv_element_name);

1912: close c_element_dtl;
1913:
1914: IF g_debug THEN
1915: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
1916: hr_utility.trace('lv_element_name ='|| lv_element_name);
1917: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
1918: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
1919: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
1920: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */

Line 1917: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);

1913:
1914: IF g_debug THEN
1915: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
1916: hr_utility.trace('lv_element_name ='|| lv_element_name);
1917: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
1918: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
1919: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
1920: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */
1921: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */

Line 1918: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);

1914: IF g_debug THEN
1915: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
1916: hr_utility.trace('lv_element_name ='|| lv_element_name);
1917: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
1918: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
1919: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
1920: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */
1921: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */
1922: END IF;

Line 1919: hr_utility.trace('lv_classification_name ='|| lv_classification_name);

1915: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
1916: hr_utility.trace('lv_element_name ='|| lv_element_name);
1917: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
1918: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
1919: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
1920: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */
1921: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */
1922: END IF;
1923:

Line 1920: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */

1916: hr_utility.trace('lv_element_name ='|| lv_element_name);
1917: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
1918: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
1919: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
1920: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */
1921: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */
1922: END IF;
1923:
1924: if ln_legislation_code is null and

Line 1921: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */

1917: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
1918: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
1919: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
1920: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */
1921: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */
1922: END IF;
1923:
1924: if ln_legislation_code is null and
1925: ln_ele_business_group_id is not null then

Line 1934: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);

1930: lv_legislation_code := ln_legislation_code;
1931: end if;
1932:
1933: IF g_debug THEN
1934: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);
1935: End if;
1936: /* Checks whether retro component exist for the element */
1937: OPEN c_get_retro_components;
1938: FETCH c_get_retro_components INTO ln_retro_comp_exists;

Line 1970: hr_utility.trace('ln_retro_component_id ='|| ln_retro_component_id);

1966: exit;
1967: END IF;
1968:
1969: IF g_debug THEN
1970: hr_utility.trace('ln_retro_component_id ='|| ln_retro_component_id);
1971: hr_utility.trace('ln_time_span_id ='|| ln_time_span_id);
1972: hr_utility.trace('lv_start_time_name ='|| lv_start_time_name);
1973: hr_utility.trace('lv_end_time_name ='|| lv_end_time_name);
1974: End if;

Line 1971: hr_utility.trace('ln_time_span_id ='|| ln_time_span_id);

1967: END IF;
1968:
1969: IF g_debug THEN
1970: hr_utility.trace('ln_retro_component_id ='|| ln_retro_component_id);
1971: hr_utility.trace('ln_time_span_id ='|| ln_time_span_id);
1972: hr_utility.trace('lv_start_time_name ='|| lv_start_time_name);
1973: hr_utility.trace('lv_end_time_name ='|| lv_end_time_name);
1974: End if;
1975: /* Time spans define retropayment types for greater than 12 months case*/

Line 1972: hr_utility.trace('lv_start_time_name ='|| lv_start_time_name);

1968:
1969: IF g_debug THEN
1970: hr_utility.trace('ln_retro_component_id ='|| ln_retro_component_id);
1971: hr_utility.trace('ln_time_span_id ='|| ln_time_span_id);
1972: hr_utility.trace('lv_start_time_name ='|| lv_start_time_name);
1973: hr_utility.trace('lv_end_time_name ='|| lv_end_time_name);
1974: End if;
1975: /* Time spans define retropayment types for greater than 12 months case*/
1976: IF lv_start_time_name = 'START_OF_TIME' AND lv_end_time_name = 'END_OF_12_MONTHS' THEN

Line 1973: hr_utility.trace('lv_end_time_name ='|| lv_end_time_name);

1969: IF g_debug THEN
1970: hr_utility.trace('ln_retro_component_id ='|| ln_retro_component_id);
1971: hr_utility.trace('ln_time_span_id ='|| ln_time_span_id);
1972: hr_utility.trace('lv_start_time_name ='|| lv_start_time_name);
1973: hr_utility.trace('lv_end_time_name ='|| lv_end_time_name);
1974: End if;
1975: /* Time spans define retropayment types for greater than 12 months case*/
1976: IF lv_start_time_name = 'START_OF_TIME' AND lv_end_time_name = 'END_OF_12_MONTHS' THEN
1977:

Line 2117: hr_utility.trace('Custom Element');

2113: Else
2114: if ln_legislation_code is null and ln_ele_business_group_id is not null then
2115:
2116: IF g_debug THEN
2117: hr_utility.trace('Custom Element');
2118: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
2119: End if;
2120: /*Creates the retro component usages for the element if its not exist */
2121: insert_retro_comp_usages

Line 2118: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);

2114: if ln_legislation_code is null and ln_ele_business_group_id is not null then
2115:
2116: IF g_debug THEN
2117: hr_utility.trace('Custom Element');
2118: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
2119: End if;
2120: /*Creates the retro component usages for the element if its not exist */
2121: insert_retro_comp_usages
2122: (p_business_group_id => ln_ele_business_group_id

Line 2128: hr_utility.set_location(gv_package_name || lv_procedure_name, 120);

2124: ,p_retro_component_id => ln_retro_component_id
2125: ,p_creator_id => p_element_type_id
2126: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
2127: IF g_debug THEN
2128: hr_utility.set_location(gv_package_name || lv_procedure_name, 120);
2129: End if;
2130: /*Creates the element span usages for the element */
2131: insert_element_span_usages
2132: (p_business_group_id => ln_ele_business_group_id

Line 2182: hr_utility.trace('Custom Element');

2178:
2179: IF ln_legislation_code IS NULL AND ln_ele_business_group_id IS NOT NULL THEN
2180:
2181: IF g_debug THEN
2182: hr_utility.trace('Custom Element');
2183: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
2184: END IF;
2185: /*Creates the retro component usages for the element if its not exist */
2186: insert_retro_comp_usages

Line 2183: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);

2179: IF ln_legislation_code IS NULL AND ln_ele_business_group_id IS NOT NULL THEN
2180:
2181: IF g_debug THEN
2182: hr_utility.trace('Custom Element');
2183: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
2184: END IF;
2185: /*Creates the retro component usages for the element if its not exist */
2186: insert_retro_comp_usages
2187: (p_business_group_id => ln_ele_business_group_id

Line 2193: hr_utility.set_location(gv_package_name || lv_procedure_name, 120);

2189: ,p_retro_component_id => ln_retro_component_id
2190: ,p_creator_id => p_element_type_id
2191: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
2192: IF g_debug THEN
2193: hr_utility.set_location(gv_package_name || lv_procedure_name, 120);
2194: End if;
2195: /*Creates the element span usages for the element */
2196: insert_element_span_usages
2197: (p_business_group_id => ln_ele_business_group_id

Line 2224: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

2220:
2221: END IF; /*End of Check for Earnings Standard and Pre Tax Deductions */
2222:
2223: IF g_debug THEN
2224: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
2225: End if;
2226:
2227: /* Bug 5749509 - Reset the data migrator Mode */
2228: hr_general.g_data_migrator_mode := l_migrator_mode_status;

Line 2235: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

2231: WHEN OTHERS THEN
2232: /* Bug 5749509 - Reset the data migrator Mode */
2233: hr_general.g_data_migrator_mode := l_migrator_mode_status;
2234: IF g_debug THEN
2235: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
2236: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
2237: END IF;
2238: raise;
2239: END upgrade_element;

Line 2236: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

2232: /* Bug 5749509 - Reset the data migrator Mode */
2233: hr_general.g_data_migrator_mode := l_migrator_mode_status;
2234: IF g_debug THEN
2235: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
2236: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
2237: END IF;
2238: raise;
2239: END upgrade_element;
2240:

Line 2288: g_debug := hr_utility.debug_enabled;

2284:
2285:
2286: BEGIN
2287:
2288: g_debug := hr_utility.debug_enabled;
2289:
2290: IF g_debug THEN
2291: l_procedure_name := '.set_retro_leg_rule';
2292: hr_utility.set_location('Entering Procedure '||gv_package_name||l_procedure_name,10);

Line 2292: hr_utility.set_location('Entering Procedure '||gv_package_name||l_procedure_name,10);

2288: g_debug := hr_utility.debug_enabled;
2289:
2290: IF g_debug THEN
2291: l_procedure_name := '.set_retro_leg_rule';
2292: hr_utility.set_location('Entering Procedure '||gv_package_name||l_procedure_name,10);
2293: hr_utility.set_location('IN p_calling_form '||p_calling_form,10);
2294: END IF;
2295:
2296:

Line 2293: hr_utility.set_location('IN p_calling_form '||p_calling_form,10);

2289:
2290: IF g_debug THEN
2291: l_procedure_name := '.set_retro_leg_rule';
2292: hr_utility.set_location('Entering Procedure '||gv_package_name||l_procedure_name,10);
2293: hr_utility.set_location('IN p_calling_form '||p_calling_form,10);
2294: END IF;
2295:
2296:
2297: l_return_flag := 'N'; /* Default - Rule not enabled */

Line 2405: hr_utility.trace('Error: ' || sqlerrm);

2401: RETURN l_retro_definition_id;
2402: --
2403: EXCEPTION
2404: WHEN OTHERS THEN
2405: hr_utility.trace('Error: ' || sqlerrm);
2406: rollback;
2407: hr_utility.raise_error;
2408: END create_retro_definitions;
2409: --

Line 2407: hr_utility.raise_error;

2403: EXCEPTION
2404: WHEN OTHERS THEN
2405: hr_utility.trace('Error: ' || sqlerrm);
2406: rollback;
2407: hr_utility.raise_error;
2408: END create_retro_definitions;
2409: --
2410: --------------------------------------------------------------------------
2411: -- Private Function to create retro components

Line 2484: hr_utility.trace('Error: ' || sqlerrm);

2480: RETURN l_retro_component_id;
2481: --
2482: EXCEPTION
2483: WHEN OTHERS THEN
2484: hr_utility.trace('Error: ' || sqlerrm);
2485: rollback;
2486: hr_utility.raise_error;
2487: END create_retro_components;
2488: --

Line 2486: hr_utility.raise_error;

2482: EXCEPTION
2483: WHEN OTHERS THEN
2484: hr_utility.trace('Error: ' || sqlerrm);
2485: rollback;
2486: hr_utility.raise_error;
2487: END create_retro_components;
2488: --
2489: --------------------------------------------------------------------------
2490: -- Private Function to create retro definition components

Line 2552: hr_utility.trace('Error: ' || sqlerrm);

2548: RETURN l_definition_component_id;
2549: --
2550: EXCEPTION
2551: WHEN OTHERS THEN
2552: hr_utility.trace('Error: ' || sqlerrm);
2553: rollback;
2554: hr_utility.raise_error;
2555: END create_retro_defn_components;
2556:

Line 2554: hr_utility.raise_error;

2550: EXCEPTION
2551: WHEN OTHERS THEN
2552: hr_utility.trace('Error: ' || sqlerrm);
2553: rollback;
2554: hr_utility.raise_error;
2555: END create_retro_defn_components;
2556:
2557: --
2558: --------------------------------------------------------------------------

Line 2637: hr_utility.trace('Error: ' || sqlerrm);

2633: RETURN l_time_definition_id;
2634: --
2635: EXCEPTION
2636: WHEN OTHERS THEN
2637: hr_utility.trace('Error: ' || sqlerrm);
2638: rollback;
2639: hr_utility.raise_error;
2640: END create_time_definitions;
2641:

Line 2639: hr_utility.raise_error;

2635: EXCEPTION
2636: WHEN OTHERS THEN
2637: hr_utility.trace('Error: ' || sqlerrm);
2638: rollback;
2639: hr_utility.raise_error;
2640: END create_time_definitions;
2641:
2642: --------------------------------------------------------------------------
2643: -- Private Function to create time spans

Line 2709: hr_utility.trace('Error: While inserting time spans : ' || sqlerrm);

2705: RETURN l_time_span_id;
2706: --
2707: EXCEPTION
2708: WHEN OTHERS THEN
2709: hr_utility.trace('Error: While inserting time spans : ' || sqlerrm);
2710: rollback;
2711: hr_utility.raise_error;
2712: --
2713: END create_time_spans;

Line 2711: hr_utility.raise_error;

2707: EXCEPTION
2708: WHEN OTHERS THEN
2709: hr_utility.trace('Error: While inserting time spans : ' || sqlerrm);
2710: rollback;
2711: hr_utility.raise_error;
2712: --
2713: END create_time_spans;
2714:
2715: --------------------------------------------------------------------------

Line 2747: hr_utility.trace('Fetch the required details');

2743: AND pesu.adjustment_type IS NULL;
2744: --
2745: BEGIN
2746: --
2747: hr_utility.trace('Fetch the required details');
2748: --
2749: hr_utility.trace('Checking... if it already exists');
2750: --
2751: OPEN csr_exists;

Line 2749: hr_utility.trace('Checking... if it already exists');

2745: BEGIN
2746: --
2747: hr_utility.trace('Fetch the required details');
2748: --
2749: hr_utility.trace('Checking... if it already exists');
2750: --
2751: OPEN csr_exists;
2752: FETCH csr_exists INTO l_element_span_usage_id;
2753: CLOSE csr_exists;

Line 2786: hr_utility.trace('Inserted the required element');

2782: , -1
2783: , 1
2784: FROM dual;
2785: --
2786: hr_utility.trace('Inserted the required element');
2787: END IF;
2788: --
2789: END create_element_spans;
2790:

Line 2831: hr_utility.trace('Invalid component or element type');

2827: --
2828: OPEN csr_get_details;
2829: FETCH csr_get_details INTO l_retro_component_id, l_element_type_id;
2830: IF csr_get_details%NOTFOUND THEN
2831: hr_utility.trace('Invalid component or element type');
2832: hr_utility.raise_error;
2833: END IF;
2834: CLOSE csr_get_details;
2835: --

Line 2832: hr_utility.raise_error;

2828: OPEN csr_get_details;
2829: FETCH csr_get_details INTO l_retro_component_id, l_element_type_id;
2830: IF csr_get_details%NOTFOUND THEN
2831: hr_utility.trace('Invalid component or element type');
2832: hr_utility.raise_error;
2833: END IF;
2834: CLOSE csr_get_details;
2835: --
2836: hr_utility.trace('Valid component and element type');

Line 2836: hr_utility.trace('Valid component and element type');

2832: hr_utility.raise_error;
2833: END IF;
2834: CLOSE csr_get_details;
2835: --
2836: hr_utility.trace('Valid component and element type');
2837: --
2838: OPEN csr_exists;
2839: FETCH csr_exists into l_retro_component_usage_id;
2840: CLOSE csr_exists;

Line 2844: hr_utility.trace('Before inserting data into component usages');

2840: CLOSE csr_exists;
2841: --
2842: IF l_retro_component_usage_id is null THEN
2843: --
2844: hr_utility.trace('Before inserting data into component usages');
2845: --
2846: INSERT INTO pay_retro_component_usages
2847: (RETRO_COMPONENT_USAGE_ID
2848: ,RETRO_COMPONENT_ID

Line 2880: hr_utility.trace('Inserted retro component usage: ' || l_retro_component_usage_id);

2876: SELECT pay_retro_component_usages_s.currval
2877: INTO l_retro_component_usage_id
2878: from dual;
2879: --
2880: hr_utility.trace('Inserted retro component usage: ' || l_retro_component_usage_id);
2881: --
2882: create_element_spans(l_retro_component_usage_id
2883: ,l_retro_component_id
2884: ,p_retro_element_name

Line 2889: hr_utility.trace('Inserted retro component: ' || p_retro_element_name);

2885: ,p_time_span_id);
2886: --
2887: END IF;
2888: --
2889: hr_utility.trace('Inserted retro component: ' || p_retro_element_name);
2890: --
2891: END create_comp_usages;
2892:
2893: --------------------------------------------------------------------------

Line 2924: hr_utility.trace('Error: ' || sqlerrm);

2920: RETURN l_time_definition_id;
2921: --
2922: EXCEPTION
2923: WHEN OTHERS THEN
2924: hr_utility.trace('Error: ' || sqlerrm);
2925: rollback;
2926: hr_utility.raise_error;
2927: END get_time_definitions;
2928:

Line 2926: hr_utility.raise_error;

2922: EXCEPTION
2923: WHEN OTHERS THEN
2924: hr_utility.trace('Error: ' || sqlerrm);
2925: rollback;
2926: hr_utility.raise_error;
2927: END get_time_definitions;
2928:
2929: /*
2930: Procedure : create_enhanced_retro_defn

Line 3119: g_debug := hr_utility.debug_enabled;

3115: l_proc_name varchar2(80);
3116: l_exists boolean;
3117:
3118: BEGIN
3119: g_debug := hr_utility.debug_enabled;
3120:
3121: IF g_debug
3122: THEN
3123: l_proc_name := '.set_enh_retro_request_group';

Line 3124: hr_utility.trace('Entering '||gv_package_name||l_proc_name);

3120:
3121: IF g_debug
3122: THEN
3123: l_proc_name := '.set_enh_retro_request_group';
3124: hr_utility.trace('Entering '||gv_package_name||l_proc_name);
3125: END IF;
3126:
3127: l_req_grp_name := 'AU HRMS Reports and Processes';
3128: l_grp_app_name := 'PER';

Line 3158: hr_utility.trace('Program Added to Request Group '||l_add_prog_name(i));

3154: group_application => l_grp_app_name);
3155:
3156: IF g_debug
3157: THEN
3158: hr_utility.trace('Program Added to Request Group '||l_add_prog_name(i));
3159: END IF;
3160: END IF;
3161: END LOOP;
3162:

Line 3189: hr_utility.trace('Program Removed from Request Group '||l_del_prog_name(i));

3185: group_application => l_grp_app_name);
3186:
3187: IF g_debug
3188: THEN
3189: hr_utility.trace('Program Removed from Request Group '||l_del_prog_name(i));
3190: END IF;
3191: END IF;
3192: END LOOP;
3193:

Line 3197: hr_utility.trace('Leaving '||gv_package_name||l_proc_name);

3193:
3194: IF g_debug
3195: THEN
3196: l_proc_name := '.set_enh_retro_request_group';
3197: hr_utility.trace('Leaving '||gv_package_name||l_proc_name);
3198: END IF;
3199: END set_enh_retro_request_group;
3200:
3201: /*

Line 3234: g_debug := hr_utility.debug_enabled;

3230: l_bg_leg_code VARCHAR2(10);
3231:
3232: BEGIN
3233:
3234: g_debug := hr_utility.debug_enabled;
3235: g_legislation_code := 'AU';
3236:
3237: IF g_debug THEN
3238: l_procedure_name := '.enable_au_enhanced_retro';

Line 3239: hr_utility.trace('Entering '||gv_package_name||l_procedure_name);

3235: g_legislation_code := 'AU';
3236:
3237: IF g_debug THEN
3238: l_procedure_name := '.enable_au_enhanced_retro';
3239: hr_utility.trace('Entering '||gv_package_name||l_procedure_name);
3240: END IF;
3241:
3242: l_leg_rule := pay_au_retro_upgrade.set_retro_leg_rule(p_calling_form => 'UPGRADE');
3243: