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.AR_GTA_TRX_HEADERS_ALL_PKG dependencies on FND_LOG

Line 237: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

233: --Yao Zhang add end for bug#8605196 consolidate invoices
234: )
235: IS
236: l_procedure_name VARCHAR2(100) :='Insert_Row';
237: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
238: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
239: CURSOR C IS
240: SELECT
241: ROWID

Line 238: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

234: )
235: IS
236: l_procedure_name VARCHAR2(100) :='Insert_Row';
237: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
238: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
239: CURSOR C IS
240: SELECT
241: ROWID
242: FROM

Line 252: FND_LOG.String(l_proc_level

248: --log for debug
249: IF( l_proc_level >= l_dbg_level)
250: THEN
251:
252: FND_LOG.String(l_proc_level
253: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
254: ,'Enter procedure'
255: );
256:

Line 439: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

435: --The following code is add by Yao Zhang for exception handle
436: EXCEPTION
437: WHEN OTHERS THEN
438: fnd_file.PUT_LINE(fnd_file.LOG,'Exception from header insert row'||SQLCODE || SQLERRM);
439: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
440: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,
441: G_MODULE_PREFIX || l_procedure_name ||
442: '. OTHER_EXCEPTION ',
443: 'Unknown error' || SQLCODE || SQLERRM);

Line 440: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,

436: EXCEPTION
437: WHEN OTHERS THEN
438: fnd_file.PUT_LINE(fnd_file.LOG,'Exception from header insert row'||SQLCODE || SQLERRM);
439: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
440: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,
441: G_MODULE_PREFIX || l_procedure_name ||
442: '. OTHER_EXCEPTION ',
443: 'Unknown error' || SQLCODE || SQLERRM);
444:

Line 451: FND_LOG.String(l_proc_level

447: --log for debug
448: IF( l_proc_level >= l_dbg_level)
449: THEN
450:
451: FND_LOG.String(l_proc_level
452: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
453: ,'Exit procedure'
454: );
455:

Line 653: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

649: ,p_invoice_type IN VARCHAR2 --added by subba for R12.1
650: )
651: IS
652: l_procedure_name VARCHAR2(100) :='Update_Row';
653: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
654: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
655: BEGIN
656:
657: --log for debug

Line 654: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

650: )
651: IS
652: l_procedure_name VARCHAR2(100) :='Update_Row';
653: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
654: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
655: BEGIN
656:
657: --log for debug
658: IF( l_proc_level >= l_dbg_level)

Line 661: FND_LOG.String(l_proc_level

657: --log for debug
658: IF( l_proc_level >= l_dbg_level)
659: THEN
660:
661: FND_LOG.String(l_proc_level
662: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
663: ,'Enter procedure'
664: );
665:

Line 758: FND_LOG.String(l_proc_level

754: --log for debug
755: IF( l_proc_level >= l_dbg_level)
756: THEN
757:
758: FND_LOG.String(l_proc_level
759: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
760: ,'Exit procedure'
761: );
762:

Line 964: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

960: ,p_invoice_type IN VARCHAR2 --added by subba for R12.1
961: )
962: IS
963: l_procedure_name VARCHAR2(100) :='Lock_Row';
964: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
965: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
966:
967: CURSOR c IS
968: SELECT

Line 965: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

961: )
962: IS
963: l_procedure_name VARCHAR2(100) :='Lock_Row';
964: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
965: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
966:
967: CURSOR c IS
968: SELECT
969: *

Line 982: FND_LOG.String(l_proc_level

978: --log for debug
979: IF( l_proc_level >= l_dbg_level)
980: THEN
981:
982: FND_LOG.String(l_proc_level
983: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
984: ,'Begin procedure'
985: );
986:

Line 1619: FND_LOG.String(l_proc_level

1615: --log for debug
1616: IF( l_proc_level >= l_dbg_level)
1617: THEN
1618:
1619: FND_LOG.String(l_proc_level
1620: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1621: ,'Exit procedure'
1622: );
1623:

Line 1658: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1654: (p_rowid IN OUT NOCOPY VARCHAR2
1655: )
1656: IS
1657: l_procedure_name VARCHAR2(100) :='Delete_Row';
1658: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1659: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1660: -- added by Allen Yang for bug 8605196: ENHANCEMENT FOR GOLDEN TAX ADAPTER R12.1.2
1661: -----------------------------------------------------------------------------------
1662: l_consolidation_flag AR_GTA_TRX_HEADERS_ALL.CONSOLIDATION_FLAG%TYPE;

Line 1659: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1655: )
1656: IS
1657: l_procedure_name VARCHAR2(100) :='Delete_Row';
1658: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1659: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1660: -- added by Allen Yang for bug 8605196: ENHANCEMENT FOR GOLDEN TAX ADAPTER R12.1.2
1661: -----------------------------------------------------------------------------------
1662: l_consolidation_flag AR_GTA_TRX_HEADERS_ALL.CONSOLIDATION_FLAG%TYPE;
1663: l_consol_trx_num AR_GTA_TRX_HEADERS_ALL.CONSOLIDATION_TRX_NUM%TYPE;

Line 1671: FND_LOG.String(l_proc_level

1667: --log for debug
1668: IF( l_proc_level >= l_dbg_level)
1669: THEN
1670:
1671: FND_LOG.String(l_proc_level
1672: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
1673: ,'Begin procedure'
1674: );
1675:

Line 1721: FND_LOG.String(l_proc_level

1717: --log for debug
1718: IF( l_proc_level >= l_dbg_level)
1719: THEN
1720:
1721: FND_LOG.String(l_proc_level
1722: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1723: ,'Exit procedure'
1724: );
1725:

Line 1764: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1760: ,x_trx_header_rec OUT NOCOPY AR_GTA_TRX_UTIL.Trx_Header_Rec_Type
1761: )
1762: IS
1763: l_procedure_name VARCHAR2(100) :='Query_Row';
1764: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1765: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1766: BEGIN
1767:
1768: --log for debug

Line 1765: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1761: )
1762: IS
1763: l_procedure_name VARCHAR2(100) :='Query_Row';
1764: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1765: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1766: BEGIN
1767:
1768: --log for debug
1769: IF( l_proc_level >= l_dbg_level)

Line 1772: FND_LOG.String(l_proc_level

1768: --log for debug
1769: IF( l_proc_level >= l_dbg_level)
1770: THEN
1771:
1772: FND_LOG.String(l_proc_level
1773: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
1774: ,'Begin procedure'
1775: );
1776:

Line 1947: FND_LOG.String(l_proc_level

1943: --log for debug
1944: IF( l_proc_level >= l_dbg_level)
1945: THEN
1946:
1947: FND_LOG.String(l_proc_level
1948: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1949: ,'Exit procedure'
1950: );
1951:

Line 1985: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1981: (p_rowid IN OUT NOCOPY VARCHAR2
1982: )
1983: IS
1984: l_procedure_name VARCHAR2(100) :='Unmerge_Row';
1985: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1986: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1987: l_consol_trx_num AR_GTA_TRX_HEADERS_ALL.GTA_TRX_NUMBER%TYPE;
1988: BEGIN
1989:

Line 1986: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1982: )
1983: IS
1984: l_procedure_name VARCHAR2(100) :='Unmerge_Row';
1985: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1986: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1987: l_consol_trx_num AR_GTA_TRX_HEADERS_ALL.GTA_TRX_NUMBER%TYPE;
1988: BEGIN
1989:
1990: --log for debug

Line 1993: FND_LOG.String(l_proc_level

1989:
1990: --log for debug
1991: IF( l_proc_level >= l_dbg_level)
1992: THEN
1993: FND_LOG.String(l_proc_level
1994: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
1995: ,'Begin procedure'
1996: );
1997: END IF; --( l_proc_level >= l_dbg_level)

Line 2035: FND_LOG.String(l_proc_level

2031:
2032: --log for debug
2033: IF( l_proc_level >= l_dbg_level)
2034: THEN
2035: FND_LOG.String(l_proc_level
2036: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
2037: ,'Exit procedure'
2038: );
2039: END IF; --( l_proc_level >= l_dbg_level)