DBA Data[Home] [Help]

APPS.IBY_SECURITY_PKG dependencies on IBY_DEBUG_PUB

Line 937: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

933: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.encrypt_field_vals';
934:
935: BEGIN
936:
937: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
938:
939: IF masked_value_passed(p_value) = 'Y' THEN
940: return p_sec_segment_id;
941: END IF;

Line 946: iby_debug_pub.add('encrypting field value',

942:
943: -- no more used. System key passed from middle-tier
944: -- l_sys_key := Get_Sys_Key_Raw();
945:
946: iby_debug_pub.add('encrypting field value',
947: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
948:
949: Compress_Value ( p_value => p_value
950: , p_mask_setting => iby_security_pkg.G_MASK_ALL

Line 947: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

943: -- no more used. System key passed from middle-tier
944: -- l_sys_key := Get_Sys_Key_Raw();
945:
946: iby_debug_pub.add('encrypting field value',
947: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
948:
949: Compress_Value ( p_value => p_value
950: , p_mask_setting => iby_security_pkg.G_MASK_ALL
951: , p_unmask_len => 0

Line 1116: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1112: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.decrypt_field_vals';
1113:
1114: BEGIN
1115:
1116: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1117:
1118: IF (p_sec_segment_id IS NOT NULL) THEN
1119: --l_sys_key :=
1120: -- iby_security_pkg.Pad_Raw_Key( UTL_RAW.CAST_TO_RAW( p_sys_sec_key ) );

Line 1122: iby_debug_pub.add('decrypting field value',

1118: IF (p_sec_segment_id IS NOT NULL) THEN
1119: --l_sys_key :=
1120: -- iby_security_pkg.Pad_Raw_Key( UTL_RAW.CAST_TO_RAW( p_sys_sec_key ) );
1121:
1122: iby_debug_pub.add('decrypting field value',
1123: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1124:
1125: BEGIN
1126: SELECT bak.subkey_cipher_text

Line 1123: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1119: --l_sys_key :=
1120: -- iby_security_pkg.Pad_Raw_Key( UTL_RAW.CAST_TO_RAW( p_sys_sec_key ) );
1121:
1122: iby_debug_pub.add('decrypting field value',
1123: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1124:
1125: BEGIN
1126: SELECT bak.subkey_cipher_text
1127: , bas.segment_cipher_text

Line 1160: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1156: l_number VARCHAR2(4000);
1157: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.decrypt_num_field_vals';
1158:
1159: BEGIN
1160: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1161:
1162: l_number := decrypt_field_vals
1163: ( p_sec_segment_id,
1164: master_key_in

Line 1168: -- iby_debug_pub.add('l_number : ' || l_number || ':'|| ':',

1164: master_key_in
1165: );
1166: --The decrypted data is sensitive. Don not log it.
1167:
1168: -- iby_debug_pub.add('l_number : ' || l_number || ':'|| ':',
1169: -- iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1170:
1171: return to_number(l_number);
1172: EXCEPTION

Line 1169: -- iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1165: );
1166: --The decrypted data is sensitive. Don not log it.
1167:
1168: -- iby_debug_pub.add('l_number : ' || l_number || ':'|| ':',
1169: -- iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1170:
1171: return to_number(l_number);
1172: EXCEPTION
1173: WHEN OTHERS THEN