APPS.AMS_CELL_INTEGRATE_PVT dependencies on AMS_LISTGENERATION_PKG

Line 59: l_sql_string_tbl AMS_ListGeneration_PKG.sql_string;

55: l_return_status VARCHAR2(1);
56:
57: l_count NUMBER;
58: l_string_copy VARCHAR2(32767);
59: l_sql_string_tbl AMS_ListGeneration_PKG.sql_string;
60: l_length NUMBER;
61:
62: CURSOR c_chk_name IS
63: SELECT 'x'

Line 119: 'AMS_ListGeneration_PKG.create_segemnt_list: Start',

115: -- Debug Message
116: IF (AMS_DEBUG_HIGH_ON) THEN
117: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
118: FND_MESSAGE.Set_Token('ROW',
119: 'AMS_ListGeneration_PKG.create_segemnt_list: Start',
120: TRUE);
121: FND_MSG_PUB.Add;
122: END IF;
123:

Line 188: AMS_ListGeneration_PKG.validate_sql_string(

184: AMS_Utility_PVT.debug_message(l_api_name||': validate sql string');
185:
186: END IF;
187: l_found := 'N';
188: AMS_ListGeneration_PKG.validate_sql_string(
189: p_sql_string => l_sql_string_tbl ,
190: p_search_string => 'FROM',
191: p_comma_valid => 'N',
192: x_found => l_found,

Line 211: AMS_ListGeneration_PKG.get_master_types (

207:
208: END IF;
209: l_found := 'N';
210:
211: AMS_ListGeneration_PKG.get_master_types (
212: p_sql_string => l_sql_string_tbl,
213: p_start_length => 1,
214: p_start_counter => 1,
215: p_end_length => l_from_position,

Line 323: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_segment_list: END');

319:
320: --IF (AMS_DEBUG_HIGH_ON) THEN
321: --THEN
322: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
323: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_segment_list: END');
324: FND_MSG_PUB.Add;
325: --END IF;
326:
327: FND_MSG_PUB.count_and_get(