30: );
31:
32: EXCEPTION
33: when NO_DATA_FOUND then
34: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
35: fnd_message.set_token('ENTITY1', 'CALENDAR_CAP', TRUE);
36: fnd_message.set_token('ENTITY2', x_calendar_code);
37: app_exception.raise_exception;
38: END Calendar_Check_Unique;
31:
32: EXCEPTION
33: when NO_DATA_FOUND then
34: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
35: fnd_message.set_token('ENTITY1', 'CALENDAR_CAP', TRUE);
36: fnd_message.set_token('ENTITY2', x_calendar_code);
37: app_exception.raise_exception;
38: END Calendar_Check_Unique;
39:
32: EXCEPTION
33: when NO_DATA_FOUND then
34: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
35: fnd_message.set_token('ENTITY1', 'CALENDAR_CAP', TRUE);
36: fnd_message.set_token('ENTITY2', x_calendar_code);
37: app_exception.raise_exception;
38: END Calendar_Check_Unique;
39:
40:
112: );
113:
114: EXCEPTION
115: when NO_DATA_FOUND then
116: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
117: fnd_message.set_token('ENTITY1', x_exception_date);
118: fnd_message.set_token('ENTITY2', NULL);
119: app_exception.raise_exception;
120: END Cal_Exception_Check_Unique;
113:
114: EXCEPTION
115: when NO_DATA_FOUND then
116: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
117: fnd_message.set_token('ENTITY1', x_exception_date);
118: fnd_message.set_token('ENTITY2', NULL);
119: app_exception.raise_exception;
120: END Cal_Exception_Check_Unique;
121:
114: EXCEPTION
115: when NO_DATA_FOUND then
116: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
117: fnd_message.set_token('ENTITY1', x_exception_date);
118: fnd_message.set_token('ENTITY2', NULL);
119: app_exception.raise_exception;
120: END Cal_Exception_Check_Unique;
121:
122:
132: );
133:
134: EXCEPTION
135: when NO_DATA_FOUND then
136: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
137: fnd_message.set_token('ENTITY1', 'SHIFT NUM', TRUE);
138: fnd_message.set_token('ENTITY2', x_shift_num);
139: app_exception.raise_exception;
140: END Shift_Check_Unique;
133:
134: EXCEPTION
135: when NO_DATA_FOUND then
136: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
137: fnd_message.set_token('ENTITY1', 'SHIFT NUM', TRUE);
138: fnd_message.set_token('ENTITY2', x_shift_num);
139: app_exception.raise_exception;
140: END Shift_Check_Unique;
141:
134: EXCEPTION
135: when NO_DATA_FOUND then
136: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
137: fnd_message.set_token('ENTITY1', 'SHIFT NUM', TRUE);
138: fnd_message.set_token('ENTITY2', x_shift_num);
139: app_exception.raise_exception;
140: END Shift_Check_Unique;
141:
142:
153: );
154:
155: EXCEPTION
156: when NO_DATA_FOUND then
157: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
158: fnd_message.set_token('ENTITY1', x_exception_date);
159: fnd_message.set_token('ENTITY2', NULL);
160: app_exception.raise_exception;
161: END Shift_Exception_Check_Unique;
154:
155: EXCEPTION
156: when NO_DATA_FOUND then
157: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
158: fnd_message.set_token('ENTITY1', x_exception_date);
159: fnd_message.set_token('ENTITY2', NULL);
160: app_exception.raise_exception;
161: END Shift_Exception_Check_Unique;
162:
155: EXCEPTION
156: when NO_DATA_FOUND then
157: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
158: fnd_message.set_token('ENTITY1', x_exception_date);
159: fnd_message.set_token('ENTITY2', NULL);
160: app_exception.raise_exception;
161: END Shift_Exception_Check_Unique;
162:
163:
182: );
183:
184: EXCEPTION
185: when NO_DATA_FOUND then
186: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
187: fnd_message.set_token('ENTITY1', 'TIME FROM_CAP', TRUE);
188: fnd_message.set_token('ENTITY2', 'TIME TO_CAP', TRUE);
189: app_exception.raise_exception;
190: END Times_Check_Unique;
183:
184: EXCEPTION
185: when NO_DATA_FOUND then
186: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
187: fnd_message.set_token('ENTITY1', 'TIME FROM_CAP', TRUE);
188: fnd_message.set_token('ENTITY2', 'TIME TO_CAP', TRUE);
189: app_exception.raise_exception;
190: END Times_Check_Unique;
191:
184: EXCEPTION
185: when NO_DATA_FOUND then
186: fnd_message.set_name('BOM', 'BOM_ALREADY_EXISTS');
187: fnd_message.set_token('ENTITY1', 'TIME FROM_CAP', TRUE);
188: fnd_message.set_token('ENTITY2', 'TIME TO_CAP', TRUE);
189: app_exception.raise_exception;
190: END Times_Check_Unique;
191:
192: