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

Line 1: PACKAGE BODY CST_MGD_LIFO_COST_PROCESSOR AS

1: PACKAGE BODY CST_MGD_LIFO_COST_PROCESSOR AS
2: --$Header: CSTGLCPB.pls 120.2 2006/05/26 08:00:52 vmutyala noship $
3: --/*==========================================================================+
4: --| Copyright (c) 2001 Oracle Corporation Belmont, California, USA |
5: --| All rights reserved. |

Line 67: G_CST_MGD_LIFO_COST_PROCESSOR VARCHAR2(30) := 'CST_MGD_LIFO_COST_PROCESSOR';

63: --=================
64: -- CONSTANTS
65: --=================
66:
67: G_CST_MGD_LIFO_COST_PROCESSOR VARCHAR2(30) := 'CST_MGD_LIFO_COST_PROCESSOR';
68:
69: --==================
70: -- GLOBAL VARIABLES
71: --==================

Line 220: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR

216: EXCEPTION
217: WHEN OTHERS THEN
218: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
219: THEN
220: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR
221: , 'find_first_period'
222: );
223: END IF;
224: RAISE;

Line 434: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR

430: EXCEPTION
431: WHEN OTHERS THEN
432: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
433: THEN
434: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR
435: , 'populate_layers'
436: );
437: END IF;
438: RAISE;

Line 702: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR

698: EXCEPTION
699: WHEN OTHERS THEN
700: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR
703: , 'calc_lifo_cost'
704: );
705: END IF;
706: RAISE;

Line 781: CST_MGD_LIFO_COST_PROCESSOR.find_first_period( p_pac_period_id

777: END IF;
778:
779: -- find the first period to calculate from
780:
781: CST_MGD_LIFO_COST_PROCESSOR.find_first_period( p_pac_period_id
782: , l_current_item
783: , p_cost_group_id
784: , p_cost_type_id
785: );

Line 789: CST_MGD_LIFO_COST_PROCESSOR.populate_layers( p_pac_period_id

785: );
786:
787: -- record the delta quantity between periods
788:
789: CST_MGD_LIFO_COST_PROCESSOR.populate_layers( p_pac_period_id
790: , l_current_item
791: , p_cost_group_id
792: , p_cost_type_id
793: , p_user_id

Line 802: CST_MGD_LIFO_COST_PROCESSOR.calc_lifo_cost( p_pac_period_id

798: );
799:
800: -- calculate and record the lifo item cost
801:
802: CST_MGD_LIFO_COST_PROCESSOR.calc_lifo_cost( p_pac_period_id
803: , l_current_item
804: , p_cost_group_id
805: , p_cost_type_id
806: , p_user_id

Line 821: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR

817: EXCEPTION
818: WHEN OTHERS THEN
819: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
820: THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR
822: , 'lifo_cost_processor'
823: );
824: END IF;
825: x_retcode := 2;

Line 844: -- CST_MGD_LIFO_COST_PROCESSOR.populate_temp_table

840: -- COMMENT : Procedure that populates a temporary table with the
841: -- exact data required for the Periodic Incremental LIFO
842: -- Valuation Report (Summary).
843: -- PRE-COND : The procedure is called from a public procedure called
844: -- CST_MGD_LIFO_COST_PROCESSOR.populate_temp_table
845: --=========================================================================
846: PROCEDURE pop_summary_data
847: ( p_legal_entity_id IN NUMBER
848: , p_pac_period_id IN NUMBER

Line 1048: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR

1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1047: THEN
1048: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR
1049: , 'pop_summary_data'
1050: );
1051: END IF;
1052: RAISE;

Line 1068: -- CST_MGD_LIFO_COST_PROCESSOR.populate_temp_table

1064: -- COMMENT : Procedure that populates a temporary table with the
1065: -- exact data required for the Periodic Incremental LIFO
1066: -- Valuation Report (Detail).
1067: -- PRE-COND : The procedure is called from a public procedure called
1068: -- CST_MGD_LIFO_COST_PROCESSOR.populate_temp_table
1069: --=========================================================================
1070: PROCEDURE pop_detail_data
1071: ( p_legal_entity_id IN NUMBER
1072: , p_pac_period_id IN NUMBER

Line 1135: CST_MGD_LIFO_COST_PROCESSOR.find_first_period( p_pac_period_id

1131: l_inventory_tab(0) := 0;
1132:
1133: -- Find the first period to calculate from
1134:
1135: CST_MGD_LIFO_COST_PROCESSOR.find_first_period( p_pac_period_id
1136: , l_current_item
1137: , p_cost_group_id
1138: , p_cost_type_id
1139: );

Line 1431: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR

1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1430: THEN
1431: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR
1432: , 'pop_detail_data'
1433: );
1434: END IF;
1435: RAISE;

Line 1535: CST_MGD_LIFO_COST_PROCESSOR.pop_detail_data(p_legal_entity_id

1531:
1532: -- If this is a detailed report populate the
1533: -- temporary table with period layers.
1534:
1535: CST_MGD_LIFO_COST_PROCESSOR.pop_detail_data(p_legal_entity_id
1536: , p_pac_period_id
1537: , p_cost_group_id
1538: , p_cost_type_id
1539: , l_master_org

Line 1549: CST_MGD_LIFO_COST_PROCESSOR.pop_summary_data(p_legal_entity_id

1545: -- If this is a summary report populate the
1546: -- temporary table with data representing the
1547: -- current period.
1548:
1549: CST_MGD_LIFO_COST_PROCESSOR.pop_summary_data(p_legal_entity_id
1550: , p_pac_period_id
1551: , p_cost_group_id
1552: , p_cost_type_id
1553: , l_master_org

Line 1569: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR

1565: EXCEPTION
1566: WHEN OTHERS THEN
1567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1568: THEN
1569: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR
1570: , 'populate_temp_table'
1571: );
1572: END IF;
1573: x_retcode := 2;

Line 1648: p_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR.get_pac_id('

1644: IF l_count > 1 THEN
1645: p_pac_period_id := 0;
1646: p_err_num := 99;
1647: p_err_code := NULL;
1648: p_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR.get_pac_id('
1649: || to_char(l_stmt_num)
1650: || '): '
1651: ||'TOO MANY PERIODS',1,240);
1652: END IF;

Line 1661: p_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR.get_pac_id('

1657: WHEN NO_DATA_FOUND THEN
1658: ROLLBACK;
1659: p_err_num := 1403;
1660: p_err_code := NULL;
1661: p_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR.get_pac_id('
1662: || to_char(l_stmt_num)
1663: || '): '
1664: ||SQLERRM,1,240);
1665:

Line 1670: p_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR.get_pac_id('

1666: WHEN OTHERS THEN
1667: ROLLBACK;
1668: p_err_num := SQLCODE;
1669: p_err_code := NULL;
1670: p_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR.get_pac_id('
1671: || to_char(l_stmt_num)
1672: || '): '
1673: ||SQLERRM,1,240);
1674:

Line 1775: p_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR'

1771: l_inventory_item_id = RECINTERFACE.inventory_item_id) THEN
1772: IF l_layer_quantity <> RECINTERFACE.begin_layer_quantity THEN
1773: p_err_num := 99;
1774: p_err_code := NULL;
1775: p_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR'
1776: ||'.check_quantity('
1777: || to_char(l_stmt_num)
1778: || '): '
1779: ||'begin layer quantity not correct'

Line 1806: p_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR.check_quantity('

1802: WHEN OTHERS THEN
1803: ROLLBACK;
1804: p_err_num := SQLCODE;
1805: p_err_code := NULL;
1806: p_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR.check_quantity('
1807: || to_char(l_stmt_num)
1808: || '): '
1809: ||SQLERRM,1,240);
1810:

Line 1918: CST_MGD_LIFO_COST_PROCESSOR.find_first_period(RECINTERFACE.pac_period_id

1914: WHERE cost_type = RECINTERFACE.cost_type;
1915:
1916: -- find the first period to calculate from
1917:
1918: CST_MGD_LIFO_COST_PROCESSOR.find_first_period(RECINTERFACE.pac_period_id
1919: ,RECINTERFACE.inventory_item_id
1920: ,RECINTERFACE.cost_group_id
1921: ,l_cost_type_id
1922: );

Line 1926: CST_MGD_LIFO_COST_PROCESSOR.populate_layers(RECINTERFACE.pac_period_id

1922: );
1923:
1924: -- record the delta quantity between periods
1925:
1926: CST_MGD_LIFO_COST_PROCESSOR.populate_layers(RECINTERFACE.pac_period_id
1927: ,RECINTERFACE.inventory_item_id
1928: ,RECINTERFACE.cost_group_id
1929: ,l_cost_type_id
1930: ,l_user_id

Line 1939: CST_MGD_LIFO_COST_PROCESSOR.calc_lifo_cost(RECINTERFACE.pac_period_id

1935: );
1936:
1937: -- call the cost processor to calc lifo
1938:
1939: CST_MGD_LIFO_COST_PROCESSOR.calc_lifo_cost(RECINTERFACE.pac_period_id
1940: ,RECINTERFACE.inventory_item_id
1941: ,RECINTERFACE.cost_group_id
1942: ,l_cost_type_id
1943: ,l_user_id);

Line 1960: x_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR.loading_lifo_cost('

1956: WHEN OTHERS THEN
1957: ROLLBACK;
1958: x_err_num := SQLCODE;
1959: x_err_code := NULL;
1960: x_err_msg := SUBSTR('CST_MGD_LIFO_COST_PROCESSOR.loading_lifo_cost('
1961: || to_char(l_stmt_num)
1962: || '): '
1963: ||SQLERRM,1,240);
1964:

Line 2142: CST_MGD_LIFO_COST_PROCESSOR.Log

2138:
2139:
2140: BEGIN
2141:
2142: CST_MGD_LIFO_COST_PROCESSOR.Log
2143: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2144: ,'Start of Proc:Selective Purge'
2145: );
2146:

Line 2143: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2139:
2140: BEGIN
2141:
2142: CST_MGD_LIFO_COST_PROCESSOR.Log
2143: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2144: ,'Start of Proc:Selective Purge'
2145: );
2146:
2147: -- initialize the message stack

Line 2157: CST_MGD_LIFO_COST_PROCESSOR.Log

2153: ,p_item_id
2154: );
2155: FETCH get_market_value_cur INTO l_market_value;
2156:
2157: CST_MGD_LIFO_COST_PROCESSOR.Log
2158: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2159: ,'Market Value: ' || to_char(l_market_value)
2160: );
2161:

Line 2158: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2154: );
2155: FETCH get_market_value_cur INTO l_market_value;
2156:
2157: CST_MGD_LIFO_COST_PROCESSOR.Log
2158: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2159: ,'Market Value: ' || to_char(l_market_value)
2160: );
2161:
2162: CLOSE get_market_value_cur;

Line 2172: CST_MGD_LIFO_COST_PROCESSOR.Log

2168: );
2169:
2170: FETCH get_begin_quantity_cur INTO l_first_begin_quantity;
2171:
2172: CST_MGD_LIFO_COST_PROCESSOR.Log
2173: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2174: ,'Begin quantity of the first period: ' ||
2175: to_char(l_first_begin_quantity)
2176: );

Line 2173: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2169:
2170: FETCH get_begin_quantity_cur INTO l_first_begin_quantity;
2171:
2172: CST_MGD_LIFO_COST_PROCESSOR.Log
2173: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2174: ,'Begin quantity of the first period: ' ||
2175: to_char(l_first_begin_quantity)
2176: );
2177:

Line 2184: CST_MGD_LIFO_COST_PROCESSOR.Log

2180: OPEN get_period_end_date_cur(p_first_period_id);
2181: FETCH get_period_end_date_cur
2182: INTO l_first_period_end_date;
2183:
2184: CST_MGD_LIFO_COST_PROCESSOR.Log
2185: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2186: ,'First period end date: ' ||
2187: to_char(l_first_period_end_date)
2188:

Line 2185: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2181: FETCH get_period_end_date_cur
2182: INTO l_first_period_end_date;
2183:
2184: CST_MGD_LIFO_COST_PROCESSOR.Log
2185: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2186: ,'First period end date: ' ||
2187: to_char(l_first_period_end_date)
2188:
2189: );

Line 2228: CST_MGD_LIFO_COST_PROCESSOR.Log

2224: < l_first_period_end_date);
2225:
2226:
2227: COMMIT; -- Deleted all the prior item cost layers with commit size
2228: CST_MGD_LIFO_COST_PROCESSOR.Log
2229: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2230: ,'Number of historical item cost layers purged: ' ||
2231: to_char(l_purge_prior_count)
2232: );

Line 2229: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2225:
2226:
2227: COMMIT; -- Deleted all the prior item cost layers with commit size
2228: CST_MGD_LIFO_COST_PROCESSOR.Log
2229: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2230: ,'Number of historical item cost layers purged: ' ||
2231: to_char(l_purge_prior_count)
2232: );
2233:

Line 2249: CST_MGD_LIFO_COST_PROCESSOR.g_current_period_index;

2245:
2246: -- Get the period index of the p_pac_period_id
2247: -- first period index
2248: l_period_index :=
2249: CST_MGD_LIFO_COST_PROCESSOR.g_current_period_index;
2250:
2251: -- get the first period id
2252: l_period_id :=
2253: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);

Line 2253: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);

2249: CST_MGD_LIFO_COST_PROCESSOR.g_current_period_index;
2250:
2251: -- get the first period id
2252: l_period_id :=
2253: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2254:
2255: WHILE (l_period_index <>
2256: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.LAST) LOOP
2257:

Line 2256: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.LAST) LOOP

2252: l_period_id :=
2253: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2254:
2255: WHILE (l_period_index <>
2256: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.LAST) LOOP
2257:
2258: IF (l_period_id = p_pac_period_id) THEN
2259:
2260: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2260: CST_MGD_LIFO_COST_PROCESSOR.Log

2256: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.LAST) LOOP
2257:
2258: IF (l_period_id = p_pac_period_id) THEN
2259:
2260: CST_MGD_LIFO_COST_PROCESSOR.Log
2261: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2262: ,'Current Period Index: ' ||
2263: to_char(l_period_index) || ' ' ||
2264: 'Period Id:' || to_char(l_period_id)

Line 2261: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2257:
2258: IF (l_period_id = p_pac_period_id) THEN
2259:
2260: CST_MGD_LIFO_COST_PROCESSOR.Log
2261: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2262: ,'Current Period Index: ' ||
2263: to_char(l_period_index) || ' ' ||
2264: 'Period Id:' || to_char(l_period_id)
2265: );

Line 2270: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.NEXT(l_period_index);

2266: EXIT;
2267: END IF;
2268: -- get the next period index
2269: l_period_index :=
2270: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.NEXT(l_period_index);
2271:
2272: l_period_id :=
2273: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2274:

Line 2273: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);

2269: l_period_index :=
2270: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.NEXT(l_period_index);
2271:
2272: l_period_id :=
2273: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2274:
2275: END LOOP;
2276:
2277: WHILE (l_period_id <> p_first_period_id) LOOP

Line 2282: CST_MGD_LIFO_COST_PROCESSOR.Log

2278: OPEN get_layer_quantity_cur(l_period_id
2279: ,p_item_id
2280: ,p_cost_group_id);
2281:
2282: CST_MGD_LIFO_COST_PROCESSOR.Log
2283: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2284: ,'Period Id: ' ||
2285: to_char(l_period_id)
2286: );

Line 2283: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2279: ,p_item_id
2280: ,p_cost_group_id);
2281:
2282: CST_MGD_LIFO_COST_PROCESSOR.Log
2283: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2284: ,'Period Id: ' ||
2285: to_char(l_period_id)
2286: );
2287:

Line 2291: CST_MGD_LIFO_COST_PROCESSOR.Log

2287:
2288: FETCH get_layer_quantity_cur
2289: INTO l_layer_quantity;
2290:
2291: CST_MGD_LIFO_COST_PROCESSOR.Log
2292: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2293: ,'Delta of the item cost layer: ' ||
2294: to_char(l_layer_quantity)
2295: );

Line 2292: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2288: FETCH get_layer_quantity_cur
2289: INTO l_layer_quantity;
2290:
2291: CST_MGD_LIFO_COST_PROCESSOR.Log
2292: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2293: ,'Delta of the item cost layer: ' ||
2294: to_char(l_layer_quantity)
2295: );
2296:

Line 2315: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.PRIOR(l_period_index);

2311:
2312:
2313: -- get the previous period layer
2314: l_period_index :=
2315: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.PRIOR(l_period_index);
2316:
2317: l_period_id :=
2318: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2319:

Line 2318: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);

2314: l_period_index :=
2315: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.PRIOR(l_period_index);
2316:
2317: l_period_id :=
2318: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2319:
2320: -- add delta to the end quantity of the previous period item costs
2321: UPDATE CST_PAC_ITEM_COSTS
2322: SET total_layer_quantity = total_layer_quantity + l_layer_quantity

Line 2340: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.PRIOR(l_period_index);

2336: ELSE
2337:
2338: -- get the previous period layer
2339: l_period_index :=
2340: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.PRIOR(l_period_index);
2341:
2342: l_period_id :=
2343: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2344:

Line 2343: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);

2339: l_period_index :=
2340: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.PRIOR(l_period_index);
2341:
2342: l_period_id :=
2343: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2344:
2345: END IF;
2346:
2347:

Line 2399: CST_MGD_LIFO_COST_PROCESSOR.Log

2395: COMMIT; -- deleted all the item cost layers
2396: -- update total purge count
2397: l_total_purge_count := l_total_purge_count + l_rec_purge_count;
2398:
2399: CST_MGD_LIFO_COST_PROCESSOR.Log
2400: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_EVENT
2401: ,'Inventory Item Id: ' || to_char(p_item_id)
2402: || ' Total item cost layers purged: ' ||
2403: to_char(l_total_purge_count)

Line 2400: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_EVENT

2396: -- update total purge count
2397: l_total_purge_count := l_total_purge_count + l_rec_purge_count;
2398:
2399: CST_MGD_LIFO_COST_PROCESSOR.Log
2400: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_EVENT
2401: ,'Inventory Item Id: ' || to_char(p_item_id)
2402: || ' Total item cost layers purged: ' ||
2403: to_char(l_total_purge_count)
2404: );

Line 2407: CST_MGD_LIFO_COST_PROCESSOR.Log

2403: to_char(l_total_purge_count)
2404: );
2405:
2406:
2407: CST_MGD_LIFO_COST_PROCESSOR.Log
2408: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2409: ,'End of Proc:Selective Purge'
2410: );
2411:

Line 2408: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2404: );
2405:
2406:
2407: CST_MGD_LIFO_COST_PROCESSOR.Log
2408: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2409: ,'End of Proc:Selective Purge'
2410: );
2411:
2412: EXCEPTION

Line 2417: CST_MGD_LIFO_COST_PROCESSOR.Log

2413:
2414: WHEN OTHERS THEN
2415: l_errorcode := SQLCODE;
2416: l_errortext := SUBSTR(SQLERRM,1,200);
2417: CST_MGD_LIFO_COST_PROCESSOR.Log
2418: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_ERROR
2419: ,to_char(l_errorcode) || l_errortext
2420: );
2421:

Line 2418: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_ERROR

2414: WHEN OTHERS THEN
2415: l_errorcode := SQLCODE;
2416: l_errortext := SUBSTR(SQLERRM,1,200);
2417: CST_MGD_LIFO_COST_PROCESSOR.Log
2418: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_ERROR
2419: ,to_char(l_errorcode) || l_errortext
2420: );
2421:
2422: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2424: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR

2420: );
2421:
2422: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2423: THEN
2424: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR
2425: ,'selective_purge'
2426: );
2427: END IF;
2428:

Line 2543: l_period_tab CST_MGD_LIFO_COST_PROCESSOR.period_tbl_type;

2539: l_item_number VARCHAR2(240);
2540: l_inventory_item_id NUMBER;
2541:
2542: -- store the list of item cost periods
2543: l_period_tab CST_MGD_LIFO_COST_PROCESSOR.period_tbl_type;
2544: l_first_period_index BINARY_INTEGER;
2545: l_period_index BINARY_INTEGER;
2546: l_next_period_index BINARY_INTEGER;
2547: l_period_id NUMBER;

Line 2554: CST_MGD_LIFO_COST_PROCESSOR.Log_Initialize;

2550:
2551: BEGIN
2552:
2553: -- initialize log
2554: CST_MGD_LIFO_COST_PROCESSOR.Log_Initialize;
2555:
2556: -- initialize the message stack
2557: FND_MSG_PUB.Initialize;
2558:

Line 2559: CST_MGD_LIFO_COST_PROCESSOR.Log

2555:
2556: -- initialize the message stack
2557: FND_MSG_PUB.Initialize;
2558:
2559: CST_MGD_LIFO_COST_PROCESSOR.Log
2560: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2561: ,'Start of Proc:Lifo purge'
2562: );
2563:

Line 2560: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2556: -- initialize the message stack
2557: FND_MSG_PUB.Initialize;
2558:
2559: CST_MGD_LIFO_COST_PROCESSOR.Log
2560: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2561: ,'Start of Proc:Lifo purge'
2562: );
2563:
2564: -- Print the Parameter values

Line 2565: CST_MGD_LIFO_COST_PROCESSOR.Log

2561: ,'Start of Proc:Lifo purge'
2562: );
2563:
2564: -- Print the Parameter values
2565: CST_MGD_LIFO_COST_PROCESSOR.Log
2566: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2567: ,'----- PARAMETERS -----'
2568: );
2569:

Line 2566: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2562: );
2563:
2564: -- Print the Parameter values
2565: CST_MGD_LIFO_COST_PROCESSOR.Log
2566: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2567: ,'----- PARAMETERS -----'
2568: );
2569:
2570: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2570: CST_MGD_LIFO_COST_PROCESSOR.Log

2566: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2567: ,'----- PARAMETERS -----'
2568: );
2569:
2570: CST_MGD_LIFO_COST_PROCESSOR.Log
2571: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2572: ,'Legal entity Id : ' || to_char(p_legal_entity_id)
2573: );
2574:

Line 2571: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2567: ,'----- PARAMETERS -----'
2568: );
2569:
2570: CST_MGD_LIFO_COST_PROCESSOR.Log
2571: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2572: ,'Legal entity Id : ' || to_char(p_legal_entity_id)
2573: );
2574:
2575: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2575: CST_MGD_LIFO_COST_PROCESSOR.Log

2571: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2572: ,'Legal entity Id : ' || to_char(p_legal_entity_id)
2573: );
2574:
2575: CST_MGD_LIFO_COST_PROCESSOR.Log
2576: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2577: ,'Cost group Id : ' || to_char(p_cost_group_id)
2578: );
2579:

Line 2576: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2572: ,'Legal entity Id : ' || to_char(p_legal_entity_id)
2573: );
2574:
2575: CST_MGD_LIFO_COST_PROCESSOR.Log
2576: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2577: ,'Cost group Id : ' || to_char(p_cost_group_id)
2578: );
2579:
2580: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2580: CST_MGD_LIFO_COST_PROCESSOR.Log

2576: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2577: ,'Cost group Id : ' || to_char(p_cost_group_id)
2578: );
2579:
2580: CST_MGD_LIFO_COST_PROCESSOR.Log
2581: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2582: ,'Cost type Id : ' || to_char(p_cost_type_id)
2583: );
2584:

Line 2581: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2577: ,'Cost group Id : ' || to_char(p_cost_group_id)
2578: );
2579:
2580: CST_MGD_LIFO_COST_PROCESSOR.Log
2581: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2582: ,'Cost type Id : ' || to_char(p_cost_type_id)
2583: );
2584:
2585: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2585: CST_MGD_LIFO_COST_PROCESSOR.Log

2581: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2582: ,'Cost type Id : ' || to_char(p_cost_type_id)
2583: );
2584:
2585: CST_MGD_LIFO_COST_PROCESSOR.Log
2586: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2587: ,'Pac Period Id : ' || to_char(p_pac_period_id)
2588: );
2589:

Line 2586: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2582: ,'Cost type Id : ' || to_char(p_cost_type_id)
2583: );
2584:
2585: CST_MGD_LIFO_COST_PROCESSOR.Log
2586: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2587: ,'Pac Period Id : ' || to_char(p_pac_period_id)
2588: );
2589:
2590: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2590: CST_MGD_LIFO_COST_PROCESSOR.Log

2586: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2587: ,'Pac Period Id : ' || to_char(p_pac_period_id)
2588: );
2589:
2590: CST_MGD_LIFO_COST_PROCESSOR.Log
2591: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2592: ,'Category Set name : ' || p_category_set_name
2593: );
2594:

Line 2591: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2587: ,'Pac Period Id : ' || to_char(p_pac_period_id)
2588: );
2589:
2590: CST_MGD_LIFO_COST_PROCESSOR.Log
2591: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2592: ,'Category Set name : ' || p_category_set_name
2593: );
2594:
2595: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2595: CST_MGD_LIFO_COST_PROCESSOR.Log

2591: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2592: ,'Category Set name : ' || p_category_set_name
2593: );
2594:
2595: CST_MGD_LIFO_COST_PROCESSOR.Log
2596: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2597: ,'Category Structure : ' || to_char(p_category_struct)
2598: );
2599:

Line 2596: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2592: ,'Category Set name : ' || p_category_set_name
2593: );
2594:
2595: CST_MGD_LIFO_COST_PROCESSOR.Log
2596: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2597: ,'Category Structure : ' || to_char(p_category_struct)
2598: );
2599:
2600: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2600: CST_MGD_LIFO_COST_PROCESSOR.Log

2596: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2597: ,'Category Structure : ' || to_char(p_category_struct)
2598: );
2599:
2600: CST_MGD_LIFO_COST_PROCESSOR.Log
2601: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2602: ,'Category From : ' || p_category_from
2603: );
2604:

Line 2601: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2597: ,'Category Structure : ' || to_char(p_category_struct)
2598: );
2599:
2600: CST_MGD_LIFO_COST_PROCESSOR.Log
2601: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2602: ,'Category From : ' || p_category_from
2603: );
2604:
2605: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2605: CST_MGD_LIFO_COST_PROCESSOR.Log

2601: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2602: ,'Category From : ' || p_category_from
2603: );
2604:
2605: CST_MGD_LIFO_COST_PROCESSOR.Log
2606: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2607: ,'Category To : ' || p_category_to
2608: );
2609:

Line 2606: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2602: ,'Category From : ' || p_category_from
2603: );
2604:
2605: CST_MGD_LIFO_COST_PROCESSOR.Log
2606: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2607: ,'Category To : ' || p_category_to
2608: );
2609:
2610: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2610: CST_MGD_LIFO_COST_PROCESSOR.Log

2606: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2607: ,'Category To : ' || p_category_to
2608: );
2609:
2610: CST_MGD_LIFO_COST_PROCESSOR.Log
2611: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2612: ,'Item From : ' || p_item_from
2613: );
2614:

Line 2611: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2607: ,'Category To : ' || p_category_to
2608: );
2609:
2610: CST_MGD_LIFO_COST_PROCESSOR.Log
2611: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2612: ,'Item From : ' || p_item_from
2613: );
2614:
2615: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2615: CST_MGD_LIFO_COST_PROCESSOR.Log

2611: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2612: ,'Item From : ' || p_item_from
2613: );
2614:
2615: CST_MGD_LIFO_COST_PROCESSOR.Log
2616: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2617: ,'Item To : ' || p_item_to
2618: );
2619:

Line 2616: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2612: ,'Item From : ' || p_item_from
2613: );
2614:
2615: CST_MGD_LIFO_COST_PROCESSOR.Log
2616: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2617: ,'Item To : ' || p_item_to
2618: );
2619:
2620:

Line 2629: CST_MGD_LIFO_COST_PROCESSOR.Log

2625: INTO l_master_org_id,
2626: l_master_org_name;
2627:
2628:
2629: CST_MGD_LIFO_COST_PROCESSOR.Log
2630: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2631: ,'Master Organization Id: ' || to_char(l_master_org_id)
2632: || ' ' || l_master_org_name
2633: );

Line 2630: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2626: l_master_org_name;
2627:
2628:
2629: CST_MGD_LIFO_COST_PROCESSOR.Log
2630: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2631: ,'Master Organization Id: ' || to_char(l_master_org_id)
2632: || ' ' || l_master_org_name
2633: );
2634:

Line 2656: CST_MGD_LIFO_COST_PROCESSOR.Log

2652: -- Item Information
2653: l_item_number := item_number_list.item_number;
2654: l_inventory_item_id := item_number_list.inventory_item_id;
2655:
2656: CST_MGD_LIFO_COST_PROCESSOR.Log
2657: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2658: ,'Item Number: ' || l_item_number
2659: || ' ' || 'Item Id: ' || to_char(l_inventory_item_id)
2660: );

Line 2657: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2653: l_item_number := item_number_list.item_number;
2654: l_inventory_item_id := item_number_list.inventory_item_id;
2655:
2656: CST_MGD_LIFO_COST_PROCESSOR.Log
2657: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2658: ,'Item Number: ' || l_item_number
2659: || ' ' || 'Item Id: ' || to_char(l_inventory_item_id)
2660: );
2661:

Line 2664: CST_MGD_LIFO_COST_PROCESSOR.find_first_period(p_pac_period_id

2660: );
2661:
2662:
2663: -- Get the first period per item per cost group per cost type
2664: CST_MGD_LIFO_COST_PROCESSOR.find_first_period(p_pac_period_id
2665: ,l_inventory_item_id
2666: ,p_cost_group_id
2667: ,p_cost_type_id);
2668:

Line 2670: l_first_period_index := CST_MGD_LIFO_COST_PROCESSOR.g_current_period_index;

2666: ,p_cost_group_id
2667: ,p_cost_type_id);
2668:
2669: -- first period index
2670: l_first_period_index := CST_MGD_LIFO_COST_PROCESSOR.g_current_period_index;
2671:
2672: -- first period id
2673: l_first_period_id :=
2674: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_first_period_index);

Line 2674: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_first_period_index);

2670: l_first_period_index := CST_MGD_LIFO_COST_PROCESSOR.g_current_period_index;
2671:
2672: -- first period id
2673: l_first_period_id :=
2674: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_first_period_index);
2675:
2676: -- get the total quantity of the first period
2677: SELECT
2678: total_layer_quantity

Line 2692: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.LAST) LOOP

2688:
2689: l_period_index := l_first_period_index;
2690:
2691: WHILE (l_period_index <=
2692: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.LAST) LOOP
2693:
2694: l_period_id :=
2695: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2696:

Line 2695: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);

2691: WHILE (l_period_index <=
2692: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.LAST) LOOP
2693:
2694: l_period_id :=
2695: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2696:
2697: IF (l_period_id = p_pac_period_id) THEN
2698:
2699: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2699: CST_MGD_LIFO_COST_PROCESSOR.Log

2695: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2696:
2697: IF (l_period_id = p_pac_period_id) THEN
2698:
2699: CST_MGD_LIFO_COST_PROCESSOR.Log
2700: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2701: ,'Current Period Index: ' ||
2702: to_char(l_period_index) || ' ' ||
2703: 'Period Id:' || to_char(l_period_id)

Line 2700: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2696:
2697: IF (l_period_id = p_pac_period_id) THEN
2698:
2699: CST_MGD_LIFO_COST_PROCESSOR.Log
2700: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2701: ,'Current Period Index: ' ||
2702: to_char(l_period_index) || ' ' ||
2703: 'Period Id:' || to_char(l_period_id)
2704: );

Line 2709: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.NEXT(l_period_index);

2705: EXIT;
2706: END IF;
2707:
2708: l_period_index :=
2709: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.NEXT(l_period_index);
2710:
2711: END LOOP;
2712:
2713: -- get the proper first period when total qty is <= 0

Line 2718: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.NEXT(l_first_period_index);

2714: IF (l_total_quantity <= 0
2715: AND l_first_period_index <> g_period_tab.LAST) THEN
2716:
2717: l_next_period_index :=
2718: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.NEXT(l_first_period_index);
2719: l_next_period_id :=
2720: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_next_period_index);
2721:
2722: -- check the incremented index lies within the current period index

Line 2720: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_next_period_index);

2716:
2717: l_next_period_index :=
2718: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab.NEXT(l_first_period_index);
2719: l_next_period_id :=
2720: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_next_period_index);
2721:
2722: -- check the incremented index lies within the current period index
2723: IF l_next_period_index <= l_period_index THEN
2724: l_first_period_index := l_next_period_index;

Line 2730: CST_MGD_LIFO_COST_PROCESSOR.Log

2726: END IF;
2727:
2728: END IF;
2729:
2730: CST_MGD_LIFO_COST_PROCESSOR.Log
2731: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_EVENT
2732: ,'Proc:find first period completed'
2733: );
2734:

Line 2731: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_EVENT

2727:
2728: END IF;
2729:
2730: CST_MGD_LIFO_COST_PROCESSOR.Log
2731: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_EVENT
2732: ,'Proc:find first period completed'
2733: );
2734:
2735: CST_MGD_LIFO_COST_PROCESSOR.Log

Line 2735: CST_MGD_LIFO_COST_PROCESSOR.Log

2731: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_EVENT
2732: ,'Proc:find first period completed'
2733: );
2734:
2735: CST_MGD_LIFO_COST_PROCESSOR.Log
2736: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2737: ,'First Period Id: ' || to_char(l_first_period_id)
2738: );
2739:

Line 2736: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT

2732: ,'Proc:find first period completed'
2733: );
2734:
2735: CST_MGD_LIFO_COST_PROCESSOR.Log
2736: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_STATEMENT
2737: ,'First Period Id: ' || to_char(l_first_period_id)
2738: );
2739:
2740: -- selective purge of the item cost historical LIFO layers

Line 2741: CST_MGD_LIFO_COST_PROCESSOR.selective_purge(p_legal_entity_id

2737: ,'First Period Id: ' || to_char(l_first_period_id)
2738: );
2739:
2740: -- selective purge of the item cost historical LIFO layers
2741: CST_MGD_LIFO_COST_PROCESSOR.selective_purge(p_legal_entity_id
2742: ,p_pac_period_id
2743: ,l_first_period_id
2744: ,p_cost_group_id
2745: ,p_cost_type_id

Line 2751: CST_MGD_LIFO_COST_PROCESSOR.Log

2747:
2748:
2749: END LOOP; -- for the list of items
2750:
2751: CST_MGD_LIFO_COST_PROCESSOR.Log
2752: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2753: ,'End of Proc:Lifo purge'
2754: );
2755:

Line 2752: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2748:
2749: END LOOP; -- for the list of items
2750:
2751: CST_MGD_LIFO_COST_PROCESSOR.Log
2752: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2753: ,'End of Proc:Lifo purge'
2754: );
2755:
2756:

Line 2757: CST_MGD_LIFO_COST_PROCESSOR.Log

2753: ,'End of Proc:Lifo purge'
2754: );
2755:
2756:
2757: CST_MGD_LIFO_COST_PROCESSOR.Log
2758: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2759: ,'Selective LIFO Purge Successful'
2760: );
2761:

Line 2758: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2754: );
2755:
2756:
2757: CST_MGD_LIFO_COST_PROCESSOR.Log
2758: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2759: ,'Selective LIFO Purge Successful'
2760: );
2761:
2762: x_errbuff := NULL;

Line 2770: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR

2766:
2767: WHEN OTHERS THEN
2768: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2769: THEN
2770: FND_MSG_PUB.Add_Exc_Msg( G_CST_MGD_LIFO_COST_PROCESSOR
2771: ,'lifo_purge'
2772: );
2773: END IF;
2774:

Line 2775: CST_MGD_LIFO_COST_PROCESSOR.Log

2771: ,'lifo_purge'
2772: );
2773: END IF;
2774:
2775: CST_MGD_LIFO_COST_PROCESSOR.Log
2776: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2777: ,'Selective LIFO Purge Failed'
2778: );
2779:

Line 2776: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE

2772: );
2773: END IF;
2774:
2775: CST_MGD_LIFO_COST_PROCESSOR.Log
2776: (CST_MGD_LIFO_COST_PROCESSOR.G_LOG_PROCEDURE
2777: ,'Selective LIFO Purge Failed'
2778: );
2779:
2780: x_retcode := RETCODE_ERROR;

Line 2785: END CST_MGD_LIFO_COST_PROCESSOR;

2781: x_errbuff := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
2782:
2783: END Lifo_purge;
2784:
2785: END CST_MGD_LIFO_COST_PROCESSOR;