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 ZX_TRL_SUMMARY_OVERRIDE_PKG

Line 1: PACKAGE BODY ZX_TRL_SUMMARY_OVERRIDE_PKG AS

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;

Line 147: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.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:
151: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 148: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Insert_Row (+)');

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

Line 153: 'ZX.PLSQL.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:
157: INSERT INTO ZX_LINES_SUMMARY

Line 407: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row',

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,
411: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.END',

Line 411: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Insert_Row.END',

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

Line 412: '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:
415: END Insert_Row;
416:

Line 676: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Lock_Row.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:
680: OPEN summary_lines_csr;

Line 677: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Lock_Row (+)');

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:
680: OPEN summary_lines_csr;
681: FETCH summary_lines_csr INTO Recinfo;

Line 1025: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Lock_Row.END',

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

Line 1026: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Lock_Row (-)');

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

Line 1637: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.BEGIN',

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:
1641: IF (g_level_statement >= g_current_runtime_level) THEN

Line 1638: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (+)');

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:
1641: IF (g_level_statement >= g_current_runtime_level) THEN
1642: FND_LOG.STRING(g_level_statement,

Line 1643: 'ZX.PLSQL.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:
1647: BEGIN

Line 1670: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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',
1674: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');

Line 1673: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',

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

Line 1674: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');

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;
1677: WHEN OTHERS THEN
1678: NULL;

Line 1686: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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:
1690: FND_MESSAGE.Set_Name ('ZX','ZX_TAX_AMT_UPDATE_NOT_ALLOWED');

Line 1761: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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:
1765: FOR rec IN c2(p_application_id,

Line 1774: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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',
1778: 'Associated_child_frozen_flag : '||rec.associated_child_frozen_flag);

Line 1777: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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:
1781: IF rec.freeze_until_overridden_flag = 'Y' AND

Line 1881: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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:
1885: -- we need to perform subsequent actions only if the current line is having offset tax

Line 1932: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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

Line 1938: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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

Line 1944: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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:
1948: l_had_frozen_dists := TRUE;

Line 2342: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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

Line 2348: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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
2352: FND_LOG.STRING(g_level_procedure,

Line 2353: '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:
2357: IF nvl(p_cancel_flag,'N') = 'N' THEN

Line 2361: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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
2365: SET UNROUNDED_TAX_AMT = p_tax_amt

Line 2376: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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
2380: SET UNROUNDED_TAX_AMT = decode(nvl(p_cancel_flag,'N'), 'N', ((unrounded_tax_amt * p_tax_amt)/l_total_detail_tax_amt), 0)

Line 2390: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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
2394: SET UNROUNDED_TAX_AMT = decode(nvl(p_cancel_flag,'N'), 'N', ((unrounded_taxable_amt * p_tax_amt)/l_total_detail_taxable_amt), 0)

Line 2404: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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
2408: --RAISE Invalid_unrounded_amt;

Line 2412: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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:
2416: FND_MESSAGE.Set_Name ('ZX','ZX_TAX_AMT_UPDATE_NOT_ALLOWED');

Line 2500: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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'
2504:

Line 2507: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row',

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

Line 2513: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_Row.END',

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

Line 2514: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (-)');

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;
2517:
2518: PROCEDURE Delete_Row

Line 2648: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.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:
2652: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2649: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Delete_Row (+)');

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

Line 2654: 'ZX.PLSQL.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:
2658: UPDATE ZX_LINES_SUMMARY

Line 2680: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row',

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',
2684: 'ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row (-)');

Line 2683: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row.END',

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:
2687: END Delete_Row;

Line 2684: 'ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_Row (-)');

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:
2687: END Delete_Row;
2688:

Line 2702: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row.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;
2706:

Line 2703: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Override_Row (+)');

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

Line 2709: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row',

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:
2713: UPDATE ZX_LINES_DET_FACTORS

Line 2730: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row',

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

Line 2736: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Override_Row.END',

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:
2740: --commit;

Line 2737: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Override_Row (-)');

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:
2740: --commit;
2741: END Override_Row;

Line 2763: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Check_Unique',

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

Line 2795: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.Check_Unique',

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:
2799: END Check_Unique;

Line 2831: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc.BEGIN',

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:
2835: OPEN lock_sum_tax_lines_for_doc_csr(p_application_id,

Line 2832: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: lock_summ_tax_lines_for_doc (+)');

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:
2835: OPEN lock_sum_tax_lines_for_doc_csr(p_application_id,
2836: p_event_class_code,

Line 2843: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc.END',

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

Line 2844: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: lock_summ_tax_lines_for_doc (-)');

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

Line 2856: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_summ_tax_lines_for_doc',

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

Line 2863: END ZX_TRL_SUMMARY_OVERRIDE_PKG;

2859: END lock_summ_tax_lines_for_doc;
2860:
2861:
2862:
2863: END ZX_TRL_SUMMARY_OVERRIDE_PKG;