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

Line 125: Purpose : Log a message, either using fnd_file, or hr_utility.trace

121:
122:
123: /******************************************************************************
124: Name : msg
125: Purpose : Log a message, either using fnd_file, or hr_utility.trace
126: ******************************************************************************/
127:
128: PROCEDURE msg(p_text VARCHAR2)
129: IS

Line 139: Purpose : Log a message, either using fnd_file, or hr_utility.trace

135: END msg;
136:
137: /******************************************************************************
138: Name : dbg
139: Purpose : Log a message, either using fnd_file, or hr_utility.trace
140: if debuggging is enabled
141: ******************************************************************************/
142: PROCEDURE dbg(p_text VARCHAR2) IS
143:

Line 152: hr_utility.trace(p_text);

148: -- Write to the concurrent request log
149: fnd_file.put_line(fnd_file.log, p_text);
150: ELSE
151: -- Use HR trace
152: hr_utility.trace(p_text);
153: END IF;
154: END IF;
155:
156: END dbg;

Line 375: hr_utility.set_location(gv_package || lv_procedure_name, 10);

371: BEGIN
372:
373: lv_procedure_name := '.get_payroll_action_info';
374:
375: hr_utility.set_location(gv_package || lv_procedure_name, 10);
376: ln_step := 1;
377: dbg('Entering get_payroll_action_info .......');
378:
379: -- open the cursor to get all the parameters from pay_payroll_actions table

Line 392: hr_utility.set_location(gv_package || lv_procedure_name, 20);

388: close c_payroll_action_info;
389:
390: -- get the report Implementation Date from ln_legal_emp_id and set it to the
391: -- global variable g_report_imp_date
392: hr_utility.set_location(gv_package || lv_procedure_name, 20);
393: ln_step := 2;
394: dbg('Get report Impl date for Legal employer id ' ||to_char(ln_legal_emp_id) );
395:
396: open c_get_imp_date(ln_legal_emp_id) ;

Line 407: hr_utility.set_location(gv_package || lv_procedure_name, 40);

403: close c_get_imp_date;
404: dbg('report impl date is '||to_char(ld_report_imp_date) );
405: g_report_imp_date := ld_report_imp_date;
406:
407: hr_utility.set_location(gv_package || lv_procedure_name, 40);
408: ln_step := 3;
409: dbg('Get Event Group Id ' );
410:
411: open c_get_event_group(gv_event_group) ;

Line 430: hr_utility.set_location(gv_package || lv_procedure_name, 40);

426: dbg('trans gre id : ' || to_char(p_tran_gre_id)) ;
427: dbg('gre id : ' || to_char(p_gre_id)) ;
428: dbg('event group id : ' || to_char(p_event_group_id) );
429:
430: hr_utility.set_location(gv_package || lv_procedure_name, 40);
431: ln_step := 4;
432:
433: dbg('Exiting get_payroll_action_info .......');
434:

Line 441: hr_utility.raise_error;

437: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
438: gv_package || lv_procedure_name;
439:
440: dbg(lv_error_message || '-' || sqlerrm);
441: hr_utility.raise_error;
442:
443: END get_payroll_action_info;
444:
445:

Line 494: hr_utility.set_location(gv_package || lv_procedure_name, 10);

490: g_debug_flag := 'Y' ;
491: -- g_concurrent_flag := 'Y' ;
492:
493: lv_procedure_name := '.range_cursor';
494: hr_utility.set_location(gv_package || lv_procedure_name, 10);
495:
496: lv_func_area := 'SS Affiliation Events' ;
497:
498: -- Get all the parameter information from pay_payroll_actions table

Line 509: hr_utility.set_location(gv_package || lv_procedure_name, 20);

505: ,p_tran_gre_id => ln_tran_gre_id
506: ,p_gre_id => ln_gre_id
507: ,p_event_group_id => ln_event_group_id);
508:
509: hr_utility.set_location(gv_package || lv_procedure_name, 20);
510:
511: -- Check the dynamic triggers are enable for functional area
512: dbg('Check dynamic triggers enabled' ) ;
513:

Line 523: hr_utility.raise_error;

519:
520: dbg('Error : Dynamic triggers NOT enabled' ) ;
521: lv_sql_string := null;
522:
523: hr_utility.raise_error;
524:
525: else
526:
527: dbg('Dynamic triggers Enabled' ) ;

Line 549: hr_utility.set_location(gv_package || lv_procedure_name, 30);

545: and :payroll_action_id > 0 ' ;
546:
547: end if;
548:
549: hr_utility.set_location(gv_package || lv_procedure_name, 30);
550: p_sqlstr := lv_sql_string;
551: hr_utility.set_location(gv_package || lv_procedure_name, 40);
552:
553: dbg('Exiting range_cursor .......') ;

Line 551: hr_utility.set_location(gv_package || lv_procedure_name, 40);

547: end if;
548:
549: hr_utility.set_location(gv_package || lv_procedure_name, 30);
550: p_sqlstr := lv_sql_string;
551: hr_utility.set_location(gv_package || lv_procedure_name, 40);
552:
553: dbg('Exiting range_cursor .......') ;
554:
555: END range_cursor;

Line 687: hr_utility.set_location(gv_package || lv_procedure_name, 10);

683: -- g_concurrent_flag := 'Y' ;
684:
685: lv_procedure_name := '.action_creation';
686:
687: hr_utility.set_location(gv_package || lv_procedure_name, 10);
688: ln_step := 1;
689: dbg('Get parameter information from pay_payroll_actions table' ) ;
690:
691: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

Line 701: hr_utility.set_location(gv_package || lv_procedure_name, 20);

697: ,p_event_group_id => ln_event_group_id
698: );
699:
700:
701: hr_utility.set_location(gv_package || lv_procedure_name, 20);
702: ln_step := 2;
703: dbg('Action creation Query parameters') ;
704: dbg('Start assignment id : ' || to_char(p_start_assignment_id));
705: dbg('End assignment id : ' || to_char(p_end_assignment_id));

Line 723: hr_utility.set_location(gv_package || lv_procedure_name, 30);

719: ,ld_end_date
720: ,ln_event_group_id);
721:
722: -- Loop for all rows returned for SQL statement.
723: hr_utility.set_location(gv_package || lv_procedure_name, 30);
724: ln_step := 3;
725:
726: loop
727: fetch c_get_asg into ln_assignment_id ;

Line 733: hr_utility.set_location(gv_package || lv_procedure_name, 40);

729:
730: -- if gre_id is not null then tax_unit_id= gre_id
731: -- if tran_gre_id is not null then tax_unit_id = tran_gre_id
732:
733: hr_utility.set_location(gv_package || lv_procedure_name, 40);
734: ln_step := 4;
735: dbg('creating aaid for assignment_id = ' || to_char(ln_assignment_id) ||
736: ' Tax Unit Id = ' || to_char(nvl(ln_gre_id,ln_tran_gre_id)) ) ;
737:

Line 758: hr_utility.set_location(gv_package || lv_procedure_name, 50);

754:
755: end loop;
756: close c_get_asg;
757:
758: hr_utility.set_location(gv_package || lv_procedure_name, 50);
759: ln_step := 5;
760:
761: dbg('Exiting Action creation ..............') ;
762:

Line 769: hr_utility.raise_error;

