eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VALIDATION_SET_PVT dependencies on OKL_API

Line 13: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

9: WHERE validation_set_name = p_vlsv_rec.validation_set_name
10: AND org_id = mo_global.get_current_org_id();
11:
12: l_dummy_var varchar2(1) := '?';
13: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
14: x_return_status varchar2(1) := okl_api.g_ret_sts_success;
15: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_header';
16:
17: BEGIN

Line 14: x_return_status varchar2(1) := okl_api.g_ret_sts_success;

10: AND org_id = mo_global.get_current_org_id();
11:
12: l_dummy_var varchar2(1) := '?';
13: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
14: x_return_status varchar2(1) := okl_api.g_ret_sts_success;
15: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_header';
16:
17: BEGIN
18: IF p_vlsv_rec.effective_from > p_vlsv_rec.effective_to THEN

Line 20: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

16:
17: BEGIN
18: IF p_vlsv_rec.effective_from > p_vlsv_rec.effective_to THEN
19:
20: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
21: p_msg_name => 'OKL_INVALID_VALID_TO');
22:
23: RAISE OKL_API.G_EXCEPTION_ERROR;
24: END IF;

Line 23: RAISE OKL_API.G_EXCEPTION_ERROR;

19:
20: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
21: p_msg_name => 'OKL_INVALID_VALID_TO');
22:
23: RAISE OKL_API.G_EXCEPTION_ERROR;
24: END IF;
25: --name,vls_ac_flag combination should be unique
26: OPEN l_vls_csr;
27: FETCH l_vls_csr INTO l_dummy_var ;

