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.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on FND_FILE

Line 331: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt start, TimeStamp:' ||systimestamp);

327: module => l_Debug_Module);
328:
329: -- Calling Insert_Into_Gt procedure to include Document Receivable tag
330: -- in FC Payer Notification Extract.
331: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt start, TimeStamp:' ||systimestamp);
332: Insert_Into_Gt(p_mbatchid);
333: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt end, TimeStamp:' ||systimestamp);
334:
335: iby_debug_pub.add(debug_msg => 'Before executing dynamic query.',

Line 333: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt end, TimeStamp:' ||systimestamp);

329: -- Calling Insert_Into_Gt procedure to include Document Receivable tag
330: -- in FC Payer Notification Extract.
331: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt start, TimeStamp:' ||systimestamp);
332: Insert_Into_Gt(p_mbatchid);
333: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt end, TimeStamp:' ||systimestamp);
334:
335: iby_debug_pub.add(debug_msg => 'Before executing dynamic query.',
336: debug_level => FND_LOG.LEVEL_STATEMENT,
337: module => l_Debug_Module);

Line 433: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt start, TimeStamp:' ||systimestamp);

429: IF ((p_req_type = 'ORAPMTCLOSEBATCH')
430: OR (p_req_type = 'ORAPMTEFTCLOSEBATCH')
431: OR (p_req_type = 'ORAPMTPDCCLOSEBATCH')) THEN
432: --14671332 Making the call to headers_gt only in the time of batch closure.
433: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt start, TimeStamp:' ||systimestamp);
434: Insert_Into_Gt(p_txn_id);
435: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt end, TimeStamp:' ||systimestamp);
436:
437: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v START' || ':TimeStamp:' ||systimestamp);

Line 435: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt end, TimeStamp:' ||systimestamp);

431: OR (p_req_type = 'ORAPMTPDCCLOSEBATCH')) THEN
432: --14671332 Making the call to headers_gt only in the time of batch closure.
433: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt start, TimeStamp:' ||systimestamp);
434: Insert_Into_Gt(p_txn_id);
435: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt end, TimeStamp:' ||systimestamp);
436:
437: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v START' || ':TimeStamp:' ||systimestamp);
438: --Bug# 13640788
439: -- Removed Optimizer hints as per the pef team sugestion

Line 437: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v START' || ':TimeStamp:' ||systimestamp);

433: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt start, TimeStamp:' ||systimestamp);
434: Insert_Into_Gt(p_txn_id);
435: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt end, TimeStamp:' ||systimestamp);
436:
437: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v START' || ':TimeStamp:' ||systimestamp);
438: --Bug# 13640788
439: -- Removed Optimizer hints as per the pef team sugestion
440: SELECT
441: XMLType.getClobVal(instruction)

Line 454: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v END' || ':TimeStamp:' ||systimestamp);

450: FROM iby_xml_online_fci_1_0_v
451: WHERE trxnmid=p_txn_id
452: AND rownum=1;
453: END IF;
454: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v END' || ':TimeStamp:' ||systimestamp);
455:
456: -- clears out data from global temporary table
457: COMMIT;
458:

Line 1450: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Enter , TimeStamp:' ||systimestamp);

1446: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Insert_Into_Headers_Gt';
1447: BEGIN
1448:
1449: IF (l_header_cursor%ISOPEN) THEN CLOSE l_header_cursor; END IF;
1450: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Enter , TimeStamp:' ||systimestamp);
1451: /* The columns from 15 to 22 are null because the view ar_docs_receivables_v
1452: has null for ship_from_address_id
1453: */
1454: SELECT payment_channel_code

Line 1532: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_HEADER_GT: '||l_count);

1528: END IF;
1529:
1530: END LOOP;
1531: select count(*) into l_count from IBY_AR_DOC_HEADER_GT;
1532: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_HEADER_GT: '||l_count);
1533: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Exit , TimeStamp:' ||systimestamp);
1534:
1535: END Insert_Into_Headers_Gt;
1536:

Line 1533: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Exit , TimeStamp:' ||systimestamp);

1529:
1530: END LOOP;
1531: select count(*) into l_count from IBY_AR_DOC_HEADER_GT;
1532: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_HEADER_GT: '||l_count);
1533: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Exit , TimeStamp:' ||systimestamp);
1534:
1535: END Insert_Into_Headers_Gt;
1536:
1537:

Line 1554: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Enter , TimeStamp:' ||systimestamp);

1550: l_payment_channel_code IBY_TRXN_SUMMARIES_ALL.PAYMENT_CHANNEL_CODE%TYPE;
1551: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Insert_Into_Lines_Gt';
1552: BEGIN
1553:
1554: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Enter , TimeStamp:' ||systimestamp);
1555: IF (l_lines_cursor%ISOPEN) THEN CLOSE l_lines_cursor; END IF;
1556:
1557: SELECT payment_channel_code
1558: INTO l_payment_channel_code

Line 1614: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_LINES_GT: '||l_count);

1610: END IF;
1611:
1612: END LOOP;
1613: select count(*) into l_count from IBY_AR_DOC_LINES_GT;
1614: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_LINES_GT: '||l_count);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Exit , TimeStamp:' ||systimestamp);
1616:
1617: END Insert_Into_Lines_Gt;
1618:

Line 1615: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Exit , TimeStamp:' ||systimestamp);

1611:
1612: END LOOP;
1613: select count(*) into l_count from IBY_AR_DOC_LINES_GT;
1614: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_LINES_GT: '||l_count);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Exit , TimeStamp:' ||systimestamp);
1616:
1617: END Insert_Into_Lines_Gt;
1618:
1619: