833: x_plan_sht_status => x_plan_sht_status
834: );
835:
836: IF (x_mode = 'S') THEN
837: igs_sc_gen_001.set_ctx('R');
838: END IF;
839: INSERT INTO igs_en_spa_terms (
840: term_record_id,
841: person_id,
929: x_program_update_date,
930: new_references.plan_sht_status
931: ) RETURNING ROWID, term_record_id INTO x_rowid, x_term_record_id;
932: IF (x_mode = 'S') THEN
933: igs_sc_gen_001.unset_ctx('R');
934: END IF;
935:
936:
937:
940: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
941: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
942: fnd_message.set_token ('ERR_CD', SQLCODE);
943: igs_ge_msg_stack.add;
944: igs_sc_gen_001.unset_ctx('R');
945: app_exception.raise_exception;
946: ELSE
947: igs_sc_gen_001.unset_ctx('R');
948: RAISE;
943: igs_ge_msg_stack.add;
944: igs_sc_gen_001.unset_ctx('R');
945: app_exception.raise_exception;
946: ELSE
947: igs_sc_gen_001.unset_ctx('R');
948: RAISE;
949: END IF;
950: END insert_row;
951:
1242: END IF;
1243: END IF;
1244:
1245: IF (x_mode = 'S') THEN
1246: igs_sc_gen_001.set_ctx('R');
1247: END IF;
1248: UPDATE igs_en_spa_terms
1249: SET
1250: person_id = new_references.person_id,
1293:
1294: IF (SQL%NOTFOUND) THEN
1295: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1296: igs_ge_msg_stack.add;
1297: igs_sc_gen_001.unset_ctx('R');
1298: app_exception.raise_exception;
1299: END IF;
1300: IF (x_mode = 'S') THEN
1301: igs_sc_gen_001.unset_ctx('R');
1297: igs_sc_gen_001.unset_ctx('R');
1298: app_exception.raise_exception;
1299: END IF;
1300: IF (x_mode = 'S') THEN
1301: igs_sc_gen_001.unset_ctx('R');
1302: END IF;
1303:
1304:
1305:
1308: IF (SQLCODE = (-28115)) THEN
1309: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1310: fnd_message.set_token ('ERR_CD', SQLCODE);
1311: igs_ge_msg_stack.add;
1312: igs_sc_gen_001.unset_ctx('R');
1313: app_exception.raise_exception;
1314: ELSE
1315: igs_sc_gen_001.unset_ctx('R');
1316: RAISE;
1311: igs_ge_msg_stack.add;
1312: igs_sc_gen_001.unset_ctx('R');
1313: app_exception.raise_exception;
1314: ELSE
1315: igs_sc_gen_001.unset_ctx('R');
1316: RAISE;
1317: END IF;
1318: END update_row;
1319:
1487: x_rowid => x_rowid
1488: );
1489:
1490: IF (x_mode = 'S') THEN
1491: igs_sc_gen_001.set_ctx('R');
1492: END IF;
1493: DELETE FROM igs_en_spa_terms
1494: WHERE rowid = x_rowid;
1495:
1495:
1496: IF (SQL%NOTFOUND) THEN
1497: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1498: igs_ge_msg_stack.add;
1499: igs_sc_gen_001.unset_ctx('R');
1500: app_exception.raise_exception;
1501: END IF;
1502: IF (x_mode = 'S') THEN
1503: igs_sc_gen_001.unset_ctx('R');
1499: igs_sc_gen_001.unset_ctx('R');
1500: app_exception.raise_exception;
1501: END IF;
1502: IF (x_mode = 'S') THEN
1503: igs_sc_gen_001.unset_ctx('R');
1504: END IF;
1505:
1506:
1507: END delete_row;