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

Line 24: IF p_cur_version = Okl_Api.G_MISS_CHAR THEN

20: l_row_not_found BOOLEAN := FALSE;
21: BEGIN
22: null;
23: /*
24: IF p_cur_version = Okl_Api.G_MISS_CHAR THEN
25: x_new_version := G_INIT_VERSION;
26: ELSE
27: -- Check for future versions of the same formula
28: l_sql_stmt := 'SELECT ''1'' ' ||

Line 32: '''' || Okl_Api.G_MISS_DATE || '''' || ') > ' ||

28: l_sql_stmt := 'SELECT ''1'' ' ||
29: 'FROM ' || p_table ||
30: ' WHERE NAME = ' || '''' || p_name || '''' ||
31: ' AND NVL(TO_DATE, ' ||
32: '''' || Okl_Api.G_MISS_DATE || '''' || ') > ' ||
33: '''' || p_to_date || '''';
34: OPEN okl_all_laterversionsexist_csr
35: FOR l_sql_stmt;
36: FETCH okl_all_laterversionsexist_csr INTO l_check;

Line 49: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

45: + G_VERSION_MINOR_INCREMENT, G_VERSION_FORMAT);
46: END IF;
47: END IF;
48:
49: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
50: */
51: EXCEPTION
52: WHEN OTHERS THEN
53: -- store SQL error message on message stack

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

50: */
51: EXCEPTION
52: WHEN OTHERS THEN
53: -- store SQL error message on message stack
54: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
55: p_msg_name => G_UNEXPECTED_ERROR,
56: p_token1 => G_SQLCODE_TOKEN,
57: p_token1_value => SQLCODE,
58: p_token2 => G_SQLERRM_TOKEN,

Line 60: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

56: p_token1 => G_SQLCODE_TOKEN,
57: p_token1_value => SQLCODE,
58: p_token2 => G_SQLERRM_TOKEN,
59: p_token2_value => SQLERRM);
60: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
61:
62: IF (okl_all_laterversionsexist_csr%ISOPEN) THEN
63: CLOSE okl_all_laterversionsexist_csr;
64: END IF;

Line 83: NVL(DESCRIPTION,Okl_Api.G_MISS_CHAR) DESCRIPTION,

79: ID,
80: OBJECT_VERSION_NUMBER,
81: NAME,
82: VERSION,
83: NVL(DESCRIPTION,Okl_Api.G_MISS_CHAR) DESCRIPTION,
84: FROM_DATE,
85: NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
86: CREATED_BY,
87: CREATION_DATE,

Line 85: NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,

81: NAME,
82: VERSION,
83: NVL(DESCRIPTION,Okl_Api.G_MISS_CHAR) DESCRIPTION,
84: FROM_DATE,
85: NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
86: CREATED_BY,
87: CREATION_DATE,
88: LAST_UPDATED_BY,
89: LAST_UPDATE_DATE,

Line 90: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN

86: CREATED_BY,
87: CREATION_DATE,
88: LAST_UPDATED_BY,
89: LAST_UPDATE_DATE,
90: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
91: FROM Okl_Pdt_Templates_V
92: WHERE okl_pdt_templates_v.id = p_id;
93: l_okl_ptlv_pk okl_ptlv_pk_csr%ROWTYPE;
94: l_ptlv_rec ptlv_rec_type;

Line 96: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

92: WHERE okl_pdt_templates_v.id = p_id;
93: l_okl_ptlv_pk okl_ptlv_pk_csr%ROWTYPE;
94: l_ptlv_rec ptlv_rec_type;
95: BEGIN
96: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
97: x_no_data_found := TRUE;
98:
99: -- Get current database values
100: OPEN okl_ptlv_pk_csr (p_ptlv_rec.id);

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

116: x_ptlv_rec := l_ptlv_rec;
117: EXCEPTION
118: WHEN OTHERS THEN
119: -- store SQL error message on message stack
120: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
121: p_msg_name => G_UNEXPECTED_ERROR,
122: p_token1 => G_SQLCODE_TOKEN,
123: p_token1_value => SQLCODE,
124: p_token2 => G_SQLERRM_TOKEN,

Line 127: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

123: p_token1_value => SQLCODE,
124: p_token2 => G_SQLERRM_TOKEN,
125: p_token2_value => SQLERRM);
126: -- notify UNEXPECTED error for calling API.
127: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
128:
129: IF (okl_ptlv_pk_csr%ISOPEN) THEN
130: CLOSE okl_ptlv_pk_csr;
131: END IF;

Line 156: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

152: l_row_not_found BOOLEAN := FALSE;
153: BEGIN
154: /*
155: x_valid := TRUE;
156: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
157: -- Check for product template overlaps
158: l_sql_stmt := 'SELECT ''1'' ' ||
159: 'FROM ' || p_table ||
160: ' WHERE NAME = ' || '''' || p_name || '''' ||

Line 164: ' NVL(TO_DATE, ' || '''' || Okl_Api.G_MISS_DATE || '''' || ') OR ' ||

160: ' WHERE NAME = ' || '''' || p_name || '''' ||
161: ' AND ID <> ' || p_id ||
162: ' AND ( ' || '''' || p_from_date || '''' ||
163: ' BETWEEN FROM_DATE AND ' ||
164: ' NVL(TO_DATE, ' || '''' || Okl_Api.G_MISS_DATE || '''' || ') OR ' ||
165: '''' || p_to_date || '''' ||
166: ' BETWEEN FROM_DATE AND ' ||
167: ' NVL(TO_DATE, ' || '''' || Okl_Api.G_MISS_DATE || '''' || ')) ' ||
168: 'UNION ALL ' ||

Line 167: ' NVL(TO_DATE, ' || '''' || Okl_Api.G_MISS_DATE || '''' || ')) ' ||

163: ' BETWEEN FROM_DATE AND ' ||
164: ' NVL(TO_DATE, ' || '''' || Okl_Api.G_MISS_DATE || '''' || ') OR ' ||
165: '''' || p_to_date || '''' ||
166: ' BETWEEN FROM_DATE AND ' ||
167: ' NVL(TO_DATE, ' || '''' || Okl_Api.G_MISS_DATE || '''' || ')) ' ||
168: 'UNION ALL ' ||
169: 'SELECT ''2'' ' ||
170: 'FROM ' || p_table ||
171: ' WHERE NAME = ' || '''' || p_name || '''' ||

Line 176: ' >= NVL(TO_DATE, ' || '''' || Okl_Api.G_MISS_DATE || '''' || ') ';

172: ' AND ID <> ' || p_id ||
173: ' AND ' || '''' || p_from_date || '''' ||
174: ' <= FROM_DATE ' ||
175: 'AND ' || '''' || p_to_date || '''' ||
176: ' >= NVL(TO_DATE, ' || '''' || Okl_Api.G_MISS_DATE || '''' || ') ';
177: OPEN okl_all_overlaps_csr
178: FOR l_sql_stmt;
179: FETCH okl_all_overlaps_csr INTO l_check;
180: l_row_not_found := okl_all_overlaps_csr%NOTFOUND;

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

179: FETCH okl_all_overlaps_csr INTO l_check;
180: l_row_not_found := okl_all_overlaps_csr%NOTFOUND;
181: CLOSE okl_all_overlaps_csr;
182: IF l_row_not_found = FALSE THEN
183: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
184: p_msg_name => G_VERSION_OVERLAPS,
185: p_token1 => G_TABLE_TOKEN,
186: p_token1_value => p_table,
187: p_token2 => G_COL_NAME_TOKEN,

Line 190: x_return_status := Okl_Api.G_RET_STS_ERROR;

186: p_token1_value => p_table,
187: p_token2 => G_COL_NAME_TOKEN,
188: p_token2_value => 'NAME');
189: x_valid := FALSE;
190: x_return_status := Okl_Api.G_RET_STS_ERROR;
191: END IF;
192: */
193: null;
194: EXCEPTION

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

193: null;
194: EXCEPTION
195: WHEN OTHERS THEN
196: -- store SQL error message on message stack
197: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
198: p_msg_name => G_UNEXPECTED_ERROR,
199: p_token1 => G_SQLCODE_TOKEN,
200: p_token1_value => SQLCODE,
201: p_token2 => G_SQLERRM_TOKEN,

Line 204: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

200: p_token1_value => SQLCODE,
201: p_token2 => G_SQLERRM_TOKEN,
202: p_token2_value => SQLERRM);
203: x_valid := FALSE;
204: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
205:
206: IF (okl_all_overlaps_csr%ISOPEN) THEN
207: CLOSE okl_all_overlaps_csr;
208: END IF;

Line 274: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

270: l_to_date okl_pdt_templates_v.TO_DATE%TYPE;
271:
272: BEGIN
273: x_valid := TRUE;
274: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
275:
276: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_TEMPLATE_SERCH',
277: p_attribute_code => 'OKL_PRODUCT_TEMPLATES');
278:

Line 292: IF p_ptlv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN

288: l_token_5 := l_token_3 ||','||l_token_4;
289:
290: -- Check for product dates
291:
292: IF p_ptlv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN
293: l_to_date := NULL;
294: ELSE
295: l_to_date := p_ptlv_rec.TO_DATE;
296: END IF;

Line 298: IF p_ptlv_rec.id <> Okl_Api.G_MISS_NUM THEN

294: ELSE
295: l_to_date := p_ptlv_rec.TO_DATE;
296: END IF;
297:
298: IF p_ptlv_rec.id <> Okl_Api.G_MISS_NUM THEN
299:
300: OPEN okl_products_csr (p_upd_ptlv_rec.id,
301: p_ptlv_rec.from_date,
302: l_to_date

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

306: CLOSE okl_products_csr;
307:
308:
309: IF l_row_not_found = FALSE THEN
310: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
311: p_msg_name => G_DATES_MISMATCH,
312: p_token1 => G_PARENT_TABLE_TOKEN,
313: p_token1_value => l_token_1,
314: p_token2 => G_CHILD_TABLE_TOKEN,

Line 317: x_return_status := Okl_Api.G_RET_STS_ERROR;

313: p_token1_value => l_token_1,
314: p_token2 => G_CHILD_TABLE_TOKEN,
315: p_token2_value => l_token_2);
316: x_valid := FALSE;
317: x_return_status := Okl_Api.G_RET_STS_ERROR;
318: END IF;
319: END IF;
320:
321: -- Check for constraints dates

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

326: l_row_not_found := okl_ptl_constraints_csr%NOTFOUND;
327: CLOSE okl_ptl_constraints_csr;
328:
329: IF l_row_not_found = FALSE THEN
330: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
331: p_msg_name => G_DATES_MISMATCH,
332: p_token1 => G_PARENT_TABLE_TOKEN,
333: p_token1_value => l_token_5,
334: p_token2 => G_CHILD_TABLE_TOKEN,

Line 337: x_return_status := Okl_Api.G_RET_STS_ERROR;

333: p_token1_value => l_token_5,
334: p_token2 => G_CHILD_TABLE_TOKEN,
335: p_token2_value => l_token_1);
336: x_valid := FALSE;
337: x_return_status := Okl_Api.G_RET_STS_ERROR;
338: END IF;
339:
340: EXCEPTION
341: WHEN OTHERS THEN

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

339:
340: EXCEPTION
341: WHEN OTHERS THEN
342: -- store SQL error message on message stack
343: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
344: p_msg_name => G_UNEXPECTED_ERROR,
345: p_token1 => G_SQLCODE_TOKEN,
346: p_token1_value => SQLCODE,
347: p_token2 => G_SQLERRM_TOKEN,

Line 350: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

346: p_token1_value => SQLCODE,
347: p_token2 => G_SQLERRM_TOKEN,
348: p_token2_value => SQLERRM);
349: x_valid := FALSE;
350: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
351:
352: IF (okl_products_csr%ISOPEN) THEN
353: CLOSE okl_products_csr;
354: END IF;

Line 380: l_upd_ptlv_rec.description := Okl_Api.G_MISS_CHAR;

