DBA Data[Home] [Help]

APPS.IGS_PE_FUND_SOURCE_PKG dependencies on IGS_SC_GEN_001

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

324: x_last_update_login => x_last_update_login
325: );
326:
327: IF (x_mode = 'S') THEN
328: igs_sc_gen_001.set_ctx('R');
329: END IF;
330: INSERT INTO igs_pe_fund_source (
331: fund_source_id,
332: person_id,

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

356: x_last_updated_by,
357: x_last_update_login
358: );
359: IF (x_mode = 'S') THEN
360: igs_sc_gen_001.unset_ctx('R');
361: END IF;
362:
363:
364: OPEN c;

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

375: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
376: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
377: fnd_message.set_token ('ERR_CD', SQLCODE);
378: igs_ge_msg_stack.add;
379: igs_sc_gen_001.unset_ctx('R');
380: app_exception.raise_exception;
381: ELSE
382: igs_sc_gen_001.unset_ctx('R');
383: RAISE;

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

378: igs_ge_msg_stack.add;
379: igs_sc_gen_001.unset_ctx('R');
380: app_exception.raise_exception;
381: ELSE
382: igs_sc_gen_001.unset_ctx('R');
383: RAISE;
384: END IF;
385: END insert_row;
386:

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

518: x_last_update_login => x_last_update_login
519: );
520:
521: IF (x_mode = 'S') THEN
522: igs_sc_gen_001.set_ctx('R');
523: END IF;
524: UPDATE igs_pe_fund_source
525: SET
526: person_id = new_references.person_id,

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

537:
538: IF (SQL%NOTFOUND) THEN
539: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
540: igs_ge_msg_stack.add;
541: igs_sc_gen_001.unset_ctx('R');
542: app_exception.raise_exception;
543: END IF;
544: IF (x_mode = 'S') THEN
545: igs_sc_gen_001.unset_ctx('R');

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

541: igs_sc_gen_001.unset_ctx('R');
542: app_exception.raise_exception;
543: END IF;
544: IF (x_mode = 'S') THEN
545: igs_sc_gen_001.unset_ctx('R');
546: END IF;
547:
548:
549:

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

552: IF (SQLCODE = (-28115)) THEN
553: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
554: fnd_message.set_token ('ERR_CD', SQLCODE);
555: igs_ge_msg_stack.add;
556: igs_sc_gen_001.unset_ctx('R');
557: app_exception.raise_exception;
558: ELSE
559: igs_sc_gen_001.unset_ctx('R');
560: RAISE;

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

555: igs_ge_msg_stack.add;
556: igs_sc_gen_001.unset_ctx('R');
557: app_exception.raise_exception;
558: ELSE
559: igs_sc_gen_001.unset_ctx('R');
560: RAISE;
561: END IF;
562: END update_row;
563:

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

647: x_rowid => x_rowid
648: );
649:
650: IF (x_mode = 'S') THEN
651: igs_sc_gen_001.set_ctx('R');
652: END IF;
653: DELETE FROM igs_pe_fund_source
654: WHERE rowid = x_rowid;
655:

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

655:
656: IF (SQL%NOTFOUND) THEN
657: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
658: igs_ge_msg_stack.add;
659: igs_sc_gen_001.unset_ctx('R');
660: app_exception.raise_exception;
661: END IF;
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.unset_ctx('R');

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

659: igs_sc_gen_001.unset_ctx('R');
660: app_exception.raise_exception;
661: END IF;
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.unset_ctx('R');
664: END IF;
665:
666:
667: END delete_row;