DBA Data[Home] [Help]

APPS.GMIGAPI dependencies on IC_ITEM_CNV

Line 329: | x_ic_item_cnv_row OUT ic_item_cnv%ROWTYPE |

325: | p_init_msg_list IN VARCHAR2 - Message Initialization Ind. |
326: | p_commit IN VARCHAR2 - Commit Indicator |
327: | p_validation_level IN VARCHAR2 - Validation Level Indicator |
328: | p_conv_rec IN GMIGAPI.lot_rec_typ - Conversion details |
329: | x_ic_item_cnv_row OUT ic_item_cnv%ROWTYPE |
330: | x_return_status OUT VARCHAR2 - Return Status |
331: | x_msg_count OUT NUMBER - Number of messages |
332: | x_msg_data OUT VARCHAR2 - Messages in encoded format |
333: | |

Line 356: , x_ic_item_cnv_row OUT NOCOPY ic_item_cnv%ROWTYPE

352: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
353: , p_conv_rec IN GMIGAPI.conv_rec_typ
354: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
355: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
356: , x_ic_item_cnv_row OUT NOCOPY ic_item_cnv%ROWTYPE
357: , x_return_status OUT NOCOPY VARCHAR2
358: , x_msg_count OUT NOCOPY NUMBER
359: , x_msg_data OUT NOCOPY VARCHAR2
360: )

Line 387: , x_ic_item_cnv_row => x_ic_item_cnv_row

383: , p_validation_level => p_validation_level
384: , p_item_cnv_rec => p_conv_rec
385: , p_ic_item_mst_row => p_ic_item_mst_row
386: , p_ic_lots_mst_row => p_ic_lots_mst_row
387: , x_ic_item_cnv_row => x_ic_item_cnv_row
388: , x_return_status => x_return_status
389: , x_msg_count => x_msg_count
390: , x_msg_data => x_msg_data
391: );

Line 399: IF GMIVDBL.ic_item_cnv_insert(x_ic_item_cnv_row, x_ic_item_cnv_row)

395: THEN
396: /* If no errors were found then proceed with the database insert */
397: /* Bug 1741321 */
398: /* Set token for uom type to be displayed in the success message */
399: IF GMIVDBL.ic_item_cnv_insert(x_ic_item_cnv_row, x_ic_item_cnv_row)
400: THEN
401:
402: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
403: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_conv_rec.item_no);

Line 406: FND_MESSAGE.SET_TOKEN('UM_TYPE', x_ic_item_cnv_row.um_type);

402: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
403: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_conv_rec.item_no);
404: FND_MESSAGE.SET_TOKEN('LOT_NO', p_conv_rec.lot_no);
405: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_conv_rec.sublot_no);
406: FND_MESSAGE.SET_TOKEN('UM_TYPE', x_ic_item_cnv_row.um_type);
407: FND_MSG_PUB.Add;
408:
409: IF FND_API.to_boolean(p_commit)
410: THEN

Line 422: FND_MESSAGE.SET_TOKEN('UM_TYPE', x_ic_item_cnv_row.um_type);

418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
419: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_conv_rec.item_no);
420: FND_MESSAGE.SET_TOKEN('LOT_NO', p_conv_rec.lot_no);
421: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_conv_rec.sublot_no);
422: FND_MESSAGE.SET_TOKEN('UM_TYPE', x_ic_item_cnv_row.um_type);
423: FND_MSG_PUB.Add;
424: ELSE
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;