APPS.IGS_PE_EV_FORM_PKG dependencies on IGS_SC_GEN_001

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

589: x_sevis_school_id => x_sevis_school_id
590: );
591:
592: IF (x_mode = 'S') THEN
593: igs_sc_gen_001.set_ctx('R');
594: END IF;
595: INSERT INTO igs_pe_ev_form (
596: ev_form_id,
597: person_id,

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

687: new_references.other_govt_name,
688: new_references.SEVIS_SCHOOL_IDENTIFIER
689: ) RETURNING ROWID, ev_form_id INTO x_rowid, x_ev_form_id;
690: IF (x_mode = 'S') THEN
691: igs_sc_gen_001.unset_ctx('R');
692: END IF;
693:
694:
695: afterrowinsertupdatedel(TRUE,FALSE,FALSE);

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

700: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
701: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
702: fnd_message.set_token ('ERR_CD', SQLCODE);
703: igs_ge_msg_stack.add;
704: igs_sc_gen_001.unset_ctx('R');
705: app_exception.raise_exception;
706: ELSE
707: igs_sc_gen_001.unset_ctx('R');
708: RAISE;

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

703: igs_ge_msg_stack.add;
704: igs_sc_gen_001.unset_ctx('R');
705: app_exception.raise_exception;
706: ELSE
707: igs_sc_gen_001.unset_ctx('R');
708: RAISE;
709: END IF;
710: END insert_row;
711:

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

1008: x_sevis_school_id => x_sevis_school_id
1009: );
1010:
1011: IF (x_mode = 'S') THEN
1012: igs_sc_gen_001.set_ctx('R');
1013: END IF;
1014: UPDATE igs_pe_ev_form
1015: SET
1016: person_id = new_references.person_id,

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

1060:
1061: IF (SQL%NOTFOUND) THEN
1062: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1063: igs_ge_msg_stack.add;
1064: igs_sc_gen_001.unset_ctx('R');
1065: app_exception.raise_exception;
1066: END IF;
1067: IF (x_mode = 'S') THEN
1068: igs_sc_gen_001.unset_ctx('R');

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

1064: igs_sc_gen_001.unset_ctx('R');
1065: app_exception.raise_exception;
1066: END IF;
1067: IF (x_mode = 'S') THEN
1068: igs_sc_gen_001.unset_ctx('R');
1069: END IF;
1070:
1071:
1072: afterrowinsertupdatedel(FALSE,TRUE,FALSE);

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

1077: IF (SQLCODE = (-28115)) THEN
1078: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1079: fnd_message.set_token ('ERR_CD', SQLCODE);
1080: igs_ge_msg_stack.add;
1081: igs_sc_gen_001.unset_ctx('R');
1082: app_exception.raise_exception;
1083: ELSE
1084: igs_sc_gen_001.unset_ctx('R');
1085: RAISE;

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

1080: igs_ge_msg_stack.add;
1081: igs_sc_gen_001.unset_ctx('R');
1082: app_exception.raise_exception;
1083: ELSE
1084: igs_sc_gen_001.unset_ctx('R');
1085: RAISE;
1086: END IF;
1087: END update_row;
1088:

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

1271: x_rowid => x_rowid
1272: );
1273:
1274: IF (x_mode = 'S') THEN
1275: igs_sc_gen_001.set_ctx('R');
1276: END IF;
1277: DELETE FROM igs_pe_ev_form
1278: WHERE rowid = x_rowid;
1279:

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

1279:
1280: IF (SQL%NOTFOUND) THEN
1281: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1282: igs_ge_msg_stack.add;
1283: igs_sc_gen_001.unset_ctx('R');
1284: app_exception.raise_exception;
1285: END IF;
1286: IF (x_mode = 'S') THEN
1287: igs_sc_gen_001.unset_ctx('R');

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

1283: igs_sc_gen_001.unset_ctx('R');
1284: app_exception.raise_exception;
1285: END IF;
1286: IF (x_mode = 'S') THEN
1287: igs_sc_gen_001.unset_ctx('R');
1288: END IF;
1289:
1290:
1291: afterrowinsertupdatedel(FALSE,FALSE,TRUE);