376: l_upd_ptlv_rec := p_upd_ptlv_rec;
377: l_db_ptlv_rec := p_db_ptlv_rec;
378:
379: IF l_upd_ptlv_rec.description = l_db_ptlv_rec.description THEN
380: l_upd_ptlv_rec.description := Okl_Api.G_MISS_CHAR;
381: END IF;
382:
383: IF to_date(to_char(l_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
384: l_upd_ptlv_rec.from_date := Okl_Api.G_MISS_DATE;

Line 384: l_upd_ptlv_rec.from_date := Okl_Api.G_MISS_DATE;

380: l_upd_ptlv_rec.description := Okl_Api.G_MISS_CHAR;
381: END IF;
382:
383: IF to_date(to_char(l_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
384: l_upd_ptlv_rec.from_date := Okl_Api.G_MISS_DATE;
385: END IF;
386:
387: IF to_date(to_char(l_upd_ptlv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_ptlv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
388: l_upd_ptlv_rec.TO_DATE := Okl_Api.G_MISS_DATE;

Line 388: l_upd_ptlv_rec.TO_DATE := Okl_Api.G_MISS_DATE;

384: l_upd_ptlv_rec.from_date := Okl_Api.G_MISS_DATE;
385: END IF;
386:
387: IF to_date(to_char(l_upd_ptlv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_ptlv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
388: l_upd_ptlv_rec.TO_DATE := Okl_Api.G_MISS_DATE;
389: END IF;
390:
391: p_upd_ptlv_rec := l_upd_ptlv_rec;
392:

Line 409: IF p_upd_ptlv_rec.description <> Okl_Api.G_MISS_CHAR THEN

405: BEGIN
406: /* create a temporary record with all relevant details from db and upd records */
407: l_ptlv_rec := p_db_ptlv_rec;
408:
409: IF p_upd_ptlv_rec.description <> Okl_Api.G_MISS_CHAR THEN
410: l_ptlv_rec.description := p_upd_ptlv_rec.description;
411: END IF;
412:
413: IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE THEN

Line 413: IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE THEN

409: IF p_upd_ptlv_rec.description <> Okl_Api.G_MISS_CHAR THEN
410: l_ptlv_rec.description := p_upd_ptlv_rec.description;
411: END IF;
412:
413: IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE THEN
414: l_ptlv_rec.from_date := p_upd_ptlv_rec.from_date;
415: END IF;
416:
417: IF p_upd_ptlv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN

Line 417: IF p_upd_ptlv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN

413: IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE THEN
414: l_ptlv_rec.from_date := p_upd_ptlv_rec.from_date;
415: END IF;
416:
417: IF p_upd_ptlv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
418: l_ptlv_rec.TO_DATE := p_upd_ptlv_rec.TO_DATE;
419: END IF;
420:
421: RETURN l_ptlv_rec;

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

433: x_msg_data OUT NOCOPY VARCHAR2
434: ) IS
435: l_upd_ptlv_rec ptlv_rec_type;
436: l_ptlv_rec ptlv_rec_type;
437: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
438: l_valid BOOLEAN;
439: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
440: BEGIN
441: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 441: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

437: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
438: l_valid BOOLEAN;
439: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
440: BEGIN
441: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
442: l_ptlv_rec := p_ptlv_rec;
443: l_upd_ptlv_rec := p_upd_ptlv_rec;
444:
445: /* check for start date greater than sysdate */

Line 446: /*IF to_date(to_char(p_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND

442: l_ptlv_rec := p_ptlv_rec;
443: l_upd_ptlv_rec := p_upd_ptlv_rec;
444:
445: /* check for start date greater than sysdate */
446: /*IF to_date(to_char(p_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND
447: to_date(to_char(p_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
448: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
449: p_msg_name => G_START_DATE);
450: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 448: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

444:
445: /* check for start date greater than sysdate */
446: /*IF to_date(to_char(p_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND
447: to_date(to_char(p_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
448: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
449: p_msg_name => G_START_DATE);
450: x_return_status := OKL_API.G_RET_STS_ERROR;
451: RAISE G_EXCEPTION_HALT_PROCESSING;
452: END IF; */

Line 450: x_return_status := OKL_API.G_RET_STS_ERROR;

446: /*IF to_date(to_char(p_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND
447: to_date(to_char(p_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
448: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
449: p_msg_name => G_START_DATE);
450: x_return_status := OKL_API.G_RET_STS_ERROR;
451: RAISE G_EXCEPTION_HALT_PROCESSING;
452: END IF; */
453:
454:

Line 457: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

453:
454:
455: /* check for the records with from and to dates less than sysdate */
456: /* IF to_date(to_char(p_upd_ptlv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
457: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
458: p_msg_name => G_PAST_RECORDS);
459: x_return_status := OKL_API.G_RET_STS_ERROR;
460: RAISE G_EXCEPTION_HALT_PROCESSING;
461: END IF;

Line 459: x_return_status := OKL_API.G_RET_STS_ERROR;

455: /* check for the records with from and to dates less than sysdate */
456: /* IF to_date(to_char(p_upd_ptlv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
457: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
458: p_msg_name => G_PAST_RECORDS);
459: x_return_status := OKL_API.G_RET_STS_ERROR;
460: RAISE G_EXCEPTION_HALT_PROCESSING;
461: END IF;
462: */
463:

Line 466: /* IF to_date(to_char(p_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND

462: */
463:
464: /* if the start date is in the past, the start date cannot be
465: modified */
466: /* IF to_date(to_char(p_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND
467: to_date(to_char(p_db_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <= l_sysdate THEN
468: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
469: p_msg_name => 'OKL_NOT_ALLOWED',
470: p_token1 => G_COL_NAME_TOKEN,

Line 468: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

464: /* if the start date is in the past, the start date cannot be
465: modified */
466: /* IF to_date(to_char(p_upd_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(OKL_API.G_MISS_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND
467: to_date(to_char(p_db_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <= l_sysdate THEN
468: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
469: p_msg_name => 'OKL_NOT_ALLOWED',
470: p_token1 => G_COL_NAME_TOKEN,
471: p_token1_value => 'START_DATE');
472: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 472: x_return_status := OKL_API.G_RET_STS_ERROR;

468: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
469: p_msg_name => 'OKL_NOT_ALLOWED',
470: p_token1 => G_COL_NAME_TOKEN,
471: p_token1_value => 'START_DATE');
472: x_return_status := OKL_API.G_RET_STS_ERROR;
473: RAISE G_EXCEPTION_HALT_PROCESSING;
474: END IF;
475:
476: */ IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE OR

Line 476: */ IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE OR

472: x_return_status := OKL_API.G_RET_STS_ERROR;
473: RAISE G_EXCEPTION_HALT_PROCESSING;
474: END IF;
475:
476: */ IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE OR
477: p_upd_ptlv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
478:
479: /* call check_overlaps */
480: /*check_overlaps(p_id => l_upd_ptlv_rec.id,

Line 477: p_upd_ptlv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN

473: RAISE G_EXCEPTION_HALT_PROCESSING;
474: END IF;
475:
476: */ IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE OR
477: p_upd_ptlv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
478:
479: /* call check_overlaps */
480: /*check_overlaps(p_id => l_upd_ptlv_rec.id,
481: p_name => l_ptlv_rec.name,

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

483: p_to_date => l_ptlv_rec.TO_DATE,
484: p_table => 'Okl_Pdt_Templates_V',
485: x_return_status => l_return_status,
486: x_valid => l_valid);
487: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
488: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
489: RAISE G_EXCEPTION_HALT_PROCESSING;
490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
491: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

Line 488: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

484: p_table => 'Okl_Pdt_Templates_V',
485: x_return_status => l_return_status,
486: x_valid => l_valid);
487: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
488: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
489: RAISE G_EXCEPTION_HALT_PROCESSING;
490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
491: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
492: l_valid <> TRUE) THEN

Line 490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR

486: x_valid => l_valid);
487: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
488: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
489: RAISE G_EXCEPTION_HALT_PROCESSING;
490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
491: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
492: l_valid <> TRUE) THEN
493: x_return_status := OKL_API.G_RET_STS_ERROR;
494: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 491: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

487: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
488: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
489: RAISE G_EXCEPTION_HALT_PROCESSING;
490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
491: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
492: l_valid <> TRUE) THEN
493: x_return_status := OKL_API.G_RET_STS_ERROR;
494: RAISE G_EXCEPTION_HALT_PROCESSING;
495: END IF;*/

Line 493: x_return_status := OKL_API.G_RET_STS_ERROR;

489: RAISE G_EXCEPTION_HALT_PROCESSING;
490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
491: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
492: l_valid <> TRUE) THEN
493: x_return_status := OKL_API.G_RET_STS_ERROR;
494: RAISE G_EXCEPTION_HALT_PROCESSING;
495: END IF;*/
496:
497: /* call check_constraints */

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

498: Check_Constraints(p_upd_ptlv_rec => l_upd_ptlv_rec,
499: p_ptlv_rec => l_ptlv_rec,
500: x_return_status => l_return_status,
501: x_valid => l_valid);
502: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
503: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
504: RAISE G_EXCEPTION_HALT_PROCESSING;
505: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
506: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

Line 503: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

499: p_ptlv_rec => l_ptlv_rec,
500: x_return_status => l_return_status,
501: x_valid => l_valid);
502: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
503: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
504: RAISE G_EXCEPTION_HALT_PROCESSING;
505: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
506: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
507: l_valid <> TRUE) THEN

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

501: x_valid => l_valid);
502: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
503: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
504: RAISE G_EXCEPTION_HALT_PROCESSING;
505: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
506: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
507: l_valid <> TRUE) THEN
508: x_return_status := Okl_Api.G_RET_STS_ERROR;
509: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 506: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

502: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
503: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
504: RAISE G_EXCEPTION_HALT_PROCESSING;
505: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
506: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
507: l_valid <> TRUE) THEN
508: x_return_status := Okl_Api.G_RET_STS_ERROR;
509: RAISE G_EXCEPTION_HALT_PROCESSING;
510: END IF;

Line 508: x_return_status := Okl_Api.G_RET_STS_ERROR;

504: RAISE G_EXCEPTION_HALT_PROCESSING;
505: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
506: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
507: l_valid <> TRUE) THEN
508: x_return_status := Okl_Api.G_RET_STS_ERROR;
509: RAISE G_EXCEPTION_HALT_PROCESSING;
510: END IF;
511:
512: END IF;

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

518: NULL;
519:
520: WHEN OTHERS THEN
521: -- store SQL error message on message stack for caller
522: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
523: p_msg_name => G_UNEXPECTED_ERROR,
524: p_token1 => G_SQLCODE_TOKEN,
525: p_token1_value => SQLCODE,
526: p_token2 => G_SQLERRM_TOKEN,

Line 530: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

526: p_token2 => G_SQLERRM_TOKEN,
527: p_token2_value => SQLERRM );
528: x_msg_data := 'Unexpected DATABASE Error';
529: -- notify caller of an UNEXPECTED error
530: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
531:
532: END check_updates;
533:
534: ---------------------------------------------------------------------------

Line 550: IF p_upd_ptlv_rec.from_date = Okl_Api.G_MISS_DATE AND

546: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
547: BEGIN
548:
549: /* Scenario 1: Only description changes */
550: IF p_upd_ptlv_rec.from_date = Okl_Api.G_MISS_DATE AND
551: p_upd_ptlv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN
552: l_action := '1';
553: /* Scenario 2: only changing description and end date for all records
554: or modified start date is less than existing start date */

Line 551: p_upd_ptlv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN

547: BEGIN
548:
549: /* Scenario 1: Only description changes */
550: IF p_upd_ptlv_rec.from_date = Okl_Api.G_MISS_DATE AND
551: p_upd_ptlv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN
552: l_action := '1';
553: /* Scenario 2: only changing description and end date for all records
554: or modified start date is less than existing start date */
555: /*ELSIF (p_upd_ptlv_rec.from_date = OKL_API.G_MISS_DATE AND

Line 555: /*ELSIF (p_upd_ptlv_rec.from_date = OKL_API.G_MISS_DATE AND

551: p_upd_ptlv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN
552: l_action := '1';
553: /* Scenario 2: only changing description and end date for all records
554: or modified start date is less than existing start date */
555: /*ELSIF (p_upd_ptlv_rec.from_date = OKL_API.G_MISS_DATE AND
556: p_upd_ptlv_rec.TO_DATE <> OKL_API.G_MISS_DATE) OR
557: (p_upd_ptlv_rec.from_date <> OKL_API.G_MISS_DATE AND
558: p_db_ptlv_rec.from_date > p_date AND
559: p_upd_ptlv_rec.from_date < p_db_ptlv_rec.from_date) THEN*/

Line 556: p_upd_ptlv_rec.TO_DATE <> OKL_API.G_MISS_DATE) OR

552: l_action := '1';
553: /* Scenario 2: only changing description and end date for all records
554: or modified start date is less than existing start date */
555: /*ELSIF (p_upd_ptlv_rec.from_date = OKL_API.G_MISS_DATE AND
556: p_upd_ptlv_rec.TO_DATE <> OKL_API.G_MISS_DATE) OR
557: (p_upd_ptlv_rec.from_date <> OKL_API.G_MISS_DATE AND
558: p_db_ptlv_rec.from_date > p_date AND
559: p_upd_ptlv_rec.from_date < p_db_ptlv_rec.from_date) THEN*/
560: ELSE

Line 557: (p_upd_ptlv_rec.from_date <> OKL_API.G_MISS_DATE AND

553: /* Scenario 2: only changing description and end date for all records
554: or modified start date is less than existing start date */
555: /*ELSIF (p_upd_ptlv_rec.from_date = OKL_API.G_MISS_DATE AND
556: p_upd_ptlv_rec.TO_DATE <> OKL_API.G_MISS_DATE) OR
557: (p_upd_ptlv_rec.from_date <> OKL_API.G_MISS_DATE AND
558: p_db_ptlv_rec.from_date > p_date AND
559: p_upd_ptlv_rec.from_date < p_db_ptlv_rec.from_date) THEN*/
560: ELSE
561: l_action := '2';

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

583: TO_DATE
584: FROM Okl_Ptl_Ptq_Vals_V pmv
585: WHERE pmv.PTL_ID = p_ptl_id;
586:
587: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
588: l_count NUMBER := 0;
589: l_pmvv_tbl pmvv_tbl_type;
590:
591: BEGIN

Line 592: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

588: l_count NUMBER := 0;
589: l_pmvv_tbl pmvv_tbl_type;
590:
591: BEGIN
592: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
593:
594: -- Get current database values
595: FOR okl_pmv_rec IN okl_pmvv_fk_csr(p_upd_ptlv_rec.id)
596: LOOP

Line 603: IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE THEN

599: END IF;
600: l_pmvv_tbl(l_count).PTL_ID := p_ptlv_rec.ID;
601: l_pmvv_tbl(l_count).PTQ_ID := okl_pmv_rec.PTQ_ID;
602: l_pmvv_tbl(l_count).PTV_ID := okl_pmv_rec.PTV_ID;
603: IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE THEN
604: l_pmvv_tbl(l_count).from_date := p_upd_ptlv_rec.from_date;
605: ELSE
606: l_pmvv_tbl(l_count).from_date := okl_pmv_rec.from_date;
607: END IF;

Line 608: IF p_upd_ptlv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN

604: l_pmvv_tbl(l_count).from_date := p_upd_ptlv_rec.from_date;
605: ELSE
606: l_pmvv_tbl(l_count).from_date := okl_pmv_rec.from_date;
607: END IF;
608: IF p_upd_ptlv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
609: l_pmvv_tbl(l_count).TO_DATE := p_upd_ptlv_rec.TO_DATE;
610: ELSE
611: l_pmvv_tbl(l_count).TO_DATE := okl_pmv_rec.TO_DATE;
612: END IF;

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

618:
619: EXCEPTION
620: WHEN OTHERS THEN
621: -- store SQL error message on message stack
622: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
623: p_msg_name => G_UNEXPECTED_ERROR,
624: p_token1 => G_SQLCODE_TOKEN,
625: p_token1_value => SQLCODE,
626: p_token2 => G_SQLERRM_TOKEN,

Line 629: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

625: p_token1_value => SQLCODE,
626: p_token2 => G_SQLERRM_TOKEN,
627: p_token2_value => SQLERRM );
628: -- notify UNEXPECTED error for calling API.
629: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
630:
631: IF (okl_pmvv_fk_csr%ISOPEN) THEN
632: CLOSE okl_pmvv_fk_csr;
633: END IF;

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

