APPS.ARI_DB_UTILITIES dependencies on FND_API

Line 1246: l_message:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

1242:
1243: fnd_message.retrieve(l_message);
1244:
1245: LOOP
1246: l_message:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
1247: IF (l_message IS NULL)THEN
1248: EXIT;
1249: END IF;
1250: END LOOP;

Line 1295: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;

1291: RETCODE OUT NOCOPY VARCHAR2,
1292: p_import_new_banks_only IN VARCHAR2) IS
1293:
1294: l_api_version NUMBER := 1.0;
1295: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
1296: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1297: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1298: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;
1299: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;

Line 1388: IF(RETCODE = FND_API.G_RET_STS_ERROR ) THEN

1384: x_msg_count => l_msg_count,
1385: x_msg_data => ERRBUF,
1386: x_response => l_branch_response );
1387:
1388: IF(RETCODE = FND_API.G_RET_STS_ERROR ) THEN
1389:
1390: fnd_file.put_line( FND_FILE.LOG, 'Error - Endating the Routing Number :: '||ar_bank_branch_rec.routing_number ||' , Bank Name :: '||ar_bank_branch_rec.bank_name);
1391: fnd_file.put_line( FND_FILE.LOG, 'ERRBUF :: '||ERRBUF);
1392: l_cr_return_status := 'WARNING';

Line 1444: IF(RETCODE = FND_API.G_RET_STS_ERROR ) THEN

1440: x_msg_count => l_msg_count,
1441: x_msg_data => ERRBUF,
1442: x_response => l_branch_response );
1443:
1444: IF(RETCODE = FND_API.G_RET_STS_ERROR ) THEN
1445:
1446: fnd_file.put_line( FND_FILE.LOG, 'Error - Updating Branch Info for Routing Number :: '||ar_bank_branch_rec.routing_number||' , with Branch Name :: '||ar_bank_branch_rec.branch_name);
1447: fnd_file.put_line( FND_FILE.LOG, 'ERRBUF :: '||ERRBUF);
1448: l_cr_return_status := 'WARNING';

Line 1524: IF(RETCODE = FND_API.G_RET_STS_ERROR ) THEN

1520: x_msg_count => l_msg_count,
1521: x_msg_data => ERRBUF,
1522: x_response => l_bank_response );
1523:
1524: IF(RETCODE = FND_API.G_RET_STS_ERROR ) THEN
1525:
1526: fnd_file.put_line( FND_FILE.LOG, 'Error - Creating Bank Info for Routing Number :: '||ar_bank_branch_rec.routing_number||' , Bank Name :: '||ar_bank_branch_rec.bank_name);
1527: fnd_file.put_line( FND_FILE.LOG, 'ERRBUF :: '||ERRBUF);
1528: l_cr_return_status := 'WARNING';

Line 1530: ELSIF (RETCODE = FND_API.G_RET_STS_SUCCESS AND l_bank_party_id is not null) THEN

1526: fnd_file.put_line( FND_FILE.LOG, 'Error - Creating Bank Info for Routing Number :: '||ar_bank_branch_rec.routing_number||' , Bank Name :: '||ar_bank_branch_rec.bank_name);
1527: fnd_file.put_line( FND_FILE.LOG, 'ERRBUF :: '||ERRBUF);
1528: l_cr_return_status := 'WARNING';
1529:
1530: ELSIF (RETCODE = FND_API.G_RET_STS_SUCCESS AND l_bank_party_id is not null) THEN
1531:
1532: l_ext_branch_rec.branch_party_id := NULL;
1533: l_ext_branch_rec.bank_party_id := l_bank_party_id;
1534: l_ext_branch_rec.branch_name := ar_bank_branch_rec.branch_name;

Line 1552: IF(RETCODE = FND_API.G_RET_STS_ERROR ) THEN

1548: x_msg_count => l_msg_count,
1549: x_msg_data => ERRBUF,
1550: x_response => l_branch_response);
1551:
1552: IF(RETCODE = FND_API.G_RET_STS_ERROR ) THEN
1553:
1554: fnd_file.put_line( FND_FILE.LOG, 'Error - Creating Branch Info for Routing Number :: '||ar_bank_branch_rec.routing_number||' , Branch Name :: '||ar_bank_branch_rec.branch_name);
1555: fnd_file.put_line( FND_FILE.LOG, 'ERRBUF :: '||ERRBUF);
1556: l_cr_return_status := 'WARNING';

Line 1563: END IF; -- RETCODE = FND_API.G_RET_STS_ERROR

1559: fnd_file.put_line( FND_FILE.LOG, 'Successful - Creating Bank and Branch Info for Routing Number :: '||ar_bank_branch_rec.routing_number||' , Bank Name :: '||ar_bank_branch_rec.bank_name);
1560: l_success_recs := l_success_recs+1;
1561: END IF;
1562:
1563: END IF; -- RETCODE = FND_API.G_RET_STS_ERROR
1564:
1565:
1566: ELSE -- if bank associated to this routing number eixsts in ce
1567:

Line 1591: IF(RETCODE = FND_API.G_RET_STS_ERROR ) THEN

1587: x_msg_count => l_msg_count,
1588: x_msg_data => ERRBUF,
1589: x_response => l_branch_response);
1590:
1591: IF(RETCODE = FND_API.G_RET_STS_ERROR ) THEN
1592:
1593: fnd_file.put_line( FND_FILE.LOG, 'Error - Creating Branch Info for Routing Number :: '||ar_bank_branch_rec.routing_number||' , with Branch Name :: '||ar_bank_branch_rec.routing_number);
1594: fnd_file.put_line( FND_FILE.LOG, 'ERRBUF :: '||ERRBUF);
1595: l_cr_return_status := 'WARNING';