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

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

2: /* $Header: OKLRRCSB.pls 120.4 2005/09/14 06:43:12 smadhava noship $ */
3:
4: -- Function checks if there are repetitions of items or categories in a residual category set
5: FUNCTION check_existence (p_source_code VARCHAR2, p_res_tbl IN okl_res_tbl) RETURN VARCHAR2 IS
6: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7:
8: l_temp_resi_category_set_id NUMBER := NULL;
9: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'check_existence';
10:

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

25: END IF;
26: END LOOP;
27:
28: IF l_count > 1 THEN
29: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
30: p_msg_name => 'OKL_ITEM_REPEAT');
31: RAISE OKL_API.G_EXCEPTION_ERROR;
32: END IF;
33:

Line 31: RAISE OKL_API.G_EXCEPTION_ERROR;

27:
28: IF l_count > 1 THEN
29: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
30: p_msg_name => 'OKL_ITEM_REPEAT');
31: RAISE OKL_API.G_EXCEPTION_ERROR;
32: END IF;
33:
34: ELSIF p_source_code = G_CAT_ITEM_CAT THEN
35: FOR j IN p_res_tbl.FIRST..p_res_tbl.LAST

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

40: END IF;
41: END LOOP;
42:
43: IF l_count > 1 THEN
44: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
45: p_msg_name => 'OKL_ITEM_CAT_REPEAT');
46: RAISE OKL_API.G_EXCEPTION_ERROR;
47: END IF;
48:

Line 46: RAISE OKL_API.G_EXCEPTION_ERROR;

42:
43: IF l_count > 1 THEN
44: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
45: p_msg_name => 'OKL_ITEM_CAT_REPEAT');
46: RAISE OKL_API.G_EXCEPTION_ERROR;
47: END IF;
48:
49: END IF; -- end of source code check
50: END LOOP; -- end of for loop

Line 54: WHEN OKL_API.G_EXCEPTION_ERROR THEN

50: END LOOP; -- end of for loop
51:
52: RETURN (l_return_status);
53: EXCEPTION
54: WHEN OKL_API.G_EXCEPTION_ERROR THEN
55: RETURN OKL_API.G_RET_STS_ERROR;
56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
58: WHEN OTHERS THEN

Line 55: RETURN OKL_API.G_RET_STS_ERROR;

51:
52: RETURN (l_return_status);
53: EXCEPTION
54: WHEN OKL_API.G_EXCEPTION_ERROR THEN
55: RETURN OKL_API.G_RET_STS_ERROR;
56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
58: WHEN OTHERS THEN
59: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

52: RETURN (l_return_status);
53: EXCEPTION
54: WHEN OKL_API.G_EXCEPTION_ERROR THEN
55: RETURN OKL_API.G_RET_STS_ERROR;
56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
58: WHEN OTHERS THEN
59: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
60: p_msg_name => G_DB_ERROR,

Line 57: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;

53: EXCEPTION
54: WHEN OKL_API.G_EXCEPTION_ERROR THEN
55: RETURN OKL_API.G_RET_STS_ERROR;
56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
58: WHEN OTHERS THEN
59: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
60: p_msg_name => G_DB_ERROR,
61: p_token1 => G_PROG_NAME_TOKEN,

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

55: RETURN OKL_API.G_RET_STS_ERROR;
56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
58: WHEN OTHERS THEN
59: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
60: p_msg_name => G_DB_ERROR,
61: p_token1 => G_PROG_NAME_TOKEN,
62: p_token1_value => l_api_name,
63: p_token2 => G_SQLCODE_TOKEN,

Line 67: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;

