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

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 (SUMMARY_TAX_LINE_ID,

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

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

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

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

Line 409: '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:
412: END Insert_Row;
413:

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

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

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:
677: OPEN summary_lines_csr;
678: FETCH summary_lines_csr INTO Recinfo;

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

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

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

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

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

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

Line 1631: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: Update_Row (+)'||p_self_assessed_flag);

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

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

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

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

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

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

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

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

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;
1670: WHEN OTHERS THEN
1671: NULL;

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

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

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

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',
1755: 'tax only line flag ='||rec.associated_child_frozen_flag);

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

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:
1758: IF NVL(rec.tax_only_line_flag, 'N') = 'N' THEN

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

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

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

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

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

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

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

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

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

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

Line 2296: '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:
2300: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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
2379: -- manual entered tax line:

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

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

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

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

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

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;
2459:
2460: PROCEDURE Delete_Row

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:
2682: --commit;
2683: END Override_Row;

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

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

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

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

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

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

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

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:
2777: OPEN lock_sum_tax_lines_for_doc_csr(p_application_id,
2778: p_event_class_code,

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

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

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

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

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

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

Line 2805: END ZX_TRL_SUMMARY_OVERRIDE_PKG;

2801: END lock_summ_tax_lines_for_doc;
2802:
2803:
2804:
2805: END ZX_TRL_SUMMARY_OVERRIDE_PKG;