DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_DEBUG_PUB

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

4252: AND (b.iban_sec_segment_id = ibs.sec_segment_id(+))
4253: AND (ibs.sec_subkey_id = ibk.sec_subkey_id(+));
4254:
4255: BEGIN
4256: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
4257:
4258: IF (c_ext_ba%ISOPEN) THEN CLOSE c_ext_ba; END IF;
4259:
4260: Get_Mask_Settings(lx_mask_option,lx_unmask_len);

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

4258: IF (c_ext_ba%ISOPEN) THEN CLOSE c_ext_ba; END IF;
4259:
4260: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
4261:
4262: iby_debug_pub.add('masking option:=' || lx_mask_option,
4263: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4264: iby_debug_pub.add('unmask length:=' || lx_unmask_len,
4265: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4266:

Line 4263: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

4259:
4260: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
4261:
4262: iby_debug_pub.add('masking option:=' || lx_mask_option,
4263: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4264: iby_debug_pub.add('unmask length:=' || lx_unmask_len,
4265: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4266:
4267: iby_security_pkg.Validate_Sys_Key(p_sys_key,lx_key_error);

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

4260: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
4261:
4262: iby_debug_pub.add('masking option:=' || lx_mask_option,
4263: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4264: iby_debug_pub.add('unmask length:=' || lx_unmask_len,
4265: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4266:
4267: iby_security_pkg.Validate_Sys_Key(p_sys_key,lx_key_error);
4268: l_mode := Get_BA_Encrypt_Mode();

Line 4265: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

4261:
4262: iby_debug_pub.add('masking option:=' || lx_mask_option,
4263: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4264: iby_debug_pub.add('unmask length:=' || lx_unmask_len,
4265: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4266:
4267: iby_security_pkg.Validate_Sys_Key(p_sys_key,lx_key_error);
4268: l_mode := Get_BA_Encrypt_Mode();
4269:

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

4266:
4267: iby_security_pkg.Validate_Sys_Key(p_sys_key,lx_key_error);
4268: l_mode := Get_BA_Encrypt_Mode();
4269:
4270: iby_debug_pub.add('sys key check:=' || lx_key_error,
4271: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4272:
4273: FOR ext_ba_rec IN c_ext_ba(lx_mask_option,lx_unmask_len) LOOP
4274: l_ba_num := NULL;

Line 4271: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

4267: iby_security_pkg.Validate_Sys_Key(p_sys_key,lx_key_error);
4268: l_mode := Get_BA_Encrypt_Mode();
4269:
4270: iby_debug_pub.add('sys key check:=' || lx_key_error,
4271: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4272:
4273: FOR ext_ba_rec IN c_ext_ba(lx_mask_option,lx_unmask_len) LOOP
4274: l_ba_num := NULL;
4275: l_iban := NULL;

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

4280: l_iban_segment := NULL;
4281: lx_ba_segment_id := NULL;
4282: lx_iban_segment_id := NULL;
4283:
4284: iby_debug_pub.add('bank account:=' || ext_ba_rec.ext_bank_account_id,
4285: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4286:
4287: IF ( ((NOT ext_ba_rec.ba_num_sec_segment_id IS NULL) OR
4288: (NOT ext_ba_rec.iban_sec_segment_id IS NULL)

Line 4285: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

4281: lx_ba_segment_id := NULL;
4282: lx_iban_segment_id := NULL;
4283:
4284: iby_debug_pub.add('bank account:=' || ext_ba_rec.ext_bank_account_id,
4285: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4286:
4287: IF ( ((NOT ext_ba_rec.ba_num_sec_segment_id IS NULL) OR
4288: (NOT ext_ba_rec.iban_sec_segment_id IS NULL)
4289: ) AND (NOT lx_key_error IS NULL) )

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

4311: IF (NOT ext_ba_rec.ba_num_sec_segment_id IS NULL)
4312: OR (NOT ext_ba_rec.iban_sec_segment_id IS NULL)
4313: THEN
4314:
4315: iby_debug_pub.add('encrypted bank account data',
4316: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4317: Compress_Bank_Number
4318: (l_ba_num,lx_mask_option,lx_unmask_len,lx_compress_num,
4319: lx_ba_unmask_digits);

Line 4316: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

4312: OR (NOT ext_ba_rec.iban_sec_segment_id IS NULL)
4313: THEN
4314:
4315: iby_debug_pub.add('encrypted bank account data',
4316: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4317: Compress_Bank_Number
4318: (l_ba_num,lx_mask_option,lx_unmask_len,lx_compress_num,
4319: lx_ba_unmask_digits);
4320:

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

4368: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
4369: END IF;
4370:
4371: ELSE
4372: iby_debug_pub.add('unencrypted bank account data',
4373: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4374:
4375: lx_ba_unmask_digits := l_ba_num;
4376: lx_iban_unmask_digits := l_iban;

Line 4373: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

4369: END IF;
4370:
4371: ELSE
4372: iby_debug_pub.add('unencrypted bank account data',
4373: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
4374:
4375: lx_ba_unmask_digits := l_ba_num;
4376: lx_iban_unmask_digits := l_iban;
4377:

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

4406: IF FND_API.to_Boolean( p_commit ) THEN
4407: COMMIT;
4408: END IF;
4409:
4410: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
4411: END Remask_Accounts;
4412:
4413: PROCEDURE Encrypt_Accounts
4414: (p_commit IN VARCHAR2,