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

Line 56: IF NOT FND_API.Compatible_API_Call

52: -- Standard Start of API savepoint
53: SAVEPOINT Calculate_InventoryValue_PUB;
54:
55: -- Check for call compatibility
56: IF NOT FND_API.Compatible_API_Call
57: ( p_current_version_number => l_api_version,
58: p_caller_version_number => p_api_version,
59: p_api_name => l_api_name,
60: p_pkg_name => G_PKG_NAME

Line 63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

59: p_api_name => l_api_name,
60: p_pkg_name => G_PKG_NAME
61: )
62: THEN
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
65:
66: -- Initialize API message list if necessary
67: IF FND_API.To_Boolean(p_init_msg_list)

Line 67: IF FND_API.To_Boolean(p_init_msg_list)

63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
65:
66: -- Initialize API message list if necessary
67: IF FND_API.To_Boolean(p_init_msg_list)
68: THEN
69: FND_MSG_PUB.Initialize;
70: END IF;
71:

Line 77: IF NOT FND_API.To_Boolean(p_commit)

73: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
74: x_msg_count := l_msg_level_threshold;
75:
76: -- Check for the value of p_commit
77: IF NOT FND_API.To_Boolean(p_commit)
78: THEN
79: FND_MSG_PUB.Add_Exc_Msg(
80: p_pkg_name => G_PKG_NAME,
81: p_procedure_name => l_api_name,

Line 84: RAISE FND_API.G_EXC_ERROR;

80: p_pkg_name => G_PKG_NAME,
81: p_procedure_name => l_api_name,
82: p_error_text => 'This API should not be called with p_commit set to false'
83: );
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86:
87: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
88: THEN

Line 144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

140: p_one_time_item => p_one_time_item,
141: x_return_status => x_return_status
142: );
143:
144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
145: THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: );
143:
144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
145: THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:
149: -- Find the cost groups that match the specifications
150: l_stmt_num := 20;

Line 160: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

156: p_own => p_own,
157: x_return_status => x_return_status
158: );
159:
160: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
161: THEN
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164:

Line 162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

158: );
159:
160: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
161: THEN
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164:
165: -- Find the subinventories that match the specifications
166: l_stmt_num := 30;

Line 176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

172: p_expense_sub => p_expense_sub,
173: x_return_status => x_return_status
174: );
175:
176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
177: THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: END IF;
180:

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174: );
175:
176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
177: THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: END IF;
180:
181: l_stmt_num := 32;
182: l_gather_stats := CST_Utility_PUB.check_Db_Version(

Line 188: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

184: x_return_status => x_return_status,
185: x_msg_count => x_msg_count,
186: x_msg_data => x_msg_data
187: );
188: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
189: THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186: x_msg_data => x_msg_data
187: );
188: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
189: THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193: IF l_gather_stats = 1
194: THEN

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194: THEN
195: l_stmt_num := 35;
196: IF NOT FND_INSTALLATION.GET_APP_INFO('BOM', l_status, l_industry, l_schema)
197: THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
201: IF l_schema IS NOT NULL
202: THEN

Line 229: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

225: p_unvalued_txns => p_unvalued_txns,
226: x_return_status => x_return_status
227: );
228:
229: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
230: THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233: END IF;

Line 231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

227: );
228:
229: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
230: THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233: END IF;
234:
235: -- Calculate the intransit quantity of matching items in the cost groups

Line 251: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

247: p_unvalued_txns => p_unvalued_txns,
248: x_return_status => x_return_status
249: );
250:
251: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
252: THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255: END IF;

Line 253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249: );
250:
251: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
252: THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255: END IF;
256:
257: -- Calculate the receiving quantity of matching items

Line 270: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

266: p_include_period_end => p_include_period_end,
267: x_return_status => x_return_status
268: );
269:
270: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
271: THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: END IF;

Line 272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

268: );
269:
270: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
271: THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: END IF;
275:
276: -- Gather statistics on the global temporary table

Line 288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

284: x_return_status => x_return_status,
285: x_msg_count => x_msg_count,
286: x_msg_data => x_msg_data
287: );
288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
289: THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:

Line 290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

286: x_msg_data => x_msg_data
287: );
288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
289: THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
293: IF l_gather_stats = 1
294: THEN

Line 298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

294: THEN
295: l_stmt_num := 63;
296: IF NOT FND_INSTALLATION.GET_APP_INFO('BOM', l_status, l_industry, l_schema)
297: THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301: IF l_schema IS NOT NULL
302: THEN

Line 320: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

316: p_organization_id => p_organization_id,
317: x_return_status => x_return_status
318: );
319:
320: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
321: THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:

Line 322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

318: );
319:
320: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
321: THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: IF l_gather_stats = 1
326: THEN

Line 345: WHEN FND_API.G_EXC_ERROR THEN

341: );
342: END IF;
343:
344: EXCEPTION
345: WHEN FND_API.G_EXC_ERROR THEN
346: ROLLBACK TO Calculate_InventoryValue_PUB;
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: ROLLBACK TO Calculate_InventoryValue_PUB;

Line 347: x_return_status := FND_API.G_RET_STS_ERROR;

343:
344: EXCEPTION
345: WHEN FND_API.G_EXC_ERROR THEN
346: ROLLBACK TO Calculate_InventoryValue_PUB;
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: ROLLBACK TO Calculate_InventoryValue_PUB;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: WHEN OTHERS THEN

Line 348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

344: EXCEPTION
345: WHEN FND_API.G_EXC_ERROR THEN
346: ROLLBACK TO Calculate_InventoryValue_PUB;
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: ROLLBACK TO Calculate_InventoryValue_PUB;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: WHEN OTHERS THEN
352: ROLLBACK TO Calculate_InventoryValue_PUB;

Line 350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

346: ROLLBACK TO Calculate_InventoryValue_PUB;
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: ROLLBACK TO Calculate_InventoryValue_PUB;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: WHEN OTHERS THEN
352: ROLLBACK TO Calculate_InventoryValue_PUB;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

349: ROLLBACK TO Calculate_InventoryValue_PUB;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: WHEN OTHERS THEN
352: ROLLBACK TO Calculate_InventoryValue_PUB;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
355: THEN
356: FND_MSG_PUB.Add_Exc_Msg(
357: p_pkg_name => G_PKG_NAME,