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

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

17: SELECT
18: ID,
19: OBJECT_VERSION_NUMBER,
20: NAME,
21: NVL(DESCRIPTION,Okl_Api.G_MISS_CHAR) DESCRIPTION,
22: FROM_DATE,
23: NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
24: NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
25: NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,

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

19: OBJECT_VERSION_NUMBER,
20: NAME,
21: NVL(DESCRIPTION,Okl_Api.G_MISS_CHAR) DESCRIPTION,
22: FROM_DATE,
23: NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
24: NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
25: NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,
26: NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
27: NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,

Line 24: NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,

20: NAME,
21: NVL(DESCRIPTION,Okl_Api.G_MISS_CHAR) DESCRIPTION,
22: FROM_DATE,
23: NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
24: NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
25: NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,
26: NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
27: NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
28: NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,

Line 25: NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,

21: NVL(DESCRIPTION,Okl_Api.G_MISS_CHAR) DESCRIPTION,
22: FROM_DATE,
23: NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
24: NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
25: NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,
26: NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
27: NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
28: NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
29: NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,

Line 26: NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,

22: FROM_DATE,
23: NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
24: NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
25: NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,
26: NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
27: NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
28: NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
29: NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
30: NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,

Line 27: NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,

23: NVL(TO_DATE,Okl_Api.G_MISS_DATE) TO_DATE,
24: NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
25: NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,
26: NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
27: NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
28: NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
29: NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
30: NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
31: NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,

Line 28: NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,

24: NVL(ATTRIBUTE_CATEGORY, Okl_Api.G_MISS_CHAR) ATTRIBUTE_CATEGORY,
25: NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,
26: NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
27: NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
28: NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
29: NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
30: NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
31: NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
32: NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,

Line 29: NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,

25: NVL(ATTRIBUTE1, Okl_Api.G_MISS_CHAR) ATTRIBUTE1,
26: NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
27: NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
28: NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
29: NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
30: NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
31: NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
32: NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
33: NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,

Line 30: NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,

26: NVL(ATTRIBUTE2, Okl_Api.G_MISS_CHAR) ATTRIBUTE2,
27: NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
28: NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
29: NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
30: NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
31: NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
32: NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
33: NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
34: NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,

Line 31: NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,

27: NVL(ATTRIBUTE3, Okl_Api.G_MISS_CHAR) ATTRIBUTE3,
28: NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
29: NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
30: NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
31: NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
32: NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
33: NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
34: NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
35: NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,

Line 32: NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,

28: NVL(ATTRIBUTE4, Okl_Api.G_MISS_CHAR) ATTRIBUTE4,
29: NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
30: NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
31: NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
32: NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
33: NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
34: NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
35: NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
36: NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,

Line 33: NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,

29: NVL(ATTRIBUTE5, Okl_Api.G_MISS_CHAR) ATTRIBUTE5,
30: NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
31: NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
32: NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
33: NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
34: NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
35: NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
36: NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,
37: NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,

Line 34: NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,

30: NVL(ATTRIBUTE6, Okl_Api.G_MISS_CHAR) ATTRIBUTE6,
31: NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
32: NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
33: NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
34: NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
35: NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
36: NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,
37: NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,
38: NVL(ATTRIBUTE14, Okl_Api.G_MISS_CHAR) ATTRIBUTE14,

Line 35: NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,

31: NVL(ATTRIBUTE7, Okl_Api.G_MISS_CHAR) ATTRIBUTE7,
32: NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
33: NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
34: NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
35: NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
36: NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,
37: NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,
38: NVL(ATTRIBUTE14, Okl_Api.G_MISS_CHAR) ATTRIBUTE14,
39: NVL(ATTRIBUTE15, Okl_Api.G_MISS_CHAR) ATTRIBUTE15,

Line 36: NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,

32: NVL(ATTRIBUTE8, Okl_Api.G_MISS_CHAR) ATTRIBUTE8,
33: NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
34: NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
35: NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
36: NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,
37: NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,
38: NVL(ATTRIBUTE14, Okl_Api.G_MISS_CHAR) ATTRIBUTE14,
39: NVL(ATTRIBUTE15, Okl_Api.G_MISS_CHAR) ATTRIBUTE15,
40: CREATED_BY,

Line 37: NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,

33: NVL(ATTRIBUTE9, Okl_Api.G_MISS_CHAR) ATTRIBUTE9,
34: NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
35: NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
36: NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,
37: NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,
38: NVL(ATTRIBUTE14, Okl_Api.G_MISS_CHAR) ATTRIBUTE14,
39: NVL(ATTRIBUTE15, Okl_Api.G_MISS_CHAR) ATTRIBUTE15,
40: CREATED_BY,
41: CREATION_DATE,

Line 38: NVL(ATTRIBUTE14, Okl_Api.G_MISS_CHAR) ATTRIBUTE14,

34: NVL(ATTRIBUTE10, Okl_Api.G_MISS_CHAR) ATTRIBUTE10,
35: NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
36: NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,
37: NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,
38: NVL(ATTRIBUTE14, Okl_Api.G_MISS_CHAR) ATTRIBUTE14,
39: NVL(ATTRIBUTE15, Okl_Api.G_MISS_CHAR) ATTRIBUTE15,
40: CREATED_BY,
41: CREATION_DATE,
42: LAST_UPDATED_BY,

Line 39: NVL(ATTRIBUTE15, Okl_Api.G_MISS_CHAR) ATTRIBUTE15,

35: NVL(ATTRIBUTE11, Okl_Api.G_MISS_CHAR) ATTRIBUTE11,
36: NVL(ATTRIBUTE12, Okl_Api.G_MISS_CHAR) ATTRIBUTE12,
37: NVL(ATTRIBUTE13, Okl_Api.G_MISS_CHAR) ATTRIBUTE13,
38: NVL(ATTRIBUTE14, Okl_Api.G_MISS_CHAR) ATTRIBUTE14,
39: NVL(ATTRIBUTE15, Okl_Api.G_MISS_CHAR) ATTRIBUTE15,
40: CREATED_BY,
41: CREATION_DATE,
42: LAST_UPDATED_BY,
43: LAST_UPDATE_DATE,

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

40: CREATED_BY,
41: CREATION_DATE,
42: LAST_UPDATED_BY,
43: LAST_UPDATE_DATE,
44: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
45: FROM Okl_Options_V
46: WHERE okl_options_v.id = p_id;
47: l_okl_optv_pk okl_optv_pk_csr%ROWTYPE;
48: l_optv_rec optv_rec_type;

Line 50: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

46: WHERE okl_options_v.id = p_id;
47: l_okl_optv_pk okl_optv_pk_csr%ROWTYPE;
48: l_optv_rec optv_rec_type;
49: BEGIN
50: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
51: x_no_data_found := TRUE;
52:
53: -- Get current database values
54: OPEN okl_optv_pk_csr (p_optv_rec.id);

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

85: x_optv_rec := l_optv_rec;
86: EXCEPTION
87: WHEN OTHERS THEN
88: -- store SQL error message on message stack
89: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
90: p_msg_name => G_UNEXPECTED_ERROR,
91: p_token1 => G_SQLCODE_TOKEN,
92: p_token1_value => SQLCODE,
93: p_token2 => G_SQLERRM_TOKEN,

Line 96: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

92: p_token1_value => SQLCODE,
93: p_token2 => G_SQLERRM_TOKEN,
94: p_token2_value => SQLERRM);
95: -- notify UNEXPECTED error for calling API.
96: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
97:
98: IF (okl_optv_pk_csr%ISOPEN) THEN
99: CLOSE okl_optv_pk_csr;
100: END IF;

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

117: FROM Okl_opt_Values_V ove
118: WHERE ove.opt_id = p_opt_id
119: AND ove.TO_DATE IS NULL;
120:
121: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
122: l_count NUMBER := 0;
123: l_ovev_tbl ovev_tbl_type;
124: i NUMBER := 0;
125:

Line 127: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

123: l_ovev_tbl ovev_tbl_type;
124: i NUMBER := 0;
125:
126: BEGIN
127: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
128:
129: -- Get current database values
130: FOR okl_ove_rec IN okl_ovev_fk_csr(p_upd_optv_rec.id)
131: LOOP

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

139:
140: EXCEPTION
141: WHEN OTHERS THEN
142: -- store SQL error message on message stack
143: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
144: p_msg_name => G_UNEXPECTED_ERROR,
145: p_token1 => G_SQLCODE_TOKEN,
146: p_token1_value => SQLCODE,
147: p_token2 => G_SQLERRM_TOKEN,

Line 150: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

146: p_token1_value => SQLCODE,
147: p_token2 => G_SQLERRM_TOKEN,
148: p_token2_value => SQLERRM );
149: -- notify UNEXPECTED error for calling API.
150: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
151:
152: IF (okl_ovev_fk_csr%ISOPEN) THEN
153: CLOSE okl_ovev_fk_csr;
154: END IF;

Line 221: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

217: l_row_not_found BOOLEAN := FALSE;
218: l_to_date okl_options_v.TO_DATE%TYPE;
219: BEGIN
220: x_valid := TRUE;
221: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
222:
223: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',
224: p_attribute_code => 'OKL_OPTIONS');
225:

Line 237: IF p_optv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN

233: p_attribute_code => 'OKL_PRODUCT_OPTIONS');
234:
235:
236: -- Fix for g_miss_date
237: IF p_optv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN
238: l_to_date := NULL;
239: ELSE
240: l_to_date := p_optv_rec.TO_DATE;
241: END IF;

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

249: l_row_not_found := okl_opt_orl_fk_csr%NOTFOUND;
250: CLOSE okl_opt_orl_fk_csr;
251:
252: IF l_row_not_found = FALSE THEN
253: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
254: p_msg_name => G_DATES_MISMATCH,
255: p_token1 => G_PARENT_TABLE_TOKEN,
256: p_token1_value => l_token_1,
257: p_token2 => G_CHILD_TABLE_TOKEN,

Line 260: x_return_status := Okl_Api.G_RET_STS_ERROR;

256: p_token1_value => l_token_1,
257: p_token2 => G_CHILD_TABLE_TOKEN,
258: p_token2_value => l_token_2);
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: -- Check for option values dates

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

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

Line 280: x_return_status := Okl_Api.G_RET_STS_ERROR;

276: p_token1_value => l_token_1,
277: p_token2 => G_CHILD_TABLE_TOKEN,
278: p_token2_value => l_token_3);
279: x_valid := FALSE;
280: x_return_status := Okl_Api.G_RET_STS_ERROR;
281: RAISE G_EXCEPTION_HALT_PROCESSING;
282: END IF;
283:
284: -- Check for product dates

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

289: l_row_not_found := okl_opt_pon_fk_csr%NOTFOUND;
290: CLOSE okl_opt_pon_fk_csr;
291:
292: IF l_row_not_found = FALSE THEN
293: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
294: p_msg_name => G_DATES_MISMATCH,
295: p_token1 => G_PARENT_TABLE_TOKEN,
296: p_token1_value => l_token_1,
297: p_token2 => G_CHILD_TABLE_TOKEN,

Line 300: x_return_status := Okl_Api.G_RET_STS_ERROR;

296: p_token1_value => l_token_1,
297: p_token2 => G_CHILD_TABLE_TOKEN,
298: p_token2_value => l_token_4);
299: x_valid := FALSE;
300: x_return_status := Okl_Api.G_RET_STS_ERROR;
301: RAISE G_EXCEPTION_HALT_PROCESSING;
302: END IF;
303:
304: EXCEPTION

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

308: NULL;
309:
310: WHEN OTHERS THEN
311: -- store SQL error message on message stack
312: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
313: p_msg_name => G_UNEXPECTED_ERROR,
314: p_token1 => G_SQLCODE_TOKEN,
315: p_token1_value => SQLCODE,
316: p_token2 => G_SQLERRM_TOKEN,

Line 319: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

315: p_token1_value => SQLCODE,
316: p_token2 => G_SQLERRM_TOKEN,
317: p_token2_value => SQLERRM);
318: x_valid := FALSE;
319: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
320:
321: IF (okl_opt_orl_fk_csr%ISOPEN) THEN
322: CLOSE okl_opt_orl_fk_csr;
323: END IF;

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

349: PROCEDURE Validate_Name(
350: p_optv_rec IN OUT NOCOPY optv_rec_type,
351: x_return_status OUT NOCOPY VARCHAR2
352: ) IS
353: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
354: l_token_1 VARCHAR2(999);
355: BEGIN
356:
357: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTION_CRUPD','OKL_NAME');

Line 358: IF p_optv_rec.name = Okl_Api.G_MISS_CHAR OR

354: l_token_1 VARCHAR2(999);
355: BEGIN
356:
357: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTION_CRUPD','OKL_NAME');
358: IF p_optv_rec.name = Okl_Api.G_MISS_CHAR OR
359: p_optv_rec.name IS NULL
360: THEN
361: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);
362: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 361: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);

357: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTION_CRUPD','OKL_NAME');
358: IF p_optv_rec.name = Okl_Api.G_MISS_CHAR OR
359: p_optv_rec.name IS NULL
360: THEN
361: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);
362: x_return_status := Okl_Api.G_RET_STS_ERROR;
363: END IF;
364: p_optv_rec.name := Okl_Accounting_Util.okl_upper(p_optv_rec.name);
365: EXCEPTION

Line 362: x_return_status := Okl_Api.G_RET_STS_ERROR;

358: IF p_optv_rec.name = Okl_Api.G_MISS_CHAR OR
359: p_optv_rec.name IS NULL
360: THEN
361: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);
362: x_return_status := Okl_Api.G_RET_STS_ERROR;
363: END IF;
364: p_optv_rec.name := Okl_Accounting_Util.okl_upper(p_optv_rec.name);
365: EXCEPTION
366: WHEN OTHERS THEN

Line 367: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,

363: END IF;
364: p_optv_rec.name := Okl_Accounting_Util.okl_upper(p_optv_rec.name);
365: EXCEPTION
366: WHEN OTHERS THEN
367: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,
368: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
369: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
370: p_token1_value =>SQLCODE,
371: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,

Line 373: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

369: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
370: p_token1_value =>SQLCODE,
371: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
372: p_token2_value =>SQLERRM);
373: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
374:
375: END Validate_Name;
376: ------end of Validate_Name-----------------------------------
377:

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

390: PROCEDURE Validate_From_Date(
391: p_optv_rec IN optv_rec_type,
392: x_return_status OUT NOCOPY VARCHAR2
393: ) IS
394: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
395: l_token_1 VARCHAR2(999);
396: BEGIN
397: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTION_CRUPD','OKL_EFFECTIVE_FROM');
398: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = Okl_Api.G_MISS_DATE

Line 398: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = Okl_Api.G_MISS_DATE

394: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
395: l_token_1 VARCHAR2(999);
396: BEGIN
397: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTION_CRUPD','OKL_EFFECTIVE_FROM');
398: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = Okl_Api.G_MISS_DATE
399: THEN
400: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);
401: x_return_status := Okl_Api.G_RET_STS_ERROR;
402: END IF;

Line 400: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);

396: BEGIN
397: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTION_CRUPD','OKL_EFFECTIVE_FROM');
398: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = Okl_Api.G_MISS_DATE
399: THEN
400: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);
401: x_return_status := Okl_Api.G_RET_STS_ERROR;
402: END IF;
403: EXCEPTION
404: WHEN OTHERS THEN

Line 401: x_return_status := Okl_Api.G_RET_STS_ERROR;

397: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTION_CRUPD','OKL_EFFECTIVE_FROM');
398: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = Okl_Api.G_MISS_DATE
399: THEN
400: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);
401: x_return_status := Okl_Api.G_RET_STS_ERROR;
402: END IF;
403: EXCEPTION
404: WHEN OTHERS THEN
405: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,

Line 405: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,

401: x_return_status := Okl_Api.G_RET_STS_ERROR;
402: END IF;
403: EXCEPTION
404: WHEN OTHERS THEN
405: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,
406: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
407: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
408: p_token1_value =>SQLCODE,
409: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,

Line 411: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

407: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
408: p_token1_value =>SQLCODE,
409: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
410: p_token2_value =>SQLERRM);
411: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
412:
413: END Validate_From_Date;
414: ------end of Validate_From_Date-----------------------------------
415:

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

429:
430: FUNCTION Validate_Attributes(
431: p_optv_rec IN OUT NOCOPY optv_rec_type
432: ) RETURN VARCHAR IS
433: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
434: l_return_status VARCHAR2(1):= Okl_Api.G_RET_STS_SUCCESS;
435:
436:
437: BEGIN

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

430: FUNCTION Validate_Attributes(
431: p_optv_rec IN OUT NOCOPY optv_rec_type
432: ) RETURN VARCHAR IS
433: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
434: l_return_status VARCHAR2(1):= Okl_Api.G_RET_STS_SUCCESS;
435:
436:
437: BEGIN
438: -------CHECK FOR NAME------------------

Line 440: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

436:
437: BEGIN
438: -------CHECK FOR NAME------------------
439: Validate_Name (p_optv_rec, x_return_status);
440: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
441: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
442: -- need to leave
443: l_return_status := x_return_status;
444: RAISE G_EXCEPTION_HALT_PROCESSING;

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

437: BEGIN
438: -------CHECK FOR NAME------------------
439: Validate_Name (p_optv_rec, x_return_status);
440: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
441: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
442: -- need to leave
443: l_return_status := x_return_status;
444: RAISE G_EXCEPTION_HALT_PROCESSING;
445: ELSE

Line 452: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

448: END IF;
449:
450: -----CHECK FOR FROM_DATE----------------------------
451: Validate_From_Date (p_optv_rec, x_return_status);
452: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
453: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
454: -- need to leave
455: l_return_status := x_return_status;
456: RAISE G_EXCEPTION_HALT_PROCESSING;

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

449:
450: -----CHECK FOR FROM_DATE----------------------------
451: Validate_From_Date (p_optv_rec, x_return_status);
452: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
453: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
454: -- need to leave
455: l_return_status := x_return_status;
456: RAISE G_EXCEPTION_HALT_PROCESSING;
457: ELSE

Line 471: Okl_Api.set_message(p_app_name =>G_APP_NAME,

467: NULL;
468: RETURN (l_return_status);
469:
470: WHEN OTHERS THEN
471: Okl_Api.set_message(p_app_name =>G_APP_NAME,
472: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
473: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
474: p_token1_value =>SQLCODE,
475: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,

Line 477: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

473: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
474: p_token1_value =>SQLCODE,
475: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
476: p_token2_value =>SQLERRM);
477: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
478: RETURN(l_return_status);
479:
480: END Validate_Attributes;
481:

Line 501: l_upd_optv_rec.description := Okl_Api.G_MISS_CHAR;

497: l_upd_optv_rec := p_upd_optv_rec;
498: l_db_optv_rec := p_db_optv_rec;
499:
500: IF l_upd_optv_rec.description = l_db_optv_rec.description THEN
501: l_upd_optv_rec.description := Okl_Api.G_MISS_CHAR;
502: END IF;
503:
504: IF to_date(to_char(l_upd_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
505: l_upd_optv_rec.from_date := Okl_Api.G_MISS_DATE;

Line 505: l_upd_optv_rec.from_date := Okl_Api.G_MISS_DATE;

501: l_upd_optv_rec.description := Okl_Api.G_MISS_CHAR;
502: END IF;
503:
504: IF to_date(to_char(l_upd_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
505: l_upd_optv_rec.from_date := Okl_Api.G_MISS_DATE;
506: END IF;
507:
508: IF to_date(to_char(l_upd_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
509: l_upd_optv_rec.TO_DATE := Okl_Api.G_MISS_DATE;

Line 509: l_upd_optv_rec.TO_DATE := Okl_Api.G_MISS_DATE;

505: l_upd_optv_rec.from_date := Okl_Api.G_MISS_DATE;
506: END IF;
507:
508: IF to_date(to_char(l_upd_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') = to_date(to_char(l_db_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') THEN
509: l_upd_optv_rec.TO_DATE := Okl_Api.G_MISS_DATE;
510: END IF;
511:
512: IF l_upd_optv_rec.attribute_category = l_db_optv_rec.attribute_category THEN
513: l_upd_optv_rec.attribute_category := Okl_Api.G_MISS_CHAR;

Line 513: l_upd_optv_rec.attribute_category := Okl_Api.G_MISS_CHAR;

509: l_upd_optv_rec.TO_DATE := Okl_Api.G_MISS_DATE;
510: END IF;
511:
512: IF l_upd_optv_rec.attribute_category = l_db_optv_rec.attribute_category THEN
513: l_upd_optv_rec.attribute_category := Okl_Api.G_MISS_CHAR;
514: END IF;
515:
516: IF l_upd_optv_rec.attribute1 = l_db_optv_rec.attribute1 THEN
517: l_upd_optv_rec.attribute1 := Okl_Api.G_MISS_CHAR;

Line 517: l_upd_optv_rec.attribute1 := Okl_Api.G_MISS_CHAR;

513: l_upd_optv_rec.attribute_category := Okl_Api.G_MISS_CHAR;
514: END IF;
515:
516: IF l_upd_optv_rec.attribute1 = l_db_optv_rec.attribute1 THEN
517: l_upd_optv_rec.attribute1 := Okl_Api.G_MISS_CHAR;
518: END IF;
519:
520: IF l_upd_optv_rec.attribute2 = l_db_optv_rec.attribute2 THEN
521: l_upd_optv_rec.attribute2 := Okl_Api.G_MISS_CHAR;

Line 521: l_upd_optv_rec.attribute2 := Okl_Api.G_MISS_CHAR;

517: l_upd_optv_rec.attribute1 := Okl_Api.G_MISS_CHAR;
518: END IF;
519:
520: IF l_upd_optv_rec.attribute2 = l_db_optv_rec.attribute2 THEN
521: l_upd_optv_rec.attribute2 := Okl_Api.G_MISS_CHAR;
522: END IF;
523:
524: IF l_upd_optv_rec.attribute3 = l_db_optv_rec.attribute3 THEN
525: l_upd_optv_rec.attribute3 := Okl_Api.G_MISS_CHAR;

Line 525: l_upd_optv_rec.attribute3 := Okl_Api.G_MISS_CHAR;

521: l_upd_optv_rec.attribute2 := Okl_Api.G_MISS_CHAR;
522: END IF;
523:
524: IF l_upd_optv_rec.attribute3 = l_db_optv_rec.attribute3 THEN
525: l_upd_optv_rec.attribute3 := Okl_Api.G_MISS_CHAR;
526: END IF;
527:
528: IF l_upd_optv_rec.attribute4 = l_db_optv_rec.attribute4 THEN
529: l_upd_optv_rec.attribute4 := Okl_Api.G_MISS_CHAR;

Line 529: l_upd_optv_rec.attribute4 := Okl_Api.G_MISS_CHAR;

525: l_upd_optv_rec.attribute3 := Okl_Api.G_MISS_CHAR;
526: END IF;
527:
528: IF l_upd_optv_rec.attribute4 = l_db_optv_rec.attribute4 THEN
529: l_upd_optv_rec.attribute4 := Okl_Api.G_MISS_CHAR;
530: END IF;
531:
532: IF l_upd_optv_rec.attribute5 = l_db_optv_rec.attribute5 THEN
533: l_upd_optv_rec.attribute5 := Okl_Api.G_MISS_CHAR;

Line 533: l_upd_optv_rec.attribute5 := Okl_Api.G_MISS_CHAR;

529: l_upd_optv_rec.attribute4 := Okl_Api.G_MISS_CHAR;
530: END IF;
531:
532: IF l_upd_optv_rec.attribute5 = l_db_optv_rec.attribute5 THEN
533: l_upd_optv_rec.attribute5 := Okl_Api.G_MISS_CHAR;
534: END IF;
535:
536: IF l_upd_optv_rec.attribute6 = l_db_optv_rec.attribute6 THEN
537: l_upd_optv_rec.attribute6 := Okl_Api.G_MISS_CHAR;

Line 537: l_upd_optv_rec.attribute6 := Okl_Api.G_MISS_CHAR;

533: l_upd_optv_rec.attribute5 := Okl_Api.G_MISS_CHAR;
534: END IF;
535:
536: IF l_upd_optv_rec.attribute6 = l_db_optv_rec.attribute6 THEN
537: l_upd_optv_rec.attribute6 := Okl_Api.G_MISS_CHAR;
538: END IF;
539:
540: IF l_upd_optv_rec.attribute7 = l_db_optv_rec.attribute7 THEN
541: l_upd_optv_rec.attribute7 := Okl_Api.G_MISS_CHAR;

Line 541: l_upd_optv_rec.attribute7 := Okl_Api.G_MISS_CHAR;

537: l_upd_optv_rec.attribute6 := Okl_Api.G_MISS_CHAR;
538: END IF;
539:
540: IF l_upd_optv_rec.attribute7 = l_db_optv_rec.attribute7 THEN
541: l_upd_optv_rec.attribute7 := Okl_Api.G_MISS_CHAR;
542: END IF;
543:
544: IF l_upd_optv_rec.attribute8 = l_db_optv_rec.attribute8 THEN
545: l_upd_optv_rec.attribute8 := Okl_Api.G_MISS_CHAR;

Line 545: l_upd_optv_rec.attribute8 := Okl_Api.G_MISS_CHAR;

541: l_upd_optv_rec.attribute7 := Okl_Api.G_MISS_CHAR;
542: END IF;
543:
544: IF l_upd_optv_rec.attribute8 = l_db_optv_rec.attribute8 THEN
545: l_upd_optv_rec.attribute8 := Okl_Api.G_MISS_CHAR;
546: END IF;
547:
548: IF l_upd_optv_rec.attribute9 = l_db_optv_rec.attribute9 THEN
549: l_upd_optv_rec.attribute9 := Okl_Api.G_MISS_CHAR;

Line 549: l_upd_optv_rec.attribute9 := Okl_Api.G_MISS_CHAR;

545: l_upd_optv_rec.attribute8 := Okl_Api.G_MISS_CHAR;
546: END IF;
547:
548: IF l_upd_optv_rec.attribute9 = l_db_optv_rec.attribute9 THEN
549: l_upd_optv_rec.attribute9 := Okl_Api.G_MISS_CHAR;
550: END IF;
551:
552: IF l_upd_optv_rec.attribute10 = l_db_optv_rec.attribute10 THEN
553: l_upd_optv_rec.attribute10 := Okl_Api.G_MISS_CHAR;

Line 553: l_upd_optv_rec.attribute10 := Okl_Api.G_MISS_CHAR;

549: l_upd_optv_rec.attribute9 := Okl_Api.G_MISS_CHAR;
550: END IF;
551:
552: IF l_upd_optv_rec.attribute10 = l_db_optv_rec.attribute10 THEN
553: l_upd_optv_rec.attribute10 := Okl_Api.G_MISS_CHAR;
554: END IF;
555:
556: IF l_upd_optv_rec.attribute11 = l_db_optv_rec.attribute11 THEN
557: l_upd_optv_rec.attribute11 := Okl_Api.G_MISS_CHAR;

Line 557: l_upd_optv_rec.attribute11 := Okl_Api.G_MISS_CHAR;

553: l_upd_optv_rec.attribute10 := Okl_Api.G_MISS_CHAR;
554: END IF;
555:
556: IF l_upd_optv_rec.attribute11 = l_db_optv_rec.attribute11 THEN
557: l_upd_optv_rec.attribute11 := Okl_Api.G_MISS_CHAR;
558: END IF;
559:
560: IF l_upd_optv_rec.attribute12 = l_db_optv_rec.attribute12 THEN
561: l_upd_optv_rec.attribute12 := Okl_Api.G_MISS_CHAR;

Line 561: l_upd_optv_rec.attribute12 := Okl_Api.G_MISS_CHAR;

557: l_upd_optv_rec.attribute11 := Okl_Api.G_MISS_CHAR;
558: END IF;
559:
560: IF l_upd_optv_rec.attribute12 = l_db_optv_rec.attribute12 THEN
561: l_upd_optv_rec.attribute12 := Okl_Api.G_MISS_CHAR;
562: END IF;
563:
564: IF l_upd_optv_rec.attribute13 = l_db_optv_rec.attribute13 THEN
565: l_upd_optv_rec.attribute13 := Okl_Api.G_MISS_CHAR;

Line 565: l_upd_optv_rec.attribute13 := Okl_Api.G_MISS_CHAR;

561: l_upd_optv_rec.attribute12 := Okl_Api.G_MISS_CHAR;
562: END IF;
563:
564: IF l_upd_optv_rec.attribute13 = l_db_optv_rec.attribute13 THEN
565: l_upd_optv_rec.attribute13 := Okl_Api.G_MISS_CHAR;
566: END IF;
567:
568: IF l_upd_optv_rec.attribute14 = l_db_optv_rec.attribute14 THEN
569: l_upd_optv_rec.attribute14 := Okl_Api.G_MISS_CHAR;

Line 569: l_upd_optv_rec.attribute14 := Okl_Api.G_MISS_CHAR;

565: l_upd_optv_rec.attribute13 := Okl_Api.G_MISS_CHAR;
566: END IF;
567:
568: IF l_upd_optv_rec.attribute14 = l_db_optv_rec.attribute14 THEN
569: l_upd_optv_rec.attribute14 := Okl_Api.G_MISS_CHAR;
570: END IF;
571:
572: IF l_upd_optv_rec.attribute15 = l_db_optv_rec.attribute15 THEN
573: l_upd_optv_rec.attribute15 := Okl_Api.G_MISS_CHAR;

Line 573: l_upd_optv_rec.attribute15 := Okl_Api.G_MISS_CHAR;

569: l_upd_optv_rec.attribute14 := Okl_Api.G_MISS_CHAR;
570: END IF;
571:
572: IF l_upd_optv_rec.attribute15 = l_db_optv_rec.attribute15 THEN
573: l_upd_optv_rec.attribute15 := Okl_Api.G_MISS_CHAR;
574: END IF;
575:
576: p_upd_optv_rec := l_upd_optv_rec;
577:

Line 594: IF p_upd_optv_rec.description <> Okl_Api.G_MISS_CHAR THEN

590: BEGIN
591: /* create a temporary record with all relevant details from db and upd records */
592: l_optv_rec := p_db_optv_rec;
593:
594: IF p_upd_optv_rec.description <> Okl_Api.G_MISS_CHAR THEN
595: l_optv_rec.description := p_upd_optv_rec.description;
596: END IF;
597:
598: IF p_upd_optv_rec.from_date <> Okl_Api.G_MISS_DATE THEN

Line 598: IF p_upd_optv_rec.from_date <> Okl_Api.G_MISS_DATE THEN

594: IF p_upd_optv_rec.description <> Okl_Api.G_MISS_CHAR THEN
595: l_optv_rec.description := p_upd_optv_rec.description;
596: END IF;
597:
598: IF p_upd_optv_rec.from_date <> Okl_Api.G_MISS_DATE THEN
599: l_optv_rec.from_date := p_upd_optv_rec.from_date;
600: END IF;
601:
602: IF p_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN

Line 602: IF p_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN

598: IF p_upd_optv_rec.from_date <> Okl_Api.G_MISS_DATE THEN
599: l_optv_rec.from_date := p_upd_optv_rec.from_date;
600: END IF;
601:
602: IF p_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
603: l_optv_rec.TO_DATE := p_upd_optv_rec.TO_DATE;
604: END IF;
605:
606: IF p_upd_optv_rec.attribute_category <> Okl_Api.G_MISS_CHAR THEN

Line 606: IF p_upd_optv_rec.attribute_category <> Okl_Api.G_MISS_CHAR THEN

602: IF p_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
603: l_optv_rec.TO_DATE := p_upd_optv_rec.TO_DATE;
604: END IF;
605:
606: IF p_upd_optv_rec.attribute_category <> Okl_Api.G_MISS_CHAR THEN
607: l_optv_rec.attribute_category := p_upd_optv_rec.attribute_category;
608: END IF;
609:
610: IF p_upd_optv_rec.attribute1 <> Okl_Api.G_MISS_CHAR THEN

Line 610: IF p_upd_optv_rec.attribute1 <> Okl_Api.G_MISS_CHAR THEN

606: IF p_upd_optv_rec.attribute_category <> Okl_Api.G_MISS_CHAR THEN
607: l_optv_rec.attribute_category := p_upd_optv_rec.attribute_category;
608: END IF;
609:
610: IF p_upd_optv_rec.attribute1 <> Okl_Api.G_MISS_CHAR THEN
611: l_optv_rec.attribute1 := p_upd_optv_rec.attribute1;
612: END IF;
613:
614: IF p_upd_optv_rec.attribute2 <> Okl_Api.G_MISS_CHAR THEN

Line 614: IF p_upd_optv_rec.attribute2 <> Okl_Api.G_MISS_CHAR THEN

610: IF p_upd_optv_rec.attribute1 <> Okl_Api.G_MISS_CHAR THEN
611: l_optv_rec.attribute1 := p_upd_optv_rec.attribute1;
612: END IF;
613:
614: IF p_upd_optv_rec.attribute2 <> Okl_Api.G_MISS_CHAR THEN
615: l_optv_rec.attribute2 := p_upd_optv_rec.attribute2;
616: END IF;
617:
618: IF p_upd_optv_rec.attribute3 <> Okl_Api.G_MISS_CHAR THEN

Line 618: IF p_upd_optv_rec.attribute3 <> Okl_Api.G_MISS_CHAR THEN

614: IF p_upd_optv_rec.attribute2 <> Okl_Api.G_MISS_CHAR THEN
615: l_optv_rec.attribute2 := p_upd_optv_rec.attribute2;
616: END IF;
617:
618: IF p_upd_optv_rec.attribute3 <> Okl_Api.G_MISS_CHAR THEN
619: l_optv_rec.attribute3 := p_upd_optv_rec.attribute3;
620: END IF;
621:
622: IF p_upd_optv_rec.attribute4 <> Okl_Api.G_MISS_CHAR THEN

Line 622: IF p_upd_optv_rec.attribute4 <> Okl_Api.G_MISS_CHAR THEN

618: IF p_upd_optv_rec.attribute3 <> Okl_Api.G_MISS_CHAR THEN
619: l_optv_rec.attribute3 := p_upd_optv_rec.attribute3;
620: END IF;
621:
622: IF p_upd_optv_rec.attribute4 <> Okl_Api.G_MISS_CHAR THEN
623: l_optv_rec.attribute4 := p_upd_optv_rec.attribute4;
624: END IF;
625:
626: IF p_upd_optv_rec.attribute5 <> Okl_Api.G_MISS_CHAR THEN

Line 626: IF p_upd_optv_rec.attribute5 <> Okl_Api.G_MISS_CHAR THEN

622: IF p_upd_optv_rec.attribute4 <> Okl_Api.G_MISS_CHAR THEN
623: l_optv_rec.attribute4 := p_upd_optv_rec.attribute4;
624: END IF;
625:
626: IF p_upd_optv_rec.attribute5 <> Okl_Api.G_MISS_CHAR THEN
627: l_optv_rec.attribute5 := p_upd_optv_rec.attribute5;
628: END IF;
629:
630: IF p_upd_optv_rec.attribute6 <> Okl_Api.G_MISS_CHAR THEN

Line 630: IF p_upd_optv_rec.attribute6 <> Okl_Api.G_MISS_CHAR THEN

626: IF p_upd_optv_rec.attribute5 <> Okl_Api.G_MISS_CHAR THEN
627: l_optv_rec.attribute5 := p_upd_optv_rec.attribute5;
628: END IF;
629:
630: IF p_upd_optv_rec.attribute6 <> Okl_Api.G_MISS_CHAR THEN
631: l_optv_rec.attribute6 := p_upd_optv_rec.attribute6;
632: END IF;
633:
634: IF p_upd_optv_rec.attribute7 <> Okl_Api.G_MISS_CHAR THEN

Line 634: IF p_upd_optv_rec.attribute7 <> Okl_Api.G_MISS_CHAR THEN

630: IF p_upd_optv_rec.attribute6 <> Okl_Api.G_MISS_CHAR THEN
631: l_optv_rec.attribute6 := p_upd_optv_rec.attribute6;
632: END IF;
633:
634: IF p_upd_optv_rec.attribute7 <> Okl_Api.G_MISS_CHAR THEN
635: l_optv_rec.attribute7 := p_upd_optv_rec.attribute7;
636: END IF;
637:
638: IF p_upd_optv_rec.attribute8 <> Okl_Api.G_MISS_CHAR THEN

Line 638: IF p_upd_optv_rec.attribute8 <> Okl_Api.G_MISS_CHAR THEN

634: IF p_upd_optv_rec.attribute7 <> Okl_Api.G_MISS_CHAR THEN
635: l_optv_rec.attribute7 := p_upd_optv_rec.attribute7;
636: END IF;
637:
638: IF p_upd_optv_rec.attribute8 <> Okl_Api.G_MISS_CHAR THEN
639: l_optv_rec.attribute8 := p_upd_optv_rec.attribute8;
640: END IF;
641:
642: IF p_upd_optv_rec.attribute9 <> Okl_Api.G_MISS_CHAR THEN

Line 642: IF p_upd_optv_rec.attribute9 <> Okl_Api.G_MISS_CHAR THEN

638: IF p_upd_optv_rec.attribute8 <> Okl_Api.G_MISS_CHAR THEN
639: l_optv_rec.attribute8 := p_upd_optv_rec.attribute8;
640: END IF;
641:
642: IF p_upd_optv_rec.attribute9 <> Okl_Api.G_MISS_CHAR THEN
643: l_optv_rec.attribute9 := p_upd_optv_rec.attribute9;
644: END IF;
645:
646: IF p_upd_optv_rec.attribute10 <> Okl_Api.G_MISS_CHAR THEN

Line 646: IF p_upd_optv_rec.attribute10 <> Okl_Api.G_MISS_CHAR THEN

642: IF p_upd_optv_rec.attribute9 <> Okl_Api.G_MISS_CHAR THEN
643: l_optv_rec.attribute9 := p_upd_optv_rec.attribute9;
644: END IF;
645:
646: IF p_upd_optv_rec.attribute10 <> Okl_Api.G_MISS_CHAR THEN
647: l_optv_rec.attribute10 := p_upd_optv_rec.attribute10;
648: END IF;
649:
650: IF p_upd_optv_rec.attribute11 <> Okl_Api.G_MISS_CHAR THEN

Line 650: IF p_upd_optv_rec.attribute11 <> Okl_Api.G_MISS_CHAR THEN

646: IF p_upd_optv_rec.attribute10 <> Okl_Api.G_MISS_CHAR THEN
647: l_optv_rec.attribute10 := p_upd_optv_rec.attribute10;
648: END IF;
649:
650: IF p_upd_optv_rec.attribute11 <> Okl_Api.G_MISS_CHAR THEN
651: l_optv_rec.attribute11 := p_upd_optv_rec.attribute11;
652: END IF;
653:
654: IF p_upd_optv_rec.attribute12 <> Okl_Api.G_MISS_CHAR THEN

Line 654: IF p_upd_optv_rec.attribute12 <> Okl_Api.G_MISS_CHAR THEN

650: IF p_upd_optv_rec.attribute11 <> Okl_Api.G_MISS_CHAR THEN
651: l_optv_rec.attribute11 := p_upd_optv_rec.attribute11;
652: END IF;
653:
654: IF p_upd_optv_rec.attribute12 <> Okl_Api.G_MISS_CHAR THEN
655: l_optv_rec.attribute12 := p_upd_optv_rec.attribute12;
656: END IF;
657:
658: IF p_upd_optv_rec.attribute13 <> Okl_Api.G_MISS_CHAR THEN

Line 658: IF p_upd_optv_rec.attribute13 <> Okl_Api.G_MISS_CHAR THEN

654: IF p_upd_optv_rec.attribute12 <> Okl_Api.G_MISS_CHAR THEN
655: l_optv_rec.attribute12 := p_upd_optv_rec.attribute12;
656: END IF;
657:
658: IF p_upd_optv_rec.attribute13 <> Okl_Api.G_MISS_CHAR THEN
659: l_optv_rec.attribute13 := p_upd_optv_rec.attribute13;
660: END IF;
661:
662: IF p_upd_optv_rec.attribute14 <> Okl_Api.G_MISS_CHAR THEN

Line 662: IF p_upd_optv_rec.attribute14 <> Okl_Api.G_MISS_CHAR THEN

658: IF p_upd_optv_rec.attribute13 <> Okl_Api.G_MISS_CHAR THEN
659: l_optv_rec.attribute13 := p_upd_optv_rec.attribute13;
660: END IF;
661:
662: IF p_upd_optv_rec.attribute14 <> Okl_Api.G_MISS_CHAR THEN
663: l_optv_rec.attribute14 := p_upd_optv_rec.attribute14;
664: END IF;
665:
666: IF p_upd_optv_rec.attribute15 <> Okl_Api.G_MISS_CHAR THEN

Line 666: IF p_upd_optv_rec.attribute15 <> Okl_Api.G_MISS_CHAR THEN

662: IF p_upd_optv_rec.attribute14 <> Okl_Api.G_MISS_CHAR THEN
663: l_optv_rec.attribute14 := p_upd_optv_rec.attribute14;
664: END IF;
665:
666: IF p_upd_optv_rec.attribute15 <> Okl_Api.G_MISS_CHAR THEN
667: l_optv_rec.attribute15 := p_upd_optv_rec.attribute15;
668: END IF;
669:
670: RETURN l_optv_rec;

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

681: x_return_status OUT NOCOPY VARCHAR2,
682: x_msg_data OUT NOCOPY VARCHAR2
683: ) IS
684: l_optv_rec optv_rec_type;
685: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
686: l_valid BOOLEAN;
687: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
688: BEGIN
689: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 689: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

685: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
686: l_valid BOOLEAN;
687: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
688: BEGIN
689: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
690: l_optv_rec := p_optv_rec;
691:
692: /* check for start date greater than sysdate */
693: /*IF to_date(to_char(p_upd_optv_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

Line 693: /*IF to_date(to_char(p_upd_optv_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

689: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
690: l_optv_rec := p_optv_rec;
691:
692: /* check for start date greater than sysdate */
693: /*IF to_date(to_char(p_upd_optv_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
694: to_date(to_char(p_upd_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
695: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
696: p_msg_name => G_START_DATE);
697: x_return_status := Okl_Api.G_RET_STS_ERROR;

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

691:
692: /* check for start date greater than sysdate */
693: /*IF to_date(to_char(p_upd_optv_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
694: to_date(to_char(p_upd_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
695: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
696: p_msg_name => G_START_DATE);
697: x_return_status := Okl_Api.G_RET_STS_ERROR;
698: RAISE G_EXCEPTION_HALT_PROCESSING;
699: END IF;

Line 697: x_return_status := Okl_Api.G_RET_STS_ERROR;

693: /*IF to_date(to_char(p_upd_optv_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
694: to_date(to_char(p_upd_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
695: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
696: p_msg_name => G_START_DATE);
697: x_return_status := Okl_Api.G_RET_STS_ERROR;
698: RAISE G_EXCEPTION_HALT_PROCESSING;
699: END IF;
700: */
701: /* check for the records with from and to dates less than sysdate */

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

699: END IF;
700: */
701: /* check for the records with from and to dates less than sysdate */
702: /*IF to_date(to_char(p_upd_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
703: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
704: p_msg_name => G_PAST_RECORDS);
705: x_return_status := Okl_Api.G_RET_STS_ERROR;
706: RAISE G_EXCEPTION_HALT_PROCESSING;
707: END IF;

Line 705: x_return_status := Okl_Api.G_RET_STS_ERROR;

701: /* check for the records with from and to dates less than sysdate */
702: /*IF to_date(to_char(p_upd_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
703: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
704: p_msg_name => G_PAST_RECORDS);
705: x_return_status := Okl_Api.G_RET_STS_ERROR;
706: RAISE G_EXCEPTION_HALT_PROCESSING;
707: END IF;
708: */
709: /* if the start date is in the past, the start date cannot be

Line 711: /*IF to_date(to_char(p_upd_optv_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

707: END IF;
708: */
709: /* if the start date is in the past, the start date cannot be
710: modified */
711: /*IF to_date(to_char(p_upd_optv_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
712: to_date(to_char(p_db_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <= l_sysdate THEN
713: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
714: p_msg_name => G_NOT_ALLOWED,
715: p_token1 => G_COL_NAME_TOKEN,

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

709: /* if the start date is in the past, the start date cannot be
710: modified */
711: /*IF to_date(to_char(p_upd_optv_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
712: to_date(to_char(p_db_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') <= l_sysdate THEN
713: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
714: p_msg_name => G_NOT_ALLOWED,
715: p_token1 => G_COL_NAME_TOKEN,
716: p_token1_value => 'START_DATE');
717: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 717: x_return_status := Okl_Api.G_RET_STS_ERROR;

713: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
714: p_msg_name => G_NOT_ALLOWED,
715: p_token1 => G_COL_NAME_TOKEN,
716: p_token1_value => 'START_DATE');
717: x_return_status := Okl_Api.G_RET_STS_ERROR;
718: RAISE G_EXCEPTION_HALT_PROCESSING;
719: END IF;
720: */
721: IF p_upd_optv_rec.from_date <> Okl_Api.G_MISS_DATE OR

Line 721: IF p_upd_optv_rec.from_date <> Okl_Api.G_MISS_DATE OR

717: x_return_status := Okl_Api.G_RET_STS_ERROR;
718: RAISE G_EXCEPTION_HALT_PROCESSING;
719: END IF;
720: */
721: IF p_upd_optv_rec.from_date <> Okl_Api.G_MISS_DATE OR
722: p_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
723: Check_Constraints(p_optv_rec => l_optv_rec,
724: x_return_status => l_return_status,
725: x_valid => l_valid);

Line 722: p_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN

718: RAISE G_EXCEPTION_HALT_PROCESSING;
719: END IF;
720: */
721: IF p_upd_optv_rec.from_date <> Okl_Api.G_MISS_DATE OR
722: p_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
723: Check_Constraints(p_optv_rec => l_optv_rec,
724: x_return_status => l_return_status,
725: x_valid => l_valid);
726: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

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

722: p_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
723: Check_Constraints(p_optv_rec => l_optv_rec,
724: x_return_status => l_return_status,
725: x_valid => l_valid);
726: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
727: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
728: RAISE G_EXCEPTION_HALT_PROCESSING;
729: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
730: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

Line 727: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

723: Check_Constraints(p_optv_rec => l_optv_rec,
724: x_return_status => l_return_status,
725: x_valid => l_valid);
726: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
727: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
728: RAISE G_EXCEPTION_HALT_PROCESSING;
729: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
730: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
731: l_valid <> TRUE) THEN

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

725: x_valid => l_valid);
726: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
727: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
728: RAISE G_EXCEPTION_HALT_PROCESSING;
729: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
730: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
731: l_valid <> TRUE) THEN
732: x_return_status := Okl_Api.G_RET_STS_ERROR;
733: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 730: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND

726: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
727: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
728: RAISE G_EXCEPTION_HALT_PROCESSING;
729: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
730: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
731: l_valid <> TRUE) THEN
732: x_return_status := Okl_Api.G_RET_STS_ERROR;
733: RAISE G_EXCEPTION_HALT_PROCESSING;
734: END IF;

Line 732: x_return_status := Okl_Api.G_RET_STS_ERROR;

728: RAISE G_EXCEPTION_HALT_PROCESSING;
729: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
730: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
731: l_valid <> TRUE) THEN
732: x_return_status := Okl_Api.G_RET_STS_ERROR;
733: RAISE G_EXCEPTION_HALT_PROCESSING;
734: END IF;
735: END IF;
736:

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

741: NULL;
742:
743: WHEN OTHERS THEN
744: -- store SQL error message on message stack for caller
745: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
746: p_msg_name => G_UNEXPECTED_ERROR,
747: p_token1 => G_SQLCODE_TOKEN,
748: p_token1_value => SQLCODE,
749: p_token2 => G_SQLERRM_TOKEN,

Line 752: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

748: p_token1_value => SQLCODE,
749: p_token2 => G_SQLERRM_TOKEN,
750: p_token2_value => SQLERRM );
751: -- notify caller of an UNEXPECTED error
752: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
753:
754: END check_updates;
755:
756: ---------------------------------------------------------------------------

Line 771: IF p_upd_optv_rec.from_date = Okl_Api.G_MISS_DATE AND

767: l_action VARCHAR2(1);
768: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
769: BEGIN
770: /* Scenario 1: Only description and/or descriptive flexfield changes */
771: IF p_upd_optv_rec.from_date = Okl_Api.G_MISS_DATE AND
772: p_upd_optv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN
773: l_action := '1';
774: /* Scenario 2: Changing the dates */
775: ELSE

Line 772: p_upd_optv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN

768: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
769: BEGIN
770: /* Scenario 1: Only description and/or descriptive flexfield changes */
771: IF p_upd_optv_rec.from_date = Okl_Api.G_MISS_DATE AND
772: p_upd_optv_rec.TO_DATE = Okl_Api.G_MISS_DATE THEN
773: l_action := '1';
774: /* Scenario 2: Changing the dates */
775: ELSE
776: l_action := '2';

Line 785: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

781: ---------------------------------------------------------------------------
782: -- PROCEDURE copy_update_constraints for: OKL_OPTIONS_V
783: ---------------------------------------------------------------------------
784: PROCEDURE copy_update_constraints (p_api_version IN NUMBER,
785: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
786: p_upd_optv_rec IN optv_rec_type,
787: x_return_status OUT NOCOPY VARCHAR2,
788: x_msg_count OUT NOCOPY NUMBER,
789: x_msg_data OUT NOCOPY VARCHAR2

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

788: x_msg_count OUT NOCOPY NUMBER,
789: x_msg_data OUT NOCOPY VARCHAR2
790: ) IS
791: l_upd_optv_rec optv_rec_type; /* input copy */
792: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
793: l_ove_count NUMBER := 0;
794: l_ovev_tbl ovev_tbl_type;
795: l_out_ovev_tbl ovev_tbl_type;
796:

Line 798: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

794: l_ovev_tbl ovev_tbl_type;
795: l_out_ovev_tbl ovev_tbl_type;
796:
797: BEGIN
798: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
799: l_upd_optv_rec := p_upd_optv_rec;
800:
801: /* Get Option Values */
802: get_opt_values(p_upd_optv_rec => l_upd_optv_rec,

Line 807: IF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

803: x_return_status => l_return_status,
804: x_count => l_ove_count,
805: x_ovev_tbl => l_ovev_tbl);
806:
807: IF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
808: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
809: RAISE G_EXCEPTION_HALT_PROCESSING;
810: END IF;
811:

Line 808: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

804: x_count => l_ove_count,
805: x_ovev_tbl => l_ovev_tbl);
806:
807: IF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
808: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
809: RAISE G_EXCEPTION_HALT_PROCESSING;
810: END IF;
811:
812: IF l_ove_count > 0 THEN

Line 822: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

818: p_ovev_tbl => l_ovev_tbl,
819: x_ovev_tbl => l_out_ovev_tbl);
820: END IF;
821:
822: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
823: x_return_status := Okl_Api.G_RET_STS_ERROR;
824: RAISE G_EXCEPTION_HALT_PROCESSING;
825: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
826: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 823: x_return_status := Okl_Api.G_RET_STS_ERROR;

819: x_ovev_tbl => l_out_ovev_tbl);
820: END IF;
821:
822: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
823: x_return_status := Okl_Api.G_RET_STS_ERROR;
824: RAISE G_EXCEPTION_HALT_PROCESSING;
825: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
826: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
827: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 825: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

821:
822: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
823: x_return_status := Okl_Api.G_RET_STS_ERROR;
824: RAISE G_EXCEPTION_HALT_PROCESSING;
825: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
826: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
827: RAISE G_EXCEPTION_HALT_PROCESSING;
828: END IF;
829:

Line 826: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

822: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
823: x_return_status := Okl_Api.G_RET_STS_ERROR;
824: RAISE G_EXCEPTION_HALT_PROCESSING;
825: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
826: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
827: RAISE G_EXCEPTION_HALT_PROCESSING;
828: END IF;
829:
830: EXCEPTION

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

834: NULL;
835:
836: WHEN OTHERS THEN
837: -- store SQL error message on message stack
838: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
839: p_msg_name => G_UNEXPECTED_ERROR,
840: p_token1 => G_SQLCODE_TOKEN,
841: p_token1_value => SQLCODE,
842: p_token2 => G_SQLERRM_TOKEN,

Line 845: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

841: p_token1_value => SQLCODE,
842: p_token2 => G_SQLERRM_TOKEN,
843: p_token2_value => SQLERRM );
844: -- notify UNEXPECTED error for calling API.
845: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
846:
847: END copy_update_constraints;
848:
849: ---------------------------------------------------------------------------

Line 853: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

849: ---------------------------------------------------------------------------
850: -- PROCEDURE insert_options for: OKL_OPTIONS_V
851: ---------------------------------------------------------------------------
852: PROCEDURE insert_options(p_api_version IN NUMBER,
853: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
854: x_return_status OUT NOCOPY VARCHAR2,
855: x_msg_count OUT NOCOPY NUMBER,
856: x_msg_data OUT NOCOPY VARCHAR2,
857: p_optv_rec IN optv_rec_type,

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

866: l_token_1 VARCHAR2(1999);
867: l_api_version CONSTANT NUMBER := 1;
868: l_api_name CONSTANT VARCHAR2(30) := 'insert_options';
869: l_valid BOOLEAN := TRUE;
870: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
871: l_optv_rec optv_rec_type;
872: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
873: BEGIN
874: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 874: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

870: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
871: l_optv_rec optv_rec_type;
872: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
873: BEGIN
874: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
875: l_optv_rec := p_optv_rec;
876:
877: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
878: p_pkg_name => G_PKG_NAME,

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

873: BEGIN
874: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
875: l_optv_rec := p_optv_rec;
876:
877: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
878: p_pkg_name => G_PKG_NAME,
879: p_init_msg_list => p_init_msg_list,
880: l_api_version => l_api_version,
881: p_api_version => p_api_version,

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

880: l_api_version => l_api_version,
881: p_api_version => p_api_version,
882: p_api_type => '_PVT',
883: x_return_status => l_return_status);
884: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
885: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
886: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
887: RAISE Okl_Api.G_EXCEPTION_ERROR;
888: END IF;

Line 885: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

881: p_api_version => p_api_version,
882: p_api_type => '_PVT',
883: x_return_status => l_return_status);
884: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
885: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
886: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
887: RAISE Okl_Api.G_EXCEPTION_ERROR;
888: END IF;
889:

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

882: p_api_type => '_PVT',
883: x_return_status => l_return_status);
884: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
885: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
886: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
887: RAISE Okl_Api.G_EXCEPTION_ERROR;
888: END IF;
889:
890: --- Validate all non-missing attributes (Item Level Validation)

Line 887: RAISE Okl_Api.G_EXCEPTION_ERROR;

883: x_return_status => l_return_status);
884: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
885: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
886: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
887: RAISE Okl_Api.G_EXCEPTION_ERROR;
888: END IF;
889:
890: --- Validate all non-missing attributes (Item Level Validation)
891: l_return_status := Validate_Attributes(l_optv_rec);

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

889:
890: --- Validate all non-missing attributes (Item Level Validation)
891: l_return_status := Validate_Attributes(l_optv_rec);
892: --- If any errors happen abort API
893: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
894: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
895: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
896: RAISE Okl_Api.G_EXCEPTION_ERROR;
897: END IF;

Line 894: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

890: --- Validate all non-missing attributes (Item Level Validation)
891: l_return_status := Validate_Attributes(l_optv_rec);
892: --- If any errors happen abort API
893: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
894: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
895: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
896: RAISE Okl_Api.G_EXCEPTION_ERROR;
897: END IF;
898:

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

891: l_return_status := Validate_Attributes(l_optv_rec);
892: --- If any errors happen abort API
893: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
894: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
895: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
896: RAISE Okl_Api.G_EXCEPTION_ERROR;
897: END IF;
898:
899: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',

Line 896: RAISE Okl_Api.G_EXCEPTION_ERROR;

892: --- If any errors happen abort API
893: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
894: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
895: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
896: RAISE Okl_Api.G_EXCEPTION_ERROR;
897: END IF;
898:
899: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',
900: p_attribute_code => 'OKL_OPTIONS');

Line 906: Okl_Api.set_message('OKL','OKL_NOT_UNIQUE', 'OKL_TABLE_NAME',l_token_1);

