APPS.MRP_VALIDATE_SOURCING_RULE dependencies on DBMS_OUTPUT

Line 108: dbms_output.put_line ('Cannot delete Sourcing Rule');

104: FROM MRP_SR_ASSIGNMENTS
105: WHERE sourcing_rule_id = p_Sourcing_Rule_rec.sourcing_rule_id;
106:
107: IF l_count > 0 THEN
108: dbms_output.put_line ('Cannot delete Sourcing Rule');
109: FND_MESSAGE.SET_NAME('MRP','MRP_OPERATION_ERROR');
110: FND_MESSAGE.SET_TOKEN('OPERATION','DELETE');
111: FND_MESSAGE.SET_TOKEN('ENTITY','Sourcing_Rule');
112: FND_MESSAGE.SET_TOKEN('DETAILS','This Sourcing Rule has been assigned');

Line 169: dbms_output.put_line ('Error Sourcing_Rule_Id');

165: IF NOT MRP_Validate.Sourcing_Rule
166: ( p_Sourcing_Rule_rec.Sourcing_Rule_Id
167: )
168: THEN
169: dbms_output.put_line ('Error Sourcing_Rule_Id');
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: END IF;
172: END IF;
173:

Line 409: dbms_output.put_line ('Error Organization_Id');

405: 'Cannot change Organization while Updating');
406: FND_MSG_PUB.Add;
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: ELSIF NOT Val_Organization_Id(p_Sourcing_Rule_rec.Organization_Id) THEN
409: dbms_output.put_line ('Error Organization_Id');
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: END IF;
412: END IF;
413:

Line 472: dbms_output.put_line ('Error Sourcing_Rule_Name');

468: THEN
469: -- Bug 3015208
470: IF NOT Val_Sourcing_Rule_Name(p_Sourcing_Rule_rec.Sourcing_Rule_Name,
471: p_Sourcing_Rule_rec.organization_id) THEN
472: dbms_output.put_line ('Error Sourcing_Rule_Name');
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: END IF;
475: END IF;
476:

Line 492: dbms_output.put_line ('Error Sourcing_Rule_Type');

488: 'Cannot Change Sourcing Rule Type while updating');
489: FND_MSG_PUB.Add;
490: x_return_status := FND_API.G_RET_STS_ERROR;
491: ELSIF NOT Val_Sourcing_Rule_Type(p_Sourcing_Rule_rec.Sourcing_Rule_Type) THEN
492: dbms_output.put_line ('Error Sourcing_Rule_Type');
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: END IF;
495: END IF;
496:

Line 503: dbms_output.put_line ('Error Status');

499: p_old_Sourcing_Rule_rec.Status OR
500: p_old_Sourcing_Rule_rec.Status IS NULL )
501: THEN
502: IF NOT Val_Status(p_Sourcing_Rule_rec.Status) THEN
503: dbms_output.put_line ('Error Status');
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: END IF;
506: END IF;
507: