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_QUICK_QUOTES_PVT dependencies on OKL_API

Line 21: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

17: WHERE reference_number = p_qqhv_rec_type.reference_number
18: AND id <> NVL(p_qqhv_rec_type.id, -9999);
19:
20: l_dummy_var VARCHAR2(1);
21: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
22: l_api_name CONSTANT VARCHAR2(61) := g_pkg_name || '.' || 'validate_header';
23: l_msg_count NUMBER;
24: l_msg_data VARCHAR2(2000);
25:

Line 33: okl_api.set_message(p_app_name => g_app_name

29: FETCH chk_uniquness INTO l_dummy_var;
30: CLOSE chk_uniquness; -- if l_dummy_var is 'x' then Ref Num already exists
31:
32: IF (l_dummy_var = 'x') THEN
33: okl_api.set_message(p_app_name => g_app_name
34: ,p_msg_name => 'OKL_DUPLICATE_CURE_REQUEST'
35: ,p_token1 => 'COL_NAME'
36: ,p_token1_value => p_qqhv_rec_type.reference_number);
37: RAISE okl_api.g_exception_error;

Line 37: RAISE okl_api.g_exception_error;

33: okl_api.set_message(p_app_name => g_app_name
34: ,p_msg_name => 'OKL_DUPLICATE_CURE_REQUEST'
35: ,p_token1 => 'COL_NAME'
36: ,p_token1_value => p_qqhv_rec_type.reference_number);
37: RAISE okl_api.g_exception_error;
38: END IF;
39:
40: RETURN x_return_status;
41:

Line 43: WHEN okl_api.g_exception_error THEN

39:
40: RETURN x_return_status;
41:
42: EXCEPTION
43: WHEN okl_api.g_exception_error THEN
44: RETURN okl_api.g_ret_sts_error;
45: WHEN OTHERS THEN
46: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
47: ,p_pkg_name => g_pkg_name

Line 44: RETURN okl_api.g_ret_sts_error;

40: RETURN x_return_status;
41:
42: EXCEPTION
43: WHEN okl_api.g_exception_error THEN
44: RETURN okl_api.g_ret_sts_error;
45: WHEN OTHERS THEN
46: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
47: ,p_pkg_name => g_pkg_name
48: ,p_exc_name => 'OTHERS'

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

42: EXCEPTION
43: WHEN okl_api.g_exception_error THEN
44: RETURN okl_api.g_ret_sts_error;
45: WHEN OTHERS THEN
46: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
47: ,p_pkg_name => g_pkg_name
48: ,p_exc_name => 'OTHERS'
49: ,x_msg_count => l_msg_count
50: ,x_msg_data => l_msg_data

Line 56: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

52: RETURN x_return_status;
53: END validate_header;
54:
55: PROCEDURE create_qqh(p_api_version IN NUMBER
56: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
57: ,x_return_status OUT NOCOPY VARCHAR2
58: ,x_msg_count OUT NOCOPY NUMBER
59: ,x_msg_data OUT NOCOPY VARCHAR2
60: ,p_qqhv_rec_type IN qqhv_rec_type

Line 71: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

67: is_debug_procedure_on BOOLEAN;
68: is_debug_statement_on BOOLEAN;
69: l_api_name CONSTANT VARCHAR2(30) := 'create_qqh';
70: l_api_version CONSTANT NUMBER := 1.0;
71: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
72:
73: BEGIN
74: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');
75: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

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

86:
87: -- call START_ACTIVITY to create savepoint, check compatibility
88: -- and initialize message list
89:
90: l_return_status := okl_api.start_activity(p_api_name => l_api_name
91: ,p_pkg_name => g_pkg_name
92: ,p_init_msg_list => p_init_msg_list
93: ,l_api_version => l_api_version
94: ,p_api_version => p_api_version

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

97:
98: lp_qqhv_rec_type := p_qqhv_rec_type;
99:
100: l_return_status := validate_header(lp_qqhv_rec_type); --validate header
101: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
102: RAISE okl_api.g_exception_unexpected_error;
103: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
104: RAISE okl_api.g_exception_error;
105: END IF;

Line 102: RAISE okl_api.g_exception_unexpected_error;

98: lp_qqhv_rec_type := p_qqhv_rec_type;
99:
100: l_return_status := validate_header(lp_qqhv_rec_type); --validate header
101: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
102: RAISE okl_api.g_exception_unexpected_error;
103: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
104: RAISE okl_api.g_exception_error;
105: END IF;
106:

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

99:
100: l_return_status := validate_header(lp_qqhv_rec_type); --validate header
101: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
102: RAISE okl_api.g_exception_unexpected_error;
103: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
104: RAISE okl_api.g_exception_error;
105: END IF;
106:
107: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN -- write to log

Line 104: RAISE okl_api.g_exception_error;

100: l_return_status := validate_header(lp_qqhv_rec_type); --validate header
101: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
102: RAISE okl_api.g_exception_unexpected_error;
103: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
104: RAISE okl_api.g_exception_error;
105: END IF;
106:
107: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN -- write to log
108: okl_debug_pub.log_debug(fnd_log.level_statement

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

110: ,'Function okl_quick_quotes_pvt.validate_header returned with status ' ||
111: l_return_status);
112: END IF; -- end of l_debug_enabled ='Y'
113:
114: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
115: RAISE okl_api.g_exception_unexpected_error;
116: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
117: RAISE okl_api.g_exception_error;
118: END IF;

Line 115: RAISE okl_api.g_exception_unexpected_error;

111: l_return_status);
112: END IF; -- end of l_debug_enabled ='Y'
113:
114: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
115: RAISE okl_api.g_exception_unexpected_error;
116: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
117: RAISE okl_api.g_exception_error;
118: END IF;
119:

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

112: END IF; -- end of l_debug_enabled ='Y'
113:
114: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
115: RAISE okl_api.g_exception_unexpected_error;
116: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
117: RAISE okl_api.g_exception_error;
118: END IF;
119:
120: okl_qqh_pvt.insert_row(p_api_version

Line 117: RAISE okl_api.g_exception_error;

113:
114: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
115: RAISE okl_api.g_exception_unexpected_error;
116: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
117: RAISE okl_api.g_exception_error;
118: END IF;
119:
120: okl_qqh_pvt.insert_row(p_api_version
121: ,okl_api.g_false

Line 121: ,okl_api.g_false

117: RAISE okl_api.g_exception_error;
118: END IF;
119:
120: okl_qqh_pvt.insert_row(p_api_version
121: ,okl_api.g_false
122: ,l_return_status
123: ,x_msg_count
124: ,x_msg_data
125: ,lp_qqhv_rec_type

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

133: ' x_msg_data ' ||
134: x_msg_data);
135: END IF; -- end of l_debug_enabled ='Y'
136:
137: IF (l_return_status = okl_api.g_ret_sts_error) THEN
138: RAISE okl_api.g_exception_error;
139: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
140: RAISE okl_api.g_exception_unexpected_error;
141: END IF;

Line 138: RAISE okl_api.g_exception_error;

134: x_msg_data);
135: END IF; -- end of l_debug_enabled ='Y'
136:
137: IF (l_return_status = okl_api.g_ret_sts_error) THEN
138: RAISE okl_api.g_exception_error;
139: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
140: RAISE okl_api.g_exception_unexpected_error;
141: END IF;
142:

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

135: END IF; -- end of l_debug_enabled ='Y'
136:
137: IF (l_return_status = okl_api.g_ret_sts_error) THEN
138: RAISE okl_api.g_exception_error;
139: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
140: RAISE okl_api.g_exception_unexpected_error;
141: END IF;
142:
143: x_qqhv_rec_type := lx_qqhv_rec_type;

Line 140: RAISE okl_api.g_exception_unexpected_error;

136:
137: IF (l_return_status = okl_api.g_ret_sts_error) THEN
138: RAISE okl_api.g_exception_error;
139: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
140: RAISE okl_api.g_exception_unexpected_error;
141: END IF;
142:
143: x_qqhv_rec_type := lx_qqhv_rec_type;
144:

Line 147: okl_api.end_activity(x_msg_count => x_msg_count

143: x_qqhv_rec_type := lx_qqhv_rec_type;
144:
145: x_return_status := l_return_status;
146:
147: okl_api.end_activity(x_msg_count => x_msg_count
148: ,x_msg_data => x_msg_data);
149:
150: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
151: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 157: WHEN okl_api.g_exception_error THEN

153: ,'end debug OKLRQQHB.pls call create_qqh');
154: END IF;
155:
156: EXCEPTION
157: WHEN okl_api.g_exception_error THEN
158: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
159: ,p_pkg_name => g_pkg_name
160: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
161: ,x_msg_count => x_msg_count

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

154: END IF;
155:
156: EXCEPTION
157: WHEN okl_api.g_exception_error THEN
158: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
159: ,p_pkg_name => g_pkg_name
160: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
161: ,x_msg_count => x_msg_count
162: ,x_msg_data => x_msg_data

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

156: EXCEPTION
157: WHEN okl_api.g_exception_error THEN
158: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
159: ,p_pkg_name => g_pkg_name
160: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
161: ,x_msg_count => x_msg_count
162: ,x_msg_data => x_msg_data
163: ,p_api_type => g_api_type);
164: WHEN okl_api.g_exception_unexpected_error THEN

Line 164: WHEN okl_api.g_exception_unexpected_error THEN

160: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
161: ,x_msg_count => x_msg_count
162: ,x_msg_data => x_msg_data
163: ,p_api_type => g_api_type);
164: WHEN okl_api.g_exception_unexpected_error THEN
165: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
166: ,p_pkg_name => g_pkg_name
167: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
168: ,x_msg_count => x_msg_count

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

161: ,x_msg_count => x_msg_count
162: ,x_msg_data => x_msg_data
163: ,p_api_type => g_api_type);
164: WHEN okl_api.g_exception_unexpected_error THEN
165: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
166: ,p_pkg_name => g_pkg_name
167: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
168: ,x_msg_count => x_msg_count
169: ,x_msg_data => x_msg_data

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

163: ,p_api_type => g_api_type);
164: WHEN okl_api.g_exception_unexpected_error THEN
165: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
166: ,p_pkg_name => g_pkg_name
167: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
168: ,x_msg_count => x_msg_count
169: ,x_msg_data => x_msg_data
170: ,p_api_type => g_api_type);
171: WHEN OTHERS THEN

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

168: ,x_msg_count => x_msg_count
169: ,x_msg_data => x_msg_data
170: ,p_api_type => g_api_type);
171: WHEN OTHERS THEN
172: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
173: ,p_pkg_name => g_pkg_name
174: ,p_exc_name => 'OTHERS'
175: ,x_msg_count => x_msg_count
176: ,x_msg_data => x_msg_data

Line 181: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

177: ,p_api_type => g_api_type);
178: END create_qqh;
179:
180: PROCEDURE create_qql(p_api_version IN NUMBER
181: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
182: ,x_return_status OUT NOCOPY VARCHAR2
183: ,x_msg_count OUT NOCOPY NUMBER
184: ,x_msg_data OUT NOCOPY VARCHAR2
185: ,p_qqlv_tbl_type IN qqlv_tbl_type

Line 196: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

192: is_debug_procedure_on BOOLEAN;
193: is_debug_statement_on BOOLEAN;
194: l_api_name CONSTANT VARCHAR2(30) := 'create_qql';
195: l_api_version CONSTANT NUMBER := 1.0;
196: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
197:
198: BEGIN
199: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');
200: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

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

211:
212: -- call START_ACTIVITY to create savepoint, check compatibility
213: -- and initialize message list
214:
215: l_return_status := okl_api.start_activity(p_api_name => l_api_name
216: ,p_pkg_name => g_pkg_name
217: ,p_init_msg_list => p_init_msg_list
218: ,l_api_version => l_api_version
219: ,p_api_version => p_api_version

Line 226: ,okl_api.g_false

222:
223: lp_qqlv_tbl_type := p_qqlv_tbl_type;
224:
225: okl_qql_pvt.insert_row(p_api_version
226: ,okl_api.g_false
227: ,l_return_status
228: ,x_msg_count
229: ,x_msg_data
230: ,lp_qqlv_tbl_type

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

239: x_msg_data);
240:
241: END IF; -- end of l_debug_enabled ='Y'
242:
243: IF (l_return_status = okl_api.g_ret_sts_error) THEN
244: RAISE okl_api.g_exception_error;
245: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
246: RAISE okl_api.g_exception_unexpected_error;
247: END IF;

Line 244: RAISE okl_api.g_exception_error;

240:
241: END IF; -- end of l_debug_enabled ='Y'
242:
243: IF (l_return_status = okl_api.g_ret_sts_error) THEN
244: RAISE okl_api.g_exception_error;
245: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
246: RAISE okl_api.g_exception_unexpected_error;
247: END IF;
248:

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

241: END IF; -- end of l_debug_enabled ='Y'
242:
243: IF (l_return_status = okl_api.g_ret_sts_error) THEN
244: RAISE okl_api.g_exception_error;
245: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
246: RAISE okl_api.g_exception_unexpected_error;
247: END IF;
248:
249: --Assign value to OUT variables

Line 246: RAISE okl_api.g_exception_unexpected_error;

242:
243: IF (l_return_status = okl_api.g_ret_sts_error) THEN
244: RAISE okl_api.g_exception_error;
245: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
246: RAISE okl_api.g_exception_unexpected_error;
247: END IF;
248:
249: --Assign value to OUT variables
250: x_qqlv_tbl_type := lx_qqlv_tbl_type;

Line 253: okl_api.end_activity(x_msg_count => x_msg_count

249: --Assign value to OUT variables
250: x_qqlv_tbl_type := lx_qqlv_tbl_type;
251:
252: x_return_status := l_return_status;
253: okl_api.end_activity(x_msg_count => x_msg_count
254: ,x_msg_data => x_msg_data);
255:
256: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
257: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 263: WHEN okl_api.g_exception_error THEN

259: ,'end debug OKLRQQHB.pls call create_qql');
260: END IF;
261:
262: EXCEPTION
263: WHEN okl_api.g_exception_error THEN
264: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
265: ,p_pkg_name => g_pkg_name
266: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
267: ,x_msg_count => x_msg_count

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

260: END IF;
261:
262: EXCEPTION
263: WHEN okl_api.g_exception_error THEN
264: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
265: ,p_pkg_name => g_pkg_name
266: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
267: ,x_msg_count => x_msg_count
268: ,x_msg_data => x_msg_data

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

262: EXCEPTION
263: WHEN okl_api.g_exception_error THEN
264: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
265: ,p_pkg_name => g_pkg_name
266: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
267: ,x_msg_count => x_msg_count
268: ,x_msg_data => x_msg_data
269: ,p_api_type => g_api_type);
270: WHEN okl_api.g_exception_unexpected_error THEN

Line 270: WHEN okl_api.g_exception_unexpected_error THEN

266: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
267: ,x_msg_count => x_msg_count
268: ,x_msg_data => x_msg_data
269: ,p_api_type => g_api_type);
270: WHEN okl_api.g_exception_unexpected_error THEN
271: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
272: ,p_pkg_name => g_pkg_name
273: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
274: ,x_msg_count => x_msg_count

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

267: ,x_msg_count => x_msg_count
268: ,x_msg_data => x_msg_data
269: ,p_api_type => g_api_type);
270: WHEN okl_api.g_exception_unexpected_error THEN
271: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
272: ,p_pkg_name => g_pkg_name
273: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
274: ,x_msg_count => x_msg_count
275: ,x_msg_data => x_msg_data

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

269: ,p_api_type => g_api_type);
270: WHEN okl_api.g_exception_unexpected_error THEN
271: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
272: ,p_pkg_name => g_pkg_name
273: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
274: ,x_msg_count => x_msg_count
275: ,x_msg_data => x_msg_data
276: ,p_api_type => g_api_type);
277: WHEN OTHERS THEN

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

274: ,x_msg_count => x_msg_count
275: ,x_msg_data => x_msg_data
276: ,p_api_type => g_api_type);
277: WHEN OTHERS THEN
278: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
279: ,p_pkg_name => g_pkg_name
280: ,p_exc_name => 'OTHERS'
281: ,x_msg_count => x_msg_count
282: ,x_msg_data => x_msg_data

Line 287: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

283: ,p_api_type => g_api_type);
284: END create_qql;
285:
286: PROCEDURE create_quick_qte(p_api_version IN NUMBER
287: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
288: ,x_return_status OUT NOCOPY VARCHAR2
289: ,x_msg_count OUT NOCOPY NUMBER
290: ,x_msg_data OUT NOCOPY VARCHAR2
291: ,p_qqhv_rec_type IN qqhv_rec_type

Line 306: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

302: is_debug_procedure_on BOOLEAN;
303: is_debug_statement_on BOOLEAN;
304: l_api_name CONSTANT VARCHAR2(30) := 'create_quick_qte';
305: l_api_version CONSTANT NUMBER := 1.0;
306: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
307: i NUMBER;
308:
309: BEGIN
310: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');

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

322:
323: -- call START_ACTIVITY to create savepoint, check compatibility
324: -- and initialize message list
325:
326: l_return_status := okl_api.start_activity(p_api_name => l_api_name
327: ,p_pkg_name => g_pkg_name
328: ,p_init_msg_list => p_init_msg_list
329: ,l_api_version => l_api_version
330: ,p_api_version => p_api_version

Line 339: ,p_init_msg_list => okl_api.g_false

335: lp_qqlv_tbl_type := p_qqlv_tbl_type;
336:
337: okl_quick_quotes_pvt.create_qqh(
338: p_api_version => p_api_version
339: ,p_init_msg_list => okl_api.g_false
340: ,x_return_status => l_return_status
341: ,x_msg_count => x_msg_count
342: ,x_msg_data => x_msg_data
343: ,p_qqhv_rec_type => lp_qqhv_rec_type

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

352: ' x_msg_data ' ||
353: x_msg_data);
354: END IF; -- end of l_debug_enabled ='Y'
355:
356: IF (l_return_status = okl_api.g_ret_sts_error) THEN
357: RAISE okl_api.g_exception_error;
358: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
359: RAISE okl_api.g_exception_unexpected_error;
360: END IF;

Line 357: RAISE okl_api.g_exception_error;

353: x_msg_data);
354: END IF; -- end of l_debug_enabled ='Y'
355:
356: IF (l_return_status = okl_api.g_ret_sts_error) THEN
357: RAISE okl_api.g_exception_error;
358: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
359: RAISE okl_api.g_exception_unexpected_error;
360: END IF;
361: -- populate the foreign key

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

354: END IF; -- end of l_debug_enabled ='Y'
355:
356: IF (l_return_status = okl_api.g_ret_sts_error) THEN
357: RAISE okl_api.g_exception_error;
358: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
359: RAISE okl_api.g_exception_unexpected_error;
360: END IF;
361: -- populate the foreign key
362: FOR i in lp_qqlv_tbl_type.first..lp_qqlv_tbl_type.last LOOP

Line 359: RAISE okl_api.g_exception_unexpected_error;

355:
356: IF (l_return_status = okl_api.g_ret_sts_error) THEN
357: RAISE okl_api.g_exception_error;
358: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
359: RAISE okl_api.g_exception_unexpected_error;
360: END IF;
361: -- populate the foreign key
362: FOR i in lp_qqlv_tbl_type.first..lp_qqlv_tbl_type.last LOOP
363: lp_qqlv_tbl_type(i).quick_quote_id:=lx_qqhv_rec_type.id;

Line 368: ,p_init_msg_list => okl_api.g_false

364: END LOOP;
365:
366: okl_quick_quotes_pvt.create_qql(
367: p_api_version => p_api_version
368: ,p_init_msg_list => okl_api.g_false
369: ,x_return_status => l_return_status
370: ,x_msg_count => x_msg_count
371: ,x_msg_data => x_msg_data
372: ,p_qqlv_tbl_type => lp_qqlv_tbl_type

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

380: ' x_msg_data ' ||
381: x_msg_data);
382: END IF; -- end of l_debug_enabled ='Y'
383:
384: IF (l_return_status = okl_api.g_ret_sts_error) THEN
385: RAISE okl_api.g_exception_error;
386: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
387: RAISE okl_api.g_exception_unexpected_error;
388: END IF;

Line 385: RAISE okl_api.g_exception_error;

381: x_msg_data);
382: END IF; -- end of l_debug_enabled ='Y'
383:
384: IF (l_return_status = okl_api.g_ret_sts_error) THEN
385: RAISE okl_api.g_exception_error;
386: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
387: RAISE okl_api.g_exception_unexpected_error;
388: END IF;
389:

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

382: END IF; -- end of l_debug_enabled ='Y'
383:
384: IF (l_return_status = okl_api.g_ret_sts_error) THEN
385: RAISE okl_api.g_exception_error;
386: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
387: RAISE okl_api.g_exception_unexpected_error;
388: END IF;
389:
390: x_qqhv_rec_type := lx_qqhv_rec_type;

Line 387: RAISE okl_api.g_exception_unexpected_error;

383:
384: IF (l_return_status = okl_api.g_ret_sts_error) THEN
385: RAISE okl_api.g_exception_error;
386: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
387: RAISE okl_api.g_exception_unexpected_error;
388: END IF;
389:
390: x_qqhv_rec_type := lx_qqhv_rec_type;
391: x_qqlv_tbl_type := lx_qqlv_tbl_type;

Line 393: okl_api.end_activity(x_msg_count => x_msg_count

389:
390: x_qqhv_rec_type := lx_qqhv_rec_type;
391: x_qqlv_tbl_type := lx_qqlv_tbl_type;
392: x_return_status := l_return_status;
393: okl_api.end_activity(x_msg_count => x_msg_count
394: ,x_msg_data => x_msg_data);
395:
396: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
397: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 403: WHEN okl_api.g_exception_error THEN

399: ,'end debug OKLRQQHB.pls call create_qq');
400: END IF;
401:
402: EXCEPTION
403: WHEN okl_api.g_exception_error THEN
404: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
405: ,p_pkg_name => g_pkg_name
406: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
407: ,x_msg_count => x_msg_count

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

400: END IF;
401:
402: EXCEPTION
403: WHEN okl_api.g_exception_error THEN
404: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
405: ,p_pkg_name => g_pkg_name
406: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
407: ,x_msg_count => x_msg_count
408: ,x_msg_data => x_msg_data

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

402: EXCEPTION
403: WHEN okl_api.g_exception_error THEN
404: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
405: ,p_pkg_name => g_pkg_name
406: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
407: ,x_msg_count => x_msg_count
408: ,x_msg_data => x_msg_data
409: ,p_api_type => g_api_type);
410: WHEN okl_api.g_exception_unexpected_error THEN

Line 410: WHEN okl_api.g_exception_unexpected_error THEN

406: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
407: ,x_msg_count => x_msg_count
408: ,x_msg_data => x_msg_data
409: ,p_api_type => g_api_type);
410: WHEN okl_api.g_exception_unexpected_error THEN
411: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
412: ,p_pkg_name => g_pkg_name
413: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
414: ,x_msg_count => x_msg_count

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

407: ,x_msg_count => x_msg_count
408: ,x_msg_data => x_msg_data
409: ,p_api_type => g_api_type);
410: WHEN okl_api.g_exception_unexpected_error THEN
411: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
412: ,p_pkg_name => g_pkg_name
413: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
414: ,x_msg_count => x_msg_count
415: ,x_msg_data => x_msg_data

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

409: ,p_api_type => g_api_type);
410: WHEN okl_api.g_exception_unexpected_error THEN
411: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
412: ,p_pkg_name => g_pkg_name
413: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
414: ,x_msg_count => x_msg_count
415: ,x_msg_data => x_msg_data
416: ,p_api_type => g_api_type);
417: WHEN OTHERS THEN

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

414: ,x_msg_count => x_msg_count
415: ,x_msg_data => x_msg_data
416: ,p_api_type => g_api_type);
417: WHEN OTHERS THEN
418: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
419: ,p_pkg_name => g_pkg_name
420: ,p_exc_name => 'OTHERS'
421: ,x_msg_count => x_msg_count
422: ,x_msg_data => x_msg_data

Line 427: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

423: ,p_api_type => g_api_type);
424: END create_quick_qte;
425:
426: PROCEDURE update_qqh (p_api_version IN NUMBER
427: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
428: ,x_return_status OUT NOCOPY VARCHAR2
429: ,x_msg_count OUT NOCOPY NUMBER
430: ,x_msg_data OUT NOCOPY VARCHAR2
431: ,p_qqhv_rec_type IN qqhv_rec_type

Line 441: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

437: is_debug_procedure_on BOOLEAN;
438: is_debug_statement_on BOOLEAN;
439: l_api_name CONSTANT VARCHAR2(30) := 'update_qqh';
440: l_api_version CONSTANT NUMBER := 1.0;
441: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
442:
443: BEGIN
444: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
445: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

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

455:
456: -- call START_ACTIVITY to create savepoint, check compatibility
457: -- and initialize message list
458:
459: l_return_status := okl_api.start_activity(p_api_name => l_api_name
460: ,p_pkg_name => g_pkg_name
461: ,p_init_msg_list => p_init_msg_list
462: ,l_api_version => l_api_version
463: ,p_api_version => p_api_version

Line 490: ,okl_api.g_false

486: END IF;
487: END IF;
488:
489: okl_qqh_pvt.update_row(p_api_version
490: ,okl_api.g_false
491: ,l_return_status
492: ,x_msg_count
493: ,x_msg_data
494: ,lp_qqhv_rec_type

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

502: ' x_msg_data ' ||
503: x_msg_data);
504: END IF; -- end of l_debug_enabled ='Y'
505:
506: IF (l_return_status = okl_api.g_ret_sts_error) THEN
507: RAISE okl_api.g_exception_error;
508: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
509: RAISE okl_api.g_exception_unexpected_error;
510: END IF;

Line 507: RAISE okl_api.g_exception_error;

503: x_msg_data);
504: END IF; -- end of l_debug_enabled ='Y'
505:
506: IF (l_return_status = okl_api.g_ret_sts_error) THEN
507: RAISE okl_api.g_exception_error;
508: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
509: RAISE okl_api.g_exception_unexpected_error;
510: END IF;
511:

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

504: END IF; -- end of l_debug_enabled ='Y'
505:
506: IF (l_return_status = okl_api.g_ret_sts_error) THEN
507: RAISE okl_api.g_exception_error;
508: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
509: RAISE okl_api.g_exception_unexpected_error;
510: END IF;
511:
512: x_qqhv_rec_type := lx_qqhv_rec_type;

Line 509: RAISE okl_api.g_exception_unexpected_error;

505:
506: IF (l_return_status = okl_api.g_ret_sts_error) THEN
507: RAISE okl_api.g_exception_error;
508: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
509: RAISE okl_api.g_exception_unexpected_error;
510: END IF;
511:
512: x_qqhv_rec_type := lx_qqhv_rec_type;
513:

Line 515: okl_api.end_activity(x_msg_count => x_msg_count

511:
512: x_qqhv_rec_type := lx_qqhv_rec_type;
513:
514: x_return_status := l_return_status;
515: okl_api.end_activity(x_msg_count => x_msg_count
516: ,x_msg_data => x_msg_data);
517:
518: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
519: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 525: WHEN okl_api.g_exception_error THEN

521: ,'end debug OKLRQQHB.pls call update_qqh');
522: END IF;
523:
524: EXCEPTION
525: WHEN okl_api.g_exception_error THEN
526: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
527: ,p_pkg_name => g_pkg_name
528: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
529: ,x_msg_count => x_msg_count

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

522: END IF;
523:
524: EXCEPTION
525: WHEN okl_api.g_exception_error THEN
526: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
527: ,p_pkg_name => g_pkg_name
528: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
529: ,x_msg_count => x_msg_count
530: ,x_msg_data => x_msg_data

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

524: EXCEPTION
525: WHEN okl_api.g_exception_error THEN
526: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
527: ,p_pkg_name => g_pkg_name
528: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
529: ,x_msg_count => x_msg_count
530: ,x_msg_data => x_msg_data
531: ,p_api_type => g_api_type);
532: WHEN okl_api.g_exception_unexpected_error THEN

Line 532: WHEN okl_api.g_exception_unexpected_error THEN

528: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
529: ,x_msg_count => x_msg_count
530: ,x_msg_data => x_msg_data
531: ,p_api_type => g_api_type);
532: WHEN okl_api.g_exception_unexpected_error THEN
533: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
534: ,p_pkg_name => g_pkg_name
535: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
536: ,x_msg_count => x_msg_count

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

529: ,x_msg_count => x_msg_count
530: ,x_msg_data => x_msg_data
531: ,p_api_type => g_api_type);
532: WHEN okl_api.g_exception_unexpected_error THEN
533: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
534: ,p_pkg_name => g_pkg_name
535: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
536: ,x_msg_count => x_msg_count
537: ,x_msg_data => x_msg_data

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

531: ,p_api_type => g_api_type);
532: WHEN okl_api.g_exception_unexpected_error THEN
533: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
534: ,p_pkg_name => g_pkg_name
535: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
536: ,x_msg_count => x_msg_count
537: ,x_msg_data => x_msg_data
538: ,p_api_type => g_api_type);
539: WHEN OTHERS THEN

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

536: ,x_msg_count => x_msg_count
537: ,x_msg_data => x_msg_data
538: ,p_api_type => g_api_type);
539: WHEN OTHERS THEN
540: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
541: ,p_pkg_name => g_pkg_name
542: ,p_exc_name => 'OTHERS'
543: ,x_msg_count => x_msg_count
544: ,x_msg_data => x_msg_data

Line 561: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

557: -- End of Comments
558: -----------------------------------------------------------------------------
559:
560: procedure cancel_quick_quote(p_api_version IN NUMBER
561: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
562: ,x_return_status OUT NOCOPY VARCHAR2
563: ,x_msg_count OUT NOCOPY NUMBER
564: ,x_msg_data OUT NOCOPY VARCHAR2
565: ,p_qqhv_rec_type IN qqhv_rec_type

Line 576: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

572: is_debug_procedure_on BOOLEAN;
573: is_debug_statement_on BOOLEAN;
574: l_api_name CONSTANT VARCHAR2(30) := 'cancel_quick_quote';
575: l_api_version CONSTANT NUMBER := 1.0;
576: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
577:
578: BEGIN
579: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
580: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

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

590:
591: -- call START_ACTIVITY to create savepoint, check compatibility
592: -- and initialize message list
593:
594: l_return_status := okl_api.start_activity(p_api_name => l_api_name
595: ,p_pkg_name => g_pkg_name
596: ,p_init_msg_list => p_init_msg_list
597: ,l_api_version => l_api_version
598: ,p_api_version => p_api_version

Line 605: ,okl_api.g_false

601:
602: lp_qqhv_rec_type := p_qqhv_rec_type;
603: lp_qqhv_rec_type.sts_code := QQ_CANCELLED;
604: okl_qqh_pvt.update_row(p_api_version
605: ,okl_api.g_false
606: ,l_return_status
607: ,x_msg_count
608: ,x_msg_data
609: ,lp_qqhv_rec_type

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

617: ' x_msg_data ' ||
618: x_msg_data);
619: END IF; -- end of l_debug_enabled ='Y'
620:
621: IF (l_return_status = okl_api.g_ret_sts_error) THEN
622: RAISE okl_api.g_exception_error;
623: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
624: RAISE okl_api.g_exception_unexpected_error;
625: END IF;

Line 622: RAISE okl_api.g_exception_error;

618: x_msg_data);
619: END IF; -- end of l_debug_enabled ='Y'
620:
621: IF (l_return_status = okl_api.g_ret_sts_error) THEN
622: RAISE okl_api.g_exception_error;
623: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
624: RAISE okl_api.g_exception_unexpected_error;
625: END IF;
626:

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

619: END IF; -- end of l_debug_enabled ='Y'
620:
621: IF (l_return_status = okl_api.g_ret_sts_error) THEN
622: RAISE okl_api.g_exception_error;
623: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
624: RAISE okl_api.g_exception_unexpected_error;
625: END IF;
626:
627: x_qqhv_rec_type := lx_qqhv_rec_type;

Line 624: RAISE okl_api.g_exception_unexpected_error;

620:
621: IF (l_return_status = okl_api.g_ret_sts_error) THEN
622: RAISE okl_api.g_exception_error;
623: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
624: RAISE okl_api.g_exception_unexpected_error;
625: END IF;
626:
627: x_qqhv_rec_type := lx_qqhv_rec_type;
628:

Line 630: okl_api.end_activity(x_msg_count => x_msg_count

626:
627: x_qqhv_rec_type := lx_qqhv_rec_type;
628:
629: x_return_status := l_return_status;
630: okl_api.end_activity(x_msg_count => x_msg_count
631: ,x_msg_data => x_msg_data);
632:
633: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
634: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 640: WHEN okl_api.g_exception_error THEN

636: ,'end debug OKLRQQHB.pls call cancel_quick_quote');
637: END IF;
638:
639: EXCEPTION
640: WHEN okl_api.g_exception_error THEN
641: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
642: ,p_pkg_name => g_pkg_name
643: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
644: ,x_msg_count => x_msg_count

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

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

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

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

Line 647: WHEN okl_api.g_exception_unexpected_error THEN

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

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

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

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

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

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

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

Line 669: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

665:
666:
667:
668: PROCEDURE update_qql (p_api_version IN NUMBER
669: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
670: ,x_return_status OUT NOCOPY VARCHAR2
671: ,x_msg_count OUT NOCOPY NUMBER
672: ,x_msg_data OUT NOCOPY VARCHAR2
673: ,p_qqlv_tbl_type IN qqlv_tbl_type

Line 684: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

680: is_debug_procedure_on BOOLEAN;
681: is_debug_statement_on BOOLEAN;
682: l_api_name CONSTANT VARCHAR2(30) := 'update_qql';
683: l_api_version CONSTANT NUMBER := 1.0;
684: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
685:
686: BEGIN
687: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
688: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

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

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

Line 713: ,okl_api.g_false

709:
710: IF lp_qqlv_tbl_type.COUNT > 0 THEN
711:
712: okl_qql_pvt.update_row(p_api_version
713: ,okl_api.g_false
714: ,l_return_status
715: ,x_msg_count
716: ,x_msg_data
717: ,lp_qqlv_tbl_type

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

723: l_return_status ||
724: ' x_msg_data ' ||
725: x_msg_data);
726: END IF; -- end of l_debug_enabled ='Y'
727: IF (l_return_status = okl_api.g_ret_sts_error) THEN
728: RAISE okl_api.g_exception_error;
729: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
730: RAISE okl_api.g_exception_unexpected_error;
731: END IF;

Line 728: RAISE okl_api.g_exception_error;

724: ' x_msg_data ' ||
725: x_msg_data);
726: END IF; -- end of l_debug_enabled ='Y'
727: IF (l_return_status = okl_api.g_ret_sts_error) THEN
728: RAISE okl_api.g_exception_error;
729: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
730: RAISE okl_api.g_exception_unexpected_error;
731: END IF;
732:

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

725: x_msg_data);
726: END IF; -- end of l_debug_enabled ='Y'
727: IF (l_return_status = okl_api.g_ret_sts_error) THEN
728: RAISE okl_api.g_exception_error;
729: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
730: RAISE okl_api.g_exception_unexpected_error;
731: END IF;
732:
733: END IF;

Line 730: RAISE okl_api.g_exception_unexpected_error;

726: END IF; -- end of l_debug_enabled ='Y'
727: IF (l_return_status = okl_api.g_ret_sts_error) THEN
728: RAISE okl_api.g_exception_error;
729: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
730: RAISE okl_api.g_exception_unexpected_error;
731: END IF;
732:
733: END IF;
734:

Line 739: okl_api.end_activity(x_msg_count => x_msg_count

735: --Assign value to OUT variables
736:
737: x_qqlv_tbl_type := lx_qqlv_tbl_type;
738: x_return_status := l_return_status;
739: okl_api.end_activity(x_msg_count => x_msg_count
740: ,x_msg_data => x_msg_data);
741:
742: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
743: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 749: WHEN okl_api.g_exception_error THEN

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

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

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

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

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

Line 756: WHEN okl_api.g_exception_unexpected_error THEN

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

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

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

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

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

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

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

Line 773: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

769: ,p_api_type => g_api_type);
770: END update_qql;
771:
772: PROCEDURE update_quick_qte(p_api_version IN NUMBER
773: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
774: ,x_return_status OUT NOCOPY VARCHAR2
775: ,x_msg_count OUT NOCOPY NUMBER
776: ,x_msg_data OUT NOCOPY VARCHAR2
777: ,p_qqhv_rec_type IN qqhv_rec_type

Line 792: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

788: is_debug_procedure_on BOOLEAN;
789: is_debug_statement_on BOOLEAN;
790: l_api_name CONSTANT VARCHAR2(30) := 'update_quick_qte';
791: l_api_version CONSTANT NUMBER := 1.0;
792: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
793:
794: BEGIN
795: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
796: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

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

806:
807: -- call START_ACTIVITY to create savepoint, check compatibility
808: -- and initialize message list
809:
810: l_return_status := okl_api.start_activity(p_api_name => l_api_name
811: ,p_pkg_name => g_pkg_name
812: ,p_init_msg_list => p_init_msg_list
813: ,l_api_version => l_api_version
814: ,p_api_version => p_api_version

Line 823: ,p_init_msg_list => okl_api.g_false

819: lp_qqlv_tbl_type := p_qqlv_tbl_type;
820:
821: okl_quick_quotes_pvt.update_qqh(
822: p_api_version => p_api_version
823: ,p_init_msg_list => okl_api.g_false
824: ,x_return_status => l_return_status
825: ,x_msg_count => x_msg_count
826: ,x_msg_data => x_msg_data
827: ,p_qqhv_rec_type => lp_qqhv_rec_type

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

836: ' x_msg_data ' ||
837: x_msg_data);
838: END IF; -- end of l_debug_enabled ='Y'
839:
840: IF (l_return_status = okl_api.g_ret_sts_error) THEN
841: RAISE okl_api.g_exception_error;
842: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
843: RAISE okl_api.g_exception_unexpected_error;
844: END IF;

Line 841: RAISE okl_api.g_exception_error;

837: x_msg_data);
838: END IF; -- end of l_debug_enabled ='Y'
839:
840: IF (l_return_status = okl_api.g_ret_sts_error) THEN
841: RAISE okl_api.g_exception_error;
842: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
843: RAISE okl_api.g_exception_unexpected_error;
844: END IF;
845:

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

838: END IF; -- end of l_debug_enabled ='Y'
839:
840: IF (l_return_status = okl_api.g_ret_sts_error) THEN
841: RAISE okl_api.g_exception_error;
842: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
843: RAISE okl_api.g_exception_unexpected_error;
844: END IF;
845:
846: okl_quick_quotes_pvt.update_qql(

Line 843: RAISE okl_api.g_exception_unexpected_error;

839:
840: IF (l_return_status = okl_api.g_ret_sts_error) THEN
841: RAISE okl_api.g_exception_error;
842: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
843: RAISE okl_api.g_exception_unexpected_error;
844: END IF;
845:
846: okl_quick_quotes_pvt.update_qql(
847: p_api_version => p_api_version

Line 848: ,p_init_msg_list => okl_api.g_false

844: END IF;
845:
846: okl_quick_quotes_pvt.update_qql(
847: p_api_version => p_api_version
848: ,p_init_msg_list => okl_api.g_false
849: ,x_return_status => l_return_status
850: ,x_msg_count => x_msg_count
851: ,x_msg_data => x_msg_data
852: ,p_qqlv_tbl_type => lp_qqlv_tbl_type

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

861: ' x_msg_data ' ||
862: x_msg_data);
863: END IF; -- end of l_debug_enabled ='Y'
864:
865: IF (l_return_status = okl_api.g_ret_sts_error) THEN
866: RAISE okl_api.g_exception_error;
867: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
868: RAISE okl_api.g_exception_unexpected_error;
869: END IF;

Line 866: RAISE okl_api.g_exception_error;

862: x_msg_data);
863: END IF; -- end of l_debug_enabled ='Y'
864:
865: IF (l_return_status = okl_api.g_ret_sts_error) THEN
866: RAISE okl_api.g_exception_error;
867: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
868: RAISE okl_api.g_exception_unexpected_error;
869: END IF;
870:

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

863: END IF; -- end of l_debug_enabled ='Y'
864:
865: IF (l_return_status = okl_api.g_ret_sts_error) THEN
866: RAISE okl_api.g_exception_error;
867: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
868: RAISE okl_api.g_exception_unexpected_error;
869: END IF;
870:
871: x_qqhv_rec_type := lx_qqhv_rec_type;

Line 868: RAISE okl_api.g_exception_unexpected_error;

864:
865: IF (l_return_status = okl_api.g_ret_sts_error) THEN
866: RAISE okl_api.g_exception_error;
867: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
868: RAISE okl_api.g_exception_unexpected_error;
869: END IF;
870:
871: x_qqhv_rec_type := lx_qqhv_rec_type;
872: x_qqlv_tbl_type := lx_qqlv_tbl_type;

Line 874: okl_api.end_activity(x_msg_count => x_msg_count

870:
871: x_qqhv_rec_type := lx_qqhv_rec_type;
872: x_qqlv_tbl_type := lx_qqlv_tbl_type;
873: x_return_status := l_return_status;
874: okl_api.end_activity(x_msg_count => x_msg_count
875: ,x_msg_data => x_msg_data);
876:
877: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
878: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 884: WHEN okl_api.g_exception_error THEN

880: ,'end debug OKLRQQHB.pls call update_quick_qte');
881: END IF;
882:
883: EXCEPTION
884: WHEN okl_api.g_exception_error THEN
885: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
886: ,p_pkg_name => g_pkg_name
887: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
888: ,x_msg_count => x_msg_count

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

881: END IF;
882:
883: EXCEPTION
884: WHEN okl_api.g_exception_error THEN
885: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
886: ,p_pkg_name => g_pkg_name
887: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
888: ,x_msg_count => x_msg_count
889: ,x_msg_data => x_msg_data

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

883: EXCEPTION
884: WHEN okl_api.g_exception_error THEN
885: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
886: ,p_pkg_name => g_pkg_name
887: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
888: ,x_msg_count => x_msg_count
889: ,x_msg_data => x_msg_data
890: ,p_api_type => g_api_type);
891: WHEN okl_api.g_exception_unexpected_error THEN

Line 891: WHEN okl_api.g_exception_unexpected_error THEN

887: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
888: ,x_msg_count => x_msg_count
889: ,x_msg_data => x_msg_data
890: ,p_api_type => g_api_type);
891: WHEN okl_api.g_exception_unexpected_error THEN
892: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
893: ,p_pkg_name => g_pkg_name
894: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
895: ,x_msg_count => x_msg_count

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

888: ,x_msg_count => x_msg_count
889: ,x_msg_data => x_msg_data
890: ,p_api_type => g_api_type);
891: WHEN okl_api.g_exception_unexpected_error THEN
892: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
893: ,p_pkg_name => g_pkg_name
894: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
895: ,x_msg_count => x_msg_count
896: ,x_msg_data => x_msg_data

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

890: ,p_api_type => g_api_type);
891: WHEN okl_api.g_exception_unexpected_error THEN
892: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
893: ,p_pkg_name => g_pkg_name
894: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
895: ,x_msg_count => x_msg_count
896: ,x_msg_data => x_msg_data
897: ,p_api_type => g_api_type);
898: WHEN OTHERS THEN

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

895: ,x_msg_count => x_msg_count
896: ,x_msg_data => x_msg_data
897: ,p_api_type => g_api_type);
898: WHEN OTHERS THEN
899: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
900: ,p_pkg_name => g_pkg_name
901: ,p_exc_name => 'OTHERS'
902: ,x_msg_count => x_msg_count
903: ,x_msg_data => x_msg_data

Line 908: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

904: ,p_api_type => g_api_type);
905: END update_quick_qte;
906:
907: PROCEDURE delete_qql(p_api_version IN NUMBER
908: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
909: ,x_return_status OUT NOCOPY VARCHAR2
910: ,x_msg_count OUT NOCOPY NUMBER
911: ,x_msg_data OUT NOCOPY VARCHAR2
912: ,p_qqlv_rec_type IN qqlv_rec_type) IS

Line 916: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

912: ,p_qqlv_rec_type IN qqlv_rec_type) IS
913:
914: l_api_name CONSTANT VARCHAR2(30) := 'delete_qql';
915: l_api_version CONSTANT NUMBER := 1.0;
916: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
917: l_qqlv_rec qqlv_rec_type := p_qqlv_rec_type;
918: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';
919: l_debug_enabled VARCHAR2(10);
920: is_debug_procedure_on BOOLEAN;

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

935:
936: -- call START_ACTIVITY to create savepoint, check compatibility
937: -- and initialize message list
938:
939: l_return_status := okl_api.start_activity(p_api_name => l_api_name
940: ,p_pkg_name => g_pkg_name
941: ,p_init_msg_list => p_init_msg_list
942: ,l_api_version => l_api_version
943: ,p_api_version => p_api_version

Line 964: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

960: ' x_msg_data ' ||
961: x_msg_data);
962: END IF; -- end of l_debug_enabled ='Y'
963:
964: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
965: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
966: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
967: RAISE OKL_API.G_EXCEPTION_ERROR;
968: END IF;

Line 965: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

961: x_msg_data);
962: END IF; -- end of l_debug_enabled ='Y'
963:
964: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
965: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
966: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
967: RAISE OKL_API.G_EXCEPTION_ERROR;
968: END IF;
969:

Line 966: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

962: END IF; -- end of l_debug_enabled ='Y'
963:
964: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
965: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
966: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
967: RAISE OKL_API.G_EXCEPTION_ERROR;
968: END IF;
969:
970: okl_api.end_activity(x_msg_count => x_msg_count

Line 967: RAISE OKL_API.G_EXCEPTION_ERROR;

963:
964: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
965: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
966: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
967: RAISE OKL_API.G_EXCEPTION_ERROR;
968: END IF;
969:
970: okl_api.end_activity(x_msg_count => x_msg_count
971: ,x_msg_data => x_msg_data);

Line 970: okl_api.end_activity(x_msg_count => x_msg_count

966: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
967: RAISE OKL_API.G_EXCEPTION_ERROR;
968: END IF;
969:
970: okl_api.end_activity(x_msg_count => x_msg_count
971: ,x_msg_data => x_msg_data);
972:
973: x_return_status := l_return_status;
974: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 981: WHEN okl_api.g_exception_error THEN

977: ,'end debug OKLRQQHB.pls call delete_qql');
978: END IF;
979:
980: EXCEPTION
981: WHEN okl_api.g_exception_error THEN
982: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
983: ,p_pkg_name => g_pkg_name
984: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
985: ,x_msg_count => x_msg_count

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

978: END IF;
979:
980: EXCEPTION
981: WHEN okl_api.g_exception_error THEN
982: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
983: ,p_pkg_name => g_pkg_name
984: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
985: ,x_msg_count => x_msg_count
986: ,x_msg_data => x_msg_data

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

980: EXCEPTION
981: WHEN okl_api.g_exception_error THEN
982: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
983: ,p_pkg_name => g_pkg_name
984: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
985: ,x_msg_count => x_msg_count
986: ,x_msg_data => x_msg_data
987: ,p_api_type => g_api_type);
988: WHEN okl_api.g_exception_unexpected_error THEN

Line 988: WHEN okl_api.g_exception_unexpected_error THEN

984: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
985: ,x_msg_count => x_msg_count
986: ,x_msg_data => x_msg_data
987: ,p_api_type => g_api_type);
988: WHEN okl_api.g_exception_unexpected_error THEN
989: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
990: ,p_pkg_name => g_pkg_name
991: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
992: ,x_msg_count => x_msg_count

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

985: ,x_msg_count => x_msg_count
986: ,x_msg_data => x_msg_data
987: ,p_api_type => g_api_type);
988: WHEN okl_api.g_exception_unexpected_error THEN
989: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
990: ,p_pkg_name => g_pkg_name
991: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
992: ,x_msg_count => x_msg_count
993: ,x_msg_data => x_msg_data

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

987: ,p_api_type => g_api_type);
988: WHEN okl_api.g_exception_unexpected_error THEN
989: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
990: ,p_pkg_name => g_pkg_name
991: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
992: ,x_msg_count => x_msg_count
993: ,x_msg_data => x_msg_data
994: ,p_api_type => g_api_type);
995: WHEN OTHERS THEN

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

992: ,x_msg_count => x_msg_count
993: ,x_msg_data => x_msg_data
994: ,p_api_type => g_api_type);
995: WHEN OTHERS THEN
996: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
997: ,p_pkg_name => g_pkg_name
998: ,p_exc_name => 'OTHERS'
999: ,x_msg_count => x_msg_count
1000: ,x_msg_data => x_msg_data

Line 1005: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1001: ,p_api_type => g_api_type);
1002: END delete_qql;
1003:
1004: PROCEDURE delete_qql(p_api_version IN NUMBER
1005: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1006: ,x_return_status OUT NOCOPY VARCHAR2
1007: ,x_msg_count OUT NOCOPY NUMBER
1008: ,x_msg_data OUT NOCOPY VARCHAR2
1009: ,p_qqlv_tbl_type IN qqlv_tbl_type) IS

Line 1013: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1009: ,p_qqlv_tbl_type IN qqlv_tbl_type) IS
1010:
1011: l_api_name CONSTANT VARCHAR2(30) := 'delete_qql';
1012: l_api_version CONSTANT NUMBER := 1.0;
1013: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1014: l_qqlv_tbl qqlv_tbl_type := p_qqlv_tbl_type;
1015: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';
1016: l_debug_enabled VARCHAR2(10);
1017: is_debug_procedure_on BOOLEAN;

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

1032:
1033: -- call START_ACTIVITY to create savepoint, check compatibility
1034: -- and initialize message list
1035:
1036: l_return_status := okl_api.start_activity(p_api_name => l_api_name
1037: ,p_pkg_name => g_pkg_name
1038: ,p_init_msg_list => p_init_msg_list
1039: ,l_api_version => l_api_version
1040: ,p_api_version => p_api_version

Line 1061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1057: ' x_msg_data ' ||
1058: x_msg_data);
1059: END IF; -- end of l_debug_enabled ='Y'
1060:
1061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_ERROR;
1065: END IF;

Line 1062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1058: x_msg_data);
1059: END IF; -- end of l_debug_enabled ='Y'
1060:
1061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_ERROR;
1065: END IF;
1066:

Line 1063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1059: END IF; -- end of l_debug_enabled ='Y'
1060:
1061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_ERROR;
1065: END IF;
1066:
1067: okl_api.end_activity(x_msg_count => x_msg_count

Line 1064: RAISE OKL_API.G_EXCEPTION_ERROR;

1060:
1061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_ERROR;
1065: END IF;
1066:
1067: okl_api.end_activity(x_msg_count => x_msg_count
1068: ,x_msg_data => x_msg_data);

Line 1067: okl_api.end_activity(x_msg_count => x_msg_count

1063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_ERROR;
1065: END IF;
1066:
1067: okl_api.end_activity(x_msg_count => x_msg_count
1068: ,x_msg_data => x_msg_data);
1069:
1070: x_return_status := l_return_status;
1071: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1078: WHEN okl_api.g_exception_error THEN

1074: ,'end debug OKLRQQHB.pls call delete_qql');
1075: END IF;
1076:
1077: EXCEPTION
1078: WHEN okl_api.g_exception_error THEN
1079: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1080: ,p_pkg_name => g_pkg_name
1081: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1082: ,x_msg_count => x_msg_count

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

1075: END IF;
1076:
1077: EXCEPTION
1078: WHEN okl_api.g_exception_error THEN
1079: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1080: ,p_pkg_name => g_pkg_name
1081: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1082: ,x_msg_count => x_msg_count
1083: ,x_msg_data => x_msg_data

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

1077: EXCEPTION
1078: WHEN okl_api.g_exception_error THEN
1079: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1080: ,p_pkg_name => g_pkg_name
1081: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1082: ,x_msg_count => x_msg_count
1083: ,x_msg_data => x_msg_data
1084: ,p_api_type => g_api_type);
1085: WHEN okl_api.g_exception_unexpected_error THEN

Line 1085: WHEN okl_api.g_exception_unexpected_error THEN

1081: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1082: ,x_msg_count => x_msg_count
1083: ,x_msg_data => x_msg_data
1084: ,p_api_type => g_api_type);
1085: WHEN okl_api.g_exception_unexpected_error THEN
1086: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1087: ,p_pkg_name => g_pkg_name
1088: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
1089: ,x_msg_count => x_msg_count

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

1082: ,x_msg_count => x_msg_count
1083: ,x_msg_data => x_msg_data
1084: ,p_api_type => g_api_type);
1085: WHEN okl_api.g_exception_unexpected_error THEN
1086: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1087: ,p_pkg_name => g_pkg_name
1088: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
1089: ,x_msg_count => x_msg_count
1090: ,x_msg_data => x_msg_data

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

1084: ,p_api_type => g_api_type);
1085: WHEN okl_api.g_exception_unexpected_error THEN
1086: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1087: ,p_pkg_name => g_pkg_name
1088: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
1089: ,x_msg_count => x_msg_count
1090: ,x_msg_data => x_msg_data
1091: ,p_api_type => g_api_type);
1092: WHEN OTHERS THEN

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

1089: ,x_msg_count => x_msg_count
1090: ,x_msg_data => x_msg_data
1091: ,p_api_type => g_api_type);
1092: WHEN OTHERS THEN
1093: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1094: ,p_pkg_name => g_pkg_name
1095: ,p_exc_name => 'OTHERS'
1096: ,x_msg_count => x_msg_count
1097: ,x_msg_data => x_msg_data

Line 1103: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

1099: END delete_qql;
1100:
1101: --method to create or update the quick quote
1102: PROCEDURE handle_quick_quote(p_api_version IN number
1103: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
1104: ,x_return_status OUT NOCOPY varchar2
1105: ,x_msg_count OUT NOCOPY number
1106: ,x_msg_data OUT NOCOPY varchar2
1107: ,p_qqhv_rec_type IN qqhv_rec_type

Line 1124: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1120:
1121: l_api_name CONSTANT VARCHAR2(30) := 'handle_quick_quote';
1122: QQ_ACTIVE CONSTANT okl_quick_quotes_b.sts_code%TYPE :='ACTIVE';
1123: l_api_version CONSTANT NUMBER := 1.0;
1124: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1125:
1126: l_qqhv_rec_type qqhv_rec_type := p_qqhv_rec_type;
1127: l_qqlv_tbl_type qqlv_tbl_type := p_qqlv_tbl_type;
1128: l_cfh_rec_type cashflow_hdr_rec := p_cfh_rec_type;

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

1298:
1299: -- call START_ACTIVITY to create savepoint, check compatibility
1300: -- and initialize message list
1301:
1302: l_return_status := okl_api.start_activity(p_api_name => l_api_name
1303: ,p_pkg_name => g_pkg_name
1304: ,p_init_msg_list => p_init_msg_list
1305: ,l_api_version => l_api_version
1306: ,p_api_version => p_api_version

Line 1343: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1339: -- getting the value of the frequency for the correspoding code
1340: l_months_factor := okl_stream_generator_pvt.get_months_factor(
1341: p_frequency => l_qqhv_rec_type.target_frequency,
1342: x_return_status => x_return_status);
1343: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1344: RAISE okl_api.g_exception_unexpected_error;
1345: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1346: RAISE okl_api.g_exception_error;
1347: END IF;

Line 1344: RAISE okl_api.g_exception_unexpected_error;

1340: l_months_factor := okl_stream_generator_pvt.get_months_factor(
1341: p_frequency => l_qqhv_rec_type.target_frequency,
1342: x_return_status => x_return_status);
1343: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1344: RAISE okl_api.g_exception_unexpected_error;
1345: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1346: RAISE okl_api.g_exception_error;
1347: END IF;
1348: END IF;

Line 1345: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1341: p_frequency => l_qqhv_rec_type.target_frequency,
1342: x_return_status => x_return_status);
1343: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1344: RAISE okl_api.g_exception_unexpected_error;
1345: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1346: RAISE okl_api.g_exception_error;
1347: END IF;
1348: END IF;
1349: -- Pricing Method:rate card and pricing option : Structured pricing

Line 1346: RAISE okl_api.g_exception_error;

1342: x_return_status => x_return_status);
1343: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1344: RAISE okl_api.g_exception_unexpected_error;
1345: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1346: RAISE okl_api.g_exception_error;
1347: END IF;
1348: END IF;
1349: -- Pricing Method:rate card and pricing option : Structured pricing
1350: IF (l_qqhv_rec_type.pricing_method='RC' AND l_qqhv_rec_type.structured_pricing= 'Y') THEN

