DBA Data[Home] [Help]

APPS.IGS_EN_SPA_TERMS_PKG dependencies on IGS_SC_GEN_001

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

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,

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

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:

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

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;

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

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:

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

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,

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

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');

Line 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:

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

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;

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

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:

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

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:

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

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');

Line 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;