[Home] [Help]
63: Exception
64: When error_process then
65: ROLLBACK to CSD_REPAIRS;
66: v_error_text := substr(sqlerrm,1,1000)||'Repair Line Id:'||repair_line_id_mig(j);
67: INSERT INTO CSD_UPG_ERRORS
68: (ORIG_SYSTEM_REFERENCE,
69: TARGET_SYSTEM_REFERENCE,
70: ORIG_SYSTEM_REFERENCE_ID,
71: UPGRADE_DATETIME,
407:
408: Exception
409: When error_process then
410: ROLLBACK to product_txn;
411: INSERT INTO CSD_UPG_ERRORS
412: (ORIG_SYSTEM_REFERENCE,
413: TARGET_SYSTEM_REFERENCE,
414: ORIG_SYSTEM_REFERENCE_ID,
415: UPGRADE_DATETIME,
430:
431: When others then
432: ROLLBACK to product_txn;
433: v_error_text := 'Err Msg:'||substr(sqlerrm,1,1000)||'Estimate Detail Id:'||estimate_detail_id_mig(j);
434: INSERT INTO CSD_UPG_ERRORS
435: (ORIG_SYSTEM_REFERENCE,
436: TARGET_SYSTEM_REFERENCE,
437: ORIG_SYSTEM_REFERENCE_ID,
438: UPGRADE_DATETIME,
631: EXCEPTION
632: WHEN OTHERS THEN
633: v_error_text := substr(SQLERRM,2000);
634: ROLLBACK to ESTIMATE_HEADER;
635: INSERT INTO csd_upg_errors
636: (orig_system_reference,
637: target_system_reference,
638: orig_system_reference_id,
639: upgrade_datetime,
798: EXCEPTION
799: WHEN OTHERS THEN
800: v_error_text := substr(SQLERRM,2000);
801: ROLLBACK to ESTIMATE_LINES;
802: INSERT INTO csd_upg_errors
803: (orig_system_reference,
804: target_system_reference,
805: orig_system_reference_id,
806: upgrade_datetime,
903: -- the csd upgrade errors table
904: Rollback to CSD_REPAIR_JOB_XREF;
905: l_error_text := 'Repair job xref updation Error '||substr(sqlerrm,1,1000);
906:
907: INSERT INTO csd_upg_errors
908: (orig_system_reference,
909: target_system_reference,
910: orig_system_reference_id,
911: upgrade_datetime,
1009: -- when errored rollback and insert the message into
1010: -- the csd upgrade errors table
1011: Rollback to CSD_REPAIR_TYPES_B;
1012: l_error_text := 'Repair Type Updation Error'||substr(sqlerrm,1,1000);
1013: INSERT INTO csd_upg_errors
1014: (orig_system_reference,
1015: target_system_reference,
1016: orig_system_reference_id,
1017: upgrade_datetime,