DBA Data[Home] [Help]

APPS.AMS_IMP_REG_DETAIL_PVT dependencies on FND_API

Line 545: , p_init_msg_list => FND_API.G_FALSE

541: END IF;
542: END IF;
543:
544: AMS_Registrants_PUB.Register( p_api_version_number => 1.0
545: , p_init_msg_list => FND_API.G_FALSE
546: , p_commit => FND_API.G_FALSE
547: , x_return_status => l_return_status
548: , x_msg_count => l_msg_count
549: , x_msg_data => l_msg_data

Line 546: , p_commit => FND_API.G_FALSE

542: END IF;
543:
544: AMS_Registrants_PUB.Register( p_api_version_number => 1.0
545: , p_init_msg_list => FND_API.G_FALSE
546: , p_commit => FND_API.G_FALSE
547: , x_return_status => l_return_status
548: , x_msg_count => l_msg_count
549: , x_msg_data => l_msg_data
550: , p_reg_det_rec => l_reg_rec

Line 558: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

554: , p_application_id => 530
555: , x_confirm_code => l_conf_code
556: );
557: l_processed_rows := l_processed_rows+1;
558: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
559: l_failed_rows := l_failed_rows+1;
560: END IF;
561:
562: -- BEGIN

Line 571: IF (l_out_status = FND_API.G_RET_STS_ERROR) THEN

567: , p_msg_count => l_msg_count -- Added by ptendulk on 21-Dec-2002
568: , p_out_status => l_out_status
569: );
570: -- soagrawa added out status on 03-feb-2003 for error threshold
571: IF (l_out_status = FND_API.G_RET_STS_ERROR) THEN
572: RETURN;
573: END IF;
574: -- EXCEPTION
575: -- WHEN error_threshold_exc THEN

Line 879: , p_init_msg_list => FND_API.G_FALSE

875: END IF;
876: END IF;
877:
878: AMS_Registrants_PUB.Register( p_api_version_number => 1.0
879: , p_init_msg_list => FND_API.G_FALSE
880: , p_commit => FND_API.G_FALSE
881: , x_return_status => l_return_status
882: , x_msg_count => l_msg_count
883: , x_msg_data => l_msg_data

Line 880: , p_commit => FND_API.G_FALSE

876: END IF;
877:
878: AMS_Registrants_PUB.Register( p_api_version_number => 1.0
879: , p_init_msg_list => FND_API.G_FALSE
880: , p_commit => FND_API.G_FALSE
881: , x_return_status => l_return_status
882: , x_msg_count => l_msg_count
883: , x_msg_data => l_msg_data
884: , p_reg_det_rec => l_reg_rec

Line 892: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

888: , p_application_id => 530
889: , x_confirm_code => l_conf_code
890: );
891: l_processed_rows := l_processed_rows+1;
892: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
893: l_failed_rows := l_failed_rows+1;
894: END IF;
895:
896:

Line 906: IF (l_out_status = FND_API.G_RET_STS_ERROR) THEN

902: , p_msg_count => l_msg_count -- Added by ptendulk on 21-Dec-2002
903: , p_out_status => l_out_status
904: );
905: -- soagrawa added out status on 03-feb-2003 for error threshold
906: IF (l_out_status = FND_API.G_RET_STS_ERROR) THEN
907: RETURN;
908: END IF;
909:
910: -- EXCEPTION

Line 964: p_out_status := FND_API.g_ret_sts_success;

960: l_msg_data_ec varchar2(2000);
961: l_tmp_var VARCHAR2(2000);
962: -- error_threshold_exc exception;
963: BEGIN
964: p_out_status := FND_API.g_ret_sts_success;
965: l_used_by := 'IMPH'; --'EVENT_REG_IMPORT';
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 );

Line 967: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

963: BEGIN
964: p_out_status := FND_API.g_ret_sts_success;
965: l_used_by := 'IMPH'; --'EVENT_REG_IMPORT';
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,

Line 1007: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);

1003: );
1004: --FND_FILE.PUT_LINE(FND_FILE.LOG,'check the log table for detail error message ');
1005: l_msg_count := FND_MSG_PUB.count_msg;
1006: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
1007: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
1008: AMS_List_Import_PUB.error_capture( p_api_version => 1.0
1009: , x_return_status => l_return_status_ec
1010: , x_msg_count => l_msg_count_ec
1011: , x_msg_data => l_msg_data_ec

Line 1033: l_tmp_var := fnd_msg_pub.get(i, p_encoded => fnd_api.g_false);

1029:
1030:
1031: FOR i IN 1..p_msg_count LOOP
1032: -- soagrawa 17-feb-2003 now passing index to fnd msg pub get for bug# 2769511
1033: l_tmp_var := fnd_msg_pub.get(i, p_encoded => fnd_api.g_false);
1034: l_msg_data := SUBSTR((l_msg_data || (i ||'. ')|| l_tmp_var),1,2000);
1035: END LOOP;
1036: AMS_List_Import_PUB.error_capture( p_api_version => 1.0
1037: , x_return_status => l_return_status_ec

Line 1049: IF l_return_status_ec = FND_API.G_RET_STS_ERROR THEN

1045: , p_error_text => l_msg_data
1046: );
1047:
1048: -- soagrawa added out status on 03-feb-2003 for error threshold
1049: IF l_return_status_ec = FND_API.G_RET_STS_ERROR THEN
1050: p_out_status := FND_API.G_RET_STS_ERROR;
1051: END IF;
1052:
1053: UPDATE ams_imp_source_lines

Line 1050: p_out_status := FND_API.G_RET_STS_ERROR;

1046: );
1047:
1048: -- soagrawa added out status on 03-feb-2003 for error threshold
1049: IF l_return_status_ec = FND_API.G_RET_STS_ERROR THEN
1050: p_out_status := FND_API.G_RET_STS_ERROR;
1051: END IF;
1052:
1053: UPDATE ams_imp_source_lines
1054: SET import_successful_flag = 'N',