APPS.IGS_AD_PNMEMBR_DTLS_PKG dependencies on IGS_SC_GEN_001

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

952: x_last_update_login => x_last_update_login
953: );
954:
955: IF (x_mode = 'S') THEN
956: igs_sc_gen_001.set_ctx('R');
957: END IF;
958: INSERT INTO igs_ad_pnmembr_dtls (
959: panel_dtls_id,
960: role_type_code,

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

1030: x_last_updated_by,
1031: x_last_update_login
1032: ) RETURNING ROWID INTO x_rowid;
1033: IF (x_mode = 'S') THEN
1034: igs_sc_gen_001.unset_ctx('R');
1035: END IF;
1036:
1037:
1038: EXCEPTION

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

1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: IF (x_mode = 'S') THEN
1041: igs_sc_gen_001.unset_ctx('R');
1042: END IF;
1043: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1044: -- Code to handle Security Policy error raised
1045: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1304: x_last_update_login => x_last_update_login
1305: );
1306:
1307: IF (x_mode = 'S') THEN
1308: igs_sc_gen_001.set_ctx('R');
1309: END IF;
1310: UPDATE igs_ad_pnmembr_dtls
1311: SET
1312: role_type_code = new_references.role_type_code,

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

1346: IF (SQL%NOTFOUND) THEN
1347: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1348: igs_ge_msg_stack.add;
1349: IF (x_mode = 'S') THEN
1350: igs_sc_gen_001.unset_ctx('R');
1351: END IF;
1352: app_exception.raise_exception;
1353: END IF;
1354: IF (x_mode = 'S') THEN

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

1351: END IF;
1352: app_exception.raise_exception;
1353: END IF;
1354: IF (x_mode = 'S') THEN
1355: igs_sc_gen_001.unset_ctx('R');
1356: END IF;
1357:
1358:
1359: EXCEPTION

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

1358:
1359: EXCEPTION
1360: WHEN OTHERS THEN
1361: IF (x_mode = 'S') THEN
1362: igs_sc_gen_001.unset_ctx('R');
1363: END IF;
1364: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1365: -- Code to handle Security Policy error raised
1366: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1533: x_rowid => x_rowid
1534: );
1535:
1536: IF (x_mode = 'S') THEN
1537: igs_sc_gen_001.set_ctx('R');
1538: END IF;
1539: DELETE FROM igs_ad_pnmembr_dtls
1540: WHERE rowid = x_rowid;
1541:

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

1542: IF (SQL%NOTFOUND) THEN
1543: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1544: igs_ge_msg_stack.add;
1545: IF (x_mode = 'S') THEN
1546: igs_sc_gen_001.unset_ctx('R');
1547: END IF;
1548: app_exception.raise_exception;
1549: END IF;
1550: IF (x_mode = 'S') THEN

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

1547: END IF;
1548: app_exception.raise_exception;
1549: END IF;
1550: IF (x_mode = 'S') THEN
1551: igs_sc_gen_001.unset_ctx('R');
1552: END IF;
1553:
1554:
1555: EXCEPTION

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

1554:
1555: EXCEPTION
1556: WHEN OTHERS THEN
1557: IF (x_mode = 'S') THEN
1558: igs_sc_gen_001.unset_ctx('R');
1559: END IF;
1560: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1561: -- Code to handle Security Policy error raised
1562: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.