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.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;

Line 335: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.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:
339: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
339: IF (g_level_procedure >= g_current_runtime_level ) THEN
340: FND_LOG.STRING(g_level_procedure,

Line 341: 'ZX.PLSQL.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',
345: 'p_entity_code '||p_entity_code);

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

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',
348: 'p_tax_line_number '||to_char(p_tax_line_number));

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

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',
351: 'p_event_class_code '||p_event_class_code);

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

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',
354: 'p_application_id '||p_application_id);

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

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',
357: 'p_tax_id ' ||p_tax_id);

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

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:
360: BEGIN

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

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

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

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;
413: END if;

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

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:
1036: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
1042: --Set recalculate_required_flag = 'Y' for all the tax lines for the same

Line 1039: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update ZX_LINES (+)');

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:
1042: --Set recalculate_required_flag = 'Y' for all the tax lines for the same
1043: --trx line with compounding_tax_miss_flag = 'Y'.

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

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:
1060: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1057: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update ZX_LINES (-)');

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:
1060: IF (g_level_procedure >= g_current_runtime_level ) THEN
1061: FND_LOG.STRING(g_level_procedure,

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

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:
1066: END Insert_Row;

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

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:
1066: END Insert_Row;
1067:

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

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:
1689: OPEN lines_csr;

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

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:
1689: OPEN lines_csr;
1690: FETCH lines_csr INTO Recinfo;

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

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:
2553: END Lock_Row;

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

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:
2553: END Lock_Row;
2554:

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

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:
3004: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
3004: IF (g_level_procedure >= g_current_runtime_level ) THEN
3005: FND_LOG.STRING(g_level_procedure,

Line 3006: 'ZX.PLSQL.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:
3010: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
3016: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
3022: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
3028: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
3034: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
3040: l_tax_rate := p_tax_rate;

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

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',
3095: 'Inserting into tax only line flag'||p_tax_only_line_flag);

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

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',
3098: 'tax rate code'||p_tax_rate_code);

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

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',
3101: 'trx id '||p_trx_id);

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

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',
3104: 'trx line id '||p_trx_line_id);

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

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',
3107: 'trx level type '||p_trx_level_type);

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

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',
3110: 'taxlevel type '||p_trx_level_type);

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

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',
3113: 'tax line id '||p_tax_line_id);

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

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

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

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:
3123: IF nvl(p_assoc_children_frozen_flg,'N') = 'Y' THEN

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

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:
3131: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
3137: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
3143: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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,
3149: p_trx_id,p_trx_line_id,p_trx_level_type, p_tax_line_id) loop

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

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
3156: rec.tax_rate_id <> p_tax_rate_id OR

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

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:
3203: SELECT zx_lines_s.nextval into l_tax_line_id

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

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:
3280: Insert_Row

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

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:
3658: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
3664: BEGIN

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

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:
3727: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
3733: END Update_Row;

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

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:
3733: END Update_Row;
3734:

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

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:
4052: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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:
4052: IF (g_level_procedure >= g_current_runtime_level ) THEN
4053: FND_LOG.STRING(g_level_procedure,

Line 4054: 'ZX.PLSQL.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:
4058: UPDATE ZX_LINES

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

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:
4071: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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

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

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;
4077:
4078: PROCEDURE Override_Row

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

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

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

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:
4100: --
4101: -- obtain lock before update ZX_LINES_DET_FACTORS

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

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:
4129: END Override_Row;

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

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:
4129: END Override_Row;
4130:

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

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:
4165: OPEN lock_dtl_tax_lines_for_doc_csr(p_application_id,

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

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:
4165: OPEN lock_dtl_tax_lines_for_doc_csr(p_application_id,
4166: p_event_class_code,

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

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
4177: WHEN OTHERS THEN

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

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
4177: WHEN OTHERS THEN
4178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

Line 4192: END ZX_TRL_DETAIL_OVERRIDE_PKG;

4188: END IF;
4189: END lock_dtl_tax_lines_for_doc;
4190:
4191:
4192: END ZX_TRL_DETAIL_OVERRIDE_PKG;