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_PERIODIC_ABSORPTION_PROC dependencies on CST_PAC_ITERATION_PROCESS_PVT

Line 3114: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mmtt.organization_id) = 'Y'

3110: SELECT count(1)
3111: INTO l_count_rows
3112: FROM mtl_material_transactions_temp mmtt
3113: WHERE NVL(mmtt.transaction_status,0) <> 2
3114: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mmtt.organization_id) = 'Y'
3115: AND mmtt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3116: AND ROWNUM = 1;
3117:
3118:

Line 3138: WHERE CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mti.organization_id) = 'Y'

3134:
3135: SELECT count(1)
3136: INTO l_count_rows
3137: FROM mtl_transactions_interface mti
3138: WHERE CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mti.organization_id) = 'Y'
3139: AND mti.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3140: AND ROWNUM = 1;
3141:
3142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3161: WHERE CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(wcti.organization_id) = 'Y'

3157:
3158: SELECT count(1)
3159: INTO l_count_rows
3160: FROM wip_cost_txn_interface wcti
3161: WHERE CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(wcti.organization_id) = 'Y'
3162: AND wcti.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3163: AND ROWNUM = 1;
3164:
3165: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3187: WHERE CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(ood.organization_id) = 'Y'

3183: FROM rcv_transactions_interface rti
3184: WHERE rti.to_organization_code IN
3185: (SELECT ood.organization_code
3186: FROM cst_organization_definitions ood
3187: WHERE CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(ood.organization_id) = 'Y'
3188: )
3189: AND rti.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3190: AND ROWNUM = 1;
3191:

Line 3219: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'

3215: WHERE
3216: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3217: AND cppp.process_upto_date IS NOT NULL)
3218: AND cppp.pac_period_id = p_pac_period_id
3219: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'
3220: )
3221: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mmt.organization_id) = 'Y'
3222: AND mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3223: AND ROWNUM = 1;

Line 3221: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mmt.organization_id) = 'Y'

3217: AND cppp.process_upto_date IS NOT NULL)
3218: AND cppp.pac_period_id = p_pac_period_id
3219: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'
3220: )
3221: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mmt.organization_id) = 'Y'
3222: AND mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3223: AND ROWNUM = 1;
3224:
3225: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3250: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'

3246: WHERE
3247: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3248: AND cppp.process_upto_date IS NOT NULL)
3249: AND cppp.pac_period_id = p_pac_period_id
3250: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'
3251: )
3252: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(wt.organization_id) = 'Y'
3253: AND wt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3254: AND ROWNUM = 1;

Line 3252: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(wt.organization_id) = 'Y'

3248: AND cppp.process_upto_date IS NOT NULL)
3249: AND cppp.pac_period_id = p_pac_period_id
3250: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'
3251: )
3252: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(wt.organization_id) = 'Y'
3253: AND wt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3254: AND ROWNUM = 1;
3255:
3256: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3281: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'

3277: WHERE
3278: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3279: AND cppp.process_upto_date IS NOT NULL)
3280: AND cppp.pac_period_id = p_pac_period_id
3281: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'
3282: )
3283: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(rt.organization_id) = 'Y'
3284: AND rt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3285: AND ROWNUM = 1;

Line 3283: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(rt.organization_id) = 'Y'

3279: AND cppp.process_upto_date IS NOT NULL)
3280: AND cppp.pac_period_id = p_pac_period_id
3281: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'
3282: )
3283: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(rt.organization_id) = 'Y'
3284: AND rt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3285: AND ROWNUM = 1;
3286:
3287: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3312: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'

3308: WHERE
3309: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3310: AND cppp.process_upto_date IS NOT NULL)
3311: AND cppp.pac_period_id = p_pac_period_id
3312: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'
3313: )
3314: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(rae.organization_id) = 'Y'
3315: AND rae.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3316: AND rae.event_type_id IN (7,8, 9, 10)

Line 3314: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(rae.organization_id) = 'Y'

3310: AND cppp.process_upto_date IS NOT NULL)
3311: AND cppp.pac_period_id = p_pac_period_id
3312: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group(cppp.cost_group_id) = 'Y'
3313: )
3314: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(rae.organization_id) = 'Y'
3315: AND rae.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3316: AND rae.event_type_id IN (7,8, 9, 10)
3317: AND ROWNUM = 1;
3318:

Line 3681: CST_PAC_ITERATION_PROCESS_PVT.Initialize

3677: END IF;
3678:
3679: -- Initialize Global PL/SQL tables used in PAC interorg
3680: -- iteration process for each run
3681: CST_PAC_ITERATION_PROCESS_PVT.Initialize
3682: (p_legal_entity_id => p_legal_entity
3683: );
3684: -- TAB is used as a delimiter in output which can be viewed in spreadsheet application to see the progress through iterations.
3685: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_OUTPUT_MESSAGE');

Line 3692: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item

3688:
3689: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PMAC_ITR_PROMPT');
3690: l_message := FND_MESSAGE.Get;
3691: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3692: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3693: it need not be translated for each item */
3694: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3695: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3696: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');

Line 3695: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;

3691: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3692: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3693: it need not be translated for each item */
3694: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3695: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3696: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');
3697: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3698:
3699: -- Get the iteration process flag to check whether an iteration is an

Line 3697: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;

3693: it need not be translated for each item */
3694: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3695: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3696: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');
3697: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3698:
3699: -- Get the iteration process flag to check whether an iteration is an
3700: -- optional process
3701:

Line 3928: CST_PAC_ITERATION_PROCESS_PVT.Iteration_Process

3924: -- Perform Item Iteration LOOP
3925: -- Item --> Iteration --> Optimal Seq cost Group --> interorg Transactions
3926: -- Item --> Iteration_Process
3927: -- =======================================================================
3928: CST_PAC_ITERATION_PROCESS_PVT.Iteration_Process
3929: (p_init_msg_list => l_init_msg_list
3930: ,p_validation_level => l_validation_level
3931: ,p_legal_entity_id => p_legal_entity
3932: ,p_cost_type_id => p_cost_type_id

Line 4349: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status( p_legal_entity_id => p_legal_entity

4345: IF l_interorg_non_tol_lp_cnt <> 0 THEN
4346: -- Set Periodic Absorption Cost Processor status to Resume
4347: -- Set process status to 5 - Resume for all the valid cost groups
4348: -- in Legal Entity
4349: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status( p_legal_entity_id => p_legal_entity
4350: , p_period_id => p_period_id
4351: , p_period_end_date => p_end_date
4352: , p_phase_status => 5
4353: );

Line 4357: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status

4353: );
4354:
4355: -- Set Phase 5 status to 5 - Resume for all the CGs to display
4356: -- the Phase 7 status on the screen
4357: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status
4358: ( p_legal_entity_id => p_legal_entity
4359: , p_period_id => p_period_id
4360: , p_period_end_date => p_end_date
4361: , p_phase_status => 5

Line 4416: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status(p_legal_entity_id => p_legal_entity

4412: -- ====================================================================================
4413: -- Set Phase 7 status to 4 - complete for all valid cost groups
4414: -- Set Phase 5 status to 1 - unprocessed for all valid cost groups
4415: -- ====================================================================================
4416: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status(p_legal_entity_id => p_legal_entity
4417: ,p_period_id => p_period_id
4418: ,p_period_end_date => p_end_date
4419: ,p_phase_status => 4
4420: );

Line 4424: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity

4420: );
4421:
4422: -- Set Phase 5 status to 1 - Un Processed for all the valid cost
4423: -- groups in Legal Entity
4424: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity
4425: ,p_period_id => p_period_id
4426: ,p_period_end_date => p_end_date
4427: ,p_phase_status => 1
4428: );

Line 4440: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status(p_legal_entity_id => p_legal_entity

4436: -- ====================================================================================
4437: -- Set Phase 7 status to 4 - complete for all valid cost groups
4438: -- Set Phase 5 status to 1 - unprocessed for all valid cost groups
4439: -- ====================================================================================
4440: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status(p_legal_entity_id => p_legal_entity
4441: ,p_period_id => p_period_id
4442: ,p_period_end_date => p_end_date
4443: ,p_phase_status => 4
4444: );

Line 4448: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity

4444: );
4445:
4446: -- Set Phase 5 status to 1 - Un Processed for all the valid cost
4447: -- groups in Legal Entity
4448: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity
4449: ,p_period_id => p_period_id
4450: ,p_period_end_date => p_end_date
4451: ,p_phase_status => 1
4452: );

