APPS.IGS_UC_TRANSACTIONS_PKG dependencies on IGS_SC_GEN_001

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

416: x_part_time => x_part_time
417: );
418:
419: IF (x_mode = 'S') THEN
420: igs_sc_gen_001.set_ctx('R');
421: END IF;
422: INSERT INTO igs_uc_transactions (
423: uc_tran_id,
424: transaction_id,

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

488: new_references.modular ,
489: new_references.part_time
490: );
491: IF (x_mode = 'S') THEN
492: igs_sc_gen_001.unset_ctx('R');
493: END IF;
494:
495:
496: OPEN c;

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

507: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
508: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
509: fnd_message.set_token ('ERR_CD', SQLCODE);
510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;
513: ELSE
514: igs_sc_gen_001.unset_ctx('R');
515: RAISE;

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

510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;
513: ELSE
514: igs_sc_gen_001.unset_ctx('R');
515: RAISE;
516: END IF;
517: END insert_row;
518:

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

754: x_part_time => x_part_time
755: );
756:
757: IF (x_mode = 'S') THEN
758: igs_sc_gen_001.set_ctx('R');
759: END IF;
760: UPDATE igs_uc_transactions
761: SET
762: transaction_id = new_references.transaction_id,

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

793:
794: IF (SQL%NOTFOUND) THEN
795: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
796: igs_ge_msg_stack.add;
797: igs_sc_gen_001.unset_ctx('R');
798: app_exception.raise_exception;
799: END IF;
800: IF (x_mode = 'S') THEN
801: igs_sc_gen_001.unset_ctx('R');

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

797: igs_sc_gen_001.unset_ctx('R');
798: app_exception.raise_exception;
799: END IF;
800: IF (x_mode = 'S') THEN
801: igs_sc_gen_001.unset_ctx('R');
802: END IF;
803:
804: EXCEPTION
805: WHEN OTHERS THEN

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

806: IF (SQLCODE = (-28115)) THEN
807: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
808: fnd_message.set_token ('ERR_CD', SQLCODE);
809: igs_ge_msg_stack.add;
810: igs_sc_gen_001.unset_ctx('R');
811: app_exception.raise_exception;
812: ELSE
813: igs_sc_gen_001.unset_ctx('R');
814: RAISE;

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

809: igs_ge_msg_stack.add;
810: igs_sc_gen_001.unset_ctx('R');
811: app_exception.raise_exception;
812: ELSE
813: igs_sc_gen_001.unset_ctx('R');
814: RAISE;
815: END IF;
816:
817: END update_row;

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

964: x_rowid => x_rowid
965: );
966:
967: IF (x_mode = 'S') THEN
968: igs_sc_gen_001.set_ctx('R');
969: END IF;
970: DELETE FROM igs_uc_transactions
971: WHERE rowid = x_rowid;
972:

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

972:
973: IF (SQL%NOTFOUND) THEN
974: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
975: igs_ge_msg_stack.add;
976: igs_sc_gen_001.unset_ctx('R');
977: app_exception.raise_exception;
978: END IF;
979: IF (x_mode = 'S') THEN
980: igs_sc_gen_001.unset_ctx('R');

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

976: igs_sc_gen_001.unset_ctx('R');
977: app_exception.raise_exception;
978: END IF;
979: IF (x_mode = 'S') THEN
980: igs_sc_gen_001.unset_ctx('R');
981: END IF;
982:
983:
984: END delete_row;