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

Line 63: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR

59: aso_debug_pub.add('SQLERRM : '|| P_SQLERRM, 1, 'N');
60: END IF;
61:
62: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
63: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
64: THEN
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: FND_MSG_PUB.Count_And_Get(
67: p_count => x_msg_count,

Line 66: FND_MSG_PUB.Count_And_Get(

62: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
63: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
64: THEN
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: FND_MSG_PUB.Count_And_Get(
67: p_count => x_msg_count,
68: p_data => x_msg_data);
69: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
70: THEN

Line 69: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

65: x_return_status := FND_API.G_RET_STS_ERROR;
66: FND_MSG_PUB.Count_And_Get(
67: p_count => x_msg_count,
68: p_data => x_msg_data);
69: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
70: THEN
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: FND_MSG_PUB.Count_And_Get(
73: p_count => x_msg_count,

Line 72: FND_MSG_PUB.Count_And_Get(

68: p_data => x_msg_data);
69: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
70: THEN
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: FND_MSG_PUB.Count_And_Get(
73: p_count => x_msg_count,
74: p_data => x_msg_data);
75: ELSIF p_exception_level = G_EXC_OTHERS
76: THEN

Line 82: FND_MSG_PUB.ADD;

78:
79: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');
80: FND_MESSAGE.Set_token('PKG_NAME' , p_pkg_name);
81: FND_MESSAGE.Set_token('API_NAME' , p_api_name);
82: FND_MSG_PUB.ADD;
83: l_len_sqlerrm := Length(P_SQLERRM) ;
84: While l_len_sqlerrm >= i Loop
85: FND_MESSAGE.Set_Name('ASO', 'ASO_SQLERRM');
86: FND_MESSAGE.Set_token('ERR_TEXT' , substr(P_SQLERRM,i,240));

Line 88: FND_MSG_PUB.ADD;

84: While l_len_sqlerrm >= i Loop
85: FND_MESSAGE.Set_Name('ASO', 'ASO_SQLERRM');
86: FND_MESSAGE.Set_token('ERR_TEXT' , substr(P_SQLERRM,i,240));
87: i := i + 240;
88: FND_MSG_PUB.ADD;
89: end loop;
90:
91:
92: FND_MSG_PUB.Count_And_Get(

Line 92: FND_MSG_PUB.Count_And_Get(

88: FND_MSG_PUB.ADD;
89: end loop;
90:
91:
92: FND_MSG_PUB.Count_And_Get(
93: p_count => x_msg_count,
94: p_data => x_msg_data);
95:
96: END IF;

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

107:
108: if (p_col_choice is NULL and p_col_name is NOT NULL)
109: or (p_col_choice is NOT NULL and p_col_name is NULL)
110: then
111: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
112: then
113: fnd_message.set_name('ASO', 'API_MISSING_ORDERBY_ELEMENT');
114: fnd_msg_pub.add;
115: end if;

Line 114: fnd_msg_pub.add;

110: then
111: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
112: then
113: fnd_message.set_name('ASO', 'API_MISSING_ORDERBY_ELEMENT');
114: fnd_msg_pub.add;
115: end if;
116: raise fnd_api.g_exc_error;
117: end if;
118:

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

130: elsif (mod(p_col_choice, 10) = 0)
131: then
132: return(l_col_name || ' DESC, ');
133: else
134: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
135: then
136: fnd_message.set_name('ASO', 'API_INVALID_ORDERBY_CHOICE');
137: fnd_message.set_token('PARAM',p_col_choice, false);
138: fnd_msg_pub.add;

Line 138: fnd_msg_pub.add;

134: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
135: then
136: fnd_message.set_name('ASO', 'API_INVALID_ORDERBY_CHOICE');
137: fnd_message.set_token('PARAM',p_col_choice, false);
138: fnd_msg_pub.add;
139: end if;
140: raise fnd_api.g_exc_error;
141: return '';
142: end if;

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

167: p_api_version_number,
168: l_api_name,
169: G_PKG_NAME)
170: THEN
171: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
172: THEN
173: FND_MESSAGE.Set_Name('ASO', 'API_UNEXP_ERROR_IN_PROCESSING');
174: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
175: FND_MSG_PUB.ADD;

Line 175: FND_MSG_PUB.ADD;

171: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
172: THEN
173: FND_MESSAGE.Set_Name('ASO', 'API_UNEXP_ERROR_IN_PROCESSING');
174: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
175: FND_MSG_PUB.ADD;
176: END IF;
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:

Line 183: FND_MSG_PUB.initialize;

179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean( p_init_msg_list )
182: THEN
183: FND_MSG_PUB.initialize;
184: END IF;
185:
186: -- Initialize API return status to success
187: --

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

194: -- Validate Environment
195:
196: IF G_User_Id IS NULL
197: THEN
198: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
199: THEN
200: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
201: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
202: FND_MSG_PUB.ADD;

Line 202: FND_MSG_PUB.ADD;

198: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
199: THEN
200: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
201: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
202: FND_MSG_PUB.ADD;
203: END IF;
204: END IF;
205:
206: -- initialize the table to ''.

Line 237: FND_MSG_PUB.Count_And_Get

233: WHEN FND_API.G_EXC_ERROR THEN
234:
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236:
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241:

Line 247: FND_MSG_PUB.Count_And_Get

243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244:
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
246:
247: FND_MSG_PUB.Count_And_Get
248: ( p_count => x_msg_count,
249: p_data => x_msg_data
250: );
251:

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

254:
255:
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
257:
258: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
259: THEN
260: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
261: END IF;
262:

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

256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
257:
258: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
259: THEN
260: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
261: END IF;
262:
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,

Line 263: FND_MSG_PUB.Count_And_Get

259: THEN
260: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
261: END IF;
262:
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,
265: p_data => x_msg_data
266: );
267:

Line 280: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

276: l_length NUMBER;
277: l_start NUMBER := 1;
278: l_substring VARCHAR2(30);
279: BEGIN
280: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
281: THEN
282: /*
283: l_length := length(p_msg);
284:

Line 294: FND_MSG_PUB.Add;

290: FND_MESSAGE.Set_Name('ASO', l_substring);
291: -- FND_MESSAGE.Set_Name(p_app_name, l_substring);
292: l_start := l_start + 30;
293: l_length := l_length - 30;
294: FND_MSG_PUB.Add;
295: END LOOP;
296:
297: l_substring := substr(p_msg, l_start);
298: FND_MESSAGE.Set_Name('ASO', l_substring);

Line 301: FND_MSG_PUB.Add;

297: l_substring := substr(p_msg, l_start);
298: FND_MESSAGE.Set_Name('ASO', l_substring);
299: --dbms_output.put_line('l_substring: ' || l_substring);
300: -- FND_MESSAGE.Set_Name(p_app_name, p_msg);
301: FND_MSG_PUB.Add;
302: */
303: l_length := length(p_msg);
304:
305: -- FND_MESSAGE doesn't allow message name to be over 30 chars

Line 315: FND_MSG_PUB.Add;

311: ELSE
312: FND_MESSAGE.Set_Name('ASO', p_msg);
313: END IF;
314:
315: FND_MSG_PUB.Add;
316: END IF;
317: END Debug_Message;
318:
319:

Line 392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

388: p_flex_where_tbl_type IN ASO_UTILITY_PVT.flex_where_tbl_type,
389: x_flex_where_clause OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
390: l_flex_where_cl VARCHAR2(2000) := NULL;
391: BEGIN
392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
393: null;
394: --dbms_output.put_line('ASO_UTILITY_PVT Generate Flexfield Where: begin');
395: END IF;
396:

Line 406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

402: END IF;
403: END LOOP;
404: x_flex_where_clause := l_flex_where_cl;
405:
406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
407: null;
408: --dbms_output.put_line('ASO_UTILITY_PVT Generate Flexfield Where: end');
409: END IF;
410: END;

Line 416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

412: PROCEDURE Bind_Flexfield_Where(
413: p_cursor_id IN NUMBER,
414: p_flex_where_tbl_type IN ASO_UTILITY_PVT.flex_where_tbl_type) IS
415: BEGIN
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
417: null;
418: --dbms_output.put_line('ASO_UTILITY_PVT Bind Flexfield Where: begin');
419: END IF;
420:

Line 429: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

425: p_flex_where_tbl_type(i).value);
426: END IF;
427: END LOOP;
428:
429: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
430: null;
431: --dbms_output.put_line('ASO_UTILITY_PVT Bind Flexfield Where: end');
432: END IF;
433: END;

Line 473: l_temp_msg := fnd_msg_pub.get(l_count, fnd_api.g_true);

469:
470:
471:
472: FOR l_count in 1..NVL(p_message_count,1) LOOP
473: l_temp_msg := fnd_msg_pub.get(l_count, fnd_api.g_true);
474:
475: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
476:
477: OPEN Get_Appl_Id (l_appl_short_name);

Line 498: l_temp_msg := fnd_msg_pub.get(l_count, fnd_api.g_false);

494: ELSE
495: l_prefix_msg := NULL;
496: END IF;
497:
498: l_temp_msg := fnd_msg_pub.get(l_count, fnd_api.g_false);
499:
500: EXIT WHEN (Length(l_msg_list) + Length(l_prefix_msg) + Length(l_temp_msg)) > 2000;
501:
502: l_msg_list := l_msg_list || l_prefix_msg || l_temp_msg;

Line 757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

753: EXCEPTION
754: WHEN NO_DATA_FOUND THEN
755: RAISE NO_DATA_FOUND;
756: WHEN OTHERS THEN
757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
758: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
759: FND_MSG_PUB.ADD;
760: END IF;
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 759: FND_MSG_PUB.ADD;

755: RAISE NO_DATA_FOUND;
756: WHEN OTHERS THEN
757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
758: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
759: FND_MSG_PUB.ADD;
760: END IF;
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END Query_Header_Row;
763:

Line 2314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2310: EXCEPTION
2311: WHEN NO_DATA_FOUND THEN
2312: RAISE NO_DATA_FOUND;
2313: WHEN OTHERS THEN
2314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2315: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
2316: FND_MSG_PUB.ADD;
2317: END IF;
2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2316: FND_MSG_PUB.ADD;

2312: RAISE NO_DATA_FOUND;
2313: WHEN OTHERS THEN
2314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2315: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
2316: FND_MSG_PUB.ADD;
2317: END IF;
2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2319: END Query_Shipment_Row;
2320:

Line 3387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3383: EXCEPTION
3384: WHEN NO_DATA_FOUND THEN
3385: RAISE NO_DATA_FOUND;
3386: WHEN OTHERS THEN
3387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3388: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
3389: FND_MSG_PUB.ADD;
3390: END IF;
3391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3389: FND_MSG_PUB.ADD;

3385: RAISE NO_DATA_FOUND;
3386: WHEN OTHERS THEN
3387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3388: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_QUERY');
3389: FND_MSG_PUB.ADD;
3390: END IF;
3391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3392: END Query_Qte_Line_Row;
3393: