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.GMIGAPI dependencies on IC_ITEM_MST

Line 26: | x_ic_item_mst_row OUT ic_item_mst%ROWTYPE - The ic_item_mst row |

22: | p_init_msg_list IN VARCHAR2 - Message Initialization Ind. |
23: | p_commit IN VARCHAR2 - Commit Indicator |
24: | p_validation_level IN VARCHAR2 - Validation Level Indicator |
25: | p_item_rec IN item_rec_typ - Item details |
26: | x_ic_item_mst_row OUT ic_item_mst%ROWTYPE - The ic_item_mst row |
27: | x_ic_item_cpg_row OUT ic_item_cpg%ROWTYPE - The ic_item_cpg row |
28: | x_return_status OUT VARCHAR2 - Return Status |
29: | x_msg_count OUT NUMBER - Number of messages |
30: | x_msg_data OUT VARCHAR2 - Messages in encoded format |

Line 39: | ic_item_mst_insert and Create_Lot if they occur |

35: | HISTORY |
36: | 13-May-00 P.J.Schofield Major restructuring for performance reasons |
37: | B1294915. |
38: | 18-Oct-02 A. Cataldo - Bug 2513463 - Need to handle problems with |
39: | ic_item_mst_insert and Create_Lot if they occur |
40: +==========================================================================+
41: */
42:
43: PROCEDURE Create_Item

Line 49: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE

45: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
46: , p_commit IN VARCHAR2 := FND_API.G_FALSE
47: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
48: , p_item_rec IN GMIGAPI.item_rec_typ
49: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE
50: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
51: , x_return_status OUT NOCOPY VARCHAR2
52: , x_msg_count OUT NOCOPY NUMBER
53: , x_msg_data OUT NOCOPY VARCHAR2

Line 83: , x_ic_item_mst_row => x_ic_item_mst_row

79: GMIVITM.Validate_Item
80: ( p_api_version => p_api_version
81: , p_validation_level => p_validation_level
82: , p_item_rec => p_item_rec
83: , x_ic_item_mst_row => x_ic_item_mst_row
84: , x_ic_item_cpg_row => x_ic_item_cpg_row
85: , x_return_status => x_return_status
86: , x_msg_count => x_msg_count
87: , x_msg_data => x_msg_data

Line 95: IF GMIVDBL.ic_item_mst_insert(x_ic_item_mst_row, x_ic_item_mst_row)

91:
92: IF x_return_status = FND_API.G_RET_STS_SUCCESS
93: THEN
94: /* If no errors were found then proceed with the database inserts */
95: IF GMIVDBL.ic_item_mst_insert(x_ic_item_mst_row, x_ic_item_mst_row)
96: THEN
97: -- TKW 9/11/2003 B2378017
98: -- Moved call to gmi_item_categories from ic_item_mst_insert to here.
99: -- It is now called with new signature.

Line 98: -- Moved call to gmi_item_categories from ic_item_mst_insert to here.

94: /* If no errors were found then proceed with the database inserts */
95: IF GMIVDBL.ic_item_mst_insert(x_ic_item_mst_row, x_ic_item_mst_row)
96: THEN
97: -- TKW 9/11/2003 B2378017
98: -- Moved call to gmi_item_categories from ic_item_mst_insert to here.
99: -- It is now called with new signature.
100: GMIVDBL.gmi_item_categories(p_item_rec, x_ic_item_mst_row);
101:
102: -- Jatinder - B3158806 - removed the check for the CPG install and

Line 100: GMIVDBL.gmi_item_categories(p_item_rec, x_ic_item_mst_row);

96: THEN
97: -- TKW 9/11/2003 B2378017
98: -- Moved call to gmi_item_categories from ic_item_mst_insert to here.
99: -- It is now called with new signature.
100: GMIVDBL.gmi_item_categories(p_item_rec, x_ic_item_mst_row);
101:
102: -- Jatinder - B3158806 - removed the check for the CPG install and
103: -- added check for lot_ctl instead
104: IF x_ic_item_mst_row.lot_ctl = 1

Line 104: IF x_ic_item_mst_row.lot_ctl = 1

100: GMIVDBL.gmi_item_categories(p_item_rec, x_ic_item_mst_row);
101:
102: -- Jatinder - B3158806 - removed the check for the CPG install and
103: -- added check for lot_ctl instead
104: IF x_ic_item_mst_row.lot_ctl = 1
105: THEN
106: /* ic_item_mst created OK. Copy the allocated item_id. */
107: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;
108: IF GMIVDBL.ic_item_cpg_insert(x_ic_item_cpg_row, x_ic_item_cpg_row)

Line 106: /* ic_item_mst created OK. Copy the allocated item_id. */

102: -- Jatinder - B3158806 - removed the check for the CPG install and
103: -- added check for lot_ctl instead
104: IF x_ic_item_mst_row.lot_ctl = 1
105: THEN
106: /* ic_item_mst created OK. Copy the allocated item_id. */
107: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;
108: IF GMIVDBL.ic_item_cpg_insert(x_ic_item_cpg_row, x_ic_item_cpg_row)
109: THEN
110: NULL;

Line 107: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;

103: -- added check for lot_ctl instead
104: IF x_ic_item_mst_row.lot_ctl = 1
105: THEN
106: /* ic_item_mst created OK. Copy the allocated item_id. */
107: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;
108: IF GMIVDBL.ic_item_cpg_insert(x_ic_item_cpg_row, x_ic_item_cpg_row)
109: THEN
110: NULL;
111: ELSE

Line 129: , p_ic_item_mst_row => x_ic_item_mst_row

125: , p_init_msg_list => FND_API.G_FALSE
126: , p_commit => FND_API.G_FALSE
127: , p_validation_level=> FND_API.G_VALID_LEVEL_NONE
128: , p_lot_rec => l_lot_rec
129: , p_ic_item_mst_row => x_ic_item_mst_row
130: , p_ic_item_cpg_row => x_ic_item_cpg_row
131: , x_ic_lots_mst_row => l_ic_lots_mst_row
132: , x_ic_lots_cpg_row => l_ic_lots_cpg_row
133: , x_return_status => x_return_status

Line 216: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE

212: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
213: , p_commit IN VARCHAR2 := FND_API.G_FALSE
214: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
215: , p_lot_rec IN lot_rec_typ
216: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
217: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
218: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
219: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
220: , x_return_status OUT NOCOPY VARCHAR2

Line 248: , p_ic_item_mst_row => p_ic_item_mst_row

244: GMIVLOT.Validate_Lot
245: ( p_api_version => p_api_version
246: , p_validation_level => p_validation_level
247: , p_lot_rec => p_lot_rec
248: , p_ic_item_mst_row => p_ic_item_mst_row
249: , p_ic_item_cpg_row => p_ic_item_cpg_row
250: , x_ic_lots_mst_row => x_ic_lots_mst_row
251: , x_ic_lots_cpg_row => x_ic_lots_cpg_row
252: , x_return_status => x_return_status

Line 354: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE

350: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
351: , p_commit IN VARCHAR2 := FND_API.G_FALSE
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

Line 385: , p_ic_item_mst_row => p_ic_item_mst_row

381: GMIVILC.Validate_Lot_Conversion
382: ( p_api_version => p_api_version
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

Line 467: | p_ic_item_mst_row IN ic_item_mst%ROWTYPE |

463: | p_init_msg_list IN VARCHAR2 - Message Initialization Ind. |
464: | p_commit IN VARCHAR2 - Commit Indicator |
465: | p_validation_level IN VARCHAR2 - Validation Level Indicator |
466: | p_qty_rec IN GMIGAPI.qty_rec_typ - Quantity details |
467: | p_ic_item_mst_row IN ic_item_mst%ROWTYPE |
468: | p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE |
469: | p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE |
470: | p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE |
471: | x_ic_jrnl_mst_row OUT ic_jrnl_mst%ROWTYPE |

Line 518: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE

514: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
515: , p_commit IN VARCHAR2 := FND_API.G_FALSE
516: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
517: , p_qty_rec IN GMIGAPI.qty_rec_typ
518: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
519: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
520: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
521: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
522: , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE

Line 603: , p_ic_item_mst_row => p_ic_item_mst_row

599: GMIVQTY.Validate_Inventory_Posting
600: ( p_api_version => p_api_version
601: , p_validation_level => p_validation_level
602: , p_qty_rec => p_qty_rec
603: , p_ic_item_mst_row => p_ic_item_mst_row
604: , p_ic_item_cpg_row => p_ic_item_cpg_row
605: , p_ic_lots_mst_row => p_ic_lots_mst_row
606: , p_ic_lots_cpg_row => p_ic_lots_cpg_row
607: , x_ic_jrnl_mst_row => x_ic_jrnl_mst_row

Line 624: IF p_ic_item_mst_row.lot_ctl = 0

620: /* follows. */
621:
622: IF x_ic_adjs_jnl_row1.trans_type IN ('CREI','CRER')
623: THEN
624: IF p_ic_item_mst_row.lot_ctl = 0
625: THEN
626: l_ic_lots_mst_row.lot_id := 0;
627: l_ic_lots_mst_row.lot_no := GMIGUTL.IC$DEFAULT_LOT;
628: x_ic_adjs_jnl_row1.lot_id := l_ic_lots_mst_row.lot_id;

Line 631: IF p_ic_item_mst_row.sublot_ctl = 1

627: l_ic_lots_mst_row.lot_no := GMIGUTL.IC$DEFAULT_LOT;
628: x_ic_adjs_jnl_row1.lot_id := l_ic_lots_mst_row.lot_id;
629: ELSE
630: l_lot_rec.lot_no := p_qty_rec.lot_no;
631: IF p_ic_item_mst_row.sublot_ctl = 1
632: THEN
633: l_lot_rec.sublot_no := p_qty_rec.sublot_no;
634: END IF;
635:

Line 639: ( p_ic_item_mst_row.item_id

635:
636: /* Make sure we aren't trying to create a lot which exists already. */
637:
638: GMIGUTL.get_lot
639: ( p_ic_item_mst_row.item_id
640: , p_qty_rec.lot_no
641: , p_qty_rec.sublot_no
642: , l_ic_lots_mst_row
643: , l_ic_lots_cpg_row

Line 653: , p_ic_item_mst_row => p_ic_item_mst_row

649: , p_init_msg_list => FND_API.G_FALSE
650: , p_commit => FND_API.G_FALSE
651: , p_validation_level=> FND_API.G_VALID_LEVEL_FULL
652: , p_lot_rec => l_lot_rec
653: , p_ic_item_mst_row => p_ic_item_mst_row
654: , p_ic_item_cpg_row => p_ic_item_cpg_row
655: , x_ic_lots_mst_row => l_ic_lots_mst_row
656: , x_ic_lots_cpg_row => l_ic_lots_cpg_row
657: , x_return_status => x_return_status

Line 671: IF p_ic_item_mst_row.lot_ctl = 0

667: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669: END IF;
670: ELSE
671: IF p_ic_item_mst_row.lot_ctl = 0
672: THEN
673: l_ic_lots_mst_row.lot_id := 0;
674: l_ic_lots_mst_row.lot_no := GMIGUTL.IC$DEFAULT_LOT;
675: x_ic_adjs_jnl_row1.lot_id := l_ic_lots_mst_row.lot_id;

Line 685: IF ( (p_ic_item_mst_row.lot_ctl = 1)

681: If it is a move immediate, check if moving allocations is
682: required/permitted. It is applicable only for lot controlled items.
683: ********************************************************************* */
684: --{
685: IF ( (p_ic_item_mst_row.lot_ctl = 1)
686: AND ( (p_ic_item_mst_row.status_ctl = 0)
687: OR (fnd_profile.value('IC$MOVEDIFFSTAT') IN (0,2))
688: )
689: AND (x_ic_adjs_jnl_row1.trans_type = 'TRNI')

Line 686: AND ( (p_ic_item_mst_row.status_ctl = 0)

682: required/permitted. It is applicable only for lot controlled items.
683: ********************************************************************* */
684: --{
685: IF ( (p_ic_item_mst_row.lot_ctl = 1)
686: AND ( (p_ic_item_mst_row.status_ctl = 0)
687: OR (fnd_profile.value('IC$MOVEDIFFSTAT') IN (0,2))
688: )
689: AND (x_ic_adjs_jnl_row1.trans_type = 'TRNI')
690: AND (fnd_profile.value('IC$MOVEALLOC') = 1)

Line 934: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_ic_item_mst_row.item_no);

930: FND_MESSAGE.SET_TOKEN('DOC_LINE_TO', x_ic_adjs_jnl_row2.doc_line);
931: END IF;
932: FND_MESSAGE.SET_TOKEN('JOURNAL_NO', x_ic_jrnl_mst_row.journal_no);
933: FND_MESSAGE.SET_TOKEN('ORGN_CODE', x_ic_adjs_jnl_row1.orgn_code);
934: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_ic_item_mst_row.item_no);
935: FND_MESSAGE.SET_TOKEN('LOT_NO',p_ic_lots_mst_row.lot_no);
936: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_ic_lots_mst_row.sublot_no);
937: FND_MSG_PUB.Add;
938:

Line 984: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE

980: , p_init_msg_list IN VARCHAR2
981: , p_commit IN VARCHAR2
982: , p_validation_level IN NUMBER
983: , p_xfer_rec IN GMIGAPI.xfer_rec_typ
984: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
985: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
986: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
987: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
988: , p_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE