[Home] [Help]
31: -- Bug 1755817: if line belongs to a different order, then
32: -- clear the cached results so that the cache is reset for
33: -- the new order
34: IF p_record.order_number <> g_order_number THEN
35: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results;
36: g_order_number := p_record.order_number;
37: END IF;
38:
39: l_result := OE_PC_Constraints_Admin_PVT.Is_OP_constrained
35: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results;
36: g_order_number := p_record.order_number;
37: END IF;
38:
39: l_result := OE_PC_Constraints_Admin_PVT.Is_OP_constrained
40: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
41: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
42: , p_operation => p_operation
43: , p_qualifier_attribute => p_record.transaction_phase_code
58: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
59: AND p_column_name IS NOT NULL THEN
60: SELECT column_name
61: INTO l_column_name
62: FROM oe_pc_constraints
63: WHERE constraint_id = l_constraint_id;
64: if l_column_name is null and x_on_operation_action = 0 then
65: oe_debug_pub.add('Constraint on UPDATE of all columns!');
66: RAISE FND_API.G_EXC_ERROR;
2269: -- Bug 1755817: if there are no attribute-specific insert
2270: -- constraints, then no need to go further. Entity level
2271: -- security check for CREATE will be called again from
2272: -- process order after defaulting.
2273: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
2274: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE
2275: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
2276: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
2277: )