Line 1426: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1422: lx_qqhv_rec_type,
1423: l_qqlv_tbl_type,
1424: lx_qqlv_tbl_type);
1425:
1426: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1427: RAISE okl_api.g_exception_unexpected_error;
1428: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1429: RAISE okl_api.g_exception_error;
1430: END IF;

Line 1427: RAISE okl_api.g_exception_unexpected_error;

1423: l_qqlv_tbl_type,
1424: lx_qqlv_tbl_type);
1425:
1426: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1427: RAISE okl_api.g_exception_unexpected_error;
1428: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1429: RAISE okl_api.g_exception_error;
1430: END IF;
1431:

Line 1428: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1424: lx_qqlv_tbl_type);
1425:
1426: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1427: RAISE okl_api.g_exception_unexpected_error;
1428: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1429: RAISE okl_api.g_exception_error;
1430: END IF;
1431:
1432: ELSIF (create_yn ='N') THEN

Line 1429: RAISE okl_api.g_exception_error;

1425:
1426: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1427: RAISE okl_api.g_exception_unexpected_error;
1428: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1429: RAISE okl_api.g_exception_error;
1430: END IF;
1431:
1432: ELSIF (create_yn ='N') THEN
1433: -- update the quick quote

Line 1449: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1445: x_msg_data,
1446: l_qqhv_rec_type,
1447: lx_qqhv_rec_type);
1448:
1449: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1450: RAISE okl_api.g_exception_unexpected_error;
1451: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1452: RAISE okl_api.g_exception_error;
1453: END IF;

Line 1450: RAISE okl_api.g_exception_unexpected_error;

1446: l_qqhv_rec_type,
1447: lx_qqhv_rec_type);
1448:
1449: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1450: RAISE okl_api.g_exception_unexpected_error;
1451: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1452: RAISE okl_api.g_exception_error;
1453: END IF;
1454:

Line 1451: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1447: lx_qqhv_rec_type);
1448:
1449: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1450: RAISE okl_api.g_exception_unexpected_error;
1451: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1452: RAISE okl_api.g_exception_error;
1453: END IF;
1454:
1455: l_line_no :=1;

Line 1452: RAISE okl_api.g_exception_error;

1448:
1449: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1450: RAISE okl_api.g_exception_unexpected_error;
1451: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1452: RAISE okl_api.g_exception_error;
1453: END IF;
1454:
1455: l_line_no :=1;
1456: -- delete the existing rows of quick quote lines for the header

Line 1469: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1465: x_msg_count,
1466: x_msg_data,
1467: lxx_qqlv_tbl_type);
1468:
1469: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1470: RAISE okl_api.g_exception_unexpected_error;
1471: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1472: RAISE okl_api.g_exception_error;
1473: END IF;

Line 1470: RAISE okl_api.g_exception_unexpected_error;

1466: x_msg_data,
1467: lxx_qqlv_tbl_type);
1468:
1469: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1470: RAISE okl_api.g_exception_unexpected_error;
1471: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1472: RAISE okl_api.g_exception_error;
1473: END IF;
1474:

Line 1471: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1467: lxx_qqlv_tbl_type);
1468:
1469: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1470: RAISE okl_api.g_exception_unexpected_error;
1471: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1472: RAISE okl_api.g_exception_error;
1473: END IF;
1474:
1475:

Line 1472: RAISE okl_api.g_exception_error;

1468:
1469: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1470: RAISE okl_api.g_exception_unexpected_error;
1471: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1472: RAISE okl_api.g_exception_error;
1473: END IF;
1474:
1475:
1476: -- if there is a new quick quote line that is added, insert it separately

Line 1482: ,okl_api.g_false

1478: -- IF (l_qqlv_tbl_type(l_count).id is null) THEN
1479: l_qqlv_tbl_type(l_count).quick_quote_id:=lx_qqhv_rec_type.id;
1480: -- insert the record
1481: okl_qql_pvt.insert_row(p_api_version
1482: ,okl_api.g_false
1483: ,x_return_status
1484: ,x_msg_count
1485: ,x_msg_data
1486: ,l_qqlv_tbl_type(l_count)

Line 1489: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1485: ,x_msg_data
1486: ,l_qqlv_tbl_type(l_count)
1487: ,lx_qqlv_tbl_type(l_count));
1488:
1489: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1490: RAISE okl_api.g_exception_unexpected_error;
1491: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1492: RAISE okl_api.g_exception_error;
1493: END IF;

Line 1490: RAISE okl_api.g_exception_unexpected_error;

1486: ,l_qqlv_tbl_type(l_count)
1487: ,lx_qqlv_tbl_type(l_count));
1488:
1489: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1490: RAISE okl_api.g_exception_unexpected_error;
1491: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1492: RAISE okl_api.g_exception_error;
1493: END IF;
1494: END LOOP;

Line 1491: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1487: ,lx_qqlv_tbl_type(l_count));
1488:
1489: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1490: RAISE okl_api.g_exception_unexpected_error;
1491: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1492: RAISE okl_api.g_exception_error;
1493: END IF;
1494: END LOOP;
1495: -- call to cash flow delete API to delete the cash flows

Line 1492: RAISE okl_api.g_exception_error;

1488:
1489: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1490: RAISE okl_api.g_exception_unexpected_error;
1491: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1492: RAISE okl_api.g_exception_error;
1493: END IF;
1494: END LOOP;
1495: -- call to cash flow delete API to delete the cash flows
1496: -- delete the cash flows for the quote type

Line 1507: ,OKL_API.G_FALSE

1503:
1504: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (
1505: l_api_version
1506: ,p_init_msg_list
1507: ,OKL_API.G_FALSE
1508: ,l_oty_code --dkagrawa changed source table name to soucrce object code
1509: ,l_qqlv_tbl_type(i).id
1510: ,x_return_status
1511: ,x_msg_count

Line 1514: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1510: ,x_return_status
1511: ,x_msg_count
1512: ,x_msg_data
1513: );
1514: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1515: RAISE okl_api.g_exception_unexpected_error;
1516: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1517: RAISE okl_api.g_exception_error;
1518: END IF;

Line 1515: RAISE okl_api.g_exception_unexpected_error;

1511: ,x_msg_count
1512: ,x_msg_data
1513: );
1514: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1515: RAISE okl_api.g_exception_unexpected_error;
1516: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1517: RAISE okl_api.g_exception_error;
1518: END IF;
1519:

Line 1516: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1512: ,x_msg_data
1513: );
1514: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1515: RAISE okl_api.g_exception_unexpected_error;
1516: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1517: RAISE okl_api.g_exception_error;
1518: END IF;
1519:
1520: END IF;

Line 1517: RAISE okl_api.g_exception_error;

1513: );
1514: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1515: RAISE okl_api.g_exception_unexpected_error;
1516: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1517: RAISE okl_api.g_exception_error;
1518: END IF;
1519:
1520: END IF;
1521: END LOOP;

Line 1527: ,OKL_API.G_FALSE

1523: -- delete cash flows for the header
1524: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (
1525: l_api_version
1526: ,p_init_msg_list
1527: ,OKL_API.G_FALSE
1528: ,'QUICK_QUOTE' --dkagrawa changed source table name to soucrce object code
1529: ,l_qqhv_rec_type.id
1530: ,x_return_status
1531: ,x_msg_count

Line 1535: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1531: ,x_msg_count
1532: ,x_msg_data
1533: );
1534:
1535: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1536: RAISE okl_api.g_exception_unexpected_error;
1537: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1538: RAISE okl_api.g_exception_error;
1539: END IF;

Line 1536: RAISE okl_api.g_exception_unexpected_error;

1532: ,x_msg_data
1533: );
1534:
1535: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1536: RAISE okl_api.g_exception_unexpected_error;
1537: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1538: RAISE okl_api.g_exception_error;
1539: END IF;
1540: -- delete the quick quote lines

Line 1537: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1533: );
1534:
1535: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1536: RAISE okl_api.g_exception_unexpected_error;
1537: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1538: RAISE okl_api.g_exception_error;
1539: END IF;
1540: -- delete the quick quote lines
1541: -- viselvar updated. Instead of deletion and creating the quick quotes,

Line 1538: RAISE okl_api.g_exception_error;

1534:
1535: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1536: RAISE okl_api.g_exception_unexpected_error;
1537: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1538: RAISE okl_api.g_exception_error;
1539: END IF;
1540: -- delete the quick quote lines
1541: -- viselvar updated. Instead of deletion and creating the quick quotes,
1542: -- updation of the quick quotes is done

Line 1550: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1546: x_msg_count,
1547: x_msg_data,
1548: l_qqlv_tbl_type);
1549:
1550: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1551: RAISE okl_api.g_exception_unexpected_error;
1552: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1553: RAISE okl_api.g_exception_error;
1554: END IF;

Line 1551: RAISE okl_api.g_exception_unexpected_error;

1547: x_msg_data,
1548: l_qqlv_tbl_type);
1549:
1550: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1551: RAISE okl_api.g_exception_unexpected_error;
1552: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1553: RAISE okl_api.g_exception_error;
1554: END IF;
1555:

Line 1552: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1548: l_qqlv_tbl_type);
1549:
1550: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1551: RAISE okl_api.g_exception_unexpected_error;
1552: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1553: RAISE okl_api.g_exception_error;
1554: END IF;
1555:
1556: -- delete the quick quote header

Line 1553: RAISE okl_api.g_exception_error;

1549:
1550: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1551: RAISE okl_api.g_exception_unexpected_error;
1552: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1553: RAISE okl_api.g_exception_error;
1554: END IF;
1555:
1556: -- delete the quick quote header
1557: okl_qqh_pvt.delete_row(l_api_version,

Line 1620: OKL_API.G_FALSE,

1616: -- create the cahflows for the rent stream other than the rate card method
1617: if (l_qqhv_rec_type.pricing_method <>'RC' and l_qqhv_rec_type.pricing_method <>'TR') THEN
1618: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(l_api_version,
1619: p_init_msg_list,
1620: OKL_API.G_FALSE,
1621: l_cfh_rec_type,
1622: l_cfl_tbl_type,
1623: x_return_status,
1624: x_msg_count,

Line 1628: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1624: x_msg_count,
1625: x_msg_data
1626: );
1627:
1628: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1629: RAISE okl_api.g_exception_unexpected_error;
1630: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1631: RAISE okl_api.g_exception_error;
1632: END IF;

Line 1629: RAISE okl_api.g_exception_unexpected_error;

1625: x_msg_data
1626: );
1627:
1628: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1629: RAISE okl_api.g_exception_unexpected_error;
1630: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1631: RAISE okl_api.g_exception_error;
1632: END IF;
1633:

Line 1630: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1626: );
1627:
1628: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1629: RAISE okl_api.g_exception_unexpected_error;
1630: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1631: RAISE okl_api.g_exception_error;
1632: END IF;
1633:
1634: end if;

Line 1631: RAISE okl_api.g_exception_error;

1627:
1628: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1629: RAISE okl_api.g_exception_unexpected_error;
1630: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1631: RAISE okl_api.g_exception_error;
1632: END IF;
1633:
1634: end if;
1635: -- create the cash flows necessary for the quick quote

Line 1706: OKL_API.G_FALSE,

