DBA Data[Home] [Help]

APPS.GMI_QUANTITY_PVT dependencies on IC_WHSE_MST

Line 94: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;

90: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
91: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
92: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;
93: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
94: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;
95: l_ic_loct_inv_rec_from ic_loct_inv%ROWTYPE;
96: l_ic_loct_inv_rec_to ic_loct_inv%ROWTYPE;
97: l_sy_reas_cds_rec sy_reas_cds%ROWTYPE;
98: l_lot_rec GMI_LOTS_PUB.lot_rec_typ;

Line 580: , x_ic_whse_mst => l_ic_whse_mst_rec

576: -- Validate 'from' warehouse code (not applicable for change QC Grade)
577: IF (l_trans_type <> 5)
578: THEN
579: GMI_GLOBAL_GRP.Get_Warehouse ( p_whse_code => l_trans_rec.from_whse_code
580: , x_ic_whse_mst => l_ic_whse_mst_rec
581: );
582: IF (l_ic_whse_mst_rec.whse_code = ' ') OR
583: (l_ic_whse_mst_rec.delete_mark = 1)
584: THEN

Line 582: IF (l_ic_whse_mst_rec.whse_code = ' ') OR

578: THEN
579: GMI_GLOBAL_GRP.Get_Warehouse ( p_whse_code => l_trans_rec.from_whse_code
580: , x_ic_whse_mst => l_ic_whse_mst_rec
581: );
582: IF (l_ic_whse_mst_rec.whse_code = ' ') OR
583: (l_ic_whse_mst_rec.delete_mark = 1)
584: THEN
585: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
586: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_trans_rec.from_whse_code);

Line 583: (l_ic_whse_mst_rec.delete_mark = 1)

579: GMI_GLOBAL_GRP.Get_Warehouse ( p_whse_code => l_trans_rec.from_whse_code
580: , x_ic_whse_mst => l_ic_whse_mst_rec
581: );
582: IF (l_ic_whse_mst_rec.whse_code = ' ') OR
583: (l_ic_whse_mst_rec.delete_mark = 1)
584: THEN
585: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
586: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_trans_rec.from_whse_code);
587: FND_MSG_PUB.Add;

Line 593: , p_whse_loct_ctl => l_ic_whse_mst_rec.loct_ctl

589: ELSE
590: -- Check location parameters
591: IF NOT GMI_VALID_GRP.Validate_Location
592: ( p_item_loct_ctl => l_ic_item_mst_rec.loct_ctl
593: , p_whse_loct_ctl => l_ic_whse_mst_rec.loct_ctl
594: , p_whse_code => l_trans_rec.from_whse_code
595: , p_location => l_trans_rec.from_location
596: )
597: THEN

Line 620: , x_ic_whse_mst => l_ic_whse_mst_rec

616: -- If move inventory transaction then validate 'to' warehouse code
617: IF (l_trans_type = 3)
618: THEN
619: GMI_GLOBAL_GRP.Get_Warehouse ( p_whse_code =>l_trans_rec.to_whse_code
620: , x_ic_whse_mst => l_ic_whse_mst_rec
621: );
622: IF (l_ic_whse_mst_rec.whse_code = ' ') OR
623: (l_ic_whse_mst_rec.delete_mark = 1)
624: THEN

Line 622: IF (l_ic_whse_mst_rec.whse_code = ' ') OR

618: THEN
619: GMI_GLOBAL_GRP.Get_Warehouse ( p_whse_code =>l_trans_rec.to_whse_code
620: , x_ic_whse_mst => l_ic_whse_mst_rec
621: );
622: IF (l_ic_whse_mst_rec.whse_code = ' ') OR
623: (l_ic_whse_mst_rec.delete_mark = 1)
624: THEN
625: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
626: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_trans_rec.to_whse_code);

Line 623: (l_ic_whse_mst_rec.delete_mark = 1)

619: GMI_GLOBAL_GRP.Get_Warehouse ( p_whse_code =>l_trans_rec.to_whse_code
620: , x_ic_whse_mst => l_ic_whse_mst_rec
621: );
622: IF (l_ic_whse_mst_rec.whse_code = ' ') OR
623: (l_ic_whse_mst_rec.delete_mark = 1)
624: THEN
625: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
626: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_trans_rec.to_whse_code);
627: FND_MSG_PUB.Add;

Line 633: , p_whse_loct_ctl => l_ic_whse_mst_rec.loct_ctl

629: ELSE
630: -- Check location parameters
631: IF NOT GMI_VALID_GRP.Validate_Location
632: ( p_item_loct_ctl => l_ic_item_mst_rec.loct_ctl
633: , p_whse_loct_ctl => l_ic_whse_mst_rec.loct_ctl
634: , p_whse_code => l_trans_rec.to_whse_code
635: , p_location => l_trans_rec.to_location
636: )
637: THEN

Line 1391: , p_whse_code IN ic_whse_mst.whse_code%TYPE

1387: --+=========================================================================+
1388: FUNCTION Check_unposted_jnl_lot_status
1389: ( p_item_id IN ic_item_mst.item_id%TYPE
1390: , p_lot_id IN ic_lots_mst.lot_id%TYPE
1391: , p_whse_code IN ic_whse_mst.whse_code%TYPE
1392: , p_location IN ic_loct_mst.location%TYPE
1393: , p_lot_status IN ic_lots_sts.lot_status%TYPE
1394: )
1395: RETURN BOOLEAN