63: p_token2 => G_SQLCODE_TOKEN,
64: p_token2_value => sqlcode,
65: p_token3 => G_SQLERRM_TOKEN,
66: p_token3_value => sqlerrm);
67: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
68: END check_existence;
69:
70: /*
71: Function checks the inventory for the presence of the items/item categories.

Line 146: WHEN OKL_API.G_EXCEPTION_ERROR THEN

142:
143: RETURN l_make_inactive;
144:
145: EXCEPTION
146: WHEN OKL_API.G_EXCEPTION_ERROR THEN
147: RETURN OKL_API.G_RET_STS_ERROR;
148: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
149: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
150: WHEN OTHERS THEN

Line 147: RETURN OKL_API.G_RET_STS_ERROR;

143: RETURN l_make_inactive;
144:
145: EXCEPTION
146: WHEN OKL_API.G_EXCEPTION_ERROR THEN
147: RETURN OKL_API.G_RET_STS_ERROR;
148: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
149: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
150: WHEN OTHERS THEN
151: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 148: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

144:
145: EXCEPTION
146: WHEN OKL_API.G_EXCEPTION_ERROR THEN
147: RETURN OKL_API.G_RET_STS_ERROR;
148: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
149: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
150: WHEN OTHERS THEN
151: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
152: p_msg_name => G_DB_ERROR,

Line 149: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;

145: EXCEPTION
146: WHEN OKL_API.G_EXCEPTION_ERROR THEN
147: RETURN OKL_API.G_RET_STS_ERROR;
148: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
149: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
150: WHEN OTHERS THEN
151: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
152: p_msg_name => G_DB_ERROR,
153: p_token1 => G_PROG_NAME_TOKEN,

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

147: RETURN OKL_API.G_RET_STS_ERROR;
148: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
149: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
150: WHEN OTHERS THEN
151: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
152: p_msg_name => G_DB_ERROR,
153: p_token1 => G_PROG_NAME_TOKEN,
154: p_token1_value => l_api_name,
155: p_token2 => G_SQLCODE_TOKEN,

Line 159: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;

155: p_token2 => G_SQLCODE_TOKEN,
156: p_token2_value => sqlcode,
157: p_token3 => G_SQLERRM_TOKEN,
158: p_token3_value => sqlerrm);
159: RETURN OKL_API.G_RET_STS_UNEXP_ERROR;
160: END check_update_status;
161:
162: procedure create_rcs (
163: p_api_version IN NUMBER

Line 164: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

160: END check_update_status;
161:
162: procedure create_rcs (
163: p_api_version IN NUMBER
164: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
165: , x_return_status OUT NOCOPY VARCHAR2
166: , x_msg_count OUT NOCOPY NUMBER
167: , x_msg_data OUT NOCOPY VARCHAR2
168: , p_rcsv_rec IN okl_rcsv_rec

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

179: l_api_version CONSTANT NUMBER := p_api_version;
180: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
181: l_msg_count NUMBER := x_msg_count ;
182: l_msg_data VARCHAR2(2000);
183: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
184:
185: l_rcsv_rec okl_rcsv_rec := p_rcsv_rec;
186: l_res_tbl okl_res_tbl := p_res_tbl;
187:

Line 196: l_return_status := OKL_API.start_activity(l_api_name

192: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
193: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call create_rcs');
194: END IF;
195:
196: l_return_status := OKL_API.start_activity(l_api_name
197: ,G_PKG_NAME
198: ,p_init_msg_list
199: ,l_api_version
200: ,p_api_version

Line 203: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

199: ,l_api_version
200: ,p_api_version
201: ,'_PVT'
202: ,x_return_status);
203: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
204: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
205: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
206: raise OKL_API.G_EXCEPTION_ERROR;
207: END IF;

Line 204: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

200: ,p_api_version
201: ,'_PVT'
202: ,x_return_status);
203: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
204: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
205: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
206: raise OKL_API.G_EXCEPTION_ERROR;
207: END IF;
208:

Line 205: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

201: ,'_PVT'
202: ,x_return_status);
203: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
204: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
205: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
206: raise OKL_API.G_EXCEPTION_ERROR;
207: END IF;
208:
209: -- Set the status of the residual category set to ACTIVE

Line 206: raise OKL_API.G_EXCEPTION_ERROR;

202: ,x_return_status);
203: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
204: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
205: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
206: raise OKL_API.G_EXCEPTION_ERROR;
207: END IF;
208:
209: -- Set the status of the residual category set to ACTIVE
210: l_rcsv_rec.sts_code := OKL_RCS_PVT.G_STS_ACTIVE;

Line 223: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

219: , p_rcsv_rec => l_rcsv_rec
220: , x_rcsv_rec => x_rcsv_rec);
221:
222:
223: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
224: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
226: raise OKL_API.G_EXCEPTION_ERROR;
227: END IF;

Line 224: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

220: , x_rcsv_rec => x_rcsv_rec);
221:
222:
223: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
224: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
226: raise OKL_API.G_EXCEPTION_ERROR;
227: END IF;
228:

Line 225: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

221:
222:
223: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
224: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
226: raise OKL_API.G_EXCEPTION_ERROR;
227: END IF;
228:
229: -- Assign the foreign key to the child table

Line 226: raise OKL_API.G_EXCEPTION_ERROR;

222:
223: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
224: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
226: raise OKL_API.G_EXCEPTION_ERROR;
227: END IF;
228:
229: -- Assign the foreign key to the child table
230: for i IN l_res_tbl.FIRST..l_res_tbl.LAST

Line 239: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

235:
236:
237: -- Check for the presence of duplicate items or item categories
238: l_return_status := check_existence(l_rcsv_rec.source_code, p_res_tbl);
239: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
240: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
241: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
242: raise OKL_API.G_EXCEPTION_ERROR;
243: END IF;

Line 240: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

236:
237: -- Check for the presence of duplicate items or item categories
238: l_return_status := check_existence(l_rcsv_rec.source_code, p_res_tbl);
239: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
240: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
241: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
242: raise OKL_API.G_EXCEPTION_ERROR;
243: END IF;
244:

Line 241: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

237: -- Check for the presence of duplicate items or item categories
238: l_return_status := check_existence(l_rcsv_rec.source_code, p_res_tbl);
239: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
240: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
241: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
242: raise OKL_API.G_EXCEPTION_ERROR;
243: END IF;
244:
245: -- Insert rows in the lines table for the respective header

Line 242: raise OKL_API.G_EXCEPTION_ERROR;

238: l_return_status := check_existence(l_rcsv_rec.source_code, p_res_tbl);
239: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
240: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
241: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
242: raise OKL_API.G_EXCEPTION_ERROR;
243: END IF;
244:
245: -- Insert rows in the lines table for the respective header
246: okl_res_pvt.insert_row(

Line 254: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

250: , x_msg_count => x_msg_count
251: , x_msg_data => x_msg_data
252: , p_res_tbl => l_res_tbl
253: , x_res_tbl => x_res_tbl);
254: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
255: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
257: raise OKL_API.G_EXCEPTION_ERROR;
258: END IF;

Line 255: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

251: , x_msg_data => x_msg_data
252: , p_res_tbl => l_res_tbl
253: , x_res_tbl => x_res_tbl);
254: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
255: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
257: raise OKL_API.G_EXCEPTION_ERROR;
258: END IF;
259: x_return_status := l_return_status;

Line 256: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

252: , p_res_tbl => l_res_tbl
253: , x_res_tbl => x_res_tbl);
254: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
255: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
257: raise OKL_API.G_EXCEPTION_ERROR;
258: END IF;
259: x_return_status := l_return_status;
260: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 257: raise OKL_API.G_EXCEPTION_ERROR;

253: , x_res_tbl => x_res_tbl);
254: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
255: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
257: raise OKL_API.G_EXCEPTION_ERROR;
258: END IF;
259: x_return_status := l_return_status;
260: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
261:

Line 260: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

256: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
257: raise OKL_API.G_EXCEPTION_ERROR;
258: END IF;
259: x_return_status := l_return_status;
260: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
261:
262:
263: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
264: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call create_rcs');

Line 272: WHEN OKL_API.G_EXCEPTION_ERROR THEN

268: WHEN G_EXCEPTION_HALT_VALIDATION then
269: -- No action necessary.
270: NULL;
271:
272: WHEN OKL_API.G_EXCEPTION_ERROR THEN
273:
274: x_return_status := OKL_API.HANDLE_EXCEPTIONS
275: (
276: l_api_name,

Line 274: x_return_status := OKL_API.HANDLE_EXCEPTIONS

270: NULL;
271:
272: WHEN OKL_API.G_EXCEPTION_ERROR THEN
273:
274: x_return_status := OKL_API.HANDLE_EXCEPTIONS
275: (
276: l_api_name,
277: G_PKG_NAME,
278: 'OKL_API.G_RET_STS_ERROR',

Line 278: 'OKL_API.G_RET_STS_ERROR',

274: x_return_status := OKL_API.HANDLE_EXCEPTIONS
275: (
276: l_api_name,
277: G_PKG_NAME,
278: 'OKL_API.G_RET_STS_ERROR',
279: x_msg_count,
280: x_msg_data,
281: '_PVT'
282: );

Line 284: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

280: x_msg_data,
281: '_PVT'
282: );
283:
284: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
285:
286: x_return_status := OKL_API.HANDLE_EXCEPTIONS
287: (
288: l_api_name,

Line 286: x_return_status := OKL_API.HANDLE_EXCEPTIONS

282: );
283:
284: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
285:
286: x_return_status := OKL_API.HANDLE_EXCEPTIONS
287: (
288: l_api_name,
289: G_PKG_NAME,
290: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 290: 'OKL_API.G_RET_STS_UNEXP_ERROR',

286: x_return_status := OKL_API.HANDLE_EXCEPTIONS
287: (
288: l_api_name,
289: G_PKG_NAME,
290: 'OKL_API.G_RET_STS_UNEXP_ERROR',
291: x_msg_count,
292: x_msg_data,
293: '_PVT'
294: );

Line 298: x_return_status := OKL_API.HANDLE_EXCEPTIONS

294: );
295:
296: WHEN OTHERS THEN
297:
298: x_return_status := OKL_API.HANDLE_EXCEPTIONS
299: (
300: l_api_name,
301: G_PKG_NAME,
302: 'OTHERS',

Line 316: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

312: any of the existing lines are not present in the inventory.
313: */
314: PROCEDURE update_rcs (
315: p_api_version IN NUMBER
316: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
317: , x_return_status OUT NOCOPY VARCHAR2
318: , x_msg_count OUT NOCOPY NUMBER
319: , x_msg_data OUT NOCOPY VARCHAR2
320: , p_rcsv_rec IN okl_rcsv_rec

Line 350: l_return_status := OKL_API.start_activity(l_api_name

346: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
347: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
348: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call update_rcs');
349: END IF;
350: l_return_status := OKL_API.start_activity(l_api_name
351: ,G_PKG_NAME
352: ,p_init_msg_list
353: ,l_api_version
354: ,p_api_version

Line 357: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

353: ,l_api_version
354: ,p_api_version
355: ,'_PVT'
356: ,x_return_status);
357: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
358: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
360: raise OKL_API.G_EXCEPTION_ERROR;
361: END IF;

Line 358: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

354: ,p_api_version
355: ,'_PVT'
356: ,x_return_status);
357: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
358: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
360: raise OKL_API.G_EXCEPTION_ERROR;
361: END IF;
362:

Line 359: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

355: ,'_PVT'
356: ,x_return_status);
357: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
358: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
360: raise OKL_API.G_EXCEPTION_ERROR;
361: END IF;
362:
363: j:=1;

Line 360: raise OKL_API.G_EXCEPTION_ERROR;

356: ,x_return_status);
357: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
358: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
360: raise OKL_API.G_EXCEPTION_ERROR;
361: END IF;
362:
363: j:=1;
364: k:=1;

Line 368: IF p_res_tbl(i).resi_cat_object_id IS NULL OR p_res_tbl(i).resi_cat_object_id = OKL_API.G_MISS_NUM THEN

364: k:=1;
365: FOR i IN p_res_tbl.FIRST..p_res_tbl.LAST
366: LOOP
367:
368: IF p_res_tbl(i).resi_cat_object_id IS NULL OR p_res_tbl(i).resi_cat_object_id = OKL_API.G_MISS_NUM THEN
369: lp_res_crt_tbl(j) := p_res_tbl(i);
370: lp_res_crt_tbl(j).resi_category_set_id := p_rcsv_rec.resi_category_set_id;
371: j := j+1;
372:

Line 382: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

378:
379:
380: -- Check for the presence of duplicate items or item categories
381: l_return_status := check_existence(lp_rcsv_rec.source_code, p_res_tbl);
382: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
383: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
385: raise OKL_API.G_EXCEPTION_ERROR;
386: END IF;

Line 383: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

379:
380: -- Check for the presence of duplicate items or item categories
381: l_return_status := check_existence(lp_rcsv_rec.source_code, p_res_tbl);
382: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
383: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
385: raise OKL_API.G_EXCEPTION_ERROR;
386: END IF;
387:

Line 384: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

380: -- Check for the presence of duplicate items or item categories
381: l_return_status := check_existence(lp_rcsv_rec.source_code, p_res_tbl);
382: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
383: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
385: raise OKL_API.G_EXCEPTION_ERROR;
386: END IF;
387:
388: -- Update the objects if any

Line 385: raise OKL_API.G_EXCEPTION_ERROR;

381: l_return_status := check_existence(lp_rcsv_rec.source_code, p_res_tbl);
382: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
383: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
385: raise OKL_API.G_EXCEPTION_ERROR;
386: END IF;
387:
388: -- Update the objects if any
389: OKL_RES_PVT.update_row(

Line 398: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

394: , x_msg_data => x_msg_data
395: , p_res_tbl => lp_res_upd_tbl
396: , x_res_tbl => lx_res_upd_tbl);
397:
398: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
399: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
401: raise OKL_API.G_EXCEPTION_ERROR;
402: END IF;

Line 399: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

395: , p_res_tbl => lp_res_upd_tbl
396: , x_res_tbl => lx_res_upd_tbl);
397:
398: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
399: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
401: raise OKL_API.G_EXCEPTION_ERROR;
402: END IF;
403:

Line 400: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

396: , x_res_tbl => lx_res_upd_tbl);
397:
398: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
399: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
401: raise OKL_API.G_EXCEPTION_ERROR;
402: END IF;
403:
404:

Line 401: raise OKL_API.G_EXCEPTION_ERROR;

397:
398: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
399: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
401: raise OKL_API.G_EXCEPTION_ERROR;
402: END IF;
403:
404:
405: OKL_RES_PVT.insert_row(

Line 414: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

410: , x_msg_data => x_msg_data
411: , p_res_tbl => lp_res_crt_tbl
412: , x_res_tbl => lx_res_crt_tbl);
413:
414: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
415: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
417: raise OKL_API.G_EXCEPTION_ERROR;
418: END IF;

Line 415: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

411: , p_res_tbl => lp_res_crt_tbl
412: , x_res_tbl => lx_res_crt_tbl);
413:
414: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
415: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
417: raise OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419:

Line 416: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

412: , x_res_tbl => lx_res_crt_tbl);
413:
414: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
415: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
417: raise OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419:
420: /* Call function to check if the residual category set needs to be made Inactive */

Line 417: raise OKL_API.G_EXCEPTION_ERROR;

413:
414: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
415: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
417: raise OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419:
420: /* Call function to check if the residual category set needs to be made Inactive */
421: l_make_inactive := check_update_status( p_rcsv_rec.source_code, lp_res_upd_tbl);

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

422:
423:
424: IF l_make_inactive = 'yes' THEN
425: lp_rcsv_rec.sts_code := G_STS_INACTIVE;
426: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
427: p_msg_name => 'OKL_RES_CAT_INACTIVATED',
428: p_token1 => 'NAME',
429: p_token1_value => lp_rcsv_rec.resi_cat_name);
430: ELSE

Line 444: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN

440: , x_msg_data => x_msg_data
441: , p_rcsv_rec => lp_rcsv_rec
442: , x_rcsv_rec => x_rcsv_rec);
443:
444: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
445: RAISE OKL_API.G_EXCEPTION_ERROR;
446: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
448: END IF;

Line 445: RAISE OKL_API.G_EXCEPTION_ERROR;

441: , p_rcsv_rec => lp_rcsv_rec
442: , x_rcsv_rec => x_rcsv_rec);
443:
444: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
445: RAISE OKL_API.G_EXCEPTION_ERROR;
446: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
448: END IF;
449: x_return_status := l_return_status;

Line 446: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

442: , x_rcsv_rec => x_rcsv_rec);
443:
444: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
445: RAISE OKL_API.G_EXCEPTION_ERROR;
446: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
448: END IF;
449: x_return_status := l_return_status;
450: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

443:
444: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
445: RAISE OKL_API.G_EXCEPTION_ERROR;
446: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
448: END IF;
449: x_return_status := l_return_status;
450: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
451:

Line 450: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

446: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
448: END IF;
449: x_return_status := l_return_status;
450: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
451:
452: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
453: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call update_rcs');
454: END IF;

Line 460: WHEN OKL_API.G_EXCEPTION_ERROR THEN

456: WHEN G_EXCEPTION_HALT_VALIDATION then
457: -- No action necessary.
458: NULL;
459:
460: WHEN OKL_API.G_EXCEPTION_ERROR THEN
461:
462: x_return_status := OKL_API.HANDLE_EXCEPTIONS
463: (
464: l_api_name,

Line 462: x_return_status := OKL_API.HANDLE_EXCEPTIONS

458: NULL;
459:
460: WHEN OKL_API.G_EXCEPTION_ERROR THEN
461:
462: x_return_status := OKL_API.HANDLE_EXCEPTIONS
463: (
464: l_api_name,
465: G_PKG_NAME,
466: 'OKL_API.G_RET_STS_ERROR',

Line 466: 'OKL_API.G_RET_STS_ERROR',

462: x_return_status := OKL_API.HANDLE_EXCEPTIONS
463: (
464: l_api_name,
465: G_PKG_NAME,
466: 'OKL_API.G_RET_STS_ERROR',
467: x_msg_count,
468: x_msg_data,
469: '_PVT'
470: );

Line 472: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

468: x_msg_data,
469: '_PVT'
470: );
471:
472: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
473:
474: x_return_status := OKL_API.HANDLE_EXCEPTIONS
475: (
476: l_api_name,

Line 474: x_return_status := OKL_API.HANDLE_EXCEPTIONS

470: );
471:
472: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
473:
474: x_return_status := OKL_API.HANDLE_EXCEPTIONS
475: (
476: l_api_name,
477: G_PKG_NAME,
478: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 478: 'OKL_API.G_RET_STS_UNEXP_ERROR',

474: x_return_status := OKL_API.HANDLE_EXCEPTIONS
475: (
476: l_api_name,
477: G_PKG_NAME,
478: 'OKL_API.G_RET_STS_UNEXP_ERROR',
479: x_msg_count,
480: x_msg_data,
481: '_PVT'
482: );

Line 486: x_return_status := OKL_API.HANDLE_EXCEPTIONS

482: );
483:
484: WHEN OTHERS THEN
485:
486: x_return_status := OKL_API.HANDLE_EXCEPTIONS
487: (
488: l_api_name,
489: G_PKG_NAME,
490: 'OTHERS',

Line 504: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

500: */
501:
502: PROCEDURE activate_rcs (
503: p_api_version IN NUMBER
504: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
505: , x_return_status OUT NOCOPY VARCHAR2
506: , x_msg_count OUT NOCOPY NUMBER
507: , x_msg_data OUT NOCOPY VARCHAR2
508: , p_rcsv_rec IN okl_rcsv_rec

Line 531: l_return_status := OKL_API.start_activity(l_api_name

527: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
528: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call activate_rcs');
529: END IF;
530:
531: l_return_status := OKL_API.start_activity(l_api_name
532: ,G_PKG_NAME
533: ,p_init_msg_list
534: ,l_api_version
535: ,p_api_version

Line 538: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

534: ,l_api_version
535: ,p_api_version
536: ,'_PVT'
537: ,l_return_status);
538: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
539: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
541: raise OKL_API.G_EXCEPTION_ERROR;
542: END IF;

Line 539: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

535: ,p_api_version
536: ,'_PVT'
537: ,l_return_status);
538: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
539: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
541: raise OKL_API.G_EXCEPTION_ERROR;
542: END IF;
543:

Line 540: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

536: ,'_PVT'
537: ,l_return_status);
538: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
539: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
541: raise OKL_API.G_EXCEPTION_ERROR;
542: END IF;
543:
544:

Line 541: raise OKL_API.G_EXCEPTION_ERROR;

537: ,l_return_status);
538: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
539: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
541: raise OKL_API.G_EXCEPTION_ERROR;
542: END IF;
543:
544:
545:

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

548:
549:
550: IF l_make_inactive = 'yes' THEN
551: lp_rcsv_rec.sts_code := G_STS_INACTIVE;
552: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
553: p_msg_name => 'OKL_RES_CAT_INACTIVE');
554: ELSE
555: lp_rcsv_rec.sts_code := G_STS_ACTIVE;
556:

Line 569: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN

565: END IF;
566:
567:
568:
569: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
570: RAISE OKL_API.G_EXCEPTION_ERROR;
571: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
573: END IF;

Line 570: RAISE OKL_API.G_EXCEPTION_ERROR;

566:
567:
568:
569: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
570: RAISE OKL_API.G_EXCEPTION_ERROR;
571: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
573: END IF;
574: x_return_status := l_return_status;

Line 571: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

567:
568:
569: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
570: RAISE OKL_API.G_EXCEPTION_ERROR;
571: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
573: END IF;
574: x_return_status := l_return_status;
575: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

568:
569: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
570: RAISE OKL_API.G_EXCEPTION_ERROR;
571: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
573: END IF;
574: x_return_status := l_return_status;
575: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
576:

Line 575: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

571: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
573: END IF;
574: x_return_status := l_return_status;
575: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
576:
577:
578: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
579: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call update_rcs');

Line 586: WHEN OKL_API.G_EXCEPTION_ERROR THEN

582: WHEN G_EXCEPTION_HALT_VALIDATION then
583: -- No action necessary.
584: NULL;
585:
586: WHEN OKL_API.G_EXCEPTION_ERROR THEN
587:
588: x_return_status := OKL_API.HANDLE_EXCEPTIONS
589: (
590: l_api_name,

Line 588: x_return_status := OKL_API.HANDLE_EXCEPTIONS

584: NULL;
585:
586: WHEN OKL_API.G_EXCEPTION_ERROR THEN
587:
588: x_return_status := OKL_API.HANDLE_EXCEPTIONS
589: (
590: l_api_name,
591: G_PKG_NAME,
592: 'OKL_API.G_RET_STS_ERROR',

Line 592: 'OKL_API.G_RET_STS_ERROR',

588: x_return_status := OKL_API.HANDLE_EXCEPTIONS
589: (
590: l_api_name,
591: G_PKG_NAME,
592: 'OKL_API.G_RET_STS_ERROR',
593: x_msg_count,
594: x_msg_data,
595: '_PVT'
596: );

Line 598: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

594: x_msg_data,
595: '_PVT'
596: );
597:
598: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
599:
600: x_return_status := OKL_API.HANDLE_EXCEPTIONS
601: (
602: l_api_name,

Line 600: x_return_status := OKL_API.HANDLE_EXCEPTIONS

596: );
597:
598: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
599:
600: x_return_status := OKL_API.HANDLE_EXCEPTIONS
601: (
602: l_api_name,
603: G_PKG_NAME,
604: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 604: 'OKL_API.G_RET_STS_UNEXP_ERROR',

600: x_return_status := OKL_API.HANDLE_EXCEPTIONS
601: (
602: l_api_name,
603: G_PKG_NAME,
604: 'OKL_API.G_RET_STS_UNEXP_ERROR',
605: x_msg_count,
606: x_msg_data,
607: '_PVT'
608: );

Line 612: x_return_status := OKL_API.HANDLE_EXCEPTIONS

608: );
609:
610: WHEN OTHERS THEN
611:
612: x_return_status := OKL_API.HANDLE_EXCEPTIONS
613: (
614: l_api_name,
615: G_PKG_NAME,
616: 'OTHERS',

Line 629: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

625: */
626:
627: PROCEDURE Inactivate_rcs (
628: p_api_version IN NUMBER
629: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
630: , x_return_status OUT NOCOPY VARCHAR2
631: , x_msg_count OUT NOCOPY NUMBER
632: , x_msg_data OUT NOCOPY VARCHAR2
633: , p_rcs_id IN NUMBER

Line 653: l_return_status := OKL_API.start_activity(l_api_name

649: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
650: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
651: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call Inactivate_rcs');
652: END IF;
653: l_return_status := OKL_API.start_activity(l_api_name
654: ,G_PKG_NAME
655: ,p_init_msg_list
656: ,l_api_version
657: ,p_api_version

Line 660: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

656: ,l_api_version
657: ,p_api_version
658: ,'_PVT'
659: ,x_return_status);
660: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
661: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
662: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
663: raise OKL_API.G_EXCEPTION_ERROR;
664: END IF;

Line 661: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

657: ,p_api_version
658: ,'_PVT'
659: ,x_return_status);
660: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
661: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
662: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
663: raise OKL_API.G_EXCEPTION_ERROR;
664: END IF;
665:

Line 662: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

658: ,'_PVT'
659: ,x_return_status);
660: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
661: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
662: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
663: raise OKL_API.G_EXCEPTION_ERROR;
664: END IF;
665:
666: lp_rcsv_rec.resi_category_set_id := p_rcs_id;

Line 663: raise OKL_API.G_EXCEPTION_ERROR;

659: ,x_return_status);
660: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
661: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
662: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
663: raise OKL_API.G_EXCEPTION_ERROR;
664: END IF;
665:
666: lp_rcsv_rec.resi_category_set_id := p_rcs_id;
667: lp_rcsv_rec.sts_code := G_STS_INACTIVE;

Line 680: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN

676: , p_rcsv_rec => lp_rcsv_rec
677: , x_rcsv_rec => x_rcsv_rec);
678:
679:
680: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
681: RAISE OKL_API.G_EXCEPTION_ERROR;
682: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
683: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
684: END IF;

Line 681: RAISE OKL_API.G_EXCEPTION_ERROR;

677: , x_rcsv_rec => x_rcsv_rec);
678:
679:
680: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
681: RAISE OKL_API.G_EXCEPTION_ERROR;
682: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
683: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
684: END IF;
685: x_return_status := l_return_status;

Line 682: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

678:
679:
680: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
681: RAISE OKL_API.G_EXCEPTION_ERROR;
682: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
683: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
684: END IF;
685: x_return_status := l_return_status;
686: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 683: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

679:
680: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
681: RAISE OKL_API.G_EXCEPTION_ERROR;
682: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
683: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
684: END IF;
685: x_return_status := l_return_status;
686: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
687:

Line 686: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

682: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
683: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
684: END IF;
685: x_return_status := l_return_status;
686: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
687:
688: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
689: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call Inactivate_rcs');
690: END IF;

Line 696: WHEN OKL_API.G_EXCEPTION_ERROR THEN

692: WHEN G_EXCEPTION_HALT_VALIDATION then
693: -- No action necessary.
694: NULL;
695:
696: WHEN OKL_API.G_EXCEPTION_ERROR THEN
697:
698: x_return_status := OKL_API.HANDLE_EXCEPTIONS
699: (
700: l_api_name,

Line 698: x_return_status := OKL_API.HANDLE_EXCEPTIONS

694: NULL;
695:
696: WHEN OKL_API.G_EXCEPTION_ERROR THEN
697:
698: x_return_status := OKL_API.HANDLE_EXCEPTIONS
699: (
700: l_api_name,
701: G_PKG_NAME,
702: 'OKL_API.G_RET_STS_ERROR',

Line 702: 'OKL_API.G_RET_STS_ERROR',

698: x_return_status := OKL_API.HANDLE_EXCEPTIONS
699: (
700: l_api_name,
701: G_PKG_NAME,
702: 'OKL_API.G_RET_STS_ERROR',
703: x_msg_count,
704: x_msg_data,
705: '_PVT'
706: );

Line 708: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

704: x_msg_data,
705: '_PVT'
706: );
707:
708: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
709:
710: x_return_status := OKL_API.HANDLE_EXCEPTIONS
711: (
712: l_api_name,

Line 710: x_return_status := OKL_API.HANDLE_EXCEPTIONS

706: );
707:
708: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
709:
710: x_return_status := OKL_API.HANDLE_EXCEPTIONS
711: (
712: l_api_name,
713: G_PKG_NAME,
714: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 714: 'OKL_API.G_RET_STS_UNEXP_ERROR',

710: x_return_status := OKL_API.HANDLE_EXCEPTIONS
711: (
712: l_api_name,
713: G_PKG_NAME,
714: 'OKL_API.G_RET_STS_UNEXP_ERROR',
715: x_msg_count,
716: x_msg_data,
717: '_PVT'
718: );

Line 722: x_return_status := OKL_API.HANDLE_EXCEPTIONS

718: );
719:
720: WHEN OTHERS THEN
721:
722: x_return_status := OKL_API.HANDLE_EXCEPTIONS
723: (
724: l_api_name,
725: G_PKG_NAME,
726: 'OTHERS',

Line 735: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

731: END Inactivate_rcs;
732:
733: PROCEDURE delete_objects(
734: p_api_version IN NUMBER
735: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
736: , x_return_status OUT NOCOPY VARCHAR2
737: , x_msg_count OUT NOCOPY NUMBER
738: , x_msg_data OUT NOCOPY VARCHAR2
739: , p_res_tbl IN okl_res_tbl) IS

Line 757: l_return_status := OKL_API.start_activity(l_api_name

753: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
754: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
755: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call delete_objects');
756: END IF;
757: l_return_status := OKL_API.start_activity(l_api_name
758: ,G_PKG_NAME
759: ,p_init_msg_list
760: ,l_api_version
761: ,p_api_version

Line 764: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

760: ,l_api_version
761: ,p_api_version
762: ,'_PVT'
763: ,x_return_status);
764: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
765: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
766: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
767: raise OKL_API.G_EXCEPTION_ERROR;
768: END IF;

Line 765: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

761: ,p_api_version
762: ,'_PVT'
763: ,x_return_status);
764: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
765: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
766: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
767: raise OKL_API.G_EXCEPTION_ERROR;
768: END IF;
769:

Line 766: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

762: ,'_PVT'
763: ,x_return_status);
764: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
765: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
766: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
767: raise OKL_API.G_EXCEPTION_ERROR;
768: END IF;
769:
770: OKL_RES_PVT.delete_row(

Line 767: raise OKL_API.G_EXCEPTION_ERROR;

763: ,x_return_status);
764: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
765: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
766: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
767: raise OKL_API.G_EXCEPTION_ERROR;
768: END IF;
769:
770: OKL_RES_PVT.delete_row(
771: p_api_version => l_api_version

Line 778: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

774: , x_msg_count => x_msg_count
775: , x_msg_data => x_msg_data
776: , p_res_tbl => p_res_tbl);
777:
778: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
779: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
780: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
781: raise OKL_API.G_EXCEPTION_ERROR;
782: END IF;

Line 779: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

775: , x_msg_data => x_msg_data
776: , p_res_tbl => p_res_tbl);
777:
778: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
779: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
780: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
781: raise OKL_API.G_EXCEPTION_ERROR;
782: END IF;
783:

Line 780: elsif l_return_status = OKL_API.G_RET_STS_ERROR then

776: , p_res_tbl => p_res_tbl);
777:
778: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
779: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
780: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
781: raise OKL_API.G_EXCEPTION_ERROR;
782: END IF;
783:
784: x_return_status := l_return_status;

Line 781: raise OKL_API.G_EXCEPTION_ERROR;

777:
778: if l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
779: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
780: elsif l_return_status = OKL_API.G_RET_STS_ERROR then
781: raise OKL_API.G_EXCEPTION_ERROR;
782: END IF;
783:
784: x_return_status := l_return_status;
785:

Line 786: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

782: END IF;
783:
784: x_return_status := l_return_status;
785:
786: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
787:
788: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
789: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call delete_objects');
790: END IF;

Line 792: WHEN OKL_API.G_EXCEPTION_ERROR THEN

788: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
789: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call delete_objects');
790: END IF;
791: EXCEPTION
792: WHEN OKL_API.G_EXCEPTION_ERROR THEN
793: x_return_status := OKL_API.HANDLE_EXCEPTIONS
794: (
795: l_api_name,
796: G_PKG_NAME,

Line 793: x_return_status := OKL_API.HANDLE_EXCEPTIONS

789: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call delete_objects');
790: END IF;
791: EXCEPTION
792: WHEN OKL_API.G_EXCEPTION_ERROR THEN
793: x_return_status := OKL_API.HANDLE_EXCEPTIONS
794: (
795: l_api_name,
796: G_PKG_NAME,
797: 'OKL_API.G_RET_STS_ERROR',

Line 797: 'OKL_API.G_RET_STS_ERROR',

793: x_return_status := OKL_API.HANDLE_EXCEPTIONS
794: (
795: l_api_name,
796: G_PKG_NAME,
797: 'OKL_API.G_RET_STS_ERROR',
798: x_msg_count,
799: x_msg_data,
800: '_PVT'
801: );

Line 803: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

799: x_msg_data,
800: '_PVT'
801: );
802:
803: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
804:
805: x_return_status := OKL_API.HANDLE_EXCEPTIONS
806: (
807: l_api_name,

Line 805: x_return_status := OKL_API.HANDLE_EXCEPTIONS

801: );
802:
803: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
804:
805: x_return_status := OKL_API.HANDLE_EXCEPTIONS
806: (
807: l_api_name,
808: G_PKG_NAME,
809: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 809: 'OKL_API.G_RET_STS_UNEXP_ERROR',

805: x_return_status := OKL_API.HANDLE_EXCEPTIONS
806: (
807: l_api_name,
808: G_PKG_NAME,
809: 'OKL_API.G_RET_STS_UNEXP_ERROR',
810: x_msg_count,
811: x_msg_data,
812: '_PVT'
813: );

Line 817: x_return_status := OKL_API.HANDLE_EXCEPTIONS

813: );
814:
815: WHEN OTHERS THEN
816:
817: x_return_status := OKL_API.HANDLE_EXCEPTIONS
818: (
819: l_api_name,
820: G_PKG_NAME,
821: 'OTHERS',