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.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PQP_ALIEN_EXPAT_TAXATION_PKG

Line 1: package body pqp_alien_expat_taxation_pkg as

1: package body pqp_alien_expat_taxation_pkg as
2: /* $Header: pqalnexp.pkb 120.10 2009/12/22 22:26:56 rnestor noship $ */
3:
4: -- global Variable
5: g_package constant varchar2(150) := 'pqp_alien_expat_taxation_pkg';

Line 5: g_package constant varchar2(150) := 'pqp_alien_expat_taxation_pkg';

1: package body pqp_alien_expat_taxation_pkg as
2: /* $Header: pqalnexp.pkb 120.10 2009/12/22 22:26:56 rnestor noship $ */
3:
4: -- global Variable
5: g_package constant varchar2(150) := 'pqp_alien_expat_taxation_pkg';
6: g_bus_grp_id number(15);
7: --
8: -- The cursor below selects the process_event_id, object_version_number,
9: -- assignment_id, description from pay_process_events with status = 'NOT_READ'

Line 667: || 'pqp_alien_expat_taxation_pkg.pqp_process_events_errorlog(create). Error '

663: when OTHERS then
664: hr_utility.set_location('Entering exception:'||l_proc, 15);
665: hr_utility.set_message(800, 'DTU10_GENERAL_ORACLE_ERROR');
666: hr_utility.set_message_token('2', 'Error in '
667: || 'pqp_alien_expat_taxation_pkg.pqp_process_events_errorlog(create). Error '
668: || 'Code = ' || TO_CHAR(Sqlcode) || ' ' || sqlerrm);
669: hr_utility.raise_error;
670:
671: end PQP_Process_Events_ErrorLog;

Line 733: || 'pqp_alien_expat_taxation_pkg.pqp_process_events_errorlog(Update). Error '

729: when others then
730: hr_utility.set_location('Entering exception:'||l_proc, 15);
731: hr_utility.set_message(800, 'DTU10_GENERAL_ORACLE_ERROR');
732: hr_utility.set_message_token('2', 'Error in '
733: || 'pqp_alien_expat_taxation_pkg.pqp_process_events_errorlog(Update). Error '
734: || 'Code = ' || TO_CHAR(Sqlcode) || ' ' || sqlerrm);
735: hr_utility.raise_error;
736:
737: end PQP_Process_Events_ErrorLog;

Line 1310: 'Error in pqp_alien_expat_taxation_pkg.insert_pay_process_'||

1306: exception
1307: when others then
1308: hr_utility.set_message(800, 'DTU10_GENERAL_ORACLE_ERROR');
1309: hr_utility.set_message_token('2',
1310: 'Error in pqp_alien_expat_taxation_pkg.insert_pay_process_'||
1311: 'events. Error Code = ' || TO_CHAR(Sqlcode) || ' ' || sqlerrm);
1312: hr_utility.set_location('Leaving :'||l_proc, 160);
1313: hr_utility.raise_error;
1314:

Line 1982: ('API_NAME','pqp_alien_expat_taxation_pkg.pqp_windstar_person_read');

1978: hr_utility.set_location('Entering '||l_proc, 6);
1979: hr_utility.set_message(800, 'HR_7207_API_MANDATORY_ARG');
1980: hr_utility.set_message_token('ARGUMENT', 'Source Type');
1981: hr_utility.set_message_token
1982: ('API_NAME','pqp_alien_expat_taxation_pkg.pqp_windstar_person_read');
1983: hr_utility.raise_error;
1984:
1985: elsif (p_source_type <> 'PQP_US_ALIEN_WINDSTAR') then
1986: hr_utility.set_location('Entering '||l_proc, 6);

Line 1995: ('API_NAME','pqp_alien_expat_taxation_pkg.pqp_windstar_person_read');

1991: --
1992: hr_utility.set_message(800, 'HR_7462_PLK_INVLD_VALUE');
1993: hr_utility.set_message_token('COLUMN_NAME', 'Source Type');
1994: hr_utility.set_message_token
1995: ('API_NAME','pqp_alien_expat_taxation_pkg.pqp_windstar_person_read');
1996: hr_utility.raise_error;
1997: end if;
1998:
1999: hr_utility.set_location(l_proc, 10);

Line 3056: hr_utility.set_message_token('2', 'Error in pqp_alien_expat_taxation_pkg.'

3052: p_person_read_count := l_person_read_count ;
3053: p_person_err_count := l_person_err_count ;
3054: hr_utility.set_location('Leaving '||l_proc, 550);
3055: hr_utility.set_message(800, 'DTU10_GENERAL_ORACLE_ERROR');
3056: hr_utility.set_message_token('2', 'Error in pqp_alien_expat_taxation_pkg.'
3057: || 'pqp_windstar_person_read. Error Code = ' || TO_CHAR(sqlcode) ||
3058: ' ' || sqlerrm);
3059: hr_utility.raise_error;
3060: end pqp_windstar_person_read;

Line 3937: hr_utility.set_message_token('2', 'Error in pqp_alien_expat_taxation_pkg.'

3933: exception --EXC1}{
3934: when OTHERS then
3935: hr_utility.set_location('Entering exc'||l_proc, 320);
3936: hr_utility.set_message(800, 'DTU10_GENERAL_ORACLE_ERROR');
3937: hr_utility.set_message_token('2', 'Error in pqp_alien_expat_taxation_pkg.'
3938: || 'pqp_windstar_balance_read. Error Code = ' || TO_CHAR(sqlcode) ||
3939: ' ' || sqlerrm);
3940: hr_utility.raise_error;
3941: end pqp_windstar_balance_read; --END1}

Line 4428: hr_utility.set_message_token('2', 'Error in pqp_alien_expat_taxation_pkg.'

4424: exception
4425: when OTHERS then
4426: hr_utility.set_location('Entering exc'||l_proc, 170);
4427: hr_utility.set_message(800, 'DTU10_GENERAL_ORACLE_ERROR');
4428: hr_utility.set_message_token('2', 'Error in pqp_alien_expat_taxation_pkg.'
4429: || 'pqp_windstar_visa_read. Error Code = ' || TO_CHAR(sqlcode) ||
4430: ' ' || sqlerrm);
4431: hr_utility.raise_error;
4432: end pqp_windstar_visa_read;

Line 4491: 'pqp_alien_expat_taxation_pkg.pqp_read_public');

4487: if (p_selection_criterion is null) then
4488: hr_utility.set_message(800, 'HR_7207_API_MANDATORY_ARG');
4489: hr_utility.set_message_token('ARGUMENT', 'Selection Criterion');
4490: hr_utility.set_message_token('API_NAME',
4491: 'pqp_alien_expat_taxation_pkg.pqp_read_public');
4492: hr_utility.raise_error;
4493: end if;
4494: begin
4495: hr_utility.set_location(l_proc, 10);

Line 4564: || 'pqp_alien_expat_taxation_pkg.pqp_read_public. Error '

4560: when OTHERS then
4561: hr_utility.set_location('Entering exception:'||l_proc, 50);
4562: hr_utility.set_message(800, 'DTU10_GENERAL_ORACLE_ERROR');
4563: hr_utility.set_message_token('2', 'Error in '
4564: || 'pqp_alien_expat_taxation_pkg.pqp_read_public. Error '
4565: || 'Code = ' || TO_CHAR(Sqlcode) || ' ' || sqlerrm);
4566: hr_utility.raise_error;
4567: end;
4568: hr_utility.set_location(l_proc, 60);

Line 4791: t_balance_tab pqp_alien_expat_taxation_pkg.t_balance_tab_type;

4787: ,p_forecast_income_code in varchar2
4788: ,p_error_message out nocopy varchar2
4789: ) is
4790:
4791: t_balance_tab pqp_alien_expat_taxation_pkg.t_balance_tab_type;
4792: l_retro_lose_ben_amt_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4793: l_retro_lose_ben_date_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4794: l_income_code_change_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4795: l_current_analysis_mesg pqp_alien_transaction_data.ERROR_TEXT%type;

Line 6197: end pqp_alien_expat_taxation_pkg;

6193:
6194: end AbortReadAPI;
6195:
6196:
6197: end pqp_alien_expat_taxation_pkg;