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.

[Home] [Help]

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 173: g_debug := hr_utility.debug_enabled;

169: l_element_name_warning BOOLEAN;
170: l_element_name_change_warning BOOLEAN;
171:
172: BEGIN
173: g_debug := hr_utility.debug_enabled;
174: lv_procedure_name := 'insert_event_group';
175:
176: IF g_debug THEN
177: hr_utility.trace('Entering ' || lv_procedure_name);

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

173: g_debug := hr_utility.debug_enabled;
174: lv_procedure_name := 'insert_event_group';
175:
176: IF g_debug THEN
177: hr_utility.trace('Entering ' || lv_procedure_name);
178: END if;
179:
180:
181: open c_get_retro_element_info;

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

249: ,p_element_name_change_warning => l_element_name_change_warning
250: );
251:
252: IF g_debug THEN
253: hr_utility.trace('Updated Event Group for Element: ' || p_element_type_id);
254: END if;
255:
256: END IF;
257:

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

259:
260: close c_get_retro_element_info;
261:
262: IF g_debug THEN
263: hr_utility.trace('Leaving ' || lv_procedure_name);
264: END if;
265:
266: exception
267: when others then

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

265:
266: exception
267: when others then
268: IF g_debug THEN
269: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
270: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
271: End if;
272:
273: raise;

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

266: exception
267: when others then
268: IF g_debug THEN
269: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
270: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
271: End if;
272:
273: raise;
274:

Line 310: g_debug := hr_utility.debug_enabled;

306: l_ele_entry_value_table_id NUMBER;
307:
308:
309: BEGIN
310: g_debug := hr_utility.debug_enabled;
311: l_effective_date := to_date('1900/01/01','YYYY/MM/DD');
312:
313: lv_procedure_name := 'create_event_group';
314:

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

312:
313: lv_procedure_name := 'create_event_group';
314:
315: IF g_debug THEN
316: hr_utility.trace('Entering ' || lv_procedure_name);
317: END if;
318:
319:
320: OPEN c_get_event_group_id;

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

409:
410: p_event_group_id := l_event_group_id;
411:
412: IF g_debug THEN
413: hr_utility.trace('p_event_group_id: ' || p_event_group_id);
414: hr_utility.trace('Leaving ' || lv_procedure_name);
415: End If;
416:
417: exception

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

410: p_event_group_id := l_event_group_id;
411:
412: IF g_debug THEN
413: hr_utility.trace('p_event_group_id: ' || p_event_group_id);
414: hr_utility.trace('Leaving ' || lv_procedure_name);
415: End If;
416:
417: exception
418: when others then

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

416:
417: exception
418: when others then
419: IF g_debug THEN
420: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
421: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
422: End If;
423:
424: raise;

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

417: exception
418: when others then
419: IF g_debug THEN
420: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
421: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
422: End If;
423:
424: raise;
425: END;

Line 508: g_debug := hr_utility.debug_enabled;

504: l_element_type_id NUMBER;
505: lv_procedure_name VARCHAR2(50);
506:
507: BEGIN
508: g_debug := hr_utility.debug_enabled;
509: lv_procedure_name := 'create_ff_results';
510:
511: IF g_debug THEN
512: hr_utility.trace('Entering ' || lv_procedure_name);

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

508: g_debug := hr_utility.debug_enabled;
509: lv_procedure_name := 'create_ff_results';
510:
511: IF g_debug THEN
512: hr_utility.trace('Entering ' || lv_procedure_name);
513: End if;
514:
515:
516: l_legislation_code := 'AU';

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

527: l_result_name2 := 'ADDITIONAL_DEDUCTION'; -- bug13362286
528: l_result_rule_type := 'I';
529:
530: IF g_debug THEN
531: hr_utility.trace('p_business_group_id: ' || p_business_group_id);
532: hr_utility.trace('p_retro_type: ' || p_retro_type);
533: hr_utility.trace('p_element_type_id: ' || p_element_type_id);
534: End if;
535:

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

528: l_result_rule_type := 'I';
529:
530: IF g_debug THEN
531: hr_utility.trace('p_business_group_id: ' || p_business_group_id);
532: hr_utility.trace('p_retro_type: ' || p_retro_type);
533: hr_utility.trace('p_element_type_id: ' || p_element_type_id);
534: End if;
535:
536: /* Gets the processing rule id for element */

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

529:
530: IF g_debug THEN
531: hr_utility.trace('p_business_group_id: ' || p_business_group_id);
532: hr_utility.trace('p_retro_type: ' || p_retro_type);
533: hr_utility.trace('p_element_type_id: ' || p_element_type_id);
534: End if;
535:
536: /* Gets the processing rule id for element */
537: OPEN c_get_formula_results(p_element_type_id);

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

549: CLOSE c_get_formula_id;
550: END IF;
551:
552: IF g_debug THEN
553: hr_utility.trace('l_formula_id: ' || l_formula_id);
554: End if;
555:
556: IF nvl(l_status_processing_rule_id,9999) = 9999 THEN
557:

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

716: END IF;
717: END IF;
718:
719: IF g_debug THEN
720: hr_utility.trace('Leaving ' || lv_procedure_name);
721: End if;
722:
723: exception
724: when others then

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

722:
723: exception
724: when others then
725: IF g_debug THEN
726: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
727: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
728: End if;
729: raise;
730: END;

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

723: exception
724: when others then
725: IF g_debug THEN
726: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
727: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
728: End if;
729: raise;
730: END;
731:

Line 792: g_debug := hr_utility.debug_enabled;

788: l_effective_date DATE;
789: lv_procedure_name VARCHAR2(50);
790:
791: BEGIN
792: g_debug := hr_utility.debug_enabled;
793:
794: lv_procedure_name := 'create_balance_feeds';
795:
796: IF g_debug THEN

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

793:
794: lv_procedure_name := 'create_balance_feeds';
795:
796: IF g_debug THEN
797: hr_utility.trace('Entering ' || lv_procedure_name);
798: End if;
799:
800: IF p_bal_type IN (1,3) THEN /*bug 7665727, 8765082 to set effective_date for Retro Earnings Spread, Leave Loading */
801: l_effective_date := to_date('2009/07/01','YYYY/MM/DD');

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

816: FETCH c_get_input_value_id INTO l_input_value_id;
817: CLOSE c_get_input_value_id;
818:
819: IF g_debug THEN
820: hr_utility.trace('Creating Balance Feed for input value ' || csr_rec_iv.name);
821: hr_utility.trace('Input Value ID: ' || l_input_value_id);
822: End if;
823:
824: IF UPPER(csr_rec_iv.NAME) = UPPER('Pay Value') THEN

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

817: CLOSE c_get_input_value_id;
818:
819: IF g_debug THEN
820: hr_utility.trace('Creating Balance Feed for input value ' || csr_rec_iv.name);
821: hr_utility.trace('Input Value ID: ' || l_input_value_id);
822: End if;
823:
824: IF UPPER(csr_rec_iv.NAME) = UPPER('Pay Value') THEN
825: /* Checks whether seeded balance feed exist for element created by upgrade process */

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

829: /* Checks whether balance feed does not exist and element classification is not of type Pre Tax Deductions */
830: IF l_exists = 0 AND p_scale <> 0 THEN
831:
832: IF g_debug THEN
833: hr_utility.trace('Create Seeded Balance Feed');
834: End if;
835: /* Creates balance feeds for the elements created by upgrade process */
836: hr_balances.ins_balance_feed(
837: p_option => 'INS_MANUAL_FEED',

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

846: p_business_group => p_business_group_id,
847: p_legislation_code => NULL,
848: p_mode => 'USER');
849: IF g_debug THEN
850: hr_utility.trace('Created Seeded Balance Feed');
851: End if;
852: END IF;
853: END IF;
854: /* Checks whether user balance feed exist for element created by upgrade process */

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

858:
859: IF l_exists = 0 THEN
860:
861: IF g_debug THEN
862: hr_utility.trace('Create User Balance Feed FOR balance TYPE id: ' || csr_rec_bf.balance_type_id);
863: End if;
864:
865: hr_balances.ins_balance_feed(
866: p_option => 'INS_MANUAL_FEED',

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

875: p_business_group => p_business_group_id,
876: p_legislation_code => NULL,
877: p_mode => 'USER');
878: IF g_debug THEN
879: hr_utility.trace('Created User Balance Feed');
880: End if;
881:
882: END IF;
883:

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

885:
886: END LOOP;
887:
888: IF g_debug THEN
889: hr_utility.trace('Leaving ' || lv_procedure_name);
890: End if;
891: exception
892: when others then
893: IF g_debug THEN

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

890: End if;
891: exception
892: when others then
893: IF g_debug THEN
894: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
895: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
896: End if;
897: raise;
898: END;

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

891: exception
892: when others then
893: IF g_debug THEN
894: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
895: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
896: End if;
897: raise;
898: END;
899:

Line 972: g_debug := hr_utility.debug_enabled;

968: lv_ovn_invl number;
969:
970: rec_input_values_user c_input_exists%ROWTYPE;
971: begin
972: g_debug := hr_utility.debug_enabled;
973: lv_procedure_name := 'create_input_value';
974:
975: IF g_debug THEN
976: hr_utility.trace('Entering ' || lv_procedure_name);

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

972: g_debug := hr_utility.debug_enabled;
973: lv_procedure_name := 'create_input_value';
974:
975: IF g_debug THEN
976: hr_utility.trace('Entering ' || lv_procedure_name);
977: End if;
978:
979: l_effective_date := to_date('2005/07/01','YYYY/MM/DD');
980:

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

978:
979: l_effective_date := to_date('2005/07/01','YYYY/MM/DD');
980:
981: IF g_debug THEN
982: hr_utility.trace(p_business_group_id || ' p_business_group_id');
983: hr_utility.trace(p_retro_element_id || ' p_retro_element_id');
984: hr_utility.trace(p_element_type_id || ' p_element_type_id');
985: hr_utility.trace(p_retro_type || ' p_retro_type');
986: End if;

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

979: l_effective_date := to_date('2005/07/01','YYYY/MM/DD');
980:
981: IF g_debug THEN
982: hr_utility.trace(p_business_group_id || ' p_business_group_id');
983: hr_utility.trace(p_retro_element_id || ' p_retro_element_id');
984: hr_utility.trace(p_element_type_id || ' p_element_type_id');
985: hr_utility.trace(p_retro_type || ' p_retro_type');
986: End if;
987:

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

980:
981: IF g_debug THEN
982: hr_utility.trace(p_business_group_id || ' p_business_group_id');
983: hr_utility.trace(p_retro_element_id || ' p_retro_element_id');
984: hr_utility.trace(p_element_type_id || ' p_element_type_id');
985: hr_utility.trace(p_retro_type || ' p_retro_type');
986: End if;
987:
988: /* Fetches the details of input value of retro element */

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

981: IF g_debug THEN
982: hr_utility.trace(p_business_group_id || ' p_business_group_id');
983: hr_utility.trace(p_retro_element_id || ' p_retro_element_id');
984: hr_utility.trace(p_element_type_id || ' p_element_type_id');
985: hr_utility.trace(p_retro_type || ' p_retro_type');
986: End if;
987:
988: /* Fetches the details of input value of retro element */
989: open c_get_input_value_info;

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

1023: end if;
1024:
1025: if c_input_exists%notfound then
1026: IF g_debug THEN
1027: hr_utility.trace(rec_input_values.NAME || ' does not exists');
1028: End if;
1029: /* Created input value similar to retro element for the element created by Upgrade process */
1030: PAY_INPUT_VALUE_API.CREATE_INPUT_VALUE
1031: ( P_EFFECTIVE_DATE => l_effective_date

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

1055: ,P_FORMULA_MESSAGE => l_message
1056: );
1057:
1058: IF g_debug THEN
1059: hr_utility.trace(rec_input_values.NAME || ' Created');
1060: End if;
1061:
1062: end if;
1063: close c_input_exists;

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

1066:
1067: close c_get_input_value_info;
1068:
1069: IF g_debug THEN
1070: hr_utility.trace('Leaving ' || lv_procedure_name);
1071: End if;
1072: exception
1073: when others then
1074: IF g_debug THEN

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

1071: End if;
1072: exception
1073: when others then
1074: IF g_debug THEN
1075: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1076: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1077: End if;
1078: raise;
1079: end;

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

1072: exception
1073: when others then
1074: IF g_debug THEN
1075: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1076: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1077: End if;
1078: raise;
1079: end;
1080:

Line 1239: g_debug := hr_utility.debug_enabled;

1235: dummy_rowid varchar2(18) default null;
1236: dummy_id number(38) default null;
1237:
1238: begin
1239: g_debug := hr_utility.debug_enabled;
1240: l_upgraded_element :='N'; /* Flag to check whether element was created by Upgrade process */
1241: l_effective_date := to_date('2005/07/01','YYYY/MM/DD');
1242:
1243: lv_procedure_name := 'create_element';

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

1242:
1243: lv_procedure_name := 'create_element';
1244:
1245: IF g_debug THEN
1246: hr_utility.trace('Entering ' || lv_procedure_name);
1247: End if;
1248:
1249: /* Gets the details of Retro Element */
1250: open c_get_retro_element_info;

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

1251: fetch c_get_retro_element_info into rec_element_types;
1252: close c_get_retro_element_info;
1253:
1254: IF g_debug THEN
1255: hr_utility.trace('Retro Element Name: ' || rec_element_types.element_name);
1256: End if;
1257: /* Checks whether element already exist before creating the element + */
1258: OPEN c_element_exists;
1259: FETCH c_element_exists INTO l_element_type_id;

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

1259: FETCH c_element_exists INTO l_element_type_id;
1260: IF c_element_exists%NOTFOUND THEN
1261:
1262: IF g_debug THEN
1263: hr_utility.trace('Creating New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );
1264: End if;
1265: /* Creates element + */
1266: /* Bug 5749509 - ONCE_EACH_PERIOD_FLAG - Specify default of 'N' if existing value is Null
1267: - TIME_DEFINITION_TYPE,TIME_DEFINITION_TYPE added in API call

Line 1331: hr_utility.trace('sub classification change to : ' || p_class_label ||' for '|| rec_element_types.ELEMENT_NAME || ' ' || p_retro_type ||'('||p_element_type_id||')' );

1327: /*Bug 8765082 - Added Sub classification for Leave Loading */
1328: IF p_class_label = 'Spread' OR p_class_label = 'Leave Loading' OR p_class_label = 'Additional' THEN -- bug13362286
1329:
1330: IF g_debug THEN
1331: hr_utility.trace('sub classification change to : ' || p_class_label ||' for '|| rec_element_types.ELEMENT_NAME || ' ' || p_retro_type ||'('||p_element_type_id||')' );
1332: End if;
1333:
1334: select rowid, sub_classification_rule_id
1335: into l_rowid, l_sub_classification_rule_id

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

1372: ,p_element_type_extra_info_id => l_eei_info_id
1373: ,p_object_version_number => l_ovn_eei);
1374:
1375: IF g_debug THEN
1376: hr_utility.trace('Created New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );
1377: End if;
1378: /* Gets the details of element link of retro element, if link exist
1379: create the similar element link for newly created element */
1380:

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

1385: IF c_get_element_links%NOTFOUND THEN
1386: exit;
1387: ELSE
1388: IF g_debug THEN
1389: hr_utility.trace('Creating Element links for New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );
1390: End if;
1391:
1392: /* 8416815 - Added two more input parameters p_cost_allocation_keyflex_id and p_balancing_keyflex_id
1393: to the below call*/

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

1422: ,p_effective_start_date => l_effective_start_date
1423: ,p_effective_end_date => l_effective_end_date
1424: );
1425: IF g_debug THEN
1426: hr_utility.trace('Created Element links for New Retro Element: ' || rec_element_types.element_name || ' ' || p_retro_type );
1427: End if;
1428: /* 5731490 End dates link*/
1429: if to_char(rec_element_links.effective_end_date,'YYYY/MM/DD') <> '4712/12/31' then
1430: pay_element_link_api.delete_element_link

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

1449:
1450: CLOSE c_element_exists;
1451:
1452: IF g_debug THEN
1453: hr_utility.trace('Leaving ' || lv_procedure_name);
1454: End if;
1455: exception
1456: when others then
1457: IF g_debug THEN

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

1454: End if;
1455: exception
1456: when others then
1457: IF g_debug THEN
1458: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1459: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1460: End if;
1461: raise;
1462: end;

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

1455: exception
1456: when others then
1457: IF g_debug THEN
1458: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1459: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1460: End if;
1461: raise;
1462: end;
1463: /*

Line 1494: g_debug := hr_utility.debug_enabled;

1490: AND retro_component_id = p_retro_component_id;
1491:
1492:
1493: BEGIN
1494: g_debug := hr_utility.debug_enabled;
1495: lv_procedure_name := '.insert_retro_comp_usages';
1496:
1497: IF g_debug THEN
1498: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

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

1494: g_debug := hr_utility.debug_enabled;
1495: lv_procedure_name := '.insert_retro_comp_usages';
1496:
1497: IF g_debug THEN
1498: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1499: End if;
1500: /* Checks whether retro compnoned already exist */
1501: OPEN c_retro_comp_exists;
1502: FETCH c_retro_comp_exists INTO ln_retro_component_usage_id;

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

1518:
1519: p_retro_comp_usage_id := ln_retro_component_usage_id;
1520:
1521: IF g_debug THEN
1522: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);
1523: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
1524: End if;
1525: ELSE
1526: p_retro_comp_usage_id := ln_retro_component_usage_id;

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

