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 GMIVDBL

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 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 108: IF GMIVDBL.ic_item_cpg_insert(x_ic_item_cpg_row, x_ic_item_cpg_row)

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
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 262: IF GMIVDBL.ic_lots_mst_insert(x_ic_lots_mst_row, x_ic_lots_mst_row)

258: IF x_return_status = FND_API.G_RET_STS_SUCCESS
259: THEN
260: /* If no errors were found then proceed with the database inserts */
261:
262: IF GMIVDBL.ic_lots_mst_insert(x_ic_lots_mst_row, x_ic_lots_mst_row)
263: THEN
264: -- Jatinder - B3158806 - Removed SY$CPG_INSTALL check
265: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;
266: IF GMIVDBL.ic_lots_cpg_insert(x_ic_lots_cpg_row, x_ic_lots_cpg_row)

Line 266: IF GMIVDBL.ic_lots_cpg_insert(x_ic_lots_cpg_row, x_ic_lots_cpg_row)

262: IF GMIVDBL.ic_lots_mst_insert(x_ic_lots_mst_row, x_ic_lots_mst_row)
263: THEN
264: -- Jatinder - B3158806 - Removed SY$CPG_INSTALL check
265: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;
266: IF GMIVDBL.ic_lots_cpg_insert(x_ic_lots_cpg_row, x_ic_lots_cpg_row)
267: THEN
268: NULL;
269: ELSE
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 796: IF GMIVDBL.ic_jrnl_mst_insert(x_ic_jrnl_mst_row, x_ic_jrnl_mst_row) THEN

792: FND_MESSAGE.SET_TOKEN('ORGN_CODE',p_qty_rec.orgn_code);
793: FND_MSG_PUB.Add;
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: IF GMIVDBL.ic_jrnl_mst_insert(x_ic_jrnl_mst_row, x_ic_jrnl_mst_row) THEN
797: x_return_status := FND_API.G_RET_STS_SUCCESS;
798: x_ic_adjs_jnl_row1.journal_id := x_ic_jrnl_mst_row.journal_id;
799: --Jalaj Srivastava Bug 2483656
800: IF ( (l_assign_type = 2)

Line 813: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1) THEN

809: OPEN get_doc_line;
810: FETCH get_doc_line INTO x_ic_adjs_jnl_row1.doc_line;
811: CLOSE get_doc_line;
812:
813: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1) THEN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN
816: GMIVQTY.construct_txn_rec
817: (x_ic_adjs_jnl_row1, l_tran_rec);

Line 839: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2) THEN

835: IF substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD') THEN
836: x_ic_adjs_jnl_row2.doc_id := x_ic_adjs_jnl_row1.doc_id;
837: x_ic_adjs_jnl_row2.journal_id := x_ic_adjs_jnl_row1.journal_id;
838: x_ic_adjs_jnl_row2.doc_line := x_ic_adjs_jnl_row1.doc_line + 1;
839: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2) THEN
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN
842: GMIVQTY.construct_txn_rec
843: (x_ic_adjs_jnl_row2, l_tran_rec);

Line 890: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)

886:
887: END IF;--}
888:
889: END IF; --(substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')
890: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
893: END IF; --substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD')
894: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)

Line 892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)

888:
889: END IF; --(substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')
890: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
893: END IF; --substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD')
894: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)

Line 894: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)

890: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
893: END IF; --substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD')
894: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)
897: ELSE --GMIVDBL.ic_jrnl_mst_insert(x_ic_jrnl_mst_row, x_ic_jrnl_mst_row)
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 896: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)

892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
893: END IF; --substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD')
894: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)
897: ELSE --GMIVDBL.ic_jrnl_mst_insert(x_ic_jrnl_mst_row, x_ic_jrnl_mst_row)
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: END IF;
900: END IF;

Line 897: ELSE --GMIVDBL.ic_jrnl_mst_insert(x_ic_jrnl_mst_row, x_ic_jrnl_mst_row)

893: END IF; --substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD')
894: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)
897: ELSE --GMIVDBL.ic_jrnl_mst_insert(x_ic_jrnl_mst_row, x_ic_jrnl_mst_row)
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: END IF;
900: END IF;
901: