DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on ZX_PTP_IMPORT

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 3710: ZX_PTP_IMPORT.IMPORT_WRAPPER(p_request_id => p_request_id

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
3713: , p_validate_only => FND_API.G_TRUE
3714: , p_sql_select_insert_ptp_intf => l_sql_select_insert_ptp_intf

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 3888: ZX_PTP_IMPORT.IMPORT_WRAPPER(p_request_id => l_request_id

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
3891: , p_validate_only => FND_API.G_FALSE
3892: , p_sql_select_insert_ptp_intf => NULL

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 3935: ZX_PTP_IMPORT.MESSAGE_WRAPPER(p_request_id => l_request_id

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
3938: ,p_display_messages => FND_API.G_FALSE
3939: ,p_message_header_string_1 => NULL

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 3973: ZX_PTP_IMPORT.MESSAGE_WRAPPER(p_request_id => l_request_id

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'
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

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 4012: ZX_PTP_IMPORT.delete_success_records(p_request_id => l_request_id

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
4015: ,x_msg_data => x_msg_data);
4016:

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: