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 354: if not validate_mfg_lookups('BOM_EAM_COST_CATEGORY', P_DEF_MAINT_COST_CATEGORY)

350: --ver eam enabled
351: validate_org_eam_enabled(p_organization_id);
352:
353: --verify default cost cat
354: if not validate_mfg_lookups('BOM_EAM_COST_CATEGORY', P_DEF_MAINT_COST_CATEGORY)
355: then
356: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_COST_CAT');
357: fnd_msg_pub.add;
358: RAISE FND_API.G_EXC_ERROR;

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

358: RAISE FND_API.G_EXC_ERROR;
359: end if;
360:
361: --VALIDATE Billing_BASIS
362: if not validate_mfg_lookups('EAM_BILLING_BASIS', P_BILLING_BASIS)
363: then
364: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_BILLING_BASIS');
365: fnd_msg_pub.add;
366: RAISE FND_API.G_EXC_ERROR;

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

366: RAISE FND_API.G_EXC_ERROR;
367: end if;
368:
369: -- VALIDATE BILLING_METHOD
370: if not validate_mfg_lookups('EAM_BILLING_METHOD', P_BILLING_METHOD)
371: then
372: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_BILLING_METHOD');
373: fnd_msg_pub.add;
374: RAISE FND_API.G_EXC_ERROR;

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

619:
620: --ver eam enabled
621: validate_org_eam_enabled(p_organization_id);
622:
623: if not validate_mfg_lookups('BOM_EAM_COST_CATEGORY', P_DEF_MAINT_COST_CATEGORY)
624: then
625: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_COST_CAT');
626: fnd_msg_pub.add;
627: RAISE FND_API.G_EXC_ERROR;