APPS.IGS_PE_DEPD_ACTIVE_PKG dependencies on IGS_SC_GEN_001

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

247: x_other_reason_remarks => x_other_reason_remarks
248: );
249:
250: IF (x_mode = 'S') THEN
251: igs_sc_gen_001.set_ctx('R');
252: END IF;
253: INSERT INTO igs_pe_depd_active (
254: relationship_id,
255: action_code,

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

275: x_last_update_login ,
276: new_references.other_reason_remarks
277: ) RETURNING ROWID INTO x_rowid;
278: IF (x_mode = 'S') THEN
279: igs_sc_gen_001.unset_ctx('R');
280: END IF;
281:
282:
283:

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

286: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
287: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
288: fnd_message.set_token ('ERR_CD', SQLCODE);
289: igs_ge_msg_stack.add;
290: igs_sc_gen_001.unset_ctx('R');
291: app_exception.raise_exception;
292: ELSE
293: igs_sc_gen_001.unset_ctx('R');
294: RAISE;

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

289: igs_ge_msg_stack.add;
290: igs_sc_gen_001.unset_ctx('R');
291: app_exception.raise_exception;
292: ELSE
293: igs_sc_gen_001.unset_ctx('R');
294: RAISE;
295: END IF;
296: END insert_row;
297:

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

415: x_other_reason_remarks => x_other_reason_remarks
416: );
417:
418: IF (x_mode = 'S') THEN
419: igs_sc_gen_001.set_ctx('R');
420: END IF;
421: UPDATE igs_pe_depd_active
422: SET
423: reason_code = new_references.reason_code,

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

430:
431: IF (SQL%NOTFOUND) THEN
432: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
433: igs_ge_msg_stack.add;
434: igs_sc_gen_001.unset_ctx('R');
435: app_exception.raise_exception;
436: END IF;
437: IF (x_mode = 'S') THEN
438: igs_sc_gen_001.unset_ctx('R');

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

434: igs_sc_gen_001.unset_ctx('R');
435: app_exception.raise_exception;
436: END IF;
437: IF (x_mode = 'S') THEN
438: igs_sc_gen_001.unset_ctx('R');
439: END IF;
440:
441:
442:

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

445: IF (SQLCODE = (-28115)) THEN
446: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
447: fnd_message.set_token ('ERR_CD', SQLCODE);
448: igs_ge_msg_stack.add;
449: igs_sc_gen_001.unset_ctx('R');
450: app_exception.raise_exception;
451: ELSE
452: igs_sc_gen_001.unset_ctx('R');
453: RAISE;

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

448: igs_ge_msg_stack.add;
449: igs_sc_gen_001.unset_ctx('R');
450: app_exception.raise_exception;
451: ELSE
452: igs_sc_gen_001.unset_ctx('R');
453: RAISE;
454: END IF;
455: END update_row;
456:

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

536: x_rowid => x_rowid
537: );
538:
539: IF (x_mode = 'S') THEN
540: igs_sc_gen_001.set_ctx('R');
541: END IF;
542: DELETE FROM igs_pe_depd_active
543: WHERE rowid = x_rowid;
544:

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

544:
545: IF (SQL%NOTFOUND) THEN
546: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
547: igs_ge_msg_stack.add;
548: igs_sc_gen_001.unset_ctx('R');
549: app_exception.raise_exception;
550: END IF;
551: IF (x_mode = 'S') THEN
552: igs_sc_gen_001.unset_ctx('R');

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

548: igs_sc_gen_001.unset_ctx('R');
549: app_exception.raise_exception;
550: END IF;
551: IF (x_mode = 'S') THEN
552: igs_sc_gen_001.unset_ctx('R');
553: END IF;
554:
555:
556: END delete_row;