eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARI_DB_UTILITIES dependencies on FND_REQUEST

Line 1205: fnd_request.set_org_id(p_org_id);

1201: end if;
1202:
1203: fnd_global.apps_initialize(user_id, resp_id, appl_id, l_security_group_id, l_server_id);
1204: fnd_log_repository.init;
1205: fnd_request.set_org_id(p_org_id);
1206:
1207: -- arp_global.init_global;
1208:
1209: -- Bug 3933606

Line 1218: v_set_layout_option := fnd_request.add_layout(

1214:
1215: -- Bug 3957478 - Single notification for multiple print requests
1216: -- Notification here removed
1217: -- Added for bug 9005896
1218: v_set_layout_option := fnd_request.add_layout(
1219: template_appl_name => 'AR' --application
1220: ,template_code => 'RAXINV_SEL'
1221: ,template_language => 'en'
1222: ,template_territory => 'US'

Line 1229: l_request_id := fnd_request.submit_request('AR', 'RAXINV_SEL', l_program_name,

1225: IF ( NOT v_set_layout_option ) THEN
1226: fnd_file.put_line( fnd_file.log,'Unable to apply template');
1227: END IF;
1228:
1229: l_request_id := fnd_request.submit_request('AR', 'RAXINV_SEL', l_program_name,
1230: null, false, 'TRX_NUMBER','','','','',
1231: '','','',p_customer_id,'','N','N','','SEL','1',
1232: 'N','10',p_random_invoices_flag,p_invoice_list_string,'','','','','','',
1233: '','','','','','','','','','',

Line 1693: l_fnd_request_date DATE;

1689: p_creation_date in varchar2 ) IS
1690:
1691: l_cp_return_status VARCHAR2(10) :='NORMAL';
1692: l_procedure_name VARCHAR2(50);
1693: l_fnd_request_date DATE;
1694: l_return BOOLEAN;
1695: msgbuf VARCHAR2(2000);
1696: numrows NUMBER;
1697:

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 1707: l_fnd_request_date := FND_CONC_DATE.STRING_TO_DATE(p_creation_date); /* Convert character string to date */

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:
1710: l_cp_return_status := 'ERROR';
1711: errbuf := 'Unexpected error converting character string to date'||l_fnd_request_date;

Line 1708: if(l_fnd_request_date is NULL) then

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:
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(

Line 1711: errbuf := 'Unexpected error converting character string to date'||l_fnd_request_date;

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:
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:

Line 1725: fnd_message.set_token('DATE', l_fnd_request_date);

1721: end if;
1722:
1723: fnd_message.set_name('FND', 'PURGING_UP_TO_DATE');
1724: fnd_message.set_token('ENTITY', 'AR_IREC_PRINT_REQUESTS');
1725: fnd_message.set_token('DATE', l_fnd_request_date);
1726: msgbuf := fnd_message.get;
1727: FND_FILE.put_line(FND_FILE.log, msgbuf);
1728:
1729: select count(*) into numrows from ar_irec_print_requests where trunc(creation_date) < trunc(l_fnd_request_date);

Line 1729: select count(*) into numrows from ar_irec_print_requests where trunc(creation_date) < trunc(l_fnd_request_date);

1725: fnd_message.set_token('DATE', l_fnd_request_date);
1726: msgbuf := fnd_message.get;
1727: FND_FILE.put_line(FND_FILE.log, msgbuf);
1728:
1729: select count(*) into numrows from ar_irec_print_requests where trunc(creation_date) < trunc(l_fnd_request_date);
1730: delete from ar_irec_print_requests where trunc(creation_date) < trunc(l_fnd_request_date);
1731: commit;
1732:
1733: fnd_file.put_line( FND_FILE.LOG, '+---------------------------------------------------------------------------+');

Line 1730: delete from ar_irec_print_requests where trunc(creation_date) < trunc(l_fnd_request_date);

1726: msgbuf := fnd_message.get;
1727: FND_FILE.put_line(FND_FILE.log, msgbuf);
1728:
1729: select count(*) into numrows from ar_irec_print_requests where trunc(creation_date) < trunc(l_fnd_request_date);
1730: delete from ar_irec_print_requests where trunc(creation_date) < trunc(l_fnd_request_date);
1731: commit;
1732:
1733: fnd_file.put_line( FND_FILE.LOG, '+---------------------------------------------------------------------------+');
1734: