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_AR_EXTENSION_PVT dependencies on OKC_API

Line 18: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

14: -- End of comments
15: ----------------------------------------------------------------------------------
16: PROCEDURE create_rxh_extension(
17: p_api_version IN NUMBER
18: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
19: ,x_return_status OUT NOCOPY VARCHAR2
20: ,x_msg_count OUT NOCOPY NUMBER
21: ,x_msg_data OUT NOCOPY VARCHAR2
22: ,p_rxhv_rec IN rxhv_rec_type

Line 30: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

26: )
27: IS
28: i NUMBER;
29: l_rxhv_rec rxhv_rec_type;
30: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
31: l_rxlv_tbl rxlv_tbl_type := p_rxlv_tbl;
32: BEGIN
33: -- Populate TRX EXTENSION
34: create_rxh_extension(

Line 42: IF x_return_status = OKC_API.G_RET_STS_SUCCESS

38: ,x_msg_count => x_msg_count
39: ,x_msg_data => x_msg_data
40: ,p_rxhv_rec => p_rxhv_rec
41: ,x_rxhv_rec => x_rxhv_rec);
42: IF x_return_status = OKC_API.G_RET_STS_SUCCESS
43: THEN
44: -- populate the foreign key for the detail
45: IF (l_rxlv_tbl.COUNT > 0)
46: THEN

Line 70: OKC_API.SET_MESSAGE(

66: THEN
67: NULL;
68: WHEN OTHERS
69: THEN
70: OKC_API.SET_MESSAGE(
71: p_app_name => g_app_name
72: ,p_msg_name => g_unexpected_error
73: ,p_token1 => g_sqlcode_token
74: ,p_token1_value => sqlcode

Line 77: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

73: ,p_token1 => g_sqlcode_token
74: ,p_token1_value => sqlcode
75: ,p_token2 => g_sqlerrm_token
76: ,p_token2_value => sqlerrm);
77: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
78: END create_rxh_extension;
79:
80: ----------------------------------------------------------------------------------
81: -- Start of comments

Line 93: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

89: -- End of comments
90: ----------------------------------------------------------------------------------
91: PROCEDURE create_rxh_extension(
92: p_api_version IN NUMBER
93: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
94: ,x_return_status OUT NOCOPY VARCHAR2
95: ,x_msg_count OUT NOCOPY NUMBER
96: ,x_msg_data OUT NOCOPY VARCHAR2
97: ,p_rxhv_rec IN rxhv_rec_type

Line 99: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

95: ,x_msg_count OUT NOCOPY NUMBER
96: ,x_msg_data OUT NOCOPY VARCHAR2
97: ,p_rxhv_rec IN rxhv_rec_type
98: ,x_rxhv_rec OUT NOCOPY rxhv_rec_type) IS
99: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
100: BEGIN
101: okl_rxh_pvt.insert_row(
102: p_api_version => p_api_version
103: ,p_init_msg_list => p_init_msg_list

Line 110: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

106: ,x_msg_data => x_msg_data
107: ,p_rxhv_rec => p_rxhv_rec
108: ,x_rxhv_rec => x_rxhv_rec);
109:
110: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
111: THEN
112: RAISE G_EXCEPTION_HALT_VALIDATION;
113: ELSE
114: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

Line 114: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

110: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
111: THEN
112: RAISE G_EXCEPTION_HALT_VALIDATION;
113: ELSE
114: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
115: THEN
116: l_return_status := x_return_status;
117: END IF;
118: END IF;

Line 126: OKC_API.SET_MESSAGE(p_app_name => g_app_name

122: THEN
123: NULL;
124: WHEN OTHERS
125: THEN
126: OKC_API.SET_MESSAGE(p_app_name => g_app_name
127: ,p_msg_name => g_unexpected_error
128: ,p_token1 => g_sqlcode_token
129: ,p_token1_value => sqlcode
130: ,p_token2 => g_sqlerrm_token

Line 132: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

128: ,p_token1 => g_sqlcode_token
129: ,p_token1_value => sqlcode
130: ,p_token2 => g_sqlerrm_token
131: ,p_token2_value => sqlerrm);
132: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
133: END create_rxh_extension;
134:
135: ----------------------------------------------------------------------------------
136: -- Start of comments

Line 149: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

145: -- End of comments
146: ----------------------------------------------------------------------------------
147: PROCEDURE create_rxh_extension(
148: p_api_version IN NUMBER
149: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
150: ,x_return_status OUT NOCOPY VARCHAR2
151: ,x_msg_count OUT NOCOPY NUMBER
152: ,x_msg_data OUT NOCOPY VARCHAR2
153: ,p_rxhv_tbl IN rxhv_tbl_type

Line 155: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

151: ,x_msg_count OUT NOCOPY NUMBER
152: ,x_msg_data OUT NOCOPY VARCHAR2
153: ,p_rxhv_tbl IN rxhv_tbl_type
154: ,x_rxhv_tbl OUT NOCOPY rxhv_tbl_type) IS
155: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
156: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
157: i NUMBER := 0;
158: BEGIN
159: Okc_Api.init_msg_list(p_init_msg_list);

Line 156: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

152: ,x_msg_data OUT NOCOPY VARCHAR2
153: ,p_rxhv_tbl IN rxhv_tbl_type
154: ,x_rxhv_tbl OUT NOCOPY rxhv_tbl_type) IS
155: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
156: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
157: i NUMBER := 0;
158: BEGIN
159: Okc_Api.init_msg_list(p_init_msg_list);
160: -- Make sure PL/SQL table has records in it before passing

Line 159: Okc_Api.init_msg_list(p_init_msg_list);

155: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
156: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
157: i NUMBER := 0;
158: BEGIN
159: Okc_Api.init_msg_list(p_init_msg_list);
160: -- Make sure PL/SQL table has records in it before passing
161: IF (p_rxhv_tbl.COUNT > 0)
162: THEN
163: i := p_rxhv_tbl.FIRST;

Line 167: ,p_init_msg_list => Okc_Api.G_FALSE

163: i := p_rxhv_tbl.FIRST;
164: LOOP
165: create_rxh_extension(
166: p_api_version => p_api_version
167: ,p_init_msg_list => Okc_Api.G_FALSE
168: ,x_return_status => x_return_status
169: ,x_msg_count => x_msg_count
170: ,x_msg_data => x_msg_data
171: ,p_rxhv_rec => p_rxhv_tbl(i)

Line 174: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS

170: ,x_msg_data => x_msg_data
171: ,p_rxhv_rec => p_rxhv_tbl(i)
172: ,x_rxhv_rec => x_rxhv_tbl(i));
173: -- store the highest degree of error
174: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
175: THEN
176: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
177: THEN
178: l_overall_status := x_return_status;

Line 176: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR

172: ,x_rxhv_rec => x_rxhv_tbl(i));
173: -- store the highest degree of error
174: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
175: THEN
176: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
177: THEN
178: l_overall_status := x_return_status;
179: END IF;
180: END IF;

Line 192: OKC_API.SET_MESSAGE(

188: THEN
189: NULL;
190: WHEN OTHERS
191: THEN
192: OKC_API.SET_MESSAGE(
193: p_app_name => g_app_name
194: ,p_msg_name => g_unexpected_error
195: ,p_token1 => g_sqlcode_token
196: ,p_token1_value => sqlcode

Line 199: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

195: ,p_token1 => g_sqlcode_token
196: ,p_token1_value => sqlcode
197: ,p_token2 => g_sqlerrm_token
198: ,p_token2_value => sqlerrm);
199: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
200: END create_rxh_extension;
201:
202: ----------------------------------------------------------------------------------
203: -- Start of comments

Line 216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

212: -- End of comments
213: ----------------------------------------------------------------------------------
214: PROCEDURE update_rxh_extension(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_rxhv_rec IN rxhv_rec_type,

Line 224: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

220: p_rxhv_rec IN rxhv_rec_type,
221: p_rxlv_tbl IN rxlv_tbl_type,
222: x_rxhv_rec OUT NOCOPY rxhv_rec_type,
223: x_rxlv_tbl OUT NOCOPY rxlv_tbl_type) IS
224: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
225: BEGIN
226: -- Update the master
227: update_rxh_extension(
228: p_api_version => p_api_version

Line 236: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS)

232: ,x_msg_data => x_msg_data
233: ,p_rxhv_rec => p_rxhv_rec
234: ,x_rxhv_rec => x_rxhv_rec);
235:
236: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS)
237: THEN
238: -- Update the detail
239: update_rxl_extension(
240: p_api_version => p_api_version

Line 254: OKC_API.SET_MESSAGE(p_app_name => g_app_name

250: THEN
251: NULL;
252: WHEN OTHERS
253: THEN
254: OKC_API.SET_MESSAGE(p_app_name => g_app_name
255: ,p_msg_name => g_unexpected_error
256: ,p_token1 => g_sqlcode_token
257: ,p_token1_value => sqlcode
258: ,p_token2 => g_sqlerrm_token

Line 260: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

256: ,p_token1 => g_sqlcode_token
257: ,p_token1_value => sqlcode
258: ,p_token2 => g_sqlerrm_token
259: ,p_token2_value => sqlerrm);
260: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
261: END update_rxh_extension;
262:
263: ----------------------------------------------------------------------------------
264: -- Start of comments

Line 276: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

272: -- End of comments
273: ----------------------------------------------------------------------------------
274: PROCEDURE validate_rxh_extension(
275: p_api_version IN NUMBER
276: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
277: ,x_return_status OUT NOCOPY VARCHAR2
278: ,x_msg_count OUT NOCOPY NUMBER
279: ,x_msg_data OUT NOCOPY VARCHAR2
280: ,p_rxhv_rec IN rxhv_rec_type

Line 283: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

279: ,x_msg_data OUT NOCOPY VARCHAR2
280: ,p_rxhv_rec IN rxhv_rec_type
281: ,p_rxlv_tbl IN rxlv_tbl_type) IS
282:
283: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
284: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
285: BEGIN
286: -- Validate the master
287: validate_rxh_extension(

Line 284: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

280: ,p_rxhv_rec IN rxhv_rec_type
281: ,p_rxlv_tbl IN rxlv_tbl_type) IS
282:
283: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
284: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
285: BEGIN
286: -- Validate the master
287: validate_rxh_extension(
288: p_api_version => p_api_version

Line 295: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS

291: ,x_msg_count => x_msg_count
292: ,x_msg_data => x_msg_data
293: ,p_rxhv_rec => p_rxhv_rec);
294:
295: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
296: THEN
297: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
298: THEN
299: l_overall_status := x_return_status;

Line 297: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR

293: ,p_rxhv_rec => p_rxhv_rec);
294:
295: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
296: THEN
297: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
298: THEN
299: l_overall_status := x_return_status;
300: END IF;
301: END IF;

Line 310: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS

306: ,x_return_status => x_return_status
307: ,x_msg_count => x_msg_count
308: ,x_msg_data => x_msg_data
309: ,p_rxlv_tbl => p_rxlv_tbl);
310: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
311: THEN
312: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
313: THEN
314: l_overall_status := x_return_status;

Line 312: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR

308: ,x_msg_data => x_msg_data
309: ,p_rxlv_tbl => p_rxlv_tbl);
310: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
311: THEN
312: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
313: THEN
314: l_overall_status := x_return_status;
315: END IF;
316: END IF;

Line 322: OKC_API.SET_MESSAGE(p_app_name => g_app_name

318: EXCEPTION
319: WHEN G_EXCEPTION_HALT_VALIDATION THEN
320: NULL;
321: WHEN OTHERS THEN
322: OKC_API.SET_MESSAGE(p_app_name => g_app_name
323: ,p_msg_name => g_unexpected_error
324: ,p_token1 => g_sqlcode_token
325: ,p_token1_value => sqlcode
326: ,p_token2 => g_sqlerrm_token

Line 328: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

324: ,p_token1 => g_sqlcode_token
325: ,p_token1_value => sqlcode
326: ,p_token2 => g_sqlerrm_token
327: ,p_token2_value => sqlerrm);
328: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
329:
330: END validate_rxh_extension;
331:
332: ----------------------------------------------------------------------------------

Line 345: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

341: -- End of comments
342: ----------------------------------------------------------------------------------
343: PROCEDURE lock_rxh_extension(
344: p_api_version IN NUMBER
345: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
346: ,x_return_status OUT NOCOPY VARCHAR2
347: ,x_msg_count OUT NOCOPY NUMBER
348: ,x_msg_data OUT NOCOPY VARCHAR2
349: ,p_rxhv_rec IN rxhv_rec_type) IS

Line 350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

346: ,x_return_status OUT NOCOPY VARCHAR2
347: ,x_msg_count OUT NOCOPY NUMBER
348: ,x_msg_data OUT NOCOPY VARCHAR2
349: ,p_rxhv_rec IN rxhv_rec_type) IS
350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
351: BEGIN
352: okl_rxh_pvt.lock_row(
353: p_api_version => p_api_version
354: ,p_init_msg_list => p_init_msg_list

Line 360: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

356: ,x_msg_count => x_msg_count
357: ,x_msg_data => x_msg_data
358: ,p_rxhv_rec => p_rxhv_rec);
359:
360: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
361: THEN
362: RAISE G_EXCEPTION_HALT_VALIDATION;
363: ELSE
364: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

Line 364: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

360: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
361: THEN
362: RAISE G_EXCEPTION_HALT_VALIDATION;
363: ELSE
364: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
365: THEN
366: l_return_status := x_return_status;
367: END IF;
368: END IF;

Line 373: OKC_API.SET_MESSAGE(p_app_name => g_app_name

369: EXCEPTION
370: WHEN G_EXCEPTION_HALT_VALIDATION THEN
371: NULL;
372: WHEN OTHERS THEN
373: OKC_API.SET_MESSAGE(p_app_name => g_app_name
374: ,p_msg_name => g_unexpected_error
375: ,p_token1 => g_sqlcode_token
376: ,p_token1_value => sqlcode
377: ,p_token2 => g_sqlerrm_token

Line 379: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

375: ,p_token1 => g_sqlcode_token
376: ,p_token1_value => sqlcode
377: ,p_token2 => g_sqlerrm_token
378: ,p_token2_value => sqlerrm);
379: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
380: END lock_rxh_extension;
381:
382: ----------------------------------------------------------------------------------
383: -- Start of comments

Line 395: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

391: -- End of comments
392: ----------------------------------------------------------------------------------
393: PROCEDURE lock_rxh_extension(
394: p_api_version IN NUMBER
395: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
396: ,x_return_status OUT NOCOPY VARCHAR2
397: ,x_msg_count OUT NOCOPY NUMBER
398: ,x_msg_data OUT NOCOPY VARCHAR2
399: ,p_rxhv_tbl IN rxhv_tbl_type) IS

Line 400: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

396: ,x_return_status OUT NOCOPY VARCHAR2
397: ,x_msg_count OUT NOCOPY NUMBER
398: ,x_msg_data OUT NOCOPY VARCHAR2
399: ,p_rxhv_tbl IN rxhv_tbl_type) IS
400: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
401: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
402: i NUMBER := 0;
403: BEGIN
404: Okc_Api.init_msg_list(p_init_msg_list);

Line 401: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

397: ,x_msg_count OUT NOCOPY NUMBER
398: ,x_msg_data OUT NOCOPY VARCHAR2
399: ,p_rxhv_tbl IN rxhv_tbl_type) IS
400: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
401: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
402: i NUMBER := 0;
403: BEGIN
404: Okc_Api.init_msg_list(p_init_msg_list);
405: -- Make sure PL/SQL table has records in it before passing

Line 404: Okc_Api.init_msg_list(p_init_msg_list);

400: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
401: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
402: i NUMBER := 0;
403: BEGIN
404: Okc_Api.init_msg_list(p_init_msg_list);
405: -- Make sure PL/SQL table has records in it before passing
406: IF (p_rxhv_tbl.COUNT > 0)
407: THEN
408: i := p_rxhv_tbl.FIRST;

Line 412: ,p_init_msg_list => Okc_Api.G_FALSE

408: i := p_rxhv_tbl.FIRST;
409: LOOP
410: lock_rxh_extension(
411: p_api_version => p_api_version
412: ,p_init_msg_list => Okc_Api.G_FALSE
413: ,x_return_status => x_return_status
414: ,x_msg_count => x_msg_count
415: ,x_msg_data => x_msg_data
416: ,p_rxhv_rec => p_rxhv_tbl(i));

Line 418: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS

414: ,x_msg_count => x_msg_count
415: ,x_msg_data => x_msg_data
416: ,p_rxhv_rec => p_rxhv_tbl(i));
417: -- store the highest degree of error
418: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
419: THEN
420: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
421: THEN
422: l_overall_status := x_return_status;

Line 420: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR

416: ,p_rxhv_rec => p_rxhv_tbl(i));
417: -- store the highest degree of error
418: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
419: THEN
420: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
421: THEN
422: l_overall_status := x_return_status;
423: END IF;
424: END IF;

Line 436: OKC_API.SET_MESSAGE(

432: THEN
433: NULL;
434: WHEN OTHERS
435: THEN
436: OKC_API.SET_MESSAGE(
437: p_app_name => g_app_name
438: ,p_msg_name => g_unexpected_error
439: ,p_token1 => g_sqlcode_token
440: ,p_token1_value => sqlcode

Line 443: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

439: ,p_token1 => g_sqlcode_token
440: ,p_token1_value => sqlcode
441: ,p_token2 => g_sqlerrm_token
442: ,p_token2_value => sqlerrm);
443: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
444: END lock_rxh_extension;
445:
446: ----------------------------------------------------------------------------------
447: -- Start of comments

Line 459: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

455: -- End of comments
456: ----------------------------------------------------------------------------------
457: PROCEDURE update_rxh_extension(
458: p_api_version IN NUMBER
459: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
460: ,x_return_status OUT NOCOPY VARCHAR2
461: ,x_msg_count OUT NOCOPY NUMBER
462: ,x_msg_data OUT NOCOPY VARCHAR2
463: ,p_rxhv_rec IN rxhv_rec_type

Line 465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

461: ,x_msg_count OUT NOCOPY NUMBER
462: ,x_msg_data OUT NOCOPY VARCHAR2
463: ,p_rxhv_rec IN rxhv_rec_type
464: ,x_rxhv_rec OUT NOCOPY rxhv_rec_type) IS
465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
466: BEGIN
467: okl_rxh_pvt.update_row(
468: p_api_version => p_api_version
469: ,p_init_msg_list => p_init_msg_list

Line 475: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

471: ,x_msg_count => x_msg_count
472: ,x_msg_data => x_msg_data
473: ,p_rxhv_rec => p_rxhv_rec
474: ,x_rxhv_rec => x_rxhv_rec);
475: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
476: THEN
477: RAISE G_EXCEPTION_HALT_VALIDATION;
478: ELSE
479: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

Line 479: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

475: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
476: THEN
477: RAISE G_EXCEPTION_HALT_VALIDATION;
478: ELSE
479: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
480: THEN
481: l_return_status := x_return_status;
482: END IF;
483: END IF;

Line 488: OKC_API.SET_MESSAGE(p_app_name => g_app_name

484: EXCEPTION
485: WHEN G_EXCEPTION_HALT_VALIDATION THEN
486: NULL;
487: WHEN OTHERS THEN
488: OKC_API.SET_MESSAGE(p_app_name => g_app_name
489: ,p_msg_name => g_unexpected_error
490: ,p_token1 => g_sqlcode_token
491: ,p_token1_value => sqlcode
492: ,p_token2 => g_sqlerrm_token

Line 494: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

490: ,p_token1 => g_sqlcode_token
491: ,p_token1_value => sqlcode
492: ,p_token2 => g_sqlerrm_token
493: ,p_token2_value => sqlerrm);
494: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
495: END update_rxh_extension;
496:
497: ----------------------------------------------------------------------------------
498: -- Start of comments

Line 510: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

506: -- End of comments
507: ----------------------------------------------------------------------------------
508: PROCEDURE update_rxh_extension(
509: p_api_version IN NUMBER
510: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
511: ,x_return_status OUT NOCOPY VARCHAR2
512: ,x_msg_count OUT NOCOPY NUMBER
513: ,x_msg_data OUT NOCOPY VARCHAR2
514: ,p_rxhv_tbl IN rxhv_tbl_type

Line 516: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

512: ,x_msg_count OUT NOCOPY NUMBER
513: ,x_msg_data OUT NOCOPY VARCHAR2
514: ,p_rxhv_tbl IN rxhv_tbl_type
515: ,x_rxhv_tbl OUT NOCOPY rxhv_tbl_type) IS
516: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
517: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
518: i NUMBER := 0;
519: BEGIN
520: Okc_Api.init_msg_list(p_init_msg_list);

Line 517: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

513: ,x_msg_data OUT NOCOPY VARCHAR2
514: ,p_rxhv_tbl IN rxhv_tbl_type
515: ,x_rxhv_tbl OUT NOCOPY rxhv_tbl_type) IS
516: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
517: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
518: i NUMBER := 0;
519: BEGIN
520: Okc_Api.init_msg_list(p_init_msg_list);
521: -- Make sure PL/SQL table has records in it before passing

Line 520: Okc_Api.init_msg_list(p_init_msg_list);

516: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
517: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
518: i NUMBER := 0;
519: BEGIN
520: Okc_Api.init_msg_list(p_init_msg_list);
521: -- Make sure PL/SQL table has records in it before passing
522: IF (p_rxhv_tbl.COUNT > 0) THEN
523: i := p_rxhv_tbl.FIRST;
524: LOOP

Line 527: p_init_msg_list => Okc_Api.G_FALSE,

523: i := p_rxhv_tbl.FIRST;
524: LOOP
525: update_rxh_extension(
526: p_api_version => p_api_version,
527: p_init_msg_list => Okc_Api.G_FALSE,
528: x_return_status => x_return_status,
529: x_msg_count => x_msg_count,
530: x_msg_data => x_msg_data,
531: p_rxhv_rec => p_rxhv_tbl(i),

Line 534: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS

530: x_msg_data => x_msg_data,
531: p_rxhv_rec => p_rxhv_tbl(i),
532: x_rxhv_rec => x_rxhv_tbl(i));
533: -- store the highest degree of error
534: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
535: THEN
536: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
537: THEN
538: l_overall_status := x_return_status;

Line 536: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR

532: x_rxhv_rec => x_rxhv_tbl(i));
533: -- store the highest degree of error
534: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
535: THEN
536: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
537: THEN
538: l_overall_status := x_return_status;
539: END IF;
540: END IF;

Line 552: OKC_API.SET_MESSAGE(p_app_name => g_app_name

548: THEN
549: NULL;
550: WHEN OTHERS
551: THEN
552: OKC_API.SET_MESSAGE(p_app_name => g_app_name
553: ,p_msg_name => g_unexpected_error
554: ,p_token1 => g_sqlcode_token
555: ,p_token1_value => sqlcode
556: ,p_token2 => g_sqlerrm_token

Line 558: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

554: ,p_token1 => g_sqlcode_token
555: ,p_token1_value => sqlcode
556: ,p_token2 => g_sqlerrm_token
557: ,p_token2_value => sqlerrm);
558: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
559: END update_rxh_extension;
560:
561: ----------------------------------------------------------------------------------
562: -- Start of comments

Line 574: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

570: -- End of comments
571: ----------------------------------------------------------------------------------
572: PROCEDURE delete_rxh_extension(
573: p_api_version IN NUMBER
574: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
575: ,x_return_status OUT NOCOPY VARCHAR2
576: ,x_msg_count OUT NOCOPY NUMBER
577: ,x_msg_data OUT NOCOPY VARCHAR2
578: ,p_rxhv_rec IN rxhv_rec_type) IS

Line 580: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

576: ,x_msg_count OUT NOCOPY NUMBER
577: ,x_msg_data OUT NOCOPY VARCHAR2
578: ,p_rxhv_rec IN rxhv_rec_type) IS
579: i NUMBER :=0;
580: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
581: l_rxlv_tbl rxlv_tbl_type;
582:
583: CURSOR rxl_csr IS
584: SELECT rxl.line_extension_id

Line 600: IF x_return_status = OKC_API.G_RET_STS_SUCCESS

596: ,x_return_status => x_return_status
597: ,x_msg_count => x_msg_count
598: ,x_msg_data => x_msg_data
599: ,p_rxlv_tbl => l_rxlv_tbl);
600: IF x_return_status = OKC_API.G_RET_STS_SUCCESS
601: THEN
602: okl_rxh_pvt.delete_row(
603: p_api_version => p_api_version
604: ,p_init_msg_list => p_init_msg_list

Line 616: OKC_API.SET_MESSAGE(

612: THEN
613: NULL;
614: WHEN OTHERS
615: THEN
616: OKC_API.SET_MESSAGE(
617: p_app_name => g_app_name
618: ,p_msg_name => g_unexpected_error
619: ,p_token1 => g_sqlcode_token
620: ,p_token1_value => sqlcode

Line 623: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

619: ,p_token1 => g_sqlcode_token
620: ,p_token1_value => sqlcode
621: ,p_token2 => g_sqlerrm_token
622: ,p_token2_value => sqlerrm);
623: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
624: END delete_rxh_extension;
625:
626: ----------------------------------------------------------------------------------
627: -- Start of comments

Line 639: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

635: -- End of comments
636: ----------------------------------------------------------------------------------
637: PROCEDURE delete_rxh_extension(
638: p_api_version IN NUMBER
639: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
640: ,x_return_status OUT NOCOPY VARCHAR2
641: ,x_msg_count OUT NOCOPY NUMBER
642: ,x_msg_data OUT NOCOPY VARCHAR2
643: ,p_rxhv_tbl IN rxhv_tbl_type) IS

Line 645: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

641: ,x_msg_count OUT NOCOPY NUMBER
642: ,x_msg_data OUT NOCOPY VARCHAR2
643: ,p_rxhv_tbl IN rxhv_tbl_type) IS
644: i NUMBER :=0;
645: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
646: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
647:
648: BEGIN
649: --Initialize the return status

Line 646: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

642: ,x_msg_data OUT NOCOPY VARCHAR2
643: ,p_rxhv_tbl IN rxhv_tbl_type) IS
644: i NUMBER :=0;
645: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
646: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
647:
648: BEGIN
649: --Initialize the return status
650: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 650: x_return_status := OKC_API.G_RET_STS_SUCCESS;

646: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
647:
648: BEGIN
649: --Initialize the return status
650: x_return_status := OKC_API.G_RET_STS_SUCCESS;
651: IF (p_rxhv_tbl.COUNT > 0)
652: THEN
653: i := p_rxhv_tbl.FIRST;
654: LOOP

Line 662: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS

658: ,x_return_status => x_return_status
659: ,x_msg_count => x_msg_count
660: ,x_msg_data => x_msg_data
661: ,p_rxhv_rec => p_rxhv_tbl(i));
662: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
663: THEN
664: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
665: THEN
666: l_overall_status := x_return_status;

Line 664: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR

660: ,x_msg_data => x_msg_data
661: ,p_rxhv_rec => p_rxhv_tbl(i));
662: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
663: THEN
664: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
665: THEN
666: l_overall_status := x_return_status;
667: END IF;
668: END IF;

Line 680: OKC_API.SET_MESSAGE(

676: THEN
677: NULL;
678: WHEN OTHERS
679: THEN
680: OKC_API.SET_MESSAGE(
681: p_app_name => g_app_name
682: ,p_msg_name => g_unexpected_error
683: ,p_token1 => g_sqlcode_token
684: ,p_token1_value => sqlcode

Line 687: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

683: ,p_token1 => g_sqlcode_token
684: ,p_token1_value => sqlcode
685: ,p_token2 => g_sqlerrm_token
686: ,p_token2_value => sqlerrm);
687: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
688: END delete_rxh_extension;
689:
690: ----------------------------------------------------------------------------------
691: -- Start of comments

Line 703: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

699: -- End of comments
700: ----------------------------------------------------------------------------------
701: PROCEDURE validate_rxh_extension(
702: p_api_version IN NUMBER
703: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
704: ,x_return_status OUT NOCOPY VARCHAR2
705: ,x_msg_count OUT NOCOPY NUMBER
706: ,x_msg_data OUT NOCOPY VARCHAR2
707: ,p_rxhv_rec IN rxhv_rec_type) IS

Line 708: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

704: ,x_return_status OUT NOCOPY VARCHAR2
705: ,x_msg_count OUT NOCOPY NUMBER
706: ,x_msg_data OUT NOCOPY VARCHAR2
707: ,p_rxhv_rec IN rxhv_rec_type) IS
708: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
709: BEGIN
710: okl_rxh_pvt.validate_row(
711: p_api_version => p_api_version
712: ,p_init_msg_list => p_init_msg_list

Line 717: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

713: ,x_return_status => x_return_status
714: ,x_msg_count => x_msg_count
715: ,x_msg_data => x_msg_data
716: ,p_rxhv_rec => p_rxhv_rec);
717: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
718: THEN
719: RAISE G_EXCEPTION_HALT_VALIDATION;
720: ELSE
721: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

Line 721: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

717: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
718: THEN
719: RAISE G_EXCEPTION_HALT_VALIDATION;
720: ELSE
721: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
722: THEN
723: l_return_status := x_return_status;
724: END IF;
725: END IF;

Line 732: OKC_API.SET_MESSAGE(

728: THEN
729: NULL;
730: WHEN OTHERS
731: THEN
732: OKC_API.SET_MESSAGE(
733: p_app_name => g_app_name
734: ,p_msg_name => g_unexpected_error
735: ,p_token1 => g_sqlcode_token
736: ,p_token1_value => sqlcode

Line 739: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

735: ,p_token1 => g_sqlcode_token
736: ,p_token1_value => sqlcode
737: ,p_token2 => g_sqlerrm_token
738: ,p_token2_value => sqlerrm);
739: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
740: END validate_rxh_extension;
741:
742: ----------------------------------------------------------------------------------
743: -- Start of comments

Line 755: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

751: -- End of comments
752: ----------------------------------------------------------------------------------
753: PROCEDURE validate_rxh_extension(
754: p_api_version IN NUMBER,
755: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
756: x_return_status OUT NOCOPY VARCHAR2,
757: x_msg_count OUT NOCOPY NUMBER,
758: x_msg_data OUT NOCOPY VARCHAR2,
759: p_rxhv_tbl IN rxhv_tbl_type)

Line 761: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

757: x_msg_count OUT NOCOPY NUMBER,
758: x_msg_data OUT NOCOPY VARCHAR2,
759: p_rxhv_tbl IN rxhv_tbl_type)
760: IS
761: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
762: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
763: i NUMBER := 0;
764: BEGIN
765: Okc_Api.init_msg_list(p_init_msg_list);

Line 762: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

758: x_msg_data OUT NOCOPY VARCHAR2,
759: p_rxhv_tbl IN rxhv_tbl_type)
760: IS
761: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
762: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
763: i NUMBER := 0;
764: BEGIN
765: Okc_Api.init_msg_list(p_init_msg_list);
766: -- Make sure PL/SQL table has records in it before passing

Line 765: Okc_Api.init_msg_list(p_init_msg_list);

761: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
762: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
763: i NUMBER := 0;
764: BEGIN
765: Okc_Api.init_msg_list(p_init_msg_list);
766: -- Make sure PL/SQL table has records in it before passing
767: IF (p_rxhv_tbl.COUNT > 0)
768: THEN
769: i := p_rxhv_tbl.FIRST;

Line 773: ,p_init_msg_list => Okc_Api.G_FALSE

769: i := p_rxhv_tbl.FIRST;
770: LOOP
771: validate_rxh_extension(
772: p_api_version => p_api_version
773: ,p_init_msg_list => Okc_Api.G_FALSE
774: ,x_return_status => x_return_status
775: ,x_msg_count => x_msg_count
776: ,x_msg_data => x_msg_data
777: ,p_rxhv_rec => p_rxhv_tbl(i));

Line 779: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS

775: ,x_msg_count => x_msg_count
776: ,x_msg_data => x_msg_data
777: ,p_rxhv_rec => p_rxhv_tbl(i));
778: -- store the highest degree of error
779: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
780: THEN
781: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
782: THEN
783: l_overall_status := x_return_status;

Line 781: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR

777: ,p_rxhv_rec => p_rxhv_tbl(i));
778: -- store the highest degree of error
779: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS
780: THEN
781: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR
782: THEN
783: l_overall_status := x_return_status;
784: END IF;
785: END IF;

Line 797: OKC_API.SET_MESSAGE(

793: THEN
794: NULL;
795: WHEN OTHERS
796: THEN
797: OKC_API.SET_MESSAGE(
798: p_app_name => g_app_name
799: ,p_msg_name => g_unexpected_error
800: ,p_token1 => g_sqlcode_token
801: ,p_token1_value => sqlcode

Line 804: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

800: ,p_token1 => g_sqlcode_token
801: ,p_token1_value => sqlcode
802: ,p_token2 => g_sqlerrm_token
803: ,p_token2_value => sqlerrm);
804: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
805: END validate_rxh_extension;
806:
807: ----------------------------------------------------------------------------------
808: -- Start of comments

Line 820: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

816: -- End of comments
817: ----------------------------------------------------------------------------------
818: PROCEDURE create_rxl_extension(
819: p_api_version IN NUMBER
820: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
821: ,x_return_status OUT NOCOPY VARCHAR2
822: ,x_msg_count OUT NOCOPY NUMBER
823: ,x_msg_data OUT NOCOPY VARCHAR2
824: ,p_rxlv_rec IN rxlv_rec_type

Line 827: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

823: ,x_msg_data OUT NOCOPY VARCHAR2
824: ,p_rxlv_rec IN rxlv_rec_type
825: ,x_rxlv_rec OUT NOCOPY rxlv_rec_type)
826: IS
827: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
828: BEGIN
829: okl_rxl_pvt.insert_row(
830: p_api_version => p_api_version
831: ,p_init_msg_list => p_init_msg_list

Line 837: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

833: ,x_msg_count => x_msg_count
834: ,x_msg_data => x_msg_data
835: ,p_rxlv_rec => p_rxlv_rec
836: ,x_rxlv_rec => x_rxlv_rec);
837: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
838: THEN
839: RAISE G_EXCEPTION_HALT_VALIDATION;
840: ELSE
841: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

Line 841: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

837: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
838: THEN
839: RAISE G_EXCEPTION_HALT_VALIDATION;
840: ELSE
841: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
842: THEN
843: l_return_status := x_return_status;
844: END IF;
845: END IF;

Line 852: OKC_API.SET_MESSAGE(

848: THEN
849: NULL;
850: WHEN OTHERS
851: THEN
852: OKC_API.SET_MESSAGE(
853: p_app_name => g_app_name
854: ,p_msg_name => g_unexpected_error
855: ,p_token1 => g_sqlcode_token
856: ,p_token1_value => sqlcode

Line 859: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

855: ,p_token1 => g_sqlcode_token
856: ,p_token1_value => sqlcode
857: ,p_token2 => g_sqlerrm_token
858: ,p_token2_value => sqlerrm);
859: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
860: END create_rxl_extension;
861:
862: ----------------------------------------------------------------------------------
863: -- Start of comments

Line 876: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

872: -- End of comments
873: ----------------------------------------------------------------------------------
874: PROCEDURE create_rxl_extension(
875: p_api_version IN NUMBER
876: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
877: ,x_return_status OUT NOCOPY VARCHAR2
878: ,x_msg_count OUT NOCOPY NUMBER
879: ,x_msg_data OUT NOCOPY VARCHAR2
880: ,p_rxlv_tbl IN rxlv_tbl_type

Line 883: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

879: ,x_msg_data OUT NOCOPY VARCHAR2
880: ,p_rxlv_tbl IN rxlv_tbl_type
881: ,x_rxlv_tbl OUT NOCOPY rxlv_tbl_type)
882: IS
883: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
884: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
885: i NUMBER := 0;
886: BEGIN
887: OKC_API.init_msg_list(p_init_msg_list);

Line 884: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

880: ,p_rxlv_tbl IN rxlv_tbl_type
881: ,x_rxlv_tbl OUT NOCOPY rxlv_tbl_type)
882: IS
883: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
884: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
885: i NUMBER := 0;
886: BEGIN
887: OKC_API.init_msg_list(p_init_msg_list);
888: -- Make sure PL/SQL table has records in it before passing

Line 887: OKC_API.init_msg_list(p_init_msg_list);

883: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
884: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
885: i NUMBER := 0;
886: BEGIN
887: OKC_API.init_msg_list(p_init_msg_list);
888: -- Make sure PL/SQL table has records in it before passing
889: IF (p_rxlv_tbl.COUNT > 0)
890: THEN
891: i := p_rxlv_tbl.FIRST;

Line 895: ,p_init_msg_list => OKC_API.G_FALSE

891: i := p_rxlv_tbl.FIRST;
892: LOOP
893: create_rxl_extension(
894: p_api_version => p_api_version
895: ,p_init_msg_list => OKC_API.G_FALSE
896: ,x_return_status => x_return_status
897: ,x_msg_count => x_msg_count
898: ,x_msg_data => x_msg_data
899: ,p_rxlv_rec => p_rxlv_tbl(i)

Line 902: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

898: ,x_msg_data => x_msg_data
899: ,p_rxlv_rec => p_rxlv_tbl(i)
900: ,x_rxlv_rec => x_rxlv_tbl(i));
901: -- store the highest degree of error
902: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
903: THEN
904: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR
905: THEN
906: l_overall_status := x_return_status;

Line 904: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR

900: ,x_rxlv_rec => x_rxlv_tbl(i));
901: -- store the highest degree of error
902: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
903: THEN
904: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR
905: THEN
906: l_overall_status := x_return_status;
907: END IF;
908: END IF;

Line 920: OKC_API.SET_MESSAGE(

916: THEN
917: NULL;
918: WHEN OTHERS
919: THEN
920: OKC_API.SET_MESSAGE(
921: p_app_name => g_app_name
922: ,p_msg_name => g_unexpected_error
923: ,p_token1 => g_sqlcode_token
924: ,p_token1_value => sqlcode

Line 927: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

923: ,p_token1 => g_sqlcode_token
924: ,p_token1_value => sqlcode
925: ,p_token2 => g_sqlerrm_token
926: ,p_token2_value => sqlerrm);
927: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
928: END create_rxl_extension;
929: ----------------------------------------------------------------------------------
930: -- Start of comments
931: --

Line 942: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

938: -- End of comments
939: ----------------------------------------------------------------------------------
940: PROCEDURE lock_rxl_extension(
941: p_api_version IN NUMBER
942: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
943: ,x_return_status OUT NOCOPY VARCHAR2
944: ,x_msg_count OUT NOCOPY NUMBER
945: ,x_msg_data OUT NOCOPY VARCHAR2
946: ,p_rxlv_rec IN rxlv_rec_type) IS

Line 947: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

943: ,x_return_status OUT NOCOPY VARCHAR2
944: ,x_msg_count OUT NOCOPY NUMBER
945: ,x_msg_data OUT NOCOPY VARCHAR2
946: ,p_rxlv_rec IN rxlv_rec_type) IS
947: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
948: BEGIN
949: okl_rxl_pvt.lock_row(
950: p_api_version => p_api_version
951: ,p_init_msg_list => p_init_msg_list

Line 956: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

952: ,x_return_status => x_return_status
953: ,x_msg_count => x_msg_count
954: ,x_msg_data => x_msg_data
955: ,p_rxlv_rec => p_rxlv_rec );
956: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
957: THEN
958: RAISE G_EXCEPTION_HALT_VALIDATION;
959: ELSE
960: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

Line 960: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

956: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
957: THEN
958: RAISE G_EXCEPTION_HALT_VALIDATION;
959: ELSE
960: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
961: THEN
962: l_return_status := x_return_status;
963: END IF;
964: END IF;

Line 971: OKC_API.SET_MESSAGE(

967: THEN
968: NULL;
969: WHEN OTHERS
970: THEN
971: OKC_API.SET_MESSAGE(
972: p_app_name => g_app_name
973: ,p_msg_name => g_unexpected_error
974: ,p_token1 => g_sqlcode_token
975: ,p_token1_value => sqlcode

Line 978: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

974: ,p_token1 => g_sqlcode_token
975: ,p_token1_value => sqlcode
976: ,p_token2 => g_sqlerrm_token
977: ,p_token2_value => sqlerrm);
978: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
979: END lock_rxl_extension;
980:
981: ----------------------------------------------------------------------------------
982: -- Start of comments

Line 994: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

990: -- End of comments
991: ----------------------------------------------------------------------------------
992: PROCEDURE lock_rxl_extension(
993: p_api_version IN NUMBER
994: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
995: ,x_return_status OUT NOCOPY VARCHAR2
996: ,x_msg_count OUT NOCOPY NUMBER
997: ,x_msg_data OUT NOCOPY VARCHAR2
998: ,p_rxlv_tbl IN rxlv_tbl_type)

Line 1000: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

996: ,x_msg_count OUT NOCOPY NUMBER
997: ,x_msg_data OUT NOCOPY VARCHAR2
998: ,p_rxlv_tbl IN rxlv_tbl_type)
999: IS
1000: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1001: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1002: i NUMBER := 0;
1003: BEGIN
1004: OKC_API.init_msg_list(p_init_msg_list);

Line 1001: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

997: ,x_msg_data OUT NOCOPY VARCHAR2
998: ,p_rxlv_tbl IN rxlv_tbl_type)
999: IS
1000: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1001: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1002: i NUMBER := 0;
1003: BEGIN
1004: OKC_API.init_msg_list(p_init_msg_list);
1005: -- Make sure PL/SQL table has records in it before passing

Line 1004: OKC_API.init_msg_list(p_init_msg_list);

1000: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1001: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1002: i NUMBER := 0;
1003: BEGIN
1004: OKC_API.init_msg_list(p_init_msg_list);
1005: -- Make sure PL/SQL table has records in it before passing
1006: IF (p_rxlv_tbl.COUNT > 0)
1007: THEN
1008: i := p_rxlv_tbl.FIRST;

Line 1012: ,p_init_msg_list => OKC_API.G_FALSE

1008: i := p_rxlv_tbl.FIRST;
1009: LOOP
1010: lock_rxl_extension(
1011: p_api_version => p_api_version
1012: ,p_init_msg_list => OKC_API.G_FALSE
1013: ,x_return_status => x_return_status
1014: ,x_msg_count => x_msg_count
1015: ,x_msg_data => x_msg_data
1016: ,p_rxlv_rec => p_rxlv_tbl(i));

Line 1018: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

1014: ,x_msg_count => x_msg_count
1015: ,x_msg_data => x_msg_data
1016: ,p_rxlv_rec => p_rxlv_tbl(i));
1017: -- store the highest degree of error
1018: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
1019: THEN
1020: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR
1021: THEN
1022: l_overall_status := x_return_status;

Line 1020: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR

1016: ,p_rxlv_rec => p_rxlv_tbl(i));
1017: -- store the highest degree of error
1018: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
1019: THEN
1020: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR
1021: THEN
1022: l_overall_status := x_return_status;
1023: END IF;
1024: END IF;

Line 1036: OKC_API.SET_MESSAGE(

1032: THEN
1033: NULL;
1034: WHEN OTHERS
1035: THEN
1036: OKC_API.SET_MESSAGE(
1037: p_app_name => g_app_name
1038: ,p_msg_name => g_unexpected_error
1039: ,p_token1 => g_sqlcode_token
1040: ,p_token1_value => sqlcode

Line 1043: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1039: ,p_token1 => g_sqlcode_token
1040: ,p_token1_value => sqlcode
1041: ,p_token2 => g_sqlerrm_token
1042: ,p_token2_value => sqlerrm);
1043: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1044: END lock_rxl_extension;
1045:
1046: ----------------------------------------------------------------------------------
1047: -- Start of comments

Line 1059: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1055: -- End of comments
1056: ----------------------------------------------------------------------------------
1057: PROCEDURE update_rxl_extension(
1058: p_api_version IN NUMBER
1059: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1060: ,x_return_status OUT NOCOPY VARCHAR2
1061: ,x_msg_count OUT NOCOPY NUMBER
1062: ,x_msg_data OUT NOCOPY VARCHAR2
1063: ,p_rxlv_rec IN rxlv_rec_type

Line 1066: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1062: ,x_msg_data OUT NOCOPY VARCHAR2
1063: ,p_rxlv_rec IN rxlv_rec_type
1064: ,x_rxlv_rec OUT NOCOPY rxlv_rec_type)
1065: IS
1066: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1067: BEGIN
1068: okl_rxl_pvt.update_row(
1069: p_api_version => p_api_version
1070: ,p_init_msg_list => p_init_msg_list

Line 1077: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1073: ,x_msg_data => x_msg_data
1074: ,p_rxlv_rec => p_rxlv_rec
1075: ,x_rxlv_rec => x_rxlv_rec
1076: );
1077: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1078: RAISE G_EXCEPTION_HALT_VALIDATION;
1079: ELSE
1080: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1081: l_return_status := x_return_status;

Line 1080: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1076: );
1077: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1078: RAISE G_EXCEPTION_HALT_VALIDATION;
1079: ELSE
1080: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1081: l_return_status := x_return_status;
1082: END IF;
1083: END IF;
1084: EXCEPTION

Line 1090: OKC_API.SET_MESSAGE(

1086: THEN
1087: NULL;
1088: WHEN OTHERS
1089: THEN
1090: OKC_API.SET_MESSAGE(
1091: p_app_name => g_app_name
1092: ,p_msg_name => g_unexpected_error
1093: ,p_token1 => g_sqlcode_token
1094: ,p_token1_value => sqlcode

Line 1097: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1093: ,p_token1 => g_sqlcode_token
1094: ,p_token1_value => sqlcode
1095: ,p_token2 => g_sqlerrm_token
1096: ,p_token2_value => sqlerrm);
1097: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1098: END update_rxl_extension;
1099:
1100: ----------------------------------------------------------------------------------
1101: -- Start of comments

Line 1113: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1109: -- End of comments
1110: ----------------------------------------------------------------------------------
1111: PROCEDURE update_rxl_extension(
1112: p_api_version IN NUMBER
1113: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1114: ,x_return_status OUT NOCOPY VARCHAR2
1115: ,x_msg_count OUT NOCOPY NUMBER
1116: ,x_msg_data OUT NOCOPY VARCHAR2
1117: ,p_rxlv_tbl IN rxlv_tbl_type

Line 1120: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1116: ,x_msg_data OUT NOCOPY VARCHAR2
1117: ,p_rxlv_tbl IN rxlv_tbl_type
1118: ,x_rxlv_tbl OUT NOCOPY rxlv_tbl_type)
1119: IS
1120: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1121: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1122: i NUMBER := 0;
1123: BEGIN
1124: OKC_API.init_msg_list(p_init_msg_list);

Line 1121: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1117: ,p_rxlv_tbl IN rxlv_tbl_type
1118: ,x_rxlv_tbl OUT NOCOPY rxlv_tbl_type)
1119: IS
1120: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1121: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1122: i NUMBER := 0;
1123: BEGIN
1124: OKC_API.init_msg_list(p_init_msg_list);
1125: -- Make sure PL/SQL table has records in it before passing

Line 1124: OKC_API.init_msg_list(p_init_msg_list);

1120: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1121: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1122: i NUMBER := 0;
1123: BEGIN
1124: OKC_API.init_msg_list(p_init_msg_list);
1125: -- Make sure PL/SQL table has records in it before passing
1126: IF (p_rxlv_tbl.COUNT > 0)
1127: THEN
1128: i := p_rxlv_tbl.FIRST;

Line 1132: p_init_msg_list => OKC_API.G_FALSE,

1128: i := p_rxlv_tbl.FIRST;
1129: LOOP
1130: update_rxl_extension(
1131: p_api_version => p_api_version,
1132: p_init_msg_list => OKC_API.G_FALSE,
1133: x_return_status => x_return_status,
1134: x_msg_count => x_msg_count,
1135: x_msg_data => x_msg_data,
1136: p_rxlv_rec => p_rxlv_tbl(i),

Line 1139: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

1135: x_msg_data => x_msg_data,
1136: p_rxlv_rec => p_rxlv_tbl(i),
1137: x_rxlv_rec => x_rxlv_tbl(i));
1138: -- store the highest degree of error
1139: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
1140: THEN
1141: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR
1142: THEN
1143: l_overall_status := x_return_status;

Line 1141: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR

1137: x_rxlv_rec => x_rxlv_tbl(i));
1138: -- store the highest degree of error
1139: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
1140: THEN
1141: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR
1142: THEN
1143: l_overall_status := x_return_status;
1144: END IF;
1145: END IF;

Line 1157: OKC_API.SET_MESSAGE(

1153: THEN
1154: NULL;
1155: WHEN OTHERS
1156: THEN
1157: OKC_API.SET_MESSAGE(
1158: p_app_name => g_app_name
1159: ,p_msg_name => g_unexpected_error
1160: ,p_token1 => g_sqlcode_token
1161: ,p_token1_value => sqlcode

Line 1164: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1160: ,p_token1 => g_sqlcode_token
1161: ,p_token1_value => sqlcode
1162: ,p_token2 => g_sqlerrm_token
1163: ,p_token2_value => sqlerrm);
1164: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1165: END update_rxl_extension;
1166:
1167: ----------------------------------------------------------------------------------
1168: -- Start of comments

Line 1180: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1176: -- End of comments
1177: ----------------------------------------------------------------------------------
1178: PROCEDURE delete_rxl_extension(
1179: p_api_version IN NUMBER
1180: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1181: ,x_return_status OUT NOCOPY VARCHAR2
1182: ,x_msg_count OUT NOCOPY NUMBER
1183: ,x_msg_data OUT NOCOPY VARCHAR2
1184: ,p_rxlv_rec IN rxlv_rec_type) IS

Line 1186: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1182: ,x_msg_count OUT NOCOPY NUMBER
1183: ,x_msg_data OUT NOCOPY VARCHAR2
1184: ,p_rxlv_rec IN rxlv_rec_type) IS
1185: i NUMBER :=0;
1186: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1187: BEGIN
1188: okl_rxl_pvt.delete_row(
1189: p_api_version => p_api_version
1190: ,p_init_msg_list => p_init_msg_list

Line 1195: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

1191: ,x_return_status => x_return_status
1192: ,x_msg_count => x_msg_count
1193: ,x_msg_data => x_msg_data
1194: ,p_rxlv_rec => p_rxlv_rec);
1195: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1196: THEN
1197: RAISE G_EXCEPTION_HALT_VALIDATION;
1198: ELSE
1199: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

Line 1199: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

1195: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1196: THEN
1197: RAISE G_EXCEPTION_HALT_VALIDATION;
1198: ELSE
1199: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
1200: THEN
1201: l_return_status := x_return_status;
1202: END IF;
1203: END IF;

Line 1210: OKC_API.SET_MESSAGE(

1206: THEN
1207: NULL;
1208: WHEN OTHERS
1209: THEN
1210: OKC_API.SET_MESSAGE(
1211: p_app_name => g_app_name
1212: ,p_msg_name => g_unexpected_error
1213: ,p_token1 => g_sqlcode_token
1214: ,p_token1_value => sqlcode

Line 1217: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1213: ,p_token1 => g_sqlcode_token
1214: ,p_token1_value => sqlcode
1215: ,p_token2 => g_sqlerrm_token
1216: ,p_token2_value => sqlerrm);
1217: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1218: END delete_rxl_extension;
1219:
1220: ----------------------------------------------------------------------------------
1221: -- Start of comments

Line 1233: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1229: -- End of comments
1230: ----------------------------------------------------------------------------------
1231: PROCEDURE delete_rxl_extension(
1232: p_api_version IN NUMBER
1233: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1234: ,x_return_status OUT NOCOPY VARCHAR2
1235: ,x_msg_count OUT NOCOPY NUMBER
1236: ,x_msg_data OUT NOCOPY VARCHAR2
1237: ,p_rxlv_tbl IN rxlv_tbl_type)

Line 1240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1236: ,x_msg_data OUT NOCOPY VARCHAR2
1237: ,p_rxlv_tbl IN rxlv_tbl_type)
1238: IS
1239: i NUMBER :=0;
1240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1241: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1242: BEGIN
1243: --Initialize the return status
1244: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1241: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1237: ,p_rxlv_tbl IN rxlv_tbl_type)
1238: IS
1239: i NUMBER :=0;
1240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1241: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1242: BEGIN
1243: --Initialize the return status
1244: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1245: IF (p_rxlv_tbl.COUNT > 0)

Line 1244: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1241: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1242: BEGIN
1243: --Initialize the return status
1244: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1245: IF (p_rxlv_tbl.COUNT > 0)
1246: THEN
1247: i := p_rxlv_tbl.FIRST;
1248: LOOP

Line 1256: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

1252: ,x_return_status => x_return_status
1253: ,x_msg_count => x_msg_count
1254: ,x_msg_data => x_msg_data
1255: ,p_rxlv_rec => p_rxlv_tbl(i));
1256: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
1257: THEN
1258: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR
1259: THEN
1260: l_overall_status := x_return_status;

Line 1258: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR

1254: ,x_msg_data => x_msg_data
1255: ,p_rxlv_rec => p_rxlv_tbl(i));
1256: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
1257: THEN
1258: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR
1259: THEN
1260: l_overall_status := x_return_status;
1261: END IF;
1262: END IF;

Line 1274: OKC_API.SET_MESSAGE(

1270: THEN
1271: NULL;
1272: WHEN OTHERS
1273: THEN
1274: OKC_API.SET_MESSAGE(
1275: p_app_name => g_app_name
1276: ,p_msg_name => g_unexpected_error
1277: ,p_token1 => g_sqlcode_token
1278: ,p_token1_value => sqlcode

Line 1281: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1277: ,p_token1 => g_sqlcode_token
1278: ,p_token1_value => sqlcode
1279: ,p_token2 => g_sqlerrm_token
1280: ,p_token2_value => sqlerrm);
1281: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1282: END delete_rxl_extension;
1283:
1284: ----------------------------------------------------------------------------------
1285: -- Start of comments

Line 1297: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1293: -- End of comments
1294: ----------------------------------------------------------------------------------
1295: PROCEDURE validate_rxl_extension(
1296: p_api_version IN NUMBER
1297: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1298: ,x_return_status OUT NOCOPY VARCHAR2
1299: ,x_msg_count OUT NOCOPY NUMBER
1300: ,x_msg_data OUT NOCOPY VARCHAR2
1301: ,p_rxlv_rec IN rxlv_rec_type) IS

Line 1302: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1298: ,x_return_status OUT NOCOPY VARCHAR2
1299: ,x_msg_count OUT NOCOPY NUMBER
1300: ,x_msg_data OUT NOCOPY VARCHAR2
1301: ,p_rxlv_rec IN rxlv_rec_type) IS
1302: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1303: BEGIN
1304: okl_rxl_pvt.validate_row(
1305: p_api_version => p_api_version
1306: ,p_init_msg_list => p_init_msg_list

Line 1311: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

1307: ,x_return_status => x_return_status
1308: ,x_msg_count => x_msg_count
1309: ,x_msg_data => x_msg_data
1310: ,p_rxlv_rec => p_rxlv_rec );
1311: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1312: THEN
1313: RAISE G_EXCEPTION_HALT_VALIDATION;
1314: ELSE
1315: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

Line 1315: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

1311: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1312: THEN
1313: RAISE G_EXCEPTION_HALT_VALIDATION;
1314: ELSE
1315: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
1316: THEN
1317: l_return_status := x_return_status;
1318: END IF;
1319: END IF;

Line 1326: OKC_API.SET_MESSAGE(

1322: THEN
1323: NULL;
1324: WHEN OTHERS
1325: THEN
1326: OKC_API.SET_MESSAGE(
1327: p_app_name => g_app_name
1328: ,p_msg_name => g_unexpected_error
1329: ,p_token1 => g_sqlcode_token
1330: ,p_token1_value => sqlcode

Line 1333: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1329: ,p_token1 => g_sqlcode_token
1330: ,p_token1_value => sqlcode
1331: ,p_token2 => g_sqlerrm_token
1332: ,p_token2_value => sqlerrm);
1333: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1334: END validate_rxl_extension;
1335:
1336: ----------------------------------------------------------------------------------
1337: -- Start of comments

Line 1349: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1345: -- End of comments
1346: ----------------------------------------------------------------------------------
1347: PROCEDURE validate_rxl_extension(
1348: p_api_version IN NUMBER
1349: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1350: ,x_return_status OUT NOCOPY VARCHAR2
1351: ,x_msg_count OUT NOCOPY NUMBER
1352: ,x_msg_data OUT NOCOPY VARCHAR2
1353: ,p_rxlv_tbl IN rxlv_tbl_type)

Line 1355: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1351: ,x_msg_count OUT NOCOPY NUMBER
1352: ,x_msg_data OUT NOCOPY VARCHAR2
1353: ,p_rxlv_tbl IN rxlv_tbl_type)
1354: IS
1355: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1356: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1357: i NUMBER := 0;
1358: BEGIN
1359: OKC_API.init_msg_list(p_init_msg_list);

Line 1356: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1352: ,x_msg_data OUT NOCOPY VARCHAR2
1353: ,p_rxlv_tbl IN rxlv_tbl_type)
1354: IS
1355: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1356: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1357: i NUMBER := 0;
1358: BEGIN
1359: OKC_API.init_msg_list(p_init_msg_list);
1360: -- Make sure PL/SQL table has records in it before passing

Line 1359: OKC_API.init_msg_list(p_init_msg_list);

1355: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1356: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1357: i NUMBER := 0;
1358: BEGIN
1359: OKC_API.init_msg_list(p_init_msg_list);
1360: -- Make sure PL/SQL table has records in it before passing
1361: IF (p_rxlv_tbl.COUNT > 0)
1362: THEN
1363: i := p_rxlv_tbl.FIRST;

Line 1367: ,p_init_msg_list => OKC_API.G_FALSE

1363: i := p_rxlv_tbl.FIRST;
1364: LOOP
1365: validate_rxl_extension(
1366: p_api_version => p_api_version
1367: ,p_init_msg_list => OKC_API.G_FALSE
1368: ,x_return_status => x_return_status
1369: ,x_msg_count => x_msg_count
1370: ,x_msg_data => x_msg_data
1371: ,p_rxlv_rec => p_rxlv_tbl(i));

Line 1373: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS

1369: ,x_msg_count => x_msg_count
1370: ,x_msg_data => x_msg_data
1371: ,p_rxlv_rec => p_rxlv_tbl(i));
1372: -- store the highest degree of error
1373: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
1374: THEN
1375: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR
1376: THEN
1377: l_overall_status := x_return_status;

Line 1375: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR

1371: ,p_rxlv_rec => p_rxlv_tbl(i));
1372: -- store the highest degree of error
1373: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS
1374: THEN
1375: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR
1376: THEN
1377: l_overall_status := x_return_status;
1378: END IF;
1379: END IF;

Line 1391: OKC_API.SET_MESSAGE(

1387: THEN
1388: NULL;
1389: WHEN OTHERS
1390: THEN
1391: OKC_API.SET_MESSAGE(
1392: p_app_name => g_app_name
1393: ,p_msg_name => g_unexpected_error
1394: ,p_token1 => g_sqlcode_token
1395: ,p_token1_value => sqlcode

Line 1398: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1394: ,p_token1 => g_sqlcode_token
1395: ,p_token1_value => sqlcode
1396: ,p_token2 => g_sqlerrm_token
1397: ,p_token2_value => sqlerrm);
1398: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1399: END validate_rxl_extension;
1400:
1401: ----------------------------------------------------------------------------------
1402: -- Start of comments

Line 1417: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1413: -- End of comments
1414: ----------------------------------------------------------------------------------
1415: PROCEDURE create_rxh_extension(
1416: p_api_version IN NUMBER
1417: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1418: ,x_return_status OUT NOCOPY VARCHAR2
1419: ,x_msg_count OUT NOCOPY NUMBER
1420: ,x_msg_data OUT NOCOPY VARCHAR2
1421: ,p_rxh_rec IN rxh_rec_type

Line 1425: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1421: ,p_rxh_rec IN rxh_rec_type
1422: ,p_rxhl_tbl IN rxhl_tbl_type
1423: ,x_rxh_rec OUT NOCOPY rxh_rec_type
1424: ,x_rxhl_tbl OUT NOCOPY rxhl_tbl_type) IS
1425: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1426: BEGIN
1427: okl_rxh_pvt.insert_row(
1428: p_api_version => p_api_version
1429: ,p_init_msg_list => p_init_msg_list

Line 1439: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1435: ,x_rxh_rec => x_rxh_rec
1436: ,x_rxhl_tbl => x_rxhl_tbl
1437: );
1438:
1439: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1440: RAISE G_EXCEPTION_HALT_VALIDATION;
1441: ELSE
1442: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1443: l_return_status := x_return_status;

Line 1442: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1438:
1439: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1440: RAISE G_EXCEPTION_HALT_VALIDATION;
1441: ELSE
1442: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1443: l_return_status := x_return_status;
1444: END IF;
1445: END IF;
1446: -- Custom code if any

Line 1453: OKC_API.SET_MESSAGE(p_app_name => g_app_name

1449: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1450: NULL;
1451:
1452: WHEN OTHERS THEN
1453: OKC_API.SET_MESSAGE(p_app_name => g_app_name
1454: ,p_msg_name => g_unexpected_error
1455: ,p_token1 => g_sqlcode_token
1456: ,p_token1_value => sqlcode
1457: ,p_token2 => g_sqlerrm_token

Line 1459: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1455: ,p_token1 => g_sqlcode_token
1456: ,p_token1_value => sqlcode
1457: ,p_token2 => g_sqlerrm_token
1458: ,p_token2_value => sqlerrm);
1459: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1460: END create_rxh_extension;
1461:
1462: ----------------------------------------------------------------------------------
1463: -- Start of comments

Line 1478: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1474: -- End of comments
1475: ----------------------------------------------------------------------------------
1476: PROCEDURE create_rxl_extension(
1477: p_api_version IN NUMBER
1478: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rxl_rec IN rxl_rec_type

Line 1486: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1482: ,p_rxl_rec IN rxl_rec_type
1483: ,p_rxll_tbl IN rxll_tbl_type
1484: ,x_rxl_rec OUT NOCOPY rxl_rec_type
1485: ,x_rxll_tbl OUT NOCOPY rxll_tbl_type) IS
1486: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1487: BEGIN
1488: okl_rxl_pvt.insert_row(
1489: p_api_version => p_api_version
1490: ,p_init_msg_list => p_init_msg_list

Line 1499: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1495: ,p_rxll_tbl => p_rxll_tbl
1496: ,x_rxl_rec => x_rxl_rec
1497: ,x_rxll_tbl => x_rxll_tbl
1498: );
1499: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE G_EXCEPTION_HALT_VALIDATION;
1501: ELSE
1502: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1503: l_return_status := x_return_status;

Line 1502: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1498: );
1499: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE G_EXCEPTION_HALT_VALIDATION;
1501: ELSE
1502: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1503: l_return_status := x_return_status;
1504: END IF;
1505: END IF;
1506: EXCEPTION

Line 1510: OKC_API.SET_MESSAGE(p_app_name => g_app_name

1506: EXCEPTION
1507: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1508: NULL;
1509: WHEN OTHERS THEN
1510: OKC_API.SET_MESSAGE(p_app_name => g_app_name
1511: ,p_msg_name => g_unexpected_error
1512: ,p_token1 => g_sqlcode_token
1513: ,p_token1_value => sqlcode
1514: ,p_token2 => g_sqlerrm_token

Line 1516: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1512: ,p_token1 => g_sqlcode_token
1513: ,p_token1_value => sqlcode
1514: ,p_token2 => g_sqlerrm_token
1515: ,p_token2_value => sqlerrm);
1516: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1517: END create_rxl_extension;
1518: END OKL_AR_EXTENSION_PVT;