1702:
1703: -- create the cahflows for the correspoding streams
1704: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(l_api_version,
1705: p_init_msg_list,
1706: OKL_API.G_FALSE,
1707: l_cfh_other_rec,
1708: l_cfl_other_tbl,
1709: x_return_status,
1710: x_msg_count,

Line 1713: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1709: x_return_status,
1710: x_msg_count,
1711: x_msg_data);
1712:
1713: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1714: RAISE okl_api.g_exception_unexpected_error;
1715: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1716: RAISE okl_api.g_exception_error;
1717: END IF;

Line 1714: RAISE okl_api.g_exception_unexpected_error;

1710: x_msg_count,
1711: x_msg_data);
1712:
1713: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1714: RAISE okl_api.g_exception_unexpected_error;
1715: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1716: RAISE okl_api.g_exception_error;
1717: END IF;
1718:

Line 1715: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1711: x_msg_data);
1712:
1713: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1714: RAISE okl_api.g_exception_unexpected_error;
1715: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1716: RAISE okl_api.g_exception_error;
1717: END IF;
1718:
1719: END IF;

Line 1716: RAISE okl_api.g_exception_error;

1712:
1713: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1714: RAISE okl_api.g_exception_unexpected_error;
1715: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1716: RAISE okl_api.g_exception_error;
1717: END IF;
1718:
1719: END IF;
1720: END LOOP;

Line 1739: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1735: x_qa_result => x_qa_result,
1736: x_qa_result_tbl => x_qa_result_tbl
1737: );
1738:
1739: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1740: RAISE okl_api.g_exception_unexpected_error;
1741: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1742: RAISE okl_api.g_exception_error;
1743: END IF;

Line 1740: RAISE okl_api.g_exception_unexpected_error;

1736: x_qa_result_tbl => x_qa_result_tbl
1737: );
1738:
1739: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1740: RAISE okl_api.g_exception_unexpected_error;
1741: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1742: RAISE okl_api.g_exception_error;
1743: END IF;
1744:

Line 1741: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1737: );
1738:
1739: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1740: RAISE okl_api.g_exception_unexpected_error;
1741: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1742: RAISE okl_api.g_exception_error;
1743: END IF;
1744:
1745: -- viselvar added

Line 1742: RAISE okl_api.g_exception_error;

1738:
1739: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1740: RAISE okl_api.g_exception_unexpected_error;
1741: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1742: RAISE okl_api.g_exception_error;
1743: END IF;
1744:
1745: -- viselvar added
1746: IF (x_qa_result= 'E') THEN

Line 1751: okl_api.set_message(p_app_name => G_APP_NAME,

1747: count_num:=0;
1748: FOR num_of_row IN x_qa_result_tbl.first .. x_qa_result_tbl.last LOOP
1749: IF (x_qa_result_tbl(num_of_row).result_code = 'ERROR' ) THEN
1750: count_num:= count_num +1;
1751: okl_api.set_message(p_app_name => G_APP_NAME,
1752: p_msg_name => x_qa_result_tbl(num_of_row).message_code );
1753: END IF;
1754: if (count_num = 3) then
1755: exit;

Line 1759: RAISE okl_api.g_exception_error;

1755: exit;
1756: end if;
1757: END LOOP;
1758: -- raise the exception
1759: RAISE okl_api.g_exception_error;
1760: END IF;
1761:
1762: okl_pricing_utils_pvt.price_quick_quote(
1763: l_api_version,

Line 1774: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1770: sub_yields_rec,
1771: pricing_results_table
1772: );
1773:
1774: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1775: RAISE okl_api.g_exception_unexpected_error;
1776: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1777: RAISE okl_api.g_exception_error;
1778: END IF;

Line 1775: RAISE okl_api.g_exception_unexpected_error;

1771: pricing_results_table
1772: );
1773:
1774: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1775: RAISE okl_api.g_exception_unexpected_error;
1776: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1777: RAISE okl_api.g_exception_error;
1778: END IF;
1779:

Line 1776: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1772: );
1773:
1774: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1775: RAISE okl_api.g_exception_unexpected_error;
1776: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1777: RAISE okl_api.g_exception_error;
1778: END IF;
1779:
1780: FOR i IN pricing_results_table.FIRST ..pricing_results_table.LAST LOOP

Line 1777: RAISE okl_api.g_exception_error;

1773:
1774: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1775: RAISE okl_api.g_exception_unexpected_error;
1776: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1777: RAISE okl_api.g_exception_error;
1778: END IF;
1779:
1780: FOR i IN pricing_results_table.FIRST ..pricing_results_table.LAST LOOP
1781: IF (pricing_results_table(i).LINE_TYPE='FREE_FORM1') THEN

Line 1820: ,okl_api.g_false

1816: lp_qqlv_rec.VALUE:=round(pricing_results_table(i).subsidy, l_precision);
1817: lp_qqlv_rec.quick_quote_id:=lx_qqhv_rec_type.id;
1818:
1819: okl_qql_pvt.insert_row(p_api_version
1820: ,okl_api.g_false
1821: ,x_return_status
1822: ,x_msg_count
1823: ,x_msg_data
1824: ,lp_qqlv_rec

Line 1827: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1823: ,x_msg_data
1824: ,lp_qqlv_rec
1825: ,lx_qqlv_rec);
1826:
1827: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1828: RAISE okl_api.g_exception_unexpected_error;
1829: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1830: RAISE okl_api.g_exception_error;
1831: END IF;

Line 1828: RAISE okl_api.g_exception_unexpected_error;

1824: ,lp_qqlv_rec
1825: ,lx_qqlv_rec);
1826:
1827: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1828: RAISE okl_api.g_exception_unexpected_error;
1829: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1830: RAISE okl_api.g_exception_error;
1831: END IF;
1832: END IF;

Line 1829: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1825: ,lx_qqlv_rec);
1826:
1827: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1828: RAISE okl_api.g_exception_unexpected_error;
1829: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1830: RAISE okl_api.g_exception_error;
1831: END IF;
1832: END IF;
1833: -- rate card pricing method

Line 1830: RAISE okl_api.g_exception_error;

1826:
1827: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1828: RAISE okl_api.g_exception_unexpected_error;
1829: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1830: RAISE okl_api.g_exception_error;
1831: END IF;
1832: END IF;
1833: -- rate card pricing method
1834: IF (p_qqhv_rec_type.pricing_method = 'RC') THEN

Line 1882: OKL_API.G_FALSE,

1878: --Fix Bug # 5184214 ssdeshpa end
1879:
1880: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(l_api_version,
1881: p_init_msg_list,
1882: OKL_API.G_FALSE,
1883: l_cfh_rec_type,
1884: l_cfl_tbl_type,
1885: x_return_status,
1886: x_msg_count,

Line 1890: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1886: x_msg_count,
1887: x_msg_data
1888: );
1889:
1890: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1891: RAISE okl_api.g_exception_unexpected_error;
1892: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1893: RAISE okl_api.g_exception_error;
1894: END IF;

Line 1891: RAISE okl_api.g_exception_unexpected_error;

1887: x_msg_data
1888: );
1889:
1890: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1891: RAISE okl_api.g_exception_unexpected_error;
1892: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1893: RAISE okl_api.g_exception_error;
1894: END IF;
1895:

Line 1892: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1888: );
1889:
1890: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1891: RAISE okl_api.g_exception_unexpected_error;
1892: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1893: RAISE okl_api.g_exception_error;
1894: END IF;
1895:
1896: rate_card_num:= rate_card_num + 1;

Line 1893: RAISE okl_api.g_exception_error;

1889:
1890: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1891: RAISE okl_api.g_exception_unexpected_error;
1892: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1893: RAISE okl_api.g_exception_error;
1894: END IF;
1895:
1896: rate_card_num:= rate_card_num + 1;
1897: END IF;

Line 1977: OKL_API.G_FALSE,

1973: x_rent_payments_tbl(1).start_date :=l_so_details(1).start_date;
1974:
1975: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(l_api_version,
1976: p_init_msg_list,
1977: OKL_API.G_FALSE,
1978: l_cfh_rec_type,
1979: l_cfl_tbl_type,
1980: x_return_status,
1981: x_msg_count,

Line 1985: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1981: x_msg_count,
1982: x_msg_data
1983: );
1984:
1985: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1986: RAISE okl_api.g_exception_unexpected_error;
1987: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1988: RAISE okl_api.g_exception_error;
1989: END IF;

Line 1986: RAISE okl_api.g_exception_unexpected_error;

1982: x_msg_data
1983: );
1984:
1985: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1986: RAISE okl_api.g_exception_unexpected_error;
1987: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1988: RAISE okl_api.g_exception_error;
1989: END IF;
1990:

Line 1987: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

1983: );
1984:
1985: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1986: RAISE okl_api.g_exception_unexpected_error;
1987: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1988: RAISE okl_api.g_exception_error;
1989: END IF;
1990:
1991: END IF;

Line 1988: RAISE okl_api.g_exception_error;

1984:
1985: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1986: RAISE okl_api.g_exception_unexpected_error;
1987: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1988: RAISE okl_api.g_exception_error;
1989: END IF;
1990:
1991: END IF;
1992:

Line 2040: OKL_API.G_FALSE,

2036: -- updating the cash flows for fees and services for basis other than fixed
2037:
2038: OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow(l_api_version,
2039: p_init_msg_list,
2040: OKL_API.G_FALSE,
2041: l_update_cfh_rec,
2042: l_update_cfl_tbl,
2043: x_return_status,
2044: x_msg_count,

Line 2048: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

2044: x_msg_count,
2045: x_msg_data
2046: );
2047:
2048: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2049: RAISE okl_api.g_exception_unexpected_error;
2050: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2051: RAISE okl_api.g_exception_error;
2052: END IF;

Line 2049: RAISE okl_api.g_exception_unexpected_error;

2045: x_msg_data
2046: );
2047:
2048: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2049: RAISE okl_api.g_exception_unexpected_error;
2050: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2051: RAISE okl_api.g_exception_error;
2052: END IF;
2053:

Line 2050: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

2046: );
2047:
2048: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2049: RAISE okl_api.g_exception_unexpected_error;
2050: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2051: RAISE okl_api.g_exception_error;
2052: END IF;
2053:
2054: END LOOP;

Line 2051: RAISE okl_api.g_exception_error;

2047:
2048: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2049: RAISE okl_api.g_exception_unexpected_error;
2050: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2051: RAISE okl_api.g_exception_error;
2052: END IF;
2053:
2054: END LOOP;
2055: END IF;

Line 2084: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

2080: x_qqhv_rec_type,
2081: lx_qqlv_tbl_type,
2082: x_qqlv_tbl_type);
2083:
2084: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2085: RAISE okl_api.g_exception_unexpected_error;
2086: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2087: RAISE okl_api.g_exception_error;
2088: END IF;

Line 2085: RAISE okl_api.g_exception_unexpected_error;

2081: lx_qqlv_tbl_type,
2082: x_qqlv_tbl_type);
2083:
2084: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2085: RAISE okl_api.g_exception_unexpected_error;
2086: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2087: RAISE okl_api.g_exception_error;
2088: END IF;
2089:

Line 2086: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

2082: x_qqlv_tbl_type);
2083:
2084: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2085: RAISE okl_api.g_exception_unexpected_error;
2086: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2087: RAISE okl_api.g_exception_error;
2088: END IF;
2089:
2090: -- create the data in the cash flow tables if not already created

Line 2087: RAISE okl_api.g_exception_error;

2083:
2084: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2085: RAISE okl_api.g_exception_unexpected_error;
2086: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2087: RAISE okl_api.g_exception_error;
2088: END IF;
2089:
2090: -- create the data in the cash flow tables if not already created
2091: l_cfh_rec_type.cashflow_header_ovn:=1;

Line 2104: OKL_API.G_FALSE,

2100: l_cfl_tbl_type(t).record_mode := 'UPDATE';
2101: END LOOP;
2102: OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow(l_api_version,
2103: p_init_msg_list,
2104: OKL_API.G_FALSE,
2105: l_cfh_rec_type,
2106: l_cfl_tbl_type,
2107: x_return_status,
2108: x_msg_count,

Line 2112: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

2108: x_msg_count,
2109: x_msg_data
2110: );
2111:
2112: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2113: RAISE okl_api.g_exception_unexpected_error;
2114: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2115: RAISE okl_api.g_exception_error;
2116: END IF;

Line 2113: RAISE okl_api.g_exception_unexpected_error;

2109: x_msg_data
2110: );
2111:
2112: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2113: RAISE okl_api.g_exception_unexpected_error;
2114: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2115: RAISE okl_api.g_exception_error;
2116: END IF;
2117:

Line 2114: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

2110: );
2111:
2112: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2113: RAISE okl_api.g_exception_unexpected_error;
2114: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2115: RAISE okl_api.g_exception_error;
2116: END IF;
2117:
2118: END IF;

Line 2115: RAISE okl_api.g_exception_error;

2111:
2112: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2113: RAISE okl_api.g_exception_unexpected_error;
2114: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2115: RAISE okl_api.g_exception_error;
2116: END IF;
2117:
2118: END IF;
2119: -- commit the transaction

Line 2129: WHEN okl_api.g_exception_error THEN

2125: ,l_module
2126: ,'end debug OKLRQQHB.pls call handle_quick_quote');
2127: END IF;
2128: EXCEPTION
2129: WHEN okl_api.g_exception_error THEN
2130: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2131: ,p_pkg_name => g_pkg_name
2132: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
2133: ,x_msg_count => x_msg_count

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

2126: ,'end debug OKLRQQHB.pls call handle_quick_quote');
2127: END IF;
2128: EXCEPTION
2129: WHEN okl_api.g_exception_error THEN
2130: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2131: ,p_pkg_name => g_pkg_name
2132: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
2133: ,x_msg_count => x_msg_count
2134: ,x_msg_data => x_msg_data

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

2128: EXCEPTION
2129: WHEN okl_api.g_exception_error THEN
2130: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2131: ,p_pkg_name => g_pkg_name
2132: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
2133: ,x_msg_count => x_msg_count
2134: ,x_msg_data => x_msg_data
2135: ,p_api_type => g_api_type);
2136: WHEN okl_api.g_exception_unexpected_error THEN

Line 2136: WHEN okl_api.g_exception_unexpected_error THEN

2132: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
2133: ,x_msg_count => x_msg_count
2134: ,x_msg_data => x_msg_data
2135: ,p_api_type => g_api_type);
2136: WHEN okl_api.g_exception_unexpected_error THEN
2137: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2138: ,p_pkg_name => g_pkg_name
2139: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
2140: ,x_msg_count => x_msg_count

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

2133: ,x_msg_count => x_msg_count
2134: ,x_msg_data => x_msg_data
2135: ,p_api_type => g_api_type);
2136: WHEN okl_api.g_exception_unexpected_error THEN
2137: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2138: ,p_pkg_name => g_pkg_name
2139: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
2140: ,x_msg_count => x_msg_count
2141: ,x_msg_data => x_msg_data

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

2135: ,p_api_type => g_api_type);
2136: WHEN okl_api.g_exception_unexpected_error THEN
2137: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2138: ,p_pkg_name => g_pkg_name
2139: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
2140: ,x_msg_count => x_msg_count
2141: ,x_msg_data => x_msg_data
2142: ,p_api_type => g_api_type);
2143: WHEN OTHERS THEN

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

2140: ,x_msg_count => x_msg_count
2141: ,x_msg_data => x_msg_data
2142: ,p_api_type => g_api_type);
2143: WHEN OTHERS THEN
2144: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2145: ,p_pkg_name => g_pkg_name
2146: ,p_exc_name => 'OTHERS'
2147: ,x_msg_count => x_msg_count
2148: ,x_msg_data => x_msg_data

Line 2258: x_return_status := okl_api.g_ret_sts_success;

2254:
2255: i pls_integer := 1;
2256: BEGIN
2257:
2258: x_return_status := okl_api.g_ret_sts_success;
2259:
2260: OPEN c_qqh(p_id => p_quote_id);
2261: FETCH c_qqh INTO
2262: x_qqhv_rec.id,

Line 2324: x_return_status := okl_api.g_ret_sts_error;

2320: x_qqhv_rec.reference_number := okl_util.get_next_seq_num('OKL_QQH_REF_SEQ','OKL_QUICK_QUOTES_B','REFERENCE_NUMBER');
2321: --Bug 7022258--Change end
2322:
2323: IF c_qqh%NOTFOUND THEN
2324: x_return_status := okl_api.g_ret_sts_error;
2325: END IF;
2326: CLOSE c_qqh;
2327:
2328: FOR l_qql IN c_qql(p_id => p_quote_id) LOOP

Line 2398: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2394: is_debug_procedure_on BOOLEAN;
2395: is_debug_statement_on BOOLEAN;
2396: l_api_name CONSTANT VARCHAR2(30) := 'duplicate_quick_qte';
2397: l_api_version CONSTANT NUMBER := 1.0;
2398: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2399:
2400: -- cursor to get the estimates of a particular lease opportunity
2401: CURSOR get_estimates(l_lopp_id IN NUMBER) IS
2402: SELECT ID FROM OKL_QUICK_QUOTES_B

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

2419:
2420: -- call START_ACTIVITY to create savepoint, check compatibility
2421: -- and initialize message list
2422:
2423: l_return_status := okl_api.start_activity(p_api_name => l_api_name
2424: ,p_pkg_name => g_pkg_name
2425: ,p_init_msg_list => p_init_msg_list
2426: ,l_api_version => l_api_version
2427: ,p_api_version => p_api_version

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

2434: x_qqhv_rec => l_quote_rec,
2435: x_qqlv_tbl => l_quote_lines_tbl,
2436: x_return_status => l_return_status );
2437:
2438: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2439: RAISE okl_api.g_exception_unexpected_error;
2440: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2441: RAISE okl_api.g_exception_error;
2442: END IF;

Line 2439: RAISE okl_api.g_exception_unexpected_error;

2435: x_qqlv_tbl => l_quote_lines_tbl,
2436: x_return_status => l_return_status );
2437:
2438: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2439: RAISE okl_api.g_exception_unexpected_error;
2440: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2441: RAISE okl_api.g_exception_error;
2442: END IF;
2443:

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

2436: x_return_status => l_return_status );
2437:
2438: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2439: RAISE okl_api.g_exception_unexpected_error;
2440: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2441: RAISE okl_api.g_exception_error;
2442: END IF;
2443:
2444: -- set the target lease opportunity id

Line 2441: RAISE okl_api.g_exception_error;

2437:
2438: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2439: RAISE okl_api.g_exception_unexpected_error;
2440: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2441: RAISE okl_api.g_exception_error;
2442: END IF;
2443:
2444: -- set the target lease opportunity id
2445: l_quote_rec.lease_opportunity_id:=target_lopp_id;

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

2453: x_qqhv_rec_type => x_quick_qte_rec,
2454: p_qqlv_tbl_type => l_quote_lines_tbl,
2455: x_qqlv_tbl_type => x_quick_qte_lines_tbl);
2456:
2457: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2458: RAISE okl_api.g_exception_unexpected_error;
2459: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2460: RAISE okl_api.g_exception_error;
2461: END IF;

Line 2458: RAISE okl_api.g_exception_unexpected_error;

2454: p_qqlv_tbl_type => l_quote_lines_tbl,
2455: x_qqlv_tbl_type => x_quick_qte_lines_tbl);
2456:
2457: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2458: RAISE okl_api.g_exception_unexpected_error;
2459: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2460: RAISE okl_api.g_exception_error;
2461: END IF;
2462:

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

2455: x_qqlv_tbl_type => x_quick_qte_lines_tbl);
2456:
2457: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2458: RAISE okl_api.g_exception_unexpected_error;
2459: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2460: RAISE okl_api.g_exception_error;
2461: END IF;
2462:
2463: END LOOP;

Line 2460: RAISE okl_api.g_exception_error;

2456:
2457: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2458: RAISE okl_api.g_exception_unexpected_error;
2459: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2460: RAISE okl_api.g_exception_error;
2461: END IF;
2462:
2463: END LOOP;
2464:

Line 2465: x_return_status := okl_api.g_ret_sts_success;

2461: END IF;
2462:
2463: END LOOP;
2464:
2465: x_return_status := okl_api.g_ret_sts_success;
2466:
2467: EXCEPTION
2468:
2469: WHEN okl_api.g_exception_error THEN

Line 2469: WHEN okl_api.g_exception_error THEN

2465: x_return_status := okl_api.g_ret_sts_success;
2466:
2467: EXCEPTION
2468:
2469: WHEN okl_api.g_exception_error THEN
2470: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2471: ,p_pkg_name => g_pkg_name
2472: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
2473: ,x_msg_count => x_msg_count

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

2466:
2467: EXCEPTION
2468:
2469: WHEN okl_api.g_exception_error THEN
2470: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2471: ,p_pkg_name => g_pkg_name
2472: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
2473: ,x_msg_count => x_msg_count
2474: ,x_msg_data => x_msg_data

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

2468:
2469: WHEN okl_api.g_exception_error THEN
2470: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2471: ,p_pkg_name => g_pkg_name
2472: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
2473: ,x_msg_count => x_msg_count
2474: ,x_msg_data => x_msg_data
2475: ,p_api_type => g_api_type);
2476: WHEN okl_api.g_exception_unexpected_error THEN

Line 2476: WHEN okl_api.g_exception_unexpected_error THEN

2472: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
2473: ,x_msg_count => x_msg_count
2474: ,x_msg_data => x_msg_data
2475: ,p_api_type => g_api_type);
2476: WHEN okl_api.g_exception_unexpected_error THEN
2477: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2478: ,p_pkg_name => g_pkg_name
2479: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
2480: ,x_msg_count => x_msg_count

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

2473: ,x_msg_count => x_msg_count
2474: ,x_msg_data => x_msg_data
2475: ,p_api_type => g_api_type);
2476: WHEN okl_api.g_exception_unexpected_error THEN
2477: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2478: ,p_pkg_name => g_pkg_name
2479: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
2480: ,x_msg_count => x_msg_count
2481: ,x_msg_data => x_msg_data

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

2475: ,p_api_type => g_api_type);
2476: WHEN okl_api.g_exception_unexpected_error THEN
2477: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2478: ,p_pkg_name => g_pkg_name
2479: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
2480: ,x_msg_count => x_msg_count
2481: ,x_msg_data => x_msg_data
2482: ,p_api_type => g_api_type);
2483: WHEN OTHERS THEN

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

2480: ,x_msg_count => x_msg_count
2481: ,x_msg_data => x_msg_data
2482: ,p_api_type => g_api_type);
2483: WHEN OTHERS THEN
2484: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
2485: ,p_pkg_name => g_pkg_name
2486: ,p_exc_name => 'OTHERS'
2487: ,x_msg_count => x_msg_count
2488: ,x_msg_data => x_msg_data