198: if(p_flag is not null)
199: then
200: if not EAM_COMMON_UTILITIES_PVT.validate_boolean_flag(p_flag)
201: then
202: fnd_message.set_name('EAM', p_msg);
203: fnd_msg_pub.add;
204: RAISE FND_API.G_EXC_ERROR;
205: end if;
206: end if;
216: and NVL(eam_enabled_flag,'N') = 'Y';
217:
218: if l_count = 0
219: then
220: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
221: fnd_msg_pub.add;
222: RAISE fnd_api.g_exc_error;
223: end if;
224:
244: status => l_cs_installed,
245: industry => l_indust);
246: IF (l_installed = FALSE)
247: THEN
248: fnd_message.set_name('EAM', 'EAM_WR_PN_NOT_INSTALLED');
249: fnd_msg_pub.add;
250: RAISE fnd_api.g_exc_error;
251: END IF;
252: end if;
262: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
263:
264: if (l_count = 0 and NOT p_create_flag)
265: then
266: fnd_message.set_name('EAM', 'EAM_PARAM_REC_NOT_FOUND');
267: fnd_msg_pub.add;
268: RAISE fnd_api.g_exc_error;
269: elsif (l_count >0 and p_create_flag)
270: then
267: fnd_msg_pub.add;
268: RAISE fnd_api.g_exc_error;
269: elsif (l_count >0 and p_create_flag)
270: then
271: fnd_message.set_name('EAM', 'EAM_PARAM_REC_EXISTS');
272: fnd_msg_pub.add;
273: RAISE fnd_api.g_exc_error;
274: end if;
275: END;
342: if (P_DEF_MAINT_COST_CATEGORY is null
343: or P_DEF_EAM_COST_ELEMENT_ID is null
344: or P_DEFAULT_EAM_CLASS is null)
345: then
346: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAMS');
347: fnd_msg_pub.add;
348: RAISE FND_API.G_EXC_ERROR;
349: end if;
350:
353:
354: --verify default cost cat
355: if not validate_mfg_lookups('BOM_EAM_COST_CATEGORY', P_DEF_MAINT_COST_CATEGORY)
356: then
357: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_COST_CAT');
358: fnd_msg_pub.add;
359: RAISE FND_API.G_EXC_ERROR;
360: end if;
361:
361:
362: --VALIDATE Billing_BASIS
363: if not validate_mfg_lookups('EAM_BILLING_BASIS', P_BILLING_BASIS)
364: then
365: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_BILLING_BASIS');
366: fnd_msg_pub.add;
367: RAISE FND_API.G_EXC_ERROR;
368: end if;
369:
369:
370: -- VALIDATE BILLING_METHOD
371: if not validate_mfg_lookups('EAM_BILLING_METHOD', P_BILLING_METHOD)
372: then
373: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_BILLING_METHOD');
374: fnd_msg_pub.add;
375: RAISE FND_API.G_EXC_ERROR;
376: end if;
377:
377:
378: --ver def cost element id
379: if not validate_cost_element_id(P_DEF_EAM_COST_ELEMENT_ID )
380: then
381: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CST_ELMNT_ID');
382: fnd_msg_pub.add;
383: RAISE FND_API.G_EXC_ERROR;
384: end if;
385: --ver wip acnt class
384: end if;
385: --ver wip acnt class
386: if not validate_acnt_class(P_DEFAULT_EAM_CLASS , P_ORGANIZATION_ID )
387: then
388: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
389: fnd_msg_pub.add;
390: RAISE FND_API.G_EXC_ERROR;
391: end if;
392: --ver maint offset acnt
391: end if;
392: --ver maint offset acnt
393: if not validate_chart_of_accounts(P_MAINTENANCE_OFFSET_ACCOUNT ,P_ORGANIZATION_ID )
394: then
395: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CHART_ACNT');
396: fnd_msg_pub.add;
397: RAISE FND_API.G_EXC_ERROR;
398: end if;
399:
398: end if;
399:
400: -- validate default dept id
401: if (p_default_department_id is not null and not eam_common_utilities_pvt.validate_department_id(p_default_department_id, p_organization_id)) then
402: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_DEPT_ID');
403: fnd_msg_pub.add;
404: RAISE FND_API.G_EXC_ERROR;
405: end if;
406:
615: if (P_DEF_MAINT_COST_CATEGORY is null
616: or P_DEF_EAM_COST_ELEMENT_ID is null
617: or P_DEFAULT_EAM_CLASS is null)
618: then
619: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAMS');
620: fnd_msg_pub.add;
621: RAISE FND_API.G_EXC_ERROR;
622: end if;
623:
625: validate_org_eam_enabled(p_organization_id);
626:
627: if not validate_mfg_lookups('BOM_EAM_COST_CATEGORY', P_DEF_MAINT_COST_CATEGORY)
628: then
629: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_COST_CAT');
630: fnd_msg_pub.add;
631: RAISE FND_API.G_EXC_ERROR;
632: end if;
633:
632: end if;
633:
634: if not validate_cost_element_id(P_DEF_EAM_COST_ELEMENT_ID )
635: then
636: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CST_ELMNT_ID');
637: fnd_msg_pub.add;
638: RAISE FND_API.G_EXC_ERROR;
639: end if;
640: if not validate_acnt_class(P_DEFAULT_EAM_CLASS , P_ORGANIZATION_ID )
638: RAISE FND_API.G_EXC_ERROR;
639: end if;
640: if not validate_acnt_class(P_DEFAULT_EAM_CLASS , P_ORGANIZATION_ID )
641: then
642: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
643: fnd_msg_pub.add;
644: RAISE FND_API.G_EXC_ERROR;
645: end if;
646:
645: end if;
646:
647: if not validate_chart_of_accounts(P_MAINTENANCE_OFFSET_ACCOUNT ,P_ORGANIZATION_ID )
648: then
649: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CHART_ACNT');
650: fnd_msg_pub.add;
651: RAISE FND_API.G_EXC_ERROR;
652: end if;
653:
652: end if;
653:
654: -- validate default dept id
655: if (p_default_department_id is not null and not eam_common_utilities_pvt.validate_department_id(p_default_department_id, p_organization_id)) then
656: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_DEPT_ID');
657: fnd_msg_pub.add;
658: RAISE FND_API.G_EXC_ERROR;
659: end if;
660: