APPS.MRP_VALIDATE_RECEIVING_ORG dependencies on DBMS_OUTPUT

Line 27: dbms_output.put_line ('Error - Sr_Receipt_Id is null');

23: THEN
24:
25: l_return_status := FND_API.G_RET_STS_ERROR;
26:
27: dbms_output.put_line ('Error - Sr_Receipt_Id is null');
28:
29: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
30: THEN
31:

Line 116: dbms_output.put_line ('This is the only rec. org for the s rule');

112: WHERE sourcing_rule_id = p_Receiving_Org_rec.sourcing_rule_id
113: AND sr_receipt_id <> p_Receiving_Org_rec.sr_receipt_id;
114:
115: IF l_count = 0 THEN
116: dbms_output.put_line ('This is the only rec. org for the s rule');
117: FND_MESSAGE.SET_NAME('MRP','MRP_OPERATION_ERROR');
118: FND_MESSAGE.SET_TOKEN('OPERATION','DELETE');
119: FND_MESSAGE.SET_TOKEN('ENTITY','Receiving_Org');
120: FND_MESSAGE.SET_TOKEN('DETAILS',

Line 842: dbms_output.put_line ('Val_Disable_Date Error');

838: p_Disable_Date = FND_API.G_MISS_DATE
839: THEN
840: RETURN TRUE;
841: ELSIF p_Disable_Date < p_Effective_Date THEN
842: dbms_output.put_line ('Val_Disable_Date Error');
843: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Disable_Date');
845: FND_MESSAGE.SET_TOKEN('DETAILS',
846: 'Disable_Date Cannot be Less than Effective_Date');

Line 866: dbms_output.put_line ('Val_Effective_Date Error');

862:
863: IF p_Effective_Date IS NULL OR
864: p_Effective_Date = FND_API.G_MISS_DATE
865: THEN
866: dbms_output.put_line ('Val_Effective_Date Error');
867: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
868: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Effective_Date');
869: FND_MSG_PUB.Add;
870: RETURN FALSE;

Line 873: dbms_output.put_line ('Val_Effective_Date Error');

869: FND_MSG_PUB.Add;
870: RETURN FALSE;
871: ELSE
872: IF p_Effective_Date < trunc(SYSDATE) THEN
873: dbms_output.put_line ('Val_Effective_Date Error');
874: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Effective_Date');
876: FND_MESSAGE.SET_TOKEN('DETAILS',
877: 'Effective_Date Cannot be less than Current Date');

Line 1021: dbms_output.put_line ('Val_Receipt_Organization_Id Error');

1017: Open cur_sr_org;
1018: Fetch cur_sr_org INTO l_organization_id;
1019:
1020: IF l_organization_id is not NULL THEN
1021: dbms_output.put_line ('Val_Receipt_Organization_Id Error');
1022: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
1023: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Organization_Id');
1024: FND_MSG_PUB.Add;
1025: RETURN FALSE;

Line 1039: dbms_output.put_line ('Val_Receipt_Organization_Id Error');

1035: FROM MTL_PARAMETERS
1036: WHERE organization_id = p_Receipt_Organization_Id;
1037:
1038: IF l_count = 0 THEN
1039: dbms_output.put_line ('Val_Receipt_Organization_Id Error');
1040: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Organization_Id');
1042: FND_MSG_PUB.Add;
1043: RETURN FALSE;