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_API

Line 50: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

46:
47: PROCEDURE Handle_Exceptions(
48: P_API_NAME IN VARCHAR2,
49: P_PKG_NAME IN VARCHAR2,
50: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
51: P_SQLCODE IN NUMBER DEFAULT NULL,
52: P_SQLERRM IN VARCHAR2 DEFAULT NULL,
53: P_PACKAGE_TYPE IN VARCHAR2,
54: P_ROLLBACK_FLAG IN VARCHAR2 := 'Y',

Line 70: x_return_status := FND_API.G_RET_STS_ERROR;

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,
73: p_data => x_msg_data);
74: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
79: p_data => x_msg_data);
80: ELSIF p_exception_level = G_EXC_OTHERS

Line 82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

78: p_count => x_msg_count,
79: p_data => x_msg_data);
80: ELSIF p_exception_level = G_EXC_OTHERS
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);

Line 113: raise fnd_api.g_exc_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:
116:
117: if (nls_upper(p_col_name) = 'CUSTOMER_NAME')

Line 137: raise fnd_api.g_exc_error;

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;
140: end;
141:

Line 144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

140: end;
141:
142: PROCEDURE Translate_OrderBy
143: ( p_api_version_number IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: p_order_by_tbl IN UTIL_ORDER_BY_TBL_TYPE,
147: x_order_by_clause OUT VARCHAR2,
148: x_return_status OUT VARCHAR2,

Line 145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

141:
142: PROCEDURE Translate_OrderBy
143: ( p_api_version_number IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: p_order_by_tbl IN UTIL_ORDER_BY_TBL_TYPE,
147: x_order_by_clause OUT VARCHAR2,
148: x_return_status OUT VARCHAR2,
149: x_msg_count OUT NUMBER,

Line 162: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

158: l_api_name CONSTANT VARCHAR2(30) := 'Translate_OrderBy';
159: l_api_version_number CONSTANT NUMBER := 1.0;
160: begin
161: -- Standard call to check for call compatibility.
162: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
163: p_api_version_number,
164: l_api_name,
165: G_PKG_NAME)
166: THEN

Line 173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
176: -- Initialize message list if p_init_msg_list is set to TRUE.
177: IF FND_API.to_Boolean( p_init_msg_list )

Line 177: IF FND_API.to_Boolean( p_init_msg_list )

173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;
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:

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: END IF;
181:
182: -- Initialize API return status to success
183: --
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: --
187: -- API body
188: --

Line 229: WHEN FND_API.G_EXC_ERROR THEN

225: x_order_by_clause := l_order_by_clause;
226:
227: EXCEPTION
228:
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

Line 231: x_return_status := FND_API.G_RET_STS_ERROR ;

227: EXCEPTION
228:
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

Line 239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

235: p_data => x_msg_data
236: );
237:
238:
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

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

237:
238:
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

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

248:
249: WHEN OTHERS THEN
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);

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 460: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

456: p_token2 IN VARCHAR2,
457: p_token2_value IN VARCHAR2,
458: p_token3 IN VARCHAR2,
459: p_token3_value IN VARCHAR2,
460: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 461: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

457: p_token2_value IN VARCHAR2,
458: p_token3 IN VARCHAR2,
459: p_token3_value IN VARCHAR2,
460: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 462: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

458: p_token3 IN VARCHAR2,
459: p_token3_value IN VARCHAR2,
460: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 463: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

459: p_token3_value IN VARCHAR2,
460: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 464: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

460: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
468: )

Line 465: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

461: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
468: )
469: IS

Line 466: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

462: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
468: )
469: IS
470: BEGIN

Line 467: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

463: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
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)

Line 497: AND p_flex_where_tbl_type(i).value <> FND_API.G_MISS_CHAR) THEN

493: END IF;
494:
495: FOR i IN 1..p_flex_where_tbl_type.count LOOP
496: IF (p_flex_where_tbl_type(i).value IS NOT NULL
497: AND p_flex_where_tbl_type(i).value <> FND_API.G_MISS_CHAR) THEN
498: l_flex_where_cl := l_flex_where_cl||' AND '||p_flex_where_tbl_type(i).name
499: || ' = :p_ofso_flex_var'||i;
500: END IF;
501: END LOOP;

Line 521: AND p_flex_where_tbl_type(i).value <> FND_API.G_MISS_CHAR) THEN

517: END IF;
518:
519: FOR i IN 1..p_flex_where_tbl_type.count LOOP
520: IF (p_flex_where_tbl_type(i).value IS NOT NULL
521: AND p_flex_where_tbl_type(i).value <> FND_API.G_MISS_CHAR) THEN
522: DBMS_SQL.Bind_Variable(p_cursor_id, ':p_ofso_flex_var'||i,
523: p_flex_where_tbl_type(i).value);
524: END IF;
525: END LOOP;