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_CTM_UTILITY_PVT dependencies on FND_API

Line 38: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;

34: query_str VARCHAR2(200);
35:
36: l_return_csr VARCHAR2(1);
37:
38: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;
39:
40: BEGIN
41:
42: /* cursor SELECT statement */

Line 51: l_return_variable := FND_API.G_FALSE;

47: FETCH c_chk_fk_id INTO l_return_csr;
48:
49: IF c_chk_fk_id%NOTFOUND THEN
50:
51: l_return_variable := FND_API.G_FALSE;
52:
53: /* Debug message */
54: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
55: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

Line 85: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;

81: query_str VARCHAR2(200);
82:
83: l_return_csr VARCHAR2(1);
84:
85: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;
86:
87: BEGIN
88:
89: -- cursor SELECT statement

Line 99: l_return_variable := FND_API.G_FALSE;

95: FETCH c_chk_lookup_code INTO l_return_csr;
96:
97: IF c_chk_lookup_code%NOTFOUND THEN
98:
99: l_return_variable := FND_API.G_FALSE;
100:
101: -- Debug message
102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
103: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_INVALID_LOOKUP_CODE');

Line 132: raise fnd_api.g_exc_error;

128: then
129: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
130: fnd_msg_pub.add;
131: end if;
132: raise fnd_api.g_exc_error;
133: end if;
134:
135:
136: if (nls_upper(p_col_name) = 'CUSTOMER_NAME')

Line 155: raise fnd_api.g_exc_error;

151: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
152: fnd_message.set_token('PARAM',p_col_choice, false);
153: fnd_msg_pub.add;
154: end if;
155: raise fnd_api.g_exc_error;
156: return '';
157: end if;
158: end;
159:

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

158: end;
159:
160: PROCEDURE Translate_OrderBy
161: ( p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,

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

159:
160: PROCEDURE Translate_OrderBy
161: ( p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_order_by_tbl IN util_order_by_tbl_type,

Line 184: IF NOT FND_API.Compatible_API_Call (l_api_version,

180:
181:
182: BEGIN
183: -- Standard call to check for call compatibility.
184: IF NOT FND_API.Compatible_API_Call (l_api_version,
185: p_api_version,
186: l_api_name,
187: G_PKG_NAME)
188: THEN

Line 195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

191: FND_MESSAGE.Set_Name('JTF', 'API_UNEXP_ERROR_IN_PROCESSING');
192: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
193: FND_MSG_PUB.ADD;
194: END IF;
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list )

Line 199: IF FND_API.to_Boolean( p_init_msg_list )

195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list )
200: THEN
201: FND_MSG_PUB.initialize;
202: END IF;
203:

Line 206: x_return_status := FND_API.G_RET_STS_SUCCESS;

202: END IF;
203:
204: -- Initialize API return status to success
205: --
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207:
208: --
209: -- API body
210: --

Line 240: WHEN FND_API.G_EXC_ERROR THEN

236: x_order_by_clause := l_order_by_clause;
237:
238: EXCEPTION
239:
240: WHEN FND_API.G_EXC_ERROR THEN
241:
242: x_return_status := FND_API.G_RET_STS_ERROR ;
243:
244: FND_MSG_PUB.Count_And_Get

Line 242: x_return_status := FND_API.G_RET_STS_ERROR ;

238: EXCEPTION
239:
240: WHEN FND_API.G_EXC_ERROR THEN
241:
242: x_return_status := FND_API.G_RET_STS_ERROR ;
243:
244: FND_MSG_PUB.Count_And_Get
245: ( p_count => x_msg_count,
246: p_data => x_msg_data

Line 250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

246: p_data => x_msg_data
247: );
248:
249:
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251:
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253:
254: FND_MSG_PUB.Count_And_Get

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

248:
249:
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251:
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253:
254: FND_MSG_PUB.Count_And_Get
255: ( p_count => x_msg_count,
256: p_data => x_msg_data

Line 263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

259:
260: WHEN OTHERS THEN
261:
262:
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
264:
265: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
266: THEN
267: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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

508: and lng.language_id = x_lang_id;
509: BEGIN
510: FOR l_count in 1..p_message_count LOOP
511:
512: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
513: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
514: OPEN Get_Appl_Id (l_appl_short_name);
515: FETCH Get_Appl_Id into l_id;
516: CLOSE Get_Appl_Id;

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

523: FETCH Get_Message_Num into l_message_num;
524: CLOSE Get_Message_Num;
525: END IF;
526:
527: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
528:
529: IF NVL(l_message_num, 0) <> 0
530: THEN
531: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';

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

535:
536: IF l_count = 1
537: THEN
538: l_msg_list := l_msg_list || l_temp_msg ||
539: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
540: ELSE
541: l_msg_list := l_msg_list || l_temp_msg ||
542: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
543: END IF;

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

538: l_msg_list := l_msg_list || l_temp_msg ||
539: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
540: ELSE
541: l_msg_list := l_msg_list || l_temp_msg ||
542: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
543: END IF;
544:
545: l_msg_list := l_msg_list || '';
546: