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 FND_LOG

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

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;
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: 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;
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: DATE_DUMMY CONSTANT DATE := TO_DATE('01-01-1951', 'DD-MM-YYYY');

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: DATE_DUMMY CONSTANT DATE := TO_DATE('01-01-1951', 'DD-MM-YYYY');
11:

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: DATE_DUMMY CONSTANT DATE := TO_DATE('01-01-1951', 'DD-MM-YYYY');
11:
12: PROCEDURE Insert_Row

Line 332: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

328: FROM ZX_LINES
329: WHERE TAX_LINE_ID = p_tax_line_id;
330:
331: 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',

Line 335: FND_LOG.STRING(g_level_procedure,

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

Line 341: FND_LOG.STRING(g_level_procedure,

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,
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',

Line 344: FND_LOG.STRING(g_level_procedure,

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)||
347: ', Application_Id='||TO_CHAR(p_application_id)||
348: ', Entity_Code='||p_entity_code||

Line 366: FND_LOG.STRING(g_level_procedure,

362: AND event_class_code = p_event_class_code
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;

Line 411: FND_LOG.STRING(g_level_procedure,

407: FROM zx_taxes_b
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;

Line 1036: FND_LOG.STRING(g_level_procedure,

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

Line 1042: FND_LOG.STRING(g_level_procedure,

1038: 'Inserting into ZX_LINES (-)');
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:

Line 1060: FND_LOG.STRING(g_level_procedure,

1056: AND TRX_LEVEL_TYPE = p_trx_level_type
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:

Line 1680: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1676: l_return_status VARCHAR2(1000);
1677:
1678: BEGIN
1679:
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',

Line 1683: FND_LOG.STRING(g_level_procedure,

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

Line 2547: FND_LOG.STRING(g_level_procedure,

2543: APP_EXCEPTION.Raise_Exception;
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:

Line 2997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2993: BEGIN
2994:
2995: l_same_line := TRUE;
2996: l_tax_amt_incl_changed := NVL(p_tax_amt_included_flag,'N');
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',

Line 3000: FND_LOG.STRING(g_level_procedure,

2996: l_tax_amt_incl_changed := NVL(p_tax_amt_included_flag,'N');
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',

Line 3003: FND_LOG.STRING(g_level_procedure,

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||
3007: ', Event_Class_Code='||p_event_class_code||

Line 3134: FND_LOG.STRING(g_level_procedure,

3130: )
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:

Line 3534: FND_LOG.STRING(g_level_procedure,

3530: p_tax_amt = 0 AND
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.

Line 3629: FND_LOG.STRING(g_level_procedure,

3625: END IF; --IF l_same_line THEN
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:

Line 3691: FND_LOG.STRING(g_level_procedure,

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

Line 4007: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4003: l_msg_data VARCHAR2(1000);
4004:
4005: BEGIN
4006:
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',

Line 4010: FND_LOG.STRING(g_level_procedure,

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

Line 4016: FND_LOG.STRING(g_level_procedure,

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,
4017: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4018: 'Update zx_lines for delete and cancel flag (+)');
4019: END IF;
4020:

Line 4029: FND_LOG.STRING(g_level_procedure,

4025: OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1)
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:

Line 4035: FND_LOG.STRING(g_level_procedure,

4031: 'Update zx_lines for delete and cancel flag (-)');
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;

Line 4055: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4051: l_return_status VARCHAR2(80);
4052:
4053: BEGIN
4054:
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',

Line 4058: FND_LOG.STRING(g_level_procedure,

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

Line 4087: FND_LOG.STRING(g_level_procedure,

4083: AND TRX_LINE_ID = p_trx_line_id;
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:

Line 4120: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4116:
4117: BEGIN
4118: x_return_status := FND_API.G_RET_STS_SUCCESS;
4119:
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',

Line 4123: FND_LOG.STRING(g_level_procedure,

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

Line 4135: FND_LOG.STRING(g_level_procedure,

4131: p_trx_id);
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

Line 4148: FND_LOG.STRING(g_level_procedure,

4144: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
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;