APPS.OKL_MULTI_GAAP_PVT dependencies on OKL_API

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

16: OPEN category_name_csr(p_category_id);
17: FETCH category_name_csr INTO l_category_name;
18: IF category_name_csr%NOTFOUND THEN
19: -- store SQL error message on message stack for caller
20: OKL_API.set_message(p_app_name => G_APP_NAME,
21: p_msg_name => G_NO_MATCHING_RECORD,
22: p_token1 => G_COL_NAME_TOKEN,
23: p_token1_value => 'p_category_id');
24: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 24: RAISE OKL_API.G_EXCEPTION_ERROR;

20: OKL_API.set_message(p_app_name => G_APP_NAME,
21: p_msg_name => G_NO_MATCHING_RECORD,
22: p_token1 => G_COL_NAME_TOKEN,
23: p_token1_value => 'p_category_id');
24: RAISE OKL_API.G_EXCEPTION_ERROR;
25: END IF;
26: CLOSE category_name_csr;
27:
28: RETURN l_category_name;

Line 31: WHEN OKL_API.G_EXCEPTION_ERROR THEN

27:
28: RETURN l_category_name;
29:
30: EXCEPTION
31: WHEN OKL_API.G_EXCEPTION_ERROR THEN
32: IF category_name_csr%ISOPEN THEN
33: CLOSE category_name_csr;
34: END IF;
35:

Line 76: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

72: WHEN OTHERS THEN
73: IF check_multi_gaap%ISOPEN THEN
74: CLOSE check_multi_gaap;
75: END IF;
76: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
77: ,p_msg_name => G_UNEXPECTED_ERROR
78: ,p_token1 => G_SQLCODE_TOKEN
79: ,p_token1_value => SQLCODE
80: ,p_token2 => G_SQLERRM_TOKEN

Line 155: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

151: IF get_ae_lines%ISOPEN THEN
152: CLOSE get_ae_lines;
153: END IF;
154:
155: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
156: ,p_msg_name => G_UNEXPECTED_ERROR
157: ,p_token1 => G_SQLCODE_TOKEN
158: ,p_token1_value => SQLCODE
159: ,p_token2 => G_SQLERRM_TOKEN

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

173: p_date_to IN DATE,
174: p_batch_name IN VARCHAR2 ) RETURN NUMBER IS
175:
176: x_request_id NUMBER;
177: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
178: l_msg_count NUMBER;
179: l_msg_data VARCHAR2(2000);
180: l_api_name VARCHAR2(2000) := 'SUBMIT_MULTI_GAAP';
181: l_api_version CONSTANT NUMBER := 1.0;

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

178: l_msg_count NUMBER;
179: l_msg_data VARCHAR2(2000);
180: l_api_name VARCHAR2(2000) := 'SUBMIT_MULTI_GAAP';
181: l_api_version CONSTANT NUMBER := 1.0;
182: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;
183: l_date_from VARCHAR2(2000);
184: l_date_to VARCHAR2(2000);
185: BEGIN
186: -- Set save point

Line 187: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

183: l_date_from VARCHAR2(2000);
184: l_date_to VARCHAR2(2000);
185: BEGIN
186: -- Set save point
187: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
188: ,G_PKG_NAME
189: ,l_init_msg_list
190: ,l_api_version
191: ,p_api_version

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

190: ,l_api_version
191: ,p_api_version
192: ,'_PVT'
193: ,l_return_status);
194: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
195: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
196: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
197: RAISE Okl_Api.G_EXCEPTION_ERROR;
198: END IF;

Line 195: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

191: ,p_api_version
192: ,'_PVT'
193: ,l_return_status);
194: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
195: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
196: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
197: RAISE Okl_Api.G_EXCEPTION_ERROR;
198: END IF;
199:

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

192: ,'_PVT'
193: ,l_return_status);
194: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
195: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
196: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
197: RAISE Okl_Api.G_EXCEPTION_ERROR;
198: END IF;
199:
200: -- validate period from date

Line 197: RAISE Okl_Api.G_EXCEPTION_ERROR;

193: ,l_return_status);
194: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
195: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
196: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
197: RAISE Okl_Api.G_EXCEPTION_ERROR;
198: END IF;
199:
200: -- validate period from date
201: IF (p_date_from IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN

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

197: RAISE Okl_Api.G_EXCEPTION_ERROR;
198: END IF;
199:
200: -- validate period from date
201: IF (p_date_from IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
202: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
203: p_msg_name => 'OKL_MGP_PERIOD_FROM_ERROR');
204: RAISE Okl_Api.G_EXCEPTION_ERROR;
205: ELSE

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

198: END IF;
199:
200: -- validate period from date
201: IF (p_date_from IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
202: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
203: p_msg_name => 'OKL_MGP_PERIOD_FROM_ERROR');
204: RAISE Okl_Api.G_EXCEPTION_ERROR;
205: ELSE
206: l_date_from := FND_DATE.DATE_TO_CANONICAL(p_date_from);

Line 204: RAISE Okl_Api.G_EXCEPTION_ERROR;

200: -- validate period from date
201: IF (p_date_from IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
202: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
203: p_msg_name => 'OKL_MGP_PERIOD_FROM_ERROR');
204: RAISE Okl_Api.G_EXCEPTION_ERROR;
205: ELSE
206: l_date_from := FND_DATE.DATE_TO_CANONICAL(p_date_from);
207: END IF;
208:

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

206: l_date_from := FND_DATE.DATE_TO_CANONICAL(p_date_from);
207: END IF;
208:
209: -- validate period to date
210: IF (p_date_to IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
211: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
212: p_msg_name => 'OKL_MGP_PERIOD_TO_ERROR');
213: RAISE Okl_Api.G_EXCEPTION_ERROR;
214: ELSE

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

207: END IF;
208:
209: -- validate period to date
210: IF (p_date_to IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
211: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
212: p_msg_name => 'OKL_MGP_PERIOD_TO_ERROR');
213: RAISE Okl_Api.G_EXCEPTION_ERROR;
214: ELSE
215: l_date_to := FND_DATE.DATE_TO_CANONICAL(p_date_to);

Line 213: RAISE Okl_Api.G_EXCEPTION_ERROR;

209: -- validate period to date
210: IF (p_date_to IS NULL OR p_date_from = Okl_Api.G_MISS_DATE) THEN
211: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
212: p_msg_name => 'OKL_MGP_PERIOD_TO_ERROR');
213: RAISE Okl_Api.G_EXCEPTION_ERROR;
214: ELSE
215: l_date_to := FND_DATE.DATE_TO_CANONICAL(p_date_to);
216: END IF;
217:

Line 229: Okl_Api.SET_MESSAGE(G_APP_NAME, 'OKL_ERROR_SUB_CONC_PROG', 'CONC_PROG', 'Multi GAAP Adjustment Support');

225:
226: IF x_request_id = 0 THEN
227: -- Handle submission error
228: -- Raise Error if the request has not been submitted successfully.
229: Okl_Api.SET_MESSAGE(G_APP_NAME, 'OKL_ERROR_SUB_CONC_PROG', 'CONC_PROG', 'Multi GAAP Adjustment Support');
230: RAISE Okl_Api.G_EXCEPTION_ERROR;
231: ELSE
232: --set return status
233: x_return_status := l_return_status;

Line 230: RAISE Okl_Api.G_EXCEPTION_ERROR;

226: IF x_request_id = 0 THEN
227: -- Handle submission error
228: -- Raise Error if the request has not been submitted successfully.
229: Okl_Api.SET_MESSAGE(G_APP_NAME, 'OKL_ERROR_SUB_CONC_PROG', 'CONC_PROG', 'Multi GAAP Adjustment Support');
230: RAISE Okl_Api.G_EXCEPTION_ERROR;
231: ELSE
232: --set return status
233: x_return_status := l_return_status;
234: RETURN x_request_id;

Line 238: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

234: RETURN x_request_id;
235: END IF;
236:
237: EXCEPTION
238: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
239: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
240: ,g_pkg_name
241: ,'OKL_API.G_RET_STS_ERROR'
242: ,x_msg_count

Line 239: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

235: END IF;
236:
237: EXCEPTION
238: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
239: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
240: ,g_pkg_name
241: ,'OKL_API.G_RET_STS_ERROR'
242: ,x_msg_count
243: ,x_msg_data

Line 241: ,'OKL_API.G_RET_STS_ERROR'

237: EXCEPTION
238: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
239: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
240: ,g_pkg_name
241: ,'OKL_API.G_RET_STS_ERROR'
242: ,x_msg_count
243: ,x_msg_data
244: ,'_PVT');
245: RETURN x_request_id;

Line 246: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

242: ,x_msg_count
243: ,x_msg_data
244: ,'_PVT');
245: RETURN x_request_id;
246: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
247: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
248: ,g_pkg_name
249: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
250: ,x_msg_count

Line 247: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

243: ,x_msg_data
244: ,'_PVT');
245: RETURN x_request_id;
246: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
247: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
248: ,g_pkg_name
249: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
250: ,x_msg_count
251: ,x_msg_data

Line 249: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

245: RETURN x_request_id;
246: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
247: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
248: ,g_pkg_name
249: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
250: ,x_msg_count
251: ,x_msg_data
252: ,'_PVT');
253: RETURN x_request_id;

Line 255: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

251: ,x_msg_data
252: ,'_PVT');
253: RETURN x_request_id;
254: WHEN OTHERS THEN
255: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
256: (l_api_name,
257: G_PKG_NAME,
258: 'OTHERS',
259: x_msg_count,

Line 292: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;

288: l_sob_name VARCHAR2(2000);
289: l_cr_dr_flag VARCHAR2(2000);
290: l_concat_desc VARCHAR2(2000);
291: l_fac_synd_flag VARCHAR2(2000);
292: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;
293: l_msg_data VARCHAR2(2000);
294: l_org_name VARCHAR2(2000);
295: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
296: l_msg_count NUMBER;

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

291: l_fac_synd_flag VARCHAR2(2000);
292: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;
293: l_msg_data VARCHAR2(2000);
294: l_org_name VARCHAR2(2000);
295: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
296: l_msg_count NUMBER;
297: l_org_id NUMBER;
298: l_contract_error_count NUMBER := 1;
299: l_count NUMBER := 1;

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

545:
546: -- Find set of books id
547: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID;
548: IF (l_sob_id IS NULL) THEN
549: Okl_Api.set_message(p_app_name => g_app_name,
550: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
551: RAISE Okl_Api.G_EXCEPTION_ERROR;
552: END IF;
553:

Line 551: RAISE Okl_Api.G_EXCEPTION_ERROR;

547: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID;
548: IF (l_sob_id IS NULL) THEN
549: Okl_Api.set_message(p_app_name => g_app_name,
550: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
551: RAISE Okl_Api.G_EXCEPTION_ERROR;
552: END IF;
553:
554: -- Find set of books name
555: l_sob_name := Okl_Accounting_Util.GET_SET_OF_BOOKS_NAME(l_sob_id);

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

557: -- Find org name for report
558: l_org_id := mo_global.get_current_org_id();
559: IF l_org_id IS NULL THEN
560: -- store SQL error message on message stack for caller
561: okl_api.set_message(p_app_name => G_APP_NAME,
562: p_msg_name => G_INVALID_VALUE,
563: p_token1 => G_COL_NAME_TOKEN,
564: p_token1_value => 'ORG_ID');
565: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 565: RAISE OKL_API.G_EXCEPTION_ERROR;

561: okl_api.set_message(p_app_name => G_APP_NAME,
562: p_msg_name => G_INVALID_VALUE,
563: p_token1 => G_COL_NAME_TOKEN,
564: p_token1_value => 'ORG_ID');
565: RAISE OKL_API.G_EXCEPTION_ERROR;
566: END IF;
567:
568: OPEN org_name_csr(l_org_id);
569: FETCH org_name_csr INTO l_org_name;

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

569: FETCH org_name_csr INTO l_org_name;
570: IF org_name_csr%NOTFOUND THEN
571: CLOSE org_name_csr;
572: -- store SQL error message on message stack for caller
573: okl_api.set_message(p_app_name => G_APP_NAME,
574: p_msg_name => G_NO_MATCHING_RECORD,
575: p_token1 => G_COL_NAME_TOKEN,
576: p_token1_value => 'ORG_ID');
577: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 577: RAISE OKL_API.G_EXCEPTION_ERROR;

573: okl_api.set_message(p_app_name => G_APP_NAME,
574: p_msg_name => G_NO_MATCHING_RECORD,
575: p_token1 => G_COL_NAME_TOKEN,
576: p_token1_value => 'ORG_ID');
577: RAISE OKL_API.G_EXCEPTION_ERROR;
578: END IF;
579: CLOSE org_name_csr;
580:
581: -- Find the reporting asset book

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

581: -- Find the reporting asset book
582: l_book_type_code := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_RPT_PROD_BOOK_TYPE_CODE);
583: -- verify the reporting book only for secondary rep method of 'Report'. Bug 7584164
584: IF (l_book_type_code IS NULL and l_sec_rep_method = 'REPORT') THEN
585: Okl_Api.set_message(p_app_name => g_app_name,
586: p_msg_name => 'OKL_MGP_ASSET_BOOK_ERROR');
587: RAISE Okl_Api.G_EXCEPTION_ERROR;
588: END IF;
589:

Line 587: RAISE Okl_Api.G_EXCEPTION_ERROR;

583: -- verify the reporting book only for secondary rep method of 'Report'. Bug 7584164
584: IF (l_book_type_code IS NULL and l_sec_rep_method = 'REPORT') THEN
585: Okl_Api.set_message(p_app_name => g_app_name,
586: p_msg_name => 'OKL_MGP_ASSET_BOOK_ERROR');
587: RAISE Okl_Api.G_EXCEPTION_ERROR;
588: END IF;
589:
590: -- Find functional currency code for the set of books id
591: l_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;

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

589:
590: -- Find functional currency code for the set of books id
591: l_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;
592: IF (l_currency_code IS NULL) THEN
593: Okl_Api.set_message(p_app_name => g_app_name,
594: p_msg_name => 'OKL_AGN_CURR_CODE_ERROR');
595: RAISE Okl_Api.G_EXCEPTION_ERROR;
596: END IF;
597:

Line 595: RAISE Okl_Api.G_EXCEPTION_ERROR;

591: l_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;
592: IF (l_currency_code IS NULL) THEN
593: Okl_Api.set_message(p_app_name => g_app_name,
594: p_msg_name => 'OKL_AGN_CURR_CODE_ERROR');
595: RAISE Okl_Api.G_EXCEPTION_ERROR;
596: END IF;
597:
598: -- Create report header
599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE'));

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

742: x_msg_data => l_msg_data,
743: p_pdtv_rec => l_pdtv_rec,
744: p_pdt_parameter_rec => l_pdt_parameters_rec);
745: -- store the highest degree of error
746: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
747: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
748: Okl_Api.set_message(p_app_name => g_app_name,
749: p_msg_name => 'OKL_MGP_REP_PDT_ERROR',
750: p_token1 => 'PRODUCT_NAME',

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

743: p_pdtv_rec => l_pdtv_rec,
744: p_pdt_parameter_rec => l_pdt_parameters_rec);
745: -- store the highest degree of error
746: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
747: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
748: Okl_Api.set_message(p_app_name => g_app_name,
749: p_msg_name => 'OKL_MGP_REP_PDT_ERROR',
750: p_token1 => 'PRODUCT_NAME',
751: p_token1_value => l_product_name);

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

744: p_pdt_parameter_rec => l_pdt_parameters_rec);
745: -- store the highest degree of error
746: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
747: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
748: Okl_Api.set_message(p_app_name => g_app_name,
749: p_msg_name => 'OKL_MGP_REP_PDT_ERROR',
750: p_token1 => 'PRODUCT_NAME',
751: p_token1_value => l_product_name);
752:

Line 753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

749: p_msg_name => 'OKL_MGP_REP_PDT_ERROR',
750: p_token1 => 'PRODUCT_NAME',
751: p_token1_value => l_product_name);
752:
753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
754: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
755: Okl_Api.set_message(p_app_name => g_app_name,
756: p_msg_name => 'OKL_MGP_REP_PDT_ERROR',
757: p_token1 => 'PRODUCT_NAME',

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

750: p_token1 => 'PRODUCT_NAME',
751: p_token1_value => l_product_name);
752:
753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
754: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
755: Okl_Api.set_message(p_app_name => g_app_name,
756: p_msg_name => 'OKL_MGP_REP_PDT_ERROR',
757: p_token1 => 'PRODUCT_NAME',
758: p_token1_value => l_product_name);

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

751: p_token1_value => l_product_name);
752:
753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
754: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
755: Okl_Api.set_message(p_app_name => g_app_name,
756: p_msg_name => 'OKL_MGP_REP_PDT_ERROR',
757: p_token1 => 'PRODUCT_NAME',
758: p_token1_value => l_product_name);
759: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 759: RAISE OKL_API.G_EXCEPTION_ERROR;

755: Okl_Api.set_message(p_app_name => g_app_name,
756: p_msg_name => 'OKL_MGP_REP_PDT_ERROR',
757: p_token1 => 'PRODUCT_NAME',
758: p_token1_value => l_product_name);
759: RAISE OKL_API.G_EXCEPTION_ERROR;
760: END IF;
761: END IF;
762:
763: -- Bug# 2824234. Adding currency code for reporting streams.

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

784: ,x_msg_data => l_msg_data
785: ,x_result => l_rule_result
786: ,p_ctr_id => l_contract_id);
787: -- store the highest degree of error
788: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
789: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
790: Okl_Api.set_message(p_app_name => g_app_name,
791: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
792: p_token1 => 'CONTRACT_NUMBER',

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

785: ,x_result => l_rule_result
786: ,p_ctr_id => l_contract_id);
787: -- store the highest degree of error
788: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
789: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
790: Okl_Api.set_message(p_app_name => g_app_name,
791: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
792: p_token1 => 'CONTRACT_NUMBER',
793: p_token1_value => l_contract_number);

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

786: ,p_ctr_id => l_contract_id);
787: -- store the highest degree of error
788: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
789: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
790: Okl_Api.set_message(p_app_name => g_app_name,
791: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
792: p_token1 => 'CONTRACT_NUMBER',
793: p_token1_value => l_contract_number);
794: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 794: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

790: Okl_Api.set_message(p_app_name => g_app_name,
791: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
792: p_token1 => 'CONTRACT_NUMBER',
793: p_token1_value => l_contract_number);
794: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
796: Okl_Api.set_message(p_app_name => g_app_name,
797: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
798: p_token1 => 'CONTRACT_NUMBER',

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

791: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
792: p_token1 => 'CONTRACT_NUMBER',
793: p_token1_value => l_contract_number);
794: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
796: Okl_Api.set_message(p_app_name => g_app_name,
797: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
798: p_token1 => 'CONTRACT_NUMBER',
799: p_token1_value => l_contract_number);

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

792: p_token1 => 'CONTRACT_NUMBER',
793: p_token1_value => l_contract_number);
794: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
796: Okl_Api.set_message(p_app_name => g_app_name,
797: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
798: p_token1 => 'CONTRACT_NUMBER',
799: p_token1_value => l_contract_number);
800: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 800: RAISE OKL_API.G_EXCEPTION_ERROR;

796: Okl_Api.set_message(p_app_name => g_app_name,
797: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
798: p_token1 => 'CONTRACT_NUMBER',
799: p_token1_value => l_contract_number);
800: RAISE OKL_API.G_EXCEPTION_ERROR;
801: END IF;
802: END IF;
803:
804: IF l_rule_result = 'Y' THEN

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

805: l_accrual_activity := 'ACCRUAL';
806: ELSIF l_rule_result = 'N' THEN
807: l_accrual_activity := 'NON-ACCRUAL';
808: ELSE
809: Okl_Api.set_message(p_app_name => g_app_name,
810: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
811: p_token1 => 'CONTRACT_NUMBER',
812: p_token1_value => l_contract_number);
813: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 813: RAISE OKL_API.G_EXCEPTION_ERROR;

809: Okl_Api.set_message(p_app_name => g_app_name,
810: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
811: p_token1 => 'CONTRACT_NUMBER',
812: p_token1_value => l_contract_number);
813: RAISE OKL_API.G_EXCEPTION_ERROR;
814: END IF;
815:
816: -- get override status
817: OPEN override_status_csr(l_contract_id);

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

831: l_accrual_activity := 'ACCRUAL';
832: l_contract_verified := 'YES';
833: ELSE
834: -- store SQL error message on message stack for caller
835: okl_api.set_message(p_app_name => G_APP_NAME,
836: p_msg_name => G_INVALID_VALUE,
837: p_token1 => G_COL_NAME_TOKEN,
838: p_token1_value => 'ACCRUAL_YN');
839: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 839: RAISE OKL_API.G_EXCEPTION_ERROR;

835: okl_api.set_message(p_app_name => G_APP_NAME,
836: p_msg_name => G_INVALID_VALUE,
837: p_token1 => G_COL_NAME_TOKEN,
838: p_token1_value => 'ACCRUAL_YN');
839: RAISE OKL_API.G_EXCEPTION_ERROR;
840:
841: END IF; --IF j.accrual_yn = 'Y' THEN
842:
843: ELSIF l_contract_verified = 'YES' THEN

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

847: l_accrual_activity := 'ACCRUAL';
848: ELSIF l_rule_result = 'N' THEN
849: l_accrual_activity := 'NON-ACCRUAL';
850: ELSE
851: Okl_Api.set_message(p_app_name => g_app_name,
852: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
853: p_token1 => 'CONTRACT_NUMBER',
854: p_token1_value => l_contract_number);
855: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 855: RAISE OKL_API.G_EXCEPTION_ERROR;

