APPS.IGS_UC_APP_CHOICES_PKG dependencies on IGS_SC_GEN_001

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

862: x_ucas_cycle => x_ucas_cycle
863: );
864:
865: IF (x_mode = 'S') THEN
866: igs_sc_gen_001.set_ctx('R');
867: END IF;
868: INSERT INTO igs_uc_app_choices (
869: app_choice_id,
870: app_id,

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

993: -- smaddali added new column for ucfd203 - bug#2669208
994: new_references.ucas_cycle
995: );
996: IF (x_mode = 'S') THEN
997: igs_sc_gen_001.unset_ctx('R');
998: END IF;
999:
1000:
1001: OPEN c;

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

1012: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1013: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1014: fnd_message.set_token ('ERR_CD', SQLCODE);
1015: igs_ge_msg_stack.add;
1016: igs_sc_gen_001.unset_ctx('R');
1017: app_exception.raise_exception;
1018: ELSE
1019: igs_sc_gen_001.unset_ctx('R');
1020: RAISE;

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

1015: igs_ge_msg_stack.add;
1016: igs_sc_gen_001.unset_ctx('R');
1017: app_exception.raise_exception;
1018: ELSE
1019: igs_sc_gen_001.unset_ctx('R');
1020: RAISE;
1021: END IF;
1022: END insert_row;
1023:

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

1407: x_ucas_cycle => x_ucas_cycle
1408: );
1409:
1410: IF (x_mode = 'S') THEN
1411: igs_sc_gen_001.set_ctx('R');
1412: END IF;
1413: UPDATE igs_uc_app_choices
1414: SET
1415: app_id = new_references.app_id,

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

1476:
1477: IF (SQL%NOTFOUND) THEN
1478: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1479: igs_ge_msg_stack.add;
1480: igs_sc_gen_001.unset_ctx('R');
1481: app_exception.raise_exception;
1482: END IF;
1483: IF (x_mode = 'S') THEN
1484: igs_sc_gen_001.unset_ctx('R');

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

1480: igs_sc_gen_001.unset_ctx('R');
1481: app_exception.raise_exception;
1482: END IF;
1483: IF (x_mode = 'S') THEN
1484: igs_sc_gen_001.unset_ctx('R');
1485: END IF;
1486:
1487: EXCEPTION
1488: WHEN OTHERS THEN

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

1489: IF (SQLCODE = (-28115)) THEN
1490: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1491: fnd_message.set_token ('ERR_CD', SQLCODE);
1492: igs_ge_msg_stack.add;
1493: igs_sc_gen_001.unset_ctx('R');
1494: app_exception.raise_exception;
1495: ELSE
1496: igs_sc_gen_001.unset_ctx('R');
1497: RAISE;

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

1492: igs_ge_msg_stack.add;
1493: igs_sc_gen_001.unset_ctx('R');
1494: app_exception.raise_exception;
1495: ELSE
1496: igs_sc_gen_001.unset_ctx('R');
1497: RAISE;
1498: END IF;
1499:
1500: END update_row;

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

1735: x_rowid => x_rowid
1736: );
1737:
1738: IF (x_mode = 'S') THEN
1739: igs_sc_gen_001.set_ctx('R');
1740: END IF;
1741: DELETE FROM igs_uc_app_choices
1742: WHERE rowid = x_rowid;
1743:

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

1743:
1744: IF (SQL%NOTFOUND) THEN
1745: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1746: igs_ge_msg_stack.add;
1747: igs_sc_gen_001.unset_ctx('R');
1748: app_exception.raise_exception;
1749: END IF;
1750: IF (x_mode = 'S') THEN
1751: igs_sc_gen_001.unset_ctx('R');

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

1747: igs_sc_gen_001.unset_ctx('R');
1748: app_exception.raise_exception;
1749: END IF;
1750: IF (x_mode = 'S') THEN
1751: igs_sc_gen_001.unset_ctx('R');
1752: END IF;
1753:
1754:
1755: END delete_row;