Line 4468: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status(p_legal_entity_id => p_legal_entity

4464: EXCEPTION
4465: WHEN FND_API.G_EXC_ERROR THEN
4466: ROLLBACK;
4467: -- Set Phase 7 Status to error
4468: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status(p_legal_entity_id => p_legal_entity
4469: ,p_period_id => p_period_id
4470: ,p_period_end_date => p_end_date
4471: ,p_phase_status => 3
4472: );

Line 4479: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status(p_legal_entity_id => p_legal_entity

4475:
4476: WHEN OTHERS THEN
4477: ROLLBACK;
4478: -- Set Phase 7 Status to error
4479: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status(p_legal_entity_id => p_legal_entity
4480: ,p_period_id => p_period_id
4481: ,p_period_end_date => p_end_date
4482: ,p_phase_status => 3
4483: );

Line 4637: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity_id

4633: FND_MESSAGE.set_token('MESSAGE', 'CSTPPINV.cost_acct_events for cost group '||p_cost_group_id||' logical txn id '||l_logical_txn_tab(i).transaction_id
4634: ||' item id '||l_logical_txn_tab(i).inventory_item_id||' org id '||l_logical_txn_tab(i).organization_id||' ('||l_error_code||') '||l_error_msg);
4635: FND_MSG_PUB.Add;
4636: -- Set Phase 5 status to Error
4637: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity_id
4638: ,p_period_id => p_period_id
4639: ,p_period_end_date => p_end_date
4640: ,p_phase_status => 3
4641: );

Line 4890: CST_PAC_ITERATION_PROCESS_PVT.Process_Optimal_Sequence(p_period_id => p_period_id);

4886: --========================================================================================
4887: -- To arrange different cost groups in incresing order of On Hand quantities for each item
4888: --========================================================================================
4889:
4890: CST_PAC_ITERATION_PROCESS_PVT.Process_Optimal_Sequence(p_period_id => p_period_id);
4891:
4892: -- ====================================================================
4893: -- Absorption Cost Rollup Process
4894: -- ====================================================================

Line 4936: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity

4932: -- Process Phase 5 for all Cost Groups
4933: -- ========================================================
4934:
4935: -- Set Phase 5 status to 2 - Running for all Cost Groups
4936: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity
4937: ,p_period_id => p_period_id
4938: ,p_period_end_date => p_end_date
4939: ,p_phase_status => 2
4940: );

Line 4982: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity

4978: FND_MESSAGE.set_token('MESSAGE', 'CST_MGD_LIFO_COST_PROCESSOR.Lifo_Cost_Processor for cost group '||
4979: p_cg_tab(l_current_index).cost_group_id||' ('||l_error_code||') '||l_error_msg);
4980: FND_MSG_PUB.Add;
4981: -- Set Phase 5 status to Error
4982: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity
4983: ,p_period_id => p_period_id
4984: ,p_period_end_date => p_end_date
4985: ,p_phase_status => 3
4986: );

Line 5034: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity

5030: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWCL.process_wip_close_txns for cost group '||
5031: p_cg_tab(l_current_index).cost_group_id||' ('||l_error_code||') '||l_error_msg);
5032: FND_MSG_PUB.Add;
5033: -- Set Phase 5 status to Error
5034: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity
5035: ,p_period_id => p_period_id
5036: ,p_period_end_date => p_end_date
5037: ,p_phase_status => 3
5038: );

Line 5050: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity

5046:
5047: END LOOP;
5048:
5049: -- Set Phase 5 completion for all cost groups
5050: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity
5051: ,p_period_id => p_period_id
5052: ,p_period_end_date => p_end_date
5053: ,p_phase_status => 4
5054: );