11: x_msg_data OUT NOCOPY VARCHAR2,
12: p_chr_id IN Varchar2,
13: x_sc_rg_tbl OUT NOCOPY sc_rg_tbl_type) is
14: l_api_name CONSTANT VARCHAR2(30) := 'GET_SUBCLASS_RGS';
15: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
16: Begin
17: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
18: G_PKG_NAME,
19: p_init_msg_list,
13: x_sc_rg_tbl OUT NOCOPY sc_rg_tbl_type) is
14: l_api_name CONSTANT VARCHAR2(30) := 'GET_SUBCLASS_RGS';
15: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
16: Begin
17: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
18: G_PKG_NAME,
19: p_init_msg_list,
20: G_API_VERSION,
21: p_api_version,
21: p_api_version,
22: G_SCOPE,
23: x_return_status);
24:
25: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
28: RAISE OKL_API.G_EXCEPTION_ERROR;
29: END IF;
22: G_SCOPE,
23: x_return_status);
24:
25: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
28: RAISE OKL_API.G_EXCEPTION_ERROR;
29: END IF;
30: x_return_status := l_return_status;
23: x_return_status);
24:
25: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
28: RAISE OKL_API.G_EXCEPTION_ERROR;
29: END IF;
30: x_return_status := l_return_status;
31: OKL_RULE_EXTRACT_PVT.Get_subclass_Rgs (p_api_version => p_api_version,
24:
25: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
28: RAISE OKL_API.G_EXCEPTION_ERROR;
29: END IF;
30: x_return_status := l_return_status;
31: OKL_RULE_EXTRACT_PVT.Get_subclass_Rgs (p_api_version => p_api_version,
32: p_init_msg_list => p_init_msg_list,
34: x_msg_count => x_msg_count,
35: x_msg_data => x_msg_data,
36: p_chr_id => p_chr_id,
37: x_sc_rg_tbl => x_sc_rg_tbl);
38: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: END IF;
35: x_msg_data => x_msg_data,
36: p_chr_id => p_chr_id,
37: x_sc_rg_tbl => x_sc_rg_tbl);
38: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: END IF;
43: --Call End Activity
36: p_chr_id => p_chr_id,
37: x_sc_rg_tbl => x_sc_rg_tbl);
38: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: END IF;
43: --Call End Activity
44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
37: x_sc_rg_tbl => x_sc_rg_tbl);
38: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: END IF;
43: --Call End Activity
44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);
40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: END IF;
43: --Call End Activity
44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);
46: EXCEPTION
47: WHEN OKL_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKL_API.HANDLE_EXCEPTIONS
43: --Call End Activity
44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);
46: EXCEPTION
47: WHEN OKL_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKL_API.HANDLE_EXCEPTIONS
49: (substr(l_api_name,1,26),
50: G_PKG_NAME,
51: 'OKL_API.G_RET_STS_ERROR',
44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);
46: EXCEPTION
47: WHEN OKL_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKL_API.HANDLE_EXCEPTIONS
49: (substr(l_api_name,1,26),
50: G_PKG_NAME,
51: 'OKL_API.G_RET_STS_ERROR',
52: x_msg_count,
47: WHEN OKL_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKL_API.HANDLE_EXCEPTIONS
49: (substr(l_api_name,1,26),
50: G_PKG_NAME,
51: 'OKL_API.G_RET_STS_ERROR',
52: x_msg_count,
53: x_msg_data,
54: G_SCOPE);
55:
52: x_msg_count,
53: x_msg_data,
54: G_SCOPE);
55:
56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: x_return_status := OKL_API.HANDLE_EXCEPTIONS
58: (substr(l_api_name,1,26),
59: G_PKG_NAME,
60: 'OKL_API.G_RET_STS_UNEXP_ERROR',
53: x_msg_data,
54: G_SCOPE);
55:
56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: x_return_status := OKL_API.HANDLE_EXCEPTIONS
58: (substr(l_api_name,1,26),
59: G_PKG_NAME,
60: 'OKL_API.G_RET_STS_UNEXP_ERROR',
61: x_msg_count,
56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: x_return_status := OKL_API.HANDLE_EXCEPTIONS
58: (substr(l_api_name,1,26),
59: G_PKG_NAME,
60: 'OKL_API.G_RET_STS_UNEXP_ERROR',
61: x_msg_count,
62: x_msg_data,
63: G_SCOPE);
64:
63: G_SCOPE);
64:
65: WHEN OTHERS THEN
66: -- store SQL error message on message stack for caller
67: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
68: x_return_status := OKL_API.HANDLE_EXCEPTIONS
69: (substr(l_api_name,1,26),
70: G_PKG_NAME,
71: 'OTHERS',
64:
65: WHEN OTHERS THEN
66: -- store SQL error message on message stack for caller
67: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
68: x_return_status := OKL_API.HANDLE_EXCEPTIONS
69: (substr(l_api_name,1,26),
70: G_PKG_NAME,
71: 'OTHERS',
72: x_msg_count,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_rgd_code IN Varchar2,
86: x_rg_rules_tbl OUT NOCOPY rg_rules_tbl_type) Is
87: l_api_name CONSTANT VARCHAR2(30) := 'GET_RG_RULES';
88: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
89: BEGIN
90: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
91: G_PKG_NAME,
92: p_init_msg_list,
86: x_rg_rules_tbl OUT NOCOPY rg_rules_tbl_type) Is
87: l_api_name CONSTANT VARCHAR2(30) := 'GET_RG_RULES';
88: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
89: BEGIN
90: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
91: G_PKG_NAME,
92: p_init_msg_list,
93: G_API_VERSION,
94: p_api_version,
94: p_api_version,
95: G_SCOPE,
96: x_return_status);
97:
98: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_ERROR;
102: END IF;
95: G_SCOPE,
96: x_return_status);
97:
98: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_ERROR;
102: END IF;
103: x_return_status := l_return_status;
96: x_return_status);
97:
98: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_ERROR;
102: END IF;
103: x_return_status := l_return_status;
104: OKL_RULE_EXTRACT_PVT.Get_Rg_Rules (p_api_version => p_api_version,
97:
98: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_ERROR;
102: END IF;
103: x_return_status := l_return_status;
104: OKL_RULE_EXTRACT_PVT.Get_Rg_Rules (p_api_version => p_api_version,
105: p_init_msg_list => p_init_msg_list,
107: x_msg_count => x_msg_count,
108: x_msg_data => x_msg_data,
109: p_rgd_code => p_rgd_code,
110: x_rg_rules_tbl => x_rg_rules_tbl);
111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
108: x_msg_data => x_msg_data,
109: p_rgd_code => p_rgd_code,
110: x_rg_rules_tbl => x_rg_rules_tbl);
111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: --Call End Activity
109: p_rgd_code => p_rgd_code,
110: x_rg_rules_tbl => x_rg_rules_tbl);
111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: --Call End Activity
117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
110: x_rg_rules_tbl => x_rg_rules_tbl);
111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: --Call End Activity
117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data);
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: --Call End Activity
117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data);
119: EXCEPTION
120: WHEN OKL_API.G_EXCEPTION_ERROR THEN
121: x_return_status := OKL_API.HANDLE_EXCEPTIONS
116: --Call End Activity
117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data);
119: EXCEPTION
120: WHEN OKL_API.G_EXCEPTION_ERROR THEN
121: x_return_status := OKL_API.HANDLE_EXCEPTIONS
122: (substr(l_api_name,1,26),
123: G_PKG_NAME,
124: 'OKL_API.G_RET_STS_ERROR',
117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data);
119: EXCEPTION
120: WHEN OKL_API.G_EXCEPTION_ERROR THEN
121: x_return_status := OKL_API.HANDLE_EXCEPTIONS
122: (substr(l_api_name,1,26),
123: G_PKG_NAME,
124: 'OKL_API.G_RET_STS_ERROR',
125: x_msg_count,
120: WHEN OKL_API.G_EXCEPTION_ERROR THEN
121: x_return_status := OKL_API.HANDLE_EXCEPTIONS
122: (substr(l_api_name,1,26),
123: G_PKG_NAME,
124: 'OKL_API.G_RET_STS_ERROR',
125: x_msg_count,
126: x_msg_data,
127: G_SCOPE);
128:
125: x_msg_count,
126: x_msg_data,
127: G_SCOPE);
128:
129: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
130: x_return_status := OKL_API.HANDLE_EXCEPTIONS
131: (substr(l_api_name,1,26),
132: G_PKG_NAME,
133: 'OKL_API.G_RET_STS_UNEXP_ERROR',
126: x_msg_data,
127: G_SCOPE);
128:
129: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
130: x_return_status := OKL_API.HANDLE_EXCEPTIONS
131: (substr(l_api_name,1,26),
132: G_PKG_NAME,
133: 'OKL_API.G_RET_STS_UNEXP_ERROR',
134: x_msg_count,
129: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
130: x_return_status := OKL_API.HANDLE_EXCEPTIONS
131: (substr(l_api_name,1,26),
132: G_PKG_NAME,
133: 'OKL_API.G_RET_STS_UNEXP_ERROR',
134: x_msg_count,
135: x_msg_data,
136: G_SCOPE);
137:
136: G_SCOPE);
137:
138: WHEN OTHERS THEN
139: -- store SQL error message on message stack for caller
140: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
142: (substr(l_api_name,1,26),
143: G_PKG_NAME,
144: 'OTHERS',
137:
138: WHEN OTHERS THEN
139: -- store SQL error message on message stack for caller
140: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
142: (substr(l_api_name,1,26),
143: G_PKG_NAME,
144: 'OTHERS',
145: x_msg_count,
159: p_rgs_code IN VARCHAR2,
160: p_buy_or_sell IN VARCHAR2,
161: x_rule_segment_tbl OUT NOCOPY rule_segment_tbl_type) IS
162: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';
163: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
164: BEGIN
165: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
166: G_PKG_NAME,
167: p_init_msg_list,
161: x_rule_segment_tbl OUT NOCOPY rule_segment_tbl_type) IS
162: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';
163: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
164: BEGIN
165: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
166: G_PKG_NAME,
167: p_init_msg_list,
168: G_API_VERSION,
169: p_api_version,
169: p_api_version,
170: G_SCOPE,
171: x_return_status);
172:
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;
170: G_SCOPE,
171: x_return_status);
172:
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;
178: x_return_status := l_return_status;
171: x_return_status);
172:
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;
178: x_return_status := l_return_status;
179: OKL_RULE_EXTRACT_PVT.Get_Rule_Def (p_api_version => p_api_version,
172:
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;
178: x_return_status := l_return_status;
179: OKL_RULE_EXTRACT_PVT.Get_Rule_Def (p_api_version => p_api_version,
180: p_init_msg_list => p_init_msg_list,
184: p_rgd_code => p_rgd_code,
185: p_rgs_code => p_rgs_code,
186: p_buy_or_sell => p_buy_or_sell,
187: x_rule_segment_tbl => x_rule_segment_tbl);
188: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
191: RAISE OKL_API.G_EXCEPTION_ERROR;
192: END IF;
185: p_rgs_code => p_rgs_code,
186: p_buy_or_sell => p_buy_or_sell,
187: x_rule_segment_tbl => x_rule_segment_tbl);
188: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
191: RAISE OKL_API.G_EXCEPTION_ERROR;
192: END IF;
193: --Call End Activity
186: p_buy_or_sell => p_buy_or_sell,
187: x_rule_segment_tbl => x_rule_segment_tbl);
188: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
191: RAISE OKL_API.G_EXCEPTION_ERROR;
192: END IF;
193: --Call End Activity
194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
187: x_rule_segment_tbl => x_rule_segment_tbl);
188: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
191: RAISE OKL_API.G_EXCEPTION_ERROR;
192: END IF;
193: --Call End Activity
194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data);
190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
191: RAISE OKL_API.G_EXCEPTION_ERROR;
192: END IF;
193: --Call End Activity
194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data);
196: EXCEPTION
197: WHEN OKL_API.G_EXCEPTION_ERROR THEN
198: x_return_status := OKL_API.HANDLE_EXCEPTIONS
193: --Call End Activity
194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data);
196: EXCEPTION
197: WHEN OKL_API.G_EXCEPTION_ERROR THEN
198: x_return_status := OKL_API.HANDLE_EXCEPTIONS
199: (substr(l_api_name,1,26),
200: G_PKG_NAME,
201: 'OKL_API.G_RET_STS_ERROR',
194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data);
196: EXCEPTION
197: WHEN OKL_API.G_EXCEPTION_ERROR THEN
198: x_return_status := OKL_API.HANDLE_EXCEPTIONS
199: (substr(l_api_name,1,26),
200: G_PKG_NAME,
201: 'OKL_API.G_RET_STS_ERROR',
202: x_msg_count,
197: WHEN OKL_API.G_EXCEPTION_ERROR THEN
198: x_return_status := OKL_API.HANDLE_EXCEPTIONS
199: (substr(l_api_name,1,26),
200: G_PKG_NAME,
201: 'OKL_API.G_RET_STS_ERROR',
202: x_msg_count,
203: x_msg_data,
204: G_SCOPE);
205:
202: x_msg_count,
203: x_msg_data,
204: G_SCOPE);
205:
206: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS
208: (substr(l_api_name,1,26),
209: G_PKG_NAME,
210: 'OKL_API.G_RET_STS_UNEXP_ERROR',
203: x_msg_data,
204: G_SCOPE);
205:
206: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS
208: (substr(l_api_name,1,26),
209: G_PKG_NAME,
210: 'OKL_API.G_RET_STS_UNEXP_ERROR',
211: x_msg_count,
206: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS
208: (substr(l_api_name,1,26),
209: G_PKG_NAME,
210: 'OKL_API.G_RET_STS_UNEXP_ERROR',
211: x_msg_count,
212: x_msg_data,
213: G_SCOPE);
214:
213: G_SCOPE);
214:
215: WHEN OTHERS THEN
216: -- store SQL error message on message stack for caller
217: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
219: (substr(l_api_name,1,26),
220: G_PKG_NAME,
221: 'OTHERS',
214:
215: WHEN OTHERS THEN
216: -- store SQL error message on message stack for caller
217: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
219: (substr(l_api_name,1,26),
220: G_PKG_NAME,
221: 'OTHERS',
222: x_msg_count,
246: p_entity_column IN VARCHAR2,
247: x_rule_segment_tbl OUT NOCOPY rule_segment_tbl_type2) IS
248:
249: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';
250: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
251: BEGIN
252: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
253: G_PKG_NAME,
254: p_init_msg_list,
248:
249: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';
250: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
251: BEGIN
252: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
253: G_PKG_NAME,
254: p_init_msg_list,
255: G_API_VERSION,
256: p_api_version,
256: p_api_version,
257: G_SCOPE,
258: x_return_status);
259:
260: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_ERROR;
264: END IF;
257: G_SCOPE,
258: x_return_status);
259:
260: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_ERROR;
264: END IF;
265: x_return_status := l_return_status;
258: x_return_status);
259:
260: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_ERROR;
264: END IF;
265: x_return_status := l_return_status;
266: OKL_RULE_EXTRACT_PVT.Get_Rules_Metadata (
259:
260: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_ERROR;
264: END IF;
265: x_return_status := l_return_status;
266: OKL_RULE_EXTRACT_PVT.Get_Rules_Metadata (
267: p_api_version => p_api_version,
278: p_template_table => p_template_table,
279: p_rule_id_column => p_rule_id_column,
280: p_entity_column => p_entity_column,
281: x_rule_segment_tbl => x_rule_segment_tbl);
282: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
279: p_rule_id_column => p_rule_id_column,
280: p_entity_column => p_entity_column,
281: x_rule_segment_tbl => x_rule_segment_tbl);
282: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287: --Call End Activity
280: p_entity_column => p_entity_column,
281: x_rule_segment_tbl => x_rule_segment_tbl);
282: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287: --Call End Activity
288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
281: x_rule_segment_tbl => x_rule_segment_tbl);
282: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287: --Call End Activity
288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data);
284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287: --Call End Activity
288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data);
290: EXCEPTION
291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
287: --Call End Activity
288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data);
290: EXCEPTION
291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
293: (substr(l_api_name,1,26),
294: G_PKG_NAME,
295: 'OKL_API.G_RET_STS_ERROR',
288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data);
290: EXCEPTION
291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
293: (substr(l_api_name,1,26),
294: G_PKG_NAME,
295: 'OKL_API.G_RET_STS_ERROR',
296: x_msg_count,
291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
293: (substr(l_api_name,1,26),
294: G_PKG_NAME,
295: 'OKL_API.G_RET_STS_ERROR',
296: x_msg_count,
297: x_msg_data,
298: G_SCOPE);
299:
296: x_msg_count,
297: x_msg_data,
298: G_SCOPE);
299:
300: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
302: (substr(l_api_name,1,26),
303: G_PKG_NAME,
304: 'OKL_API.G_RET_STS_UNEXP_ERROR',
297: x_msg_data,
298: G_SCOPE);
299:
300: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
302: (substr(l_api_name,1,26),
303: G_PKG_NAME,
304: 'OKL_API.G_RET_STS_UNEXP_ERROR',
305: x_msg_count,
300: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
302: (substr(l_api_name,1,26),
303: G_PKG_NAME,
304: 'OKL_API.G_RET_STS_UNEXP_ERROR',
305: x_msg_count,
306: x_msg_data,
307: G_SCOPE);
308:
307: G_SCOPE);
308:
309: WHEN OTHERS THEN
310: -- store SQL error message on message stack for caller
311: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
312: x_return_status := OKL_API.HANDLE_EXCEPTIONS
313: (substr(l_api_name,1,26),
314: G_PKG_NAME,
315: 'OTHERS',
308:
309: WHEN OTHERS THEN
310: -- store SQL error message on message stack for caller
311: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
312: x_return_status := OKL_API.HANDLE_EXCEPTIONS
313: (substr(l_api_name,1,26),
314: G_PKG_NAME,
315: 'OTHERS',
316: x_msg_count,