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 24: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 566: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

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

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

628: l_ccid := atl_rec.code_combination_id;
629: END LOOP;
630:
631: IF l_ccid IS NULL THEN
632: Okl_Api.set_message(p_app_name => g_app_name,
633: p_msg_name => 'OKL_TMPT_LN_CCID_REQD' );
634: l_return_status := G_RET_STS_ERROR;
635: RAISE G_EXCEPTION_ERROR;
636: ELSE

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

634: l_return_status := G_RET_STS_ERROR;
635: RAISE G_EXCEPTION_ERROR;
636: ELSE
637: x_return_status := G_RET_STS_SUCCESS;
638: Okl_Api.end_activity(x_msg_count, x_msg_data);
639: RETURN l_ccid;
640: END IF;
641:
642: END IF;

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

653: l_ccid := get_code_combination_id(p_concate_segments => l_concat_segments
654: ,x_return_status => l_return_status );
655:
656: IF (l_ccid = -1 OR l_ccid IS NULL ) THEN
657: Okl_Api.set_message(p_app_name => g_app_name,
658: p_msg_name => 'OKL_ERROR_GEN_CCID' );
659: l_return_status := G_RET_STS_ERROR;
660: RAISE G_EXCEPTION_ERROR;
661:

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

669: l_error_text := l_concat_segments;
670: END IF;
671:
672:
673: Okl_Api.set_message(p_app_name => g_app_name,
674: p_msg_name => 'OKL_CODE_COMB_NOT_EXISTS',
675: p_token1 => 'CONCATENATED_SEGMENTS',
676: p_token1_value => l_error_text );
677: l_return_status := G_RET_STS_ERROR;

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

696: p_primary_key_tbl => p_primary_key_tbl,
697: p_ae_tmpt_line_id => p_ae_tmpt_line_id);
698:
699: IF (l_ccid = -1 OR l_ccid IS NULL ) THEN
700: Okl_Api.set_message(p_app_name => g_app_name,
701: p_msg_name => 'OKL_ERROR_GEN_CCID_WF' );
702: l_return_status := G_RET_STS_ERROR;
703: RAISE G_EXCEPTION_ERROR;
704: END IF;

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

705:
706: END IF;
707:
708: x_return_status := l_return_status;
709: Okl_Api.end_activity(x_msg_count, x_msg_data);
710:
711: RETURN l_ccid;
712:
713:

Line 716: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

712:
713:
714: EXCEPTION
715: WHEN G_EXCEPTION_ERROR THEN
716: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
717: ,g_pkg_name
718: ,'OKL_API.G_RET_STS_ERROR'
719: ,x_msg_count
720: ,x_msg_data

Line 718: ,'OKL_API.G_RET_STS_ERROR'

714: EXCEPTION
715: WHEN G_EXCEPTION_ERROR THEN
716: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
717: ,g_pkg_name
718: ,'OKL_API.G_RET_STS_ERROR'
719: ,x_msg_count
720: ,x_msg_data
721: ,'_PVT');
722: RETURN l_ccid;

Line 724: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

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

Line 726: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

722: RETURN l_ccid;
723: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
724: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
725: ,g_pkg_name
726: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
727: ,x_msg_count
728: ,x_msg_data
729: ,'_PVT');
730: RETURN l_ccid;

Line 732: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

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