[Home] [Help]
PACKAGE: APPS.OKC_AQ_WRITE_ERROR_PVT
Source
1 Package OKC_AQ_WRITE_ERROR_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCRAQWS.pls 120.0 2005/05/25 23:03:53 appldev noship $ */
3 ----------------------------------------------------------------------------------
4 --Subtype Definitions
5 subtype aqev_rec_type is okc_aqerrmsg_pub.aqev_rec_type;
6 subtype aqev_tbl_type is okc_aqerrmsg_pub.aqev_tbl_type;
7 subtype aqmv_rec_type is okc_aqerrmsg_pub.aqmv_rec_type;
8 subtype aqmv_tbl_type is okc_aqerrmsg_pub.aqmv_tbl_type;
9 ----------------------------------------------------------------------------------
10 --Global Variables
11 l_aqev_rec aqev_rec_type;
12 x_aqev_rec aqev_rec_type;
13 l_aqev_tbl aqev_tbl_type;
14 l_aqmv_rec aqmv_rec_type;
15 x_aqmv_rec aqmv_rec_type;
16 l_aqmv_tbl aqmv_tbl_type;
17 x_aqmv_tbl aqmv_tbl_type;
18
19 -- Global Variables
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_AQ_WRITE_ERROR_PVT';
21 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
22 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
24 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
25
26 --Global Exception
27 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
28
29 --Procedure to write errors and message details to the tables from the message stack
30 PROCEDURE WRITE_MSGDATA(p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
32 p_source_name IN VARCHAR2,
33 p_datetime IN DATE,
34 p_msg_tab IN OKC_AQ_PVT.msg_tab_typ,
35 p_q_name IN VARCHAR2 DEFAULT NULL,
36 p_corrid IN VARCHAR2,
37 p_msgid IN RAW DEFAULT NULL,
38 p_message_name IN VARCHAR2 DEFAULT NULL,
39 p_msg_count IN NUMBER,
40 p_msg_data IN VARCHAR2,
41 p_commit IN VARCHAR2 DEFAULT 'T');
42
43 --Procedure to update errors and message details in the tables
44 PROCEDURE UPDATE_ERROR(p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46 p_id IN NUMBER,
47 p_aqe_id IN NUMBER,
48 p_msg_seq_no IN NUMBER,
49 p_source_name IN VARCHAR2,
50 p_datetime IN DATE,
51 p_q_name IN VARCHAR2 DEFAULT NULL,
52 p_msgid IN RAW DEFAULT NULL,
53 p_message_no IN NUMBER,
54 p_message_name IN VARCHAR2,
55 p_message_text IN VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 x_return_status OUT NOCOPY VARCHAR2);
59
60 --Procedure to delete errors and message details from the tables
61 PROCEDURE DELETE_ERROR(p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
63 p_id IN NUMBER,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 x_return_status OUT NOCOPY VARCHAR2);
67 PROCEDURE get_clob_msg(p_msg_tab IN OKC_AQ_PVT.msg_tab_typ,
68 p_q_name IN VARCHAR2,
69 p_corrid IN VARCHAR2,
70 p_msg_clob OUT NOCOPY CLOB,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY VARCHAR2,
73 x_msg_data OUT NOCOPY VARCHAR2);
74 end OKC_AQ_WRITE_ERROR_PVT;