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

Line 15: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

11: WHERE currency_code = p_clgv_rec.currency_code;
12:
13: BEGIN
14: -- initialize return status
15: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
16:
17: -- data is required
18: IF(p_clgv_rec.currency_code IS NULL) OR (p_clgv_rec.currency_code = Okl_Api.G_MISS_CHAR) THEN
19: -- Message Text: Please enter all mandatory fields

Line 18: IF(p_clgv_rec.currency_code IS NULL) OR (p_clgv_rec.currency_code = Okl_Api.G_MISS_CHAR) THEN

14: -- initialize return status
15: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
16:
17: -- data is required
18: IF(p_clgv_rec.currency_code IS NULL) OR (p_clgv_rec.currency_code = Okl_Api.G_MISS_CHAR) THEN
19: -- Message Text: Please enter all mandatory fields
20: x_return_status := OKC_API.G_RET_STS_ERROR;
21: OKC_API.set_message( p_app_name => G_APP_NAME,
22: p_msg_name => 'OKL_BPD_MISSING_FIELDS');

Line 34: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

30: CLOSE l_clgv_csr;
31:
32: -- if l_dummy_var is still set to default, data was not found
33: IF(l_dummy_var = '?') THEN
34: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
35: p_msg_name => g_no_parent_record,
36: p_token1 => g_col_name_token,
37: p_token1_value => 'Currency',
38: p_token2 => g_child_table_token,

Line 44: x_return_status := Okl_Api.G_RET_STS_ERROR;

40: p_token3 => g_parent_table_token,
41: p_token3_value => 'FND_CURRENCIES_V');
42:
43: -- notify caller of an error
44: x_return_status := Okl_Api.G_RET_STS_ERROR;
45: END IF;
46:
47: EXCEPTION
48:

Line 55: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

51: x_return_status := OKC_API.G_RET_STS_ERROR;
52:
53: WHEN OTHERS THEN
54: -- store SQL error message on message stack for caller
55: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
56: p_msg_name => g_unexpected_error,
57: p_token1 => g_sqlcode_token,
58: p_token1_value => SQLCODE,
59: p_token2 => g_sqlerrm_token,

Line 64: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

60: p_token2_value => SQLERRM);
61:
62:
63: -- notify caller of an error
64: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
65:
66: -- verfiy that cursor was closed
67: IF l_clgv_csr%ISOPEN THEN
68: CLOSE l_clgv_csr;

Line 82: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

78: x_return_status OUT NOCOPY VARCHAR2) IS
79: l_exists NUMBER(1);
80: item_not_found_error EXCEPTION;
81: BEGIN
82: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
83: IF (p_clgv_rec.legal_entity_id IS NOT NULL) THEN
84: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_clgv_rec.legal_entity_id);
85: IF(l_exists <> 1) THEN
86: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');

Line 118: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

114: WHERE id = p_clgv_rec.ibt_id;
115:
116: BEGIN
117: -- initialize return status
118: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
119:
120: -- data is required
121: IF(p_clgv_rec.ibt_id IS NULL) OR (p_clgv_rec.ibt_id = Okl_Api.G_MISS_NUM) THEN
122: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

Line 121: IF(p_clgv_rec.ibt_id IS NULL) OR (p_clgv_rec.ibt_id = Okl_Api.G_MISS_NUM) THEN

117: -- initialize return status
118: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
119:
120: -- data is required
121: IF(p_clgv_rec.ibt_id IS NULL) OR (p_clgv_rec.ibt_id = Okl_Api.G_MISS_NUM) THEN
122: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
123: p_msg_name => g_required_value,
124: p_token1 => g_col_name_token,
125: p_token1_value => 'ibt_id');

Line 122: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

118: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
119:
120: -- data is required
121: IF(p_clgv_rec.ibt_id IS NULL) OR (p_clgv_rec.ibt_id = Okl_Api.G_MISS_NUM) THEN
122: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
123: p_msg_name => g_required_value,
124: p_token1 => g_col_name_token,
125: p_token1_value => 'ibt_id');
126:

Line 128: x_return_status := Okl_Api.G_RET_STS_ERROR;

124: p_token1 => g_col_name_token,
125: p_token1_value => 'ibt_id');
126:
127: -- notify caller of an error
128: x_return_status := Okl_Api.G_RET_STS_ERROR;
129:
130: -- halt further validation of this column
131: RAISE G_EXCEPTION_HALT_VALIDATION;
132: END IF;

Line 141: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

137: CLOSE l_ibt_csr;
138:
139: -- if l_dummy_var is still set to default, data was not found
140: IF(l_dummy_var = '?') THEN
141: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
142: p_msg_name => g_no_parent_record,
143: p_token1 => g_col_name_token,
144: p_token1_value => 'ibt_id',
145: p_token2 => g_child_table_token,

Line 151: x_return_status := Okl_Api.G_RET_STS_ERROR;

147: p_token3 => g_parent_table_token,
148: p_token3_value => 'OKX_BILL_TOS_V');
149:
150: -- notify caller of an error
151: x_return_status := Okl_Api.G_RET_STS_ERROR;
152: END IF;
153:
154: EXCEPTION
155:

Line 162: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

158: x_return_status := OKC_API.G_RET_STS_ERROR;
159:
160: WHEN OTHERS THEN
161: -- store SQL error message on message stack for caller
162: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
163: p_msg_name => g_unexpected_error,
164: p_token1 => g_sqlcode_token,
165: p_token1_value => SQLCODE,
166: p_token2 => g_sqlerrm_token,

Line 171: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

167: p_token2_value => SQLERRM);
168:
169:
170: -- notify caller of an error
171: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
172:
173: -- verfiy that cursor was closed
174: IF l_ibt_csr%ISOPEN THEN
175: CLOSE l_ibt_csr;

Line 193: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

189: WHERE id = p_clgv_rec.ica_id;
190:
191: BEGIN
192: -- initialize return status
193: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
194:
195: -- data is required
196: IF(p_clgv_rec.ica_id IS NULL) OR (p_clgv_rec.ica_id = Okl_Api.G_MISS_NUM) THEN
197: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

Line 196: IF(p_clgv_rec.ica_id IS NULL) OR (p_clgv_rec.ica_id = Okl_Api.G_MISS_NUM) THEN

192: -- initialize return status
193: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
194:
195: -- data is required
196: IF(p_clgv_rec.ica_id IS NULL) OR (p_clgv_rec.ica_id = Okl_Api.G_MISS_NUM) THEN
197: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
198: p_msg_name => g_required_value,
199: p_token1 => g_col_name_token,
200: p_token1_value => 'ica_id');

Line 197: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

193: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
194:
195: -- data is required
196: IF(p_clgv_rec.ica_id IS NULL) OR (p_clgv_rec.ica_id = Okl_Api.G_MISS_NUM) THEN
197: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
198: p_msg_name => g_required_value,
199: p_token1 => g_col_name_token,
200: p_token1_value => 'ica_id');
201:

Line 203: x_return_status := Okl_Api.G_RET_STS_ERROR;

199: p_token1 => g_col_name_token,
200: p_token1_value => 'ica_id');
201:
202: -- notify caller of an error
203: x_return_status := Okl_Api.G_RET_STS_ERROR;
204:
205: -- halt further validation of this column
206: RAISE G_EXCEPTION_HALT_VALIDATION;
207: END IF;

Line 216: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

212: CLOSE l_ica_csr;
213:
214: -- if l_dummy_var is still set to default, data was not found
215: IF(l_dummy_var = '?') THEN
216: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
217: p_msg_name => g_no_parent_record,
218: p_token1 => g_col_name_token,
219: p_token1_value => 'ica_id',
220: p_token2 => g_child_table_token,

Line 226: x_return_status := Okl_Api.G_RET_STS_ERROR;

222: p_token3 => g_parent_table_token,
223: p_token3_value => 'OKX_CUSTOMER_ACCOUNTS_V');
224:
225: -- notify caller of an error
226: x_return_status := Okl_Api.G_RET_STS_ERROR;
227: END IF;
228:
229: EXCEPTION
230: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 236: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

232: NULL;
233:
234: WHEN OTHERS THEN
235: -- store SQL error message on message stack for caller
236: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
237: p_msg_name => g_unexpected_error,
238: p_token1 => g_sqlcode_token,
239: p_token1_value => SQLCODE,
240: p_token2 => g_sqlerrm_token,

Line 245: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

241: p_token2_value => SQLERRM);
242:
243:
244: -- notify caller of an error
245: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
246:
247: -- verfiy that cursor was closed
248: IF l_ica_csr%ISOPEN THEN
249: CLOSE l_ica_csr;

Line 266: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

262: WHERE id = p_clgv_rec.inf_id;
263:
264: BEGIN
265: -- initialize return status
266: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
267:
268: -- data is required
269: IF(p_clgv_rec.inf_id IS NULL) OR (p_clgv_rec.inf_id = Okl_Api.G_MISS_NUM) THEN
270: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

Line 269: IF(p_clgv_rec.inf_id IS NULL) OR (p_clgv_rec.inf_id = Okl_Api.G_MISS_NUM) THEN

265: -- initialize return status
266: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
267:
268: -- data is required
269: IF(p_clgv_rec.inf_id IS NULL) OR (p_clgv_rec.inf_id = Okl_Api.G_MISS_NUM) THEN
270: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
271: p_msg_name => g_required_value,
272: p_token1 => g_col_name_token,
273: p_token1_value => 'inf_id');

Line 270: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

266: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
267:
268: -- data is required
269: IF(p_clgv_rec.inf_id IS NULL) OR (p_clgv_rec.inf_id = Okl_Api.G_MISS_NUM) THEN
270: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
271: p_msg_name => g_required_value,
272: p_token1 => g_col_name_token,
273: p_token1_value => 'inf_id');
274:

Line 276: x_return_status := Okl_Api.G_RET_STS_ERROR;

272: p_token1 => g_col_name_token,
273: p_token1_value => 'inf_id');
274:
275: -- notify caller of an error
276: x_return_status := Okl_Api.G_RET_STS_ERROR;
277:
278: -- halt further validation of this column
279: RAISE G_EXCEPTION_HALT_VALIDATION;
280: END IF;

Line 289: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

285: CLOSE l_inf_csr;
286:
287: -- if l_dummy_var is still set to default, data was not found
288: IF(l_dummy_var = '?') THEN
289: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
290: p_msg_name => g_no_parent_record,
291: p_token1 => g_col_name_token,
292: p_token1_value => 'inf_id',
293: p_token2 => g_child_table_token,

Line 299: x_return_status := Okl_Api.G_RET_STS_ERROR;

295: p_token3 => g_parent_table_token,
296: p_token3_value => 'OKL_INVOICE_FORMATS_V');
297:
298: -- notify caller of an error
299: x_return_status := Okl_Api.G_RET_STS_ERROR;
300: END IF;
301:
302: EXCEPTION
303:

Line 311: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

307:
308:
309: WHEN OTHERS THEN
310: -- store SQL error message on message stack for caller
311: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
312: p_msg_name => g_unexpected_error,
313: p_token1 => g_sqlcode_token,
314: p_token1_value => SQLCODE,
315: p_token2 => g_sqlerrm_token,

Line 320: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

316: p_token2_value => SQLERRM);
317:
318:
319: -- notify caller of an error
320: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
321:
322: -- verfiy that cursor was closed
323: IF l_inf_csr%ISOPEN THEN
324: CLOSE l_inf_csr;

Line 340: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

336: WHERE id = p_clgv_rec.irm_id;
337:
338: BEGIN
339: -- initialize return status
340: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
341:
342: -- data is required
343: IF(p_clgv_rec.irm_id IS NULL) OR (p_clgv_rec.irm_id = Okl_Api.G_MISS_NUM) THEN
344: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

Line 343: IF(p_clgv_rec.irm_id IS NULL) OR (p_clgv_rec.irm_id = Okl_Api.G_MISS_NUM) THEN

339: -- initialize return status
340: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
341:
342: -- data is required
343: IF(p_clgv_rec.irm_id IS NULL) OR (p_clgv_rec.irm_id = Okl_Api.G_MISS_NUM) THEN
344: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
345: p_msg_name => g_required_value,
346: p_token1 => g_col_name_token,
347: p_token1_value => 'irm_id');

Line 344: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

340: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
341:
342: -- data is required
343: IF(p_clgv_rec.irm_id IS NULL) OR (p_clgv_rec.irm_id = Okl_Api.G_MISS_NUM) THEN
344: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
345: p_msg_name => g_required_value,
346: p_token1 => g_col_name_token,
347: p_token1_value => 'irm_id');
348:

Line 350: x_return_status := Okl_Api.G_RET_STS_ERROR;

346: p_token1 => g_col_name_token,
347: p_token1_value => 'irm_id');
348:
349: -- notify caller of an error
350: x_return_status := Okl_Api.G_RET_STS_ERROR;
351:
352: -- halt further validation of this column
353: RAISE G_EXCEPTION_HALT_VALIDATION;
354: END IF;

Line 363: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

359: CLOSE l_irm_csr;
360:
361: -- if l_dummy_var is still set to default, data was not found
362: IF(l_dummy_var = '?') THEN
363: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
364: p_msg_name => g_no_parent_record,
365: p_token1 => g_col_name_token,
366: p_token1_value => 'irm_id',
367: p_token2 => g_child_table_token,

Line 373: x_return_status := Okl_Api.G_RET_STS_ERROR;

369: p_token3 => g_parent_table_token,
370: p_token3_value => 'OKX_RECEIPT_METHODS_V');
371:
372: -- notify caller of an error
373: x_return_status := Okl_Api.G_RET_STS_ERROR;
374: END IF;
375:
376: EXCEPTION
377: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 383: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

379: NULL;
380:
381: WHEN OTHERS THEN
382: -- store SQL error message on message stack for caller
383: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
384: p_msg_name => g_unexpected_error,
385: p_token1 => g_sqlcode_token,
386: p_token1_value => SQLCODE,
387: p_token2 => g_sqlerrm_token,

Line 392: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

388: p_token2_value => SQLERRM);
389:
390:
391: -- notify caller of an error
392: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
393:
394: -- verfiy that cursor was closed
395: IF l_irm_csr%ISOPEN THEN
396: CLOSE l_irm_csr;

Line 412: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

408: WHERE id = p_clgv_rec.iuv_id;
409:
410: BEGIN
411: -- initialize return status
412: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
413:
414: -- data is required
415: IF(p_clgv_rec.iuv_id IS NULL) OR (p_clgv_rec.iuv_id = Okl_Api.G_MISS_NUM) THEN
416: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

Line 415: IF(p_clgv_rec.iuv_id IS NULL) OR (p_clgv_rec.iuv_id = Okl_Api.G_MISS_NUM) THEN

411: -- initialize return status
412: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
413:
414: -- data is required
415: IF(p_clgv_rec.iuv_id IS NULL) OR (p_clgv_rec.iuv_id = Okl_Api.G_MISS_NUM) THEN
416: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
417: p_msg_name => g_required_value,
418: p_token1 => g_col_name_token,
419: p_token1_value => 'iuv_id');

Line 416: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

412: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
413:
414: -- data is required
415: IF(p_clgv_rec.iuv_id IS NULL) OR (p_clgv_rec.iuv_id = Okl_Api.G_MISS_NUM) THEN
416: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
417: p_msg_name => g_required_value,
418: p_token1 => g_col_name_token,
419: p_token1_value => 'iuv_id');
420:

Line 422: x_return_status := Okl_Api.G_RET_STS_ERROR;

418: p_token1 => g_col_name_token,
419: p_token1_value => 'iuv_id');
420:
421: -- notify caller of an error
422: x_return_status := Okl_Api.G_RET_STS_ERROR;
423:
424: -- halt further validation of this column
425: RAISE G_EXCEPTION_HALT_VALIDATION;
426: END IF;

Line 435: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

431: CLOSE l_iuv_csr;
432:
433: -- if l_dummy_var is still set to default, data was not found
434: IF(l_dummy_var = '?') THEN
435: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
436: p_msg_name => g_no_parent_record,
437: p_token1 => g_col_name_token,
438: p_token1_value => 'iuv_id',
439: p_token2 => g_child_table_token,

Line 445: x_return_status := Okl_Api.G_RET_STS_ERROR;

441: p_token3 => g_parent_table_token,
442: p_token3_value => 'OKX_USAGES_V');
443:
444: -- notify caller of an error
445: x_return_status := Okl_Api.G_RET_STS_ERROR;
446: END IF;
447:
448: EXCEPTION
449: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 455: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

451: NULL;
452:
453: WHEN OTHERS THEN
454: -- store SQL error message on message stack for caller
455: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
456: p_msg_name => g_unexpected_error,
457: p_token1 => g_sqlcode_token,
458: p_token1_value => SQLCODE,
459: p_token2 => g_sqlerrm_token,

Line 464: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

460: p_token2_value => SQLERRM);
461:
462:
463: -- notify caller of an error
464: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
465:
466: -- verfiy that cursor was closed
467: IF l_iuv_csr%ISOPEN THEN
468: CLOSE l_iuv_csr;

Line 479: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

475: p_clgv_rec IN clgv_rec_type) IS
476:
477: BEGIN
478: -- initialize return status
479: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
480:
481: -- data is required
482: IF(p_clgv_rec.id IS NULL) OR (p_clgv_rec.id = Okl_Api.G_MISS_NUM) THEN
483: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

Line 482: IF(p_clgv_rec.id IS NULL) OR (p_clgv_rec.id = Okl_Api.G_MISS_NUM) THEN

478: -- initialize return status
479: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
480:
481: -- data is required
482: IF(p_clgv_rec.id IS NULL) OR (p_clgv_rec.id = Okl_Api.G_MISS_NUM) THEN
483: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
484: p_msg_name => g_required_value,
485: p_token1 => g_col_name_token,
486: p_token1_value => 'id');

Line 483: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

479: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
480:
481: -- data is required
482: IF(p_clgv_rec.id IS NULL) OR (p_clgv_rec.id = Okl_Api.G_MISS_NUM) THEN
483: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
484: p_msg_name => g_required_value,
485: p_token1 => g_col_name_token,
486: p_token1_value => 'id');
487:

Line 489: x_return_status := Okl_Api.G_RET_STS_ERROR;

485: p_token1 => g_col_name_token,
486: p_token1_value => 'id');
487:
488: -- notify caller of an error
489: x_return_status := Okl_Api.G_RET_STS_ERROR;
490:
491: -- halt further validation of this column
492: RAISE G_EXCEPTION_HALT_VALIDATION;
493: END IF;

Line 503: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

499: p_clgv_rec IN clgv_rec_type) IS
500:
501: BEGIN
502: -- initialize return status
503: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
504:
505: -- data is required
506: IF(p_clgv_rec.object_version_number IS NULL) OR (p_clgv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
507: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

Line 506: IF(p_clgv_rec.object_version_number IS NULL) OR (p_clgv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN

502: -- initialize return status
503: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
504:
505: -- data is required
506: IF(p_clgv_rec.object_version_number IS NULL) OR (p_clgv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
507: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
508: p_msg_name => g_required_value,
509: p_token1 => g_col_name_token,
510: p_token1_value => 'object_version_number');

Line 507: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

503: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
504:
505: -- data is required
506: IF(p_clgv_rec.object_version_number IS NULL) OR (p_clgv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
507: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
508: p_msg_name => g_required_value,
509: p_token1 => g_col_name_token,
510: p_token1_value => 'object_version_number');
511:

Line 513: x_return_status := Okl_Api.G_RET_STS_ERROR;

509: p_token1 => g_col_name_token,
510: p_token1_value => 'object_version_number');
511:
512: -- notify caller of an error
513: x_return_status := Okl_Api.G_RET_STS_ERROR;
514:
515: -- halt further validation of this column
516: RAISE G_EXCEPTION_HALT_VALIDATION;
517: END IF;

Line 538: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

534: FROM OKL_CNTR_LVLNG_GRPS_V
535: WHERE name = p_name;
536: BEGIN
537: -- initialize return status
538: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
539:
540: -- data is required
541: IF(p_clgv_rec.name IS NULL) OR (p_clgv_rec.name = Okl_Api.G_MISS_CHAR) THEN
542: -- Message Text: Please enter all mandatory fields

Line 541: IF(p_clgv_rec.name IS NULL) OR (p_clgv_rec.name = Okl_Api.G_MISS_CHAR) THEN

537: -- initialize return status
538: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
539:
540: -- data is required
541: IF(p_clgv_rec.name IS NULL) OR (p_clgv_rec.name = Okl_Api.G_MISS_CHAR) THEN
542: -- Message Text: Please enter all mandatory fields
543: x_return_status := OKC_API.G_RET_STS_ERROR;
544: OKC_API.set_message( p_app_name => G_APP_NAME,
545: p_msg_name => 'OKL_BPD_MISSING_FIELDS');

Line 595: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

591: --x_return_status := OKC_API.G_RET_STS_ERROR;
592:
593: WHEN OTHERS THEN
594: -- store SQL error message on message stack for caller
595: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
596: p_msg_name => g_unexpected_error,
597: p_token1 => g_sqlcode_token,
598: p_token1_value => SQLCODE,
599: p_token2 => g_sqlerrm_token,

Line 1109: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1105: ---------------------------------------------------
1106: FUNCTION Validate_Attributes (
1107: p_clgv_rec IN clgv_rec_type
1108: ) RETURN VARCHAR2 IS
1109: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1110: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1111: BEGIN
1112: -- Call each column level validation
1113:

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

1106: FUNCTION Validate_Attributes (
1107: p_clgv_rec IN clgv_rec_type
1108: ) RETURN VARCHAR2 IS
1109: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1110: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1111: BEGIN
1112: -- Call each column level validation
1113:
1114: validate_id(x_return_status => l_return_status,

Line 1118: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1114: validate_id(x_return_status => l_return_status,
1115: p_clgv_rec => p_clgv_rec);
1116:
1117: -- Store the highest degree of error
1118: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1119: x_return_status := l_return_status;
1120: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1121: -- IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1122: -- x_return_status := l_return_status;

Line 1121: -- IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1117: -- Store the highest degree of error
1118: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1119: x_return_status := l_return_status;
1120: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1121: -- IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1122: -- x_return_status := l_return_status;
1123: -- END IF;
1124: END IF;
1125:

Line 1130: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1126: validate_object_version_number(x_return_status => l_return_status,
1127: p_clgv_rec => p_clgv_rec);
1128:
1129: -- Store the highest degree of error
1130: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1131: x_return_status := l_return_status;
1132: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1133: -- IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1134: -- x_return_status := l_return_status;

Line 1133: -- IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1129: -- Store the highest degree of error
1130: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1131: x_return_status := l_return_status;
1132: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1133: -- IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1134: -- x_return_status := l_return_status;
1135: -- END IF;
1136: END IF;
1137:

Line 1142: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1138: validate_name(x_return_status => l_return_status,
1139: p_clgv_rec => p_clgv_rec);
1140:
1141: -- Store the highest degree of error
1142: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1143: x_return_status := l_return_status;
1144: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1145: -- IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1146: -- x_return_status := l_return_status;

Line 1145: -- IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1141: -- Store the highest degree of error
1142: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1143: x_return_status := l_return_status;
1144: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1145: -- IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1146: -- x_return_status := l_return_status;
1147: -- END IF;
1148: END IF;
1149: /*

Line 1154: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1150: validate_ibt_id(x_return_status => l_return_status,
1151: p_clgv_rec => p_clgv_rec);
1152:
1153: -- Store the highest degree of error
1154: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1155: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1156: x_return_status := l_return_status;
1157: END IF;
1158: END IF;

Line 1155: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1151: p_clgv_rec => p_clgv_rec);
1152:
1153: -- Store the highest degree of error
1154: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1155: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1156: x_return_status := l_return_status;
1157: END IF;
1158: END IF;
1159:

Line 1164: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1160: validate_ica_id(x_return_status => l_return_status,
1161: p_clgv_rec => p_clgv_rec);
1162:
1163: -- Store the highest degree of error
1164: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1165: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1166: x_return_status := l_return_status;
1167: END IF;
1168: END IF;

Line 1165: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1161: p_clgv_rec => p_clgv_rec);
1162:
1163: -- Store the highest degree of error
1164: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1165: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1166: x_return_status := l_return_status;
1167: END IF;
1168: END IF;
1169:

Line 1174: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1170: validate_irm_id(x_return_status => l_return_status,
1171: p_clgv_rec => p_clgv_rec);
1172:
1173: -- Store the highest degree of error
1174: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1175: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1176: x_return_status := l_return_status;
1177: END IF;
1178: END IF;

Line 1175: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1171: p_clgv_rec => p_clgv_rec);
1172:
1173: -- Store the highest degree of error
1174: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1175: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1176: x_return_status := l_return_status;
1177: END IF;
1178: END IF;
1179:

Line 1184: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1180: validate_iuv_id(x_return_status => l_return_status,
1181: p_clgv_rec => p_clgv_rec);
1182:
1183: -- Store the highest degree of error
1184: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1185: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1186: x_return_status := l_return_status;
1187: END IF;
1188: END IF;

Line 1185: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1181: p_clgv_rec => p_clgv_rec);
1182:
1183: -- Store the highest degree of error
1184: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1185: IF(x_return_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1186: x_return_status := l_return_status;
1187: END IF;
1188: END IF;
1189: */

Line 1198: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1194: validate_currency_code(x_return_status => l_return_status,
1195: p_clgv_rec => p_clgv_rec);
1196:
1197: -- Store the highest degree of error
1198: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1199: x_return_status := l_return_status;
1200: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1201: END IF;
1202: -- for LE Uptake project 08-11-2006

Line 1203: IF ((p_clgv_rec.legal_entity_id = Okl_Api.G_MISS_NUM) OR p_clgv_rec.legal_entity_id IS NULL)

1199: x_return_status := l_return_status;
1200: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1201: END IF;
1202: -- for LE Uptake project 08-11-2006
1203: IF ((p_clgv_rec.legal_entity_id = Okl_Api.G_MISS_NUM) OR p_clgv_rec.legal_entity_id IS NULL)
1204: THEN
1205: RAISE G_EXCEPTION_HALT_VALIDATION;
1206: ELSE
1207: validate_legal_entity_id(p_clgv_rec => p_clgv_rec,

Line 1210: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1206: ELSE
1207: validate_legal_entity_id(p_clgv_rec => p_clgv_rec,
1208: x_return_status => l_return_status);
1209:
1210: IF(l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1211: x_return_status := l_return_status;
1212: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1213: END IF;
1214: END IF;