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.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_ON_FLY_TRX_UPGRADE_PO_PKG

Line 1: PACKAGE BODY ZX_ON_FLY_TRX_UPGRADE_PO_PKG AS

1: PACKAGE BODY ZX_ON_FLY_TRX_UPGRADE_PO_PKG AS
2: /* $Header: zxmigtrxflypob.pls 120.26.12020000.3 2012/11/23 14:25:21 srajapar noship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 34: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.BEGIN',

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

Line 35: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(+)');

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

Line 83: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',

79: EXCEPTION
80: WHEN OTHERS THEN
81: l_estb_id := NULL;
82: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
83: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
84: 'Main Establishment Not Defined ' ||SQLERRM);
85: END IF;
86: END;
87:

Line 518: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',

514: );
515:
516: IF (g_level_statement >= g_current_runtime_level ) THEN
517: FND_LOG.STRING(g_level_statement,
518: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
519: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
520: END IF;
521:
522: -- COMMIT;

Line 1222: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',

1218: );
1219:
1220: IF (g_level_statement >= g_current_runtime_level ) THEN
1221: FND_LOG.STRING(g_level_statement,
1222: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
1223: 'Number of Rows Inserted(Tax Code) = '||TO_CHAR(SQL%ROWCOUNT));
1224: END IF;
1225:
1226: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1941: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',

1937: );
1938:
1939: IF (g_level_statement >= g_current_runtime_level ) THEN
1940: FND_LOG.STRING(g_level_statement,
1941: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
1942: 'Number of Rows Inserted(Tax Group = ' || TO_CHAR(SQL%ROWCOUNT));
1943: END IF;
1944:
1945: -- COMMIT;

Line 2420: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',

2416: );
2417:
2418: IF (g_level_statement >= g_current_runtime_level ) THEN
2419: FND_LOG.STRING(g_level_statement,
2420: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
2421: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
2422: END IF;
2423:
2424: ELSIF p_upg_trx_info_rec.entity_code = 'RELEASE' THEN

Line 2853: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',

2849: );
2850:
2851: IF (g_level_statement >= g_current_runtime_level ) THEN
2852: FND_LOG.STRING(g_level_statement,
2853: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
2854: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
2855: END IF;
2856:
2857:

Line 3571: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',

3567: );
3568:
3569: IF (g_level_statement >= g_current_runtime_level ) THEN
3570: FND_LOG.STRING(g_level_statement,
3571: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
3572: 'Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));
3573: END IF;
3574:
3575: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4302: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',

4298: );
4299:
4300: IF (g_level_statement >= g_current_runtime_level ) THEN
4301: FND_LOG.STRING(g_level_statement,
4302: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
4303: 'Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));
4304: END IF;
4305:
4306:

Line 4782: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',

4778: );
4779:
4780: IF (g_level_statement >= g_current_runtime_level ) THEN
4781: FND_LOG.STRING(g_level_statement,
4782: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
4783: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
4784: END IF;
4785: END IF; -- entity_code = 'PURCHASE_ORDER' or 'RELEASE'
4786:

Line 4789: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',

4785: END IF; -- entity_code = 'PURCHASE_ORDER' or 'RELEASE'
4786:
4787: IF (g_level_procedure >= g_current_runtime_level ) THEN
4788: FND_LOG.STRING(g_level_procedure,
4789: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',
4790: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');
4791: END IF;
4792:
4793: EXCEPTION

Line 4790: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');

4786:
4787: IF (g_level_procedure >= g_current_runtime_level ) THEN
4788: FND_LOG.STRING(g_level_procedure,
4789: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',
4790: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');
4791: END IF;
4792:
4793: EXCEPTION
4794: WHEN OTHERS THEN

Line 4798: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',

4794: WHEN OTHERS THEN
4795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4796: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4797: FND_LOG.STRING(g_level_unexpected,
4798: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
4799: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4800: FND_LOG.STRING(g_level_unexpected,
4801: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',
4802: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');

Line 4801: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',

4797: FND_LOG.STRING(g_level_unexpected,
4798: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
4799: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4800: FND_LOG.STRING(g_level_unexpected,
4801: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',
4802: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');
4803: END IF;
4804:
4805: END upgrade_trx_on_fly_po;

Line 4802: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');

4798: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
4799: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4800: FND_LOG.STRING(g_level_unexpected,
4801: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',
4802: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');
4803: END IF;
4804:
4805: END upgrade_trx_on_fly_po;
4806:

Line 4829: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.BEGIN',

4825: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4826:
4827: IF (g_level_procedure >= g_current_runtime_level ) THEN
4828: FND_LOG.STRING(g_level_procedure,
4829: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.BEGIN',
4830: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(+)');
4831: END IF;
4832:
4833: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4830: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(+)');

4826:
4827: IF (g_level_procedure >= g_current_runtime_level ) THEN
4828: FND_LOG.STRING(g_level_procedure,
4829: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.BEGIN',
4830: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(+)');
4831: END IF;
4832:
4833: x_return_status := FND_API.G_RET_STS_SUCCESS;
4834:

Line 5275: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',

5271: AND ptp.party_type_code = 'OU';
5272:
5273: IF (g_level_statement >= g_current_runtime_level ) THEN
5274: FND_LOG.STRING(g_level_statement,
5275: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
5276: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
5277: END IF;
5278:
5279: -- COMMIT;

Line 5978: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',

5974:
5975:
5976: IF (g_level_statement >= g_current_runtime_level ) THEN
5977: FND_LOG.STRING(g_level_statement,
5978: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
5979: 'ZX_LINES Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));
5980: END IF;
5981:
5982: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 6694: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',

6690: AND status.tax_status_code(+) = rates.tax_status_code;
6691:
6692: IF (g_level_statement >= g_current_runtime_level ) THEN
6693: FND_LOG.STRING(g_level_statement,
6694: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
6695: 'ZX_LINES Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));
6696: END IF;
6697:
6698: -- COMMIT;

Line 7166: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',

7162: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%';
7163:
7164: IF (g_level_statement >= g_current_runtime_level ) THEN
7165: FND_LOG.STRING(g_level_statement,
7166: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
7167: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
7168: END IF;
7169:
7170: -- bug 5166217 : Do bulk migration for RELEASE

Line 7596: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',

7592: AND ptp.party_type_code = 'OU';
7593:
7594: IF (g_level_statement >= g_current_runtime_level ) THEN
7595: FND_LOG.STRING(g_level_statement,
7596: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
7597: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
7598: END IF;
7599:
7600: -- COMMIT;

Line 8308: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',

8304: AND status.tax_status_code(+) = rates.tax_status_code;
8305:
8306: IF (g_level_statement >= g_current_runtime_level ) THEN
8307: FND_LOG.STRING(g_level_statement,
8308: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
8309: 'ZX_LINES Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));
8310: END IF;
8311:
8312: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 9034: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',

9030: AND status.tax_status_code(+) = rates.tax_status_code;
9031:
9032: IF (g_level_statement >= g_current_runtime_level ) THEN
9033: FND_LOG.STRING(g_level_statement,
9034: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
9035: 'ZX_LINES Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));
9036: END IF;
9037:
9038: -- COMMIT;

Line 9506: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',

9502: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%';
9503:
9504: IF (g_level_statement >= g_current_runtime_level ) THEN
9505: FND_LOG.STRING(g_level_statement,
9506: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
9507: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
9508: END IF;
9509:
9510: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 9512: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',

9508: END IF;
9509:
9510: IF (g_level_procedure >= g_current_runtime_level ) THEN
9511: FND_LOG.STRING(g_level_procedure,
9512: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',
9513: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');
9514: END IF;
9515:
9516: EXCEPTION

Line 9513: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');

9509:
9510: IF (g_level_procedure >= g_current_runtime_level ) THEN
9511: FND_LOG.STRING(g_level_procedure,
9512: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',
9513: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');
9514: END IF;
9515:
9516: EXCEPTION
9517: WHEN OTHERS THEN

Line 9521: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',

9517: WHEN OTHERS THEN
9518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9519: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9520: FND_LOG.STRING(g_level_unexpected,
9521: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
9522: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
9523: FND_LOG.STRING(g_level_unexpected,
9524: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',
9525: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');

Line 9524: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',

9520: FND_LOG.STRING(g_level_unexpected,
9521: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
9522: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
9523: FND_LOG.STRING(g_level_unexpected,
9524: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',
9525: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');
9526: END IF;
9527:
9528: END upgrade_trx_on_fly_blk_po;

Line 9525: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');

9521: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
9522: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
9523: FND_LOG.STRING(g_level_unexpected,
9524: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',
9525: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');
9526: END IF;
9527:
9528: END upgrade_trx_on_fly_blk_po;
9529:

Line 9530: END ZX_ON_FLY_TRX_UPGRADE_PO_PKG;

9526: END IF;
9527:
9528: END upgrade_trx_on_fly_blk_po;
9529:
9530: END ZX_ON_FLY_TRX_UPGRADE_PO_PKG;
9531: