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_PERIOD_SWEEP_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 88: l_ledger_name := OKL_ACCOUNTING_UTIL.get_set_of_books_name (p_ledger_id);

84: l_ledger_name VARCHAR2(30);
85:
86: BEGIN
87:
88: l_ledger_name := OKL_ACCOUNTING_UTIL.get_set_of_books_name (p_ledger_id);
89: INSERT INTO OKL_G_REPORTS_GT(VALUE1_TEXT,VALUE2_TEXT,VALUE1_DATE)
90: VALUES('HEADER' ,l_ledger_name, l_to_start_date);
91:
92: FOR acct_rec IN acct_csr(l_start_date,l_end_date)

Line 274: --l_ledger_id := OKL_ACCOUNTING_UTIL.get_set_of_books_id;

270:
271:
272: --rkuttiya commenting out the following code for MultiGAAP Project
273: --Bug 6017242
274: --l_ledger_id := OKL_ACCOUNTING_UTIL.get_set_of_books_id;
275: --Bug 6017242
276:
277: OPEN c_ledger_id(p_representation_code);
278: FETCH c_ledger_id INTO l_ledger_id;

Line 281: OKL_ACCOUNTING_UTIL.get_period_info(p_period_name => p_period_from,

277: OPEN c_ledger_id(p_representation_code);
278: FETCH c_ledger_id INTO l_ledger_id;
279: CLOSE c_ledger_id;
280:
281: OKL_ACCOUNTING_UTIL.get_period_info(p_period_name => p_period_from,
282: p_start_date => l_start_date,
283: p_end_date => l_end_date,
284: --Bug 5707866 SLA Uptake Project
285: p_ledger_id => l_ledger_id);

Line 289: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(p_ledger_id => l_ledger_id,

285: p_ledger_id => l_ledger_id);
286:
287: /*
288: --Bug 5707866 SLA Uptake Project
289: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(p_ledger_id => l_ledger_id,
290: p_period_name => p_period_to);
291:
292: IF (l_period_status NOT IN ('O','F')) THEN
293: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 302: OKL_ACCOUNTING_UTIL.get_period_info(p_period_name => p_period_to,

298: END IF;
299: --Bug 5707866 end
300: */
301:
302: OKL_ACCOUNTING_UTIL.get_period_info(p_period_name => p_period_to,
303: p_start_date => l_to_start_date,
304: p_end_date => l_to_end_date,
305: --Bug 5707866 SLA Uptake Project
306: p_ledger_id => l_ledger_id);

Line 493: okl_accounting_util.get_message_token('OKL_LP_SWEEP_PROGRAM','OKL_TRANSFER_FROM_PERIOD')

489: --rkuttiya end
490:
491: IF (p_period_from IS NULL) THEN
492: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
493: okl_accounting_util.get_message_token('OKL_LP_SWEEP_PROGRAM','OKL_TRANSFER_FROM_PERIOD')
494: );
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497:

Line 498: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(p_period_from

494: );
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497:
498: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(p_period_from
499: ,l_ledger_id);
500:
501: IF (l_period_status IS NULL) THEN
502: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 519: OKL_ACCOUNTING_UTIL.get_period_info(p_period_from, l_start_date_from,l_end_date_from,l_ledger_id);

515:
516: RAISE OKL_API.G_EXCEPTION_ERROR;
517: END IF;
518:
519: OKL_ACCOUNTING_UTIL.get_period_info(p_period_from, l_start_date_from,l_end_date_from,l_ledger_id);
520:
521: IF (p_period_to IS NOT NULL) AND (p_period_to <> OKL_API.G_MISS_CHAR) THEN
522: OKL_ACCOUNTING_UTIL.get_period_info(p_period_to, l_start_date_to, l_end_date_to, l_ledger_id);
523: IF (l_start_date_to IS NULL) THEN

Line 522: OKL_ACCOUNTING_UTIL.get_period_info(p_period_to, l_start_date_to, l_end_date_to, l_ledger_id);

518:
519: OKL_ACCOUNTING_UTIL.get_period_info(p_period_from, l_start_date_from,l_end_date_from,l_ledger_id);
520:
521: IF (p_period_to IS NOT NULL) AND (p_period_to <> OKL_API.G_MISS_CHAR) THEN
522: OKL_ACCOUNTING_UTIL.get_period_info(p_period_to, l_start_date_to, l_end_date_to, l_ledger_id);
523: IF (l_start_date_to IS NULL) THEN
524: OKL_API.set_message(p_app_name => G_APP_NAME,
525: p_msg_name => 'OKL_PERIOD_NOT_FOUND',
526: p_token1 => 'PERIOD_NAME',

Line 541: OKL_ACCOUNTING_UTIL.get_period_info(l_to_date, l_to_period, l_start_date_to, l_end_date_to,l_ledger_id);

537: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN,'To Period');
538: RAISE OKL_API.G_EXCEPTION_ERROR;
539: END IF;
540:
541: OKL_ACCOUNTING_UTIL.get_period_info(l_to_date, l_to_period, l_start_date_to, l_end_date_to,l_ledger_id);
542: END IF;
543:
544: l_period_status := NULL;
545: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(l_to_period

Line 545: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(l_to_period

541: OKL_ACCOUNTING_UTIL.get_period_info(l_to_date, l_to_period, l_start_date_to, l_end_date_to,l_ledger_id);
542: END IF;
543:
544: l_period_status := NULL;
545: l_period_status := OKL_ACCOUNTING_UTIL.GET_OKL_PERIOD_STATUS(l_to_period
546: ,l_ledger_id);
547: IF (l_period_status NOT IN ('O','F')) THEN
548: OKL_API.set_message(p_app_name => G_APP_NAME,
549: p_msg_name => 'OKL_PERIOD_NOT_OPEN',

Line 556: OKL_ACCOUNTING_UTIL.get_period_info(l_to_period, l_start_date_to,l_end_date_to,l_ledger_id);

552:
553: RAISE OKL_API.G_EXCEPTION_ERROR;
554: END IF;
555:
556: OKL_ACCOUNTING_UTIL.get_period_info(l_to_period, l_start_date_to,l_end_date_to,l_ledger_id);
557:
558: IF (l_start_date_to <= l_start_date_from) THEN
559: OKL_API.set_message(p_app_name => G_APP_NAME,
560: p_msg_name => 'OKL_TO_PERIOD_LATER');