653: TO_DATE
654: FROM Okl_Pdt_Pqys_V pdq
655: WHERE pdq.PTL_ID = p_ptl_id;
656:
657: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
658: l_count NUMBER := 0;
659: l_pdqv_tbl pdqv_tbl_type;
660:
661: BEGIN

Line 662: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

658: l_count NUMBER := 0;
659: l_pdqv_tbl pdqv_tbl_type;
660:
661: BEGIN
662: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
663:
664: -- Get current database values
665: FOR okl_pdq_rec IN okl_pdqv_fk_csr(p_upd_ptlv_rec.id)
666: LOOP

Line 672: IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE THEN

668: l_pdqv_tbl(l_count).ID := okl_pdq_rec.ID;
669: END IF;
670: l_pdqv_tbl(l_count).PTL_ID := p_ptlv_rec.ID;
671: l_pdqv_tbl(l_count).PQY_ID := okl_pdq_rec.PQY_ID;
672: IF p_upd_ptlv_rec.from_date <> Okl_Api.G_MISS_DATE THEN
673: l_pdqv_tbl(l_count).from_date := p_upd_ptlv_rec.from_date;
674: ELSE
675: l_pdqv_tbl(l_count).from_date := okl_pdq_rec.from_date;
676: END IF;

Line 677: IF p_upd_ptlv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN

673: l_pdqv_tbl(l_count).from_date := p_upd_ptlv_rec.from_date;
674: ELSE
675: l_pdqv_tbl(l_count).from_date := okl_pdq_rec.from_date;
676: END IF;
677: IF p_upd_ptlv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
678: l_pdqv_tbl(l_count).TO_DATE := p_upd_ptlv_rec.TO_DATE;
679: ELSE
680: l_pdqv_tbl(l_count).TO_DATE := okl_pdq_rec.TO_DATE;
681: END IF;

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

687:
688: EXCEPTION
689: WHEN OTHERS THEN
690: -- store SQL error message on message stack
691: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
692: p_msg_name => G_UNEXPECTED_ERROR,
693: p_token1 => G_SQLCODE_TOKEN,
694: p_token1_value => SQLCODE,
695: p_token2 => G_SQLERRM_TOKEN,

Line 698: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

694: p_token1_value => SQLCODE,
695: p_token2 => G_SQLERRM_TOKEN,
696: p_token2_value => SQLERRM );
697: -- notify UNEXPECTED error for calling API.
698: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
699:
700: IF (okl_pdqv_fk_csr%ISOPEN) THEN
701: CLOSE okl_pdqv_fk_csr;
702: END IF;

Line 711: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

707: -- PROCEDURE copy_update_constraints for: OKL_PDT_TEMPLATES_V
708: -- To copy constraints data from one version to the other
709: ---------------------------------------------------------------------------
710: PROCEDURE copy_update_constraints (p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
712: p_upd_ptlv_rec IN ptlv_rec_type,
713: p_db_ptlv_rec IN ptlv_rec_type,
714: p_ptlv_rec IN ptlv_rec_type,
715: p_flag IN VARCHAR2,

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

719: ) IS
720: l_upd_ptlv_rec ptlv_rec_type; /* input copy */
721: l_ptlv_rec ptlv_rec_type; /* latest with the retained changes */
722: l_db_ptlv_rec ptlv_rec_type; /* for db copy */
723: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
724: l_pmv_count NUMBER := 0;
725: l_pdq_count NUMBER := 0;
726: l_pmvv_tbl pmvv_tbl_type;
727: l_out_pmvv_tbl pmvv_tbl_type;

Line 732: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

728: l_pdqv_tbl pdqv_tbl_type;
729: l_out_pdqv_tbl pdqv_tbl_type;
730:
731: BEGIN
732: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
733: l_upd_ptlv_rec := p_ptlv_rec;
734: l_ptlv_rec := p_ptlv_rec;
735: l_db_ptlv_rec := p_db_ptlv_rec;
736:

Line 744: IF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

740: p_flag => p_flag,
741: x_return_status => l_return_status,
742: x_count => l_pmv_count,
743: x_pmvv_tbl => l_pmvv_tbl);
744: IF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
745: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
746: RAISE G_EXCEPTION_HALT_PROCESSING;
747: END IF;
748:

Line 745: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

741: x_return_status => l_return_status,
742: x_count => l_pmv_count,
743: x_pmvv_tbl => l_pmvv_tbl);
744: IF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
745: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
746: RAISE G_EXCEPTION_HALT_PROCESSING;
747: END IF;
748:
749: IF l_pmv_count > 0 THEN

Line 767: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

763: x_msg_data => x_msg_data,
764: p_pmvv_tbl => l_pmvv_tbl,
765: x_pmvv_tbl => l_out_pmvv_tbl);
766: END IF;
767: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
768: x_return_status := Okl_Api.G_RET_STS_ERROR;
769: RAISE G_EXCEPTION_HALT_PROCESSING;
770: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
771: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 768: x_return_status := Okl_Api.G_RET_STS_ERROR;

764: p_pmvv_tbl => l_pmvv_tbl,
765: x_pmvv_tbl => l_out_pmvv_tbl);
766: END IF;
767: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
768: x_return_status := Okl_Api.G_RET_STS_ERROR;
769: RAISE G_EXCEPTION_HALT_PROCESSING;
770: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
771: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
772: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 770: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

766: END IF;
767: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
768: x_return_status := Okl_Api.G_RET_STS_ERROR;
769: RAISE G_EXCEPTION_HALT_PROCESSING;
770: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
771: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
772: RAISE G_EXCEPTION_HALT_PROCESSING;
773: END IF;
774: END IF;

Line 771: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

767: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
768: x_return_status := Okl_Api.G_RET_STS_ERROR;
769: RAISE G_EXCEPTION_HALT_PROCESSING;
770: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
771: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
772: RAISE G_EXCEPTION_HALT_PROCESSING;
773: END IF;
774: END IF;
775:

Line 783: IF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

779: p_flag => p_flag,
780: x_return_status => l_return_status,
781: x_count => l_pdq_count,
782: x_pdqv_tbl => l_pdqv_tbl);
783: IF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
784: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
785: RAISE G_EXCEPTION_HALT_PROCESSING;
786: END IF;
787:

Line 784: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

780: x_return_status => l_return_status,
781: x_count => l_pdq_count,
782: x_pdqv_tbl => l_pdqv_tbl);
783: IF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
784: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
785: RAISE G_EXCEPTION_HALT_PROCESSING;
786: END IF;
787:
788: IF l_pdq_count > 0 THEN

Line 806: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

802: x_msg_data => x_msg_data,
803: p_pdqv_tbl => l_pdqv_tbl,
804: x_pdqv_tbl => l_out_pdqv_tbl);
805: END IF;
806: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
807: x_return_status := Okl_Api.G_RET_STS_ERROR;
808: RAISE G_EXCEPTION_HALT_PROCESSING;
809: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
810: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 807: x_return_status := Okl_Api.G_RET_STS_ERROR;

803: p_pdqv_tbl => l_pdqv_tbl,
804: x_pdqv_tbl => l_out_pdqv_tbl);
805: END IF;
806: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
807: x_return_status := Okl_Api.G_RET_STS_ERROR;
808: RAISE G_EXCEPTION_HALT_PROCESSING;
809: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
810: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
811: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 809: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

805: END IF;
806: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
807: x_return_status := Okl_Api.G_RET_STS_ERROR;
808: RAISE G_EXCEPTION_HALT_PROCESSING;
809: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
810: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
811: RAISE G_EXCEPTION_HALT_PROCESSING;
812: END IF;
813:

Line 810: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

806: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
807: x_return_status := Okl_Api.G_RET_STS_ERROR;
808: RAISE G_EXCEPTION_HALT_PROCESSING;
809: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
810: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
811: RAISE G_EXCEPTION_HALT_PROCESSING;
812: END IF;
813:
814: END IF;

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

821: NULL;
822:
823: WHEN OTHERS THEN
824: -- store SQL error message on message stack
825: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
826: p_msg_name => G_UNEXPECTED_ERROR,
827: p_token1 => G_SQLCODE_TOKEN,
828: p_token1_value => SQLCODE,
829: p_token2 => G_SQLERRM_TOKEN,

Line 832: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

828: p_token1_value => SQLCODE,
829: p_token2 => G_SQLERRM_TOKEN,
830: p_token2_value => SQLERRM );
831: -- notify UNEXPECTED error for calling API.
832: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
833:
834: END copy_update_constraints;
835:
836: ---------------------------------------------------------------------------

Line 840: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

836: ---------------------------------------------------------------------------
837: -- PROCEDURE insert_pdttemplates for: OKL_PDT_TEMPLATES_V
838: ---------------------------------------------------------------------------
839: PROCEDURE insert_pdttemplates(p_api_version IN NUMBER,
840: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
841: x_return_status OUT NOCOPY VARCHAR2,
842: x_msg_count OUT NOCOPY NUMBER,
843: x_msg_data OUT NOCOPY VARCHAR2,
844: p_ptlv_rec IN ptlv_rec_type,

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

858: l_row_found BOOLEAN := FALSE;
859: l_api_version CONSTANT NUMBER := 1;
860: l_api_name CONSTANT VARCHAR2(30) := 'insert_pdttemplates';
861: l_valid BOOLEAN := TRUE;
862: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
863: l_ptlv_rec ptlv_rec_type;
864: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
865: BEGIN
866: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 866: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

862: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
863: l_ptlv_rec ptlv_rec_type;
864: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
865: BEGIN
866: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
867: l_ptlv_rec := p_ptlv_rec;
868:
869: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
870: p_pkg_name => G_PKG_NAME,

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

865: BEGIN
866: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
867: l_ptlv_rec := p_ptlv_rec;
868:
869: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
870: p_pkg_name => G_PKG_NAME,
871: p_init_msg_list => p_init_msg_list,
872: l_api_version => l_api_version,
873: p_api_version => p_api_version,

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

872: l_api_version => l_api_version,
873: p_api_version => p_api_version,
874: p_api_type => '_PVT',
875: x_return_status => l_return_status);
876: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
877: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
878: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
879: RAISE Okl_Api.G_EXCEPTION_ERROR;
880: END IF;

Line 877: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

873: p_api_version => p_api_version,
874: p_api_type => '_PVT',
875: x_return_status => l_return_status);
876: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
877: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
878: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
879: RAISE Okl_Api.G_EXCEPTION_ERROR;
880: END IF;
881:

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

874: p_api_type => '_PVT',
875: x_return_status => l_return_status);
876: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
877: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
878: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
879: RAISE Okl_Api.G_EXCEPTION_ERROR;
880: END IF;
881:
882: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_TEMPLATE_SERCH',

Line 879: RAISE Okl_Api.G_EXCEPTION_ERROR;

875: x_return_status => l_return_status);
876: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
877: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
878: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
879: RAISE Okl_Api.G_EXCEPTION_ERROR;
880: END IF;
881:
882: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_TEMPLATE_SERCH',
883: p_attribute_code => 'OKL_PRODUCT_TEMPLATES');

Line 893: Okl_Api.set_message('OKL',G_UNQS, G_TABLE_TOKEN, l_token_1);

889: l_row_found := c1%FOUND;
890: CLOSE c1;
891:
892: IF l_row_found THEN
893: Okl_Api.set_message('OKL',G_UNQS, G_TABLE_TOKEN, l_token_1);
894: RAISE Okl_Api.G_EXCEPTION_ERROR;
895: END IF;
896:
897: /* check for the records with from and to dates less than sysdate */

Line 894: RAISE Okl_Api.G_EXCEPTION_ERROR;

890: CLOSE c1;
891:
892: IF l_row_found THEN
893: Okl_Api.set_message('OKL',G_UNQS, G_TABLE_TOKEN, l_token_1);
894: RAISE Okl_Api.G_EXCEPTION_ERROR;
895: END IF;
896:
897: /* check for the records with from and to dates less than sysdate */
898: /*IF to_date(to_char(l_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate OR

Line 900: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

896:
897: /* check for the records with from and to dates less than sysdate */
898: /*IF to_date(to_char(l_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate OR
899: to_date(to_char(l_ptlv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
900: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
901: p_msg_name => G_PAST_RECORDS);
902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;*/
904:

Line 902: RAISE OKL_API.G_EXCEPTION_ERROR;

898: /*IF to_date(to_char(l_ptlv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate OR
899: to_date(to_char(l_ptlv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
900: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
901: p_msg_name => G_PAST_RECORDS);
902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;*/
904:
905: /* public api to insert pdttemplates */
906: Okl_Pdt_Templates_Pub.insert_pdt_templates(p_api_version => p_api_version,

Line 914: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

910: x_msg_data => x_msg_data,
911: p_ptlv_rec => l_ptlv_rec,
912: x_ptlv_rec => x_ptlv_rec);
913:
914: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
915: RAISE Okl_Api.G_EXCEPTION_ERROR;
916: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
917: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
918: END IF;

Line 915: RAISE Okl_Api.G_EXCEPTION_ERROR;

911: p_ptlv_rec => l_ptlv_rec,
912: x_ptlv_rec => x_ptlv_rec);
913:
914: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
915: RAISE Okl_Api.G_EXCEPTION_ERROR;
916: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
917: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
918: END IF;
919: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

Line 916: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

912: x_ptlv_rec => x_ptlv_rec);
913:
914: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
915: RAISE Okl_Api.G_EXCEPTION_ERROR;
916: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
917: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
918: END IF;
919: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
920: x_msg_data => x_msg_data);

Line 917: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

913:
914: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
915: RAISE Okl_Api.G_EXCEPTION_ERROR;
916: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
917: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
918: END IF;
919: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
920: x_msg_data => x_msg_data);
921: EXCEPTION

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

915: RAISE Okl_Api.G_EXCEPTION_ERROR;
916: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
917: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
918: END IF;
919: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
920: x_msg_data => x_msg_data);
921: EXCEPTION
922: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
923: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 922: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

918: END IF;
919: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
920: x_msg_data => x_msg_data);
921: EXCEPTION
922: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
923: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
924: p_pkg_name => G_PKG_NAME,
925: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
926: x_msg_count => x_msg_count,

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

919: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
920: x_msg_data => x_msg_data);
921: EXCEPTION
922: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
923: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
924: p_pkg_name => G_PKG_NAME,
925: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
926: x_msg_count => x_msg_count,
927: x_msg_data => x_msg_data,

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

921: EXCEPTION
922: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
923: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
924: p_pkg_name => G_PKG_NAME,
925: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
926: x_msg_count => x_msg_count,
927: x_msg_data => x_msg_data,
928: p_api_type => '_PVT');
929: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 929: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

925: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
926: x_msg_count => x_msg_count,
927: x_msg_data => x_msg_data,
928: p_api_type => '_PVT');
929: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
930: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
931: p_pkg_name => G_PKG_NAME,
932: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
933: x_msg_count => x_msg_count,

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

926: x_msg_count => x_msg_count,
927: x_msg_data => x_msg_data,
928: p_api_type => '_PVT');
929: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
930: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
931: p_pkg_name => G_PKG_NAME,
932: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
933: x_msg_count => x_msg_count,
934: x_msg_data => x_msg_data,

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

928: p_api_type => '_PVT');
929: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
930: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
931: p_pkg_name => G_PKG_NAME,
932: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
933: x_msg_count => x_msg_count,
934: x_msg_data => x_msg_data,
935: p_api_type => '_PVT');
936: WHEN OTHERS THEN

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

933: x_msg_count => x_msg_count,
934: x_msg_data => x_msg_data,
935: p_api_type => '_PVT');
936: WHEN OTHERS THEN
937: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
938: p_pkg_name => G_PKG_NAME,
939: p_exc_name => 'OTHERS',
940: x_msg_count => x_msg_count,
941: x_msg_data => x_msg_data,

Line 954: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

950: ---------------------------------------------------------------------------
951: -- PROCEDURE update_pdttemplates for: OKL_PDT_TEMPLATES_V
952: ---------------------------------------------------------------------------
953: PROCEDURE update_pdttemplates(p_api_version IN NUMBER,
954: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
955: x_return_status OUT NOCOPY VARCHAR2,
956: x_msg_count OUT NOCOPY NUMBER,
957: x_msg_data OUT NOCOPY VARCHAR2,
958: p_ptlv_rec IN ptlv_rec_type,

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

967: l_db_ptlv_rec ptlv_rec_type; /* database copy */
968: l_upd_ptlv_rec ptlv_rec_type; /* input copy */
969: l_ptlv_rec ptlv_rec_type; /* latest with the retained changes */
970: l_tmp_ptlv_rec ptlv_rec_type; /* for any other purposes */
971: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
972: l_action VARCHAR2(1);
973: l_new_version VARCHAR2(100);
974: l_pmv_count NUMBER := 0;
975: l_pdq_count NUMBER := 0;

Line 981: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

977: l_out_pmvv_tbl pmvv_tbl_type;
978: l_pdqv_tbl pdqv_tbl_type;
979: l_out_pdqv_tbl pdqv_tbl_type;
980: BEGIN
981: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
982: l_upd_ptlv_rec := p_ptlv_rec;
983:
984: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
985: p_pkg_name => G_PKG_NAME,

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

980: BEGIN
981: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
982: l_upd_ptlv_rec := p_ptlv_rec;
983:
984: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
985: p_pkg_name => G_PKG_NAME,
986: p_init_msg_list => p_init_msg_list,
987: l_api_version => l_api_version,
988: p_api_version => p_api_version,

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

987: l_api_version => l_api_version,
988: p_api_version => p_api_version,
989: p_api_type => '_PVT',
990: x_return_status => l_return_status);
991: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
994: RAISE Okl_Api.G_EXCEPTION_ERROR;
995: END IF;

Line 992: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

988: p_api_version => p_api_version,
989: p_api_type => '_PVT',
990: x_return_status => l_return_status);
991: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
994: RAISE Okl_Api.G_EXCEPTION_ERROR;
995: END IF;
996:

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

989: p_api_type => '_PVT',
990: x_return_status => l_return_status);
991: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
994: RAISE Okl_Api.G_EXCEPTION_ERROR;
995: END IF;
996:
997: /* fetch old details from the database */

Line 994: RAISE Okl_Api.G_EXCEPTION_ERROR;

990: x_return_status => l_return_status);
991: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
994: RAISE Okl_Api.G_EXCEPTION_ERROR;
995: END IF;
996:
997: /* fetch old details from the database */
998: get_rec(p_ptlv_rec => l_upd_ptlv_rec,

Line 1003: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR

999: x_return_status => l_return_status,
1000: x_no_data_found => l_no_data_found,
1001: x_ptlv_rec => l_db_ptlv_rec);
1002:
1003: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR
1004: l_no_data_found = TRUE THEN
1005: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1006: END IF;
1007:

Line 1005: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1001: x_ptlv_rec => l_db_ptlv_rec);
1002:
1003: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR
1004: l_no_data_found = TRUE THEN
1005: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1006: END IF;
1007:
1008: /* to reorganize the input accordingly */
1009: reorganize_inputs(p_upd_ptlv_rec => l_upd_ptlv_rec,

Line 1029: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1025: x_msg_data => x_msg_data,
1026: p_ptlv_rec => l_upd_ptlv_rec,
1027: x_ptlv_rec => x_ptlv_rec);
1028:
1029: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1030: RAISE Okl_Api.G_EXCEPTION_ERROR;
1031: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1032: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1033: END IF;

Line 1030: RAISE Okl_Api.G_EXCEPTION_ERROR;

1026: p_ptlv_rec => l_upd_ptlv_rec,
1027: x_ptlv_rec => x_ptlv_rec);
1028:
1029: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1030: RAISE Okl_Api.G_EXCEPTION_ERROR;
1031: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1032: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1033: END IF;
1034:

Line 1031: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1027: x_ptlv_rec => x_ptlv_rec);
1028:
1029: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1030: RAISE Okl_Api.G_EXCEPTION_ERROR;
1031: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1032: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1033: END IF;
1034:
1035: /* Scenario 2: only changing description and end date for all records

Line 1032: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1028:
1029: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1030: RAISE Okl_Api.G_EXCEPTION_ERROR;
1031: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1032: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1033: END IF;
1034:
1035: /* Scenario 2: only changing description and end date for all records
1036: or modified start date is less than existing start date for a future record */

Line 1050: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1046: p_db_ptlv_rec => l_db_ptlv_rec,
1047: p_ptlv_rec => l_ptlv_rec,
1048: x_return_status => l_return_status,
1049: x_msg_data => x_msg_data);
1050: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1051: RAISE Okl_Api.G_EXCEPTION_ERROR;
1052: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1053: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1054: END IF;

Line 1051: RAISE Okl_Api.G_EXCEPTION_ERROR;

1047: p_ptlv_rec => l_ptlv_rec,
1048: x_return_status => l_return_status,
1049: x_msg_data => x_msg_data);
1050: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1051: RAISE Okl_Api.G_EXCEPTION_ERROR;
1052: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1053: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1054: END IF;
1055:

Line 1052: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1048: x_return_status => l_return_status,
1049: x_msg_data => x_msg_data);
1050: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1051: RAISE Okl_Api.G_EXCEPTION_ERROR;
1052: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1053: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1054: END IF;
1055:
1056: /* public api to update product templates */

Line 1053: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1049: x_msg_data => x_msg_data);
1050: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1051: RAISE Okl_Api.G_EXCEPTION_ERROR;
1052: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1053: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1054: END IF;
1055:
1056: /* public api to update product templates */
1057: Okl_Pdt_Templates_Pub.update_pdt_templates(p_api_version => p_api_version,

Line 1064: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1060: x_msg_count => x_msg_count,
1061: x_msg_data => x_msg_data,
1062: p_ptlv_rec => l_upd_ptlv_rec,
1063: x_ptlv_rec => x_ptlv_rec);
1064: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1065: RAISE Okl_Api.G_EXCEPTION_ERROR;
1066: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1067: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1068: END IF;

Line 1065: RAISE Okl_Api.G_EXCEPTION_ERROR;

1061: x_msg_data => x_msg_data,
1062: p_ptlv_rec => l_upd_ptlv_rec,
1063: x_ptlv_rec => x_ptlv_rec);
1064: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1065: RAISE Okl_Api.G_EXCEPTION_ERROR;
1066: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1067: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1068: END IF;
1069:

Line 1066: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1062: p_ptlv_rec => l_upd_ptlv_rec,
1063: x_ptlv_rec => x_ptlv_rec);
1064: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1065: RAISE Okl_Api.G_EXCEPTION_ERROR;
1066: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1067: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1068: END IF;
1069:
1070: /* update constraints */

Line 1067: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1063: x_ptlv_rec => x_ptlv_rec);
1064: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1065: RAISE Okl_Api.G_EXCEPTION_ERROR;
1066: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1067: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1068: END IF;
1069:
1070: /* update constraints */
1071: /* copy_update_constraints(p_api_version => p_api_version,

Line 1080: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1076: p_flag => G_UPDATE,
1077: x_return_status => l_return_status,
1078: x_msg_count => x_msg_count,
1079: x_msg_data => x_msg_data);
1080: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1081: RAISE OKL_API.G_EXCEPTION_ERROR;
1082: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1083: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1084: END IF;

Line 1081: RAISE OKL_API.G_EXCEPTION_ERROR;

1077: x_return_status => l_return_status,
1078: x_msg_count => x_msg_count,
1079: x_msg_data => x_msg_data);
1080: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1081: RAISE OKL_API.G_EXCEPTION_ERROR;
1082: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1083: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1084: END IF;
1085: */

Line 1082: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1078: x_msg_count => x_msg_count,
1079: x_msg_data => x_msg_data);
1080: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1081: RAISE OKL_API.G_EXCEPTION_ERROR;
1082: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1083: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1084: END IF;
1085: */
1086: END IF;

Line 1083: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1079: x_msg_data => x_msg_data);
1080: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1081: RAISE OKL_API.G_EXCEPTION_ERROR;
1082: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1083: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1084: END IF;
1085: */
1086: END IF;
1087:

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

1084: END IF;
1085: */
1086: END IF;
1087:
1088: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
1089: x_msg_data => x_msg_data);
1090: EXCEPTION
1091: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1092: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 1091: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1087:
1088: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
1089: x_msg_data => x_msg_data);
1090: EXCEPTION
1091: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1092: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1093: p_pkg_name => G_PKG_NAME,
1094: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1095: x_msg_count => x_msg_count,

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

1088: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
1089: x_msg_data => x_msg_data);
1090: EXCEPTION
1091: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1092: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1093: p_pkg_name => G_PKG_NAME,
1094: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1095: x_msg_count => x_msg_count,
1096: x_msg_data => x_msg_data,

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

1090: EXCEPTION
1091: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1092: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1093: p_pkg_name => G_PKG_NAME,
1094: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1095: x_msg_count => x_msg_count,
1096: x_msg_data => x_msg_data,
1097: p_api_type => '_PVT');
1098: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1098: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1094: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1095: x_msg_count => x_msg_count,
1096: x_msg_data => x_msg_data,
1097: p_api_type => '_PVT');
1098: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1099: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1100: p_pkg_name => G_PKG_NAME,
1101: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1102: x_msg_count => x_msg_count,

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

1095: x_msg_count => x_msg_count,
1096: x_msg_data => x_msg_data,
1097: p_api_type => '_PVT');
1098: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1099: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1100: p_pkg_name => G_PKG_NAME,
1101: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1102: x_msg_count => x_msg_count,
1103: x_msg_data => x_msg_data,

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

1097: p_api_type => '_PVT');
1098: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1099: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1100: p_pkg_name => G_PKG_NAME,
1101: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1102: x_msg_count => x_msg_count,
1103: x_msg_data => x_msg_data,
1104: p_api_type => '_PVT');
1105: WHEN OTHERS THEN

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

1102: x_msg_count => x_msg_count,
1103: x_msg_data => x_msg_data,
1104: p_api_type => '_PVT');
1105: WHEN OTHERS THEN
1106: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1107: p_pkg_name => G_PKG_NAME,
1108: p_exc_name => 'OTHERS',
1109: x_msg_count => x_msg_count,
1110: x_msg_data => x_msg_data,