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_SUMMARY_OVERRIDE_PKG dependencies on FND_LOG

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

1: PACKAGE BODY ZX_TRL_SUMMARY_OVERRIDE_PKG AS
2: /* $Header: zxriovrsumlnpkgb.pls 120.83.12020000.2 2012/08/17 13:05:42 ssohal 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: zxriovrsumlnpkgb.pls 120.83.12020000.2 2012/08/17 13:05:42 ssohal 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 143: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

139: FROM ZX_LINES_SUMMARY
140: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
141:
142: BEGIN
143: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
144:
145: IF (g_level_procedure >= g_current_runtime_level ) THEN
146: FND_LOG.STRING(g_level_procedure,
147: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.BEGIN',

Line 146: FND_LOG.STRING(g_level_procedure,

142: BEGIN
143: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
144:
145: IF (g_level_procedure >= g_current_runtime_level ) THEN
146: FND_LOG.STRING(g_level_procedure,
147: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.BEGIN',
148: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Insert_Row (+)');
149: END IF;
150:

Line 152: FND_LOG.STRING(g_level_procedure,

148: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Insert_Row (+)');
149: END IF;
150:
151: IF (g_level_procedure >= g_current_runtime_level ) THEN
152: FND_LOG.STRING(g_level_procedure,
153: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',
154: 'Insert into zx_lines_summary (+)');
155: END IF;
156:

Line 406: FND_LOG.STRING(g_level_procedure,

402:
403: CLOSE C;
404:
405: IF (g_level_procedure >= g_current_runtime_level ) THEN
406: FND_LOG.STRING(g_level_procedure,
407: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',
408: 'Insert into zx_lines_summary (-)');
409:
410: FND_LOG.STRING(g_level_procedure,

Line 410: FND_LOG.STRING(g_level_procedure,

406: FND_LOG.STRING(g_level_procedure,
407: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',
408: 'Insert into zx_lines_summary (-)');
409:
410: FND_LOG.STRING(g_level_procedure,
411: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.END',
412: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Insert_Row (-)');
413: END IF;
414:

Line 672: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

668: Recinfo summary_lines_csr%ROWTYPE;
669: l_transaction_rec ZX_API_PUB.transaction_rec_type;
670: l_return_status VARCHAR2(1000);
671: BEGIN
672: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
673:
674: IF (g_level_procedure >= g_current_runtime_level ) THEN
675: FND_LOG.STRING(g_level_procedure,
676: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Lock_Row.BEGIN',

Line 675: FND_LOG.STRING(g_level_procedure,

671: BEGIN
672: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
673:
674: IF (g_level_procedure >= g_current_runtime_level ) THEN
675: FND_LOG.STRING(g_level_procedure,
676: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Lock_Row.BEGIN',
677: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Lock_Row (+)');
678: END IF;
679:

Line 1024: FND_LOG.STRING(g_level_procedure,

1020: APP_EXCEPTION.Raise_Exception;
1021: END IF;
1022:
1023: IF (g_level_procedure >= g_current_runtime_level ) THEN
1024: FND_LOG.STRING(g_level_procedure,
1025: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Lock_Row.END',
1026: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Lock_Row (-)');
1027: END IF;
1028:

Line 1633: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1629: l_allow_update_flag VARCHAR2(1);
1630:
1631: BEGIN
1632:
1633: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1634:
1635: IF (g_level_procedure >= g_current_runtime_level ) THEN
1636: FND_LOG.STRING(g_level_procedure,
1637: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',

Line 1636: FND_LOG.STRING(g_level_procedure,

1632:
1633: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1634:
1635: IF (g_level_procedure >= g_current_runtime_level ) THEN
1636: FND_LOG.STRING(g_level_procedure,
1637: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1638: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (+)');
1639: END IF;
1640:

Line 1642: FND_LOG.STRING(g_level_statement,

1638: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (+)');
1639: END IF;
1640:
1641: IF (g_level_statement >= g_current_runtime_level) THEN
1642: FND_LOG.STRING(g_level_statement,
1643: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1644: 'Self_assessed_flag : '||p_self_assessed_flag);
1645: END IF;
1646:

Line 1669: FND_LOG.STRING(g_level_statement,

1665: AND NVL(cancel_flag, 'N') <> 'Y';
1666: EXCEPTION
1667: WHEN NO_DATA_FOUND THEN
1668: IF (g_level_statement >= g_current_runtime_level) THEN
1669: FND_LOG.STRING(g_level_statement,
1670: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1671: 'No Lines to Update ');
1672: FND_LOG.STRING(g_level_statement,
1673: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',

Line 1672: FND_LOG.STRING(g_level_statement,

1668: IF (g_level_statement >= g_current_runtime_level) THEN
1669: FND_LOG.STRING(g_level_statement,
1670: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1671: 'No Lines to Update ');
1672: FND_LOG.STRING(g_level_statement,
1673: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',
1674: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');
1675: END IF;
1676: RETURN;

Line 1685: FND_LOG.STRING(g_level_statement,

1681: -- bug#8264829- taxable_amt = 0, error if tax_amt <> 0
1682: IF (l_total_detail_taxable_amt = 0 AND
1683: p_tax_amt <> 0 ) THEN
1684: IF (g_level_statement >= g_current_runtime_level) THEN
1685: FND_LOG.STRING(g_level_statement,
1686: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1687: 'error: taxable_amt = 0 but tax_amt <> 0');
1688: END IF;
1689:

Line 1760: FND_LOG.STRING(g_level_procedure,

1756:
1757: END;
1758:
1759: IF (g_level_procedure >= g_current_runtime_level ) THEN
1760: FND_LOG.STRING(g_level_procedure,
1761: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1762: 'Update zx_lines_summary (+)');
1763: END IF;
1764:

Line 1773: FND_LOG.STRING(g_level_statement,

1769: p_summary_tax_line_id)
1770: LOOP
1771:
1772: IF (g_level_statement >= g_current_runtime_level) THEN
1773: FND_LOG.STRING(g_level_statement,
1774: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1775: 'Tax_only_line_flag : '||rec.tax_only_line_flag);
1776: FND_LOG.STRING(g_level_statement,
1777: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

Line 1776: FND_LOG.STRING(g_level_statement,

1772: IF (g_level_statement >= g_current_runtime_level) THEN
1773: FND_LOG.STRING(g_level_statement,
1774: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1775: 'Tax_only_line_flag : '||rec.tax_only_line_flag);
1776: FND_LOG.STRING(g_level_statement,
1777: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1778: 'Associated_child_frozen_flag : '||rec.associated_child_frozen_flag);
1779: END IF;
1780:

Line 1880: FND_LOG.STRING(g_level_statement,

1876: tax_hold_released_code = NULL
1877: WHERE tax_line_id = rec.tax_line_id;
1878:
1879: IF (g_level_statement >= g_current_runtime_level) THEN
1880: FND_LOG.STRING(g_level_statement,
1881: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1882: 'Tax_line_id updated : '||to_char(rec.tax_line_id));
1883: END IF;
1884:

Line 1931: FND_LOG.STRING(g_level_statement,

1927: END;
1928: END IF; -- rec.offset_tax_rate_code IS NOT NULL
1929:
1930: IF (g_level_statement >= g_current_runtime_level) THEN
1931: FND_LOG.STRING(g_level_statement,
1932: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1933: 'Offset_Tax_line_id Updated : '||to_char(l_offset_tax_line_id));
1934: END IF;
1935:

Line 1937: FND_LOG.STRING(g_level_procedure,

1933: 'Offset_Tax_line_id Updated : '||to_char(l_offset_tax_line_id));
1934: END IF;
1935:
1936: IF (g_level_procedure >= g_current_runtime_level ) THEN
1937: FND_LOG.STRING(g_level_procedure,
1938: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1939: 'Tax_apportionment_line_num : '||l_tax_apportionment_line_num);
1940: END IF;
1941:

Line 1943: FND_LOG.STRING(g_level_procedure,

1939: 'Tax_apportionment_line_num : '||l_tax_apportionment_line_num);
1940: END IF;
1941:
1942: IF (g_level_procedure >= g_current_runtime_level ) THEN
1943: FND_LOG.STRING(g_level_procedure,
1944: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1945: 'Historical_flag : '|| p_historical_flag);
1946: END IF;
1947:

Line 2341: FND_LOG.STRING(g_level_procedure,

2337: WHERE summary_tax_line_id = p_summary_tax_line_id;
2338: END IF;
2339:
2340: IF (g_level_procedure >= g_current_runtime_level ) THEN
2341: FND_LOG.STRING(g_level_procedure,
2342: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2343: 'Cancel_flag : '||p_cancel_flag);
2344: END IF;
2345:

Line 2347: FND_LOG.STRING(g_level_procedure,

2343: 'Cancel_flag : '||p_cancel_flag);
2344: END IF;
2345:
2346: IF (g_level_procedure >= g_current_runtime_level ) THEN
2347: FND_LOG.STRING(g_level_procedure,
2348: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2349: 'Total_detail_tax_amt : '||to_char(l_total_detail_tax_amt));
2350: END IF;
2351: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2352: FND_LOG.STRING(g_level_procedure,

2348: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2349: 'Total_detail_tax_amt : '||to_char(l_total_detail_tax_amt));
2350: END IF;
2351: IF (g_level_procedure >= g_current_runtime_level ) THEN
2352: FND_LOG.STRING(g_level_procedure,
2353: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2354: 'Total_detail_taxable_amt : '||to_char(l_total_detail_taxable_amt));
2355: END IF;
2356:

Line 2360: FND_LOG.STRING(g_level_statement,

2356:
2357: IF nvl(p_cancel_flag,'N') = 'N' THEN
2358: IF nvl(l_num_det_lines,0) = 1 THEN
2359: IF (g_level_statement >= g_current_runtime_level) THEN
2360: FND_LOG.STRING(g_level_statement,
2361: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2362: 'No. of Det Lines 1');
2363: END IF;
2364: UPDATE ZX_LINES

Line 2375: FND_LOG.STRING(g_level_statement,

2371: AND nvl(cancel_flag,'N') <> 'Y';
2372: ELSE
2373: IF nvl(l_total_detail_tax_amt,0) <> 0 THEN
2374: IF (g_level_statement >= g_current_runtime_level) THEN
2375: FND_LOG.STRING(g_level_statement,
2376: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2377: 'Total_detail_tax_amt <> 0');
2378: END IF;
2379: UPDATE ZX_LINES

Line 2389: FND_LOG.STRING(g_level_statement,

2385: AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2386: AND nvl(cancel_flag,'N') <> 'Y';
2387: ELSIF nvl(l_total_detail_taxable_amt,0) <> 0 THEN
2388: IF (g_level_statement >= g_current_runtime_level) THEN
2389: FND_LOG.STRING(g_level_statement,
2390: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2391: 'Total_detail_taxable_amt <> 0');
2392: END IF;
2393: UPDATE ZX_LINES

Line 2403: FND_LOG.STRING(g_level_statement,

2399: AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2400: AND nvl(cancel_flag,'N') <> 'Y';
2401: ELSE
2402: IF (g_level_statement >= g_current_runtime_level) THEN
2403: FND_LOG.STRING(g_level_statement,
2404: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2405: 'EXCEPTION');
2406: END IF;
2407: IF p_tax_amt <> 0 THEN

Line 2411: FND_LOG.STRING(g_level_statement,

2407: IF p_tax_amt <> 0 THEN
2408: --RAISE Invalid_unrounded_amt;
2409: -- Bug 7227477
2410: IF (g_level_statement >= g_current_runtime_level) THEN
2411: FND_LOG.STRING(g_level_statement,
2412: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2413: 'EXCEPTION -- Tax amount is Not Zero');
2414: END IF;
2415:

Line 2499: FND_LOG.STRING(g_level_procedure,

2495:
2496: ELSE
2497: -- Tax Lines are created for variance purposes, no updates will be allowed.
2498: IF (g_level_procedure >= g_current_runtime_level ) THEN
2499: FND_LOG.STRING(g_level_procedure,
2500: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2501: 'Tax Lines are created for variance purposes, no updates will be allowed');
2502: END IF;
2503: END IF; --l_allow_update_flag = 'Y'

Line 2506: FND_LOG.STRING(g_level_procedure,

2502: END IF;
2503: END IF; --l_allow_update_flag = 'Y'
2504:
2505: IF (g_level_procedure >= g_current_runtime_level ) THEN
2506: FND_LOG.STRING(g_level_procedure,
2507: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2508: 'Update zx_lines_summary (-)');
2509: END IF;
2510:

Line 2512: FND_LOG.STRING(g_level_procedure,

2508: 'Update zx_lines_summary (-)');
2509: END IF;
2510:
2511: IF (g_level_procedure >= g_current_runtime_level ) THEN
2512: FND_LOG.STRING(g_level_procedure,
2513: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',
2514: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');
2515: END IF;
2516: END Update_Row;

Line 2644: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2640: p_last_update_date DATE,
2641: p_last_update_login NUMBER) IS
2642:
2643: BEGIN
2644: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2645:
2646: IF (g_level_procedure >= g_current_runtime_level ) THEN
2647: FND_LOG.STRING(g_level_procedure,
2648: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.BEGIN',

Line 2647: FND_LOG.STRING(g_level_procedure,

2643: BEGIN
2644: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2645:
2646: IF (g_level_procedure >= g_current_runtime_level ) THEN
2647: FND_LOG.STRING(g_level_procedure,
2648: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.BEGIN',
2649: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Delete_Row (+)');
2650: END IF;
2651:

Line 2653: FND_LOG.STRING(g_level_procedure,

2649: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Delete_Row (+)');
2650: END IF;
2651:
2652: IF (g_level_procedure >= g_current_runtime_level ) THEN
2653: FND_LOG.STRING(g_level_procedure,
2654: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2655: 'Update zx_lines_summary for DELETE (+)');
2656: END IF;
2657:

Line 2679: FND_LOG.STRING(g_level_procedure,

2675: RAISE NO_DATA_FOUND;
2676: END IF;
2677:
2678: IF (g_level_procedure >= g_current_runtime_level ) THEN
2679: FND_LOG.STRING(g_level_procedure,
2680: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2681: 'Update zx_lines_summary for DELETE (-)');
2682: FND_LOG.STRING(g_level_procedure,
2683: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.END',

Line 2682: FND_LOG.STRING(g_level_procedure,

2678: IF (g_level_procedure >= g_current_runtime_level ) THEN
2679: FND_LOG.STRING(g_level_procedure,
2680: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2681: 'Update zx_lines_summary for DELETE (-)');
2682: FND_LOG.STRING(g_level_procedure,
2683: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.END',
2684: 'ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row (-)');
2685: END IF;
2686:

Line 2698: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2694: p_event_id NUMBER,
2695: p_summary_tax_line_id NUMBER) IS
2696:
2697: BEGIN
2698: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2699:
2700: IF (g_level_procedure >= g_current_runtime_level ) THEN
2701: FND_LOG.STRING(g_level_procedure,
2702: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row.BEGIN',

Line 2701: FND_LOG.STRING(g_level_procedure,

2697: BEGIN
2698: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2699:
2700: IF (g_level_procedure >= g_current_runtime_level ) THEN
2701: FND_LOG.STRING(g_level_procedure,
2702: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row.BEGIN',
2703: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Override_Row (+)');
2704:
2705: END IF;

Line 2708: FND_LOG.STRING(g_level_procedure,

2704:
2705: END IF;
2706:
2707: IF (g_level_procedure >= g_current_runtime_level ) THEN
2708: FND_LOG.STRING(g_level_procedure,
2709: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row',
2710: 'Update zx_lines_det_factors (+)');
2711: END IF;
2712:

Line 2729: FND_LOG.STRING(g_level_procedure,

2725: AND TRX_ID = p_trx_id
2726: AND SUMMARY_TAX_LINE_ID = p_summary_tax_line_id);
2727:
2728: IF (g_level_procedure >= g_current_runtime_level ) THEN
2729: FND_LOG.STRING(g_level_procedure,
2730: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row',
2731: 'Update zx_lines_det_factors (-)');
2732: END IF;
2733:

Line 2735: FND_LOG.STRING(g_level_procedure,

2731: 'Update zx_lines_det_factors (-)');
2732: END IF;
2733:
2734: IF (g_level_procedure >= g_current_runtime_level ) THEN
2735: FND_LOG.STRING(g_level_procedure,
2736: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row.END',
2737: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Override_Row (-)');
2738: END IF;
2739:

Line 2759: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2755: debug_info VARCHAR2(100);
2756:
2757: BEGIN
2758:
2759: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2760:
2761: IF (g_level_procedure >= g_current_runtime_level ) THEN
2762: FND_LOG.STRING(g_level_procedure,
2763: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Check_Unique',

Line 2762: FND_LOG.STRING(g_level_procedure,

2758:
2759: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2760:
2761: IF (g_level_procedure >= g_current_runtime_level ) THEN
2762: FND_LOG.STRING(g_level_procedure,
2763: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Check_Unique',
2764: 'Validation for logical primary key (+)');
2765: END IF;
2766:

Line 2794: FND_LOG.STRING(g_level_procedure,

2790:
2791: END;
2792:
2793: IF (g_level_procedure >= g_current_runtime_level ) THEN
2794: FND_LOG.STRING(g_level_procedure,
2795: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Check_Unique',
2796: 'Validation for logical primary key (-)');
2797: END IF;
2798:

Line 2827: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2823:
2824: BEGIN
2825: x_return_status := FND_API.G_RET_STS_SUCCESS;
2826:
2827: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2828:
2829: IF (g_level_procedure >= g_current_runtime_level ) THEN
2830: FND_LOG.STRING(g_level_procedure,
2831: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc.BEGIN',

Line 2830: FND_LOG.STRING(g_level_procedure,

2826:
2827: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2828:
2829: IF (g_level_procedure >= g_current_runtime_level ) THEN
2830: FND_LOG.STRING(g_level_procedure,
2831: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc.BEGIN',
2832: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: lock_summ_tax_lines_for_doc (+)');
2833: END IF;
2834:

Line 2842: FND_LOG.STRING(g_level_procedure,

2838: p_trx_id);
2839: CLOSE lock_sum_tax_lines_for_doc_csr;
2840:
2841: IF (g_level_procedure >= g_current_runtime_level ) THEN
2842: FND_LOG.STRING(g_level_procedure,
2843: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc.END',
2844: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: lock_summ_tax_lines_for_doc (-)');
2845: END IF;
2846: EXCEPTION

Line 2855: FND_LOG.STRING(g_level_procedure,

2851: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
2852: FND_MSG_PUB.Add;
2853:
2854: IF (g_level_procedure >= g_current_runtime_level ) THEN
2855: FND_LOG.STRING(g_level_procedure,
2856: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc',
2857: 'Exception:' ||x_error_buffer);
2858: END IF;
2859: END lock_summ_tax_lines_for_doc;