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.HZ_CUSTOMER_INT dependencies on FND_API

Line 3576: x_return_status := FND_API.G_RET_STS_SUCCESS;

3572:
3573: BEGIN
3574: FND_FILE.put_line(fnd_file.log,'sync_tax_reference + req_id : '||p_request_id);
3575:
3576: x_return_status := FND_API.G_RET_STS_SUCCESS;
3577:
3578: OPEN c_tax_reference;
3579: FETCH c_tax_reference BULK COLLECT INTO l_party_id, l_tax_reference ;
3580:

Line 3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3611: FND_FILE.put_line(fnd_file.log,'sync_tax_reference - ');
3612:
3613: EXCEPTION
3614: WHEN OTHERS THEN
3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3616: x_msg_data := SQLERRM;
3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in HZ_CUSTOMER_INT.sync_tax_reference : ' || SQLERRM);
3618:
3619:

Line 3667: x_return_status := FND_API.G_RET_STS_SUCCESS;

3663: l_cust_tax_reference VARCHAR2(50);
3664:
3665: BEGIN
3666:
3667: x_return_status := FND_API.G_RET_STS_SUCCESS;
3668:
3669: --Dbms_Output.put_line('Import_tax_attributes +');
3670:
3671: FND_FILE.put_line(fnd_file.log,'Import_tax_attributes +'||p_MODE||' req_id - '||p_request_id);

Line 3712: ,p_gather_stats => FND_API.G_TRUE

3708: FND_FILE.put_line(fnd_file.log,SYSDATE||' Call ZX_PTP_IMPORT.IMPORT_WRAPPER for VALIDATE with request_id :'||p_request_id);
3709:
3710: ZX_PTP_IMPORT.IMPORT_WRAPPER(p_request_id => p_request_id
3711: ,p_interface_table_name => 'RA_CUSTOMERS_INTERFACE_ALL'
3712: ,p_gather_stats => FND_API.G_TRUE
3713: , p_validate_only => FND_API.G_TRUE
3714: , p_sql_select_insert_ptp_intf => l_sql_select_insert_ptp_intf
3715: , p_sql_from_insert_ptp_intf => l_sql_from_insert_ptp_intf
3716: , p_insert_only => FND_API.G_FALSE

Line 3713: , p_validate_only => FND_API.G_TRUE

3709:
3710: ZX_PTP_IMPORT.IMPORT_WRAPPER(p_request_id => p_request_id
3711: ,p_interface_table_name => 'RA_CUSTOMERS_INTERFACE_ALL'
3712: ,p_gather_stats => FND_API.G_TRUE
3713: , p_validate_only => FND_API.G_TRUE
3714: , p_sql_select_insert_ptp_intf => l_sql_select_insert_ptp_intf
3715: , p_sql_from_insert_ptp_intf => l_sql_from_insert_ptp_intf
3716: , p_insert_only => FND_API.G_FALSE
3717: , p_sql_select_valid_party_id => NULL

Line 3716: , p_insert_only => FND_API.G_FALSE

3712: ,p_gather_stats => FND_API.G_TRUE
3713: , p_validate_only => FND_API.G_TRUE
3714: , p_sql_select_insert_ptp_intf => l_sql_select_insert_ptp_intf
3715: , p_sql_from_insert_ptp_intf => l_sql_from_insert_ptp_intf
3716: , p_insert_only => FND_API.G_FALSE
3717: , p_sql_select_valid_party_id => NULL
3718: , p_sql_from_valid_party_id => NULL
3719: , p_sql_select_insert_ptp_prod => NULL
3720: , p_sql_from_insert_ptp_prod => NULL

Line 3721: , p_commit => FND_API.G_FALSE

3717: , p_sql_select_valid_party_id => NULL
3718: , p_sql_from_valid_party_id => NULL
3719: , p_sql_select_insert_ptp_prod => NULL
3720: , p_sql_from_insert_ptp_prod => NULL
3721: , p_commit => FND_API.G_FALSE
3722: , p_batch_id => null
3723: , x_return_status => x_return_status
3724: , x_msg_data => x_msg_data);
3725:

Line 3730: IF x_return_status <>FND_API.G_RET_STS_SUCCESS AND x_return_status <> 'W' THEN

3726:
3727:
3728: FND_FILE.put_line(fnd_file.log,SYSDATE||' End Call ZX_PTP_IMPORT.IMPORT_WRAPPER for VALIDATE with status :'||x_return_status);
3729:
3730: IF x_return_status <>FND_API.G_RET_STS_SUCCESS AND x_return_status <> 'W' THEN
3731: FND_FILE.put_line(fnd_file.log,SYSDATE||' Error in Call ZX_PTP_IMPORT.IMPORT_WRAPPER for VALIDATE :'||x_msg_data);
3732: END IF;
3733:
3734:

Line 3890: ,p_gather_stats => FND_API.G_FALSE

3886: FND_FILE.put_line(fnd_file.log,'['||To_Char(SYSDATE,'DD-MON-RRRR HH24:MI:SS')||'] '||' Call ZX_PTP_IMPORT.IMPORT_WRAPPER for INSERT with request_id :'||l_request_id);
3887:
3888: ZX_PTP_IMPORT.IMPORT_WRAPPER(p_request_id => l_request_id
3889: ,p_interface_table_name => 'RA_CUSTOMERS_INTERFACE_ALL'
3890: ,p_gather_stats => FND_API.G_FALSE
3891: , p_validate_only => FND_API.G_FALSE
3892: , p_sql_select_insert_ptp_intf => NULL
3893: , p_sql_from_insert_ptp_intf => NULL
3894: , p_insert_only => FND_API.G_TRUE

Line 3891: , p_validate_only => FND_API.G_FALSE

3887:
3888: ZX_PTP_IMPORT.IMPORT_WRAPPER(p_request_id => l_request_id
3889: ,p_interface_table_name => 'RA_CUSTOMERS_INTERFACE_ALL'
3890: ,p_gather_stats => FND_API.G_FALSE
3891: , p_validate_only => FND_API.G_FALSE
3892: , p_sql_select_insert_ptp_intf => NULL
3893: , p_sql_from_insert_ptp_intf => NULL
3894: , p_insert_only => FND_API.G_TRUE
3895: , p_sql_select_valid_party_id => l_sql_select_valid_party_id

Line 3894: , p_insert_only => FND_API.G_TRUE

3890: ,p_gather_stats => FND_API.G_FALSE
3891: , p_validate_only => FND_API.G_FALSE
3892: , p_sql_select_insert_ptp_intf => NULL
3893: , p_sql_from_insert_ptp_intf => NULL
3894: , p_insert_only => FND_API.G_TRUE
3895: , p_sql_select_valid_party_id => l_sql_select_valid_party_id
3896: , p_sql_from_valid_party_id => l_sql_from_valid_party_id
3897: , p_sql_select_insert_ptp_prod => l_sql_select_insert_ptp_prod
3898: , p_sql_from_insert_ptp_prod => l_sql_from_insert_ptp_prod

Line 3899: , p_commit => FND_API.G_FALSE

3895: , p_sql_select_valid_party_id => l_sql_select_valid_party_id
3896: , p_sql_from_valid_party_id => l_sql_from_valid_party_id
3897: , p_sql_select_insert_ptp_prod => l_sql_select_insert_ptp_prod
3898: , p_sql_from_insert_ptp_prod => l_sql_from_insert_ptp_prod
3899: , p_commit => FND_API.G_FALSE
3900: , p_batch_id => NULL
3901: , x_return_status => x_return_status
3902: , x_msg_data => x_msg_data);
3903:

Line 3908: IF x_return_status <>FND_API.G_RET_STS_SUCCESS THEN

3904:
3905:
3906: FND_FILE.put_line(fnd_file.log,'['||To_Char(SYSDATE,'DD-MON-RRRR HH24:MI:SS')||'] '||' End Call ZX_PTP_IMPORT.IMPORT_WRAPPER for INSERT with status :'||x_return_status);
3907:
3908: IF x_return_status <>FND_API.G_RET_STS_SUCCESS THEN
3909: FND_FILE.put_line(fnd_file.log,SYSDATE||' Error in Call ZX_PTP_IMPORT.IMPORT_WRAPPER for INSERT :'||x_msg_data);
3910: END IF;
3911:
3912: ELSIF p_mode = 'DISP_STATS' THEN

Line 3937: ,p_display_stats => FND_API.G_TRUE

3933: FND_FILE.put_line(fnd_file.output,'');
3934:
3935: ZX_PTP_IMPORT.MESSAGE_WRAPPER(p_request_id => l_request_id
3936: ,p_interface_table_name => 'RA_CUSTOMERS_INTERFACE_ALL'
3937: ,p_display_stats => FND_API.G_TRUE
3938: ,p_display_messages => FND_API.G_FALSE
3939: ,p_message_header_string_1 => NULL
3940: ,p_message_header_string_2 => NULL
3941: ,x_return_status => x_return_status

Line 3938: ,p_display_messages => FND_API.G_FALSE

3934:
3935: ZX_PTP_IMPORT.MESSAGE_WRAPPER(p_request_id => l_request_id
3936: ,p_interface_table_name => 'RA_CUSTOMERS_INTERFACE_ALL'
3937: ,p_display_stats => FND_API.G_TRUE
3938: ,p_display_messages => FND_API.G_FALSE
3939: ,p_message_header_string_1 => NULL
3940: ,p_message_header_string_2 => NULL
3941: ,x_return_status => x_return_status
3942: ,x_msg_data => x_msg_data

Line 3975: ,p_display_stats => FND_API.G_FALSE

3971:
3972:
3973: ZX_PTP_IMPORT.MESSAGE_WRAPPER(p_request_id => l_request_id
3974: ,p_interface_table_name => 'RA_CUSTOMERS_INTERFACE_ALL'
3975: ,p_display_stats => FND_API.G_FALSE
3976: ,p_display_messages => FND_API.G_TRUE
3977: ,p_message_header_string_1 => l_message_header_string_1
3978: ,p_message_header_string_2 => l_message_header_string_2
3979: ,x_return_status => x_return_status

Line 3976: ,p_display_messages => FND_API.G_TRUE

3972:
3973: ZX_PTP_IMPORT.MESSAGE_WRAPPER(p_request_id => l_request_id
3974: ,p_interface_table_name => 'RA_CUSTOMERS_INTERFACE_ALL'
3975: ,p_display_stats => FND_API.G_FALSE
3976: ,p_display_messages => FND_API.G_TRUE
3977: ,p_message_header_string_1 => l_message_header_string_1
3978: ,p_message_header_string_2 => l_message_header_string_2
3979: ,x_return_status => x_return_status
3980: ,x_msg_data => x_msg_data

Line 4013: ,p_commit => FND_API.G_FALSE

4009:
4010: FND_FILE.put_line(fnd_file.log,'Call ZX_PTP_IMPORT.delete_success_records');
4011:
4012: ZX_PTP_IMPORT.delete_success_records(p_request_id => l_request_id
4013: ,p_commit => FND_API.G_FALSE
4014: ,x_return_status => x_return_status
4015: ,x_msg_data => x_msg_data);
4016:
4017: FND_FILE.put_line(fnd_file.log,'End Call ZX_PTP_IMPORT.delete_success_records');