APPS.ARI_DB_UTILITIES dependencies on FND_CONCURRENT

Line 982: from fnd_concurrent_requests fcr,

978:
979: /* Verify that the request belongs to this user */
980:
981: select 'Y' into l_valid_user
982: from fnd_concurrent_requests fcr,
983: fnd_concurrent_programs fcp
984: where fcr.request_id = p_request_id
985: and fcr.requested_by = p_user_id
986: and fcp.concurrent_program_id = fcr.concurrent_program_id

Line 983: fnd_concurrent_programs fcp

979: /* Verify that the request belongs to this user */
980:
981: select 'Y' into l_valid_user
982: from fnd_concurrent_requests fcr,
983: fnd_concurrent_programs fcp
984: where fcr.request_id = p_request_id
985: and fcr.requested_by = p_user_id
986: and fcp.concurrent_program_id = fcr.concurrent_program_id
987: and fcp.concurrent_program_name = 'RAXINV_SEL';

Line 993: from fnd_concurrent_requests

989: /* Get the request status */
990:
991: if (l_valid_user = 'Y') then
992: select status_code into l_status
993: from fnd_concurrent_requests
994: where request_id = p_request_id;
995: end if;
996:
997: p_status := l_status;

Line 1636: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

1632:
1633: fnd_file.put_line( FND_FILE.LOG, '------------------------------------------------------------------------------------------+');
1634:
1635: IF ( l_cr_return_status = 'WARNING' AND l_import_new_banks_only = 'N') THEN
1636: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1637: status => l_cr_return_status,
1638: message => 'Not all banks informartion were created/updated successfully. Please review the log file.');
1639: ELSE
1640: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

Line 1640: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

1636: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1637: status => l_cr_return_status,
1638: message => 'Not all banks informartion were created/updated successfully. Please review the log file.');
1639: ELSE
1640: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1641: status => l_cr_return_status,
1642: message => 'Not all banks informartion were created successfully. Please review the log file.');
1643:
1644: END IF;

Line 1650: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

1646: fnd_file.put_line( FND_FILE.LOG, 'End Procedure ' || 'upload_ar_bank_branch_concur' || l_procedure_name);
1647:
1648: EXCEPTION WHEN OTHERS THEN
1649: l_cr_return_status := 'ERROR';
1650: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1651: status => l_cr_return_status,
1652: message => 'Exporting Bank Information has failed. Please review the log file.');
1653:
1654: fnd_file.put_line( FND_FILE.LOG,'Unexpected Exception in ' || 'upload_ar_bank_branch_concur' || l_procedure_name);

Line 1664: | table data matching the purge process of FND_CONCURRENT_REQUESTS table.

1660: | PUBLIC procedure PURGE_IREC_PRINT_REQUESTS
1661: |
1662: | DESCRIPTION
1663: | This procedure submits cuncurrent request to purge AR_IREC_PRINT_REQUESTS
1664: | table data matching the purge process of FND_CONCURRENT_REQUESTS table.
1665: | --------------------------------------------------------------------
1666: |
1667: | PSEUDO CODE/LOGIC
1668: |

Line 1705: select min(request_date) into l_fnd_request_date from fnd_concurrent_requests;

1701: fnd_file.put_line( FND_FILE.LOG, 'Begin Procedure ' || l_procedure_name);
1702: fnd_file.put_line( FND_FILE.LOG, '+---------------------------------------------------------------------------+');
1703:
1704: if(p_creation_date is NULL) then
1705: select min(request_date) into l_fnd_request_date from fnd_concurrent_requests;
1706: else
1707: l_fnd_request_date := FND_CONC_DATE.STRING_TO_DATE(p_creation_date); /* Convert character string to date */
1708: if(l_fnd_request_date is NULL) then
1709:

Line 1712: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

1708: if(l_fnd_request_date is NULL) then
1709:
1710: l_cp_return_status := 'ERROR';
1711: errbuf := 'Unexpected error converting character string to date'||l_fnd_request_date;
1712: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1713: status => l_cp_return_status,
1714: message => errbuf);
1715:
1716: retcode := '2';

Line 1739: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

1735: fnd_message.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1736: fnd_message.set_token('ROWS', numrows);
1737: msgbuf := fnd_message.get;
1738: FND_FILE.put_line(FND_FILE.log, msgbuf);
1739: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1740: status => l_cp_return_status,
1741: message => 'Purging AR_IREC_PRINT_REQUESTS completed successfully');
1742: exception
1743: when others then

Line 1748: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

1744: errbuf := sqlerrm;
1745: retcode := '2';
1746: FND_FILE.put_line(FND_FILE.log,errbuf);
1747: l_cp_return_status := 'ERROR';
1748: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1749: status => l_cp_return_status,
1750: message => 'Unexpected error during purge process');
1751: raise;
1752:

Line 1807: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

1803: if(l_purge_date is NULL) then
1804:
1805: l_cp_return_status := 'ERROR';
1806: errbuf := 'Unexpected error converting character string to date'||l_purge_date;
1807: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1808: status => l_cp_return_status,
1809: message => errbuf);
1810:
1811: retcode := '2';

Line 1834: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

1830: fnd_message.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1831: fnd_message.set_token('ROWS', numrows);
1832: msgbuf := fnd_message.get;
1833: FND_FILE.put_line(FND_FILE.log, msgbuf);
1834: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1835: status => l_cp_return_status,
1836: message => 'Purging AR_IREC_USER_ACCT_SITES_ALL completed successfully');
1837: exception
1838: when others then

Line 1843: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

1839: errbuf := sqlerrm;
1840: retcode := '2';
1841: FND_FILE.put_line(FND_FILE.log,errbuf);
1842: l_cp_return_status := 'ERROR';
1843: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1844: status => l_cp_return_status,
1845: message => 'Unexpected error during purge process');
1846: raise;
1847: