81: p_err_num NUMBER; -- pass back to calling program
82: p_err_msg NUMBER;
83:
84: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 Start */
85: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
86: l_organization_code mtl_parameters.organization_code%TYPE;
87: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 End */
88:
89: -- Asset Item list (Non-Serviceable) for which prices need to be imported
82: p_err_msg NUMBER;
83:
84: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 Start */
85: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
86: l_organization_code mtl_parameters.organization_code%TYPE;
87: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 End */
88:
89: -- Asset Item list (Non-Serviceable) for which prices need to be imported
90: -- Active Check not required for header as already done at SRS and for
146: SELECT nvl(process_enabled_flag,'N')
147: , organization_code
148: INTO l_process_enabled_flag
149: , l_organization_code
150: FROM mtl_parameters
151: WHERE organization_id = p_organization_id;
152:
153: IF nvl(l_process_enabled_flag,'N') = 'Y' THEN
154: FND_MESSAGE.set_name('GMF','GMF_PROCESS_ORG_ERROR');
241:
242: l_stmt_num := 20 ;
243: Select cost_organization_id
244: into l_cost_organization_id
245: from mtl_parameters MP
246: where MP.organization_id = p_organization_id;
247:
248: If p_organization_id <> l_cost_organization_id
249: Then