18: );
19:
20: EXCEPTION
21: WHEN NO_DATA_FOUND THEN
22: FND_MESSAGE.SET_NAME('MRP','GEN-duplicate name');
23: FND_MESSAGE.SET_TOKEN('ENTITY','E_SCHEDULE', TRUE);
24: APP_EXCEPTION.RAISE_EXCEPTION;
25:
26: END Check_Unique;
19:
20: EXCEPTION
21: WHEN NO_DATA_FOUND THEN
22: FND_MESSAGE.SET_NAME('MRP','GEN-duplicate name');
23: FND_MESSAGE.SET_TOKEN('ENTITY','E_SCHEDULE', TRUE);
24: APP_EXCEPTION.RAISE_EXCEPTION;
25:
26: END Check_Unique;
27:
83: RETURN(TRUE);
84:
85: EXCEPTION
86: WHEN NO_DATA_FOUND THEN
87: FND_MESSAGE.SET_NAME('MRP','GEN-duplicate name');
88: if (entity = 1) then
89: FND_MESSAGE.SET_TOKEN('ENTITY','E_FORECAST', TRUE);
90: else
91: FND_MESSAGE.SET_TOKEN('ENTITY','E_PLAN', TRUE);
85: EXCEPTION
86: WHEN NO_DATA_FOUND THEN
87: FND_MESSAGE.SET_NAME('MRP','GEN-duplicate name');
88: if (entity = 1) then
89: FND_MESSAGE.SET_TOKEN('ENTITY','E_FORECAST', TRUE);
90: else
91: FND_MESSAGE.SET_TOKEN('ENTITY','E_PLAN', TRUE);
92: end if;
93: APP_EXCEPTION.RAISE_EXCEPTION;
87: FND_MESSAGE.SET_NAME('MRP','GEN-duplicate name');
88: if (entity = 1) then
89: FND_MESSAGE.SET_TOKEN('ENTITY','E_FORECAST', TRUE);
90: else
91: FND_MESSAGE.SET_TOKEN('ENTITY','E_PLAN', TRUE);
92: end if;
93: APP_EXCEPTION.RAISE_EXCEPTION;
94: RETURN(FALSE);
95:
120: RETURN(TRUE);
121:
122: EXCEPTION
123: WHEN NO_DATA_FOUND THEN
124: FND_MESSAGE.SET_NAME('MRP', 'No Plans exist');
125: RETURN(FALSE);
126:
127: END Plans_Exist;
128: