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 FND_LOG

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

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

Line 29: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

25: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
26:
27: BEGIN
28:
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',

Line 32: FND_LOG.STRING(g_level_procedure,

28:
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:

Line 45: FND_LOG.STRING(g_level_unexpected,

41: IF NVL(l_multi_org_flag,'N') = 'N' THEN -- non- multi org
42: FND_PROFILE.GET('ORG_ID',l_org_id);
43: IF l_org_id is NULL THEN
44: IF (g_level_unexpected >= g_current_runtime_level ) THEN
45: FND_LOG.STRING(g_level_unexpected,
46: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
47: 'Current envionment is a Single Org environment,'||
48: ' but profile ORG_ID is not set up');
49: END IF;

Line 59: FND_LOG.STRING(g_level_statement,

55: ZX_PO_REC_PKG.get_rec_info(p_upg_trx_info_rec => p_upg_trx_info_rec,
56: x_return_status => x_return_status);
57:
58: IF (g_level_statement >= g_current_runtime_level ) THEN
59: FND_LOG.STRING(g_level_statement,
60: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
61: 'Inserting data into zx_lines_det_factors');
62: END IF;
63:

Line 483: FND_LOG.STRING(g_level_statement,

479: AND zxl.TRX_LEVEL_TYPE = 'SHIPMENT'
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:

Line 491: FND_LOG.STRING(g_level_statement,

487:
488: -- COMMIT;
489:
490: IF (g_level_statement >= g_current_runtime_level ) THEN
491: FND_LOG.STRING(g_level_statement,
492: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
493: 'Inserting data into zx_lines: tax code');
494: END IF;
495:

Line 1191: FND_LOG.STRING(g_level_statement,

1187: AND zxl.TRX_LEVEL_TYPE = 'SHIPMENT'
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:

Line 1197: FND_LOG.STRING(g_level_statement,

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
1197: FND_LOG.STRING(g_level_statement,
1198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1199: 'Inserting data into zx_lines');
1200: END IF;
1201:

Line 1910: FND_LOG.STRING(g_level_statement,

1906: AND zxl.TRX_LEVEL_TYPE = 'SHIPMENT'
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:

Line 1918: FND_LOG.STRING(g_level_statement,

1914:
1915: -- COMMIT;
1916:
1917: IF (g_level_statement >= g_current_runtime_level ) THEN
1918: FND_LOG.STRING(g_level_statement,
1919: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1920: 'Inserting data into zx_rec_nrec_dist');
1921: END IF;
1922:

Line 2357: FND_LOG.STRING(g_level_statement,

2353: -- AND zxdist.trx_line_dist_id = pod.po_distribution_id
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:

Line 2791: FND_LOG.STRING(g_level_statement,

2787: AND zxl.TRX_LEVEL_TYPE = 'SHIPMENT'
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:

Line 2800: FND_LOG.STRING(g_level_statement,

2796:
2797: -- COMMIT;
2798:
2799: IF (g_level_statement >= g_current_runtime_level ) THEN
2800: FND_LOG.STRING(g_level_statement,
2801: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
2802: 'Inserting data into zx_lines (Tax Code)');
2803: END IF;
2804:

Line 3512: FND_LOG.STRING(g_level_statement,

3508: -- AND NVL(zxl.TAX_APPORTIONMENT_LINE_NUMBER,1) = NVL(TAX_APPORTIONMENT_LINE_NUMBER,1)
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:

Line 3518: FND_LOG.STRING(g_level_statement,

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
3518: FND_LOG.STRING(g_level_statement,
3519: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
3520: 'Inserting data into zx_lines(Tax Group)');
3521: END IF;
3522:

Line 4243: FND_LOG.STRING(g_level_statement,

4239: -- AND NVL(zxl.TAX_APPORTIONMENT_LINE_NUMBER,1) = NVL(TAX_APPORTIONMENT_LINE_NUMBER,1)
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:

Line 4252: FND_LOG.STRING(g_level_statement,

4248:
4249: -- COMMIT;
4250:
4251: IF (g_level_statement >= g_current_runtime_level ) THEN
4252: FND_LOG.STRING(g_level_statement,
4253: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
4254: 'Inserting data into zx_rec_nrec_dist');
4255: END IF;
4256:

Line 4691: FND_LOG.STRING(g_level_statement,

4687: -- AND zxdist.trx_line_dist_id = pod.po_distribution_id
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'

Line 4698: FND_LOG.STRING(g_level_procedure,

4694: END IF;
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:

Line 4707: FND_LOG.STRING(g_level_unexpected,

4703: EXCEPTION
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',

Line 4710: FND_LOG.STRING(g_level_unexpected,

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(-)');
4713: END IF;
4714:

Line 4735: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4731: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
4732:
4733: BEGIN
4734:
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',

Line 4738: FND_LOG.STRING(g_level_procedure,

4734:
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:

Line 4751: FND_LOG.STRING(g_level_unexpected,

4747: IF NVL(l_multi_org_flag,'N') = 'N' THEN -- non- multi org
4748: FND_PROFILE.GET('ORG_ID',l_org_id);
4749: IF l_org_id is NULL THEN
4750: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4751: FND_LOG.STRING(g_level_unexpected,
4752: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4753: 'Current envionment is a Single Org environment,'||
4754: ' but profile ORG_ID is not set up');
4755: END IF;

Line 4764: FND_LOG.STRING(g_level_statement,

4760: --
4761: ZX_PO_REC_PKG.get_rec_info(x_return_status => x_return_status);
4762:
4763: IF (g_level_statement >= g_current_runtime_level ) THEN
4764: FND_LOG.STRING(g_level_statement,
4765: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4766: 'Inserting data into zx_lines_det_factors');
4767: END IF;
4768: -- Insert data into zx_lines_det_factors

Line 5185: FND_LOG.STRING(g_level_statement,

5181: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
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:

Line 5193: FND_LOG.STRING(g_level_statement,

5189:
5190: -- COMMIT;
5191:
5192: IF (g_level_statement >= g_current_runtime_level ) THEN
5193: FND_LOG.STRING(g_level_statement,
5194: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5195: 'Inserting data into zx_lines(Tax Code)');
5196: END IF;
5197:

Line 5891: FND_LOG.STRING(g_level_statement,

5887: AND status.tax_status_code(+) = rates.tax_status_code;
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:

Line 5897: FND_LOG.STRING(g_level_statement,

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
5897: FND_LOG.STRING(g_level_statement,
5898: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5899: 'Inserting data into zx_lines(Tax Group)');
5900: END IF;
5901:

Line 6607: FND_LOG.STRING(g_level_statement,

6603: AND status.content_owner_id(+) = rates.content_owner_id
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:

Line 6615: FND_LOG.STRING(g_level_statement,

6611:
6612: -- COMMIT;
6613:
6614: IF (g_level_statement >= g_current_runtime_level ) THEN
6615: FND_LOG.STRING(g_level_statement,
6616: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
6617: 'Inserting data into zx_rec_nrec_dist');
6618: END IF;
6619:

Line 7049: FND_LOG.STRING(g_level_statement,

7045: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)
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:

Line 7480: FND_LOG.STRING(g_level_statement,

7476: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
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:

Line 7488: FND_LOG.STRING(g_level_statement,

7484:
7485: -- COMMIT;
7486:
7487: IF (g_level_statement >= g_current_runtime_level ) THEN
7488: FND_LOG.STRING(g_level_statement,
7489: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
7490: 'Inserting data into zx_lines(Tax Code)');
7491: END IF;
7492:

Line 8195: FND_LOG.STRING(g_level_statement,

8191: AND status.content_owner_id(+) = rates.content_owner_id
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:

Line 8201: FND_LOG.STRING(g_level_statement,

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
8201: FND_LOG.STRING(g_level_statement,
8202: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8203: 'Inserting data into zx_lines(Tax Group)');
8204: END IF;
8205:

Line 8921: FND_LOG.STRING(g_level_statement,

8917: AND status.content_owner_id(+) = rates.content_owner_id
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:

Line 8929: FND_LOG.STRING(g_level_statement,

8925:
8926: -- COMMIT;
8927:
8928: IF (g_level_statement >= g_current_runtime_level ) THEN
8929: FND_LOG.STRING(g_level_statement,
8930: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8931: 'Inserting data into zx_rec_nrec_dist');
8932: END IF;
8933:

Line 9363: FND_LOG.STRING(g_level_statement,

9359: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)
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:

Line 9372: FND_LOG.STRING(g_level_procedure,

9368:
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:

Line 9381: FND_LOG.STRING(g_level_unexpected,

9377: EXCEPTION
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',

Line 9384: FND_LOG.STRING(g_level_unexpected,

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(-)');
9387: END IF;
9388: