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.AS_UTILITY_PVT dependencies on FND_MSG_PUB

Line 12: -- in FND_MSG_PUB.Count_And_Get of

8: -- 08/11/99 AWU CREATED(as AS_UTILITY)
9: -- 09/09/99 SOLIN UPDATED(change to JTF_PLSQL_API)
10: -- 04/09/00 SOLIN UPDATED(change back to AS_UTILITY)
11: -- 10/12/00 SOLIN ADD "p_encoded => FND_API.G_FALSE,"
12: -- in FND_MSG_PUB.Count_And_Get of
13: -- Handle_Exceptions()
14: -- 11/12/02 AXAVIER Bug#2659173 Changed the procedure Debug_Message.
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_UTILITY_PVT';

Line 47: if p_old_level = FND_MSG_PUB.G_MSG_LVL_ERROR then

43:
44: FUNCTION translate_log_level(p_old_level NUMBER) RETURN NUMBER IS
45: l_level NUMBER;
46: BEGIN
47: if p_old_level = FND_MSG_PUB.G_MSG_LVL_ERROR then
48: l_level := FND_LOG.LEVEL_ERROR;
49: elsif p_old_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR then
50: l_level := FND_LOG.LEVEL_UNEXPECTED;
51: elsif p_old_level = FND_MSG_PUB.G_MSG_LVL_SUCCESS then

Line 49: elsif p_old_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR then

45: l_level NUMBER;
46: BEGIN
47: if p_old_level = FND_MSG_PUB.G_MSG_LVL_ERROR then
48: l_level := FND_LOG.LEVEL_ERROR;
49: elsif p_old_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR then
50: l_level := FND_LOG.LEVEL_UNEXPECTED;
51: elsif p_old_level = FND_MSG_PUB.G_MSG_LVL_SUCCESS then
52: l_level := FND_LOG.LEVEL_EVENT;
53: else

Line 51: elsif p_old_level = FND_MSG_PUB.G_MSG_LVL_SUCCESS then

47: if p_old_level = FND_MSG_PUB.G_MSG_LVL_ERROR then
48: l_level := FND_LOG.LEVEL_ERROR;
49: elsif p_old_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR then
50: l_level := FND_LOG.LEVEL_UNEXPECTED;
51: elsif p_old_level = FND_MSG_PUB.G_MSG_LVL_SUCCESS then
52: l_level := FND_LOG.LEVEL_EVENT;
53: else
54: l_level := FND_LOG.LEVEL_STATEMENT;
55: end if;

Line 63: if p_level = FND_MSG_PUB.G_MSG_LVL_ERROR then

59:
60: -- The following procedure have added for common logging enhancement
61: PROCEDURE SET_LOG(p_module VARCHAR2, p_level NUMBER) is
62: BEGIN
63: if p_level = FND_MSG_PUB.G_MSG_LVL_ERROR then
64: if FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
65: fnd_log.message(FND_LOG.LEVEL_ERROR,p_module,TRUE);
66: end if;
67: elsif p_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR then

Line 67: elsif p_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR then

63: if p_level = FND_MSG_PUB.G_MSG_LVL_ERROR then
64: if FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
65: fnd_log.message(FND_LOG.LEVEL_ERROR,p_module,TRUE);
66: end if;
67: elsif p_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR then
68: if FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
69: fnd_log.message(FND_LOG.LEVEL_UNEXPECTED,p_module,TRUE);
70: end if;
71: elsif p_level = FND_MSG_PUB.G_MSG_LVL_SUCCESS then

Line 71: elsif p_level = FND_MSG_PUB.G_MSG_LVL_SUCCESS then

67: elsif p_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR then
68: if FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
69: fnd_log.message(FND_LOG.LEVEL_UNEXPECTED,p_module,TRUE);
70: end if;
71: elsif p_level = FND_MSG_PUB.G_MSG_LVL_SUCCESS then
72: if FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
73: fnd_log.message(FND_LOG.LEVEL_EVENT,p_module,TRUE);
74: end if;
75: else

Line 148: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR

144: THEN
145: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
146: END IF;
147:
148: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
149: THEN
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: FND_MSG_PUB.Count_And_Get(
152: p_encoded => FND_API.G_FALSE,

Line 151: FND_MSG_PUB.Count_And_Get(

147:
148: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
149: THEN
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: FND_MSG_PUB.Count_And_Get(
152: p_encoded => FND_API.G_FALSE,
153: p_count => x_msg_count,
154: p_data => x_msg_data);
155: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 155: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

151: FND_MSG_PUB.Count_And_Get(
152: p_encoded => FND_API.G_FALSE,
153: p_count => x_msg_count,
154: p_data => x_msg_data);
155: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
156: THEN
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_And_Get(
159: p_encoded => FND_API.G_FALSE,

Line 158: FND_MSG_PUB.Count_And_Get(

154: p_data => x_msg_data);
155: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
156: THEN
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_And_Get(
159: p_encoded => FND_API.G_FALSE,
160: p_count => x_msg_count,
161: p_data => x_msg_data);
162: ELSIF p_exception_level = G_EXC_OTHERS

Line 169: FND_MSG_PUB.Add;

165:
166: l_log_level := translate_log_level(p_exception_level);
167: IF l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
168: FND_MESSAGE.Set_Name('AS', 'Error number ' || to_char(P_SQLCODE));
169: FND_MSG_PUB.Add;
170: FND_MESSAGE.Set_Name('AS', 'Error number ' || to_char(P_SQLCODE));
171: SET_LOG(p_module, p_exception_level);
172: END IF;
173:

Line 175: -- actually it's reduntant. FND_MSG_PUB.Add_Exc_Msg will do the work.

171: SET_LOG(p_module, p_exception_level);
172: END IF;
173:
174: -- ffang 090902, bug 2552070, this line is causing the problem and
175: -- actually it's reduntant. FND_MSG_PUB.Add_Exc_Msg will do the work.
176: -- Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR, P_SQLERRM);
177: -- end ffang 090902, bug 2552070
178:
179: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name, p_api_name);

Line 176: -- Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR, P_SQLERRM);

172: END IF;
173:
174: -- ffang 090902, bug 2552070, this line is causing the problem and
175: -- actually it's reduntant. FND_MSG_PUB.Add_Exc_Msg will do the work.
176: -- Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR, P_SQLERRM);
177: -- end ffang 090902, bug 2552070
178:
179: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name, p_api_name);
180: FND_MSG_PUB.Count_And_Get(

Line 179: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name, p_api_name);

175: -- actually it's reduntant. FND_MSG_PUB.Add_Exc_Msg will do the work.
176: -- Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR, P_SQLERRM);
177: -- end ffang 090902, bug 2552070
178:
179: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name, p_api_name);
180: FND_MSG_PUB.Count_And_Get(
181: p_encoded => FND_API.G_FALSE,
182: p_count => x_msg_count,
183: p_data => x_msg_data);

Line 180: FND_MSG_PUB.Count_And_Get(

176: -- Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR, P_SQLERRM);
177: -- end ffang 090902, bug 2552070
178:
179: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name, p_api_name);
180: FND_MSG_PUB.Count_And_Get(
181: p_encoded => FND_API.G_FALSE,
182: p_count => x_msg_count,
183: p_data => x_msg_data);
184: END IF;

Line 199: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

195:
196: if (p_col_choice is NULL and p_col_name is NOT NULL)
197: or (p_col_choice is NOT NULL and p_col_name is NULL)
198: then
199: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
200: then
201: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
202: fnd_msg_pub.add;
203: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');

Line 202: fnd_msg_pub.add;

198: then
199: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
200: then
201: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
202: fnd_msg_pub.add;
203: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
204: SET_LOG('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);
205: end if;
206: raise fnd_api.g_exc_error;

Line 204: SET_LOG('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);

200: then
201: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
202: fnd_msg_pub.add;
203: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
204: SET_LOG('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);
205: end if;
206: raise fnd_api.g_exc_error;
207: end if;
208:

Line 224: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

220: elsif (mod(p_col_choice, 10) = 0)
221: then
222: return(l_col_name || ' DESC, ');
223: else
224: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
225: then
226: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
227: fnd_message.set_token('PARAM',p_col_choice, false);
228: fnd_msg_pub.add;

Line 228: fnd_msg_pub.add;

224: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
225: then
226: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
227: fnd_message.set_token('PARAM',p_col_choice, false);
228: fnd_msg_pub.add;
229: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
230: fnd_message.set_token('PARAM',p_col_choice, false);
231: set_log('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);
232: end if;

Line 231: set_log('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);

227: fnd_message.set_token('PARAM',p_col_choice, false);
228: fnd_msg_pub.add;
229: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
230: fnd_message.set_token('PARAM',p_col_choice, false);
231: set_log('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);
232: end if;
233: raise fnd_api.g_exc_error;
234: return '';
235: end if;

Line 263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

259: p_api_version_number,
260: l_api_name,
261: G_PKG_NAME)
262: THEN
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
264: THEN
265: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
266: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
267: FND_MSG_PUB.ADD;

Line 267: FND_MSG_PUB.ADD;

263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
264: THEN
265: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
266: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
267: FND_MSG_PUB.ADD;
268: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
269: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
270: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);
271: END IF;

Line 270: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);

266: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
267: FND_MSG_PUB.ADD;
268: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
269: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
270: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);
271: END IF;
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:

Line 278: FND_MSG_PUB.initialize;

274:
275: -- Initialize message list if p_init_msg_list is set to TRUE.
276: IF FND_API.to_Boolean( p_init_msg_list )
277: THEN
278: FND_MSG_PUB.initialize;
279: END IF;
280:
281: -- Initialize API return status to success
282: --

Line 293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

289: -- Validate Environment
290:
291: IF FND_GLOBAL.User_Id IS NULL
292: THEN
293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
294: THEN
295: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
296: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
297: FND_MSG_PUB.ADD;

Line 297: FND_MSG_PUB.ADD;

293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
294: THEN
295: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
296: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
297: FND_MSG_PUB.ADD;
298: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
299: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
300: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);
301: END IF;

Line 300: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);

296: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
297: FND_MSG_PUB.ADD;
298: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
299: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
300: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);
301: END IF;
302: END IF;
303:
304: -- initialize the table to ''.

Line 335: FND_MSG_PUB.Count_And_Get

331: WHEN FND_API.G_EXC_ERROR THEN
332:
333: x_return_status := FND_API.G_RET_STS_ERROR ;
334:
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count,
337: p_data => x_msg_data
338: );
339:

Line 345: FND_MSG_PUB.Count_And_Get

341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342:
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
344:
345: FND_MSG_PUB.Count_And_Get
346: ( p_count => x_msg_count,
347: p_data => x_msg_data
348: );
349:

Line 356: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

352:
353:
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355:
356: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
357: THEN
358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
359: END IF;
360:

Line 358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355:
356: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
357: THEN
358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
359: END IF;
360:
361: FND_MSG_PUB.Count_And_Get
362: ( p_count => x_msg_count,

Line 361: FND_MSG_PUB.Count_And_Get

357: THEN
358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
359: END IF;
360:
361: FND_MSG_PUB.Count_And_Get
362: ( p_count => x_msg_count,
363: p_data => x_msg_data
364: );
365:

Line 400: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);

396: and lng.language_id = x_lang_id;
397: BEGIN
398: FOR l_count in 1..p_message_count LOOP
399:
400: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
401: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
402: OPEN Get_Appl_Id (l_appl_short_name);
403: FETCH Get_Appl_Id into l_id;
404: CLOSE Get_Appl_Id;

Line 415: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);

411: FETCH Get_Message_Num into l_message_num;
412: CLOSE Get_Message_Num;
413: END IF;
414:
415: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
416:
417: IF NVL(l_message_num, 0) <> 0
418: THEN
419: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';

Line 427: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

423:
424: IF l_count = 1
425: THEN
426: l_msg_list := l_msg_list || l_temp_msg ||
427: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
428: ELSE
429: l_msg_list := l_msg_list || l_temp_msg ||
430: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
431: END IF;

Line 430: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);

426: l_msg_list := l_msg_list || l_temp_msg ||
427: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
428: ELSE
429: l_msg_list := l_msg_list || l_temp_msg ||
430: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
431: END IF;
432:
433: l_msg_list := l_msg_list || '
434: ';

Line 463: --IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

459: l_length NUMBER;
460: l_start NUMBER := 1;
461: l_substring VARCHAR2(50);
462: BEGIN
463: --IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
464: --THEN
465: /*
466: l_length := length(p_msg);
467:

Line 477: FND_MSG_PUB.Add;

473: FND_MESSAGE.Set_Name('AS', l_substring);
474: -- FND_MESSAGE.Set_Name(p_app_name, l_substring);
475: l_start := l_start + 30;
476: l_length := l_length - 30;
477: FND_MSG_PUB.Add;
478: FND_MESSAGE.Set_Name('AS', l_substring);
479: SET_LOG(p_msg_level);
480: END LOOP;
481:

Line 488: FND_MSG_PUB.Add;

484: -- dbms_output.put_line('l_substring: ' || l_substring);
485: -- FND_MESSAGE.Set_Name(p_app_name, p_msg);
486: SET_LOG(p_msg_level);
487: FND_MESSAGE.Set_Name('AS', l_substring);
488: FND_MSG_PUB.Add;
489:
490: */
491: l_log_level := translate_log_level(p_msg_level);
492: IF l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 506: FND_MSG_PUB.Add;

502: ELSE
503: FND_MESSAGE.Set_Name('AS', p_msg);
504: -- FND_MESSAGE.Set_Name(p_msg, '');
505: END IF;
506: FND_MSG_PUB.Add;
507: IF l_length > 30
508: THEN
509: l_substring := substr(p_msg, l_start, 30);
510: FND_MESSAGE.Set_Name('AS', l_substring);

Line 537: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

533: p_msg_name IN VARCHAR2
534: )
535: IS
536: BEGIN
537: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
538: THEN
539: FND_MESSAGE.Set_Name('AS', p_msg_name);
540: FND_MSG_PUB.Add;
541: FND_MESSAGE.Set_Name('AS', p_msg_name);

Line 540: FND_MSG_PUB.Add;

536: BEGIN
537: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
538: THEN
539: FND_MESSAGE.Set_Name('AS', p_msg_name);
540: FND_MSG_PUB.Add;
541: FND_MESSAGE.Set_Name('AS', p_msg_name);
542: SET_LOG(p_module, p_msg_level);
543: END IF;
544: END Set_Message;

Line 570: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

566: p_token1_value IN VARCHAR2
567: )
568: IS
569: BEGIN
570: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
571: THEN
572: FND_MESSAGE.Set_Name('AS', p_msg_name);
573: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
574: FND_MSG_PUB.Add;

Line 574: FND_MSG_PUB.Add;

570: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
571: THEN
572: FND_MESSAGE.Set_Name('AS', p_msg_name);
573: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
574: FND_MSG_PUB.Add;
575: FND_MESSAGE.Set_Name('AS', p_msg_name);
576: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
577: SET_LOG(p_module, p_msg_level);
578: END IF;

Line 608: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

604: p_token2_value IN VARCHAR2
605: )
606: IS
607: BEGIN
608: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
609: THEN
610: FND_MESSAGE.Set_Name('AS', p_msg_name);
611: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
612: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

Line 613: FND_MSG_PUB.Add;

609: THEN
610: FND_MESSAGE.Set_Name('AS', p_msg_name);
611: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
612: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
613: FND_MSG_PUB.Add;
614: FND_MESSAGE.Set_Name('AS', p_msg_name);
615: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
616: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
617: SET_LOG(p_module, p_msg_level);

Line 653: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

649: p_token3_value IN VARCHAR2
650: )
651: IS
652: BEGIN
653: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
654: THEN
655: FND_MESSAGE.Set_Name('AS', p_msg_name);
656: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
657: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

Line 659: FND_MSG_PUB.Add;

655: FND_MESSAGE.Set_Name('AS', p_msg_name);
656: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
657: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
658: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
659: FND_MSG_PUB.Add;
660: FND_MESSAGE.Set_Name('AS', p_msg_name);
661: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
662: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
663: FND_MESSAGE.Set_Token(p_token3, p_token3_value);

Line 720: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

716: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
717: )
718: IS
719: BEGIN
720: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
721: THEN
722: FND_MESSAGE.Set_Name('AS', p_msg_name);
723: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
724: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

Line 730: FND_MSG_PUB.Add;

726: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
727: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
728: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
729: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
730: FND_MSG_PUB.Add;
731: FND_MESSAGE.Set_Name('AS', p_msg_name);
732: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
733: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
734: FND_MESSAGE.Set_Token(p_token3, p_token3_value);

Line 748: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

744: p_flex_where_tbl_type IN AS_UTILITY_PVT.flex_where_tbl_type,
745: x_flex_where_clause OUT NOCOPY VARCHAR2) IS
746: l_flex_where_cl VARCHAR2(2000) := NULL;
747: BEGIN
748: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
749: 'AS_UTILITY_PVT Generate Flexfield Where: begin');
750:
751: FOR i IN 1..p_flex_where_tbl_type.count LOOP
752: IF (p_flex_where_tbl_type(i).value IS NOT NULL

Line 760: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

756: END IF;
757: END LOOP;
758: x_flex_where_clause := l_flex_where_cl;
759:
760: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
761: 'AS_UTILITY_PVT Generate Flexfield Where: end');
762: END;
763:
764: PROCEDURE Bind_Flexfield_Where(

Line 768: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

764: PROCEDURE Bind_Flexfield_Where(
765: p_cursor_id IN NUMBER,
766: p_flex_where_tbl_type IN AS_UTILITY_PVT.flex_where_tbl_type) IS
767: BEGIN
768: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
769: 'AS_UTILITY_PVT Bind Flexfield Where: begin');
770:
771: FOR i IN 1..p_flex_where_tbl_type.count LOOP
772: IF (p_flex_where_tbl_type(i).value IS NOT NULL

Line 779: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

775: p_flex_where_tbl_type(i).value);
776: END IF;
777: END LOOP;
778:
779: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
780: 'AS_UTILITY_PVT Bind Flexfield Where: end');
781: END;
782:
783:

Line 829: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_UTILITY_PVT Processing index: '||p_indRec.index_name );

825: ' STORAGE (INITIAL '||p_indRec.int_ext||'M NEXT '||p_indRec.next_ext ||'M MINEXTENTS '||
826: p_indRec.min_ext||' MAXEXTENTS '||p_indRec.max_ext ||' PCTINCREASE '||p_indRec.pct||
827: ' FREELISTS '||p_indRec.freelists||') PARALLEL '||get_degree_parallelism||
828: ' TABLESPACE '||p_indRec.ts;
829: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_UTILITY_PVT Processing index: '||p_indRec.index_name );
830:
831: UPDATE as_conc_request_messages
832: SET index_text = p_indRec.indSql
833: WHERE index_name = p_indRec.index_name

Line 970: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'execute_ind '||'Processing index:' ||I.indname||' with mode: '||p_mode);

966: Return;
967: END IF;
968: IF (p_mode = 'BUILD') THEN
969: FOR I in build_index (p_table_name, p_table_owner) LOOP
970: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'execute_ind '||'Processing index:' ||I.indname||' with mode: '||p_mode);
971: EXECUTE IMMEDIATE I.indSql||CHR(0);
972: EXECUTE IMMEDIATE 'ALTER INDEX '||I.owner||'.'||I.indname||' LOGGING NOPARALLEL';
973: END LOOP;
974: --Code commented for performance bug#5802537-- by lester

Line 980: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'execute_ind '||'Processing index:' ||I.indname||' with mode: '||p_mode);

976: DELETE FROM as_conc_request_messages where table_name = p_table_name and table_owner = p_table_owner;
977: END IF;
978: IF (p_mode = 'DROP') THEN
979: FOR I in drop_index (p_table_name, p_table_owner) LOOP
980: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'execute_ind '||'Processing index:' ||I.indname||' with mode: '||p_mode);
981: EXECUTE IMMEDIATE 'DROP INDEX '||I.owner||'.'||I.indname;
982: END LOOP;
983: END IF;
984: retcode := 0;