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

Line 7: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,

3: ---------------------------------------------------------------------------
4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
9:
10: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
11: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;

Line 8: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
9:
10: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
11: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
12: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;

Line 40: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.

36: ---------------------------------------------------------------------------
37: -- FUNCTION find_highest_exception
38: ---------------------------------------------------------------------------
39: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
40: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE

38: ---------------------------------------------------------------------------
39: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
40: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
45: i INTEGER := 1;
46: BEGIN

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

40: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
45: i INTEGER := 1;
46: BEGIN
47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;

Line 50: IF (p_error_tbl(i).error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

46: BEGIN
47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;
49: LOOP
50: IF (p_error_tbl(i).error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
52: l_return_status := p_error_tbl(i).error_type;
53: END IF;
54: END IF;

Line 51: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;
49: LOOP
50: IF (p_error_tbl(i).error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
52: l_return_status := p_error_tbl(i).error_type;
53: END IF;
54: END IF;
55: EXIT WHEN (i = p_error_tbl.LAST);

Line 150: x_return_status := OKL_API.G_RET_STS_SUCCESS;

146: ) RETURN rps_rec_type IS
147: l_rps_rec rps_rec_type;
148: l_row_notfound BOOLEAN := TRUE;
149: BEGIN
150: x_return_status := OKL_API.G_RET_STS_SUCCESS;
151: l_rps_rec := get_rec(p_rps_rec, l_row_notfound);
152: IF (l_row_notfound) THEN
153: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'STREAM_PARAMETER_ID');
154: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 153: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'STREAM_PARAMETER_ID');

149: BEGIN
150: x_return_status := OKL_API.G_RET_STS_SUCCESS;
151: l_rps_rec := get_rec(p_rps_rec, l_row_notfound);
152: IF (l_row_notfound) THEN
153: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'STREAM_PARAMETER_ID');
154: x_return_status := OKL_API.G_RET_STS_ERROR;
155: END IF;
156: RETURN(l_rps_rec);
157: END get_rec;

Line 154: x_return_status := OKL_API.G_RET_STS_ERROR;

150: x_return_status := OKL_API.G_RET_STS_SUCCESS;
151: l_rps_rec := get_rec(p_rps_rec, l_row_notfound);
152: IF (l_row_notfound) THEN
153: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'STREAM_PARAMETER_ID');
154: x_return_status := OKL_API.G_RET_STS_ERROR;
155: END IF;
156: RETURN(l_rps_rec);
157: END get_rec;
158: -----------------------------------------------------------

Line 176: IF (l_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM ) THEN

172: p_rps_rec IN rps_rec_type
173: ) RETURN rps_rec_type IS
174: l_rps_rec rps_rec_type := p_rps_rec;
175: BEGIN
176: IF (l_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM ) THEN
177: l_rps_rec.stream_parameter_id := NULL;
178: END IF;
179: IF (l_rps_rec.report_id = OKL_API.G_MISS_NUM ) THEN
180: l_rps_rec.report_id := NULL;

Line 179: IF (l_rps_rec.report_id = OKL_API.G_MISS_NUM ) THEN

175: BEGIN
176: IF (l_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM ) THEN
177: l_rps_rec.stream_parameter_id := NULL;
178: END IF;
179: IF (l_rps_rec.report_id = OKL_API.G_MISS_NUM ) THEN
180: l_rps_rec.report_id := NULL;
181: END IF;
182: IF (l_rps_rec.sty_id = OKL_API.G_MISS_NUM ) THEN
183: l_rps_rec.sty_id := NULL;

Line 182: IF (l_rps_rec.sty_id = OKL_API.G_MISS_NUM ) THEN

178: END IF;
179: IF (l_rps_rec.report_id = OKL_API.G_MISS_NUM ) THEN
180: l_rps_rec.report_id := NULL;
181: END IF;
182: IF (l_rps_rec.sty_id = OKL_API.G_MISS_NUM ) THEN
183: l_rps_rec.sty_id := NULL;
184: END IF;
185: IF (l_rps_rec.activity_code = OKL_API.G_MISS_CHAR ) THEN
186: l_rps_rec.activity_code := NULL;

Line 185: IF (l_rps_rec.activity_code = OKL_API.G_MISS_CHAR ) THEN

181: END IF;
182: IF (l_rps_rec.sty_id = OKL_API.G_MISS_NUM ) THEN
183: l_rps_rec.sty_id := NULL;
184: END IF;
185: IF (l_rps_rec.activity_code = OKL_API.G_MISS_CHAR ) THEN
186: l_rps_rec.activity_code := NULL;
187: END IF;
188: IF (l_rps_rec.created_by = OKL_API.G_MISS_NUM ) THEN
189: l_rps_rec.created_by := NULL;

Line 188: IF (l_rps_rec.created_by = OKL_API.G_MISS_NUM ) THEN

184: END IF;
185: IF (l_rps_rec.activity_code = OKL_API.G_MISS_CHAR ) THEN
186: l_rps_rec.activity_code := NULL;
187: END IF;
188: IF (l_rps_rec.created_by = OKL_API.G_MISS_NUM ) THEN
189: l_rps_rec.created_by := NULL;
190: END IF;
191: IF (l_rps_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
192: l_rps_rec.creation_date := NULL;

Line 191: IF (l_rps_rec.creation_date = OKL_API.G_MISS_DATE ) THEN

187: END IF;
188: IF (l_rps_rec.created_by = OKL_API.G_MISS_NUM ) THEN
189: l_rps_rec.created_by := NULL;
190: END IF;
191: IF (l_rps_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
192: l_rps_rec.creation_date := NULL;
193: END IF;
194: IF (l_rps_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
195: l_rps_rec.last_updated_by := NULL;

Line 194: IF (l_rps_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN

190: END IF;
191: IF (l_rps_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
192: l_rps_rec.creation_date := NULL;
193: END IF;
194: IF (l_rps_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
195: l_rps_rec.last_updated_by := NULL;
196: END IF;
197: IF (l_rps_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
198: l_rps_rec.last_update_date := NULL;

Line 197: IF (l_rps_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN

193: END IF;
194: IF (l_rps_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
195: l_rps_rec.last_updated_by := NULL;
196: END IF;
197: IF (l_rps_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
198: l_rps_rec.last_update_date := NULL;
199: END IF;
200: IF (l_rps_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
201: l_rps_rec.last_update_login := NULL;

Line 200: IF (l_rps_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN

196: END IF;
197: IF (l_rps_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
198: l_rps_rec.last_update_date := NULL;
199: END IF;
200: IF (l_rps_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
201: l_rps_rec.last_update_login := NULL;
202: END IF;
203: RETURN(l_rps_rec);
204: END null_out_defaults;

Line 212: x_return_status := OKL_API.G_RET_STS_SUCCESS;

208: PROCEDURE validate_stream_parameter_id(
209: x_return_status OUT NOCOPY VARCHAR2,
210: p_stream_parameter_id IN NUMBER) IS
211: BEGIN
212: x_return_status := OKL_API.G_RET_STS_SUCCESS;
213: IF (p_stream_parameter_id IS NULL) THEN
214: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'stream_parameter_id');
215: x_return_status := OKL_API.G_RET_STS_ERROR;
216: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 214: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'stream_parameter_id');

210: p_stream_parameter_id IN NUMBER) IS
211: BEGIN
212: x_return_status := OKL_API.G_RET_STS_SUCCESS;
213: IF (p_stream_parameter_id IS NULL) THEN
214: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'stream_parameter_id');
215: x_return_status := OKL_API.G_RET_STS_ERROR;
216: RAISE G_EXCEPTION_HALT_VALIDATION;
217: END IF;
218: EXCEPTION

Line 215: x_return_status := OKL_API.G_RET_STS_ERROR;

211: BEGIN
212: x_return_status := OKL_API.G_RET_STS_SUCCESS;
213: IF (p_stream_parameter_id IS NULL) THEN
214: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'stream_parameter_id');
215: x_return_status := OKL_API.G_RET_STS_ERROR;
216: RAISE G_EXCEPTION_HALT_VALIDATION;
217: END IF;
218: EXCEPTION
219: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 222: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

218: EXCEPTION
219: WHEN G_EXCEPTION_HALT_VALIDATION THEN
220: null;
221: WHEN OTHERS THEN
222: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
223: ,p_msg_name => G_UNEXPECTED_ERROR
224: ,p_token1 => G_SQLCODE_TOKEN
225: ,p_token1_value => SQLCODE
226: ,p_token2 => G_SQLERRM_TOKEN

Line 228: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

224: ,p_token1 => G_SQLCODE_TOKEN
225: ,p_token1_value => SQLCODE
226: ,p_token2 => G_SQLERRM_TOKEN
227: ,p_token2_value => SQLERRM);
228: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
229: END validate_stream_parameter_id;
230: ----------------------------------------
231: -- Validate_Attributes for: REPORT_ID --
232: ----------------------------------------

Line 237: x_return_status := OKL_API.G_RET_STS_SUCCESS;

233: PROCEDURE validate_report_id(
234: x_return_status OUT NOCOPY VARCHAR2,
235: p_report_id IN NUMBER) IS
236: BEGIN
237: x_return_status := OKL_API.G_RET_STS_SUCCESS;
238: IF (p_report_id IS NULL) THEN
239: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'report_id');
240: x_return_status := OKL_API.G_RET_STS_ERROR;
241: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 239: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'report_id');

235: p_report_id IN NUMBER) IS
236: BEGIN
237: x_return_status := OKL_API.G_RET_STS_SUCCESS;
238: IF (p_report_id IS NULL) THEN
239: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'report_id');
240: x_return_status := OKL_API.G_RET_STS_ERROR;
241: RAISE G_EXCEPTION_HALT_VALIDATION;
242: END IF;
243: EXCEPTION

Line 240: x_return_status := OKL_API.G_RET_STS_ERROR;

236: BEGIN
237: x_return_status := OKL_API.G_RET_STS_SUCCESS;
238: IF (p_report_id IS NULL) THEN
239: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'report_id');
240: x_return_status := OKL_API.G_RET_STS_ERROR;
241: RAISE G_EXCEPTION_HALT_VALIDATION;
242: END IF;
243: EXCEPTION
244: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 247: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

243: EXCEPTION
244: WHEN G_EXCEPTION_HALT_VALIDATION THEN
245: null;
246: WHEN OTHERS THEN
247: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
248: ,p_msg_name => G_UNEXPECTED_ERROR
249: ,p_token1 => G_SQLCODE_TOKEN
250: ,p_token1_value => SQLCODE
251: ,p_token2 => G_SQLERRM_TOKEN

Line 253: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

249: ,p_token1 => G_SQLCODE_TOKEN
250: ,p_token1_value => SQLCODE
251: ,p_token2 => G_SQLERRM_TOKEN
252: ,p_token2_value => SQLERRM);
253: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
254: END validate_report_id;
255: -------------------------------------
256: -- Validate_Attributes for: STY_ID --
257: -------------------------------------

Line 262: x_return_status := OKL_API.G_RET_STS_SUCCESS;

258: PROCEDURE validate_sty_id(
259: x_return_status OUT NOCOPY VARCHAR2,
260: p_sty_id IN NUMBER) IS
261: BEGIN
262: x_return_status := OKL_API.G_RET_STS_SUCCESS;
263: IF (p_sty_id IS NULL) THEN
264: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'sty_id');
265: x_return_status := OKL_API.G_RET_STS_ERROR;
266: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 264: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'sty_id');

260: p_sty_id IN NUMBER) IS
261: BEGIN
262: x_return_status := OKL_API.G_RET_STS_SUCCESS;
263: IF (p_sty_id IS NULL) THEN
264: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'sty_id');
265: x_return_status := OKL_API.G_RET_STS_ERROR;
266: RAISE G_EXCEPTION_HALT_VALIDATION;
267: END IF;
268: EXCEPTION

Line 265: x_return_status := OKL_API.G_RET_STS_ERROR;

261: BEGIN
262: x_return_status := OKL_API.G_RET_STS_SUCCESS;
263: IF (p_sty_id IS NULL) THEN
264: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'sty_id');
265: x_return_status := OKL_API.G_RET_STS_ERROR;
266: RAISE G_EXCEPTION_HALT_VALIDATION;
267: END IF;
268: EXCEPTION
269: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 272: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

268: EXCEPTION
269: WHEN G_EXCEPTION_HALT_VALIDATION THEN
270: null;
271: WHEN OTHERS THEN
272: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
273: ,p_msg_name => G_UNEXPECTED_ERROR
274: ,p_token1 => G_SQLCODE_TOKEN
275: ,p_token1_value => SQLCODE
276: ,p_token2 => G_SQLERRM_TOKEN

Line 278: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

274: ,p_token1 => G_SQLCODE_TOKEN
275: ,p_token1_value => SQLCODE
276: ,p_token2 => G_SQLERRM_TOKEN
277: ,p_token2_value => SQLERRM);
278: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
279: END validate_sty_id;
280: --------------------------------------------
281: -- Validate_Attributes for: ACTIVITY_CODE --
282: --------------------------------------------

Line 297: x_return_status := OKL_API.G_RET_STS_SUCCESS;

293:
294: l_test_value NUMBER := 0;
295:
296: BEGIN
297: x_return_status := OKL_API.G_RET_STS_SUCCESS;
298: IF (p_activity_code IS NOT NULL) THEN
299: -- validate activity code
300: OPEN c_is_valid_rpt_act_code(p_activity_code);
301:

Line 305: OKL_API.set_message(p_app_name => G_APP_NAME,

301:
302: FETCH c_is_valid_rpt_act_code INTO l_test_value;
303:
304: IF (c_is_valid_rpt_act_code%NOTFOUND) THEN
305: OKL_API.set_message(p_app_name => G_APP_NAME,
306: p_msg_name => G_COL_ERROR,
307: p_token1 => G_COL_NAME_TOKEN,
308: p_token1_value => 'activity_code',
309: p_token2 => G_PKG_NAME_TOKEN,

Line 311: x_return_status := OKL_API.G_RET_STS_ERROR;

307: p_token1 => G_COL_NAME_TOKEN,
308: p_token1_value => 'activity_code',
309: p_token2 => G_PKG_NAME_TOKEN,
310: p_token2_value => G_PKG_NAME);
311: x_return_status := OKL_API.G_RET_STS_ERROR;
312: CLOSE c_is_valid_rpt_act_code;
313: RAISE OKL_API.G_EXCEPTION_ERROR;
314: END IF;
315:

Line 313: RAISE OKL_API.G_EXCEPTION_ERROR;

309: p_token2 => G_PKG_NAME_TOKEN,
310: p_token2_value => G_PKG_NAME);
311: x_return_status := OKL_API.G_RET_STS_ERROR;
312: CLOSE c_is_valid_rpt_act_code;
313: RAISE OKL_API.G_EXCEPTION_ERROR;
314: END IF;
315:
316: CLOSE c_is_valid_rpt_act_code;
317: END IF;

Line 324: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

320:
321: WHEN G_EXCEPTION_HALT_VALIDATION THEN
322: null;
323: WHEN OTHERS THEN
324: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
325: ,p_msg_name => G_UNEXPECTED_ERROR
326: ,p_token1 => G_SQLCODE_TOKEN
327: ,p_token1_value => SQLCODE
328: ,p_token2 => G_SQLERRM_TOKEN

Line 330: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

326: ,p_token1 => G_SQLCODE_TOKEN
327: ,p_token1_value => SQLCODE
328: ,p_token2 => G_SQLERRM_TOKEN
329: ,p_token2_value => SQLERRM);
330: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
331: END validate_activity_code;
332: ---------------------------------------------------------------------------
333: -- FUNCTION Validate_Attributes
334: ---------------------------------------------------------------------------

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

338: FUNCTION Validate_Attributes (
339: p_rps_rec IN rps_rec_type
340: ) RETURN VARCHAR2 IS
341:
342: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
343: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
344: l_test_value NUMBER := 0;
345:
346: -- cursor to validate existence of record for a given report id and stram type

Line 343: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

339: p_rps_rec IN rps_rec_type
340: ) RETURN VARCHAR2 IS
341:
342: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
343: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
344: l_test_value NUMBER := 0;
345:
346: -- cursor to validate existence of record for a given report id and stram type
347: CURSOR c_is_record_exists(

Line 365: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

361: -- ***
362: -- stream_parameter_id
363: -- ***
364: validate_stream_parameter_id(x_return_status, p_rps_rec.stream_parameter_id);
365: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
366: l_return_status := x_return_status;
367: RAISE G_EXCEPTION_HALT_VALIDATION;
368: END IF;
369:

Line 374: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

370: -- ***
371: -- report_id
372: -- ***
373: validate_report_id(x_return_status, p_rps_rec.report_id);
374: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
375: l_return_status := x_return_status;
376: RAISE G_EXCEPTION_HALT_VALIDATION;
377: END IF;
378:

Line 383: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

379: -- ***
380: -- sty_id
381: -- ***
382: validate_sty_id(x_return_status, p_rps_rec.sty_id);
383: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
384: l_return_status := x_return_status;
385: RAISE G_EXCEPTION_HALT_VALIDATION;
386: END IF;
387:

Line 392: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

388: -- ***
389: -- activity_code
390: -- ***
391: validate_activity_code(x_return_status, p_rps_rec.activity_code);
392: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
393: l_return_status := x_return_status;
394: RAISE G_EXCEPTION_HALT_VALIDATION;
395: END IF;
396:

Line 402: OKL_API.set_message(p_app_name => G_APP_NAME,

398: OPEN c_is_record_exists(p_rps_rec.report_id, p_rps_rec.sty_id, p_rps_rec.stream_parameter_id);
399: FETCH c_is_record_exists INTO l_test_value;
400:
401: IF (c_is_record_exists%FOUND) THEN
402: OKL_API.set_message(p_app_name => G_APP_NAME,
403: p_msg_name => 'OKL_RSP_COMB_EXISTS_MSG');
404: CLOSE c_is_record_exists;
405: RAISE OKL_API.G_EXCEPTION_ERROR;
406: END IF;

Line 405: RAISE OKL_API.G_EXCEPTION_ERROR;

401: IF (c_is_record_exists%FOUND) THEN
402: OKL_API.set_message(p_app_name => G_APP_NAME,
403: p_msg_name => 'OKL_RSP_COMB_EXISTS_MSG');
404: CLOSE c_is_record_exists;
405: RAISE OKL_API.G_EXCEPTION_ERROR;
406: END IF;
407:
408: CLOSE c_is_record_exists;
409:

Line 415: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

411: EXCEPTION
412: WHEN G_EXCEPTION_HALT_VALIDATION THEN
413: RETURN(l_return_status);
414: WHEN OTHERS THEN
415: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
416: ,p_msg_name => G_UNEXPECTED_ERROR
417: ,p_token1 => G_SQLCODE_TOKEN
418: ,p_token1_value => SQLCODE
419: ,p_token2 => G_SQLERRM_TOKEN

Line 421: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

417: ,p_token1 => G_SQLCODE_TOKEN
418: ,p_token1_value => SQLCODE
419: ,p_token2 => G_SQLERRM_TOKEN
420: ,p_token2_value => SQLERRM);
421: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
422: RETURN(l_return_status);
423: END Validate_Attributes;
424: ---------------------------------------------------------------------------
425: -- PROCEDURE Validate_Record

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

430: FUNCTION Validate_Record (
431: p_rps_rec IN rps_rec_type,
432: p_db_rps_rec IN rps_rec_type
433: ) RETURN VARCHAR2 IS
434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
435: BEGIN
436: RETURN (l_return_status);
437: END Validate_Record;
438: FUNCTION Validate_Record (

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

437: END Validate_Record;
438: FUNCTION Validate_Record (
439: p_rps_rec IN rps_rec_type
440: ) RETURN VARCHAR2 IS
441: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
442: l_db_rps_rec rps_rec_type := get_rec(p_rps_rec);
443: BEGIN
444: l_return_status := Validate_Record(p_rps_rec => p_rps_rec,
445: p_db_rps_rec => l_db_rps_rec);

Line 460: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

456: -- validate_row for:OKL_REPORT_STREAM_PARAMS --
457: -----------------------------------------------
458: PROCEDURE validate_row(
459: p_api_version IN NUMBER,
460: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
461: x_return_status OUT NOCOPY VARCHAR2,
462: x_msg_count OUT NOCOPY NUMBER,
463: x_msg_data OUT NOCOPY VARCHAR2,
464: p_rps_rec IN rps_rec_type) IS

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

464: p_rps_rec IN rps_rec_type) IS
465:
466: l_api_version CONSTANT NUMBER := 1;
467: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
468: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
469: l_rps_rec rps_rec_type := p_rps_rec;
470: BEGIN
471: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
472: G_PKG_NAME,

Line 471: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

467: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
468: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
469: l_rps_rec rps_rec_type := p_rps_rec;
470: BEGIN
471: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
472: G_PKG_NAME,
473: p_init_msg_list,
474: l_api_version,
475: p_api_version,

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

474: l_api_version,
475: p_api_version,
476: '_PVT',
477: x_return_status);
478: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
479: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
480: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;

Line 479: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

475: p_api_version,
476: '_PVT',
477: x_return_status);
478: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
479: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
480: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;
483: --- Validate all non-missing attributes (Item Level Validation)

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

476: '_PVT',
477: x_return_status);
478: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
479: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
480: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;
483: --- Validate all non-missing attributes (Item Level Validation)
484: l_return_status := Validate_Attributes(l_rps_rec);

Line 481: RAISE OKL_API.G_EXCEPTION_ERROR;

477: x_return_status);
478: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
479: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
480: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;
483: --- Validate all non-missing attributes (Item Level Validation)
484: l_return_status := Validate_Attributes(l_rps_rec);
485: --- If any errors happen abort API

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

482: END IF;
483: --- Validate all non-missing attributes (Item Level Validation)
484: l_return_status := Validate_Attributes(l_rps_rec);
485: --- If any errors happen abort API
486: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
488: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;

Line 487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

483: --- Validate all non-missing attributes (Item Level Validation)
484: l_return_status := Validate_Attributes(l_rps_rec);
485: --- If any errors happen abort API
486: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
488: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;
491: l_return_status := Validate_Record(l_rps_rec);

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

484: l_return_status := Validate_Attributes(l_rps_rec);
485: --- If any errors happen abort API
486: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
488: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;
491: l_return_status := Validate_Record(l_rps_rec);
492: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 489: RAISE OKL_API.G_EXCEPTION_ERROR;

485: --- If any errors happen abort API
486: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
488: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;
491: l_return_status := Validate_Record(l_rps_rec);
492: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

488: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;
491: l_return_status := Validate_Record(l_rps_rec);
492: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
494: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;

Line 493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;
491: l_return_status := Validate_Record(l_rps_rec);
492: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
494: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497: x_return_status := l_return_status;

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

490: END IF;
491: l_return_status := Validate_Record(l_rps_rec);
492: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
494: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497: x_return_status := l_return_status;
498: EXCEPTION

Line 495: RAISE OKL_API.G_EXCEPTION_ERROR;

491: l_return_status := Validate_Record(l_rps_rec);
492: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
494: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497: x_return_status := l_return_status;
498: EXCEPTION
499: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 499: WHEN OKL_API.G_EXCEPTION_ERROR THEN

495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497: x_return_status := l_return_status;
498: EXCEPTION
499: WHEN OKL_API.G_EXCEPTION_ERROR THEN
500: x_return_status := OKL_API.HANDLE_EXCEPTIONS
501: (
502: l_api_name,
503: G_PKG_NAME,

Line 500: x_return_status := OKL_API.HANDLE_EXCEPTIONS

496: END IF;
497: x_return_status := l_return_status;
498: EXCEPTION
499: WHEN OKL_API.G_EXCEPTION_ERROR THEN
500: x_return_status := OKL_API.HANDLE_EXCEPTIONS
501: (
502: l_api_name,
503: G_PKG_NAME,
504: 'OKL_API.G_RET_STS_ERROR',

Line 504: 'OKL_API.G_RET_STS_ERROR',

500: x_return_status := OKL_API.HANDLE_EXCEPTIONS
501: (
502: l_api_name,
503: G_PKG_NAME,
504: 'OKL_API.G_RET_STS_ERROR',
505: x_msg_count,
506: x_msg_data,
507: '_PVT'
508: );

Line 509: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

505: x_msg_count,
506: x_msg_data,
507: '_PVT'
508: );
509: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
510: x_return_status := OKL_API.HANDLE_EXCEPTIONS
511: (
512: l_api_name,
513: G_PKG_NAME,

Line 510: x_return_status := OKL_API.HANDLE_EXCEPTIONS

506: x_msg_data,
507: '_PVT'
508: );
509: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
510: x_return_status := OKL_API.HANDLE_EXCEPTIONS
511: (
512: l_api_name,
513: G_PKG_NAME,
514: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 514: 'OKL_API.G_RET_STS_UNEXP_ERROR',

510: x_return_status := OKL_API.HANDLE_EXCEPTIONS
511: (
512: l_api_name,
513: G_PKG_NAME,
514: 'OKL_API.G_RET_STS_UNEXP_ERROR',
515: x_msg_count,
516: x_msg_data,
517: '_PVT'
518: );

Line 520: x_return_status := OKL_API.HANDLE_EXCEPTIONS

516: x_msg_data,
517: '_PVT'
518: );
519: WHEN OTHERS THEN
520: x_return_status := OKL_API.HANDLE_EXCEPTIONS
521: (
522: l_api_name,
523: G_PKG_NAME,
524: 'OTHERS',

Line 535: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

531: -- PL/SQL TBL validate_row for:OKL_REPORT_STREAM_PARAMS --
532: ----------------------------------------------------------
533: PROCEDURE validate_row(
534: p_api_version IN NUMBER,
535: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
536: x_return_status OUT NOCOPY VARCHAR2,
537: x_msg_count OUT NOCOPY NUMBER,
538: x_msg_data OUT NOCOPY VARCHAR2,
539: p_rps_tbl IN rps_tbl_type,

Line 540: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

536: x_return_status OUT NOCOPY VARCHAR2,
537: x_msg_count OUT NOCOPY NUMBER,
538: x_msg_data OUT NOCOPY VARCHAR2,
539: p_rps_tbl IN rps_tbl_type,
540: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
541:
542: l_api_version CONSTANT NUMBER := 1;
543: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
544: i NUMBER := 0;

Line 546: OKL_API.init_msg_list(p_init_msg_list);

542: l_api_version CONSTANT NUMBER := 1;
543: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
544: i NUMBER := 0;
545: BEGIN
546: OKL_API.init_msg_list(p_init_msg_list);
547: -- Make sure PL/SQL table has records in it before passing
548: IF (p_rps_tbl.COUNT > 0) THEN
549: i := p_rps_tbl.FIRST;
550: LOOP

Line 552: l_error_rec OKL_API.ERROR_REC_TYPE;

548: IF (p_rps_tbl.COUNT > 0) THEN
549: i := p_rps_tbl.FIRST;
550: LOOP
551: DECLARE
552: l_error_rec OKL_API.ERROR_REC_TYPE;
553: BEGIN
554: l_error_rec.api_name := l_api_name;
555: l_error_rec.api_package := G_PKG_NAME;
556: l_error_rec.idx := i;

Line 559: p_init_msg_list => OKL_API.G_FALSE,

555: l_error_rec.api_package := G_PKG_NAME;
556: l_error_rec.idx := i;
557: validate_row (
558: p_api_version => p_api_version,
559: p_init_msg_list => OKL_API.G_FALSE,
560: x_return_status => l_error_rec.error_type,
561: x_msg_count => l_error_rec.msg_count,
562: x_msg_data => l_error_rec.msg_data,
563: p_rps_rec => p_rps_tbl(i));

Line 564: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

560: x_return_status => l_error_rec.error_type,
561: x_msg_count => l_error_rec.msg_count,
562: x_msg_data => l_error_rec.msg_data,
563: p_rps_rec => p_rps_tbl(i));
564: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
565: l_error_rec.sqlcode := SQLCODE;
566: load_error_tbl(l_error_rec, px_error_tbl);
567: ELSE
568: x_msg_count := l_error_rec.msg_count;

Line 572: WHEN OKL_API.G_EXCEPTION_ERROR THEN

568: x_msg_count := l_error_rec.msg_count;
569: x_msg_data := l_error_rec.msg_data;
570: END IF;
571: EXCEPTION
572: WHEN OKL_API.G_EXCEPTION_ERROR THEN
573: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
574: l_error_rec.sqlcode := SQLCODE;
575: load_error_tbl(l_error_rec, px_error_tbl);
576: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 573: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;

569: x_msg_data := l_error_rec.msg_data;
570: END IF;
571: EXCEPTION
572: WHEN OKL_API.G_EXCEPTION_ERROR THEN
573: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
574: l_error_rec.sqlcode := SQLCODE;
575: load_error_tbl(l_error_rec, px_error_tbl);
576: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
577: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 576: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

572: WHEN OKL_API.G_EXCEPTION_ERROR THEN
573: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
574: l_error_rec.sqlcode := SQLCODE;
575: load_error_tbl(l_error_rec, px_error_tbl);
576: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
577: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
578: l_error_rec.sqlcode := SQLCODE;
579: load_error_tbl(l_error_rec, px_error_tbl);
580: WHEN OTHERS THEN

Line 577: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

573: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
574: l_error_rec.sqlcode := SQLCODE;
575: load_error_tbl(l_error_rec, px_error_tbl);
576: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
577: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
578: l_error_rec.sqlcode := SQLCODE;
579: load_error_tbl(l_error_rec, px_error_tbl);
580: WHEN OTHERS THEN
581: l_error_rec.error_type := 'OTHERS';

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

588: END IF;
589: -- Loop through the error_tbl to find the error with the highest severity
590: -- and return it.
591: x_return_status := find_highest_exception(px_error_tbl);
592: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
593: EXCEPTION
594: WHEN OKL_API.G_EXCEPTION_ERROR THEN
595: x_return_status := OKL_API.HANDLE_EXCEPTIONS
596: (

Line 594: WHEN OKL_API.G_EXCEPTION_ERROR THEN

590: -- and return it.
591: x_return_status := find_highest_exception(px_error_tbl);
592: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
593: EXCEPTION
594: WHEN OKL_API.G_EXCEPTION_ERROR THEN
595: x_return_status := OKL_API.HANDLE_EXCEPTIONS
596: (
597: l_api_name,
598: G_PKG_NAME,

Line 595: x_return_status := OKL_API.HANDLE_EXCEPTIONS

591: x_return_status := find_highest_exception(px_error_tbl);
592: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
593: EXCEPTION
594: WHEN OKL_API.G_EXCEPTION_ERROR THEN
595: x_return_status := OKL_API.HANDLE_EXCEPTIONS
596: (
597: l_api_name,
598: G_PKG_NAME,
599: 'OKL_API.G_RET_STS_ERROR',

Line 599: 'OKL_API.G_RET_STS_ERROR',

595: x_return_status := OKL_API.HANDLE_EXCEPTIONS
596: (
597: l_api_name,
598: G_PKG_NAME,
599: 'OKL_API.G_RET_STS_ERROR',
600: x_msg_count,
601: x_msg_data,
602: '_PVT'
603: );

Line 604: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 605: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 609: 'OKL_API.G_RET_STS_UNEXP_ERROR',

605: x_return_status := OKL_API.HANDLE_EXCEPTIONS
606: (
607: l_api_name,
608: G_PKG_NAME,
609: 'OKL_API.G_RET_STS_UNEXP_ERROR',
610: x_msg_count,
611: x_msg_data,
612: '_PVT'
613: );

Line 615: x_return_status := OKL_API.HANDLE_EXCEPTIONS

611: x_msg_data,
612: '_PVT'
613: );
614: WHEN OTHERS THEN
615: x_return_status := OKL_API.HANDLE_EXCEPTIONS
616: (
617: l_api_name,
618: G_PKG_NAME,
619: 'OTHERS',

Line 631: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

627: -- PL/SQL TBL validate_row for:OKL_REPORT_STREAM_PARAMS --
628: ----------------------------------------------------------
629: PROCEDURE validate_row(
630: p_api_version IN NUMBER,
631: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
632: x_return_status OUT NOCOPY VARCHAR2,
633: x_msg_count OUT NOCOPY NUMBER,
634: x_msg_data OUT NOCOPY VARCHAR2,
635: p_rps_tbl IN rps_tbl_type) IS

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

635: p_rps_tbl IN rps_tbl_type) IS
636:
637: l_api_version CONSTANT NUMBER := 1;
638: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
640: l_error_tbl OKL_API.ERROR_TBL_TYPE;
641: BEGIN
642: OKL_API.init_msg_list(p_init_msg_list);
643: -- Make sure PL/SQL table has records in it before passing

Line 640: l_error_tbl OKL_API.ERROR_TBL_TYPE;

636:
637: l_api_version CONSTANT NUMBER := 1;
638: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
640: l_error_tbl OKL_API.ERROR_TBL_TYPE;
641: BEGIN
642: OKL_API.init_msg_list(p_init_msg_list);
643: -- Make sure PL/SQL table has records in it before passing
644: IF (p_rps_tbl.COUNT > 0) THEN

Line 642: OKL_API.init_msg_list(p_init_msg_list);

638: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
640: l_error_tbl OKL_API.ERROR_TBL_TYPE;
641: BEGIN
642: OKL_API.init_msg_list(p_init_msg_list);
643: -- Make sure PL/SQL table has records in it before passing
644: IF (p_rps_tbl.COUNT > 0) THEN
645: validate_row (
646: p_api_version => p_api_version,

Line 647: p_init_msg_list => OKL_API.G_FALSE,

643: -- Make sure PL/SQL table has records in it before passing
644: IF (p_rps_tbl.COUNT > 0) THEN
645: validate_row (
646: p_api_version => p_api_version,
647: p_init_msg_list => OKL_API.G_FALSE,
648: x_return_status => x_return_status,
649: x_msg_count => x_msg_count,
650: x_msg_data => x_msg_data,
651: p_rps_tbl => p_rps_tbl,

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

650: x_msg_data => x_msg_data,
651: p_rps_tbl => p_rps_tbl,
652: px_error_tbl => l_error_tbl);
653: END IF;
654: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
655: EXCEPTION
656: WHEN OKL_API.G_EXCEPTION_ERROR THEN
657: x_return_status := OKL_API.HANDLE_EXCEPTIONS
658: (

Line 656: WHEN OKL_API.G_EXCEPTION_ERROR THEN

652: px_error_tbl => l_error_tbl);
653: END IF;
654: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
655: EXCEPTION
656: WHEN OKL_API.G_EXCEPTION_ERROR THEN
657: x_return_status := OKL_API.HANDLE_EXCEPTIONS
658: (
659: l_api_name,
660: G_PKG_NAME,

Line 657: x_return_status := OKL_API.HANDLE_EXCEPTIONS

653: END IF;
654: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
655: EXCEPTION
656: WHEN OKL_API.G_EXCEPTION_ERROR THEN
657: x_return_status := OKL_API.HANDLE_EXCEPTIONS
658: (
659: l_api_name,
660: G_PKG_NAME,
661: 'OKL_API.G_RET_STS_ERROR',

Line 661: 'OKL_API.G_RET_STS_ERROR',

657: x_return_status := OKL_API.HANDLE_EXCEPTIONS
658: (
659: l_api_name,
660: G_PKG_NAME,
661: 'OKL_API.G_RET_STS_ERROR',
662: x_msg_count,
663: x_msg_data,
664: '_PVT'
665: );

Line 666: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

662: x_msg_count,
663: x_msg_data,
664: '_PVT'
665: );
666: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
667: x_return_status := OKL_API.HANDLE_EXCEPTIONS
668: (
669: l_api_name,
670: G_PKG_NAME,

Line 667: x_return_status := OKL_API.HANDLE_EXCEPTIONS

663: x_msg_data,
664: '_PVT'
665: );
666: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
667: x_return_status := OKL_API.HANDLE_EXCEPTIONS
668: (
669: l_api_name,
670: G_PKG_NAME,
671: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 671: 'OKL_API.G_RET_STS_UNEXP_ERROR',

667: x_return_status := OKL_API.HANDLE_EXCEPTIONS
668: (
669: l_api_name,
670: G_PKG_NAME,
671: 'OKL_API.G_RET_STS_UNEXP_ERROR',
672: x_msg_count,
673: x_msg_data,
674: '_PVT'
675: );

Line 677: x_return_status := OKL_API.HANDLE_EXCEPTIONS

673: x_msg_data,
674: '_PVT'
675: );
676: WHEN OTHERS THEN
677: x_return_status := OKL_API.HANDLE_EXCEPTIONS
678: (
679: l_api_name,
680: G_PKG_NAME,
681: 'OTHERS',

Line 696: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

692: -- insert_row for:OKL_REPORT_STREAM_PARAMS --
693: ---------------------------------------------
694: PROCEDURE insert_row(
695: p_api_version IN NUMBER,
696: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
697: x_return_status OUT NOCOPY VARCHAR2,
698: x_msg_count OUT NOCOPY NUMBER,
699: x_msg_data OUT NOCOPY VARCHAR2,
700: p_rps_rec IN rps_rec_type,

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

701: x_rps_rec OUT NOCOPY rps_rec_type) IS
702:
703: l_api_version CONSTANT NUMBER := 1;
704: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
705: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
706: l_rps_rec rps_rec_type := p_rps_rec;
707: l_def_rps_rec rps_rec_type;
708: -------------------------------
709: -- FUNCTION fill_who_columns --

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

726: FUNCTION Set_Attributes (
727: p_rps_rec IN rps_rec_type,
728: x_rps_rec OUT NOCOPY rps_rec_type
729: ) RETURN VARCHAR2 IS
730: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
731: BEGIN
732: x_rps_rec := p_rps_rec;
733: RETURN(l_return_status);
734: END Set_Attributes;

Line 736: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

732: x_rps_rec := p_rps_rec;
733: RETURN(l_return_status);
734: END Set_Attributes;
735: BEGIN
736: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
737: G_PKG_NAME,
738: p_init_msg_list,
739: l_api_version,
740: p_api_version,

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

739: l_api_version,
740: p_api_version,
741: '_PVT',
742: x_return_status);
743: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
745: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
746: RAISE OKL_API.G_EXCEPTION_ERROR;
747: END IF;

Line 744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

740: p_api_version,
741: '_PVT',
742: x_return_status);
743: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
745: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
746: RAISE OKL_API.G_EXCEPTION_ERROR;
747: END IF;
748: l_rps_rec := null_out_defaults(p_rps_rec);

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

741: '_PVT',
742: x_return_status);
743: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
745: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
746: RAISE OKL_API.G_EXCEPTION_ERROR;
747: END IF;
748: l_rps_rec := null_out_defaults(p_rps_rec);
749: -- Set primary key value

Line 746: RAISE OKL_API.G_EXCEPTION_ERROR;

742: x_return_status);
743: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
745: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
746: RAISE OKL_API.G_EXCEPTION_ERROR;
747: END IF;
748: l_rps_rec := null_out_defaults(p_rps_rec);
749: -- Set primary key value
750: l_rps_rec.STREAM_PARAMETER_ID := get_seq_id;

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

752: l_return_Status := Set_Attributes(
753: l_rps_rec, -- IN
754: l_def_rps_rec); -- OUT
755: --- If any errors happen abort API
756: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
758: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
759: RAISE OKL_API.G_EXCEPTION_ERROR;
760: END IF;

Line 757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

753: l_rps_rec, -- IN
754: l_def_rps_rec); -- OUT
755: --- If any errors happen abort API
756: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
758: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
759: RAISE OKL_API.G_EXCEPTION_ERROR;
760: END IF;
761: l_def_rps_rec := fill_who_columns(l_def_rps_rec);

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

754: l_def_rps_rec); -- OUT
755: --- If any errors happen abort API
756: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
758: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
759: RAISE OKL_API.G_EXCEPTION_ERROR;
760: END IF;
761: l_def_rps_rec := fill_who_columns(l_def_rps_rec);
762: --- Validate all non-missing attributes (Item Level Validation)

Line 759: RAISE OKL_API.G_EXCEPTION_ERROR;

755: --- If any errors happen abort API
756: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
758: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
759: RAISE OKL_API.G_EXCEPTION_ERROR;
760: END IF;
761: l_def_rps_rec := fill_who_columns(l_def_rps_rec);
762: --- Validate all non-missing attributes (Item Level Validation)
763: l_return_status := Validate_Attributes(l_def_rps_rec);

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

761: l_def_rps_rec := fill_who_columns(l_def_rps_rec);
762: --- Validate all non-missing attributes (Item Level Validation)
763: l_return_status := Validate_Attributes(l_def_rps_rec);
764: --- If any errors happen abort API
765: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
768: RAISE OKL_API.G_EXCEPTION_ERROR;
769: END IF;

Line 766: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

762: --- Validate all non-missing attributes (Item Level Validation)
763: l_return_status := Validate_Attributes(l_def_rps_rec);
764: --- If any errors happen abort API
765: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
768: RAISE OKL_API.G_EXCEPTION_ERROR;
769: END IF;
770: l_return_status := Validate_Record(l_def_rps_rec);

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

763: l_return_status := Validate_Attributes(l_def_rps_rec);
764: --- If any errors happen abort API
765: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
768: RAISE OKL_API.G_EXCEPTION_ERROR;
769: END IF;
770: l_return_status := Validate_Record(l_def_rps_rec);
771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 768: RAISE OKL_API.G_EXCEPTION_ERROR;

764: --- If any errors happen abort API
765: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
768: RAISE OKL_API.G_EXCEPTION_ERROR;
769: END IF;
770: l_return_status := Validate_Record(l_def_rps_rec);
771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

767: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
768: RAISE OKL_API.G_EXCEPTION_ERROR;
769: END IF;
770: l_return_status := Validate_Record(l_def_rps_rec);
771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_ERROR;
775: END IF;

Line 772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

768: RAISE OKL_API.G_EXCEPTION_ERROR;
769: END IF;
770: l_return_status := Validate_Record(l_def_rps_rec);
771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_ERROR;
775: END IF;
776: INSERT INTO OKL_REPORT_STREAM_PARAMS(

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

769: END IF;
770: l_return_status := Validate_Record(l_def_rps_rec);
771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_ERROR;
775: END IF;
776: INSERT INTO OKL_REPORT_STREAM_PARAMS(
777: stream_parameter_id,

Line 774: RAISE OKL_API.G_EXCEPTION_ERROR;

770: l_return_status := Validate_Record(l_def_rps_rec);
771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_ERROR;
775: END IF;
776: INSERT INTO OKL_REPORT_STREAM_PARAMS(
777: stream_parameter_id,
778: report_id,

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

795: l_def_rps_rec.last_update_login);
796: -- Set OUT values
797: x_rps_rec := l_def_rps_rec;
798: x_return_status := l_return_status;
799: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
800: EXCEPTION
801: WHEN OKL_API.G_EXCEPTION_ERROR THEN
802: x_return_status := OKL_API.HANDLE_EXCEPTIONS
803: (

Line 801: WHEN OKL_API.G_EXCEPTION_ERROR THEN

797: x_rps_rec := l_def_rps_rec;
798: x_return_status := l_return_status;
799: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
800: EXCEPTION
801: WHEN OKL_API.G_EXCEPTION_ERROR THEN
802: x_return_status := OKL_API.HANDLE_EXCEPTIONS
803: (
804: l_api_name,
805: G_PKG_NAME,

Line 802: x_return_status := OKL_API.HANDLE_EXCEPTIONS

798: x_return_status := l_return_status;
799: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
800: EXCEPTION
801: WHEN OKL_API.G_EXCEPTION_ERROR THEN
802: x_return_status := OKL_API.HANDLE_EXCEPTIONS
803: (
804: l_api_name,
805: G_PKG_NAME,
806: 'OKL_API.G_RET_STS_ERROR',

Line 806: 'OKL_API.G_RET_STS_ERROR',

802: x_return_status := OKL_API.HANDLE_EXCEPTIONS
803: (
804: l_api_name,
805: G_PKG_NAME,
806: 'OKL_API.G_RET_STS_ERROR',
807: x_msg_count,
808: x_msg_data,
809: '_PVT'
810: );

Line 811: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

807: x_msg_count,
808: x_msg_data,
809: '_PVT'
810: );
811: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
812: x_return_status := OKL_API.HANDLE_EXCEPTIONS
813: (
814: l_api_name,
815: G_PKG_NAME,

Line 812: x_return_status := OKL_API.HANDLE_EXCEPTIONS

808: x_msg_data,
809: '_PVT'
810: );
811: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
812: x_return_status := OKL_API.HANDLE_EXCEPTIONS
813: (
814: l_api_name,
815: G_PKG_NAME,
816: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 816: 'OKL_API.G_RET_STS_UNEXP_ERROR',

812: x_return_status := OKL_API.HANDLE_EXCEPTIONS
813: (
814: l_api_name,
815: G_PKG_NAME,
816: 'OKL_API.G_RET_STS_UNEXP_ERROR',
817: x_msg_count,
818: x_msg_data,
819: '_PVT'
820: );

Line 822: x_return_status := OKL_API.HANDLE_EXCEPTIONS

818: x_msg_data,
819: '_PVT'
820: );
821: WHEN OTHERS THEN
822: x_return_status := OKL_API.HANDLE_EXCEPTIONS
823: (
824: l_api_name,
825: G_PKG_NAME,
826: 'OTHERS',

Line 837: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

833: -- PL/SQL TBL insert_row for:RPS_TBL --
834: ---------------------------------------
835: PROCEDURE insert_row(
836: p_api_version IN NUMBER,
837: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
838: x_return_status OUT NOCOPY VARCHAR2,
839: x_msg_count OUT NOCOPY NUMBER,
840: x_msg_data OUT NOCOPY VARCHAR2,
841: p_rps_tbl IN rps_tbl_type,

Line 843: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

839: x_msg_count OUT NOCOPY NUMBER,
840: x_msg_data OUT NOCOPY VARCHAR2,
841: p_rps_tbl IN rps_tbl_type,
842: x_rps_tbl OUT NOCOPY rps_tbl_type,
843: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
844:
845: l_api_version CONSTANT NUMBER := 1;
846: l_api_name CONSTANT VARCHAR2(30) := 'error_tbl_insert_row';
847: i NUMBER := 0;

Line 849: OKL_API.init_msg_list(p_init_msg_list);

845: l_api_version CONSTANT NUMBER := 1;
846: l_api_name CONSTANT VARCHAR2(30) := 'error_tbl_insert_row';
847: i NUMBER := 0;
848: BEGIN
849: OKL_API.init_msg_list(p_init_msg_list);
850: -- Make sure PL/SQL table has records in it before passing
851: IF (p_rps_tbl.COUNT > 0) THEN
852: i := p_rps_tbl.FIRST;
853: LOOP

Line 855: l_error_rec OKL_API.ERROR_REC_TYPE;

851: IF (p_rps_tbl.COUNT > 0) THEN
852: i := p_rps_tbl.FIRST;
853: LOOP
854: DECLARE
855: l_error_rec OKL_API.ERROR_REC_TYPE;
856: BEGIN
857: l_error_rec.api_name := l_api_name;
858: l_error_rec.api_package := G_PKG_NAME;
859: l_error_rec.idx := i;

Line 862: p_init_msg_list => OKL_API.G_FALSE,

858: l_error_rec.api_package := G_PKG_NAME;
859: l_error_rec.idx := i;
860: insert_row (
861: p_api_version => p_api_version,
862: p_init_msg_list => OKL_API.G_FALSE,
863: x_return_status => l_error_rec.error_type,
864: x_msg_count => l_error_rec.msg_count,
865: x_msg_data => l_error_rec.msg_data,
866: p_rps_rec => p_rps_tbl(i),

Line 868: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

864: x_msg_count => l_error_rec.msg_count,
865: x_msg_data => l_error_rec.msg_data,
866: p_rps_rec => p_rps_tbl(i),
867: x_rps_rec => x_rps_tbl(i));
868: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
869: l_error_rec.sqlcode := SQLCODE;
870: load_error_tbl(l_error_rec, px_error_tbl);
871: ELSE
872: x_msg_count := l_error_rec.msg_count;

Line 876: WHEN OKL_API.G_EXCEPTION_ERROR THEN

872: x_msg_count := l_error_rec.msg_count;
873: x_msg_data := l_error_rec.msg_data;
874: END IF;
875: EXCEPTION
876: WHEN OKL_API.G_EXCEPTION_ERROR THEN
877: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
878: l_error_rec.sqlcode := SQLCODE;
879: load_error_tbl(l_error_rec, px_error_tbl);
880: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 877: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;

873: x_msg_data := l_error_rec.msg_data;
874: END IF;
875: EXCEPTION
876: WHEN OKL_API.G_EXCEPTION_ERROR THEN
877: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
878: l_error_rec.sqlcode := SQLCODE;
879: load_error_tbl(l_error_rec, px_error_tbl);
880: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
881: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 880: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

876: WHEN OKL_API.G_EXCEPTION_ERROR THEN
877: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
878: l_error_rec.sqlcode := SQLCODE;
879: load_error_tbl(l_error_rec, px_error_tbl);
880: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
881: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
882: l_error_rec.sqlcode := SQLCODE;
883: load_error_tbl(l_error_rec, px_error_tbl);
884: WHEN OTHERS THEN

Line 881: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

877: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
878: l_error_rec.sqlcode := SQLCODE;
879: load_error_tbl(l_error_rec, px_error_tbl);
880: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
881: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
882: l_error_rec.sqlcode := SQLCODE;
883: load_error_tbl(l_error_rec, px_error_tbl);
884: WHEN OTHERS THEN
885: l_error_rec.error_type := 'OTHERS';

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

892: END IF;
893: -- Loop through the error_tbl to find the error with the highest severity
894: -- and return it.
895: x_return_status := find_highest_exception(px_error_tbl);
896: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
897: EXCEPTION
898: WHEN OKL_API.G_EXCEPTION_ERROR THEN
899: x_return_status := OKL_API.HANDLE_EXCEPTIONS
900: (

Line 898: WHEN OKL_API.G_EXCEPTION_ERROR THEN

894: -- and return it.
895: x_return_status := find_highest_exception(px_error_tbl);
896: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
897: EXCEPTION
898: WHEN OKL_API.G_EXCEPTION_ERROR THEN
899: x_return_status := OKL_API.HANDLE_EXCEPTIONS
900: (
901: l_api_name,
902: G_PKG_NAME,

Line 899: x_return_status := OKL_API.HANDLE_EXCEPTIONS

895: x_return_status := find_highest_exception(px_error_tbl);
896: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
897: EXCEPTION
898: WHEN OKL_API.G_EXCEPTION_ERROR THEN
899: x_return_status := OKL_API.HANDLE_EXCEPTIONS
900: (
901: l_api_name,
902: G_PKG_NAME,
903: 'OKL_API.G_RET_STS_ERROR',

Line 903: 'OKL_API.G_RET_STS_ERROR',

899: x_return_status := OKL_API.HANDLE_EXCEPTIONS
900: (
901: l_api_name,
902: G_PKG_NAME,
903: 'OKL_API.G_RET_STS_ERROR',
904: x_msg_count,
905: x_msg_data,
906: '_PVT'
907: );

Line 908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

904: x_msg_count,
905: x_msg_data,
906: '_PVT'
907: );
908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
909: x_return_status := OKL_API.HANDLE_EXCEPTIONS
910: (
911: l_api_name,
912: G_PKG_NAME,

Line 909: x_return_status := OKL_API.HANDLE_EXCEPTIONS

905: x_msg_data,
906: '_PVT'
907: );
908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
909: x_return_status := OKL_API.HANDLE_EXCEPTIONS
910: (
911: l_api_name,
912: G_PKG_NAME,
913: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 913: 'OKL_API.G_RET_STS_UNEXP_ERROR',

909: x_return_status := OKL_API.HANDLE_EXCEPTIONS
910: (
911: l_api_name,
912: G_PKG_NAME,
913: 'OKL_API.G_RET_STS_UNEXP_ERROR',
914: x_msg_count,
915: x_msg_data,
916: '_PVT'
917: );

Line 919: x_return_status := OKL_API.HANDLE_EXCEPTIONS

915: x_msg_data,
916: '_PVT'
917: );
918: WHEN OTHERS THEN
919: x_return_status := OKL_API.HANDLE_EXCEPTIONS
920: (
921: l_api_name,
922: G_PKG_NAME,
923: 'OTHERS',

Line 935: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

931: -- PL/SQL TBL insert_row for:RPS_TBL --
932: ---------------------------------------
933: PROCEDURE insert_row(
934: p_api_version IN NUMBER,
935: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
936: x_return_status OUT NOCOPY VARCHAR2,
937: x_msg_count OUT NOCOPY NUMBER,
938: x_msg_data OUT NOCOPY VARCHAR2,
939: p_rps_tbl IN rps_tbl_type,

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

940: x_rps_tbl OUT NOCOPY rps_tbl_type) IS
941:
942: l_api_version CONSTANT NUMBER := 1;
943: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
944: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
945: l_error_tbl OKL_API.ERROR_TBL_TYPE;
946: BEGIN
947: OKL_API.init_msg_list(p_init_msg_list);
948: -- Make sure PL/SQL table has records in it before passing

Line 945: l_error_tbl OKL_API.ERROR_TBL_TYPE;

941:
942: l_api_version CONSTANT NUMBER := 1;
943: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
944: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
945: l_error_tbl OKL_API.ERROR_TBL_TYPE;
946: BEGIN
947: OKL_API.init_msg_list(p_init_msg_list);
948: -- Make sure PL/SQL table has records in it before passing
949: IF (p_rps_tbl.COUNT > 0) THEN

Line 947: OKL_API.init_msg_list(p_init_msg_list);

943: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
944: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
945: l_error_tbl OKL_API.ERROR_TBL_TYPE;
946: BEGIN
947: OKL_API.init_msg_list(p_init_msg_list);
948: -- Make sure PL/SQL table has records in it before passing
949: IF (p_rps_tbl.COUNT > 0) THEN
950: insert_row (
951: p_api_version => p_api_version,

Line 952: p_init_msg_list => OKL_API.G_FALSE,

948: -- Make sure PL/SQL table has records in it before passing
949: IF (p_rps_tbl.COUNT > 0) THEN
950: insert_row (
951: p_api_version => p_api_version,
952: p_init_msg_list => OKL_API.G_FALSE,
953: x_return_status => x_return_status,
954: x_msg_count => x_msg_count,
955: x_msg_data => x_msg_data,
956: p_rps_tbl => p_rps_tbl,

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

956: p_rps_tbl => p_rps_tbl,
957: x_rps_tbl => x_rps_tbl,
958: px_error_tbl => l_error_tbl);
959: END IF;
960: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
961: EXCEPTION
962: WHEN OKL_API.G_EXCEPTION_ERROR THEN
963: x_return_status := OKL_API.HANDLE_EXCEPTIONS
964: (

Line 962: WHEN OKL_API.G_EXCEPTION_ERROR THEN

958: px_error_tbl => l_error_tbl);
959: END IF;
960: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
961: EXCEPTION
962: WHEN OKL_API.G_EXCEPTION_ERROR THEN
963: x_return_status := OKL_API.HANDLE_EXCEPTIONS
964: (
965: l_api_name,
966: G_PKG_NAME,

Line 963: x_return_status := OKL_API.HANDLE_EXCEPTIONS

959: END IF;
960: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
961: EXCEPTION
962: WHEN OKL_API.G_EXCEPTION_ERROR THEN
963: x_return_status := OKL_API.HANDLE_EXCEPTIONS
964: (
965: l_api_name,
966: G_PKG_NAME,
967: 'OKL_API.G_RET_STS_ERROR',

Line 967: 'OKL_API.G_RET_STS_ERROR',

963: x_return_status := OKL_API.HANDLE_EXCEPTIONS
964: (
965: l_api_name,
966: G_PKG_NAME,
967: 'OKL_API.G_RET_STS_ERROR',
968: x_msg_count,
969: x_msg_data,
970: '_PVT'
971: );

Line 972: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

968: x_msg_count,
969: x_msg_data,
970: '_PVT'
971: );
972: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
973: x_return_status := OKL_API.HANDLE_EXCEPTIONS
974: (
975: l_api_name,
976: G_PKG_NAME,

Line 973: x_return_status := OKL_API.HANDLE_EXCEPTIONS

969: x_msg_data,
970: '_PVT'
971: );
972: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
973: x_return_status := OKL_API.HANDLE_EXCEPTIONS
974: (
975: l_api_name,
976: G_PKG_NAME,
977: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 977: 'OKL_API.G_RET_STS_UNEXP_ERROR',

973: x_return_status := OKL_API.HANDLE_EXCEPTIONS
974: (
975: l_api_name,
976: G_PKG_NAME,
977: 'OKL_API.G_RET_STS_UNEXP_ERROR',
978: x_msg_count,
979: x_msg_data,
980: '_PVT'
981: );

Line 983: x_return_status := OKL_API.HANDLE_EXCEPTIONS

979: x_msg_data,
980: '_PVT'
981: );
982: WHEN OTHERS THEN
983: x_return_status := OKL_API.HANDLE_EXCEPTIONS
984: (
985: l_api_name,
986: G_PKG_NAME,
987: 'OTHERS',

Line 1000: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

996: -------------------------------------------
997: -- lock_row for:OKL_REPORT_STREAM_PARAMS --
998: -------------------------------------------
999: PROCEDURE lock_row(
1000: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1001: x_return_status OUT NOCOPY VARCHAR2,
1002: x_msg_count OUT NOCOPY NUMBER,
1003: x_msg_data OUT NOCOPY VARCHAR2,
1004: p_rps_rec IN rps_rec_type) IS

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

1012: FOR UPDATE NOWAIT;
1013:
1014: l_api_version CONSTANT NUMBER := 1;
1015: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1016: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1017: l_lock_var lock_csr%ROWTYPE;
1018: l_row_notfound BOOLEAN := FALSE;
1019: lc_row_notfound BOOLEAN := FALSE;
1020: BEGIN

Line 1021: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1017: l_lock_var lock_csr%ROWTYPE;
1018: l_row_notfound BOOLEAN := FALSE;
1019: lc_row_notfound BOOLEAN := FALSE;
1020: BEGIN
1021: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1022: p_init_msg_list,
1023: '_PVT',
1024: x_return_status);
1025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1021: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1022: p_init_msg_list,
1023: '_PVT',
1024: x_return_status);
1025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;

Line 1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1022: p_init_msg_list,
1023: '_PVT',
1024: x_return_status);
1025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;
1030: BEGIN

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

1023: '_PVT',
1024: x_return_status);
1025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;
1030: BEGIN
1031: OPEN lock_csr(p_rps_rec);

Line 1028: RAISE OKL_API.G_EXCEPTION_ERROR;

1024: x_return_status);
1025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;
1030: BEGIN
1031: OPEN lock_csr(p_rps_rec);
1032: FETCH lock_csr INTO l_lock_var;

Line 1040: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1036: WHEN E_Resource_Busy THEN
1037: IF (lock_csr%ISOPEN) THEN
1038: CLOSE lock_csr;
1039: END IF;
1040: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1041: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1042: END;
1043:
1044: IF ( l_row_notfound ) THEN

Line 1045: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1041: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1042: END;
1043:
1044: IF ( l_row_notfound ) THEN
1045: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1046: RAISE OKL_API.G_EXCEPTION_ERROR;
1047: ELSE
1048: IF (l_lock_var.stream_parameter_id <> p_rps_rec.stream_parameter_id) THEN
1049: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1046: RAISE OKL_API.G_EXCEPTION_ERROR;

1042: END;
1043:
1044: IF ( l_row_notfound ) THEN
1045: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1046: RAISE OKL_API.G_EXCEPTION_ERROR;
1047: ELSE
1048: IF (l_lock_var.stream_parameter_id <> p_rps_rec.stream_parameter_id) THEN
1049: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1050: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1049: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1045: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1046: RAISE OKL_API.G_EXCEPTION_ERROR;
1047: ELSE
1048: IF (l_lock_var.stream_parameter_id <> p_rps_rec.stream_parameter_id) THEN
1049: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1050: RAISE OKL_API.G_EXCEPTION_ERROR;
1051: END IF;
1052: END IF;
1053: x_return_status := l_return_status;

Line 1050: RAISE OKL_API.G_EXCEPTION_ERROR;

1046: RAISE OKL_API.G_EXCEPTION_ERROR;
1047: ELSE
1048: IF (l_lock_var.stream_parameter_id <> p_rps_rec.stream_parameter_id) THEN
1049: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1050: RAISE OKL_API.G_EXCEPTION_ERROR;
1051: END IF;
1052: END IF;
1053: x_return_status := l_return_status;
1054: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1050: RAISE OKL_API.G_EXCEPTION_ERROR;
1051: END IF;
1052: END IF;
1053: x_return_status := l_return_status;
1054: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1055: EXCEPTION
1056: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1057: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1058: (

Line 1056: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1052: END IF;
1053: x_return_status := l_return_status;
1054: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1055: EXCEPTION
1056: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1057: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1058: (
1059: l_api_name,
1060: G_PKG_NAME,

Line 1057: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1053: x_return_status := l_return_status;
1054: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1055: EXCEPTION
1056: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1057: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1058: (
1059: l_api_name,
1060: G_PKG_NAME,
1061: 'OKL_API.G_RET_STS_ERROR',

Line 1061: 'OKL_API.G_RET_STS_ERROR',

1057: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1058: (
1059: l_api_name,
1060: G_PKG_NAME,
1061: 'OKL_API.G_RET_STS_ERROR',
1062: x_msg_count,
1063: x_msg_data,
1064: '_PVT'
1065: );

Line 1066: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1062: x_msg_count,
1063: x_msg_data,
1064: '_PVT'
1065: );
1066: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1068: (
1069: l_api_name,
1070: G_PKG_NAME,

Line 1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1063: x_msg_data,
1064: '_PVT'
1065: );
1066: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1068: (
1069: l_api_name,
1070: G_PKG_NAME,
1071: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1071: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1068: (
1069: l_api_name,
1070: G_PKG_NAME,
1071: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1072: x_msg_count,
1073: x_msg_data,
1074: '_PVT'
1075: );

Line 1077: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1073: x_msg_data,
1074: '_PVT'
1075: );
1076: WHEN OTHERS THEN
1077: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1078: (
1079: l_api_name,
1080: G_PKG_NAME,
1081: 'OTHERS',

Line 1092: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1088: -- lock_row for: OKL_REPORT_STREAM_PARAMS --
1089: --------------------------------------------
1090: PROCEDURE lock_row(
1091: p_api_version IN NUMBER,
1092: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1093: x_return_status OUT NOCOPY VARCHAR2,
1094: x_msg_count OUT NOCOPY NUMBER,
1095: x_msg_data OUT NOCOPY VARCHAR2,
1096: p_rps_rec IN rps_rec_type) IS

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

1096: p_rps_rec IN rps_rec_type) IS
1097:
1098: l_api_version CONSTANT NUMBER := 1;
1099: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1100: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1101: l_rps_rec rps_rec_type:= p_rps_rec;
1102: BEGIN
1103: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1104: G_PKG_NAME,

Line 1103: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1099: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1100: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1101: l_rps_rec rps_rec_type:= p_rps_rec;
1102: BEGIN
1103: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1104: G_PKG_NAME,
1105: p_init_msg_list,
1106: l_api_version,
1107: p_api_version,

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

1106: l_api_version,
1107: p_api_version,
1108: '_PVT',
1109: x_return_status);
1110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1113: RAISE OKL_API.G_EXCEPTION_ERROR;
1114: END IF;

Line 1111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1107: p_api_version,
1108: '_PVT',
1109: x_return_status);
1110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1113: RAISE OKL_API.G_EXCEPTION_ERROR;
1114: END IF;
1115: -----------------------------------------

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

1108: '_PVT',
1109: x_return_status);
1110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1113: RAISE OKL_API.G_EXCEPTION_ERROR;
1114: END IF;
1115: -----------------------------------------
1116: -- Move VIEW record to "Child" records --

Line 1113: RAISE OKL_API.G_EXCEPTION_ERROR;

1109: x_return_status);
1110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1113: RAISE OKL_API.G_EXCEPTION_ERROR;
1114: END IF;
1115: -----------------------------------------
1116: -- Move VIEW record to "Child" records --
1117: -----------------------------------------

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

1124: x_msg_count,
1125: x_msg_data,
1126: l_rps_rec
1127: );
1128: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1130: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_ERROR;
1132: END IF;

Line 1129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1125: x_msg_data,
1126: l_rps_rec
1127: );
1128: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1130: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_ERROR;
1132: END IF;
1133: x_return_status := l_return_status;

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

1126: l_rps_rec
1127: );
1128: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1130: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_ERROR;
1132: END IF;
1133: x_return_status := l_return_status;
1134: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1131: RAISE OKL_API.G_EXCEPTION_ERROR;

1127: );
1128: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1130: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_ERROR;
1132: END IF;
1133: x_return_status := l_return_status;
1134: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1135: EXCEPTION

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

1130: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_ERROR;
1132: END IF;
1133: x_return_status := l_return_status;
1134: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1135: EXCEPTION
1136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1138: (

Line 1136: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1132: END IF;
1133: x_return_status := l_return_status;
1134: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1135: EXCEPTION
1136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1138: (
1139: l_api_name,
1140: G_PKG_NAME,

Line 1137: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1133: x_return_status := l_return_status;
1134: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1135: EXCEPTION
1136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1138: (
1139: l_api_name,
1140: G_PKG_NAME,
1141: 'OKL_API.G_RET_STS_ERROR',

Line 1141: 'OKL_API.G_RET_STS_ERROR',

1137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1138: (
1139: l_api_name,
1140: G_PKG_NAME,
1141: 'OKL_API.G_RET_STS_ERROR',
1142: x_msg_count,
1143: x_msg_data,
1144: '_PVT'
1145: );

Line 1146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1142: x_msg_count,
1143: x_msg_data,
1144: '_PVT'
1145: );
1146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1147: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1148: (
1149: l_api_name,
1150: G_PKG_NAME,

Line 1147: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1143: x_msg_data,
1144: '_PVT'
1145: );
1146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1147: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1148: (
1149: l_api_name,
1150: G_PKG_NAME,
1151: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1151: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1147: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1148: (
1149: l_api_name,
1150: G_PKG_NAME,
1151: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1152: x_msg_count,
1153: x_msg_data,
1154: '_PVT'
1155: );

Line 1157: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1153: x_msg_data,
1154: '_PVT'
1155: );
1156: WHEN OTHERS THEN
1157: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1158: (
1159: l_api_name,
1160: G_PKG_NAME,
1161: 'OTHERS',

Line 1172: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1168: -- PL/SQL TBL lock_row for:RPS_TBL --
1169: -------------------------------------
1170: PROCEDURE lock_row(
1171: p_api_version IN NUMBER,
1172: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1173: x_return_status OUT NOCOPY VARCHAR2,
1174: x_msg_count OUT NOCOPY NUMBER,
1175: x_msg_data OUT NOCOPY VARCHAR2,
1176: p_rps_tbl IN rps_tbl_type,

Line 1177: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

1173: x_return_status OUT NOCOPY VARCHAR2,
1174: x_msg_count OUT NOCOPY NUMBER,
1175: x_msg_data OUT NOCOPY VARCHAR2,
1176: p_rps_tbl IN rps_tbl_type,
1177: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1178:
1179: l_api_version CONSTANT NUMBER := 1;
1180: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1181: i NUMBER := 0;

Line 1183: OKL_API.init_msg_list(p_init_msg_list);

1179: l_api_version CONSTANT NUMBER := 1;
1180: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1181: i NUMBER := 0;
1182: BEGIN
1183: OKL_API.init_msg_list(p_init_msg_list);
1184: -- Make sure PL/SQL table has recrods in it before passing
1185: IF (p_rps_tbl.COUNT > 0) THEN
1186: i := p_rps_tbl.FIRST;
1187: LOOP

Line 1189: l_error_rec OKL_API.ERROR_REC_TYPE;

1185: IF (p_rps_tbl.COUNT > 0) THEN
1186: i := p_rps_tbl.FIRST;
1187: LOOP
1188: DECLARE
1189: l_error_rec OKL_API.ERROR_REC_TYPE;
1190: BEGIN
1191: l_error_rec.api_name := l_api_name;
1192: l_error_rec.api_package := G_PKG_NAME;
1193: l_error_rec.idx := i;

Line 1196: p_init_msg_list => OKL_API.G_FALSE,

1192: l_error_rec.api_package := G_PKG_NAME;
1193: l_error_rec.idx := i;
1194: lock_row(
1195: p_api_version => p_api_version,
1196: p_init_msg_list => OKL_API.G_FALSE,
1197: x_return_status => l_error_rec.error_type,
1198: x_msg_count => l_error_rec.msg_count,
1199: x_msg_data => l_error_rec.msg_data,
1200: p_rps_rec => p_rps_tbl(i));

Line 1201: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

1197: x_return_status => l_error_rec.error_type,
1198: x_msg_count => l_error_rec.msg_count,
1199: x_msg_data => l_error_rec.msg_data,
1200: p_rps_rec => p_rps_tbl(i));
1201: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1202: l_error_rec.sqlcode := SQLCODE;
1203: load_error_tbl(l_error_rec, px_error_tbl);
1204: ELSE
1205: x_msg_count := l_error_rec.msg_count;

Line 1209: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1205: x_msg_count := l_error_rec.msg_count;
1206: x_msg_data := l_error_rec.msg_data;
1207: END IF;
1208: EXCEPTION
1209: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1210: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1211: l_error_rec.sqlcode := SQLCODE;
1212: load_error_tbl(l_error_rec, px_error_tbl);
1213: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1210: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;

1206: x_msg_data := l_error_rec.msg_data;
1207: END IF;
1208: EXCEPTION
1209: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1210: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1211: l_error_rec.sqlcode := SQLCODE;
1212: load_error_tbl(l_error_rec, px_error_tbl);
1213: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1214: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1213: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1209: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1210: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1211: l_error_rec.sqlcode := SQLCODE;
1212: load_error_tbl(l_error_rec, px_error_tbl);
1213: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1214: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1215: l_error_rec.sqlcode := SQLCODE;
1216: load_error_tbl(l_error_rec, px_error_tbl);
1217: WHEN OTHERS THEN

Line 1214: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

1210: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1211: l_error_rec.sqlcode := SQLCODE;
1212: load_error_tbl(l_error_rec, px_error_tbl);
1213: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1214: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1215: l_error_rec.sqlcode := SQLCODE;
1216: load_error_tbl(l_error_rec, px_error_tbl);
1217: WHEN OTHERS THEN
1218: l_error_rec.error_type := 'OTHERS';

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

1225: END IF;
1226: -- Loop through the error_tbl to find the error with the highest severity
1227: -- and return it.
1228: x_return_status := find_highest_exception(px_error_tbl);
1229: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1230: EXCEPTION
1231: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1232: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1233: (

Line 1231: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1227: -- and return it.
1228: x_return_status := find_highest_exception(px_error_tbl);
1229: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1230: EXCEPTION
1231: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1232: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1233: (
1234: l_api_name,
1235: G_PKG_NAME,

Line 1232: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1228: x_return_status := find_highest_exception(px_error_tbl);
1229: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1230: EXCEPTION
1231: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1232: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1233: (
1234: l_api_name,
1235: G_PKG_NAME,
1236: 'OKL_API.G_RET_STS_ERROR',

Line 1236: 'OKL_API.G_RET_STS_ERROR',

1232: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1233: (
1234: l_api_name,
1235: G_PKG_NAME,
1236: 'OKL_API.G_RET_STS_ERROR',
1237: x_msg_count,
1238: x_msg_data,
1239: '_PVT'
1240: );

Line 1241: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1237: x_msg_count,
1238: x_msg_data,
1239: '_PVT'
1240: );
1241: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1242: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1243: (
1244: l_api_name,
1245: G_PKG_NAME,

Line 1242: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1238: x_msg_data,
1239: '_PVT'
1240: );
1241: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1242: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1243: (
1244: l_api_name,
1245: G_PKG_NAME,
1246: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1246: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1242: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1243: (
1244: l_api_name,
1245: G_PKG_NAME,
1246: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1247: x_msg_count,
1248: x_msg_data,
1249: '_PVT'
1250: );

Line 1252: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1248: x_msg_data,
1249: '_PVT'
1250: );
1251: WHEN OTHERS THEN
1252: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1253: (
1254: l_api_name,
1255: G_PKG_NAME,
1256: 'OTHERS',

Line 1267: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1263: -- PL/SQL TBL lock_row for:RPS_TBL --
1264: -------------------------------------
1265: PROCEDURE lock_row(
1266: p_api_version IN NUMBER,
1267: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1268: x_return_status OUT NOCOPY VARCHAR2,
1269: x_msg_count OUT NOCOPY NUMBER,
1270: x_msg_data OUT NOCOPY VARCHAR2,
1271: p_rps_tbl IN rps_tbl_type) IS

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

1271: p_rps_tbl IN rps_tbl_type) IS
1272:
1273: l_api_version CONSTANT NUMBER := 1;
1274: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1275: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1276: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1277: BEGIN
1278: OKL_API.init_msg_list(p_init_msg_list);
1279: -- Make sure PL/SQL table has recrods in it before passing

Line 1276: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1272:
1273: l_api_version CONSTANT NUMBER := 1;
1274: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1275: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1276: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1277: BEGIN
1278: OKL_API.init_msg_list(p_init_msg_list);
1279: -- Make sure PL/SQL table has recrods in it before passing
1280: IF (p_rps_tbl.COUNT > 0) THEN

Line 1278: OKL_API.init_msg_list(p_init_msg_list);

1274: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1275: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1276: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1277: BEGIN
1278: OKL_API.init_msg_list(p_init_msg_list);
1279: -- Make sure PL/SQL table has recrods in it before passing
1280: IF (p_rps_tbl.COUNT > 0) THEN
1281: lock_row(
1282: p_api_version => p_api_version,

Line 1283: p_init_msg_list => OKL_API.G_FALSE,

1279: -- Make sure PL/SQL table has recrods in it before passing
1280: IF (p_rps_tbl.COUNT > 0) THEN
1281: lock_row(
1282: p_api_version => p_api_version,
1283: p_init_msg_list => OKL_API.G_FALSE,
1284: x_return_status => x_return_status,
1285: x_msg_count => x_msg_count,
1286: x_msg_data => x_msg_data,
1287: p_rps_tbl => p_rps_tbl,

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

1286: x_msg_data => x_msg_data,
1287: p_rps_tbl => p_rps_tbl,
1288: px_error_tbl => l_error_tbl);
1289: END IF;
1290: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1291: EXCEPTION
1292: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1293: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1294: (

Line 1292: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1288: px_error_tbl => l_error_tbl);
1289: END IF;
1290: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1291: EXCEPTION
1292: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1293: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1294: (
1295: l_api_name,
1296: G_PKG_NAME,

Line 1293: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1289: END IF;
1290: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1291: EXCEPTION
1292: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1293: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1294: (
1295: l_api_name,
1296: G_PKG_NAME,
1297: 'OKL_API.G_RET_STS_ERROR',

Line 1297: 'OKL_API.G_RET_STS_ERROR',

1293: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1294: (
1295: l_api_name,
1296: G_PKG_NAME,
1297: 'OKL_API.G_RET_STS_ERROR',
1298: x_msg_count,
1299: x_msg_data,
1300: '_PVT'
1301: );

Line 1302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1298: x_msg_count,
1299: x_msg_data,
1300: '_PVT'
1301: );
1302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1303: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1304: (
1305: l_api_name,
1306: G_PKG_NAME,

Line 1303: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1299: x_msg_data,
1300: '_PVT'
1301: );
1302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1303: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1304: (
1305: l_api_name,
1306: G_PKG_NAME,
1307: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1307: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1303: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1304: (
1305: l_api_name,
1306: G_PKG_NAME,
1307: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1308: x_msg_count,
1309: x_msg_data,
1310: '_PVT'
1311: );

Line 1313: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1309: x_msg_data,
1310: '_PVT'
1311: );
1312: WHEN OTHERS THEN
1313: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1314: (
1315: l_api_name,
1316: G_PKG_NAME,
1317: 'OTHERS',

Line 1330: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1326: ---------------------------------------------
1327: -- update_row for:OKL_REPORT_STREAM_PARAMS --
1328: ---------------------------------------------
1329: PROCEDURE update_row(
1330: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1331: x_return_status OUT NOCOPY VARCHAR2,
1332: x_msg_count OUT NOCOPY NUMBER,
1333: x_msg_data OUT NOCOPY VARCHAR2,
1334: p_rps_rec IN rps_rec_type,

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

1335: x_rps_rec OUT NOCOPY rps_rec_type) IS
1336:
1337: l_api_version CONSTANT NUMBER := 1;
1338: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1339: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1340: l_rps_rec rps_rec_type := p_rps_rec;
1341: l_def_rps_rec rps_rec_type;
1342: l_row_notfound BOOLEAN := TRUE;
1343: ----------------------------------

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

1348: x_rps_rec OUT NOCOPY rps_rec_type
1349: ) RETURN VARCHAR2 IS
1350: l_rps_rec rps_rec_type;
1351: l_row_notfound BOOLEAN := TRUE;
1352: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1353: BEGIN
1354: x_rps_rec := p_rps_rec;
1355: -- Get current database values
1356: l_rps_rec := get_rec(p_rps_rec, l_return_status);

Line 1357: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

1353: BEGIN
1354: x_rps_rec := p_rps_rec;
1355: -- Get current database values
1356: l_rps_rec := get_rec(p_rps_rec, l_return_status);
1357: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1358: IF x_rps_rec.stream_parameter_id IS NULL OR x_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM THEN
1359: x_rps_rec.stream_parameter_id := l_rps_rec.stream_parameter_id;
1360: END IF;
1361: IF x_rps_rec.report_id IS NULL OR x_rps_rec.report_id = OKL_API.G_MISS_NUM THEN

Line 1358: IF x_rps_rec.stream_parameter_id IS NULL OR x_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM THEN

1354: x_rps_rec := p_rps_rec;
1355: -- Get current database values
1356: l_rps_rec := get_rec(p_rps_rec, l_return_status);
1357: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1358: IF x_rps_rec.stream_parameter_id IS NULL OR x_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM THEN
1359: x_rps_rec.stream_parameter_id := l_rps_rec.stream_parameter_id;
1360: END IF;
1361: IF x_rps_rec.report_id IS NULL OR x_rps_rec.report_id = OKL_API.G_MISS_NUM THEN
1362: x_rps_rec.report_id := l_rps_rec.report_id;

Line 1361: IF x_rps_rec.report_id IS NULL OR x_rps_rec.report_id = OKL_API.G_MISS_NUM THEN

1357: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1358: IF x_rps_rec.stream_parameter_id IS NULL OR x_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM THEN
1359: x_rps_rec.stream_parameter_id := l_rps_rec.stream_parameter_id;
1360: END IF;
1361: IF x_rps_rec.report_id IS NULL OR x_rps_rec.report_id = OKL_API.G_MISS_NUM THEN
1362: x_rps_rec.report_id := l_rps_rec.report_id;
1363: END IF;
1364: IF x_rps_rec.sty_id IS NULL OR x_rps_rec.sty_id = OKL_API.G_MISS_NUM THEN
1365: x_rps_rec.sty_id := l_rps_rec.sty_id;

Line 1364: IF x_rps_rec.sty_id IS NULL OR x_rps_rec.sty_id = OKL_API.G_MISS_NUM THEN

1360: END IF;
1361: IF x_rps_rec.report_id IS NULL OR x_rps_rec.report_id = OKL_API.G_MISS_NUM THEN
1362: x_rps_rec.report_id := l_rps_rec.report_id;
1363: END IF;
1364: IF x_rps_rec.sty_id IS NULL OR x_rps_rec.sty_id = OKL_API.G_MISS_NUM THEN
1365: x_rps_rec.sty_id := l_rps_rec.sty_id;
1366: END IF;
1367: IF x_rps_rec.activity_code = OKL_API.G_MISS_CHAR THEN
1368: x_rps_rec.activity_code := l_rps_rec.activity_code;

Line 1367: IF x_rps_rec.activity_code = OKL_API.G_MISS_CHAR THEN

1363: END IF;
1364: IF x_rps_rec.sty_id IS NULL OR x_rps_rec.sty_id = OKL_API.G_MISS_NUM THEN
1365: x_rps_rec.sty_id := l_rps_rec.sty_id;
1366: END IF;
1367: IF x_rps_rec.activity_code = OKL_API.G_MISS_CHAR THEN
1368: x_rps_rec.activity_code := l_rps_rec.activity_code;
1369: END IF;
1370: IF x_rps_rec.created_by IS NULL OR x_rps_rec.created_by = OKL_API.G_MISS_NUM THEN
1371: x_rps_rec.created_by := l_rps_rec.created_by;

Line 1370: IF x_rps_rec.created_by IS NULL OR x_rps_rec.created_by = OKL_API.G_MISS_NUM THEN

1366: END IF;
1367: IF x_rps_rec.activity_code = OKL_API.G_MISS_CHAR THEN
1368: x_rps_rec.activity_code := l_rps_rec.activity_code;
1369: END IF;
1370: IF x_rps_rec.created_by IS NULL OR x_rps_rec.created_by = OKL_API.G_MISS_NUM THEN
1371: x_rps_rec.created_by := l_rps_rec.created_by;
1372: END IF;
1373: IF x_rps_rec.creation_date IS NULL OR x_rps_rec.creation_date = OKL_API.G_MISS_DATE THEN
1374: x_rps_rec.creation_date := l_rps_rec.creation_date;

Line 1373: IF x_rps_rec.creation_date IS NULL OR x_rps_rec.creation_date = OKL_API.G_MISS_DATE THEN

1369: END IF;
1370: IF x_rps_rec.created_by IS NULL OR x_rps_rec.created_by = OKL_API.G_MISS_NUM THEN
1371: x_rps_rec.created_by := l_rps_rec.created_by;
1372: END IF;
1373: IF x_rps_rec.creation_date IS NULL OR x_rps_rec.creation_date = OKL_API.G_MISS_DATE THEN
1374: x_rps_rec.creation_date := l_rps_rec.creation_date;
1375: END IF;
1376: IF x_rps_rec.last_updated_by IS NULL OR x_rps_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
1377: x_rps_rec.last_updated_by := l_rps_rec.last_updated_by;

Line 1376: IF x_rps_rec.last_updated_by IS NULL OR x_rps_rec.last_updated_by = OKL_API.G_MISS_NUM THEN

1372: END IF;
1373: IF x_rps_rec.creation_date IS NULL OR x_rps_rec.creation_date = OKL_API.G_MISS_DATE THEN
1374: x_rps_rec.creation_date := l_rps_rec.creation_date;
1375: END IF;
1376: IF x_rps_rec.last_updated_by IS NULL OR x_rps_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
1377: x_rps_rec.last_updated_by := l_rps_rec.last_updated_by;
1378: END IF;
1379: IF x_rps_rec.last_update_date IS NULL OR x_rps_rec.last_update_date = OKL_API.G_MISS_DATE THEN
1380: x_rps_rec.last_update_date := l_rps_rec.last_update_date;

Line 1379: IF x_rps_rec.last_update_date IS NULL OR x_rps_rec.last_update_date = OKL_API.G_MISS_DATE THEN

1375: END IF;
1376: IF x_rps_rec.last_updated_by IS NULL OR x_rps_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
1377: x_rps_rec.last_updated_by := l_rps_rec.last_updated_by;
1378: END IF;
1379: IF x_rps_rec.last_update_date IS NULL OR x_rps_rec.last_update_date = OKL_API.G_MISS_DATE THEN
1380: x_rps_rec.last_update_date := l_rps_rec.last_update_date;
1381: END IF;
1382: IF x_rps_rec.last_update_login = OKL_API.G_MISS_NUM THEN
1383: x_rps_rec.last_update_login := l_rps_rec.last_update_login;

Line 1382: IF x_rps_rec.last_update_login = OKL_API.G_MISS_NUM THEN

1378: END IF;
1379: IF x_rps_rec.last_update_date IS NULL OR x_rps_rec.last_update_date = OKL_API.G_MISS_DATE THEN
1380: x_rps_rec.last_update_date := l_rps_rec.last_update_date;
1381: END IF;
1382: IF x_rps_rec.last_update_login = OKL_API.G_MISS_NUM THEN
1383: x_rps_rec.last_update_login := l_rps_rec.last_update_login;
1384: END IF;
1385: END IF;
1386: RETURN(l_return_status);

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

1391: FUNCTION Set_Attributes (
1392: p_rps_rec IN rps_rec_type,
1393: x_rps_rec OUT NOCOPY rps_rec_type
1394: ) RETURN VARCHAR2 IS
1395: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1396: BEGIN
1397: x_rps_rec := p_rps_rec;
1398: RETURN(l_return_status);
1399: END Set_Attributes;

Line 1401: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1397: x_rps_rec := p_rps_rec;
1398: RETURN(l_return_status);
1399: END Set_Attributes;
1400: BEGIN
1401: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1402: p_init_msg_list,
1403: '_PVT',
1404: x_return_status);
1405: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1401: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1402: p_init_msg_list,
1403: '_PVT',
1404: x_return_status);
1405: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1406: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1407: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1408: RAISE OKL_API.G_EXCEPTION_ERROR;
1409: END IF;

Line 1406: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1402: p_init_msg_list,
1403: '_PVT',
1404: x_return_status);
1405: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1406: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1407: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1408: RAISE OKL_API.G_EXCEPTION_ERROR;
1409: END IF;
1410: --- Setting item attributes

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

1403: '_PVT',
1404: x_return_status);
1405: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1406: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1407: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1408: RAISE OKL_API.G_EXCEPTION_ERROR;
1409: END IF;
1410: --- Setting item attributes
1411: l_return_status := Set_Attributes(

Line 1408: RAISE OKL_API.G_EXCEPTION_ERROR;

1404: x_return_status);
1405: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1406: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1407: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1408: RAISE OKL_API.G_EXCEPTION_ERROR;
1409: END IF;
1410: --- Setting item attributes
1411: l_return_status := Set_Attributes(
1412: p_rps_rec, -- IN

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

1411: l_return_status := Set_Attributes(
1412: p_rps_rec, -- IN
1413: l_rps_rec); -- OUT
1414: --- If any errors happen abort API
1415: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1417: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1418: RAISE OKL_API.G_EXCEPTION_ERROR;
1419: END IF;

Line 1416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1412: p_rps_rec, -- IN
1413: l_rps_rec); -- OUT
1414: --- If any errors happen abort API
1415: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1417: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1418: RAISE OKL_API.G_EXCEPTION_ERROR;
1419: END IF;
1420: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);

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

1413: l_rps_rec); -- OUT
1414: --- If any errors happen abort API
1415: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1417: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1418: RAISE OKL_API.G_EXCEPTION_ERROR;
1419: END IF;
1420: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1421: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1418: RAISE OKL_API.G_EXCEPTION_ERROR;

1414: --- If any errors happen abort API
1415: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1417: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1418: RAISE OKL_API.G_EXCEPTION_ERROR;
1419: END IF;
1420: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1421: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1422: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1417: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1418: RAISE OKL_API.G_EXCEPTION_ERROR;
1419: END IF;
1420: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1421: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1422: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1423: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1424: RAISE OKL_API.G_EXCEPTION_ERROR;
1425: END IF;

Line 1422: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1418: RAISE OKL_API.G_EXCEPTION_ERROR;
1419: END IF;
1420: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1421: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1422: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1423: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1424: RAISE OKL_API.G_EXCEPTION_ERROR;
1425: END IF;
1426:

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

1419: END IF;
1420: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1421: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1422: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1423: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1424: RAISE OKL_API.G_EXCEPTION_ERROR;
1425: END IF;
1426:
1427: UPDATE OKL_REPORT_STREAM_PARAMS

Line 1424: RAISE OKL_API.G_EXCEPTION_ERROR;

1420: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1421: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1422: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1423: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1424: RAISE OKL_API.G_EXCEPTION_ERROR;
1425: END IF;
1426:
1427: UPDATE OKL_REPORT_STREAM_PARAMS
1428: SET REPORT_ID = l_def_rps_rec.report_id,

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

1436: WHERE STREAM_PARAMETER_ID = l_def_rps_rec.stream_parameter_id;
1437:
1438: x_rps_rec := l_rps_rec;
1439: x_return_status := l_return_status;
1440: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1441: EXCEPTION
1442: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1443: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1444: (

Line 1442: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1438: x_rps_rec := l_rps_rec;
1439: x_return_status := l_return_status;
1440: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1441: EXCEPTION
1442: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1443: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1444: (
1445: l_api_name,
1446: G_PKG_NAME,

Line 1443: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1439: x_return_status := l_return_status;
1440: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1441: EXCEPTION
1442: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1443: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1444: (
1445: l_api_name,
1446: G_PKG_NAME,
1447: 'OKL_API.G_RET_STS_ERROR',

Line 1447: 'OKL_API.G_RET_STS_ERROR',

1443: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1444: (
1445: l_api_name,
1446: G_PKG_NAME,
1447: 'OKL_API.G_RET_STS_ERROR',
1448: x_msg_count,
1449: x_msg_data,
1450: '_PVT'
1451: );

Line 1452: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1448: x_msg_count,
1449: x_msg_data,
1450: '_PVT'
1451: );
1452: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1453: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1454: (
1455: l_api_name,
1456: G_PKG_NAME,

Line 1453: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1449: x_msg_data,
1450: '_PVT'
1451: );
1452: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1453: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1454: (
1455: l_api_name,
1456: G_PKG_NAME,
1457: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1457: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1453: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1454: (
1455: l_api_name,
1456: G_PKG_NAME,
1457: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1458: x_msg_count,
1459: x_msg_data,
1460: '_PVT'
1461: );

Line 1463: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1459: x_msg_data,
1460: '_PVT'
1461: );
1462: WHEN OTHERS THEN
1463: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1464: (
1465: l_api_name,
1466: G_PKG_NAME,
1467: 'OTHERS',

Line 1478: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1474: -- update_row for:OKL_REPORT_STREAM_PARAMS --
1475: ---------------------------------------------
1476: PROCEDURE update_row(
1477: p_api_version IN NUMBER,
1478: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1479: x_return_status OUT NOCOPY VARCHAR2,
1480: x_msg_count OUT NOCOPY NUMBER,
1481: x_msg_data OUT NOCOPY VARCHAR2,
1482: p_rps_rec IN rps_rec_type,

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

1483: x_rps_rec OUT NOCOPY rps_rec_type) IS
1484:
1485: l_api_version CONSTANT NUMBER := 1;
1486: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1487: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1488: l_rps_rec rps_rec_type := p_rps_rec;
1489: l_def_rps_rec rps_rec_type;
1490: l_db_rps_rec rps_rec_type;
1491: lx_rps_rec rps_rec_type;

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

1509: p_rps_rec IN rps_rec_type,
1510: x_rps_rec OUT NOCOPY rps_rec_type
1511: ) RETURN VARCHAR2 IS
1512: l_row_notfound BOOLEAN := TRUE;
1513: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1514: BEGIN
1515: x_rps_rec := p_rps_rec;
1516: -- Get current database values
1517: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

Line 1520: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

1516: -- Get current database values
1517: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1518: -- so it may be verified through LOCK_ROW.
1519: l_db_rps_rec := get_rec(p_rps_rec, l_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1521: IF x_rps_rec.stream_parameter_id IS NULL OR x_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM THEN
1522: x_rps_rec.stream_parameter_id := l_db_rps_rec.stream_parameter_id;
1523: END IF;
1524: IF x_rps_rec.report_id IS NULL OR x_rps_rec.report_id = OKL_API.G_MISS_NUM THEN

Line 1521: IF x_rps_rec.stream_parameter_id IS NULL OR x_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM THEN

1517: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1518: -- so it may be verified through LOCK_ROW.
1519: l_db_rps_rec := get_rec(p_rps_rec, l_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1521: IF x_rps_rec.stream_parameter_id IS NULL OR x_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM THEN
1522: x_rps_rec.stream_parameter_id := l_db_rps_rec.stream_parameter_id;
1523: END IF;
1524: IF x_rps_rec.report_id IS NULL OR x_rps_rec.report_id = OKL_API.G_MISS_NUM THEN
1525: x_rps_rec.report_id := l_db_rps_rec.report_id;

Line 1524: IF x_rps_rec.report_id IS NULL OR x_rps_rec.report_id = OKL_API.G_MISS_NUM THEN

1520: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1521: IF x_rps_rec.stream_parameter_id IS NULL OR x_rps_rec.stream_parameter_id = OKL_API.G_MISS_NUM THEN
1522: x_rps_rec.stream_parameter_id := l_db_rps_rec.stream_parameter_id;
1523: END IF;
1524: IF x_rps_rec.report_id IS NULL OR x_rps_rec.report_id = OKL_API.G_MISS_NUM THEN
1525: x_rps_rec.report_id := l_db_rps_rec.report_id;
1526: END IF;
1527: IF x_rps_rec.sty_id IS NULL OR x_rps_rec.sty_id = OKL_API.G_MISS_NUM THEN
1528: x_rps_rec.sty_id := l_db_rps_rec.sty_id;

Line 1527: IF x_rps_rec.sty_id IS NULL OR x_rps_rec.sty_id = OKL_API.G_MISS_NUM THEN

1523: END IF;
1524: IF x_rps_rec.report_id IS NULL OR x_rps_rec.report_id = OKL_API.G_MISS_NUM THEN
1525: x_rps_rec.report_id := l_db_rps_rec.report_id;
1526: END IF;
1527: IF x_rps_rec.sty_id IS NULL OR x_rps_rec.sty_id = OKL_API.G_MISS_NUM THEN
1528: x_rps_rec.sty_id := l_db_rps_rec.sty_id;
1529: END IF;
1530: IF x_rps_rec.activity_code IS NULL OR x_rps_rec.activity_code = OKL_API.G_MISS_CHAR THEN
1531: x_rps_rec.activity_code := l_db_rps_rec.activity_code;

Line 1530: IF x_rps_rec.activity_code IS NULL OR x_rps_rec.activity_code = OKL_API.G_MISS_CHAR THEN

1526: END IF;
1527: IF x_rps_rec.sty_id IS NULL OR x_rps_rec.sty_id = OKL_API.G_MISS_NUM THEN
1528: x_rps_rec.sty_id := l_db_rps_rec.sty_id;
1529: END IF;
1530: IF x_rps_rec.activity_code IS NULL OR x_rps_rec.activity_code = OKL_API.G_MISS_CHAR THEN
1531: x_rps_rec.activity_code := l_db_rps_rec.activity_code;
1532: END IF;
1533: IF x_rps_rec.created_by IS NULL OR x_rps_rec.created_by = OKL_API.G_MISS_NUM THEN
1534: x_rps_rec.created_by := l_db_rps_rec.created_by;

Line 1533: IF x_rps_rec.created_by IS NULL OR x_rps_rec.created_by = OKL_API.G_MISS_NUM THEN

1529: END IF;
1530: IF x_rps_rec.activity_code IS NULL OR x_rps_rec.activity_code = OKL_API.G_MISS_CHAR THEN
1531: x_rps_rec.activity_code := l_db_rps_rec.activity_code;
1532: END IF;
1533: IF x_rps_rec.created_by IS NULL OR x_rps_rec.created_by = OKL_API.G_MISS_NUM THEN
1534: x_rps_rec.created_by := l_db_rps_rec.created_by;
1535: END IF;
1536: IF x_rps_rec.creation_date IS NULL OR x_rps_rec.creation_date = OKL_API.G_MISS_DATE THEN
1537: x_rps_rec.creation_date := l_db_rps_rec.creation_date;

Line 1536: IF x_rps_rec.creation_date IS NULL OR x_rps_rec.creation_date = OKL_API.G_MISS_DATE THEN

1532: END IF;
1533: IF x_rps_rec.created_by IS NULL OR x_rps_rec.created_by = OKL_API.G_MISS_NUM THEN
1534: x_rps_rec.created_by := l_db_rps_rec.created_by;
1535: END IF;
1536: IF x_rps_rec.creation_date IS NULL OR x_rps_rec.creation_date = OKL_API.G_MISS_DATE THEN
1537: x_rps_rec.creation_date := l_db_rps_rec.creation_date;
1538: END IF;
1539: IF x_rps_rec.last_updated_by IS NULL OR x_rps_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
1540: x_rps_rec.last_updated_by := l_db_rps_rec.last_updated_by;

Line 1539: IF x_rps_rec.last_updated_by IS NULL OR x_rps_rec.last_updated_by = OKL_API.G_MISS_NUM THEN

1535: END IF;
1536: IF x_rps_rec.creation_date IS NULL OR x_rps_rec.creation_date = OKL_API.G_MISS_DATE THEN
1537: x_rps_rec.creation_date := l_db_rps_rec.creation_date;
1538: END IF;
1539: IF x_rps_rec.last_updated_by IS NULL OR x_rps_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
1540: x_rps_rec.last_updated_by := l_db_rps_rec.last_updated_by;
1541: END IF;
1542: IF x_rps_rec.last_update_date IS NULL OR x_rps_rec.last_update_date = OKL_API.G_MISS_DATE THEN
1543: x_rps_rec.last_update_date := l_db_rps_rec.last_update_date;

Line 1542: IF x_rps_rec.last_update_date IS NULL OR x_rps_rec.last_update_date = OKL_API.G_MISS_DATE THEN

1538: END IF;
1539: IF x_rps_rec.last_updated_by IS NULL OR x_rps_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
1540: x_rps_rec.last_updated_by := l_db_rps_rec.last_updated_by;
1541: END IF;
1542: IF x_rps_rec.last_update_date IS NULL OR x_rps_rec.last_update_date = OKL_API.G_MISS_DATE THEN
1543: x_rps_rec.last_update_date := l_db_rps_rec.last_update_date;
1544: END IF;
1545: IF x_rps_rec.last_update_login = OKL_API.G_MISS_NUM THEN
1546: x_rps_rec.last_update_login := l_db_rps_rec.last_update_login;

Line 1545: IF x_rps_rec.last_update_login = OKL_API.G_MISS_NUM THEN

1541: END IF;
1542: IF x_rps_rec.last_update_date IS NULL OR x_rps_rec.last_update_date = OKL_API.G_MISS_DATE THEN
1543: x_rps_rec.last_update_date := l_db_rps_rec.last_update_date;
1544: END IF;
1545: IF x_rps_rec.last_update_login = OKL_API.G_MISS_NUM THEN
1546: x_rps_rec.last_update_login := l_db_rps_rec.last_update_login;
1547: END IF;
1548: END IF;
1549: RETURN(l_return_status);

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

1554: FUNCTION Set_Attributes (
1555: p_rps_rec IN rps_rec_type,
1556: x_rps_rec OUT NOCOPY rps_rec_type
1557: ) RETURN VARCHAR2 IS
1558: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1559: BEGIN
1560: x_rps_rec := p_rps_rec;
1561: RETURN(l_return_status);
1562: END Set_Attributes;

Line 1564: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1560: x_rps_rec := p_rps_rec;
1561: RETURN(l_return_status);
1562: END Set_Attributes;
1563: BEGIN
1564: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1565: G_PKG_NAME,
1566: p_init_msg_list,
1567: l_api_version,
1568: p_api_version,

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

1567: l_api_version,
1568: p_api_version,
1569: '_PVT',
1570: x_return_status);
1571: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_ERROR;
1575: END IF;

Line 1572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1568: p_api_version,
1569: '_PVT',
1570: x_return_status);
1571: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_ERROR;
1575: END IF;
1576: --- Setting item attributes

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

1569: '_PVT',
1570: x_return_status);
1571: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_ERROR;
1575: END IF;
1576: --- Setting item attributes
1577: l_return_status := Set_Attributes(

Line 1574: RAISE OKL_API.G_EXCEPTION_ERROR;

1570: x_return_status);
1571: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_ERROR;
1575: END IF;
1576: --- Setting item attributes
1577: l_return_status := Set_Attributes(
1578: p_rps_rec, -- IN

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

1577: l_return_status := Set_Attributes(
1578: p_rps_rec, -- IN
1579: x_rps_rec); -- OUT
1580: --- If any errors happen abort API
1581: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1583: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1584: RAISE OKL_API.G_EXCEPTION_ERROR;
1585: END IF;

Line 1582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1578: p_rps_rec, -- IN
1579: x_rps_rec); -- OUT
1580: --- If any errors happen abort API
1581: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1583: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1584: RAISE OKL_API.G_EXCEPTION_ERROR;
1585: END IF;
1586: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);

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

1579: x_rps_rec); -- OUT
1580: --- If any errors happen abort API
1581: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1583: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1584: RAISE OKL_API.G_EXCEPTION_ERROR;
1585: END IF;
1586: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1587: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1584: RAISE OKL_API.G_EXCEPTION_ERROR;

1580: --- If any errors happen abort API
1581: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1583: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1584: RAISE OKL_API.G_EXCEPTION_ERROR;
1585: END IF;
1586: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1587: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1588: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1583: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1584: RAISE OKL_API.G_EXCEPTION_ERROR;
1585: END IF;
1586: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1587: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1588: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1589: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1590: RAISE OKL_API.G_EXCEPTION_ERROR;
1591: END IF;

Line 1588: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1584: RAISE OKL_API.G_EXCEPTION_ERROR;
1585: END IF;
1586: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1587: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1588: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1589: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1590: RAISE OKL_API.G_EXCEPTION_ERROR;
1591: END IF;
1592: l_def_rps_rec := null_out_defaults(l_def_rps_rec);

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

1585: END IF;
1586: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1587: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1588: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1589: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1590: RAISE OKL_API.G_EXCEPTION_ERROR;
1591: END IF;
1592: l_def_rps_rec := null_out_defaults(l_def_rps_rec);
1593: l_def_rps_rec := fill_who_columns(l_def_rps_rec);

Line 1590: RAISE OKL_API.G_EXCEPTION_ERROR;

1586: l_return_status := populate_new_record(l_rps_rec, l_def_rps_rec);
1587: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1588: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1589: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1590: RAISE OKL_API.G_EXCEPTION_ERROR;
1591: END IF;
1592: l_def_rps_rec := null_out_defaults(l_def_rps_rec);
1593: l_def_rps_rec := fill_who_columns(l_def_rps_rec);
1594: --- Validate all non-missing attributes (Item Level Validation)

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

1593: l_def_rps_rec := fill_who_columns(l_def_rps_rec);
1594: --- Validate all non-missing attributes (Item Level Validation)
1595: l_return_status := Validate_Attributes(l_def_rps_rec);
1596: --- If any errors happen abort API
1597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1600: RAISE OKL_API.G_EXCEPTION_ERROR;
1601: END IF;

Line 1598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1594: --- Validate all non-missing attributes (Item Level Validation)
1595: l_return_status := Validate_Attributes(l_def_rps_rec);
1596: --- If any errors happen abort API
1597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1600: RAISE OKL_API.G_EXCEPTION_ERROR;
1601: END IF;
1602: l_return_status := Validate_Record(l_def_rps_rec, l_db_rps_rec);

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

1595: l_return_status := Validate_Attributes(l_def_rps_rec);
1596: --- If any errors happen abort API
1597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1600: RAISE OKL_API.G_EXCEPTION_ERROR;
1601: END IF;
1602: l_return_status := Validate_Record(l_def_rps_rec, l_db_rps_rec);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1600: RAISE OKL_API.G_EXCEPTION_ERROR;

1596: --- If any errors happen abort API
1597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1600: RAISE OKL_API.G_EXCEPTION_ERROR;
1601: END IF;
1602: l_return_status := Validate_Record(l_def_rps_rec, l_db_rps_rec);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1600: RAISE OKL_API.G_EXCEPTION_ERROR;
1601: END IF;
1602: l_return_status := Validate_Record(l_def_rps_rec, l_db_rps_rec);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1605: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;

Line 1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1600: RAISE OKL_API.G_EXCEPTION_ERROR;
1601: END IF;
1602: l_return_status := Validate_Record(l_def_rps_rec, l_db_rps_rec);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1605: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;
1608:

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

1601: END IF;
1602: l_return_status := Validate_Record(l_def_rps_rec, l_db_rps_rec);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1605: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;
1608:
1609: -- Lock the Record

Line 1606: RAISE OKL_API.G_EXCEPTION_ERROR;

1602: l_return_status := Validate_Record(l_def_rps_rec, l_db_rps_rec);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1605: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;
1608:
1609: -- Lock the Record
1610: lock_row(

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

1613: x_return_status => l_return_status,
1614: x_msg_count => x_msg_count,
1615: x_msg_data => x_msg_data,
1616: p_rps_rec => p_rps_rec);
1617: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1619: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1620: RAISE OKL_API.G_EXCEPTION_ERROR;
1621: END IF;

Line 1618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1614: x_msg_count => x_msg_count,
1615: x_msg_data => x_msg_data,
1616: p_rps_rec => p_rps_rec);
1617: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1619: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1620: RAISE OKL_API.G_EXCEPTION_ERROR;
1621: END IF;
1622:

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

1615: x_msg_data => x_msg_data,
1616: p_rps_rec => p_rps_rec);
1617: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1619: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1620: RAISE OKL_API.G_EXCEPTION_ERROR;
1621: END IF;
1622:
1623: -----------------------------------------

Line 1620: RAISE OKL_API.G_EXCEPTION_ERROR;

1616: p_rps_rec => p_rps_rec);
1617: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1619: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1620: RAISE OKL_API.G_EXCEPTION_ERROR;
1621: END IF;
1622:
1623: -----------------------------------------
1624: -- Move VIEW record to "Child" records --

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

1633: x_msg_data,
1634: l_rps_rec,
1635: lx_rps_rec
1636: );
1637: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1640: RAISE OKL_API.G_EXCEPTION_ERROR;
1641: END IF;

Line 1638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1634: l_rps_rec,
1635: lx_rps_rec
1636: );
1637: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1640: RAISE OKL_API.G_EXCEPTION_ERROR;
1641: END IF;
1642: x_rps_rec := l_def_rps_rec;

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

1635: lx_rps_rec
1636: );
1637: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1640: RAISE OKL_API.G_EXCEPTION_ERROR;
1641: END IF;
1642: x_rps_rec := l_def_rps_rec;
1643: x_return_status := l_return_status;

Line 1640: RAISE OKL_API.G_EXCEPTION_ERROR;

1636: );
1637: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1640: RAISE OKL_API.G_EXCEPTION_ERROR;
1641: END IF;
1642: x_rps_rec := l_def_rps_rec;
1643: x_return_status := l_return_status;
1644: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1640: RAISE OKL_API.G_EXCEPTION_ERROR;
1641: END IF;
1642: x_rps_rec := l_def_rps_rec;
1643: x_return_status := l_return_status;
1644: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1645: EXCEPTION
1646: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1647: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1648: (

Line 1646: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1642: x_rps_rec := l_def_rps_rec;
1643: x_return_status := l_return_status;
1644: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1645: EXCEPTION
1646: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1647: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1648: (
1649: l_api_name,
1650: G_PKG_NAME,

Line 1647: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1643: x_return_status := l_return_status;
1644: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1645: EXCEPTION
1646: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1647: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1648: (
1649: l_api_name,
1650: G_PKG_NAME,
1651: 'OKL_API.G_RET_STS_ERROR',

Line 1651: 'OKL_API.G_RET_STS_ERROR',

1647: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1648: (
1649: l_api_name,
1650: G_PKG_NAME,
1651: 'OKL_API.G_RET_STS_ERROR',
1652: x_msg_count,
1653: x_msg_data,
1654: '_PVT'
1655: );

Line 1656: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1652: x_msg_count,
1653: x_msg_data,
1654: '_PVT'
1655: );
1656: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1657: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1658: (
1659: l_api_name,
1660: G_PKG_NAME,

Line 1657: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1653: x_msg_data,
1654: '_PVT'
1655: );
1656: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1657: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1658: (
1659: l_api_name,
1660: G_PKG_NAME,
1661: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1661: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1657: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1658: (
1659: l_api_name,
1660: G_PKG_NAME,
1661: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1662: x_msg_count,
1663: x_msg_data,
1664: '_PVT'
1665: );

Line 1667: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1663: x_msg_data,
1664: '_PVT'
1665: );
1666: WHEN OTHERS THEN
1667: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1668: (
1669: l_api_name,
1670: G_PKG_NAME,
1671: 'OTHERS',

Line 1682: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1678: -- PL/SQL TBL update_row for:rps_tbl --
1679: ---------------------------------------
1680: PROCEDURE update_row(
1681: p_api_version IN NUMBER,
1682: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1683: x_return_status OUT NOCOPY VARCHAR2,
1684: x_msg_count OUT NOCOPY NUMBER,
1685: x_msg_data OUT NOCOPY VARCHAR2,
1686: p_rps_tbl IN rps_tbl_type,

Line 1688: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

1684: x_msg_count OUT NOCOPY NUMBER,
1685: x_msg_data OUT NOCOPY VARCHAR2,
1686: p_rps_tbl IN rps_tbl_type,
1687: x_rps_tbl OUT NOCOPY rps_tbl_type,
1688: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1689:
1690: l_api_version CONSTANT NUMBER := 1;
1691: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
1692: i NUMBER := 0;

Line 1694: OKL_API.init_msg_list(p_init_msg_list);

1690: l_api_version CONSTANT NUMBER := 1;
1691: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
1692: i NUMBER := 0;
1693: BEGIN
1694: OKL_API.init_msg_list(p_init_msg_list);
1695: -- Make sure PL/SQL table has records in it before passing
1696: IF (p_rps_tbl.COUNT > 0) THEN
1697: i := p_rps_tbl.FIRST;
1698: LOOP

Line 1700: l_error_rec OKL_API.ERROR_REC_TYPE;

1696: IF (p_rps_tbl.COUNT > 0) THEN
1697: i := p_rps_tbl.FIRST;
1698: LOOP
1699: DECLARE
1700: l_error_rec OKL_API.ERROR_REC_TYPE;
1701: BEGIN
1702: l_error_rec.api_name := l_api_name;
1703: l_error_rec.api_package := G_PKG_NAME;
1704: l_error_rec.idx := i;

Line 1707: p_init_msg_list => OKL_API.G_FALSE,

1703: l_error_rec.api_package := G_PKG_NAME;
1704: l_error_rec.idx := i;
1705: update_row (
1706: p_api_version => p_api_version,
1707: p_init_msg_list => OKL_API.G_FALSE,
1708: x_return_status => l_error_rec.error_type,
1709: x_msg_count => l_error_rec.msg_count,
1710: x_msg_data => l_error_rec.msg_data,
1711: p_rps_rec => p_rps_tbl(i),

Line 1713: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

1709: x_msg_count => l_error_rec.msg_count,
1710: x_msg_data => l_error_rec.msg_data,
1711: p_rps_rec => p_rps_tbl(i),
1712: x_rps_rec => x_rps_tbl(i));
1713: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1714: l_error_rec.sqlcode := SQLCODE;
1715: load_error_tbl(l_error_rec, px_error_tbl);
1716: ELSE
1717: x_msg_count := l_error_rec.msg_count;

Line 1721: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1717: x_msg_count := l_error_rec.msg_count;
1718: x_msg_data := l_error_rec.msg_data;
1719: END IF;
1720: EXCEPTION
1721: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1722: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1723: l_error_rec.sqlcode := SQLCODE;
1724: load_error_tbl(l_error_rec, px_error_tbl);
1725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1722: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;

1718: x_msg_data := l_error_rec.msg_data;
1719: END IF;
1720: EXCEPTION
1721: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1722: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1723: l_error_rec.sqlcode := SQLCODE;
1724: load_error_tbl(l_error_rec, px_error_tbl);
1725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1726: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1721: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1722: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1723: l_error_rec.sqlcode := SQLCODE;
1724: load_error_tbl(l_error_rec, px_error_tbl);
1725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1726: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1727: l_error_rec.sqlcode := SQLCODE;
1728: load_error_tbl(l_error_rec, px_error_tbl);
1729: WHEN OTHERS THEN

Line 1726: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

1722: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1723: l_error_rec.sqlcode := SQLCODE;
1724: load_error_tbl(l_error_rec, px_error_tbl);
1725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1726: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1727: l_error_rec.sqlcode := SQLCODE;
1728: load_error_tbl(l_error_rec, px_error_tbl);
1729: WHEN OTHERS THEN
1730: l_error_rec.error_type := 'OTHERS';

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

1737: END IF;
1738: -- Loop through the error_tbl to find the error with the highest severity
1739: -- and return it.
1740: x_return_status := find_highest_exception(px_error_tbl);
1741: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1742: EXCEPTION
1743: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1744: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1745: (

Line 1743: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1739: -- and return it.
1740: x_return_status := find_highest_exception(px_error_tbl);
1741: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1742: EXCEPTION
1743: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1744: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1745: (
1746: l_api_name,
1747: G_PKG_NAME,

Line 1744: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1740: x_return_status := find_highest_exception(px_error_tbl);
1741: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1742: EXCEPTION
1743: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1744: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1745: (
1746: l_api_name,
1747: G_PKG_NAME,
1748: 'OKL_API.G_RET_STS_ERROR',

Line 1748: 'OKL_API.G_RET_STS_ERROR',

1744: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1745: (
1746: l_api_name,
1747: G_PKG_NAME,
1748: 'OKL_API.G_RET_STS_ERROR',
1749: x_msg_count,
1750: x_msg_data,
1751: '_PVT'
1752: );

Line 1753: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1749: x_msg_count,
1750: x_msg_data,
1751: '_PVT'
1752: );
1753: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1754: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1755: (
1756: l_api_name,
1757: G_PKG_NAME,

Line 1754: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1750: x_msg_data,
1751: '_PVT'
1752: );
1753: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1754: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1755: (
1756: l_api_name,
1757: G_PKG_NAME,
1758: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1758: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1754: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1755: (
1756: l_api_name,
1757: G_PKG_NAME,
1758: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1759: x_msg_count,
1760: x_msg_data,
1761: '_PVT'
1762: );

Line 1764: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1760: x_msg_data,
1761: '_PVT'
1762: );
1763: WHEN OTHERS THEN
1764: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1765: (
1766: l_api_name,
1767: G_PKG_NAME,
1768: 'OTHERS',

Line 1780: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1776: -- PL/SQL TBL update_row for:RPS_TBL --
1777: ---------------------------------------
1778: PROCEDURE update_row(
1779: p_api_version IN NUMBER,
1780: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1781: x_return_status OUT NOCOPY VARCHAR2,
1782: x_msg_count OUT NOCOPY NUMBER,
1783: x_msg_data OUT NOCOPY VARCHAR2,
1784: p_rps_tbl IN rps_tbl_type,

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

1785: x_rps_tbl OUT NOCOPY rps_tbl_type) IS
1786:
1787: l_api_version CONSTANT NUMBER := 1;
1788: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1789: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1790: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1791: BEGIN
1792: OKL_API.init_msg_list(p_init_msg_list);
1793: -- Make sure PL/SQL table has records in it before passing

Line 1790: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1786:
1787: l_api_version CONSTANT NUMBER := 1;
1788: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1789: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1790: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1791: BEGIN
1792: OKL_API.init_msg_list(p_init_msg_list);
1793: -- Make sure PL/SQL table has records in it before passing
1794: IF (p_rps_tbl.COUNT > 0) THEN

Line 1792: OKL_API.init_msg_list(p_init_msg_list);

1788: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1789: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1790: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1791: BEGIN
1792: OKL_API.init_msg_list(p_init_msg_list);
1793: -- Make sure PL/SQL table has records in it before passing
1794: IF (p_rps_tbl.COUNT > 0) THEN
1795: update_row (
1796: p_api_version => p_api_version,

Line 1797: p_init_msg_list => OKL_API.G_FALSE,

1793: -- Make sure PL/SQL table has records in it before passing
1794: IF (p_rps_tbl.COUNT > 0) THEN
1795: update_row (
1796: p_api_version => p_api_version,
1797: p_init_msg_list => OKL_API.G_FALSE,
1798: x_return_status => x_return_status,
1799: x_msg_count => x_msg_count,
1800: x_msg_data => x_msg_data,
1801: p_rps_tbl => p_rps_tbl,

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

1801: p_rps_tbl => p_rps_tbl,
1802: x_rps_tbl => x_rps_tbl,
1803: px_error_tbl => l_error_tbl);
1804: END IF;
1805: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1806: EXCEPTION
1807: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1808: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1809: (

Line 1807: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1803: px_error_tbl => l_error_tbl);
1804: END IF;
1805: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1806: EXCEPTION
1807: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1808: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1809: (
1810: l_api_name,
1811: G_PKG_NAME,

Line 1808: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1804: END IF;
1805: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1806: EXCEPTION
1807: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1808: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1809: (
1810: l_api_name,
1811: G_PKG_NAME,
1812: 'OKL_API.G_RET_STS_ERROR',

Line 1812: 'OKL_API.G_RET_STS_ERROR',

1808: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1809: (
1810: l_api_name,
1811: G_PKG_NAME,
1812: 'OKL_API.G_RET_STS_ERROR',
1813: x_msg_count,
1814: x_msg_data,
1815: '_PVT'
1816: );

Line 1817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1813: x_msg_count,
1814: x_msg_data,
1815: '_PVT'
1816: );
1817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1818: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1819: (
1820: l_api_name,
1821: G_PKG_NAME,

Line 1818: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1814: x_msg_data,
1815: '_PVT'
1816: );
1817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1818: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1819: (
1820: l_api_name,
1821: G_PKG_NAME,
1822: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1822: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1818: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1819: (
1820: l_api_name,
1821: G_PKG_NAME,
1822: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1823: x_msg_count,
1824: x_msg_data,
1825: '_PVT'
1826: );

Line 1828: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1824: x_msg_data,
1825: '_PVT'
1826: );
1827: WHEN OTHERS THEN
1828: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1829: (
1830: l_api_name,
1831: G_PKG_NAME,
1832: 'OTHERS',

Line 1846: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1842: ---------------------------------------------
1843: -- delete_row for:OKL_REPORT_STREAM_PARAMS --
1844: ---------------------------------------------
1845: PROCEDURE delete_row(
1846: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1847: x_return_status OUT NOCOPY VARCHAR2,
1848: x_msg_count OUT NOCOPY NUMBER,
1849: x_msg_data OUT NOCOPY VARCHAR2,
1850: p_rps_rec IN rps_rec_type) IS

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

1850: p_rps_rec IN rps_rec_type) IS
1851:
1852: l_api_version CONSTANT NUMBER := 1;
1853: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
1854: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1855: l_rps_rec rps_rec_type := p_rps_rec;
1856: l_row_notfound BOOLEAN := TRUE;
1857: BEGIN
1858: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1858: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1854: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1855: l_rps_rec rps_rec_type := p_rps_rec;
1856: l_row_notfound BOOLEAN := TRUE;
1857: BEGIN
1858: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1859: p_init_msg_list,
1860: '_PVT',
1861: x_return_status);
1862: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1858: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1859: p_init_msg_list,
1860: '_PVT',
1861: x_return_status);
1862: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1864: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1865: RAISE OKL_API.G_EXCEPTION_ERROR;
1866: END IF;

Line 1863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1859: p_init_msg_list,
1860: '_PVT',
1861: x_return_status);
1862: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1864: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1865: RAISE OKL_API.G_EXCEPTION_ERROR;
1866: END IF;
1867:

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

1860: '_PVT',
1861: x_return_status);
1862: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1864: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1865: RAISE OKL_API.G_EXCEPTION_ERROR;
1866: END IF;
1867:
1868: DELETE FROM OKL_REPORT_STREAM_PARAMS

Line 1865: RAISE OKL_API.G_EXCEPTION_ERROR;

1861: x_return_status);
1862: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1864: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1865: RAISE OKL_API.G_EXCEPTION_ERROR;
1866: END IF;
1867:
1868: DELETE FROM OKL_REPORT_STREAM_PARAMS
1869: WHERE STREAM_PARAMETER_ID = p_rps_rec.stream_parameter_id;

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

1868: DELETE FROM OKL_REPORT_STREAM_PARAMS
1869: WHERE STREAM_PARAMETER_ID = p_rps_rec.stream_parameter_id;
1870:
1871: x_return_status := l_return_status;
1872: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1873: EXCEPTION
1874: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1875: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1876: (

Line 1874: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1870:
1871: x_return_status := l_return_status;
1872: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1873: EXCEPTION
1874: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1875: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1876: (
1877: l_api_name,
1878: G_PKG_NAME,

Line 1875: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1871: x_return_status := l_return_status;
1872: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1873: EXCEPTION
1874: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1875: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1876: (
1877: l_api_name,
1878: G_PKG_NAME,
1879: 'OKL_API.G_RET_STS_ERROR',

Line 1879: 'OKL_API.G_RET_STS_ERROR',

1875: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1876: (
1877: l_api_name,
1878: G_PKG_NAME,
1879: 'OKL_API.G_RET_STS_ERROR',
1880: x_msg_count,
1881: x_msg_data,
1882: '_PVT'
1883: );

Line 1884: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1880: x_msg_count,
1881: x_msg_data,
1882: '_PVT'
1883: );
1884: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1885: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1886: (
1887: l_api_name,
1888: G_PKG_NAME,

Line 1885: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1881: x_msg_data,
1882: '_PVT'
1883: );
1884: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1885: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1886: (
1887: l_api_name,
1888: G_PKG_NAME,
1889: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1889: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1885: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1886: (
1887: l_api_name,
1888: G_PKG_NAME,
1889: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1890: x_msg_count,
1891: x_msg_data,
1892: '_PVT'
1893: );

Line 1895: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1891: x_msg_data,
1892: '_PVT'
1893: );
1894: WHEN OTHERS THEN
1895: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1896: (
1897: l_api_name,
1898: G_PKG_NAME,
1899: 'OTHERS',

Line 1910: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1906: -- delete_row for:OKL_REPORT_STREAM_PARAMS --
1907: ---------------------------------------------
1908: PROCEDURE delete_row(
1909: p_api_version IN NUMBER,
1910: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1911: x_return_status OUT NOCOPY VARCHAR2,
1912: x_msg_count OUT NOCOPY NUMBER,
1913: x_msg_data OUT NOCOPY VARCHAR2,
1914: p_rps_rec IN rps_rec_type) IS

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

1914: p_rps_rec IN rps_rec_type) IS
1915:
1916: l_api_version CONSTANT NUMBER := 1;
1917: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
1918: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1919: l_rps_rec rps_rec_type := p_rps_rec;
1920: BEGIN
1921: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1922: G_PKG_NAME,

Line 1921: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1917: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
1918: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1919: l_rps_rec rps_rec_type := p_rps_rec;
1920: BEGIN
1921: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1922: G_PKG_NAME,
1923: p_init_msg_list,
1924: l_api_version,
1925: p_api_version,

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

1924: l_api_version,
1925: p_api_version,
1926: '_PVT',
1927: x_return_status);
1928: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1930: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1931: RAISE OKL_API.G_EXCEPTION_ERROR;
1932: END IF;

Line 1929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1925: p_api_version,
1926: '_PVT',
1927: x_return_status);
1928: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1930: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1931: RAISE OKL_API.G_EXCEPTION_ERROR;
1932: END IF;
1933: -----------------------------------------

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

1926: '_PVT',
1927: x_return_status);
1928: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1930: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1931: RAISE OKL_API.G_EXCEPTION_ERROR;
1932: END IF;
1933: -----------------------------------------
1934: -- Move VIEW record to "Child" records --

Line 1931: RAISE OKL_API.G_EXCEPTION_ERROR;

1927: x_return_status);
1928: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1930: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1931: RAISE OKL_API.G_EXCEPTION_ERROR;
1932: END IF;
1933: -----------------------------------------
1934: -- Move VIEW record to "Child" records --
1935: -----------------------------------------

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

1942: x_msg_count,
1943: x_msg_data,
1944: l_rps_rec
1945: );
1946: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1947: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1948: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1949: RAISE OKL_API.G_EXCEPTION_ERROR;
1950: END IF;

Line 1947: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1943: x_msg_data,
1944: l_rps_rec
1945: );
1946: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1947: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1948: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1949: RAISE OKL_API.G_EXCEPTION_ERROR;
1950: END IF;
1951: x_return_status := l_return_status;

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

1944: l_rps_rec
1945: );
1946: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1947: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1948: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1949: RAISE OKL_API.G_EXCEPTION_ERROR;
1950: END IF;
1951: x_return_status := l_return_status;
1952: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1949: RAISE OKL_API.G_EXCEPTION_ERROR;

1945: );
1946: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1947: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1948: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1949: RAISE OKL_API.G_EXCEPTION_ERROR;
1950: END IF;
1951: x_return_status := l_return_status;
1952: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1953: EXCEPTION

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

1948: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1949: RAISE OKL_API.G_EXCEPTION_ERROR;
1950: END IF;
1951: x_return_status := l_return_status;
1952: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1953: EXCEPTION
1954: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1955: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1956: (

Line 1954: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1950: END IF;
1951: x_return_status := l_return_status;
1952: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1953: EXCEPTION
1954: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1955: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1956: (
1957: l_api_name,
1958: G_PKG_NAME,

Line 1955: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1951: x_return_status := l_return_status;
1952: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1953: EXCEPTION
1954: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1955: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1956: (
1957: l_api_name,
1958: G_PKG_NAME,
1959: 'OKL_API.G_RET_STS_ERROR',

Line 1959: 'OKL_API.G_RET_STS_ERROR',

1955: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1956: (
1957: l_api_name,
1958: G_PKG_NAME,
1959: 'OKL_API.G_RET_STS_ERROR',
1960: x_msg_count,
1961: x_msg_data,
1962: '_PVT'
1963: );

Line 1964: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1960: x_msg_count,
1961: x_msg_data,
1962: '_PVT'
1963: );
1964: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1965: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1966: (
1967: l_api_name,
1968: G_PKG_NAME,

Line 1965: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1961: x_msg_data,
1962: '_PVT'
1963: );
1964: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1965: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1966: (
1967: l_api_name,
1968: G_PKG_NAME,
1969: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1969: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1965: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1966: (
1967: l_api_name,
1968: G_PKG_NAME,
1969: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1970: x_msg_count,
1971: x_msg_data,
1972: '_PVT'
1973: );

Line 1975: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1971: x_msg_data,
1972: '_PVT'
1973: );
1974: WHEN OTHERS THEN
1975: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1976: (
1977: l_api_name,
1978: G_PKG_NAME,
1979: 'OTHERS',

Line 1990: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1986: -- PL/SQL TBL delete_row for:OKL_REPORT_STREAM_PARAMS --
1987: --------------------------------------------------------
1988: PROCEDURE delete_row(
1989: p_api_version IN NUMBER,
1990: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1991: x_return_status OUT NOCOPY VARCHAR2,
1992: x_msg_count OUT NOCOPY NUMBER,
1993: x_msg_data OUT NOCOPY VARCHAR2,
1994: p_rps_tbl IN rps_tbl_type,

Line 1995: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

1991: x_return_status OUT NOCOPY VARCHAR2,
1992: x_msg_count OUT NOCOPY NUMBER,
1993: x_msg_data OUT NOCOPY VARCHAR2,
1994: p_rps_tbl IN rps_tbl_type,
1995: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1996:
1997: l_api_version CONSTANT NUMBER := 1;
1998: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
1999: i NUMBER := 0;

Line 2001: OKL_API.init_msg_list(p_init_msg_list);

1997: l_api_version CONSTANT NUMBER := 1;
1998: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
1999: i NUMBER := 0;
2000: BEGIN
2001: OKL_API.init_msg_list(p_init_msg_list);
2002: -- Make sure PL/SQL table has records in it before passing
2003: IF (p_rps_tbl.COUNT > 0) THEN
2004: i := p_rps_tbl.FIRST;
2005: LOOP

Line 2007: l_error_rec OKL_API.ERROR_REC_TYPE;

2003: IF (p_rps_tbl.COUNT > 0) THEN
2004: i := p_rps_tbl.FIRST;
2005: LOOP
2006: DECLARE
2007: l_error_rec OKL_API.ERROR_REC_TYPE;
2008: BEGIN
2009: l_error_rec.api_name := l_api_name;
2010: l_error_rec.api_package := G_PKG_NAME;
2011: l_error_rec.idx := i;

Line 2014: p_init_msg_list => OKL_API.G_FALSE,

2010: l_error_rec.api_package := G_PKG_NAME;
2011: l_error_rec.idx := i;
2012: delete_row (
2013: p_api_version => p_api_version,
2014: p_init_msg_list => OKL_API.G_FALSE,
2015: x_return_status => l_error_rec.error_type,
2016: x_msg_count => l_error_rec.msg_count,
2017: x_msg_data => l_error_rec.msg_data,
2018: p_rps_rec => p_rps_tbl(i));

Line 2019: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

2015: x_return_status => l_error_rec.error_type,
2016: x_msg_count => l_error_rec.msg_count,
2017: x_msg_data => l_error_rec.msg_data,
2018: p_rps_rec => p_rps_tbl(i));
2019: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2020: l_error_rec.sqlcode := SQLCODE;
2021: load_error_tbl(l_error_rec, px_error_tbl);
2022: ELSE
2023: x_msg_count := l_error_rec.msg_count;

Line 2027: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2023: x_msg_count := l_error_rec.msg_count;
2024: x_msg_data := l_error_rec.msg_data;
2025: END IF;
2026: EXCEPTION
2027: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2028: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2029: l_error_rec.sqlcode := SQLCODE;
2030: load_error_tbl(l_error_rec, px_error_tbl);
2031: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2028: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;

2024: x_msg_data := l_error_rec.msg_data;
2025: END IF;
2026: EXCEPTION
2027: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2028: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2029: l_error_rec.sqlcode := SQLCODE;
2030: load_error_tbl(l_error_rec, px_error_tbl);
2031: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2032: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2031: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2027: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2028: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2029: l_error_rec.sqlcode := SQLCODE;
2030: load_error_tbl(l_error_rec, px_error_tbl);
2031: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2032: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2033: l_error_rec.sqlcode := SQLCODE;
2034: load_error_tbl(l_error_rec, px_error_tbl);
2035: WHEN OTHERS THEN

Line 2032: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

2028: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2029: l_error_rec.sqlcode := SQLCODE;
2030: load_error_tbl(l_error_rec, px_error_tbl);
2031: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2032: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2033: l_error_rec.sqlcode := SQLCODE;
2034: load_error_tbl(l_error_rec, px_error_tbl);
2035: WHEN OTHERS THEN
2036: l_error_rec.error_type := 'OTHERS';

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

2043: END IF;
2044: -- Loop through the error_tbl to find the error with the highest severity
2045: -- and return it.
2046: x_return_status := find_highest_exception(px_error_tbl);
2047: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2048: EXCEPTION
2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2050: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2051: (

Line 2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2045: -- and return it.
2046: x_return_status := find_highest_exception(px_error_tbl);
2047: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2048: EXCEPTION
2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2050: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2051: (
2052: l_api_name,
2053: G_PKG_NAME,

Line 2050: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2046: x_return_status := find_highest_exception(px_error_tbl);
2047: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2048: EXCEPTION
2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2050: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2051: (
2052: l_api_name,
2053: G_PKG_NAME,
2054: 'OKL_API.G_RET_STS_ERROR',

Line 2054: 'OKL_API.G_RET_STS_ERROR',

2050: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2051: (
2052: l_api_name,
2053: G_PKG_NAME,
2054: 'OKL_API.G_RET_STS_ERROR',
2055: x_msg_count,
2056: x_msg_data,
2057: '_PVT'
2058: );

Line 2059: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2055: x_msg_count,
2056: x_msg_data,
2057: '_PVT'
2058: );
2059: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2060: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2061: (
2062: l_api_name,
2063: G_PKG_NAME,

Line 2060: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2056: x_msg_data,
2057: '_PVT'
2058: );
2059: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2060: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2061: (
2062: l_api_name,
2063: G_PKG_NAME,
2064: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2064: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2060: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2061: (
2062: l_api_name,
2063: G_PKG_NAME,
2064: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2065: x_msg_count,
2066: x_msg_data,
2067: '_PVT'
2068: );

Line 2070: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2066: x_msg_data,
2067: '_PVT'
2068: );
2069: WHEN OTHERS THEN
2070: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2071: (
2072: l_api_name,
2073: G_PKG_NAME,
2074: 'OTHERS',

Line 2086: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2082: -- PL/SQL TBL delete_row for:OKL_REPORT_STREAM_PARAMS --
2083: --------------------------------------------------------
2084: PROCEDURE delete_row(
2085: p_api_version IN NUMBER,
2086: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2087: x_return_status OUT NOCOPY VARCHAR2,
2088: x_msg_count OUT NOCOPY NUMBER,
2089: x_msg_data OUT NOCOPY VARCHAR2,
2090: p_rps_tbl IN rps_tbl_type) IS

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

2090: p_rps_tbl IN rps_tbl_type) IS
2091:
2092: l_api_version CONSTANT NUMBER := 1;
2093: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2094: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2095: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2096: BEGIN
2097: OKL_API.init_msg_list(p_init_msg_list);
2098: -- Make sure PL/SQL table has records in it before passing

Line 2095: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2091:
2092: l_api_version CONSTANT NUMBER := 1;
2093: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2094: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2095: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2096: BEGIN
2097: OKL_API.init_msg_list(p_init_msg_list);
2098: -- Make sure PL/SQL table has records in it before passing
2099: IF (p_rps_tbl.COUNT > 0) THEN

Line 2097: OKL_API.init_msg_list(p_init_msg_list);

2093: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2094: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2095: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2096: BEGIN
2097: OKL_API.init_msg_list(p_init_msg_list);
2098: -- Make sure PL/SQL table has records in it before passing
2099: IF (p_rps_tbl.COUNT > 0) THEN
2100: delete_row (
2101: p_api_version => p_api_version,

Line 2102: p_init_msg_list => OKL_API.G_FALSE,

2098: -- Make sure PL/SQL table has records in it before passing
2099: IF (p_rps_tbl.COUNT > 0) THEN
2100: delete_row (
2101: p_api_version => p_api_version,
2102: p_init_msg_list => OKL_API.G_FALSE,
2103: x_return_status => x_return_status,
2104: x_msg_count => x_msg_count,
2105: x_msg_data => x_msg_data,
2106: p_rps_tbl => p_rps_tbl,

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

2105: x_msg_data => x_msg_data,
2106: p_rps_tbl => p_rps_tbl,
2107: px_error_tbl => l_error_tbl);
2108: END IF;
2109: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2110: EXCEPTION
2111: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2112: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2113: (

Line 2111: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2107: px_error_tbl => l_error_tbl);
2108: END IF;
2109: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2110: EXCEPTION
2111: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2112: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2113: (
2114: l_api_name,
2115: G_PKG_NAME,

Line 2112: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2108: END IF;
2109: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2110: EXCEPTION
2111: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2112: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2113: (
2114: l_api_name,
2115: G_PKG_NAME,
2116: 'OKL_API.G_RET_STS_ERROR',

Line 2116: 'OKL_API.G_RET_STS_ERROR',

2112: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2113: (
2114: l_api_name,
2115: G_PKG_NAME,
2116: 'OKL_API.G_RET_STS_ERROR',
2117: x_msg_count,
2118: x_msg_data,
2119: '_PVT'
2120: );

Line 2121: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2117: x_msg_count,
2118: x_msg_data,
2119: '_PVT'
2120: );
2121: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2123: (
2124: l_api_name,
2125: G_PKG_NAME,

Line 2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2118: x_msg_data,
2119: '_PVT'
2120: );
2121: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2123: (
2124: l_api_name,
2125: G_PKG_NAME,
2126: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2126: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2123: (
2124: l_api_name,
2125: G_PKG_NAME,
2126: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2127: x_msg_count,
2128: x_msg_data,
2129: '_PVT'
2130: );

Line 2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2128: x_msg_data,
2129: '_PVT'
2130: );
2131: WHEN OTHERS THEN
2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2133: (
2134: l_api_name,
2135: G_PKG_NAME,
2136: 'OTHERS',