851: Okl_Api.set_message(p_app_name => g_app_name,
852: p_msg_name => 'OKL_AGN_RULE_VALD_ERROR',
853: p_token1 => 'CONTRACT_NUMBER',
854: p_token1_value => l_contract_number);
855: RAISE OKL_API.G_EXCEPTION_ERROR;
856: END IF;
857: -- check override status
858: IF l_override_status = 'Y' THEN
859: l_accrual_activity := 'NON-ACCRUAL';

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

863: l_accrual_activity := 'ACCRUAL';
864:
865: ELSE
866: -- store SQL error message on message stack for caller
867: okl_api.set_message(p_app_name => G_APP_NAME,
868: p_msg_name => G_INVALID_VALUE,
869: p_token1 => G_COL_NAME_TOKEN,
870: p_token1_value => 'ACCRUAL_YN');
871: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 871: RAISE OKL_API.G_EXCEPTION_ERROR;

867: okl_api.set_message(p_app_name => G_APP_NAME,
868: p_msg_name => G_INVALID_VALUE,
869: p_token1 => G_COL_NAME_TOKEN,
870: p_token1_value => 'ACCRUAL_YN');
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872:
873: END IF; --IF j.accrual_yn='Y'
874: END IF; --IF l_contract_verified = 'NO' THEN
875:

Line 984: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
981:
982:
983: EXCEPTION
984: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
985: l_return_status := Okl_Api.G_RET_STS_ERROR;
986: -- Select the contract for error reporting
987: l_contract_error_tbl(l_contract_error_count) := l_contract_number;
988: l_contract_error_count := l_contract_error_count + 1;

Line 985: l_return_status := Okl_Api.G_RET_STS_ERROR;

981:
982:
983: EXCEPTION
984: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
985: l_return_status := Okl_Api.G_RET_STS_ERROR;
986: -- Select the contract for error reporting
987: l_contract_error_tbl(l_contract_error_count) := l_contract_number;
988: l_contract_error_count := l_contract_error_count + 1;
989: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||

Line 1002: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

998: END IF;
999: END LOOP;
1000: END IF;
1001:
1002: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1003: -- Select the contract for error reporting
1004: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1005:
1006: -- Select the contract for error reporting

Line 1004: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1000: END IF;
1001:
1002: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1003: -- Select the contract for error reporting
1004: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1005:
1006: -- Select the contract for error reporting
1007: l_contract_error_tbl(l_contract_error_count) := l_contract_number;
1008: l_contract_error_count := l_contract_error_count + 1;

Line 1028: l_return_status := Okl_Api.G_RET_STS_ERROR;

1024: CLOSE override_status_csr;
1025: END IF;
1026:
1027: -- Select the contract for error reporting
1028: l_return_status := Okl_Api.G_RET_STS_ERROR;
1029: -- Select the contract for error reporting
1030: l_contract_error_tbl(l_contract_error_count) := l_contract_number;
1031: l_contract_error_count := l_contract_error_count + 1;
1032: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||

Line 1198: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
1195: END IF;
1196:
1197: retcode := 0;
1198: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1199:
1200: EXCEPTION
1201: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1202: l_return_status := Okl_Api.G_RET_STS_ERROR;

Line 1201: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1197: retcode := 0;
1198: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1199:
1200: EXCEPTION
1201: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1202: l_return_status := Okl_Api.G_RET_STS_ERROR;
1203:
1204: -- print the error message in the log file
1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 1202: l_return_status := Okl_Api.G_RET_STS_ERROR;

1198: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1199:
1200: EXCEPTION
1201: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1202: l_return_status := Okl_Api.G_RET_STS_ERROR;
1203:
1204: -- print the error message in the log file
1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));

Line 1220: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1216: END LOOP;
1217: END IF;
1218: retcode := 0;
1219:
1220: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1221: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1222:
1223: -- print the error message in the log file
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')

Line 1221: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1217: END IF;
1218: retcode := 0;
1219:
1220: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1221: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1222:
1223: -- print the error message in the log file
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
1225: ||' '||l_return_status);

Line 1244: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1240: IF org_name_csr%ISOPEN THEN
1241: CLOSE org_name_csr;
1242: END IF;
1243:
1244: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1245:
1246: -- print the error message in the log file
1247: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
1248: ||' '||l_return_status);