DBA Data[Home] [Help]

APPS.OKL_LEASE_RATE_FACTORS_PVT dependencies on FND_API

Line 13: ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false

9: p_lrfv_tbl, to identify the levels corressponding to factor.
10: **/
11:
12: PROCEDURE handle_lrf_ents(p_api_version IN number
13: ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false
14: ,x_return_status OUT NOCOPY varchar2
15: ,x_msg_count OUT NOCOPY number
16: ,x_msg_data OUT NOCOPY varchar2
17: ,p_lrfv_tbl IN lrfv_tbl_type

Line 93: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

89: ,l_module
90: ,'Procedure okl_lrf_pvt.insert_row with status ' ||
91: l_return_status);
92: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
93: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
94: RAISE okl_api.g_exception_error;
95: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
96: RAISE okl_api.g_exception_unexpected_error;
97: END IF;

Line 95: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

91: l_return_status);
92: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
93: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
94: RAISE okl_api.g_exception_error;
95: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
96: RAISE okl_api.g_exception_unexpected_error;
97: END IF;
98: FOR j IN lp_lrlv_tbl.FIRST..lp_lrlv_tbl.LAST LOOP
99:

Line 125: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

121: ,l_module
122: ,'Procedure okl_lrl_pvt.insert_row with status ' ||
123: l_return_status);
124: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
125: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
126: RAISE okl_api.g_exception_error;
127: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
128: RAISE okl_api.g_exception_unexpected_error;
129: END IF;

Line 127: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

123: l_return_status);
124: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
125: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
126: RAISE okl_api.g_exception_error;
127: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
128: RAISE okl_api.g_exception_unexpected_error;
129: END IF;
130: ELSE
131: okl_lrl_pvt.update_row(l_api_version

Line 147: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

143: ,l_module
144: ,'Procedure okl_lrl_pvt.update_row with status ' ||
145: l_return_status);
146: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
147: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
148: RAISE okl_api.g_exception_error;
149: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
150: RAISE okl_api.g_exception_unexpected_error;
151: END IF;

Line 149: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

145: l_return_status);
146: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
147: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
148: RAISE okl_api.g_exception_error;
149: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
150: RAISE okl_api.g_exception_unexpected_error;
151: END IF;
152: END IF;
153: END IF;

Line 172: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

168: ,l_module
169: ,'Procedure okl_lrf_pvt.update_row with status ' ||
170: l_return_status);
171: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
172: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
173: RAISE okl_api.g_exception_error;
174: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
175: RAISE okl_api.g_exception_unexpected_error;
176: END IF;

Line 174: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

170: l_return_status);
171: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
172: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
173: RAISE okl_api.g_exception_error;
174: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
175: RAISE okl_api.g_exception_unexpected_error;
176: END IF;
177: FOR j IN lp_lrlv_tbl.FIRST..lp_lrlv_tbl.LAST LOOP
178:

Line 201: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

197: ,l_module
198: ,'Procedure okl_lrl_pvt.insert_row with status ' ||
199: l_return_status);
200: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
201: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
202: RAISE okl_api.g_exception_error;
203: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
204: RAISE okl_api.g_exception_unexpected_error;
205: END IF;

Line 203: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

199: l_return_status);
200: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
201: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
202: RAISE okl_api.g_exception_error;
203: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
204: RAISE okl_api.g_exception_unexpected_error;
205: END IF;
206: ELSE
207: okl_lrl_pvt.update_row(l_api_version

Line 223: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

219: ,l_module
220: ,'Procedure okl_lrl_pvt.update_row with status ' ||
221: l_return_status);
222: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
223: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
224: RAISE okl_api.g_exception_error;
225: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
226: RAISE okl_api.g_exception_unexpected_error;
227: END IF;

Line 225: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

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

Line 275: ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false

271: for rate set version id p_lrv_id.
272: **/
273:
274: PROCEDURE delete_lease_rate_factors(p_api_version IN number
275: ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false
276: ,x_return_status OUT NOCOPY varchar2
277: ,x_msg_count OUT NOCOPY number
278: ,x_msg_data OUT NOCOPY varchar2
279: ,p_lrv_id IN number) IS

Line 444: ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false

440: levels.
441: **/
442:
443: PROCEDURE remove_lrs_factor (p_api_version IN number
444: ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false
445: ,x_return_status OUT NOCOPY varchar2
446: ,x_msg_count OUT NOCOPY number
447: ,x_msg_data OUT NOCOPY varchar2
448: ,p_lrfv_rec IN lrfv_rec_type) IS

Line 575: ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false

571: This procedure deletes the lease rate factor level.
572: **/
573:
574: PROCEDURE remove_lrs_level(p_api_version IN number
575: ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false
576: ,x_return_status OUT NOCOPY varchar2
577: ,x_msg_count OUT NOCOPY number
578: ,x_msg_data OUT NOCOPY varchar2
579: ,p_lrlv_rec IN okl_lrlv_rec) IS