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.62.12010000.8 2009/02/03 13:19:52 rajessub 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: zxriovrdetlnpkgb.pls 120.62.12010000.8 2009/02/03 13:19:52 rajessub 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: 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 331: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

327: FROM ZX_LINES
328: WHERE TAX_LINE_ID = p_tax_line_id;
329:
330: BEGIN
331: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
332:
333: IF (g_level_procedure >= g_current_runtime_level ) THEN
334: FND_LOG.STRING(g_level_procedure,
335: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.BEGIN',

Line 334: FND_LOG.STRING(g_level_procedure,

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

Line 340: FND_LOG.STRING(g_level_procedure,

336: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Insert_Row (+)');
337: END IF;
338:
339: IF (g_level_procedure >= g_current_runtime_level ) THEN
340: FND_LOG.STRING(g_level_procedure,
341: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
342: 'Inserting into ZX_LINES (+)');
343: FND_LOG.STRING(g_level_procedure,
344: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 343: FND_LOG.STRING(g_level_procedure,

339: IF (g_level_procedure >= g_current_runtime_level ) THEN
340: FND_LOG.STRING(g_level_procedure,
341: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
342: 'Inserting into ZX_LINES (+)');
343: FND_LOG.STRING(g_level_procedure,
344: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
345: 'p_entity_code '||p_entity_code);
346: FND_LOG.STRING(g_level_procedure,
347: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 346: FND_LOG.STRING(g_level_procedure,

342: 'Inserting into ZX_LINES (+)');
343: FND_LOG.STRING(g_level_procedure,
344: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
345: 'p_entity_code '||p_entity_code);
346: FND_LOG.STRING(g_level_procedure,
347: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
348: 'p_tax_line_number '||to_char(p_tax_line_number));
349: FND_LOG.STRING(g_level_procedure,
350: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 349: FND_LOG.STRING(g_level_procedure,

345: 'p_entity_code '||p_entity_code);
346: FND_LOG.STRING(g_level_procedure,
347: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
348: 'p_tax_line_number '||to_char(p_tax_line_number));
349: FND_LOG.STRING(g_level_procedure,
350: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
351: 'p_event_class_code '||p_event_class_code);
352: FND_LOG.STRING(g_level_procedure,
353: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 352: FND_LOG.STRING(g_level_procedure,

348: 'p_tax_line_number '||to_char(p_tax_line_number));
349: FND_LOG.STRING(g_level_procedure,
350: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
351: 'p_event_class_code '||p_event_class_code);
352: FND_LOG.STRING(g_level_procedure,
353: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
354: 'p_application_id '||p_application_id);
355: FND_LOG.STRING(g_level_procedure,
356: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 355: FND_LOG.STRING(g_level_procedure,

351: 'p_event_class_code '||p_event_class_code);
352: FND_LOG.STRING(g_level_procedure,
353: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
354: 'p_application_id '||p_application_id);
355: FND_LOG.STRING(g_level_procedure,
356: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
357: 'p_tax_id ' ||p_tax_id);
358: END IF;
359:

Line 368: FND_LOG.STRING(g_level_procedure,

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

Line 408: FND_LOG.STRING(g_level_procedure,

404: from zx_taxes_b where
405: tax_id = p_tax_id;
406: EXCEPTION WHEN NO_DATA_FOUND THEN
407: IF (g_level_procedure >= g_current_runtime_level ) THEN
408: FND_LOG.STRING(g_level_procedure,
409: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
410: 'No data found while querying up taxes using the tax id Possibly an invalid tax id is passed');
411: END IF;
412: END;

Line 1031: FND_LOG.STRING(g_level_procedure,

1027:
1028: CLOSE C;
1029:
1030: IF (g_level_procedure >= g_current_runtime_level ) THEN
1031: FND_LOG.STRING(g_level_procedure,
1032: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
1033: 'Inserting into ZX_LINES (-)');
1034: END IF;
1035:

Line 1037: FND_LOG.STRING(g_level_procedure,

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

Line 1055: FND_LOG.STRING(g_level_procedure,

1051: AND TRX_LEVEL_TYPE = p_trx_level_type
1052: AND COMPOUNDING_TAX_MISS_FLAG = 'Y';
1053:
1054: IF (g_level_procedure >= g_current_runtime_level ) THEN
1055: FND_LOG.STRING(g_level_procedure,
1056: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.',
1057: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update ZX_LINES (-)');
1058: END IF;
1059:

Line 1061: FND_LOG.STRING(g_level_procedure,

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

Line 1681: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1677: l_return_status VARCHAR2(1000);
1678:
1679: BEGIN
1680:
1681: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1682:
1683: IF (g_level_procedure >= g_current_runtime_level ) THEN
1684: FND_LOG.STRING(g_level_procedure,
1685: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_Row.BEGIN',

Line 1684: FND_LOG.STRING(g_level_procedure,

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

Line 2548: FND_LOG.STRING(g_level_procedure,

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

Line 2996: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2992:
2993: BEGIN
2994:
2995: l_same_line := TRUE;
2996: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2997:
2998: IF (g_level_procedure >= g_current_runtime_level ) THEN
2999: FND_LOG.STRING(g_level_procedure,
3000: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.BEGIN',

Line 2999: FND_LOG.STRING(g_level_procedure,

2995: l_same_line := TRUE;
2996: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2997:
2998: IF (g_level_procedure >= g_current_runtime_level ) THEN
2999: FND_LOG.STRING(g_level_procedure,
3000: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.BEGIN',
3001: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (+)');
3002: END IF;
3003:

Line 3005: FND_LOG.STRING(g_level_procedure,

3001: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (+)');
3002: END IF;
3003:
3004: IF (g_level_procedure >= g_current_runtime_level ) THEN
3005: FND_LOG.STRING(g_level_procedure,
3006: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3007: 'Update ZX_LINES (+)');
3008: END IF;
3009:

Line 3011: FND_LOG.STRING(g_level_procedure,

3007: 'Update ZX_LINES (+)');
3008: END IF;
3009:
3010: IF (g_level_procedure >= g_current_runtime_level ) THEN
3011: FND_LOG.STRING(g_level_procedure,
3012: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3013: 'p_trx_id: '||to_char(p_trx_id));
3014: END IF;
3015:

Line 3017: FND_LOG.STRING(g_level_procedure,

3013: 'p_trx_id: '||to_char(p_trx_id));
3014: END IF;
3015:
3016: IF (g_level_procedure >= g_current_runtime_level ) THEN
3017: FND_LOG.STRING(g_level_procedure,
3018: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3019: 'p_Compounding_Tax_Flag: '||p_compounding_tax_flag);
3020: END IF;
3021:

Line 3023: FND_LOG.STRING(g_level_procedure,

3019: 'p_Compounding_Tax_Flag: '||p_compounding_tax_flag);
3020: END IF;
3021:
3022: IF (g_level_procedure >= g_current_runtime_level ) THEN
3023: FND_LOG.STRING(g_level_procedure,
3024: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3025: 'p_Tax_Amt_Included_Flag: '||p_tax_amt_included_flag);
3026: END IF;
3027:

Line 3029: FND_LOG.STRING(g_level_procedure,

3025: 'p_Tax_Amt_Included_Flag: '||p_tax_amt_included_flag);
3026: END IF;
3027:
3028: IF (g_level_procedure >= g_current_runtime_level ) THEN
3029: FND_LOG.STRING(g_level_procedure,
3030: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3031: 'p_Recalc_Required_Flag: '||p_recalc_required_flag);
3032: END IF;
3033:

Line 3035: FND_LOG.STRING(g_level_procedure,

3031: 'p_Recalc_Required_Flag: '||p_recalc_required_flag);
3032: END IF;
3033:
3034: IF (g_level_procedure >= g_current_runtime_level ) THEN
3035: FND_LOG.STRING(g_level_procedure,
3036: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3037: 'p_Process_For_Recovery_Flag: '||p_process_for_recovery_flag);
3038: END IF;
3039:

Line 3090: FND_LOG.STRING(g_level_procedure,

3086: l_overridden_flag := p_overridden_flag;
3087: l_process_for_recovery_flag := NVL(p_process_for_recovery_flag, 'N');
3088:
3089: IF (g_level_procedure >= g_current_runtime_level ) THEN
3090: FND_LOG.STRING(g_level_procedure,
3091: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3092: 'assoc child frozen flag: '||p_assoc_children_frozen_flg);
3093: FND_LOG.STRING(g_level_procedure,
3094: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 3093: FND_LOG.STRING(g_level_procedure,

3089: IF (g_level_procedure >= g_current_runtime_level ) THEN
3090: FND_LOG.STRING(g_level_procedure,
3091: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3092: 'assoc child frozen flag: '||p_assoc_children_frozen_flg);
3093: FND_LOG.STRING(g_level_procedure,
3094: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3095: 'Inserting into tax only line flag'||p_tax_only_line_flag);
3096: FND_LOG.STRING(g_level_procedure,
3097: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 3096: FND_LOG.STRING(g_level_procedure,

3092: 'assoc child frozen flag: '||p_assoc_children_frozen_flg);
3093: FND_LOG.STRING(g_level_procedure,
3094: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3095: 'Inserting into tax only line flag'||p_tax_only_line_flag);
3096: FND_LOG.STRING(g_level_procedure,
3097: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3098: 'tax rate code'||p_tax_rate_code);
3099: FND_LOG.STRING(g_level_procedure,
3100: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 3099: FND_LOG.STRING(g_level_procedure,

3095: 'Inserting into tax only line flag'||p_tax_only_line_flag);
3096: FND_LOG.STRING(g_level_procedure,
3097: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3098: 'tax rate code'||p_tax_rate_code);
3099: FND_LOG.STRING(g_level_procedure,
3100: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3101: 'trx id '||p_trx_id);
3102: FND_LOG.STRING(g_level_procedure,
3103: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 3102: FND_LOG.STRING(g_level_procedure,

3098: 'tax rate code'||p_tax_rate_code);
3099: FND_LOG.STRING(g_level_procedure,
3100: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3101: 'trx id '||p_trx_id);
3102: FND_LOG.STRING(g_level_procedure,
3103: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3104: 'trx line id '||p_trx_line_id);
3105: FND_LOG.STRING(g_level_procedure,
3106: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 3105: FND_LOG.STRING(g_level_procedure,

3101: 'trx id '||p_trx_id);
3102: FND_LOG.STRING(g_level_procedure,
3103: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3104: 'trx line id '||p_trx_line_id);
3105: FND_LOG.STRING(g_level_procedure,
3106: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3107: 'trx level type '||p_trx_level_type);
3108: FND_LOG.STRING(g_level_procedure,
3109: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 3108: FND_LOG.STRING(g_level_procedure,

3104: 'trx line id '||p_trx_line_id);
3105: FND_LOG.STRING(g_level_procedure,
3106: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3107: 'trx level type '||p_trx_level_type);
3108: FND_LOG.STRING(g_level_procedure,
3109: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3110: 'taxlevel type '||p_trx_level_type);
3111: FND_LOG.STRING(g_level_procedure,
3112: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',

Line 3111: FND_LOG.STRING(g_level_procedure,

3107: 'trx level type '||p_trx_level_type);
3108: FND_LOG.STRING(g_level_procedure,
3109: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3110: 'taxlevel type '||p_trx_level_type);
3111: FND_LOG.STRING(g_level_procedure,
3112: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3113: 'tax line id '||p_tax_line_id);
3114: END IF;
3115: IF nvl(p_tax_only_line_flag,'N') = 'N' THEN

Line 3118: FND_LOG.STRING(g_level_procedure,

3114: END IF;
3115: IF nvl(p_tax_only_line_flag,'N') = 'N' THEN
3116:
3117: IF (g_level_procedure >= g_current_runtime_level ) THEN
3118: FND_LOG.STRING(g_level_procedure,
3119: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3120: 'inside tax only line');
3121: END IF;
3122:

Line 3126: FND_LOG.STRING(g_level_procedure,

3122:
3123: IF nvl(p_assoc_children_frozen_flg,'N') = 'Y' THEN
3124:
3125: IF (g_level_procedure >= g_current_runtime_level ) THEN
3126: FND_LOG.STRING(g_level_procedure,
3127: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3128: 'inside assoc child frozen');
3129: END IF;
3130:

Line 3132: FND_LOG.STRING(g_level_procedure,

3128: 'inside assoc child frozen');
3129: END IF;
3130:
3131: IF (g_level_procedure >= g_current_runtime_level ) THEN
3132: FND_LOG.STRING(g_level_procedure,
3133: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3134: 'appl id'||p_application_id);
3135: END IF;
3136:

Line 3138: FND_LOG.STRING(g_level_procedure,

3134: 'appl id'||p_application_id);
3135: END IF;
3136:
3137: IF (g_level_procedure >= g_current_runtime_level ) THEN
3138: FND_LOG.STRING(g_level_procedure,
3139: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3140: 'entity code'||p_entity_code);
3141: END IF;
3142:

Line 3144: FND_LOG.STRING(g_level_procedure,

3140: 'entity code'||p_entity_code);
3141: END IF;
3142:
3143: IF (g_level_procedure >= g_current_runtime_level ) THEN
3144: FND_LOG.STRING(g_level_procedure,
3145: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3146: 'event class code code'||p_event_class_code);
3147: END IF;
3148: For rec in c_line (p_application_id, p_entity_code, p_event_class_code,

Line 3151: FND_LOG.STRING(g_level_procedure,

3147: END IF;
3148: For rec in c_line (p_application_id, p_entity_code, p_event_class_code,
3149: p_trx_id,p_trx_line_id,p_trx_level_type, p_tax_line_id) loop
3150: IF (g_level_procedure >= g_current_runtime_level ) THEN
3151: FND_LOG.STRING(g_level_procedure,
3152: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
3153: 'rec tax rate code'||rec.tax_rate_code);
3154: END IF;
3155: IF ( rec.tax_status_code <> p_tax_status_code OR

Line 3198: FND_LOG.STRING(g_level_procedure,

3194: )
3195: THEN
3196:
3197: IF (g_level_procedure >= g_current_runtime_level ) THEN
3198: FND_LOG.STRING(g_level_procedure,
3199: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3200: 'inside if '||p_recalc_required_flag);
3201: END IF;
3202:

Line 3275: FND_LOG.STRING(g_level_procedure,

3271:
3272: l_same_line := FALSE;
3273:
3274: IF (g_level_procedure >= g_current_runtime_level ) THEN
3275: FND_LOG.STRING(g_level_procedure,
3276: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3277: ' tax apportionment line num: '||l_tax_apportionment_line_num);
3278: END IF;
3279:

Line 3653: FND_LOG.STRING(g_level_procedure,

3649:
3650: END IF;
3651:
3652: IF (g_level_procedure >= g_current_runtime_level ) THEN
3653: FND_LOG.STRING(g_level_procedure,
3654: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3655: 'Update ZX_LINES (-)');
3656: END IF;
3657:

Line 3659: FND_LOG.STRING(g_level_procedure,

3655: 'Update ZX_LINES (-)');
3656: END IF;
3657:
3658: IF (g_level_procedure >= g_current_runtime_level ) THEN
3659: FND_LOG.STRING(g_level_procedure,
3660: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3661: 'Update RECALC_REQUIRED_FLAG in ZX_LINES (+)');
3662: END IF;
3663:

Line 3722: FND_LOG.STRING(g_level_procedure,

3718: END IF;
3719: END IF;
3720:
3721: IF (g_level_procedure >= g_current_runtime_level ) THEN
3722: FND_LOG.STRING(g_level_procedure,
3723: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3724: 'Update RECALC_REQUIRED_FLAG in ZX_LINES (-)');
3725: END IF;
3726:

Line 3728: FND_LOG.STRING(g_level_procedure,

3724: 'Update RECALC_REQUIRED_FLAG in ZX_LINES (-)');
3725: END IF;
3726:
3727: IF (g_level_procedure >= g_current_runtime_level ) THEN
3728: FND_LOG.STRING(g_level_procedure,
3729: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row.END',
3730: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update_Row (-)');
3731: END IF;
3732:

Line 4044: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4040: l_msg_data VARCHAR2(1000);
4041:
4042: BEGIN
4043:
4044: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4045:
4046: IF (g_level_procedure >= g_current_runtime_level ) THEN
4047: FND_LOG.STRING(g_level_procedure,
4048: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.BEGIN',

Line 4047: FND_LOG.STRING(g_level_procedure,

4043:
4044: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4045:
4046: IF (g_level_procedure >= g_current_runtime_level ) THEN
4047: FND_LOG.STRING(g_level_procedure,
4048: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.BEGIN',
4049: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (+)');
4050: END IF;
4051:

Line 4053: FND_LOG.STRING(g_level_procedure,

4049: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (+)');
4050: END IF;
4051:
4052: IF (g_level_procedure >= g_current_runtime_level ) THEN
4053: FND_LOG.STRING(g_level_procedure,
4054: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4055: 'Update zx_lines for delete and cancel flag (+)');
4056: END IF;
4057:

Line 4066: FND_LOG.STRING(g_level_procedure,

4062: OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1)
4063: WHERE TAX_LINE_ID = p_tax_line_id;
4064:
4065: IF (g_level_procedure >= g_current_runtime_level ) THEN
4066: FND_LOG.STRING(g_level_procedure,
4067: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4068: 'Update zx_lines for delete and cancel flag (-)');
4069: END IF;
4070:

Line 4072: FND_LOG.STRING(g_level_procedure,

4068: 'Update zx_lines for delete and cancel flag (-)');
4069: END IF;
4070:
4071: IF (g_level_procedure >= g_current_runtime_level ) THEN
4072: FND_LOG.STRING(g_level_procedure,
4073: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row.END',
4074: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Delete_Row (-)');
4075: END IF;
4076: END Delete_Row;

Line 4092: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4088: l_return_status VARCHAR2(80);
4089:
4090: BEGIN
4091:
4092: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4093:
4094: IF (g_level_procedure >= g_current_runtime_level ) THEN
4095: FND_LOG.STRING(g_level_procedure,
4096: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.BEGIN',

Line 4095: FND_LOG.STRING(g_level_procedure,

4091:
4092: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4093:
4094: IF (g_level_procedure >= g_current_runtime_level ) THEN
4095: FND_LOG.STRING(g_level_procedure,
4096: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.BEGIN',
4097: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row(+)');
4098: END IF;
4099:

Line 4124: FND_LOG.STRING(g_level_procedure,

4120: AND TRX_LINE_ID = p_trx_line_id;
4121: END IF;
4122:
4123: IF (g_level_procedure >= g_current_runtime_level ) THEN
4124: FND_LOG.STRING(g_level_procedure,
4125: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Override_Row.END',
4126: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row (-)');
4127: END IF;
4128:

Line 4157: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4153:
4154: BEGIN
4155: x_return_status := FND_API.G_RET_STS_SUCCESS;
4156:
4157: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4158:
4159: IF (g_level_procedure >= g_current_runtime_level ) THEN
4160: FND_LOG.STRING(g_level_procedure,
4161: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.BEGIN',

Line 4160: FND_LOG.STRING(g_level_procedure,

4156:
4157: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4158:
4159: IF (g_level_procedure >= g_current_runtime_level ) THEN
4160: FND_LOG.STRING(g_level_procedure,
4161: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.BEGIN',
4162: 'ZX_TRL_DETAIL_OVERRIDE_PKG: lock_dtl_tax_lines_for_doc (+)');
4163: END IF;
4164:

Line 4172: FND_LOG.STRING(g_level_procedure,

4168: p_trx_id);
4169: CLOSE lock_dtl_tax_lines_for_doc_csr;
4170:
4171: IF (g_level_procedure >= g_current_runtime_level ) THEN
4172: FND_LOG.STRING(g_level_procedure,
4173: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc.END',
4174: 'ZX_TRL_DETAIL_OVERRIDE_PKG: lock_dtl_tax_lines_for_doc (-)');
4175: END IF;
4176: EXCEPTION

Line 4185: FND_LOG.STRING(g_level_procedure,

4181: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
4182: FND_MSG_PUB.Add;
4183:
4184: IF (g_level_procedure >= g_current_runtime_level ) THEN
4185: FND_LOG.STRING(g_level_procedure,
4186: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.lock_dtl_tax_lines_for_doc',
4187: 'Exception:' ||x_error_buffer);
4188: END IF;
4189: END lock_dtl_tax_lines_for_doc;