81: and mp.maint_organization_id = p_organization_id
82: and eam_item_type = 3
83: and rownum = 1;
84: else
85: fnd_message.set_name('EAM', 'EAM_REBUILD_ITEM_EXCEPTION');
86: fnd_msg_pub.add;
87: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
88: return; --no use in continuing further with validations
89: end if;
88: return; --no use in continuing further with validations
89: end if;
90: exception
91: when no_data_found then
92: fnd_message.set_name('EAM', 'EAM_INVALID_REBUILD_ITEM');
93: fnd_msg_pub.add;
94: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
95: return;
96: end;
155: end if;
156: exception
157: when no_data_found then
158: if (p_validate_mode = VALIDATE_ISSUE) then
159: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL_ISSUE');
160: elsif (p_validate_mode = VALIDATE_REMOVE) then
161: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL_REMOVE');
162: else
163: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL');
157: when no_data_found then
158: if (p_validate_mode = VALIDATE_ISSUE) then
159: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL_ISSUE');
160: elsif (p_validate_mode = VALIDATE_REMOVE) then
161: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL_REMOVE');
162: else
163: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL');
164: end if;
165: fnd_message.set_token('SERIAL', p_rebuild_serial_number);
159: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL_ISSUE');
160: elsif (p_validate_mode = VALIDATE_REMOVE) then
161: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL_REMOVE');
162: else
163: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL');
164: end if;
165: fnd_message.set_token('SERIAL', p_rebuild_serial_number);
166: fnd_msg_pub.add;
167: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
161: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL_REMOVE');
162: else
163: fnd_message.set_name('EAM', 'EAM_INVALID_RBLD_SERIAL');
164: end if;
165: fnd_message.set_token('SERIAL', p_rebuild_serial_number);
166: fnd_msg_pub.add;
167: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
168: return;
169: end;
178: 'Now Validating Rebuild Activity...');
179: end if;
180: -- serial mandatory if specifying activity for serialized rebuild
181: if ((p_rebuild_serial_number is null) and (l_serial_control_code > 1)) then
182: fnd_message.set_name('EAM', 'EAM_NO_SERIAL_FOR_ACTIVITY');
183: fnd_msg_pub.add;
184: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
185: return;
186: end if;
235: 'Finished Validating Rebuild Activity');
236: end if;
237: exception
238: when no_data_found then
239: fnd_message.set_name('EAM', 'EAM_INVALID_ACTIVITY');
240: fnd_msg_pub.add;
241: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
242: return;
243: end;