APPS.IGS_AS_SUA_SES_ATTS_PKG dependencies on IGS_SC_GEN_001

Line 289: igs_sc_gen_001.set_ctx('R');

285: x_last_update_login => x_last_update_login
286: );
287:
288: IF (x_mode = 'S') THEN
289: igs_sc_gen_001.set_ctx('R');
290: END IF;
291: INSERT INTO igs_as_sua_ses_atts (
292: person_id,
293: course_cd,

Line 315: igs_sc_gen_001.unset_ctx('R');

311: x_last_updated_by,
312: x_last_update_login
313: ) RETURNING ROWID INTO x_rowid;
314: IF (x_mode = 'S') THEN
315: igs_sc_gen_001.unset_ctx('R');
316: END IF;
317:
318:
319: -- Initialize API return status to success.

Line 330: igs_sc_gen_001.unset_ctx('R');

326: p_data => X_MSG_DATA);
327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: igs_sc_gen_001.unset_ctx('R');
331: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
332: FND_MSG_PUB.Count_And_Get(
333: p_encoded => FND_API.G_FALSE,
334: p_count => x_MSG_COUNT,

Line 338: igs_sc_gen_001.unset_ctx('R');

334: p_count => x_MSG_COUNT,
335: p_data => X_MSG_DATA);
336: RETURN;
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: igs_sc_gen_001.unset_ctx('R');
339: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_MSG_PUB.Count_And_Get(
341: p_encoded => FND_API.G_FALSE,
342: p_count => x_MSG_COUNT,

Line 346: igs_sc_gen_001.unset_ctx('R');

342: p_count => x_MSG_COUNT,
343: p_data => X_MSG_DATA);
344: RETURN;
345: WHEN OTHERS THEN
346: igs_sc_gen_001.unset_ctx('R');
347: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
348: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
349: fnd_message.set_token ('ERR_CD', SQLCODE);
350: FND_MSG_PUB.ADD;

Line 525: igs_sc_gen_001.set_ctx('R');

521: x_last_update_login => x_last_update_login
522: );
523:
524: IF (x_mode = 'S') THEN
525: igs_sc_gen_001.set_ctx('R');
526: END IF;
527: UPDATE igs_as_sua_ses_atts
528: SET
529: attendance_flag = new_references.attendance_flag,

Line 538: igs_sc_gen_001.unset_ctx('R');

534:
535: IF (SQL%NOTFOUND) THEN
536: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
537: igs_ge_msg_stack.add;
538: igs_sc_gen_001.unset_ctx('R');
539: app_exception.raise_exception;
540: END IF;
541: IF (x_mode = 'S') THEN
542: igs_sc_gen_001.unset_ctx('R');

Line 542: igs_sc_gen_001.unset_ctx('R');

538: igs_sc_gen_001.unset_ctx('R');
539: app_exception.raise_exception;
540: END IF;
541: IF (x_mode = 'S') THEN
542: igs_sc_gen_001.unset_ctx('R');
543: END IF;
544:
545:
546: -- Initialize API return status to success.

Line 571: igs_sc_gen_001.unset_ctx('R');

567: p_count => x_MSG_COUNT,
568: p_data => X_MSG_DATA);
569: RETURN;
570: WHEN OTHERS THEN
571: igs_sc_gen_001.unset_ctx('R');
572: IF (SQLCODE = (-28115)) THEN
573: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
574: fnd_message.set_token ('ERR_CD', SQLCODE);
575: FND_MSG_PUB.ADD;

Line 725: igs_sc_gen_001.set_ctx('R');

721: x_rowid => x_rowid
722: );
723:
724: IF (x_mode = 'S') THEN
725: igs_sc_gen_001.set_ctx('R');
726: END IF;
727: DELETE FROM igs_as_sua_ses_atts
728: WHERE rowid = x_rowid;
729:

Line 733: igs_sc_gen_001.unset_ctx('R');

729:
730: IF (SQL%NOTFOUND) THEN
731: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
732: igs_ge_msg_stack.add;
733: igs_sc_gen_001.unset_ctx('R');
734: app_exception.raise_exception;
735: END IF;
736: IF (x_mode = 'S') THEN
737: igs_sc_gen_001.unset_ctx('R');

Line 737: igs_sc_gen_001.unset_ctx('R');

733: igs_sc_gen_001.unset_ctx('R');
734: app_exception.raise_exception;
735: END IF;
736: IF (x_mode = 'S') THEN
737: igs_sc_gen_001.unset_ctx('R');
738: END IF;
739:
740:
741: -- Initialize API return status to success.