APPS.MSC_ST_UTIL dependencies on MSC_ERRORS

Line 42: lv_message_text msc_errors.error_text%TYPE;

38: p_propagated VARCHAR2 DEFAULT 'N')
39: RETURN NUMBER IS
40: lv_sql_stmt VARCHAR2(5000);
41: lv_where_str VARCHAR2(5000);
42: lv_message_text msc_errors.error_text%TYPE;
43: BEGIN
44:
45: --For the severity warning, the error text will be taken from the
46: --parameter and for the severity error, error text will be picked from

Line 64: 'INSERT INTO msc_errors'

60: END IF;
61:
62: v_sql_stmt := 01;
63: lv_sql_stmt :=
64: 'INSERT INTO msc_errors'
65: ||'( error_id,'
66: ||' transaction_id,'
67: ||' message_id,'
68: ||' instance_code,'

Line 86: ||' msc_errors_s.NEXTVAL,'

82: ||' program_id,'
83: ||' program_update_date,'
84: ||' error_text)'
85: ||' SELECT'
86: ||' msc_errors_s.NEXTVAL,'
87: ||' st_transaction_id,'
88: ||' message_id,'
89: || ''''||p_instance_code||''''||','
90: || ''''||p_table_name||''''||','