APPS.GMI_ITEM_PUB dependencies on DUAL

Line 179: SELECT gem5_item_id_s.nextval INTO l_item_id FROM dual;

175: END IF;
176: -- If no errors were found then proceed with the item create
177:
178: -- First get the surrogate key (item_id) for the item
179: SELECT gem5_item_id_s.nextval INTO l_item_id FROM dual;
180: IF (l_item_id <=0)
181: THEN
182: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
183: FND_MESSAGE.SET_TOKEN('SKEY','item_id');

Line 211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;

207: l_ic_item_mst_rec.item_desc2 := p_item_rec.item_desc2;
208: l_ic_item_mst_rec.alt_itema := UPPER(p_item_rec.alt_itema);
209: l_ic_item_mst_rec.alt_itemb := UPPER(p_item_rec.alt_itemb);
210: l_ic_item_mst_rec.item_um := l_item_um;
211: l_ic_item_mst_rec.dualum_ind := p_item_rec.dualum_ind;
212: l_ic_item_mst_rec.item_um2 := l_item_um2;
213: l_ic_item_mst_rec.deviation_lo := p_item_rec.deviation_lo;
214: l_ic_item_mst_rec.deviation_hi := p_item_rec.deviation_hi;
215: l_ic_item_mst_rec.level_code := p_item_rec.level_code;

Line 311: -- dbms_output.put_line('dualum_ind '||'!'||p_item_rec.dualum_ind||'!');

307: -- dbms_output.put_line('item_desc2 '||'!'||p_item_rec.item_desc2||'!');
308: -- dbms_output.put_line('alt_itema '||'!'||UPPER(p_item_rec.alt_itema)||'!');
309: -- dbms_output.put_line('alt_itemb '||'!'||UPPER(p_item_rec.alt_itemb)||'!');
310: -- dbms_output.put_line('item_um '||'!'||l_item_um||'!');
311: -- dbms_output.put_line('dualum_ind '||'!'||p_item_rec.dualum_ind||'!');
312: -- dbms_output.put_line('item_um2 '||'!'||l_item_um2||'!');
313: -- dbms_output.put_line('deviation_lo '||'!'||p_item_rec.deviation_lo||'!');
314: -- dbms_output.put_line('deviation_hi '||'!'||p_item_rec.deviation_hi||'!');
315: -- dbms_output.put_line('level_code '||'!'||p_item_rec.level_code||'!');

Line 611: -- Dual unit of measure indicator

607: FND_MSG_PUB.Add;
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: -- Dual unit of measure indicator
612: IF NOT GMI_VALID_GRP.Validate_dualum_ind(p_item_rec.dualum_ind)
613: THEN
614: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DUALUM_IND');
615: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

Line 612: IF NOT GMI_VALID_GRP.Validate_dualum_ind(p_item_rec.dualum_ind)

608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: -- Dual unit of measure indicator
612: IF NOT GMI_VALID_GRP.Validate_dualum_ind(p_item_rec.dualum_ind)
613: THEN
614: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DUALUM_IND');
615: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
616: FND_MSG_PUB.Add;

Line 614: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DUALUM_IND');

610:
611: -- Dual unit of measure indicator
612: IF NOT GMI_VALID_GRP.Validate_dualum_ind(p_item_rec.dualum_ind)
613: THEN
614: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DUALUM_IND');
615: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
616: FND_MSG_PUB.Add;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;

Line 622: IF NOT GMI_VALID_GRP.Validate_item_um2(p_item_rec.dualum_ind,l_item_um2)

618: END IF;
619:
620: -- Secondary Unit of Measure
621:
622: IF NOT GMI_VALID_GRP.Validate_item_um2(p_item_rec.dualum_ind,l_item_um2)
623: THEN
624: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
625: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
626: FND_MESSAGE.SET_TOKEN('UOM',l_item_um2);

Line 632: IF NOT GMI_VALID_GRP.Validate_deviation ( p_item_rec.dualum_ind

628: RAISE FND_API.G_EXC_ERROR;
629: END IF;
630:
631: -- Deviation factor lo
632: IF NOT GMI_VALID_GRP.Validate_deviation ( p_item_rec.dualum_ind
633: , p_item_rec.deviation_lo
634: )
635:
636: THEN

Line 644: IF NOT GMI_VALID_GRP.Validate_deviation ( p_item_rec.dualum_ind

640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642:
643: -- Deviation factor hi
644: IF NOT GMI_VALID_GRP.Validate_deviation ( p_item_rec.dualum_ind
645: , p_item_rec.deviation_hi
646: )
647: THEN
648: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DEVIATION');