DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on FND_LOG

Line 5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1: PACKAGE BODY ZX_ON_FLY_TRX_UPGRADE_AR_PKG AS
2: /* $Header: zxmigtrxflyarb.pls 120.22 2011/09/23 13:40:53 msakalab ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:

Line 6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

2: /* $Header: zxmigtrxflyarb.pls 120.22 2011/09/23 13:40:53 msakalab ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: -------------------------------------------------------------------------------

Line 7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: -------------------------------------------------------------------------------
11: -- PUBLIC PROCEDURE

Line 8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: -------------------------------------------------------------------------------
11: -- PUBLIC PROCEDURE
12: -- upgrade_trx_on_fly_ar

Line 32: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

28: l_fnd_return BOOLEAN;
29: l_estb_id NUMBER;
30:
31: BEGIN
32: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
33:
34: IF (g_level_procedure >= g_current_runtime_level ) THEN
35: FND_LOG.STRING(g_level_procedure,
36: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ar.BEGIN',

Line 35: FND_LOG.STRING(g_level_procedure,

31: BEGIN
32: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
33:
34: IF (g_level_procedure >= g_current_runtime_level ) THEN
35: FND_LOG.STRING(g_level_procedure,
36: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ar.BEGIN',
37: 'ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ar(+)');
38: END IF;
39: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 68: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar',

64: EXCEPTION
65: WHEN OTHERS THEN
66: l_estb_id := NULL;
67: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
68: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar',
69: 'Main Establishment Not Defined ' ||SQLERRM);
70: END IF;
71: END;
72:

Line 1859: FND_LOG.STRING(g_level_procedure,

1855: AND zxl.TRX_LEVEL_TYPE = 'LINE'
1856: );
1857:
1858: IF (g_level_procedure >= g_current_runtime_level ) THEN
1859: FND_LOG.STRING(g_level_procedure,
1860: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar.END',
1861: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar(-)');
1862: END IF;
1863: EXCEPTION

Line 1867: FND_LOG.STRING(g_level_unexpected,

1863: EXCEPTION
1864: WHEN OTHERS THEN
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1866: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1867: FND_LOG.STRING(g_level_unexpected,
1868: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar',
1869: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1870: FND_LOG.STRING(g_level_unexpected,
1871: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar.END',

Line 1870: FND_LOG.STRING(g_level_unexpected,

1866: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1867: FND_LOG.STRING(g_level_unexpected,
1868: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar',
1869: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1870: FND_LOG.STRING(g_level_unexpected,
1871: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar.END',
1872: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar(-)');
1873: END IF;
1874:

Line 1896: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1892: l_industry VARCHAR2(10);
1893: l_fnd_return BOOLEAN;
1894:
1895: BEGIN
1896: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1897:
1898: IF (g_level_procedure >= g_current_runtime_level ) THEN
1899: FND_LOG.STRING(g_level_procedure,
1900: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar.BEGIN',

Line 1899: FND_LOG.STRING(g_level_procedure,

1895: BEGIN
1896: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1897:
1898: IF (g_level_procedure >= g_current_runtime_level ) THEN
1899: FND_LOG.STRING(g_level_procedure,
1900: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar.BEGIN',
1901: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar(+)');
1902: END IF;
1903:

Line 1911: FND_LOG.STRING(g_level_unexpected,

1907: IF l_multi_org_flag = 'N' THEN
1908: FND_PROFILE.GET('ORG_ID',l_org_id);
1909: IF l_org_id is NULL THEN
1910: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1911: FND_LOG.STRING(g_level_unexpected,
1912: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar',
1913: 'Current envionment is a Single Org environment,'||
1914: ' but peofile ORG_ID is not set up');
1915: END IF;

Line 3682: FND_LOG.STRING(g_level_procedure,

3678: AND rates.content_owner_id = status.content_owner_id(+)
3679: AND NVL(arsysparam.tax_code, '!') <> 'Localization';
3680:
3681: IF (g_level_procedure >= g_current_runtime_level ) THEN
3682: FND_LOG.STRING(g_level_procedure,
3683: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar.BEGIN',
3684: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar(+)');
3685: END IF;
3686:

Line 3691: FND_LOG.STRING(g_level_unexpected,

3687: EXCEPTION
3688: WHEN OTHERS THEN
3689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3690: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3691: FND_LOG.STRING(g_level_unexpected,
3692: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar',
3693: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3694: FND_LOG.STRING(g_level_unexpected,
3695: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar.END',

Line 3694: FND_LOG.STRING(g_level_unexpected,

3690: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3691: FND_LOG.STRING(g_level_unexpected,
3692: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar',
3693: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3694: FND_LOG.STRING(g_level_unexpected,
3695: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar.END',
3696: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar(-)');
3697: END IF;
3698: