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

Line 34: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

30:
31: -- Variables Declarations
32: l_api_version CONSTANT NUMBER DEFAULT 1.0;
33: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CHECK_UNIQUE_COMBINATION';
34: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
35: l_check_tmplt_comb VARCHAR2(1);
36: CURSOR c_chk_tmlt_cmbntn IS
37: SELECT 'x'
38: FROM Okl_Leaseapp_Templates LATV,

Line 47: AND NVL(LATV.INDUSTRY_CODE, OKL_API.G_MISS_CHAR) = NVL(p_latv_rec.INDUSTRY_CODE, OKL_API.G_MISS_CHAR)

43: -- Bug 5149659 udhenuko : Start - Uncommenting industry values check
44: --Commented the industry values for checking uniqueness due to issue with data model
45: --industry values are stired at header and it will be same always accross versions
46: --for a given template
47: AND NVL(LATV.INDUSTRY_CODE, OKL_API.G_MISS_CHAR) = NVL(p_latv_rec.INDUSTRY_CODE, OKL_API.G_MISS_CHAR)
48: AND NVL(LATV.INDUSTRY_CLASS, OKL_API.G_MISS_CHAR) = NVL(p_latv_rec.INDUSTRY_CLASS, OKL_API.G_MISS_CHAR)
49: -- Bug 5149659 udhenuko : End
50: AND NVL(LAVV.CONTRACT_TEMPLATE_ID, OKL_API.G_MISS_NUM) = NVL(p_lavv_rec.CONTRACT_TEMPLATE_ID, OKL_API.G_MISS_NUM)
51: AND NVL(LAVV.CHECKLIST_ID, OKL_API.G_MISS_NUM) = NVL(p_lavv_rec.CHECKLIST_ID, OKL_API.G_MISS_NUM)

Line 48: AND NVL(LATV.INDUSTRY_CLASS, OKL_API.G_MISS_CHAR) = NVL(p_latv_rec.INDUSTRY_CLASS, OKL_API.G_MISS_CHAR)

44: --Commented the industry values for checking uniqueness due to issue with data model
45: --industry values are stired at header and it will be same always accross versions
46: --for a given template
47: AND NVL(LATV.INDUSTRY_CODE, OKL_API.G_MISS_CHAR) = NVL(p_latv_rec.INDUSTRY_CODE, OKL_API.G_MISS_CHAR)
48: AND NVL(LATV.INDUSTRY_CLASS, OKL_API.G_MISS_CHAR) = NVL(p_latv_rec.INDUSTRY_CLASS, OKL_API.G_MISS_CHAR)
49: -- Bug 5149659 udhenuko : End
50: AND NVL(LAVV.CONTRACT_TEMPLATE_ID, OKL_API.G_MISS_NUM) = NVL(p_lavv_rec.CONTRACT_TEMPLATE_ID, OKL_API.G_MISS_NUM)
51: AND NVL(LAVV.CHECKLIST_ID, OKL_API.G_MISS_NUM) = NVL(p_lavv_rec.CHECKLIST_ID, OKL_API.G_MISS_NUM)
52: AND LAVV.VERSION_STATUS = 'ACTIVE'

Line 50: AND NVL(LAVV.CONTRACT_TEMPLATE_ID, OKL_API.G_MISS_NUM) = NVL(p_lavv_rec.CONTRACT_TEMPLATE_ID, OKL_API.G_MISS_NUM)

46: --for a given template
47: AND NVL(LATV.INDUSTRY_CODE, OKL_API.G_MISS_CHAR) = NVL(p_latv_rec.INDUSTRY_CODE, OKL_API.G_MISS_CHAR)
48: AND NVL(LATV.INDUSTRY_CLASS, OKL_API.G_MISS_CHAR) = NVL(p_latv_rec.INDUSTRY_CLASS, OKL_API.G_MISS_CHAR)
49: -- Bug 5149659 udhenuko : End
50: AND NVL(LAVV.CONTRACT_TEMPLATE_ID, OKL_API.G_MISS_NUM) = NVL(p_lavv_rec.CONTRACT_TEMPLATE_ID, OKL_API.G_MISS_NUM)
51: AND NVL(LAVV.CHECKLIST_ID, OKL_API.G_MISS_NUM) = NVL(p_lavv_rec.CHECKLIST_ID, OKL_API.G_MISS_NUM)
52: AND LAVV.VERSION_STATUS = 'ACTIVE'
53: AND LAVV.ID <> nvl(p_lavv_rec.id,-99999);
54: BEGIN

Line 51: AND NVL(LAVV.CHECKLIST_ID, OKL_API.G_MISS_NUM) = NVL(p_lavv_rec.CHECKLIST_ID, OKL_API.G_MISS_NUM)

47: AND NVL(LATV.INDUSTRY_CODE, OKL_API.G_MISS_CHAR) = NVL(p_latv_rec.INDUSTRY_CODE, OKL_API.G_MISS_CHAR)
48: AND NVL(LATV.INDUSTRY_CLASS, OKL_API.G_MISS_CHAR) = NVL(p_latv_rec.INDUSTRY_CLASS, OKL_API.G_MISS_CHAR)
49: -- Bug 5149659 udhenuko : End
50: AND NVL(LAVV.CONTRACT_TEMPLATE_ID, OKL_API.G_MISS_NUM) = NVL(p_lavv_rec.CONTRACT_TEMPLATE_ID, OKL_API.G_MISS_NUM)
51: AND NVL(LAVV.CHECKLIST_ID, OKL_API.G_MISS_NUM) = NVL(p_lavv_rec.CHECKLIST_ID, OKL_API.G_MISS_NUM)
52: AND LAVV.VERSION_STATUS = 'ACTIVE'
53: AND LAVV.ID <> nvl(p_lavv_rec.id,-99999);
54: BEGIN
55: -- check for unique Lease Application Template

Line 61: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

57: FETCH c_chk_tmlt_cmbntn INTO l_check_tmplt_comb;
58: CLOSE c_chk_tmlt_cmbntn;
59:
60: IF l_check_tmplt_comb = 'x' THEN
61: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
62: p_msg_name => 'OKL_SO_LSEAPP_TMPLT_NOT_UNIQUE');
63: -- notify caller of an error
64: l_return_status := OKL_API.G_RET_STS_ERROR;
65: END IF;

Line 64: l_return_status := OKL_API.G_RET_STS_ERROR;

60: IF l_check_tmplt_comb = 'x' THEN
61: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
62: p_msg_name => 'OKL_SO_LSEAPP_TMPLT_NOT_UNIQUE');
63: -- notify caller of an error
64: l_return_status := OKL_API.G_RET_STS_ERROR;
65: END IF;
66: RETURN(l_return_status);
67: EXCEPTION
68: -- other appropriate handlers

Line 103: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

99: l_api_version CONSTANT NUMBER := p_api_version;
100: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
101: l_msg_count NUMBER := x_msg_count ;
102: l_msg_data VARCHAR2(2000);
103: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
104:
105: l_latv_rec latv_rec_type;
106: lx_latv_rec latv_rec_type;
107: l_lavv_rec lavv_rec_type;

Line 137: x_return_status := OKL_API.G_RET_STS_SUCCESS;

133: is_debug_procedure_on BOOLEAN;
134: is_debug_statement_on BOOLEAN;
135:
136: BEGIN
137: x_return_status := OKL_API.G_RET_STS_SUCCESS;
138: -- check for logging on PROCEDURE level
139: l_debug_enabled := okl_debug_pub.check_log_enabled;
140: -- call START_ACTIVITY to create savepoint, check compatibility
141: -- and initialize message list

Line 142: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

138: -- check for logging on PROCEDURE level
139: l_debug_enabled := okl_debug_pub.check_log_enabled;
140: -- call START_ACTIVITY to create savepoint, check compatibility
141: -- and initialize message list
142: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
143: ,p_pkg_name => G_PKG_NAME
144: ,p_init_msg_list => p_init_msg_list
145: ,l_api_version => l_api_version
146: ,p_api_version => p_api_version

Line 150: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

146: ,p_api_version => p_api_version
147: ,p_api_type => g_api_type
148: ,x_return_status => x_return_status);
149: -- check if activity started successfully
150: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
153: RAISE OKL_API.G_EXCEPTION_ERROR;
154: END IF;

Line 151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

147: ,p_api_type => g_api_type
148: ,x_return_status => x_return_status);
149: -- check if activity started successfully
150: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
153: RAISE OKL_API.G_EXCEPTION_ERROR;
154: END IF;
155:

Line 152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

148: ,x_return_status => x_return_status);
149: -- check if activity started successfully
150: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
153: RAISE OKL_API.G_EXCEPTION_ERROR;
154: END IF;
155:
156: OPEN c_get_lat_data(p_lat_version_id);

Line 153: RAISE OKL_API.G_EXCEPTION_ERROR;

149: -- check if activity started successfully
150: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
153: RAISE OKL_API.G_EXCEPTION_ERROR;
154: END IF;
155:
156: OPEN c_get_lat_data(p_lat_version_id);
157: FETCH c_get_lat_data INTO l_latv_rec.id

Line 175: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

171: ,x_msg_count => x_msg_count
172: ,x_msg_data => x_msg_data
173: ,p_lavv_rec => l_lavv_rec
174: ,x_lavv_rec => lx_lavv_rec);
175: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
178: RAISE OKL_API.G_EXCEPTION_ERROR;
179: END IF;

Line 176: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

172: ,x_msg_data => x_msg_data
173: ,p_lavv_rec => l_lavv_rec
174: ,x_lavv_rec => lx_lavv_rec);
175: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
178: RAISE OKL_API.G_EXCEPTION_ERROR;
179: END IF;
180:

Line 177: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

173: ,p_lavv_rec => l_lavv_rec
174: ,x_lavv_rec => lx_lavv_rec);
175: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
178: RAISE OKL_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: OPEN c_chk_ver_sts(l_latv_rec.ID);

Line 178: RAISE OKL_API.G_EXCEPTION_ERROR;

174: ,x_lavv_rec => lx_lavv_rec);
175: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
178: RAISE OKL_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: OPEN c_chk_ver_sts(l_latv_rec.ID);
182: FETCH c_chk_ver_sts INTO l_chk_vers_sts;

Line 196: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

192: ,x_msg_data => x_msg_data
193: ,p_latv_rec => l_latv_rec
194: ,x_latv_rec => lx_latv_rec);
195:
196: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
199: RAISE OKL_API.G_EXCEPTION_ERROR;
200: END IF;

Line 197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

193: ,p_latv_rec => l_latv_rec
194: ,x_latv_rec => lx_latv_rec);
195:
196: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
199: RAISE OKL_API.G_EXCEPTION_ERROR;
200: END IF;
201:

Line 198: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

194: ,x_latv_rec => lx_latv_rec);
195:
196: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
199: RAISE OKL_API.G_EXCEPTION_ERROR;
200: END IF;
201:
202: END IF;

Line 199: RAISE OKL_API.G_EXCEPTION_ERROR;

195:
196: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
199: RAISE OKL_API.G_EXCEPTION_ERROR;
200: END IF;
201:
202: END IF;
203: -- raise the business event passing the Template id and the version id added to the parameter list

Line 220: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

216: ,x_msg_data => x_msg_data
217: ,p_event_name => p_event_name
218: ,p_parameters => l_parameter_list);
219:
220: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;

Line 221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

217: ,p_event_name => p_event_name
218: ,p_parameters => l_parameter_list);
219:
220: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;
225:

Line 222: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

218: ,p_parameters => l_parameter_list);
219:
220: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;
225:
226: x_return_status := l_return_status;

Line 223: RAISE OKL_API.G_EXCEPTION_ERROR;

219:
220: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;
225:
226: x_return_status := l_return_status;
227: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 227: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;
225:
226: x_return_status := l_return_status;
227: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
228: ,x_msg_data => x_msg_data);
229:
230: EXCEPTION
231: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 231: WHEN OKL_API.G_EXCEPTION_ERROR THEN

227: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
228: ,x_msg_data => x_msg_data);
229:
230: EXCEPTION
231: WHEN OKL_API.G_EXCEPTION_ERROR THEN
232: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
233: p_api_name => l_api_name,
234: p_pkg_name => G_PKG_NAME,
235: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 232: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

228: ,x_msg_data => x_msg_data);
229:
230: EXCEPTION
231: WHEN OKL_API.G_EXCEPTION_ERROR THEN
232: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
233: p_api_name => l_api_name,
234: p_pkg_name => G_PKG_NAME,
235: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
236: x_msg_count => x_msg_count,

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

231: WHEN OKL_API.G_EXCEPTION_ERROR THEN
232: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
233: p_api_name => l_api_name,
234: p_pkg_name => G_PKG_NAME,
235: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
236: x_msg_count => x_msg_count,
237: x_msg_data => x_msg_data,
238: p_api_type => g_api_type);
239: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 239: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

235: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
236: x_msg_count => x_msg_count,
237: x_msg_data => x_msg_data,
238: p_api_type => g_api_type);
239: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
240: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
241: p_api_name => l_api_name,
242: p_pkg_name => G_PKG_NAME,
243: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 240: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

236: x_msg_count => x_msg_count,
237: x_msg_data => x_msg_data,
238: p_api_type => g_api_type);
239: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
240: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
241: p_api_name => l_api_name,
242: p_pkg_name => G_PKG_NAME,
243: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
244: x_msg_count => x_msg_count,

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

239: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
240: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
241: p_api_name => l_api_name,
242: p_pkg_name => G_PKG_NAME,
243: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
244: x_msg_count => x_msg_count,
245: x_msg_data => x_msg_data,
246: p_api_type => g_api_type);
247: WHEN OTHERS THEN

Line 248: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

244: x_msg_count => x_msg_count,
245: x_msg_data => x_msg_data,
246: p_api_type => g_api_type);
247: WHEN OTHERS THEN
248: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
249: p_api_name => l_api_name,
250: p_pkg_name => G_PKG_NAME,
251: p_exc_name => 'OTHERS',
252: x_msg_count => x_msg_count,

Line 287: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

283: x_lavv_rec OUT NOCOPY lavv_rec_type)IS
284: -- Variables Declarations
285: l_api_version CONSTANT NUMBER DEFAULT 1.0;
286: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_LEASEAPP_TEMPLATE';
287: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
288:
289: -- Record/Table Type Declarations
290: l_latv_rec latv_rec_type;
291: lx_latv_rec latv_rec_type;

Line 296: x_return_status := OKL_API.G_RET_STS_SUCCESS;

292: l_lavv_rec lavv_rec_type;
293: lx_lavv_rec lavv_rec_type;
294: l_debug_enabled VARCHAR2(10);
295: BEGIN
296: x_return_status := OKL_API.G_RET_STS_SUCCESS;
297: -- check for logging on PROCEDURE level
298: l_debug_enabled := okl_debug_pub.check_log_enabled;
299: -- call START_ACTIVITY to create savepoint, check compatibility
300: -- and initialize message list

Line 301: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

297: -- check for logging on PROCEDURE level
298: l_debug_enabled := okl_debug_pub.check_log_enabled;
299: -- call START_ACTIVITY to create savepoint, check compatibility
300: -- and initialize message list
301: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
302: ,p_pkg_name => G_PKG_NAME
303: ,p_init_msg_list => p_init_msg_list
304: ,l_api_version => l_api_version
305: ,p_api_version => p_api_version

Line 309: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

305: ,p_api_version => p_api_version
306: ,p_api_type => g_api_type
307: ,x_return_status => x_return_status);
308: -- check if activity started successfully
309: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
310: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
311: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
312: RAISE OKL_API.G_EXCEPTION_ERROR;
313: END IF;

Line 310: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

306: ,p_api_type => g_api_type
307: ,x_return_status => x_return_status);
308: -- check if activity started successfully
309: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
310: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
311: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
312: RAISE OKL_API.G_EXCEPTION_ERROR;
313: END IF;
314: l_latv_rec := p_latv_rec;

Line 311: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

307: ,x_return_status => x_return_status);
308: -- check if activity started successfully
309: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
310: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
311: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
312: RAISE OKL_API.G_EXCEPTION_ERROR;
313: END IF;
314: l_latv_rec := p_latv_rec;
315: l_lavv_rec := p_lavv_rec;

Line 312: RAISE OKL_API.G_EXCEPTION_ERROR;

308: -- check if activity started successfully
309: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
310: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
311: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
312: RAISE OKL_API.G_EXCEPTION_ERROR;
313: END IF;
314: l_latv_rec := p_latv_rec;
315: l_lavv_rec := p_lavv_rec;
316:

Line 341: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

337:
338: --call function to check the unique combination for lease application template
339: /*l_return_status := check_unique_combination(l_latv_rec,
340: l_lavv_rec);
341: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_ERROR;
345: END IF; */

Line 342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

338: --call function to check the unique combination for lease application template
339: /*l_return_status := check_unique_combination(l_latv_rec,
340: l_lavv_rec);
341: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_ERROR;
345: END IF; */
346: --Bug # 5189655 ssdeshpa end

Line 343: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

339: /*l_return_status := check_unique_combination(l_latv_rec,
340: l_lavv_rec);
341: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_ERROR;
345: END IF; */
346: --Bug # 5189655 ssdeshpa end
347:

Line 344: RAISE OKL_API.G_EXCEPTION_ERROR;

340: l_lavv_rec);
341: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_ERROR;
345: END IF; */
346: --Bug # 5189655 ssdeshpa end
347:
348: IF(l_debug_enabled='Y') THEN

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

368: ' expiring lease application template with ret status ' || x_return_status ||
369: ' x_msg_data ' || x_msg_data);
370: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
371:
372: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
373: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
375: RAISE OKL_API.G_EXCEPTION_ERROR;
376: END IF;

Line 373: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

369: ' x_msg_data ' || x_msg_data);
370: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
371:
372: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
373: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
375: RAISE OKL_API.G_EXCEPTION_ERROR;
376: END IF;
377:

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

370: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
371:
372: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
373: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
375: RAISE OKL_API.G_EXCEPTION_ERROR;
376: END IF;
377:
378: l_lavv_rec.LEASEAPP_TEMPLATE_ID := lx_latv_rec.ID;

Line 375: RAISE OKL_API.G_EXCEPTION_ERROR;

371:
372: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
373: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
375: RAISE OKL_API.G_EXCEPTION_ERROR;
376: END IF;
377:
378: l_lavv_rec.LEASEAPP_TEMPLATE_ID := lx_latv_rec.ID;
379:

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

400: 'l_lavv_rec.version_status '||l_lavv_rec.version_status||
401: ' expiring lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
402: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
403:
404: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
406: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
407: RAISE OKL_API.G_EXCEPTION_ERROR;
408: END IF;

Line 405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

401: ' expiring lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
402: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
403:
404: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
406: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
407: RAISE OKL_API.G_EXCEPTION_ERROR;
408: END IF;
409: x_latv_rec := lx_latv_rec;

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

402: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
403:
404: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
406: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
407: RAISE OKL_API.G_EXCEPTION_ERROR;
408: END IF;
409: x_latv_rec := lx_latv_rec;
410: x_lavv_rec := lx_lavv_rec;

Line 407: RAISE OKL_API.G_EXCEPTION_ERROR;

403:
404: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
406: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
407: RAISE OKL_API.G_EXCEPTION_ERROR;
408: END IF;
409: x_latv_rec := lx_latv_rec;
410: x_lavv_rec := lx_lavv_rec;
411: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 411: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

407: RAISE OKL_API.G_EXCEPTION_ERROR;
408: END IF;
409: x_latv_rec := lx_latv_rec;
410: x_lavv_rec := lx_lavv_rec;
411: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
412: ,x_msg_data => x_msg_data);
413: EXCEPTION
414: WHEN OKL_API.G_EXCEPTION_ERROR THEN
415: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 414: WHEN OKL_API.G_EXCEPTION_ERROR THEN

410: x_lavv_rec := lx_lavv_rec;
411: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
412: ,x_msg_data => x_msg_data);
413: EXCEPTION
414: WHEN OKL_API.G_EXCEPTION_ERROR THEN
415: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
416: p_api_name => l_api_name,
417: p_pkg_name => G_PKG_NAME,
418: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 415: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

411: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
412: ,x_msg_data => x_msg_data);
413: EXCEPTION
414: WHEN OKL_API.G_EXCEPTION_ERROR THEN
415: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
416: p_api_name => l_api_name,
417: p_pkg_name => G_PKG_NAME,
418: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
419: x_msg_count => x_msg_count,

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

414: WHEN OKL_API.G_EXCEPTION_ERROR THEN
415: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
416: p_api_name => l_api_name,
417: p_pkg_name => G_PKG_NAME,
418: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
419: x_msg_count => x_msg_count,
420: x_msg_data => x_msg_data,
421: p_api_type => g_api_type);
422: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 422: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

418: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
419: x_msg_count => x_msg_count,
420: x_msg_data => x_msg_data,
421: p_api_type => g_api_type);
422: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
424: p_api_name => l_api_name,
425: p_pkg_name => G_PKG_NAME,
426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

419: x_msg_count => x_msg_count,
420: x_msg_data => x_msg_data,
421: p_api_type => g_api_type);
422: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
424: p_api_name => l_api_name,
425: p_pkg_name => G_PKG_NAME,
426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
427: x_msg_count => x_msg_count,

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

422: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
424: p_api_name => l_api_name,
425: p_pkg_name => G_PKG_NAME,
426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
427: x_msg_count => x_msg_count,
428: x_msg_data => x_msg_data,
429: p_api_type => g_api_type);
430: WHEN OTHERS THEN

Line 431: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

427: x_msg_count => x_msg_count,
428: x_msg_data => x_msg_data,
429: p_api_type => g_api_type);
430: WHEN OTHERS THEN
431: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
432: p_api_name => l_api_name,
433: p_pkg_name => G_PKG_NAME,
434: p_exc_name => 'OTHERS',
435: x_msg_count => x_msg_count,

Line 470: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

466: p_ident_flag IN VARCHAR2)IS
467: -- Variables Declarations
468: l_api_version CONSTANT NUMBER DEFAULT 1.0;
469: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_LEASEAPP_TEMPLATE';
470: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
471: -- Record/Table Type Declarations
472:
473: -- Begin - bug#4632503 - varangan- 11-Oct-2005
474: l_source_type CONSTANT VARCHAR2(30) DEFAULT 'LEASE_APPL_TEMPLATE';

Line 529: x_return_status := OKL_API.G_RET_STS_SUCCESS;

525: AND lat.ID = p_lat_id
526: ) MY_START_DATE;
527:
528: BEGIN
529: x_return_status := OKL_API.G_RET_STS_SUCCESS;
530: -- check for logging on PROCEDURE level
531: l_debug_enabled := okl_debug_pub.check_log_enabled;
532: -- call START_ACTIVITY to create savepoint, check compatibility
533: -- and initialize message list

Line 534: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

530: -- check for logging on PROCEDURE level
531: l_debug_enabled := okl_debug_pub.check_log_enabled;
532: -- call START_ACTIVITY to create savepoint, check compatibility
533: -- and initialize message list
534: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
535: ,p_pkg_name => G_PKG_NAME
536: ,p_init_msg_list => p_init_msg_list
537: ,l_api_version => l_api_version
538: ,p_api_version => p_api_version

Line 542: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

538: ,p_api_version => p_api_version
539: ,p_api_type => g_api_type
540: ,x_return_status => x_return_status);
541: -- check if activity started successfully
542: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;

Line 543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

539: ,p_api_type => g_api_type
540: ,x_return_status => x_return_status);
541: -- check if activity started successfully
542: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547: l_latv_rec := p_latv_rec;

Line 544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

540: ,x_return_status => x_return_status);
541: -- check if activity started successfully
542: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547: l_latv_rec := p_latv_rec;
548: l_lavv_rec := p_lavv_rec;

Line 545: RAISE OKL_API.G_EXCEPTION_ERROR;

541: -- check if activity started successfully
542: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547: l_latv_rec := p_latv_rec;
548: l_lavv_rec := p_lavv_rec;
549: l_ident_flag := p_ident_flag;

Line 601: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

597:
598: --call function to check the unique combination for lease application template
599: /*l_return_status := check_unique_combination(l_latv_rec,
600: l_lavv_rec);
601: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
603: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_ERROR;
605: END IF; */

Line 602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

598: --call function to check the unique combination for lease application template
599: /*l_return_status := check_unique_combination(l_latv_rec,
600: l_lavv_rec);
601: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
603: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_ERROR;
605: END IF; */
606: --Bug # 5189655 ssdeshpa end

Line 603: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

599: /*l_return_status := check_unique_combination(l_latv_rec,
600: l_lavv_rec);
601: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
603: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_ERROR;
605: END IF; */
606: --Bug # 5189655 ssdeshpa end
607: --if we are updating an active version, check if the valid to date is greater than or equal to

Line 604: RAISE OKL_API.G_EXCEPTION_ERROR;

600: l_lavv_rec);
601: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
603: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_ERROR;
605: END IF; */
606: --Bug # 5189655 ssdeshpa end
607: --if we are updating an active version, check if the valid to date is greater than or equal to
608: --all the lease applications and vendor programs start date which uses this template

Line 627: IF l_lavv_rec.valid_to <> OKL_API.G_MISS_DATE AND l_lavv_rec.valid_to < l_max_start_date THEN

623: -- as the max_Start_date
624: l_max_start_date := l_lavv_rec.valid_from;
625: END IF;
626:
627: IF l_lavv_rec.valid_to <> OKL_API.G_MISS_DATE AND l_lavv_rec.valid_to < l_max_start_date THEN
628: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
629: p_msg_name => 'OKL_LAT_INVALID_VALITO',
630: p_token1 => 'VALID_TO',
631: p_token1_value => l_max_start_date);

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

624: l_max_start_date := l_lavv_rec.valid_from;
625: END IF;
626:
627: IF l_lavv_rec.valid_to <> OKL_API.G_MISS_DATE AND l_lavv_rec.valid_to < l_max_start_date THEN
628: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
629: p_msg_name => 'OKL_LAT_INVALID_VALITO',
630: p_token1 => 'VALID_TO',
631: p_token1_value => l_max_start_date);
632: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 632: RAISE OKL_API.G_EXCEPTION_ERROR;

628: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
629: p_msg_name => 'OKL_LAT_INVALID_VALITO',
630: p_token1 => 'VALID_TO',
631: p_token1_value => l_max_start_date);
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633:
634: END IF;
635: -- l_latv_rec.template_status := G_STATUS_ACTIVE;
636: END IF;

Line 638: IF ((l_latv_rec.ID IS NOT NULL OR l_latv_rec.id <> OKL_API.G_MISS_NUM)) THEN

634: END IF;
635: -- l_latv_rec.template_status := G_STATUS_ACTIVE;
636: END IF;
637:
638: IF ((l_latv_rec.ID IS NOT NULL OR l_latv_rec.id <> OKL_API.G_MISS_NUM)) THEN
639: IF(l_debug_enabled='Y') THEN
640: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.UPADTE_ROW'
641: ,'begin debug OKLSLATB.pls call upadte_row');
642: END IF;

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

658: 'l_latv_name '||l_latv_rec.NAME
659: ||'lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
660: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
661:
662: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;

Line 663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

659: ||'lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
660: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
661:
662: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;
667: END IF;

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

660: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
661:
662: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;
667: END IF;
668:

Line 665: RAISE OKL_API.G_EXCEPTION_ERROR;

661:
662: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;
667: END IF;
668:
669: IF ((l_lavv_rec.ID IS NOT NULL OR l_lavv_rec.id <> OKL_API.G_MISS_NUM)) THEN

Line 669: IF ((l_lavv_rec.ID IS NOT NULL OR l_lavv_rec.id <> OKL_API.G_MISS_NUM)) THEN

665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;
667: END IF;
668:
669: IF ((l_lavv_rec.ID IS NOT NULL OR l_lavv_rec.id <> OKL_API.G_MISS_NUM)) THEN
670: IF(l_debug_enabled='Y') THEN
671: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.UPADTE_ROW'
672: ,'begin debug OKLSLAVB.pls call upadte_row');
673: END IF;

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

689: 'l_lavv_rec.version_number '||to_char(l_lavv_rec.version_number) ||'l_lavv_rec.version_status '
690: ||l_lavv_rec.version_status
691: ||'lease application template with ret status '||x_return_status||'x_msg_data '||x_msg_data);
692: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
693: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
695: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
696: RAISE OKL_API.G_EXCEPTION_ERROR;
697: END IF;

Line 694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

690: ||l_lavv_rec.version_status
691: ||'lease application template with ret status '||x_return_status||'x_msg_data '||x_msg_data);
692: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
693: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
695: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
696: RAISE OKL_API.G_EXCEPTION_ERROR;
697: END IF;
698: END IF;

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

691: ||'lease application template with ret status '||x_return_status||'x_msg_data '||x_msg_data);
692: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
693: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
695: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
696: RAISE OKL_API.G_EXCEPTION_ERROR;
697: END IF;
698: END IF;
699: -- Begin - Bug#4632503 - Updating Eligibility criteria's end date while updating version end date- varangan- 11-Oct-2005

Line 696: RAISE OKL_API.G_EXCEPTION_ERROR;

692: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
693: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
695: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
696: RAISE OKL_API.G_EXCEPTION_ERROR;
697: END IF;
698: END IF;
699: -- Begin - Bug#4632503 - Updating Eligibility criteria's end date while updating version end date- varangan- 11-Oct-2005
700: OKL_ECC_VALUES_PVT.end_date_eligibility_criteria(p_api_version => p_api_version

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

704: ,x_msg_data => x_msg_data
705: ,p_source_id => l_lavv_rec.ID
706: ,p_source_type => l_source_type
707: ,p_end_date => l_lavv_rec.valid_to);
708: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
711: RAISE OKL_API.G_EXCEPTION_ERROR;
712: END IF;

Line 709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

705: ,p_source_id => l_lavv_rec.ID
706: ,p_source_type => l_source_type
707: ,p_end_date => l_lavv_rec.valid_to);
708: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
711: RAISE OKL_API.G_EXCEPTION_ERROR;
712: END IF;
713: -- End - Bug#4632503 - Updating Eligibility criteria's end date while updating version end date- varangan- 11-Oct-2005

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

706: ,p_source_type => l_source_type
707: ,p_end_date => l_lavv_rec.valid_to);
708: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
711: RAISE OKL_API.G_EXCEPTION_ERROR;
712: END IF;
713: -- End - Bug#4632503 - Updating Eligibility criteria's end date while updating version end date- varangan- 11-Oct-2005
714: x_latv_rec := lx_latv_rec;

Line 711: RAISE OKL_API.G_EXCEPTION_ERROR;

707: ,p_end_date => l_lavv_rec.valid_to);
708: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
711: RAISE OKL_API.G_EXCEPTION_ERROR;
712: END IF;
713: -- End - Bug#4632503 - Updating Eligibility criteria's end date while updating version end date- varangan- 11-Oct-2005
714: x_latv_rec := lx_latv_rec;
715: x_lavv_rec := lx_lavv_rec;

Line 716: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

712: END IF;
713: -- End - Bug#4632503 - Updating Eligibility criteria's end date while updating version end date- varangan- 11-Oct-2005
714: x_latv_rec := lx_latv_rec;
715: x_lavv_rec := lx_lavv_rec;
716: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
717: ,x_msg_data => x_msg_data);
718: EXCEPTION
719: WHEN OKL_API.G_EXCEPTION_ERROR THEN
720: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 719: WHEN OKL_API.G_EXCEPTION_ERROR THEN

715: x_lavv_rec := lx_lavv_rec;
716: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
717: ,x_msg_data => x_msg_data);
718: EXCEPTION
719: WHEN OKL_API.G_EXCEPTION_ERROR THEN
720: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
721: p_api_name => l_api_name,
722: p_pkg_name => G_PKG_NAME,
723: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 720: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

716: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
717: ,x_msg_data => x_msg_data);
718: EXCEPTION
719: WHEN OKL_API.G_EXCEPTION_ERROR THEN
720: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
721: p_api_name => l_api_name,
722: p_pkg_name => G_PKG_NAME,
723: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
724: x_msg_count => x_msg_count,

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

719: WHEN OKL_API.G_EXCEPTION_ERROR THEN
720: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
721: p_api_name => l_api_name,
722: p_pkg_name => G_PKG_NAME,
723: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
724: x_msg_count => x_msg_count,
725: x_msg_data => x_msg_data,
726: p_api_type => g_api_type);
727: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 727: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

723: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
724: x_msg_count => x_msg_count,
725: x_msg_data => x_msg_data,
726: p_api_type => g_api_type);
727: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
728: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
729: p_api_name => l_api_name,
730: p_pkg_name => G_PKG_NAME,
731: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 728: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

724: x_msg_count => x_msg_count,
725: x_msg_data => x_msg_data,
726: p_api_type => g_api_type);
727: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
728: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
729: p_api_name => l_api_name,
730: p_pkg_name => G_PKG_NAME,
731: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
732: x_msg_count => x_msg_count,

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

727: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
728: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
729: p_api_name => l_api_name,
730: p_pkg_name => G_PKG_NAME,
731: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
732: x_msg_count => x_msg_count,
733: x_msg_data => x_msg_data,
734: p_api_type => g_api_type);
735: WHEN OTHERS THEN

Line 736: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

732: x_msg_count => x_msg_count,
733: x_msg_data => x_msg_data,
734: p_api_type => g_api_type);
735: WHEN OTHERS THEN
736: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
737: p_api_name => l_api_name,
738: p_pkg_name => G_PKG_NAME,
739: p_exc_name => 'OTHERS',
740: x_msg_count => x_msg_count,

Line 775: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

771: p_mode IN VARCHAR2)IS
772: -- Variables Declarations
773: l_api_version CONSTANT NUMBER DEFAULT 1.0;
774: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'VERSION_DUP_LEASEAPP_TEMP';
775: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
776: -- Record/Table Type Declarations
777: l_latv_rec_old latv_rec_type;
778: l_latv_rec_new latv_rec_type;
779: x_latv_rec_old latv_rec_type;

Line 812: x_return_status := OKL_API.G_RET_STS_SUCCESS;

808: WHERE LAV1.LEASEAPP_TEMPLATE_ID = LAT.ID);
809: --Fixed ssdeshpa Bug # 6487421 End
810: --asawanka bug 4966317 fix ends
811: BEGIN
812: x_return_status := OKL_API.G_RET_STS_SUCCESS;
813: -- check for logging on PROCEDURE level
814: l_debug_enabled := okl_debug_pub.check_log_enabled;
815: -- call START_ACTIVITY to create savepoint, check compatibility
816: -- and initialize message list

Line 817: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

813: -- check for logging on PROCEDURE level
814: l_debug_enabled := okl_debug_pub.check_log_enabled;
815: -- call START_ACTIVITY to create savepoint, check compatibility
816: -- and initialize message list
817: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
818: ,p_pkg_name => G_PKG_NAME
819: ,p_init_msg_list => p_init_msg_list
820: ,l_api_version => l_api_version
821: ,p_api_version => p_api_version

Line 825: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

821: ,p_api_version => p_api_version
822: ,p_api_type => g_api_type
823: ,x_return_status => x_return_status);
824: -- check if activity started successfully
825: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;

Line 826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

822: ,p_api_type => g_api_type
823: ,x_return_status => x_return_status);
824: -- check if activity started successfully
825: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
830: --Bug 5149659 PAGARG Populate old rec from DB for previous version update

Line 827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

823: ,x_return_status => x_return_status);
824: -- check if activity started successfully
825: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
830: --Bug 5149659 PAGARG Populate old rec from DB for previous version update
831: l_latv_rec_new := p_latv_rec;

Line 828: RAISE OKL_API.G_EXCEPTION_ERROR;

824: -- check if activity started successfully
825: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
830: --Bug 5149659 PAGARG Populate old rec from DB for previous version update
831: l_latv_rec_new := p_latv_rec;
832: l_lavv_rec_new := p_lavv_rec;

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

872: ' l_latv_name '||l_latv_rec_new.NAME ||
873: ' expiring lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data );
874: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
875:
876: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
877: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
878: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
879: RAISE OKL_API.G_EXCEPTION_ERROR;
880: END IF;

Line 877: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

873: ' expiring lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data );
874: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
875:
876: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
877: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
878: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
879: RAISE OKL_API.G_EXCEPTION_ERROR;
880: END IF;
881: x_latv_rec := x_latv_rec_new;

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

874: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
875:
876: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
877: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
878: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
879: RAISE OKL_API.G_EXCEPTION_ERROR;
880: END IF;
881: x_latv_rec := x_latv_rec_new;
882: x_lavv_rec := x_lavv_rec_new;

Line 879: RAISE OKL_API.G_EXCEPTION_ERROR;

875:
876: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
877: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
878: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
879: RAISE OKL_API.G_EXCEPTION_ERROR;
880: END IF;
881: x_latv_rec := x_latv_rec_new;
882: x_lavv_rec := x_lavv_rec_new;
883: ELSE

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

891: ,x_msg_data => x_msg_data
892: ,p_latv_rec => p_latv_rec
893: ,x_latv_rec => lx_latv_rec);
894:
895: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
896: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
897: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
898: RAISE OKL_API.G_EXCEPTION_ERROR;
899: END IF;

Line 896: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

892: ,p_latv_rec => p_latv_rec
893: ,x_latv_rec => lx_latv_rec);
894:
895: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
896: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
897: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
898: RAISE OKL_API.G_EXCEPTION_ERROR;
899: END IF;
900:

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

893: ,x_latv_rec => lx_latv_rec);
894:
895: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
896: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
897: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
898: RAISE OKL_API.G_EXCEPTION_ERROR;
899: END IF;
900:
901: IF l_lavv_rec_new.valid_from < lx_latv_rec.valid_from THEN

Line 898: RAISE OKL_API.G_EXCEPTION_ERROR;

894:
895: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
896: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
897: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
898: RAISE OKL_API.G_EXCEPTION_ERROR;
899: END IF;
900:
901: IF l_lavv_rec_new.valid_from < lx_latv_rec.valid_from THEN
902: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

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

898: RAISE OKL_API.G_EXCEPTION_ERROR;
899: END IF;
900:
901: IF l_lavv_rec_new.valid_from < lx_latv_rec.valid_from THEN
902: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
903: p_msg_name => 'OKL_LAT_INVALID_VALIDFROM',
904: p_token1 => 'VALID_FROM',
905: p_token1_value => lx_latv_rec.valid_from);
906: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 906: RAISE OKL_API.G_EXCEPTION_ERROR;

902: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
903: p_msg_name => 'OKL_LAT_INVALID_VALIDFROM',
904: p_token1 => 'VALID_FROM',
905: p_token1_value => lx_latv_rec.valid_from);
906: RAISE OKL_API.G_EXCEPTION_ERROR;
907: END IF;
908: -- Modifications to be done for the current template version
909: -- Current version template end_date will be updated with
910: -- new version valid from -1

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

950: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.update_leaseapp_template',
951: 'l_latv_name '||l_latv_rec_old.NAME ||
952: 'lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
953: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
954: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
955: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
957: RAISE OKL_API.G_EXCEPTION_ERROR;
958: END IF;

Line 955: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

951: 'l_latv_name '||l_latv_rec_old.NAME ||
952: 'lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
953: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
954: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
955: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
957: RAISE OKL_API.G_EXCEPTION_ERROR;
958: END IF;
959:

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

952: 'lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
953: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
954: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
955: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
957: RAISE OKL_API.G_EXCEPTION_ERROR;
958: END IF;
959:
960: -- Modifications for New Version

Line 957: RAISE OKL_API.G_EXCEPTION_ERROR;

953: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
954: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
955: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
957: RAISE OKL_API.G_EXCEPTION_ERROR;
958: END IF;
959:
960: -- Modifications for New Version
961: l_lavv_rec_new.version_number := l_lavv_rec_old.version_number + 1 ;

Line 981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

977: --End- varangan-bug#4684557 - Version From date validation
978: --call function to check the unique combination for lease application template
979: /* l_return_status := check_unique_combination(l_latv_rec_new,
980: l_lavv_rec_new);
981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_ERROR;
985: END IF; */

Line 982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

978: --call function to check the unique combination for lease application template
979: /* l_return_status := check_unique_combination(l_latv_rec_new,
980: l_lavv_rec_new);
981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_ERROR;
985: END IF; */
986: --Bug # 5189655 ssdeshpa end

Line 983: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

979: /* l_return_status := check_unique_combination(l_latv_rec_new,
980: l_lavv_rec_new);
981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_ERROR;
985: END IF; */
986: --Bug # 5189655 ssdeshpa end
987: -- call the TAPI insert_row to create a lease application template version

Line 984: RAISE OKL_API.G_EXCEPTION_ERROR;

980: l_lavv_rec_new);
981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_ERROR;
985: END IF; */
986: --Bug # 5189655 ssdeshpa end
987: -- call the TAPI insert_row to create a lease application template version
988: OKL_LAV_PVT.insert_row(p_api_version => p_api_version

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

1002: ' l_latv_name '||l_latv_rec_old.NAME ||
1003: ' expiring lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
1004: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1005:
1006: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1007: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1008: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1009: RAISE OKL_API.G_EXCEPTION_ERROR;
1010: END IF;

Line 1007: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1003: ' expiring lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
1004: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1005:
1006: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1007: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1008: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1009: RAISE OKL_API.G_EXCEPTION_ERROR;
1010: END IF;
1011: x_latv_rec := x_latv_rec_old;

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

1004: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1005:
1006: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1007: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1008: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1009: RAISE OKL_API.G_EXCEPTION_ERROR;
1010: END IF;
1011: x_latv_rec := x_latv_rec_old;
1012: x_lavv_rec := x_lavv_rec_new;

Line 1009: RAISE OKL_API.G_EXCEPTION_ERROR;

1005:
1006: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1007: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1008: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1009: RAISE OKL_API.G_EXCEPTION_ERROR;
1010: END IF;
1011: x_latv_rec := x_latv_rec_old;
1012: x_lavv_rec := x_lavv_rec_new;
1013: END IF;

Line 1015: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

1011: x_latv_rec := x_latv_rec_old;
1012: x_lavv_rec := x_lavv_rec_new;
1013: END IF;
1014:
1015: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1016: ,x_msg_data => x_msg_data);
1017: EXCEPTION
1018: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1019: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1018: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1014:
1015: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1016: ,x_msg_data => x_msg_data);
1017: EXCEPTION
1018: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1019: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1020: p_api_name => l_api_name,
1021: p_pkg_name => G_PKG_NAME,
1022: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1019: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1015: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1016: ,x_msg_data => x_msg_data);
1017: EXCEPTION
1018: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1019: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1020: p_api_name => l_api_name,
1021: p_pkg_name => G_PKG_NAME,
1022: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1023: x_msg_count => x_msg_count,

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

1018: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1019: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1020: p_api_name => l_api_name,
1021: p_pkg_name => G_PKG_NAME,
1022: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1023: x_msg_count => x_msg_count,
1024: x_msg_data => x_msg_data,
1025: p_api_type => g_api_type);
1026: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1026: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1022: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1023: x_msg_count => x_msg_count,
1024: x_msg_data => x_msg_data,
1025: p_api_type => g_api_type);
1026: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1028: p_api_name => l_api_name,
1029: p_pkg_name => G_PKG_NAME,
1030: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1023: x_msg_count => x_msg_count,
1024: x_msg_data => x_msg_data,
1025: p_api_type => g_api_type);
1026: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1028: p_api_name => l_api_name,
1029: p_pkg_name => G_PKG_NAME,
1030: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1031: x_msg_count => x_msg_count,

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

1026: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1028: p_api_name => l_api_name,
1029: p_pkg_name => G_PKG_NAME,
1030: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1031: x_msg_count => x_msg_count,
1032: x_msg_data => x_msg_data,
1033: p_api_type => g_api_type);
1034: WHEN OTHERS THEN

Line 1035: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1031: x_msg_count => x_msg_count,
1032: x_msg_data => x_msg_data,
1033: p_api_type => g_api_type);
1034: WHEN OTHERS THEN
1035: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1036: p_api_name => l_api_name,
1037: p_pkg_name => G_PKG_NAME,
1038: p_exc_name => 'OTHERS',
1039: x_msg_count => x_msg_count,

Line 1112: OKL_API.SET_MESSAGE( g_app_name

1108: VALUE => p_value2 );
1109: END IF;
1110: l_msg := FND_MESSAGE.GET;
1111: IF ( UPPER(p_during_upd_flag) = 'T' ) THEN
1112: OKL_API.SET_MESSAGE( g_app_name
1113: ,p_msg_name
1114: ,p_token1
1115: ,p_value1
1116: ,p_token2

Line 1156: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1152: x_error_msgs_tbl OUT NOCOPY error_msgs_tbl_type) IS
1153: -- Variables Declarations
1154: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1155: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'VALIDATE_LEASEAPP_TEMPLATE';
1156: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1157: -- Record/Table Type Declarations
1158: l_latv_rec latv_rec_type;
1159: lx_latv_rec latv_rec_type;
1160: l_lavv_rec lavv_rec_type;

Line 1216: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1212: l_parameter_list WF_PARAMETER_LIST_T;
1213: l_event_name wf_events.name%TYPE;
1214: -- bug 4741121 - smadhava - Added - End
1215: BEGIN
1216: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1217: -- check for logging on PROCEDURE level
1218: l_debug_enabled := okl_debug_pub.check_log_enabled;
1219: -- call START_ACTIVITY to create savepoint, check compatibility
1220: -- and initialize message list

Line 1221: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

1217: -- check for logging on PROCEDURE level
1218: l_debug_enabled := okl_debug_pub.check_log_enabled;
1219: -- call START_ACTIVITY to create savepoint, check compatibility
1220: -- and initialize message list
1221: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
1222: ,p_pkg_name => G_PKG_NAME
1223: ,p_init_msg_list => p_init_msg_list
1224: ,l_api_version => l_api_version
1225: ,p_api_version => p_api_version

Line 1229: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1225: ,p_api_version => p_api_version
1226: ,p_api_type => g_api_type
1227: ,x_return_status => x_return_status);
1228: -- check if activity started successfully
1229: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: END IF;

Line 1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1226: ,p_api_type => g_api_type
1227: ,x_return_status => x_return_status);
1228: -- check if activity started successfully
1229: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: l_latv_rec := p_latv_rec;

Line 1231: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1227: ,x_return_status => x_return_status);
1228: -- check if activity started successfully
1229: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: l_latv_rec := p_latv_rec;
1235: l_lavv_rec := p_lavv_rec;

Line 1232: RAISE OKL_API.G_EXCEPTION_ERROR;

1228: -- check if activity started successfully
1229: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: l_latv_rec := p_latv_rec;
1235: l_lavv_rec := p_lavv_rec;
1236: --Validate the Checklist Template and Poulate the Error Table

Line 1288: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1284: , l_return_status
1285: , x_msg_count
1286: , x_msg_data
1287: , l_lavv_rec.ID);
1288: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1289: RAISE OKL_API.G_EXCEPTION_ERROR;
1290: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1292: END IF;

Line 1289: RAISE OKL_API.G_EXCEPTION_ERROR;

1285: , x_msg_count
1286: , x_msg_data
1287: , l_lavv_rec.ID);
1288: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1289: RAISE OKL_API.G_EXCEPTION_ERROR;
1290: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1292: END IF;
1293:

Line 1290: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1286: , x_msg_data
1287: , l_lavv_rec.ID);
1288: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1289: RAISE OKL_API.G_EXCEPTION_ERROR;
1290: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1292: END IF;
1293:
1294: ELSE

Line 1291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1287: , l_lavv_rec.ID);
1288: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1289: RAISE OKL_API.G_EXCEPTION_ERROR;
1290: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1292: END IF;
1293:
1294: ELSE
1295: OKL_WF_PVT.raise_event(p_api_version => p_api_version,

Line 1302: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1298: x_msg_count => x_msg_count,
1299: x_msg_data => x_msg_data,
1300: p_event_name => l_event_name,
1301: p_parameters => l_parameter_list);
1302: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1305: RAISE OKL_API.G_EXCEPTION_ERROR;
1306: END IF;

Line 1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1299: x_msg_data => x_msg_data,
1300: p_event_name => l_event_name,
1301: p_parameters => l_parameter_list);
1302: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1305: RAISE OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307: END IF;

Line 1304: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1300: p_event_name => l_event_name,
1301: p_parameters => l_parameter_list);
1302: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1305: RAISE OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307: END IF;
1308: -- bug 4741121 - smadhava - Modified - End

Line 1305: RAISE OKL_API.G_EXCEPTION_ERROR;

1301: p_parameters => l_parameter_list);
1302: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1305: RAISE OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307: END IF;
1308: -- bug 4741121 - smadhava - Modified - End
1309: END IF;

Line 1329: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

1325:
1326: x_error_msgs_tbl := l_error_msgs_tbl;
1327: x_latv_rec := l_latv_rec;
1328: x_lavv_rec := l_lavv_rec;
1329: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1330: ,x_msg_data => x_msg_data);
1331: EXCEPTION
1332: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1333: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1332: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1328: x_lavv_rec := l_lavv_rec;
1329: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1330: ,x_msg_data => x_msg_data);
1331: EXCEPTION
1332: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1333: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1334: p_api_name => l_api_name,
1335: p_pkg_name => G_PKG_NAME,
1336: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1333: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1329: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1330: ,x_msg_data => x_msg_data);
1331: EXCEPTION
1332: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1333: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1334: p_api_name => l_api_name,
1335: p_pkg_name => G_PKG_NAME,
1336: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1337: x_msg_count => x_msg_count,

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

1332: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1333: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1334: p_api_name => l_api_name,
1335: p_pkg_name => G_PKG_NAME,
1336: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1337: x_msg_count => x_msg_count,
1338: x_msg_data => x_msg_data,
1339: p_api_type => g_api_type);
1340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1336: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1337: x_msg_count => x_msg_count,
1338: x_msg_data => x_msg_data,
1339: p_api_type => g_api_type);
1340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1342: p_api_name => l_api_name,
1343: p_pkg_name => G_PKG_NAME,
1344: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1337: x_msg_count => x_msg_count,
1338: x_msg_data => x_msg_data,
1339: p_api_type => g_api_type);
1340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1342: p_api_name => l_api_name,
1343: p_pkg_name => G_PKG_NAME,
1344: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1345: x_msg_count => x_msg_count,

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

1340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1341: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1342: p_api_name => l_api_name,
1343: p_pkg_name => G_PKG_NAME,
1344: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1345: x_msg_count => x_msg_count,
1346: x_msg_data => x_msg_data,
1347: p_api_type => g_api_type);
1348: WHEN OTHERS THEN

Line 1349: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1345: x_msg_count => x_msg_count,
1346: x_msg_data => x_msg_data,
1347: p_api_type => g_api_type);
1348: WHEN OTHERS THEN
1349: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1350: p_api_name => l_api_name,
1351: p_pkg_name => G_PKG_NAME,
1352: p_exc_name => 'OTHERS',
1353: x_msg_count => x_msg_count,

Line 1384: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1380: x_latv_rec OUT NOCOPY latv_rec_type)IS
1381: -- Variables Declarations
1382: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1383: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'MAX_VALID_FROM_DATE';
1384: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1385: -- Record/Table Type Declarations
1386: l_latv_rec latv_rec_type;
1387: l_max_start_date DATE;
1388: l_valid_from DATE;

Line 1444: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1440: WHERE LAV1.LEASEAPP_TEMPLATE_ID = LAT.ID);
1441: --Fixed ssdeshpa Bug # 6487421 End
1442: --asawanka bug 4966317 fix ends
1443: BEGIN
1444: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1445: -- call START_ACTIVITY to create savepoint, check compatibility
1446: -- and initialize message list
1447: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
1448: ,p_pkg_name => G_PKG_NAME

Line 1447: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

1443: BEGIN
1444: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1445: -- call START_ACTIVITY to create savepoint, check compatibility
1446: -- and initialize message list
1447: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
1448: ,p_pkg_name => G_PKG_NAME
1449: ,p_init_msg_list => p_init_msg_list
1450: ,l_api_version => l_api_version
1451: ,p_api_version => p_api_version

Line 1455: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1451: ,p_api_version => p_api_version
1452: ,p_api_type => g_api_type
1453: ,x_return_status => x_return_status);
1454: -- check if activity started successfully
1455: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: END IF;

Line 1456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1452: ,p_api_type => g_api_type
1453: ,x_return_status => x_return_status);
1454: -- check if activity started successfully
1455: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: END IF;
1460: l_latv_rec := p_latv_rec;

Line 1457: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1453: ,x_return_status => x_return_status);
1454: -- check if activity started successfully
1455: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: END IF;
1460: l_latv_rec := p_latv_rec;
1461: -- Fetch the Maximum of Start Date of the Vendor Program and Lease application using this template

Line 1458: RAISE OKL_API.G_EXCEPTION_ERROR;

1454: -- check if activity started successfully
1455: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: END IF;
1460: l_latv_rec := p_latv_rec;
1461: -- Fetch the Maximum of Start Date of the Vendor Program and Lease application using this template
1462: FOR r_new_date_rec IN c_get_max_start_date(l_latv_rec.id) LOOP

Line 1495: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

1491: -- New version template valid from date will be updated with l_max_start_date + 1
1492: l_latv_rec.valid_from := l_max_start_date + 1;
1493: --asawanka bug 4966317 fix ends
1494: x_latv_rec := l_latv_rec;
1495: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1496: ,x_msg_data => x_msg_data);
1497: EXCEPTION
1498: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1498: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1494: x_latv_rec := l_latv_rec;
1495: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1496: ,x_msg_data => x_msg_data);
1497: EXCEPTION
1498: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1500: p_api_name => l_api_name,
1501: p_pkg_name => G_PKG_NAME,
1502: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1495: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1496: ,x_msg_data => x_msg_data);
1497: EXCEPTION
1498: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1500: p_api_name => l_api_name,
1501: p_pkg_name => G_PKG_NAME,
1502: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1503: x_msg_count => x_msg_count,

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

1498: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1500: p_api_name => l_api_name,
1501: p_pkg_name => G_PKG_NAME,
1502: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1503: x_msg_count => x_msg_count,
1504: x_msg_data => x_msg_data,
1505: p_api_type => g_api_type);
1506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1502: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1503: x_msg_count => x_msg_count,
1504: x_msg_data => x_msg_data,
1505: p_api_type => g_api_type);
1506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1507: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1508: p_api_name => l_api_name,
1509: p_pkg_name => G_PKG_NAME,
1510: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1507: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1503: x_msg_count => x_msg_count,
1504: x_msg_data => x_msg_data,
1505: p_api_type => g_api_type);
1506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1507: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1508: p_api_name => l_api_name,
1509: p_pkg_name => G_PKG_NAME,
1510: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1511: x_msg_count => x_msg_count,

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

1506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1507: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1508: p_api_name => l_api_name,
1509: p_pkg_name => G_PKG_NAME,
1510: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1511: x_msg_count => x_msg_count,
1512: x_msg_data => x_msg_data,
1513: p_api_type => g_api_type);
1514: WHEN OTHERS THEN

Line 1515: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1511: x_msg_count => x_msg_count,
1512: x_msg_data => x_msg_data,
1513: p_api_type => g_api_type);
1514: WHEN OTHERS THEN
1515: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1516: p_api_name => l_api_name,
1517: p_pkg_name => G_PKG_NAME,
1518: p_exc_name => 'OTHERS',
1519: x_msg_count => x_msg_count,