APPS.IGS_AD_PANEL_DTLS_PKG dependencies on IGS_SC_GEN_001

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

1357: x_last_update_login => x_last_update_login
1358: );
1359:
1360: IF (x_mode = 'S') THEN
1361: igs_sc_gen_001.set_ctx('R');
1362: END IF;
1363: INSERT INTO igs_ad_panel_dtls (
1364: panel_dtls_id,
1365: person_id,

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

1443: x_last_updated_by,
1444: x_last_update_login
1445: ) RETURNING ROWID, panel_dtls_id INTO x_rowid, x_panel_dtls_id;
1446: IF (x_mode = 'S') THEN
1447: igs_sc_gen_001.unset_ctx('R');
1448: END IF;
1449:
1450:
1451: -- Assign the panel members associated with the panel code to the Application Instance.

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

1452: afterinsertupdatedelete( p_inserting => TRUE , p_updating => FALSE, p_deleting=> FALSE, p_panel_dtls_id => x_panel_dtls_id);
1453: EXCEPTION
1454: WHEN OTHERS THEN
1455: IF (x_mode = 'S') THEN
1456: igs_sc_gen_001.unset_ctx('R');
1457: END IF;
1458: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1459: -- Code to handle Security Policy error raised
1460: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1742: x_last_update_login => x_last_update_login
1743: );
1744:
1745: IF (x_mode = 'S') THEN
1746: igs_sc_gen_001.set_ctx('R');
1747: END IF;
1748: UPDATE igs_ad_panel_dtls
1749: SET
1750: person_id = new_references.person_id,

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

1789: IF (SQL%NOTFOUND) THEN
1790: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1791: igs_ge_msg_stack.add;
1792: IF (x_mode = 'S') THEN
1793: igs_sc_gen_001.unset_ctx('R');
1794: END IF;
1795: app_exception.raise_exception;
1796: END IF;
1797: IF (x_mode = 'S') THEN

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

1794: END IF;
1795: app_exception.raise_exception;
1796: END IF;
1797: IF (x_mode = 'S') THEN
1798: igs_sc_gen_001.unset_ctx('R');
1799: END IF;
1800:
1801:
1802: -- When the final screening/interview decision is changed, a record needs to get inserted into the history table.

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

1803: afterinsertupdatedelete( p_inserting => FALSE , p_updating => TRUE, p_deleting=> FALSE, p_panel_dtls_id => new_references.panel_dtls_id);
1804: EXCEPTION
1805: WHEN OTHERS THEN
1806: IF (x_mode = 'S') THEN
1807: igs_sc_gen_001.unset_ctx('R');
1808: END IF;
1809: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1810: -- Code to handle Security Policy error raised
1811: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1989: x_rowid => x_rowid
1990: );
1991:
1992: IF (x_mode = 'S') THEN
1993: igs_sc_gen_001.set_ctx('R');
1994: END IF;
1995: DELETE FROM igs_ad_panel_dtls
1996: WHERE rowid = x_rowid;
1997:

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

1998: IF (SQL%NOTFOUND) THEN
1999: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2000: igs_ge_msg_stack.add;
2001: IF (x_mode = 'S') THEN
2002: igs_sc_gen_001.unset_ctx('R');
2003: END IF;
2004: app_exception.raise_exception;
2005: END IF;
2006: IF (x_mode = 'S') THEN

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

2003: END IF;
2004: app_exception.raise_exception;
2005: END IF;
2006: IF (x_mode = 'S') THEN
2007: igs_sc_gen_001.unset_ctx('R');
2008: END IF;
2009:
2010:
2011: EXCEPTION

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

2010:
2011: EXCEPTION
2012: WHEN OTHERS THEN
2013: IF (x_mode = 'S') THEN
2014: igs_sc_gen_001.unset_ctx('R');
2015: END IF;
2016: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
2017: -- Code to handle Security Policy error raised
2018: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.