[Home] [Help]
170: /* Check if the record already exists corresponding to
171: the source_id, source_type */
172: SELECT COUNT(1)
173: INTO l_failure_exists
174: FROM eam_asset_failures
175: WHERE source_type = l_eam_failure_entry_record.source_type
176: AND source_id = l_eam_failure_entry_record.source_id;
177:
178: IF l_failure_exists >= 1 THEN
188: /* Failure Date is Already Validated on top of the API for both Create/ Update */
189:
190: SELECT COUNT(1)
191: INTO l_failure_exists
192: FROM eam_asset_failures
193: WHERE failure_id = l_eam_failure_entry_record.failure_id;
194:
195: IF l_failure_exists = 0 THEN
196: x_reason_failed:='EAM_FAILURE_NOT_EXISTS';
256: IF l_eam_failure_codes_record.transaction_type IN (Eam_Process_Failure_Entry_PUB.G_FE_CREATE, Eam_Process_Failure_Entry_PUB.G_FE_UPDATE) THEN
257:
258: SELECT count(1)
259: INTO l_valid_header_record
260: FROM eam_asset_failures eaf
261: WHERE eaf.failure_id = l_eam_failure_codes_record.failure_id;
262:
263: IF l_valid_header_record = 0 THEN
264: x_reason_failed:= 'EAM_HEADER_REC_NOT_EXISTS';
385: BEGIN
386: SELECT inventory_item_id
387: INTO l_inventory_item_id
388: FROM CSI_ITEM_INSTANCES
389: WHERE instance_id = ( SELECT object_id FROM eam_asset_failures
390: WHERE failure_id = l_eam_failure_codes_record.failure_id
391: );
392: EXCEPTION
393: WHEN NO_DATA_FOUND THEN
651: /* dbms_output.put_line('After Validate_failure_entry_record2'); */
652:
653: END IF;
654:
655: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures00'); */
656:
657: IF l_eam_failure_entry_record.transaction_type IS NOT NULL THEN
658:
659: IF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
656:
657: IF l_eam_failure_entry_record.transaction_type IS NOT NULL THEN
658:
659: IF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
660: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures0'); */
661: SELECT eam_asset_failures_s.nextval
662: INTO l_failure_id
663: FROM DUAL;
664: l_eam_failure_entry_record.failure_id := l_failure_id;
657: IF l_eam_failure_entry_record.transaction_type IS NOT NULL THEN
658:
659: IF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
660: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures0'); */
661: SELECT eam_asset_failures_s.nextval
662: INTO l_failure_id
663: FROM DUAL;
664: l_eam_failure_entry_record.failure_id := l_failure_id;
665: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures'); */
661: SELECT eam_asset_failures_s.nextval
662: INTO l_failure_id
663: FROM DUAL;
664: l_eam_failure_entry_record.failure_id := l_failure_id;
665: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures'); */
666: INSERT INTO eam_asset_failures
667: (
668: FAILURE_ID,
669: FAILURE_DATE,
662: INTO l_failure_id
663: FROM DUAL;
664: l_eam_failure_entry_record.failure_id := l_failure_id;
665: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures'); */
666: INSERT INTO eam_asset_failures
667: (
668: FAILURE_ID,
669: FAILURE_DATE,
670: SOURCE_TYPE,
698: SYSDATE,
699: FND_GLOBAL.user_id,
700: FND_GLOBAL.user_id
701: );
702: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failures'); */
703:
704: FOR i IN 1..l_eam_failure_codes_tbl.count
705: LOOP
706: IF l_eam_failure_codes_tbl(i).transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
708: END IF;
709: END LOOP;
710:
711: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
712: /* dbms_output.put_line('Just Before Updating the data into eam_asset_failures'); */
713: UPDATE eam_asset_failures
714: SET failure_date = l_eam_failure_entry_record.failure_date
715: /* ,source_typ = l_eam_failure_entry_record.source_typ
716: ,source_id = l_eam_failure_entry_record.source_id
709: END LOOP;
710:
711: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
712: /* dbms_output.put_line('Just Before Updating the data into eam_asset_failures'); */
713: UPDATE eam_asset_failures
714: SET failure_date = l_eam_failure_entry_record.failure_date
715: /* ,source_typ = l_eam_failure_entry_record.source_typ
716: ,source_id = l_eam_failure_entry_record.source_id
717: ,object_typ = l_eam_failure_entry_record.object_typ
723: ,last_update_date = SYSDATE
724: ,last_updated_by = FND_GLOBAL.user_id
725: ,last_update_login= FND_GLOBAL.user_id
726: WHERE failure_id = l_eam_failure_entry_record.failure_id;
727: /* dbms_output.put_line('Just After Updating the data into eam_asset_failures'); */
728:
729: END IF;
730: END IF;
731: /* dbms_output.put_line('Just Before Validating the data into eam_asset_failures_codes'); */
727: /* dbms_output.put_line('Just After Updating the data into eam_asset_failures'); */
728:
729: END IF;
730: END IF;
731: /* dbms_output.put_line('Just Before Validating the data into eam_asset_failures_codes'); */
732: --Validate the child records
733: l_return_status := true;
734: validate_failure_codes(
735: p_eam_failure_codes_tbl_typ => l_eam_failure_codes_tbl
737: , x_token_name => l_token_name
738: , x_token_value => l_token_value
739: , x_return_status => l_return_status
740: );
741: /* dbms_output.put_line('Just After Validating the data into eam_asset_failures_codes'); */
742: IF (NOT l_return_status ) THEN
743: FND_MESSAGE.SET_NAME ('EAM', l_reason_failed);
744: IF ( l_token_name is not null AND l_token_value IS NOT NULL )
745: THEN
768: SELECT inventory_item_id
769: INTO l_inventory_item_id
770: FROM CSI_ITEM_INSTANCES
771: WHERE instance_id = ( SELECT object_id
772: FROM eam_asset_failures
773: WHERE failure_id = l_eam_failure_codes_record.failure_id
774: );
775: SELECT COMBINATION_ID
776: INTO l_combination_id