23: AND NVL(ECO_FOR_PRODUCTION,2) = 2
24: AND ((rowid <> X_Rowid) OR (X_Rowid IS NULL)));
25: EXCEPTION
26: WHEN NO_DATA_FOUND THEN
27: fnd_message.set_name('BOM','BOM_COMP_OP_COMBINATION');
28: app_exception.raise_exception;
29: END Check_Overlap;
30:
31: PROCEDURE Check_Unit_Number_Overlap(X_Rowid VARCHAR2,
51: AND disable_date is NULL
52: AND ((rowid <> X_Rowid) OR (X_Rowid IS NULL)));
53: EXCEPTION
54: WHEN NO_DATA_FOUND THEN
55: fnd_message.set_name('BOM','BOM_UNIT_OVERLAP');
56: app_exception.raise_exception;
57: END Check_Unit_Number_Overlap;
58:
59: PROCEDURE Check_Commons(X_Bill_Sequence_Id NUMBER,
120: AND msi1.pick_components_flag = 'Y'
121: AND msi2.bom_item_type = 4
122: AND msi2.replenish_to_order_flag = 'Y')
123: );
124: fnd_message.set_name('INV','INV_NOT_VALID');
125: fnd_message.set_token('ENTITY','Component item_CAP',TRUE);
126: fnd_message.set_name('BOM','BOM_COMMON_OTHER_ORGS');
127: app_exception.raise_exception;
128: EXCEPTION
121: AND msi2.bom_item_type = 4
122: AND msi2.replenish_to_order_flag = 'Y')
123: );
124: fnd_message.set_name('INV','INV_NOT_VALID');
125: fnd_message.set_token('ENTITY','Component item_CAP',TRUE);
126: fnd_message.set_name('BOM','BOM_COMMON_OTHER_ORGS');
127: app_exception.raise_exception;
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
122: AND msi2.replenish_to_order_flag = 'Y')
123: );
124: fnd_message.set_name('INV','INV_NOT_VALID');
125: fnd_message.set_token('ENTITY','Component item_CAP',TRUE);
126: fnd_message.set_name('BOM','BOM_COMMON_OTHER_ORGS');
127: app_exception.raise_exception;
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
130: null;
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
130: null;
131: WHEN TOO_MANY_ROWS THEN
132: fnd_message.set_name('INV','INV_NOT_VALID');
133: fnd_message.set_token('ENTITY','Component item_CAP',TRUE);
134: fnd_message.set_name('BOM','BOM_COMMON_OTHER_ORGS');
135: app_exception.raise_exception;
136: END Check_Commons;
129: WHEN NO_DATA_FOUND THEN
130: null;
131: WHEN TOO_MANY_ROWS THEN
132: fnd_message.set_name('INV','INV_NOT_VALID');
133: fnd_message.set_token('ENTITY','Component item_CAP',TRUE);
134: fnd_message.set_name('BOM','BOM_COMMON_OTHER_ORGS');
135: app_exception.raise_exception;
136: END Check_Commons;
137:
130: null;
131: WHEN TOO_MANY_ROWS THEN
132: fnd_message.set_name('INV','INV_NOT_VALID');
133: fnd_message.set_token('ENTITY','Component item_CAP',TRUE);
134: fnd_message.set_name('BOM','BOM_COMMON_OTHER_ORGS');
135: app_exception.raise_exception;
136: END Check_Commons;
137:
138:
197: -- is a valid combination
198:
199: NULL;
200: ELSE
201: fnd_message.set_name('BOM','BOM_INVALID_ATP');
202: app_exception.raise_exception;
203: END IF;
204: */
205:
226:
227: EXCEPTION
228: WHEN NO_DATA_FOUND THEN
229: IF (X_bill_or_eco = 1) THEN
230: fnd_message.set_name('BOM','BOM_COMPONENT_DUPLICATE');
231: ELSE
232: fnd_message.set_name('ENG','ENG_HAS_BEEN_MODIFIED');
233: END IF;
234: app_exception.raise_exception;
228: WHEN NO_DATA_FOUND THEN
229: IF (X_bill_or_eco = 1) THEN
230: fnd_message.set_name('BOM','BOM_COMPONENT_DUPLICATE');
231: ELSE
232: fnd_message.set_name('ENG','ENG_HAS_BEEN_MODIFIED');
233: END IF;
234: app_exception.raise_exception;
235: END Check_Unique;
236:
258:
259: EXCEPTION
260: WHEN NO_DATA_FOUND THEN
261: IF (X_bill_or_eco = 1) THEN
262: fnd_message.set_name('BOM','BOM_COMP_DUP_UNIT');
263: ELSE
264: fnd_message.set_name('ENG','ENG_UNIT_NUMBER_MODIFIED');
265: END IF;
266: app_exception.raise_exception;
260: WHEN NO_DATA_FOUND THEN
261: IF (X_bill_or_eco = 1) THEN
262: fnd_message.set_name('BOM','BOM_COMP_DUP_UNIT');
263: ELSE
264: fnd_message.set_name('ENG','ENG_UNIT_NUMBER_MODIFIED');
265: END IF;
266: app_exception.raise_exception;
267: END Check_Unique_From_Unit_Number;
268: