DBA Data[Home] [Help]

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on CSTPPWAC

Line 1255: -- COMMENT : This procedure is a copy CSTPPWAC.calculate_periodic_cost with

1251: END; -- Balance pac txn
1252:
1253: -- ==========================================================================
1254: -- PROCEDURE : Calc_Pmac_For_Interorg PRIVATE
1255: -- COMMENT : This procedure is a copy CSTPPWAC.calculate_periodic_cost with
1256: -- : a minor modification to perform the process only for the
1257: -- : last txn of a transaction category 8 interorg receipts
1258: -- ==========================================================================
1259: PROCEDURE Calc_Pmac_For_Interorg(p_pac_period_id IN NUMBER

Line 1748: -- : logic equivalent of CSTPPWAC.calculate_periodic_cost for each cost group

1744:
1745: --=====================================================================================
1746: -- PROCEDURE : Calc_Pmac_Update_Cppb PRIVATE
1747: -- COMMENT : This procedure invokes
1748: -- : logic equivalent of CSTPPWAC.calculate_periodic_cost for each cost group
1749: -- : CSTPPWAC.update_cppb for each cost groups
1750: -- : Calculates PAC in CPICD, CPIC
1751: -- : Variance Amount is updated for last transaction of a transaction
1752: -- : category 8 interorg receipts

Line 1749: -- : CSTPPWAC.update_cppb for each cost groups

1745: --=====================================================================================
1746: -- PROCEDURE : Calc_Pmac_Update_Cppb PRIVATE
1747: -- COMMENT : This procedure invokes
1748: -- : logic equivalent of CSTPPWAC.calculate_periodic_cost for each cost group
1749: -- : CSTPPWAC.update_cppb for each cost groups
1750: -- : Calculates PAC in CPICD, CPIC
1751: -- : Variance Amount is updated for last transaction of a transaction
1752: -- : category 8 interorg receipts
1753: -- : Updates CPPB with period balance, variance amount

Line 4049: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id

4045:
4046: -- insert into cppb for 1000 inventory items
4047: l_error_num := 0;
4048: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000) THEN
4049: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4050: ,i_cost_group_id => p_cost_group_id
4051: ,i_txn_category => l_txn_category
4052: ,i_user_id => FND_GLOBAL.user_id
4053: ,i_login_id => FND_GLOBAL.login_id

Line 4275: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id

4271: l_error_num := 0;
4272:
4273:
4274: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
4275: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4276: ,i_cost_group_id => p_cost_group_id
4277: ,i_txn_category => l_txn_category
4278: ,i_user_id => FND_GLOBAL.user_id
4279: ,i_login_id => FND_GLOBAL.login_id

Line 4309: CSTPPWAC.calculate_periodic_cost(i_pac_period_id => p_period_id

4305: -- process; Update Variance Amount in the last transaction of MPACD;
4306: -- Update CPPB - Invoke Update_Item_cppb for a given CG
4307: -- Copy of Calc_Pmac_Update_Cppb for a given cost group
4308: -- ================================================================
4309: CSTPPWAC.calculate_periodic_cost(i_pac_period_id => p_period_id
4310: ,i_cost_group_id => p_cost_group_id
4311: ,i_cost_type_id => p_cost_type_id
4312: ,i_low_level_code => p_low_level_code
4313: ,i_item_id => p_inventory_item_id

Line 4365: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '

4361:
4362: IF l_error_num <> 0 THEN
4363: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4364: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4365: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4366: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4367: ||' error('||l_error_code||') '||l_error_msg);
4368: FND_MSG_PUB.Add;
4369: RAISE FND_API.G_EXC_ERROR;

Line 4372: CSTPPWAC.update_item_cppb (i_pac_period_id => p_period_id,

4368: FND_MSG_PUB.Add;
4369: RAISE FND_API.G_EXC_ERROR;
4370: END IF;
4371:
4372: CSTPPWAC.update_item_cppb (i_pac_period_id => p_period_id,
4373: i_cost_group_id => p_cost_group_id,
4374: i_txn_category => l_txn_category,
4375: i_item_id => p_inventory_item_id,
4376: i_user_id => FND_GLOBAL.user_id,

Line 4522: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id

4518: -- insert into cppb for 1000 inventory items
4519: l_error_num := 0;
4520:
4521: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000) THEN
4522: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4523: ,i_cost_group_id => p_cost_group_id
4524: ,i_txn_category => l_txn_category
4525: ,i_user_id => FND_GLOBAL.user_id
4526: ,i_login_id => FND_GLOBAL.login_id

Line 4740: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id

4736: -- ======================================================
4737: l_error_num := 0;
4738:
4739: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
4740: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4741: ,i_cost_group_id => p_cost_group_id
4742: ,i_txn_category => l_txn_category
4743: ,i_user_id => FND_GLOBAL.user_id
4744: ,i_login_id => FND_GLOBAL.login_id

Line 4766: CSTPPWAC.update_item_cppb(i_pac_period_id => p_period_id

4762: END IF;
4763: END IF; -- item existence check in item table
4764:
4765: IF l_error_num = 0 THEN
4766: CSTPPWAC.update_item_cppb(i_pac_period_id => p_period_id
4767: ,i_cost_group_id => p_cost_group_id
4768: ,i_txn_category => l_txn_category
4769: ,i_item_id => p_inventory_item_id
4770: ,i_user_id => FND_GLOBAL.user_id

Line 4796: , 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '

4792: IF l_error_num <> 0 THEN
4793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4794: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
4795: , G_MODULE_HEAD || l_routine || '.others'
4796: , 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4797: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4798: ||' error('||l_error_code||') '||l_error_msg
4799: );
4800: END IF;

Line 4803: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '

4799: );
4800: END IF;
4801: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4802: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4803: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4804: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4805: ||' error('||l_error_code||') '||l_error_msg);
4806: FND_MSG_PUB.Add;
4807: RAISE FND_API.G_EXC_ERROR;

Line 5939: CSTPPWAC.calculate_periodic_cost(

5935: t_low_level_code := l_optimal_cg_idx.low_level_code;
5936: END IF;
5937:
5938:
5939: CSTPPWAC.calculate_periodic_cost(
5940: i_pac_period_id => p_period_id,
5941: i_cost_group_id => l_optimal_cg_idx.cost_group_id,
5942: i_cost_type_id => p_cost_type_id,
5943: i_low_level_code => t_low_level_code,