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.INV_ITEM_CATALOG_ELE_PVT dependencies on INV_ITEM_MSG

Line 31: Mctx INV_ITEM_MSG.Msg_Ctx_type;

27: )
28: IS
29: l_api_name CONSTANT VARCHAR2(30) := 'Catalog_Grp_Ele_Val_Assignment';
30: l_api_version CONSTANT NUMBER := 1.0;
31: Mctx INV_ITEM_MSG.Msg_Ctx_type;
32:
33: l_element_name VARCHAR2(200);
34: l_exists VARCHAR2(1);
35: l_inventory_item_id NUMBER;

Line 98: INV_ITEM_MSG.Initialize;

94: --dbms_output.put_line('Before Initialize message list.');
95:
96: -- Initialize message list
97: IF (FND_API.To_Boolean (p_init_msg_list)) THEN
98: INV_ITEM_MSG.Initialize;
99: END IF;
100:
101: -- Define message context
102: Mctx.Package_Name := G_PKG_NAME;

Line 115: INV_ITEM_MSG.Add_Error('INV_INVALID_ARG_NULL_VALUE');

111:
112: IF (( p_inventory_item_id IS NULL ) AND ( p_item_number IS NULL )) OR
113: ( p_element_name IS NULL )
114: THEN
115: INV_ITEM_MSG.Add_Error('INV_INVALID_ARG_NULL_VALUE');
116: RAISE FND_API.g_EXC_ERROR;
117: END IF;
118:
119: INV_ITEM_MSG.Debug(Mctx, 'Validate item');

Line 119: INV_ITEM_MSG.Debug(Mctx, 'Validate item');

115: INV_ITEM_MSG.Add_Error('INV_INVALID_ARG_NULL_VALUE');
116: RAISE FND_API.g_EXC_ERROR;
117: END IF;
118:
119: INV_ITEM_MSG.Debug(Mctx, 'Validate item');
120:
121: -- Validate item
122: INV_ITEM_MSG.Debug(Mctx, 'assign missing inventory_item_id');
123: l_inventory_item_id := p_inventory_item_id;

Line 122: INV_ITEM_MSG.Debug(Mctx, 'assign missing inventory_item_id');

118:
119: INV_ITEM_MSG.Debug(Mctx, 'Validate item');
120:
121: -- Validate item
122: INV_ITEM_MSG.Debug(Mctx, 'assign missing inventory_item_id');
123: l_inventory_item_id := p_inventory_item_id;
124:
125: /** checking the validation level, to convert the item_number to item_id ***/
126: IF (p_validation_level IN (INV_ITEM_CATALOG_ELEM_PUB.g_VALIDATE_ALL,INV_ITEM_CATALOG_ELEM_PUB.g_VALIDATE_LEVEL_FULL)) THEN

Line 155: INV_ITEM_MSG.Add_Message

151: END IF;
152:
153: END IF;
154: IF (l_return_status = fnd_api.g_RET_STS_ERROR) THEN
155: INV_ITEM_MSG.Add_Message
156: ( p_Msg_Name => l_msg_name
157: , p_token1 => l_token
158: , p_value1 => l_token_value
159: , p_column_name => l_column_name

Line 172: INV_ITEM_MSG.Add_Error('INV_ORGITEM_ID_NOT_FOUND');

168: OPEN org_item_exists_csr (l_inventory_item_id);
169: FETCH org_item_exists_csr INTO l_org_id;
170: IF (org_item_exists_csr%NOTFOUND) THEN
171: CLOSE org_item_exists_csr;
172: INV_ITEM_MSG.Add_Error('INV_ORGITEM_ID_NOT_FOUND');
173: RAISE FND_API.g_EXC_ERROR;
174: END IF;
175: CLOSE org_item_exists_csr;
176:

Line 179: INV_ITEM_MSG.Debug(Mctx, 'Validate catalog Group name');

175: CLOSE org_item_exists_csr;
176:
177: --dbms_output.put_line('After OPEN org_item_exists_csr ; x_return_status = ' || x_return_status);
178:
179: INV_ITEM_MSG.Debug(Mctx, 'Validate catalog Group name');
180:
181: -- Validate catalog group name
182:
183: OPEN catalog_group_csr (l_inventory_item_id);

Line 188: INV_ITEM_MSG.Add_Error('INV_CEOI_CAT_GRP_NOT_FOUND');

184: FETCH catalog_group_csr INTO l_grp_id;
185:
186: IF (catalog_group_csr%NOTFOUND) THEN
187: CLOSE catalog_group_csr;
188: INV_ITEM_MSG.Add_Error('INV_CEOI_CAT_GRP_NOT_FOUND');
189: RAISE FND_API.g_EXC_ERROR;
190: END IF;
191: CLOSE catalog_group_csr;
192:

Line 193: INV_ITEM_MSG.Debug(Mctx, 'Validate catalog Element name');

189: RAISE FND_API.g_EXC_ERROR;
190: END IF;
191: CLOSE catalog_group_csr;
192:
193: INV_ITEM_MSG.Debug(Mctx, 'Validate catalog Element name');
194: -- Validate catalog element name
195:
196: OPEN catalog_group_element_csr (p_element_name,l_inventory_item_id);
197: FETCH catalog_group_element_csr INTO l_element_name;

Line 201: INV_ITEM_MSG.Add_Error

197: FETCH catalog_group_element_csr INTO l_element_name;
198:
199: IF (catalog_group_element_csr%NOTFOUND) THEN
200: CLOSE catalog_group_element_csr;
201: INV_ITEM_MSG.Add_Error
202: ( p_Msg_Name =>'INV_CEOI_CAT_GRP_ELE_NOT_FOUND'
203: , p_token => 'ELEMENT_NAME'
204: , p_value => p_element_name );
205: RAISE FND_API.g_EXC_ERROR;

Line 209: INV_ITEM_MSG.Debug(Mctx, 'Validate catalog Element value');

205: RAISE FND_API.g_EXC_ERROR;
206: END IF;
207: CLOSE catalog_group_element_csr;
208:
209: INV_ITEM_MSG.Debug(Mctx, 'Validate catalog Element value');
210: -- Validate catalog element value length
211:
212: IF (length(p_element_value) > G_ELEM_VAL_LENGTH) THEN
213: INV_ITEM_MSG.Add_Error

Line 213: INV_ITEM_MSG.Add_Error

209: INV_ITEM_MSG.Debug(Mctx, 'Validate catalog Element value');
210: -- Validate catalog element value length
211:
212: IF (length(p_element_value) > G_ELEM_VAL_LENGTH) THEN
213: INV_ITEM_MSG.Add_Error
214: ( p_Msg_Name =>'INV_CEOI_CAT_GRP_ELE_VAL_LEN_M'
215: , p_token => 'ELEMENT_NAME'
216: , p_value => p_element_name );
217: RAISE FND_API.g_EXC_ERROR;

Line 240: INV_ITEM_MSG.Add_Error

236: ELSE
237: l_item_number := p_item_number;
238: END IF;
239:
240: INV_ITEM_MSG.Add_Error
241: ( p_Msg_Name =>'INV_IOI_ITEM_UPDATE_PRIV'
242: , p_token => 'VALUE'
243: , p_value => l_item_number );
244: RAISE FND_API.g_EXC_ERROR;

Line 249: INV_ITEM_MSG.Debug(Mctx, 'begin UPDATE mtl_descr_element_values');

245: END IF;
246:
247: -- Update the production table
248:
249: INV_ITEM_MSG.Debug(Mctx, 'begin UPDATE mtl_descr_element_values');
250:
251: UPDATE mtl_descr_element_values
252: SET
253: element_value = p_element_value

Line 267: INV_ITEM_MSG.Debug(Mctx, 'end UPDATE mtl_descr_element_values');

263: inventory_item_id = l_inventory_item_id
264: AND element_name = p_element_name;
265:
266:
267: INV_ITEM_MSG.Debug(Mctx, 'end UPDATE mtl_descr_element_values');
268:
269: -- Standard check of p_commit
270: IF (FND_API.To_Boolean (p_commit)) THEN
271:

Line 272: INV_ITEM_MSG.Debug(Mctx, 'before COMMIT WORK');

268:
269: -- Standard check of p_commit
270: IF (FND_API.To_Boolean (p_commit)) THEN
271:
272: INV_ITEM_MSG.Debug(Mctx, 'before COMMIT WORK');
273: COMMIT WORK;
274: END IF;
275:
276: INV_ITEM_MSG.Count_And_Get

Line 276: INV_ITEM_MSG.Count_And_Get

272: INV_ITEM_MSG.Debug(Mctx, 'before COMMIT WORK');
273: COMMIT WORK;
274: END IF;
275:
276: INV_ITEM_MSG.Count_And_Get
277: ( p_count => x_msg_count
278: , p_data => x_msg_data
279: );
280: -- Write all accumulated messages

Line 281: INV_ITEM_MSG.Write_List (p_delete => TRUE);

277: ( p_count => x_msg_count
278: , p_data => x_msg_data
279: );
280: -- Write all accumulated messages
281: INV_ITEM_MSG.Write_List (p_delete => TRUE);
282:
283: EXCEPTION
284:
285: WHEN FND_API.g_EXC_ERROR THEN

Line 289: INV_ITEM_MSG.Count_And_Get

285: WHEN FND_API.g_EXC_ERROR THEN
286: ROLLBACK TO Catalog_Grp_Ele_Val_Assign_PVT;
287:
288: x_return_status := FND_API.g_RET_STS_ERROR;
289: INV_ITEM_MSG.Count_And_Get
290: ( p_count => x_msg_count
291: , p_data => x_msg_data
292: );
293:

Line 298: INV_ITEM_MSG.Count_And_Get

294: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
295: ROLLBACK TO Catalog_Grp_Ele_Val_Assign_PVT;
296:
297: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
298: INV_ITEM_MSG.Count_And_Get
299: ( p_count => x_msg_count
300: , p_data => x_msg_data
301: );
302:

Line 307: INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);

303: WHEN others THEN
304: ROLLBACK TO Catalog_Grp_Ele_Val_Assign_PVT;
305:
306: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
307: INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);
308:
309: INV_ITEM_MSG.Count_And_Get
310: ( p_count => x_msg_count
311: , p_data => x_msg_data

Line 309: INV_ITEM_MSG.Count_And_Get

305:
306: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
307: INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);
308:
309: INV_ITEM_MSG.Count_And_Get
310: ( p_count => x_msg_count
311: , p_data => x_msg_data
312: );
313: