DBA Data[Home] [Help]

APPS.CSD_GEN_ERRMSGS_PVT dependencies on CSD_GENERIC_ERRMSGS

Line 257: csd_generic_errmsgs_pkg.insert_row

253: );
254: END IF;
255:
256: l_generic_errmsgs_id := NULL;
257: csd_generic_errmsgs_pkg.insert_row
258: (px_generic_errmsgs_id => l_generic_errmsgs_id,
259: p_module_code => p_module_code,
260: p_source_entity_id1 => p_source_entity_id1,
261: p_source_entity_id2 => p_source_entity_id2,

Line 408: DELETE FROM csd_generic_errmsgs

404: -- initialize return status
405: x_return_status := fnd_api.g_ret_sts_success;
406:
407: BEGIN
408: DELETE FROM csd_generic_errmsgs
409: WHERE generic_errmsgs_id = p_generic_errmsgs_id;
410: EXCEPTION
411: WHEN NO_DATA_FOUND
412: THEN

Line 555: DELETE FROM csd_generic_errmsgs

551: p_api_name => l_api_name
552: );
553:
554: BEGIN
555: DELETE FROM csd_generic_errmsgs
556: WHERE module_code = p_module_code
557: AND ( source_entity_id1 = p_source_entity_id1
558: OR p_source_entity_id1 IS NULL
559: )

Line 709: FROM csd_generic_errmsgs a,

705: SELECT b.repair_number, c.meaning source_entity_type,
706: a.source_entity_type_code source_entity_type_code,
707: d.meaning msg_type, a.msg, a.generic_errmsgs_id,
708: a.source_entity_id2
709: FROM csd_generic_errmsgs a,
710: csd_repairs_v b,
711: fnd_lookups c,
712: fnd_lookups d
713: WHERE b.repair_line_id = a.source_entity_id1