765: when others then
766: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
767: gv_package || lv_procedure_name;
768: dbg(lv_error_message || '-' || sqlerrm);
769: hr_utility.raise_error;
770:
771: END action_creation;
772:
773: /******************************************************************************

Line 799: hr_utility.set_location(gv_package || lv_procedure_name, 10);

795: -- g_concurrent_flag := 'Y' ;
796:
797: lv_procedure_name := '.archinit';
798:
799: hr_utility.set_location(gv_package || lv_procedure_name, 10);
800: ln_step := 1;
801:
802: dbg('Exiting archinit .............');
803:

Line 995: hr_utility.set_location(gv_package || lv_procedure_name, 10);

991: lv_layout_identifier := '9' ;
992: ld_sep_date := p_effective_date-1 ;
993:
994: ln_step := 1;
995: hr_utility.set_location(gv_package || lv_procedure_name, 10);
996:
997: dbg('Get employer ss id ');
998: -- get employer ss id for p_tax_unit_id
999: open c_get_er_ss_number(p_tax_unit_id) ;

Line 1004: hr_utility.set_location(gv_package || lv_procedure_name, 20);

1000: fetch c_get_er_ss_number into lv_er_ss_number ;
1001: close c_get_er_ss_number ;
1002:
1003: ln_step := 2;
1004: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1005:
1006: dbg('Get GRE leaving reason from assignment extra info ');
1007: -- get GRE leaving reason
1008: open c_get_leaving_reason( p_assignment_id

Line 1027: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1023: end if;
1024:
1025:
1026: ln_step := 3;
1027: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1028:
1029: dbg('Get IMSS way bill for gre '|| to_char(p_tax_unit_id));
1030:
1031: -- get IMSS Waybill for p_tax_unit_id

Line 1055: hr_utility.set_location(gv_package || lv_procedure_name, 40);

1051:
1052: dbg('IMSS Waybill Number is '||lv_imss_way_bill );
1053:
1054: ln_step := 4;
1055: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1056:
1057: dbg('Get separation details from assignment' );
1058: -- get the asg details from the table
1059: open c_get_sep_details( p_assignment_id,

Line 1072: hr_utility.set_location(gv_package || lv_procedure_name, 50);

1068: close c_get_sep_details ;
1069:
1070:
1071: ln_step := 5;
1072: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1073:
1074: msg('Calling the Api to create the separation details with the parameters ');
1075:
1076: msg('Action_information_category : ' || 'MX SS SEPARATION DETAILS' );

Line 1123: hr_utility.set_location(gv_package || lv_procedure_name, 100);

1119: );
1120: msg('Successfully Archived. Action Information Id is : ' || to_char(ln_action_information_id) );
1121:
1122: ln_step := 10;
1123: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1124:
1125: dbg('Exiting archive_sep_details .........');
1126:
1127: EXCEPTION

Line 1134: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1130: gv_package || lv_procedure_name;
1131:
1132: dbg(lv_error_message || '-' || sqlerrm);
1133:
1134: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1135: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1136: hr_utility.raise_error;
1137:
1138: END archive_sep_details ;

Line 1135: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

1131:
1132: dbg(lv_error_message || '-' || sqlerrm);
1133:
1134: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1135: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1136: hr_utility.raise_error;
1137:
1138: END archive_sep_details ;
1139:

Line 1136: hr_utility.raise_error;

1132: dbg(lv_error_message || '-' || sqlerrm);
1133:
1134: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1135: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1136: hr_utility.raise_error;
1137:
1138: END archive_sep_details ;
1139:
1140:

Line 1247: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1243: lv_layout_identifier := '9' ;
1244:
1245:
1246: ln_step := 1;
1247: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1248:
1249: dbg('Get employer ssid ');
1250: -- get employer ss id for p_tax_unit_id
1251: open c_get_er_ss_number(p_tax_unit_id) ;

Line 1256: hr_utility.set_location(gv_package || lv_procedure_name, 20);

1252: fetch c_get_er_ss_number into lv_er_ss_number ;
1253: close c_get_er_ss_number ;
1254:
1255: ln_step := 2;
1256: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1257:
1258: dbg('Get IMSS waybill for gre '|| to_char(p_tax_unit_id) );
1259:
1260: -- get IMSS Waybill for p_tax_unit_id

Line 1285: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1281:
1282: dbg('way bill number is ' || lv_imss_way_bill );
1283:
1284: ln_step := 3;
1285: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1286:
1287: dbg('Get hire details from assignment ' );
1288: dbg('Assignment Id : ' || to_char(p_assignment_id) );
1289: dbg('Effective Date : ' || to_char(p_effective_date,'DD-MON-YYYY'));

Line 1309: hr_utility.set_location(gv_package || lv_procedure_name, 40);

1305:
1306: close c_get_hire_details ;
1307:
1308: ln_step := 4;
1309: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1310:
1311: dbg('Get reduced working week indicator from workschedule ' );
1312:
1313: -- derive Reduced Working-week indicator from workschedule

Line 1321: hr_utility.set_location(gv_package || lv_procedure_name, 50);

1317: lv_rww_indicator := null ;
1318: end if;
1319:
1320: ln_step := 5;
1321: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1322:
1323: dbg('Get IDW' );
1324:
1325: dbg('Assignment Id '||to_char(p_assignment_id) );

Line 1429: hr_utility.set_location(gv_package || lv_procedure_name, 100);

1425:
1426: msg('Successfully Archived. Action Information Id is : ' || to_char(ln_action_information_id) );
1427:
1428: ln_step := 6;
1429: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1430:
1431: dbg('Exiting archive_hire_details .........');
1432:
1433: EXCEPTION

Line 1440: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1436: gv_package || lv_procedure_name;
1437:
1438: dbg(lv_error_message || '-' || sqlerrm);
1439:
1440: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1441: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1442: hr_utility.raise_error;
1443:
1444: END archive_hire_details ;

Line 1441: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

1437:
1438: dbg(lv_error_message || '-' || sqlerrm);
1439:
1440: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1441: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1442: hr_utility.raise_error;
1443:
1444: END archive_hire_details ;
1445:

Line 1442: hr_utility.raise_error;

1438: dbg(lv_error_message || '-' || sqlerrm);
1439:
1440: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1441: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1442: hr_utility.raise_error;
1443:
1444: END archive_hire_details ;
1445:
1446: /************************************************************

Line 1486: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1482: BEGIN
1483:
1484:
1485: lv_procedure_name := '.arch_hire_separation_data';
1486: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1487: ln_step := 1;
1488:
1489: dbg('Entering arch_hire_separation_data .........');
1490:

Line 1561: hr_utility.set_location(gv_package || lv_procedure_name, 100);

1557: end if;
1558: end if;
1559:
1560:
1561: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1562: dbg('Exiting arch_hire_separation_data .........');
1563:
1564: EXCEPTION
1565: when others then

Line 1569: hr_utility.raise_error;

1565: when others then
1566: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
1567: gv_package || lv_procedure_name;
1568: dbg(lv_error_message || '-' || sqlerrm);
1569: hr_utility.raise_error;
1570:
1571: END arch_hire_separation_data;
1572:
1573: /************************************************************

Line 1638: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1634: dbg('Entering process insert event..........' );
1635:
1636: lv_procedure_name := '.process_insert_event';
1637:
1638: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1639: ln_step := 1;
1640: dbg('Get assignment details ' );
1641:
1642: open c_asg_details( p_assignment_id,

Line 1651: hr_utility.set_location(gv_package || lv_procedure_name, 20);

1647: ln_soft_coding_keyflex_id,
1648: ln_business_group_id;
1649: close c_asg_details ;
1650:
1651: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1652: ln_step := 2;
1653: dbg('Dervie GRE from location and SCL ' );
1654: ln_gre_id := derive_gre_from_loc_scl( ln_location_id
1655: ,ln_business_group_id

Line 1659: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1655: ,ln_business_group_id
1656: ,ln_soft_coding_keyflex_id
1657: ,p_effective_date ) ;
1658:
1659: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1660: ln_step := 3;
1661:
1662: if ln_gre_id = -1 or ln_gre_id = -2 then
1663: if ln_gre_id = -1 then

Line 1684: hr_utility.set_location(gv_package || lv_procedure_name, 40);

1680: return ;
1681:
1682: end if ;
1683:
1684: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1685: ln_step := 4;
1686:
1687: -- Check record exists in Archive table for person_id, gre_id,
1688: -- effective_date, hire_category

Line 1708: hr_utility.set_location(gv_package || lv_procedure_name, 50);

1704:
1705: -- Check the separation record exists in archive table for
1706: -- person_id, ger_id, effective_date, sep_category
1707:
1708: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1709: ln_step := 5;
1710:
1711: dbg('Check record exists in archive table with SEPARATION as info category' );
1712: dbg(' person id = '||to_char(ln_person_id) );

Line 1741: hr_utility.set_location(gv_package || lv_procedure_name, 60);

1737:
1738: else
1739: close c_chk_archive ;
1740:
1741: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1742:
1743: -- record does not exists in archive table
1744: dbg('HIRE Record not found in archive table');
1745:

Line 1779: hr_utility.set_location(gv_package || lv_procedure_name, 100);

1775: end if;
1776:
1777: end if ;
1778:
1779: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1780: ln_step := 6;
1781:
1782: dbg('Exiting process insert event..........' );
1783:

Line 1789: hr_utility.raise_error;

1785: when others then
1786: lv_error_message := 'Error at step ' || ln_step ||
1787: ' in ' || gv_package || lv_procedure_name;
1788: dbg(lv_error_message || '-' || sqlerrm);
1789: hr_utility.raise_error;
1790:
1791: END process_insert_event ;
1792:
1793: /************************************************************

Line 1873: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1869:
1870: dbg('Entering process correction event..............');
1871:
1872: ln_step := 1;
1873: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1874:
1875: -- assign the values to local variable
1876:
1877: lv_procedure_name := '.process_correction_event';

Line 1943: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1939: ln_old_gre_id := derive_gre_from_loc_scl( ln_old_value
1940: ,ln_business_group_id
1941: ,ln_old_value1
1942: ,p_effective_date ) ;
1943: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1944: ln_step := 2;
1945:
1946: if ln_old_gre_id = -1 or ln_old_gre_id = -2 then
1947: if ln_old_gre_id = -1 then

Line 1974: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1970: ln_new_gre_id := derive_gre_from_loc_scl( ln_new_value
1971: ,ln_business_group_id
1972: ,ln_new_value1
1973: ,p_effective_date ) ;
1974: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1975: ln_step := 3;
1976:
1977: if ln_new_gre_id = -1 or ln_new_gre_id = -2 then
1978: if ln_new_gre_id = -1 then

Line 2009: hr_utility.set_location(gv_package || lv_procedure_name, 50);

2005: if (ln_old_gre_id is not null and
2006: ln_new_gre_id is not null and
2007: ln_old_gre_id = ln_new_gre_id ) then
2008:
2009: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2010: dbg('old and new GREs are same no need to process');
2011:
2012: Return ;
2013:

Line 2018: hr_utility.set_location(gv_package || lv_procedure_name, 70);

2014: end if;
2015:
2016:
2017: ln_step := 5;
2018: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2019:
2020: -- if old gre is not null then process for old GRE
2021: if ln_old_gre_id <> -1 and ln_old_gre_id <> -2 and ln_old_gre_id is not null then
2022: dbg('Process for old GRE ' );

Line 2070: hr_utility.set_location(gv_package || lv_procedure_name, 80);

2066:
2067: end if; -- process for old gre
2068:
2069: ln_step := 6;
2070: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2071:
2072:
2073: -- if new gre id is not null then process for the new GRE
2074: if ln_new_gre_id <> -1 and ln_new_gre_id <> -2 and ln_new_gre_id is not null then

Line 2108: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2104:
2105: end if; -- process for new gre
2106:
2107: ln_step := 7;
2108: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2109:
2110: dbg('Exiting process correction event..........' );
2111:
2112: exception

Line 2117: hr_utility.raise_error;

2113: when others then
2114: lv_error_message := 'Error at step ' || ln_step ||
2115: ' in ' || gv_package || lv_procedure_name;
2116: dbg(lv_error_message || '-' || sqlerrm);
2117: hr_utility.raise_error;
2118:
2119: END process_correction_event;
2120:
2121:

Line 2208: hr_utility.set_location(gv_package || lv_procedure_name, 10);

2204: ln_new_value := p_new_value ;
2205: ln_old_value1 := p_old_value1 ;
2206: ln_new_value1 := p_new_value1 ;
2207:
2208: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2209: dbg('Get person details ' );
2210:
2211: -- get the person_id for this assignment
2212: open c_person_details(p_assignment_id,

Line 2266: hr_utility.set_location(gv_package || lv_procedure_name, 30);

2262: ln_old_gre_id := derive_gre_from_loc_scl( ln_old_value
2263: ,ln_business_group_id
2264: ,ln_old_value1
2265: ,p_effective_date ) ;
2266: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2267: ln_step := 2;
2268:
2269: if ln_old_gre_id = -1 or ln_old_gre_id = -2 then
2270: if ln_old_gre_id = -1 then

Line 2297: hr_utility.set_location(gv_package || lv_procedure_name, 30);

2293: ln_new_gre_id := derive_gre_from_loc_scl( ln_new_value
2294: ,ln_business_group_id
2295: ,ln_new_value1
2296: ,p_effective_date ) ;
2297: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2298: ln_step := 3;
2299:
2300: if ln_new_gre_id = -1 or ln_new_gre_id = -2 then
2301: if ln_new_gre_id = -1 then

Line 2332: hr_utility.set_location(gv_package || lv_procedure_name, 60);

2328: if (ln_old_gre_id is not null and
2329: ln_new_gre_id is not null and
2330: ln_old_gre_id = ln_new_gre_id) then
2331:
2332: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2333: dbg('old and new GREs are same no need to process');
2334:
2335: Return ;
2336:

Line 2369: hr_utility.set_location(gv_package || lv_procedure_name, 80);

2365: p_error_mesg => lv_gre_error_mesg,
2366: p_event_type => 'U'
2367: ) ;
2368: end if ;
2369: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2370:
2371: end if; -- old gre
2372:
2373: if ln_new_gre_id <> -1 and ln_new_gre_id <> -2 and ln_new_gre_id is not null then

Line 2419: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2415: end if ; -- chk_archive
2416: end if ; -- new gre
2417:
2418: ln_step := 5;
2419: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2420:
2421: dbg('Exiting process update event..........' );
2422:
2423: exception

Line 2429: hr_utility.raise_error;

2425: lv_error_message := 'Error at step ' || ln_step ||
2426: ' in ' || gv_package || lv_procedure_name;
2427: dbg(lv_error_message || '-' || sqlerrm);
2428:
2429: hr_utility.raise_error;
2430:
2431: END process_update_event;
2432:
2433:

Line 2494: hr_utility.set_location(gv_package || lv_procedure_name, 10);

2490: dbg('Entering process enddate event ..........');
2491:
2492: lv_procedure_name := '.process_enddate_event';
2493: ln_step := 1;
2494: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2495:
2496: open c_asg_details( p_assignment_id,
2497: p_effective_date ) ;
2498: fetch c_asg_details into ln_person_id,

Line 2612: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2608:
2609: end if; --to_char(p_effective_date)
2610:
2611: ln_step := 3;
2612: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2613:
2614: dbg('Exiting process end date event..........' );
2615:
2616: exception

Line 2622: hr_utility.raise_error;

2618: lv_error_message := 'Error at step ' || ln_step ||
2619: ' in ' || gv_package || lv_procedure_name;
2620: dbg(lv_error_message || '-' || sqlerrm);
2621:
2622: hr_utility.raise_error;
2623:
2624: END process_enddate_event;
2625:
2626: /************************************************************

Line 2682: hr_utility.set_location(gv_package || lv_procedure_name, 10);

2678: msg('Processing Assignment Id '|| to_char(p_assignment_id) );
2679:
2680: lv_procedure_name := '.interpret_all_asg_events';
2681:
2682: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2683: ln_step := 1;
2684: dbg('call the interpreter pkg ' );
2685:
2686: -- call the interpreter pkg

Line 2812: hr_utility.set_location(gv_package || lv_procedure_name, 20);

2808: Process : Process Insert, correction records ( ignore termination and
2809: corresponding reverse termination)
2810: */
2811:
2812: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2813: ln_step := 2;
2814: dbg('Remove the duplication rows on the same effective date');
2815:
2816: FOR i in 1..int_pkg_events.COUNT

Line 3009: hr_utility.set_location(gv_package || lv_procedure_name, 30);

3005: end if; -- update_type
3006:
3007: END LOOP ;
3008:
3009: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3010: ln_step := 3;
3011: dbg('Process after removed the duplication rows' );
3012: dbg('Total rows need to process from the asg events is ' || to_char(asg_events_table.COUNT) );
3013:

Line 3123: hr_utility.set_location(gv_package || lv_procedure_name, 40);

3119:
3120: END LOOP ;
3121:
3122: ln_step := 4;
3123: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3124:
3125: dbg('Exiting interpret_all_asg_events...........' );
3126:
3127:

Line 3133: hr_utility.raise_error;

3129: when others then
3130: lv_error_message := 'Error at step ' || ln_step ||
3131: ' in ' || gv_package || lv_procedure_name;
3132: dbg(lv_error_message || '-' || sqlerrm);
3133: hr_utility.raise_error;
3134:
3135: END interpret_all_asg_events ;
3136:
3137: /************************************************************

Line 3175: hr_utility.set_location(gv_package || lv_procedure_name, 10);

3171: dbg('Entering archive data ...........');
3172: dbg('assignment action id is ' || to_char(p_assignment_action_id) );
3173:
3174: lv_procedure_name := '.archive_data';
3175: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3176: ln_step := 1;
3177:
3178: dbg('Get Payroll Action Id ');
3179: open c_asg_action_info (p_assignment_action_id);

Line 3186: hr_utility.set_location(gv_package || lv_procedure_name, 20);

3182: ln_tax_unit_id ;
3183: close c_asg_action_info;
3184: dbg('Payroll action id' || to_char(ln_payroll_action_id) );
3185:
3186: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3187: ln_step := 2;
3188: dbg('Get parameter information from pay_payroll_actions table' ) ;
3189: get_payroll_action_info(p_payroll_action_id => ln_payroll_action_id
3190: ,p_start_date => ld_start_date

Line 3197: hr_utility.set_location(gv_package || lv_procedure_name, 30);

3193: ,p_tran_gre_id => ln_tran_gre_id
3194: ,p_gre_id => ln_gre_id
3195: ,p_event_group_id => ln_event_group_id);
3196:
3197: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3198: ln_step := 3;
3199: dbg('call Interpret_all_asg_events');
3200:
3201: interpret_all_asg_events( p_assignment_action_id => p_assignment_action_id

Line 3208: hr_utility.set_location(gv_package || lv_procedure_name, 40);

3204: ,p_end_date => ld_end_date
3205: ,p_event_group_id => ln_event_group_id
3206: ) ;
3207:
3208: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3209:
3210: dbg('Exiting archive data ...........');
3211:
3212: EXCEPTION

Line 3217: hr_utility.raise_error;

3213: when others then
3214: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
3215: gv_package || lv_procedure_name;
3216: dbg(lv_error_message || '-' || sqlerrm);
3217: hr_utility.raise_error;
3218:
3219: end archive_data;
3220:
3221:

Line 3223: --hr_utility.trace_on (null, 'SSAFFL');

3219: end archive_data;
3220:
3221:
3222: --begin
3223: --hr_utility.trace_on (null, 'SSAFFL');
3224:
3225: end per_mx_ssaffl_archive;