1519: p_retro_comp_usage_id := ln_retro_component_usage_id;
1520:
1521: IF g_debug THEN
1522: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);
1523: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
1524: End if;
1525: ELSE
1526: p_retro_comp_usage_id := ln_retro_component_usage_id;
1527: END IF;

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

1528:
1529: exception
1530: when others then
1531: IF g_debug THEN
1532: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1533: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1534: End if;
1535:
1536: raise;

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

1529: exception
1530: when others then
1531: IF g_debug THEN
1532: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1533: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1534: End if;
1535:
1536: raise;
1537: END insert_retro_comp_usages;

Line 1559: g_debug := hr_utility.debug_enabled;

1555:
1556: lv_procedure_name VARCHAR2(100);
1557:
1558: BEGIN
1559: g_debug := hr_utility.debug_enabled;
1560: lv_procedure_name := '.insert_element_span_usages';
1561:
1562: IF g_debug THEN
1563: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

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

1559: g_debug := hr_utility.debug_enabled;
1560: lv_procedure_name := '.insert_element_span_usages';
1561:
1562: IF g_debug THEN
1563: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1564: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
1565: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
1566: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1567: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);

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

1560: lv_procedure_name := '.insert_element_span_usages';
1561:
1562: IF g_debug THEN
1563: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1564: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
1565: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
1566: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1567: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
1568: End if;

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

1561:
1562: IF g_debug THEN
1563: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1564: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
1565: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
1566: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1567: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
1568: End if;
1569:

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

1562: IF g_debug THEN
1563: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1564: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
1565: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
1566: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1567: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
1568: End if;
1569:
1570: insert into pay_element_span_usages

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

1563: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1564: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
1565: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
1566: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1567: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
1568: End if;
1569:
1570: insert into pay_element_span_usages
1571: (element_span_usage_id, business_group_id, time_span_id,

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

1577: p_retro_comp_usage_id, p_retro_element_type_id,
1578: sysdate, 2, sysdate, 2, 2, 1);
1579:
1580: IF g_debug THEN
1581: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
1582: End if;
1583:
1584: exception
1585: when others then

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

1583:
1584: exception
1585: when others then
1586: IF g_debug THEN
1587: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1588: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1589: End if;
1590: raise;
1591: END insert_element_span_usages;

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

1584: exception
1585: when others then
1586: IF g_debug THEN
1587: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1588: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1589: End if;
1590: raise;
1591: END insert_element_span_usages;
1592:

Line 1630: g_debug := hr_utility.debug_enabled;

1626: l_user_element_exist char(1);
1627: l_upgrade_element_exist char(1);
1628: lv_procedure_name varchar2(30);
1629: Begin
1630: g_debug := hr_utility.debug_enabled;
1631:
1632: lv_procedure_name := '.element_exist_check';
1633: l_upgraded_element:='N';
1634: l_user_element_exist :='N';

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

1663:
1664: exception
1665: when others then
1666: IF g_debug THEN
1667: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1668: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1669: End if;
1670: raise;
1671: end element_exist_check;

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

1664: exception
1665: when others then
1666: IF g_debug THEN
1667: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1668: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1669: End if;
1670: raise;
1671: end element_exist_check;
1672:

Line 1815: g_debug := hr_utility.debug_enabled;

1811: ln_retro_summ_ele_id NUMBER; /* Bug 5731490 */
1812: ln_element_set_exist boolean; /* Bug 5731490 */
1813:
1814: BEGIN
1815: g_debug := hr_utility.debug_enabled;
1816:
1817: lv_procedure_name := '.qualify_element';
1818:
1819: IF g_debug THEN

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

1816:
1817: lv_procedure_name := '.qualify_element';
1818:
1819: IF g_debug THEN
1820: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
1821: End if;
1822:
1823: lv_qualified := 'N';
1824: lv_legislation_code := null;

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

1839: close c_element_class;
1840:
1841: IF ln_classification_id IS NOT NULL THEN
1842: IF g_debug THEN
1843: hr_utility.trace('ln_classification_id: ' || ln_classification_id);
1844: hr_utility.trace('lv_element_name: ' || lv_element_name);
1845: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1846: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1847: hr_utility.trace('lv_label: ' || lv_label);

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

1840:
1841: IF ln_classification_id IS NOT NULL THEN
1842: IF g_debug THEN
1843: hr_utility.trace('ln_classification_id: ' || ln_classification_id);
1844: hr_utility.trace('lv_element_name: ' || lv_element_name);
1845: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1846: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1847: hr_utility.trace('lv_label: ' || lv_label);
1848: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);

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

1841: IF ln_classification_id IS NOT NULL THEN
1842: IF g_debug THEN
1843: hr_utility.trace('ln_classification_id: ' || ln_classification_id);
1844: hr_utility.trace('lv_element_name: ' || lv_element_name);
1845: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1846: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1847: hr_utility.trace('lv_label: ' || lv_label);
1848: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);
1849: End if;

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

1842: IF g_debug THEN
1843: hr_utility.trace('ln_classification_id: ' || ln_classification_id);
1844: hr_utility.trace('lv_element_name: ' || lv_element_name);
1845: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1846: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1847: hr_utility.trace('lv_label: ' || lv_label);
1848: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);
1849: End if;
1850:

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

