DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on ZX_ON_FLY_TRX_UPGRADE_AR_PKG

Line 1: PACKAGE BODY ZX_ON_FLY_TRX_UPGRADE_AR_PKG AS

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;

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 1860: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar.END',

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
1864: WHEN OTHERS THEN

Line 1861: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar(-)');

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
1864: WHEN OTHERS THEN
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1868: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar',

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',
1872: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar(-)');

Line 1871: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar.END',

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:
1875: END upgrade_trx_on_fly_ar;

Line 1872: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ar(-)');

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:
1875: END upgrade_trx_on_fly_ar;
1876:

Line 1900: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar.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:
1904: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1901: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar(+)');

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:
1904: x_return_status := FND_API.G_RET_STS_SUCCESS;
1905: SELECT NVL(multi_org_flag, 'N') INTO l_multi_org_flag FROM FND_PRODUCT_GROUPS;

Line 1912: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar',

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;
1916:

Line 3683: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar.BEGIN',

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:
3687: EXCEPTION

Line 3684: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar(+)');

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:
3687: EXCEPTION
3688: WHEN OTHERS THEN

Line 3692: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar',

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',
3696: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar(-)');

Line 3695: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar.END',

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:
3699: END upgrade_trx_on_fly_blk_ar;

Line 3696: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar(-)');

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:
3699: END upgrade_trx_on_fly_blk_ar;
3700:

Line 3701: END ZX_ON_FLY_TRX_UPGRADE_AR_PKG;

3697: END IF;
3698:
3699: END upgrade_trx_on_fly_blk_ar;
3700:
3701: END ZX_ON_FLY_TRX_UPGRADE_AR_PKG;
3702: