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

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

12: -- 1. Deleting a category is not allowed from category forms / html interface
13: -- 2. No bulk operations (i.e loading data from an interface table) are allowed on category
14: PROCEDURE populateCategoryChange
15: ( p_api_version IN NUMBER ,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
18: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
19: x_return_status OUT NOCOPY VARCHAR2 ,
20: p_dml_type IN VARCHAR2 ,

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

13: -- 2. No bulk operations (i.e loading data from an interface table) are allowed on category
14: PROCEDURE populateCategoryChange
15: ( p_api_version IN NUMBER ,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
18: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
19: x_return_status OUT NOCOPY VARCHAR2 ,
20: p_dml_type IN VARCHAR2 ,
21: p_structure_id IN NUMBER ,

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

14: PROCEDURE populateCategoryChange
15: ( p_api_version IN NUMBER ,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
18: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
19: x_return_status OUT NOCOPY VARCHAR2 ,
20: p_dml_type IN VARCHAR2 ,
21: p_structure_id IN NUMBER ,
22: p_category_name IN VARCHAR2 ,

Line 34: x_return_status := FND_API.G_RET_STS_SUCCESS;

30: l_end_date DATE;
31: l_log_string VARCHAR2(2000);
32: BEGIN
33: l_err_loc := 100;
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: l_err_loc := 200;
37: -- Standard Start of API savepoint
38: SAVEPOINT populateCategoryChange_sp;

Line 56: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

52: END IF;
53:
54: l_err_loc := 400;
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
57: p_api_version ,
58: l_api_name ,
59: G_PKG_NAME )
60: THEN

Line 62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

58: l_api_name ,
59: G_PKG_NAME )
60: THEN
61: l_err_loc := 500;
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: l_err_loc := 600;
66: --Initialize the purchasing category set info.

Line 97: IF FND_API.To_Boolean( p_commit ) THEN

93: ICX_CAT_POPULATE_CATG_PVT.populateCategoryChange(P_CATEGORY_NAME, P_CATEGORY_ID);
94:
95: l_err_loc := 1100;
96: -- Standard check of p_commit
97: IF FND_API.To_Boolean( p_commit ) THEN
98: l_err_loc := 1200;
99: COMMIT;
100: l_err_loc := 1300;
101: -- Call the rebuild index

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133: || SQLERRM);
134: END IF;
135: NULL;
136: END;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: END populateCategoryChange;
139:
140: -- Called from inventory category forms / html interface for the following actions:
141: -- 1. A category is added to valid cat sets

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

142: -- Note: These informations are provided by Inventory team in 2005
143: -- 1. No bulk operations (i.e loading data from an interface table) allowed on valid cat sets
144: PROCEDURE populateValidCategorySetInsert
145: ( p_api_version IN NUMBER ,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
148: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
149: x_return_status OUT NOCOPY VARCHAR2 ,
150: p_category_set_id IN NUMBER ,

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

143: -- 1. No bulk operations (i.e loading data from an interface table) allowed on valid cat sets
144: PROCEDURE populateValidCategorySetInsert
145: ( p_api_version IN NUMBER ,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
148: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
149: x_return_status OUT NOCOPY VARCHAR2 ,
150: p_category_set_id IN NUMBER ,
151: p_category_id IN NUMBER

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

144: PROCEDURE populateValidCategorySetInsert
145: ( p_api_version IN NUMBER ,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
148: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
149: x_return_status OUT NOCOPY VARCHAR2 ,
150: p_category_set_id IN NUMBER ,
151: p_category_id IN NUMBER
152: )

Line 162: x_return_status := FND_API.G_RET_STS_SUCCESS;

158: l_end_date DATE;
159: l_log_string VARCHAR2(2000);
160: BEGIN
161: l_err_loc := 100;
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:
164: l_err_loc := 200;
165: -- Standard Start of API savepoint
166: SAVEPOINT popValidCatgSetInsert_sp;

Line 182: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

178: END IF;
179:
180: l_err_loc := 400;
181: -- Standard call to check for call compatibility.
182: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
183: p_api_version ,
184: l_api_name ,
185: G_PKG_NAME )
186: THEN

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

184: l_api_name ,
185: G_PKG_NAME )
186: THEN
187: l_err_loc := 500;
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: END IF;
190:
191: l_err_loc := 600;
192: --Initialize the purchasing category set info.

Line 217: IF FND_API.To_Boolean( p_commit ) THEN

213: ICX_CAT_POPULATE_CATG_PVT.populateValidCategorySetInsert(P_CATEGORY_ID);
214:
215: l_err_loc := 1100;
216: -- Standard check of p_commit
217: IF FND_API.To_Boolean( p_commit ) THEN
218: l_err_loc := 1200;
219: COMMIT;
220: l_err_loc := 1300;
221: -- Call the rebuild index

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253: || SQLERRM);
254: END IF;
255: NULL;
256: END;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: END populateValidCategorySetInsert;
259:
260: -- Called from inventory category forms / html interface for the following actions:
261: -- 1. A category is updated in valid cat sets

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

