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.3.12010000.5 2008/09/17 22:12:45 rnestor ship $ */
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.3.12010000.5 2008/09/17 22:12:45 rnestor ship $ */
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 1306: 'Error in pqp_alien_expat_taxation_pkg.insert_pay_process_'||

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

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

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

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

1987: --
1988: hr_utility.set_message(800, 'HR_7462_PLK_INVLD_VALUE');
1989: hr_utility.set_message_token('COLUMN_NAME', 'Source Type');
1990: hr_utility.set_message_token
1991: ('API_NAME','pqp_alien_expat_taxation_pkg.pqp_windstar_person_read');
1992: hr_utility.raise_error;
1993: end if;
1994:
1995: hr_utility.set_location(l_proc, 10);

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

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

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

3918: exception --EXC1}{
3919: when OTHERS then
3920: hr_utility.set_location('Entering exc'||l_proc, 320);
3921: hr_utility.set_message(800, 'DTU10_GENERAL_ORACLE_ERROR');
3922: hr_utility.set_message_token('2', 'Error in pqp_alien_expat_taxation_pkg.'
3923: || 'pqp_windstar_balance_read. Error Code = ' || TO_CHAR(sqlcode) ||
3924: ' ' || sqlerrm);
3925: hr_utility.raise_error;
3926: end pqp_windstar_balance_read; --END1}

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

4409: exception
4410: when OTHERS then
4411: hr_utility.set_location('Entering exc'||l_proc, 170);
4412: hr_utility.set_message(800, 'DTU10_GENERAL_ORACLE_ERROR');
4413: hr_utility.set_message_token('2', 'Error in pqp_alien_expat_taxation_pkg.'
4414: || 'pqp_windstar_visa_read. Error Code = ' || TO_CHAR(sqlcode) ||
4415: ' ' || sqlerrm);
4416: hr_utility.raise_error;
4417: end pqp_windstar_visa_read;

Line 4476: 'pqp_alien_expat_taxation_pkg.pqp_read_public');

4472: if (p_selection_criterion is null) then
4473: hr_utility.set_message(800, 'HR_7207_API_MANDATORY_ARG');
4474: hr_utility.set_message_token('ARGUMENT', 'Selection Criterion');
4475: hr_utility.set_message_token('API_NAME',
4476: 'pqp_alien_expat_taxation_pkg.pqp_read_public');
4477: hr_utility.raise_error;
4478: end if;
4479: begin
4480: hr_utility.set_location(l_proc, 10);

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

4545: when OTHERS then
4546: hr_utility.set_location('Entering exception:'||l_proc, 50);
4547: hr_utility.set_message(800, 'DTU10_GENERAL_ORACLE_ERROR');
4548: hr_utility.set_message_token('2', 'Error in '
4549: || 'pqp_alien_expat_taxation_pkg.pqp_read_public. Error '
4550: || 'Code = ' || TO_CHAR(Sqlcode) || ' ' || sqlerrm);
4551: hr_utility.raise_error;
4552: end;
4553: hr_utility.set_location(l_proc, 60);

Line 4776: t_balance_tab pqp_alien_expat_taxation_pkg.t_balance_tab_type;

4772: ,p_forecast_income_code in varchar2
4773: ,p_error_message out nocopy varchar2
4774: ) is
4775:
4776: t_balance_tab pqp_alien_expat_taxation_pkg.t_balance_tab_type;
4777: l_retro_lose_ben_amt_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4778: l_retro_lose_ben_date_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4779: l_income_code_change_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4780: l_current_analysis_mesg pqp_alien_transaction_data.ERROR_TEXT%type;

Line 6182: end pqp_alien_expat_taxation_pkg;

6178:
6179: end AbortReadAPI;
6180:
6181:
6182: end pqp_alien_expat_taxation_pkg;