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.53.12010000.13 2009/02/03 13:21:21 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: zxriovrsumlnpkgb.pls 120.53.12010000.13 2009/02/03 13:21:21 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 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 403: FND_LOG.STRING(g_level_procedure,

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

Line 407: FND_LOG.STRING(g_level_procedure,

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

Line 669: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 672: FND_LOG.STRING(g_level_procedure,

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

Line 1021: FND_LOG.STRING(g_level_procedure,

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

Line 1626: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1622: l_orig_tax_amt_included_flag VARCHAR2(1);
1623:
1624: BEGIN
1625:
1626: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1627:
1628: IF (g_level_procedure >= g_current_runtime_level ) THEN
1629: FND_LOG.STRING(g_level_procedure,
1630: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',

Line 1629: FND_LOG.STRING(g_level_procedure,

1625:
1626: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1627:
1628: IF (g_level_procedure >= g_current_runtime_level ) THEN
1629: FND_LOG.STRING(g_level_procedure,
1630: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1631: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (+)'||p_self_assessed_flag);
1632: END IF;
1633:

Line 1635: FND_LOG.STRING(g_level_statement,

1631: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (+)'||p_self_assessed_flag);
1632: END IF;
1633:
1634: IF (g_level_statement >= g_current_runtime_level) THEN
1635: FND_LOG.STRING(g_level_statement,
1636: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1637: 'Self assessed flag '||p_self_assessed_flag);
1638: END IF;
1639:

Line 1662: FND_LOG.STRING(g_level_statement,

1658: AND NVL(cancel_flag, 'N') <> 'Y';
1659: EXCEPTION
1660: WHEN NO_DATA_FOUND THEN
1661: IF (g_level_statement >= g_current_runtime_level) THEN
1662: FND_LOG.STRING(g_level_statement,
1663: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1664: 'No Lines to Update ');
1665: FND_LOG.STRING(g_level_statement,
1666: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',

Line 1665: FND_LOG.STRING(g_level_statement,

1661: IF (g_level_statement >= g_current_runtime_level) THEN
1662: FND_LOG.STRING(g_level_statement,
1663: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1664: 'No Lines to Update ');
1665: FND_LOG.STRING(g_level_statement,
1666: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',
1667: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');
1668: END IF;
1669: RETURN;

Line 1737: FND_LOG.STRING(g_level_procedure,

1733:
1734: END;
1735:
1736: IF (g_level_procedure >= g_current_runtime_level ) THEN
1737: FND_LOG.STRING(g_level_procedure,
1738: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1739: 'Update zx_lines_summary (+)');
1740: END IF;
1741:

Line 1750: FND_LOG.STRING(g_level_statement,

1746: p_summary_tax_line_id)
1747: LOOP
1748:
1749: IF (g_level_statement >= g_current_runtime_level) THEN
1750: FND_LOG.STRING(g_level_statement,
1751: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1752: 'tax only line flag ='||rec.tax_only_line_flag);
1753: FND_LOG.STRING(g_level_statement,
1754: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',

Line 1753: FND_LOG.STRING(g_level_statement,

1749: IF (g_level_statement >= g_current_runtime_level) THEN
1750: FND_LOG.STRING(g_level_statement,
1751: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1752: 'tax only line flag ='||rec.tax_only_line_flag);
1753: FND_LOG.STRING(g_level_statement,
1754: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1755: 'tax only line flag ='||rec.associated_child_frozen_flag);
1756: END IF;
1757:

Line 1840: FND_LOG.STRING(g_level_statement,

1836: unrounded_tax_amt = 0
1837: WHERE tax_line_id = rec.tax_line_id;
1838:
1839: IF (g_level_statement >= g_current_runtime_level) THEN
1840: FND_LOG.STRING(g_level_statement,
1841: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1842: 'Tax line id updated'||to_char(rec.tax_line_id));
1843: END IF;
1844:

Line 1882: FND_LOG.STRING(g_level_statement,

1878: NULL;
1879: END;
1880:
1881: IF (g_level_statement >= g_current_runtime_level) THEN
1882: FND_LOG.STRING(g_level_statement,
1883: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
1884: 'Tax line id updated'||to_char(l_offset_tax_line_id));
1885: END IF;
1886:

Line 1888: FND_LOG.STRING(g_level_procedure,

1884: 'Tax line id updated'||to_char(l_offset_tax_line_id));
1885: END IF;
1886:
1887: IF (g_level_procedure >= g_current_runtime_level ) THEN
1888: FND_LOG.STRING(g_level_procedure,
1889: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
1890: 'tax apportionment line number '||l_tax_apportionment_line_num);
1891: END IF;
1892:

Line 2284: FND_LOG.STRING(g_level_procedure,

2280: WHERE summary_tax_line_id = p_summary_tax_line_id;
2281: END IF;
2282:
2283: IF (g_level_procedure >= g_current_runtime_level ) THEN
2284: FND_LOG.STRING(g_level_procedure,
2285: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2286: 'cancel flag is '||p_cancel_flag);
2287: END IF;
2288:

Line 2290: FND_LOG.STRING(g_level_procedure,

2286: 'cancel flag is '||p_cancel_flag);
2287: END IF;
2288:
2289: IF (g_level_procedure >= g_current_runtime_level ) THEN
2290: FND_LOG.STRING(g_level_procedure,
2291: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2292: 'tot detail tax amt'||to_char(l_total_detail_tax_amt));
2293: END IF;
2294: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2295: FND_LOG.STRING(g_level_procedure,

2291: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2292: 'tot detail tax amt'||to_char(l_total_detail_tax_amt));
2293: END IF;
2294: IF (g_level_procedure >= g_current_runtime_level ) THEN
2295: FND_LOG.STRING(g_level_procedure,
2296: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2297: 'tot detail taxable amt'||to_char(l_total_detail_taxable_amt));
2298: END IF;
2299:

Line 2301: FND_LOG.STRING(g_level_procedure,

2297: 'tot detail taxable amt'||to_char(l_total_detail_taxable_amt));
2298: END IF;
2299:
2300: IF (g_level_procedure >= g_current_runtime_level ) THEN
2301: FND_LOG.STRING(g_level_procedure,
2302: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2303: 'before cancel flag = N');
2304: END IF;
2305:

Line 2309: FND_LOG.STRING(g_level_statement,

2305:
2306: IF nvl(p_cancel_flag,'N') = 'N' THEN
2307: IF nvl(l_num_det_lines,0) = 1 THEN
2308: IF (g_level_statement >= g_current_runtime_level) THEN
2309: FND_LOG.STRING(g_level_statement,
2310: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
2311: 'no of det lines 1');
2312: END IF;
2313: UPDATE ZX_LINES

Line 2324: FND_LOG.STRING(g_level_statement,

2320: AND nvl(cancel_flag,'N') <> 'Y';
2321: ELSE
2322: IF nvl(l_total_detail_tax_amt,0) <> 0 THEN
2323: IF (g_level_statement >= g_current_runtime_level) THEN
2324: FND_LOG.STRING(g_level_statement,
2325: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
2326: 'tot det tax amt <> 0');
2327: END IF;
2328: UPDATE ZX_LINES

Line 2338: FND_LOG.STRING(g_level_statement,

2334: AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2335: AND nvl(cancel_flag,'N') <> 'Y';
2336: ELSIF nvl(l_total_detail_taxable_amt,0) <> 0 THEN
2337: IF (g_level_statement >= g_current_runtime_level) THEN
2338: FND_LOG.STRING(g_level_statement,
2339: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
2340: 'tot det taxable amt <> 0');
2341: END IF;
2342: UPDATE ZX_LINES

Line 2352: FND_LOG.STRING(g_level_statement,

2348: AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2349: AND nvl(cancel_flag,'N') <> 'Y';
2350: ELSE
2351: IF (g_level_statement >= g_current_runtime_level) THEN
2352: FND_LOG.STRING(g_level_statement,
2353: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',
2354: 'exception');
2355: END IF;
2356: IF p_tax_amt <> 0 THEN

Line 2360: FND_LOG.STRING(g_level_statement,

2356: IF p_tax_amt <> 0 THEN
2357: --RAISE Invalid_unrounded_amt;
2358: -- Bug 7227477
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.BEGIN',
2362: 'exception -- Tax amount is Not Zero');
2363: END IF;
2364:

Line 2374: FND_LOG.STRING(g_level_procedure,

2370: END IF;
2371: END IF; -- cancel_flag ='N'
2372:
2373: IF (g_level_procedure >= g_current_runtime_level ) THEN
2374: FND_LOG.STRING(g_level_procedure,
2375: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2376: 'before manually entered flag = N');
2377: END IF;
2378: --Recalculation flag for records in zx_lines

Line 2448: FND_LOG.STRING(g_level_procedure,

2444: AND SUMMARY_TAX_LINE_ID = l_summary_tax_line_id
2445: AND nvl(cancel_flag,'N') <> 'Y';
2446:
2447: IF (g_level_procedure >= g_current_runtime_level ) THEN
2448: FND_LOG.STRING(g_level_procedure,
2449: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',
2450: 'Update zx_lines_summary (-)');
2451: END IF;
2452:

Line 2454: FND_LOG.STRING(g_level_procedure,

2450: 'Update zx_lines_summary (-)');
2451: END IF;
2452:
2453: IF (g_level_procedure >= g_current_runtime_level ) THEN
2454: FND_LOG.STRING(g_level_procedure,
2455: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',
2456: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');
2457: END IF;
2458: END Update_Row;

Line 2586: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2582: p_last_update_date DATE,
2583: p_last_update_login NUMBER) IS
2584:
2585: BEGIN
2586: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2587:
2588: IF (g_level_procedure >= g_current_runtime_level ) THEN
2589: FND_LOG.STRING(g_level_procedure,
2590: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.BEGIN',

Line 2589: FND_LOG.STRING(g_level_procedure,

2585: BEGIN
2586: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2587:
2588: IF (g_level_procedure >= g_current_runtime_level ) THEN
2589: FND_LOG.STRING(g_level_procedure,
2590: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.BEGIN',
2591: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Delete_Row (+)');
2592: END IF;
2593:

Line 2595: FND_LOG.STRING(g_level_procedure,

2591: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Delete_Row (+)');
2592: END IF;
2593:
2594: IF (g_level_procedure >= g_current_runtime_level ) THEN
2595: FND_LOG.STRING(g_level_procedure,
2596: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2597: 'Update zx_lines_summary for DELETE (+)');
2598: END IF;
2599:

Line 2621: FND_LOG.STRING(g_level_procedure,

2617: RAISE NO_DATA_FOUND;
2618: END IF;
2619:
2620: IF (g_level_procedure >= g_current_runtime_level ) THEN
2621: FND_LOG.STRING(g_level_procedure,
2622: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2623: 'Update zx_lines_summary for DELETE (-)');
2624: FND_LOG.STRING(g_level_procedure,
2625: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.END',

Line 2624: FND_LOG.STRING(g_level_procedure,

2620: IF (g_level_procedure >= g_current_runtime_level ) THEN
2621: FND_LOG.STRING(g_level_procedure,
2622: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',
2623: 'Update zx_lines_summary for DELETE (-)');
2624: FND_LOG.STRING(g_level_procedure,
2625: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.END',
2626: 'ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row (-)');
2627: END IF;
2628:

Line 2640: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2636: p_event_id NUMBER,
2637: p_summary_tax_line_id NUMBER) IS
2638:
2639: BEGIN
2640: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2641:
2642: IF (g_level_procedure >= g_current_runtime_level ) THEN
2643: FND_LOG.STRING(g_level_procedure,
2644: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row.BEGIN',

Line 2643: FND_LOG.STRING(g_level_procedure,

2639: BEGIN
2640: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2641:
2642: IF (g_level_procedure >= g_current_runtime_level ) THEN
2643: FND_LOG.STRING(g_level_procedure,
2644: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row.BEGIN',
2645: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Override_Row (+)');
2646:
2647: END IF;

Line 2650: FND_LOG.STRING(g_level_procedure,

2646:
2647: END IF;
2648:
2649: IF (g_level_procedure >= g_current_runtime_level ) THEN
2650: FND_LOG.STRING(g_level_procedure,
2651: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row',
2652: 'Update zx_lines_det_factors (+)');
2653: END IF;
2654:

Line 2671: FND_LOG.STRING(g_level_procedure,

2667: AND TRX_ID = p_trx_id
2668: AND SUMMARY_TAX_LINE_ID = p_summary_tax_line_id);
2669:
2670: IF (g_level_procedure >= g_current_runtime_level ) THEN
2671: FND_LOG.STRING(g_level_procedure,
2672: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row',
2673: 'Update zx_lines_det_factors (-)');
2674: END IF;
2675:

Line 2677: FND_LOG.STRING(g_level_procedure,

2673: 'Update zx_lines_det_factors (-)');
2674: END IF;
2675:
2676: IF (g_level_procedure >= g_current_runtime_level ) THEN
2677: FND_LOG.STRING(g_level_procedure,
2678: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row.END',
2679: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Override_Row (-)');
2680: END IF;
2681:

Line 2701: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 2704: FND_LOG.STRING(g_level_procedure,

2700:
2701: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2702:
2703: IF (g_level_procedure >= g_current_runtime_level ) THEN
2704: FND_LOG.STRING(g_level_procedure,
2705: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Check_Unique',
2706: 'Validation for logical primary key (+)');
2707: END IF;
2708:

Line 2736: FND_LOG.STRING(g_level_procedure,

2732:
2733: END;
2734:
2735: IF (g_level_procedure >= g_current_runtime_level ) THEN
2736: FND_LOG.STRING(g_level_procedure,
2737: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Check_Unique',
2738: 'Validation for logical primary key (-)');
2739: END IF;
2740:

Line 2769: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2765:
2766: BEGIN
2767: x_return_status := FND_API.G_RET_STS_SUCCESS;
2768:
2769: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2770:
2771: IF (g_level_procedure >= g_current_runtime_level ) THEN
2772: FND_LOG.STRING(g_level_procedure,
2773: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc.BEGIN',

Line 2772: FND_LOG.STRING(g_level_procedure,

2768:
2769: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2770:
2771: IF (g_level_procedure >= g_current_runtime_level ) THEN
2772: FND_LOG.STRING(g_level_procedure,
2773: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc.BEGIN',
2774: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: lock_summ_tax_lines_for_doc (+)');
2775: END IF;
2776:

Line 2784: FND_LOG.STRING(g_level_procedure,

2780: p_trx_id);
2781: CLOSE lock_sum_tax_lines_for_doc_csr;
2782:
2783: IF (g_level_procedure >= g_current_runtime_level ) THEN
2784: FND_LOG.STRING(g_level_procedure,
2785: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc.END',
2786: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: lock_summ_tax_lines_for_doc (-)');
2787: END IF;
2788: EXCEPTION

Line 2797: FND_LOG.STRING(g_level_procedure,

2793: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
2794: FND_MSG_PUB.Add;
2795:
2796: IF (g_level_procedure >= g_current_runtime_level ) THEN
2797: FND_LOG.STRING(g_level_procedure,
2798: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc',
2799: 'Exception:' ||x_error_buffer);
2800: END IF;
2801: END lock_summ_tax_lines_for_doc;