APPS.CSD_MASS_RCV_PVT dependencies on CSD_MASS_RO_SN

Line 82: FROM csd_mass_ro_sn

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

Line 214: --Loop through CSD_MASS_RO_SN table records for the given repair order line id

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.

Line 277: --Insert a record in CSD_MASS_RO_SN_ERRORS with the error message.

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

Line 305: -- Select error messages from stack and insert into CSD_MASS_RO_SN_ERRORS

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,

Line 383: --Insert a record in CSD_MASS_RO_SN_ERRORS with the error message.

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

Line 402: -- Select error messages from stack and insert into CSD_MASS_RO_SN_ERRORS

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,

Line 971: --Delete the processed serial number from CSD_MASS_RO_SN if exists.

967:
968: END IF;
969:
970:
971: --Delete the processed serial number from CSD_MASS_RO_SN if exists.
972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
973: THEN
974: fnd_log.STRING (fnd_log.level_statement,
975: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',

Line 976: 'Deleting CSD_MASS_RO_SN record sn=['

972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
973: THEN
974: fnd_log.STRING (fnd_log.level_statement,
975: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
976: 'Deleting CSD_MASS_RO_SN record sn=['
977: || NVL (l_repair_order_rec.serial_number, '')
978: || ']'
979: );
980: END IF;

Line 988: 'Deleting CSD_MASS_RO_SN record '

984: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
985: THEN
986: fnd_log.STRING (fnd_log.level_statement,
987: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
988: 'Deleting CSD_MASS_RO_SN record '
989: );
990: END IF;
991:
992: csd_mass_ro_sn_pkg.delete_row (p_mass_ro_sn_id => p_mass_ro_sn_id);

Line 992: csd_mass_ro_sn_pkg.delete_row (p_mass_ro_sn_id => p_mass_ro_sn_id);

988: 'Deleting CSD_MASS_RO_SN record '
989: );
990: END IF;
991:
992: csd_mass_ro_sn_pkg.delete_row (p_mass_ro_sn_id => p_mass_ro_sn_id);
993: END IF;
994:
995: -- Api body ends here
996: