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.21.12010000.2 2008/10/17 06:56:28 tsen ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

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

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

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

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

480: );
481:
482: IF (g_level_statement >= g_current_runtime_level ) THEN
483: FND_LOG.STRING(g_level_statement,
484: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
485: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
486: END IF;
487:
488: -- COMMIT;

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

1188: );
1189:
1190: IF (g_level_statement >= g_current_runtime_level ) THEN
1191: FND_LOG.STRING(g_level_statement,
1192: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
1193: 'Number of Rows Inserted(Tax Code) = '||TO_CHAR(SQL%ROWCOUNT));
1194: END IF;
1195:
1196: IF (g_level_statement >= g_current_runtime_level ) THEN

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

1907: );
1908:
1909: IF (g_level_statement >= g_current_runtime_level ) THEN
1910: FND_LOG.STRING(g_level_statement,
1911: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
1912: 'Number of Rows Inserted(Tax Group = ' || TO_CHAR(SQL%ROWCOUNT));
1913: END IF;
1914:
1915: -- COMMIT;

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

2354: );
2355:
2356: IF (g_level_statement >= g_current_runtime_level ) THEN
2357: FND_LOG.STRING(g_level_statement,
2358: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
2359: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
2360: END IF;
2361:
2362: ELSIF p_upg_trx_info_rec.entity_code = 'RELEASE' THEN

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

2788: );
2789:
2790: IF (g_level_statement >= g_current_runtime_level ) THEN
2791: FND_LOG.STRING(g_level_statement,
2792: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
2793: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
2794: END IF;
2795:
2796:

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

3509: );
3510:
3511: IF (g_level_statement >= g_current_runtime_level ) THEN
3512: FND_LOG.STRING(g_level_statement,
3513: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
3514: 'Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));
3515: END IF;
3516:
3517: IF (g_level_statement >= g_current_runtime_level ) THEN

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

4240: );
4241:
4242: IF (g_level_statement >= g_current_runtime_level ) THEN
4243: FND_LOG.STRING(g_level_statement,
4244: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
4245: 'Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));
4246: END IF;
4247:
4248:

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

4688: );
4689:
4690: IF (g_level_statement >= g_current_runtime_level ) THEN
4691: FND_LOG.STRING(g_level_statement,
4692: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
4693: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
4694: END IF;
4695: END IF; -- entity_code = 'PURCHASE_ORDER' or 'RELEASE'
4696:

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

4695: END IF; -- entity_code = 'PURCHASE_ORDER' or 'RELEASE'
4696:
4697: IF (g_level_procedure >= g_current_runtime_level ) THEN
4698: FND_LOG.STRING(g_level_procedure,
4699: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',
4700: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');
4701: END IF;
4702:
4703: EXCEPTION

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

4696:
4697: IF (g_level_procedure >= g_current_runtime_level ) THEN
4698: FND_LOG.STRING(g_level_procedure,
4699: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',
4700: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');
4701: END IF;
4702:
4703: EXCEPTION
4704: WHEN OTHERS THEN

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

4704: WHEN OTHERS THEN
4705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4706: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4707: FND_LOG.STRING(g_level_unexpected,
4708: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
4709: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4710: FND_LOG.STRING(g_level_unexpected,
4711: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',
4712: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');

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

4707: FND_LOG.STRING(g_level_unexpected,
4708: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
4709: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4710: FND_LOG.STRING(g_level_unexpected,
4711: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',
4712: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');
4713: END IF;
4714:
4715: END upgrade_trx_on_fly_po;

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

4708: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po',
4709: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4710: FND_LOG.STRING(g_level_unexpected,
4711: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po.END',
4712: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)');
4713: END IF;
4714:
4715: END upgrade_trx_on_fly_po;
4716:

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

4735: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4736:
4737: IF (g_level_procedure >= g_current_runtime_level ) THEN
4738: FND_LOG.STRING(g_level_procedure,
4739: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.BEGIN',
4740: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(+)');
4741: END IF;
4742:
4743: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4736:
4737: IF (g_level_procedure >= g_current_runtime_level ) THEN
4738: FND_LOG.STRING(g_level_procedure,
4739: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.BEGIN',
4740: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(+)');
4741: END IF;
4742:
4743: x_return_status := FND_API.G_RET_STS_SUCCESS;
4744:

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

5182: AND ptp.party_type_code = 'OU';
5183:
5184: IF (g_level_statement >= g_current_runtime_level ) THEN
5185: FND_LOG.STRING(g_level_statement,
5186: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
5187: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
5188: END IF;
5189:
5190: -- COMMIT;

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

5888:
5889:
5890: IF (g_level_statement >= g_current_runtime_level ) THEN
5891: FND_LOG.STRING(g_level_statement,
5892: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
5893: 'ZX_LINES Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));
5894: END IF;
5895:
5896: IF (g_level_statement >= g_current_runtime_level ) THEN

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

6604: AND status.tax_status_code(+) = rates.tax_status_code;
6605:
6606: IF (g_level_statement >= g_current_runtime_level ) THEN
6607: FND_LOG.STRING(g_level_statement,
6608: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
6609: 'ZX_LINES Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));
6610: END IF;
6611:
6612: -- COMMIT;

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

7046: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%';
7047:
7048: IF (g_level_statement >= g_current_runtime_level ) THEN
7049: FND_LOG.STRING(g_level_statement,
7050: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
7051: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
7052: END IF;
7053:
7054: -- bug 5166217 : Do bulk migration for RELEASE

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

7477: AND ptp.party_type_code = 'OU';
7478:
7479: IF (g_level_statement >= g_current_runtime_level ) THEN
7480: FND_LOG.STRING(g_level_statement,
7481: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
7482: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
7483: END IF;
7484:
7485: -- COMMIT;

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

8192: AND status.tax_status_code(+) = rates.tax_status_code;
8193:
8194: IF (g_level_statement >= g_current_runtime_level ) THEN
8195: FND_LOG.STRING(g_level_statement,
8196: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
8197: 'ZX_LINES Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));
8198: END IF;
8199:
8200: IF (g_level_statement >= g_current_runtime_level ) THEN

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

8918: AND status.tax_status_code(+) = rates.tax_status_code;
8919:
8920: IF (g_level_statement >= g_current_runtime_level ) THEN
8921: FND_LOG.STRING(g_level_statement,
8922: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
8923: 'ZX_LINES Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));
8924: END IF;
8925:
8926: -- COMMIT;

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

9360: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%';
9361:
9362: IF (g_level_statement >= g_current_runtime_level ) THEN
9363: FND_LOG.STRING(g_level_statement,
9364: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
9365: 'Number of Rows Inserted = ' || TO_CHAR(SQL%ROWCOUNT));
9366: END IF;
9367:
9368:

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

9369:
9370:
9371: IF (g_level_procedure >= g_current_runtime_level ) THEN
9372: FND_LOG.STRING(g_level_procedure,
9373: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',
9374: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');
9375: END IF;
9376:
9377: EXCEPTION

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

9370:
9371: IF (g_level_procedure >= g_current_runtime_level ) THEN
9372: FND_LOG.STRING(g_level_procedure,
9373: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',
9374: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');
9375: END IF;
9376:
9377: EXCEPTION
9378: WHEN OTHERS THEN

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

9378: WHEN OTHERS THEN
9379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9380: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9381: FND_LOG.STRING(g_level_unexpected,
9382: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
9383: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
9384: FND_LOG.STRING(g_level_unexpected,
9385: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',
9386: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');

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

9381: FND_LOG.STRING(g_level_unexpected,
9382: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
9383: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
9384: FND_LOG.STRING(g_level_unexpected,
9385: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',
9386: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');
9387: END IF;
9388:
9389: END upgrade_trx_on_fly_blk_po;

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

9382: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
9383: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
9384: FND_LOG.STRING(g_level_unexpected,
9385: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po.END',
9386: 'ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po(-)');
9387: END IF;
9388:
9389: END upgrade_trx_on_fly_blk_po;
9390:

Line 9391: END ZX_ON_FLY_TRX_UPGRADE_PO_PKG;

9387: END IF;
9388:
9389: END upgrade_trx_on_fly_blk_po;
9390:
9391: END ZX_ON_FLY_TRX_UPGRADE_PO_PKG;
9392: