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

Line 68: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR

64: THEN
65: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
66: END IF;
67:
68: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
69: THEN
70: x_return_status := FND_API.G_RET_STS_ERROR;
71: FND_MSG_PUB.Count_And_Get(
72: p_count => x_msg_count,

Line 71: FND_MSG_PUB.Count_And_Get(

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

Line 74: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 77: FND_MSG_PUB.Count_And_Get(

73: p_data => x_msg_data);
74: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
75: THEN
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: FND_MSG_PUB.Count_And_Get(
78: p_count => x_msg_count,
79: p_data => x_msg_data);
80: ELSIF p_exception_level = G_EXC_OTHERS
81: THEN

Line 85: FND_MSG_PUB.Add;

81: THEN
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
83:
84: FND_MESSAGE.Set_Name('AS', 'Error number ' || to_char(P_SQLCODE));
85: FND_MSG_PUB.Add;
86: FND_MESSAGE.Set_Name('AS', 'Error text ' || P_SQLERRM);
87: FND_MSG_PUB.Add;
88:
89: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name, p_api_name);

Line 87: FND_MSG_PUB.Add;

83:
84: FND_MESSAGE.Set_Name('AS', 'Error number ' || to_char(P_SQLCODE));
85: FND_MSG_PUB.Add;
86: FND_MESSAGE.Set_Name('AS', 'Error text ' || P_SQLERRM);
87: FND_MSG_PUB.Add;
88:
89: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name, p_api_name);
90: FND_MSG_PUB.Count_And_Get(
91: p_count => x_msg_count,

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

85: FND_MSG_PUB.Add;
86: FND_MESSAGE.Set_Name('AS', 'Error text ' || P_SQLERRM);
87: FND_MSG_PUB.Add;
88:
89: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name, p_api_name);
90: FND_MSG_PUB.Count_And_Get(
91: p_count => x_msg_count,
92: p_data => x_msg_data);
93: END IF;

Line 90: FND_MSG_PUB.Count_And_Get(

86: FND_MESSAGE.Set_Name('AS', 'Error text ' || P_SQLERRM);
87: FND_MSG_PUB.Add;
88:
89: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name, p_api_name);
90: FND_MSG_PUB.Count_And_Get(
91: p_count => x_msg_count,
92: p_data => x_msg_data);
93: END IF;
94:

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

104:
105: if (p_col_choice is NULL and p_col_name is NOT NULL)
106: or (p_col_choice is NOT NULL and p_col_name is NULL)
107: then
108: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
109: then
110: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
111: fnd_msg_pub.add;
112: end if;

Line 111: fnd_msg_pub.add;

107: then
108: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
109: then
110: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
111: fnd_msg_pub.add;
112: end if;
113: raise fnd_api.g_exc_error;
114: end if;
115:

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

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

Line 135: fnd_msg_pub.add;

131: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
132: then
133: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
134: fnd_message.set_token('PARAM',p_col_choice, false);
135: fnd_msg_pub.add;
136: end if;
137: raise fnd_api.g_exc_error;
138: return '';
139: end if;

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

163: p_api_version_number,
164: l_api_name,
165: G_PKG_NAME)
166: THEN
167: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
168: THEN
169: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
170: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
171: FND_MSG_PUB.ADD;

Line 171: FND_MSG_PUB.ADD;

167: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
168: THEN
169: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
170: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
171: FND_MSG_PUB.ADD;
172: END IF;
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;
175:

Line 179: FND_MSG_PUB.initialize;

175:
176: -- Initialize message list if p_init_msg_list is set to TRUE.
177: IF FND_API.to_Boolean( p_init_msg_list )
178: THEN
179: FND_MSG_PUB.initialize;
180: END IF;
181:
182: -- Initialize API return status to success
183: --

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

190: -- Validate Environment
191:
192: IF G_User_Id IS NULL
193: THEN
194: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
195: THEN
196: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
197: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
198: FND_MSG_PUB.ADD;

Line 198: FND_MSG_PUB.ADD;

194: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
195: THEN
196: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
197: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
198: FND_MSG_PUB.ADD;
199: END IF;
200: END IF;
201:
202: -- initialize the table to ''.

Line 233: FND_MSG_PUB.Count_And_Get

229: WHEN FND_API.G_EXC_ERROR THEN
230:
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232:
233: FND_MSG_PUB.Count_And_Get
234: ( p_count => x_msg_count,
235: p_data => x_msg_data
236: );
237:

Line 243: FND_MSG_PUB.Count_And_Get

239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240:
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
242:
243: FND_MSG_PUB.Count_And_Get
244: ( p_count => x_msg_count,
245: p_data => x_msg_data
246: );
247:

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

250:
251:
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253:
254: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
257: END IF;
258:

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

252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253:
254: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
257: END IF;
258:
259: FND_MSG_PUB.Count_And_Get
260: ( p_count => x_msg_count,

Line 259: FND_MSG_PUB.Count_And_Get

255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
257: END IF;
258:
259: FND_MSG_PUB.Count_And_Get
260: ( p_count => x_msg_count,
261: p_data => x_msg_data
262: );
263:

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

293: and lng.language_id = x_lang_id;
294: BEGIN
295: FOR l_count in 1..p_message_count LOOP
296:
297: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
298: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
299: OPEN Get_Appl_Id (l_appl_short_name);
300: FETCH Get_Appl_Id into l_id;
301: CLOSE Get_Appl_Id;

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

308: FETCH Get_Message_Num into l_message_num;
309: CLOSE Get_Message_Num;
310: END IF;
311:
312: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
313:
314: IF NVL(l_message_num, 0) <> 0
315: THEN
316: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';

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

320:
321: IF l_count = 1
322: THEN
323: l_msg_list := l_msg_list || l_temp_msg ||
324: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
325: ELSE
326: l_msg_list := l_msg_list || l_temp_msg ||
327: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
328: END IF;

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

323: l_msg_list := l_msg_list || l_temp_msg ||
324: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
325: ELSE
326: l_msg_list := l_msg_list || l_temp_msg ||
327: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
328: END IF;
329:
330: l_msg_list := l_msg_list || l_newline;
331:

Line 348: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

344: l_length NUMBER;
345: l_start NUMBER := 1;
346: l_substring VARCHAR2(30);
347: BEGIN
348: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
349: THEN
350: /*
351: l_length := length(p_msg);
352:

Line 362: FND_MSG_PUB.Add;

358: FND_MESSAGE.Set_Name('AS', l_substring);
359: -- FND_MESSAGE.Set_Name(p_app_name, l_substring);
360: l_start := l_start + 30;
361: l_length := l_length - 30;
362: FND_MSG_PUB.Add;
363: END LOOP;
364:
365: l_substring := substr(p_msg, l_start);
366: FND_MESSAGE.Set_Name('AS', l_substring);

Line 369: FND_MSG_PUB.Add;

365: l_substring := substr(p_msg, l_start);
366: FND_MESSAGE.Set_Name('AS', l_substring);
367: -- dbms_output.put_line('l_substring: ' || l_substring);
368: -- FND_MESSAGE.Set_Name(p_app_name, p_msg);
369: FND_MSG_PUB.Add;
370: */
371: l_length := length(p_msg);
372:
373: -- FND_MESSAGE doesn't allow message name to be over 30 chars

Line 383: FND_MSG_PUB.Add;

379: ELSE
380: FND_MESSAGE.Set_Name(p_app_name, p_msg);
381: END IF;
382:
383: FND_MSG_PUB.Add;
384: END IF;
385: END Debug_Message;
386:
387:

Line 397: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

393: p_token1_value IN VARCHAR2
394: )
395: IS
396: BEGIN
397: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
398: THEN
399: FND_MESSAGE.Set_Name('AS', p_msg_name);
400: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
401: FND_MSG_PUB.Add;

Line 401: FND_MSG_PUB.Add;

397: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
398: THEN
399: FND_MESSAGE.Set_Name('AS', p_msg_name);
400: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
401: FND_MSG_PUB.Add;
402: END IF;
403: END Set_Message;
404:
405: PROCEDURE Set_Message(

Line 416: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

412: p_token2_value IN VARCHAR2
413: )
414: IS
415: BEGIN
416: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
417: THEN
418: FND_MESSAGE.Set_Name('AS', p_msg_name);
419: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
420: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

Line 421: FND_MSG_PUB.Add;

417: THEN
418: FND_MESSAGE.Set_Name('AS', p_msg_name);
419: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
420: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
421: FND_MSG_PUB.Add;
422: END IF;
423: END Set_Message;
424:
425: PROCEDURE Set_Message(

Line 438: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

434: p_token3_value IN VARCHAR2
435: )
436: IS
437: BEGIN
438: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
439: THEN
440: FND_MESSAGE.Set_Name('AS', p_msg_name);
441: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
442: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

Line 444: FND_MSG_PUB.Add;

440: FND_MESSAGE.Set_Name('AS', p_msg_name);
441: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
442: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
443: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
444: FND_MSG_PUB.Add;
445: END IF;
446: END Set_Message;
447:
448:

Line 471: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)

467: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
468: )
469: IS
470: BEGIN
471: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
472: THEN
473: FND_MESSAGE.Set_Name('AS', p_msg_name);
474: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
475: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

Line 481: FND_MSG_PUB.Add;

477: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
478: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
479: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
480: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
481: FND_MSG_PUB.Add;
482: END IF;
483: END Set_Message;
484:
485: PROCEDURE Gen_Flexfield_Where(

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

486: p_flex_where_tbl_type IN JTF_PLSQL_API.flex_where_tbl_type,
487: x_flex_where_clause OUT VARCHAR2) IS
488: l_flex_where_cl VARCHAR2(2000) := NULL;
489: BEGIN
490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
491: null;
492: -- dbms_output.put_line('JTF_PLSQL_API Generate Flexfield Where: begin');
493: END IF;
494:

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

500: END IF;
501: END LOOP;
502: x_flex_where_clause := l_flex_where_cl;
503:
504: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
505: null;
506: -- dbms_output.put_line('JTF_PLSQL_API Generate Flexfield Where: end');
507: END IF;
508: END;

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

510: PROCEDURE Bind_Flexfield_Where(
511: p_cursor_id IN NUMBER,
512: p_flex_where_tbl_type IN JTF_PLSQL_API.flex_where_tbl_type) IS
513: BEGIN
514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
515: null;
516: -- dbms_output.put_line('JTF_PLSQL_API Bind Flexfield Where: begin');
517: END IF;
518:

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

523: p_flex_where_tbl_type(i).value);
524: END IF;
525: END LOOP;
526:
527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
528: null;
529: -- dbms_output.put_line('JTF_PLSQL_API Bind Flexfield Where: end');
530: END IF;
531: END;