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,
128: )
129: OR (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
130: ) /* bug 10082384 */
131: );
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: EXCEPTION
129: OR (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
130: ) /* bug 10082384 */
131: );
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: EXCEPTION
137: WHEN NO_DATA_FOUND THEN
130: ) /* bug 10082384 */
131: );
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: EXCEPTION
137: WHEN NO_DATA_FOUND THEN
138: null;
136: EXCEPTION
137: WHEN NO_DATA_FOUND THEN
138: null;
139: WHEN TOO_MANY_ROWS THEN
140: fnd_message.set_name('INV','INV_NOT_VALID');
141: fnd_message.set_token('ENTITY','Component item_CAP',TRUE);
142: fnd_message.set_name('BOM','BOM_COMMON_OTHER_ORGS');
143: app_exception.raise_exception;
144: END Check_Commons;
137: WHEN NO_DATA_FOUND THEN
138: null;
139: WHEN TOO_MANY_ROWS THEN
140: fnd_message.set_name('INV','INV_NOT_VALID');
141: fnd_message.set_token('ENTITY','Component item_CAP',TRUE);
142: fnd_message.set_name('BOM','BOM_COMMON_OTHER_ORGS');
143: app_exception.raise_exception;
144: END Check_Commons;
145:
138: null;
139: WHEN TOO_MANY_ROWS THEN
140: fnd_message.set_name('INV','INV_NOT_VALID');
141: fnd_message.set_token('ENTITY','Component item_CAP',TRUE);
142: fnd_message.set_name('BOM','BOM_COMMON_OTHER_ORGS');
143: app_exception.raise_exception;
144: END Check_Commons;
145:
146:
205: -- is a valid combination
206:
207: NULL;
208: ELSE
209: fnd_message.set_name('BOM','BOM_INVALID_ATP');
210: app_exception.raise_exception;
211: END IF;
212: */
213:
234:
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: IF (X_bill_or_eco = 1) THEN
238: fnd_message.set_name('BOM','BOM_COMPONENT_DUPLICATE');
239: ELSE
240: fnd_message.set_name('ENG','ENG_HAS_BEEN_MODIFIED');
241: END IF;
242: app_exception.raise_exception;
236: WHEN NO_DATA_FOUND THEN
237: IF (X_bill_or_eco = 1) THEN
238: fnd_message.set_name('BOM','BOM_COMPONENT_DUPLICATE');
239: ELSE
240: fnd_message.set_name('ENG','ENG_HAS_BEEN_MODIFIED');
241: END IF;
242: app_exception.raise_exception;
243: END Check_Unique;
244:
266:
267: EXCEPTION
268: WHEN NO_DATA_FOUND THEN
269: IF (X_bill_or_eco = 1) THEN
270: fnd_message.set_name('BOM','BOM_COMP_DUP_UNIT');
271: ELSE
272: fnd_message.set_name('ENG','ENG_UNIT_NUMBER_MODIFIED');
273: END IF;
274: app_exception.raise_exception;
268: WHEN NO_DATA_FOUND THEN
269: IF (X_bill_or_eco = 1) THEN
270: fnd_message.set_name('BOM','BOM_COMP_DUP_UNIT');
271: ELSE
272: fnd_message.set_name('ENG','ENG_UNIT_NUMBER_MODIFIED');
273: END IF;
274: app_exception.raise_exception;
275: END Check_Unique_From_Unit_Number;
276: