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_TRL_DETAIL_OVERRIDE_PKG dependencies on ZX_TRL_DETAIL_OVERRIDE_PKG

Line 1: PACKAGE BODY ZX_TRL_DETAIL_OVERRIDE_PKG AS

1: PACKAGE BODY ZX_TRL_DETAIL_OVERRIDE_PKG AS
2: /* $Header: zxriovrdetlnpkgb.pls 120.85.12020000.3 2012/08/17 13:24:41 ssohal noship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 336: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.BEGIN',

332: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
333:
334: IF (g_level_procedure >= g_current_runtime_level ) THEN
335: FND_LOG.STRING(g_level_procedure,
336: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.BEGIN',
337: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Insert_Row (+)');
338: END IF;
339:
340: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 337: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Insert_Row (+)');

333:
334: IF (g_level_procedure >= g_current_runtime_level ) THEN
335: FND_LOG.STRING(g_level_procedure,
336: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.BEGIN',
337: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Insert_Row (+)');
338: END IF;
339:
340: IF (g_level_procedure >= g_current_runtime_level ) THEN
341: FND_LOG.STRING(g_level_procedure,

Line 342: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

338: END IF;
339:
340: IF (g_level_procedure >= g_current_runtime_level ) THEN
341: FND_LOG.STRING(g_level_procedure,
342: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
343: 'Inserting into ZX_LINES (+)');
344: FND_LOG.STRING(g_level_procedure,
345: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
346: 'Input Parameters : Tax_Line_Number='||TO_CHAR(p_tax_line_number)||

Line 345: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

341: FND_LOG.STRING(g_level_procedure,
342: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
343: 'Inserting into ZX_LINES (+)');
344: FND_LOG.STRING(g_level_procedure,
345: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
346: 'Input Parameters : Tax_Line_Number='||TO_CHAR(p_tax_line_number)||
347: ', Application_Id='||TO_CHAR(p_application_id)||
348: ', Entity_Code='||p_entity_code||
349: ', Event_Class_Code='||p_event_class_code||

Line 367: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

363: AND application_id = p_application_id;
364: EXCEPTION WHEN NO_DATA_FOUND THEN
365: IF (g_level_procedure >= g_current_runtime_level ) THEN
366: FND_LOG.STRING(g_level_procedure,
367: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
368: 'No data found while querying up zx_event_cls_mappings Please check seed data');
369: END IF;
370: END;
371:

Line 412: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

408: WHERE tax_id = p_tax_id;
409: EXCEPTION WHEN NO_DATA_FOUND THEN
410: IF (g_level_procedure >= g_current_runtime_level ) THEN
411: FND_LOG.STRING(g_level_procedure,
412: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
413: 'No data found while querying up taxes using the tax id Possibly an invalid tax id is passed');
414: END IF;
415: END;
416: END IF;

Line 1037: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

1033: CLOSE C;
1034:
1035: IF (g_level_procedure >= g_current_runtime_level ) THEN
1036: FND_LOG.STRING(g_level_procedure,
1037: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
1038: 'Inserting into ZX_LINES (-)');
1039: END IF;
1040:
1041: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1043: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

1039: END IF;
1040:
1041: IF (g_level_procedure >= g_current_runtime_level ) THEN
1042: FND_LOG.STRING(g_level_procedure,
1043: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
1044: 'Set Recalc_Required_Flag');
1045: END IF;
1046:
1047: --Set recalculate_required_flag = 'Y' for all the tax lines for the same

Line 1061: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.END',

1057: AND COMPOUNDING_TAX_MISS_FLAG = 'Y';
1058:
1059: IF (g_level_procedure >= g_current_runtime_level ) THEN
1060: FND_LOG.STRING(g_level_procedure,
1061: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.END',
1062: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Insert_Row (-)');
1063: END IF;
1064:
1065: END Insert_Row;

Line 1062: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Insert_Row (-)');

1058:
1059: IF (g_level_procedure >= g_current_runtime_level ) THEN
1060: FND_LOG.STRING(g_level_procedure,
1061: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.END',
1062: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Insert_Row (-)');
1063: END IF;
1064:
1065: END Insert_Row;
1066:

Line 1684: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_Row.BEGIN',

1680: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1681:
1682: IF (g_level_procedure >= g_current_runtime_level ) THEN
1683: FND_LOG.STRING(g_level_procedure,
1684: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_Row.BEGIN',
1685: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Lock_Row (+)');
1686: END IF;
1687:
1688: OPEN lines_csr;

Line 1685: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Lock_Row (+)');

1681:
1682: IF (g_level_procedure >= g_current_runtime_level ) THEN
1683: FND_LOG.STRING(g_level_procedure,
1684: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_Row.BEGIN',
1685: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Lock_Row (+)');
1686: END IF;
1687:
1688: OPEN lines_csr;
1689: FETCH lines_csr INTO Recinfo;

Line 2548: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_Row.END',

2544: END IF;
2545:
2546: IF (g_level_procedure >= g_current_runtime_level ) THEN
2547: FND_LOG.STRING(g_level_procedure,
2548: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_Row.END',
2549: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Lock_Row (-)');
2550: END IF;
2551:
2552: END Lock_Row;

Line 2549: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Lock_Row (-)');

2545:
2546: IF (g_level_procedure >= g_current_runtime_level ) THEN
2547: FND_LOG.STRING(g_level_procedure,
2548: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_Row.END',
2549: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Lock_Row (-)');
2550: END IF;
2551:
2552: END Lock_Row;
2553:

Line 3001: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.BEGIN',

2997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2998:
2999: IF (g_level_procedure >= g_current_runtime_level ) THEN
3000: FND_LOG.STRING(g_level_procedure,
3001: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.BEGIN',
3002: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (+)');
3003: FND_LOG.STRING(g_level_procedure,
3004: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3005: 'Input Parameters : Application_Id='||TO_CHAR(p_application_id)||

Line 3002: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (+)');

2998:
2999: IF (g_level_procedure >= g_current_runtime_level ) THEN
3000: FND_LOG.STRING(g_level_procedure,
3001: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.BEGIN',
3002: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (+)');
3003: FND_LOG.STRING(g_level_procedure,
3004: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3005: 'Input Parameters : Application_Id='||TO_CHAR(p_application_id)||
3006: ', Entity_Code='||p_entity_code||

Line 3004: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',

3000: FND_LOG.STRING(g_level_procedure,
3001: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.BEGIN',
3002: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (+)');
3003: FND_LOG.STRING(g_level_procedure,
3004: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3005: 'Input Parameters : Application_Id='||TO_CHAR(p_application_id)||
3006: ', Entity_Code='||p_entity_code||
3007: ', Event_Class_Code='||p_event_class_code||
3008: ', Trx_Id='||TO_CHAR(p_trx_id)||

Line 3135: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',

3131: THEN
3132:
3133: IF (g_level_procedure >= g_current_runtime_level ) THEN
3134: FND_LOG.STRING(g_level_procedure,
3135: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3136: 'Inside summary tax line criteria changed');
3137: END IF;
3138:
3139: SELECT zx_lines_s.nextval into l_tax_line_id

Line 3535: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',

3531: p_taxable_amt = 0 AND
3532: p_other_doc_source = 'REFERENCE' THEN
3533: IF (g_level_procedure >= g_current_runtime_level ) THEN
3534: FND_LOG.STRING(g_level_procedure,
3535: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3536: 'Tax Lines are created for variance purposes, no updates will be allowed');
3537: END IF;
3538: -- Tax Lines are created for variance purposes, no updates will be allowed.
3539: ELSE

Line 3630: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',

3626: END IF; --IF p_freeze_until_overriddn_flg = 'Y'
3627:
3628: IF (g_level_procedure >= g_current_runtime_level ) THEN
3629: FND_LOG.STRING(g_level_procedure,
3630: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3631: 'Update recalc_required_flag in zx_lines');
3632: END IF;
3633:
3634: BEGIN

Line 3692: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.END',

3688: END IF;
3689:
3690: IF (g_level_procedure >= g_current_runtime_level ) THEN
3691: FND_LOG.STRING(g_level_procedure,
3692: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.END',
3693: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (-)');
3694: END IF;
3695:
3696: END Update_Row;

Line 3693: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (-)');

3689:
3690: IF (g_level_procedure >= g_current_runtime_level ) THEN
3691: FND_LOG.STRING(g_level_procedure,
3692: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.END',
3693: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (-)');
3694: END IF;
3695:
3696: END Update_Row;
3697:

Line 4011: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.BEGIN',

4007: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4008:
4009: IF (g_level_procedure >= g_current_runtime_level ) THEN
4010: FND_LOG.STRING(g_level_procedure,
4011: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.BEGIN',
4012: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (+)');
4013: END IF;
4014:
4015: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 4012: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (+)');

4008:
4009: IF (g_level_procedure >= g_current_runtime_level ) THEN
4010: FND_LOG.STRING(g_level_procedure,
4011: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.BEGIN',
4012: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (+)');
4013: END IF;
4014:
4015: IF (g_level_procedure >= g_current_runtime_level ) THEN
4016: FND_LOG.STRING(g_level_procedure,

Line 4017: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',

4013: END IF;
4014:
4015: IF (g_level_procedure >= g_current_runtime_level ) THEN
4016: FND_LOG.STRING(g_level_procedure,
4017: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4018: 'Update zx_lines for delete and cancel flag (+)');
4019: END IF;
4020:
4021: UPDATE ZX_LINES

Line 4030: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',

4026: WHERE TAX_LINE_ID = p_tax_line_id;
4027:
4028: IF (g_level_procedure >= g_current_runtime_level ) THEN
4029: FND_LOG.STRING(g_level_procedure,
4030: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4031: 'Update zx_lines for delete and cancel flag (-)');
4032: END IF;
4033:
4034: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 4036: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.END',

4032: END IF;
4033:
4034: IF (g_level_procedure >= g_current_runtime_level ) THEN
4035: FND_LOG.STRING(g_level_procedure,
4036: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.END',
4037: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (-)');
4038: END IF;
4039: END Delete_Row;
4040:

Line 4037: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (-)');

4033:
4034: IF (g_level_procedure >= g_current_runtime_level ) THEN
4035: FND_LOG.STRING(g_level_procedure,
4036: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.END',
4037: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (-)');
4038: END IF;
4039: END Delete_Row;
4040:
4041: PROCEDURE Override_Row

Line 4059: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.BEGIN',

4055: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4056:
4057: IF (g_level_procedure >= g_current_runtime_level ) THEN
4058: FND_LOG.STRING(g_level_procedure,
4059: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.BEGIN',
4060: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row(+)');
4061: END IF;
4062:
4063: --

Line 4060: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row(+)');

4056:
4057: IF (g_level_procedure >= g_current_runtime_level ) THEN
4058: FND_LOG.STRING(g_level_procedure,
4059: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.BEGIN',
4060: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row(+)');
4061: END IF;
4062:
4063: --
4064: -- obtain lock before update ZX_LINES_DET_FACTORS

Line 4088: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.END',

4084: END IF;
4085:
4086: IF (g_level_procedure >= g_current_runtime_level ) THEN
4087: FND_LOG.STRING(g_level_procedure,
4088: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.END',
4089: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row (-)');
4090: END IF;
4091:
4092: END Override_Row;

Line 4089: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row (-)');

4085:
4086: IF (g_level_procedure >= g_current_runtime_level ) THEN
4087: FND_LOG.STRING(g_level_procedure,
4088: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.END',
4089: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row (-)');
4090: END IF;
4091:
4092: END Override_Row;
4093:

Line 4124: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.BEGIN',

4120: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4121:
4122: IF (g_level_procedure >= g_current_runtime_level ) THEN
4123: FND_LOG.STRING(g_level_procedure,
4124: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.BEGIN',
4125: 'ZX_TRL_DETAIL_OVERRIDE_PKG: lock_dtl_tax_lines_for_doc (+)');
4126: END IF;
4127:
4128: OPEN lock_dtl_tax_lines_for_doc_csr(p_application_id,

Line 4125: 'ZX_TRL_DETAIL_OVERRIDE_PKG: lock_dtl_tax_lines_for_doc (+)');

4121:
4122: IF (g_level_procedure >= g_current_runtime_level ) THEN
4123: FND_LOG.STRING(g_level_procedure,
4124: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.BEGIN',
4125: 'ZX_TRL_DETAIL_OVERRIDE_PKG: lock_dtl_tax_lines_for_doc (+)');
4126: END IF;
4127:
4128: OPEN lock_dtl_tax_lines_for_doc_csr(p_application_id,
4129: p_event_class_code,

Line 4136: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.END',

4132: CLOSE lock_dtl_tax_lines_for_doc_csr;
4133:
4134: IF (g_level_procedure >= g_current_runtime_level ) THEN
4135: FND_LOG.STRING(g_level_procedure,
4136: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.END',
4137: 'ZX_TRL_DETAIL_OVERRIDE_PKG: lock_dtl_tax_lines_for_doc (-)');
4138: END IF;
4139: EXCEPTION
4140: WHEN OTHERS THEN

Line 4137: 'ZX_TRL_DETAIL_OVERRIDE_PKG: lock_dtl_tax_lines_for_doc (-)');

4133:
4134: IF (g_level_procedure >= g_current_runtime_level ) THEN
4135: FND_LOG.STRING(g_level_procedure,
4136: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.END',
4137: 'ZX_TRL_DETAIL_OVERRIDE_PKG: lock_dtl_tax_lines_for_doc (-)');
4138: END IF;
4139: EXCEPTION
4140: WHEN OTHERS THEN
4141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4149: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc',

4145: FND_MSG_PUB.Add;
4146:
4147: IF (g_level_procedure >= g_current_runtime_level ) THEN
4148: FND_LOG.STRING(g_level_procedure,
4149: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc',
4150: 'Exception:' ||x_error_buffer);
4151: END IF;
4152: END lock_dtl_tax_lines_for_doc;
4153:

Line 4155: END ZX_TRL_DETAIL_OVERRIDE_PKG;

4151: END IF;
4152: END lock_dtl_tax_lines_for_doc;
4153:
4154:
4155: END ZX_TRL_DETAIL_OVERRIDE_PKG;