Line 31: okl_api.set_message(p_app_name => g_app_name

27: FETCH l_vls_csr INTO l_dummy_var ;
28: CLOSE l_vls_csr; -- if l_dummy_var is 'x' then name already exists
29:
30: IF (l_dummy_var = 'x') THEN
31: okl_api.set_message(p_app_name => g_app_name
32: ,p_msg_name => 'OKL_DUPLICATE_NAME'
33: ,p_token1 => 'NAME'
34: ,p_token1_value => p_vlsv_rec.validation_set_name);
35: RAISE okl_api.g_exception_error;

Line 35: RAISE okl_api.g_exception_error;

31: okl_api.set_message(p_app_name => g_app_name
32: ,p_msg_name => 'OKL_DUPLICATE_NAME'
33: ,p_token1 => 'NAME'
34: ,p_token1_value => p_vlsv_rec.validation_set_name);
35: RAISE okl_api.g_exception_error;
36: END IF; --if value type=range data type should not be varchar2
37:
38: RETURN(x_return_status);
39: EXCEPTION

Line 40: WHEN okl_api.g_exception_error THEN

36: END IF; --if value type=range data type should not be varchar2
37:
38: RETURN(x_return_status);
39: EXCEPTION
40: WHEN okl_api.g_exception_error THEN
41: RETURN okl_api.g_ret_sts_error;
42: WHEN okl_api.g_exception_unexpected_error THEN
43: RETURN okl_api.g_ret_sts_unexp_error;
44: WHEN OTHERS THEN

Line 41: RETURN okl_api.g_ret_sts_error;

37:
38: RETURN(x_return_status);
39: EXCEPTION
40: WHEN okl_api.g_exception_error THEN
41: RETURN okl_api.g_ret_sts_error;
42: WHEN okl_api.g_exception_unexpected_error THEN
43: RETURN okl_api.g_ret_sts_unexp_error;
44: WHEN OTHERS THEN
45: RETURN okl_api.g_ret_sts_unexp_error;

Line 42: WHEN okl_api.g_exception_unexpected_error THEN

38: RETURN(x_return_status);
39: EXCEPTION
40: WHEN okl_api.g_exception_error THEN
41: RETURN okl_api.g_ret_sts_error;
42: WHEN okl_api.g_exception_unexpected_error THEN
43: RETURN okl_api.g_ret_sts_unexp_error;
44: WHEN OTHERS THEN
45: RETURN okl_api.g_ret_sts_unexp_error;
46: END validate_header;

Line 43: RETURN okl_api.g_ret_sts_unexp_error;

39: EXCEPTION
40: WHEN okl_api.g_exception_error THEN
41: RETURN okl_api.g_ret_sts_error;
42: WHEN okl_api.g_exception_unexpected_error THEN
43: RETURN okl_api.g_ret_sts_unexp_error;
44: WHEN OTHERS THEN
45: RETURN okl_api.g_ret_sts_unexp_error;
46: END validate_header;
47:

Line 45: RETURN okl_api.g_ret_sts_unexp_error;

41: RETURN okl_api.g_ret_sts_error;
42: WHEN okl_api.g_exception_unexpected_error THEN
43: RETURN okl_api.g_ret_sts_unexp_error;
44: WHEN OTHERS THEN
45: RETURN okl_api.g_ret_sts_unexp_error;
46: END validate_header;
47:
48: FUNCTION validate_duplicates(p_vldv_tbl IN vldv_tbl_type) RETURN varchar2 IS
49:

Line 53: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

49:
50: lp_vldv_tbl1 vldv_tbl_type;
51: lp_vldv_tbl2 vldv_tbl_type;
52: l_dummy_var varchar2(1) := '?';
53: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
54: x_return_status varchar2(1) := okl_api.g_ret_sts_success;
55: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_duplicate';
56: i INTEGER:=1;
57: j INTEGER:=1;

Line 54: x_return_status varchar2(1) := okl_api.g_ret_sts_success;

50: lp_vldv_tbl1 vldv_tbl_type;
51: lp_vldv_tbl2 vldv_tbl_type;
52: l_dummy_var varchar2(1) := '?';
53: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
54: x_return_status varchar2(1) := okl_api.g_ret_sts_success;
55: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_duplicate';
56: i INTEGER:=1;
57: j INTEGER:=1;
58: breakLoop boolean:=false;

Line 79: okl_api.set_message(p_app_name => g_app_name

75:
76: -- if l_dummy_var is 'x' then name already exists
77:
78: IF (l_dummy_var = 'x') THEN
79: okl_api.set_message(p_app_name => g_app_name
80: ,p_msg_name => 'OKL_DUPLICATE_VALIDATION'
81: ,p_token1 => 'NAME'
82: ,p_token1_value => lp_vldv_tbl2(j).description);
83: RAISE okl_api.g_exception_error;

Line 83: RAISE okl_api.g_exception_error;

79: okl_api.set_message(p_app_name => g_app_name
80: ,p_msg_name => 'OKL_DUPLICATE_VALIDATION'
81: ,p_token1 => 'NAME'
82: ,p_token1_value => lp_vldv_tbl2(j).description);
83: RAISE okl_api.g_exception_error;
84: END IF; --if value type=range data type should not be varchar2
85: RETURN(x_return_status);
86: EXCEPTION
87: WHEN okl_api.g_exception_error THEN

Line 87: WHEN okl_api.g_exception_error THEN

83: RAISE okl_api.g_exception_error;
84: END IF; --if value type=range data type should not be varchar2
85: RETURN(x_return_status);
86: EXCEPTION
87: WHEN okl_api.g_exception_error THEN
88: RETURN okl_api.g_ret_sts_error;
89: WHEN okl_api.g_exception_unexpected_error THEN
90: RETURN okl_api.g_ret_sts_unexp_error;
91: WHEN OTHERS THEN

Line 88: RETURN okl_api.g_ret_sts_error;

84: END IF; --if value type=range data type should not be varchar2
85: RETURN(x_return_status);
86: EXCEPTION
87: WHEN okl_api.g_exception_error THEN
88: RETURN okl_api.g_ret_sts_error;
89: WHEN okl_api.g_exception_unexpected_error THEN
90: RETURN okl_api.g_ret_sts_unexp_error;
91: WHEN OTHERS THEN
92: RETURN okl_api.g_ret_sts_unexp_error;

Line 89: WHEN okl_api.g_exception_unexpected_error THEN

85: RETURN(x_return_status);
86: EXCEPTION
87: WHEN okl_api.g_exception_error THEN
88: RETURN okl_api.g_ret_sts_error;
89: WHEN okl_api.g_exception_unexpected_error THEN
90: RETURN okl_api.g_ret_sts_unexp_error;
91: WHEN OTHERS THEN
92: RETURN okl_api.g_ret_sts_unexp_error;
93: END validate_duplicates;

Line 90: RETURN okl_api.g_ret_sts_unexp_error;

86: EXCEPTION
87: WHEN okl_api.g_exception_error THEN
88: RETURN okl_api.g_ret_sts_error;
89: WHEN okl_api.g_exception_unexpected_error THEN
90: RETURN okl_api.g_ret_sts_unexp_error;
91: WHEN OTHERS THEN
92: RETURN okl_api.g_ret_sts_unexp_error;
93: END validate_duplicates;
94:

Line 92: RETURN okl_api.g_ret_sts_unexp_error;

88: RETURN okl_api.g_ret_sts_error;
89: WHEN okl_api.g_exception_unexpected_error THEN
90: RETURN okl_api.g_ret_sts_unexp_error;
91: WHEN OTHERS THEN
92: RETURN okl_api.g_ret_sts_unexp_error;
93: END validate_duplicates;
94:
95: PROCEDURE create_vls(p_api_version IN number
96: ,p_init_msg_list IN varchar2

Line 115: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

111: is_debug_procedure_on boolean;
112: is_debug_statement_on boolean;
113: l_api_name CONSTANT varchar2(30) := 'create_vls';
114: l_api_version CONSTANT number := 1.0;
115: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
116:
117: BEGIN
118:
119: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 135: l_return_status := okl_api.start_activity(p_api_name=>l_api_name

131:
132: -- call START_ACTIVITY to create savepoint, check compatibility
133: -- and initialize message list
134:
135: l_return_status := okl_api.start_activity(p_api_name=>l_api_name
136: ,p_pkg_name=>G_PKG_NAME
137: ,p_init_msg_list=>p_init_msg_list
138: ,l_api_version=>l_api_version
139: ,p_api_version=>p_api_version

Line 143: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

139: ,p_api_version=>p_api_version
140: ,p_api_type=>G_API_TYPE
141: ,x_return_status=>x_return_status); -- check if activity started successfully
142:
143: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
144: RAISE okl_api.g_exception_unexpected_error;
145: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
146: RAISE okl_api.g_exception_error;
147: END IF;

Line 144: RAISE okl_api.g_exception_unexpected_error;

140: ,p_api_type=>G_API_TYPE
141: ,x_return_status=>x_return_status); -- check if activity started successfully
142:
143: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
144: RAISE okl_api.g_exception_unexpected_error;
145: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
146: RAISE okl_api.g_exception_error;
147: END IF;
148: lp_vlsv_rec := p_vlsv_rec;

Line 145: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

141: ,x_return_status=>x_return_status); -- check if activity started successfully
142:
143: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
144: RAISE okl_api.g_exception_unexpected_error;
145: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
146: RAISE okl_api.g_exception_error;
147: END IF;
148: lp_vlsv_rec := p_vlsv_rec;
149: lp_vldv_tbl := p_vldv_tbl; --validate header

Line 146: RAISE okl_api.g_exception_error;

142:
143: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
144: RAISE okl_api.g_exception_unexpected_error;
145: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
146: RAISE okl_api.g_exception_error;
147: END IF;
148: lp_vlsv_rec := p_vlsv_rec;
149: lp_vldv_tbl := p_vldv_tbl; --validate header
150: l_return_status := validate_header(lp_vlsv_rec); -- write to log

Line 159: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

155: ,'Function okl_ecc_def_pvt.validate_header returned with status ' ||
156: l_return_status);
157: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
158:
159: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
160: RAISE okl_api.g_exception_unexpected_error;
161: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
162: RAISE okl_api.g_exception_error;
163: END IF;

Line 160: RAISE okl_api.g_exception_unexpected_error;

156: l_return_status);
157: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
158:
159: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
160: RAISE okl_api.g_exception_unexpected_error;
161: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
162: RAISE okl_api.g_exception_error;
163: END IF;
164:

Line 161: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

157: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
158:
159: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
160: RAISE okl_api.g_exception_unexpected_error;
161: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
162: RAISE okl_api.g_exception_error;
163: END IF;
164:
165: l_return_status := validate_duplicates(lp_vldv_tbl); -- write to log

Line 162: RAISE okl_api.g_exception_error;

158:
159: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
160: RAISE okl_api.g_exception_unexpected_error;
161: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
162: RAISE okl_api.g_exception_error;
163: END IF;
164:
165: l_return_status := validate_duplicates(lp_vldv_tbl); -- write to log
166:

Line 174: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

170: ,'Function okl_ecc_def_pvt.validate_duplicates returned with status ' ||
171: l_return_status);
172: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
173:
174: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
175: RAISE okl_api.g_exception_unexpected_error;
176: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
177: RAISE okl_api.g_exception_error;
178: END IF;

Line 175: RAISE okl_api.g_exception_unexpected_error;

171: l_return_status);
172: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
173:
174: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
175: RAISE okl_api.g_exception_unexpected_error;
176: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
177: RAISE okl_api.g_exception_error;
178: END IF;
179:

Line 176: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

172: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
173:
174: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
175: RAISE okl_api.g_exception_unexpected_error;
176: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
177: RAISE okl_api.g_exception_error;
178: END IF;
179:
180: okl_vls_pvt.insert_row(p_api_version

Line 177: RAISE okl_api.g_exception_error;

173:
174: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
175: RAISE okl_api.g_exception_unexpected_error;
176: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
177: RAISE okl_api.g_exception_error;
178: END IF;
179:
180: okl_vls_pvt.insert_row(p_api_version
181: ,okl_api.g_false

Line 181: ,okl_api.g_false

177: RAISE okl_api.g_exception_error;
178: END IF;
179:
180: okl_vls_pvt.insert_row(p_api_version
181: ,okl_api.g_false
182: ,l_return_status
183: ,x_msg_count
184: ,x_msg_data
185: ,lp_vlsv_rec

Line 197: IF (l_return_status = okl_api.g_ret_sts_error) THEN

193: ' x_msg_data ' ||
194: x_msg_data);
195: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
196:
197: IF (l_return_status = okl_api.g_ret_sts_error) THEN
198: RAISE okl_api.g_exception_error;
199: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
200: RAISE okl_api.g_exception_unexpected_error;
201: END IF; --Copy value of OUT variable in the IN rvldrd type

Line 198: RAISE okl_api.g_exception_error;

194: x_msg_data);
195: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
196:
197: IF (l_return_status = okl_api.g_ret_sts_error) THEN
198: RAISE okl_api.g_exception_error;
199: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
200: RAISE okl_api.g_exception_unexpected_error;
201: END IF; --Copy value of OUT variable in the IN rvldrd type
202:

Line 199: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

195: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
196:
197: IF (l_return_status = okl_api.g_ret_sts_error) THEN
198: RAISE okl_api.g_exception_error;
199: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
200: RAISE okl_api.g_exception_unexpected_error;
201: END IF; --Copy value of OUT variable in the IN rvldrd type
202:
203: lp_vlsv_rec := lx_vlsv_rec;

Line 200: RAISE okl_api.g_exception_unexpected_error;

196:
197: IF (l_return_status = okl_api.g_ret_sts_error) THEN
198: RAISE okl_api.g_exception_error;
199: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
200: RAISE okl_api.g_exception_unexpected_error;
201: END IF; --Copy value of OUT variable in the IN rvldrd type
202:
203: lp_vlsv_rec := lx_vlsv_rec;
204:

Line 211: ,okl_api.g_false

207: FOR i IN lp_vldv_tbl.FIRST..lp_vldv_tbl.LAST LOOP
208: lp_vldv_tbl(i).validation_set_id := lp_vlsv_rec.id;
209: END LOOP;
210: okl_vld_pvt.insert_row(p_api_version
211: ,okl_api.g_false
212: ,l_return_status
213: ,x_msg_count
214: ,x_msg_data
215: ,lp_vldv_tbl

Line 226: IF (l_return_status = okl_api.g_ret_sts_error) THEN

222: l_return_status ||
223: ' x_msg_data ' ||
224: x_msg_data);
225: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
226: IF (l_return_status = okl_api.g_ret_sts_error) THEN
227: RAISE okl_api.g_exception_error;
228: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
229: RAISE okl_api.g_exception_unexpected_error;
230: END IF;

Line 227: RAISE okl_api.g_exception_error;

223: ' x_msg_data ' ||
224: x_msg_data);
225: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
226: IF (l_return_status = okl_api.g_ret_sts_error) THEN
227: RAISE okl_api.g_exception_error;
228: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
229: RAISE okl_api.g_exception_unexpected_error;
230: END IF;
231: END IF; --Assign value to OUT variables

Line 228: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

224: x_msg_data);
225: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
226: IF (l_return_status = okl_api.g_ret_sts_error) THEN
227: RAISE okl_api.g_exception_error;
228: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
229: RAISE okl_api.g_exception_unexpected_error;
230: END IF;
231: END IF; --Assign value to OUT variables
232: x_vlsv_rec := lx_vlsv_rec;

Line 229: RAISE okl_api.g_exception_unexpected_error;

225: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
226: IF (l_return_status = okl_api.g_ret_sts_error) THEN
227: RAISE okl_api.g_exception_error;
228: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
229: RAISE okl_api.g_exception_unexpected_error;
230: END IF;
231: END IF; --Assign value to OUT variables
232: x_vlsv_rec := lx_vlsv_rec;
233: x_vldv_tbl := lx_vldv_tbl;

Line 235: okl_api.end_activity(x_msg_count => x_msg_count

231: END IF; --Assign value to OUT variables
232: x_vlsv_rec := lx_vlsv_rec;
233: x_vldv_tbl := lx_vldv_tbl;
234: x_return_status := l_return_status;
235: okl_api.end_activity(x_msg_count => x_msg_count
236: ,x_msg_data => x_msg_data);
237:
238: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
239: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 245: WHEN okl_api.g_exception_error THEN

241: ,'end debug OKL_VALIDATION_SET_PVT.pls call create_vls');
242: END IF;
243:
244: EXCEPTION
245: WHEN okl_api.g_exception_error THEN
246:
247: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
248: ,p_pkg_name => G_PKG_NAME
249: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

Line 247: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

243:
244: EXCEPTION
245: WHEN okl_api.g_exception_error THEN
246:
247: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
248: ,p_pkg_name => G_PKG_NAME
249: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
250: ,x_msg_count => x_msg_count
251: ,x_msg_data => x_msg_data

Line 249: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

245: WHEN okl_api.g_exception_error THEN
246:
247: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
248: ,p_pkg_name => G_PKG_NAME
249: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
250: ,x_msg_count => x_msg_count
251: ,x_msg_data => x_msg_data
252: ,p_api_type => G_API_TYPE);
253:

Line 254: WHEN okl_api.g_exception_unexpected_error THEN

250: ,x_msg_count => x_msg_count
251: ,x_msg_data => x_msg_data
252: ,p_api_type => G_API_TYPE);
253:
254: WHEN okl_api.g_exception_unexpected_error THEN
255:
256: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
257: ,p_pkg_name => G_PKG_NAME
258: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'

Line 256: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

252: ,p_api_type => G_API_TYPE);
253:
254: WHEN okl_api.g_exception_unexpected_error THEN
255:
256: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
257: ,p_pkg_name => G_PKG_NAME
258: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
259: ,x_msg_count => x_msg_count
260: ,x_msg_data => x_msg_data

Line 258: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'

254: WHEN okl_api.g_exception_unexpected_error THEN
255:
256: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
257: ,p_pkg_name => G_PKG_NAME
258: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
259: ,x_msg_count => x_msg_count
260: ,x_msg_data => x_msg_data
261: ,p_api_type => G_API_TYPE);
262:

Line 265: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

261: ,p_api_type => G_API_TYPE);
262:
263: WHEN OTHERS THEN
264:
265: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
266: ,p_pkg_name => G_PKG_NAME
267: ,p_exc_name => 'OTHERS'
268: ,x_msg_count => x_msg_count
269: ,x_msg_data => x_msg_data

Line 275: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

271:
272: END create_vls;
273:
274: PROCEDURE update_vls(p_api_version IN number
275: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
276: ,x_return_status OUT NOCOPY varchar2
277: ,x_msg_count OUT NOCOPY number
278: ,x_msg_data OUT NOCOPY varchar2
279: ,p_vlsv_rec IN vlsv_rec_type

Line 300: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

296: is_debug_procedure_on boolean;
297: is_debug_statement_on boolean;
298: l_api_name CONSTANT varchar2(30) := 'update_vls';
299: l_api_version CONSTANT number := 1.0;
300: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
301:
302: BEGIN
303: l_debug_enabled := okl_debug_pub.check_log_enabled;
304: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

Line 318: l_return_status := okl_api.start_activity(p_api_name => l_api_name

314:
315: -- call START_ACTIVITY to create savepoint, check compatibility
316: -- and initialize message list
317:
318: l_return_status := okl_api.start_activity(p_api_name => l_api_name
319: ,p_pkg_name => g_pkg_name
320: ,p_init_msg_list => p_init_msg_list
321: ,l_api_version => l_api_version
322: ,p_api_version => p_api_version

Line 326: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

322: ,p_api_version => p_api_version
323: ,p_api_type => g_api_type
324: ,x_return_status => x_return_status); -- check if activity started successfully
325:
326: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
327: RAISE okl_api.g_exception_unexpected_error;
328: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
329: RAISE okl_api.g_exception_error;
330: END IF;

Line 327: RAISE okl_api.g_exception_unexpected_error;

323: ,p_api_type => g_api_type
324: ,x_return_status => x_return_status); -- check if activity started successfully
325:
326: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
327: RAISE okl_api.g_exception_unexpected_error;
328: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
329: RAISE okl_api.g_exception_error;
330: END IF;
331: lp_vlsv_rec := p_vlsv_rec;

Line 328: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

324: ,x_return_status => x_return_status); -- check if activity started successfully
325:
326: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
327: RAISE okl_api.g_exception_unexpected_error;
328: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
329: RAISE okl_api.g_exception_error;
330: END IF;
331: lp_vlsv_rec := p_vlsv_rec;
332: lp_vldv_tbl := p_vldv_tbl;

Line 329: RAISE okl_api.g_exception_error;

325:
326: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
327: RAISE okl_api.g_exception_unexpected_error;
328: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
329: RAISE okl_api.g_exception_error;
330: END IF;
331: lp_vlsv_rec := p_vlsv_rec;
332: lp_vldv_tbl := p_vldv_tbl;
333:

Line 336: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

332: lp_vldv_tbl := p_vldv_tbl;
333:
334: IF lp_vlsv_rec.effective_from > lp_vlsv_rec.effective_to THEN
335:
336: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
337: p_msg_name => 'OKL_INVALID_VALID_TO');
338:
339: RAISE OKL_API.G_EXCEPTION_ERROR;
340: END IF;

Line 339: RAISE OKL_API.G_EXCEPTION_ERROR;

335:
336: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
337: p_msg_name => 'OKL_INVALID_VALID_TO');
338:
339: RAISE OKL_API.G_EXCEPTION_ERROR;
340: END IF;
341:
342: l_return_status :=validate_duplicates(lp_vldv_tbl); -- write to log
343:

Line 351: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

347: ,'Function okl_ecc_def_pvt.validate_header returned with status ' ||
348: l_return_status);
349: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
350:
351: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
352: RAISE okl_api.g_exception_unexpected_error;
353: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
354: RAISE okl_api.g_exception_error;
355: END IF;

Line 352: RAISE okl_api.g_exception_unexpected_error;

348: l_return_status);
349: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
350:
351: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
352: RAISE okl_api.g_exception_unexpected_error;
353: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
354: RAISE okl_api.g_exception_error;
355: END IF;
356: okl_vls_pvt.update_row(p_api_version

Line 353: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

349: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
350:
351: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
352: RAISE okl_api.g_exception_unexpected_error;
353: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
354: RAISE okl_api.g_exception_error;
355: END IF;
356: okl_vls_pvt.update_row(p_api_version
357: ,okl_api.g_false

Line 354: RAISE okl_api.g_exception_error;

350:
351: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
352: RAISE okl_api.g_exception_unexpected_error;
353: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
354: RAISE okl_api.g_exception_error;
355: END IF;
356: okl_vls_pvt.update_row(p_api_version
357: ,okl_api.g_false
358: ,l_return_status

Line 357: ,okl_api.g_false

353: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
354: RAISE okl_api.g_exception_error;
355: END IF;
356: okl_vls_pvt.update_row(p_api_version
357: ,okl_api.g_false
358: ,l_return_status
359: ,x_msg_count
360: ,x_msg_data
361: ,lp_vlsv_rec

Line 373: IF (l_return_status = okl_api.g_ret_sts_error) THEN

369: ' x_msg_data ' ||
370: x_msg_data);
371: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
372:
373: IF (l_return_status = okl_api.g_ret_sts_error) THEN
374: RAISE okl_api.g_exception_error;
375: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
376: RAISE okl_api.g_exception_unexpected_error;
377: END IF; --Copy value of OUT variable in the IN rvldrd type

Line 374: RAISE okl_api.g_exception_error;

370: x_msg_data);
371: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
372:
373: IF (l_return_status = okl_api.g_ret_sts_error) THEN
374: RAISE okl_api.g_exception_error;
375: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
376: RAISE okl_api.g_exception_unexpected_error;
377: END IF; --Copy value of OUT variable in the IN rvldrd type
378: lp_vlsv_rec := lx_vlsv_rec;

Line 375: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

371: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
372:
373: IF (l_return_status = okl_api.g_ret_sts_error) THEN
374: RAISE okl_api.g_exception_error;
375: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
376: RAISE okl_api.g_exception_unexpected_error;
377: END IF; --Copy value of OUT variable in the IN rvldrd type
378: lp_vlsv_rec := lx_vlsv_rec;
379: j := 1;

Line 376: RAISE okl_api.g_exception_unexpected_error;

372:
373: IF (l_return_status = okl_api.g_ret_sts_error) THEN
374: RAISE okl_api.g_exception_error;
375: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
376: RAISE okl_api.g_exception_unexpected_error;
377: END IF; --Copy value of OUT variable in the IN rvldrd type
378: lp_vlsv_rec := lx_vlsv_rec;
379: j := 1;
380: l := 1;

Line 403: ,okl_api.g_false

399: END LOOP;
400:
401: IF lp_vldv_crt_tbl.COUNT > 0 THEN
402: okl_vld_pvt.insert_row(p_api_version
403: ,okl_api.g_false
404: ,l_return_status
405: ,x_msg_count
406: ,x_msg_data
407: ,lp_vldv_crt_tbl

Line 417: IF (l_return_status = okl_api.g_ret_sts_error) THEN

413: l_return_status ||
414: ' x_msg_data ' ||
415: x_msg_data);
416: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
417: IF (l_return_status = okl_api.g_ret_sts_error) THEN
418: RAISE okl_api.g_exception_error;
419: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
420: RAISE okl_api.g_exception_unexpected_error;
421: END IF;

Line 418: RAISE okl_api.g_exception_error;

414: ' x_msg_data ' ||
415: x_msg_data);
416: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
417: IF (l_return_status = okl_api.g_ret_sts_error) THEN
418: RAISE okl_api.g_exception_error;
419: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
420: RAISE okl_api.g_exception_unexpected_error;
421: END IF;
422: END IF;

Line 419: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

415: x_msg_data);
416: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
417: IF (l_return_status = okl_api.g_ret_sts_error) THEN
418: RAISE okl_api.g_exception_error;
419: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
420: RAISE okl_api.g_exception_unexpected_error;
421: END IF;
422: END IF;
423: IF lp_vldv_rmv_tbl.COUNT > 0 THEN

Line 420: RAISE okl_api.g_exception_unexpected_error;

416: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
417: IF (l_return_status = okl_api.g_ret_sts_error) THEN
418: RAISE okl_api.g_exception_error;
419: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
420: RAISE okl_api.g_exception_unexpected_error;
421: END IF;
422: END IF;
423: IF lp_vldv_rmv_tbl.COUNT > 0 THEN
424: okl_vld_pvt.update_row(p_api_version

Line 425: ,okl_api.g_false

421: END IF;
422: END IF;
423: IF lp_vldv_rmv_tbl.COUNT > 0 THEN
424: okl_vld_pvt.update_row(p_api_version
425: ,okl_api.g_false
426: ,l_return_status
427: ,x_msg_count
428: ,x_msg_data
429: ,lp_vldv_rmv_tbl

Line 439: IF (l_return_status = okl_api.g_ret_sts_error) THEN

435: l_return_status ||
436: ' x_msg_data ' ||
437: x_msg_data);
438: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
439: IF (l_return_status = okl_api.g_ret_sts_error) THEN
440: RAISE okl_api.g_exception_error;
441: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
442: RAISE okl_api.g_exception_unexpected_error;
443: END IF;

Line 440: RAISE okl_api.g_exception_error;

436: ' x_msg_data ' ||
437: x_msg_data);
438: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
439: IF (l_return_status = okl_api.g_ret_sts_error) THEN
440: RAISE okl_api.g_exception_error;
441: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
442: RAISE okl_api.g_exception_unexpected_error;
443: END IF;
444: END IF;

Line 441: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

437: x_msg_data);
438: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
439: IF (l_return_status = okl_api.g_ret_sts_error) THEN
440: RAISE okl_api.g_exception_error;
441: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
442: RAISE okl_api.g_exception_unexpected_error;
443: END IF;
444: END IF;
445: END IF; --Assign value to OUT variables

Line 442: RAISE okl_api.g_exception_unexpected_error;

438: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
439: IF (l_return_status = okl_api.g_ret_sts_error) THEN
440: RAISE okl_api.g_exception_error;
441: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
442: RAISE okl_api.g_exception_unexpected_error;
443: END IF;
444: END IF;
445: END IF; --Assign value to OUT variables
446:

Line 450: okl_api.end_activity(x_msg_count => x_msg_count

446:
447: x_vlsv_rec := lx_vlsv_rec;
448: x_vldv_tbl := lx_vldv_crt_tbl;
449: x_return_status := l_return_status;
450: okl_api.end_activity(x_msg_count => x_msg_count
451: ,x_msg_data => x_msg_data);
452:
453: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
454: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 460: WHEN okl_api.g_exception_error THEN

456: ,'end debug OKLRvlsB.pls call update_vls');
457: END IF;
458:
459: EXCEPTION
460: WHEN okl_api.g_exception_error THEN
461: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
462: ,p_pkg_name => g_pkg_name
463: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
464: ,x_msg_count => x_msg_count

Line 461: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

457: END IF;
458:
459: EXCEPTION
460: WHEN okl_api.g_exception_error THEN
461: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
462: ,p_pkg_name => g_pkg_name
463: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
464: ,x_msg_count => x_msg_count
465: ,x_msg_data => x_msg_data

Line 463: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

459: EXCEPTION
460: WHEN okl_api.g_exception_error THEN
461: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
462: ,p_pkg_name => g_pkg_name
463: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
464: ,x_msg_count => x_msg_count
465: ,x_msg_data => x_msg_data
466: ,p_api_type => g_api_type);
467: WHEN okl_api.g_exception_unexpected_error THEN

Line 467: WHEN okl_api.g_exception_unexpected_error THEN

463: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
464: ,x_msg_count => x_msg_count
465: ,x_msg_data => x_msg_data
466: ,p_api_type => g_api_type);
467: WHEN okl_api.g_exception_unexpected_error THEN
468: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
469: ,p_pkg_name => g_pkg_name
470: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
471: ,x_msg_count => x_msg_count

Line 468: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

464: ,x_msg_count => x_msg_count
465: ,x_msg_data => x_msg_data
466: ,p_api_type => g_api_type);
467: WHEN okl_api.g_exception_unexpected_error THEN
468: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
469: ,p_pkg_name => g_pkg_name
470: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
471: ,x_msg_count => x_msg_count
472: ,x_msg_data => x_msg_data

Line 470: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'

466: ,p_api_type => g_api_type);
467: WHEN okl_api.g_exception_unexpected_error THEN
468: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
469: ,p_pkg_name => g_pkg_name
470: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
471: ,x_msg_count => x_msg_count
472: ,x_msg_data => x_msg_data
473: ,p_api_type => g_api_type);
474: WHEN OTHERS THEN

Line 475: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

471: ,x_msg_count => x_msg_count
472: ,x_msg_data => x_msg_data
473: ,p_api_type => g_api_type);
474: WHEN OTHERS THEN
475: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
476: ,p_pkg_name => g_pkg_name
477: ,p_exc_name => 'OTHERS'
478: ,x_msg_count => x_msg_count
479: ,x_msg_data => x_msg_data

Line 484: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

480: ,p_api_type => g_api_type);
481: END update_vls;
482:
483: PROCEDURE delete_vls(p_api_version IN number
484: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
485: ,x_return_status OUT NOCOPY varchar2
486: ,x_msg_count OUT NOCOPY number
487: ,x_msg_data OUT NOCOPY varchar2
488: ,p_vlsv_rec IN vlsv_rec_type) IS

Line 528: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

524: is_debug_procedure_on boolean;
525: is_debug_statement_on boolean;
526: l_api_name CONSTANT varchar2(30) := 'delete_vls';
527: l_api_version CONSTANT number := 1.0;
528: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
529:
530: BEGIN
531: l_debug_enabled := okl_debug_pub.check_log_enabled;
532: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

Line 546: l_return_status := okl_api.start_activity(p_api_name => l_api_name

542:
543: -- call START_ACTIVITY to create savepoint, check compatibility
544: -- and initialize message list
545:
546: l_return_status := okl_api.start_activity(p_api_name => l_api_name
547: ,p_pkg_name => g_pkg_name
548: ,p_init_msg_list => p_init_msg_list
549: ,l_api_version => l_api_version
550: ,p_api_version => p_api_version

Line 554: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

550: ,p_api_version => p_api_version
551: ,p_api_type => g_api_type
552: ,x_return_status => x_return_status); -- check if activity started successfully
553:
554: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
555: RAISE okl_api.g_exception_unexpected_error;
556: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
557: RAISE okl_api.g_exception_error;
558: END IF;

Line 555: RAISE okl_api.g_exception_unexpected_error;

551: ,p_api_type => g_api_type
552: ,x_return_status => x_return_status); -- check if activity started successfully
553:
554: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
555: RAISE okl_api.g_exception_unexpected_error;
556: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
557: RAISE okl_api.g_exception_error;
558: END IF;
559: lp_vlsv_rec := p_vlsv_rec;

Line 556: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

552: ,x_return_status => x_return_status); -- check if activity started successfully
553:
554: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
555: RAISE okl_api.g_exception_unexpected_error;
556: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
557: RAISE okl_api.g_exception_error;
558: END IF;
559: lp_vlsv_rec := p_vlsv_rec;
560:

Line 557: RAISE okl_api.g_exception_error;

553:
554: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
555: RAISE okl_api.g_exception_unexpected_error;
556: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
557: RAISE okl_api.g_exception_error;
558: END IF;
559: lp_vlsv_rec := p_vlsv_rec;
560:
561: l_return_status := OKL_VALIDATION_SET_PVT.validate_header(lp_vlsv_rec); -- write to log

Line 570: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

566: ,'Function okl_ecc_def_pvt.validate_header returned with status ' ||
567: l_return_status);
568: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
569:
570: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
571: RAISE okl_api.g_exception_unexpected_error;
572: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
573: RAISE okl_api.g_exception_error;
574: END IF; --if crit_cat_def_id is present it means we are duplicating so populate orig_crit_Cat_Def_id

Line 571: RAISE okl_api.g_exception_unexpected_error;

567: l_return_status);
568: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
569:
570: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
571: RAISE okl_api.g_exception_unexpected_error;
572: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
573: RAISE okl_api.g_exception_error;
574: END IF; --if crit_cat_def_id is present it means we are duplicating so populate orig_crit_Cat_Def_id
575:

Line 572: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

568: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
569:
570: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
571: RAISE okl_api.g_exception_unexpected_error;
572: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
573: RAISE okl_api.g_exception_error;
574: END IF; --if crit_cat_def_id is present it means we are duplicating so populate orig_crit_Cat_Def_id
575:
576: --Delete all the Records for Validation Set

Line 573: RAISE okl_api.g_exception_error;

569:
570: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
571: RAISE okl_api.g_exception_unexpected_error;
572: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
573: RAISE okl_api.g_exception_error;
574: END IF; --if crit_cat_def_id is present it means we are duplicating so populate orig_crit_Cat_Def_id
575:
576: --Delete all the Records for Validation Set
577: OPEN l_vldv_csr(lp_vlsv_rec.id);

Line 585: ,okl_api.g_false

581: lx_vldv_tbl(i):=lx_vldv_rec;
582: i:=i+1;
583: END LOOP;
584: okl_vld_pvt.delete_row(p_api_version
585: ,okl_api.g_false
586: ,l_return_status
587: ,x_msg_count
588: ,x_msg_data
589: ,lx_vldv_tbl); -- write to log

Line 600: IF (l_return_status = okl_api.g_ret_sts_error) THEN

596: ' x_msg_data ' ||
597: x_msg_data);
598: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
599:
600: IF (l_return_status = okl_api.g_ret_sts_error) THEN
601: RAISE okl_api.g_exception_error;
602: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
603: RAISE okl_api.g_exception_unexpected_error;
604: END IF; --Copy value of OUT variable in the IN rvldrd type

Line 601: RAISE okl_api.g_exception_error;

597: x_msg_data);
598: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
599:
600: IF (l_return_status = okl_api.g_ret_sts_error) THEN
601: RAISE okl_api.g_exception_error;
602: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
603: RAISE okl_api.g_exception_unexpected_error;
604: END IF; --Copy value of OUT variable in the IN rvldrd type
605: --Delete Parent If Child Are successfully Deleted

Line 602: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

598: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
599:
600: IF (l_return_status = okl_api.g_ret_sts_error) THEN
601: RAISE okl_api.g_exception_error;
602: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
603: RAISE okl_api.g_exception_unexpected_error;
604: END IF; --Copy value of OUT variable in the IN rvldrd type
605: --Delete Parent If Child Are successfully Deleted
606: okl_vls_pvt.delete_row(p_api_version

Line 603: RAISE okl_api.g_exception_unexpected_error;

599:
600: IF (l_return_status = okl_api.g_ret_sts_error) THEN
601: RAISE okl_api.g_exception_error;
602: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
603: RAISE okl_api.g_exception_unexpected_error;
604: END IF; --Copy value of OUT variable in the IN rvldrd type
605: --Delete Parent If Child Are successfully Deleted
606: okl_vls_pvt.delete_row(p_api_version
607: ,okl_api.g_false

Line 607: ,okl_api.g_false

603: RAISE okl_api.g_exception_unexpected_error;
604: END IF; --Copy value of OUT variable in the IN rvldrd type
605: --Delete Parent If Child Are successfully Deleted
606: okl_vls_pvt.delete_row(p_api_version
607: ,okl_api.g_false
608: ,l_return_status
609: ,x_msg_count
610: ,x_msg_data
611: ,lp_vlsv_rec); -- write to log

Line 622: IF (l_return_status = okl_api.g_ret_sts_error) THEN

618: ' x_msg_data ' ||
619: x_msg_data);
620: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
621:
622: IF (l_return_status = okl_api.g_ret_sts_error) THEN
623: RAISE okl_api.g_exception_error;
624: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okl_api.g_exception_unexpected_error;
626: END IF; --Copy value of OUT variable in the IN rvldrd type

Line 623: RAISE okl_api.g_exception_error;

619: x_msg_data);
620: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
621:
622: IF (l_return_status = okl_api.g_ret_sts_error) THEN
623: RAISE okl_api.g_exception_error;
624: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okl_api.g_exception_unexpected_error;
626: END IF; --Copy value of OUT variable in the IN rvldrd type
627: okl_api.end_activity(x_msg_count => x_msg_count

Line 624: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

620: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
621:
622: IF (l_return_status = okl_api.g_ret_sts_error) THEN
623: RAISE okl_api.g_exception_error;
624: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okl_api.g_exception_unexpected_error;
626: END IF; --Copy value of OUT variable in the IN rvldrd type
627: okl_api.end_activity(x_msg_count => x_msg_count
628: ,x_msg_data => x_msg_data);

Line 625: RAISE okl_api.g_exception_unexpected_error;

621:
622: IF (l_return_status = okl_api.g_ret_sts_error) THEN
623: RAISE okl_api.g_exception_error;
624: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okl_api.g_exception_unexpected_error;
626: END IF; --Copy value of OUT variable in the IN rvldrd type
627: okl_api.end_activity(x_msg_count => x_msg_count
628: ,x_msg_data => x_msg_data);
629:

Line 627: okl_api.end_activity(x_msg_count => x_msg_count

623: RAISE okl_api.g_exception_error;
624: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okl_api.g_exception_unexpected_error;
626: END IF; --Copy value of OUT variable in the IN rvldrd type
627: okl_api.end_activity(x_msg_count => x_msg_count
628: ,x_msg_data => x_msg_data);
629:
630: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
631: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 639: WHEN okl_api.g_exception_error THEN

635:
636:
637:
638: EXCEPTION
639: WHEN okl_api.g_exception_error THEN
640: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
641: ,p_pkg_name => g_pkg_name
642: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
643: ,x_msg_count => x_msg_count

Line 640: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

636:
637:
638: EXCEPTION
639: WHEN okl_api.g_exception_error THEN
640: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
641: ,p_pkg_name => g_pkg_name
642: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
643: ,x_msg_count => x_msg_count
644: ,x_msg_data => x_msg_data

Line 642: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

638: EXCEPTION
639: WHEN okl_api.g_exception_error THEN
640: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
641: ,p_pkg_name => g_pkg_name
642: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
643: ,x_msg_count => x_msg_count
644: ,x_msg_data => x_msg_data
645: ,p_api_type => g_api_type);
646: WHEN okl_api.g_exception_unexpected_error THEN

Line 646: WHEN okl_api.g_exception_unexpected_error THEN

642: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
643: ,x_msg_count => x_msg_count
644: ,x_msg_data => x_msg_data
645: ,p_api_type => g_api_type);
646: WHEN okl_api.g_exception_unexpected_error THEN
647: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
648: ,p_pkg_name => g_pkg_name
649: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
650: ,x_msg_count => x_msg_count

Line 647: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

643: ,x_msg_count => x_msg_count
644: ,x_msg_data => x_msg_data
645: ,p_api_type => g_api_type);
646: WHEN okl_api.g_exception_unexpected_error THEN
647: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
648: ,p_pkg_name => g_pkg_name
649: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
650: ,x_msg_count => x_msg_count
651: ,x_msg_data => x_msg_data

Line 649: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'

645: ,p_api_type => g_api_type);
646: WHEN okl_api.g_exception_unexpected_error THEN
647: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
648: ,p_pkg_name => g_pkg_name
649: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
650: ,x_msg_count => x_msg_count
651: ,x_msg_data => x_msg_data
652: ,p_api_type => g_api_type);
653: WHEN OTHERS THEN

Line 654: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

650: ,x_msg_count => x_msg_count
651: ,x_msg_data => x_msg_data
652: ,p_api_type => g_api_type);
653: WHEN OTHERS THEN
654: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
655: ,p_pkg_name => g_pkg_name
656: ,p_exc_name => 'OTHERS'
657: ,x_msg_count => x_msg_count
658: ,x_msg_data => x_msg_data

Line 665: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

661:
662: END delete_vls;
663:
664: PROCEDURE delete_vld(p_api_version IN number
665: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
666: ,x_return_status OUT NOCOPY varchar2
667: ,x_msg_count OUT NOCOPY number
668: ,x_msg_data OUT NOCOPY varchar2
669: ,p_vldv_rec IN vldv_rec_type) IS

Line 682: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

678: is_debug_procedure_on boolean;
679: is_debug_statement_on boolean;
680: l_api_name CONSTANT varchar2(30) := 'delete_vld';
681: l_api_version CONSTANT number := 1.0;
682: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
683: BEGIN
684: l_debug_enabled := okl_debug_pub.check_log_enabled;
685: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
686: ,fnd_log.level_procedure);

Line 699: l_return_status := okl_api.start_activity(p_api_name => l_api_name

695:
696: -- call START_ACTIVITY to create savepoint, check compatibility
697: -- and initialize message list
698:
699: l_return_status := okl_api.start_activity(p_api_name => l_api_name
700: ,p_pkg_name => g_pkg_name
701: ,p_init_msg_list => p_init_msg_list
702: ,l_api_version => l_api_version
703: ,p_api_version => p_api_version

Line 707: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

703: ,p_api_version => p_api_version
704: ,p_api_type => g_api_type
705: ,x_return_status => x_return_status); -- check if activity started successfully
706:
707: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
708: RAISE okl_api.g_exception_unexpected_error;
709: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
710: RAISE okl_api.g_exception_error;
711: END IF;

Line 708: RAISE okl_api.g_exception_unexpected_error;

704: ,p_api_type => g_api_type
705: ,x_return_status => x_return_status); -- check if activity started successfully
706:
707: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
708: RAISE okl_api.g_exception_unexpected_error;
709: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
710: RAISE okl_api.g_exception_error;
711: END IF;
712:

Line 709: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

705: ,x_return_status => x_return_status); -- check if activity started successfully
706:
707: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
708: RAISE okl_api.g_exception_unexpected_error;
709: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
710: RAISE okl_api.g_exception_error;
711: END IF;
712:
713: lp_vldv_rec := p_vldv_rec;

Line 710: RAISE okl_api.g_exception_error;

706:
707: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
708: RAISE okl_api.g_exception_unexpected_error;
709: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
710: RAISE okl_api.g_exception_error;
711: END IF;
712:
713: lp_vldv_rec := p_vldv_rec;
714: okl_vld_pvt.delete_row(p_api_version

Line 715: ,okl_api.g_false

711: END IF;
712:
713: lp_vldv_rec := p_vldv_rec;
714: okl_vld_pvt.delete_row(p_api_version
715: ,okl_api.g_false
716: ,l_return_status
717: ,x_msg_count
718: ,x_msg_data
719: ,lp_vldv_rec); -- write to log

Line 730: IF (l_return_status = okl_api.g_ret_sts_error) THEN

726: ' x_msg_data ' ||
727: x_msg_data);
728: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
729:
730: IF (l_return_status = okl_api.g_ret_sts_error) THEN
731: RAISE okl_api.g_exception_error;
732: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
733: RAISE okl_api.g_exception_unexpected_error;
734: END IF; --Copy value of OUT variable in the IN rvldrd type

Line 731: RAISE okl_api.g_exception_error;

727: x_msg_data);
728: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
729:
730: IF (l_return_status = okl_api.g_ret_sts_error) THEN
731: RAISE okl_api.g_exception_error;
732: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
733: RAISE okl_api.g_exception_unexpected_error;
734: END IF; --Copy value of OUT variable in the IN rvldrd type
735:

Line 732: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

728: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
729:
730: IF (l_return_status = okl_api.g_ret_sts_error) THEN
731: RAISE okl_api.g_exception_error;
732: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
733: RAISE okl_api.g_exception_unexpected_error;
734: END IF; --Copy value of OUT variable in the IN rvldrd type
735:
736:

Line 733: RAISE okl_api.g_exception_unexpected_error;

729:
730: IF (l_return_status = okl_api.g_ret_sts_error) THEN
731: RAISE okl_api.g_exception_error;
732: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
733: RAISE okl_api.g_exception_unexpected_error;
734: END IF; --Copy value of OUT variable in the IN rvldrd type
735:
736:
737: okl_api.end_activity(x_msg_count => x_msg_count

Line 737: okl_api.end_activity(x_msg_count => x_msg_count

733: RAISE okl_api.g_exception_unexpected_error;
734: END IF; --Copy value of OUT variable in the IN rvldrd type
735:
736:
737: okl_api.end_activity(x_msg_count => x_msg_count
738: ,x_msg_data => x_msg_data);
739:
740: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
741: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 747: WHEN okl_api.g_exception_error THEN

743: ,'end debug OKL_VALIDATION_SET_PVT.pls call create_vls');
744: END IF;
745:
746: EXCEPTION
747: WHEN okl_api.g_exception_error THEN
748: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
749: ,p_pkg_name => g_pkg_name
750: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
751: ,x_msg_count => x_msg_count

Line 748: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

744: END IF;
745:
746: EXCEPTION
747: WHEN okl_api.g_exception_error THEN
748: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
749: ,p_pkg_name => g_pkg_name
750: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
751: ,x_msg_count => x_msg_count
752: ,x_msg_data => x_msg_data

Line 750: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

746: EXCEPTION
747: WHEN okl_api.g_exception_error THEN
748: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
749: ,p_pkg_name => g_pkg_name
750: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
751: ,x_msg_count => x_msg_count
752: ,x_msg_data => x_msg_data
753: ,p_api_type => g_api_type);
754: WHEN okl_api.g_exception_unexpected_error THEN

Line 754: WHEN okl_api.g_exception_unexpected_error THEN

750: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
751: ,x_msg_count => x_msg_count
752: ,x_msg_data => x_msg_data
753: ,p_api_type => g_api_type);
754: WHEN okl_api.g_exception_unexpected_error THEN
755: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
756: ,p_pkg_name => g_pkg_name
757: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
758: ,x_msg_count => x_msg_count

Line 755: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

751: ,x_msg_count => x_msg_count
752: ,x_msg_data => x_msg_data
753: ,p_api_type => g_api_type);
754: WHEN okl_api.g_exception_unexpected_error THEN
755: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
756: ,p_pkg_name => g_pkg_name
757: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
758: ,x_msg_count => x_msg_count
759: ,x_msg_data => x_msg_data

Line 757: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'

753: ,p_api_type => g_api_type);
754: WHEN okl_api.g_exception_unexpected_error THEN
755: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
756: ,p_pkg_name => g_pkg_name
757: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
758: ,x_msg_count => x_msg_count
759: ,x_msg_data => x_msg_data
760: ,p_api_type => g_api_type);
761: WHEN OTHERS THEN

Line 762: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

758: ,x_msg_count => x_msg_count
759: ,x_msg_data => x_msg_data
760: ,p_api_type => g_api_type);
761: WHEN OTHERS THEN
762: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
763: ,p_pkg_name => g_pkg_name
764: ,p_exc_name => 'OTHERS'
765: ,x_msg_count => x_msg_count
766: ,x_msg_data => x_msg_data