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_FILE

Line 1131: FND_FILE.PUT_LINE(FND_FILE.LOG,

1127: IF l_conc_dev_phase <> 'COMPLETE'
1128: OR l_conc_dev_status <> 'NORMAL' THEN
1129: retcode := 2;
1130:
1131: FND_FILE.PUT_LINE(FND_FILE.LOG,
1132: TO_CHAR( l_sub_request_id ) ||
1133: ' : ' || l_conc_phase || ':' || l_conc_status ||
1134: ' (' || l_message || ').' );
1135: RETURN;

Line 1171: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

1167:
1168: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1169: FND_MESSAGE.RETRIEVE(l_message);
1170:
1171: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
1172: retcode := 2;
1173: RETURN;
1174:
1175: ELSE

Line 1180: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

1176:
1177: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_SHOW_UPD_REQID');
1178: FND_MESSAGE.RETRIEVE(l_message);
1179:
1180: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
1181: retcode := 0;
1182:
1183: END IF;
1184:

Line 1202: FND_FILE.PUT_LINE(FND_FILE.LOG,

1198: l_profile := 'HZ_CINTERFACE_NUM_OF_WORKERS';
1199:
1200: l_num_of_workers := NVL(FND_PROFILE.VALUE(l_profile), 1);
1201:
1202: FND_FILE.PUT_LINE(FND_FILE.LOG,
1203: l_profile || ' = ' || TO_CHAR(l_num_of_workers));
1204:
1205: l_request_data := '';
1206:

Line 1227: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(i) || ' : ' || l_message);

1223:
1224: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1225: FND_MESSAGE.RETRIEVE(l_message );
1226:
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(i) || ' : ' || l_message);
1228: retcode := 2;
1229:
1230: ELSE
1231:

Line 1235: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(i) || ' : ' || l_message);

1231:
1232: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_SHOW_UPD_REQID');
1233: FND_MESSAGE.RETRIEVE(l_message);
1234:
1235: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(i) || ' : ' || l_message);
1236: retcode := 0;
1237:
1238: l_request_data := l_request_data || TO_CHAR(l_sub_request_id) || ' ';
1239: END IF;

Line 1254: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Oracle Error : ' || SQLERRM );

1250: request_data => l_request_data);
1251:
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Oracle Error : ' || SQLERRM );
1255: retcode := 2;
1256: RETURN;
1257: END conc_main;
1258:

Line 3574: FND_FILE.put_line(fnd_file.log,'sync_tax_reference + req_id : '||p_request_id);

3570: l_party_id PARTY_ID;
3571: l_tax_reference TAX_REFERENCE;
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;

Line 3587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of records updated in HZ_PARTIES : ' || l_party_id.count);

3583: UPDATE HZ_PARTIES p
3584: SET tax_reference = l_tax_reference(i)
3585: WHERE p.party_id = l_party_id(i);
3586:
3587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of records updated in HZ_PARTIES : ' || l_party_id.count);
3588:
3589: FORALL i IN 1..l_party_id.count
3590:
3591: UPDATE HZ_PERSON_PROFILES per

Line 3597: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of records updated in HZ_PERSON_PROFILES : ' || l_party_id.count);

3593: WHERE per.party_id = l_party_id(i)
3594: AND actual_content_source = 'SST'
3595: AND effective_end_date IS NULL;
3596:
3597: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of records updated in HZ_PERSON_PROFILES : ' || l_party_id.count);
3598:
3599: FORALL i IN 1..l_party_id.count
3600:
3601: UPDATE HZ_ORGANIZATION_PROFILES org

Line 3607: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of records updated in HZ_ORGANIZATION_PROFILES : ' || l_party_id.count);

3603: WHERE party_id = l_party_id(i)
3604: AND actual_content_source = 'SST'
3605: AND effective_end_date IS NULL;
3606:
3607: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of records updated in HZ_ORGANIZATION_PROFILES : ' || l_party_id.count);
3608:
3609: CLOSE c_tax_reference;
3610:
3611: FND_FILE.put_line(fnd_file.log,'sync_tax_reference - ');

Line 3611: FND_FILE.put_line(fnd_file.log,'sync_tax_reference - ');

3607: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of records updated in HZ_ORGANIZATION_PROFILES : ' || l_party_id.count);
3608:
3609: CLOSE c_tax_reference;
3610:
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;

Line 3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in HZ_CUSTOMER_INT.sync_tax_reference : ' || SQLERRM);

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:
3620: END sync_tax_reference;
3621:

Line 3671: FND_FILE.put_line(fnd_file.log,'Import_tax_attributes +'||p_MODE||' req_id - '||p_request_id);

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);
3672:
3673: IF p_mode = 'VALIDATE' THEN
3674:
3675: BEGIN

Line 3703: FND_FILE.put_line(fnd_file.log,'l_sql_select_insert_ptp_intf : '||l_sql_select_insert_ptp_intf);

3699:
3700: l_sql_select_insert_ptp_intf := NULL;
3701: l_sql_from_insert_ptp_intf := NULL;
3702:
3703: FND_FILE.put_line(fnd_file.log,'l_sql_select_insert_ptp_intf : '||l_sql_select_insert_ptp_intf);
3704: FND_FILE.put_line(fnd_file.log,'l_sql_from_insert_ptp_intf : '||l_sql_from_insert_ptp_intf);
3705:
3706: END IF;
3707:

Line 3704: FND_FILE.put_line(fnd_file.log,'l_sql_from_insert_ptp_intf : '||l_sql_from_insert_ptp_intf);

3700: l_sql_select_insert_ptp_intf := NULL;
3701: l_sql_from_insert_ptp_intf := NULL;
3702:
3703: FND_FILE.put_line(fnd_file.log,'l_sql_select_insert_ptp_intf : '||l_sql_select_insert_ptp_intf);
3704: FND_FILE.put_line(fnd_file.log,'l_sql_from_insert_ptp_intf : '||l_sql_from_insert_ptp_intf);
3705:
3706: END IF;
3707:
3708: FND_FILE.put_line(fnd_file.log,SYSDATE||' Call ZX_PTP_IMPORT.IMPORT_WRAPPER for VALIDATE with request_id :'||p_request_id);

Line 3708: FND_FILE.put_line(fnd_file.log,SYSDATE||' Call ZX_PTP_IMPORT.IMPORT_WRAPPER for VALIDATE with request_id :'||p_request_id);

3704: FND_FILE.put_line(fnd_file.log,'l_sql_from_insert_ptp_intf : '||l_sql_from_insert_ptp_intf);
3705:
3706: END IF;
3707:
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

Line 3728: FND_FILE.put_line(fnd_file.log,SYSDATE||' End Call ZX_PTP_IMPORT.IMPORT_WRAPPER for VALIDATE with status :'||x_return_status);

3724: , x_msg_data => x_msg_data);
3725:
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;

Line 3731: FND_FILE.put_line(fnd_file.log,SYSDATE||' Error in Call ZX_PTP_IMPORT.IMPORT_WRAPPER for VALIDATE :'||x_msg_data);

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:
3735: IF x_return_status = 'W' THEN

Line 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);

3882: l_request_id := p_request_id;
3883: END;
3884: END IF;
3885:
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

Line 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);

3902: , x_msg_data => x_msg_data);
3903:
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;

Line 3909: FND_FILE.put_line(fnd_file.log,SYSDATE||' Error in Call ZX_PTP_IMPORT.IMPORT_WRAPPER for INSERT :'||x_msg_data);

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
3913:

Line 3930: FND_FILE.put_line(fnd_file.log,'Call ZX_PTP_IMPORT.MESSAGE_WRAPPER stats');

3926: WHEN No_Data_Found THEN
3927: l_request_id := p_request_id;
3928: END;
3929:
3930: FND_FILE.put_line(fnd_file.log,'Call ZX_PTP_IMPORT.MESSAGE_WRAPPER stats');
3931:
3932: FND_FILE.put_line(fnd_file.log,'l_request_id -'||l_request_id);
3933: FND_FILE.put_line(fnd_file.output,'');
3934:

Line 3932: FND_FILE.put_line(fnd_file.log,'l_request_id -'||l_request_id);

3928: END;
3929:
3930: FND_FILE.put_line(fnd_file.log,'Call ZX_PTP_IMPORT.MESSAGE_WRAPPER stats');
3931:
3932: FND_FILE.put_line(fnd_file.log,'l_request_id -'||l_request_id);
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'

Line 3933: FND_FILE.put_line(fnd_file.output,'');

3929:
3930: FND_FILE.put_line(fnd_file.log,'Call ZX_PTP_IMPORT.MESSAGE_WRAPPER stats');
3931:
3932: FND_FILE.put_line(fnd_file.log,'l_request_id -'||l_request_id);
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

Line 3944: FND_FILE.put_line(fnd_file.log,'end Call ZX_PTP_IMPORT.MESSAGE_WRAPPER stats with status :'||x_return_status);

3940: ,p_message_header_string_2 => NULL
3941: ,x_return_status => x_return_status
3942: ,x_msg_data => x_msg_data
3943: );
3944: FND_FILE.put_line(fnd_file.log,'end Call ZX_PTP_IMPORT.MESSAGE_WRAPPER stats with status :'||x_return_status);
3945:
3946:
3947:
3948: ELSIF p_mode = 'DISP_ERRORS' THEN

Line 3969: FND_FILE.put_line(fnd_file.log,'Call ZX_PTP_IMPORT.MESSAGE_WRAPPER messages');

3965:
3966: l_message_header_string_1 := fnd_message.get_string('AR','AR_RACUST_OUT_ZX_HDR1');
3967: l_message_header_string_2 := fnd_message.get_string('AR','AR_RACUST_OUT_ZX_HDR2');
3968:
3969: FND_FILE.put_line(fnd_file.log,'Call ZX_PTP_IMPORT.MESSAGE_WRAPPER messages');
3970: FND_FILE.put_line(fnd_file.log,'l_request_id -'||l_request_id);
3971:
3972:
3973: ZX_PTP_IMPORT.MESSAGE_WRAPPER(p_request_id => l_request_id

Line 3970: FND_FILE.put_line(fnd_file.log,'l_request_id -'||l_request_id);

3966: l_message_header_string_1 := fnd_message.get_string('AR','AR_RACUST_OUT_ZX_HDR1');
3967: l_message_header_string_2 := fnd_message.get_string('AR','AR_RACUST_OUT_ZX_HDR2');
3968:
3969: FND_FILE.put_line(fnd_file.log,'Call ZX_PTP_IMPORT.MESSAGE_WRAPPER messages');
3970: FND_FILE.put_line(fnd_file.log,'l_request_id -'||l_request_id);
3971:
3972:
3973: ZX_PTP_IMPORT.MESSAGE_WRAPPER(p_request_id => l_request_id
3974: ,p_interface_table_name => 'RA_CUSTOMERS_INTERFACE_ALL'

Line 3983: FND_FILE.put_line(fnd_file.log,'End Call ZX_PTP_IMPORT.MESSAGE_WRAPPER messages with status :'||x_return_status);

3979: ,x_return_status => x_return_status
3980: ,x_msg_data => x_msg_data
3981: );
3982:
3983: FND_FILE.put_line(fnd_file.log,'End Call ZX_PTP_IMPORT.MESSAGE_WRAPPER messages with status :'||x_return_status);
3984:
3985: ELSIF p_mode = 'DELETE_ZX_REC' THEN
3986:
3987: IF validation_flag = 0 THEN

Line 4010: FND_FILE.put_line(fnd_file.log,'Call ZX_PTP_IMPORT.delete_success_records');

4006: END;
4007: END IF;
4008:
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

Line 4017: FND_FILE.put_line(fnd_file.log,'End Call ZX_PTP_IMPORT.delete_success_records');

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');
4018:
4019:
4020: END IF;
4021:

Line 4022: FND_FILE.put_line(fnd_file.log,'Import_tax_attributes -');

4018:
4019:
4020: END IF;
4021:
4022: FND_FILE.put_line(fnd_file.log,'Import_tax_attributes -');
4023:
4024: EXCEPTION
4025:
4026: WHEN OTHERS THEN

Line 4028: FND_FILE.put_line(fnd_file.log,'Import_tax_attributes error :'||sqlerrm);

4024: EXCEPTION
4025:
4026: WHEN OTHERS THEN
4027:
4028: FND_FILE.put_line(fnd_file.log,'Import_tax_attributes error :'||sqlerrm);
4029: RAISE;
4030:
4031: END Import_tax_attributes;
4032:

Line 4036: FND_FILE.put_line(fnd_file.log,'HZ_CUSTOMER_INT.delete_success_records +');

4032:
4033: PROCEDURE delete_success_records IS
4034: BEGIN
4035:
4036: FND_FILE.put_line(fnd_file.log,'HZ_CUSTOMER_INT.delete_success_records +');
4037:
4038: DELETE FROM ra_customers_interface
4039: WHERE interface_status is NULL;
4040:

Line 4070: FND_FILE.put_line(fnd_file.log,'HZ_CUSTOMER_INT.delete_success_records -');

4066:
4067: UPDATE ra_customer_banks_interface
4068: SET request_id = NULL;
4069:
4070: FND_FILE.put_line(fnd_file.log,'HZ_CUSTOMER_INT.delete_success_records -');
4071:
4072: END delete_success_records;
4073:
4074: -- enh 14181243

Line 4117: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'In upd_non_primary_bank_priority: ');

4113: i_instrument_payment_use_id IDlist;
4114: i_bank_acct_count IDlist;
4115:
4116: begin
4117: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'In upd_non_primary_bank_priority: ');
4118: open get_cust_bank_acct_priority;
4119: fetch get_cust_bank_acct_priority bulk collect into i_ext_pmt_party_id, i_max_order_of_preference, i_bank_acct_count;
4120: close get_cust_bank_acct_priority;
4121:

Line 4123: -- FND_FILE.PUT_LINE( FND_FILE.LOG,'i_ext_pmt_party_id'||i||':'||i_ext_pmt_party_id(i));

4119: fetch get_cust_bank_acct_priority bulk collect into i_ext_pmt_party_id, i_max_order_of_preference, i_bank_acct_count;
4120: close get_cust_bank_acct_priority;
4121:
4122: for i in 1..i_ext_pmt_party_id.count loop
4123: -- FND_FILE.PUT_LINE( FND_FILE.LOG,'i_ext_pmt_party_id'||i||':'||i_ext_pmt_party_id(i));
4124: -- FND_FILE.PUT_LINE( FND_FILE.LOG,'i_max_order_of_preference'||i||':'||i_max_order_of_preference(i));
4125: open get_modifying_priorities(i_ext_pmt_party_id(i));
4126: fetch get_modifying_priorities bulk collect into i_instrument_payment_use_id;
4127: close get_modifying_priorities;

Line 4124: -- FND_FILE.PUT_LINE( FND_FILE.LOG,'i_max_order_of_preference'||i||':'||i_max_order_of_preference(i));

4120: close get_cust_bank_acct_priority;
4121:
4122: for i in 1..i_ext_pmt_party_id.count loop
4123: -- FND_FILE.PUT_LINE( FND_FILE.LOG,'i_ext_pmt_party_id'||i||':'||i_ext_pmt_party_id(i));
4124: -- FND_FILE.PUT_LINE( FND_FILE.LOG,'i_max_order_of_preference'||i||':'||i_max_order_of_preference(i));
4125: open get_modifying_priorities(i_ext_pmt_party_id(i));
4126: fetch get_modifying_priorities bulk collect into i_instrument_payment_use_id;
4127: close get_modifying_priorities;
4128: