DBA Data[Home] [Help]

APPS.EGO_ICC_STRUCTURE_PVT dependencies on FND_MSG_PUB

Line 3180: FND_MSG_PUB.Delete_Msg(null);

3176: l_item_locator_control Number := 0;
3177: l_locator_control Number;
3178: l_sub_locator_control Number :=0;
3179: Begin
3180: FND_MSG_PUB.Delete_Msg(null);
3181: if p_component_yield_factor is null then
3182: FND_MESSAGE.set_name('BOM', 'BOM_COMP_YIELD_MISSING');
3183: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3184: FND_MSG_PUB.add;

Line 3184: FND_MSG_PUB.add;

3180: FND_MSG_PUB.Delete_Msg(null);
3181: if p_component_yield_factor is null then
3182: FND_MESSAGE.set_name('BOM', 'BOM_COMP_YIELD_MISSING');
3183: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3184: FND_MSG_PUB.add;
3185: l_val_failure := l_val_failure+1;
3186: end if;
3187:
3188: if (p_component_yield_factor is not null AND

Line 3192: FND_MSG_PUB.add;

3188: if (p_component_yield_factor is not null AND
3189: (p_component_yield_factor < 0 OR p_component_yield_factor > 1 )) then
3190: FND_MESSAGE.set_name('BOM', 'BOM_COMPYIELD_OUT_OF_RANGE');
3191: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3192: FND_MSG_PUB.add;
3193: l_val_failure := l_val_failure+1;
3194: end if;
3195:
3196: -- Component is Option Class and yield <> 1

Line 3202: FND_MSG_PUB.add;

3198: p_bom_item_type = 2 then
3199: FND_MESSAGE.set_name('BOM', 'BOM_COMP_YIELD_NOT_ONE');
3200: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3201: FND_MESSAGE.set_token('REVISED_ITEM_NAME', null);
3202: FND_MSG_PUB.add;
3203: l_val_failure := l_val_failure+1;
3204: end if;
3205:
3206: -- Enforce_Integer can be UP only if rounding control type allows to round order quantities.

Line 3218: FND_MSG_PUB.add;

3214: and rounding_control_type = 1;
3215: EXCEPTION
3216: WHEN NO_DATA_FOUND THEN
3217: FND_MESSAGE.set_name('BOM', 'BOM_ENFORCE_INT_INVALID');
3218: FND_MSG_PUB.add;
3219: l_val_failure := l_val_failure+1;
3220: END;
3221: end if;
3222:

Line 3225: FND_MSG_PUB.add;

3221: end if;
3222:
3223: if p_basis_type = 2 and p_wip_supply_type = 6 then
3224: FND_MESSAGE.set_name('BOM', 'BOM_LOT_BASED_PHANTOM');
3225: FND_MSG_PUB.add;
3226: l_val_failure := l_val_failure+1;
3227: end if;
3228:
3229: if ( p_basis_type = 2 and ( p_optional = 1 or p_bom_item_type in (1,2))) THEN

Line 3231: FND_MSG_PUB.add;

3227: end if;
3228:
3229: if ( p_basis_type = 2 and ( p_optional = 1 or p_bom_item_type in (1,2))) THEN
3230: FND_MESSAGE.set_name('BOM', 'BOM_LOT_BASED_ATO');
3231: FND_MSG_PUB.add;
3232: l_val_failure := l_val_failure+1;
3233: end if;
3234:
3235: if p_auto_request_material IS NOT NULL AND upper(p_auto_request_material) NOT IN ('Y','N') THEN

Line 3239: FND_MSG_PUB.add;

3235: if p_auto_request_material IS NOT NULL AND upper(p_auto_request_material) NOT IN ('Y','N') THEN
3236: FND_MESSAGE.set_name('BOM', 'BOM_AUTO_REQ_MAT_INVALID');
3237: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3238: FND_MESSAGE.set_token('AUTO_REQ_MATERIAL', p_auto_request_material);
3239: FND_MSG_PUB.add;
3240: l_val_failure := l_val_failure+1;
3241: end if;
3242:
3243: if NVL(p_high_quantity,p_component_quantity) < NVL(p_component_quantity,0) THEN

Line 3246: FND_MSG_PUB.add;

3242:
3243: if NVL(p_high_quantity,p_component_quantity) < NVL(p_component_quantity,0) THEN
3244: FND_MESSAGE.set_name('BOM', 'BOM_MAX_QUANTITY_INVALID');
3245: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3246: FND_MSG_PUB.add;
3247: l_val_failure := l_val_failure+1;
3248: end if;
3249:
3250: if NVL(p_low_quantity, p_component_quantity) > NVL(p_component_quantity,0) THEN

Line 3253: FND_MSG_PUB.add;

3249:
3250: if NVL(p_low_quantity, p_component_quantity) > NVL(p_component_quantity,0) THEN
3251: FND_MESSAGE.set_name('BOM', 'BOM_MIN_QUANTITY_INVALID');
3252: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3253: FND_MSG_PUB.add;
3254: l_val_failure := l_val_failure+1;
3255: end if;
3256:
3257: if BOM_EAMUTIL.Asset_Activity_Item(item_id => p_component_item_id,

Line 3261: FND_MSG_PUB.add;

3257: if BOM_EAMUTIL.Asset_Activity_Item(item_id => p_component_item_id,
3258: org_id => p_organization_id ) = 'Y' and
3259: p_wip_supply_type NOT IN (1,4) THEN
3260: FND_MESSAGE.set_name('BOM', 'BOM_INVALID_AA_SUPTYPES');
3261: FND_MSG_PUB.add;
3262: l_val_failure := l_val_failure+1;
3263: end if;
3264:
3265: if p_wip_supply_type is not null and p_wip_supply_type = 7 THEN

Line 3269: FND_MSG_PUB.add;

3265: if p_wip_supply_type is not null and p_wip_supply_type = 7 THEN
3266: FND_MESSAGE.set_name('BOM', 'BOM_WIP_SUPPLY_TYPE_7');
3267: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3268: FND_MESSAGE.set_token('WIP_SUPPLY_TYPE', 'Based On Bill');
3269: FND_MSG_PUB.add;
3270: l_val_failure := l_val_failure+1;
3271: end if;
3272:
3273: if p_check_atp = 1 and p_component_quantity < 0 THEN

Line 3276: FND_MSG_PUB.add;

3272:
3273: if p_check_atp = 1 and p_component_quantity < 0 THEN
3274: FND_MESSAGE.set_name('BOM', 'BOM_COMP_QTY_NEGATIVE');
3275: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3276: FND_MSG_PUB.add;
3277: l_val_failure := l_val_failure+1;
3278: end if;
3279:
3280: if p_pick_components = 1 and p_component_quantity < 0 THEN

Line 3283: FND_MSG_PUB.add;

3279:
3280: if p_pick_components = 1 and p_component_quantity < 0 THEN
3281: FND_MESSAGE.set_name('BOM', 'BOM_COMP_PTO_QTY_NEGATIVE');
3282: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3283: FND_MSG_PUB.add;
3284: l_val_failure := l_val_failure+1;
3285: end if;
3286:
3287: IF p_mutually_exclusive_options = 1 THEN

Line 3297: FND_MSG_PUB.add;

3293: null;
3294: ELSIF p_bom_item_type NOT IN (1,2) THEN
3295: FND_MESSAGE.set_name('BOM', 'BOM_MUT_EXCL_NOT_MDL_OPTCLASS');
3296: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3297: FND_MSG_PUB.add;
3298: l_val_failure := l_val_failure+1;
3299: ELSE
3300: FND_MESSAGE.set_name('BOM', 'BOM_MUT_EXCL_BOM_NOT_INST');
3301: FND_MSG_PUB.add;

Line 3301: FND_MSG_PUB.add;

3297: FND_MSG_PUB.add;
3298: l_val_failure := l_val_failure+1;
3299: ELSE
3300: FND_MESSAGE.set_name('BOM', 'BOM_MUT_EXCL_BOM_NOT_INST');
3301: FND_MSG_PUB.add;
3302: l_val_failure := l_val_failure+1;
3303: END IF;
3304: ELSE
3305: null;

Line 3311: FND_MSG_PUB.add;

3307:
3308: IF p_so_basis = 1 AND p_bom_item_type <> Bom_Globals.G_OPTION_CLASS THEN
3309: FND_MESSAGE.set_name('BOM', 'BOM_SO_BASIS_ONE');
3310: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3311: FND_MSG_PUB.add;
3312: l_val_failure := l_val_failure+1;
3313: END IF;
3314:
3315: Begin

Line 3335: FND_MSG_PUB.add;

3331:
3332: if l_locator_control = 1 and p_supply_locator_id is null then
3333: FND_MESSAGE.set_name('BOM', 'BOM_LOCATOR_REQUIRED');
3334: FND_MESSAGE.set_token('REVISED_COMPONENT_NAME', p_component_name);
3335: FND_MSG_PUB.add;
3336: l_val_failure := l_val_failure+1;
3337: end if;
3338: Exception
3339: when others then

Line 3347: FND_MSG_PUB.Add_Exc_Msg('EGO_ICC_STRUCTURE_PVT','Validate_Base_attributes',sqlerrm(sqlcode));

3343: return l_val_failure;
3344:
3345: Exception
3346: when others then
3347: FND_MSG_PUB.Add_Exc_Msg('EGO_ICC_STRUCTURE_PVT','Validate_Base_attributes',sqlerrm(sqlcode));
3348: return 1;
3349: End Validate_Base_attributes;
3350:
3351: END EGO_ICC_STRUCTURE_PVT;