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.GMF_LAYERS dependencies on GMF_LAYERS

Line 1: PACKAGE BODY GMF_LAYERS AS

1: PACKAGE BODY GMF_LAYERS AS
2: /* $Header: GMFLAYRB.pls 120.11.12020000.2 2013/02/11 21:16:49 pvkanetk ship $ */
3:
4: g_pkg_name VARCHAR2(30) := 'GMF_LAYERS';
5: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');

Line 4: g_pkg_name VARCHAR2(30) := 'GMF_LAYERS';

1: PACKAGE BODY GMF_LAYERS AS
2: /* $Header: GMFLAYRB.pls 120.11.12020000.2 2013/02/11 21:16:49 pvkanetk ship $ */
3:
4: g_pkg_name VARCHAR2(30) := 'GMF_LAYERS';
5: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
6:
7: /*
8: +==========================================================================+

Line 17: | GMF_LAYERS |

13: | FILE NAME |
14: | GMFLAYR.pls |
15: | |
16: | PACKAGE NAME |
17: | GMF_LAYERS |
18: | |
19: | DESCRIPTION |
20: | |
21: | CONTENTS |

Line 60: p_tran_rec IN GMF_LAYERS.trans_rec_type,

56: */
57: PROCEDURE Create_Incoming_Layers
58: ( p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_tran_rec IN GMF_LAYERS.trans_rec_type,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2,
64: p_Create_vib IN VARCHAR2 DEFAULT 'Y') IS

Line 295: p_tran_rec IN GMF_LAYERS.TRANS_REC_TYPE,

291: */
292: PROCEDURE Create_Outgoing_Layers
293: ( p_api_version IN NUMBER,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295: p_tran_rec IN GMF_LAYERS.TRANS_REC_TYPE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2) IS
299:

Line 1145: GMF_LAYERS.log_message (

1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: err_num := SQLCODE;
1144: err_msg := SUBSTRB(SQLERRM, 1, 100);
1145: GMF_LAYERS.log_message (
1146: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1147: p_procedure_name => 'Delete_old_layers',
1148: p_parameters => err_num,
1149: p_message => 'Error deleting Old layer data for batch_id = '||p_batch_id||' '||err_msg,

Line 1347: GMF_LAYERS.log_message (

1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: err_num := SQLCODE;
1346: err_msg := SUBSTRB(SQLERRM, 1, 100);
1347: GMF_LAYERS.log_message (
1348: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1349: p_procedure_name => 'Delete_period_layers',
1350: p_parameters => err_num,
1351: p_message => 'Error deleting Old layer data for batch_id = '||p_batch_id||' Period id '||p_period_id||

Line 1449: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;

1445: l_ol_count PLS_INTEGER := 0;
1446: l_doc_qty NUMBER;
1447: e_uom_conv_failure EXCEPTION;
1448:
1449: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;
1450: BEGIN
1451: select start_date, end_date INTO l_start_date, l_end_date
1452: from gmf_period_statuses
1453: where period_id = p_period_id;

Line 1455: GMF_LAYERS.log_message (

1451: select start_date, end_date INTO l_start_date, l_end_date
1452: from gmf_period_statuses
1453: where period_id = p_period_id;
1454:
1455: GMF_LAYERS.log_message (
1456: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1457: p_procedure_name => 'None',
1458: p_parameters => 'None',
1459: p_message => 'Started the migration Recreate_outgoing_layers for the batch',

Line 1462: GMF_LAYERS.log_message (

1458: p_parameters => 'None',
1459: p_message => 'Started the migration Recreate_outgoing_layers for the batch',
1460: p_error_type => 'I');
1461:
1462: GMF_LAYERS.log_message (
1463: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1464: p_procedure_name => 'None',
1465: p_parameters => 'None',
1466: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST'),

Line 1469: GMF_LAYERS.log_message (

1465: p_parameters => 'None',
1466: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST'),
1467: p_error_type => 'I');
1468:
1469: GMF_LAYERS.log_message (
1470: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1471: p_procedure_name => 'None',
1472: p_parameters => 'None',
1473: p_message => 'Profile GMF_USE_ITEM_STEP_DEPENDENCIES = '||FND_PROFILE.VALUE ('GMF_USE_ITEM_STEP_DEPENDENCIES'),

Line 1566: GMF_LAYERS.log_message (

1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: -- fnd_file.put_line ('Error in UOM conversion');
1565: -- fnd_file.put_line ('From UOM = '||mt.trans_um||', To UOM = '||t.doc_um);
1566: GMF_LAYERS.log_message (
1567: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1568: p_procedure_name => 'None',
1569: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id)||
1570: ' From UOM = '||trans_rec.primary_uom_code||', To UOM = '||t.doc_um,

Line 1580: gmf_layers.Create_outgoing_Layers

1576: IF t.line_type = -1 THEN
1577: l_trans_rec.doc_qty := -l_trans_rec.doc_qty;
1578: END IF;
1579:
1580: gmf_layers.Create_outgoing_Layers
1581: ( p_api_version => 1.0,
1582: p_init_msg_list => FND_API.G_FALSE,
1583: p_tran_rec => l_trans_rec,
1584: x_return_status => x_return_status,

Line 1591: GMF_LAYERS.log_message (

1587:
1588: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1589: --
1590: -- fnd_file.put_line ('Error creating outgoing layer : '||to_char (mt.trans_id));
1591: GMF_LAYERS.log_message (
1592: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1593: p_procedure_name => 'None',
1594: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
1595: p_message => 'Error creating outgoing layer',

Line 1599: GMF_LAYERS.log_message (

1595: p_message => 'Error creating outgoing layer',
1596: p_error_type => 'E');
1597: FOR i IN 1..fnd_msg_pub.count_msg
1598: LOOP
1599: GMF_LAYERS.log_message (
1600: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1601: p_procedure_name => 'None',
1602: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
1603: p_message => fnd_msg_pub.get_detail (i, NULL),

Line 1618: GMF_LAYERS.log_message (

1614: END;
1615: END LOOP;
1616:
1617:
1618: GMF_LAYERS.log_message (
1619: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1620: p_procedure_name => 'None',
1621: p_parameters => 'Incoming Layers = '||to_char(l_il_count)||
1622: ', Outgoing Layers = '||to_char(l_ol_count)||

Line 1707: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;

1703: l_ol_count PLS_INTEGER := 0;
1704: l_doc_qty NUMBER;
1705: e_uom_conv_failure EXCEPTION;
1706:
1707: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;
1708: BEGIN
1709:
1710: select start_date, end_date INTO l_start_date, l_end_date
1711: from gmf_period_statuses

Line 1714: GMF_LAYERS.log_message (

1710: select start_date, end_date INTO l_start_date, l_end_date
1711: from gmf_period_statuses
1712: where period_id = p_period_id;
1713:
1714: GMF_LAYERS.log_message (
1715: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1716: p_procedure_name => 'None',
1717: p_parameters => 'None',
1718: p_message => 'Started the migration to Recreate_resource_layers for the batch',

Line 1721: GMF_LAYERS.log_message (

1717: p_parameters => 'None',
1718: p_message => 'Started the migration to Recreate_resource_layers for the batch',
1719: p_error_type => 'I');
1720:
1721: GMF_LAYERS.log_message (
1722: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1723: p_procedure_name => 'None',
1724: p_parameters => 'None',
1725: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST'),

Line 1728: GMF_LAYERS.log_message (

1724: p_parameters => 'None',
1725: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST'),
1726: p_error_type => 'I');
1727:
1728: GMF_LAYERS.log_message (
1729: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1730: p_procedure_name => 'None',
1731: p_parameters => 'None',
1732: p_message => 'Profile GMF_USE_ITEM_STEP_DEPENDENCIES = '||FND_PROFILE.VALUE ('GMF_USE_ITEM_STEP_DEPENDENCIES'),

Line 1756: GMF_LAYERS.Create_Resource_Layers(

1752: WHERE
1753: poc_trans_id = rt.poc_trans_id;
1754:
1755: IF l_count = 0 THEN
1756: GMF_LAYERS.Create_Resource_Layers(
1757: 1.0,
1758: FND_API.G_FALSE,
1759: rt,
1760: rt.resource_usage,

Line 1768: GMF_LAYERS.log_message (

1764: x_msg_data);
1765:
1766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1767: -- fnd_file.put_line ('Error creating resource layer : '||to_char (rt.poc_trans_id));
1768: GMF_LAYERS.log_message (
1769: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1770: p_procedure_name => 'None',
1771: p_parameters => 'POC Trans ID = '||to_char(rt.poc_trans_id),
1772: p_message => 'Error creating resource layer',

Line 1775: GMF_LAYERS.log_message (

1771: p_parameters => 'POC Trans ID = '||to_char(rt.poc_trans_id),
1772: p_message => 'Error creating resource layer',
1773: p_error_type => 'E');
1774: FOR i IN 1..fnd_msg_pub.count_msg LOOP
1775: GMF_LAYERS.log_message (
1776: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1777: p_procedure_name => 'None',
1778: p_parameters => 'POC Trans ID = '||to_char(rt.poc_trans_id),
1779: p_message => fnd_msg_pub.get_detail (i, NULL),

Line 1793: GMF_LAYERS.log_message (

1789: NULL;
1790: END;
1791: END LOOP;
1792:
1793: GMF_LAYERS.log_message (
1794: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1795: p_procedure_name => 'None',
1796: p_parameters => 'Incoming Layers = '||to_char(l_il_count)||
1797: ', Outgoing Layers = '||to_char(l_ol_count)||

Line 1894: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;

1890: l_ol_count PLS_INTEGER := 0;
1891: l_doc_qty NUMBER;
1892: e_uom_conv_failure EXCEPTION;
1893:
1894: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;
1895: BEGIN
1896:
1897: select start_date, end_date INTO l_start_date, l_end_date
1898: from gmf_period_statuses

Line 1904: GMF_LAYERS.log_message (

1900:
1901: l_use_vib := FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST');
1902: l_use_step_dep := FND_PROFILE.VALUE ('GMF_USE_ITEM_STEP_DEPENDENCIES');
1903:
1904: GMF_LAYERS.log_message (
1905: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1906: p_procedure_name => 'None',
1907: p_parameters => 'None',
1908: p_message => 'Started the migration to Recreate_incoming_layers for the batch',

Line 1911: GMF_LAYERS.log_message (

1907: p_parameters => 'None',
1908: p_message => 'Started the migration to Recreate_incoming_layers for the batch',
1909: p_error_type => 'I');
1910:
1911: GMF_LAYERS.log_message (
1912: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1913: p_procedure_name => 'None',
1914: p_parameters => 'None',
1915: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||l_use_vib,

Line 1918: GMF_LAYERS.log_message (

1914: p_parameters => 'None',
1915: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||l_use_vib,
1916: p_error_type => 'I');
1917:
1918: GMF_LAYERS.log_message (
1919: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1920: p_procedure_name => 'None',
1921: p_parameters => 'None',
1922: p_message => 'Profile GMF_USE_ITEM_STEP_DEPENDENCIES = '||l_use_step_dep,

Line 2026: GMF_LAYERS.log_message (

2022: EXCEPTION
2023: WHEN OTHERS THEN
2024: -- fnd_file.put_line ('Error in UOM conversion');
2025: -- fnd_file.put_line ('From UOM = '||mt.trans_um||', To UOM = '||t.doc_um);
2026: GMF_LAYERS.log_message (
2027: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2028: p_procedure_name => 'None',
2029: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id)||
2030: ' From UOM = '||trans_rec.primary_uom_code||', To UOM = '||t.doc_um,

Line 2038: gmf_layers.Create_Incoming_Layers

2034: END;
2035:
2036: IF (l_prev_mat_det_id = t.mat_det_id AND NVL(l_use_vib, 'N') = 'N' AND NVL(l_use_vib, 'N') = 'N') THEN
2037:
2038: gmf_layers.Create_Incoming_Layers
2039: ( p_api_version => 1.0,
2040: p_init_msg_list => FND_API.G_FALSE,
2041: p_tran_rec => l_trans_rec,
2042: x_return_status => x_return_status,

Line 2049: gmf_layers.Create_Incoming_Layers

2045: p_Create_vib => 'N'
2046: );
2047: ELSE
2048:
2049: gmf_layers.Create_Incoming_Layers
2050: ( p_api_version => 1.0,
2051: p_init_msg_list => FND_API.G_FALSE,
2052: p_tran_rec => l_trans_rec,
2053: x_return_status => x_return_status,

Line 2063: GMF_LAYERS.log_message (

2059: END IF;
2060:
2061: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2062: -- fnd_file.put_line ('Error creating incoming layer : '||to_char (mt.trans_id));
2063: GMF_LAYERS.log_message (
2064: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2065: p_procedure_name => 'None',
2066: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
2067: p_message => 'Error creating incoming layer',

Line 2070: GMF_LAYERS.log_message (

2066: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
2067: p_message => 'Error creating incoming layer',
2068: p_error_type => 'E');
2069: FOR i IN 1..fnd_msg_pub.count_msg LOOP
2070: GMF_LAYERS.log_message (
2071: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2072: p_procedure_name => 'None',
2073: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
2074: p_message => fnd_msg_pub.get_detail (i, NULL),

Line 2089: GMF_LAYERS.log_message (

2085: END;
2086: l_prev_mat_det_id := t.mat_det_id; -- B 15888374
2087: END LOOP;
2088:
2089: GMF_LAYERS.log_message (
2090: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2091: p_procedure_name => 'None',
2092: p_parameters => 'Incoming Layers = '||to_char(l_il_count)||
2093: ', Outgoing Layers = '||to_char(l_ol_count)||

Line 2160: GMF_LAYERS.log_message (

2156: x_msg_count,
2157: x_msg_data);
2158:
2159: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2160: GMF_LAYERS.log_message (
2161: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2162: p_procedure_name => 'None',
2163: p_parameters => 'Batch ID = '||to_char(cls.batch_id),
2164: p_message => 'Error creating finalization layers',

Line 2168: GMF_LAYERS.log_message (

2164: p_message => 'Error creating finalization layers',
2165: p_error_type => 'E');
2166:
2167: FOR i IN 1..fnd_msg_pub.count_msg LOOP
2168: GMF_LAYERS.log_message (
2169: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2170: p_procedure_name => 'None',
2171: p_parameters => 'Batch ID = '||to_char(cls.batch_id),
2172: p_message => fnd_msg_pub.get_detail (i, NULL),

Line 2181: GMF_LAYERS.log_message (

2177: WHEN OTHERS THEN
2178: NULL;
2179: END;
2180: END LOOP;
2181: GMF_LAYERS.log_message (
2182: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2183: p_procedure_name => 'None',
2184: p_parameters => 'Batch ID = '||to_char(p_batch_id),
2185: p_message => 'Layer Finalization completed',

Line 2251: /* Bug 9417673 - GMF_LAYERS PACKAGE FAILS WITH ORA-1722 */

2247:
2248: rec batch_rec_type;
2249: cur_batches batch_cursor_type;
2250:
2251: /* Bug 9417673 - GMF_LAYERS PACKAGE FAILS WITH ORA-1722 */
2252: CURSOR cur_get_periodid IS
2253: SELECT gps.period_id,
2254: gps.start_date,
2255: gps.end_date

Line 2543: GMF_LAYERS.Delete_old_layers(rec.batch_id);

2539:
2540: IF ((rec.actual_start_date >= l_startdate) AND (rec.actual_start_date <= l_enddate)) THEN
2541:
2542: fnd_file.put_line(fnd_file.log, ' Deleting Old layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no);
2543: GMF_LAYERS.Delete_old_layers(rec.batch_id);
2544:
2545: ELSE
2546:
2547: fnd_file.put_line(fnd_file.log, ' Deleting Period layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no||' Period id '||l_periodid);

Line 2548: GMF_LAYERS.Delete_period_layers(rec.batch_id, l_periodid);

2544:
2545: ELSE
2546:
2547: fnd_file.put_line(fnd_file.log, ' Deleting Period layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no||' Period id '||l_periodid);
2548: GMF_LAYERS.Delete_period_layers(rec.batch_id, l_periodid);
2549:
2550: END IF;
2551:
2552: fnd_file.put_line(fnd_file.log, ' END Deleting Old layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no||' Period id '||l_periodid);

Line 2556: GMF_LAYERS.Recreate_outgoing_layers(rec.batch_id,l_periodid);

2552: fnd_file.put_line(fnd_file.log, ' END Deleting Old layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no||' Period id '||l_periodid);
2553: -- Moved Declaration to top
2554: fnd_file.put_line(fnd_file.log, ' Rebuilding outgoing layers data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2555:
2556: GMF_LAYERS.Recreate_outgoing_layers(rec.batch_id,l_periodid);
2557:
2558: fnd_file.put_line(fnd_file.log, ' Rebuilding Resource data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2559:
2560: GMF_LAYERS.Recreate_resource_layers(rec.batch_id,l_periodid);

Line 2560: GMF_LAYERS.Recreate_resource_layers(rec.batch_id,l_periodid);

2556: GMF_LAYERS.Recreate_outgoing_layers(rec.batch_id,l_periodid);
2557:
2558: fnd_file.put_line(fnd_file.log, ' Rebuilding Resource data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2559:
2560: GMF_LAYERS.Recreate_resource_layers(rec.batch_id,l_periodid);
2561:
2562: fnd_file.put_line(fnd_file.log, ' Rebuilding incoming layers data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2563:
2564: GMF_LAYERS.Recreate_incoming_layers(rec.batch_id,l_periodid);

Line 2564: GMF_LAYERS.Recreate_incoming_layers(rec.batch_id,l_periodid);

2560: GMF_LAYERS.Recreate_resource_layers(rec.batch_id,l_periodid);
2561:
2562: fnd_file.put_line(fnd_file.log, ' Rebuilding incoming layers data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2563:
2564: GMF_LAYERS.Recreate_incoming_layers(rec.batch_id,l_periodid);
2565:
2566: -- Or call if r=batch close date i in period being passed?
2567: IF ((rec.batch_status = 4) AND (rec.batch_close_date >= l_startdate) AND (rec.batch_close_date <= l_enddate)) THEN
2568:

Line 2571: GMF_LAYERS.Finalize_batch (rec.batch_id,l_periodid);

2567: IF ((rec.batch_status = 4) AND (rec.batch_close_date >= l_startdate) AND (rec.batch_close_date <= l_enddate)) THEN
2568:
2569: fnd_file.put_line(fnd_file.log, ' Finalizing layers data for Close Batch_id '|| rec.batch_id);
2570:
2571: GMF_LAYERS.Finalize_batch (rec.batch_id,l_periodid);
2572:
2573: END IF;
2574:
2575: -- Bug 10196137 Perform these queries and log messages only if debug level is 3.

Line 2665: END GMF_LAYERS;

2661: END Relayer;
2662:
2663: -- END Additions for relayering concurrent request.
2664:
2665: END GMF_LAYERS;