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

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

23: AS
24:
25: l_acc_rul_lns_tbl_type acc_rul_lns_tbl_type;
26: l_RowCount NUMBER := 0;
27: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
28: l_ae_line_type_meaning VARCHAR2(80);
29:
30: -- Cursor which selects all the account generator rule lines for a ae line type.
31:

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

58: l_ae_line_type_meaning := okl_accounting_util.get_lookup_meaning
59: (p_lookup_type => 'OKL_AE_LINE_TYPE',
60: p_lookup_code => p_ae_line_type);
61:
62: Okl_Api.set_message(p_app_name => g_app_name,
63: p_msg_name => 'OKL_NO_RULE_LINES_SETUP',
64: p_token1 => 'AE_LINE_TYPE',
65: p_token1_value => NVL(l_ae_line_type_meaning, p_ae_line_type));
66:

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

92: x_return_status := G_RET_STS_UNEXP_ERROR;
93: WHEN OTHERS THEN
94: -- store SQL error message on message stack for caller
95: x_return_status := G_RET_STS_UNEXP_ERROR;
96: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
97: p_msg_name => g_unexpected_error,
98: p_token1 => g_sqlcode_token,
99: p_token1_value => SQLCODE,
100: p_token2 => g_sqlerrm_token,

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

126: l_where_clause VARCHAR2(1000) := ' WHERE ';
127: l_equal_clause VARCHAR2(10) := ' = ';
128: l_gl_table VARCHAR2(50) := ' GL_CODE_COMBINATIONS ' ;
129: l_ccid_column VARCHAR2(50) := ' CODE_COMBINATION_ID ';
130: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
131: l_primary_key_msg VARCHAR2(100);
132: l_ae_line_type_meaning VARCHAR2(80);
133: l_source_table_meaning VARCHAR2(80);
134: l_exec_mode VARCHAR2(1) := NULL;

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

153: IF TRIM(SUBSTR(p_primary_key, 1, 50))IS NULL OR TRIM(SUBSTR(p_primary_key, 51, 100)) IS NULL THEN
154:
155: -- Commented out by Santonyr on 22-Sep-2004 to fix bug 3901209.
156: /*
157: Okl_Api.set_message(p_app_name => g_app_name,
158: p_msg_name => 'OKL_INV_SOURCE_OR_PK_IS_NULL'
159: );
160:
161: */

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

169: IF p_primary_key IS NULL THEN
170:
171: -- Commented out by Santonyr on 22-Sep-2004 to fix bug 3901209.
172: /*
173: Okl_Api.set_message(p_app_name => g_app_name,
174: p_msg_name => 'OKL_INV_SOURCE_OR_PK_IS_NULL'
175: );
176: */
177: G_USE_DEFAULT_ACCOUNT := 'Y';

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

198: l_source_table_meaning := okl_accounting_util.get_lookup_meaning
199: (p_lookup_type => 'OKL_ACC_GEN_SOURCE_TABLE',
200: p_lookup_code => p_source_table);
201:
202: Okl_Api.set_message(p_app_name => g_app_name,
203: p_msg_name => 'OKL_NO_SOURCES_SETUP',
204: p_token1 => 'AE_LINE_TYPE',
205: p_token1_value => NVL(l_ae_line_type_meaning, p_ae_line_type),
206: p_token2 => 'SOURCE',

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

263: l_source_table_meaning := okl_accounting_util.get_lookup_meaning
264: (p_lookup_type => 'OKL_ACC_GEN_SOURCE_TABLE',
265: p_lookup_code => p_source_table);
266:
267: Okl_Api.set_message(p_app_name => g_app_name,
268: p_msg_name => 'OKL_INVALID_SOURCE',
269: p_token1 => 'SOURCE',
270: p_token1_value => NVL(l_source_table_meaning, p_source_table)
271: );

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

301: l_source_table_meaning := okl_accounting_util.get_lookup_meaning
302: (p_lookup_type => 'OKL_ACC_GEN_SOURCE_TABLE',
303: p_lookup_code => p_source_table);
304:
305: Okl_Api.set_message(p_app_name => g_app_name,
306: p_msg_name => 'OKL_NO_SOURCE_EXISTS',
307: p_token1 => 'SOURCE',
308: p_token1_value => NVL(l_source_table_meaning, p_source_table),
309: p_token2 => 'PRIMARY_KEY',

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

326: (p_lookup_type => 'OKL_ACC_GEN_SOURCE_TABLE',
327: p_lookup_code => p_source_table);
328:
329:
330: Okl_Api.set_message(p_app_name => g_app_name,
331: p_msg_name => 'OKL_NO_SOURCE_EXISTS',
332: p_token1 => 'SOURCE',
333: p_token1_value => NVL(l_source_table_meaning, p_source_table),
334: p_token2 => 'PRIMARY_KEY',

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

369: RETURN l_segment_value;
370: WHEN OTHERS THEN
371: -- store SQL error message on message stack for caller
372: x_return_status := G_RET_STS_UNEXP_ERROR;
373: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
374: p_msg_name => g_unexpected_error,
375: p_token1 => g_sqlcode_token,
376: p_token1_value => SQLCODE,
377: p_token2 => g_sqlerrm_token,

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

395: l_number_of_segments NUMBER;
396: l_segment_seprator VARCHAR2(1);
397: l_concat_segments VARCHAR2(1500) := NULL;
398: l_primary_key VARCHAR2(100);
399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
400: i NUMBER;
401:
402: BEGIN
403: l_number_of_segments := p_acc_rul_lns_tbl_type.COUNT;

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

456: RETURN l_concat_segments;
457: WHEN OTHERS THEN
458: -- store SQL error message on message stack for caller
459: x_return_status := G_RET_STS_UNEXP_ERROR;
460: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
461: p_msg_name => g_unexpected_error,
462: p_token1 => g_sqlcode_token,
463: p_token1_value => SQLCODE,
464: p_token2 => g_sqlerrm_token,

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

476: x_return_status OUT NOCOPY VARCHAR2)
477: RETURN NUMBER
478: AS
479: l_ccid NUMBER := -1;
480: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
481: BEGIN
482:
483: -- get the ccid
484:

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

500: RETURN l_ccid;
501: WHEN OTHERS THEN
502: -- store SQL error message on message stack for caller
503: x_return_status := G_RET_STS_UNEXP_ERROR;
504: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
505: p_msg_name => g_unexpected_error,
506: p_token1 => g_sqlcode_token,
507: p_token1_value => SQLCODE,
508: p_token2 => g_sqlerrm_token,

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

535: p_ae_tmpt_line_id IN NUMBER DEFAULT NULL
536: )
537: RETURN NUMBER
538: AS
539: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
540: l_api_name CONSTANT VARCHAR2(40) := 'GENERATE_ACCOUNT';
541: l_api_version CONSTANT NUMBER := 1.0;
542: l_init_msg_list VARCHAR2(1);
543: l_msg_count NUMBER;

Line 569: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

565:
566: BEGIN
567:
568: -- Set save point
569: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
570: ,G_PKG_NAME
571: ,l_init_msg_list
572: ,l_api_version
573: ,p_api_version

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

634: l_ccid := atl_rec.code_combination_id;
635: END LOOP;
636:
637: IF l_ccid IS NULL THEN
638: Okl_Api.set_message(p_app_name => g_app_name,
639: p_msg_name => 'OKL_TMPT_LN_CCID_REQD' );
640: l_return_status := G_RET_STS_ERROR;
641: RAISE G_EXCEPTION_ERROR;
642: ELSE

Line 644: Okl_Api.end_activity(x_msg_count, x_msg_data);

640: l_return_status := G_RET_STS_ERROR;
641: RAISE G_EXCEPTION_ERROR;
642: ELSE
643: x_return_status := G_RET_STS_SUCCESS;
644: Okl_Api.end_activity(x_msg_count, x_msg_data);
645: RETURN l_ccid;
646: END IF;
647:
648: END IF;

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

659: l_ccid := get_code_combination_id(p_concate_segments => l_concat_segments
660: ,x_return_status => l_return_status );
661:
662: IF (l_ccid = -1 OR l_ccid IS NULL ) THEN
663: Okl_Api.set_message(p_app_name => g_app_name,
664: p_msg_name => 'OKL_ERROR_GEN_CCID' );
665: l_return_status := G_RET_STS_ERROR;
666: RAISE G_EXCEPTION_ERROR;
667:

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

675: l_error_text := l_concat_segments;
676: END IF;
677:
678:
679: Okl_Api.set_message(p_app_name => g_app_name,
680: p_msg_name => 'OKL_CODE_COMB_NOT_EXISTS',
681: p_token1 => 'CONCATENATED_SEGMENTS',
682: p_token1_value => l_error_text );
683: l_return_status := G_RET_STS_ERROR;

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

702: p_primary_key_tbl => p_primary_key_tbl,
703: p_ae_tmpt_line_id => p_ae_tmpt_line_id);
704:
705: IF (l_ccid = -1 OR l_ccid IS NULL ) THEN
706: Okl_Api.set_message(p_app_name => g_app_name,
707: p_msg_name => 'OKL_ERROR_GEN_CCID_WF' );
708: l_return_status := G_RET_STS_ERROR;
709: RAISE G_EXCEPTION_ERROR;
710: END IF;

Line 715: Okl_Api.end_activity(x_msg_count, x_msg_data);

711:
712: END IF;
713:
714: x_return_status := l_return_status;
715: Okl_Api.end_activity(x_msg_count, x_msg_data);
716:
717: RETURN l_ccid;
718:
719:

Line 722: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

718:
719:
720: EXCEPTION
721: WHEN G_EXCEPTION_ERROR THEN
722: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
723: ,g_pkg_name
724: ,'OKL_API.G_RET_STS_ERROR'
725: ,x_msg_count
726: ,x_msg_data

Line 724: ,'OKL_API.G_RET_STS_ERROR'

720: EXCEPTION
721: WHEN G_EXCEPTION_ERROR THEN
722: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
723: ,g_pkg_name
724: ,'OKL_API.G_RET_STS_ERROR'
725: ,x_msg_count
726: ,x_msg_data
727: ,'_PVT');
728: RETURN l_ccid;

Line 730: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

726: ,x_msg_data
727: ,'_PVT');
728: RETURN l_ccid;
729: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
730: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
731: ,g_pkg_name
732: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
733: ,x_msg_count
734: ,x_msg_data

Line 732: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

728: RETURN l_ccid;
729: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
730: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
731: ,g_pkg_name
732: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
733: ,x_msg_count
734: ,x_msg_data
735: ,'_PVT');
736: RETURN l_ccid;

Line 738: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

734: ,x_msg_data
735: ,'_PVT');
736: RETURN l_ccid;
737: WHEN OTHERS THEN
738: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
739: ,g_pkg_name
740: ,'OTHERS'
741: ,x_msg_count
742: ,x_msg_data