APPS.PO_GML_DB_COMMON dependencies on FND_PROFILE

Line 211: l_location := fnd_profile.value('IC$DEFAULT_LOCT');

207:
208:
209: --get location code
210: IF (plocator_id IS NULL) THEN
211: l_location := fnd_profile.value('IC$DEFAULT_LOCT');
212:
213: ELSE
214: BEGIN
215: select location INTO l_location

Line 692: IF (NVL(fnd_profile.value('GML_VAL_RET_CORR_LOT_QTY'), 'Y') = 'N') AND

688: then find ic_tran_pnd record for rcv_lots_interface for receipt and copy the quantitiy.
689:
690: If anything does not match do Nothing */
691:
692: IF (NVL(fnd_profile.value('GML_VAL_RET_CORR_LOT_QTY'), 'Y') = 'N') AND
693: (l_trx_type = 'RETURN TO VENDOR' or l_trx_type = 'RETURN TO RECEIVING') THEN
694: -- Now check for receipt_qty matching Return_qty
695: OPEN Cur_Receipt_qty;
696: FETCH Cur_Receipt_qty INTO l_recv_qty, l_receipt_um;

Line 833: l_location := fnd_profile.value('IC$DEFAULT_LOCT');

829: x_return_status := '-30';
830: raise ex_exception_found;
831: END;
832:
833: l_location := fnd_profile.value('IC$DEFAULT_LOCT');
834:
835: --2491449 Preetam Bamb added check for item location control
836: --send location to the inventory API only if both the item and the
837: --warehouse are location controlled.Else send the default location populated above.