DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_DEBUG_PUB

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

5090: AND (b.iban_sec_segment_id = ibs.sec_segment_id(+))
5091: AND (ibs.sec_subkey_id = ibk.sec_subkey_id(+));
5092:
5093: BEGIN
5094: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
5095:
5096: IF (c_ext_ba%ISOPEN) THEN CLOSE c_ext_ba; END IF;
5097:
5098: Get_Mask_Settings(lx_mask_option,lx_unmask_len);

Line 5100: iby_debug_pub.add('masking option:=' || lx_mask_option,

5096: IF (c_ext_ba%ISOPEN) THEN CLOSE c_ext_ba; END IF;
5097:
5098: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
5099:
5100: iby_debug_pub.add('masking option:=' || lx_mask_option,
5101: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5102: iby_debug_pub.add('unmask length:=' || lx_unmask_len,
5103: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5104:

Line 5101: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

5097:
5098: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
5099:
5100: iby_debug_pub.add('masking option:=' || lx_mask_option,
5101: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5102: iby_debug_pub.add('unmask length:=' || lx_unmask_len,
5103: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5104:
5105: iby_security_pkg.Validate_Sys_Key(p_sys_key,lx_key_error);

Line 5102: iby_debug_pub.add('unmask length:=' || lx_unmask_len,

5098: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
5099:
5100: iby_debug_pub.add('masking option:=' || lx_mask_option,
5101: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5102: iby_debug_pub.add('unmask length:=' || lx_unmask_len,
5103: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5104:
5105: iby_security_pkg.Validate_Sys_Key(p_sys_key,lx_key_error);
5106: l_mode := Get_BA_Encrypt_Mode();

Line 5103: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

5099:
5100: iby_debug_pub.add('masking option:=' || lx_mask_option,
5101: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5102: iby_debug_pub.add('unmask length:=' || lx_unmask_len,
5103: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5104:
5105: iby_security_pkg.Validate_Sys_Key(p_sys_key,lx_key_error);
5106: l_mode := Get_BA_Encrypt_Mode();
5107:

Line 5108: iby_debug_pub.add('sys key check:=' || lx_key_error,

5104:
5105: iby_security_pkg.Validate_Sys_Key(p_sys_key,lx_key_error);
5106: l_mode := Get_BA_Encrypt_Mode();
5107:
5108: iby_debug_pub.add('sys key check:=' || lx_key_error,
5109: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5110:
5111: FOR ext_ba_rec IN c_ext_ba(lx_mask_option,lx_unmask_len) LOOP
5112: l_ba_num := NULL;

Line 5109: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

5105: iby_security_pkg.Validate_Sys_Key(p_sys_key,lx_key_error);
5106: l_mode := Get_BA_Encrypt_Mode();
5107:
5108: iby_debug_pub.add('sys key check:=' || lx_key_error,
5109: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5110:
5111: FOR ext_ba_rec IN c_ext_ba(lx_mask_option,lx_unmask_len) LOOP
5112: l_ba_num := NULL;
5113: l_iban := NULL;

Line 5122: iby_debug_pub.add('bank account:=' || ext_ba_rec.ext_bank_account_id,

5118: l_iban_segment := NULL;
5119: lx_ba_segment_id := NULL;
5120: lx_iban_segment_id := NULL;
5121:
5122: iby_debug_pub.add('bank account:=' || ext_ba_rec.ext_bank_account_id,
5123: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5124:
5125: IF ( ((NOT ext_ba_rec.ba_num_sec_segment_id IS NULL) OR
5126: (NOT ext_ba_rec.iban_sec_segment_id IS NULL)

Line 5123: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

5119: lx_ba_segment_id := NULL;
5120: lx_iban_segment_id := NULL;
5121:
5122: iby_debug_pub.add('bank account:=' || ext_ba_rec.ext_bank_account_id,
5123: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5124:
5125: IF ( ((NOT ext_ba_rec.ba_num_sec_segment_id IS NULL) OR
5126: (NOT ext_ba_rec.iban_sec_segment_id IS NULL)
5127: ) AND (NOT lx_key_error IS NULL) )

Line 5153: iby_debug_pub.add('encrypted bank account data',

5149: IF (NOT ext_ba_rec.ba_num_sec_segment_id IS NULL)
5150: OR (NOT ext_ba_rec.iban_sec_segment_id IS NULL)
5151: THEN
5152:
5153: iby_debug_pub.add('encrypted bank account data',
5154: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5155: Compress_Bank_Number
5156: (l_ba_num,lx_mask_option,lx_unmask_len,lx_compress_num,
5157: lx_ba_unmask_digits);

Line 5154: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

5150: OR (NOT ext_ba_rec.iban_sec_segment_id IS NULL)
5151: THEN
5152:
5153: iby_debug_pub.add('encrypted bank account data',
5154: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5155: Compress_Bank_Number
5156: (l_ba_num,lx_mask_option,lx_unmask_len,lx_compress_num,
5157: lx_ba_unmask_digits);
5158:

Line 5210: iby_debug_pub.add('unencrypted bank account data',

5206: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
5207: END IF;
5208:
5209: ELSE
5210: iby_debug_pub.add('unencrypted bank account data',
5211: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5212:
5213: lx_ba_unmask_digits := l_ba_num;
5214: lx_iban_unmask_digits := l_iban;

Line 5211: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

5207: END IF;
5208:
5209: ELSE
5210: iby_debug_pub.add('unencrypted bank account data',
5211: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5212:
5213: lx_ba_unmask_digits := l_ba_num;
5214: lx_iban_unmask_digits := l_iban;
5215:

Line 5248: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

5244: IF FND_API.to_Boolean( p_commit ) THEN
5245: COMMIT;
5246: END IF;
5247:
5248: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
5249: END Remask_Accounts;
5250:
5251: PROCEDURE Encrypt_Accounts
5252: (p_commit IN VARCHAR2,