APPS.ARI_UTILITIES dependencies on AR_BANK_DIRECTORY

Line 1727: FROM AR_BANK_DIRECTORY

1723: and nvl(trunc(end_date), trunc(sysdate)) >= trunc(sysdate);
1724:
1725: CURSOR bank_directory_cur IS
1726: SELECT bank_name
1727: FROM AR_BANK_DIRECTORY
1728: WHERE routing_number = p_routing_number;
1729:
1730: bank_branch_rec bank_branch_cur%ROWTYPE;
1731: bank_directory_rec bank_directory_cur%ROWTYPE;

Line 1780: l_routing_number_validation := NVL(FND_PROFILE.value('AR_BANK_DIRECTORY_SOURCE'),'NONE');

1776: ELSE
1777: CLOSE bank_branch_cur;
1778: END IF;
1779:
1780: l_routing_number_validation := NVL(FND_PROFILE.value('AR_BANK_DIRECTORY_SOURCE'),'NONE');
1781:
1782: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1783: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'profile AR_BANK_DIRECTORY_SOURCE value :: '||l_routing_number_validation);
1784: end if;

Line 1783: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'profile AR_BANK_DIRECTORY_SOURCE value :: '||l_routing_number_validation);

1779:
1780: l_routing_number_validation := NVL(FND_PROFILE.value('AR_BANK_DIRECTORY_SOURCE'),'NONE');
1781:
1782: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1783: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'profile AR_BANK_DIRECTORY_SOURCE value :: '||l_routing_number_validation);
1784: end if;
1785:
1786: /*-----------------------------------------------------+
1787: | If source is 'NONE' then no validate routing number against AR_BANKD_DIRECTORY |

Line 1795: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Found routing number in AR_BANK_DIRECTORY');

1791: OPEN bank_directory_cur;
1792: FETCH bank_directory_cur INTO bank_directory_rec;
1793: IF (bank_directory_cur%FOUND) then
1794: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1795: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Found routing number in AR_BANK_DIRECTORY');
1796: end if;
1797: CLOSE bank_directory_cur;
1798: RETURN 1;
1799: ELSE

Line 1801: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Routing Number not found in AR_BANK_DIRECTORY');

1797: CLOSE bank_directory_cur;
1798: RETURN 1;
1799: ELSE
1800: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1801: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Routing Number not found in AR_BANK_DIRECTORY');
1802: end if;
1803: CLOSE bank_directory_cur;
1804: RETURN 0;
1805: END IF;