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

Line 7: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3:
4: --Object type procedure for insert
5: PROCEDURE create_acc_gen_rule(
6: p_api_version IN NUMBER
7: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
8: ,x_return_status OUT NOCOPY VARCHAR2
9: ,x_msg_count OUT NOCOPY NUMBER
10: ,x_msg_data OUT NOCOPY VARCHAR2
11: ,p_agrv_rec IN agrv_rec_type

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

15: )
16: IS
17: i NUMBER;
18: l_agrv_rec agrv_rec_type;
19: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20: l_aulv_tbl aulv_tbl_type := p_aulv_tbl;
21:
22: BEGIN
23:

Line 35: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

31: ,x_msg_data
32: ,p_agrv_rec
33: ,x_agrv_rec);
34:
35: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
36:
37: -- populate the foreign key for the detail
38: IF (l_aulv_tbl.COUNT > 0) THEN
39: i:= l_aulv_tbl.FIRST;

Line 66: OKC_API.SET_MESSAGE(p_app_name => g_app_name

62: WHEN G_EXCEPTION_HALT_VALIDATION THEN
63: NULL;
64:
65: WHEN OTHERS THEN
66: OKC_API.SET_MESSAGE(p_app_name => g_app_name
67: ,p_msg_name => g_unexpected_error
68: ,p_token1 => g_sqlcode_token
69: ,p_token1_value => SQLCODE
70: ,p_token2 => g_sqlerrm_token

Line 72: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

68: ,p_token1 => g_sqlcode_token
69: ,p_token1_value => SQLCODE
70: ,p_token2 => g_sqlerrm_token
71: ,p_token2_value => SQLERRM);
72: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
73: END create_acc_gen_rule;
74:
75:
76: --Object type procedure for update

Line 79: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

75:
76: --Object type procedure for update
77: PROCEDURE update_acc_gen_rule(
78: p_api_version IN NUMBER
79: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
80: ,x_return_status OUT NOCOPY VARCHAR2
81: ,x_msg_count OUT NOCOPY NUMBER
82: ,x_msg_data OUT NOCOPY VARCHAR2
83: ,p_agrv_rec IN agrv_rec_type

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

85: ,x_agrv_rec OUT NOCOPY agrv_rec_type
86: ,x_aulv_tbl OUT NOCOPY aulv_tbl_type
87: )
88: IS
89: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
90: BEGIN
91: -- Update the master
92: update_acc_gen_rule(
93: p_api_version

Line 102: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

98: ,p_agrv_rec
99: ,x_agrv_rec);
100:
101:
102: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
103:
104: -- Update the detail
105: update_acc_gen_rule_lns(
106: p_api_version

Line 121: OKC_API.SET_MESSAGE(p_app_name => g_app_name

117: WHEN G_EXCEPTION_HALT_VALIDATION THEN
118: NULL;
119:
120: WHEN OTHERS THEN
121: OKC_API.SET_MESSAGE(p_app_name => g_app_name
122: ,p_msg_name => g_unexpected_error
123: ,p_token1 => g_sqlcode_token
124: ,p_token1_value => SQLCODE
125: ,p_token2 => g_sqlerrm_token

Line 127: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

123: ,p_token1 => g_sqlcode_token
124: ,p_token1_value => SQLCODE
125: ,p_token2 => g_sqlerrm_token
126: ,p_token2_value => SQLERRM);
127: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
128: END update_acc_gen_rule;
129:
130:
131: --Object type procedure for validate

Line 134: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

130:
131: --Object type procedure for validate
132: PROCEDURE validate_acc_gen_rule(
133: p_api_version IN NUMBER
134: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
135: ,x_return_status OUT NOCOPY VARCHAR2
136: ,x_msg_count OUT NOCOPY NUMBER
137: ,x_msg_data OUT NOCOPY VARCHAR2
138: ,p_agrv_rec IN agrv_rec_type

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

138: ,p_agrv_rec IN agrv_rec_type
139: ,p_aulv_tbl IN aulv_tbl_type
140: )
141: IS
142: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
143: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
144: BEGIN
145:
146: -- Validate the master

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

139: ,p_aulv_tbl IN aulv_tbl_type
140: )
141: IS
142: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
143: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
144: BEGIN
145:
146: -- Validate the master
147: validate_acc_gen_rule(

Line 155: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

151: ,x_msg_count
152: ,x_msg_data
153: ,p_agrv_rec);
154:
155: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
156: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
157: l_overall_status := x_return_status;
158: END IF;
159: END IF;

Line 156: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

152: ,x_msg_data
153: ,p_agrv_rec);
154:
155: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
156: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
157: l_overall_status := x_return_status;
158: END IF;
159: END IF;
160:

Line 171: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

167: ,x_msg_count
168: ,x_msg_data
169: ,p_aulv_tbl);
170:
171: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
172: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
173: l_overall_status := x_return_status;
174: END IF;
175: END IF;

Line 172: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

168: ,x_msg_data
169: ,p_aulv_tbl);
170:
171: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
172: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
173: l_overall_status := x_return_status;
174: END IF;
175: END IF;
176:

Line 184: OKC_API.SET_MESSAGE(p_app_name => g_app_name

180: EXCEPTION
181: WHEN G_EXCEPTION_HALT_VALIDATION THEN
182: NULL;
183: WHEN OTHERS THEN
184: OKC_API.SET_MESSAGE(p_app_name => g_app_name
185: ,p_msg_name => g_unexpected_error
186: ,p_token1 => g_sqlcode_token
187: ,p_token1_value => SQLCODE
188: ,p_token2 => g_sqlerrm_token

Line 190: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

186: ,p_token1 => g_sqlcode_token
187: ,p_token1_value => SQLCODE
188: ,p_token2 => g_sqlerrm_token
189: ,p_token2_value => SQLERRM);
190: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
191:
192:
193:
194: END validate_acc_gen_rule;

Line 199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

195:
196:
197: PROCEDURE create_acc_gen_rule(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_agrv_rec IN agrv_rec_type,

Line 215: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

211: x_msg_data,
212: p_agrv_rec,
213: x_agrv_rec);
214:
215: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
216: NULL;
217: -- Custom code by developer Update_Minor_Version(p_agrv_rec.dnz_chr_id);
218: END IF;
219:

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

220: END create_acc_gen_rule;
221:
222: PROCEDURE create_acc_gen_rule(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_agrv_tbl IN agrv_tbl_type,

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

227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_agrv_tbl IN agrv_tbl_type,
229: x_agrv_tbl OUT NOCOPY agrv_tbl_type) IS
230:
231: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
232: i NUMBER := 0;
233:
234: BEGIN
235:

Line 236: OKC_API.init_msg_list(p_init_msg_list);

232: i NUMBER := 0;
233:
234: BEGIN
235:
236: OKC_API.init_msg_list(p_init_msg_list);
237: -- Make sure PL/SQL table has records in it before passing
238: IF (p_agrv_tbl.COUNT > 0) THEN
239: i := p_agrv_tbl.FIRST;
240: LOOP

Line 243: p_init_msg_list => OKC_API.G_FALSE,

239: i := p_agrv_tbl.FIRST;
240: LOOP
241: create_acc_gen_rule(
242: p_api_version => p_api_version,
243: p_init_msg_list => OKC_API.G_FALSE,
244: x_return_status => x_return_status,
245: x_msg_count => x_msg_count,
246: x_msg_data => x_msg_data,
247: p_agrv_rec => p_agrv_tbl(i),

Line 250: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

246: x_msg_data => x_msg_data,
247: p_agrv_rec => p_agrv_tbl(i),
248: x_agrv_rec => x_agrv_tbl(i));
249:
250: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
251: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
252: l_overall_status := x_return_status;
253: END IF;
254: END IF;

Line 251: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

247: p_agrv_rec => p_agrv_tbl(i),
248: x_agrv_rec => x_agrv_tbl(i));
249:
250: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
251: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
252: l_overall_status := x_return_status;
253: END IF;
254: END IF;
255:

Line 268: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

264:
265:
266: PROCEDURE lock_acc_gen_rule(
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272: p_agrv_rec IN agrv_rec_type) IS

Line 285: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

281: END lock_acc_gen_rule;
282:
283: PROCEDURE lock_acc_gen_rule(
284: p_api_version IN NUMBER,
285: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
289: p_agrv_tbl IN agrv_tbl_type) IS

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

287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
289: p_agrv_tbl IN agrv_tbl_type) IS
290:
291: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
292: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
293: i NUMBER := 0;
294: BEGIN
295: OKC_API.init_msg_list(p_init_msg_list);

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

288: x_msg_data OUT NOCOPY VARCHAR2,
289: p_agrv_tbl IN agrv_tbl_type) IS
290:
291: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
292: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
293: i NUMBER := 0;
294: BEGIN
295: OKC_API.init_msg_list(p_init_msg_list);
296: -- Make sure PL/SQL table has records in it before passing

Line 295: OKC_API.init_msg_list(p_init_msg_list);

291: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
292: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
293: i NUMBER := 0;
294: BEGIN
295: OKC_API.init_msg_list(p_init_msg_list);
296: -- Make sure PL/SQL table has records in it before passing
297: IF (p_agrv_tbl.COUNT > 0) THEN
298: i := p_agrv_tbl.FIRST;
299: LOOP

Line 302: p_init_msg_list => OKC_API.G_FALSE,

298: i := p_agrv_tbl.FIRST;
299: LOOP
300: lock_acc_gen_rule(
301: p_api_version => p_api_version,
302: p_init_msg_list => OKC_API.G_FALSE,
303: x_return_status => x_return_status,
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data,
306: p_agrv_rec => p_agrv_tbl(i));

Line 308: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data,
306: p_agrv_rec => p_agrv_tbl(i));
307:
308: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
309: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
310: l_overall_status := x_return_status;
311: END IF;
312: END IF;

Line 309: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

305: x_msg_data => x_msg_data,
306: p_agrv_rec => p_agrv_tbl(i));
307:
308: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
309: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
310: l_overall_status := x_return_status;
311: END IF;
312: END IF;
313:

Line 324: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

320: END lock_acc_gen_rule;
321:
322: PROCEDURE update_acc_gen_rule(
323: p_api_version IN NUMBER,
324: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,
328: p_agrv_rec IN agrv_rec_type,

Line 340: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

336: x_msg_data,
337: p_agrv_rec,
338: x_agrv_rec);
339:
340: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
341: NULL;
342: -- Custom code by developer Update_Minor_Version(p_agrv_rec.dnz_chr_id);
343: END IF;
344: END update_acc_gen_rule;

Line 348: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

344: END update_acc_gen_rule;
345:
346: PROCEDURE update_acc_gen_rule(
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,
351: x_msg_data OUT NOCOPY VARCHAR2,
352: p_agrv_tbl IN agrv_tbl_type,

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

351: x_msg_data OUT NOCOPY VARCHAR2,
352: p_agrv_tbl IN agrv_tbl_type,
353: x_agrv_tbl OUT NOCOPY agrv_tbl_type) IS
354:
355: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
356: i NUMBER := 0;
357:
358: BEGIN
359: OKC_API.init_msg_list(p_init_msg_list);

Line 359: OKC_API.init_msg_list(p_init_msg_list);

355: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
356: i NUMBER := 0;
357:
358: BEGIN
359: OKC_API.init_msg_list(p_init_msg_list);
360: -- Make sure PL/SQL table has records in it before passing
361: IF (p_agrv_tbl.COUNT > 0) THEN
362: i := p_agrv_tbl.FIRST;
363: LOOP

Line 366: p_init_msg_list => OKC_API.G_FALSE,

362: i := p_agrv_tbl.FIRST;
363: LOOP
364: update_acc_gen_rule(
365: p_api_version => p_api_version,
366: p_init_msg_list => OKC_API.G_FALSE,
367: x_return_status => x_return_status,
368: x_msg_count => x_msg_count,
369: x_msg_data => x_msg_data,
370: p_agrv_rec => p_agrv_tbl(i),

Line 373: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

369: x_msg_data => x_msg_data,
370: p_agrv_rec => p_agrv_tbl(i),
371: x_agrv_rec => x_agrv_tbl(i));
372:
373: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
374: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
375: l_overall_status := x_return_status;
376: END IF;
377: END IF;

Line 374: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

370: p_agrv_rec => p_agrv_tbl(i),
371: x_agrv_rec => x_agrv_tbl(i));
372:
373: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
374: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
375: l_overall_status := x_return_status;
376: END IF;
377: END IF;
378: EXIT WHEN (i = p_agrv_tbl.LAST);

Line 389: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

385:
386: --Put custom code for cascade delete by developer
387: PROCEDURE delete_acc_gen_rule(
388: p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
390: x_return_status OUT NOCOPY VARCHAR2,
391: x_msg_count OUT NOCOPY NUMBER,
392: x_msg_data OUT NOCOPY VARCHAR2,
393: p_agrv_rec IN agrv_rec_type) IS

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

391: x_msg_count OUT NOCOPY NUMBER,
392: x_msg_data OUT NOCOPY VARCHAR2,
393: p_agrv_rec IN agrv_rec_type) IS
394: i NUMBER :=0;
395: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
396:
397: CURSOR rule_line_csr(p_agr_id IN NUMBER)
398: IS
399: SELECT id

Line 423: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

419: ,x_msg_count
420: ,x_msg_data
421: ,l_rule_line_tbl);
422:
423: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
424:
425: okl_agr_pvt.delete_row(
426: p_api_version,
427: p_init_msg_list,

Line 441: OKC_API.set_message(p_app_name => g_app_name,

437: WHEN G_EXCEPTION_HALT_VALIDATION THEN
438: NULL;
439:
440: WHEN OTHERS THEN
441: OKC_API.set_message(p_app_name => g_app_name,
442: p_msg_name => g_unexpected_error,
443: p_token1 => g_sqlcode_token,
444: p_token1_value => SQLCODE,
445: p_token2 => g_sqlerrm_token,

Line 447: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

443: p_token1 => g_sqlcode_token,
444: p_token1_value => SQLCODE,
445: p_token2 => g_sqlerrm_token,
446: p_token2_value => SQLERRM);
447: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
448: END delete_acc_gen_rule;
449:
450:
451: PROCEDURE delete_acc_gen_rule(

Line 453: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

449:
450:
451: PROCEDURE delete_acc_gen_rule(
452: p_api_version IN NUMBER,
453: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
454: x_return_status OUT NOCOPY VARCHAR2,
455: x_msg_count OUT NOCOPY NUMBER,
456: x_msg_data OUT NOCOPY VARCHAR2,
457: p_agrv_tbl IN agrv_tbl_type) IS

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

455: x_msg_count OUT NOCOPY NUMBER,
456: x_msg_data OUT NOCOPY VARCHAR2,
457: p_agrv_tbl IN agrv_tbl_type) IS
458: i NUMBER :=0;
459: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
460: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
461:
462: BEGIN
463: --Initialize the return status

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

456: x_msg_data OUT NOCOPY VARCHAR2,
457: p_agrv_tbl IN agrv_tbl_type) IS
458: i NUMBER :=0;
459: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
460: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
461:
462: BEGIN
463: --Initialize the return status
464: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 464: x_return_status := OKC_API.G_RET_STS_SUCCESS;

460: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
461:
462: BEGIN
463: --Initialize the return status
464: x_return_status := OKC_API.G_RET_STS_SUCCESS;
465:
466: IF (p_agrv_tbl.COUNT > 0) THEN
467: i := p_agrv_tbl.FIRST;
468: LOOP

Line 477: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

473: ,x_msg_count
474: ,x_msg_data
475: ,p_agrv_tbl(i));
476:
477: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
478: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
479: l_overall_status := x_return_status;
480: END IF;
481: END IF;

Line 478: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

474: ,x_msg_data
475: ,p_agrv_tbl(i));
476:
477: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
478: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
479: l_overall_status := x_return_status;
480: END IF;
481: END IF;
482:

Line 496: OKC_API.set_message(p_app_name => g_app_name,

492: WHEN G_EXCEPTION_HALT_VALIDATION THEN
493: NULL;
494:
495: WHEN OTHERS THEN
496: OKC_API.set_message(p_app_name => g_app_name,
497: p_msg_name => g_unexpected_error,
498: p_token1 => g_sqlcode_token,
499: p_token1_value => SQLCODE,
500: p_token2 => g_sqlerrm_token,

Line 502: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

498: p_token1 => g_sqlcode_token,
499: p_token1_value => SQLCODE,
500: p_token2 => g_sqlerrm_token,
501: p_token2_value => SQLERRM);
502: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
503: END delete_acc_gen_rule;
504:
505: PROCEDURE validate_acc_gen_rule(
506: p_api_version IN NUMBER,

Line 507: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

503: END delete_acc_gen_rule;
504:
505: PROCEDURE validate_acc_gen_rule(
506: p_api_version IN NUMBER,
507: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
508: x_return_status OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,
510: x_msg_data OUT NOCOPY VARCHAR2,
511: p_agrv_rec IN agrv_rec_type) IS

Line 524: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

520: END validate_acc_gen_rule;
521:
522: PROCEDURE validate_acc_gen_rule(
523: p_api_version IN NUMBER,
524: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
525: x_return_status OUT NOCOPY VARCHAR2,
526: x_msg_count OUT NOCOPY NUMBER,
527: x_msg_data OUT NOCOPY VARCHAR2,
528: p_agrv_tbl IN agrv_tbl_type) IS

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

526: x_msg_count OUT NOCOPY NUMBER,
527: x_msg_data OUT NOCOPY VARCHAR2,
528: p_agrv_tbl IN agrv_tbl_type) IS
529:
530: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
531: i NUMBER := 0;
532:
533: BEGIN
534: OKC_API.init_msg_list(p_init_msg_list);

Line 534: OKC_API.init_msg_list(p_init_msg_list);

530: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
531: i NUMBER := 0;
532:
533: BEGIN
534: OKC_API.init_msg_list(p_init_msg_list);
535: -- Make sure PL/SQL table has records in it before passing
536: IF (p_agrv_tbl.COUNT > 0) THEN
537: i := p_agrv_tbl.FIRST;
538: LOOP

Line 541: p_init_msg_list => OKC_API.G_FALSE,

537: i := p_agrv_tbl.FIRST;
538: LOOP
539: validate_acc_gen_rule(
540: p_api_version => p_api_version,
541: p_init_msg_list => OKC_API.G_FALSE,
542: x_return_status => x_return_status,
543: x_msg_count => x_msg_count,
544: x_msg_data => x_msg_data,
545: p_agrv_rec => p_agrv_tbl(i));

Line 547: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

543: x_msg_count => x_msg_count,
544: x_msg_data => x_msg_data,
545: p_agrv_rec => p_agrv_tbl(i));
546:
547: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
548: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
549: l_overall_status := x_return_status;
550: END IF;
551:

Line 548: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

544: x_msg_data => x_msg_data,
545: p_agrv_rec => p_agrv_tbl(i));
546:
547: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
548: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
549: l_overall_status := x_return_status;
550: END IF;
551:
552: END IF;

Line 563: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

559: END validate_acc_gen_rule;
560:
561: PROCEDURE create_acc_gen_rule_lns(
562: p_api_version IN NUMBER,
563: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
564: x_return_status OUT NOCOPY VARCHAR2,
565: x_msg_count OUT NOCOPY NUMBER,
566: x_msg_data OUT NOCOPY VARCHAR2,
567: p_aulv_rec IN aulv_rec_type,

Line 579: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

575: x_msg_data,
576: p_aulv_rec,
577: x_aulv_rec);
578:
579: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
580: NULL;
581: -- Custom code by developer Update_Minor_Version(p_aulv_rec.dnz_chr_id);
582: END IF;
583:

Line 588: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

584: END create_acc_gen_rule_lns;
585:
586: PROCEDURE create_acc_gen_rule_lns(
587: p_api_version IN NUMBER,
588: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_aulv_tbl IN aulv_tbl_type,

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

591: x_msg_data OUT NOCOPY VARCHAR2,
592: p_aulv_tbl IN aulv_tbl_type,
593: x_aulv_tbl OUT NOCOPY aulv_tbl_type) IS
594:
595: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
596: i NUMBER := 0;
597: BEGIN
598: OKC_API.init_msg_list(p_init_msg_list);
599: -- Make sure PL/SQL table has records in it before passing

Line 598: OKC_API.init_msg_list(p_init_msg_list);

594:
595: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
596: i NUMBER := 0;
597: BEGIN
598: OKC_API.init_msg_list(p_init_msg_list);
599: -- Make sure PL/SQL table has records in it before passing
600: IF (p_aulv_tbl.COUNT > 0) THEN
601: i := p_aulv_tbl.FIRST;
602: LOOP

Line 605: p_init_msg_list => OKC_API.G_FALSE,

601: i := p_aulv_tbl.FIRST;
602: LOOP
603: create_acc_gen_rule_lns(
604: p_api_version => p_api_version,
605: p_init_msg_list => OKC_API.G_FALSE,
606: x_return_status => x_return_status,
607: x_msg_count => x_msg_count,
608: x_msg_data => x_msg_data,
609: p_aulv_rec => p_aulv_tbl(i),

Line 612: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

608: x_msg_data => x_msg_data,
609: p_aulv_rec => p_aulv_tbl(i),
610: x_aulv_rec => x_aulv_tbl(i));
611:
612: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
613: l_overall_status := x_return_status;
614: EXIT;
615: END IF;
616:

Line 630: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

626: END create_acc_gen_rule_lns;
627:
628: PROCEDURE lock_acc_gen_rule_lns(
629: p_api_version IN NUMBER,
630: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
631: x_return_status OUT NOCOPY VARCHAR2,
632: x_msg_count OUT NOCOPY NUMBER,
633: x_msg_data OUT NOCOPY VARCHAR2,
634: p_aulv_rec IN aulv_rec_type) IS

Line 647: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

643: END lock_acc_gen_rule_lns;
644:
645: PROCEDURE lock_acc_gen_rule_lns(
646: p_api_version IN NUMBER,
647: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
648: x_return_status OUT NOCOPY VARCHAR2,
649: x_msg_count OUT NOCOPY NUMBER,
650: x_msg_data OUT NOCOPY VARCHAR2,
651: p_aulv_tbl IN aulv_tbl_type) IS

Line 652: l_overall_Status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

648: x_return_status OUT NOCOPY VARCHAR2,
649: x_msg_count OUT NOCOPY NUMBER,
650: x_msg_data OUT NOCOPY VARCHAR2,
651: p_aulv_tbl IN aulv_tbl_type) IS
652: l_overall_Status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
653: i NUMBER := 0;
654: BEGIN
655: OKC_API.init_msg_list(p_init_msg_list);
656: -- Make sure PL/SQL table has records in it before passing

Line 655: OKC_API.init_msg_list(p_init_msg_list);

651: p_aulv_tbl IN aulv_tbl_type) IS
652: l_overall_Status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
653: i NUMBER := 0;
654: BEGIN
655: OKC_API.init_msg_list(p_init_msg_list);
656: -- Make sure PL/SQL table has records in it before passing
657: IF (p_aulv_tbl.COUNT > 0) THEN
658: i := p_aulv_tbl.FIRST;
659: LOOP

Line 662: p_init_msg_list => OKC_API.G_FALSE,

658: i := p_aulv_tbl.FIRST;
659: LOOP
660: lock_acc_gen_rule_lns(
661: p_api_version => p_api_version,
662: p_init_msg_list => OKC_API.G_FALSE,
663: x_return_status => x_return_status,
664: x_msg_count => x_msg_count,
665: x_msg_data => x_msg_data,
666: p_aulv_rec => p_aulv_tbl(i));

Line 668: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

664: x_msg_count => x_msg_count,
665: x_msg_data => x_msg_data,
666: p_aulv_rec => p_aulv_tbl(i));
667:
668: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
669:
670: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
671: l_overall_status := x_return_status;
672: END IF;

Line 670: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

666: p_aulv_rec => p_aulv_tbl(i));
667:
668: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
669:
670: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
671: l_overall_status := x_return_status;
672: END IF;
673:
674: END IF;

Line 685: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

681: END lock_acc_gen_rule_lns;
682:
683: PROCEDURE update_acc_gen_rule_lns(
684: p_api_version IN NUMBER,
685: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
686: x_return_status OUT NOCOPY VARCHAR2,
687: x_msg_count OUT NOCOPY NUMBER,
688: x_msg_data OUT NOCOPY VARCHAR2,
689: p_aulv_rec IN aulv_rec_type,

Line 705: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

701: x_aulv_rec);
702:
703: -- RAISE_APPLICATION_ERROR (-20001, 'Return Status in acc gen pvtTTTTTTTTTT' || x_return_status);
704:
705: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
706: NULL;
707: -- Custom code by developer Update_Minor_Version(p_aulv_rec.dnz_chr_id);
708: END IF;
709: END update_acc_gen_rule_lns;

Line 713: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

709: END update_acc_gen_rule_lns;
710:
711: PROCEDURE update_acc_gen_rule_lns(
712: p_api_version IN NUMBER,
713: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
714: x_return_status OUT NOCOPY VARCHAR2,
715: x_msg_count OUT NOCOPY NUMBER,
716: x_msg_data OUT NOCOPY VARCHAR2,
717: p_aulv_tbl IN aulv_tbl_type,

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

716: x_msg_data OUT NOCOPY VARCHAR2,
717: p_aulv_tbl IN aulv_tbl_type,
718: x_aulv_tbl OUT NOCOPY aulv_tbl_type) IS
719:
720: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
721: i NUMBER := 0;
722: BEGIN
723: OKC_API.init_msg_list(p_init_msg_list);
724: -- Make sure PL/SQL table has records in it before passing

Line 723: OKC_API.init_msg_list(p_init_msg_list);

719:
720: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
721: i NUMBER := 0;
722: BEGIN
723: OKC_API.init_msg_list(p_init_msg_list);
724: -- Make sure PL/SQL table has records in it before passing
725: IF (p_aulv_tbl.COUNT > 0) THEN
726: i := p_aulv_tbl.FIRST;
727: LOOP

Line 730: p_init_msg_list => OKC_API.G_FALSE,

726: i := p_aulv_tbl.FIRST;
727: LOOP
728: update_acc_gen_rule_lns(
729: p_api_version => p_api_version,
730: p_init_msg_list => OKC_API.G_FALSE,
731: x_return_status => x_return_status,
732: x_msg_count => x_msg_count,
733: x_msg_data => x_msg_data,
734: p_aulv_rec => p_aulv_tbl(i),

Line 737: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

733: x_msg_data => x_msg_data,
734: p_aulv_rec => p_aulv_tbl(i),
735: x_aulv_rec => x_aulv_tbl(i));
736:
737: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
738:
739: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
740: l_overall_status := x_return_status;
741: END IF;

Line 739: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

735: x_aulv_rec => x_aulv_tbl(i));
736:
737: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
738:
739: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
740: l_overall_status := x_return_status;
741: END IF;
742:
743: END IF;

Line 758: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

754: --Put custom code for cascade delete by developer
755:
756: PROCEDURE delete_acc_gen_rule_lns(
757: p_api_version IN NUMBER,
758: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_aulv_rec IN aulv_rec_type) IS

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

760: x_msg_count OUT NOCOPY NUMBER,
761: x_msg_data OUT NOCOPY VARCHAR2,
762: p_aulv_rec IN aulv_rec_type) IS
763: i NUMBER :=0;
764: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
765: BEGIN
766: --Delete the Master
767: okl_aul_pvt.delete_row(
768: p_api_version,

Line 781: OKC_API.set_message(p_app_name => g_app_name,

777: WHEN G_EXCEPTION_HALT_VALIDATION THEN
778: NULL;
779:
780: WHEN OTHERS THEN
781: OKC_API.set_message(p_app_name => g_app_name,
782: p_msg_name => g_unexpected_error,
783: p_token1 => g_sqlcode_token,
784: p_token1_value => SQLCODE,
785: p_token2 => g_sqlerrm_token,

Line 787: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

783: p_token1 => g_sqlcode_token,
784: p_token1_value => SQLCODE,
785: p_token2 => g_sqlerrm_token,
786: p_token2_value => SQLERRM);
787: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
788: END delete_acc_gen_rule_lns;
789:
790: PROCEDURE delete_acc_gen_rule_lns(
791: p_api_version IN NUMBER,

Line 792: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

788: END delete_acc_gen_rule_lns;
789:
790: PROCEDURE delete_acc_gen_rule_lns(
791: p_api_version IN NUMBER,
792: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
793: x_return_status OUT NOCOPY VARCHAR2,
794: x_msg_count OUT NOCOPY NUMBER,
795: x_msg_data OUT NOCOPY VARCHAR2,
796: p_aulv_tbl IN aulv_tbl_type) IS

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

794: x_msg_count OUT NOCOPY NUMBER,
795: x_msg_data OUT NOCOPY VARCHAR2,
796: p_aulv_tbl IN aulv_tbl_type) IS
797: i NUMBER :=0;
798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
799: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
800:
801: BEGIN
802: --Initialize the return status

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

795: x_msg_data OUT NOCOPY VARCHAR2,
796: p_aulv_tbl IN aulv_tbl_type) IS
797: i NUMBER :=0;
798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
799: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
800:
801: BEGIN
802: --Initialize the return status
803: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 803: x_return_status := OKC_API.G_RET_STS_SUCCESS;

799: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
800:
801: BEGIN
802: --Initialize the return status
803: x_return_status := OKC_API.G_RET_STS_SUCCESS;
804:
805: IF (p_aulv_tbl.COUNT > 0) THEN
806: i := p_aulv_tbl.FIRST;
807: LOOP

Line 816: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

812: x_msg_count,
813: x_msg_data,
814: p_aulv_tbl(i));
815:
816: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
817:
818: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
819: l_overall_status := x_return_status;
820: END IF;

Line 818: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

814: p_aulv_tbl(i));
815:
816: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
817:
818: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
819: l_overall_status := x_return_status;
820: END IF;
821:
822: END IF;

Line 836: OKC_API.set_message(p_app_name => g_app_name,

832: WHEN G_EXCEPTION_HALT_VALIDATION THEN
833: NULL;
834:
835: WHEN OTHERS THEN
836: OKC_API.set_message(p_app_name => g_app_name,
837: p_msg_name => g_unexpected_error,
838: p_token1 => g_sqlcode_token,
839: p_token1_value => SQLCODE,
840: p_token2 => g_sqlerrm_token,

Line 842: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

838: p_token1 => g_sqlcode_token,
839: p_token1_value => SQLCODE,
840: p_token2 => g_sqlerrm_token,
841: p_token2_value => SQLERRM);
842: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
843: END delete_acc_gen_rule_lns;
844:
845: PROCEDURE validate_acc_gen_rule_lns(
846: p_api_version IN NUMBER,

Line 847: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

843: END delete_acc_gen_rule_lns;
844:
845: PROCEDURE validate_acc_gen_rule_lns(
846: p_api_version IN NUMBER,
847: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
848: x_return_status OUT NOCOPY VARCHAR2,
849: x_msg_count OUT NOCOPY NUMBER,
850: x_msg_data OUT NOCOPY VARCHAR2,
851: p_aulv_rec IN aulv_rec_type) IS

Line 864: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

860: END validate_acc_gen_rule_lns;
861:
862: PROCEDURE validate_acc_gen_rule_lns(
863: p_api_version IN NUMBER,
864: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
865: x_return_status OUT NOCOPY VARCHAR2,
866: x_msg_count OUT NOCOPY NUMBER,
867: x_msg_data OUT NOCOPY VARCHAR2,
868: p_aulv_tbl IN aulv_tbl_type) IS

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

866: x_msg_count OUT NOCOPY NUMBER,
867: x_msg_data OUT NOCOPY VARCHAR2,
868: p_aulv_tbl IN aulv_tbl_type) IS
869:
870: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
871: i NUMBER := 0;
872: BEGIN
873: OKC_API.init_msg_list(p_init_msg_list);
874: -- Make sure PL/SQL table has records in it before passing

Line 873: OKC_API.init_msg_list(p_init_msg_list);

869:
870: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
871: i NUMBER := 0;
872: BEGIN
873: OKC_API.init_msg_list(p_init_msg_list);
874: -- Make sure PL/SQL table has records in it before passing
875: IF (p_aulv_tbl.COUNT > 0) THEN
876: i := p_aulv_tbl.FIRST;
877: LOOP

Line 880: p_init_msg_list => OKC_API.G_FALSE,

876: i := p_aulv_tbl.FIRST;
877: LOOP
878: validate_acc_gen_rule_lns(
879: p_api_version => p_api_version,
880: p_init_msg_list => OKC_API.G_FALSE,
881: x_return_status => x_return_status,
882: x_msg_count => x_msg_count,
883: x_msg_data => x_msg_data,
884: p_aulv_rec => p_aulv_tbl(i));

Line 886: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

882: x_msg_count => x_msg_count,
883: x_msg_data => x_msg_data,
884: p_aulv_rec => p_aulv_tbl(i));
885:
886: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
887: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
888: l_overall_status := x_return_status;
889: END IF;
890:

Line 887: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

883: x_msg_data => x_msg_data,
884: p_aulv_rec => p_aulv_tbl(i));
885:
886: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
887: IF (l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
888: l_overall_status := x_return_status;
889: END IF;
890:
891: END IF;