DBA Data[Home] [Help]

APPS.AMS_IMP_REG_DETAIL_PVT dependencies on AMS_UTILITY_PVT

Line 255: Ams_Utility_PVT.Create_Log (

251: END IF;
252: END IF;
253: IF (l_notfound = 0)
254: THEN
255: Ams_Utility_PVT.Create_Log (
256: x_return_status => l_return_status_log,
257: p_arc_log_used_by => l_used_by,
258: p_log_used_by_id => l_hdr_id,
259: p_msg_data => 'Start of import Event registrations Record'

Line 261: Ams_Utility_PVT.Create_Log (

257: p_arc_log_used_by => l_used_by,
258: p_log_used_by_id => l_hdr_id,
259: p_msg_data => 'Start of import Event registrations Record'
260: );
261: Ams_Utility_PVT.Create_Log (
262: x_return_status => l_return_status_log,
263: p_arc_log_used_by => l_used_by,
264: p_log_used_by_id => l_hdr_id,
265: p_msg_data => 'Concurrent Program started the Id is ' || to_char(l_request_id)

Line 284: Ams_Utility_PVT.Create_Log (

280: fetch c_get_lines into l_imp_rec;
281: IF c_get_lines%NOTFOUND THEN
282: CLOSE c_get_lines;
283: --FND_FILE.PUT_LINE(FND_FILE.LOG,'No Line RECORD TO Process at this time');
284: Ams_Utility_PVT.Create_Log (
285: x_return_status => l_return_status_log,
286: p_arc_log_used_by => l_used_by,
287: p_log_used_by_id => l_hdr_id,
288: p_msg_data => 'No Line RECORD TO Process at this time'

Line 295: Ams_Utility_PVT.Create_Log( x_return_status => l_return_status_log

291: ELSE
292: LOOP
293: exit WHEN c_get_lines%NOTFOUND;
294: --DBMS_OUTPUT.put_line('In side second loop'||l_cnt1||' ' ||l_cnt2);
295: Ams_Utility_PVT.Create_Log( x_return_status => l_return_status_log
296: , p_arc_log_used_by => l_used_by
297: , p_log_used_by_id => l_hdr_id
298: , p_msg_data => '----Processing the record whose source Line Id is '
299: || to_char(l_imp_rec.import_source_line_id) || '----'

Line 553: , p_owner_user_id => ams_utility_pvt.get_resource_id(FND_GLOBAL.user_id)

549: , x_msg_data => l_msg_data
550: , p_reg_det_rec => l_reg_rec
551: -- soagrawa 30-jan-2003 bug# 2769511
552: -- , p_owner_user_id => -1 -- what do we do with this?
553: , p_owner_user_id => ams_utility_pvt.get_resource_id(FND_GLOBAL.user_id)
554: , p_application_id => 530
555: , x_confirm_code => l_conf_code
556: );
557: l_processed_rows := l_processed_rows+1;

Line 619: Ams_Utility_PVT.Create_Log (

615: fetch c_get_lines into l_imp_rec;
616: IF c_get_lines%NOTFOUND THEN
617: CLOSE c_get_lines;
618: --FND_FILE.PUT_LINE(FND_FILE.LOG,'No Line RECORD TO Process at this time');
619: Ams_Utility_PVT.Create_Log (
620: x_return_status => l_return_status_log,
621: p_arc_log_used_by => l_used_by,
622: p_log_used_by_id => p_list_header_id,
623: p_msg_data => 'No Line RECORD TO Process at this time'

Line 630: Ams_Utility_PVT.Create_Log( x_return_status => l_return_status_log

626: ELSE
627: LOOP
628: exit WHEN c_get_lines%NOTFOUND;
629: --DBMS_OUTPUT.put_line('In side second loop'||l_cnt1||' ' ||l_cnt2);
630: Ams_Utility_PVT.Create_Log( x_return_status => l_return_status_log
631: , p_arc_log_used_by => l_used_by
632: , p_log_used_by_id => p_list_header_id
633: , p_msg_data => '----Processing the record whose source Line Id is '
634: || to_char(l_imp_rec.import_source_line_id) || '----'

Line 887: , p_owner_user_id => ams_utility_pvt.get_resource_id(FND_GLOBAL.user_id)

883: , x_msg_data => l_msg_data
884: , p_reg_det_rec => l_reg_rec
885: -- soagrawa 30-jan-2003 bug# 2769511
886: -- , p_owner_user_id => -1 -- what do we do with this?
887: , p_owner_user_id => ams_utility_pvt.get_resource_id(FND_GLOBAL.user_id)
888: , p_application_id => 530
889: , x_confirm_code => l_conf_code
890: );
891: l_processed_rows := l_processed_rows+1;

Line 970: Ams_Utility_PVT.Create_Log (

966: --DBMS_OUTPUT.put_line('Inside update_imp_src_line_rec' || p_return_status || ' ' || p_imp_src_id );
967: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
968: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Record proceesed sucessfully = ' || p_imp_src_id );
969: l_msg_data := 'Record proceesed sucessfully ';
970: Ams_Utility_PVT.Create_Log (
971: x_return_status => l_return_status_log,
972: p_arc_log_used_by => l_used_by,
973: p_log_used_by_id => p_imp_hdr_id,
974: p_msg_data => l_msg_data

Line 986: Ams_Utility_PVT.Create_Log (

982: -- instead of stack and then send it to error_capture process.
983: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Record Not proceesed = ' || p_imp_src_id );
984: /*
985: l_msg_data := 'Processing failed for the record whose sourceline Id is ' || p_imp_src_id || '. Check the log table for detail error message';
986: Ams_Utility_PVT.Create_Log (
987: x_return_status => l_return_status_log,
988: p_arc_log_used_by => l_used_by,
989: p_log_used_by_id => p_imp_hdr_id,
990: p_msg_data => l_msg_data

Line 1020: Ams_Utility_PVT.Create_Log (

1016: , p_field_name => null
1017: , p_error_text => l_msg_data
1018: ); */
1019: /*
1020: Ams_Utility_PVT.Create_Log (
1021: x_return_status => l_return_status_log,
1022: p_arc_log_used_by => l_used_by,
1023: p_log_used_by_id => p_imp_hdr_id,
1024: p_msg_data => l_msg_data

Line 1069: Ams_Utility_PVT.Create_Log (

1065: IS
1066: l_return_status VARCHAR2(1);
1067: BEGIN
1068: --FND_FILE.PUT_LINE(FND_FILE.LOG,'No RECORD TO Processed = ' || p_processed_rows );
1069: Ams_Utility_PVT.Create_Log (
1070: x_return_status => l_return_status,
1071: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1072: p_log_used_by_id => p_imp_hdr_id,
1073: p_msg_data => '----No RECORD TO Processed = ' || p_processed_rows

Line 1077: Ams_Utility_PVT.Create_Log (

1073: p_msg_data => '----No RECORD TO Processed = ' || p_processed_rows
1074: );
1075: IF (p_failed_rows > 0) THEN
1076: --FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Failed Records' || p_failed_rows || '----');
1077: Ams_Utility_PVT.Create_Log (
1078: x_return_status => l_return_status,
1079: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1080: p_log_used_by_id => p_imp_hdr_id,
1081: p_msg_data => 'No of Failed Records' || p_failed_rows