APPS.IGS_PE_NONIMG_FORM_PKG dependencies on IGS_SC_GEN_001

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

618: x_sevis_school_id => x_sevis_school_id
619: );
620:
621: IF (x_mode = 'S') THEN
622: igs_sc_gen_001.set_ctx('R');
623: END IF;
624: INSERT INTO igs_pe_nonimg_form (
625: nonimg_form_id,
626: person_id,

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

718: new_references.adjudicated_flag,
719: new_references.SEVIS_SCHOOL_IDENTIFIER
720: ) RETURNING ROWID, nonimg_form_id INTO x_rowid, x_nonimg_form_id;
721: IF (x_mode = 'S') THEN
722: igs_sc_gen_001.unset_ctx('R');
723: END IF;
724:
725:
726: afterrowinsertupdate(TRUE,FALSE);

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

731: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
732: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
733: fnd_message.set_token ('ERR_CD', SQLCODE);
734: igs_ge_msg_stack.add;
735: igs_sc_gen_001.unset_ctx('R');
736: app_exception.raise_exception;
737: ELSE
738: igs_sc_gen_001.unset_ctx('R');
739: RAISE;

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

734: igs_ge_msg_stack.add;
735: igs_sc_gen_001.unset_ctx('R');
736: app_exception.raise_exception;
737: ELSE
738: igs_sc_gen_001.unset_ctx('R');
739: RAISE;
740: END IF;
741: END insert_row;
742:

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

1044: x_sevis_school_id => x_sevis_school_id
1045: );
1046:
1047: IF (x_mode = 'S') THEN
1048: igs_sc_gen_001.set_ctx('R');
1049: END IF;
1050: UPDATE igs_pe_nonimg_form
1051: SET
1052: person_id = new_references.person_id,

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

1097:
1098: IF (SQL%NOTFOUND) THEN
1099: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1100: igs_ge_msg_stack.add;
1101: igs_sc_gen_001.unset_ctx('R');
1102: app_exception.raise_exception;
1103: END IF;
1104: IF (x_mode = 'S') THEN
1105: igs_sc_gen_001.unset_ctx('R');

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

1101: igs_sc_gen_001.unset_ctx('R');
1102: app_exception.raise_exception;
1103: END IF;
1104: IF (x_mode = 'S') THEN
1105: igs_sc_gen_001.unset_ctx('R');
1106: END IF;
1107:
1108:
1109: afterrowinsertupdate(FALSE,TRUE);

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

1114: IF (SQLCODE = (-28115)) THEN
1115: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1116: fnd_message.set_token ('ERR_CD', SQLCODE);
1117: igs_ge_msg_stack.add;
1118: igs_sc_gen_001.unset_ctx('R');
1119: app_exception.raise_exception;
1120: ELSE
1121: igs_sc_gen_001.unset_ctx('R');
1122: RAISE;

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

1117: igs_ge_msg_stack.add;
1118: igs_sc_gen_001.unset_ctx('R');
1119: app_exception.raise_exception;
1120: ELSE
1121: igs_sc_gen_001.unset_ctx('R');
1122: RAISE;
1123: END IF;
1124: END update_row;
1125:

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

1311: x_rowid => x_rowid
1312: );
1313:
1314: IF (x_mode = 'S') THEN
1315: igs_sc_gen_001.set_ctx('R');
1316: END IF;
1317: DELETE FROM igs_pe_nonimg_form
1318: WHERE rowid = x_rowid;
1319:

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

1319:
1320: IF (SQL%NOTFOUND) THEN
1321: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1322: igs_ge_msg_stack.add;
1323: igs_sc_gen_001.unset_ctx('R');
1324: app_exception.raise_exception;
1325: END IF;
1326: IF (x_mode = 'S') THEN
1327: igs_sc_gen_001.unset_ctx('R');

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

1323: igs_sc_gen_001.unset_ctx('R');
1324: app_exception.raise_exception;
1325: END IF;
1326: IF (x_mode = 'S') THEN
1327: igs_sc_gen_001.unset_ctx('R');
1328: END IF;
1329:
1330:
1331: del_per_inst ;