[Home] [Help]
1: PACKAGE BODY bis_vg_lookup AS
2: /* $Header: BISTLATB.pls 120.1.12020000.2 2012/12/04 17:39:11 dbowles ship $ */
3:
4: -- Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA
5: -- All rights reserved.
19: -- 23-JUL-98 Created
20: -- 09-MAR-99 Edited by WNASRALL
21: -- 11-DEC-01 Edited by DBOWLES Added dr driver comments.
22: --
23: G_PKG_NAME CONSTANT VARCHAR(30) := 'bis_vg_lookup';
24: /* ============================================================================
25: PROCEDURE : put_column_name
26: PARAMETERS:
27: 1. p_View_Column_Table table of varchars to hold columns OF view text
96: bis_debug_pub.ADD('column pos = '||l_num);
97: --
98: IF (l_str IS NULL) THEN
99: BIS_VG_UTIL.Add_Error_message
100: ( p_error_msg_name => bis_vg_lookup.lat_col_tag_exp_msg
101: , p_error_proc_name => G_PKG_NAME||'.put_column_name'
102: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
103: , p_error_table => x_error_tbl
104: , x_error_table => x_error_tbl
421: );
422: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
423: THEN
424: BIS_VG_UTIL.Add_Error_message
425: ( p_error_msg_name => bis_vg_lookup.LAT_INVALID_LOOKUP_TYPE_MSG
426: , p_error_proc_name => G_PKG_NAME||'. write_decode_statement'
427: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
428: , p_token1 => 'tag'
429: , p_value1 => '_LA:' || p_expr || ':' || p_lookup_table || ':' ||
884: , x_error_Tbl
885: )
886: ) THEN
887: BIS_VG_UTIL.Add_Error_message
888: ( p_error_msg_name => bis_vg_lookup.LAT_COL_TAG_EXP_NO_EXP_MSG
889: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
890: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
891: , p_token1 => 'tag'
892: , p_value1 => l_str
925: , x_error_Tbl
926: )
927: ) THEN
928: BIS_VG_UTIL.Add_Error_message
929: ( p_error_msg_name => bis_vg_lookup.LAT_COL_TAG_EXP_NO_EXP_MSG
930: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
931: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
932: , p_token1 => 'tag'
933: , p_value1 => l_str
965: , x_error_Tbl
966: )
967: ) THEN
968: BIS_VG_UTIL.Add_Error_message
969: ( p_error_msg_name => bis_vg_lookup.LAT_SEL_TAG_EXP_NO_TABLE_MSG
970: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
971: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
972: , p_token1 => 'tag'
973: , p_value1 => l_str
1002: , x_error_Tbl
1003: )
1004: ) THEN
1005: BIS_VG_UTIL.Add_Error_message
1006: ( p_error_msg_name => bis_vg_lookup.LAT_SEL_TAG_EXP_NO_TYPE_MSG
1007: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
1008: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1009: , p_token1 => 'tag'
1010: , p_value1 => l_str
1033: --
1034: IF (x_lookup_column IS NULL
1035: ) THEN
1036: BIS_VG_UTIL.Add_Error_message
1037: ( p_error_msg_name => bis_vg_lookup.LAT_SEL_TAG_EXP_NO_COL_MSG
1038: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
1039: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1040: , p_token1 => 'tag'
1041: , p_value1 => l_str
1231: ELSE
1232: -- The lookup table either does not exist
1233: -- or does not contain the column demanded
1234: BIS_VG_UTIL.Add_Error_message
1235: ( p_error_msg_name => bis_vg_lookup.LAT_SEL_TAG_UNDEF_TAB
1236: , p_error_proc_name => G_PKG_NAME||'.put_decode_in_select'
1237: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1238: , p_token1 => 'tab'
1239: , p_value1 => l_lookup_table
1365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1366:
1367: END add_Lookup_Info;
1368: --
1369: END bis_vg_lookup;