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.IBC_UTILITIES_GRP dependencies on FND_API

Line 44: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false,

40: --
41: -- --------------------------------------------------------------
42: PROCEDURE Get_Rendition_File_Id (
43: p_api_version IN NUMBER DEFAULT 1.0,
44: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false,
45: p_content_item_id IN NUMBER DEFAULT NULL,
46: p_citem_ver_id IN NUMBER DEFAULT NULL,
47: p_language IN VARCHAR2 DEFAULT NULL,
48: p_mime_type IN VARCHAR2,

Line 82: IF NOT FND_API.Compatible_API_Call (

78:
79: BEGIN
80: -- ******* Standard Begins ********
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call (
83: l_api_version,
84: p_api_version,
85: l_api_name,
86: G_PKG_NAME)

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84: p_api_version,
85: l_api_name,
86: G_PKG_NAME)
87: THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list )
92: THEN

Line 91: IF FND_API.to_Boolean( p_init_msg_list )

87: THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list )
92: THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Initialize API return status to success
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98: --******************* Real Logic Start *********************
99:
100: IF p_language IS NULL THEN
101: l_language := USERENV('LANG');

Line 126: IBC_VALIDATE_PVT.isValidCitemVer(l_citem_ver_id) = FND_API.g_false OR

122: END IF;
123:
124: -- checking version id
125: IF l_citem_ver_id IS NULL OR
126: IBC_VALIDATE_PVT.isValidCitemVer(l_citem_ver_id) = FND_API.g_false OR
127: (p_content_item_id IS NOT NULL AND
128: IBC_VALIDATE_PVT.isValidCitemVerForCitem(p_content_item_id,l_citem_ver_id) = FND_API.g_false)
129: THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;

Line 128: IBC_VALIDATE_PVT.isValidCitemVerForCitem(p_content_item_id,l_citem_ver_id) = FND_API.g_false)

124: -- checking version id
125: IF l_citem_ver_id IS NULL OR
126: IBC_VALIDATE_PVT.isValidCitemVer(l_citem_ver_id) = FND_API.g_false OR
127: (p_content_item_id IS NOT NULL AND
128: IBC_VALIDATE_PVT.isValidCitemVerForCitem(p_content_item_id,l_citem_ver_id) = FND_API.g_false)
129: THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
132: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id/p_citem_ver_id', FALSE);

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

126: IBC_VALIDATE_PVT.isValidCitemVer(l_citem_ver_id) = FND_API.g_false OR
127: (p_content_item_id IS NOT NULL AND
128: IBC_VALIDATE_PVT.isValidCitemVerForCitem(p_content_item_id,l_citem_ver_id) = FND_API.g_false)
129: THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
132: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id/p_citem_ver_id', FALSE);
133: FND_MSG_PUB.ADD;
134: RAISE FND_API.G_EXC_ERROR;

Line 134: RAISE FND_API.G_EXC_ERROR;

130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
132: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id/p_citem_ver_id', FALSE);
133: FND_MSG_PUB.ADD;
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: IF IBC_VALIDATE_PVT.isvalidlanguage(l_language) = FND_API.g_false THEN
138: x_return_status := FND_API.G_RET_STS_ERROR;

Line 137: IF IBC_VALIDATE_PVT.isvalidlanguage(l_language) = FND_API.g_false THEN

133: FND_MSG_PUB.ADD;
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: IF IBC_VALIDATE_PVT.isvalidlanguage(l_language) = FND_API.g_false THEN
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
140: FND_MESSAGE.Set_Token('INPUT', 'p_language', FALSE);
141: FND_MSG_PUB.ADD;

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: IF IBC_VALIDATE_PVT.isvalidlanguage(l_language) = FND_API.g_false THEN
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
140: FND_MESSAGE.Set_Token('INPUT', 'p_language', FALSE);
141: FND_MSG_PUB.ADD;
142: RAISE FND_API.G_EXC_ERROR;

Line 142: RAISE FND_API.G_EXC_ERROR;

138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
140: FND_MESSAGE.Set_Token('INPUT', 'p_language', FALSE);
141: FND_MSG_PUB.ADD;
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144:
145: OPEN Get_File_Id(l_citem_ver_id, l_language, l_mime_type);
146: FETCH Get_File_Id INTO l_file_id;

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: OPEN Get_File_Id(l_citem_ver_id, l_language, l_mime_type);
146: FETCH Get_File_Id INTO l_file_id;
147: -- check if default style sheet exists
148: IF Get_File_Id%NOTFOUND THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
151: FND_MESSAGE.Set_Token('INPUT', 'p_language/p_mime_type', FALSE);
152: FND_MSG_PUB.ADD;
153: CLOSE Get_File_id;

Line 154: RAISE FND_API.G_EXC_ERROR;

150: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
151: FND_MESSAGE.Set_Token('INPUT', 'p_language/p_mime_type', FALSE);
152: FND_MSG_PUB.ADD;
153: CLOSE Get_File_id;
154: RAISE FND_API.G_EXC_ERROR;
155: END IF;
156: CLOSE Get_File_Id;
157:
158: x_file_id := l_file_id;

Line 166: WHEN FND_API.G_EXC_ERROR THEN

162: -- Standard call to get message count and if count=1, get the message
163: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
164: p_data => x_msg_data);
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
169: p_data => x_msg_data);
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
164: p_data => x_msg_data);
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
169: p_data => x_msg_data);
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
169: p_data => x_msg_data);
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
173: p_data => x_msg_data);
174: WHEN OTHERS THEN

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
169: p_data => x_msg_data);
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
173: p_data => x_msg_data);
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
173: p_data => x_msg_data);
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
179: END IF;

Line 253: IF NOT FND_API.Compatible_API_Call (

249:
250: BEGIN
251: -- ******* Standard Begins ********
252: -- Standard call to check for call compatibility.
253: IF NOT FND_API.Compatible_API_Call (
254: l_api_version,
255: p_api_version,
256: l_api_name,
257: G_PKG_NAME)

Line 259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

255: p_api_version,
256: l_api_name,
257: G_PKG_NAME)
258: THEN
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: END IF;
261: -- Initialize message list if p_init_msg_list is set to TRUE.
262: IF FND_API.to_Boolean( p_init_msg_list )
263: THEN

Line 262: IF FND_API.to_Boolean( p_init_msg_list )

258: THEN
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: END IF;
261: -- Initialize message list if p_init_msg_list is set to TRUE.
262: IF FND_API.to_Boolean( p_init_msg_list )
263: THEN
264: FND_MSG_PUB.initialize;
265: END IF;
266:

Line 268: x_return_status := FND_API.G_RET_STS_SUCCESS;

264: FND_MSG_PUB.initialize;
265: END IF;
266:
267: -- Initialize API return status to success
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269: --******************* Real Logic Start *********************
270:
271: IF p_user_id IS NOT NULL THEN
272: l_user_id := p_user_id;

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

279: IF p_directory_node_id IS NOT NULL THEN
280: OPEN c_dirpath(p_directory_node_id);
281: FETCH c_dirpath INTO l_dirpath;
282: IF c_dirpath%NOTFOUND THEN
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
285: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);
286: FND_MSG_PUB.ADD;
287: RAISE FND_API.G_EXC_ERROR;

Line 287: RAISE FND_API.G_EXC_ERROR;

283: x_return_status := FND_API.G_RET_STS_ERROR;
284: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
285: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);
286: FND_MSG_PUB.ADD;
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289: CLOSE c_dirpath;
290: ELSE
291: l_dirpath := p_path_pattern;

Line 294: IF p_include_subdirs = FND_API.g_true THEN

290: ELSE
291: l_dirpath := p_path_pattern;
292: END IF;
293:
294: IF p_include_subdirs = FND_API.g_true THEN
295: l_dirpath := l_dirpath || '%';
296: END IF;
297:
298: l_count := 0;

Line 327: WHEN FND_API.G_EXC_ERROR THEN

323: -- Standard call to get message count and if count=1, get the message
324: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
325: p_data => x_msg_data);
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
330: p_data => x_msg_data);
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

324: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
325: p_data => x_msg_data);
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
330: p_data => x_msg_data);
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
330: p_data => x_msg_data);
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
334: p_data => x_msg_data);
335: WHEN OTHERS THEN

Line 332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
330: p_data => x_msg_data);
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
334: p_data => x_msg_data);
335: WHEN OTHERS THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
334: p_data => x_msg_data);
335: WHEN OTHERS THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
338: THEN
339: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
340: END IF;

Line 351: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false,

347: --
348: -- --------------------------------------------------------------
349: PROCEDURE Get_Citem_Stylesheets (
350: p_api_version IN NUMBER DEFAULT 1.0,
351: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false,
352: p_content_item_id IN NUMBER,
353: p_language IN VARCHAR2 DEFAULT NULL,
354: x_citem_ids OUT NOCOPY JTF_NUMBER_TABLE,
355: x_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 396: IF NOT FND_API.Compatible_API_Call (

392:
393: BEGIN
394: -- ******* Standard Begins ********
395: -- Standard call to check for call compatibility.
396: IF NOT FND_API.Compatible_API_Call (
397: l_api_version,
398: p_api_version,
399: l_api_name,
400: G_PKG_NAME)

Line 402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

398: p_api_version,
399: l_api_name,
400: G_PKG_NAME)
401: THEN
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;
404: -- Initialize message list if p_init_msg_list is set to TRUE.
405: IF FND_API.to_Boolean( p_init_msg_list )
406: THEN

Line 405: IF FND_API.to_Boolean( p_init_msg_list )

401: THEN
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;
404: -- Initialize message list if p_init_msg_list is set to TRUE.
405: IF FND_API.to_Boolean( p_init_msg_list )
406: THEN
407: FND_MSG_PUB.initialize;
408: END IF;
409:

Line 411: x_return_status := FND_API.G_RET_STS_SUCCESS;

407: FND_MSG_PUB.initialize;
408: END IF;
409:
410: -- Initialize API return status to success
411: x_return_status := FND_API.G_RET_STS_SUCCESS;
412: --******************* Real Logic Start *********************
413:
414: l_count := 0;
415: FOR r_items IN c_items(p_content_item_id)

Line 439: WHEN FND_API.G_EXC_ERROR THEN

435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
437: p_data => x_msg_data);
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
442: p_data => x_msg_data);
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

436: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
437: p_data => x_msg_data);
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
442: p_data => x_msg_data);
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
442: p_data => x_msg_data);
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
446: p_data => x_msg_data);
447: WHEN OTHERS THEN

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

440: x_return_status := FND_API.G_RET_STS_ERROR;
441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
442: p_data => x_msg_data);
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
446: p_data => x_msg_data);
447: WHEN OTHERS THEN
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
446: p_data => x_msg_data);
447: WHEN OTHERS THEN
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
452: END IF;