1843: hr_utility.trace('ln_classification_id: ' || ln_classification_id);
1844: hr_utility.trace('lv_element_name: ' || lv_element_name);
1845: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1846: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1847: hr_utility.trace('lv_label: ' || lv_label);
1848: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);
1849: End if;
1850:
1851: if lv_legislation_code is null and

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

1844: hr_utility.trace('lv_element_name: ' || lv_element_name);
1845: hr_utility.trace('ln_business_group_id: ' || ln_business_group_id);
1846: hr_utility.trace('lv_classification_name: ' || lv_classification_name);
1847: hr_utility.trace('lv_label: ' || lv_label);
1848: hr_utility.trace('lv_retro_summ_ele_id: '||ln_retro_summ_ele_id);
1849: End if;
1850:
1851: if lv_legislation_code is null and
1852: ln_business_group_id is not null then

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

1880: exit;
1881: end if;
1882: ln_element_set_exist := TRUE; /* 5731490 */
1883: IF g_debug THEN
1884: hr_utility.trace('Element Set ID ' || ln_element_set_id);
1885: End if;
1886: /* Chechk whether Element set is used for retropayment */
1887: /* Bug 5731490 - Check Added for summary element */
1888: open c_element_check(ln_element_set_id);

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

1895:
1896: lv_qualified := 'Y';
1897:
1898: IF g_debug THEN
1899: hr_utility.trace('UPGRADE Element ' || lv_element_name ||
1900: '(' || p_object_id || ')');
1901: End if;
1902: exit;
1903: else

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

1902: exit;
1903: else
1904: lv_qualified := 'N';
1905: IF g_debug THEN
1906: hr_utility.trace('Element ' || lv_element_name ||
1907: '(' || p_object_id || ') does not need to be upgraded');
1908: End if;
1909:
1910: end if;

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

1927: 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.');
1928: end if;
1929:
1930: IF g_debug THEN
1931: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
1932: End if;
1933:
1934: exception
1935: when others then

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

1933:
1934: exception
1935: when others then
1936: IF g_debug THEN
1937: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1938: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1939: End if;
1940:
1941: raise;

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

1934: exception
1935: when others then
1936: IF g_debug THEN
1937: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
1938: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
1939: End if;
1940:
1941: raise;
1942: END qualify_element;

Line 2100: g_debug := hr_utility.debug_enabled;

2096:
2097: l_bal_type NUMBER; --bug 7665727 to check if retro Earnings Spread balance is
2098:
2099: BEGIN
2100: g_debug := hr_utility.debug_enabled;
2101: lv_procedure_name := '.upgrade_element';
2102: l_warning_flag := -1;
2103:
2104: /* Bug 5749509 - Set the data migrator Mode */

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

2105: l_migrator_mode_status := hr_general.g_data_migrator_mode;
2106: hr_general.g_data_migrator_mode := 'Y';
2107:
2108: IF g_debug THEN
2109: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
2110: End if;
2111: /* Gets the details of element */
2112: open c_element_dtl(p_element_type_id);
2113: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,

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

2115: lv_element_name, lv_classification_name,ln_retro_summ_ele_id,lv_class_label; /* Bug 5731490 */
2116: close c_element_dtl;
2117:
2118: IF g_debug THEN
2119: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
2120: hr_utility.trace('lv_element_name ='|| lv_element_name);
2121: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
2122: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
2123: hr_utility.trace('lv_classification_name ='|| lv_classification_name);

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

2116: close c_element_dtl;
2117:
2118: IF g_debug THEN
2119: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
2120: hr_utility.trace('lv_element_name ='|| lv_element_name);
2121: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
2122: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
2123: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
2124: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */

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

2117:
2118: IF g_debug THEN
2119: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
2120: hr_utility.trace('lv_element_name ='|| lv_element_name);
2121: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
2122: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
2123: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
2124: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */
2125: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */

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

2118: IF g_debug THEN
2119: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
2120: hr_utility.trace('lv_element_name ='|| lv_element_name);
2121: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
2122: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
2123: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
2124: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */
2125: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */
2126: END IF;

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

2119: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
2120: hr_utility.trace('lv_element_name ='|| lv_element_name);
2121: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
2122: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
2123: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
2124: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */
2125: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */
2126: END IF;
2127:

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

2120: hr_utility.trace('lv_element_name ='|| lv_element_name);
2121: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
2122: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
2123: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
2124: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */
2125: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */
2126: END IF;
2127:
2128: if ln_legislation_code is null and

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

2121: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
2122: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
2123: hr_utility.trace('lv_classification_name ='|| lv_classification_name);
2124: hr_utility.trace('l_retro_summ_ele_id ='|| ln_retro_summ_ele_id); /* Bug 5731490 */
2125: hr_utility.trace('lv_class_label ='|| lv_class_label); /* Bug 5731490 */
2126: END IF;
2127:
2128: if ln_legislation_code is null and
2129: ln_ele_business_group_id is not null then

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

2134: lv_legislation_code := ln_legislation_code;
2135: end if;
2136:
2137: IF g_debug THEN
2138: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);
2139: End if;
2140: /* Checks whether retro component exist for the element */
2141: OPEN c_get_retro_components;
2142: FETCH c_get_retro_components INTO ln_retro_comp_exists;

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

2170: exit;
2171: END IF;
2172:
2173: IF g_debug THEN
2174: hr_utility.trace('ln_retro_component_id ='|| ln_retro_component_id);
2175: hr_utility.trace('ln_time_span_id ='|| ln_time_span_id);
2176: hr_utility.trace('lv_start_time_name ='|| lv_start_time_name);
2177: hr_utility.trace('lv_end_time_name ='|| lv_end_time_name);
2178: End if;

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

2171: END IF;
2172:
2173: IF g_debug THEN
2174: hr_utility.trace('ln_retro_component_id ='|| ln_retro_component_id);
2175: hr_utility.trace('ln_time_span_id ='|| ln_time_span_id);
2176: hr_utility.trace('lv_start_time_name ='|| lv_start_time_name);
2177: hr_utility.trace('lv_end_time_name ='|| lv_end_time_name);
2178: End if;
2179: /* Time spans define retropayment types for greater than 12 months case*/

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

2172:
2173: IF g_debug THEN
2174: hr_utility.trace('ln_retro_component_id ='|| ln_retro_component_id);
2175: hr_utility.trace('ln_time_span_id ='|| ln_time_span_id);
2176: hr_utility.trace('lv_start_time_name ='|| lv_start_time_name);
2177: hr_utility.trace('lv_end_time_name ='|| lv_end_time_name);
2178: End if;
2179: /* Time spans define retropayment types for greater than 12 months case*/
2180: IF lv_start_time_name = 'START_OF_TIME' AND lv_end_time_name = 'END_OF_12_MONTHS' THEN

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

2173: IF g_debug THEN
2174: hr_utility.trace('ln_retro_component_id ='|| ln_retro_component_id);
2175: hr_utility.trace('ln_time_span_id ='|| ln_time_span_id);
2176: hr_utility.trace('lv_start_time_name ='|| lv_start_time_name);
2177: hr_utility.trace('lv_end_time_name ='|| lv_end_time_name);
2178: End if;
2179: /* Time spans define retropayment types for greater than 12 months case*/
2180: IF lv_start_time_name = 'START_OF_TIME' AND lv_end_time_name = 'END_OF_12_MONTHS' THEN
2181:

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

2382: Else
2383: if ln_legislation_code is null and ln_ele_business_group_id is not null then
2384:
2385: IF g_debug THEN
2386: hr_utility.trace('Custom Element');
2387: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
2388: End if;
2389: /*Creates the retro component usages for the element if its not exist */
2390: insert_retro_comp_usages

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