262: -- Note: These informations are provided by Inventory team in 2005
263: -- 1. No bulk operations (i.e loading data from an interface table) allowed on valid cat sets
264: PROCEDURE populateValidCategorySetUpdate
265: ( p_api_version IN NUMBER ,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
268: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
269: x_return_status OUT NOCOPY VARCHAR2 ,
270: p_category_set_id IN NUMBER ,

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

263: -- 1. No bulk operations (i.e loading data from an interface table) allowed on valid cat sets
264: PROCEDURE populateValidCategorySetUpdate
265: ( p_api_version IN NUMBER ,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
268: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
269: x_return_status OUT NOCOPY VARCHAR2 ,
270: p_category_set_id IN NUMBER ,
271: p_old_category_id IN NUMBER ,

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

264: PROCEDURE populateValidCategorySetUpdate
265: ( p_api_version IN NUMBER ,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
268: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
269: x_return_status OUT NOCOPY VARCHAR2 ,
270: p_category_set_id IN NUMBER ,
271: p_old_category_id IN NUMBER ,
272: p_new_category_id IN NUMBER

Line 283: x_return_status := FND_API.G_RET_STS_SUCCESS;

279: l_end_date DATE;
280: l_log_string VARCHAR2(2000);
281: BEGIN
282: l_err_loc := 100;
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284:
285: l_err_loc := 200;
286: -- Standard Start of API savepoint
287: SAVEPOINT popValidCatgSetUpdate_sp;

Line 304: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

300: END IF;
301:
302: l_err_loc := 400;
303: -- Standard call to check for call compatibility.
304: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
305: p_api_version ,
306: l_api_name ,
307: G_PKG_NAME )
308: THEN

Line 310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

306: l_api_name ,
307: G_PKG_NAME )
308: THEN
309: l_err_loc := 500;
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312:
313: l_err_loc := 600;
314: --Initialize the purchasing category set info.

Line 339: IF FND_API.To_Boolean( p_commit ) THEN

335: ICX_CAT_POPULATE_CATG_PVT.populateValidCategorySetUpdate(P_OLD_CATEGORY_ID, P_NEW_CATEGORY_ID);
336:
337: l_err_loc := 1100;
338: -- Standard check of p_commit
339: IF FND_API.To_Boolean( p_commit ) THEN
340: l_err_loc := 1200;
341: COMMIT;
342: l_err_loc := 1300;
343: -- Call the rebuild index

Line 379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

375: || SQLERRM);
376: END IF;
377: NULL;
378: END;
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: END populateValidCategorySetUpdate;
381:
382: -- Called from inventory category forms / html interface for the following actions:
383: -- 1. A category is deleted from valid cat sets

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

384: -- Note: These informations are provided by Inventory team in 2005
385: -- 1. No bulk operations (i.e loading data from an interface table) allowed on valid cat sets
386: PROCEDURE populateValidCategorySetDelete
387: ( p_api_version IN NUMBER ,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
389: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
390: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
391: x_return_status OUT NOCOPY VARCHAR2 ,
392: p_category_set_id IN NUMBER ,

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

385: -- 1. No bulk operations (i.e loading data from an interface table) allowed on valid cat sets
386: PROCEDURE populateValidCategorySetDelete
387: ( p_api_version IN NUMBER ,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
389: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
390: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
391: x_return_status OUT NOCOPY VARCHAR2 ,
392: p_category_set_id IN NUMBER ,
393: p_category_id IN NUMBER

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

386: PROCEDURE populateValidCategorySetDelete
387: ( p_api_version IN NUMBER ,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
389: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
390: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
391: x_return_status OUT NOCOPY VARCHAR2 ,
392: p_category_set_id IN NUMBER ,
393: p_category_id IN NUMBER
394: )

Line 404: x_return_status := FND_API.G_RET_STS_SUCCESS;

400: l_end_date DATE;
401: l_log_string VARCHAR2(2000);
402: BEGIN
403: l_err_loc := 100;
404: x_return_status := FND_API.G_RET_STS_SUCCESS;
405:
406: l_err_loc := 200;
407: -- Standard Start of API savepoint
408: SAVEPOINT popValidCatgSetDelete_sp;

Line 424: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

420: END IF;
421:
422: l_err_loc := 400;
423: -- Standard call to check for call compatibility.
424: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
425: p_api_version ,
426: l_api_name ,
427: G_PKG_NAME )
428: THEN

Line 430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

426: l_api_name ,
427: G_PKG_NAME )
428: THEN
429: l_err_loc := 500;
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: END IF;
432:
433: l_err_loc := 600;
434: --Initialize the purchasing category set info.

Line 460: IF FND_API.To_Boolean( p_commit ) THEN

456: ICX_CAT_POPULATE_CATG_PVT.populateValidCategorySetDelete(P_CATEGORY_ID);
457:
458: l_err_loc := 1100;
459: -- Standard check of p_commit
460: IF FND_API.To_Boolean( p_commit ) THEN
461: l_err_loc := 1200;
462: COMMIT;
463: l_err_loc := 1300;
464: -- Call the rebuild index

Line 500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

496: || SQLERRM);
497: END IF;
498: NULL;
499: END;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: END populateValidCategorySetDelete;
502:
503: END ICX_CAT_POPULATE_CATG_GRP;