DBA Data[Home] [Help]

APPS.IGS_DA_UTILS_PKG dependencies on FND_MSG_PUB

Line 186: FND_MSG_PUB.initialize;

182: SELECT feature_code
183: FROM igs_da_req_ftrs rf_in
184: WHERE rf_in.batch_id = dr.batch_id);
185: BEGIN
186: FND_MSG_PUB.initialize;
187: OPEN c_igs_da_rqst (p_batch_id);
188: LOOP
189: FETCH c_igs_da_rqst INTO rec_igs_da_rqst;
190: EXIT WHEN c_igs_da_rqst%NOTFOUND;

Line 221: FND_MSG_PUB.ADD;

217: IF l_is_filename_null = 'N' THEN
218: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
219: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
220: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
221: FND_MSG_PUB.ADD;
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224: OPEN c_stud_grp_mem FOR l_dyn_stud_grp_mem;
225: ELSE

Line 276: FND_MSG_PUB.ADD;

272: IF l_is_filename_null = 'N' THEN
273: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
274: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
275: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
276: FND_MSG_PUB.ADD;
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: OPEN c_stud_grp_mem FOR l_dyn_stud_grp_mem;
280: ELSE

Line 335: FND_MSG_PUB.ADD;

331: IF l_is_filename_null = 'N' THEN
332: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
333: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
334: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
335: FND_MSG_PUB.ADD;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: OPEN c_stud_grp_mem FOR l_dyn_stud_grp_mem;
339: ELSE

Line 416: FND_MSG_PUB.ADD;

412: X_MSG_COUNT => l_msg_count
413: );
414: IF l_return_status <>'S' THEN
415: FND_MESSAGE.SET_NAME('IGS','IGS_DA_CR_PLS_ERROR');
416: FND_MSG_PUB.ADD;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419:
420: END LOOP;

Line 449: FND_MSG_PUB.ADD;

445: igs_da_xml_pkg.Pre_Submit_Event(p_batch_id => p_batch_id);
446: EXCEPTION
447: WHEN OTHERS THEN
448: FND_MESSAGE.SET_NAME('IGS','IGS_DA_XML_ERROR');
449: FND_MSG_PUB.ADD;
450: RAISE FND_API.G_EXC_ERROR;
451: END;
452:
453: -- Initialize API return status to success.

Line 457: FND_MSG_PUB.Count_And_Get(

453: -- Initialize API return status to success.
454: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
455: -- Standard call to get message count and if count is 1, get message
456: -- info.
457: FND_MSG_PUB.Count_And_Get(
458: p_encoded => FND_API.G_TRUE,
459: p_count => x_MSG_COUNT,
460: p_data => X_MSG_DATA);
461:

Line 465: FND_MSG_PUB.Count_And_Get(

461:
462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
465: FND_MSG_PUB.Count_And_Get(
466: p_encoded => FND_API.G_TRUE,
467: p_count => x_MSG_COUNT,
468: p_data => X_MSG_DATA);
469: RETURN;

Line 472: FND_MSG_PUB.Count_And_Get(

468: p_data => X_MSG_DATA);
469: RETURN;
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
472: FND_MSG_PUB.Count_And_Get(
473: p_encoded => FND_API.G_TRUE,
474: p_count => x_MSG_COUNT,
475: p_data => X_MSG_DATA);
476: RETURN;

Line 481: FND_MSG_PUB.ADD;

477: WHEN OTHERS THEN
478: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
480: FND_MESSAGE.SET_TOKEN('NAME','create_req_stdnts_rec : '||SQLERRM);
481: FND_MSG_PUB.ADD;
482: FND_MSG_PUB.Count_And_Get(
483: p_encoded => FND_API.G_TRUE,
484: p_count => x_MSG_COUNT,
485: p_data => X_MSG_DATA);

Line 482: FND_MSG_PUB.Count_And_Get(

478: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
480: FND_MESSAGE.SET_TOKEN('NAME','create_req_stdnts_rec : '||SQLERRM);
481: FND_MSG_PUB.ADD;
482: FND_MSG_PUB.Count_And_Get(
483: p_encoded => FND_API.G_TRUE,
484: p_count => x_MSG_COUNT,
485: p_data => X_MSG_DATA);
486: RETURN;