2383: if ln_legislation_code is null and ln_ele_business_group_id is not null then
2384:
2385: IF g_debug THEN
2386: hr_utility.trace('Custom Element');
2387: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
2388: End if;
2389: /*Creates the retro component usages for the element if its not exist */
2390: insert_retro_comp_usages
2391: (p_business_group_id => ln_ele_business_group_id

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

2393: ,p_retro_component_id => ln_retro_component_id
2394: ,p_creator_id => p_element_type_id
2395: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
2396: IF g_debug THEN
2397: hr_utility.set_location(gv_package_name || lv_procedure_name, 120);
2398: End if;
2399: /*Creates the element span usages for the element */
2400: insert_element_span_usages
2401: (p_business_group_id => ln_ele_business_group_id

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

2447:
2448: IF ln_legislation_code IS NULL AND ln_ele_business_group_id IS NOT NULL THEN
2449:
2450: IF g_debug THEN
2451: hr_utility.trace('Custom Element');
2452: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
2453: END IF;
2454: /*Creates the retro component usages for the element if its not exist */
2455: insert_retro_comp_usages

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

2448: IF ln_legislation_code IS NULL AND ln_ele_business_group_id IS NOT NULL THEN
2449:
2450: IF g_debug THEN
2451: hr_utility.trace('Custom Element');
2452: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
2453: END IF;
2454: /*Creates the retro component usages for the element if its not exist */
2455: insert_retro_comp_usages
2456: (p_business_group_id => ln_ele_business_group_id

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

2458: ,p_retro_component_id => ln_retro_component_id
2459: ,p_creator_id => p_element_type_id
2460: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
2461: IF g_debug THEN
2462: hr_utility.set_location(gv_package_name || lv_procedure_name, 120);
2463: End if;
2464: /*Creates the element span usages for the element */
2465: insert_element_span_usages
2466: (p_business_group_id => ln_ele_business_group_id

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

2489:
2490: END IF; /*End of Check for Earnings Standard and Pre Tax Deductions */
2491:
2492: IF g_debug THEN
2493: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
2494: End if;
2495:
2496: /* Bug 5749509 - Reset the data migrator Mode */
2497: hr_general.g_data_migrator_mode := l_migrator_mode_status;

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

2500: WHEN OTHERS THEN
2501: /* Bug 5749509 - Reset the data migrator Mode */
2502: hr_general.g_data_migrator_mode := l_migrator_mode_status;
2503: IF g_debug THEN
2504: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
2505: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
2506: END IF;
2507: raise;
2508: END upgrade_element;

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

2501: /* Bug 5749509 - Reset the data migrator Mode */
2502: hr_general.g_data_migrator_mode := l_migrator_mode_status;
2503: IF g_debug THEN
2504: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
2505: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
2506: END IF;
2507: raise;
2508: END upgrade_element;
2509:

Line 2557: g_debug := hr_utility.debug_enabled;

2553:
2554:
2555: BEGIN
2556:
2557: g_debug := hr_utility.debug_enabled;
2558:
2559: IF g_debug THEN
2560: l_procedure_name := '.set_retro_leg_rule';
2561: hr_utility.set_location('Entering Procedure '||gv_package_name||l_procedure_name,10);

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

2557: g_debug := hr_utility.debug_enabled;
2558:
2559: IF g_debug THEN
2560: l_procedure_name := '.set_retro_leg_rule';
2561: hr_utility.set_location('Entering Procedure '||gv_package_name||l_procedure_name,10);
2562: hr_utility.set_location('IN p_calling_form '||p_calling_form,10);
2563: END IF;
2564:
2565:

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

2558:
2559: IF g_debug THEN
2560: l_procedure_name := '.set_retro_leg_rule';
2561: hr_utility.set_location('Entering Procedure '||gv_package_name||l_procedure_name,10);
2562: hr_utility.set_location('IN p_calling_form '||p_calling_form,10);
2563: END IF;
2564:
2565:
2566: l_return_flag := 'N'; /* Default - Rule not enabled */

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

2670: RETURN l_retro_definition_id;
2671: --
2672: EXCEPTION
2673: WHEN OTHERS THEN
2674: hr_utility.trace('Error: ' || sqlerrm);
2675: rollback;
2676: hr_utility.raise_error;
2677: END create_retro_definitions;
2678: --

Line 2676: hr_utility.raise_error;

2672: EXCEPTION
2673: WHEN OTHERS THEN
2674: hr_utility.trace('Error: ' || sqlerrm);
2675: rollback;
2676: hr_utility.raise_error;
2677: END create_retro_definitions;
2678: --
2679: --------------------------------------------------------------------------
2680: -- Private Function to create retro components

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

2749: RETURN l_retro_component_id;
2750: --
2751: EXCEPTION
2752: WHEN OTHERS THEN
2753: hr_utility.trace('Error: ' || sqlerrm);
2754: rollback;
2755: hr_utility.raise_error;
2756: END create_retro_components;
2757: --

Line 2755: hr_utility.raise_error;

2751: EXCEPTION
2752: WHEN OTHERS THEN
2753: hr_utility.trace('Error: ' || sqlerrm);
2754: rollback;
2755: hr_utility.raise_error;
2756: END create_retro_components;
2757: --
2758: --------------------------------------------------------------------------
2759: -- Private Function to create retro definition components

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

2817: RETURN l_definition_component_id;
2818: --
2819: EXCEPTION
2820: WHEN OTHERS THEN
2821: hr_utility.trace('Error: ' || sqlerrm);
2822: rollback;
2823: hr_utility.raise_error;
2824: END create_retro_defn_components;
2825:

Line 2823: hr_utility.raise_error;

2819: EXCEPTION
2820: WHEN OTHERS THEN
2821: hr_utility.trace('Error: ' || sqlerrm);
2822: rollback;
2823: hr_utility.raise_error;
2824: END create_retro_defn_components;
2825:
2826: --
2827: --------------------------------------------------------------------------

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

2902: RETURN l_time_definition_id;
2903: --
2904: EXCEPTION
2905: WHEN OTHERS THEN
2906: hr_utility.trace('Error: ' || sqlerrm);
2907: rollback;
2908: hr_utility.raise_error;
2909: END create_time_definitions;
2910:

Line 2908: hr_utility.raise_error;

2904: EXCEPTION
2905: WHEN OTHERS THEN
2906: hr_utility.trace('Error: ' || sqlerrm);
2907: rollback;
2908: hr_utility.raise_error;
2909: END create_time_definitions;
2910:
2911: --------------------------------------------------------------------------
2912: -- Private Function to create time spans

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

2974: RETURN l_time_span_id;
2975: --
2976: EXCEPTION
2977: WHEN OTHERS THEN
2978: hr_utility.trace('Error: While inserting time spans : ' || sqlerrm);
2979: rollback;
2980: hr_utility.raise_error;
2981: --
2982: END create_time_spans;

Line 2980: hr_utility.raise_error;

2976: EXCEPTION
2977: WHEN OTHERS THEN
2978: hr_utility.trace('Error: While inserting time spans : ' || sqlerrm);
2979: rollback;
2980: hr_utility.raise_error;
2981: --
2982: END create_time_spans;
2983:
2984: --------------------------------------------------------------------------

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

3012: AND pesu.adjustment_type IS NULL;
3013: --
3014: BEGIN
3015: --
3016: hr_utility.trace('Fetch the required details');
3017: --
3018: hr_utility.trace('Checking... if it already exists');
3019: --
3020: OPEN csr_exists;

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

3014: BEGIN
3015: --
3016: hr_utility.trace('Fetch the required details');
3017: --
3018: hr_utility.trace('Checking... if it already exists');
3019: --
3020: OPEN csr_exists;
3021: FETCH csr_exists INTO l_element_span_usage_id;
3022: CLOSE csr_exists;

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

3051: , -1
3052: , 1
3053: FROM dual;
3054: --
3055: hr_utility.trace('Inserted the required element');
3056: END IF;
3057: --
3058: END create_element_spans;
3059:

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

3096: --
3097: OPEN csr_get_details;
3098: FETCH csr_get_details INTO l_retro_component_id, l_element_type_id;
3099: IF csr_get_details%NOTFOUND THEN
3100: hr_utility.trace('Invalid component or element type');
3101: hr_utility.raise_error;
3102: END IF;
3103: CLOSE csr_get_details;
3104: --

Line 3101: hr_utility.raise_error;

3097: OPEN csr_get_details;
3098: FETCH csr_get_details INTO l_retro_component_id, l_element_type_id;
3099: IF csr_get_details%NOTFOUND THEN
3100: hr_utility.trace('Invalid component or element type');
3101: hr_utility.raise_error;
3102: END IF;
3103: CLOSE csr_get_details;
3104: --
3105: hr_utility.trace('Valid component and element type');

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

3101: hr_utility.raise_error;
3102: END IF;
3103: CLOSE csr_get_details;
3104: --
3105: hr_utility.trace('Valid component and element type');
3106: --
3107: OPEN csr_exists;
3108: FETCH csr_exists into l_retro_component_usage_id;
3109: CLOSE csr_exists;

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

3109: CLOSE csr_exists;
3110: --
3111: IF l_retro_component_usage_id is null THEN
3112: --
3113: hr_utility.trace('Before inserting data into component usages');
3114: --
3115: INSERT INTO pay_retro_component_usages
3116: (RETRO_COMPONENT_USAGE_ID
3117: ,RETRO_COMPONENT_ID

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

3145: SELECT pay_retro_component_usages_s.currval
3146: INTO l_retro_component_usage_id
3147: from dual;
3148: --
3149: hr_utility.trace('Inserted retro component usage: ' || l_retro_component_usage_id);
3150: --
3151: create_element_spans(l_retro_component_usage_id
3152: ,l_retro_component_id
3153: ,p_retro_element_name

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

3154: ,p_time_span_id);
3155: --
3156: END IF;
3157: --
3158: hr_utility.trace('Inserted retro component: ' || p_retro_element_name);
3159: --
3160: END create_comp_usages;
3161:
3162: --------------------------------------------------------------------------

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

3189: RETURN l_time_definition_id;
3190: --
3191: EXCEPTION
3192: WHEN OTHERS THEN
3193: hr_utility.trace('Error: ' || sqlerrm);
3194: rollback;
3195: hr_utility.raise_error;
3196: END get_time_definitions;
3197:

Line 3195: hr_utility.raise_error;

3191: EXCEPTION
3192: WHEN OTHERS THEN
3193: hr_utility.trace('Error: ' || sqlerrm);
3194: rollback;
3195: hr_utility.raise_error;
3196: END get_time_definitions;
3197:
3198:
3199: --------------------------------------------------------------------------

Line 3223: g_debug := hr_utility.debug_enabled;

3219:
3220:
3221: BEGIN
3222:
3223: g_debug := hr_utility.debug_enabled;
3224:
3225: IF g_debug THEN
3226: l_procedure_name := '.set_retro_status_rule';
3227: hr_utility.set_location('Entering Procedure '||gv_package_name||l_procedure_name,10);

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

3223: g_debug := hr_utility.debug_enabled;
3224:
3225: IF g_debug THEN
3226: l_procedure_name := '.set_retro_status_rule';
3227: hr_utility.set_location('Entering Procedure '||gv_package_name||l_procedure_name,10);
3228: END IF;
3229:
3230: /* Insert the legislation rule */
3231: OPEN csr_exists;

Line 3252: hr_utility.set_location('Leagvin Procedure '||gv_package_name||l_procedure_name,10);

3248: AND legislation_code = 'AU' ;
3249: END IF;
3250:
3251: IF g_debug THEN
3252: hr_utility.set_location('Leagvin Procedure '||gv_package_name||l_procedure_name,10);
3253: END IF;
3254:
3255: END set_retro_status_rule;
3256:

Line 3558: g_debug := hr_utility.debug_enabled;

3554: l_proc_name varchar2(80);
3555: l_exists boolean;
3556:
3557: BEGIN
3558: g_debug := hr_utility.debug_enabled;
3559:
3560: IF g_debug
3561: THEN
3562: l_proc_name := '.set_enh_retro_request_group';

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

3559:
3560: IF g_debug
3561: THEN
3562: l_proc_name := '.set_enh_retro_request_group';
3563: hr_utility.trace('Entering '||gv_package_name||l_proc_name);
3564: END IF;
3565:
3566: l_req_grp_name := 'AU HRMS Reports and Processes';
3567: l_grp_app_name := 'PER';

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

3593: group_application => l_grp_app_name);
3594:
3595: IF g_debug
3596: THEN
3597: hr_utility.trace('Program Added to Request Group '||l_add_prog_name(i));
3598: END IF;
3599: END IF;
3600: END LOOP;
3601:

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

3624: group_application => l_grp_app_name);
3625:
3626: IF g_debug
3627: THEN
3628: hr_utility.trace('Program Removed from Request Group '||l_del_prog_name(i));
3629: END IF;
3630: END IF;
3631: END LOOP;
3632:

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

3632:
3633: IF g_debug
3634: THEN
3635: l_proc_name := '.set_enh_retro_request_group';
3636: hr_utility.trace('Leaving '||gv_package_name||l_proc_name);
3637: END IF;
3638: END set_enh_retro_request_group;
3639:
3640: /*

Line 3673: g_debug := hr_utility.debug_enabled;

3669: l_bg_leg_code VARCHAR2(10);
3670:
3671: BEGIN
3672:
3673: g_debug := hr_utility.debug_enabled;
3674: g_legislation_code := 'AU';
3675:
3676: IF g_debug THEN
3677: l_procedure_name := '.enable_au_enhanced_retro';

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

3674: g_legislation_code := 'AU';
3675:
3676: IF g_debug THEN
3677: l_procedure_name := '.enable_au_enhanced_retro';
3678: hr_utility.trace('Entering '||gv_package_name||l_procedure_name);
3679: END IF;
3680:
3681: l_leg_rule := pay_au_retro_upgrade.set_retro_leg_rule(p_calling_form => 'UPGRADE');
3682:

Line 3747: g_debug := hr_utility.debug_enabled;

3743: l_exists NUMBER;
3744:
3745: BEGIN
3746:
3747: g_debug := hr_utility.debug_enabled;
3748: g_legislation_code := 'AU';
3749:
3750: IF g_debug THEN
3751: lv_procedure_name := '.enable_au_retro_overlap';

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

3748: g_legislation_code := 'AU';
3749:
3750: IF g_debug THEN
3751: lv_procedure_name := '.enable_au_retro_overlap';
3752: hr_utility.trace('Entering '||gv_package_name||lv_procedure_name);
3753: END IF;
3754:
3755: OPEN c_retro_rule_check('ADVANCED_RETRO') ;
3756: FETCH c_retro_rule_check into l_adv_retro_rule;

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

3795: fnd_file.put_line(FND_FILE.LOG,'MESSAGE: Retro Overlap Rule is NOT enabled. Enhanced Retropay rule must be enabled before Retro Overlap upgrade.');
3796: END IF;
3797:
3798: IF g_debug THEN
3799: hr_utility.trace('Leaving '||gv_package_name||lv_procedure_name);
3800: END IF;
3801:
3802: EXCEPTION WHEN others THEN
3803: fnd_file.put_line(FND_FILE.LOG,gv_package_name||lv_procedure_name);