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'); */
670: INSERT INTO eam_asset_failures
671: (
808: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failure_codes'); */
809:
810: SELECT eam_asset_failure_codes_s.nextval
811: INTO l_failure_entry_id
812: FROM DUAL;
813: l_eam_failure_codes_record.failure_entry_id := l_failure_entry_id;
814:
815: INSERT INTO eam_asset_failure_codes
816: (