APPS.EAM_PARAMETERS_PUB dependencies on MFG_LOOKUPS

Line 86: FUNCTION validate_mfg_lookups(P_LOOKUP_TYPE IN VARCHAR2, P_LOOKUP_CODE in varchar2)

82:
83: END;
84:
85: --funcation to validate if the provided lookup code is present forthe specified type.
86: FUNCTION validate_mfg_lookups(P_LOOKUP_TYPE IN VARCHAR2, P_LOOKUP_CODE in varchar2)
87: return boolean is
88: l_count number;
89: BEGIN
90: if P_LOOKUP_TYPE = 'BOM_EAM_COST_CATEGORY' AND P_LOOKUP_CODE is null

Line 99: FROM mfg_lookups

95: return true;
96: end if;
97:
98: SELECT count(*) INTO l_count
99: FROM mfg_lookups
100: WHERE lookup_type = P_LOOKUP_TYPE
101: AND lookup_code = P_LOOKUP_CODE;
102:
103: if l_count = 0

Line 355: if not validate_mfg_lookups('BOM_EAM_COST_CATEGORY', P_DEF_MAINT_COST_CATEGORY)

351: --ver eam enabled
352: validate_org_eam_enabled(p_organization_id);
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;

Line 363: if not validate_mfg_lookups('EAM_BILLING_BASIS', P_BILLING_BASIS)

359: RAISE FND_API.G_EXC_ERROR;
360: end if;
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;

Line 371: if not validate_mfg_lookups('EAM_BILLING_METHOD', P_BILLING_METHOD)

367: RAISE FND_API.G_EXC_ERROR;
368: end if;
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;

Line 627: if not validate_mfg_lookups('BOM_EAM_COST_CATEGORY', P_DEF_MAINT_COST_CATEGORY)

623:
624: --ver eam enabled
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;