APPS.AMS_CELL_INTEGRATE_PVT dependencies on AMS_UTILITY_PVT

Line 80: AMS_Utility_PVT.debug_message(l_api_name||': get list name');

76:
77: --------------------- get new list name -----------------------
78: IF (AMS_DEBUG_HIGH_ON) THEN
79:
80: AMS_Utility_PVT.debug_message(l_api_name||': get list name');
81: END IF;
82: OPEN c_get_cell_name ;
83: FETCH c_get_cell_name into l_cell_list_name;
84: CLOSE c_get_cell_name;

Line 127: AMS_Utility_PVT.debug_message(l_api_name ||': get sql string for cell');

123:
124: --------------------- find source type -----------------------
125: IF (AMS_DEBUG_HIGH_ON) THEN
126:
127: AMS_Utility_PVT.debug_message(l_api_name ||': get sql string for cell');
128: END IF;
129: AMS_CELL_PVT.get_single_sql(
130: p_api_version => p_api_version,
131: p_init_msg_list => p_init_msg_list,

Line 150: AMS_Utility_PVT.debug_message(l_api_name ||': empty sql string');

146: l_sql_string = ''
147: THEN
148: IF (AMS_DEBUG_HIGH_ON) THEN
149:
150: AMS_Utility_PVT.debug_message(l_api_name ||': empty sql string');
151: END IF;
152: RAISE FND_API.G_EXC_ERROR;
153: ELSE
154: --l_sql_string := UPPER(l_sql_string);

Line 161: AMS_Utility_PVT.debug_message(l_api_name ||': put sql string into table');

157: IF (AMS_DEBUG_HIGH_ON) THEN
158:
159:
160:
161: AMS_Utility_PVT.debug_message(l_api_name ||': put sql string into table');
162:
163: END IF;
164: l_count := 0;
165: l_string_copy := l_sql_string;

Line 184: AMS_Utility_PVT.debug_message(l_api_name||': validate sql string');

180: IF (AMS_DEBUG_HIGH_ON) THEN
181:
182:
183:
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(

Line 206: AMS_Utility_PVT.debug_message(l_api_name||': get master type');

202: IF (AMS_DEBUG_HIGH_ON) THEN
203:
204:
205:
206: AMS_Utility_PVT.debug_message(l_api_name||': get master type');
207:
208: END IF;
209: l_found := 'N';
210:

Line 230: AMS_Utility_PVT.debug_message(l_api_name ||': master_type = '||l_master_type);

226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228: IF (AMS_DEBUG_HIGH_ON) THEN
229:
230: AMS_Utility_PVT.debug_message(l_api_name ||': master_type = '||l_master_type);
231: END IF;
232: --dbms_output.put_line('master_type :' || l_master_type);
233: x_list_source_type := l_master_type;
234:

Line 242: AMS_Utility_PVT.debug_message(l_api_name ||': create_listheader');

238:
239: -- Perform the database operation
240: IF (AMS_DEBUG_HIGH_ON) THEN
241:
242: AMS_Utility_PVT.debug_message(l_api_name ||': create_listheader');
243: END IF;
244:
245: -- ams_listheader_pvt.init_listheader_rec(l_list_header_rec);
246: l_list_header_rec.list_name := l_cell_list_name ;

Line 268: AMS_Utility_PVT.debug_message(l_api_name ||'listheader_id = '||x_list_header_id);

264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: IF (AMS_DEBUG_HIGH_ON) THEN
267:
268: AMS_Utility_PVT.debug_message(l_api_name ||'listheader_id = '||x_list_header_id);
269: END IF;
270:
271: -------------------- Create_ListAction ----------------
272: IF (AMS_DEBUG_HIGH_ON) THEN

Line 274: AMS_Utility_PVT.debug_message(l_api_name ||': create_listAction');

270:
271: -------------------- Create_ListAction ----------------
272: IF (AMS_DEBUG_HIGH_ON) THEN
273:
274: AMS_Utility_PVT.debug_message(l_api_name ||': create_listAction');
275: END IF;
276:
277: l_action_rec.arc_action_used_by := 'LIST';
278: l_action_rec.action_used_by_id := x_list_header_id;