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.FV_THIRD_PARTY_REMIT_PKG dependencies on FV_THIRD_PARTY_TEMP

Line 165: -- Purge fv_third_party_temp table using Initialization procedure

161: g_errbuf := 'Erroring out from Third Party Remittance Process because Third Party Profile Option is set to NO !!';
162: g_retcode := 2;
163: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');
164: ELSE
165: -- Purge fv_third_party_temp table using Initialization procedure
166: IF (g_retcode = 0)
167: THEN
168: Initialization;
169: END IF;

Line 252: -- from Fv_Third_Party_Temp table

248: -- -------------------------------------------------------------
249: -- PROCEDURE INITIALIZATION
250: -- -------------------------------------------------------------
251: -- The purpose of this procedure is to delete any existing data
252: -- from Fv_Third_Party_Temp table
253: -- -------------------------------------------------------------
254: PROCEDURE INITIALIZATION IS
255: l_module_name VARCHAR2(200) ;
256: l_count NUMBER := 0;

Line 258: g_message := ' Purging Fv_Third_Party_Temp table ...';

254: PROCEDURE INITIALIZATION IS
255: l_module_name VARCHAR2(200) ;
256: l_count NUMBER := 0;
257: BEGIN
258: g_message := ' Purging Fv_Third_Party_Temp table ...';
259: l_module_name := g_module_name || 'INITIALIZATION';
260: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
261:
262: DELETE FROM fv_third_party_temp;

Line 262: DELETE FROM fv_third_party_temp;

258: g_message := ' Purging Fv_Third_Party_Temp table ...';
259: l_module_name := g_module_name || 'INITIALIZATION';
260: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
261:
262: DELETE FROM fv_third_party_temp;
263: EXCEPTION
264: WHEN OTHERS THEN
265: g_retcode := SQLCODE;
266: g_errbuf := SQLERRM ||

Line 267: ' -- Error in Initialization Procedure when purging fv_third_party_temp table';

263: EXCEPTION
264: WHEN OTHERS THEN
265: g_retcode := SQLCODE;
266: g_errbuf := SQLERRM ||
267: ' -- Error in Initialization Procedure when purging fv_third_party_temp table';
268: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');
269: END INITIALIZATION;
270:
271:

Line 290: g_message := ' Inserting a record in Fv_Third_Party_Temp ...';

286: p_invoice_amount NUMBER,
287: p_discount_amount NUMBER) IS
288: l_module_name VARCHAR2(200) ;
289: BEGIN
290: g_message := ' Inserting a record in Fv_Third_Party_Temp ...';
291: l_module_name := g_module_name || 'POPULATE_THIRD_PARTY_TEMP';
292: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
293: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,'');
294:

Line 295: INSERT INTO fv_third_party_temp

291: l_module_name := g_module_name || 'POPULATE_THIRD_PARTY_TEMP';
292: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
293: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,'');
294:
295: INSERT INTO fv_third_party_temp
296: (original_supplier_name,
297: original_supplier_site,
298: third_party_agent,
299: third_party_site,

Line 325: ' -- Error in Populate_Third_Party_Temp Procedure when inserting record into fv_third_party_temp table';

321: EXCEPTION
322: WHEN OTHERS THEN
323: g_retcode := SQLCODE;
324: g_errbuf := SQLERRM ||
325: ' -- Error in Populate_Third_Party_Temp Procedure when inserting record into fv_third_party_temp table';
326: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');
327: END POPULATE_THIRD_PARTY_TEMP;
328:
329: