DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on FND_MESSAGE

Line 207: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');

203: l_header NUMBER := 0;
204:
205:
206: BEGIN
207: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
208: l_export_message := FND_MESSAGE.Get;
209:
210: WriteOutput(''||l_export_message||'-'||l_request_id||'

Web Analytics Made Easy -StatCounter
');
211:

Line 208: l_export_message := FND_MESSAGE.Get;

204:
205:
206: BEGIN
207: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
208: l_export_message := FND_MESSAGE.Get;
209:
210: WriteOutput(''||l_export_message||'-'||l_request_id||'

Web Analytics Made Easy -StatCounter
');
211:
212: /* WriteOutput('

'||l_export_message||' ('||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||')

');

Line 218: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');

214:
215: WriteOutput('

');
216: WriteOutput('

');
217: WriteOutput('');
218: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');
219: l_export_message := FND_MESSAGE.Get;
220: WriteOutput('');
221: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
222: l_export_message := FND_MESSAGE.Get;

Line 219: l_export_message := FND_MESSAGE.Get;

215: WriteOutput('

');
216: WriteOutput('

'||l_export_message||'
');
217: WriteOutput('');
218: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');
219: l_export_message := FND_MESSAGE.Get;
220: WriteOutput('');
221: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
222: l_export_message := FND_MESSAGE.Get;
223: WriteOutput('');

Line 221: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');

217: WriteOutput('

');
218: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');
219: l_export_message := FND_MESSAGE.Get;
220: WriteOutput('');
221: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
222: l_export_message := FND_MESSAGE.Get;
223: WriteOutput('');
224: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');
225: l_export_message := FND_MESSAGE.Get;

Line 222: l_export_message := FND_MESSAGE.Get;

218: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');
219: l_export_message := FND_MESSAGE.Get;
220: WriteOutput('

');
221: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
222: l_export_message := FND_MESSAGE.Get;
223: WriteOutput('');
224: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');
225: l_export_message := FND_MESSAGE.Get;
226: WriteOutput('');

Line 224: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');

220: WriteOutput('

');
221: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
222: l_export_message := FND_MESSAGE.Get;
223: WriteOutput('');
224: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');
225: l_export_message := FND_MESSAGE.Get;
226: WriteOutput('');
227: WriteOutput('');
228: WriteOutput('
'||l_export_message||''||l_export_message||'
'||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||''||l_export_message||' '||l_export_message||''||l_export_message||' '||l_export_message||'
');

Line 225: l_export_message := FND_MESSAGE.Get;

221: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
222: l_export_message := FND_MESSAGE.Get;
223: WriteOutput(''||l_export_message||'');
224: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');
225: l_export_message := FND_MESSAGE.Get;
226: WriteOutput(''||l_export_message||'');
227: WriteOutput('');
228: WriteOutput('');
229: WriteOutput('

');*/

Line 251: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_8');

247: IF(l_header > 0) THEN
248: WriteOutput('');
249: WriteOutput('

');
250: WriteOutput('');
251: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_8');
252: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
253: l_export_message := FND_MESSAGE.Get;
254: WriteOutput('');
255: WriteOutput('');

Line 252: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);

248: WriteOutput('

'||l_export_message||'
');
249: WriteOutput('
');
250: WriteOutput('');
251: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_8');
252: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
253: l_export_message := FND_MESSAGE.Get;
254: WriteOutput('');
255: WriteOutput('');
256: WriteOutput('');

Line 253: l_export_message := FND_MESSAGE.Get;

249: WriteOutput('

'||l_export_message||'
');
250: WriteOutput('');
251: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_8');
252: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
253: l_export_message := FND_MESSAGE.Get;
254: WriteOutput('');
255: WriteOutput('');
256: WriteOutput('');
257: WriteOutput('
'||l_export_message||'
');

Line 295: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');

291: END IF;
292: WriteOutput('

');
293: WriteOutput('');
294: WriteOutput('');
303: WriteOutput('
'||l_org_name||'');
295: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
296: l_export_message := FND_MESSAGE.Get;
297: WriteOutput('
'||l_export_message||'');
298: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
299: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');

Line 296: l_export_message := FND_MESSAGE.Get;

292: WriteOutput('

');
293: WriteOutput('');
294: WriteOutput('');
303: WriteOutput('
'||l_org_name||'');
295: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
296: l_export_message := FND_MESSAGE.Get;
297: WriteOutput('
'||l_export_message||'');
298: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
299: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');
300: l_export_message := FND_MESSAGE.Get;

Line 299: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');

295: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
296: l_export_message := FND_MESSAGE.Get;
297: WriteOutput('

'||l_export_message||'');
298: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
299: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');
300: l_export_message := FND_MESSAGE.Get;
301: WriteOutput('
'||l_export_message||':  '||l_page_count||'');
302: WriteOutput('
');

Line 300: l_export_message := FND_MESSAGE.Get;

296: l_export_message := FND_MESSAGE.Get;
297: WriteOutput('

'||l_export_message||'');
298: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
299: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');
300: l_export_message := FND_MESSAGE.Get;
301: WriteOutput('
'||l_export_message||':  '||l_page_count||'');
302: WriteOutput('
');
304: WriteOutput('

');

Line 305: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');

301: WriteOutput(''||l_export_message||':  '||l_page_count||'');
302: WriteOutput('');
303: WriteOutput('');
304: WriteOutput('

');
305: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');
306: l_export_message := FND_MESSAGE.Get;
307: WriteOutput('

'||l_export_message||'

');
308:
309: WriteOutput('
');

Line 306: l_export_message := FND_MESSAGE.Get;

302: WriteOutput('');
303: WriteOutput('

');
304: WriteOutput('

');
305: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');
306: l_export_message := FND_MESSAGE.Get;
307: WriteOutput('

'||l_export_message||'

');
308:
309: WriteOutput('
');
310: WriteOutput('');

Line 312: fnd_message.set_name('SQLAP', 'OIE_REP_EMPLOYEE_NAME');

308:
309: WriteOutput('

');
310: WriteOutput('');
311:
312: fnd_message.set_name('SQLAP', 'OIE_REP_EMPLOYEE_NAME');
313: l_export_message := FND_MESSAGE.Get;
314: WriteOutput('');
315:
316: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');

Line 313: l_export_message := FND_MESSAGE.Get;

309: WriteOutput('

'||l_export_message||'
');
310: WriteOutput('');
311:
312: fnd_message.set_name('SQLAP', 'OIE_REP_EMPLOYEE_NAME');
313: l_export_message := FND_MESSAGE.Get;
314: WriteOutput('');
315:
316: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');
317: l_export_message := FND_MESSAGE.Get;

Line 316: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');

312: fnd_message.set_name('SQLAP', 'OIE_REP_EMPLOYEE_NAME');
313: l_export_message := FND_MESSAGE.Get;
314: WriteOutput('

');
315:
316: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');
317: l_export_message := FND_MESSAGE.Get;
318: WriteOutput('');
319:
320: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');

Line 317: l_export_message := FND_MESSAGE.Get;

313: l_export_message := FND_MESSAGE.Get;
314: WriteOutput('

');
315:
316: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');
317: l_export_message := FND_MESSAGE.Get;
318: WriteOutput('');
319:
320: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
321: l_export_message := FND_MESSAGE.Get;

Line 320: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');

316: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');
317: l_export_message := FND_MESSAGE.Get;
318: WriteOutput('

');
319:
320: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
321: l_export_message := FND_MESSAGE.Get;
322: WriteOutput('');
323:
324: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');

Line 321: l_export_message := FND_MESSAGE.Get;

317: l_export_message := FND_MESSAGE.Get;
318: WriteOutput('

');
319:
320: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
321: l_export_message := FND_MESSAGE.Get;
322: WriteOutput('');
323:
324: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
325: l_export_message := FND_MESSAGE.Get;

Line 324: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');

320: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
321: l_export_message := FND_MESSAGE.Get;
322: WriteOutput('

');
323:
324: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
325: l_export_message := FND_MESSAGE.Get;
326: WriteOutput('');
327:
328: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');

Line 325: l_export_message := FND_MESSAGE.Get;

321: l_export_message := FND_MESSAGE.Get;
322: WriteOutput('

');
323:
324: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
325: l_export_message := FND_MESSAGE.Get;
326: WriteOutput('');
327:
328: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
329: l_export_message := FND_MESSAGE.Get;

Line 328: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');

324: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
325: l_export_message := FND_MESSAGE.Get;
326: WriteOutput('

');
327:
328: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
329: l_export_message := FND_MESSAGE.Get;
330: WriteOutput('');
331:
332: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');

Line 329: l_export_message := FND_MESSAGE.Get;

325: l_export_message := FND_MESSAGE.Get;
326: WriteOutput('

');
327:
328: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
329: l_export_message := FND_MESSAGE.Get;
330: WriteOutput('');
331:
332: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');
333: l_export_message := FND_MESSAGE.Get;

Line 332: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');

328: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
329: l_export_message := FND_MESSAGE.Get;
330: WriteOutput('

');
331:
332: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');
333: l_export_message := FND_MESSAGE.Get;
334: WriteOutput('');
335:
336: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');

Line 333: l_export_message := FND_MESSAGE.Get;

329: l_export_message := FND_MESSAGE.Get;
330: WriteOutput('

');
331:
332: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');
333: l_export_message := FND_MESSAGE.Get;
334: WriteOutput('');
335:
336: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
337: l_export_message := FND_MESSAGE.Get;

Line 336: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');

332: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');
333: l_export_message := FND_MESSAGE.Get;
334: WriteOutput('

');
335:
336: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
337: l_export_message := FND_MESSAGE.Get;
338: WriteOutput('');
339:
340: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');

Line 337: l_export_message := FND_MESSAGE.Get;

333: l_export_message := FND_MESSAGE.Get;
334: WriteOutput('

');
335:
336: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
337: l_export_message := FND_MESSAGE.Get;
338: WriteOutput('');
339:
340: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
341: l_export_message := FND_MESSAGE.Get;

Line 340: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');

336: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
337: l_export_message := FND_MESSAGE.Get;
338: WriteOutput('

');
339:
340: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
341: l_export_message := FND_MESSAGE.Get;
342: WriteOutput('');
343:
344: fnd_message.set_name('SQLAP', 'AP_ALL_REPORTS_DESCRIPTION');

Line 341: l_export_message := FND_MESSAGE.Get;

337: l_export_message := FND_MESSAGE.Get;
338: WriteOutput('

');
339:
340: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
341: l_export_message := FND_MESSAGE.Get;
342: WriteOutput('');
343:
344: fnd_message.set_name('SQLAP', 'AP_ALL_REPORTS_DESCRIPTION');
345: l_export_message := FND_MESSAGE.Get;

Line 344: fnd_message.set_name('SQLAP', 'AP_ALL_REPORTS_DESCRIPTION');

340: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
341: l_export_message := FND_MESSAGE.Get;
342: WriteOutput('

');
343:
344: fnd_message.set_name('SQLAP', 'AP_ALL_REPORTS_DESCRIPTION');
345: l_export_message := FND_MESSAGE.Get;
346: WriteOutput('');
347:
348: fnd_message.set_name('SQLAP', 'AP_ACTION_LIST_HOLD');

Line 345: l_export_message := FND_MESSAGE.Get;

341: l_export_message := FND_MESSAGE.Get;
342: WriteOutput('

');
343:
344: fnd_message.set_name('SQLAP', 'AP_ALL_REPORTS_DESCRIPTION');
345: l_export_message := FND_MESSAGE.Get;
346: WriteOutput('');
347:
348: fnd_message.set_name('SQLAP', 'AP_ACTION_LIST_HOLD');
349: l_export_message := FND_MESSAGE.Get;

Line 348: fnd_message.set_name('SQLAP', 'AP_ACTION_LIST_HOLD');

344: fnd_message.set_name('SQLAP', 'AP_ALL_REPORTS_DESCRIPTION');
345: l_export_message := FND_MESSAGE.Get;
346: WriteOutput('

');
347:
348: fnd_message.set_name('SQLAP', 'AP_ACTION_LIST_HOLD');
349: l_export_message := FND_MESSAGE.Get;
350: WriteOutput('');
351: WriteOutput('');
352: END IF;

Line 349: l_export_message := FND_MESSAGE.Get;

345: l_export_message := FND_MESSAGE.Get;
346: WriteOutput('

');
347:
348: fnd_message.set_name('SQLAP', 'AP_ACTION_LIST_HOLD');
349: l_export_message := FND_MESSAGE.Get;
350: WriteOutput('');
351: WriteOutput('');
352: END IF;
353:

Line 381: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_8');

377: IF(l_header > 0) THEN
378: WriteOutput('

'||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||'
'||l_export_message||' '||l_export_message||'
');
379: WriteOutput('
');
380: WriteOutput('');
381: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_8');
382: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
383: l_export_message := FND_MESSAGE.Get;
384: WriteOutput('');
385: WriteOutput('');

Line 382: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);

378: WriteOutput('

'||l_export_message||'
');
379: WriteOutput('
');
380: WriteOutput('');
381: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_8');
382: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
383: l_export_message := FND_MESSAGE.Get;
384: WriteOutput('');
385: WriteOutput('');
386: WriteOutput('');

Line 383: l_export_message := FND_MESSAGE.Get;

379: WriteOutput('

'||l_export_message||'
');
380: WriteOutput('');
381: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_8');
382: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
383: l_export_message := FND_MESSAGE.Get;
384: WriteOutput('');
385: WriteOutput('');
386: WriteOutput('');
387: WriteOutput('
'||l_export_message||'
');

Line 390: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_7');

386: WriteOutput('');
387: WriteOutput('');
388: END IF;
389: IF(l_count > 0) THEN
390: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_7');
391: FND_MESSAGE.SET_TOKEN('COUNT', l_count);
392: l_export_message := FND_MESSAGE.Get;
393: WriteOutput('

');
394: WriteOutput('');

Line 391: FND_MESSAGE.SET_TOKEN('COUNT', l_count);

387: WriteOutput('

');
388: END IF;
389: IF(l_count > 0) THEN
390: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_7');
391: FND_MESSAGE.SET_TOKEN('COUNT', l_count);
392: l_export_message := FND_MESSAGE.Get;
393: WriteOutput('
');
394: WriteOutput('');
395: WriteOutput('');

Line 392: l_export_message := FND_MESSAGE.Get;

388: END IF;
389: IF(l_count > 0) THEN
390: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_7');
391: FND_MESSAGE.SET_TOKEN('COUNT', l_count);
392: l_export_message := FND_MESSAGE.Get;
393: WriteOutput('

'||l_export_message||'
');
394: WriteOutput('');
395: WriteOutput('');
396: WriteOutput('');

Line 403: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');

399: WriteOutput('');
400: WriteOutput('

'||l_export_message||'
');
401: WriteOutput('

');
402: ELSE
403: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');
404: l_export_message := FND_MESSAGE.Get;
405: WriteOutput('

'||l_export_message||'

');
406: WriteOutput('
');
407: WriteOutput('');

Line 404: l_export_message := FND_MESSAGE.Get;

400: WriteOutput('

');
401: WriteOutput('

');
402: ELSE
403: fnd_message.set_name('SQLAP', 'AP_APXXTR_IMPORT_9');
404: l_export_message := FND_MESSAGE.Get;
405: WriteOutput('

'||l_export_message||'

');
406: WriteOutput('
');
407: WriteOutput('');
408: WriteOutput('');

Line 409: fnd_message.set_name('SQLAP', 'OIE_NO_REPORT_SELECTED');

405: WriteOutput('

'||l_export_message||'

');
406: WriteOutput('

');
407: WriteOutput('');
408: WriteOutput('');
409: fnd_message.set_name('SQLAP', 'OIE_NO_REPORT_SELECTED');
410: l_export_message := FND_MESSAGE.Get;
411: WriteOutput('');
412: WriteOutput('');
413: WriteOutput('');

Line 410: l_export_message := FND_MESSAGE.Get;

406: WriteOutput('


'||l_export_message||'
');
407: WriteOutput('');
408: WriteOutput('');
409: fnd_message.set_name('SQLAP', 'OIE_NO_REPORT_SELECTED');
410: l_export_message := FND_MESSAGE.Get;
411: WriteOutput('');
412: WriteOutput('');
413: WriteOutput('');
414: WriteOutput('');

Line 438: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_7');

434: IF(l_header > 0) THEN
435: WriteOutput('


'||l_export_message||'
');
436: WriteOutput('
');
437: WriteOutput('');
438: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_7');
439: l_export_message := FND_MESSAGE.Get;
440: WriteOutput('');
441: WriteOutput('');
442: WriteOutput('');

Line 439: l_export_message := FND_MESSAGE.Get;

435: WriteOutput('

'||l_export_message||' ' || l_total_func_amount || '
');
436: WriteOutput('
');
437: WriteOutput('');
438: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_7');
439: l_export_message := FND_MESSAGE.Get;
440: WriteOutput('');
441: WriteOutput('');
442: WriteOutput('');
443: WriteOutput('
'||l_export_message||' ' || l_total_func_amount || '
');

Line 481: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');

477: END IF;
478: WriteOutput('

');
479: WriteOutput('');
480: WriteOutput('');
489: WriteOutput('
'||l_org_name||'');
481: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
482: l_export_message := FND_MESSAGE.Get;
483: WriteOutput('
'||l_export_message||'');
484: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
485: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');

Line 482: l_export_message := FND_MESSAGE.Get;

478: WriteOutput('

');
479: WriteOutput('');
480: WriteOutput('');
489: WriteOutput('
'||l_org_name||'');
481: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
482: l_export_message := FND_MESSAGE.Get;
483: WriteOutput('
'||l_export_message||'');
484: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
485: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');
486: l_export_message := FND_MESSAGE.Get;

Line 485: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');

481: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
482: l_export_message := FND_MESSAGE.Get;
483: WriteOutput('

'||l_export_message||'');
484: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
485: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');
486: l_export_message := FND_MESSAGE.Get;
487: WriteOutput('
'||l_export_message||':  '||l_page_count||'');
488: WriteOutput('
');

Line 486: l_export_message := FND_MESSAGE.Get;

482: l_export_message := FND_MESSAGE.Get;
483: WriteOutput('

'||l_export_message||'');
484: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
485: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');
486: l_export_message := FND_MESSAGE.Get;
487: WriteOutput('
'||l_export_message||':  '||l_page_count||'');
488: WriteOutput('
');
490: WriteOutput('

');

Line 491: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');

487: WriteOutput(''||l_export_message||':  '||l_page_count||'');
488: WriteOutput('');
489: WriteOutput('');
490: WriteOutput('

');
491: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
492: l_export_message := FND_MESSAGE.Get;
493: WriteOutput('

'||l_export_message||'

');
494:
495: WriteOutput('
');

Line 492: l_export_message := FND_MESSAGE.Get;

488: WriteOutput('');
489: WriteOutput('

');
490: WriteOutput('

');
491: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
492: l_export_message := FND_MESSAGE.Get;
493: WriteOutput('

'||l_export_message||'

');
494:
495: WriteOutput('
');
496: WriteOutput('');

Line 497: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');

493: WriteOutput('

'||l_export_message||'

');
494:
495: WriteOutput('
');
496: WriteOutput('');
497: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
498: l_export_message := FND_MESSAGE.Get;
499: WriteOutput('');
500:
501: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');

Line 498: l_export_message := FND_MESSAGE.Get;

494:
495: WriteOutput('

'||l_export_message||'
');
496: WriteOutput('');
497: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
498: l_export_message := FND_MESSAGE.Get;
499: WriteOutput('');
500:
501: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
502: l_export_message := FND_MESSAGE.Get;

Line 501: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');

497: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
498: l_export_message := FND_MESSAGE.Get;
499: WriteOutput('

');
500:
501: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
502: l_export_message := FND_MESSAGE.Get;
503: WriteOutput('');
504:
505: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');

Line 502: l_export_message := FND_MESSAGE.Get;

498: l_export_message := FND_MESSAGE.Get;
499: WriteOutput('

');
500:
501: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
502: l_export_message := FND_MESSAGE.Get;
503: WriteOutput('');
504:
505: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
506: l_export_message := FND_MESSAGE.Get;

Line 505: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');

501: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
502: l_export_message := FND_MESSAGE.Get;
503: WriteOutput('

');
504:
505: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
506: l_export_message := FND_MESSAGE.Get;
507: WriteOutput('');
508:
509: fnd_message.set_name('SQLAP', 'OIE_PREPAY_NUMBER');

Line 506: l_export_message := FND_MESSAGE.Get;

502: l_export_message := FND_MESSAGE.Get;
503: WriteOutput('

');
504:
505: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
506: l_export_message := FND_MESSAGE.Get;
507: WriteOutput('');
508:
509: fnd_message.set_name('SQLAP', 'OIE_PREPAY_NUMBER');
510: l_export_message := FND_MESSAGE.Get;

Line 509: fnd_message.set_name('SQLAP', 'OIE_PREPAY_NUMBER');

505: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
506: l_export_message := FND_MESSAGE.Get;
507: WriteOutput('

');
508:
509: fnd_message.set_name('SQLAP', 'OIE_PREPAY_NUMBER');
510: l_export_message := FND_MESSAGE.Get;
511: WriteOutput('');
512:
513: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');

Line 510: l_export_message := FND_MESSAGE.Get;

506: l_export_message := FND_MESSAGE.Get;
507: WriteOutput('

');
508:
509: fnd_message.set_name('SQLAP', 'OIE_PREPAY_NUMBER');
510: l_export_message := FND_MESSAGE.Get;
511: WriteOutput('');
512:
513: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
514: l_export_message := FND_MESSAGE.Get;

Line 513: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');

509: fnd_message.set_name('SQLAP', 'OIE_PREPAY_NUMBER');
510: l_export_message := FND_MESSAGE.Get;
511: WriteOutput('

');
512:
513: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
514: l_export_message := FND_MESSAGE.Get;
515: WriteOutput('');
516:
517: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');

Line 514: l_export_message := FND_MESSAGE.Get;

510: l_export_message := FND_MESSAGE.Get;
511: WriteOutput('

');
512:
513: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
514: l_export_message := FND_MESSAGE.Get;
515: WriteOutput('');
516:
517: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
518: l_export_message := FND_MESSAGE.Get;

Line 517: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');

513: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
514: l_export_message := FND_MESSAGE.Get;
515: WriteOutput('

');
516:
517: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
518: l_export_message := FND_MESSAGE.Get;
519: WriteOutput('');
520:
521: fnd_message.set_name('SQLAP', 'OIE_AMOUNT_APPLIED');

Line 518: l_export_message := FND_MESSAGE.Get;

514: l_export_message := FND_MESSAGE.Get;
515: WriteOutput('

');
516:
517: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
518: l_export_message := FND_MESSAGE.Get;
519: WriteOutput('');
520:
521: fnd_message.set_name('SQLAP', 'OIE_AMOUNT_APPLIED');
522: l_export_message := FND_MESSAGE.Get;

Line 521: fnd_message.set_name('SQLAP', 'OIE_AMOUNT_APPLIED');

517: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
518: l_export_message := FND_MESSAGE.Get;
519: WriteOutput('

');
520:
521: fnd_message.set_name('SQLAP', 'OIE_AMOUNT_APPLIED');
522: l_export_message := FND_MESSAGE.Get;
523: WriteOutput('');
524:
525: fnd_message.set_name('SQLAP', 'OIE_INV_AMOUNT_REM');

Line 522: l_export_message := FND_MESSAGE.Get;

518: l_export_message := FND_MESSAGE.Get;
519: WriteOutput('

');
520:
521: fnd_message.set_name('SQLAP', 'OIE_AMOUNT_APPLIED');
522: l_export_message := FND_MESSAGE.Get;
523: WriteOutput('');
524:
525: fnd_message.set_name('SQLAP', 'OIE_INV_AMOUNT_REM');
526: l_export_message := FND_MESSAGE.Get;

Line 525: fnd_message.set_name('SQLAP', 'OIE_INV_AMOUNT_REM');

521: fnd_message.set_name('SQLAP', 'OIE_AMOUNT_APPLIED');
522: l_export_message := FND_MESSAGE.Get;
523: WriteOutput('

');
524:
525: fnd_message.set_name('SQLAP', 'OIE_INV_AMOUNT_REM');
526: l_export_message := FND_MESSAGE.Get;
527: WriteOutput('');
528:
529: fnd_message.set_name('SQLAP', 'OIE_PREPAY_AMT_AVAILABLE');

Line 526: l_export_message := FND_MESSAGE.Get;

522: l_export_message := FND_MESSAGE.Get;
523: WriteOutput('

');
524:
525: fnd_message.set_name('SQLAP', 'OIE_INV_AMOUNT_REM');
526: l_export_message := FND_MESSAGE.Get;
527: WriteOutput('');
528:
529: fnd_message.set_name('SQLAP', 'OIE_PREPAY_AMT_AVAILABLE');
530: l_export_message := FND_MESSAGE.Get;

Line 529: fnd_message.set_name('SQLAP', 'OIE_PREPAY_AMT_AVAILABLE');

525: fnd_message.set_name('SQLAP', 'OIE_INV_AMOUNT_REM');
526: l_export_message := FND_MESSAGE.Get;
527: WriteOutput('

');
528:
529: fnd_message.set_name('SQLAP', 'OIE_PREPAY_AMT_AVAILABLE');
530: l_export_message := FND_MESSAGE.Get;
531: WriteOutput('');
532:
533: WriteOutput('');

Line 530: l_export_message := FND_MESSAGE.Get;

526: l_export_message := FND_MESSAGE.Get;
527: WriteOutput('

');
528:
529: fnd_message.set_name('SQLAP', 'OIE_PREPAY_AMT_AVAILABLE');
530: l_export_message := FND_MESSAGE.Get;
531: WriteOutput('');
532:
533: WriteOutput('');
534:

Line 562: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_7');

558: IF(l_header > 0) THEN
559: WriteOutput('

'||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||'
'||l_export_message||' '||l_export_message||'
');
560: WriteOutput('
');
561: WriteOutput('');
562: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_7');
563: l_export_message := FND_MESSAGE.Get;
564: WriteOutput('');
565: WriteOutput('');
566: WriteOutput('');

Line 563: l_export_message := FND_MESSAGE.Get;

559: WriteOutput('

'||l_export_message||' ' || l_total_func_amount || '
');
560: WriteOutput('
');
561: WriteOutput('');
562: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_7');
563: l_export_message := FND_MESSAGE.Get;
564: WriteOutput('');
565: WriteOutput('');
566: WriteOutput('');
567: WriteOutput('
'||l_export_message||' ' || l_total_func_amount || '
');

Line 572: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_6');

568: END IF;
569:
570: --WriteOutput('');
571: IF(l_count > 0) THEN
572: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_6');
573: FND_MESSAGE.SET_TOKEN('COUNT', l_count);
574: l_export_message := FND_MESSAGE.Get;
575: WriteOutput('

');
576: WriteOutput('');

Line 573: FND_MESSAGE.SET_TOKEN('COUNT', l_count);

569:
570: --WriteOutput('

');
571: IF(l_count > 0) THEN
572: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_6');
573: FND_MESSAGE.SET_TOKEN('COUNT', l_count);
574: l_export_message := FND_MESSAGE.Get;
575: WriteOutput('
');
576: WriteOutput('');
577: WriteOutput('');

Line 574: l_export_message := FND_MESSAGE.Get;

570: --WriteOutput('

'||l_export_message||'
');
571: IF(l_count > 0) THEN
572: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_6');
573: FND_MESSAGE.SET_TOKEN('COUNT', l_count);
574: l_export_message := FND_MESSAGE.Get;
575: WriteOutput('
');
576: WriteOutput('');
577: WriteOutput('');
578: WriteOutput('');

Line 585: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');

581: WriteOutput('');
582: WriteOutput('

'||l_export_message||'
');
583: WriteOutput('

');
584: ELSE
585: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
586: l_export_message := FND_MESSAGE.Get;
587: WriteOutput('

'||l_export_message||'

');
588: WriteOutput('
');
589: WriteOutput('');

Line 586: l_export_message := FND_MESSAGE.Get;

582: WriteOutput('

');
583: WriteOutput('

');
584: ELSE
585: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
586: l_export_message := FND_MESSAGE.Get;
587: WriteOutput('

'||l_export_message||'

');
588: WriteOutput('
');
589: WriteOutput('');
590: WriteOutput('');

Line 591: fnd_message.set_name('SQLAP', 'OIE_NO_PREPAY_APPLIED');

587: WriteOutput('

'||l_export_message||'

');
588: WriteOutput('

');
589: WriteOutput('');
590: WriteOutput('');
591: fnd_message.set_name('SQLAP', 'OIE_NO_PREPAY_APPLIED');
592: l_export_message := FND_MESSAGE.Get;
593: WriteOutput('');
594: WriteOutput('');
595: WriteOutput('');

Line 592: l_export_message := FND_MESSAGE.Get;

588: WriteOutput('


'||l_export_message||'
');
589: WriteOutput('');
590: WriteOutput('');
591: fnd_message.set_name('SQLAP', 'OIE_NO_PREPAY_APPLIED');
592: l_export_message := FND_MESSAGE.Get;
593: WriteOutput('');
594: WriteOutput('');
595: WriteOutput('');
596: WriteOutput('');

Line 620: fnd_message.set_name('SQLAP', 'OIE_FUNC_AMT_REJECTED');

616: IF(l_header > 0) THEN
617: WriteOutput('


'||l_export_message||'
');
618: WriteOutput('
');
619: WriteOutput('');
620: fnd_message.set_name('SQLAP', 'OIE_FUNC_AMT_REJECTED');
621: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
622: l_export_message := FND_MESSAGE.Get;
623: WriteOutput('');
624: WriteOutput('');

Line 621: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);

617: WriteOutput('

'||l_export_message||'
');
618: WriteOutput('
');
619: WriteOutput('');
620: fnd_message.set_name('SQLAP', 'OIE_FUNC_AMT_REJECTED');
621: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
622: l_export_message := FND_MESSAGE.Get;
623: WriteOutput('');
624: WriteOutput('');
625: WriteOutput('');

Line 622: l_export_message := FND_MESSAGE.Get;

618: WriteOutput('

'||l_export_message||'
');
619: WriteOutput('');
620: fnd_message.set_name('SQLAP', 'OIE_FUNC_AMT_REJECTED');
621: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
622: l_export_message := FND_MESSAGE.Get;
623: WriteOutput('');
624: WriteOutput('');
625: WriteOutput('');
626: WriteOutput('
'||l_export_message||'
');

Line 664: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');

660:
661: WriteOutput('

');
662: WriteOutput('');
663: WriteOutput('');
672: WriteOutput('
'||l_org_name||'');
664: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
665: l_export_message := FND_MESSAGE.Get;
666: WriteOutput('
'||l_export_message||'');
667: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
668: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');

Line 665: l_export_message := FND_MESSAGE.Get;

661: WriteOutput('

');
662: WriteOutput('');
663: WriteOutput('');
672: WriteOutput('
'||l_org_name||'');
664: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
665: l_export_message := FND_MESSAGE.Get;
666: WriteOutput('
'||l_export_message||'');
667: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
668: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');
669: l_export_message := FND_MESSAGE.Get;

Line 668: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');

664: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
665: l_export_message := FND_MESSAGE.Get;
666: WriteOutput('

'||l_export_message||'');
667: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
668: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');
669: l_export_message := FND_MESSAGE.Get;
670: WriteOutput('
'||l_export_message||':  '||l_page_count||'');
671: WriteOutput('
');

Line 669: l_export_message := FND_MESSAGE.Get;

665: l_export_message := FND_MESSAGE.Get;
666: WriteOutput('

'||l_export_message||'');
667: WriteOutput('
'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||'');
668: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE');
669: l_export_message := FND_MESSAGE.Get;
670: WriteOutput('
'||l_export_message||':  '||l_page_count||'');
671: WriteOutput('
');
673: WriteOutput('

');

Line 674: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');

670: WriteOutput(''||l_export_message||':  '||l_page_count||'');
671: WriteOutput('');
672: WriteOutput('');
673: WriteOutput('

');
674: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');
675: l_export_message := FND_MESSAGE.Get;
676: WriteOutput('

'||l_export_message||'

');
677:
678: WriteOutput('
');

Line 675: l_export_message := FND_MESSAGE.Get;

671: WriteOutput('');
672: WriteOutput('

');
673: WriteOutput('

');
674: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');
675: l_export_message := FND_MESSAGE.Get;
676: WriteOutput('

'||l_export_message||'

');
677:
678: WriteOutput('
');
679: WriteOutput('');

Line 681: fnd_message.set_name('SQLAP', 'OIE_REP_EMPLOYEE_NAME');

677:
678: WriteOutput('

');
679: WriteOutput('');
680:
681: fnd_message.set_name('SQLAP', 'OIE_REP_EMPLOYEE_NAME');
682: l_export_message := FND_MESSAGE.Get;
683: WriteOutput('');
684:
685: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');

Line 682: l_export_message := FND_MESSAGE.Get;

678: WriteOutput('

'||l_export_message||'
');
679: WriteOutput('');
680:
681: fnd_message.set_name('SQLAP', 'OIE_REP_EMPLOYEE_NAME');
682: l_export_message := FND_MESSAGE.Get;
683: WriteOutput('');
684:
685: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');
686: l_export_message := FND_MESSAGE.Get;

Line 685: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');

681: fnd_message.set_name('SQLAP', 'OIE_REP_EMPLOYEE_NAME');
682: l_export_message := FND_MESSAGE.Get;
683: WriteOutput('

');
684:
685: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');
686: l_export_message := FND_MESSAGE.Get;
687: WriteOutput('');
688:
689: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');

Line 686: l_export_message := FND_MESSAGE.Get;

682: l_export_message := FND_MESSAGE.Get;
683: WriteOutput('

');
684:
685: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');
686: l_export_message := FND_MESSAGE.Get;
687: WriteOutput('');
688:
689: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
690: l_export_message := FND_MESSAGE.Get;

Line 689: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');

685: fnd_message.set_name('SQLAP', 'OIE_EMPLOYEE_NUMBER');
686: l_export_message := FND_MESSAGE.Get;
687: WriteOutput('

');
688:
689: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
690: l_export_message := FND_MESSAGE.Get;
691: WriteOutput('');
692:
693: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');

Line 690: l_export_message := FND_MESSAGE.Get;

686: l_export_message := FND_MESSAGE.Get;
687: WriteOutput('

');
688:
689: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
690: l_export_message := FND_MESSAGE.Get;
691: WriteOutput('');
692:
693: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
694: l_export_message := FND_MESSAGE.Get;

Line 693: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');

689: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NAME');
690: l_export_message := FND_MESSAGE.Get;
691: WriteOutput('

');
692:
693: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
694: l_export_message := FND_MESSAGE.Get;
695: WriteOutput('');
696:
697: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');

Line 694: l_export_message := FND_MESSAGE.Get;

690: l_export_message := FND_MESSAGE.Get;
691: WriteOutput('

');
692:
693: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
694: l_export_message := FND_MESSAGE.Get;
695: WriteOutput('');
696:
697: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
698: l_export_message := FND_MESSAGE.Get;

Line 697: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');

693: fnd_message.set_name('SQLAP', 'OIE_SUPPLIER_NUMBER');
694: l_export_message := FND_MESSAGE.Get;
695: WriteOutput('

');
696:
697: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
698: l_export_message := FND_MESSAGE.Get;
699: WriteOutput('');
700:
701: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');

Line 698: l_export_message := FND_MESSAGE.Get;

694: l_export_message := FND_MESSAGE.Get;
695: WriteOutput('

');
696:
697: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
698: l_export_message := FND_MESSAGE.Get;
699: WriteOutput('');
700:
701: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');
702: l_export_message := FND_MESSAGE.Get;

Line 701: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');

697: fnd_message.set_name('SQLAP', 'OIE_INVOICE_NUMBER');
698: l_export_message := FND_MESSAGE.Get;
699: WriteOutput('

');
700:
701: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');
702: l_export_message := FND_MESSAGE.Get;
703: WriteOutput('');
704:
705: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');

Line 702: l_export_message := FND_MESSAGE.Get;

698: l_export_message := FND_MESSAGE.Get;
699: WriteOutput('

');
700:
701: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');
702: l_export_message := FND_MESSAGE.Get;
703: WriteOutput('');
704:
705: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
706: l_export_message := FND_MESSAGE.Get;

Line 705: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');

701: fnd_message.set_name('SQLAP', 'OIE_INVOICE_DATE');
702: l_export_message := FND_MESSAGE.Get;
703: WriteOutput('

');
704:
705: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
706: l_export_message := FND_MESSAGE.Get;
707: WriteOutput('');
708:
709: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');

Line 706: l_export_message := FND_MESSAGE.Get;

702: l_export_message := FND_MESSAGE.Get;
703: WriteOutput('

');
704:
705: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
706: l_export_message := FND_MESSAGE.Get;
707: WriteOutput('');
708:
709: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
710: l_export_message := FND_MESSAGE.Get;

Line 709: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');

705: fnd_message.set_name('SQLAP', 'OIE_INVOICE_CURRENCY');
706: l_export_message := FND_MESSAGE.Get;
707: WriteOutput('

');
708:
709: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
710: l_export_message := FND_MESSAGE.Get;
711: WriteOutput('');
712:
713: fnd_message.set_name('SQLAP', 'OIE_REJECTION_REASON');

Line 710: l_export_message := FND_MESSAGE.Get;

706: l_export_message := FND_MESSAGE.Get;
707: WriteOutput('

');
708:
709: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
710: l_export_message := FND_MESSAGE.Get;
711: WriteOutput('');
712:
713: fnd_message.set_name('SQLAP', 'OIE_REJECTION_REASON');
714: l_export_message := FND_MESSAGE.Get;

Line 713: fnd_message.set_name('SQLAP', 'OIE_REJECTION_REASON');

709: fnd_message.set_name('SQLAP', 'OIE_INVOICE_AMOUNT');
710: l_export_message := FND_MESSAGE.Get;
711: WriteOutput('

');
712:
713: fnd_message.set_name('SQLAP', 'OIE_REJECTION_REASON');
714: l_export_message := FND_MESSAGE.Get;
715: WriteOutput('');
716:
717: WriteOutput('');

Line 714: l_export_message := FND_MESSAGE.Get;

710: l_export_message := FND_MESSAGE.Get;
711: WriteOutput('

');
712:
713: fnd_message.set_name('SQLAP', 'OIE_REJECTION_REASON');
714: l_export_message := FND_MESSAGE.Get;
715: WriteOutput('');
716:
717: WriteOutput('');
718:

Line 747: fnd_message.set_name('SQLAP', 'OIE_FUNC_AMT_REJECTED');

743: IF(l_header > 0) THEN
744: WriteOutput('

'||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||' '||l_export_message||'
'||l_export_message||' '||l_export_message||'
');
745: WriteOutput('
');
746: WriteOutput('');
747: fnd_message.set_name('SQLAP', 'OIE_FUNC_AMT_REJECTED');
748: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
749: l_export_message := FND_MESSAGE.Get;
750: WriteOutput('');
751: WriteOutput('');

Line 748: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);

744: WriteOutput('

'||l_export_message||'
');
745: WriteOutput('
');
746: WriteOutput('');
747: fnd_message.set_name('SQLAP', 'OIE_FUNC_AMT_REJECTED');
748: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
749: l_export_message := FND_MESSAGE.Get;
750: WriteOutput('');
751: WriteOutput('');
752: WriteOutput('');

Line 749: l_export_message := FND_MESSAGE.Get;

745: WriteOutput('

'||l_export_message||'
');
746: WriteOutput('');
747: fnd_message.set_name('SQLAP', 'OIE_FUNC_AMT_REJECTED');
748: FND_MESSAGE.SET_TOKEN('AMOUNT', l_total_func_amount);
749: l_export_message := FND_MESSAGE.Get;
750: WriteOutput('');
751: WriteOutput('');
752: WriteOutput('');
753: WriteOutput('
'||l_export_message||'
');

Line 756: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_5');

752: WriteOutput('');
753: WriteOutput('');
754: END IF;
755: IF(l_count > 0) THEN
756: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_5');
757: FND_MESSAGE.SET_TOKEN('COUNT', l_count);
758: l_export_message := FND_MESSAGE.Get;
759: WriteOutput('

');
760: WriteOutput('');

Line 757: FND_MESSAGE.SET_TOKEN('COUNT', l_count);

753: WriteOutput('

');
754: END IF;
755: IF(l_count > 0) THEN
756: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_5');
757: FND_MESSAGE.SET_TOKEN('COUNT', l_count);
758: l_export_message := FND_MESSAGE.Get;
759: WriteOutput('
');
760: WriteOutput('');
761: WriteOutput('');

Line 758: l_export_message := FND_MESSAGE.Get;

754: END IF;
755: IF(l_count > 0) THEN
756: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_5');
757: FND_MESSAGE.SET_TOKEN('COUNT', l_count);
758: l_export_message := FND_MESSAGE.Get;
759: WriteOutput('

'||l_export_message||'
');
760: WriteOutput('');
761: WriteOutput('');
762: WriteOutput('');

Line 766: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');

762: WriteOutput('');
763: WriteOutput('

'||l_export_message||'
');
764: WriteOutput('

');
765: ELSE
766: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');
767: l_export_message := FND_MESSAGE.Get;
768: WriteOutput('

'||l_export_message||'

');
769: WriteOutput('
');
770: WriteOutput('');

Line 767: l_export_message := FND_MESSAGE.Get;

763: WriteOutput('

');
764: WriteOutput('

');
765: ELSE
766: fnd_message.set_name('SQLAP', 'AP_APXXTR_EXCEPT_1');
767: l_export_message := FND_MESSAGE.Get;
768: WriteOutput('

'||l_export_message||'

');
769: WriteOutput('
');
770: WriteOutput('');
771: WriteOutput('');

Line 772: fnd_message.set_name('SQLAP', 'OIE_NO_REPORT_REJECTED');

768: WriteOutput('

'||l_export_message||'

');
769: WriteOutput('

');
770: WriteOutput('');
771: WriteOutput('');
772: fnd_message.set_name('SQLAP', 'OIE_NO_REPORT_REJECTED');
773: l_export_message := FND_MESSAGE.Get;
774: WriteOutput('');
775: WriteOutput('');
776: WriteOutput('');

Line 773: l_export_message := FND_MESSAGE.Get;

769: WriteOutput('


'||l_export_message||'
');
770: WriteOutput('');
771: WriteOutput('');
772: fnd_message.set_name('SQLAP', 'OIE_NO_REPORT_REJECTED');
773: l_export_message := FND_MESSAGE.Get;
774: WriteOutput('');
775: WriteOutput('');
776: WriteOutput('');
777: WriteOutput('');

Line 1934: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_REMITTANCE_DESC');

1930: IF g_debug_switch = 'Y' THEN
1931: fnd_file.put_line(fnd_file.log, l_debug_info);
1932: END IF;
1933:
1934: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_REMITTANCE_DESC');
1935: FND_MESSAGE.Set_Token('PAID_ON_BEHALF_OF', l_invoice_rec.name);
1936: FND_MESSAGE.Set_Token('INVOICE_DESCRIPTION',
1937: l_invoice_rec.description);
1938: l_description := FND_MESSAGE.GET;

Line 1935: FND_MESSAGE.Set_Token('PAID_ON_BEHALF_OF', l_invoice_rec.name);

1931: fnd_file.put_line(fnd_file.log, l_debug_info);
1932: END IF;
1933:
1934: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_REMITTANCE_DESC');
1935: FND_MESSAGE.Set_Token('PAID_ON_BEHALF_OF', l_invoice_rec.name);
1936: FND_MESSAGE.Set_Token('INVOICE_DESCRIPTION',
1937: l_invoice_rec.description);
1938: l_description := FND_MESSAGE.GET;
1939:

Line 1936: FND_MESSAGE.Set_Token('INVOICE_DESCRIPTION',

1932: END IF;
1933:
1934: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_REMITTANCE_DESC');
1935: FND_MESSAGE.Set_Token('PAID_ON_BEHALF_OF', l_invoice_rec.name);
1936: FND_MESSAGE.Set_Token('INVOICE_DESCRIPTION',
1937: l_invoice_rec.description);
1938: l_description := FND_MESSAGE.GET;
1939:
1940: l_invoice_rec.description := substrb(l_description, 1, 240);

Line 1938: l_description := FND_MESSAGE.GET;

1934: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_REMITTANCE_DESC');
1935: FND_MESSAGE.Set_Token('PAID_ON_BEHALF_OF', l_invoice_rec.name);
1936: FND_MESSAGE.Set_Token('INVOICE_DESCRIPTION',
1937: l_invoice_rec.description);
1938: l_description := FND_MESSAGE.GET;
1939:
1940: l_invoice_rec.description := substrb(l_description, 1, 240);
1941:
1942: END IF;


'||l_export_message||'