DBA Data[Home] [Help]

APPS.IGS_EN_NSC_PKG dependencies on FND_API

Line 559: RAISE FND_API.G_EXC_ERROR;

555: END IF;
556: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_NSC_NO_STUDENTS');
557: FND_MSG_PUB.Add;
558: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
559: RAISE FND_API.G_EXC_ERROR;
560: END IF;
561: l_student_data.student_id:=NULL;
562:
563: --Loop through the list of courses satisfying the program attempt validations

Line 788: RAISE FND_API.G_EXC_ERROR;

784:
785: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_NSC_NO_STUDENTS');
786: --FND_MSG_PUB.Add;
787: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
788: RAISE FND_API.G_EXC_ERROR;
789:
790: END IF;
791:
792: -- Create trailer record

Line 860: RAISE FND_API.G_EXC_ERROR;

856: ELSE
857: IF (g_debug_mode) THEN
858: Put_Debug_Msg('Error during request submition');
859: END IF;
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862:
863: COMMIT;
864: RETURN TRUE;

Line 867: WHEN FND_API.G_EXC_ERROR THEN

863: COMMIT;
864: RETURN TRUE;
865:
866: EXCEPTION
867: WHEN FND_API.G_EXC_ERROR THEN
868: ROLLBACK TO Print_Snapshot;
869: Put_Debug_Msg('G_EXC_ERROR'||sqlerrm);
870: RETURN FALSE;
871:

Line 872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

868: ROLLBACK TO Print_Snapshot;
869: Put_Debug_Msg('G_EXC_ERROR'||sqlerrm);
870: RETURN FALSE;
871:
872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
873: ROLLBACK TO Print_Snapshot;
874: Put_Debug_Msg('UNEXPECTED_ERROR'||sqlerrm);
875: RETURN FALSE;
876:

Line 908: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE

904: p_comment IN VARCHAR2, -- Runtime comments
905: p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Snapshot Id to create a file
906: p_dirpath IN VARCHAR2 , -- Output directory name
907: p_file_name IN VARCHAR2 , -- Output file name
908: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
909: )
910: IS
911:
912: l_api_name CONSTANT VARCHAR2(30) := 'Print_Snapshot_Request';

Line 938: IF (l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN

934:
935:
936: -- Checking the status
937:
938: IF (l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN
939: fnd_file.put_line(FND_FILE.LOG,'File Successfully Printed ');
940: --Successfull completion
941: retcode := 0;
942: ELSE

Line 983: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE

979: p_non_std_rpt_typ IN VARCHAR2, -- Non Standard report type like 'GRADUATE'
980: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
981: p_dirpath IN VARCHAR2, -- Output directory name
982: p_file_name IN VARCHAR2, -- Output file name
983: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
984: )IS
985: l_api_name CONSTANT VARCHAR2(30) := 'Create_Snapshot_Request';
986: l_return_status VARCHAR2(1);
987: l_msg_count NUMBER;

Line 1051: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE

1047: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
1048: retcode OUT NOCOPY NUMBER , -- Request standard return status
1049: p_comment IN VARCHAR2, -- Runtime comments
1050: p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE , -- Snapshot Id to delete
1051: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
1052: )IS
1053: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Snapshot_Request';
1054: l_return_status CONSTANT VARCHAR2(1) := 'S';
1055: l_msg_count NUMBER;

Line 1078: IF (l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN

1074: x_rowid => l_rowid
1075: );
1076:
1077: -- Checking the status
1078: IF (l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN
1079: --Successfull completion
1080: fnd_file.put_line(FND_FILE.LOG,'File deleted successfully.');
1081: retcode := 0;
1082: ELSE

Line 1116: l_msg_data := FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

1112:
1113: IF (l_msg_count > 0) THEN
1114: l_msg_data := '';
1115: FOR l_cur IN 1..l_msg_count LOOP
1116: l_msg_data := FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
1117: put_debug_msg(l_msg_data);
1118: fnd_file.put_line (FND_FILE.LOG, l_msg_data);
1119: END LOOP;
1120: ELSE

Line 1137: RAISE FND_API.G_EXC_ERROR;

1133: BEGIN
1134:
1135: IF substr(p_code,1,1) <> 'S' THEN
1136: Put_Debug_Msg('Error during EDS insertion: '||p_code);
1137: RAISE FND_API.G_EXC_ERROR;
1138: END IF;
1139:
1140: END Check_Result;
1141:

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

1167: x_doc_inst_name => 'NSCL Interface instance' ,
1168: x_doc_inst_params => l_doc_inst_params
1169: );
1170:
1171: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1172: RAISE FND_API.G_EXC_ERROR;
1173: END IF;
1174:
1175: x_snapshot_id := l_inst_id;

Line 1172: RAISE FND_API.G_EXC_ERROR;

1168: x_doc_inst_params => l_doc_inst_params
1169: );
1170:
1171: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1172: RAISE FND_API.G_EXC_ERROR;
1173: END IF;
1174:
1175: x_snapshot_id := l_inst_id;
1176:

Line 1660: RAISE FND_API.G_EXC_ERROR;

1656: end if;
1657:
1658: IF length(p_student_data.state) > 2 then
1659: Put_Debug_Msg('State is too long. Please change to 2 character state code and rerun the report');
1660: RAISE FND_API.G_EXC_ERROR;
1661: end if;
1662:
1663:
1664: END IF;