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

Line 17: -- Default = FND_API.G_FALSE

13: -- Parameters :
14: -- IN :
15: -- p_api_version IN NUMBER Required
16: -- p_init_msg_list IN VARCHAR2 Optional
17: -- Default = FND_API.G_FALSE
18: -- p_commit IN VARCHAR2 Optional
19: -- Default = FND_API.G_FALSE
20: -- p_validation_level IN NUMBER Optional
21: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 19: -- Default = FND_API.G_FALSE

15: -- p_api_version IN NUMBER Required
16: -- p_init_msg_list IN VARCHAR2 Optional
17: -- Default = FND_API.G_FALSE
18: -- p_commit IN VARCHAR2 Optional
19: -- Default = FND_API.G_FALSE
20: -- p_validation_level IN NUMBER Optional
21: -- Default = FND_API.G_VALID_LEVEL_FULL
22: -- p_item_id IN NUMBER Required
23: -- p_organization_id IN NUMBER Required

Line 21: -- Default = FND_API.G_VALID_LEVEL_FULL

17: -- Default = FND_API.G_FALSE
18: -- p_commit IN VARCHAR2 Optional
19: -- Default = FND_API.G_FALSE
20: -- p_validation_level IN NUMBER Optional
21: -- Default = FND_API.G_VALID_LEVEL_FULL
22: -- p_item_id IN NUMBER Required
23: -- p_organization_id IN NUMBER Required
24: -- p_cost_source IN NUMBER Required
25: -- 1 - Return item cost from valuation cost type.

Line 64: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

60: ) IS
61: l_api_name CONSTANT VARCHAR2(30) := 'Get_ItemCost';
62: l_api_version CONSTANT NUMBER := 1.0;
63:
64: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
65: l_msg_count NUMBER := 0;
66: l_msg_data VARCHAR2(8000) := '';
67: l_stmt_num NUMBER := 0;
68: l_api_message VARCHAR2(1000);

Line 89: IF NOT FND_API.Compatible_API_Call (

85: ,'Get_ItemCost <<');
86: END IF;
87:
88: -- Standard call to check for call compatibility
89: IF NOT FND_API.Compatible_API_Call (
90: l_api_version,
91: p_api_version,
92: l_api_name,
93: G_PKG_NAME ) THEN

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90: l_api_version,
91: p_api_version,
92: l_api_name,
93: G_PKG_NAME ) THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: -- Initialize message list if p_init_msg_list is set to TRUE
98: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 98: IF FND_API.to_Boolean(p_init_msg_list) THEN

94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: -- Initialize message list if p_init_msg_list is set to TRUE
98: IF FND_API.to_Boolean(p_init_msg_list) THEN
99: FND_MSG_PUB.initialize;
100: END IF;
101:
102: -- Initialize API return status to success

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;

99: FND_MSG_PUB.initialize;
100: END IF;
101:
102: -- Initialize API return status to success
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104:
105: -- Check the value passed in p_cost_type_id
106: -- If it's 0, then fetch the cost_type_id for the valuation cost type
107: l_cost_type_id := p_cost_type_id;

Line 159: raise FND_API.g_exc_unexpected_error;

155: order by transaction_id desc)
156: where rownum <= CST_ItemResourceCosts_GRP.LAST_N_PO_RECEIPTS);
157:
158: else
159: raise FND_API.g_exc_unexpected_error;
160: end if;
161:
162: -- Also return the currency_code
163: l_stmt_num := 50;

Line 170: IF FND_API.to_Boolean(p_commit) THEN

166: from cst_organization_definitions
167: where organization_id = p_organization_id;
168:
169: --- Standard check of p_commit
170: IF FND_API.to_Boolean(p_commit) THEN
171: COMMIT WORK;
172: END IF;
173:
174: -- Standard Call to get message count and if count = 1, get message info

Line 185: WHEN FND_API.g_exc_error THEN

181: ,'Get_ItemCost >>');
182: END IF;
183:
184: EXCEPTION
185: WHEN FND_API.g_exc_error THEN
186: ROLLBACK TO Get_ItemCost_PVT;
187: x_return_status := FND_API.g_ret_sts_error;
188: FND_MSG_PUB.count_and_get
189: ( p_count => x_msg_count

Line 187: x_return_status := FND_API.g_ret_sts_error;

183:
184: EXCEPTION
185: WHEN FND_API.g_exc_error THEN
186: ROLLBACK TO Get_ItemCost_PVT;
187: x_return_status := FND_API.g_ret_sts_error;
188: FND_MSG_PUB.count_and_get
189: ( p_count => x_msg_count
190: , p_data => x_msg_data
191: );

Line 193: WHEN FND_API.g_exc_unexpected_error THEN

189: ( p_count => x_msg_count
190: , p_data => x_msg_data
191: );
192:
193: WHEN FND_API.g_exc_unexpected_error THEN
194: ROLLBACK TO Get_ItemCost_PVT;
195: x_return_status := FND_API.g_ret_sts_unexp_error ;
196: FND_MSG_PUB.count_and_get
197: ( p_count => x_msg_count

Line 195: x_return_status := FND_API.g_ret_sts_unexp_error ;

191: );
192:
193: WHEN FND_API.g_exc_unexpected_error THEN
194: ROLLBACK TO Get_ItemCost_PVT;
195: x_return_status := FND_API.g_ret_sts_unexp_error ;
196: FND_MSG_PUB.count_and_get
197: ( p_count => x_msg_count
198: , p_data => x_msg_data
199: );

Line 203: x_return_status := FND_API.g_ret_sts_error;

199: );
200:
201: WHEN NO_DATA_FOUND THEN
202: ROLLBACK TO Get_ItemCost_PVT;
203: x_return_status := FND_API.g_ret_sts_error;
204: if (l_stmt_num = 20) then
205: l_api_message := 'No item cost exists for the provided cost type, organization, and item.';
206: elsif (l_stmt_num = 30) then
207: l_api_message := 'No list price is defined in the item definition for this item and organization.';

Line 222: x_return_status := fnd_api.g_ret_sts_unexp_error ;

218: x_msg_data := l_api_message;
219:
220: WHEN OTHERS THEN
221: ROLLBACK TO Get_ItemCost_PVT;
222: x_return_status := fnd_api.g_ret_sts_unexp_error ;
223:
224: IF l_unexpLog THEN
225: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
226: ,'Get_ItemCost '||l_stmt_num||' : '||substr(SQLERRM,1,200));

Line 244: -- Default = FND_API.G_FALSE

240: -- Parameters :
241: -- IN :
242: -- p_api_version IN NUMBER Required
243: -- p_init_msg_list IN VARCHAR2 Optional
244: -- Default = FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Optional
246: -- Default = FND_API.G_FALSE
247: -- p_validation_level IN NUMBER Optional
248: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 246: -- Default = FND_API.G_FALSE

242: -- p_api_version IN NUMBER Required
243: -- p_init_msg_list IN VARCHAR2 Optional
244: -- Default = FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Optional
246: -- Default = FND_API.G_FALSE
247: -- p_validation_level IN NUMBER Optional
248: -- Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_resource_id IN NUMBER Required
250: -- p_organization_id IN NUMBER Required

Line 248: -- Default = FND_API.G_VALID_LEVEL_FULL

244: -- Default = FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Optional
246: -- Default = FND_API.G_FALSE
247: -- p_validation_level IN NUMBER Optional
248: -- Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_resource_id IN NUMBER Required
250: -- p_organization_id IN NUMBER Required
251: -- p_cost_type_id IN NUMBER Optional
252: -- Default = 0 -> will then default to AvgRates

Line 283: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

279: ) IS
280: l_api_name CONSTANT VARCHAR2(30) := 'Get_ResourceRate';
281: l_api_version CONSTANT NUMBER := 1.0;
282:
283: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
284: l_msg_count NUMBER := 0;
285: l_msg_data VARCHAR2(8000) := '';
286: l_stmt_num NUMBER := 0;
287: l_api_message VARCHAR2(1000);

Line 308: IF NOT FND_API.Compatible_API_Call (

304: ,'Get_ResourceRate <<');
305: END IF;
306:
307: -- Standard call to check for call compatibility
308: IF NOT FND_API.Compatible_API_Call (
309: l_api_version,
310: p_api_version,
311: l_api_name,
312: G_PKG_NAME ) THEN

Line 313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

309: l_api_version,
310: p_api_version,
311: l_api_name,
312: G_PKG_NAME ) THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315:
316: -- Initialize message list if p_init_msg_list is set to TRUE
317: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 317: IF FND_API.to_Boolean(p_init_msg_list) THEN

313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315:
316: -- Initialize message list if p_init_msg_list is set to TRUE
317: IF FND_API.to_Boolean(p_init_msg_list) THEN
318: FND_MSG_PUB.initialize;
319: END IF;
320:
321: -- Initialize API return status to success

Line 322: x_return_status := FND_API.G_RET_STS_SUCCESS;

318: FND_MSG_PUB.initialize;
319: END IF;
320:
321: -- Initialize API return status to success
322: x_return_status := FND_API.G_RET_STS_SUCCESS;
323:
324: l_stmt_num := 10;
325:
326: l_cost_type_id := p_cost_type_id;

Line 354: IF FND_API.to_Boolean(p_commit) THEN

350: from cst_organization_definitions
351: where organization_id = p_organization_id;
352:
353: --- Standard check of p_commit
354: IF FND_API.to_Boolean(p_commit) THEN
355: COMMIT WORK;
356: END IF;
357:
358: -- Standard Call to get message count and if count = 1, get message info

Line 369: WHEN FND_API.g_exc_error THEN

365: ,'Get_ResourceRate >>');
366: END IF;
367:
368: EXCEPTION
369: WHEN FND_API.g_exc_error THEN
370: ROLLBACK TO Get_ResourceRate_PVT;
371: x_return_status := FND_API.g_ret_sts_error;
372: FND_MSG_PUB.count_and_get
373: ( p_count => x_msg_count

Line 371: x_return_status := FND_API.g_ret_sts_error;

367:
368: EXCEPTION
369: WHEN FND_API.g_exc_error THEN
370: ROLLBACK TO Get_ResourceRate_PVT;
371: x_return_status := FND_API.g_ret_sts_error;
372: FND_MSG_PUB.count_and_get
373: ( p_count => x_msg_count
374: , p_data => x_msg_data
375: );

Line 376: WHEN FND_API.g_exc_unexpected_error THEN

372: FND_MSG_PUB.count_and_get
373: ( p_count => x_msg_count
374: , p_data => x_msg_data
375: );
376: WHEN FND_API.g_exc_unexpected_error THEN
377:
378: ROLLBACK TO Get_ResourceRate_PVT;
379: x_return_status := FND_API.g_ret_sts_unexp_error ;
380: FND_MSG_PUB.count_and_get

Line 379: x_return_status := FND_API.g_ret_sts_unexp_error ;

375: );
376: WHEN FND_API.g_exc_unexpected_error THEN
377:
378: ROLLBACK TO Get_ResourceRate_PVT;
379: x_return_status := FND_API.g_ret_sts_unexp_error ;
380: FND_MSG_PUB.count_and_get
381: ( p_count => x_msg_count
382: , p_data => x_msg_data
383: );

Line 387: x_return_status := FND_API.g_ret_sts_error;

383: );
384:
385: WHEN NO_DATA_FOUND THEN
386: ROLLBACK TO Get_ResourceRate_PVT;
387: x_return_status := FND_API.g_ret_sts_error;
388: if (l_stmt_num = 10) then
389: l_api_message := 'No AvgRates cost_type is setup in organization parameters, so no default cost type is available.';
390: elsif (l_stmt_num = 20) then
391: l_api_message := 'No resource rate is defined for the inputs provided.';

Line 404: x_return_status := fnd_api.g_ret_sts_unexp_error ;

400: x_msg_data := l_api_message;
401:
402: WHEN OTHERS THEN
403: ROLLBACK TO Get_ResourceRate_PVT;
404: x_return_status := fnd_api.g_ret_sts_unexp_error ;
405:
406: IF l_unexpLog THEN
407: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
408: ,'Get_ResourceRate '||l_stmt_num||' : '||substr(SQLERRM,1,200));