902: --moved from simle api to fix error messages
903: OPEN okl_options_unique (Okl_Accounting_Util.okl_upper(p_optv_rec.name));
904: FETCH okl_options_unique INTO l_unique_key;
905: IF okl_options_unique%FOUND THEN
906: Okl_Api.set_message('OKL','OKL_NOT_UNIQUE', 'OKL_TABLE_NAME',l_token_1);
907: RAISE Okl_Api.G_EXCEPTION_ERROR;
908: ELSE
909: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
910: END IF;

Line 907: RAISE Okl_Api.G_EXCEPTION_ERROR;

903: OPEN okl_options_unique (Okl_Accounting_Util.okl_upper(p_optv_rec.name));
904: FETCH okl_options_unique INTO l_unique_key;
905: IF okl_options_unique%FOUND THEN
906: Okl_Api.set_message('OKL','OKL_NOT_UNIQUE', 'OKL_TABLE_NAME',l_token_1);
907: RAISE Okl_Api.G_EXCEPTION_ERROR;
908: ELSE
909: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
910: END IF;
911: CLOSE okl_options_unique;

Line 909: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

905: IF okl_options_unique%FOUND THEN
906: Okl_Api.set_message('OKL','OKL_NOT_UNIQUE', 'OKL_TABLE_NAME',l_token_1);
907: RAISE Okl_Api.G_EXCEPTION_ERROR;
908: ELSE
909: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
910: END IF;
911: CLOSE okl_options_unique;
912:
913: /* check for the records with start or end dates less than sysdate */

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

912:
913: /* check for the records with start or end dates less than sysdate */
914: /*IF to_date(to_char(l_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate OR
915: to_date(to_char(l_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
916: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
917: p_msg_name => G_PAST_RECORDS);
918: RAISE Okl_Api.G_EXCEPTION_ERROR;
919: END IF;
920: */

Line 918: RAISE Okl_Api.G_EXCEPTION_ERROR;

914: /*IF to_date(to_char(l_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate OR
915: to_date(to_char(l_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
916: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
917: p_msg_name => G_PAST_RECORDS);
918: RAISE Okl_Api.G_EXCEPTION_ERROR;
919: END IF;
920: */
921: /* public api to create options */
922: Okl_Options_Pub.create_options(p_api_version => p_api_version,

Line 930: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

926: x_msg_data => x_msg_data,
927: p_optv_rec => l_optv_rec,
928: x_optv_rec => x_optv_rec);
929:
930: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
931: RAISE Okl_Api.G_EXCEPTION_ERROR;
932: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
934: END IF;

Line 931: RAISE Okl_Api.G_EXCEPTION_ERROR;

927: p_optv_rec => l_optv_rec,
928: x_optv_rec => x_optv_rec);
929:
930: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
931: RAISE Okl_Api.G_EXCEPTION_ERROR;
932: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
934: END IF;
935:

Line 932: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

928: x_optv_rec => x_optv_rec);
929:
930: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
931: RAISE Okl_Api.G_EXCEPTION_ERROR;
932: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
934: END IF;
935:
936: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

Line 933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

929:
930: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
931: RAISE Okl_Api.G_EXCEPTION_ERROR;
932: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
934: END IF;
935:
936: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
937: x_msg_data => x_msg_data);

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

932: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
934: END IF;
935:
936: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
937: x_msg_data => x_msg_data);
938: EXCEPTION
939: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
940: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 939: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

935:
936: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
937: x_msg_data => x_msg_data);
938: EXCEPTION
939: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
940: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
941: p_pkg_name => G_PKG_NAME,
942: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
943: x_msg_count => x_msg_count,

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

936: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
937: x_msg_data => x_msg_data);
938: EXCEPTION
939: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
940: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
941: p_pkg_name => G_PKG_NAME,
942: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
943: x_msg_count => x_msg_count,
944: x_msg_data => x_msg_data,

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

938: EXCEPTION
939: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
940: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
941: p_pkg_name => G_PKG_NAME,
942: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
943: x_msg_count => x_msg_count,
944: x_msg_data => x_msg_data,
945: p_api_type => '_PVT');
946: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 946: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

942: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
943: x_msg_count => x_msg_count,
944: x_msg_data => x_msg_data,
945: p_api_type => '_PVT');
946: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
948: p_pkg_name => G_PKG_NAME,
949: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
950: x_msg_count => x_msg_count,

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

943: x_msg_count => x_msg_count,
944: x_msg_data => x_msg_data,
945: p_api_type => '_PVT');
946: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
948: p_pkg_name => G_PKG_NAME,
949: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
950: x_msg_count => x_msg_count,
951: x_msg_data => x_msg_data,

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

945: p_api_type => '_PVT');
946: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
948: p_pkg_name => G_PKG_NAME,
949: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
950: x_msg_count => x_msg_count,
951: x_msg_data => x_msg_data,
952: p_api_type => '_PVT');
953: WHEN OTHERS THEN

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

950: x_msg_count => x_msg_count,
951: x_msg_data => x_msg_data,
952: p_api_type => '_PVT');
953: WHEN OTHERS THEN
954: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
955: p_pkg_name => G_PKG_NAME,
956: p_exc_name => 'OTHERS',
957: x_msg_count => x_msg_count,
958: x_msg_data => x_msg_data,

Line 970: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

966: ---------------------------------------------------------------------------
967: -- PROCEDURE update_options for: OKL_OPTIONS_V
968: ---------------------------------------------------------------------------
969: PROCEDURE update_options(p_api_version IN NUMBER,
970: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
971: x_return_status OUT NOCOPY VARCHAR2,
972: x_msg_count OUT NOCOPY NUMBER,
973: x_msg_data OUT NOCOPY VARCHAR2,
974: p_optv_rec IN optv_rec_type,

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

982: l_upd_optv_rec optv_rec_type; /* input copy */
983: l_optv_rec optv_rec_type; /* latest with the retained changes */
984: l_tmp_optv_rec optv_rec_type; /* for any other purposes */
985: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
986: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
987: l_action VARCHAR2(1);
988: BEGIN
989: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
990: l_upd_optv_rec := p_optv_rec;

Line 989: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

985: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
986: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
987: l_action VARCHAR2(1);
988: BEGIN
989: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
990: l_upd_optv_rec := p_optv_rec;
991:
992: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
993: p_pkg_name => G_PKG_NAME,

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

988: BEGIN
989: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
990: l_upd_optv_rec := p_optv_rec;
991:
992: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
993: p_pkg_name => G_PKG_NAME,
994: p_init_msg_list => p_init_msg_list,
995: l_api_version => l_api_version,
996: p_api_version => p_api_version,

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

995: l_api_version => l_api_version,
996: p_api_version => p_api_version,
997: p_api_type => '_PVT',
998: x_return_status => l_return_status);
999: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1000: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1002: RAISE Okl_Api.G_EXCEPTION_ERROR;
1003: END IF;

Line 1000: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

996: p_api_version => p_api_version,
997: p_api_type => '_PVT',
998: x_return_status => l_return_status);
999: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1000: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1002: RAISE Okl_Api.G_EXCEPTION_ERROR;
1003: END IF;
1004:

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

997: p_api_type => '_PVT',
998: x_return_status => l_return_status);
999: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1000: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1002: RAISE Okl_Api.G_EXCEPTION_ERROR;
1003: END IF;
1004:
1005: /* fetch old details from the database */

Line 1002: RAISE Okl_Api.G_EXCEPTION_ERROR;

998: x_return_status => l_return_status);
999: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1000: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1002: RAISE Okl_Api.G_EXCEPTION_ERROR;
1003: END IF;
1004:
1005: /* fetch old details from the database */
1006: get_rec(p_optv_rec => l_upd_optv_rec,

Line 1010: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR

1006: get_rec(p_optv_rec => l_upd_optv_rec,
1007: x_return_status => l_return_status,
1008: x_no_data_found => l_no_data_found,
1009: x_optv_rec => l_db_optv_rec);
1010: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR
1011: l_no_data_found = TRUE THEN
1012: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1013: END IF;
1014:

Line 1012: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1008: x_no_data_found => l_no_data_found,
1009: x_optv_rec => l_db_optv_rec);
1010: IF l_return_status <> Okl_Api.G_RET_STS_SUCCESS OR
1011: l_no_data_found = TRUE THEN
1012: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1013: END IF;
1014:
1015: IF l_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
1016: /* update constraints */

Line 1015: IF l_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN

1011: l_no_data_found = TRUE THEN
1012: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1013: END IF;
1014:
1015: IF l_upd_optv_rec.TO_DATE <> Okl_Api.G_MISS_DATE THEN
1016: /* update constraints */
1017: copy_update_constraints(p_api_version => p_api_version,
1018: p_init_msg_list => p_init_msg_list,
1019: p_upd_optv_rec => l_upd_optv_rec,

Line 1024: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1020: x_return_status => l_return_status,
1021: x_msg_count => x_msg_count,
1022: x_msg_data => x_msg_data);
1023:
1024: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1025: RAISE Okl_Api.G_EXCEPTION_ERROR;
1026: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1028: END IF;

Line 1025: RAISE Okl_Api.G_EXCEPTION_ERROR;

1021: x_msg_count => x_msg_count,
1022: x_msg_data => x_msg_data);
1023:
1024: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1025: RAISE Okl_Api.G_EXCEPTION_ERROR;
1026: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1028: END IF;
1029:

Line 1026: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1022: x_msg_data => x_msg_data);
1023:
1024: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1025: RAISE Okl_Api.G_EXCEPTION_ERROR;
1026: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1028: END IF;
1029:
1030: END IF;

Line 1027: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1023:
1024: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1025: RAISE Okl_Api.G_EXCEPTION_ERROR;
1026: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1028: END IF;
1029:
1030: END IF;
1031:

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

1035:
1036: /* check for past records */
1037: /*IF to_date(to_char(l_db_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate AND
1038: to_date(to_char(l_db_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
1039: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1040: p_msg_name => G_PAST_RECORDS);
1041: x_return_status := Okl_Api.G_RET_STS_ERROR;
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;

Line 1041: x_return_status := Okl_Api.G_RET_STS_ERROR;

1037: /*IF to_date(to_char(l_db_optv_rec.from_date, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate AND
1038: to_date(to_char(l_db_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
1039: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1040: p_msg_name => G_PAST_RECORDS);
1041: x_return_status := Okl_Api.G_RET_STS_ERROR;
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044: */
1045:

Line 1042: RAISE Okl_Api.G_EXCEPTION_ERROR;

1038: to_date(to_char(l_db_optv_rec.TO_DATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
1039: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1040: p_msg_name => G_PAST_RECORDS);
1041: x_return_status := Okl_Api.G_RET_STS_ERROR;
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044: */
1045:
1046:

Line 1048: IF (l_upd_optv_rec.TO_DATE = Okl_Api.G_MISS_DATE) then

1044: */
1045:
1046:
1047:
1048: IF (l_upd_optv_rec.TO_DATE = Okl_Api.G_MISS_DATE) then
1049: l_upd_optv_rec.TO_DATE := p_optv_rec.to_date;
1050: end if;
1051:
1052: IF (l_upd_optv_rec.from_DATE = Okl_Api.G_MISS_DATE) then

Line 1052: IF (l_upd_optv_rec.from_DATE = Okl_Api.G_MISS_DATE) then

1048: IF (l_upd_optv_rec.TO_DATE = Okl_Api.G_MISS_DATE) then
1049: l_upd_optv_rec.TO_DATE := p_optv_rec.to_date;
1050: end if;
1051:
1052: IF (l_upd_optv_rec.from_DATE = Okl_Api.G_MISS_DATE) then
1053: l_upd_optv_rec.from_DATE := p_optv_rec.from_date;
1054: end if;
1055:
1056: /* To Check end date is > from_date */

Line 1058: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

1054: end if;
1055:
1056: /* To Check end date is > from_date */
1057: IF (l_upd_optv_rec.TO_DATE IS NOT NULL) AND (l_upd_optv_rec.TO_DATE < l_upd_optv_rec.from_date) THEN
1058: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1059: ,p_msg_name => Okl_Opt_Pvt.g_to_date_error
1060: ,p_token1 => Okl_Opt_Pvt.g_col_name_token
1061: ,p_token1_value => 'to_date');
1062: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 1062: x_return_status := Okl_Api.G_RET_STS_ERROR;

1058: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1059: ,p_msg_name => Okl_Opt_Pvt.g_to_date_error
1060: ,p_token1 => Okl_Opt_Pvt.g_col_name_token
1061: ,p_token1_value => 'to_date');
1062: x_return_status := Okl_Api.G_RET_STS_ERROR;
1063: RAISE Okl_Api.G_EXCEPTION_ERROR;
1064: END IF;
1065:
1066: /* determine how the processing to be done */

Line 1063: RAISE Okl_Api.G_EXCEPTION_ERROR;

1059: ,p_msg_name => Okl_Opt_Pvt.g_to_date_error
1060: ,p_token1 => Okl_Opt_Pvt.g_col_name_token
1061: ,p_token1_value => 'to_date');
1062: x_return_status := Okl_Api.G_RET_STS_ERROR;
1063: RAISE Okl_Api.G_EXCEPTION_ERROR;
1064: END IF;
1065:
1066: /* determine how the processing to be done */
1067: l_action := determine_action(p_upd_optv_rec => l_upd_optv_rec,

Line 1081: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1077: x_msg_count => x_msg_count,
1078: x_msg_data => x_msg_data,
1079: p_optv_rec => l_upd_optv_rec,
1080: x_optv_rec => x_optv_rec);
1081: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1082: RAISE Okl_Api.G_EXCEPTION_ERROR;
1083: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1084: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1085: END IF;

Line 1082: RAISE Okl_Api.G_EXCEPTION_ERROR;

1078: x_msg_data => x_msg_data,
1079: p_optv_rec => l_upd_optv_rec,
1080: x_optv_rec => x_optv_rec);
1081: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1082: RAISE Okl_Api.G_EXCEPTION_ERROR;
1083: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1084: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1085: END IF;
1086:

Line 1083: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1079: p_optv_rec => l_upd_optv_rec,
1080: x_optv_rec => x_optv_rec);
1081: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1082: RAISE Okl_Api.G_EXCEPTION_ERROR;
1083: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1084: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1085: END IF;
1086:
1087: /* Scenario 2: changing the dates */

Line 1084: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1080: x_optv_rec => x_optv_rec);
1081: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1082: RAISE Okl_Api.G_EXCEPTION_ERROR;
1083: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1084: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1085: END IF;
1086:
1087: /* Scenario 2: changing the dates */
1088: ELSIF l_action = '2' THEN

Line 1098: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1094: p_db_optv_rec => l_db_optv_rec,
1095: p_optv_rec => l_optv_rec,
1096: x_return_status => l_return_status,
1097: x_msg_data => x_msg_data);
1098: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1099: RAISE Okl_Api.G_EXCEPTION_ERROR;
1100: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1101: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1102: END IF;

Line 1099: RAISE Okl_Api.G_EXCEPTION_ERROR;

1095: p_optv_rec => l_optv_rec,
1096: x_return_status => l_return_status,
1097: x_msg_data => x_msg_data);
1098: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1099: RAISE Okl_Api.G_EXCEPTION_ERROR;
1100: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1101: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1102: END IF;
1103:

Line 1100: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1096: x_return_status => l_return_status,
1097: x_msg_data => x_msg_data);
1098: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1099: RAISE Okl_Api.G_EXCEPTION_ERROR;
1100: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1101: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1102: END IF;
1103:
1104: /* public api to update options */

Line 1101: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1097: x_msg_data => x_msg_data);
1098: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1099: RAISE Okl_Api.G_EXCEPTION_ERROR;
1100: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1101: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1102: END IF;
1103:
1104: /* public api to update options */
1105: Okl_Options_Pub.update_options(p_api_version => p_api_version,

Line 1112: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1108: x_msg_count => x_msg_count,
1109: x_msg_data => x_msg_data,
1110: p_optv_rec => l_upd_optv_rec,
1111: x_optv_rec => x_optv_rec);
1112: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1113: RAISE Okl_Api.G_EXCEPTION_ERROR;
1114: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1116: END IF;

Line 1113: RAISE Okl_Api.G_EXCEPTION_ERROR;

1109: x_msg_data => x_msg_data,
1110: p_optv_rec => l_upd_optv_rec,
1111: x_optv_rec => x_optv_rec);
1112: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1113: RAISE Okl_Api.G_EXCEPTION_ERROR;
1114: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1116: END IF;
1117: END IF;

Line 1114: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1110: p_optv_rec => l_upd_optv_rec,
1111: x_optv_rec => x_optv_rec);
1112: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1113: RAISE Okl_Api.G_EXCEPTION_ERROR;
1114: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1116: END IF;
1117: END IF;
1118:

Line 1115: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1111: x_optv_rec => x_optv_rec);
1112: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1113: RAISE Okl_Api.G_EXCEPTION_ERROR;
1114: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1116: END IF;
1117: END IF;
1118:
1119: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

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

1115: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1116: END IF;
1117: END IF;
1118:
1119: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
1120: x_msg_data => x_msg_data);
1121: EXCEPTION
1122: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1123: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 1122: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1118:
1119: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
1120: x_msg_data => x_msg_data);
1121: EXCEPTION
1122: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1123: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1124: p_pkg_name => G_PKG_NAME,
1125: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1126: x_msg_count => x_msg_count,

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

1119: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
1120: x_msg_data => x_msg_data);
1121: EXCEPTION
1122: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1123: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1124: p_pkg_name => G_PKG_NAME,
1125: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1126: x_msg_count => x_msg_count,
1127: x_msg_data => x_msg_data,

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

1121: EXCEPTION
1122: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1123: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1124: p_pkg_name => G_PKG_NAME,
1125: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1126: x_msg_count => x_msg_count,
1127: x_msg_data => x_msg_data,
1128: p_api_type => '_PVT');
1129: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1129: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1125: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1126: x_msg_count => x_msg_count,
1127: x_msg_data => x_msg_data,
1128: p_api_type => '_PVT');
1129: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1130: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1131: p_pkg_name => G_PKG_NAME,
1132: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1133: x_msg_count => x_msg_count,

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

1126: x_msg_count => x_msg_count,
1127: x_msg_data => x_msg_data,
1128: p_api_type => '_PVT');
1129: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1130: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1131: p_pkg_name => G_PKG_NAME,
1132: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1133: x_msg_count => x_msg_count,
1134: x_msg_data => x_msg_data,

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

1128: p_api_type => '_PVT');
1129: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1130: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1131: p_pkg_name => G_PKG_NAME,
1132: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1133: x_msg_count => x_msg_count,
1134: x_msg_data => x_msg_data,
1135: p_api_type => '_PVT');
1136: WHEN OTHERS THEN

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

1133: x_msg_count => x_msg_count,
1134: x_msg_data => x_msg_data,
1135: p_api_type => '_PVT');
1136: WHEN OTHERS THEN
1137: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1138: p_pkg_name => G_PKG_NAME,
1139: p_exc_name => 'OTHERS',
1140: x_msg_count => x_msg_count,
1141: x_msg_data => x_msg_data,