APPS.IGS_UC_APPLICANTS_PKG dependencies on IGS_SC_GEN_001

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

1107: x_personal_id => x_personal_id
1108: );
1109:
1110: IF (x_mode = 'S') THEN
1111: igs_sc_gen_001.set_ctx('R');
1112: END IF;
1113: INSERT INTO igs_uc_applicants (
1114: app_id,
1115: app_no,

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

1337: new_references.country_birth ,
1338: new_references.personal_id
1339: );
1340: IF (x_mode = 'S') THEN
1341: igs_sc_gen_001.unset_ctx('R');
1342: END IF;
1343:
1344:
1345: OPEN c;

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

1359: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1360: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1361: fnd_message.set_token ('ERR_CD', SQLCODE);
1362: igs_ge_msg_stack.add;
1363: igs_sc_gen_001.unset_ctx('R');
1364: app_exception.raise_exception;
1365: ELSE
1366: igs_sc_gen_001.unset_ctx('R');
1367: RAISE;

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

1362: igs_ge_msg_stack.add;
1363: igs_sc_gen_001.unset_ctx('R');
1364: app_exception.raise_exception;
1365: ELSE
1366: igs_sc_gen_001.unset_ctx('R');
1367: RAISE;
1368: END IF;
1369: END insert_row;
1370:

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

2004: x_personal_id => x_personal_id
2005: );
2006:
2007: IF (x_mode = 'S') THEN
2008: igs_sc_gen_001.set_ctx('R');
2009: END IF;
2010: UPDATE igs_uc_applicants
2011: SET
2012: app_no = new_references.app_no,

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

2122:
2123: IF (SQL%NOTFOUND) THEN
2124: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2125: igs_ge_msg_stack.add;
2126: igs_sc_gen_001.unset_ctx('R');
2127: app_exception.raise_exception;
2128: END IF;
2129: IF (x_mode = 'S') THEN
2130: igs_sc_gen_001.unset_ctx('R');

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

2126: igs_sc_gen_001.unset_ctx('R');
2127: app_exception.raise_exception;
2128: END IF;
2129: IF (x_mode = 'S') THEN
2130: igs_sc_gen_001.unset_ctx('R');
2131: END IF;
2132:
2133:
2134: -- Bug No: 3087784. Resetting the value of l_rowid to NULL.

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

2139: IF (SQLCODE = (-28115)) THEN
2140: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
2141: fnd_message.set_token ('ERR_CD', SQLCODE);
2142: igs_ge_msg_stack.add;
2143: igs_sc_gen_001.unset_ctx('R');
2144: app_exception.raise_exception;
2145: ELSE
2146: igs_sc_gen_001.unset_ctx('R');
2147: RAISE;

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

2142: igs_ge_msg_stack.add;
2143: igs_sc_gen_001.unset_ctx('R');
2144: app_exception.raise_exception;
2145: ELSE
2146: igs_sc_gen_001.unset_ctx('R');
2147: RAISE;
2148: END IF;
2149:
2150: END update_row;

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

2537: x_rowid => x_rowid
2538: );
2539:
2540: IF (x_mode = 'S') THEN
2541: igs_sc_gen_001.set_ctx('R');
2542: END IF;
2543: DELETE FROM igs_uc_applicants
2544: WHERE rowid = x_rowid;
2545:

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

2545:
2546: IF (SQL%NOTFOUND) THEN
2547: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2548: igs_ge_msg_stack.add;
2549: igs_sc_gen_001.unset_ctx('R');
2550: app_exception.raise_exception;
2551: END IF;
2552: IF (x_mode = 'S') THEN
2553: igs_sc_gen_001.unset_ctx('R');

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

2549: igs_sc_gen_001.unset_ctx('R');
2550: app_exception.raise_exception;
2551: END IF;
2552: IF (x_mode = 'S') THEN
2553: igs_sc_gen_001.unset_ctx('R');
2554: END IF;
2555:
2556:
2557: -- Bug No: 3087784. Resetting the value of l_rowid to NULL.