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

Line 19: -- Default = FND_API.G_FALSE

15: -- Parameters :
16: --
17: -- IN : p_api_version IN NUMBER Required
18: -- p_init_msg_list IN VARCHAR2 Optional
19: -- Default = FND_API.G_FALSE
20: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
21: -- x_msg_count OUT NOCOPY NUMBER
22: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
23: -- x_section_id_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE

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

33: --
34: -- End of comments
35: procedure Get_Preload_Section_Ids
36: (p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41:

Line 54: IF NOT FND_API.Compatible_API_Call (l_api_version,

50: BEGIN
51: --gzhang 08/08/2002, bug#2488246
52: --ibe_util.enable_debug;
53: -- standard call to check for call compatibility
54: IF NOT FND_API.Compatible_API_Call (l_api_version,
55: p_api_version,
56: l_api_name,
57: G_PKG_NAME )
58: THEN

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: p_api_version,
56: l_api_name,
57: G_PKG_NAME )
58: THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: -- initialize message list if p_init_msg_list is set to TRUE
63: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 63: IF FND_API.to_Boolean(p_init_msg_list) THEN

59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: -- initialize message list if p_init_msg_list is set to TRUE
63: IF FND_API.to_Boolean(p_init_msg_list) THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:
67: -- initialize API return status to success

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: FND_MSG_PUB.initialize;
65: END IF;
66:
67: -- initialize API return status to success
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
71: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(+)');
72: END IF;

Line 70: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

66:
67: -- initialize API return status to success
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
71: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(+)');
72: END IF;
73: -- begin API body
74:

Line 81: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

77: FROM IBE_DSP_SECTIONS_B s
78: WHERE sysdate between s.start_date_active and nvl(s.end_date_active,sysdate);
79:
80: -- end API body
81: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
82: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(-)');
83: END IF;
84:
85: -- standard call to get message count and if count is 1, get message info.

Line 87: ( p_encoded => FND_API.G_FALSE,

83: END IF;
84:
85: -- standard call to get message count and if count is 1, get message info.
86: FND_MSG_PUB.Count_And_Get
87: ( p_encoded => FND_API.G_FALSE,
88: p_count => x_msg_count,
89: p_data => x_msg_data
90: );
91: --gzhang 08/08/2002, bug#2488246

Line 94: WHEN FND_API.G_EXC_ERROR THEN

90: );
91: --gzhang 08/08/2002, bug#2488246
92: --ibe_util.disable_debug;
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: FND_MSG_PUB.Count_And_Get
97: ( p_encoded => FND_API.G_FALSE,
98: p_count => x_msg_count,

Line 95: x_return_status := FND_API.G_RET_STS_ERROR;

91: --gzhang 08/08/2002, bug#2488246
92: --ibe_util.disable_debug;
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: FND_MSG_PUB.Count_And_Get
97: ( p_encoded => FND_API.G_FALSE,
98: p_count => x_msg_count,
99: p_data => x_msg_data

Line 97: ( p_encoded => FND_API.G_FALSE,

93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: FND_MSG_PUB.Count_And_Get
97: ( p_encoded => FND_API.G_FALSE,
98: p_count => x_msg_count,
99: p_data => x_msg_data
100: );
101: --gzhang 08/08/2002, bug#2488246

Line 103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

99: p_data => x_msg_data
100: );
101: --gzhang 08/08/2002, bug#2488246
102: --ibe_util.disable_debug;
103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: FND_MSG_PUB.Count_And_Get
106: ( p_encoded => FND_API.G_FALSE,
107: p_count => x_msg_count,

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

100: );
101: --gzhang 08/08/2002, bug#2488246
102: --ibe_util.disable_debug;
103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: FND_MSG_PUB.Count_And_Get
106: ( p_encoded => FND_API.G_FALSE,
107: p_count => x_msg_count,
108: p_data => x_msg_data

Line 106: ( p_encoded => FND_API.G_FALSE,

102: --ibe_util.disable_debug;
103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: FND_MSG_PUB.Count_And_Get
106: ( p_encoded => FND_API.G_FALSE,
107: p_count => x_msg_count,
108: p_data => x_msg_data
109: );
110: --gzhang 08/08/2002, bug#2488246

Line 113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

109: );
110: --gzhang 08/08/2002, bug#2488246
111: --ibe_util.disable_debug;
112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
115: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || '4');
116: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
117: FND_MESSAGE.Set_Token('REASON', SQLERRM);

Line 127: ( p_encoded => FND_API.G_FALSE,

123: l_api_name
124: );
125: END IF;
126: FND_MSG_PUB.Count_And_Get
127: ( p_encoded => FND_API.G_FALSE,
128: p_count => x_msg_count,
129: p_data => x_msg_data
130: );
131: --gzhang 08/08/2002, bug#2488246

Line 151: -- Default = FND_API.G_FALSE

147: -- Parameters :
148: --
149: -- IN : p_api_version IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional
151: -- Default = FND_API.G_FALSE
152: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
153: -- x_msg_count OUT NOCOPY NUMBER
154: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
155: -- x_item_id_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE

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

165: --
166: -- End of comments
167: procedure Get_Preload_Item_Ids
168: (p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173:

Line 184: IF NOT FND_API.Compatible_API_Call (l_api_version,

180: BEGIN
181: --gzhang 08/08/2002, bug#2488246
182: --ibe_util.enable_debug;
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 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: p_api_version,
186: l_api_name,
187: G_PKG_NAME )
188: THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: -- initialize message list if p_init_msg_list is set to TRUE
193: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 193: IF FND_API.to_Boolean(p_init_msg_list) THEN

189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: -- initialize message list if p_init_msg_list is set to TRUE
193: IF FND_API.to_Boolean(p_init_msg_list) THEN
194: FND_MSG_PUB.initialize;
195: END IF;
196:
197: -- initialize API return status to success

Line 198: x_return_status := FND_API.G_RET_STS_SUCCESS;

194: FND_MSG_PUB.initialize;
195: END IF;
196:
197: -- initialize API return status to success
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199:
200: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(+)');
201: -- begin API body
202: OPEN x_item_id_csr FOR

Line 215: ( p_encoded => FND_API.G_FALSE,

211: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(-)');
212:
213: -- standard call to get message count and if count is 1, get message info.
214: FND_MSG_PUB.Count_And_Get
215: ( p_encoded => FND_API.G_FALSE,
216: p_count => x_msg_count,
217: p_data => x_msg_data
218: );
219: --gzhang 08/08/2002, bug#2488246

Line 222: WHEN FND_API.G_EXC_ERROR THEN

218: );
219: --gzhang 08/08/2002, bug#2488246
220: --ibe_util.disable_debug;
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: FND_MSG_PUB.Count_And_Get
225: ( p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,

Line 223: x_return_status := FND_API.G_RET_STS_ERROR;

219: --gzhang 08/08/2002, bug#2488246
220: --ibe_util.disable_debug;
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: FND_MSG_PUB.Count_And_Get
225: ( p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data

Line 225: ( p_encoded => FND_API.G_FALSE,

221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: FND_MSG_PUB.Count_And_Get
225: ( p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data
228: );
229: --gzhang 08/08/2002, bug#2488246

Line 231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

227: p_data => x_msg_data
228: );
229: --gzhang 08/08/2002, bug#2488246
230: --ibe_util.disable_debug;
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Count_And_Get
234: ( p_encoded => FND_API.G_FALSE,
235: p_count => x_msg_count,

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: );
229: --gzhang 08/08/2002, bug#2488246
230: --ibe_util.disable_debug;
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Count_And_Get
234: ( p_encoded => FND_API.G_FALSE,
235: p_count => x_msg_count,
236: p_data => x_msg_data

Line 234: ( p_encoded => FND_API.G_FALSE,

230: --ibe_util.disable_debug;
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Count_And_Get
234: ( p_encoded => FND_API.G_FALSE,
235: p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238: --gzhang 08/08/2002, bug#2488246

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

237: );
238: --gzhang 08/08/2002, bug#2488246
239: --ibe_util.disable_debug;
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
243: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
244: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
245: FND_MESSAGE.Set_Token('REASON', SQLERRM);

Line 255: ( p_encoded => FND_API.G_FALSE,

251: l_api_name
252: );
253: END IF;
254: FND_MSG_PUB.Count_And_Get
255: ( p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data
258: );
259: --gzhang 08/08/2002, bug#2488246