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.IGS_EN_SPAA_LGCY_PUB dependencies on FND_API

Line 105: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

101: WHERE award_cd = cp_award_cd
102: AND grading_schema_cd = cp_grading_schema_cd
103: AND gs_version_number = cp_gs_version_number;
104:
105: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
106: l_dummy VARCHAR2(1);
107:
108: BEGIN
109:

Line 129: l_ret_status := FND_API.G_RET_STS_ERROR;

125: x_person_id => p_person_id,
126: x_course_cd => p_awd_aim_rec.program_cd ) THEN
127: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_PRGM_ATT_NOT_EXIST');
128: FND_MSG_PUB.ADD;
129: l_ret_status := FND_API.G_RET_STS_ERROR;
130: END IF;
131:
132: -- FK check in the Award Code table
133: IF NOT igs_ps_awd_pkg.get_pk_for_validation (

Line 137: l_ret_status := FND_API.G_RET_STS_ERROR;

133: IF NOT igs_ps_awd_pkg.get_pk_for_validation (
134: x_award_cd => p_awd_aim_rec.award_cd ) THEN
135: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_AWD_NOT_EXIST');
136: FND_MSG_PUB.ADD;
137: l_ret_status := FND_API.G_RET_STS_ERROR;
138: END IF;
139:
140: -- Check if grading schema matches one stored at the award
141: IF p_awd_aim_rec.grading_schema_cd IS NOT NULL AND

Line 151: l_ret_status := FND_API.G_RET_STS_ERROR;

147: FETCH cur_awd_grd_sch INTO l_dummy;
148: IF (cur_awd_grd_sch%NOTFOUND) THEN
149: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWD_GRD_SCH_NO_MTCH');
150: FND_MSG_PUB.ADD;
151: l_ret_status := FND_API.G_RET_STS_ERROR;
152: END IF;
153: END IF;
154:
155: -- Check if award_grade belongs to grading schema

Line 166: l_ret_status := FND_API.G_RET_STS_ERROR;

162: x_grade => p_awd_aim_rec.award_grade )
163: THEN
164: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_GRD_NOT_IN_SCHEMA');
165: FND_MSG_PUB.ADD;
166: l_ret_status := FND_API.G_RET_STS_ERROR;
167: END IF;
168: ELSE
169: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_GRD_NOT_IN_SCHEMA');
170: FND_MSG_PUB.ADD;

Line 171: l_ret_status := FND_API.G_RET_STS_ERROR;

167: END IF;
168: ELSE
169: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_GRD_NOT_IN_SCHEMA');
170: FND_MSG_PUB.ADD;
171: l_ret_status := FND_API.G_RET_STS_ERROR;
172: END IF;
173: END IF;
174:
175: RETURN l_ret_status;

Line 261: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,

257: BEGIN
258: -- Standard Start of API savepoint
259: SAVEPOINT awd_aim_pub;
260: -- Standard call to check for call compatibility.
261: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,
262: p_api_version,
263: l_api_name,
264: g_pkg_name ) THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

261: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,
262: p_api_version,
263: l_api_name,
264: g_pkg_name ) THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: -- Initialize message list if p_init_msg_list is set to TRUE.
269: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

Line 269: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: -- Initialize message list if p_init_msg_list is set to TRUE.
269: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
270: FND_MSG_PUB.INITIALIZE;
271: END IF;
272:
273: -- Initialize API return status to success

Line 274: x_return_status := FND_API.G_RET_STS_SUCCESS;

270: FND_MSG_PUB.INITIALIZE;
271: END IF;
272:
273: -- Initialize API return status to success
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275:
276: /****** Validating all the parameters available ******/
277: l_stdnt_awd_aim_status := validate_parameters ( p_awd_aim_rec => p_awd_aim_rec );
278:

Line 365: x_return_status := FND_API.G_RET_STS_ERROR ;

361: --make it to 'E' and rollback if any transaction has happened and not commited.
362: --If l_stdnt_awd_aim_status is VALID then x_return_status is 'S'.
363: IF l_stdnt_awd_aim_status = 'INVALID' THEN
364: IF x_return_status <> 'W' THEN
365: x_return_status := FND_API.G_RET_STS_ERROR ;
366: END IF;
367: ROLLBACK TO awd_aim_pub;
368: ELSIF l_stdnt_awd_aim_status = 'VALID' THEN
369: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 369: x_return_status := FND_API.G_RET_STS_SUCCESS ;

365: x_return_status := FND_API.G_RET_STS_ERROR ;
366: END IF;
367: ROLLBACK TO awd_aim_pub;
368: ELSIF l_stdnt_awd_aim_status = 'VALID' THEN
369: x_return_status := FND_API.G_RET_STS_SUCCESS ;
370: -- Standard check of p_commit.
371: IF FND_API.TO_BOOLEAN( p_commit ) THEN
372: COMMIT WORK;
373: END IF;

Line 371: IF FND_API.TO_BOOLEAN( p_commit ) THEN

367: ROLLBACK TO awd_aim_pub;
368: ELSIF l_stdnt_awd_aim_status = 'VALID' THEN
369: x_return_status := FND_API.G_RET_STS_SUCCESS ;
370: -- Standard check of p_commit.
371: IF FND_API.TO_BOOLEAN( p_commit ) THEN
372: COMMIT WORK;
373: END IF;
374: END IF;
375:

Line 380: WHEN FND_API.G_EXC_ERROR THEN

376: -- Standard call to get message count and if count is 1, get message info.
377: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
378: p_data => x_msg_data );
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: ROLLBACK TO awd_aim_pub;
382: x_return_status := FND_API.G_RET_STS_ERROR ;
383: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
384: p_data => x_msg_data );

Line 382: x_return_status := FND_API.G_RET_STS_ERROR ;

378: p_data => x_msg_data );
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: ROLLBACK TO awd_aim_pub;
382: x_return_status := FND_API.G_RET_STS_ERROR ;
383: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
384: p_data => x_msg_data );
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: ROLLBACK TO awd_aim_pub;

Line 385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

381: ROLLBACK TO awd_aim_pub;
382: x_return_status := FND_API.G_RET_STS_ERROR ;
383: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
384: p_data => x_msg_data );
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: ROLLBACK TO awd_aim_pub;
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
388: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
389: p_data => x_msg_data );

Line 387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

383: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
384: p_data => x_msg_data );
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: ROLLBACK TO awd_aim_pub;
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
388: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
389: p_data => x_msg_data );
390: WHEN OTHERS THEN
391: ROLLBACK TO awd_aim_pub;

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

388: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
389: p_data => x_msg_data );
390: WHEN OTHERS THEN
391: ROLLBACK TO awd_aim_pub;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
394: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name,
395: l_api_name );
396: END IF;