APPS.IGS_PE_VISA_PKG dependencies on IGS_SC_GEN_001

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

743: x_last_update_login => x_last_update_login
744: );
745:
746: IF (x_mode = 'S') THEN
747: igs_sc_gen_001.set_ctx('R');
748: END IF;
749: INSERT INTO igs_pe_visa (
750: visa_id,
751: person_id,

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

827: x_last_updated_by,
828: x_last_update_login
829: ) RETURNING ROWID, visa_id INTO x_rowid, x_visa_id;
830: IF (x_mode = 'S') THEN
831: igs_sc_gen_001.unset_ctx('R');
832: END IF;
833:
834:
835:

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

844: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
845: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
846: fnd_message.set_token ('ERR_CD', SQLCODE);
847: igs_ge_msg_stack.add;
848: igs_sc_gen_001.unset_ctx('R');
849: app_exception.raise_exception;
850: ELSE
851: igs_sc_gen_001.unset_ctx('R');
852: RAISE;

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

847: igs_ge_msg_stack.add;
848: igs_sc_gen_001.unset_ctx('R');
849: app_exception.raise_exception;
850: ELSE
851: igs_sc_gen_001.unset_ctx('R');
852: RAISE;
853: END IF;
854: END insert_row;
855:

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

1117: x_last_update_login => x_last_update_login
1118: );
1119:
1120: IF (x_mode = 'S') THEN
1121: igs_sc_gen_001.set_ctx('R');
1122: END IF;
1123: UPDATE igs_pe_visa
1124: SET
1125: person_id = new_references.person_id,

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

1162:
1163: IF (SQL%NOTFOUND) THEN
1164: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1165: igs_ge_msg_stack.add;
1166: igs_sc_gen_001.unset_ctx('R');
1167: app_exception.raise_exception;
1168: END IF;
1169: IF (x_mode = 'S') THEN
1170: igs_sc_gen_001.unset_ctx('R');

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

1166: igs_sc_gen_001.unset_ctx('R');
1167: app_exception.raise_exception;
1168: END IF;
1169: IF (x_mode = 'S') THEN
1170: igs_sc_gen_001.unset_ctx('R');
1171: END IF;
1172:
1173:
1174: After_DML(

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

1182: IF (SQLCODE = (-28115)) THEN
1183: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1184: fnd_message.set_token ('ERR_CD', SQLCODE);
1185: igs_ge_msg_stack.add;
1186: igs_sc_gen_001.unset_ctx('R');
1187: app_exception.raise_exception;
1188: ELSE
1189: igs_sc_gen_001.unset_ctx('R');
1190: RAISE;

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

1185: igs_ge_msg_stack.add;
1186: igs_sc_gen_001.unset_ctx('R');
1187: app_exception.raise_exception;
1188: ELSE
1189: igs_sc_gen_001.unset_ctx('R');
1190: RAISE;
1191: END IF;
1192: END update_row;
1193:

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

1355: x_rowid => x_rowid
1356: );
1357:
1358: IF (x_mode = 'S') THEN
1359: igs_sc_gen_001.set_ctx('R');
1360: END IF;
1361: DELETE FROM igs_pe_visa
1362: WHERE rowid = x_rowid;
1363:

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

1363:
1364: IF (SQL%NOTFOUND) THEN
1365: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1366: igs_ge_msg_stack.add;
1367: igs_sc_gen_001.unset_ctx('R');
1368: app_exception.raise_exception;
1369: END IF;
1370: IF (x_mode = 'S') THEN
1371: igs_sc_gen_001.unset_ctx('R');

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

1367: igs_sc_gen_001.unset_ctx('R');
1368: app_exception.raise_exception;
1369: END IF;
1370: IF (x_mode = 'S') THEN
1371: igs_sc_gen_001.unset_ctx('R');
1372: END IF;
1373:
1374:
1375: END delete_row;