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

Line 36: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

32: WHERE okl_ptl_ptq_vals_v.id = p_id;
33: l_okl_pmvv_pk okl_pmvv_pk_csr%ROWTYPE;
34: l_pmvv_rec pmvv_rec_type;
35: BEGIN
36: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
37: x_no_data_found := TRUE;
38: -- Get current database values
39: OPEN okl_pmvv_pk_csr (p_pmvv_rec.id);
40: FETCH okl_pmvv_pk_csr INTO

Line 59: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

55: x_pmvv_rec := l_pmvv_rec;
56: EXCEPTION
57: WHEN OTHERS THEN
58: -- store SQL error message on message stack
59: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
60: p_msg_name => G_UNEXPECTED_ERROR,
61: p_token1 => G_SQLCODE_TOKEN,
62: p_token1_value => SQLCODE,
63: p_token2 => G_SQLERRM_TOKEN,

Line 66: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

62: p_token1_value => SQLCODE,
63: p_token2 => G_SQLERRM_TOKEN,
64: p_token2_value => SQLERRM);
65: -- notify UNEXPECTED error for calling API.
66: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
67:
68: IF (okl_pmvv_pk_csr%ISOPEN) THEN
69: CLOSE okl_pmvv_pk_csr;
70: END IF;

Line 92: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

88: WHERE ptlv.id = p_ptl_id;
89: l_okl_ptlv_pk okl_ptl_pk_csr%ROWTYPE;
90: l_ptlv_rec ptlv_rec_type;
91: BEGIN
92: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
93: x_no_data_found := TRUE;
94: -- Get current database values
95: OPEN okl_ptl_pk_csr (p_pmvv_rec.ptl_id);
96: FETCH okl_ptl_pk_csr INTO

Line 105: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

101: x_ptlv_rec := l_ptlv_rec;
102: EXCEPTION
103: WHEN OTHERS THEN
104: -- store SQL error message on message stack
105: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
106: p_msg_name => G_UNEXPECTED_ERROR,
107: p_token1 => G_SQLCODE_TOKEN,
108: p_token1_value => SQLCODE,
109: p_token2 => G_SQLERRM_TOKEN,

Line 113: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

109: p_token2 => G_SQLERRM_TOKEN,
110: p_token2_value => SQLERRM);
111:
112: -- notify UNEXPECTED error for calling API.
113: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
114:
115: IF (okl_ptl_pk_csr%ISOPEN) THEN
116: CLOSE okl_ptl_pk_csr;
117:

Line 128: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

124: -----------------------------------------------------------------------------
125:
126: PROCEDURE Check_Constraints (
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
129: p_pmvv_rec IN pmvv_rec_type,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,

Line 187: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

183: l_token_6 VARCHAR2(1999);
184:
185: BEGIN
186: x_valid := TRUE;
187: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
188:
189: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PDT_TMPL_QLTY_CREATE',
190: p_attribute_code => 'OKL_PDT_TMPL_QLTY_CREATE_TITLE');
191:

Line 215: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

211: l_row_not_found := okl_pmvv_chk_csr%NOTFOUND;
212: CLOSE okl_pmvv_chk_csr;
213:
214: IF l_row_not_found = FALSE THEN
215: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
216: p_msg_name => G_IN_USE,
217: p_token1 => G_PARENT_TABLE_TOKEN,
218: p_token1_value => l_token_1,
219: p_token2 => G_CHILD_TABLE_TOKEN,

Line 222: x_return_status := Okl_Api.G_RET_STS_ERROR;

218: p_token1_value => l_token_1,
219: p_token2 => G_CHILD_TABLE_TOKEN,
220: p_token2_value => l_token_2);
221: x_valid := FALSE;
222: x_return_status := Okl_Api.G_RET_STS_ERROR;
223: RAISE G_EXCEPTION_HALT_PROCESSING;
224: END IF;
225:
226:

Line 228: IF p_pmvv_rec.id = Okl_Api.G_MISS_NUM THEN

224: END IF;
225:
226:
227:
228: IF p_pmvv_rec.id = Okl_Api.G_MISS_NUM THEN
229: OPEN c1(p_pmvv_rec.ptl_id,
230: p_pmvv_rec.ptq_id);
231: FETCH c1 INTO l_pmv_status;
232: l_row_found := c1%FOUND;

Line 235: --Okl_Api.set_message(Okl_Pmv_Pvt.G_APP_NAME,Okl_Pmv_Pvt.G_UNQS,Okl_Pmv_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001

231: FETCH c1 INTO l_pmv_status;
232: l_row_found := c1%FOUND;
233: CLOSE c1;
234: IF l_row_found THEN
235: --Okl_Api.set_message(Okl_Pmv_Pvt.G_APP_NAME,Okl_Pmv_Pvt.G_UNQS,Okl_Pmv_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001
236: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
237: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',
238: p_token1 => G_TABLE_TOKEN,
239: p_token1_value => l_token_1,

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

232: l_row_found := c1%FOUND;
233: CLOSE c1;
234: IF l_row_found THEN
235: --Okl_Api.set_message(Okl_Pmv_Pvt.G_APP_NAME,Okl_Pmv_Pvt.G_UNQS,Okl_Pmv_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001
236: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
237: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',
238: p_token1 => G_TABLE_TOKEN,
239: p_token1_value => l_token_1,
240: p_token2 => G_COLUMN_TOKEN,

Line 243: x_return_status := Okl_Api.G_RET_STS_ERROR;

239: p_token1_value => l_token_1,
240: p_token2 => G_COLUMN_TOKEN,
241: p_token2_value => l_token_6);
242: x_valid := FALSE;
243: x_return_status := Okl_Api.G_RET_STS_ERROR;
244: RAISE G_EXCEPTION_HALT_PROCESSING;
245: END IF;
246: END IF;
247:

Line 257: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

253: l_row_not_found := okl_pmv_ptl_fk_csr%NOTFOUND;
254: CLOSE okl_pmv_ptl_fk_csr;
255:
256: IF l_row_not_found = FALSE THEN
257: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
258: p_msg_name => G_PAST_RECORDS);
259: x_valid := FALSE;
260: x_return_status := Okl_Api.G_RET_STS_ERROR;
261: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 260: x_return_status := Okl_Api.G_RET_STS_ERROR;

256: IF l_row_not_found = FALSE THEN
257: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
258: p_msg_name => G_PAST_RECORDS);
259: x_valid := FALSE;
260: x_return_status := Okl_Api.G_RET_STS_ERROR;
261: RAISE G_EXCEPTION_HALT_PROCESSING;
262: END IF;
263: */
264:

Line 266: IF p_pmvv_rec.id = Okl_Api.G_MISS_NUM THEN

262: END IF;
263: */
264:
265: -- Check for constraints dates
266: IF p_pmvv_rec.id = Okl_Api.G_MISS_NUM THEN
267: OPEN okl_pmv_constraints_csr (p_pmvv_rec.ptv_id,
268: p_pmvv_rec.from_date,
269: p_pmvv_rec.TO_DATE);
270: FETCH okl_pmv_constraints_csr INTO l_check;

Line 275: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

271: l_row_not_found := okl_pmv_constraints_csr%NOTFOUND;
272: CLOSE okl_pmv_constraints_csr;
273:
274: IF l_row_not_found = FALSE THEN
275: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
276: p_msg_name => G_DATES_MISMATCH,
277: p_token1 => G_PARENT_TABLE_TOKEN,
278: p_token1_value => l_token_5,
279: p_token2 => G_CHILD_TABLE_TOKEN,

Line 282: x_return_status := Okl_Api.G_RET_STS_ERROR;

278: p_token1_value => l_token_5,
279: p_token2 => G_CHILD_TABLE_TOKEN,
280: p_token2_value => l_token_4);
281: x_valid := FALSE;
282: x_return_status := Okl_Api.G_RET_STS_ERROR;
283: RAISE G_EXCEPTION_HALT_PROCESSING;
284: END IF;
285: END IF;
286:

Line 294: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

290: -- with the next column
291: NULL;
292: WHEN OTHERS THEN
293: -- store SQL error message on message stack
294: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
295: p_msg_name => G_UNEXPECTED_ERROR,
296: p_token1 => G_SQLCODE_TOKEN,
297: p_token1_value => SQLCODE,
298: p_token2 => G_SQLERRM_TOKEN,

Line 301: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

297: p_token1_value => SQLCODE,
298: p_token2 => G_SQLERRM_TOKEN,
299: p_token2_value => SQLERRM);
300: x_valid := FALSE;
301: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
302:
303: IF (okl_pmvv_chk_csr%ISOPEN) THEN
304: CLOSE okl_pmvv_chk_csr;
305: END IF;

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

339: FROM okl_ptl_qualitys_v
340: WHERE okl_ptl_qualitys_v.id = p_id;
341:
342: l_ptq_status VARCHAR2(1);
343: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
344: l_row_notfound BOOLEAN := TRUE;
345: l_token_1 VARCHAR2(1999);
346:
347: BEGIN

Line 349: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

345: l_token_1 VARCHAR2(1999);
346:
347: BEGIN
348: -- initialize return status
349: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
350:
351: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PDT_TMPL_QLTY_CREATE',
352: p_attribute_code => 'OKL_TEMPLATE_QUALITY');
353:

Line 356: (p_pmvv_rec.ptq_id = Okl_Api.G_MISS_NUM) THEN

352: p_attribute_code => 'OKL_TEMPLATE_QUALITY');
353:
354: -- check for data before processing
355: IF (p_pmvv_rec.ptq_id IS NULL) OR
356: (p_pmvv_rec.ptq_id = Okl_Api.G_MISS_NUM) THEN
357: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name
358: ,p_msg_name => Okl_Pmv_Pvt.g_required_value
359: ,p_token1 => Okl_Pmv_Pvt.g_col_name_token
360: ,p_token1_value => l_token_1);

Line 357: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name

353:
354: -- check for data before processing
355: IF (p_pmvv_rec.ptq_id IS NULL) OR
356: (p_pmvv_rec.ptq_id = Okl_Api.G_MISS_NUM) THEN
357: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name
358: ,p_msg_name => Okl_Pmv_Pvt.g_required_value
359: ,p_token1 => Okl_Pmv_Pvt.g_col_name_token
360: ,p_token1_value => l_token_1);
361: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 361: x_return_status := Okl_Api.G_RET_STS_ERROR;

357: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name
358: ,p_msg_name => Okl_Pmv_Pvt.g_required_value
359: ,p_token1 => Okl_Pmv_Pvt.g_col_name_token
360: ,p_token1_value => l_token_1);
361: x_return_status := Okl_Api.G_RET_STS_ERROR;
362: RAISE G_EXCEPTION_HALT_PROCESSING;
363: END IF;
364:
365: IF (p_pmvv_rec.ptq_ID IS NOT NULL)

Line 372: Okl_Api.set_message(Okl_Pmv_Pvt.G_APP_NAME, Okl_Pmv_Pvt.G_INVALID_VALUE,Okl_Pmv_Pvt.G_COL_NAME_TOKEN,l_token_1);

368: FETCH okl_ptqv_pk_csr INTO l_ptq_status;
369: l_row_notfound := okl_ptqv_pk_csr%NOTFOUND;
370: CLOSE okl_ptqv_pk_csr;
371: IF (l_row_notfound) THEN
372: Okl_Api.set_message(Okl_Pmv_Pvt.G_APP_NAME, Okl_Pmv_Pvt.G_INVALID_VALUE,Okl_Pmv_Pvt.G_COL_NAME_TOKEN,l_token_1);
373: RAISE G_ITEM_NOT_FOUND_ERROR;
374: END IF;
375: END IF;
376:

Line 384: x_return_status := Okl_Api.G_RET_STS_ERROR;

380: -- no processing necessary; validation can continue
381: -- with the next column
382: NULL;
383: WHEN G_ITEM_NOT_FOUND_ERROR THEN
384: x_return_status := Okl_Api.G_RET_STS_ERROR;
385:
386: WHEN OTHERS THEN
387: -- store SQL error message on message stack for caller
388: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,

Line 388: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,

384: x_return_status := Okl_Api.G_RET_STS_ERROR;
385:
386: WHEN OTHERS THEN
387: -- store SQL error message on message stack for caller
388: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,
389: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,
390: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,
391: p_token1_value => SQLCODE,
392: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,

Line 396: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

392: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,
393: p_token2_value => SQLERRM);
394:
395: -- notify caller of an UNEXPECTED error
396: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
397:
398: END Validate_Ptq_Id;
399:
400: ---------------------------------------------------------------------------

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

412:
413: FUNCTION Validate_Attributes (
414: p_pmvv_rec IN pmvv_rec_type
415: ) RETURN VARCHAR2 IS
416: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
417: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
418: BEGIN
419: -- Validate_Ptq_Id
420: Validate_Ptq_Id(p_pmvv_rec, x_return_status);

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

413: FUNCTION Validate_Attributes (
414: p_pmvv_rec IN pmvv_rec_type
415: ) RETURN VARCHAR2 IS
416: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
417: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
418: BEGIN
419: -- Validate_Ptq_Id
420: Validate_Ptq_Id(p_pmvv_rec, x_return_status);
421: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 421: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

417: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
418: BEGIN
419: -- Validate_Ptq_Id
420: Validate_Ptq_Id(p_pmvv_rec, x_return_status);
421: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
422: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
423: -- need to leave
424: l_return_status := x_return_status;
425: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 422: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

418: BEGIN
419: -- Validate_Ptq_Id
420: Validate_Ptq_Id(p_pmvv_rec, x_return_status);
421: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
422: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
423: -- need to leave
424: l_return_status := x_return_status;
425: RAISE G_EXCEPTION_HALT_PROCESSING;
426: ELSE

Line 441: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,

437: RETURN (l_return_status);
438:
439: WHEN OTHERS THEN
440: -- store SQL error message on message stack for caller
441: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pmv_Pvt.g_app_name,
442: p_msg_name => Okl_Pmv_Pvt.g_unexpected_error,
443: p_token1 => Okl_Pmv_Pvt.g_sqlcode_token,
444: p_token1_value => SQLCODE,
445: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,

Line 448: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

444: p_token1_value => SQLCODE,
445: p_token2 => Okl_Pmv_Pvt.g_sqlerrm_token,
446: p_token2_value => SQLERRM);
447: -- notify caller of an UNEXPECTED error
448: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
449: RETURN(l_return_status);
450:
451: END Validate_Attributes;
452:

Line 458: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

454: -- PROCEDURE insert_pmvalues for: OKL_PTL_PTQ_VALS_V
455: ---------------------------------------------------------------------------
456:
457: PROCEDURE insert_pmvalues(p_api_version IN NUMBER,
458: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
459: x_return_status OUT NOCOPY VARCHAR2,
460: x_msg_count OUT NOCOPY NUMBER,
461: x_msg_data OUT NOCOPY VARCHAR2,
462: p_ptlv_rec IN ptlv_rec_type,

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

464: x_pmvv_rec OUT NOCOPY pmvv_rec_type
465: ) IS
466: l_api_version CONSTANT NUMBER := 1;
467: l_api_name CONSTANT VARCHAR2(30) := 'insert_pmvalues';
468: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
469: l_valid BOOLEAN;
470: l_pmvv_rec pmvv_rec_type;
471: l_ptlv_rec ptlv_rec_type;
472: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');

Line 475: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

471: l_ptlv_rec ptlv_rec_type;
472: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
473: l_row_notfound BOOLEAN := TRUE;
474: BEGIN
475: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
476:
477: l_pmvv_rec := p_pmvv_rec;
478:
479: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

Line 479: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

475: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
476:
477: l_pmvv_rec := p_pmvv_rec;
478:
479: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
480: p_pkg_name => G_PKG_NAME,
481: p_init_msg_list => p_init_msg_list,
482: l_api_version => l_api_version,
483: p_api_version => p_api_version,

Line 487: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

483: p_api_version => p_api_version,
484: p_api_type => '_PVT',
485: x_return_status => l_return_status);
486:
487: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
490: RAISE Okl_Api.G_EXCEPTION_ERROR;
491: END IF;

Line 488: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

484: p_api_type => '_PVT',
485: x_return_status => l_return_status);
486:
487: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
490: RAISE Okl_Api.G_EXCEPTION_ERROR;
491: END IF;
492:

Line 489: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

485: x_return_status => l_return_status);
486:
487: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
490: RAISE Okl_Api.G_EXCEPTION_ERROR;
491: END IF;
492:
493: l_return_status := Validate_Attributes(l_pmvv_rec);

Line 490: RAISE Okl_Api.G_EXCEPTION_ERROR;

486:
487: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
490: RAISE Okl_Api.G_EXCEPTION_ERROR;
491: END IF;
492:
493: l_return_status := Validate_Attributes(l_pmvv_rec);
494: --- If any errors happen abort API

Line 495: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

491: END IF;
492:
493: l_return_status := Validate_Attributes(l_pmvv_rec);
494: --- If any errors happen abort API
495: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
496: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
497: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
498: RAISE Okl_Api.G_EXCEPTION_ERROR;
499: END IF;

Line 496: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

492:
493: l_return_status := Validate_Attributes(l_pmvv_rec);
494: --- If any errors happen abort API
495: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
496: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
497: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
498: RAISE Okl_Api.G_EXCEPTION_ERROR;
499: END IF;
500:

Line 497: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

493: l_return_status := Validate_Attributes(l_pmvv_rec);
494: --- If any errors happen abort API
495: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
496: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
497: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
498: RAISE Okl_Api.G_EXCEPTION_ERROR;
499: END IF;
500:
501: get_parent_dates(p_pmvv_rec => l_pmvv_rec,

Line 498: RAISE Okl_Api.G_EXCEPTION_ERROR;

494: --- If any errors happen abort API
495: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
496: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
497: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
498: RAISE Okl_Api.G_EXCEPTION_ERROR;
499: END IF;
500:
501: get_parent_dates(p_pmvv_rec => l_pmvv_rec,
502: x_no_data_found => l_row_notfound,

Line 507: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

503: x_return_status => l_return_status,
504: x_ptlv_rec => l_ptlv_rec);
505:
506: IF (l_row_notfound) THEN
507: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
508: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
509: RAISE Okl_Api.G_EXCEPTION_ERROR;
510: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 508: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

504: x_ptlv_rec => l_ptlv_rec);
505:
506: IF (l_row_notfound) THEN
507: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
508: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
509: RAISE Okl_Api.G_EXCEPTION_ERROR;
510: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
512: END IF;

Line 509: RAISE Okl_Api.G_EXCEPTION_ERROR;

505:
506: IF (l_row_notfound) THEN
507: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
508: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
509: RAISE Okl_Api.G_EXCEPTION_ERROR;
510: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
512: END IF;
513:

Line 510: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

506: IF (l_row_notfound) THEN
507: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
508: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
509: RAISE Okl_Api.G_EXCEPTION_ERROR;
510: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
512: END IF;
513:
514: l_pmvv_rec.from_date := l_ptlv_rec.from_date;

Line 511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

507: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
508: ELSIF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
509: RAISE Okl_Api.G_EXCEPTION_ERROR;
510: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
512: END IF;
513:
514: l_pmvv_rec.from_date := l_ptlv_rec.from_date;
515: l_pmvv_rec.TO_DATE := l_ptlv_rec.TO_DATE;

Line 527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

523: x_msg_count => x_msg_count,
524: x_msg_data => x_msg_data,
525: x_valid => l_valid);
526:
527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
530: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
531: l_valid <> TRUE) THEN

Line 528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

524: x_msg_data => x_msg_data,
525: x_valid => l_valid);
526:
527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
530: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
531: l_valid <> TRUE) THEN
532: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR

525: x_valid => l_valid);
526:
527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
530: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
531: l_valid <> TRUE) THEN
532: x_return_status := Okl_Api.G_RET_STS_ERROR;
533: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 530: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

526:
527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
530: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
531: l_valid <> TRUE) THEN
532: x_return_status := Okl_Api.G_RET_STS_ERROR;
533: RAISE Okl_Api.G_EXCEPTION_ERROR;
534: END IF;

Line 532: x_return_status := Okl_Api.G_RET_STS_ERROR;

528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
530: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
531: l_valid <> TRUE) THEN
532: x_return_status := Okl_Api.G_RET_STS_ERROR;
533: RAISE Okl_Api.G_EXCEPTION_ERROR;
534: END IF;
535:
536: /* public api to insert pmvalues */

Line 533: RAISE Okl_Api.G_EXCEPTION_ERROR;

529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
530: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
531: l_valid <> TRUE) THEN
532: x_return_status := Okl_Api.G_RET_STS_ERROR;
533: RAISE Okl_Api.G_EXCEPTION_ERROR;
534: END IF;
535:
536: /* public api to insert pmvalues */
537:

Line 546: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

542: x_msg_data => x_msg_data,
543: p_pmvv_rec => l_pmvv_rec,
544: x_pmvv_rec => x_pmvv_rec);
545:
546: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
547: RAISE Okl_Api.G_EXCEPTION_ERROR;
548: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
550: END IF;

Line 547: RAISE Okl_Api.G_EXCEPTION_ERROR;

543: p_pmvv_rec => l_pmvv_rec,
544: x_pmvv_rec => x_pmvv_rec);
545:
546: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
547: RAISE Okl_Api.G_EXCEPTION_ERROR;
548: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
550: END IF;
551:

Line 548: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

544: x_pmvv_rec => x_pmvv_rec);
545:
546: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
547: RAISE Okl_Api.G_EXCEPTION_ERROR;
548: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
550: END IF;
551:
552: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

Line 549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

545:
546: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
547: RAISE Okl_Api.G_EXCEPTION_ERROR;
548: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
550: END IF;
551:
552: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
553: x_msg_data => x_msg_data);

Line 552: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

548: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
550: END IF;
551:
552: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
553: x_msg_data => x_msg_data);
554: EXCEPTION
555: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
556: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 555: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

551:
552: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
553: x_msg_data => x_msg_data);
554: EXCEPTION
555: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
556: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
557: p_pkg_name => G_PKG_NAME,
558: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
559: x_msg_count => x_msg_count,

Line 556: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

552: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
553: x_msg_data => x_msg_data);
554: EXCEPTION
555: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
556: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
557: p_pkg_name => G_PKG_NAME,
558: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
559: x_msg_count => x_msg_count,
560: x_msg_data => x_msg_data,

Line 558: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

554: EXCEPTION
555: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
556: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
557: p_pkg_name => G_PKG_NAME,
558: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
559: x_msg_count => x_msg_count,
560: x_msg_data => x_msg_data,
561: p_api_type => '_PVT');
562: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 562: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

558: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
559: x_msg_count => x_msg_count,
560: x_msg_data => x_msg_data,
561: p_api_type => '_PVT');
562: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
563: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
564: p_pkg_name => G_PKG_NAME,
565: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
566: x_msg_count => x_msg_count,

Line 563: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

559: x_msg_count => x_msg_count,
560: x_msg_data => x_msg_data,
561: p_api_type => '_PVT');
562: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
563: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
564: p_pkg_name => G_PKG_NAME,
565: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
566: x_msg_count => x_msg_count,
567: x_msg_data => x_msg_data,

Line 565: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

561: p_api_type => '_PVT');
562: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
563: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
564: p_pkg_name => G_PKG_NAME,
565: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
566: x_msg_count => x_msg_count,
567: x_msg_data => x_msg_data,
568: p_api_type => '_PVT');
569: WHEN OTHERS THEN

Line 570: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

566: x_msg_count => x_msg_count,
567: x_msg_data => x_msg_data,
568: p_api_type => '_PVT');
569: WHEN OTHERS THEN
570: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
571: p_pkg_name => G_PKG_NAME,
572: p_exc_name => 'OTHERS',
573: x_msg_count => x_msg_count,
574: x_msg_data => x_msg_data,

Line 580: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

576:
577: END insert_pmvalues;
578:
579: PROCEDURE insert_pmvalues(p_api_version IN NUMBER,
580: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
581: x_return_status OUT NOCOPY VARCHAR2,
582: x_msg_count OUT NOCOPY NUMBER,
583: x_msg_data OUT NOCOPY VARCHAR2,
584: p_ptlv_rec IN ptlv_rec_type,

Line 599: p_init_msg_list => OKL_API.G_FALSE,

595: i := p_pmvv_tbl.FIRST;
596: LOOP
597: insert_pmvalues(
598: p_api_version => p_api_version,
599: p_init_msg_list => OKL_API.G_FALSE,
600: x_return_status => x_return_status,
601: x_msg_count => x_msg_count,
602: x_msg_data => x_msg_data,
603: p_ptlv_rec => p_ptlv_rec,

Line 607: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

603: p_ptlv_rec => p_ptlv_rec,
604: p_pmvv_rec => p_pmvv_tbl(i),
605: x_pmvv_rec => x_pmvv_tbl(i));
606:
607: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
608: IF (l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
609: l_overall_status := x_return_status;
610: END IF;
611: END IF;

Line 608: IF (l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

604: p_pmvv_rec => p_pmvv_tbl(i),
605: x_pmvv_rec => x_pmvv_tbl(i));
606:
607: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
608: IF (l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
609: l_overall_status := x_return_status;
610: END IF;
611: END IF;
612:

Line 627: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

623: -- This allows the user to delete table of records
624: ---------------------------------------------------------------------------
625: PROCEDURE delete_pmvalues(
626: p_api_version IN NUMBER
627: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
628: ,x_return_status OUT NOCOPY VARCHAR2
629: ,x_msg_count OUT NOCOPY NUMBER
630: ,x_msg_data OUT NOCOPY VARCHAR2
631: ,p_ptlv_rec IN ptlv_rec_type

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

634: l_api_version CONSTANT NUMBER := 1;
635: l_pmvv_tbl pmvv_tbl_type;
636: l_api_name CONSTANT VARCHAR2(30) := 'delete_pmvalues';
637: l_pmvv_rec pmvv_rec_type;
638: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
639: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
640: i NUMBER;
641: l_valid BOOLEAN;
642:

Line 639: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

635: l_pmvv_tbl pmvv_tbl_type;
636: l_api_name CONSTANT VARCHAR2(30) := 'delete_pmvalues';
637: l_pmvv_rec pmvv_rec_type;
638: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
639: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
640: i NUMBER;
641: l_valid BOOLEAN;
642:
643:

Line 646: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

642:
643:
644: BEGIN
645:
646: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
647:
648: l_pmvv_tbl := p_pmvv_tbl;
649:
650: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

Line 650: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

646: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
647:
648: l_pmvv_tbl := p_pmvv_tbl;
649:
650: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
651: p_pkg_name => G_PKG_NAME,
652: p_init_msg_list => p_init_msg_list,
653: l_api_version => l_api_version,
654: p_api_version => p_api_version,

Line 658: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

654: p_api_version => p_api_version,
655: p_api_type => '_PVT',
656: x_return_status => l_return_status);
657:
658: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
659: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
660: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
661: RAISE Okl_Api.G_EXCEPTION_ERROR;
662: END IF;

Line 659: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

655: p_api_type => '_PVT',
656: x_return_status => l_return_status);
657:
658: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
659: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
660: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
661: RAISE Okl_Api.G_EXCEPTION_ERROR;
662: END IF;
663:

Line 660: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

656: x_return_status => l_return_status);
657:
658: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
659: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
660: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
661: RAISE Okl_Api.G_EXCEPTION_ERROR;
662: END IF;
663:
664: /* check if the product asked to delete is used by contracts if yes halt the process*/

Line 661: RAISE Okl_Api.G_EXCEPTION_ERROR;

657:
658: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
659: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
660: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
661: RAISE Okl_Api.G_EXCEPTION_ERROR;
662: END IF;
663:
664: /* check if the product asked to delete is used by contracts if yes halt the process*/
665:

Line 680: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

676: x_msg_count => x_msg_count,
677: x_msg_data => x_msg_data,
678: x_valid => l_valid);
679:
680: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
681: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
682: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
683: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
684: l_valid <> TRUE) THEN

Line 681: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

677: x_msg_data => x_msg_data,
678: x_valid => l_valid);
679:
680: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
681: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
682: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
683: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
684: l_valid <> TRUE) THEN
685: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 682: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR

678: x_valid => l_valid);
679:
680: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
681: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
682: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
683: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
684: l_valid <> TRUE) THEN
685: x_return_status := Okl_Api.G_RET_STS_ERROR;
686: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 683: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

679:
680: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
681: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
682: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
683: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
684: l_valid <> TRUE) THEN
685: x_return_status := Okl_Api.G_RET_STS_ERROR;
686: RAISE Okl_Api.G_EXCEPTION_ERROR;
687: END IF;

Line 685: x_return_status := Okl_Api.G_RET_STS_ERROR;

681: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
682: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
683: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
684: l_valid <> TRUE) THEN
685: x_return_status := Okl_Api.G_RET_STS_ERROR;
686: RAISE Okl_Api.G_EXCEPTION_ERROR;
687: END IF;
688:
689: EXIT WHEN (i = l_pmvv_tbl.LAST);

Line 686: RAISE Okl_Api.G_EXCEPTION_ERROR;

682: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
683: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
684: l_valid <> TRUE) THEN
685: x_return_status := Okl_Api.G_RET_STS_ERROR;
686: RAISE Okl_Api.G_EXCEPTION_ERROR;
687: END IF;
688:
689: EXIT WHEN (i = l_pmvv_tbl.LAST);
690:

Line 704: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

700: x_msg_count => x_msg_count,
701: x_msg_data => x_msg_data,
702: p_pmvv_tbl => l_pmvv_tbl);
703:
704: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
705: RAISE Okl_Api.G_EXCEPTION_ERROR;
706: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
708: END IF;

Line 705: RAISE Okl_Api.G_EXCEPTION_ERROR;

701: x_msg_data => x_msg_data,
702: p_pmvv_tbl => l_pmvv_tbl);
703:
704: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
705: RAISE Okl_Api.G_EXCEPTION_ERROR;
706: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
708: END IF;
709:

Line 706: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

702: p_pmvv_tbl => l_pmvv_tbl);
703:
704: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
705: RAISE Okl_Api.G_EXCEPTION_ERROR;
706: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
708: END IF;
709:
710: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

Line 707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

703:
704: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
705: RAISE Okl_Api.G_EXCEPTION_ERROR;
706: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
708: END IF;
709:
710: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
711: x_msg_data => x_msg_data);

Line 710: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

706: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
708: END IF;
709:
710: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
711: x_msg_data => x_msg_data);
712: EXCEPTION
713: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
714: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 713: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

709:
710: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
711: x_msg_data => x_msg_data);
712: EXCEPTION
713: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
714: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
715: p_pkg_name => G_PKG_NAME,
716: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
717: x_msg_count => x_msg_count,

Line 714: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

710: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
711: x_msg_data => x_msg_data);
712: EXCEPTION
713: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
714: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
715: p_pkg_name => G_PKG_NAME,
716: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
717: x_msg_count => x_msg_count,
718: x_msg_data => x_msg_data,

Line 716: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

712: EXCEPTION
713: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
714: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
715: p_pkg_name => G_PKG_NAME,
716: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
717: x_msg_count => x_msg_count,
718: x_msg_data => x_msg_data,
719: p_api_type => '_PVT');
720: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 720: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

716: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
717: x_msg_count => x_msg_count,
718: x_msg_data => x_msg_data,
719: p_api_type => '_PVT');
720: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
722: p_pkg_name => G_PKG_NAME,
723: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
724: x_msg_count => x_msg_count,

Line 721: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

717: x_msg_count => x_msg_count,
718: x_msg_data => x_msg_data,
719: p_api_type => '_PVT');
720: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
722: p_pkg_name => G_PKG_NAME,
723: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
724: x_msg_count => x_msg_count,
725: x_msg_data => x_msg_data,

Line 723: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

719: p_api_type => '_PVT');
720: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
722: p_pkg_name => G_PKG_NAME,
723: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
724: x_msg_count => x_msg_count,
725: x_msg_data => x_msg_data,
726: p_api_type => '_PVT');
727: WHEN OTHERS THEN

Line 728: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

724: x_msg_count => x_msg_count,
725: x_msg_data => x_msg_data,
726: p_api_type => '_PVT');
727: WHEN OTHERS THEN
728: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
729: p_pkg_name => G_PKG_NAME,
730: p_exc_name => 'OTHERS',
731: x_msg_count => x_msg_count,
732: x_msg_data => x_msg_data,