eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_PROCESS_FAILURE_ENTRY_PVT dependencies on EAM_ASSET_FAILURES

Line 174: FROM eam_asset_failures

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

Line 192: FROM eam_asset_failures

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';

Line 260: FROM eam_asset_failures eaf

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';

Line 389: WHERE instance_id = ( SELECT object_id FROM eam_asset_failures

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

Line 659: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures00'); */

655: /* dbms_output.put_line('After Validate_failure_entry_record2'); */
656:
657: END IF;
658:
659: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures00'); */
660:
661: IF l_eam_failure_entry_record.transaction_type IS NOT NULL THEN
662:
663: IF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN

Line 664: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures0'); */

660:
661: IF l_eam_failure_entry_record.transaction_type IS NOT NULL THEN
662:
663: IF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
664: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures0'); */
665: SELECT eam_asset_failures_s.nextval
666: INTO l_failure_id
667: FROM DUAL;
668: l_eam_failure_entry_record.failure_id := l_failure_id;

Line 665: SELECT eam_asset_failures_s.nextval

661: IF l_eam_failure_entry_record.transaction_type IS NOT NULL THEN
662:
663: IF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
664: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures0'); */
665: SELECT eam_asset_failures_s.nextval
666: INTO l_failure_id
667: FROM DUAL;
668: l_eam_failure_entry_record.failure_id := l_failure_id;
669: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures'); */

Line 669: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures'); */

665: SELECT eam_asset_failures_s.nextval
666: INTO l_failure_id
667: FROM DUAL;
668: l_eam_failure_entry_record.failure_id := l_failure_id;
669: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures'); */
670: INSERT INTO eam_asset_failures
671: (
672: FAILURE_ID,
673: FAILURE_DATE,

Line 670: INSERT INTO eam_asset_failures

666: INTO l_failure_id
667: FROM DUAL;
668: l_eam_failure_entry_record.failure_id := l_failure_id;
669: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures'); */
670: INSERT INTO eam_asset_failures
671: (
672: FAILURE_ID,
673: FAILURE_DATE,
674: SOURCE_TYPE,

Line 706: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failures'); */

702: SYSDATE,
703: FND_GLOBAL.user_id,
704: FND_GLOBAL.user_id
705: );
706: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failures'); */
707:
708: FOR i IN 1..l_eam_failure_codes_tbl.count
709: LOOP
710: IF l_eam_failure_codes_tbl(i).transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN

Line 716: /* dbms_output.put_line('Just Before Updating the data into eam_asset_failures'); */

712: END IF;
713: END LOOP;
714:
715: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
716: /* dbms_output.put_line('Just Before Updating the data into eam_asset_failures'); */
717: UPDATE eam_asset_failures
718: SET failure_date = l_eam_failure_entry_record.failure_date
719: /* ,source_typ = l_eam_failure_entry_record.source_typ
720: ,source_id = l_eam_failure_entry_record.source_id

Line 717: UPDATE eam_asset_failures

713: END LOOP;
714:
715: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
716: /* dbms_output.put_line('Just Before Updating the data into eam_asset_failures'); */
717: UPDATE eam_asset_failures
718: SET failure_date = l_eam_failure_entry_record.failure_date
719: /* ,source_typ = l_eam_failure_entry_record.source_typ
720: ,source_id = l_eam_failure_entry_record.source_id
721: ,object_typ = l_eam_failure_entry_record.object_typ

Line 731: /* dbms_output.put_line('Just After Updating the data into eam_asset_failures'); */

727: ,last_update_date = SYSDATE
728: ,last_updated_by = FND_GLOBAL.user_id
729: ,last_update_login= FND_GLOBAL.user_id
730: WHERE failure_id = l_eam_failure_entry_record.failure_id;
731: /* dbms_output.put_line('Just After Updating the data into eam_asset_failures'); */
732:
733: END IF;
734: END IF;
735: /* dbms_output.put_line('Just Before Validating the data into eam_asset_failures_codes'); */

Line 735: /* dbms_output.put_line('Just Before Validating the data into eam_asset_failures_codes'); */

731: /* dbms_output.put_line('Just After Updating the data into eam_asset_failures'); */
732:
733: END IF;
734: END IF;
735: /* dbms_output.put_line('Just Before Validating the data into eam_asset_failures_codes'); */
736: --Validate the child records
737: l_return_status := true;
738: validate_failure_codes(
739: p_eam_failure_codes_tbl_typ => l_eam_failure_codes_tbl

Line 745: /* dbms_output.put_line('Just After Validating the data into eam_asset_failures_codes'); */

741: , x_token_name => l_token_name
742: , x_token_value => l_token_value
743: , x_return_status => l_return_status
744: );
745: /* dbms_output.put_line('Just After Validating the data into eam_asset_failures_codes'); */
746: IF (NOT l_return_status ) THEN
747: FND_MESSAGE.SET_NAME ('EAM', l_reason_failed);
748: IF ( l_token_name is not null AND l_token_value IS NOT NULL )
749: THEN

Line 776: FROM eam_asset_failures

772: SELECT inventory_item_id
773: INTO l_inventory_item_id
774: FROM CSI_ITEM_INSTANCES
775: WHERE instance_id = ( SELECT object_id
776: FROM eam_asset_failures
777: WHERE failure_id = l_eam_failure_codes_record.failure_id
778: );
779: SELECT COMBINATION_ID
780: INTO l_combination_id

Line 941: SELECT COUNT(1) INTO l_count FROM eam_asset_failures WHERE source_id = p_source_id;

937:
938: -- Initialize API return status to success
939: x_return_status := FND_API.G_RET_STS_SUCCESS;
940:
941: SELECT COUNT(1) INTO l_count FROM eam_asset_failures WHERE source_id = p_source_id;
942:
943: IF l_count >=1 THEN
944:
945: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Deleting the earlier failure data') ; END IF;

Line 947: SELECT failure_id INTO l_failure_id FROM eam_asset_failures WHERE source_id = p_source_id;

943: IF l_count >=1 THEN
944:
945: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Deleting the earlier failure data') ; END IF;
946:
947: SELECT failure_id INTO l_failure_id FROM eam_asset_failures WHERE source_id = p_source_id;
948:
949: DELETE FROM eam_asset_failure_codes eafc
950: WHERE eafc.failure_id=l_failure_id;
951:

Line 952: DELETE FROM eam_asset_failures eaf

948:
949: DELETE FROM eam_asset_failure_codes eafc
950: WHERE eafc.failure_id=l_failure_id;
951:
952: DELETE FROM eam_asset_failures eaf
953: WHERE eaf.failure_id=l_failure_id;
954: ELSE
955: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Failure information doesn''t exist') ; END IF;
956: END IF;