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

Line 31: IF l_sob_id IS NULL OR l_sob_id = OKL_API.G_MISS_NUM THEN

27: -- get sob id
28: l_sob_id := OKL_ACCOUNTING_UTIL.get_set_of_books_id;
29:
30: --validate sob id
31: IF l_sob_id IS NULL OR l_sob_id = OKL_API.G_MISS_NUM THEN
32: okl_api.set_message(p_app_name => G_APP_NAME,
33: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
34: RAISE OKL_API.G_EXCEPTION_ERROR;
35: END IF;

Line 32: okl_api.set_message(p_app_name => G_APP_NAME,

28: l_sob_id := OKL_ACCOUNTING_UTIL.get_set_of_books_id;
29:
30: --validate sob id
31: IF l_sob_id IS NULL OR l_sob_id = OKL_API.G_MISS_NUM THEN
32: okl_api.set_message(p_app_name => G_APP_NAME,
33: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
34: RAISE OKL_API.G_EXCEPTION_ERROR;
35: END IF;
36:

Line 34: RAISE OKL_API.G_EXCEPTION_ERROR;

30: --validate sob id
31: IF l_sob_id IS NULL OR l_sob_id = OKL_API.G_MISS_NUM THEN
32: okl_api.set_message(p_app_name => G_APP_NAME,
33: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
34: RAISE OKL_API.G_EXCEPTION_ERROR;
35: END IF;
36:
37: OPEN period_details_csr(l_sob_id);
38: FETCH period_details_csr INTO l_period_set_name, l_user_period_type;

Line 41: okl_api.set_message(p_app_name => G_APP_NAME,

37: OPEN period_details_csr(l_sob_id);
38: FETCH period_details_csr INTO l_period_set_name, l_user_period_type;
39: IF period_details_csr%NOTFOUND THEN
40: -- store SQL error message on message stack for caller
41: okl_api.set_message(p_app_name => G_APP_NAME,
42: p_msg_name => G_NO_MATCHING_RECORD,
43: p_token1 => G_COL_NAME_TOKEN,
44: p_token1_value => 'l_sob_id');
45: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 45: RAISE OKL_API.G_EXCEPTION_ERROR;

41: okl_api.set_message(p_app_name => G_APP_NAME,
42: p_msg_name => G_NO_MATCHING_RECORD,
43: p_token1 => G_COL_NAME_TOKEN,
44: p_token1_value => 'l_sob_id');
45: RAISE OKL_API.G_EXCEPTION_ERROR;
46: END IF;
47: CLOSE period_details_csr;
48:
49: OPEN period_name_csr(p_date, l_period_set_name, l_user_period_type);

Line 53: okl_api.set_message(p_app_name => G_APP_NAME,

49: OPEN period_name_csr(p_date, l_period_set_name, l_user_period_type);
50: FETCH period_name_csr INTO l_period_name;
51: IF period_name_csr%NOTFOUND THEN
52: -- store SQL error message on message stack for caller
53: okl_api.set_message(p_app_name => G_APP_NAME,
54: p_msg_name => G_NO_MATCHING_RECORD,
55: p_token1 => G_COL_NAME_TOKEN,
56: p_token1_value => 'l_period_set_name');
57: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 57: RAISE OKL_API.G_EXCEPTION_ERROR;

53: okl_api.set_message(p_app_name => G_APP_NAME,
54: p_msg_name => G_NO_MATCHING_RECORD,
55: p_token1 => G_COL_NAME_TOKEN,
56: p_token1_value => 'l_period_set_name');
57: RAISE OKL_API.G_EXCEPTION_ERROR;
58: END IF;
59: CLOSE period_name_csr;
60:
61: RETURN l_period_name;

Line 64: WHEN OKL_API.G_EXCEPTION_ERROR THEN

60:
61: RETURN l_period_name;
62:
63: EXCEPTION
64: WHEN OKL_API.G_EXCEPTION_ERROR THEN
65: IF period_details_csr%ISOPEN THEN
66: CLOSE period_details_csr;
67: END IF;
68:

Line 104: OKL_API.set_message(p_app_name => G_APP_NAME,

100: OPEN category_name_csr(p_category_id);
101: FETCH category_name_csr INTO l_category_name;
102: IF category_name_csr%NOTFOUND THEN
103: -- store SQL error message on message stack for caller
104: OKL_API.set_message(p_app_name => G_APP_NAME,
105: p_msg_name => G_NO_MATCHING_RECORD,
106: p_token1 => G_COL_NAME_TOKEN,
107: p_token1_value => 'p_category_id');
108: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 108: RAISE OKL_API.G_EXCEPTION_ERROR;

104: OKL_API.set_message(p_app_name => G_APP_NAME,
105: p_msg_name => G_NO_MATCHING_RECORD,
106: p_token1 => G_COL_NAME_TOKEN,
107: p_token1_value => 'p_category_id');
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END IF;
110: CLOSE category_name_csr;
111:
112: RETURN l_category_name;

Line 115: WHEN OKL_API.G_EXCEPTION_ERROR THEN

111:
112: RETURN l_category_name;
113:
114: EXCEPTION
115: WHEN OKL_API.G_EXCEPTION_ERROR THEN
116: IF category_name_csr%ISOPEN THEN
117: CLOSE category_name_csr;
118: END IF;
119:

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

138: p_date_from IN DATE,
139: p_date_to IN DATE ) RETURN NUMBER IS
140:
141: x_request_id NUMBER;
142: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
143: l_msg_count NUMBER;
144: l_msg_data VARCHAR2(2000);
145: l_api_name VARCHAR2(2000) := 'SUBMIT_DEPRN_ADJUSTMENT';
146: l_api_version CONSTANT NUMBER := 1.0;

Line 147: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;

143: l_msg_count NUMBER;
144: l_msg_data VARCHAR2(2000);
145: l_api_name VARCHAR2(2000) := 'SUBMIT_DEPRN_ADJUSTMENT';
146: l_api_version CONSTANT NUMBER := 1.0;
147: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;
148: l_date_from VARCHAR2(2000);
149: l_date_to VARCHAR2(2000);
150:
151: BEGIN

Line 153: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

149: l_date_to VARCHAR2(2000);
150:
151: BEGIN
152: -- Set save point
153: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
154: ,G_PKG_NAME
155: ,l_init_msg_list
156: ,l_api_version
157: ,p_api_version

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

156: ,l_api_version
157: ,p_api_version
158: ,'_PVT'
159: ,l_return_status);
160: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
163: RAISE Okl_Api.G_EXCEPTION_ERROR;
164: END IF;

Line 161: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

157: ,p_api_version
158: ,'_PVT'
159: ,l_return_status);
160: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
163: RAISE Okl_Api.G_EXCEPTION_ERROR;
164: END IF;
165:

Line 162: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

158: ,'_PVT'
159: ,l_return_status);
160: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
163: RAISE Okl_Api.G_EXCEPTION_ERROR;
164: END IF;
165:
166: -- Bug 3130551

Line 163: RAISE Okl_Api.G_EXCEPTION_ERROR;

159: ,l_return_status);
160: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
163: RAISE Okl_Api.G_EXCEPTION_ERROR;
164: END IF;
165:
166: -- Bug 3130551
167: -- check if period from date is missing

Line 168: IF (p_date_from IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN

164: END IF;
165:
166: -- Bug 3130551
167: -- check if period from date is missing
168: IF (p_date_from IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
169: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
170: p_msg_name => 'OKL_MGP_PERIOD_FROM_ERROR');
171: RAISE Okl_Api.G_EXCEPTION_ERROR;
172: ELSE

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

165:
166: -- Bug 3130551
167: -- check if period from date is missing
168: IF (p_date_from IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
169: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
170: p_msg_name => 'OKL_MGP_PERIOD_FROM_ERROR');
171: RAISE Okl_Api.G_EXCEPTION_ERROR;
172: ELSE
173: l_date_from := FND_DATE.DATE_TO_CANONICAL(p_date_from);

Line 171: RAISE Okl_Api.G_EXCEPTION_ERROR;

167: -- check if period from date is missing
168: IF (p_date_from IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
169: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
170: p_msg_name => 'OKL_MGP_PERIOD_FROM_ERROR');
171: RAISE Okl_Api.G_EXCEPTION_ERROR;
172: ELSE
173: l_date_from := FND_DATE.DATE_TO_CANONICAL(p_date_from);
174: END IF;
175:

Line 178: IF (p_date_to IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN

174: END IF;
175:
176: -- Bug 3130551
177: -- check if period to date is missing
178: IF (p_date_to IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
179: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
180: p_msg_name => 'OKL_MGP_PERIOD_TO_ERROR');
181: RAISE Okl_Api.G_EXCEPTION_ERROR;
182: ELSE

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

175:
176: -- Bug 3130551
177: -- check if period to date is missing
178: IF (p_date_to IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
179: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
180: p_msg_name => 'OKL_MGP_PERIOD_TO_ERROR');
181: RAISE Okl_Api.G_EXCEPTION_ERROR;
182: ELSE
183: l_date_to := FND_DATE.DATE_TO_CANONICAL(p_date_to);

Line 181: RAISE Okl_Api.G_EXCEPTION_ERROR;

177: -- check if period to date is missing
178: IF (p_date_to IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
179: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
180: p_msg_name => 'OKL_MGP_PERIOD_TO_ERROR');
181: RAISE Okl_Api.G_EXCEPTION_ERROR;
182: ELSE
183: l_date_to := FND_DATE.DATE_TO_CANONICAL(p_date_to);
184: END IF;
185:

Line 196: Okl_Api.SET_MESSAGE(G_APP_NAME, 'OKL_ERROR_SUB_CONC_PROG', 'CONC_PROG', 'OKL Depreciation Adjustment for Accrual');

192:
193: IF x_request_id = 0 THEN
194: -- Handle submission error
195: -- Raise Error if the request has not been submitted successfully.
196: Okl_Api.SET_MESSAGE(G_APP_NAME, 'OKL_ERROR_SUB_CONC_PROG', 'CONC_PROG', 'OKL Depreciation Adjustment for Accrual');
197: RAISE Okl_Api.G_EXCEPTION_ERROR;
198: ELSE
199: --set return status
200: x_return_status := l_return_status;

Line 197: RAISE Okl_Api.G_EXCEPTION_ERROR;

193: IF x_request_id = 0 THEN
194: -- Handle submission error
195: -- Raise Error if the request has not been submitted successfully.
196: Okl_Api.SET_MESSAGE(G_APP_NAME, 'OKL_ERROR_SUB_CONC_PROG', 'CONC_PROG', 'OKL Depreciation Adjustment for Accrual');
197: RAISE Okl_Api.G_EXCEPTION_ERROR;
198: ELSE
199: --set return status
200: x_return_status := l_return_status;
201: RETURN x_request_id;

Line 205: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

201: RETURN x_request_id;
202: END IF;
203:
204: EXCEPTION
205: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
206: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
207: ,g_pkg_name
208: ,'OKL_API.G_RET_STS_ERROR'
209: ,x_msg_count

Line 206: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

202: END IF;
203:
204: EXCEPTION
205: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
206: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
207: ,g_pkg_name
208: ,'OKL_API.G_RET_STS_ERROR'
209: ,x_msg_count
210: ,x_msg_data

Line 208: ,'OKL_API.G_RET_STS_ERROR'

204: EXCEPTION
205: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
206: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
207: ,g_pkg_name
208: ,'OKL_API.G_RET_STS_ERROR'
209: ,x_msg_count
210: ,x_msg_data
211: ,'_PVT');
212: RETURN x_request_id;

Line 213: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

209: ,x_msg_count
210: ,x_msg_data
211: ,'_PVT');
212: RETURN x_request_id;
213: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
214: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
215: ,g_pkg_name
216: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
217: ,x_msg_count

Line 214: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

210: ,x_msg_data
211: ,'_PVT');
212: RETURN x_request_id;
213: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
214: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
215: ,g_pkg_name
216: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
217: ,x_msg_count
218: ,x_msg_data

Line 216: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

212: RETURN x_request_id;
213: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
214: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
215: ,g_pkg_name
216: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
217: ,x_msg_count
218: ,x_msg_data
219: ,'_PVT');
220: RETURN x_request_id;

Line 222: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

218: ,x_msg_data
219: ,'_PVT');
220: RETURN x_request_id;
221: WHEN OTHERS THEN
222: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
223: (l_api_name,
224: G_PKG_NAME,
225: 'OTHERS',
226: x_msg_count,

Line 250: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;

246: l_sysdate DATE := SYSDATE;
247: l_api_version CONSTANT NUMBER := 1.0;
248: p_api_version CONSTANT NUMBER := 1.0;
249: l_api_name CONSTANT VARCHAR2(30) := 'ADJUST_DEPRECIATION';
250: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;
251: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
252: l_msg_count NUMBER;
253: l_msg_data VARCHAR2(2000);
254: l_outer_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;

Line 251: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

247: l_api_version CONSTANT NUMBER := 1.0;
248: p_api_version CONSTANT NUMBER := 1.0;
249: l_api_name CONSTANT VARCHAR2(30) := 'ADJUST_DEPRECIATION';
250: l_init_msg_list VARCHAR2(4000) := OKL_API.G_FALSE;
251: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
252: l_msg_count NUMBER;
253: l_msg_data VARCHAR2(2000);
254: l_outer_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;
255: l_org_id NUMBER;

Line 376: IF (l_sob_id IS NULL OR l_sob_id = OKL_API.G_MISS_NUM) THEN

372: BEGIN
373:
374: -- Find set of books id
375: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID;
376: IF (l_sob_id IS NULL OR l_sob_id = OKL_API.G_MISS_NUM) THEN
377: Okl_Api.set_message(p_app_name => g_app_name,
378: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
379: RAISE Okl_Api.G_EXCEPTION_ERROR;
380: END IF;

Line 377: Okl_Api.set_message(p_app_name => g_app_name,

373:
374: -- Find set of books id
375: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID;
376: IF (l_sob_id IS NULL OR l_sob_id = OKL_API.G_MISS_NUM) THEN
377: Okl_Api.set_message(p_app_name => g_app_name,
378: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
379: RAISE Okl_Api.G_EXCEPTION_ERROR;
380: END IF;
381:

Line 379: RAISE Okl_Api.G_EXCEPTION_ERROR;

375: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID;
376: IF (l_sob_id IS NULL OR l_sob_id = OKL_API.G_MISS_NUM) THEN
377: Okl_Api.set_message(p_app_name => g_app_name,
378: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
379: RAISE Okl_Api.G_EXCEPTION_ERROR;
380: END IF;
381:
382: -- Find set of books name
383: l_sob_name := Okl_Accounting_Util.GET_SET_OF_BOOKS_NAME(l_sob_id);

Line 389: okl_api.set_message(p_app_name => G_APP_NAME,

385: -- Find org name for report
386: l_org_id := mo_global.get_current_org_id();
387: IF l_org_id IS NULL THEN
388: -- store SQL error message on message stack for caller
389: okl_api.set_message(p_app_name => G_APP_NAME,
390: p_msg_name => G_INVALID_VALUE,
391: p_token1 => G_COL_NAME_TOKEN,
392: p_token1_value => 'l_org_id');
393: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 393: RAISE OKL_API.G_EXCEPTION_ERROR;

389: okl_api.set_message(p_app_name => G_APP_NAME,
390: p_msg_name => G_INVALID_VALUE,
391: p_token1 => G_COL_NAME_TOKEN,
392: p_token1_value => 'l_org_id');
393: RAISE OKL_API.G_EXCEPTION_ERROR;
394: END IF;
395:
396: OPEN org_name_csr(l_org_id);
397: FETCH org_name_csr INTO l_org_name;

Line 400: okl_api.set_message(p_app_name => G_APP_NAME,

396: OPEN org_name_csr(l_org_id);
397: FETCH org_name_csr INTO l_org_name;
398: IF org_name_csr%NOTFOUND THEN
399: -- store SQL error message on message stack for caller
400: okl_api.set_message(p_app_name => G_APP_NAME,
401: p_msg_name => G_NO_MATCHING_RECORD,
402: p_token1 => G_COL_NAME_TOKEN,
403: p_token1_value => 'l_org_id');
404: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 404: RAISE OKL_API.G_EXCEPTION_ERROR;

400: okl_api.set_message(p_app_name => G_APP_NAME,
401: p_msg_name => G_NO_MATCHING_RECORD,
402: p_token1 => G_COL_NAME_TOKEN,
403: p_token1_value => 'l_org_id');
404: RAISE OKL_API.G_EXCEPTION_ERROR;
405: END IF;
406: CLOSE org_name_csr;
407:
408:

Line 412: Okl_Api.set_message(p_app_name => g_app_name,

408:
409: -- Find currency code for the set of books id
410: l_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;
411: IF (l_currency_code IS NULL) THEN
412: Okl_Api.set_message(p_app_name => g_app_name,
413: p_msg_name => 'OKL_AGN_CURR_CODE_ERROR');
414: RAISE Okl_Api.G_EXCEPTION_ERROR;
415: END IF;
416:

Line 414: RAISE Okl_Api.G_EXCEPTION_ERROR;

410: l_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;
411: IF (l_currency_code IS NULL) THEN
412: Okl_Api.set_message(p_app_name => g_app_name,
413: p_msg_name => 'OKL_AGN_CURR_CODE_ERROR');
414: RAISE Okl_Api.G_EXCEPTION_ERROR;
415: END IF;
416:
417: -- Create report header
418: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||

Line 463: okl_api.set_message(p_app_name => G_APP_NAME,

459: OPEN sty_id_csr;
460: FETCH sty_id_csr INTO l_sty_id;
461: IF sty_id_csr%NOTFOUND THEN
462: -- store SQL error message on message stack for caller
463: okl_api.set_message(p_app_name => G_APP_NAME,
464: p_msg_name => G_NO_MATCHING_RECORD,
465: p_token1 => G_COL_NAME_TOKEN,
466: p_token1_value => 'l_sty_id');
467: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 467: RAISE OKL_API.G_EXCEPTION_ERROR;

463: okl_api.set_message(p_app_name => G_APP_NAME,
464: p_msg_name => G_NO_MATCHING_RECORD,
465: p_token1 => G_COL_NAME_TOKEN,
466: p_token1_value => 'l_sty_id');
467: RAISE OKL_API.G_EXCEPTION_ERROR;
468: END IF;
469: CLOSE sty_id_csr;
470:
471: IF l_depr_contracts_tbl.COUNT > 0 THEN

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

500: ,p_sty_id => l_sty_id
501: ,x_value => l_securitized_yn
502: ,x_inv_agmt_chr_id => l_agreement_id);
503:
504: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
507: RAISE Okl_Api.G_EXCEPTION_ERROR;
508: END IF;

Line 505: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

501: ,x_value => l_securitized_yn
502: ,x_inv_agmt_chr_id => l_agreement_id);
503:
504: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
507: RAISE Okl_Api.G_EXCEPTION_ERROR;
508: END IF;
509:

Line 506: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

502: ,x_inv_agmt_chr_id => l_agreement_id);
503:
504: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
507: RAISE Okl_Api.G_EXCEPTION_ERROR;
508: END IF;
509:
510: IF l_securitized_yn = 'T' THEN

Line 507: RAISE Okl_Api.G_EXCEPTION_ERROR;

503:
504: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
507: RAISE Okl_Api.G_EXCEPTION_ERROR;
508: END IF;
509:
510: IF l_securitized_yn = 'T' THEN
511: -- check if agreement id is available. if not throw error.

Line 513: Okl_Api.set_message(p_app_name => g_app_name,

509:
510: IF l_securitized_yn = 'T' THEN
511: -- check if agreement id is available. if not throw error.
512: IF l_agreement_id IS NULL THEN
513: Okl_Api.set_message(p_app_name => g_app_name,
514: p_msg_name => 'OKL_ADA_AGR_ID_ERROR',
515: p_token1 => G_CONTRACT_NUMBER_TOKEN,
516: p_token1_value => l_contract_number);
517: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 517: RAISE OKL_API.G_EXCEPTION_ERROR;

513: Okl_Api.set_message(p_app_name => g_app_name,
514: p_msg_name => 'OKL_ADA_AGR_ID_ERROR',
515: p_token1 => G_CONTRACT_NUMBER_TOKEN,
516: p_token1_value => l_contract_number);
517: RAISE OKL_API.G_EXCEPTION_ERROR;
518: END IF;
519:
520: OPEN agr_num_csr(l_agreement_id);
521: FETCH agr_num_csr INTO l_agreement_number;

Line 524: okl_api.set_message(p_app_name => G_APP_NAME,

520: OPEN agr_num_csr(l_agreement_id);
521: FETCH agr_num_csr INTO l_agreement_number;
522: IF agr_num_csr%NOTFOUND THEN
523: -- store SQL error message on message stack for caller
524: okl_api.set_message(p_app_name => G_APP_NAME,
525: p_msg_name => G_NO_MATCHING_RECORD,
526: p_token1 => G_COL_NAME_TOKEN,
527: p_token1_value => 'contract id');
528: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 528: RAISE OKL_API.G_EXCEPTION_ERROR;

524: okl_api.set_message(p_app_name => G_APP_NAME,
525: p_msg_name => G_NO_MATCHING_RECORD,
526: p_token1 => G_COL_NAME_TOKEN,
527: p_token1_value => 'contract id');
528: RAISE OKL_API.G_EXCEPTION_ERROR;
529: END IF;
530: CLOSE agr_num_csr;
531:
532: -- get revenue share

Line 537: Okl_Api.set_message(p_app_name => g_app_name,

533: OPEN get_revenue_share_csr(l_agreement_id);
534: FETCH get_revenue_share_csr INTO l_revenue_share;
535: IF get_revenue_share_csr%NOTFOUND OR l_revenue_share = 0 THEN
536: -- store SQL error message on message stack for caller
537: Okl_Api.set_message(p_app_name => g_app_name,
538: p_msg_name => 'OKL_ADA_REV_SHARE_ERROR',
539: p_token1 => 'AGREEMENT_NUMBER',
540: p_token1_value => l_agreement_number);
541: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 541: RAISE Okl_Api.G_EXCEPTION_ERROR;

537: Okl_Api.set_message(p_app_name => g_app_name,
538: p_msg_name => 'OKL_ADA_REV_SHARE_ERROR',
539: p_token1 => 'AGREEMENT_NUMBER',
540: p_token1_value => l_agreement_number);
541: RAISE Okl_Api.G_EXCEPTION_ERROR;
542: END IF;
543: CLOSE get_revenue_share_csr;
544:
545: END IF; --IF l_securitized_yn = 'T' THEN

Line 607: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

603: END IF; -- IF l_asset_deprn_tbl.COUNT > 0 THEN
604: END LOOP; --FOR i IN asset_deprn_csr(l_contract_id)
605:
606: EXCEPTION
607: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
608:
609: --close open cursors
610: IF agr_num_csr%ISOPEN THEN
611: CLOSE agr_num_csr;

Line 618: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

614: IF get_revenue_share_csr%ISOPEN THEN
615: CLOSE get_revenue_share_csr;
616: END IF;
617:
618: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
619:
620: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
621: IF (l_error_msg_tbl.COUNT > 0) THEN
622: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST

Line 630: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

626: END IF;
627: END LOOP;
628: END IF;
629:
630: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
631:
632: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
633:
634: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);

Line 632: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

628: END IF;
629:
630: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
631:
632: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
633:
634: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
635: IF (l_error_msg_tbl.COUNT > 0) THEN
636: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST

Line 646: OKL_API.SET_MESSAGE(p_app_name => g_app_name

642: END IF;
643:
644: WHEN OTHERS THEN
645: -- Select the contract for error reporting
646: OKL_API.SET_MESSAGE(p_app_name => g_app_name
647: ,p_msg_name => g_unexpected_error
648: ,p_token1 => g_sqlcode_token
649: ,p_token1_value => SQLCODE
650: ,p_token2 => g_sqlerrm_token

Line 653: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

649: ,p_token1_value => SQLCODE
650: ,p_token2 => g_sqlerrm_token
651: ,p_token2_value => SQLERRM);
652:
653: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
654:
655: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
656: IF (l_error_msg_tbl.COUNT > 0) THEN
657: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST

Line 687: l_return_status := OKL_API.G_RET_STS_SUCCESS;

683: END LOOP;
684: END IF;
685:
686: retcode := 0;
687: l_return_status := OKL_API.G_RET_STS_SUCCESS;
688:
689: EXCEPTION
690: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
691: --close open cursors

Line 690: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

686: retcode := 0;
687: l_return_status := OKL_API.G_RET_STS_SUCCESS;
688:
689: EXCEPTION
690: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
691: --close open cursors
692: IF org_name_csr%ISOPEN THEN
693: CLOSE org_name_csr;
694: END IF;

Line 701: l_return_status := Okl_Api.G_RET_STS_ERROR;

697: CLOSE sty_id_csr;
698: END IF;
699:
700: -- set return status needed in report
701: l_return_status := Okl_Api.G_RET_STS_ERROR;
702:
703: -- print the error message in the log file
704: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
705: ||' '||l_return_status);

Line 719: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

715:
716: retcode := 2;
717:
718: WHEN OTHERS THEN
719: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
720:
721: -- print the error message in the log file
722: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
723: ||' '||l_return_status);