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

Line 15: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

11: -- 4. Translation of an item is updated
12: -- 5. An item is assigned to an org
13: PROCEDURE populateItemChange
14: ( p_api_version IN NUMBER ,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
17: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
18: x_return_status OUT NOCOPY VARCHAR2 ,
19: p_dml_type IN VARCHAR2 ,

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

12: -- 5. An item is assigned to an org
13: PROCEDURE populateItemChange
14: ( p_api_version IN NUMBER ,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
17: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
18: x_return_status OUT NOCOPY VARCHAR2 ,
19: p_dml_type IN VARCHAR2 ,
20: p_inventory_item_id IN NUMBER ,

Line 17: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,

13: PROCEDURE populateItemChange
14: ( p_api_version IN NUMBER ,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
17: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
18: x_return_status OUT NOCOPY VARCHAR2 ,
19: p_dml_type IN VARCHAR2 ,
20: p_inventory_item_id IN NUMBER ,
21: p_item_number IN VARCHAR2 ,

Line 37: x_return_status := FND_API.G_RET_STS_SUCCESS;

33: l_log_string VARCHAR2(2000);
34: l_tmp_count NUMBER := 0;
35: BEGIN
36: l_err_loc := 100;
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: l_err_loc := 200;
40: -- Standard Start of API savepoint
41: SAVEPOINT populateItemChange_sp;

Line 61: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

57: END IF;
58:
59: l_err_loc := 400;
60: -- Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
62: p_api_version ,
63: l_api_name ,
64: G_PKG_NAME )
65: THEN

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

63: l_api_name ,
64: G_PKG_NAME )
65: THEN
66: l_err_loc := 500;
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70: l_err_loc := 600;
71: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

Line 138: IF (FND_API.To_Boolean(P_COMMIT)) THEN

134: END IF;
135:
136: l_err_loc := 1000;
137: -- Standard check of P_COMMIT
138: IF (FND_API.To_Boolean(P_COMMIT)) THEN
139: l_err_loc := 1100;
140: COMMIT;
141: l_err_loc := 1200;
142: -- Call the rebuild index

Line 178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

174: || SQLERRM);
175: END IF;
176: NULL;
177: END;
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179: END populateItemChange;
180:
181: -- Called from inventory's item open interface (IOI) for the following actions:
182: -- 1. Create/Update an item P_ENTITY_TYPE = 'ITEM'

Line 189: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

185: -- 4. Create/Update/Delete of an items category assignment P_ENTITY_TYPE = 'ITEM_CATEGORY'
186: -- Join with MTL_ITEM_BULKLOAD_RECS to get the changed inventory_item_id and organization_id
187: PROCEDURE populateBulkItemChange
188: ( p_api_version IN NUMBER ,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
191: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
192: x_return_status OUT NOCOPY VARCHAR2 ,
193: p_request_id IN NUMBER ,

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

186: -- Join with MTL_ITEM_BULKLOAD_RECS to get the changed inventory_item_id and organization_id
187: PROCEDURE populateBulkItemChange
188: ( p_api_version IN NUMBER ,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
191: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
192: x_return_status OUT NOCOPY VARCHAR2 ,
193: p_request_id IN NUMBER ,
194: p_entity_type IN VARCHAR2

Line 191: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,

187: PROCEDURE populateBulkItemChange
188: ( p_api_version IN NUMBER ,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
191: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
192: x_return_status OUT NOCOPY VARCHAR2 ,
193: p_request_id IN NUMBER ,
194: p_entity_type IN VARCHAR2
195: )

Line 205: x_return_status := FND_API.G_RET_STS_SUCCESS;

201: l_end_date DATE;
202: l_log_string VARCHAR2(2000);
203: BEGIN
204: l_err_loc := 100;
205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:
207: l_err_loc := 200;
208: -- Standard Start of API savepoint
209: SAVEPOINT populateBulkItemChange_sp;

Line 225: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

221: END IF;
222:
223: l_err_loc := 400;
224: -- Standard call to check for call compatibility.
225: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
226: p_api_version ,
227: l_api_name ,
228: G_PKG_NAME )
229: THEN

Line 231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

227: l_api_name ,
228: G_PKG_NAME )
229: THEN
230: l_err_loc := 500;
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234: l_err_loc := 600;
235: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

Line 269: IF (FND_API.To_Boolean(P_COMMIT)) THEN

265: END IF;
266:
267: l_err_loc := 1100;
268: -- Standard check of P_COMMIT
269: IF (FND_API.To_Boolean(P_COMMIT)) THEN
270: l_err_loc := 1200;
271: COMMIT;
272: l_err_loc := 1300;
273: -- Call the rebuild index

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

305: || SQLERRM);
306: END IF;
307: NULL;
308: END;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: END populateBulkItemChange;
311:
312: -- Called from inventory forms / HTML interface for the following actions:
313: -- 1. Item category assignment is created

Line 318: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

314: -- 2. Item category assignment is updated
315: -- 3. Item category assignment is deleted
316: PROCEDURE populateItemCategoryChange
317: ( p_api_version IN NUMBER ,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
319: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
320: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
321: x_return_status OUT NOCOPY VARCHAR2 ,
322: p_dml_type IN VARCHAR2 ,

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

315: -- 3. Item category assignment is deleted
316: PROCEDURE populateItemCategoryChange
317: ( p_api_version IN NUMBER ,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
319: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
320: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
321: x_return_status OUT NOCOPY VARCHAR2 ,
322: p_dml_type IN VARCHAR2 ,
323: p_inventory_item_id IN NUMBER ,

Line 320: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,

316: PROCEDURE populateItemCategoryChange
317: ( p_api_version IN NUMBER ,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
319: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
320: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
321: x_return_status OUT NOCOPY VARCHAR2 ,
322: p_dml_type IN VARCHAR2 ,
323: p_inventory_item_id IN NUMBER ,
324: p_item_number IN VARCHAR2 ,

Line 339: x_return_status := FND_API.G_RET_STS_SUCCESS;

335: l_end_date DATE;
336: l_log_string VARCHAR2(2000);
337: BEGIN
338: l_err_loc := 100;
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340:
341: l_err_loc := 200;
342: -- Standard Start of API savepoint
343: SAVEPOINT populateItemCategoryChange_sp;

Line 364: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

360: END IF;
361:
362: l_err_loc := 400;
363: -- Standard call to check for call compatibility.
364: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
365: p_api_version ,
366: l_api_name ,
367: G_PKG_NAME )
368: THEN

Line 370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

366: l_api_name ,
367: G_PKG_NAME )
368: THEN
369: l_err_loc := 500;
370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
371: END IF;
372:
373: l_err_loc := 600;
374: --Initialize the purchasing category set info.

Line 404: IF (FND_API.To_Boolean(P_COMMIT)) THEN

400: END IF;
401:
402: l_err_loc := 1200;
403: -- Standard check of P_COMMIT
404: IF (FND_API.To_Boolean(P_COMMIT)) THEN
405: l_err_loc := 1300;
406: COMMIT;
407: l_err_loc := 1400;
408: -- Call the rebuild index

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

440: || SQLERRM);
441: END IF;
442: NULL;
443: END;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: END populateItemCategoryChange;
446:
447: END ICX_CAT_POPULATE_MI_GRP;