DBA Data[Home] [Help]

APPS.ASF_ERR_REP_PKG dependencies on AS_LS_ERRS

Line 24: t_error_type_id as_ls_errs.error_type_id%TYPE;

20: --
21: -- End of Comments
22: ----------------------------------------------------------
23: /* ******* ERROR MSG TABLE VARIABLES ******** */
24: t_error_type_id as_ls_errs.error_type_id%TYPE;
25: t_error_text as_ls_errs.error_text%TYPE;
26:
27: PROCEDURE process_error
28: (p_dir_flag IN VARCHAR2

Line 25: t_error_text as_ls_errs.error_text%TYPE;

21: -- End of Comments
22: ----------------------------------------------------------
23: /* ******* ERROR MSG TABLE VARIABLES ******** */
24: t_error_type_id as_ls_errs.error_type_id%TYPE;
25: t_error_text as_ls_errs.error_text%TYPE;
26:
27: PROCEDURE process_error
28: (p_dir_flag IN VARCHAR2
29: ,p_error_num IN NUMBER

Line 60: INSERT INTO as_ls_errs (error_id, dir_flag,error_status,

56: t_error_type_id := 2;
57: END IF;
58:
59: -- BEGIN
60: INSERT INTO as_ls_errs (error_id, dir_flag,error_status,
61: error_type_id,error_num,error_code,
62: error_text, transaction_id,
63: lead_id,partner_id,error_cre_date)
64: VALUES

Line 65: (as_ls_errs_s.nextval,p_dir_flag,

61: error_type_id,error_num,error_code,
62: error_text, transaction_id,
63: lead_id,partner_id,error_cre_date)
64: VALUES
65: (as_ls_errs_s.nextval,p_dir_flag,
66: 'O',t_error_type_id,p_error_num,
67: p_error_code,p_error_text,
68: p_transaction_id,p_lead_id,
69: p_partner_id,sysdate);