DBA Data[Home] [Help]

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on CSTPPWAC

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

1155: END; -- Balance pac txn
1156:
1157: -- ==========================================================================
1158: -- PROCEDURE : Calc_Pmac_For_Interorg PRIVATE
1159: -- COMMENT : This procedure is a copy CSTPPWAC.calculate_periodic_cost with
1160: -- : a minor modification to perform the process only for the
1161: -- : last txn of a transaction category 8 interorg receipts
1162: -- ==========================================================================
1163: PROCEDURE Calc_Pmac_For_Interorg(p_pac_period_id IN NUMBER

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

1638:
1639: --=====================================================================================
1640: -- PROCEDURE : Calc_Pmac_Update_Cppb PRIVATE
1641: -- COMMENT : This procedure invokes
1642: -- : logic equivalent of CSTPPWAC.calculate_periodic_cost for each cost group
1643: -- : CSTPPWAC.update_cppb for each cost groups
1644: -- : Calculates PAC in CPICD, CPIC
1645: -- : Variance Amount is updated for last transaction of a transaction
1646: -- : category 8 interorg receipts

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

1639: --=====================================================================================
1640: -- PROCEDURE : Calc_Pmac_Update_Cppb PRIVATE
1641: -- COMMENT : This procedure invokes
1642: -- : logic equivalent of CSTPPWAC.calculate_periodic_cost for each cost group
1643: -- : CSTPPWAC.update_cppb for each cost groups
1644: -- : Calculates PAC in CPICD, CPIC
1645: -- : Variance Amount is updated for last transaction of a transaction
1646: -- : category 8 interorg receipts
1647: -- : Updates CPPB with period balance, variance amount

Line 3816: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id

3812:
3813: -- insert into cppb for 1000 inventory items
3814: l_error_num := 0;
3815: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000) THEN
3816: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
3817: ,i_cost_group_id => p_cost_group_id
3818: ,i_txn_category => l_txn_category
3819: ,i_user_id => FND_GLOBAL.user_id
3820: ,i_login_id => FND_GLOBAL.login_id

Line 4042: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id

4038: l_error_num := 0;
4039:
4040:
4041: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
4042: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4043: ,i_cost_group_id => p_cost_group_id
4044: ,i_txn_category => l_txn_category
4045: ,i_user_id => FND_GLOBAL.user_id
4046: ,i_login_id => FND_GLOBAL.login_id

Line 4076: CSTPPWAC.calculate_periodic_cost(i_pac_period_id => p_period_id

4072: -- process; Update Variance Amount in the last transaction of MPACD;
4073: -- Update CPPB - Invoke Update_Item_cppb for a given CG
4074: -- Copy of Calc_Pmac_Update_Cppb for a given cost group
4075: -- ================================================================
4076: CSTPPWAC.calculate_periodic_cost(i_pac_period_id => p_period_id
4077: ,i_cost_group_id => p_cost_group_id
4078: ,i_cost_type_id => p_cost_type_id
4079: ,i_low_level_code => p_low_level_code
4080: ,i_item_id => p_inventory_item_id

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

4128:
4129: IF l_error_num <> 0 THEN
4130: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4131: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4132: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4133: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4134: ||' error('||l_error_code||') '||l_error_msg);
4135: FND_MSG_PUB.Add;
4136: RAISE FND_API.G_EXC_ERROR;

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

4135: FND_MSG_PUB.Add;
4136: RAISE FND_API.G_EXC_ERROR;
4137: END IF;
4138:
4139: CSTPPWAC.update_item_cppb (i_pac_period_id => p_period_id,
4140: i_cost_group_id => p_cost_group_id,
4141: i_txn_category => l_txn_category,
4142: i_item_id => p_inventory_item_id,
4143: i_user_id => FND_GLOBAL.user_id,

Line 4289: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id

4285: -- insert into cppb for 1000 inventory items
4286: l_error_num := 0;
4287:
4288: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000) THEN
4289: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4290: ,i_cost_group_id => p_cost_group_id
4291: ,i_txn_category => l_txn_category
4292: ,i_user_id => FND_GLOBAL.user_id
4293: ,i_login_id => FND_GLOBAL.login_id

Line 4507: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id

4503: -- ======================================================
4504: l_error_num := 0;
4505:
4506: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
4507: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4508: ,i_cost_group_id => p_cost_group_id
4509: ,i_txn_category => l_txn_category
4510: ,i_user_id => FND_GLOBAL.user_id
4511: ,i_login_id => FND_GLOBAL.login_id

Line 4533: CSTPPWAC.update_item_cppb(i_pac_period_id => p_period_id

4529: END IF;
4530: END IF; -- item existence check in item table
4531:
4532: IF l_error_num = 0 THEN
4533: CSTPPWAC.update_item_cppb(i_pac_period_id => p_period_id
4534: ,i_cost_group_id => p_cost_group_id
4535: ,i_txn_category => l_txn_category
4536: ,i_item_id => p_inventory_item_id
4537: ,i_user_id => FND_GLOBAL.user_id

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

4559: IF l_error_num <> 0 THEN
4560: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4561: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
4562: , G_MODULE_HEAD || l_routine || '.others'
4563: , 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4564: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4565: ||' error('||l_error_code||') '||l_error_msg
4566: );
4567: END IF;

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

4566: );
4567: END IF;
4568: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4569: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4570: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4571: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4572: ||' error('||l_error_code||') '||l_error_msg);
4573: FND_MSG_PUB.Add;
4574: RAISE FND_API.G_EXC_ERROR;