[Home] [Help]
110: v_error_text := substr(sqlerrm, 1, 1000)
111: || 'Actual Repair Line Id:'
112: || act_hdr_arr(j);
113:
114: INSERT INTO CSD_UPG_ERRORS
115: (ORIG_SYSTEM_REFERENCE,
116: TARGET_SYSTEM_REFERENCE,
117: ORIG_SYSTEM_REFERENCE_ID,
118: UPGRADE_DATETIME,
260: v_error_text := substr(sqlerrm, 1, 1000)
261: || 'Estimate Detail Id:'
262: || est_lines_arr(j);
263:
264: INSERT INTO CSD_UPG_ERRORS
265: (ORIG_SYSTEM_REFERENCE,
266: TARGET_SYSTEM_REFERENCE,
267: ORIG_SYSTEM_REFERENCE_ID,
268: UPGRADE_DATETIME,
399: v_error_text := substr(sqlerrm, 1, 1000)
400: || 'Repair Estimate Line Id:'
401: || rep_est_lines_arr(j);
402:
403: INSERT INTO CSD_UPG_ERRORS
404: (ORIG_SYSTEM_REFERENCE,
405: TARGET_SYSTEM_REFERENCE,
406: ORIG_SYSTEM_REFERENCE_ID,
407: UPGRADE_DATETIME,
1841: || 'Actual Estimate Detail Id:'
1842: || v_ESTIMATE_DETAIL_ID(j);
1843: end if;
1844:
1845: INSERT INTO CSD_UPG_ERRORS
1846: (ORIG_SYSTEM_REFERENCE,
1847: TARGET_SYSTEM_REFERENCE,
1848: ORIG_SYSTEM_REFERENCE_ID,
1849: UPGRADE_DATETIME,
2219: || 'Actual Estimate Detail Id:'
2220: || est_det_arr(j).estimate_detail_id;
2221: end if;
2222:
2223: INSERT INTO CSD_UPG_ERRORS
2224: (ORIG_SYSTEM_REFERENCE,
2225: TARGET_SYSTEM_REFERENCE,
2226: ORIG_SYSTEM_REFERENCE_ID,
2227: UPGRADE_DATETIME,
2349: v_error_text := substr(sqlerrm, 1, 1000)
2350: || 'Repair Job Xref Id:'
2351: || repair_job_xref_id_mig(j);
2352:
2353: INSERT INTO CSD_UPG_ERRORS
2354: (ORIG_SYSTEM_REFERENCE,
2355: TARGET_SYSTEM_REFERENCE,
2356: ORIG_SYSTEM_REFERENCE_ID,
2357: UPGRADE_DATETIME,
2412: v_error_text := substr(sqlerrm, 1, 1000)
2413: || 'Repair Job Xref Id:'
2414: || repair_job_xref_id_mig(j);
2415:
2416: INSERT INTO CSD_UPG_ERRORS
2417: (ORIG_SYSTEM_REFERENCE,
2418: TARGET_SYSTEM_REFERENCE,
2419: ORIG_SYSTEM_REFERENCE_ID,
2420: UPGRADE_DATETIME,
2470: ROLLBACK TO CSD_MASS_RO_SN_ERRORS;
2471: v_error_text := substr(sqlerrm, 1, 1000)
2472: || 'Not able to update Repair type from RR to WR';
2473:
2474: INSERT INTO CSD_UPG_ERRORS
2475: (ORIG_SYSTEM_REFERENCE,
2476: TARGET_SYSTEM_REFERENCE,
2477: ORIG_SYSTEM_REFERENCE_ID,
2478: UPGRADE_DATETIME,
2495: ROLLBACK TO CSD_MASS_RO_SN_ERRORS;
2496: v_error_text := substr(sqlerrm, 1, 1000)
2497: || 'Not able to update Repair type from ARR to WRL';
2498:
2499: INSERT INTO CSD_UPG_ERRORS
2500: (ORIG_SYSTEM_REFERENCE,
2501: TARGET_SYSTEM_REFERENCE,
2502: ORIG_SYSTEM_REFERENCE_ID,
2503: UPGRADE_DATETIME,
2790: x_rate => l_rate
2791: );
2792: -- If l_rate is -1 or -2 then conversion did not happen.
2793: -- Update original_cost with the item_cost and item_cost
2794: --with null and save this info in CSD_UPG_ERRORS table.
2795: IF l_rate < 0 then
2796: Update csd_repair_Estimate_lines
2797: set original_cost = item_cost,
2798: item_cost = null
2837: -- v_error_text := substr(sqlerrm,1,1000)||'Estimate_Line_id:'||repair_estimate_line_id_mig(j) ;
2838:
2839: log_error(repair_estimate_line_id_mig(j),item_cost_mig(j), l_cost_currency_code);
2840:
2841: /* INSERT INTO CSD_UPG_ERRORS
2842: (ORIG_SYSTEM_REFERENCE,
2843: TARGET_SYSTEM_REFERENCE,
2844: ORIG_SYSTEM_REFERENCE_ID,
2845: UPGRADE_DATETIME,
2857:
2858: WHEN error_process THEN
2859: v_error_text := substr(sqlerrm,1,1000)||'Estimate_Line_id:'||repair_estimate_line_id_mig(j) ;
2860:
2861: INSERT INTO CSD_UPG_ERRORS
2862: (ORIG_SYSTEM_REFERENCE,
2863: TARGET_SYSTEM_REFERENCE,
2864: ORIG_SYSTEM_REFERENCE_ID,
2865: UPGRADE_DATETIME,
2897: /* description : procedure for logging errors while migrating */
2898: /* csd_repair_estimate_lines table cost data */
2899: /* from 11.5.9 to 11.5.10 */
2900: /* */
2901: /* This procedure will log the item_cost in CSD_UPG_ERRORS table */
2902: /*-------------------------------------------------------------------------------*/
2903: procedure log_Error( p_estimate_line_id number,p_item_cost number, p_cost_currency_code varchar2)
2904: IS
2905: v_error_text varchar2(2000);
2907: --Log the item_cost for the estimate that is being reset to null
2908: v_error_text := substr(sqlerrm,1,1000)||'Estimate_Line_id:'||p_estimate_line_id
2909: || 'item_cost:'|| p_item_cost ||p_cost_currency_code ;
2910:
2911: INSERT INTO CSD_UPG_ERRORS
2912: (ORIG_SYSTEM_REFERENCE,
2913: TARGET_SYSTEM_REFERENCE,
2914: ORIG_SYSTEM_REFERENCE_ID,
2915: UPGRADE_DATETIME,
3200: v_error_text || -- ', while processing event code ''
3201: 'for the repair history id between ' ||
3202: v_min || ' and ' || v_max;
3203:
3204: INSERT INTO CSD_UPG_ERRORS
3205: (ORIG_SYSTEM_REFERENCE,
3206: TARGET_SYSTEM_REFERENCE,
3207: ORIG_SYSTEM_REFERENCE_ID,
3208: UPGRADE_DATETIME,
3824: l_error_text := substr(sqlerrm, 1, 1000) || 'Product Transaction Id:'||
3825: v_product_trans_id(j);
3826: ROLLBACK TO Update_prod_Txns;
3827:
3828: INSERT INTO CSD_UPG_ERRORS
3829: (ORIG_SYSTEM_REFERENCE,
3830: TARGET_SYSTEM_REFERENCE,
3831: ORIG_SYSTEM_REFERENCE_ID,
3832: UPGRADE_DATETIME,
3873: When Others Then
3874: ROLLBACK TO Update_prod_Txns;
3875: l_error_text := 'Event :' || l_procedure_event ||' -Error Code :' || sqlcode || 'Error Message:' || substr(sqlerrm, 1, 1000) ;
3876:
3877: INSERT INTO CSD_UPG_ERRORS
3878: (ORIG_SYSTEM_REFERENCE,
3879: TARGET_SYSTEM_REFERENCE,
3880: ORIG_SYSTEM_REFERENCE_ID,
3881: UPGRADE_DATETIME,
3908: l_error_text := 'Error Code :' || sqlcode || 'Error Message:' || substr(sqlerrm, 1, 1000) ;
3909: -- Rollback the changes
3910: ROLLBACK;
3911:
3912: INSERT INTO CSD_UPG_ERRORS
3913: (ORIG_SYSTEM_REFERENCE,
3914: TARGET_SYSTEM_REFERENCE,
3915: ORIG_SYSTEM_REFERENCE_ID,
3916: UPGRADE_DATETIME,