APPS.IGS_PR_STDNT_PR_FND_PKG dependencies on IGS_SC_GEN_001

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

357: x_last_update_login => x_last_update_login
358: );
359:
360: IF (x_mode = 'S') THEN
361: igs_sc_gen_001.set_ctx('R');
362: END IF;
363: INSERT INTO igs_pr_stdnt_pr_fnd (
364: person_id,
365: course_cd,

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

381: x_last_updated_by,
382: x_last_update_login
383: ) RETURNING ROWID INTO x_rowid;
384: IF (x_mode = 'S') THEN
385: igs_sc_gen_001.unset_ctx('R');
386: END IF;
387:
388: EXCEPTION
389: WHEN OTHERS THEN

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

389: WHEN OTHERS THEN
390: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
391: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
392: IF (x_mode = 'S') THEN
393: igs_sc_gen_001.unset_ctx('R');
394: END IF;
395:
396: fnd_message.set_token ('ERR_CD', SQLCODE);
397: igs_ge_msg_stack.add;

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

394: END IF;
395:
396: fnd_message.set_token ('ERR_CD', SQLCODE);
397: igs_ge_msg_stack.add;
398: igs_sc_gen_001.unset_ctx('R');
399: app_exception.raise_exception;
400: ELSE
401: igs_sc_gen_001.unset_ctx('R');
402: RAISE;

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

397: igs_ge_msg_stack.add;
398: igs_sc_gen_001.unset_ctx('R');
399: app_exception.raise_exception;
400: ELSE
401: igs_sc_gen_001.unset_ctx('R');
402: RAISE;
403: END IF;
404: END insert_row;
405:

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

468: x_rowid => x_rowid
469: );
470:
471: IF (x_mode = 'S') THEN
472: igs_sc_gen_001.set_ctx('R');
473: END IF;
474: DELETE FROM igs_pr_stdnt_pr_fnd
475: WHERE rowid = x_rowid;
476:

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

476:
477: IF (SQL%NOTFOUND) THEN
478: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
479: igs_ge_msg_stack.add;
480: igs_sc_gen_001.unset_ctx('R');
481: app_exception.raise_exception;
482: END IF;
483: IF (x_mode = 'S') THEN
484: igs_sc_gen_001.unset_ctx('R');

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

480: igs_sc_gen_001.unset_ctx('R');
481: app_exception.raise_exception;
482: END IF;
483: IF (x_mode = 'S') THEN
484: igs_sc_gen_001.unset_ctx('R');
485: END IF;
486:
487:
488: END delete_row;