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 32: Mctx INV_ITEM_MSG.Msg_Ctx_type;

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

Line 99: INV_ITEM_MSG.Initialize;

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

Line 117: /INV_ITEM_MSG.Add_Error('INV_INVALID_ARG_NULL_VALUE');/

113: IF (( p_inventory_item_id IS NULL ) AND ( p_item_number IS NULL )) OR
114: ( p_element_name IS NULL )
115: THEN
116:
117: /*INV_ITEM_MSG.Add_Error('INV_INVALID_ARG_NULL_VALUE');*/
118: --YJAIN
119: --Bug 14068499
120: INV_ITEM_MSG.Add_Message
121: ( p_Msg_Name => 'INV_INVALID_ARG_NULL_VALUE'

Line 120: INV_ITEM_MSG.Add_Message

116:
117: /*INV_ITEM_MSG.Add_Error('INV_INVALID_ARG_NULL_VALUE');*/
118: --YJAIN
119: --Bug 14068499
120: INV_ITEM_MSG.Add_Message
121: ( p_Msg_Name => 'INV_INVALID_ARG_NULL_VALUE'
122: , p_transaction_id => p_transaction_id
123: );
124:

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

124:
125: RAISE FND_API.g_EXC_ERROR;
126: END IF;
127:
128: INV_ITEM_MSG.Debug(Mctx, 'Validate item');
129:
130: -- Validate item
131: INV_ITEM_MSG.Debug(Mctx, 'assign missing inventory_item_id');
132: l_inventory_item_id := p_inventory_item_id;

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

127:
128: INV_ITEM_MSG.Debug(Mctx, 'Validate item');
129:
130: -- Validate item
131: INV_ITEM_MSG.Debug(Mctx, 'assign missing inventory_item_id');
132: l_inventory_item_id := p_inventory_item_id;
133:
134: /** checking the validation level, to convert the item_number to item_id ***/
135: IF (p_validation_level IN (INV_ITEM_CATALOG_ELEM_PUB.g_VALIDATE_ALL,INV_ITEM_CATALOG_ELEM_PUB.g_VALIDATE_LEVEL_FULL)) THEN

Line 166: INV_ITEM_MSG.Add_Message

162: END IF;
163: IF (l_return_status = fnd_api.g_RET_STS_ERROR) THEN
164: --YJAIN
165: --Bug 14068499
166: INV_ITEM_MSG.Add_Message
167: ( p_Msg_Name => l_msg_name
168: , p_token1 => l_token
169: , p_value1 => l_token_value
170: , p_column_name => l_column_name

Line 186: INV_ITEM_MSG.Add_Message( p_Msg_Name => 'INV_ORGITEM_ID_NOT_FOUND'

182: FETCH org_item_exists_csr INTO l_org_id;
183: IF (org_item_exists_csr%NOTFOUND) THEN
184: CLOSE org_item_exists_csr;
185: --Bug 14068499
186: INV_ITEM_MSG.Add_Message( p_Msg_Name => 'INV_ORGITEM_ID_NOT_FOUND'
187: ,p_transaction_id => p_transaction_id);
188:
189: RAISE FND_API.g_EXC_ERROR;
190: END IF;

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

191: CLOSE org_item_exists_csr;
192:
193: --dbms_output.put_line('After OPEN org_item_exists_csr ; x_return_status = ' || x_return_status);
194:
195: INV_ITEM_MSG.Debug(Mctx, 'Validate catalog Group name');
196:
197: -- Validate catalog group name
198:
199: OPEN catalog_group_csr (l_inventory_item_id);

Line 206: INV_ITEM_MSG.Add_Message( p_Msg_Name => 'INV_CEOI_CAT_GRP_NOT_FOUND'

202: IF (catalog_group_csr%NOTFOUND) THEN
203: CLOSE catalog_group_csr;
204: --YJAIN
205: --Bug 14068499
206: INV_ITEM_MSG.Add_Message( p_Msg_Name => 'INV_CEOI_CAT_GRP_NOT_FOUND'
207: ,p_transaction_id => p_transaction_id);
208:
209:
210: RAISE FND_API.g_EXC_ERROR;

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

210: RAISE FND_API.g_EXC_ERROR;
211: END IF;
212: CLOSE catalog_group_csr;
213:
214: INV_ITEM_MSG.Debug(Mctx, 'Validate catalog Element name');
215: -- Validate catalog element name
216:
217: OPEN catalog_group_element_csr (p_element_name,l_inventory_item_id);
218: FETCH catalog_group_element_csr INTO l_element_name;

Line 223: INV_ITEM_MSG.Add_Message

219:
220: IF (catalog_group_element_csr%NOTFOUND) THEN
221: CLOSE catalog_group_element_csr;
222: --Bug 14068499
223: INV_ITEM_MSG.Add_Message
224: ( p_Msg_Name => 'INV_CEOI_CAT_GRP_ELE_NOT_FOUND'
225: , p_token1 => 'ELEMENT_NAME'
226: , p_value1 => p_element_name
227: , p_transaction_id => p_transaction_id

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

230: RAISE FND_API.g_EXC_ERROR;
231: END IF;
232: CLOSE catalog_group_element_csr;
233:
234: INV_ITEM_MSG.Debug(Mctx, 'Validate catalog Element value');
235: -- Validate catalog element value length
236:
237: IF (length(p_element_value) > G_ELEM_VAL_LENGTH) THEN
238: --YJAIN

Line 240: INV_ITEM_MSG.Add_Message

236:
237: IF (length(p_element_value) > G_ELEM_VAL_LENGTH) THEN
238: --YJAIN
239: --Bug 14068499
240: INV_ITEM_MSG.Add_Message
241: ( p_Msg_Name =>'INV_CEOI_CAT_GRP_ELE_VAL_LEN_M'
242: , p_token1 => 'ELEMENT_NAME'
243: , p_value1 => p_element_name
244: , p_transaction_id => p_transaction_id );

Line 269: INV_ITEM_MSG.Add_Error

265: ELSE
266: l_item_number := p_item_number;
267: END IF;
268:
269: INV_ITEM_MSG.Add_Error
270: ( p_Msg_Name =>'INV_IOI_ITEM_UPDATE_PRIV'
271: , p_token => 'VALUE'
272: , p_value => l_item_number );
273: RAISE FND_API.g_EXC_ERROR;

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

274: END IF;
275:
276: -- Update the production table
277:
278: INV_ITEM_MSG.Debug(Mctx, 'begin UPDATE mtl_descr_element_values');
279:
280: UPDATE mtl_descr_element_values
281: SET
282: element_value = p_element_value

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

292: inventory_item_id = l_inventory_item_id
293: AND element_name = p_element_name;
294:
295:
296: INV_ITEM_MSG.Debug(Mctx, 'end UPDATE mtl_descr_element_values');
297:
298: -- Standard check of p_commit
299: IF (FND_API.To_Boolean (p_commit)) THEN
300:

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

297:
298: -- Standard check of p_commit
299: IF (FND_API.To_Boolean (p_commit)) THEN
300:
301: INV_ITEM_MSG.Debug(Mctx, 'before COMMIT WORK');
302: COMMIT WORK;
303: END IF;
304:
305: INV_ITEM_MSG.Count_And_Get

Line 305: INV_ITEM_MSG.Count_And_Get

301: INV_ITEM_MSG.Debug(Mctx, 'before COMMIT WORK');
302: COMMIT WORK;
303: END IF;
304:
305: INV_ITEM_MSG.Count_And_Get
306: ( p_count => x_msg_count
307: , p_data => x_msg_data
308: );
309: -- Write all accumulated messages

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

306: ( p_count => x_msg_count
307: , p_data => x_msg_data
308: );
309: -- Write all accumulated messages
310: INV_ITEM_MSG.Write_List (p_delete => TRUE);
311:
312: EXCEPTION
313:
314: WHEN FND_API.g_EXC_ERROR THEN

Line 318: INV_ITEM_MSG.Count_And_Get

314: WHEN FND_API.g_EXC_ERROR THEN
315: ROLLBACK TO Catalog_Grp_Ele_Val_Assign_PVT;
316:
317: x_return_status := FND_API.g_RET_STS_ERROR;
318: INV_ITEM_MSG.Count_And_Get
319: ( p_count => x_msg_count
320: , p_data => x_msg_data
321: );
322:

Line 327: INV_ITEM_MSG.Count_And_Get

323: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
324: ROLLBACK TO Catalog_Grp_Ele_Val_Assign_PVT;
325:
326: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
327: INV_ITEM_MSG.Count_And_Get
328: ( p_count => x_msg_count
329: , p_data => x_msg_data
330: );
331:

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

332: WHEN others THEN
333: ROLLBACK TO Catalog_Grp_Ele_Val_Assign_PVT;
334:
335: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
336: INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);
337:
338: INV_ITEM_MSG.Count_And_Get
339: ( p_count => x_msg_count
340: , p_data => x_msg_data

Line 338: INV_ITEM_MSG.Count_And_Get

334:
335: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
336: INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);
337:
338: INV_ITEM_MSG.Count_And_Get
339: ( p_count => x_msg_count
340: , p_data => x_msg_data
341: );
342: