50:
51:
52: -- operation_seq_num
53:
54: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
55:
56: begin
57:
58: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
54: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
55:
56: begin
57:
58: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
59:
60: select 1
61: into g_dummy
62: from wip_operations wo
91:
92:
93: -- resource_seq_num
94:
95: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource_seq_num . . . '); END IF;
96:
97: begin
98:
99: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
95: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource_seq_num . . . '); END IF;
96:
97: begin
98:
99: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
100:
101: select 1
102: into g_dummy
103: from wip_operation_resources wor
132: end;
133:
134:
135: -- instance_id
136: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating instance_id . . . '); END IF;
137:
138: begin
139:
140: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
136: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating instance_id . . . '); END IF;
137:
138: begin
139:
140: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
141:
142: select count(*)
143: into g_dummy
144: from bom_resource_equipments
172:
173:
174:
175: -- serial_number
176: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating serial_number . . . '); END IF;
177:
178: begin
179:
180: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
176: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating serial_number . . . '); END IF;
177:
178: begin
179:
180: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
181:
182: if (p_eam_res_usage_rec.serial_number is not NULL) then
183:
184: select count(*)
217: end;
218:
219:
220: -- start_date
221: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating start_date . . . '); END IF;
222:
223: begin
224:
225: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
221: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating start_date . . . '); END IF;
222:
223: begin
224:
225: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
226:
227: if p_eam_res_usage_rec.start_date > p_eam_res_usage_rec.completion_date then
228: raise fnd_api.g_exc_unexpected_error;
229: end if;
254: end;
255:
256:
257: -- assigned_units
258: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating assigned_units . . . '); END IF;
259:
260: begin
261:
262: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
258: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating assigned_units . . . '); END IF;
259:
260: begin
261:
262: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then
263:
264: if (p_eam_res_usage_rec.assigned_units < 0 ) then
265: raise fnd_api.g_exc_unexpected_error;
266: end if;
292:
293:
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Resource Check Attributes . . . '); END IF;
297:
298:
299: END Check_Attributes;
300: