78: --Cursor to get the repair order record data and serial number data.
79: CURSOR cur_sn_rec (p_repln_id NUMBER)
80: IS
81: SELECT instance_id, serial_number,mass_ro_sn_id
82: FROM csd_mass_ro_sn
83: WHERE repair_line_id = p_repln_id;
84:
85: CURSOR cur_repair_order( p_repln_id NUMBER)
86: IS
210: || ']'
211: );
212: END IF;
213:
214: --Loop through CSD_MASS_RO_SN table records for the given repair order line id
215: -- and create repair order lines and product transactions for all the entered
216: -- serial numbers.
217:
218: -- l_count indicates the count of saved serial numbers.
273: x_new_repln_id => l_new_repln_id
274: );
275:
276: --If the return_status <> 'S' then
277: --Insert a record in CSD_MASS_RO_SN_ERRORS with the error message.
278: IF (l_return_status = fnd_api.g_ret_sts_success)
279: THEN
280: IF (l_event_level >= l_debug_level)
281: THEN
301: --Error handling TBD
302: ELSE
303: --Rollback to Save point Process_RO
304: ROLLBACK TO sp_process_ro_start;
305: -- Select error messages from stack and insert into CSD_MASS_RO_SN_ERRORS
306: csd_gen_errmsgs_pvt.save_fnd_msgs
307: (p_api_version => 1.0,
308: x_return_status => l_return_status,
309: x_msg_count => l_msg_count,
379: x_new_repln_id => l_new_repln_id
380: );
381:
382: --If the return_status <> 'S' then
383: --Insert a record in CSD_MASS_RO_SN_ERRORS with the error message.
384: IF (l_return_status = fnd_api.g_ret_sts_success)
385: THEN
386: l_count_sn_success := l_count_sn_success + 1;
387: csd_repairs_pvt.copy_attachments
398: --Error handling TBD
399: ELSE
400: --Rollback to Save point Process_RO
401: ROLLBACK TO sp_process_ro_start;
402: -- Select error messages from stack and insert into CSD_MASS_RO_SN_ERRORS
403: csd_gen_errmsgs_pvt.save_fnd_msgs
404: (p_api_version => 1.0,
405: x_return_status => l_return_status,
406: x_msg_count => l_msg_count,
961:
962: END IF;
963:
964:
965: --Delete the processed serial number from CSD_MASS_RO_SN if exists.
966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
967: THEN
968: fnd_log.STRING (fnd_log.level_statement,
969: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
967: THEN
968: fnd_log.STRING (fnd_log.level_statement,
969: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
970: 'Deleting CSD_MASS_RO_SN record sn=['
971: || NVL (l_repair_order_rec.serial_number, '')
972: || ']'
973: );
974: END IF;
978: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
979: THEN
980: fnd_log.STRING (fnd_log.level_statement,
981: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
982: 'Deleting CSD_MASS_RO_SN record '
983: );
984: END IF;
985:
986: csd_mass_ro_sn_pkg.delete_row (p_mass_ro_sn_id => p_mass_ro_sn_id);
982: 'Deleting CSD_MASS_RO_SN record '
983: );
984: END IF;
985:
986: csd_mass_ro_sn_pkg.delete_row (p_mass_ro_sn_id => p_mass_ro_sn_id);
987: END IF;
988:
989: -- Api body ends here
990: