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

Line 14: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

10:
11: --Object type procedure for insert
12: PROCEDURE create_internal_trans(
13: p_api_version IN NUMBER
14: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
15: ,x_return_status OUT NOCOPY VARCHAR2
16: ,x_msg_count OUT NOCOPY NUMBER
17: ,x_msg_data OUT NOCOPY VARCHAR2
18: ,p_rctv_rec IN rctv_rec_type

Line 24: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

20: ,x_rctv_rec OUT NOCOPY rctv_rec_type
21: ,x_rcav_tbl OUT NOCOPY rcav_tbl_type
22: ) IS
23:
24: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
25: l_rctv_rec rctv_rec_type;
26: l_rcav_tbl rcav_tbl_type := p_rcav_tbl;
27: i NUMBER;
28: BEGIN

Line 40: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

36: x_msg_data,
37: p_rctv_rec,
38: x_rctv_rec);
39:
40: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
41: RAISE G_EXCEPTION_HALT_VALIDATION;
42: ELSE
43: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
44: l_return_status := x_return_status;

Line 43: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

39:
40: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
41: RAISE G_EXCEPTION_HALT_VALIDATION;
42: ELSE
43: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
44: l_return_status := x_return_status;
45: END IF;
46: END IF;
47:

Line 69: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

65: x_msg_data,
66: l_rcav_tbl,
67: x_rcav_tbl);
68:
69: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
70: RAISE G_EXCEPTION_HALT_VALIDATION;
71: ELSE
72: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
73: l_return_status := x_return_status;

Line 72: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

68:
69: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
70: RAISE G_EXCEPTION_HALT_VALIDATION;
71: ELSE
72: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
73: l_return_status := x_return_status;
74: END IF;
75: END IF;
76:

Line 83: Okl_Api.set_message(p_app_name => g_app_name,

79: WHEN G_EXCEPTION_HALT_VALIDATION THEN
80: NULL;
81:
82: WHEN OTHERS THEN
83: Okl_Api.set_message(p_app_name => g_app_name,
84: p_msg_name => g_unexpected_error,
85: p_token1 => g_sqlcode_token,
86: p_token1_value => SQLCODE,
87: p_token2 => g_sqlerrm_token,

Line 89: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

85: p_token1 => g_sqlcode_token,
86: p_token1_value => SQLCODE,
87: p_token2 => g_sqlerrm_token,
88: p_token2_value => SQLERRM);
89: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
90:
91: END ;
92:
93: --Object type procedure for update

Line 96: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

92:
93: --Object type procedure for update
94: PROCEDURE update_internal_trans(
95: p_api_version IN NUMBER
96: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
97: ,x_return_status OUT NOCOPY VARCHAR2
98: ,x_msg_count OUT NOCOPY NUMBER
99: ,x_msg_data OUT NOCOPY VARCHAR2
100: ,p_rctv_rec IN rctv_rec_type

Line 105: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

101: ,p_rcav_tbl IN rcav_tbl_type
102: ,x_rctv_rec OUT NOCOPY rctv_rec_type
103: ,x_rcav_tbl OUT NOCOPY rcav_tbl_type
104: ) IS
105: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
106: BEGIN
107: --Update the Master
108: update_internal_trans(
109: p_api_version,

Line 116: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

112: x_msg_count,
113: x_msg_data,
114: p_rctv_rec,
115: x_rctv_rec);
116: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
117: RAISE G_EXCEPTION_HALT_VALIDATION;
118: ELSE
119: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
120: l_return_status := x_return_status;

Line 119: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

115: x_rctv_rec);
116: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
117: RAISE G_EXCEPTION_HALT_VALIDATION;
118: ELSE
119: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
120: l_return_status := x_return_status;
121: END IF;
122: END IF;
123:

Line 133: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

129: x_msg_count,
130: x_msg_data,
131: p_rcav_tbl,
132: x_rcav_tbl);
133: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
134: RAISE G_EXCEPTION_HALT_VALIDATION;
135: ELSE
136: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
137: l_return_status := x_return_status;

Line 136: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

132: x_rcav_tbl);
133: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
134: RAISE G_EXCEPTION_HALT_VALIDATION;
135: ELSE
136: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
137: l_return_status := x_return_status;
138: END IF;
139: END IF;
140: EXCEPTION

Line 145: Okl_Api.set_message(p_app_name => g_app_name,

141: WHEN G_EXCEPTION_HALT_VALIDATION THEN
142: NULL;
143:
144: WHEN OTHERS THEN
145: Okl_Api.set_message(p_app_name => g_app_name,
146: p_msg_name => g_unexpected_error,
147: p_token1 => g_sqlcode_token,
148: p_token1_value => SQLCODE,
149: p_token2 => g_sqlerrm_token,

Line 151: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

147: p_token1 => g_sqlcode_token,
148: p_token1_value => SQLCODE,
149: p_token2 => g_sqlerrm_token,
150: p_token2_value => SQLERRM);
151: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
152: END ;
153:
154: --Object type procedure for delete
155: PROCEDURE delete_internal_trans(

Line 157: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

153:
154: --Object type procedure for delete
155: PROCEDURE delete_internal_trans(
156: p_api_version IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
158: ,x_return_status OUT NOCOPY VARCHAR2
159: ,x_msg_count OUT NOCOPY NUMBER
160: ,x_msg_data OUT NOCOPY VARCHAR2
161: ,p_rctv_rec IN rctv_rec_type

Line 166: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

162: ,p_rcav_tbl IN rcav_tbl_type
163: ,x_rctv_rec OUT NOCOPY rctv_rec_type
164: ,x_rcav_tbl OUT NOCOPY rcav_tbl_type
165: ) IS
166: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
167: BEGIN
168: --Delete the Master
169: delete_internal_trans(
170: p_api_version,

Line 176: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

172: x_return_status,
173: x_msg_count,
174: x_msg_data,
175: p_rctv_rec);
176: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
177: RAISE G_EXCEPTION_HALT_VALIDATION;
178: ELSE
179: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
180: l_return_status := x_return_status;

Line 179: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

175: p_rctv_rec);
176: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
177: RAISE G_EXCEPTION_HALT_VALIDATION;
178: ELSE
179: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
180: l_return_status := x_return_status;
181: END IF;
182: END IF;
183:

Line 192: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

188: x_return_status,
189: x_msg_count,
190: x_msg_data,
191: p_rcav_tbl);
192: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
193: RAISE G_EXCEPTION_HALT_VALIDATION;
194: ELSE
195: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
196: l_return_status := x_return_status;

Line 195: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

191: p_rcav_tbl);
192: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
193: RAISE G_EXCEPTION_HALT_VALIDATION;
194: ELSE
195: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
196: l_return_status := x_return_status;
197: END IF;
198: END IF;
199: EXCEPTION

Line 204: Okl_Api.set_message(p_app_name => g_app_name,

200: WHEN G_EXCEPTION_HALT_VALIDATION THEN
201: NULL;
202:
203: WHEN OTHERS THEN
204: Okl_Api.set_message(p_app_name => g_app_name,
205: p_msg_name => g_unexpected_error,
206: p_token1 => g_sqlcode_token,
207: p_token1_value => SQLCODE,
208: p_token2 => g_sqlerrm_token,

Line 210: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

206: p_token1 => g_sqlcode_token,
207: p_token1_value => SQLCODE,
208: p_token2 => g_sqlerrm_token,
209: p_token2_value => SQLERRM);
210: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
211: END ;
212:
213: --Object type procedure for validate
214: PROCEDURE validate_internal_trans(

Line 216: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

212:
213: --Object type procedure for validate
214: PROCEDURE validate_internal_trans(
215: p_api_version IN NUMBER
216: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rctv_rec IN rctv_rec_type

Line 223: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

219: ,x_msg_data OUT NOCOPY VARCHAR2
220: ,p_rctv_rec IN rctv_rec_type
221: ,p_rcav_tbl IN rcav_tbl_type
222: ) IS
223: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
224: BEGIN
225: --Validate the Master
226: validate_internal_trans(
227: p_api_version,

Line 233: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

229: x_return_status,
230: x_msg_count,
231: x_msg_data,
232: p_rctv_rec);
233: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
234: RAISE G_EXCEPTION_HALT_VALIDATION;
235: ELSE
236: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
237: l_return_status := x_return_status;

Line 236: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

232: p_rctv_rec);
233: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
234: RAISE G_EXCEPTION_HALT_VALIDATION;
235: ELSE
236: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
237: l_return_status := x_return_status;
238: END IF;
239: END IF;
240:

Line 250: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

246: x_msg_count,
247: x_msg_data,
248: p_rcav_tbl);
249:
250: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
251: RAISE G_EXCEPTION_HALT_VALIDATION;
252: ELSE
253: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
254: l_return_status := x_return_status;

Line 253: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

249:
250: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
251: RAISE G_EXCEPTION_HALT_VALIDATION;
252: ELSE
253: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
254: l_return_status := x_return_status;
255: END IF;
256: END IF;
257:

Line 263: Okl_Api.set_message(p_app_name => g_app_name,

259: WHEN G_EXCEPTION_HALT_VALIDATION THEN
260: NULL;
261:
262: WHEN OTHERS THEN
263: Okl_Api.set_message(p_app_name => g_app_name,
264: p_msg_name => g_unexpected_error,
265: p_token1 => g_sqlcode_token,
266: p_token1_value => SQLCODE,
267: p_token2 => g_sqlerrm_token,

Line 269: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

265: p_token1 => g_sqlcode_token,
266: p_token1_value => SQLCODE,
267: p_token2 => g_sqlerrm_token,
268: p_token2_value => SQLERRM);
269: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
270: END ;
271:
272:
273:

Line 276: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

272:
273:
274: PROCEDURE create_internal_trans(
275: p_api_version IN NUMBER,
276: p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rctv_rec IN rctv_rec_type,

Line 295: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

291: x_rctv_rec);
292:
293:
294:
295: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
296: NULL;
297: -- Custom code by developer Update_Minor_Version(p_rctv_rec.dnz_chr_id);
298: END IF;
299:

Line 304: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

300: END create_internal_trans;
301:
302: PROCEDURE create_internal_trans(
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
305: x_return_status OUT NOCOPY VARCHAR2,
306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,
308: p_rctv_tbl IN rctv_tbl_type,

Line 323: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

319: END create_internal_trans;
320:
321: PROCEDURE lock_internal_trans(
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,
326: x_msg_data OUT NOCOPY VARCHAR2,
327: p_rctv_rec IN rctv_rec_type) IS

Line 340: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

336: END lock_internal_trans;
337:
338: PROCEDURE lock_internal_trans(
339: p_api_version IN NUMBER,
340: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
341: x_return_status OUT NOCOPY VARCHAR2,
342: x_msg_count OUT NOCOPY NUMBER,
343: x_msg_data OUT NOCOPY VARCHAR2,
344: p_rctv_tbl IN rctv_tbl_type) IS

Line 357: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

353: END lock_internal_trans;
354:
355: PROCEDURE update_internal_trans(
356: p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
358: x_return_status OUT NOCOPY VARCHAR2,
359: x_msg_count OUT NOCOPY NUMBER,
360: x_msg_data OUT NOCOPY VARCHAR2,
361: p_rctv_rec IN rctv_rec_type,

Line 373: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

369: x_msg_data,
370: p_rctv_rec,
371: x_rctv_rec);
372:
373: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
374: NULL;
375: -- Custom code by developer Update_Minor_Version(p_rctv_rec.dnz_chr_id);
376: END IF;
377: END update_internal_trans;

Line 381: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

377: END update_internal_trans;
378:
379: PROCEDURE update_internal_trans(
380: p_api_version IN NUMBER,
381: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
382: x_return_status OUT NOCOPY VARCHAR2,
383: x_msg_count OUT NOCOPY NUMBER,
384: x_msg_data OUT NOCOPY VARCHAR2,
385: p_rctv_tbl IN rctv_tbl_type,

Line 401: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

397:
398: --Put custom code for cascade delete by developer
399: PROCEDURE delete_internal_trans(
400: p_api_version IN NUMBER,
401: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
402: x_return_status OUT NOCOPY VARCHAR2,
403: x_msg_count OUT NOCOPY NUMBER,
404: x_msg_data OUT NOCOPY VARCHAR2,
405: p_rctv_rec IN rctv_rec_type) IS

Line 407: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

403: x_msg_count OUT NOCOPY NUMBER,
404: x_msg_data OUT NOCOPY VARCHAR2,
405: p_rctv_rec IN rctv_rec_type) IS
406: i NUMBER :=0;
407: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
408: BEGIN
409: --Delete the Master
410: Okl_Rct_Pvt.delete_row(
411: p_api_version,

Line 417: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

413: x_return_status,
414: x_msg_count,
415: x_msg_data,
416: p_rctv_rec);
417: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
418: RAISE G_EXCEPTION_HALT_VALIDATION;
419: ELSE
420: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
421: l_return_status := x_return_status;

Line 420: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

416: p_rctv_rec);
417: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
418: RAISE G_EXCEPTION_HALT_VALIDATION;
419: ELSE
420: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
421: l_return_status := x_return_status;
422: END IF;
423: END IF;
424: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

Line 424: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

420: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
421: l_return_status := x_return_status;
422: END IF;
423: END IF;
424: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
425: NULL;
426: -- Custom Code by developer Update_Minor_Version(p_rctv_rec.dnz_chr_id);
427: END IF;
428:

Line 434: Okl_Api.set_message(p_app_name => g_app_name,

430: WHEN G_EXCEPTION_HALT_VALIDATION THEN
431: NULL;
432:
433: WHEN OTHERS THEN
434: Okl_Api.set_message(p_app_name => g_app_name,
435: p_msg_name => g_unexpected_error,
436: p_token1 => g_sqlcode_token,
437: p_token1_value => SQLCODE,
438: p_token2 => g_sqlerrm_token,

Line 440: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

436: p_token1 => g_sqlcode_token,
437: p_token1_value => SQLCODE,
438: p_token2 => g_sqlerrm_token,
439: p_token2_value => SQLERRM);
440: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
441: END delete_internal_trans;
442:
443: PROCEDURE delete_internal_trans(
444: p_api_version IN NUMBER,

Line 445: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

441: END delete_internal_trans;
442:
443: PROCEDURE delete_internal_trans(
444: p_api_version IN NUMBER,
445: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
446: x_return_status OUT NOCOPY VARCHAR2,
447: x_msg_count OUT NOCOPY NUMBER,
448: x_msg_data OUT NOCOPY VARCHAR2,
449: p_rctv_tbl IN rctv_tbl_type) IS

Line 451: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

447: x_msg_count OUT NOCOPY NUMBER,
448: x_msg_data OUT NOCOPY VARCHAR2,
449: p_rctv_tbl IN rctv_tbl_type) IS
450: i NUMBER :=0;
451: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
452: BEGIN
453: --Initialize the return status
454: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
455:

Line 454: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

450: i NUMBER :=0;
451: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
452: BEGIN
453: --Initialize the return status
454: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
455:
456: IF (p_rctv_tbl.COUNT > 0) THEN
457: i := p_rctv_tbl.FIRST;
458: LOOP

Line 470: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

466: EXIT WHEN (i = p_rctv_tbl.LAST);
467: i := p_rctv_tbl.NEXT(i);
468: END LOOP;
469: END IF;
470: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
471: RAISE G_EXCEPTION_HALT_VALIDATION;
472: ELSE
473: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
474: l_return_status := x_return_status;

Line 473: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

469: END IF;
470: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
471: RAISE G_EXCEPTION_HALT_VALIDATION;
472: ELSE
473: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
474: l_return_status := x_return_status;
475: END IF;
476: END IF;
477: EXCEPTION

Line 482: Okl_Api.set_message(p_app_name => g_app_name,

478: WHEN G_EXCEPTION_HALT_VALIDATION THEN
479: NULL;
480:
481: WHEN OTHERS THEN
482: Okl_Api.set_message(p_app_name => g_app_name,
483: p_msg_name => g_unexpected_error,
484: p_token1 => g_sqlcode_token,
485: p_token1_value => SQLCODE,
486: p_token2 => g_sqlerrm_token,

Line 488: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

484: p_token1 => g_sqlcode_token,
485: p_token1_value => SQLCODE,
486: p_token2 => g_sqlerrm_token,
487: p_token2_value => SQLERRM);
488: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
489: END delete_internal_trans;
490:
491: PROCEDURE validate_internal_trans(
492: p_api_version IN NUMBER,

Line 493: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

489: END delete_internal_trans;
490:
491: PROCEDURE validate_internal_trans(
492: p_api_version IN NUMBER,
493: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_count OUT NOCOPY NUMBER,
496: x_msg_data OUT NOCOPY VARCHAR2,
497: p_rctv_rec IN rctv_rec_type) IS

Line 510: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

506: END validate_internal_trans;
507:
508: PROCEDURE validate_internal_trans(
509: p_api_version IN NUMBER,
510: p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rctv_tbl IN rctv_tbl_type) IS

Line 527: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

523: END validate_internal_trans;
524:
525: PROCEDURE create_internal_trans(
526: p_api_version IN NUMBER,
527: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
528: x_return_status OUT NOCOPY VARCHAR2,
529: x_msg_count OUT NOCOPY NUMBER,
530: x_msg_data OUT NOCOPY VARCHAR2,
531: p_rcav_rec IN rcav_rec_type,

Line 543: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

539: x_msg_data,
540: p_rcav_rec,
541: x_rcav_rec);
542:
543: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
544: NULL;
545: -- Custom code by developer Update_Minor_Version(p_rcav_rec.dnz_chr_id);
546: END IF;
547:

Line 552: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

548: END create_internal_trans;
549:
550: PROCEDURE create_internal_trans(
551: p_api_version IN NUMBER,
552: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: x_msg_data OUT NOCOPY VARCHAR2,
556: p_rcav_tbl IN rcav_tbl_type,

Line 571: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

567: END create_internal_trans;
568:
569: PROCEDURE lock_internal_trans(
570: p_api_version IN NUMBER,
571: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
572: x_return_status OUT NOCOPY VARCHAR2,
573: x_msg_count OUT NOCOPY NUMBER,
574: x_msg_data OUT NOCOPY VARCHAR2,
575: p_rcav_rec IN rcav_rec_type) IS

Line 588: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

584: END lock_internal_trans;
585:
586: PROCEDURE lock_internal_trans(
587: p_api_version IN NUMBER,
588: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
589: x_return_status OUT NOCOPY VARCHAR2,
590: x_msg_count OUT NOCOPY NUMBER,
591: x_msg_data OUT NOCOPY VARCHAR2,
592: p_rcav_tbl IN rcav_tbl_type) IS

Line 605: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

601: END lock_internal_trans;
602:
603: PROCEDURE update_internal_trans(
604: p_api_version IN NUMBER,
605: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
606: x_return_status OUT NOCOPY VARCHAR2,
607: x_msg_count OUT NOCOPY NUMBER,
608: x_msg_data OUT NOCOPY VARCHAR2,
609: p_rcav_rec IN rcav_rec_type,

Line 621: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

617: x_msg_data,
618: p_rcav_rec,
619: x_rcav_rec);
620:
621: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
622: NULL;
623: -- Custom code by developer Update_Minor_Version(p_rcav_rec.dnz_chr_id);
624: END IF;
625: END update_internal_trans;

Line 629: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

625: END update_internal_trans;
626:
627: PROCEDURE update_internal_trans(
628: p_api_version IN NUMBER,
629: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
630: x_return_status OUT NOCOPY VARCHAR2,
631: x_msg_count OUT NOCOPY NUMBER,
632: x_msg_data OUT NOCOPY VARCHAR2,
633: p_rcav_tbl IN rcav_tbl_type,

Line 649: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

645:
646: --Put custom code for cascade delete by developer
647: PROCEDURE delete_internal_trans(
648: p_api_version IN NUMBER,
649: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
650: x_return_status OUT NOCOPY VARCHAR2,
651: x_msg_count OUT NOCOPY NUMBER,
652: x_msg_data OUT NOCOPY VARCHAR2,
653: p_rcav_rec IN rcav_rec_type) IS

Line 655: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

651: x_msg_count OUT NOCOPY NUMBER,
652: x_msg_data OUT NOCOPY VARCHAR2,
653: p_rcav_rec IN rcav_rec_type) IS
654: i NUMBER :=0;
655: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
656: BEGIN
657: --Delete the Master
658: Okl_Rca_Pvt.delete_row(
659: p_api_version,

Line 665: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

661: x_return_status,
662: x_msg_count,
663: x_msg_data,
664: p_rcav_rec);
665: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
666: RAISE G_EXCEPTION_HALT_VALIDATION;
667: ELSE
668: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
669: l_return_status := x_return_status;

Line 668: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

664: p_rcav_rec);
665: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
666: RAISE G_EXCEPTION_HALT_VALIDATION;
667: ELSE
668: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
669: l_return_status := x_return_status;
670: END IF;
671: END IF;
672: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

Line 672: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

668: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
669: l_return_status := x_return_status;
670: END IF;
671: END IF;
672: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
673: NULL;
674: -- Custom Code by developer Update_Minor_Version(p_rcav_rec.dnz_chr_id);
675: END IF;
676:

Line 682: Okl_Api.set_message(p_app_name => g_app_name,

678: WHEN G_EXCEPTION_HALT_VALIDATION THEN
679: NULL;
680:
681: WHEN OTHERS THEN
682: Okl_Api.set_message(p_app_name => g_app_name,
683: p_msg_name => g_unexpected_error,
684: p_token1 => g_sqlcode_token,
685: p_token1_value => SQLCODE,
686: p_token2 => g_sqlerrm_token,

Line 688: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

684: p_token1 => g_sqlcode_token,
685: p_token1_value => SQLCODE,
686: p_token2 => g_sqlerrm_token,
687: p_token2_value => SQLERRM);
688: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
689: END delete_internal_trans;
690:
691: PROCEDURE delete_internal_trans(
692: p_api_version IN NUMBER,

Line 693: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

689: END delete_internal_trans;
690:
691: PROCEDURE delete_internal_trans(
692: p_api_version IN NUMBER,
693: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
694: x_return_status OUT NOCOPY VARCHAR2,
695: x_msg_count OUT NOCOPY NUMBER,
696: x_msg_data OUT NOCOPY VARCHAR2,
697: p_rcav_tbl IN rcav_tbl_type) IS

Line 699: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

695: x_msg_count OUT NOCOPY NUMBER,
696: x_msg_data OUT NOCOPY VARCHAR2,
697: p_rcav_tbl IN rcav_tbl_type) IS
698: i NUMBER :=0;
699: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
700: BEGIN
701: --Initialize the return status
702: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
703:

Line 702: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

698: i NUMBER :=0;
699: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
700: BEGIN
701: --Initialize the return status
702: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
703:
704: IF (p_rcav_tbl.COUNT > 0) THEN
705: i := p_rcav_tbl.FIRST;
706: LOOP

Line 718: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

714: EXIT WHEN (i = p_rcav_tbl.LAST);
715: i := p_rcav_tbl.NEXT(i);
716: END LOOP;
717: END IF;
718: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
719: RAISE G_EXCEPTION_HALT_VALIDATION;
720: ELSE
721: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
722: l_return_status := x_return_status;

Line 721: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

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

Line 730: Okl_Api.set_message(p_app_name => g_app_name,

726: WHEN G_EXCEPTION_HALT_VALIDATION THEN
727: NULL;
728:
729: WHEN OTHERS THEN
730: Okl_Api.set_message(p_app_name => g_app_name,
731: p_msg_name => g_unexpected_error,
732: p_token1 => g_sqlcode_token,
733: p_token1_value => SQLCODE,
734: p_token2 => g_sqlerrm_token,

Line 736: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

732: p_token1 => g_sqlcode_token,
733: p_token1_value => SQLCODE,
734: p_token2 => g_sqlerrm_token,
735: p_token2_value => SQLERRM);
736: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
737: END delete_internal_trans;
738:
739: PROCEDURE validate_internal_trans(
740: p_api_version IN NUMBER,

Line 741: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

737: END delete_internal_trans;
738:
739: PROCEDURE validate_internal_trans(
740: p_api_version IN NUMBER,
741: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_rcav_rec IN rcav_rec_type) IS

Line 758: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

754: END validate_internal_trans;
755:
756: PROCEDURE validate_internal_trans(
757: p_api_version IN NUMBER,
758: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
759: x_return_status OUT NOCOPY VARCHAR2,
760: x_msg_count OUT NOCOPY NUMBER,
761: x_msg_data OUT NOCOPY VARCHAR2,
762: p_rcav_tbl IN rcav_tbl_type) IS